Skip to content

Wedding Budget & Planning Spreadsheet

I created this Wedding Budget Spreadsheet when I was planning my wedding back in 2022!  This allowed me to stay organized and most importantly, to stay on budget!

This sheet consists of 7 tabs.  There is a video below that demonstrates how to fill it out, as well as step by step instructions!

Tab One: Planner

The planner tab is simple! Just fill in the Bride’s name, the Groom’s name and the Wedding date.  Filling in this section will allow the other tabs to auto populate with the necessary information, so don’t skip this step! 

Tab Two: Checklist

This tab will allow you to build out your to-do’s! You can organize the wedding checklist items by how soon before the wedding they need to be completed.  

On this tab you will also assign a priority to each item to help stay organized! 

The top section of this tab will assist with tracking what has been completed and what still needs to be done. 

Tab Three: Guest List

On this tab, you will build out your guest list, determine table assignments and keep track of each attendee’s information.  The top section will provide a summary of the guest list info!

Please note, if you try to seat more than 10 people at one table, the spreadsheet will highlight that table in red.  Should you have a table that holds more than 10 people, I recommend you use two tables as a ‘part 1’ and ‘part 2’.  Otherwise, the guest’s information will not pull into the next tab. 

Tab Four: Table Assignments

This tab will automatically populate based on your inputs from the pervious tab.  The only information you will need to enter is how many seats there are per table.  This way, if your tables hold 8 people but you assigned 10 to the table, the excel will highlight red.  This will also help track how many available seats there are per table. 

Additionally, if you want to rename the tables you can do that here.  (i.e. ‘Sweetheart table’, ‘Bride’s family’, etc.).  Once it is updated in Column Q, it will update everywhere else in the sheet. 

Please rename the tables before making assignments in tab 3.  Otherwise you will have to correct the table assignments. 

As noted above, if you try and seat more than 10 people per table, all of the guests will not be pulled into this tab.  Should you have a table that seats more than 10 people, you can create a ‘part 1’ and ‘part 2’ but overwriting the table names, as shown below! 

Tab Five: Budget

This tab allows you to track budgeted costs and compare to actuals! It also allows you to track what has been paid, what is outstanding and when it is due. 

First, enter the category, the person responsible for payment.  Then enter the amount budgeted, the actual cost and any payments to date! 

Tab Six: Vendors

This tab provides a location to enter your vendors! It also keeps track of if the vendors  have been booked and any notes needed.  The spreadsheet is pre-populated with common vendor types but should you not need a particular vendor just overwrite the top row of that vendor box. 

Tab Seven: Venue Comparison

Finally, the last tab can be utilized to compare different venue options. It allows for a comparison of General Info as well as costs. 

This tab is pre-populated with common ‘General Info’ and common ‘Payment / Fees’.  Should you not need a particular row you can overwrite the Description. 

Related Post

Spread the love

Leave a Reply

Your email address will not be published. Required fields are marked *