Convert Square Checking CSV to QuickBooks (.QBO)
Works with Square Checking CSV and Excel exports Nothing uploaded
Square Checking is the business bank account built into Square, where card sales settle without the usual transfer delay. Square does not hand you a QuickBooks Web Connect (.QBO) file. What you can pull from the Square Dashboard is a CSV, either an account activity export or the broader transactions report, and that CSV is what you convert here into a .QBO file.
The catch with Square is the export width. The full transactions CSV runs to roughly fifty columns, with separate fields for gross sales, fees, tips, taxes, and net deposit. QuickBooks does not want all of that. For bank-style reconciliation you usually care about the date, a description, and a single net amount. When you map columns in the converter, point it at the date, the description, and the net amount column, and ignore the rest.
If you are tracking Square Checking itself (the money in and out of the account), use the account activity export rather than the sales transactions report. It is narrower and lines up better with what you reconcile in QuickBooks. Map it once, download the .QBO, and import it as you would a normal bank feed file.
.QBO QuickBooks accepts. For Square Checking, its dates are usually MM/DD/YYYY, and amounts arrive as a use the net amount column (separate gross, fee, and net fields exist; pick net for reconciliation), both detected automatically.A typical Square Checking export has columns like Date, Time, Time Zone, Description, Gross Sales, Fees, Net Total, Net Amount, Transaction ID and uses MM/DD/YYYY dates. QBO Maker auto-detects these, just confirm the mapping.
How to import Square Checking statements into QuickBooks
- Export your transactions from Square Checking online banking as CSV or Excel.
- Open the QBO Maker converter and drop the file in.
- Confirm the auto-detected date, amount (or separate debit/credit) and description columns.
- Choose .QBO as the output and click download.
- In QuickBooks Online: Transactions → Bank transactions → Upload from file, then select the .QBO. In Desktop: Banking → Bank Feeds → Import Web Connect File.
Square Checking-specific things to watch for
- Square's transactions CSV is very wide (around fifty columns). Map the date, description, and net amount, and ignore gross, fee, and tax columns to avoid double counting.
- Fees are shown as their own column rather than as separate transactions. If you want fees booked separately in QuickBooks, handle that with rules after import.
- Date and time are split across separate columns. The converter only needs the date column.
- For the Square Checking balance (deposits and withdrawals), use the account activity export, not the sales transactions report, which mixes sale-level detail.
QuickBooks Online vs Desktop
QuickBooks Online: Transactions → Bank transactions → Upload from file → choose your .QBO. QuickBooks Desktop: Banking → Bank Feeds → Import Web Connect File. Desktop is stricter about the bank ID.
Frequently asked questions
Can I export a .QBO file from Square?
No. Square exports CSV (and PDF statements). QuickBooks Desktop needs a .QBO file, so the CSV has to be converted first. QBO Maker does that conversion in your browser.
Which amount column should I map, gross or net?
For bank-style reconciliation, map the net amount. Gross plus a separate fee column will overstate your income if both are imported. If you need fees split out, add a QuickBooks rule after the .QBO is imported.
Why does my Square CSV have so many columns?
Square's sales report carries detail for every part of a transaction (sales, fees, tips, taxes, refunds). QuickBooks does not use most of it. When you map columns here, just select date, description, and net amount.
Does converting upload my Square data anywhere?
No. Everything runs locally in your browser and nothing is sent to a server. Convert your Square CSV now.
Convert your Square Checking statement now
Free, in your browser, nothing uploaded.
Open the converter