Audit 1395

FY End
2022-06-30
Total Expended
$11.08M
Findings
16
Programs
11
Organization: City of Baldwin Park (CA)
Year: 2022 Accepted: 2023-10-25

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
739 2022-003 Significant Deficiency - B
740 2022-003 Significant Deficiency - B
741 2022-003 Significant Deficiency - B
742 2022-004 Significant Deficiency - I
743 2022-005 Material Weakness Yes L
744 2022-005 Material Weakness Yes L
745 2022-006 Material Weakness Yes N
746 2022-007 Significant Deficiency Yes N
577181 2022-003 Significant Deficiency - B
577182 2022-003 Significant Deficiency - B
577183 2022-003 Significant Deficiency - B
577184 2022-004 Significant Deficiency - I
577185 2022-005 Material Weakness Yes L
577186 2022-005 Material Weakness Yes L
577187 2022-006 Material Weakness Yes N
577188 2022-007 Significant Deficiency Yes N

Contacts

Name Title Type
MQD3WRJ5RBN9 Rose Tam Auditee
6269604011 Kenneth Pun Auditor
No contacts on file

Notes to SEFA

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, 2022. 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.

Finding Details

Community Development Block Grants-Entitlement Grants Cluster We determined the City did not comply with federal requirements for direct payroll charges. Payroll costs for all eight employees tested were allocated to programs based on percentages provided by management. These allocations 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. Employee timesheets did not record the actual labor efforts expended on these grants. . During our testing of payroll expenditures, 40 of the 40 payroll charges non-statistically sampled were based on payroll budget allocations. Housing Voucher Cluster We determined the City did not comply with federal requirements for direct payroll charges. Payroll costs for all six employees tested were allocated to programs based on percentages provided by management. These allocations 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. Employee timesheets did not record the actual labor efforts expended on these grants. During our testing of payroll expenditures, 25 of the 25 payroll charges non-statistically sampled were based on payroll budget allocations. Coronavirus State and Local Fiscal Recovery Funds One out of 40 samples selected for testing that staff was not able to provide the personal action form for the auditors to verify the employee title and step in order to verify the pay rate against to the adopted salary schedule.
Community Development Block Grants-Entitlement Grants Cluster We determined the City did not comply with federal requirements for direct payroll charges. Payroll costs for all eight employees tested were allocated to programs based on percentages provided by management. These allocations 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. Employee timesheets did not record the actual labor efforts expended on these grants. . During our testing of payroll expenditures, 40 of the 40 payroll charges non-statistically sampled were based on payroll budget allocations. Housing Voucher Cluster We determined the City did not comply with federal requirements for direct payroll charges. Payroll costs for all six employees tested were allocated to programs based on percentages provided by management. These allocations 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. Employee timesheets did not record the actual labor efforts expended on these grants. During our testing of payroll expenditures, 25 of the 25 payroll charges non-statistically sampled were based on payroll budget allocations. Coronavirus State and Local Fiscal Recovery Funds One out of 40 samples selected for testing that staff was not able to provide the personal action form for the auditors to verify the employee title and step in order to verify the pay rate against to the adopted salary schedule.
Community Development Block Grants-Entitlement Grants Cluster We determined the City did not comply with federal requirements for direct payroll charges. Payroll costs for all eight employees tested were allocated to programs based on percentages provided by management. These allocations 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. Employee timesheets did not record the actual labor efforts expended on these grants. . During our testing of payroll expenditures, 40 of the 40 payroll charges non-statistically sampled were based on payroll budget allocations. Housing Voucher Cluster We determined the City did not comply with federal requirements for direct payroll charges. Payroll costs for all six employees tested were allocated to programs based on percentages provided by management. These allocations 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. Employee timesheets did not record the actual labor efforts expended on these grants. During our testing of payroll expenditures, 25 of the 25 payroll charges non-statistically sampled were based on payroll budget allocations. Coronavirus State and Local Fiscal Recovery Funds One out of 40 samples selected for testing that staff was not able to provide the personal action form for the auditors to verify the employee title and step in order to verify the pay rate against to the adopted salary schedule.
During our audit, we noted that there was no supporting document to indicate that the City verified the vendor against the SAM to ensure the vendor was not suspended or debarred from federally-funded programs before the contract was entered into.
As a result of our test work, we noted the following exceptions: Community Development Block Grants-Entitlement Grants Cluster The City did not submit the required Cash on Hand Quarterly Report in a timely manner. The quarterly Cash on Hand Quarterly Report for the reporting period ended September 30, 2021 was submitted on Nov 1, 2021 and for the reporting period ended March 31, 2022 was submitted on May 4, 2022. The City did not submit any of the four (4) quarterly Section 15011 Reports for the year ended June 30, 2022. Housing Voucher Cluster The audited Financial Data Schedule (FDS) for the fiscal year ended June 30, 2022 was not submitted on or before the March 31, 2023 due date. We also noted for 4 out of 4 VMS reports tested, there was no evidence of review and approval prior to submission to HUD. We noted the City does not have internal controls designed to review the VMS report prior to submission. A nonstatistical sample of 4 out of 12 VMS reports were selected for test work.
As a result of our test work, we noted the following exceptions: Community Development Block Grants-Entitlement Grants Cluster The City did not submit the required Cash on Hand Quarterly Report in a timely manner. The quarterly Cash on Hand Quarterly Report for the reporting period ended September 30, 2021 was submitted on Nov 1, 2021 and for the reporting period ended March 31, 2022 was submitted on May 4, 2022. The City did not submit any of the four (4) quarterly Section 15011 Reports for the year ended June 30, 2022. Housing Voucher Cluster The audited Financial Data Schedule (FDS) for the fiscal year ended June 30, 2022 was not submitted on or before the March 31, 2023 due date. We also noted for 4 out of 4 VMS reports tested, there was no evidence of review and approval prior to submission to HUD. We noted the City does not have internal controls designed to review the VMS report prior to submission. A nonstatistical sample of 4 out of 12 VMS reports were selected for test work.
We found seven (7) instances out of 40 in which the City did not conduct the HQS biennial inspection in a timely manner. A nonstatistical sample of 40 of 5,523 HAP payments were selected to test compliance over special tests and provisions – Housing Quality Standards Inspections (HQS).
The PHA does not have a review process in place to determine if the utility allowance schedule is accurate and updated. During our review, the PHA could not provide documentation that the utility allowance schedule has been reviewed annually for each utility category to determine if there has been a rate change of ten percent or more. Therefore, we could not determine if the appropriate utility allowance was given for tenant-paid utilities. For 2022, the utility allowance schedule used was from 2019, and documentation was not provided to determine that utility rates have not changed by 10 percent or more for a utility category.
Community Development Block Grants-Entitlement Grants Cluster We determined the City did not comply with federal requirements for direct payroll charges. Payroll costs for all eight employees tested were allocated to programs based on percentages provided by management. These allocations 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. Employee timesheets did not record the actual labor efforts expended on these grants. . During our testing of payroll expenditures, 40 of the 40 payroll charges non-statistically sampled were based on payroll budget allocations. Housing Voucher Cluster We determined the City did not comply with federal requirements for direct payroll charges. Payroll costs for all six employees tested were allocated to programs based on percentages provided by management. These allocations 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. Employee timesheets did not record the actual labor efforts expended on these grants. During our testing of payroll expenditures, 25 of the 25 payroll charges non-statistically sampled were based on payroll budget allocations. Coronavirus State and Local Fiscal Recovery Funds One out of 40 samples selected for testing that staff was not able to provide the personal action form for the auditors to verify the employee title and step in order to verify the pay rate against to the adopted salary schedule.
Community Development Block Grants-Entitlement Grants Cluster We determined the City did not comply with federal requirements for direct payroll charges. Payroll costs for all eight employees tested were allocated to programs based on percentages provided by management. These allocations 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. Employee timesheets did not record the actual labor efforts expended on these grants. . During our testing of payroll expenditures, 40 of the 40 payroll charges non-statistically sampled were based on payroll budget allocations. Housing Voucher Cluster We determined the City did not comply with federal requirements for direct payroll charges. Payroll costs for all six employees tested were allocated to programs based on percentages provided by management. These allocations 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. Employee timesheets did not record the actual labor efforts expended on these grants. During our testing of payroll expenditures, 25 of the 25 payroll charges non-statistically sampled were based on payroll budget allocations. Coronavirus State and Local Fiscal Recovery Funds One out of 40 samples selected for testing that staff was not able to provide the personal action form for the auditors to verify the employee title and step in order to verify the pay rate against to the adopted salary schedule.
Community Development Block Grants-Entitlement Grants Cluster We determined the City did not comply with federal requirements for direct payroll charges. Payroll costs for all eight employees tested were allocated to programs based on percentages provided by management. These allocations 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. Employee timesheets did not record the actual labor efforts expended on these grants. . During our testing of payroll expenditures, 40 of the 40 payroll charges non-statistically sampled were based on payroll budget allocations. Housing Voucher Cluster We determined the City did not comply with federal requirements for direct payroll charges. Payroll costs for all six employees tested were allocated to programs based on percentages provided by management. These allocations 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. Employee timesheets did not record the actual labor efforts expended on these grants. During our testing of payroll expenditures, 25 of the 25 payroll charges non-statistically sampled were based on payroll budget allocations. Coronavirus State and Local Fiscal Recovery Funds One out of 40 samples selected for testing that staff was not able to provide the personal action form for the auditors to verify the employee title and step in order to verify the pay rate against to the adopted salary schedule.
During our audit, we noted that there was no supporting document to indicate that the City verified the vendor against the SAM to ensure the vendor was not suspended or debarred from federally-funded programs before the contract was entered into.
As a result of our test work, we noted the following exceptions: Community Development Block Grants-Entitlement Grants Cluster The City did not submit the required Cash on Hand Quarterly Report in a timely manner. The quarterly Cash on Hand Quarterly Report for the reporting period ended September 30, 2021 was submitted on Nov 1, 2021 and for the reporting period ended March 31, 2022 was submitted on May 4, 2022. The City did not submit any of the four (4) quarterly Section 15011 Reports for the year ended June 30, 2022. Housing Voucher Cluster The audited Financial Data Schedule (FDS) for the fiscal year ended June 30, 2022 was not submitted on or before the March 31, 2023 due date. We also noted for 4 out of 4 VMS reports tested, there was no evidence of review and approval prior to submission to HUD. We noted the City does not have internal controls designed to review the VMS report prior to submission. A nonstatistical sample of 4 out of 12 VMS reports were selected for test work.
As a result of our test work, we noted the following exceptions: Community Development Block Grants-Entitlement Grants Cluster The City did not submit the required Cash on Hand Quarterly Report in a timely manner. The quarterly Cash on Hand Quarterly Report for the reporting period ended September 30, 2021 was submitted on Nov 1, 2021 and for the reporting period ended March 31, 2022 was submitted on May 4, 2022. The City did not submit any of the four (4) quarterly Section 15011 Reports for the year ended June 30, 2022. Housing Voucher Cluster The audited Financial Data Schedule (FDS) for the fiscal year ended June 30, 2022 was not submitted on or before the March 31, 2023 due date. We also noted for 4 out of 4 VMS reports tested, there was no evidence of review and approval prior to submission to HUD. We noted the City does not have internal controls designed to review the VMS report prior to submission. A nonstatistical sample of 4 out of 12 VMS reports were selected for test work.
We found seven (7) instances out of 40 in which the City did not conduct the HQS biennial inspection in a timely manner. A nonstatistical sample of 40 of 5,523 HAP payments were selected to test compliance over special tests and provisions – Housing Quality Standards Inspections (HQS).
The PHA does not have a review process in place to determine if the utility allowance schedule is accurate and updated. During our review, the PHA could not provide documentation that the utility allowance schedule has been reviewed annually for each utility category to determine if there has been a rate change of ten percent or more. Therefore, we could not determine if the appropriate utility allowance was given for tenant-paid utilities. For 2022, the utility allowance schedule used was from 2019, and documentation was not provided to determine that utility rates have not changed by 10 percent or more for a utility category.