Skip to content
← TemplatesFinance & modelling

Free Fixed Asset Register & Depreciation Schedule (Excel)

Every set of accounts needs a fixed asset register, and doing it by hand is where errors creep in. This free workbook keeps it straight: list each asset once with its cost and category, and the annual depreciation, accumulated depreciation to date and net book value all compute themselves — ready for your year-end.

Download free — Excel (.xlsx) ↓Opens in Excel or Google Sheets · no sign-up

What's inside

  • Annual depreciation, accumulated depreciation and net book value per asset
  • Editable useful life per category; straight-line rate derived
  • Accumulated depreciation capped at cost (never over-depreciates)
  • Dashboard: total cost, total depreciation, total net book value at any date
  • Formulas locked; only the yellow cells accept typing

The tabs

  • Start Here (guide)
  • Categories (editable lives)
  • Assets
  • Dashboard

Yellow cells only. You type in the yellow cells; the rest are locked formulas. Gridlines are off and it prints clean on A4.

The Categories tab holds the useful life for each class of asset — computers, furniture, machinery, vehicles, buildings — which you can edit to your own policy; the straight-line rate is derived automatically. On the Assets tab you pick a category from the dropdown and enter the cost and purchase date, and the schedule fills in: annual depreciation (cost ÷ life), age since purchase, accumulated depreciation (capped at cost) and net book value.

The Dashboard totals your asset cost, accumulated depreciation and total net book value as at any date you choose, so you can drop the figures straight into a balance sheet. The formulas are locked and only the yellow cells accept typing, so the register can't be broken by accident.

It uses straight-line depreciation, the clearest method for accounts. For tax, confirm the current KRA wear-and-tear (investment) allowance rates, which differ by asset class and use a reducing-balance basis — a note on the Categories tab reminds you.

Do it online instead

Model a whole business — free DCF tool

Open the free tool →

Frequently asked questions

Is this straight-line or reducing-balance depreciation?

It uses straight-line: annual depreciation = cost ÷ useful life, and accumulated depreciation is capped so net book value never goes below zero. This is the clearest basis for a set of accounts. For KRA tax, wear-and-tear allowances differ and are on a reducing-balance basis — confirm the current rates for each class.

Can I change the useful lives?

Yes. The Categories tab holds the life (in years) for each asset class and is fully editable, so you can match your own accounting policy. Every asset in that category re-depreciates automatically.

Does it work in Google Sheets?

Yes — upload the .xlsx to Google Drive and open it with Google Sheets; the dropdowns and formulas carry over.