Fraud Blocker
pixPix Wedding
Wedding budget template, Google Sheets

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.

11 columns, from Category to Notes, with an example for each
10 formulas and 4 color rules, each with a copy button
Vendor averages from The Knot 2026 Real Weddings Study
A notebook of wedding costs next to a calculator and two coffees

LINE BY LINE

An engaged couple writing their wedding budget in a notebook next to a laptop and calculator
Emma & JamesBudget night
The short answer

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.

One line in that budget

Guest 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.

Emma & JamesScan to share your photos
9:41

SHARED GALLERY

Emma & James

AllCeremonyMine
First dance
Toast
Cake smash
Table selfie
Bouquet toss
Grandmas dancing
Confetti exit
Getting ready
Sparkler exit
Upload your photosNo app needed
02Starting estimates

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.

Venue & catering50% · $17,100
Reception site, food, bar, rentals, cake
Photography & video12% · $4,104
Photographer, videographer, prints
Decor & flowers10% · $3,420
Florist, lighting, decor
Attire & beauty8% · $2,736
Dress, suit, alterations, hair, makeup
Entertainment8% · $2,736
DJ or band, other entertainment
Planner / coordinator5% · $1,710
Day-of or full planning
Emergency buffer4% · $1,368
Overruns, last-minute fixes
Stationery & misc3% · $1,026
Invitations, officiant, transport, favors
Total100% · $34,200

Bars are scaled so 50% fills the track. Average from The Knot 2026 Real Weddings Study; split from the Budget Allocator.

A wedding photographer shooting the couple laughing at the head table
Photography and video: 12% of the sample, about $4,100.
Estimate as a share of your total
=B1*0.12

Write each estimate as a share of B1 (photography and video here). Change the total once and every line moves with it.

$34,200Average US wedding cost
117Guests on average, per The Knot 2026

The Knot 2026 averages to check each line against

VendorAverage costRow in your sheet
Reception venue$12,900Venue & catering
Catering$80 per guestVenue & catering
Alcohol$2,800Venue & catering
Photographer$3,000Photography & video
Videographer$2,300Photography & video
Flowers$2,800Decor & flowers
Wedding dress$2,100Attire & beauty
Reception DJ$1,800Entertainment
Wedding planner$2,100Planner / coordinator
Transportation$1,100Stationery & misc

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.

03The layout

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.

Wedding budget, Budget tab
CategoryVendor / itemEstimatedActualPaidBalanceDueStatus
Venue & cateringReception venue$17,100$17,600$5,000$12,600May 1Pending
Photography & videoPhotographer$4,104$3,900$1,000$2,900May 15Pending
Decor & flowersFlorist$3,420Not started
Attire & beautyDress + alterations$2,736$2,450$2,450$0Paid
EntertainmentDJ$2,736$1,900$500$1,400May 20Pending
Planner / coordinatorDay-of coordinator$1,710$1,600$400$1,200May 1Pending
Emergency bufferUnassigned$1,368
Stationery & miscInvitations$1,026$780$780$0Paid
Totals$34,200$28,230$10,130$18,100

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.

ColHeaderWhat goes in itExample
ACategoryThe budget line, typed the same way every time so SUMIF can find itVenue & catering
BVendor / itemWho you are paying or what you are buyingReception venue
CDescriptionPackage, hours, guest count the quote assumes6 hours, 120 guests
DEstimated costYour planned number before a quote$17,100
EActual costThe signed contract total, with tax and service$17,600
FPaid so farDeposits and installments paid to date$5,000
GLast payment dateWhen the last money left your accountOct 2, 2026
HBalance dueFormula: actual minus paid=E2-F2
IBalance due dateThe date the vendor needs the restMay 1, 2027
JPayment statusDropdown: Paid, Pending, Not startedPending
KNotesContact, what is included, cancellation termsCake cutting fee waived
04Copy and paste

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$1

Format the cell as a percent. The $ signs keep B1 fixed when you drag down.

Balance per row

Budget tab, H2, drag down
=E2-F2

