When a fill-up never made it into your log, the next row shows a wildly high mileage that is not real. Fix it by treating the two tanks as one long interval: take the odometer difference across both, add the litres from both fills, and divide. If you do not know the missed litres, estimate them from the payment amount or leave that interval out of your averages.
What does a missed fill do to the numbers?
Each row's mileage is the kilometres since the previous row divided by the litres in that row. If one fill is missing, the row after it covers two tanks of driving but only one tank of litres. The figure comes out about double, then your next honest rows look low by comparison, which is how people end up thinking something broke. Say a bike averages 45 km per litre and takes 6 litres each time. Here is a ten-row log with one fill missing between rows 5 and 6.
| Row | Odometer (km) | Litres | Km since previous | Km per litre |
|---|---|---|---|---|
| 1 | 20,000 | start | start | start |
| 2 | 20,270 | 6.0 | 270 | 45.0 |
| 3 | 20,540 | 6.0 | 270 | 45.0 |
| 4 | 20,810 | 6.0 | 270 | 45.0 |
| 5 | 21,080 | 6.0 | 270 | 45.0 |
| 6 | 21,620 | 6.0 | 540 | 90.0 (not real) |
| 7 | 21,890 | 6.0 | 270 | 45.0 |
| 8 | 22,160 | 6.0 | 270 | 45.0 |
| 9 | 22,430 | 6.0 | 270 | 45.0 |
| 10 | 22,700 | 6.0 | 270 | 45.0 |
How do you merge the two tanks?
Row 6 covers 540 km. If your UPI statement shows ₹600 paid at that pump on a day near 21,350 km and the pump price was around ₹100 per litre, the missed fill was about 6 litres. Then row 6 is 540 km on 12 litres, which is 45.0 km per litre, right back where it belongs. Mark the 6 litres as an estimate so nobody mistakes it for a measured value.
What if you cannot estimate the missed litres?
Then skip that interval instead of inventing a number. Leave row 6 blank in your mileage column, add a note saying one fill was not logged, and compute your average over the rows that remain. You lose one data point, which is far better than carrying a false 90 into your running average.
How do you set this up in a sheet?
Use these columns: A date, B odometer, C litres, D km since previous, E km per litre, F note, G litres missed (estimate). With the header in row 1 and the first fill in row 2, enter these formulas starting in row 3:
- D3: =B3-B2
- E3: =IF($F3="gap","",D3/(C3+G3))
- Type gap in column F for a row you want to skip, and type the estimated litres in column G for a row you want to merge. A blank G counts as zero, so ordinary rows are unaffected.
- Overall mileage for the whole log, using rows 2 to 11: =(B11-B2)/(SUM(C3:C11)+SUM(G3:G11))
For the example, that last formula gives 2,700 km over 60 litres, which is 45.0 km per litre. These formulas work the same way in Excel and Google Sheets.
How do you stop it happening again?
- Log the fill before you leave the pump, while the odometer is in front of you.
- Pay by UPI or card where you can, so the statement is a backup record of every fill.
- Once a month, scan the odometer column for any jump much larger than a normal tank range.
- Use full-tank to full-tank intervals, because partial fills break the maths even without a missed row.
If you upload your statement to SpendixAI, the fuel payments appear with their dates and amounts, which makes a missed fill easy to spot against your log. Cash fills can be added by hand.
A quick fix list
- Find the row with the impossibly high mileage.
- Check the statement for a pump payment between the two odometer readings.
- Estimate litres from amount divided by price, or mark the interval as a gap.
- Recalculate with the merged litres and note that the figure is an estimate.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

