Docs · File formats
Fuel Card Review CSV format
Header names are matched automatically, in any order and any case. Extra columns are ignored.
| Column | Required | Also accepted as | Example |
|---|---|---|---|
| Transaction date | Yes | transaction date, trans date, tran date, transaction date/time, date/time, purchase date | 2026-10-06 |
| Total amount | Yes | total amount, transaction amount, gross amount, net amount, total fuel cost, gross cost | 298.83 |
| Transaction time | transaction time, trans time, tran time, purchase time, time | 06:48 | |
| Card number | card number, card #, card no, card, card id, card last 4 | ****1001 | |
| Driver | driver name, driver, driver id, employee name, employee, cardholder | Maria Lopez | |
| Vehicle | vehicle number, vehicle id, vehicle #, vehicle, vehicle description, unit number | TRK-101 | |
| Merchant | merchant name, merchant, site name, site, station, truck stop name | Pilot Travel Center | |
| City | merchant city, city, site city, truck stop city, town | Stockton | |
| State / province | merchant state, merchant state / province, state/province, state, province, truck stop state | CA | |
| Product | product description, product, product type, product name, fuel type, item description | Diesel #2 | |
| Gallons / litres | gallons, litres, liters, units, quantity, qty | 61.5 | |
| Unit of measure | unit of measure, uom, measure, volume unit | GAL | |
| Unit price | unit price, price per unit, ppu, price per gallon, ppg, price per litre | 4.859 | |
| Odometer | odometer, odometer reading, current odometer, odo, mileage, kilometres | 120872 | |
| Tank capacity | tank capacity, tank size, fuel capacity, tank capacity gallons, tank capacity litres, tank | 50 | |
| Vehicle fuel type | vehicle fuel type, required fuel, required grade, vehicle grade, fuel grade required, vehicle fuel | Diesel | |
| Posted / retail price | retail price, posted price, pump price, retail average, average retail price, opis price | 4.879 | |
| Fee amount | fee amount, program fee, program fees, fees, fee, admin fee | 49.00 | |
| Fee type | fee type, fee description, fee name, fee code | Program Administration Fee | |
| Late fee | late fee, late fees, late charge, late payment fee | 85.00 | |
| Promised discount per unit | contract discount, discount expected, expected discount, promised discount, discount per gallon, discount per litre | 0.05 | |
| Discount credited | discount amount, discount, discount applied, rebate, rebate amount, rebate credited | 1.91 | |
| Payment date | payment date, paid date, date paid, payment received date | 2026-10-14 | |
| Payment due date | due date, payment due date, statement due date | 2026-10-15 | |
| Card provider | card provider, provider, issuer, card program, fuel card, network | Fuelman |