Budget Guide

Wedding Budget Template Google Sheets: Category Breakdowns, Formulas and Charts

Build a live wedding budget tracker in Google Sheets. Industry-standard category percentages, SUMIF formulas for paid and remaining, and a spending pie chart.

Use Free Budget Tool Instead Full Planner Template

Standard Wedding Budget Category Allocations

These percentages are based on typical US wedding spending patterns. Use them to set category targets before receiving vendor quotes.

Example: $30,000 total budget. Venue allocation at 37% = $11,100 category target.

Column Structure for Your Budget Sheet

These 11 columns capture every dimension of a wedding expense from initial quote to final payment.

ACategory

Text (dropdown)Venue, Catering, Photography...

BVendor / Item

TextThe Grand Ballroom, Main Caterer...

CDescription

TextVenue hire Saturday + Sunday setup

DEstimated Cost

Currency8500

EActual Cost

Currency8750 (once invoice arrives)

FDeposit Amount

Currency2625

GDeposit Paid Date

Date2025-11-15

HBalance Due

Formula =E-F=E2-F2

IBalance Due Date

Date2026-06-01

JPayment Status

Dropdown (Paid/Pending/Not Started)Pending

KNotes

TextIncludes 20% service charge per contract

8 Essential Budget Formulas

These formulas turn a static list of numbers into a live financial dashboard. Copy them directly into your spreadsheet.

=SUM(D:D)

Total estimated budget committedDashboard summary row

=SUM(E:E)

Total actual cost (invoices received)Dashboard summary row

=SUMIF(J:J,"Paid",F:F)

Total deposits already paidDashboard - Paid row

=SUMIF(J:J,"Pending",H:H)

Total balance outstandingDashboard - Outstanding row

=$B$1-SUM(D:D)

Remaining uncommitted budgetDashboard - Available row

=SUMIF(A:A,"Catering",D:D)

Total catering budget committedCategory summary tab

=D2*0.22

Estimated tax + service charge (22%)Each vendor row uplift

=SUMPRODUCT((I2:I200<=TODAY()+30)*(J2:J200="Pending")*(H2:H200))

Payments due in the next 30 daysCash flow warning cell

Create a Budget Pie Chart in 4 Steps

A visual chart makes it immediately obvious if one category is consuming a disproportionate share of the budget.

Create a category summary tableOn a separate tab (or a section of your budget tab), create two columns: Category Name and Total Spent. List all 10 budget categories in column A.

Add SUMIF formulas for each categoryIn column B next to each category, enter =SUMIF(Budget!A:A,"Venue",Budget!D:D). Replace "Venue" with each category name. This pulls the total committed spend per category from your main budget data.

Select the two-column table and insert chartClick the top-left cell of your summary table, drag to select both columns. Go to Insert > Chart. Google Sheets will suggest a pie chart. Accept it.

Customise the chartIn the Chart Editor, change the chart title to "Wedding Budget by Category". Enable data labels and set them to show percentage. Move the chart to a prominent position on the Dashboard tab.

5 Budget Busters to Track in Your Sheet

These are the most common sources of budget overrun for US couples. Add a row for each in the relevant category.

Service charges and tax

Add 20-25% on top of every venue and catering quote. This is the single biggest budget surprise and the easiest to plan for.

Guest count creep

Every additional guest adds approximately $150-200 (food, drink, favour, seating). Budget per-head so you can see the cost impact of adding 10 people.

Vendor gratuities

Plan to tip caterers (15-20% of food bill), photographers ($100-200), hair/makeup ($20-50 per person), DJ ($150-200). Add a gratuity row per vendor.

Alterations and last-minute

Dress alterations ($150-600), day-of emergency kit supplies, replacement items. Add a $500-1000 miscellaneous buffer row in your sheet.

Upgrades after deposit

Lighting upgrades, extra photographer hours, upgraded florals. Track these as separate rows tagged "Upgrade" so you can see scope creep clearly.

Cash Flow Planning: Tracking Deposits vs. Final Payments

Most wedding costs are split: a deposit 9-12 months before, then the balance 4-8 weeks before the wedding. These two dates often land in the same month, creating a major cash crunch. A budget template with payment dates prevents surprises.

Engagement to 12 months outDeposits

25-33% of each vendor's total cost

