How to Track Inventory Without Software

You can track inventory without software by keeping one count sheet with five columns (item, unit cost, reorder point, last count, this count), counting on the same day every week or month, and keeping the receipts for every stock purchase. That sheet answers the three questions inventory tracking exists for: what to reorder this week, how much money is sitting on the shelf, and what is disappearing without being sold. For a shop, maker, or salon retail shelf with fewer than about a hundred products sold in one place, paper or a single spreadsheet does that job fully. Software starts paying for itself when the same item sells in more than one place, when stock moves faster than you can count it, or when the count itself takes longer than the decisions it feeds.

That last sentence is the whole argument, and the rest of this post is the working detail: the sheet, the reorder point, the count routine, the shrinkage arithmetic, and a decision tree for when to stop doing it by hand.

One boundary first. This is about running the shelf, not about filing a return. How inventory is treated for tax purposes, and whether your business is required to keep one at all, depends on your situation. That's a question for a bookkeeper or an accountant, and the IRS covers the rules in Publication 334, the tax guide for small business. Everything below is arithmetic you can run yourself.

What does an inventory record need to tell you?

Start with the output, because most inventory systems fail by recording far more than anyone reads. A small business needs its stock record to answer three things:

What do I need to reorder this week? This is the question that costs you sales when you get it wrong. An empty peg or a missing shade of color means a customer walks out.
How much money is on the shelf right now? Stock is cash you've already spent. If you can't put a number on it, you can't tell whether a slow month was a bad month or just a month where your money turned into boxes.
What is leaving without being sold? Breakage, samples you gave away, product you used yourself, miscounts, and theft all look the same on a shelf: fewer items than you expected.

Anything that doesn't serve one of those three is optional. Supplier part numbers, bin locations, and product photos are useful in a warehouse with staff. On a single shelf that you stock yourself, they are extra writing you'll stop doing by March.

Which five columns make a working count sheet?

Here is the whole sheet. It works on a clipboard, in a notebook, or as one tab in a spreadsheet.

Item	Unit cost	Reorder at	Last count	This count
Lavender candle, 8 oz	$6.50	10	24	14
Cedar candle, 8 oz	$6.50	10	18	15
Wax melt, 6 pack	$2.10	20	40	22
Gift box, large	$1.80	15	30	12

Hypothetical example: a small candle maker's shelf, figures invented for illustration.

What each column does:

Item. One row per thing a customer can buy, or per material you run out of. If a product comes in three sizes, that's three rows, because you run out of them separately.
Unit cost. What you paid for one, from the supplier invoice or your own materials costing. This is the column that turns a count into money. The Etsy profit tracking walkthrough shows how to cost a handmade item if you make what you sell.
Reorder at. The count at which you place the next order. The next section covers how to pick it.
Last count and This count. Two columns, not a column per date. After each count, the "this count" figure moves over into "last count" and the right-hand column starts fresh. On paper, you start a new sheet and copy the numbers across. The old sheet goes in a folder, which becomes your history.

Two numbers fall out of this sheet with no extra columns:

Shelf value is this count multiplied by unit cost, added up down the page. For the four rows above: 14 × $6.50, plus 15 × $6.50, plus 22 × $2.10, plus 12 × $1.80, which comes to $256.30 of stock.
Reorder list is every row where this count is at or below the reorder number. Above, the gift boxes (12, reorder at 15) are the only line that needs an order today, even though the wax melts dropped the most.

What the sheet deliberately leaves out is a running tally of every sale. Most small shops can't keep that honestly by hand, and the count doesn't need it. The receipts you already keep for sales and for stock purchases supply the rest, which is what makes the shrinkage check below possible.

How do you set a reorder point without a formula?

Safety stock equations exist, but for a small shelf you need one question answered per item: how many do I sell while I wait for the next delivery?

Work it out in plain steps:

Delivery wait. How long from placing an order to having the stock on the shelf? Use the slow version, not the best case. If a supplier usually takes one week and sometimes two, call it two.
Sales in that wait. Look at your last few counts. If an item sells about five a week and the wait is two weeks, you sell about ten while waiting.
Cushion. Add a little for the items where running out actually hurts: your best seller, or anything a customer comes in specifically to buy. For items nobody misses for a week, add nothing.

Ten while waiting plus a small cushion puts that item's reorder point at 10 or 12. Write it in the column and stop thinking about it until something changes.

If even that feels like too much arithmetic, use two containers. Keep stock in two boxes, and when you open the second box, you reorder. The size of that second box is your reorder point, set by feel and corrected by experience. It's a long-standing retail habit because it takes no writing at all.

Revisit reorder points when a season turns, when a supplier changes, or when you run out of something twice. Running out once is bad luck. Running out twice means the number in the column is wrong.

How often should a small shop count stock?

Pick a fixed day and never move it. The value of a count comes from comparing it to the last one, and comparisons only mean something when the gap between them is regular. "Every Monday before opening" beats "whenever it looks low".

A reasonable rhythm for a small shelf:

Weekly for anything that sells fast or costs a lot per unit. These are the rows where a missed reorder or a missing item hurts.
Monthly for everything else. Slow sellers and cheap consumables don't change fast enough to justify a weekly look.
A full count at year end, every row, on the last business day or the first morning of the new year. If you keep an inventory for tax purposes, the Schedule C cost of goods sold section in Publication 334 starts from inventory at the beginning of the year and ends with inventory at the end of it. Those are counts, and your accountant will want them.

