Capital allowances schedule in Excel with the 2026 rates
Work out a period's plant and machinery allowances from the additions and disposals, with each claim checked against the rules and the pools carried forward. This capital allowances schedule is one Excel workbook with the April 2026 main rate change and the hybrid rate built in.
Finance teamsGet this pack and 51 more for $79
Want every pack, for every region? Global library, 110 packs, $99
What the schedule looks like

When you need it
A capital allowances schedule works out the tax relief on plant and machinery for one accounting period. HMRC says a limited company must include a separate capital allowances calculation with its Company Tax Return. Use this one when:
- You are preparing a corporation tax computation for a period that spans 1 April 2026
- A business bought equipment, vans or machinery and needs to choose between the AIA, full expensing and the 40% allowance
- A sole trader or partnership claims allowances on its tax return
- Assets were sold or scrapped and you need the disposal values and any balancing charge
How to use the capital allowances schedule
- Fill in the Period sheet. Period dates, whether the claimant is a company, its share of the AIA and the pool balances brought forward.
- Enter each addition. One row per item, at cost excluding recoverable VAT. Choose the pool and the claim. Leave AIA claimed blank to claim the AIA on the full cost.
- Clear every Check. The Check column flags any claim the item doesn't qualify for, such as the AIA on a car or full expensing on a used item.
- Enter the disposals. Say what relief was claimed on each item. Balancing charges on full expensing and 50% items are worked out straight away.
- Carry the pools forward. Take the total allowances to the tax computation and the carried forward balances to next period's Period sheet.
Questions
What is a capital allowances schedule?
The working that turns a period's plant and machinery additions and disposals into tax relief. It shows the allowance claimed on each item, the main and special rate pools from brought forward to carried forward, and the total allowances and balancing charges for the tax return.
What is the annual investment allowance?
£1 million a year, for most plant and machinery other than cars. For a period of more or less than 12 months it is pro-rated, so a 9-month period gets £750,000. Two or more companies controlled by the same person get one AIA between them and choose how to share it.
What is the main pool rate from April 2026?
14%, down from 18%. The change took effect on 1 April 2026 for corporation tax and 6 April 2026 for income tax. A period that includes the change date uses a hybrid rate. The special rate pool stays at 6%.
What is the difference between full expensing and the AIA?
Full expensing gives companies 100% relief on new and unused main rate plant and machinery, not cars. The AIA is open to sole traders and partnerships too, covers special rate items and items bought used, and is capped at £1 million a year. The schedule uses the AIA first on special rate items, which otherwise get only 6% a year.
What is the 40% first-year allowance?
A 40% allowance on new and unused main rate plant and machinery bought on or after 1 January 2026, not cars. Unlike full expensing, unincorporated businesses can claim it. The other 60% of the cost goes into the main pool.
What goes in the special rate pool?
Integral features such as lifts, heating, air conditioning, hot and cold water and electrical systems, long-life assets, solar panels, thermal insulation added to a building, and cars above the CO2 threshold.
Also in the fixed assets pack
Who it's for
Accountants and finance teams preparing UK corporation tax and self assessment computations for businesses that buy plant and machinery.
Last checked
Checked against HMRC's capital allowances rules, including the April 2026 main rate change and the 40% first-year allowance, in November 2026.
