Columns
Balance Sheet, Profit & Loss Statement and Notes
You can choose the options you wish to include in the Balance Sheet, in the Profit and Loss Statement and in the Notes:
- Account number
- Current: the balance or movement in basic currency referred to the selected period or period subdivision
- Foreign currency: the balance in the account currency referred to the selected period or period subdivision
- % of row: includes the column with the percentage referring to the total (for example, % total Assets)
- Opening: opening balance at the beginning of the period
- Budget: budget amount referred to the selected period or period subdivision
- Previous period: the amount of the period previous to the selected period or period subdivision
- Previous year: the amount of the same period in the previous year
- Difference: the difference between the amounts of the current period and the other column (Budget, Previous period, Previous year)
- % Difference: is the difference, expressed in percentage, between the current period and the other column (Budget, Previous period, Previous year)
- Year-to-date: the balance or movement from the beginning of the accounting until the date of the last transaction.
Headers editing, color or display change of the columns
Each section has the Advanced button from where it is possible to change the column's settings and options.
Columns (Advanced)
By pressing the Advanced button, it is possible to change the column's header:
- in order to make the column visible in the printout, check che corresponding checkbox
- in order to change the sequence of the columns, drag up or down the name of the column you wish to move, or use the Move Up and Move Down buttons
- In order to add new columns to be shown in the report (choosing them from a list) use the Add button
- In order to remove some columns from the list, use the Remove button
- In order to edit the display properties of a column (colors, headers, etc.) use the Properties button
Headers and options (Columns properties)
Headers
Row 1/ Row 2 / Row 3
It is possible to change the columns headers by selecting the Text option (from the drop down menu) and by entering the new header. If you select the Column option, the column name of the selected column will be shown.
Options
Visible
If this cell is activated, the column header will be shown.
Display as a total column
If activated, this option only shows the amounts in the Totals column.
Columns - add
Add / Delete
In the Balance sheet, Profit and Loss Statement and in the Notes, it is possible to add new columns (from the ones included in the list), or to delete the undesired ones. Starting from the Account1 menu -> Enhanced Balance sheet with groups -> Columns -> Advanced button -> Add button.
If one or more options are being activated, the program includes:
Accounts Table Columns
If you click on the header a list of all the columns of the Accounts Table will be shown:
You can then inlcude in the printout any column existing in the Accounts Table
Accounting amounts
These are the columns with the amounts calculated by the program, the opening balances and the entered transactions, for the indicated period or for the subdivision period
Amount in the Account currency
The account balances in foreign currencies will also be displayed.
Current
The balances of the current year will be displayed.
Opening
The Opening balances will be displayed.
Previous (period)
The balances of the previous period are being displayed (month, quarter, semester, etc).
Previous Year
The balances of the previous year are being displayed.
YTD (Year To Date)
This column is only available in the Profit & Loss Statement. The balances from the beginning of the year until the last transaction date are being displayed.
Budget amounts
See also Budget information. These are the columns with the amounts calculated by the program based on the budget amounts entered in the Accounts Table or in the Budget Table. If you created the Budget table and if some rows have been entered, the program will use the data of this table for its calculation, even if there are values in the Budget column of the Accounts Table.
Budget (Current period)
The amounts related to the foreseen budget of the current period are being displayed.
Budget Previous
The amounts related to the foreseen budget of the previous period are being displayed.
Budget Previous Year
The amounts related to the foreseen budget of the previous year are being displayed.
Notes on calculation period
The program cannot calculate amounts for periods overlapping between several accounting years or years with initial and final accounting dates that do not match.
Colors (Columns properties)
You can access this window by pressing on the Properties button, Colors tab (from the Enhanced balance sheet by groups command - Columns, from the Account1 menu)
Change
With this button you can change the text or the background color
Default color
With this button you can restore the default color for the text or the background.