Management accounts template
A monthly pack for one company or a small group.
Quick answer
Download a free monthly management accounts template in Excel, with a summary, P&L, balance sheet, cash flow and KPI tab, plus a group tab that adds up to three companies and subtracts intercompany eliminations.
Download the management accounts template (.xlsx)
How to use it
- Paste each company's trial balance figures into its tab.
- Enter intercompany balances on the eliminations tab.
- Check the group balance sheet balances.
- Write three lines of commentary on the summary tab.
New to the format? Read what are management accounts.
When to move beyond a template
Once you have more than three companies, different charts of accounts or several currencies, a consolidation app saves time and errors. See the best consolidation software.
Frequently asked questions
What format should management accounts be in?
There's no required format. Most include a summary, P&L against budget, balance sheet, cash flow, aged debtors and creditors and KPIs.