Communicating Management Information: Tables, Charts, and Commentary

Learning objectives

• Select table and chart formats that match the management question, with clear labels, consistent units, and no misleading presentation.
• Present performance against plan using variance tables and simple visuals that highlight what matters for decisions.
• Write concise, decision-focused commentary that explains causes, consequences, and actions.
• Apply practical data quality, confidentiality, and distribution controls before sharing internal reports.

Overview & key concepts

Communicating management information is not about producing more numbers. It is about presenting the right numbers in a form that helps the reader make a decision. A good internal report makes performance easy to scan, easy to compare with a baseline, and easy to act on.

Internal reports do not create accounting entries. However, the figures in an internal report should be traceable to the underlying records and operational data. If numbers cannot be reconciled, confidence in the report quickly disappears.

Management reports

A management report is an internal document that summarises performance for planning, control, and decision-making. It usually combines:

• quantitative information (for example, actual vs budget costs, volumes, margins, productivity), and
• qualitative explanation (what drove results, what risks arise, and what actions are recommended).

Before building any report, be clear about:

• Audience: who will read it (and what they can influence).
• Purpose: what decision or action it should support.

Key performance indicators (KPIs)

KPIs are selected measures used to monitor progress toward an objective. They can be:

• financial (for example, gross margin %, cost per unit, receivables days), or
• non-financial (for example, on-time delivery %, defect rate, customer complaints).

A KPI must be clearly defined, consistently calculated, and linked to something the business can influence.

Variance analysis

Variance analysis compares actual performance to a baseline, commonly:

• budget (planned target),
• forecast (updated expectation), or
• prior period (historical comparison).

Variances are often labelled:

• favourable (F)when performance is better than the baseline for the objective, and
• adverse (A)when performance is worse than the baseline for the objective.

Define “good” in the context of the KPI (for example, higher margin is good; lower defect rate is good), then apply the same sign rule consistently across tables and charts.

Materiality and thresholds (internal focus)

Materiality in internal reports is about decision impact: a variance is material if it could change what a manager does next. Many organisations use a simple exception rule, such as:

• report itemsover £Xorover Y%, and
• focus on items that arecontrollableby the report owner.

Data validation

Data validation is checking that reported figures are complete, accurate, and consistent before circulation. Typical checks include reconciling to source systems, confirming that totals agree to supporting detail, and investigating unusual movements.

Dashboards

Dashboards present several measures together to support rapid scanning. They work best when they:

• show a small number of measures that matter,
• use consistent periods and units, and
• highlight exceptions rather than forcing the reader to hunt for problems.

Visual encoding

Visual encoding is how a chart communicates information (for example, bar length, position on an axis, or a trend line). Clear visuals use simple encodings and avoid decorative effects that distort comparisons.

Baseline

A baseline is the reference point used to interpret performance (budget, forecast, or prior period). A variance is only meaningful if the baseline is relevant and prepared on a comparable basis.

Narrative commentary

Narrative commentary explains what the numbers mean and what should happen next. Strong commentary is selective: it focuses on the few points that drive decisions, not on repeating every line of the table.

Exception reporting

Exception reporting highlights only items outside agreed thresholds (for example, variances above ±10% or above a £ limit). It keeps reports short and directs attention to what needs action.

Time series

Time series data is ordered by time (daily, weekly, monthly). It is used to identify trend, seasonality, and turning points. A single month’s variance may be a one-off; a time series can show whether a pattern is emerging.

Confidentiality

Confidentiality means restricting sensitive information to those who need it and avoiding unnecessary personal or commercially sensitive detail. Internal reports should be distributed securely, on a need-to-know basis, with personal data minimised or aggregated.

Core approach

Selecting table and chart formats

Choose the format that answers the question.

Tables are best when the reader needs exact numbers, such as:

• budget vs actual by cost category,
• detailed volumes and rates, or
• reconciliations and supporting calculations.

Charts are best when the reader needs to see a pattern quickly, such as:

• trend over time,
• ranking across departments, or
• whether results are clustered or unusual.

Practical rules for clarity

