Card activity report

Quarterly/annual audits of cardholders are necessary to ensure that limits on card accounts are appropriate for the account activities.

These audits can utilize the output from the Card Activity Report to monitor these limits. The report lists the employee ID and names, account number, statement issuer name, card status, account type, company unit, credit limit, purchase cycle counts, minimum and maximum transaction and spend amounts and the average spend amount.

With this information, the Card Activity Report allows administrators to report a variety of cardholder activity attributes, such as high, low and average transaction amounts, and identify cardholders with no activity.

To generate a card activity report:

1. Ensure that you are logged in as an administrator and have entered the administration mode.
2. From the main menu, select Administration > Overview > Card Activity.

   Note: If this report is not visible in your reports list, you will need to ensure that you have the report linked to the report group you are a member of.

   The Card Activity window appears.

3. Use the following parameters to narrow the results of your report:

   Employee filter

   Employee ID. To restrict the search to a particular individual, enter their unique employee ID in the field.

   Employee First name/Employee Last name. To restrict the search to a particular name, enter the full or partial name in the fields. For example, ‘dan’ as a first name would return account holders with names beginning with Dan, such Daniel or Danny. Entering ‘%dan’ returns names containing dan, such as Daniel or Brendan.

   Company Unit. If your organization uses company units, you can restrict the search to a particular unit (and anything lower in the hierarchy), all units or any employees not allocated to a unit. Company units are displayed in the list according to the company's hierarchical structure.

   Account Number. This option restricts the search to accounts with the same last four digits as the four you enter.

   Standard filters

   Account Issuer. This required field restricts the search to one particular account issuer or all issuers.

   Statement Ending In. An alternative to using the Statement Period or State Date/End Date fields, this option allows you to search for statements that end in one of several typical date ranges, for example, today, yesterday, current calendar week, last 28 days.

   Card Status. This option filters the report output based on the card's status: Active, Blocked, Suspended, Expired or Closed.

   Account Type. This option restricts the search to a particular account type, eg. corporate card, requisition card, or all account types.

   Card Activity. This option limits the results to cards with at least one purchase transaction within the execution range, or to those without.

4. Click Run to initiate the creation of the report, which is sent directly to the vault on completion.
5. From the main menu, select Administration > File Management > The Vault.
6. Click the Outbox folder and click the Download file icon for the relevant .xlsx file. See Download file from Vault for details.