Audit 358335

Significant deficiency in internal control over compliance and noncompliance related to allowable costs/cost principles compliance requirements. Federal Agency: U.S. Department of Treasury Pass-Through Entity: City and County of Denver Program Title: Coronavirus State and Local Fiscal Recovery Funds Assistance Listing Number: 21.027 Award Number: 202474319 Criteria Nonfederal entities must follow the standards for documentation of personnel expenses set out at 2 CFR section 200.430(i). Under those standards, charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. Additionally, those standards require that the records a) reasonably reflect the total activity for which the employee is compensated by the nonfederal entity, not exceeding 100% of compensated activities; b) support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one federal award; a federal award and nonfederal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity; and c) budget estimates (i.e., estimates determined before the services are performed) alone do not qualify as support for charges to Federal awards. Budget estimates may be used for interim account purposes, provided that a) The system for establishing the estimates produces reasonable approximations of the activity performed; b) significant changes in the related work activity (as defined by the recipient's or subrecipient's written policies) are promptly identified and entered into the records. Short-term (such as one or two months) fluctuations between workload categories do not need to be considered as long as the distribution of salaries and wages is reasonable over the longer term; and c) the recipient's or subrecipient's system of internal controls includes processes to perform periodic after-the-fact reviews of interim charges made to a Federal award based on budget estimates. All necessary adjustments must be made so that the final amount charged to the Federal award is accurate, allowable, and properly allocated Condition and Context The Organization maintains a timekeeping and payroll system for charges to federal awards that documents approved wage and salary rates, time and effort certification, hours, and actual amounts paid to employees. The Organization is allocating payroll costs to federal programs for individual employees using budget estimates of time and effort on different activities. The Organization maintains after-the-fact review documentation of time spent for each employee to support the allocation in the form of “Time and Effort” certifications that are signed by all employees and supervisors to verify actual time spent on major program. During our testing we noted two pay-periods for one employee where the Organization did not maintain the “Time and Effort” certification. Section III - Reportable Findings and Questioned Costs for Federal Awards Cause The Organization’s management noted that the missing certifications were due to the employee leaving employment before the certifications were completed for the two pay periods. The Organization did not have a process in place to ensure alternate certification documentation was created and retained in the situation of terminated employees. Effect The effect is that the Organization is not in compliance with the requirements of 2 CFR section 200.430(i) for the two pay periods for this employee. For two pay-periods for one employee the payroll costs charged to the major program were not supported by documentation of after-the-fact review evidencing that those costs reasonably reflect the work actually performed on the activity. Questioned Costs The expenditures for the two pay periods for the one employee totaled of $8,846. Repeat Finding This is not a repeat finding. Recommendation We recommend management update its internal control process for employees who depart or are unable to certify their timesheets to ensure all time spent on federal programs is certified by employees and their supervisors. Views of Responsible Official and Corrective Action Plan Management agrees with the finding and has provided the accompanying corrective action plan.

Significant deficiency in internal control over compliance related to matching compliance requirements. Federal Agency: US Department of Treasury Pass-Through Entity: State of Colorado Department of Local Affairs - Division of Housing Program Title: Coronavirus State and Local Fiscal Recovery Funds Assistance Listing Number: 21.027 Award Number: H4HRG23147 Criteria Nonfederal entities must follow the standards for documentation of personnel expenses set out at 2 CFR section 200.306(a). Under this guidance, the entity that accepts any cost share funds (including cash and third-party in-kind contributions, and also including funds committed by the recipient, subrecipient, or third parties) as part of the recipient's or subrecipient's contributions to a program when the funds among others: 1) are verifiable in the recipient's or subrecipient’s records. Section III - Reportable Findings and Questioned Costs for Federal Awards Condition/Context/Cause The Organization entered into an agreement with match requirements to qualify for a federal match. The agreement stipulates the Organization has until September 2026 to expend the necessary matching funds. During our testing of matching for this award we noted that the Organization did not have controls in place to track and monitor compliance with the matching requirement. Effect The effect is that the Organization was not tracking spending to date that qualifies to meet the matching requirement for this award in compliance with the requirements of 2 CFR section 200.306. Questioned Costs None. Repeat Finding This is not a repeat finding. Recommendation We recommend management update its internal control process for a tracking system of matching funds to ensure compliance with 2 CFR 200.306 is met. This includes maintaining detailed records and documentation of all matching contributions. Views of Responsible Official and Corrective Action Plan Management agrees with the finding and has provided the accompanying corrective action plan.

