FederalReporting.gov Template - Grants and Loans

Section 1512 Data Elements - Federal Financial Assistance

FederalReportingTemplate - Grants and Loans.xls

Section 1512 Data Elements - State/local/tribal governments

OMB: 0430-0004

Document [xlsx]
Download: xlsx | pdf

Overview

Instructions
Prime Recipient
Sub Recipients
Vendors


Sheet 1: Instructions

Recipient Report Instructions

Version: 1.6
Instructions:



You are submitting a report for a Grant or Loan award.



Instruction Required Worksheets



If you are a Prime Recipient who is submitting a report or reports on behalf of your Sub Recipient, you must fill out these worksheets (see the tabs at the bottom of the screen): Prime Recipient



Sub Recipients



Vendors (optional)



If you are a Prime Recipient who is not submitting a report or reports on behalf of your Sub Recipient, you must fill out these worksheets (see the tabs at the bottom of the screen): Prime Recipient



Vendors (optional)



If you are a Sub Recipient who is submitting a report, you must fill out these worksheets (see the tabs at the bottom of the screen):

NOTE: For Sub Recipient reporting for self, the DUNS numbers populated in the "Sub Recipient DUNS Number" field on the "Sub Recipients" tab must all be the same regardless of the Sub Award Numbers.
Sub Recipients



Vendors (optional)



Note: If entering Sub Recipients and/or Vendors in your report, you must enter one Sub Recipient Award or Vendor per numbered row. Do not leave a blank row between entries.















Notes
Potential Question Answer
Not all of my text is showing up when I enter values a narrative field. For example, when entering text for the Project Description field. 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.
When I try to select a value from a drop-down menu, the text is too small to read. How to I make it bigger? Check to make sure you're 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.
I don't know which CFDA to use. A list of CFDA Codes applicable to Recovery Act reporting can be found on the Downloads page at FederalReporting.gov. You can also access this list via https://www.cfda.gov/index?s=program&tab=searchresults&mode=list&_filt=rec&cck=1&au=&ck=.
I'm not sure what each of the data elements mean. You can either click on each cell for instructional text or reference the Data Model document published on Recovery.gov
I have more than 400 Sub Recipients or Vendors to add, but the spreadsheet looks like it is limited to 400. You can continue to add additional Sub Recipients and Vendors beyond the #400 line provided for 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 excessievly large. Data validation will be performed once your report is uploaded on FederalReporting.gov.

Sheet 2: Prime Recipient

Recipient Report: Grant or Loan

Version: 1.6


Prime Recipient










Reporting Information


Award Type* Award Number* Final Report*
















Award Recipient Information


Recipient DUNS Number* Recipient Account Number Recipient Congressional District*
















Award Information
Need Help Finding Award Information?
Funding Agency Code* Awarding Agency Code* Award Date*
Browse the Full Listings by using the drop-down lists.




Agency Drop-Down List: 1200 - Department of Agriculture
Amount of Award* CFDA Number*

Program Source (TAS) Drop-Down List: 12-0111-USDA-Office of the Secretary of Agriculture-Agriculture Buildings and Facilities and Rental Payments



Know the code and want to check the name?
Search by Code
Program Source (TAS)* Sub Account Number for Program Source (TAS)
Enter Agency Code: 1201



Agency Name: Office of the Secretary of Agriculture
Total Number of Sub Awards to Individuals* Total Amount of Sub Awards to Individuals*
Enter Program Source (TAS) Code: 12-0111



Program Source (TAS) Name: USDA-Office of the Secretary of Agriculture-Agriculture Buildings and Facilities and Rental Payments
Total Number of Payments to Vendors less than $25,000/award* Total Amount of Payments to Vendors less than $25,000/award*
Know the name and want to find the code?
Search by Name



Enter Agency Name: Department of Agriculture
Total Number of Sub Awards less than $25,000/award* Total Amount of Sub Awards less than $25,000/award*
Agency Code: 1200



