Trial Balance to Financial Statements Template
A real chart of accounts tagged via XLOOKUP, auto-building a full Profit & Loss and Balance Sheet with a live balance check.
No sign-up or email required. Real Excel formulas, not a screenshot.
What this template does
- ✓Tags each trial-balance account to its financial-statement line automatically via XLOOKUP.
- ✓Builds a complete Profit & Loss and Balance Sheet from the trial balance using SUMIF, live.
- ✓Includes a balance check (Assets − Liabilities & Equity, should be zero) that responds immediately to any change.
What’s inside
FS Mapping
Maps each account to its financial-statement line.
Trial Balance
A real 22-account chart of accounts, each tagged with its FS Line via a live XLOOKUP against FS Mapping.
Profit & Loss
Auto-built from the Trial Balance via SUMIF.
Balance Sheet
Auto-built via SUMIF, pulling Net Profit live from the Profit & Loss sheet into Retained Earnings — so it balances exactly whenever the Trial Balance itself balances.
Read Me
The workbook's own documentation and a link back to the full guide.
How to use it
To add a new account: add a row to the Trial Balance, add a matching row to FS Mapping with its FS Line, and extend the relevant SUMIF range if you go beyond the existing 22 accounts.
Want the full walkthrough?
The guide explains every formula in this workbook step by step, with a worked example.
Go deeper
Advanced Excel for Finance & Business
This template is one piece of a bigger workflow. The course builds the whole thing with real datasets, step by step, with a graded assessment and a verifiable certificate.