Presenting Management Information: Reports and Visuals

Learning objectives

By the end of this chapter, you should be able to:

• Prepare concise management reports for different audiences, focusing on decision usefulness and clear communication.
• Select appropriate tables and charts to present management accounting information accurately and efficiently.
• Interpret and critique visuals, identifying common sources of bias or distortion and improving clarity.
• Explain variances clearly and consistently, using short commentary that links outcomes to drivers and actions.

Overview & key concepts

Presenting management information is not the same as producing more information. The goal is to help a decision-maker understand what matters, why it matters, and what to do next. A well-designed report makes performance drivers easy to see, avoids visual distortion, and provides a brief narrative that turns numbers into actions.

Management reports are not created to “change” results. They summarise outcomes generated by underlying transactions and operational activity, and they should remain internally consistent with the entity’s source records.

Key Performance Indicators (KPIs)

KPIs are a small set of measures chosen to monitor progress toward defined objectives. A KPI is “key” because it is linked to a decision or a target, not because it is easy to calculate.

KPIs are often a mixture of:

• lagging indicators (what has already happened, e.g. operating margin), and
• leading indicators (signals that may predict future outcomes, e.g. order intake, delivery lead time).

Well-designed KPI sets are balanced: financial and non-financial, short-term and longer-term, and focused on what management can influence.

Dashboards

A dashboard is a compact display of selected KPIs and visuals designed for rapid monitoring. It helps managers spot patterns, exceptions, and emerging issues quickly, without reading long narrative text. The underlying data should be consistent with the entity’s “source of truth” (the systems and reconciliations the organisation relies on).

Variance reports

Variance reports compare actual performance to a benchmark such as a budget, standard, or prior period. They highlight differences and then explain the main drivers. Variances commonly relate to volume, price/rate, mix, yield, usage, and efficiency.

Variance reports support action: they identify where performance differs from expectations and provide a structured way to investigate causes.

Exception reporting

Exception reporting filters information so management attention goes to what is unusual or material. It works best when:

• thresholds are agreed in advance,
• alerts are linked to actions (who does what, by when), and
• routine “noise” is controlled so the most important items remain visible.

Narrative commentary

Narrative commentary is short, decision-focused explanation that:

1. states the headline result (what happened),
2. explains the drivers (why it happened), and
3. recommends actions (what happens next).

Effective commentary is selective. It prioritises the few factors that explain most of the movement.

Data visualisation

Data visualisation uses charts, graphs, and tables to show patterns and comparisons quickly. A visual should:

• match the purpose (comparison, trend, composition, relationship),
• use clear labels and units,
• avoid distortion (for example, misleading axis scales), and
• remain consistent with the numbers in the report.

Core theory and frameworks

Designing a report around the decision

Start by asking: what decision will be made after reading this? Then build the page so it answers that question in the fewest steps.

A practical way to do this is to structure the report as a “decision brief”:

• Decision needed: the choice to be made (or the discussion to be steered).
• What we should do: one clear recommendation or conclusion.
• What changed: the two or three movements that matter most (with amounts and direction).
• Why it changed: the main operational or commercial drivers, stated plainly.
• What happens next: actions, owner, and timing (and what you will measure to confirm impact).

If the report will be read by different audiences (for example, an executive team versus an operations meeting), keep the core story consistent but vary the level of detail. Senior readers typically need implications and priorities; operational readers need drivers and controllable actions.

Selecting appropriate visuals

Choose the visual based on what you want the reader to do:

• Compare categories → bar/column chart or a well-formatted table
• Show trend over time → line chart
• Show composition (parts of a whole) → stacked columns (often clearer than pie charts)
• Show relationship between two variables → scatter plot (with a trendline if helpful)

Use a table when precision matters and the reader needs exact values. Use a chart when the pattern is the message.

Writing commentary that earns its space

Keep commentary short and structured so the reader can grasp it in one pass:

