OP-008 · Version 1.0.0
Asset Manager: fixed assets and depreciation in Excel
Fixed asset register with straight-line depreciation, book value, warranties and equipment loans, no macros.

Asset Manager is an Excel workbook to keep your company's fixed asset register without installing software.
Record each asset with its cost, useful life and warranty: the workbook calculates monthly straight-line depreciation and book value and warns about warranties about to expire. When an asset is disposed of, depreciation stops.
The loans sheet tracks who has each item and flags overdue ones. The dashboard summarizes cost, book value and loans.
Features
- Automatic monthly straight-line depreciation and book value.
- Dated disposals: depreciation stops and book value goes to 0.
- Warnings for warranties about to expire.
- Equipment loan tracking with overdue items.
- Reports by category, location and month with charts.
- Checks for IDs, dates, costs and duplicate loans.
- Includes demo, PDF manual and quick start. No macros.
Who it is for
Small businesses, schools, offices and workshops that need to know what assets they have, where they are, what they are worth and who has them.
What it does not include
It does not replace accounting and includes no depreciation methods other than straight-line or barcode reading.
Editions
| FREE (demo) | PRO | |
|---|---|---|
| Workbook with sample data | ✓ | ✓ |
| Empty template for your business | — | ✓ |
| Capacity | 100 assets / 200 loans | 2,000 assets / 3,000 loans |
| PDF manual and quick start | — | ✓ |
| Minor updates within the same major version | — | ✓ |
What you get
- Asset_Manager_Demo_EN.xlsx
- Asset_Manager_EN.xlsx
- CHANGELOG.txt
- LICENSE.txt
- Quick_Start_EN.pdf
- README.txt
- User_Manual_EN.pdf
Requirements
Excel 2016 or later, Microsoft 365 or LibreOffice Calc 7.6+. Windows, macOS or Linux.
Questions about this product
Is it valid for official accounting?
It is an internal control tool. Ask your accountant about useful life and tax depreciation rules in your country.
How many assets does it hold?
The PRO edition holds 2,000 assets and 3,000 loans. The demo holds 100 assets.
Which depreciation method does it use?
Straight-line, by full months in use, with salvage value.
Do I need macros?
No. Only standard Excel formulas.
Version history
1.0.0 · 2026-11-16
- First release: asset register, monthly straight-line depreciation, book value, disposals, warranties, equipment loans with overdue tracking, dashboard and reports.