Bank Profiles are used for mapping a credit card with a user. This will help when you import the credit card feed as the import program will know which transactions goes to which user. Please note that Bank profile have nothing to do with payments.
This solution provides the detailed information on each column available in the Credit Card Profiles Data Import Template
For a detailed tutorial on how to import bank profile, please refer - Credit Card Profiles Data Import Tutorial
| Column Name | Required/Optional | Description |
| UserEmail | Required | Valid email id associated with the user |
| ProfileName | Required | AMEX + Last 4 digits of Credit Card / Pcard. This value should be unique |
| BankName | Required | Valid Bank Name or Credit Card provider name. For Example, American Express, Bank Of America, JPMorgan Chase Bank, Citi Bank, SunTrust, Comerica, US Bank |
| AccountType | Required | Account type can be selected from the drop down it should be either one CreditCard, Savings or Checking |
| AccountNumber | Required |
Enter Credit Card Number associated with the user. The credit card (account number) should resemble exactly how it comes in the credit card file. |
| RoutingNumber | Required | Enter NA |
| DefaultCountry | Required | If the bank feed does not contain the information related to the country where the expense occurred, then the import defaults the country specified here |
| DefaultState | Required | If the bank feed does not contain the information related to the state where the expense occurred, then the import defaults the state specified here |
| DefaultCurrency | Required |
If the bank feed does not contain the information related to the currency in which the expense occurred, then the import defaults the currency specified here |
| DefaultCity | Required | If the bank feed does not contain the information related to the city where the expense occurred, then the import defaults the city specified here |
| DefaultPayMethod | Required | Pay Method associated with the credit card. Default to Corporate Credit Card or AMEX |
| DefaultCard | Required | Default to True always |
| DefaultCompany |
Optional | Default Company that should get selected, if using company field on the transaction |
| DefaultBusinessUnit |
Optional |
Default BU that should get selected, if using BU field on the transaction |
| DefaultCostCenter |
Optional |
Default Cost Center that should get selected, if using Cost Center field on the transaction |
Prior to importing Credit Card profiles please make sure Employees and Expense Types are imported correctly.