Document
Template for Quarterly Progress Reports (QPR)
ICR 202605-1660-006 · OMB 1660-0072 · Object 168557800.
Document Viewer [xlsx]
Document Metadata
| File Type | application/vnd.openxmlformats-officedocument.spreadsheetml.sheet |
|---|---|
| File Title | Template for Quarterly Progress Reports (QPR) |
| Author | Ross, Erika (CTR) |
| Last Modified By | Calc |
| File Modified | 2022-12-27 |
| File Created | 2026-10-21 |
| Conversion State | complete |
Extracted Text
DEPARTMENT OF HOMELAND SECURITY FEDERAL EMERGENCY MANAGEMENT AGENCY OMB Control Number XXXX-XXX Recipient Information A1 A2 A3 A4 A5 A6 Recipient Organization Name FEMA Program State Region Unique Entity Identifier (UEI) Employer Identification Number (EIN) Disaster Information (if applicable) A7 A8 A9 A10 New FSA? Disaster Number Applicant ID Category Award and Reporting Information Federal Award or Other Identifying Number A11 Assigned by the Federal Awarding agency Federal Award Period of Performance (POP) Start A12 Date A13 A14 A15 A16 A17 A18 A19 Federal Award Period of Performance (POP) End Date (if applicable) Reporting Period Start Date Reporting Period End Date Is this the Final Report? Reporting Frequency Date Report Submitted Other Attachments Certifying Representation and Points of Contac A20 Name of Authorized Certifying Representative A21 Title of Authorized Certifying Representative Signature of Authorized Certifiying A22 Representative A23 Name of Point of Contact A24 Title of Point of Contact Telephone Number of Point of Contact (XXX-XXXA25 XXXX) A26 Email of Point of Contact T OF HOMELAND SECURITY GENCY MANAGEMENT AGENCY ntrol Number XXXX-XXX pient Information Provided from application or populated from NEMIS Provided from application or populated from NEMIS Provided from application or populated from NEMIS Provided from application or populated from NEMIS Provided from application or populated from NEMIS Provided from application or populated from NEMIS formation (if applicable) Manual entry based on declaration date Populated from NEMIS Populated from NEMIS Populated from NEMIS Reporting Information Provided from application or populated from NEMIS Provided from application Provided from application Populated by FEMA Program Populated by FEMA Program Populated by FEMA Program Populated by FEMA Program Populated by recipient Populated by recipient entation and Points of Contact Populated by recipient Populated by recipient Populated by recipient Populated by recipient Populated by recipient Populated by recipient Populated by recipient Source PPR QPR Both (B1) Program Indicator Number (B2) Program Objective/Goal (B3) Program Indicator Populated by FEMA Program Populated by FEMA Program Populated by FEMA Program (B4) Program Indicator Description Populated by FEMA Program Source PPR QPR Both (C1) Program Indicator Number Original Source Provided from application or populated from NEMIS PPR QPR Both (C2) Project Identifier Provided from application or populated from NEMIS (C3) Project Title Populated by recipient (C4) Sub-Recipient Name/Sub-Applicant ID (if applicable) Provided from application or populated from NEMIS (C5) Project Description Provided from application or populated from NEMIS (C6) Project Indicator (C7) Project Baseline Provided from application or populated from NEMIS Provided from application or populated from NEMIS (C8) Reporting Period 1 Project Target Provided from application or populated from NEMIS (C9) Reporting Period 1 Project Actual to Date Populated by recipient (C10) Reporting Period 2 Project Target Provided from application or populated from NEMIS (C11) Reporting Period 2 Project Actual to Date Populated by recipient (C12) Quarter (C13) Latest Version Number (if Number (if applicable) applicable) Manual Entry Provided from application or populated from NEMIS Source PPR QPR Both (D1) Project Identifier Populated by FEMA Program (D2) Project Indicator Populated by FEMA Program (D3) Projected Completion Date Populated by recpient (D4) Accomplishments Populated by recpient (D5) Impact Populated by recpient (D6) Percent Complete Populated by recpient (D7) Potential Risks Populated by recpient (D8) Significant Events Populated by recpient (D9) Extensions Populated by recpient Source PPR QPR Both (E1) Project Identifier (E2) Project Indicator Populated by FEMA Program Populated by FEMA Program (E3) Total Eligible Populated from NEMIS (E4) Sum of Project Amount (E5) Sum of Federal Share Obligated (E6) Date Obligated (E7) Applicant Expenditures To Date Populated from NEMIS Populated from NEMIS Populated from NEMIS Populated by recipient (E8) Total Applicant Drawdown (E9) Date of Last Drawdown (E10) Federal Funds Disbursed (E11) Date Final Payment Made to Applicant Populated by recipient Populated by recipient Populated by recipient Populated by recipient (E12) Calculation of UDO (E13) Excess Funds? Formula calculated by FEMA Program Formula calculated by FEMA Program (E14) Deobligation Amount Populated by FEMA Program (E15) Reason: 100% Complete but Still Open Populated by FEMA Program (E16) FEMA Comments Populated by FEMA Program (E17) Tribe (if applicable) (E17) County (if applicable) (E18) Project Size Populated from NEMIS Populated from NEMIS Populated from NEMIS (E19) Project (E20) Period of Completion Status Performance End Date (EDW) Populated from NEMIS Populated from NEMIS DEPARTMENT OF HOMELAND SECURITY FEDERAL EMERGENCY MANAGEMENT AGENCY GRANT PROGRAMS DIRECTORATE OMB Control Number XXXX-XXX Cover Sheet Recipient Organization Name FEMA Program Federal Award or Other Identifying Number Assigned by the Awarding Federal agency Unique Entity Identifier (UEI, formerly DUNS Number) Employer Identification Number (EIN) (XX-XXXXXXX) Federal Award Period of Performance (POP) Start Date Federal Award Period of Performance (POP) End Date Reporting Period Start Date Reporting Period End Date Is this the Final PPR Report? Reporting Frequency Name of Authorized Certifying Representative Title of Authorized Certifying Representative Signature of Authorizing Certifying Representative Name of Point of Contact Title of Point of Contact Telephone Number of Point of Contact (XXX-XXX-XXXX) Email of Point of Contact Date Report Submitted Other Attachments Performance Measures Program Indicator Number Program Objective/Goal Program Indicator Program Indicator Description Project Performance Measures Program Indicator Number Project Identifier Project Description Project Indicator Project Baseline FY (Year) Reporting Period 1 Project Target FY (Year) Reporting Period 1 Project Actual to Date FY (Year) Reporting Period 2 Project Target FY (Year) Reporting Period 2 Project Actual to Date Target Year Explanation Project Narrative Project Identifier Project Indicator Accomplishments Impact Percent Complete Potential Risks Significant Events Project Expenditures Project Identifier Project Indicator Project Activity Description Total Estimated Expenditures Funding Expended DEPARTMENT OF HOMELAND SECURITY FEDERAL EMERGENCY MANAGEMENT AGENCY GRANT PROGRAMS DIRECTORATE OMB Control Number XXXX-XXX Cover Sheet Enter the name of recipient organization and address, including zip code. Select the appropriate drop-down option that corresponds your FEMA Program. Enter the grant/award number contained in the award document Enter the recipient organization's Unique Entity Identifier, formerly known as the Data Universal Numbering System (DUNS) number. Enter the recipient organization's Employer Identification Number (EIN) provided by the Internal Revenue Service. Enter the award period of performance start date established in the award document. Enter the award period of performance end date established in the award document. Enter the starting date of the reporting period in MM/DD/YYYY format. Enter the ending date of the reporting period in MM/DD/YYYY format. Select “yes” only if this is the final report for the project/grant. Select the appropriate drop-down option that corresponds your Reporting Frequency. Enter the name of the authorized certifying official of the recipient. Enter the title of the authorized certifying official of the recipient. Submit a signature of the authorized certifying official of the recipient. Enter the name of the individual responsible for completing this form if other than the authorized certifying official of the recipient. If the POC is the authorized certifying official, please enter N/A. Enter the title of the individual responsible for completing this form if other than the authorized certifying official of the recipient. If the POC is the authorized certifying official, please enter N/A. Enter the telephone number of the individual responsible for completing this form. If the POC is the authorized certifying official, please enter their telephone number here. Enter the email address of the individual responsible for completing this form. If the POC is the authorized certifying official, please enter their email address. Enter date submitted to the awarding Federal agency in MM/DD/YYYY format. Note: Report must be received by the awarding Federal agency no later than 90 days after the end of the reporting period. Attach other documents as needed or as instructed by the awarding Federal agency. Performance Measures This number will track the program goal, objective, or program/priority area established in the Program NOFO. This number will automatically generate in the following format: Program Acronym#. Enter the program goal(s), objective(s), priorities identified in Section A.10: Program Overview, Objectives, and Priorities within the Program's NOFO. Enter the performance measure(s) identified in Section A.11: Performance Measures in the Program's NOFO that align to the Program goal(s) and objective(s). Indicators should be quantitative, e.g., counts, percentages, target dates, time periods, or levels. Describe how data for the performance measures will be collected, i.e., the information that is being requested of recipients. In some cases, the description in this column refers to just one indicator; in others, it pertains to multiple related indicators. Project Performance Measures This number will track the program goal, objective, or program/priority area established in the Program NOFO. This number will automatically generate from the NOFO Performance Measures Tab. This number will track a particular award activity as established in Section C of the Program NOFO. This number will automatically generate in the following format: Award Number_Project Number_#. Enter a short description of the project including a high-level overview and the project purpose. Based on the approved award activities, established in Section C of the Program NOFO, enter the quantitative measure associated with the Program goal(s) and objective(s) identified within the NOFO Performance Measures tab of this spreadsheet. Enter the initial starting point or average amount or condition related to each Project Indicator. A baseline is typically a count, or other quantitative data. The baseline is the project starting point, against which can be measured all project progress and results. Enter the expected amount to be achieved for each Project Indicator as specified in the approved work plan for Reporting Period 1. This will be prepopulated based on what was entered on the application. Enter the actual cumulative amount, condition or status achieved at the end of the reporting period for each Project Indicator for Reporting Period 1. Enter the expected amount to be achieved for each Project Indicator as specified in the approved work plan for Reporting Period 2. This will be prepopulated based on what was entered on the application. Enter the actual cumulative amount achieved at the end of the reporting period for each Project Indicator for Reporting Period 2. Enter the year you expect to accomplish the target(s) specified in the approved work plan. Different target years may appear on the same report such as an annual measure and a long-term measure. If you did not meet or expect to meet your target, you must explain. Reasons could include, delays, weather, pandemic-related challenges, etc. Project Narrative This number will track a particular award activity as established in Section C of the Program NOFO. This number will automatically generate from the Project Performance Measures Tab. Project Indicator is the quantitative measure associated with the Program goal(s) and objective(s) identified within the NOFO Performance Measures tab of this spreadsheet. This will automatically generate from the Project Performance Measures Tab. Provide a summary of project accomplishments/achievements throughout the grant period of performance. Describe how the project accomplishments created a positive impact. Describe how the accomplishments align with the intended goals/objectives of the Program or how they addressed gaps. Select the percent complete for each Project noted in the Project Performance Measures Tab. Please describe any potential risks to the completion or success of the project such as delays, lack of resources, weather events, etc. Please explain if significant events have caused delays in accomplishing the target within the intended timeframe. This should be an expanded explanation related to the Explanation section noted in the Project Performance Measures Tab. Project Expenditures This number will track a particular award activity as established in Section C of the Program NOFO. This number will automatically generate from the Project Performance Measures Tab. Project Indicator is the quantitative measure associated with the Program goal(s) and objective(s) identified within the NOFO Performance Measures tab of this spreadsheet. This will automatically generate from the Project Performance Measures Tab. Describe what funds are intended to support the approved award activities identified within the Project Performance Measures tab of this spreadsheet. Provide the estimated Project activity expenditures used to support the approved award activities identified within the Project Performance Measures tab of this spreadsheet. Provide the total amount expended during the performance period on the approved award activities identified within the Project Performance Measures tab of this spreadsheet. Term Federal Award Federal Awarding Agency Federal Financial Assistance Unique Entity Identifier (UEI) Grant Non-Federal Entity Period of Performance Performance or Progress Report (PPR) Pass-Through Entity Recipient State Subrecipient DEPARTMENT OF HOMELAND SECURITY FEDERAL EMERGENCY MANAGEMENT AGENCY GRANT PROGRAMS DIRECTORATE OMB Control Number XXXX-XXX Definition The federal award refers to FEMA’s award of financial assistance to the recipient or to the recipient’s subawar subrecipient made as a pass-through entity. It may also refer to the financial assistance awarded; or the gran cooperative agreement, or other financial assistance agreement (as defined in §200.40) setting out the terms FEMA’s financial assistance The federal agency that provides a federal award directly to a non-federal entity. FEMA is the federal awarding funds to the recipient for FEMA financial assistance programs addressed in this form. Federal financial assistance includes assistance that non-federal entities receive or administer in the form of: cooperative agreements; non-cash contributions, or donations of property (including donated surplus proper appropriations; food commodities; loans; loan guarantees; interest subsidies; insurance; and other financial a financial assistance does not include amounts received as reimbursement for services rendered to individuals CFR §§ 200.502(h) and (i). DUNS Number or Vendor ID Number, which is the number assigned to recipients’ profiles in FEMA’s official fin record This tool uses the term grant to reference all types of federal financial assistance that FEMA administers. A non-federal entity is a state, local government, Indian tribal government, institute of higher learning, or no organization that carries out a federal award as a recipient or subrecipient, or as referenced in previous guida subgrantee. It is not an individual recipient or beneficiary of an award. The time period specified in the award documents that FEMA establishes for the prime award to the recipient through entity establishes for subawards, during which the non-federal entity may incur costs (i.e., recipient/s obligations) to carry out the work authorized under the federal award.) A program status report the recipient prepares and submits to FEMA describing the status of reportable activ quantifies, where possible, accomplishments under the award and outlines any problems expected to result i materially impact achieving the objectives of the award noncompliance to approved award conditions. For PA example, this is the Quarterly Progress Report (QPR) and Performance Report. For other programs, this is the Progress Report (PPR). A non-federal entity that provides a subaward to a subrecipient to carry out part of a FEMA award. Past FEMA refer to a grantee that provides a subgrant to a subgrantee. For disaster assistance programs, this may be a s tribal government. The non-federal entity that receives an award directly from FEMA to carry out an activity under a FEMA assista recipient may also be a pass-through entity. The term recipient does not include subrecipients or individuals. assistance programs, the recipient is a state or Indian tribal government. Any state of the United States of America, the District of Columbia, the Commonwealth of Puerto Rico, the Vir American Samoa, and the Commonwealth of the Northern Mariana Islands, and any agency or instrumentalit exclusive of local governments. A non-federal entity that receives a subaward from a pass-through entity to carry out part of the FEMA award in previous guidance, a subgrantee that received a subgrant from a grantee to carry out part of a federal pro subrecipient does not include an individual who is a beneficiary of the federal program. For most FEMA progr the state, local government, Indian tribal government or private nonprofit receiving the subaward for a proje the state or Indian tribal government recipients award from FEMA. Subrecipient replaces FEMA references to