The IRS's own guidance on book inventories points the same way. Publication 538 on accounting periods and methods says a physical inventory has to be taken at reasonable intervals and the book figure adjusted to agree with it. In plain terms: whatever your records say, the shelf is the truth, and the count is how you check.

Time the count, too. If it takes twenty minutes, it will keep happening. If it takes two hours, it will quietly stop, and that is usually the first sign you've outgrown doing it by hand.

How do you spot shrinkage from a count?

Shrinkage is stock that left the shelf without being sold. Finding it takes one line of subtraction per item:

Last count + received since − this count = what left the shelf

Then compare that figure to what you actually sold. The gap is shrinkage.

Take the lavender candle from the sheet above (still a hypothetical example):

Step	Figure
Last count	24
Received since (from the supplier invoice)	+ 12
This count	− 14
Left the shelf	22
Sold, from your receipts or sales log	19
Unaccounted for	3

Three candles at $6.50 is $19.50 in a week. Before calling it theft, go through the ordinary explanations, because they're far more common: a candle you burned in the shop, two you gave away at a market as samples, a cracked jar you binned, or a sale you took in cash and never wrote down. Keep a "used or damaged" note on the back of the count sheet and most of the gap usually explains itself.

What you're looking for is a pattern. One unexplained item is a miscount. The same item short three weeks running is a signal worth acting on, whether that means moving it behind the counter, tightening how you log cash sales, or checking the delivery count when the box arrives.

The "received since" figure is where your purchase records earn their keep. The IRS describes what purchase records should show: the payee, the amount, proof of payment, the date, and a description of what was bought. A supplier invoice that lists quantities does both jobs at once: it supports the expense and tells you what arrived.

When does inventory software start paying for itself?

Not at a product count alone. The deciding factors are how many products you carry, how fast they move, and whether the same item sells in more than one place. Use this decision tree:

Does the same item sell in more than one place? (A shop counter and a website, two market stalls, a salon shelf and an online store.)
- Yes: use inventory software. A paper sheet can't stop you selling the last unit twice, and that oversold order costs more in refunds and apologies than a subscription does. This is the one branch where the answer is software regardless of size.
- No: go to step 2.
How many products (rows) do you carry?
- Under about 50: a paper count sheet works. Go to step 3 only if stock moves fast.
- About 50 to a few hundred: use one spreadsheet, because the multiplication and the reorder list are tedious by hand at this size. Go to step 3.
- Several hundred or more, or lots of variants per product: inventory software, because the count itself becomes the job.
How fast does stock move?
- You count weekly and nothing runs out between counts: stay where you are.
- Things run out between weekly counts, or you'd need to count daily to keep up: move up a level (paper to spreadsheet, spreadsheet to software).
- More than one person receives deliveries or pulls stock: a shared spreadsheet at minimum, since a paper sheet in one person's bag isn't a record for anyone else.

Two more honest tests. If your weekly count takes longer than the decisions it produces, you've outgrown the method. And if you've run out of your best seller twice in a quarter despite having a reorder point, the problem is speed, not discipline.

None of those thresholds are industry figures. They're where hand counting tends to break, and your own count time is the better measure. If you're already keeping your sales without software, the same logic applies: stay with the simplest format that answers your questions, and move when it stops answering them.

Where does the money side of stock go?

The count sheet tracks units. The money you spend on stock belongs in your expense records, and keeping the two separate is what makes both of them simple.

A straightforward way to do it: every time you buy stock, log it as one expense with a category like "Stock" or "Materials" and a note naming what arrived ("12 lavender, 12 cedar, supplier invoice 4471"). The expense categories post covers how to keep that list short. The note is what feeds the "received since" line in your shrinkage check.

To be plain about what SMBDashboard does here: it has no stock module, so the count sheet stays a sheet. What the Money module does is hold those purchase entries with a category and a note, and show the month's spending broken down by category, so the "Stock" line tells you what your shelf cost you this month without a separate tool. The free tier holds 200 money entries, and your data stays in your browser unless you turn on Pro sync. The small business expense tracker page explains how the Money module works.

FAQ

What is the easiest way to keep track of inventory?

A single count sheet with five columns: item, unit cost, reorder point, last count, and this count. Count on the same day every week or month, and reorder anything at or below its reorder point. For a small shelf, that's the complete system.

Can I track inventory in a spreadsheet?

Yes, and a spreadsheet is the natural step up from paper once you carry more than about 50 products. Use the same five columns, add a formula for shelf value (this count multiplied by unit cost), and highlight any row at or below its reorder point. Keep one tab for the current count and copy last month's to a new tab so you have history.

How often should a small business do a stock count?

Weekly for fast-moving or expensive items, monthly for everything else, and a full count at year end. The most important part is keeping the same day every time, because a count is only useful when compared to the one before it.

How many products before I need inventory software?

There isn't a single number. Hand counting usually strains somewhere past a few hundred products, but the stronger trigger is selling the same item in more than one place, where software keeps you from overselling. If you sell in one place and your count takes under half an hour, you probably don't need it yet.

Open the dashboard free and log this month's stock purchases as expenses. The count sheet tells you what's on the shelf, and the Money module tells you what it cost.