Card Acquiring Service (CAS) 

Reconciliation: iQ to CIR
Page 2 L EAD ∙ T RANSFORM ∙ D ELIVER

• This webinar has been pre-recorded

• To comply with the rules outlined by Treasury’s Legislative 

and Public Affairs Division, no presenter(s) will disclose their 

identifies. 

• Please submit all questions to the CAS Outreach Mailbox

– CardAcquiringService@fiscal.treasury.gov

– Title SUBJECT LINE as: CAS Reconciliation Question 

– Please provide your name and agency in the body of 

the email.

Housekeeping

Guidelines of today’s session
Page 3 L EAD ∙ T RANSFORM ∙ D ELIVER

Objectives:

• To educate agencies on reconciling card transactions from start to 

finish, while supplying tips, tricks and best practices for utilizing the 

iQ portal designed by Worldpay from FIS and Treasury's’ Collections 

Information Repository (CIR).

How:

• Supplying agencies with a high-level synopsis of the Card Acquiring 

Service (CAS) policies and procedures, outlined in the Treasury 

Financial Manual (7000) Volume 1, Part 5: Credit and Debit 

Transactions

• Define iQ and CIR

• Help our participants with understanding the crosswalk of 

terminology between reporting systems

• Delivering a simulated demonstration of iQ and CIR. 

Purpose: Why are you here?
Reconciliation
Page 5 L EAD ∙ T RANSFORM ∙ D ELIVER

• The card rules apply to federal agencies that are collecting 

or intend to collect obligations via credit or debit card. In 

addition to these requirements, an agency also must 

comply with and be bound by the rules and regulations 

governing all debit and credit card transactions accepted by 

the agency (collectively, the Network Rules), any of which 

may be altered or amended periodically and without notice.

Policies: CAS governing policies

• The TFM is the Department of the Treasury’s (Treasury’s) 

official publication of policies, procedures, and instructions 

concerning financial management in the Federal 

Government.

What is the Treasury Financial Manual (TFM)?

What are the CAS Card Rules?
Page 6 L EAD ∙ T RANSFORM ∙ D ELIVER

Policies: TFM Guidance on Reconciliation

• Reconciliation (referenced)

– Section 7020: Application

• The Financial Agent assigns an account number to each new 

account that an agency establishes. An agency must designate 

on its application a point of contact for each account. This point of 

contact is responsible for ensuring that proper reconciliation of 

Card activity occurs at the organization.

– Section 7070: Training of Key Personnel

• The Financial Agent offers training on its reporting tool, including 

such topics as reconciliation, reporting, and chargebacks.
Page 7 L EAD ∙ T RANSFORM ∙ D ELIVER

• iQ is a one-stop reporting tool that houses all cardholder 

information for credit/debit transactions, and other relevant 

financial analytics and business intelligence. 

Reporting System: What is iQ?

Access clear, detailed, and 

up-to-date sales 

performance figures for each 

line of business. 

Configure and customize 

data viewing and delivery 

options so the focus is on 

what’s most important.

Drill down into financial, 

operations, and chargeback 

management data to 

measure performance.
Page 8 L EAD ∙ T RANSFORM ∙ D ELIVER

• The Collections Information Repository (CIR), is a Fiscal 

Service-wide transaction broker, data warehouse, and 

reporting solution. CIR is:

Reporting Systems: What is CIR?

A collections reporting tool used for Federal Program Agencies to manage 

revenue

The primary mechanism for collections data reporting, containing detailed 

and summarized records of all revenue collections transactions processed 

by Fiscal Service

A system where data is standardized and optimized for reporting and for 

business analytics
Card Simulated Demonstration 
Page 10 L EAD ∙ T RANSFORM ∙ D ELIVER

• Department of the ABC (Sesame City) submitted an email to CAS team 

on March 9, 2018, indicating they were experiencing issues with 

reconciling their end- of-day balance for January 7, 2018. The issue that 

has been identified is that the organization’s end-of-day receipts are not 

matching the Card Detailed Report, located within the Collections 

Information Repository. CAS must assist the agency with addressing 

