Most SME owners look at their profit and loss account and ask one question: did we make more money than last year? That is a fair question, but it is the wrong starting point if you want to understand what is actually happening in the business. A company can grow turnover by 15 percent and still be quietly losing money on every sale, because costs are creeping up faster than revenue. If you only glance at the bottom line, you will miss it until the cash runs tight. Horizontal and vertical analysis are two simple techniques that let you see both the direction of travel and the shape of your finances at the same time — without needing an accountancy qualification to do it.
What Horizontal and Vertical Analysis Actually Mean
Horizontal analysis simply compares the same line item across two or more periods and works out the change in pounds and as a percentage. It answers the question: is this number growing, shrinking, or staying flat, and by how much? Vertical analysis takes a single period and expresses every line as a percentage of one base figure — usually turnover for the profit and loss account, or total assets for the balance sheet. It answers a different question: how is the pound I earned actually being spent, and has that structure changed? Used together, these two views stop you from being fooled by growth. Horizontal analysis shows you the trend; vertical analysis shows you whether the trend is healthy or whether costs are eating into it.
Worked Example: Three Years of a Growing SME
Take Ashcroft Fabrications Ltd, a metalwork business that has been growing steadily for three years. On the surface the story looks good — turnover is up every year. But when the owner ran a horizontal and vertical analysis on the last three sets of accounts, a different picture emerged.
| Line item | 2022 (£) | 2023 (£) | 2024 (£) | Change 2022→23 | Change 2023→24 |
|---|---|---|---|---|---|
| Turnover | 850,000 | 980,000 | 1,120,000 | +15.3% | +14.3% |
| Cost of sales | 510,000 | 610,000 | 710,000 | +19.6% | +16.4% |
| Gross profit | 340,000 | 370,000 | 410,000 | +8.8% | +10.8% |
| Operating expenses | 255,000 | 292,000 | 330,000 | +14.5% | +13.0% |
| Operating profit | 85,000 | 78,000 | 80,000 | -8.2% | +2.6% |
That is horizontal analysis in action: it shows year-on-year movement in pound terms and as a percentage. Notice that cost of sales grew faster than turnover in percentage terms in both years — 19.6 percent against 15.3 percent in the first period. Because the resulting £30,000 increase in gross profit was outpaced by a £37,000 rise in operating expenses, operating profit actually fell in 2023 even though turnover rose. Growth alone told a happy story; the horizontal comparison told the true one.
| Line item | 2022 (% of turnover) | 2023 (% of turnover) | 2024 (% of turnover) |
|---|---|---|---|
| Cost of sales | 60.0% | 62.2% | 63.4% |
| Gross profit | 40.0% | 37.8% | 36.6% |
| Operating expenses | 30.0% | 29.8% | 29.5% |
| Operating profit | 10.0% | 8.0% | 7.1% |
This is the vertical analysis: every figure restated as a percentage of turnover for that year. It shows the underlying structure has shifted. In 2022, for every pound of sales, 60 pence went on direct costs and 10 pence dropped through as operating profit. By 2024, direct costs were consuming over 63 pence of every pound, and operating profit had shrunk to just over 7 pence. The business is bigger, but structurally weaker.
| Turnover 2023 | £980,000 |
| Turnover 2022 | £850,000 |
| Increase in turnover | £130,000 |
| Horizontal % change (130,000 ÷ 850,000 × 100) | 15.3% |
| Cost of sales 2024 | £710,000 |
| Turnover 2024 | £1,120,000 |
| Vertical % (710,000 ÷ 1,120,000 × 100) | 63.4% |
The real value of these two techniques is what they show when you use them together. Horizontal analysis flags that something moved. Vertical analysis tells you whether that movement changed the shape of your business — and that is usually the more important question for an owner deciding where to act.
Why the Numbers Moved: A Real Transaction Behind the Trend
Percentages on a spreadsheet only matter if you can trace them back to real decisions and transactions. When Ashcroft’s finance manager dug into the 2024 operating expenses line, part of the increase came from a single accounting entry: a rise in the provision for doubtful debts, following two large customers falling into arrears. The provision had to be increased by £18,000 to reflect the risk that these balances might not be collected.
| Account | Dr | Cr |
|---|---|---|
| Bad debt expense (profit and loss account) | £18,000 | |
| Provision for doubtful debts (balance sheet) | £18,000 |
Increase in the provision for doubtful debts to reflect increased credit risk on two customer accounts, recorded within operating expenses for the year ended 2024.
That £18,000 does not look dramatic on its own, but it is a meaningful slice of the £38,000 rise in total operating expenses between 2023 and 2024. Without tracing this horizontal expense increase back to this journal entry, the owner might have assumed general cost inflation was to blame and reacted by cutting marketing or headcount. Instead, the real issue was credit control — the business needed tighter payment terms and closer monitoring of larger customers, not blanket cost-cutting.
Percentages can mislead when the base figure is small or when one-off items are included. A 50 percent jump in a cost line sounds alarming, but if it moved from £2,000 to £3,000, it barely affects the wider picture. Equally, a one-off grant, insurance payout, or asset sale can distort both horizontal and vertical figures for a single year. Always check whether a movement is a genuine trend or a one-off before you act on it.
Using This in Management Reporting and Decisions
For finance managers producing monthly or quarterly management packs, horizontal and vertical analysis should not be an annual exercise reserved for year-end accounts. Running both views every month against budget and against the same period last year gives you an early warning system. If gross margin as a percentage of turnover is drifting down two months in a row, you can raise it with the sales or production team before it becomes a year-end surprise. If a cost line is growing faster than revenue in percentage terms, that is your cue to ask why, rather than waiting for the accountant to flag it at the annual review.
The same logic applies to the balance sheet. Vertical analysis of assets — stock, debtors, and cash as a percentage of total assets — can reveal whether working capital is becoming tied up in slow-moving inventory or overdue customer balances, long before it shows up as a cash flow problem. Horizontal analysis of the same figures tells you how quickly that tie-up is building.
- Always read pound change and percentage change together — a growing turnover figure can hide a shrinking margin, as Ashcroft Fabrications discovered when cost of sales grew faster than sales in percentage terms.
- Use at least three years of data where possible, so you can tell a genuine trend from a one-off blip caused by a single transaction or unusual item.
- When a line item on your vertical analysis moves noticeably, trace it back to the underlying transaction or journal entry — do not assume it is general inflation until you have checked.
- Build both analyses into your regular management reporting, not just the annual accounts, so problems are visible while there is still time to act.
Want your management reports to show you the full picture?
We help SME owners and finance teams build reporting that goes beyond the bottom line, combining horizontal and vertical analysis with clear, jargon-free commentary you can act on.
