A seasonal pattern is easy to produce and hard to trust. This checklist exists for the gap between those two states: the hour before a pattern goes into a staffing plan, when it is still cheap to find that the export was filtered the wrong way. Work through the groups in order, because a fault in the first group makes every later check meaningless.
Before pulling any numbers
- Write down the question the pattern is meant to answer, in one sentence.
- Name the period length and stick to it for the whole exercise.
- Decide the base window before looking at the data, not after.
- Note the date the export was taken, since a later export will not match.
- Agree who signs off on the finished comparison.
The one-sentence question is not bureaucracy. A pattern built to answer whether to hire in summer looks different from one built to answer whether to run a promotion in a quiet month, even when both come from the same bookings.
Export hygiene
- Confirm every row carries the date the appointment was booked for, not the date it was created.
- Confirm cancelled appointments are excluded, and that no-show charges are not counted as visits.
- Check that package redemptions appear once rather than twice.
- Check that the export is not filtered to a single practitioner or service by accident.
- Count the rows and compare against the booking system's own total for the same window.
That last check catches most problems. If the row count and the system total disagree, the export is filtered, and no amount of careful arithmetic afterwards will fix it.
Calendar corrections
- Mark every week the business was closed, including holiday stretches and renovation days.
- Mark every week with reduced hours, such as a summer schedule or a short week after a holiday.
- Note any period a practitioner was away, since their chairs sat empty for reasons that have nothing to do with demand.
- Note any period capacity changed: a new chair, a lost room, a second location.
- Decide, in writing, whether closed periods are excluded or treated as zero, and apply one rule throughout.
The rule matters less than the consistency. Excluding closures lifts the average and lowers every index; treating them as zero does the reverse. Either can be defended. Mixing them cannot.
Comparison rules
- Compare like periods against like periods: the same month across years, not month against the month before.
- Use counts and hours booked together whenever the service mix has moved.
- Read three periods before drawing a conclusion from one.
- Treat any single unusual period as an event until a second year confirms it.
- Keep the raw counts visible next to every ratio.
Sanity checks by eye
- Plot the periods in order and look for a shape you can describe in a sentence.
- Ask whether the shape matches the season you would expect from how clients talk about the business.
- Look for a spike in a period with a promotion and ask whether the promotion caused it or the season did.
- Check whether the quietest period is quiet or simply closed.
- Check that the busiest period is a period the business can actually staff.
If the picture does not match lived experience, believe the mismatch long enough to investigate it. A pattern that contradicts the front desk's memory is usually a data fault, and occasionally it is a real change nobody had noticed yet.
Sign-off before use
- Confirm the base window and period length are written in the same document as the result.
- Confirm every exclusion is listed with a reason.
- Confirm the counts can be reproduced by somebody else from the same export.
- Confirm the pattern is being used to answer the question written in the first group.
Where the checklist leads
A cleared checklist makes the arithmetic on the seasonal demand patterns calculator worth doing, and a cleared calculator makes a staffing conversation short. When the answer is coverage rather than promotion, the choices are voicemail, which records a call without booking it, an answering service during bought hours, or an AI receptionist for salons that answers around the clock, books appointments, captures caller details, sends SMS follow-ups, and escalates urgent calls to a person.
Keep the completed checklist with the seasonal demand template so next year's run starts from a known state rather than from a blank page.