Utilities Extensions for accounting
This section covers general utility extensions for accounting.
Table of contents
- Compare current with other accounting file
- Calculate interest on account (exact days 365/365)
- Update Dates in the accounting file
- Invoice from member fee (Banana 9)
- Invoice from member fee (Banana+)
- Printing receipts from cash book transactions
- Reconcile account with mt940/ISO20022 file
- Duplicate transaction checking
Calculate interest on account (exact days 365/365)
Calculate interest on account (exact days 365/365)Install the extension
To install the extension:
- Open Banana Accounting Plus.
- Menu Extensions > Manage Extensions.
- In the search field enter Calculate interest on account (exact days 365/365).
- From the extensions list select Calculate interest on account (exact days 365/365).
- Select the extension and click Install.
- Click Close to close the window.
Create the report
To creare the report:
- Open an accounting file.
- From the Extensions menu select Calculate interest on account (exact days 365/365).
- Enter the account number.
- Select the period.
- Enter the interest rate on debit balance.
- Enter the interest rate on credit balance.
A window with results is displayed. You can copy, save and print the results. The transactions list can be paste into the table Transactions.
Compare current with other accounting file
Compare current with other accounting fileInstall the extension
To install the extension:
- Open Banana Accounting Plus.
- Menu Extensions > Manage Extensions.
- In the search field enter Compare current with other accounting file.
- From the extensions list select Compare current with other accounting file.
- Select the extension and click Install.
- Click Close to close the window.
Compare two accounting files
To compare two accounting files:
- Open an accounting file.
- From the Extensions menu select Compare current with other accounting file.
- Select a second accounting file to compare.
The differences are reported as messages, when you click on it you go to the row.

Create invoice transactions from member fee (Banana 9)
Create invoice transactions from member fee (Banana 9)Prerequisites
- Double-entry accounting file with normal accounts for members/customers is required.
Install the extension
To install the extension:
- Open Banana Accounting.
- Menu Extensions > Manage Extensions.
- In the search field enter Create invoice transactions from member fee (Banana 9).
- From the extensions list select Create invoice transactions from member fee (Banana 9).
- Select the extension and click Install.
- Click Close to close the window.
Add the MemberFee column
- Open the Accounts table (Address view).
- Activate the MemberFee column (the column already exists, it just needs to be activated).
- For each member/customer use the MemberFee column to enter the invoice amount.
Create invoice transactions
To creare the invoice transactions:
- Open an accounting file.
- From the menu Account1 select Import to accounting.
- As import option select Transactions.
- From the list select the Create invoice transactions from member fee extension.
- In the File name field, click Browse and select the current open accounting file.
- Click OK.
- Enter the invoice start number.
- Enter the revenue account.
- Enter the transaction description.
- The Import transactions opens, confirm with OK.
The program creates the invoice transactions for all the member/customer that has an amount in the MemberFee column of the table Accounts.
Create invoice transactions from member fee (Banana+)
Create invoice transactions from member fee (Banana+)Prerequisites
- Banana Accounting Plus.
- Double entry accounting file with Cost Centers accounts (Cc1, Cc2, Cc3) for members/customers is required.
Install the extension
To install the extension:
- Open Banana Accounting Plus.
- Menu Extensions > Manage Extensions.
- In the search field enter Create invoice transactions from member fee (Banana+).
- From the extensions list select Create invoice transactions from member fee (Banana+).
- Select the extension and click Install.
- Click Close to close the window.
Add the MemberFee column
- Open the Accounts table (Address view).
- Activate the MemberFee column (the column already exists, it just needs to be activated).
- For each member/customer use the MemberFee column to enter the invoice amount.
Create invoice transactions
To creare the invoice transactions:
- Open the accounting file.
- From the menu Extensions select Create invoice transactions from member fee (Banana+).
- In the Settings dialogue:
- Set the invoice description.
The text that is displayed on the invoice. This text is automatically followed by first and last name or company name. - Set the starting invoice number.
The first invoice starts whit this number, while all others invoices use progressive numbers.
- Set the invoice description.
- The program shows a dialog with all the invoice transactions that will be added.
- Confirm with OK.
The program creates the invoice transactions for all the members/customers that have an amount in the MemberFee column of the table Accounts.
- Date: the date of the current day.
- Description: text entered in the settings followed by first and last name or company name.
- Amount: the amount defined in the MemberFee column of the Accounts table.
- Cc1 / Cc2 / Cc3: the Cost Center account of the member/customer:
- Cc1 when using cost centers that starts with "."
- Cc2 when using cost centers that starts with ","
- Cc3 when using cost centers that starts with ";"
Duplicate transaction checking
Duplicate transaction checkingInstall the extension
To install the extension:
- Open Banana Accounting Plus.
- Menu Extensions > Manage Extensions.
- In the search field enter Duplicate transaction checking.
- From the extensions list select Duplicate transaction checking.
- Select the extension and click Install.
- Click Close to close the window.
Check for duplicate transactions
To check for duplicate transactions:
- Open an accounting file.
- From the Extensions menu select Duplicate transaction checking.
A transaction is duplicate if another transaction exists with the same amount, the same credit account and the same debit account in a time laps of 3 days.
If a duplicate transaction is found, a message is displayed to the user.
It is possible to skip the check for a transaction: just add a column with the name 'SkipDuplicateCheck' and insert any value (ie.: 'x') to the transaction to skip.
Reconcile account with mt940/ISO20022 file
Reconcile account with mt940/ISO20022 fileThis extension takes as input an electronic bank statemant (MT940 or ISO20022) and compare day by day with the account statements and shows differences.
It is very usefull for finding transactions not recordered or incorrectly recorded.
Install the extension
To install the extension:
- Open Banana Accounting Plus.
- Menu Extensions > Manage Extensions.
- In the search field enter Reconcile account with mt940/ISO20022 file.
- From the extensions list select Reconcile account with mt940/ISO20022 file.
- Select the extension and click Install.
- Click Close to close the window.
Create the report
To creare the report:
- Open the accounting file.
- From the Extensions menu select the Reconcile account with mt940/ISO20022 file.
- Select the electronic bank statement (MT940 or ISO20022).
- Enter the account number.
A window with results is displayed. You can copy, save and print the results.
Update Dates in the accounting file
Update Dates in the accounting fileIn order to change the accounting data, the extension uses the Document Change API. For more information visit How-to update Accounting Dates using Document Change.
Install the extension
To install the extension:
- Open Banana Accounting Plus.
- Menu Extensions > Manage Extensions.
- In the search field enter Update Dates in the accounting file.
- From the extensions list select Update Dates in the accounting file.
- Select the extension and click Install.
- Click Close to close the window.
Change accounting dates
To change accounting dates using the extension:
- Open an accounting file.
- From the Extensions menu select the Update Dates in the accounting file.
- A confirmation window dialogue shows all the sections and tables of the accounting where dates will be changed.
- Confirm with OK to apply the changes to the accounting file.