Enhanced Balance Sheet with groups

Banana Accounting automatically calculates, displays, and prints the Balance Sheet and the Profit and Lost account. These are two fundamental financial documents used by businesses to monitor and report their financial and operational activities.

The Balance Sheet and the Profit and Lost account can be customized both based on the period and the columns to be displayed. Balance Sheets can be generated for monthly, quarterly, semi-annual, and annual periods. Additionally, when selecting a period (e.g., semi-annual), the data can be further broken down by periods (month, quarter).

The Balance sheet with groups differs from the Balance sheet for the following characteristics:

  • Displays the subgroups in detail.
  • Offers the possibility to exclude groups or accounts (for instance, to display only the total of the group and not the accounts of which the total is composed).
  • In the Chart of accounts →Sections it is possible to select which accounts to include or leave out from the printouts
  • It is possible to sort by a given period (for example in the first semester, you can choose whether to obtain the data by month or by quarter)
  • It is possible to have a subdivision by segment.

In order to calculate, display and print the Enhanced Balance sheet by groups, click on Reports → Enhanced balance sheet with groups command from the menu: a window appears, with different sections that allow the user to define the print setup.

Enhanced balance sheet with groups

 

Features:

See also Print Examples.

FAQ

  • If I exclude the groups with a zero balance, the title rows that refer to the excluded groups are still being displayed; how can I erase them?
    Go to Sections and activate Hide current row on the title rows that you wish to exclude.
  • I would like to exclude the display of the period in the titles of the printouts ("1st Semester 2013"); how can I do that?
    Go to the Headers section and deactivate the Print period option.
  • On the cover page, when there are long titles, I would like to be able to choose how to subdivide the texts into two rows and wish to apply bold print. Is this possible?
    It is not possible to change the fonts on the cover page.
  • Some amounts are not included in the indicated period. Why?
    Transactions without a date are counted as openings and do not appear in the printouts of the Profit & Loss statement. Be sure to enter the date into all the transactions.
  • The total groups that contain all the accounts of the classes 3 and 4 are being renamed with the text Profit or Loss, depending on the result of the accounting period. How can I change that text?
    Go to the Sections and overwrite the original text in the Alternate text zone of the active row.
  • How can I display the data of the previous year if it is longer than the standard year?
    In the "Enhanced Balance Sheet by groups" dialogue box, under the heading "Columns", for the "Income Statement" section, click on the "Advanced" button, in the "Columns" window click on "Add". At this point, activate the "Prior" option in the "Print Columns" window. Then close all windows by pressing the "ok" button. You can customize the header of the columns in the "Columns" window, by clicking on the "properties" button, if necessary.

 

Headers

In the Page → Headers section are the options for heading the pages and the logo when printing the Financial Statements and Income Statement.

Enhanced Balance sheet with groups

Header 1, Header 2, Header 3, Header 4
Enter as headers the text you wish appearing in the printouts. The headings inserted are shown on the first page (cover page) and on each sheet as main headings.

Logo
It is possible to insert the logo in the header of all pages of the report.
If one or more logos have been added in the menu File→Logo Setup, you can select one from the list.
If no logo has been added, the Edit button can be used to add the logo.

Print period and/or subdivision
This option is active only when a specific period has been defined. When you deactivate this option, the period will not be indicated in the titles of the printouts.

Footer

Print page numbers
By activating this function, page numbers will be printed.

Print date
By activating this function the date will be printed.

Cover page

Print cover page
By activating this function the cover page will be printed.

Logo:
It is possible to insert the logo in the header of all pages of the report.
If one or more logos have been added in the menu File→Logo Setup, you can select one from the list.
If no logo has been added, the Edit button can be used to add the logo.

 

 

Layout

In the Page → Layout section you set the font size and the page orientation for printing the Balance Sheet and Income Statement.

Enhanced Balance sheet with groups, layout

Font size
The display of the printout varies according to the entered value.

Page orientation
You can select the page orientation: automatic, landscape and portrait.

 

Logo

Via the File → Logo setup  command  it is possible to include a logo and to define its settings (width, height, position). It is also possible to create and save Customizations with different logo settings.
This feature is a simpler alternative to the logo setting with the Documents Table.

Enhanced Balance sheet with groups, logo

