In this free Excel template every fixed asset sits on one line: tag, name, class, location, custodian, purchase date and cost. Choose the class and the rate fills in; change the financial year and the opening value, this year's depreciation, written-down value and accumulated depreciation are calculated on reducing balance or straight line.
The template is built from fixed asset working formats used in audits: unit-wise addition break-ups, movement schedules and top sheets. As in real work, every asset is a separate line and the schedule adds up from there.
Policies built in
- Financial year July to June; enter the year-end in the Settings sheet
- Full-year depreciation in the year of purchase (a common policy)
- RB = reducing balance: the rate applies to the written-down value each year; SL = straight line: the rate applies to cost each year
- Typical class rates are in the Settings sheet; change them to match your accounting policy
From register to financial statement note
The class-wise schedule sheet adds up cost, opening WDV, this year's depreciation, closing WDV and accumulated depreciation for each class. That is the basis of the fixed asset note in the financial statements. Assets sold or scrapped during the year need to be shown separately; the template keeps that part simple.
The verification column
At year-end, inspect the assets and choose in the verification column: OK, moved, not found, idle/damaged. That column shows the auditor that a physical verification took place. With many assets or several units, verifying by phone with QR tags is much faster: see the live demo.
Frequently asked questions
How do I keep tax depreciation separately?
Take a copy and enter the income tax rates in its Settings sheet. The difference between the two files' closing WDVs drives the deferred tax calculation.
What about land?
Land is not depreciated, so its rate in Settings is 0.
Does it work in Google Sheets?
Yes. Just check once that the drop-downs and colours came through.
Talk to us about your accounting work
The first conversation is free. You get a written price and timeline before any work starts.
Related pages
Depreciation calculator
Year-by-year depreciation and WDV table on RB or SL.
Large companiesFixed asset register and physical verification
Register build-up, QR tagging, year-end verification and depreciation schedules.
AutomationFixed asset register software
QR tags, mobile verification, automatic depreciation and audit reports. Live demo available.
Free templatesRatio analysis in Excel: the ratios banks look at
12 ratios with a two-year comparison: see your statements the way a bank does.
Written by the EOMS Hisab accounts team. Last reviewed: . Bangladesh rules change with each Finance Act, SRO and circular. Check rates and thresholds against the latest official source before relying on them.