Step-by-Step Guide: How to Update Item Cost in QuickBooks Online
Step-by-Step Guide: How to Update Item Cost in QuickBooks Online
Managing accurate item costs in QuickBooks Online is essential for maintaining correct profit margins, inventory valuation, and financial reporting. As purchase prices change due to supplier adjustments, shipping fees, or market fluctuations, you must update item costs regularly to ensure the system reflects real expenses. This guide explains why item cost updates are important, how to update item costs correctly, and what to do if you encounter problems.
Why Updating Item Cost Matters in QuickBooks Online
Accurate Profit Margins
If costs change but selling prices stay the same, your profit calculations become inaccurate. Updating costs helps maintain correct margin tracking.
Correct Inventory Valuation
QuickBooks Online uses item cost to calculate your inventory asset values. Incorrect costs lead to inaccurate financial reports.
Better Pricing Decisions
Updated costs help you evaluate whether to adjust selling prices or negotiate with vendors.
Reliable Reporting
Reports such as Cost of Goods Sold (COGS), Inventory Valuation Summary, and Profit & Loss depend on precise item cost data.
Before Updating Item Cost: Important Things to Know
QuickBooks Online uses FIFO (First In, First Out) for inventory valuation.
Updating the item cost does not change previous transactions.
Changing the item cost affects future transactions only, not past inventory values.
You must have Plus or Advanced versions to use inventory features.
Make sure you have Inventory tracking enabled in settings.
Verify that no other users are editing the same item or stock levels.
How to Update Item Cost in QuickBooks Online (Step-by-Step)
Step 1: Go to the Sales or Expenses Menu
You can access your items from either:
Sales → Products and Services, or
Expenses → Vendors → Items
Most users prefer the Products and Services list.
Step 2: Locate the Item You Want to Update
Scroll or use the search bar to find the inventory or non-inventory item.
Click the Edit button on the right side of the item.
Step 3: Update the Cost Field
Inside the item information window:
Look for the Cost field.
Enter the updated cost based on the new supplier or purchase price.
Note: This cost does not immediately affect past purchases — it applies to future transactions only.
Step 4: Save Your Changes
Once the new cost is entered, select Save and Close.
Your item cost is now updated and will be applied to future purchase orders, bills, and vendor transactions.
How to Update Item Cost Through a Vendor Bill (Alternative Method)
Sometimes item costs update automatically when you enter a new vendor bill. QuickBooks may prompt you to adjust the item cost based on the bill amount.
Step 1: Create or Open a Vendor Bill
Enter the vendor, items purchased, quantities, and amounts.
Step 2: Enter the New Cost
If the cost differs from the current item setup, QuickBooks will detect a mismatch.
Step 3: Accept the Cost Update Prompt
A message may appear:
Asking if you want to update the item cost
Asking if you want to update the sales price (optional)
You can choose:
Only update cost
Update both cost and price
Ignore
Step 4: Save the Bill
Once saved, the new cost will update for future calculations.
How to Update Selling Prices After Changing Item Cost
Adjusting costs often impacts pricing decisions. You may want to review your sales prices.
Step 1: Go to Products and Services
Open the product list.
Step 2: Edit the Item
Select Edit next to the item.
Step 3: Adjust the Sales Price
Enter the new sales price that matches your target margins.
Step 4: Save and Close
This helps you maintain profitability after cost changes.
How QuickBooks Online Handles Item Cost Changes (FIFO Method)
QuickBooks uses FIFO, meaning oldest inventory costs are used first.
If you change the cost today, it affects new inventory entries only.
Existing stock retains its original cost based on previous purchase dates.
Cost changes do not affect already posted COGS or sales transactions.
Inventory valuation reports adjust only after new stock entries.
Understanding FIFO is crucial when analyzing COGS differences or profit fluctuations.
Troubleshooting Item Cost Update Issues in QuickBooks Online
1. Cost Won’t Update
Possible Causes:
You are editing a bundle item
Item type is non-inventory and cost field isn't shown
Browser cache causing display issues
Solutions:
Ensure you have an inventory item selected
Clear browser cache or switch browser
Enable inventory tracking in Account and Settings
2. QuickBooks Did Not Prompt Me to Update Cost After Vendor Bill
Possible Causes:
Automatic cost update prompt disabled
Vendor bill matched current cost
Solutions:
Edit the item manually
Change the bill cost significantly, then retry
Check your item setup to ensure it's inventory-tracking enabled
3. Inventory Valuation Didn’t Change After Cost Update
Explanation:
Cost changes only affect new inventory, not existing stock under FIFO.
Solution:
Enter a new purchase to apply new cost
Run a valuation report after new inventory arrives
4. Changes Do Not Reflect in Sales Transactions
Explanation:
Past invoices or sales receipts do not change retroactively.
Solution:
Only future sales reflect updated costs
If needed, adjust sales prices manually
Best Practices for Updating Item Costs in QuickBooks Online
Review item costs monthly or quarterly.
Update cost immediately when vendor pricing changes.
Use vendor bill prompts to keep item costs consistent.
Reevaluate sales prices when cost changes affect margins.
Keep an eye on reports like Inventory Valuation Summary.
Maintain proper vendor item records for accuracy.
Avoid editing costs for existing high-volume inventory to prevent confusion.
When You Should Update Item Cost Immediately
Supplier price change occurs.
New shipping or freight costs increase your expenses.
Discounts or bulk pricing adjustments occur.
Your profit margin reports show unexpected decreases.
You introduce a new version or variation of the product.
You find inconsistencies in inventory valuation reports.
Updating costs promptly keeps your financial data reliable.
Conclusion
Updating item cost in QuickBooks Online is essential for accurate financial reporting, correct inventory valuation, stable profit margins, and effective pricing strategies. Whether you update costs manually through the Products and Services list or automatically through vendor bills, each method ensures your accounting records reflect real business expenses. Understanding how FIFO impacts cost updates helps you interpret your inventory reports correctly. By following this step-by-step guide and applying the troubleshooting tips provided, you can keep your QuickBooks Online data accurate and aligned with your business goals.