How to Make a Wedding Budget in Excel That Tracks Payments
By ExcelReady TeamUpdated 6 min read
The short answer
Make one row per wedding cost with columns for Item, Category, Budget, Cost and Paid. Add a Balance column with =D2-E2 to see what you still owe each supplier. Total each column with SUM, and use SUMIF to total one category, such as everything for the reception. The sheet then shows overspending and payments due at a glance.
Key takeaways
- Keep one row per cost and one column per fact: Budget, Cost, Paid and Balance.
- Balance is simply Cost minus Paid, so =D2-E2 shows what you still owe each supplier.
- SUMIF totals one category, like =SUMIF(B2:B8,"Reception",D2:D8).
- Compare the Cost total with the Budget total to see early if you are over budget.
- Add a due date column so you know which balance has to be paid next.
On this page+
A wedding budget in Excel needs one row per cost and a few columns: what you planned to spend, what the supplier actually charges, and what you have paid so far. With those in place, two short formulas show the balance you still owe and whether you are over budget. This guide is for couples and planners who want a simple sheet that tracks payments, not just a list of prices.
The figures below are made-up examples to show how the formulas work. Use your own quotes and amounts.
What columns does a wedding budget need?#
Five columns cover most weddings: Item, Category, Budget, Cost and Paid. Each column holds one kind of fact, which keeps the formulas simple.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Item | Category | Budget | Cost | Paid |
| 2 | Venue hire | Reception | 6,000 | 6,500 | 3,000 |
| 3 | Catering | Reception | 5,000 | 4,800 | 1,000 |
| 4 | Photographer | Photo | 2,500 | 2,200 | 2,200 |
| 5 | Dress | Attire | 1,500 | 1,650 | 1,650 |
| 6 | Flowers | Decor | 1,200 | 950 | 300 |
| 7 | Band | Reception | 2,000 | 2,400 | 500 |
| 8 | Invitations | Stationery | 400 | 360 | 360 |
- Budget is what you planned to spend before you had quotes.
- Cost is the agreed price from the supplier's quote or contract.
- Paid is the total you have paid that supplier so far, deposits included.
Keep amounts as plain numbers. Typing "6,500 USD" or "approx 6500" turns the cell into text, and SUM skips text. Use Home > Number Format > Currency to show the currency sign instead.
How to track payments and the balance due#
The balance is the cost minus what you have paid. In F1 type Balance, then in F2 type:
=D2-E2Fill it down to row 8 (Windows: Ctrl+D; Mac: ⌘D). Venue hire shows 3,500, because you paid 3,000 of 6,500. The photographer shows 0, so that supplier is fully paid.
When you pay another instalment, update the Paid cell and the balance changes by itself. If you want a history of every payment, keep a second sheet with one row per payment (date, supplier, amount) and total it per supplier with SUMIF. That is the same idea as a petty cash log that records each transaction.
A status column makes the sheet easier to scan. In G2:
=IF(E2>=D2,"Paid in full",IF(E2>0,"Deposit paid","Not paid"))Venue hire shows "Deposit paid" and the dress shows "Paid in full".
How to total the wedding budget with SUM#
Put a Total row under the data and add each column with SUM. In C9 type:
=SUM(C2:C8)Fill it right to E9. On the example data you get:
| Total | Result |
|---|---|
Budget =SUM(C2:C8) | 18,600 |
Cost =SUM(D2:D8) | 18,860 |
Paid =SUM(E2:E8) | 9,010 |
Still to pay =SUM(D2:D8)-SUM(E2:E8) | 9,850 |
The costs are 260 over the plan. To see that as a percentage, divide: =SUM(D2:D8)/SUM(C2:C8) returns about 1.014, which shows as 101% with Percent format. The SUM function guide covers the shortcut too: select the cell below a column and press Alt+= on Windows or ⌘+Shift+T on a Mac.
How to see which costs are over budget#
A Difference column shows which items moved the total. In H1 type Over/Under, and in H2:
=D2-C2A positive number means the item costs more than planned. Venue hire is 500 over, the band is 400 over and the dress is 150 over. Catering is -200, so it came in under budget.
To make the overspends stand out, select H2:H8, go to Home > Conditional Formatting > Highlight Cells Rules > Greater Than, type 0 and pick a red fill. The guide to budget vs actual in Excel shows more ways to report the gap, including a percentage variance.
How to total a wedding budget by category with SUMIF#
SUMIF adds only the rows that match one condition, so it gives you a total per category. The syntax is =SUMIF(range, criteria, sum_range):
=SUMIF(B2:B8,"Reception",D2:D8)This checks the Category column (B2:B8) for "Reception" and adds the matching costs: 6,500 + 4,800 + 2,400 = 13,700. Change the last range to C2:C8 and you get the reception budget, 13,000.
To build a full summary, list each category once in J2:J6 and type this in K2:
=SUMIF($B$2:$B$8,J2,$D$2:$D$8)Fill it down. The $ signs keep the data ranges fixed while J2 changes to J3, J4 and so on. The SUMIF function guide explains each argument, and a pie or bar chart of this summary shows where the money goes.
You can also combine two SUMIFs. The reception balance is the reception cost minus the reception payments:
=SUMIF(B2:B8,"Reception",D2:D8)-SUMIF(B2:B8,"Reception",E2:E8)The result is 9,200, the money still owed to the venue, caterer and band.
How to plan when each payment is due#
Add a Due date column with the date each balance is due, and sort by it so the next payment is at the top (Data > Sort). If you want a monthly view, a SUMIFS on the due dates totals what falls in each month, and the bill tracker guide shows how to flag dates that are close.
A few habits keep the sheet reliable:
- Enter every cost, even small ones. Favours, tips and alterations add up.
- Update the Paid column on the day you pay, and keep receipts in the same folder.
- Freeze the header row (View > Freeze Panes > Freeze Top Row) so the column names stay visible as the list grows.
- Turn the range into a table (Ctrl+T on Windows, ⌘T on a Mac) so new rows are included in your totals.
The same layout works for any big one-off expense. The guides to a monthly household budget and a project budget use the same Budget, Actual and Difference pattern.
Practise it#
A wedding budget is mostly SUM, subtraction and SUMIF. Practise budget formulas in a live spreadsheet to get fast at totals and differences, then practise SUMIF in a live spreadsheet: you type the formula and it checks it instantly. Or try the exercise on this page and work out what you still owe for the reception.
Try it yourself
This is a live spreadsheet. Type the formula in the green cell and press Enter.
How much do you still owe for Reception items? Click G2 and subtract the Reception Paid total (E2:E8) from the Reception Cost total (D2:D8), using SUMIF twice. Press Enter.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Paid | |||||||
| 2 | Reception owed | |||||||
| 3 | ||||||||
| 4 | ||||||||
| 5 | ||||||||
| 6 | ||||||||
| 7 | ||||||||
| 8 | ||||||||
| 9 | ||||||||
| 10 | ||||||||
| 11 |
Tip: Write one SUMIF for the Cost column and one for the Paid column, both checking B2:B8 for Reception, then subtract.
Practise this in a lesson
Frequently asked questions
How do I make a wedding budget spreadsheet in Excel?
List every cost on its own row with columns for Item, Category, Budget, Cost and Paid. Add a Balance column that subtracts Paid from Cost, then total the columns with SUM in a row at the bottom.
How do I track deposits and payments in a wedding budget?
Keep a Paid column with the total you have paid each supplier so far, and a Balance column with =Cost-Paid. When you pay another instalment, add it to the Paid cell and the balance updates.
How do I total wedding costs by category in Excel?
Use SUMIF. For example, =SUMIF(B2:B8,"Reception",D2:D8) adds the cost of every row whose category is Reception. Point the criteria at a cell to build a full category summary.
Is there a wedding budget template in Excel?
Excel offers ready-made templates under File > New, and you can search there for wedding or event budgets. Building your own takes about ten minutes and lets you choose exactly the columns you need.