1 / 11

Use of Central Accounting Data (UCAD) to Reconcile

Use of Central Accounting Data (UCAD) to Reconcile. September 19, 2007 Yianting Lee. Use of Central Accounting Data - UCAD. Purpose

hayden
Download Presentation

Use of Central Accounting Data (UCAD) to Reconcile

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Use of Central Accounting Data (UCAD) to Reconcile September 19, 2007 Yianting Lee

  2. Use of Central Accounting Data - UCAD Purpose • To Improve interagency eliminations by providing agencies a tool to reconcile transactions and balances directly to Treasury Central Accounting data (authoritative data)

  3. UCAD – cont’d Benefit • To address the following reporting inconsistencies, • in agency financial statements vs. agency monthly reporting to the Treasury • Agency financial statement data not consistent with USSGL by matching with the authoritative data (one-to-one relationship from Central Accounting System to year-end financial reporting)

  4. New Transfers Categories –FY 2007 * Replacing RC 19 & 28

  5. New Transfers Categories –FY 2007 cont’d • Changes are in • FY 2007 TFM, 4705.35-Receiprocal Categories • FY 2007 Intragovernmental Accounting Policy Guide, Section 20.1

  6. Agency Generated Reports - UCAD Three types of reports for each category

  7. Summary Report by Activity Type – cont’d Set parameters for the report: Period: accounting month in Fiscal year For Example: October: Period 1

  8. Summary Report by Activity Type – cont’d Lists the Rpt title and USSGLs w/in parameters Export the report out to PDF/Excel Parameters For: AXFERC, AXFERD, BXFERC, BXFERD CXFERC, CXFERD

  9. Detail Report provides more transaction details to assist the agencies to reconcile: Transaction Reference Number in the Central Accounting Data

  10. Detail Report – cont’d Trading partner’s information

  11. Upcoming … • Reports (RC 7 & 8) are available for the agencies now • Reports can be used as a tool to assist agencies during the reconciliation process • Reports will be required to be used to reconcile the GFRS/IRAS data reporting in the future • Similar reports will be available for other authoritative data in 2008 and beyond: • FBWT • CIHO • Investments • Borrowing Activity • Net Outlays • Appropriation Warrants • … and more…

More Related