Skip to content

Square QuickBooks Integration

Save hours at every month end: your Square sales, invoices, sales tax and fees are booked for you, without a CSV export

SparkReceipt's Square QuickBooks integration signs in to Square with your permission, then books each month's sales as Income, with the sales tax or VAT you set up in Square, and Square's fees as an Expense. Every invoice you send with Square Invoices arrives as its own Income. Payouts are matched to the deposits in your bank, and the month is ready to publish to QuickBooks Online or Xero. The first import reaches back up to 24 months.

7-day free trial

Business Owners in 175 Countries Trust SparkReceipt

Tracy DugganRobert ConnollyRafael RoaFrédéric ThériaultPierce Mooney
4.8on the App Store · 4.6 on Google Play · 2,700+ ratings
24 monthsImported When You Connect
1 IncomePer Month and Currency
EverySquare Invoice as Its Own Income
190Currencies Supported

Square Bookkeeping Before and After SparkReceipt

What changes when your Square sales and invoices are booked for you

Without SparkReceipt

  • Square deposits entered as income, net of fees and on the payout date
  • Sales tax collected at the register mixed into your revenue
  • Square's processing fees never recorded as an expense
  • Square invoices forwarded by email, one at a time
  • Sales reports downloaded and retyped at every month end

With SparkReceipt

  • Each month's sales booked as Income, dated in the month you sold
  • Sales tax or VAT on its own, at the rate you set in Square
  • Square's fees booked as an Expense with Square as the Merchant
  • Every Square invoice added as its own Income, automatically
  • Payouts matched to the bank deposit and never counted twice

Sales in the month you made them

Why Square Accounting Shouldn't Start From Your Deposits

The money Square sends to your bank is what's left after its processing fees and any refunds. A payout can also mix the last days of one month with the first days of the next. Book those deposits as income and your sales come out too low, the fees you could deduct vanish, and your sales tax is buried inside revenue.

SparkReceipt books Square from the sales themselves. Your gross sales are Income in the month you made them, the sales tax or VAT you collected is kept apart, and Square's fees are an expense of their own. When the payout reaches your bank, it settles what was already booked.

Profit and loss report built from a month of Square sales and fees

Invoices you send with Square, booked one by one

Square Invoices Arrive as Their Own Income

Every invoice you send with Square Invoices is added to SparkReceipt as its own Income, with your customer as the Payer, the invoice number, the due date and the invoice's lines and tax. An invoice you send later in the month shows up in that month's import.

When your customer pays the invoice through Square, the payment isn't counted again in that month's sales, so each invoice is booked once. Square doesn't offer its invoices as PDF files, so the Income carries the invoice's details without an attached file.

Square invoices listed as Income by customer in SparkReceipt

The tax you set up in Square, kept apart

Your Square Sales Tax Report, Ready Each Month

Square already knows which taxes you charge, because you set them up in your item library and at checkout. The import keeps that tax on each sales line, at the rate you set, so the month's Income shows sales and tax separately. Discounts are their own lines, with their tax where Square states it.

That gives you a sales tax figure you can check every month instead of reconstructing it at filing time. In Canada, GST, HST and PST are split the way Square applied them. In VAT countries, each line keeps its rate.

Monthly Square sales with sales tax shown separately in SparkReceipt

Publish Square sales with the rest of your books

Square to QuickBooks Online or Xero

Imported Square months and invoices are Income and Expenses like any other in SparkReceipt, so they publish to QuickBooks Online or Xero through the same connection your receipts use. Automatic publish rules wait until a month has ended, so a half-finished month isn't sent on its own.

One thing to check first: if QuickBooks or Xero already receives your Square sales from another app, publish them from one place only, or the same sales will be booked twice.

Publishing a month of Square sales to QuickBooks Online from SparkReceipt

How the Square QuickBooks Integration Works

1

Connect Square in SparkReceipt

In the SparkReceipt web app, open Integrations, find Square under Sales platforms and click Connect. Choose the first month to import, up to 24 months back.

2

Sign In With Square

Continue to Square and sign in to the business you sell with. Allow SparkReceipt to read your payments, orders, invoices and payouts, and Square sends you back.

3

Choose Categories for Sales and Fees

SparkReceipt suggests one Category for your Square sales and one for Square's fees. Change them if you like and save. Every month's import uses them.

4

Review and Publish Each Month

Each month's sales and tax arrive as one Income, the fees as one Expense, and every Square invoice as its own Income. Check them, then publish to QuickBooks Online or Xero when the month is closed.

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 activityWhere it lands in SparkReceipt
Payments at the register and onlineSales on the month's Income
Sales tax or VAT you set up in SquareTax on the sales lines, at the rate you set
DiscountsTheir own lines on the month's Income
RefundsRefunds on the month's Income
Square's processing feesThe month's fee Expense, with Square as the Merchant
Invoices sent with Square InvoicesEach invoice as its own Income, its payments left out of the monthly sales
Tips, gift card sales and app feesKept out of your sales
PayoutsMatched 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:

  1. The month's sales, discounts, refunds and tax are booked as Income, dated in the month you made the sales.
  2. Square's fees are booked as an Expense, ready to deduct.
  3. 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.

Loved by Small Business Owners

“SparkReceipt is an excellent alternative to full-fledged accounting software, saving you time and money!”
Pierce Mooney

Pierce Mooney

Legal Services · United States

“Thanks to SparkReceipt I have a quick look to my business accounts status in a glance. It is really impressive.”
Rafael Roa

Rafael Roa

System Arquitectura · Spain

“With SparkReceipt, organizing and tracking expenses has never been easier. The detailed categorization and expense tracking features make financial management a breeze.”
Jean-Pierre Michael

Jean-Pierre Michael

