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.

Begin by logging into Cognos Analytics.

  1. Click Team content, from the Navigation Panel.
  2. Click Finance, Facilities, and Research Administration folder.
  3. Click School or Central folder.
  4. Click Supply Chain folder.
  5. Click the report title to see the prompt page.
  1. Respond to prompts as needed to filter the report. Thee report contains all chart strings to which you have access.
  2. Click Finish. Result: the report appears in HTML or your default format.

Prompt Name

Prompt Description

Date Options

  • From Yesterday to Today: Use this prompt to automatically choose Submission Date Range for last two days. Tip: This is handy choice if you need to setup a recurring schedule
  • For the Last 7 Days: Use this prompt to automatically choose Submission Date Range for last seven days. Tip: This is handy choice if you need to setup a recurring schedule
  • User Defined Date Range: Use this prompt to filter report by From Submission Date To Submission Date (after 1/28/16)

Transaction Type

  • Unreconciled: Use this prompt to filter report for Corporate Card transactions without an expense report.
  • Reconciled: Use this prompt to filter report for Corporate Card transactions with an expense report. Tip: Chart string prompts become available when you choose this option.
  • Both: Use this prompt to filter report by employee ID or name.

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

  • Tree (As of Today): Select one or more department node.
  • Department Search & Select: Search and Select for one or more departments.

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.

Unreconciled report example

sc034-Unreconciled.jpg

Reconciled report example

sc034-Reconciled.jpg

Both - Unreconciled and Reconciled report example

sc034-both.jpg

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

  • blank – unreconciled
  • Not submitted – saved and budget checked but not submitted
  • Submitted -  for approval
  • Posted – fully approved and reconciled

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 7, or consultant@northwestern.edu.



Keywords:bi "business intelligence" era reporting cognos analytics "supply chain" sc ffra nufin   Doc ID:82175
Owner:Data Management & Analytics (DMA) .Group:Northwestern
Created:2018-05-10 07:45 CSTUpdated:2019-02-04 10:59 CST
Sites:Northwestern
Feedback:  0   0