Troubleshooting: How To Check Source to Xero Post Conversion

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 OnlineXero
Comments
Trial BalanceReporting > Reports > Business Reports > Trial Balance > Run Year to DateAccounting > 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 ReceivableReporting > Reports > Sales > Unpaid InvoicesAccounting > 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 PayableReporting > Reports > Purchases > Unpaid BillsAccounting > 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 ReconciliationReporting > Reports > Banking > Banking Reconciliation Report > Accounts Select Bank accountDashboard > 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 SummaryReporting > Reports > Payroll > Payroll RegisterAccounting > 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 SummaryReporting > Reports > Business > GST ReportAccounting > 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 LossAccounting > 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 BalanceAccounting > Reports > Taxes and balances > Trial Balance> More > AccrualThere 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 DetailAccounting > Aged Receivables DetailIf 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 DetailAccounting > Aged Payables DetailIf 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 transactionsDashboard > click the top right of the bank in question > Reconcile > Reconciliation ReportIf 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 SummaryAccounting > Reports > Payroll > Payroll Activity SummaryIf 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 SummaryAccounting > 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 > AccrualAccounting > Reports > Taxes and balances > Trial Balance> More > AccrualThere 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 DetailAccounting > Aged Receivables DetailIf 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 DetailAccounting > Aged Payables DetailIf 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 transactionsDashboard > click the top right of the bank in question > Reconcile > Reconciliation ReportIf 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 ReportAccounting > Reports > Payroll > Payroll Activity SummaryIf 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 SummaryAccounting > 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 AccrualAccounting > Reports > Taxes and balances > Trial Balance> More > AccrualThere 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 DetailAccounting > Aged Receivables DetailIf 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 DetailAccounting > Aged Payables DetailIf 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 transactionsDashboard > click the top right of the bank in question > Reconcile > Reconciliation ReportIf 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 ...
    • 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 ...
    • 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 ...
    • 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 ...