Every migration that goes wrong goes wrong in the same place: the opening balances. Here is the checklist we run, in order.
Before anything moves
Freeze the source. Pick a cut-off date and stop back-dating entries into the old system. Every migration that slipped did so because somebody kept posting.
The four passes
Import runs in four passes and the order is not negotiable:
- Masters - customers, suppliers, items. Nothing else can reference anything until these exist.
- Opening balances - per ledger, as at the cut-off.
- Open documents - unpaid invoices, unfulfilled orders, stock in hand.
- History - everything closed, for reference.
The reconciliation report
Nothing goes live until somebody has signed off:
- row counts per entity, source versus destination
- the total of opening balances per ledger, both sides
- a line-by-line list of what was skipped and why
- the trial balance, which must balance before and after
The one that always bites
If the opening balances are out by exactly the value of an advance, look for receipts sitting against a customer rather than against an invoice. Nine times out of ten that is it. Resist the adjustment entry - it hides the problem rather than fixing it, and it will surface again at year end.