To activate the logo option when printing the Financial Statements and Income Statement, it is necessary to select Logo, instead of none.
For the Logo option to be visible, you need to have set up your logo in the File → Logo Setup menu.

 

Margins

In the Page → Margins section you set the margins for printing the Balance Sheet and Income Statement.

Enhanced Balance sheet with groups, margins

Top, Bottom, Left, Right
It's the distance between the page border and the content.

Header
Is the distance between the page header and the content.

Footer
Is the distance between the page footer and the content.

Increase margins to printable area
If the content exceeds the page margins it will be automatically adjusted to fit the printable area.
 

Sections

The Section section shows how the chart of accounts is structured and subdivided.
The structure is set up using the Section column in the Chart of accounts.

It allows you to set: 

  • Items to be printed together. 
  • Page changes. 
  • Items to be excluded from the print.

Enhanced Balance Sheet with groups, sections

As on Accounts table

The display and the printout settings of the Enhanced Balance Sheet with groups, are the same as in the Accounts table.

By clicking on the arrow on the left you can display the components of the section. Normally only groups with a balance are displayed. To also display the groups with zero balance, go to the Rows section and click on view groups with zero balances.


Depending on the selection, there are different sections with different options:

  • Sections 1, 2, 3, 4, 01, 02, 03, 04... refer to the main items of the Balance Sheet
  • Account sections refer to the selected account
  • Group sections refer to the selected group

Section*
If you select a section with an asterisk, you will have the following options:

Hide section
Click on the section that you wish to hide.

Hide current row
Click on the row that you wish to hide.

Start on new page
Click on the header that you want to have on a new page and activate the option.

Alternative text
Enter an alternative text if you want to have a different one for the selected section or row.

If you select a number or a group section (1, 2, 3, 4.....), there are extra options:

alternative text in Enhanced Balance sheet with groups

Group for % calculation (%)
Is visible when you select a section (assets, liabilities, costs, income ....).
It is the group that serves as the basis for calculating the percentage of the section accounts and groups.

  • Determined by the software. 
    The group is established by the program. As a rule, it is the last group in the section (total assets, liabilities, costs and income).
  • Group indicated by the user.
    For the income statement, a group must be indicated (for example, total sales).


Hide child rows
If you select a group and you activate this function, child rows of this group won't be printed in the Enhanced Balance Sheet.

Show as account
If you select a group and you activate this function, the group will be displayed as an account in the Balance sheet. Enhanced balance sheet with groups - Section - Group for percent calculation

External accounting report

Print the Enhanced Balance Sheet by groups, based on the structure of the Accounting report file.

Enhanced balance sheet with groups, external report

Report File
You can select the file of the External Accounting report with the Browse button.

Grouping column
Column in which the accounts refer to the groups defined in the External Accounting report. Available columns: Gr1, Gr2, Gr, BClasse and GrVat.

Signal missing grouping
Checks whether all accounts belong to a group in the External Accounting report.

 

Rows

In the Chart of Accounts → Rows section you can choose to print the following elements: Accounts, Accounts with zero balance, Accounts with transactions, Groups with zero balance, Empty rows.Enhanced balance sheet with groups, rows

 

 

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.

 

Subdivision

Via the Chart of Accounts section → Subdivision you can access the options to choose the subdivision of the period (year, semester, quarter, month).

Enhanced balance sheet with groups, subdivision period

None
Only the data for the overall period are present in print.

Subdivision by period

With the breakdown by period, the program creates columns for the indicated periods. For each period you will see the same columns for the overall period.

The function allows you to view the data of the period for:

  • day
  • month
  • bi-monthly
  • quarter
  • four monthly
  • semester
  • year
  • 5 years
  • 10 years.

The selected period appears in the column header.

In order not to have an excessive number of columns in print:

  • Limit the number of items you want to print.
  • Indicate a shorter period.
  • Indicate the maximum number of periods.

Enhanced balance sheet with groups, subdivision period

 

Create periods for the entire year
When the accounting period does not coincide with the calendar year, but you want to view all the months anyway, simply activate this function. 

Totals column
This function creates a Totals column of the selected periods in the income statement and in the Totals view.

