Agree on the split before anyone books. For most college roommate trips, an equal share covers the shared rental, gas, tolls, parking, and agreed coverage; adjust it when dates or access differ.

Put the rule in a shared Google Sheet, log each payment once, and settle from the final balances. Turns out, the spreadsheet won't decide what is fair. Your written rule does.

Agree on the rules before booking

Settle the awkward details while the trip is still an idea. Once one roommate has paid with a card, changing the arrangement can feel personal.

Review the reservation terms and the FTC's rental car guidance before paying. Ask about additional drivers, age-related charges, coverage options, fuel terms, and any deposit or card hold; fees and options can raise the base price.

A driver should be listed and eligible under the rental agreement. If an additional-driver fee or age-related surcharge exists, decide whether the person who creates it pays or whether the group treats it as a shared cost. Either can be fair. Surprises are the unfair part.

Decision Example rule to record
Who shares the car? List every roommate, travel date, and expected level of access.
Which charges are shared? Rental, gas, tolls, parking, and group-approved coverage.
Which split method applies? Equal per person, per day or night, usage based, or a hybrid.
Who may drive? Name eligible drivers before pickup and confirm the rental agreement.
What happens if plans change? Decide how to handle late arrivals, cancellations, damage, or missing receipts.
When will you settle? Review the final balance after the last car expense.

Write this agreement in the Rules tab. Keep it short enough that everyone will actually read it.

Pick a split method that matches use

Equal is not automatically fair, and mileage is not automatically better. Pick the method you can explain in one sentence.

  • Equal per person: Divide eligible car costs by the number of people sharing the car. This works when everyone has similar access and trip dates.
  • Per-day or per-night: Adjust each person's share for the days or nights they are part of the trip. Use it when a late arrival or early departure changes access.
  • Usage based: Track miles or driving days for each person's share. This can fit uneven participation, but it requires clean logs and agreement about which miles count.
  • Hybrid: Split the base rental equally, then assign a person-specific fee or a late-arrival adjustment separately.

For a mileage method, calculate a person's gross share as their logged miles divided by the group's miles, multiplied by eligible car costs. Then subtract what that person already paid.

Room-based or income-based splits can work, but they add a subsidy rather than measuring car use. Name that choice plainly if your group wants it. With four people and $480 in eligible costs, an equal share is $120 each.

Build a simple Google Sheets tracker

Keep the sheet boring. Boring records get finished.

Create three tabs: Rules, Expenses, and Balances. A single tracker can hold meals or lodging too, but add a Category column or a separate balance block so a dinner does not accidentally become part of the car split.

Use one row per charge.

Date Description Amount (USD) Paid By Category Receipt or notes
2026-01-15 Rental fee 250 Alex Car Reservation receipt
2026-01-16 Gas 45 Jordan Car Receipt link; optional odometer

Record refunds as negative amounts. Use the same spelling for each payer's name every time.

For a four-person equal split, put this in Alex's balance cell:

=SUMIF(Expenses!D:D, "Alex", Expenses!C:C) - (SUM(Expenses!C:C) / 4)

This adds what Alex paid, then subtracts Alex's one-fourth share. A positive result means Alex paid above their share and should receive reimbursement. A negative result means Alex owes.

To make the name and group size changeable, put each name in column A of Balances and the number of participants in Rules!B2:

=SUMIF(Expenses!D:D,A2,Expenses!C:C)-(SUM(Expenses!C:C)/Rules!B2)

The formula uses a criteria range and a sum range, which is the basic SUMIF structure shown in these examples. Thing is, one neat formula cannot fix a missing rule or a mistyped name.

These formulas assume Expenses contains only car costs. If you combine every trip expense on one tab, filter by Category with a suitable SUMIFS formula or keep a separate car tab.

Share the file only with invited roommates. Give editing access to people who need to add expenses, and put a receipt file name or link in the notes column. Review the balances before the final day, not weeks later.

The sheet may look a little messy. That's fine. A late toll, a corrected gas amount, a note that says "receipt in group chat" - those are still better than relying on memory.

Track gas and incidentals as they happen

Gas is where memory gets fuzzy. Rotate who pays if that keeps stops moving, but rotate the receipt too.

  1. Write the payment order in the Rules tab before leaving. Note who will cover the first fill-up and who follows.
  2. At each stop, record the date, amount, payer, and station. Add gallons or the odometer reading if you are using a mileage-based method.
  3. Attach a receipt photo, file name, or link while the purchase is fresh. If the assigned payer cannot pay, record the actual payer instead.
  4. At the final review, total the gas charges and apply the agreed split. A payment at the pump is a credit toward that person's share, not a replacement for the calculation.

Use the same workflow for tolls, parking, and other small charges. Small costs are easy to forget and surprisingly annoying to reconstruct.

Give unusual charges their own rule

Some line items deserve separate treatment. Otherwise they sneak into the equal split and cause the fight later.

Extra driver or age-related fee. Assign it to the person whose driving eligibility creates the charge, or share it if the whole group needs that driver. Decide before the reservation.

Optional coverage. If one roommate asks for an optional protection product for personal comfort, decide whether the group shares it before booking. The rental company's terms and any personal policy determine what it actually covers.

Damage or cleaning. Record the date, photos, and rental-company correspondence. If responsibility is unclear, don't guess from memory or promise that a personal policy will pay. Follow the rental agreement and discuss the charge with the group.

Late arrival or cancellation. A per-day method may reduce a late participant's share, while a committed reservation charge may still need a separate decision. Put that decision in writing instead of changing the formula after the trip.

Settle the balance, not every receipt

Don't try to make every person pay every receipt. Net the balances instead.

Review the car tab when the rental ends. Match people with positive balances to those with negative balances, using as few transfers as practical.

A positive balance means the person paid more than their share. A negative balance means they owe. Zero means the recorded payments already match the rule.

Keep a Settled? column in Balances or a separate Payments tab. Don't delete original expense rows after someone reimburses the payer.

"I checked the car tab. Your balance is -$45, so please send $45 by Friday using our usual payment method. Mark it paid after sending."

Save a copy of the final sheet and the receipt links. To be honest, that final record matters most when plans change later or someone remembers the trip differently.

Questions roommates usually ask

Should someone who does not drive still pay?

Driving and cost sharing are separate. If the roommate rides in the car or has access to it, an equal share can still make sense. If they will not use the car at all, exclude them or agree on a different rule before booking.

What if someone joins the trip late?

Use a per-day or per-night adjustment when the dates are a reasonable proxy for car access. Record the person's start and end dates in the Rules tab.

Can the same sheet include meals and lodging?

Yes. Add a category for each type of expense, then calculate car balances from car rows only. A car formula that includes every vacation charge will produce the wrong result.

What if a receipt is missing?

Mark the row as pending, ask the payer for a statement or other record, and resolve it before final settlement. If proof never appears, make the group decision visible in the notes rather than silently guessing.

Create the rule before the reservation

Open the group chat now. Ask each roommate to post their travel dates, whether they will drive, and whether they accept the proposed split; then create the Rules, Expenses, and Balances tabs before anyone books.