finance

fixed-asset-register

Manages the IAS 16 fixed asset lifecycle in Google Sheets and posts monthly depreciation, impairment, and disposal entries.

Manage the complete IAS 16 fixed asset lifecycle: acquisition, monthly depreciation, impairment, and disposal. Every fixed asset generates monthly depreciation journal entries that feed the GL and trial balance.

Difficulty: beginner
Input: data
Output: spreadsheet
Needs: none
Used by: Finance Manager

What it needs

asset_details — Asset name, category, cost, acquisition date, useful life, depreciation method
po_ref — loaded from your vault context
period_id — Accounting period, e.g. 2025-12
asset
recoverable_amount — Higher of fair value less costs to sell and value in use (AED)
disposal_date
disposal_proceeds — Cash received (AED). 0 for scrapped assets.
asset

What you get

(one per asset)
depreciation-journal-entries (markdown)
disposal-je (markdown)
fixed-asset (markdown)
impairment-je (markdown)
schedule (markdown)
updated-asset (markdown)

Ask it like this

fixed asset
monthly depreciation
impairment write-down
dispose of an asset.