solutionsvat
Square or SumUp to Xero: Fixing VAT Rate Mismatches on Mixed-Rate Sales
If your VAT figures look wrong after syncing Square or SumUp to Xero, the usual cause is mixed VAT rates landing under one tax rate. Set the right VAT rate on every item in your till. Choose a sync that splits sales by VAT rate. Then check each rate lands on the matching tax rate in Xero.
Sumcraft Editorial Team8 min read
Checked on 20 October 2026. Updated 22 October 2026 with Square's Tax Mapping step and answers to common questions. VAT rules come from HMRC. Integration details come from Square, SumUp and Xero's own pages. We have not tested these integrations ourselves. This is not tax advice. If your figures are material, speak to an accountant.
Why mixed-rate sales go wrong
UK VAT is set per product, not per shop. A café can sell standard-rated, zero-rated and outside-the-scope items in a single order. Three things in the till-to-Xero chain decide whether that survives the trip:
- The VAT rate on each item in the till. Square applies VAT to "all current and future taxable items" or to items you select. Items you mark non-taxable get no VAT at all.
- Online orders. Square has separate VAT override settings for delivery, pickup, QR code and shipping orders. Your online shop can charge differently from your counter.
- How the sync posts to Xero. Square creates a daily sales summary invoice in Xero, or transaction-level detail if you choose. SumUp pushes the previous day's data at 4am. It can post by summary (VAT split), by item category or by item.
Link My Books sells a competing connector. It says that without configuration "standard, reduced, and zero-rated sales are lumped together". Treat that as one vendor's view, but it describes the failure exactly. One tax rate swallows the others.
The rules your till has to follow
These rules come from three HMRC sources: VAT Notice 709/1 on catering and takeaway food, its manual on tips and its policy on vouchers.
| Sale | VAT treatment |
|---|---|
| Hot takeaway food that meets any of HMRC's tests | Standard rate (20%) |
| Cold takeaway food | Zero rate, unless it is a type that is always standard-rated |
| Crisps, sweets and bottled water | Standard rate, even when cold |
| Hot takeaway drinks | Standard rate |
| Food or drink eaten on your premises, including your own seating | Standard rate |
| Tips freely given, or a genuinely optional service charge | Outside the scope of VAT |
| A compulsory service charge | Same VAT as the meal |
| Single-purpose voucher (VAT known when sold) | VAT due when the voucher is sold |
| Multi-purpose voucher | VAT due when it is redeemed |
HMRC has five hot food tests. Food is standard-rated if it was heated so it can be eaten hot or heated to order. The same applies if it was kept hot after heating. Heat-retaining packaging or advertising it as hot also count. Food that passes none of them stays zero-rated, even if it is still warm. Notice 709/1 also set a temporary reduced rate for certain children's meals from 25 June to 1 September 2026. Check any return that covers those dates.
Mapping each treatment in Xero
Xero names its tax rates slightly differently from one organisation to another, so check the list in your own Xero settings. What matters is that each treatment has its own rate:
| Treatment | Xero tax rate to map to |
|---|---|
| Standard rate | Your 20% sales rate |
| Reduced rate | Your 5% sales rate |
| Zero rate | Your zero-rated sales rate |
| Exempt | Your exempt sales rate |
| Outside the scope (tips) | Your no VAT or out-of-scope rate |
Zero-rated sales still belong on your VAT return as sales. They just carry no VAT. Tips that are freely given are not part of your sales for VAT at all.
How to fix it, step by step
- Pull a sales report by VAT rate from Square or SumUp for the quarter.
- Compare it with Xero. Run Xero's VAT report for the same dates. A gap shows which rate is being swallowed.
- Fix the items at source. In Square, VAT rates live under Settings > Account & Settings > Payments > VAT. Give every item the right rate, and mark zero-rated items correctly.
- Check online order settings. In Square, review the VAT overrides for delivery, pickup and shipping.
- Change the sync breakdown. In SumUp, choose a summary with a VAT split, or sync by item. In Square, check the tax rate on each line of the daily summary invoice.
- Check Square's Tax Mapping. A Square community answer marked as the solution points to a Tax Mapping section in Square's Xero integration settings. Use it to map each Square VAT rate to the matching Xero rate. Map zero-rated sales to your zero-rated rate, not No VAT. Zero-rated sales still count as sales on your VAT return.
- Correct past returns. HMRC lets you correct errors on your next return if the net value is £10,000 or less. Up to £50,000 is allowed if it is no more than 1% of your box 6 figure. Larger or deliberate errors must be reported to HMRC separately. The time limit is four years.
In 2023 accountants reported that SumUp's basic card reader app could not send data to Xero, and that the integration needed SumUp's POS system. Check your SumUp plan before you plan around the sync. A CSV export is the fallback.
Quick answers
- Does Square integrate with Xero? Yes. Square is listed on Xero's UK App Store. It posts a daily sales summary to Xero, or transaction-level detail if you choose.
- Does SumUp integrate with Xero? Yes. SumUp is on Xero's UK App Store too. It pushes the previous day's sales every night at 4am.
- Why don't my SumUp payouts match my takings? SumUp's help centre says it pays the net amount into your bank. That is your sales minus SumUp's fees. You then match each payout to a clearing account, not straight to your sales.
- How do I check my VAT is right? Compare a sales report by VAT rate from your till with Xero's VAT report for the same dates. Steps 1 and 2 above show how.
If you use the Flat Rate Scheme
You still charge customers the normal VAT rate for each item. You then pay HMRC a fixed percentage of your total VAT-inclusive turnover. HMRC says zero-rated and exempt sales are included in that turnover. So item-level rates still matter for your invoices, even though your return uses one percentage.
Sources, checked 20 October 2026:
- HMRC: catering, takeaway food and VAT (VAT Notice 709/1, updated 8 June 2026)
- HMRC manual VATSC06130: gratuities, tips and service charges
- HMRC: VAT treatment of vouchers
- HMRC: how to correct VAT errors (VAT Notice 700/45)
- HMRC: Flat Rate Scheme (VAT Notice 733)
- Square Support: create and manage your VAT settings
- Xero App Store: Square
- Xero blog: Square and Xero enhanced integration (UK)
- Xero App Store: SumUp Payments and POS
- AccountingWEB: SumUp and integration with Xero (2023)
- Link My Books: how to integrate Square with Xero (vendor article)
- Square Community: nominal codes Square uses to integrate with Xero (18 July 2025)
- SumUp Help Centre: connect your SumUp profile to QuickBooks
- VAT
- Xero
- Square
- SumUp
- Hospitality