A house built on your own plot is easiest to control when every rupee is tagged to a stage. Keep one ledger with a row per payment, a column for the stage, and a second small table with planned and actual per stage. The difference between those two columns tells you where the budget is slipping while there is still time to act.
Which stages should the ledger have?
- Land and approvals: plot cost, registration, survey, plan and permission costs.
- Foundation: excavation, footings, plinth.
- Structure: columns, floors and roof, brickwork or block work, staircase.
- Services: electrical, plumbing, drainage, water storage.
- Finishing: plaster, flooring, doors, windows, paint, fittings.
- Handover and extras: compound wall, gate, connection charges, cleaning, a contingency line.
Rename them to match how your contractor or architect splits the work. The point is that every payment fits exactly one stage.
What columns does the payment sheet need?
Keep it to eight columns: date, stage, item, paid to, mode (UPI, cheque, cash), amount, bill or receipt number, and a note. In Excel or Google Sheets, put the date in column A, the stage in B, the item in C and the amount in D, with data starting on row 2. To total one stage, use this formula.
- =SUMIFS($D$2:$D$500, $B$2:$B$500, "Foundation") gives the actual spent on Foundation so far.
- =SUMIFS($D$2:$D$500, $B$2:$B$500, G2) does the same when the stage name sits in cell G2, so you can copy it down a list of stages.
- =H2-I2, where H2 is actual and I2 is planned, gives the variance for a stage. A positive figure means over plan.
SUMIFS takes the range to add first, then pairs of a range to check and what to match. It works the same in Excel and Google Sheets.
What does a planned against actual table look like?
With made-up figures, a plan may look like this after the first three stages.
| Stage | Planned | Actual so far | Variance |
|---|---|---|---|
| Foundation | ₹6,00,000 | ₹6,40,000 | +₹40,000 |
| Structure | ₹18,00,000 | ₹19,50,000 | +₹1,50,000 |
| Finishing | ₹12,00,000 | ₹11,20,000 | -₹80,000 |
| Total | ₹36,00,000 | ₹37,10,000 | +₹1,10,000 |
The arithmetic: 6,00,000 + 18,00,000 + 12,00,000 = ₹36,00,000 planned, 6,40,000 + 19,50,000 + 11,20,000 = ₹37,10,000 actual, and 37,10,000 minus 36,00,000 = ₹1,10,000 over. The sheet shows the overspend sits in structure, which is where to ask questions.
How often should I update the ledger?
Enter payments the day you make them, and set aside ten minutes every Sunday to check the sheet against your bank statement and your pocket diary. Most gaps are cash handed over on site and forgotten by the weekend. A weekly check also lets you spot early if one stage is running over, because a ₹40,000 overrun in foundation is far easier to adjust for than a lakh discovered at handover.
What if a payment covers two stages?
Split it into two rows with the same bill number, one for each stage, so the stage totals stay honest. If a contractor takes a lump sum that mixes labour and material, ask for a breakdown in writing, or tag it to the main stage and add a note.
When a sheet stops being enough
A single sheet works well for one site. If you want to pull each month's bank debits straight into stage-wise categories, SpendixAI lets you upload statements, review rows before saving, set up your own categories and sub-categories for each stage, and add cash payments by hand. It does not know your plan, so keep the planned column in your own sheet.
Before each stage starts
- Update the planned figure if the quote has changed, and note why.
- Check the last stage's actual against its bills.
- Add a contingency line and move money into it only deliberately.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


