Recipient reporting training l.jpg
This presentation is the property of its rightful owner.
Sponsored Links
1 / 42

Recipient Reporting Training PowerPoint PPT Presentation


  • 190 Views
  • Uploaded on
  • Presentation posted in: General

Recipient Reporting Training. CDC Recovery Act Coordination Unit. Training Objectives. Understand the basic recipient reporting process Requirements Registration and Preparation Reporting options and sample report Understand the Data Quality Reviews (DQR ) Requirements Basic Process

Download Presentation

Recipient Reporting Training

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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Recipient reporting training l.jpg

Recipient Reporting Training

CDC Recovery Act Coordination Unit


Training objectives l.jpg

Training Objectives

  • Understand the basic recipient reporting process

    • Requirements

    • Registration and Preparation

    • Reporting options and sample report

  • Understand the Data Quality Reviews (DQR)

    • Requirements

    • Basic Process

    • Preparation

  • Distinguish between Performance Measurement Reporting and Section 1512 Reporting


Recovery act overview l.jpg

Recovery Act Overview

  • The American Recovery and Reinvestment Act of 2009 (Recovery Act) was passed on February 17, 2009, with $787 billion in funding

  • Main goals:

    • Create new jobs as well as save existing ones

    • Spur economic activity and invest in long-term economic growth


Slide4 l.jpg

Unprecedented level of accountability and transparency

Funding should reach “end users” quickly and be expended for quick results

Emphasis on measurement and evaluation

Reporting will be extensive including post-award audits & reviews (GAO, OIG)

Special Requirements


Recipient reporting two components l.jpg

Recipient Reporting:Two Components

  • Section 1512 – Public recipient reports due to www.federalreporting.gov by Day 10* after the end of each quarter.

  • Program Performance Measures – Public and non-public performance measures.

    • Coordinated by Program Project Officers.

  • * Note:Dates are subject to change and recipients will receiveupdated timelines each quarter.


Slide6 l.jpg

Section 1512 Reporting


Reporting schedule l.jpg

Reporting Schedule

  • Eleven reporting periods complete since April 2009

  • OMB has determined recipient reporting will continue quarterly through September 2013

    • Recipients will continue to report through their final report*

      *See appendix for additional guidance (Slides 37 & 38)


Funding recipients l.jpg

Funding Recipients

  • Prime recipient– non-Federal entities that receive Recovery Act funding (grants, cooperative agreements, loans) directly from the federal government.

  • Sub-recipient – non-Federal entity that receives all or a portion of Recovery Act funding from a prime recipient to support the performance of programs/projects for which the prime recipient received funding.

  • Vendor – a dealer, distributor, merchant, or other seller providing goods or services to recipients that are needed to carry out the project or program.

  • Contractor – a non-federal entity who receives funds directly from the federal government as indicated by a legal contract.


Vendors l.jpg

Vendors

The distinguishing features of a vendor are below:

  • Provides the goods and services within normal business operations;

  • Provides similar goods and services to many different purchasers;

  • Operates in a competitive environment;

  • Provides goods and services that are ancillary to the operation of a federal program; and,

  • Is not subject to compliance requirements of the federal program.

Office of Management and Budget Guidance on Reporting (M-09-21), p.7 http://www.recovery.gov/?q=content/recipient-reporting


Reporting responsibilities l.jpg

Reporting Responsibilities

Prime recipient

  • Own all recipient data

  • Initiates data collection/reporting procedures

  • Implements internal controls to ensure accurate/complete information

  • Reviews information for significant errors or omissions, makes corrections and/or works with sub-recipients to correct errors

    Sub-recipient

  • Own sub-recipient data

  • Initiates data collection/reporting procedures

  • Implements internal controls to ensure accurate/complete information

  • Reviews information for significant errors or omissions, makes corrections and/or works with prime recipient to correct errors


Reporting responsibilities11 l.jpg

Reporting Responsibilities

Contractors

  • Owns contractor data

  • Initiates data collection/reporting procedures

  • Implements internal controls to ensure accurate /complete information

  • Reviews information for significant errors or omissions; makes corrections and/or works with prime recipient to correct errors

    Vendors

  • Not required to report


Recipient reporting data quality review key dates l.jpg

Recipient Reporting & Data Quality Review: Key Dates

  • * Note:Dates are subject to change and recipients will receiveupdated timelines each quarter.


Recipient reporting key dates l.jpg

