What's in the template
This serial number tracking template is a register for products you stock and sell by individual unit: inverters, batteries, laptops, power tools, instruments, medical devices. Each row is one physical unit, identified by its serial number, with the product it belongs to, where it is, and what has happened to it.
When a unit sells, the sale date, customer and order reference go on that same row. That is what makes the sheet useful later: a warranty claim, a return or a recall becomes a search on one serial number instead of a dig through invoices.
Columns explained
| Serial_Number | The unique number of this one unit, as printed by the manufacturer or assigned by you. |
| SKU / Product_Name | The product the unit belongs to, so you can still count units per product. |
| Status | In stock, Sold, Returned, In repair or Scrapped (a dropdown in the Excel version). |
| Location | Warehouse and bin for units in stock; a dash once the unit has left. |
| Received_Date / Supplier | When and from whom the unit came in, for supplier warranty claims. |
| Lot_Number | The production batch, if the supplier provides one. Needed when a recall is issued by lot rather than by serial. |
| Sold_Date / Customer / Order_Ref | Who received this exact unit, when, and on which order. |
| Warranty_Months | The warranty period you give on this product. |
| Warranty_Expires / Warranty_Status | Calculated in the Excel version: sale date plus warranty months, and whether that date has passed. |
| Duplicate_Check | Calculated in the Excel version: flags a serial number that appears on more than one row, usually a typo. |
How to use it
- Receiving: add one row per unit as it arrives, with its serial number, status In stock, location and supplier.
- Selling: find the unit's row, set Status to Sold and fill in Sold_Date, Customer and Order_Ref.
- Warranty claims: search the serial number. The row shows the sale date and, in the Excel version, whether the unit is still under warranty.
- Returns and repairs: change the status to Returned or In repair and note the reason, so the unit is not sold again by mistake.
- Recalls: filter on Lot_Number or a range of serial numbers to get the list of customers who received an affected unit.
Where a serial number spreadsheet breaks down
A spreadsheet works while one person handles a few dozen units. It gets fragile when serials are typed by hand (one wrong character and the unit cannot be found), when two people edit the file at once, and when you need the history of a unit: overwrite the Status cell and the earlier return or repair is gone.
That is the point to move to serial number tracking software: serials are scanned from the barcode instead of typed, every status change is logged, and the lookup works from a phone on the shop floor. StockFlow's free plan includes serial number tracking.
Related resources
Trusted by small businesses
What our customers say
“Super Kind! Quick replies from their support and very easy fixes, changed the dashboard a bit and customized it. Also gave me 450 items extra on the free plan just for me. Highly recommend and again great service!”
“Best customer service! Stockflow's customer support is fast and extremely helpful. They assisted me with customization of the software to improve my experience as a user.”