1 / 14

XBRL GL Overview The HUD/FHA Pilot

XBRL GL Overview The HUD/FHA Pilot. Gianluca Garbellotto DynAccSys San Jose, CA January 18 th 2006. Agenda. XBRL GL, The Journal Taxonomy XBRL GL and XBRL FR The HUD/FHA Pilot Resources. Scope and role of XBRL. XBRL GL, the Journal Taxonomy. XBRL “Financial Reporting”. Business

nhu
Download Presentation

XBRL GL Overview The HUD/FHA Pilot

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. XBRL GL OverviewThe HUD/FHA Pilot Gianluca Garbellotto DynAccSys San Jose, CA January 18th 2006

  2. Agenda • XBRL GL, The Journal Taxonomy • XBRL GL and XBRL FR • The HUD/FHA Pilot • Resources

  3. Scope and role of XBRL XBRL GL, the Journal Taxonomy XBRL “Financial Reporting” Business Operations Internal Business Reporting External Business Reporting Investment, Lending, Regulation Economic Policymaking Processes Companies Financial Publishers and Data Aggregators Investors Central Banks Participants Trading Partners Auditors Regulators Management Accountants Software Vendors

  4. Standard Payload: XBRL GL Can Represent 1. Trigger: a source document is represented electronically 2. Source Journal The document is entered and posted, creating a source journal. 3. Journal entries: The accounting implications are gathered and prepared for the GL. 4. GL Entries: the journal entries are prepared for posting to the GL. 5. Journal History: The entries are posted to the Journal History. 6. Consolidation: The data at journal entry or trial balance level are brought together. 7. Reporting: Consolidated numbers combine for eventual reporting. Invoice Posting Journal Source Journal Distribution To GL Report General Journal Transaction Posting Journal History Report Consolidating/ Consolidated

  5. Journal Entries Sub Ledgers General Ledger Financial Reporting xbrlInfo xbrlInclude summaryReportingElement Business Activity Transaction Detail Source Documents XBRL GL And XBRL FR Source Systems Internal Reporting Pipeline Reporting Annual(Quarterly) Reporting Financial Systems Journalize Accounts Payable Accounts Receivable Order Entries Purchasing Fixed Assets Human Resource Payroll Regulatory Reporting Aggregation Consolidation Tax Decision Support Manual Transaction Late Entries Adjustments Manual Entries Business Activity Management Extract & Transform Financial Data Mart/ Repository Business Events Benchmark & Analysis Budgeting & Forcasting Monitor, Audit & Control

  6. The Story at HUD/FHA • DynAccSys hosts one of the many legacy systems that are part of HUD/FHA’s information system: a loan and property administration system that manages AP and AR related to loan servicing, rents, expenses related to property maintenance, tax payments and fees. • In the current architecture, a data warehouse collects legacy data and feeds them to the main general ledger. • The data warehouse has two functions: • Converting entries from MSA to SGL format • Maintain the detail information: the main GL only stores summary information

  7. The Story at HUD/FHA The use of XBRL GL will: • Streamline the process. • Eliminate the need for manual data integration • Eliminate time consuming reconciliation • Enhance the reusability of the same information across different systems and processes.

  8. US SGL Summary Entries Data Warehouse Translates MSA GL account format to US SGL The Problem… CSMS System of Record Journal detail data Summary data out of balance with transaction detail PeopleSoft INTERFACE Ongoing reconciliation MLS AP/AR Performance Budget Monthly Feed Reporting Audit INTERFACE Business Analysis PMS AP/AR Rekey data for other uses Challenge: Consistent, timely, complete and accurate data Journal detail data

  9. …The Solution CSMS System of Record PeopleSoft MAPPING TO XBRL GL Performance MLS AP/AR Budget Reporting Daily Feed Audit MAPPING TO XBRL GL Business Analysis PMS AP/AR Next Things

  10. The Solution • Benefits for HUD: • Avoid data manipulation at HUD • Reduce processing time. • Re-use of data in other systems or analytical tools • without further intervention. • Reduced reconciliation time. • This will also enable HUD to adhere to the Presidents Management Agenda (PMA) regarding Performance Improvement and Budget.

  11. XBRL GL Using XBRL as a data standard and XABRA as the tool to implement it will enable HUD to achieve: • Implementation of daily cash reporting features • Simplify financial reporting to its core financial system, PeopleSoft • Gain interoperability between systems and data reusability through standardization.

  12. What will be achieved • Meet downstream information and reporting requirements with transaction processing data linked to transaction engines • Accept standard information integration and electronic data to and from other internal, government-wide, or private-sector processing environments • “One-time” data entry and reuse of transaction data to support downstream integration, interfacing, or business and reporting requirements • Be modular in design and built with reusability as an objective

  13. Resources • What’s available to review • XBRL GL 2005, an XBRL 2.1-compliant taxonomy • Where to find it • www.xbrl.org/GLFiles • Additional resources • GaLaPaGoS – GL Practices Guide for Study http://gl.iphix.net • Questions? xbrlgl@xbrl.org

  14. Contact Information Eric E. Cohen XBRL Global Technical Leader, PwC eric.e.cohen@us.pwc.com Gianluca Garbellotto XBRL Business Manager, DynAccSys XBRL GL Working Group ggarbellotto@dynaccsys.com

More Related