The short answer
The most reliable way for a factory to move off Excel, WhatsApp and paper registers is in stages that follow the material: clean up master data first, then move requisitions and purchase orders, then receiving and quality, then stock and traceability. Run each stage in parallel with the old method for a short, fixed period and retire the old sheet once the new records are trusted.
Why Excel works — until it does not
Excel and WhatsApp are fast, flexible and already on everyone’s phone and laptop. For a small team they are often the right tool. The limits appear gradually: several people editing copies of the same sheet, approvals that exist only as chat messages, and no link between the PO, the receipt, the inspection and the stock figure.
Signs it is time to move:
- Different people give different answers to "how much do we have?"
- Tracing a batch takes hours of searching registers and chats.
- Approvals are disputed because nobody can find the message.
- One person going on leave slows down purchasing or stores.
A practical sequence
- Masters first: build clean lists of materials (with codes and units), suppliers, warehouses and bin locations. Remove duplicates like "MS Sheet 2mm" and "M.S. sheet 2 mm".
- Requisitions and approvals: move material requests and their approvals out of chat. This is usually the quickest win and the easiest habit to build.
- Purchase orders: raise POs against approved requisitions, with delivery dates.
- Receiving and quality: record GRNs against purchase orders with batch numbers, and inspection results with accepted and rejected quantities.
- Stock and traceability: take an opening stock count by batch and location, then let stock be driven by quality-accepted receipts. Label lots.
Getting opening stock right
Opening stock is where most migrations go wrong. A figure copied from the old sheet carries its errors into the new system on day one.
- Pick a cut-off date and count physically, by material, batch and location.
- Freeze issues and receipts briefly during the count if you can.
- Label counted lots as you go, so the physical and system records match from the start.
- Accept that very old material may have no traceable batch — record it honestly rather than inventing history.
Bringing the team along
- Start with the people who feel the pain most — usually purchase and stores.
- Give each person access only to the modules they need.
- Set a date when the old sheet or register stops being updated, and keep to it.
- Review the first few weeks together; fix master data issues as they surface.
Starting with mosaicOne
mosaicOne follows this sequence: masters for suppliers, materials, plants, warehouses and bins; then requisitions and approvals; purchase orders with delivery batches; GRNs and quality inspection; and inventory with lot labels and batch traceability. It does not replace accounting software. A demo walks through how your current sheets and registers map to each step.
Key takeaways
- Move in stages that follow the material, not all at once.
- Clean master data before anything else.
- Count opening stock physically, by batch and location.
- Set a firm date to retire each old sheet.