Venue deposit ($2,000-5,000), photographer deposit ($500-1,500), caterer deposit ($1,500-3,000)

6-9 months outMid-planning payments

Second deposits or progress payments

Some vendors require a second deposit at 6 months. Dress purchase and alterations fall in this window.

4-8 weeks beforeFinal balances

67-75% of all vendor costs due simultaneously

This is the biggest cash flow month. Venue balance, catering balance, and most vendor final payments arrive at once.

Wedding weekCash for tips and incidentals

$500-2,000 in cash or separate payment

Vendor tips, day-of incidentals, marriage licence fee if not paid earlier.

Add a monthly cash flow row to your Dashboard tab:

=SUMPRODUCT((MONTH(I2:I200)=6)*(YEAR(I2:I200)=2026)*(H2:H200))

This formula totals all balance payments due in June 2026. Change the month and year to see any month's expected outflow.

Who Should (and Should Not) See Your Wedding Budget

Sharing the budget with the wrong people creates pressure, unsolicited opinions, and awkward vendor negotiations. Here is a practical sharing guide.

Your partner

Full budget

Complete alignment on spending decisions. Both partners should know every line item.

Wedding planner or coordinator

Full budget

They need to know your real limits to advocate for you in vendor negotiations.

Parents contributing financially

Budget overview only (totals per category)

They should know the overall picture but do not need vendor-by-vendor detail. Protect against micro-managing.

Vendors

Never your total budget

Telling a vendor your budget ceiling means their quote will match it exactly. Share only the category maximum for their service.

Wedding party

Nothing from the budget

Bridesmaids and groomsmen do not need to know budget numbers. Sharing creates unwanted commentary.

Conditional Formatting: Turn Your Budget Into a Visual Dashboard

Colour-coding your budget sheet makes critical information visible at a glance. These four rules take under 10 minutes to set up.

Green row=J2="Paid"

Apply to all rows. Entire row turns green when payment status in column J is "Paid". Immediately shows which vendors are fully settled.

Red cell in Balance Due Date=AND(I2<TODAY(),J2="Pending")

Apply to the Balance Due Date column (I). Turns red when the due date has passed and payment is still pending. Prevents missed payments.

Yellow row for upcoming=AND(I2<=TODAY()+30,J2="Pending")

Apply to all rows. Highlights rows yellow when a balance is due within 30 days and not yet paid. 30-day early warning system.

Orange when over category budget=D2>VLOOKUP(A2,CategoryBudget,2,FALSE)

Requires a category budget reference table. Highlights orange when actual cost exceeds the category allocation. Flags overspend immediately.

Building Your Dashboard Summary Tab

A Dashboard tab pulls key numbers from your Budget tab so you can see your financial position without scrolling through hundreds of rows.

Total Budget

=YourTotalBudgetCell

Link directly to the cell where you entered your total budget. Changing this number updates all downstream calculations.

Total Committed

=SUM(Budget!D:D)

Sum of all estimated costs. Shows how much of the budget is allocated across all vendors and categories.

Total Paid

=SUMIF(Budget!J:J,"Paid",Budget!F:F)

Sum of all deposits for paid vendors plus any fully-paid final balances. Your actual cash outflow to date.

Remaining Uncommitted

=B1-SUM(Budget!D:D)

Budget minus total committed. Shows budget headroom for vendors not yet booked.

Outstanding Balances

=SUMIF(Budget!J:J,"Pending",Budget!H:H)

Total of all final balances still owed. This is the money you need ready in the months before the wedding.

Confirmed Guest Count

=COUNTIF('Guest List'!D:D,"Yes")

Pulls confirmed RSVP count from your Guest List tab. Use this to calculate your actual per-head catering cost.

Sample Budget Allocation: $30,000 Wedding

Seeing the category percentages applied to a real number makes them concrete. Here is what a $30,000 budget looks like distributed across standard categories.

Related Budget and Planning Tools

Full Google Sheets Planner Budget Allocator Tool Excel Template Guide Wedding Cost Calculator All Free Templates

Budget Set. Now Plan the Memories.

Pix Wedding collects every guest photo into one private album with a single QR code. Free to start, no app download required for guests.

Try Photo Sharing Free

Using Your Budget Spreadsheet in Vendor Negotiations

A well-maintained budget spreadsheet is a negotiation tool, not just a tracking tool. Here is how to use it actively to reduce your total wedding cost.

