To track what diapers, wipes and formula cost you, record only your own purchases: the date, the item, the quantity in the pack and the price you paid. Divide the price by the quantity to get a cost per unit, then divide a month's total by the weeks in it to get a weekly figure. A size jump or brand switch then shows up as a visible step in your numbers instead of a vague feeling that things are costing more.
What should each purchase line contain?
Four fields are enough: date, item, quantity (the count in the pack, or the weight of the formula tin), and the total price. Add a fifth, 'size or stage', because the size is what usually changes your costs. Where a purchase mixes items, such as a single order with diapers and wipes, split it into two lines in the amounts the invoice shows.
| Date | Item | Size or stage | Quantity | Price paid |
|---|---|---|---|---|
| 3 Mar | Diapers | Size 2 | 72 pieces | ₹1,150 |
| 9 Mar | Wipes | All | 240 sheets | ₹480 |
| 20 Mar | Diapers | Size 2 | 72 pieces | ₹1,150 |
The numbers are only an example. Your pack counts and prices will differ, and the point is to work them out yourself rather than rely on anyone's average.
How do you work out cost per diaper?
Cost per unit = price paid / quantity. For the first row, 1,150 / 72 = ₹15.97 per diaper. In a spreadsheet, if the quantity is a number in column D and the price is in column E, the formula is =E2/D2. Keep the quantity column as a pure number and write 'pieces' in the header, so the formula does not break.
To get a weekly cost, add up a month's purchases and divide by the number of weeks you are covering. Two diaper packs at ₹1,150 each, plus ₹480 of wipes, is 2,300 + 480 = ₹2,780 for the month. Divided over four weeks, that is 2,780 / 4 = ₹695 a week. If the packs were used over 30 days, the exact weekly figure is 2,780 / (30 / 7) = about ₹649.
How do you see the effect of a size jump or brand change?
Size changes matter because bigger diapers often come in packs with fewer pieces, so the price per piece goes up even if the pack price looks the same. Suppose the next size comes in 64 pieces for ₹1,150. The cost per diaper is 1,150 / 64 = ₹17.97, compared with ₹15.97 earlier, so you pay ₹2.00 more per diaper. If you use 6 diapers a day, that is 6 x 2 = ₹12 a day more, or about ₹360 for a 30-day month.
Put a 'size or stage' note next to the month, then compare the cost per unit before and after. Treat a brand switch the same way: log the new item as a separate line and compare, instead of mixing both brands in one total.
Formula, feeding and what to leave out
If you buy formula, record the tin size in grams and the price, and work out the cost per 100 grams: 100 x price / grams. A 400 g tin at ₹700 works out to 100 x 700 / 400 = ₹175 per 100 g. The paediatrician decides which formula and how much; your record only helps you see what the choice costs you over a month.
Leave out gifts, and leave out samples you were given at the clinic. Counting only what you bought keeps the total honest.
Where a sheet stops being enough
A sheet works well while you buy from a few places. When purchases are spread across marketplace orders, UPI payments to a local chemist and card swipes, it gets tedious to copy them over. SpendixAI can take the bank and card statements you upload, sort lines into a Diapers and hygiene category using your own rules, and show a monthly total in reports, with the quantity details staying in your own notes.
Monthly review checklist
- List every diaper, wipes and formula purchase for the month.
- Work out cost per unit for each, and compare with last month.
- Note any size jump, brand change or stock-up.
- Total the month and divide by weeks.
- Decide whether to stock up next month or buy as you go.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


