What Square export file format does this tool accept?

This tool accepts Square Transactions CSV files. Export from Square and upload the CSV file directly.

Can I convert Square CSV to QuickBooks Journal?

Yes, this tool converts Square Transactions CSV exports directly to QuickBooks Journal Entries format compatible with QuickBooks Journal.

How do I import Square transactions to QuickBooks Journal?

Export your transactions from Square, upload the CSV file to this converter, then import the converted file to QuickBooks Journal.

Reconcile Square in QuickBooks Online Complete Fee Matching

🥦

QuickBooks Journal Entries Format

valid rows

Reconcile your Square account in QuickBooks Online. Match Net amounts to bank, track fees as expenses, and close your books accurately.

Free preview — then from $5. Save with bundles.

Free preview before you pay

Files never leave your browser

No account needed to start

Download Sample

Sample Square Transactions CSV

Download

Tool Rating

4.7 / 5 (82 votes)

Reconciliation Questions Answered

How are tips handled?

Tips are credited to a liability account (Tips Payable) rather than income. When you pay employees their tips, you debit Tips Payable and credit Cash. This keeps tips properly tracked and out of your revenue.

How do I match deposits in QuickBooks?

Each journal entry includes the Transfer/Deposit ID. When you see a Square deposit in your bank feed, match it to the journal entry with the same ID.

What is a clearing account for Square?

A clearing account is a separate Square account in QuickBooks that temporarily holds all Square transactions before they settle to your bank. It helps track sales, fees, and deposits separately for easier reconciliation.

How Reconciliation Works

Export from Square

Dashboard → Reporting → Transactions → Export CSV

Upload and Configure

Upload Transactions Export CSV and choose Journal Entry format

Preview and Download

Review converted data, download Quickbooks Online-ready file

Import to QuickBooks Online

Settings ⚙️ → Import Data → Journal Entries → Upload CSV

Discrepancies are highlighted with clear match and mismatch indicators — review differences at a glance.

How People Use This

Square batches our daily card sales into a single deposit that arrives T+2. With tips deducted differently per location, the bank deposit never matched the POS total. I was burning two hours every Monday morning trying to figure out why $8,400 in sales turned into a $7,962 deposit. Now I upload the export, get journal entries with gross, fees, and tips split correctly, and my QuickBooks bank rec matches on the first try.

Our firm handles reconciliation for restaurants and retail shops that all use Square. The 2.6% + $0.10 per-swipe fees plus the 1.75% instant deposit surcharge created a $3,200 variance across one client's accounts last quarter. Every fee was there in the data but manually splitting them into QuickBooks journal entries was unsustainable. The tool produces balanced JEs with Transfer IDs so I match each deposit in the bank feed in seconds.

My accountant kept asking why my Square deposits didn't match my sales reports. Turns out I had $1,170 in processing fees, $340 in refunds, and $2,800 in tips flowing through the same account with no separation. After converting to proper journal entries, my CPA reconciled Q2 in one afternoon instead of the usual three days. He actually called to say it was the cleanest Square reconciliation he'd ever seen.

One of my clients had tips sitting in revenue instead of a liability account for six months. The IRS discrepancy was waiting to happen. Once I started importing journal entries with tips properly split to Tips Payable, the balance sheet made sense and we corrected $14,000 in misclassified income before year-end filing.

Why Square Reconciliation Is Challenging

The Deposit Doesn't Match Problem

Square deposits aggregated amounts to your bank. You had $500 in sales plus $50 in tips, but Square deposited $532.10 after their 2.6% + $0.10 fees. Without proper handling, your books show $532.10 in revenue instead of $500 revenue, $50 tips liability, and $17.90 in fees.

How This Tool Helps

We convert Square Transactions to proper Journal Entries that track everything: - Gross sales credited to Income - Tips credited to Liability (for employee payout) - Fees debited to Expense - Net debited to Bank (reconciles with deposit) Import these to QuickBooks, and your Square balance matches exactly.

Secure, Private Reconciliation

Row-by-Row Matching

Records matched row by row. Mismatches surfaced clearly for review.

Runs in Your Browser

Both files compared in your browser. Nothing uploaded to any server.

GDPR Compliant

No data stored or transmitted. Full EU privacy compliance.

More credits - more savings

Buy bundles and get up to 60% off. Perfect for recurring monthly conversions.

Field Mapping

How Square Transactions fields map to Quickbooks Online Journal Entry

