Utilities Extensions for accounting

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:

  1. Open an accounting file.
  2. From the Extensions menu select Calculate interest on account (exact days 365/365).
  3. Enter the account number.
  4. Select the period.
  5. Enter the interest rate on debit balance.
  6. 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.

domenico
URL Stable release
https://raw.githubusercontent.com/BananaAccounting/General/master/SampleApps/ch.banana.script.calcinterest.js
URL Development
https://github.com/BananaAccounting/General/tree/master/SampleApps
Short Description
Compute the interest debit and credit for the account and rate you specify, based on the exact days. Suitable to calculate interest pro rata.
Country
Universal
Publisher
Banana.ch
Extension type
Productivity
Help ID
ch.banana.script.calcinterest.js
Release Date Stable

Compare current with other accounting file

Compare current with other accounting file

Install 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:

  1. Open an accounting file.
  2. From the Extensions menu select Compare current with other accounting file.
  3. Select a second accounting file to compare.

The differences are reported as messages, when you click on it you go to the row.

 

domenico
URL Stable release
https://raw.githubusercontent.com/BananaAccounting/General/master/SampleApps/comparestwoaccountingfiles.js
URL Development
https://github.com/BananaAccounting/General
Short Description
It compares the current open accounting file with an other one and reports differences between the two files.
Country
Universal
Publisher
Banana.ch
Extension type
Productivity
Help ID
ch.banana.apps.comparestwoaccountingfiles

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:

  1. Open an accounting file.
  2. From the menu Account1 select Import to accounting.
  3. As import option select Transactions.
  4. From the list select the Create invoice transactions from member fee extension.
  5. In the File name field, click Browse and select the current open accounting file.
  6. Click OK.
  7. Enter the invoice start number.
  8. Enter the revenue account.
  9. Enter the transaction description.
  10. 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.

 

ivan
URL Stable release
https://raw.githubusercontent.com/BananaAccounting/General/master/SampleApps/ch.banana.script.invoices.frommemberfee.js
Short Description
This extension creates invoice transactions, taking all accounts in the accounting table that have a value in the column MemberFee.
Country
Universal
Publisher
Banana.ch
Extension type
Import
Help ID
ch.banana.script.invoices.frommemberfee
Release Date Stable

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:

  1. Open the accounting file.
  2. From the menu Extensions select Create invoice transactions from member fee (Banana+).
  3. In the Settings dialogue:
    1. 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.
    2. Set the starting invoice number.
      The first invoice starts whit this number, while all others invoices use progressive numbers.
  4. The program shows a dialog with all the invoice transactions that will be added.
  5. 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 ";" 

 

ivan
URL Stable release
https://raw.githubusercontent.com/BananaAccounting/Universal/master/report/association/invoicesfrommemberfee/ch.banana.uni.app.invoicesfrommemberfee.js
Short Description
This extension creates invoice transactions, taking all cost centers in the accounting table that have a value in the column MemberFee.
Country
Universal
Publisher
Banana.ch
Extension type
Productivity
Help ID
ch.banana.uni.app.invoicesfrommemberfee
Release Date Stable

Duplicate transaction checking

Duplicate transaction checking

Install 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:

  1. Open an accounting file.
  2. 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.

claudia
URL Stable release
https://raw.githubusercontent.com/BananaAccounting/General/master/SampleApps/ch.banana.apps.check.duplicate.transaction.js
URL Development
https://github.com/BananaAccounting/General/tree/master/SampleApps
Short Description
This app checks for duplicate transactions.
Country
Universal
Publisher
Banana.ch
Extension type
Productivity
Help ID
ch.banana.apps.check.duplicate.transaction

Reconcile account with mt940/ISO20022 file

Reconcile account with mt940/ISO20022 file

This 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:

  1. Open the accounting file.
  2. From the Extensions menu select the Reconcile account with mt940/ISO20022 file.
  3. Select the electronic bank statement (MT940 or ISO20022).
  4. Enter the account number.

A window with results is displayed. You can copy, save and print the results.

 

domenico
URL Stable release
https://github.com/BananaAccounting/General/raw/master/SampleApps/reconcylebankaccount.js
URL Development
https://github.com/BananaAccounting/General/tree/master/SampleApps
Country
Universal
Publisher
Banana.ch
Extension type
Productivity
Help ID
ch.banana.report.comparedailybalance

Update Dates in the accounting file

Update Dates in the accounting file

In 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:

  1. Open an accounting file.
  2. From the Extensions menu select the Update Dates in the accounting file.
  3. A confirmation window dialogue shows all the sections and tables of the accounting where dates will be changed.
  4. Confirm with OK to apply the changes to the accounting file.

 

claudia
URL Stable release
https://github.com/BananaAccounting/General/raw/master/SampleApps/ch.banana.apps.documentchange.dates.js
URL Development
https://github.com/BananaAccounting/General/tree/master/SampleApps
Short Description
This extension updates the opening and closure accounting dates of the open document with the current year, and also updates the rows dates of the Transaction and the Budget tables.
Country
Universal
Publisher
Banana.ch
Extension type
Productivity
Help ID
ch.banana.apps.documentchange.dates.js