Understanding the SC034 Corporate Card Activity Report in Cognos Analytics
The SC034 Corporate Card Activity Report is used to review which procurement card charges in My Wallet have been reconciled via an expense report. The SC034 can be used to review Unreconciled, Reconciled, or Both unreconciled and reconciled transactions. This is a real-time report; data is no from the previous business day.
Step 1 Navigate to the report
Begin by logging into Cognos Analytics.
- Click Team content, from the Navigation Panel.
- Click Finance, Facilities, and Research Administration folder.
- Click School or Central folder.
- Click Supply Chain folder.
- Click the report title to see the prompt page.
Step 2 Respond to prompts and run the report
- Respond to prompts as needed to filter the report. Thee report contains all chart strings to which you have access.
- Click Finish. Result: the report appears in HTML or your default format.
Prompt Name |
Prompt Description |
---|---|
Date Options |
|
Transaction Type |
|
Card Holder |
Search by entering all or part of a Card Holder Employee ID or by Name. |
Merchant |
Search by entering all or part of a Merchant Name. |
Department Prompt |
|
Project Status. |
Filter Project prompt and reports results by All Projects (Default), Active Project Only, Inactive Projects Only. |
Project |
Search and Select for one or more Project ID or its description. |
Account |
Search and Select for one or more Account ID or its description. |
Report Results
Unreconciled report example
Reconciled report example
Both - Unreconciled and Reconciled report example
Column Definitions
Indicated by Letter |
Column Name |
Column Description |
---|---|---|
A |
Merchant |
Business where the purchase was made. |
B |
Transaction Date |
Date of purchase. |
C |
Transaction Load Date |
Date transaction was uploaded to My Wallet. |
D |
Transaction ID |
My Wallet transaction number. |
E |
Amount |
Dollar amount charged in U.S. currency. Credits appear as a negative amount for merchant refunds. |
F |
Expense Report ID |
Expense report number. |
G |
Expense Report Status |
|
H |
Description |
Line description from Detail tab in expense report. |
I |
Chart strings |
Chart strings. |
For additional assistance please contact the IT Support Center at 847-491-4357 (1-HELP) option 2, or consultant@northwestern.edu.