Audit 31838

FY End
2022-06-30
Total Expended
$18.98M
Findings
4
Programs
11
Organization: City of South Gate (CA)
Year: 2022 Accepted: 2023-03-28
Auditor: Davis Farr LLP

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
37637 2022-005 Significant Deficiency - B
37638 2022-006 - Yes L
614079 2022-005 Significant Deficiency - B
614080 2022-006 - Yes L

Contacts

Name Title Type
WL7DME3FJSW4 Kristopher Ryan Auditee
3235799524 Jennifer Farr Auditor
No contacts on file

Notes to SEFA

Accounting Policies: Expenditures reported on the Schedule are reported on the modified-accrual basis ofaccounting for those grants that were recorded in governmental funds, and on theaccrual basis of accounting for those grants that were recorded in proprietary funds.Such expenditures for part of the year are recognized following the cost principlescontained in OMB Circular 87, Cost Principles for State, Local, and Indian TribalGovernments, and for part of the year contained in Uniform AdministrativeRequirements, Cost Principles, and Audit Requirements for Federal Awards whereincertain types of expenditures are not allowable or are limited as to reimbursement.Pass-through entity identifying numbers are presented where available. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate.

Finding Details

2022-005: Federal Awards ? Allowable Costs Federal Agency: U.S. Department of Treasury CFDA No.: 14.218 Federal Program: Community Development Block Grants/Entitlement Grants Federal Award Year: 2022 Control Category: Allowable Costs Questioned Costs: $23,270 Condition The City charged CDBG payroll expenses to the program based a timesheet allocation and did not adjust the charges to reconcile to actual time incurred per employee timesheets. Criteria 2 CFR 200.430(i), Standards for Documentation of Personnel Expenses, states, in part: ?Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed?? Charges must ?support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award;?? And ?budget estimates (i.e., estimates determined before the services are performed) alone do not qualify as support for charges to Federal awards.? Cause The City's payroll system charges time for employees each pay period based on an allocation rather than actual hours documented on the employee?s timesheet. Effect Payroll costs charged to the program were greater than amounts supported by the documentation. Questioned Costs There were questioned costs in the amount of $23,270. Recommendation We recommend that the City charge time to the program based on actual hours worked per the employees' timesheets. Management?s Response Regarding Corrective Action Taken or Planned Management acknowledges the importance of ensuring that payroll costs charged to the program are consistent between the payroll system and the employee?s timesheet. The Finance Department plans to provide training to program staff on how to properly report their time worked on the grant to ensure that hours worked are both reported correctly on the timesheets and are following the funding allocations that are approved by the grant.
2022-006: Federal Awards ? Reporting Federal Agency: Department of Housing and Urban Development CFDA No.: 14.218 Federal Program: Community Development Block Grants/Entitlement Grants Federal Award Year: 2022 Control Category: Reporting Questioned Costs: $0 Condition For the Community Development Block Grants/Entitlement Grants program, the City did not submit the following reports within the required deadline: Report Type Reporting Period (End Date) Report Submission Deadline Report Submission Date SF-425 Federal Financial Report September 30, 2021 October 30, 2022 January 11, 2022 SF-425 Federal Financial Report December 31, 2021 January 30, 2022 January 19, 2022 SF-425 Federal Financial Report March 31, 2022 April 30, 2022 May 10, 2022 SF-425 Federal Financial Report June 30, 2022 July 30, 2022 September 7, 2022 Criteria Pursuant to the Part 4 CDBG ? Entitlement Grants Cluster and financial and performance reporting requirements in the cooperative agreement provisions, and 2 CFR 200.327: SF-425 Federal Financial Report: Program award recipients must submit SF 425 reports to HUD quarterly, 30 days after the reporting period end date. Each report must cover all expenditures on the cooperative agreement from the start date of the reporting period to the reporting period end date. The following federal fiscal year quarter reporting period will be used for all quarterly reports, are due to HUD 30 days after the period end dates. Cause The City did not have internal controls in place to ensure that financial and performance reports are filed timely. Effect Delay in filing the reports resulted in non-compliance with the compliance requirements. Questioned Costs There were no questioned costs. Recommendation We recommend that the City strengthen internal controls by implementing procedures to ensure the timely filing of financial and performance reports. Management?s Response Regarding Corrective Action Taken or Planned Management agrees with the finding. Due to vacancies experienced by the City of South Gate and the absence of a Director and Deputy Director of Administrative Services, management was not able to properly oversee the timely submission of the SF-425 financial reports for fiscal year ended June 30, 2022. Additionally, due to these vacancies, the late submission of these reports extended into the first two quarters of the following fiscal year. However, these vacant positions have since been filled and Management will ensure that all SF-425 financial reports are reviewed and submitted within 30 days after the reporting period end date.
2022-005: Federal Awards ? Allowable Costs Federal Agency: U.S. Department of Treasury CFDA No.: 14.218 Federal Program: Community Development Block Grants/Entitlement Grants Federal Award Year: 2022 Control Category: Allowable Costs Questioned Costs: $23,270 Condition The City charged CDBG payroll expenses to the program based a timesheet allocation and did not adjust the charges to reconcile to actual time incurred per employee timesheets. Criteria 2 CFR 200.430(i), Standards for Documentation of Personnel Expenses, states, in part: ?Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed?? Charges must ?support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award;?? And ?budget estimates (i.e., estimates determined before the services are performed) alone do not qualify as support for charges to Federal awards.? Cause The City's payroll system charges time for employees each pay period based on an allocation rather than actual hours documented on the employee?s timesheet. Effect Payroll costs charged to the program were greater than amounts supported by the documentation. Questioned Costs There were questioned costs in the amount of $23,270. Recommendation We recommend that the City charge time to the program based on actual hours worked per the employees' timesheets. Management?s Response Regarding Corrective Action Taken or Planned Management acknowledges the importance of ensuring that payroll costs charged to the program are consistent between the payroll system and the employee?s timesheet. The Finance Department plans to provide training to program staff on how to properly report their time worked on the grant to ensure that hours worked are both reported correctly on the timesheets and are following the funding allocations that are approved by the grant.
2022-006: Federal Awards ? Reporting Federal Agency: Department of Housing and Urban Development CFDA No.: 14.218 Federal Program: Community Development Block Grants/Entitlement Grants Federal Award Year: 2022 Control Category: Reporting Questioned Costs: $0 Condition For the Community Development Block Grants/Entitlement Grants program, the City did not submit the following reports within the required deadline: Report Type Reporting Period (End Date) Report Submission Deadline Report Submission Date SF-425 Federal Financial Report September 30, 2021 October 30, 2022 January 11, 2022 SF-425 Federal Financial Report December 31, 2021 January 30, 2022 January 19, 2022 SF-425 Federal Financial Report March 31, 2022 April 30, 2022 May 10, 2022 SF-425 Federal Financial Report June 30, 2022 July 30, 2022 September 7, 2022 Criteria Pursuant to the Part 4 CDBG ? Entitlement Grants Cluster and financial and performance reporting requirements in the cooperative agreement provisions, and 2 CFR 200.327: SF-425 Federal Financial Report: Program award recipients must submit SF 425 reports to HUD quarterly, 30 days after the reporting period end date. Each report must cover all expenditures on the cooperative agreement from the start date of the reporting period to the reporting period end date. The following federal fiscal year quarter reporting period will be used for all quarterly reports, are due to HUD 30 days after the period end dates. Cause The City did not have internal controls in place to ensure that financial and performance reports are filed timely. Effect Delay in filing the reports resulted in non-compliance with the compliance requirements. Questioned Costs There were no questioned costs. Recommendation We recommend that the City strengthen internal controls by implementing procedures to ensure the timely filing of financial and performance reports. Management?s Response Regarding Corrective Action Taken or Planned Management agrees with the finding. Due to vacancies experienced by the City of South Gate and the absence of a Director and Deputy Director of Administrative Services, management was not able to properly oversee the timely submission of the SF-425 financial reports for fiscal year ended June 30, 2022. Additionally, due to these vacancies, the late submission of these reports extended into the first two quarters of the following fiscal year. However, these vacant positions have since been filled and Management will ensure that all SF-425 financial reports are reviewed and submitted within 30 days after the reporting period end date.