Audit 318000

FY End
2023-06-30
Total Expended
$145.60M
Findings
28
Programs
18
Organization: City of Stockton (CA)
Year: 2023 Accepted: 2024-08-27

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
485187 2023-003 Significant Deficiency - AB
485188 2023-003 Significant Deficiency - AB
485189 2023-003 Significant Deficiency - AB
485190 2023-003 Significant Deficiency - AB
485191 2023-005 Significant Deficiency - L
485192 2023-003 Significant Deficiency - AB
485193 2023-006 Significant Deficiency Yes N
485194 2023-003 Significant Deficiency - AB
485195 2023-006 Significant Deficiency Yes N
485196 2023-003 Significant Deficiency - AB
485197 2023-006 Significant Deficiency Yes N
485198 2023-004 Material Weakness Yes E
485199 2023-004 Material Weakness Yes E
485200 2023-004 Material Weakness Yes E
1061629 2023-003 Significant Deficiency - AB
1061630 2023-003 Significant Deficiency - AB
1061631 2023-003 Significant Deficiency - AB
1061632 2023-003 Significant Deficiency - AB
1061633 2023-005 Significant Deficiency - L
1061634 2023-003 Significant Deficiency - AB
1061635 2023-006 Significant Deficiency Yes N
1061636 2023-003 Significant Deficiency - AB
1061637 2023-006 Significant Deficiency Yes N
1061638 2023-003 Significant Deficiency - AB
1061639 2023-006 Significant Deficiency Yes N
1061640 2023-004 Material Weakness Yes E
1061641 2023-004 Material Weakness Yes E
1061642 2023-004 Material Weakness Yes E

Contacts

Name Title Type
YV3KNQAKJLQ7 Jay Kapoor Auditee
2099378212 Sophia Kuo Auditor
No contacts on file

Notes to SEFA

Title: Reporting Entity Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards (the "Schedule") includes the federal award activity of City under programs of the federal government for the year ended June 30, 2023. The information in this Schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (the “Uniform Guidance”). Because the Schedule presents only a selected portion of the operations of City, it is not intended to and does not present the financial position of the City. Negative amounts reflected in the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. De Minimis Rate Used: N Rate Explanation: The City has not elected to use the 10 percent de-minimis indirect rate as allowed under Uniform Guidance. The financial reporting entity consists of the primary government, City of Stockton, California (the “City”), organizations for which the primary government is financially accountable, and other organizations for which the nature and significance of their relationship with the primary government are such that exclusion would cause the reporting entity’s financial statements to be misleading or incomplete. The City Council acts as the governing body and is able to impose its will on the following organizations, establishing financial accountability: - The Stockton Public Financing Authority - Fiduciary Component Unit: - Successor Agency of the Former Redevelopment Agency of the City of Stockton
Title: Basis of Presentation Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards (the "Schedule") includes the federal award activity of City under programs of the federal government for the year ended June 30, 2023. The information in this Schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (the “Uniform Guidance”). Because the Schedule presents only a selected portion of the operations of City, it is not intended to and does not present the financial position of the City. Negative amounts reflected in the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. De Minimis Rate Used: N Rate Explanation: The City has not elected to use the 10 percent de-minimis indirect rate as allowed under Uniform Guidance. The accompanying Schedule of Expenditures of Federal Awards (the "Schedule") includes the federal award activity of City under programs of the federal government for the year ended June 30, 2023. The information in this Schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (the “Uniform Guidance”). Because the Schedule presents only a selected portion of the operations of City, it is not intended to and does not present the financial position of the City. Negative amounts reflected in the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. The Schedule also includes $2,779,929 of federal award activity from prior years that was not included in the City’s previously issued Single Audit Reports. For more information, refer to the current year finding 2023-002.
Title: Summary of Significant Accounting Policies Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards (the "Schedule") includes the federal award activity of City under programs of the federal government for the year ended June 30, 2023. The information in this Schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (the “Uniform Guidance”). Because the Schedule presents only a selected portion of the operations of City, it is not intended to and does not present the financial position of the City. Negative amounts reflected in the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. De Minimis Rate Used: N Rate Explanation: The City has not elected to use the 10 percent de-minimis indirect rate as allowed under Uniform Guidance. Expenditures reported on the Schedule are reported on the accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement.
Title: Indirect Cost Rate Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards (the "Schedule") includes the federal award activity of City under programs of the federal government for the year ended June 30, 2023. The information in this Schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (the “Uniform Guidance”). Because the Schedule presents only a selected portion of the operations of City, it is not intended to and does not present the financial position of the City. Negative amounts reflected in the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. De Minimis Rate Used: N Rate Explanation: The City has not elected to use the 10 percent de-minimis indirect rate as allowed under Uniform Guidance. The City has not elected to use the 10 percent de-minimis indirect rate as allowed under Uniform Guidance.

Finding Details

