AssetCenter
Asset register template
A free asset register template for Excel and Google Sheets, and a printable one you can build here: choose the columns for an equipment list, an IT asset inventory or a fixed asset register, then download the spreadsheet or print blank or pre-numbered pages.
Download the ready-made template
Thirteen columns with an example row. The Excel workbook adds drop-down lists for status and condition, a sheet that defines each status, and notes on how to use it. The CSV opens in Google Sheets, Numbers or any other spreadsheet.
In the print dialog, set the scale to 100% or Actual size. Choose Save as PDF as the printer to keep a copy.
What each column is for
| Column | What to record |
|---|---|
| Asset ID | A number of your own that never changes, the same one printed on the item’s tag. Leave location, department and status out of it. |
| Asset name | What someone would call it: the make and model, or a plain description. |
| Category | The kind of thing it is, from a short fixed list such as Laptop, Vehicle or Power tool. |
| Serial number | The manufacturer’s identifier, or a VIN for a vehicle. It proves which unit this row is. |
| Status | Where it is in its life: received, available, deployed, in service, in storage, retired or disposed. |
| Custodian | The person responsible for it today. |
| Location | The site, room or vehicle it is kept in. |
| Condition | New, good, fair, poor or damaged, as last seen. |
| Purchase date and cost | When it was bought and what was paid, for warranty, replacement and depreciation questions. |
| Warranty end | The last day a repair is the supplier’s cost and not yours. |
| Last verified | The last date someone physically saw the item where the register says it is. |
| Notes | Anything the next person needs that no other column holds. |
The asset register guide explains how to choose fields, define the status values before anyone types one, and decide who is allowed to change a row.
Keeping the register right after the first week
- Tag the item before you add the row. The ID on the register has to be the ID on the equipment. The asset tag generator prints numbered QR or barcode labels to match.
- Update the row when the handoff happens. A register that is corrected once a quarter is wrong for most of the quarter.
- Count it against the room. Print an inventory count sheet from the register, walk each location, and fill in Last verified for what you find.
- Check the file before you rely on it. The asset register checker finds duplicate IDs and serials, costs that are not numbers and three spellings of the same location.
- Know what a spreadsheet cannot keep. Changing the custodian overwrites the previous one. If you need to know who had an item before, keep a handoff log beside the register or move it into an asset system.
Asset register template FAQ
At least an ID that never changes, a name, a category, the serial number, who has the item, where it is and its condition. Add the purchase date, cost and warranty end if you answer replacement or warranty questions from the register, and a last-verified date if you count it.
In everyday use, yes: each is a list with one row for every item an organization owns or is responsible for. A fixed asset register usually means the finance version, which adds purchase date and cost for depreciation. Stock counted by quantity is a different kind of inventory and needs different columns.
Yes. Download the CSV and open it in Google Sheets, Numbers or any other spreadsheet. The drop-down lists for status and condition are in the Excel workbook.
When several people edit it, when you need to know who had an item before the current custodian, or when physical checks keep disagreeing with the file. A spreadsheet row holds only the current state, so each change overwrites the one before it.
Yes. AssetCenter imports assets from an Excel file. Run yours through the asset register checker first: it flags what an import would reject and saves a cleaned copy with AssetCenter’s column headings.
No. The register is built in your browser, and your settings are remembered on this device only.
Outgrown the spreadsheet?
AssetCenter keeps the same fields on each asset’s record and adds what a spreadsheet loses: every previous custodian and location, repairs, costs and documents on one timeline. Import your register from Excel. Free for up to 25 assets.