Year-Over-Year Growth: The Formula Every Business Owner Needs to Master

A 40% revenue jump from November to December may reflect holiday demand. Comparing December with the previous December answers a different question: how much did the same calendar month's revenue change over a year?

Year-over-year (YOY) analysis makes that comparison explicit. It still needs consistent records and context: a one-off sale, changed prices or an incomplete month can distort the result. Use the monthly YOY growth worksheet to compare one monetary metric and currency, see missing periods clearly, and download the comparisons.

What Is Year-Over-Year (YOY) Growth?​

Year-over-year growth compares a metric with the same period in the prior year. For a monthly comparison, match January 2026 with January 2025. This differs from comparing entire annual totals, a distinction the Bureau of Economic Analysis explains in its guide to changes from one year ago.

YOY is also different from annualizing a shorter-period rate. Annualizing asks what a monthly or quarterly rate would imply if it continued over a year; BEA's quarterly example compounds the rate across four quarters. A direct same-month YOY comparison does not make that continuation assumption. See BEA's explanation of annual rates.

For one monthly comparison, you need two comparable observations a year apart. You do not need every intervening month. Both observations should cover the complete calendar month, use the same metric definition and be expressed in the same currency. The worksheet handles monthly monetary totals only; counts, rates, fiscal periods and annual totals need their own analysis.

The YOY Growth Formula​

For a positive prior-period value:

YOY Growth Rate = ((Current Period Value - Prior Period Value) / Prior Period Value) × 100

Or equivalently:

YOY Growth Rate = ((Current Period Value / Prior Period Value) - 1) × 100

The absolute change is current minus prior. A positive change means the measured amount increased; whether that is desirable depends on the metric. Higher expenses, for example, do not automatically mean better performance.

The baseline matters:

• Prior value above zero: calculate the percentage, even if the current value is negative. Profit moving from 100 to -20 is a change of -120 and -120.00%.
• Prior value of zero: the absolute change is available, but percentage change is undefined because it would divide by zero.
• Negative prior value: this worksheet withholds the percentage as a tool policy. The division is mathematically possible, but its sign can obscure a move toward or away from profitability. Profit moving from -100 to -80 improves by 20; read those amounts directly.
• A missing observation: neither the absolute nor percentage change is available. Missing is different from an entered zero.

Step-by-Step Calculation​

1. Name one monetary metric, such as revenue or net profit, and declare its currency.
2. Gather the complete current month's total.
3. Gather that same month's total from the prior year. Keep the accounting definition consistent.
4. Subtract prior from current to get the signed absolute change.
5. When the prior value is positive, divide the change by that prior value and multiply by 100.
6. Read the values alongside the percentage. Check missing data, unusual transactions and differences in business scope before interpreting the result.

Worked YOY Growth Examples​

Example 1: Monthly Revenue​

Suppose a consulting firm earned $85,000 in March 2026 and $68,000 in March 2025.

YOY Growth = (($85,000 - $68,000) / $68,000) × 100 = 25.00%

The absolute increase is $17,000. Matching March avoids comparing different seasons, but it does not establish why revenue increased or remove unusual transactions from either month's books.

Example 2: Monthly Expenses​

Suppose monthly operating expenses rise from $10,000 to $12,000 in the same month a year later. The change is +$2,000 and +20.00%. Those positive signs describe an increase, not a verdict on whether the spending was worthwhile. Review what changed and compare it with the relevant revenue and profit records.

The dashboard example below adds declining profit, a move into loss, nonpositive baselines and missing months.

Why YOY Growth Matters​

It Compares Similar Seasonal Windows​

Comparing July with July is often more useful than comparing July with January for a seasonal business. It is not formal seasonal adjustment. BLS describes seasonal adjustment as a statistical process with changing seasonal factors and separate treatment of calendar effects and outliers; this worksheet performs none of those adjustments. See BLS's seasonal adjustment methodology.

Changes in holiday timing, trading days or one-off events can still affect the two totals. Keep those explanations beside the comparison.

It Makes a Comparison Easier to Review​

Showing the two period labels, original values and signed change lets another reader check your calculation. Keep the underlying records available when discussing the result with a business partner, lender or adviser.

It Helps You Follow Changes Over Time​

Several monthly comparisons can show a pattern worth investigating. A slowing percentage may reflect weaker current performance, a stronger prior-year baseline or both. Inspect the amounts before assigning a cause.

It Requires Care When Comparing Businesses​

The same percentage does not make two businesses directly comparable. Check their starting size, metric definitions, reporting periods and changes in business scope before drawing conclusions.

YOY vs. Other Growth Metrics​

Each comparison answers a different timing question:

Month-Over-Month (MOM)​

MOM compares a month with the immediately preceding month. It can help examine recent movement, but seasonal and one-off effects still need context.

Quarter-Over-Quarter (QOQ)​

QOQ compares a quarter with the immediately preceding quarter. It is a sequential comparison, not a same-quarter prior-year comparison. The monthly worksheet does not calculate quarters.

Year-Over-Year (YOY)​

Monthly YOY compares a month with that same month one year earlier. It gives a longer comparison interval while keeping the calendar month aligned; it does not remove every seasonal effect or reveal the changes that happened in between.

Choose the Comparison for the Question​

Use matching periods and label them explicitly. A December-to-December comparison, a December-to-November comparison and a full-year comparison are different calculations. Do not present one as another or add monthly growth percentages to produce annual growth.

