Carrier and trucking TMS · Fuel and tolls

Fuel card statements: import EFS, WEX, Comdata or Relay

Open Fuel, then Purchases, and use Import a fuel-card statement. Tezify matches the columns by name, skips non-fuel lines, puts each fill on its truck and state, and never counts the same statement twice.

Updated Open this in Tezify

Why import the card statement

Your fuel card portal already knows every gallon you bought, where, and on which card. Getting that into your TMS gives you three things: fuel cost per load and per truck, gallons by state for the IFTA return, and a way to catch fills that do not look right.

Tezify reads the statement file you download from the card portal. There is no live transaction feed from the card companies today, so plan to import once a week or at least before each IFTA quarter closes.

Import a statement

  1. In your fuel card portal, download the transaction report for the period as CSV or Excel.
  2. In Tezify, open Fuel and choose Purchases.
  3. Use Import a fuel-card statement and pick the file. Only the first sheet of an Excel file is read.
  4. Read the result: how many fills were saved, how many non-fuel lines were skipped, and how many were duplicates.
  5. Open any fill with no state and add one, so IFTA can place the gallons.

What Tezify reads from the file

ColumnAlso matched as
DateTransaction date, purchase date
UnitTruck, tractor, vehicle
DriverCardholder, employee
LocationMerchant, truck stop, site
City and stateState can be a name like Texas or a code like TX
GallonsQuantity, diesel gallons
Amount, fees and discountsTotal, net amount, rebate, savings

A file needs at least a date and either an amount or gallons. Lines for DEF, cash advances, scale tickets, washes, oil and lumper fees are skipped, so they do not inflate your fuel spend or your IFTA gallons. Reefer fuel is kept but marked, and IFTA leaves it out of road fuel. A date with no time is set to noon company time.

Fills logged by hand

Use the log fuel form on Purchases for a fill that is not on a card, such as a cash fill. Drivers can log fills in the app too. When the same fill is on the card and logged by hand, on the same truck and day with gallons within 1%, Tezify counts it once.

The Purchases page totals spend, gallons, average price per gallon and the number of transactions for the period.

Common mistakes

  • Importing a summary report. Use the per-transaction report, with one line per fill.
  • Unit numbers in the card portal that do not match Tezify. The fill then sits on a unit number Tezify does not know. Make the card's unit number match the unit on the equipment list.
  • Waiting until the IFTA deadline to import three months at once. Mistakes are easier to fix week by week.

Common questions

Is there a live fuel card feed?

Not for transactions. The Relay, EFS and WEX FleetOne connections under Connections are for locking cards, not pulling fills. See the fuel card hold.

What if I upload the same statement twice?

Each transaction is matched to the one already saved, so nothing is doubled. The result tells you how many lines were duplicates.

Which fuel card companies work?

Any portal that exports a CSV or Excel file with a date and an amount or gallons column. EFS, WEX, Comdata and Relay exports are all read by column name.

How do I find a suspicious fill?

Use the fill checks and MPG view. See suspect fuel fills and MPG.

Ready to do it? This lives at /admin/fuel-transactions in Tezify.

Open this in Tezify

Still stuck?

Inside Tezify, press the ? at the top of any page to file a ticket with that page attached. Not a customer yet? Ask us anything.