Filetype Excel XLSX | Posted on 05 Jul 2022 | 3 years ago
Authentication
digital resources
142x Filetype XLSX File size 0.27 MB Source: home.treasury.gov
Sheet 1: NEU Distribution- Eligible NEUs
| Version: 2021.07.30 | ||||||||||||||||||||||||||||
| 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 |
Note: This template is not the final version and should not be used for submission. Recipients should use the template that will be posted in the Treasury Submission Portal once it opens to report information. | |||||||||||||||||||||||||||
| Field ID | Entered_State_or_Territory__c | NEU_Recipient_Number__c | Name | DUNS__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_Point_of_Contact_Name__c | NEU_POC_Phone_Number__c | NEU_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 | Required | 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 DUNS 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. | NEU/local government DUNS Number. (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 |
| Version: 2021.07.30 | |||||||||||||||
| Template Name: NEU Distribution - Ineligible | |||||||||||||||
| Instructions to Reporter: - Do not change the cell formatting - Do not reformat the template - All data should be as text |
Note: This template is not the final version and should not be used for submission. Recipients should use the template that will be posted in the Treasury Submission Portal once it opens to report information. | Ineligible MCD (only for weak-MCD states) | |||||||||||||
| Field ID | Entered_State_or_Territory__c | Name | DUNS__c | Ineligible_or_Other__c | Additional_Notes__c | ||||||||||
| Required/Optional | Required | Required | Optional | Required | Optional | ||||||||||
| Field Name | State or Territory | NEU Name | NEU DUNS number | Reason for Ineligibility | Notes (Optional) | ||||||||||
| Help Text | Name of the state or territory performing the transfer to the NEU (e.g., California, Maine, Maryland) | Legal name of the NEU organization/local government. | NEU/local government DUNS Number, if known/available (Valid Format XXXXXXXX) | 1) Ineligible MCD (i.e., any Minor Civil Divisions in a "weak-MCD" State that did not meet the facts-and-circumstances test as outlined in Treasury's guidance); 2) Other. If other, please provide additional explanation in Column F, Valid Entries, "Ineligible MDC", "Other". |
Provide an explanation for "Other" ineligibility rationale | ||||||||||
no reviews yet
Please Login to review.
