How is the FX Difference Journal calculated when you pay an invoice in a different currency, and when is it not created?
The system creates two separate journals dated on the payment date: the usual payment journal for the amount actually paid in the Payment Currency, and a second journal named FX Difference Journal that records the Difference between the value of the Total Paid in the system currency and the value of the Adjustment Value at the original Invoice Price.
- Both journals appear on the payment Page under Related Journals.
| Document | Positive Difference | Negative Difference |
|---|---|---|
| Sales Invoice payment | Debit Client / Credit Foreign Exchange Gains and Losses | Debit Foreign Exchange Gains and Losses / Credit Client |
| Purchase Invoice payment | Credit Supplier / Debit Foreign Exchange Gains and Losses | Debit Supplier / Credit Foreign Exchange Gains and Losses |
| The refunded Invoice and Purchase Refund | The direction is the reverse of a regular document payment | Reverse direction |
Note: The Difference journal is not created if the Difference is less than the Smallest unit of the base Account Currency, and it is deleted if the payment is edited and the Difference becomes zero.
Which rate is used to calculate the currency Difference: the Invoice rate or the payment day rate?
The Difference is calculated by comparing two rates: the rate from the payment to the Account Currency (entered in the payment or the system rate on its date), and the rate from the Invoice to the Account Currency at which the Invoice was recorded. The Invoice rate is taken in this order: the manual rate saved on the Invoice, then the rate of the Invoice journal, then the system rate On invoice date. For a Purchase Refund, the rate of the original Purchase Invoice is used.
| Document | Document rate used |
|---|---|
| Sales Invoice | The manual rate on the Invoice or the rate of its journal |
| Purchase Invoice | The manual rate (from the Currency Conversion Rate setting) or the rate of its journal |
| Purchase Refund | The rate of the original Purchase Invoice |
Note: For this reason, editing the Invoice rate changes the currency Difference in payments saved after the edit.
Why was no FX Difference Journal created for a payment in a different currency?
The FX Difference Journal is created only if the Difference between the value of the Total Paid in the Account Currency and the value of the Adjustment Value at the Invoice rate is greater than or equals the Smallest unit of your base Account Currency (for example, 0.01 SAR). If the Difference is smaller than that, only the payment journal is created. When you edit a payment that had a Difference journal and its Difference becomes zero, the Difference journal is deleted automatically.
| Reason | What happens |
|---|---|
| The payment rate equals the Invoice rate | No Difference; no journal |
| The Difference is less than 0.01 (or the Smallest unit) | It is ignored; no journal |
| The payment is in the Invoice Currency and the Invoice is in the Account Currency | It is not a payment in a different currency; no journal |
| The Accounting app is Disabled | No journals are posted at all |
Note: You can review the journals under Related Journals on the payment Page.