How to Use Google Sheets for Wedding Budget Tracking: Free Templates

The Spreadsheet That Saved the Wedding

It was the third meeting with the wedding planner — the one where the couple was supposed to finalise the vendor shortlist and begin making deposits — when the bride's mother asked the question that changed the trajectory of the planning.

"How much have we actually spent so far?"

The room was quiet for a moment. The bride looked at the groom. The groom looked at his phone, where he had a notes application containing various numbers that had been recorded at various times in various contexts without a consistent format or a running total. The bride's mother had a folder with printed quotes from three vendors. The groom's father had paid the engagement photographer directly and the amount was somewhere in his personal banking app.

The wedding planner had her own records of the amounts that had been discussed in meetings. But the couple's own record — the single document that should have contained every amount committed, every deposit paid, every quote received, every category of expenditure with its budgeted and actual figures — did not exist.

"We have the quotes," the bride said. "And some receipts."

The wedding planner did the thing she did in this situation — which was not to express the specific feeling that the situation produced in her but to open her laptop and share a Google Sheets template with the couple that she had built over years of working with clients who had arrived at the third meeting without a consolidated budget document.

"We are going to spend the first thirty minutes of this meeting building your budget tracker," she said. "And then every meeting after this one will begin by updating it."

They spent forty-five minutes on it rather than thirty. By the end of the forty-five minutes, the couple had a document that contained every amount that had been spent, every amount that had been committed, every amount that was budgeted for categories not yet spent, and a running total at the top of the sheet that answered the bride's mother's question clearly and immediately.

The answer was: significantly more than the couple had informally estimated, and the gap between the informal estimate and the actual number was large enough to require a specific conversation about priorities.

That conversation — the one that the spreadsheet made possible and that the notes application and the folder of printed quotes would never have prompted — is the conversation that the wedding budget tracker exists to produce. Not to restrict spending but to make the spending visible, so that the choices being made are genuine choices rather than the default accumulation of commitments that have never been assembled into a complete picture.

This guide builds that document — from the first cell to the final dashboard — with the specific structure, the specific formulas, and the specific templates that the NRI wedding's complexity requires.

Why Google Sheets Is the Right Tool

The Alternatives and Their Limitations

The notes application:

The notes application — Apple Notes, Google Keep, the default notes app on any smartphone — is the most commonly used informal budget tracking tool at the beginning of the wedding planning process. It is also the worst. Notes applications store information in the format it was entered — a note that says "venue 45000" provides no context about whether this is the deposit or the total, no running total, no comparison to the budgeted amount, and no visibility to anyone who was not the person who entered it.

The spreadsheet application on a single device:

A spreadsheet created in Microsoft Excel on a specific laptop is better than a notes application but worse than a shared cloud document — the couple cannot both access it simultaneously, it is not available on mobile, and it is at risk of being lost with the device.

The dedicated wedding budget applications:

The dedicated wedding planning applications — The Knot, Zola, WeddingWire — include budget tracking features that are adequate for a straightforward domestic wedding but are frequently insufficient for the NRI wedding's complexity. They are designed for a single-currency budget in a single country, without the multi-currency tracking, the international vendor payment management, and the category structure that the NRI wedding requires. They also create a dependency on the specific application's continued operation and the couple's continued subscription.

Google Sheets:

Google Sheets is the right tool for the NRI wedding budget tracker for five specific reasons. It is free — no subscription, no per-feature cost, no premium tier required for the features the budget tracker needs. It is collaborative — the couple, the families, and the wedding planner can all access and edit the same document simultaneously from any device in any country. It is cloud-based — the document exists independently of any specific device and is accessible from anywhere. It is powerful enough — the formula set available in Google Sheets is sufficient for every calculation the wedding budget tracker requires. And it is familiar enough — the majority of people involved in the wedding planning have used a spreadsheet at some point and can navigate a well-structured Google Sheet without training.

Building the Budget Tracker: The Complete Structure

The Document Architecture

The NRI wedding budget tracker is not a single sheet — it is a document with multiple tabs, each serving a specific function, linked together so that the summary tab reflects the detail tabs automatically.

The tabs:

Tab 1: Dashboard — the summary view that answers the bride's mother's question at a glance.

Tab 2: Master Budget — the complete category-level budget with budgeted amounts, committed amounts, paid amounts, and remaining amounts for every expenditure category.

Tab 3: Vendor Tracker — the detailed record of every vendor, their contract value, deposit status, payment schedule, and contact information.

