Asset register template for a small business
Keep physical equipment identified, located and reviewed, with a workbook for item details, warranty and service dates.
Last updated October 13, 2026
Track equipment with one record per physical item, a unique tag and a current location. Record its condition and service dates beside the identifying details so the person responsible can find the right item and decide what needs attention.
Download the equipment workbook (Excel). The Register sheet holds identification and location details; Service dates holds maintenance and warranty information using the same asset tag. Both contain clearly labeled fictional examples. Replace them before entering your own records.
What is an asset register?
It is a list of the physical items a business wants to keep track of over time. A shop might include checkout equipment, display stands, shelving, printers and furniture. The list answers practical questions: which item is this, where is it and what condition is it in?
Start with equipment that people move, service, lend or replace. You do not need to record every low-cost consumable to make the list useful. Decide the scope once and write it beside the register so different people apply the same rule.
Asset register vs inventory
Equipment stays with the business while stock is usually held for sale or use. A label printer is equipment; the products it labels are stock. Keep these lists separate because they answer different questions and change in different ways.
An equipment move changes a location. Selling five units of a product changes a quantity. Combining both in one sheet makes it harder to tell whether a row represents one identifiable object or a batch of interchangeable units. Use the existing stock spreadsheet guide for products held across locations.
Equipment register fields to start with
Use a small set of required fields and leave unknown optional values blank. A made-up serial number or purchase date is less useful than an honest gap that someone can investigate later.
| Field | Example | Purpose |
|---|---|---|
| Asset tag | EQ-001 | Stable internal identifier |
| Item | Checkout label printer | Name people recognize |
| Category | Equipment | Group similar items |
| Location and area | North store, checkout two | Find the item |
| Status | In use | Describe its current use |
| Condition | Good | Record the observed state |
| Manufacturer and model | Enter from the item | Identify parts or service information |
| Serial number | Enter from the item | Distinguish units of the same model |
| Notes | Cable stored in drawer | Keep useful physical context |
How to number business equipment
Choose a short prefix and a sequence, such as EQ-001. Keep the tag when the item moves. Encoding its current location in the identifier creates extra work when it transfers to another store.
Check existing numbers before assigning a new one, and do not reuse a retired tag for a replacement. If two records describe the same object, resolve the duplicate before attaching labels. Keep the manufacturer's serial number in its own field; it serves a different purpose from your internal identifier.
Build an asset location log
Record a move when it happens. Use the same location names throughout the workbook so filters do not split "North store" and "North shop" into separate groups. Excel's drop-down list guidance explains how to maintain consistent choices.
The downloadable register holds the current location. If you need a sequence of past transfers, keep a separate move record with tag, date, previous location, destination and responsible person. Do not expect a cell containing today's location to explain where the equipment was last month.
Use an equipment maintenance tracker
Enter last service and next maintenance as separate dates. Base the next date on the item's service guidance and your maintenance arrangement. The person responsible should review upcoming dates on a schedule appropriate to the equipment.
In the example workbook, the Service dates sheet is linked by tag rather than by row position. Keep tags consistent when sorting either sheet, and add a service row when adding a new item. The template records dates; it does not issue reminders or schedule a technician.
Keep a warranty tracking spreadsheet
Record the warranty end date only when you have checked the supporting document. Use notes to identify where the receipt or service agreement is kept. Avoid pasting private account credentials or payment details into a broadly shared equipment file.
Before seeking repair, check the item's tag, serial number and warranty evidence together. Similar models can have different purchase dates or coverage. The register helps find the documents; its date alone does not establish what a provider will cover.
Record an asset condition check
Use consistent condition words and explain unusual observations in notes. "Poor: drawer does not latch" tells the next person more than "old." Status and condition are separate: an item can be in storage and in good condition, or in use while needing review.
Compare the list against the physical items. Confirm the tag, location and condition, then correct discrepancies. For long sheets, freeze the headers so people can see which field they are editing. Check both worksheets when an identifier changes.
Maintain a retired equipment list
Retain the tag and change the status when an item leaves use. Record what happened in the notes, such as returned to lessor or removed from service. Keeping the record helps distinguish missing equipment from something deliberately retired.
Purchase cost, where known, is a historical amount. This operational workbook does not calculate depreciation, tax treatment or current market value. Keep those decisions and records in the appropriate accounting process.
Where headoffis fits
headoffis is coming soon. Its Assets feature records physical equipment, tags, location, condition, status and optional purchase, warranty and maintenance dates. It can filter items due for maintenance and export the filtered register. Dates do not send reminders or create Work tasks automatically, and fixture designs for shelf planning remain separate records.
The workbook can be used now without an account. See product features, pair it with a department contact directory, or join the waitlist for launch news.