Consolidated Financial Summary preview
Dashboard sheet with consolidated financial summary showing revenue, EBITDA, net income, and cash across parent and subsidiary entities. 1/6

About this consolidated financial summary spreadsheet template

This consolidated financial summary template provides a structured framework for group-level financial reporting with entity contributions and intercompany eliminations. Built around six interconnected sheets — Dashboard, Data Entry, Analysis, Exception Queue, Lists & Guide, and Instructions — it covers the full consolidation workflow from raw entity data entry through to a summarized group dashboard with key metrics including Revenue, EBITDA, Net Income, and Cash.

The template supports multi-entity consolidation with Parent Co and up to three subsidiaries, tracking intercompany revenue and cost eliminations, FX adjustments, and concentration risks. The Analysis sheet provides side-by-side comparison of consolidated figures against elimination and adjustment amounts with built-in validation checks, while the Exception Queue helps finance teams prioritize and resolve reconciliation issues with owner assignments and evidence tracking.

Fully editable in WPS Office, Microsoft Excel, Google Sheets, and Apple Numbers, the template adapts to your own group structure. Replace the sample entity data, period values, consolidation rules, and exception items with your actual financial submissions, and follow the step-by-step Instructions sheet to run a complete consolidation close cycle.

6 structured sheets

Dashboard, Data Entry, Analysis, Exception Queue, Lists & Guide, and Instructions for a complete consolidation workflow.

Consolidation-ready logic

Pre-built intercompany elimination, FX adjustment, and concentration check formulas for multi-entity reporting.

Corporate dashboard style

Clean, professional layout designed for group finance and controller review.

Standard XLSX format

Works with WPS Office, Microsoft Excel, Google Sheets, and Apple Numbers.

Frequently asked questions
The Consolidated Financial Summary template is designed for group-level financial consolidation, intercompany elimination tracking, and multi-entity financial reporting. Customize the sample data, entity structure, and other editable elements in WPS Office for your own consolidation projects.
Use the native XLSX in WPS Office, Microsoft Excel, or Google Sheets. For Notion workflows, reuse the financial data and consolidation structure in a Notion database; for branded visual reports, adapt the content in Adobe Express.
Download the template, open it in WPS Office, and replace the placeholder entity names, financial data, period labels, consolidation rules, and other editable elements with your own group financial information.
Yes. Select Download to get the editable XLSX file and open it in WPS Office or another compatible spreadsheet application.
Yes. Adapt it for group financial reporting, intercompany reconciliation, consolidation audit workpapers, and management dashboards. It is available for personal and commercial projects, subject to the applicable template license.