2023-003 – Allowable Costs/Cost Principles – Internal Control over Payroll Expenditures Identification of the Federal Program: Assistance Listing Number: 14.231 Assistance Listing Title: Emergency Solutions Grant Program Federal Agency: U.S. Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Identification Number: E-20-MW-06-0026, E-21-MC-06-0026, E-22-MC-06-0026 Assistance Listing Number: 14.218 Assistance Listing Title: Community Development Block Grants-Entitlement Grants Cluster Federal Agency: U.S. Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Identification Number: B-20-MW-06-0026, B-21-MC-06-0026, B-22-MC-06-0026, B-23-MC-06-0026 Program Income Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): Total salaries charged to Federal awards (including extra service pay) are subject to the Standards of Documentation as described by 2 CFR §200.430(i). Per this section, salaries and wages charged to Federal awards must be based on records that accurately reflect the work performed. These records must: - Be incorporated into the organization’s official records; - Reasonably reflect the total activity for which the employee is compensating across all grant related and non-grant related activities (100% effort); - Support the distribution of employee salary across multiple activities or cost objectives (for example, effort spent on multiple federal awards, spent on general/or administrative activities, vacation, sick leave, leave without pay, etc.); and - Utilize an "after-the-fact" review of the employee’s actual hours worked during the reporting period for identifying and correcting significant changes (as defined by the organization’s written policies). Condition: Emergency Solutions Grant Program The City was unable to locate and provide the timesheets for (2) out of eleven (11) samples tested with Payroll Cost allocated to the Program. Within the overall population of a hundred and five (105) lines of ESG and ESGCV payroll charges, the City also had four (4) unsupported employee benefits charged to the program has benefit charged to program. Community Development Block Grants-Entitlement Grants Cluster Payroll costs for eighteen (18) out of forty (40) samples tested were allocated to programs were not supported by approved time samples or updated cost allocation methods/plan, nor were they reconciled to actual time spent on the various programs. Cause: The City did not adhere to its established policies and procedures for verifying that employee compensation charged to federal programs was supported by contemporaneous time records or an after-the-fact distribution of actual time and effort spent on federal program activities. Additionally, a thorough review and reconciliation of payroll time entries and postings from the old financial system (HTE) to the new financial system (MUNIS) was not conducted, resulting in the failure to preserve supporting documentation, such as timesheets, during the transition process. Effect or Potential Effect: The City did not comply with the program’s requirements for allowable costs. There is an increased risk that employees’ compensation charged to the program may not have represented an actual time and effort expended on the program’s activities. Questioned Costs: None. Context: See condition above for the context of the finding. Identification as a Repeat Finding, If Applicable: Not applicable. Recommendation: We recommend that the City enhance its internal controls over payroll processes by implementing policies and procedures that ensure employee compensation charged to federal programs is supported by contemporaneous or after-the-fact documentation of actual time and effort spent on federal program activities. Additionally, all supporting documentation should be properly saved. Views of Responsible Officials: Management concurs with the finding.
2023-003 – Allowable Costs/Cost Principles – Internal Control over Payroll Expenditures Identification of the Federal Program: Assistance Listing Number: 14.231 Assistance Listing Title: Emergency Solutions Grant Program Federal Agency: U.S. Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Identification Number: E-20-MW-06-0026, E-21-MC-06-0026, E-22-MC-06-0026 Assistance Listing Number: 14.218 Assistance Listing Title: Community Development Block Grants-Entitlement Grants Cluster Federal Agency: U.S. Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Identification Number: B-20-MW-06-0026, B-21-MC-06-0026, B-22-MC-06-0026, B-23-MC-06-0026 Program Income Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): Total salaries charged to Federal awards (including extra service pay) are subject to the Standards of Documentation as described by 2 CFR §200.430(i). Per this section, salaries and wages charged to Federal awards must be based on records that accurately reflect the work performed. These records must: - Be incorporated into the organization’s official records; - Reasonably reflect the total activity for which the employee is compensating across all grant related and non-grant related activities (100% effort); - Support the distribution of employee salary across multiple activities or cost objectives (for example, effort spent on multiple federal awards, spent on general/or administrative activities, vacation, sick leave, leave without pay, etc.); and - Utilize an "after-the-fact" review of the employee’s actual hours worked during the reporting period for identifying and correcting significant changes (as defined by the organization’s written policies). Condition: Emergency Solutions Grant Program The City was unable to locate and provide the timesheets for (2) out of eleven (11) samples tested with Payroll Cost allocated to the Program. Within the overall population of a hundred and five (105) lines of ESG and ESGCV payroll charges, the City also had four (4) unsupported employee benefits charged to the program has benefit charged to program. Community Development Block Grants-Entitlement Grants Cluster Payroll costs for eighteen (18) out of forty (40) samples tested were allocated to programs were not supported by approved time samples or updated cost allocation methods/plan, nor were they reconciled to actual time spent on the various programs. Cause: The City did not adhere to its established policies and procedures for verifying that employee compensation charged to federal programs was supported by contemporaneous time records or an after-the-fact distribution of actual time and effort spent on federal program activities. Additionally, a thorough review and reconciliation of payroll time entries and postings from the old financial system (HTE) to the new financial system (MUNIS) was not conducted, resulting in the failure to preserve supporting documentation, such as timesheets, during the transition process. Effect or Potential Effect: The City did not comply with the program’s requirements for allowable costs. There is an increased risk that employees’ compensation charged to the program may not have represented an actual time and effort expended on the program’s activities. Questioned Costs: None. Context: See condition above for the context of the finding. Identification as a Repeat Finding, If Applicable: Not applicable. Recommendation: We recommend that the City enhance its internal controls over payroll processes by implementing policies and procedures that ensure employee compensation charged to federal programs is supported by contemporaneous or after-the-fact documentation of actual time and effort spent on federal program activities. Additionally, all supporting documentation should be properly saved. Views of Responsible Officials: Management concurs with the finding.
2023-003 – Allowable Costs/Cost Principles – Internal Control over Payroll Expenditures Identification of the Federal Program: Assistance Listing Number: 14.231 Assistance Listing Title: Emergency Solutions Grant Program Federal Agency: U.S. Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Identification Number: E-20-MW-06-0026, E-21-MC-06-0026, E-22-MC-06-0026 Assistance Listing Number: 14.218 Assistance Listing Title: Community Development Block Grants-Entitlement Grants Cluster Federal Agency: U.S. Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Identification Number: B-20-MW-06-0026, B-21-MC-06-0026, B-22-MC-06-0026, B-23-MC-06-0026 Program Income Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): Total salaries charged to Federal awards (including extra service pay) are subject to the Standards of Documentation as described by 2 CFR §200.430(i). Per this section, salaries and wages charged to Federal awards must be based on records that accurately reflect the work performed. These records must: - Be incorporated into the organization’s official records; - Reasonably reflect the total activity for which the employee is compensating across all grant related and non-grant related activities (100% effort); - Support the distribution of employee salary across multiple activities or cost objectives (for example, effort spent on multiple federal awards, spent on general/or administrative activities, vacation, sick leave, leave without pay, etc.); and - Utilize an "after-the-fact" review of the employee’s actual hours worked during the reporting period for identifying and correcting significant changes (as defined by the organization’s written policies). Condition: Emergency Solutions Grant Program The City was unable to locate and provide the timesheets for (2) out of eleven (11) samples tested with Payroll Cost allocated to the Program. Within the overall population of a hundred and five (105) lines of ESG and ESGCV payroll charges, the City also had four (4) unsupported employee benefits charged to the program has benefit charged to program. Community Development Block Grants-Entitlement Grants Cluster Payroll costs for eighteen (18) out of forty (40) samples tested were allocated to programs were not supported by approved time samples or updated cost allocation methods/plan, nor were they reconciled to actual time spent on the various programs. Cause: The City did not adhere to its established policies and procedures for verifying that employee compensation charged to federal programs was supported by contemporaneous time records or an after-the-fact distribution of actual time and effort spent on federal program activities. Additionally, a thorough review and reconciliation of payroll time entries and postings from the old financial system (HTE) to the new financial system (MUNIS) was not conducted, resulting in the failure to preserve supporting documentation, such as timesheets, during the transition process. Effect or Potential Effect: The City did not comply with the program’s requirements for allowable costs. There is an increased risk that employees’ compensation charged to the program may not have represented an actual time and effort expended on the program’s activities. Questioned Costs: None. Context: See condition above for the context of the finding. Identification as a Repeat Finding, If Applicable: Not applicable. Recommendation: We recommend that the City enhance its internal controls over payroll processes by implementing policies and procedures that ensure employee compensation charged to federal programs is supported by contemporaneous or after-the-fact documentation of actual time and effort spent on federal program activities. Additionally, all supporting documentation should be properly saved. Views of Responsible Officials: Management concurs with the finding.
2023-003 – Allowable Costs/Cost Principles – Internal Control over Payroll Expenditures Identification of the Federal Program: Assistance Listing Number: 14.231 Assistance Listing Title: Emergency Solutions Grant Program Federal Agency: U.S. Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Identification Number: E-20-MW-06-0026, E-21-MC-06-0026, E-22-MC-06-0026 Assistance Listing Number: 14.218 Assistance Listing Title: Community Development Block Grants-Entitlement Grants Cluster Federal Agency: U.S. Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Identification Number: B-20-MW-06-0026, B-21-MC-06-0026, B-22-MC-06-0026, B-23-MC-06-0026 Program Income Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): Total salaries charged to Federal awards (including extra service pay) are subject to the Standards of Documentation as described by 2 CFR §200.430(i). Per this section, salaries and wages charged to Federal awards must be based on records that accurately reflect the work performed. These records must: - Be incorporated into the organization’s official records; - Reasonably reflect the total activity for which the employee is compensating across all grant related and non-grant related activities (100% effort); - Support the distribution of employee salary across multiple activities or cost objectives (for example, effort spent on multiple federal awards, spent on general/or administrative activities, vacation, sick leave, leave without pay, etc.); and - Utilize an "after-the-fact" review of the employee’s actual hours worked during the reporting period for identifying and correcting significant changes (as defined by the organization’s written policies). Condition: Emergency Solutions Grant Program The City was unable to locate and provide the timesheets for (2) out of eleven (11) samples tested with Payroll Cost allocated to the Program. Within the overall population of a hundred and five (105) lines of ESG and ESGCV payroll charges, the City also had four (4) unsupported employee benefits charged to the program has benefit charged to program. Community Development Block Grants-Entitlement Grants Cluster Payroll costs for eighteen (18) out of forty (40) samples tested were allocated to programs were not supported by approved time samples or updated cost allocation methods/plan, nor were they reconciled to actual time spent on the various programs. Cause: The City did not adhere to its established policies and procedures for verifying that employee compensation charged to federal programs was supported by contemporaneous time records or an after-the-fact distribution of actual time and effort spent on federal program activities. Additionally, a thorough review and reconciliation of payroll time entries and postings from the old financial system (HTE) to the new financial system (MUNIS) was not conducted, resulting in the failure to preserve supporting documentation, such as timesheets, during the transition process. Effect or Potential Effect: The City did not comply with the program’s requirements for allowable costs. There is an increased risk that employees’ compensation charged to the program may not have represented an actual time and effort expended on the program’s activities. Questioned Costs: None. Context: See condition above for the context of the finding. Identification as a Repeat Finding, If Applicable: Not applicable. Recommendation: We recommend that the City enhance its internal controls over payroll processes by implementing policies and procedures that ensure employee compensation charged to federal programs is supported by contemporaneous or after-the-fact documentation of actual time and effort spent on federal program activities. Additionally, all supporting documentation should be properly saved. Views of Responsible Officials: Management concurs with the finding.
2023-005 – Reporting – Internal Control and Compliance over Reporting Information of the Federal Program(s): Assistance Listing Number: 14.218 Assistance Listing Title: Community Development Block Grants-Entitlement Grants Cluster Federal Agency: U.S. Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Identification Number: B-20-MW-06-0026 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): The OMB Compliance Supplement requires that reports submitted to the Federal awarding agency include all activity of the reporting period, are supported by underlying accounting information and are presented in accordance with program requirements. Pursuant to Guidance on Section 15011 of the CARES Act requires that recipients of $150,000 or more of CARES Act funding submit, not later than 10 days after the end of each calendar quarter, a report containing: information regarding the amount of funds received; the amount of funds obligated or expended for each project or activity; a detailed list of all such projects or activities, including a description of the project or activity; and detailed information on any subcontracts or subgrants awarded by the recipient. This report is limited to Community Development Block Grants/Entitlement Grants Cluster - COVID-19 funding and does not include other Community Development Block Grants/Entitlement Grants Cluster funds that may be used to address coronavirus. Grantees and subrecipients have reported data meeting the Section 15011 requirements at usaspending.gov. The Pandemic Response Accountability Committee (PRAC), an independent oversight committee within the Council of the Inspectors General on Integrity and Efficiency, has determined that the data reported in usaspending.gov has fulfilled these reporting requests. (“Section 15011 Report”). Condition: As a result of our test work, we noted that the City did not submit any of the four (4) quarterly Section 15011 Reports for the year ended June 30, 2023. Cause: The City was not aware of the Section 15011 CARES reporting. Effect or Potential Effect: Delay in filing and not filing the reports resulted in noncompliance with the compliance requirements, which can result in errors going undetected by management. Questioned Costs: None. Context: See condition above for the context of the finding. Identification as a Repeat Finding, If Applicable: Not Applicable. Recommendation: We recommend that the City conduct thorough research on the reports needed to be submitted and contact the grantor if there is any confusion. When a report cannot be submitted by the due date, the City should request an extension from the funding agency and maintain a record of the approval. Views of Responsible Officials: Management concurs with the finding.
2023-003 – Allowable Costs/Cost Principles – Internal Control over Payroll Expenditures Identification of the Federal Program: Assistance Listing Number: 14.231 Assistance Listing Title: Emergency Solutions Grant Program Federal Agency: U.S. Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Identification Number: E-20-MW-06-0026, E-21-MC-06-0026, E-22-MC-06-0026 Assistance Listing Number: 14.218 Assistance Listing Title: Community Development Block Grants-Entitlement Grants Cluster Federal Agency: U.S. Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Identification Number: B-20-MW-06-0026, B-21-MC-06-0026, B-22-MC-06-0026, B-23-MC-06-0026 Program Income Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): Total salaries charged to Federal awards (including extra service pay) are subject to the Standards of Documentation as described by 2 CFR §200.430(i). Per this section, salaries and wages charged to Federal awards must be based on records that accurately reflect the work performed. These records must: - Be incorporated into the organization’s official records; - Reasonably reflect the total activity for which the employee is compensating across all grant related and non-grant related activities (100% effort); - Support the distribution of employee salary across multiple activities or cost objectives (for example, effort spent on multiple federal awards, spent on general/or administrative activities, vacation, sick leave, leave without pay, etc.); and - Utilize an "after-the-fact" review of the employee’s actual hours worked during the reporting period for identifying and correcting significant changes (as defined by the organization’s written policies). Condition: Emergency Solutions Grant Program The City was unable to locate and provide the timesheets for (2) out of eleven (11) samples tested with Payroll Cost allocated to the Program. Within the overall population of a hundred and five (105) lines of ESG and ESGCV payroll charges, the City also had four (4) unsupported employee benefits charged to the program has benefit charged to program. Community Development Block Grants-Entitlement Grants Cluster Payroll costs for eighteen (18) out of forty (40) samples tested were allocated to programs were not supported by approved time samples or updated cost allocation methods/plan, nor were they reconciled to actual time spent on the various programs. Cause: The City did not adhere to its established policies and procedures for verifying that employee compensation charged to federal programs was supported by contemporaneous time records or an after-the-fact distribution of actual time and effort spent on federal program activities. Additionally, a thorough review and reconciliation of payroll time entries and postings from the old financial system (HTE) to the new financial system (MUNIS) was not conducted, resulting in the failure to preserve supporting documentation, such as timesheets, during the transition process. Effect or Potential Effect: The City did not comply with the program’s requirements for allowable costs. There is an increased risk that employees’ compensation charged to the program may not have represented an actual time and effort expended on the program’s activities. Questioned Costs: None. Context: See condition above for the context of the finding. Identification as a Repeat Finding, If Applicable: Not applicable. Recommendation: We recommend that the City enhance its internal controls over payroll processes by implementing policies and procedures that ensure employee compensation charged to federal programs is supported by contemporaneous or after-the-fact documentation of actual time and effort spent on federal program activities. Additionally, all supporting documentation should be properly saved. Views of Responsible Officials: Management concurs with the finding.
2023-006 – Special Tests and Provisions – Internal Control and Compliance over Obligation, Expenditure, Payment Requirements Identification of the Federal Program: Assistance Listing Number: 14.231 Assistance Listing Title: Emergency Solutions Grant Program Federal Agency: U.S. Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Identification Number: E-20-MW-06-0026, E-21-MC-06-0026, E-22-MC-06-0026 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): Pursuant to May 2023 Compliance Supplement, Special Tests and Provisions – Obligation, Expenditures and Payment Requirements – Obligation-ESG. Funds allocated to metropolitan cities, urban counties, and territories. Within 180 days after the date that HUD signs the grant agreement (or a grant amendment for reallocation of funds) with a metropolitan city, urban county, or territory, the recipient must obligate all of the grant amount, except the amount for its administrative costs. ESG-CV funds must be obligated by the recipient in accordance with 24 CFR 576.203(a)(1) and (2), except as provided below. The applicable period for obligating ESG-CV funds begins on the date HUD signed the recipient’s grant agreement for the first allocation of ESG-CV funds. The obligation deadlines below apply to the both the first and second allocation of ESG-CV funds. HUD is also providing further flexibility for recipients (including states and non-states) to provide additional time to identify entities that have capacity and expertise to mitigate the impacts of coronavirus, including those who have not previously or recently received ESG funding. a. Recipients that are metropolitan cities, urban counties, or territories may have up to 240 days from the date HUD signs the grant agreement to obligate ESG-CV funds. Recipients must maintain in their program records a description of any changes the recipient implemented to identify and select new subrecipients. Payments to Subrecipients. The recipient must pay each subrecipient for allowable costs within 30 days after receiving the subrecipient’s complete payment request. This requirement also applies to each subrecipient that is a unit of general-purpose local government (24 CFR section 576.203). Condition: During our audit, we noted that the ESG Grant Fund obligated to sub-recipients under obligation testing were outside of the obligation timeframe of 180 days in case of ESG and 240 days in case of ESG CV without further justifications. In addition, we noted two (2) out of seven (7) samples selected for payment requirements testing were outside of 30 days window without further justifications. Cause: The City does not have formal policies and procedures in place to obligate the funds within the required timeframe nor complete the subrecipient’s payment request within 30 days. In addition, the City did not have procedures in place to timely request grantor extensions and/or document exceptions that are outside of uniform guidance. Effect or Potential Effect: The exceptions noted resulted in noncompliance. Questioned Costs: None. Context: See condition above for the context of the finding. Identification as a Repeat Finding, If Applicable: Yes. See prior year finding 2022-006. Recommendation: We recommended the City establish internal control procedures to monitor compliance requirements to ensure the subrecipient’s payment requests are processed timely. Views of Responsible Officials: Management concurs with the finding.
2023-003 – Allowable Costs/Cost Principles – Internal Control over Payroll Expenditures Identification of the Federal Program: Assistance Listing Number: 14.231 Assistance Listing Title: Emergency Solutions Grant Program Federal Agency: U.S. Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Identification Number: E-20-MW-06-0026, E-21-MC-06-0026, E-22-MC-06-0026 Assistance Listing Number: 14.218 Assistance Listing Title: Community Development Block Grants-Entitlement Grants Cluster Federal Agency: U.S. Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Identification Number: B-20-MW-06-0026, B-21-MC-06-0026, B-22-MC-06-0026, B-23-MC-06-0026 Program Income Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): Total salaries charged to Federal awards (including extra service pay) are subject to the Standards of Documentation as described by 2 CFR §200.430(i). Per this section, salaries and wages charged to Federal awards must be based on records that accurately reflect the work performed. These records must: - Be incorporated into the organization’s official records; - Reasonably reflect the total activity for which the employee is compensating across all grant related and non-grant related activities (100% effort); - Support the distribution of employee salary across multiple activities or cost objectives (for example, effort spent on multiple federal awards, spent on general/or administrative activities, vacation, sick leave, leave without pay, etc.); and - Utilize an "after-the-fact" review of the employee’s actual hours worked during the reporting period for identifying and correcting significant changes (as defined by the organization’s written policies). Condition: Emergency Solutions Grant Program The City was unable to locate and provide the timesheets for (2) out of eleven (11) samples tested with Payroll Cost allocated to the Program. Within the overall population of a hundred and five (105) lines of ESG and ESGCV payroll charges, the City also had four (4) unsupported employee benefits charged to the program has benefit charged to program. Community Development Block Grants-Entitlement Grants Cluster Payroll costs for eighteen (18) out of forty (40) samples tested were allocated to programs were not supported by approved time samples or updated cost allocation methods/plan, nor were they reconciled to actual time spent on the various programs. Cause: The City did not adhere to its established policies and procedures for verifying that employee compensation charged to federal programs was supported by contemporaneous time records or an after-the-fact distribution of actual time and effort spent on federal program activities. Additionally, a thorough review and reconciliation of payroll time entries and postings from the old financial system (HTE) to the new financial system (MUNIS) was not conducted, resulting in the failure to preserve supporting documentation, such as timesheets, during the transition process. Effect or Potential Effect: The City did not comply with the program’s requirements for allowable costs. There is an increased risk that employees’ compensation charged to the program may not have represented an actual time and effort expended on the program’s activities. Questioned Costs: None. Context: See condition above for the context of the finding. Identification as a Repeat Finding, If Applicable: Not applicable. Recommendation: We recommend that the City enhance its internal controls over payroll processes by implementing policies and procedures that ensure employee compensation charged to federal programs is supported by contemporaneous or after-the-fact documentation of actual time and effort spent on federal program activities. Additionally, all supporting documentation should be properly saved. Views of Responsible Officials: Management concurs with the finding.
2023-006 – Special Tests and Provisions – Internal Control and Compliance over Obligation, Expenditure, Payment Requirements Identification of the Federal Program: Assistance Listing Number: 14.231 Assistance Listing Title: Emergency Solutions Grant Program Federal Agency: U.S. Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Identification Number: E-20-MW-06-0026, E-21-MC-06-0026, E-22-MC-06-0026 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): Pursuant to May 2023 Compliance Supplement, Special Tests and Provisions – Obligation, Expenditures and Payment Requirements – Obligation-ESG. Funds allocated to metropolitan cities, urban counties, and territories. Within 180 days after the date that HUD signs the grant agreement (or a grant amendment for reallocation of funds) with a metropolitan city, urban county, or territory, the recipient must obligate all of the grant amount, except the amount for its administrative costs. ESG-CV funds must be obligated by the recipient in accordance with 24 CFR 576.203(a)(1) and (2), except as provided below. The applicable period for obligating ESG-CV funds begins on the date HUD signed the recipient’s grant agreement for the first allocation of ESG-CV funds. The obligation deadlines below apply to the both the first and second allocation of ESG-CV funds. HUD is also providing further flexibility for recipients (including states and non-states) to provide additional time to identify entities that have capacity and expertise to mitigate the impacts of coronavirus, including those who have not previously or recently received ESG funding. a. Recipients that are metropolitan cities, urban counties, or territories may have up to 240 days from the date HUD signs the grant agreement to obligate ESG-CV funds. Recipients must maintain in their program records a description of any changes the recipient implemented to identify and select new subrecipients. Payments to Subrecipients. The recipient must pay each subrecipient for allowable costs within 30 days after receiving the subrecipient’s complete payment request. This requirement also applies to each subrecipient that is a unit of general-purpose local government (24 CFR section 576.203). Condition: During our audit, we noted that the ESG Grant Fund obligated to sub-recipients under obligation testing were outside of the obligation timeframe of 180 days in case of ESG and 240 days in case of ESG CV without further justifications. In addition, we noted two (2) out of seven (7) samples selected for payment requirements testing were outside of 30 days window without further justifications. Cause: The City does not have formal policies and procedures in place to obligate the funds within the required timeframe nor complete the subrecipient’s payment request within 30 days. In addition, the City did not have procedures in place to timely request grantor extensions and/or document exceptions that are outside of uniform guidance. Effect or Potential Effect: The exceptions noted resulted in noncompliance. Questioned Costs: None. Context: See condition above for the context of the finding. Identification as a Repeat Finding, If Applicable: Yes. See prior year finding 2022-006. Recommendation: We recommended the City establish internal control procedures to monitor compliance requirements to ensure the subrecipient’s payment requests are processed timely. Views of Responsible Officials: Management concurs with the finding.
2023-003 – Allowable Costs/Cost Principles – Internal Control over Payroll Expenditures Identification of the Federal Program: Assistance Listing Number: 14.231 Assistance Listing Title: Emergency Solutions Grant Program Federal Agency: U.S. Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Identification Number: E-20-MW-06-0026, E-21-MC-06-0026, E-22-MC-06-0026 Assistance Listing Number: 14.218 Assistance Listing Title: Community Development Block Grants-Entitlement Grants Cluster Federal Agency: U.S. Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Identification Number: B-20-MW-06-0026, B-21-MC-06-0026, B-22-MC-06-0026, B-23-MC-06-0026 Program Income Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): Total salaries charged to Federal awards (including extra service pay) are subject to the Standards of Documentation as described by 2 CFR §200.430(i). Per this section, salaries and wages charged to Federal awards must be based on records that accurately reflect the work performed. These records must: - Be incorporated into the organization’s official records; - Reasonably reflect the total activity for which the employee is compensating across all grant related and non-grant related activities (100% effort); - Support the distribution of employee salary across multiple activities or cost objectives (for example, effort spent on multiple federal awards, spent on general/or administrative activities, vacation, sick leave, leave without pay, etc.); and - Utilize an "after-the-fact" review of the employee’s actual hours worked during the reporting period for identifying and correcting significant changes (as defined by the organization’s written policies). Condition: Emergency Solutions Grant Program The City was unable to locate and provide the timesheets for (2) out of eleven (11) samples tested with Payroll Cost allocated to the Program. Within the overall population of a hundred and five (105) lines of ESG and ESGCV payroll charges, the City also had four (4) unsupported employee benefits charged to the program has benefit charged to program. Community Development Block Grants-Entitlement Grants Cluster Payroll costs for eighteen (18) out of forty (40) samples tested were allocated to programs were not supported by approved time samples or updated cost allocation methods/plan, nor were they reconciled to actual time spent on the various programs. Cause: The City did not adhere to its established policies and procedures for verifying that employee compensation charged to federal programs was supported by contemporaneous time records or an after-the-fact distribution of actual time and effort spent on federal program activities. Additionally, a thorough review and reconciliation of payroll time entries and postings from the old financial system (HTE) to the new financial system (MUNIS) was not conducted, resulting in the failure to preserve supporting documentation, such as timesheets, during the transition process. Effect or Potential Effect: The City did not comply with the program’s requirements for allowable costs. There is an increased risk that employees’ compensation charged to the program may not have represented an actual time and effort expended on the program’s activities. Questioned Costs: None. Context: See condition above for the context of the finding. Identification as a Repeat Finding, If Applicable: Not applicable. Recommendation: We recommend that the City enhance its internal controls over payroll processes by implementing policies and procedures that ensure employee compensation charged to federal programs is supported by contemporaneous or after-the-fact documentation of actual time and effort spent on federal program activities. Additionally, all supporting documentation should be properly saved. Views of Responsible Officials: Management concurs with the finding.
2023-006 – Special Tests and Provisions – Internal Control and Compliance over Obligation, Expenditure, Payment Requirements Identification of the Federal Program: Assistance Listing Number: 14.231 Assistance Listing Title: Emergency Solutions Grant Program Federal Agency: U.S. Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Identification Number: E-20-MW-06-0026, E-21-MC-06-0026, E-22-MC-06-0026 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): Pursuant to May 2023 Compliance Supplement, Special Tests and Provisions – Obligation, Expenditures and Payment Requirements – Obligation-ESG. Funds allocated to metropolitan cities, urban counties, and territories. Within 180 days after the date that HUD signs the grant agreement (or a grant amendment for reallocation of funds) with a metropolitan city, urban county, or territory, the recipient must obligate all of the grant amount, except the amount for its administrative costs. ESG-CV funds must be obligated by the recipient in accordance with 24 CFR 576.203(a)(1) and (2), except as provided below. The applicable period for obligating ESG-CV funds begins on the date HUD signed the recipient’s grant agreement for the first allocation of ESG-CV funds. The obligation deadlines below apply to the both the first and second allocation of ESG-CV funds. HUD is also providing further flexibility for recipients (including states and non-states) to provide additional time to identify entities that have capacity and expertise to mitigate the impacts of coronavirus, including those who have not previously or recently received ESG funding. a. Recipients that are metropolitan cities, urban counties, or territories may have up to 240 days from the date HUD signs the grant agreement to obligate ESG-CV funds. Recipients must maintain in their program records a description of any changes the recipient implemented to identify and select new subrecipients. Payments to Subrecipients. The recipient must pay each subrecipient for allowable costs within 30 days after receiving the subrecipient’s complete payment request. This requirement also applies to each subrecipient that is a unit of general-purpose local government (24 CFR section 576.203). Condition: During our audit, we noted that the ESG Grant Fund obligated to sub-recipients under obligation testing were outside of the obligation timeframe of 180 days in case of ESG and 240 days in case of ESG CV without further justifications. In addition, we noted two (2) out of seven (7) samples selected for payment requirements testing were outside of 30 days window without further justifications. Cause: The City does not have formal policies and procedures in place to obligate the funds within the required timeframe nor complete the subrecipient’s payment request within 30 days. In addition, the City did not have procedures in place to timely request grantor extensions and/or document exceptions that are outside of uniform guidance. Effect or Potential Effect: The exceptions noted resulted in noncompliance. Questioned Costs: None. Context: See condition above for the context of the finding. Identification as a Repeat Finding, If Applicable: Yes. See prior year finding 2022-006. Recommendation: We recommended the City establish internal control procedures to monitor compliance requirements to ensure the subrecipient’s payment requests are processed timely. Views of Responsible Officials: Management concurs with the finding.
2023-004 – Eligibility – Internal Control Over Eligibility Identification of the Federal Program: Assistance Listing Number: 21.023 Assistance Listing Title: Emergency Rental Assistance Program Federal Agency: Department of Treasury Pass-Through Entity: State of California Department of Finance Federal Award Identification Number: N/A Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): Pursuant to the May 2023 Compliance Supplement, Eligibility: This approach to eligibility was implemented in accordance with 15 USC 9058a, for ERA 1 in 15 USC 9058a(c)(2)(C)(ii) concerning documentation of payments to households, 15 USC 9058a(f)(2)(A) and (B) of the Act concerning signature requirements for applications and documentation required for tenants, 15 USC 9058a (k)(1) concerning area median income determinations, and 15 USC 9058a (k)(3)(A)(I) and (II) concerning eligible household determinations and attestation requirements. This treatment is further explained in the ERA FAQs; 15 USC 9058a; and the Treasury, Department of Justice and Department of Housing and Urban Development joint letter issued August 27, 2021 (https://home.treasury.gov/system/files/136/Eviction- Moratorium-Joint-Letter.pdf). To the extent that a grantee has established and consistently followed its own reasonable procedures for implementing an eligibility determination process, consistent with Treasury’s guidance, it is not Treasury’s expectation that grantees should seek additional documentation from a beneficiary after the initial determination of eligibility has been completed, including for those determined to be eligible using self-attestation, categorical eligibility, or fact-specific proxies in qualifying circumstances. Testing of individual household eligibility-related documentation should be limited to material already collected by the grantee during application as much as possible to avoid imposing undue burden on households that remain at risk of housing instability. Condition: During our audit, we noted five (5) samples out of nine (9) samples selected for the eligibility requirement testing with internal control deficiency related to the income eligibility verification. The city failed to collect the zero income attestation document from applicant. The amount of income shown in documents uploaded by applicant was different from the amount shown in application/system, check box for income verification was not ticked off by supervisor though the verification was completed. However, we recalculated those five applicants’ income based on the income verification support provided and those applicants were eligible to receive the grant subsidy based on the income limit. Cause: The City did not have proper internal controls in place to review the process performed. Effect or Potential Effect: The City could potentially be out of compliance with the eligibility requirement due to the error in executing the internal control procedures. Questioned Costs: None. Context: See condition above for the context of the finding. Identification as a Repeat Finding, If Applicable: Yes. See prior year finding 2022-003. Recommendation: We recommend the City enhance its internal control by implementing policies and procedures over eligibility requirement. Views of Responsible Officials: Management concurs with the finding.
2023-004 – Eligibility – Internal Control Over Eligibility Identification of the Federal Program: Assistance Listing Number: 21.023 Assistance Listing Title: Emergency Rental Assistance Program Federal Agency: Department of Treasury Pass-Through Entity: State of California Department of Finance Federal Award Identification Number: N/A Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): Pursuant to the May 2023 Compliance Supplement, Eligibility: This approach to eligibility was implemented in accordance with 15 USC 9058a, for ERA 1 in 15 USC 9058a(c)(2)(C)(ii) concerning documentation of payments to households, 15 USC 9058a(f)(2)(A) and (B) of the Act concerning signature requirements for applications and documentation required for tenants, 15 USC 9058a (k)(1) concerning area median income determinations, and 15 USC 9058a (k)(3)(A)(I) and (II) concerning eligible household determinations and attestation requirements. This treatment is further explained in the ERA FAQs; 15 USC 9058a; and the Treasury, Department of Justice and Department of Housing and Urban Development joint letter issued August 27, 2021 (https://home.treasury.gov/system/files/136/Eviction- Moratorium-Joint-Letter.pdf). To the extent that a grantee has established and consistently followed its own reasonable procedures for implementing an eligibility determination process, consistent with Treasury’s guidance, it is not Treasury’s expectation that grantees should seek additional documentation from a beneficiary after the initial determination of eligibility has been completed, including for those determined to be eligible using self-attestation, categorical eligibility, or fact-specific proxies in qualifying circumstances. Testing of individual household eligibility-related documentation should be limited to material already collected by the grantee during application as much as possible to avoid imposing undue burden on households that remain at risk of housing instability. Condition: During our audit, we noted five (5) samples out of nine (9) samples selected for the eligibility requirement testing with internal control deficiency related to the income eligibility verification. The city failed to collect the zero income attestation document from applicant. The amount of income shown in documents uploaded by applicant was different from the amount shown in application/system, check box for income verification was not ticked off by supervisor though the verification was completed. However, we recalculated those five applicants’ income based on the income verification support provided and those applicants were eligible to receive the grant subsidy based on the income limit. Cause: The City did not have proper internal controls in place to review the process performed. Effect or Potential Effect: The City could potentially be out of compliance with the eligibility requirement due to the error in executing the internal control procedures. Questioned Costs: None. Context: See condition above for the context of the finding. Identification as a Repeat Finding, If Applicable: Yes. See prior year finding 2022-003. Recommendation: We recommend the City enhance its internal control by implementing policies and procedures over eligibility requirement. Views of Responsible Officials: Management concurs with the finding.
2023-004 – Eligibility – Internal Control Over Eligibility Identification of the Federal Program: Assistance Listing Number: 21.023 Assistance Listing Title: Emergency Rental Assistance Program Federal Agency: Department of Treasury Pass-Through Entity: State of California Department of Finance Federal Award Identification Number: N/A Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): Pursuant to the May 2023 Compliance Supplement, Eligibility: This approach to eligibility was implemented in accordance with 15 USC 9058a, for ERA 1 in 15 USC 9058a(c)(2)(C)(ii) concerning documentation of payments to households, 15 USC 9058a(f)(2)(A) and (B) of the Act concerning signature requirements for applications and documentation required for tenants, 15 USC 9058a (k)(1) concerning area median income determinations, and 15 USC 9058a (k)(3)(A)(I) and (II) concerning eligible household determinations and attestation requirements. This treatment is further explained in the ERA FAQs; 15 USC 9058a; and the Treasury, Department of Justice and Department of Housing and Urban Development joint letter issued August 27, 2021 (https://home.treasury.gov/system/files/136/Eviction- Moratorium-Joint-Letter.pdf). To the extent that a grantee has established and consistently followed its own reasonable procedures for implementing an eligibility determination process, consistent with Treasury’s guidance, it is not Treasury’s expectation that grantees should seek additional documentation from a beneficiary after the initial determination of eligibility has been completed, including for those determined to be eligible using self-attestation, categorical eligibility, or fact-specific proxies in qualifying circumstances. Testing of individual household eligibility-related documentation should be limited to material already collected by the grantee during application as much as possible to avoid imposing undue burden on households that remain at risk of housing instability. Condition: During our audit, we noted five (5) samples out of nine (9) samples selected for the eligibility requirement testing with internal control deficiency related to the income eligibility verification. The city failed to collect the zero income attestation document from applicant. The amount of income shown in documents uploaded by applicant was different from the amount shown in application/system, check box for income verification was not ticked off by supervisor though the verification was completed. However, we recalculated those five applicants’ income based on the income verification support provided and those applicants were eligible to receive the grant subsidy based on the income limit. Cause: The City did not have proper internal controls in place to review the process performed. Effect or Potential Effect: The City could potentially be out of compliance with the eligibility requirement due to the error in executing the internal control procedures. Questioned Costs: None. Context: See condition above for the context of the finding. Identification as a Repeat Finding, If Applicable: Yes. See prior year finding 2022-003. Recommendation: We recommend the City enhance its internal control by implementing policies and procedures over eligibility requirement. Views of Responsible Officials: Management concurs with the finding.
2023-003 – Allowable Costs/Cost Principles – Internal Control over Payroll Expenditures Identification of the Federal Program: Assistance Listing Number: 14.231 Assistance Listing Title: Emergency Solutions Grant Program Federal Agency: U.S. Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Identification Number: E-20-MW-06-0026, E-21-MC-06-0026, E-22-MC-06-0026 Assistance Listing Number: 14.218 Assistance Listing Title: Community Development Block Grants-Entitlement Grants Cluster Federal Agency: U.S. Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Identification Number: B-20-MW-06-0026, B-21-MC-06-0026, B-22-MC-06-0026, B-23-MC-06-0026 Program Income Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): Total salaries charged to Federal awards (including extra service pay) are subject to the Standards of Documentation as described by 2 CFR §200.430(i). Per this section, salaries and wages charged to Federal awards must be based on records that accurately reflect the work performed. These records must: - Be incorporated into the organization’s official records; - Reasonably reflect the total activity for which the employee is compensating across all grant related and non-grant related activities (100% effort); - Support the distribution of employee salary across multiple activities or cost objectives (for example, effort spent on multiple federal awards, spent on general/or administrative activities, vacation, sick leave, leave without pay, etc.); and - Utilize an "after-the-fact" review of the employee’s actual hours worked during the reporting period for identifying and correcting significant changes (as defined by the organization’s written policies). Condition: Emergency Solutions Grant Program The City was unable to locate and provide the timesheets for (2) out of eleven (11) samples tested with Payroll Cost allocated to the Program. Within the overall population of a hundred and five (105) lines of ESG and ESGCV payroll charges, the City also had four (4) unsupported employee benefits charged to the program has benefit charged to program. Community Development Block Grants-Entitlement Grants Cluster Payroll costs for eighteen (18) out of forty (40) samples tested were allocated to programs were not supported by approved time samples or updated cost allocation methods/plan, nor were they reconciled to actual time spent on the various programs. Cause: The City did not adhere to its established policies and procedures for verifying that employee compensation charged to federal programs was supported by contemporaneous time records or an after-the-fact distribution of actual time and effort spent on federal program activities. Additionally, a thorough review and reconciliation of payroll time entries and postings from the old financial system (HTE) to the new financial system (MUNIS) was not conducted, resulting in the failure to preserve supporting documentation, such as timesheets, during the transition process. Effect or Potential Effect: The City did not comply with the program’s requirements for allowable costs. There is an increased risk that employees’ compensation charged to the program may not have represented an actual time and effort expended on the program’s activities. Questioned Costs: None. Context: See condition above for the context of the finding. Identification as a Repeat Finding, If Applicable: Not applicable. Recommendation: We recommend that the City enhance its internal controls over payroll processes by implementing policies and procedures that ensure employee compensation charged to federal programs is supported by contemporaneous or after-the-fact documentation of actual time and effort spent on federal program activities. Additionally, all supporting documentation should be properly saved. Views of Responsible Officials: Management concurs with the finding.
2023-003 – Allowable Costs/Cost Principles – Internal Control over Payroll Expenditures Identification of the Federal Program: Assistance Listing Number: 14.231 Assistance Listing Title: Emergency Solutions Grant Program Federal Agency: U.S. Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Identification Number: E-20-MW-06-0026, E-21-MC-06-0026, E-22-MC-06-0026 Assistance Listing Number: 14.218 Assistance Listing Title: Community Development Block Grants-Entitlement Grants Cluster Federal Agency: U.S. Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Identification Number: B-20-MW-06-0026, B-21-MC-06-0026, B-22-MC-06-0026, B-23-MC-06-0026 Program Income Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): Total salaries charged to Federal awards (including extra service pay) are subject to the Standards of Documentation as described by 2 CFR §200.430(i). Per this section, salaries and wages charged to Federal awards must be based on records that accurately reflect the work performed. These records must: - Be incorporated into the organization’s official records; - Reasonably reflect the total activity for which the employee is compensating across all grant related and non-grant related activities (100% effort); - Support the distribution of employee salary across multiple activities or cost objectives (for example, effort spent on multiple federal awards, spent on general/or administrative activities, vacation, sick leave, leave without pay, etc.); and - Utilize an "after-the-fact" review of the employee’s actual hours worked during the reporting period for identifying and correcting significant changes (as defined by the organization’s written policies). Condition: Emergency Solutions Grant Program The City was unable to locate and provide the timesheets for (2) out of eleven (11) samples tested with Payroll Cost allocated to the Program. Within the overall population of a hundred and five (105) lines of ESG and ESGCV payroll charges, the City also had four (4) unsupported employee benefits charged to the program has benefit charged to program. Community Development Block Grants-Entitlement Grants Cluster Payroll costs for eighteen (18) out of forty (40) samples tested were allocated to programs were not supported by approved time samples or updated cost allocation methods/plan, nor were they reconciled to actual time spent on the various programs. Cause: The City did not adhere to its established policies and procedures for verifying that employee compensation charged to federal programs was supported by contemporaneous time records or an after-the-fact distribution of actual time and effort spent on federal program activities. Additionally, a thorough review and reconciliation of payroll time entries and postings from the old financial system (HTE) to the new financial system (MUNIS) was not conducted, resulting in the failure to preserve supporting documentation, such as timesheets, during the transition process. Effect or Potential Effect: The City did not comply with the program’s requirements for allowable costs. There is an increased risk that employees’ compensation charged to the program may not have represented an actual time and effort expended on the program’s activities. Questioned Costs: None. Context: See condition above for the context of the finding. Identification as a Repeat Finding, If Applicable: Not applicable. Recommendation: We recommend that the City enhance its internal controls over payroll processes by implementing policies and procedures that ensure employee compensation charged to federal programs is supported by contemporaneous or after-the-fact documentation of actual time and effort spent on federal program activities. Additionally, all supporting documentation should be properly saved. Views of Responsible Officials: Management concurs with the finding.
2023-003 – Allowable Costs/Cost Principles – Internal Control over Payroll Expenditures Identification of the Federal Program: Assistance Listing Number: 14.231 Assistance Listing Title: Emergency Solutions Grant Program Federal Agency: U.S. Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Identification Number: E-20-MW-06-0026, E-21-MC-06-0026, E-22-MC-06-0026 Assistance Listing Number: 14.218 Assistance Listing Title: Community Development Block Grants-Entitlement Grants Cluster Federal Agency: U.S. Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Identification Number: B-20-MW-06-0026, B-21-MC-06-0026, B-22-MC-06-0026, B-23-MC-06-0026 Program Income Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): Total salaries charged to Federal awards (including extra service pay) are subject to the Standards of Documentation as described by 2 CFR §200.430(i). Per this section, salaries and wages charged to Federal awards must be based on records that accurately reflect the work performed. These records must: - Be incorporated into the organization’s official records; - Reasonably reflect the total activity for which the employee is compensating across all grant related and non-grant related activities (100% effort); - Support the distribution of employee salary across multiple activities or cost objectives (for example, effort spent on multiple federal awards, spent on general/or administrative activities, vacation, sick leave, leave without pay, etc.); and - Utilize an "after-the-fact" review of the employee’s actual hours worked during the reporting period for identifying and correcting significant changes (as defined by the organization’s written policies). Condition: Emergency Solutions Grant Program The City was unable to locate and provide the timesheets for (2) out of eleven (11) samples tested with Payroll Cost allocated to the Program. Within the overall population of a hundred and five (105) lines of ESG and ESGCV payroll charges, the City also had four (4) unsupported employee benefits charged to the program has benefit charged to program. Community Development Block Grants-Entitlement Grants Cluster Payroll costs for eighteen (18) out of forty (40) samples tested were allocated to programs were not supported by approved time samples or updated cost allocation methods/plan, nor were they reconciled to actual time spent on the various programs. Cause: The City did not adhere to its established policies and procedures for verifying that employee compensation charged to federal programs was supported by contemporaneous time records or an after-the-fact distribution of actual time and effort spent on federal program activities. Additionally, a thorough review and reconciliation of payroll time entries and postings from the old financial system (HTE) to the new financial system (MUNIS) was not conducted, resulting in the failure to preserve supporting documentation, such as timesheets, during the transition process. Effect or Potential Effect: The City did not comply with the program’s requirements for allowable costs. There is an increased risk that employees’ compensation charged to the program may not have represented an actual time and effort expended on the program’s activities. Questioned Costs: None. Context: See condition above for the context of the finding. Identification as a Repeat Finding, If Applicable: Not applicable. Recommendation: We recommend that the City enhance its internal controls over payroll processes by implementing policies and procedures that ensure employee compensation charged to federal programs is supported by contemporaneous or after-the-fact documentation of actual time and effort spent on federal program activities. Additionally, all supporting documentation should be properly saved. Views of Responsible Officials: Management concurs with the finding.
2023-003 – Allowable Costs/Cost Principles – Internal Control over Payroll Expenditures Identification of the Federal Program: Assistance Listing Number: 14.231 Assistance Listing Title: Emergency Solutions Grant Program Federal Agency: U.S. Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Identification Number: E-20-MW-06-0026, E-21-MC-06-0026, E-22-MC-06-0026 Assistance Listing Number: 14.218 Assistance Listing Title: Community Development Block Grants-Entitlement Grants Cluster Federal Agency: U.S. Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Identification Number: B-20-MW-06-0026, B-21-MC-06-0026, B-22-MC-06-0026, B-23-MC-06-0026 Program Income Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): Total salaries charged to Federal awards (including extra service pay) are subject to the Standards of Documentation as described by 2 CFR §200.430(i). Per this section, salaries and wages charged to Federal awards must be based on records that accurately reflect the work performed. These records must: - Be incorporated into the organization’s official records; - Reasonably reflect the total activity for which the employee is compensating across all grant related and non-grant related activities (100% effort); - Support the distribution of employee salary across multiple activities or cost objectives (for example, effort spent on multiple federal awards, spent on general/or administrative activities, vacation, sick leave, leave without pay, etc.); and - Utilize an "after-the-fact" review of the employee’s actual hours worked during the reporting period for identifying and correcting significant changes (as defined by the organization’s written policies). Condition: Emergency Solutions Grant Program The City was unable to locate and provide the timesheets for (2) out of eleven (11) samples tested with Payroll Cost allocated to the Program. Within the overall population of a hundred and five (105) lines of ESG and ESGCV payroll charges, the City also had four (4) unsupported employee benefits charged to the program has benefit charged to program. Community Development Block Grants-Entitlement Grants Cluster Payroll costs for eighteen (18) out of forty (40) samples tested were allocated to programs were not supported by approved time samples or updated cost allocation methods/plan, nor were they reconciled to actual time spent on the various programs. Cause: The City did not adhere to its established policies and procedures for verifying that employee compensation charged to federal programs was supported by contemporaneous time records or an after-the-fact distribution of actual time and effort spent on federal program activities. Additionally, a thorough review and reconciliation of payroll time entries and postings from the old financial system (HTE) to the new financial system (MUNIS) was not conducted, resulting in the failure to preserve supporting documentation, such as timesheets, during the transition process. Effect or Potential Effect: The City did not comply with the program’s requirements for allowable costs. There is an increased risk that employees’ compensation charged to the program may not have represented an actual time and effort expended on the program’s activities. Questioned Costs: None. Context: See condition above for the context of the finding. Identification as a Repeat Finding, If Applicable: Not applicable. Recommendation: We recommend that the City enhance its internal controls over payroll processes by implementing policies and procedures that ensure employee compensation charged to federal programs is supported by contemporaneous or after-the-fact documentation of actual time and effort spent on federal program activities. Additionally, all supporting documentation should be properly saved. Views of Responsible Officials: Management concurs with the finding.
2023-005 – Reporting – Internal Control and Compliance over Reporting Information of the Federal Program(s): Assistance Listing Number: 14.218 Assistance Listing Title: Community Development Block Grants-Entitlement Grants Cluster Federal Agency: U.S. Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Identification Number: B-20-MW-06-0026 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): The OMB Compliance Supplement requires that reports submitted to the Federal awarding agency include all activity of the reporting period, are supported by underlying accounting information and are presented in accordance with program requirements. Pursuant to Guidance on Section 15011 of the CARES Act requires that recipients of $150,000 or more of CARES Act funding submit, not later than 10 days after the end of each calendar quarter, a report containing: information regarding the amount of funds received; the amount of funds obligated or expended for each project or activity; a detailed list of all such projects or activities, including a description of the project or activity; and detailed information on any subcontracts or subgrants awarded by the recipient. This report is limited to Community Development Block Grants/Entitlement Grants Cluster - COVID-19 funding and does not include other Community Development Block Grants/Entitlement Grants Cluster funds that may be used to address coronavirus. Grantees and subrecipients have reported data meeting the Section 15011 requirements at usaspending.gov. The Pandemic Response Accountability Committee (PRAC), an independent oversight committee within the Council of the Inspectors General on Integrity and Efficiency, has determined that the data reported in usaspending.gov has fulfilled these reporting requests. (“Section 15011 Report”). Condition: As a result of our test work, we noted that the City did not submit any of the four (4) quarterly Section 15011 Reports for the year ended June 30, 2023. Cause: The City was not aware of the Section 15011 CARES reporting. Effect or Potential Effect: Delay in filing and not filing the reports resulted in noncompliance with the compliance requirements, which can result in errors going undetected by management. Questioned Costs: None. Context: See condition above for the context of the finding. Identification as a Repeat Finding, If Applicable: Not Applicable. Recommendation: We recommend that the City conduct thorough research on the reports needed to be submitted and contact the grantor if there is any confusion. When a report cannot be submitted by the due date, the City should request an extension from the funding agency and maintain a record of the approval. Views of Responsible Officials: Management concurs with the finding.
2023-003 – Allowable Costs/Cost Principles – Internal Control over Payroll Expenditures Identification of the Federal Program: Assistance Listing Number: 14.231 Assistance Listing Title: Emergency Solutions Grant Program Federal Agency: U.S. Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Identification Number: E-20-MW-06-0026, E-21-MC-06-0026, E-22-MC-06-0026 Assistance Listing Number: 14.218 Assistance Listing Title: Community Development Block Grants-Entitlement Grants Cluster Federal Agency: U.S. Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Identification Number: B-20-MW-06-0026, B-21-MC-06-0026, B-22-MC-06-0026, B-23-MC-06-0026 Program Income Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): Total salaries charged to Federal awards (including extra service pay) are subject to the Standards of Documentation as described by 2 CFR §200.430(i). Per this section, salaries and wages charged to Federal awards must be based on records that accurately reflect the work performed. These records must: - Be incorporated into the organization’s official records; - Reasonably reflect the total activity for which the employee is compensating across all grant related and non-grant related activities (100% effort); - Support the distribution of employee salary across multiple activities or cost objectives (for example, effort spent on multiple federal awards, spent on general/or administrative activities, vacation, sick leave, leave without pay, etc.); and - Utilize an "after-the-fact" review of the employee’s actual hours worked during the reporting period for identifying and correcting significant changes (as defined by the organization’s written policies). Condition: Emergency Solutions Grant Program The City was unable to locate and provide the timesheets for (2) out of eleven (11) samples tested with Payroll Cost allocated to the Program. Within the overall population of a hundred and five (105) lines of ESG and ESGCV payroll charges, the City also had four (4) unsupported employee benefits charged to the program has benefit charged to program. Community Development Block Grants-Entitlement Grants Cluster Payroll costs for eighteen (18) out of forty (40) samples tested were allocated to programs were not supported by approved time samples or updated cost allocation methods/plan, nor were they reconciled to actual time spent on the various programs. Cause: The City did not adhere to its established policies and procedures for verifying that employee compensation charged to federal programs was supported by contemporaneous time records or an after-the-fact distribution of actual time and effort spent on federal program activities. Additionally, a thorough review and reconciliation of payroll time entries and postings from the old financial system (HTE) to the new financial system (MUNIS) was not conducted, resulting in the failure to preserve supporting documentation, such as timesheets, during the transition process. Effect or Potential Effect: The City did not comply with the program’s requirements for allowable costs. There is an increased risk that employees’ compensation charged to the program may not have represented an actual time and effort expended on the program’s activities. Questioned Costs: None. Context: See condition above for the context of the finding. Identification as a Repeat Finding, If Applicable: Not applicable. Recommendation: We recommend that the City enhance its internal controls over payroll processes by implementing policies and procedures that ensure employee compensation charged to federal programs is supported by contemporaneous or after-the-fact documentation of actual time and effort spent on federal program activities. Additionally, all supporting documentation should be properly saved. Views of Responsible Officials: Management concurs with the finding.
2023-006 – Special Tests and Provisions – Internal Control and Compliance over Obligation, Expenditure, Payment Requirements Identification of the Federal Program: Assistance Listing Number: 14.231 Assistance Listing Title: Emergency Solutions Grant Program Federal Agency: U.S. Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Identification Number: E-20-MW-06-0026, E-21-MC-06-0026, E-22-MC-06-0026 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): Pursuant to May 2023 Compliance Supplement, Special Tests and Provisions – Obligation, Expenditures and Payment Requirements – Obligation-ESG. Funds allocated to metropolitan cities, urban counties, and territories. Within 180 days after the date that HUD signs the grant agreement (or a grant amendment for reallocation of funds) with a metropolitan city, urban county, or territory, the recipient must obligate all of the grant amount, except the amount for its administrative costs. ESG-CV funds must be obligated by the recipient in accordance with 24 CFR 576.203(a)(1) and (2), except as provided below. The applicable period for obligating ESG-CV funds begins on the date HUD signed the recipient’s grant agreement for the first allocation of ESG-CV funds. The obligation deadlines below apply to the both the first and second allocation of ESG-CV funds. HUD is also providing further flexibility for recipients (including states and non-states) to provide additional time to identify entities that have capacity and expertise to mitigate the impacts of coronavirus, including those who have not previously or recently received ESG funding. a. Recipients that are metropolitan cities, urban counties, or territories may have up to 240 days from the date HUD signs the grant agreement to obligate ESG-CV funds. Recipients must maintain in their program records a description of any changes the recipient implemented to identify and select new subrecipients. Payments to Subrecipients. The recipient must pay each subrecipient for allowable costs within 30 days after receiving the subrecipient’s complete payment request. This requirement also applies to each subrecipient that is a unit of general-purpose local government (24 CFR section 576.203). Condition: During our audit, we noted that the ESG Grant Fund obligated to sub-recipients under obligation testing were outside of the obligation timeframe of 180 days in case of ESG and 240 days in case of ESG CV without further justifications. In addition, we noted two (2) out of seven (7) samples selected for payment requirements testing were outside of 30 days window without further justifications. Cause: The City does not have formal policies and procedures in place to obligate the funds within the required timeframe nor complete the subrecipient’s payment request within 30 days. In addition, the City did not have procedures in place to timely request grantor extensions and/or document exceptions that are outside of uniform guidance. Effect or Potential Effect: The exceptions noted resulted in noncompliance. Questioned Costs: None. Context: See condition above for the context of the finding. Identification as a Repeat Finding, If Applicable: Yes. See prior year finding 2022-006. Recommendation: We recommended the City establish internal control procedures to monitor compliance requirements to ensure the subrecipient’s payment requests are processed timely. Views of Responsible Officials: Management concurs with the finding.
2023-003 – Allowable Costs/Cost Principles – Internal Control over Payroll Expenditures Identification of the Federal Program: Assistance Listing Number: 14.231 Assistance Listing Title: Emergency Solutions Grant Program Federal Agency: U.S. Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Identification Number: E-20-MW-06-0026, E-21-MC-06-0026, E-22-MC-06-0026 Assistance Listing Number: 14.218 Assistance Listing Title: Community Development Block Grants-Entitlement Grants Cluster Federal Agency: U.S. Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Identification Number: B-20-MW-06-0026, B-21-MC-06-0026, B-22-MC-06-0026, B-23-MC-06-0026 Program Income Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): Total salaries charged to Federal awards (including extra service pay) are subject to the Standards of Documentation as described by 2 CFR §200.430(i). Per this section, salaries and wages charged to Federal awards must be based on records that accurately reflect the work performed. These records must: - Be incorporated into the organization’s official records; - Reasonably reflect the total activity for which the employee is compensating across all grant related and non-grant related activities (100% effort); - Support the distribution of employee salary across multiple activities or cost objectives (for example, effort spent on multiple federal awards, spent on general/or administrative activities, vacation, sick leave, leave without pay, etc.); and - Utilize an "after-the-fact" review of the employee’s actual hours worked during the reporting period for identifying and correcting significant changes (as defined by the organization’s written policies). Condition: Emergency Solutions Grant Program The City was unable to locate and provide the timesheets for (2) out of eleven (11) samples tested with Payroll Cost allocated to the Program. Within the overall population of a hundred and five (105) lines of ESG and ESGCV payroll charges, the City also had four (4) unsupported employee benefits charged to the program has benefit charged to program. Community Development Block Grants-Entitlement Grants Cluster Payroll costs for eighteen (18) out of forty (40) samples tested were allocated to programs were not supported by approved time samples or updated cost allocation methods/plan, nor were they reconciled to actual time spent on the various programs. Cause: The City did not adhere to its established policies and procedures for verifying that employee compensation charged to federal programs was supported by contemporaneous time records or an after-the-fact distribution of actual time and effort spent on federal program activities. Additionally, a thorough review and reconciliation of payroll time entries and postings from the old financial system (HTE) to the new financial system (MUNIS) was not conducted, resulting in the failure to preserve supporting documentation, such as timesheets, during the transition process. Effect or Potential Effect: The City did not comply with the program’s requirements for allowable costs. There is an increased risk that employees’ compensation charged to the program may not have represented an actual time and effort expended on the program’s activities. Questioned Costs: None. Context: See condition above for the context of the finding. Identification as a Repeat Finding, If Applicable: Not applicable. Recommendation: We recommend that the City enhance its internal controls over payroll processes by implementing policies and procedures that ensure employee compensation charged to federal programs is supported by contemporaneous or after-the-fact documentation of actual time and effort spent on federal program activities. Additionally, all supporting documentation should be properly saved. Views of Responsible Officials: Management concurs with the finding.
2023-006 – Special Tests and Provisions – Internal Control and Compliance over Obligation, Expenditure, Payment Requirements Identification of the Federal Program: Assistance Listing Number: 14.231 Assistance Listing Title: Emergency Solutions Grant Program Federal Agency: U.S. Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Identification Number: E-20-MW-06-0026, E-21-MC-06-0026, E-22-MC-06-0026 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): Pursuant to May 2023 Compliance Supplement, Special Tests and Provisions – Obligation, Expenditures and Payment Requirements – Obligation-ESG. Funds allocated to metropolitan cities, urban counties, and territories. Within 180 days after the date that HUD signs the grant agreement (or a grant amendment for reallocation of funds) with a metropolitan city, urban county, or territory, the recipient must obligate all of the grant amount, except the amount for its administrative costs. ESG-CV funds must be obligated by the recipient in accordance with 24 CFR 576.203(a)(1) and (2), except as provided below. The applicable period for obligating ESG-CV funds begins on the date HUD signed the recipient’s grant agreement for the first allocation of ESG-CV funds. The obligation deadlines below apply to the both the first and second allocation of ESG-CV funds. HUD is also providing further flexibility for recipients (including states and non-states) to provide additional time to identify entities that have capacity and expertise to mitigate the impacts of coronavirus, including those who have not previously or recently received ESG funding. a. Recipients that are metropolitan cities, urban counties, or territories may have up to 240 days from the date HUD signs the grant agreement to obligate ESG-CV funds. Recipients must maintain in their program records a description of any changes the recipient implemented to identify and select new subrecipients. Payments to Subrecipients. The recipient must pay each subrecipient for allowable costs within 30 days after receiving the subrecipient’s complete payment request. This requirement also applies to each subrecipient that is a unit of general-purpose local government (24 CFR section 576.203). Condition: During our audit, we noted that the ESG Grant Fund obligated to sub-recipients under obligation testing were outside of the obligation timeframe of 180 days in case of ESG and 240 days in case of ESG CV without further justifications. In addition, we noted two (2) out of seven (7) samples selected for payment requirements testing were outside of 30 days window without further justifications. Cause: The City does not have formal policies and procedures in place to obligate the funds within the required timeframe nor complete the subrecipient’s payment request within 30 days. In addition, the City did not have procedures in place to timely request grantor extensions and/or document exceptions that are outside of uniform guidance. Effect or Potential Effect: The exceptions noted resulted in noncompliance. Questioned Costs: None. Context: See condition above for the context of the finding. Identification as a Repeat Finding, If Applicable: Yes. See prior year finding 2022-006. Recommendation: We recommended the City establish internal control procedures to monitor compliance requirements to ensure the subrecipient’s payment requests are processed timely. Views of Responsible Officials: Management concurs with the finding.
2023-003 – Allowable Costs/Cost Principles – Internal Control over Payroll Expenditures Identification of the Federal Program: Assistance Listing Number: 14.231 Assistance Listing Title: Emergency Solutions Grant Program Federal Agency: U.S. Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Identification Number: E-20-MW-06-0026, E-21-MC-06-0026, E-22-MC-06-0026 Assistance Listing Number: 14.218 Assistance Listing Title: Community Development Block Grants-Entitlement Grants Cluster Federal Agency: U.S. Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Identification Number: B-20-MW-06-0026, B-21-MC-06-0026, B-22-MC-06-0026, B-23-MC-06-0026 Program Income Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): Total salaries charged to Federal awards (including extra service pay) are subject to the Standards of Documentation as described by 2 CFR §200.430(i). Per this section, salaries and wages charged to Federal awards must be based on records that accurately reflect the work performed. These records must: - Be incorporated into the organization’s official records; - Reasonably reflect the total activity for which the employee is compensating across all grant related and non-grant related activities (100% effort); - Support the distribution of employee salary across multiple activities or cost objectives (for example, effort spent on multiple federal awards, spent on general/or administrative activities, vacation, sick leave, leave without pay, etc.); and - Utilize an "after-the-fact" review of the employee’s actual hours worked during the reporting period for identifying and correcting significant changes (as defined by the organization’s written policies). Condition: Emergency Solutions Grant Program The City was unable to locate and provide the timesheets for (2) out of eleven (11) samples tested with Payroll Cost allocated to the Program. Within the overall population of a hundred and five (105) lines of ESG and ESGCV payroll charges, the City also had four (4) unsupported employee benefits charged to the program has benefit charged to program. Community Development Block Grants-Entitlement Grants Cluster Payroll costs for eighteen (18) out of forty (40) samples tested were allocated to programs were not supported by approved time samples or updated cost allocation methods/plan, nor were they reconciled to actual time spent on the various programs. Cause: The City did not adhere to its established policies and procedures for verifying that employee compensation charged to federal programs was supported by contemporaneous time records or an after-the-fact distribution of actual time and effort spent on federal program activities. Additionally, a thorough review and reconciliation of payroll time entries and postings from the old financial system (HTE) to the new financial system (MUNIS) was not conducted, resulting in the failure to preserve supporting documentation, such as timesheets, during the transition process. Effect or Potential Effect: The City did not comply with the program’s requirements for allowable costs. There is an increased risk that employees’ compensation charged to the program may not have represented an actual time and effort expended on the program’s activities. Questioned Costs: None. Context: See condition above for the context of the finding. Identification as a Repeat Finding, If Applicable: Not applicable. Recommendation: We recommend that the City enhance its internal controls over payroll processes by implementing policies and procedures that ensure employee compensation charged to federal programs is supported by contemporaneous or after-the-fact documentation of actual time and effort spent on federal program activities. Additionally, all supporting documentation should be properly saved. Views of Responsible Officials: Management concurs with the finding.
2023-006 – Special Tests and Provisions – Internal Control and Compliance over Obligation, Expenditure, Payment Requirements Identification of the Federal Program: Assistance Listing Number: 14.231 Assistance Listing Title: Emergency Solutions Grant Program Federal Agency: U.S. Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Identification Number: E-20-MW-06-0026, E-21-MC-06-0026, E-22-MC-06-0026 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): Pursuant to May 2023 Compliance Supplement, Special Tests and Provisions – Obligation, Expenditures and Payment Requirements – Obligation-ESG. Funds allocated to metropolitan cities, urban counties, and territories. Within 180 days after the date that HUD signs the grant agreement (or a grant amendment for reallocation of funds) with a metropolitan city, urban county, or territory, the recipient must obligate all of the grant amount, except the amount for its administrative costs. ESG-CV funds must be obligated by the recipient in accordance with 24 CFR 576.203(a)(1) and (2), except as provided below. The applicable period for obligating ESG-CV funds begins on the date HUD signed the recipient’s grant agreement for the first allocation of ESG-CV funds. The obligation deadlines below apply to the both the first and second allocation of ESG-CV funds. HUD is also providing further flexibility for recipients (including states and non-states) to provide additional time to identify entities that have capacity and expertise to mitigate the impacts of coronavirus, including those who have not previously or recently received ESG funding. a. Recipients that are metropolitan cities, urban counties, or territories may have up to 240 days from the date HUD signs the grant agreement to obligate ESG-CV funds. Recipients must maintain in their program records a description of any changes the recipient implemented to identify and select new subrecipients. Payments to Subrecipients. The recipient must pay each subrecipient for allowable costs within 30 days after receiving the subrecipient’s complete payment request. This requirement also applies to each subrecipient that is a unit of general-purpose local government (24 CFR section 576.203). Condition: During our audit, we noted that the ESG Grant Fund obligated to sub-recipients under obligation testing were outside of the obligation timeframe of 180 days in case of ESG and 240 days in case of ESG CV without further justifications. In addition, we noted two (2) out of seven (7) samples selected for payment requirements testing were outside of 30 days window without further justifications. Cause: The City does not have formal policies and procedures in place to obligate the funds within the required timeframe nor complete the subrecipient’s payment request within 30 days. In addition, the City did not have procedures in place to timely request grantor extensions and/or document exceptions that are outside of uniform guidance. Effect or Potential Effect: The exceptions noted resulted in noncompliance. Questioned Costs: None. Context: See condition above for the context of the finding. Identification as a Repeat Finding, If Applicable: Yes. See prior year finding 2022-006. Recommendation: We recommended the City establish internal control procedures to monitor compliance requirements to ensure the subrecipient’s payment requests are processed timely. Views of Responsible Officials: Management concurs with the finding.
2023-004 – Eligibility – Internal Control Over Eligibility Identification of the Federal Program: Assistance Listing Number: 21.023 Assistance Listing Title: Emergency Rental Assistance Program Federal Agency: Department of Treasury Pass-Through Entity: State of California Department of Finance Federal Award Identification Number: N/A Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): Pursuant to the May 2023 Compliance Supplement, Eligibility: This approach to eligibility was implemented in accordance with 15 USC 9058a, for ERA 1 in 15 USC 9058a(c)(2)(C)(ii) concerning documentation of payments to households, 15 USC 9058a(f)(2)(A) and (B) of the Act concerning signature requirements for applications and documentation required for tenants, 15 USC 9058a (k)(1) concerning area median income determinations, and 15 USC 9058a (k)(3)(A)(I) and (II) concerning eligible household determinations and attestation requirements. This treatment is further explained in the ERA FAQs; 15 USC 9058a; and the Treasury, Department of Justice and Department of Housing and Urban Development joint letter issued August 27, 2021 (https://home.treasury.gov/system/files/136/Eviction- Moratorium-Joint-Letter.pdf). To the extent that a grantee has established and consistently followed its own reasonable procedures for implementing an eligibility determination process, consistent with Treasury’s guidance, it is not Treasury’s expectation that grantees should seek additional documentation from a beneficiary after the initial determination of eligibility has been completed, including for those determined to be eligible using self-attestation, categorical eligibility, or fact-specific proxies in qualifying circumstances. Testing of individual household eligibility-related documentation should be limited to material already collected by the grantee during application as much as possible to avoid imposing undue burden on households that remain at risk of housing instability. Condition: During our audit, we noted five (5) samples out of nine (9) samples selected for the eligibility requirement testing with internal control deficiency related to the income eligibility verification. The city failed to collect the zero income attestation document from applicant. The amount of income shown in documents uploaded by applicant was different from the amount shown in application/system, check box for income verification was not ticked off by supervisor though the verification was completed. However, we recalculated those five applicants’ income based on the income verification support provided and those applicants were eligible to receive the grant subsidy based on the income limit. Cause: The City did not have proper internal controls in place to review the process performed. Effect or Potential Effect: The City could potentially be out of compliance with the eligibility requirement due to the error in executing the internal control procedures. Questioned Costs: None. Context: See condition above for the context of the finding. Identification as a Repeat Finding, If Applicable: Yes. See prior year finding 2022-003. Recommendation: We recommend the City enhance its internal control by implementing policies and procedures over eligibility requirement. Views of Responsible Officials: Management concurs with the finding.
2023-004 – Eligibility – Internal Control Over Eligibility Identification of the Federal Program: Assistance Listing Number: 21.023 Assistance Listing Title: Emergency Rental Assistance Program Federal Agency: Department of Treasury Pass-Through Entity: State of California Department of Finance Federal Award Identification Number: N/A Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): Pursuant to the May 2023 Compliance Supplement, Eligibility: This approach to eligibility was implemented in accordance with 15 USC 9058a, for ERA 1 in 15 USC 9058a(c)(2)(C)(ii) concerning documentation of payments to households, 15 USC 9058a(f)(2)(A) and (B) of the Act concerning signature requirements for applications and documentation required for tenants, 15 USC 9058a (k)(1) concerning area median income determinations, and 15 USC 9058a (k)(3)(A)(I) and (II) concerning eligible household determinations and attestation requirements. This treatment is further explained in the ERA FAQs; 15 USC 9058a; and the Treasury, Department of Justice and Department of Housing and Urban Development joint letter issued August 27, 2021 (https://home.treasury.gov/system/files/136/Eviction- Moratorium-Joint-Letter.pdf). To the extent that a grantee has established and consistently followed its own reasonable procedures for implementing an eligibility determination process, consistent with Treasury’s guidance, it is not Treasury’s expectation that grantees should seek additional documentation from a beneficiary after the initial determination of eligibility has been completed, including for those determined to be eligible using self-attestation, categorical eligibility, or fact-specific proxies in qualifying circumstances. Testing of individual household eligibility-related documentation should be limited to material already collected by the grantee during application as much as possible to avoid imposing undue burden on households that remain at risk of housing instability. Condition: During our audit, we noted five (5) samples out of nine (9) samples selected for the eligibility requirement testing with internal control deficiency related to the income eligibility verification. The city failed to collect the zero income attestation document from applicant. The amount of income shown in documents uploaded by applicant was different from the amount shown in application/system, check box for income verification was not ticked off by supervisor though the verification was completed. However, we recalculated those five applicants’ income based on the income verification support provided and those applicants were eligible to receive the grant subsidy based on the income limit. Cause: The City did not have proper internal controls in place to review the process performed. Effect or Potential Effect: The City could potentially be out of compliance with the eligibility requirement due to the error in executing the internal control procedures. Questioned Costs: None. Context: See condition above for the context of the finding. Identification as a Repeat Finding, If Applicable: Yes. See prior year finding 2022-003. Recommendation: We recommend the City enhance its internal control by implementing policies and procedures over eligibility requirement. Views of Responsible Officials: Management concurs with the finding.
2023-004 – Eligibility – Internal Control Over Eligibility Identification of the Federal Program: Assistance Listing Number: 21.023 Assistance Listing Title: Emergency Rental Assistance Program Federal Agency: Department of Treasury Pass-Through Entity: State of California Department of Finance Federal Award Identification Number: N/A Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): Pursuant to the May 2023 Compliance Supplement, Eligibility: This approach to eligibility was implemented in accordance with 15 USC 9058a, for ERA 1 in 15 USC 9058a(c)(2)(C)(ii) concerning documentation of payments to households, 15 USC 9058a(f)(2)(A) and (B) of the Act concerning signature requirements for applications and documentation required for tenants, 15 USC 9058a (k)(1) concerning area median income determinations, and 15 USC 9058a (k)(3)(A)(I) and (II) concerning eligible household determinations and attestation requirements. This treatment is further explained in the ERA FAQs; 15 USC 9058a; and the Treasury, Department of Justice and Department of Housing and Urban Development joint letter issued August 27, 2021 (https://home.treasury.gov/system/files/136/Eviction- Moratorium-Joint-Letter.pdf). To the extent that a grantee has established and consistently followed its own reasonable procedures for implementing an eligibility determination process, consistent with Treasury’s guidance, it is not Treasury’s expectation that grantees should seek additional documentation from a beneficiary after the initial determination of eligibility has been completed, including for those determined to be eligible using self-attestation, categorical eligibility, or fact-specific proxies in qualifying circumstances. Testing of individual household eligibility-related documentation should be limited to material already collected by the grantee during application as much as possible to avoid imposing undue burden on households that remain at risk of housing instability. Condition: During our audit, we noted five (5) samples out of nine (9) samples selected for the eligibility requirement testing with internal control deficiency related to the income eligibility verification. The city failed to collect the zero income attestation document from applicant. The amount of income shown in documents uploaded by applicant was different from the amount shown in application/system, check box for income verification was not ticked off by supervisor though the verification was completed. However, we recalculated those five applicants’ income based on the income verification support provided and those applicants were eligible to receive the grant subsidy based on the income limit. Cause: The City did not have proper internal controls in place to review the process performed. Effect or Potential Effect: The City could potentially be out of compliance with the eligibility requirement due to the error in executing the internal control procedures. Questioned Costs: None. Context: See condition above for the context of the finding. Identification as a Repeat Finding, If Applicable: Yes. See prior year finding 2022-003. Recommendation: We recommend the City enhance its internal control by implementing policies and procedures over eligibility requirement. Views of Responsible Officials: Management concurs with the finding.