Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Level 7
November 29, 2018
Question

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?

  • November 29, 2018
  • 2 replies
  • 8 views
No text available

2 replies

November 30, 2018

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
November 30, 2018

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

 @lindak1119

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