Accountio / Templates / Fixed assets / Capital allowances schedule

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 teams
$15
In the pack
Fixed assets pack
Files
4, Word and Excel
Buy the pack · $15
US library · 52 packs

Get this pack and 51 more for $79

Fixed assets · this packBookkeeping and advisory lettersAudit and AUP lettersBook-to-tax reconciliationCompilation and review lettersIndependent contractorsCPA verification letters1040 checklistsIRS notices+ 43 more
$79$69889% off
Buy the US library · $79

Want every pack, for every region? Global library, 110 packs, $99

What the schedule looks like

Capital allowances schedule template
What the schedule coversSheet or line in the schedule
The period and the claimant
✓
PeriodPeriod dates, whether the claimant is a company and the months in the period
Annual investment allowance for the period
✓
AIA available for the period£1 million a year, pro-rated for a short or long period and for this company's share within a group
The main pool rate
✓
Main pool rate for the period (hybrid if it spans the change)14% from April 2026, 18% before, and a time-apportioned rate rounded up to two decimal places for a period that spans the change
Pool balances from last period
✓
Main pool brought forward, Special rate pool brought forwardTaken from last period's computation
Each item bought
✓
AdditionsDate, description, pool, car, new and unused, and cost excluding recoverable VAT, with room for 100 items
The allowance claimed on each item
✓
ClaimAIA, full expensing, 50% first-year allowance, 40% first-year allowance or no first-year claim
Claims an item doesn't qualify for
✓
CheckFlags cars, used items, full expensing outside a company, 40% claims before 2026 and dates outside the period
Items sold or scrapped
✓
DisposalsProceeds, original cost and disposal value capped at cost, with room for 50 items
Balancing charges on items with full expensing or the 50% allowance
✓
Balancing charge nowThe whole disposal value for full expensing, half for the 50% allowance
The main and special rate pools
✓
ComputationBrought forward, additions, disposal values, writing down allowance, first-year balances and carried forward
Total allowances
✓
Total allowances, Net allowancesAIA, full expensing, first-year and writing down allowances, less balancing charges

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

  1. Fill in the Period sheet. Period dates, whether the claimant is a company, its share of the AIA and the pool balances brought forward.
  2. 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.
  3. 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.
  4. Enter the disposals. Say what relief was claimed on each item. Balancing charges on full expensing and 50% items are worked out straight away.
  5. 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

Fixed asset registerCapitalisation policy

See the whole 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.