Budget-share splitting works when friends agree that a shared cruise cost will follow set percentages instead of an equal split. It can help a group with different spending limits, but the percentages need to be agreed before someone books the charge.
Create one shared Google Sheet and keep two numbers separate: each person's assigned share and the amount they paid upfront. Use percentages for budget-share rows, 1 or 0 markers for equal or usage-based rows, and a separate settlement record for repayments.
Agree on what "budget share" means
Budget share is not automatically an income split. It is simply a rule the group chooses, such as Alex 40%, Jordan 30%, and Casey 30% for a shared grocery run.
Write the rule before booking. State whether it applies to taxes, gratuity, deposits, cancellation charges, and onboard fees. Also decide whether the percentages apply to the whole trip or only to a category.
Use the method that matches the cost:
- Equal split: Divide a shared dinner or grocery purchase evenly when everyone receives roughly the same value.
- Usage-based split: Charge only the people who join an excursion, drink package, or activity. Cabin costs may follow occupants, room type, or nights stayed.
- Budget share: Apply agreed percentages when spending limits differ or the group has chosen an unequal contribution rule.
- Personal expense: Exclude an item that benefits one person, such as a private purchase or an excursion booked without the group.
Cabins deserve their own conversation. Occupants, nights, and room type often explain the cost better than a general budget percentage. If the group chooses budget share anyway, put that choice in writing.
Build a shared Google Sheet that stays readable
Keep the file boring. Really. A plain sheet that everyone understands is more useful than a clever one nobody updates.
Use one row for each purchase. These columns cover most cruise groups:
| Field | What to enter | Example |
|---|---|---|
| Date | Date of the purchase | 2026-03-15 |
| Description | Clear name for the charge | Excursion tickets |
| Category | Cabin, meals, activities, groceries, or other | Activities |
| Paid By | Person who paid the merchant | Alex |
| Amount | Full amount paid | $500 |
| Currency | Currency shown on the receipt | USD |
| Split Type | Equal, Usage-based, Budget Share, Personal, or Reimbursement | Budget Share |
| Participant columns | One column per person | Alex, Jordan, Casey |
| Notes | Receipt reference, exception, or agreement | Alex 40%, Jordan 30%, Casey 30% |
Put the group's names on a Rules tab. Add the agreed percentages, definitions for each split type, the currency used for settlements, and the day the group will review the sheet.
Use a Transactions tab for actual purchases. A Settlements tab should track money sent between friends. That separation keeps repayments from inflating the trip's total spending.
Share the file with named group members when possible. Give edit access to the people entering expenses, and use view or comment access for everyone else. Avoid an open link if the sheet includes personal spending details.
Log each cruise expense once
One row should represent one economic event. A deposit, a dinner, and a reimbursement are different events.
- Save the receipt or write down the charge soon after it happens.
- Enter the date, description, category, payer, amount, and currency.
- Choose the split type before marking participants.
- Enter 1 for each included person and 0 for each excluded person on equal or usage-based rows.
- Add the agreed percentages on budget-share rows, then explain unusual choices in Notes.
Do not hide personal purchases inside a group row. A private cocktail, souvenir, or activity should stay separate unless everyone agrees to share it.
If the connection is unreliable at sea, keep temporary receipt details in phone notes and add them to the sheet when connected. Use one person per row, not several people editing the same unfinished line.
Calculate each person's budget-share portion
Turns out, the math is simple once the rule is visible.
For equal and usage-based rows, count the 1s and divide the amount by that count. For budget-share rows, use the agreed percentages instead. The percentages should total 100%.
| Charge | Paid by | Allocation | Assigned shares |
|---|---|---|---|
| $500 excursion | Alex | Alex 40%, Jordan 30%, Casey 30% | Alex $200, Jordan $150, Casey $150 |
| $120 dinner | Jordan | Alex 1, Jordan 1, Casey 0 | Alex $60, Jordan $60, Casey $0 |
Store percentages as 40%, 30%, and 30%, or as 0.4, 0.3, and 0.3. Do not mix whole numbers with percentage-formatted values.
If the amount is in column E, the split type is in F, and Alex's participant value is in H, place this in Alex's share-amount column:
=IF($F2="Budget Share",$E2*$H2,IF($H2=1,$E2/COUNTIF($H2:$J2,1),0))Copy the formula across for the other participant columns and down for new rows. Change the participant reference from H2 to I2 or J2 as needed. Expand the range if your group has more than three people.
Add a check cell for budget rows:
=IF($F2="Budget Share",SUM($H2:$J2),"")A budget row should show 100%. An equal or usage-based row should show its participant count instead.
At the bottom, total each person's assigned shares and total the amounts they paid. Use this calculation for the balance:
net balance = total paid - assigned share + settlements sent - settlements received
A positive balance means that person should receive money. A negative balance means they still owe money.
That distinction matters. The person who paid the merchant is not always the person who owes the most.
Keep reimbursements separate from expenses
Thing is, a transfer is not a new expense. It is a movement of money that reduces an existing balance.
On the Settlements tab, record the date, sender, recipient, amount, payment method, related expense, and whether the payment is complete. Cash belongs there too. Add a note so nobody has to rely on memory later.
If you keep everything on one tab, set Split Type to Reimbursement and use the 100%/0% convention. Put 100% under the person who originally paid the expense and is now being repaid, and 0% under everyone else. Add From and To columns so the row is clear. Here, 100% is a credit marker, not another expense allocation.
Make sure reimbursement rows are excluded from expense totals. Otherwise, the same money may be counted once as a cruise cost and again as a repayment.
For example, Alex pays the $500 excursion and owes $200 of it personally. Alex has a $300 positive balance before settling. If Jordan sends Alex $150, Jordan's negative balance moves toward zero and Alex's positive balance falls to $150. Casey still owes $150.
Do not add Jordan's $150 transfer as another $150 excursion.
Review the sheet before balances get large
Review weekly as a default. Check sooner after a large deposit, cabin payment, or cancellation charge.
| Review check | What to confirm |
|---|---|
| Missing row | Compare receipts, confirmations, and card records |
| Wrong payer | Correct the person who paid, not the participant shares |
| Wrong participant | Change the marker to 0 if that person did not join |
| Budget total error | Confirm the percentages add to 100% |
| Duplicate charge | Search the description and amount before adding a row |
| Missing repayment | Check the Settlements tab and mark its status |
Ask the payer to confirm the amount. Ask participants to confirm who benefited. Those are separate checks.
Don't silently change a disputed row. Add a note, discuss the rule in the group chat, and record the agreed correction in the sheet. The goal is a shared record, not a private calculation that only one person understands.
Send clear settlement requests
At each review, publish the current balance by person and a settle-by date chosen by the group. Keep the message specific:
I reconciled the sheet through Thursday. Jordan owes Alex $150 for the excursion. Please check the row and send it by Friday, or flag the correction before then.
To be honest, a payment request does not explain why money is owed. The sheet does that. Keep the transfer confirmation or cash note with the settlement record.
Use cents in the row calculations and round only at the final settlement. If rounding leaves a one-cent difference, agree on who will absorb it instead of letting the spreadsheet carry a mystery balance.
Start with a test row
Before booking, create the Rules and Transactions tabs, enter one small example, and ask every participant to verify the percentages. If the test produces the numbers everyone expects, use that format for the cruise.