What Metrics Should You Track YOY?​

Revenue​

Use a consistent revenue definition across both months. If you break revenue down by product, customer group or sales channel, keep those categories comparable too.

Net Profit​

Profit can be positive, zero or negative. Always show the amounts and absolute change; the worksheet's percentage policy is especially relevant when the same month in the prior year had a loss.

Customer Acquisition​

Customer counts can also be compared across years, but they are outside this monetary worksheet. Keep count-based comparisons separate from currency amounts.

Customer Retention Rate​

Changes in rates need clear units. A retention rate moving from 80% to 85% rises by 5 percentage points, or 6.25% relative to its prior value. These are different statements. This worksheet does not analyze rates.

Operating Expenses​

An increase may reflect new activity, higher prices or changed cost categories. Use the same expense scope and inspect the underlying transactions rather than treating every increase as good or bad.

Cash Flow​

State which cash-flow measure you are comparing, such as operating cash flow, and keep that definition consistent. Profit and cash flow describe different aspects of the business; neither should silently stand in for the other.

Common YOY Analysis Mistakes to Avoid​

Mistake 1: Comparing Non-Equivalent Periods​

Comparing Q1 2026 with Q4 2025 is sequential, not YOY. Comparing a partial current month with a complete prior-year month also gives unequal coverage. Wait for a complete calendar-month total for this worksheet, and check that both totals use the same accounting basis and business scope.

Mistake 2: Ignoring Inflation or Currency Differences​

The worksheet shows nominal amounts and percentages. It does not adjust for inflation, translate currencies or separate price changes from changes in activity. Do not label its result as inflation-adjusted growth or combine different currencies in one comparison.

Mistake 3: Overlooking External Events​

An unusual sale, disruption or change in the business can affect either side of the comparison. Record that context; the YOY formula does not remove it.

Mistake 4: Focusing Only on Revenue​

Revenue can rise while profit falls. Review the relevant measures together, using a separate worksheet for each monetary metric, and investigate the cause before making a decision.

Mistake 5: Inventing History for a New Business​

If the business has no comparable observation from the same month a year earlier, that YOY comparison is missing. Do not replace it with the previous month or a zero. Two complete, comparable month totals are sufficient for one comparison; a continuous 12-month dataset is not required.

Mistake 6: Ignoring the Base Effect​

Moving from $1,000 to $2,000 is 100.00% growth and a $1,000 increase. Growing 5.00% from $10 million adds $500,000. Show both the absolute change and percentage so the starting scale remains visible.

How to Build a YOY Growth Dashboard​

Step 1: Load the Monthly Worked Example​

Open the year-over-year growth calculator and choose Load example. It uses synthetic Net profit, USD and comparison year 2026. Every row compares the named 2026 month with the same month in 2025. Values below are USD; missing cells are not zeros.

January's calculation is (120 - 100) / 100 × 100 = 20.00%. April demonstrates that a negative current value can produce a valid result below -100% when the prior value was positive. May and June both improve by 20, but their percentages are withheld for different reasons. The worksheet shows percentages rounded to two decimal places while retaining exact monetary inputs and changes.

Step 2: Enter Your Own Values or Use the CSV Template​

Choose one monetary metric, its currency and the comparison year. Enter complete calendar-month totals into the matching cells. A blank editor cell means the observation is missing; type 0 when you know the value was zero.

For a file workflow, choose Download example template on the worksheet. Keep its header unchanged. Each observation row supplies a YYYY-MM month and value, repeating the same metric, currency and comparison year. The import accepts up to 240 observation rows in a 1 MiB UTF-8 CSV.

Use digits 0–9, an optional minus sign and a decimal point for CSV values. Do not include currency symbols, grouping separators, a leading plus sign or exponent notation. Omit a row if its value is missing: an explicit blank numeric cell is refused. Keep the input CSV as your own source copy.

Step 3: Review, Apply and Download​

Select the CSV and review its preview. Apply imported observations replaces all current entries, including observations from other years. A refused file does not replace the worksheet, and canceling the preview leaves the current entries intact. Data is processed locally in your browser.

Check the metric, currency, year and the 12 result rows before choosing Download comparison results. The results file includes the two month labels, source values, signed change, percentage and status. A CSV percentage of 20.00 means 20%; an undefined or missing percentage stays blank with its reason in the status column. Invalid edits make result export unavailable.

The results file is an output report, not an import template. Keep your input file separately; entries are not saved across a page reload. A browser download request does not guarantee that a file was saved.

Step 4: Review the Underlying Records​

Reconcile each month's source records before updating its total. Note restatements and unusual events, then review changes in both amounts and percentages. The worksheet does not create an annual total, a forecast, a fiscal-period comparison or an inflation/FX adjustment.

How to Interpret YOY Growth Without a Universal Benchmark​

There is no growth range built into this worksheet that grades a business as healthy. Compare the result with your own documented plans and comparable records, considering the starting amount, margins, cash needs and any change in business scope. A percentage alone cannot establish sustainability or explain the cause of a change.

Keep Your Finances Organized for Better YOY Analysis​

Consistent records make the comparison reviewable. Beancount.io helps you organize plain-text accounting records; the documentation explains how to work with them. Reconcile the monthly totals, keep backups and retain a record of corrections. Version history can help explain what changed, but it does not make an inaccurate entry correct.