How to Use the Savvy Wedding Budget
by Janet Dagostino, Savvy Spreadsheets
Here are detailed instructions for how to use the Savvy Wedding Budget, our ultimate, customizable wedding budget template.
Setting up your Budget
It takes five steps to set up the Savvy Wedding Budget.
Step 1: Enable your macros. For details on how to do this, check out this FAQ.
Step 2: Enter your estimated total wedding budget under the Budget Target section.
Step 3: Enter your budget categories and subcategories. Use the examples or type over them with your own.
Use the signs on the left-hand side of the template to add, delete, or move rows. To add a category (or subcategory), place your cursor on a category (or subcategory) and click the PLUS SIGN. A new row will appear underneath. To remove a category (or subcategory), place your cursor on the category (or subcategory) and click the MINUS SIGN. To move a category (or subcategory) up or down, place your cursor on the category (or subcategory) and click the UP or DOWN ARROWS.
Step 4: Enter an estimated budget percentage next to each category. Make sure these percentages add up to 100% in cell E12.
The category’s budget target will be calculated based on this percentage.
Step 5: Enter a budget amount for each subcategory. Try to add up to the category’s target budget.
At this point, the Projected Amount column will equal the Budget Amount column.
Tracking your Expenses
Now that your budget is set up, start tracking your expenses.
As soon as an amount for a subcategory is confirmed, enter it in the Actual Amount column.
The Projected column will update as you start entering actuals. The Projected amount equals the Actual amount for confirmed costs, and equals the Budget amount for unconfirmed costs. Be sure to check this column regularly as you enter actuals, to see if you are projected to come in under or over budget.
If any of these are payable in stages (i.e. there is an initial deposit) you can use the Paid column to keep track of how much you owe. Enter what you’ve paid so far under the Paid column, and your remaining Amount Due will calculate.
Use the notes section to track details about your budget.
That’s it! Just keep track of your expenses and try to stay within budget
Have an unanswered question? Feel free to post it in the comments below!