Square Sales Report by Item
A Square sales report by item shows units and net sales for every item you sold in a period. Square Dashboard has it under Reports; the Items export gives the same data one row per item sold, so you can split it by location, hour, day of week or discount.
Export Item Sales from Square, upload it, and ask "best-selling items by location on weekends" — the table and chart come back in one answer.
In Square Dashboard
Go to Reports → Item Sales, choose the date range and location, and sort by net sales or quantity. Use Export → Detail CSV for one row per item sold, or Summary CSV for one row per item. The detail export is the one to analyse.
By item and location in Excel
Open the detail CSV, insert a PivotTable with Item in Rows, Location in Columns and the sum of Net Sales in Values. Add Qty for units. Net Sales is Gross Sales after Discounts; use it rather than Gross Sales when you want what you actually took.
By day of week and hour
Add a column =TEXT(Date,"ddd") for the weekday and use the Time column's hour for the busiest hours. That turns the item report into a staffing and prep plan: which items sell when.
Drop your file in and ask a question — no account needed.
Upload your spreadsheet.xlsx .xls .csv — free to try, no accountSee it on a sample file
What DataMimi shows for a Square item sales
2,727 rows, Jul 2025 – Aug 2026. Computed by DataMimi from a sample export with the same columns as yours — the data is invented, the figures are exactly what the app produces from it.
What this export contains
| Date |
| Time |
| Time Zone |
| Category |
| Item |
| Qty |
| Price Point Name |
| SKU |
| Modifiers Applied |
| Gross Sales |
| Discounts |
| Net Sales |
| Tax |
| Transaction ID |
| Location |
| Dining Option |
What usually goes wrong with it
Gross or net
Gross Sales ignores discounts; comparing items on gross overstates those most often discounted.
DataMimi It reads a Square item export by its headers and uses Net Sales as revenue, saying so on screen.
Modifiers inflate item counts
Items with modifiers appear under several Price Point Names or with Modifiers Applied, which splits one item across rows.
DataMimi It groups by item across price points and lists what it grouped.
Several locations in one file
A multi-location export mixes stores, so a single total hides which location actually sells an item.
DataMimi It breaks every figure down by Location when there is more than one.
Refunds as negative lines
Refunds appear as negative quantities and sales, which a filter on positive rows quietly leaves out.
DataMimi It keeps refund lines as negatives so net sales match what Square reports.
Common questions
How do I get a sales report by item in Square?
Square Dashboard → Reports → Item Sales, set the dates and location, and export the Detail CSV for one row per item sold.
What is the difference between gross sales and net sales in Square?
Gross Sales is before discounts; Net Sales is after them. Use net sales to see what an item actually brought in.
Can I see Square item sales by location?
Yes: filter the Item Sales report by location, or put Location in the columns of a PivotTable on the detail export.
How do I find my busiest days and hours in Square?
Use the Date and Time columns of the detail export to group sales by weekday and hour.
Does Square's item export include refunds?
Yes, as negative quantity and sales lines, so totals already net them off.
Try it with your own file
DataMimi reads the file you actually have — merged cells, headers below row one, totals pasted at the bottom — and shows which rows and columns every number came from.
Ask about your file