Switching the Accounting Method for Foreign Currency Translation
In this topic, we use an example to explain the procedure for switching the gain/loss accounting method for currency translation. More...
- Sample Company Ltd is a multicurrency company. Its functional currency is Canadian dollars.
In the fiscal year 2019, Sample Company Ltd used the Realized and Unrealized Gain/Loss accounting method. The company revalues balances of monetary accounts once a year.
- There is only one US customer, and, as of December 31, 2019, their balance in USD is 1,000.00 with CAD equivalent of 1,500.00.
- Sample Company Ltd maintains a USD bank account, with a balance in the account of 5,000.00 as of December 31, 2019.
The CAD equivalent functional amount is 6,750.00.
- Sample Company Ltd wants to switch to the Recognized Gain/Loss accounting method as of January 1, 2020.
- Complete all period-end and year-end procedures.
- Run Create New Year.
Steps to take in 2019:
- In Accounts Receivable, revalue the balances of your accounts receivable.
Assume that the exchange rate on December 31, 2019 is 1 USD = 1.4000 CAD. Thus, when revaluation is performed in A/R, the following reversing G/L entry is created on December 31, 2019:
G/L Account Source Currency Functional Currency Debit Credit Debit Credit Receivables Control 0.00 0.00 0.00 100.00 Unrealized Exchange Loss 0.00 0.00 100.00 0.00 [(1.4000 x 1,000) - 1,500 = 100.00] - In General Ledger:
General Ledger > G/L Periodic Processing > Create Revaluation Batch, and then revalue the balance of USD bank accounts, using 1 USD = 1.4000 CAD as the exchange rate for Year/Period 2019-12.
The G/L revaluation creates the following reversing entry on December 31, 2019:
G/L Account Source Currency Functional Currency Debit Credit Debit Credit USD Bank 0.00 0.00 250.00 0.00 Unrealized Exchange Gain 0.00 0.00 0.00 250.00 [(5,000 x 1.4000) - 6,750 = 250.00] - General Ledger > G/L Reports >
Trial Balance Report, and then print the report.
The report shows the following entries:
G/L Account Source Currency Functional Currency Debit Credit Debit Credit USD Bank 5,000.00 7,000.00 Receivables Control 1,000.00 1,400.00 Unrealized Exchange Gain 250.00 Unrealized Exchange Loss 100.00 - General Ledger > G/L Periodic Processing > Create New Year, and then click Process.
Steps to take in 2020:
- In General Ledger, post the reversing revaluation entries created by the 2019 revaluation:
G/L Account Source Currency Functional Currency Debit Credit Debit Credit Receivables Control 0.00 0.00 100.00 0.00 Unrealized Exchange Loss 0.00 0.00 0.00 100.00 [(1.4000 x 1,000) - 1,500 = -100.00] G/L Account Source Currency Functional Currency Debit Credit Debit Credit USD Bank 0.00 0.00 100.00 250.00 Unrealized Exchange Gain 0.00 0.00 250.00 0.00 [(5,000 x 1.4000) - 6,750 = 250.00] - In Common Services:
- Open Company Profile, and then click the Options tab.
- In the Gain/Loss Accounting Method field, select Recognized Gain/Loss.
- Click Save.
- In General Ledger:
- On the G/L Accounts screen, create new accounts for Recognized Exchange Gain and Recognized Exchange Loss.
- On the Revaluation Codes screen, modify existing revaluation codes or create new ones.
- Assign the new revaluation codes to the new exchange gain and loss accounts.
- In Accounts Receivable:
- Modify existing account sets or create new account sets for the USD customers.
- Revalue the balances of your accounts receivable.
In our example, we assume that the exchange rate on January 31, 2020 is 1 USD = 1.6500 CAD. Thus, when revaluation is performed in Accounts Receivable, the following General Ledger entry is created on January 31, 2020:
G/L Account Source Currency Functional Currency Debit Credit Debit Credit Receivables Control 0.00 0.00 150.00 0.00 Exchange Gain 0.00 0.00 0.00 150.00 [(1.6500 - 1.5000) x 1,000 = -150.00]
- In General Ledger:
Revalue the balance of the USD Bank account using 1 USD = 1.6500 CAD as the exchange rate for Year/Period 2020-01. The General Ledger revaluation creates the following entry on January 31, 2020:
G/L Account Source Currency Functional Currency Debit Credit Debit Credit USD Bank 0.00 0.00 1,500.00 0.00 Exchange Gain 0.00 0.00 0.00 1,500.00 [(5,000 x 1.650) - 6,750 = -1500.00] - Print the Trial Balance report.
The multicurrency accounts display the following values for January 31, 2020:
G/L Account Source Currency Functional Currency Debit Credit Debit Credit USD Bank 5,000.00 8,250.00 Receivables Control 1,000.00 1,650.00 Unrealized Exchange Gain 0.00 Unrealized Exchange Loss 0.00 Exchange Gain 1,650.00 Exchange Loss 0.00 [(5,000 + 1,000) x 1.6500 - (1,500 + 6,750) = 1,650.00]
- At the transaction date, each asset, liability, revenue, or expense arising from a foreign currency transaction of the recording entity should be translated into functional currency using the exchange rate in effect at the date of the transaction.
- At each balance sheet date, recorded balances of monetary assets and liabilities that are denominated in a currency other than the functional currency of the recording entity should be adjusted to reflect the current (spot) exchange rate. The resulting exchange gain or loss should be included (that is, recognized) in the net income for the current period.