cancel
Showing results for 
Search instead for 
Did you mean: 
Tiffiny Taylor Krugh
Level 4

delete opening inventory entry

I mistakenly created a handful on inventory products with opening balances.  I have since decided not to include those items in my inventory.  I made inactive the products but an uncle to remove the "Inventory Starting Value" entry in the "Opening Balance Equity" & the "Inventory Asset" accounts, both have zero balances.  

I wouldn't mind so much but these items are constantly listed at the bottom of the "Purchases by Product/Service Detail" report each time I run it.

Solved
Best answer August 26, 2020

Best Answers
AlexV
QuickBooks Team

delete opening inventory entry

I understand that you want to delete an item, juliaah33.

 

The best option I can suggest is to adjust it to zero out the quantity on hand. You can follow these steps:

  1. Go to the + New button and select Inventory Qty Adjustment.
  2. Enter the Adjustment Date and the Inventory adjustment account.
  3. Select the Product and enter the new quantity.
  4. Click Save and close.

Once done, you can review  your Asset and Opening Balance Equity account to see the adjustments.

 

I'll be here if you need more help. Have a great day!

View solution in original post

Mark_R
Moderator

delete opening inventory entry

Thank you for posting here in the Community, Tim.

 

Let's modify the starting date of the item created so you can use it when processing estimates or purchase order (PO).

 

Inventory items that were added fall before the date you're trying to create a transaction can't be used. To get this fixed, please follow the steps below:

 

  1. Click Sales from the left menu, then select Products and Services.
  2. Find the created item and click Edit under the Action column.1.PNG
  3. Under Quantity on Hand, click Starting Value. A message will appear warning not to change this value, select Got it!3.PNG
  4. Change the As of date field to the correct date. This item can only be added on transactions that are dated on or after this date.2.PNG

I'm adding this article to learn more about tracking inventory in QuickBooks Online: Set up and track your inventory.

 

Just in case you want to change the product and service item types, here's an article you can read for the detailed information: Change product and service item types in QuickBooks Online.

 

Keep in touch if you need any more assistance with this, or there's something else I can do for you. I've got your back. Have a good day.

View solution in original post

6 Comments 6
Rustler
Level 15

delete opening inventory entry

in the chart of accounts use the register for inventory asset, find the item and find the entry that says START, edit that entry to zero qty and zero cost

Tiffiny Taylor Krugh
Level 4

delete opening inventory entry

Thank you.  I had done that previously.  I just would like to delete the entries all together but there is no option to do so.  Now, these mistakenly created inventory items will ALWAYS be listed on my reports even with a zero value associated with them. 

juliaah33
Level 2

delete opening inventory entry

I'm having the same issue. Even the transaction deleter apps say you can't delete an Inventory item only make it Inactive so I think the starting balance entries are stuck there permanently.

 

AlexV
QuickBooks Team

delete opening inventory entry

I understand that you want to delete an item, juliaah33.

 

The best option I can suggest is to adjust it to zero out the quantity on hand. You can follow these steps:

  1. Go to the + New button and select Inventory Qty Adjustment.
  2. Enter the Adjustment Date and the Inventory adjustment account.
  3. Select the Product and enter the new quantity.
  4. Click Save and close.

Once done, you can review  your Asset and Opening Balance Equity account to see the adjustments.

 

I'll be here if you need more help. Have a great day!

sydexusa
Level 2

delete opening inventory entry

Did you ever get this fixed?  Please help.  I entered an item with the wrong start date now it won't let me use it in an estimate or PO.

Tim

Mark_R
Moderator

delete opening inventory entry

Thank you for posting here in the Community, Tim.

 

Let's modify the starting date of the item created so you can use it when processing estimates or purchase order (PO).

 

Inventory items that were added fall before the date you're trying to create a transaction can't be used. To get this fixed, please follow the steps below:

 

  1. Click Sales from the left menu, then select Products and Services.
  2. Find the created item and click Edit under the Action column.1.PNG
  3. Under Quantity on Hand, click Starting Value. A message will appear warning not to change this value, select Got it!3.PNG
  4. Change the As of date field to the correct date. This item can only be added on transactions that are dated on or after this date.2.PNG

I'm adding this article to learn more about tracking inventory in QuickBooks Online: Set up and track your inventory.

 

Just in case you want to change the product and service item types, here's an article you can read for the detailed information: Change product and service item types in QuickBooks Online.

 

Keep in touch if you need any more assistance with this, or there's something else I can do for you. I've got your back. Have a good day.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us