cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Created with Sketch. The latest tax table update for QuickBooks Desktop is now available. Download the update in minutes by visiting our step-by-step guide.
QuickBooksHelp
Intuit

Transferring Xero data to QuickBooks Online

How does the transfer process work?

  1. Review the Pre-Migration Checklist section in this document.
  2. Prepare your current Xero file for transfer and ensure your QuickBooks Online file is set up correctly.
  3. Fill out a form to gather your consent for the migration of the Xero data to QuickBooks Online.
  4. Select how many years of Xero data you wish to have transferred as well as any optional add-ons, such as Inventory, that you may require.
  5. Upload your Xero file via secure server to the Dataswitcher tool for migration to QuickBooks Online.
  6. Start using your new QuickBooks Online company file upon your confirmation of the results.

 

Note: Keep your pre-transfer back-ups and/or exported reports from Xero for tax auditing purposes.  It is important that you keep the backups or extracted reports from the source system in a safe location even after the transfer is complete.

How long will it take to transfer my data?

The process of transferring data takes, on average, up to 72 hours from the time your data is uploaded into the Dataswitcher tool.

Contact the QuickBooks Online support team if the transfer has been longer than 72 hours.

How will my business data be protected?

Your business data is protected in the following ways:

  • as long as you use the online form to upload, your data is protected using industry-standard SSL encryption
  • your data is governed by Intuit’s Data Stewardship Principles

What Xero Data will not be transferred?

The following data types cannot be transferred at this time:

  • Budgets
  • Multi-currency
  • Memorized transactions
  • Invoice template and other templates
  • Sales orders
  • Payroll records
  • Projects
  • Attachments
  • Non-posting entries (estimates)

Transfer limitations

The following limitations of service can occur when you are transferring from Xero to QuickBooks Online using Dataswitcher.

Opening balance for transactions outside transfer period

Transactions outside the transfer period will be consolidated into an automatically-calculated balance for both GL accounts, customers and suppliers.  As a part of your free transfer, Dataswitcher will transfer the last two fiscal years. The transactions from all prior years will be consolidated into an automatically-calculated opening balance unless extra years are purchased.

If the profit and loss and balance sheets do not align, Dataswitcher will add a balance line for retained earnings called undistributed profits.

If you do not want to buy additional years but still want comparative balances, you can divide the Dataswitcher opening balance transaction post-transfer into multiple years.

Sales Tax is transferred, as a line item

Dataswitcher applies sales tax from Xero as a line item. This provides a higher-quality transfer that closes financially. However, it is necessary to undertake a post-check step for your first sales tax report. This is a one-time process.

Matching journal entries with related credits

The transfer is unable to match related credits to their respective journal entries. The journal entries will still be posted, however, but they will remain unlinked. Although this is not a mandatory step, we advise you to match these entries in Xero prior to the transfer.

Cash basis accounting scheme for taxes

If you use the Cash basis accounting scheme, we advise you to migrate directly after the close (and reconciliation) of your most-recent tax period. This will prevent additional post-transfer work in Quickbooks Online.

If your administration uses Cash basis accounting instead of the Standard (non-cash) accounting scheme for taxes, you’ll need to manually change your open invoices after the transfer to include taxes.

If there are some invoices that remain partly paid at the end of your last sales tax submission (in your source accounting system) you’ll need to ensure that the invoice is split. This can be done manually in Quickbooks Online to reflect the open amount and the respective sales tax rate to be applied.

Also ensure to follow the pre-transfer checklist before transferring. The reconciliation of the bank is important for Cash basis accounting because this might affect certain tax reports.

Stock

Dataswitcher supports up to 1000 items with stock. Code, stock code, location, name and description are posted. Current stock, purchase, and sales price are also posted. Income and asset account are not posted to Quickbooks.

Departments and projects

Tracking classes in Xero will become Locations in Quickbooks Online.

Journal Merge

Xero keeps a very detailed journal history for all operations. Because of an overabundance of information on the Customers/Suppliers level, journals will be merged as they relate to Credits, Prepayments and Overpayments in order to maintain an accurate balance on all accounts. This means that older period reports might not represent the correct balance at that time, even if all the current and outstanding balances are fine.

Pre-Migration Checklist

The following steps are required prior to uploading your file for transfer:

  • if you have an existing QuickBooks Online Company File that you have used in any way you will need to cancel your subscription and create with a new account. Data cannot be migrated into a QuickBooks Online Company file that has existing data contained within it.
  • create a backup of your Xero file. Save the backup file in a location that is easy to access. It will be used for upload in a later step.
  • reconcile all your bank/credit card accounts to the most recent statement possible. After reconciling, make a note of the balances on your bank account. You’ll need this when preparing the post-transfer reconciliation in your QuickBooks Online company file.
  • file your quarterly Sales Tax return for the remaining quarter. If you use Cash-based accounting, it is advised to migrate directly after close (and reconciliation) of a tax period. Otherwise the post-transfer work in Quickbooks Online can be considerable (for example, considering partial paid invoices).

 

To file your quarterly Sales Tax return:

  1. Click Reports under the Accounting.
  2. Choose the Tax Return option.
  3. Click View under Looking to see VAT/GST Transactions for your own date range?
  4. Select the data range. The date range is the start of the quarter until the current date (i.e., transfer date).
  5. Click Display.
  6. Export the report to a PDF.

 

After the transfer this information will be used to generate a full report. This is done by adding the amounts in the boxes together (in the old and new software).

Extract the following reports to check your data after the transfer:

  • Profit and loss until transfer date
  • Trial balance until transfer date
  • Balances on your bank accounts

 

Print a list of outstanding invoices of your customers and suppliers per transfer date.

Extract the following data for auditing purposes:

  • Sales Tax report
  • Account Transactions

Get started transferring your data to QuickBooks Online

Visit the Dataswitcher migration wizard to get started.

Note: the wizard is only available in English at this time.

Start using QuickBooks Online

Once you’ve performed the tasks described in this document you can start using QuickBooks Online.

Contact the QuickBooks Online support team if you have any questions about any of these tasks.

Was this helpful?

You must sign in to vote, reply, or post

Need to get in touch?

Contact us