New Standard Agency Intragovernmental Quarterly Data Submission Format
Monthly UCAD Reports Fiscal Year 2011
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:
Instructions on viewing a specific accounting reporting period:
Monthly UCAD Reports
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:
Caveats to the spreadsheet:
ITPR Reports Fiscal Year 2012
ITPR Reports Fiscal Year 2011
ITPR Reports Fiscal Year 2010
ITPR Reports Fiscal Year 2009
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.