Depreciation Calculator UK
🇬🇧 UK Depreciation Calculators & Guides
🏠 Home
🚗 Vehicle Calculators

🏛️ Business & Tax

🏠 Property

📚 Guides

🗂️ Resources
Business Asset Register Template UK 2026 | Fixed Asset Register Example
📊 Fixed Assets · UK Accounts · HMRC Records · 2026

Business Asset Register Template UK 2026

Use this practical fixed asset register template to track everything your UK business owns — purchase cost, serial numbers, location, depreciation, net book value, disposals and HMRC capital allowance treatment in one clean record.

20+
Useful register fields
£1M
AIA annual limit
14%
Main pool WDA 2026
3%
SBA for structures
🧾 2026 note: A register is not just an internal list. It helps prove asset ownership, supports depreciation journals under UK GAAP, gives your accountant a clean basis for capital allowance claims, and reduces problems when an item is sold, scrapped, stolen, moved between sites or replaced.

What Is a Business Asset Register?

A business asset register is a structured record of the long-term assets your company owns, controls or uses in the business.

A business asset register, also called a fixed asset register, is the master list of your company’s tangible assets. It records items such as laptops, servers, tools, vans, machinery, office furniture, fixtures, production equipment, leasehold improvements, commercial property elements and other assets that are used for more than one accounting period. Instead of relying on old invoices, memory or scattered accounting entries, the register gives you one organised view of what the business owns and where each item is.

For UK businesses, a good asset register connects three important areas: accounting depreciation, tax relief and operational control. In the accounts, assets are normally capitalised and depreciated over their useful lives. In the tax computation, HMRC capital allowances are claimed separately because accounting depreciation is not the same as a tax deduction. Operationally, the register helps managers locate assets, check insurance cover, plan replacements, identify obsolete equipment and prove ownership during an audit or claim.

This template has been built for UK companies, sole traders and accountants who need something more useful than a basic “asset name and cost” list. It includes accounting fields such as cost, useful life, residual value, depreciation method, opening net book value and closing net book value. It also includes tax fields such as HMRC pool, AIA, FYA, WDA and SBA notes, plus practical fields such as serial number, assigned user, department, status and disposal proceeds.

Tip: If your business uses Xero, QuickBooks, Sage or FreeAgent, you can still keep this spreadsheet as your detailed working file. The accounting software can hold the summary ledger balance, while the register explains what sits behind that balance.

Business Asset Register Template UK 2026

Copy these columns into Excel, Google Sheets or your accounting workpapers. The sample rows show how to record common UK business assets.

Asset IDCategoryDescriptionLocation / Cost CentreOwner / UserSupplierPurchase DateCost (£)Capitalised?MethodUseful LifeResidual (£)Opening NBV (£)Depreciation 2026 (£)Closing NBV (£)HMRC Pool / AllowanceAIA / FYA Claimed?Serial / Reg No.StatusDisposal DateDisposal Proceeds (£)
IT-001Computer & ITLaptop for finance managerHead Office – FinanceA. SmithDell UK15/01/20261,200.00YesStraight-line3 years0.000.00400.00800.00Main pool / AIAAIA 100%SN-12345678In use0.00
VEH-010Company vanFord Transit delivery vanWarehouseLogistics teamFord dealer01/07/202422,000.00YesReducing balance5 years2,000.0015,840.003,168.0012,672.00Main pool / WDAAIA used in 2024AB12 CDEIn use0.00
FIT-025FixturesOffice desks and chairsBranch Office – SalesSharedFurniture supplier10/09/20238,500.00YesStraight-line7 years0.006,714.291,214.295,500.00Main pool / AIAAIA claimedN/AIn use0.00
IF-003Integral featureWarehouse LED lighting systemMain WarehouseFacilitiesLighting Solutions Ltd30/11/202218,000.00YesStraight-line15 years0.0014,400.001,200.0013,200.00Special rate pool 6%Part AIA / part WDAN/AIn use0.00
BLD-001BuildingFreehold office building structureHead OfficeN/AProperty vendor01/05/2020650,000.00YesStraight-line40 years0.00585,000.0016,250.00568,750.00SBA 3% on structureNo AIA on landTitle Ref 12345In use0.00

