Guide
Management accounts: what they contain, and how to prepare them monthly
Management accounts are the monthly financial picture a business actually runs on — not the statutory accounts filed once a year. There is no prescribed format, because they exist to answer management's questions rather than a regulator's. What follows is the structure almost all of them share.
Free to create. No subscription, and credits never expire.
Also called mis report, monthly financial reporting, board pack and month-end reporting package, depending on where you are. Every name, explained.
A set of management accounts has six parts, every month
Profit and loss for the period
Turnover through to profit before tax, with the comparative period beside it and the year to date. Without a comparative it is a list of numbers, not a report.
Balance sheet at the period end
Condensed to what management acts on: stock, debtors, creditors, borrowings and cash. The statutory level of detail belongs in the year-end accounts, not here.
Cash flow
Opening cash, movement from operating, investing and financing activities, closing cash. The section owner-managers read first and the one most often missing.
Key ratios and KPIs
Gross and EBITDA margin, debtor and creditor days, stock turn, current ratio — each against the prior period so a change is visible without arithmetic.
Aged debtors and creditors
Outstanding balances in buckets with the largest few named. This is the section that most often turns into a phone call the same afternoon.
Commentary
Short, plain sentences on what moved and why, tied to the figures rather than restating them. If it can be deleted without losing information, it was a caption.
A worked example
One month of a fictional trading company, in the shape the profit and loss section usually takes. Figures in £000.
| This month | Prior month | |
|---|---|---|
| Turnover | 412.8 | 381.2 |
| Cost of sales | (268.3) | (251.6) |
| Gross profit | 144.5 | 129.6 |
| Administrative expenses | (96.1) | (92.4) |
| EBITDA | 48.4 | 37.2 |
| Depreciation and amortisation | (8.9) | (8.9) |
| Finance costs | (4.2) | (4.6) |
| Profit before tax | 35.3 | 23.7 |
Every figure above is invented for illustration — a made-up company, not a client. Nothing on this page is computed from anyone’s accounts.
Management accounts vs audited accounts: one is for running the business, the other is for the record
Audited accounts are the year-end statutory accounts after an independent auditor has examined them and given an opinion on them. They are prepared to an accounting framework, filed, and read by people outside the business — HMRC, Companies House, lenders, shareholders — months after the year has closed.
Management accounts answer a different question, sooner: how did last month go, and what needs doing about it? They are produced within days or weeks of the month end, cut to whatever level of detail management acts on, and they can carry estimates, operational figures and commentary an auditor would never sign. A business needs both, and the monthly set is what makes the year-end one unsurprising.
Management accounts vs a trial balance: the trial balance is the raw material
A trial balance is a list of every ledger and its closing balance, debits on one side and credits on the other, totalling to the same figure. It proves the books balance. It does not group anything, compare anything or explain anything, and a business with a few hundred ledgers produces one nobody outside the accounts team can read.
Management accounts are made from it. Each ledger is mapped to a report line — turnover, cost of sales, administrative expenses, debtors — the lines are added up into a profit and loss account and a balance sheet, and the result is set beside last month and the year to date. Mapping is the step that takes the time, which is why Magic MIS does it once and keeps it.
A management accounts template: what each sheet holds
A template that survives more than one month keeps the data apart from the report. The sheets that do that, in the order they usually run:
- Trial balance data — the month's export, pasted as it came, never edited by hand.
- Mapping — every ledger beside the report line it belongs to. The only sheet that needs judgement, and the one that goes wrong when a new ledger appears.
- Profit and loss and balance sheet — formulas that add the mapped ledgers up, with comparatives and year to date.
- Cash flow — derived from the movement between two balance sheets and the profit for the period.
- KPIs and ratios, ageing and commentary — read from the sheets above, never typed in.
There is no empty template to download here. Magic MIS builds its workbook from your own trial balance instead — profit and loss with year to date, a balance sheet summary, KPIs and, where the registers are loaded, aged debtors and creditors — with live formulas, checked to tie back to the trial balance before you receive it.
Where the month actually goes
Re-mapping the same ledgers. The trial balance changes every month; which nominal codes feed which report lines almost never does. Rebuilding that mapping is the bulk of the work and none of the value.
Chasing a figure nobody can trace. Pasted values survive until the meeting where someone asks where a number came from, and then the answer has to be reconstructed from a raw file that may no longer exist.
The template living with one person. When the workbook that knows the client is on one laptop, the month is late whenever that person is on another job.
What people ask about preparing management accounts
What are management accounts?
Monthly or quarterly financial reports prepared for the people running a business, rather than for Companies House or HMRC. They typically contain a profit and loss account, a balance sheet, cash flow, ratios and commentary. They are not statutory, not filed, and not governed by a prescribed format — the content follows what management needs to decide.
Are management accounts a legal requirement?
No. They are optional and internal, unlike year-end statutory accounts. In practice lenders, investors and boards ask for them, and a company without them is making decisions on figures that are months old.
How are management accounts different from statutory accounts?
Statutory accounts are annual, filed, formally formatted and usually audited. Management accounts are monthly or quarterly, internal, formatted however suits the business, and can carry operational detail and forward-looking commentary that statutory accounts never would.
Are management accounts audited?
No. An audit is of the year-end statutory accounts, not the monthly management set. Management accounts are reviewed by whoever relies on them — the directors, a lender, an investor — and an auditor may read them as background, but nobody gives an opinion on them. That is why every figure in them should be traceable to the ledgers it came from.
Who can prepare management accounts?
Anyone who knows the books well enough to map them. Because management accounts are internal and not filed, preparing them is not reserved to a qualified accountant the way an audit is. In practice they are prepared by the bookkeeper, an in-house finance team, or the business's external accountant as a monthly service.
Is an MIS report the same as management accounts?
Effectively yes. “MIS report” is the term used in India for the same monthly management report; “management accounts” is the term in the UK, Ireland, Australia, New Zealand and South Africa. The Indian version often carries a little more operational detail alongside the financials, but the core — P&L, balance sheet, cash flow, ratios, ageing, commentary — is the same document.
How long do monthly management accounts take to prepare?
Prepared by hand, a first set for a new client typically takes one to two days, and each following month a few hours of re-keying and re-checking. Most of that repeat effort is mapping ledgers to report lines — work that does not change from month to month once it is right.
How does Magic MIS produce them?
You upload the raw trial balance your accounting system gives you and take an Excel workbook with live formulas, a dashboard and written commentary. Every figure traces back to the ledger it came from, and later months reuse the mapping — a refresh on unchanged structure makes no AI calls at all.
Read next
- Client reporting software for accounting firms and CAS teamsManagement reporting across a portfolio of clients, without a junior rebuilding each workbook by hand. One mapping per client, reused every month, with every number traceable.
- How a trial balance becomes a monthly MIS, stage by stageUpload your raw accounting data and take the workbook. Ledgers are mapped for you, and later months reuse the mapping with no AI calls at all. Here is each step in detail.
- Management accounts from Xero: which reports to export, and what nextWhich Xero reports to export each month for management accounts — trial balance, P&L, balance sheet, aged receivables and payables — and how to stop rebuilding the pack.
Or stop rebuilding them every month
Magic MIS produces the P&L, balance sheet summary, ratios and ageing from the raw trial balance you already have, with live formulas and every figure traceable. The mapping is built once and reused every month.
Prepaid credits, no subscription. Credits never expire.