FAQ - XERO to QuickBooks Online Conversion

1. What we Convert

• Chart of Accounts (We do custom mapping as well)
• Customer Details
• Supplier Details
• Opening Account Balances
• Aged Receivables
• Aged Payables
• Bank Transactions (Includes Invoice payments, Bill payments, and other Bank Transactions) (All Bank Transactions will remain unreconciled in QuickBooks Online and can be reconciled at your end at once by entering opening balance and closing balance. This will be the step in the post-conversion process at your end.)
• Credit Card
• Invoices and Credit Notes Detailed
• Bills and Bill credit Detailed
• All Manual Journals
• Inactive Contacts/Accounts can be brought over on special request
• The entire conversion and matching of Reports are done on ACCRUAL Basis.
• We make our best attempt to give you the exact image of your Xero data, however, due to the limitations of few fields which are different in Xero and QuickBooks Online, we might have to use some workarounds to bring the transactions.

2. What We Don't Convert

• Budgets
• Track Inventory
• Classes / Job / Department
• Purchase Orders and Sales Estimates
• Fixed Asset
• Expense Claims
• Memorized Transactions
• Payment Terms
• Custom VAT Rates
• Invoice Templates
• Time Sheets
• Repeating Invoices after the "Convert To" date
• Deleted/Void Transactions
• Allocation of Invoices or Bills against credit notes
• Transaction lines with Nil Values
• Sales Rep
• Customer Jobs
• Attachments
• Unreconciled Entry
• We are specialist in converting core financial information and we try our best to bring the other non-financial information as well, however, because of the limitation of APIs of both software’s, we might not be able to get few fields

3. Workarounds

• Chart of Accounts - Inactive Accounts, if used in Xero in the conversion period are turned as Active Accounts in QuickBooks Online
• Custom Sales Tax Rates are converted into standard Sales Tax Rate with "Tax Adjustment" entry as a separate line item in QuickBooks Online
• System Accounts like Retained Earnings, VAT control Account are used in QuickBooks Online for their counterpart accounts in Xero
• We bring inventory details like name, code, description, sales account, purchase account, sales price, purchase price etc. Since we don’t do tracked inventory, as part of the migration, we import all the items as "non-inventory" type in QuickBooks Online and after the completion of the migration, you need to manually change the type from 'Non-Inventory' to 'Inventory' and add the quantity on hand manually for each item
• Rounding can be different in QuickBooks Online and Xero because of the data precision techniques used in both software.
• In Purchase Bills - we don’t bring items or products in QuickBooks Online.
• Blank Bill reference Numbers and Invoice reference Numbers:- In case we find any invoice or bill without a number, we use a dummy number example for Bills:- Bill1, Bill2 and for Invoices - Inv1, Inv2.
• Duplicate reference Number in bank transactions or invoices/bills:- In case we find duplicate reference numbers then we use transaction numbers instead of reference numbers or make the numbers unique by appending an extra character with a hyphen
• Limitation of Reference number:- QuickBooks Online have limitations of 20 characters for Reference number thus for the reference numbers more than 20 characters we have to trim them to 20 characters.

4. Sample of how your Xero data will look in QuickBooks Online

XERO CUSTOMER

QuickBooks Online CUSTOMER

XERO SUPPLIER

QuickBooks Online SUPPLIER

XERO INVOICE

QuickBooks Online INVOICE

XERO INVOICE PAYMENT

QuickBooks Online INVOICE PAYMENT

XERO BILL

QuickBooks Online BILL

XERO BILL PAYMENT

QuickBooks Online BILL PAYMENT

XERO ITEM

QuickBooks Online ITEM