Free asset tracking spreadsheet
Jump to download form ↓Enter your email below to download this asset tracking spreadsheet as a ready-to-use PDF.
Free asset tracking spreadsheet (PDF). Log check-in, check-out, current holder, last seen and location for each asset, and see where it breaks at scale.
Commercial Director
Key takeaways
- An asset tracking spreadsheet logs each movement of an asset: who checked it out, when, where it went and when it came back, so custody is never a guess.
- It tracks movement and custody over time, where an asset register or inventory captures a point-in-time snapshot. Use it for assets that move between people and sites.
- A shared spreadsheet works to roughly 100 assets; beyond that, version conflicts, stale rows and no audit trail make it unreliable as a custody record.
- Past that point a barcode or QR system that updates on a phone replaces manual rows and gives a tamper-evident movement history automatically.
Updated 4 June 2026
How to use: download the PDF, print or complete digitally on any device.
- PDF format, ready to print or fill on screen
- Use as-is or customise to suit your operation
- Go digital in MapTrack for photos, alerts and audit trails
Download free PDF template
Trusted by teams across Australia and New Zealand
We respect your privacy. Unsubscribe anytime.
Used by construction, mining and field service teams
What is a asset tracking spreadsheet?
An asset tracking spreadsheet is a movement log used to record where each asset is and who has it as custody changes over time. For each entry it captures the asset ID or tag, the asset description, the action (checked out or returned), the date and time, the person or crew taking or returning it, the location it moved to or from, and the expected return date. Unlike an asset register or inventory, which captures a snapshot of what you own at a point in time, an asset tracking spreadsheet is a running history of custody and location, so you can answer who had the laser level last and where it is right now.
Asset tracking spreadsheets are used across construction, trades, hire, facilities and field service wherever tools, test equipment and portable plant move between people, vehicles and sites every day. They are a sensible first step and this template will serve a small fleet well. Be honest about the limits, though: a shared spreadsheet starts to break at roughly 100 assets or once several people edit it at once. Rows go stale because updates rely on memory, two people overwrite each other, there is no real audit trail of who changed what, and a phone in the field cannot update it easily. In MapTrack, that same workflow becomes a scan: each asset carries a QR or barcode label, check-in and check-out updates the holder and location automatically, and the full movement history is kept against the asset without anyone maintaining rows. Under ISO 55001 and the record-keeping expectations of the WHS Regulations 2011, organisations are expected to know where the plant they hold is and who is responsible for it.
Learn more about asset tracking in MapTrack.
Benefits of using this asset tracking spreadsheet
- Custody visibility: a running log of who took each asset and when makes it clear who is responsible for an item right now.
- Loss prevention: recording the holder and location at each movement makes a missing or unreturned asset obvious quickly.
- Return discipline: an expected return date against each check-out flags overdue items before they are quietly lost or written off.
- Movement history: a dated log shows where an asset has been and how often it moves, useful for disputes, audits and utilisation.
- Honest scaling signal: built-in limits make it clear when a shared sheet has been outgrown and a scan-based system is the next step.
- Low barrier to start: a simple sign-out log needs no software and gets a small tool store under control in an afternoon.
- Audit support: a contemporaneous custody record helps account for assets during insurance claims, audits and incident reviews.
Benefits of digitising forms in MapTrack
When you move your asset registers from paper to MapTrack, you get:
- Field users can easily scan a QR code to complete a form on mobile. Unlimited users.
- Automatically get alerts when faults are identified.
- Link every form digitally as a PDF to the relevant asset, location or person.
- Receive a digital PDF copy with every submission to your email.
- Ability to share forms digitally.
- Build conditional logic (show or hide questions based on answers).
- Take pictures or attach photos. Not possible with a paper-based form.
- Electronic signatures.
- Edit forms later without reprinting.
- Restrict permissions (who can view, complete or approve).
- Build forms with AI (describe what you need and MapTrack suggests the form).
- Maintain a live asset register with location, condition and custody history.
- Schedule and track calibration, certification and warranty expiry dates.
- Generate depreciation and total-cost-of-ownership reports per asset.
Book a demo to see how MapTrack handles asset registers.
Try MapTrack free for 30 days
Full access to every feature. No credit card required. Per-asset pricing so you scale as your fleet grows.
- No credit card required
- 30 days free trial
- Cancel anytime
1-2 days/week saved
“Bloody amazing! We used to spend 1-2 days a week tracking and managing our generators alone.”
Steve McAllister
Asset Coordinator, Saunders International
What to include in a asset tracking spreadsheet
This asset tracking spreadsheet covers 10 key areas:
- Log details: organisation, prepared by, store or site, and the date the log was opened.
- Asset ID or tag: the unique identifier or barcode/QR tag number for the asset being moved.
- Description: a clear name for the asset, including make and model where it helps identification.
- Action: whether the asset is being checked out or returned at this entry.
- Date and time: when the movement happened, so the log reads as a chronological history.
- Holder: the person or crew taking or returning the asset right now.
- Location: where the asset is going to or coming from, such as a site, vehicle or store.
- Expected return: the date the asset is due back, so overdue items can be chased.
- Condition out and in: a quick note on condition at check-out and return to catch damage.
- Notes: defects, accessories included, or any action required.
How to use this asset tracking spreadsheet
- Set up the log columns and give every asset a unique ID or tag.: Confirm the columns you need such as asset ID, action, holder, location and expected return, then assign a unique identifier to each asset and label it physically. Consistent IDs are what let you tie every movement back to the right asset without confusion between similar items.
- Record a check-out line every time an asset leaves the store.: When an asset is taken, add a row with the asset ID, the date and time, the person or crew taking it, where it is going and the expected return date. Note the condition at check-out so any damage on return can be attributed fairly rather than disputed later.
- Record a return line when the asset comes back.: When the asset is returned, add a matching row with the date, who returned it and the condition in. The pair of check-out and return lines gives you a complete custody history for that asset and confirms it is back in the store and available.
- Review overdue items against their expected return dates.: Regularly scan the log for assets past their expected return date and follow them up with the holder before they are quietly lost. A short weekly review keeps custody tight and stops small losses compounding into a write-off at stocktake.
- Reconcile the log against a physical check and investigate gaps.: Periodically walk the store and compare what is physically present against what the log says is out, then investigate any asset that is neither in the store nor logged out. Correct the log so it stays an accurate record of where every asset actually is.
- Watch for the scaling limits and plan the move to scanning.: When the sheet passes roughly 100 assets, or several people need to update it at once, expect stale rows, version conflicts and no audit trail. That is the signal to move to a barcode or QR system, where check-in and check-out update automatically from a phone in the field.
In MapTrack, you can manage your full asset register digitally. Each submission is stored as a timestamped PDF against the asset record.
Get the free templateEnter your email above to download the full asset tracking spreadsheet as a PDF.Back to download formHow often should you complete this asset register?
Update an asset tracking spreadsheet at the moment of every movement: a line at check-out and a line at return, not from memory at the end of the day. Review overdue items weekly and reconcile the log against a physical check monthly, or before audits and insurance renewals. As the asset count and the number of people editing grow, the manual log gets harder to keep accurate. In MapTrack, the movement history updates in real time as assets are scanned in and out, so custody and location stay current without anyone maintaining rows by hand.
Frequently asked questions
Applicable regulatory standards
This template aligns with the following regulations and standards:
- ISO 55001 - Asset Management Systems (knowing and controlling the assets an organisation holds)
- WHS Regulations 2011, Chapter 5 - Plant and Structures (records of plant an organisation is responsible for)
- ISO 55000 - Asset Management (overview and principles of managing physical assets)
Need to manage your full asset register digitally?
Register every asset in MapTrack, attach digital forms, and get a complete history of every inspection, service and compliance record.