May 8, 2008

BFE LoB

Budget Execution and Financial Management Integration Workgroup Holden Hogue, FMS/Treasury Dave Harmon, OMB

Budget and Financial Management Integration Workgroup Goal

Develop solutions and/or tools that will support government-wide standards, improve data exchange within the business process, and support better reporting and decision-making at all levels.

2

Financial and Budgetary Reporting Data Exchange Current Structure

Treasury OMB Agencies

Deficiencies:

•No single source of data •Multiple data exchanges between multiple partners •Multiple schemas based on data being exchanged •Data not available electronically 3

Financial and Budgetary Current Reporting Challenges

• Financial and budgetary data is not available from a single source • Data must be obtained from multiple entities, locations and applications • Substantial resources are required to establish and maintain multiple data exchange schemas with multiple partners • Not all data is available electronically • Data exchange standards do not exist • There are inconsistencies between apportionment document (SF 132) and the budget execution (SF 133) – These must be eliminated to support automation and standard data exchange 4

Financial and Budgetary Current Reporting: Proposed Solution

Create a mechanism that will: • Provide a single point of data for financial and budgetary transactions • Provide a standard data exchange schemas • Eliminate the need to exchange data in paper form • Eliminate conflicts between reported financial and budgetary data 5

Financial and Budgetary Current Reporting

A Starting Point • Obtain the following data for use: – Apportionment data from OMB – FACTS I and FACT II data from Agencies – FACTS II required data elements (i.e., discretionary, non discretionary, X year, multiyear, etc… ) from OMB MAX • Map budget execution processes • Develop model data table requirements • Develop data exchange standard 6

Financial and Budgetary Data Exchange Concept Model: Data Exchange Proposed Structure

Treasury OMB Data Exchange Concept Model Agencies

Benefits:

•Provides a single source for budgetary and financial data •Reduces required number of exchanges •Standard data exchange schema •Makes data available electronically 7

Key Steps in Implementing the Model

• Obtain executive management buy-in • Develop the Government-wide standard data exchange model and requirements • Automate the SF 132 Apportionment and provide controls for summary level reporting • Incorporate into the OMB and Treasury FMS plans once accepted • Provide capability to feed the SF 132 into the SF 133, Budget Execution 8

Current Workgroup Projects – Steps Along the Way to a Data Store Proposed Solution Where We Are Today Touchpoints

- Identify key intersections (Touchpoints) between Budgeting and Financial Management.

Touchpoints document drafted and posted to community website. Extensive comments have been received and incorporated from the budget and financial communities. Paper has been presented to the FSIO and is now available for comment on the website.

Process Mapping

- Map budget execution processes that are common to all (or most) government agencies .

Task is in progress – several maps have been completed. Progress chart is on the community website.

9

Current Workgroup Projects – Steps Along the Way to a Data Store Proposed Solution Data Mapping

- Map data requirements and flows between Treasury, OMB and agencies

Where We Are Today

Task is scheduled to start in late July early August

Reimbursable Agreements

– Working with the BFE LoB, develop and promulgate standard business practices for intragovernmental transactions Task is just beginning. BEFMI is coordinating with the FMLOB 10

We Need Your Help!

•

Participate

in BEFMI workgroup meetings – can join by phone and Adobe Connect •

Review and Comment

on the Touch points paper on the community website at

https://max.omb.gov/community/x/QA4

•

Review and Comment

on the process maps now posted at

https://max.omb.gov/community/x/EgAFAw

• It’s an exciting time – we believe we are making progress toward solving some of the most troublesome problems confronting the budget and financial management community.

11