Guide
Monthly management report template (management accounts)
Management accounts are the monthly financial statements a business prepares for itself; a management report turns them into something the people running it can act on. Download the free Excel workbook below, with the variance and KPI formulas built in, or follow the template on this page: the sections and the layout, what good commentary looks like, a checklist, and a real example from a sample company's books.
Updated
Free download
Monthly management report template
Profit and loss against budget and the prior month with variance formulas, a balance sheet comparison that checks itself, KPIs (gross and operating margin, DSO, current ratio) calculated from both, and a commentary sheet.
Also on GitHub: ataskiai/management-report-templates
How do I create a monthly management report for a small business?
- Business day 3: Finish the bookkeeping. Reconcile every bank and card account and post the month's invoices, bills and accruals, so the figures stop moving.
- Business day 4: Run the statements. Run the Profit and Loss for the month beside the prior month, and the Balance Sheet beside the prior month's. Xero and QuickBooks Online both use these report names.
- Business day 4: Compare with the budget. Run Budget Variance in Xero or Budget vs. Actuals in QuickBooks Online, and mark each line favourable or unfavourable by its effect on profit.
- Business day 5: Review receivables. Run Aged Receivables Summary in Xero or A/R Aging Summary in QuickBooks Online, and name the largest late payers.
- Business day 6: Write the commentary. Open with a summary of three to five sentences, then explain each large variance by the accounts and amounts behind it.
- Business day 7: Check and send. Work through the checklist below, give every action an owner and a date, and send the report to the same readers every month.
The days are a suggested timetable for a small team, not a standard: what matters is keeping the same one every month, so readers know when the report arrives.
The sections, in order
- Summary. Three to five sentences: the result for the month, the cash position, the one or two things that matter most, and any decision needed.
- Key metrics. A short, fixed scorecard such as revenue, gross margin, operating result, burn rate, cash runway and days sales outstanding, each against budget or the prior month.
- Profit and loss. The month against budget and the prior month, plus the year to date. Revenue, cost of sales, gross profit, operating expenses, operating result.
- Balance sheet. Month end against the prior month end: cash, receivables, payables, debt, equity.
- Cash. A bridge from opening to closing cash, and a forecast of the weeks ahead.
- Working capital. Receivables by age with the largest late payers named, and payables falling due.
- Commentary. Each large variance explained by the accounts behind it (see below).
- Actions. What needs approving, chasing or changing, each with an owner and a date.
What layout gets a management report read?
Put the summary first and the detail last, so the first page stands on its own. Use the same columns in every table: actual, budget, variance and the prior period. Mark each variance favourable or unfavourable, put the commentary beside the number it explains, and keep the same template every month.
- Summary first, detail last. The first page should stand on its own; statements and schedules follow for anyone who wants to check.
- Same columns every table. Actual, budget, variance, and the prior period. A reader learns the layout once.
- Signs that cannot be misread. Mark each variance favourable or unfavourable rather than relying on plus and minus, which flip meaning between revenue and cost lines.
- Commentary next to the number. Put the explanation beside the line it explains, not in a separate section three pages later.
- The same template every month. Consistency is what makes month-on-month comparison possible.
What does good commentary look like?
It explains a variance by the accounts that caused it, with amounts, and says whether it will recur. “Operating expenses were higher than budget” is weak; naming the legal fees and the conference sponsorship, and saying both are one-offs, is strong. If profit and cash moved apart, add one sentence on where the cash went.
Good commentary explains a variance by the accounts that caused it, with amounts, and says whether it will recur. Compare:
- Weak: "Operating expenses were higher than budget this month."
- Strong: "Operating expenses were over budget, driven by legal fees for the new contract and one conference sponsorship; both are one-offs, and payroll was on budget."
The strong version answers the next three questions before anyone asks them: which accounts, how much, and does it matter next month. If profit and cash moved in different directions, add one sentence on where the cash went: receivables, payables, inventory, loan repayments or capital spending.
Worked example: Northbridge Analytics, September 2026
Northbridge Analytics is the sample company in Ataski's Financial Analyst workspace. These figures come from its sample monthly management report, built from one set of generated books.
| Line | Actual | Budget | Variance |
|---|---|---|---|
| Revenue | $163,156 | $145,140 | +$18,015 favourable |
| Operating expenses | $181,300 | $169,871 | +$11,429 unfavourable |
| Cost of revenue | $44,002 | $42,678 | +$1,324 unfavourable |
| Operating result | −$62,146 | −$67,408 | +$5,262 favourable |
- Cash: $1,544,959 at the start of the month, $1,454,444 at the end.
- Runway on the forecast: 23.4 months.
- Gross margin: 73.0%.
Commentary from the sample report
“CAC payback stood at 24.2 months in September 2026, above the 18 months the model assumes. Behind it: Google Ads $14,503 (from $13,110). Moving the other way: Sales Commissions $2,724 (from $9,204) and Events & Conferences nothing this month (from $4,781). The lines that moved the other way do not explain the gap.”
The measure, its value against the target, and the accounts behind the movement, each with an amount: the pattern described above, applied to a real month.
What should you check before sending the report?
Check that bank and card accounts are reconciled, the month's invoices, bills and accruals are posted, the balance sheet ties to the trial balance and closing cash to the bank, every large variance names accounts and amounts, prior-month figures are unchanged or explained, and every action has an owner and a date.
- Bank and card accounts reconciled for the month.
- Invoices, bills and accruals for the month posted.
- Balance sheet totals tie to the trial balance; closing cash ties to the bank.
- Every large variance has a cause naming accounts and amounts.
- Prior-month figures unchanged from last month's report, or the change explained.
- Receivables reviewed and the largest late payers named.
- Actions have an owner and a date.
- The summary still stands on its own after the edits.
Building it from your accounting system
Step-by-step for the two most common ledgers: a monthly management report from QuickBooks Online and budget vs actual in Xero. For the quarterly version for directors, see the board pack template.
Or have it written for you
Ataski's Financial Analyst writes the monthly management report from your accounting system, so the work above happens without you.
- Your ledger. QuickBooks Online and Xero; NetSuite, Sage Intacct, Zoho Books and Business Central in beta.
- Every month on the 1st. The report is refreshed on the 1st of every month for the month just ended, as a draft that waits for your approval.
- History from day one. The first connection reads the trailing 24 months, so the first report already compares each month with the same month last year.
- Cash, 13 weeks out. A weekly cash forecast beside the open invoices and bills falling due.
- A second reviewer. A second, independent AI reviewer reads every monthly narrative, and an AI explanation that cites a source outside your books is discarded, not published.
Plans start at $599/mo. The first month is free, and no card is needed to start it.
Questions
What is the difference between management accounts and a management report?
Management accounts are the monthly financial statements prepared for internal use: profit and loss, balance sheet and cash flow. A management report wraps them with key metrics, budget comparisons and written commentary on what moved and why.
What should a monthly financial report include?
A short summary, the key metrics, the profit and loss against budget and the prior month, the balance sheet, a cash bridge and forecast, receivables and payables, commentary that explains each large variance by the accounts behind it, and the decisions or actions needed.
How do I explain a variance in the commentary?
Name the line, the amount and the accounts that caused it, then say whether it is a one-off or will recur. For example: operating expenses over budget, driven by legal fees and one conference, not by a rise in payroll.
Who should receive the monthly management report?
The people who run the business: the founders or CEO, department heads with a budget, and often investors or lenders who receive a shorter version. Each reader should be able to find their own numbers quickly.