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 teamsGet this pack and 51 more for $79
Want every pack, for every region? Global library, 110 packs, $99
What the workbook looks like

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
- Fill in Settings. Company name, currency, the first month of your financial year and the two variance thresholds.
- 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.
- 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.
- 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.
- 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
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.
