sheetsmith

Templates › Household money

Car Running Costs

Made for drivers who want to know what the car really costs.

A workbook for recording every fuel fill and every other motoring bill, so the true cost per mile, fuel economy and yearly spend are always visible. The summary carries a chart that redraws itself as you type.

Tabs
3
Columns
19
Fill themselves in
20

£7one payment, yours to keep

  • Opens in Excel, Google Sheets and Numbers
  • Delivered straight away
  • No macros, nothing to install
  • Change it free before you buy

Payment is handled by Stripe. Your card details go to them and never to us. Sales are final, which is why every tab, column and calculation is shown on this page first.

The workbook's summary and the table behind it
A row typed into the real file. Every figure that changes is the spreadsheet's own arithmetic.
The summary page, every figure calculated from the tables
The chart, drawn from the totals in the table beside it
What is inside: the tabs, the columns and what fills itself in
Where you type, and the shaded columns that work themselves out
The guide sheet that opens first and explains the file
Everything included in the download

Everything inside, before you pay

This is the whole design: every tab, every column and how each calculated one is worked out. White cells are yours to fill in; the shaded ones work themselves out and are locked so a formula cannot be overwritten by accident. There is room for 650 rows.

Fuel Log

One row per fill. Enter the date, the odometer reading, the miles covered since the last fill, the litres and the pump price. Everything else is worked out for you. Room for 400 rows.

ColumnTypeWorked out as
Datedate
Odometer (Miles)number
Miles Since Last Fillnumber
Litresnumber
Price Per Litrecurrency
Fuel CostcurrencyIF(OR(ISBLANK([litres]),ISBLANK([price_per_litre])),"",ROUND([litres]*[price_per_litre],2))
Miles Per GallonnumberIF(OR(ISBLANK([litres]),ISBLANK([miles_since_last])),"",ROUND(IFERROR([miles_since_last]*4.54609/[litres],0),1))
Fuel Cost Per MilecurrencyIF(OR(ISBLANK([litres]),ISBLANK([price_per_litre]),ISBLANK([miles_since_last])),"",ROUND(IFERROR([litres]*[price_per_litre]/[miles_since_last],0),3))
Stationtext
Fill Typechoice (list)
YeartextIF(ISBLANK([date]),"",TEXT([date],"YYYY"))

Other Costs

Every motoring bill that is not fuel: servicing, tax, insurance, repairs and the rest. One row per bill. Room for 250 rows.

ColumnTypeWorked out as
Datedate
Categorychoice (list)
Descriptiontext
Paid Totext
Amountcurrency
Odometer (Miles)number
Next Duedate
YeartextIF(ISBLANK([date]),"",TEXT([date],"YYYY"))

Summary

What the car actually costs. Every line recalculates as you add fills and bills.

MeasureWorked out as
Total Spend This YearROUND(SUMIF([Fuel Log!year_label],TEXT(TODAY(),"YYYY"),[Fuel Log!fuel_cost])+SUMIF([Other Costs!year_label],TEXT(TODAY(),"YYYY"),[Other Costs!amount]),2)
Fuel Spend This YearROUND(SUMIF([Fuel Log!year_label],TEXT(TODAY(),"YYYY"),[Fuel Log!fuel_cost]),2)
Other Costs This YearROUND(SUMIF([Other Costs!year_label],TEXT(TODAY(),"YYYY"),[Other Costs!amount]),2)
Miles Driven This YearSUMIF([Fuel Log!year_label],TEXT(TODAY(),"YYYY"),[Fuel Log!miles_since_last])
Total Cost Per Mile This YearROUND(IFERROR((SUMIF([Fuel Log!year_label],TEXT(TODAY(),"YYYY"),[Fuel Log!fuel_cost])+SUMIF([Other Costs!year_label],TEXT(TODAY(),"YYYY"),[Other Costs!amount]))/SUMIF([Fuel Log!year_label],TEXT(TODAY(),"YYYY"),[Fuel Log!miles_since_last]),0),3)
Fuel Cost Per Mile This YearROUND(IFERROR(SUMIF([Fuel Log!year_label],TEXT(TODAY(),"YYYY"),[Fuel Log!fuel_cost])/SUMIF([Fuel Log!year_label],TEXT(TODAY(),"YYYY"),[Fuel Log!miles_since_last]),0),3)
Average Fuel Economy This YearROUND(IFERROR(SUMIF([Fuel Log!year_label],TEXT(TODAY(),"YYYY"),[Fuel Log!miles_since_last])*4.54609/SUMIF([Fuel Log!year_label],TEXT(TODAY(),"YYYY"),[Fuel Log!litres]),0),1)
Average Price Per Litre This YearROUND(IFERROR(SUMIF([Fuel Log!year_label],TEXT(TODAY(),"YYYY"),[Fuel Log!fuel_cost])/SUMIF([Fuel Log!year_label],TEXT(TODAY(),"YYYY"),[Fuel Log!litres]),0),3)
Litres Bought This YearROUND(SUMIF([Fuel Log!year_label],TEXT(TODAY(),"YYYY"),[Fuel Log!litres]),2)
Fills Recorded This YearCOUNTIF([Fuel Log!year_label],TEXT(TODAY(),"YYYY"))
Average Cost Of A Fill This YearROUND(IFERROR(SUMIF([Fuel Log!year_label],TEXT(TODAY(),"YYYY"),[Fuel Log!fuel_cost])/COUNTIF([Fuel Log!year_label],TEXT(TODAY(),"YYYY")),0),2)
Largest Single Bill RecordedIFERROR(MAX([Other Costs!amount]),0)
Latest Odometer ReadingIFERROR(MAX([Fuel Log!odometer]),0)
Total Spend All TimeROUND(SUM([Fuel Log!fuel_cost])+SUM([Other Costs!amount]),2)
Total Cost Per Mile All TimeROUND(IFERROR((SUM([Fuel Log!fuel_cost])+SUM([Other Costs!amount]))/SUM([Fuel Log!miles_since_last]),0),3)