Home › Guides

How to reconcile cash-accounting VAT through payments and credits

Determine scheme eligibility and the covered transaction population before choosing a payment-allocation setting. Cash timing for VAT does not automatically make the company's financial accounts cash based, and a feature called "unrealised VAT" does not establish eligibility.

This guide uses one invoice, two partial receipts, a credit against the unpaid balance and a final receipt. The example keeps revenue recognition separate from VAT realisation and reconciles each stage.

Use the cash VAT allocation worksheet alongside the actual invoice, bank receipts and VAT entries. The controls are recommendations; the authority's rules determine which transactions can follow them.

Confirm the scheme and excluded transactions

HMRC's Cash Accounting Scheme overview describes accounting for sales VAT when customers pay and purchase VAT when suppliers are paid. The business must meet the scheme's conditions rather than electing it separately for whichever invoices improve cash flow. GOV.UK, VAT Cash Accounting Scheme.

Notice 731 sets eligibility, transaction exclusions, records, part-payment and exit rules. Exclusions include specified transaction types and certain advance-invoice arrangements. Keep those cases outside the ordinary payment-based workflow unless the tax owner confirms the correct treatment. HMRC, VAT Notice 731.

The tax owner should document the joining date, covered population and monitoring responsibility. Avoid relying on a turnover number alone: the conditions concern more than size. Review the current rules again before a scheme transition or material business change.

Record the local accounting basis separately. A delivered sale can be revenue and a receivable in accrual accounts while the related output VAT remains in an unrealised tax account until qualifying payment occurs.

Define payment and allocation evidence

Identify the event that establishes payment under the relevant rules. Preserve bank references, receipt dates, allocations and any reversals. Do not confuse a customer promise, a payment-gateway authorisation or an unallocated bank import with a completed invoice application.

Business Central documents several unrealised-VAT behaviours. Its Percentage option allocates payments proportionally to VAT and invoice amount; other options behave differently. Select the option matching the approved requirement and demonstrate it in the actual release and localisation. Microsoft, unrealised VAT setup.

The application owner should show which accounts hold unrealised and realised tax, how partial applications transfer amounts and how an unapplied or reversed payment is treated. Record those results without assuming every product or localisation uses the same account structure.

Give customer-account corrections an approval trail. A cash receipt allocated to the wrong invoice can alter tax realisation even when the bank reconciliation itself is correct.

Establish the worked example

Assume an eligible UK business delivers a standard-rated sale and issues a GBP 1,200 invoice: GBP 1,000 net and GBP 200 VAT. Its accounting policy recognises the delivered sale immediately. The invoice and all payments fall within the approved scheme population.

There are no foreign currencies, discounts, fees, factoring, reverse-charge transactions or opening balances. The business has not remitted the example's VAT during the sequence. Receipts are allocated proportionally, and the later credit is approved to reduce the unpaid portion.

At issue, debit receivables 1,200, credit revenue 1,000 and credit unrealised VAT 200. The invoice balance is 1,200. Revenue is already 1,000 even though no payment has yet arrived.

This exercise shows accounting effects using generic account names. The actual Business Central entries and report classifications must be demonstrated in the selected configuration; it is not a tested menu walkthrough.

Apply two part payments

The first receipt is GBP 360, or 30% of the invoice. Its VAT content is 360 divided by six, or 60, because the example uses a 20% tax rate on the net amount. Transfer 60 from unrealised to realised VAT and clear 360 of receivables.

The remaining invoice balance is 840 and remaining unrealised VAT is 140. Revenue is unchanged. The receipt is not another sale.

The second receipt is 240. Its VAT content is 40. After applying it, cumulative cash is 600, receivables are 600, realised VAT is 100 and unrealised VAT is 100.

The isolated position balances: cash 600 plus receivables 600 equals revenue/profit contribution 1,000 plus total VAT liabilities of 200. The realised/unrealised distinction changes tax timing, not the total amount represented by the original invoice.

Keep the allocation denominator and amount applied with each event. A payment covering several invoices needs an allocation record before its tax components can be reconciled reliably.

Apply the credit to the unpaid balance

