Written by: JJ Tan, Founder, Jelly | Last updated: 22 June 2026
Key Takeaways for UK Hospitality Teams
- Manual Square-to-Xero reconciliation wastes 10–20 hours monthly and hides true dish profitability for UK hospitality operators.
- Amaka automates daily sales, VAT, fees and refunds into Xero, so HMRC-compliant bank reconciliation happens without spreadsheets.
- Correct VAT code mapping in Amaka is essential for mixed-rate menus to avoid over- or under-reporting tax on hot food, alcohol and takeaway items.
- Adding Jelly on top of the sync delivers real-time gross-profit visibility, Price Alerts and automated invoice scanning from live Square sales data.
- Ready to add the profitability layer? See how Jelly works with your Square data.
Pre-Setup Checklist for Square, Xero and Amaka
Confirm the following before starting the Amaka setup:
- Square admin access, as the account owner or with admin permissions to authorise third-party OAuth connections.
- Xero organisation with an active subscription, chart of accounts, bank feeds and VAT rates already configured.
- Amaka account, either free or paid, linked to the same email used for Square.
- VAT rates in Xero including standard rate (20%), reduced rate (5%) and zero rate, especially for mixed-rated items such as hot food, cold food and alcohol.
Roles: The owner or finance manager should own the Xero account mapping and VAT code configuration. The head chef or operations manager should support menu category mapping in Step 4, since they know which Square item categories match each tax treatment.
Why Accurate Square–Xero Mapping Protects HMRC Compliance
Square supports connections to third-party accounting tools including Xero so payment processing fits into existing financial workflows. However, Square does not automatically reconcile its fees, refunds or taxes into Xero, so a separate integration layer must break down net bank deposits into gross sales, VAT, fees and payouts for accurate matching.
This process matters for HMRC compliance. Square deposits net payouts into the seller’s bank account, so the figure hitting your bank account is never the gross sales figure. Without an integration that reconstructs those components, your Xero bank reconciliation will not match your VAT return, and the gap compounds every month.
For hospitality businesses selling mixed VAT-rated items, Square does not reliably separate VAT rates within net payouts. The integration must therefore apply VAT product grouping at the accounting stage. Amaka handles this separation automatically during the mapping steps below.
Step-by-Step: 7-Step Square–Xero Setup via Amaka
The following seven steps usually take 30–45 minutes and create a fully automated daily sync between Square and Xero. Once this foundation is in place, operators can add real-time profitability tracking through tools like Jelly, covered later in the Advanced Tips section.
Step 1 — Create your Amaka account and connect Square via OAuth
Log in to Amaka and select Square as your data source. Amaka uses Xero’s secure OAuth flow, so no API keys or developer involvement are required. Click “Connect Square”, sign in with your Square credentials and grant the requested permissions. Success criterion: Amaka dashboard shows Square as “Connected” with your location name visible.
Step 2 — Connect your Xero organisation
Within Amaka, click “Connect Xero” and authorise access to your Xero organisation. Amaka imports your chart of accounts, existing tax codes and tracking categories. Success criterion: your Xero account names appear in the Amaka mapping interface.
Step 3 — Map Square sales categories to Xero revenue accounts
Amaka lists every Square item category such as Food, Drinks, Desserts and Delivery. Map each category to the correct Xero revenue account. For hospitality operators, set up separate revenue accounts in Xero for food sales, alcohol sales and non-alcoholic beverages before this step to keep reporting clean. Success criterion: every Square category has a corresponding Xero account selected.
Step 4 — Assign VAT tax codes to each category
This step has the greatest impact on HMRC compliance. Assign the correct Xero VAT tax code to each mapped category: standard rate (20%) for hot food and alcohol, reduced rate (5%) where applicable and zero rate for cold takeaway food. UK VAT registration is required once taxable turnover exceeds £90,000 in any rolling 12-month period, so your Xero VAT scheme must match your HMRC registration. Success criterion: each category shows a VAT code, and no category remains as “No VAT” unless genuinely zero-rated.
Step 5 — Configure Square fee handling
In Amaka’s fee settings, map Square processing fees to a dedicated Xero expense account such as “Payment Processing Fees”. Square issues monthly fee invoices via the Square Dashboard that itemise processing fees and any VAT applied, and Amaka imports these automatically when fee sync is enabled. Set the VAT treatment for fees, which are typically standard-rated for VAT purposes. Success criterion: a test fee transaction appears in Xero under the correct expense account with the correct tax code.
Step 6 — Set the daily summary schedule
Configure Amaka to post a daily sales summary to Xero at a consistent time, typically 2:00 AM after the previous day’s trading is complete. Choose “Daily Summary” rather than individual transactions unless your accountant specifically requires line-level posting. Summaries keep bank reconciliation simple and reduce Xero clutter. Success criterion: Amaka shows a scheduled sync time and the next run date.
Step 7 — Run the first sync and verify bank reconciliation
Trigger a manual sync for the previous trading day. In Xero, open Bank Reconciliation and confirm that the Amaka-posted sales invoice matches the net Square payout in your bank feed, with the difference explained by the fee entry. Check that VAT figures on the sales invoice align with the figures in your Square dashboard. Success criterion: bank reconciliation matches to the penny, VAT figures reconcile and no unmatched items remain.
Monthly Routine: Recording Square Fees in Xero
Use this checklist each month to keep Square fees recorded correctly:
- Download the monthly fee invoice from Square Dashboard (Accounts > Fee Invoices).
- Confirm Amaka has imported the fee total automatically; if not, create a manual bill in Xero.
- Post fees to a dedicated expense account such as “Square Processing Fees”, and avoid netting fees against sales revenue.
- Apply the correct VAT tax code to the fee line, usually standard rate 20% when Square has charged VAT on the fee.
- Match the fee bill against the net payout in your Xero bank reconciliation.
- Retain the Square fee invoice as a VAT record for HMRC purposes.
Common Square–Xero Issues and Fixes
Incorrect VAT tax codes on mixed-rate items. The most frequent error is assigning a single VAT rate to all Square sales. Hospitality businesses sell items at multiple rates. If Amaka maps all categories to “20% (VAT on Income)” by default, cold takeaway food will be over-reported for VAT. Fix this by revisiting Step 4 and assigning zero-rate or reduced-rate codes to the relevant categories before the next sync.
Duplicate payouts in Xero. Duplicate entries usually appear when both Amaka and a manual CSV import post the same day’s sales. Disable any manual import process as soon as Amaka goes live. Check Xero’s bank reconciliation for duplicate draft invoices covering the same date range and delete the manual entries.
Missing refunds. Refunds processed in Square must appear as credit notes in Xero. Confirm that Amaka’s refund sync is enabled in settings. If refunds are missing from a historical period, run a manual sync for that date range within Amaka.
Fee invoices not matching bank deposits. Because Square deposits only the net amount, the bank deposit will never equal gross sales. The reconciliation equation is: Gross Sales − Fees − Refunds = Net Payout. If this does not balance, check that fee mapping in Step 5 is active and that refund sync is enabled.
How to Measure a Successful Integration
A correctly configured Square–Xero integration via Amaka should deliver the following within the first 30 days:
Time saved: the automation should deliver the 10–20 hour monthly reduction mentioned earlier. This saving only matters when the underlying data is accurate, which makes the next metrics essential.
Reconciliation accuracy: bank reconciliation should match at 99% or above, with no unexplained variances. This level depends on correct VAT coding and complete fee capture.
VAT accuracy: VAT return figures in Xero should match Square’s tax reports without manual adjustment. Any mismatch here usually indicates misconfigured VAT codes in Step 4 and will flow through into HMRC reporting errors.
Fee visibility: processing fees must appear as a discrete expense line rather than being netted against revenue. This separation supports accurate cost-of-sales reporting and margin analysis.
If reconciliation accuracy falls below 99%, the most likely causes are misconfigured VAT codes, missing refund sync or fee netting. Revisit Steps 4 and 5.
Advanced Tips: Adding Jelly for Real-Time Profitability
Accurate books create a solid base, yet they do not tell a head chef whether the lamb shank still makes money after last week’s supplier price increase. That level of visibility requires a profitability layer between the POS and the accounting system.
Jelly connects directly to Square via a real-time API and pulls item-level sales data as each transaction completes. The head chef maps each Square menu item to a Jelly dish recipe built from scanned supplier invoices. From that point, every sale updates the live gross profit margin for that dish automatically. When a supplier increases the price of an ingredient, Jelly’s Price Alert feature flags the change quickly so operators can negotiate credits, switch suppliers or reprice the dish before the margin erodes.
Jelly’s Flash Report provides a daily, weekly or monthly view of gross profit calculated from live invoice costs and Square sales data. The Sales Mix report highlights which dishes are most popular and most profitable, which supports data-driven menu engineering. Jelly also scans every supplier invoice line by line via photo or email and pushes digitised invoices directly into Xero with one click, which can reduce bookkeeping time by 90%.
Jelly works alongside Square and other POS systems, and onboarding takes one week. Pricing is a flat £129 per site per month with no per-user charges. Operators using Jelly often report reductions in food costs and improvements in gross profit.
Connect Jelly to your Square–Xero setup in under a week.
Frequently Asked Questions
Does Xero integrate with Square?
Yes. Square and Xero are active integration partners, and Square names Xero as a supported accounting tool within its partner ecosystem. The integration is not a direct native connection inside either platform’s core product. It requires an intermediary tool such as Amaka to handle data mapping, VAT code assignment and daily sync scheduling. Once configured, the integration posts daily sales summaries, fee data and refunds to Xero automatically without manual CSV exports or data entry.
How does Square work with Xero for UK VAT and fees?
Square calculates VAT at checkout based on the rates the operator configures in the Square Dashboard, but it does not determine which VAT rate legally applies or file VAT returns with HMRC. That responsibility sits with the operator. Square deposits net payouts into the seller’s bank account. An integration tool such as Amaka reconstructs those components, including gross sales, VAT by rate, fees and refunds, and posts them to the correct Xero accounts with the correct tax codes. For hospitality businesses with mixed VAT-rated menus, the VAT category mapping step in Amaka is critical, so each Square item category must receive the correct Xero VAT code before the first sync runs.
What are typical Square Xero integration fees?
The cost of the integration depends on the intermediary tool used. Amaka offers tiered pricing based on transaction volume, with plans suitable for independent hospitality operators. This cost is separate from Square’s standard card processing fees, which are deducted from payouts and must be recorded as an expense in Xero. Jelly, which sits on top of the Square–Xero workflow to deliver real-time profitability, charges a flat £129 per site per month with no variable or per-user fees.
Can I add real-time menu profitability after the sync is set up?
Yes. This step works best once the Square–Xero sync runs accurately. Jelly connects to Square via a separate real-time API integration that pulls item-level sales data independently of the Xero sync. The two integrations run in parallel. Amaka handles the accounting and reconciliation workflow into Xero, while Jelly uses the same Square sales data to calculate live dish-level gross profit margins, flag ingredient price changes and generate daily Flash Reports. Setting up Jelly’s Square integration takes about five minutes and does not require changes to the existing Amaka configuration. Onboarding to full profitability visibility typically takes one week.
Conclusion: Clean Books First, Clear Margins Next
The Square–Xero integration via Amaka solves the reconciliation problem. Daily sales, VAT by rate, processing fees and refunds flow into Xero automatically, HMRC compliance stays on track and bank reconciliation closes cleanly. That combination removes a large block of monthly admin and reduces the risk of VAT misreporting.
Margin visibility remains a separate challenge. Knowing that yesterday’s sales were £4,200 helps, but knowing that the beef burger delivered 58% gross profit while the fish special delivered 31%, and that the fish cost increased 12% last Tuesday, protects the business. Jelly adds that layer through real-time dish costing, automated invoice scanning, Price Alerts and Sales Mix reporting, all connected to Square and pushing clean data into Xero. Pricing stays flat at £129 per site, with one week to value in most cases.