Revaluation of Invoice with Partial Payment
In this example, you are revaluing open balances for January between your U.S. based subsidiary and a British customer. Transactions include the following:
-
January 7 Invoice for 100 GBP
-
Rate is 2 USD to 1 GBP
-
Base currency value =200 USD
-
-
January 9 Payment for 40 GBP
-
Rate is 2.5 USD to 1 GBP
-
Base currency value =100 USD
-
100 USD credited to Accounts Receivable account
-
20 USD credited to Realized Gain/Loss account
-
-
-
February 15 Payment for 60 GBP
-
Rate is 3 USD to 1 GBP
-
Base currency value =180 USD
-
180 USD credited to Accounts Receivable account
-
60 USD credited to Realized Gain/Loss account
-
-
-
January Period Close Revaluation
-
Revalues the open balance amount of the invoice (60 GBP) at the end of the month
-
Rate on January 31 is 2.5 USD to 1 GBP
-
Variance = (Ending Rate – Transaction Rate) × Balance
-
30 USD posts to Unrealized Gain/Loss account
-
The currency revaluation transaction includes the following columns in the Details subtab under Open Receivables. These columns follow Type, Date, Payee, and Currency. Currency symbols do not appear in the transaction record but are included here to distinguish the transaction currency from the base currency.
Transaction Exchange Rate |
Ending Exchange Rate |
Balance |
Gain/Loss |
Prior Gain/Loss |
Net Gain/Loss |
---|---|---|---|---|---|
2.00 |
2.50 |
£60.00 |
$30.00 |
0.00 |
$30.00 |
When you run revaluation in February, this transaction is closed by the payment of the balance on February 15 and not subject to revaluation.