# How to Calculate Stock Turns in Unleashed, With the Formula and a Worked Example

> Unleashed's stock turn formula is cost of goods sold for the past year divided by average inventory cost. Here is where to find each number.

- URL: https://logistify.ai/guides/unleashed/calculate-stock-turns/
- Section: Unleashed Guides, Setup & reports
- Applies to: Unleashed Lite, Core, Pro
- Steps checked against: Unleashed Help Centre articles, checked 23 October 2026
- Updated: 2026-10-23

**Short answer:** To calculate stock turns in Unleashed, divide a product's cost of goods sold for the past year by its average inventory cost. Cost of goods sold is the year's Sales Shipments value less Credits, from the Transaction Enquiry. Average inventory cost is the average of last year's and today's on-hand quantity times Average Landed Cost, from the Stock On Hand Enquiry. On Core and Pro, the Reorder Report also has a Stock Turns column.

## Before you start

- Unleashed's formula is Stock Turn = Current Cost Of Goods Sold / Average Inventory Cost. It works per product.
- Current Cost Of Goods Sold is the sum of all Sales less the sum of all Credits during the past year up to today.
- Average Inventory Cost is ((last year's on-hand quantity x last year's Average Landed Cost) + (today's on-hand quantity x today's Average Landed Cost)) / 2.
- The Stock On Hand Enquiry shows Qty On Hand and Avg Cost as they were at the end of any date you pick, so you can look up both years in one report.
- The Transaction Enquiry only includes completed transactions. Never Diminishing Products don't appear in it, so they have no stock turn.
- The Reorder Report, which has a ready-made Stock Turns column, is not available on Lite. On Lite, use the manual steps below.

