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.
The Transaction Table is also characterized by the Balance Column, which allows identifying any differences between the Debit and Credit columns and especially the row where the difference originated. Additionally, errors and accounting differences are flagged in the information window at the bottom.
Key features:
- Single or compound entries: Single entries record simple transactions with one Debit and one Credit account, while compound entries are entered on multiple lines with different Debit and Credit accounts. The program suggests previously entered text for quick auto-completion.
- Recording Method: Transactions can be recorded using either the accrual or cash method, ensuring accuracy and compliance with accounting standards.
- Management of Repetitive Operations: Stores repetitive operations for quick future recording, reducing data entry time.
- Customizable Columns: Default columns can be made visible at the user's choice, including quantity, price, and other relevant information.
- Automatic Numbering: Automatically assigns document numbers with different numbering simultaneously, maintaining systematic order and facilitating search and archiving.
- Digital Attachments: Links digital justifications such as PDFs or images to files, accessible with a simple click for complete and organized documentation.
- Exception Management: Highlights rows to quickly identify entries to verify or correct, facilitating the review and control process.
- Data Integration: Imports transactions from various digital bank statements and other programs, speeding up entry of records and ensuring data accuracy.
- Cost/Profit Centers and Segmentation: Allows recording operations on cost/profit centers and segments for detailed analysis and better financial management.
- Balance Verification Entries: Before period or year-end closings, quickly identifies and corrects errors between actual balances, ensuring accurate and updated balances.
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 pages:
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.