What the Square QuickBooks Integration Books Each Month
The import reads your Square payments, refunds, orders and payouts. This is how each kind of activity is booked:
| Square activity | Where it lands in SparkReceipt |
|---|
| Payments at the register and online | Sales on the month's Income |
| Sales tax or VAT you set up in Square | Tax on the sales lines, at the rate you set |
| Discounts | Their own lines on the month's Income |
| Refunds | Refunds on the month's Income |
| Square's processing fees | The month's fee Expense, with Square as the Merchant |
| Invoices sent with Square Invoices | Each invoice as its own Income, its payments left out of the monthly sales |
| Tips, gift card sales and app fees | Kept out of your sales |
| Payouts | Matched to the deposit in your bank, never booked as Income again |
The Income is dated on the last day of the month, so a sale on the 31st counts in that month even when Square pays it out days later. If you sell in more than one currency, each currency gets its own Income for the month.
Tips aren't counted as sales. If you keep your tips as income, add them yourself or ask your accountant how they want them booked.
Square Payouts and Your Bank
Square pays out on its own schedule, and one deposit often covers a few days of sales. Each import reads the payouts Square sent that month. When the deposit shows up on your bank statement or bank feed in SparkReceipt, it's matched to its payout by the exact amount, Square's name and the arrival date. The matched bank line isn't turned into a second Income, so each sale counts once in your reports.
Square's own help center explains how its payouts work, including instant and scheduled transfers.
Square Bookkeeping for the Month End
Without a connection, Square bookkeeping at month end means downloading the sales summary, splitting gross sales from tax and fees, and matching the deposits to your bank. With Square connected, the import does all three:
- The month's sales, discounts, refunds and tax are booked as Income, dated in the month you made the sales.
- Square's fees are booked as an Expense, ready to deduct.
- The month's payouts are matched to the deposits in your bank.
Your invoices are booked as you send them. What's left for you is a review: open the month's Income and Expense, check the totals against your Square Dashboard, and publish. If you work with an accountant, invite them to your account for free and they can do the review themselves.
Signing In and Signing Out
You connect with Sign in with Square, so you never type a Square password or key into SparkReceipt. Square asks you to allow SparkReceipt to read your payments, orders, invoices and payouts. Square's sign-in has an expiry date, shown on the Square card on your Integrations page. If Square ever asks you to sign in again, the card shows Needs attention and a Sign in again button.
Disconnecting stops the imports and removes SparkReceipt's access. The months and invoices already imported stay as they are.
Your Square 1099-K
Square sends a Form 1099-K when your payments pass the federal threshold. Box 1a is your gross sales before fees and refunds, as the IRS explains, so it won't match your deposits. With your Square months booked as gross sales, refunds and fees, you can check the form against your own records. Our Form 1099-K guide shows how.
Is This the Right Square QuickBooks Integration for You?
SparkReceipt books Square as one Income and one Expense a month, plus one Income per invoice. That suits a shop, salon, food truck or service business whose accountant wants clean monthly totals for sales, tax and fees, with each payout matched to the bank. It also suits a business without accounting software, where SparkReceipt is the books and the monthly Income feeds your Profit & Loss report directly.
If you need every Square payment as its own transaction in QuickBooks, a per-transaction sync app is the closer fit, and you'd publish your Square months from one place only. For most small businesses, the monthly view is the one their accountant asks for.
The same SparkReceipt account scans your supplier receipts, imports your bank statements and tracks the rest of your income, so your Square sales sit next to everything else your books need. When you connect Square, the Square QuickBooks integration starts with the months you choose, and each new month arrives on its own.