The question Square's reports don't answer in one place
Square Dashboard has good sales reports, and Square's team tools track timecards. What owners usually want is the ratio: how much labor each store spent to earn each dollar of sales, and in which hours that ratio goes wrong. Getting there by hand means exporting both, lining up the time stamps, and repeating it every week.
What the scorecard shows
- Sales, average order value and units per transaction by store
- Labor % of sales by store and by week, from Square timecards
- A heat map of sales by day of week and hour, so you can see the dead hours
- Refunds and discounts by store and by team member
- Trends against the same week last year once you have the history
A synthetic example
In the sample for Prairie Thread Outfitters (a fictional five-store retailer), one store runs a much higher labor % than the others. The heat map shows why: it is fully staffed on weekday mornings when almost nobody buys. That is a schedule change, not a sales problem. All names and numbers are invented.
How it connects
You approve read-only access in Square once. Each night a pipeline copies orders, payments, refunds and timecards into a reporting database and refreshes the scorecard. If your staff clock in somewhere other than Square, we can join that system's hours instead.
Frequently asked questions
How do I calculate labor cost percentage from Square?
Labor % is total labor cost (hours worked times wage, plus any burden you choose to include) divided by net sales for the same period. The scorecard calculates it per store and per week from Square timecards and Square sales.
Can Square show sales by hour?
Square's reports can break down sales by time. The scorecard turns that into a day-by-hour heat map for every store at once, alongside labor, so you can compare staffing to traffic.
What if we use a separate payroll or scheduling app?
That works. We can pull hours from the scheduling or payroll system and match them to Square sales by location.