Coffee shop economics
How to Read Your Square Sales Reports (A Coffee Shop Owner's Guide)
Square quietly records everything that happens in your shop. The problem isn't missing data — it's that the dashboard is overwhelming, and most owners never open the reports that actually matter. Here's a plain-English guide to the Square reports worth your five minutes a week.
If you run your coffee shop on Square, you are sitting on a goldmine of data you almost certainly aren't using. Every espresso, every muffin, every card tap is logged. But open the Square Dashboard and you're met with a wall of reports, charts, and filters — so most owners glance at today's sales total and close the tab. The good news: you don't need most of it. A handful of Square reports, read the right way, tell you almost everything about how your shop is doing.
Where to find them: log into your Square Dashboard (on a computer, not just the register app) and open the Reports section. Most reports let you set a date range and export to CSV — which is exactly the format you'll want if you ever feed them into a tool that reads them for you.
1. Sales Summary — your top-line health
This is the report to start with every week. It shows your gross sales, net sales, transaction count, and average sale over the period you choose. Set it to last week and compare it to the week before. Three things to actually look at: is revenue trending up, flat, or down; how many transactions you had (your real customer traffic); and your average sale. Don't just read the revenue number — a flat total can hide a falling customer count masked by a higher average ticket.
2. Item Sales — what's actually selling
Item Sales breaks revenue down by product. This is where your product mix lives — how much comes from specialty drinks versus drip, how much from food, what your best and worst sellers are. Not every dollar is equally profitable, so a shop doing big volume on low-margin items is working harder for the same money. Scan for two things: which items drive the most revenue, and whether your higher-margin items (food, specialty drinks) are pulling their weight.
3. Sales by Hour (or Sales Trends) — your daypart patterns
This is the most underused report of all. It shows when your money actually comes in across the day and week. Your morning rush might carry the whole operation while certain afternoon hours barely cover the staff running them. Reading sales by hour — ideally next to your labor — is how you spot the hours you're overstaffed and the ones you're leaving money on the table.
4. Team / Timecard reports — the labor picture
If you run scheduling or payroll through Square, your team reports give you the staff hours you paid. Put those hours next to your Sales by Hour, and you can see your labor cost as a percentage of revenue — the single biggest cost most owners can control. A healthy target for many independents is somewhere around 30–35% of revenue, but the average hides the truth; the real insight is labor by daypart.
5. Discounts and Comps — the quiet leaks
Discounts, comps, and voids rarely show up as one scary number, so they go unwatched. But loyalty rewards, friends-and-family freebies, and remakes add up. A quick look at your discounts report tells you how much revenue is walking out the door in ways you may have stopped noticing.
Square isn't missing anything. The gap is that nobody has the time each week to open five reports, line them up, and ask the right question.
Read them together, not one at a time
The magic isn't in any single report — it's in cross-referencing them. Revenue flat but transactions down means you're leaning on fewer, higher-spending customers. Labor percentage fine overall but ugly on Tuesday afternoons means a scheduling problem the monthly average hid. Item sales strong but average ticket sliding means your mix is drifting toward cheaper items. The story is always in the combination.
That's also the hard part. Exporting five CSVs and reconciling them by hand at 9pm after close is not going to happen most weeks — which is exactly why the reports pile up unread.
Let Square's reports read themselves
Second Manager takes your Square export and does this cross-referencing every week — surfacing the questions worth asking instead of leaving you to dig through five reports. It won't tell you what to do. It makes sure you're looking at the right numbers.
Start your free 7-day trial →Built for independent coffee shops · No integration · Just a CSV
The five-minute weekly read
If you do nothing else, build this habit: once a week, open your Sales Summary, check revenue trend and transaction count, glance at Item Sales for any big mix shift, and scan Sales by Hour for a daypart that looks off. Five minutes, the same four glances, every week. That consistency — reading the same numbers the same way — is what turns Square from a cash register into an early-warning system.
Common questions
Which Square report shows my coffee shop's profit?
No single Square report shows net profit, because Square doesn't know your rent, wages, or ingredient costs. The Sales Summary shows revenue and gross figures; you combine that with your labor (team reports) and your outside costs to understand profit. Square gives you the sales side of the equation, not the full P&L.
How do I export Square reports as a CSV?
In the Square Dashboard on a computer, open the report you want, set your date range, and look for an export or download option — most reports export to CSV. That CSV is the file you'd upload to a tool that analyzes it for you.
What's the difference between gross and net sales in Square?
Gross sales is the total before discounts, comps, and refunds. Net sales is what's left after those are taken out. Net sales is the more honest figure for how much you actually took in, and the gap between the two is worth watching — a widening gap can mean discounts and comps are creeping up.
How often should I check my Square reports?
Weekly is the sweet spot for most independent coffee shops. Daily is noisy and reactive; monthly is often too late to catch a problem while it's small. A short weekly read of the same core reports lets you spot trends early without drowning in data.
More reading: 7 numbers every coffee shop owner should check weekly · Why is my coffee shop busy but not profitable? · See how Second Manager works →