• State units once (for example, “£” or “£000”).
• Label periods clearly (for example, “January” and “Year-to-date”).
• Avoid unnecessary decimals unless they change the decision.
• Use one sign convention and stick to it.
• If a chart is used, state what it compares and what the baseline is.

Constructing variance tables

A well-built variance table typically includes:

• baseline (Budget / Forecast / Prior period),
• actual,
• variance in money terms,
• variance percentage, and
• an F/A indicator (optional but often helpful).

Recommended approach (for costs)

• Variance (£) = Actual − Budget
• Variance (%) = Variance (£) ÷ Budget
• Label asAif Actual > Budget (overspend) andFif Actual < Budget (underspend).

Variance percentage edge cases (judgement required)

• If thebudget is zero or very small, percentages can be misleading: consider showing “n/m” (not meaningful) and using a £ threshold instead.
• If thebudget is negative(rare, but possible with rebates/credits), state the basis clearly and consider using an alternative baseline (for example, prior period) to avoid confusing percentages.

Choosing chart types

Use chart types that make comparison easy.

• Bar/column chart: best for comparing departments or categories in one period.
• Line chart: best for showing movement over time.
• Scatter plot: best for relationships (for example, volume vs cost).
• Stacked charts: use cautiously; they can hide comparisons unless the goal is composition.

Good chart habits

• Start the value axis at zero for bar/column charts unless there is a strong reason not to.
• Use a clear baseline (for example, a zero line for variances).
• Keep titles descriptive (for example, “Cost variances vs budget (January)”).
• Avoid 3D effects and heavy formatting that distracts from the message.

Decision commentary (clear, action-led)

Use a structure that forces the commentary to answer the decision question:

• So what?State the outcome in one line (the headline variance and the main driver).
• Why?Explain the two or three causes that move the decision, each backed by a number. Separate timing effects from underlying performance.
• What next?Specify actions that change the trajectory: what will be done, by whom, and by when (include any approvals needed).
• How we’ll know: Set the follow-up measure(s) for next month and what “back on track” looks like.

Good commentary adds interpretation and direction; it should not re-list every variance line-by-line.

Pre-release checks: five quick steps

Before distributing a report, apply a short process:

1. Reconcilekey totals to source systems (ledger for £ figures; operational systems for volumes).
2. Confirm comparability(same period cut-off, same inclusions/exclusions, same allocation rules).
3. Sense-check movement(large swings, one-offs, reversals, reclassifications) and document the reason.
4. Verify calculations(percentages, denominators, rounding, and any lines with tiny/zero budgets).
5. Approve and control distribution(version number, report owner, access list, secure storage and sharing method).

Confidentiality controls should match the audience: aggregate personal pay data, remove unnecessary identifiers, and circulate only on a need-to-know basis.

Avoiding common classification errors (linking reports to records)

Internal reports analyse results; they do not create accounting entries. However, performance measures often go wrong when basic classifications are misunderstood. Examples (illustrative):

Sales tax / VAT (output tax)
Amounts charged to customers as sales tax/VAT collected on behalf of the tax authority are not revenue.

• Dr Trade receivables / Cash (gross)
• Cr Revenue (net)
• Cr Sales tax/VAT payable (output tax)

Sales returns
Returns reduce revenue (and may also reverse cost of sales if inventory is returned and tracked):

• Dr Sales returns (or reduce Revenue)
• Cr Trade receivables / Cash
• (If applicable) Dr Inventory; Cr Cost of sales

Early settlement discounts
Early settlement discounts reduce the consideration expected/received, so they reduce net revenue (even if tracked internally in a separate “discounts” account for reporting). A common bookkeeping presentation is:

• Dr Cash (amount received)
• Dr Discount allowed (contra revenue)
• Cr Trade receivables (amount originally invoiced)

Depreciation
Depreciation allocates the cost of an asset over its useful life:

• Dr Depreciation expense
• Cr Accumulated depreciation

Loan repayments
Loan principal is not an expense. Interest (if included) is an expense and should be separated for analysis:

• Dr Loan payable (principal)
• Dr Interest expense (if applicable)
• Cr Cash

Worked example

Narrative scenario

