26 Feb Reckon File preparation
Here is our recommendation of what to check before converting to Xero:
- Ensure that Reckon is set to the correct accounting basis (cash or accrual). You can do this in Edit/Preferences/Tax/Company Preferences.
- Clean up the Reckon file by following these steps.
- Please remove the password for the Admin user. (see steps in 2 above). If you have difficulty in removing the password please call or chat to advise what the password is. (Please avoid using email)
- Do NOT change any account types in Reckon prior to conversion.
- Do not start a Xero subscription prior to the conversion:
- We set up an entirely new Xero org for you based on the file sent to us
- Conversion to a Xero 30 day free trial is not available with this service.
- Check that balances in all reconciled bank accounts and credit cards actually reflect the statement balances as of the last reconciliation date. Finalise all bank reconciliations. (Reconciliation is easier in Xero, so we recommend leaving unreconciled periods unreconciled in Reckon. However you need to make sure that the bank balances are correct as of your conversion start date.)
- Ensure all clearing accounts (including Undeposited Funds and Electronic Clearing Account) are reconciled to NIL.
- Confirm that the Accounts Payable report reconciles to Supplier statements and that all unpaid invoices are still due.
- Ensure all credit notes are applied unless actually unused.
- Repeat points 3 and 4 for Accounts Receivable.
- Run AR Ageing Summary and AR Ageing Detail reports as of the last day of the financial year (e.g. 30/6/15 if that is the date you used for Step 2 under the Must Do’s as mentioned above) and make sure that there is no Out of Balance amount. Xero does not allow direct journals to system accounts.
- Ensure that all employees that are terminated have a termination date entered, rather than just being made inactive.
- Check if any Account numbers are longer than 10 digits. If so edit them to be unique numbers of 10 digits or less.
- Run a verification of the file (from the File/Utilities menu). Fix any errors so that the file can be verified without any errors occurring.
- If the file is bigger than 250MB we may be able complete the conversion for you. If your file is greater than 250 MB you can try to reduce the file size by following these instructions.
We are unable to convert files saved with Reckon Accountant versions, as we are not able to open them.
If you have a new Reckon Accountant file, we need the file to be saved from a business version of Reckon, or in a version that is earlier than 2017.
To do this, please follow these steps:
- Open the Reckon File in the Accountant version.
- From the file menu, choose toggle to another edition (e.g. Premier General Business).
- Save a backup copy of the file.
- Whilst still toggled, restore the back-up copy, this is now ready to upload to us.