Print
Download Reader
Text
Recipient Report for Grant or Loan AwardTopics on this page:
Report InstructionsIf you are a Prime Recipient who is submitting a report or reports on behalf of your Sub Recipient, you must complete these worksheets:
If you are a Prime Recipient who not is submitting a report or reports on behalf of your Sub Recipient, you must complete these worksheets:
If you are a Sub Recipient who is submitting a report, you must complete these worksheets:
*Required reporting element Report Questions and AnswersQ. Not all of my text is showing up when I enter values in a narrative field, for example, when entering text for the Project Description field.
A. This is a limitation of Excel. Although each cell holds up to 32,767 characters, Excel only displays 1,024 characters in the cell itself. To view all of the text you’ve entered for a given field, click on the cell in question and the text will display in the formula bar at the top of the screen.
Q. When I try to select a value from a drop-down menu, the text is too small to read. How do I make it bigger?
A. Check to make sure you are viewing the workbook at 100% zoom. If your zoom is set to less than 100%, this can cause the text in the drop-down menus to appear very small.
Q. I don’t know what CFDA identifier to use.
A. Go to http://www.cfda.gov for the complete list of Catalog for Federal Domestic Assistance (CFDA) values.
Q. I’m not sure what each of the data elements mean.
A. You can either click on each cell for instructional text or reference the Data Model document published on Recovery.gov.
Q. I have more than 400 Sub Recipients or Vendors to add, but the spreadsheet looks like it is limited to 400.
A. You can continue to add additional Sub Recipients and Vendors beyond the #400 line provided to you; however the special formatting and data validations which are provided for the first 400 Sub Recipients or Vendor entries will not be present. This is done to keep the file size of the template from growing excessively large. Data validation will be performed once your report is uploaded on FederalReporting.gov.
Prime Recipient ReportReporting InformationAward Type*: Award Number*: Final Report*: Award Recipient InformationRecipient DNUS Number*: Recipient Account Number: Recipient Congressional District*: Award InformationFunding Agency Code*: Awarding Agency Code*: Award Date*: Amount of Award*: CFDA Number*: Program Source (TAS)*: Sub Account Number for Program Source (TAS)*: Total Number of Sub Awards to Individuals*: Total Amount of Sub Awards to Individuals*: Total Number of Payments to Vendors less than $25,000/award*: Total Amount of Payments to Vendors less than $25,000/award*: Total Number of Sub Awards less than $25,000/award*: Total Amount of Sub Awards less than $25,000/award*: Award Description* (Enter a description of the overall purpose and expected outcomes, or results of the contract or action under the contract funded by the Recovery Act, including significant deliverables and associated units of measure. 4000 characters or less.) Project InformationProject Name or Project/Program Title*: Project Status*: Total Federal Amount of ARRA Funds Received/Invoiced*: Number of Jobs*: Description of Jobs Created*: Quarterly Activities/Project Description*: (Enter a description of the overall purpose and expected outcomes, or results of the contract or action under the contract funded by the Recovery Act, including significant deliverables and associated units of measure. 4000 characters or less.) Activity Code (NAICS or NTEE-NPC)*: Total Federal Amount of ARRA Expenditure* (Enter the cumulative total amount of Recovery Funds received that were expended to projects or activities. Refer to the Data Model for details on how to calculate this amount.): Total Federal ARRA Infrastructure Expenditure Infrastructure Contact Name: Infrastructure Contact Email: Infrastructure Contact Phone: Infrastructure Contact Phone Ext: Infrastructure Contact Street Address 1: Infrastructure Contact Street Address 2: Infrastructure Contact Street Address 3: Infrastructure City: Infrastructure State: Infrastructure ZIP Code+4: Infrastructure Purpose and Rationale (If applicable, enter an explanation about how the infrastructure investment will contribute to one or more purposes of the Recovery Act. Refer to the Data Model for details on what to report. 4000 characters or less.):
Primary Place of PerformanceStreet Address 1: Street Address 2: City*: State*: ZIP Code+4*: Congressional District*: Country*:
Recipient Highly Compensated OfficersPrime Recipient Indication of Reporting Applicability*:
Sub Recipient ReportReporting InformationAward Type* (Select the award type: Grant or Loan. If you are reporting for a Federally Awarded Contract, use the Contracts Excel template. Other types of Federal financial assistance should be reported under the award type of Grant.): Award Number*: Recipient DUNS Number*:
Sub Recipient InformationSub Recipient DUNS Number*: Sub Recipient Award Number*: Sub Recipient Congressional District*:
Sub Award InformationAmount of Sub Award*: Total Sub Award Funds Disbursed*: Sub Award Date*:
Sub Recipient Place of PerformanceNote: Please provide this information for each sub recipient place of performance:
Street Address 1: Street Address 2: City*: State*: ZIP Code+4*: Congressional District*: Country*:
Sub Recipient Highly Compensated OfficersNote: Please provide this information for each sub recipient place of performance:
Sub Recipient Indication of Reporting Applicability*:
Vendor ReportReporting InformationAward Number* (Enter the identifying number assigned by the awarding Federal Agency such as the Federal grant number, Federal contract number, or the Federal loan number. This field is case, space, and special character sensitive. 50 characters or less.): Subaward Number(*): Vendor DUNS Number(*): Vendor Name(*): Vendor HQ ZIP Code+4(*): Product and Service Description: Payment Amount: |
|
