Square exports a CSV and nothing else. The QuickBooks sync reaches back about 18 months and only into QuickBooks Online. Upload a Square statement, payout report, or Square Checking statement here and get a real .QBO Web Connect file that Online and Desktop both accept. Start free, no credit card.
Last updated July 2026
Upload your bank statement
Drop file here or click to upload
PDF, JPG, PNG, BMP, HEIC, TIFF, MT940
Uploading...
Upload the Square statement, payout report, or Square Checking PDF statement to BankXLSX and choose QBO as the download format. Square offers no QuickBooks file of its own: its exports are CSV, and the Connect to Square app syncs only into QuickBooks Online, reaching about 18 months of prior transactions. The converted QBO imports into the matching QuickBooks account for any period, including closed accounts and history the sync will not backfill.
Square is a payments company, not a bank, and its accounting exports show it. Everything comes out as a spreadsheet, and the sync only covers a window.
Sales, Transactions, Payments, Payouts: every Square report downloads as a CSV. A Transactions CSV runs to roughly 52 columns of raw data. There is no Web Connect option anywhere in the Dashboard.
Connect to Square imports up to around 18 months of prior transactions when you set it up. Older periods, and the year you are rebuilding in a cleanup, sit outside it.
The Square connector is a QuickBooks Online app. Desktop shops are pushed toward third-party syncs or a sales receipt import, and Web Connect remains the only supported way to bring activity into a Desktop bank account.
Square nets processing fees, refunds, and chargebacks out of each payout, so the deposit that hits your bank is smaller than what you sold. Book the deposit as revenue and you understate sales and lose the fee entirely.
Square Checking is a real deposit account behind the scenes, and its monthly statements come as PDFs like any bank's. A PDF is not importable, no matter which QuickBooks you run.
A restaurant owner forwards the monthly statement. Dashboard access, with the permissions needed to pull raw reports, usually never arrives.
Upload the Square statement or report and get a valid Web Connect file, with sales, fees, refunds, and payouts kept apart.
An actual .qbo with the structure QuickBooks expects, the only format QuickBooks Desktop Web Connect will import and the cleanest one for an Online upload.
A statement carries no sync window with it. Convert a period from three years ago or an account you have already closed.
Square's processing fee stays its own line instead of disappearing into the payout, so revenue books at gross and the fee books as an expense.
Each payout survives as a single transaction, which is what lets you match it against the deposit that lands on your bank feed.
Refunds and disputes come across with the correct sign, so the Square balance in QuickBooks moves the way Square says it did.
256-bit encryption in transit, and you can delete your uploaded files whenever you want.
No software to install and no credit card to start.
In the Square Dashboard, open Balance or Reports and save the monthly statement or payout report. Square Checking statements sit under the Banking section as PDFs. A file a client forwarded works just as well. Drag it into the box above.
Tip: The monthly statement is the cleanest starting point for bookkeeping.
Once the transactions are read, pick QBO as the download format. QFX, OFX, CSV, and Excel sit next to it.
Tip: Pick QFX if the target is Quicken.
QuickBooks Online: Transactions, Bank transactions, Upload from file. Desktop: File, Utilities, Import, Web Connect Files. Point it at the Square account in your chart of accounts, set up as a bank account.
Tip: One account per file.
Square runs the register at a huge number of US restaurants, salons, coffee shops, and retail stores, and almost all of them keep their books in QuickBooks. The gap between what Square records and what the bank shows is where the bookkeeping work lives.
Daily card sales, tips, and refunds go in, one netted payout comes out. Both sides have to reach QuickBooks for the numbers to tie.
Convert whatever period the client forwarded, without Dashboard access and without waiting on a sync that will not backfill it.
Two years behind is common in hospitality. The sync reaches roughly 18 months, so the rest of the rebuild comes from converted statements.
The Square app is an Online product. Desktop imports Web Connect files, and a converted statement is a proper one.
Yes, but every native route has a catch. The Connect to Square app syncs into QuickBooks Online and brings in roughly 18 months of prior transactions. Square's own exports are CSV files, which QuickBooks Online will take with column mapping but QuickBooks Desktop will not accept for banking at all. And a converted statement produces a Web Connect .QBO that either version imports directly. Which route you need comes down to two questions: how far back are you going, and are you on Online or Desktop.
| Path | File or method | History reach | Works with QuickBooks Desktop? |
|---|---|---|---|
| Connect to Square app | Live app sync | About 18 months of prior transactions | No, it is an Online app |
| Square Dashboard export | CSV, around 52 columns | Whatever range you select | No native CSV banking import |
| Square Checking statement | Every month the account was open | No, a PDF is not importable | |
| Converted Square statement | A real .QBO Web Connect file | Any period Square recorded | Yes |
The division of labor is the familiar one. The app owns the current period, the CSV is raw material rather than an import file, and conversion covers what neither of them will touch, which is most of what a cleanup or an audit needs.
No. Everything Square hands you downloads as a CSV, and the Transactions CSV is a wide raw export running to roughly 52 columns, built for analysis rather than for import. There is no Web Connect option in the Dashboard. QuickBooks Desktop imports bank activity through Web Connect files, so a Square CSV cannot go straight in, and even in QuickBooks Online a CSV upload means mapping columns by hand every time. Converting produces the file Square never made.
Because Square takes its fees, refunds, and any chargebacks out before it pays you. A day with 2,000 dollars of card sales might land in the bank as 1,940 after processing fees, and a refund from last week can reduce it further. If you book the deposit as revenue, sales are understated by the fees and the processing cost never reaches your profit and loss. The fix is to record gross sales, record the fee as an expense, and treat the payout as a transfer that lands in the bank.
Square is a payments company, part of Block, Inc., not a chartered bank in the way Chase or Wells Fargo is. Square Checking and Square Savings are deposit accounts provided through its banking partners and Square Financial Services, and they are FDIC insured through those institutions. The practical consequence for your books is that you may be dealing with two different documents: a payments report showing sales, fees, and payouts, and a genuine bank statement for the Square Checking account. They convert the same way but belong in different QuickBooks accounts.
Set up Square as its own bank account in QuickBooks and let the sales, fees, and refunds flow through it. The payout then appears as a withdrawal from that Square account, and the same amount appears as a deposit on your real bank feed. Match them as a transfer. Skip that step and post the bank deposit straight to income, and you have booked the revenue once through Square and once through the bank, which is the most common way Square books end up overstating sales. The same logic covers a PayPal withdrawal or a Stripe payout.
If the Connect to Square app is already running, load converted history behind it, never over it. Open the register, find the oldest transaction the app brought in, and end your converted file the day before that date. Restaurants and retail generate a lot of lines, so before a big rebuild check how many transactions QuickBooks accepts at once, because a QuickBooks Online upload caps at 1,000 lines per file and a busy month of card sales can approach that on its own.
The same upload produces more than a QuickBooks file. Take XLSX or CSV instead with the Square statement to Excel converter when you want to total a year for a tax return. The step-by-step version of this page is how to import Square transactions into QuickBooks. The PayPal statement to QBO converter covers the other processor most small businesses run alongside Square, the bank statement to QBO converter handles checking and savings, and if the sync window is what sent you here, why QuickBooks only imports 90 days of transactions explains what each connection type reaches.
If you already exported the Square CSV and just need it in Web Connect form, a dedicated CSV to QBO converter does that one job. When statements from several institutions all have to land in the same QuickBooks file, a purpose-built bank statement to QuickBooks converter runs the PDF to QBO workflow across all of them.
Yes. The Connect to Square app syncs into QuickBooks Online and pulls in around 18 months of prior transactions. For older periods, for QuickBooks Desktop, or for a closed account, convert the Square statement or payout report to a .QBO Web Connect file and import that instead.
No. Square exports CSV files only, and its Transactions CSV is a wide raw export of roughly 52 columns. There is no Web Connect download in the Square Dashboard, so the only way to get a .QBO from Square data is to convert it.
About 18 months of prior transactions at setup. That covers a recent year but not a two-year cleanup, and it does nothing for an account you have already closed. Converted statements have no such window.
Not through the Square app, which is a QuickBooks Online product. Desktop takes a Web Connect .qbo file under File, Utilities, Import, Web Connect Files. Convert the Square statement to QBO and import it into the Square account in your chart of accounts.
Square deducts processing fees, refunds, and chargebacks before it pays out, so the deposit is always smaller than gross sales. Record sales at gross, the fee as an expense, and the payout as a transfer into the bank. Booking only the deposit understates revenue and hides the fee.
Yes. Square holds a balance between the sale and the payout, so treating it as a bank account is what lets you match the payout against the deposit on your real bank feed as a transfer, instead of double counting the revenue.
Square is a payments company within Block, Inc. Square Checking and Square Savings are deposit accounts offered through its banking partners and Square Financial Services and carry FDIC insurance through those institutions. Its payments reports and its Checking statements are different documents and belong in different QuickBooks accounts.
The same statement as XLSX or CSV instead.
The processor that never made a QBO file at all.
The processor whose only Desktop file is a legacy IIF.
The store platform whose sync stops at one year.
Convert any bank statement to a QBO file.
Every QuickBooks import path, and the limits on each.
Z tej samej rodziny narzędzi
Get started converting bank statements to spreadsheets.
USD
per month
billed as
$288 yearly
Choose speed vs accuracy when extracting
| Base AI Faster | 2,500 pages |
| Pro AI Best accuracy | 500 pages |
Scale statement conversion across your team with automation.
USD
per month
billed as
$888 yearly
Choose speed vs accuracy when extracting
| Base AI Faster | 10,000 pages |
| Pro AI Best accuracy | 2,000 pages |
Enterprise-grade bank statement conversion and controls.
USD
per month
billed as
$ yearly
Choose speed vs accuracy when extracting
| Base AI Faster | pages |
| Pro AI Best accuracy | pages |
