EN

Calculate a Depreciation Schedule (Straight-Line/Reducing)

Depreciation spreads the cost of a fixed asset (machinery, a vehicle, equipment…) over its useful life as yearly charges. Two methods are commonly used for book and management accounts: straight-line, with a constant yearly charge, and reducing balance, with higher charges early on.

Enter the asset's cost, useful life and in-service date: the calculator builds both schedules, year by year, with the pro-rated first accounting period.

Simplified: no residual value, accounting year matches the calendar year, proration in whole months. This tool is for book/management depreciation, not UK tax relief: HMRC capital allowances use a structurally different system — Writing Down Allowances on fixed asset "pools" at 14 % (main pool) or 6 % (special rate pool) from April 2026, applied indefinitely rather than over a chosen useful life. Check capital allowances separately for tax purposes.

The asset to depreciate

Cost and useful life

Applied to the straight-line rate. Common convention: ×2 (double-declining balance).

For the first accounting period's proration.

yearsNBVstraight-linereducing balance
Illustrative example (12,000 €, 5 years, in service in March). The diagram redraws with the figures entered after the calculation.

Several UK accounting and tax acronyms come up below — each flagged with an asterisk and explained in the glossary at the end of the page.

Straight-line or reducing balance: which asset, which story

Same cost, two clocks. Straight-line carves the amount into equal yearly slices — a desk, a building, anything whose usefulness does not fall off a cliff. Reducing balance takes a fixed percentage of whatever carrying amount is left. Year one is heavy, later years thin. That fits a laptop, a van, a machine that is half obsolete before it is half worn out.

Faster charges up front also mean faster tax relief if the tax system follows the books. In the UK it often does not: the accounts can show one pattern while capital allowances follow another. The two columns on this page are the accounting story. They help make cash-flow timing visible inside the P&L*, not a CT600 line.

Book depreciation and capital allowances are not the same machine

FRS 102* or IFRS* ask what the asset consumed this year. The Capital Allowances Act asks what HMRC will allow as a deduction. A lorry can be depreciated straight-line over six years in the accounts while still claiming pool allowances — or the Annual Investment Allowance — on the tax computation. The gap sits in deferred tax, not in this table.

  • Book depreciation — policy, useful life, residual value, a true and fair view.
  • Capital allowances — statute, pools, first-year reliefs, no residual value in the usual WDA* arithmetic.

Mixing the two is the classic spreadsheet error: taking the accounts charge and dropping it into the tax return. This calculator does the books only; allowances need their own working.

Writing-down allowances: main pool and special-rate pool

Most plant goes into a pool, with no need to track each asset individually for tax once it has gone in. The pool balance gets a writing-down allowance each period.

  • Main pool — 18% WDA on the reducing balance: general plant, computers, most commercial vehicles.
  • Special-rate pool — 6% WDA: long-life assets (over 25 years), integral features (lifts, air-con), thermal insulation.

Additions go in, disposal proceeds come out (capped at cost). If a pool drops below £1,000 the small-pools allowance can often wipe it out entirely. Cars have their own rules and usually miss the AIA*. None of that is what the reducing-balance column here is doing: here the multiplier is an accounting declining-balance, applied asset by asset, so it can be compared with straight-line on the same useful life.

Annual Investment Allowance: 100% in the year of spend

The AIA lets most businesses write off qualifying plant and machinery (not cars) in full, in the year of purchase, up to a cap. That cap is £1 million a year and has been set on a lasting basis. Spend under the cap, the whole lot can hit taxable profit at once. Spend over it, the excess goes into the right pool and crawls out via WDAs.

Connected-party buys and assets with a private-use slice are fussy. Groups share one AIA. It is a cash-flow tool for SMEs, not a reason to change the depreciation method in the statutory accounts. This schedule can still run straight-line for the board pack while AIA gets claimed separately on the tax computation.

A residual value that is not zero

Where a scrap or second-hand cheque is expected at the end, that amount should not be depreciated. Straight-line subtracts it from the base:

Depreciable amount = Cost − Residual value

Annual charge = (Cost − Residual value) / Useful life

Reducing balance usually treats residual as a floor: stop when net book value meets it. Fleet vehicles and plant with a real used market justify the floor. This page assumes a nil residual (see the note under the intro). Where the real figure isn't nil, subtracting it from the cost entered, or adjusting the last rows by hand, keeps the schedule accurate.

Selling mid-schedule

The sale is never of the original cost — it is of the net book value on the disposal date: cost less everything already charged, including a pro-rata slice of the current year.

NBV = Cost − Accumulated depreciation (to disposal date)

Gain/(loss) = Proceeds − NBV

Proceeds above NBV: gain in the P&L. Below: a loss. For tax, proceeds (capped at cost) come off the pool; a balancing allowance or charge may follow if the asset was in a single-asset pool. A reducing-balance book policy leaves a thinner NBV, so a given sale price looks more like a gain. Glancing at both columns before completing the sale is worth the minute it takes.

Double-declining balance and the ×2 habit

DDB is the textbook accelerated method: twice the straight-line rate, hit against opening NBV each year. A five-year life is 20% straight-line, 40% DDB. Residual value is ignored in the yearly sum and used only as a stop. US GAAP* loves it; IFRS allows a declining-balance if it matches the pattern of benefits.

DDB rate = (1 / Useful life) × 2

Charge = Opening NBV × DDB rate

This calculator's reducing-balance column is in the same family — a multiplier on the straight-line rate, then a switch to the remaining-life straight-line when that is larger (the max in the formula). It is not the UK tax pool, and pasting it into a corporation-tax computation as if it were WDA would misstate the relief.

Reading the schedule in the software

Xero, Sage, QuickBooks: same bones as the table above. Asset code, cost, residual, method, this year's charge, accumulated depreciation, NBV. It shows when a replacement is due, what a disposal will do to the P&L, and whether two similar vans are being depreciated the same way.

This page prorates the first year in whole months, calendar year. A package that counts days, or a 1 April year-end, will print a slightly different first line. Two conventions, not two errors — checking which one a given file actually uses avoids a mismatch.

Glossary

P&L
Profit and loss account: the accounting statement showing revenue, costs and the resulting profit or loss over a period.
FRS 102
Financial Reporting Standard 102: the UK accounting standard most smaller and medium-sized companies use to prepare their statutory accounts.
IFRS
International Financial Reporting Standards: the accounting rulebook used by listed and larger companies worldwide, as an alternative to a national standard like FRS 102.
WDA
Writing Down Allowance: the yearly tax deduction HMRC allows on a pool of assets, at a fixed percentage that never reaches zero.
AIA
Annual Investment Allowance: a UK tax relief letting most businesses deduct the full cost of qualifying equipment in the year of purchase, up to an annual cap.
GAAP
Generally Accepted Accounting Principles: the standard framework of rules used to prepare and present financial statements in a given country, such as US GAAP.

Related calculators