Custom CSV Export Column Options

The expense amount, in USD

If any attendees were included on the expense, a list of attendees

If the expense includes a check-in and check-out date, the total amount divided by the number of days between those dates (for example, the nightly rate per day of a hotel stay)

If the expense is marked billable, 'yes'

If the expense is marked not billable, 'no'

If the expense is associated with a card transaction from a corporate card program, the name of that card program

If we have an extended description of an associated card transaction

The expense category name, broken with a '>' if parent_category > sub_category

If the expense has a check-in date (typically used for hotels and rental cars)

If the expense has a check-out date (typically used for hotels and rental cars)

If the expense has a debit, the amount of that debit to the organization

If the expense has a debit, the date of that debit to the organization

If the expense has a debit, the unique debit ID of the expense generated by Abacus

If the expense has a debit, the status of the debit

If the expenser has a home currency set, the 3-letter description of that home currency

If the expenser has a home currency set, the numeric value of that home currency

If the expenser has an employee id designated on their user profile

The unique URL link of expense generated by Abacus

The email address of the expenser

Expenser ID

The unique ID of expenser generated by Abacus

Expenser Name

The first and last name of the expenser

If a category has a GL Code mapped

If the expense has a receipt, then 'yes'

If the expense does not have a receipt, then 'no'

If the expense is entered in an international currency, the numeric value of that international currency

If the expense is entered in an international currency, the 3-letter description of that international currency

If the expense is from a connected card, the card_description - last_4_digits_of_card_number

If the expenser has a manager, the email address of the manager

If the expenser has a manager, the first and last name of the manager

The expense merchant/vendor

If the expense is a mileage expense, the number of miles

The business purpose for the expense

If the expense is from a connected card that has transaction posting dates (only commercial/corporate tier card programs and select banks)

The date the expense was most recently reviewed (approved or denied)

Either 'Manual', 'Corporate Card', 'Personal Card', 'International (Manual)', 'International (Personal Card)', 'International (Corporate Card)'

If expense was split, the unique ID of the split generated by Abacus (all portions an split expense have the same split ID)

The expense state (new, manager_approved, approved, denied)

If the expense is from a connected card that has transaction statement dates (only commercial/corporate tier card programs and select banks)

The date the expense was created

If the expense has check-in/check-out dates, the total number of days between check-in and check-out

The date that the expense was incurred

If a trip is associated with the expense, the name of the trip

If a trip is associated with the expense, the start date of that trip

If a trip is associated with the expense, the end date of that trip

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