Square Sales Report Template
A free spreadsheet for Square sellers. Paste two exports from your Square Dashboard and it builds six reports on its own: sales by day, a weekday and hour grid, your top items and categories, discounts and refunds, what each deposit should be, and a menu matrix that sorts items into Stars, Plowhorses, Puzzles and Dogs. It works in Excel and Google Sheets, with plain formulas only: no macros, no add-ons, and nothing leaves your copy.
The download is an Excel file of about 10 MB. It opens in Excel, Google Sheets, Numbers and LibreOffice.
What's inside
These are the tabs filled in with the template's sample week from a small cafe. Your own exports replace the sample when you paste them.
Sales by day
Net sales, orders, average ticket, discounts and refunds for every day in your export.
| Date | Day | Net sales | Orders | Avg ticket | Discounts | Refunds |
|---|---|---|---|---|---|---|
| 2026-10-05 | Monday | $102.17 | 7 | $14.60 | $4.08 | $4.75 |
| 2026-10-06 | Tuesday | $108.00 | 8 | $13.50 | $2.50 | $0.00 |
| 2026-10-07 | Wednesday | $79.50 | 7 | $11.36 | $0.00 | $0.00 |
| 2026-10-08 | Thursday | $98.10 | 8 | $12.26 | $1.65 | $0.00 |
Weekday and hour
Net sales by weekday and hour, shaded so your busiest and slowest hours stand out, with averages per day and your slowest days and hours. Part of the grid:
| Day | 7 AM | 8 AM | 9 AM | 10 AM | 11 AM | 12 PM | 1 PM | 2 PM | 3 PM |
|---|---|---|---|---|---|---|---|---|---|
| Monday | $25 | $6 | $29 | $3 | $18 | $23 | |||
| Tuesday | $49 | $54 | $6 | ||||||
| Wednesday | $14 | $6 | $21 | $27 | $13 | ||||
| Thursday | $10 | $9 | $23 | $18 | $39 |
Top items and categories
Your top 25 items by net sales and by units, with refunds taken off, and every category's share of sales.
| # | Item | Category | Net sales | Units | Share |
|---|---|---|---|---|---|
| 1 | Avocado Toast | Food | $123.50 | 13 | 21.1% |
| 2 | Turkey Sandwich | Food | $105.60 | 10 | 18.1% |
| 3 | Latte / Large | Coffee | $84.70 | 16 | 14.5% |
| 4 | Cold Brew | Coffee | $60.32 | 13 | 10.3% |
Discounts and refunds
Totals from each export and what share of sales went to discounts, refunds, tips and processing fees, plus how customers paid and your most discounted and most refunded items.
| Amount | Share | |
|---|---|---|
| Discounts | $11.94 | 2.0% of gross sales |
| Refunds | $4.75 | 0.8% of net sales |
| Tips | $40.32 | 6.9% of net sales |
| Processing fees | $18.50 | 3.2% of net sales |
Deposits
What each Square deposit should be (card and Cash App sales, minus refunds and fees) to check against your bank statement, plus sales not deposited yet, refunds with no matching sale, and cash that never reaches the bank.
| Deposit date | Card sales | Refunds | Fees | Expected deposit | Payments |
|---|---|---|---|---|---|
| 2026-10-11 | $44.61 | $0.00 | -$1.60 | $43.01 | 3 |
| 2026-10-10 | $68.71 | $0.00 | -$2.69 | $66.02 | 6 |
| 2026-10-09 | $87.38 | $0.00 | -$3.17 | $84.21 | 6 |
How to use it
- Export from Square. In your Square Dashboard, go to Payments & invoices > Transactions, pick a date range, then Export, and generate both the Items Detail CSV and the Transactions CSV.
- In Google Sheets: open the Paste Items Detail tab, then choose File > Import > Upload and pick the Items Detail CSV. Choose Replace current sheet and keep Convert text to numbers, dates, and formulas checked. Do the same with the Transactions CSV on the Paste Transactions tab.
- In Excel: clear the Paste Items Detail tab, then open the Items Detail CSV, select everything, copy it, and paste it into cell A1 of that tab. Do the same with the Transactions CSV on the Paste Transactions tab.
- Check the Start here tab. It shows how many rows were read and names any column your export is missing.
- Add your costs on the Costs tab to fill in the menu matrix. They stay in your copy.
The template reads up to 10,000 rows from each export. For a busy month, export a shorter date range. Columns are found by their header names, so it doesn't matter if Square adds or reorders columns.
Get these reports updated every night, free
Connect Square once and Flumen keeps your sales, best sellers and busiest hours current, with no exporting or pasting.
Free plan, no signup form. By connecting you agree to our Terms and Privacy Policy.