Citibank® Commercial Cards

Appendix C: Report Formats

Report Name: Quarterly Vendor Summary by MCC Control Unit Listing (C.38.2.k)
Report Number: TBR 650
Frequencies Available: Quarter, fiscal quarter, annual, fiscal year
Level of Detail Selected: Detail
Dollars Reflected on Report: Real and/or memo
Sort Order: Unit, MCC, supplier descending from highest net spend
Agency Benefits: Provides a supplier listing with a five-quarter spending history

Report Description

This report provides a detailed analysis of a unit's spending over a five-quarter (fiscal or calendar) period. Data is sorted by Merchant Category Code, then by net spend within that MCC group. This report offers five quarters of transaction totals, and Year-to-Date total spend. Totals are calculated for the unit.

Additional information includes:

  • Total spend with each supplier, in each period
  • Number of purchases in each period
  • Average purchase amount in each period
  • Percentage of total spent with each supplier in the current period and in YTD
DETAIL LEVEL
  QUARTERLY VENDOR SUMMARY BY MCC

Click on the image above to enlarge

Featuer 1.1.11 Merchant Category [Quarterly Summary] (C.38.2.k)

Pictorial Depiction
Merchant Category [Quarterly Summary] Site Name
<Event/Posting/Transaction/Processing> date for dynamic date range: <date range>
<hierarchy level>
Level of Detail: <list of LCD items>
[No] additional scoping parameters are in effect.
Category Description
xxxxx xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
xxxxxxxxx
 
Fiscal Year: YYYY Q1: Q2: Q3: Q4:
Count of Transactions: 99,999,999 99,999,999 99,999,999 99,999,999
Amount of Transactions 99,999,999.99 99,999,999.99 99,999,999.99 99,999,999.99
Average Transaction Amount: 99,999,999.99 99,999,999.99 99,999,999.99 99,999,999.99
Cardholder Name: Card Number Amount:
xxxxxxxxxxxxxxxxxxxxx 9999 9999 9999 9999 99,999,999.99
xxxxxxxxxxxxxxxxxxxxx 9999 9999 9999 9999 99,999,999.99
Fiscal Year: YYYY Q1: Q2: Q3: Q4:
Count of Transactions: 99,999,999 99,999,999 99,999,999 99,999,999
Amount of Transactions 99,999,999.99 99,999,999.99 99,999,999.99 99,999,999.99
Average Transaction Amount: 99,999,999.99 99,999,999.99 99,999,999.99 99,999,999.99
Cardholder Name: Card Number Amount:
xxxxxxxxxxxxxxxxxxxxx 9999 9999 9999 9999 99,999,999.99
xxxxxxxxxxxxxxxxxxxxx 9999 9999 9999 9999 99,999,999.99
     
Cardholder Name: Card Number Amount:
xxxxxxxxxxxxxxxxxxxxx 9999 9999 9999 9999 99,999,999.99
xxxxxxxxxxxxxxxxxxxxx 9999 9999 9999 9999 99,999,999.99
Fiscal Year: YYYY Q1: Q2: Q3: Q4:
Count of Transactions: 99,999,999 99,999,999 99,999,999 99,999,999
Amount of Transactions 99,999,999.99 99,999,999.99 99,999,999.99 99,999,999.99
Average Transaction Amount: 99,999,999.99 99,999,999.99 99,999,999.99 99,999,999.99
Cardholder Name: Card Number Amount:
xxxxxxxxxxxxxxxxxxxxx 9999 9999 9999 9999 99,999,999.99
xxxxxxxxxxxxxxxxxxxxx 9999 9999 9999 9999 99,999,999.99






Run Date/Time 12/5/1997 4:50pm    Page 1 of 1