Enhanced Balance Sheet with groups
Print the Balance Sheet with your logo
In the new Banana Accounting Plus version, the Balance Sheet with groups printout has been improved with new customization possibilities. Among the new features, the possibility to insert your logo.
We advise you to immediately switch to Banana Accounting Plus and take advantage of the many new features.
The Balance sheet with groups differs from the Balance sheet for the following characteristics:
- Includes also subgroups in the printout, as in the chart of accounts (and not only groups).
- 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 in the printouts
- It is possible to choose, for a given period, what kind of subdivision you want (for example in the first semester, you can choose wether to obtain the data by month or by quarter)
- It is possible to have a subdivision by segment
- ... and much more!
In order to calculate, display and print the Enhanced Balance sheet by groups, click on the Enhanced balance sheet with groups command from the Account1 menu; a window appears, with different sections that allow the user to define the print setup.
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 it?
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 on two rows and whether I wish to apply bold print. Is it possible?
It is impossible to change the fonts on the cover page. - Some amounts are not included in the indicated period. Why?
Transactions without a date are being 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. Can I change that?
Go to the Sections and overwrite the original text in the Alternate text zone of the active row. - In case the Show previous year option is being activated, and in the previous year file there are groups that are no longer present in the current year, the program will give error messages. Can I do something about it?
In order to print the Balance sheet with data of the previous and the current year, the groups of the previous year have to also be present in the current year.
Headers
Header 1, Header 2, Header 3, Header 4
Enter as headers the text you wish appearing in the printouts. They will be on the cover page and on each page headings.
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.
Print cover page
By activating this function the cover page will be printed.
Layout
Zoom
The printout layout will change according to the entered value.
Page orientation
You can select the page orientation: automatic, landscape and portrait.
Margins
Top, Bottom, Left, Right
It's the distance between the page border and the content.
Header
It's the distance between the page header and the content.
Footer
It's 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
This section can vary depending on the settings of the Section column of the accounting plan - See the related document: Sections in the accounting plan
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.
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:
Group for % calculation (%)
This option is visible when selecting a section (Assets, Liabilities, ...). It is possible to indicate which group the % calculation should be based on.
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.
External accounting report
Print the Enhanced Balance Sheet by groups, based on the structure of the Accounting report file.
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
Accounts, accounts with zero balance, accounts with transactions, groups with zero balance, empty rows.
By activating the different options, you can include them in the printouts.
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.
Subdivision
From the Account1 menu choose the Enhanced Balance Sheet with groups command and select the Subdivision tab.
None
The whole period is shown.
Subdivision by period
This function makes it possible to display the dates of the selected period per day, month, bi-monthly, per quarter, per 4 months, per semester or per year. The selected period will be shown in the column headers.
Only segment
Only the data related to the selected segment are being shown.
Create periods for the whole year
When the accounting period is not the same as the solar year, but when the user still wants to see all months, this function needs to be activated.
Totals column
This function creates a Totals column for the selected periods in the Profit / Loss Statement and in the Totals view of the Accounting reports command (Account1 menu).
Max number of divisions
The default maximum number of periods is 36. In particular cases, if the user would want to obtain special and very detailed statistics over a long time span, this value can be changed manually. A very high maximum number of periods can slow down the program.
Subdivision by segment
The data related to the selected segment are being shown. This option is only available if segments have been set.
- Select all - all options will are selected
- Void - only the amount not assigned to any segment is shown
- Segments subdivision - Each subdivision will have the header given in the accounting plan. The data of the selected subdivision are shown.
Totals column
When this option is being activated, 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
Explanation on the Period tab are available at the following link:
https://www.banana.ch/doc8/en/node/2766
Style Tab
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
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
This tab is used to alter the texts of the program columns headers for print-outs.
In order to change the Value column you just have to double-click on the cell you want to edit.
Composition
Explanations on the Composition section are available at the following link:
http://doc8.banana.ch/en/node/2768
Attachments
This sections allows you to add text that will be printent with the Balance sheet and Profit & Loss statement.
- texts are printed after the Balance sheet and Profit & Loss statement.
- each document begins on a new page
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
This button will open a text editor where you can add new text.
If you haven't created the Documents table yet, the programm will automatically add it.
Remove
This button will remove the selected element and its content.
Notes
- 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 give the Undo command more that once.