Tab 4: Payment Log — the chronological record of every payment made, the method used, the exchange rate applied, and the vendor receiving the payment.

Tab 5: Currency Converter — the live reference for the Pound-to-Rupee, Dollar-to-Rupee, and other relevant exchange rates with the conversion calculations for international payments.

Tab 6: Guest Count and Per-Head Tracking — the per-head cost calculations that connect the guest count to the catering, venue, and other per-head expenditure categories.

Tab 7: Contingency and Overage Tracker — the record of budget overages by category and the contingency fund's current status.

Tab 1: The Dashboard

The dashboard is the first tab the couple sees when they open the budget tracker — the view that provides the complete budget picture without requiring navigation through the detail tabs.

The dashboard structure:

The headline numbers (top of the dashboard):

Total budget: the overall wedding budget agreed by the couple and the families.

Total committed: the sum of all signed contracts and confirmed verbal commitments.

Total paid: the sum of all payments made to date.

Total remaining budget: Total budget minus Total committed.

Remaining to pay: Total committed minus Total paid.

These five numbers — updated automatically as the detail tabs are updated — answer the bride's mother's question instantly and completely. They should be large, clearly labelled, and prominently positioned at the top of the dashboard.

The category summary (middle of the dashboard):

A table showing each major expenditure category — Venue, Catering, Decor, Photography and Videography, Outfits and Jewellery, Entertainment, Accommodation, Transportation, Invitations and Stationery, Beauty and Grooming, Priest and Ceremony, Gifts and Favours, Miscellaneous — with four columns: Budgeted, Committed, Paid, Variance.

The Variance column — Budgeted minus Committed — shows at a glance which categories are over budget and which have remaining room. A conditional formatting rule that colours negative variances red and positive variances green makes the over-budget categories immediately visible without requiring mathematical interpretation.

The visual summary (bottom of the dashboard):

A pie chart showing the budget allocation by category — generated automatically from the category summary table. The pie chart is the single visual that most effectively communicates where the wedding budget is going, and the NRI couple who has not explicitly decided on their budget allocation is often surprised by the pie chart's visual representation of what the numbers had been telling them without visual form.

Setting Up the Dashboard: The Formulas

The headline numbers:

Total budget is a manually entered figure — the agreed total wedding budget — that does not change unless the couple explicitly decides to revise it.

Total committed uses a SUMIF formula that pulls from the Vendor Tracker tab, summing the contract value column for all vendors whose status is marked as "Confirmed":

=SUMIF('Vendor Tracker'!G:G,"Confirmed",'Vendor Tracker'!D:D)

Total paid uses a SUM formula that pulls from the Payment Log tab:

=SUM('Payment Log'!E:E)

Total remaining budget:

=B2-B3

(Where B2 is Total budget and B3 is Total committed)

Remaining to pay:

=B3-B4

(Where B3 is Total committed and B4 is Total paid)

The category summary:

The Budgeted column is manually entered — the couple's allocation for each category. The Committed column uses SUMIF formulas pulling from the Vendor Tracker tab, summing by category. The Paid column uses SUMIF formulas pulling from the Payment Log tab, summing by category. The Variance column subtracts Committed from Budgeted.

Tab 2: The Master Budget

The Master Budget tab is the planning document — the place where the couple sets the budget allocation before spending begins, and where the gap between budget and reality becomes visible as the planning progresses.

The Master Budget structure:

Column A: Category (the major expenditure categories listed above)

Column B: Sub-category (the specific line items within each category — for Venue: ceremony venue, reception venue, mehndi venue, cocktail area; for Photography: photographer fee, videographer fee, drone, album)

Column C: Budgeted Amount (INR) — the planned allocation for this line item

Column D: Vendor (the vendor assigned to this line item, linked to the Vendor Tracker)

Column E: Contract Amount (INR) — the actual contract value once a vendor is confirmed

Column F: Variance (Column C minus Column E) — the difference between budgeted and actual

Column G: Notes — specific notes about this line item

The sub-category structure for NRI weddings:

The NRI wedding's expenditure categories require more sub-categories than the standard domestic wedding tracker because of the multi-day, multi-event structure and the international guest logistics. Some specific sub-categories that the NRI wedding budget tracker should include:

Under Venue: separate line items for each event (mehndi venue, sangeet venue, ceremony venue, reception venue) and the additional costs that destination wedding venues often have (venue hire for accommodation block, venue exclusive use fee, generator hire, additional lighting infrastructure).

