How to Split Gas Money by Percentage: Fair Road Trip Formulas

✨ Community Finance

Published: May 3, 2026

To split gas money by percentage for a road trip or carpool, first calculate the total gas cost using this formula from Santander Consumer USA: (miles driven / MPG) times price per gallon. Then determine each person's percentage share with (their share / total cost) * 100, as shown in Google Sheets examples from Formula Bot.

For example, for 200 miles at 30 MPG and $3.25 per gallon, total cost is (200 / 30) times $3.25 or about $21.67. If one person covers 40% based on miles driven or passengers, their share is (0.40 * 21.67) or $8.67.

Use a shared spreadsheet to track odometer readings, fill-ups, and auto-calculate splits. This works for U.S. travel groups, roommates, or friends dividing costs by distance, usage, or income without apps or complex tools. Discuss rules upfront, document totals, and request reimbursements with receipts for clear records.

Calculate Total Gas Cost Before Splitting

Start with accurate total gas cost to ensure fair percentage splits. Use the step-by-step formula from Santander Consumer USA.

Note starting odometer reading before the trip.
Drive and note ending odometer for total miles.
Fill the tank completely and record gallons added.
Check local gas price per gallon at fill-up.
Calculate MPG: miles driven divided by gallons filled.
Calculate total cost: (miles / MPG) times price per gallon.

Example: 200 miles driven, 30 MPG, $3.25 per gallon. MPG is confirmed by dividing 200 by about 6.67 gallons filled. Total cost: (200 / 30) times 3.25 equals $21.67.

Track multiple fill-ups if the trip is long. Add a notes column for partial fills or efficiency changes from traffic or load, as suggested by Simplify Sheets for MPG monitoring. This gives a reliable total before applying percentages.

Determine Fair Percentage Shares for Your Group

Fairness depends on your group's rules. Common options include equal splits, usage-based, or income-based. Use the percentage formula (part / total) * 100 from Formula Bot for any method.

Equal split: Divide 100% by number of people. For 4 people, each pays 25%. Simple for uniform trips.
Usage-based: Base on miles driven with that person or passengers carried. If Person A rode 80 of 200 miles, their share is (80 / 200) * 100 or 40%.
Income-based: Adjust for earnings differences. If incomes are $50k, $60k, $70k total $180k, shares are 28%, 33%, 39%. Use (income / total income) * 100.

Decision points:

Choose equal if everyone rides the same and contributes equally to driving.
Use usage-based for uneven participation, like one driver covering most miles.
Pick income-based if lower earners need support, but agree on documentation.

Discuss tradeoffs: Equal is easiest but ignores imbalances. Usage-based promotes accountability via logs. Income-based builds equity but requires sensitive income sharing. Test with a sample trip total before committing.

In spreadsheets, enter = (their miles / total miles) * 100 in the percentage cell. Sum percentages to confirm 100%.

Set Up a Shared Spreadsheet for Gas Splits

A shared Google Sheet or Excel file tracks everything in one place. Draw from Simplify Sheets recommendations for MPG columns.

Recommended columns:

Date
Starting odometer
Ending odometer (formula: prior end + miles this leg)
Gallons filled
Price per gallon
MPG (formula: =(ending - starting) / gallons)
Cost this fill-up (formula: gallons * price)
Running total cost (sum of prior costs)
Person shares (e.g., miles with A, B)
Percentage for A (formula: =A miles / total miles)
Amount for A (formula: =percentage * running total)

Example row formulas in Google Sheets:

MPG: = (C2 - B2) / D2
Percentage: =(E2 / $E$10) * 100 (E2 is their miles, E10 total)
Amount: =F2 * (G2 / 100)

Share via link with edit permissions for drivers to log fill-ups. Set update cadence: Log after each fill-up, review weekly or trip-end.

Common mistakes: Forgetting partial fills (use notes column), not resetting odometer baselines, or manual errors in sums. A spreadsheet suffices for most informal groups; pair with a shared photos folder for receipts if needed.

Document and Request Reimbursements

Clear records prevent disputes. Follow these steps for calculation, documentation, and requests.

Finalize sheet with all fill-ups and totals.
Confirm percentages sum to 100% and amounts match total cost.
Export or screenshot the final rows.
Send personalized requests: "Hi [Name], our total gas was $X. Your 25% share is $Y based on equal split. Receipt photos attached. Venmo ok?"
Collect payments and note in a "paid" column.

For U.S. groups, under IRS accountable plan rules summarized by Expensify, submit receipts and documentation within 60 days, and return any excess reimbursement within 120 days, to keep it tax-free. This applies to informal travel reimbursements; check IRS guidance for your situation as rules are U.S.-specific.

Review as a group post-trip: Verify logs, update paid status, archive the sheet. Keep receipts 3+ years if tax-relevant.