It is a great feeling to complete a conversion. I often cannot wait to hand it back to the client and get them started in Xero. However, it is really good to run a final check that makes sure that the conversion is really 100% as it was in the old system.
Our Post Conversion Checks
- Save Conversion Balances
- Compare Aged Receivables
- Compare Aged Payables
- Review Account Balances
- Bank Reconciliation Check
- GST Reconciliation Report
- Locked Down?
It does not matter whether you did the conversion yourself or got one of the conversion services to do it for you, this check uncovers problems easily and quickly and minimises the risk that your client comes back to you later saying something was wrong. At Jet Convert we find a fresh pair of eyes picks up issues more readily and always have a different person running these checks, not the one who worked on the conversion.
1) Save Conversion Balances
This might seem a silly step, but it is absolutely essential. Without this all your figures might be out. Just go to Settings – General Settings – Conversion Balances and press Save.
The second reason is that this will make sure the Accounts Receivable and Accounts Payable actually match the invoices and bills. If you can save the conversion balances that means they do match. If they do not, Xero will not allow you to save the balances and you know there is something wrong.
2) Compare Aged Receivables
Once you are clear that the Debtors and Creditors totals are correct (through the conversion balances saving without a warning), it is time to look at the details.
- Choose any month after the conversion date.
- Review the total first.
- It is often worthwhile checking off each individual clients’ total.
- If the totals do not match, you can tick the “Show Invoices” to find the invoices that are out (or just hand it back to your conversion provider to fix…)
If your source is MYOB, the corresponding report to look at is the Reconciliation Summary (or Reconciliation Detail if you are looking at invoice level) in the Sales tab for reports.
3) Compare Ages Payables
An exact replica of the process above for the Ages Payables report.
4) Review Account Balances
The quickest check is comparing Equity in the balance sheet and Net Profit in the Profit & Loss report. Both should match.
We actually compare every single account in the trial balance to make sure nothing has shifted (and we do it on different dates).
Please note that the totals of a trial balance will never match when comparing to MYOB. The reason is the single GST in Xero, compared to multiple GST accounts in MYOB. So these totals are not a place to use for checking.
5) Bank Reconciliation Check
The Statement Balance on the Dashboard should be the same as calculated in the source system for the accounts that are reconciled.
6) GST Reconciliation Report
The GST Reconciliation Report is really useful if set up correctly. The difficulty is that any open invoices from before the conversion date might impact on it in a way they should not. When the conversion is completed successfully, it should show $0.00 for the Unfiled Amounts in both GST Collected and GST Paid.
You will still need to publish any Business Activity Statements from after the conversion date, but that belongs in the post conversion tasks.
7) Locked Down?
Once all of these things are done, it is important to protect your work and minimise the risk that any client messes with it. The simplest way is by entering the Period Lock Date and End of Year Lock Date. For the Period Lock Date, choose a date as close to today as possible, but leaving the dates open that have not yet been reconciled.
We are really keen to hear about any other checks that you find useful. Please share below.