GFRS/FACTS I/IFCS

Intragovernmental Reports

Reciprocal Categories by USSGL Account

• Fiscal Year 2009
  (153 KB)

New Standard Agency F-file Submission Format

• New F-file format for Fiscal Year 2009 (27 KB)

IRAS vs. UCAD Reports Fiscal Year 2009

Reciprocal Categories 2007 & 2008 vs. Use of the Central Accounting Data Report

The Reciprocal Categories 07 & 08 vs. UCAD Report is a spreadsheet in Pivot table format, providing agencies a data comparison between the Treasury's Central Accounting System and IRAS. This report compares intragovernmental balances in Reciprocal Category 07 Appropriation of Unavailable Trust or Special Fund Receipts and Reciprocal Category 08 Nonexpenditure Transfers of Unexpended Appropriations and Financing Sources.

Instructions on using the pivot table:

1. Click on the drop down box next to the "Reciprocal Category" field, select the Reciprocal Category that you desire, and click "OK."
2. Click on the drop down box next to the "Department" field, select your Department, and click "OK."
3. After the Department is selected, the spreadsheet will automatically populate information for the set parameters.

• 1st Quarter (160 KB)

Individual Trading Partner Reciprocal Report (ITPR)

The Individual Trading Partner Comparison Report (ITPR) is a spreadsheet in pivot table format, providing agencies with additional information that is not on the Intragovernmental Activity Detail and Intragovernmental Reciprocal Category Reports. This information includes agencies' fund titles, fund account groups, and Standard General Ledger accounts to assist agencies with their reconciliation process.

Instructions on using the pivot table:

1. Click on the drop down menu next to "Your Agency" field, select your agency code, and click "OK."
   
2. Click on the drop down menu next to "Trading Partner" field, select your partner code you wish to see, and click "OK."
   
3. Click on the drop down menu next to the "Recip Category" field, select the reciprocal category you wish, and click "OK."
   
4. Click on "Run" button in the red box.

Caveats to the spreadsheet:

1. Both the reporting agency and the trading partner must be a verifying agency.
2. Do not click on any drop down menu on the Partner’s side.
3. Only select one trading partner at a time from the drop down menu.
4. Only select one reciprocal category at a time from the drop down menu in order to work.

ITPR Reports Fiscal Year 2009

• 2nd Quarter (6,844 KB)
  
  
• 1st Quarter (6,390 KB)
  
  

Reciprocal Categories 2008 vs. Use of the Central Accounting Data (UCAD)
Report Fiscal Year 2009

• 4th Quarter (7,898 KB)
  
  
• 3rd Quarter (7,440 KB)
  
  
• 2nd Quarter (7,228 KB)
  
  
• 1st Quarter (7,464 KB)
  
  

Reciprocal Categories 2007 vs. Use of the Central Accounting Data (UCAD)
Report Fiscal Year 2009

• 4th Quarter (8,376 KB)
  
  
• 3rd Quarter (9,245 KB)

Fiscal Year 2009 Additional Explanation

Additional Explanation
(54 KB) November 6, 2008

Viewing PDF files requires Acrobat Reader which is included in many Web browsers. If your browser does not read Acrobat's pdf files, the Acrobat Reader is free to download and use.