Under Catering: separate line items for each event's catering, the welcome dinner, the farewell brunch, the guest hospitality (water, tea/coffee, snacks during non-meal periods), and the staff catering that large venues often charge separately.

Under Accommodation: the couple's own accommodation across the wedding week, the hosted guest accommodation (the family members whose accommodation the couple is funding), and the room block deposit and attrition clause exposure.

Under Transportation: the airport transfer logistics for international guests, the inter-venue shuttle service across the wedding week, the baraat vehicles, and the couple's own transport.

Under International Guest Logistics: the welcome kit budget, the hospitality desk budget, the cultural guide production, and the practical communication materials that the NRI wedding requires.

Tab 3: The Vendor Tracker

The Vendor Tracker is the complete record of every vendor engaged for the wedding — their contact information, their contract value, their payment schedule, and their current status.

The Vendor Tracker columns:

Column A: Vendor Category (from the Master Budget category list)

Column B: Vendor Name

Column C: Contact Name and Details (phone, email, WhatsApp)

Column D: Contract Value (INR)

Column E: Deposit Amount (INR)

Column F: Deposit Due Date

Column G: Status (Quote Received / In Negotiation / Confirmed / Deposit Paid / Full Payment Due / Fully Paid)

Column H: Balance Amount (INR) (Column D minus Column E)

Column I: Balance Due Date

Column J: Payment Method (SWIFT / Wise / Family Relay / Cash / UPI)

Column K: Contract Signed (Yes / No)

Column L: Notes

The status colour coding:

Apply conditional formatting to Column G so that each status level has a specific colour — grey for Quote Received, yellow for In Negotiation, blue for Confirmed, orange for Deposit Paid, red for Full Payment Due, green for Fully Paid. The colour-coded status column allows the couple to see at a glance which vendors require immediate action.

The payment due date alert:

Add a column (Column M) that calculates the number of days until the next payment is due and applies conditional formatting — red for payments due within seven days, orange for payments due within fourteen days, green for payments more than fourteen days away:

=IF(F2<>"",F2-TODAY(),IF(I2<>"",I2-TODAY(),""))

This formula checks whether the deposit date or balance date is closer and calculates days remaining. The conditional formatting on this column is the closest the budget tracker comes to an active alert system — the couple who reviews the Vendor Tracker at the beginning of each week sees immediately which payments are approaching.

Tab 4: The Payment Log

The Payment Log is the chronological record of every payment made — the document that answers the question "what have we actually paid?" with the specificity that the notes application cannot provide.

The Payment Log columns:

Column A: Date of Payment

Column B: Vendor Name

Column C: Category

Column D: Payment Description (Deposit / Balance / Part Payment / Miscellaneous)

Column E: Amount Paid (INR)

Column F: Amount Paid (Home Currency — GBP/USD/CAD/AUD)

Column G: Exchange Rate Applied

Column H: Payment Method (SWIFT / Wise / Family Relay / Cash / UPI)

Column I: Transfer Reference Number

Column J: Confirmation Received from Vendor (Yes / No / Pending)

Column K: Notes

The exchange rate tracking:

Column G — the exchange rate applied — is the specific column that allows the couple to track the total cost of currency conversion across all international payments. The couple who calculates the average exchange rate applied across all their India payments and compares it to the mid-market rate for the same period has the specific information needed to assess whether their payment method choices were optimal.

Tab 5: The Currency Converter

The Currency Converter tab is the NRI wedding budget tracker's specific addition for the international context — the reference tool for converting between the couple's home currency and Indian Rupees consistently throughout the planning process.

The structure:

A simple reference table with the major currency pairs relevant to the couple's guest list and vendor payment context:

GBP to INR: manually entered current rate (updated weekly or before each significant payment)

USD to INR: manually entered current rate

CAD to INR: manually entered current rate

AUD to INR: manually entered current rate

EUR to INR: manually entered current rate

The conversion calculator:

Below the reference table, a simple conversion calculator — enter an amount in home currency, multiply by the relevant exchange rate, display the Rupee equivalent. This calculator is the tool the couple uses when a vendor quotes in Rupees and the couple wants to understand the cost in their home currency, or when the couple is sending a payment and needs to know exactly how many home currency units to send to arrive at the correct Rupee amount.

The budget in home currency:

A column alongside the Master Budget's Rupee column that converts every budget figure to the couple's home currency at the current reference rate — allowing the couple to see their wedding budget in the currency they think in as well as the currency they are spending in.