• Result: state the outcome versus the benchmark (include the number).
• Reason: give the key drivers (focus on what explains most of the movement).
• Response: specify the action, owner, and expected effect (what will improve, by how much, and when you will review).

Avoid labels without causes (for example, “costs increased”). Link the driver to the outcome (for example, “unit material cost rose and returns increased, reducing net revenue”).

Quality, controls, and ethics checks

Before issuing a report, apply controls that protect reliability and reduce the risk of misleading conclusions:

• Reconcile key totals to source records (sales ledger, inventory records, payroll, supplier invoices).
• Check arithmetic, sign conventions, and units (units, £000, percentages).
• Ensure charts are not visually misleading (axis labels, scale, consistent time periods).
• Disclose material assumptions behind budgets, standards, and allocations.
• Protect confidentiality: show only what the audience needs to know.
• Maintain an audit trail: document the “source of truth”, calculation logic, and any manual adjustments, using clear version control so the report can be reproduced.

Handling variances

Variance analysis is most useful when it is consistent and reconcilable back to the overall difference versus benchmark.

For revenue, a common approach is:

• volume effect: difference in quantity at budget/standard price
• price effect: difference in selling price on actual quantity

For costs, common splits include:

• price/rate effect (what each unit of input cost)
• efficiency/usage effect (how much input was used for the output achieved)

Use a clear convention for labels:

• Favourable (F): improves profit versus benchmark
• Adverse (A): reduces profit versus benchmark

Avoiding misleading presentations

Misleading presentations usually come from avoidable design choices:

• cropped axes that exaggerate movements
• mixing time periods or using inconsistent units
• presenting net figures without showing the drivers (for example, returns and discounts)
• omitting assumptions that materially affect interpretation

The aim is not to make results look good. The aim is to make drivers easy to see and decisions easier to make.

Worked example

Narrative scenario

ABC Ltd produces a single product (widgets). Management is reviewing performance for the quarter and wants a short report explaining sales performance and key cost movements.

The following information relates to the quarter:

• Budgeted sales: 1,300 units at a budget selling price of £48 per unit.
• Actual sales: 1,200 units invoiced at £50 per unit.
• Sales returns: 50 units (credited at the same unit selling price as the original sale).
• Raw materials purchased: £15,000.
• Labour costs: £10,000.
• Production overheads: £5,000.
• Sales discount: £500 granted to a major customer (presented as a reduction of revenue).
• Raw material prices increased by 10% during the quarter (reported by purchasing).
• New production line acquired: £20,000 (capital expenditure).
• Marketing spend paid: £2,000.
• Supplier rebate received: £1,000 (used here to reduce raw material cost for management analysis).
• Opening trade receivables: £10,000.
• Closing trade receivables: to be determined.

Assume all sales and returns were on credit. Assume no customer receipts information is provided.

Required

1. Compute total sales revenue and net sales for the quarter.
2. Prepare a sales variance analysis comparing budget to actual net sales.
3. Identify and explain the main drivers of variance and key cost movements.
4. Recommend actions based on the analysis.
5. Determine closing trade receivables from the information given and explain what additional information would be required.

Solution

1) Total sales revenue and net sales

Total sales revenue = 1,200 units × £50 = £60,000

Sales returns (at selling price) = 50 units × £50 = £2,500

The £500 discount is presented as a reduction of revenue. For net sales in management reporting, it is therefore deducted from revenue.

Net sales = £60,000 − £2,500 − £500 = £57,000

2) Sales variance analysis using a revenue bridge

To keep the analysis reconciled and decision-useful, use a “revenue bridge” approach. Start with budget revenue, then show the movements that explain the change to actual net revenue. This avoids mixing drivers: price and volume explain gross invoiced sales, while returns and discounts are shown separately as revenue reductions.

Budget revenue = 1,300 × £48 = £62,400

Bridge movements:

Volume effect = (1,200 − 1,300) × £48 = £4,800 (A)

Price effect = (£50 − £48) × 1,200 = £2,400 (F)

Now adjust from gross invoiced sales to net revenue:

