FAC Explorer

Audit 308306

FY End
2023-12-31
Total Expended
$1.11M
Findings
12
Programs
4
Organization: City of Peshtigo (WI)
Year: 2023 Accepted: 2024-06-06
Auditor: Cliftonlarsonallen LLP

Organization Exclusion Status:

Findings

ID Ref Severity Repeat Requirement
400166 2023-004 Material Weakness - I
400167 2023-005 Significant Deficiency - I
400168 2023-004 Material Weakness - I
400169 2023-005 Significant Deficiency - I
400170 2023-004 Material Weakness - I
400171 2023-005 Significant Deficiency - I
976608 2023-004 Material Weakness - I
976609 2023-005 Significant Deficiency - I
976610 2023-004 Material Weakness - I
976611 2023-005 Significant Deficiency - I
976612 2023-004 Material Weakness - I
976613 2023-005 Significant Deficiency - I

Programs

ALN Program Spent Major Findings
21.027 Covid-19: Neighborhood Investment Fund Grant $744,921 Yes 2
21.027 Covid-19: American Rescue Plan Act $301,730 Yes 2
15.916 Land and Water Conservation Fund Aids $59,349 - 0
21.027 Covid-19: Law Enforcement Agency Grant $7,490 Yes 2

Contacts

Name Title Type
JWTNR3TP7F25 Tammy Kasal Auditee
7155823041 Scott Sternhagen Auditor
No contacts on file

Notes to SEFA

Title: BASIS OF PRESENTATION Accounting Policies: Revenues and expenditures in the schedules are presented in accordance with the modified accrual basis of accounting and are generally in agreement with revenues and expenditures reported in the City’s 2023 fund financial statements. Such expenditures are recognized following the cost principals contained in Uniform Guidance and the State Single Audit Guidelines, where in certain types of expenditures are not allowable or are limited as to reimbursement. Federal Assistance Listing Number 21.027 follows criteria determined by the Department of Treasury for allowability of costs. Accrued revenue at year-end consists of federal and state program expenditures scheduled for reimbursement to the City in the succeeding year while unearned revenue represents advances for federal and state programs that exceed recorded City expenditures. Because of subsequent program adjustments, these amounts may differ from the prior year’s ending balances. De Minimis Rate Used: N Rate Explanation: The City has not elected to charge a de minimis rate of 10% of modified total costs. The accompanying schedules of expenditures of federal and state awards for the City are 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) and the State Single Audit Guidelines issued by the Wisconsin Department of Administration. The schedules of expenditures of federal and state awards include all federal and state awards of the City. Because the schedules present 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.
Title: OVERSIGHT AGENCIES Accounting Policies: Revenues and expenditures in the schedules are presented in accordance with the modified accrual basis of accounting and are generally in agreement with revenues and expenditures reported in the City’s 2023 fund financial statements. Such expenditures are recognized following the cost principals contained in Uniform Guidance and the State Single Audit Guidelines, where in certain types of expenditures are not allowable or are limited as to reimbursement. Federal Assistance Listing Number 21.027 follows criteria determined by the Department of Treasury for allowability of costs. Accrued revenue at year-end consists of federal and state program expenditures scheduled for reimbursement to the City in the succeeding year while unearned revenue represents advances for federal and state programs that exceed recorded City expenditures. Because of subsequent program adjustments, these amounts may differ from the prior year’s ending balances. De Minimis Rate Used: N Rate Explanation: The City has not elected to charge a de minimis rate of 10% of modified total costs. The federal and state oversight agencies for the City are as follows: Federal - U.S. Department of Treasury State - Wisconsin Department of Natural Resources
Title: PASS THROUGH ENTITIES Accounting Policies: Revenues and expenditures in the schedules are presented in accordance with the modified accrual basis of accounting and are generally in agreement with revenues and expenditures reported in the City’s 2023 fund financial statements. Such expenditures are recognized following the cost principals contained in Uniform Guidance and the State Single Audit Guidelines, where in certain types of expenditures are not allowable or are limited as to reimbursement. Federal Assistance Listing Number 21.027 follows criteria determined by the Department of Treasury for allowability of costs. Accrued revenue at year-end consists of federal and state program expenditures scheduled for reimbursement to the City in the succeeding year while unearned revenue represents advances for federal and state programs that exceed recorded City expenditures. Because of subsequent program adjustments, these amounts may differ from the prior year’s ending balances. De Minimis Rate Used: N Rate Explanation: The City has not elected to charge a de minimis rate of 10% of modified total costs. Federal awards have been passed through the following entities: WI DNR - Wisconsin Department of Natural Resources WI DOA - Wisconsin Department of Administration

