betterdocs-category-grid-icon

Finance

Accounting and Invoicing

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 CPA Books.


Configuration #

Enable multi-currencies #

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

../../../../../_images/exchange_rate03.pngConfigure the currency rates in Configuration ‣ Currencies. Write down the rate and make sure the currency is active.

../../../../../_images/exchange_rate02.pngIn this document, the base currency is Euro and we will record payments in Dollars.

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

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/exchange_rate06.pngCheck 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/exchange_rate10.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/exchange_rate05.pngThe 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/exchange_rate04.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/exchange_rate07.pngWhen reconciling it, CPA Books 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/exchange_rate09.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.

../../../../../_images/exchange_rate01.png