Video Income & Expense accounting: video tutorial that shows you how to easily set up an Income & Expense accounting, adapt the Accounts and Categories tables, set a budget, enter the transactions and print reports.
Creating an accounting file, starting with a template
Banana Accounting includes templates for all legal frameworks, divided by country and by category. They can be opened directly in the program, via the File menu, New ... command, or they can be downloaded from the Templates page of our website.
The startup procedure is explained below starting with a template directly from the program:
- File menu → New command
- Select the Region, the Category and the Accounting type
- From the list of the templates that appears, select the template that is closest to your own needs.
- Click on the Create button
When entering a key word in the Search area, the program will display the templates that contain the entered key word.
It is equally possible to start from a blank file, by activating the Create Empty file option. In order to facilitate starting up and to avoid grouping errors, we however recommend that you always set out with existing template.
More information on how to create a new file is available on the Create New File page.
Setting up the File properties
Set your data in the File Properties (Base Data) and save the file as.
Save to disk
With the File-> Save As command, save the data and also assign an name to the file. The save dialog typical for your operating system appears.
- It is advisable to use the name of the company followed by the year "Company_2020.ac2." to distinguish it from other accounting files.
- You can keep as many accounting files as you need, each will have its own name.
- You can choose the path and media on which to save the file (save to disk, key or cloud).
If you also expect to have documents linked to the current year's accounts, it is suggested that you create a separate directory for each accounting year having to group all the files.
In the Accounts table, you can customize the estate accounts, according to your own needs:
- you can change the Account numbers
- you can change the Description
- In the Opening column you need to enter your opening balances
For Liabilities' accounts (f.ex. debts), the opening balance should be preceded by the minus (-) sign.
This operation needs to be executed only when using Banana Accounting for the first time, since from then on, every end of the year, when creating a New Year (Actions menu, Create New Year command), the opening balance will be automatically transferred.
In the Categories table, customize the income (earnings/revenue) and expense (expenses/costs) categories.
The Category numbers can be amended, as well as the Description.
The categories don't and must not contain an opening balance, in order to determine the result of the accounting year.
In the Transactions table, the daily income and expense transactions are entered, indicating the account, for which the transaction was made and the category to which the income or expense is attributed.
In the appropriate columns:
- Enter the date
- Enter the document number that is manually assigned to the paper document. This allows you to easily find documents, once the accounting transaction has been entered.
- Enter a description
- In the Income column, enter the income amount
- In the Expenses column, enter the expense amount
- In the Account column enter the account number (it has to be an existing account in the Accounts table, ex. Bank)
- In the Category column enter the expense or income category (it has to be an existing category in the Category table).
Speeding up the recording of the transactions
In order to speed up the recording of your transactions, you can use:
- the Smart fill function that allows the automatic auto-complete of data that have already been entered at an earlier date.
- the Recurring transactions function (Actions menu), used to memorize recurring transactions into a separate table.
- import of your bank or post office statement.
Transactions with VAT
In order to enter transactions with VAT please proceed as follows:
- from the File menu, choose New command and choose Income /Expenses accounting with VAT/Sales taxes
- Choose one of the existing templates for your nation of the Income/expenses accounting with VAT type
In order to enter transactions with VAT, please refer to the Transactions page.
Transactions on multiple rows
Transactions on multiple rows, or Composed transactions are transactions involving more than two accounts and credits/debits on multiple accounts or categories (for example when you pay different invoices from the bank account). In this case you need to enter the transaction on multiple rows:
- in the first row enter the total amount of the income or expense and the account from which this amount is debited or credited
- n each subsequent row, enter the income or expense amount in the category column, and enter the appropriate category number.
Each individual amount is recorded on different row. When all the individual income and expenses rows are entered there shouldn't be any differences.
The Account card
The Account card allows you to have a complete list of entries relating to the same account or the same group.
- To open an account card you click once on the account number cell and then click once on the small blue arrow appearing in the upper right corner of the cell.
- To open multiple account cards you must select the Account cards command from Reports menu.
- To update the account cards, following changes in the Transactions table, you must click on the two circular arrows symbol, located at the top right of the account card.
The category card
The Category card allows you to have a complete list of entries relating to the same category.
- To open a category card you click on the account number cell and then click once on the small blue arrow appearing in the upper right corner of the cell.
- To open multiple category cards you must select the Account cards command from Reports menu.
- To update the category cards, following changes in the Transactions table, you must click on the two circular arrows symbol, located at the top right of the category card.
Account cards per period
To open an account card with account balances at predefined dates, click on Reports in the menu, Account cards ... and click Period selected in the Period tab to insert your selected period.
Consult the Period page for further information.
Print the Account cards
To print an Account card, open it from any table (Accounts or Transactions) and start printing from the File menu.
To print out several or all the Account cards, click Reports menu, select Account cards and select the Accounts you wish to print. The filter in the window allows you to select automatic selection of all accounts, cost centers, segments, groups etc.
For further information refer to the Account Cards page.
To view the Enhanced Statement and the Enhanced Statement with groups, choose the Reports menu and then the Enhanced statement or Enhanced statement with groups command. You can also obtain statements by period.
- The Enhanced statement displays all accounts and categories without any subgroups
- The Enhanced statement with groups displays all accounts and categories also with subgroups.
Archive data in PDF format
At the end of the year, when the accounting is done, corrected and revised, you can store all accounting data with the Create Pdf dossier command from the File menu.
Before starting your accounting year, you can create a budget with your assumed expenses and revenue, in order to have control over the financial and economic situation of your company.
The budget can be set in two different ways:
- From the Budget column of the Categories table. For each account the yearly budget is indicated.
In this case, when you process the budget from the Reports menu, Enhanced statement with groups command, the Budget column shows the amounts that relate to the entire year.
- From the Budget table, that you need to manually activate using the Add new functionalities command from the Tools menu.
- In this table all estimates are entered as budget transactions, either income or expenses. If you activate this table, the Budget column of the Accounts table is automatically deactivate.
A detailed budget can be set in this case, that takes into account the possible variations during the year and in the different periods of the year