Management accounts template: a monthly pack you can download

What monthly management accounts contain

Monthly management accounts are the internal pack a company's directors read each month to run the business. A complete pack has eight pages:

1. Summary of key figures
2. Profit and loss: month and year to date, against budget and last year
3. Balance sheet
4. Cash-flow bridge
5. Aged debtors
6. Aged creditors
7. Commentary
8. Checks

They are not statutory accounts. Statutory accounts are prepared once a year to accounting standards and sent to shareholders, Companies House and HMRC. Management accounts follow no prescribed format; they exist because directors need figures every month, and the Companies Act already requires every company to keep adequate accounting records that show its financial position at any time with reasonable accuracy. The pack turns those records into something a board can read in ten minutes.

For US readers: the equivalent is the monthly management reporting package, or management financials. Read debtors as accounts receivable, creditors as accounts payable and turnover as revenue.

What the .xlsx template contains

The workbook has eleven pages after the "How to use" sheet:

1. Cover: company, month-end date and contents. Every page follows the date in B4.
2. TB: paste the trial balance as period movements: Account code, Account name, Month (the month-end date), Debit, Credit. Net, pack line, statement, signed net, year and month number are formulas.
3. Mapping: each account code once, with its pack line, statement (P&L or BS) and sign (−1 for income, liabilities and equity).
4. Budget: pack line by 12 months.
5. Summary: revenue, gross margin %, EBITDA, cash, debtor days and headcount, then the month against budget.
6. P&L: month actual, month budget, variance, var %, month last year, YTD actual, YTD budget, YTD variance, YTD last year.
7. Balance sheet: this month, last month and the last year end.
8. Cash flow: an indirect bridge from operating profit to closing cash.
9. Aging: debtors and creditors by current, 30, 60 and 90+ days.
10. Commentary: one box per page.
11. Checks: seven tie-outs.

How the formulas work

The formulas use named ranges (TB_Signed, TB_Line, CurMonth and so on), so each one reads as what it does. Each P&L line is one SUMIFS on the trial balance:

Month actual:  =SUMIFS(TB_Signed,TB_Line,$A5,TB_Year,CurYear,TB_Mo,CurMonth)
YTD actual:    =SUMIFS(TB_Signed,TB_Line,$A5,TB_Year,CurYear,TB_Mo,"<="&CurMonth)
Last year:     =SUMIFS(TB_Signed,TB_Line,$A5,TB_Year,CurYear-1,TB_Mo,CurMonth)

TB_Signed is the net amount times the mapping's sign, so revenue (a credit) comes out positive. Variance is actual minus budget, and the percentage guards against a zero budget:

Variance:  =B5-C5
Var %:     =IFERROR(D5/ABS(C5),"")

Balance sheet lines sum every movement up to the column's date, and retained earnings add the profit to date:

=SUMIFS(TB_Signed,TB_Line,$A6,TB_Date,"<="&B$4)

The workbook uses SUMIFS, INDEX/MATCH, EOMONTH and IFERROR only, so it opens in Excel 2016 and 2019 as well as Microsoft 365.

Worked example: September

The sample company, Example Trading Ltd, for September 2026, in GBP:

The cash bridge:

Closing cash of £200,800 equals cash on the balance sheet. Debtor days are £506,000 / £4,745,000 rolling 12-month revenue × 365 = 38.9 days.

The reading: revenue beat budget by £12,000, but the lower margin (40.0% against 41.0%) gave back almost all of it, so gross profit is only £800 ahead. The profit beat came from overheads, £2,500 under budget.

The checks built into the template

The Checks sheet shows seven differences and a result line that reads "All checks pass" only when every one is 0:

1. The trial balance nets to zero: =ROUND(SUM(TB_Net),2).
2. No unmapped codes: =COUNTIFS(TB_Line,"UNMAPPED"). A new ledger account not yet in Mapping would otherwise drop out of the pack.
3. The balance sheet balances: net assets minus total equity.
4. Profit equals the movement in retained earnings: the month's profit minus (retained earnings this month − last month). Dividends sit on their own line so they do not break this check.
5. The cash bridge closes: bridge closing cash minus balance-sheet cash.
6. Aged debtors equal balance-sheet debtors (£506,000 in the sample).
7. Aged creditors equal balance-sheet creditors (£198,500).

Read the Checks sheet before any other page.

Writing the commentary

Answer first, then up to three bullets per page. Explain only the variances over a threshold, for example both 5% and £10,000, and say what happens next. Commentary that repeats the table adds nothing. "Revenue £12,000 over budget" is in the table already; "the margin fell a point because of the September price promotion, which ends in October" is commentary. A board narrative with a citation on every number shows how to write it so every figure traces back to the pack, and ten board metrics for a sales-led company helps choose what goes on the summary page.

Timetable

A workable rhythm is to close the ledger by working day 5 and send the pack to directors by working day 8. A flash of revenue, cash and debtors on working day 2 or 3 bridges the gap. The pack is only as good as the period cut-off behind it; see fiscal calendars and period cuts. The commercial pages that sit beside this finance pack are in the monthly commercial pack.

Where it goes wrong

• Accruals and prepayments not posted. One month swings and the next corrects it.
• New ledger accounts not in Mapping. They drop out of the pack; check 2 catches them.
• Budget phased evenly across the months when the business is seasonal, so every month carries a timing variance.
• Inconsistent variance signs between revenue and costs. State favorable or adverse on every line you comment on; for the full treatment, see the budget vs actual template.
• Commentary that repeats the numbers instead of explaining them.

Beyond the template

A workbook pack works for one company and one ledger. It strains with several entities, several currencies, or directors who ask follow-up questions the pack does not answer. Upload the trial balance and budget and Covirage's tools compute the P&L variances, the cash bridge and debtor days with every check run; the external AI model drafts the commentary from the finished figures. See board reporting: the monthly pack's analysis pages, built from your own ledger and tied to the trial balance every month. For the board version of the pack, see the board report template; for the early read before close, flash report.