Which stock is tying up cash?
- Files
- 4
- Rows
- 94,154
- Checks passed
- 26
Stock value
$412,000
Not sold in 9 months
31.0%
SKUs below zero
214
What went in
Aug 1, 2025 – Jul 31, 2026
- Project
- Stock and sales: 12 months
- Subject
- Sales & stock
- Rows
- 94,154
Source files
- order_lines.csv86,412 rows
- stock_on_hand.xlsx1,284 rows
- purchase_orders.csv2,140 rows
- returns.csv4,318 rows
The finished example
Demonstration data we built, not a customer's file.
Rendered by the same components that render your own projects.
Your best-selling product loses $2.15 a unit, and it paid for the stock you cannot sell.
The linen shirt is the top seller by volume and reports a 59% gross margin. After discounts, marketplace and payment fees, free shipping and a 26% return rate, it contributes −$2.15 per unit ordered: $8,988 over the year. Meanwhile $128,000 of stock, 31% of the total value, has not sold in nine months, and eight of the products that do sell were out of stock for 4.7% of the year.
Where the linen shirt's margin goes
A 59% gross margin ends at −$8,988
- 01The best seller contributes −$2.15 per unit ordered.
- 02$128,000 of stock has not sold in nine months, and half of it was bought to hit a discount.
- 03Eight products that do sell were unavailable for 4.7% of the year.
Filed under
Closest to this one
Ranked by how many subjects they share with this project.
Cash flow & budgets · 1,210 rows
28 leases worth $85,700 a month all come up for renewal in a single quarter: two-fifths of the rent roll at once.
How concentrated is our lease-renewal risk?
Sales & stock · 19,329 rows
Product A produced 68% of total growth while repeat purchasing fell from 31% to 24%.
What is making this store's growth less durable?
Have something like this?
Drop it in and see what comes back. You only pay once you like it.
No account needed to start. You only pay when you like what you see.