Copyable CSV Header

Paste this row into Excel or Google Sheets to create your own fixed asset register template.

How to Fill in Each Asset Register Column

The best registers are simple enough to update every month, but detailed enough to support accounts, tax and asset control.

Identification

Asset ID, category and description

Give every item a unique asset ID, such as IT-001, VAN-002 or MACH-014. Use categories that match your accounts, for example computer equipment, motor vehicles, plant and machinery, fixtures, furniture or building improvements. The description should be specific enough that someone else can identify the item without asking you.

Control

Location, user and serial number

Record the site, department, cost centre and person responsible for the asset. For portable items, the serial number is essential. For vehicles, record the registration number and VIN where possible. These fields are especially useful for insurance claims, audits, theft checks and internal stock takes.

Accounting

Cost, useful life and depreciation

Enter the purchase cost excluding recoverable VAT, the date available for use, the depreciation method and useful life. Straight-line depreciation is common for furniture, IT and buildings; reducing balance is often used for vehicles and assets that lose more value in early years. Residual value should only be included if it is realistic and supportable.

Tax

HMRC pool and allowance claimed

Record whether the asset used AIA, FYA, full expensing, 40% FYA, main pool WDA, special rate WDA, a single asset pool or Structures and Buildings Allowance. This prevents confusion at year-end because the tax treatment may be different from the accounting depreciation method.

Lifecycle

Status and disposal details

Keep a clear status field: in use, stored, damaged, scrapped, sold, transferred or written off. When an item leaves the business, add the disposal date and proceeds. This is vital for removing assets from the balance sheet, recording profit or loss on disposal, and adjusting capital allowance pools correctly.

Evidence

Invoice and document links

Add a notes column for invoice references, warranty expiry dates, maintenance files, insurance values, photo links or cloud storage links. A register becomes much more useful when the supporting evidence is easy to find, especially if HMRC, an auditor or an insurer asks for proof later.

How to Use This Template Month by Month

A fixed asset register only works if it is updated regularly. Use this workflow to keep it accurate without creating extra admin.

1

Set your capitalisation threshold

Decide the minimum value that will be capitalised, such as £250, £500 or £1,000. Items below the threshold can usually be expensed, although you may still track portable items in a separate inventory list.

2

Add purchases when invoices arrive

Do not wait until year-end. When an invoice is coded to fixed assets, add the item to the register, attach the invoice reference, choose the category and record the date the asset became available for use.

3

Post depreciation journals

At month-end or quarter-end, calculate depreciation based on the register and post the journal to your accounting software. The total closing net book value should reconcile to the fixed asset ledger.

4

Review disposals and transfers

Before finalising management accounts, ask department heads if any assets were sold, scrapped, replaced or moved. Update location and status fields so the register stays close to the real world.

Practical rule: Reconcile the register to your balance sheet every reporting period. If the register says fixed assets are £85,400 but the ledger says £91,200, investigate the difference before it becomes a year-end problem.

Quick Asset Depreciation Checker

Estimate the annual depreciation charge and closing net book value for one asset before adding it to your register.

£0
Year 1 depreciation
£0
Monthly equivalent
£0
Closing NBV at end
£0
Total depreciation
Important: This checker estimates accounting depreciation only. HMRC capital allowances are calculated separately and may give relief faster or slower than your accounts.

Accounting Depreciation vs HMRC Capital Allowances

Your register should show both, because the numbers often move at different speeds.

Accounting depreciation is the charge you recognise in your financial statements to spread the cost of an asset over its useful economic life. For example, a £1,200 laptop with a three-year life and no residual value might be depreciated at £400 per year. This charge reduces accounting profit and the net book value of the asset on the balance sheet.

HMRC capital allowances are different. They are tax reliefs that replace accounting depreciation in the tax computation. A laptop may receive 100% Annual Investment Allowance in the year of purchase, even though the accounts depreciate it over three years. A company car may receive only 6% or 14% Writing Down Allowance, even though the accounts use 20% or 25% depreciation. A commercial structure may qualify for the Structures and Buildings Allowance at 3% each year, but land does not receive depreciation or capital allowances.

