Square POS records every sale automatically, but your reports are only as accurate as the data your team puts in. Accurate sales reporting comes from a handful of habits: ringing up real items instead of custom amounts, using comps, voids and refunds correctly, setting your business hours and close of day properly, and reconciling cash and transfers on a schedule. Get those right and Square's reports become numbers you can make decisions on.
This guide is about data hygiene: keeping what goes into Square clean. If you want to know which report answers which business question, see how to use Square's dashboard for restaurant insights.
Why sales reports go wrong
Most reporting problems are not software problems. They come from small shortcuts at the register that add up:
- Items rung up as a custom amount instead of the actual menu item.
- Duplicate or renamed items that split one product's history.
- Mistakes fixed with the wrong tool (a refund where a void was right, or the reverse).
- Sales from other channels that never reach Square.
- Cash that is not counted against what Square expects.
1. Ring up real items, every time
A custom amount tells Square that money came in, but not what was sold. Your item sales, category sales and inventory reports cannot use it. If staff use custom amounts because an item is missing or hard to find, fix the item library:
- Add every menu item, including seasonal specials, before they go on sale.
- Use variations for sizes and modifiers for add-ons, so one drink is one item.
- Organize your POS layout so the top sellers are one tap away.
- Limit who can enter custom amounts, if your setup allows it, and review them weekly.
2. Keep your item library stable
Square's support center notes that renaming an item or category creates a separate entry in reporting. So if "Iced Latte" becomes "Iced Latte (16 oz)" halfway through the month, your report will show two lines. To keep history together:
- Choose clear, final names before you launch an item.
- Avoid creating a new item for each promotion. Use discounts instead.
- Delete or archive true duplicates and retrain staff on the correct one.
Our guide to customizing your restaurant's menu on Square covers item setup in detail.
3. Use comps, voids and refunds correctly
| Situation | Use | Why |
|---|---|---|
| Item entered by mistake and not made yet | Void | It was never really sold. |
| Item made or served, but given free (remake, apology, staff meal) | Comp | The product was used, so it should appear in reports and inventory. |
| Guest already paid and gets money back | Refund | Money left the business after a completed sale. |
Square lets you set up comp and void reasons in Square Dashboard, which staff pick when they comp or void. Reasons such as "wrong order", "quality issue" and "staff meal" turn a vague loss into something you can manage. When refunding, refund the specific items returned where you can, rather than a lump dollar amount, so item level reports stay accurate.
4. Set business hours and close of day correctly
If your cafe closes after midnight or does late prep, the time Square uses to end your business day matters. Set your location's business hours and close of day time to match how you operate, so late sales count toward the right day.
5. Bring every channel into Square
If delivery apps, online orders or catering are tracked somewhere else, your Square reports undercount real sales and distort your item mix. Where possible, use channels that send orders directly into Square POS. Where you cannot, record those totals consistently so you can add them to your analysis.
6. Reconcile on a schedule
- Every shift: count the cash drawer and compare with Square's expected cash in the cash drawer report.
- Every week: review voids, comps, refunds and custom amounts by team member.
- Every month: match Square transfers to your bank deposits and hand clean reports to your bookkeeper.
Example: a two location coffee shop
An owner notices that one location shows far more "Custom Amount" sales than the other. Looking closer, the newer location never added the seasonal menu to its POS layout, so staff typed prices in by hand. The owner adds the items, removes custom amount access for new hires and adds comp reasons. Next month, item reports from both locations line up and the seasonal menu's real performance becomes visible.
Common mistakes
- Fixing mistakes with refunds. Refunding an order that was never completed inflates both sales and refunds.
- No comp reasons. Without them, you cannot tell remakes from giveaways.
- Mid-period renaming. It splits your item history.
- Reading gross sales as revenue. Use net sales, which account for discounts, comps and refunds.
With clean data, reports become useful for decisions like menu engineering with Square sales data.
Where Orda fits
Accurate reporting is easier when every order lands in Square. With Orda, orders from your branded iOS and Android app, your ordering website and Orda Express kiosks flow directly into Square POS as real items from your synced Square menu, not custom amounts. App, web, kiosk and counter sales sit in the same reports, so your numbers reflect the whole business.