Intragovernmental Reports

Intragovernmental Dates

• Intragovernmental Key Dates
  
  

New Standard Agency Intragovernmental Quarterly Data Submission Format

• ATB-File Format
  (16 kb)

Monthly UCAD Reports Fiscal Year 2013

Monthly Use of the Central Accounting Data Report for Reciprocal Categories 07, 08, 11, Appropriation Received, as adjusted, and Fund Balance with Treasury

The monthly UCAD Report is in a Pivot table format in Microsoft Excel, providing agencies with transactions and balances at each TAS level in Reciprocal Category 07 Appropriation of Unavailable Trust or Special Fund Receipts, Reciprocal Category 08 Nonexpenditure Transfers of Unexpended Appropriations and Financing Sources, Reciprocal Category 11 Nonexpenditure Transfers of Financing Sources – Capital Transfers, Appropriation Received as adjusted, and Fund Balance with Treasury. The data is directly linked from the Treasury's Central Accounting System. Agencies should reconcile and validate the data using the reports. Each agency has its own worktab in the file. Agencies can retrieve this report on the eighth workday of every month.

Instructions on using the pivot table for both the Summary and Detail Reports:

1. Open the pivot table spreadsheet. At the bottom of the workbook select the worksheet tab that corresponds to your 2-digit agency Department code.
2. Click on the drop down box next to the "Reciprocal Category" field, select the Reciprocal Category that you desire, and click "OK."
3. From Excel menu bar, select "File", then "Print" to print the report

Instructions on viewing a specific accounting reporting period:

1. Click on the drop down box next to the "Accounting Date" field, select the date(s) that you desire, and click "OK."
2. Based on the selected parameters, the spreadsheet automatically populates with the desired information.

Fiscal Year 2013

November Monthly UCAD Reports

• Summary Monthly UCAD Reports for RC 7, 8 & 11
  (571 KB)
  
  
• Detail Monthly UCAD Reports for RC 7, 8 & 11
  (577 KB)
  
  
• Appropriations Received Monthly UCAD Report
  (112 KB)
  
  

Fund Balance with Treasury

Monthly UCAD Reports
November Fiscal Year 2013 (4.01 MB)	October Fiscal Year 2013 (4.20 MB)

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 either a verifying agency or one of the 22 expanded non verifying agencies. (TFM Announcement A-2011-01, October 2010)
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 2012

• 4th Quarter
  (12.41 mb)
  
  
• 3rd Quarter
  (10.1 mb)
  
  
• 2nd Quarter
  (10.70 mb)
  
  
• 1st Quarter
  (10.81 mb)
  
  

ITPR Reports Fiscal Year 2011

• 4th Quarter
  (12.41 mb)
  
  
• 3rd Quarter
  (11.7 mb)
  
  
• 2nd Quarter
  (8.16 mb)
  
  
• 1st Quarter
  (7.66 mb)
  
  

Additional Explanation

Material Differences Report - Additional Explanation (Part III)
(54 kb)

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.