Video:Make a Wedding Budget Spreadsheetwith Rachel Edelman
From the DJ's down payment to the florist's fee, there are a lot of details to juggle in a wedding budget. Learn how to create a budget spreadsheet that organizes your finances in one place.See Transcript
Transcript:Make a Wedding Budget SpreadsheetHi, I am Rachel Edelman for About.com. One way to simplify your wedding planning is to keep a wedding budget spreadsheet. In this computer dependent world, it's key to have all of your wedding information and spending records in one place.
Save a Budget SpreadsheetI like use a spreadsheet program like excel for this kind of note keeping. So, first thing to do is save the document on your computer in a safe place. I will just title it Wedding Budget.
Compile a List of Wedding VendorsNext, set up the first column. This should be a list of your vendors. The main vendors that you will likely be starting with are:
- caterer reception
Fill in Wedding Vendor InformationThen name each of the columns based on the kinds of information you will need on each vendor. Start with contact information like:
- company name
- phone number
- contact name
Organize the Wedding Budget DetailsNow fill the rest of the columns with the budget related items. Write in what the total cost will be, what kind of deposit is required and when the deposits are due. Next what the remainder will be and when that is due. Vendors like caterers and florists often need additionally information closer to the wedding that might affect your budget, like guest count and table count. Keep track of this here too. Finally, mark down who is paying each vendor. If you have multiple people helping to pay for your wedding, this column will help you keep track of multiple budgets.
Add in Your Wedding Budget TotalsIf you have an idea of what you would like to try to spend on each of the big ticket items, fill in the Total Cost column so you can get an idea of how to break down your budget. Test a few different numbers so you can see what things you might want to spend more on, and where you want to be more thrifty.
Calculate the Wedding Budget TotalsThe last thing that you want to set up on the spreadsheet is a calculation of your totals. The most important total is for the total cost. You can also keep track of how much each Payee is contributing. You could name these rows:
- Total Bride's Family
- Total Groom's Family
- Total Personal
Remember to Update the Budget SpreadsheetAs you start choosing vendors for your wedding, fill in as much information as you can. Do not forget to save your changes. Setting up the spreadsheet is the first step - adding to it doesn't end until after your wedding.
Hopefully this helps you get started keeping your information organized during this wonderful and busy time. Thanks for watching. To learn more, visit us on the Web at style.about.com.
About videos are made available on an "as is" basis, subject to the User Agreement.