TOOLS CLUB TEMPLATE

Common-Size Statement Analyzer

Comparing raw dollar figures across periods or against industry benchmarks can be misleading once a business grows or shrinks. This template expresses every line item on your P&L as a percentage of revenue instead, so you can compare cost structure over time — or against your industry — on an apples-to-apples basis.

Join the Tools Club — $7/mo Already a Member? Log In

Included in the $7/mo Tools Club · Works in Excel or Google Sheets · Includes a built-in AI prompt

Who this is for

Business owners tracking whether cost structure is improving or slipping as revenue changes
Anyone benchmarking their expenses against published industry ratios
Business owners preparing for a valuation, sale, or investor conversation
Students learning common-size (vertical) financial statement analysis

What's included

Every P&L line item automatically converted to a % of revenue
Side-by-side comparison across periods
Highlighted view of your largest cost categories as a share of revenue
Built-in AI prompt comparing your percentages to general industry benchmarks

Why use a template instead of starting from scratch?

A cost that grows from $10,000 to $15,000 sounds alarming until you realize revenue tripled in the same period — raw dollars alone can’t tell you if cost structure is actually improving or worsening. Common-size percentages strip out the effect of scale so you can see the real trend.

How to Use This Template

Download and open in Excel or Google Sheets

Requires a Tools Club membership — log in first to access the file.

Enter your P&L figures for one or more periods

Use the same line items you’d see on a standard P&L.

Let the template calculate each line as a % of revenue

This happens automatically once revenue and the line items are entered.

Compare percentages across periods

Look for cost categories that are growing as a share of revenue, even if the dollar trend looked fine.

Run the built-in AI prompt for a benchmark comparison

Attach the saved file to ChatGPT or Claude and ask how your percentages compare to typical benchmarks for your industry.

Built-in AI prompt

Once you've filled this template in, it includes a ready-to-use prompt at the bottom of the sheet. Attach your saved file to ChatGPT, Claude, or any AI chat tool and paste it in — you'll get plain-English feedback on how your cost structure percentages compare to general industry benchmarks, and which categories are trending in the wrong direction as a share of revenue, no accounting background required.

Common Mistakes to Avoid

Comparing common-size percentages across very different business models

A software company and a retail store have fundamentally different healthy cost structures — benchmark against businesses genuinely similar to yours.

Ignoring dollar amounts entirely

A shrinking percentage on a fast-growing revenue base can still mean a growing dollar cost — use common-size analysis alongside your regular P&L, not as a full replacement.

Only running this once, at year-end

The real value is in watching the trend over multiple periods — a single snapshot doesn’t show whether cost structure is improving or slipping.

Treating industry benchmarks as precise targets

Published benchmarks are averages across many businesses — useful for a general sense-check, not a number you need to hit exactly.

Frequently Asked Questions

What is common-size analysis?

It’s a method of expressing every line item on a financial statement as a percentage of a base figure — usually total revenue on the income statement, or total assets on the balance sheet — which makes comparison across different sizes or time periods much easier.

How is this different from just looking at percentages in my accounting software?

Most accounting software shows dollar figures by default. This template is specifically built to lay out every line as a percentage side by side, across multiple periods, for direct trend comparison.

Where can I find industry benchmark percentages to compare against?

Industry association reports, published financial ratio studies, and some accounting software with benchmarking features are common sources — the built-in AI prompt can also give you a general directional comparison.

Can I use common-size analysis on my balance sheet too?

Yes — the same principle applies, using total assets as the base instead of revenue. This template is focused on the income statement, where the technique is most commonly used.

Is this included in the free plan?

No, this is a Tools Club template. iLuvAccounting also has a free Profit and Loss Template if you just need the standard dollar-based statement.

What percentage changes should actually concern me?

There’s no universal threshold — what matters is a meaningful, sustained shift in a major cost category as a share of revenue, especially if it’s trending the wrong direction over several periods rather than a one-time blip.

Does common-size analysis replace ratio analysis?

No, they’re complementary — common-size shows cost structure as a share of revenue; ratio analysis (like the Financial Ratio Dashboard) measures liquidity, profitability, and efficiency using different combinations of figures.

Related Templates

Related Resources

Want the Full Template Library?

70+ editable templates, each with a built-in AI prompt. $7/month, cancel anytime.

Join the Tools Club