The Consolidated Trial Balance (4) report shows up to four business units in separate columns, followed by combined amounts, eliminations, and consolidated totals. Amounts come from entries already imported into the consolidated company; the report doesn't show separate local-currency and converted-value columns.
Before you run this report, ensure that your consolidation and currency exchange setups are properly configured.
Enter the consolidation Starting Date and Ending Date, and choose Net Change or Balance in Show. Use Business Unit Filter to limit the report to four business units or fewer. You can show amounts in whole thousands.
Use cases
Analyze consolidated financial data for up to four business units in separate columns, with combined amounts, eliminations, and totals. Use this report to compare and review financial performance side-by-side across business units.
Tip
Here are some tips on how to use the report:
- Use this report when a detailed breakdown of consolidation components is needed.
- Get enhanced visibility into financial performance across companies with breakdowns by company, adjustments, and totals in one report.
- Ensure all relevant consolidation and currency exchange configurations are in place to avoid discrepancies.
Financial controllers and analysts can use this report to:
- Analyze consolidated financial performance across multiple companies.
- Compare up to four business units and review posted eliminations in a single view.
- Ensure accuracy in consolidation by comparing adjustments and totals.
- Review consolidated amounts after importing business unit data and posting eliminations.
Try the report
Try the report here:
Tip
If you hold down the Ctrl key while you select the report link, the report opens on a new browser tab. The new tab lets you stay on the current page while you explore the report on the other browser tab.
Related information
Set Up Company Consolidation
Built-in key finance reports
Ad-hoc analysis on finance data
Financial analytics overview