Stock counts: 3 moves to keep books close to shelves

Key takeaways

• Count incoming goods and record their cost when they arrive.
• Separate returned units from allowances on goods you keep.
• Remove sold units and their cost from inventory.
• Recount a difference before adjusting the books.

Why the shelf and the books drift apart

A stock book is built from a chain of small entries. Something arrives. Something is sold. Something goes back to the supplier. Each entry has to land in the right place, at the right time, with the right quantity and value. When one is missed, delayed, or entered twice, the book starts to drift from the shelf, and the gap grows quietly until somebody counts.

Most of the time nobody notices the drift because nobody looks. The book looks fine on screen. The shelf looks fine when you walk past it. The problem only shows up when a full count puts both numbers side by side, and by then the cause may be weeks old and hard to trace.

Food cost is a good place to see why this matters. Square's guide to food cost percentage says that calculating and closely monitoring that figure is vital, and that it could be a matter of staying in business or closing your doors ( Square). You don't have to run a restaurant to feel the same pressure. If the book says you have stock you do not have, your cost figures look better than they are. You may under-order, run out of a product your customers expect, or buy later than you should. If the book says you are short when you are not, you may order twice. Either way, the count is telling you something about money, not just about boxes.

This post covers three stock moves that do most of the work. The first is recording deliveries. The second is recording returns and allowances. The third is taking cost out of inventory when you sell. If these three happen at the time they should, with the right values, then the count at the end of the month becomes a check rather than a rescue. You will still need to investigate any gap.

Those three moves are about the book. The count is about the shelf. A good count tells you where the two disagree, and a good set of moves makes sure the disagreement stays small. Read on for what each move looks like in practice, and what to do when a count still comes up short.

Move 1: Book every delivery when it arrives

The first move is the receiving entry. When goods come in from a supplier, the book needs to show them at once, with the quantity you actually received and the cost you agreed to pay. Waiting makes the book wrong for as long as you wait, and any count run inside that window will show a gap that is not a real loss.

Consider a simple case from an accounting textbook. OpenStax's merchandising chapter describes a candle company that received a shipment from a manufacturer that had 150 candles that cost $150. The point for us is the first step. The shipment is stock the company now holds, and it belongs in the books when it arrives, not when someone gets around to it.

In a real stockroom, that translates into a few habits.

• Count at the door. Count what the carrier actually left, and write that number on the receiving record before the driver leaves. Counting later, from a pallet that has already been broken down, is where errors creep in.
• Record the cost on the same line. Take the unit cost from the supplier invoice, not from last quarter's price list or your memory of what the item cost before.
• Note shortages and damage at receiving. If a few units are broken, don't let them go onto the shelf count as if they arrived whole. Record what arrived, what is damaged, and what is missing, so the damaged units can be handled as their own issue.
• Keep unpaid deliveries on the books. Payment and stock are separate things. A shipment you have not paid for is still stock you hold. If your receiving log only shows what accounts payable has processed, the book will be short every time a delivery is waiting for an invoice.
• Check the delivery against the purchase order. A mismatch between what you ordered, what was delivered, and what you recorded is much easier to fix on the day than at the next count.

A common mistake is treating the receiving record as paperwork instead of a stock movement. Once the delivery is in the system, the shelf and the book should agree on that day. If they don't, the cause is usually one of two things. The count at the door was rushed, or the delivery was entered from memory later in the day.

Move 2: Book returns and allowances as their own entries

The second move is returns and allowances. These are where drift tends to hide, because goods that leave the building don't always leave the books the same way, and goods that come back can get counted as if they were sold.

The same textbook example is useful here because it separates two different outcomes for one shipment. Assume the candle company has not yet paid for the candles, and that 100 of them are badly damaged and must be returned. The other 50 candles are marketable, but they are not the right style. The company returned the 100 defective candles for a full refund, and it asked for and received an allowance of $20 for the 50 improper candles it kept ( OpenStax, Compare and contrast merchandising).

Two things happened to two groups of the same shipment. The damaged candles went back. The wrong-style candles stayed, and the company got some money back for them. If your book treats both the same way, your unit count will be wrong, your cost will be wrong, or both.

The textbook keeps these apart for a reason. It describes net sales as gross sales less sales discounts, sales returns, and sales allowances ( same chapter). Those are different things, and the accounting shows them separately. Your stock records should do the same.

For the stockroom, the rules of thumb are these:

• A return removes units from your count. Reverse the receiving entry for the units sent back, at the cost you recorded when they came in. Log the quantity, the reason, and the date.
• An allowance does not remove units. It changes the cost of units you keep. Don't subtract them from your count just because you got money back. If the allowance is posted as a unit reduction, the book will say you have fewer items than you really do.
• Keep one line for each. Mixing returns and allowances into a single generic adjustment makes it impossible to explain a gap later. When someone asks why the count is off by a case, you want to be able to point to a line that says "returned, damaged" or "kept, allowance."
• Check the back room after each return. A returned case that is still sitting on a shelf in the back is a count error waiting to be found. Confirm the return left the building before you close the entry.
• Don't let a return sit in limbo. Items waiting to go back to a supplier are not on the sales floor, but they are not gone either. Decide where they live in your books, and count them there.

