# Convert Square Checking CSV to QuickBooks (.QBO)

_Canonical: https://qbomaker.com/banks/square-checking.html_

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.

## Steps

1. Export your transactions from Square Checking online banking as CSV or Excel.
2. Open the QBO Maker converter and drop the file in.
3. Confirm the auto-detected date, amount (or separate debit/credit) and description columns.
4. Choose .QBO as the output and click download.
5. In QuickBooks Online: Transactions → Bank transactions → Upload from file, then select the .QBO. In Desktop: Banking → Bank Feeds → Import Web Connect File.

**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 free at https://qbomaker.com/#tool, runs entirely in your browser.