XBRL GL Overview The HUDFHA Pilot

1
XBRL GL OverviewThe HUD/FHA Pilot

• International Consortium on Governmental
  Financial Management
• February 1, 2006
• Gianluca Garbellotto DynAccSys
• XBRL GL Working Group

2
Agenda

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

3
Scope and role of XBRL
XBRL Financial Reporting
XBRL GL, the Journal Taxonomy
External Business Reporting
Business Operations
Internal Business Reporting
Investment, Lending, Regulation
Economic Policymaking
Processes
Investors
Financial Publishers and Data Aggregators
Companies
Central Banks
Participants
Auditors
Trading Partners
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.
Posting Journal
Invoice
Distribution To GL Report
Source Journal
General Journal Transaction Posting
Journal History Report
Consolidating/ Consolidated
5
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
Modular and Reusable/Generic

• Core has common elements, lays out the
  framework
• Jurisdictional add-ons
• Functional add-ons
• Industry add-ons
• Other add-ons

One or many types of entry groupings
One or more entries
One or more detail lines per entry
7
The Story at HUD/FHA

• DynAccSys hosts one of the many legacy systems
  that are part of HUD/FHAs 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

8
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
Business Analysis
MAPPING TO XBRL GL
PMS AP/AR
Next Things
10
XBRL GL

• The use of XBRL GL as a data standard will
• Streamline the process and reduce processing
  time
• Eliminate the need for manual data integration
  and manipulation
• Eliminate time consuming reconciliation
• Enhance the reusability of the same information
  across different systems and processes.

11
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

12
Resources

• Whats 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_at_xbrl.org

13
Contact Information

• Gianluca Garbellotto
• XBRL Business Manager, DynAccSys
• XBRL GL Working Group
• ggarbellotto_at_dynaccsys.com