Free templatesAsset register
Free template · CSV for Excel or Google Sheets
Asset register template
An asset register lists every piece of equipment you service on each site, with enough detail to find it, service it on time and show its history.
The columns
- Asset ID
- Your label or barcode number.
- Site
- Client or site name.
- Location
- Level, room or area.
- Asset type
- For example extinguisher, split system, CCTV camera.
- Make / model
- Manufacturer and model.
- Serial
- Serial number, if any.
- Installed
- Install or manufacture date.
- Service interval
- How often it is serviced.
- Last serviced
- Date of the last service.
- Next due
- Date the next service is due.
- Condition
- Good, fair, poor or out of service.
- Notes
- Access notes, defects, warranty.
Example rows
Sample data, included in the download so you can see the format. Delete these rows and add your own.
| Asset ID | Site | Location | Asset type | Make / model | Serial | Installed | Service interval | Last serviced | Next due | Condition | Notes |
|---|---|---|---|---|---|---|---|---|---|---|---|
| EXT-014 | Example Plaza | Level 1, east stair | Extinguisher, dry powder 4.5kg | Example Fire Co | 2022-03 | 6-monthly | 2026-09-12 | 2027-03-12 | Good | ||
| AC-003 | Example Plaza | Roof | Split system 7kW | Example Air | SN12345 | 2019-11 | Quarterly | 2026-10-01 | 2027-01-01 | Fair | Fan noise noted |
Using it well
- Give every asset a label that matches the register, so the technician can find the right row on site.
- Record the interval, not only the due date. The interval is what lets the next date be worked out after each visit.
- Keep one row per asset, and a separate service history, rather than overwriting the last visit.
Outgrowing the spreadsheet?
In Taskr every asset sits on its site with its service history and next-due date, and recurring schedules create the visits. Import this spreadsheet to load your sites and assets.
Paperwork and compliance: how Taskr helpsFAQ
Frequently asked questions
What is the difference between an asset register and a service history?
The register is one row per asset. The history is one row per visit. Together they show what is on site and what was done to it.
Can I import this into Taskr?
Yes. Taskr imports CSV and Excel files, and you match the columns to Taskr's fields when you upload.