Cashbook - Main Module
Find a file
2024-07-19 15:41:25 +02:00
docs remove logging, add config-settings for caching, add docs 2023-03-05 10:20:02 +01:00
icon book neu 2022-08-05 12:02:04 +02:00
locale Config: setting for booking-wizard - 'fixate' 2024-06-01 11:13:47 +02:00
report report ok, auf book und line 2022-08-17 17:16:23 +02:00
tests Config: setting for booking-wizard - 'fixate' 2024-06-01 11:13:47 +02:00
view Config: setting for booking-wizard - 'fixate' 2024-06-01 11:13:47 +02:00
.gitignore update gitignore 2024-07-19 15:33:50 +02:00
__init__.py add worker-based precalculation of cashbook-values 2023-12-27 15:49:02 +01:00
book.py cashbook: optimize for speed for checking rows 2023-12-29 22:55:41 +01:00
book.xml Tryton 7.0: ir.rule: Eval('user', ...) --> Eval('user_id', -1) 2023-11-30 13:18:14 +01:00
category.py formatting, indexes optimized 2023-11-29 15:19:38 +01:00
category.xml kategorie: constraint gegen gleiche Namen auf toplevel, 2022-08-28 12:24:25 +02:00
cbreport.py formatting, line: test for delete of party 2023-05-18 12:15:53 +02:00
cbreport.xml report ok, auf book und line 2022-08-17 17:16:23 +02:00
configuration.py Config: setting for booking-wizard - 'fixate' 2024-06-01 11:13:47 +02:00
configuration.xml report ok, auf book und line 2022-08-17 17:16:23 +02:00
const.py formatting, indexes optimized 2023-11-29 15:19:38 +01:00
COPYRIGHT add license 2023-12-31 11:20:00 +01:00
cron.py add worker-based precalculation of cashbook-values 2023-12-27 15:49:02 +01:00
cron.xml add worker-based precalculation of cashbook-values 2023-12-27 15:49:02 +01:00
currency.py add worker-based precalculation of cashbook-values 2023-12-27 15:49:02 +01:00
group.xml report ok, auf book und line 2022-08-17 17:16:23 +02:00
icon.xml book neu 2022-08-05 12:02:04 +02:00
ir.py Use 'irrulecontext' to add 'user_id' to context of ir.rule 2024-07-19 15:41:25 +02:00
LICENSE add license 2023-12-31 11:20:00 +01:00
line.py add worker-based precalculation of cashbook-values 2023-12-27 15:49:02 +01:00
line.xml Tryton 7.0: ir.rule: Eval('user', ...) --> Eval('user_id', -1) 2023-11-30 13:18:14 +01:00
MANIFEST.in add license 2023-12-31 11:20:00 +01:00
menu.xml menü: updt settings-icon 2023-02-10 19:04:06 +01:00
message.xml optimize searcher/sort, add search/sort to balance_ref 2023-12-29 14:51:39 +01:00
mixin.py add worker-based precalculation of cashbook-values 2023-12-27 15:49:02 +01:00
model.py remove caching 2023-12-23 10:36:58 +01:00
README.rst readme 2023-11-30 13:53:13 +01:00
reconciliation.py formatting, indexes optimized 2023-11-29 15:19:38 +01:00
reconciliation.xml Tryton 7.0: ir.rule: Eval('user', ...) --> Eval('user_id', -1) 2023-11-30 13:18:14 +01:00
setup.py Tryton 7.0 2023-11-30 13:28:00 +01:00
splitline.py add worker-based precalculation of cashbook-values 2023-12-27 15:49:02 +01:00
splitline.xml Tryton 7.0: ir.rule: Eval('user', ...) --> Eval('user_id', -1) 2023-11-30 13:18:14 +01:00
tryton.cfg Use 'irrulecontext' to add 'user_id' to context of ir.rule 2024-07-19 15:41:25 +02:00
types.py formatting, indexes optimized 2023-11-29 15:19:38 +01:00
types.xml report ok, auf book und line 2022-08-17 17:16:23 +02:00
valuestore.py re-calculate values @ module install 2024-01-20 18:09:03 +01:00
versiondep.txt Use 'irrulecontext' to add 'user_id' to context of ir.rule 2024-07-19 15:41:25 +02:00
wizard_booking.py Config: setting for booking-wizard - 'fixate' 2024-06-01 11:13:47 +02:00
wizard_booking.xml line: omit calculation of balance if credit/debit = None 2023-01-15 11:03:50 +01:00
wizard_openline.py formatting, line: test for delete of party 2023-05-18 12:15:53 +02:00
wizard_openline.xml line: omit calculation of balance if credit/debit = None 2023-01-15 11:03:50 +01:00
wizard_runreport.py optimize search-queries, line: fix state-selection 2023-07-24 17:31:34 +02:00
wizard_runreport.xml line: omit calculation of balance if credit/debit = None 2023-01-15 11:03:50 +01:00

