Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

#Steps
1

Specify exchange rates for consolidations 

Only process if a business unit uses a different currency than the consolidated company,  exchange rate methods for each account must specify before consolidate

(1) Go to business unit card, then select Related=> Exchange Rates => Select Average Rate

(2) On the Change Exchange Rate page, modify the  Relational Exch. Rate then Close the page.

(3) Choose the Closing Rate action. 

(4) Modify the Relational Exch. Rate then Close the Page

Description of Exch. Rage Option



Average Rate (Manual)You manually calculate the average rate for the period to consolidate. Calculate the average either as an arithmetic average or as a best estimate, and specify the result for each business unit. Used for income statement accounts.
Closing RateUsed for balance sheet accounts.
Last Closing RateThe rate that was valid in the foreign exchange market on the date for which the balance sheet or income statement is being prepared. You enter this rate for each business unit. Used for balance sheet accounts.


2

Test Consolidations

On the business unit page, select Actions => Functions => Test Database...

Review the G/L Account mapping and resolve the Error if any.  

3

Run Consolidation

On the business unit page, select Actions => Functions => Run Consolidation...

Enter the Consolidation Period and Document No. then click OK

After consolidated, Consolidation Trail Balance report page to be prompt

Enter start date and end date then click Preview

Image Modified

Sample Consolidated Trial balance

Image Modified


Remarks:

The Consolidated Trial Balance Report can be run by select Related => Reports => Trial Balance

Image Modified

...

4. Eliminate repeated transactions 

Processing consolidation eliminations is a manual process.

...