FederalReporting.gov Template - Grants and Loans

---

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