Troubleshooting: How To Check Source to Xero Post Conversion
Recommendation
Source to Xero Review: We suggest that the report comparisons be completed prior to commencing work in Xero.
MYOB Desktop
MYOB Desktop | Xero | Comments | |
Trial Balance | Reports > Index to reports > Accounts > Trial Balance> Run YTD and in Accrual Basis | Accounting > Reports > Taxes and balances > Trial Balance> More > Accrual | There are many system differences in cash basis hence best to compare on an accrual basis. If the MYOB balance varies from the Post Conversion Report it is likely that changes were made to the source post upload. If Xero is different check History and notes for changes made post conversion. |
Accounts Receivable | Reports > Index to reports > Sales > Receivables Reconciliation [Detail] | Accounting > Aged Receivables Detail | If the MYOB report has an out of balance we will have posted this amount to the Accounts Receivable Original Account - see here for more information |
Accounts Payable | Reports > Index to reports > Purchases > Payables Reconciliation [Detail] | Accounting > Aged Payables Detail | If the MYOB report has an out of balance we will have posted this amount to the Accounts Payable Original Account - see here for more information |
Bank Reconciliation | Command Centre > Banking > Reconcile Accounts > Select Bank Account and enter date of conversion | Dashboard > click the top right of the bank in question > Reconcile > Reconciliation Report | If there are items on the source file ticked then this means a reconciliation was being prepared but never finalised. Should you need to bulk reconcile please see here for our recommendations on post conversion reconciliation. |
Payroll Activity Summary | Reports > Index to reports > | Accounting > Reports > Payroll > Payroll Activity Summary | If these do not match, please check that an additional pay run has not been made since providing the file or a previous pay run adjusted. |
GST Activity Summary | Reports > Index to reports > GST / Sales Tax > GST[Summary - Your basis according to your file] - Run for the transactional period you converted for. | Accounting > Activity Statement - Run for the transactional period you converted for | Run this report for the entire transactional period converted. There are times you may see variances in the GST Collected and GST Paid due to system differences between the source file and Xero, please see here. If this is the case, you will find the difference between the two account balances out and the amount of GST Payable / Refundable is captured correctly in the Trial Balance and BAS reports. |
Job Reporting (if applicable) | Reports > Index to reports > Accounts > Jobs > Job Activity [Summary] | Accounting > Profit and Loss > Compare Tracking categories> drop down options and select "Select All" | We do not convert jobs/tracking for payroll this should be the only variance between reports unless you have more jobs/classes than the package allowed for and opted not to convert them. |
MYOB Online
Before starting to compare reports in MYOB Go To > Business Name top Right corner > Report Settings > Accounting Method Accrual
| MYOB Online | Xero | Comments | |
| Trial Balance | Reporting > Reports > Business Reports > Trial Balance > Run Year to Date | Accounting > Reports > Taxes and balances > Trial Balance> More > Accrual | There are many system differences in cash basis hence best to compare on accrual. If the MYOB balance vary from the Post Conversion Report it is likely changes were made to the source post upload. If Xero is different check History and notes for changes made post conversion. |
| Accounts Receivable | Reporting > Reports > Sales > Unpaid Invoices | Accounting > Aged Receivables Detail | If the MYOB report has an out of balance we will have posted this amount to the Accounts Receivable Original Account - see here for more information |
| Accounts Payable | Reporting > Reports > Purchases > Unpaid Bills | Accounting > Aged Payables Detail | If the MYOB report has an out of balance we will have posted this amount to the Accounts Payable Original Account - see here for more information |
| Bank Reconciliation | Reporting > Reports > Banking > Banking Reconciliation Report > Accounts Select Bank account | Dashboard > click the top right of the bank in question > Reconcile > Reconciliation Report | If there are items on the source file ticked then this means a reconciliation was being prepared but never finalised. Should you need to bulk reconcile please see here for our recommendations on post conversion reconciliation. |
| Payroll Activity Summary | Reporting > Reports > Payroll > Payroll Register | Accounting > Reports > Payroll > Payroll Activity Summary | If these do not match, please check that an additional pay run has not been made since providing the file or a previous pay run adjusted. |
| GST Activity Summary | Reporting > Reports > Business > GST Report | Accounting > Activity Statement - Run for the transactional period you converted for | Run this report for the entire transactional period converted. There are times you may see variances in the GST Collected and GST Paid due to system differences between the source file and Xero, please see here. If this is the case, you will find the difference between the two account balances out and the amount of GST Payable / Refundable is captured correctly in the Trial Balance and BAS reports. |
| Job Reporting (if applicable) | Reporting > Reports> Jobs> Job Profit and Loss | Accounting > Profit and Loss > Compare Tracking categories> drop down options and select "Select All" | We do not convert jobs/tracking for payroll this should be the only variance between reports unless you have more jobs/classes than the package allowed for and opted not to convert them. |
**Note: There will be differences if work continued in the source after Jet Convert extracted the data.
Reckon
Reckon | Xero | Comments | |
Trial Balance | Reports > Accountant > Trial Balance | Accounting > Reports > Taxes and balances > Trial Balance> More > Accrual | There are many system differences in cash basis hence best to compare on an accrual basis. If the balance varies from the Post Conversion Report it is likely that changes were made to the source post upload. If Xero is different check History and notes for changes made post conversion. |
Accounts Receivable | Reports > Customers & Receivables > A/R Ageing Detail | Accounting > Aged Receivables Detail | If the report do not match this is likely to be a general journal or cheque payment that Xero does not allow to be post to a system account. Therefore we post these in the A/R Original Account - see here for more information |
Accounts Payable | Reports > Suppliers & Payables > A/P Ageing Detail | Accounting > Aged Payables Detail | If the report do not match this is likely to be a general journal or cheque payment that Xero does not allow to be post to a system account. Therefore we post these in the A/P Original Account - see here for more information |
Bank Reconciliation | Banking > Reconcile > Select the bank and a future date to include all transactions | Dashboard > click the top right of the bank in question > Reconcile > Reconciliation Report | If there are items on the source file ticked then this means a reconciliation was being prepared but never finalised. Should you need to bulk reconcile please see here for our recommendations on post conversion reconciliation. |
Payroll Activity Summary | Reports > Employees & Payroll > Payroll Summary | Accounting > Reports > Payroll > Payroll Activity Summary | If these do not match, please check that an additional pay run has not been made since providing the file or a previous pay run adjusted. |
GST Activity Summary | Reports > Tax > Tax Summary | Accounting > Activity Statement - Run for the transactional period you converted for | Run this report for the entire transactional period converted. There are times you may see variances in the GST Collected and GST Paid due to system differences between the source file and Xero, please see here. If this is the case, you will find the difference between the two account balances out and the amount of GST Payable / Refundable is captured correctly in the Trial Balance and BAS reports. |
Job Reporting (if applicable) | Reports > Jobs, Time & Mileage > Job Profitability Summary | Accounting > Profit and Loss > Compare Tracking categories> drop down options and select "Select All" | We do not convert jobs/tracking for payroll this should be the only variance between reports unless you have more jobs/classes than the package allowed for and opted not to convert them. |
Quickbooks Online
QBO | Xero | Comments | |
Trial Balance | Reports > Reports > For my Accountant > Trial Balance > Accrual | Accounting > Reports > Taxes and balances > Trial Balance> More > Accrual | There are many system differences in cash basis hence best to compare on an accrual basis. If the MYOB balance varies from the Post Conversion Report it is likely that changes were made to the source post upload. If Xero is different check History and notes for changes made post conversion. |
Accounts Receivable | Reports > Reports > Who Owes You > Accounts receivable Ageing Detail | Accounting > Aged Receivables Detail | If the MYOB report has an out of balance we will have posted this amount to the Accounts Receivable Original Account - see here for more information |
Accounts Payable | Reports > Reports > Who You Owe > Accounts Payable Ageing Detail | Accounting > Aged Payables Detail | If the MYOB report has an out of balance we will have posted this amount to the Accounts Payable Original Account - see here for more information |
Bank Reconciliation | Transactions > Reconcile > Select Bank and future date to include all transactions | Dashboard > click the top right of the bank in question > Reconcile > Reconciliation Report | If there are items on the source file ticked then this means a reconciliation was being prepared but never finalised. Should you need to bulk reconcile please see here for our recommendations on post conversion reconciliation. |
Payroll Activity Summary (AU only) | Payroll > Reports > Gross to Net Report | Accounting > Reports > Payroll > Payroll Activity Summary | If these do not match, please check that an additional pay run has not been made since providing the file or a previous pay run adjusted. |
GST Activity Summary (AU Only) | GST > Run Reports > GST Summary | Accounting > Activity Statement - Run for the transactional period you converted for | Run this report for the entire transactional period converted. There are times you may see variances in the GST Collected and GST Paid due to system differences between the source file and Xero, please see here. If this is the case, you will find the difference between the two account balances out and the amount of GST Payable / Refundable is captured correctly in the Trial Balance and BAS reports. |
Job Reporting (if applicable) | Reports > Profit and Loss by Tag group | Accounting > Profit and Loss > Compare Tracking categories> drop down options and select "Select All" | We do not convert jobs/tracking for payroll this should be the only variance between reports unless you have more jobs/classes than the package allowed for and opted not to convert them. |
**Note: There will be differences if work continued in the source after Jet Convert extracted the data.
QuickBooks Desktop
QuickBooks Desktop | Xero | Comments | |
Trial Balance | Reports > Accountant & Taxes >Trial Balance > Report basis Accrual | Accounting > Reports > Taxes and balances > Trial Balance> More > Accrual | There are many system differences in cash basis hence best to compare on an accrual basis. If the MYOB balance varies from the Post Conversion Report it is likely that changes were made to the source post upload. If Xero is different check History and notes for changes made post conversion. |
Accounts Receivable | Reports > Customers & Receivables > A/R Aging Detail | Accounting > Aged Receivables Detail | If the MYOB report has an out of balance we will have posted this amount to the Accounts Receivable Original Account - see here for more information |
Accounts Payable | Reports > Vendors & Payables > A/P Aging Detail | Accounting > Aged Payables Detail | If the MYOB report has an out of balance we will have posted this amount to the Accounts Payable Original Account - see here for more information |
Bank Reconciliation | Banking > Begin Reconciliation > Select Bank and future date to include all transactions | Dashboard > click the top right of the bank in question > Reconcile > Reconciliation Report | If there are items on the source file ticked then this means a reconciliation was being prepared but never finalised. Should you need to bulk reconcile please see here for our recommendations on post conversion reconciliation. |
Job Reporting (if applicable) | Reports > Jobs, Time & Mileage > Job Profitability Summary | Accounting > Profit and Loss > Compare Tracking categories> drop down options and select "Select All" | We do not convert jobs/tracking for payroll this should be the only variance between reports unless you have more jobs/classes than the package allowed for and opted not to convert them. |
Related Articles
Changing Accounting Basis in Xero Post Conversion
Changing Accounting Basis in Xero Post Conversion Table of contents Warning: We recommend that you do not use the file until it has been corrected. Unless you understand the full accounting implication of the above steps there is a very high chance ...Post Conversion Queries
Amending Conversion Balances Please see here for more information on how to Amend Conversion Balances Figures in Conversion Clearing Account Please see here for more information regarding conversion clearing accounts. Why do I have a Reconciliation ...How to Deal With Single Touch Payroll Post Conversion
Please see here for how payroll information is converted - this applies to Australian conversions only. Moving from an STP solution Xero's recommendation in relation to converting software mid year for STP purposes is to convert the YTD opening ...GST Reconciliation Post Conversion
Publish your BAS for the period before your conversion date Run and publish the older BAS, or finalise the new Activity Statement for all periods prior to your conversion date that contain transactions with GST. You’ll need to do this in Xero so your ...Bank Reconciliation Post Conversion
How to deal with the reconciliation post-conversion can vary depending on how up-to-date the accounting data file was when it was uploaded for conversion. In addition, whether you ordered a history versus balances service will influence when you need ...