UK management accounts template (Excel)
Working on this yourself? Talk to Mark, our co-founder. We’re here to solve it with you.
Excel (.xlsx), P&L, balance sheet, KPIs and notes, example data in pounds
Free, no sign-up, no email address.
How to use the template
The template has four sheets: P&L, balance sheet, KPIs and notes. The blue cells are inputs, the rest are formulas. Fill in the month's actual figures from your bookkeeping software, the budget for the month and the year-to-date figures.
The P&L runs from turnover and cost of sales to gross profit, then overheads: staff costs including employer's National Insurance and pension contributions, premises, marketing, software and IT, professional fees and other overheads. Below EBITDA come depreciation, interest and corporation tax. The tax rate is an input cell, set to the 25% main rate; change it if the small profits rate or marginal relief applies to you.
The balance sheet follows the UK layout: fixed assets, current assets, creditors falling due within one year, including VAT and PAYE, creditors falling due after more than one year, and net assets against capital and reserves. A check row shows zero when it balances.
KPIs and commentary
The KPI sheet calculates gross margin, EBITDA margin, debtor days, creditor days, the current ratio and cash runway in months from the other sheets. Debtor days tell you how long customers take to pay, runway how long the cash lasts at the current burn.
Use the notes sheet for the commentary the directors read first: what stood out this month, why, and what happens next. Explain every material variance and keep the rest short.
What lenders and investors look for
Banks and investors who receive your management accounts read them in a fixed order: cash and runway first, then the trend in turnover and gross margin, then debtor days and the balance sheet. Keep the layout the same every month so they can compare, send the accounts on the same day each month, and say plainly when a number is an estimate.
Close the month first
Management accounts are only as good as the books under them. Reconcile the bank, book accruals and prepayments and post depreciation before you fill in the template. Practices that prepare management accounts for clients usually agree a fixed day each month, such as the tenth working day, and the closer the books are kept during the month, the earlier that day can be.
Frequently asked questions
Are management accounts a legal requirement in the UK?
No. Only annual statutory accounts are required, filed with Companies House. Management accounts are for the directors, lenders and investors, and their format is up to you.
What is the difference between management accounts and statutory accounts?
Statutory accounts follow a set format under the Companies Act and UK accounting standards, once a year. Management accounts are monthly or quarterly, in whatever format helps you run the business, and usually include a budget comparison and KPIs.
Which corporation tax rate should I use?
The main rate is 25% for profits above £250,000, the small profits rate 19% for profits up to £50,000, with marginal relief in between. Set the input cell to the effective rate you expect for the year.
Is the template free?
Yes. No sign-up and no email address. Download it and use it as you like.
More free tools
- Month-end close checklist
- DSO calculator
- Dutch statutory interest and collection costs calculator
- Liquidity and solvency ratio calculator
- UK late payment interest calculator
- Cash flow statement template (Excel)
- 13-week cash flow forecast template (Excel)
- Management report template (Excel)
- Month-end close checklist (Excel template)
Where Thred comes in
Make your firm more efficient with AI, so you have more time for relationships, new customers and advisory work.
