How to Export Item Sales from Square (2026 Guide)

Go to squareup.com and sign in with your Square account. Ensure you are viewing the correct business location if you operate multiple stores or locations.

Click Reports in the left-side navigation menu. The Reports section contains various sales and financial reports. Look for the Item Sales report, which may be listed under Sales reports or accessible through a submenu.

Select the Item Sales report from the available report types. This report shows a breakdown of sales at the individual item level, including quantities sold, gross sales, discounts, and tax for each product and variation.

Set the date range for the report using the date picker. You can also filter by location, category, or specific items to narrow the results. For a complete export, select all locations and the full date range you need.

Tip: The Item Sales report links to transactions via Transaction ID. Export both this report and the Transactions report for the same date range to cross-reference item-level and payment-level data.

Click the Export button in the upper-right corner of the report. Choose CSV as the file format from the available options. Square generates the file and downloads it to your device. Each row in the file represents one item sold within a transaction.

Open the CSV in a spreadsheet application. Verify that the columns include Transaction ID, Date, Item Name, Variation, Quantity, Unit Price, Gross Sales, Discounts, Net Sales, and Tax. Multi-item transactions will have multiple rows sharing the same Transaction ID.