390 likes | 510 Views
Rural Development ARRA Recipient Reporting. Webinar June 29, 2010. Introduction. Speakers Jacki Ponti-Lazuruk, Recovery Act Implementation Coordinator, Rural Development, USDA Rachel Beattie, Team lead, Recipient Reporting, Rural Development, USDA Format for Webinar
E N D
Rural DevelopmentARRA Recipient Reporting Webinar June 29, 2010
Introduction • Speakers • Jacki Ponti-Lazuruk, Recovery Act Implementation Coordinator, Rural Development, USDA • Rachel Beattie, Team lead, Recipient Reporting, Rural Development, USDA • Format for Webinar • 30-45 minutes of presentation • Remaining 45 minutes for questions • Questions need to be submitted via the Questions feature of the Webinar • Teleconference bridge is “listen” only
Objectives • Discuss requirements for Recipient Reporting • Review consequences for non-reporting • Review reporting cycle timeline • Review available resources to recipients • Discuss what is required to get started for Recipients • Summary • Questions and Answers
Requirements for Recipient Reporting • American Recovery and Reinvestment Act of 2009 (ARRA) • Section 1512 covers Recipient Reporting: “(c) RECIPIENT REPORTS— Not later than 10 days after the end of each calendar quarter, each recipient that received recovery funds from a Federal agency shall submit a report to that agency that contains—…” • Who is required to report under the Recovery Act? • Prime Recipients: Non-Federal entities that receive greater than $25,000 in Recovery Act funding as Federal awards in the form of grants or loans • Sub Recipients: Non-Federal entities awarded Recovery funding through a legal instrument from the Prime Recipient • What happens to the submitted data? • The submitted data is published to Recovery.gov for public review on the 30th of the month of the Reporting Cycle • The remaining 60 days of the Reporting Cycle are dedicated to data quality improvement • Is it a big deal if you do not report? • Yes, it is a big deal!
Consequences for non-compliant reporters • Why do recipients need to report? • Ensure that the American public has a clear understanding of the use of Recovery Act funds • Not reporting could put your award at risk • What is the definition of non-compliant recipient? • Those who are persistently late or negligent in their reporting obligations • Further action is taken if a recipient is non-compliant for two or more consecutive reporting quarters • What happens when you non-report? • Recipients who have failed to submit a Section 1512 report as required by the terms of their award are considered to be non-compliant • What are the consequences for being a non-compliant recipient? • Are subject to Federal action, up to and including the termination of Federal funding or the ability to receive Federal funds in the future. • In some cases, intentional reporting of false information can result in civil and/or criminal penalties
Recipient Reporting Cycle Timeline (June-July 2010) Jun 30 Jul 15 Jun 5 Jun 10 Jun 15 Jul 5 Jul 10 Jul 20 Jul 25 Jul 31 • 6/9-7/14: • Rolling registration on CCR • As soon as funds have been obligated, a recipient may begin registration process 7/15-7/20: 7/21-7/22 Recipients • 7/1-7/14: • Initial Submission phase • Recipient filing window • Recipient Late submission period • Recipient correction period • No new reports, just corrections to existing records filed 6/29 • Recipient Webinar • 7/23-7/29: • Agency review period to provide comments to recipient reports • 7/1-7/20: • “View” only access to recipient-filed reports on FederalReporting.gov Rural Development point of contact Represents where we are currently (6/29)
Recipient Reporting Schedule and significant milestones • July 1-14: Recipient filing window : Recipients need to submit reports via FederalReporting.gov • Please file as early as possible to allow for technical issues or concerns • Agencies will have “View only” access of reports and review Daily Extracts from FederalReporting.gov • Agencies will work with recipients, on a rolling basis, to make any corrections to recipient reports • Beginning July 8: Agencies will contact recipients who have not yet filed as of July 7th to remind them of submission window • July 15-20: Recipient late submission period • July 21-22: Recipient correction period. No new reports, just corrections to existing records filed • Beginning July 22: Agencies will reach out to recipients and get the reasons for not reporting • July 23-29: Agency Review Period • July 30: Data is published on Recovery.gov • August 3 – September 14: Continuous Quality Assurance (QA) Period • September 16: Final Continuous QA data published on Recovery.gov Note: Dates highlighted in Blue underline indicate major milestones for Recipients
Available resources for recipients • There are several resources available for recipients ARRA Recipients FederalReporting.gov Helpdesk USDA Rural Development (RD) Offices Training materials USDA RD Computer Locations USDA Technical Assistance Providers (NRWA and RCAP) USDA Office of the Chief Financial Officer USDA Rural Development Recipient Reporting
Available resources for recipients (con’t) • Training materials, such as presentations and webinars are available through several websites • http://www.whitehouse.gov/recovery/webinartrainingmaterials/ • Materials provide overviews of reporting requirements • Available for download in both mp3 and PDF formats • https://www.federalreporting.gov/federalreporting/downloads.do • Downloads section has templates, Recipient Reporting Data Dictionary, Webinars, User Guide, Quick Reference Guide, and Reference Data and additional links • Most are available via PDF format • Reference data section provides links for looking up codes required for report submission
Getting started: Recipients A little bit of planning goes a long way with Recipient reporting requirements • Working with your Rural Development points of contact to validate your Award ID and the DUNS number on record associated with your award • Reviewing and validating your Central Contractor Registry (CCR) registration • Determining your preferred method to report • Excel spreadsheet template • XML • Direct input on FederalReporting.gov • Understanding functions of FederalReporting.gov functions which may make reporting easier • “Copy forward” and “Linking” functions 1 2 3 4
Getting started: Recipients (con’t) 1 • Working with your Rural Development point of contact to validate your Award ID and the DUNS number on record associated with your award • Obtain Award ID from your Rural Development Point of contact • It is critical that this matches exactly (including dashes, spaces, etc.) what is provided by your Rural Development point of contact • Validate DUNS number(s) • The DUNS record the recipient plans on reporting in FederalReporting.gov should be compared against that on record with the Rural Development point of contact
Getting started: Recipients (con’t) 2 • Reviewing and validating your Central Contractor Registry (CCR) registration • For recipients with existing CCR registrations, ensure your CCR information is up-to-date and will be active throughout the reporting cycle • CCR registration must be renewed at least every 12 months and an expired registration will prevent report submission &/or modification by the recipient • Maintaining current Points of Contact in the CCR record will assure recipients that renewal reminders are received • For recipients requiring CCR registration, register with CCR and obtain a DUNS number in order to register • Re-instating an expired registration requires specific recipient actions to protect the security of the record, processing time, and additional time to update FederalReporting.gov • Recipient instructions may be found at Chapter 2 of the User Guide at the downloads page of FederalReporting.gov • Register at the FederalReporting.gov Web portal • This is the central place for submitting recipient reports related to ARRA funding
Under Administration in the Quick Links menu, click “Request FRPIN.” Getting started: Recipients (con’t) 3 • Determining your preferred method to report: Prime Recipients and Sub Recipients submit reports by entering data into forms residing on FederalReporting.gov • Requires FRPIN, which must be requested via FederalReporting.gov Create Report Online Once you are logged in to FederalReporting.gov, you can begin to create your report. Click the “Create Report” command button from the Left Side Bar to begin creating your report. • After you receive an FRPIN, you need to “Create Report”
Getting started: Recipients (con’t) 3 • Determining your preferred method to report: Prime Recipients and Sub Recipients submit reports by entering data into forms residing on FederalReporting.gov • After you have entered all your report data, you will be prompted to “Submit” your report Once you click the “Submit” button, you will be prompted to enter the FRPIN for the DUNS number for which you are reporting 1 Click the “Submit” button to submit your report as Initial Submission status. Click “Cancel” if you wish to cancel the action of submitting the Initial Submission. You will be returned to your report entry screens. 2
Getting started: Recipients (con’t) 3 • Determining your preferred method to report: Downloading Excel or XML You can access functionality to download the Excel template from two locations within the FederalReporting.gov system: The Download Templates box located in the Left Side Bar on the Home Page, or the Downloads Page 1 2
Getting started: Recipients (con’t) 4 • Understanding functions of FederalReporting.gov functions which may make reporting easier • “Copy forward” function • Returning Recipient reporters should utilize this function within FederalReporting.gov report submission process • Facilitates linkage of current and previous reports and allow the public to follow the progress of projects over time • A full discussion of this process is available in Chapter 10 of the User Guide at FederalReporting.gov • “Linking” function • Reports Linkage Page: A new Link/Unlink Reports Page is created to support the creation and the modification of report relationships • While on this page, the recipient can link a current quarter report to a report submitted in the previous quarter. The recipient can also change or remove links • The manually created link will help distinguish ongoing awards from new awards, even if the relationship is not obvious.
Summary • Initial Submission begins on July 1st and goes through July 14th • Work closely with your Rural Development point of contact as they review your submitted reports and provide you with feedback • Review training materials available via the whitehouse.gov and FederalReporting.gov sites referenced earlier in this presentation Give yourself plenty of time to submit during the July 1-14th Initial Submission period
Screenshot – Create Report Online (Con’t) Recipient Focus • You will need to provide the following: • Prime Award Number • Prime DUNS • Award Type • Federally awarded contract • Grant • Loan • Recipient Type • Prime Recipient [Prime Only] • Prime Recipient [Prime reporting for self and Sub(s)] • Sub Recipient [Sub Only] Once you have entered all of the required data, click “Continue Report Creation.” 2
Screenshot – Create Report Online (Prime Recipient) Recipient Focus Continue, entering reporting data online, you will use the following types of fields and controls: • Free text fields • Drop-down lists • Code Reference lookups • Calendars 1 2 Field Information Page icon — The field information page icon opens a new window including details regarding the various data elements from the Recipient Reporting Data Model V3.0.
Screenshot – Create Report Online (Vendor tab) Recipient Focus In the Vendor Information area, you will enter all of the appropriate data associated with your vendor: • Vendor DUNS Number • Vendor Name • Vendor Headquarters (HQ) ZIP Code • Vendor HQ ZIP Code Ext • Payment Amount • Product and Service Description 1 When you click “Save New Vendor,” the system takes you to the Vendor Reporting results page. There you can see all of the Vendor reports which you have entered. 2
Screenshot – Create Report Online (Recipient Report Submission) Recipient Focus Once you click the “Submit” button, you will be prompted to enter the FRPIN for the DUNS number for which you are reporting 1 Click the “Submit” button to submit your report as Initial Submission status. Click “Cancel” if you wish to cancel the action of submitting the Initial Submission. You will be returned to your report entry screens. 2
Screenshot – Download Excel and XML Recipient Focus You can access functionality to download the Excel template from two locations within the FederalReporting.gov system: The Download Templates box located in the Left Side Bar on the Home Page, or the Downloads Page 1 2
Screenshot – Validate Excel and XML Recipient Focus Follow these steps to validate your file: Step 1: Create your sample Excel or XML file to validate of no greater than 200 megabytes. Step 2: Select the required fields for Award Type and Recipient Type. Step 3: Browse and select the file to validate. Step 4: Click “Validate File.” Step 5: Confirmation page confirms that your file has uploaded. Step 6: Within 1 to 24 hours, you’ll receive an email with validation results. Only users who are logged in to FederalReporting.gov can access the Validation Utility. Your validation file will not be saved in the FederalReporting.gov database and is not considered a report submission.
Screenshot – Upload Excel and XML Recipient Focus • Uploading the completed XML or Excel file: • Step 1: Select the required fields for Award Type • Step 2: Select the required fields for Recipient Type. • Step 3: Browse and select the file to validate. • File extension should be .xls for Microsoft Excel file • File extension of .xml for the XML file • Step 4: Enter FRPIN. Remember, each DUNS Number is assigned by FederalReporting.gov a unique 9-digit FRPIN. • Step 5: Click “Upload Report.” 1 2 3 4 5
Screenshot – Upload Excel and XML, Cont’d(Email Notification for Excel report) Recipient Focus • If your Excel file has been accepted as a valid submission, you will receive an email indicating successful submission. • If there are validation errors associated with the Excel file, you will receive an email describing the errors. Use the information in the validation errors email to review the Excel file and make all necessary corrections. Errors must be corrected and new file uploaded for submission to be completed. An Excel file with errors is not considered a valid submission. Example email text—Excel file successfully submitted 1 Award_G278K-L_Grant.xls: successfully submitted. Do not reply to this e-mail. Please contact the FederalReporting.gov Service Desk or call us at 877-508-7386; TTY: 877-881-5186 if you have any questions. Example email text—Excel file submission unsuccessful 2 Award_Gs2762940-K7.xls failed on validation as follows: The submitted report contains validation errors. 1. Error Code: VALUE_NOT_FOUND Error Message: Unable to find a CFDA Number* with the value 0000012. Error Code: INVALID_EMAIL Error Message: dfadsf@ must be a valid email address3. Error Code: INVALID_DOLLAR_AMOUNT Error Message: Amount of Award* must be a value greater than zero with no more than two decimal places. Do not reply to this e-mail. Please contact the FederalReporting.gov Service Desk or call us at 877-508-7386; TTY: 877-881-5186 if you have any questions.
Link/Unlink Reports – Prime Recipient User The Prime Recipient User logs in. The Prime Recipient User clicks on “My Work Queue”. A Work Queue message is in the Prime Recipient User’s work queue. The Prime Recipient User clicks on the “Award #” link to open the report.
Link/Unlink Reports – Prime Recipient User The “Prime Recipient Reporting” page opens. The Prime Recipient User clicks on the “View or Add Report Comments” link to read the comment left by the Agency User. The Prime Recipient User closes the “Report Comments” page and returns to the “Prime Recipient Reporting” page. 30
Link/Unlink Reports – Prime Recipient User The Prime Recipient User clicks on the “Link/Unlink Reports” link to access the “Link/Unlink Reports” page. 31
Link/Unlink Reports – Prime Recipient User • The Prime Recipient User can: • Review reports linkage information. • Remove an existing link. • Search for previous quarter reports to link to the current quarter report. • Update the link. 32
Link/Unlink Reports – Prime Recipient User The Prime Recipient User decides to change the link to a different report. The Prime Recipient clicks on the Award Number of a report in the January 2010 Reports section. The “Link Reports” page is opened. 33
Link/Unlink Reports – Prime Recipient User • To complete the update action, the Prime Recipient must: • Verify that the link is correct • Check the “Terms and Conditions” check box. • Enter the FRPIN. • Click on “Update Link”. 34
Link/Unlink Reports – Prime Recipient User The system displays the “Link Report Confirmation” page. 35
Link/Unlink Reports – Prime Recipient User The Prime Recipient User is notified by the Agency User to unlink the report. The Prime Recipient User navigates back to the “Link/Unlink Reports” page and clicks on the “Unlink” button. The “Remove Report Link” page is opened. 36
Link/Unlink Reports – Prime Recipient User • To complete the update action, the Prime Recipient must: • Check the “Terms and Conditions” check box. • Enter the FRPIN. • Click on “Unlink”. 37
Link/Unlink Reports – Prime Recipient User The system displays the “Link Report Confirmation” page.