Hen Do Planner UK – Budget & Cost Splitter Spreadsheet
Plan your hen do budget and split costs between guests in Excel or Google Sheets, with amounts in £. Track deposits and balances, handle different guest packages and a bride-goes-free option, and keep the itinerary together.
Made for UK hen dos, in pounds, for Excel or free Google Sheets. Also included: itinerary, bookings, a countdown to-do list, ready-to-paste group chat messages and printable itinerary cards.
WHAT'S INCLUDED
• Hen do planner spreadsheet (.xlsx) with 10 tabs
• Printables (PDF, A4): itinerary cards (2 per page), packing list, guest info sheet, who's-in-which-room sheet
• Buyer guide (PDF): set-up in 5 minutes, how the split works, FAQ
THE 10 TABS
1. Start Here: quick start and colour key
2. Overview: days to go, guests coming, total cost, cost per person for each package, collected vs outstanding, next supplier payment, next 5 to-dos
3. Guests: up to 40 guests with RSVP, package, room share, dietary needs, and amount due, paid and balance worked out for you
4. Costs & Split: each booking, who shares it, "Include bride?" (default No = the bride goes free), deposits, balances and due dates
5. Payments: log each payment once; balances and an instalment plan update automatically
6. Itinerary: day-by-day plan with times and places
7. Bookings & Contacts: venues, suppliers, booking refs and cancellation dates
8. Bride's Wishes: questions to ask before you book
9. To-Do Countdown: tasks from 16 weeks before to the thank-you message, with due dates worked out from the hen date
10. Group Chat Messages: save the date, deposits, costs, personal and group payment reminders, final details, thank you, all filled in with names, dates and amounts
HOW IT WORKS
1. Download and open the spreadsheet in Excel, or upload it to Google Drive and open with Google Sheets
2. Type the bride's name, dates and destination on the Overview tab
3. Add your guests and costs; choose who shares each cost
4. Log payments as they come in, and copy the ready-made reminders into your group chat
FEATURES
✔ UK wording and £ throughout (hen do, not bachelorette)
✔ "Bride goes free": her share is split across everyone else, cost by cost
✔ Different packages: Full weekend, Saturday only, Night out only, or a custom amount
✔ Optional kitty per guest and optional rounding up to the nearest £5
✔ Instalments: choose 1 to 6, with dates and the amount per guest
✔ Colour-coded balances: amber = still owes, red = still owes after your deadline, green = paid in full
✔ Formulas only, no macros. Locked formula cells (no password) so nothing gets typed over
✔ Fictional example hen included so you can see how it works; easy to clear
COMPATIBLE WITH
• Microsoft Excel (Windows, Mac, Excel for the web)
• Google Sheets (free; upload the .xlsx to Google Drive, instructions included)
• LibreOffice Calc and Apple Numbers (formulas work; colours may look slightly different)
• Printables: any PDF reader, print on A4
PLEASE NOTE
• This is a digital download. No physical item will be sent.
• Your files will be ready to download right after purchase from your confirmation email and download page.
• A computer is easiest for setting up; the Excel and Google Sheets phone apps work for logging payments.
• The planner does the maths from the numbers you type in. Always check amounts before asking anyone to pay.
• If the file is faulty or doesn't open, message me and I'll fix it or refund you.
• Designed by me with help from AI tools; every page checked by hand.
• For personal use only. Please don't share or resell the files.
Questions? Send me a message and I'll get back to you as soon as I can.