Consolidated Eliminations Report
Use the Consolidated Eliminations report to review the accounts and amounts that were eliminated during consolidation processing.
The report displays to-date elimination totals for balance sheet accounts and fiscal year-to-date totals for income statement accounts, through the current accounting period. Any income statement account eliminations from prior years are summarized on a single, separate report line. You can drill down to see the supporting transaction detail for any amount on the report.
Eliminations Processing
During the consolidation process, DPS eliminates (excludes from the merged data) any account balances or portions of account balances that represent intercompany transactions between the companies in the consolidation group, so that the consolidated information gives an accurate view of the financial state of that group as a whole.
DPS automatically eliminates all or portions of the balances of the following accounts used in intercompany transactions:
- Intercompany accounts receivable account
- Intercompany accounts payable account
- Intercompany suspense account
- Regular, overhead, and promotional labor accounts used for labor adjustments and journal entries
- Regular, overhead, and promotional expense accounts used for cost transfers and journal entries
- Balance sheet and other accounts used for journal entries
- Tax accounts used for journal entries
In addition, when you set up a consolidation group, you can specify other accounts that you want DPS to eliminate when it processes a consolidation for that group. You identify these user-defined elimination accounts on the Eliminations tab of the Consolidated Reporting Setup form.
Settings that Affect GL Reports
You can only generate the cash-basis version of this report if you select the Cash-Basis Reporting option on the Reporting tab of the Accounting System Settings form ().
The Organization Record Access setting for your role on the General tab of the Roles form () determines the organizations for which you can see data on this report.
Drill Down for Detail
If you preview the Consolidated Elimination report, you can drill down on elimination amounts. The drill-down report displays the individual transactions for that elimination amount. The transaction amounts are displayed in the functional currency of the company that owns the transaction.
Options Dialog Box
Use the Options dialog box to specify reporting options for a report. Depending on the report, the dialog box contains one or more of the following tabs: General, Sorting/Grouping, Columns, Budget, Metrics, User Defined Sections, Activity, Drill Down, Layout, and Graph.