Double entry columns setup

The Chart of accounts > Columns section contains the most important options for customizing the columns to be displayed and printed in the Financial Statements and in the Income Statement and Notes.

Enhanced Balance sheet with groups, columns

Balance Sheet, Profit and Loss Statement and Notes

If the various options are activated, the following data will be included in the display and printing of the reports:

Account number
In addition to the account description, the account numbers are also included.

Current
The balance or movement in the basic currency, referring to the selected period or to the subdivision of the period.

% of row
Includes the column with the percentage referred to the total (e.g.% total assets).
The total group to base the percentage calculation on can be set in the Sections tab.
The group is set by the program, but especially for the Income Statement, it is not always determined ideally, so it must be set manually.

Foreign currency
This option is only visible in a multi-currency file.
By activating the option in the printout, the balance will also be displayed in foreign currency for the selected period or the subdivision of the period.

Opening
The opening balance for the period.

Budget
The amount of the budget, referring to the selected period or the subdivision of the period:

  • If the Budget table has not been set up, the amount in the Budget column of the Chart of accounts is indicated.
    The total amount of each account is divided over 12 months.
  • If the Budget table has been set up, the budget amount of the accounts is calculated based on the transactions entered in the Budget table.

Previous period
The amount for the period prior to the selected period or period split.

Previous year
The amount for the same period of the previous year.

Difference
Is the difference between the amount of the current period and that of the other column (Budget, Previous period, previous year).

% Difference
Is the difference between the amount of the current period and that of the other column (Budget, Previous period, previous year).

Year-to-date
The balance or movement from the beginning of the accounting to the date of the last posting.

Advanced

With the Advanced button you can further customize the arrangement, texts and colors of the columns.

Hide/Show.
You can hide or display a column that is indicated in the list.

Change sequence
Use the Move Up and Move Down buttons or drag the column with the mouse.

Add new column
You can include other columns from the Accounts table or one of the columns calculated by the report in the report.

Remove the column from the list
With the Delete button the column is deleted. You can always add it again:

Special cases

Previous accounting year beyond the current accounting period

If the previous accounting year is longer than the normal duration of the current year (for example, it starts in November or December), the Previous column of the Accounts table is used to correctly display the totals of the income statement of the previous year, as otherwise, Banana accounting calculates the totals of the income statement taking the same duration as the current year and the totals will differ from what is displayed in the financial statements of the previous year.

In this case proceed as follows.

  • For the Income statement, deactivate the Previous year and Previous period columns
  • Click on Advanced ...
  • With the Add ... command, add the Columns table Accounts > Prior column
  • With the Properties ... command, enter the text to be displayed as the header for the Prior column
    • Row 1 > Text > "2021", "2022", ...
  • Confirm and display Enhanced Balance Sheet.

Columns (Advanced)

This dialog allows you to see the list of different columns as they appear in the report and to customize their column display, headers, and column content colors or background colors.

You can change the list of columns with the Add or Remove buttons:

  • Accounts table columns
    Complete list of columns in the Accounts table
  • Acounting amounts [A]
    List of columns calculated for the current accounting period. (A=Actual)
  • Budget amounts [B]
    List of columns calculated on the basis of data from the Budget table. (B=Budget)

Enhanced balance sheet with groups, columns, advanced

The following options are available:

  • Hide/Show columns
    With the check you can hide or make a column that is indicated in the list visible.
  • Change sequence.
    Use the Move Up and Move Down buttons or drag the column with the mouse.
  • Add new column
    You can include other columns from the Accounts table or one of the columns calculated by the report in the report.
  • Remove the column from the list
    With the Delete button the column is deleted. You can always add it again.
  • Change text or background colour.
  • Change the header or other properties of the column.

 

Columns - add

In the Balance sheet, Profit and Loss Statement and in the Notes, it is possible to add further columns.

Starting from the Reports menu → Enhanced Balance sheet with groupsColumns Advanced button → Add button.

Enhanced balance sheet with groups, add columns

Available columns list

The dialog lists all the columns that can be included in the report:

  • Columns present in the Accounts table.
  • Columns with Accounting amounts .
  • Columns with Budget amounts.

Activating the column from the list adds it to the report. In the Advanced dialog you can change the sequence and headings.

By removing the check, the column is removed from the report.

Columns present in the Accounts table

You can include any column of the Accounts table, for example:

  • Note.
  • Aditional description.
  • Description in another language.
  • Import or other columns added by you.

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
Only visible for multi-currency files. Account balances in foreign currency are also 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

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.  Also see informations on Budget.

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 budget amounts are displayed for the same period as the current one, but from the previous year.

Calculation period annotations

The program cannot calculate values for periods that overlap between different accounting years or for years with start and end dates that do not match.
To obtain balances from the previous year that exceed one calendar year, activate the Prior column. This column replaces the "Previous year" column, which only shows the previous year's balances from 01.01.xx to 31.12.xx.
You get to this column from the menu Reports → Enhanced balance sheet by groups → Columns → Advanced button → Add. Clicking on the Account table columns header will display the list of all the columns defined in the Accounts table. Activate the Prior column.

 

Headers and options (Columns properties)

In this section there are options to change the column headers in reports.

Enhanced balance sheet with groups, column 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.

 

Colors (Columns properties)

The dialog box is accessed via the Reports → Enhanced statement by groups → Columns → Advanced button → Properties → Colors menu. There are options to change the colors of the texts and columns.

Enhanced balance sheet with groups, change color

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.