All How-To Videos

Fuel Center: Set Up Cards and Import Monthly Purchases

TruckTA How-to Guides8:09English captions

Set up fuel cards, import monthly CSV purchases, and connect each purchase to the right truck and driver using dated card periods and Equipment Assignment History.

By TruckTA Team · Product guidance

Reviewed by TruckTA ·

This tutorial uses an AI-generated voice. The video and article explain the same reviewed TruckTA workflow.

Put the workflow to work

Solve the task with TruckTA

In this article
  1. 1. Open Fuel
  2. 2. Prepare your provider CSV
  3. 3. Upload the first file
  4. 4. Match today’s cards
  5. 5. Check earlier periods
  6. 6. Connect drivers through equipment history
  7. 7. Review Assignment History
  8. 8. Finish the import
  9. 9. Read Overview
  10. 10. Inspect Transactions
  11. 11. Maintain Cards & Matching
  12. 12. Review Issues
  13. 13. Import the next month
  14. 14. Review IFTA purchases
  15. 15. Keep the monthly routine consistent

Set up fuel cards once, then use the saved card periods and equipment assignment dates to connect monthly purchases to the right trucks and drivers. This walkthrough covers all six Fuel tabs using synthetic Roadline examples with three cards and two monthly CSV files.

Open Fuel

From Dashboard, open Finance Center, then Fuel. The page includes Overview, Transactions, Import Fuel, Cards & Matching, Issues, and IFTA. A company importing fuel for the first time sees guided setup. Roadline already has history, so the video demonstrates first setup for three new cards without removing earlier records.

Prepare your provider CSV

Download detailed transactions for the month from your fuel provider as a CSV, rather than a PDF statement. Date and amount are required. Include card number, transaction ID, gallons, and state to support matching, duplicate checks, and IFTA. Unit number, driver name, station, and product details help with review. Keep card numbers consistent, including leading zeros. Open What your CSV needs in Import Fuel to review the fields or download a template. The demonstration uses a fictional sixty-column TCS-format export containing diesel, DEF, discounts, and fees. Repeat the export for each new month.

Upload the first file

Choose file and select the monthly CSV. TruckTA recognizes the demonstrated TCS format automatically. Other formats may ask you to match columns; at least date and amount must be mapped. Those choices are remembered for files with the same columns. Review What's in the file, including purchase count, dates, total, and cards. The October sample contains eighteen purchases and three cards. Uploading reads the file; it does not complete the final import into your books.

Match today’s cards

Choose Start and confirm which truck has each card. In the example, card 8702 belongs to RD-002, card 8705 to RD-005, and card 8710 to RD-010. Check each suggestion before choosing Yes. A unit entered at the pump can suggest a match, but you still need to confirm the card's actual history.

Car hauler driver fueling a loaded car carrier at a diesel pump on a sunny day

Check earlier periods

Open Earlier to review older periods that still need an answer. Dates must reflect when the truck actually had the card. If a card moved, do not apply today's truck to the entire old statement. Use One truck when the card stays in one truck. Follows a driver and Shared by trucks describe different arrangements; select them only when they reflect actual use. Once the saved periods cover the purchases, continue to Drivers.

Connect drivers through equipment history

The Drivers step checks the truck's driver history for each purchase date. For a card assigned to one truck, the CSV driver name is a reference: TruckTA derives the driver from the truck's Assignment History. The examples use Bianca Ramirez, Elias Santos, and Jasmine Patel. If a driver is missing, record the correct assignment dates in the truck's history, then return to Fuel and choose Check again.

Review Assignment History

Open Equipment, select the truck, and open its assignment history. In the video, Bianca's assignment to RD-002 begins before the October purchases and has no end date, covering both sample files. When a driver changes trucks, end the old assignment on the correct date and start the new one when it actually began. Do not backdate an assignment simply to clear a warning. Gaps or conflicting assignments can prevent a single driver match. Correct the history to reflect what happened, then return through Finance Center to Fuel.

Finish the import

Return to the file in Import Fuel and open the Import step. Review purchases ready to import, anything already imported, and anything still needing review. Confirming a truck is separate from approving this final step. Select Import, review the confirmation, and confirm it. Wait for completion, then check the file's status and counts. Purchases held for a decision still need attention; an uploaded file alone does not mean every row reached the books.

