In a previous blog, we talked about posting foreign currency transactions.
Today we are looking at a different angle. We are posting domestic transactions in a foreign legal entity (CAD in a Canadian legal entity) and consolidating them into a USA legal entity.
To do this we are going to automatically ‘translate’ the CAD transactions into USD, and also automatically ‘revalue’ the balances to reflect the current USD value.
1a. Setup Currency Exchange Rates
Like the earlier blog (Part 9 above) we will set up two new default rates as exhibited below.
General ledger > Currencies > Currency exchange rates
Create the following three Main Accounts.
Account Name Type FC reval. Exch. type Reporting type
101010 Petty Cash Asset Yes Default Default
320111 APIC, 111 Equity No blank blank
320112 APIC, 112 Equity No blank blank
Note: the Equity accounts are Foreign Currency Revaluation is set to “No” because they are non-monetary accounts. This will be discussed in further detail later in today’s blog.
Example settings for Petty Cash Main Account
Key and post two voucher like exhibited.
Note: Same CAD amounts for each voucher, but different dates (11/30 and 12/31)
Use the same ‘year’ as the rates setup above.
General ledger > Journal entries > General journals
Consolidated November.
Choose the proper dates.
Consolidate > Consolidate, online > Criteria (tab)
Consolidate > Consolidate, online > Legal entities (tab)
See your accountant to verify the Main Account settings above (FC Reval Yes/No), and the related method settings that follow.
Choose the currency translation methods
Choose to revalue the Petty Cash monetary account at the “consolidation date” rate.
Choose to revalue the Additional Paid In Capital (APIC) non-monetary accounts at the “Transaction date” rate.
Consolidate > Consolidate, online > Currency translation (tab)
Exhibit: Settings for Main Account 101010
Repeat the consolidation, with the same settings, except use date range 12/1/2023 to 12/31/2023
2b. Trial Balance
Run Trial Balance report in the Consolidation legal entity (C01).
General ledger > Inquiries and reports > Trial balance
Note: All Trial Balance amounts in Consolidation company (C01) are in USD.
3a. Revalue the Consolidation legal entity
Now we want to know how much the assets are worth at December 31.
The system has correctly ‘translated’ the November and December activity at the corresponding month end (default) rates. The November rate for the Petty Cash asset is no longer applicable as of December 31, thus we will revalue.
Since we do not have sub ledger entries in Accounts Receivable and Accounts Payable, we will skip those modules and go directly to the General ledger module.
Key the parameters and post the Foreign Currency Revaluation in the Consolidation legal entity (C01).
General ledger > Periodic > Foreign Currency Revaluation
3b. Trial Balance
Run another Trial Balance report in the Consolidation legal entity (C01).
General ledger > Inquiries and reports > Trial balance
Note: All Trial Balance amounts in Consolidation company (C01) are in USD.