Track a room or bathroom for in-laws as one project with its own list: every quote, every advance, every material bill and a column saying who paid. Keep it in one place from the first estimate to the last tile. At the end you can total it by item and by funder, which answers both how much it cost and who put in what.
What should the project list contain?
One row per payment or bill, with these columns: date, what it was for, amount, paid to, paid by, mode (cash, UPI, cheque, transfer), and a note or bill number. Add a second small table for quotes, with the contractor's name, the date and the amount quoted. Keep the two separate: a quote is a promise, a payment is a fact.
| Date | Item | Amount | Paid to | Paid by | Mode |
|---|---|---|---|---|---|
| 3 Mar | Advance to mason | ₹30,000 | Mason | Son | UPI |
| 10 Mar | Cement and sand | ₹18,500 | Supplier | Father | Cheque |
| 24 Mar | Tiles for bathroom | ₹26,000 | Tile shop | Son | Card |
| 2 Apr | Plumbing fixtures | ₹14,200 | Plumber | Daughter-in-law | UPI |
The figures here are only to show the shape of the sheet.
How do you handle advances to the mason?
Advances are the trickiest part, because they are paid before the work. Record each advance as its own line and note what stage it was meant for, such as foundation, walls or finishing. When the final bill comes, subtract all advances from it to see what remains. Keep a short written note of the agreed rate and stages, signed or at least messaged by both sides; a photo of a notebook page is better than memory.
Cash advances should carry a date and a witness name in the note, even if just a family member who was present. Where you can, pay by UPI or transfer instead, so the bank statement backs up your list.
How do you keep quotes and actual costs apart?
Make a quotes table and an actuals table. Compare them at the end: if the plumber quoted ₹35,000 and you paid ₹38,500, the difference of ₹3,500 deserves a note, such as extra pipe length or a changed fixture. A reader who sees only the final total never learns where plans moved. Use hypothetical differences like this to check that your sheet subtracts correctly.
Who funded what, and why does it matter?
If the money comes from several people, such as a son, a father and savings, add a Paid by column from day one. Later it will be obvious who covered the mason, who covered the fixtures and whether anyone expects to be repaid. Where a payment is a loan between family members, write that in the note. Where it is a gift, write that too. Reconstructing this from memory after a year is hard and sometimes painful.
What does the final summary look like?
- Total all actual payments to get the project cost.
- Sum them by item: labour, materials, fixtures, electrical, painting, miscellaneous.
- Sum them by funder: each person's total contribution.
- Compare against the original quote total and note the biggest differences.
- Attach the bills and receipts, numbered to match the list.
Take hypothetical totals of ₹1,12,000 on labour and ₹1,38,000 on materials and fixtures. The project cost is ₹2,50,000. If the son paid ₹1,40,000, the father ₹90,000 and the daughter-in-law ₹20,000, the funders add up to the same ₹2,50,000, which is how you know nothing was missed.
Where to keep bills and receipts
Keep paper bills in one envelope and take a photo of each as you pay. If you use SpendixAI, receipts can be kept with their transactions, and a custom category such as Home extension, with sub-categories for labour and materials, lets the reports show the project total separately from daily household spending. Expenses paid in cash can be added by hand.
Before the project closes
- Match the sheet's total with the bank statement for non-cash payments
- Ask the contractor for a final bill showing advances received
- Note the date work finished and any warranty promises
- Share the final summary with everyone who contributed
Useful ideas start with a clearer picture of your own spending.
Explore your reports

