Sales during a count: how to account for them

A market stall, a pharmacy by a bus stop, a mini-market in a residential courtyard: in places like these you cannot stop trading even for an hour. A count still takes hours, and receipts keep being printed throughout. So the book balances taken in the morning do not match the stock counted in the afternoon, and "shortages" appear that nobody caused. The answer is not to stop sales but to account for the time of every receipt.

Where the gap comes from

The booked balance and the goods on the shelf belong to two different moments. You took the books at the start of the count, say at 10:00; call that the cut-off. Each zone, though, was counted at its own time: one at 11:15, another at 13:30, a third at 15:45. Every unit sold in between is still in the books but no longer on the shelf, so the count comes out lower than the books. That is not a real shortage, just a difference in time.

The correction formula

There is one rule: add to the counted quantity whatever was sold between the cut-off and the moment the zone was counted, then compare the result with the books at the cut-off.

Balance at cut-off = counted quantity + quantity sold between the cut-off and the zone's counting time

For example, the cut-off is 10:00. Bottles of 1.5-litre water in zone B were counted at 13:30 and the count was 38. According to the receipts, 7 of them were sold between 10:00 and 13:30. So at 10:00 the shelf held 38 + 7 = 45. If the books show 45, there is no difference. If they show 47, the real shortage is 2 units. Without the correction you would see "−7" and "−9" in the two cases, and the real shortage would drown in the noise.

Record the time for every zone

For the formula to work, the counting time of each zone must be known. Write the start and finish times at the top of each zone sheet, and let the coordinator take the time from the till display rather than from their own watch. Phones, the till and the accounting program can differ by several minutes, and for a fast seller a few minutes means a few receipts. Before you start, ring up one test receipt and compare its time with the clock on the wall.

Sales inside the zone itself create a grey window that cannot be measured exactly. To narrow it, split the zone into parts and finish each part within 20 to 30 minutes: the shorter the window, the smaller the uncertainty.

Complicated cases

A receipt knows the item but not the zone. If the same item stands on the shelf and in the stockroom, the receipts cannot tell you where it was sold from. Count such items in both places one straight after the other, within 20 to 30 minutes, and take the finish time of the second zone as the time. Or ask the sales staff to write "shelf" or "stockroom" in a notebook, for those items only.

Receipts alone are not enough. A return accepted after the cut-off is subtracted from sales in the formula. An order from Telegram or Uzum may have been picked from the shelf before the count and rung up in the evening; for these, the time of picking matters, not the time of the receipt. Also check receipts that were rung up by hand during an internet outage: they should enter the accounting system with the time of the sale, not the time of entry.

The adjustment sheet

Keep the calculation on a single Excel sheet. Columns: item, zone, zone counting time, counted, sold up to that time, adjusted quantity, books at the cut-off, difference. Do not fill in the "sold" column by hand: export a receipts report from the accounting program for the period between the cut-off and the zone's time and total it by item code. Close the positions with a difference near zero and send the rest for a second count. The correction is then calculated once, and nobody asks later where a figure came from.

Conclusion

You can count without stopping trade if every zone and every receipt is tied to an exact time. Sales then stop being an obstacle and become ordinary arithmetic. The Pereuchet team records the time of each zone and reconciles the differences with your records in exactly this order.