The multi-currency chart of accounts

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

The Chart of accounts of the multi-currency accounting is the same as the one of an accounting without foreign currency, except for the specifics that are indicated here below.

Basic currency

In the File and accounting properties, the basic currency should be defined and in the Exchange rate table, the foreign currencies should be defined.

In the example here below, the basic currency is the CHF, which, as can be seen, appears in the column headers with the amounts in basic currency.

Account currency

Each account has a currency symbol, which can be the same as the basic currency or a currency symbol that is different from the basic currency, indicated in the Exchange rate table.
  • The Assets and the Liabilities (Balance sheet accounts) can be in basic currency or in foreign currency.
  • The Costs (Expenses) and Revenue accounts must be in basic currency.

Explanation of the columns of the multicurrency accounting

  • The opening balance in basic currency.
    A protected column, calculated by the program based on the opening balance in currency and the opening exchange rate (exchange rate of the exchange rate table indicated in a row without date).
  • The current balance in currency.
    Calculated by the program, using the opening balance in currency and the currency amount indicated in the transaction rows. 
  • The current balance in basic currency.
    Calculated by the program, using the opening balance in basic currency and the amount in basic currency indicated in the transaction rows.
  • The calculated balance
    Is the balance in the account currency converted at the current exchange rate (exchange rate of the exchange rate table indicated in a row without date).

Assets and Liabilities accounts set up in different currencies

The accounts of the Profit and Loss Statement (Revenue and Expenses) have to be specified in basic currency.

Opening Balances

  • Before entering the opening balances, the opening exchange rates for the different currencies have to be indicated in the Exchange rate table.
    The opening exchange rate is the one indicated in the Rate Opening column in the row of the exchange rate without date.
  • The Opening balances have to be inserted in the Accounts table, in the Opening currency column, Base view. This operation needs to be done for both basic currency and foreign currency accounts.
  • The Opening Basic currency column is protected; the program automatically calculates the value in the basic currency on the basis of the opening exchange rate shown in the Exchange rate table.
  • The opening balances for the liabilities have to be entered with the minus sign (-) in front of the amount.
  • The opening balances of assets and liabilities have to balance out; for more information please visit the Recheck the accounting page.

Revaluation accounts and historical exchange rates

The exchange rates are fluctuating. The actual value of the balance in the account currency varies therefore depending on the foreign exchange fluctuation.

The basic currency amount of an account is being calculated using the opening exchange rate and the exchange rates that are indicated in the transactions. Because this value corresponds to equivalent of today's exchange rate, it is necessary to revaluate the account.
The revaluation takes place by calculating the exchange rate differences. We need to record on the account just an amount in basic currency (exchange rate difference), so that the balance in basic currency results equal to the equivalent (calculated balance)

This alignment operation is done at the end of the year, before closing the accounts, or when you want to print a balance sheet with exchange values that correspond to the current reality. See the command Create transaction for exchange rate variation.

There are accounts (related to, for example, investments) for which a so-called historic exchange rate is being used. By an historical exchange rate we mean un exchange rate that doesn't vary over time.
In order to have exchange rates that don't change, an extra currency symbol (for example EUR2) must be created in the Exchange rate table. To this currency, the same exchange rate is always being applied.

You can create as many currency symbols as you need for the different accounts with historic exchange rates.

Group totals in foreign currency

Normally, the columns with amounts in foreign currency don't have totals,as it has little sense to calculate totals for values in different currency.

If you have a group that includes only accounts in a specific currency, the currency symbol can be indicated at a group level and, in the Accounts table, the program totalizes these amounts. If there would be accounts with various currency symbols, there would be no amount indicated (the program would not report an error either).