Ignoring Seasonality: Misreading Peaks and Valleys Leads to Bad Data

Ignoring Seasonality: Misreading Peaks and Valleys Leads to Bad Data

By: Jeff Heybruck

Every business owner knows the feeling. Sales are up three months in a row, the phones won’t stop ringing, and it finally feels like the business has turned a corner. So a business owner hires another person, signs a lease on new equipment, or loosens the purse strings a little.

Then the calendar turns, the work slows down, and he’s left wondering what went wrong.

In many cases, nothing went wrong at all. The business simply did what it does every year. The problem wasn’t the slowdown; it was reading a predictable seasonal peak as a permanent change in direction.

The Calendar Is Part of Your Data

Almost every business has a rhythm. A landscaping company is slammed in spring and quiet in January. A retailer may earn a large share of its annual profit in the last two months of the year. An HVAC contractor lives and dies by the first heat wave and the first cold snap. Even professional services firms feel it, whether it’s tax season, year-end budgeting, or the summer lull when decision-makers are on vacation.

None of that is a secret to the owner. Most people can describe their busy season without looking at a single report. The trouble starts when the numbers are reviewed without that context. A monthly report that shows revenue down 30 percent from last month looks alarming on its own. Next to the same month last year, it may look perfectly healthy.

Seasonality doesn’t make your data wrong. It makes your data easy to misread.

How Seasonality Turns Good Numbers Into Bad Decisions

When seasonal patterns aren’t built into how you review your financials, the same few mistakes tend to show up:

  • Comparing month to month instead of year over year. October versus September tells you how the season is changing. October versus last October tells you how the business is changing.
  • Hiring or expanding at the top of the curve. A strong quarter feels like proof of growth, so fixed costs get added just before revenue naturally pulls back.
  • Cutting too deep in the valley. The opposite reaction is just as costly. Owners slash marketing or let good people go during a normal slow stretch, then scramble when demand returns.
  • Running out of cash in a profitable year. A business can be profitable over twelve months and still come up short in month eight if no one planned for the gap between when expenses hit and when revenue arrives.
  • Setting flat targets. Dividing an annual goal by twelve sets up a team to “miss” every slow month and “crush” every busy one, which tells you very little about actual performance.

Each of these decisions feels reasonable in the moment. That’s what makes them dangerous. The numbers on the screen are accurate; they just aren’t being read against the right baseline.

Your Memory Isn’t a Seasonal Model

Most owners have a general sense of their slow and busy periods. But “summer is usually slow” is not the same as knowing how slow, for how long, and what it costs.

Memory tends to smooth things out. It remembers the overall shape of the year, but not the size of the dip or exactly when it started. It also has a hard time separating seasonal patterns from one-time events. Was last March slow because of the season, because of the weather, or because a major client paused a project? Without clean historical data, it’s difficult to tell, and the answer matters a great deal when you’re planning this year’s March.

That’s where a few years of reliable, consistently categorized books become valuable. They turn a vague sense of the calendar into something we can actually plan around.

If you have been on QuickBooks for a few years, that history is probably already sitting in your file. The real question is whether it was recorded consistently enough to compare one year against another.

Reading the Peaks and Valleys Correctly

Building seasonality into a financial picture doesn’t require anything exotic. It mostly requires discipline and the right comparisons:

  • Look at year-over-year results alongside month-over-month to separate seasonal movement from real growth or decline.
  • Use trailing twelve-month figures to see the overall trend without the noise of any single season.
  • Build a seasonal budget that reflects when revenue and expenses actually occur, rather than spreading them evenly across the year.
  • Forecast cash flow ahead of the slow season, to know how much cushion to have on hand and when it will be needed.
  • Set targets by period that account for the natural rhythm of the business, so the team is measured against realistic expectations.

Just as important, make sure the underlying data is clean enough to support those comparisons. If revenue is recorded late, expenses are lumped into the wrong months, or categories change from year to year, the seasonal picture will be distorted and not useful for comparisons or forecasting.

Seeing Seasonality in QuickBooks

Most of what you need to read your seasons correctly is already in QuickBooks. The trouble is that the default reports don’t show it. Run a standard Profit and Loss for last month and you get a single column of numbers with no context.

A few adjustments change that:

  • Add a prior-year comparison. The Profit and Loss report can show the same period from last year alongside the current one, so October sits next to last October instead of standing alone.
  • Display columns by month. A full year with a column for each month shows the shape of your season at a glance. Run two years and you can see whether that shape is changing.
  • Build the budget month by month. Depending on your version, QuickBooks lets you enter a budget by month instead of one annual number, then compare actual results against it. That gives every month its own realistic target.
  • Track by class or location. If one service line or location drives your busy season, class or location tracking shows which part of the business is moving and which is holding steady.
  • Save the reports you rely on. Once a report is set up the way you need it, save the customization so the right comparison is one click away every month.

None of these reports are more reliable than the transactions behind them. If income is recorded when the deposit clears instead of when the work was done, or expenses land in whatever month someone got around to entering them, QuickBooks will faithfully report a season that never happened. Consistent dates, consistent categories, and a regular monthly close are what make the comparisons worth trusting.

The Pattern Is Only Useful If You Can See It

Seasonality is one of the few forms of bad data that is almost entirely predictable. The peaks and valleys will come back. The question is whether you’ll see them coming in your numbers or only feel them in your bank account.

If you’re not sure whether last quarter’s results reflected real progress or just the time of year, Lucrum can help. We’ll clean up and organize the history in your QuickBooks file, set up the reports and budgets that respect your business’s natural rhythm, and show you what’s really changing, so you can plan each season with Confidence in the Numbers.

Questions? Contact Us Below.

"*" indicates required fields

This field is for validation purposes and should be left unchanged.