Reckon file preparation

[printfriendly]

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

What not to do before uploading your Reckon file to Jet Convert:

Do not start a Xero Organisation unless you are a Xero Partner with approval to convert into Existing Xero Organisations. If you have already started a Xero subscription and should not have click here for instruction on how to proceed.
Do not change any account types in Reckon before proceeding.

BEFORE you upload your Reckon file to Jet Convert:

ESSENTIAL File Preparation:

ATTENTION: Please note if the Essential File Preparation is not completed prior to upload a reconversion charge may apply. If you are not comfortable processing the above steps we have approved trainers who regularly process conversion and can handle this process for you.

See our website for transaction types that typically cause issues
Check what data will and won't convert against your specific needs
Ensure the Reckon file is set to the correct GST accounting basis
Check how your bank accounts and credit cards are set up in Reckon
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 (including archived accounts) in the Chart of Accounts.
For example: Account no. 1234, description 'Motor Vehicle Expenses' and Account no. 1235 'Motor Vehicle Expenses'. As the two descriptions are the same you need to add a number or character to one to make them unique.
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
Ensure that Accounts Receivable, Accounts Payable and GST accounts do not have Account type as Bank Account.
Apply all credit notes unless current.

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
Pay Superannuation to date through the Reckon file (if applicable)
Check that all employees have an accurate USI/SPIN
Remove the password for the Admin User
Set the closing date
Clean up the file by removing unwanted data - only required if your file is large in size.

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.

NEXT STEPS:

Create a backup of the Reckon file.
Upload the backup to sandbox.jetconvert.com.
Make your Package selection.
Complete your bank account mapping (if applicable).

CONVERSION TURNAROUND TIME:

The conversion will take up to 5 busines days from when you have:

Selected your conversion service
Provided us with the desktop file password
Advised as to how you want the bank accounts to be treated in Xero (premium packages only). *

* Please be advised -If bank mapping is not completed within a 48 hour timeframe we will complete this on your behalf.

What not to do before uploading your Reckon file to Jet Convert:

BEFORE you upload your Reckon file to Jet Convert:

ESSENTIAL File Preparation:

OPTIONAL File Preparation:

NEXT STEPS:

CONVERSION TURNAROUND TIME:

Accounting software conversions

Other services

About Jet Convert