Convert Square POS Sales
to QuickBooks CSV

Why Square CSV Exports Need Conversion for QuickBooks

Square's POS system generates transaction reports designed for retail and restaurant analytics, not accounting software import. While the data is comprehensive — covering gross sales, tips, discounts, taxes, fees, refunds, and device/location information — the column structure doesn't match what QuickBooks expects. Square exports include 29+ columns with POS-specific data like Device Name, Staff ID, Dining Option, and PAN Suffix that have no equivalent in QuickBooks' import template. Without conversion, you're left manually deleting columns, reformatting data, and splitting combined amounts — a tedious process that's especially painful for high-volume POS businesses.

Common Square Import Errors

When attempting to import a raw Square CSV export into QuickBooks, users commonly encounter these issues:

• “Too many columns” — Square's Transactions Report includes 29 columns, but QuickBooks' CSV import expects only 3 or 4 (Date, Description, Amount, or Date, Description, Credit, Debit for Desktop). The extra columns cause mapping failures.
• Tips combined with sales — Square's “Total Collected” column includes the base sale plus tips. If imported as-is, your revenue appears higher than actual sales, making it impossible to accurately report tip income separately for payroll.
• Fees not tracked as expenses — Square processing fees (2.6% + $0.10 per tap/dip/swipe) are in a separate column but aren't formatted as expense line items. QuickBooks needs them as individual negative entries to properly categorize processing costs.
• Discount reconciliation — Discounts appear as a column value in Square's export rather than as separate adjustment entries. This makes it difficult to track promotional spending and reconcile gross vs. net sales in QuickBooks.
• Multi-location confusion — For businesses with multiple Square locations, all transactions export into a single file. Without location tags in the description, it's impossible to tell which location generated which revenue in QuickBooks.

How the Converter Fixes These Issues

The Square to QuickBooks Converter addresses every compatibility gap between Square's POS export format and QuickBooks' import requirements:

• Column reduction and mapping — Strips the 29-column Square export down to the 3 or 4 columns QuickBooks needs, mapping Gross Sales, Net Sales, or Total Collected to the Amount field based on your preference.
• Tip separation — Extracts tip amounts from each transaction and adds them as separate positive line items. This gives you clean revenue figures for sales vs. tips, essential for accurate payroll tip reporting.
• Fee splitting — Each Square processing fee is extracted and added as a separate negative line item. This creates trackable expense entries so you can categorize fees under “Payment Processing Fees” in your chart of accounts.
• Discount tracking — Discount amounts are optionally split into separate negative entries, making it easy to monitor promotional spending and reconcile gross-to-net sales differences.
• Location-aware descriptions — For multi-location businesses, the converter automatically appends the Square location name to each transaction description (e.g., “Square Payment: Coffee @ Main Street Store”), making per-location reporting straightforward in QuickBooks.
• Daily aggregation — For high-volume businesses, the optional daily aggregation feature combines all transactions of the same type into daily summaries. Instead of importing hundreds of individual transactions, you get clean daily totals for sales, tips, fees, and refunds.

How to Export Transactions from Square

Follow these steps to export your Square transaction data:

1. Log into your Square Dashboard at squareup.com.
2. Navigate to Transactions from the left sidebar.
3. Select your desired date range using the date picker.
4. Optionally filter by location, device, or payment type if needed.
5. Click the Export button (CSV icon) in the top-right corner.
6. Save the downloaded CSV file — it will include all columns from the Transactions Report.

Importing into QuickBooks Online

After converting your Square CSV, follow these steps to import into QuickBooks Online:

1. Log into QuickBooks Online and navigate to Banking from the left sidebar.
2. Click Upload transactions (or “Link account” → “Upload from file” if this is your first import).
3. Select the converted CSV file from your computer.
4. QuickBooks will display a column mapping preview — verify that Date, Description, and Amount are mapped correctly.
5. Choose the QuickBooks account to import into (e.g., “Square Sales” or “POS Deposits”).
6. Click Import to complete the process. Transactions will appear in the “For Review” tab.

Tip: If you split tips during conversion, consider a dedicated “Square Tips” income account for easier reconciliation.

Importing into QuickBooks Desktop

For QuickBooks Desktop (Pro, Premier, or Enterprise), use the Web Connect import method:

1. Open QuickBooks Desktop and go to File → Utilities → Import → Web Connect Files.
2. Browse to and select your converted file.
3. QuickBooks will prompt you to select the account for the imported transactions.
4. Click Continue to import. Transactions will appear in the bank register for review.

After import, check that tip amounts and processing fees appear as separate line items in your register.

Alternatively, you can use our CSV to IIF Converter to generate an IIF file, which can be imported via File → Utilities → Import → IIF Files.

Square Tip and Fee Accounting Best Practices

