Rehearsal Dinner Planner Spreadsheet, Excel & Google Sheets: Guest List, Menu Costs, Cost Split, Toasts

Host the rehearsal dinner with a clear number, not a surprise bill. RSVPs and meal choices feed the menu count, service, tax and tip are worked into an estimated total, and the cost splits between hosts by percentage.

Quick Start: enter the date, price per guest, tax, service, tip and budget once on the Start Here tab, and the all-in cost per guest and how many guests your budget covers fill in automatically.

Made for Microsoft Excel 2019 / 2021 / 365. Also opens in Google Sheets (import instructions included). Instant digital download.

About how it's made: Altar & Agenda designed this rehearsal dinner planner with the help of AI tools (formulas, layout and guide text), then checked and tested every formula before release.

━━━━━━━━━━━━━━━━
WHAT'S INSIDE: 9 CONNECTED TABS
━━━━━━━━━━━━━━━━
♡ Start Here: names, dinner date and time, venue, default price per guest, service charge %, tax % (with or without tax on service), extra tip %, budget and currency
♡ Dashboard: days to go, attending, estimated total, per guest, awaiting RSVP, missing meal choices, budget left, program end time, cost breakdown, hosts' balances, meal counts and dietary needs
♡ Guest List (80): relationship, invited, RSVP, meal choice, dietary needs, notes and a follow-up column
♡ Menu & Costs: up to 6 meal options counted from RSVPs, 12 drinks/extras/fees (per guest or flat), and the estimated total with service, tax and tip
♡ Cost Split: up to 4 hosts by percentage with share, paid, balance and a 100% check
♡ Toasts & Program (25 rows): moments, who and minutes, timed from the dinner start
♡ Checklist: 18 hosting tasks dated back from the dinner (plus blank rows)
♡ FAQ + editable dropdown Lists

━━━━━━━━━━━━━━━━
YOU'LL RECEIVE
━━━━━━━━━━━━━━━━
One .zip file (Rehearsal-Dinner-Planner-Files.zip) containing:
✓ Rehearsal-Dinner-Planner.xlsx: your blank rehearsal dinner planner
✓ Rehearsal-Dinner-Planner-EXAMPLE.xlsx: a filled-in example so you can see how it works
✓ Rehearsal-Dinner-Planner-Setup-Guide.pdf: step-by-step for Excel and Google Sheets import, plus troubleshooting
The setup guide PDF is also included as a separate download.

━━━━━━━━━━━━━━━━
FEATURES
━━━━━━━━━━━━━━━━
• Meal counts for the venue, straight from RSVPs
• Service charge, tax and tip worked into an estimated total
• Percentage cost split between up to 4 hosts
• Automatic calculations. In Excel, formula cells are protected so you can't break them by accident.
• Any currency symbol
• Import into Google Sheets to share with the other hosts

━━━━━━━━━━━━━━━━
HOW IT WORKS
━━━━━━━━━━━━━━━━
1. Purchase and download the files from Etsy (Purchases & Reviews), then unzip.
2. Open the .xlsx in Excel, or import it into Google Sheets: upload it to Google Drive, open it, and choose File → Save as Google Sheets (the guide has step-by-step instructions).
3. Enter the date, venue and your venue's prices and percentages on Start Here, add meal options and guests, then set the hosts' shares.

━━━━━━━━━━━━━━━━
PLANNING THE WEDDING TOO?
━━━━━━━━━━━━━━━━
The Complete Wedding Planner brings budget, payment schedule, guest list & RSVPs, seating, vendors, an auto-dated checklist, a day-of schedule and more into one file (25 tabs). Sold separately in our shop: https://www.etsy.com/listing/4598291905/wedding-planner-spreadsheet-excel-google

━━━━━━━━━━━━━━━━
PLEASE NOTE
━━━━━━━━━━━━━━━━
• This is a DIGITAL DOWNLOAD. No physical item will be shipped.
• Made for Excel 2019 or newer / Microsoft 365. In Excel 2016 or older, the dietary-needs list on the Dashboard shows #NAME?; everything else works.
• Also opens in Google Sheets (free Google account). In Sheets, Excel's cell protection isn't kept, the tab links on Start Here may not jump, and fonts or charts can look slightly different.
• Apple Numbers isn't supported. The download is a .zip, so unzip it on a computer.
• Best used on a computer or tablet.
• Listing images show fictional sample data for illustration. Your planner arrives blank (with the 18 hosting tasks pre-filled).
• For personal use only. Please don't resell or share the files.
• Questions? Message Altar & Agenda through Etsy any time; we're happy to help.