How is fuel consumption by norm calculated?

Mileage is multiplied by the base norm in L/100 km and by a factor of (1 + surcharge). The surcharge is the sum of the seasonal one (by trip month) and the condition surcharges: city, cargo, or both.

Can I change the norms and surcharges?

Yes, all norms, seasonal surcharges, the overuse threshold and the periods are editable cells. The default values are illustrative: check them against your own rules and applicable regulations.

Is this an official trip sheet form?

No. The print form is a working form following the structure of a trip sheet, with signature fields. Determine the required details and procedure from your own internal rules.

What does the spreadsheet check?

Return lower than departure, negative fuel balances, odometer lower than the previous return, duplicate sheet number, overuse above the threshold, and license, medical check, insurance and maintenance expired on the trip date.

How many vehicles and records can I keep?

Up to 60 vehicles, 80 drivers and 800 trip sheets; the summary is by vehicle and by month of the selected year.

← All templates

Trip Sheets and Fuel Tracking in Excel: Fuel Consumption by Norm

Trip log in Excel: fuel consumption by norm with seasonal surcharges, overuse and savings, tracking of maintenance, insurance, licenses and medical checks, summary by vehicle and month, printable trip sheet.

≈ $4.89

390 ₽

Blank template + filled-in example · Excel 2007+, LibreOffice, Google Sheets

Payment is processed securely by YooKassa in Russian rubles. If your card is declined, email us at info@хижняков.рф and we will arrange another way to pay.

What it is for

Keep a trip log and track fuel in Excel without manual calculations: you enter odometer readings, balances and refuels, and the spreadsheet calculates mileage, fuel consumption by norm with winter surcharges, actual consumption, and overuse or saving in liters. It also watches the deadlines for maintenance, vehicle insurance, driver's licenses and medical checks.

What's inside

"Settings": organization, overuse threshold, warning period, seasonal surcharges by month, fuel prices — everything is editable, with a note to check values against your own rules.
"Vehicles": up to 60 vehicles with L/100 km norm, city and cargo surcharges, maintenance and insurance dates, current odometer.
"Drivers": up to 80 drivers with license and medical check; the medical check validity is calculated automatically.
"Trip Log": up to 800 records — mileage, consumption by norm, actual consumption, overuse and saving, status and checks (return lower than departure, negative balance, overuse above the threshold, deadlines expired on the trip date).
"Deadline Control": a traffic light for maintenance, insurance, licenses and medical checks.
"Summary": by month and by vehicle — mileage, fuel, overuse, average consumption in L/100 km, cost of overuse.
"Print Trip Sheet": a simplified form by record number with signature fields (a working form, not an official one).

For organizations with a small fleet

In an administration, school, hospital or any institution with a small fleet, the spreadsheet replaces scattered logs: the person in charge of transport sees overuse for each vehicle, and the manager sees the maintenance, insurance and driver authorization deadlines. The monthly summary helps justify fuel write-offs by norm and prepare data for a report.

Who it is for

Fleet coordinators, transport supervisors, administration and facilities staff, mechanics, accountants who write off fuel, and managers of small organizations.

Compatibility

Excel 2007 and later, LibreOffice. No macros. The file is in English. Consumption norms, surcharges, medical check validity and the overuse threshold are illustrative defaults — check them against your own rules and the regulations that apply to you. The print form is a working form, not an official one.

📘 Fuel Consumption Log and Trip Sheet in Excel: Norm, Overuse and Savings

Questions and answers

How is fuel consumption by norm calculated?: Mileage is multiplied by the base norm in L/100 km and by a factor of (1 + surcharge). The surcharge is the sum of the seasonal one (by trip month) and the condition surcharges: city, cargo, or both.
Can I change the norms and surcharges?: Yes, all norms, seasonal surcharges, the overuse threshold and the periods are editable cells. The default values are illustrative: check them against your own rules and applicable regulations.
Is this an official trip sheet form?: No. The print form is a working form following the structure of a trip sheet, with signature fields. Determine the required details and procedure from your own internal rules.
What does the spreadsheet check?: Return lower than departure, negative fuel balances, odometer lower than the previous return, duplicate sheet number, overuse above the threshold, and license, medical check, insurance and maintenance expired on the trip date.
How many vehicles and records can I keep?: Up to 60 vehicles, 80 drivers and 800 trip sheets; the summary is by vehicle and by month of the selected year.