Audit 302364

FY End
2023-06-30
Total Expended
$12.61M
Findings
30
Programs
11
Organization: City of Baldwin Park (CA)
Year: 2023 Accepted: 2024-04-02

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
392140 2023-002 Significant Deficiency Yes B
392141 2023-002 Significant Deficiency Yes B
392142 2023-002 Significant Deficiency Yes B
392143 2023-002 Significant Deficiency Yes B
392144 2023-003 Significant Deficiency - B
392145 2023-004 Significant Deficiency Yes I
392146 2023-004 Significant Deficiency Yes I
392147 2023-004 Significant Deficiency Yes I
392148 2023-005 Material Weakness Yes L
392149 2023-005 Material Weakness Yes L
392150 2023-005 Material Weakness Yes L
392151 2023-005 Material Weakness Yes L
392152 2023-006 Significant Deficiency - M
392153 2023-007 Material Weakness Yes N
392154 2023-007 Material Weakness Yes N
968582 2023-002 Significant Deficiency Yes B
968583 2023-002 Significant Deficiency Yes B
968584 2023-002 Significant Deficiency Yes B
968585 2023-002 Significant Deficiency Yes B
968586 2023-003 Significant Deficiency - B
968587 2023-004 Significant Deficiency Yes I
968588 2023-004 Significant Deficiency Yes I
968589 2023-004 Significant Deficiency Yes I
968590 2023-005 Material Weakness Yes L
968591 2023-005 Material Weakness Yes L
968592 2023-005 Material Weakness Yes L
968593 2023-005 Material Weakness Yes L
968594 2023-006 Significant Deficiency - M
968595 2023-007 Material Weakness Yes N
968596 2023-007 Material Weakness 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, 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. 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. Negative amounts, if applicable, shown on 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 elected not to use the 10% de minimis indirect cost rate as allowed under the Uniform Guidance.

Finding Details