Car hauler driver filling the tank of a loaded car carrier at a fuel island

Read Overview

Open Overview and select the period. Use Truck, Driver, Card, or State to narrow the results; More filters includes the provider. Net spend reflects the cost after discounts and added charges. Diesel and DEF have separate gallon totals. Gross spend, discounts, fees, and weighted prices per gallon provide more detail. Cost per mile needs usable odometer coverage, so a dash is not zero. Check the date range and notices about days without imported data. An empty period may mean purchases still need importing.

Inspect Transactions

Open Transactions and choose the same period. Filter to a card and open a purchase to review its truck, derived driver, date, provider information, and line items. Diesel and DEF are distinct products. Compare unexpected totals with the original provider file. More filters can show purchases that are not fully matched. The match explanation helps identify a missing truck, missing driver, or conflicting answer.

Maintain Cards & Matching

By card shows truck history and the current driver; By truck shows the cards used by each truck. Open a card to inspect its dated periods. Use Card moved to another truck for a move and Card stopped when it is no longer used. Change dates corrects a period. Used for another truck handles a genuine one-off. Review affected purchases and amounts before saving. A one-off overrides the normal card period and should not replace a lasting move.

Review Issues

Open Issues for purchases needing a decision, such as possible duplicates, missing truck choices, incorrect states, or total mismatches. Do not count a suspicious purchase merely to clear the list. Missing-driver issues point back to the truck's Assignment History; Fuel does not provide a separate driver override for those purchases. Correct the underlying record, return, and verify the match. An empty list means no issues within the selected filters.

Import the next month

Return to Import Fuel and upload the next month's file. The November example contains nine new purchases on the same three cards. Because the saved card periods and truck assignments cover those dates, TruckTA reuses the matches for Bianca, Elias, and Jasmine. Review the preview, finish importing, and open November in Transactions to verify trucks and drivers. New cards, moves, or missing history can still require setup. Previously imported purchases are skipped or flagged for duplicate review; check the preview rather than assuming every row is new.

Review IFTA purchases

Open IFTA, select the dates, and group purchased fuel by state, period, or truck. Eligible diesel gallons count toward the purchased-fuel view; DEF does not. Missing states or unresolved matching can leave purchases out of totals, so review them first. A supported connected ELD can add recorded miles by state. This is a workpaper view, not a calculation of final tax due or a filed IFTA return.

Keep the monthly routine consistent

Download the detailed CSV each month, review and import it, then check the results. Accurate card-to-truck periods and truck-to-driver assignment dates are what let the next file connect purchases to the correct trucks and drivers.

Read the video transcript

