In this article
In order to create automatically a Balance Sheet by groups, the chart of accounts needs to be configured with special codes that are to be entered in the Section column.
The encoding is the following:
For more details please visit the Sections logic page
|
* |
Title 1 |
To enter for the main headers |
|
** |
Title 2 |
To enter for the secondary headers |
|
1 |
Assets |
To enter in the title row Assets |
|
2 |
Liabilities |
To enter in the title row Liabilities |
|
3 |
Expenses |
To enter in the title row Expenses |
|
4 |
Revenue |
To enter in the title row Revenue |
|
01 |
Client's Register |
To enter in the title row Client's Register |
|
02 |
Supplier's Register |
To enter in the title row Supplier's Register |
|
03 |
Cost Centers |
To enter in the title row Cost Centers |
|
04 |
Profit Centers |
To enter in the title row Profit Centers |
|
# |
Notes |
To enter in the title row Notes |
|
#X |
Hidden data |
To enter in the row from whereon the data have to be hidden |
- Enter a * on the same row as the title Balance Sheet
- Enter 1 on the same row as the title Assets
- Enter 2 on the same row as the title Liabilities
- Enter a * on the same row as the title Profit/Loss Statement
- Enter 3 on the same row as the title Expenses
- Enter 4 on the same row as the title Revenue (Income).
Attention: in case a chart of accounts with Expenses and Revenue mixed (with the calculation of the Gross Profit) is being used, insert a "*" on the title row "Profit/Loss Statement" and only the number 4 on the row preceding the row containing the title "Expenses" or "Revenue".
For the clients/suppliers register a new section is being defined, by entering an asterisk as usual.
- Enter 01 on the same row as the title Clients register
- Enter 02 on the same row as the title Suppliers register
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.
Example in case there is a clients/suppliers register in the chart of accounts.
In case there are cost or profit centers configured, enter the following elements
- An asterisk for the section change
- 03 on the same row as the title Cost center
- 03 on the same row as the title Profit center
The amounts will be shown as positive (in black) like the expenses and in red like the revenue.
