How to import Square Transactions into QuickBooks Online

QuickBooks Online rejects a raw Square Transactions export on the first try, every time. Here's exactly why, how to fix it yourself in a spreadsheet, and the one-click shortcut if you'd rather skip it.

Why QuickBooks Online rejects it

Square's Transactions export (Reports → Transactions → Export) includes columns like Date, Time, Time Zone, Transaction ID, Payment ID, Gross Sales, Fees, Net Total, Total Collected, and Event Type — often dozens of columns. QuickBooks Online's bank-import tool only accepts a strict 3-column format: Date, Description, Amount. Anything else in the file and it rejects the whole upload rather than guessing which columns to use.

Option 1: Fix it by hand

Free, but tedious if you do it every month.

  1. In your Square Dashboard, go to Reports → Transactions → Export, and pick your date range.
  2. Open the file in Excel or Google Sheets.
  3. Add a new column for Description, combining the Event Type and Transaction ID columns for each row (e.g. "Payment 8HK392910A1234567").
  4. Reformat every value in the Date column to MM/DD/YYYY if it isn't already.
  5. Use the Net Total column as your Amount — not Gross Sales. Net Total is what actually landed in your account after Square's fee.
  6. Watch the sign: Square stores Fees as a negative number, so Net Total = Gross Sales + Fees, not minus. If you're calculating it yourself, subtracting instead of adding will double-count the fee.
  7. Delete every other column so only Date, Description, and Amount remain, in that order, with those exact headers in row 1.
  8. Strip any $ signs or thousands-separator commas from the Amount column — QBO's importer chokes on both.
  9. Save the file as CSV (UTF-8 encoding).
  10. If you have more than ~1,000 transactions, split the file into smaller date ranges before importing.
  11. In QuickBooks Online, go to Banking → Upload transactions and import the file.

Option 2: Skip the manual work

Web App

Square to QuickBooks

Upload your raw Square Transactions export, get back a QuickBooks-ready CSV in seconds — dates, descriptions, and Net Total amounts handled automatically, sign flip and all.

From $14
Try it

Frequently asked questions

Why does QuickBooks Online reject a Square Transactions CSV export?
Square's export has far more columns than QBO's bank-import format expects. QBO wants exactly Date, Description, and Amount — nothing else — so it rejects the file rather than guessing which columns matter.

Which Square column is the real transaction amount?
Use Net Total, not Gross Sales. Gross Sales is the value before Square's fee is deducted; Net Total is what actually landed in your account.

Why is my Square Net Total calculation coming out wrong?
Square stores Fees as a negative number. Net Total = Gross Sales + Fees, not minus — subtracting will double-count the fee.

Is there a row limit for QuickBooks Online CSV imports?
Stay under roughly 1,000–1,500 transactions per file. Split larger exports by date range.

← Back to DigitalBuilds.org