Reconciliation and proof of migration
You will be able to: List the tie-outs that prove a migration; Document differences and get accountant sign-off; Use Zeyto's reconciliation downloads and reports.
- Read not done yet
- Self-check: not taken not done yet
- Lesson complete not done yet
Proof of migration means independent evidence that the new system holds what the old one held. 'It looks right' is not proof. Write the tie-outs into the plan and run them on every rehearsal and on the final load.
| Control | Old system figure | Zeyto figure | Expected |
|---|---|---|---|
| Trial balance | Signed trial balance at cut-over | Trial Balance report at the cut-over date | Equal, and total debit equals total credit |
| Opening Balance ledger 3900 | None | Ledger balance after all openings | Zero |
| Customer receivables | Ageing total by invoice | Aged receivables report and the receivable control account | All three equal |
| Supplier payables | Ageing total by invoice | Aged payables report and the payable control account | All three equal |
| Stock | Stock valuation by item | Stock report, and Inventory in the ledger | Equal quantity and value |
| Bank and cash | Bank statement and cash count | Book balance of each account | Equal after reconciling items |
| Counts | Number of customers, suppliers, items | Counts in Zeyto | Equal, or excluded rows listed |
In Zeyto, the Opening Balances screen offers a reconciliation download (Excel, PDF or CSV) with a Section column: Accounts, Customer bills, Supplier bills, Stock, Totals and the Balancing entry. For migrations with the tool, the certificate adds proof by document type and by document.
Differences log
Differences will exist. Record each one with its reason and a decision by the accountant. A difference with no explanation blocks sign-off.
Sign-off form
- Controls listed with old figure, Zeyto figure and difference.
- Each difference with reason, owner and decision.
- Statement: balances loaded are agreed as the opening position at the cut-over date.
- Signatures: accountant, sponsor, consultant, with date.
Practise in the demo
- Draw your own reconciliation table for a client with controls, old and new figures.
- In the demo, open Reports and find the Trial Balance and an ageing report. Note the date filters.
- 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.
Public demo company, sign in as admin / demoAdmin123. Data refreshes nightly.
- Prove migration with tie-outs, not impressions.
- 3900 must be zero and receivables, payables and stock must tie to the old listings.
- Every difference needs a reason, an owner and the accountant's decision.
Check yourself
1 question on this lesson. Not timed, not the exam, and you can try again. Score 60% or more, and read the lesson, to complete it.