In this article
Video Double-entry accounting: video tutorial that shows you how to easily set up a Double-entry accounting, adapt the Accounts table, set a budget, enter the transactions and print reports.
Creating an accounting file, starting from a template
Proceed as follows:
- File menu, New command
- Select the region, the language, 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
In the Search area, when entering a key word, the program displays the templates that contain the entered key word.
It is equally possible to start from a blank file, by activating the Create blank file option. In any case, in order to facilitate the start and avoid grouping errors, we recommend that you always start from an existing model.
More information on how to create a new file is available on the Create New File page.
Setting up the file properties (basic data)
- From the File menu, File properties command, indicate the company name that will appear in the headers of the printouts and on the other data.
- Select the basic currency, with which the accounting will be kept.
Save to disk
With the File-> Save As command, save the data and also assign an name to the file. The typical save dialog of your operating system appears.
- It is advisable to use the name of the company followed by the year "Company-2020." to distinguish it from other accounting files.
The program will add the "ac2" extension.
- You can keep as many accounting files as you need, each will have its own name.
- You can choose the folder you want, (for example, Documents -> Accounting) or the support you want like a disk, usb 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.
General use of the program
Banana Accounting inspires itself from Excel. The user directions and the commands are kept as similar as possible to the ones of Microsoft Office.
For more information on the general use of the program, we refer to the explanations on our page Program interface.
The accounting is being contained in tables; all of them have the same way of operating.
Customizing the Chart of accounts
In the Accounts table, customize the Chart of accounts and adapt it to your own needs:
- Add new accounts and /or delete existing ones (see Adding new rows)
- Modify the account numbers, the descriptions (for example, enter the name of your own Bank account), enter other groups, etc.
- To create subgroups, please consult our Groups page.
In the Chart of accounts, you can also define Cost centers or Segments, used to attribute the amounts in a more detailed or specific way.
The Transactions have to be entered into the Transactions table; together they compose the Journal.
In the specific columns:
- Enter the Date
- Enter the Document number, manually assigned to the paper document. This makes it possible to easily locate the documents once the accounting transaction has been entered.
- Enter the Description
- Into the Debit account column, enter the destination account
- Into the Credit account column, enter the account of origin.
- Enter the Amount. In the accounting with VAT, enter the gross amount, VAT included. The program will separate the VAT, splitting the net cost or net income.
Speeding up the recording of the transactions
In order to accelarate the recording of the transactions, you can use
- the Smart fill function that allows the automatic autocomplete of data that have already been entered at an earlier date.
- the Recurring transactions function, used to memorize recurring transactions into a separate table.
- importing your bank or postal account statement from the e-banking.
Transactions with VAT
In order to enter transactions with VAT please proceed as follows:
- from the File menu, choose New command and choose Double-entry accounting with VAT/Sales taxes
- Choose one of the existing templates for your nation with double-entry accounting with VAT codes and VAT Codes table.
In order to enter transactions with VAT, please visit 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 (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 and the account debited or credited
- when all the individual debit and credit rows are entered there shouldn't be any difference
For more details, consult the page Composed transactions.
Checking customer and supplier invoices
Banana allows you to keep an eye on the invoices to be paid and the receivable, issued invoices. Please consult:
The Account card
The Account card automatically displays all the transactions that have been recorded on the same account (for example, cash, bank, clients, etc).
To display an account card, just position yourself with the mouse on the account number and click on the small blue symbol that appears.
Account card by period
To display the account card with the balances referring to a specific period, click on the Account1 menu, Account card command, and in the Period section, activate Period Selected, entering the Start and the End date of the period.
For more details, consult the Period page.
Printing the Account card
In order to print one account card, just display the card from the Accounts or the Transactions table and launch the print from on the File menu.
To print several or all account cards, click on the Account1 menu, Account card command, and select the account cards that need to be printed. By means of the Filter, all the account cards, or only a part of all of them (for example, only accounts, cost centers, segments), that need to be printed can be automatically selected.
For more details, consult the Account Card page.
The Balance Sheet and Profit and Loss Statement
The Balance sheet shows the balances of all the estate accounts, Assets & Liabilities. The difference between the Assets and the Liabilities determines the Share capital.
The Profit & Loss statement shows all the Expense & Revenue accounts. The difference between the Expenses & Revenue determines the Profit or Loss of the Accounting year.
The display and the printing of the Balance Sheet is being executed from the Account1 menu, Enhanced Balance Sheet and Enhanced Balance Sheet with groups commands.
- The Enhanced Balance Sheet command simply lists all the accounts without distinguishing Groups and Subgroups
- The Enhanced Balance Sheet with groups command lists all the accounts while subdividing Groups and Subgroups; besides, it presents numerous features to customize the presentation, functions that are not provided in the Enhanced Balance Sheet.
Data archiving in PDF format
At the end of the year, when the entire accounting has been completed, corrected and audited, all the accounting data can be archived with the Create PDF dossier command of the File menu.
- Accounts table, Budget column. For each account, the annual budget amount is being indicated.
In this case, when you set up the Budget from the Account1 menu, Enhanced Balance Sheet with groups command, the Budget column displays the amounts that refer to the entire year.
- In the Budget table, that can be activated through the Tools menu, Add new functionalities command.
In this table, you can enter all the budgeted costs and revenue by means of entering transactions. If you activate this table, the column of the accounts table will be automatically deactivated.In this case you can set up a detailed budget, taking into account the possible variations over the year and in different periods of the year.
For more details, consult the page Budget.