Printouts
All the printouts of the Financial Statements, the profit and loss Statement, and the various accounting Reports are available from the Reports menu. Each command has various options for customizing the various printouts.
To print the content of the tables, please refer to the Page setup section (last paragraph).
Enhanced Balance sheet with groups - colored columns
This example has been realized with the following features:
- Enhanced Balance sheet with groups.
- Columns setup to indicate which columns are to be displayed (in the example the columns of the Current and the Previous year are being displayed)
- Style: Lugano (Groups highlighted), Style properties: Groups and totals: Color.
Enhanced Balance sheet with budget
This example has been realized with the following features:
- Enhanced Balance sheet
- Options Include in print : to indicate which columns to display (in the example the Current, Estimate column is displayed).
- Style: Berlin, colored columns.
Enhanced Balance sheet
This example has been realized with the following features:
- Enhanced Balance sheet
- Options Include in print : to indicate which columns to display (in the example the Current, Previous,% Difference columns have been activated).
- Style: Berlin, colored columns.
Subdivision by semester
This example has been realized with the following features:
- Enhanced Balance sheet with groups.
- Columns setup to indicate which columns are to be displayed (Current and Budget).
- Subdivision -> Subdivision by period in order to set up the sub-divsion by period
- Style: Lugano (Groups highlighted), Style properties: Groups and totals: Color.
- Color column properties to color the columns differently.
Subdivision by segment
This example has been realized with the following features:
- Enhanced Balance sheet with groups
- Subdivision -> Subdivision by segment in order to choose the segment level to be displayed.
- Print style:
When printing the segments, it is not possible to set up the colors of the columns.
Pdf dossier with all the accounting data
The file is being created with a summary that provides access to the different printouts in an easy way.
The following data can be saved in Pdf
- Balance sheet and Profit & Loss statement
- Accounts table, Transactions, VAT Codes, Totals
- VAT reports
- Account cards
If you save this file on a non re-writable CD (to keep together with your accounting documents), this will comply with the legal requirements for archiving the accounting data.
This example has been realized with the following features:
File menu, Create Pdf dossier command
Printing an extra column
In order to print an extra column in the Balance sheet, the following features are used:
- Add a new column in the Accounts table, via the Data → Columns setup menu.
- Enhanced Balance sheet with groups
- Columns - advanced, to make the column visible.
Account cards - Ledger
The account card corresponds to the Ledger and allows you to have a comprehensive list of accounting movements concerning the same account, a cost center, segments and groups.
An Account card contains the following information:
- The name of the account represented by the card.
- The date of the financial transaction.
- The type of financial transaction (e.g., sale, purchase, payment, receipt).
- The amount.
- The description (e.g., the name of the supplier or customer, the nature of the goods or services bought or sold).
Banana Accounting automatically records all transactions entered in the Table Transactions table, allocating them to the corresponding specific accounts. Therefore, the ledger cards are updated every time a transaction is recorded in the Transactions table.
Opening the Account card
There are two methods to open an account card:
First method
This method is recommended when you want to display and print all or several account / category cards.
- Select the Reports → Account Cards in the menu
A dialog box will appear, with the following sections:
For detailed information on the sections, click on the corresponding links.
Second method
- Click on the small icon that appears when you select the cell that contains the account, category or group number.
Updating the Account card
The account or category card is temporary and is calculated at the time of the request. If transactions are changed or added in the Transactions table, the account card is not simultaneously updated.
To update the account card, following changes, the Account / category card command must be issued again, or if the account card is still open, click on the symbol shown in the image below.
Deleting or modifying data
In the accountcards or group cards, it's not possible to directly modify or delete data. If changes are required, they must be made in the Transactions table or in the Budget table (if they concern estimate transactions). After recalculating, the changes are automatically applied to the corresponding account card.
If you are in the account card and you notice an error or a modification to be made, you need to:
- Within the account card, position yourself on the row number related to the modification.
- Double-click on the row number, and the program automatically redirects to the Transactions table, right on the row related to the modification.
- Make the modification and recalculate the accounting (press Shift + F9).
The changes are automatically reflected in the corresponding account card.
The Account Selected column
Starting from any Account card, the Account Selected column, can be displayed, via the Data → Columns setup menu, the account on which the transaction took place will be shown.
When you get an account card of one or more accounts, groups and segments, you will see the exact account that has been used.
The contra account in the account cards
In the Account cards, the "Contrp" Account column (C-Acct.) is present, which indicates the account that completes the transaction.
When there are transactions on multiple accounts (transactions on multiple rows) as in the example below, and there is one account entered in debit and several accounts in credit, or the other way round, the software deducts the possible contra account using the following logic:
- In the first transaction row, the 5000 account is considered the common contra account of the transactions that follow.
- On the Account card 5000, the multiple transaction (Gross salaries for the month of December) displays the [*] symbol as the contra account. It is impossible to have the indication of the contra accounts directly in the account card, because the account has several contra accounts (1020, 5700, 5730). For this reason the program indicates the [*] , which signals that we are dealing with a transaction on multiple accounts.
- On the Account cards of the next transaction rows (1020, 5700, 5730), the common contra account is indicated between square brackets [5700], and indicates a deducted contra account.
Cards of groups and classes
In the Account card of a group or a class, all the transactions of the accounts that belong to the selected group or class are being grouped together.
The accounts of the group or the class can be displayed by making the Account Selected column visible.
Budget Account card
If the budget transactions have been entered in the Budget table, it is possible to have the account or group cards of the budget:
- Via the Reports → Account cards → Budget transactions must be activated.
Print the Ledger (all account cards)
To print the Account cards:
- Reports menu→ Account cards command
- Using the Filter, all the account cards that need to be printed entirely or partially (for example, only accounts, cost centers, segments) can be selected automatically.
- In the various sections Period, Options, Customization, activate the desired options (for ex. period, 1 account per page, ...)
- Press OK to confirm, after having selected the desired options.
For the explanations of the different tabs, please visit the next few pages: Accounts/Categories tab, Period and Options.
The program will show the selected account cards.
In order to print, choose the Print command from the File menu.
When you have activated the Budget table in your file, you may choose which transactions you wish to see (actual transactions or budget transactions).
Include a logo in the account cards
From Banana Accounting 9 it is possible to include a logo in the account cards printout as well. After obtaining your account cards details (with the Reports→ Account cards command), use the File -> Print preview command. From the print preview click on the the Setup icon, and in the dialog window that will open, select your logo with the Logo option (instead of the none option).
You can also check the how to setup a logo page.
Save the settings
In case you regularly print the account cards of specific accounts for example, all those that concern the Sales accounts, it is useful to create a specific customization.
- Go to the Customization tab
- Create a new customization, using the New button
- Indicate the name of the customization, for example "Sales accounts", in the Description field.
- Select the accounts that you want to be printed.
- Set the view options for the tab. It is possible to select and change the view, from those available, but not to create a new one. If you change the layout of a column, for example by changing its header, this will be applied to the associated view of all customisations.
Each time you want to print accounts, select the customisation you have created.
Page setup
In Page setup, you can specify the margins & other settings of the page.
Accounts
You can access this windows by choosing the Reports menu > Account cards command (see the Account cards page).
Accounts
The list of all available accounts appears.
Select all
By activating this option, all the accounts that are part of the Chart of accounts are automatically selected.
If you wish to print one or more account cards activate only the desired accounts.
Selecting accounts with the mouse
- Clicking on the account name selects the account, and if a previous selection was made, it is deselected.
- Clicking on the account tick box (within the checkbox) selects/deselects the account and the previous selection remains unchanged.
- To select multiple adjacent accounts at the same time, simply click on the first one, hold down the left mouse button, move the mouse over the list to select the desired accounts, and press the spacebar.
- To select multiple non-adjacent accounts, hold down the Ctrl key (or Cmd on Mac), and use the left mouse button to move over the list, selecting the desired accounts, and then press the spacebar.
Selecting accounts with the keyboard
- You can navigate the account list using the up/down arrow keys, and select/deselect an account by pressing the spacebar.
Search
The option allows the immediate search of one or more accounts. The account number or description of the account is entered in the box; the program filters the accounts using the search values entered.
You can also enter multiple accounts to be displayed simultaneously, or combine accounts and segments (see developer explanations):
- 1000|1001 will display the transactions for account 1000 and 1001.
- 1000:01 will display all transactions of the 1000 account with the 01 segment.
Sort by account number
If this option is activated, the accounts are sorted according to the selection applied in the Filter (at the bottom of the dialog box). If, for example, there are accounts, cost centers or segments with abbreviations, they are listed in alphabetical order.
Filter
This function allows you to filter all account cards or just a selection, specifically:
- Accounts, cost centre and segments - if no selection is made they are filtered by default
- Accounts/categories (existing cost centres and segments are excluded)
- Accounts, Cost centres (only segments are excluded)
- Cost centres (accounts and/or categories and segments are excluded)
- Segments (accounts and/or categories and cost centres are excluded)
- Groups - existing groups will be shown - you need to select the ones to be printed
- Classes - all classes will be shown - you need to select the ones to be printed.
Actual or budget transactions
When you have activated the Budget table in your file, you may select:
- Actual transactions
The entries in the Transaction tab will be processed.
- Budget transactions
The entries in the Budget tab will be processed.
If the Budget table is not present, but amounts have been entered in the Budget column of the Accounts table (Budget View), these amounts are converted into monthly amounts. The division performed by the program is based on the start and end date of the accounting period (if the duration is 1 year, the division will be into 12 monthly installments).
Account card 00 - Differences in accounting transactions
When there are discrepancies in the transactions (see Debit - Credit Difference error page), to identify where the error is located, the account statement for Group 00 is displayed (or the statement for the group in your chart of accounts that includes all accounts from Class 1, 2, 3, and 4).
You will have a list of all transactions with the successive balances, which after each entering should equal zero. The row where the balance is not at zero contains the error.
Viewing the Details of transactions
Using the Group 00 account statement, it is also possible to view the details of the transactions.
Once you have selected the Group 00 account statement, the list of transactions will appear. Select any column, double-click on the column, and a screen will appear to select the visible columns. Select the "TransactionAmount" column. After making this change, the screen opened from the Group 00 account statement will display the "Transaction" column in CHF with detailed specific amounts.
Double-click on a column:
Select the "MovementAmount" column
Next, a new column "Movement CHF" will be added, which will display the details of the amounts of individual transactions. This modification can be useful, for example, when a transaction includes VAT, and you want to see the details of that transaction while keeping the VAT separate.
Invoice recording with VAT:
Details of the invoice recording with VAT, with Account Card 00 and the "MovementAmount" column activated:
Period Accounting Card
The explanations of the Period tab are the same as those for the Enhanced Balance Sheet with Groups, tab Period.
Options tab
Via the Reports → Account cards → Options menu you can access the various options that can be included or excluded from displaying and printing.
Lines before end of page
This function was created in order to avoid printing an account partially on one page and partially on the following. If the account card to be printed doesn't have at least a number of rows corresponding to the number input in this field, printing the whole card will be moved to the next page.
One account per page
By activating this function, each card will be printed on a separate page (even those with few transactions).
Repeat column's headers
By activating this function, the column headers will be repeated for each account, within the page.
Include accounts with no transactions
By activating this function, cards without transactions will be printed as well.
View
You can select the columns view to be included in the account cards display and printout:
- Base
- VAT
- Cost centers
- Expiration dates
If no criteria are specified the program will keep the order present in the Transactions table.
Sort column
In the account card, transactions can be sorted according to different data criteria:
- Document date
- Value date
- Expiration date
- Payment date
Journal
In Accounting, the "journal" is a book of original entry where all financial transactions of a company are recorded in chronological order. It is a fundamental tool for recording accounting transactions and plays a crucial role in the bookkeeping process.
In Banana Accounting, the Journal is represented by the Transactions table, where transactions are entered in chronological order. From this table, the program provides a detailed and complete record of all financial activities of the company and serves as the basis for preparing other accounting documents such as the general ledger, balance sheet, and income statement.
Each transaction is recorded with detailed annotations, divided into specific columns:
- Date: The date on which the transaction occurred.
- Description: A brief description of the transaction, indicating the nature of the accounting operation.
- Debit Account: The account debited for the amount of the transaction.
- Credit Account: The account credited for the amount of the transaction.
- Amount: The amount of the transaction.
Journal prints can be generated either by selection or by using a command that also allows defining a period.
For further information, please refer to the following pages.
With Banana Accounting the Journal corresponds to the Transactions table. It is possible to print the entire journal or just a part of it, selecting the rows that you wish to print.
There are different methods to print the Journal:
- Position yourself in the Transactions table and click on the Print preview icon; then click on the Print icon
- From the Transactions table and select from the File menu → Print preview → Print icon.
- From the menu Reports menu → Journal by period ...
Period
You can choose whether to print all or a defined period. To print a specific period, enter the start date and the end date.
Sorting
In the Sort column tab it is possible to choose the criteria by which the journal should be sorted and printed.
Customize the printing of the Journal
To customize the printing of the journal, you can change the arrangement and header of the columns. Information can be found on the Columns setup page; while the options to include in the printout are found in the Page Setup lesson.
Enhanced Balance Sheet
The Balance Sheet represents all the Assets, Liabilities, Expenses and Income at a specific moment. The difference between Assets and Liabilities determines the equity capital. In Banana Accounting, the embellished Balance Sheet has the following characteristics:
- The grouping of the accounts is done according to the contents of the BClass column.
- The Enhanced Balance Sheet (Reports menu), shown in the preview, can be saved in different formats (PDF, HTML, MS Excel) and can be copied to the clipboard.
- It is possible to calculate, display and print the budget at the end of the year, or for a specific period.
- Transactions without date are considered as opening transactions and will not appear in the printouts of the Profit & Loss Statement.
To calculate, view and print out the Enhanced balance Sheet, click on the menu Report > Enhanced balance Sheet. A window appears with several sections allowing you to set the printing parameters.
See also Printout Examples.
Print pages and Include in printout
In these sections, by activating the different options listed, you can choose the content to be displayed and printed in the Enhanced balance sheet.
The option "Previous year balances" is only available if the field All is selected in the Period section. If a specific period is defined instead, the option is not active. In this case, the Enhanced balance sheet with groups should be used instead.
Page headers
Rows 1 - 4
Rows available to define the heading of the balance sheet.
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 page number
If this option is activated, the number is printed in footer progression.
Print date
If this option is activated, the date is entered in the footer.
Cover page
Print cover page
Activating the function prints the cover page.
Logo
It is possible to insert the logo in the cover page 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.
Column headers
The boxes at the bottom of the enhanced Balance Sheet dialogue box are used to insert the current and previous year headings in the printout.
The first two vertical boxes refer to the dates of the balance sheet, the second to those of the income statement.
At the moment, when opening the dialogue window of the Enhanced Balance Sheet, the boxes for entering the current and previous year are not clearly visible.
To view the boxes mentioned, one must scroll all the way down the vertical scroll bar, located on the right-hand side of the dialogue box.
Current year
Insert the final date of the current accounting.
Previous year
Enter the final date of the previous year's accounting in this field.
When switching to the new year from the menu Actions > Create New Year, the header of the previous year is not adapted automatically, so it must be changed manually. This issue will be resolved in the future.
Dialogue not fully visible
To display the Enhanced Balance dialogue box completely, choose one of two procedures:
- Enlarge the dialogue box.
- Slide the scroll bar, located on the right-hand side of the window, downwards.
Other tabs
The explanations for the other tabs are available at the following pages:
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.
Features:
- Reports with actual balance data, or budget data, or both, with indication of variances.
- Free arrangement with groups and subgroups.
- Updated results directly visible in the accounts table.
- Customizable prints:
Watch the video tutorial that shows how to create and print the Enhanced Balance Sheet with groups.- Addition of your own logo.
- Choice of columns to include.
- Choice of sections to include.
- Detailed or grouped printing.
- Prints for a single period.
- Columns with breakdown by period (month, quarter, semester, year).
- Previous year values.
- Comparison with forecast value.
- Columns with breakdown by segment.
- Addition of attached notes.
- Grouping as in the chart of accounts or according to your own scheme.
- Saving customization
- Tabular reports (similar to customizable prints, but with data present in the table).
- Export to PDF for data preservation and export in other formats for data processing.
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.
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.
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.
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.
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.
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:
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. 
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
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.
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.
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)
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.
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 groups → Columns → Advanced button → Add button.
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.
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.
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).
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.
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.
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.
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.
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.
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.
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
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.
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.
Customization
Customizations allow you to create and save print settings and recall them later.
See the page relating to Customizations.
End of Year PDF printouts
From the print preview of a document, you can save in PDF format and print.
You can save in a PDF format the following documents:
- Balance sheet and Profit and Loss Statement
- Accounts, Transactions, VAT, Totals tables
- VAT Reports
- Account cards
This PDF file will have an index that allows for easy access for the different printouts.
If you save this file on a non rewritable CD (to be kept along with the accounting documents), you will comply with the requirements for accounting data archiving.
Reports over several years
A statement over several years allows for a simple and immediate comparison of the evolution of your business. Banana Accounting can display balance sheets up to two previous years in the same report, so for example the balances of the years 2022, 2021 and 2020 on a single page.
In order to view the balances over several years it is necessary that the "file previous year" option is indicated correctly in the File and accounting Properties, → Options tab, otherwise Banana Accounting is not able to retrieve the balances of the previous accounting periods, which would therefore remain empty.
In the following example we indicate how to get a report for the years 2022, 2021 and 2020. Here is how to proceed:
- Reports menu → Enhanced balance sheet with groups ...
- Check Current and Previous year in the Columns section.
- Advanced Button (click on the button for both the Balance Sheet and the Profit and Loss Statement).
- From the dialog window that opens, click on the Add button to add a column.
- Scroll down the list until you see -2 Years (we have to go 2 years back, from the current year).
- Confirm with OK to get the report.
Accounting report
- The Accounting Report command from the Reports menu displays and prints the amounts of accounts with a specific grouping, for a specific period or with a specific subdivision.
- Transactions without date are being considered as opening transactions and will not appear in the printouts of the Profit & Loss Statement.
Include a logo in the accounting report printout
To obtain accounting reports with logo, after creating the accounting report, you need to:
- File Menu → Print Preview → select Page Setup
in the dialog box that opens, under Logo, indicate the logo (instead of none).
You can also check the how to setup a logo page.
Base tab
Report
You can select the desired grouping scheme:
- As on Accounts table - the Report will show a list of all accounts just as in the Accounts table with the Opening balance and Balance columns
- Accounts by class - the Report will show the list of the accounts but without subgroups
- External accounting report - the Report will show the data according to a grouping system preset in a separate file (created via File → New → Double-entry accounting → Accounting Report).
Options
You can select the accounts to be included or excluded:
- Show group totals only - only the group totals will be shown
- Include accounts with transactions - only accounts with transactions will be printed
- Include accounts with 0 balance - accounts with zero balance will be printed as well
- Exclude groups without accounts - groups that contain only accounts with zero balance will not be printed.
Other sections
The explanations for the other sections are available at the following pages:
Report result
A new table is created where the results are shown.
