The year-end warehouse: closing stock the auditor believes

Every December the same project starts in the same warehouse. Someone books the count, someone else chases the open receipts, and on the second of January a spreadsheet arrives that tries to explain why the stock figure, the count and the purchase ledger each say something different. By March the auditor has asked a question nobody can answer from memory, and the answer is reconstructed from delivery notes in a box.

None of that is accounting. How stock is valued at the balance date is a matter for your accountant and auditor, and nothing here is advice about it. But the figures they value come from the warehouse, and the questions they ask about those figures are operational. There are three, and they are always the same.

The three questions

What was physically there? A count, taken at or reconciled to the balance date, that someone can show was done properly: who counted, where, when, and what happened to the differences.

Which of it was yours? Not everything on your shelves belongs to you, and not everything you own is on your shelves. A figure that mixes the two is wrong in both directions at once.

Which side of midnight did each movement fall? A pallet received on 31 December whose invoice arrives in January, or a delivery invoiced in December that left the dock on the second. Each sits in one year on one ledger and the other year on the other. That is what cut-off means, and it is where most year-end trouble actually lives.

The first question gets all the attention, because the count is the visible event. The other two decide whether the count is believed.

The count is the easy part

We wrote about counting separately, in stocktakes without stopping the warehouse: count by location, count blind, put every correction through the ledger as a movement with a reason. The year-end point is narrower. A count is evidence only when the ledger it is compared with is complete up to the moment of the count. If goods were put away but not booked, or picked but not confirmed, the count disagrees with the system for reasons that have nothing to do with loss, and the adjustment you post bakes a timing error into the opening balance for next year.

So before any count, the open documents matter more than the counters. Every receipt either put away and booked, or deliberately left open with the goods standing in a marked receiving area. Every pick either confirmed or released. Every transfer between your own sites either received at the other end or visibly in transit. A count over a floor with half-finished documents measures the paperwork, not the stock.

Cut-off: draw the line, then write it down

Cut-off is not complicated, but it is unforgiving, because it is about exact moments and the warehouse does not stop for them. The habits that make it believable are small:

• Name the moment. Last goods-in and last goods-out of the year, at a stated time, agreed in advance. Anything that arrives after it waits in a marked area and is booked in the new year.
• Record the last document numbers. The last goods receipt, the last dispatch, the last transfer of the year. With those numbers written down, the question “was this in December or January?” has a one-line answer instead of an archaeology project.
• Look at the yard. A loaded trailer standing outside at midnight is a cut-off question on wheels. Was it dispatched, or is it still stock? Decide, document it, photograph it.
• Know what is between sites. Goods moving between two of your own warehouses at midnight are in neither building and still yours. If transfers are recorded as a dispatch at one end and a receipt at the other, the list of open transfers is the list of goods in transit. If they are not, those goods simply vanish from both counts.

Whether goods on a customer’s or supplier’s truck are already yours depends on the delivery terms, and that is a question for the people who wrote the contract. The warehouse’s job is to have the documents that show where the goods physically were and which papers moved with them.

Goods that are not yours

This is the question a mixed warehouse gets wrong most often. A carrier or logistics company that stores goods for customers may hold more pallets on behalf of others than of its own. Some businesses hold consignment stock that stays the supplier’s until it is used. And most companies own stock that is not in their building: at a third-party warehouse, out on hire, in a service van, on consignment at a customer.

Two rules keep this honest. Goods held for others are counted, because you are accountable for them, but they are listed against their owner and never in your own stock figure. And goods you own away from your premises are listed by location, with something from the holder that confirms them.

Both rules are easy in December only if they were true all year. If customer goods came in on a proper goods receipt and live on their own ledger, the custody list is a report. If they came in on a phone call and sit on the same shelves under the same article numbers, separating them at year-end is guesswork, and it is guesswork in front of an auditor. We covered the receipt side in storing customer goods.

Returns, damage and the quarantine corner

Every warehouse has a corner where things wait: returns not yet inspected, damaged goods waiting for a claim decision, stock on hold for a quality question. They are physically present, often yours, and quite possibly not worth what the system says. How to value them is not a warehouse decision. Making them visible is. Goods with a known condition, an owner and a status can be valued by someone who knows how. Goods in an unlabelled corner get discovered in February.

A calendar that does not end in a December project

• October and November: agree the count date and scope with your accountant and auditor. Ask whether the year’s cycle counts can support the year-end figure, and what evidence they would want. That is their call, and it is cheaper to ask now than in January.
• Early December: clear the open documents. Old receipts, unconfirmed picks, transfers nobody received. Each one is a variance you would otherwise find at the count.
• The last day: name the cut-off moment, record the last document numbers, walk the yard, mark the waiting area, print the custody list.
• January: reconcile the count to the ledger, explain every difference above your threshold, and file the evidence where it can be found when the question comes in March.

The pattern underneath is the same as with counting. A warehouse whose ledger is right all year closes the year by running reports. A warehouse whose ledger is right once a year closes it by reconstruction, and reconstruction is the part nobody believes.

In navichain, stock is a ledger rather than a number: on-hand per article and per warehouse with every movement on an audit trail, so the last movement before midnight is a lookup rather than a memory. Pallets and locations have addresses, counts can be scoped to a warehouse, a zone or a list of articles and run blind, and a count corrects the pallets and the ledger in the same step. Customer goods in custody come in on a sealed, barcoded goods receipt note and stay on their own ledger, so the custody list is a report. The warehouse page shows the rest, and pricing shows what it costs.