The Management Reporting Package: What to Include

A management reporting package is the set of financial and operational reports that a company's leadership uses each month to understand performance, make decisions and hold themselves accountable. This guide is part of business analytics for finance and operations, follows how to automate financial reporting and ETL vs. ELT, and leads to the monthly management report template and board reporting packs. It is different from the statutory accounts, which exist for regulators and lenders. The management package exists to answer the question "How are we doing and what should we do about it?" A good package is short enough to read, consistent from month to month, tied to the budget and the forecast, and ends with clear points for decision. A poor one is a stack of unexplained numbers produced late. This guide lists what a management reporting package should include, page by page, works through a P&L variance example with volume and rate effects and checked arithmetic, covers the timeline, the commentary and the design, and describes how to improve a package over time. The package is the backbone of the cycle in budgeting and forecasting.

The purpose and the audience

Start by defining who reads the package and what they decide. The CEO and the leadership team want to know whether the business is on track, where the risks are and what needs a decision. Department heads want to see their own results and drivers. The board wants a higher-level version. One package rarely serves all of them, so design a core package for the leadership team, with extracts for departments and a summary for the board. Write the purpose at the front: "to review performance against budget and forecast, and agree actions."

What to include

1. Executive summary (one page). The headline results, three to five key messages, the main risks and opportunities, and decisions needed. Many readers will read only this page, so write it last and carefully.

2. Income statement with variances. Actual versus budget and versus prior year, for the month and year to date, with variance in dollars and percent, and a column for the latest forecast of the year. Show revenue, cost of goods sold, gross profit, operating expenses by major category and operating profit.

3. Variance commentary. A short explanation of each material variance: what happened, why, whether it is temporary or lasting and what is being done. Use a threshold, such as variances greater than 5 percent and $25,000.

4. Balance sheet summary. Cash, receivables, inventory, payables, debt and equity, with movement from the prior month and a note on significant changes.

5. Cash flow and liquidity. Operating cash flow, capital expenditure, free cash flow, the cash balance and the rolling 13-week forecast with headroom against minimum cash and covenants. See cash flow management.

6. Working capital. Days sales outstanding, days of inventory, days payable and the cash conversion cycle, with trends and the aging of receivables and inventory.

7. KPI scorecard. Five to fifteen company KPIs with targets, status and trend. See KPI scorecards.

8. Forecast outlook. The latest full-year forecast versus budget, key assumptions and risks and opportunities with estimated values. State the changes since the last forecast.

9. Departmental or segment results. Revenue, margin and contribution by business unit, product line, region or channel, as appropriate.

10. Operational metrics. On-time in-full, inventory turns, forecast accuracy, headcount and any measures central to the business.

11. Initiatives and actions. Status of major projects and of actions from the previous meeting.

12. Appendices. Detailed schedules, reconciliations and definitions, for reference.

Tailor the list. A service firm may emphasize utilization and backlog, a manufacturer yield and capacity, an e-commerce company conversion and customer acquisition cost.

A worked variance: from the income statement to the explanation

Suppose a company's month results are as follows, in thousands of dollars (hypothetical).

Check: 4,350 - 2,688 = 1,662; 4,800 - 2,928 = 1,872; 1,662 - 1,380 = 282; 1,872 - 1,400 = 472; 282 - 472 = -190; -190 / 472 = -0.4025. Gross margin: 1,662 / 4,350 = 38.2 percent and 1,872 / 4,800 = 39.0 percent.

Operating profit is 40 percent below budget, a much larger percentage gap than the 9.4 percent revenue shortfall, because fixed costs did not flex. To explain the gross profit gap of -$210 thousand, split it into a volume effect and a rate effect. The volume effect is the revenue shortfall at the budgeted margin: (4,350 - 4,800) × 0.39 = -450 × 0.39 = -$175.5 thousand. The rate effect is the margin shortfall on actual revenue: 4,350 × (0.38207 - 0.39) = 1,662 - 1,696.5 = -$34.5 thousand. The two sum to -175.5 - 34.5 = -$210 thousand, matching the variance. The commentary can then say: "Gross profit is $210 thousand below budget. About $175 thousand comes from lower volume, mainly delayed orders from two accounts worth roughly $310 thousand, which we expect to ship next month. About $35 thousand comes from lower margin rates due to mix toward lower-margin products. Operating expenses were $20 thousand under budget. Operating profit is $190 thousand below plan, and the year-to-date shortfall is now $240 thousand." The reader sees the size of the problem, the cause, whether it is temporary and the outlook.

Timeline

