Purpose
This article explains how to complete an export of your corporate card transactions using the TravelBank platform.
Audience
This article applies to all TravelBank customers with a corporate card.
Overview
A transaction export includes only corporate card transactions, so you can use a transaction export to help you reconcile your corporate card statement. In contrast, an expense export includes all of your corporate card and personal/out of pocket expenses. Review the “Configure the columns for the export” section of this article to see what information is unique to transaction exports.
Complete a transaction export (TravelBank web app)
To complete a transaction export, take the following steps:
Open the TravelBank web app at app.travelbank.com.
From the TravelBank left navigation menu, select “Manage” > “Transactions”.
Select “Export” in the top-right corner of the page (see Figure 1). (Note: If you have applied filters on this page, the filters will be in effect for the transaction export.) This brings up an Export Transactions page where you can specify what data you want to export.
Figure 1. Transactions page “Export” button
Use the available filters to refine the data you want to export.
Use the Column Configurations section to further refine the information you want to include about each transaction in your export.
Once you’ve set up your transaction data for your export, complete the export by selecting “Export CSV” at the bottom of the page. This automatically downloads your export. (Note: If there are no transactions that meet the filters you set for the export, an error message appears. Reset your filters to include a wider range of transactions, and try your export again.)
Add filters for the export
In the Filters section, you can refine the data you want to export. If you applied filters on the Manage > Transactions page, those filters show up in the Filters section.
To add a filter, select an option from the filter’s dropdown options (see Figure 2).
Figure 2. Dropdown options for the Transaction Status filter
To remove a filter, or unselect a filter option, select the X to the right of the option after you’ve selected it (see Figure 3).
Figure 3. Unselecting the selected option for the Transaction Status filter
The following filters are available to customize your transaction export.
Transaction status (required): Select Posted or Declined
Date range (required): Select the date range for the transactions you want to export. (Only transactions posted in the past three years are available for exporting. If you need older transactions, reach out to TravelBank support.)
Report status: Select Approved & Closed, Submitted, Active, or Unassigned
Department
Managing account
Cardholder
Expense category
Receipt status: Select Has Receipt or No Receipt
Expense assignee
Account minimum and account maximum
Configure the columns for the export
In the Column Configurations section, you can set how your filtered data appears in your export. You can rearrange the columns, as well as rename them so they display how you want them to in your export. Custom transaction fields are also available to be included in the export.
To include a column, check the column’s checkbox (see Figure 4).
Figure 4. Select columns to include in transaction export
The following columns are available for configuration, as well as any custom columns your organization has created. (Note: Columns with an asterisk are available only in transaction exports, not expense exports.)
Account/GL Codes (External Account ID)
Note: Account/GL codes (External account ID) information was previously only available in expense exports. This information is now also available in transaction exports.
Amount (always in USD)
Approved by Finance Date
Approved by Manager Date
Billable
Card #*
Cardholder*
Department
Description Field
Disputed Status*
Disputed Status Date*
Expense Assignee*
Expense Assignee Email*
Expense Category
Expense Policy
Expense Report
Expense Report ID
Fx Information*
ID
Lost/Stolen account*
MCC*
MCC Description*
Merchant
Merchant City*
Merchant State*
Posted Date
Receipt
Report Comments
Report Status
Sales Tax*
Split Amount (FX)*
Split Amount (USD)*
Submitted Date
Transaction Date*
Transaction reference ID
Trip
Trip ID
Frequently Asked Questions
Why am I receiving an “Export failed unexpectedly” error message?
You may be receiving this error message if the date range selected for the export does not contain any transactions. Try selecting a different date range and try the export again.
If I make modifications to the column configurations, will I have to reorder them every time I export transactions?
No, after a successful transaction export, the modifications you make will remain intact.
Why didn't I receive my transaction export?
Your completed export appears in your downloads folder. If the export is not there, you may need to turn off your pop-up blocker and try the export again.
In what format will my transaction export be?
Transaction exports are downloaded in .csv format.
Why don't I see the custom fields I created on my transaction export?
You may not have selected that field in the Column Configurations section. Under Column Configurations, double check that the box is checked for the field you are looking for in your transaction export.
Need help?
If you need help, contact the TravelBank support team:
Email support@travelbank.com.
From the website or mobile app: Open the left navigation menu and select “Chat with us”.
Publish date: March 14, 2024
Last update: April 20, 2024