Say your group wants gas money to follow income instead of headcount. Divide each person's agreed income or weight by the group total, then multiply that percentage by the gas bill. A $100 fill-up for two people earning $95,000 and $65,000 comes out to $59.38 and $40.62.
That's an ability-to-pay split, not a miles-ridden one, and the math itself doesn't make it fair. Income is private. To be honest, the agreeing matters more than the arithmetic here, so settle the rule before the first receipt shows up.
The income-based gas split formula
Pick one income basis and stick to it for everybody. Monthly take-home pay tracks available cash closely, and annual gross income works too. What you can't do is mix them, since a monthly figure measured against an annual one breaks the ratio.
| Calculation | Formula |
|---|---|
| Group total | Sum of all agreed incomes |
| Person's share percentage | Person's income / group total |
| Person's gas share | Gas bill x person's share percentage |
Carry the full percentage through every step of the math. Round dollars only at the end.
Worked example
Sarah earns $95,000 a year and Alex earns $65,000. Their group total is $160,000.
| Person | Agreed income | Share percentage | Amount from $100 |
|---|---|---|---|
| Sarah | $95,000 | 59.375% | $59.38 |
| Alex | $65,000 | 40.625% | $40.62 |
| Total | $160,000 | 100% | $100.00 |
At a glance the shares read as 59% and 41%. The spreadsheet should keep the exact figures, 59.375% and 40.625%, because that's what makes the cents add up cleanly.
Three incomes of $80,000, $60,000, and $40,000 give exact shares of 44.444%, 33.333%, and 22.222%. On a $100 bill that rounds to $44.44, $33.33, and $22.23. The third share absorbed the spare cent so the total still reaches exactly $100.
Calculate, record, and settle each fill-up
Here's the workflow for a road trip, a carpool, or any recurring shared ride:
- Agree on the income basis or the percentages before anyone travels. If salaries are private, agreed weights do the same job without anybody typing a dollar figure.
- Add the figures and calculate each person's share. Check that the percentages total 100%.
- Enter the gas amount from the actual receipt, never an estimate, and strip out any personal purchase that got rung up on the same paper.
- Record the date, the payer, and odometer readings if you want them. Odometer data helps with trip records, but it changes nothing about an income-based split.
- Multiply the receipt amount by each person's percentage. If the trip has several fill-ups, give each one its own row.
- Write down who advanced the money. The share is each person's obligation; the payer field only shows who already covered the cash.
- Net everything at the end.
net position = amount paid - amount owed; a positive result means the group owes that person, while a negative one means they owe the group.
Say Sarah pays the whole $100. Alex reimburses her $40.62, and Sarah's own $59.38 stays as her contribution. If Alex also put $20 toward another fill-up, you'd combine both rows before requesting a final amount.
A long trip can make the sheet look busy, but the method never changes; add a row, apply the same shares, and settle the totals later. Yes, it's repetitive. That's exactly why a row-by-row log helps.
Use a plain reminder such as:
Gas receipt: $75. I paid it. Your agreed amount is [enter amount]. The receipt is in the sheet; please mark it paid after reimbursement.
Build a reusable spreadsheet
Set up two tabs: People and Fill-ups. A spreadsheet handles this math with room to spare; the harder part is agreeing on the inputs and recording who paid.
On the People tab, enter comparable income figures or agreed weights. Start with rows 2 through 10 and put the total in row 11.
| Name | Income or agreed weight | Split % |
|---|---|---|
| Sarah | 95000 | =IF(B2="","",B2/$B$11) |
| Alex | 65000 | =IF(B3="","",B3/$B$11) |
| Taylor | 40000 | =IF(B4="","",B4/$B$11) |
| Total | =SUM(B2:B10) |
=SUM(C2:C10) |
Copy the formula in C2 down through C10, then format column C as a percentage. If you add more people, extend the total range and add a matching share column on the transaction tab.
The Fill-ups tab can hold one row per receipt:
| Date | Gas amount | Paid by | Sarah share | Alex share | Taylor share | Settled |
|---|---|---|---|---|---|---|
| Trip date | Receipt total | Name | =$B2*People!$C$2 |
=$B2*People!$C$3 |
=$B2*People!$C$4 |
Yes or No |
Change the names and cell references to match your group. Optional columns fit easily: odometer start, odometer end, miles, receipt location, or payment date. The Google Sheets function help page covers basics such as SUM.
Keep formula columns separate from input columns. If your spreadsheet tool supports range protection, turn it on to cut down accidental edits, and when possible give contributors access to input columns rather than the formulas. Income amounts are sensitive, so agreed percentages may work better as the shared input than actual salaries, which most people would rather not type into a shared file anyway.
Which cost-sharing model fits the trip?
Income is one defensible choice, not the only one. Turns out the right model depends on what the group wants to reflect: ability to pay, actual use, or simple convenience.
| Method | Calculation | Fits when | Limitation |
|---|---|---|---|
| Equal | Gas total / number of riders | Everyone uses the same route and wants quick math | It ignores income and different ride lengths |
| Income-based | Gas total x income share | The group has agreed that ability to pay should matter | It needs trust and may ignore actual usage |
| Usage-based | Gas total x person's passenger miles / total passenger miles | Riders join or leave at different points | Someone must track each person's mileage |
If everyone rides the same miles, a usage split may end up equal anyway. Groups that want income and mileage to both matter should agree on a hybrid rule first. Multiplying two percentages without a stated method can leave shares that don't total 100%.
Keep gas separate from other car costs
Gas isn't the same as every transportation expense. Tolls, parking, rental charges, and nonfuel vehicle costs belong in separate rows.
If one person provides the car or does most of the driving, the group has to decide whether it's sharing fuel only or also recognizing that contribution. There's no universal answer. Write the decision down, especially when riders cover different trip legs.
Agree on rules and keep records
Thing is, most disputes begin with a missing rule, not hard arithmetic. Put the agreement in the group chat or the spreadsheet before departure.
- Choose monthly take-home income, annual gross income, or agreed weights, and use the same basis for everyone.
- State whether the arrangement covers fuel only or includes other transportation costs.
- Record who pays upfront and when reimbursements are due.
- Explain how you'll handle partial rides, cancellations, rounding, and an unpaid balance.
For example:
Gas is split using the percentages on the People tab. The person who pays uploads the receipt. Others reimburse the listed amount within 48 hours. Tolls, parking, and nonfuel car costs are handled separately unless we agree otherwise.
Save receipt photos with the matching spreadsheet row. For an ongoing carpool, review the figures on an agreed schedule, quarterly, say, rather than changing percentages after every fill-up.
Questions people usually ask
Should we use take-home or pre-tax income?
Either works if everyone uses the same basis and period. Take-home income sits closer to spendable cash, while gross income may be easier to compare. Choose one before the numbers go in.
What if someone rides only part of the route?
Run a usage-based or per-leg split for that trip. An income-based formula alone charges by the agreed income ratio, not by miles traveled.
What if one person pays every receipt?
Keep the payer on every row and net all advances against each person's total obligation. The final reimbursement should reflect the balance, not require everyone to repay the full amount separately.
Can the same sheet handle tolls and parking?
Yes, but don't apply the gas percentages automatically. Add separate expense rows and agree on the rule for each category.
Before the next trip, build the People and Fill-ups tabs. Enter whatever figures or weights you agreed on, push one old receipt through the formulas, and check that the share columns sum to the receipt down to the last cent.