Quickbooks – File Preparation

The cleaner your file – the smoother your conversion to Xero.

What not to do before uploading your Quickbooks entity file to Jet Convert:

  1. Do not start a Xero subscription. We will create a new Xero subscription for you. If you have already started a Xero subscription click here.
    NOTE: We can not convert to a trial version of Xero.
  2. Do not change any account types in Quickbooks prior to conversion.

BEFORE you upload your Quickbooks entity to Jet Convert:

ESSENTIAL File Preparation:

*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
  • 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
  • Apply all credit notes unless current

Additional ESSENTIAL checks for QB desktop files:

  • Remove the password for the Admin User

Additional ESSENTIAL checks for QBO:

  • Turn on account numbers for your Chart of Accounts
  • 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
  • Edit account numbers to be a maximum of 10 digits
  • Confirm that the AR/AP reconciliation report matches the balance in the General Ledger
  • Ensure all bank transactions you want converted are coded
  • Run verify & rebuild on the file before submitting for conversion
  • Ensure all clearing accounts are reconciled to NIL

NEXT STEPS Quickbooks desktop files:

NEXT STEPS Quickbooks Online:
Click here for detailed instructions on how to start the QBO to Xero conversion process.