What a Small Company Should Prepare Before Building an ERP
Most ERP projects that go wrong do so before a line of code is written. These are the things I ask companies to prepare first, from building ERP systems for [a property group](/projects/terra-group/) and for [manufacturers, traders and service businesses](/projects/confidential-client-systems/).
1. Write down how the work is done today
Not how it should be done: how it is done. Which spreadsheet holds stock, who keeps the price list, which WhatsApp group approves a discount, where invoices are typed. A system built on the real workflow gets used; one built on an ideal workflow gets worked around.
2. Clean the data you already have
- One customer list instead of five, with duplicates merged.
- One product or item list with codes that do not change.
- Opening balances you trust: stock counts, outstanding invoices, deposits.
Moving messy data into a new system only makes the mess harder to see.
3. Start with one module that hurts most
Stock, sales orders, project costing or customer follow-up: pick the one that causes the most daily pain, put it live first on real data, and add the rest once people trust it. A small first version that works beats a complete design that is still on paper a year later. For a property company, the same order applies: see how a property company can use IT to grow.
4. Name an owner for every part
Each module needs one person in the company who decides how it should work and answers the developer's questions. Without that person, decisions stall and the system drifts away from what the business needs.
5. Plan the switch-over
- Run the old and new way side by side for a short, fixed period.
- Train the people who enter data, not only the managers who read reports.
- Decide the date after which the old spreadsheet is no longer updated.
6. Keep your data yours
The system should run on accounts and databases the company owns, with backups it can reach. If the developer disappears, the business should still have its records. See how I work with clients.
