Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesRetail & E-commerceStore OperationsShrinkage & Stock Loss Log

SpreadsheetStore OperationsFree

Shrinkage & Stock Loss Log

Record every loss by cause, value it at cost and see where theft, damage and waste are costing you most.

Shown with sample data

Colour

Shrinkage & Stock Loss Log

Record every loss by cause, value it at cost and see where theft, damage and waste are costing you most.

Loss at cost
$321.20
Shrinkage rate
0.7%
Change 48000 to your sales for the period
Incidents
8
Lost to shoplifting
$128
Loss value by loss type
  • Shoplifting$128
  • Expired / spoiled$48.20
  • Admin or pricing error$41.60
  • Supplier short delivery$38.40
  • Unknown$38
  • Damage$27
Share of loss value by loss type
  • Shoplifting$12840%
  • Expired / spoiled$48.2015%
  • Admin or pricing error$41.6013%
  • Supplier short delivery$38.4012%
  • Unknown$3812%
  • Damage$278%

How to use it

  1. 1Log losses as they are found, not at stocktake.
  2. 2Choose the most likely cause honestly.
  3. 3Record the action: claim, markdown, disposal or police report.
  4. 4Review causes monthly and fix the top one.

In this workbook

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

About this template

Shrinkage hides in the gap between the stock system and the shelf. Log each known loss with the product, quantity, cause and what was done; the sheet values it at cost, totals losses by cause and expresses shrink as a percentage of sales so you can target the biggest leak.

Who it’s for

  • Weekly write-offs and damages
  • Loss prevention reviews
  • Insurance and supplier claims

What’s included

  • Losses sheet: One row per loss found.
  • Summary by Loss type sheet: Loss value and Quantity and the number of entries for each loss type, calculated from the Losses sheet.

How to use it

  1. 1Log losses as they are found, not at stocktake.
  2. 2Choose the most likely cause honestly.
  3. 3Record the action: claim, markdown, disposal or police report.
  4. 4Review causes monthly and fix the top one.
Related searchesshrinkage logstock loss trackerretail shrink reportinventory write off logdamage and theft log

Details

Format
Spreadsheet
Category
Store Operations
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetStore OperationsFree

Shrinkage & Stock Loss Log

Record every loss by cause, value it at cost and see where theft, damage and waste are costing you most.

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
Store Operations
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Your copy is private to you.

More store operations templates

View all
Retail Sales Tracker2 sheets

Net sales

$20,210

Avg transaction

$48

Conversion

24%

Net sales by day
SpreadsheetStore Operations

Retail Sales Tracker

Daily sales by channel with transactions, average basket and target progress.

10 min setupPreview
Retail Store KPI Scorecard2 sheets

Sales

$308,840

Conversion rate

14%

Average transaction value

$33

Sales by store
$148k
$130k
$31k
Riverside MallHigh StreetStation Kiosk
SpreadsheetStore Operations

Retail Store KPI Scorecard

Weekly footfall, transactions, units and sales by store, turned into conversion, basket value and units per sale.

10 min setupPreview
Store Staff Rota2 sheets

Total hours

150

Labour cost

$2,622

Labour % of sales

18%

ABCD
1StaffRoleContracted hrsMon
2HannahManager408
3OmarSupervisor320
4PriyaSales associate246
5TomSales associate160
Rota
SpreadsheetStore Operations

Store Staff Rota

Next week's hours by person and day, with contract and overtime checks, staff on and labour cost each day, minimum cover alerts and labour as a share of forecast sales.

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