How to make a wedding budget spreadsheet in Google Sheets
The full column layout, every formula ready to copy, color rules that flag overspending and a $34,200 sample split built on The Knot's 2026 average.

LINE BY LINE

How to create a wedding budget in Google Sheets
Open a blank Google Sheet and add a Budget tab with columns for category, vendor, estimated cost, actual cost, paid so far, balance due, due date and status. Give every vendor a row, add SUM and SUMIF totals on a Summary tab, color overspending in orange, and share the file with your partner as an editor.
Menu paths from Google's conditional formatting help and dropdown help, checked November 7, 2026.
Most people arrive here with one request: help me create a wedding budget spreadsheet. The three cards below are that request, in the order to do it.
1. Set up the columns
Eleven headers in row 1, frozen, with a Paid, Pending, Not started dropdown in the status column.
Jump to it2. Paste the formulas
Balance per row, then totals for estimated, committed, paid, owed and left to assign.
Jump to it3. Split your total
Start each category at a share of your total, then swap in real quotes as they come.
Jump to itGuest photos, sorted.
One QR code, one album.
On the day, guests scan a QR code and add their photos to one shared album from the phone browser. No app and no account, on iPhone or Android.
SHARED GALLERY
Emma & James









How should a $34,200 wedding budget be split?
Wedding budget percentages are a starting point for the Estimated cost column, not a rule. Here is the Pix Wedding Budget Allocator’s default split applied to The Knot’s 2026 national average. The eight lines add up to the full total.
Bars are scaled so 50% fills the track. Average from The Knot 2026 Real Weddings Study; split from the Budget Allocator.