Never reveal your category ceilingVendors will quote to your maximum. When asked for a budget, give a range 15-20% below your actual limit. Your spreadsheet shows your real ceiling privately, not theirs.

Use your spreadsheet to compare quotes side by sideWhen getting quotes from three photographers, enter all three in your Vendors tab with cost, package details, and travel fees. The side-by-side view makes it immediately obvious which offers the best value.

Show vendors your allocation to negotiate packagingIf a vendor is 20% above your category allocation, show them the allocation number (not the total budget). "My photography budget is $3,500 - is there a package that fits that?" is more effective than "you are too expensive".

Track payment dates to negotiate deposit termsYour budget spreadsheet shows cash flow by month. If you have three large deposits due in the same month, you have grounds to ask one vendor to delay their deposit date or split it into two payments.

Use the total committed column to demonstrate loyaltyIf a venue also provides catering, showing the total committed across both services can sometimes unlock a package discount. Your spreadsheet gives you the exact figure to reference.

Step-by-Step: Build Your Wedding Budget Sheet in 20 Minutes

From blank sheet to fully functional wedding budget tracker. Follow these steps in order.

Create a new Google SheetGo to sheets.google.com. Create a blank sheet. Name it "Wedding Budget [Your Names] [Year]".

Add column headers in row 1Category, Vendor/Item, Description, Estimated Cost, Actual Cost, Deposit Amount, Deposit Date, Balance Due, Balance Due Date, Payment Status, Notes. Freeze row 1 (View > Freeze > 1 row).

Format currency columnsSelect columns D, E, F, H. Format > Number > Currency. This ensures all cost entries display as dollar amounts consistently.

Add dropdown to Payment Status (column J)Select all cells in column J. Data > Data validation > Criteria: List of items. Enter: Paid,Pending,Not Started,Overdue. This enables SUMIF formulas to work accurately.

Enter your category rowsAdd one row per vendor or cost item. Group related items (all venue costs together, all catering together). Use consistent category names matching your allocation table.

Create a summary section at the topLeave rows 1-8 blank initially. After entering all vendor rows, use this space for summary formulas: =SUM(D10:D200) for total estimated, =SUMIF(J10:J200,"Paid",F10:F200) for total paid.

Add conditional formattingSelect all data rows. Format > Conditional formatting. Add rule: =J2="Paid" with green fill. Add rule: =AND(I2<TODAY(),J2="Pending") with red fill for overdue payments.

Create the category summary and pie chartOn a new tab called "Summary", list each category and use SUMIF to pull totals. Select the two-column summary, Insert > Chart, and Google Sheets will suggest a pie chart automatically.

The Budget-Only Template vs. the Full Planner

A wedding budget template is a different tool from a full wedding planner spreadsheet. The full planner contains six or more tabs: checklists, vendors, seating charts, timelines. The budget template is focused entirely on money: what you planned to spend, what you have committed to spend, what you have paid, and what you still owe.

This focus matters. Budget decisions happen every week for 12-18 months. Keeping the budget in a dedicated tab (or a separate file) means it is always at the top of the stack, not buried behind the guest list and seating chart tabs.

The structure described on this page can exist as a standalone budget file that you share only with your partner and planner, or as the Budget tab within a larger wedding planner workbook. Either works. The formulas and categories are the same.

•Standalone budget file: share only with partner, easier to protect from family viewing
•Budget tab in full planner: all planning in one file, requires careful tab protection
•Whichever you choose, keep one source of truth. Do not maintain parallel budget files.

Tax, Service Charges, and Hidden Costs

Wedding venues and caterers consistently quote pre-tax, pre-service-charge figures. The actual invoice is typically 20-30% higher. A $120 per head catering quote becomes $150-$156 when you add 18% service charge and 6-8% sales tax.

Build this uplift into your budget template from the start. Add an "Estimated Tax + Service" row within each category. Use a formula: =D5*0.22 (22% is a conservative blended estimate). Your actual invoices will reveal the exact percentages, but planning for 20-25% overhead prevents budget shock when the contract arrives.

Other hidden costs to budget for: wedding coordinator day-of fees, venue parking, shuttle buses, vendor meals (most caterers charge a vendor meal rate), marriage licence fee, honeymoon travel insurance, and a 5-10% miscellaneous buffer for things you did not anticipate.

