Record every advance you pay an interior vendor on one line: who, for what, how much, on what date, what delivery was promised and what balance is still owed. Add a flag column that turns on when the promised date has passed and the item has not arrived, and you stop relying on memory.
Why do advances need their own record?
An interior project runs on advances: carpenter, electrician, false-ceiling team, curtain maker. Each takes some money before work begins, so at any moment you have paid for things you do not yet have. If you do not track them, you lose sight of how much is at stake and who is late.
What columns should the sheet have?
- A: Vendor
- B: Item, such as wardrobe, TV unit, modular kitchen
- C: Order total
- D: Advance paid
- E: Date of advance
- F: Promised delivery date
- G: Delivered? Type Yes when it arrives
- H: Balance owed, worked out as C minus D
- I: Flag for late delivery
In H2 type =C2-D2. In I2 type the following and fill down:
=IF(AND(G2<>"Yes",F2<TODAY()),"Overdue","")
That shows the word Overdue when the item is not marked Yes and the promised date is already in the past. To total the advances still sitting with vendors for undelivered items, use:
=SUMIFS($D$2:$D$100,$G$2:$G$100,"<>Yes")
It works in Excel and Google Sheets. Blank cells in column G count as not delivered, which is what you want.
A worked example
Hypothetical: a carpenter's wardrobe order totals ₹1,20,000. You pay ₹40,000 in advance on 1 October and the promised delivery is 10 December. The balance owed is ₹80,000. On 15 December the item has not arrived. The flag shows Overdue, and the money at risk is the ₹40,000 advance. Say an electrician has a ₹15,000 order with a ₹5,000 advance, delivered. Undelivered advances total ₹40,000, because the electrician's row is marked Yes.
| Vendor | Item | Order | Advance | Promised | Flag |
|---|---|---|---|---|---|
| Carpenter | Wardrobe | ₹1,20,000 | ₹40,000 | 10 Dec | Overdue on 15 Dec |
| Electrician | Wiring and points | ₹15,000 | ₹5,000 | 20 Nov | Delivered |
How should I pay an advance?
Pay by UPI or bank transfer where you can, so a record sits in your statement. Put the item and date in the payment note. Ask for a written order or a message that states the item, the total, the advance and the promised date. If something goes wrong, those are your papers.
Where do the statements fit in?
The sheet tracks promises; your bank statement shows what left your account. SpendixAI lets you upload the statement, review the rows and category-tag the advances, so the amounts in the sheet can be checked against actual payments, and cash advances can be added by hand with the slip attached.
How big should an advance be?
There is no fixed rule, so decide what you are comfortable losing if the vendor disappears. Many people find it easier to tie payments to stages: a smaller amount to start, more when materials arrive on site, the balance on fitting. For made-to-order items, ask what the vendor does with the advance; if it buys the material, the vendor may reasonably want more upfront than for a simple repair.
Whatever you agree, write it in the sheet before paying. Your future self will thank you.
What proof should I keep with each advance?
- The written order or message listing item, total, advance and promised date
- The payment confirmation from UPI or bank transfer
- The vendor's receipt or acknowledgement, if given
- Photos of the item or site on the day work began
Weekly routine
- Open the sheet and look at the flag column.
- Message any vendor who is overdue.
- Update the delivered column as items arrive.
- Check that the advance column matches your statement.
- Total the undelivered advances and see if you are comfortable.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