mds-cashbook
============
Tryton module to add a cashbook.

Install
=======

pip install mds-cashbook

Requires
========
- Tryton 7.0

How to
======

This module adds a cash book to Tryton. Each Tryton user can have
any number of cash books. The cash books can be arranged hierarchically.
A cash book contains simple postings, such as expense, revenue, transfer,
split posting. Each booking has a category, an amount and possibly a description.
The cash books of the different Tryton users are separated from
each other by permissions. There is an enhancement module for the connection
to the chart of accounts and analytic.

This module adds new user groups:

Cashbook
    The user can make entries in his cash books.

Cashbook - WF - Check
    The user can mark his bookings as 'checked'

Cashbook - WF - Done
    The user can reconcile his cash books

Cashbook - Administrator
    the Cashbook-Administrator

There is a possibility to allow reading or editing for other users via
the Tryton user groups. This makes it possible to set up a administrator
for all cash books of the Tryton system.


Set up your cash book
---------------------

Add the Tryton user to the *Cashbook* group. In the tab *Owner and Authorizeds*,
enter the user as the owner. Enter *Type*, *Currency*, *Initial Date*
and *Line Numbering*. Cash books without a type cannot receive postings
and are treated as a view. You can create several cash books per user
and arrange them hierarchically.


Creating categories
-------------------

Each booking needs a category. The categories are separated by revenue and expense.
In the menu Cash Book / Configuration / Category you create some categories.


Using the chart of accounts
---------------------------

If you want to have the postings as a posting record in Tryton Accounting
install the *cashbook_account* module. For analytic, install *cashbook_analytic*.
In each of the cash books, add one account to the
chart of accounts, in tab *Account Configuration*.

In the categories you add a chart of accounts account in the
tab 'Account and Tax'. If you want to make your transactions with taxes,
you can also add one or more taxes.

Enter bookings
--------------

There are two ways to enter bookings.

1) The *Enter Booking* wizard. The wizard is optimized for use on
   small screens. You can write down expenses on the go with your smartphone.
   The type of bookings is limited to expense, revenue and transfers between cash books.
   When using the wizard, you should check the booking later and possibly complete it.

2) The record form of a cash book. This option offers all posting variants,
   such as expense, revenue, transfer to, transfer from, expense split posting
   and revenue split posting. When using chart of accounts and analytic,
   you also specify the taxes and analytic accounts here.


Processing states
-----------------

Postings in cash books have several workflow states.

Edit
    The entry has been created but not yet verified

Checked
    The user has checked his entry and has indicated this by clicking on 'Check'
    When using the chart of accounts modules, posting records are created here
    in the Draft state.

Reconciled
    A user (with enough permissions) has checked the entry against a
    bank statement. This step is performed in the 'Reconciliations' tab of a cash book.

Done
    The entry is committed. This step is performed by completing a
    reconciliation in the cash book. When using the chart of accounts modules,
    the posting records created in step 'Check' are committed.


Reconciliation
--------------

The bookings should be checked regularly against a bank statement. This is done
in the 'Reconciliations' tab of a cash book.

1) Click the plus button, don't change anything about the contents,
   click *ok*, save the cash book. The system will change the dates of the
   reconciliation so that all eligible bookings are taken into account.

2) If you want to change the end date, do so now. Save.

3) Open the reconciliation by double-clicking, click on *Check*.
   This will insert all posting lines into the list. The posting lines
   in the cash book are now protected against edit.

4) Now check line by line against an account statement. To remember what you
   have already seen, click the 'Reconciled' button.

5) When you're done, click the *Done* button of the reconciliation. This
   sets all posting lines and the reconciliation to *Done*.


Configuration
-------------

The configuration in the menu Cash Book / Configuration is a user-specific setting.
The user can choose which cash books appear in the *Enter Booking* dialog and
which default settings should apply when opening a cash book.


Foreign currencies
------------------

The cash books can be used with foreign currency. Base currency is the company currency.
For transfers between cash books with different currencies, the current conversion
rate in Tryton is used. You can adjust the exchange rate actually used in the booking dialog.
If you have hierarchical cash books, the amounts of subordinate cash books with foreign
currency are converted  into the display currency of the parent cash book.


Changes
=======

*7.0.0 - 30.11.2023*

- compatibility to Tryton 7.0