A depreciation schedule is the bridge between the asset register and the ledger. Get it right once and it runs itself.
List each asset with cost, residual value, useful life, method and the date it was available for use. Calculate monthly depreciation with straight-line or reducing-balance formulas, stop at the residual value or disposal date, and total by asset category. Each month, agree the schedule's accumulated depreciation and charge to the ledger.
Put the period end in a cell named PeriodEnd.
H: monthly charge
=(C2-D2)/E2
I: months depreciated to date, capped at the useful life and stopped at disposal:
=IF(F2>PeriodEnd,0,MIN(E2,DATEDIF(F2,IF(AND(G2<>"",G2<PeriodEnd),G2,PeriodEnd),"m")+1))
J: accumulated depreciation =H2*I2
K: net book value =C2-J2
This counts the first month as a full month. If your policy is to start the month after the asset is available, remove the +1.
Reducing balance applies a fixed rate to the opening net book value each year. Excel's DB function calculates the annual charge:
=DB(C2,D2,E2/12,YearNumber)
Divide by 12 for a monthly charge within the year. Because the charge changes every year, many teams keep reducing-balance assets on a separate sheet with one column per year. The straight-line vs reducing balance guide explains when each method fits.
For disposals, see fixed asset disposal accounting; for what the register needs, the fixed asset register requirements.
Useful lives and residual values are estimates, and they should be reviewed at least once a year. If an asset is going to be used for longer or shorter than planned, or its expected resale value has changed, the remaining depreciation is adjusted from that point forward rather than going back and restating earlier months. Record the review, who approved any change and the reason, so the auditors can follow the decision.
Accounting depreciation and tax relief are separate. UK capital allowances and US tax depreciation follow their own rules and rates, so keep a separate tax schedule if you need one.
Straight-line vs reducing balance depreciation year by year, with net book value and the journal entry. Free to use online.
The Fixed Assets & Depreciation System calculates straight-line and reducing-balance depreciation, stops depreciation at the disposal date with the profit or loss calculated, and ties a full movement schedule back to the register. Excel, no macros, one-time price.
When the asset is available for use, not when it is paid for. Set out whether you start in that month or the next one in your accounting policy.
Generally no, because land usually has an unlimited useful life. Buildings on the land are depreciated separately.
Common causes are missed disposals, assets added to the ledger but not the schedule, and manual journals to accumulated depreciation.
Last updated 21 October 2026. General guidance for finance teams; check it against your own policies, systems and local rules.