l2_banner_2

How do you manage foreign currency transactions?

(or small accounting homework)

With the arrival of free trade and globalization more generally, even small companies began to deal with foreign business partners.

Accountants therefore began to invent all kinds of methods to enter foreign currency transactions into computerized accounting systems that had not been designed for this purpose. These methods worked pretty well as long as we only had to recognize the US Dollar. But when it came to trading in other currencies, these simple management tips at first quickly became a nightmare to apply.

We suggest here an easy method to implement and follow and moreover correct accounting.

First some basic assumptions:

  • Only balance sheet accounts should reflect changes in exchange rates over time.
  • The income statements, for their part, must reflect the value of the transaction in Canadian Dollars at the rate in effect at the time of the transaction and not change.
  • Exchange rates vary so often (but very little) we need a method applicable even if we do not change the calculations for rate every day!
  • However, the method should be flexible enough to recognize that a sales transaction (for example) may be recorded at one rate but cashed at another a few weeks later.

If you agree, lets continue ...

Let us first add to our chart of accounts a so-called "Conversion" account for each balance sheet account that must support a foreign currency. Let this account in the Charter of Account immediately after the basic account. The purpose of this account is to bring in Canadian Dollar a basic account expressed in foreign currency (So much for the financial statements!).

Consider the example of a company that has a Canadian $ bank account, a USD Currency Bank account, and a USD Currency Customer account. We would end up with a partial charter as follows:

GL Description
1000 Bank CAD$
1100 Bank USD$
1101 Bank Conversion USD$
1300 Accounts Receivable (AR) USD$
1301 Accounts Receivable Conversion USD$
5000 Income CAD$
9000 Gain or Loss on EXCHANGE Variation CAD$

Now let's take a look at the recording of transactions and their effect on the trial balance. (We are the 1st of the month and the exchange rate is 1.50).

Recording of a sale transaction in USD $ with a value of 100 USD $:

GL Description DT
5000 Income 150.00 CT
1300 AR USD$ 100.00 DT
1301 Conv. AR USD$ 50.00 DT

Recording of a partial deposit of $ 40 on the 10th of the month. The rate is 1.48.

GL Description DT
1100 Bank USD$ 40.00 DT
1101 Conv. Bank USD$ 19.20 DT
1300 AR USD$ 40.00 CT
1301 Conv. AR USD$ 19.20 CT

The trial balance now reads as follows:

GL Description DT CT
1100 Bank USD$ 40.00
1101 Conv. Bank USD$ 19.20
1300 AR USD$ 60.00
1301 Conv. AR USD$ 30.80
5000 Income 150.00

At the end of the month the currency USD trades at 1.49. So let's make the monthly entry that will adjust the balance sheet accounts.

GL Description DT
1101 Conv. Bank USD$ .40 DT
1301 Conv. AR USD$ 1.40 CT
9000 Gain or Loss/Exchange Rate 1.00 dt

We arrive at the following final Balance Sheet:

GL Description DT CT
1100 Bank USD$ 40.00
1101 Conv. Bank USD$ 19.60
1300 AR USD$ 60.00
1301 Conv. AR USD$ 29.40
5000 Income 150.00
9000 Gain Loss/Exchange rate 1.00

Conclusion

The suggested approach has important advantages:

  • The currency account presents the transactions without any manipulation.
  • We can always have a correct idea of the value in Canadian Dollars of our balance sheet accounts.
  • It allows (by calculating the gain or loss on rate changes) to release the consequences of owning assets in foreign currencies.

At DCi Software, we have automated this recording method. The user only has to choose the currency of the document to be saved and any entry in conversion accounts is done automatically according to the exchange rate of the currency (currencies) then in effect. It is therefore possible, even trivial, to assign several accounts linked to different currencies in the same record!

TO DOWNLOAD

Manage Foreign Currency