Audit 42772

FY End
2022-12-31
Total Expended
$368.79M
Findings
20
Programs
71
Organization: City of Columbus, Ohio (OH)
Year: 2022 Accepted: 2023-04-12

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
51834 2022-002 Material Weakness - AB
51835 2022-002 Material Weakness - AB
51836 2022-002 Material Weakness - AB
51837 2022-002 Material Weakness - AB
51838 2022-002 Material Weakness - AB
51839 2022-002 Material Weakness - AB
51840 2022-002 Material Weakness - AB
51841 2022-002 Material Weakness - AB
51842 2022-002 Material Weakness - AB
51843 2022-001 Material Weakness Yes I
628276 2022-002 Material Weakness - AB
628277 2022-002 Material Weakness - AB
628278 2022-002 Material Weakness - AB
628279 2022-002 Material Weakness - AB
628280 2022-002 Material Weakness - AB
628281 2022-002 Material Weakness - AB
628282 2022-002 Material Weakness - AB
628283 2022-002 Material Weakness - AB
628284 2022-002 Material Weakness - AB
628285 2022-001 Material Weakness Yes I

Programs

ALN Program Spent Major Findings
93.778 Medical Assistance Program $114.20M - 0
66.458 Capitalization Grants for Clean Water State Revolving Funds $58.22M Yes 0
21.027 Coronavirus State and Local Fiscal Recovery Funds $21.99M Yes 0
21.023 Emergency Rental Assistance Program $17.89M Yes 0
66.468 Capitalization Grants for Drinking Water State Revolving Funds $10.16M - 0
20.205 Highway Planning and Construction $6.57M Yes 0
16.922 Equitable Sharing Program $3.26M Yes 1
93.045 Special Programs for the Aging_title Iii, Part C_nutrition Services $2.33M Yes 0
93.391 Activities to Support State, Tribal, Local and Territorial (stlt) Health Department Response to Public Health Or Healthcare Crises $1.35M - 0
10.557 Special Supplemental Nutrition Program for Women, Infants, and Children $1.06M Yes 0
14.900 Lead-Based Paint Hazard Control in Privately-Owned Housing $950,727 - 0
93.053 Special Programs for the Aging_title Iii, Part C_nutrition Services $949,736 Yes 0
10.559 Summer Food Service Program for Children (smp) $757,551 Yes 0
14.218 Community Development Block Grants/entitlement Grants $729,549 Yes 1
93.926 Healthy Start Initiative $702,961 - 0
14.241 Housing Opportunities for Persons with Aids $548,347 - 0
93.145 Aids Education and Training Centers $467,591 - 0
93.217 Family Planning_services $366,692 - 0
14.239 Home Investment Partnerships Program $345,148 - 0
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $338,040 - 0
14.191 Multifamily Housing Services Coordinator $309,221 - 0
16.754 Harold Rogers Prescription Drug Monitoring Program $263,553 - 0
14.231 Emergency Solutions Grant Program $261,902 - 0
93.069 Public Health Emergency Preparedness $260,624 - 0
16.838 Comprehensive Opioid Abuse Site-Based Program $252,121 - 0
10.576 Senior Farmers Market Nutrition Program $247,046 - 0
16.034 Coronavirus Emergency Supplemental Funding Program $205,122 - 0
16.585 Drug Court Discretionary Grant Program $196,539 - 0
97.044 Assistance to Firefighters Grant $187,175 - 0
93.268 Immunization Cooperative Agreements $120,149 - 0
93.136 Injury Prevention and Control Research and State and Community Based Programs $118,205 - 0
93.994 Maternal and Child Health Services Block Grant to the States $111,464 - 0
21.016 Equitable Sharing $102,098 - 0
93.959 Block Grants for Prevention and Treatment of Substance Abuse $101,675 - 0
93.788 Opioid Str $92,316 - 0
93.940 Hiv Prevention Activities_health Department Based $79,675 - 0
93.137 Community Programs to Improve Minority Health Grant Program $78,193 - 0
93.071 Medicare Enrollment Assistance Program $72,625 - 0
93.558 Temporary Assistance for Needy Families $69,980 - 0
16.745 Criminal and Juvenile Justice and Mental Health Collaboration Program $61,948 - 0
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers $60,000 Yes 0
93.914 Hiv Emergency Relief Project Grants $52,032 - 0
93.041 Special Programs for the Aging_title Vii, Chapter 3_programs for Prevention of Elder Abuse, Neglect, and Exploitation $49,262 - 0
16.588 Violence Against Women Formula Grants $47,239 - 0
97.012 Boating Safety Financial Assistance $46,553 - 0
20.616 National Priority Safety Programs $44,617 - 0
16.575 Crime Victim Assistance $44,286 - 0
16.590 Grants to Encourage Arrest Policies and Enforcement of Protection Orders Program $43,027 - 0
14.913 Healthy Homes Production Program $38,644 - 0
93.568 Low-Income Home Energy Assistance $32,733 - 0
16.320 Services for Trafficking Victims $31,428 - 0
93.991 Preventive Health and Health Services Block Grant $28,978 - 0
93.043 Special Programs for the Aging_title Iii, Part D_disease Prevention and Health Promotion Services $25,755 - 0
93.421 Strengthening Public Health Systems and Services Through National Partnerships to Improve and Protect the Nations Health $25,000 - 0
16.726 Juvenile Mentoring Program $24,368 - 0
93.516 Affordable Care Act (aca) Public Health Training Centers Program $20,905 - 0
93.478 Preventing Maternal Deaths: Supporting Maternal Mortality Review Committees (b) $20,000 - 0
93.855 Allergy, Immunology and Transplantation Research $18,672 - 0
93.387 National and State Tobacco Control Program (b) $17,500 - 0
16.742 Paul Coverdell Forensic Sciences Improvement Grant Program $16,135 - 0
16.738 Edward Byrne Memorial Justice Assistance Grant Program $14,943 - 0
93.052 National Family Caregiver Support, Title Iii, Part E $11,250 - 0
93.958 Block Grants for Community Mental Health Services $3,942 - 0
93.074 Hospital Preparedness Program (hpp) and Public Health Emergency Preparedness (phep) Aligned Cooperative Agreements $3,396 - 0
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $2,409 Yes 0
20.608 Minimum Penalties for Repeat Offenders for Driving While Intoxicated $2,291 - 0
93.243 Substance Abuse and Mental Health Services_projects of Regional and National Significance $1,806 - 0
20.600 State and Community Highway Safety $1,141 - 0
21.019 Coronavirus Relief Fund $445 - 0
16.741 Dna Backlog Reduction Program $173 - 0
93.977 Preventive Health Services_sexually Transmitted Diseases Control Grants $15 - 0

