This article is part of the Commercial Rewards Card free plan guide or Commercial Rewards Card paid plan guide, or both. You can navigate back to each guide with the previous links and take the next onboarding steps.
Purpose
This article explains ERP integrations that may be possible for your organization.
Audience
This article is directed toward administrators who want to set up ERP integrations with TravelBank.
Export file (self-service)
The TravelBank standard expense export produces a .csv file on a predetermined schedule or on demand, depending on your preference. This process is the most common way that you can extract data from TravelBank. Note that an expense export only exports approved and completed transactions from the system. If you want access to an accrual view of transactions or a list of pending or open transactions, go to “Transactions” and select “Export”.
The export feature allows you to choose existing fields in TravelBank (such as “Posting Date,” “Transaction Amount,” “Expense Description,” “GL Account,” or “Department”) to export in whatever column order you choose. You can rename these fields for the export to match a corresponding field in your ERP system. The following Table 1 lists examples.
Table 1. TravelBank field names and corresponding ERP field names
TravelBank field name | ERP field name |
External Account ID | GL Account |
Department ID | Cost Center |
First Name | FirstName |
The following article also provides more information on expense exports: https://support.travelbank.com/en/articles/4038220-expense-export-faq
Custom export file (technical consultant engagement)
Custom export files are files that you cannot produce using the standard expense export method detailed in the previous section. These require custom work by the bank’s technical resources and will have an associated cost. The bank collaborates with you to build a custom file configuration that is delivered to you in a format that will automatically upload to your ERP/GL. These files vary in complexity, and the bank starts the process by asking you to share a copy of what you currently upload to your ERP.
A technical consultant schedules a scoping call with you to review what you need and to present the system’s capabilities to meet your needs. The entire process may involve up to four weeks for you to receive a completed custom file.
Here are common examples of when you may need a custom file:
You need credit card and out-of-pocket expenses separated into two files.
There are specific fields that do not exist in TravelBank that you must include for a file to upload successfully to your ERP (for example a “Date File Generated” field with the timestamp for that date).
You need to combine any existing fields in TravelBank to form a GL string (for example, combine your “Account ID-Department ID” and your “Custom Field ID” fields into one).
QuickBooks Online (QBO) integration
TravelBank has a basic API integration built with QuickBooks Online, which allows you to sync data between the two systems.
NetSuite integration
TravelBank supports a NetSuite integration, which allows you to sync:
NetSuite accounts or categories to TravelBank expense categories,
expense report approvals from TravelBank to NetSuite, and
expense report reimbursements from TravelBank to NetSuite.
Need help?
If you need help, contact the Commercial Rewards Program team at commercialrewards@travelbank.com.
Publish date: January 26, 2024
Last update: NA