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.

DateDayNet salesOrdersAvg ticketDiscountsRefunds
2026-10-05Monday$102.177$14.60$4.08$4.75
2026-10-06Tuesday$108.008$13.50$2.50$0.00
2026-10-07Wednesday$79.507$11.36$0.00$0.00
2026-10-08Thursday$98.108$12.26$1.65$0.00

How to use it

  1. 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.
  2. 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.
  3. 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.
  4. Check the Start here tab. It shows how many rows were read and names any column your export is missing.
  5. 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.

Connect Square in one click

Free plan, no signup form. By connecting you agree to our Terms and Privacy Policy.