A school's spreadsheet and an office's email
A secondary school emails asking you to collect old IT equipment over the half term. Attached is a spreadsheet exported from their asset system: two hundred rows with asset tags, model names, serial numbers, and a column that says "dead" or "working". The same morning an accountancy firm emails a list typed into the body of the message: "about 30 PCs, some monitors, 4 printers, a server and a box of cables".
Your office has to turn both into a booking. How many cages, what size vehicle, how many people, which items need data wiping, which are large household style appliances. The school's spreadsheet uses model names your team has never seen. The accountancy firm's list is guesswork. The office retypes both into your own booking sheet, estimates, and books.
On collection day the driver finds the school has added a stack of interactive whiteboards and the accountancy firm has twice as many monitors as they said. The vehicle is too small. A second trip is booked.
Why every booking starts from scratch
Businesses disposing of electrical equipment describe it in their own terms, and your team needs it in yours.
- Every customer's asset list has different columns, names and levels of detail.
- Items need mapping to your categories for handling, pricing and reporting.
- Data-bearing items must be identified at booking, not discovered on arrival.
- Estimated quantities are often wrong, so vehicles and cages are wrong too.
- Nothing checks what arrives against what was booked, so missing or extra items go unrecorded.
What messy bookings cost
Retyping asset lists takes office time for every booking, and errors carry through to collection and processing. Wrong vehicle sizes and second trips cost fuel and driver time. Items that should have been flagged for data wiping and were not create a risk you do not want.
Customers also notice. A business that sent a careful asset list expects a certificate or report that matches it. If you cannot reconcile what arrived with what they sent, their IT manager has a gap in their own records and you look careless.
How we turn asset lists into bookings
What we build accepts the customer's list in whatever form it comes and turns it into a structured booking.
- Customers book through a form on your website, uploading their own spreadsheet or typing a rough list. Emailed lists can be forwarded into the same intake.
- Columns are mapped automatically where possible, and a language model, for example OpenAI or Anthropic Claude, suggests your category for each item from its description or model name. The office confirms or corrects the mapping.
- Data-bearing items, such as PCs, laptops, servers, phones and some printers, are flagged from their category so they are handled separately from collection onwards.
- The booking calculates cages, pallets and vehicle size from the categorised list, and the office adjusts where they know better.
- At your site, items are checked in against the list by scanning asset tags or serial numbers, with differences recorded: missing, extra, or different from described.
- The check-in result feeds your processing records and the customer's report or certificate.
| Customer's list says | Mapped to | Flag |
|---|---|---|
| Desktop PC, model name | IT, desktop | Data-bearing |
| Monitor 24 inch | Display equipment | None |
| Interactive whiteboard | Display equipment, large | Handling |
| Server | IT, server | Data-bearing |
| Box of cables | Cables | None |
The school's booking with the new intake
The school uploads its spreadsheet on the booking page. The categories are suggested for every row, and the office corrects the few it got wrong. The booking shows the data-bearing items and calculates the cages and vehicle. The form also asked whether there was anything not on the list, and the school mentioned the whiteboards, so the right vehicle goes.
At your site, items are scanned in against the list. Three laptops on the list did not arrive; the school is asked about them. The report the school receives matches their asset register line for line, with the three laptops marked as not received.
Do WEEE bookings start with retyping?
- Every customer sends a different list format.
- The office retypes asset lists into a booking sheet.
- Vehicles and cages are often the wrong size for the job.
- Data-bearing items are sometimes identified only on arrival.
- You cannot say which listed items did not arrive.