• The Balance Sheet represents all the Assets, Liabilities, Expenses and Income in a specific moment. The difference between Assets and Liabilities gives the personal capital.
• The grouping of the accounts is done according to the contents of the BClass column.
• The Enhanced Balance Sheet, shown in the preview, can be saved in different formats (PDF, HTML, MS Excel) and can be copied in the clipboard.
• In order to calculate, display and print it at the end of year or the end of a period, activate the Enhanced balance sheet command from the Account1 menu.
• Transactions without date are being considered as opening transactions and will not appear in the printouts of the Profit & Loss Statement.

Including a logo in the Enhanced Balance Sheet

From the Banana version 9.0.3  it is possible to include a logo and to define its settings (width, height, position) from the File meu > Logo setup command. It is also possible to create and save Compositions with different logo settings.
This feature is a simpler alternative to the logo setting with the Documents Table.

From the following window several printing options can be activated, appears.
See also Print Examples.

Page header

Rows 1 thru 4
In this field, enter texts to use as headers when printing.

Print cover page / Print date / Print page numbers
The activated options will be shown in the print-out.

Column header (Balance / Profit and Loss)
The first two vertical fields refer to the Balance Sheet, the two second ones refer to the Profit and Loss Statement.

Current year
Insert the final date of the current accounting.

Previous year
In this field, enter the final date of the previous year's accounting.

Print pages / Include in printout
By selecting the appropriate cells, it is possible to choose the options that should be activated in the printouts.

 

Other tabs

The explanations for the other tabs are available at the following pages:

• Period
• Style
• Texts
• Margins
• Composition

Results

 

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.

 

With Banana Accounting the Journal corresponds to the Transactions table. It is possible to print the whole journal or just a part of it, selecting the rows that you wish to print.

In order to personalize the journal printout you can change the columns order and headings: you can find all the information on how to proceed in the Columns setup page; you can also choose several options in the printout; please visit the Page setup page.

There are different ways to print:

• place yourself in the Transactions table and click on the Print icon
• place yourself in the Transactions table and launch the Print command form the File menu
• from the Account1 menu click on the Print journal by period command; in this case you should then indicate if you wish to print the whole table or just a specific period

The information on the Period tab are explained in detail in the Period page of the General settings.
 

In the Sort column tab in is possible to choose the criteria the journal should be sorted and printed.

 

• This command allows the user to visualize the amounts of accounts with a specific grouping, for a specific period or with a specific subdivision.
• In order to calculate, obtaine and print reports, choose the Accounting reports command form the Account1 menu.
• 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

From Banana Accounting 9 it is possible to include a logo in the accounting report printout as well. After obtaining your accounting report , go to File menu -> Print preview command. From the print preview click on the the Setup icon, and in the dialog window that will open, in the Logo option, seleg your logo insted of the none option.
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 (File menu, New command,  Double-entry accounting group, 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 tabs

The explanations for the other tabs are available at the following pages:

• Period tab
• Subdivision tab
• Composition tab

Report result

A new table is created where the results are shown.

The account card corresponds to the  Ledger and allows you to have a complete list of accounting movements concerning the same account, the same categories (income & expense accounting and cash manager), a cost centre, segments and groups.

Opening the Account card

There are two methods to open an account card or a category card:

• Select the Account/category Card (Cash book and Income & Expense accounting) command or the Account card (Double-entry accounting) command of the Account1 menu in order to open and print several or all account cards.
• On the account number cell there is a small blue symbol; click on it just once in order to obtain the account card.
  The groups of the Chart of accounts have the same symbol available as well, in order to display the account card.

Updating the accounting card

The account card table is temporary and it is calculated when the command is given to do so. If, in the Transactions table, transactions are altered or added, they are not automatically updated on the account card - the user needs to select the Account Cards command again or click, in the Transactions table, once more on the account number's blue symbol, or in case the account card is still open, click on the small Refresh button on the right side (see image hereunder).

Note:

It is not possible to modify the data in the Account card. Double-click on the row number to go back to the original corresponding row of the Transactions or Budget table.

The AccountSelected column

In the AccountSelected column, which can be made visible, starting from any Account card, through the Data menu -> Columns setup, the account on which the transaction took place is being displayed.
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 Contra Account column (C-Acct.), which indicates the account that completes the transaction, is being shown.

When there are transactions on multiple accounts (transactions on multiple rows) as in the example hereunder, and there is one account entered in debit and several accounts in credit, or the other way around, the software deducts the possible contra account using the following logic:

• In the first transaction row, the 1020 account is considered the common contra account of the transactions that follow.

• On the Account card 1020, the composed transaction (Payment various invoices) shows the contra account indicated by the [*] symbol. It is impossible to have the indication of the contra accounts directly in the account card, because the account has several contra accounts (4500, 6700, 6700). For this reason the program indicates the [*] symbol in the C-Acct (Conta-Account) column, which means that we are dealing with a transaction on multiple accounts.

• On the Account cards of the next transaction rows (4500, 6700, 6700), the common contra account is indicated between square brackets ("[1020]"), 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 AccountSelected column visible.

Print the Ledger (all account cards)

To print the Account cards:

• Account1 menu, Account cards command
• By means of the Filter, all the account cards that need to be printed completely or partially (for example, only accounts, cost centers, segments) can be automatically selected
• In the various sections Period, Options, Composition, 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 want 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 Account1 -> Account cards command), go to File menu -> Print preview command. From the print preview click on the the Setup icon, and in the dialog window that will open, in the Logo option, seleg your logo insted 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 composition.

• Go to the Composition tab
• Create a new composition, using the New button
• Indicate the name of the composition, for example "Sales accounts", in the Description field of the window
• Select the accounts that you want to be printed.

Every time you wish to print these accounts, you can select the composition that you created.

Page setup

In Page setup, you can specify the margins & other settings of the page.

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 will allow to access easily the different printouts.
If you save this file on a non rewritable CD (to be kept along with the accounting documents), you will meet the law requirements for accounting data archiving.

 

 

A statement over several years allows a simple and immediate comparison of the evolution of your business. Banana Accounting can display the balances up to two previous years in the same report, so for example the balances of the years 2019, 2018 and 2017 on a single page.

In order to use this feature though, you need to make sure that in the basic accounting data the "previous year's file" option is activated and that the correct file is entered (File menu -> File properties (Basic data) -> Options tabn -> Previous year file), otherwise Banana Accounting cannot recover the balances of the previous accounting periods, and they won't appear in the report.
In the following example we will show you how to obtain a report over the years 2017, 2018 and 2019. Here is how to proceed:

• from the Account1 menu choose the Enhanced balance sheet with groups...
• from the Columns section, check the Current and Previous year boxes

• then click on the Advanced button (this operation must be done both for the Balance sheet and for the Profit & Loss statement) and,
  from the dialog window that opens, click on the Add button to add a column
• scroll down the list of possibilities until you reach -2 Years - we are indeed in the year 2019 and in order to have a 2017 report we have to go 2 years back

• confirm with OK and enjoy your report