Square Transactions	Source Value		Quickbooks Online Journal Entry	Target Value	Note
`Date`	`2026-01-15`	→	`JournalDate`	`2026-01-15`	Transaction date to MM/DD/YYYY
`Gross Sales`	`100.00`	→	`Credits`	`100.00`	Gross sales credited to revenue
`Fees`	`-2.90`	→	`Debits`	`-2.90`	Processing fees debited to expense (ABS of negative)
`Net Total`	`99.30`	→	`Debits`	`99.30`	Net amount deposited to bank
`Deposit ID`	`DEP789012`	→	`Memo`	`DEP789012`	Payout reference in memo

Why Reconcile Your Data First?

Complete Fee Tracking

Every Square processing fee recorded as a separate expense.

Tips Tracking

Tips recorded as liability, separate from sales revenue.

Bank Reconciliation Ready

Net amounts match Square deposits exactly.

Multi-Location Support

Transactions include location for departmental reporting.

Deposit Matching

Transactions grouped by Transfer ID for easy bank matching.

Refund Handling

Refunds reduce revenue with correct accounting entries.

Data Transformation

Square transactions grouped by Deposit ID become balanced journal entries

One row per transaction, grouped by Deposit ID

Key columns: Date, Gross Sales, Fees, Net Total, Deposit ID

N:1 — Multiple input rows aggregate to one output row

Double-entry accounting with balanced debits and credits

DR Bank Deposit Net amount deposited to your bank account

CR Sales Revenue Gross sales amount

DR Processing Fees Square processing fees as expense (ABS of negative)

Debits must equal Credits (balanced double-entry)

Common Journal Entry Import Errors

Issues you might encounter when importing Transactions Export data to Journal Entry - and how we solve them

Unbalanced Journal Entry

QuickBooks requires Debits = Credits for each journal entry

Debit: $970, Credit: $1000 (unbalanced)

Debit: $970 + $30, Credit: $1000 (balanced)

We auto-calculate balanced entries: Bank + Fees = Sales

Each deposit creates a balanced entry with fee breakdown

Square Uses Negative Fees

Square exports fees as negative values (e.g., -$3.22)

Fees: -$3.22

Fees Expense (Debit): $3.22

Fee values are converted to positive for expense tracking

Negative fees are automatically converted using ABS()

Account Names Not Found

Import fails if account names don't match your Chart of Accounts

Account: 'Square Sales' (not in your QB)

Account: 'Sales Income' (matches your QB)

Configure your actual account names before converting

Use account settings to match your QB Chart of Accounts

Frequently Asked Questions

Your data never leaves your device. All files are processed entirely in your browser using client-side JavaScript - no data is stored on our servers or sent anywhere. There's no account to hack, no database storing your files, and no API connections to your bank or accounting software. You upload, convert, download, and we forget it immediately.

No payment or signup required. You can upload your file, see a free preview of the conversion results, and verify everything looks correct before paying anything. If it doesn't work for your files, you haven't wasted any money. We only charge when you're satisfied and ready to download the final converted file.

You can, but free scripts and AI often miss edge cases that break real-world data: missing SKUs, currency formatting quirks, tax calculation errors, or date format mismatches. We have battle-tested validators specifically designed for accounting software imports that catch these issues before they corrupt your books. Plus, you get instant browser-based conversion without installing Python or managing dependencies.

Instant deposit fees (1.75%) are included in the Fee column of exports and are captured in your fees expense account along with standard processing fees.

Each journal entry includes the Transfer/Deposit ID. When you see a Square deposit in your bank feed, match it to the journal entry with the same ID.

Location information is preserved in the journal entry memo. You can use this for departmental tracking or class assignments in QuickBooks.

After importing, the sum of your journal entries for a date range should match the total deposits to your bank. Check the Deposit ID references to trace specific entries.

Square deposits may be set to Undeposited Funds by default. Change this in Square settings by selecting Apps > Sync with Square > Settings, then update your default bank account where Square deposits money.

Square typically transfers real funds to your bank 3-7 days after payment is received. This timing difference is why using a clearing account is recommended for accurate reconciliation.

Square deposits are net of processing fees, refunds, and chargebacks. Check that all fees are recorded in QuickBooks and use the Resolve Difference feature if amounts still don't match.

Yes, reconciling by payout is more efficient than reconciling individual transactions. Group deposits by sales, fees, refunds, and taxes to match Square payouts with QuickBooks.