cancel
Showing results for 
Search instead for 
Did you mean: 
UserLE
Level 1

All of my inventory has been entered incorrectly. How do I fix the quantity without receiving bad debt or inventory shrinkages?

I have done a physical inventory check and have realized that all my inventory entered on quickbooks does not match my physical inventory significantly. I need to fix this issue immediately so I don't continue to sell products that aren't in stock on the website. 

The inventory shows:

  1. I have positive quantities in-stock on QB but I actually have zero in-stock in my physical inventory (example: 12 in-stock on QB but physically 0 in-stock)
  2. I have less in-stock physically (at least more than zero quantity) than I do in-stock on QB (for instance QB says I have 12 in-stock but physically I have 8 in-stock)

How do I change these inventory quantities to the correct quantities that I have in-stock without QB documenting the changes as bad debt or inventory shrinkages? The numbers are simply wrong and I would like to change them without it showing that I have lost money. I haven't lost any money, my inventory was just entered incorrectly.

3 Comments 3
Catherine_B
QuickBooks Team

All of my inventory has been entered incorrectly. How do I fix the quantity without receiving bad debt or inventory shrinkages?

Hello there, UserLE. 

 

Sometimes you might see that you have either more or fewer of an item than QuickBooks shows. If you track inventory in QuickBooks Online Plus and Advanced, we can manually adjust an item's quantity without recording a purchase or sale, to match what you actually have in stock.

 

However, when you save the inventory adjustment, we automatically record appropriate adjustments to your stock Asset and Cost of Goods Sold (under stock Shrinkage) accounts for our reports to be accurate. You can check this article for more details: Adjust inventory quantity on hand in QuickBooks Online.

 

On the other hand, we have the option to delete and recreate the items entering the correct quantity on hand. Set up and track your inventory in QuickBooks Online

 

I'm here if you have other questions. Take care!

Rustler
Level 15

All of my inventory has been entered incorrectly. How do I fix the quantity without receiving bad debt or inventory shrinkages?

@UserLE 

 

in the chart of accounts, open the register for inventory asset

 

each line that has a START notation is the starting stockage entry for that item, edit them as needed

LewisH95
Level 2

All of my inventory has been entered incorrectly. How do I fix the quantity without receiving bad debt or inventory shrinkages?

There are a number of reasons for inventory shrinkage. Inventory shrinkage can take place when items, such as expired produce, are naturally no longer sellable. Or, shrinkage might be due to damaged items.

Inventory shrinkage may also be the result of errors. You or one of your employees might miscount items. Your vendor might also make errors when they supply you with inventory items.

In some cases, you might have inventory shrinkage because of malicious actions, such as theft, shoplifting, or fraud. Vendors may commit fraud and give you less inventory than what you purchased. Or, employees might steal inventory. Shrinkage is also common when customers shoplift from your business.

A shrinkage expense account will be recorded under the Cost of Goods Sold (COGS) It includes material cost, direct labor cost, and direct factory overheads, and is directly proportional to revenue. As revenue increases, more resources are required to produce goods or services. COGS is often an account.

Need to get in touch?

Contact us