Manage invoices and make a payment in a multi-currencies system

Requirements

This tutorial requires the installation of the following applications/modules:

In this article, Viindoo will show you how to manage foreign currency invoices and payments. However, before that you need to enable the multi-currencies feature, activate other currencies, and update their exchange rates.

To better understand, we will use the below exchange rate to figure out and do some examples as follow:

Exchange rates Viindoo

The foreign currency invoices in Viindoo

First of all, you need to know how to create a customer invoice and how to create a vendor bill.

After that, you can create a foreign currency invoice in two ways as below:

  • Method 01: If your Company manages a Journal for each currency.

    • Create a Journal for foreign currency.

    • On the invoice, select the journal configured in your desired foreign currency.

    Choose the Journal in invoices Viindoo
  • Method 02: If your Company manages a Journal for all of currencies.

    • Use the default Journal, choose a foreign currency right on this form.

    Choose the foreign currency at invoice form Viindoo

The exchange rate from the foreign currency to your company’s main currency will be decided based on the following rules:

  • Customer invoices: Based on the buying rate.

    For example: On 22/03/2022, create an invoice for DEF Company with a value of 100 USD, the buying rate will be used automatically is 22.750 VND/USD:

    Exchange rate in customer invoices Viindoo
  • Vendor Bills: Based on the selling rate.

    For example: On 21/03/2022, create a vendor bill of ABC Company with a value of 100 USD, the selling rate will be used automatically is 22.960 VND/USD:

    Exchange rate in vendor bills Viindoo

Payment for Vendor bills

Payment by the main currency of the company

Proceed a payment in the company’s main currency for a vendor bill in USD with ABC Company.

In the vendor bill form, press Register Payment, on the pop-up, choose the payment’s currency is VND, the total value in VND is equal to the recorded amount.

Doing a payment for vendor bills by the main currency of company Viindoo

After pressing Create Payment, the status of the vendor bill will be changed to Paid.

The paid payment by the main currency of company Viindoo

Navigate to Journal Entry to see: The payment entries and the exchange rate difference entries.

Note

The exchange rate difference entry will be generated automatically when any transaction happens.

The generated entry when do payment by the company’s main currency Viindoo

In this example: The exchange rate on the bill date is higher than the one on the date of payment, therefore, the entry for recording the loss of exchange rate difference will be as follows:

The details of the exchange rate difference entry Viindoo

Payment in foreign currency

Do the same steps as paying by the company’s main currency, but choose the foreign currency in payment.

Payment in foreign currency Viindoo

Once done, navigate to Journal Entry to see: The payment entry and the exchange rate difference entry.

The generated entry in foreign currency Viindoo

In this situation: The exchange rate on the bill date is higher than the one on the payment date, therefore, the entry of gaining exchange rate difference will be:

The details of the exchange difference entry Viindoo

Customer’s payment

Receiving payment in the company’s main currency

For example, on 21/03/2022, DEF Company made a payment in USD to your VND’s account.

On the Customer invoice, click Register Payment, the register payment window appears. Here, you choose the payment currency is VND and the payment date, the total value of VND is taken exactly as the debited debt.

Customer pays to the company's account Viindoo

Press Create Payment, and the status of the customer’s invoice will be Paid.

Customer's invoices in Paid status Viindoo

In Journal Entry, you can view related derivatives.

The details of receiving money in the main currency Viindoo
  • Payment journal entry:

Payment journal entry
  • Exchange rate difference entry: The exchange rate on the invoice date is smaller than the one on the payment date, so, the entry of losing exchange rate difference will be:

The difference entry of receiving money Viindoo

Receiving payment in foreign currency

Similar to previous scenarios, but this time, you need to record the payment from customer DEF Company to your foreign currency account in USD:

Customer pay to the foreign currency's account Viindoo

Once done, navigate to Journal Entry to see the payment and the different exchange rate entries.

The entry of paying in foreign currency Viindoo

In this example: The exchange rate on the invoice date is smaller than the one on the payment date, the customer paid in foreign currency and the entry for the gain exchange rate difference will be:

The details of entry of receiving payment in foreign currency Viindoo

Note

In normal transactions, the currency used in payment is the same as the one used in invoices and contracts. However, if the payment is done via payment acquirers , the currency needs to be supported by them. Due to this reason, there are situations where the currency used on invoices is different from the one used on payments.