=B1*0.12Write each estimate as a share of B1 (photography and video here). Change the total once and every line moves with it.
The Knot 2026 averages to check each line against
| Vendor | Average cost | Row in your sheet |
|---|---|---|
| Reception venue | $12,900 | Venue & catering |
| Catering | $80 per guest | Venue & catering |
| Alcohol | $2,800 | Venue & catering |
| Photographer | $3,000 | Photography & video |
| Videographer | $2,300 | Photography & video |
| Flowers | $2,800 | Decor & flowers |
| Wedding dress | $2,100 | Attire & beauty |
| Reception DJ | $1,800 | Entertainment |
| Wedding planner | $2,100 | Planner / coordinator |
| Transportation | $1,100 | Stationery & misc |
Reception venue
Catering
Alcohol
Photographer
Videographer
Flowers
Wedding dress
Reception DJ
Wedding planner
Transportation
Source: The Knot 2026 Real Weddings Study, as listed in AOL's roundup of the study (April 29, 2026), checked November 7, 2026. Averages are per couple who hired that vendor, so they do not add up to $34,200.
Wedding budget template Google Sheets layout: the 11 columns
Any wedding budget Google Sheet template worth copying has these columns, whatever the colors. Row 1 holds the headers, every vendor or purchase gets its own row below.
Illustrative numbers. Green rows are paid, the orange cell is over its estimate. On phones the mockup shows four of the columns; all 11 are listed below.
| Col | Header | What goes in it | Example |
|---|---|---|---|
| A | Category | The budget line, typed the same way every time so SUMIF can find it | Venue & catering |
| B | Vendor / item | Who you are paying or what you are buying | Reception venue |
| C | Description | Package, hours, guest count the quote assumes | 6 hours, 120 guests |
| D | Estimated cost | Your planned number before a quote | $17,100 |
| E | Actual cost | The signed contract total, with tax and service | $17,600 |
| F | Paid so far | Deposits and installments paid to date | $5,000 |
| G | Last payment date | When the last money left your account | Oct 2, 2026 |
| H | Balance due | Formula: actual minus paid | =E2-F2 |
| I | Balance due date | The date the vendor needs the rest | May 1, 2027 |
| J | Payment status | Dropdown: Paid, Pending, Not started | Pending |
| K | Notes | Contact, what is included, cancellation terms | Cake cutting fee waived |
A Category
B Vendor / item
C Description
D Estimated cost
E Actual cost
F Paid so far
G Last payment date
H Balance due
I Balance due date
J Payment status
K Notes
Which formulas does a wedding budget spreadsheet need?
Most searches for how to make budget sheet totals update on their own end at two functions, SUM and SUMIF. They assume the Budget tab layout above and a Summary tab with your total in B1.
Total estimated
Summary tab=SUM(Budget!D2:D200)Adds every planned number. Compare it to your total in B1.
Left to assign
Summary tab=B1-SUM(Budget!D2:D200)Your total minus all estimates. Below zero means the plan is already over.
Total committed
Summary tab=SUM(Budget!E2:E200)What the signed contracts add up to so far.
Paid so far
Summary tab=SUM(Budget!F2:F200)Cash that has left your account.
Still owed to pending vendors
Summary tab=SUMIF(Budget!J2:J200,"Pending",Budget!H2:H200)Balances on every row marked Pending.
One category
Summary tab=SUMIF(Budget!A2:A200,"Venue & catering",Budget!E2:E200)Swap the category name to total any line. It must match column A exactly.
Percent of total
Summary tab, next to a category total=B5/$B$1Format the cell as a percent. The $ signs keep B1 fixed when you drag down.
Balance per row
Budget tab, H2, drag down=E2-F2Actual minus paid. Updates the moment you log a payment.
Service and tax on a quote
Budget tab, a row under the quote=D2*0.22Replace 0.22 with the service charge plus tax rate in your contract.
Due in the next 30 days
Summary tab=SUMPRODUCT((Budget!I2:I200<>"")*(Budget!I2:I200<=TODAY()+30)*(Budget!J2:J200<>"Paid")*Budget!H2:H200)Unpaid balances due within 30 days, overdue ones included.
Function reference: SUMIF in Google's help center, checked November 7, 2026. Ranges stop at row 200; raise the number if your list is longer.
How to add a wedding budget pie chart
A pie chart shows in one look which category eats the budget. It reads from a small category table on the Summary tab, so it updates as your totals change.
- 1
Build a category table
On the Summary tab, list the eight categories in A5:A12 and total each one with SUMIF in column B.
- 2
Select both columns
Drag across the category names and their totals, A5:B12.
- 3
Insert the chart
Go to Insert, then Chart. Sheets often suggests a pie for one label column and one number column; if not, pick Pie chart in the editor.
- 4
Label it
In the chart editor, Customize, Pie chart, set slice labels to Percentage, and name it Wedding budget by category.
Chart types from Google's chart help, checked November 7, 2026.
Which wedding costs do budget templates leave out?
A blank template only holds what you think to type in. These six are the rows people add late, so add them on day one.
Service charges and tax
Venue and catering quotes are often per person before the service charge and sales tax. Ask every caterer for the all-in number and put that in Actual cost.
Guest count creep
At The Knot 2026 average of $80 per guest, catering alone moves with every name. Keep a per-guest cost on the Summary tab so the list and the budget stay linked.
Vendor tips
Tips are rarely in a contract. Give them their own rows under each category, decided early, so they are not paid from the buffer on the day.
Alterations and small fixes
Dress alterations, a day-of kit, replacement items. Small on their own, real money together. They belong in Attire or Misc, not in your head.
Upgrades after the deposit
Extra photo hours, better lighting, a bigger floral arch. Log each one as a new row tagged Upgrade so you can see what the add-ons cost in total.
Postage, license, delivery
Stamps for invitations, the marriage license fee, delivery and setup charges from rental companies. Easy to forget, so give each one a row.

Catering average from The Knot 2026 study via AOL, checked November 7, 2026. To bring that line down, see cheap wedding catering ideas.
How do you track deposits and due dates?
Columns F to J turn the sheet into a payment calendar. Log each payment as it happens and the balance and the color rules do the rest.
At booking
Deposit row filled: Actual cost, Paid so far, Last payment date. Status turns Pending.
Middle months
Installments raise Paid so far. Balance due shrinks on its own through the H formula.
Final weeks
The 30-day formula and the yellow rule show every balance you need ready.
After the wedding
Tips, overtime and returns logged. Status Paid on every row, then compare Actual to Estimated.
=SUMIFS(Budget!H2:H200,Budget!I2:I200,">="&DATE(2027,6,1),Budget!I2:I200,"<"&DATE(2027,7,1))Copy it for each month before the wedding to see which months are heavy.

