Overview

  • Jet Convert makes a “mirror image” from the source to Xero even though the data structure between Quickbooks, Reckon, MYOB, or Sage is completely different to Xero’s.
  • Jet Convert implements differences behind the scene. Some are simple: e.g. Quickbooks Payroll has active, terminated, and employees. Xero has either active or inactive.  Other products can have negative sales supplier invoices. We turn these into credit notes in Xero as it will not accept negative invoices.

What Does Come Across

  • Mirror image of the source file with some exceptions.

What Does Not Come Across

  • Features or data that Xero does not support.

More Information

See individual answers in the rest of this page or for more detailed FAQ –  click here.

Premium options include additional history, Monthly Comparative Balances, and Custom Chart of Accounts – click here

Contacts

What Does Come Across

  • All contact and financial details, addresses sorted into Postal and Street in Xero.
  • We check every phone number and make sure the mobile/cell number ends up in the mobile field.
  • We also check each address for variations of PO Box and automatically move it into the postal address fields.

What Does Not Come Across

  • In Reckon and Quickbooks, you need to update Bank Details and other financial details.
  • Contact logs do not come across.
  • Default income and standard purchase account codes.

More Information

The FAQ on Contacts has more information –  Click Here.

Accounts

What Does Come Across

  • All accounts are brought across.
  • As part of the conversion process you have the chance to confirm bank account type in Xero.
  • If there is no account number the Xero account will be a no-number account.

What Does Not Come Across

  • More than 700 accounts are supported, but accounts in excess of about 1,500 will cause issues in Xero. For these files we recommend that you select the Custom Chart of Accounts option and combine multiple accounts to reduce the number to under 500 accounts along with the use of Xero Report Codes to manage reporting.
  • Xero has a limit of 10 numbers for account codes and they have to be unique.
  • Header accounts  in MYOB are not used.
  • Hyphens in account numbers are removed.
  • Report codes – the Custom Chart of Accounts premium option supports Xero Report Code import.

More Information

The Chart of Accounts FAQ has more detailed information – click here.

More detail on Account types in Xero check out our Blog – Click Here

Items / Inventory

What Does Come Across

  • Item number and item name though will appear slightly differently in Xero
  • Base sales price
  • Standard Cost
  • Cost of Goods Sold and inventory amount in $
  • COGS and inventory Accounts
  • Both active and inactive items
  • The accounting transactions

What Does Not Come Across

  • Purchased item description (description only available for sold items)
  • Locations (note there is a fee associated with multi-locations files)
  • Last purchase price
  • Restocking information
  • Inventory adjustments
  • Quantity on hand
  • No negative inventory
  • Item codes on credit notes, draft invoices or bills

More Information

The FAQ has more detailed information – Click Here

Bank Transactions

What Does Come Across

  • All bank transactions
  • Reconciled as per the source file

What Does Not Come Across

  • Warning: it is possible to tick for reconciliation in MYOB, but it requires a second step to commit that reconciliation – if that second step is not performed in MYOB these transactions will appear un-reconciled

More Information

The FAQ has more detailed information – click here

Bank Accounts and Credit Cards

What Does Come Across

  • All bank accounts and credit cards including Paypal are converted to Xero

More Information

For more information of how to select correct accounts – click here

Invoices and Quotes

What Does Come Across

  • Invoices as in the source file with full line items and payments against them – dates, invoice number the same (unless it is a duplicate as Xero does not accept duplicate invoice numbers)
  • Draft invoices or Quotes

What Does Not Come Across

  • Quotes prior to your selected conversion history start date will not be converted
  • Cannot allocated billable Expenses against Clients in Xero
  • Repeating invoices

More Information

The Transactions FAQ has more information – click here

Bill and Purchase Orders

What Does Come Across

  • Bills (or negative invoices in Sage) as in the source file with full line items and payments against them – dates, purchase number the same (unless it is a duplicate as Xero does not accept duplicate bills and purchase orders)
  • Draft bills or Purchase Orders

What Does Not Come Across

  • Purchase orders prior to your selected conversion history start date
  • Repeating bills

More Information

The Transactions FAQ has more information – click here

Jobs / Categories / Classes

What Does Come Across

  •  Up to 500 (active, inactive and headers)
  • In Xero there are only 4 total categories (2 active, 2 inactive) so most are converted into options
  • Jobs are converted at the transaction line level to Xero options, note: Classes in Quickbooks and Reckon are at the contact level and jobs are at the line level

