Service Charge Budget Excel
Budget, levies, arrears & sinking fund for OMCs
- Budget in the 9 categories of the MUD Act, vs actual
- Levy per unit from the lease share or floor area
- Arrears aged 0–30 / 31–60 / 61–90 / 90+ days
One-off purchase – no subscription
Fixed Asset Register Excel
Asset register, book depreciation and Irish capital allowances for sole traders, small companies and their accountants
€59incl. VAT
One register for the asset list, the accounts and the tax computation
9sheets
200assets
0macros
- Asset register with category, location, person responsible, serial or reg. number, supplier and invoice
- Book depreciation by month – straight-line or reducing balance, with useful life and residual value per category or per asset
- Irish wear and tear: 12.5% a year for 8 years, ACA at 100% and industrial buildings at 4% – rates editable
- Cars by CO2 group: full €24,000 limit, half limit or nil, with the 2027 thresholds and business-use share
- Disposals with profit or loss and an estimated balancing allowance or charge (€2,000 rule included)
- Accountant summary: cost, depreciation and NBV movements by category, capital allowances by class and 12 years side by side
STARTSETTINGSASSET REGISTERDEPRECIATIONCAPITAL ALLOWANCESDISPOSALSYEAR BY YEARACCOUNTANT SUMMARYDASHBOARD
Found an error in the template? We'll fix it – or refund you.
A fixed asset register that speaks Irish tax – not just depreciation
List every van, machine, laptop and fit-out once. The workbook works out the depreciation for your accounts, the wear and tear for Revenue, and what happens when you sell – year after year.
Most asset register templates stop at straight-line depreciation. In Ireland your accountant needs two sets of figures: depreciation for the accounts, and capital allowances for the tax return – 12.5% a year for 8 years on plant and machinery, cars limited by their CO2 emissions and the €24,000 specified amount, the business share for sole traders, and a balancing allowance or charge when an asset is sold, traded in or scrapped.
This workbook keeps both side by side. Enter each asset once with its category, cost, date and where it is. DEPRECIATION charges the year month by month, CAPITAL ALLOWANCES works out the wear and tear and the tax written-down value, DISPOSALS shows the profit or loss and the tax adjustment, and the ACCOUNTANT SUMMARY gives the fixed asset note and the capital allowances by class for the year you choose.
Without a template
- A list of assets in one file and the depreciation in another
- Nobody knows which assets are fully claimed and which still have wear and tear left
- Car allowances worked out without the CO2 limits or the private-use share
- Sold or scrapped assets that stay on the books – or vanish with no balancing charge
With ExcelGrand
- Register, depreciation and capital allowances linked on the same line
- Year x of 8, final year and fully claimed shown for every asset
- CO2 group, qualifying cost and business share calculated per car
- Disposals stay on the register with profit/loss and the estimated balancing adjustment
What's in the file
START
Key figures, quick links and a step-by-step guide.
SETTINGS
Business, financial year end month, year to report, depreciation start rule, capitalisation threshold, 12 categories with default method, life, rate, residual value and tax class, 6 tax classes and the car CO2 rules – all editable, with the date checked.
ASSET REGISTER
200 assets: ID, description, category, purchase date, cost, location, responsible person, serial or reg. number, supplier and invoice – plus optional overrides, CO2, business use and the disposal on the same line, with status, NBV and data checks.
DEPRECIATION
Cost and accumulated depreciation brought forward, additions, disposals, charge for the year and NBV per asset – plus the NBV at 13 year ends.
CAPITAL ALLOWANCES
Tax class, CO2 group, qualifying cost, business use, first and last year, wear and tear, balancing allowance or charge and TWDV per asset – plus TWDV and allowances claimed for 13 years.
DISPOSALS
Every sale, trade-in or write-off in date order: proceeds, NBV, profit or loss, TWDV, tax proceeds and the estimated balancing adjustment.
YEAR BY YEAR
Twelve financial years: additions, disposals, cost, depreciation, NBV, allowances, balancing items, TWDV and the NBV–TWDV gap.
ACCOUNTANT SUMMARY
Fixed asset note by category (cost, depreciation, NBV), capital allowances by tax class, the capital items in the tax computation and data checks.
DASHBOARD
Cost held, NBV, depreciation and net capital allowances, with four charts.
Take a look inside
Specifications
Format.xlsx
RequiresExcel 2016+ / Microsoft 365
Sheets9
Capacity200 assets · 12 categories · 6 tax classes · 12-year view
RulesWear and tear 12.5% × 8 years, car CO2 limits and €24,000, ACA 100% – all editable
MacrosNone
Who is it for?
- Sole traders & partnerships
- Small limited companies
- Accountants & bookkeepers
- Trades, workshops & contractors
- Office & finance managers
Frequently asked questions
What should be included in a fixed asset register?
At least an asset ID, a description, the category, purchase date, cost and supplier, where the asset is and who is responsible for it, and a serial or registration number. For the accounts you also need the depreciation method, useful life, residual value and net book value, and for tax the capital allowance class. When an asset is sold or scrapped, record the date and the proceeds. The ASSET REGISTER sheet has a column for each of these.
What is the difference between depreciation and capital allowances in Ireland?
Depreciation is what you charge in your accounts, based on your own estimate of the asset's useful life. Revenue does not allow it for tax: it is added back, and you claim capital allowances instead – for most plant and machinery 12.5% of the cost a year for 8 years, as long as the asset is in use at the end of the period. This workbook calculates both side by side and shows the gap year by year.
How are capital allowances on cars calculated in Ireland?
They depend on the car's CO2 emissions and when you bought it. For cars bought from 2021 to 2026, cars up to 140 g/km qualify on €24,000, cars from 141 to 155 g/km on half (at most €12,000), and higher-emission cars get nothing; from 1 January 2027 the limits drop to 120 and 140 g/km. The allowance is 12.5% a year for 8 years, and sole traders claim only the business share. These rules are pre-filled and editable in SETTINGS.
What happens when I sell or scrap an asset?
Instead of wear and tear in that year, you compare the tax written-down value with the sale proceeds: if the proceeds are lower you get a balancing allowance, if they are higher a balancing charge is added to your profit. No balancing charge is made when the proceeds are under €2,000, unless you sell to a connected person. The DISPOSALS sheet estimates this for every disposal, alongside the profit or loss in the accounts.
Can I use it if my financial year doesn't end in December?
Yes. Choose the month your financial year ends and the year you want to report in SETTINGS. Depreciation is charged month by month, and capital allowances are worked out per financial year.
Does it replace my accountant?
No. It keeps your assets and the figures in order and gives your accountant a clear summary – the fixed asset movements, the capital allowances by class and the disposals. Your accountant prepares the final accounts and tax computation.
Other templates you may need
Fire Safety Register Excel
Fire safety log book with due-date alerts for Irish buildings
- Weekly fire alarm test log with call point rotation
- Monthly checks of fire doors, escape routes and emergency lighting
- Service due dates for extinguishers, alarm and other equipment
Risk Assessment Template Excel
Hazard register, 5×5 risk matrix, action plan & Safety Statement checklist
- Hazard register by area with who is at risk and existing controls
- 5×5 likelihood × severity scoring with colour-coded ratings
- Action plan with owner, target date from the rating and overdue alerts
Fixed Asset Register Excel
Asset register, book depreciation and Irish capital allowances for sole traders, small companies and their accountants · €59
Fixed asset register template in Excel with depreciation and Irish capital allowances
A fixed asset register template in Excel lets a small business keep every asset in one place – what it cost, when it was bought, where it is and who has it – and works out the net book value at each year end. This asset register template goes further for Ireland: book depreciation (straight-line or reducing balance) next to wear and tear, tax written-down value and the capital allowance schedule your accountant needs.
Use it as a fixed asset register for a sole trader or a small company, as a depreciation schedule in Excel, or as a capital allowances calculator for plant and machinery, vans and cars with CO2 limits. Disposals, balancing allowances and charges, and a year-by-year view of book value against tax value are all included – with no macros and no subscription.
Fixed Asset Register Excel€59