into for QuickBooks
FileInto turns a Square transactions CSV into a QuickBooks file with sales and processing fees split out.
- Never uploaded, stays on your device
- Free preview
- Opens in QuickBooks
How to get the file from Square
- In the Square Dashboard, open Payments, then Transactions.
- Set the date range you need.
- Click Export and choose Transactions CSV.
- Drop the downloaded file below.
Have a different file, or need a different one? Click or above.
How to import into QuickBooks
QuickBooks Online
- Go to Bank transactions (under All apps, then Accounting, or under Transactions on some plans).
- Open the Link account menu and choose Upload from file.
- Drag in the .qbo file from FileInto and pick the QuickBooks account it belongs to.
- Review the new transactions on the For review tab, then categorize and add them.
QuickBooks Desktop
- Go to Banking, then Bank Feeds, then Import Web Connect Files.
- Select the .qbo file from FileInto.
- Choose Use an existing QuickBooks account and pick the account, then Continue.
- Open the Bank Feeds Center to review and add the transactions.
What FileInto looks for in your file
| Column | Examples | Notes |
|---|---|---|
| Date | 10/01/2026 | The sale date. |
| Description | 2 x Latte, 1 x Croissant | The items sold. Fee lines keep it in the memo. |
| Total Collected and Fees | $22.53 and -$0.71 | Total Collected (with tax and tips) becomes the sale; Fees becomes a separate Square fee line. |
Problems and fixes
- QuickBooks shows only the net amount
- Leave "Split fees into their own lines" on. Each Square sale then comes in at its full amount with a separate Square fee line, so income and fees are both right.
- Pending or failed payments are missing
- They are skipped on purpose. Only completed payments belong in your books; export again after Square finishes them.
- The same payments appear twice
- Each line gets a fixed id from its date, amount and description, so importing the same export again is skipped by QuickBooks. Overlapping date ranges from different exports can still duplicate; export non-overlapping ranges.
- Payouts look like expenses
- Payouts move money from Square to your bank. In QuickBooks, match or categorize them as a transfer to your bank account, not an expense.
Questions
- Why use Total Collected and not Net Sales?
- Total Collected is what the customer paid, including tax and tips, which is the money that moved. Net Sales leaves those out.
- Doesn’t Square connect to QuickBooks already?
- Square’s own QuickBooks app syncs ongoing sales. This converter is for history, for accounts without the app, and for anyone who wants a file they control.
- Is my Square export uploaded?
- No. FileInto converts it inside your browser tab.
- What are the limits?
- Files up to 25 MB. Every file gets a full preview free. Downloads up to 25 transactions are free, no account needed; a Day Pass ($9 for 24 hours) or Unlimited ($7 a month) has no row limit. It works in current versions of Chrome, Edge, Safari and Firefox, on computers and phones.
Pick a converter
Every converter runs in your browser. Nothing is uploaded.
Turn your Square file into
- CSVExcel and Google SheetsSoon
- QBOQuickBooksCurrent
- QFXQuickenCurrent
- OFXXero, GnuCash and moreCurrent
- QIFOlder QuickenCurrent
Make a QBO file from
Bank and card files
Payment processors
- PayPalintoQBOFor QuickBooks
- StripeintoQBOFor QuickBooks
- SquareintoQBOFor QuickBooks
- PayPalintoQFXFor Quicken
- PayPalintoOFXFor Xero, Moneydance and GnuCash
- PayPalintoQIFFor older Quicken and other apps
- StripeintoQFXFor Quicken
- StripeintoOFXFor Xero, Moneydance and GnuCash
- StripeintoQIFFor older Quicken and other apps
- SquareintoQFXFor Quicken
- SquareintoOFXFor Xero, Moneydance and GnuCash
- SquareintoQIFFor older Quicken and other apps
Bank downloads
No converter for “” yet. Tell us what you need and we will look at it.