NEU Distribution - Eligible NEU's — Version: 2022.06.02 — Instructions to Reporter

Summary

A reporting template, NEU Distribution - Eligible NEU's, version 2022.06.02, for a state or territory to list the non-entitlement units of local government (NEUs) eligible for distributions. It instructs reporters not to change cell formatting or reformat the template and to enter all data as text. The fields include the state or territory, the NEU recipient number, name, UEI and EIN, address, contacts, the authorized representative, an action status, and original and revised budget and tranche allocation amounts.

Summary drafted by a model from the document's text below and checked by script against that text before publication. It is a navigation aid, not a reading of what the document proves. Where AI is used

Full text

Text extracted from the spreadsheet file: one line per row, cells separated by tabs, each sheet headed by its name. Numbers appear as stored, without the workbook’s formatting.

Sheet: NEU Distribution Eligible Templ
Version: 2022.06.02
Template Name: NEU Distribution - Eligible NEU's
Instructions to Reporter: - Do not change the cell formatting - Do not reformat the template - All data should be as text
Field ID	Entered_State_or_Territory__c	NEU_Recipient_Number__c	Name	UEI__c	EIN__c	Address__c	Address_2__c	Address_3__c	City__c	State_Abbreviated__c	Zip__c	Zip_4__c	NEU_Email_Address__c	NEU_Primary_Point_of_Contact_Name__c	NEU_Primary_POC_Phone_Number__c	NEU_Primary_POC_Email__c	Authorized_Representative_Name__c	Authorized_Representative_Email__c	Status_Action_or_No_Action__c	Total_NEU_Budget_Ref_orig__c	Total_NEU_Budget_Ref_rev__c	TOT_Allocation_1_2_Tranches_orig__c	TOT_Allocation_1_2_Tranches_1st_rev__c	TOT_Allocation_1_2_Tranches_2nd_rev__c	Final_Allocation_After_75_Budget_Cap__c	Final_Alloc_After_75_Budget_Cap_rev_1__c	Final_Alloc_After_75_Budget_Cap_rev_2__c	Additional_Notes__c
Required/Optional	Required	Required	Required	Required	Required	Required	Optional	Optional	Required	Required	Required	Optional	Required	Required	Required	Required	Required	Required	Required	Required	Optional	Required	Optional	Optional	Required	Optional	Optional	Optional
Field Name	State or Territory	NEU Recipient Number	NEU Name	NEU UEI number	NEU Taxpayer Identification Number (TIN)	NEU Address 1	NEU Address 2	NEU Address 3	NEU City	NEU State	NEU Zip Code	NEU Zip +4	NEU Email Address	NEU Point of Contact Name	NEU Point of Contact Phone Number	NEU Point of Contact Email	Authorized Representative Name	Authorized Representative Email	Status	Total NEU Budget Reference (original)	Total NEU Budget Reference (revised, if applicable)	Total Allocation Across 1st and 2nd Tranches (before application of 75 percent budget cap) (original)	Total Allocation Across 1st and 2nd Tranches (before application of 75 percent budget cap) (first revision, if applicable)	Total Allocation Across 1st and 2nd Tranches (before application of 75 percent budget cap) (second revision, if applicable)	Final Allocation Across 1st and 2nd Tranches after application of the 75 percent budget cap	Final Allocation Across 1st and 2nd Tranches after application of the 75 percent budget cap (first revision, if applicable)	Final Allocation Across 1st and 2nd Tranches after application of the 75 percent budget cap (second revision, if applicable)	Additional Notes
Help Text	Name of the state or territory performing the transfer to the NEU (e.g, California, Maine, Maryland)	A unique identification code for each NEU assigned by the State to the NEU as part of the request for funding (e.g., AZ1003)	Legal name of the NEU organization/local government.	Unique Entity Identifier. (Valid Format XXXXXXXX)	NEU Taxpayer Identification Number (TIN)  (Valid Format XXXXXXXX)	First line of the NEU organization's address.	Second line of the NEU organization's address.	Third line of the NEU organization's address.	Name of city in which the NEU organization is located.	United States Postal Service (USPS) two-letter abbreviation for the state or territory in which the NEU organization is located. Valid Response:  (AL, AK, AS, AZ, AR, CA, CO, CT, DE, DC, FM, FL, GA, GU, HI, ID, IL, IN, IA, KS, KY, LA, ME, MH, MD, MA, MI, MN, MS, MO, MT, NE, NV, NH, NJ, NM, NY, NC, ND, MP, OH, OK, OR, PW, PA, PR, RI, SC, SD, TN, TX, UT, VT, VI, VA, WA, WV, WI, WY)	United States ZIP code (five digits) associated with the NEU's  address.   Format XXXXX, 5 numeric characters.	Zip Plus4 (four digits) for the NEU's address.  Format XXXX, 4 numeric characters.	Email address of the NEU organization.	Name of a Point of Contact at the NEU.	Phone number of the primary Point of Contact for the NEU organization.	Email address of the primary Point of Contact for the NEU organization.	Name of an Authorized Representative of the NEU.  If the primary point of contact is also the authorized representative, please provide the name again.	Email of an Authorized Representative of the NEU.  If the primary point of contact is also the authorized representative, please provide the email again.	Eligibility status of a given NEU.  Indicate the NEU's status: 1) Action Taken (i.e., the NEU requested funding or declined funding & requested Sec. 603(c)(4) transfer to the state); or 2) Action Not Taken (i.e., the NEU is nonresponsive / declined funding), Valid Entries. "Action Taken", "Action Not Taken"	Provide the Total NEU Budget Reference submitted by the NEU as part of its request for funding or Sec. 603(c)(4) transfer to the state DO NOT include a "$" sign when entering Amounts.	Provide the revised Total NEU Budget Reference, if revisions were made based on updated NEU Guidance (i.e., updated Treasury guidance on interpretation of the 75 percent budget cap issued on June 30, 2021) DO NOT include a "$" sign when entering Amounts.	Provide the Total Allocation Across 1st and 2nd Tranches before application of the 75 percent budget cap. DO NOT include a "$" sign when entering Amounts.	Provide the Total Allocation Across 1st and 2nd Tranches (before application of 75 percent budget cap) (first revision, if applicable). DO NOT include a "$" sign when entering Amounts.	Provide the Total Allocation Across 1st and 2nd Tranches (before application of 75 percent cap) (second revision, if applicable) DO NOT include a "$" sign when entering Amounts.	Final Allocation Across 1st and 2nd Tranches after application of the 75 percent budget cap. DO NOT include a "$" sign when entering Amounts.	Final Allocation Across 1st and 2nd Tranches after application of the 75 percent budget cap (first revision, if applicable) DO NOT include a "$" sign when entering Amounts.	Final Allocation Across 1st and 2nd Tranches after application of the 75 percent budget cap (second revision, if applicable) DO NOT include a "$" sign when entering Amounts.	Include any additional notes required to explain the NEU distribution summary line items, as applicable

File and source

File: TREAS-NEU-Distribution-Eligible-NEUs.xlsx
Size: 22,141 bytes
SHA-256: 2f959da1c5f0614427b5c8c06480dc3c914d9be9617db3a284d7a2cfc6dd50cb
Our copy: TREAS-NEU-Distribution-Eligible-NEUs.xlsx
Original: home.treasury.gov