# Presentation: 814548

## FFIS Table Maintenance

- Presented by**Darrell Kennedy and Eddie Malter**

## VEND Table Statistics

- As of April 30, 2007 – 1,355,639 records
- Active – 973,940 / Inactive – 381,699
- Active – 536,716 Non-Employees & 437,224 Employees
- Monthly increase = 10,000 plus – Approx 75% are Employees
- Non-Employees with EFT = 318,319 / 59%
- Non-Employees with DCIA waivers = 89,359 / 17%
- Employees with EFT = 415,615 / 95%
- Non-Employees 1099 reportable = 411,703 / 77%
- Non-Employees TIN Matched to IRS = 355,060 / 66%

- Office of the Chief Financial Officer

## FFIS Vendor Requests By USDA Agency 

| AGENCY | APPL ID | FY 2006 | FY 2007 |
| --- | --- | --- | --- |
| AMS | 	FF02 | 	3982 | 	2090 |
| ARS | 	FF03 | 	2994 | 	1142 |
| FSA | 	FFFA | 	4802 | 	975 |
| RD | 	FF07 | 	4293 | 	1871 |
| RMA | 	FF08 | 	1204 | 	435 |
| FAS | 	FF10 | 	2126 | 	1106 |
| FS | 	FF11 | 	20816 | 	7880 |
| NRCS | 	FF16 | 	70638 | 	32578 |
| ERS | 	FF18 | 	263 | 	119 |

- Office of the Chief Financial Officer

## FFIS Vendor Requests By USDA Agency 

| AGENCY | APPL ID | FY 2006 | FY 2007 |
| --- | --- | --- | --- |
| NASS | 	FF20 | 	340 | 	108 |
| CSREES | 	FF22 | 	815 | 	562 |
| OIG | 	FF23 | 	258 | 	67 |
| FNS | 	FF30 | 	232 | 	92 |
| APHIS | 	FF34 | 	8578 | 	4512 |
| GIPSA | 	FF36 | 	1695 | 	414 |
| FSIS | 	FF37 | 	2529 | 	1296 |
| OCFO/DASO | 	FF90 | 	3064 | 	2038 |
| TOTALS |         17 | 	128747 | 	57285 |

- Office of the Chief Financial Officer

## EFT vs Check Payment Metrics  

- The USDA initiative to increase EFT payments commenced in the fourth quarter of 2004.  USDA’s EFT Metrics performance according to the Financial Management Service guidelines progressed as follows:
- DEC 2004 = 39% EFT Payments
- DEC 2005 = 94% EFT Payments
- DEC 2006 = 97% EFT Payments
- APR 2007 = 97% EFT Payments
- Department Of Treasury, Financial Management Service Metric ratings are – a) Green = 96% or greater, b) Yellow = 90% to 96%, and Red = less than 90% . . .

- Office of the Chief Financial Officer

## IRS TIN Matching Initiative  

- The USDA initiative to validate / match FFIS VEND TINs and vendor names to the IRS database commenced in April 2006.  The purpose of this initiative is to enhance data quality control and ensure the propriety entities conducting business with USDA.  The Department’s TIN validation progress is as follows:
- MAR 2006 = 0% validation
- APR 2006 = .44% validation
- MAY 2006 = 22% validation
- JUN 2006 = 81% validation
- DEC 2006 = 88% validation
- APR 2007 = 86% validation

- Office of the Chief Financial Officer

## FSIO Review of CCR Enhancements  

- The Financial Systems Integration Office (FSIO) within the General Services Administration was formerly known as the Joint Financial Management Improvement Program (JFMIP) staff office.  FSIO is currently in the process of conducting a review of CCR enhancements (past, present, and future), and accomplish an incremental test in 2007 to validate:
- CCR requirements and compliance with the Federal Acquisition Regulation (FAR).
- CCR functionality and compatibility with CORE (Component Organization and Registration Environment).
- CCR functionality and compatibility with participating Federal agencies’ operating systems.
- Identify concerns, issues, and recommendations to be addressed by Department of Defense/CCR.

- Office of the Chief Financial Officer

## Federal Funding Accountability and Transparency Act (FFATA) 

**FFATA** of 2006 asks the White House Office of Management and Budget (OMB) to lead the development, by January 2008, of a single searchable website, accessible by the public for free that includes for each Federal award of loans and grants.  Accessible info should include:
- The name of the entity receiving the award
- The amount of the award
- Information on the award such as transaction type, funding agency, etc.
- The location of the entity receiving the award
- A unique identifier of the entity receiving the award – Dun & Bradstreet Universal Numbering System (DUNS)

- Office of the Chief Financial Officer

## Sun Trust Bank Routing Number Change 

- SunTrust Bank, headquartered in Florida, has advised the United States Department of the Treasury’s Financial Management Service (FMS) of their decision to consolidate their Automated Clearing House (ACH) routing numbers into a single routing number effective May 1, 2007.
- ABA Routing Numbers not effected are 05100002 0, 05140186 5, 05310046 5, 05500270 7, 06110079 0, 06310215 2, 06400004 6, and 08400742 7 . . .
- All other pre-existing ABA Routing Numbers will be replaced with 06100010 4 . . .
- Refer to the supplemental hand-out for additional details and POCs.

- Office of the Chief Financial Officer

## Common Agreement Numbers (CAN) Theory and Application Process

- The purpose of OCFO Bulletin #2002-006 for Common Agreement Numbers is to provide guidance on the procedures to be followed by all agencies in the use by both trading partners of the same agreement number in agency accounting for intra-departmental transactions.
- The elimination of intra-departmental activity for the consolidated financial statements requires that the same amount must exist in each trading partner’s general ledger in reciprocal accounts.
- In order to identify, confirm to trading partners, and report intra-departmental balances by general ledger account, agencies must maintain in their general ledger the information necessary to identify intra-departmental activity, by agreement, for each trading partner.  In cases where agencies fail to confirm balances to their trading partners, or confirm without researching the actual general ledger amounts and accounts, the process could result in material misstatement of the consolidated financial statements.  Refer to the supplemental hand-out for complete detail coverage...

- Office of the Chief Financial Officer