A shared Google Sheets tracker works best when it separates what the group bought, who used it, and who paid upfront. Use one row for each expense and one row for each person's share.

That detail matters. Turns out, most trip disputes start with a vague split rule, not bad arithmetic. Set the rules before booking, log receipts daily, and settle from the final balances.

Agree on Split Rules Before Booking

The same split rarely fits every Las Vegas charge. A room, a meal, and a show have different users.

Split method Works well for Tradeoff
Equal per person Shared rides, groceries, or a room with similar use Fast, but it ignores different usage
Nights stayed Hotel rooms when travelers arrive or leave on different days Requires separate rows by night or stay
Room or occupant based Suites or rentals with noticeably different rooms Fairer for unequal space, but needs agreement
Usage based Rental cars, gas, parking, and itemized meals More accurate, with more tracking
Weighted Families or groups that agree on different shares Flexible, but weights can feel subjective
Income based Couples or close family members sharing a broader budget Private and potentially sensitive; use only by consent
Reimbursement after proof One person fronts a cost and submits the receipt Clear records, but repayment happens later

Use one method per category and write it in a Rules tab. For example, hotel rooms might use occupants and nights, meals might use diners, and tours might include attendees only.

For a $200 room night shared equally by three people, each share is $66.67 before other charges. Three people. One clean calculation.

If one traveler stayed only one of three nights, create separate expense rows or include that person only on the nights they used the room. A couple in a private bedroom may also need a room-based split rather than an equal per-person split.

Some groups want to settle every night, some want to wait until checkout, and some want to split the large hotel charge immediately but leave meals for the end; any of those can work if the sheet says which balance is temporary and which one is final.

Keep Personal Spending Out of the Group Total

Personal purchases should stay separate. If each traveler buys their own flight, snack, or shopping, don't add those charges to the shared expense list just because everyone is on the same trip.

Flights need a decision too. If one person books every ticket, use each traveler's actual ticket cost and agreed fees unless the group deliberately chooses an equal split. Put separate travelers on separate rows when prices differ.

Shared meals can use an equal split, an itemized split, or a hybrid. For a hybrid, each diner covers their own entree while everyone shares agreed common items, tax, and tip.

To be honest, the cleanest rule is often the least clever one: personal items stay personal, shared items get a receipt, and exceptions get a note.

Build a Tracker With Separate Tabs

Name the file something recognizable, such as Las Vegas Trip - Expenses. Four or five tabs keep the math readable.

Tab Suggested columns Purpose
Rules Participant, default weight, default method, notes Records decisions before the trip
Expenses Expense ID, date, description, category, payer, amount, receipt, notes Stores one row per purchase or refund
Splits Expense ID, person, included, weight, share owed Stores one row per person for each expense
Settlements Date, from, to, amount, status, note Records payments made after the trip
Balances Person, paid, owes, net, received, sent, outstanding Shows who should pay or receive

Give each expense a unique ID, such as LV-001 or LV-002. Match that ID to the receipt filename or a note in your shared receipt folder.

The Expenses tab needs the actual amount paid. Format it as dollars, and keep refunds as negative amounts. Don't put card numbers, account credentials, or unrelated personal details in the file.

Give edit access to people who enter costs. View access may be enough for everyone else. Protect formula columns after testing them so a quick phone edit doesn't replace the calculation.

Add Formulas for Each Person's Share

The key setup is the Splits tab. Create a row for every person considered for every expense, then use Included as a checkbox and Weight as a number.

For an equal split, enter TRUE and a weight of 1 for each participant. For a weighted split, use the agreed values, such as 1 for an adult and 0.5 for a child. A participant who didn't use the service gets FALSE.

In Splits!E2, copy this formula down for Share Owed:

=IF(C2,VLOOKUP(A2,Expenses!$A$2:$F$200,6,FALSE)*D2/SUMIFS($D$2:$D$200,$A$2:$A$200,A2,$C$2:$C$200,TRUE),0)

This formula finds the expense amount, multiplies it by the person's weight, and divides by the total weight for that expense. Make sure every included person has a positive weight.

The formula assumes the Expenses columns run from A through F and the working range ends at row 200. Extend both ranges if the trip has more rows. Names and expense IDs must match exactly.

In Balances, list each participant once. Use these formulas in row 2:

=SUMIF(Expenses!$E$2:$E$200,A2,Expenses!$F$2:$F$200)
=SUMIF(Splits!$B$2:$B$200,A2,Splits!$E$2:$E$200)
=B2-C2

