New plan10 templates a month$9/month, cancel anytime

Start your plan
Consolidated Balance Sheet Template watermarked preview
Accounting & Bookkeeping · Financial Statements

Consolidated Balance Sheet Template

Track multi-company financial position with consolidated assets, liabilities, and equity across reporting periods.

This template provides a structured format for preparing consolidated balance sheets that combine financial data from multiple subsidiary companies into a single statement. It displays assets, liabilities, and shareholders' equity at a specific reporting date, enabling corporate groups to present unified financial health. Ideal for holding companies, multinational corporations, and organizations with multiple operating entities needing consolidated financial reporting.

What's inside

  • Multi-year period comparison (e.g., 2001 vs 2002)
  • Consolidated asset and liability sections
  • Equity consolidation tracking
  • Reporting date reference fields
  • Standardized accounting structure
#consolidated balance sheet#financial statements#group accounting#multi-entity reporting#assets liabilities equity

Download this template

.xlsx · 1 sheet

$9/monthDownload up to 10 templates a month from a library of thousands. Cancel anytime.

  • 10 downloads every month
  • Cancel anytime
  • 14-day refund policy

More in Accounting & Bookkeeping

Fixed Assets Register Template Excel with Depreciation Schedule previewAccounting & Bookkeeping

Fixed Assets Register Template Excel with Depreciation Schedule

A fixed assets register template in Excel with a depreciation schedule: track each asset's location and custodian, depreciate monthly by straight-line, declining balance or sum-of-years' digits, record disposals with gain or loss, and produce the year-end roll-forward and net book value report.

  • 10 tabs, from a quick-start guide to the depreciation engine
  • Asset register with location, custodian, supplier and serial or tag
  • Straight-line, declining balance and sum-of-years' digits
intermediate.xlsx
Bank CSV to Ledger Bookkeeping & Reconciliation previewAccounting & Bookkeeping

Bank CSV to Ledger Bookkeeping & Reconciliation

A bookkeeping system in Excel that turns raw bank and card CSV exports into categorized double-entry books, flags duplicates, missing lines and other errors automatically, and reconciles every account.

  • 14 connected tabs, from a quick-start guide to Settings
  • Paste raw bank and card CSV exports as downloaded
  • CSV profiles for any bank layout, date and number format
intermediate.xlsx
Balance Sheet with Ratios and Working Capital previewAccounting & Bookkeeping

Balance Sheet with Ratios and Working Capital

Track financial position and calculate key liquidity ratios to assess business solvency instantly.

  • Current ratio calculation
  • Quick ratio formula
  • Cash ratio tracking
intermediate.xlsx
Statement of Total Recognised Gains and Losses previewAccounting & Bookkeeping

Statement of Total Recognised Gains and Losses

Financial statement tracking all recognised gains and losses for a complete accounting period.

  • Year-end comparative reporting structure
  • Line items for operating and non-operating gains/losses
  • Multi-period comparison columns
intermediate.xlsx