Most café owners look at one number in Square: today’s total. That number tells you whether it was a good day, but it tells you almost nothing about why, or what to change tomorrow. The reports that answer those questions are already sitting in your Square Dashboard, free, collecting data on every transaction you have ever run.
This guide walks through the five reports worth opening every week, what each one actually means, and — the part most guides skip — the specific decision each report should drive. It assumes you run a café on Square and want to use what you already have, not buy another tool.
Where the reports live
Everything below is in two places:
- Square Dashboard (on a computer at squareup.com, or the Square Dashboard app) — the full reporting suite under Reports.
- Square Point of Sale app — a lighter summary on the device itself.
Core sales reporting is included free with every Square account. You do not need a paid plan to see net sales, item sales, category sales, sales by time, or payment methods. A few advanced views — notably deeper labour-versus-sales reporting — come with paid tiers such as Square for Restaurants Plus, but the five reports in this guide are all available on the free plan.
1. The Sales Summary — your weekly vital signs
The Sales Summary is the top-line view: gross sales, net sales, discounts, refunds, taxes, tips, and average sale. Read it like a vital-signs chart, not a single number.
The distinction that trips people up:
- Gross sales = everything sold, before discounts and refunds.
- Net sales = gross sales − discounts − comps − refunds (but before tax and tip).
Net sales is your real top line. If gross looks healthy but net is sagging, you are discounting or refunding more than you think — which is exactly the kind of leak that running promotions without watching your margin creates.
The other number to anchor on here is average sale (average ticket). It is net sales divided by transactions, and it is the single most actionable café metric because small movements compound across thousands of orders.
If your average ticket moves from $7.50 to $8.25 across 6,000 monthly transactions, that is $4,500 in extra monthly revenue from the same customer count.
That is why a whole separate playbook exists for increasing average order value at a coffee shop — the report tells you the number; the playbook tells you how to move it.
Decision it drives: Is your average ticket trending up, flat, or down? If it is down, look at upsells, modifiers, and food attach before you blame traffic.
2. Sales by Time of Day — staff against reality, not vibes
Open Sales by Time (or Sales Trends) and Square charts your sales across the hours of the day and the days of the week. For a café this is the most operationally valuable report you have, because it turns “mornings are busy” into an actual curve.
What to look for:
- The shape of your peak. Most cafés have a sharp morning spike and a softer afternoon. The width of that spike decides your staffing and whether order-ahead pays off.
- The dead zones. The 2–4pm trough is where promotions, a happy-hour reward, or a loyalty nudge earn their keep — because you are filling capacity you have already paid for.
- Day-of-week patterns. A Monday that consistently underperforms is a campaign target, not a fact of life.
Decision it drives: Staff to the curve, not to habit. And where the morning spike is taller than your counter can serve in time, that is the precise problem order-ahead solves for the morning rush — customers skip the line, and you smooth the peak without adding a register.
3. Item Sales — which drinks actually carry the café
The Item Sales report ranks every menu item by units sold and by sales. This is your menu-engineering raw material. Sort it two ways and read both:
- By units sold — your volume drivers, the drinks people come for.
- By total sales — where the money actually is, which is not always the same list.
Then look at the bottom of the report, not just the top. Items that sell almost nothing are doing real damage: they add prep complexity, tie up inventory, slow the line, and clutter the menu. A menu of 40 items where 12 generate 80% of sales is a menu with 28 candidates for the cut.
A simple framework, drawn from classic menu engineering:
| Sells a lot | Sells little |
|---|---|
| High margin → feature it. Put it first, name it well, train staff to suggest it. | High margin, low volume → reposition or rename. The money is there; the visibility is not. |
| Low margin, high volume → reprice or re-cost. Popular but thin; a small price move scales. | Low margin, low volume → cut it. It is costing you more in complexity than it returns. |
Decision it drives: Each quarter, promote the top-right (popular and profitable), reprice the bottom-left (popular but thin), and cut the dead weight.
4. Category Sales — the mix that determines your margin
Category Sales groups items into the buckets you defined — espresso drinks, brewed coffee, food, retail beans, merch. The ratio between these categories is one of the biggest hidden drivers of profit, because food and retail usually carry different margins than drinks.
If 90% of your sales are beverages and food is a rounding error, you are leaving margin on the table — a pastry attached to a latte often costs the customer little decision energy and meaningfully lifts the ticket. If retail beans are climbing, that is a signal to give them more counter real estate.
Decision it drives: Track category mix month over month. A deliberate push on the under-weight, high-margin category (usually food or retail) is one of the cleanest margin wins a café has.
5. Customers and returns — the report that predicts your future
Today’s sales are history. The report that predicts next month is how many customers come back. Through Square’s Customer Directory, loyalty, and feedback tools, Square can show returning versus new customers, visit frequency, and spend per customer — when transactions are tied to a profile, a loyalty phone number, or a card on file.
That caveat is the whole game. If most of your sales are anonymous card taps, Square can only tell you so much. The moment you capture customers — through a loyalty program, order-ahead, or app sign-in — every report above gains a second dimension: not just what sold, but to whom and how often.
This is the bridge from reporting to growth. Once you can see repeat rate and frequency, you can calculate customer lifetime value for your coffee shop and start managing the number that actually compounds: how often a regular comes back.
Decision it drives: If your returning-customer rate is low or invisible, your priority is not a new promotion — it is capturing customers so you can bring them back on purpose.
A simple weekly reporting routine
You do not need an analyst. Fifteen minutes, once a week:
- Sales Summary — net sales and average ticket vs. last week. Up, flat, or down?
- Sales by Time — did the peaks and troughs move? Is staffing matched to them?
- Item Sales — what is the new top 5, and what is dead at the bottom?
- Category Sales — is food/retail mix climbing or stuck?
- Customers — is repeat rate visible, and is it growing?
Write one sentence per report and one action for the week. That habit beats any dashboard you never open.
Where reporting hits its ceiling — and what’s next
Square’s free reports are genuinely good at telling you what happened. Where they stop is making the next visit happen. They can show you a 2pm trough; they cannot fill it. They can show you a customer has not returned in 40 days; they cannot, by themselves, message that customer to come back.
That is the line where a direct channel takes over from a report. A branded ordering app on your existing Square POS turns those insights into action: the customer is captured automatically at order-ahead, every visit ties to a profile, and you can send a push notification to fill the slow afternoon the report just revealed. That is what Tany builds for independent cafés — a branded iOS and Android app with self-running loyalty, push, and web ordering on top of your Square data, live in about a day for $99 CAD/month per location.
Reports tell you the truth about your café. The next step is owning the channel that lets you act on it.