Template · Stock and products · Opening soon

Days inventory outstanding and stock turnover, by product

Work out every product's inventory turnover and days on hand from your stock levels and sales, month by month, so slow stock shows up before it ties up more cash.

Book a demo

You bring

Stock levels260 rows

ProductStock dateOn hand

Sales1,330 rows

Sold productSale dateUnits sold

Mammoth does the work

You get

One table60 rows

Each product's turnover and days of stock on hand, month by month.

ProductMonthAverage on handUnits soldTurnoverDays on hand

Not a spreadsheet to fill inIt is a ready-made workflow in Mammoth. You bring the files, and it does the work.
Your files, as they areUpload a file or connect a source. Your column names do not have to match.
Runs again by itselfWhen new data arrives, every step runs again and the result updates.

What you get back

The real result of this template, run on sample data.

Inventory turnover and days on hand: the resultSample data60 rows

Product	Month	Average on hand	Units sold	Turnover	Days on hand
SKU-1001	2026-04-01	281	249	0.89	33.90
SKU-1002	2026-04-01	189	178	0.94	31.90
SKU-1003	2026-04-01	135.50	114	0.84	35.70
SKU-1004	2026-04-01	86.50	84	0.97	30.90
SKU-1005	2026-04-01	60.80	49	0.81	37.20
SKU-1006	2026-04-01	47.50	31	0.65	46
SKU-1007	2026-04-01	38	17	0.45	67.10
SKU-1008	2026-04-01	31.50	4	0.13	236.30

60 rows in the result · made from Sales (1,330 rows) and Stock levels (260 rows) · first 8 shown. Sample data: illustrative figures, not business results.

How is days inventory outstanding calculated?

Days inventory outstanding (DIO) is average inventory divided by what was sold in the period, times the days in the period. Inventory turnover is the other way up: sold divided by average inventory. A high DIO means stock sits for longer.

How it works

How to use the inventory turnover and days on hand template

1Bring your dataConnect a source, or upload a file.
2Check the columnsMammoth matches each column the template needs and asks only when it is unsure.
3Choose where it goesA table, a sheet, or a dashboard. It rebuilds on every refresh.

See the exact columns and steps ›

What it needs

Stock levels over time and your sales, by product (2 tables)

Stock levels

Product
Stock date
On handUnits, or stock value at cost: the same measure as sales.

Sales

Sold product
Sale date
Units sold

The steps it runs

1Match columns: Stock levels
2Match columns: Sales
3Units sold by product and month
4Average stock by product and month
5Bring in each month's sales
6Turnover and days on hand

Every step is an ordinary Mammoth step you can open and change.

Inventory turnover and days on hand: questions

Units or value?

Either, as long as both tables use the same one. Units per product is what Shopify and most stock systems export; stock at cost and cost of sales gives the accounting DIO.

What is the inventory turnover ratio formula?

Cost of goods sold (or units sold) divided by average inventory for the same period. The template shows it for every product and month.

Does it update by itself?

Yes. The template becomes an ordinary workflow in Mammoth. When your data refreshes, from a connector, a scheduled pull or a new file, every step runs again and the result table updates.

Can I change the steps?

Every step is an ordinary Mammoth step you can open and edit. Mammoth remembers which steps came from the template, so an update never overwrites your changes.

Do my column names have to match?

No. You point the template at your columns once. Mammoth suggests a match for each one and asks only when it is unsure.