Skip to content
All posts

Your Year-End POS Data Review

It's November. By December 31, you'll close out 2026. Before you do, there are five reports you should pull from your POS data. Not because they're interesting. But because they're going to inform how you run 2027.

Report 1: Labour Cost by Location for the Year

B&L_customerexperience_0654Pull year-to-date labour cost by location. Not just the number. The trend.

Which locations are running consistently under target? Which are consistently over?

If location three is running 30% labour cost and location four is running 32%, that's a 2-point gap. Over a year, on a $2M location, that's $40,000 in difference. Now ask: Why?

Is it staffing policy? Process efficiency? Labour scheduling? Market conditions?

If it's a controllable difference (staffing, process, scheduling), that's a best practice you can spread to location four. If it's market conditions (location four is in a lower-wage area), then you have a new baseline.

The point: By December 31, you know which locations are labour-efficient and why. You go into 2027 with a specific list of improvements.

Report 2: Food Cost by Location and by Category

Pull year-to-date food cost by location. Also break it down by category (proteins, produce, dairy, etc.).

Which locations are running efficient food cost? Which are struggling?

Which categories are consistent across locations? Which are drifting?

If chicken is 28% at location one and 31% at location three, that's a gap worth investigating. Are they getting different pricing? Different waste? Different portion control? If one location is consistently 1-2 points better on food cost, that's a best practice (supplier management, waste management, portion control) worth documenting and spreading.

The point: By December 31, you know which food cost drivers are working and which need attention in 2027.

Report 3: Covers and Sales per Labour Hour by Location

Pull how many covers each location served per labour hour. Pull sales per labour hour. This tells you about operational efficiency and productivity. If location two is getting 8.5 covers per labour hour and location five is getting 7.2, that's a productivity gap.

The question: Why?

Is it the menu mix (location two sells more of the fast items)? Is it process (location five is slower)? Is it staffing mix (location two has more experienced staff)? If it's controllable (process or staffing), that's something to address in 2027.

The point: By December 31, you know where your efficiency gaps are and whether they're structural or addressable.

Report 4: Guest Count and Sales Trends by Month

Pull a simple chart: Sales and covers by month for 2026.

Is there a pattern? Do certain months always perform better? Are you seeing growth or decline month-over-month?

This tells you about your business trends heading into 2027. If November and December are your strongest months, you need to staff and plan accordingly. If September is weak, you need to plan marketing or menu innovation to prop it up. If you're seeing month-over-month decline, that's a signal. Is it market? Is it your operation? That's a 2027 conversation.

The point: By December 31, you understand your seasonal patterns and can plan 2027 accordingly.

Report 5: Cash Flow and Gross Profit by Location

Pull a simple table: Sales, COGS, labour, and gross profit by location._MG_4748

Which locations are your most profitable? Which are struggling?

If you're planning to add a new location in 2027, model it after the profile of your strongest locations. If a location is under-profitable, ask: Is it fixable? Or is there a structural problem (location, market, format)?

The point: By December 31, you know which parts of your operation are working and which need attention or change in 2027.

The Framework

Pull these five reports. Print them. Read them with your leadership team.

For each report, ask three questions:

One: What's working? Which locations or metrics are hitting target or exceeding it?

Two: What's not working? Which locations or metrics are falling short?

Three: Is it fixable? If something is not working, is it addressable through operational change, or is it structural?

Then: Make a list. By January 1, 2027, you should have a list of 3-5 specific operational changes you're making to improve each metric.

This isn't abstract strategic planning. This is concrete. "We're reducing labour cost at location four by implementing better scheduling, similar to location three's model." Specific.

The Power of This Data

Most operators finish 2026 and say "okay, 2027 is about doing better." That's hope. Operators who pull these reports finish 2026 and say "okay, 2027 is about spreading location two's labour efficiency model to location four, implementing location three's food cost best practices, and investigating the June sales dip to prevent it in 2027." That's a plan.

The data is already in your POS system. You're not doing anything new. You're just reading what you've already created.

The difference is: Most operators never read it. The operators that do are the ones who improve year over year.

The Last Note

If pulling these reports is hard—if you don't have easy access to this data from your POS system - that's a signal. Your POS system isn't built for multi-location intelligence. By January 2027, that needs to change. Because if you can't easily pull these five reports, you're blind to what's actually working in your business.

That's not acceptable for 2027.

How Squirrel Systems Solves This

Squirrel Systems ensures consistency scales. One system, every location, every concept. Your brand shows up the same way at location one and location 20. See how Cactus Club transformed their guest experience.

Ready to see what a modern POS platform can do for your operation? Book a demo with Squirrel Systems.