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 dashboard with book value, depreciation, loans and charts from the demo data
Real screenshot of the dashboard with the demo data.

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

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—✓
Capacity100 assets / 200 loans2,000 assets / 3,000 loans
PDF manual and quick start—✓
Minor updates within the same major version—✓

What you get

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