The seller approves a GBP 240 gross credit comprising 200 net and 40 VAT, applied entirely to the remaining unpaid amount. Debit revenue or the approved sales-return account 200, debit unrealised VAT 40 and credit receivables 240.

The remaining receivable is now 360. Net revenue is 800. Realised VAT remains 100 and unrealised VAT falls to 60. No cash is refunded in this scenario because the credit reduces an unpaid balance.

The customer pays the final 360. Transfer its VAT content of 60 to realised VAT and clear the receivable. Total cash is 960, net revenue is 800, realised VAT is 160 and both receivables and unrealised VAT are zero.

The final controls agree: original gross invoice 1,200 less credit 240 equals cash 960. Original VAT 200 less credit VAT 40 equals realised VAT 160. Cash 960 equals the 800 pretax profit contribution plus the 160 tax liability.

The credit's treatment is a stated assumption for this unpaid-balance case. A refund after full settlement, a mixed-rate invoice or a credit allocated across several payments requires its own approved calculation and test.

Recover from incorrect allocation or early tax realisation

Suppose the first GBP 360 receipt causes the entire GBP 200 VAT to become realised. The bank and receivable values can still be correct, but realised VAT is overstated by 140 at that stage.

Stop the affected tax-report release. The application owner compares the selected unrealised-VAT option and actual payment application to the approved proportional result. The controller authorises the supported correction; tax decides whether a return already submitted needs amendment.

Do not simply post a manual tax-only journal and leave the subledger wrong. Later payments may realise VAT again, reversing the apparent fix. Correct the source behaviour or maintain a clearly reconciled exception process until the supported remedy is deployed.

If a receipt was applied to the wrong invoice, reverse and reapply it using the product's controlled process. Check both affected invoices and their tax entries. A corrected customer statement alone does not establish that the VAT allocation was corrected.

Plan entry, exit and continuing review

Before joining or leaving the scheme, identify open invoices, payments, credits and transactions treated under normal rules. Give the transition population a boundary schedule so previously accounted-for VAT is not reported again and outstanding VAT is not omitted.

Monitor the approved eligibility conditions and business changes. New imports, different contract terms or a change in payment arrangements can introduce excluded or specialised cases even if turnover remains similar.

Finance owns invoice and credit accuracy, treasury owns payment evidence, the application owner owns the configured allocation, and tax owns scheme applicability and return acceptance. A named case owner should coordinate errors spanning those teams.

Before completion, confirm:

Retain the worksheet with transaction and VAT-entry exports. Use currency handling for foreign receipts and acceptance testing to preserve this case as a regression fixture.

Source verification date: 17 October 2026. The guide covers a bounded UK scheme example and does not generalise its rules to every country's cash-accounting arrangements.

Worksheet: Cash VAT payment allocation worksheet

Copy this worksheet for each case. It records decisions and evidence; it does not determine the tax or legal treatment.

Show the worksheet

Use with the cash VAT guide. Obtain an eligibility and transaction-scope decision before applying this worksheet.

Scheme and invoice

Receipt and credit trail

For each receipt record bank identity, date, allocation amount, gross balance before/after, realised tax and remaining unrealised tax. For a credit, record the original invoice link and whether it affects paid or unpaid consideration. Do not treat bank clearing as automatic approval of a tax allocation.

Rehearsal: gross 1,200 contains tax 200. Receipt360 realises60; receipt 240 realises40. Credit240 against unpaid consideration reduces net by200 and tax by40. Final receipt 360 realises60. Total cash 960 equals revenue 800 plus tax 160; receivable and unrealised tax are zero.

Reconciliation and sign-off

Rehearse realising all200 on the first360 receipt and identify the140 overstatement. Retain the correction and original document together.

Vendor documentation is cited only as an example of the level of evidence to ask for; it is not a recommendation or a ranking. This guide is general information, not tax or legal advice. Checked 2026-10-17.

Related: Glossary – abbreviations and terms used in these guides (SAF-T, Peppol, CTC, EN 16931, IFRS and more).

Page last updated: · Markdown version

Newsletter – monthly digest of mandate and ERP support changes. Subscribe on the home page.