Square Sales Report Analyzer

Square's exports hold more than its dashboard shows, but reading them means a spreadsheet and a lot of pivot tables. Upload your Square export here and get the answers on one page: what sells, when you're slow, what discounts and refunds cost you, and how much goes to card fees. Your file is read in memory, analyzed, and discarded. Nothing is stored unless you choose to share a copy.

Which file to upload

In your Square Dashboard, go to Payments & invoices > Transactions, choose a date range, then Export > Transactions CSV or Items Detail CSV. Pick one or both:

  • Items Detail CSV, one row per item sold. It shows best and worst items, categories, modifiers, and when you sell.
  • Transactions CSV, one row per payment. It shows tips, payment mix, card fees, and when you sell.

Upload both for the full picture. The Items Summary CSV won't work, because it has no dates or orders.

Not sure where to find the export? See how to find and read your Square sales reports.

Best and worst items, categories, modifiers

Tips, payment mix, card fees

CSV files from Square only, up to 10 MB each. Customer names, card details, and IDs are removed as soon as the file is read.

What the results can't tell you

Square's exports have no item costs, so this tool shows sales, not profit. A best seller by revenue can still be a weak earner. To see what each item actually makes, use the menu item profitability calculator.

To match Square's deposits to your bank statement, deposit by deposit, use the free Square Deposit Matcher.

The results are also a snapshot of one file. To track your best sellers, slow hours and sales trends every day without exporting anything, Flumen connects to Square and keeps them current for you.

Start seeing your restaurant's real numbers

This analyzes one export at a time. Flumen connects to your Square account and keeps your best sellers, slow hours and sales trends current from your live sales, with no exports.

Connect Square in one click

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

On another POS? Sign up here instead.

Frequently asked questions

Which Square export should I upload?

The Items Detail CSV and the Transactions CSV, both from Payments & invoices > Transactions > Export in your Square Dashboard. Items Detail shows items, categories, and modifiers. Transactions shows tips, payment mix, and card fees. You can upload either one or both.

Is my Square data stored?

Nothing is stored unless you choose to share a copy. Your file is read in memory, analyzed, and discarded when the results page is built, and nothing from it is logged. If you tick the box to share a copy, we keep a version with customer, employee and card details removed, and delete it after 90 days. How shared copies are handled.

Why doesn't it show profit?

Square's exports don't include what each item costs you, so there's no way to calculate profit from them. Use the menu item profitability calculator to add your costs and see each item's margin.

Does it work with more than one location?

Yes. If your export includes several locations, you'll see a comparison of sales, orders, and average ticket for each one.

How large a file can I upload?

Up to 10 MB per file, which covers months of sales for most restaurants. For a longer period, export a shorter date range.