Agree a calendar and keep to it. A typical schedule: close the books by working day 5 or 6; complete the first draft of the package on day 7; review with finance and department heads on day 8; issue the package by day 10; hold the leadership review on day 11 or 12. Track the days to produce the package as a KPI. Automate the data collection and the standard pages so the time goes into analysis and commentary. See how to automate financial reporting.

Writing the commentary

Good commentary is brief, specific and forward-looking. Four rules help.

1. Lead with the so what. "Gross margin fell 0.8 points because of mix" is better than "Gross margin was 38.2 percent."
2. Quantify. Give dollar effects and not adjectives.
3. Separate one-time from recurring items.
4. Say what you are doing, with an owner and a date.

Avoid copying the same text every month, restating the numbers in words and hiding bad news in the middle of a paragraph.

Design principles

Use a consistent layout and order every month. Put the summary first and detail behind it. Show comparisons on every number. Use color only for meaning. Limit each page to one idea. Label each page with the period, the basis of preparation and the data status. Reconcile every total to the ledger and display the check. Keep definitions in an appendix. See dashboard best practices.

Improving the package over time

Ask readers each quarter what they read, what they skip and what they miss. Track which pages generate questions or decisions. Remove pages that nobody uses and add those that readers request. Keep a simple version history, and note changes in the front of the package. As the business changes, add or retire KPIs. Compare the forecast with actual results in the package, so that readers learn how far to trust it.

Common mistakes

1. Too long, with no priorities.
2. Late delivery.
3. Numbers without explanations.
4. Inconsistent definitions between pages and from the board pack.
5. No forward view.
6. Changing format every month.
7. No decision points.
8. No reconciliation.

The year-to-date and forecast view

The monthly variance tells leaders what happened in the month. They also need to know where the year is heading. A compact table of year-to-date results and the full-year forecast does this. Suppose operating profit for the first six months is $1,980 thousand against a budget of $2,310 thousand (hypothetical). The year-to-date variance is 1,980 - 2,310 = -$330 thousand, or -330 / 2,310 = -14.3 percent. The forecast for the second half is $2,150 thousand. The full-year forecast is 1,980 + 2,150 = $4,130 thousand against a full-year budget of $4,700 thousand, a gap of -$570 thousand or -570 / 4,700 = -12.1 percent. Notice that the forecast gap is larger in dollars than the year-to-date gap: the forecast assumes the second half is also below budget, by 4,700 - 2,310 = 2,390 budgeted for the second half against 2,150 forecast, which is $240 thousand lower. The page should say why: which assumptions drive the second half, what could move them and what actions are planned. Show the last forecast beside the new one, with the reasons for the change, so that readers can see whether the outlook is stabilizing or deteriorating.

Segment pages

Where the company has several product lines, regions or channels, include a page for each main segment with revenue, gross margin, contribution and the same variance structure. A good segment page answers: which parts of the business are driving the total variance, and are they the same parts as last month? A ranked bar of variance contribution by segment makes this visible at a glance. Allocate shared costs on a stated basis, or stop at contribution margin so that the discussion is not about allocation rules. See product mix analysis.

Governance of the package

A package that leaders rely on needs its own controls. Assign a preparer and a reviewer. Reconcile the income statement and balance sheet to the closed ledger, and display the check on the first page. Keep a record of each month's package, along with the data cut-off date and any later adjustments. When a number is restated, explain it. When a definition changes, note the date and restate comparatives. Treat the package as a product with an owner, a calendar and a feedback loop, not as a task that is rebuilt each month.

Questions leaders ask after reading

Be ready for the questions that follow every package. What is driving the variance, and is it temporary? What is the forecast, and how confident are you? Where could we be wrong? What decision do you need from us? What are we doing about the red items? How does this compare with what we told the board? Build the answers into the package so that the meeting begins with decisions and not with clarification. If the same question comes up two months in a row, add the answer to the standard layout.

FAQs

What should a management reporting package include?

An executive summary, income statement with variances and commentary, balance sheet and cash flow, working capital, KPIs, a forecast outlook, segment results, operational metrics and actions.

How long should it be?

Long enough to answer the leadership team's questions, often 10 to 20 pages with appendices, and with a one-page summary at the front.

How is a management package different from statutory accounts?

Management reports are for internal decisions and may use different formats and measures. Statutory accounts follow accounting standards and are prepared for external users.

When should it be issued?

Typically within 7 to 12 working days after month-end, as quickly as accuracy allows.

How do I explain a variance well?

State what happened, quantify it, say why, whether it will recur and what action is planned.