Currency Revaluation and Translation Example
This example shows how adjustment values are calculated for home and dual currency when performing a currency revaluation. For simplicity, the example shows values resulting from a single sales invoice.
Company
Company Name | Home Currency | Dual Currency |
---|---|---|
Atkins GB | GBP | EUR |
Sales Invoice
Invoice Currency | Invoice Date | Invoice Exchange Rate (Doc to Home) |
Dual Exchange Rate (Home to Dual) |
Invoice Line Net Value | Tax Value | Invoice Total |
---|---|---|---|---|---|---|
USD | 01/01/2014 | 2 | 1.2 | $100 | $17.50 | $117.50 |
Transaction Line Items
Line Type | GLA | GLA Allows Revaluation? | Doc Value | Home Exchange Rate | Home Value | Dual Exchange Rate | Dual Value |
---|---|---|---|---|---|---|---|
Account | AR Control - USD (Balance Sheet) | Yes | $117.50 | 2 | £58.75 | 1.2 | €70.50 |
Analysis | Sales - Parts (Income Statement) | Yes | $100.00 | 2 | £50.00 | 1.2 | €60.00 |
Tax | VAT Output (Balance Sheet) | No | $17.50 | 2 | £8.75 | 1.2 | €10.50 |
CRV Wizard
Revaluation Criteria
- Unrealized Gains/Losses GLA = Exchange Gains/Losses UK
- Dimension Analysis = None
- Analysis = Summary Level
- Revaluation Type = Both
- GLA Selection = Automatically select all eligible GLAs
- Action on Duplicates = Exclude from selection
- Income Statement Periods = From 2014/001, To 2014/001, Posting Period 2014/001
- Balance Sheet Periods = From Opening Balances, To 2014/001, Posting Period 2014/001
Revalue
- Enable the checkboxes to revalue both Document to Home, and Home to Dual, for USD to GBP.
- Document Rate (USD to GBP): 4
- Dual Rate (GBP to EUR): 2
Transaction Line Items - Revalued
This table shows what the transaction line values would be if the new exchange rates were applied. The original transaction lines are not changed; any differences are accounted for in the resulting CRV documents.
Line Type | GLA | GLA Allows Revaluation? | Doc Value | Home Exchange Rate | Home Value | Dual Exchange Rate | Dual Value |
---|---|---|---|---|---|---|---|
Account | AR Control - USD (Balance Sheet) | Yes | $117.50 | 4 | £29.38 | 2.0 | €58.76 |
Analysis | Sales - Parts (Income Statement) | Yes | $100.00 | 4 | £25.00 | 2.0 | €50.00 |
Tax | VAT Output (Balance Sheet) | No | $17.50 | 2 | £8.75 | 1.2 | €10.50 |
CRV Documents
In this example, two CRV documents are generated: one for the Income Statement revaluation, and one for the Balance Sheet revaluation.
CRV Document 1 (Income Statement)
GLA | Home Adjustment Value | Dual Adjustment Value |
---|---|---|
Sales - Parts | 25 | 10 |
CRV Document 2 (Balance Sheet)
GLA | Home Adjustment Value | Dual Adjustment Value |
---|---|---|
AR Control - USD | 29.37 | 11.74 |
Upon posting a CRV document, the adjustment values are debited from the GLA on the transaction line item, and credited to the Unrealized Gains/Losses GLA specified in the Revaluation Criteria.
Transaction line items that have been included in an Income Statement revaluation (the line posted to the Sales - Parts GLA in this example) are updated with the CRV reference number so that they cannot be revalued again accidentally. For more information, see Error Handling in Currency Revaluation.