A furniture tracker lists every piece by room with the quoted price, what you paid, the delivery date, the warranty end and a flag for buy now or later. Add two formulas and you can see the total for each room and how much you must spend before you move in.
What columns should the tracker have?
- A: Room
- B: Item
- C: Quoted price
- D: Paid so far
- E: Delivery date
- F: Warranty end date
- G: Buy now or later
Keep one row per item, even if two items are from the same shop. It makes the totals honest.
A worked example
Hypothetical numbers for a new flat.
| Room | Item | Quoted | Flag |
|---|---|---|---|
| Bedroom | Bed with storage | ₹24,000 | Now |
| Bedroom | Mattress | ₹12,000 | Now |
| Living room | Sofa | ₹32,000 | Later |
| Dining | Table and four chairs | ₹18,000 | Now |
| Storage | Shoe rack | ₹4,500 | Later |
Items to buy now: 24,000 plus 12,000 plus 18,000 is ₹54,000. Items for later: 32,000 plus 4,500 is ₹36,500. Everything together is ₹90,500.
Which formulas do I need?
Total quoted for one room, here Bedroom:
=SUMIFS($C$2:$C$60,$A$2:$A$60,"Bedroom")
Total for the items flagged Now:
=SUMIFS($C$2:$C$60,$G$2:$G$60,"Now")
Balance still to pay on everything:
=SUM($C$2:$C$60)-SUM($D$2:$D$60)
Warranty end date, if the warranty is a number of years in H2 and the delivery date is in E2:
=EDATE(E2,H2*12)
All four work in Excel and Google Sheets. Always use the delivery date for the warranty if the paper says so; some start at purchase.
How do I decide what to buy now?
Ask three questions for each item. Can we live without it for three months? Is it needed for sleeping, cooking or safety? Will a sale or festival offer be coming soon? Beds and mattresses usually go on the first list; a second sofa can wait. Be careful about the part that says wait for a sale; check the offer is real against the price you were quoted.
Where do the payments get recorded?
Pay by UPI or bank transfer when you can and keep invoices. SpendixAI can categorise the payments as Furniture, and you can keep the invoice with each transaction. The warranty dates and the buy-now flag are easier to manage in the sheet.
What if I want to compare two shops?
Add two price columns, one for each shop, and a column for delivery charge and assembly. Compare the full price, not the sticker price. Say a sofa is ₹32,000 at one shop with free delivery, and ₹30,500 at another with ₹2,000 delivery. The second costs ₹32,500, so it is dearer by ₹500.
Ask also about return and replacement terms for each piece, and write the answer in the notes column. A small difference in price is easily outweighed by a difficult return.
How do I handle delivery and damage?
When furniture arrives, check it before the delivery person leaves: look for scratches, dents and missing parts, and take photos of the item and the packing. If something is wrong, note it on the delivery slip and message the shop that day. Write the date of delivery in column E, because it is the date many warranties and return windows depend on.
Keep the carton and the fitting instructions until you are sure everything works, and file the invoice with the warranty card in the same place as your sheet.
Before you shop
- Measure each room and the doors the furniture must pass through.
- List items by room in the sheet.
- Get at least two quotes for the large pieces.
- Mark each Now or Later.
- Update the paid column after each payment.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

