Audit 49087

FY End
2022-04-30
Total Expended
$3.11M
Findings
12
Programs
1
Organization: Village of Catlin (IL)
Year: 2022 Accepted: 2022-10-31

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
52239 2022-001 Significant Deficiency Yes L
52240 2022-002 Significant Deficiency Yes L
52241 2022-003 Significant Deficiency - L
52242 2022-001 Significant Deficiency Yes L
52243 2022-002 Significant Deficiency Yes L
52244 2022-003 Significant Deficiency - L
628681 2022-001 Significant Deficiency Yes L
628682 2022-002 Significant Deficiency Yes L
628683 2022-003 Significant Deficiency - L
628684 2022-001 Significant Deficiency Yes L
628685 2022-002 Significant Deficiency Yes L
628686 2022-003 Significant Deficiency - L

Programs

ALN Program Spent Major Findings
10.760 Water and Waste Disposal Systems for Rural Communities $895,105 Yes 3

Contacts

Name Title Type
QGGMDBGEMBZ7 Shelley McLain Auditee
2174272136 Karen Crowder Auditor
No contacts on file

Notes to SEFA

Accounting Policies: NOTE ABASIS OF PRESENTATIONThe accompanying schedule of expenditures of federal awards (the Schedule) includes the federal award activity of the Village of Catlin under the Department of Agriculture program of the federal government for the year ended April 30, 2022. 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 Village of Catlin it is not intended to and does not present the financial position, changes in net position, or cash flows of the Village of Catlin.NOTE BSUMMARY OF SIGNIFICANT ACCOUNTING POLICIESExpenditures reported on the Schedule are reported on the modified cash basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance and/or OMB Circular A-87, Cost Principles for State, Local, and Indian Tribal Governments, wherein certain types of expenditures are not allowable or are limited as to reimbursement.NOTE CINDIRECT COST RATEThe Village of Catlin has elected to use the 10% de minimis indirect cost rate as allowed under the Uniform Guidance. NOTE DGRANTING AGENCYS PROGRAMSThe financial statement findings and federal award findings and questioned costs had no effect on the granting agencys programs. There were no related party transactions or other issues with a potentially significant adverse effect on the granting agencys programs.NOTE EGOING CONCERNThere is no going concern or other significant financial difficulty. De Minimis Rate Used: Y Rate Explanation: The auditee used the de minimis cost rate.

Finding Details

