Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesOperations & Supply ChainInventory & Stock ManagementStock Movement Ledger

SpreadsheetInventory & Stock ManagementFree

Stock Movement Ledger

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

Shown with sample data

Colour

Stock Movement Ledger

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

Stock value
$8,664
Items to reorder
1
Stock value by item
  • Control board 24V$6,536
  • Shipping carton L$2,013
  • Abrasive disc$115.20

How to use it

  1. 1Enter opening quantities on the Items sheet.
  2. 2Log each receipt, issue or adjustment as it happens.
  3. 3Check On hand before promising stock.
  4. 4Investigate any item where the count and the record differ.

In this workbook

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

About this template

A perpetual stock record without a system. Each line is a movement in or out with a reference; a second sheet nets them against opening stock to give the quantity on hand and value for every item, and flags anything at or below its minimum.

Who it’s for

  • Stores that issue stock to jobs or departments
  • Reconciling counts to records
  • Showing an auditor how a balance was reached

What’s included

  • Movements sheet: One row per movement.
  • Items sheet: Quantity on hand for each item, calculated from the movements.

How to use it

  1. 1Enter opening quantities on the Items sheet.
  2. 2Log each receipt, issue or adjustment as it happens.
  3. 3Check On hand before promising stock.
  4. 4Investigate any item where the count and the record differ.
Related searchesstock ledgerstock in outinventory transactionsstock cardgoods movement

Details

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

Download a copy

Downloads need a free account.

SpreadsheetInventory & Stock ManagementFree

Stock Movement Ledger

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

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
Beginner
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
Inventory Valuation & Turnover Report2 sheets

Stock value

$27,060

Overall turnover

4.7

Slow or dead value

$14,060

Stock value by category
$17k
$5,790
$2,800
$1,430
Finished goodsComponentsPackagingSpares
SpreadsheetInventory & Stock Management

Inventory Valuation & Turnover Report

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

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