Missing a template? Request it →
Inventory & Stock Tracker, the Dashboard tab
№ · Spreadsheets · Business

Stock counted from every movement, not guessed.

Log stock in, sales and count adjustments, and on hand stays right. A reorder list says how many to buy and from whom, and a dashboard shows stock value, best sellers and slow movers.

Google Sheets · Excel .xlsx · Blank + filled example

Language

Instant download. Permanent link in your account.

Open it live, read‑only

Instant download. Permanent link in your account. Yours forever, no subscription.

The honest split

You log what moves. It counts the shelf.

Everything on the right is a formula you never have to touch, in Google Sheets and in Excel alike.

You type

  1. Each item, once
  2. Stock in, sales and count adjustments
  3. Your suppliers and their lead times

It works out

  • On hand, for every item
  • The reorder list with quantities and cost
  • Stock value at cost and at retail
  • Best sellers and slow movers
Every tab, as it arrives

Open any tab. These are the real ones.

Tap a tab, then the picture to read every figure full size.

Dashboard

The Dashboard tab.

The dashboard: stock value at cost and retail, what to reorder, best sellers and slow movers.

Open the filled example, read-only
The difference, on one screen

A plain spreadsheet, and this one.

On the left, the plain stock list most people keep. On the right, the Dashboard tab. Drag the line.

A plain spreadsheet The tracker
Both apps, one price

Google Sheets or Excel. You do not have to choose.

The download carries both: the Sheets copy link and the native .xlsx. Every formula is chosen to work identically in the two, and we test the round trip on every build.

Google Sheets
Blank and filled-example copies, one click into your Drive.
Excel .xlsx
Native files, not exports. Blank and filled example included.
Day one

Your first five minutes.

  1. 1

    Buy it once.

    $39, no subscription. Your order email and your account both carry the download, permanently.

  2. 2

    Copy it into your Drive.

    One click and it is yours, in your own Google account, forever. We keep no access to your copy and nothing in it phones home.

  3. 3

    Start in the example.

    The filled copy shows every tab already working. Poke it, break it, then open your blank and type your own.

№ · Log the movement, the count follows

An inventory spreadsheet that works stock out from every delivery and sale

The Inventory & Stock Tracker is for a small shop, maker or wholesaler who keeps stock on shelves and needs to know what to reorder before it runs out. Add your suppliers with their lead times, then your items: a unique SKU, name, category, location, supplier, cost, price, the stock you hold today and a reorder point.

Never type a quantity again

From then on, every movement is one row on the Stock Log: In for a delivery, Out for a sale, Adjust after a count, minus for a loss. On hand is opening stock plus in, minus out, plus adjustments, so a sale logged twice shows up as a wrong count rather than a silent one. Put a price on an Out line and the Dashboard counts what you sold as well as how many.

What to order this week

Reorder lists every item at or under its reorder point with a suggested quantity, the supplier, their lead time and the cost. What If goes further: at your sales pace, the day each item runs out against its supplier’s lead time, so you see what would sell out before an order placed today arrives. The Dashboard keeps stock value at cost and at retail, best sellers over 30 days and slow movers after 60.

Selling one-off items across marketplaces instead? The Reseller Inventory & Profit Tracker follows each item to its profit.

The download is a short PDF with two Google Sheets buttons, one for a blank copy in your own Drive and one for a copy filled with an example, the same workbook as blank and example Excel files, and a one-page Quick Start for each.

Before you ask

The questions we actually get

How is the stock on hand worked out?

Opening stock plus every In, minus every Out, plus adjustments, all from the Stock Log. You never type an on-hand figure.

How does it know when to reorder?

Each item has a reorder point. At or under it, the item appears on Reorder with a suggested quantity, its supplier, lead time and the cost.

What if a count does not match?

Log an Adjust line for the difference, minus for a loss. The item's history stays intact.

Can I track stock in more than one place?

Each item carries a location, Shelf A, Back room or your own names, and the Dashboard shows stock by location and by category.

Does it work in Excel?

Yes. The download carries native .xlsx files, one blank and one filled with an example, for Excel 2010 and later, Excel for Mac and Microsoft 365. Every formula is ordinary Excel, with no macros to enable.

Inventory & Stock Tracker

The shelf, counted for you.

Stock, reorders and value, in Google Sheets and Excel, no subscription, no year baked in.

Get the tracker · $39

Still deciding? Open it live, read‑only. Not the sheet you need? See every spreadsheet template or ask at Templacity Hall.

№ · Reviews

Be the first to say something.

Nobody has written about this one yet. If it is on your device, yours is the first thing the next person reads.

Read by a person before it goes up, usually within a day. Your email stays with us and never appears on the page.

Instant download.

Your file is in your account the moment you check out, yours to re-download any time. A receipt lands in your inbox, too.

One-time purchase.

No subscription, no annual renewal, no upgrade nags. Pay once and the file is yours.

Quiet, secure checkout.

Stripe. Apple Pay. No spam, no “partners,” no reselling your details. Receipt, file, done.