How to Reconcile Delivery Platform Payouts in Xero: A Step-by-Step Guide

Reconciling delivery platform payouts in Xero is one of the most time-consuming tasks for UK restaurant owners. Each platform pays you a net lump sum that bundles hundreds of orders, commissions, refunds, and VAT adjustments into a single bank deposit. Matching that deposit against your actual sales requires order-level detail that the bank statement does not provide.

This guide walks through the manual reconciliation process for all three major UK delivery platforms -- Deliveroo, Uber Eats, and Just Eat -- and explains the Xero journal entries you need to keep your books accurate.

Why delivery platform reconciliation is different from normal sales

When a customer pays at your till, the transaction is straightforward: sale amount, payment method, VAT. The money arrives in your bank account (via your card processor) and you can match it directly.

Delivery platform payouts work differently:

• Multiple deductions before payment: Commission, VAT on commission, service fees, refunds, marketing charges, and tablet rental are all subtracted before the payout reaches your bank
• Delayed payment: Deliveroo pays weekly, Uber Eats on varying schedules, Just Eat on its own cycle -- none align with your accounting period
• Net lump sums: You receive one payment covering dozens or hundreds of orders, with no order-level breakdown in the bank feed
• Cross-period orders: An order placed on Friday might be included in the following week's payout, creating timing differences

Step 1: Download platform payout reports

Before you can reconcile, you need the raw data from each platform:

• Deliveroo: Log into Deliveroo Partner Hub. Navigate to Payments, select the relevant period, and export the CSV
• Uber Eats: Log into Uber Eats Manager. Go to Payments, download the payment statement for the period
• Just Eat: Log into Just Eat Partner Centre. Access Payment Reports and download the detailed breakdown

Each CSV contains order-level data: order value, commission charged, refunds deducted, and the net amount included in the payout. You need all of this to create accurate journal entries.

Step 2: Set up Xero tracking codes

Before entering your first platform journal, set up dedicated tracking in Xero. You need separate nominal codes (or tracking categories) for:

• Gross platform sales -- the total order value before any deductions (a revenue account)
• Commission expense -- the commission charged by each platform (a cost of sales account)
• VAT on commission (input) -- the VAT charged on the commission (recoverable if VAT-registered)
• Refunds -- customer refunds deducted from your payout
• Platform fees -- service charges, marketing costs, tablet rental

Using a single "Deliveroo income" line captures none of this detail. If HMRC queries your records, a single line entry gives you nothing to substantiate your figures against the order-level data HMRC already has from the platform.

Step 3: Create the journal entries

For each platform payout, create a manual journal in Xero with the following lines:

Example journal for a Deliveroo weekly payout of £2,589: The journal balances: £2,589 + £1,000 + £200 + £106 + £105 = £4,000.

Step 4: Handle VAT on commissions correctly

This is where most restaurants and generalist accountants make errors. The commission charged by delivery platforms is a service subject to VAT at the standard 20% rate. The VAT on this commission is input tax -- you can reclaim it if you are VAT-registered.

However, if your restaurant sells both standard-rated items (hot food, soft drinks) and zero-rated items (cold takeaway food, certain bakery items), the VAT reclaim on commission needs to reflect your actual sales split.

The common mistake: Coding the entire commission VAT as T1 (standard-rated input) when a proportion of your sales are zero-rated. This overclaims input VAT. The correct approach: Calculate the proportion of standard-rated vs zero-rated sales for the period, and split the commission VAT input accordingly. If 80% of your sales are standard-rated and 20% are zero-rated, only 80% of the commission VAT is reclaimable as input tax under the partial exemption rules.

Check with your accountant on the specific apportionment method that applies to your business. HMRC's partial exemption guidance covers the rules in detail.

Step 5: Match payouts against bank deposits

Once the journal is entered, go to Xero's bank reconciliation screen. The Deliveroo payout should appear as an incoming deposit. Match it against the journal you just created.

If the deposit amount does not match your calculated payout exactly, common reasons include:

• Timing differences: Orders at the edge of the payout period may be included or excluded
• Adjustments: Platform corrections from previous periods
• Currency rounding: Minor rounding differences on individual orders

For any discrepancy over £5, investigate before entering an adjusting line. Small, unexplained adjustments compound over time.

Step 6: Verify against HMRC's data

Since January 2024, delivery platforms report your revenue directly to HMRC under the Digital Platform Reporting Rules. Your gross sales figures in Xero need to match what HMRC has received from each platform.

The best way to check: compare your Xero sales account totals for each platform against the gross order values in the platform CSVs for the same period. Any mismatch means either your journal entries are wrong or you have missed a payout.

How long this takes (honestly)

For a restaurant on three platforms doing moderate volumes, manual reconciliation takes approximately:

• Downloading CSVs: 10-15 minutes (logging into 3 dashboards, finding the right reports)
• Cross-referencing orders: 30-60 minutes per platform (checking refunds, verifying commission rates)
• Creating Xero journals: 15-20 minutes per platform (data entry, VAT coding)
• Bank matching: 10 minutes
• Total: 2-3 hours per week

Over a year, that is 100-150 hours of bookkeeping. At accountant rates (£150-400/month), you are paying £1,800-4,800 annually for this single task.

A faster way

PayoutLedger automates this entire workflow: upload your platform CSVs, get VAT-correct journal entries, and push them into Xero in minutes. Join the waitlist to be first to try it.

---

This guide covers delivery platform reconciliation for UK VAT-registered restaurants using Xero. The same principles apply to QuickBooks and Sage, though the specific journal entry process differs. This is not financial or tax advice. Consult a qualified accountant for guidance on your specific VAT position.

Sources

• Platform Operators (Due Diligence and Reporting Requirements) Regulations 2023
• HMRC VAT partial exemption guidance