Properly tracking Square tips and processing fees is essential for accurate financial reporting, especially for restaurants and service businesses. Here are the recommended practices:

• Separate tip income tracking — Create a dedicated “Tip Income” account in your chart of accounts. When tips are split into separate line items during conversion, categorize them into this account. This is essential for accurate payroll tip reporting and compliance with IRS tip reporting requirements.
• Create a processing fee expense category — Set up a “Payment Processing Fees” or “Square Fees” account under Expenses. With fee splitting enabled, each Square processing fee becomes a trackable expense entry that you can categorize automatically.
• Use daily aggregation for high volume — Restaurants and retail stores processing 50+ transactions per day should consider daily aggregation. This creates one sales entry, one tip entry, and one fee entry per day, matching the way Square deposits funds to your bank (daily batches).
• Reconcile against Square deposits — Square batches and deposits daily. Match your daily aggregated net totals against actual bank deposits to ensure nothing is missing. The converter's net amount should match Square's deposit to your bank, minus any holds or reserves.

Need a complete guide to Square POS bookkeeping? Read our Square Accounting Guide — covering processing fee structures, tip income reporting, multi-location accounting, daily deposit reconciliation, and tax compliance for Square merchants.

Related Free Accounting Tools

The Square to QuickBooks Converter is part of our complete suite of free QuickBooks conversion tools:

• CSV to QBO Converter — Convert cleaned bank CSVs into Web Connect (.qbo) files for QuickBooks Online and Desktop.
• CSV to IIF Converter — Convert CSVs into Intuit Interchange Format (.iif) for QuickBooks Desktop import.
• Bank CSV Cleaner — Clean and normalize messy bank CSV exports before importing into QuickBooks.
• Stripe to QuickBooks Converter — Convert Stripe payment exports into QuickBooks-compatible CSV format.
• QBO to IIF Converter — Convert existing QBO files to IIF format when you need to switch import methods.
• IIF to QBO Converter — Convert IIF files into QBO format for QuickBooks Online compatibility.
• IIF File Viewer — Inspect and validate IIF files before importing them into QuickBooks Desktop.
• Chart of Accounts Generator — Generate a customized chart of accounts for your QuickBooks company file.
• PayPal to QuickBooks Converter — Convert PayPal activity exports with locale-aware date handling and transaction type filtering.
• Amazon to QuickBooks Converter — Convert Amazon Seller settlement reports with order aggregation and FBA fee categorization.
• Shopify to QuickBooks Converter — Convert Shopify payout exports with chargeback handling and multi-currency support.
• PDF to QBO Converter — Convert PDF bank statements to QBO, CSV, or IIF format.
• OFX to QBO Converter — Convert OFX bank statement files to QuickBooks Web Connect QBO format.
• QFX to QBO Converter — Convert Quicken QFX files to QuickBooks QBO format for seamless migration.
• QBO to CSV Converter — Export QBO transaction files to clean CSV spreadsheets for Excel and Google Sheets.
• OFX to CSV Converter — Convert OFX bank files to CSV format for spreadsheet analysis.
• OFX to IIF Converter — Convert OFX bank statements directly to QuickBooks Desktop IIF format.
• CSV to OFX Converter — Transform bank CSV exports into standard OFX format for financial software.
• QIF to QBO Converter — Upgrade legacy Quicken QIF files to modern QuickBooks QBO format.
• QBO to PDF Converter — Generate professional PDF bank statements from QBO transaction files.
• MT940 to QBO Converter — Convert SWIFT MT940 European bank statements to QuickBooks QBO format.
• QIF to CSV Converter — Convert legacy Quicken QIF files to clean CSV spreadsheets for analysis.
• QIF to IIF Converter — Convert Quicken QIF files directly to QuickBooks Desktop IIF format.
• IIF to CSV Converter — Export QuickBooks Desktop IIF files to CSV for spreadsheet analysis.
• QBO to OFX Converter — Convert QuickBooks QBO files to standard OFX format for other financial software.
• MT940 to CSV Converter — Convert SWIFT MT940 European bank statements to CSV spreadsheets.
• QBO File Viewer — Preview and inspect QBO Web Connect files before importing into QuickBooks.
• OFX File Viewer — Preview and inspect OFX bank statement files in a readable format.
• XLSX to QBO Converter — Convert Excel spreadsheets directly to QuickBooks Web Connect QBO format.
• Etsy to QuickBooks Converter — Convert Etsy shop payment exports into QuickBooks-compatible format.
• Duplicate Transaction Detector — Scan QuickBooks files to find and flag duplicate transactions before import.
• Import Troubleshooter — Diagnose and fix common QuickBooks file import errors automatically.
• File Format Detector — Identify unknown financial file formats and get conversion recommendations.
• CAMT.053 to QBO Converter — Convert ISO 20022 CAMT.053 bank statements to QuickBooks QBO format.