these issues within 24 hrs. of being notified of the challenge.

• Department of the ABC – Sesame City

– ALC: 11111111

– Chain: 0F000B

– Division: 001

– Merchant ID: 4445020000001 

– Transaction Date & Time: January 6, 2018 @ 11:38PM

– Transaction Amount: $51.35

Demonstration: Card-Present Use Case
Page 11 L EAD ∙ T RANSFORM ∙ D ELIVER

1. Customer Transaction Receipt - View Receipt for the MID, Date, 

Time, Card #, and Transaction Amount 

2. Agency Terminal Summary Report 

3. Credit Card Daily Transaction Report

4. CIR Card Detail Report

Demonstration: Card Transaction Artifacts 
Page 12 L EAD ∙ T RANSFORM ∙ D ELIVER

1. Customer Transaction Receipt

2. Agency Terminal Summary Report 

3. Credit Card Daily Transaction Report - # of Transactions = 105

4. CIR Card Detail Report - # of Transactions = 104

Card Transaction Artifacts (cont.)
Page 13 L EAD ∙ T RANSFORM ∙ D ELIVER

• Step 1: Log into iQ

• Step 2: Research Transaction Approval - Go to the left side menu on the 

Home page and click on Reconciliation > Transaction Research

iQ: Transaction Research Function
Page 14 L EAD ∙ T RANSFORM ∙ D ELIVER

• Step 3: Populate prompts to retrieve transaction(s). 

– Hierarchy Level: CHAIN

– Enter a value or click + to lookup: CHAIN VALUE (0F584B)

– Select Transaction Date Range: 1/6/2018 to 1/8/2018

– Enter Transaction Amount - $51.35 

– CLICK SEARCH

iQ: Transaction Research Function
Page 15 L EAD ∙ T RANSFORM ∙ D ELIVER

• Step 4: Review Transaction Details

– Transaction Initiation Time and Date

– First 6/Last 4 of Card Number

– Transaction Amount - $51.35 

– Response Code

• Step 5: Log Out of iQ – Click the “green” person silhouette in the top 

right corner of webpage > Sign Out

iQ: Transaction Research Function
Page 16 L EAD ∙ T RANSFORM ∙ D ELIVER

• US Treasury Reports 

– MD-410: Credit Card Processing Detail Report - Daily report that 

provides a detailed listing of credit card chargebacks and credit 

miscellaneous adjustments broken out by division and store number. 

The report also provides chargeback count and amount totals at the 

division and chain levels. 

– MD-493: Summary of CA$HLINK File Data by 

CHAIN/DIV/MERCHANT – Report that provides summary level data 

broken out by Chain, Division and Merchant ID. The report generated 

provides data captured within the file sent to Treasury’s Collections 

Information Repository (CIR).

iQ: Standard Reports Overview 
Page 17 L EAD ∙ T RANSFORM ∙ D ELIVER

• Step 1: Log into the Collections Information Repository (CIR)

– Click LOGIN

– Select PKI Certificate

– Enter Single Sign-On PIN 

CIR: Application Log-in
Page 18 L EAD ∙ T RANSFORM ∙ D ELIVER

• Step 2: Generate CIR Reports - Click LAUNCH REPORTS on the Menu 

bar

CIR: Application Homepage
Page 19 L EAD ∙ T RANSFORM ∙ D ELIVER

• Step 3: Reports Home Page - Click DOCUMENTS which will direct you 

to the CIR Reports Folder.

CIR: Reports Homepage
Page 20 L EAD ∙ T RANSFORM ∙ D ELIVER

• Agency Reports

– Voucher Reports: These reports provide users with a list of 

vouchers matching the selected search criteria.

• Reporting Program/Subprogram = Card Acquiring Service

• Agency Location Code (ALC) = 11111111

• Agency Account ID = Data field for Chain/Division (No Spaces)

– E.g. 0F000B001

• Comerica Collections Account Number (CAN) = (010121)

– Financial Transaction Reports: The Financial Transaction 

Summary Report provides the user a list of financial transactions 

