Wedding Budget Spreadsheet

What it does

• Setup tab: your names, wedding date, total budget, guest count, a currency label, and up to 6 people or groups contributing (for example the two of you and each set of parents) with the amount each pledged
• Category targets as a % of your total, with an editable starter split: venue, catering and bar, photography and video, attire, flowers and decor, music and entertainment, stationery, rings, hair and makeup, transport, favours and gifts, honeymoon, other and buffer (rename them or add 2 more)
• Budget tab: up to 200 line items with category drop-down, item, vendor, estimated, quoted and actual (agreed) price, planned cost, deposit paid, paid to date, balance due, next due date, who pays and notes
• Status for every item: Not booked, Booked, Paid in full, or Overdue (a balance with a due date before today, or a status date you choose)
• Payments tab: log every payment after the deposit (date, item, amount, who paid, method). Paid to date on the Budget tab adds them up by itself
• Summary tab: target, estimated, quoted, actual, planned, paid and still to pay for each category, left vs target, and an Under budget, Near limit or Over budget flag in colour
• Dashboard: total budget, planned total, left to allocate, committed, paid so far, still to pay, not booked yet, cost per guest, days to the wedding, categories over budget, overdue balances, the amount due in the next 30 days, a list of up to 8 payments overdue or due soon, contributions by person (pledged, paid, still to give), a target vs planned chart by category and a paid vs still to pay chart
• The tabs are protected without a password, so formulas don't get typed over by accident (you can unprotect them any time)

What you get

• XLSXWedding-Budget-Spreadsheet.xlsx (blank, with the starter categories and split)
• XLSXWedding-Budget-Spreadsheet-with-Sample-Data.xlsx (a filled-in example: a made-up wedding with a 30,000 budget, 36 line items and 3 people contributing)
• PDFQuick-start guide (PDF)

Good for

Engaged couples, brides and grooms to be, and parents or family helping to pay, who want one clear wedding budget with deposits, due dates and who has paid what. Works in any currency (the currency is a label you type).