Artist · France

Join 38,283 businesses that chose SparkReceipt — 4,620,044 receipts processed and counting.

Get Started

Simple, Transparent Pricing

1 user included, add more at a per-user rate. Cancel any time.

Your accountant joins free

Your first user is included. Each extra user: $1.00/month, billed $12 annually.

Your accountant joins free

Pro

For side hustles.

$5.75/mo

Total for 1 user · $69.00 billed annually

+ VAT/GST where applicable

Get Started

7-day free trial

50 documents / month

For receipts and invoices

  • AI scanning and categorization
  • One connected email inbox
  • One live bank feed connection
  • Bank statement extraction and matching
  • Mileage tracking and expense reports
  • QuickBooks Online, Xero and more
Recommended

Elite

For small businesses with 1 to 40 people.

$10.75/mo

Total for 1 user · $129.00 billed annually

+ VAT/GST where applicable

Get Started

7-day free trial

Unlimited documents*

Everything in Pro, plus:

  • Line-item extraction on every receipt
  • Several connected email inboxes
  • Several live bank feed connections
  • AI Fields for the details you need
  • AI rules for categorizing and filing
  • Schedule C and accounting templates
  • Trips start when your phone connects to your car

Founder-led setup

Joel Ojala

Joel Ojala, co-founder, sets up SparkReceipt with you, tailored to how you work.

$400one-time setup

+ Elite for 1 user: $10.75/mo, billed annually

$529.00 today, then $129.00 a year

+ VAT/GST where applicable

Get set up with Joel

Annual plan only · No free trial

Everything in Elite

Plus a 60-minute session with Joel and one follow-up. In the session:

  • Your process, mapped at a high level
  • Logins for your team, and any extra users you need
  • Set up inbox scanning for receipts and invoices
  • Connect bank / upload your first statement
  • The phone app for paper receipts
  • Expense categories and your accounting integration
  • Anything else you'd like to go through

Unlimited linked accounts on every plan.

Compare all features

Pro

  • 1 user included. Add teammates any time for a flat fee per user, your accountant joins free on top, unlimited linked accounts
  • 50 documents per month (receipts and invoices, mass upload up to 100 at once)
  • AI scanning and categorization
  • Automatic email receipt scanning from one connected inbox (Gmail, Outlook, IMAP)
  • Bank statement extraction and receipt matching (PDF, CSV, Excel)
  • 100 credits a month per user. Bank statements use 1 credit per transaction
  • One live bank feed connection
  • Mileage tracker: GPS or manual trips, with per diem
  • Expense claims: submit receipts and trips, approve, mark paid
  • SparkAgent AI assistant, or connect your own AI over MCP
  • Integrations: QuickBooks Online, Xero, Zapier, Make, Pabbly, plus webhooks and API
  • Expense reports and exports: PDF, Excel, CSV, ZIP; 190 currencies

Elite

  • Everything in Pro, plus:
  • Unlimited documents: receipts and invoices, mass upload up to 100 at once
  • 200 credits a month per user. Bank statements use 1 credit per transaction
  • Line-item extraction on every receipt
  • Several connected email inboxes with automatic scanning
  • Several live bank feed connections
  • AI Fields: tell the AI exactly what to pull from every document
  • Plain-English AI rules: tell the AI how to categorize and file automatically
  • Schedule C export for US tax filing
  • Trips start when your phone connects to your car
  • Export templates for Sage 50, DATEV, Wave, and Sage 200

Founder-led setup

  • A 60-minute setup session with Joel, co-founder, plus one follow-up session
  • Together we set up your process, team logins, inboxes, bank statements, categories and integrations
  • Everything in Elite, billed annually
  • 1 user included. Add teammates any time for a flat fee per user

Unlimited document scanning on Elite is subject to fair use. Bank statement extraction uses monthly renewable credits. Historical email imports include a free allowance; larger imports use credits, with the cost shown before you start.

Frequently Asked Questions

Open Integrations in the SparkReceipt web app, click Connect next to Square under Sales platforms and choose the first month to import. Continue to Square, sign in to the business you sell with and allow SparkReceipt to read your payments, orders, invoices and payouts. Admins and accountants on the account can connect Square.

Up to 24 months. When you connect, you choose the first month to import, and SparkReceipt books every month from then on. Invoices issued before that first month aren't imported.

Yes. Every invoice you send with Square Invoices is added as its own Income, with your customer as the Payer, the invoice number, the due date and the invoice's lines and tax. Its payments aren't counted again in the monthly sales.

No. Your sales are booked as Income in the month you made them, and each payout is matched to its deposit in your bank by amount, name and arrival date. The matched bank line isn't turned into a second Income.

The sales tax or VAT you set up in Square stays on each sales line at the rate you set, so the month's Income shows sales and tax separately. In Canada, GST, HST and PST are split the way Square applied them.

They're kept out of your sales. If you keep your tips as income, add them yourself or ask your accountant how they want them booked.

Yes. Imported Square months and invoices publish to QuickBooks Online or Xero like any other Income and Expense in SparkReceipt, and automatic publish rules wait until the month has ended. If your accounting software already receives Square sales from another app, publish from one place only so the sales aren't booked twice.

The Square QuickBooks integration is included in SparkReceipt Pro and Elite, with no fee per connection. Plans start at $5.75/month, billed annually, with a 7-day free trial.

Put Your Square Sales on Autopilot

Get Started

SparkReceipt connects to Square with Sign in with Square, using permissions you grant. Square is a trademark of Block, Inc. Intuit and QuickBooks are trademarks of Intuit Inc. Xero is a trademark of Xero Limited. SparkReceipt is not affiliated with, endorsed by or sponsored by Block, Intuit or Xero.

Get Started