An interior designer's money is tangled across many projects, with client instalments arriving in stages and carpenters, tile vendors and electricians paid in dribs and drabs. The cleanest way to untangle it is one ledger sheet with a project code on every row, and a summary sheet that uses SUMIFS to show each project's cash position and margin. Here is that layout.
What are the three tabs?
- Projects: one row per project with code, client first name, site, quotation amount, start date and expected end date.
- Ledger: every rupee in or out, one row each, with the project code.
- Summary: one row per project, filled by formulas, showing received, paid, cash position and margin.
How should the ledger rows look?
| Column | Heading | Example (sample) |
|---|---|---|
| A | Date | 12-Sep-2026 |
| B | Project code | P-014 |
| C | Type | Client receipt or Vendor payment |
| D | Party | Carpenter, tiles, electrician, or the client |
| E | Work or stage | Wardrobe carcass, first instalment |
| F | Amount | ₹85,000 |
| G | Mode and reference | UPI, NEFT or cash, with a short note |
Use a drop-down on column C with exactly two options, so the Summary formulas never miss a row because of a spelling difference.
What does the Summary formula look like?
Say project codes are in column A of Summary, and the quotation is pulled from Projects in column B. Then:
- Received: =SUMIFS(Ledger!$F$2:$F$1000, Ledger!$B$2:$B$1000, $A2, Ledger!$C$2:$C$1000, "Client receipt")
- Paid out: =SUMIFS(Ledger!$F$2:$F$1000, Ledger!$B$2:$B$1000, $A2, Ledger!$C$2:$C$1000, "Vendor payment")
- Cash position: =C2-D2
- Still to collect: =B2-C2
Which numbers matter most? A worked example
Take a sample project. The quotation is ₹8,50,000. The client has paid 40% as an advance (₹3,40,000) and 30% at the carcass stage (₹2,55,000), so received is ₹5,95,000. You have agreed ₹6,20,000 of vendor and carpenter work in total and paid ₹3,10,000 so far.
| Line | Amount |
|---|---|
| Quotation | ₹8,50,000 |
| Received from client | ₹5,95,000 |
| Paid to vendors | ₹3,10,000 |
| Cash position today (received minus paid) | ₹2,85,000 |
| Agreed vendor cost | ₹6,20,000 |
| Margin on paper (quotation minus agreed cost) | ₹2,30,000 |
The paper margin of ₹2,30,000 is about 27% of the quotation (230 divided by 850). The cash position tells you something different: you are holding ₹2,85,000 now, but ₹3,10,000 more is owed to vendors (6,20,000 minus 3,10,000), so the money in hand is not yours yet. If the cash position drops near zero while work remains, pause before ordering anything new.
How do you track vendor commitments?
Add a Vendors tab with project code, vendor, work, agreed amount and paid so far, using SUMIFS on the Ledger for the paid column. The balance column is agreed minus paid. The total of the agreed column per project feeds the margin check, so it stays honest when a carpenter's quote changes.
What should you check every Friday?
- Which projects have a cash position below the unpaid vendor total.
- Which client instalments are due this week, so you can send the reminder.
- Whether any cash payments to carpenters are missing a note on the ledger row.
How do you close a project properly?
When the handover is done, add a final line on the Summary tab: quotation plus approved variations, less every vendor payment, equals the project's actual margin. Compare it with the margin on paper at the start. The gap, whether good or bad, tells you which stage went off plan. Keep the closed project's rows in the ledger rather than deleting them, because the next quotation is easier to price when you can see what a similar job really cost.
GST on your design fees and materials depends on how you bill, so ask your CA how to record it; a separate GST column in the ledger keeps it out of your margin. If your bank statements pile up, SpendixAI can import them so the payment lines are already there to copy into the ledger.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