Contacts

Name Title Type
E212WH2HVV55 Megan Kilgore Auditee
6146457615 Tom Dusek Auditor
No contacts on file

Notes to SEFA

Title: Note B - Basis of Accounting Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards (the Schedule) presents the activity of all federal award programs of the City of Columbus, Ohio (the City). The Citys reporting entity is defined in Note A to the Citys basic financial statements.The basis for determining when federal awards are expended 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. In addition, expenditures reported on the Schedule are recognized following the costs principles contained in Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, wherein certain types of expenditures are not allowable or are limited as to re-imbursement except for expenditures related to CFDA 21.019, Coronavirus Relief Fund (CRF). CRF does not apply the cost principles contained in Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards but rather applies the U.S. Department of Treasurys guidance. Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in the preparation of, the basic financial statements.The City has not elected to use the 10-precent de minimus indirect cost rate to recover indirect costs as allowed under the Uniform Guidance. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. The accompanying schedule is presented using the cash basis of accounting in which expenditures are recognized when paid.
Title: Note C-Schedule References Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards (the Schedule) presents the activity of all federal award programs of the City of Columbus, Ohio (the City). The Citys reporting entity is defined in Note A to the Citys basic financial statements.The basis for determining when federal awards are expended 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. In addition, expenditures reported on the Schedule are recognized following the costs principles contained in Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, wherein certain types of expenditures are not allowable or are limited as to re-imbursement except for expenditures related to CFDA 21.019, Coronavirus Relief Fund (CRF). CRF does not apply the cost principles contained in Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards but rather applies the U.S. Department of Treasurys guidance. Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in the preparation of, the basic financial statements.The City has not elected to use the 10-precent de minimus indirect cost rate to recover indirect costs as allowed under the Uniform Guidance. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. 1. COC ID# represents the Citys Microsoft D365 Accounting System classification structure and is used for internal purposes only.2. FAIN/Pass through ID represents the pass through agencys grant identification number or the federal agencys identification number.3. The PASSPORT program is funded by both federal and state Medicaid. The amount presented is the federal portion only.

