The moment of buying and the moment of cost
When a shop buys 50,000 units of stock, cash leaves at once. But the business has not yet incurred a cost in the sense that matters for profit. It has exchanged cash for goods that it expects to sell. The cost is recognised when the goods are sold, at the amount they originally cost.
Missing this distinction leads to misleading monthly figures: a big buying month looks like a loss, and a month of selling from old stock looks like a windfall.
Cash view and profit view
Both views are useful and neither is wrong.
- Cash view: stock bought is money spent. It shows what left the account.
- Profit view: only the cost of the goods actually sold counts against the sales of the month.
Keeping both requires tracking what is on the shelf, at least roughly.
Cost of goods sold for one month
Opening stock at the start of the month was worth 30,000. Purchases during the month were 50,000. At month-end, a count shows stock on hand worth 42,000.
Cost of goods sold is the opening stock plus purchases minus closing stock: 30,000 + 50,000 - 42,000 = 38,000.
If sales for the month were 70,000, the gross profit is 32,000, even though 50,000 of cash went out for stock. The cash view says 20,000 was left after buying stock; the profit view says 32,000 was earned, with 12,000 of the extra stock still waiting to be sold.
Count the shelf at regular intervals
A full count every month is ideal for a small shop; for larger inventories, count the main lines and sample the rest. Value stock at what it cost, not at the selling price. A quick spreadsheet, a list in a notebook or a note per category is enough.
If counting every month is impractical, count at least every quarter and at year end. Between counts, the estimate of stock on hand should be based on purchases minus the cost of sales.
Where mistakes creep in
Common errors include forgetting items bought but not yet put on the shelf, counting damaged or unsellable goods at full cost, double-counting items in a back room, and leaving out goods held on behalf of a customer.
Recording purchases in the app
In SpendixAI, record each supplier payment under a stock or goods category on the day it is made, and add a note of what was bought. Keep a separate record of the monthly count and calculate the cost of goods sold as above. Comparing the stock category’s cash total with the cost of goods sold over several months reveals whether inventory is growing, shrinking or staying level. Growth in unsold stock is a cue to slow buying.
Stock bought on credit
When stock is bought on credit, the purchase creates both an asset, the goods on the shelf, and a liability, the amount owed. Neither has cost the business any profit yet. Only as the goods are sold does their cost reach the profit figure, and only as the supplier is paid does cash leave.
Keeping those two timelines in mind explains many surprising months: a busy month with falling cash may simply mean that suppliers were paid for earlier purchases, while profit reflects the current sales. Recording each side separately keeps them from being confused.
Stock held for others and stock in transit
Goods that belong to someone else, such as items held on consignment or kept aside for a customer’s later pickup, should not be counted as the shop’s own stock. Equally, goods paid for but still on the road belong in the count once ownership has passed, even though they cannot be sold yet. A short note at each count listing such exceptions keeps the closing figure honest.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