Because of these timing differences, your register should include both the accounting columns and the tax columns. The accounting columns explain the net book value that appears in the accounts. The tax columns explain the HMRC pool, allowance claimed and remaining tax value. This is especially helpful when assets are sold, because disposal proceeds can create a profit or loss in the accounts and a balancing charge or allowance for tax.

Asset typeTypical accounting treatmentCommon HMRC treatment in 2026
Computers and IT equipmentUsually straight-line over 3–4 yearsUsually qualifies for AIA, subject to conditions and limits
Commercial vansOften reducing balance or straight-line over 4–6 yearsNormally plant and machinery; AIA may be available
CarsDepreciated based on useful life and residual valueNo AIA. WDA depends on CO₂ emissions; new zero-emission cars may qualify for 100% FYA
Integral featuresDepreciated over the useful life of the featureOften special rate pool at 6%, unless AIA is claimed
Commercial buildingsBuilding structure may be depreciated in accountsSBA may be available at 3% on qualifying structure costs; land excluded

Common Fixed Asset Register Mistakes

Avoid these issues before they create messy year-end reconciliations or weak HMRC evidence.

Mixing repairs with capital additions

Repairs normally restore an asset to its previous condition, while capital additions improve, extend or replace a significant part of the asset. If repairs are incorrectly capitalised, depreciation and tax claims may be wrong.

Forgetting disposals

Old laptops, vans, furniture and tools often leave the business without being removed from the register. This leaves ghost assets on the balance sheet and can overstate insurance values.

Using one generic depreciation rate

A van, laptop, office desk and building do not have the same useful life. Group assets by category and set sensible lives that reflect how the assets are used in your business.

Ignoring private use

Sole traders and partnerships must restrict capital allowances where assets are used partly privately. Companies handle private vehicle use through Benefit-in-Kind rules, but still need clear records.

Not reconciling to the accounts

The register should agree to your fixed asset cost, accumulated depreciation and net book value ledger balances. Differences should be explained and corrected regularly.

Leaving tax treatment blank

When the HMRC pool field is blank, year-end capital allowance work becomes guesswork. Record whether AIA, FYA, WDA, SBA or another treatment was used when the asset is added.

Year-End Fixed Asset Register Checklist

Before you send the register to your accountant or use it for statutory accounts, run through these checks.

At year-end, the asset register should be more than a list of purchases. It should reconcile to the accounts, explain current-year movements and provide enough detail to support the depreciation charge. Start by checking the opening cost and accumulated depreciation figures agree to last year’s closing balances. Then compare new additions in the register to the fixed asset additions posted in your accounting software. Any invoice coded to fixed assets should have a matching row in the register.

Next, review disposals. Assets that were sold, scrapped, stolen, replaced or no longer used should not remain as active assets. Add the disposal date, proceeds, reason for disposal and any supporting document reference. For high-value items, keep evidence such as a sales invoice, trade-in statement, insurance claim, board approval or disposal note. This makes it easier to calculate the accounting profit or loss on disposal and deal with any capital allowance adjustment.

Finally, review depreciation rates and useful lives. A laptop that is still in active use after three years may not need an adjustment if the original estimate was reasonable, but a machine that became obsolete faster than expected may need an impairment review or revised remaining useful life. The goal is not to make the register complicated; it is to keep it honest, consistent and easy to defend.

1. Reconcile cost

Total asset cost in the register should agree to the fixed asset cost balance in the nominal ledger or trial balance.

2. Reconcile depreciation

Accumulated depreciation and current-year charge should agree to your depreciation journal and accounts working papers.

3. Confirm existence

For valuable or portable assets, carry out a physical check or ask department heads to confirm that items still exist.

4. Review tax notes

Check HMRC pool and allowance fields so AIA, FYA, WDA and SBA claims can be prepared without guesswork.

Who Should Use This Business Asset Register?

The template works for companies, sole traders, landlords, charities and growing teams that need better asset visibility.

Small limited companies

