Account cards - Ledger
The account card corresponds to the Ledger and allows you to have a comprehensive list of accounting movements concerning the same account, a cost center, segments and groups.
An Account card contains the following information:
- The name of the account represented by the card.
- The date of the financial transaction.
- The type of financial transaction (e.g., sale, purchase, payment, receipt).
- The amount.
- The description (e.g., the name of the supplier or customer, the nature of the goods or services bought or sold).
Banana Accounting automatically records all transactions entered in the Table Transactions table, allocating them to the corresponding specific accounts. Therefore, the ledger cards are updated every time a transaction is recorded in the Transactions table.
Opening the Account card
There are two methods to open an account card:
First method
This method is recommended when you want to display and print all or several account / category cards.
- Select the Reports → Account Cards in the menu
A dialog box will appear, with the following sections:
For detailed information on the sections, click on the corresponding links.
Second method
- Click on the small icon that appears when you select the cell that contains the account, category or group number.
Updating the Account card
The account or category card is temporary and is calculated at the time of the request. If transactions are changed or added in the Transactions table, the account card is not simultaneously updated.
To update the account card, following changes, the Account / category card command must be issued again, or if the account card is still open, click on the symbol shown in the image below.
Deleting or modifying data
In the accountcards or group cards, it's not possible to directly modify or delete data. If changes are required, they must be made in the Transactions table or in the Budget table (if they concern estimate transactions). After recalculating, the changes are automatically applied to the corresponding account card.
If you are in the account card and you notice an error or a modification to be made, you need to:
- Within the account card, position yourself on the row number related to the modification.
- Double-click on the row number, and the program automatically redirects to the Transactions table, right on the row related to the modification.
- Make the modification and recalculate the accounting (press Shift + F9).
The changes are automatically reflected in the corresponding account card.
The Account Selected column
Starting from any Account card, the Account Selected column, can be displayed, via the Data → Columns setup menu, the account on which the transaction took place will be shown.
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 "Contrp" Account column (C-Acct.) is present, which indicates the account that completes the transaction.
When there are transactions on multiple accounts (transactions on multiple rows) as in the example below, and there is one account entered in debit and several accounts in credit, or the other way round, the software deducts the possible contra account using the following logic:
- In the first transaction row, the 5000 account is considered the common contra account of the transactions that follow.
- On the Account card 5000, the multiple transaction (Gross salaries for the month of December) displays the [*] symbol as the contra account. It is impossible to have the indication of the contra accounts directly in the account card, because the account has several contra accounts (1020, 5700, 5730). For this reason the program indicates the [*] , which signals that we are dealing with a transaction on multiple accounts.
- On the Account cards of the next transaction rows (1020, 5700, 5730), the common contra account is indicated between square brackets [5700], 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 Account Selected column visible.
Budget Account card
If the budget transactions have been entered in the Budget table, it is possible to have the account or group cards of the budget:
- Via the Reports → Account cards → Budget transactions must be activated.
Print the Ledger (all account cards)
To print the Account cards:
- Reports menu→ Account cards command
- Using the Filter, all the account cards that need to be printed entirely or partially (for example, only accounts, cost centers, segments) can be selected automatically.
- In the various sections Period, Options, Customization, 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 wish 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 Reports→ Account cards command), use the File -> Print preview command. From the print preview click on the the Setup icon, and in the dialog window that will open, select your logo with the Logo option (instead 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 customization.
- Go to the Customization tab
- Create a new customization, using the New button
- Indicate the name of the customization, for example "Sales accounts", in the Description field.
- Select the accounts that you want to be printed.
- Set the view options for the tab. It is possible to select and change the view, from those available, but not to create a new one. If you change the layout of a column, for example by changing its header, this will be applied to the associated view of all customisations.
Each time you want to print accounts, select the customisation you have created.
Page setup
In Page setup, you can specify the margins & other settings of the page.
Accounts
You can access this windows by choosing the Reports menu > Account cards command (see the Account cards page).
Accounts
The list of all available accounts appears.
Select all
By activating this option, all the accounts that are part of the Chart of accounts are automatically selected.
If you wish to print one or more account cards activate only the desired accounts.
Selecting accounts with the mouse
- Clicking on the account name selects the account, and if a previous selection was made, it is deselected.
- Clicking on the account tick box (within the checkbox) selects/deselects the account and the previous selection remains unchanged.
- To select multiple adjacent accounts at the same time, simply click on the first one, hold down the left mouse button, move the mouse over the list to select the desired accounts, and press the spacebar.
- To select multiple non-adjacent accounts, hold down the Ctrl key (or Cmd on Mac), and use the left mouse button to move over the list, selecting the desired accounts, and then press the spacebar.
Selecting accounts with the keyboard
- You can navigate the account list using the up/down arrow keys, and select/deselect an account by pressing the spacebar.
Search
The option allows the immediate search of one or more accounts. The account number or description of the account is entered in the box; the program filters the accounts using the search values entered.
You can also enter multiple accounts to be displayed simultaneously, or combine accounts and segments (see developer explanations):
- 1000|1001 will display the transactions for account 1000 and 1001.
- 1000:01 will display all transactions of the 1000 account with the 01 segment.
Sort by account number
If this option is activated, the accounts are sorted according to the selection applied in the Filter (at the bottom of the dialog box). If, for example, there are accounts, cost centers or segments with abbreviations, they are listed in alphabetical order.
Filter
This function allows you to filter all account cards or just a selection, specifically:
- Accounts, cost centre and segments - if no selection is made they are filtered by default
- Accounts/categories (existing cost centres and segments are excluded)
- Accounts, Cost centres (only segments are excluded)
- Cost centres (accounts and/or categories and segments are excluded)
- Segments (accounts and/or categories and cost centres are excluded)
- Groups - existing groups will be shown - you need to select the ones to be printed
- Classes - all classes will be shown - you need to select the ones to be printed.
Actual or budget transactions
When you have activated the Budget table in your file, you may select:
- Actual transactions
The entries in the Transaction tab will be processed.
- Budget transactions
The entries in the Budget tab will be processed.
If the Budget table is not present, but amounts have been entered in the Budget column of the Accounts table (Budget View), these amounts are converted into monthly amounts. The division performed by the program is based on the start and end date of the accounting period (if the duration is 1 year, the division will be into 12 monthly installments).
Account card 00 - Differences in accounting transactions
When there are discrepancies in the transactions (see Debit - Credit Difference error page), to identify where the error is located, the account statement for Group 00 is displayed (or the statement for the group in your chart of accounts that includes all accounts from Class 1, 2, 3, and 4).
You will have a list of all transactions with the successive balances, which after each entering should equal zero. The row where the balance is not at zero contains the error.
Viewing the Details of transactions
Using the Group 00 account statement, it is also possible to view the details of the transactions.
Once you have selected the Group 00 account statement, the list of transactions will appear. Select any column, double-click on the column, and a screen will appear to select the visible columns. Select the "TransactionAmount" column. After making this change, the screen opened from the Group 00 account statement will display the "Transaction" column in CHF with detailed specific amounts.
Double-click on a column:
Select the "MovementAmount" column
Next, a new column "Movement CHF" will be added, which will display the details of the amounts of individual transactions. This modification can be useful, for example, when a transaction includes VAT, and you want to see the details of that transaction while keeping the VAT separate.
Invoice recording with VAT:
Details of the invoice recording with VAT, with Account Card 00 and the "MovementAmount" column activated:
Period Accounting Card
The explanations of the Period tab are the same as those for the Enhanced Balance Sheet with Groups, tab Period.
Options tab
Via the Reports → Account cards → Options menu you can access the various options that can be included or excluded from displaying and printing.
Lines before end of page
This function was created in order to avoid printing an account partially on one page and partially on the following. If the account card to be printed doesn't have at least a number of rows corresponding to the number input in this field, printing the whole card will be moved to the next page.
One account per page
By activating this function, each card will be printed on a separate page (even those with few transactions).
Repeat column's headers
By activating this function, the column headers will be repeated for each account, within the page.
Include accounts with no transactions
By activating this function, cards without transactions will be printed as well.
View
You can select the columns view to be included in the account cards display and printout:
- Base
- VAT
- Cost centers
- Expiration dates
If no criteria are specified the program will keep the order present in the Transactions table.
Sort column
In the account card, transactions can be sorted according to different data criteria:
- Document date
- Value date
- Expiration date
- Payment date