Returns (reduction of revenue) = £2,500 (A)

Discount (reduction of revenue) = £500 (A)

Reconcile:

Budget revenue £62,400
Less volume effect £4,800 (A) → £57,600
Add price effect £2,400 (F) → £60,000 (gross invoiced sales)
Less returns £2,500 (A) → £57,500
Less discount £500 (A) → £57,000 (actual net sales)

Overall variance:

Total sales variance = £57,000 − £62,400 = £5,400 (A)

3) Main drivers and key cost movements

Sales performance (drivers):

• Units sold were 100 below budget, giving a £4,800 adverse volume effect. This suggests weaker demand, lost orders, service issues, capacity constraints, or competitor pressure.
• The achieved selling price (£50) exceeded budget (£48), giving a £2,400 favourable price effect. This may indicate improved pricing discipline, market conditions, or customer/product mix effects.
• Returns (£2,500) and the £500 discount reduced revenue and should be analysed separately, as they can signal quality issues, delivery problems, or commercial pressure.

Cost movements (high-level):

Raw materials purchases were £15,000 and a supplier rebate of £1,000 was received.

For management analysis in this example:

Net raw material purchase cost (management view) = £15,000 − £1,000 = £14,000

Accounting presentation can vary by policy and substance. In practice, rebates are often netted against the related purchase/cost line when they are directly linked to purchases, but some entities may present certain rebates separately (for example, within other income). The key is consistency and clear disclosure in internal reporting.

A reported 10% increase in raw material prices suggests inflationary pressure, but its impact cannot be quantified from the information given. Without prior/standard prices and the quantities purchased, it is not possible to calculate a price variance or isolate how much of the £15,000 purchase value reflects price change versus volume/usage.

Labour (£10,000) and overheads (£5,000) are period production costs, but efficiency analysis requires hours, rates, output, and standards (not provided).

Marketing (£2,000) is an operating expense for the period.

The new production line (£20,000) is capital expenditure. It may affect future depreciation and capacity, but it is not a period expense in this scenario.

4) Recommended actions

• Volume shortfall:review demand drivers (customer retention, competitor moves, delivery performance, stock availability). Identify whether the issue is commercial (orders not won) or operational (orders not fulfilled).
• Returns:analyse returns by customer and reason. If quality-related, quantify the margin impact and prioritise root-cause fixes.
• Discount discipline:confirm the purpose of discounting (retention, volume incentive, dispute resolution). Track discounts as a percentage of gross sales by customer/channel and tighten approval controls.
• Materials cost risk:negotiate price agreements where feasible, consider alternative suppliers, and review specifications/value engineering without compromising quality.

5) Closing trade receivables and what would make it determinable

Receivables are driven by amounts invoiced to customers, less amounts credited (returns/allowances) and less cash received (and other settlement items such as set-offs). With the information provided, closing receivables can be expressed but not fully calculated because customer receipts are not given.

Receivables movement:

Closing receivables = Opening receivables + Credit sales invoices − Credit notes/adjustments − Cash received from customers

From the scenario:

• Opening receivables = £10,000
• Credit sales invoices (gross) = £60,000
• Sales returns credited = £2,500
• Cash received = not provided

Discount treatment affects receivables depending on how it is processed:

• If the £500 discount was recorded as a credit note (or invoice adjustment) on the customer’s account, it reduces receivables.
• If the £500 discount was treated as a separate rebate paid later (for example, a payment processed outside the sales ledger), it would not reduce receivables until it is actually paid or offset, even though it is presented as a reduction of revenue in management reporting.

If the discount is assumed to reduce receivables via a credit note:

Closing receivables = £10,000 + £60,000 − £2,500 − £500 − Cash received
Closing receivables = £67,000 − Cash received

If the discount is assumed not to reduce receivables at this stage:

Closing receivables = £10,000 + £60,000 − £2,500 − Cash received
Closing receivables = £67,500 − Cash received

To determine closing receivables numerically, the report would need at least:

