Tracked Inventory after conversion

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 the items to be connected to the COGS account and the Sales account. Your source file may allow tracked items to be connected to the COGS account, sales account and inventory account.

In this scenario inventory accounts are set up as 'other assets' and as Xero does not have an 'other assets' account the inventory accounts are generally converted 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.

Setting up Inventory Tracking in Xero

This is a two-step process:

Step 1: Setting up Inventory Asset Accounts & Inventory Tracking:

  1. Set up Inventory accounts - Inventory (Asset), COG and Adjustment (Expense) (Check each code and category)
     
  2.     
  1. The details contained in each row will become the default settings for that particular Inventory Item. If the purchase and name details are missing you can copy the sale description column and paste it into the purchase description and name column.






c. At the end of the spreadsheet there will be two additional columns, these are Inventory Asset Account and Cost of Good account. If you wish to track the inventory items then these two              columns will need to be completed with the relevant accounts.








d. Save as a .csv
e. Import .csv into Xero


Note: Xero will not allow you to bring in a .csv file if there are over 1000 items. If you have over 1000 items please split the .csv so that there are under 1000 items.


Step 2: Importing opening balances:

Once the items have been re-imported into Xero you can now update the opening balances.

  1. Under the Business tab select 'Products and Services'
  2. From the Import drop-down select opening balances 
  3. Select your Opening Balance Date
  4. Download template with existing opening balances
  5. Update template Including the quantity balances for each item
  6. Save as a .csv
  7. Import updated figures into Xero

If you're not changing the balance of the account that holds the value of your inventory item your Adjustment Account will be the same as your Inventory Asset AccountHowever, if you are changing the balance of this account, the Adjustment Account and the Inventory Asset Account will be different.


For example, if you want to move the balance from the original Inventory account then you will need to use this as the Adjustment Account
Any purchase orders and quotes that are in existence will need to be updated to reflect the new accounts and details. This will ensure that the details flow into the inventory for all purchase orders, quotes, invoices and bills.


Once you have imported the opening balances for inventory it is worthwhile checking your tax defaults for the sales and purchases to ensure that this remains consistent. You can check your tax defaults for sales and purchases in your financial settings. This helps with the flow when creating future purchase orders, quotes and invoices. 


If you are unsure use the Demo company for practice before importing it into your Xero organisation. 



    • Related Articles

    • Inventory Items

      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 ...
    • 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' ...
    • 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 ...
    • MYOB (AU & NZ)

      MYOB Preparation Checklist It is ESSENTIAL you work through the information detailed on this page before uploading your file for conversion. This will ensure that you will have a cleaner conversion to Xero, and highlight if there are any outstanding ...
    • Conversion Support

      You have a variety of support options to choose from, depending on what works best for you. Pre-conversion Prior to converting your file, we encourage you to get in touch to discuss your conversion needs.  You can email us at support@jetconvert.com ...