QuickBooks Inventory Tracking for Small Businesses: Purchases, Stock & Cost of Goods Sold
Published By IndiaBizExperts | Reviewed by Authorized Chartered Accountant: CA Unit Kr Jha
Inventory can be one of the most important assets in a product-based business—and one of the easiest areas of bookkeeping to get wrong. If your business buys and sells physical products, inaccurate stock records can lead to unexpected stockouts, unnecessary purchases, unreliable profit reports, and confusing year-end financial statements.
QuickBooks can help eligible businesses maintain inventory records, record purchases and sales, monitor stock levels, and understand the cost of goods sold (COGS). However, the software is only as reliable as the transactions, opening quantities, product costs, and inventory adjustments entered into it.
This guide explains how QuickBooks inventory tracking works, how to organize product records, how purchases affect inventory, how COGS is calculated, and how to investigate common discrepancies. It is written for US small-business owners, retailers, wholesalers, and e-commerce sellers who want more dependable bookkeeping.
Important: QuickBooks features vary by product and subscription. The instructions below primarily discuss QuickBooks Online's built-in inventory functionality. Check your current plan and product documentation before applying them to your account.
Table of Contents
- What is inventory tracking in QuickBooks?
- Which businesses need inventory tracking?
- Inventory asset, sales income, and COGS explained
- How to set up inventory in QuickBooks Online
- How to record inventory purchases
- How to record inventory sales
- How to understand cost of goods sold
- Practical example: inventory and gross profit
- How to reconcile physical stock with QuickBooks
- Common inventory bookkeeping mistakes
- Inventory reports to review
- Monthly inventory checklist
- When should you seek bookkeeping help?
- Frequently asked questions
1. What Is Inventory Tracking in QuickBooks?
Inventory tracking is the process of maintaining records of the products your business owns for resale or production. A useful inventory system records how many units you have, what those units cost, what you sell, and how much inventory remains.
Where supported and properly configured, QuickBooks Online can help you:
- Maintain product records and stock quantities.
- Record inventory purchases and the receipt of goods.
- Reduce quantities when inventory items are sold.
- Monitor low-stock levels and reorder points.
- Track inventory asset values and cost of goods sold.
- Review inventory reports to identify unusual balances or trends.
These features do not automatically guarantee that the books match the warehouse or shop floor. Returns, damaged products, missing stock, duplicate entries, shipping integrations, and incomplete purchase records can still create differences.
2. Which Businesses Need Inventory Tracking?
Inventory tracking is particularly useful when a business purchases, manufactures, stores, or sells physical products.
| Business type |
Examples of inventory |
Key tracking concern |
| Retail store |
Clothing, home goods, electronics |
Stock availability, shrinkage, and margins |
| E-commerce business |
Products stored at home, in a warehouse, or with a fulfillment provider |
Sales-channel quantities, returns, and fulfillment records |
| Wholesale distributor |
Bulk products purchased for resale |
Purchase costs, quantities, and supplier invoices |
| Manufacturer |
Raw materials, work in process, finished goods |
Production costs and inventory valuation |
| Repair or installation business |
Parts and materials |
Distinguishing resale inventory from supplies consumed in jobs |
A business that sells only services may not need product-level inventory tracking. A business that also sells merchandise or uses significant materials in providing services may need a more tailored approach.
Businesses selling through marketplaces or multiple sales channels should also confirm whether their chosen integrations synchronize inventory quantities, orders, returns, and product costs. A connection between two systems does not necessarily mean every inventory field synchronizes automatically.
3. Inventory Asset, Sales Income, and COGS Explained
Three accounting concepts are central to understanding inventory in QuickBooks.
Inventory Asset
Inventory Asset represents the recorded cost of goods the business still owns and expects to sell or use in production. It is generally reported as a current asset, subject to the nature of the inventory and applicable accounting presentation.
Sales Income
Sales Income records the revenue earned from selling products. The sales price is not the same as the cost of the item. A product can generate revenue while still having a relatively small gross profit after its cost is deducted.
Cost of Goods Sold (COGS)
COGS represents the cost assigned to products sold during a period. It is generally shown as an expense on the profit and loss statement. Depending on the business and applicable accounting method, product costs may include more than the supplier's invoice price.
In QuickBooks Online's built-in inventory workflow, inventory asset and COGS accounts are used to track the value of goods held and the cost assigned to sold goods. QuickBooks documents the use of average cost for its inventory valuation calculations. Confirm the applicable accounting treatment for your business before making manual adjustments. See Intuit's guide to inventory assets and COGS.
4. How to Set Up Inventory in QuickBooks Online
Before adding inventory, decide which products need quantity tracking, verify your starting stock, and gather reliable purchase-cost information. If the business has been operating for a while, avoid entering estimated opening quantities without documenting how they were determined.
Step 1: Confirm that your plan supports inventory
Intuit's current QuickBooks Online guidance lists built-in inventory features for Plus and Advanced, while options for other subscriptions may differ. Check your account's current feature availability before starting.
Official instructions: Set up and track inventory in QuickBooks Online.
Step 2: Enable inventory tracking
In supported versions, open the settings area and locate the sales or product-and-service settings. Enable the relevant product fields and inventory quantity tracking options. Menu names may change as QuickBooks updates its interface.
Step 3: Create a consistent product list
For each inventory item, prepare the information required by your workflow. Common fields include:
- Product name and SKU or internal identifier.
- Product description.
- Opening quantity and the date that quantity applies to.
- Sales price and appropriate income account.
- Purchase cost and appropriate COGS account.
- Inventory asset account.
- Reorder point, if used.
- Preferred supplier, where useful.
Use consistent product names and SKUs across your accounting records, warehouse spreadsheet, and sales channels. Avoid creating a new item every time the same product is purchased.
Step 4: Verify opening stock
Count the products physically held by the business as of a clearly documented date. Compare that count with supplier records, sales records, and the previous accounting system. Record the method used to determine the opening cost and have a qualified bookkeeper or accountant review material opening balances.
Step 5: Test the process with a small number of items
Before importing hundreds of products, test a purchase, a sale, a customer return, and an inventory adjustment where relevant. Confirm that the quantities and financial reports change as expected.
For official product setup instructions, refer to Intuit's guide to adding inventory products.
5. How to Record Inventory Purchases
Inventory purchases should be recorded using the transaction type that reflects what actually happened. A purchase order, a supplier bill, a card expense, and the receipt of goods are not necessarily interchangeable records.
When goods are ordered but have not arrived
A purchase order can document the items and quantities ordered. A purchase order by itself does not necessarily mean the goods have been received or that a payable should be recorded. Follow the accounting and receiving workflow appropriate to your business.
When goods arrive and the supplier will be paid later
Record the supplier bill using the correct vendor, product, quantity, cost, and due date. Where your QuickBooks workflow supports linking the bill to a purchase order, review the matched quantities and prices before saving.
When goods are purchased and paid for immediately
Record the purchase using the appropriate transaction type and product details. Check that the payment account is correct and that the entry increases the quantity and value of the appropriate inventory items when required by your workflow.
Check the supplier invoice carefully
- Confirm that the products and quantities match what was received.
- Compare the invoiced price with the purchase order and agreed terms.
- Record purchase returns, discounts, and allowances appropriately.
- Review freight and other costs to determine whether they should form part of inventory cost under the applicable accounting rules.
- Investigate partial shipments and backorders rather than assuming the full order arrived.
Practical tip: Do not record the same purchase once as an expense and again as an inventory bill. Duplicate purchase entries can overstate expenses, payables, or inventory balances.
6. How to Record Inventory Sales
When inventory is sold, two financial effects commonly need to be reflected: the business records the sale, and the cost of the goods sold is transferred from inventory to COGS. With supported QuickBooks inventory items and properly configured transactions, the software can handle these entries as part of its normal inventory workflow.
Invoice sale
Use an invoice when the customer will pay later. Select the correct inventory item and quantity, verify the price and applicable sales-tax settings, and ensure the customer and invoice date are correct.
Immediate-payment sale
Use the appropriate sales receipt workflow when the customer pays at the time of sale. Confirm the payment method and the account where the proceeds should be recorded.
Customer returns and refunds
Returns should be recorded in a way that reflects the actual outcome. A product returned in saleable condition may be returned to stock, while a damaged product may require a different treatment. Avoid simply increasing stock without documenting the return and its financial effect.
Sales-channel imports
If orders arrive from an online marketplace, point-of-sale system, or e-commerce platform, review the integration settings. Depending on the integration, orders, fees, refunds, taxes, inventory quantities, and settlement deposits may require different handling. Reconcile imported transactions to the underlying channel reports and bank deposits.
For additional context on revenue and unpaid customer invoices, read our related article on QuickBooks accounts receivable, if that URL is published and accessible.
7. How to Understand Cost of Goods Sold
COGS helps a business understand the direct cost assigned to products sold during a reporting period. It is a key input in calculating gross profit.
A simplified COGS formula
Beginning inventory + net inventory purchases and other applicable inventory costs − ending inventory = cost of goods sold.
This is a simplified formula. The exact calculation depends on the business's accounting method, inventory system, production costs, returns, personal withdrawals, freight treatment, and applicable tax and accounting rules.
Why COGS matters
- It helps calculate gross profit.
- It helps identify changes in product margins.
- It supports pricing and purchasing decisions.
- It helps explain how inventory changes affect reported profit.
- It supports financial reporting and tax preparation when maintained under the applicable rules.
Inventory cost is not always the same as the supplier's unit price
For some businesses, inventory costs can include qualifying freight, production labor, or overhead. Other costs may need to be recorded separately. The treatment depends on the type of business and the applicable accounting rules; do not automatically add every shipping or operating expense to inventory.
The IRS explains inventory and COGS considerations for US businesses in Publication 334, Tax Guide for Small Business. Inventory tax treatment can depend on eligibility and the taxpayer's accounting method, so obtain tax advice for your circumstances.
8. Practical Example: Inventory and Gross Profit
Suppose a small retailer starts the month with 100 units of a product recorded at $10 per unit. During the month, it buys another 50 units at $12 per unit. It sells 80 units for $20 each. For illustration, assume no returns, additional inventory costs, discounts, or other adjustments and use a consistent average-cost approach.
| Item |
Calculation |
Amount |
| Beginning inventory |
100 × $10 |
$1,000 |
| Purchase |
50 × $12 |
$600 |
| Units available |
100 + 50 |
150 units |
| Total recorded inventory cost |
$1,000 + $600 |
$1,600 |
| Illustrative average cost per unit |
$1,600 ÷ 150 |
$10.67 approximately |
| Sales revenue |
80 × $20 |
$1,600 |
| Illustrative COGS |
80 × $10.6667 approximately |
$853.33 approximately |
| Remaining quantity |
150 − 80 |
70 units |
| Illustrative ending inventory |
$1,600 − $853.33 |
$746.67 approximately |
| Illustrative gross profit |
$1,600 − $853.33 |
$746.67 approximately |
The figures are simplified and rounded for teaching. QuickBooks may calculate average cost using its transaction-level inventory rules, so its actual results may differ if transactions occur in a different order or there are additional purchases, returns, or adjustments.
What this example shows: sales revenue is not the same as gross profit. The cost assigned to the 80 units sold becomes COGS, while the recorded cost of the 70 remaining units stays in inventory, subject to appropriate adjustments and valuation rules.
9. How to Reconcile Physical Stock With QuickBooks
Inventory reconciliation compares the quantity and value in your accounting records with what the business actually holds. Perform counts regularly according to your business's risk, transaction volume, and operational needs, and complete a careful review at the reporting period end.
Step 1: Choose a count date
Set a clear date and, where possible, pause or carefully control inventory movements while counting. If transactions continue during the count, document them so the records can be adjusted to the same cutoff time.
Step 2: Count the stock physically
Count units by SKU and location. Separately identify damaged goods, expired products, customer returns, goods held by third parties, and items owned by the business but stored elsewhere.
Step 3: Compare with QuickBooks
Compare the physical quantity with the quantity on hand shown in the relevant product records or inventory report. Investigate differences before making adjustments.
Step 4: Find the cause
Common causes include unrecorded sales, duplicate bills, missing receipts, incorrect quantities, returns not processed, inventory moved between locations, shrinkage, and transactions entered with the wrong date.
Step 5: Make documented adjustments
In supported versions, QuickBooks Online provides an inventory quantity adjustment workflow. Record the count date, the actual quantity, the reason, and the appropriate adjustment account. Since adjustments can affect inventory assets, COGS, and reported profit, obtain professional review for material or unusual differences.
See Intuit's inventory quantity adjustment instructions.
10. Common Inventory Bookkeeping Mistakes
| Mistake |
Why it matters |
Recommended control |
| Incorrect opening quantities |
Stock and inventory value may be wrong from the start. |
Document the opening count, date, and valuation source. |
| Duplicate purchase entries |
Inventory, expenses, or accounts payable may be overstated. |
Match bills to purchase records and supplier statements. |
| Sales entered without inventory items |
Quantities or COGS may not update as intended. |
Use the correct product item and test the posting workflow. |
| Unrecorded returns |
Stock and revenue records may not reflect the real outcome. |
Link returns to the original sale where appropriate. |
| Negative quantities |
Sales may have been recorded before purchases or receipts. |
Review transaction dates and missing receiving entries. |
| Unexplained stock adjustments |
Financial reports may be distorted and shrinkage hidden. |
Keep count sheets, adjustment reasons, and approvals. |
| Incorrect product costs |
COGS and gross margins may be unreliable. |
Compare costs to invoices and review valuation reports. |
| Sales-channel mismatch |
Platform sales, refunds, and quantities may not agree. |
Reconcile channel reports, accounting entries, and deposits. |
If your company already has years of inconsistent entries, avoid making broad changes to old transactions without first reviewing the consequences. A structured cleanup can help identify the root cause and establish a reliable opening point.
11. Inventory Reports to Review
The reports available depend on your QuickBooks product and configuration. Where supported, review the following reports or equivalent product summaries:
- Inventory Valuation Summary: reviews the recorded value of inventory by item.
- Inventory quantity or stock-on-hand reports: help compare recorded quantities with physical counts.
- Profit and Loss: helps review sales, COGS, and gross profit for a selected period.
- Balance Sheet: helps review the inventory asset balance.
- Purchases and vendor transaction reports: help identify supplier activity and investigate missing or duplicate entries.
Use consistent date ranges and investigate material changes from prior periods. A report is a starting point for review, not proof that all underlying transactions are correct.
Related reading, if these pages are live: QuickBooks Profit and Loss Report and QuickBooks Chart of Accounts.
12. Monthly Inventory Checklist
- Review inventory purchases and confirm supplier invoices.
- Check that goods received are recorded correctly.
- Review sales, refunds, and customer returns.
- Investigate negative or unusual inventory quantities.
- Compare physical counts with QuickBooks records on a risk-based schedule.
- Document damaged, missing, obsolete, or personally withdrawn inventory.
- Review the inventory valuation report and COGS for unusual movements.
- Reconcile material balances and investigate unexplained differences.
- Confirm sales-channel and fulfillment records agree with the accounting records.
- Save count sheets, invoices, adjustment explanations, and other supporting documents.
13. When Should You Seek Bookkeeping Help?
You may benefit from an independent bookkeeping or accounting professional if:
- Your inventory asset balance does not agree with your records or physical count.
- COGS or gross profit changes unexpectedly.
- You have negative inventory quantities or unexplained adjustments.
- You are moving from spreadsheets or another accounting system into QuickBooks.
- You sell through multiple channels and cannot reconcile inventory movements.
- You need help reviewing inventory valuation or preparing year-end records.
IndiaBizExperts is a facilitation platform that helps businesses request connections with independent professionals. It does not itself provide bookkeeping, accounting, tax, or other professional services, and it is not affiliated with or endorsed by QuickBooks or Intuit.
Need help reviewing your QuickBooks inventory records? Request a connection through IndiaBizExperts to explore whether an independent professional may be suitable for your requirements. Professional fees and the scope of work should be confirmed directly with the professional.
14. Frequently Asked Questions
1. Can QuickBooks track inventory quantities automatically?
QuickBooks Online can update quantities through supported inventory workflows when inventory tracking is available and correctly configured. The accuracy of the result depends on recording purchases, sales, returns, and adjustments correctly. Confirm the features included in your subscription.
2. Which QuickBooks Online plans include built-in inventory tracking?
Intuit's current guidance lists built-in inventory features in QuickBooks Online Plus and Advanced. Availability and add-on options can change, so check the current official plan details for your account.
3. What is the difference between inventory asset and COGS?
Inventory Asset generally represents the recorded cost of goods still held by the business. COGS represents the cost assigned to goods sold during the period. Correct transaction records help ensure the cost moves to the appropriate account at the right time.
4. How does QuickBooks calculate inventory cost?
QuickBooks Online's built-in inventory tracking uses average-cost calculations for inventory valuation. Review the relevant Intuit documentation and reports for details. If you use another QuickBooks product or a separate inventory system, the method may differ.
5. Why does my QuickBooks inventory quantity not match my physical stock?
Common reasons include unrecorded purchases or sales, duplicate transactions, incorrect quantities, returns, timing differences, theft, damage, and errors in product setup. Compare transactions and physical counts before recording an adjustment.
6. Can I use QuickBooks for inventory if I sell through an online marketplace?
Possibly, but the right setup depends on your sales channels, integration, and inventory needs. Confirm which data synchronizes and reconcile marketplace sales, refunds, fees, fulfillment movements, and bank deposits.
7. What happens when I sell an inventory item?
In a correctly configured supported workflow, QuickBooks records the sale and updates the inventory and COGS records. The precise entries depend on the product setup and transaction type.
8. How often should I count inventory?
There is no single schedule suitable for every business. High-value, fast-moving, or shrinkage-prone items may need more frequent checks. Businesses should establish a documented count schedule and complete appropriate period-end counts.
9. Can inventory errors affect my taxes?
Yes. Inventory and COGS can affect reported business income and tax calculations. US federal tax rules include exceptions and method-specific requirements, so review IRS guidance and seek advice from a qualified tax professional for your circumstances.
10. Can IndiaBizExperts fix my QuickBooks inventory records?
IndiaBizExperts does not directly perform bookkeeping or accounting work. It facilitates requests to connect with independent professionals. You should confirm the professional's experience, scope of work, pricing, and responsibilities directly with them.
Conclusion
Reliable QuickBooks inventory tracking starts with accurate opening quantities, consistent product records, correctly recorded purchases and sales, and documented stock counts. When these controls are followed, inventory and COGS reports can provide a clearer view of stock levels, gross profit, and purchasing needs.
Do not rely on software settings alone to guarantee accuracy. Review unusual balances, investigate physical-stock differences, and seek qualified advice where inventory valuation or tax treatment is uncertain.
If you need help finding an independent professional to review your records, request a connection through IndiaBizExperts.
Disclaimer
This article is for general educational and informational purposes only. It is not accounting, tax, legal, or financial advice and does not replace advice tailored to your business. QuickBooks features, plan availability, interfaces, and integration behavior can change. Verify current product documentation and consult an appropriately qualified professional regarding your circumstances. IndiaBizExperts is a facilitation platform and is not affiliated with or endorsed by Intuit or QuickBooks.
Official References