Convert untracked items to tracked items in inventory
You can convert an untracked item to a tracked item. You would do this if you want to start recording the item's quantity and value on hand. Once you've converted the item, enter the opening balance so Xero can keep an accurate record of your holdings.
Xero starts tracking the item after it's been converted. You cannot backdate tracking.
Learn about tracked inventory items:
If you're not sure whether tracked inventory items are right for your organization, check out Xero's inventory options.
You can convert a tracked item to an untracked item in some situations.
Points to note about converting untracked items to tracked items
Once you convert an untracked item to a tracked item, you can only reverse the conversion in some situations
You can only reverse the conversion if you haven't either:
- Used the tracked item in a transaction
- Made an adjustment to the tracked item
Be sure that you want to start tracking the item before you convert it.
You cannot convert an untracked item which has been used on a repeating invoice or repeating bill
You can remove the inventory item from the repeating transaction first, then convert it. Delete the item from the repeating transaction, convert the item to a tracked item, then reenter the item on the repeating transaction.
You'll need to ensure that you mark invoices and bills as approved so that inventory records are updated
Xero updates quantities and values of tracked inventory items when you mark invoices and bills as approved.
Get ready to convert your untracked item or items
Before you convert the item, enter in Xero all outstanding transactions using the item. This ensures that Xero's starting inventory quantity for this item will match your quantity on hand.
After conversion, when you enter new invoices, bills, credit notes, spend money and receive money transactions using that item, Xero will update the item's quantity and value on hand regardless of the transaction's date.
If you don't already have any tracked items, you'll need to take some setup steps first.
After you've checked that you are set up for tracked items:
Go to Accounts, then Inventory.
Click anywhere on the line of the item you want to convert.
Click Edit item.
Select the checkbox I track this item.
Select the Inventory Asset Account to use for this item.
Select and enter other information you want to display whenever you use the inventory item in transactions.
Convert multiple untracked items to tracked items at once
If you have many untracked items you want to convert to tracked items, you can do this in one go using Xero's export and import functions.
To convert multiple untracked items:
Open the CSV file. Delete the lines of the items you don't want to convert.
Enter or update information for your inventory items you want to track.