How to Track School Laptops & Lab Equipment (No Spreadsheets)

Every school has a version of the same story. A set of laptops was bought for a class, a few went to a teacher “just for the term,” one is in a drawer in the science lab, and nobody can say for sure how many exist. The spreadsheet that was supposed to track them was last updated in September.

Spreadsheets aren’t a bad tool. They’re just the wrong tool for equipment that moves between people and rooms every week. This guide shows a practical way to track laptops, tablets and lab equipment without them, and how to keep it running with very little admin time.

Why spreadsheets break down in schools

• No history. A spreadsheet shows who has a laptop now, but it overwrites who had it last month. When something goes missing, that history is what you need.
• Nobody owns updates. Equipment moves all day. If updating the sheet is a separate chore, it doesn’t happen.
• Duplicate and mismatched entries. Typing serial numbers by hand guarantees typos, so the same device can appear twice or not at all.
• Hard to audit. A term-end check means walking around with a printout and comparing it to what you find.
• No accountability for the person holding the item. A name in a cell isn’t the same as a staff member confirming they received it.

A simple system that works

Step 1: Count and label everything once

Start with a one-time inventory. Give every laptop, tablet, projector and piece of lab equipment its own unique ID, and stick a durable QR label on it. From this point on, the label is how the item is identified, not its description or whoever remembers where it went.

Step 2: Record the same few details for every item

Keep it short so it actually gets done:

• Item name and category (laptop, microscope, tablet)
• Serial number
• Location (room, lab, office)
• Purchase date and funding source, if you report on either
• Condition

Step 3: Assign every item to a person or a place

An item that belongs to “the school” belongs to nobody. Assign laptops to the teacher or student who has them, and assign shared lab equipment to the room or department. When ownership changes, the system records it, so you keep a history of who had what and when.

Step 4: Use check-out and check-in for anything that moves

Loaner laptops, camera kits, lab instruments and trolleys of tablets should be checked out and back in, ideally by scanning the QR label. It takes seconds and replaces the question “who last had this?” with a clear record.

Step 5: Let people see their own equipment

When staff can look up what’s assigned to them, they notice errors before an audit does, and they’re more likely to return things on time. Employee self-service features exist for this reason.

Step 6: Audit by scanning, not by hunting

At the end of each term, walk each room and scan the labels. Anything you didn’t scan is your short list of items to find. This turns a multi-day audit into a few hours.

Step 7: Retire equipment properly

When a device is sold, donated, recycled or written off, mark it as retired instead of deleting the row. You keep the record for finance and for disposal rules, and the active list stays clean.

Common mistakes to avoid

• Labelling only the expensive items. Chargers, cameras and small lab kits go missing too.
• Trying to do everything at once. Start with laptops and one lab, then expand.
• Giving everyone edit access. Use roles so only the right people can change records.
• Skipping the handover moment. The point of check-out is that someone confirms they have the item.

Which tool to use

You need software that does four things well: asset records with labels, assignments with history, check-in and check-out, and reports you can export for audits. Equiply is built around exactly these tasks for small teams. It uses QR code labels and check-in and check-out workflows, and it has employee self-service and reporting. There’s a free plan for up to 150 items, which is enough to start with one school, one lab or one set of laptops.

A realistic first week

1. Day 1: Count the laptops and tablets and print labels.
2. Day 2–3: Label devices and add them with their assigned person or room.
3. Day 4: Add your most-used lab equipment.
4. Day 5: Show staff how to check out and look up their own equipment.

After that, the system mostly runs itself, because updating a record becomes part of handing the item over.

Frequently asked questions

What is the best way to track school laptops?

Give every laptop a unique ID and a QR label, assign it to a person or room, and use check-out and check-in whenever it moves. Then audit by scanning labels instead of comparing printouts.

What information should I record for each device?

The item name, serial number, location, who it’s assigned to, purchase date and condition. Add the funding source if you report on it.

How often should a school audit its equipment?

At least once a year, and a short scan at the end of each term catches missing items much sooner.

Can a small school do this for free?

Yes. Equiply’s free plan covers up to 150 items, which is enough to start with one set of laptops or one lab.

Replace the spreadsheet

You can label what you own and have a working system in a week. Try Equiply free at equiply.net.