Stock turns depend on Average Landed Cost, so wrong costs give a wrong answer. See [How to work with average landed cost in Unleashed](https://logistify.ai/guides/unleashed/average-landed-cost/) first if your costs look off.

## Step 1: Find the product's cost of goods sold for the past year

1. Go to Reports > Inventory > Transaction Enquiry.
2. Enter the product in Product Code, and set the dates to cover the past year up to today, the period Unleashed's formula uses.
3. Set Transaction Type to Sales Shipment and click Run. Note the Total Value in the footer. It shows as a negative number; use the positive figure.
4. Change Transaction Type to Credit and click Run again. Note that Total Value.
5. Subtract the Credit total from the Sales Shipment total. This is the product's Current Cost Of Goods Sold.
6. Alternatively, use the Cost column in Reports > Sales > Margin Enquiry for the last 365 days. This only works if every dispatched Sales Order from that period has been completed, because the Margin Enquiry only lists completed orders.

## Step 2: Find last year's quantity and Average Landed Cost

1. Go to Reports > Inventory > Stock On Hand Enquiry.
2. Enter the product in Product Code and set Date To to today's date last year.
3. Click Run.
4. Note Qty On Hand (last year's on-hand quantity) and Avg Cost (last year's Average Landed Cost). If the product had no stock then, both are 0.

## Step 3: Find today's quantity and Average Landed Cost

1. In the same Stock On Hand Enquiry, set Date To to today and click Run.
2. Note Qty On Hand and Avg Cost again. You can also check today's Average Landed Cost on the Cost tab of the product record.

## Step 4: Do the calculation

1. Multiply last year's Qty On Hand by last year's Avg Cost.
2. Multiply today's Qty On Hand by today's Avg Cost.
3. Add the two results and divide by 2. This is the Average Inventory Cost.
4. Divide the Current Cost Of Goods Sold from Step 1 by the Average Inventory Cost. The result is the product's stock turn for the year.

| Figure | Where it comes from | Unleashed's example (JAM JAR) |
| --- | --- | --- |
| Last year's on-hand quantity x Average Landed Cost | Stock On Hand Enquiry, Date To a year ago | 0 x 0 (no stock last year) |
| Today's on-hand quantity x Average Landed Cost | Stock On Hand Enquiry, Date To today | 1.9167 x 53.8399 |
| Average Inventory Cost | Sum of the two lines, divided by 2 | 51.5975 |
| Sales Shipments, past year | Transaction Enquiry Total Value (use the positive figure) | 376.88 |
| Credits, past year | Transaction Enquiry Total Value | 53.84 |
| Current Cost Of Goods Sold | Sales Shipments less Credits | 323.0 |
| Stock Turn | Cost of goods sold / Average Inventory Cost | 6.26 |

*Worked example from Unleashed's Calculating Stock Turns article, checked 23 October 2026.*

## Step 5: Check it against the Reorder Report (Core and Pro)

1. Go to Reports > Purchases > Reorder Report.
2. Click Show Toolbar, then Hidden Columns, and drag Stock Turns into the grid.
3. Set the warehouse filter to Global. The Stock Turns column is only shown for Global.
4. Click Run and compare the figure with your own calculation.

Unleashed's Reorder Report article describes the Stock Turns column as the average number of days it takes to use up a product's stock. Its Calculating Stock Turns article, though, matches the column to the ratio (6.3 for JAM JAR). If the column is unclear for a product, work it out by hand with Steps 1 to 4. For using the rest of the report, see [How to use the Reorder Report to replenish stock](https://logistify.ai/guides/unleashed/reorder-report/).

## If something doesn't look right

- The Sales Shipment total is negative: that's expected. Use the positive figure.
- The Margin Enquiry cost is lower than the Transaction Enquiry: some dispatched Sales Orders aren't completed yet, so the Margin Enquiry leaves them out.
- The Stock Turns column is missing or blank: the warehouse filter isn't Global, or your plan is Lite.
- The product was new this year: last year's quantity and cost are 0, which halves the average and makes the stock turn look high.
- Avg Cost is 0: stock may not have been receipted correctly or wasn't on hand. Fix the cost before relying on the result.

## Where Unleashed leaves the work to you

- The manual method works one product at a time. For many products, you export the enquiries to CSV or XLSX and do the arithmetic in a spreadsheet.
- The formula uses two points in time, a year ago and today. A product that was stocked up or run down in between can give a misleading figure.
- Unleashed gives you the number. Deciding which products turn too slowly, and what to do about them, is your call.
- The result is only as good as your receipted costs, landed costs and completed orders.

## Where Logistify fits

Logistify doesn't calculate stock turns or build reports in Unleashed. It works earlier in the chain: the [Sales Order Service](https://logistify.ai/agents/sales-order/) enters customer orders that arrive by email, PDF, Excel, EDI and other channels into Unleashed as sales orders, so sales aren't waiting in an inbox to be keyed. Its order demand check also flags lines well above a customer's usual quantity before they become a sales order.

## Frequently Asked Questions

### What formula does Unleashed use for stock turns?

Stock Turn = Current Cost Of Goods Sold / Average Inventory Cost. Cost of goods sold is the past year's Sales less Credits. Average Inventory Cost is the average of last year's and today's on-hand value at Average Landed Cost.

### Is the Reorder Report's Stock Turns column on every plan?

No. Unleashed says the Reorder Report isn't available on Lite. Lite users can work stock turns out by hand from the Stock On Hand Enquiry and Transaction Enquiry.

### Can I use the Margin Enquiry instead of the Transaction Enquiry?

Yes, its Cost column gives cost of goods sold, but only for completed Sales Orders. Complete every dispatched Sales Order from the past 365 days first.

### Why does a new product show a very high stock turn?

With no stock a year ago, last year's value is 0. That halves the Average Inventory Cost and pushes the stock turn up.

## Sources

- [Unleashed: Calculating Stock Turns](https://help-unleashed.theaccessgroup.com/en/articles/12396471-calculating-stock-turns)
- [Unleashed: Reorder Report](https://help-unleashed.theaccessgroup.com/en/articles/11582307-reorder-report)
- [Unleashed: Stock On Hand Enquiry](https://help-unleashed.theaccessgroup.com/en/articles/11582309-stock-on-hand-enquiry)
- [Unleashed: Transaction Enquiry](https://help-unleashed.theaccessgroup.com/en/articles/11582312-transaction-enquiry)
- [Unleashed: Margin Enquiry](https://help-unleashed.theaccessgroup.com/en/articles/11582318-margin-enquiry)
- [Unleashed: Calculate sales margins](https://help-unleashed.theaccessgroup.com/en/articles/11582106-calculate-sales-margins)