In this article
The Transactions table is the central hub for keeping the accounts, where all the operations with financial and economic impact are entered. The use is similar to Excel. In the Transaction table the movements are always visible and in perfect order and by scrolling them, you instantly have a clear view of all the events.
All the data entered can be modified and corrected, making it easy to have a perfect accounting.
Fast insertion
The table is similar to Excel, you can scroll up and down and position yourself in any cell.
There are many features that make entering and editing data very fast.
The following operations are possible:
- Cancel and redo.
- Select one or more cells and copy / paste.
- Add, copy, paste and delete lines, individually or in bulk.
- Search and replace texts.
- Sort the rows by date.
- The auto-complete function suggests the values to enter (for example the list of accounts).
- With the F6 key the values of the row are completed, taking over those of the same row.
- The F4 key resumes the values from the previous row.
- The date is completed with the values from the previous row.
- In the Doc column progressive numbers (with different counters) are suggested.
- In the Debit or Credit Account column you can search for the account by typing it's description.
- In the columns of the amounts you can enter formulas, such as "30 + 25" and the program inserts the result.
Further information is available on the Cells page.
Movements import
By importing transactions from bank, postal or credit card statements, data entry in the Transactions table is speeded up and errors are avoided. Data is recorded exactly as it appears on the bank statement.
- In addition to the account statements, you can also import data from other programs.
- The program automatically completes the missing values.
- Several formats are available for importing.
- You can copy and paste data from other programs.
- Imported data can be completed, modified or deleted.
- Ability to program extensions to import any type of file.
Further information is available on the Import to Accounting page.
Management of multiple information
A lot of information can be indicated for each entry row:
- The value date and that of the document.
- A progressive number of document and protocol, or external reference.
- Any additional information you need by adding columns.
- Link to a digital document file.
- Add and remove links.
- Open the link and view the content.
- VAT management (if the type of accounting with VAT was chosen in the creation of the file):
- By entering the VAT code in the transaction, the program calculates the VAT automatically.
- Break down and post the VAT on the designated account.
- You can define whether the amount is net or gross of VAT.
- You can indicate that it is a reversal by inserting the minus sign "-" before the VAT code.
- You can indicate a VAT percentage that is not recoverable.
- You can encode special cases with additional codes.
- Cost and Profit centres:
- Up to 3 cost and profit centers for each posting line.
- You can post negative by indicating the "-" sign in front of the cost or profit center account.
- Segments:
- For each debit or credit account you can indicate up to 10 segments.
- Supplier management:
- Management both on the basis of competence (setting as ledger) and cash (setting as cost and profit centers).
- Management of due date and payment, to have the report of open and paid invoices.
- Client management:
- Management both on the basis of competence (setting as ledger) and cash (setting as cost and profit centers).
- Management of due date and payment, to have the report of open and collected invoices.
- Invoices to customers:
- Data entry for the creation of invoices.
- Customer account suggestion.
- Quantity and price (make columns visible).
- For billing or cost control.
- Automatic calculation of the amount.
- Item number (if option activated)
- To connect to the items table.
- Automatic calculation of the quantities of products entered and exited.
- Print invoices.
- Indication of further information needed to print the invoice.
Account card
From the Transactions table you can access any account card, just go to the account cell (in the Debit or Credit column) and click on the small icon that appears in the upper right corner of the cell.
When you are in the account card, clicking on the row number of a transaction takes you back to the Transactions table, on the original transaction precisely.
More information on account cards can be found on the Account / Category Card page.
Verify data
Entering values is very secure. Banana Accounting has functions that allow automatic detection and reporting of errors.
- The program verifies that the entered values are correct.
- If there is an imbalance between the Debit and Credit columns, this will be indicated in red in the Info window.
- Transactions you are unsure about can be left pending and completed later.
- For each error message there is a corresponding help page (requires internet connection).
- In the Info window below you have the following information:
- Description, movement and balance of the accounts used.
- Error reports error messages with a link to the help page.
- Reporting of the debit and credit difference.
- By entering the actual bank balances via the #checkbalance function, you can immediately check the correspondence of the balances in the accounting and avoid errors.
- With the Check accounting command, the program rechecks all the data entered and alerts you to oversights and errors.
- You can colour the rows, change fonts and make them bold.
- You can protect the rows.
- Lock transactions with blockchain technology.
Arrangement of columns
To have a more congenial data entry, you can arrange all the columns in your own order.
You can choose to:
- Move the columns to the right or left.
- Display additional columns or hide unnecessary ones.
- Add own columns
- Save the arrangement of the columns (views).
Further information is available on the Columns setup page.