• total cash collected from customers in the quarter (or a list of receipts), and
• confirmation of whether the £500 discount was credited against the receivables ledger or processed separately.

Supplier rebates do not affect trade receivables. They relate to suppliers and would affect payables/costs, not customer balances.

Common pitfalls and misunderstandings

• Treating KPIs as “important numbers” rather than measures linked to decisions and targets.
• Building KPI sets that are unbalanced (only financial, only lagging, or too many measures).
• Choosing visuals that do not match the message (for example, composition charts for trends).
• Distorting visuals with cropped axes, inconsistent time periods, or missing units.
• Presenting net figures without showing drivers (returns and discounts should often be visible).
• Mixing benchmark bases within a variance analysis and failing to reconcile back to the total difference.
• Treating capital expenditure as an expense when explaining period performance.
• Overlooking controls: lack of reconciliation, unclear sources, and no audit trail of calculations.
• Treating receivables as determinable from sales alone, without considering receipts and how credits/discounts are processed.

Summary

Effective management reporting turns data into decisions. Strong reports are concise, structured around the decision required, and supported by visuals that reveal the key movements without distortion. Variance analysis is most useful when it reconciles clearly back to the overall difference versus benchmark and separates distinct drivers such as volume, price, returns, and discounts. Reliable reporting depends on controls: reconciliations, transparent assumptions, and a documented audit trail from source data to reported numbers.

FAQ

What makes a KPI “key” rather than just a metric?

A KPI is tied to an objective and influences decisions. It is chosen because it signals progress toward a target or highlights risks that require action, not simply because it is available in the system.

How can visuals mislead in management reports?

Visuals can mislead through axis manipulation, inconsistent scales, missing units, selective time periods, or by hiding drivers inside net figures. Clear labels, consistent bases, and appropriate chart choices reduce this risk.

Why is narrative commentary essential?

Commentary explains drivers and implications. It helps the reader understand what changed, why it changed, and what action is recommended, which is the main purpose of management reporting.

What are common mistakes in variance analysis?

Common mistakes include inconsistent sign conventions, mixing up budget and actual bases, failing to reconcile variances back to the overall difference, and not showing separate revenue reductions such as returns or discounting.

How do you choose between a table and a chart?

Use a chart when the pattern is the message (trend or comparison at a glance). Use a table when exact values matter and the reader needs precision.

What is exception reporting used for?

Exception reporting highlights items outside agreed thresholds so management attention is focused on significant deviations, not routine fluctuations.

Why must totals be validated before publishing a report?

Errors undermine credibility and lead to poor decisions. Validation includes reconciling to source records, checking calculations and units, confirming assumptions, and keeping an audit trail of how figures were produced.

Glossary

Key Performance Indicator (KPI)
A selected measure linked to an objective, used to monitor performance and support decisions.

Leading indicator
A measure that tends to change before outcomes change, providing an early signal of future performance.

Lagging indicator
A measure that records outcomes after they occur, summarising results achieved.

Dashboard
A compact display of selected KPIs and visuals designed for rapid monitoring and early identification of issues.

Variance report
A comparison of actual results to a benchmark (such as budget or standard) with analysis of differences and drivers.

Exception reporting
A reporting approach that highlights items outside agreed thresholds, focusing attention on significant deviations.

Narrative commentary
Short explanatory text that interprets results, identifies key drivers, and recommends actions.

Benchmark
A reference point used for comparison, such as budget, prior period, target, competitor data, or best practice.

Data visualisation
The use of charts, graphs, and tables to present data so patterns and comparisons can be understood quickly.

Scale
The range and interval spacing on a chart axis, which can materially influence how changes appear visually.

Trend
A general direction of movement over time that becomes clear when viewed over an appropriate period.

Outlier
A value that differs substantially from the rest of the dataset and may require investigation or separate presentation.

Traffic-light indicators
A red/amber/green status display used to show performance versus thresholds at a glance.

Materiality threshold
A practical rule for deciding what is significant enough to report or investigate, based on impact and decision relevance.