Audit 339617

FY End
2024-06-30
Total Expended
$13.89M
Findings
8
Programs
26
Year: 2024 Accepted: 2025-01-24

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
520089 2024-002 Significant Deficiency - L
520090 2024-003 - - B
520091 2024-002 Significant Deficiency - L
520092 2024-003 - - B
1096531 2024-002 Significant Deficiency - L
1096532 2024-003 - - B
1096533 2024-002 Significant Deficiency - L
1096534 2024-003 - - B

Programs

ALN Program Spent Major Findings
21.027 Coronavirus State and Local Fiscal Recovery Fund $5.78M Yes 0
14.218 Community Development Block Grants/entitlement Grants $3.37M Yes 2
14.239 Home Investment Partnerships Program $2.38M - 0
16.710 Public Safety Partnership and Community Policing $556,220 - 0
93.493 Community Funded Projects $210,677 - 0
16.753 Bja- Byrne Discretionary $205,091 - 0
20.600 Cpd Highway Safety Program $191,889 - 0
97.044 Fema Assistance to Firefighters Grant (afg) $137,613 - 0
16.753 Byrne Discretionary Community Project $90,045 - 0
16.922 Equitable Sharing - Justice $78,849 - 0
95.001 Appalachia High Intensity Drug Trafficking Area - Mdent $73,160 - 0
14.218 Community Development Block Grants Cv (cares Act Allocation - July 2020) Entitlement Grants $65,312 Yes 2
93.788 State Opioid Response Program $60,294 - 0
16.838 Bja Comprehensive Opioid Abuse Site-Based Program $55,352 - 0
16.579 Mdent Task Force $50,000 - 0
97.067 Homeland Security - C4 Camera Expansion $42,949 - 0
21.016 Equitable Sharing - Treasury $37,049 - 0
16.302 Federal Bureau of Investigations $30,385 - 0
16.579 Jag Prevention Resource Officers $29,750 - 0
16.738 Edward Byrne Memorial Justice Assistance Grant $27,613 - 0
16.012 Alcohol Tobacco & Firearms $8,819 - 0
16.609 Project Safe Neighborhoods - Nibin $6,923 - 0
14.239 Home Investment Partnerships Program - Cv (american Rescue Act Program) $6,679 - 0
97.067 Homeland Security - Dive Team $5,114 - 0
97.067 Homeland Security - Throw Bags $1,815 - 0
97.067 Homeland Security - Field Force Equipment $0 - 0

Contacts

Name Title Type
FN2TCKTCFG37 Jennifer Vickers, Cpa, Cica Auditee
3043488000 Chris Lambert, Cpa, Cgma, Ccifp Auditor
No contacts on file

Notes to SEFA

Title: NOTE 3 - LOANS OUTSTANDING Accounting Policies: Expenditures reported on the Schedule are reported on the modified 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. De Minimis Rate Used: N Rate Explanation: The City has not elected to use the 10% de minimis indirect cost rate allowed under Section 200.414 of the Uniform Guidance. The City had the following loan balances outstanding at June 30, 2024. Loans outstanding at the beginning of the year and loans made during the year are included as federal expenditures presented in this schedule.
Title: NOTE 4 - BASIS OF PRESENTATION Accounting Policies: Expenditures reported on the Schedule are reported on the modified 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. De Minimis Rate Used: N Rate Explanation: The City has not elected to use the 10% de minimis indirect cost rate allowed under Section 200.414 of the Uniform Guidance. The accompanying schedule of expenditures of federal awards includes the federal award activity of the City under programs of the federal government for the year ended June 30, 2024. 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 (Uniform Guidance). Because the Schedule presents only a selected portion of the operations of the City, it is not intended to and does not present the financial position, changes in net position, or cash flows of the City.

Finding Details

