Square Accounting Guide
Understand Square's fee structure, export your Dashboard data, and import everything into QuickBooks — completely free with PrimeConnect.
Square Fee Structure Explained
Square uses transparent flat-rate pricing — no tiered rates, no monthly minimums.
In-Person Payments
Tap, dip (chip), or swipe transactions processed through Square Reader, Square Stand, Square Terminal, or Square Register hardware.
per transaction
Online Payments
Square Online store, invoices paid online, eCommerce API transactions, and Square checkout links.
per transaction
Keyed-In Payments
Card number typed manually into the Square POS app or Virtual Terminal. Higher rate due to increased fraud risk.
per transaction
Additional Square Fees to Track
Instant Transfers
1.75% fee to receive funds instantly instead of waiting for the standard next-business-day deposit. Record as a bank fee in QuickBooks.
Chargeback Fee
Square does not charge a chargeback fee — they absorb the cost on your behalf. However, the disputed amount is still deducted from your balance.
Square Subscriptions
Square Plus plans ($29+/mo for Restaurants, Retail, or Appointments) are operating expenses — not COGS. Track separately in QuickBooks.
Custom Rates
Businesses processing $250,000+/year can negotiate custom processing rates. These still appear in your export with the actual fee charged per transaction.
How to Export Square Transaction Data
Three export paths give you different views of your Square financials.
Transactions
- Log into Square Dashboard
- Go to Transactions
- Set your date range filter
- Click the Export (CSV) icon
- Save the file to your computer
Best for: individual transaction details including items, tips, and discounts.
Deposits
- Navigate to Balance > Deposits
- Filter by date range
- Click Export
- Choose CSV format
- Download the file
Best for: bank reconciliation — matches bank deposit amounts and dates.
Items Detail
- Go to Reporting > Sales
- Select Items view
- Set date range
- Click Export
- Save CSV file
Best for: SKU-level sales tracking and inventory cost analysis.
Square Accounting Challenges
Square's versatility as both a POS and online platform creates unique bookkeeping hurdles.
POS + Online Unification
Square processes both in-store POS transactions and online sales, but at different fee rates (2.6% + $0.10 vs. 2.9% + $0.30). When both channels deposit into the same bank account, a single day's deposit mixes in-person and online sales. Your accounting must differentiate between channels to accurately track fee expenses and understand per-channel profitability. Without splitting by payment type, you cannot tell which channel costs more.
Tips & Modifiers
Tips are a significant revenue component for service businesses using Square. Square processes the tip as part of the total charge, but it needs separate accounting treatment — tips collected are a liability (owed to employees), not revenue. Additionally, item modifiers (e.g., "add extra shot $0.75") change the line item total but do not always export as separate entries, making it hard to track modifier-level revenue accurately in QuickBooks.
Inventory Tracking Sync
Square's inventory management tracks stock levels in real-time, but exporting this data to QuickBooks requires mapping each Square item to a QuickBooks inventory item. When items are sold across both POS and online channels, stock deductions happen in Square, but cost-of-goods entries need to be manually created or imported into QuickBooks. Mismatched item names or SKUs between the two systems create reconciliation headaches.
Square Payroll Integration
If you use Square Payroll, payroll debits come from the same Square account as your sales deposits. This creates confusion in your bank feed — some Square transactions are income (sales deposits) and others are expenses (payroll debits). Without careful categorization, payroll expenses may accidentally offset sales revenue. Keep payroll in a separate QuickBooks account and always export payroll reports separately from transaction reports.
Square to QuickBooks Workflow
Follow these five steps to get your Square data into QuickBooks accurately.
Export from Square Dashboard
Log into your Square Dashboard and navigate to Transactions. Set your date range (weekly is recommended for regular reconciliation) and click the Export icon to download a CSV file. For deposit-level reconciliation, also download from the Balance > Deposits section.
Upload to PrimeConnect Converter
Open the Square to QuickBooks converter and drag-and-drop your CSV file. The tool automatically detects Square's column format and parses all transaction types — sales, refunds, tips, discounts, and fees. Everything runs in your browser with zero server contact.
Configure Tip & Fee Splitting
Review the auto-detected settings. Enable tip splitting to separate tip amounts from sale amounts (critical for proper liability tracking). Enable fee splitting to break out Square processing fees as separate COGS line items. Choose your QuickBooks edition for correct column mapping.
Download QuickBooks-Ready File
Preview the converted transactions, then download the QuickBooks-compatible CSV. Need a different format? Use PrimeConnect's CSV to IIF converter for QuickBooks Desktop or the CSV to QBO converter for Web Connect import.
Import & Reconcile in QuickBooks
Import the converted file into QuickBooks using the bank feed or file import workflow. Match each Square deposit to the corresponding bank transaction. Categorize processing fees as COGS, tips as a liability account, and Square subscription fees as an operating expense.
QuickBooks Account Mapping for Square
Map each Square transaction type to the correct QuickBooks account.
| Square Transaction Type | QuickBooks Account | Account Type |
|---|---|---|
| Sale revenue (POS) | Square POS Sales | Income |
| Sale revenue (online) | Square Online Sales | Income |
| Processing fee | Square Processing Fees | COGS |
| Tips collected | Tips Payable | Current Liability |
| Discount applied | Sales Discounts (contra) | Income (negative) |
| Refund | Square Sales (contra) | Income (negative) |
| Subscription fee | Software & Subscriptions | Expense |
| Instant transfer fee | Bank Fees | Expense |
Square Tax Considerations
Sales Tax Collection & Reporting
Square calculates and collects sales tax automatically based on your business location and the buyer's shipping address (for online orders). Square's tax engine handles varying state, county, and city tax rates. However, Square does not file or remit sales tax on your behalf — that remains your responsibility. Export your Square sales tax report (Dashboard > Reporting > Taxes) to verify amounts collected, then file with your state tax authority. Track collected tax in a "Sales Tax Payable" liability account in QuickBooks.
1099-K Reporting Threshold
Square is required to issue a 1099-K form to sellers who exceed the IRS reporting threshold. As of 2024, the threshold is $5,000 in gross payments (phased in from the original $600 threshold). The 1099-K reports gross sales before processing fees, refunds, and tips — so it will be higher than your net deposits. Accurate bookkeeping that tracks fees, refunds, and tips separately is essential to avoid overpaying taxes. Your Square-to-QuickBooks import should preserve all deduction categories.
Multi-Location Tax Complexity
If you operate Square POS at multiple locations (different cities or states), each location may have different tax rates. Square handles this automatically for collection, but your QuickBooks setup must mirror this structure with location-based tax codes. Create a separate "Sales Tax Payable" sub-account for each tax jurisdiction to ensure you remit the correct amount to each authority. Our converter preserves the tax amount from each Square transaction so your per-location totals stay accurate.
Square Accounting Best Practices
Follow these six rules to keep your Square books clean year-round.
1. Separate POS and Online Revenue
Create separate income accounts in QuickBooks for in-person POS sales and online sales. This gives you visibility into which channel drives more revenue and which has higher processing costs (online fees are 0.3% + $0.20 more per transaction than in-person).
2. Track Tips as a Liability
Never record tips as revenue. Tips collected through Square belong to your employees — record them in a "Tips Payable" current liability account. When you distribute tips (via payroll or cash), offset the liability. This prevents overstating your gross revenue.
3. Reconcile Daily Deposits
Square deposits are settled next business day. Match each bank deposit to the corresponding day's transactions in Square Dashboard. If you use instant transfers, reconcile those separately and track the 1.75% fee as a bank fee expense.
4. Isolate Payroll from Sales
If you use Square Payroll, export and import payroll data separately from sales data. Never mix the two in the same QuickBooks bank account. Create a dedicated "Square Payroll" account to track payroll debits and prevent accidental netting against sales deposits.
5. Monitor Keyed-In Transaction Volume
Keyed-in transactions cost 3.5% + $0.15 — nearly a full percentage point more than in-person swipes. Track keyed-in volume as a percentage of total transactions. If it exceeds 10%, investigate why staff are keying in cards instead of using the reader. This is often a training or hardware issue that directly impacts your margins.
6. Use Square Item Categories
Organize items into categories in Square Dashboard (e.g., Food, Drinks, Merchandise). When you export, these categories map to QuickBooks product/service items, enabling P&L reporting by product line. Consistent naming between Square and QuickBooks eliminates manual mapping during import.
Related PrimeConnect Tools
Everything you need to get Square data into QuickBooks — free.
Square to QuickBooks
Convert Square Dashboard exports to QuickBooks-ready CSV with tips and fees split automatically.
Convert free →CSV to IIF Converter
Convert CSV output to IIF format for QuickBooks Desktop import.
Convert free →CSV to QBO Converter
Convert CSV output to QBO (Web Connect) for direct QuickBooks bank feed import.
Convert free →Multi-Channel Merge
Combine Square exports with other platforms into one QuickBooks file.
Merge now →Analytics Dashboard
Compare Square fees and revenue against other platforms visually.
Analyze now →Ecommerce Accounting Hub
Central hub for all 11 platform converters and accounting guides.
View all tools →Related Platform Guides
Using multiple payment processors? These guides cover accounting for other gateways commonly paired with Square.
Stripe Accounting Guide
Fee structure, balance exports, gross vs net revenue recognition, and QuickBooks import workflows for Stripe.
Read guidePayPal Accounting Guide
Fee structure, activity exports, holding reserves, Venmo for Business, and QuickBooks import workflows for PayPal.
Read guideVenmo Accounting Guide
Business vs personal separation, $600 1099-K threshold, statement exports, and QuickBooks import for Venmo.
Read guideFrequently Asked Questions
How do I export my Square transaction data?
What are Square's processing fees?
How do I handle tips in QuickBooks from Square?
Can I use Square and QuickBooks together?
How do I reconcile Square deposits with my bank?
How does Square handle refunds in accounting?
Is the Square to QuickBooks converter free?
How do I account for Square Payroll in QuickBooks?
Convert Your Square Data to QuickBooks — Free
Upload your Square Dashboard export and get a QuickBooks-ready file in seconds. Tips, fees, and discounts split automatically. 100% browser-based.
Convert Square to QuickBooks →