Enter Program Source (TAS) Name: USDA-Office of the Secretary of Agriculture-Agriculture Buildings and Facilities and Rental Payments
Award Description*
Program Source (TAS) Code: 12-0111




Number of characters entered: 0










Project Information


Project Name or Project/Program Title* Project Status* Total Federal Amount ARRA Funds Received/Invoiced*








Number of Jobs* Description of Jobs Created*







Number of characters entered: 0


Quarterly Activities/Project Description*















Number of characters entered: 0
Need Help Finding an Activity, State, or Country Code?
Activity Code (NAICS or NTEE-NPC)*

Browse the Full Listing by using the drop-down list.
1
2

Activity Code Drop-Down List: Z99 - NTEE - Unknown
3
4

State Drop-Down List: AK - Alaska
5
6

Country Drop-Down List: US - United States
7
8

Know the code and want to check the name?
Search by Code
9
10

Enter Activity Code: 111110
Total Federal Amount of ARRA Expenditure* Total Federal ARRA Infrastructure Expenditure Infrastructure Contact Name
Activity Name: Soybean Farming




Enter State Code: CA
Infrastructure Contact Email Infrastructure Contact Phone Infrastructure Contact Phone Ext
State Name: California




Enter Country Code: US
Infrastructure Contact Street Address 1 Infrastructure Contact Street Address 2 Infrastructure Contact Street Address 3
Country Name: United States




Know the name and want to find the code?
Search by Name
Infrastructure City Infrastructure State Infrastructure ZIP Code+4
Enter Activity Name: Other Vegetable (except Potato) and Melon Farming




Activity Code: 111219
Infrastructure Purpose and Rationale
Enter State Name: California


State Code: CA
Number of characters entered: 0
Enter Country Name: United States


Country Code: US
Primary Place of Performance


Street Address 1 Street Address 2 City*








State* ZIP Code+4* Congressional District*








Country*















Recipient Highly Compensated Officers


Prime Recipient Indication of Reporting Applicability* # Officer Name Officer Compensation



1





2




3




4




5





Sheet 3: Sub Recipients


Recipient Report: Grant or Loan
Version: 1.6


Locate a State Code














Sub Recipient


Browse the State Drop-Down List: Enter State Name: Found State Code:





















AK - Alaska Alaska AK














Reporting Information



Locate a Country Code














Award Type* Award Number* Recipient DUNS Number*



Browse the Country Drop-Down List: Enter Country Name: Found Country Code:





















US - United States United States US







































Sub Recipient Information Sub Award Information Sub Recipient Place of Performance Sub Recipient Highly Compensated Officers
No. Sub Recipient DUNS Number* Sub Award Number* Sub Recipient Congressional District* Amount of Sub Award* Total Sub Award Funds Disbursed* Sub Award Date* Street Address 1 Street Address 2 City* State* ZIP Code+4* Congressional District* Country* Sub Recipient Indication of Reporting Applicability* Officer 1 Name Officer 1 Compensation Officer 2 Name Officer 2 Compensation Officer 3 Name Officer 3 Compensation Officer 4 Name Officer 4 Compensation Officer 5 Name Officer 5 Compensation
1























2























3























4























5























6























7























8























9























10























11























12























13























14























15























16























17























18























19























20























21























22























23























24























25























26























27























28























29























30























31























32























33























34























35























36























37























38























39























40























41























42























43























44























45























46























47























48























49























50























51























52























53























54























55























56























57























58























59























60























61























62























63























64























65























66























67























68























69























70























71























72























73























74























75























76























77























78























79























80























81























82























83























84























85























86























87























88























89























90























91























92























93























94























95























96























97























98























99























100























101























102























103























104























105























106























107























108























109























110























111























112























113























114























115























116























117























118























119























120























121























122























123























124























125























126























127























128























129























130























131























132























133























134























