How do I set up the TCS fuel import?
The TCS integration allows you to upload fuel transaction data from TCS into Alvys. This is a manual import process using CSV files from your TCS system.
Who should do this? Office managers or administrators with access to integration settings and TCS reporting.
Add the TCS integration in Alvys
Navigate to the Management page and select the subsidiary you wish to integrate with TCS. Find and click the blue Integrate button.
In the pop-up window, click the Integration Type drop-down menu and scroll down to find TCS. Select it, choose the subsidiary that should use TCS, then click the blue Save button.
Add fuel card numbers to driver profiles
For TCS transactions to be properly attributed to drivers, you need to add fuel card numbers to each driver profile. Note that for TCS, you only enter the last 4 digits of the fuel card number.
Find the Assets option on the blue Alvys toolbar and select Drivers. Double-click on a driver from the list to open their profile.
In the first section of the driver profile, find and click the plus sign to the right of Fuel Card Numbers.
<image source="5584"></image>
Enter only the last 4 digits of the fuel card number associated with this driver.
<image source="4ba4"></image>
Select TCS in the Provider drop-down menu. If you'd like to deduct fuel or if fuel is discounted, use the checkboxes provided. Click Save to save your changes.
Repeat this process for each driver who has a TCS fuel card.
Download fuel transactions from TCS
You'll need to export transaction data from your TCS system to upload into Alvys.
Log in to your TCS system and navigate to Reports. Scroll down to the Transactions Download option, select your time period on the right, and your data will be downloaded as a CSV file.
If you need help locating this report, contact your TCS Sales Representative for assistance.
Upload fuel transaction reports to Alvys
Before uploading, make sure you've added fuel card numbers to driver profiles. The system will automatically link transactions to drivers based on these card numbers when you upload the report.
From the blue Alvys toolbar, select Reports and then Fuel Report. Click the blue Transaction File Upload button.
<image source="3734"></image>
In the pop-up window that appears, select TCS from the Integration Type drop-down menu.
<image source="c4fb"></image>
Click the blue button to browse for your TCS report file, or drag and drop the CSV file into the window. Upload the file, and once complete, you can review the transactions by selecting a Transaction Date range in the Fuel Report.
Frequently asked questions
Why do I only enter the last 4 digits of the fuel card number?
TCS fuel card data in transaction reports uses only the last 4 digits as the identifier, so that's what you need to enter in Alvys to match transactions correctly.
Is the TCS integration automatic or manual?
The TCS integration is manual. You need to download CSV files from your TCS system and upload them to Alvys periodically.
What happens if I upload the same transactions twice?
Alvys automatically detects duplicate transactions and won't import them again, so there's no risk of duplicate data.
How often should I upload fuel transaction reports?
This depends on your business needs. Many companies upload weekly or monthly to keep fuel data current for reporting and driver settlements.
