Before You Go Live on Oracle, You Have to Reconcile the Entire Organisation's Financial History.
You know what a trial balance is.
Every debit has a credit. Every balance agrees. Every account is accounted for.
Data migration is a trial balance — applied to the entire organisation's financial history.
Before an ERP goes live:
Every open supplier invoice must transfer to Oracle AP. Balance must agree to legacy AP sub-ledger.
Every open customer invoice must transfer to Oracle AR. Balance must agree to legacy AR sub-ledger.
Every asset on the fixed asset register must transfer to Oracle Asset Management. NBV must agree to the legacy register.
Every open purchase order must transfer to Oracle Procurement. Value must agree to the legacy commitment.
Every employee record must transfer to Oracle Payroll. Pay scale, pension rate, tax code — all must transfer correctly.
And all of it must reconcile to the closing trial balance of the legacy system.
Zero tolerance. One variance means the trial balance is wrong. And a wrong trial balance at go-live is a financial statement risk from Day 1.
The finance team are the only people who know whether the migrated numbers are right.
Not the Oracle consultants.
Not IT.
Not the Programme Director.
The accountants.
Discussion question: If your organisation went live on a new ERP tomorrow, which balance on your current system would you be most worried about migrating correctly — and why?
Fall4U FCA FCCA — Future Defined Academy