Consider a manufacturing company, ABC Ltd, which produces consumer electronics. The company prepares monthly management reports to monitor departmental performance.

Departmental cost performance (budget vs actual) for January:

• Production department incurred £52,800 in costs, against a budget of £48,000.
• Logistics department spent £11,900, under the budget of £12,500.
• Administration costs were £10,350, exceeding the budget of £9,000.

Other January activity included:

• Sales revenue for the month was £188,000.
• A new machine was purchased for £120,000 and capitalised as a non-current asset.
• Sales tax/VAT (output tax) of 15.7% was applied to all sales.
• A discount of 6.1% was offered on early payments.
• Interest on overdue balances amounted to £500.
• Payroll expenses totalled £45,000.
• A customer returned goods worth £2,000.
• Depreciation on machinery was calculated at £5,000.
• A loan repayment of £10,000 was made.

Note: Not all items above feed directly into departmental cost variances. They are included to illustrate common classification and reconciliation issues when building KPIs and internal reports.

Required

1. Calculate the variances for each department.
2. Prepare a variance table showing budget, actual, variance, and variance percentage.
3. Choose an appropriate chart type to visualise the variances.
4. Write a brief commentary explaining the variances and recommending actions.
5. Identify any data quality or confidentiality issues in the report.

Solution

1) Calculate variances (costs)

For costs: Variance (£) = Actual − Budget.

• Production: £52,800 − £48,000 =£4,800 (A)
• Logistics: £11,900 − £12,500 =£(600) (F)
• Administration: £10,350 − £9,000 =£1,350 (A)

Net variance across the three departments:
£4,800 − £600 + £1,350 = £5,550 (A)

2) Variance table (January, £)

Notes on presentation

• Brackets show favourable cost variances (underspend).
• Total variance % = £5,550 ÷ £69,500 =8.0% (A).
• If any budget line were zero or immaterial, show “n/m” for the % and rely on a £ threshold and narrative explanation.

3) Chart choice

Use a diverging bar (or column) chart of variances with a clear zero line. This makes overspends and underspends immediately visible and supports quick comparison across departments.

4) Commentary (So what / Why / What next / How we’ll know)

So what? Departmental costs were £5,550 over budget (8.0% adverse), mainly due to Production.

Why?

• Productionoverspent by£4,800 (10.0% adverse), suggesting either higher input prices, overtime, waste/rework, or higher activity without matching budget assumptions.
• Administrationoverspent by£1,350 (15.0% adverse), consistent with timing differences or one-off charges.
• Logisticswas£600 under budget (4.8% favourable), partly offsetting overspends elsewhere.

What next?

• Production: break the variance into price vs efficiency drivers (materials, labour, scrap, downtime) and confirm whether output volume changed.
• Administration: identify one-off items (for example, annual fees, recruitment, professional costs) and decide whether to rephase the budget or tighten approvals for discretionary spend.
• Logistics: confirm whether the underspend is sustainable (process improvement or contract savings) or a timing effect that may reverse.

How we’ll know Track next month’s unit cost, overtime hours, scrap/rework rate, and any committed administration spend. Define a target (for example, Production variance within ±2% and overtime back to normal levels).

5) Data quality and confidentiality issues

Data quality checks highlighted by the scenario

• Comparability of budget vs actual: confirm whether depreciation (£5,000) and payroll (£45,000) are included in departmental costs or held centrally; the variance table must compare like with like.
• Sales tax/VAT: confirm whether the £188,000 sales figure is stated gross or net of sales tax/VAT; performance KPIs should use net revenue, with sales tax/VAT analysed separately as a liability.
• Returns: confirm whether the £2,000 return is at selling price and whether it is gross or net of sales tax/VAT; ensure revenue (and, where relevant, inventory/cost of sales) is adjusted consistently.
• Discount and interest: keep early settlement discounts (which reduce net revenue collected) separate from interest on overdue balances (£500), which is a different income stream.
• Loan repayment: confirm whether the £10,000 includes interest; principal repayment is not an operating expense.

Confidentiality and distribution controls

