Management reporting practical guide · By Calculom
The monthly finance pack is finished. It contains the income statement, several department tabs, a cash report, and enough detail to answer almost any question. Yet the management meeting still begins with someone asking, “What do we need to pay attention to?”
A useful pack makes that answer easy to find. It connects financial performance, the position of the business, operating drivers, and the decisions leadership needs to make. Excel gives finance teams the flexibility to bring those elements together in a familiar format.
This guide sets out a practical structure you can adapt to your organization, with an example page plan, workbook layout, and release checklist. The page counts, scenarios, and figures are illustrative recommendations, not a required reporting standard.
1. Start with the audience and the decisions
Decide who will use the pack before deciding which reports to include. A leadership team may need a short view of performance, cash, risks, and actions. Department owners may need a more detailed account view. Finance may need supporting schedules that would distract from the management discussion.
Write down the questions the pack should answer:
- How did the business perform against the approved plan and the prior period?
- Which movements are significant, and what caused them?
- What happened to cash and working capital?
- Which operating measures help explain the financial results?
- What needs a decision, who owns it, and when will it be reviewed?
Use these questions to choose the core pages. Keep detailed reconciliations and transaction listings in supporting schedules, with a clear route from each summary to its evidence. A board pack may require different content, approvals, and distribution controls from an internal monthly management pack.
2. Choose a clear monthly pack structure
A consistent sequence helps readers know where to look each month. The following ten-page example moves from the overall story to the supporting numbers and agreed actions. Adapt its length to the business rather than treating ten pages as a target.
| Pages | Section | Primary question | Suggested content |
|---|---|---|---|
| 1 | Executive summary | What matters this month? | Headline results, drivers, risks, and decisions. |
| 2–3 | Income statement | How did we perform? | Month and year-to-date actuals, budget, prior-period comparisons. |
| 4 | Balance sheet | What changed in our financial position? | Key balances, movements, and reconciliation exceptions. |
| 5 | Cash and working capital | Where did cash move? | Opening-to-closing cash bridge and relevant working-capital detail. |
| 6–7 | Variance analysis | Why did results differ? | Material drivers, explanations, and supporting breakdowns. |
| 8 | Operating KPIs | What is happening in the business? | A focused set of defined measures and trends. |
| 9–10 | Outlook and actions | What happens next? | Updated expectations, assumptions, decisions, owners, and due dates. |
Show the reporting period, entity scope, currency, unit scale, and version on the cover or control page. Label provisional figures clearly. A management team should be able to tell whether it is looking at a closed month, a partial period, or an updated forecast.
3. Write the executive summary around the story
The summary should make the rest of the pack easier to interpret. Draft it after reviewing the supporting pages, then place it first. Use the same definitions and figures as the detailed reports.
A practical summary has four parts: performance, explanation, outlook, and decisions. For example:
Revenue finished below plan because shipment volume was lower, partly offset by higher realized prices. Operating expenses were below budget because a role remained unfilled; the operational effect needs review. Cash increased during the month, supported by collections. The sales director will confirm the status of delayed orders, while the operations lead will assess delivery capacity before the forecast review.
This is illustrative commentary, not a report about a Calculom customer. In a live pack, quantify material movements, identify the evidence, and distinguish confirmed facts from assumptions.
Avoid filling the summary with every line that moved. Select the changes that affect the business discussion. If a conclusion relies on a forecast, show the assumption and its owner rather than presenting it as a settled outcome.
4. Connect profit, financial position, and cash
The income statement, balance sheet, and cash analysis should describe the same reporting scope. Reconcile the source totals before explaining the movements. For multi-entity reporting, make clear whether balances are shown before or after consolidation adjustments.
Income statement
Show the current month and year-to-date position, with the comparisons leadership needs. Keep actuals, approved budget, prior-year results, and latest forecast distinctly labeled. Include margins where useful and explain material changes in the underlying drivers.
Balance sheet
Highlight movements in balances such as receivables, inventory, payables, debt, and cash. Connect the balance sheet to the relevant reconciliation or aging schedule. A large increase in revenue is easier to assess when readers can also see whether receivables and collections moved with it.
Cash and working capital
Show how opening cash connects to closing cash. This simplified bridge illustrates the structure:
| Movement | Amount |
|---|---|
| Opening cash | $300,000 |
| Net cash from operating activities | +$45,000 |
| Net cash used in investing activities | −$10,000 |
| Net cash used in financing activities | −$15,000 |
| Closing cash | $320,000 |
The movements reconcile to closing cash. They do not establish that the full cash balance is available for discretionary spending. Add context about committed payments, restricted balances, and expected receipts where relevant. If foreign-exchange movements or other reconciling items apply, include them explicitly. This example is not a complete statutory cash-flow statement.
5. Add operating KPIs and useful commentary
Choose operating measures that help explain financial performance. Depending on the business, these might include shipment volume, billable utilization, customer retention, headcount, or order backlog. A longer list is useful only if the additional measures support a decision.
ACCA’s performance-management framework includes analysis of financial and non-financial indicators and connecting reporting to business strategy. For your pack, apply that principle by linking each measure to a specific management question.
Define each KPI once and keep the definition alongside the workbook:
- Calculation: what is included in the numerator and denominator?
- Scope: which entities, departments, products, and periods are covered?
- Source: which system or approved schedule supplies the data?
- Ownership: who validates the measure and explains changes?
- Comparison: is the benchmark a target, budget, prior period, or forecast?
For example, define whether order backlog includes only confirmed, unfulfilled customer orders or also includes quotations. Changing that definition between months could create an apparent trend that reflects classification rather than business performance.
Use short commentary to connect significant movements to their drivers and actions. Our budget-versus-actual analysis guide includes worked examples and a structure for writing that explanation.
6. Organize the Excel workbook for repeat use
Separate inputs, calculations, and presentation so a reviewer can follow the flow. An example tab structure is:
00_Control
01_Executive_Summary
02_Income_Statement
03_Balance_Sheet
04_Cash
05_Variances
06_Operating_KPIs
07_Outlook_Actions
90_Source_Data
91_Account_Mapping
92_ChecksUse the control tab to record the period, budget version, entities, currency, data refresh time, preparer, reviewer, and release status. Avoid repeating these selections independently across tabs.
Keep account mappings and KPI definitions in identifiable schedules. Make manual adjustments visible, with an explanation and reviewer, instead of overwriting connected figures. Add checks for unreconciled totals, unmapped accounts, missing inputs, and inconsistent periods.
For the presentation tabs, set print areas, repeat column headings where needed, and check the PDF output. Use readable units and consistent number formats. If a table is too wide, reconsider its comparisons or move supporting detail to a separate page.
A chart should make a specific comparison easier to read. Label its units and periods, and keep scales consistent when comparing similar measures. Charts and commentary should use the same approved figures as the tables.
7. Review, release, and retain the pack
Make release a defined step, with someone accountable for the final version. Use this checklist before sending it:
- Confirm the reporting period, entity scope, currency, and approved budget version.
- Reconcile financial totals to the source reports and relevant supporting schedules.
- Review account mappings, manual adjustments, and any unresolved reconciliation items.
- Check that summary figures, tables, charts, and commentary agree.
- Validate KPI definitions and operational data with the responsible owners.
- Confirm that material explanations have evidence, an owner, and a next step.
- Review the final workbook and PDF for clipped columns, unreadable figures, and missing pages.
- Approve the recipient list and remove detail that recipients should not receive.
- Record approval and retain a dated copy of the released workbook and presentation.
- Carry open actions into the next review and check whether expected outcomes occurred.
Keep the released version separate from the working file. If a material correction is needed after distribution, issue a clearly labeled replacement with an explanation of what changed. A workbook that refreshes later should not silently replace the evidence of what management originally reviewed.
8. Build toward a connected reporting workflow
Once the pack structure is useful, review where your team spends time maintaining it. Repeated exports, inconsistent account mappings, and manual period changes are practical places to investigate.
Calculom brings connected ERP reporting into Excel so your team can build financial reports and budget comparisons in familiar tools. Explore Excel reporting, period refresh, and financial and operational context as you consider the workflow.
The pack layout and review process in this article are recommendations for your team to implement. Connected data does not replace reconciliations, management judgment, or approval of the released report.
For a related view of recurring report production, see our archived board-package automation guide; confirm current product availability with our team. To discuss your own reporting structure, request a Calculom demonstration and bring a sample pack layout.