A wedding invitations tracker is a sheet with one row per invitation and columns for date, family, city, relationship, travel cost, gift cap and your decision to attend. Add a cell for your season budget, and two formulas total the cost of the weddings you have said yes to and show what is left. It works in Excel and Google Sheets.
The columns
- A: Date of the wedding
- B: Family or couple
- C: City
- D: Relationship
- E: Travel cost (estimate, including stay if any)
- F: Gift cap
- G: Attend? (type Yes, No or Maybe)
- H: Cost if attending
Put your season cap in cell K1 and a label in J1. Row 1 holds headings, and data starts in row 2.
The formulas
In H2, type the following and fill it down:
- Cost in H2: =IF(G2="Yes",E2+F2,0)
- Total committed: =SUM($H$2:$H$100)
- Left in the season budget: =$K$1-SUM($H$2:$H$100)
- Number of weddings you will attend: =COUNTIF($G$2:$G$100,"Yes")
- Cost if every Maybe becomes Yes: =SUMPRODUCT(($G$2:$G$100="Maybe")*($E$2:$E$100+$F$2:$F$100))
- Running total in each row (put in I2 and fill down): =SUM($H$2:H2)
The SUMPRODUCT line needs numbers, not text, in columns E and F, so leave a cell blank rather than typing a dash. Every function above is available in all current versions of Excel and in Google Sheets.
A few notes on layout. Freeze row 1 so the headings stay visible, add a drop-down list to column G so only Yes, No or Maybe can be typed, and sort by date once you have more than a dozen rows. In Google Sheets the drop-down comes from Data validation under the Data menu; in Excel it is Data Validation on the Data tab. In both, you can type the list as Yes,No,Maybe.
A worked example with made-up numbers
| Wedding | Travel | Gift cap | Decision | Cost counted |
|---|---|---|---|---|
| Cousin, Jaipur | ₹3,000 | ₹5,000 | Yes | ₹8,000 |
| Colleague, same city | ₹200 | ₹2,000 | Yes | ₹2,200 |
| Friend, Pune | ₹6,000 | ₹3,000 | Maybe | ₹0 |
| Neighbour, same city | ₹0 | ₹1,500 | Yes | ₹1,500 |
| Relative, Lucknow | ₹5,500 | ₹4,000 | Yes | ₹9,500 |
With a season budget of ₹30,000, the total committed is 8,000 + 2,200 + 1,500 + 9,500 = ₹21,200, leaving ₹8,800. If the Pune Maybe turns into a Yes, add 6,000 + 3,000 = ₹9,000, which makes ₹30,200 and takes you ₹200 over. The sheet shows the trade-off before you decide.
Notice what the sheet does not decide. It will not tell you whether the Pune wedding is worth ₹9,000; it only shows what saying yes does to the total. Some people set a rule such as no more than two out-of-town weddings a season and write it beside the cap.
How do you decide which weddings to attend?
Add a column for how close you are and how hard travel is, and go through the list with your family. Some weddings are non-negotiable; others you can mark as a short visit, a gift sent ahead, or a polite no. Writing the decision in the sheet takes the pressure out of the conversation, because everyone sees the same totals.
What about gifts you decide not to give in cash?
Gift cap means the total you are willing to spend, in whatever form. If you plan to give an item instead of an envelope, enter its price. For cash gifts, a separate record of what you gave is useful for future occasions; a companion article on shagun envelopes covers that.
When a sheet stops being enough
If the sheet works, keep it. If you want the actual spending to flow in without retyping, SpendixAI can take card and bank statements by upload and let you set a budget, so the wedding-season spend sits next to the rest of your month.
Before the season starts
- Set the season cap in K1.
- Enter each invitation as it arrives.
- Mark Yes, No or Maybe after discussing with family.
- Check the remaining budget before accepting anything new.
- Revisit the Maybe rows a month before each date.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


