How to track company assets: from Excel to software

Almost every asset register starts life as a spreadsheet, and for good reason: it is free, flexible and everyone knows how to use it. The trouble starts gradually. A second person edits it. A third saves a copy. Someone sorts one column without the others. A year later, nobody is quite sure which version is right.

This article covers how to track company assets in practice: the steps that work whatever tool you use, how to track assets in Excel properly, how to tell when you have outgrown the spreadsheet, and how to move to dedicated asset management software without losing data or momentum.

Already decided? You can start a free Asetavo workspace — the Starter plan is free forever for up to 100 assets and 2 users — and bring your spreadsheet across yourself with the self-serve Excel/CSV import wizard. The steps are in Import your Excel register in minutes below.

How to track company assets, step by step

These seven steps are the same whether you use a spreadsheet, software or a clipboard. Most tracking problems come from skipping one of them.

1. Decide what counts as an asset. Set a simple rule, such as "anything over $500, plus every laptop, phone and power tool, whatever it cost". Write the categories down: IT, furniture, tools, vehicles, machinery.
2. Put everything in one register. One list, one row per item, owned by one named person. If the IT team, the workshop and finance each keep their own list, none of them is right.
3. Give every asset a unique ID and a tag. Use a simple numbering scheme (for example AST-0001) and stick a label with that ID on the item — ideally a QR code or barcode, so it can be scanned rather than read and typed.
4. Record where it is and who has it. Use fixed location names (site, building, room) and a named custodian for every item. "Somewhere in the warehouse" is not a location.
5. Record every change when it happens. Moves, loans, returns, repairs and disposals should be written down at the time, not at the end of the month. For equipment people borrow, use a check-out with a due date.
6. Count it regularly. Walk the sites at least once a year (more often for laptops and tools), check each item against the register and investigate anything missing. Our physical asset audit checklist lists what to prepare.
7. Use the data. Review what is overdue, what is due for service, which warranties expire and what is worth what. A register nobody reads soon stops being updated.

How to track equipment in a company

Equipment that people share — tools, test kit, cameras, laptops, vehicles — needs one extra habit on top of the steps above: check-out and check-in. Every time an item leaves the store or the shared shelf, record who took it, when, and when it is due back; when it comes back, record its condition. That single habit answers the question people ask most ("who has the drill?") and makes losses traceable. Read more in our article on tool and equipment check-in/check-out.

How to track assets in Excel

A spreadsheet can work well for a small register if it is set up with discipline. To start from a ready-made layout, download our free asset tracking spreadsheet template, or follow these rules:

• One row per asset, one column per fact. Typical columns: Asset ID, Name, Category, Make and model, Serial number, Location, Custodian, Purchase date, Cost, Condition, Status and Notes.
• Format it as an Excel table (Insert, then Table) so filters, sorting and new rows behave, and freeze the header row.
• Use drop-down lists (Data, then Data Validation) for Category, Location, Custodian, Condition and Status, so "Warehouse B" never becomes "Whse B".
• Keep a separate Movements sheet with Date, Asset ID, From, To, Person and Reason. The main sheet shows where things are now; the Movements sheet is your history.
• Protect the ID and formula columns, and keep the file in one shared location with version history rather than emailing copies.
• Print the Asset ID as a barcode or QR label and stick it on the item, so counts are quicker and IDs are not mistyped.

What is the best way to track company assets?

It depends on how many assets you have, how often they move and how many people touch the register:

• A few dozen items that rarely move, one person in charge: a well-structured spreadsheet is enough.
• Shared equipment, several people updating, items lent out: asset tracking software with QR or barcode labels scanned by phone. This is where most growing companies end up, and it can be free to start — see free asset tracking software.
• Hundreds of items counted often, or things that must not leave a building: add UHF RFID readers for bulk counts and exit alerts.
• Vehicles and heavy plant spread across sites: add GPS trackers for a live position.

Whatever you choose, the steps above still apply: the tool only makes them faster and harder to skip.

What spreadsheets do well

It is worth being fair to the spreadsheet first. For a small, stable register with one owner, it is hard to beat:

• Zero cost and zero setup.
• Total flexibility — add a column whenever you need one.
• Familiar formulas for simple depreciation and totals.
• Easy to share as a file for an auditor or accountant.

If you have a few dozen assets, they rarely move, and one person maintains the list, a well-structured spreadsheet may be all you need. Our free asset register template is a good starting point.

The signs you have outgrown it

Most teams move on when several of these become true:

