How QuickBooks Online reports inventory turnover.
A short reference for the finance team reconciling the number on this calculator with the number QuickBooks Online returns. Report name, the menu path, the costing assumptions, and the one caveat that bites most often.
What this page is, and what it is not
This is not a buy/don’t-buy review of QuickBooks Online, and it is not a pricing comparison. Inventory turnover is a formula, not a software market: any general ledger that posts COGS and tracks inventory value can produce the ratio. This page exists for the moment a CFO runs our calculator on the trial balance, runs the QuickBooks Online report, and gets two different numbers. Below is why.
Where the turnover report lives
QuickBooks Online’s report is called Inventory Valuation Summary plus Profit & Loss. The path is Reports > Sales and customers > Inventory Valuation Summary; Reports > Business overview > Profit & Loss.
What the report counts as COGS
Cost of Goods Sold line from the P&L, period-bounded.
What the report counts as inventory
QuickBooks Online uses the ending inventory basis by default. Our calculator defaults to average inventory (beginning plus ending, divided by two). If you want the two numbers to agree, set both to the same basis before reconciling. See average vs ending inventory for the trade-off.
How QuickBooks Online annualises
Manual. QBO does not publish an inventory turnover line; pull COGS, pull beginning and ending inventory asset balance, average them, and divide.
The one caveat that bites
Average Cost is the only valuation method in QBO; LIFO and specific-identification businesses must reconcile in a side workbook before the turnover number is defensible.
Reconciling the QuickBooks Online number with this calculator
- In QuickBooks Online, run Inventory Valuation Summary plus Profit & Loss for the same window you used in our calculator (calendar year, fiscal year, or trailing twelve months).
- Set inventory basis to match: our calculator uses average by default; QuickBooks Online uses ending. Either change ours via the toggle, or pull the second balance point from QuickBooks Online and average it yourself.
- Confirm the COGS number matches your P&L. If QuickBooks Online is upstream of your GL (for example Cin7 or Fishbowl feeding QuickBooks), wait for the sync to clear before comparing.
- Apply the caveat above. For mixed-method costing or multi-entity roll-ups, the single-number turnover is rarely defensible without a per-segment breakdown.
Pricing context (for completeness, not the point)
QuickBooks Online publishes list pricing. Solopreneur $20/mo. Inventory requires Plus at $115/mo. See the vendor page for current tiers. Recent change: 2026 pricing reset: Solopreneur replaced Self-Employed; Simple Start $38, Essentials $75, Plus $115, Advanced $275.
Related
- Our methodology - what this calculator does, and the auditor-preferred defaults.
- Average vs ending inventory - the basis choice that determines whether your number and QuickBooks Online’s number agree.
- Vendor compare pages - head-to-heads framed around the turnover-reporting workflow.