Finding Details

2 CFR ?2400.101 gives regulatory effect to the Department of Housing and Urban Development for 2 CFR ?200.303(a) states that the non-Federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in ?Standards for Internal Control in the Federal Government? issued by the Comptroller General of the United States or the ?Internal Control Integrated Framework?, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Furthermore, 2 CFR ?200.430(i)(1)(i) states "charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must be supported by a system of internal controls which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. During testing of payroll expenses for AL #14.218 CDBG Entitlement Grant Cluster, we noted the City utilized employee-completed time-sheets for allocating payroll expenses to the federal program. However, the City?s established internal control procedures did not occur for six out of 40 timesheets. The timesheets did not contain appropriate evidence that the timesheet was reviewed and approved by a supervisor with direct knowledge of the employee?s activities to support proper allocation to the program. We were able to substantiate the related expenses through additional means to support allocation to the federal program. Failure to ensure all time sheets are appropriately approved by a knowledgeable supervisor could result in unallowable costs being allocated to a federal program and could ultimately result in a questioned cost. We recommend the City review established policies and procedures and ensure all timesheets are appropriately reviewed prior to allocation to a federal program.
2 CFR ?2400.101 gives regulatory effect to the Department of Housing and Urban Development for 2 CFR ?200.303(a) states that the non-Federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in ?Standards for Internal Control in the Federal Government? issued by the Comptroller General of the United States or the ?Internal Control Integrated Framework?, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Furthermore, 2 CFR ?200.430(i)(1)(i) states "charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must be supported by a system of internal controls which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. During testing of payroll expenses for AL #14.218 CDBG Entitlement Grant Cluster, we noted the City utilized employee-completed time-sheets for allocating payroll expenses to the federal program. However, the City?s established internal control procedures did not occur for six out of 40 timesheets. The timesheets did not contain appropriate evidence that the timesheet was reviewed and approved by a supervisor with direct knowledge of the employee?s activities to support proper allocation to the program. We were able to substantiate the related expenses through additional means to support allocation to the federal program. Failure to ensure all time sheets are appropriately approved by a knowledgeable supervisor could result in unallowable costs being allocated to a federal program and could ultimately result in a questioned cost. We recommend the City review established policies and procedures and ensure all timesheets are appropriately reviewed prior to allocation to a federal program.
2 CFR ?2400.101 gives regulatory effect to the Department of Housing and Urban Development for 2 CFR ?200.303(a) states that the non-Federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in ?Standards for Internal Control in the Federal Government? issued by the Comptroller General of the United States or the ?Internal Control Integrated Framework?, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Furthermore, 2 CFR ?200.430(i)(1)(i) states "charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must be supported by a system of internal controls which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. During testing of payroll expenses for AL #14.218 CDBG Entitlement Grant Cluster, we noted the City utilized employee-completed time-sheets for allocating payroll expenses to the federal program. However, the City?s established internal control procedures did not occur for six out of 40 timesheets. The timesheets did not contain appropriate evidence that the timesheet was reviewed and approved by a supervisor with direct knowledge of the employee?s activities to support proper allocation to the program. We were able to substantiate the related expenses through additional means to support allocation to the federal program. Failure to ensure all time sheets are appropriately approved by a knowledgeable supervisor could result in unallowable costs being allocated to a federal program and could ultimately result in a questioned cost. We recommend the City review established policies and procedures and ensure all timesheets are appropriately reviewed prior to allocation to a federal program.
2 CFR ?2400.101 gives regulatory effect to the Department of Housing and Urban Development for 2 CFR ?200.303(a) states that the non-Federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in ?Standards for Internal Control in the Federal Government? issued by the Comptroller General of the United States or the ?Internal Control Integrated Framework?, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Furthermore, 2 CFR ?200.430(i)(1)(i) states "charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must be supported by a system of internal controls which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. During testing of payroll expenses for AL #14.218 CDBG Entitlement Grant Cluster, we noted the City utilized employee-completed time-sheets for allocating payroll expenses to the federal program. However, the City?s established internal control procedures did not occur for six out of 40 timesheets. The timesheets did not contain appropriate evidence that the timesheet was reviewed and approved by a supervisor with direct knowledge of the employee?s activities to support proper allocation to the program. We were able to substantiate the related expenses through additional means to support allocation to the federal program. Failure to ensure all time sheets are appropriately approved by a knowledgeable supervisor could result in unallowable costs being allocated to a federal program and could ultimately result in a questioned cost. We recommend the City review established policies and procedures and ensure all timesheets are appropriately reviewed prior to allocation to a federal program.
2 CFR ?2400.101 gives regulatory effect to the Department of Housing and Urban Development for 2 CFR ?200.303(a) states that the non-Federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in ?Standards for Internal Control in the Federal Government? issued by the Comptroller General of the United States or the ?Internal Control Integrated Framework?, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Furthermore, 2 CFR ?200.430(i)(1)(i) states "charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must be supported by a system of internal controls which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. During testing of payroll expenses for AL #14.218 CDBG Entitlement Grant Cluster, we noted the City utilized employee-completed time-sheets for allocating payroll expenses to the federal program. However, the City?s established internal control procedures did not occur for six out of 40 timesheets. The timesheets did not contain appropriate evidence that the timesheet was reviewed and approved by a supervisor with direct knowledge of the employee?s activities to support proper allocation to the program. We were able to substantiate the related expenses through additional means to support allocation to the federal program. Failure to ensure all time sheets are appropriately approved by a knowledgeable supervisor could result in unallowable costs being allocated to a federal program and could ultimately result in a questioned cost. We recommend the City review established policies and procedures and ensure all timesheets are appropriately reviewed prior to allocation to a federal program.
2 CFR ?2400.101 gives regulatory effect to the Department of Housing and Urban Development for 2 CFR ?200.303(a) states that the non-Federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in ?Standards for Internal Control in the Federal Government? issued by the Comptroller General of the United States or the ?Internal Control Integrated Framework?, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Furthermore, 2 CFR ?200.430(i)(1)(i) states "charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must be supported by a system of internal controls which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. During testing of payroll expenses for AL #14.218 CDBG Entitlement Grant Cluster, we noted the City utilized employee-completed time-sheets for allocating payroll expenses to the federal program. However, the City?s established internal control procedures did not occur for six out of 40 timesheets. The timesheets did not contain appropriate evidence that the timesheet was reviewed and approved by a supervisor with direct knowledge of the employee?s activities to support proper allocation to the program. We were able to substantiate the related expenses through additional means to support allocation to the federal program. Failure to ensure all time sheets are appropriately approved by a knowledgeable supervisor could result in unallowable costs being allocated to a federal program and could ultimately result in a questioned cost. We recommend the City review established policies and procedures and ensure all timesheets are appropriately reviewed prior to allocation to a federal program.
2 CFR ?2400.101 gives regulatory effect to the Department of Housing and Urban Development for 2 CFR ?200.303(a) states that the non-Federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in ?Standards for Internal Control in the Federal Government? issued by the Comptroller General of the United States or the ?Internal Control Integrated Framework?, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Furthermore, 2 CFR ?200.430(i)(1)(i) states "charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must be supported by a system of internal controls which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. During testing of payroll expenses for AL #14.218 CDBG Entitlement Grant Cluster, we noted the City utilized employee-completed time-sheets for allocating payroll expenses to the federal program. However, the City?s established internal control procedures did not occur for six out of 40 timesheets. The timesheets did not contain appropriate evidence that the timesheet was reviewed and approved by a supervisor with direct knowledge of the employee?s activities to support proper allocation to the program. We were able to substantiate the related expenses through additional means to support allocation to the federal program. Failure to ensure all time sheets are appropriately approved by a knowledgeable supervisor could result in unallowable costs being allocated to a federal program and could ultimately result in a questioned cost. We recommend the City review established policies and procedures and ensure all timesheets are appropriately reviewed prior to allocation to a federal program.
2 CFR ?2400.101 gives regulatory effect to the Department of Housing and Urban Development for 2 CFR ?200.303(a) states that the non-Federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in ?Standards for Internal Control in the Federal Government? issued by the Comptroller General of the United States or the ?Internal Control Integrated Framework?, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Furthermore, 2 CFR ?200.430(i)(1)(i) states "charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must be supported by a system of internal controls which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. During testing of payroll expenses for AL #14.218 CDBG Entitlement Grant Cluster, we noted the City utilized employee-completed time-sheets for allocating payroll expenses to the federal program. However, the City?s established internal control procedures did not occur for six out of 40 timesheets. The timesheets did not contain appropriate evidence that the timesheet was reviewed and approved by a supervisor with direct knowledge of the employee?s activities to support proper allocation to the program. We were able to substantiate the related expenses through additional means to support allocation to the federal program. Failure to ensure all time sheets are appropriately approved by a knowledgeable supervisor could result in unallowable costs being allocated to a federal program and could ultimately result in a questioned cost. We recommend the City review established policies and procedures and ensure all timesheets are appropriately reviewed prior to allocation to a federal program.
2 CFR ?2400.101 gives regulatory effect to the Department of Housing and Urban Development for 2 CFR ?200.303(a) states that the non-Federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in ?Standards for Internal Control in the Federal Government? issued by the Comptroller General of the United States or the ?Internal Control Integrated Framework?, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Furthermore, 2 CFR ?200.430(i)(1)(i) states "charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must be supported by a system of internal controls which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. During testing of payroll expenses for AL #14.218 CDBG Entitlement Grant Cluster, we noted the City utilized employee-completed time-sheets for allocating payroll expenses to the federal program. However, the City?s established internal control procedures did not occur for six out of 40 timesheets. The timesheets did not contain appropriate evidence that the timesheet was reviewed and approved by a supervisor with direct knowledge of the employee?s activities to support proper allocation to the program. We were able to substantiate the related expenses through additional means to support allocation to the federal program. Failure to ensure all time sheets are appropriately approved by a knowledgeable supervisor could result in unallowable costs being allocated to a federal program and could ultimately result in a questioned cost. We recommend the City review established policies and procedures and ensure all timesheets are appropriately reviewed prior to allocation to a federal program.
2 CFR ?2867.10 gives regulatory effect to the Department of Justice for 2 CFR ?180.305 which states that Non-Federal entities are prohibited from entering into a covered transaction with parties that are suspended or debarred or whose principals are suspended or debarred, unless the Federal agency responsible for the transaction grants an exception under 2 CFR ? 180.135. 2 CFR ?180.200 identifies ?covered transactions? as non-procurement or procurement transactions at the primary tier, between a Federal agency and a person; or at the lower tier, between a participant in a covered transaction and another person. Procurement contracts for goods and services awarded under a non-procurement transaction (e.g., grant or cooperative agreement) are covered transactions if the contracts are expected to equal or exceed $25,000 or meet certain other specified criteria outlined in 2 CFR ? 180.220. All non-procurement transactions (i.e., subawards to subrecipients), irrespective of award amount, are considered covered transactions, unless exempt by 2 CFR ? 180.215. When a non-Federal entity enters a covered transaction, the non-Federal entity must verify that the entity is not suspended or debarred or otherwise excluded. This verification may be accomplished by checking SAM exclusions (http://sam.gov); collecting a certification from the entity, or adding a clause or condition to the covered transactions with that entity. Furthermore, the City of Columbus Purchasing Policy Manual - Bid and Proposal Evaluations - Federal Grants - Special Instructions provides "each department will review its Federal grants program policies and procedures for contract routing and update them immediately to include the following: A SAM.gov website review shall be included as the first page with each original contract scanned into Dynamics 365." The City did not have the proper internal controls in place to verify that all entities, with whom the City had entered covered transactions, had not been suspended or debarred. During testing of the contract expenses for AL #16.922 Equitable Sharing Program Funds grant programs, we noted seven out of eight instances in which the programs had a payment to a vendor of more than $25,000 and no evidence the City checked the SAM exclusions, collected a certification from the entity, or added a clause or condition to the covered transaction with the vendor could be provided. Failing to have the appropriate controls in place may result in vendors who are suspended or debarred receiving federal funds. Prior to contracting with vendors that will be paid with federal funds, the City should verify the vendor is not suspended or debarred by checking the SAM exclusions, collecting a certification from the vendor, or adding a clause or condition to the covered transaction with the vendor.
2 CFR ?2400.101 gives regulatory effect to the Department of Housing and Urban Development for 2 CFR ?200.303(a) states that the non-Federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in ?Standards for Internal Control in the Federal Government? issued by the Comptroller General of the United States or the ?Internal Control Integrated Framework?, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Furthermore, 2 CFR ?200.430(i)(1)(i) states "charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must be supported by a system of internal controls which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. During testing of payroll expenses for AL #14.218 CDBG Entitlement Grant Cluster, we noted the City utilized employee-completed time-sheets for allocating payroll expenses to the federal program. However, the City?s established internal control procedures did not occur for six out of 40 timesheets. The timesheets did not contain appropriate evidence that the timesheet was reviewed and approved by a supervisor with direct knowledge of the employee?s activities to support proper allocation to the program. We were able to substantiate the related expenses through additional means to support allocation to the federal program. Failure to ensure all time sheets are appropriately approved by a knowledgeable supervisor could result in unallowable costs being allocated to a federal program and could ultimately result in a questioned cost. We recommend the City review established policies and procedures and ensure all timesheets are appropriately reviewed prior to allocation to a federal program.
2 CFR ?2400.101 gives regulatory effect to the Department of Housing and Urban Development for 2 CFR ?200.303(a) states that the non-Federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in ?Standards for Internal Control in the Federal Government? issued by the Comptroller General of the United States or the ?Internal Control Integrated Framework?, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Furthermore, 2 CFR ?200.430(i)(1)(i) states "charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must be supported by a system of internal controls which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. During testing of payroll expenses for AL #14.218 CDBG Entitlement Grant Cluster, we noted the City utilized employee-completed time-sheets for allocating payroll expenses to the federal program. However, the City?s established internal control procedures did not occur for six out of 40 timesheets. The timesheets did not contain appropriate evidence that the timesheet was reviewed and approved by a supervisor with direct knowledge of the employee?s activities to support proper allocation to the program. We were able to substantiate the related expenses through additional means to support allocation to the federal program. Failure to ensure all time sheets are appropriately approved by a knowledgeable supervisor could result in unallowable costs being allocated to a federal program and could ultimately result in a questioned cost. We recommend the City review established policies and procedures and ensure all timesheets are appropriately reviewed prior to allocation to a federal program.
2 CFR ?2400.101 gives regulatory effect to the Department of Housing and Urban Development for 2 CFR ?200.303(a) states that the non-Federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in ?Standards for Internal Control in the Federal Government? issued by the Comptroller General of the United States or the ?Internal Control Integrated Framework?, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Furthermore, 2 CFR ?200.430(i)(1)(i) states "charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must be supported by a system of internal controls which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. During testing of payroll expenses for AL #14.218 CDBG Entitlement Grant Cluster, we noted the City utilized employee-completed time-sheets for allocating payroll expenses to the federal program. However, the City?s established internal control procedures did not occur for six out of 40 timesheets. The timesheets did not contain appropriate evidence that the timesheet was reviewed and approved by a supervisor with direct knowledge of the employee?s activities to support proper allocation to the program. We were able to substantiate the related expenses through additional means to support allocation to the federal program. Failure to ensure all time sheets are appropriately approved by a knowledgeable supervisor could result in unallowable costs being allocated to a federal program and could ultimately result in a questioned cost. We recommend the City review established policies and procedures and ensure all timesheets are appropriately reviewed prior to allocation to a federal program.
2 CFR ?2400.101 gives regulatory effect to the Department of Housing and Urban Development for 2 CFR ?200.303(a) states that the non-Federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in ?Standards for Internal Control in the Federal Government? issued by the Comptroller General of the United States or the ?Internal Control Integrated Framework?, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Furthermore, 2 CFR ?200.430(i)(1)(i) states "charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must be supported by a system of internal controls which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. During testing of payroll expenses for AL #14.218 CDBG Entitlement Grant Cluster, we noted the City utilized employee-completed time-sheets for allocating payroll expenses to the federal program. However, the City?s established internal control procedures did not occur for six out of 40 timesheets. The timesheets did not contain appropriate evidence that the timesheet was reviewed and approved by a supervisor with direct knowledge of the employee?s activities to support proper allocation to the program. We were able to substantiate the related expenses through additional means to support allocation to the federal program. Failure to ensure all time sheets are appropriately approved by a knowledgeable supervisor could result in unallowable costs being allocated to a federal program and could ultimately result in a questioned cost. We recommend the City review established policies and procedures and ensure all timesheets are appropriately reviewed prior to allocation to a federal program.
2 CFR ?2400.101 gives regulatory effect to the Department of Housing and Urban Development for 2 CFR ?200.303(a) states that the non-Federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in ?Standards for Internal Control in the Federal Government? issued by the Comptroller General of the United States or the ?Internal Control Integrated Framework?, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Furthermore, 2 CFR ?200.430(i)(1)(i) states "charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must be supported by a system of internal controls which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. During testing of payroll expenses for AL #14.218 CDBG Entitlement Grant Cluster, we noted the City utilized employee-completed time-sheets for allocating payroll expenses to the federal program. However, the City?s established internal control procedures did not occur for six out of 40 timesheets. The timesheets did not contain appropriate evidence that the timesheet was reviewed and approved by a supervisor with direct knowledge of the employee?s activities to support proper allocation to the program. We were able to substantiate the related expenses through additional means to support allocation to the federal program. Failure to ensure all time sheets are appropriately approved by a knowledgeable supervisor could result in unallowable costs being allocated to a federal program and could ultimately result in a questioned cost. We recommend the City review established policies and procedures and ensure all timesheets are appropriately reviewed prior to allocation to a federal program.
2 CFR ?2400.101 gives regulatory effect to the Department of Housing and Urban Development for 2 CFR ?200.303(a) states that the non-Federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in ?Standards for Internal Control in the Federal Government? issued by the Comptroller General of the United States or the ?Internal Control Integrated Framework?, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Furthermore, 2 CFR ?200.430(i)(1)(i) states "charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must be supported by a system of internal controls which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. During testing of payroll expenses for AL #14.218 CDBG Entitlement Grant Cluster, we noted the City utilized employee-completed time-sheets for allocating payroll expenses to the federal program. However, the City?s established internal control procedures did not occur for six out of 40 timesheets. The timesheets did not contain appropriate evidence that the timesheet was reviewed and approved by a supervisor with direct knowledge of the employee?s activities to support proper allocation to the program. We were able to substantiate the related expenses through additional means to support allocation to the federal program. Failure to ensure all time sheets are appropriately approved by a knowledgeable supervisor could result in unallowable costs being allocated to a federal program and could ultimately result in a questioned cost. We recommend the City review established policies and procedures and ensure all timesheets are appropriately reviewed prior to allocation to a federal program.
2 CFR ?2400.101 gives regulatory effect to the Department of Housing and Urban Development for 2 CFR ?200.303(a) states that the non-Federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in ?Standards for Internal Control in the Federal Government? issued by the Comptroller General of the United States or the ?Internal Control Integrated Framework?, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Furthermore, 2 CFR ?200.430(i)(1)(i) states "charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must be supported by a system of internal controls which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. During testing of payroll expenses for AL #14.218 CDBG Entitlement Grant Cluster, we noted the City utilized employee-completed time-sheets for allocating payroll expenses to the federal program. However, the City?s established internal control procedures did not occur for six out of 40 timesheets. The timesheets did not contain appropriate evidence that the timesheet was reviewed and approved by a supervisor with direct knowledge of the employee?s activities to support proper allocation to the program. We were able to substantiate the related expenses through additional means to support allocation to the federal program. Failure to ensure all time sheets are appropriately approved by a knowledgeable supervisor could result in unallowable costs being allocated to a federal program and could ultimately result in a questioned cost. We recommend the City review established policies and procedures and ensure all timesheets are appropriately reviewed prior to allocation to a federal program.
2 CFR ?2400.101 gives regulatory effect to the Department of Housing and Urban Development for 2 CFR ?200.303(a) states that the non-Federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in ?Standards for Internal Control in the Federal Government? issued by the Comptroller General of the United States or the ?Internal Control Integrated Framework?, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Furthermore, 2 CFR ?200.430(i)(1)(i) states "charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must be supported by a system of internal controls which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. During testing of payroll expenses for AL #14.218 CDBG Entitlement Grant Cluster, we noted the City utilized employee-completed time-sheets for allocating payroll expenses to the federal program. However, the City?s established internal control procedures did not occur for six out of 40 timesheets. The timesheets did not contain appropriate evidence that the timesheet was reviewed and approved by a supervisor with direct knowledge of the employee?s activities to support proper allocation to the program. We were able to substantiate the related expenses through additional means to support allocation to the federal program. Failure to ensure all time sheets are appropriately approved by a knowledgeable supervisor could result in unallowable costs being allocated to a federal program and could ultimately result in a questioned cost. We recommend the City review established policies and procedures and ensure all timesheets are appropriately reviewed prior to allocation to a federal program.
2 CFR ?2400.101 gives regulatory effect to the Department of Housing and Urban Development for 2 CFR ?200.303(a) states that the non-Federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in ?Standards for Internal Control in the Federal Government? issued by the Comptroller General of the United States or the ?Internal Control Integrated Framework?, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Furthermore, 2 CFR ?200.430(i)(1)(i) states "charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must be supported by a system of internal controls which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. During testing of payroll expenses for AL #14.218 CDBG Entitlement Grant Cluster, we noted the City utilized employee-completed time-sheets for allocating payroll expenses to the federal program. However, the City?s established internal control procedures did not occur for six out of 40 timesheets. The timesheets did not contain appropriate evidence that the timesheet was reviewed and approved by a supervisor with direct knowledge of the employee?s activities to support proper allocation to the program. We were able to substantiate the related expenses through additional means to support allocation to the federal program. Failure to ensure all time sheets are appropriately approved by a knowledgeable supervisor could result in unallowable costs being allocated to a federal program and could ultimately result in a questioned cost. We recommend the City review established policies and procedures and ensure all timesheets are appropriately reviewed prior to allocation to a federal program.
2 CFR ?2867.10 gives regulatory effect to the Department of Justice for 2 CFR ?180.305 which states that Non-Federal entities are prohibited from entering into a covered transaction with parties that are suspended or debarred or whose principals are suspended or debarred, unless the Federal agency responsible for the transaction grants an exception under 2 CFR ? 180.135. 2 CFR ?180.200 identifies ?covered transactions? as non-procurement or procurement transactions at the primary tier, between a Federal agency and a person; or at the lower tier, between a participant in a covered transaction and another person. Procurement contracts for goods and services awarded under a non-procurement transaction (e.g., grant or cooperative agreement) are covered transactions if the contracts are expected to equal or exceed $25,000 or meet certain other specified criteria outlined in 2 CFR ? 180.220. All non-procurement transactions (i.e., subawards to subrecipients), irrespective of award amount, are considered covered transactions, unless exempt by 2 CFR ? 180.215. When a non-Federal entity enters a covered transaction, the non-Federal entity must verify that the entity is not suspended or debarred or otherwise excluded. This verification may be accomplished by checking SAM exclusions (http://sam.gov); collecting a certification from the entity, or adding a clause or condition to the covered transactions with that entity. Furthermore, the City of Columbus Purchasing Policy Manual - Bid and Proposal Evaluations - Federal Grants - Special Instructions provides "each department will review its Federal grants program policies and procedures for contract routing and update them immediately to include the following: A SAM.gov website review shall be included as the first page with each original contract scanned into Dynamics 365." The City did not have the proper internal controls in place to verify that all entities, with whom the City had entered covered transactions, had not been suspended or debarred. During testing of the contract expenses for AL #16.922 Equitable Sharing Program Funds grant programs, we noted seven out of eight instances in which the programs had a payment to a vendor of more than $25,000 and no evidence the City checked the SAM exclusions, collected a certification from the entity, or added a clause or condition to the covered transaction with the vendor could be provided. Failing to have the appropriate controls in place may result in vendors who are suspended or debarred receiving federal funds. Prior to contracting with vendors that will be paid with federal funds, the City should verify the vendor is not suspended or debarred by checking the SAM exclusions, collecting a certification from the vendor, or adding a clause or condition to the covered transaction with the vendor.