Accountio / Templates / Board pack / Management accounts

Management accounts template (Excel) with cash flow and KPIs

Produce the monthly profit and loss, balance sheet, cash flow and KPIs against budget and prior year from one set of figures, with checks that stop a pack going out when something doesn't balance. This management accounts template is one Excel workbook, ready for your chart of accounts and your board dates.

Finance teams
$15
In the pack
Management accounts and board pack
Files
3, Excel and Word
Buy the pack · $15
US library · 52 packs

Get this pack and 51 more for $79

Board pack · this packBookkeeping and advisory lettersAudit and AUP lettersBook-to-tax reconciliationCompilation and review lettersIndependent contractorsCPA verification letters1040 checklistsIRS notices+ 43 more
$79$69889% off
Buy the US library · $79

Want every pack, for every region? Global library, 110 packs, $99

What the workbook looks like

Management accounts template
What the workbook coversSheet in the workbook
Company, currency and reporting month
✓
SettingsChange the reporting month once and every report page moves to it
When a variance needs a comment
✓
SettingsA percentage and an amount threshold, plus the tolerance for amber KPIs
Monthly figures for actual, budget and prior year
✓
P&L dataRevenue, cost of sales, six overhead lines, depreciation, interest, tax, dividends and headcount
Month-end balance sheets
✓
Balance sheet dataActual, budget and prior year, from the prior year end, with two checks for every month
Month and year to date against budget and prior year
✓
Profit and lossVariance in money and percentage, down to profit after tax
Lines that need an explanation
✓
Profit and lossThe Check column says Add commentary until the Commentary column is filled in
Balance sheet with net debt and working capital
✓
Balance sheetAgainst budget, the prior year end and the same month last year
A cash flow you don't have to build
✓
Cash flowWorked out from the profit and loss and the balance sheet, then checked against cash at bank
Every month's cash flow
✓
Cash flow workingsCalculated for actual, budget and prior year. Nothing to enter
KPIs with a rating
✓
KPIsMargins, cash conversion, net debt, debtor, creditor and inventory days, current ratio and revenue per head, rated Green, Amber or Red against budget
How each KPI is worked out
✓
KPIsThe formula written out in words next to every KPI

When you need it

Management accounts are the monthly or quarterly accounts a company prepares for its own directors, lenders and investors. They are not filed at Companies House and have no set format, so the layout is yours to choose. Use this workbook when:

  • The board or investors want monthly figures against budget and last year
  • A lender asks for regular management accounts as a condition of a facility
  • Your current pack has no cash flow, or one that doesn't agree to the bank
  • You are taking over month-end reporting from an outsourced bookkeeper or a departing finance lead

How to use the management accounts template

  1. Fill in Settings. Company name, currency, the first month of your financial year and the two variance thresholds.
  2. Load the year's starting figures. The budget for all 12 months, the prior year by month, and the balance sheet at the prior year end and at the start of the prior year.
  3. Enter each month's actuals. The profit and loss and the month-end balance sheet from your trial balance. Costs and liabilities go in as positive numbers.
  4. Clear every check. Fix any balance sheet that doesn't balance, or retained earnings that don't move by profit less dividends, before you go further.
  5. Set the reporting month and write the commentary. Every report page moves to that month. Explain each line marked Add commentary, then copy the report pages into the board report.

Questions

What are management accounts?

Financial reports a company prepares for its own management, usually every month. They normally include a profit and loss account, a balance sheet and a cash flow, compared with budget and the prior year, with KPIs and commentary.

What is the difference between management accounts and statutory accounts?

Statutory accounts are prepared once a year in the format set by the Companies Act 2006 and filed at Companies House. Management accounts are internal, prepared as often as the business needs, and laid out however the directors find most useful.

Do companies have to prepare management accounts?

There is no rule that says they must. The Companies Act 2006 does require every company to keep accounting records that disclose its financial position with reasonable accuracy at any time, and regular management accounts are how most boards see that position.

What should management accounts include?

At least a profit and loss account and a balance sheet for the month and year to date, a cash flow, comparisons with budget and the prior year, and an explanation of the main differences. This workbook adds a KPI page with Green, Amber and Red ratings.

How is the cash flow worked out?

From the movement in the balance sheet and the profit for the month, using the indirect method. It starts from EBITDA, adjusts for working capital, tax, capital spending, interest, borrowing and dividends, and checks the closing figure against cash at bank.

Also in the management accounts and board pack

Board reportBoard pack checklist and timetable

See the whole pack →

Who it's for

Finance directors, financial controllers and management accountants who produce a monthly pack for a board, investors or a lender.

Last checked

Checked against the Companies Act 2006 in November 2026.