135























136























137























138























139























140























141























142























143























144























145























146























147























148























149























150























151























152























153























154























155























156























157























158























159























160























161























162























163























164























165























166























167























168























169























170























171























172























173























174























175























176























177























178























179























180























181























182























183























184























185























186























187























188























189























190























191























192























193























194























195























196























197























198























199























200























201























202























203























204























205























206























207























208























209























210























211























212























213























214























215























216























217























218























219























220























221























222























223























224























225























226























227























228























229























230























231























232























233























234























235























236























237























238























239























240























241























242























243























244























245























246























247























248























249























250























251























252























253























254























255























256























257























258























259























260























261























262























263























264























265























266























267























268























269























270























271























272























273























274























275























276























277























278























279























280























281























282























283























284























285























286























287























288























289























290























291























292























293























294























295























296























297























298























299























300























301























302























303























304























305























306























307























308























309























310























311























312























313























314























315























316























317























318























319























320























321























322























323























324























325























326























327























328























329























330























331























332























333























334























335























336























337























338























339























340























341























342























343























344























345























346























347























348























349























350























351























352























353























354























355























356























357























358























359























360























361























362























363























364























365























366























367























368























369























370























371























372























373























374























375























376























377























378























379























380























381























382























383























384























385























386























387























388























389























390























391























392























393























394























395























396























397























398























399























400
























Sheet 4: Vendors


Recipient Report: Grant or Loan
Version: 1.6


Vendors








Reporting Information




Award Number*
















No. Subaward Number(*) Vendor DUNS Number(*) Vendor Name(*) Vendor HQ ZIP Code+4(*) Product and Service Description Payment Amount
1





2





3





4





5





6





7





8





9





10





11





12





13





14





15





16





17





18





19





20





21





22





23





24





25





26





27





28





29





30





31





32





33





34





35





36





37





38





39





40





41





42





43





44





45





46





47





48





49





50





51





52





53





54





55





56





57





58





59





60





61





62





63





64





65





66





67





68





69





70





71





72





73





74





75





76





77





78





79





80





81





82





83





84





85





86





87





88





89





90





91





92





93





94





95





96





97





98





99





100





101





102





103





104





105





106





107





108





109





110





111





112





113





114





115





116





117





118





119





120





121





122





123





124





125





126





127





128





129





130





131





132





133





134





135





136





137





138





139





140





141





142





143





144





145





146





147





148





149





150





151





152





153





154





155





156





157





158





159





160





161





162





163





164





165





166





167





168





169





170





171





172





173





174





175





176





177





178





179





180





181





182





183





184





185





186





187





188





189





190





191





192





193





194





195





196





197





198





199





200





201





202





203





204





205





206





207





208





209





210





211





212





213





214





215





216





217





218





219





220





221





222





223





224





225





226





227





228





229





230





231





232





233





234





235





236





237





238





239





240





241





242





243





244





245





246





247





248





249





250





251





252





253





254





255





256





257





258





259





260





261





262





263





264





265





266





267





268





269





270





271





272





273





274





275





276





277





278





279





280





281





282





283





284





285





286





287





288





289





290





291





292





293





294





295





296





297





298





299





300





301





302





303





304





305





306





307





308





309





310





311





312





313





314





315





316





317





318





319





320





321





322





323





324





325





326





327





328





329





330





331





332





333





334





335





336





337





338





339





340





341





342





343





344





345





346





347





348





349





350





351





352





353





354





355





356





357





358





359





360





361





362





363





364





365





366





367





368





369





370





371





372





373





374





375





376





377





378





379





380





381





382





383





384





385





386





387





388





389





390





391





392





393





394





395





396





397





398





399





400





File Typeapplication/vnd.ms-excel
AuthorFederalReporting.gov
Last Modified Byjennifer.dure
File Modified2009-12-29
File Created2009-07-27

© 2024 OMB.report | Privacy Policy