A road trip budget needs six rows: fuel, tolls, stay, food, small extras and a buffer. Fuel, tolls and stay can be pre-filled from route data and bookings; food and extras are estimates; the buffer is a percentage of everything else. The sample below, for a six-day trip, comes to ₹38,335 with made-up numbers.
How do I lay the sheet out?
Put your inputs in a block at the top so you can change them without touching formulas.
- B1: total distance in km (1,400 in the sample).
- B2: mileage in km/l (16).
- B3: petrol price per litre (₹100).
- B4: nights (5), B5: room rate per night (₹2,800).
- B6: people (2), B7: days (6), B8: food per person per day (₹700).
Below the inputs, make a table of items and amounts in C11 to C15, then a subtotal, a buffer and a total.
What does each row look like?
| Row | Formula | Sample amount |
|---|---|---|
| Fuel | =B1/B2*B3 | ₹8,750 |
| Tolls | Typed in from route data | ₹2,200 |
| Stay | =B4*B5 | ₹14,000 |
| Food | =B6*B7*B8 | ₹8,400 |
| Parking, entry fees, extras | Typed estimate | ₹1,500 |
| Subtotal | =SUM(C11:C15) | ₹34,850 |
| Buffer at 10% | =ROUND(C16*0.1,0) | ₹3,485 |
| Total | =C16+C17 | ₹38,335 |
Fuel check: 1,400 / 16 = 87.5 litres, times ₹100 = ₹8,750. The total divided by six days is about ₹6,389 a day. The 10% buffer is only a starting point; a remote route deserves more.
Which rows can I pre-fill and which must I estimate?
- Pre-fill from data: distance from a map, tolls from a route planner or your last trip on the same road, stay from a confirmed booking.
- Pre-fill from your own history: your mileage, taken tank to tank, rather than the brochure figure.
- Estimate: food, parking, entry fees and small extras. Use last trip's actuals if you have them.
- Estimate with care: the buffer. Size it to the length and remoteness of the trip.
What should I do about big prepaid items?
Bookings paid before you leave, such as hotels and a train back, belong in the trip total but should be separated from the money you spend on the road. Make a second column for paid in advance and spend on the day. This keeps your daily spending cap clean and shows how much you must still pay as you go.
How do I check the plan against the actual trip?
Keep the same row names in your records after the trip. If you upload statements to SpendixAI, you can group spending under the same categories and compare each total against your plan. Pro includes budgets. A sheet still works well for a one-off trip; an app helps if you plan several each year.
How do I split the budget across days?
Divide the road costs by the number of days once the stay is fixed. In the sample, subtract the prepaid stay of ₹14,000 from the subtotal of ₹34,850 to get ₹20,850 for the road, and divide by 6 to get about ₹3,475 a day. Add the buffer separately and do not spend it unless you must. If you would like a daily cap with an evening routine, set it up from this figure and recalculate each night.
Also add a column for who pays when more than one person is chipping in, so the trip total and each person's share can be read without a second calculation.
A planning checklist
- Fill the inputs block with your own figures.
- Check your mileage with a tank-to-tank reading.
- Add the tolls for the full route, both ways.
- Pick a buffer you can live with.
- After the trip, paste in the actuals and keep the sheet for next time.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


