Here is our recommendation of what to check before converting to Xero. The cleaner your data, the smoother your conversion to Xero.
- WE CAN CONVERT:
- QuickBooks Online
- WE DO NOT CONVERT:
- Multi-currency files
- Self Employed QBO Version
- Advanced (tracked) inventory
- Locations
- Projects
- PDF Attachments
- Linked transactions
Friendly Reminder:
Xero Subsidised service is only for conversions where Jet Convert creates the Xero Organisation.
If you would prefer to take up the Xero pricing plan discount you can, however conversions start from $220.
BEFORE you start your QBO conversion:
ESSENTIAL Data Preparation:
- See our website for transaction types that can cause system variances.
- Check what data will and won't convert against your specific needs.
- Ensure that QuickBooks is set to the correct accounting basis (cash or accrual).
- Ensure that Accounts Receivable, Accounts Payable and GST accounts do not have Account type as Bank Account.
- If you have used Undeposited Funds for Sales ensure the source QBO and mapping are set up as a Bank - to ensure this links to the contact history.
WARNING: Some banks require credit cards to be set up as bank accounts in Xero in order to connect bank feeds.
See here for more information.
- Ensure you have no Negative Inventory quantities in the file.
- Turn off bank feeds and disable any add-ons.
IMPORTANT – Stop working in QuickBooks Online – data will be extracted at a point in time. Data entered after this date will need to be re-entered if you continue working in QuickBooks Online.
OPTIONAL Data Preparation:
- Check that the balances in all bank accounts (Cash or Cash Equivalents) and credit cards match the bank statements as of the last reconciliation date
- Ensure all bank transactions you want converted are coded.
- Check that bank accounts have been reconciled.
- Note that transactions marked with a "C" are cleared and not reconciled and will convert that way.
- Ensure all clearing accounts are reconciled to NIL.
- Make sure your Accounts Receivable and Accounts Payable ageing match the Trial Balance value. Apply all credit notes unless current.
- Turn on account numbers for your Chart of Accounts.
- Edit account numbers to be a maximum of 10 digits.
- Ensure that there are no duplicate names in the Chart of Accounts.
- For example: 1234 - Motor Vehicle Expenses and 1235 - Motor Vehicle Expenses - As this description is duplicate please add a number or character to make them unique.
- Edit Chart of Account names. The Header and Chart of account name cannot exceed 200 characters.
- Confirm that the AR/AP reconciliation report matches the balance in the General Ledger.
- Terminate any employees not paid in the current financial year.
- Pay Superannuation to date through QBO (if applicable).
Next Steps:
- Start your conversion:
- Xero Subsidised Service – We create the Xero Organisation and transfer to you: Go to the Jet Convert website to start your Xero conversion.
- We convert into your Xero Organisation: Click here to start your conversion.
- Invite Jet Convert into QuickBooks Online.
- Make your conversion package selection.
- If Applicable Complete your bank account mapping.
Conversion Turnaround Time:
The conversion will take up to 5 busines days from when you have:
- Selected your conversion package.
- Given us access to QuickBooks Online.
- Premium Packages Only* Advised as to how you want the bank accounts to be treated in Xero.
* Please be advised -If bank mapping is not completed within a 48 hour timeframe we will complete this on your behalf.
