The cleaner your data – the smoother your conversion to Xero.
- WE CAN CONVERT:
- USA QuickBooks online
- WE DO NOT CONVERT:
- Payroll
- QBO Self Employed
- Multi-currency files
- Advanced (tracked) inventory
- Locations
- Projects
- PDF Attachments
- Linked Transactions
What not to do before giving Jet Convert access to your QuickBooks file:
- Do not start a Xero Organization. We will create a new Xero Organization as part of our process.
NOTE: We can not convert to a trial version of Xero.
BEFORE you give Jet Convert access to QuickBooks Online:
ESSENTIAL File Preparation:
ATTENTION: Please note if the Essential File Preparation is not completed prior to starting your conversion a reconversion charge may apply.
- See our website for transaction types that typically cause issues
- 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) using Edit/Preferences/Tax/Company Preferences
- Check how your bank accounts and credit cards are set up in QuickBooks
- If you have used Undeposited Funds for Sales ensure the source file 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 that there are no duplicate names in the Chart of Accounts eg. 1234 - Motor Vehicle Expenses and 1235 - Motor Vehicle Expenses - As this description is duplicate please add a number or character to make them unique.
- Reconcile Accounts Payable using the AP Unpaid Bills Detail report
- Reconcile Accounts Receivable using the Customer Balance Detail report
- Ensure all invoices/bills and credit notes are still outstanding
- Ensure that Accounts Receivable, Accounts Payable and GST accounts do not have Account type as Bank Account.
- Turn off bank feeds and disable any add-ons
- Do not work in QBO while the conversion is in progress
OPTIONAL File Preparation:
- Check that the balances in all bank accounts and credit cards match the bank statements as of the last reconciliation date
- Confirm that the AR/AP reconciliation report matches the balance in the General Ledger
- Ensure all bank transactions you want converted are coded
- 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
- Turn on Account Numbers for you Chart of Accounts
- Edit Chart of Account names where the header and chart of account name exceeds 200 characters.
- Edit Account numbers where they exceed 10 digits
- Turn on Account Number for your Chart of Accounts