# Presentation: 718617

## USDA Financial Indicators

- Presented by**Donna Bateman and Charles Burns**

## USDA Financial Indicators

- Government-wide Metric Tracking System (MTS)
- USDA Financial Indicators
- USDA Financial Indicator Scorecard
- Areas of Improvement Needed for USDA

- Office of the Chief Financial Officer

## Metric Tracking System (MTS)(Government-wide) 

- MTS Overview
- Achievements to Date
- Performance Improvement
- Where is the Metrics Program Heading?
- (All information in this section taken from a Briefing by
-  Adam Goldberg, OMB, Office of Federal Financial Management,
-  202-395-7583)

- Office of the Chief Financial Officer

## MTS Overview

- What is MTS?
- A performance measurement system that captures key financial management indicators across the Federal government
- What is its purpose?
- Provide stakeholders information to assess the financial management health of the Federal government
- What is its objective?
- Help guide financial management reforms to areas where better stewardship is needed

- Office of the Chief Financial Officer

## MTS Overview

- Who is responsible for MTS?
- Performance Measurement Committee of the Chief Financial Officers (CFO) Council
- Performance Measurement Committee chaired by Kathleen Turco (CFO, General Services Administration)
- Steering committee members represented by OMB, GSA, DoD, and Treasury
- Subject matter experts from across government
- Working group comprised of agency personnel

- Office of the Chief Financial Officer

## MTS Overview

- What is the MTS team responsible for doing?
- Developing and refining a series of baseline and target financial metrics
- Establishing a rigorous, consistent, and systematic agency reporting process
- Implementing a centralized system/database where data and results can be readily viewed by interested parties
- Improving agency and government-wide performance in areas where the metrics show deficiencies

- Office of the Chief Financial Officer

## MTS Overview

- What is reported in MTS Public?
- 9 government-wide financial and programmatic metrics
- Agency ranking page
- Ranking for current and 3 prior months
- Performance measure for each month
- Agency specific page
- Underlying data for each measure
- Graphic illustrating current and past performance
- Metric description
- What does it measure?
- Why is it important?
- Goals
- Traffic light performance symbol
- Industry and actual performance driven goals

- Office of the Chief Financial Officer

##  MTS Achievements to Date

- Developing and refining a series of baseline and target financial metrics
- Phase I metrics
- Fund Balance with Treasury
- Suspense Accounts
- Delinquent Accounts Receivable Due from the Public Over 180 Days
- Electronic Funds Transfer (EFT) Vendor Payments
- Prompt Payment
- Interest Penalties Paid
- Travel and Purchase Card Delinquencies

- Office of the Chief Financial Officer

## MTS Achievements to Date

- Developing and refining a series of baseline and target financial metrics
- Phase II metrics (estimated July 2005)
- Intra-governmental Transactions
- EFT Travel Voucher Reimbursement
- Bank Card Rebates Earned
- Competitive Grants Announced on Grants.gov
- Grant Applications Received via Grants.gov

- Office of the Chief Financial Officer

## MTS Achievements to Date

- Establishing a rigorous, consistent, and systematic agency reporting process
- Current State
- Agencies report monthly
- Agency points of contact review and validate data
- MTS team personnel review and validate data
- Contractor publishes to MTS Public
- Peer reviewers will examine agency data semi-annually  - **NEW**
- Future State
- Incorporate metric requirements into Core Financial System Requirements
- Load data (when available) automatically into MTS from source (e.g., Treasury, GSA, department financial systems)

- Office of the Chief Financial Officer

## MTS Achievements to Date

- Improving agency and government-wide performance in areas where the metrics show deficiencies
- Performance Improvement Framework

- Office of the Chief Financial Officer

## MTS Performance Improvement

- How is the Federal government performing?
- Where is performance ‘Green’?
- Fund Balance with Treasury
- Interest Penalties Paid
- Bank Cards (Centrally Billed)
- Where is performance lagging?
- Suspense
- Delinquent Accounts Receivable Due from the Public Over 180 Days
- EFT Vendor Payments
- Prompt Payment

- Office of the Chief Financial Officer

## MTS Performance Improvement

- MTS  data for all government agencies can be obtained at _[www.fido.gov](http://www.fido.gov/)__ _
- Full Public Access
- Chief Financial Officers’ Council Metric Tracking System - Public

- Office of the Chief Financial Officer

## USDA Financial Indicators

- Developed a series of financial indicators for USDA agencies.  Includes:
- Government-wide MTS indicators
- Indicators used by USDA for internal management
- Target audience:
- Agency financial staff
- CFOs
- Agency administrators
- Undersecretaries

- Office of the Chief Financial Officer

## USDA Financial Indicators

- Internal Financial Metrics
- Understated Budgetary Resources
- IPAC Clearing Account
- Property Suspense Clearing and Inventories
- Government-wide Metrics
- Metrics discussed under MTS plus
- Treasury 224 Reporting Timeliness & Accuracy
- Material Weaknesses and FFMIA Compliance
- Trading Partner ’00’ Usage

- Office of the Chief Financial Officer

## USDA Financial Indicator Scorecard

- Office of the Chief Financial Officer

## USDA Financial Performance Improvement 

- Where is Performance Green at the USDA Level?
*Fund Balance with Treasury*
- Delinquent Accounts Receivable from Public
- Interest Penalties Paid
- Where is Performance Lagging?
- EFT
*Budget Clearing Account (F3875)*
- IBA and CBA Travel Card Delinquencies
- Prompt Payment Statistics Fluctuate
- All the rest....

- Office of the Chief Financial Officer

## Semi-annual exam of agency data by peers

- Fund Balance At Treasury (metric #1)
- For Treasury Symbols on FFIS
- Support will come from ACRWS application
- For Treasury Symbols _not_ on FFIS
- Currently have agencies representation that symbols are reconciled
- In future, will need monthly schedule of ledger and closing Treasury balance by Treasury symbol with difference tying to reconciliation
- Treasury Suspense – 12F3875 (metric #2)
- Current COD-maintained database of uncleared ledger items will serve as support.
- Important to ensure g/l balance reconciled to Treasury

- Office of the Chief Financial Officer

## Where is Performance Lagging?Suspense Accounts

*Budget Clearing Account (12F3875)*
- Reports transactions uncleared after 60 days of posting
- On a Net and Absolute $ basis
- Requires tracking at the detail transaction level to age properly and derive absolute value
- COD maintains database of unmatched g/l entries and send reports items by age each month
- Agency POC’s identify transactions to match manually if required
- COD contact is Fred Dean (504-426-2201)

- Office of the Chief Financial Officer

## 12F3875 Uncleared dollars (net) and volumes at 12-31-04

- Office of the Chief Financial Officer

## 12F3875 Uncleared dollars (absolute) at 12-31-04

- Office of the Chief Financial Officer