Exchange gain or loss for invoices in foreign currencies

English Template (4) (1).png
If you issue an invoice in a currency different from your company’s base currency, the amount due may change based on the exchange rate at the time of payment compared to the rate on the invoice date

This variation called an exchange gain or loss and  it arises when the exchange rate used at the time of invoicing differs from the rate in effect at the time of payment.
|

Traditional accounting systems often require manual journal entries to capture these differences and ensure accurate financial reports but Wafeq handles this automatically. 
As soon as you record the payment, the system calculates the gain or loss and posts it to the Exchange Gain or Loss account.

 

In this guide, we walk through a practical example:
We’ll issue an invoice in Egyptian Pounds (EGP), while the base currency of the company is Saudi Riyals (SAR).
We’ll then record the payment around 20 days later, at which point the exchange rate has changed, resulting in an exchange difference that Wafeq automatically recognizes in the journal entry.


Let’s follow the steps, from creating the invoice to posting  the payment.

 

Issuing an invoice in a foreign currency

To issue the invoice, go to “Sales” from the main menu, select “Sales Invoices”, then click on the “Create” button.

  • Select the relevant customer, and in the “Currency” field, choose "EGP - ج.م".

  • Enter the invoice details , then click “Save.”

Once saved, the invoice amount will automatically be converted to Saudi Riyals (SAR) based on the exchange rate on the invoice date.

 

1.png

 

Recording a payment in the company’s base currency (SAR):

After approximately 20 days—during which the exchange rate have changed—go to “Customer payments” from the main menu, then click on “Record payment”

 

2.png

 

  • In the "Customer" field, select the same customer the invoice was issued to.

  • Under "Paid through", choose the account where the payment will be recorded.

  • Enter the "amount received" in SAR, along with the payment "date" and an optional "description", if applicable.

 
Convert the invoice amount in the foreign currency (in this case, 1,000,000 EGP) to your base currency (SAR) using the exchange rate on the payment date, then enter the resulting amount in "Amount Received".

 

3.png

 

Select the payment type as "Invoices Payment".

Then, click on the "Add unpaid invoices" button.

 

4.png

 

Select the invoice we previously created in EGP, then click on the "Add" button.

 

5.png

 

Make sure the paid amount fully covers the invoice and the remaining balance is zero.

You can then download a PDF copy of the payment by clicking on the "Download receipt PDF" button, or save the transaction by clicking "Save".

 

6.png

 

Viewing the exchange gain or loss

Go to "Sales" from the main menu, then click on "Sales Invoices".
Make sure you're in "Sheet" view, and click on the invoice you’ve already recorded a payment for.

 
7.png

 

You'll find the Payments section.
Click on the book icon to view the journal entry generated by the payment.

8.png

 

The journal entry will automatically include a line showing the exchange gain or loss resulting from the difference in exchange rates between the invoice date and the payment date.
In our example, an exchange gain of SAR 1,674.67 was recorded.

 
The company’s base currency is Saudi Riyal (SAR), while the invoice was issued to the client in Egyptian Pounds (EGP).

When the invoice was created, Wafeq recorded the amount in EGP and calculated its equivalent in SAR based on the exchange rate on the invoice date, which in our case was:
1 EGP = 0.07409 SAR


After some days, the company received the payment from the client. On that payment date, the exchange rate had changed to:
1 EGP = 0.07576 SAR


Which means:
The invoice amount was 1,000,000 EGP
At the time of invoicing, that amount was equal to 74,091.78 SAR
At the time of payment, the same amount was equal to 75,766.45 SAR

The difference = 1,674.67 SAR, which is recognized as an Exchange Gain, since it resulted in an extra revenue for the company.

 

9.png

 

 

 

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.