QuickBooks Dead Stock Analysis

Why QuickBooks doesn't flag dead stock on its own

QuickBooks reports tell you what happened — quantities, costs, sales by item — but they don't rank your catalog by risk or tell you which SKUs are quietly tying up the most cash. Spotting dead or slow-moving inventory means combining several of those numbers per product: how long it's been since the last sale, how much is still on hand, what it cost, and how it's trending. Doing that by hand across more than a handful of SKUs gets impractical fast, which is why it's usually a distinct step from day-to-day bookkeeping rather than something QuickBooks surfaces automatically.

Important: there's no native QuickBooks integration

To be direct about this up front: Inventory Assassin does not currently connect to QuickBooks directly, and it isn't affiliated with or endorsed by Intuit. What it does is analyze a CSV file — which you can export from QuickBooks Online, QuickBooks Desktop, or any other system that lets you get your inventory data into a spreadsheet. If a direct integration matters to you, this isn't that. If you're comfortable exporting a CSV, the rest of this page walks through how that works.

What to export from QuickBooks

Export your inventory data into a CSV file containing the available product, quantity, cost, sales, and date fields. QuickBooks Online and Desktop both support exporting inventory and sales reports to Excel or CSV — the exact menu path varies by QuickBooks version and plan, so check your own account's export options rather than following generic instructions that may not match what you see.

The more of the following your export includes, the more complete the analysis:

• Product name or description, and SKU or item number
• Quantity on hand
• Unit cost
• Retail or selling price
• Category, if you track one
• Recent units sold, ideally with a date range
• Last sale date, or received/stocked date for items that haven't sold

How the CSV import handles QuickBooks column names

QuickBooks exports don't use the exact same column headers every business happens to expect, and that's fine — Inventory Assassin's importer maps common column-name variations to the fields it needs, rather than requiring an exact match. A few examples:

Matches that could go either way — where a wrong guess would matter financially — are flagged for you to confirm before anything is analyzed, rather than silently assumed. Analysis quality depends on the fields supplied: quantity, cost, and price are the minimum, and sales history plus dates make the risk classification meaningfully more accurate.

What the analysis actually produces

Once your QuickBooks export is uploaded, Inventory Assassin classifies every SKU as Healthy, Watch, Slow, or Dead, using inventory age, days since last sale, sales velocity, sell-through, gross margin, and cash tied up together — not any single number in isolation. Products at risk are ranked by Threat Level, a combined read on inventory risk and cash exposure, so the SKUs actually worth acting on first rise to the top instead of getting buried in a full inventory list. Each priority item gets a specific recommended action — a markdown, bundle, wholesale, or hold — with the reasoning and economics behind it shown, not just a label.

Tracking it over time

A one-time QuickBooks export gives you a single snapshot. Exporting again after you've acted — a markdown applied, a bundle launched — and re-running the analysis lets Inventory Assassin compare the two snapshots and show what actually moved, closing the loop between a recommendation and its result instead of leaving that as a separate manual check.