Square Transaction Accounting: A Bookkeeper's Guide
Why Square Needs Its Own Accounting Approach
Square is the go-to payment processor for brick-and-mortar businesses, food trucks, salons, and service providers. Unlike Stripe (primarily online) or PayPal (mixed use), Square transactions routinely include tips, itemized discounts, collected sales tax, and per-location tracking — all of which affect how you build journal entries.
Square's transaction CSV breaks every sale into its component columns rather than burying them in a description field. This is great for data quality but means you need a parser that understands how to decompose and reaggregate those columns into proper accounting categories.
Anatomy of the Square Transactions CSV
Want to skip the manual work?
Upload your settlement file — no login required. SettleBooks parses it and generates a balanced journal entry in under 60 seconds.
Try the free Settlement Summary Viewer →When you export transactions from the Square Dashboard, the CSV includes these key columns:
| Column | Description |
|---|---|
| Date | Transaction date |
| Transaction ID | Unique identifier |
| Gross Sales | Sale amount before discounts, tax, and tips |
| Discounts | Discount applied (negative value) |
| Net Sales | Gross Sales − Discounts |
| Tax | Sales tax collected |
| Tip | Tip amount (if applicable) |
| Total Collected | Net Sales + Tax + Tip (what the customer paid) |
| Fees | Square processing fee (negative value) |
| Net Total | Total Collected − Fees (what you receive) |
| Source | In-person, online, invoice, etc. |
| Location | Business location name (for multi-location setups) |
The critical relationship is: Net Total = Gross Sales − Discounts + Tax + Tip − Fees. Every column plays a role in the journal entry.
Square's Decomposed Transaction Model
What makes Square unique is that the CSV pre-decomposes each transaction. Other processors give you a single gross and fee; Square gives you six distinct amounts per transaction:
1. Gross Sales
The sticker price of items sold, before any adjustments. This is your top-line revenue.
2. Discounts
Percentage or dollar discounts applied at checkout. These reduce revenue and should be tracked in a contra-revenue account (not as an expense) so you can monitor discounting patterns.
3. Sales Tax Collected
Tax collected on behalf of the taxing authority. This is not revenue — it's a liability you owe to the state/municipality. It must go to a Sales Tax Payable account.
4. Tips
Tips collected through the Square terminal or online checkout. For most businesses, tips are a liability — you owe them to employees. They flow through a Tips Payable account until paid out. If the business owner keeps tips (rare and legally complex), they'd be Other Income.
5. Processing Fees
Square's flat-rate pricing makes this straightforward: - In-person (card present): 2.6% + $0.10 - Online: 2.9% + $0.30 - Manually keyed: 3.5% + $0.15 - Invoices: 3.3% + $0.30
6. Net Total
What actually hits the bank account. This is the control number your journal entry must reconcile to.
Worked Journal Entry Example
A coffee shop processes the following through Square in a day:
| Category | Amount |
|---|---|
| Gross sales (45 transactions) | $1,820.00 |
| Discounts (loyalty program) | −$62.00 |
| Net sales | $1,758.00 |
| Sales tax collected (8.25%) | $145.04 |
| Tips | $273.00 |
| Total collected | $2,176.04 |
| Processing fees (2.6% + $0.10) | −$61.08 |
| Net deposit | $2,114.96 |
The journal entry:
| Account | Debit | Credit |
|---|---|---|
| Bank Account (checking) | $2,114.96 | |
| Square Processing Fees | $61.08 | |
| Sales Discounts (contra-revenue) | $62.00 | |
| Sales Revenue | $1,820.00 | |
| Sales Tax Payable | $145.04 | |
| Tips Payable | $273.00 | |
| Totals | $2,238.04 | $2,238.04 |
Every dollar is accounted for: revenue, discounts, tax liability, tip liability, processing cost, and net deposit. The entry balances perfectly.
How to Download Your Square Transaction Data
- Log in to the Square Dashboard
- Navigate to Transactions > Transaction History
- Set the date range for the period you need
- Click Export (CSV icon, top right)
- Choose Transactions (not Items or Payments)
- Download the CSV file
For multi-location businesses, you can filter by location before exporting, or export all locations and let SettleBooks group the entries by location.
Importing into Your Accounting Software
QuickBooks Online
Use the SettleBooks Square converter to transform your transactions CSV into journal entries. The converter handles tip/tax/discount decomposition automatically. Export as IIF for Desktop or CSV for Online.
Xero
After conversion with SettleBooks, import the Xero-formatted CSV via Accounting > Manual Journals > Import. Tips and tax are mapped to the correct liability accounts.
Sage
Export as Sage CSV from SettleBooks and import through Transactions > Journal Entries. Square categories map to Sage nominal codes, with tax and tips properly classified as liabilities.
Edge Cases to Watch For
Partial Refunds
Square supports partial refunds on any transaction. A partial refund reduces gross sales and may also reduce the tip and tax proportionally. The processing fee for the original transaction is not refunded — Square keeps it. Record partial refunds as negative revenue with the lost fee tracked separately.
Tips Paid Out vs. Tips Collected
Tips collected through Square are typically paid to employees via payroll. Don't double-count: the tip is a liability when collected (credit Tips Payable) and cleared when paid (debit Tips Payable, credit Bank Account via payroll). Only record the collection side in the Square journal entry.
Multi-Location Businesses
If your client has multiple Square locations, each location may have separate payouts. Consider creating location-specific sub-accounts (e.g., "Sales Revenue — Downtown", "Sales Revenue — Airport") to track performance by location. SettleBooks can group journal entries by the Location column automatically.
Cash vs. Card Transactions
Square's transaction export only includes card transactions processed through Square. Cash sales tracked in Square POS appear separately. Make sure you're not missing cash revenue by only importing the card transaction file.
Gift Card Transactions
Gift card sales are not revenue — they're a liability (unearned revenue). When a gift card is redeemed, that's when revenue is recognized. Square tracks gift card sales and redemptions separately; make sure your journal entries classify them correctly.
Square vs. Stripe vs. PayPal: A Comparison
| Feature | Square | Stripe | PayPal |
|---|---|---|---|
| Primary use | In-person + online | Online-first | Online + marketplace |
| Tips in CSV | ✓ (dedicated column) | ✗ | ✗ |
| Tax in CSV | ✓ (dedicated column) | ✗ | ✗ |
| Discounts in CSV | ✓ (dedicated column) | ✗ | ✗ |
| Location tracking | ✓ | ✗ | ✗ |
| Fee structure | Flat rate | Percentage + fixed | Percentage + fixed |
| In-person rate | 2.6% + $0.10 | 2.7% + $0.05 | 2.29% + $0.09 |
| Online rate | 2.9% + $0.30 | 2.9% + $0.30 | 3.49% + $0.49 |
| Refund fee policy | Fee not refunded | Fee sometimes refunded | Fee not refunded |
| Chargeback fee | None | $15.00 | $20.00 |
Square's richer CSV structure means more accounting detail per transaction but also more complexity in building journal entries. The tradeoff is worth it — you get better financial visibility.
Recommended Chart of Accounts
| Square Category | Account Name | Account Type |
|---|---|---|
| Gross sales | Sales Revenue | Income |
| Discounts | Sales Discounts | Contra-Revenue |
| Sales tax | Sales Tax Payable | Current Liability |
| Tips | Tips Payable | Current Liability |
| Processing fees | Square Processing Fees | Expense |
| Refunds | Refunds & Returns | Contra-Revenue |
| Net deposit | Bank Account | Asset |
Automate Your Square Reconciliation
Square's decomposed transaction format means more columns to parse, more accounts to map, and more chances for manual error. SettleBooks handles the full decomposition — tips, tax, discounts, fees, multi-location grouping — and produces balanced journal entries in seconds.