Square sales report from your item sales export
Square's item sales export has every item you sold. Superlytix turns it into a report you can read in a minute: how this month compares with last year, which categories and locations carry the business, your best sellers and your average ticket.
Free to try · Pay only when you download your report · No card needed
Net sales by month, vs last year
Net sales by Category
Net sales by Location
Items sold by Item
What the report shows
- Net sales, transactions, average ticket and items sold
- Net sales by month against the same month last year
- Sales by category and by location
- Best-selling items
How to export it from Square
- In your Square Dashboard, go to Reports and open Item sales.
- Pick the date range and locations you want.
- Click Export and choose the item detail CSV.
- Upload it to Superlytix. Dollar signs and negative discounts like -$0.50 are read correctly.
Columns in a typical export
You don't need to rename or remove anything. Superlytix works out what each column is, and you can correct it.
DateTimeTime ZoneCategoryItemQtyPrice Point NameGross SalesDiscountsNet SalesTaxTransaction IDLocationDining OptionEvery number explained
Each number in your report comes with its definition and a worked example from your own data.
| Net sales | Net Sales |
| Items sold | Qty |
| Transactions | Count of distinct Transaction ID |
| Average ticket | Net sales ÷ Transactions |
Questions
Can I compare my locations?
Yes. Every chart can be split by location, and the report gets a location filter on each page.
How much history should I export?
Export at least 13 months in one file, so every month can be compared with the same month last year.
Is my customer data sent anywhere?
Your rows stay on our side. Our Specialized Super Intelligence only sees column names and summaries, never individual sales or customers.
Try it with your own Square export
About 10 minutes from file to report. Free until you download.
Related templates
Square is a trademark of its owner. Superlytix is not affiliated with or endorsed by Square; it reads the files Square lets you export. The numbers above come from a made-up sample file.