How do you flag overspending in Google Sheets?
Select the range, then Format, Conditional formatting, and under Format cells if pick Custom formula is. Sheets checks rules from the top of the list and the first true one sets the color, so keep Overdue first.
1. Overdue
A2:K200=AND($I2<>"",$I2<TODAY(),$J2<>"Paid")A due date has passed and the row is not paid. Put this rule first.
2. Due within 30 days
A2:K200=AND($I2<>"",$I2<=TODAY()+30,$J2<>"Paid")Money you need ready this month.
3. Paid
A2:K200=$J2="Paid"Done rows fade into green so open ones stand out.
4. Over estimate
E2:E200=AND($E2<>"",$E2>$D2)The signed cost beat the plan. This is your overspend flag.
Rule order and menu path from Google's conditional formatting help, checked November 7, 2026. The $ before a column letter keeps each rule reading the right column on every cell of the row.
What goes on the summary tab?
Six numbers answer every money question before a vendor meeting. Put them at the top of the Summary tab, above the category table and the pie chart.
B1The one number everything else is measured against. Type it once.
=SUM(Budget!E2:E200)Sum of signed contracts.
=SUM(Budget!F2:F200)Your cash out to date.
=B1-SUM(Budget!D2:D200)Headroom for vendors you have not booked.
=SUMIF(Budget!J2:J200,"Pending",Budget!H2:H200)Money to have ready before the day.
=COUNTIF('Guest List'!D:D,"Yes")Pulled from a Guest List tab, for your cost per guest.
Freeze the top rows
Select the last summary row, then View, Freeze, Up to current row. The six numbers stay on screen while you scroll the category table.
Google Sheets, Excel or a budget app?
All three can hold the same budget. The difference is who edits it, where, and whether you want to keep formulas yourself or let a free wedding budget tracker do it.
| Tool | Cost | Sharing | Offline | Best for |
|---|---|---|---|---|
| Google Sheets | Free with a Google account | Real-time editing for everyone you invite as an Editor | Offline mode once you turn it on in Drive | Couples who want their own columns and formulas and want both partners editing live |
| Excel | Excel for the web is free with a Microsoft account; the desktop app comes with Microsoft 365 | Co-authoring when the file lives in OneDrive | Full offline in the desktop app | People who already work in Excel or want desktop-only features |
| A wedding budget app | Zola, WeddingWire and The Knot budget tools were free when we checked in August 2026 | Through the app account | Depends on the app | Couples who want payment reminders and do not want to keep formulas themselves |
Google Sheets
Excel
A wedding budget app

Moving between them
A Google Sheet downloads as an Excel file (File, Download, Microsoft Excel) and an Excel file opens in Sheets, so the choice is not permanent. The formulas on this page work in both. Apps do not import a spreadsheet the same way, so moving into an app usually means typing the vendors in again.
Sources: Sheets offline help, Excel for the web on OneDrive, app prices from our wedding budget apps comparison, checked November 7, 2026.
How do you bring a line back under budget?
A sheet that is up to date is also your best tool with vendors. Five ways to use it when a quote comes in high.
1. Keep your ceiling private
When a vendor asks for your budget, give the number for their line only, never the total. The sheet holds the real limit.
2. Compare quotes side by side
Put three photographer quotes on three rows with hours, extras and travel in Description. The cheapest line is not always the best value, but the sheet makes it obvious.
3. Ask for a package that fits the line
If a quote is over your category, show the line amount and ask what fits it: fewer hours, one shooter, a smaller album.
4. Spread out the deposits
If the 30-day formula shows three big payments in one month, ask one vendor to move a date or split a payment.
5. Bundle where one vendor does two jobs
If the venue also caters, ask for one combined quote. The Category totals show what you would spend with two vendors.
How to make a budget sheet for your wedding, step by step
Eight steps from a blank file to a shared sheet with totals, color rules and a chart. The same steps work for any budget sheet; only the categories change.
- 1
Agree on one total and who pays
Add your savings, what you can put aside before the date and any money family has offered as a fixed amount. Type that total into B1 on a tab named Summary.
- 2
Create the tabs
Rename the first tab Budget and add Summary. Add Guest List if you want cost per guest. One file, one source of truth.
- 3
Add the 11 column headers and freeze row 1
Type Category, Vendor / item, Description, Estimated cost, Actual cost, Paid so far, Last payment date, Balance due, Balance due date, Payment status and Notes in A1 to K1. Then View, Freeze, 1 row.
- 4
Add the status dropdown
Select J2:J200, then Insert, Dropdown (or Data, Data validation, Add rule) and enter Paid, Pending and Not started.
- 5
Fill in estimates from a split of your total
Start each category at a share of B1, for example half for venue and catering, then replace estimates with quotes as they arrive.
- 6
Paste the formulas
Put =E2-F2 in H2 and drag it down. On Summary, add the totals: estimated, committed, paid, still owed and left to assign.
- 7
Add the color rules
Select A2:K200, then Format, Conditional formatting, Custom formula is, and add the overdue, due soon and paid rules. Add the over estimate rule on E2:E200.
- 8
Share it and add the chart
Click Share, add your partner as Editor, then build the category pie chart from the Summary table with Insert, Chart.
Sheet Studio builds a wedding budget planner in Google Sheets from a blank file, from the categories to expense tracking. Pause it at each step and copy the formulas from this page.
Video by Sheet Studio on YouTube, 23:54, uploaded February 2026.
Need a number first?
The free Budget Allocator splits any total into eight categories, and the Google Sheet wedding planner template adds the checklist, guest and vendor tabs around this budget.