Significant deficiency in internal control over compliance and noncompliance related to allowable costs/cost principles compliance requirements. Federal Agency: U.S. Department of Treasury Pass-Through Entity: City and County of Denver Program Title: Coronavirus State and Local Fiscal Recovery Funds Assistance Listing Number: 21.027 Award Number: 202474319 Criteria Nonfederal entities must follow the standards for documentation of personnel expenses set out at 2 CFR section 200.430(i). Under those standards, charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. Additionally, those standards require that the records a) reasonably reflect the total activity for which the employee is compensated by the nonfederal entity, not exceeding 100% of compensated activities; b) support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one federal award; a federal award and nonfederal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity; and c) budget estimates (i.e., estimates determined before the services are performed) alone do not qualify as support for charges to Federal awards. Budget estimates may be used for interim account purposes, provided that a) The system for establishing the estimates produces reasonable approximations of the activity performed; b) significant changes in the related work activity (as defined by the recipient's or subrecipient's written policies) are promptly identified and entered into the records. Short-term (such as one or two months) fluctuations between workload categories do not need to be considered as long as the distribution of salaries and wages is reasonable over the longer term; and c) the recipient's or subrecipient's system of internal controls includes processes to perform periodic after-the-fact reviews of interim charges made to a Federal award based on budget estimates. All necessary adjustments must be made so that the final amount charged to the Federal award is accurate, allowable, and properly allocated Condition and Context The Organization maintains a timekeeping and payroll system for charges to federal awards that documents approved wage and salary rates, time and effort certification, hours, and actual amounts paid to employees. The Organization is allocating payroll costs to federal programs for individual employees using budget estimates of time and effort on different activities. The Organization maintains after-the-fact review documentation of time spent for each employee to support the allocation in the form of “Time and Effort” certifications that are signed by all employees and supervisors to verify actual time spent on major program. During our testing we noted two pay-periods for one employee where the Organization did not maintain the “Time and Effort” certification. Section III - Reportable Findings and Questioned Costs for Federal Awards Cause The Organization’s management noted that the missing certifications were due to the employee leaving employment before the certifications were completed for the two pay periods. The Organization did not have a process in place to ensure alternate certification documentation was created and retained in the situation of terminated employees. Effect The effect is that the Organization is not in compliance with the requirements of 2 CFR section 200.430(i) for the two pay periods for this employee. For two pay-periods for one employee the payroll costs charged to the major program were not supported by documentation of after-the-fact review evidencing that those costs reasonably reflect the work actually performed on the activity. Questioned Costs The expenditures for the two pay periods for the one employee totaled of $8,846. Repeat Finding This is not a repeat finding. Recommendation We recommend management update its internal control process for employees who depart or are unable to certify their timesheets to ensure all time spent on federal programs is certified by employees and their supervisors. Views of Responsible Official and Corrective Action Plan Management agrees with the finding and has provided the accompanying corrective action plan.

Significant deficiency in internal control over compliance related to matching compliance requirements. Federal Agency: US Department of Treasury Pass-Through Entity: State of Colorado Department of Local Affairs - Division of Housing Program Title: Coronavirus State and Local Fiscal Recovery Funds Assistance Listing Number: 21.027 Award Number: H4HRG23147 Criteria Nonfederal entities must follow the standards for documentation of personnel expenses set out at 2 CFR section 200.306(a). Under this guidance, the entity that accepts any cost share funds (including cash and third-party in-kind contributions, and also including funds committed by the recipient, subrecipient, or third parties) as part of the recipient's or subrecipient's contributions to a program when the funds among others: 1) are verifiable in the recipient's or subrecipient’s records. Section III - Reportable Findings and Questioned Costs for Federal Awards Condition/Context/Cause The Organization entered into an agreement with match requirements to qualify for a federal match. The agreement stipulates the Organization has until September 2026 to expend the necessary matching funds. During our testing of matching for this award we noted that the Organization did not have controls in place to track and monitor compliance with the matching requirement. Effect The effect is that the Organization was not tracking spending to date that qualifies to meet the matching requirement for this award in compliance with the requirements of 2 CFR section 200.306. Questioned Costs None. Repeat Finding This is not a repeat finding. Recommendation We recommend management update its internal control process for a tracking system of matching funds to ensure compliance with 2 CFR 200.306 is met. This includes maintaining detailed records and documentation of all matching contributions. Views of Responsible Official and Corrective Action Plan Management agrees with the finding and has provided the accompanying corrective action plan.