How are inventory & activity codes handled during the conversion? | Jet Convert

How are inventory & activity codes handled during the conversion?

What we convert

If there is inventory in the source file we convert the following:

  • Item number and sale description
  • Base Sales Price
  • Standard cost 
  • COGS and Inventory $
  • COGS and Inventory Accounts
Note that Inventory accounts are set up in 'other assets' and as Xero does not have an 'other assets' account the inventory accounts generally convert as a 'fixed asset'. Xero will not allow you to change the 'fixed asset' to an 'inventory asset' account so there is some manual work to implement tracking post conversion (refer Converting untracked inventory to tracked in Xero below).
 
Please note that active and archived Inventory will be converted.

If you select a transactional history service you also receive:
 
  • Postings for sales and purchases
  • Sales value
  • Purchase value.
Note that the item name/description will be converted into the inventory Sales Description in Xero, regardless of whether the item is bought or sold.

What we DO NOT convert

The following will NOT come across as part of the conversion and will require updating in the Xero org:

  • Activities or Activity codes
  • Item description
  • Locations (MYOB Enterprise)
  • Last Purchase Price
  • Restocking information including primary supplier are not brought across
  • Quantity on Hand is not brought across
We cannot convert files with negative inventory. Please refer to our separate knowledgebase article on this.
 
Converting untracked inventory to tracked in Xero

During the conversion process Inventory Items are converted as 'Un-tracked Items' this allows the items to be connected to the COGS account and the Sales account.

In the source file you may have the ability to mark/tick an item as 'I inventory this Item' which allows allocation to the COG account, Sales account and the Inventory account.

Xero have recently updated how you can handle inventory in Xero and this new functionality now allows clients to track and use the relevant inventory accounts. However, our conversion service does not allow 'Inventoried items' from MYOB to convert as 'i track this item' in Xero.

To update this data in Xero please refer to the following information:

During the process of creating your 'tracked' items in Xero you will be able to allocate the relevant inventory code. Please see screen shot of the information that needs updating in Xero.

Please also review how our conversion process brings across the data associated with Inventory Items.

uestions.