Tab 6: Guest Count and Per-Head Tracking

The guest count and per-head tracking tab connects the guest count to the expenditure categories that scale with it — making visible the per-head cost of the wedding and the financial impact of guest count changes.

The structure:

The total confirmed guest count, with separate counts for each event (the mehndi may have a smaller guest list than the reception, the ceremony may have a different count from both).

The per-head expenditure categories: catering cost per head by event, venue cost per head by event, welcome kit cost per head.

The total per-head cost: the sum of all per-head expenditure divided by the guest count, giving the couple the specific figure of what the wedding is costing per guest.

The guest count change simulator:

A specific section of the tab that shows the financial impact of adding or removing ten, twenty, or fifty guests — calculated automatically from the per-head costs. The couple who is deciding whether to extend the guest list from one hundred and eighty to two hundred guests can see immediately that the addition of twenty guests at the current per-head cost represents a specific additional expenditure.

Tab 7: Contingency and Overage Tracker

The contingency fund — the budget allocation held in reserve for the unexpected costs that every wedding generates — should be tracked explicitly rather than held as a vague reserve.

The structure:

Contingency budget: the amount set aside (typically ten to fifteen percent of the total budget for an NRI wedding given its complexity).

Contingency used: the specific overages and unexpected costs that have been drawn from the contingency fund, with dates and descriptions.

Contingency remaining: Contingency budget minus Contingency used.

The overage record:

A log of every expenditure that exceeded its budgeted amount — the vendor whose contract value was higher than the budget line item, the unexpected cost that had no budget line item, the exchange rate loss that was larger than anticipated. The overage record is the document that teaches the couple — and that teaches the wedding planner working with NRI couples — where the NRI wedding's budget surprises consistently occur.

The Templates: Ready-to-Use Versions

Template One: The Standard NRI Wedding Budget Tracker

The standard template covers the full seven-tab structure described above, with the formulas pre-built and the categories pre-populated with the standard NRI wedding expenditure structure. The couple's task is to:

Enter the total budget in the Dashboard tab.

Allocate the budget across categories in the Master Budget tab.

Add vendors to the Vendor Tracker as they are confirmed.

Log payments in the Payment Log as they are made.

Update the exchange rates in the Currency Converter weekly.

The Dashboard updates automatically as the detail tabs are populated.

Creating the template:

Open Google Sheets at sheets.google.com. Create a new blank spreadsheet. Rename it "[Couple's Names] Wedding Budget [Year]." Create the seven tabs by clicking the plus button at the bottom of the screen and renaming each tab as described above. Build each tab following the column structure described in this guide. Share the document with the partner, the families, and the wedding planner using the Share button — set the couple's family to Editor access and the wedding planner to Editor or Commenter access depending on the preferred level of collaboration.

Template Two: The Multi-Family Budget Tracker

For NRI weddings where the costs are being shared between the bride's family and the groom's family — a common structure in which each family is funding specific events or specific categories — the multi-family budget tracker adds a family allocation layer to the standard template.

The addition:

An extra column in the Master Budget tab identifying which family is funding each line item (Bride's Family / Groom's Family / Shared / TBD).

A summary section in the Dashboard showing the total budget allocation and actual spend by family — the specific visibility that prevents the end-of-wedding conversation about who paid what from being conducted from memory rather than records.

A separate Payment Log section for each family's payments — allowing each family's contribution to be tracked independently while the totals feed into the combined dashboard.

Template Three: The Day-of Budget and Actuals Tracker

For the wedding week itself — when expenditures are happening daily and the budget picture is changing rapidly — a simplified day-of tracker is more practical than the full planning tracker.

The structure:

A single sheet with the wedding days as column headers and the active vendor categories as row headers. Each cell contains the expected payment for that vendor on that day. As payments are made, the cell is updated to the actual amount and colour-coded to indicate payment confirmed. The day-of tracker is the wedding week's operational document — the reference that the wedding coordinator and the couple's family use to manage the payment logistics across the wedding programme.

The Maintenance Discipline: Making the Tracker Work

The Weekly Update Ritual

The budget tracker that is built and then not maintained is the spreadsheet that provides the false comfort of a document existing without the actual comfort of the document being current. The couple who built the tracker in week one and has not updated it since week three is the couple who arrives at week thirty-six without knowing how much they have spent.

The weekly update ritual:

