Superlytix.ai
VIJoin the waitlist
#templatesRestaurants & retail · Square

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.

Try it with your own file Download the sample file

Free to try · Pay only when you download your report · No card needed

What Superlytix made from the sample file items.csv · 28,341 rows · Jan 2025 – Sep 2026
Net sales
$185.5K
Transactions
18,049
Average ticket
$10.28
Items sold
35,432

Net sales by month, vs last year

Net salesNet sales LY
max $9,939Jan 2025May 2025Sep 2025Jan 2026May 2026Sep 2026

Net sales: mix and momentum by Category and Item

Net sales: mix and momentum by Category and ItemCoffeeFoodPastriesTeaLatteCold BrewCappucci…Drip Cof…AmericanoBreakfas…Avocado …CroissantCinnamon…Blueberr…Chai Lat…Matcha L…$83.2K+12.9%Growing fastestWhole Bean 12oz+21.9%Americano+21.1%Blueberry Muffin+18.0%Cold Brew+15.7%Losing groundNoneSize = share of Net sales; colour = growth (last 9 months vs a year earlier)
Whole Bean 12oz is growing fastest (+21.9%).

Net sales: busy and quiet times

Net sales: busy and quiet timesOctNovDecJanFebMarAprMayJunJulAugSepMonTueWedThuFriSatSunBusiest: Fri (+12.5%) · Quietest: Mon (−12.4%)Net sales per day by weekday, last 12 months. Darker = busier than that month's average day.
Fri is the busiest day (+12.5% vs an average day); Mon is the quietest (−12.4%): a day to fill with offers or to plan staff and stock around.

Net sales ranking by Category over time

CoffeeFoodPastriesTeaRetail
Oct 2025Dec 2025Feb 2026Apr 2026Jun 2026Aug 2026Sep 2026

Net sales by Category

Coffee$88.4KFood$35.9KPastries$31.1KTea$24.4KRetail$5,725

Net sales by Location

Downtown$111.3KEastside$74.2K

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

  1. In your Square Dashboard, go to Reports and open Item sales.
  2. Pick the date range and locations you want.
  3. Click Export and choose the item detail CSV.
  4. 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 Option

Every number explained

Each number in your report comes with its definition and a worked example from your own data.

Net salesNet Sales
Items soldQty
TransactionsCount of distinct Transaction ID
Average ticketNet 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.

Start free

Related templates

ToastToast restaurant sales report from your item selection detailsTurn Toast's item selection details export into a restaurant sales report: net sales vs last year, sales by category, average check by server, best-selling menu items.ShopifyShopify sales dashboard, straight from your orders exportTurn your Shopify orders CSV into a sales dashboard: net sales by month vs last year, best sellers, sales by state and channel. Every number explained. Free to try.Bank & cardCredit card expense report from your activity downloadTurn your business credit card activity download into an expense report: spending by month vs last year, by category and by merchant. Purchases and returns netted correctly.

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.