Gas receipts to Excel

Pump receipts are full of numbers

A gas receipt lists the pump number, fuel grade, price per gallon, gallons, rewards and discounts. ReceiptMoa looks for the amount you were charged among all of that, and discount lines aren't treated as the total. The date, station name and total go into the table.

Files download as fuel-log_date_time.xlsx with a sheet called Fuel.

Calculating MPG

The tool doesn't extract gallons, so add two columns and fill them in from the receipt and your dashboard.

Miles per gallon is the distance since your last fill-up divided by the gallons you just added. It's most accurate when you fill the tank every time. From the third row down, =(F3-F2)/E3 gives MPG. If you use liters and kilometers, =E3/(F3-F2)*100 gives liters per 100 km instead. Snapping a photo of the odometer with the receipt makes this column easy to fill in.

Monthly fuel costs

Dates come through as real Excel dates, so monthly totals are one formula away. Fuel spending for September 2026 is =SUMIFS(D:D, B:B, ">="&DATE(2026,9,1), B:B, "<"&DATE(2026,10,1)). With more than one car, add a Vehicle column and total by vehicle too.

Fuel is often the biggest running cost of a car. Add maintenance, insurance and toll receipts to the same file and you'll see what the car really costs to run.

If you drive for work

If you use your car for business, tax systems often let you claim either actual vehicle expenses or a standard mileage rate, and each needs different records. Check your tax authority's rules or your employer's policy before deciding what to track, and use this log as supporting data.

Frequently asked questions

Do small pay-at-the-pump receipts work?

Yes. Pump receipts are narrow with small print, so hold the phone close and tap to focus. Anything the reader isn't sure about is highlighted for a check.

Does it capture gallons or price per gallon?

No. It records the date, station and total only. Add a Gallons column and type the figure from the receipt.

What about fuel rewards discounts?

Discount lines aren't treated as the total, and the reader looks for the amount actually charged. Receipt layouts vary, so compare the total with the photo when a receipt shows both a before-discount and a final price.