Skip to content
English
  • There are no suggestions because the search field is empty.

Balance Sheet Consolidation Report

Get a consolidated financial statement across your parent office and subsidiaries with multiple currencies

Step by Step Guide: 

1. Navigate to ACCOUNTING > General Ledger > General Ledger Reports.

2. - Expand the Balance Sheet Reports section.

  • Click on the Balance Sheet Consolidation Report hyperlink.

3. Enter the Required Report Parameters

The Balance Sheet Consolidation Report request page is divided into two main sections:

Request Parameters

  • Accounting Period – Select the Accounting Year and Accounting Month to view consolidated balances at a specific point in time.
  • Monthly FX Rate Card – (Optional) Use this setting to apply predefined exchange rates for currency conversion.
  • Show Sub GL Account Details – Checked by default. If header accounts are used, uncheck this to roll up the report at the header account level.
  • Show Eliminations – Checked by default to include elimination entries on the consolidated balance sheet.
  • Convert to Selected Currency – Enables consolidation across offices with different currencies. Once selected, the Report FX Rate column will display the FX rate for each office in the chosen Report Currency.
  • Apply Ownership % – Applies ownership percentages based on office records to reflect accurate financial consolidation.
  • Report Format – If the agency has custom financial statement formats, select an applicable format. (Refer to Financial Statement Formats for more details.)
  • Column Format – Choose to organize data by Office or by Entity.

Filters Available:

  • Offices – Select specific offices to include in the consolidation report. (The available offices depend on office restrictions on the employee record.)
  • Entities – If only certain entities need to be included, use the filter options accordingly.

4. Generate and Export the Report

  1. Click PREVIEW to view the Balance Sheet Consolidation Report on-screen.
  2. (Optional) Click Excel to download the report in spreadsheet format for further financial analysis.
  3. Click Export to generate a PDF version of the report.

5. Understanding the Report

The Balance Sheet Consolidation Report is structured into three primary financial categories:

  1. Assets – Includes cash, fixed assets, receivables, inter-office transactions, and other current assets.
  2. Liabilities – Displays payables, outstanding debts, and accrued expenses.
  3. Equity – Shows retained earnings, share capital, and ownership adjustments.

Key Features of the Report:

  • Consolidates financial data across multiple offices and entities into a single report.
  • Allows for currency conversions using predefined FX rates.
  • Includes elimination entries for inter-company transactions.
  • Provides an adjusted ownership percentage view for accurate reporting.
  • Supports custom financial statement formats for consistency in reporting.

Tip: Interactive Version

For a real-time, drill-down view of this report:

  1. Navigate to ACCOUNTING > General Ledger > Balance Sheet Statements.
  2. Select Consolidation from the Column Format list.