Recipient Reporting: Key Dates

  • Days 1 – 10*: Submit Reports

    • Recipients submit reports to federalreporting.gov. There are three reporting options (all available at www.federalreporting.gov )

      • Recipient Reporting Online Form, Recipient Reporting Excel Tool, Recipient Reporting XML Schema

      • All recipients should use copy-forward feature (see Resources slide)

  • Days 11 – 14*:Extended Submission

  • Day 15-18: Initial Report Review

    • Prime recipients ID errors/omissions and notify sub recipients where applicable

    • Recipients correct data

    • Federal agencies initiate data reviews

  • * Note:Dates are subject to change and recipients will receiveupdated timelines each quarter.


Recipient reporting data quality review l.jpg

Recipient Reporting &Data Quality Review

  • Days 19 – 29*: Official Agency Review

    • Reports locked; agencies must enter a comment for a recipient to update a report

    • Federal agencies officially alert recipients to data issues

    • Recipients correct data issues

    • Federal agencies categorize data for Recovery.gov

  • Day 30*: Final reports posted on Recovery.gov

  • Days 33 – 81*: Continuous Review

    • RAC/Program report final list of errors, corrections, and non-compliance

    • Additional error correction

  • * Note:Dates are subject to change and recipients will receiveupdated timelines each quarter.


Slide15 l.jpg

Guidance and Sample Reports


Recipient checklist l.jpg

