Record exchange rates at payments

Overview

Any company doing international trade faces the case where the payments are in a different currency.

After receiving their payments, you have the option to convert the amount into your company currency. Multi currency payment implies rates fluctuations. The rate differences are automatically recorded by Flectra.

Configuration

Enable multi-currencies

In the accounting module, Go to Configuration ‣ Settings and flag Allow multi currencies, then click on apply.

../../../../../_images/exchange_rate03.png

Configure the currency rates in Configuration ‣ Currencies. Write down the rate and make sure the currency is active.

../../../../../_images/exchange_rate02.png

In this document, the base currency is Euro and we will record payments in Dollars.

../../../../../_images/exchange_rate08.png

Tip

You can automatically fetch the currency rates from the European Central Bank or from Yahoo. Please read the document : Flectra’s multi-currency system.

Configure your journal

In order to register payments in other currencies, you have to remove the currency constraint on the journal. Go to the accounting application, Click on More on the journal and Settings.

../../../../../_images/invoice011.png

Check if the Currency field is empty or in the foreign currency in which you will register the payments. If a currency is filled in, it means that you can register payments only in this currency.

../../../../../_images/invoice021.png

Record a payment in a different currency

In the Accounting application, go to Sales ‣ Payments. Register the payment and indicate that it was done in the foreign currency. Then click on confirm.

../../../../../_images/invoice051.png

The journal entry has been posted but not allocated.

Go back to your invoice (Sales ‣ Customer Invoices) and click on Add to allocate the payment.

../../../../../_images/invoice061.png

Record a bank statement in a different currency

Create or import the bank statement of your payment. The Amount is in the company currency. There are two complementary fields, the Amount currency, which is the amount that was actually paid and the Currency in which it was paid.

../../../../../_images/invoice071.png

When reconciling it, Flectra will directly match the payment with the right Invoice. You will get the invoice price in the invoice currency and the amount in your company currency.

../../../../../_images/invoice081.png

Check the exchange rate differences

Go to Adviser ‣ Journal Entries and look for the Exchange difference journal entries. All the exchange rates differences are recorded in it.

Tip

The Exchange difference journal can be changed in your accounting settings.

Warning

In order for an exchange difference entry to be created automatically, the corresponding invoices and payments need to be fully reconciled. This means the invoices are fully paid and the payments are fully spent on invoices. If you partially pay 3 invoices from 2 payments, and the last invoice still has an amount due, there will be no exchange difference entry for any of them until that final amount is paid.