The last point causes the most trouble. A stockroom usually has a corner where returns wait for pickup. If those units aren't recorded as on hold or returned, the shelf count will look short and the book will look long, or the reverse, depending on when someone checked.

Move 3: Take the cost out of inventory at the moment of sale

The third move is the sale. Every time you sell an item, two things need to happen. The sale is recorded, and the cost of the item leaves your inventory. Many stock books get the first part right and miss the second. They show the money coming in, but the stock value stays on the books as if the item is still there.

Here is how the textbook shows it. A shoe store sells 150 pairs of athletic cleats to a local baseball league for $1,500, and those cleats cost $900 ( OpenStax, Compare and contrast merchandising). The store has to recognize two things with the sale: the $900 cost of the shoes sold, and the $900 reduction in merchandise inventory. Both entries come from one sale. If the second one is missing, the stock value on the books is too high, and the store looks more profitable on paper than it is.

In day-to-day work, the sale move looks like this:

• Relieve stock on every sale. That includes discounted sales, bundles, and sales made by hand or on a second register. A discount changes the price the customer pays. It does not change the item leaving your shelf.
• Use the cost you paid for that unit. Use the cost recorded at receiving for the units being sold. Don't use what the item costs to buy today unless your books are set up to work that way on purpose.
• Reconcile the register to the stock system. If the point-of-sale and the stock records run separately, compare them on a regular schedule, daily if you can manage it. Find the disagreement while it is still small and the sales are still fresh in memory.
• Watch for sales of items the system doesn't know. A sale of an item that was never received into the system shows up as a negative count or an unknown product. Treat every one of those as a question to answer, not a number to tidy up.
• Handle samples and staff use the same way. Units taken for samples, tastings, or staff use leave the shelf too. If they don't get recorded, they become a gap at the next count with no name attached.

The sale move is where most of the day-to-day drift comes from, simply because sales happen all the time. A single missed relief might be small. A week of them can be the whole reason the count is off. For the accounting connection, see cost of goods sold.

Illustrative example: follow the three stock moves

Suppose a delivery contains 100 units costing $100 in total. Record 100 units and $100 of inventory. Return 50 units for a $50 refund: the book now holds 50 units costing $50. These figures illustrate the flow; check the actual entries against the shelf count.

What to do when the count still disagrees

Even with good habits, counts will disagree. When they do, resist the urge to adjust the book first. Adjusting first makes the gap disappear on paper and takes the evidence away with it. Work through the cause in order.

1. Recount the item. Ideally, have a second person count it without seeing the book number. A recount that agrees with the first is far more useful than a count that is guessed to match.
2. Check the deliveries since the last count. Did a delivery come in that never reached the book? Were the units counted at the door? Was any shortage recorded?
3. Check the returns and allowances. Did a return leave the building? Did an allowance get posted as a unit reduction by mistake? Are units waiting to go back still sitting on the books?
4. Check the sales. Was every sale relieved from stock, including the ones rung up on a second register or entered late? Are there negative counts or unknown items?
5. Check the physical location. Units get moved to the back room, the display, the sample table, or the trash without being recorded. Walk the area where the gap is most likely.
6. Adjust with a reason. Once you have found the cause, or ruled out the likely causes, post the adjustment with a reason that says what happened. "Count correction" is not a reason.

Keep a short log of count adjustments. Over a few cycles, the log will show which move gives you the most trouble. If most of your gaps come from deliveries, fix the receiving step first. If most come from sales, look at how the register and the stock system talk to each other. Use the inventory adjustment checks before updating stock records.

Give each move an owner

A move that belongs to everyone usually gets done by no one. Name one person for each of the three moves. The person who signs for deliveries owns the receiving entry, including the count at the door. Whoever runs the back room or the returns area owns the return entries, and checks that units have actually left before the entry is closed. Whoever manages the register or the sales system owns the relief of stock on each sale, and the reconciliation between the two.

Owners don't need to do everything themselves. They need to know what "done" looks like for their move. For receiving, that means a signed record with counted quantities and costs. For returns, it means a logged reason and a confirmed departure. For sales, it means every sale relieved, with no unexplained negative counts.

Set a regular review. A short weekly check of each owner's log catches small problems while they are still easy to explain. Pair it with a count schedule the manager sets, so that the full count is never a surprise and the team knows when it is coming. Keep the review short. Ten minutes of checking the logs beats a full afternoon reconstructing a month.

Make the count a check, not a rescue

The textbook picture of inventory is tidy. When it explains the perpetual inventory system, it considers one environment in which physical counts and book records align, and it works from there ( OpenStax, perpetual inventory system). Your stockroom will rarely look that neat at the first count. But that picture is the goal to aim for.

Each count you run is information. Over time, the count becomes a quick check that confirms the books, rather than a long hunt through paperwork after the fact.

Today, pick one item with a count difference. Recount it, check its delivery, return and sales entries, and record the reason before adjusting the book. Follow the physical inventory reconciliation steps if you need a count routine.

Questions about stock counts

Does an allowance reduce the stock count?

An allowance changes the cost of goods you keep without removing units. Check that it has not been entered as a quantity reduction.

Should you adjust the book as soon as a count differs?

Recount and investigate the difference before adjusting the book. Check deliveries, returns, sales and physical locations, then record the adjustment with a reason.