The Wedding Dashboard: Spend vs Budget, RSVP Progress & Open Payments
This lesson is part of the course
In this lesson
You summarise the payment log into committed spend per category, measure how many guests have replied, total the open payments and chart budget against commitments on one page.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Splitting the Wedding Budget: Shares, Remaining Amounts & Over-Budget Flags Locked
- The Guest List: RSVPs, Plus-Ones & the Catering Headcount Locked
- Cost per Guest: Tiered Catering Prices with XLOOKUP and Bar Package vs Consumption Locked
- Choosing Vendors: a Weighted Scoring Matrix with SUMPRODUCT and RANK.EQ Locked
- The Payment Schedule: Deposits, Due Dates with WORKDAY & EDATE, and What Is Still Open Locked
- Seating: Tables Needed with ROUNDUP, Guests per Table & Empty Seats Locked
- The Savings Plan: Months to Go with DATEDIF and the Monthly Amount with PMT Locked
- The Wedding Dashboard: Spend vs Budget, RSVP Progress & Open Payments Locked