Hotel Room Split Calculator
Split tour lodging by travelers, room occupancy, nights, role groups, single-room exceptions, lodging tax, nightly room fees, fixed fees, and per-person reimbursement shares.
Use case: Load a named tour lodging setup, then adjust rooms, travelers, roles, fees, and single-room exceptions for your actual settlement sheet.
Use the role groups for band members, featured artists, crew, guests, or management. Single rooms are exceptions inside each group; comped singles are deducted before premiums are charged.
| Role group | Travelers | Weight | Single rooms | Notes |
|---|---|---|---|---|
| Core performers or named rooming group. | ||||
| Use for contracted or operational single-room exceptions. | ||||
| Lower or higher weights model deal memos. | ||||
| Optional add-on group for non-performing travelers. |
Split Breakdown
| Role group | Travelers | Singles | Room share | Tax/fees | Single adj. | Group total | Per person |
|---|
| Rooming pattern | Typical use | Occupancy basis | Split note |
|---|---|---|---|
| Two queen shared | Band and crew motel run | 2 per room | Clean equal split if all roles share. |
| Double-double quad | Students, choir, budget tour | 4 per room | Use room-use basis for dense blocks. |
| King single | Artist, driver rest, medical need | 1 per room | Mark as comped or premium exception. |
| Suite plus rooms | Producer, MD, management | Mixed | Role weights handle unequal agreements. |
| Overflow block | Nightliner, festival, late add-ons | 1-2 per room | Compare expected travelers to role total. |
| Method | Best for | How it behaves | Watch item |
|---|---|---|---|
| Follow room basis | Simple reimbursement | Fees mirror the main room split. | May hide fee-heavy singles. |
| Equal per traveler | Shared tour ledger | Every traveler gets the same fee share. | Ignores role weight agreements. |
| Role-weighted | Deal memo splits | Higher weights carry more lodging. | Weights must be agreed first. |
| Estimated room use | Singles and dense rooms | Singles count as one room-use share. | Approximation, not room assignment. |
| Preset | Travelers | Rooms x nights | Single exceptions |
|---|---|---|---|
| Indie Band Motel | 7 | 3 x 2 | 1 comped lead |
| Festival Holdover | 12 | 6 x 3 | 2 artist singles |
| Fly-In Producer Suite | 5 | 4 x 4 | 2 premium singles |
| Choir Conference Block | 38 | 12 x 5 | 2 director rooms |
| Recording Residency | 8 | 5 x 7 | 2 production singles |
When a tour travels between location, the tour is responsible for dividing up the hotel bill between all of the travelers on the tour. The hotel bill is a list of costs that must be divided up between the travelers, and the hotel bill determines the amount of money that each traveler must contribute towards the hotel costs for there stay. If a group dont properly divide the hotel bill, the group may experience arguments among its members regarding who should of paid how much for the hotel stay.
Therefore, each member of the group should maintain a record of the hotel bill to ensure that all members know to whom they should have agreed to pay for the hotel bill. Tours often order many rooms at the same time, and pay for the hotel bill for all of the travelers before dividing the hotel bill. The hotel bill includes the cost of the rooms for each traveler times the number of nights that they will stay in the hotel, but the hotel bill also includes taxes, destination fees, parking fees, and any other fees that is charged to the hotel by its destination.
How to Split the Hotel Bill on Tour
There are several ways that a group can divide the hotel bill. For instance, the group can divide the hotel bill equally among all of the travelers on the tour. Alternatively, the group can divide the hotel bill based off the role that each traveler plays in the group; for instance, the lead artist on the tour may have a more higher share of the hotel bill than some of the crew members on the tour.
Yet another way to divide the hotel bill is based upon how many individual will be using each hotel room; in this case, one person would pay for the cost of a single room, while many individuals pay for the cost of a room that is shared by many member of the group. Each of these method of dividing the hotel bill has its uses, but each also has the potential to create problem if the group does not adhere to the rules of the method for dividing the hotel bill. Single rooms are often used for tour manager or artists, and are a special feature offered to the members of the group.
If the group agrees to pay for a single traveler’s room, the group distributes the cost of that single room among all of the other travelers in the group. However, if the group does not agree to pay for a single traveler’s room, then that individual who will be using the single room must pay for the extra cost of the single room. These single rooms must be marked on the group manifest prior to dividing the hotel bill; otherwise, the group will assign the extra cost for the single rooms to the wrong member of the group.
If the extra cost for single rooms is assigned to the wrong travelers, the travelers will feel resentment towards the group. Another consideration of how to divide the hotel bill is the occupancy rules for the hotel. For instance, a room that is designed to accommodate two travelers may contain two queen-sized beds; in this instance, the room can hold three traveler.
The hotel bill for such a room will change in relation to the number of travelers that are occupying that room. Hotels often assign entire rooms to group of individuals; for instance, a choir may rent a single hotel quad room for all of its choir member. The number of rooms that are included in the hotel reservation may not match the number of rooms that is needed by the group.
Therefore, it is necessary to check the number of rooms prior to the reservation is finalized; otherwise, the group may encounter problem with the hotel staff at the front desk of the hotel. The final consideration in dividing the hotel bill is the division of taxes and fees. The lodging tax is usually calculated for the nightly room rate.
However, resort fees and facility fees may be calculated separate from the room rate. If a group applies the same tax rate to every item on the hotel bill, the group may end up charging the lodging tax twice on the bill. Fixed fees such as parking fees or porterage fees are easier to divide if the group keeps the fixed fees as whole amount.
A calculator can be used to calculate the lodging tax, the nightly fees, the fixed fees, and the room rates. Role weights determine how much each traveler will pay based on their job in the group. Each band member may have a different role weight.
For instance, an artist may have a role weight of 1.35 while a crew member may have a role weight of 0.85. These role weights are not randomly assigned to the individuals in the band. The role weights are from the deal memo that each member of the band sign prior to embarking on the tour.
The role weights should not be changed once the tour has officially begun. The original numbers should be written down and everyone should agree to the role weight of each individual in the band. A calculator can be used to change the role weights and to see the impact of the change in role weights.
A reference table may exist to demonstrate the different ways to split the bill for the band’s lodging. For instance, the reference table may have a pattern for bands that use two queen beds, a pattern for drivers that require single king beds, or a pattern for bands that use a quad room. The occupancy basis for each split note allow for each member of the band to understand the different split and how to split the bill.
A reference table allow each member of the band to review the different split methods. A group that commonly splits the lodging bill equally may use the reference table to determine if splitting the lodging bill according to the use of the rooms would be a more better split for that band at that specific hotel. The requirements for each tour change from stop to stop.
For instance, a festival may require six rooms for three night while a recording residency may require seven rooms for seven nights. The same logic has to be applied to each stop on the tour. The single rooms have to be marked first, the tax has to be separated from the lodging rate for the rooms, the fixed fees have to be kept as whole amount, and the split has to be determined between splitting according to the travelers, the roles, or the use of the rooms in the hotel.
A split sheet should be printed prior to the band leaving the hotel. A split sheet is a single sheet of paper that lists the base charge for the band member for the rooms, the tax to be paid on the lodging, the nightly fees, the fixed fees, and the total amount that each traveler in the band will have to pay for lodging. A split sheet can be given to each traveler.
The travelers will have a record of the lodging bill that they can keep with their other receipt for the hotel. If the hotel decides on adding a new fee for instance for parking, the amount can be added to the split sheet in the “fixed fees” line and the number can be calculated again. A split sheet can be used to keep the band’s finances in their head.
By calculating the hotel bill and splitting it prior to the arrival of the hotel bill, the band can have a conversation about the money in a calm manner and the lodging cost will land in the same place that the band originally agree the cost should land.
