cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
venessapowell
Level 1

Duplicated Inventory

I added items to inventory then created a bill for the supplier. This ended up duplicating the amount in my inventory. How do I fix this?

4 Comments 4
Rasa-LilaM
QuickBooks Team

Duplicated Inventory

Let's adjust the inventory quantity for your items to keep your record in order, venessa. I'm here to ensure you can do this task in just a few clicks.

 

Here's how:

 

  1. In QuickBooks Online (QBO), tap the New menu in the upper-left and choose Inventory qty adjustment under Other.
  2. Enter the date in the Adjustment date field.
  3. Click the Inventory adjustment account drop-down and select the appropriate account.
  4. Type the item name in the Product field.
  5. The description and current quantity on hand auto-populate.
  6. For each item, enter either a new quantity or a change in quantity.
  7. In the Memo field, key in the details about the adjustment.
  8. Press the Save and close button.

 

This reference provides in-depth information on the process: Adjust inventory quantity on hand in QuickBooks Online. It includes instructions on how to edit or delete an adjustment.

 

Furthermore, this link contains a list of topics that tackles managing your items, products, and services: Self-help articles. Simply choose the resources that best address your concern. 

 

Keep me posted if you have other inventory concerns or need further assistance while working in QBO. I'll jump right back in to respond to them. Enjoy your day. 

venessapowell
Level 1

Duplicated Inventory

I would have to do inventory now to determine the quantity on hand to make this adjustment. Why is it duplicating though? Do I just not add the vendor as an expense? How do I enter the inventory in the first instance so as not to have this duplication?

JamesAndrewM
Moderator

Duplicated Inventory

Thanks for getting back to the thread, @venessapowell. I'll chime in and share my thoughts on how you can manage your inventory.

 

QuickBooks Online has everything you need to manage your inventory. Track your inventory, get notified when it's back in stock, and gain insight into your purchases and sales. If you haven't enabled these settings, here's how:

 

  1. Go to Settings ⚙ and select Account and Settings.
  2. Select the Sales tab.
  3. Choose Edit ✎ in the Products and Services section.
  4. Turn on Show Product/Service column on sales forms.
  5. You can also turn on price rules if you want to set up flexible pricing for the things you sell.
  6. Turn on both Track quantity and price/rate and Track inventory quantity on hand.
  7. Click Save and then Done.

 

After enabling the inventory tracking, you can proceed in adding your inventory products:

 

  1. Go to Get Paid & Pay and select Products & Services (Take me there).
  2. Click New or Add a Product or Service. Then select Inventory.
  3. Add a NameSKU, or Category for what you're tracking. Tip: Categories let you group your products and services together so they’re easier to find.
  4. Choose the unit from the Unit* ▼ dropdown.
  5. Click the category from the Category ▼ dropdown.

 

For detailed information and the following steps, visit these articles:

 

 

Additionally, this reference will help you in checking the best sellers, what is on hand, the cost of goods, and more among all of your items: Use reports to see your sales and inventory status.

 

For additional QuickBooks-related concerns, don't hesitate to post them here in the Community. We're always available and willing to lend a hand to your queries. Have a great day ahead.

Rainflurry
Level 14

Duplicated Inventory

@venessapowell 

 

If you receive a bill from your vendor, add the items to the bill and that will put them into inventory.  There is nothing else you need to do.  When you added them manually, you duplicated the entry and also added an entry to whatever account you selected in the 'Inventory adjustment account' pull-down.  As long as the bill added the same number of items as your inventory quantity adjustment you can delete the quantity adjustment and everything should be fine.

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Need to get in touch?

Contact us