What Does Not Come Across

  • Jobs/Categories/Classes will not convert if there are more than 100 in the file
  • Descriptions do not come across
  • Opening balances
  • Header jobs will have $0 balances.
  • Categories and options have to be unique so if there are duplicates in the source file, these are renamed

More Information

The Jobs / Categories / Classes FAQ has more detailed information – click here

Payroll and Employees

What Does Come Across (Australia)

  •  All employees paid in the current year (both active and terminated )
  • All employees set up but never paid unless terminated or inactive
  • All pay items
  • Employee details
  • Pay templates
  • Pay cycles
  • Opening balances
  • Allowances

What Does Not Come Across

  • Reimbursements if part of pay template (not permitted in Xero)
  • Employer expenses
  • If more than 200 active employees
  • Timesheets
  • Long service leave

More Information

The Payroll FAQ has more detailed information – click here

For information about timesheets and self service – click here

Company Information

What Does Come Across

  • Information in the Source file  ABN, Company EIN, GST
  • Addresses, tax basis

What Does Not Come Across

  • Users – need to set them up in Xero
  • Invoice and purchase order templates

More Information

The general  FAQ has more detailed information – click here

Tax - GST / VAT

What Does Come Across (GST / VAT)

  • All transactions
  • In Xero GST is a system account and both input and output GST/VAT are in a single account so MYOB Input/Output tax is combined into a single account
  • The GST balances in Xero are the same as in the source file
  • It a custom tax code exists in the source file, we make all attempt to use a valid tax code in Xero

What Does Not Come Across

  • In Australia, WET and custom tax codes – where tax codes have been created, but not used the conversion continues
  • Unusual tax codes are identified and if possible converted
  • The source file may not indicate full intended treatment of a tax code

More Information

See the general  FAQ has more detailed information – click here

Budgets

What Does Come Across

  • We will not convert budgets – in Xero budgets are part of reporting, there is no API and so no budget information is brought across

What Does Not Come Across

  • Xero budget is a manual process, you can export the template out of Xero, amend with your own information and re-import into Xero

More Information

See the budget instructions from Xero for more detailed information – click here

Allocating payments to Invoices or Bills

Issue

In desktop software it is possible to journal a bank transaction against Accounts Receivable or Accounts Payable. Xero does not allow such transactions. Bank transactions are restricted to money received or spent and payments must be against an invoice or a bill.

What Does Come Across

  • Where the correct contact can be identified, then a credit note is raised against the customer / supplier
  • If the payment has no contact information, the transaction remains in the “Original A/P” or “Original A/R” accounts

What Does Not Come Across

  • If the payment or receipt cannot be tracked then the payment / receipt is created in the Original AP/AR

More Information

Matching credit notes with invoices or bills will happen on occasions where the contact can be identified.

Where the contact is not specified in the journal, then we cannot create a correcting credit note.  All data will be in the “Original A/R” or “Original A/P” account. Our QA team will pick this up and make corrections if a limited number of journals made. Otherwise a transaction with journals equivalent of the payment will have been entered but not allocated.

For a detailed explanation of Journals against AR/AP  – click here

Multi-currency

What Does Come Across

  • Multi-currency is only currently supported for MYOB in Singapore and Hong Kong (Australia in progress)

What Does Not Come Across

  • If the source file has multi-currency turned on but there are not transactions in the past 2 years then the file may be converted

More Information

For a detailed explanation of MYOB Multi-currency differences then – click here

Project and Expenses

What Does Come Across

  • Nil

What Does Not Come Across

  • Nothing is brought across
  • In source files there are a range of features such as vehicle mileage or projects
  • Xero has only recently implemented Projects and Expenses with an API

More Information

Categories and Jobs are converted – but not these other advanced features.

For Xero Expenses  – click here.

For Xero Projects  – Click Here

Balances Only - Transaction Free

What Does Come Across

  • Accounts
  • Contacts
  • Balances – either balances only, or zero dollar balances

What Does Not Come Across

  • No transactions
  • No invoices, or bills

More Information

For details of the service – click here

Premium Options available

How long does it take?

What is the Service Level to Expect

  • 95% of all files that are uploaded can be converted to Xero with full transactions
  • 4% can be converted with no transactions or only current year of transactions
  • 1% cannot be converted (generally file errors)

How long does it take?

  • Our target is 3 business days for Australian or New Zealand MYOB and 5 business days for Quickbooks, Reckon and Asia MYOB files and we are continually striving to reduce this
  • Our published data for ANZ MYOB for the past 12 months is:
  • 50% within 1 day
  •  91% within 3 days
  • 97% within 5 days

More Information

Contact us if you have any concerns about the timing  – click here