2023-002 - Allowable Costs/Cost Principles – Internal Control and Compliance over Payroll Expenditures (Significant Deficiency) Information on the Federal Program(s): Assistance Listing Number: 14.218 Federal Program Name: Community Development Block Grants-Entitlement Grants Cluster Federal Agency: Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Number(s) and Award Year: B-21-MC-06-0554 B-20-MW-06-0554 Assistance Listing Number: 14.871 Federal Program Name: Housing Voucher Cluster Federal Agency: Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Number(s) and Award Year: CA120 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: 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. In April 2023, the City has required all Housing Department staff to retrospectively fill out timesheets pertaining to actual hours worked on the program during fiscal year 2023, The City performed reconciliation on Housing Department staff payroll charges to reflect actual hours worked. However, for the admin supporting staff did not use the same method due to the low percentage of the payroll charges to the grant. Housing Voucher Cluster We determined the City did not comply with federal requirements for direct payroll charges. Payroll costs for all five 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. In April 2023, the City has required all Housing Department staff to retrospectively fill out timesheets pertaining to actual hours worked on the program during fiscal year 2023, The City performed reconciliation on Housing Department staff payroll charges to reflect actual hours worked. However, for the admin supporting staff did not use the same method due to the low percentage of the payroll charges to the grant. Cause: The City did not follow its adopted policies and procedures for ensuring employees’ compensation charged to federal programs was supported by contemporaneous time record or an after-the-fact distribution of employees’ actual time and effort expended on federal program activities. The City’s attempt in addressing prior year finding was not deemed sufficient due to lack of reconciliation for actual hours worked for payroll charges from Administrative, Finance, and Other Departments. 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: Community Development Block Grants-Entitlement Grants Cluster $41,821 Housing Voucher Cluster $15,986 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 comply with federal regulation requiring that any employee funded by federal grant document the actual time they spend working on the grant’s objectives. Documentation must reflect “actual” time spent by employees on awards being charged. The City should develop and implement policies and procedures that ensure that employees’ compensation charged to federal programs reflect a contemporaneous or after-the-fact distribution of employees’ actual time and effort expended on federal programs. We also recommend the City enhance its internal controls over the payroll processes. Views of Responsible Officials: Management concurs the finding.
2023-002 - Allowable Costs/Cost Principles – Internal Control and Compliance over Payroll Expenditures (Significant Deficiency) Information on the Federal Program(s): Assistance Listing Number: 14.218 Federal Program Name: Community Development Block Grants-Entitlement Grants Cluster Federal Agency: Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Number(s) and Award Year: B-21-MC-06-0554 B-20-MW-06-0554 Assistance Listing Number: 14.871 Federal Program Name: Housing Voucher Cluster Federal Agency: Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Number(s) and Award Year: CA120 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: 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. In April 2023, the City has required all Housing Department staff to retrospectively fill out timesheets pertaining to actual hours worked on the program during fiscal year 2023, The City performed reconciliation on Housing Department staff payroll charges to reflect actual hours worked. However, for the admin supporting staff did not use the same method due to the low percentage of the payroll charges to the grant. Housing Voucher Cluster We determined the City did not comply with federal requirements for direct payroll charges. Payroll costs for all five 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. In April 2023, the City has required all Housing Department staff to retrospectively fill out timesheets pertaining to actual hours worked on the program during fiscal year 2023, The City performed reconciliation on Housing Department staff payroll charges to reflect actual hours worked. However, for the admin supporting staff did not use the same method due to the low percentage of the payroll charges to the grant. Cause: The City did not follow its adopted policies and procedures for ensuring employees’ compensation charged to federal programs was supported by contemporaneous time record or an after-the-fact distribution of employees’ actual time and effort expended on federal program activities. The City’s attempt in addressing prior year finding was not deemed sufficient due to lack of reconciliation for actual hours worked for payroll charges from Administrative, Finance, and Other Departments. 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: Community Development Block Grants-Entitlement Grants Cluster $41,821 Housing Voucher Cluster $15,986 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 comply with federal regulation requiring that any employee funded by federal grant document the actual time they spend working on the grant’s objectives. Documentation must reflect “actual” time spent by employees on awards being charged. The City should develop and implement policies and procedures that ensure that employees’ compensation charged to federal programs reflect a contemporaneous or after-the-fact distribution of employees’ actual time and effort expended on federal programs. We also recommend the City enhance its internal controls over the payroll processes. Views of Responsible Officials: Management concurs the finding.
2023-002 - Allowable Costs/Cost Principles – Internal Control and Compliance over Payroll Expenditures (Significant Deficiency) Information on the Federal Program(s): Assistance Listing Number: 14.218 Federal Program Name: Community Development Block Grants-Entitlement Grants Cluster Federal Agency: Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Number(s) and Award Year: B-21-MC-06-0554 B-20-MW-06-0554 Assistance Listing Number: 14.871 Federal Program Name: Housing Voucher Cluster Federal Agency: Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Number(s) and Award Year: CA120 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: 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. In April 2023, the City has required all Housing Department staff to retrospectively fill out timesheets pertaining to actual hours worked on the program during fiscal year 2023, The City performed reconciliation on Housing Department staff payroll charges to reflect actual hours worked. However, for the admin supporting staff did not use the same method due to the low percentage of the payroll charges to the grant. Housing Voucher Cluster We determined the City did not comply with federal requirements for direct payroll charges. Payroll costs for all five 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. In April 2023, the City has required all Housing Department staff to retrospectively fill out timesheets pertaining to actual hours worked on the program during fiscal year 2023, The City performed reconciliation on Housing Department staff payroll charges to reflect actual hours worked. However, for the admin supporting staff did not use the same method due to the low percentage of the payroll charges to the grant. Cause: The City did not follow its adopted policies and procedures for ensuring employees’ compensation charged to federal programs was supported by contemporaneous time record or an after-the-fact distribution of employees’ actual time and effort expended on federal program activities. The City’s attempt in addressing prior year finding was not deemed sufficient due to lack of reconciliation for actual hours worked for payroll charges from Administrative, Finance, and Other Departments. 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: Community Development Block Grants-Entitlement Grants Cluster $41,821 Housing Voucher Cluster $15,986 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 comply with federal regulation requiring that any employee funded by federal grant document the actual time they spend working on the grant’s objectives. Documentation must reflect “actual” time spent by employees on awards being charged. The City should develop and implement policies and procedures that ensure that employees’ compensation charged to federal programs reflect a contemporaneous or after-the-fact distribution of employees’ actual time and effort expended on federal programs. We also recommend the City enhance its internal controls over the payroll processes. Views of Responsible Officials: Management concurs the finding.
2023-002 - Allowable Costs/Cost Principles – Internal Control and Compliance over Payroll Expenditures (Significant Deficiency) Information on the Federal Program(s): Assistance Listing Number: 14.218 Federal Program Name: Community Development Block Grants-Entitlement Grants Cluster Federal Agency: Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Number(s) and Award Year: B-21-MC-06-0554 B-20-MW-06-0554 Assistance Listing Number: 14.871 Federal Program Name: Housing Voucher Cluster Federal Agency: Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Number(s) and Award Year: CA120 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: 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. In April 2023, the City has required all Housing Department staff to retrospectively fill out timesheets pertaining to actual hours worked on the program during fiscal year 2023, The City performed reconciliation on Housing Department staff payroll charges to reflect actual hours worked. However, for the admin supporting staff did not use the same method due to the low percentage of the payroll charges to the grant. Housing Voucher Cluster We determined the City did not comply with federal requirements for direct payroll charges. Payroll costs for all five 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. In April 2023, the City has required all Housing Department staff to retrospectively fill out timesheets pertaining to actual hours worked on the program during fiscal year 2023, The City performed reconciliation on Housing Department staff payroll charges to reflect actual hours worked. However, for the admin supporting staff did not use the same method due to the low percentage of the payroll charges to the grant. Cause: The City did not follow its adopted policies and procedures for ensuring employees’ compensation charged to federal programs was supported by contemporaneous time record or an after-the-fact distribution of employees’ actual time and effort expended on federal program activities. The City’s attempt in addressing prior year finding was not deemed sufficient due to lack of reconciliation for actual hours worked for payroll charges from Administrative, Finance, and Other Departments. 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: Community Development Block Grants-Entitlement Grants Cluster $41,821 Housing Voucher Cluster $15,986 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 comply with federal regulation requiring that any employee funded by federal grant document the actual time they spend working on the grant’s objectives. Documentation must reflect “actual” time spent by employees on awards being charged. The City should develop and implement policies and procedures that ensure that employees’ compensation charged to federal programs reflect a contemporaneous or after-the-fact distribution of employees’ actual time and effort expended on federal programs. We also recommend the City enhance its internal controls over the payroll processes. Views of Responsible Officials: Management concurs the finding.
2023-003 – Allowable Costs/Cost Principles – Internal Control and Compliance over Allowable Costs/Cost Principles (Significant Deficiency) Identification of the Federal Program: Assistance Listing Number: 21.027 Assistance Listing Title: Coronavirus State and Local Fiscal Recovery Funds Federal Agency: Department of Treasury Pass-Through Entity: N/A Federal Award Number and Award Year: N/A Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): Pursuant to Code of Federal Regulation §200.403 Requirements for pass-through entities. Except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: (a) Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles. (b) Conform to any limitations or exclusions set forth in these principles or in the Federal award as to types or amount of cost items. (c) Be consistent with policies and procedures that apply uniformly to both federally-financed and other activities of the non-Federal entity. (d) Be accorded consistent treatment. A cost may not be assigned to a Federal award as a direct cost if any other cost incurred for the same purpose in like circumstances has been allocated to the Federal award as an indirect cost. (e) Be determined in accordance with generally accepted accounting principles (GAAP), except, for state and local governments and Indian tribes only, as otherwise provided for in this part. (f) Not be included as a cost or used to meet cost sharing or matching requirements of any other federally-financed program in either the current or a prior period. See also § 200.306(b). (g) Be adequately documented. See also §§ 200.300 through 200.309 of this part. (h) Cost must be incurred during the approved budget period. The Federal awarding agency is authorized, at its discretion, to waive prior written approvals to carry forward unobligated balances to subsequent budget periods pursuant to § 200.308(e)(3). Condition: During our audit, we noted that three (3) out of forty (40) samples summed up to $39,055.50 had no proper source documents to support the transactions charged to the grant brought by lost official receipts, hence, identified as not adequately documented. Alternatively, the City created a memo to document the loss of receipts signed by the department head. Cause: The City was not able to safeguard the documents substantiating the transactions being charged to the grant. Effect or Potential Effect: The City did not comply with the CFR’s requirements for allowable costs. There is an increased risk that the charges do not represent the actual costs incurred. Questioned Costs: Known questionable cost $39,056 and the estimated questionable cost is projected to be $69,269. Context: See condition above for context of the finding. Identification as a Repeat Finding, If Applicable: Not applicable. Recommendation: We recommended the City to strengthen safeguarding of source documents to properly substantiate the charges made to the grant. Views of Responsible Officials: Management concurs the finding.
2023-004 - Procurement, Suspension, and Debarment – Internal Control over Procurement and Verification Against the System for Award Management (“SAM”) (Significant Deficiency) Identification of the Federal Program: Assistance Listing Number: 14.218 Federal Program Name: Community Development Block Grants-Entitlement Grants Cluster Federal Agency: Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Number(s) and Award Year: B-21-MC-06-0554 Assistance Listing Number: 21.027 Assistance Listing Title: Coronavirus State and Local Fiscal Recovery Funds Federal Agency: Department of Treasury Pass-Through Entity: N/A Federal Award Number and Award Year: N/A Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): Suspension and Debarment, Non-Federal entities are prohibited from contracting with or making subawards under covered transactions to parties that are suspended or debarred. “Covered transactions” include those procurement contracts for goods and services awarded under a nonprocurement transaction (e.g., grant or cooperative agreement) that are expected to equal or exceed $25,000 or meet certain other criteria as specified in 2 CFR section 180.220. All nonprocurement transactions entered into by a recipient (i.e., subawards to subrecipients), irrespective of award amount, are considered covered transactions, unless they are exempt as provided in 2 CFR section 180.215. When a non-Federal entity enters into a covered transaction with an entity at a lower tier, the non-Federal entity must verify that the entity, as defined in 2 CFR section 180.995 and agency adopting regulations, is not suspended or debarred or otherwise excluded from participating in the transaction. This verification may be accomplished by (1) checking the System for Award Management (SAM) Exclusions maintained by the General Services Administration (GSA) and available at https://www.sam.gov/portal/public/SAM/ (Note: The OMB guidance at 2 CFR part 180 and agency implementing regulations still refer to the SAM Exclusions as the Excluded Parties List System (EPLS)), (2) collecting a certification from the entity, or (3) adding a clause or condition to the covered transaction with that entity (2 CFR section 180.300). In accordance with OMB Uniform Guidance, entities under the program, including subrecipients of a state, must follow the procurement standards in 2 CFR sections § 200.318 through § 200.327, including ensuring that the procurement method used for the contracts are appropriate based on the dollar amount and conditions specified in 2 CFR section 200.320. C.F.R. § 200.319 prescribes that all procurement transactions for the acquisition of property or services required under a Federal award must be conducted in a manner providing full and open competition consistent with the standards of this section and § 200.320. Further, the non-Federal entity must ensure that all prequalified lists of persons, firms, or products which are used in acquiring goods and services are current and include enough qualified sources to ensure maximum open and free competition. Also, the non-Federal entity must not preclude potential bidders from qualifying during the solicitation period. Condition: Community Development Block Grants-Entitlement Grants Cluster Based on the City’s formal purchasing policy, purchase orders are required to initiate purchases from procured vendors for transactions above $5,000. During our audit, we noted that seven (7) out of forty (40) samples did have purchase order approval made subsequent to invoice approval. The aforementioned circumstance suggests that the method of procurement was not in line with the City’s adopted policy established in line with the Uniform Guidance. Coronavirus State and Local Fiscal Recovery Funds We determined that seven (7) out of forty (40) samples did have purchase order approval made subsequent to invoice approval. The aforementioned circumstance suggests that the method of procurement was not in line with the City’s adopted policy established in line with the Uniform Guidance. During our audit, we also 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. Cause: The City did not follow its policies and process in place to check and ensure the suspension and debarment review process over vendors that provides goods or services to the City’s programs was conducted prior to enter into contract. The City implemented necessary procedures to address the finding discovered during the audit for the year ended June 30,2022 prospectively, however, due to the timing of the previous audit, the City was not able to address for the year ended June 30, 2023. Effect or Potential Effect: Without verifying whether vendors are suspended or debarred from working on federally-funded projects prior to the contract awarded, the City could be contracting with vendors that are prohibited from working on federally funded projects. Questioned Costs: None. Context: See condition above for context of the finding. Identification as a Repeat Finding, If Applicable: Yes. See prior year finding 2022-004. Recommendation: We recommended the City follow internal control policies and procedures to incorporate the suspension and debarment verification prior to awarding contracts. Views of Responsible Officials: Management concurs the finding.
2023-004 - Procurement, Suspension, and Debarment – Internal Control over Procurement and Verification Against the System for Award Management (“SAM”) (Significant Deficiency) Identification of the Federal Program: Assistance Listing Number: 14.218 Federal Program Name: Community Development Block Grants-Entitlement Grants Cluster Federal Agency: Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Number(s) and Award Year: B-21-MC-06-0554 Assistance Listing Number: 21.027 Assistance Listing Title: Coronavirus State and Local Fiscal Recovery Funds Federal Agency: Department of Treasury Pass-Through Entity: N/A Federal Award Number and Award Year: N/A Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): Suspension and Debarment, Non-Federal entities are prohibited from contracting with or making subawards under covered transactions to parties that are suspended or debarred. “Covered transactions” include those procurement contracts for goods and services awarded under a nonprocurement transaction (e.g., grant or cooperative agreement) that are expected to equal or exceed $25,000 or meet certain other criteria as specified in 2 CFR section 180.220. All nonprocurement transactions entered into by a recipient (i.e., subawards to subrecipients), irrespective of award amount, are considered covered transactions, unless they are exempt as provided in 2 CFR section 180.215. When a non-Federal entity enters into a covered transaction with an entity at a lower tier, the non-Federal entity must verify that the entity, as defined in 2 CFR section 180.995 and agency adopting regulations, is not suspended or debarred or otherwise excluded from participating in the transaction. This verification may be accomplished by (1) checking the System for Award Management (SAM) Exclusions maintained by the General Services Administration (GSA) and available at https://www.sam.gov/portal/public/SAM/ (Note: The OMB guidance at 2 CFR part 180 and agency implementing regulations still refer to the SAM Exclusions as the Excluded Parties List System (EPLS)), (2) collecting a certification from the entity, or (3) adding a clause or condition to the covered transaction with that entity (2 CFR section 180.300). In accordance with OMB Uniform Guidance, entities under the program, including subrecipients of a state, must follow the procurement standards in 2 CFR sections § 200.318 through § 200.327, including ensuring that the procurement method used for the contracts are appropriate based on the dollar amount and conditions specified in 2 CFR section 200.320. C.F.R. § 200.319 prescribes that all procurement transactions for the acquisition of property or services required under a Federal award must be conducted in a manner providing full and open competition consistent with the standards of this section and § 200.320. Further, the non-Federal entity must ensure that all prequalified lists of persons, firms, or products which are used in acquiring goods and services are current and include enough qualified sources to ensure maximum open and free competition. Also, the non-Federal entity must not preclude potential bidders from qualifying during the solicitation period. Condition: Community Development Block Grants-Entitlement Grants Cluster Based on the City’s formal purchasing policy, purchase orders are required to initiate purchases from procured vendors for transactions above $5,000. During our audit, we noted that seven (7) out of forty (40) samples did have purchase order approval made subsequent to invoice approval. The aforementioned circumstance suggests that the method of procurement was not in line with the City’s adopted policy established in line with the Uniform Guidance. Coronavirus State and Local Fiscal Recovery Funds We determined that seven (7) out of forty (40) samples did have purchase order approval made subsequent to invoice approval. The aforementioned circumstance suggests that the method of procurement was not in line with the City’s adopted policy established in line with the Uniform Guidance. During our audit, we also 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. Cause: The City did not follow its policies and process in place to check and ensure the suspension and debarment review process over vendors that provides goods or services to the City’s programs was conducted prior to enter into contract. The City implemented necessary procedures to address the finding discovered during the audit for the year ended June 30,2022 prospectively, however, due to the timing of the previous audit, the City was not able to address for the year ended June 30, 2023. Effect or Potential Effect: Without verifying whether vendors are suspended or debarred from working on federally-funded projects prior to the contract awarded, the City could be contracting with vendors that are prohibited from working on federally funded projects. Questioned Costs: None. Context: See condition above for context of the finding. Identification as a Repeat Finding, If Applicable: Yes. See prior year finding 2022-004. Recommendation: We recommended the City follow internal control policies and procedures to incorporate the suspension and debarment verification prior to awarding contracts. Views of Responsible Officials: Management concurs the finding.
2023-004 - Procurement, Suspension, and Debarment – Internal Control over Procurement and Verification Against the System for Award Management (“SAM”) (Significant Deficiency) Identification of the Federal Program: Assistance Listing Number: 14.218 Federal Program Name: Community Development Block Grants-Entitlement Grants Cluster Federal Agency: Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Number(s) and Award Year: B-21-MC-06-0554 Assistance Listing Number: 21.027 Assistance Listing Title: Coronavirus State and Local Fiscal Recovery Funds Federal Agency: Department of Treasury Pass-Through Entity: N/A Federal Award Number and Award Year: N/A Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): Suspension and Debarment, Non-Federal entities are prohibited from contracting with or making subawards under covered transactions to parties that are suspended or debarred. “Covered transactions” include those procurement contracts for goods and services awarded under a nonprocurement transaction (e.g., grant or cooperative agreement) that are expected to equal or exceed $25,000 or meet certain other criteria as specified in 2 CFR section 180.220. All nonprocurement transactions entered into by a recipient (i.e., subawards to subrecipients), irrespective of award amount, are considered covered transactions, unless they are exempt as provided in 2 CFR section 180.215. When a non-Federal entity enters into a covered transaction with an entity at a lower tier, the non-Federal entity must verify that the entity, as defined in 2 CFR section 180.995 and agency adopting regulations, is not suspended or debarred or otherwise excluded from participating in the transaction. This verification may be accomplished by (1) checking the System for Award Management (SAM) Exclusions maintained by the General Services Administration (GSA) and available at https://www.sam.gov/portal/public/SAM/ (Note: The OMB guidance at 2 CFR part 180 and agency implementing regulations still refer to the SAM Exclusions as the Excluded Parties List System (EPLS)), (2) collecting a certification from the entity, or (3) adding a clause or condition to the covered transaction with that entity (2 CFR section 180.300). In accordance with OMB Uniform Guidance, entities under the program, including subrecipients of a state, must follow the procurement standards in 2 CFR sections § 200.318 through § 200.327, including ensuring that the procurement method used for the contracts are appropriate based on the dollar amount and conditions specified in 2 CFR section 200.320. C.F.R. § 200.319 prescribes that all procurement transactions for the acquisition of property or services required under a Federal award must be conducted in a manner providing full and open competition consistent with the standards of this section and § 200.320. Further, the non-Federal entity must ensure that all prequalified lists of persons, firms, or products which are used in acquiring goods and services are current and include enough qualified sources to ensure maximum open and free competition. Also, the non-Federal entity must not preclude potential bidders from qualifying during the solicitation period. Condition: Community Development Block Grants-Entitlement Grants Cluster Based on the City’s formal purchasing policy, purchase orders are required to initiate purchases from procured vendors for transactions above $5,000. During our audit, we noted that seven (7) out of forty (40) samples did have purchase order approval made subsequent to invoice approval. The aforementioned circumstance suggests that the method of procurement was not in line with the City’s adopted policy established in line with the Uniform Guidance. Coronavirus State and Local Fiscal Recovery Funds We determined that seven (7) out of forty (40) samples did have purchase order approval made subsequent to invoice approval. The aforementioned circumstance suggests that the method of procurement was not in line with the City’s adopted policy established in line with the Uniform Guidance. During our audit, we also 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. Cause: The City did not follow its policies and process in place to check and ensure the suspension and debarment review process over vendors that provides goods or services to the City’s programs was conducted prior to enter into contract. The City implemented necessary procedures to address the finding discovered during the audit for the year ended June 30,2022 prospectively, however, due to the timing of the previous audit, the City was not able to address for the year ended June 30, 2023. Effect or Potential Effect: Without verifying whether vendors are suspended or debarred from working on federally-funded projects prior to the contract awarded, the City could be contracting with vendors that are prohibited from working on federally funded projects. Questioned Costs: None. Context: See condition above for context of the finding. Identification as a Repeat Finding, If Applicable: Yes. See prior year finding 2022-004. Recommendation: We recommended the City follow internal control policies and procedures to incorporate the suspension and debarment verification prior to awarding contracts. Views of Responsible Officials: Management concurs the finding.
2023-005 - Reporting – Internal Control and Compliance over Reporting (Material Weakness) Information of the Federal Program(s): Assistance Listing Number: 14.218 Federal Program Name: Community Development Block Grants-Entitlement Grants Cluster Federal Agency: Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Number(s) and Award Year: B-21-MC-06-0554 B-20-MW-06-0554 Assistance Listing Number: 14.871 Federal Program Name: Housing Voucher Cluster Federal Agency: Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Number(s) and Award Year: CA120 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): Community Development Block Grants-Entitlement Grants Cluster 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 the Guidance on Cash on Hand Quarterly Report (replaced the Federal Financial Report, SF-425) and financial reporting requirements in the cooperative agreement provisions, and 2 CFR 200.327: Quarterly reports: Program award recipients must submit Cash on Hand Quarterly Report 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 noted below: Reporting Period: Quarter 1: 7/1-9/30 Quarter 2: 10/1-12/31 Quarter 3: 1/1-3/31 Quarter 4: 4/1-6/30 Due Date of Report: October 30 January 30 April 30 July 30 Community Development Block Grants-Entitlement Grants Cluster (Continued) 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”). Housing Voucher Cluster Per 24 CFR § 5.801(d)(1) - Uniform financial reporting standards, unaudited financial statements will be required 60 days after the Public Housing Authority’s (“PHA”) fiscal year end, and audited financial statements will then be required no later than 9 months after the PHA's fiscal year end, in accordance with the Single Audit Act and 2 CFR part 200, subpart F. The PHA is required to submit the HUD-52681-B, Voucher for Payment of Annual Contributions and Operating Statement form monthly to HUD electronically via the Voucher Management System (VMS). Congress has instructed HUD to use VMS data to determine renewal funding levels. HUD also uses VMS data for other funding, monitoring, and SEMAP- related decisions. Condition: 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 all of the four (4) reporting periods were submitted on February 26, 2024. The City did not submit any of the four (4) quarterly Section 15011 Reports for the year ended June 30, 2023. 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. The unaudited Financial Data Schedule (FDS) for the fiscal year ended June 30, 2023 was not submitted on or before the August 31, 2023 due date. Housing Voucher Cluster (Continued) We also noted for 2 out of 4 VMS reports tested, there was no evidence of review and approval prior to submission to HUD. A nonstatistical sample of 4 out of 12 VMS reports were selected for test work. Cause: Community Development Block Grants-Entitlement Grants Cluster There was a change in personnel monitoring the compliance requirements for CDBG reporting, and there was no proper task delegation and turnover made upon separation of the previously assigned staff. Hence, the staff assuming the post was unable to meet the due date to ensure filing the Cash on Hand quarterly reports timely, and also was not aware of the Section 15011 CARES reporting. Housing Voucher Cluster Due to the effects of COVID-19 and staff turnover, the program’s procedures did not consistently ensure that the reports were submitted timely in accordance with the timelines in the Uniform Guidance, or properly reviewed and approved prior to submission. The City has implemented internal controls designed to review the VMS report prior to submission, effective starting in March 2023, in an effort to address the finding noted during the audit for the year ended June 30, 2022. Due to the timing of implementation, any VMS report prior to March 2023 do not have any evidence of approval before submission. Effect or Potential Effect: Community Development Block Grants-Entitlement Grants Cluster Delay in filing and not filing the reports resulted in noncompliance with the compliance requirements. Housing Voucher Cluster Failure to submit the audited FDS timely results in noncompliance with the compliance requirements. Failure to review the VMS reports prior to submittal 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: Yes. See prior year finding 2022-005. Recommendation: We recommend that the City strengthen their report submission process and procedures to ensure all required reports are properly reviewed and approved and submitted timely. 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 the finding.
2023-005 - Reporting – Internal Control and Compliance over Reporting (Material Weakness) Information of the Federal Program(s): Assistance Listing Number: 14.218 Federal Program Name: Community Development Block Grants-Entitlement Grants Cluster Federal Agency: Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Number(s) and Award Year: B-21-MC-06-0554 B-20-MW-06-0554 Assistance Listing Number: 14.871 Federal Program Name: Housing Voucher Cluster Federal Agency: Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Number(s) and Award Year: CA120 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): Community Development Block Grants-Entitlement Grants Cluster 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 the Guidance on Cash on Hand Quarterly Report (replaced the Federal Financial Report, SF-425) and financial reporting requirements in the cooperative agreement provisions, and 2 CFR 200.327: Quarterly reports: Program award recipients must submit Cash on Hand Quarterly Report 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 noted below: Reporting Period: Quarter 1: 7/1-9/30 Quarter 2: 10/1-12/31 Quarter 3: 1/1-3/31 Quarter 4: 4/1-6/30 Due Date of Report: October 30 January 30 April 30 July 30 Community Development Block Grants-Entitlement Grants Cluster (Continued) 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”). Housing Voucher Cluster Per 24 CFR § 5.801(d)(1) - Uniform financial reporting standards, unaudited financial statements will be required 60 days after the Public Housing Authority’s (“PHA”) fiscal year end, and audited financial statements will then be required no later than 9 months after the PHA's fiscal year end, in accordance with the Single Audit Act and 2 CFR part 200, subpart F. The PHA is required to submit the HUD-52681-B, Voucher for Payment of Annual Contributions and Operating Statement form monthly to HUD electronically via the Voucher Management System (VMS). Congress has instructed HUD to use VMS data to determine renewal funding levels. HUD also uses VMS data for other funding, monitoring, and SEMAP- related decisions. Condition: 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 all of the four (4) reporting periods were submitted on February 26, 2024. The City did not submit any of the four (4) quarterly Section 15011 Reports for the year ended June 30, 2023. 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. The unaudited Financial Data Schedule (FDS) for the fiscal year ended June 30, 2023 was not submitted on or before the August 31, 2023 due date. Housing Voucher Cluster (Continued) We also noted for 2 out of 4 VMS reports tested, there was no evidence of review and approval prior to submission to HUD. A nonstatistical sample of 4 out of 12 VMS reports were selected for test work. Cause: Community Development Block Grants-Entitlement Grants Cluster There was a change in personnel monitoring the compliance requirements for CDBG reporting, and there was no proper task delegation and turnover made upon separation of the previously assigned staff. Hence, the staff assuming the post was unable to meet the due date to ensure filing the Cash on Hand quarterly reports timely, and also was not aware of the Section 15011 CARES reporting. Housing Voucher Cluster Due to the effects of COVID-19 and staff turnover, the program’s procedures did not consistently ensure that the reports were submitted timely in accordance with the timelines in the Uniform Guidance, or properly reviewed and approved prior to submission. The City has implemented internal controls designed to review the VMS report prior to submission, effective starting in March 2023, in an effort to address the finding noted during the audit for the year ended June 30, 2022. Due to the timing of implementation, any VMS report prior to March 2023 do not have any evidence of approval before submission. Effect or Potential Effect: Community Development Block Grants-Entitlement Grants Cluster Delay in filing and not filing the reports resulted in noncompliance with the compliance requirements. Housing Voucher Cluster Failure to submit the audited FDS timely results in noncompliance with the compliance requirements. Failure to review the VMS reports prior to submittal 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: Yes. See prior year finding 2022-005. Recommendation: We recommend that the City strengthen their report submission process and procedures to ensure all required reports are properly reviewed and approved and submitted timely. 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 the finding.
2023-005 - Reporting – Internal Control and Compliance over Reporting (Material Weakness) Information of the Federal Program(s): Assistance Listing Number: 14.218 Federal Program Name: Community Development Block Grants-Entitlement Grants Cluster Federal Agency: Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Number(s) and Award Year: B-21-MC-06-0554 B-20-MW-06-0554 Assistance Listing Number: 14.871 Federal Program Name: Housing Voucher Cluster Federal Agency: Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Number(s) and Award Year: CA120 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): Community Development Block Grants-Entitlement Grants Cluster 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 the Guidance on Cash on Hand Quarterly Report (replaced the Federal Financial Report, SF-425) and financial reporting requirements in the cooperative agreement provisions, and 2 CFR 200.327: Quarterly reports: Program award recipients must submit Cash on Hand Quarterly Report 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 noted below: Reporting Period: Quarter 1: 7/1-9/30 Quarter 2: 10/1-12/31 Quarter 3: 1/1-3/31 Quarter 4: 4/1-6/30 Due Date of Report: October 30 January 30 April 30 July 30 Community Development Block Grants-Entitlement Grants Cluster (Continued) 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”). Housing Voucher Cluster Per 24 CFR § 5.801(d)(1) - Uniform financial reporting standards, unaudited financial statements will be required 60 days after the Public Housing Authority’s (“PHA”) fiscal year end, and audited financial statements will then be required no later than 9 months after the PHA's fiscal year end, in accordance with the Single Audit Act and 2 CFR part 200, subpart F. The PHA is required to submit the HUD-52681-B, Voucher for Payment of Annual Contributions and Operating Statement form monthly to HUD electronically via the Voucher Management System (VMS). Congress has instructed HUD to use VMS data to determine renewal funding levels. HUD also uses VMS data for other funding, monitoring, and SEMAP- related decisions. Condition: 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 all of the four (4) reporting periods were submitted on February 26, 2024. The City did not submit any of the four (4) quarterly Section 15011 Reports for the year ended June 30, 2023. 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. The unaudited Financial Data Schedule (FDS) for the fiscal year ended June 30, 2023 was not submitted on or before the August 31, 2023 due date. Housing Voucher Cluster (Continued) We also noted for 2 out of 4 VMS reports tested, there was no evidence of review and approval prior to submission to HUD. A nonstatistical sample of 4 out of 12 VMS reports were selected for test work. Cause: Community Development Block Grants-Entitlement Grants Cluster There was a change in personnel monitoring the compliance requirements for CDBG reporting, and there was no proper task delegation and turnover made upon separation of the previously assigned staff. Hence, the staff assuming the post was unable to meet the due date to ensure filing the Cash on Hand quarterly reports timely, and also was not aware of the Section 15011 CARES reporting. Housing Voucher Cluster Due to the effects of COVID-19 and staff turnover, the program’s procedures did not consistently ensure that the reports were submitted timely in accordance with the timelines in the Uniform Guidance, or properly reviewed and approved prior to submission. The City has implemented internal controls designed to review the VMS report prior to submission, effective starting in March 2023, in an effort to address the finding noted during the audit for the year ended June 30, 2022. Due to the timing of implementation, any VMS report prior to March 2023 do not have any evidence of approval before submission. Effect or Potential Effect: Community Development Block Grants-Entitlement Grants Cluster Delay in filing and not filing the reports resulted in noncompliance with the compliance requirements. Housing Voucher Cluster Failure to submit the audited FDS timely results in noncompliance with the compliance requirements. Failure to review the VMS reports prior to submittal 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: Yes. See prior year finding 2022-005. Recommendation: We recommend that the City strengthen their report submission process and procedures to ensure all required reports are properly reviewed and approved and submitted timely. 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 the finding.
2023-005 - Reporting – Internal Control and Compliance over Reporting (Material Weakness) Information of the Federal Program(s): Assistance Listing Number: 14.218 Federal Program Name: Community Development Block Grants-Entitlement Grants Cluster Federal Agency: Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Number(s) and Award Year: B-21-MC-06-0554 B-20-MW-06-0554 Assistance Listing Number: 14.871 Federal Program Name: Housing Voucher Cluster Federal Agency: Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Number(s) and Award Year: CA120 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): Community Development Block Grants-Entitlement Grants Cluster 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 the Guidance on Cash on Hand Quarterly Report (replaced the Federal Financial Report, SF-425) and financial reporting requirements in the cooperative agreement provisions, and 2 CFR 200.327: Quarterly reports: Program award recipients must submit Cash on Hand Quarterly Report 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 noted below: Reporting Period: Quarter 1: 7/1-9/30 Quarter 2: 10/1-12/31 Quarter 3: 1/1-3/31 Quarter 4: 4/1-6/30 Due Date of Report: October 30 January 30 April 30 July 30 Community Development Block Grants-Entitlement Grants Cluster (Continued) 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”). Housing Voucher Cluster Per 24 CFR § 5.801(d)(1) - Uniform financial reporting standards, unaudited financial statements will be required 60 days after the Public Housing Authority’s (“PHA”) fiscal year end, and audited financial statements will then be required no later than 9 months after the PHA's fiscal year end, in accordance with the Single Audit Act and 2 CFR part 200, subpart F. The PHA is required to submit the HUD-52681-B, Voucher for Payment of Annual Contributions and Operating Statement form monthly to HUD electronically via the Voucher Management System (VMS). Congress has instructed HUD to use VMS data to determine renewal funding levels. HUD also uses VMS data for other funding, monitoring, and SEMAP- related decisions. Condition: 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 all of the four (4) reporting periods were submitted on February 26, 2024. The City did not submit any of the four (4) quarterly Section 15011 Reports for the year ended June 30, 2023. 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. The unaudited Financial Data Schedule (FDS) for the fiscal year ended June 30, 2023 was not submitted on or before the August 31, 2023 due date. Housing Voucher Cluster (Continued) We also noted for 2 out of 4 VMS reports tested, there was no evidence of review and approval prior to submission to HUD. A nonstatistical sample of 4 out of 12 VMS reports were selected for test work. Cause: Community Development Block Grants-Entitlement Grants Cluster There was a change in personnel monitoring the compliance requirements for CDBG reporting, and there was no proper task delegation and turnover made upon separation of the previously assigned staff. Hence, the staff assuming the post was unable to meet the due date to ensure filing the Cash on Hand quarterly reports timely, and also was not aware of the Section 15011 CARES reporting. Housing Voucher Cluster Due to the effects of COVID-19 and staff turnover, the program’s procedures did not consistently ensure that the reports were submitted timely in accordance with the timelines in the Uniform Guidance, or properly reviewed and approved prior to submission. The City has implemented internal controls designed to review the VMS report prior to submission, effective starting in March 2023, in an effort to address the finding noted during the audit for the year ended June 30, 2022. Due to the timing of implementation, any VMS report prior to March 2023 do not have any evidence of approval before submission. Effect or Potential Effect: Community Development Block Grants-Entitlement Grants Cluster Delay in filing and not filing the reports resulted in noncompliance with the compliance requirements. Housing Voucher Cluster Failure to submit the audited FDS timely results in noncompliance with the compliance requirements. Failure to review the VMS reports prior to submittal 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: Yes. See prior year finding 2022-005. Recommendation: We recommend that the City strengthen their report submission process and procedures to ensure all required reports are properly reviewed and approved and submitted timely. 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 the finding.
2023-006 – Subrecipient Monitoring – Internal Control and Compliance over Subrecipient Monitoring (Significant Deficiency) Identification of the Federal Program: Assistance Listing Number: 21.027 Assistance Listing Title: Coronavirus State and Local Fiscal Recovery Funds Federal Agency: Department of Treasury Pass-Through Entity: N/A Federal Award Number and Award Year: N/A Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): C.F.R. § 200.332 prescribes that the pass-through entity must conduct monitoring activities of the subrecipient as necessary to ensure that the subaward is used for authorized purposes, in compliance with Federal statutes, regulations, and the terms and conditions of the subaward; and that subaward performance goals are achieved. Pass-through entity monitoring of the subrecipient must include: 1. Reviewing financial and performance reports required by the pass-through entity. 2. Following-up and ensuring that the subrecipient takes timely and appropriate action on all deficiencies pertaining to the Federal award provided to the subrecipient from the pass-through entity detected through audits, on-site reviews, and written confirmation from the subrecipient, highlighting the status of actions planned or taken to address Single Audit findings related to the particular subaward. 3. Issuing a management decision for applicable audit findings pertaining only to the Federal award provided to the subrecipient from the pass-through entity as required by § 200.521. 4. The pass-through entity is responsible for resolving audit findings specifically related to the subaward and not responsible for resolving crosscutting findings. Condition: During our audit, we noted that the City did not have established monitoring policies and procedures for its subrecipients to address the compliance requirements. Consequently, no subrecipient monitoring activities were conducted during the year. Cause: The City does not have any written policy and sufficient procedures for subrecipient monitoring activities tailored to address the subrecipient monitoring compliance requirements of the grant. Effect or Potential Effect: The City was not able to do the necessary subrecipient monitoring activities resulted to internal control and compliance requirement finding. Questioned Costs: None. Context: See condition above for context of the finding. Identification as a Repeat Finding, If Applicable: Not applicable. Recommendation: We recommended the City establish a formal policy over review procedures on subrecipient monitoring to ensure the City is in compliance the grant requirement. Views of Responsible Officials: Management concurs the finding.
2023-007 - Special Tests – Internal Control and Compliance over Housing Quality Standards Inspections (Material Weakness) Information on the Federal Program: Assistance Listing Number: 14.871 Federal Program Name: Housing Voucher Cluster Federal Agency: Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Number and Award Year: CA120 – FY22-23 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): 24 CFR 982.405(b) states that the Public PHA (PHA) must inspect the unit leased to a family prior to the initial term of the lease, at least biennially during assisted occupancy, and at other times as needed, to determine if the unit meets Housing Quality Standards (HQS). Condition: We found five (5) instances out of 9 in which the City did not conduct the HQS failed inspection follow up in a timely manner. We also noted three (3) instances out of 40 samples for eligibility testing has HQS inspections that are over a year apart, which shows that the City did not conduct the HQS biennial inspection in a timely manner. Cause: The City currently has no policies or procedures in place to ensure that Housing Quality Standard Inspections are performed timely. Effect or Potential Effect: The City has not complied with the requirements of 24 CFR 982.405(b) – Housing Quality Standards Inspections. Questioned Costs: None. Context: See condition above for the context of the finding. Repeat Finding from Prior Year(s): Yes. See prior year finding 2022-006. Recommendation: We recommend that the City implement procedures to ensure that Housing Quality Standard Inspections are performed timely. Views of Responsible Officials: Management concurs the finding.
2023-007 - Special Tests – Internal Control and Compliance over Housing Quality Standards Inspections (Material Weakness) Information on the Federal Program: Assistance Listing Number: 14.871 Federal Program Name: Housing Voucher Cluster Federal Agency: Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Number and Award Year: CA120 – FY22-23 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): 24 CFR 982.405(b) states that the Public PHA (PHA) must inspect the unit leased to a family prior to the initial term of the lease, at least biennially during assisted occupancy, and at other times as needed, to determine if the unit meets Housing Quality Standards (HQS). Condition: We found five (5) instances out of 9 in which the City did not conduct the HQS failed inspection follow up in a timely manner. We also noted three (3) instances out of 40 samples for eligibility testing has HQS inspections that are over a year apart, which shows that the City did not conduct the HQS biennial inspection in a timely manner. Cause: The City currently has no policies or procedures in place to ensure that Housing Quality Standard Inspections are performed timely. Effect or Potential Effect: The City has not complied with the requirements of 24 CFR 982.405(b) – Housing Quality Standards Inspections. Questioned Costs: None. Context: See condition above for the context of the finding. Repeat Finding from Prior Year(s): Yes. See prior year finding 2022-006. Recommendation: We recommend that the City implement procedures to ensure that Housing Quality Standard Inspections are performed timely. Views of Responsible Officials: Management concurs the finding.
2023-002 - Allowable Costs/Cost Principles – Internal Control and Compliance over Payroll Expenditures (Significant Deficiency) Information on the Federal Program(s): Assistance Listing Number: 14.218 Federal Program Name: Community Development Block Grants-Entitlement Grants Cluster Federal Agency: Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Number(s) and Award Year: B-21-MC-06-0554 B-20-MW-06-0554 Assistance Listing Number: 14.871 Federal Program Name: Housing Voucher Cluster Federal Agency: Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Number(s) and Award Year: CA120 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: 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. In April 2023, the City has required all Housing Department staff to retrospectively fill out timesheets pertaining to actual hours worked on the program during fiscal year 2023, The City performed reconciliation on Housing Department staff payroll charges to reflect actual hours worked. However, for the admin supporting staff did not use the same method due to the low percentage of the payroll charges to the grant. Housing Voucher Cluster We determined the City did not comply with federal requirements for direct payroll charges. Payroll costs for all five 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. In April 2023, the City has required all Housing Department staff to retrospectively fill out timesheets pertaining to actual hours worked on the program during fiscal year 2023, The City performed reconciliation on Housing Department staff payroll charges to reflect actual hours worked. However, for the admin supporting staff did not use the same method due to the low percentage of the payroll charges to the grant. Cause: The City did not follow its adopted policies and procedures for ensuring employees’ compensation charged to federal programs was supported by contemporaneous time record or an after-the-fact distribution of employees’ actual time and effort expended on federal program activities. The City’s attempt in addressing prior year finding was not deemed sufficient due to lack of reconciliation for actual hours worked for payroll charges from Administrative, Finance, and Other Departments. 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: Community Development Block Grants-Entitlement Grants Cluster $41,821 Housing Voucher Cluster $15,986 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 comply with federal regulation requiring that any employee funded by federal grant document the actual time they spend working on the grant’s objectives. Documentation must reflect “actual” time spent by employees on awards being charged. The City should develop and implement policies and procedures that ensure that employees’ compensation charged to federal programs reflect a contemporaneous or after-the-fact distribution of employees’ actual time and effort expended on federal programs. We also recommend the City enhance its internal controls over the payroll processes. Views of Responsible Officials: Management concurs the finding.
2023-002 - Allowable Costs/Cost Principles – Internal Control and Compliance over Payroll Expenditures (Significant Deficiency) Information on the Federal Program(s): Assistance Listing Number: 14.218 Federal Program Name: Community Development Block Grants-Entitlement Grants Cluster Federal Agency: Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Number(s) and Award Year: B-21-MC-06-0554 B-20-MW-06-0554 Assistance Listing Number: 14.871 Federal Program Name: Housing Voucher Cluster Federal Agency: Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Number(s) and Award Year: CA120 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: 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. In April 2023, the City has required all Housing Department staff to retrospectively fill out timesheets pertaining to actual hours worked on the program during fiscal year 2023, The City performed reconciliation on Housing Department staff payroll charges to reflect actual hours worked. However, for the admin supporting staff did not use the same method due to the low percentage of the payroll charges to the grant. Housing Voucher Cluster We determined the City did not comply with federal requirements for direct payroll charges. Payroll costs for all five 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. In April 2023, the City has required all Housing Department staff to retrospectively fill out timesheets pertaining to actual hours worked on the program during fiscal year 2023, The City performed reconciliation on Housing Department staff payroll charges to reflect actual hours worked. However, for the admin supporting staff did not use the same method due to the low percentage of the payroll charges to the grant. Cause: The City did not follow its adopted policies and procedures for ensuring employees’ compensation charged to federal programs was supported by contemporaneous time record or an after-the-fact distribution of employees’ actual time and effort expended on federal program activities. The City’s attempt in addressing prior year finding was not deemed sufficient due to lack of reconciliation for actual hours worked for payroll charges from Administrative, Finance, and Other Departments. 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: Community Development Block Grants-Entitlement Grants Cluster $41,821 Housing Voucher Cluster $15,986 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 comply with federal regulation requiring that any employee funded by federal grant document the actual time they spend working on the grant’s objectives. Documentation must reflect “actual” time spent by employees on awards being charged. The City should develop and implement policies and procedures that ensure that employees’ compensation charged to federal programs reflect a contemporaneous or after-the-fact distribution of employees’ actual time and effort expended on federal programs. We also recommend the City enhance its internal controls over the payroll processes. Views of Responsible Officials: Management concurs the finding.
2023-002 - Allowable Costs/Cost Principles – Internal Control and Compliance over Payroll Expenditures (Significant Deficiency) Information on the Federal Program(s): Assistance Listing Number: 14.218 Federal Program Name: Community Development Block Grants-Entitlement Grants Cluster Federal Agency: Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Number(s) and Award Year: B-21-MC-06-0554 B-20-MW-06-0554 Assistance Listing Number: 14.871 Federal Program Name: Housing Voucher Cluster Federal Agency: Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Number(s) and Award Year: CA120 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: 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. In April 2023, the City has required all Housing Department staff to retrospectively fill out timesheets pertaining to actual hours worked on the program during fiscal year 2023, The City performed reconciliation on Housing Department staff payroll charges to reflect actual hours worked. However, for the admin supporting staff did not use the same method due to the low percentage of the payroll charges to the grant. Housing Voucher Cluster We determined the City did not comply with federal requirements for direct payroll charges. Payroll costs for all five 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. In April 2023, the City has required all Housing Department staff to retrospectively fill out timesheets pertaining to actual hours worked on the program during fiscal year 2023, The City performed reconciliation on Housing Department staff payroll charges to reflect actual hours worked. However, for the admin supporting staff did not use the same method due to the low percentage of the payroll charges to the grant. Cause: The City did not follow its adopted policies and procedures for ensuring employees’ compensation charged to federal programs was supported by contemporaneous time record or an after-the-fact distribution of employees’ actual time and effort expended on federal program activities. The City’s attempt in addressing prior year finding was not deemed sufficient due to lack of reconciliation for actual hours worked for payroll charges from Administrative, Finance, and Other Departments. 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: Community Development Block Grants-Entitlement Grants Cluster $41,821 Housing Voucher Cluster $15,986 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 comply with federal regulation requiring that any employee funded by federal grant document the actual time they spend working on the grant’s objectives. Documentation must reflect “actual” time spent by employees on awards being charged. The City should develop and implement policies and procedures that ensure that employees’ compensation charged to federal programs reflect a contemporaneous or after-the-fact distribution of employees’ actual time and effort expended on federal programs. We also recommend the City enhance its internal controls over the payroll processes. Views of Responsible Officials: Management concurs the finding.
2023-002 - Allowable Costs/Cost Principles – Internal Control and Compliance over Payroll Expenditures (Significant Deficiency) Information on the Federal Program(s): Assistance Listing Number: 14.218 Federal Program Name: Community Development Block Grants-Entitlement Grants Cluster Federal Agency: Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Number(s) and Award Year: B-21-MC-06-0554 B-20-MW-06-0554 Assistance Listing Number: 14.871 Federal Program Name: Housing Voucher Cluster Federal Agency: Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Number(s) and Award Year: CA120 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: 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. In April 2023, the City has required all Housing Department staff to retrospectively fill out timesheets pertaining to actual hours worked on the program during fiscal year 2023, The City performed reconciliation on Housing Department staff payroll charges to reflect actual hours worked. However, for the admin supporting staff did not use the same method due to the low percentage of the payroll charges to the grant. Housing Voucher Cluster We determined the City did not comply with federal requirements for direct payroll charges. Payroll costs for all five 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. In April 2023, the City has required all Housing Department staff to retrospectively fill out timesheets pertaining to actual hours worked on the program during fiscal year 2023, The City performed reconciliation on Housing Department staff payroll charges to reflect actual hours worked. However, for the admin supporting staff did not use the same method due to the low percentage of the payroll charges to the grant. Cause: The City did not follow its adopted policies and procedures for ensuring employees’ compensation charged to federal programs was supported by contemporaneous time record or an after-the-fact distribution of employees’ actual time and effort expended on federal program activities. The City’s attempt in addressing prior year finding was not deemed sufficient due to lack of reconciliation for actual hours worked for payroll charges from Administrative, Finance, and Other Departments. 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: Community Development Block Grants-Entitlement Grants Cluster $41,821 Housing Voucher Cluster $15,986 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 comply with federal regulation requiring that any employee funded by federal grant document the actual time they spend working on the grant’s objectives. Documentation must reflect “actual” time spent by employees on awards being charged. The City should develop and implement policies and procedures that ensure that employees’ compensation charged to federal programs reflect a contemporaneous or after-the-fact distribution of employees’ actual time and effort expended on federal programs. We also recommend the City enhance its internal controls over the payroll processes. Views of Responsible Officials: Management concurs the finding.
2023-003 – Allowable Costs/Cost Principles – Internal Control and Compliance over Allowable Costs/Cost Principles (Significant Deficiency) Identification of the Federal Program: Assistance Listing Number: 21.027 Assistance Listing Title: Coronavirus State and Local Fiscal Recovery Funds Federal Agency: Department of Treasury Pass-Through Entity: N/A Federal Award Number and Award Year: N/A Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): Pursuant to Code of Federal Regulation §200.403 Requirements for pass-through entities. Except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: (a) Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles. (b) Conform to any limitations or exclusions set forth in these principles or in the Federal award as to types or amount of cost items. (c) Be consistent with policies and procedures that apply uniformly to both federally-financed and other activities of the non-Federal entity. (d) Be accorded consistent treatment. A cost may not be assigned to a Federal award as a direct cost if any other cost incurred for the same purpose in like circumstances has been allocated to the Federal award as an indirect cost. (e) Be determined in accordance with generally accepted accounting principles (GAAP), except, for state and local governments and Indian tribes only, as otherwise provided for in this part. (f) Not be included as a cost or used to meet cost sharing or matching requirements of any other federally-financed program in either the current or a prior period. See also § 200.306(b). (g) Be adequately documented. See also §§ 200.300 through 200.309 of this part. (h) Cost must be incurred during the approved budget period. The Federal awarding agency is authorized, at its discretion, to waive prior written approvals to carry forward unobligated balances to subsequent budget periods pursuant to § 200.308(e)(3). Condition: During our audit, we noted that three (3) out of forty (40) samples summed up to $39,055.50 had no proper source documents to support the transactions charged to the grant brought by lost official receipts, hence, identified as not adequately documented. Alternatively, the City created a memo to document the loss of receipts signed by the department head. Cause: The City was not able to safeguard the documents substantiating the transactions being charged to the grant. Effect or Potential Effect: The City did not comply with the CFR’s requirements for allowable costs. There is an increased risk that the charges do not represent the actual costs incurred. Questioned Costs: Known questionable cost $39,056 and the estimated questionable cost is projected to be $69,269. Context: See condition above for context of the finding. Identification as a Repeat Finding, If Applicable: Not applicable. Recommendation: We recommended the City to strengthen safeguarding of source documents to properly substantiate the charges made to the grant. Views of Responsible Officials: Management concurs the finding.
2023-004 - Procurement, Suspension, and Debarment – Internal Control over Procurement and Verification Against the System for Award Management (“SAM”) (Significant Deficiency) Identification of the Federal Program: Assistance Listing Number: 14.218 Federal Program Name: Community Development Block Grants-Entitlement Grants Cluster Federal Agency: Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Number(s) and Award Year: B-21-MC-06-0554 Assistance Listing Number: 21.027 Assistance Listing Title: Coronavirus State and Local Fiscal Recovery Funds Federal Agency: Department of Treasury Pass-Through Entity: N/A Federal Award Number and Award Year: N/A Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): Suspension and Debarment, Non-Federal entities are prohibited from contracting with or making subawards under covered transactions to parties that are suspended or debarred. “Covered transactions” include those procurement contracts for goods and services awarded under a nonprocurement transaction (e.g., grant or cooperative agreement) that are expected to equal or exceed $25,000 or meet certain other criteria as specified in 2 CFR section 180.220. All nonprocurement transactions entered into by a recipient (i.e., subawards to subrecipients), irrespective of award amount, are considered covered transactions, unless they are exempt as provided in 2 CFR section 180.215. When a non-Federal entity enters into a covered transaction with an entity at a lower tier, the non-Federal entity must verify that the entity, as defined in 2 CFR section 180.995 and agency adopting regulations, is not suspended or debarred or otherwise excluded from participating in the transaction. This verification may be accomplished by (1) checking the System for Award Management (SAM) Exclusions maintained by the General Services Administration (GSA) and available at https://www.sam.gov/portal/public/SAM/ (Note: The OMB guidance at 2 CFR part 180 and agency implementing regulations still refer to the SAM Exclusions as the Excluded Parties List System (EPLS)), (2) collecting a certification from the entity, or (3) adding a clause or condition to the covered transaction with that entity (2 CFR section 180.300). In accordance with OMB Uniform Guidance, entities under the program, including subrecipients of a state, must follow the procurement standards in 2 CFR sections § 200.318 through § 200.327, including ensuring that the procurement method used for the contracts are appropriate based on the dollar amount and conditions specified in 2 CFR section 200.320. C.F.R. § 200.319 prescribes that all procurement transactions for the acquisition of property or services required under a Federal award must be conducted in a manner providing full and open competition consistent with the standards of this section and § 200.320. Further, the non-Federal entity must ensure that all prequalified lists of persons, firms, or products which are used in acquiring goods and services are current and include enough qualified sources to ensure maximum open and free competition. Also, the non-Federal entity must not preclude potential bidders from qualifying during the solicitation period. Condition: Community Development Block Grants-Entitlement Grants Cluster Based on the City’s formal purchasing policy, purchase orders are required to initiate purchases from procured vendors for transactions above $5,000. During our audit, we noted that seven (7) out of forty (40) samples did have purchase order approval made subsequent to invoice approval. The aforementioned circumstance suggests that the method of procurement was not in line with the City’s adopted policy established in line with the Uniform Guidance. Coronavirus State and Local Fiscal Recovery Funds We determined that seven (7) out of forty (40) samples did have purchase order approval made subsequent to invoice approval. The aforementioned circumstance suggests that the method of procurement was not in line with the City’s adopted policy established in line with the Uniform Guidance. During our audit, we also 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. Cause: The City did not follow its policies and process in place to check and ensure the suspension and debarment review process over vendors that provides goods or services to the City’s programs was conducted prior to enter into contract. The City implemented necessary procedures to address the finding discovered during the audit for the year ended June 30,2022 prospectively, however, due to the timing of the previous audit, the City was not able to address for the year ended June 30, 2023. Effect or Potential Effect: Without verifying whether vendors are suspended or debarred from working on federally-funded projects prior to the contract awarded, the City could be contracting with vendors that are prohibited from working on federally funded projects. Questioned Costs: None. Context: See condition above for context of the finding. Identification as a Repeat Finding, If Applicable: Yes. See prior year finding 2022-004. Recommendation: We recommended the City follow internal control policies and procedures to incorporate the suspension and debarment verification prior to awarding contracts. Views of Responsible Officials: Management concurs the finding.
2023-004 - Procurement, Suspension, and Debarment – Internal Control over Procurement and Verification Against the System for Award Management (“SAM”) (Significant Deficiency) Identification of the Federal Program: Assistance Listing Number: 14.218 Federal Program Name: Community Development Block Grants-Entitlement Grants Cluster Federal Agency: Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Number(s) and Award Year: B-21-MC-06-0554 Assistance Listing Number: 21.027 Assistance Listing Title: Coronavirus State and Local Fiscal Recovery Funds Federal Agency: Department of Treasury Pass-Through Entity: N/A Federal Award Number and Award Year: N/A Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): Suspension and Debarment, Non-Federal entities are prohibited from contracting with or making subawards under covered transactions to parties that are suspended or debarred. “Covered transactions” include those procurement contracts for goods and services awarded under a nonprocurement transaction (e.g., grant or cooperative agreement) that are expected to equal or exceed $25,000 or meet certain other criteria as specified in 2 CFR section 180.220. All nonprocurement transactions entered into by a recipient (i.e., subawards to subrecipients), irrespective of award amount, are considered covered transactions, unless they are exempt as provided in 2 CFR section 180.215. When a non-Federal entity enters into a covered transaction with an entity at a lower tier, the non-Federal entity must verify that the entity, as defined in 2 CFR section 180.995 and agency adopting regulations, is not suspended or debarred or otherwise excluded from participating in the transaction. This verification may be accomplished by (1) checking the System for Award Management (SAM) Exclusions maintained by the General Services Administration (GSA) and available at https://www.sam.gov/portal/public/SAM/ (Note: The OMB guidance at 2 CFR part 180 and agency implementing regulations still refer to the SAM Exclusions as the Excluded Parties List System (EPLS)), (2) collecting a certification from the entity, or (3) adding a clause or condition to the covered transaction with that entity (2 CFR section 180.300). In accordance with OMB Uniform Guidance, entities under the program, including subrecipients of a state, must follow the procurement standards in 2 CFR sections § 200.318 through § 200.327, including ensuring that the procurement method used for the contracts are appropriate based on the dollar amount and conditions specified in 2 CFR section 200.320. C.F.R. § 200.319 prescribes that all procurement transactions for the acquisition of property or services required under a Federal award must be conducted in a manner providing full and open competition consistent with the standards of this section and § 200.320. Further, the non-Federal entity must ensure that all prequalified lists of persons, firms, or products which are used in acquiring goods and services are current and include enough qualified sources to ensure maximum open and free competition. Also, the non-Federal entity must not preclude potential bidders from qualifying during the solicitation period. Condition: Community Development Block Grants-Entitlement Grants Cluster Based on the City’s formal purchasing policy, purchase orders are required to initiate purchases from procured vendors for transactions above $5,000. During our audit, we noted that seven (7) out of forty (40) samples did have purchase order approval made subsequent to invoice approval. The aforementioned circumstance suggests that the method of procurement was not in line with the City’s adopted policy established in line with the Uniform Guidance. Coronavirus State and Local Fiscal Recovery Funds We determined that seven (7) out of forty (40) samples did have purchase order approval made subsequent to invoice approval. The aforementioned circumstance suggests that the method of procurement was not in line with the City’s adopted policy established in line with the Uniform Guidance. During our audit, we also 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. Cause: The City did not follow its policies and process in place to check and ensure the suspension and debarment review process over vendors that provides goods or services to the City’s programs was conducted prior to enter into contract. The City implemented necessary procedures to address the finding discovered during the audit for the year ended June 30,2022 prospectively, however, due to the timing of the previous audit, the City was not able to address for the year ended June 30, 2023. Effect or Potential Effect: Without verifying whether vendors are suspended or debarred from working on federally-funded projects prior to the contract awarded, the City could be contracting with vendors that are prohibited from working on federally funded projects. Questioned Costs: None. Context: See condition above for context of the finding. Identification as a Repeat Finding, If Applicable: Yes. See prior year finding 2022-004. Recommendation: We recommended the City follow internal control policies and procedures to incorporate the suspension and debarment verification prior to awarding contracts. Views of Responsible Officials: Management concurs the finding.
2023-004 - Procurement, Suspension, and Debarment – Internal Control over Procurement and Verification Against the System for Award Management (“SAM”) (Significant Deficiency) Identification of the Federal Program: Assistance Listing Number: 14.218 Federal Program Name: Community Development Block Grants-Entitlement Grants Cluster Federal Agency: Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Number(s) and Award Year: B-21-MC-06-0554 Assistance Listing Number: 21.027 Assistance Listing Title: Coronavirus State and Local Fiscal Recovery Funds Federal Agency: Department of Treasury Pass-Through Entity: N/A Federal Award Number and Award Year: N/A Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): Suspension and Debarment, Non-Federal entities are prohibited from contracting with or making subawards under covered transactions to parties that are suspended or debarred. “Covered transactions” include those procurement contracts for goods and services awarded under a nonprocurement transaction (e.g., grant or cooperative agreement) that are expected to equal or exceed $25,000 or meet certain other criteria as specified in 2 CFR section 180.220. All nonprocurement transactions entered into by a recipient (i.e., subawards to subrecipients), irrespective of award amount, are considered covered transactions, unless they are exempt as provided in 2 CFR section 180.215. When a non-Federal entity enters into a covered transaction with an entity at a lower tier, the non-Federal entity must verify that the entity, as defined in 2 CFR section 180.995 and agency adopting regulations, is not suspended or debarred or otherwise excluded from participating in the transaction. This verification may be accomplished by (1) checking the System for Award Management (SAM) Exclusions maintained by the General Services Administration (GSA) and available at https://www.sam.gov/portal/public/SAM/ (Note: The OMB guidance at 2 CFR part 180 and agency implementing regulations still refer to the SAM Exclusions as the Excluded Parties List System (EPLS)), (2) collecting a certification from the entity, or (3) adding a clause or condition to the covered transaction with that entity (2 CFR section 180.300). In accordance with OMB Uniform Guidance, entities under the program, including subrecipients of a state, must follow the procurement standards in 2 CFR sections § 200.318 through § 200.327, including ensuring that the procurement method used for the contracts are appropriate based on the dollar amount and conditions specified in 2 CFR section 200.320. C.F.R. § 200.319 prescribes that all procurement transactions for the acquisition of property or services required under a Federal award must be conducted in a manner providing full and open competition consistent with the standards of this section and § 200.320. Further, the non-Federal entity must ensure that all prequalified lists of persons, firms, or products which are used in acquiring goods and services are current and include enough qualified sources to ensure maximum open and free competition. Also, the non-Federal entity must not preclude potential bidders from qualifying during the solicitation period. Condition: Community Development Block Grants-Entitlement Grants Cluster Based on the City’s formal purchasing policy, purchase orders are required to initiate purchases from procured vendors for transactions above $5,000. During our audit, we noted that seven (7) out of forty (40) samples did have purchase order approval made subsequent to invoice approval. The aforementioned circumstance suggests that the method of procurement was not in line with the City’s adopted policy established in line with the Uniform Guidance. Coronavirus State and Local Fiscal Recovery Funds We determined that seven (7) out of forty (40) samples did have purchase order approval made subsequent to invoice approval. The aforementioned circumstance suggests that the method of procurement was not in line with the City’s adopted policy established in line with the Uniform Guidance. During our audit, we also 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. Cause: The City did not follow its policies and process in place to check and ensure the suspension and debarment review process over vendors that provides goods or services to the City’s programs was conducted prior to enter into contract. The City implemented necessary procedures to address the finding discovered during the audit for the year ended June 30,2022 prospectively, however, due to the timing of the previous audit, the City was not able to address for the year ended June 30, 2023. Effect or Potential Effect: Without verifying whether vendors are suspended or debarred from working on federally-funded projects prior to the contract awarded, the City could be contracting with vendors that are prohibited from working on federally funded projects. Questioned Costs: None. Context: See condition above for context of the finding. Identification as a Repeat Finding, If Applicable: Yes. See prior year finding 2022-004. Recommendation: We recommended the City follow internal control policies and procedures to incorporate the suspension and debarment verification prior to awarding contracts. Views of Responsible Officials: Management concurs the finding.
2023-005 - Reporting – Internal Control and Compliance over Reporting (Material Weakness) Information of the Federal Program(s): Assistance Listing Number: 14.218 Federal Program Name: Community Development Block Grants-Entitlement Grants Cluster Federal Agency: Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Number(s) and Award Year: B-21-MC-06-0554 B-20-MW-06-0554 Assistance Listing Number: 14.871 Federal Program Name: Housing Voucher Cluster Federal Agency: Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Number(s) and Award Year: CA120 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): Community Development Block Grants-Entitlement Grants Cluster 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 the Guidance on Cash on Hand Quarterly Report (replaced the Federal Financial Report, SF-425) and financial reporting requirements in the cooperative agreement provisions, and 2 CFR 200.327: Quarterly reports: Program award recipients must submit Cash on Hand Quarterly Report 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 noted below: Reporting Period: Quarter 1: 7/1-9/30 Quarter 2: 10/1-12/31 Quarter 3: 1/1-3/31 Quarter 4: 4/1-6/30 Due Date of Report: October 30 January 30 April 30 July 30 Community Development Block Grants-Entitlement Grants Cluster (Continued) 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”). Housing Voucher Cluster Per 24 CFR § 5.801(d)(1) - Uniform financial reporting standards, unaudited financial statements will be required 60 days after the Public Housing Authority’s (“PHA”) fiscal year end, and audited financial statements will then be required no later than 9 months after the PHA's fiscal year end, in accordance with the Single Audit Act and 2 CFR part 200, subpart F. The PHA is required to submit the HUD-52681-B, Voucher for Payment of Annual Contributions and Operating Statement form monthly to HUD electronically via the Voucher Management System (VMS). Congress has instructed HUD to use VMS data to determine renewal funding levels. HUD also uses VMS data for other funding, monitoring, and SEMAP- related decisions. Condition: 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 all of the four (4) reporting periods were submitted on February 26, 2024. The City did not submit any of the four (4) quarterly Section 15011 Reports for the year ended June 30, 2023. 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. The unaudited Financial Data Schedule (FDS) for the fiscal year ended June 30, 2023 was not submitted on or before the August 31, 2023 due date. Housing Voucher Cluster (Continued) We also noted for 2 out of 4 VMS reports tested, there was no evidence of review and approval prior to submission to HUD. A nonstatistical sample of 4 out of 12 VMS reports were selected for test work. Cause: Community Development Block Grants-Entitlement Grants Cluster There was a change in personnel monitoring the compliance requirements for CDBG reporting, and there was no proper task delegation and turnover made upon separation of the previously assigned staff. Hence, the staff assuming the post was unable to meet the due date to ensure filing the Cash on Hand quarterly reports timely, and also was not aware of the Section 15011 CARES reporting. Housing Voucher Cluster Due to the effects of COVID-19 and staff turnover, the program’s procedures did not consistently ensure that the reports were submitted timely in accordance with the timelines in the Uniform Guidance, or properly reviewed and approved prior to submission. The City has implemented internal controls designed to review the VMS report prior to submission, effective starting in March 2023, in an effort to address the finding noted during the audit for the year ended June 30, 2022. Due to the timing of implementation, any VMS report prior to March 2023 do not have any evidence of approval before submission. Effect or Potential Effect: Community Development Block Grants-Entitlement Grants Cluster Delay in filing and not filing the reports resulted in noncompliance with the compliance requirements. Housing Voucher Cluster Failure to submit the audited FDS timely results in noncompliance with the compliance requirements. Failure to review the VMS reports prior to submittal 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: Yes. See prior year finding 2022-005. Recommendation: We recommend that the City strengthen their report submission process and procedures to ensure all required reports are properly reviewed and approved and submitted timely. 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 the finding.
2023-005 - Reporting – Internal Control and Compliance over Reporting (Material Weakness) Information of the Federal Program(s): Assistance Listing Number: 14.218 Federal Program Name: Community Development Block Grants-Entitlement Grants Cluster Federal Agency: Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Number(s) and Award Year: B-21-MC-06-0554 B-20-MW-06-0554 Assistance Listing Number: 14.871 Federal Program Name: Housing Voucher Cluster Federal Agency: Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Number(s) and Award Year: CA120 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): Community Development Block Grants-Entitlement Grants Cluster 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 the Guidance on Cash on Hand Quarterly Report (replaced the Federal Financial Report, SF-425) and financial reporting requirements in the cooperative agreement provisions, and 2 CFR 200.327: Quarterly reports: Program award recipients must submit Cash on Hand Quarterly Report 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 noted below: Reporting Period: Quarter 1: 7/1-9/30 Quarter 2: 10/1-12/31 Quarter 3: 1/1-3/31 Quarter 4: 4/1-6/30 Due Date of Report: October 30 January 30 April 30 July 30 Community Development Block Grants-Entitlement Grants Cluster (Continued) 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”). Housing Voucher Cluster Per 24 CFR § 5.801(d)(1) - Uniform financial reporting standards, unaudited financial statements will be required 60 days after the Public Housing Authority’s (“PHA”) fiscal year end, and audited financial statements will then be required no later than 9 months after the PHA's fiscal year end, in accordance with the Single Audit Act and 2 CFR part 200, subpart F. The PHA is required to submit the HUD-52681-B, Voucher for Payment of Annual Contributions and Operating Statement form monthly to HUD electronically via the Voucher Management System (VMS). Congress has instructed HUD to use VMS data to determine renewal funding levels. HUD also uses VMS data for other funding, monitoring, and SEMAP- related decisions. Condition: 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 all of the four (4) reporting periods were submitted on February 26, 2024. The City did not submit any of the four (4) quarterly Section 15011 Reports for the year ended June 30, 2023. 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. The unaudited Financial Data Schedule (FDS) for the fiscal year ended June 30, 2023 was not submitted on or before the August 31, 2023 due date. Housing Voucher Cluster (Continued) We also noted for 2 out of 4 VMS reports tested, there was no evidence of review and approval prior to submission to HUD. A nonstatistical sample of 4 out of 12 VMS reports were selected for test work. Cause: Community Development Block Grants-Entitlement Grants Cluster There was a change in personnel monitoring the compliance requirements for CDBG reporting, and there was no proper task delegation and turnover made upon separation of the previously assigned staff. Hence, the staff assuming the post was unable to meet the due date to ensure filing the Cash on Hand quarterly reports timely, and also was not aware of the Section 15011 CARES reporting. Housing Voucher Cluster Due to the effects of COVID-19 and staff turnover, the program’s procedures did not consistently ensure that the reports were submitted timely in accordance with the timelines in the Uniform Guidance, or properly reviewed and approved prior to submission. The City has implemented internal controls designed to review the VMS report prior to submission, effective starting in March 2023, in an effort to address the finding noted during the audit for the year ended June 30, 2022. Due to the timing of implementation, any VMS report prior to March 2023 do not have any evidence of approval before submission. Effect or Potential Effect: Community Development Block Grants-Entitlement Grants Cluster Delay in filing and not filing the reports resulted in noncompliance with the compliance requirements. Housing Voucher Cluster Failure to submit the audited FDS timely results in noncompliance with the compliance requirements. Failure to review the VMS reports prior to submittal 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: Yes. See prior year finding 2022-005. Recommendation: We recommend that the City strengthen their report submission process and procedures to ensure all required reports are properly reviewed and approved and submitted timely. 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 the finding.
2023-005 - Reporting – Internal Control and Compliance over Reporting (Material Weakness) Information of the Federal Program(s): Assistance Listing Number: 14.218 Federal Program Name: Community Development Block Grants-Entitlement Grants Cluster Federal Agency: Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Number(s) and Award Year: B-21-MC-06-0554 B-20-MW-06-0554 Assistance Listing Number: 14.871 Federal Program Name: Housing Voucher Cluster Federal Agency: Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Number(s) and Award Year: CA120 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): Community Development Block Grants-Entitlement Grants Cluster 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 the Guidance on Cash on Hand Quarterly Report (replaced the Federal Financial Report, SF-425) and financial reporting requirements in the cooperative agreement provisions, and 2 CFR 200.327: Quarterly reports: Program award recipients must submit Cash on Hand Quarterly Report 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 noted below: Reporting Period: Quarter 1: 7/1-9/30 Quarter 2: 10/1-12/31 Quarter 3: 1/1-3/31 Quarter 4: 4/1-6/30 Due Date of Report: October 30 January 30 April 30 July 30 Community Development Block Grants-Entitlement Grants Cluster (Continued) 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”). Housing Voucher Cluster Per 24 CFR § 5.801(d)(1) - Uniform financial reporting standards, unaudited financial statements will be required 60 days after the Public Housing Authority’s (“PHA”) fiscal year end, and audited financial statements will then be required no later than 9 months after the PHA's fiscal year end, in accordance with the Single Audit Act and 2 CFR part 200, subpart F. The PHA is required to submit the HUD-52681-B, Voucher for Payment of Annual Contributions and Operating Statement form monthly to HUD electronically via the Voucher Management System (VMS). Congress has instructed HUD to use VMS data to determine renewal funding levels. HUD also uses VMS data for other funding, monitoring, and SEMAP- related decisions. Condition: 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 all of the four (4) reporting periods were submitted on February 26, 2024. The City did not submit any of the four (4) quarterly Section 15011 Reports for the year ended June 30, 2023. 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. The unaudited Financial Data Schedule (FDS) for the fiscal year ended June 30, 2023 was not submitted on or before the August 31, 2023 due date. Housing Voucher Cluster (Continued) We also noted for 2 out of 4 VMS reports tested, there was no evidence of review and approval prior to submission to HUD. A nonstatistical sample of 4 out of 12 VMS reports were selected for test work. Cause: Community Development Block Grants-Entitlement Grants Cluster There was a change in personnel monitoring the compliance requirements for CDBG reporting, and there was no proper task delegation and turnover made upon separation of the previously assigned staff. Hence, the staff assuming the post was unable to meet the due date to ensure filing the Cash on Hand quarterly reports timely, and also was not aware of the Section 15011 CARES reporting. Housing Voucher Cluster Due to the effects of COVID-19 and staff turnover, the program’s procedures did not consistently ensure that the reports were submitted timely in accordance with the timelines in the Uniform Guidance, or properly reviewed and approved prior to submission. The City has implemented internal controls designed to review the VMS report prior to submission, effective starting in March 2023, in an effort to address the finding noted during the audit for the year ended June 30, 2022. Due to the timing of implementation, any VMS report prior to March 2023 do not have any evidence of approval before submission. Effect or Potential Effect: Community Development Block Grants-Entitlement Grants Cluster Delay in filing and not filing the reports resulted in noncompliance with the compliance requirements. Housing Voucher Cluster Failure to submit the audited FDS timely results in noncompliance with the compliance requirements. Failure to review the VMS reports prior to submittal 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: Yes. See prior year finding 2022-005. Recommendation: We recommend that the City strengthen their report submission process and procedures to ensure all required reports are properly reviewed and approved and submitted timely. 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 the finding.
2023-005 - Reporting – Internal Control and Compliance over Reporting (Material Weakness) Information of the Federal Program(s): Assistance Listing Number: 14.218 Federal Program Name: Community Development Block Grants-Entitlement Grants Cluster Federal Agency: Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Number(s) and Award Year: B-21-MC-06-0554 B-20-MW-06-0554 Assistance Listing Number: 14.871 Federal Program Name: Housing Voucher Cluster Federal Agency: Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Number(s) and Award Year: CA120 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): Community Development Block Grants-Entitlement Grants Cluster 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 the Guidance on Cash on Hand Quarterly Report (replaced the Federal Financial Report, SF-425) and financial reporting requirements in the cooperative agreement provisions, and 2 CFR 200.327: Quarterly reports: Program award recipients must submit Cash on Hand Quarterly Report 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 noted below: Reporting Period: Quarter 1: 7/1-9/30 Quarter 2: 10/1-12/31 Quarter 3: 1/1-3/31 Quarter 4: 4/1-6/30 Due Date of Report: October 30 January 30 April 30 July 30 Community Development Block Grants-Entitlement Grants Cluster (Continued) 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”). Housing Voucher Cluster Per 24 CFR § 5.801(d)(1) - Uniform financial reporting standards, unaudited financial statements will be required 60 days after the Public Housing Authority’s (“PHA”) fiscal year end, and audited financial statements will then be required no later than 9 months after the PHA's fiscal year end, in accordance with the Single Audit Act and 2 CFR part 200, subpart F. The PHA is required to submit the HUD-52681-B, Voucher for Payment of Annual Contributions and Operating Statement form monthly to HUD electronically via the Voucher Management System (VMS). Congress has instructed HUD to use VMS data to determine renewal funding levels. HUD also uses VMS data for other funding, monitoring, and SEMAP- related decisions. Condition: 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 all of the four (4) reporting periods were submitted on February 26, 2024. The City did not submit any of the four (4) quarterly Section 15011 Reports for the year ended June 30, 2023. 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. The unaudited Financial Data Schedule (FDS) for the fiscal year ended June 30, 2023 was not submitted on or before the August 31, 2023 due date. Housing Voucher Cluster (Continued) We also noted for 2 out of 4 VMS reports tested, there was no evidence of review and approval prior to submission to HUD. A nonstatistical sample of 4 out of 12 VMS reports were selected for test work. Cause: Community Development Block Grants-Entitlement Grants Cluster There was a change in personnel monitoring the compliance requirements for CDBG reporting, and there was no proper task delegation and turnover made upon separation of the previously assigned staff. Hence, the staff assuming the post was unable to meet the due date to ensure filing the Cash on Hand quarterly reports timely, and also was not aware of the Section 15011 CARES reporting. Housing Voucher Cluster Due to the effects of COVID-19 and staff turnover, the program’s procedures did not consistently ensure that the reports were submitted timely in accordance with the timelines in the Uniform Guidance, or properly reviewed and approved prior to submission. The City has implemented internal controls designed to review the VMS report prior to submission, effective starting in March 2023, in an effort to address the finding noted during the audit for the year ended June 30, 2022. Due to the timing of implementation, any VMS report prior to March 2023 do not have any evidence of approval before submission. Effect or Potential Effect: Community Development Block Grants-Entitlement Grants Cluster Delay in filing and not filing the reports resulted in noncompliance with the compliance requirements. Housing Voucher Cluster Failure to submit the audited FDS timely results in noncompliance with the compliance requirements. Failure to review the VMS reports prior to submittal 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: Yes. See prior year finding 2022-005. Recommendation: We recommend that the City strengthen their report submission process and procedures to ensure all required reports are properly reviewed and approved and submitted timely. 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 the finding.
2023-006 – Subrecipient Monitoring – Internal Control and Compliance over Subrecipient Monitoring (Significant Deficiency) Identification of the Federal Program: Assistance Listing Number: 21.027 Assistance Listing Title: Coronavirus State and Local Fiscal Recovery Funds Federal Agency: Department of Treasury Pass-Through Entity: N/A Federal Award Number and Award Year: N/A Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): C.F.R. § 200.332 prescribes that the pass-through entity must conduct monitoring activities of the subrecipient as necessary to ensure that the subaward is used for authorized purposes, in compliance with Federal statutes, regulations, and the terms and conditions of the subaward; and that subaward performance goals are achieved. Pass-through entity monitoring of the subrecipient must include: 1. Reviewing financial and performance reports required by the pass-through entity. 2. Following-up and ensuring that the subrecipient takes timely and appropriate action on all deficiencies pertaining to the Federal award provided to the subrecipient from the pass-through entity detected through audits, on-site reviews, and written confirmation from the subrecipient, highlighting the status of actions planned or taken to address Single Audit findings related to the particular subaward. 3. Issuing a management decision for applicable audit findings pertaining only to the Federal award provided to the subrecipient from the pass-through entity as required by § 200.521. 4. The pass-through entity is responsible for resolving audit findings specifically related to the subaward and not responsible for resolving crosscutting findings. Condition: During our audit, we noted that the City did not have established monitoring policies and procedures for its subrecipients to address the compliance requirements. Consequently, no subrecipient monitoring activities were conducted during the year. Cause: The City does not have any written policy and sufficient procedures for subrecipient monitoring activities tailored to address the subrecipient monitoring compliance requirements of the grant. Effect or Potential Effect: The City was not able to do the necessary subrecipient monitoring activities resulted to internal control and compliance requirement finding. Questioned Costs: None. Context: See condition above for context of the finding. Identification as a Repeat Finding, If Applicable: Not applicable. Recommendation: We recommended the City establish a formal policy over review procedures on subrecipient monitoring to ensure the City is in compliance the grant requirement. Views of Responsible Officials: Management concurs the finding.
2023-007 - Special Tests – Internal Control and Compliance over Housing Quality Standards Inspections (Material Weakness) Information on the Federal Program: Assistance Listing Number: 14.871 Federal Program Name: Housing Voucher Cluster Federal Agency: Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Number and Award Year: CA120 – FY22-23 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): 24 CFR 982.405(b) states that the Public PHA (PHA) must inspect the unit leased to a family prior to the initial term of the lease, at least biennially during assisted occupancy, and at other times as needed, to determine if the unit meets Housing Quality Standards (HQS). Condition: We found five (5) instances out of 9 in which the City did not conduct the HQS failed inspection follow up in a timely manner. We also noted three (3) instances out of 40 samples for eligibility testing has HQS inspections that are over a year apart, which shows that the City did not conduct the HQS biennial inspection in a timely manner. Cause: The City currently has no policies or procedures in place to ensure that Housing Quality Standard Inspections are performed timely. Effect or Potential Effect: The City has not complied with the requirements of 24 CFR 982.405(b) – Housing Quality Standards Inspections. Questioned Costs: None. Context: See condition above for the context of the finding. Repeat Finding from Prior Year(s): Yes. See prior year finding 2022-006. Recommendation: We recommend that the City implement procedures to ensure that Housing Quality Standard Inspections are performed timely. Views of Responsible Officials: Management concurs the finding.
2023-007 - Special Tests – Internal Control and Compliance over Housing Quality Standards Inspections (Material Weakness) Information on the Federal Program: Assistance Listing Number: 14.871 Federal Program Name: Housing Voucher Cluster Federal Agency: Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Number and Award Year: CA120 – FY22-23 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): 24 CFR 982.405(b) states that the Public PHA (PHA) must inspect the unit leased to a family prior to the initial term of the lease, at least biennially during assisted occupancy, and at other times as needed, to determine if the unit meets Housing Quality Standards (HQS). Condition: We found five (5) instances out of 9 in which the City did not conduct the HQS failed inspection follow up in a timely manner. We also noted three (3) instances out of 40 samples for eligibility testing has HQS inspections that are over a year apart, which shows that the City did not conduct the HQS biennial inspection in a timely manner. Cause: The City currently has no policies or procedures in place to ensure that Housing Quality Standard Inspections are performed timely. Effect or Potential Effect: The City has not complied with the requirements of 24 CFR 982.405(b) – Housing Quality Standards Inspections. Questioned Costs: None. Context: See condition above for the context of the finding. Repeat Finding from Prior Year(s): Yes. See prior year finding 2022-006. Recommendation: We recommend that the City implement procedures to ensure that Housing Quality Standard Inspections are performed timely. Views of Responsible Officials: Management concurs the finding.