Skip to content

Free template

Free fuel delivery log template (PDF and Excel)

A printable fuel delivery log sheet for oilfield fuelers. Each row is one delivery, with the unit, location or pad, contractor, fuel type and gallons. A summary at the bottom totals gallons per contractor for billing.

It's free to download, print and copy, with no email or sign-up. The PDF is one US Letter page, and the Excel file adds up the totals for you.

The sheet

What's on the sheet

The sheet has three parts. At the top is a shift header you fill in once. The middle has one row per delivery. At the bottom are a short table for gallons by contractor, the shift total, and the fuel left on the truck.

A log is a whole shift on one sheet. If a customer wants a signed paper for each delivery, that's a ticket: get the free fuel delivery ticket template.

Company
blank, filled in by hand
Fueler
blank, filled in by hand
Truck
blank, filled in by hand
Date
blank, filled in by hand
Shift (Day / Night)
blank, filled in by hand
Starting fuel (gal)
blank, filled in by hand
Preview of the fuel delivery log sheet: the first three rows filled in as an example, then blank rows.
#TimeUnit #Location / PadContractorFuel typeGallonsNotes
119:40P-12Pad 4VantexDyed Diesel142.5Frac pump
220:05GEN-3Pad 4NorthwindULSD88
320:30LT-07Pad 4VantexULSD21.25Light tower
4
5
6
The first rows filled in as an example. The printed sheet has 24 numbered rows, then a gallons-by-contractor summary, the shift total, fuel left, and lines for the fueler's signature and the reviewer.

Filling it in

How to fill it in, column by column

Start each shift with a fresh sheet and fill in the header before the first delivery: the company, your name, the truck number, the date, day or night shift, and the gallons on the truck when you start. That last number is what makes the fuel-left line at the bottom work.

Then fill in one row for every delivery.

#
Already numbered. One row per delivery, in the order you made them. If you run out of rows, start a second sheet and carry on the numbering.
Time
The time you finished the fill. It settles most arguments later ("was that before or after shift change?").
Unit #
The number painted on the equipment, exactly as it is painted. Write P-12 every time, not P12 one night and Pump 12 the next.
Location / Pad
The pad, lease or site name your office uses on invoices. If a location has two names, pick one and stick to it.
Contractor
Who is billed for these gallons. This is the column the month-end totals are built on, so spell it the same way on every line.
Fuel type
ULSD, Dyed Diesel, DEF, Gasoline and Jet A, as listed at the top of the sheet. Write it on every row, even when the whole shift is one product; it matters when some customers are billed differently for DEF.
Gallons
As metered, to the decimal the meter shows. Numbers only, no "gal", so the column adds up cleanly.
Notes
Anything the office should know: what the unit was (heater, generator), a short fill, a meter that looked off.

At the end of the shift, add up the Gallons column for the total, subtract it from the starting fuel for the fuel left, sign the sheet and hand it in. In the Excel version, those lines calculate themselves.

A few habits make a paper log hold up when someone questions it later:

  • One sheet per truck per shift. Two trucks on one sheet, or two shifts, is how gallons end up billed twice or not at all.
  • Pen, not pencil. Cross a mistake out with a single line and write the right number beside it, so the office can see what changed.
  • Photograph the sheet at the end of the shift. Text the photo to the office. That way a lost sheet can still be billed.
  • Hand it in the same day. A sheet reviewed while the fueler still remembers the night gets fixed in a minute. A month later it turns into a phone call.

Billing

Totaling gallons per contractor at month end

The log is there for the invoice. Each contractor should be billed for the gallons their equipment took and nothing else. Here is one way to do it.

  1. Fill in each sheet's contractor summary. Before a sheet leaves the truck, list each contractor on it and total their gallons. Check that the contractor totals add up to the sheet's total gallons. If they don't, a line was missed.
  2. Collect every sheet for the month. Sort by date and shift, and look for gaps. A missing night is usually a sheet still sitting in a truck.
  3. Clean up the names. Decide on one spelling per contractor, and treat Vantex, VANTEX and Vantex Services as the same customer only if they really are.
  4. Add up per contractor. On paper, add each contractor's line from every sheet's summary. In Excel, type or paste all the month's rows into one sheet and use SUMIF on the Contractor and Gallons columns, or a pivot table with Contractor as rows and the sum of Gallons as values.
  5. Hold back anything in dispute. If a line is questioned, leave it off this month's invoice and note it, rather than billing a number you may have to credit later.
  6. Attach the totals to each invoice. A one-line summary per contractor, with the date range, is what most customers want to see. Here's what else goes on a fuel delivery invoice.

Paper's limits

Where paper logs fail

A good template makes paper logs consistent. It can't fix the ways paper breaks down in the field.

  • Sheets go missing. Wet, blown off a clipboard, left in the truck on days off. A lost sheet is a shift of gallons nobody can bill.
  • Handwriting has to be read by someone else. A 1 or a 7, a 3 or an 8, at 3 a.m. with cold hands. The office guesses, or calls the crew.
  • Everything is typed twice. Every row gets retyped into a spreadsheet before it can be totaled, and each retype is a chance for a new mistake.
  • Names drift. The same contractor spelled three ways becomes three lines on a report until someone notices.
  • The math is done by hand. Totals and fuel left get added up on the tailgate, and a wrong sum travels all the way to the invoice.
  • The office sees it late. Sheets arrive days or weeks after the shift, when the fueler no longer remembers what that smudged row said.

Fuel Relay handles all of these. See how the same log works as oilfield fuel delivery software.

The Fuel logs list: each log with its fueler, truck, time sent, location, entries, gallons, AFE coding and status: Awaiting review, Reviewed or Flagged.The Fuel logs list: each log with its fueler, truck, time sent, location, entries, gallons, AFE coding and status: Awaiting review, Reviewed or Flagged.The Fuel logs list: each log with its fueler, truck, time sent, location, entries, gallons, AFE coding and status: Awaiting review, Reviewed or Flagged.
The same columns in Fuel Relay's office dashboard, with every shift sent from the phones and nothing typed twice.

Template questions

Is the template really free, with no sign-up?
Yes. Both files download straight from this page, with no form, email or account. Print and copy them as often as you like.
Which file should I use, PDF or Excel?
Print the PDF for the truck. It's one US Letter page made for a pen. Use the Excel file if someone types the sheets up in the office. The total and fuel left work themselves out, and typing a contractor's name in the summary fills in their gallons.
Can I change the columns or add my company logo?
The Excel file is yours to edit: rename columns, add your logo, change the number of rows. The formulas refer to the gallons and contractor columns, so keep those two where they are or adjust the formulas.
How many deliveries fit on one sheet?
24 numbered rows. A busy shift may need a second sheet; number it as page 2 of the same shift and add both sheets' totals together.
Is there an app that fills in the same columns?
Yes, Fuel Relay. Fuelers fill in the same fields on a phone, it saves with no signal, and it does the totals for you. See the features.

Same log, on a phone

Keep this log on a phone instead

Fuel Relay has the same columns and does the adding for you. Each delivery saves on the phone with no signal, the fuel left is tracked, and gallons per contractor are ready at month end. The office dashboard is free.