To track purchases for resale month by month, record what you bought, what you sold and the value of what is left, then work out the cost of goods sold. The result tells you your margin for the month, which cash in and cash out cannot.
What should I record?
- Each purchase: date, supplier, items, amount and whether it was paid or is owed.
- Inventory at the start of the month, valued at cost.
- Inventory at the end of the month, counted and valued at cost.
- Sales for the month.
- Returns to suppliers and customer returns.
How often do the purchases arrive?
Fast-moving goods are bought weekly, seasonal goods in bursts before festivals such as Diwali or Raksha Bandhan, and slow lines occasionally. A month with a big pre-festival purchase will show low cash but high inventory. That is why you need the inventory figure alongside the cash figure.
How do I work out cost of goods sold and margin?
Hypothetical month: opening inventory ₹80,000, purchases ₹55,000, closing inventory ₹70,000 and sales ₹84,500.
| Line | Amount |
|---|---|
| Opening inventory | ₹80,000 |
| Add: purchases | ₹55,000 |
| Less: closing inventory | ₹70,000 |
| Cost of goods sold | ₹65,000 |
| Sales | ₹84,500 |
| Gross margin | ₹19,500 |
Check: 80,000 + 55,000 - 70,000 = ₹65,000. Margin: 84,500 - 65,000 = ₹19,500. As a share of sales, 19,500 / 84,500 is about 23 percent. If next month's share is 18 percent, something moved: purchase prices, discounts you gave, goods that went missing or items that sold at a lower price. Rent, wages and other running costs are separate and come out of this margin.
How do I handle supplier credit?
Many traders pay suppliers after the goods are sold. Keep a simple payables list: invoice date, supplier, amount, due date and amount paid. Suppose you owe ₹20,000 at month end. Your cash position looks healthy, but the real position is ₹20,000 lower. Show the figure at the foot of your monthly summary so you do not spend what is already owed.
What do I do about shrinkage and own use?
Count what is on the shelf against what the sales and purchase records say should be there. If the shelf holds ₹2,000 less than expected, that is shrinkage: breakage, theft, mistakes in billing or goods taken home. Record it as a line of its own. Taking items for the household should be recorded the same day as an own-use entry; otherwise it vanishes into the margin and your numbers drift.
How do I spot slow-moving goods?
Compare closing inventory with the cost of goods sold. In the example, inventory of ₹70,000 against monthly cost of goods sold of ₹65,000 means roughly a month of goods on the shelf. If the same ratio showed three months of goods, money would be tied up in things that do not move. Review the items that have not sold for sixty days and decide whether to mark them down.
In SpendixAI you can import the bank statement that carries your supplier payments, add the cash ones by hand, and use a report grouped by category and month to see the purchase totals; the inventory count stays in your own record.
How do festival months change the numbers?
Expect inventory to rise before the festival and fall after it. Compare festival months with last year's same period, not with the month before. If you bought ₹1,20,000 of goods ahead of the season and sold only ₹70,000 worth at cost, you are carrying ₹50,000 into the next quarter; decide early whether to discount it rather than discovering it in March.
A short month-end checklist
- Count inventory and write its value at cost.
- Total purchases and sales for the month.
- Work out cost of goods sold and margin.
- Update the payables list.
- Mark items that have not sold for sixty days.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


