Convert Square Transactions CSV to QuickBooks Online
Upload your Square export, get QBO-ready Bank Transactions CSV in 10 seconds. Preview free, no signup required.
3 free exports • No credit card required
Exact Supported Export
✅ We Support:
Transactions CSV
Where to find it:
- Square Dashboard
- Click "Transactions" in sidebar
- Click "Export" (top right)
- Select "Export All" or filtered view
- Wait for email with download link
- Download transactions-YYYY-MM-DD.csv
File headers start with:
Date, Time, Time Zone, Gross Sales, Discounts, Net Sales, Tax, Tip...
❌ We Reject:
- Items CSV - Product-level data, no fees or net totals
- Sales Summary - Aggregate dashboard view, not transactions
- Payouts CSV - Bank transfers only, missing transaction detail
- Balance CSV - Balance history, not transaction-level
Square-Specific Handling
✓ Negative Fees
Square stores fees as negative numbers (e.g., fee = -0.33).
Formula: Net = Gross + Fees
Same convention as PayPal, opposite of Stripe/Shopify.
✓ Payout Exclusion
Square CSV includes payout/transfer rows.
We filter these out automatically.
Only revenue transactions and fees exported.
✓ 52 Column Format
Square exports have 52 columns total.
We validate strict 11-column core schema.
Detects modified/incomplete exports.
How It Imports into QuickBooks Online
TrestleFinance outputs Bank Transactions CSV format, which is QuickBooks Online's native import format for bank feeds.
3-Column Format (Date, Description, Amount):
- Revenue transactions: positive amounts
- Fee transactions: negative amounts (like bank fees)
- Refunds: negative revenue amounts
To import: QuickBooks Online → Banking → Upload Transactions → Select file → Map columns → Import
Journal CSV is also provided for advanced users who want debits/credits instead of bank format.
Ready to Convert Your Square CSV?
Upload now and get a full preview before paying. 3 free exports included.
Upload Square CSV