cancel
Showing results for 
Search instead for 
Did you mean: 
jengebhardt
Level 2

Inventory Management

Good morning and thank you in advance for your help!

 

I am trying to help a new bookkeeping client with their inventory problem. They have been using QB as their point of sale in their store. They have entered all of their inventory items into QB, and when they make a sale, the inventory shows the item quantity decreasing. However, when they have purchased new inventory, I do not think they have used purchase orders and have been going in manually to adjust the item quantities in their inventory when they receive new items. So their P&L report shows a line item under COGS, "Inventory Shrinkage" with a negative $ amount. From what I can gather, I think I have a fix but I would really appreciate if anyone could verify if this might solve their problem:

 

If I were to retroactively create purchase orders for their inventory purchases for every one of these quantity adjustments and then match those POs to show they have been paid, would this automatically create the correct inventory quantity adjustments? And then I could delete the manually entered adjustments that were coming up as "inventory shrinkage?"

 

Thank  you so much for your help!

Jennifer Gebhardt

2 Comments 2
Rustler
Level 15

Inventory Management

PO's are non posting, they are just a memo of what is ordered

 

You do not just go in and adjust the qty higher, the item(s) have to ordered. You do that by listing each item on the item detail part of a bill and using pay bills, or just making a payment at home depot or somewhere for the items.

 

Best option is to enter the purchases, then just delete the entries that use inventory shrinkage. Inventory shrinkage is or should be only used after a physical inventory.

 

jengebhardt
Level 2

Inventory Management

Okay so create bills for the "inventory shrinkage" items and mark them paid, generating a new unit in inventory, then delete the unit marked inventory shrinkage?

 

Sorry, just want to make sure I've got it right!

Need to get in touch?

Contact us