- hickoryhills
- 2 years ago
- Wedding: November 2019 - City, State
(Also, WELL DONE on the Flying Biscuit. My family is from Atlanta and we love that place, lol)
You could have a budget column, and an actual column, then a third column which is “spend allocated” where if the actual is blank, it fills it with the budget, if actual has a figure in it shows that figure instead. Then sum up your allocated column, and take it away from your budget to show a headline figure and conditional format it red for overspend/green for underspend?
Assuming budget was column B and actual was column C, the formula for the allocated in column D would be
=IF(isblank(c2),B2,C2)
Then =SUM(D:D) to show “allocated spend” and (budget figure) – (allocated total). I’m not sure if my description makes sense 😂
I LOVE the app ‘wedding plans’. It has a ring in a box as the icon. Also has an iPad version.
It seemed kind of out dated at first but it works so well! There is a budget and a vendor function. I listed everything in budget to get a running total (in the beginning I would estimate expenses and then put in actual prices- making sure to label actual versus estimate) and then copy an expense to vendor once booked. Vendors shows the outstanding amount which is useful for deposits and installments. My budget shows expenses that haven’t been booked, which helps because I consider that flexible spending and can adjust accordingly
You can find some free guides from weddings website the knot wedding wire etc on how much of your budget they suggest for each area. Check out barns and nobles for some wedding planners or even amazon. But definitely call around prices really vary depending on where you live and your area. I also made an excel sheet to keep track of what I paid for deposits on photographer vendors etc. but I found it hard to price venues because they all had their own preferred vendor lists. Excel or pages will have some basic spreadsheets that you can play around with. Try asking some friends if they are good with excel or pages maybe they can help you create something.
I used google docs. What we did was set a budget, and then prioritized ourselves what was important, and decided what the maximum amount we were willing to spend on each thing to come to that final number. Then the next column was how much we actually paid. From there, I was able to make adjustments-so when my dress was $800 less than I budgeted, I was able to get the more expensive veil that I wanted even though it was over my initial budget.
You didn’t specifically say this, but I assume you are talking about your wedding budget? The knot has a really good wedding budget tool. You put in your total budget, and it tells you exactly how much you can spend on each item to stay within budget. You can then adjust the recommended budget to fit what you actually spend. For example, maybe you want to spend 3K on your wedding dress instead of 1.5K, you can enter that in and then figure out where to cut back.
I found it incredibly helpful, for budgeting and for planning what to do next. Good luck and congratulations!
https://www.theknot.com/wedding-budget/start?member_exists=false