Market Reality

Lost Sales Due to Stockout: Why Your Invoices Cannot Show Them

Ronak Maloo26 August 2026

You measure sales lost because of stockouts by reconstructing demand that never became an invoice: a sales order that sat unbilled because stock was zero, or a notebook mark when a retailer asked and walked. Lost sales due to stockout leave no trace on the invoice register, because that register only records what you billed, and a stockout is a sale that was never billed. Tally's sales vouchers are complete on what went out; they are silent on who asked and found the shelf empty. A Guwahati FMCG owner at 11:15 on Tuesday hears that Fancy Bazaar Chemist wanted 40 bottles of 200 ml shampoo, saw two cases gone, and lifted from the next distributor. Item-wise sales for Tuesday will not show those 40. If a sales order had been punched before the counter check, the order would still sit as not-yet-invoiced demand against a zero Stock Summary.

Key Highlights

An invoice register records billed sales, so a stockout that turned a retailer away never appears as a line, a rupee, or a missing quantity
A sales order recorded before the invoice is the only Tally document that can still show demand after stock hit zero
Without that order, lost sales due to stockout are a mark in the same notebook as lead time: who asked, what item, how many, what time

How do I measure sales lost because of stockouts?

You measure sales lost because of stockouts by looking for demand that did not become a bill. There are two places that demand can still exist. A sales order in Tally that never became an invoice, because quantity on hand was not there to dispatch. Or a line you wrote when the retailer asked, you said no, and he left.

If neither exists, you cannot measure it. You can guess. Guessing is how "we probably lost some shampoo" stays a feeling through year-end.

The invoice list for Tuesday will show every bottle that went out. It will not show the 40 that Fancy Bazaar wanted. Those 40 never became a voucher. Asking the sales register "what did we lose" is asking a list of successes to name a failure it was never told about.

This is why recording sales orders in Tally is the demand half of stockout control for distributors. Stock on hand is what you have. A sales order is what you have already promised. An invoice is what you managed to bill. Lost sales live in the gap between the second and the third, and only if the second was written down.

Why invoices cannot show lost sales due to stockout

A sales invoice is a document of what left. Quantity, rate, party, date. Tally totals those into item-wise sales and party-wise sales. Both reports are true. Both are incomplete for stockouts.

The chemist who asked at 11 AM and found the shelf empty generated no invoice. He may generate an invoice at the next distributor. Your books will look like a quiet SKU, not like a lost counter.

Item-wise sales will even punish you twice. The 200 ml that usually does 40 a day did 0 after 11 AM because there was nothing to sell. The average daily sales you take into next week's reorder point will dip. The formula will think demand fell. Demand did not fall. Supply did.

Party-wise sales will not show Fancy Bazaar buying shampoo that day. It may show Fancy Bazaar buying oil, which he did, and the relationship will look fine on a rupee total. The SKU he stopped asking you for will not have a column called "asked and refused."

Credit notes and returns are the opposite problem: goods that went out and came back. They are visible. A stockout is goods that never went out. Visibility is the invoice's job. Absence is not a voucher type.

The principle is one sentence. Your invoices cannot show lost sales due to stockout because lost sales were never invoiced. Measurement has to start from a document that exists before the bill, or from a mark you make at the moment of the refusal.

The sales-order reconstruction

A sales order punched on the phone lands in Tally as a Sales Order. That is the same once-only capture as salesman order taking without re-entry. For lost sales it has a second job: it is a demand stamp that survives a zero stock position.

Tuesday 11:05. Salesman at Fancy Bazaar punches 40 bottles of 200 ml against the chemist. Sales order on mobile writes that order into Tally. Stock Summary on the 200 ml is already 0. The order sits. It does not become an invoice that afternoon.

Wednesday morning you can still see it. Pending Orders, a paid add-on available on request, is the list of orders not yet invoiced. A sales order against a SKU whose Stock Summary is zero is the closest Tally gets to a lost sale you can count: 40 bottles, ₹180 a bottle, ₹7,200, one party, one timestamp.

That count is still incomplete. It only includes retailers whose order was recorded. The chemist who said "chhodo" and walked, with no punch, is still invisible. The reconstruction is only as wide as the habit of recording the ask.

Do not treat Pending Orders as a fulfilment tracker. It shows what is not yet invoiced. It does not walk the order from punch to pick to truck to delivery. The lost-sales use is narrower: demand that was written, against stock that was not there.

If the salesman never punches until he has confirmed stock, you will have no order when stock is zero. That habit is good for over-promising. It is bad for measurement. For this reconstruction, the ask has to be written even when the answer is no, or the no disappears.

The notebook when nobody ordered

Most refusals are verbal. "200 ml hai?" "Khatam." "Theek hai." The chemist leaves. No sales order, because nobody thought a no needed a voucher.

