ERA2 Demographics Reporting Worksheet
Summary
An ERA2 Quarterly Report Demographics Tables worksheet, version 4.1 dated June, 2025, for Emergency Rental Assistance grantees. Hints and tips explain how to populate the worksheet and then the on-screen tables in the reporting portal, Table 1 through Table 5, and what happens when the system finds errors. The tables cover the number of unique households, households assisted by type, households by income or other eligibility, average number of months assisted, and cumulative amounts obligated and expended, with verification sheets for Tables 2 and 3.
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: Cover Page
Worksheet
ERA2 Quarterly Report
Demographics Tables
JUNE, 2025 V 4.1
Sheet: Hints and Tips
Hints and Tips for Completing Tables 1, 2, 3, 4 and 5
Populate this Excel Worksheet to ensure your data will be accepted when entered into the on-screen tables. Once the data appears complete and accurate on this worksheet, move on to manually populating the tables on-screen in the portal.
Hits for populating the on-screen tables:
a) Populate each table separately starting with Table 1 through Table 5. When you first populate a table, the "Cancel" and "Save" buttons will appear in the space immediately below the table.
b) When you have populated all fields in all columns in a table and are ready to move to the next table, click on the Save Button.
c) The system will validate the data entered when you click on the Save Button. If there are any errors or inconsistencies in the data entered, the system will display a red banner alerting you of the issue.
d) When there are errors in the data as entered, the fields where the errors occured will be blank -- that is, the incorrect data you entered and the column totals will not be displayed.
e) The amounts prepopulated on Row 21 on Tables 1,2,3 and 4 are the cumulative amounts entered for the corresponding datapoint on the "Emergency Rental Assistance Project Data" tab. This can be a helpful guide to ensure you enter complete disaggregated data.
f) Table 4 does not calculate or require category totals. Grantees are only required to input the average number of months of assistance provided to households in each subcategory for each type of assistance listed in Columns 4A, 4B, 4C, 4D, and 4E.
Sheet: Table 1
Table 1
Number of Unique Households Column 1A Column 1B
Each field must be populated with a positive whole number or zero "0" without decimal points. Column 1A: Number of unique households that completed and submitted an application Column 1B: Number of Unique households receiving initial assistance in the quarter
Validation Rule for this Column: Values in rows 9, 14 and 20 must be equal. Validation Rule for this Column: Values in rows 9, 14 and 20 must be equal.
Row Segment
1 American Indian or Alaska
2 Asian
3 Black or African American
4 Native Hawaiian or Other
5 White
6 Mixed-Race
7 Data not Collected
8 Declined to Answer
9 Race Category Total 0 0
10 Hispanic or Latino
11 Not Hispanic or Latino
12 Data not Collected
13 Declined to Answer
14 Ethnicity Category Total 0 0
15 Male
16 Female
17 Data not Collected/Reported
18 Declined to Answer
19 Sex Category Total 0 0
20 Prepopulated Totals as reported on the Emergency Rental Assistance Tab. Validation Rule: Amounts in rows 9, 14 and 20 must equal amounts displayed in row 21.
Sheet: Table 2
Table 2
Number of Households Assisted by Type Column 2A Column 2B Column 2C Column 2D Column 2E Column 2F
Each field must be populated with a positive whole number or zero "0" without decimal points. Column 2A: Cumulative Number of Households Receiving ERA2 Assistance Column 2B: Rent Column 2C: Rental Arrears Column 2D: Utility/Home Energy Column 2E: Utility/Home Energy Arrears Column 2F: Other Expenses Related to Housing
Validation Rule for this Column: Values in rows 9, 14, 20 and 21 must be equal. Validation Rule for this Column: Values in rows 9, 14, 20 and 21 must be equal. Validation Rule for this Column: Values in rows 9, 14, 20 and 21 must be equal. Validation Rule for this Column: Values in rows 9, 14, 20 and 21 must be equal. Validation Rule for this Column: Values in rows 9, 14, 20 and 21 must be equal. Validation Rule for this Column: Values in rows 9, 14, 20 and 21 must be equal.
Row Segment
1 American Indian or Alaska
2 Asian
3 Black or African American
4 Native Hawaiian or Other
5 White
6 Mixed-Race
7 Data not Collected
8 Declined to Answer
9 Race Category Total 0 0 0 0 0 0
10 Hispanic or Latino
11 Not Hispanic or Latino
12 Data not Collected
13 Delined to Answer
14 Ethnicity Category Total 0 0 0 0 0 0
15 Male
16 Female
17 Data not Collected/Reported
18 Declined to Answer
19 Sex Category Total 0 0 0 0 0 0
20 Columns 2A, 2B, 2C, 2D, 2E and 2F in this row on the on-screen version will be pre-populated with total amounts reported on the Emergency Rental Assistance Tab. Validation Rule: Amounts in rows 14 and 20 must equal amounts displayed in row 21.
Sheet: Table2 Column 2A Verification
Table 2 Column 2A Verification Sheet Copy Table 1 Column A Copy Table 2 Column A RESULTS
1a.Number of unique households that completed and submitted an application Column 2A: Cumulative Number of Households Receiving ERA2 Assistance RESULTS AND NEXT STEPS: If the figures you enter in Table 1 Column A (Column C on this spreadsheet) are less than the figures you entered in Table 2 Column A (Column D on this spreadsheet) you will need to adjust values on either Column 1A (number of applications received) or Column 2A (number of households receiving assistance). Remember it is not possible for the cumulative number of households receiving assistance to be larger than the cumulative number of households that submitted an application.
Validation Rule for this Column: Values in rows 9, 14, 20 and 21 must be equal. Validation Rule for this Column: Values in rows 9, 14, 20 and 21 must be equal.
Row Segment
1 American Indian or Alaska
2 Asian
3 Black or African American
4 Native Hawaiian or Other
5 White
6 Mixed-Race
7 Data not Collected
8 Declined to Answer
9 Race Category Total 0 0
10 Hispanic or Latino
11 Not Hispanic or Latino
12 Data not Collected
13 Delined to Answer
14 Ethnicity Category Total 0 0
15 Male
16 Female
17 Data not Collected/Reported
18 Declined to Answer
19 Sex Category Total 0 0
20 Columns 2A, 2B, 2C, 2D, 2E and 2F in this row on the on-screen version will be pre-populated with total amounts reported on the Emergency Rental Assistance Tab. Validation Rule: Amounts in rows 14 and 20 must equal amounts displayed in row 21.
Sheet: Table 3
Table 3
Number of Households by Income or Other Eligibility Methods Column 3A Column 3B Column 3C Column 3D Column 3E Column 3F
Each field must be populated with a positive whole number or zero "0" without decimal points. Column 3A: Less than 30% AMI Column 3B: 30-50% AMI Column 3C: 50-80% AMI Column 3D: Household Eligibility Based on Eligibility for other Federal Benefits. ("Eligibility Based on Other Programs"). Column 3E: Household Eligibility Determined using Fact-Based Proxy. ("Eligibility Based on Proxy"). Column 3F: Cumulative ERA2 Funds Paid to/for Participant Households.
Validation Rule for this Column: Values in rows 9, 14, 20 and 21 must be equal. Validation Rule for this Column: Values in rows 9, 14, 20 and 21 must be equal. Validation Rule for this Column: Values in rows 9, 14, 20, and 21 must be equal. Validation Rule for this Column: Values in rows 9, 14, 20 and 21 must be equal. Validation Rule for this Column: Values in rows 9, 14, 20, and 21 must be equal. Validation Rule for this Column: Values in rows 9, 14, 20, and 21 must be equal. Figures entered on this column will convert to a dollar amount with two decimal points. The figures will default to .00 if you enter a whole number or zero.
Row Segment
1 American Indian or Alaska
2 Asian
3 Black or African American
4 Native Hawaiian or Other
5 White
6 Mixed-Race
7 Data not Collected
8 Declined to Answer
9 Race Category Total 0 0 0 0 0 0
10 Hispanic or Latino
11 Not Hispanic or Latino
12 Data not Collected
13 Delined to Answer
14 Ethnicity Category Total 0 0 0 0 0 0
15 Male
16 Female
17 Data not Collected/Reported
18 Declined to Answer
19 Sex Category Total 0 0 0 0 0 0
20 Columns 3A, 3B, 3C, 3D, 3E and 3F in this row on the on-screen version will be pre-populated with total amounts reported on the Emergency Rental Assistance Tab. Validation Rule: Amounts in rows 14 and 20 must equal amounts displayed in row 21.
Sheet: Table 3 Verification Sheet
Table 3 Verification Sheet Copy Table 3 Column 3A Copy Table 3 Column 3B Copy Table 3 Column 3C Copy Table 3 Column 3D Copy Table 3 Column 3E Prepopulated Copy Table 2 Column 2A Results and Next Steps
ACTION: Copy and paste (or retype) data from Column 3A here. Less than 30% AMI ACTION: Copy and paste (or retype) data from Column 3B here: 30-50% AMI ACTION: Copy and paste (or retype) data from Column 3C here: 50-80% AMI ACTION: Copy and paste (or retype) data from Column 3D here: Eligibility Based on Other Programs ACTION: Copy and paste (or retype) data from Column 3E here: Eligibility Based on Proxy The sum of figures inputted in the fields copied from Columns 3A, 3B, 3C, 3D and 3E will populate in this column. ACTION: Copy and paste (or retype) values in Table 2 Column 2A: Cumulative Number of Households Receiving ERA2 Assistance here. RESULTS AND NEXT STEPS: If the figures prepopulated in Column H in this spreadsheet are larger than the Figures you copy or past into Column I, you will need to adjust values on Table 3 Columns 3A, 3B, 3C, 3D, and/or 3E .
Validation Rule for this Column: Values in rows 9, 14, 20 and 21 must be equal. Validation Rule for this Column: Values in rows 9, 14, 20 and 21 must be equal. Validation Rule for this Column: Values in rows 9, 14, 20 and 21 must be equal. Validation Rule for this Column: Values in rows 9, 14, 20 and 21 must be equal. Validation Rule for this Column: Values in rows 9, 14, 20 and 21 must be equal. Validation Rule for Table 3: The sum of amounts in Table 3 Columns 3A + 3B + 3C + 3D + 3E must be less than or equal to amounts in Table 2 Column 2A (Cumulative Number of Households Receiving ERA2 Assistance.)
Row Segment
1 American Indian or Alaska 0
2 Asian 0
3 Black or African American 0
4 Native Hawaiian or Other 0
5 White 0
6 Mixed-Race 0
7 Data not Collected 0
8 Declined to Answer 0
9 Race Category Total 0 0 0 0 0 0
10 Hispanic or Latino 0
11 Not Hispanic or Latino 0
12 Data not Collected 0
13 Declined to Answer 0
14 Ethnicity Category Total 0 0 0 0 0 0
15 Male 0
16 Female 0
17 Data not Collected/Reported 0
18 Declined to Answer 0
19 Sex Category Total 0 0 0 0 0 0
20 Columns 3A, 3B, 3C, 3D, 3E and 3F in this row on the on-screen version will be pre-populated with total amounts reported on the Emergency Rental Assistance Tab. Validation Rule: Amounts in rows 14 and 20 must equal amounts displayed in row 21.
Sheet: Table 4
Table 4
Average Number of Months Assisted Column 4
Each field must be populated with a positive number with up to two decimal points or zero "0". The table does not require or populate the category totals. Column 4: Rent or Utility/Home Energy Payments
Row Segment
1 American Indian or Alaska
2 Asian
3 Black or African American
4 Native Hawaiian or Other
5 White
6 Mixed-Race
7 Data not Collected
8 Declined to Answer
9 Race Category Total
10 Hispanic or Latino
11 Not Hispanic or Latino
12 Data not Collected
13 Delined to Answer
14 Ethnicity Category Total
15 Male
16 Female
17 Data not Collected/Reported
18 Declined to Answer
19 Sex Category Total
21 Columns 4A in this row on the on-screen version will be pre-populated with amount reported on the Emergency Rental Assistance Tab. Validation Rule: None.
Sheet: Table 5
Table 5
Cumulative Amounts Obligated and Expended -- Emergency Rental Assistance Project
Each field must be populated with a positive whole number or zero "0" without decimal points.
Item Number Enter Data in this Column
Item 1 Total Cumulative Expenditures for the Emergency Rental Assistance Project (This figure is pre-populated at the top of Table 4 and also on the Project Overview tab dashboard.)
Item 2 Total dollar amount of ERA2 funds paid cumulatively from award date through the end of the reporting period to or for participant housholds.
Item 3 Total dollar amount of ERA2 funds paid (expended) for administrative expenses cumulatively from award date through the end of the reporting period .
Item 4 Total dollar amount of ERA2 funds obligated for administrative expenses cumulatively from award date through the end of the reporting period .
Item 5 Total dollar amount of ERA2 funds paid (expended) for housing stability services cumulatively from award date through the end of the reporting period .
Item 6 Total dollar amount of ERA2 funds obligated for housing stability services cumulatively from award date through the end of the reporting period .
Item 7 Cumulative number of unique participant households that received housing stability services under the ERA2 Emergency Rental Assistance Project from award date through the end of the reporting period.
Verification Rule: The Sum of Items 2 + 3 + 5 must equal to the amount entered for Item 1. If the verification fails, please confirm both the total ERA2 Rental Assistance Project expenditures as reported on the Project Overview Tab and the figures entered for items 2, 3 and 5. Correct your data entries as needed.
Verification Rule: The amount entered for Item 3 must be equal to or less than the amount entered for Item 4. (The amount expended for administrative costs must be equal to or less than the amount obligated for administrative costs.)
Verification Rule: The amount entered for Item 3 must be equal to or less than the amount entered for Item 4. (The amount expended for housing stability costs must be equal to or less than the amount obligated for those housing stability costs.)
File and source
- File
- TREAS-ERA2-Demographic-Reporting-Worksheet.xlsx
- Size
- 73,271 bytes
- SHA-256
- 96e9c528afdf81b35ce692fd598ef0f2eef3a2c29e7cd503ca0494ce4a7d4196
- Original
- home.treasury.gov