Skip to main content
All CollectionsTransactionsAdmins
How do I filter and export transaction data in Spend Center?
How do I filter and export transaction data in Spend Center?

Learn how to manage which transactions display on the Transactions page on a web browser or the mobile app.

S
Written by Spend Center
Updated over 9 months ago

Any user can filter the Transactions page on a web browser or mobile device. Transaction filters include date range, spender name, transaction amount, and card.

When viewing transactions on a web browser, you can also manage which columns display on the page and export data based on your filters.

Note: You cannot export transaction data from the mobile app.


Web Browser

Video Walkthrough

Steps

Open Transactions

In the Navigation Menu, click the Transactions link.

Filter Transactions

You may only want to export a portion of your transactions within a specific time-frame or even a specific user. The filter feature can help you do this.

  1. To filter the data displayed in the Transactions page, click the Add Filter link.

  2. You can filter by date range, receipt status, transaction amount, completion status, pending status, review status, approval status, lock status, sync status, name, card, and merchant.

  3. To apply transaction filters, click the Done button.

Manage Column Settings

  1. To view column settings, click the Columns icon.

  2. To hide a column on the Transactions page, click the checkbox for the column. Some columns are locked and cannot be hidden.

Export Transactions

Once you have customized your transactions page, you can export the data displayed on the page.

  1. To export transactions, click the Export icon. Then select the file type you want to download or export receipts only.

  2. To only export visible columns, click the Only export visible columns checkbox. If you have the Only export visible columns checkbox selected, any hidden columns will not export.

  3. To confirm you want to export your transactions, click the Export button. Transaction exports may take several minutes to be available to download.

  4. You can view in-progress exports in the Export Viewer. To cancel the export, click the Cancel link.

  5. Successful exports display the Checkmark icon. To download the file export, click the Download link.

  6. Failed exports display the Warning icon. To retry the export, click the Retry link.


Mobile App

Filter Transactions

  1. In the Navigation Bar, tap the Transactions icon. If the Transactions icon is not in your Navigation Bar, tap the More icon, then tap the Transactions link.

  2. Tap the Filter icon.

  3. Tap the field(s) for the filter(s) you want to apply. You can filter transactions by date range, amount, completion status, pending status, review status, lock status, approval status, receipt status, sync status, spender name, and merchant.

  4. To apply your selected filters, tap the Apply link. To clear all filters, tap the Clear filters link.

  5. When filters are applied, the Filter icon displays the number of filters. To remove a filter, tap the Remove icon.


© 2024 JPMorgan Chase & Co.

Did this answer your question?