Fixed Assets Register with Auto Depreciation — Excel Template
Track assets, depreciation and disposals as at any date — built for accountants and small businesses
S$22.00
Who is this for?
Accountants, bookkeepers and small business owners who need a professional fixed assets register — one that actually works the way accountants think.
What makes this different?
Most fixed asset templates calculate depreciation based on today's date. This one lets you set ANY date — past or future — and the entire register recalculates instantly. Perfect for backdated schedules, audit purposes and year-end reporting.
What's inside:
📋 Asset Register — Track unlimited assets with auto depreciation. Set your Schedule As At Date once and everything updates automatically.
🗑️ Disposals — Log disposed or written off assets. NBV at disposal and gain/loss auto-calculate.
📊 Dashboard — Total cost, accumulated depreciation, NBV and annual charge by asset category.
⚙️ Setup — Configure your company name, financial year end and depreciation rates by category.
📖 How To Use — Step by step guide built in. No manual needed.
Key features:
— Straight-line AND reducing balance depreciation methods
— Financial year end aware
— annual depreciation always calculates correctly for your FY
— Schedule As At Date — key in any date and see exactly what your register looked like on that date
— Disposal tracking — asset stops depreciating at disposal date, not schedule date
— Auto status — Active, Fully Depreciated, Disposed or Written Off
— Purchase Price always visible — Cost blanks out on disposal for clean reporting
— Yellow cells = your input. Green cells = auto-calculated.
Instant download. One-time payment. No subscription.
Questions? templates@getbookjobs.com
