Purpose

This article explains how to complete an export of your corporate card expenses and personal/out-of-pocket expenses.

Audience

This article applies to all customers with a corporate card.

Overview

Unlike a transaction export, which only includes corporate card transactions, an expense export includes all of your corporate card and personal/out of pocket expenses.

Additional resource: Watch our CSM Office Hours: Card Management, Part 2, video for more information.

Complete an expense export (web app)

To complete an expense export, take the following steps:

From the navigation menu, select Company Settings > Expenses > Expense Export (Figure 1).
Figure 1. Expenses settings page Expense Export button
Use the Export Range section to refine the export range for your export.
Use the Column Configurations section to further refine the information you want to include about each expense in your export.
Once you’ve set up your expense data for your export, complete the export by selecting Export at the bottom of the page. This automatically downloads your export. (Note: If no expenses meet the range you set for the export, an error message appears [Figure 2.] Reset your filters to include a wider range of expenses, and try your export again.)

Figure 2. Expense Export Failed pop-up window error message saying: No expense reports were found for your specified range.

Figure 2. Expense Export Failed error message

Refine the export range for the export

In the Export Range section, you can select the date range, report status, and department of the expenses you would like to export. You can also set your export to only include reimbursable expenses.

To add a report status or department, select an option or options from each field’s dropdown options (Figure 3) and select Save. The default selection for the Select Report Status field is “All Report Statuses,” and the default selection for the Department field is “All Departments.” The Department field also includes a search bar at the top of the field.

Figure 3. Expense Export page with the Select Report Status range highlighted and showing the field’s dropdown options

Figure 3. Dropdown options for the Select Report Status range

To remove a report status or department (that is, to deselect a selection), uncheck the checkbox to the left of the option after you’ve selected it (Figure 4), and then select Save.

Figure 4: Expense Export page; the submitted and approved options in the Select Report Status range are currently selected. There is a checkbox to the left of the option, which is circled to show that unchecking the option removes it.

Figure 4. Unselecting the selected option for the Select Report Status range

To export only reimbursable expenses, turn the Reimbursable Expenses Only toggle to On (Figure 5).

Figure 5: Expense Export page; Reimbursable expenses only toggle turned to the on position. If turned on, the export will include only expenses where payment method is reimbursable/personal card.

Figure 5. Reimbursable Expenses Only toggle

Configure the columns for the export

In the Column Configurations section, you can set how your expense data appears in your export. You can rearrange the columns, as well as rename them so they display how you want them to in your export. Custom expense fields are also available to be included in the export.

To include a column, check the column’s checkbox (Figure 6).

Figure 6. Expense Export page, Column Configurations section. A checkbox appears for each column configuration, and the boxes are checked and outlined for emphasis.

Figure 6. Select columns to include in expense export

The following columns are available for configuration, as well as any custom columns your organization has created. (Note: Columns with an asterisk are available only in expense exports, not transaction exports.)