Actual minus paid. Updates the moment you log a payment.

Service and tax on a quote

Budget tab, a row under the quote
=D2*0.22

Replace 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.

05See it at a glance

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.

Wedding budget by category
Venue & catering 50%Photography & video 12%Decor & flowers 10%Attire & beauty 8%Entertainment 8%Planner / coordinator 5%Emergency buffer 4%Stationery & misc 3%
  1. 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. 2

    Select both columns

    Drag across the category names and their totals, A5:B12.

  3. 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. 4

    Label it

    In the chart editor, Customize, Pie chart, set slice labels to Percentage, and name it Wedding budget by category.

  5. Chart types from Google's chart help, checked November 7, 2026.

06Budget busters

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.

A couple reading vendor quotes at the kitchen table with a spreadsheet open on the laptop
Read every quote for what it leaves out, then add a row for it.

Catering average from The Knot 2026 study via AOL, checked November 7, 2026. To bring that line down, see cheap wedding catering ideas.

07Cash flow

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.

Owed in one month, for example June 2027
=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.

A couple signing a venue contract at a long wooden table
The day a contract is signed, its row gets an Actual cost and a due date.
08Who sees what

How do you share the budget sheet with a partner or planner?

Click Share in the top right of the sheet, add an email and pick a role. Google Drive has three: Viewer, Commenter and Editor.

Your partner

Editor

The full sheet. Both of you change numbers and log payments.

Planner or coordinator

Editor or Commenter

The full sheet, so they know your real limits when talking to vendors.

Parents who are paying

Viewer

Often the Summary tab is enough: category totals, not every vendor.

Vendors

No access

Never share your total. Quote them the number for their line only.

Wedding party

No access

They do not need budget numbers to do their part.

Protect the formulas

Data, Protect sheets and ranges, so only you two can change column H and the Summary tab. Google help

Undo a bad edit

File, Version history shows who changed what and restores an older version. Google help

Roles from Google Drive sharing help, checked November 7, 2026.

09Color rules

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.

10The front page

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.

Total budget
B1

The one number everything else is measured against. Type it once.

Total committed
=SUM(Budget!E2:E200)

Sum of signed contracts.

Paid so far
=SUM(Budget!F2:F200)

Your cash out to date.

Left to assign
=B1-SUM(Budget!D2:D200)

Headroom for vendors you have not booked.

Still owed
=SUMIF(Budget!J2:J200,"Pending",Budget!H2:H200)

Money to have ready before the day.

Confirmed guests
=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.

11Pick the tool

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.

ToolCostSharingOfflineBest for
Google SheetsFree with a Google accountReal-time editing for everyone you invite as an EditorOffline mode once you turn it on in DriveCouples who want their own columns and formulas and want both partners editing live
ExcelExcel for the web is free with a Microsoft account; the desktop app comes with Microsoft 365Co-authoring when the file lives in OneDriveFull offline in the desktop appPeople who already work in Excel or want desktop-only features
A wedding budget appZola, WeddingWire and The Knot budget tools were free when we checked in August 2026Through the app accountDepends on the appCouples who want payment reminders and do not want to keep formulas themselves
A smiling couple at a kitchen table planning on a laptop with a notebook and a wall calendar
Both of you editing the same file is the main reason to pick Sheets.

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.

12Use the numbers

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.

13Start to finish

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. 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. 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. 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. 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. 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. 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. 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. 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.

Watch: a budget sheet built from scratch

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.

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

From Mom

Point your camera

Scan to join the album

No app, no account

9:41

UPLOADING

Saving your moment

9:41

THE ALBUM

Emma & Jack

June 21, 2026

647 photos · 95 guests

AllMomentsMine
Guest photo 1
★
Guest photo 2
Guest photo 4
Guest photo 5
Guest photo 6
Guest photo 7
Guest photo 8
Guest photo 9
Guest photo 10
Add photosShare your moments

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
A couple at a kitchen table at night going over a budget spreadsheet on a laptop
One file, both of you editing, no second copy.

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.

FAQ

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.