A free UK VAT Partial Exemption & CGS Calculator in Excel
Standard Method Q1-Q4 & Reg. 107 Annual Adjustment, Regs. 107A-107C SMO vs. 4-Sector PESM, De Minimis & Simplified Tests 1 & 2, and 10-Interval Capital Goods Scheme Disposal Planner.
Pre-loaded with Thamesbridge Property & Finance Group plc (£17,200,000 taxable, £10,400,000 exempt, £1,160,000 residual VAT) and Aldgate Wharf Tower (£4,000,000 ex-VAT, £800,000 VAT). Overwrite any blue input cell to test your own UK VAT group, SMO trigger, de minimis headroom, or property disposal swing.
Get the Excel calculator
One Excel workbook, no macros, nothing locked. Enter your email address and the download opens immediately, along with the other free practitioner models.
You join the reader list: occasional notes when new models or handbooks release. Unsubscribe in one click. How your address is used.
The book behind this calculator
The UK VAT Partial Exemption Handbook walks through every statutory rule in VATA 1994 and SI 1995/2518 Parts XIV and XV (including the 29 July 2026 CGS reforms) with complete worked schedules on Thamesbridge Group, TFML, and Aldgate Wharf Tower.
SMO_vs_PESM: Automated Regs. 107A-107C SMO trigger (> £50,000 or > 50% and >= £25,000 -> -£78,300 clawback) compared live against a 4-sector PESM (£773,752 residual recovery, +£121,252 annual gain).
De_Minimis_Tests: Simplified Test 1, Simplified Test 2, and Full Reg. 106 Test across Q1-Q4 and annual longer period for TFML (reclaiming +£2,444.00).
CGS_10_Year_Model: 10-interval CGS schedule on Aldgate Wharf Tower comparing Interval 6 Exempt Disposal (-£280,000), Opted Taxable Disposal (+£120,000, £400,000 swing), and Distressed Cap (+£48,000).
Controls: Seven 100% dynamic cross-sheet accounting identity checks (CTRL-01 to CTRL-07) confirming 0 errors even after user edits.