What you will learn
A useful financial review starts by proving the report dates and underlying balances. Practise a comparison that shows higher sales alongside a weaker margin, then build a conclusion supported by evidence.
By the end, you can
- Verify report scope and comparative periods.
- Trace a figure through report breakdowns to accounting evidence.
- Calculate a change and distinguish it from its cause.
- Produce a concise review note and consistent report pack.
Before you begin
- Use the supplied fictional figures for the exercise.
- Know the purpose of the profit and loss account and balance sheet.
- For client work, use a reviewed trial balance and comparable reporting periods.
1. Confirm what the report covers
Select the correct client and confirm From and To dates in Reports. Apply the dates before reading the figures. Review the comparative headings and whether comparative columns, ratios and nil balances are required for the task.
A three-month report should not be described as a full-year result. A balance sheet is a position at a date, while the profit and loss describes activity over a period. Read the headings before drawing a conclusion.
For the report controls, use Reports help. When sharing a pack, retain the client, date range and report names with the file so the recipient can identify its scope.
2. Calculate what changed
Fictional Juniper Studio reports the following for two comparable full years. All figures are already reviewed, and the cost categories are consistent.
| Measure | Current year | Prior year |
|---|---|---|
| Revenue | £100,000 | £80,000 |
| Direct costs | £60,000 | £40,000 |
| Gross profit | £40,000 | £40,000 |
| Operating expenses | £16,000 | £12,000 |
| Operating profit | £24,000 | £28,000 |
Revenue increased by £20,000, or 25%. Gross profit stayed at £40,000. Gross margin fell from 50% to 40%, a fall of ten percentage points. Operating profit fell by £4,000.
Try this. Calculate the change in revenue and gross margin. Write one statement that the figures prove, and one question you would ask before explaining the cause.
3. Trace the amounts behind the change
Open the breakdown behind a material report amount. Check the account, dates, source references and movements. If the report contains several pages of detail, review the complete relevant breakdown before treating the visible page as the whole balance.
For Juniper, inspect the direct-cost accounts first. Check whether the current year includes a different classification, a year-end adjustment or genuinely higher costs. Then review the increase in operating expenses.
Use the nominal ledger and source records to establish the explanation. A graph or ratio shows a pattern; it does not establish which invoice or business decision caused it. Retain evidence for the conclusion you present.
4. Connect performance to the balance sheet
Review customer and supplier balances, bank reconciliations, loans, payroll controls and year-end schedules alongside profit. Revenue can increase while customers take longer to pay. Cash can improve because of a loan advance rather than stronger trading.
Check material receivables against the underlying customer amounts and settlements. Check loan balances against their schedules. Confirm that period-end accruals and prepayments have been considered consistently.
This prevents a plausible profit explanation from overlooking an incomplete balance sheet. Use year-end reports help and the relevant schedule help when following a balance.
5. Write a conclusion with a clear limit
A supported first conclusion is: “Revenue rose 25%, but direct costs absorbed the increase. Gross profit stayed at £40,000, and higher operating expenses reduced operating profit to £24,000.”
An unsupported conclusion would name price discounting or supplier inflation as the cause without examining the transactions. List the next evidence needed: sales mix, job profitability, purchase pricing or classification changes.
Keep the report version consistent with the figures in your note. If the ledger changes after review, regenerate the relevant reports and recheck the explanation. Share the appropriate detail for the audience rather than expecting the recipient to reconstruct your analysis.
Model answer and completion check
Model answer: sales growth is 25%; gross margin falls from 50% to 40%; operating profit falls by £4,000. The data explains the numerical movement, but does not by itself establish the commercial cause.
Your review note should state the client, periods, figures, checks completed, supported explanation and open question. For this case, the open question is why direct costs increased faster than revenue.
Before completing the exercise, ask whether a reviewer can reproduce each percentage from the attached reports. Check that “ten percentage points” has not been written as “10%”: those statements describe different changes.
Check your understanding
Read the answer and explanation
A fall of ten percentage points.
The difference between the two percentages is ten percentage points. Gross profit can remain constant while the margin changes.
Optional: selecting this button saves only this lesson’s completion on this browser. It does not create a Balansix training record or certificate, and it will not follow you to another device.