Oracle Oracle Financial Consolidation Hub, User Manual, Page: 99 / 220

Setting Up Translation 12-7
Rates Used by Translation for Vision: Canada
Entity Line Item Dr (CAD) Cr (CAD) Rate
Vision: Canada Cash 1000 400 0.8
Vision: Canada Accounts Receivable 1200 500 0.8
Vision: Canada Accounts Payable 500 700 0.8
Vision: Canada Paid-in Capital 0 400 0.84
Vision: Canada Retained Earnings 0 300 0.84
Vision: Canada Revenue 0 2000 0.7
Vision: Canada Cost of Goods Sold 1100 0 0.7
Vision: Canada Salaries 400 0 0.7
Since the balance sheet was multiplied by the ending rate and the income statement by
the average rate (and equities by an historical rate), the ending USD balances require a
credit of 58 posted to Cumulative Translation Adjustment to ensure proper balancing as
shown in the following table.
Translated Results for Vision: Canada
Entity Line Item Dr (CAD) Cr (CAD) Rate Dr (USD) Cr (USD)
Vision:
Canada Cash 1000 400 0.8 800 320
Vision:
Canada Accounts
Receivable 1200 500 0.8 960 400
Vision:
Canada Accounts
Payable 500 700 0.8 400 560
Vision:
Canada Paid-in
Capital 0 400 0.84 0 336