Why stock and daily profit should be reviewed together
A shop can have a busy sales day and still misunderstand its profit if purchases, returns, damaged goods, and expenses are recorded separately. Stock can also appear correct while the profit figure is wrong, or profit can look reasonable while physical stock is missing. A useful daily review therefore asks two connected questions: what quantity should still be in stock, and what did the recorded sales actually earn after product cost and recorded operating expenses? This worked example uses fictional products and prices to show the process. It is not a customer case study and the figures are not market prices. The same method can be adapted for grocery stores, clothing shops, mobile and electronics shops, pharmacies, wholesalers, and other owner-managed businesses. The objective is not professional period-end accounting; it is a practical operational check that helps an owner trace today's sales and estimated profit back to the transactions that created them. Editorial disclosure: this worked example is illustrative only and is not a customer endorsement. StockLedger has not collected a customer quotation for this scenario and none is pending publication. The example makes no percentage improvement claim about any real business and should not be read as typical or guaranteed results.
Start with opening stock and today's purchases
Example only: a Dhaka retail shop begins the day with two products. Product A has 10 units in stock at a recorded cost of ৳400 each. Product B has 20 units at ৳100 each. During the morning, the shop receives 10 more units of Product A at ৳500 each and 20 more units of Product B at ৳120 each. The first control is to record what was actually received before selling from the new delivery. If the supplier invoice says 10 units but only 9 physically arrived, recording 10 immediately creates a stock difference. Product, quantity, purchase cost, supplier reference, and receiving date should therefore agree with the real delivery. Opening quantities also need to be trustworthy. If the day starts from an incorrect opening balance, even perfectly recorded sales will produce an incorrect closing stock figure.
Calculate a usable cost when old and new stock are mixed
When old and newly purchased units of the same product are mixed, using only the latest purchase rate can give a misleading view of the stock cost. In this fictional example, Product A starts with 10 units at ৳400, worth ৳4,000, and receives another 10 units at ৳500, worth ৳5,000. The combined 20 units therefore have a total recorded cost of ৳9,000, or an average of ৳450 per unit. Product B starts with 20 units at ৳100, worth ৳2,000, and receives another 20 units at ৳120, worth ৳2,400. Its combined 40 units cost ৳4,400, or ৳110 per unit. The exact costing method used by a business should be consistent with its accounting setup. For this operational example, these average values give us a simple way to connect the day's unit sales with an estimated cost of the goods sold.
Record the sales before trying to calculate profit
During the day, the shop sells 8 units of Product A at ৳600 each and 15 units of Product B at ৳150 each. Gross recorded sales are therefore ৳4,800 for Product A and ৳2,250 for Product B, giving ৳7,050 before any return. Recording only the money collected is not enough. The invoice or sale record should also identify the product and quantity because those quantities explain the reduction in stock. Product A falls from 20 available units to 12 after the 8-unit sale. Product B initially falls from 40 to 25 after selling 15 units. Whether each customer paid in cash, digitally, or on due should also remain separate from the profit calculation. Payment method explains where the money or receivable went; the invoice quantities and product costs explain the inventory and gross margin.
Record customer returns and damaged stock as separate events
Later, one customer returns 1 unit of Product B from today's sale. The shop accepts the return, refunds or adjusts ৳150 according to its policy, and confirms that the returned item is suitable to sell again. Net Product B sales therefore become 14 units and ৳2,100 instead of 15 units and ৳2,250. The sellable quantity increases by one. During the same day, staff also find 2 units of Product B damaged and remove them from sellable stock. A customer return and damaged stock should not be combined into one adjustment: the return reverses part of a sale, while the damage explains why physically held stock is no longer available for normal sale. After the sale, accepted return, and damage, Product B's expected sellable closing quantity is 40 - 15 + 1 - 2 = 24 units. Keeping those events separate makes both stock investigation and profit review easier.
Worked BDT example: calculate the day's gross profit
Now connect the net sales with the recorded product cost. Product A has net sales of 8 units × ৳600 = ৳4,800. Using the illustrative average cost of ৳450, the estimated cost of those 8 units is ৳3,600. Product A therefore contributes an estimated gross profit of ৳1,200. Product B has net sales of 14 units × ৳150 = ৳2,100 after the customer return. At the illustrative cost of ৳110 per unit, the estimated cost of the 14 net sold units is ৳1,540. Product B therefore contributes ৳560. Total net sales are ৳6,900 and the estimated cost of net sold goods is ৳5,140. Estimated gross profit is therefore ৳1,760. This calculation is useful because it is linked to actual product movement rather than simply subtracting today's purchases from today's sales, which can be misleading when part of the purchased stock remains unsold.
Include damage and expenses, then check closing stock
Gross profit is not the final amount an owner should treat as the day's business result. In this fictional example, 2 damaged units of Product B have a recorded cost of ৳110 each, or ৳220 in total. The shop also records ৳400 for delivery and local transport and ৳500 for other shop operating expenses during the day, giving ৳900 of recorded daily expenses. For a simple operational estimate, start with the ৳1,760 gross profit, subtract the ৳220 recorded damage cost, then subtract the ৳900 recorded operating expenses. The resulting illustrative amount is ৳640. This is a simplified daily management figure, not a substitute for formal accounting profit, tax calculations, depreciation, accruals, finance costs, or professional period-end adjustments. The next step is a physical-stock check. Product A had 20 units available after receiving the morning purchase and sold 8, so the expected closing quantity is 12 units. At the illustrative average cost of ৳450, that represents ৳5,400 of recorded stock value for this example. Product B had 40 units available, sold 15, received 1 accepted sellable return, and lost 2 units to recorded damage, leaving 24 sellable units. At ৳110 each, that represents ৳2,640. The combined expected closing quantity is therefore 36 units across the two products, with an illustrative recorded cost of ৳8,040. If the physical count shows Product A at 11 instead of 12, the daily profit figure should not simply be edited to hide the difference. Investigate the missing unit by checking invoices, returns, damage, stock movements, late entries, and any authorized adjustment.
Why cash in the drawer will not necessarily equal profit
A common mistake is to compare the ৳640 illustrative operating result directly with the cash drawer. They measure different things. A customer may buy on due, creating sales and gross profit without putting cash in the drawer today. Another customer may pay an old due, adding cash without creating today's sale or profit. The owner may deposit cash into a bank account, pay a supplier, withdraw money, or receive digital payments through bKash, Nagad, card, or bank transfer. None of those movements changes the basic fact that stock, sales, customer dues, cash, and profit answer different questions. Daily cash closing should therefore reconcile the physical drawer separately, while the profit review should connect net sales with product cost, returns, damage, and expenses. When those reviews use the same underlying transactions, differences are easier to investigate.
Daily inventory and profit control checklist
Use the same short review every day. 1) Confirm opening stock or investigate any unresolved opening difference. 2) Record every supplier delivery using the quantity actually received. 3) Check that every completed sale has the correct product, quantity, price, and payment method. 4) Record customer returns against the appropriate sale instead of quietly adding stock back. 5) Record damaged or unusable goods separately from normal sales returns. 6) Make sure daily expenses are entered before reviewing profit. 7) Compare expected closing quantity with a physical count for high-value, fast-moving, or problem products. 8) Review net sales, estimated product cost, damage, and expenses instead of treating cash collected as profit. 9) Investigate negative stock, unexplained adjustments, unusual returns, or sudden margin changes. 10) Correct the real source transaction when possible rather than changing a final total merely to make the numbers agree.
Where StockLedger helps connect the daily review
This type of review becomes difficult when purchases are in one notebook, sales are in another system, damaged stock is remembered later, expenses are written on slips, and the owner calculates profit in a separate spreadsheet. StockLedger can keep products, purchase receiving, sales, returns, damaged stock, expenses, inventory records, and reporting inside a connected business workflow. The practical advantage is traceability: when a quantity or daily result looks unusual, the owner has a better chance of following the total back to the transactions that created it. Software still depends on correct opening data, accurate purchase receiving, complete sales, timely returns and damage entries, and disciplined expense recording. A useful evaluation is to reproduce a simple day like the worked example above with your own products, then compare the expected stock quantities and daily figures with the software records before relying on it for a larger operation.
