Steps for annual sales trend analysis
- 01
Open sales trends and choose the years to compare.
- 02
Choose the franchises, services or classes that answer your question.
- 03
Read completed years separately from any forecast for the current year.
- 04
Use what you find to plan follow-up with the franchises involved.
What the finished work leaves you with
A short comparison that names the years and franchises included, keeps actual results apart from forecasts, and lists follow-up questions.
What to do when the review finds a problem
The range includes a year that has not finished
Label that year as a forecast and leave it out of comparisons between completed years.
The question is about only some offices, services, or classes
Filter to those offices, services, or classes before you read the trend.
A year or location jumps sharply from the pattern
Check its source reports before treating it as a real change.
The comparison answers the question
Record the comparison and any follow-up. Do not edit the source reports.
A common mistake to avoid
Mixing a partial-year forecast with completed-year actuals and presenting them as one history.
Franchise sales trends analysis checklist
Use this checklist before sharing a year-over-year franchise sales comparison. It pins down what is being compared, separates finished periods from forecasts, keeps the source periods behind unusual changes, and lists follow-up questions so a chart is not taken as the answer.
Before you start
- Write the question you are answering and pick the years, offices, franchises, services, or classes it needs.
- Mark which periods are complete and which are forecasts or partial.
- Keep links to the source reports and a place to note questions about outliers.
When franchise sales trends look incomplete
A trend can look wrong because a period is missing, partial, filtered out, or truly unusual. Confirm which franchises and periods are included, and whether each is complete, before explaining a rise or fall.
A year or period is missing from the trend.
Check first
- Confirm the selected years and the franchise, office, service, and class filters.
- Check whether the missing period has a submitted report or only a draft or estimate.
- Compare the period’s status in the missing reports list with what the trend shows.
Next action
Fix the filters or collect the missing report before reading the trend. If the period is meant to be left out, label the gap and do not treat the series as continuous.
Confirm the result
The trend lists every included period and gives a reason for any period left out.
The current, unfinished period makes the trend look unusually high or low.
Check first
- Check whether the current period has ended and all expected reports are in.
- Compare complete periods with complete periods, not with a partial one.
- Note the date range and whether each period is complete next to the chart or table.
Next action
Show the partial period separately and label it incomplete. Treat it as a current snapshot until the period closes.
Confirm the result
The comparison clearly separates complete history from the partial period, and the conclusion does not treat them as the same.
A set of filters returns no trend data.
Check first
- Remove one filter at a time to find which franchise, office, service, or class filter is too narrow.
- Check that the filter labels match the ones used in the sales reports.
- Confirm the selected years have reports for those filters.
Next action
Use the narrowest filters that still answer the question, or note that no comparable data exists. Do not quietly widen the filters and present the result as the original comparison.
Confirm the result
The saved comparison lists its final filters and shows either data or a clear no-data note.
One period jumps sharply with no obvious reason.
Check first
- Open the sales reports behind that period and compare what they cover, their units, and their status.
- Check for a change in service, class, ownership, or how sales are reported.
- Look for a correction, duplicate, missing row, or late report near the period boundary.
Next action
Treat the jump as a question, not a conclusion. Note what differs in the source or open a follow-up, and leave the history unchanged until the cause is confirmed.
Confirm the result
The trend note lists the unusual period, the reports checked, and either a dated explanation or an owner for the open question.
When you need to hand it on
- Include the exact years, franchises or locations, service or class filters, and which periods are complete.
- Attach the sales reports behind an unexpected point, not just a screenshot of the chart.
- Ask the reporting owner to approve any change in how sales are defined before comparing it with earlier history.
Link to the record instead of copying passwords or unrelated personal details into your note.
A situation to work through
One franchise’s sales jump sharply between two completed years, and the current year is still in progress. The analyst checks the source reports for both years and keeps the partial-year forecast clearly separate.
Name the years and filters used, keep forecasts apart from actuals, and write down the questions behind any outlier.
This is a planning example, not a customer result.
Can Granite compare annual franchise sales trends?
Yes. Granite’s sales reports can compare past years by franchise, service or class. Completed years are kept apart from forecasts, and the original reports are never changed by the comparison.
Put the workflow into practice
In Granite, sales trends compare past years across franchises, services and classes from the reports already submitted.
Set it up in Granite with your own franchises, reporting periods and billing rules.