Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowHello, how do I get my cost in inventory to be automatically updated when I enter a new vendor bill? I have my inventory list already in QBO+, and I am now adding in vendor bills. But, when I finish the bill and make the payment, only the quantity value is appropriately adjusted. How do I get the cost to be appropriately adjusted as well? We are a jewelry company, so our purchase costs for precious metals fluctuate with the current market cost and I would like to reflect this in my reports. I am new to Quickbooks and am imputing information for multiple years. Thank you.
@Nicole87 wrote:
Hello, how do I get my cost in inventory to be automatically updated when I enter a new vendor bill? I have my inventory list already in QBO+, and I am now adding in vendor bills. But, when I finish the bill and make the payment, only the quantity value is appropriately adjusted. How do I get the cost to be appropriately adjusted as well? We are a jewelry company, so our purchase costs for precious metals fluctuate with the current market cost and I would like to reflect this in my reports. I am new to Quickbooks and am imputing information for multiple years. Thank you.
In QBO. they use the FIFO method. Total asset value is based on the average cost of inventories.
You may want to review this article and follow the steps.
Set up and track your inventory in QuickBooks Online
I can see that this is your first post so let take time to welcome you to the Community space, Nicole87.
I also want to thank you for choosing QuickBooks Online as one of your business partners.
Currently, the option the automatically change the cost of an item or services through a bill is unavailable in QuickBooks Online. This feature is only available in QuickBooks Desktop as for now and it's called Automatic Item Cost Change. Once we enter a different amount on the bill, the program will automatically prompt us if we'd like to apply that certain cost to the item.
Please know that we roll out product enhancements based on the requests that we received from our customers. I'll be taking this post as feedback and share it with our Product Design Team for consideration.
We'll keep you in the loop on our updates and will share any details as soon as we have them through our blog.
For now, we can manually change the cost of your item so that to be updated with the current market cost. You can follow these simple steps:
I've also included an article that will guide in tracking the things that you buy and sell, and the status of your inventory: Use reports to see your sales and inventory status.
We're open 24/7 here, so please don't hesitate to visit us if you need more help in managing your inventory. As always, assistance is just one post away.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.