matching the selected search criteria including non-financial 

transactions that are not associated with a voucher. 

• Same search criteria as Voucher Reports

• Initial Location = Merchant ID Number 

– E.g. 4445020000001

CIR: Standard Reports Overview
Page 21 L EAD ∙ T RANSFORM ∙ D ELIVER

• Agency Reports

– Card Reports: These reports provide the user with a list of card 

transactions matching the selected criteria. 

• Reporting Program/Subprogram = Card Acquiring Service

• Agency Location Code (ALC) = 11111111

• Merchant ID = 4445020000001

• Chain and Division (No Spaces)

– E.g. 0F000B001

• Partial Card Number (% Wildcard) – Last 4 of the card number

– E.g. %8744

CIR: Standard Reports Overview
Page 22 L EAD ∙ T RANSFORM ∙ D ELIVER

• Step 4: Reports Folder - Click AGENCY REPORTS 

• Step 5: Reports Folder – Click CARD REPORTS 

CIR: Public Reports Folder
Page 23 L EAD ∙ T RANSFORM ∙ D ELIVER

• Step 6: Report Prompts Screen - Click CARD SUMMARY REPORT to 

open reporting prompts 

• Step 7: Populate Prompts 

– Business Date: Select Business Date Range

– ALC: 11111111

– Start/End Business Date: 1/6/2018 – 1/8/2018

– Amount: 51.35

– MID: 4445020000001

– Partial Card Number: %8744 

• Step 8: Generate Report – Click OK

CIR: Card Summary Report Prompts
Page 24 L EAD ∙ T RANSFORM ∙ D ELIVER

• Step 9: Card Summary Report - Click the hyperlinked SOURCE 

FINANCIAL TRANSACTION ID to see card details 

CIR: Card Summary Report
Page 25 L EAD ∙ T RANSFORM ∙ D ELIVER

• Step 10: Card Detail Report – View report to verify transaction 

CIR: Card Detail Report
Page 26 L EAD ∙ T RANSFORM ∙ D ELIVER

Use Case Recap: What happened

• The card transaction was initiated on 

01/06/2018 at 23:38 (11:39 PM EST). 

• The standalone terminal was 

batched out at 01/07/2018 at 

00:01 (12:01 AM EST).
Page 27 L EAD ∙ T RANSFORM ∙ D ELIVER

Webinar Recap: What have you learned?

Apply

Complete CAS Application to establish or 

add to a card servicing account. Apply for an account with CIR and iQ

Understand

Taught how to utilize reporting applications for daily, monthly, or annual reconciliation 

processes. 

Educate

Delivered understanding of TFM, Chapter 

7000 

Provided informational overview of CIR 

and iQ
Next Steps
Page 29 L EAD ∙ T RANSFORM ∙ D ELIVER

Next Steps - What’s up next?

We are asking participants to refresh themselves with the 

TFM, https://tfm.fiscal.treasury.gov/v1/p5/c700.html

Complete the post-webinar survey on CAS website

Submit questions to the CAS Outreach Mailbox 

(CardAcquiringService@fiscal.treasury.gov) 

2

1

3
Page 30 L EAD ∙ T RANSFORM ∙ D ELIVER

Upcoming Webinars: Save the Date
QUESTIONS?

Submit questions via the CAS Outreach Mailbox

CardAcquiringService@fiscal.treasury.gov
L EAD ∙ T RANSFORM ∙ D ELIVER

Contact Information

Page 32

CAS Agency Outreach Mailbox

CardAcquiringService@fiscal.treasury.gov

ARM Mailbox

ARM@fiscal.treasury.gov

For More Information 

CAS Online: www.fiscal.treasury.gov/cas
APPENDIX 
Page 34 L EAD ∙ T RANSFORM ∙ D ELIVER

ALC – Agency Location Code

ARM – Agency Relationship Management

CAS – Card Acquiring Service

CASA – Card Acquiring Service Application

CIR – Collections Information Repository

MID – Merchant Identification Number

TFM – Treasury Financial Manual

SSD – Settlement Services Division 

Appendix A - Glossary