Module 24 · Advanced · 8 min read

Migration strategy: what moves and when

You will be able to: Choose between opening balances only, open documents, full history and archive; Pick a cut-over date and name a data owner for each data set; Match each option to the Zeyto tool that supports it.

  • Read not done yet
  • Self-check: not taken not done yet
  • Lesson complete not done yet

Data migration is the part of a project clients underestimate most. Start with three questions: what data moves, how much history comes with it, and on which date does the old system stop and Zeyto start? The answers drive every later plan.

Four layers of data

  • Masters: chart of accounts, customers, suppliers, items, price lists, units, warehouses.
  • Opening balances: the balance of each account, each open customer and supplier invoice, and stock, as at the cut-over date.
  • Open items: unpaid invoices and bills, cheques not yet cleared, orders not yet delivered.
  • History: closed invoices, receipts and stock movements of past periods.

The options

OptionWhat movesZeyto meansFit
A Masters and opening balancesLists plus balances at the cut-over date, bill by billImport Center and Accounting, OpeningsDefault for most clients
B Option A plus open ordersAlso orders still to deliver, re-entered as documentsManual entry or import where supported, planned in the blueprintDistributors with big open orders
C Full history replayEvery past document posted again through ZeytoMigration Tool, for Emeron onlyOnly when transaction-level history is required in Zeyto
D Read-only archiveOld system kept for referenceRestored backup, exported reports, PDFsAlways, alongside A or B

Replaying history is not free. Every old document must be clean enough to post, so history multiplies cleansing and review work. Most clients are satisfied by correct balances plus a read-only copy of the old system. Ask the accountant what the client really needs for audit and tax records, and write the answer in the blueprint.

Choosing the cut-over date

Pick a date that is easy to prove: a month end, ideally a financial year end. Balances at that date should be available from the old system as a trial balance, an ageing listing and a stock valuation. In Zeyto the Opening Date must fall inside an open fiscal year, so check Fiscal Years first.

6,800 items, 4,500 that matterA distributor's old list has 6,800 items. Cleansing shows 2,300 had no movement in three years and no stock. The client agrees to load only the 4,500 active items and keep the rest in the archive. Load time, training time and mistakes all fall. The decision and its owner go in the blueprint.

Who owns the data

Name a client owner for each data set: the accountant for the chart and balances, the sales manager for customers, the purchasing manager for suppliers, the storekeeper for items and stock. Owners clean and approve the files. The consultant maps and loads.

Watch outNever promise to migrate history before checking its quality. History in the old system is often unbalanced, mis-dated or incomplete, and every such item becomes review work.

Practise in the demo

  1. Write a one-page migration strategy for an imaginary client: options chosen, cut-over date, data owners and archive plan.
  2. In the demo open Settings, then Import Center and list the lists that can be imported. Note which are masters and which are opening balances.
  3. Open https://demo.zeyto.app/demo-app/ and sign in with the demo login. This is a public demo with sample data, so nothing you do there affects a real business.
Open the live demo

Public demo company, sign in as admin / demoAdmin123. Data refreshes nightly.

Key takeaways
  • Decide what moves, how much history and the cut-over date before any file is prepared.
  • Most clients need masters, bill-by-bill opening balances and a read-only archive.
  • Name a client owner for each data set.

Check yourself

4 questions on this lesson. Not timed, not the exam, and you can try again. Score 60% or more, and read the lesson, to complete it.

1. Which migration option is the usual default for most clients?

2. Which question belongs at the very start of migration planning?

3. What is the best date for a cut-over?

4. A client with a different accounting system wants ten years of history loaded by the Migration Tool. What is the right advice?

Practice questions for this module · Printable study sheet