Comparing Sales Periods: This Month vs Last Month, This Year vs Last Year

Comparing Sales Periods: This Month vs Last Month, This Year vs Last Year

"How are we doing?" is the most common question in retail. The answer requires comparison. But comparing correctly is harder than it seems.

Why Period Comparison Matters

A single number means nothing without context:

Comparison provides the context that transforms numbers into insights.

Types of Comparisons

Sequential Comparison

Compare consecutive periods:

**Best for:** Spotting recent trends and changes

Year-over-Year (YoY)

Compare same period, different year:

**Best for:** Accounting for seasonality

Same-Day Comparison

Compare same day of week:

**Best for:** Daily operations and staffing

Getting Comparisons Right

Account for Calendar Differences

Months have different days:

Solution: Compare same-day-count periods or use daily averages.

Note External Factors

Document things that affect comparison:

Use Multiple Comparisons

Don't rely on just one:

What to Compare

Revenue Metrics

Category Performance

Time Patterns

Reading Comparison Data

Percentage vs Absolute Change

Both matter:

A $5,000 increase is huge for a $25,000 business, minor for a $500,000 business.

Trend vs Noise

One week's change might be noise. Look for:

Segment Differently

Overall flat might hide:

Practical Applications

Setting Targets

Use comparisons to set realistic goals:

Evaluating Changes

Before/after comparisons show impact:

Seasonal Planning

YoY comparison helps predict:

Building Comparison Reports

Weekly report should include:

Monthly report adds:

Taking Action on Comparisons

For every significant change, ask:

Comparison without action is just interesting. Action without comparison is just guessing. Together, they drive improvement.

**Ready to automate your period comparisons?** Our [P&L Dashboard from Excel](/profit-loss-dashboard-from-excel) automatically generates comparison reports from your spreadsheet data.