Custom CSV Export Column Options

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)
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 a ACH reimbursement
Directpay Reimbursement Transfer Status	Transfer status of a 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