Wedding Budget Template Google Sheets: Copyable Layout

A wedding budget template Google Sheets users can maintain needs separate columns for estimates, agreed totals, payments and balances. Use the copyable layout below to build your own sheet, assign due dates and compare the committed total with your spending limit. The worked figures are examples, not typical wedding prices.

Create the sheet around decisions

Start a new spreadsheet and create a tab named Budget. Put your overall spending limit in cell B1. In row 3, enter the column headings from the table below. Begin individual items in row 4 so your formulas have a consistent starting point.

Use one row per item or contract, not one row per payment. This avoids counting a deposit and the remaining balance as separate purchases. If you need a detailed payment history, keep it on another tab and summarize the amount paid in the main budget.

Copyable column layout

These letters assume the first heading is in column A. Expand the final row in the formulas if your list grows beyond row 200.

Column	Heading	What to enter
A	Category	Venue, food, clothing, photos or another group
B	Item or supplier	A clear name for the purchase
C	Estimated total	Your current estimate before an agreement
D	Agreed total	The full confirmed amount, including known extras
E	Paid to date	Payments already made toward that amount
F	Outstanding	Formula based on D and E
G	Next due date	The next payment deadline
H	Status	Researching, quoted, booked or complete
I	Notes	Inclusions, exclusions and unresolved questions

Formulas you can paste

Enter the balance formula in F4 and copy it down. A blank agreed total remains blank rather than pretending that the estimate is a commitment.

F4: =IF(D4="","",D4-E4)
Total estimated cost: =SUM(C4:C200)
Total committed cost: =SUM(D4:D200)
Total paid: =SUM(E4:E200)
Total outstanding: =SUM(F4:F200)
Uncommitted amount within your limit: =B1-SUM(D4:D200)

Use a simple cross-check after changing formulas

Add two temporary example rows with agreed totals of 100 and 200, and payments of 25 and 50. The committed total should increase by 300, the paid total by 75 and outstanding by 225. Remove the examples after checking. This verifies that your ranges include the intended rows. It does not verify your supplier data, so still compare real entries with the underlying agreements and payment records whenever a figure changes.

Understand what the totals do not say

The uncommitted amount is not necessarily money free to spend. It excludes estimates for items you have not booked. Look at both the full estimated plan and the committed total when deciding whether you can add something. Otherwise a half-booked wedding can appear comfortably under budget while the remaining essentials are still missing.

If an agreed total changes, update the row and note the date. Keep the original agreement in your own files so the spreadsheet is a useful summary rather than the only record. Check the formula range whenever you add rows outside the original area.

A worked example, not a market price

Suppose a fictional supplier's full agreed amount is $1,200 and you have paid $300. Enter 1200 in D4 and 300 in E4; F4 becomes 900. Do not enter the $300 deposit as an additional purchase elsewhere in the committed total.

Estimated	Agreed	Paid	Outstanding
$1,000	$1,200	$300	$900

Keep collaboration deliberate

Share editing access only with people who need to change the budget. Others may only need a summary or a particular task list. Keep bank details, identity documents and sensitive family contributions outside a widely shared planning sheet.

Agree who updates supplier totals and when you review the plan together. Two people editing the same number from different quote versions can make a neat sheet inaccurate. Add a notes column for questions so unresolved decisions remain visible instead of being mistaken for final figures.

Use the sheet to compare scenarios

Create a separate copy or tab for a smaller guest list or simpler package. Change the items that actually vary rather than multiplying the entire wedding budget by a headcount ratio. Some costs are fixed, some vary with guests and others change in steps when you need another table, vehicle or staff member.

Label scenario figures as estimates and keep the booked plan separate. You should be able to tell at a glance whether a number describes a possibility, an agreed commitment or a payment already made.

From PhotosPlease

Collect the pictures that complete the story

Include guest photo collection as its own line if you plan to use it. PhotosPlease can gather photos and videos through a browser upload link, but this article does not insert a fictional product price. Add the actual plan amount only when your commercial terms are confirmed.

See how PhotosPlease works

Questions and answers

Is there a downloadable spreadsheet here?

This page provides a copyable layout and formulas you can enter into your own sheet. It does not claim to host a separate downloadable template file.

Should a deposit be added to the full price?

Usually it is a payment toward the agreed total, so record it under paid to date. Check the contract if the supplier describes a separate booking or administration charge.

How do we track an unbooked item?

Put its current estimate in column C and leave the agreed total blank until confirmed. Mark the status clearly so the estimate is not mistaken for a commitment.

Can both partners edit the sheet?

Yes, with suitable sharing permissions. Agree who updates contract figures and use notes to identify unresolved questions or changed quotes.

Why is the outstanding amount negative?

You may have recorded more paid than agreed, entered a refund incorrectly or used a deposit as an additional purchase. Check the row against actual records.

Can we adapt the formulas to another currency?

The arithmetic stays the same. Format amounts in your chosen currency and keep currencies separate unless you have explicitly converted them using a recorded rate.