Let's set up your fuel cards, import purchases, and see which truck and driver each purchase belongs to. From the Dashboard, open Finance Center, then Fuel. We'll cover all six tabs, starting with Import Fuel. A company importing fuel for the very first time sees a guided setup before the other tabs open. Roadline already has fuel history, so we're adding three new cards to show their first setup without removing existing records. On your fuel provider's website, download the detailed transactions as a CSV, not a PDF statement. Start with this month's purchases, then repeat each month. Open What your CSV needs here in TruckTA. Date and amount are required. Include card number, transaction ID, gallons, and state for matching, duplicate checks, and IFTA. Unit number, driver name, station, and product details help you review the results. Keep card numbers consistent, including leading zeros. Our fictional sample uses the same sixty-column format as a TCS export, with diesel, DEF, discounts, and fees. TruckTA also offers a downloadable template. Choose file and select the October sample. We're using October, followed by November, to demonstrate the monthly routine. TruckTA recognizes this TCS format automatically. Other CSV formats may ask you to match your columns; at least date and amount must be mapped. Those choices are remembered for files with the same columns. Review What's in the file: eighteen purchases, their dates, the total, and three cards. Uploading reads the file. It doesn't finish importing the purchases into your books. Choose Start to review which truck has each card. Our card ending in eighty-seven oh two belongs to truck R D zero zero two. Check the suggested truck before choosing Yes. Do the same for eighty-seven oh five with R D zero zero five, and eighty-seven ten with R D zero ten. These are three separate cards, used by different drivers. A unit typed at the pump can suggest a match, but you still need to confirm the card's actual history. Open Earlier to review any older periods that still need an answer. The dates must describe when that truck actually had the card. Don't apply today's truck to an entire old statement if the card moved during that time. A card that stays in one truck uses One truck. Follows a driver and Shared by trucks are different arrangements; select them only when that's how the card is really used. Once the saved periods cover these purchases, move to Drivers. The Drivers step checks the truck's driver history for each purchase date. With a card assigned to one truck, the name in the CSV is only a reference. TruckTA gets the driver from that truck's Assignment History. Our examples use Bianca Ramirez, Elias Santos, and Jasmine Patel. If a driver is missing, open the truck's history and record the correct assignment dates. Then return to Fuel and choose Check again. Let's see where that history lives. Open Equipment, select truck R D zero zero two, and open Assignment History. Bianca's assignment starts before our October purchases and has no end date, so it covers both sample files. When a driver changes trucks, end the old assignment on the correct date and start the new one when it actually began. Don't backdate an assignment just to clear a warning. Gaps or conflicting assignments can prevent a single driver match. Correct the history to reflect what really happened, then return through Finance Center to Fuel. Return to this file in Import Fuel and open the Import step. Check the purchases ready to import, anything already imported, and anything that still needs review. Choosing a truck didn't approve this final step. Select Import, review the confirmation, and confirm it. Wait for the file to finish, then check its status and counts. Purchases held for a decision need attention; an uploaded file alone doesn't mean every row reached the books. Open Overview and select October. Use Truck, Driver, Card, or State to narrow the results; More filters includes the provider. Net spend is what the purchases cost after discounts and added charges. Diesel and DEF have separate gallon totals. You'll also see gross spend, discounts, fees, and weighted prices per gallon. Cost per mile needs usable odometer coverage; a dash isn't zero. Watch the date range, and check any notice about days with no imported data. An empty period may mean that purchases still need to be imported. Open Transactions and choose the same period. Filter to one of our new cards, then open a purchase. Review the truck, derived driver, purchase date, provider information, and line items. A diesel purchase with DEF includes two different products. Compare those details with the original provider file when a total looks wrong. More filters can show purchases that aren't fully matched. Use the match explanation to find out whether the missing piece is a truck, a driver, or a conflicting answer. Open Cards and Matching. By card shows the truck history and current driver; By truck shows the cards used by each truck. Open one of our cards to inspect its dated periods. Use Card moved to another truck when the card changes trucks, or Card stopped when it is no longer used. Change dates corrects a period. Used for another truck handles a genuine one-off. Review the affected purchases and amounts before saving a change. A one-off overrides the normal card period, so don't use it to replace a lasting move. Open Issues to see purchases that need a decision. Depending on the problem, you may need to resolve a possible duplicate, choose a truck, correct a state, or review a total mismatch. Don't count a suspicious purchase just to clear the list. Missing-driver issues point back to the truck's Assignment History; Fuel doesn't provide a separate driver override for those purchases. After correcting the underlying record, return and verify the purchase is matched. An empty Issues list means there are no issues within the filters you're using. Now return to Import Fuel and choose our November file. It contains nine new purchases on the same three cards. With the card periods and truck assignments covering those dates, TruckTA can reuse the matches for Bianca, Elias, and Jasmine. Review the preview and finish the import, then open November in Transactions to verify the truck and driver results. New cards, card moves, or missing history can still require setup. Purchases already imported are skipped or flagged for duplicate review; check the preview instead of assuming every row is new. Finally, open IFTA and select the dates you want to review. Group purchased fuel by state, period, or truck. Eligible diesel gallons count toward the purchased-fuel view; DEF does not. Missing states and unresolved matching can leave purchases out of the totals, so review them first. If your supported ELD is connected, the page can also show recorded miles by state. This is a workpaper view. It doesn't calculate your final tax due or file an IFTA return. Each month, download the detailed CSV, review and import it, then check the results. Keep the card's truck dates and the truck's driver history accurate. That's what lets the next file connect purchases to the right trucks and drivers.

Put it into practice

Keep your operation moving with TruckTA.

TruckTA How-to Guides23:23Captions

Active Board: The Complete Guide

Learn to read driver capacity, assign loads, manage status and notes, plan routes, and customize Active Board. Follow the complete walkthrough or jump to the task you need.

Watch