Fleet fuel cards: reconcile the vehicle, quantity, and charge

A fuel-card statement is a payment record, but it may not reliably identify the vehicle, fuel type, or operating period without additional detail. Start by matching each transaction to the card assignment that was valid on the purchase date. A card reused after a vehicle replacement should not move the old vehicle's history to the new one.

Keep card identifier, vehicle identifier, date, supplier, fuel type, quantity, measurement unit, amount, and available receipt reference. Separate nonfuel purchases and fees. A single total labeled fuel can distort both expense review and a calculation of cost per gallon if it includes oil, repairs, or account charges.

The Department of Energy's FleetDASH work uses fleet fuel-transaction records and addresses missing or incorrectly coded data. That is a useful reminder that a detailed statement still needs completeness and classification checks before it supports an operating metric. Its federal reporting context does not impose those particular reporting requirements on every private fleet.

Compare opening balance, purchases, credits, fees, payments, and closing balance with the card account record. Confirm that all statement pages and transaction files are included. A download filtered to active cards can omit purchases from a card closed during the period.

Match credits to the original transactions where possible. A reversed authorization, corrected quantity, or merchant refund should not become a second negative fueling event in a vehicle-efficiency calculation. Preserve the financial reversal while identifying whether the original physical fueling actually occurred.

For an illustrative statement, purchases total $8,400, credits are $150, fees are $50, and payments are $8,000. With a zero opening balance, the closing amount due is $300. That reconciliation establishes the account balance. It does not establish that every purchase belongs to the correct vehicle or that the fuel quantities are reliable.

Check whether the quantity is gallons, liters, or another measure and whether the amount is in the expected currency. A unit conversion belongs in a defined calculation field, with the original quantity retained. Do not overwrite source units to make a consolidated report look uniform.

Investigate missing, zero, or implausible quantities using the receipt and merchant record. A transaction can be a valid expense while lacking enough information for fuel-efficiency analysis. Keep it in the financial reconciliation and mark its metric eligibility separately instead of either deleting the expense or inventing a volume.

Review fuel type against the vehicle's specification and assignment. An unexpected product can result from miscoding, a temporary replacement vehicle, a legitimate auxiliary purchase, or misuse. Treat it as an exception requiring evidence, not as proof of wrongdoing. The corrective action depends on what actually happened.

Odometer readings should generally form a sensible sequence for the same vehicle, but replacements, entry mistakes, and unit differences can interrupt it. Preserve the original reading and record an approved correction with its reason. A driver entering a rounded or remembered figure should not produce a precise-looking efficiency metric without review.

For a hypothetical interval, a vehicle travels from 40,200 to 40,800 miles and purchases 50 gallons under a defined full-to-full measurement method. The illustrative consumption measure is 12 miles per gallon. If the second reading was mistakenly entered as 48,000, the apparent result would be 156 miles per gallon, a data issue that should be resolved before anyone praises the vehicle's performance.

Choose a measurement method that fits the available evidence. Purchases during a calendar month are not necessarily the same as fuel consumed during that month because fuel remains in the tank at both ends. Label a simple purchase-based indicator accordingly and avoid comparing it directly with a more controlled full-to-full measure.

A vehicle may serve several jobs, branches, or drivers. Use the company's approved allocation basis, such as supported mileage or trip records, and retain unallocated activity when evidence is incomplete. The fuel-card holder's department is not necessarily the department that used the vehicle.

Suppose a hypothetical vehicle's accepted fuel cost is $900 for a period. Supported usage assigns 60% to Project A, 30% to Project B, and 10% to general operations. The allocations are $540, $270, and $90. They reconcile to the original $900; adding a separate general fuel expense after those allocations would duplicate the cost.

Keep tax treatment, employee benefits, and private-use questions in their appropriate review process. This transaction reconciliation supplies the evidence but does not decide deductibility or payroll consequences. Retain the factual use records needed by those reviewers without making an unsupported classification from the card transaction alone.

Assign each unresolved transaction a reason and owner: missing receipt, unknown vehicle, suspect quantity, odometer correction, duplicate import, or merchant dispute. Track the financial amount and the affected operating metric separately. A $20 transaction with an impossible quantity can materially distort an efficiency report even if the expense is small.

Review recurring errors by source. Repeated missing quantities from one merchant may call for a data-feed correction, while frequent assignment errors may indicate that card handover records are weak. Correct the process that creates the exception rather than repeatedly editing the monthly spreadsheet.

IRS guidance describes supporting records for purchases, expenses, and business assets. Retain the statement reconciliation, transaction details, assignment history, and approved corrections with that evidence. A completed fuel review should reconcile to the account balance and make clear which records are reliable enough for vehicle-cost and consumption analysis.