One person drives everybody to the grocery store all month. Who owes what at the pump, then? It sounds simple right up until somebody takes a long solo detour, or the tank sits empty on a Monday morning, and the math stops being obvious.
The cleanest fix is picking a split rule before anyone turns the key. Split pump totals equally, divide costs by individual miles, or give the car owner a break for wear and tear. Log the receipts in a shared Google Sheet. Settle the balances at the end of each month.
Pick a Split Rule That Fits Your Household
Equal splits only feel fair when everyone rides the same distance. If all of you pile into one car for weekly grocery runs or the occasional weekend camping trip, a straight three-way or four-way split makes sense. Same ride, same cost.
Unequal commutes break that math. One roommate drives twenty miles to work; another tags along for five miles, twice a week. An even split there breeds quiet resentment. A mileage-based split solves it: divide the total fuel cost by each person's logged miles.
Then there's the driver question. A roommate who supplies the car supplies far more than fuel. They absorb tire wear, oil changes, insurance bills, and depreciation. Thing is, many travel groups handle this by letting the driver ride fuel-free while passengers split the gas bills, which gives the vehicle owner credit for putting their own car on the line, as Spllito's road trip cost guide points out.
Four Formulas for Common Driving Scenarios
Test these formulas with realistic numbers before setting group rules.
Model 1: The Equal Split
Formula: Total Gas Bill / Number of Riders
Four roommates spend $80 filling up during a weekend getaway. Each person owes $20. Whoever paid at the pump collects $20 from each of the other three.
Model 2: The Mileage Ratio
Formula: Total Gas Bill (Individual Miles / Total Passenger Miles)
Anna rides 12 miles in a shared carpool month, Ben rides 21, and total gas costs $220. Anna's share is (12 / 33) $220, which equals $80. Ben pays (21 / 33) * $220, and that lands right at $140. The math matches the pavement used.
Model 3: The Driver Exemption
Formula: Total Gas Bill / Number of Non-Driving Passengers
On a longer trip, three passengers might cover a $150 fuel bill entirely. Each passenger pays $50. The car owner pays $0. That zero-dollar fuel tab covers the owner's oil, tires, and maintenance.
Model 4: The Income-Proportional Split
Formula: Total Gas Bill * (Individual Income / Combined Household Income)
Some roommates tie every shared cost to earnings. If Roommate A earns $3,000 monthly and Roommate B earns $2,000, Roommate A covers 60% of joint fuel tabs while Roommate B pays 40%. It requires sharing salary numbers. Most groups skip this one for gas.
Build a Shared Spreadsheet Tracker
You don't need a paid expense app for a regular house carpool. One spreadsheet in Google Drive works well as long as everyone has edit access.
Here's a column layout that holds up:
| Column Name | What Goes in the Cell | Example Entry |
|---|---|---|
| Date | Day of the fill-up | Oct 14 |
| Trip Purpose | Brief description of the drive | Target run and groceries |
| Miles Logged | Trip odometer reading | 42 |
| Total Cost | Receipt total at the pump | $52.00 |
| Paid By | Name of the person who swiped their card | Sam |
| Split Type | Equal, Mileage, or Driver Free | Equal |
| Person 1 Share | Calculated dollar amount owed | $26.00 |
| Person 2 Share | Calculated dollar amount owed | $26.00 |
| Running Balance | Net amount owed or owed back | +$26.00 to Sam |
Four setup steps keep the system from falling apart:
- Create the sheet and share it directly by email. While you're in the share settings, uncheck the option that allows editors to change permissions, a safety tip Sheets Bootcamp details for stopping accidental sharing changes.
- Lock your formula cells. Protect the share calculation columns through Data > Protect sheets and ranges, per the standard Google Sheets protection steps, so nobody pastes hardcoded text over your formulas.
- Add a photo folder. Create a Google Drive folder for receipt pictures and paste the link into cell A1 of the sheet.
- Calculate running balances. Use
=SUM(Share_Column) - SUM(Payments_Made)for each roommate to track net positions without resetting the sheet after every trip.
House Rules That Prevent Money Resentment
To be honest, the math rarely starts roommate arguments. Silence does. Let a request for seventy dollars sit for three months and things get tense fast.
Set these ground rules before anybody shares keys:
- Snap the receipt immediately: whoever pumps the gas photographs the receipt or the pump screen before pulling away.
- Log it within 24 hours: enter the numbers while the trip is still fresh in everyone's mind.
- Set a monthly settlement date: clear all outstanding balances on the first of the month, alongside rent and electric bills.
- Keep solo errands separate: if someone borrows a roommate's car for personal errands or a solo job interview, the tank comes back at or above the original fuel level.
Asking for your share works better short and matter-of-fact. A quick text does it: "Hey, logged yesterday's $48 fill-up in the sheet. Your share is $16 whenever you do monthly bills." Clear records end the awkward debate before it starts.
Put Your System in Place
A five-minute conversation today saves weeks of passive-aggressive sticky notes. Decide whether your household fits an equal split, a mileage ratio, or a driver credit. Open Google Sheets. Drop the column headers into row one. Share the link with your housemates before the next grocery run.