skip navigation
About UsNews CenterGrants/FundingPartnershipsResourcesFor CongressTraining & TA
OJP Topics


3.20 The American Recovery and Reinvestment Act of 2009

Technical Requirements

You can submit the quarterly reports in three ways:

  • Online data entry. The website provides a data entry form for you to use. A commercial web browser, such as Microsoft’s Internet Explorer or Mozilla Firefox, is required for this option.
  • Excel spreadsheet. A Microsoft Excel spreadsheet can be downloaded, filled in, and uploaded to Be sure to use the Microsoft Excel file titled FederalReportingTemplate—Grants and Loans.xls. The spreadsheet is locked to restrict modification and only allows data to be entered in the required fields. You must have Microsoft Office Excel in 2003 or a newer version to open and edit the spreadsheet. You also must have a commercial web browser for this option.

box with checkmarkAction Item

Please do not modify the structure of the Excel spreadsheet for reporting through If you do so, your submission will be invalid.

  • Custom software system extract in Extensible Markup Language (XML). You will need a data dictionary and XML schema to format and structure the XML system extracts. You can access the XML schema and a service for validating the structure of the XML extracts at This submission option requires a commercial web browser.

Direct recipients and subrecipients that have been delegated to report will be required to enter their FederalReportingPIN (FRPIN) that was provided to the organization’s Point of Contact serving as the Federal Reporting DUNS administrator. For additional information on acquiring a FRPIN, see Chapter 3—FederalReportingPIN {PDF - 401.2 Kb] of the User Guide.

  • The Marketing Partner ID Number (MPIN)is a password created by a user in SAM. In relation to reporting on Recovery Act funds, the MPIN is used to identify the submitter of the report as the direct recipient.
  • Prime recipients will not be able to view subrecipient reports until the direct recipient report is submitted using a valid MPIN for the entity associated with the award.