Multi-currency accounting

This documentation is outdated

The most complete and up-to-date documentation is the one of Banana Accounting Plus: Try it now

In this article

Multi-currency accounting is based on the double-entry accounting method and can also manage accounts and transactions in foreign currencies.

Many topics of the multicurrency accounting are the same as the double-entry accounting. In order to find missing lessons or in-depth information, we advice you to consult our internet pages on the Double-entry accounting.

Characteristics 

  • Manages the accounts also in foreign currency.
  • Calculates the conversion automatically, based on the exchange rate inserted in the Exchange rate table
  • Calculates the exchange rate differences automatically
  • Offers Balance Sheets and Profit and Loss Statements in a second currency as well.

In order to change from a double-entry accounting file to a multi-currency accounting file, check the Convert to new file command

Information

Chart of accounts, file properties and exchange rates table
We suggest to choose one of the already configured examples and to personalize it according to your needs. Please note that the chart of accounts must include the account for profit and loss from exchange rate variation and there must be accounts in foreign currencies.


Transactions
Accounting transactions must be entered in the same way as the double-entry accounting transactions


Printouts


Conversion

In order to add multicurrency features to a double entry accounting file, please visit the Convert to new file page.

If you want to change the basic currency of an existing accounting file (for example if your accounting file is in EUR and you want it in USD), proceed as follows:

  • Save the file under a different name
  • In the File properties
    • Indicate the new basic currency
    • Delete the reference to the previous year file
  • In the Exchange rates table enter the exchange rates referred to the basic currency
    • If there are many transactions to be converted, in the exchange table you can enter intermediate exchange rates (for examble for each month, indicating the beginning of the month's date). The program will use the historic exchange rate in the transactions.
  • In the accounting plan
    • Replace the old currency with the new one
      You can use the Find and Replace function also (selected area only)
    • If there are opening balances, you need to re-enter them in the new currency
    • Also the Previous year balance, budget and other columns must be converted
  • In the Transactions table
    If there are trasactions, you need to correct them row by row:
    • For those transactions that are already in the right currency, with the F6 key the program recalculates the amount in the new basic currency.
    • For other transactions you need to enter the right amount tin the basic currency and then press F6
  • In the Budget table
    Proceed just as in the Transactions table
  • Use the Check accounting command, fix possible errors, and keep using the Check accounting command until there are no more error messages.

 

Share this article: Twitter | Facebook | LinkedIn | Email