Asset tracking for a small business means keeping one register of the things you own and use, such as laptops, tools, vehicles and machines, with a label on each item, the person who holds it, where it is, when it is next serviced and what it is worth. Done well, it answers "who has the projector?" in seconds and stops equipment from quietly disappearing.
This guide sets out a simple system that works in a spreadsheet on day one and grows into software when the business does.
Why asset tracking matters more for a small business
A large company can absorb a missing laptop. A ten person business with two delivery vans cannot lose one for a week. When you own fewer things, each one carries more of the work, so knowing where it is and whether it works matters more, not less.
Tracking also pays off at three predictable moments:
- When someone leaves. You need a list of what they hold before their last day, not after.
- When something breaks. You need the warranty and the service history right away.
- At year end. Your accountant needs purchase dates, costs and current values.
What is the difference between assets and inventory?
Inventory is what you sell or use up. Assets are what you keep and use to run the business. A box of printer paper is inventory; the printer is an asset. Track them in separate places, because they answer different questions: inventory asks "how many do we have?", asset tracking asks "where is this one, who has it and what state is it in?" Our guide to inventory management for small business covers the stock side.
How to set up asset tracking for a small business
1. Build one register
List every item worth tracking. A practical rule: anything that costs more than a set amount, anything portable that could walk away, and anything that needs servicing. For each asset record a tag number, name, category, serial number, purchase date, cost, supplier and where it is.
2. Label everything
Give each asset a tag number and a printed label. Two kinds of code are common, and they do different jobs:
| Code | What it holds | Best for |
|---|---|---|
| Barcode | The asset tag itself | Scanners and fast audits |
| QR code | A web address that opens the asset record | Anyone with a phone camera |
Many teams print both on one label.
3. Name a holder for every item
An asset nobody is responsible for is the one that goes missing. Record who holds each item and keep the history of every handover. Then "what does Sara have?" and "who had the camera in March?" both have answers.
4. Record where things live
Set up places such as offices, sites, rooms or vehicles, and assign each asset to one. For larger sites, a floor plan with assets pinned on it helps new staff find things.
5. Plan the servicing
Vehicles, machines and safety equipment need regular service. Decide for each schedule whether it is fixed (keeps its original dates) or floating (counts from when the work was actually done). Keep warranties with the asset, and remember many warranties end on a date or at a usage limit, whichever comes first.
6. Audit regularly
The register only records what people said happened. An audit, where someone goes and looks, is what makes it trustworthy. Check high value and portable items every quarter and everything else once a year, and record the condition you find.
Which status and condition values should you use?
Keep the vocabulary small and clear. A status says what is happening to the asset: in stock, in use, in repair, reserved, in transit, retired, disposed, lost or stolen. Lost and stolen should stand out, because they are incidents someone must act on, not normal states.
Condition is a separate scale. The common asset management convention runs from 1 Very good to 5 Unserviceable, so low is good, the opposite of a star rating. Always show the number and the word together, and keep "not assessed" as its own honest value for items nobody has inspected yet.
When does a spreadsheet stop being enough?
A spreadsheet works for one location, one person and a few dozen items. It starts to fail when:
- several people issue and return equipment;
- you need a history of who held what, not just today's holder;
- servicing dates, warranties and insurance need reminders;
- your accountant wants depreciation and net book values;
- staff records live in another system and drift out of date.
That last point is often the real cost. The same employees appear in your HR records, payroll and asset register, and three copies of the same list never stay in step.
How ExecCortex handles asset tracking
The Asset Management app is built around the habits above. It keeps one register with status, condition and criticality; prints labels with both a barcode (the tag) and a QR code (a link to the record); records custody with a full handover ledger; places assets on floor plans; schedules maintenance as fixed or floating; and holds policies, claims, warranties and service contracts with each asset.
A few design choices matter for small teams:
- One staff directory. The people list is the same one the HR and invoicing apps use, so an employee exists once.
- One company record. Suppliers and service companies are shared with the CRM app when both are on.
- Depreciation computes, a person posts. Runs are shown for review and nothing writes into your books by itself.
- Separate permissions. Someone who books maintenance does not need to see what assets are worth, so those are different permissions.
Asset Management is a free app on the platform. Your plan sets how many assets a workspace can hold; see pricing for the allowances, or read how the apps fit together on the all in one business software page.
Frequently asked questions
What is the easiest way to track assets in a small business?
Start with one register listing every item, its tag number, holder and place, then label each item. Add service dates and a yearly audit. Software becomes worth it once several people issue equipment.
Should I use barcodes or QR codes for asset tags?
Use a barcode if you will audit with a scanner, and a QR code if people will use phone cameras. A QR code that opens the asset record is the most useful for staff; many labels carry both.
How often should a small business audit its assets?
Check high value and portable items every quarter and everything else at least once a year. Record the condition you find, so the register reflects reality rather than memory.
What should happen to assets when an employee leaves?
Pull the list of everything that person holds before their last day, collect or reassign each item, and record the handover. A custody history makes this a five minute job.
Do I need to track depreciation for small assets?
Your accountant decides the threshold, but tracking purchase date and cost for every asset makes year end far easier, and software can calculate net book values for you to review.