Skip to content
Small Business Inventory cover: a sample sheet with units sold, revenue and gross profit and a column chart, beside the Dashboard, Products and Sales tabs

Small Business Inventory

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
5
Difficulty
Beginner
Updated
November 13, 2026

Every slide (5)

Overview

This template suits a small shop that makes or buys goods to sell online, at market stalls or to wholesale buyers. The Products tab holds the product list, one item per line, with unit cost, price, opening stock and reorder point. The Sales tab records each order by date, product and channel, and works out revenue and profit from the product's price and cost. On-hand stock and the reorder flag update after every sale.

Start by entering the opening stock for each product on the day you begin tracking. Add every sale to the Sales tab with the product picked from the list, so stock and profit stay accurate. Check the Products tab each week for rows marked Reorder. The Dashboard shows which channel brings in the most revenue, which helps you decide where to spend time on sales. Revenue uses the current price, so add a new row for a new price rather than changing an old one.

Useful for

  • Tracking stock for an online shop with a few products
  • Working out which market stall sells the most
  • Knowing when to reorder candles, soap or mugs

What's included

  • 4 tabs: Dashboard, Products, Sales, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Products: a table
  • Sales: a table
  • 2 charts that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Products tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

How is profit worked out on each sale?

Profit is the sale's revenue minus the unit cost of each item sold. The Sales tab looks up the cost and price from the Products tab, so enter the product name exactly as it appears there. Shipping, fees, packaging and tax are not included, so record those separately.

What happens to stock when I log a sale?

On-hand stock is the opening stock minus every quantity sold for that product. Log a return as a sale with a negative quantity so the stock goes back up. Recount the shelf now and then, because breakage and free samples will not appear in the log.

Does it handle several storage locations?

This version keeps one stock count per product. If you hold stock in two places, use one copy of the Products tab per location and add the two counts together, or ask a bookkeeper how to set up your stock records for your business.

  • #inventory
  • #small-business-inventory
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More inventory templates

See all 19

Also in Business operations

All business operations templates
Get this template

Preparing your template…