Automating School Asset Tracking, from Lab Equipment to Classroom Furniture

Ask a school how many projectors it owns and you will usually get two answers: the number in the stock register and the number someone counts on a walk round. They rarely match. The register was last updated when the auditor visited, and since then projectors have moved rooms, two have broken, and one went to the principal's office "for a week".

Asset tracking sounds like an accounting job. In practice it is a teaching job too: a chemistry practical cannot run if the burners are in a store room no one can find.

What counts as an asset

Most schools track three tiers, each with a different level of detail:

1. High value, individually tracked. Projectors, interactive panels, laptops, lab instruments, musical instruments, sports equipment over a threshold. Each gets a tag and a record.
2. Furniture and fixtures, tracked by room. Benches, desks, chairs, cupboards. Count per room, not per item.
3. Consumables, tracked by stock. Chemicals, chalk, paper, sports balls. Track quantity and reorder level, not identity.

Trying to tag every chair is how asset projects die. Tag the first tier, count the second, and stock the third.

A setup that survives the second year

• One owner per room. The lab assistant owns the lab inventory; the class teacher owns the classroom count. A register owned by "the office" is owned by nobody.
• A tag on every tier-one item, with a number that matches the record. A QR code is useful if someone will scan it; a printed number works too.
• Record the purchase. Date, cost, supplier, warranty end. This is where asset tracking meets the school's spending.
• Record movement. When the projector goes to the hall for the annual function, the record says so.
• Count twice a year. At the end of each term, the room owner checks the list and marks what is missing or broken.

What software adds

A paper register can hold all of the above. Software adds three things a register cannot:

• Search. "Where are all the projectors?" is a filter, not a walk round.
• Alerts. A warranty ending next month, a consumable below its reorder level.
• The link to spending. When a repair or replacement is recorded as an expense against the asset, the school can see which items cost the most to keep running. We cover the money side in monitoring operational costs and stopping budget leakage.

Where Onflows fits

Onflows records what the school spends by category, with receipts and a monthly picture, in its expenses module. A dedicated asset register with tags and room counts is not something we offer today. Schools that need one often keep the asset list in a spreadsheet and record purchases and repairs as expenses in Onflows, so the spending side is clean and auditable.

If an asset register is what would decide your purchase, tell us when you sign up. The roadmap is ordered by those requests.

The lab case

Lab equipment deserves its own note because it affects teaching directly. Before each term:

• Check the practicals in the syllabus against the equipment list.
• Flag any practical that cannot run because an instrument is missing or broken.
• Order replacements before the term starts, not when the class is waiting.

A school using subject workspaces to plan the term can attach the equipment list to the subject, so the teacher planning the practical sees it.

Frequently asked questions

Do we need barcode scanners?

No. A phone camera reads QR codes, and a printed number is enough for a twice-yearly count.

How do we handle donated items?

Record them like purchases with a cost of zero and the donor's name, so they appear in the count and the audit.

What about writing off broken items?

Record the write-off with a date, a reason and who approved it. Never delete the record; the history explains the count.

See what Onflows tracks for the school office, or create your school and start recording expenses by category.