Reckon File preparation

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

  • Quickbooks version 2012/13 (AU)
  • Reckon Accountant
  • Reckon desktop and Reckon hosted from 2013 to latest release
  • Versions include: Pro, Premier, Enterprise
  • Reckon One or Home & Business
  • Files with negative inventory
  • Multi-currency files
  • If the file uses WET/WEG
  • .QBW Files >800 MB
  • (.QBB or .QBM will show a smaller size as they are compressed)

What not to do before uploading your Reckon 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 Reckon prior to conversion.

BEFORE you upload your Reckon file 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 (including archived accounts) in the Chart of Accounts
  • Remove the password for the Admin User
  • Set the closing date
  • Clean up the file by removing unwanted data
  • Terminate any employees not paid in the current financial year
  • Ensure all employees paid in the current payroll year as marked as active
  • 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
  • Check that all employees have an accurate USI/SPIN

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 balance matches the balance in the General Ledger
  • Check how non-standard tax codes are treated
  • Ensure all clearing accounts are reconciled to NIL
  • Ensure all bank transactions you want converted are coded

NOTE: Where there are no Account numbers in the Reckon file we fill in the Chart of Accounts with system generated numbers. You can update these in Xero post conversion.


  1. Create a backup of the Reckon file.
  2. Upload the backup to
  3. Make your Package selection.
  4. Complete your bank account mapping (if applicable).