Use this to manually import fuel or toll transactions from a file exported by your fuel card provider (e.g., EFS, Comdata). The same import process applies to both Fuel and Toll — just access it from the respective section.

For Fuel: Integration > Fuel > Transactions > Import File
For Tolls: Integration > Toll > Transactions > Import File

Step 1 — Upload Your File

1. Click Import File in the top right of the Transactions page
   
    

2. Select New Version (Beta) for the updated import flow

3. Drag and drop your file or click to browse; accepts .xlsx or .csv

4. Click Next Step

Step 2 — Match Columns

1. Select your MC Number and Company (e.g., EFS, Comdata) from the dropdowns

2. The left side shows what Datatruck expects. The right side shows your file's columns. Match them accordingly.

3. Required fields to map: Transaction ID, Card Number, Product, Amount. Optional fields include Location, Fee, Discount Amount, Discount Amount Base, and Status.

4. Use Add Column if your file has additional fields to include

5. To save this mapping for future imports, click Save Template and name it, select it from the Templates dropdown next time

6. Click Next Step
   
   

Step 3 — Preview and Import

Datatruck shows a summary before importing:

• Successful — rows ready to import

• Duplicated — rows already in the system, will be skipped

• Error — rows with issues; click the edit icon to fix or the delete icon to remove

Once everything looks correct, click Import. Transactions will appear in the Transactions tab immediately.



We hope this article was helpful. However, if you have any further questions, please don't hesitate to reach out to our Live Support.
​
​