Square's built-in Xero sync posts a daily summary. One line, one location, fees lumped in. If you run two stores, take bookings, or ever process a refund, the bookkeeper is unpicking it by hand. We connect Square and Xero at the level your accountant actually needs.
Of Australian small businesses spend part of every week on payments admin. Reconciling Square is a good chunk of it for retail and hospitality.
Sales, fees, surcharges, tips and refunds posted to Xero as separate lines, per location, matched to the Square payout in the bank feed.
Yesterday's trade is in Xero before the first coffee.
Runs in your Square and Xero accounts. You own the connection and the documentation.
Square Appointments and Square for Retail stock. Lightspeed and Kounta if you run those. Tyro if you are moving.
Cycle Station runs on this shape of build across multiple stores.
What moves
Each day's Square sales become a Xero invoice or journal with sales split by category, GST handled per item, surcharges and tips on their own lines, and Square's fees posted to the fee account. The payout that lands in the bank then matches to the cent.
What moves
Multi-location businesses need per-store numbers, and the built-in sync gives them one. We post per location with tracking categories, so the owner sees each store's day without a spreadsheet.
What moves
A refund is not negative sales in the wrong period. It is a credit note against the right day, with the fee treatment Square actually applied. Disputes are flagged for a human rather than guessed.
What moves
Square Appointments bookings can flow to your calendar and CRM. Square for Retail stock levels can feed reordering or your website. Both are optional additions to the same connection.
Before you pay
Some of what is on this page you can get without us. The rest is where the money goes. Both are written down here so you can decide before the call.
Square's own Xero integration is free, and for a single-location cafe with no bookings and few refunds it is probably fine. Use it. This build is for businesses with more than one location, a bookkeeper who is reworking the daily summary every week, or bookings and stock that need to go somewhere else too.
Post every individual transaction into Xero. Ten thousand tiny invoices a month makes Xero slow and your accountant unhappy. Daily, per location, per category, with the detail held in a log you can search.
How it works
Every step below is work you can verify. Ask any provider to show you the same list for what they are doing.
Which Square categories go to which Xero accounts. How surcharges, tips and fees are treated. What the owner wants to see per store. An hour with the bookkeeper is usually enough.
Most businesses have months of daily summaries the bookkeeper has already adjusted by hand. We start the connection from a clean date and leave the past alone.
A refund across two days. A payout that skips a public holiday. A new product with no category. Each has a defined outcome before launch, never a silent skip.
Every nightly post is logged against the payout it matched. If a run fails, we are alerted, and it is usually fixed before the bookkeeper opens Xero.
What it costs
Square to Xero starts from $2,500 for one location with category, fee and refund handling. Multiple locations, bookings and stock add to it, and a full multi-store build lands around $5,000 to $6,000. Live within two to three weeks.
The category and account mapping, written down. Nightly posting per location with fees, surcharges, tips and refunds. Payout matching to the bank feed. A searchable log and a handover document.
Your Square and Xero subscriptions, which stay in your name. Re-doing past months the bookkeeper has already reconciled. Fixing wrong tax settings in Square, which we will flag on day one.
You do. The connection lives in your accounts, on your subscriptions, with documentation your next provider could pick up. There is no retainer required to keep it running.
FAQs
If it gives your bookkeeper what they need, do not. The people who pay for this are the ones whose bookkeeper spends an hour a week reworking the summary, or who need per-store numbers the free sync cannot give.
Yes. Lightspeed, Kounta and Tyro all provide settlement and sales data through an API. The Xero side does not change.
Recorded in Square as cash, they post to Xero as cash sales against the till account. Cash banked is then reconciled the normal way.
Yes. GST is handled per item from Square's tax settings, not averaged across the day.
Two to three weeks for most. Multi-store setups with bookings and stock run to four.
Related
Orders, gateway payouts, refunds and GST posted so each Shopify Payments, PayPal and Afterpay deposit matches the bank. Wholesale and stock optional.
Manufacturing and industrialSee how it works → ClinikoXeroTerminal takings matched to Cliniko invoices, practitioner splits calculated, unpaid invoices chased. The Friday spreadsheet goes away.
Healthcare and allied healthSee how it works → WebsiteServiceM8The enquiry form creates the job, matches the customer and texts them back inside a minute. Quote follow-up and review requests optional.
Trades and constructionSee how it works →All nine are listed at integrations, and the general approach is on the systems integration page. Built for retail and hospitality among others.
The other half
This gives you hours back. It does not make the phone ring. If enquiries are the actual problem, the work is on the other side of the business: see SEO and web design. On the call we will tell you which half is costing you more.
Thirty minutes. Tell us what you run and we will map exactly what moves between them, what it takes, and what it costs. You keep the map whether or not you use us.
Get my free audit →