Free Excel Template · UK Corporate Tax
CTA 2009 Part 13 & Finance Act 2024: 20% Merged RDEC 7-Step Discharge, 30% ERIS Intensity Test, s. 1138A Overseas Filter, and PAYE/NIC Cap
Unlocked Excel workbook (18 KB), zero macros, zero circular references, verified with 0 formula errors. Pre-loaded with Northbridge Photonics Ltd, Fenland BioCompute Ltd, and Clyde Robotics Systems Ltd.
| Tab Name | Statutory Scope | Pre-Loaded Worked Entity |
|---|---|---|
| Merged_RDEC_7Steps | Qualifying R&D cost builder + CTA 2009 s. 1042I 7-step discharge (exact s. 1042K(2) & (5) Step 2) | Northbridge Photonics Ltd (A1: £435,000 net; A2: £435,000 cash + £50,000 CF) |
| ERIS_vs_RDEC | s. 1045ZA 30% intensity ratio, s. 1044(2A) pre-R&D loss gate, ERIS 86%/14.5% vs. Merged RDEC, Year 2 grace | Fenland BioCompute Ltd (34.00% intensity: £229,245 ERIS vs. £137,700 RDEC) |
| PAYE_Cap_Overseas | s. 1138A overseas bar, s. 1133 contracted-out exclusion, 15% IP cliff (s. 1112E), PAYE/NIC cap, IAS 20 P&L | Clyde Robotics Systems Ltd (19.05% connected EPW, £110,000 cap, £26,080 CF) |
| Controls | 10 automated 100% dynamic statutory invariant & zero-variance reconciliation checks | All 3 entities (ALL PASS) |
Full handbook: The UK R&D Tax Relief Handbook
Guide 1: UK Merged RDEC 20% Seven-Step Calculation: Worked Example
Guide 2: UK ERIS 30% R&D Intensity Test and 14.5% Payable Credit
Guide 3: UK R&D Contracted-Out Rules, Overseas Restrictions, and PAYE/NIC Cap