First dance
You guys!!
One budget row that collects every guest photo
Guests scan one QR code and upload from the phone browser, no app or account. Start on the free tier of 20 guest uploads; paid plans are one-time, from $44.

From Mom
Scan to join the album
No app, no account
UPLOADING
Saving your moment
THE ALBUM
Emma & Jack
June 21, 2026
647 photos · 95 guests









SCAN TO TRY
pix.wedding/
your-wedding
A budget-only sheet or a full wedding planner?
A wedding budget sheet tracks money only: what you planned, what you signed, what you paid and what you still owe. A full wedding planner workbook adds tabs for the checklist, vendors, guests, seating and the day-of timeline.
Either way works. The budget can live as its own file you share with your partner and planner, or as the Budget tab inside a bigger planner. The columns and formulas on this page work in both.
- Own file: easier to keep away from family who should only see totals
- Tab in a full planner: everything in one place, protect the budget tab
- Whichever you pick, keep one source of truth, never two copies

Tax, service charges and other costs a quote leaves out
Venues and caterers often quote before the service charge and sales tax. Put the contract total in Actual cost, or add a row for the extra using =D2 times the rate in your contract, so the sheet shows what the invoice will say.
Other easy misses: day-of coordinator fees, parking and shuttles, meals for vendors working the reception, the marriage license fee and a buffer line for what nobody saw coming.
Wedding budget spreadsheet questions
Straight answers to the questions people ask most about this topic.
Start from what you can pay, not from an average: savings, what you can save before the date and fixed amounts from family. Split that total into categories, then check each line against real numbers. The Knot 2026 Real Weddings Study puts the average US wedding at $34,200 with about 117 guests, a photographer at $3,000 and catering at $80 per guest. Keep a buffer line for overruns.
Google Sheets has a template gallery under File, New, From template gallery, and many wedding sites share their own files. This page does not hand you a file; it gives the full 11-column layout, every formula and the color rules, so you can build a sheet that fits your wedding instead of someone else’s.
Put =E2-F2 in the Balance due column (actual cost minus paid so far) and drag it down. On the Summary tab, =SUM(Budget!F2:F200) gives what you have paid and =SUMIF(Budget!J2:J200,"Pending",Budget!H2:H200) gives what you still owe. =B1-SUM(Budget!D2:D200) shows what is left to assign.
Eleven covers it: Category, Vendor or item, Description, Estimated cost, Actual cost, Paid so far, Last payment date, Balance due, Balance due date, Payment status and Notes. Fewer works for a small wedding, but keep Estimated, Actual, Paid and Due date, since those four drive every formula.
Yes, or put the all-in number in Actual cost. Venue and catering quotes are often given per person before the service charge and sales tax, so a sheet that only holds the base quote looks healthier than it is. A row with =D2 times your contract rate keeps the extra visible.
Both, in that order of time. The free Budget Allocator on Pix Wedding splits a total into eight categories in seconds, which gives you the starting estimates. The Google Sheet is where you then track every vendor, payment and due date for the months until the wedding.
Explore more free wedding tools
Everything you need to make your wedding day stress-free and unforgettable.
Cost Calculator
Compare wedding costs by city.
Budget Allocator
Turn your total into a category-by-category plan.
Courthouse Wedding Cost
Real fees by county and what to expect.
Photo Sharing QR
The best way to collect guest photos.
Wedding Checklist
Month-by-month planning checklist.
AI Vow Generator
Write "banger" vows in seconds.
AI Speech Pro
Banger toasts for Best Man & more.