Maximum number of divisions
The maximum number of periods is by default 36. In particular cases, if you want particular statistics that are very detailed and over long periods, you can manually change this value. A very high maximum number of periods can slow down the program.

 Subdivision by Segment

The segments allow you to have reports for a certain section of the company. Segments are defined in the Chart of accounts. With the breakdown by period, the program creates columns for the different segments. For each segment you will see the same columns for the overall period.

Each subdivision takes the name of the header given in the Chart of accounts. The split data (based on your selection) is displayed.

The Subdivision by Segment option is active only if segments have been set up in the Accounts table.

You can select:

  • All segments - This way, when new segments are added, they will be automatically added to the printout.
  • Blank - The amount not assigned to any segment is displayed.
  • Choice of segments - Indicate only the segments you want to see in print.

Enhanced balance sheet with groups, segments

Totals column
When this option is being checked, the totals for the selected segment will be obtained.

Segment header
You can choose the text to be displayed as column header for the segments.

 

Period

In the Chart of accounts → Period section, you can limit the processing of data, display and print only to an indicated period or, in the case of a budget, it allows you to obtain forecasts over several years.

Enhanced balance sheet with groups, period

All

All accounting entries are included.

Period selected

It means the specified period, indicating the start and end date.

In order to get forecasts over several years, it is necessary to enter the end date of the future year of the budget required, in the File Properties, basic data (File menu). Enter the start and end date of the period in the Period section of the Enhanced balance sheet with groups as well.
To have budgets beyond the accounting period, in the Budget table, the movements must have a repetition code.
The forecast will be displayed in the Budget column.

Movements without date

If transactions without dates have been entered in the accounting, they are considered only if All is selected.
If, on the other hand, you enter, for example, from January 1st to December 31st, the transactions without date are not displayed in the report.

 

Style Tab

This dialog section includes the option to choose the templates and the number format for printing the Balance Sheet and Income Statement. Each template can be customized by changing the style properties and colors. Columns can also be customized in the Columns section.

Enhanced balance sheet with groups, style

Use style
There are different models of the Enhanced balance sheet provided. By selecting one, the user can obtain the Enhanced balance sheet of his choice. 

Style property
For each style, the color of the fonts and the backgrounds can be defined. 

Value / Change... / Default
These functions allow the user to change style or to restore the default style. 

Ignore line formatting
If this function is activated, the formatting will not be maintained.

 

Number formats

In the Style section you can change the number formats and the display type for negative numbers.

Enhanced balance sheet with groups, numbers format

Divide by 1'000
If there are big amounts, by activating this option, three zeros will be taken off.

Show cents
By activating this option the cents will be shown.

Show zero amounts
By activating this option it is possible to choose between having the zero amounts shown with the 0,00 number or with the -,- symbol.

Negative numbers
Negative amounts can be shown with a minus sign before the amount, after the amount or the amount can be shown between parenthesis. You can also activate the option to have the negative numbers shown in red.

 

Texts

Via the Style → Texts section you can change the texts of the fixed headers that the program uses in the printouts.

To change the value, just double click on the Value cell corresponding to the key to be changed and enter the new text.

Enhanced balance sheet with groups, texts

 

Attachments

Via the Attachments section you can add texts to be printed together with the report.

  • Texts are printed after the Balance sheet and Profit & Loss statement.
  • Each document begins on a new page

balance sheet attachments

Documents

All documents listed in the Documents table (Html or text format) are listed here.

  • You can change the report sequence, just by dragging the item with your mouse
  • All documents with a check mark will be printed.

Edit

A text editor will open allowing you to enter new text or edit the existing one.

Add

Adds a new element without text.
To add plain text or Markdown documents, use the appropriate commands in the Documents table

Remove

This button will remove the selected element and its content. It's the same as removing a row from the Document table.

Add an attachment with Markdown text

  • Add a new document with Markdown text as explained on page Markdown Editor
  • Check the attachments list for the document with Markdown text.

editor Markdown

Notes

  • Printing of Markdown text is only available with the Advanced plan subscription.
  • This feature is not available in previous versions.
    If the file is open with a previous version of the Banana Accounting software, you will get a message that the file is not totally compatible.
  • If you edit this section and you press OK, in order to undo the operation you need to enter the Undo command more that once.