Template 7: ERA2 Participant Household Payment Data File Template (2024)
Summary
Template 7 sets out the columns of the ERA2 participant household payment data file, version 2021.07.15, revised 2024.02.27, with special instructions available at www.Treasury.gov/era. Each record covers a payment for a participant household: the household's physical address (P.O. Boxes cannot be accepted), city, state code, ZIP and ZIP+4, payee type, amount of payment, date of payment, the type of assistance the payment covers, and the start and end dates covered. Payee type is one of Tenant; Landlord or Owner; Utility / Home Energy Service Provider; or Other Housing Services and Eligible Expenses Provider. Assistance type is rent, rental arrears, utility or home energy costs, their arrears, or other housing costs. Address lines 2 and 3, ZIP+4 and the end date are optional; amounts go in without a $ sign and dates as MM/DD/YYYY.
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 of the spreadsheet as stored: one line per row, cells separated by " | ".
Sheet: Sheet 1 Version: 2021.07.15 - rev - 2024.02.27 Template Name: Template_7_ERA2_Participant_Household_Payment_Data_File_Template_2024 Please see special instructions: "Tip - Preparing the Participant Household Payment Data File Template 7 Before Inputting Data" available on the reporting tab at www.Treasury.gov/era Label | Address Line 1 | Address Line 2 | Address Line 3 | City Name | State Code | Zip5 | Zip4 | Payee Type | Amount of Payment | Date of Payment | Type of Assistance Covered by the payment | Start Date Covered by the Payment | End Date Covered by the Payment Required or Optional | Required | Optional | Optional | Required | Required | Required | Optional | Required | Required | Required | Required | Required | Optional Help Text | Record the first line of physical address for the Participant Household receiving assistance. *P.O. Boxes cannot be accepted | Record the second line of physical address for the Participant Household receiving assistance. | Record the third line of physical address for the Participant Household receiving assistance. | Name of the city in which the Participant Household address is located. | Report the United States Postal Service (USPS) two-letter abbreviation for the state or territory in which the address of the Participant Household receiving assistance is located. Valid Responses: (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) | Report the United States ZIP code (five digits) concatenated with the additional +4 digits associated with the physical address of the Participant Household receiving assistance. Format XXXXX, 5 numeric characters. | Zip Plus4 (four digits) identifying the physical address of the Participant Household receiving assistance. Format XXXX, 4 numeric characters. Leave the field as blank if you do not have Zip Plus4 data. | Here you will identify the type of entity/individual who was paid the ERA assistance. Please copy and paste ONE of the following choices as appropriate: - Tenant - Landlord or Owner - Utility / Home Energy Service Provider - Other Housing Services and Eligible Expenses Provider | Report the total amount dispersed to the Payee (entity or individual). DO NOT INCLUDE $ sign when entering amount. | Report the date which payment was processed to Payee (entity or individual). Format MM/DD/YYYY | Here you will identify the predominant type of ERA assistance covered by the payment to Payee (entity or individual). Please enter copy and paste ONE of the following choices as appropriate: - Financial Assistance: Rent; - Financial Assistance: Rental Arrears; - Financial Assistance: Utility/Home Energy Costs; - Financial Assistance: Utility/Home Energy Costs Arrears; - Financial Assistance: Other Housing Costs; | Report the start date indicating the time period covered by the assistance. Format MM/DD/YYYY | Report the end date indicating the time period covered by the assistance. Format MM/DD/YYYY
File and source
- File
- TREAS-Template_7_ERA2_Participant_Household_Payment_Data_File_Template_2024.xlsx
- Size
- 89,357 bytes
- SHA-256
- 035b44621c85a403d3c87141b1cacf8ffe1f6ed7682537aec1655a64f9601245
- Original
- home.treasury.gov