Place them in the Paid, Owes, and Net columns, respectively. A positive net means the person should receive money. A negative net means the person owes money.

You can summarize categories in another cell with:

=QUERY(Expenses!A2:F200,"select D, sum(F) where D is not null group by D label sum(F) 'Total'",0)

Keep the formulas unrounded. Display two decimal places instead. If a final total leaves a one-cent difference, apply that adjustment to one settlement rather than rounding every person's share.

Record Las Vegas Costs by Actual Use

Las Vegas expenses often change category during the same day. The receipt goes in. The decision goes in too.

Expense Practical split Entry note
Hotel room, taxes, and mandatory property fees Occupants, nights, or room assignment Put upgrades or room-specific charges on separate rows
Incidental authorization or hold No split unless it becomes an actual charge A temporary hold is a cash-flow issue, not a trip cost
Rental car, gas, parking, and tolls Drivers, users, days, or another agreed rule Note who had access if not everyone rode
Meals Diners, itemized amounts, or an agreed equal split Decide how shared items, tax, and tip are handled
Shows and tours Attendees only Exclude anyone who declined
Flights Each traveler's actual ticket, or an agreed equal split Separate rows help when ticket prices differ
Deposits and refunds Temporary advance or matching negative expense Add the refund when it posts, using the same split

Don't enter a hotel card hold as though it were a completed charge. Check the final hotel bill and record charges that actually posted. If a refundable deposit was paid and the group wants to settle that advance early, mark it clearly as temporary and update the balances when the refund arrives.

A canceled booking or returned deposit can use a negative amount with the original payer and participant split. That lets the formulas reverse the cost without deleting the original receipt record.

Review the Sheet During the Trip

A short review prevents a large argument later.

  1. The person who paid enters the expense the same day, attaches the receipt reference, and chooses the category.
  2. The people included in the split check the row and confirm the Included and Weight values.
  3. The tracker lead checks for missing receipts, duplicate entries, and amounts entered as text instead of numbers.
  4. The group reviews the running totals after major bookings and before checkout.
  5. The lead records refunds or corrections as new rows instead of quietly erasing the original entry.

A two-minute check after dinner is enough for many groups. Large balances deserve a separate review.

Use dropdowns or checkboxes for categories, participant names, status, and inclusion. They reduce spelling differences that can make SUMIF formulas miss a person.

Settle From Net Balances After Refunds

Wait until the major hotel charges, deposits, and cancellations are clear unless someone needs repayment sooner. Some groups settle a large advance midway, then do a final adjustment after checkout.

Read the Net column first. People with negative balances pay people with positive balances. Match those amounts directly rather than asking every traveler to repay every individual expense.

Add each completed payment to Settlements. The From person is the sender, the To person is the recipient, and Status becomes Paid only after the transfer or cash handoff happens.

In Balances, you can calculate received and sent amounts like this:

=SUMIFS(Settlements!$D$2:$D$200,Settlements!$C$2:$C$200,A2,Settlements!$E$2:$E$200,"Paid")
=SUMIFS(Settlements!$D$2:$D$200,Settlements!$B$2:$B$200,A2,Settlements!$E$2:$E$200,"Paid")

For Outstanding, use:

=D2-E2+F2

Here, D is the original net, E is received, and F is sent. A partial payment gets its own settlement row.

A neutral payment request can be simple:

The sheet shows a remaining trip balance of $X for your hotel, meals, and tour shares. Please send it to [name] using the payment method we agreed on, and flag any questionable expense ID before paying.

Don't record a reimbursement as a negative travel expense. A payment changes who has settled; it doesn't change what the trip cost. Keep the expense rows intact.

Fix Common Tracker Mistakes

Mistake Better fix
One expense row has one vague total of shares Use one Splits row per participant
Everyone pays the same hotel amount despite different nights or rooms Separate nights, rooms, or room-specific charges
A card hold is counted as a completed cost Record only an actual posted charge
Formulas round every person's share Keep full precision and adjust one final cent if needed
Names are typed several different ways Use a participant dropdown or copy names from Rules
A refund overwrites the original receipt Add a negative refund row with a reference
A payment is mixed into trip expenses Record it in Settlements

Start With One Test Expense

Create the Rules, Expenses, Splits, and Balances tabs before the first booking. Add one sample shared charge, check that the shares equal the expense total, and confirm that the payer's net balance makes sense.

Then share the finished sheet with the people who need to edit it. Test one real receipt before the trip gets busy.