Checklist for Preparing and Submitting Template 7

Summary

Checklist for Preparing and Submitting Template 7, the Participant Household Payment Data File (PHPDF), for grantees reporting to Treasury's Portal under the ERA2 program. It covers pre-population and formatting, such as using the latest template, correct data elements and date formats, and populating cumulative information on all individual payments made for participant households from receipt of the ERA2 award through the current reporting period. It says to exclude personally identifiable information beyond what is required, P.O. Boxes and landlord addresses, and payments for administrative costs. It gives file naming and upload steps and says the text carries 11/24 as a page marker. The text is Treasury's own reporting guidance.

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

Cite this document

“Checklist for Preparing and Submitting Template 7.” Original at home.treasury.gov. Archived at Pandemic Darlings, https://pandemicdarlings.com/source-documents/department-of-the-treasury-checklist-for-preparing-and-submitting-temp-70068ccc66/, SHA-256 36a8bb265c9723ceb7d3eed4dba6ba680162c06faa56f90c05f0680437dea27b.

Full text

Checklist for Preparing and Submitting Template 7
Participant Household Payment Data File (PHPDF)

 A.   Pre-Population and Formatting
             Latest Template 7 downloaded from the “Bulk Upload Templates and Instructions” tab in Treasury’s Portal
             Columns for Template 7 veriﬁed as containing the correct data elements (note required ﬁelds)
             Column J formatted in “Accounting” format without dollar sign and two decimal points (i.e., ####.##)
             Columns K, M, and N, the “Date” is formatted as follows: MM/DD/YYYY
             No other formatting, column order, added rows or columns for “Totals,” or heading adjustments have been made to
             the table


 B.   Populating Data Elements
      PHPDF Inclusions                                                    PHPDF Exclusions
        Populate with cumulative information on all individual                 Do not include Personally identiﬁable information
        payments made for/to participant households from the                   (PII) beyond what is required for speciﬁc reporting
        date of receipt of the ERA2 award through the end of the               requirements.
        current reporting period
                                                                               For the physical address of the participant
                                                                               household:
        Include multiple data entries (i.e., rows) to reﬂect
                                                                                    do not include P.O. Boxes
        multiple payments to assist a household at the same
                                                                                    do not include landlord addresses
        address (to diﬀerent payees or at diﬀerent points in time)
                                                                                    verify consistent city and state names
        Populate with all “required” ﬁelds, as noted in the                         whenever feasible
        template (see row 5 in Template 7 for details)
                                                                               Do not include payments made for Administrative
                                                                               Costs
        Verify that the Type of Payee should consistently align
        with the following list:
                                                                               Do not include payments made for Housing
             - Tenant
                                                                               Stability Services and Eviction Prevention Services
             - Landlord or Owner
                                                                               (those expenditures should be reported as either
             - Utility or Home Energy Provider
                                                                               “housing stability services” in Table 5 or as an
             - Other Housing Services and Eligible Expenses
                                                                               “Eviction Prevention Project”)
                 Provider
        Note that in situations where a payment is for multiple
        categories of ﬁnancial assistance, report the predominant
        category for the ERA assistance payment.
        Verify that data provided are complete and located in the
        correct columns and in the appropriate format (see A)
        Verify that Template 7 consists of only one ﬁle with one
        tab and one table

 C.   Saving and Uploading the File

             Template 7 saved in this format:
                      PHPDFQXYYERAE####.csv (if .csv format)
                      PHPDFQXYYERAE####.xlsx (if .xlsx format)
             QX refers to the current quarter, YY refers to the year, and ERAE#### refers to the ERA2 Grantee’s 8-digit FAIN
             number
             A copy of the complete Template 7 ﬁle saved for the Grantee’s records
             Template 7 ﬁle upload using the correct ﬁle upload features located on the Performance and Financial Reporting tab
             or on the Individual Document Request (IDR) upload section

                                   See Template 7 Guide for more detailed instructions and tips                                 11/24

File and source

File: department-of-the-treasury-checklist-for-preparing-and-submitting-template-7-phpdf-home-treasury-gov-71b8e1653.pdf
Size: 229,702 bytes
SHA-256: 36a8bb265c9723ceb7d3eed4dba6ba680162c06faa56f90c05f0680437dea27b
Our copy: department-of-the-treasury-checklist-for-preparing-and-submitting-template-7-phpdf-home-treasury-gov-71b8e1653.pdf
Original: home.treasury.gov