Moving to an ERP: a practical plan from spreadsheets to your first invoice
Moving off spreadsheets or an old system need not be a long project. The order matters: set up the organization, then master data, then opening balances, then users and permissions.
Before you start: pick a go-live date
Choose the date you start working in the new system, ideally the start of a month or fiscal year. Everything before it goes in as opening balances; everything after it is recorded as transactions in the system.
Stop recording in the old spreadsheets on that date, so your team does not work from two sources.
Step 1: set up the organization
Start with the settings the rest of the data depends on: the chart of accounts and posting routing, currencies and taxes, numbering sequences and print templates.
- Review the defaults before applying them
- Change only what is specific to your business and keep the rest
- Confirm the current fiscal year and its start date
Step 2: bring in master data
Master data is what every transaction refers to. Clean it in Excel before importing; duplicates and gaps are imported as they are.
| Data | Why in this order |
|---|---|
| Items, units and categories | Needed by invoices and opening stock |
| Customers and suppliers | Needed by invoices and opening receivables and payables |
| Employees | Needed by permissions and HR |
Step 3: enter opening balances
Opening balances link your history to the new system. Enter account balances, stock quantities and cost in each warehouse, and customer and supplier balances at the go-live date.
Then compare the trial balance in the system with your last one; they must agree before any new transaction.
Step 4: users and permissions
Give each employee only what their job needs. Start from a ready-made role close to the job and adjust permissions where needed.
- Separate whoever enters a document from whoever posts or approves it
- Hide cost from those who do not need it, such as sales representatives
- Turn on one-time codes for users with sensitive permissions
Step 5: the first week
Start with real daily work: sales and purchase invoices and vouchers. At the end of each day, check that the automatic entries land in the right accounts and that stock balances make sense. Small mistakes in week one are easier to fix than month-end ones.