Finding Details

Finding 2023-004
2023-004 – Federal Grants Management - Procurement Policy – Suspension and Debarment Federal Agency: U.S. Department of Treasury Federal Program Name: Coronavirus State and Local Fiscal Recovery Funds Assistance Listing Number: 21.027 Federal Award Identification Number and Year: SLFRP0135 – 2021 Pass-Through Agency: Wisconsin Department of Administration Pass-Through Number(s): ARPA-NIF-072 Award Period: March 3, 2021 through December 31, 2024 Type of Finding: • Material Weakness in Internal Control over Compliance and Other Matter Criteria or specific requirement: 2 CFR Part 200 Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Award requires compliance with the provisions of procurement, suspension, and debarment. The City should have internal controls designed to ensure compliance with those provisions. Condition: The City did not follow controls related to ensuring suspension and debarment status was verified prior to entering into contract with vendors. Questioned Costs: None Context: During our testing, it was noted that the City was not reviewing vendors prior to entering into a contract with a vendor to ensure the vendor was not on the suspended or debarred vendor list maintained by the General Services Administration. Cause: The City was unaware the contractors were not being reviewed to ensure they were not suspended or debarred. Effect: The auditor noted no instances of noncompliance with the provisions of procurement, suspension, and debarment; however, the lack of internal controls over these compliance requirements provides an opportunity for noncompliance. Repeat Finding: The finding is not a repeat of a finding in the immediately prior year. Recommendation: We recommend the City design controls to ensure an adequate review process is in place to review potential contractors to determine they are not suspended or debarred. Views of responsible officials: There is no disagreement with the audit finding.
Finding 2023-005
Federal Agency: U.S. Department of Treasury Federal Program Name: Coronavirus State and Local Fiscal Recovery Funds Assistance Listing Number: 21.027 Federal Award Identification Number and Year: SLFRP0135 – 2021 Pass-Through Agency: Wisconsin Department of Administration Pass-Through Number(s): ARPA-NIF-072 Award Period: March 3, 2021 through December 31, 2024 Type of Finding: • Significant Deficiency in Internal Control over Compliance and Other Matter Criteria or specific requirement: 2 CFR 200.320 Methods of Procurement state that if the small purchases method is used, price or rate quotations must be obtained from an adequate number of qualified sources. The City should have internal controls designed to ensure compliance with those provisions. Condition: The City did not follow controls related to ensuring procurement policies were followed. Questioned Costs: None Context: There were 55 transactions that exceeded procurement thresholds during the granting period. The sample size selected tested was 19. During our testing, it was noted on 6 of the 19 items tested that the City was not following the requirements under the adopted procurement policies. Cause: The City did not follow the requirements under the adopted procurement policies. Effect: The County is not in compliance with procurement requirements. Contracts for construction, non- construction related procurements, and those over the simplified acquisition threshold may not be in compliance with the Uniform Guidance. Repeat Finding: The finding is not a repeat of a finding in the immediately prior year. Recommendation: We recommend the City design controls to ensure an adequate review process is in place to review potential contractors to determine they are not suspended or debarred. Views of responsible officials: There is no disagreement with the audit finding.
Finding 2023-004
2023-004 – Federal Grants Management - Procurement Policy – Suspension and Debarment Federal Agency: U.S. Department of Treasury Federal Program Name: Coronavirus State and Local Fiscal Recovery Funds Assistance Listing Number: 21.027 Federal Award Identification Number and Year: SLFRP0135 – 2021 Pass-Through Agency: Wisconsin Department of Administration Pass-Through Number(s): ARPA-NIF-072 Award Period: March 3, 2021 through December 31, 2024 Type of Finding: • Material Weakness in Internal Control over Compliance and Other Matter Criteria or specific requirement: 2 CFR Part 200 Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Award requires compliance with the provisions of procurement, suspension, and debarment. The City should have internal controls designed to ensure compliance with those provisions. Condition: The City did not follow controls related to ensuring suspension and debarment status was verified prior to entering into contract with vendors. Questioned Costs: None Context: During our testing, it was noted that the City was not reviewing vendors prior to entering into a contract with a vendor to ensure the vendor was not on the suspended or debarred vendor list maintained by the General Services Administration. Cause: The City was unaware the contractors were not being reviewed to ensure they were not suspended or debarred. Effect: The auditor noted no instances of noncompliance with the provisions of procurement, suspension, and debarment; however, the lack of internal controls over these compliance requirements provides an opportunity for noncompliance. Repeat Finding: The finding is not a repeat of a finding in the immediately prior year. Recommendation: We recommend the City design controls to ensure an adequate review process is in place to review potential contractors to determine they are not suspended or debarred. Views of responsible officials: There is no disagreement with the audit finding.
Finding 2023-005
Federal Agency: U.S. Department of Treasury Federal Program Name: Coronavirus State and Local Fiscal Recovery Funds Assistance Listing Number: 21.027 Federal Award Identification Number and Year: SLFRP0135 – 2021 Pass-Through Agency: Wisconsin Department of Administration Pass-Through Number(s): ARPA-NIF-072 Award Period: March 3, 2021 through December 31, 2024 Type of Finding: • Significant Deficiency in Internal Control over Compliance and Other Matter Criteria or specific requirement: 2 CFR 200.320 Methods of Procurement state that if the small purchases method is used, price or rate quotations must be obtained from an adequate number of qualified sources. The City should have internal controls designed to ensure compliance with those provisions. Condition: The City did not follow controls related to ensuring procurement policies were followed. Questioned Costs: None Context: There were 55 transactions that exceeded procurement thresholds during the granting period. The sample size selected tested was 19. During our testing, it was noted on 6 of the 19 items tested that the City was not following the requirements under the adopted procurement policies. Cause: The City did not follow the requirements under the adopted procurement policies. Effect: The County is not in compliance with procurement requirements. Contracts for construction, non- construction related procurements, and those over the simplified acquisition threshold may not be in compliance with the Uniform Guidance. Repeat Finding: The finding is not a repeat of a finding in the immediately prior year. Recommendation: We recommend the City design controls to ensure an adequate review process is in place to review potential contractors to determine they are not suspended or debarred. Views of responsible officials: There is no disagreement with the audit finding.
Finding 2023-004
2023-004 – Federal Grants Management - Procurement Policy – Suspension and Debarment Federal Agency: U.S. Department of Treasury Federal Program Name: Coronavirus State and Local Fiscal Recovery Funds Assistance Listing Number: 21.027 Federal Award Identification Number and Year: SLFRP0135 – 2021 Pass-Through Agency: Wisconsin Department of Administration Pass-Through Number(s): ARPA-NIF-072 Award Period: March 3, 2021 through December 31, 2024 Type of Finding: • Material Weakness in Internal Control over Compliance and Other Matter Criteria or specific requirement: 2 CFR Part 200 Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Award requires compliance with the provisions of procurement, suspension, and debarment. The City should have internal controls designed to ensure compliance with those provisions. Condition: The City did not follow controls related to ensuring suspension and debarment status was verified prior to entering into contract with vendors. Questioned Costs: None Context: During our testing, it was noted that the City was not reviewing vendors prior to entering into a contract with a vendor to ensure the vendor was not on the suspended or debarred vendor list maintained by the General Services Administration. Cause: The City was unaware the contractors were not being reviewed to ensure they were not suspended or debarred. Effect: The auditor noted no instances of noncompliance with the provisions of procurement, suspension, and debarment; however, the lack of internal controls over these compliance requirements provides an opportunity for noncompliance. Repeat Finding: The finding is not a repeat of a finding in the immediately prior year. Recommendation: We recommend the City design controls to ensure an adequate review process is in place to review potential contractors to determine they are not suspended or debarred. Views of responsible officials: There is no disagreement with the audit finding.
Finding 2023-005
Federal Agency: U.S. Department of Treasury Federal Program Name: Coronavirus State and Local Fiscal Recovery Funds Assistance Listing Number: 21.027 Federal Award Identification Number and Year: SLFRP0135 – 2021 Pass-Through Agency: Wisconsin Department of Administration Pass-Through Number(s): ARPA-NIF-072 Award Period: March 3, 2021 through December 31, 2024 Type of Finding: • Significant Deficiency in Internal Control over Compliance and Other Matter Criteria or specific requirement: 2 CFR 200.320 Methods of Procurement state that if the small purchases method is used, price or rate quotations must be obtained from an adequate number of qualified sources. The City should have internal controls designed to ensure compliance with those provisions. Condition: The City did not follow controls related to ensuring procurement policies were followed. Questioned Costs: None Context: There were 55 transactions that exceeded procurement thresholds during the granting period. The sample size selected tested was 19. During our testing, it was noted on 6 of the 19 items tested that the City was not following the requirements under the adopted procurement policies. Cause: The City did not follow the requirements under the adopted procurement policies. Effect: The County is not in compliance with procurement requirements. Contracts for construction, non- construction related procurements, and those over the simplified acquisition threshold may not be in compliance with the Uniform Guidance. Repeat Finding: The finding is not a repeat of a finding in the immediately prior year. Recommendation: We recommend the City design controls to ensure an adequate review process is in place to review potential contractors to determine they are not suspended or debarred. Views of responsible officials: There is no disagreement with the audit finding.
Finding 2023-004
2023-004 – Federal Grants Management - Procurement Policy – Suspension and Debarment Federal Agency: U.S. Department of Treasury Federal Program Name: Coronavirus State and Local Fiscal Recovery Funds Assistance Listing Number: 21.027 Federal Award Identification Number and Year: SLFRP0135 – 2021 Pass-Through Agency: Wisconsin Department of Administration Pass-Through Number(s): ARPA-NIF-072 Award Period: March 3, 2021 through December 31, 2024 Type of Finding: • Material Weakness in Internal Control over Compliance and Other Matter Criteria or specific requirement: 2 CFR Part 200 Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Award requires compliance with the provisions of procurement, suspension, and debarment. The City should have internal controls designed to ensure compliance with those provisions. Condition: The City did not follow controls related to ensuring suspension and debarment status was verified prior to entering into contract with vendors. Questioned Costs: None Context: During our testing, it was noted that the City was not reviewing vendors prior to entering into a contract with a vendor to ensure the vendor was not on the suspended or debarred vendor list maintained by the General Services Administration. Cause: The City was unaware the contractors were not being reviewed to ensure they were not suspended or debarred. Effect: The auditor noted no instances of noncompliance with the provisions of procurement, suspension, and debarment; however, the lack of internal controls over these compliance requirements provides an opportunity for noncompliance. Repeat Finding: The finding is not a repeat of a finding in the immediately prior year. Recommendation: We recommend the City design controls to ensure an adequate review process is in place to review potential contractors to determine they are not suspended or debarred. Views of responsible officials: There is no disagreement with the audit finding.
Finding 2023-005
Federal Agency: U.S. Department of Treasury Federal Program Name: Coronavirus State and Local Fiscal Recovery Funds Assistance Listing Number: 21.027 Federal Award Identification Number and Year: SLFRP0135 – 2021 Pass-Through Agency: Wisconsin Department of Administration Pass-Through Number(s): ARPA-NIF-072 Award Period: March 3, 2021 through December 31, 2024 Type of Finding: • Significant Deficiency in Internal Control over Compliance and Other Matter Criteria or specific requirement: 2 CFR 200.320 Methods of Procurement state that if the small purchases method is used, price or rate quotations must be obtained from an adequate number of qualified sources. The City should have internal controls designed to ensure compliance with those provisions. Condition: The City did not follow controls related to ensuring procurement policies were followed. Questioned Costs: None Context: There were 55 transactions that exceeded procurement thresholds during the granting period. The sample size selected tested was 19. During our testing, it was noted on 6 of the 19 items tested that the City was not following the requirements under the adopted procurement policies. Cause: The City did not follow the requirements under the adopted procurement policies. Effect: The County is not in compliance with procurement requirements. Contracts for construction, non- construction related procurements, and those over the simplified acquisition threshold may not be in compliance with the Uniform Guidance. Repeat Finding: The finding is not a repeat of a finding in the immediately prior year. Recommendation: We recommend the City design controls to ensure an adequate review process is in place to review potential contractors to determine they are not suspended or debarred. Views of responsible officials: There is no disagreement with the audit finding.
Finding 2023-004
2023-004 – Federal Grants Management - Procurement Policy – Suspension and Debarment Federal Agency: U.S. Department of Treasury Federal Program Name: Coronavirus State and Local Fiscal Recovery Funds Assistance Listing Number: 21.027 Federal Award Identification Number and Year: SLFRP0135 – 2021 Pass-Through Agency: Wisconsin Department of Administration Pass-Through Number(s): ARPA-NIF-072 Award Period: March 3, 2021 through December 31, 2024 Type of Finding: • Material Weakness in Internal Control over Compliance and Other Matter Criteria or specific requirement: 2 CFR Part 200 Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Award requires compliance with the provisions of procurement, suspension, and debarment. The City should have internal controls designed to ensure compliance with those provisions. Condition: The City did not follow controls related to ensuring suspension and debarment status was verified prior to entering into contract with vendors. Questioned Costs: None Context: During our testing, it was noted that the City was not reviewing vendors prior to entering into a contract with a vendor to ensure the vendor was not on the suspended or debarred vendor list maintained by the General Services Administration. Cause: The City was unaware the contractors were not being reviewed to ensure they were not suspended or debarred. Effect: The auditor noted no instances of noncompliance with the provisions of procurement, suspension, and debarment; however, the lack of internal controls over these compliance requirements provides an opportunity for noncompliance. Repeat Finding: The finding is not a repeat of a finding in the immediately prior year. Recommendation: We recommend the City design controls to ensure an adequate review process is in place to review potential contractors to determine they are not suspended or debarred. Views of responsible officials: There is no disagreement with the audit finding.
Finding 2023-005
Federal Agency: U.S. Department of Treasury Federal Program Name: Coronavirus State and Local Fiscal Recovery Funds Assistance Listing Number: 21.027 Federal Award Identification Number and Year: SLFRP0135 – 2021 Pass-Through Agency: Wisconsin Department of Administration Pass-Through Number(s): ARPA-NIF-072 Award Period: March 3, 2021 through December 31, 2024 Type of Finding: • Significant Deficiency in Internal Control over Compliance and Other Matter Criteria or specific requirement: 2 CFR 200.320 Methods of Procurement state that if the small purchases method is used, price or rate quotations must be obtained from an adequate number of qualified sources. The City should have internal controls designed to ensure compliance with those provisions. Condition: The City did not follow controls related to ensuring procurement policies were followed. Questioned Costs: None Context: There were 55 transactions that exceeded procurement thresholds during the granting period. The sample size selected tested was 19. During our testing, it was noted on 6 of the 19 items tested that the City was not following the requirements under the adopted procurement policies. Cause: The City did not follow the requirements under the adopted procurement policies. Effect: The County is not in compliance with procurement requirements. Contracts for construction, non- construction related procurements, and those over the simplified acquisition threshold may not be in compliance with the Uniform Guidance. Repeat Finding: The finding is not a repeat of a finding in the immediately prior year. Recommendation: We recommend the City design controls to ensure an adequate review process is in place to review potential contractors to determine they are not suspended or debarred. Views of responsible officials: There is no disagreement with the audit finding.
Finding 2023-004
2023-004 – Federal Grants Management - Procurement Policy – Suspension and Debarment Federal Agency: U.S. Department of Treasury Federal Program Name: Coronavirus State and Local Fiscal Recovery Funds Assistance Listing Number: 21.027 Federal Award Identification Number and Year: SLFRP0135 – 2021 Pass-Through Agency: Wisconsin Department of Administration Pass-Through Number(s): ARPA-NIF-072 Award Period: March 3, 2021 through December 31, 2024 Type of Finding: • Material Weakness in Internal Control over Compliance and Other Matter Criteria or specific requirement: 2 CFR Part 200 Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Award requires compliance with the provisions of procurement, suspension, and debarment. The City should have internal controls designed to ensure compliance with those provisions. Condition: The City did not follow controls related to ensuring suspension and debarment status was verified prior to entering into contract with vendors. Questioned Costs: None Context: During our testing, it was noted that the City was not reviewing vendors prior to entering into a contract with a vendor to ensure the vendor was not on the suspended or debarred vendor list maintained by the General Services Administration. Cause: The City was unaware the contractors were not being reviewed to ensure they were not suspended or debarred. Effect: The auditor noted no instances of noncompliance with the provisions of procurement, suspension, and debarment; however, the lack of internal controls over these compliance requirements provides an opportunity for noncompliance. Repeat Finding: The finding is not a repeat of a finding in the immediately prior year. Recommendation: We recommend the City design controls to ensure an adequate review process is in place to review potential contractors to determine they are not suspended or debarred. Views of responsible officials: There is no disagreement with the audit finding.
Finding 2023-005
Federal Agency: U.S. Department of Treasury Federal Program Name: Coronavirus State and Local Fiscal Recovery Funds Assistance Listing Number: 21.027 Federal Award Identification Number and Year: SLFRP0135 – 2021 Pass-Through Agency: Wisconsin Department of Administration Pass-Through Number(s): ARPA-NIF-072 Award Period: March 3, 2021 through December 31, 2024 Type of Finding: • Significant Deficiency in Internal Control over Compliance and Other Matter Criteria or specific requirement: 2 CFR 200.320 Methods of Procurement state that if the small purchases method is used, price or rate quotations must be obtained from an adequate number of qualified sources. The City should have internal controls designed to ensure compliance with those provisions. Condition: The City did not follow controls related to ensuring procurement policies were followed. Questioned Costs: None Context: There were 55 transactions that exceeded procurement thresholds during the granting period. The sample size selected tested was 19. During our testing, it was noted on 6 of the 19 items tested that the City was not following the requirements under the adopted procurement policies. Cause: The City did not follow the requirements under the adopted procurement policies. Effect: The County is not in compliance with procurement requirements. Contracts for construction, non- construction related procurements, and those over the simplified acquisition threshold may not be in compliance with the Uniform Guidance. Repeat Finding: The finding is not a repeat of a finding in the immediately prior year. Recommendation: We recommend the City design controls to ensure an adequate review process is in place to review potential contractors to determine they are not suspended or debarred. Views of responsible officials: There is no disagreement with the audit finding.