Coordinate Guest Arrivals, Departures and Agreed Transport

To coordinate how guests get to and from a home party, keep one worksheet with a row for each guest or travelling group. Use a status column that separates what someone asked for from what both sides have actually agreed. Follow one rule: any change to a time or meeting point reopens confirmation. The file format matters less than that structure. One factor decides how much of this you need: whether any guest depends on another person to get there or home. If everyone drives themselves, a simple list of arrival times is enough. The full worksheet is worth the effort once pickups, drop-offs or shared rides are involved, because then two people have to agree on the same time and place.

Choose Word, Excel or PDF based on how often details change

Excel or another spreadsheet: best while plans are still moving. You can sort by arrival window, filter for unconfirmed rows and update one cell without reformatting anything.
Word: suits a one-page printed sheet for the host or a helper, especially when you have only a few arrangements and want room for handwritten notes.
PDF: good for a fixed reference you send to a driver or co-host. It goes out of date as soon as something changes, so put a "last updated" time at the top and send a new copy after each change.
Free option: you don't need a special download. Build the template from the columns below in any word processor or spreadsheet you already use.

What to record for each guest or group

Column	What goes in it	Who provides it
Guest or group	Names of everyone travelling together	Host
Arrival window	The time range the guest gives you	Guest
Arrival method	Driving themselves, being dropped off, pickup requested, or another method the guest names	Guest
Agreed meeting point	A specific location both the guest and the driver have confirmed	Guest and driver
Pickup contact	Who is collecting the guest and how to reach them	Host, after confirmation
Departure window	When the guest expects to leave	Guest
Departure arrangement	How the guest gets home and with whom	Guest and driver
Access request	Only what the guest has told you directly, recorded in their words	Guest
Confirmation status	Requested, proposed or confirmed	Host
Last update	When this row last changed	Host
Notify on change	Everyone who must hear about a change to this row	Host

Every entry here comes from a guest, a driver or you. Nothing is calculated, so if a guest hasn't given you a detail, leave the cell blank. Don't fill it with a guess about when they'll arrive, whether a driver has room or whether someone is free. A blank cell shows exactly what you still need to ask, and an assumption hides it.

To start a spreadsheet, paste this header row into the first row and split it into columns on the commas. In Word, insert a table with eleven columns and use the same labels.

Guest or group,Arrival window,Arrival method,Agreed meeting point,Pickup contact,Departure window,Departure arrangement,Access request,Confirmation status,Last update,Notify on change

Move each arrangement from requested to confirmed

1. Record the request as the guest stated it and mark it "requested."
2. When someone offers to cover it, such as a friend who can drive, add their name and mark the row "proposed."
3. Ask the guest and the driver to each confirm four things: the time, the exact meeting point, who is travelling and any access needs the guest has stated.
4. Mark the row "confirmed" only after both sides have agreed to the same details. Note when they did in the Last update column.
5. Add booking or service details, such as a car service reservation, only after you've checked them with the service or with the person who made the booking.

Departures need the same steps as arrivals. They are easy to leave vague because they feel far off while you're planning. A row with a confirmed arrival and a blank departure arrangement is still an open item.

When a time or meeting point changes

Contact both sides of the arrangement, not just the person who told you about the change.
Replace the old detail rather than keeping both versions in the row, so no one reads an outdated time.
Set the status back to "proposed" until both people acknowledge the new details, then mark it confirmed again and update the timestamp.
Use the Notify on change column to check that everyone affected has heard, including a co-host who is expecting that guest.
If the change affects the party itself, such as holding a course or moving a welcome, note it on your party-day run sheet. Keep this worksheet focused on transport commitments.

An illustrative example

In this hypothetical case, Lee says they'll arrive at 6:10 p.m. and asks for a pickup. Pat offers to collect them, so the row says "proposed." It changes to "confirmed" only when both Lee and Pat agree on the named pickup point and the 6:10 time. Later, Lee says they'll now arrive at 6:35. The original agreement doesn't cover the new time. You replace 6:10 with 6:35, set the status back to "proposed" and contact Pat. Once both Lee and Pat acknowledge the new time, you mark the row confirmed again.

Keep contact and access details limited

Phone numbers, meeting points and access requests are personal details. Share each one only with the people assigned to that arrangement. If you send a single PDF or printout to a whole group of drivers or helpers, remove the contact and access columns first, or send each person only the rows that involve them.