Free template
Log each fill-up with the odometer and litres, and mark whether it was a full tank. The sheet works out L/100 km per car between two full fill-ups, compares each driver's average, and colours any car using more than 20% above its own average.
Sort by car, then odometer, before reading results
Fill-ups
The first full fill-up of each car is only a starting point and gives no figure.
Lists
No ID numbers.
Comparison
Table 3 is the fair comparison: the same car with different drivers.
Compare a car with itself first: its own past average is the best yardstick. The app does this for you (last 3 fill-ups vs the 90 days before).
Rule of thumb: 20% above the car's own average is worth a question; 30% is worth an inspection. A practical rule, not an official standard.
Compare drivers on the same car (table 3). A loaded pickup won't use what a sedan does on the highway.
Before asking the driver, check tyre pressure, the air filter, the A/C, load and route type (city or highway).
Because the fuel gauge isn't precise, and the amount paid changes with the price. The litres that fill the tank again are what the car actually used over the distance since the last full fill-up. If the driver adds half a tank in between, those litres are added to the next full fill-up; column H does exactly that.
The sheet works if odometer readings reach you correct and on time. In Sayarti+ Business the driver logs the fill-up from their phone when paying, with a receipt photo; their name is saved with it, and a “car using more than its average” alert shows on your fleet dashboard without opening any file.
Try Sayarti+ Business| Sheet | Sayarti+ Business | |
|---|---|---|
| Logging | receipts sent, then typed | driver on the phone, even offline |
| Consumption maths | sheet formulas | automatic, partial and missed fill-ups handled |
| Alert | colour when opened | on the fleet dashboard |
| Report by driver | comparison sheet | plus Excel, CSV, PDF export |
FAQ
Log the odometer and litres at every full fill-up. Consumption = litres ÷ (odometer now − odometer at the previous full fill-up) × 100, in L/100 km.
Log them and choose “No” for full tank. The sheet adds their litres to the next full fill-up.
Rule of thumb: over 20% above the car's own average is worth a question; over 30% is worth inspecting the car.
It's fairer to compare them on the same car and the same kind of trips, because load and route change consumption a lot.
Yes for diesel, in litres. For CNG in Egypt, enter cubic metres instead of litres; the result is m³ per 100 km.
Yes, with no sign-up or email.