2024‐002 INTERNAL CONTROL DOCUMENTATION Federal Program Information: Federal Agency and Program Name Federal Assistance Listing Number U.S. Department of Housing and Urban Development Community Development Block Grants/Entitlement Grants 14.218 Criteria: 2 CFR 200.303 requires that a non‐federal entity must “(a) 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 and the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).” Condition: The City’s policies provide for review and approval of documentation and reports related to program compliance requirements however, evidence supporting the review for internal control purposes was not consistently documented or retained. Questioned Costs: Unknown Context: Total federal expenditures for the Community Development Block Grants/Entitlement Grants were $3,436,560 for the year ended June 30, 2024. Cause: The City did not retain adequate documentation supporting the review and approval of documentation. Effect: The City may not be in compliance with related program compliance requirements. Recommendation: We recommend that the City enhance their policies to ensure that documentation of review and approvals are maintained as evidence of controls with the specified requirements. Views of Responsible Officials: Management acknowledges the finding. See corrective action plan.
2024–003 ALLOWABILITY‐PAYROLL Federal Program Information: Federal Agency and Program Name Assistance Listing # U.S. Department of Housing and Urban Development Community Development Block Grants/Entitlement Grants 14.218 Criteria: 2 CFR 200.303 requires that a non‐federal entity must “(a) 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 and the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). 2 CFR 200.430(g)(1) states, “Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control that provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the recipient or subrecipient; (iii) Reasonably reflect the total activity for which the employee is compensated by the recipient or subrecipient, not exceeding 100 percent of compensated activities (for IHEs, this is the IBS); (iv) Encompass federally‐assisted and all other activities compensated by the recipient or subrecipient on an integrated basis but may include the use of subsidiary records as defined in the recipient's or subrecipient's written policy; (v) Comply with the established accounting policies and procedures of the recipient or subrecipient (See paragraph (i)(1)(ii) of this section for treatment of incidental work for IHEs.); and (vi) 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 non‐Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. 2 CFR 200.403 indicates that costs must “be consistent with policies and procedures that apply uniformly to both federally‐financed and other activities of the non‐Federal entity” and must “be adequately documented”. Condition: For 6 of the 17 payroll transactions selected for testing the individual’s hourly rate of pay charged to the federal program was not consistent with actual pay rates. Documentation supporting the difference in rate paid and rate reimbursed from the federal program was not available. Questioned Costs: $69 Context: Total federal expenditures for the Community Development Block Grant program were $3,436,560. The 6 payroll transactions represent $8,906 of the total payroll transactions tested of $24,915 for the program. Total payroll charged to the grant was $292,826. Cause: The City does not have adequate internal controls and policies and procedures in place to ensure that the payroll amounts reimbursed from the federal funds correspond to the payroll rates in the underlying payroll accounting records. Effect: The City is not be in compliance with federal statues, regulations, and terms of the conditions of the federal award. Expenditures were paid that are not allowable. The Authority may not identify noncompliance with federal statues, regulations, and terms of the conditions of the federal award including allowability. Recommendation: We recommend that City enhance internal controls to ensure that expenditures charged to the federal awards are properly reviewed and supported. Views of Responsible Officials: Management acknowledges the finding. See corrective action plan.
2024‐002 INTERNAL CONTROL DOCUMENTATION Federal Program Information: Federal Agency and Program Name Federal Assistance Listing Number U.S. Department of Housing and Urban Development Community Development Block Grants/Entitlement Grants 14.218 Criteria: 2 CFR 200.303 requires that a non‐federal entity must “(a) 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 and the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).” Condition: The City’s policies provide for review and approval of documentation and reports related to program compliance requirements however, evidence supporting the review for internal control purposes was not consistently documented or retained. Questioned Costs: Unknown Context: Total federal expenditures for the Community Development Block Grants/Entitlement Grants were $3,436,560 for the year ended June 30, 2024. Cause: The City did not retain adequate documentation supporting the review and approval of documentation. Effect: The City may not be in compliance with related program compliance requirements. Recommendation: We recommend that the City enhance their policies to ensure that documentation of review and approvals are maintained as evidence of controls with the specified requirements. Views of Responsible Officials: Management acknowledges the finding. See corrective action plan.
2024–003 ALLOWABILITY‐PAYROLL Federal Program Information: Federal Agency and Program Name Assistance Listing # U.S. Department of Housing and Urban Development Community Development Block Grants/Entitlement Grants 14.218 Criteria: 2 CFR 200.303 requires that a non‐federal entity must “(a) 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 and the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). 2 CFR 200.430(g)(1) states, “Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control that provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the recipient or subrecipient; (iii) Reasonably reflect the total activity for which the employee is compensated by the recipient or subrecipient, not exceeding 100 percent of compensated activities (for IHEs, this is the IBS); (iv) Encompass federally‐assisted and all other activities compensated by the recipient or subrecipient on an integrated basis but may include the use of subsidiary records as defined in the recipient's or subrecipient's written policy; (v) Comply with the established accounting policies and procedures of the recipient or subrecipient (See paragraph (i)(1)(ii) of this section for treatment of incidental work for IHEs.); and (vi) 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 non‐Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. 2 CFR 200.403 indicates that costs must “be consistent with policies and procedures that apply uniformly to both federally‐financed and other activities of the non‐Federal entity” and must “be adequately documented”. Condition: For 6 of the 17 payroll transactions selected for testing the individual’s hourly rate of pay charged to the federal program was not consistent with actual pay rates. Documentation supporting the difference in rate paid and rate reimbursed from the federal program was not available. Questioned Costs: $69 Context: Total federal expenditures for the Community Development Block Grant program were $3,436,560. The 6 payroll transactions represent $8,906 of the total payroll transactions tested of $24,915 for the program. Total payroll charged to the grant was $292,826. Cause: The City does not have adequate internal controls and policies and procedures in place to ensure that the payroll amounts reimbursed from the federal funds correspond to the payroll rates in the underlying payroll accounting records. Effect: The City is not be in compliance with federal statues, regulations, and terms of the conditions of the federal award. Expenditures were paid that are not allowable. The Authority may not identify noncompliance with federal statues, regulations, and terms of the conditions of the federal award including allowability. Recommendation: We recommend that City enhance internal controls to ensure that expenditures charged to the federal awards are properly reviewed and supported. Views of Responsible Officials: Management acknowledges the finding. See corrective action plan.
2024‐002 INTERNAL CONTROL DOCUMENTATION Federal Program Information: Federal Agency and Program Name Federal Assistance Listing Number U.S. Department of Housing and Urban Development Community Development Block Grants/Entitlement Grants 14.218 Criteria: 2 CFR 200.303 requires that a non‐federal entity must “(a) 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 and the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).” Condition: The City’s policies provide for review and approval of documentation and reports related to program compliance requirements however, evidence supporting the review for internal control purposes was not consistently documented or retained. Questioned Costs: Unknown Context: Total federal expenditures for the Community Development Block Grants/Entitlement Grants were $3,436,560 for the year ended June 30, 2024. Cause: The City did not retain adequate documentation supporting the review and approval of documentation. Effect: The City may not be in compliance with related program compliance requirements. Recommendation: We recommend that the City enhance their policies to ensure that documentation of review and approvals are maintained as evidence of controls with the specified requirements. Views of Responsible Officials: Management acknowledges the finding. See corrective action plan.
2024–003 ALLOWABILITY‐PAYROLL Federal Program Information: Federal Agency and Program Name Assistance Listing # U.S. Department of Housing and Urban Development Community Development Block Grants/Entitlement Grants 14.218 Criteria: 2 CFR 200.303 requires that a non‐federal entity must “(a) 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 and the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). 2 CFR 200.430(g)(1) states, “Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control that provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the recipient or subrecipient; (iii) Reasonably reflect the total activity for which the employee is compensated by the recipient or subrecipient, not exceeding 100 percent of compensated activities (for IHEs, this is the IBS); (iv) Encompass federally‐assisted and all other activities compensated by the recipient or subrecipient on an integrated basis but may include the use of subsidiary records as defined in the recipient's or subrecipient's written policy; (v) Comply with the established accounting policies and procedures of the recipient or subrecipient (See paragraph (i)(1)(ii) of this section for treatment of incidental work for IHEs.); and (vi) 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 non‐Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. 2 CFR 200.403 indicates that costs must “be consistent with policies and procedures that apply uniformly to both federally‐financed and other activities of the non‐Federal entity” and must “be adequately documented”. Condition: For 6 of the 17 payroll transactions selected for testing the individual’s hourly rate of pay charged to the federal program was not consistent with actual pay rates. Documentation supporting the difference in rate paid and rate reimbursed from the federal program was not available. Questioned Costs: $69 Context: Total federal expenditures for the Community Development Block Grant program were $3,436,560. The 6 payroll transactions represent $8,906 of the total payroll transactions tested of $24,915 for the program. Total payroll charged to the grant was $292,826. Cause: The City does not have adequate internal controls and policies and procedures in place to ensure that the payroll amounts reimbursed from the federal funds correspond to the payroll rates in the underlying payroll accounting records. Effect: The City is not be in compliance with federal statues, regulations, and terms of the conditions of the federal award. Expenditures were paid that are not allowable. The Authority may not identify noncompliance with federal statues, regulations, and terms of the conditions of the federal award including allowability. Recommendation: We recommend that City enhance internal controls to ensure that expenditures charged to the federal awards are properly reviewed and supported. Views of Responsible Officials: Management acknowledges the finding. See corrective action plan.
2024‐002 INTERNAL CONTROL DOCUMENTATION Federal Program Information: Federal Agency and Program Name Federal Assistance Listing Number U.S. Department of Housing and Urban Development Community Development Block Grants/Entitlement Grants 14.218 Criteria: 2 CFR 200.303 requires that a non‐federal entity must “(a) 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 and the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).” Condition: The City’s policies provide for review and approval of documentation and reports related to program compliance requirements however, evidence supporting the review for internal control purposes was not consistently documented or retained. Questioned Costs: Unknown Context: Total federal expenditures for the Community Development Block Grants/Entitlement Grants were $3,436,560 for the year ended June 30, 2024. Cause: The City did not retain adequate documentation supporting the review and approval of documentation. Effect: The City may not be in compliance with related program compliance requirements. Recommendation: We recommend that the City enhance their policies to ensure that documentation of review and approvals are maintained as evidence of controls with the specified requirements. Views of Responsible Officials: Management acknowledges the finding. See corrective action plan.
2024–003 ALLOWABILITY‐PAYROLL Federal Program Information: Federal Agency and Program Name Assistance Listing # U.S. Department of Housing and Urban Development Community Development Block Grants/Entitlement Grants 14.218 Criteria: 2 CFR 200.303 requires that a non‐federal entity must “(a) 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 and the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). 2 CFR 200.430(g)(1) states, “Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control that provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the recipient or subrecipient; (iii) Reasonably reflect the total activity for which the employee is compensated by the recipient or subrecipient, not exceeding 100 percent of compensated activities (for IHEs, this is the IBS); (iv) Encompass federally‐assisted and all other activities compensated by the recipient or subrecipient on an integrated basis but may include the use of subsidiary records as defined in the recipient's or subrecipient's written policy; (v) Comply with the established accounting policies and procedures of the recipient or subrecipient (See paragraph (i)(1)(ii) of this section for treatment of incidental work for IHEs.); and (vi) 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 non‐Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. 2 CFR 200.403 indicates that costs must “be consistent with policies and procedures that apply uniformly to both federally‐financed and other activities of the non‐Federal entity” and must “be adequately documented”. Condition: For 6 of the 17 payroll transactions selected for testing the individual’s hourly rate of pay charged to the federal program was not consistent with actual pay rates. Documentation supporting the difference in rate paid and rate reimbursed from the federal program was not available. Questioned Costs: $69 Context: Total federal expenditures for the Community Development Block Grant program were $3,436,560. The 6 payroll transactions represent $8,906 of the total payroll transactions tested of $24,915 for the program. Total payroll charged to the grant was $292,826. Cause: The City does not have adequate internal controls and policies and procedures in place to ensure that the payroll amounts reimbursed from the federal funds correspond to the payroll rates in the underlying payroll accounting records. Effect: The City is not be in compliance with federal statues, regulations, and terms of the conditions of the federal award. Expenditures were paid that are not allowable. The Authority may not identify noncompliance with federal statues, regulations, and terms of the conditions of the federal award including allowability. Recommendation: We recommend that City enhance internal controls to ensure that expenditures charged to the federal awards are properly reviewed and supported. Views of Responsible Officials: Management acknowledges the finding. See corrective action plan.