Explore more free wedding tools

Everything you need to make your wedding day stress-free and unforgettable.

AI Vow Generator

Write "banger" vows in seconds.

Try Tool →

AI Speech Pro

Banger toasts for Best Man & more.

Try Tool →

QR Sticker Designer

Design custom print-ready stickers.

Try Tool →

Seating Chart Planner

Plan your reception seating visually.

Try Tool →

Guest List Manager

Track RSVPs and dietary needs.

Try Tool →

Cost Calculator

Compare wedding costs by city.

Try Tool →

Timeline Builder

Plan your entire wedding day.

Try Tool →

Venues by State

Explore venues across all 50 states.

Try Tool →

Countdown Timer

Count down the days to your big day.

Try Tool →

Hashtag Generator

Create unique wedding hashtags.

Try Tool →

Wedding Checklist

Month-by-month planning checklist.

Try Tool →

Thank You Notes

Generate personalized thank you notes.

Try Tool →

Dress Style Quiz

Find your perfect dress silhouette.

Try Tool →

Invitation Wording

Perfect wording for your invitations.

Try Tool →

How to Collect Guest Photos

5 methods ranked by participation rate and ease.

Try Tool →

Get Photos After the Wedding

Message templates to gather guest photos post-wedding.

Try Tool →

Share Wedding Photos with Guests

Compare every sharing platform by ease and participation.

Try Tool →

Best Way to Get Guest Photos

The single method with the highest participation rate.

Try Tool →

How to Make a Shared Wedding Album

Step-by-step setup for every platform.

Try Tool →

Alternative to Disposable Cameras

Better, cheaper options than disposable cameras.

Try Tool →

Alternative to Wedding Photo Booth

5 cheaper alternatives to a $1,000+ photo booth rental.

Try Tool →

Alternative to Wedding Guest Book

15 creative alternatives guests actually enjoy.

Try Tool →

Alternatives to Hiring a Photographer

Save $2,000+ with these proven photography alternatives.

Try Tool →

Cheap Alternative to Videographer

Capture wedding video without the $2,500 bill.

Try Tool →

Common questions about tracking your wedding budget in Google Sheets

Wedding Budget Google Sheets FAQs

Everything you need to know about our free tools and how they help your wedding day.

Industry averages based on typical US weddings: Venue and rentals 35-40%, Catering and bar 25-30%, Photography and videography 10-12%, Music and entertainment 5-8%, Flowers and decor 8-10%, Wedding attire and beauty 5-8%, Stationery and favours 2-3%, Transportation 2-3%, Officiant and ceremony 1-2%, Miscellaneous/buffer 5%. These are starting points. Couples in major cities typically allocate more to venue; those with large guest lists shift more to catering.

Use =SUMIF(F:F,"Paid",D:D) to total all paid amounts (where F is the payment status column and D is the cost column). For remaining, use =$B$1-SUMIF(F:F,"Paid",D:D) where B1 is your total budget. For pending: =SUMIF(F:F,"Pending",D:D). These three formulas give you a live view of your financial position at any moment.

First, create a summary table with two columns: Category and Total Spent. Use =SUMIF(A:A,"Venue",D:D) in each row to pull totals by category. Select the two-column summary table, then Insert > Chart. Google Sheets will suggest a pie chart automatically. Set the chart title to "Wedding Budget by Category" and enable data labels to show percentages.

At minimum: Category, Vendor/Item, Description, Estimated Cost, Actual Cost, Deposit Amount, Deposit Paid Date, Balance Due, Payment Due Date, Payment Status (Paid/Pending/Not Started), and Notes. That is 11 columns. Add a "Who Booked" column if multiple people are managing vendors.

Yes. Add a row within each category for "Tax + Service Charge" estimated at 20-25% of the pre-tax vendor quote. Catering venues in particular charge 18-22% service on top of per-head food costs. Budget for these uplifts from day one or your actual spend will exceed the budget by thousands of dollars.

They serve different purposes. The Pix Wedding Budget Allocator is better for quickly seeing how to split a total budget across categories with guided suggestions. Google Sheets is better for tracking actual vendor quotes versus estimates over 12-18 months and monitoring what has been paid. Most couples use the Allocator first to set category targets, then build a Sheets tracker for ongoing monitoring.