Skip to content

Inventory and stock sheet

List your stock, see its value and get a Reorder flag when an item runs low.

Inventory and stock sheet template, first page

Fill it in and preview

Inventory and stock sheet

A spreadsheet to keep track of stock. List each item with its quantity, unit cost and reorder level, and the value of every line, the total value, the items to reorder and the items out of stock are worked out for you. Download it as Excel, OpenDocument, PDF or CSV.

Stock

Inventory and stock sheet

Count what you have, then enter the quantity. Value and the Reorder flag are worked out for every item.

Business or location Hillside Hardware, back store

Counted on 2027-03-31

SKU Item Quantity Unit cost Reorder level Stock value Status
HW-1001 Claw hammer 450 g 24 8.90 10 213.60 OK
HW-1002 Cordless drill 18 V 6 74.50 5 447.00 OK
HW-1010 Wood screws 4 x 40 mm, box of 200 58 3.20 20 185.60 OK
HW-1017 Paint roller set 4 6.75 8 27.00 Reorder
HW-1022 Work gloves, pair 0 2.40 15 0.00 Reorder
HW-1030 Spirit level 60 cm 12 11.30 6 135.60 OK
Total 6 104 1,008.80
Items to reorder 2
Items out of stock 1
Most valuable item Cordless drill 18 V

Open this spreadsheet in nerixA preview of the first rows with sample figures. Open it in nerix to fill in your own and change any cell.

Templates are a careful starting point, not legal advice. Where the law matters, check what applies where you are.

Operations and quality

What this template is for

An inventory spreadsheet to list stock with quantity and unit cost, see each item's value and the total, and flag what is below its reorder level.

It is free to fill in online, needs no account, and downloads as a Word document or a PDF. See all Operations and quality templates All free Excel and spreadsheet templates

Operations and quality

What you fill in

The form asks for 3 details. The document fills itself in as you type.

  • Business or location

    For example: Hillside Hardware, back store

  • Counted onoptional

    For example: 2027-03-31

  • Stock

    One row for each item. Reorder level: the quantity at or below which you buy more.

Operations and quality

What is inside

The parts of this document, in order.

  1. 1A spreadsheet to keep track of stock. List each item with its quantity, unit cost and reorder level, and the value of...

Templates

How it works

  1. 01

    Open

    Open the spreadsheet in nerix and fill in the short form. Your answers go straight into its cells.

  2. 02

    Change

    Every figure is a live formula. Change any cell and the totals, differences and charts work themselves out.

  3. 03

    Download

    Save it as an Excel file, an OpenDocument sheet, a PDF or CSV.

Make it yours with AI

Open it in the chat and ask for changes: shorter, firmer, another situation, another language.

Adapt it with nerix

Operations and quality

Questions people ask

What details does this template ask for?

The form asks for 3 details, starting with Business or location, Stock. 1 more are optional.

Can I download this template as Word or PDF?

Yes. Open it in nerix and the finished spreadsheet downloads as Excel, OpenDocument, PDF or CSV. It is free and the page only shows sample figures.

Is what I type sent anywhere?

No. What you type stays in your browser while you fill in the document. It only goes to nerix if you choose to open the template in the chat.

What should I check before I use this template?

The sheet shows what you count. Do a physical count on a set date, and value stock the way your accountant or local rules require.

Are these operations templates free?

Most are. Fill in and download them for free as Word or PDF, with no account. A few longer documents are premium: free to fill in, paid once to download, and marked with their price.

Do they meet a standard such as ISO 9001?

They are a practical starting point and certify nothing. Standards and safety laws differ by industry and country, so check what applies to you.

Who should approve a procedure?

The person who owns the process and a manager who can authorise it. The procedure template has fields for both, and for the review date.