1 / 13

Agenda

The Final Product – The Statements AGA GWA Workshop April 21, 2004 Panel: Richard Aaronson, Department of Homeland Security David Epstein, Department of Treasury Matt Jadacki, Federal Emergency Management Agency. Agenda. DHS Challenges Key Dates and Targets for FY 04

brandy
Download Presentation

Agenda

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. The Final Product – The StatementsAGA GWA WorkshopApril 21, 2004Panel:Richard Aaronson, Department of Homeland SecurityDavid Epstein, Department of Treasury Matt Jadacki, Federal Emergency Management Agency

  2. Agenda • DHS Challenges • Key Dates and Targets for FY 04 • Directorate Reporting Process • Departmental Consolidation Process • DHS TIER and CFO Vision Architecture • Panel Discussion

  3. DHS Challenges • Implementing financial management function to support 180,000 employees and 22 disparate agencies • Implementing financial management infrastructure to support accurate and timely recording and reporting of accounting events. • Consolidation and standardization of duplicate financial functions. • Limited departmental resources

  4. DHS Challenges

  5. DHS Financial Reporting Success for FY 2003 • Three Day Close • 15 of 22 DHS components are more than 85% automated and integrated through TIER • Auditor Communications • 16 of 22 agencies met with auditors at least once per week • FY 03 PAR

  6. DHS Accelerated Reporting Targets and Goals for FY 2004 • Close and open communication with auditors • Planning and monitoring of milestones • Establish estimates • Establish 6/30 Hard Close • Year-end milestones • Use of TIER and CFO Vision • Extra benefits

  7. Directorate Level Preparation and Submission • Establish Cutoffs • Prepare and record estimates and accruals • Close ledger • Generate TIER report • Validate TIER for SGL relationships and balances • Sign off and submit TIER report to department

  8. Estimates and Accruals for TIER – Year End • Annual Leave • Health, Pensions, and Life • Accounts Payable • Payroll • Grants • PP&E • Claims

  9. Overview – Treasury’s Consolidated Reporting • Financial Analysis and Reporting System • Bureau Financial Systems • TIER • CFO Vision • Collects Summary Level Financial Data • Produces Financial Statements and Reports • Submits Data for Government-wide Reporting

  10. DEDICATED FINANCIAL DATA SERVER(S) FOR: - Accounting/Budget Execution Data - Web Servers for TIER and CFOV - Other Future Data Subsets FIN TFF ESF ATS DO Financial Analysis and Reporting System (FARS) • CFO Vision–On-line Analytical Processing (OLAP) Decision Support Tools • 6 Financial Statements • Monthly Financial Management Report • Generated Footnotes CORE FINANCIAL SYSTEMS 1998 - (48) 2003 - (14) CFO Vision • WebTIER • General Ledger Account Data • Budgetary Data • Detailed Data Edits • FACTS I Transmissions • FACTS II Transmissions WebTIER EXTERNAL CROSS-SERVICE PROVIDERS 23 Reporting Entities IRS TTB BEP BPA,BPF FFB FMD IRR MNT OCC BPD TREASURY BUREAU DATA OTS CDF FMS OAS OIG TIG DCP

  11. Public Internet DHS Consolidated Reporting Technical Architecture • Public Key Infrastructure • Treasury establishes “Trusted Agents” at DHS • Trusted Agents distribute Treasury personal certificates • Personal Certificates Enable Application Access • Public Internet used for transport Production Server: High Availability Apache (Web Application Server) Secure External Gateway (SEG) DHSTIER Data Access Descriptor (DAD) DHS User with Web Browser Treasury PKI Infrastructure DHSTIER Schema Oracle 9i Windows 2K

  12. Production Server: High Availability Apache (Web Application Server) DHSTIER Data Access Descriptor (DAD) DHSTIER Schema Oracle 9i Windows 2K DHS Financial Reporting Process • SAS CFOV • Financial Analysis, Reporting, and Management Tool • Hundreds of Custom Built Government Report Templates • On Demand Financial Extracts Load CFOV • Data Available at DHS for Dynamic Reporting Financial Statements, Footnotes, & other reports to DHS HQ & Bureaus Treasury SAS CFOV Server Excel & PDF Files Via Email Treasury CFO Vision DHS CFO Vision Standalone Client Detailed Extract Via FTP Multi-Dimensional Consolidation Via FTP or CD-ROM DHS Local SAS CFOV

  13. Panel Discussion and Questions

More Related