Asset Register

Track fixed assets, straight-line depreciation, and net book value in one browser-based register.

Overview

Asset Register is a single-page app for finance and operations teams who need a practical fixed-asset list without enterprise ERP software. Record purchase details, see depreciation and current value update automatically, filter by category, and export reports — all in one HTML file.

Key features

Asset grid

• AG-Grid table with Asset ID, Description, Category, Purchase Date, Cost, Useful Life, Current Value, Annual Depreciation, Monthly Depreciation, and Status
• Eight sample fixed assets (IT equipment, furniture, vehicles, machinery)
• Pinned bottom row with totals for cost, depreciation, and net book value
• Inline editing for asset fields
• Dispose button to mark assets as disposed

Straight-line depreciation

• Automatic calculation of annual and monthly depreciation from cost and useful life
• Current value updates based on elapsed time since purchase
• Status auto-updates to Fully Depreciated when book value reaches zero

Add assets and filters

• Sidebar form to add new assets (ID, description, category, purchase date, cost, useful life)
• Filter by category (IT Equipment, Furniture, Vehicles, Machinery, Other)
• Filter by status (Active, Disposed, Fully Depreciated)

Summary dashboard

• Four KPI cards: Total Assets, Original Cost, Net Book Value, and Disposed count
• Chart.js pie chart showing asset count by category

Import and export

• Export register to Excel with an Assets sheet and Summary sheet (totals and metrics)
• Import assets from Excel or CSV to bulk-load or update the register

Appearance

• Dark mode toggle with saved preference
• AG-Grid adapts to light and dark themes

Data & persistence

• Asset register auto-saves to localStorage on every change
• Dark mode preference stored separately
• Reload the page to restore your session; clear browser storage to reset sample data

Charts & reporting

• Chart.js pie chart by asset category
• Excel export includes a Summary sheet with key totals

Built with

Tailwind CSS, AG-Grid Community, Alpine.js, Chart.js, and SheetJS — all from CDN in one HTML file.

Try the interactive walkthrough below. Click Walk through features and use Next / Back (or arrow keys) to explore every feature.