Recipient Checklist

  • Recipients need:

    • DUNS*: http://fedgov.dnb.com/webform

    • Current CCR: www.ccr.gov/GAQ.aspx

      • Expires annually and must be renewed

    • FRPIN: www.federalreporting.gov

    • Award #*

    • Award Amount*

    • Date*

    • CFDA*

    • TAS*

  • Is the recipient in a state with centralized reporting? Who provides information to the state’s ARRA office?

  • Refer recipient to the Notice of Grant Award

    • * Note:All recipients should use the copy forward function forthese data fields


    Example nga l.jpg

    Example NGA


    Arra reporting codes l.jpg

    ARRA Reporting Codes


    Arra reporting codes19 l.jpg

    ARRA Reporting Codes


    Recipient registration checklist l.jpg

    Recipient RegistrationChecklist

    • Has the prime recipient delegated reporting to sub-recipients? Who will report for the sub-recipient?

      • How will prime recipients validate sub-recipient reports/information?

    • What systems will you use for data collection (purchasing, accounting, etc.)? Who will receive and enter vendor data?

    • Have you submitted a report for each award?


    Job guidance l.jpg

    Job Guidance

    • Recipients should report job data quarterly, not cumulatively.

    • Recipients should calculate the total number of jobs that were funded by the Recovery Act during the quarter.

      • A funded job is defined as one in which the wages/salaries are either paid for or will be reimbursed with Recovery Act funding.

        • Job created – a new position created and filled, or an existing unfilled position that is filled, and funded by the Recovery Act.

        • Job retained – an existing position that is now funded by the Recovery Act.

      • A job is either created or retained, but it cannot be both.

    • The job data should include the sum of prime recipient, sub recipient, and vendor jobs created/retained (recipients should avoid double-counting).


    Instructions for calculating jobs l.jpg

    Instructions for Calculating Jobs

    Step 1: Calculate Quarterly Hours in a Full-Time Schedule.

    A. Determine the standard hours in a full-time work week schedule, as illustrated below. This example uses 40hours, but this number may vary depending on how an organization defines a full-time schedule.

    B. Multiply the full-time work week hours by 13 weeks to determine the quarterly hours.

    C. Example:

    40 Hours (full-time work week) X 13 weeks = 520

    http://www.whitehouse.gov/omb/assets/memoranda_2010/m10-08.pdf, p. 23


    Instructions for calculating jobs23 l.jpg

    Instructions for Calculating Jobs

    • Step 2: Calculate the Full Time Equivalent (FTE) for this Quarter.

    • Total the number of hours worked in positions funded by the Recovery Act within the current quarter (for all employees). It is possible that an employee spends a portion of their time working on a Recovery Act project. The recipient should use the actual hours worked in this case.

    • B. Divide this number by the “Quarterly Hours in a Full-Time Schedule” calculated in Step 1.

    • 520 Hours Worked and Funded by Recovery Act

    • ----------------------------------------------------------------- = 1.0 FTE

    • 520 Quarterly Hours in a Full-Time Schedule


    Job calculation example l.jpg

    Job Calculation Example

    • Two employees were hired during the second month of the current quarter to work full-time (40 hours per week) on a Recovery Act project.

    • Max # of hours worked = 640 hours

      • 40 hrs/week x 8 weeks = 320 hours

      • # of FTEs: 2

    • Total hours available in quarter = 520

    320 hours worked x 2 FTEs = 640 hours worked

    -------------------------------------------------------------------

    520 hours in a full-time schedule

    = 1.2 FTEs


    Slide25 l.jpg

    Data Quality Review (DQR)


    Scope of dqr l.jpg

    Scope of DQR

    • Material omissions:

      • Failure to submit a report (recipient reflected as non-compliant)

      • Inadequate Award Description

      • Inadequate Project Description

        • Award/Project Description standards of completeness include, but are not limited to, the following attributes:

          • Explanation of all abbreviations or acronyms that may be unfamiliar to the general public

          • Use of complete sentences

          • Adherence to instructions and examples of narratives field in OMB and agency-specific guidance

          • Taken in conjunction, entries in the “Award Description” and “Quarterly Activities/Project Description for Prime and Sub-recipients” fields must provide, at a minimum, clear and complete information on the award’s purpose, scope and nature of activities, outcomes, and status of activities


    Scope of dqr27 l.jpg

    Scope of DQR

    • Significant reporting errors:

      • Award Amount: Reported amount differs from Notice of Grant Award by more than 1%

      • Award Number: Reported number does not match agency records; must include hyphens and correct alphanumeric characters

      • DUNS# Error: Reported DUNS does not match agency records

      • Jobs:

        • Over-reported jobs: Award amount divided by 4 (or 8 for two year awards) divided by the number of jobs reports is less than $3,770

        • Under-reported jobs: Recipient was awarded more the $500,000 and has expended (for grants) or invoiced (for contracts) more the $500,000, but has not created any jobs


    Scope of dqr28 l.jpg

    Scope of DQR

    • Other Data Elements Reviewed*:

      • Award Date: Reported award date differs from CDC records by more than 7 days

      • Awarding Agency Code: 7523

      • Funding Agency Code: 7523

      • Project Status

      • Duplicate Report

      • TAS Code

      • CFDA Number

      • “Final Report”

      • Not required to report

    • * Note:See the sample excel report on FederalReporting.gov and the presentation appendix for

    • additional data element information


    Conclusion l.jpg

    Conclusion


    Summary l.jpg

    Summary

    Reports due on 10th day after the end of each calendar quarter*

    “Extended” submission period runs until the 14th day after the end of the calendar quarter*

    • * Note: Dates are subject to change and recipients will receive updated timelines each quarter

    30


    Resources l.jpg

    Resources

    • Recovery.gov - www.recovery.gov/FAQ/Pages/FAQ.aspx

      • FAQs and Resources

    • Whitehouse.gov

      • FAQs – http://www.whitehouse.gov/omb/recovery_faqs/

    • Federalreporting.gov

      • FAQs – https://www.federalreporting.gov/federalreporting/faq.do

      • Downloads: Webinars and Recipient Reporting Resources - https://www.federalreporting.gov/federalreporting/downloads.do

    • HHS Recipient Reporting Readiness Tool

      • http://taggs.hhs.gov/ReadinessTool/

    • Copy Forward Quick Reference

      • http://www.cdc.gov/fmo/topic/Recovery_Act/index.html

    • Recipient Registration Guidance

      • https://www.federalreporting.gov/federalreporting/documentation/FR-Gov%20User%20Guide%20Chapter%202%20Registration.pdf


    Technical assistance l.jpg

    Technical Assistance

    Federalreporting.gov

    Phone: 877-508-7386

    TTY: 877-881-5186

    Email: [email protected]

    Chat: LivePerson Support

    32


    Appendix l.jpg

    Appendix


    Additional guidance reporting procedures l.jpg

    Additional GuidanceReporting Procedures

    When is a recipient considered non-compliant?

    A non-reporting recipient is considered non-compliant with Section 1512 requirements, unless the instance meets one or more of the known exclusions from reporting detailed in OMB M-10-14, Section 4, copied and revised below. These exclusions are:

    Not required to report (e.g., loan or grant less than $25,000)

    Federal program exempted from 1512 reporting (e.g., USDA’s Single Family Housing loan program)

    Award de-obligated

    Award cancelled or terminated

    Extension for “Extraordinary Circumstances” (e.g., natural disaster)

    Award is classified

    Micropurchases made with the purchase card

    Final report previously submitted to FederalReporting.gov

    Other (if applicable, provide details on why reporting is not expected)

    34


    Additional guidance reporting procedures35 l.jpg

    Additional GuidanceReporting Procedures

    Can recipients submit paper reports to fulfill Section 1512 reporting requirement?

    If at all possible, recipients are required to report electronically through FederalReporting.gov.

    Reports submitted outside of FederalReporting.gov (i.e. e-mail, fax or mailed) must be received by the awarding agency by the same deadline for filing electronic reports in the reporting period to be considered “on time and compliant”.

    Mailed paper reports must be postmarked by this same deadline to be considered “on time and compliant”.

    The awarding agency is responsible for certifying that the recipient is unable to report electronically.

    Agencies shall exercise strict judgment in reviewing and accepting paper reports to ensure that this process is not used as an alternative choice for those recipients that could, but do not wish to, report electronically.

    35


    Additional guidance reporting procedures36 l.jpg

    Additional GuidanceReporting Procedures

    Can recipients submit paper reports to fulfill Section 1512 reporting requirement? (cont.)

    All paper reports that meet this requirement, have all required fields complete, and are acceptable in the judgment of the awarding agency shall be submitted to OMB for approval.

    Agencies shall submit qualified paper reports to OMB in a timely fashion to allow for review and approval prior to the end of the reporting period.

    Once approved, OMB will submit paper reports to the Recovery Accountability and Transparency Board for entering into FederalReporting.gov, and these recipients will be considered compliant reporters.

    36


    Additional guidance reporting procedures37 l.jpg

    Additional GuidanceReporting Procedures

    When should a recipient of a grant, loan, or other Federal assistance mark a record as final?

    A project is considered final for Recovery Act reporting purposes when the following requirements are met:

    All ARRA funds associated with the award have been expended at the prime recipient level

    All or nearly all ARRA funds associated with the award have been invoiced and received

    No additional jobs will be funded

    The project status is complete per agency requirements and/or performance measures, and

    The project status is marked as “Fully Complete” (marked as “4”)

    A recipient will be considered a non-reporter/non-compliant in subsequent quarters until the record is correctly marked as final.

    37


    Additional guidance reporting procedures38 l.jpg

    Additional GuidanceReporting Procedures

    When should a recipient of a grant, loan, or other Federal assistance mark a record as final? (cont.)

    In instances where expenditures are reimbursed to recipients and invoices/receipts lag expenditures, a project may be marked as final when all funds have been expended, 75% or more of the funds awarded have been invoiced and received, and the project status is “Fully Complete.”

    In instances where the award end date is in the future, recipients may still mark an award as final if the requirements listed in this Section are all met.

    In instances where an award is cancelled, no funds were received or invoiced, and the funds are rescinded, the agency should attempt to work with the recipient to change the award amount to $0.00 and mark the report as final.

    38


    Additional guidance reporting procedures39 l.jpg

    Additional GuidanceReporting Procedures

    Can I make adjustments to prior period recipient reports?

    Yes, the recipient or the Federal agency may initiate the change to a prior reporting process if they deem it to be appropriate.

    Recipients can utilize the Automated Data Change tools to request four types of report changes:

    Deactivation

    Marking a report as final

    Linking to another report

    “Other” – Changes may be requested for any of the data fields with the exception of the jobs numbers data field. Data populated in the Jobs Numbers field are permanent and change requests are automatically rejected.

    See the Automated Data Change Guidelines posted on the CDC Recovery Act internet site for additional instructions. (http://www.cdc.gov/fmo/topic/Recovery_Act/index.html)

    39


    Additional guidance reporting procedures40 l.jpg

    Additional GuidanceReporting Procedures

    Quarterly Activities/Project Descriptions for Prime and Sub-recipients

    The prime recipient is required to collect information from the sub-recipient(s) to enter with the prime recipient information for this field.

    For awards that fund multiple projects such as formula block grants, the recipients are asked to provide information that is stated in terms that allow an understanding of the accomplishments.

    Total Number of payments to vendors less than $25,000/award

    The data element should only include payments made by the prime recipient to the vendor.

    40


    Additional guidance reporting procedures41 l.jpg

    Additional GuidanceReporting Procedures

    Total Amount of payments to vendors less than $25,000/award

    The amounts reported are cumulative for the award and should only include payments made by the prime recipient. Payments that exceed the $25,000 threshold should be reported in the vendor Section of the report.

    Total Amount of Sub-awards less than $25,000/award

    The amounts reported are cumulative for the award. Payments that exceed the $25,000 threshold should be reported in the sub-recipient Section of the report.

    41


    Additional guidance reporting procedures42 l.jpg

    Additional GuidanceReporting Procedures

    Sub-Recipient Section

    Amount of Sub-award

    Sub-awards exceeding $25,000 in the quarter are reported in this Section. The data is a cumulative amount for the award and aggregated by sub-recipient. Multiple sub-awards to a single sub-recipient under the same award should be aggregated and reported in this field if the cumulative total exceeds $25,000 for the quarter.

    Vendor Section

    Payment Amount

    Payments exceeding $25,000 in the quarter are reported in this Section. The data is a cumulative amount for the award and aggregated by vendor. Multiple payments to a single vendor under the same award should be aggregated and reported in this field if the cumulative total exceeds $25,000 for the quarter.

    42


  • Login