FINDING 2022-001 Lack of Segregation of Duties Condition: The Village has a lack of segregation of duties among certain procedures being performed by employees. Criteria: The Village is responsible for establishing and maintaining an internal control system over receipts and disbursements to prevent unintentional or intentional errors, misappropriation of assets, and fraud. Duties should be segregated to provide reasonable assurance that transactions are handled appropriately. Cause: This lack of segregation of duties is caused by the Village?s limited resources to hire additional employees in order to properly segregate duties. Effect: Lack of proper segregation of duties among the Village?s staff could result in intentional or unintentional errors or misappropriations of assets, in which errors or fraud could be material to the financial statements and may not be detected in a timely manner by employees in the normal course of performing their duties. Repeat Finding: This is a repeat finding of prior year; Finding 2021-001 Recommendation: The Village is responsible for establishing and maintaining an internal control system over receipts and disbursements to prevent unintentional or intentional errors, misappropriation of assets, and fraud. Duties should be segregated to provide reasonable assurance that transactions are handled appropriately. Auditors recommend that, since the hiring of additional staff is not feasible, the Village separate duties as much as economically feasible, and alternative controls should be implemented to compensate for lack of segregation of duties. The Village?s Governing Board should provide some of these controls. Views of Responsible Officials: These procedures have been implemented, and the Village Board intends to implement more in the future.
FINDING 2022-002 Qualified Senior Management Condition: Personnel of the Village do not currently possess the skills necessary to draft financial statements and note disclosures in accordance with accounting principles generally accepted in the United States of America. Criteria: Current Government Auditing Standards require the Village to designate a qualified management level individual to be responsible and accountable for overseeing the drafting of the Village?s financial statements and note disclosures in accordance with generally accepted accounting principles (GAAP). Cause: Lack of formal technical training. Effect: The Village?s management may not be able to detect errors or omissions in the application of accounting principles generally accepted in the United States of America with respect to the Village?s financial statements and note disclosures. Repeat Finding: This is a repeat finding of prior year; Finding 2021-002 Recommendation: Since the Current Government Auditing Standards allow the Village to continue to request the auditor to prepare the financial statements and note disclosures; however, the Village is still responsible for having a qualified person capable of overseeing and understanding the complete drafting of the financial statements and note disclosures as well as having the capability of making sure that all adjusting entries, having a material effect on the financial statements, are properly posted to the audit being performed. Views of Responsible Officials: The Village accepts the degree of risk associated with this condition and will continue to have the external auditor assist in the preparation of the financial statements and note disclosures. The Village?s Mayor and Clerk are qualified to oversee and understand the completed draft of the financial statements and note disclosures. The Village Clerk is capable of making sure all adjusting entries, have a material effect on the financial statements, are properly posted prior to the audit being performed. The Village Board, Mayor, and Village Clerk review and approve the draft of the financial statements before the release of the report.
FINDING 2022-003 Water and Wastewater Revenue Balancing Procedures Condition: Revenue from the water/wastewater bills were not reconciled on a monthly basis. Criteria: GAAP requires proper internal control and reconciliation procedures be implemented over revenue to insure revenue is recognized timely and accurately. Cause: Procedures were established in prior years, however, they were not being implemented or reviewed, possibly due to a change in accounting personnel. Effect: Without appropriate internal control, reconciliation, and review procedures, misstatement of revenue could go undetected. Repeat Finding: No Recommendation: Implement and review the reconciliation procedures that were established in prior years. Views of Responsible Officials: Shelley McLain is going to train the new personnel on the reconciliation and review procedures that have been implemented.
FINDING 2022-001 Lack of Segregation of Duties Condition: The Village has a lack of segregation of duties among certain procedures being performed by employees. Criteria: The Village is responsible for establishing and maintaining an internal control system over receipts and disbursements to prevent unintentional or intentional errors, misappropriation of assets, and fraud. Duties should be segregated to provide reasonable assurance that transactions are handled appropriately. Cause: This lack of segregation of duties is caused by the Village?s limited resources to hire additional employees in order to properly segregate duties. Effect: Lack of proper segregation of duties among the Village?s staff could result in intentional or unintentional errors or misappropriations of assets, in which errors or fraud could be material to the financial statements and may not be detected in a timely manner by employees in the normal course of performing their duties. Repeat Finding: This is a repeat finding of prior year; Finding 2021-001 Recommendation: The Village is responsible for establishing and maintaining an internal control system over receipts and disbursements to prevent unintentional or intentional errors, misappropriation of assets, and fraud. Duties should be segregated to provide reasonable assurance that transactions are handled appropriately. Auditors recommend that, since the hiring of additional staff is not feasible, the Village separate duties as much as economically feasible, and alternative controls should be implemented to compensate for lack of segregation of duties. The Village?s Governing Board should provide some of these controls. Views of Responsible Officials: These procedures have been implemented, and the Village Board intends to implement more in the future.
FINDING 2022-002 Qualified Senior Management Condition: Personnel of the Village do not currently possess the skills necessary to draft financial statements and note disclosures in accordance with accounting principles generally accepted in the United States of America. Criteria: Current Government Auditing Standards require the Village to designate a qualified management level individual to be responsible and accountable for overseeing the drafting of the Village?s financial statements and note disclosures in accordance with generally accepted accounting principles (GAAP). Cause: Lack of formal technical training. Effect: The Village?s management may not be able to detect errors or omissions in the application of accounting principles generally accepted in the United States of America with respect to the Village?s financial statements and note disclosures. Repeat Finding: This is a repeat finding of prior year; Finding 2021-002 Recommendation: Since the Current Government Auditing Standards allow the Village to continue to request the auditor to prepare the financial statements and note disclosures; however, the Village is still responsible for having a qualified person capable of overseeing and understanding the complete drafting of the financial statements and note disclosures as well as having the capability of making sure that all adjusting entries, having a material effect on the financial statements, are properly posted to the audit being performed. Views of Responsible Officials: The Village accepts the degree of risk associated with this condition and will continue to have the external auditor assist in the preparation of the financial statements and note disclosures. The Village?s Mayor and Clerk are qualified to oversee and understand the completed draft of the financial statements and note disclosures. The Village Clerk is capable of making sure all adjusting entries, have a material effect on the financial statements, are properly posted prior to the audit being performed. The Village Board, Mayor, and Village Clerk review and approve the draft of the financial statements before the release of the report.
FINDING 2022-003 Water and Wastewater Revenue Balancing Procedures Condition: Revenue from the water/wastewater bills were not reconciled on a monthly basis. Criteria: GAAP requires proper internal control and reconciliation procedures be implemented over revenue to insure revenue is recognized timely and accurately. Cause: Procedures were established in prior years, however, they were not being implemented or reviewed, possibly due to a change in accounting personnel. Effect: Without appropriate internal control, reconciliation, and review procedures, misstatement of revenue could go undetected. Repeat Finding: No Recommendation: Implement and review the reconciliation procedures that were established in prior years. Views of Responsible Officials: Shelley McLain is going to train the new personnel on the reconciliation and review procedures that have been implemented.
FINDING 2022-001 Lack of Segregation of Duties Condition: The Village has a lack of segregation of duties among certain procedures being performed by employees. Criteria: The Village is responsible for establishing and maintaining an internal control system over receipts and disbursements to prevent unintentional or intentional errors, misappropriation of assets, and fraud. Duties should be segregated to provide reasonable assurance that transactions are handled appropriately. Cause: This lack of segregation of duties is caused by the Village?s limited resources to hire additional employees in order to properly segregate duties. Effect: Lack of proper segregation of duties among the Village?s staff could result in intentional or unintentional errors or misappropriations of assets, in which errors or fraud could be material to the financial statements and may not be detected in a timely manner by employees in the normal course of performing their duties. Repeat Finding: This is a repeat finding of prior year; Finding 2021-001 Recommendation: The Village is responsible for establishing and maintaining an internal control system over receipts and disbursements to prevent unintentional or intentional errors, misappropriation of assets, and fraud. Duties should be segregated to provide reasonable assurance that transactions are handled appropriately. Auditors recommend that, since the hiring of additional staff is not feasible, the Village separate duties as much as economically feasible, and alternative controls should be implemented to compensate for lack of segregation of duties. The Village?s Governing Board should provide some of these controls. Views of Responsible Officials: These procedures have been implemented, and the Village Board intends to implement more in the future.
FINDING 2022-002 Qualified Senior Management Condition: Personnel of the Village do not currently possess the skills necessary to draft financial statements and note disclosures in accordance with accounting principles generally accepted in the United States of America. Criteria: Current Government Auditing Standards require the Village to designate a qualified management level individual to be responsible and accountable for overseeing the drafting of the Village?s financial statements and note disclosures in accordance with generally accepted accounting principles (GAAP). Cause: Lack of formal technical training. Effect: The Village?s management may not be able to detect errors or omissions in the application of accounting principles generally accepted in the United States of America with respect to the Village?s financial statements and note disclosures. Repeat Finding: This is a repeat finding of prior year; Finding 2021-002 Recommendation: Since the Current Government Auditing Standards allow the Village to continue to request the auditor to prepare the financial statements and note disclosures; however, the Village is still responsible for having a qualified person capable of overseeing and understanding the complete drafting of the financial statements and note disclosures as well as having the capability of making sure that all adjusting entries, having a material effect on the financial statements, are properly posted to the audit being performed. Views of Responsible Officials: The Village accepts the degree of risk associated with this condition and will continue to have the external auditor assist in the preparation of the financial statements and note disclosures. The Village?s Mayor and Clerk are qualified to oversee and understand the completed draft of the financial statements and note disclosures. The Village Clerk is capable of making sure all adjusting entries, have a material effect on the financial statements, are properly posted prior to the audit being performed. The Village Board, Mayor, and Village Clerk review and approve the draft of the financial statements before the release of the report.
FINDING 2022-003 Water and Wastewater Revenue Balancing Procedures Condition: Revenue from the water/wastewater bills were not reconciled on a monthly basis. Criteria: GAAP requires proper internal control and reconciliation procedures be implemented over revenue to insure revenue is recognized timely and accurately. Cause: Procedures were established in prior years, however, they were not being implemented or reviewed, possibly due to a change in accounting personnel. Effect: Without appropriate internal control, reconciliation, and review procedures, misstatement of revenue could go undetected. Repeat Finding: No Recommendation: Implement and review the reconciliation procedures that were established in prior years. Views of Responsible Officials: Shelley McLain is going to train the new personnel on the reconciliation and review procedures that have been implemented.
FINDING 2022-001 Lack of Segregation of Duties Condition: The Village has a lack of segregation of duties among certain procedures being performed by employees. Criteria: The Village is responsible for establishing and maintaining an internal control system over receipts and disbursements to prevent unintentional or intentional errors, misappropriation of assets, and fraud. Duties should be segregated to provide reasonable assurance that transactions are handled appropriately. Cause: This lack of segregation of duties is caused by the Village?s limited resources to hire additional employees in order to properly segregate duties. Effect: Lack of proper segregation of duties among the Village?s staff could result in intentional or unintentional errors or misappropriations of assets, in which errors or fraud could be material to the financial statements and may not be detected in a timely manner by employees in the normal course of performing their duties. Repeat Finding: This is a repeat finding of prior year; Finding 2021-001 Recommendation: The Village is responsible for establishing and maintaining an internal control system over receipts and disbursements to prevent unintentional or intentional errors, misappropriation of assets, and fraud. Duties should be segregated to provide reasonable assurance that transactions are handled appropriately. Auditors recommend that, since the hiring of additional staff is not feasible, the Village separate duties as much as economically feasible, and alternative controls should be implemented to compensate for lack of segregation of duties. The Village?s Governing Board should provide some of these controls. Views of Responsible Officials: These procedures have been implemented, and the Village Board intends to implement more in the future.
FINDING 2022-002 Qualified Senior Management Condition: Personnel of the Village do not currently possess the skills necessary to draft financial statements and note disclosures in accordance with accounting principles generally accepted in the United States of America. Criteria: Current Government Auditing Standards require the Village to designate a qualified management level individual to be responsible and accountable for overseeing the drafting of the Village?s financial statements and note disclosures in accordance with generally accepted accounting principles (GAAP). Cause: Lack of formal technical training. Effect: The Village?s management may not be able to detect errors or omissions in the application of accounting principles generally accepted in the United States of America with respect to the Village?s financial statements and note disclosures. Repeat Finding: This is a repeat finding of prior year; Finding 2021-002 Recommendation: Since the Current Government Auditing Standards allow the Village to continue to request the auditor to prepare the financial statements and note disclosures; however, the Village is still responsible for having a qualified person capable of overseeing and understanding the complete drafting of the financial statements and note disclosures as well as having the capability of making sure that all adjusting entries, having a material effect on the financial statements, are properly posted to the audit being performed. Views of Responsible Officials: The Village accepts the degree of risk associated with this condition and will continue to have the external auditor assist in the preparation of the financial statements and note disclosures. The Village?s Mayor and Clerk are qualified to oversee and understand the completed draft of the financial statements and note disclosures. The Village Clerk is capable of making sure all adjusting entries, have a material effect on the financial statements, are properly posted prior to the audit being performed. The Village Board, Mayor, and Village Clerk review and approve the draft of the financial statements before the release of the report.
FINDING 2022-003 Water and Wastewater Revenue Balancing Procedures Condition: Revenue from the water/wastewater bills were not reconciled on a monthly basis. Criteria: GAAP requires proper internal control and reconciliation procedures be implemented over revenue to insure revenue is recognized timely and accurately. Cause: Procedures were established in prior years, however, they were not being implemented or reviewed, possibly due to a change in accounting personnel. Effect: Without appropriate internal control, reconciliation, and review procedures, misstatement of revenue could go undetected. Repeat Finding: No Recommendation: Implement and review the reconciliation procedures that were established in prior years. Views of Responsible Officials: Shelley McLain is going to train the new personnel on the reconciliation and review procedures that have been implemented.