Build a sheet with one row per family member, a cap for each, the items they actually need, the items they merely want, and a column for what was really spent. Price the needs first; if they alone exceed the cap, the cap was unrealistic. Count tailoring and alteration in the same row as the garment they belong to.
What columns does the sheet need?
- Member: name or relationship, one row each.
- Cap: the most you agree to spend on this person.
- Needed items: things the person truly lacks, such as outgrown school-age festival wear or a kurta that no longer fits.
- Wanted items: nice extras, written down but bought only if money is left.
- Tailoring and alteration: stitching, blouse work, fall and pico, hemming.
- Actual: what was paid, filled in as you buy.
- Remaining: cap minus actual.
In Excel or Google Sheets, put the headings in row 1 and the members in rows 2 to 6. If the cap is in column B and actual spend is in column E, the remaining column F is =B2-E2, copied down. The totals row can use =SUM(B2:B6) for caps, =SUM(E2:E6) for actuals and =B7-E7 for what is left across the family.
Worked example for a household of five
Say two adults, two children aged 14 and 8, and a grandmother celebrate together. The family sets a total of ₹16,000. The caps and the hypothetical actuals are below.
| Member | Cap | Actual | Variance |
|---|---|---|---|
| Father | ₹3,000 | ₹2,700 | ₹300 under |
| Mother (saree, blouse stitching, fall and pico) | ₹5,000 | ₹4,700 | ₹300 under |
| Elder child | ₹3,000 | ₹3,300 | ₹300 over |
| Younger child | ₹2,500 | ₹2,200 | ₹300 under |
| Grandmother | ₹2,500 | ₹2,100 | ₹400 under |
| Total | ₹16,000 | ₹15,000 | ₹1,000 under |
The arithmetic: caps 3,000 + 5,000 + 3,000 + 2,500 + 2,500 = 16,000. Actuals 2,700 + 4,700 + 3,300 + 2,200 + 2,100 = 15,000. Inside the mother's row, say the saree was ₹3,600, blouse stitching ₹900 and fall and pico ₹200, which gives 3,600 + 900 + 200 = ₹4,700.
How do you separate needed from wanted?
For each person, list what is in the cupboard that fits and is fit to wear on the day. Anything missing from that outfit is a need. Everything else is a want, however much the shop display suggests otherwise. Put the needs in the sheet with a rough price before you leave home. The wants go in a second column with the word 'if money is left'.
A quick test for the elder child's row: if the needed items cost ₹2,000 and the cap is ₹3,000, there is ₹1,000 for wants. If the needed items already cost ₹3,400, the cap was set too low and you have a decision to make before you shop, not at the billing counter.
Why do tailoring and alteration costs break caps?
Fabric and stitching are two separate bills, and the second is often forgotten when the cap is set. Blouse stitching, kurta stitching, pant hemming and children's alterations can easily match the garment itself. Ask the tailor for a rate for each piece before you buy the fabric, and add that number to the row. Leave time too: festival weeks are busy for tailors, and a rushed job costs more or goes wrong.
Can adults and children share the cap?
They can, but only if the family agrees on it up front. A single pool works for small households; separate caps work better when two people shop on different days. Whichever you choose, write the total on the first row and subtract each purchase as you make it, so nobody discovers the overshoot on the last evening.
Keeping the record afterwards
Create a category such as festival clothing so these purchases sit apart from everyday shopping. If the family pays by card, SpendixAI can take your card statement as a PDF, CSV or Excel file, and you review the rows before saving them, which saves retyping each billing counter entry. Cash and tailoring payments can be added by hand.
Before the shopping day
- Caps for every person added up and compared with the household total
- Needs priced for each row, wants listed separately
- Tailor's rate collected for each stitched item
- Bills kept and photographed for returns or alterations
- Last year's total noted for comparison
Useful ideas start with a clearer picture of your own spending.
Explore your reports


