Skip to content

AI assistant

TemplatesTravel & outings · Rooms and cars

Group trip rooms and cars

When you split up rooms and cars for a workshop, team outing or club trip and keep dues and participants in one place

What's inside · Table 3 · Checklist 4 · Expense split 1

Preview · a new document starts like this

Group trip rooms and cars

Departure date
Not set
Return date
Not set
Treasurer
Not set
People
Not set
Dues per person
Not set

Adjust the room assignment table to fit your lodging, then send the participant table with an ‘Edit without signing in’ link.

Room assignments

List the rooms and their capacity, and match the number of people assigned. If you rename a room, rename the ‘Room’ options in the participant table to match.

RoomTypeLabelsCapacityNumberAssignedNumberConfirmedCheckbox
Room ARoom for 220Unchecked
Room BRoom for 440Unchecked
Room CRoom for 440Unchecked
Room DDorm room80Unchecked
Row 1
Room
Room A
Type
Room for 2
Capacity
2
Assigned
0
Confirmed
Unchecked
Row 2
Room
Room B
Type
Room for 4
Capacity
4
Assigned
0
Confirmed
Unchecked
Row 3
Room
Room C
Type
Room for 4
Capacity
4
Assigned
0
Confirmed
Unchecked
Row 4
Room
Room D
Type
Dorm room
Capacity
8
Assigned
0
Confirmed
Unchecked

Car assignments

Write the driver, number of seats, and the departure point and time.

CarDriverAssigneeSeatsNumberDeparture pointDeparts atDateConfirmedCheckbox
Car 1Empty4Outside the officeEmptyUnchecked
Car 2Empty4Station plazaEmptyUnchecked
Car 3Empty7School main gateEmptyUnchecked
Row 1
Car
Car 1
Driver
Empty
Seats
4
Departure point
Outside the office
Departs at
Empty
Confirmed
Unchecked
Row 2
Car
Car 2
Driver
Empty
Seats
4
Departure point
Station plaza
Departs at
Empty
Confirmed
Unchecked
Row 3
Car
Car 3
Driver
Empty
Seats
7
Departure point
School main gate
Departs at
Empty
Confirmed
Unchecked

Participant

Everyone writes their own name (or nickname) and picks a room and a car. Delete the example line before you use it. Don't add phone numbers.

Participant

Name (nickname)RoomCarDues paidMealsNotes
(Example) KimRoom ACar 1UncheckedNo labelsThis is an example line. Delete it and write your own.
(Example) Kim
Room
Room A
Car
Car 1
Dues paid
Unchecked
Meals
No labels
Notes
This is an example line. Delete it and write your own.

Dues and expense split

Dues are based on Dues per person in Document info. Log spending during the trip in the Expense split below.

•

When you pay, check ‘Dues paid’ in the participant table.

•

After the trip, divide any leftover money with the Expense split.

☐

Each room's capacity matches the people assigned.

☐

Set a driver and departure time for each car.

☐

Deleted the example line in the participant table.

☐

Turned on ‘Edit without signing in’ on the co-editing link and sent it.

For each expense, enter the amount and the group that paid. If someone didn’t take part, pick them under ‘Excluded from split’ for that expense and it’s divided among everyone else. You can change group names and members in Column settings.

Expenses

ExpenseDateAmountPaid byExcluded from split
GroceriesNot setNot setNot setNo labels
Lodging depositNot setNot setNot setNo labels
Groceries
Date
Not set
Amount
Not set
Paid by
Not set
Excluded from split
No labels
Lodging deposit
Date
Not set
Amount
Not set
Paid by
Not set
Excluded from split
No labels