Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesOperations & Supply ChainInventory & Stock ManagementInventory Valuation & Turnover Report

SpreadsheetInventory & Stock ManagementFree

Inventory Valuation & Turnover Report

Value stock by category and see turnover and days on hand so slow movers stand out.

Shown with sample data

Colour

Inventory Valuation & Turnover Report

Value stock by category and see turnover and days on hand so slow movers stand out.

Stock value
$27,060
Overall turnover
4.7
Times a year
Slow or dead value
$14,060
Stock value by category
  • Finished goods$17,040
  • Components$5,790
  • Packaging$2,800
  • Spares$1,430
Share of stock value by category
  • Finished goods$17,04063%
  • Components$5,79021%
  • Packaging$2,80010%
  • Spares$1,4305%

How to use it

  1. 1Enter quantity on hand and unit cost from your count.
  2. 2Enter each item’s cost of goods sold for the last 12 months.
  3. 3Sort by Days on hand to find the slowest stock.
  4. 4Agree an action for every item flagged Slow or Dead.

In this workbook

  • About
  • What’s included
  • How to use
  • Related resources

About this template

Month-end stock reporting in one sheet. Enter quantity, unit cost and the cost of goods sold over the last twelve months for each item; the sheet gives stock value, turnover, days of stock on hand and a flag for slow and dead stock.

Who it’s for

  • Month-end and year-end stock reporting
  • Finding cash locked in slow stock
  • Supporting a write-down decision

What’s included

  • Valuation sheet: One row per item at the valuation date.
  • Summary by Category sheet: Stock value and COGS last 12 months and the number of entries for each category, calculated from the Valuation sheet.

How to use it

  1. 1Enter quantity on hand and unit cost from your count.
  2. 2Enter each item’s cost of goods sold for the last 12 months.
  3. 3Sort by Days on hand to find the slowest stock.
  4. 4Agree an action for every item flagged Slow or Dead.
Related searchesinventory valuationinventory turnoverdays on handslow moving stockstock report

Details

Format
Spreadsheet
Category
Inventory & Stock Management
Sheets
2
Setup
10 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetInventory & Stock ManagementFree

Inventory Valuation & Turnover Report

Value stock by category and see turnover and days on hand so slow movers stand out.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Inventory & Stock Management
Sheets
2
Setup
10 min
Level
Intermediate
Price
Free

Your copy is private to you.

More inventory & stock management templates

View all
Inventory Tracker with Reorder Alerts4 sheets

Stock value

$894

Items to reorder

4

Out of stock

1

ABCD
1ItemCategorySupplierUnit cost
2Espresso beans 1kgBeveragesRoast Co.$18.50
3Oat milk 1LBeveragesDairyFree Ltd$2.10
4Loose leaf tea 500gBeveragesLeaf & Co$11.80
5Croissants, frozen (case of 50)FoodBake Supply$32.00
Items
SpreadsheetInventory & Stock Management

Inventory Tracker with Reorder Alerts

Stock on hand from a movements log, with reorder points from real usage, lead time and safety stock, days of cover and a ready-made reorder list.

10 min setupPreview
ABC Inventory Analysis2 sheets

Items

10

Annual usage value

$102,618

A items

3

ABCD
1ItemCategoryAnnual unitsUnit cost
2Control board 24VElectrical420$86.00
3Servo motorElectrical150$210.00
4Power supply 150WElectrical260$48.00
5M8 bolt set (100)Fasteners900$6.50
ABC analysis
SpreadsheetInventory & Stock Management

ABC Inventory Analysis

Rank every item by annual usage value and class it A, B or C so you know where control matters most.

10 min setupPreview
Stock Movement Ledger2 sheets

Stock value

$8,664

Items to reorder

1

ABCD
1DateTypeQty inQty out
2Nov 2Receipt2,0000
3Nov 3Issue0350
4Nov 3Issue024
5Nov 4Receipt600
Movements
SpreadsheetInventory & Stock Management

Stock Movement Ledger

Log every receipt, issue and adjustment and see the running quantity on hand for each item.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