Reconciling Delivery Payouts in QuickBooks: A UK Restaurant Guide

Most delivery-accounting guidance written for UK restaurants assumes you are on Xero. If your books are in QuickBooks, the principles are identical but the mechanics are not, and following a Xero walkthrough step by step will leave you looking for menu items that are named something else.

This guide covers the QuickBooks version: how to structure the accounts, how to record a platform payout so the numbers are right, and how to make the reconciliation actually tie out.

The problem is the same whichever software you use

A delivery platform pays you one net figure. That figure is what remains after the platform has taken its commission, added VAT to that commission, and netted off refunds and adjustments from the period.

If you record the deposit as sales — which is what happens by default when you categorise a bank transaction — three things go wrong at once:

• Turnover is understated. Your sales figure is net of commission, so it is lower than the gross revenue HMRC can rebuild from the platform's report (what the platform paid you plus the commission, fees and taxes it deducted).
• A cost disappears. Commission never enters the books, so you cannot see what the platforms cost you.
• Input VAT is lost. The VAT charged on the commission is recoverable if you are VAT-registered, and you have just thrown it away.

None of this is a QuickBooks problem. It is a data-shape problem: one deposit represents four or five distinct accounting events, and no accounting package can split it for you without being told how.

Setting up the accounts

In QuickBooks the structure lives in Settings → Chart of accounts. You want enough separation to see each platform's economics without creating a chart nobody maintains.

A workable minimum:

Keeping sales split by platform is what lets you answer "is Deliveroo actually worth it" later. Keeping commission out of a general "bank charges" or "sundry" account is what lets you see the total cost of delivery as a single number.

The equivalent structure for Xero, along with the reasoning behind the split, is in our guide to the restaurant chart of accounts — the account names differ but the shape carries across. Our chart-of-accounts template gives you a starting point to adapt into QuickBooks.

Recording a payout

The reliable method is a journal entry per payout period rather than categorising the bank deposit directly. In QuickBooks: + New → Journal entry.

Take a Deliveroo week with £3,200 of gross orders, £640 commission, £128 VAT on that commission, and £90 of refunds. The deposit is £2,342. This example assumes the whole £3,200 is standard-rated (hot food) so there is one output-VAT line to keep the illustration simple — if your menu is mixed-rate, split the sales and output-VAT lines by rate, the same way the chart-of-accounts template does.

The entry balances at £3,200 on each side — credits are net sales plus the output VAT on those sales, debits are the three deductions (commission, input VAT on the commission, refunds) plus the bank line — and the bank line equals the deposit that actually arrived. That last point is what makes the reconciliation work: when the deposit appears in your bank feed, it matches an existing journal line rather than needing to be categorised from scratch.

