Track every function booking in one table: vendor, booking date, total agreed, advance paid, balance due, due date, cancellation terms and receipt kept. Update it each time you pay, and you will always know what you owe, to whom, and by when.
The tracker, row by row
| Vendor | Booked on | Total agreed | Advance paid | Balance due | Due date | Receipt |
|---|---|---|---|---|---|---|
| Banquet hall | 5 Jan | ₹80,000 | ₹20,000 | ₹60,000 | 2 weeks before | Yes |
| Tent house | 5 Jan | ₹25,000 | ₹5,000 | ₹20,000 | Day before | Yes |
| Decorator | 18 Jan | ₹30,000 | ₹10,000 | ₹20,000 | On the day | No |
The figures are made up. Balance due is the total minus the advance, so ₹80,000 minus ₹20,000 is ₹60,000. In a spreadsheet, you can write the balance as =C2-D2, and the total owed across all vendors as =SUM(E2:E4), which here gives ₹60,000 plus ₹20,000 plus ₹20,000, or ₹1,00,000.
What should you record at the time of booking?
- The vendor's full name and phone number, and the person you dealt with.
- The date and the time slot booked, including set-up and clearing hours.
- What the price includes: tables, chairs, lights, power backup, parking, cleaning.
- The advance paid, the mode of payment and the receipt number.
- The balance due date, in the calendar of at least two family members.
What do you check before paying an advance?
Ask for the cancellation and refund terms in writing and read them. Ask what happens if you change the date, reduce the guest count or if the venue cancels. Ask whether any extra fee, such as a security deposit, is returnable and how it is returned. Questions are cheaper to ask before you pay than after.
What if the date or the guest count changes?
Functions change shape. A relative cannot travel, the muhurat moves by a day, or the guest list grows. Write down, at the time of booking, what each vendor will do if you change the date or the numbers, and by how many days' notice. Then add a column to your tracker called Change window, with the last date you can change without a charge. This one column has saved many families from paying for a hall they could not use.
How do you handle tent house items?
For a tent house, list each item with its count: tents, chairs, tables, carpets, lights and sound. On delivery, count them with the vendor and note the number. On return, count again. Missing or damaged items are usually charged, so a written count on both days protects you.
How do you track balance dues for several vendors?
Sort the tracker by due date, not by vendor. Add a column for the person responsible for paying, so the work is split. A week before the function, go through every row and check that it has a due date, a confirmed amount and the cash or transfer ready.
An expense tracker can take over some of this. In SpendixAI you can add each advance as an expense, upload the card or bank statement to pull in transfers, and keep the receipts attached to their transactions. Use the spreadsheet for the dues and the app for the record of what has been paid, if you want both.
Share the tracker with the family member who will be at the venue on the day. They can tick each row as the vendor arrives, pays or is paid, which turns a busy function into a calm one.
After the function
- Settle each balance and collect the final receipt.
- Check that any deposit is returned and note the date.
- Update the tracker so that every row shows nil due.
- Keep the tracker and receipts for the year, in case a vendor raises a question later.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