1. More than one person needs to update it. Concurrent edits, emailed copies and "final_v3" files are the most common source of register errors.
2. Assets move or get lent out regularly. A spreadsheet stores a current state, not a history. You cannot see who had the drill last Tuesday.
3. Audits take days of re-keying. Counting on paper and then typing the results back in is slow and error-prone.
4. You need to scan tags. Spreadsheets cannot open a record from a QR code or read an RFID tag.
5. Maintenance is tracked somewhere else — or nowhere.
6. Depreciation formulas have become fragile. A copied formula or a hard-coded override can silently change the fixed-asset total.
7. You cannot answer simple questions quickly — "What is checked out right now?", "What warranties expire this quarter?", "What is our NBV by site?"
8. Access control matters. In a spreadsheet, anyone who can edit a cell can edit every cell, and there is no reliable audit trail of who changed what.

What you gain from dedicated software

• One live source of truth with role-based access, instead of copies.
• History on every asset — every movement, check-out, repair and value change, with who and when.
• Scanning with a phone or reader, so records are opened and updated by scanning, not searching.
• Custody workflows — check-out, due dates, overdue alerts.
• Audit sessions that compare what was scanned with what was expected, automatically.
• Maintenance records attached to the asset.
• Depreciation that is calculated consistently, with schedules you can reproduce.
• Reports and exports without rebuilding pivot tables each month.

What you give up — and how to mitigate it

Be honest about the trade-offs:

• Subscription cost. Compare it with the time currently spent maintaining, reconciling and auditing the spreadsheet, and with the cost of duplicate purchases and losses.
• Less ad-hoc flexibility. You work within the software's data model. Good software lets you add custom fields and export everything, so you can still analyse data in Excel when you need to.
• Change management. People have to learn a new tool and new habits. Keep the first rollout small.

A migration plan that works

1. Clean up before you move

Migrating a messy spreadsheet just produces a messy database. Before migration:

• Remove duplicate rows and obviously disposed assets.
• Standardize categories and locations into fixed lists (no free-text variations like "Warehouse B", "Whse B" and "WH-B").
• Make sure every asset has a unique ID.
• Split combined fields (for example, "Dell Latitude 5440 SN: ABC123") into separate columns.
• Separate capitalized assets from tracking-only items.

2. Decide your structure

Agree the category list, location hierarchy (site → building → floor → room), custodians, statuses and the fields each category needs. Our guide on how to build an asset register covers this in detail.

3. Map the columns

For each spreadsheet column, decide which field it maps to in the new system — or whether it is dropped. Pay particular attention to dates (format consistency), currency values and financial fields such as cost, in-service date, useful life and accumulated depreciation to date.

4. Import and verify

Import a pilot subset first (in Asetavo, the import wizard's review step catches problem rows before they are created), spot-check it against the spreadsheet, fix mapping issues, then import the rest. Verify totals: asset count by category and, for capitalized assets, total cost and NBV should match the spreadsheet (or the difference should be explained).

5. Tag and baseline

Once records are in, label the assets and run a first physical audit. This creates a verified baseline — and usually finds the gaps the spreadsheet had been hiding.

6. Switch off the spreadsheet

Make the old file read-only and archive it. Running both in parallel for more than a short, defined period guarantees they diverge.

Import your Excel register in minutes

Once your spreadsheet is cleaned up (step 1 above), moving it into Asetavo is self-serve. There is no data-entry project and no need to wait for an onboarding call:

1. Upload — create a free workspace, open Import and upload your Excel (.xlsx) or CSV file.
2. Map columns — match each spreadsheet column to an asset field: asset ID, name, category, location, custodian, serial number, cost and so on. Columns you do not need can be skipped.
3. Review — the wizard flags problem rows (a missing ID, a date it cannot read, a duplicate) before anything is created, so you fix them instead of importing them.
4. Import — Asetavo creates the assets, plus any missing categories, locations and custodians it found in the file.

A sensible first run is one site or one category: import it, spot-check a few records against the spreadsheet, then import the rest. For very large or messy registers, import in batches — one site or category at a time — so each review step stays manageable.

Getting data out is always in your hands too — reports export to Excel or CSV on every plan, and the REST API (Business plan) gives programmatic access to your register.

After import, the register, tagging, check-outs, audits and stock-takes, maintenance and depreciation all work from the same records. The Starter plan is free forever for up to 100 assets and two users with QR and barcode tagging, so a pilot on one site costs nothing — see pricing for larger registers.

Prefer to see it first? Book a demo and bring your spreadsheet — we will show you how your register maps into Asetavo.

For a full rollout plan — including tagging thousands of assets — read the asset management software implementation guide.