Fixed Asset Register Template for Excel

What a fixed asset register is (and what this template tracks)

A fixed asset register is a record of an organization’s titled tangible assets: what it owns, proof of ownership, any encumbrances, and disposition history. Lenders ask for it before financing equipment, insurers before binding a fleet policy, and due diligence teams before closing an acquisition.

This asset register template covers titled tangible assets specifically: vehicles, aircraft, vessels, heavy equipment, and trailers — anything with a certificate of title, bill of sale, or manufacturer’s statement of origin behind it. That’s narrower than “everything the company owns.” A register built for audits and financing has to answer three questions per asset — Do we own it? Is it encumbered? What happened to it? — that a general inventory list can’t. If you need book value and depreciation math, that’s a depreciation schedule — a different document; the comparison below shows the difference.

What’s inside the Excel template

The workbook has four worksheets, plus a hidden sheet powering the dropdown lists you won’t see or need.

Start Here covers how the file works: what goes in each column, and three habits — one identifier per asset, one row per document, log-don’t-delete on disposition — that keep the register usable a year from now.

Asset Registry is the core sheet: one row per titled asset, capturing owning entity, asset type (Vehicle, Aircraft, Vessel, Heavy Equipment, Trailer, or Other), description, source, and the VIN or serial number that makes each row unique. Acquisition date, type (Purchase, Transfer, Gift, Other), and cost establish how the organization came to own it. Disposition date, type (Sale, Transfer, Trade-In, Scrapped, Stolen, Other), and amount close the loop — without deleting the row that proves the asset existed.

Asset Titles exists because “we own it” and “we can prove it” are different claims. Each row logs a title document: which asset, title type (Certificate of Title, Bill of Sale, Manufacturer’s Statement of Origin, or Other), issue date, and issuing authority — a state DMV for a vehicle, the FAA for an aircraft, the U.S. Coast Guard for vessels. Three authorities, three formats — worth its own column. A lien-noted flag and status (Pending, Current, Superseded) round out the row.

Asset Liens tracks encumbrances separately, since a lien is a claim against the asset, not a fact about the title. Each row records lienholder, lien type (Purchase Money, Refinance, Tax Lien, Judgment Lien, Other), lien date, original amount, release date, and status (Active, Released, Transferred). The release date matters most: an Active lien with none is a red flag for lenders and insurers.

There’s no depreciation math here — this is an ownership register, not an accounting schedule. Pair it with your existing accounting system for book value.

How to create a fixed asset register in Excel

Building one from scratch takes five steps:

1. One row, one unique identifier per asset. Use the VIN or serial number, not the description — descriptions drift, identifiers don’t.
2. Record the owning entity and acquisition details — which legal entity holds title, when it was acquired, and at what cost.
3. Log the title document separately. Title type, issuing authority, title number, issue date — titling authorities and formats vary by asset type.
4. Flag liens and track release dates, not just origination dates. A lien with no release date is an open question.
5. Log disposition without deleting the row. Record how and when it leaves, and keep the history.

Or skip the setup — the template above has all five built in.

How to use the template

Recording owners and asset types

Start in Asset Registry: owning entity, asset type, VIN or serial number, and acquisition cost and date — every other sheet points back to this row.

Tracking title documents

Every title gets its own row in Asset Titles. If a title is reissued, add a new row and mark the prior one Superseded, so the register keeps title history, not just current state.

Tracking lien status and release dates

Add a row in Asset Liens the day a lien is recorded — status Active, release date blank — then flip status to Released once the lienholder releases it.

Logging disposition without losing history

When an asset is sold, transferred, or scrapped, fill in disposition date, type, and amount on its existing row — don’t delete it. Audit and financing lookback windows often run seven years or more, and a register with only current holdings can’t say what the company owned three years back.

Fixed asset register vs. depreciation schedule vs. IT asset inventory

These get confused because they all have “asset” in the name. They answer different questions.

A depreciation schedule and this register can describe the same physical asset and never touch — one tracks book value, the other tracks ownership. An IT asset inventory or fleet maintenance log tracks operational detail (location, condition, assigned user) that a fixed asset register deliberately leaves out. Need all three? Normal — just don’t expect one document to do the other two jobs.

When a spreadsheet stops working

This asset tracking spreadsheet takes most organizations a long way, often years. But it strains in specific ways. Excel has no version history, so a title superseded or a lien flipped without adding a new row loses the prior state. There’s no point-in-time snapshot for an auditor asking “what did we own on March 31,” and liens go stale — nothing flags an Active lien with no release date. Once more than one person or entity is involved, no one controls who edits which rows.

That doesn’t mean abandoning the spreadsheet. It means knowing when its job is done. These three data sheets use the same column headers as Lextree’s CSV import templates, so the file imports directly into titled asset tracking software, columns already mapped, no re-keying. From there, records live in a system with real version history, entity-level access control, and audit trails — see asset management for compliance for the bigger picture.

Frequently asked questions

What is a fixed asset register? A record of an organization’s titled tangible assets — what it owns, proof of ownership, any liens, and what happened to it. Used for audits, financing, insurance, and due diligence.

What should a fixed asset register include? At minimum: a unique identifier (VIN or serial number), owning entity, acquisition details, title document and issuing authority, lien status, and disposition once an asset leaves.

Is a fixed asset register the same as a depreciation schedule? No — a depreciation schedule tracks book value, while a fixed asset register tracks ownership, title, and encumbrances. Most organizations maintain both.

How do I track liens and titles in the template? Asset Titles and Asset Liens are separate worksheets, linked back to the asset row in Asset Registry. Log a new row for each document or lien, then update status and release date as they change.

Can I use it for vehicles, aircraft, and heavy equipment? Yes. The asset type dropdown covers Vehicle, Aircraft, Vessel, Heavy Equipment, Trailer, and Other — any titled asset, regardless of issuing authority.

Do I delete an asset when it’s sold? No. Fill in disposition date, type, and amount on its existing row — that retained history is what an auditor or acquirer’s due diligence team wants to see.

Is the template really free? Yes. Enter your email below and the workbook is sent immediately — no credit card, no sales call.