How can we help?

How to Run Reports

Administrators can generate a wide variety of reports through the Administrator Site:

  1. Cardholder Activity Reports
  2. Cardholder Status Reports
  3. Business Account Activity Reports

Reports on transaction activity are limited to 3 months’ worth of activity per report or 25,000 records.

  • For data older than 12 months, contact Client Services at 1-866-685-1898, option 3

How To Run Reports Now:

  1. Log into the Administrator Site
  2. Click the “Reports” tab 
  3. Click “Reports” in the blue bar
  4. Select the "Run now" radio button 

    How_to_Run_Reports_17.png

    Click the "Run now" radio button to run a report immediately 

  5. Click on the "Report type" drop down to see the reports available to you
  6. Click on the report you want

    How_to_Run_Reports_6.png

    Click the “Report Type” dropdown to see the reports available to you. Click on the report you want.

  7. Select the Start Date and End Date for the report period
  8. Or select from the following “Quick set” time parameters:
    • Today
    • This month
    • Last month
    • Since this time last month
  9. Click "Generate HTML" to see report details, and to print the report
  10. Click "Generate CSV" to download the report into a CSV format

 

How to Schedule a Report:

  1. Log into the Administrator Site
  2. Click the "Reports" tab
  3. Click "Reports" in the blue bar
  4. Click the "Schedule" radio button 
  5. Click the dropdowns to select the report you want, and when you want it to run
  6. Click the green "Schedule report" button

How_to_Run_Reports_18.png

Click the "Schedule" radio button to schedule when reports are run

 

How to See Completed and Scheduled Reports:

  1. Log into the Administrator Site
  2. Click the "Reports" tab
  3. Click "Report Queue" in the blue bar to see:
    • Completed reports, ready for download
    • Scheduled reports

How_to_Run_Reports_10.png

Click "Report Queue" to see completed and scheduled reports

How to Customize Reports

  1. Log into the Administrator Site
  2. Click the "Reports" tab
  3. Click "Reports" in the blue bar
  4. Click the "Run now" radio button
  5. Click the green "Generate HTML" button
  6. Select which columns you want to see on the HTML report
    • Click the Column icon at the top right of the screen
    • From the menu, choose which columns you want to display
    • Click the green "Change columns" button

How_to_Run_Reports_13.png

Click the Column icon. Select columns to customize a report

Report Types

The PEX system can generate a wide range of useful reports:

Settlements

  1. Spend by card - List transactions grouped by card
  2. Spend by category - List transactions grouped by spend category
  3. Spend by group - List all transactions by cardholder group
  4. Spend by transaction - List all transactions by date
  5. Settlement detail - List all transactions by date
  6. Authorized amount vs settled amount - Compare authorization amount and final settlement amount for all transactions

Authorizations

  1. Authorization detail - List all card-authorization transactions by date
  2. Declined authorizations - List all card-declined transactions by date
  3. Expired authorizations - Authorizations that expired without being settled
  4. Outstanding authorizations - Authorizations that have not yet been settled

Funding

  1. Business account funding transactions - List all business account fund transactions by date
  2. Card funding transactions - List all card funding transactions by date

Status

  1. Cardholder available balance - List all cardholders and their available balance and status
Was this article helpful?
0 out of 0 found this helpful