A limited company can use the template to support the fixed asset note in the accounts, prepare depreciation journals, track directors’ vehicles and give the accountant clean records for corporation tax. It is especially helpful when a company buys laptops, vans, tools, office furniture or machinery during the year.

Sole traders and partnerships

Self-employed businesses can use the register to separate business assets from private items. It also helps record business-use percentages, which matters for cars, phones, computers and other mixed-use assets. Clear records make Self Assessment and capital allowance claims easier to support.

Property and facilities teams

Landlords and facilities managers can use the template to track fixtures, fittings, heating systems, lighting, security equipment, leasehold improvements and commercial building expenditure. Splitting land, structure and plant elements is useful when considering SBA and plant and machinery allowances.

Business Asset Register Template UK — FAQs

Answers to common questions about fixed asset registers, depreciation schedules, NBV tracking and HMRC records.

Do I need a business asset register if I am a small UK company?
Yes. Even a small company benefits from a business asset register because it shows what the company owns, where assets are located, how depreciation has been calculated and what tax relief has been claimed. Micro-entities and small companies still need reliable records for their accounts, insurance, lenders, HMRC enquiries and internal control. A simple spreadsheet is usually enough to start.
What should be included in a fixed asset register?
A strong fixed asset register should include asset ID, category, description, supplier, invoice reference, purchase date, purchase cost, location, owner or department, serial number, depreciation method, useful life, residual value, opening net book value, annual depreciation, closing net book value, HMRC pool, capital allowance claimed, status and disposal details. You can add warranty, insurance, maintenance and photo links if those help your business.
Should low-value items be included?
Most businesses set a capitalisation threshold, often between £250 and £1,000 depending on size and policy. Items below the threshold are usually expensed rather than capitalised. However, portable or theft-prone items such as phones, tablets, cameras, monitors and tools can still be tracked in a separate inventory list even if they are not treated as fixed assets in the accounts.
How often should I update the asset register?
Update it whenever an asset is bought, sold, scrapped, transferred or damaged. As a minimum, review it monthly or quarterly before management accounts are finalised. At year-end, reconcile the register to the balance sheet, check all depreciation charges, confirm physical assets still exist and update disposal fields for anything that has left the business.
Is depreciation the same as capital allowances?
No. Depreciation is an accounting charge used to spread an asset’s cost over its useful life in the accounts. Capital allowances are HMRC tax reliefs used in the tax computation. You normally add back accounting depreciation for tax and claim capital allowances instead. Because the timing can be different, the register should track both accounting net book value and HMRC allowance treatment.
Do leased assets go into the business asset register?
It depends on the lease and accounting treatment. Short-term operating leases may be tracked separately as commitments, while finance-type leases or assets recognised on the balance sheet may be included in the fixed asset register. The register should clearly mark leased assets, lessor details, lease start date, lease term and whether the business owns the asset at the end.
How do I record a company car in the asset register?
Record the purchase date, cost, registration number, VIN if available, driver or department, business use note, CO₂ emissions, depreciation method, expected residual value and HMRC pool. Cars have special capital allowance rules: they generally do not qualify for AIA, and WDA depends on emissions. New zero-emission cars may qualify for 100% First Year Allowance if the conditions are met.
What is net book value in a fixed asset register?
Net book value, or NBV, is the asset’s cost less accumulated depreciation. For example, if a machine cost £10,000 and depreciation to date is £4,000, the NBV is £6,000. NBV is an accounting value, not necessarily the market value or tax written-down value. Your register should show opening NBV, current-year depreciation and closing NBV for each reporting period.
Can I use this template in Excel or Google Sheets?
Yes. The template is designed for Excel, Google Sheets or any spreadsheet software. Start with the CSV header above, add your existing assets, then use formulas for depreciation, accumulated depreciation and closing NBV. You can also add filters, data validation dropdowns for asset categories and conditional formatting for disposed or fully depreciated assets.
What evidence should I keep with the register?
Keep purchase invoices, finance agreements, lease documents, vehicle registration documents, supplier warranties, maintenance records, photos for high-value items, disposal invoices and proof of sale proceeds. A register with evidence links is much stronger than a standalone list because it lets you support accounting entries, tax claims and insurance values quickly.