Your profit and loss statement says net income grew 20% this year. Congratulations — or maybe not. If your revenue grew 40% over the same period, your business actually got less profitable per dollar of sales, and the headline number just hid it from you. Raw dollar amounts answer "how big?" but never "how healthy?" — and as your business grows, the gap between those two questions becomes the place where margin erosion hides.
Two classic techniques close that gap, and they work best as a pair. Vertical analysis (also called common-size analysis) converts every line of a financial statement into a percentage of one base figure, so you can see your cost structure at a glance. Horizontal analysis compares the same line across two or more periods, so you can see which way each piece is drifting. This guide shows how to run both on your own books, what each one catches that the other misses, and the bookkeeping habits that make the percentages trustworthy.
Vertical Analysis: Turning a Statement Into Percentages
Vertical analysis restates every line item as a percentage of a single base amount from the same period — hence "vertical," because you read down one column. The base depends on the statement:
- Income statement: every line is a percentage of net sales (revenue).
- Balance sheet: every line is a percentage of total assets (which equals total liabilities plus equity).
The formula is always the same: line item divided by base figure, times 100.
A Worked Example
Imagine your freelance design studio closed the year with this income statement:
| Line item | Amount | Common-size % |
|---|---|---|
| Revenue | $240,000 | 100.0% |
| Subcontractor costs | $72,000 | 30.0% |
| Software and tools | $14,400 | 6.0% |
| Rent and utilities | $21,600 | 9.0% |
| Marketing | $12,000 | 5.0% |
| Other operating expenses | $24,000 | 10.0% |
| Operating income | $96,000 | 40.0% |
| Income tax | $24,000 | 10.0% |
| Net income | $72,000 | 30.0% |
Nothing here required more than division, but the percentages tell a story the dollars don't: thirty cents of every revenue dollar goes to subcontractors, and you keep thirty cents as net income. That 30% net margin is now a number you can compare against last year, against another studio of any size, or against an industry benchmark — comparisons raw dollars can never make, because a $72,000 profit means something entirely different at $240,000 of revenue than at $2.4 million.
What Vertical Analysis Is Best At
Revealing cost structure. The percentage column is your business's recipe: this much materials, this much labor, this much overhead. When a client asks why a quote went up, the answer lives here.
Comparing across sizes. A competitor doing ten times your revenue is directly comparable once both statements are in percentages. If their subcontractor line is 22% and yours is 30%, you have a structural cost gap worth investigating — not just a scale difference.
Spotting one-period distortions. A single unusual item jumps out in percentage form. If "other operating expenses" normally runs 10% and this period shows 18%, something happened — an equipment purchase miscoded as an expense, a duplicated entry, a fraud-shaped hole. Managers generally want expense percentages to shrink over time and profit percentages to grow; any line moving the wrong way earns a follow-up question.
Reading a Common-Size Balance Sheet
The same trick works on the balance sheet with total assets as the base. Suppose your year-end balance sheet shows $180,000 in total assets, of which accounts receivable is $54,000 (30%) and cash is $18,000 (10%). Those two percentages describe your liquidity posture in one glance: nearly a third of everything you own is money customers owe you, while only a tenth is money you can spend today. If receivables were 18% of assets last year, your collection process is slipping even if total assets grew — a conclusion the dollar growth alone would have obscured.
On the other side of the balance sheet, liabilities as a percentage of total assets show leverage. Total liabilities at 65% of assets means creditors fund nearly two-thirds of the business; drifting from 50% to 65% over two years is a trend worth understanding before a lender points it out to you.
Horizontal Analysis: Measuring Change Across Periods
Horizontal analysis reads across periods instead of down one column. For each line item, you compute the dollar change and the percentage change from a prior period:
- Dollar change = current period amount − prior period amount
- Percentage change = dollar change ÷ prior period amount × 100
A Worked Example
Take the same studio's revenue and key expenses over two years:
| Line item | Last year | This year | $ change | % change |
|---|---|---|---|---|
| Revenue | $200,000 | $240,000 | +$40,000 | +20.0% |
| Subcontractor costs | $52,000 | $72,000 | +$20,000 | +38.5% |
| Software and tools | $12,000 | $14,400 | +$2,400 | +20.0% |
| Marketing | $10,000 | $12,000 | +$2,000 | +20.0% |
| Net income | $64,000 | $72,000 | +$8,000 | +12.5% |
Revenue grew 20% and net income grew 12.5% — good news on the surface. But subcontractor costs grew 38.5%, nearly twice as fast as revenue. That single row is the story of your year: every new dollar of revenue cost you more to deliver than the last one. Without horizontal analysis, you'd celebrate the 20% growth; with it, you know to renegotiate subcontractor rates or raise prices before the margin compresses further.
Trend Analysis: Horizontal Analysis Over Many Periods
When you extend horizontal analysis beyond two periods, it becomes trend analysis. The usual approach picks a base year, assigns it an index value of 100, and expresses every later year as an index relative to it: index = (year's amount ÷ base year's amount) × 100. A revenue index running 100 → 118 → 120 → 145 across four years shows at a glance that growth stalled in year three and reaccelerated in year four — a shape that's harder to see in a column of dollar figures.
Base-year choice matters. Pick a normal year, not your best or worst one: indexing off a pandemic-collapse year makes every later year look heroic, and indexing off a windfall year makes normal performance look like decline. If the business changed fundamentally (you pivoted from hourly work to productized services, say), rebase — comparing post-pivot results to a pre-pivot base mixes two different businesses into one trend line.
How the Two Methods Work Together
Neither technique is complete alone, and the interesting findings live in the overlap:
- Vertical says "what," horizontal says "where it's going." A 30% subcontractor ratio tells you the cost structure; horizontal analysis showing it climbing from 26% to 30% over three years tells you it's a problem in motion.
- Horizontal catches absolute drift; vertical catches relative drift. An expense that grows 5% a year looks disciplined — until vertical analysis shows revenue shrinking, so that "disciplined" 5% growth is actually consuming a larger slice of a smaller pie.
- Run vertical first, then horizontal. Convert each period to common-size percentages, then run horizontal analysis on the percentages themselves. Watching gross margin move 64% → 62% → 59% across three years is the single fastest way to detect margin erosion, because it strips out growth entirely and shows pure profitability decay.
A practical monthly routine: after you close the books, add the common-size column to your income statement, then compare three or four key percentages (gross margin, each major expense category, net margin) against last month and the same month last year. Fifteen minutes, once a month, catches cost creep while it's still cheap to fix.
Benchmarking: Comparing Yourself to the Industry
Common-size percentages unlock external comparison in a way dollars never can. Industry data providers and trade associations publish typical expense ratios by sector — a restaurant group might report food costs at 28–32% of revenue, or a services benchmark might show labor at 45–55%. Lining your percentages up against those bands tells you which lines are outliers.
Two cautions. First, compare like with like: your percentages must be computed on the same basis as the benchmark (same revenue definition, same category boundaries), or the comparison is noise. Second, an outlier is a question, not a verdict. Marketing at 12% against a 5% benchmark might mean wasteful spending — or a deliberate growth investment that's working. The analysis tells you where to look; judgment decides what it means.
Mistakes That Make the Percentages Lie
Inconsistent categories. If subcontractor costs were booked partly to "contract labor" last year and partly to "professional services" this year, neither year's percentage is comparable. Consistent account usage across periods is the entire foundation — more on this below.
One-time items distorting the base. A big one-off gain inflates net income as a percentage of sales and makes the year look structurally more profitable than it is. When you spot a percentage that jumps for a non-recurring reason, recompute with the item removed (or footnoted) so the trend line reflects the ongoing business.
Ignoring the absolute dollars. Percentages need their dollar context. An expense jumping 200% sounds alarming until you see it went from $150 to $450. Always read the percentage change alongside the dollar change — horizontal analysis gives you both for exactly this reason.
Seasonality. Comparing December to January in a seasonal business manufactures trends out of calendar effects. Compare against the same period last year, or use trailing-twelve-month figures, before concluding anything is drifting.
Changing the base mid-stream. Switching revenue definitions (gross vs. net of refunds, say) between periods silently rewrites every percentage. If you change a definition, restate the prior period on the new basis so the comparison stays honest.
The Bookkeeping That Makes It Work
Every analysis in this guide assumes one thing: that the same kind of spending lands in the same account every month. When it does, your percentages are signal; when similar expenses scatter across three accounts depending on who entered them, the percentages are noise and no amount of analysis recovers the truth. Accurate bookkeeping from day one is what makes year-over-year comparison possible at all — the analysis is only as consistent as the ledger behind it.
Plain-text accounting makes this consistency checkable. Because every transaction is a readable line in a version-controlled file, you can verify that a category means the same thing this year as last, and queries compute the ratios directly from the source of truth. A freelancer tracking the studio above might structure subcontractor spending under one dedicated account:
2026-01-15 * "Client project" "Contract illustrator - homepage assets"
Expenses:Subcontractors:Illustration 850.00 USD
Assets:Checking -850.00 USD
2026-01-31 * "Monthly close" "Subcontractor accrual - January"
Expenses:Subcontractors:Accrued 400.00 USD
Liabilities:Accrued-Expenses -400.00 USDWith one account subtree holding all subcontractor costs, a single query produces the ratio behind the analysis — total subcontractor spend divided by total revenue — for any period, computed identically every time. If you're new to this style of bookkeeping, the documentation walks through setting up accounts and running your first queries, and the Fava dashboard renders income statements and balance sheets you can export straight into a common-size worksheet.
Start With Last Month
You don't need special software to begin — a spreadsheet and your last twelve months of statements are enough. Convert last month's income statement to percentages of revenue, lay it beside the same month last year, and compute the change on each major line. The lines with the biggest percentage-point moves are your agenda: each one is either a decision you made on purpose or a drift you hadn't noticed. Either way, you now know where your next hour of financial attention should go — and next month, the same fifteen-minute routine keeps the picture current.
