Moving to an ERP: a practical plan from spreadsheets to your first invoice

· 5 min read

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.

Order for importing master data
DataWhy in this order
Items, units and categoriesNeeded by invoices and opening stock
Customers and suppliersNeeded by invoices and opening receivables and payables
EmployeesNeeded 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.

See AlMuraji run operations like yours

Tell us about your business and the modules you care about, and we will arrange a demo.