Intragovernmental Reports

Fiscal Year 2014 Comparative Status of Disposition Report

Department of Labor and Office of Personnal Management Quarterly Authoritative Source Balances

2nd Quarter 2014

1st Quarter 2014

Fiscal Year 2014 Quarterly Intragovernmental Reporting Requirements

Intragovernmental Dates

New Standard Agency Intragovernmental Quarterly Data Submission Format

Monthly UCAD Reports Fiscal Year 2014

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 2014

March Monthly UCAD Reports

  • Fund Balance with Treasury

    Monthly UCAD Reports
    MarchExcel File
    Fiscal Year 2014
    (4.39 MB)
    FebruaryExcel File
    Fiscal Year 2014
    (4.39 MB)
    JanuaryExcel File
    Fiscal Year 2014
    (4.29 MB)
    DecemberExcel File
    Fiscal Year 2014
    (4.11 MB)
    NovemberExcel File
    Fiscal Year 2014
    (4.30 MB)
    OctoberExcel File
    Fiscal Year 2014
    (4.90 MB)

  • Intragovernmental Raw Data Files Fiscal Year 2014

    Instructions for using the Intragovernmental Raw Data FilePDF file
    • 1st QuarterExcel File for ITPR Reports 3rd Quarter 2013
      (14.63 mb)
      (NOTE: If you have difficulty opening the spreadsheet in your browser, right-click on the link, select "Save Target As..." and change the extension from .zip to .xlsx. Then open the file from the saved location.)

    ITPR Reports Fiscal Year 2013

    Additional Explanation

    Material Differences Report - Additional Explanation (Part III)MS Word File for Quarter Additional Explanation
    (77 kb)

    Viewing PDF files PDF logo 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.

       Last Updated:  April 11, 2014