Video walkthrough
Coming soon
How asset tracking usually works
An asset register answers three questions about every piece of equipment: what it is, where it is, and what state it is in. The hard part is never building the first list — it is keeping that list true as things move, break and change hands.
- Tag everything once Give each asset a durable barcode or QR label — a tool, a laptop, a machine. That tag becomes the asset’s permanent ID; the row in the sheet becomes its history.
- Scan to change status When something is issued, returned or sent for repair, scan its tag and set the new Status from the dropdown — In use, Available, Repair. The row updates in place, so each asset keeps a single living entry.
- Capture where it is and who has it Record the location or the person it is assigned to on each scan, so you always know who touched it last and where it should be.
- Photograph the evidence Snap the label, the serial plate or any damage straight into the Photo column — invaluable for audits, insurance claims and handovers.
- Audit at any moment Every change is timestamped on one row per asset, so the sheet is an always-current register you can filter by status, location or owner whenever someone asks “where is it?”.
Set it up in one scan
Already have Barcode Sender? Scan this code with your phoneTap below and the app opens with this template ready to go.
Open in the appSet up your sheet
- Make a copy — this drops a ready-made copy of the sheet into your own Google Drive.
- Share it as Editor — in the sheet, Share → “Anyone with the link” → Editor, so Barcode Sender can write to it.
- Connect it in the app — open Barcode Sender, add a sheet, paste the link and pick the worksheet. The columns fill in automatically.
- Scan — hit scan and watch rows land in your Google Sheet in real time.
