How is 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: 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 to Converting untracked inventory to tracked in Xero below).
Note: Active and archived Inventory will be converted.
If you select a transactional history service you will also receive:
- Postings for sales and purchases
- Sales value
- Purchase value.
Note: 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 organisation.
- 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
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 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:
- Convert un-tracked inventory to tracked inventory in Xero
- If you have multiple Inventory items you may prefer to amend this information in bulk
- Export Inventory Items
- Enter opening Balances for Tracked Inventory
During the process of creating your 'tracked' items in Xero, you will be able to allocate the relevant inventory code. Please see a screenshot of the information that needs updating in Xero.
All items are created in Xero with their item codes, descriptions and purchase and sales details. What we Convert Item number Item name Base Sales Price Standard cost COGS and Inventory $ COGs and Inventory Accounts Item Description: Note: there is ...
Tracked Inventory after conversion
Our conversion brings across the accounting data associated with Inventory and not stock management data. Please see here for How inventory data is converted. About Tracked Inventory Inventory items are converted as 'Un-tracked Items' this allows ...
WET/WEG Tax Codes
The only way we can convert transactional data is if WET/WEG are removed from your source file for any tax amounts which are not 0 or 10%. If you have not used this tax code then there is a good chance you can remove it from the source file ...
Transaction types that may lead to issues
We always try to deliver the conversion with full transactional history. On occasions, if the following transaction types occur extensively we may only be able to provide a service with no or reduced history. In some instances it may prevent us ...
Custom/Non-standard Tax Codes
Australia Australian accepted tax codes The image below displays the standard tax codes that are accepted by Xero in Australia: The source file will require adjustments if you have used tax codes that are other than 0 and 10% as Xero does not accept ...