Custom CSV Export Column Options
Use this reference to choose the fields you include in a custom CSV export template.
| Column Name | Description |
|---|---|
| Amount | Original expense amount in the transaction currency |
| Amount (USD) | Expense amount converted to USD |
| Approved Date (GMT) | Date the expense was most recently reviewed (approved or denied) |
| Attendees | Any attendees listed on the expense |
| Average Daily Rate | If the expense includes a check-in and check-out date, the total amount is divided by the number of days between those dates (for example, the nightly rate per day of a hotel stay) |
| Batch ID | Unique identifier assigned to group related expenses exported together for accounting reconciliation. Only available for accounts using Manual Accounting Connection. When enabled, a batch can include both Transactions and Reimbursements for the same submitter. Batch IDs are unique per expense submitter; no batch includes expenses from multiple submitters. |
| Billable | Indicates whether the expense is marked as billable |
| Business Purpose | The business purpose for the expense |
| Card Program Name | Name of the card program associated with the corporate card transaction |
| Card Transaction Extended Description | Extended description provided by the card provider |
| Category | Expense category selected for the expense, broken with a '>' if parent_category > sub_category |
| Check-in Date | If the expense has a check-in date (typically used for hotels and rental cars) |
| Check-out Date | If the expense has a check-out date (typically used for hotels and rental cars) |
| Company Currency | Company's default currency code |
| Company Currency Amount | Expense amount converted into the company's default currency |
| Creator ID | Unique system ID of the user who created the expense |
| Creator Name | Full name of the user who created the expense |
| Date | Primary date associated with the expense, based on expense type |
| Debit Amount | The amount of the debit to the organization (if the expense is reimbursable) |
| Debit Date | The date of that debit to the organization |
| Debit ID | Unique identifier for the debit transaction |
| Debit Status | Current status of the debit |
| Directpay Reimbursement Payment Status | Payment status of an ACH reimbursement |
| Directpay Reimbursement Transfer Status | Transfer status of an ACH reimbursement |
| Employee Home Currency | The 3-letter description of that home currency (if the member has a home currency set) |
| Employee Home Currency Amount | The numeric value of that home currency (if the member has a home currency set) |
| Employee ID | If the member has an employee ID designated on their member profile |
| Expenses | Displays the number of expenses included in each reimbursement debit |
| Expense ID | Unique identifier for the expense |
| Expense URL | Direct link to view the expense in Emburse Spend |
| Expenser Email | The email address of the member |
| Expenser Name | The first and last name of the member |
| GL Code | If a category has a GL Code mapped |
| Has Receipt | Indicates whether a receipt is attached to the expense |
| ID | Unique identifier for the ACH debit |
| International Expense Amount | Expense amount in the foreign currency (if the expense is entered in an international currency) |
| International Expense Currency | Currency code of the international expense |
| Last 4 with Card Description | Last four digits of the card combined with the card description |
| Manager Email | The email address of the manager (if the member has a manager) |
| Manager Name | Full name of the manager (if the member has a manager) |
| Merchant | Merchant/vendor name associated with the expense |
| Mileage (Miles) | Number of miles claimed for mileage expenses |
| Payment Status of Directpay | Indicates the status of an ACH reimbursement |
| Posted Date (GMT) | Date the card transaction was posted (only applicable for commercial/corporate tier card programs and select banks) |
| Recipient | Recipient of the ACH reimbursement |
| Row Number | Sequential row number in the exported CSV file |
| Source | Source of the expense (corporate card, reimbursement, or international) |
| Split ID | If the expense was split, the unique ID of the split generated by Emburse Spend (all portions of a split expense have the same split ID) |
| State | Current state of the expense (new, manager_approved, approved, denied) |
| Statement Date | Card statement date associated with the transaction (only applicable for commercial/corporate tier card programs and select banks) |
| Status of Debit or Directpay | Overall processing status of the ACH debit |
| Submitted Date (GMT) | Date the expense was submitted |
| Total Days | Total number of days for lodging or trip-related expenses (if the expense has check-in/check-out dates) |
| Transaction Date (GMT) | Date the expense was incurred |
| Transfer Status of Directpay | Indicates the status of an ACH reimbursement |
| Trip | Name of the trip associated with the expense |
| Trip End Date | End date of the associated trip |
| Trip Start Date | Start date of the associated trip |
| Type | Expense type (e.g., card, reimbursement, mileage) |
| User Currency | Currency used for the expense (defaults to USD) |
| User Currency Amount | Expense amount in USD |
| expense_field_name | This column name is created from your organization's expense fields |
| team_field_name | This column name is created from your organization's team fields |
| Create "" | This creates an empty column name |