In this article
In order to create automatically an Enhanced Balance Sheet with groups, the chart of accounts needs to be configured with special codes that are to be entered in the Section column:
* | Title 1 | the asterisk separates the sections and indicates the main headers |
** | Title 2 | to be entered for the secondary headers |
1 | Assets | to be entered in the row of the Assets title |
2 | Liabilities | to be entered in the row of the Liabilities title |
3 | Expenses | to be entered in the row of the Expenses title |
4 | Revenue | to be entered in the row of the Revenue title |
01 | Client's Register | to be entered in the row of the Client's Register title |
02 | Supplier's Register | to be entered in the row of the Supplier's Register title |
03 | Cost Centers | to be entered in the row of the Cost Centers title |
04 | Profit Centers | to be entered in the row of the Profit Centers title |
# | Notes | to be entered in the row of the Notes title |
#X | Hidden data |
to be entered in the row from whereon the data have to be hidden |
Sections in the Assets
- Enter a * on the same row as the Balance Sheet title
- Enter 1 on the same row as the Assets title
Sections in the Liabilities
- Enter 2 on the same row as the Liabilities title
Sections in the Profit & Loss Statement
- Enter a * on the same row as the Profit/Loss Statement title
- Enter 4 on the empty row below the Profit/Loss Statement title
Note: when there is a clear distintion between Revenue and Expenses in the Chart of accounts, you need to:
- Enter 3 on the same row as the Expenses title
- Enter 4 on the same row as the Revenue (Income) title .
Sections in the clients/suppliers register
- Enter * in the same row as the Clients/Suppliers register title or on a empty row (as in the following example)
- Enter 01 on the same row as the Clients register title
- Enter 02 on the same row as the Suppliers register title
The amounts will be shown in the same way as for the Assets and the Liabilities.
This encoding is also valid when the clients and suppliers are configured as cost centers.
In case there are cost or profit centers configured, enter the following elements
- An * on the row of the Costs and Profit Centers title, or on a empty row
- 03 on the same row as the Cost centers title or on an empty row preceeding the Cost Centers
- 04 on the same row as the Profit centers title or on an empty row preceeding the Profit Centers
The Cost Centers amounts will be shown as positive (in black) like the expenses; the Profit Centers amounts will be shown in negative (in red) like the revenue;
For more information please vist the Sections logic page
Related document: Enhanced Balance Sheet with groups