• Payroll: avoid individual pay detail; report payroll totals by department unless individual data is essential and access is restricted.
• Customer-specific issues: if returns or overdue interest relate to identifiable customers, limit identifiers to those who need them to act.
• Secure circulation: apply version control (for example, “v1.0”), name a report owner, restrict the access list, and use secure storage/sharing methods appropriate to the sensitivity of the information.

Common pitfalls and misunderstandings

• Misclassifying favourable/adverse: define what “good” means for each KPI and apply the same sign convention in every table and chart.
• Percentage errors: using the wrong denominator, or showing percentages when budgets are tiny/zero and the result becomes misleading.
• Ignoring controllability: focusing on variances that a manager cannot influence, while missing those they can.
• Budget and actual not comparable: mixing central costs and departmental costs, or inconsistent cut-off rules.
• Confusing cash with expense: treating loan principal or capital purchases as operating costs.
• Misstating revenue: including sales tax/VAT in revenue or failing to reflect discounts in net revenue.
• Overloaded visuals: too many series, effects, or annotations that obscure the message.
• Truncated axes: bar charts that do not start at zero and exaggerate differences.
• False precision: unnecessary decimal places that imply accuracy beyond the data quality.
• No actions: describing variances without stating what will change as a result.

Summary and further reading

Effective internal reporting relies on three core skills:

• presenting performance against plan in clear variance tables,
• using simple visuals to highlight exceptions and patterns, and
• writing short commentary that links results to causes and actions.

Reports remain useful only if they are trusted and safely distributed. Build in quick validation and comparability checks, apply sensible materiality thresholds, and control confidentiality through need-to-know distribution, aggregation of sensitive data, and secure storage.

For further study, read broadly on budgeting, performance measurement, and data visualisation principles, focusing on clarity, comparability, and decision usefulness.

FAQ

What is the importance of selecting the right chart type in management reporting?
The chart type determines what the reader notices first. Bar/column charts support category comparison, line charts highlight trend, and scatter plots show relationships. Choosing the right type reduces misinterpretation and helps the reader identify the message quickly.

Does variance analysis change the accounting records?
No. Variance analysis is an internal comparison and does not create accounting entries. However, it can reveal posting errors, cut-off issues, or misclassifications that may need correction in the underlying records.

Why is data validation important in management reporting?
If figures cannot be traced back to source data, confidence in the report collapses and decision-making suffers. Validation (reconciliations, comparability checks, and reasonableness tests) helps ensure the report reflects reality rather than processing errors.

How should early settlement discounts be reflected in performance reporting?
Early settlement discounts reduce the consideration expected/received and therefore reduce net revenue. Even if tracked in a separate internal account for analysis, performance measures should reflect revenue net of discounts expected or granted.

How can confidentiality be maintained in management reporting?
Restrict distribution to those who need the information, aggregate personal data, remove unnecessary identifiers, use secure sharing methods, and apply version control and ownership so that sensitive reports do not circulate uncontrolled.

Glossary

Management reportAn internal document that summarises performance and supports planning, control, and decision-making, using both numbers and narrative explanation.

Key performance indicator (KPI)A defined measure used to track progress toward an objective. It should be consistent, understandable, and actionable.

VarianceThe difference between actual results and a baseline (such as a budget, forecast, or prior period).

Favourable / adverseLabels applied to variances based on whether performance is better or worse than the baseline for the relevant objective.

Materiality (internal)The extent to which an item could change a decision or trigger action, considering both size and context.

Data validationChecks performed to confirm that reported figures are accurate, complete, consistent, and traceable to supporting data.

Dashboard
A compact display of several measures designed for quick scanning, often highlighting exceptions and trends.

Visual encodingThe method a chart uses to communicate values (for example, length, position, or a trend line).

BaselineThe reference point used to interpret performance (budget, forecast, or prior period).

Narrative commentaryA short, structured explanation of results that identifies drivers, implications, and recommended actions.

Exception reportingA reporting approach that highlights only items outside set thresholds to focus attention on what needs action.

Time seriesData ordered by time period, used to identify trend, seasonality, and changes in performance.

ConfidentialityProtecting sensitive information by controlling access, limiting detail, and distributing reports only to those who need them.