Every Sunday — or another consistent weekly day that the couple agrees on — the couple spends fifteen to twenty minutes updating the tracker. New vendor quotes received during the week are added to the Master Budget. Vendors confirmed during the week are updated to Confirmed status in the Vendor Tracker. Payments made during the week are logged in the Payment Log. The exchange rates in the Currency Converter are updated.

The fifteen-to-twenty-minute investment produces the complete and current budget picture that the bride's mother's question requires — not as a specific exercise when the question is asked, but as a continuously maintained record that answers the question whenever it is asked.

The Decision Gate

The budget tracker is most powerful not as a record of what has been spent but as the input to the decision gate — the specific moment before any significant commitment is made when the couple checks the tracker to assess whether the commitment is within the remaining budget.

The decision gate ritual:

Before confirming any vendor, before signing any contract, before making any commitment above a threshold amount (the couple should set their own threshold — ten thousand rupees, twenty-five thousand rupees — based on the scale of their budget), open the tracker and check three things: the category variance (is this category already over budget?), the total remaining budget (does the commitment fit within what remains?), and the payment schedule (does the deposit due date conflict with another significant payment due in the same period?).

The three-minute decision gate ritual is the specific practice that prevents the accumulation of commitments that has never been assembled into a complete picture — the situation that produced the silence in the third planning meeting when the bride's mother asked how much had been spent.

Common Mistakes NRI Couples Make With Budget Tracking

The first mistake is starting the budget tracker too late — after significant commitments have been made rather than before the first vendor is engaged. The tracker that begins at the third planning meeting is the tracker that must reconstruct the commitments of the first two months from memory and receipts. The tracker that begins before the first vendor call is the tracker that captures every commitment from the beginning.

The second mistake is not including all expenditure categories from the beginning. The NRI wedding budget tracker that does not include international guest logistics, welcome kits, hospitality desk costs, currency conversion losses, and the family accommodation hosted by the couple is the tracker that systematically underestimates the total cost. The complete category list — including the NRI-specific categories — should be in the Master Budget from day one, even if the amounts are initially zero.

The third mistake is tracking in a single currency when the wedding involves multiple currencies. The couple who tracks everything in Rupees without recording the home currency amount and the exchange rate applied cannot understand the true cost of the wedding in the currency they think in, cannot track the exchange rate losses across all international payments, and cannot communicate the budget to the family members in the UK or USA or Canada who are thinking in Pounds or Dollars.

The fourth mistake is not sharing the tracker with the relevant family members and the wedding planner. The budget tracker that only the bride has access to is not a collaborative planning document — it is a personal record that does not produce the shared visibility that the multi-family NRI wedding requires. Share the document with editor access to the key decision-makers and commenter access to the advisory participants from the beginning.

The fifth mistake is not maintaining the contingency fund as an explicit budget line rather than a vague reserve. The couple who says "we have some contingency" without knowing how much contingency they started with or how much of it has been used is the couple who discovers, at the moment when the contingency is needed, that it has already been spent on the overages that were not tracked as overages. The contingency fund is a specific budget line with a specific amount — tracked in Tab 7 with every draw from it recorded and the remaining balance visible.

The Document That Makes the Choices Visible

The forty-five minutes that the wedding planner spent building the budget tracker with the couple in the third meeting was not the most glamorous investment of the wedding planning process. It did not produce a beautiful object or a memorable experience or a decision that the guests would notice or appreciate.

It produced a document. A spreadsheet with seven tabs and a collection of formulas that were individually simple and collectively powerful.

What the document produced, over the following months, was the specific visibility that the notes application and the folder of printed quotes had never provided — the running total that answered the bride's mother's question, the category variances that prompted the conversation about priorities, the payment due date alerts that prevented the Friday afternoon crisis, and the dashboard that showed the couple, at every moment of the planning process, exactly where they stood.

The wedding budget tracker is not a constraint. The couple who builds it is not choosing to spend less — they are choosing to see clearly what they are spending, so that every choice they make is a genuine choice rather than an accumulation of commitments that has never been assembled into a picture.

The picture, once assembled, makes better choices possible.

Build the tracker before the first vendor call.

Maintain it every Sunday.

Check it before every commitment.

And when the bride's mother asks how much you have actually spent — open the dashboard and show her.

The number will be there. Clearly. Immediately. Exactly.

Published by NRIWedding.com — The Premium Global Platform for Non-Resident Indians Planning Indian Weddings From Abroad.