Two VAT lines matter here, not one. Output VAT (£533.33 on this week's standard-rated sales) is what you owe HMRC; input VAT on the commission (£128) is what you can reclaim. Recording the commission's VAT without also splitting out the output VAT on the sales line understates your VAT liability even though the journal still balances — the entry ties to the bank deposit either way, so a missing output-VAT line will not show up as a reconciliation discrepancy.

Making the bank reconciliation tie out

With journals posted per period, Transactions → Reconcile becomes a matching exercise rather than a categorisation exercise. The deposit either matches the journal's bank line or it does not, and if it does not, the difference is a real discrepancy worth investigating rather than a data-entry gap. Our payout reconciliation checker runs this comparison on a single statement and tells you whether it reconciles to within 0.5% of gross sales (its tolerance) and, if not, by how much and the most likely causes. A smaller gap is still reported as reconciling, so check the variance line too.

Three things commonly cause a mismatch:

Period boundaries. The platform's reporting week and the date the money lands are not the same. Post the journal against the payout period, and expect the deposit a few days later. Adjustments from an earlier period. Corrections often appear in a later payout without being flagged. If a week is short by an odd amount, check the previous period's statement. Refunds recorded twice. If refunds are already netted off the gross figure on the statement, adding a separate refund line double-counts them. Read the statement carefully — the platforms differ on this.

The VAT position

Two separate questions, and conflating them is the most common source of error.

VAT on the commission. The platform's service fee is standard-rated. For a VAT-registered restaurant that VAT is input tax and recoverable in full — zero-rated sales are still taxable supplies, so they do not restrict recovery in the way exempt supplies would. What a zero-rated share of sales does affect is the output-VAT split shown above, which is why it belongs on its own journal line rather than buried in the commission figure. Our VAT on delivery commissions guide works through the apportionment. VAT on the food. Determined by what you sell and how it is supplied. HMRC's guidance states that "hot takeaway food and drink that meets certain tests set out below is standard-rated," while "cold takeaway food and drink is zero-rated, as long as it's not of a type that's always standard-rated." Delivery can matter for cold items: the same guidance lists "delivery of cooked ready-to-eat food or meals (with or without crockery or cutlery)" among its obvious examples of catering, which is standard-rated whether hot or cold, and HMRC's VAT Food manual (VFOOD4140) quotes the High Court: "Whether it is delivered, or not, by the supplier may often be a highly material factor." Note the words "by the supplier": where the platform's own courier delivers the order rather than you, that is one more reason the treatment depends on the facts. So cold items in a delivered meal are not automatically zero-rated; agree the treatment with your accountant.

If your menu spans both, your delivery sales accounts need to reflect the split, or your VAT return will be wrong in a way that is tedious to unpick later. Our guide to restaurant VAT in the delivery era covers the mixed-rate case.

Making Tax Digital

QuickBooks (Intuit) appears on HMRC's list of MTD-compatible software, which names the vendor entry rather than a specific edition. That resolves the filing mechanics but not the data quality underneath. Products and versions move on and off the list, so check it yourself before relying on it — the searchable list is a separate HMRC service from the guidance page. HMRC's position is unambiguous: "You must now use compatible software to keep your VAT records and file your VAT Returns."

Compatible software submitting incorrect figures is still incorrect figures. If your delivery sales are recorded net of commission, MTD compliance simply means you are filing the wrong numbers through an approved channel. Our guide to Making Tax Digital for restaurants covers the requirements in full.

The same applies to the platform reporting rules. Under the Platform Operators (Due Diligence and Reporting Requirements) Regulations 2023, operators must "collect information about sellers", "verify the information collected", and "identify reportable sellers in respect of each reportable period" (regulation 3). Separately, regulation 4 imposes the report itself: a reporting platform operator "must, for each reportable period, make a report to HMRC" on or before "the 31st January following the end" of that period. HMRC therefore holds what each platform paid you and, reported separately, the fees, commissions and taxes it deducted, which is enough to rebuild your gross platform revenue. See our guide to HMRC's digital platform reporting rules for what that means for your return.

QuickBooks or Xero?

Both handle this properly if the accounts and journals are set up correctly, and neither does it for you out of the box. The honest answer is that the constraint is rarely the software — it is whether someone builds the chart of accounts sensibly and posts the journals consistently every week.

If you are still choosing, our guide to restaurant accounting software sets out the types of package to choose between, and our restaurant bookkeeping software guide compares how the main UK packages handle delivery-specific requirements.

Key takeaways

• Never categorise a platform deposit straight to sales. One deposit is four or five accounting events.
• Split delivery sales by platform in the chart of accounts, and keep commission in its own cost-of-sales account.
• Post a journal per payout period, with the bank line equal to the actual deposit, then match it in Reconcile.
• The VAT-on-commission line is recoverable input tax for VAT-registered businesses. It is the line most often omitted.
• MTD compatibility governs how you file, not whether the underlying numbers are right.

---

Building the journal by hand each week — for each platform, with the VAT split correct on every line — is the part that does not scale. That is the gap PayoutLedger is being built to close: upload each platform's report, get VAT-correct journal entries, and reconcile every payout to the bank deposit. Join the waitlist for early access.

Sources

• GOV.UK — Find software compatible with Making Tax Digital for VAT
• HMRC — Search the MTD-compatible software list (the list itself)
• HMRC — Catering, takeaway food and VAT (Notice 709/1)
• HMRC — VAT Food manual VFOOD4140: excepted items: catering: what is catering?
• Platform Operators (Due Diligence and Reporting Requirements) Regulations 2023, regulation 3 (due diligence and record-keeping)
• Platform Operators (Due Diligence and Reporting Requirements) Regulations 2023, regulation 4 (reporting of information to HMRC)
• VAT Notice 706: partial exemption
• HMRC — IEIM901740: what platforms report as consideration (net of fees, which are reported separately)