Wedding Budget: Track Who Pays for What in a Spreadsheet
These days there is no single rule for who pays for a wedding. Some couples pay for everything, some families contribute a lump sum, and some cover specific items like the venue or the dress. Whatever you agree, the money gets confusing fast unless it is written down. A contributions tab in your wedding budget spreadsheet fixes that.
The columns you need
Create a tab called Contributions with these columns:
- Contributor (you, your partner, each set of parents, grandparents)
- Pledged (the amount they said they would give)
- Earmarked for (a specific item such as catering, or "anything")
- Conditions or timing (for example "after the house sale")
- Received (what has actually arrived)
- Still to come (a formula:
=B2-E2)
Three formulas that show the real picture
Total pledged: =SUM(B2:B10)
Total received: =SUM(E2:E10)
Funding gap against your budget: =Budget!B1-SUM(B2:B10), where Budget!B1 is your overall wedding budget. A positive number is what nobody has agreed to cover yet.
To see how much is earmarked for a single category, use =SUMIF(C2:C10,"Catering",B2:B10).
Plan on what is confirmed
A sensible habit is to plan your spending on confirmed money only, then treat anything extra as a bonus that can fund upgrades. Keep a separate column for "maybe" amounts so uncertain pledges are visible but not counted in your funding gap.
Have the conversation early
Money equals expectations for some families, so it helps to write down what each contribution is for and when it will arrive. A shared sheet makes that a neutral document rather than a negotiation. Share it with view-only access for relatives who just want to see where things stand.
Link contributions to your vendor deposits
Deposits and balances often fall due before all the contributions have arrived. Put due dates next to your vendor lines and compare them against the "Received" total, so you know when you will need to cover a gap from your own savings.
Skip the build
The GridX Wedding Budget Planner comes with four colour themes in Google Sheets and Excel. Here is the Etsy listing. For general budget-building, see our guide to budgeting in Google Sheets.
Frequently asked questions
Who pays for the wedding?
There is no universal rule today. Traditions vary by family and culture, and many couples now pay themselves or split costs with relatives. What matters is agreeing the amounts early and writing them down.
How do I track family contributions to a wedding budget?
Add a contributions tab with the contributor, pledged amount, what it is for, timing and amount received, then compare total pledged against your overall budget to find the funding gap.
Should I count promised money in my budget?
It is safer to plan around confirmed contributions and treat uncertain ones as a bonus until the money has arrived.
Free Habit Tracker for Google Sheets
Money habits stick when you track them daily. Get the free 2027 Habit Tracker, a calm Google Sheet you copy into your own Drive.
By signing up, you agree to receive your free tracker and occasional emails from The GridX Studio. Unsubscribe any time. Privacy PolicyRelated guides
- Split Bills by Income: A Partner Expense Calculator in Google Sheets
- Budgeting as a Couple When One or Both of You Have ADHD
- How to Make a Budget in Google Sheets (Step by Step)
Planner that goes with this guide: Wedding Budget Planner. All guides
GridX Studio planners and Google Sheets budgets are one-time purchases with no subscription.
See the Etsy shop