I just don’t get the Revaluation variances in the AR Reconciliation
Exchange rate variances can be confusing at the best of times, but with the advent of realised and unrealised gains/losses, they can be a minefield.
So, what are realised and unrealised exchange rate gains or losses?
Realised exchange gains occur when a company completes a transaction in a foreign currency and the exchange rate has changed in its favour by the time the transaction is settled.
Unrealised exchange gains, on the other hand, refer to fluctuations in the value of a company’s foreign currency assets or liabilities that have not yet been settled.
It is clear to see that losses occur when the exchange rates are not in the company’s favour.

How are these gains and losses managed in SYSPRO?
Many companies ensure that the Balance Sheet is a true reflection of the position of the company at a given period end. In order to best reflect the values of foreign transactions in the Balance Sheet, SYSPRO has provided revaluation functionality in the financial modules.
Thus, at the end of a financial period, Accounts Payable, Accounts Receivable and Cash Book foreign transactions can be revalued under the control of the SYSPRO sub-ledger. All resulting gains/losses are posted to the ‘Unrealised’ exchange rate control account.
Come time when the transaction is paid or reconciled to the Bank Statement, all such revaluation entries are reversed, and the actual exchange rate gain/loss is posted to the ‘Realised’ exchange rate control account.
It’s important to consult with a financial professional and/or SYSPRO consultant to ensure that your transactions are being recorded accurately and in accordance with accounting standards and best practices.
Revaluation entries in DataRapt
We are going to focus on unrealised exchange gains, and how they affect DataRapt when the foreign transaction is finally settled.
DataRapt recognises all revaluation entries as well as the reversal of these entries when payment is made, or a bank transaction reconciled. However, in the Accounts Receivable module, these adjustments can go awry.
Probably the most common scenario – there are detailed invoice or credit note on the detail tabs, but just one or two lines on the Revaluations tab. When you accumulate these by customer, you see that there are only a few cents difference between the transactions, but they remain in the reconciliation and cannot be added to a contra group.
Help is at hand. There is a DataRapt Setup option that allows you to accumulate these variances by customer if they accumulate to less than a value that you are able to define.
A little more complex are the revaluation and reversal entries. In some, fairly rare, cases, SYSPRO adjusts for the reversal of previous revaluations, but uses a combination of the payment and invoice rates to calculate the transaction exchange rate difference.
When this does occur, it usually relates to transactions where the payment function is used to offset invoices and credit notes, and only when the resulting invoice balance is zero.
DataRapt picks up the difference between the invoice and payment rates, and reflects this as an exchange rate variance. SYSPRO also self corrects, but only when the Accounts Receivable Balance function is performed.
That’s great, but how do I correct the variances?
We have already covered the ‘rats and mice’ variances by using the setup option. The gains/losses that arise out of payment vs invoice rates should be corrected by process a general journal entry between the control account and the exchange rate variance account. If you are as pedantic as we are, you could split the correcting entry between realised and unrealised gains/losses.
Of course, if all else fails, contact us. That’s what we are here for.



