How to Import Square Transactions into QuickBooks

Short answer: The Connect to Square app syncs into QuickBooks Online and imports around 18 months of prior transactions. Square's own exports are CSV files, which Desktop will not accept for banking and Online only takes with manual column mapping. For anything older, for a closed account, or for QuickBooks Desktop, convert the Square statement or payout report to a Web Connect .QBO file and import that. Square never produces a .QBO of its own.

Square runs the register at a large share of US restaurants, salons, coffee shops, and small retailers, and nearly all of them keep their books in QuickBooks. The friction is always in the same two places: how much history you can bring across, and the fact that the money arriving in the bank is never the money that rang up at the counter.

Can you import Square transactions into QuickBooks?

Yes, but each native route has a limit worth knowing before you start. The app is Online-only and has a history ceiling. The CSV export is raw data rather than an import file. And a converted statement produces the Web Connect file that both editions of QuickBooks accept without mapping anything.

What each Square path to QuickBooks actually reaches

Method 1: the Connect to Square app

In QuickBooks Online, go to Apps, find Square, and connect. During setup you choose how much history to bring in, and the practical ceiling is around 18 months of prior transactions. The import itself is not instant on a busy account, so give it time before you start hunting for missing days.

This covers a recent year well. It does not cover a two-year cleanup, a location you closed, or a client who is only now moving onto QuickBooks with three years of Square behind them. And because it is an Online app, it does nothing at all for a Desktop shop.

Method 2: the Square CSV export

In the Square Dashboard, Sales, then Transactions, then Export, gives you a Transactions CSV. It is a wide file, around 52 columns, and it is genuinely useful for analysis. As an import file it is awkward. QuickBooks Desktop has no native CSV import for bank activity at all, and QuickBooks Online will take a CSV only after you map its columns to Date, Description, and Amount by hand, every single time.

There is one Desktop-specific path worth mentioning for completeness: QuickBooks Desktop for Mac has historically offered a Square import that brings sales in as sales receipts. That is a sales workflow, not a bank feed, and it does not give you a reconcilable Square account.

Method 3: convert the statement to a QBO file

Take the Square monthly statement, payout report, or Square Checking statement, convert it to a .QBO Web Connect file, and import it. There is no date window, no app dependency, and no column mapping. It is the only route that works for QuickBooks Desktop and the only one that reaches a period the sync has already refused to backfill.

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, which should be set up as a bank account.

Why does my Square deposit not match my sales?

Because Square deducts processing fees, refunds, and any chargebacks before it pays you. A day with 2,000 dollars of card sales can land in the bank as roughly 1,940 once the fees come out, and a refund processed from last week reduces it further. If you post that deposit as revenue, your sales are understated by exactly the fees you paid, and the processing cost never appears as an expense.

The correct shape is three separate facts: gross sales are income, the Square fee is an expense, and the payout is a transfer of money you already earned. All three have to exist in the books for the numbers to tie, and all three exist on the statement.

Matching Square payouts to bank deposits

Set Square up as its own bank account in QuickBooks. Sales, fees, and refunds run through that account, so it behaves like a holding tank between the customer's card and your checking account. When Square pays out, that shows as a withdrawal from the Square account and a deposit on your real bank feed. Match the two as a transfer.

Skip that and post the bank deposit straight to income and you have booked the revenue twice, once at the register and once at the bank. In hospitality, where the payout lands almost daily, that error compounds fast and is the single most common reason a Square-based set of books overstates sales.

Is Square a bank?

Square is a payments company inside Block, Inc., not a chartered bank in the way Chase or Wells Fargo is. Square Checking and Square Savings are deposit accounts offered through its banking partners and Square Financial Services, and they carry FDIC insurance through those institutions. For your books that means you may be handling two different documents: the payments report that shows sales, fees, and payouts, and an actual bank statement for the Square Checking account. Both convert the same way, but they belong in different QuickBooks accounts, and mixing them is a fast way to double count.

Handling tips, refunds, and chargebacks

Tips are not your revenue if they pass through to staff, so they should land in a liability account until they are paid out, not in sales. Refunds reduce income and should be posted against the revenue account rather than as an expense. Chargebacks arrive as a deduction from a later payout, often weeks after the original sale, which is why a chargeback that appears in March may relate to a January sale and will never match anything if you are only looking at that day's totals. A full statement import keeps each of these as its own line, so they can be posted correctly instead of being buried in a net figure.

Avoiding duplicates when the sync is already on

Load converted history behind the app, never over it. Open the Square register, find the oldest transaction the sync brought in, and end your converted file the day before that date. Restaurants and retailers generate a lot of lines, so watch the QuickBooks Online cap of 1,000 transactions per uploaded file. A busy month of card sales can approach it on its own, which means splitting a rebuild month by month rather than year by year.

A working order of operations

1. Create Square as a bank account in the chart of accounts.
2. Connect the app if the account is open, then note the oldest date it imported.
3. Pull the monthly statements or payout reports for every earlier period you need.
4. Convert each to QBO and upload it, stopping the day before the sync's earliest transaction.
5. Post gross sales to income, fees to merchant fees, refunds against income, tips to the tip liability.
6. Match every Square payout to its bank deposit as a transfer.
7. Reconcile the Square account to the closing balance on each statement.

Reconciling is what proves the rest. If the Square account in QuickBooks ends the month on the same balance the statement shows, the fees, refunds, and payouts all landed correctly. If it does not, one of them was netted or missed.

The same problem at PayPal, Stripe, and your bank

Every payment platform behaves this way: a sync with a short memory, exports in a format the accounting software does not really want, and fees taken out before the money moves. PayPal is the extreme case, since it never produces a QBO file at all. Banks have their own ceiling, because QuickBooks will not pull transactions older than 90 days through any bank connection, which is Intuit's limit rather than the bank's. If what you actually have is a spreadsheet rather than a PDF, a dedicated CSV to QuickBooks file converter handles that single step.

To work in a spreadsheet instead, the Square statement to Excel converter produces XLSX or CSV from the same upload, and reconciling bank statements covers the month-end routine that ties it all together.

Last updated July 2026.