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

Rate from my vendor bill doesn't add up to inventory cost under Product/ Services. How to connect rate to inventory cost? Should I manually change cost every time?

 
2 Comments 2
Anonymous
Not applicable

Rate from my vendor bill doesn't add up to inventory cost under Product/ Services. How to connect rate to inventory cost? Should I manually change cost every time?

Thanks for visiting the Community, Sezin,

 

I can share some information about the inventory cost in QuickBooks Online.

 

Currently, updating the item rate on your bill does not update the original cost in the Products and Services. For you to add a new cost, you'll need to edit your inventory items one at a time.

 

Being able to do this option to your bills is a great idea, and I would like to put this forward to our developers so I'd encourage you to send them your product suggestion.

 

Here's how to send your product request: 

  1. Click the Gear icon.
  2. Select Feedback.
  3. Enter your suggestion.
  4. Click Next.
  5. Click Skip and send message.
  6. Select a Category.
  7. Click Send message.

I'll also do the same thing on my end to reinforce you request. Your suggestion goes directly to our developers who consider feedback for QuickBooks enhancements.

 

Please keep me in the loop if you need further assistance with QuickBooks, Sezin. I'll be your happy guide. Have a good one!

Rustler
Level 15

Rate from my vendor bill doesn't add up to inventory cost under Product/ Services. How to connect rate to inventory cost? Should I manually change cost every time?

Jen_D said
Currently, updating the item rate on your bill does not update the original cost in the Products and Services.
Of course it does, the rate on the bill is how inventory items get the cost per item per purchase.

For you to add a new value, you'll need to edit your inventory items one at a time.
You do NOT adjust item value, and in QBO you can not do that anyway

 @sezin

The cost you see per item in QBO reporting is not always correct, QBO inventory reporting is terrible.

QBO keeps FIFO inventory which is average cost per purchase.  When you sell an item the cost of the item sold is the first cost for that item and qty that was purchased.  ie

buy
widget, qty=3, $1.00 ea
widget, qty 10, $0.75 ea

Sell 5 each, the cost is
3 at $1, = $3
plus
2 at 0.75 = $1.50
total posted to cogs is $4.50

That $4.50 in cost will only show up in a transaction journal for the sale, and the detail posting in the COGS account, but you will never see that amount as item cost in any QBO inventory reports

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

Need to get in touch?

Contact us