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.
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
- In your fuel card portal, download the transaction report for the period as CSV or Excel.
- In Tezify, open Fuel and choose Purchases.
- Use Import a fuel-card statement and pick the file. Only the first sheet of an Excel file is read.
- Read the result: how many fills were saved, how many non-fuel lines were skipped, and how many were duplicates.
- Open any fill with no state and add one, so IFTA can place the gallons.
What Tezify reads from the file
| Column | Also matched as |
|---|---|
| Date | Transaction date, purchase date |
| Unit | Truck, tractor, vehicle |
| Driver | Cardholder, employee |
| Location | Merchant, truck stop, site |
| City and state | State can be a name like Texas or a code like TX |
| Gallons | Quantity, diesel gallons |
| Amount, fees and discounts | Total, 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.
Related articles
- Carrier and trucking TMSIFTA reporting in Tezify: automate your quarterly fuel tax
- Carrier and trucking TMSHow to spot suspect fuel fills and track MPG
- Carrier and trucking TMSHow the fuel card hold works when paperwork is missing
- Carrier and trucking TMSHow to plan cheaper fuel stops for each load
- Carrier and trucking TMSHow to import tolls from Bestpass, PrePass or E-ZPass
- Carrier and trucking TMSHow to match tolls to the load that ran them