Fixed asset register with depreciation and Irish capital allowances
Your accounts depreciate an asset one way and Revenue allows capital allowances another, so two sets of figures have to be kept side by side. The register does both from one list of assets and gives your accountant a ready summary at the year end.
- 200 assets in 12 categories
- Straight-line or reducing balance depreciation
- Wear and tear at 12.5% over 8 years
- Twelve-year view of cost and net book value

Depreciation for the accounts
DEPRECIATION charges each asset month by month, straight-line or reducing balance, using a life and residual value you set for a category or a single asset. It carries forward cost and accumulated depreciation and adds the year's additions and disposals. The financial year can end in any month.
Capital allowances for tax
| Class | Treatment in the workbook |
|---|---|
| Plant and machinery | 12.5% a year for 8 years |
| Energy-efficient equipment (ACA) | 100% in the first year |
| Industrial buildings | 4% a year |
| Cars | Depends on CO2 emissions: the €24,000 cap in full, at half, or not at all |
Business-use share is applied per asset, and every rate and limit can be edited.
Selling or scrapping an asset
DISPOSALS lists sales, trade-ins and write-offs by date, with proceeds, profit or loss in the accounts and an estimated balancing allowance or charge for tax. ACCOUNTANT SUMMARY sets out the fixed asset note by category.
A look at the sheets




Questions people ask
Why keep depreciation and capital allowances apart?
Can I use it if my year ends in June?
Does it replace my accountant?
Technical details
- START
- SETTINGS
- ASSET REGISTER
- DEPRECIATION
- CAPITAL ALLOWANCES
- DISPOSALS
- YEAR BY YEAR
- ACCOUNTANT SUMMARY
- DASHBOARD
- File format
- .xlsx
- Tabs
- 9
- Capacity
- 200 assets · 12 categories · 6 tax classes · 12-year view
- Requires
- Excel 2016+ / Microsoft 365
- Macros
- None