The reconstruction then is a mark. Same notebook as lead time. Four fields are enough: time, party, item, quantity asked. Tuesday 11:15, Fancy Bazaar Chemist, 200 ml, 40 bottles. Optional fifth: what he did next, if you know. "Lifted from the next van" is the expensive version. "Said he will try Thursday" is a maybe.

At ₹180 a bottle, that line is ₹7,200. Ten such lines in a month on one SKU is ₹72,000 you can put next to the reorder point and the 8-day Kolkata lead time. The notebook does not become a second sales register. It becomes evidence that the 200 ml's quiet item-wise sales were a stockout, not a demand drop.

You will not catch every walk-out. The salesman who is already on the scooter will not always write. The counter boy who said no at 6 PM may forget. The point of the mark is not a census. It is a refusal to let the invoice register be the only story.

A WhatsApp from the chemist, "200 ml bhej do," that you could not fulfil is also a mark. Save the message date against the party. That is still not an invoice. It is still demand.

What the live reports will and will not show

Item-wise sales shows what moved. On a stockout day it understates demand. Use it for the average when the item was in stock, not for the day it was dry.

Stock Summary shows quantity on hand, as of a date. Zero on Tuesday at noon is the empty shelf. The lost quantity is the 40 the chemist asked for. Past-date quantity is exact; the rupee column at a past date is at current rate.

Godown-wise stock tells you which location was empty. Company total of 80 bottles with Guwahati at zero is a location problem, and the chemist at Fancy Bazaar only cares about Guwahati. Lost sales due to stockout can be local even when the company is not dry.

Velocity ranks how fast items move. A high-velocity SKU at zero is the expensive empty. A low-velocity SKU at zero may be a SKU you are willing to miss. Velocity will not name the chemist who walked.

None of these reports adds a "lost sales" column. The measurement is the order that did not bill, plus the notebook. The owner still holds the second half.

A Tuesday in Fancy Bazaar, in bottles and rupees

11:00. Chemist asks for 40 bottles of 200 ml. Salesman checks Stock Summary on the phone: 0 in Guwahati, 80 in Tinsukia. Company is not dry. This counter is.

11:05. If the salesman punches a sales order for 40, Tally now holds demand. Dispatch can argue a transfer, or the owner can say no. Either way the 40 exists as an order.

11:15. If nobody punches, the chemist buys 40 from the next van at ₹180, ₹7,200 that will never hit your invoice. Item-wise sales for the 200 ml on Tuesday stays at whatever moved before 11. Party-wise sales for Fancy Bazaar looks normal because he still took oil.

7 PM. Owner reads Velocity. The 200 ml still ranks as a mover because yesterday was 40. Today's zero after noon has not yet ruined the 30-day average. The purchase still needs to go out. The lost ₹7,200 is a notebook line, or a pending order, or nothing.

Thursday. If the 40 sat as a sales order and stock arrived, it can still become an invoice. If the chemist already filled from the other van, the order should be closed in the books rather than shipped into a refusal. That closing is a person deciding, not a report deciding.

Year-end. The invoice register will not total the Tuesdays like this. If you want a figure for lost sales due to stockout, you add the unbilled orders on dry SKUs and the notebook marks you actually made. That sum is a reconstruction. It is honest about what it cannot see.

Frequently Asked Questions

Q: How do I measure sales lost because of stockouts?

A: Look for demand that never became an invoice. Count sales orders that sat unbilled because stock was zero, and add notebook marks for asks that were never punched. The invoice register cannot name those sales, because they were never billed.

Q: Why do invoices miss lost sales due to stockout?

A: An invoice records what left the godown. A stockout is a sale that did not leave. Item-wise and party-wise sales total the invoices. They have no line for a retailer who asked, found the shelf empty, and walked.

Q: Can Tally show lost sales if I record sales orders?

A: A sales order that never became an invoice, against a SKU whose stock was zero, is demand you can still see. Pending Orders, a paid add-on available on request, lists orders not yet invoiced. That is a reconstruction, not a full census of every walk-out.

Q: What if the salesman only punches when stock is available?

A: Then a zero-stock ask never becomes an order, and you are back to invoices plus memory. For measurement, the ask has to be written even when the answer is no. Otherwise the no disappears from the books.

Q: Should I lower next month's forecast when item-wise sales dip after a stockout?

A: No. A dip caused by zero stock is a supply hole, not a demand hole. Use average daily sales from days the item was in stock, and keep the notebook or unbilled orders as the lost-sales evidence.

Q: Is there a report that totals lost sales for me?

A: Tally will total invoices and, if you record them, sales orders. The owner still has to pick the unbilled orders on dry items and any marks in the notebook. That addition is the measurement.

Takkada is a Tally-integrated receivables and auto-reconciliation app for Indian distributors, with 0% MDR UPI collection and WhatsApp dispatch. Book a free demo.