Audit 27974

FY End
2022-12-31
Total Expended
$995,036
Findings
12
Programs
3
Organization: City of Lake Lillian (MN)
Year: 2022 Accepted: 2023-05-18

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
31130 2022-002 Significant Deficiency Yes P
31131 2022-001 Significant Deficiency Yes L
31132 2022-002 Significant Deficiency Yes P
31133 2022-001 Significant Deficiency Yes L
31134 2022-002 Significant Deficiency Yes P
31135 2022-001 Significant Deficiency Yes L
607572 2022-002 Significant Deficiency Yes P
607573 2022-001 Significant Deficiency Yes L
607574 2022-002 Significant Deficiency Yes P
607575 2022-001 Significant Deficiency Yes L
607576 2022-002 Significant Deficiency Yes P
607577 2022-001 Significant Deficiency Yes L

Programs

ALN Program Spent Major Findings
10.760 Water and Waste Disposal Systems for Rural Communities $966,195 Yes 2
10.766 Community Facilities Loans and Grants $16,000 - 2
21.019 Coronavirus Relief Fund $12,841 - 2

Contacts

Name Title Type
GBGKPNHJX6J4 Kozanna Hirschman Auditee
3206644440 Dennis Oberloh Auditor
No contacts on file

Notes to SEFA

Title: Loans and Loan Guarantees Outstanding Accounting Policies: Basis of Presentation: The accompanying schedule of expenditures of federal awards includes the federal grant activity of City of Lake Lillian under programs of the federal government for the year ended December 31,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 operations of the City of Lake Lillian it is not intended to and does not present the financial position, change in net position, or cash flows of the City of Lake Lillian. Summary of Significant Accounting Policies: Expenditures reported on the Schedule are reported on the regulatory basis of accounting. Such expenditures are recognized following 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, wherein certain types of expenditures are not allowable or are limited as to requirement. The City of Lake Lillian has not elected to use the 10 percent de minimis indirect cost rate as allowed under the Uniform Guidance. Loans and Loan Guarantees Outstanding: The city of Lake Lillian had no outstanding loan and loan guarantees at December 31, 2022. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. The City of Lake Lillian had been approved by the US Department of Agriculture to receive loans in the amount of $1,669,000. The amount listed for the loans includes the beginning of the period loan blaance plus proceeds used during the year. The balance owing at December 31, 2022 is $1,669,000.

Finding Details

Criteria: Internal control that supports the City's ability to initiate, record, process, and report financial data consistent with the assertions of management in the financial statements requires adequate segregation of accounting duties. Condition: The City does not have adequate segregation of accounting duties. Cause: There are a limited number of office employees. Effect or Potential Effect: The lack of adequate segregation of accounting duties could adversely affect the City's ability to initiate, record, process, and report financial data consistent with the assertions of management in the financial statements. Questioned Cost: None. Context: During our audit, we noted the City does not maintain proper separation within the accounting function of the City to ensure proper segregation of accounting duties. Repeat of Prior-Year Finding: 2021-002. Recommendations: For entities of the City's size, it generally is not practical to obtain the internal control that supports the adequate segregation of duties. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the recommendation that it is not cost effective for the City to maintain proper segregation of duties.
Criteria: The City does not have the internal resources to identify all journal entries required to maintain a general ledger and to prepare the full-disclosure financial statements in conformity with regulatory basis of accounting. Condition: The City's Personnel prepare periodic financial information for internal use that meets the needs of management and the City Council. However, the City does not have internal resources to identify all journal entries required to maintain a general ledger and prepare full disclosure financial statements required by regulatory basis of accounting for external reporting. The City is aware of this significant deficiency, and obtains our assistance in the preparation of the City's annual financial statements. Cause: The City does not have the internal expertise needed to handle all aspects of the external financial reporting. Effect or Potential Effect: The City's management is aware of the deficiency and addresses it by reviewing and approving the adjusting journal entries and completed statements prior to distribution to the end users. Questioned Cost: None. Context: During our audit, adjustments were made to the trial balance to prepare financial statements. Repeat of Prior Year Findings:2021-001. Recommendations: For entities of the City's size, it generally is not practical to obtain the internal expertise needed to handle all aspects of the external financial reporting. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the recommendation that it is not cost effective for the City to prepare the financial statements and maintain a working knowledge of the required disclosures.
Criteria: Internal control that supports the City's ability to initiate, record, process, and report financial data consistent with the assertions of management in the financial statements requires adequate segregation of accounting duties. Condition: The City does not have adequate segregation of accounting duties. Cause: There are a limited number of office employees. Effect or Potential Effect: The lack of adequate segregation of accounting duties could adversely affect the City's ability to initiate, record, process, and report financial data consistent with the assertions of management in the financial statements. Questioned Cost: None. Context: During our audit, we noted the City does not maintain proper separation within the accounting function of the City to ensure proper segregation of accounting duties. Repeat of Prior-Year Finding: 2021-002. Recommendations: For entities of the City's size, it generally is not practical to obtain the internal control that supports the adequate segregation of duties. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the recommendation that it is not cost effective for the City to maintain proper segregation of duties.
Criteria: The City does not have the internal resources to identify all journal entries required to maintain a general ledger and to prepare the full-disclosure financial statements in conformity with regulatory basis of accounting. Condition: The City's Personnel prepare periodic financial information for internal use that meets the needs of management and the City Council. However, the City does not have internal resources to identify all journal entries required to maintain a general ledger and prepare full disclosure financial statements required by regulatory basis of accounting for external reporting. The City is aware of this significant deficiency, and obtains our assistance in the preparation of the City's annual financial statements. Cause: The City does not have the internal expertise needed to handle all aspects of the external financial reporting. Effect or Potential Effect: The City's management is aware of the deficiency and addresses it by reviewing and approving the adjusting journal entries and completed statements prior to distribution to the end users. Questioned Cost: None. Context: During our audit, adjustments were made to the trial balance to prepare financial statements. Repeat of Prior Year Findings:2021-001. Recommendations: For entities of the City's size, it generally is not practical to obtain the internal expertise needed to handle all aspects of the external financial reporting. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the recommendation that it is not cost effective for the City to prepare the financial statements and maintain a working knowledge of the required disclosures.
Criteria: Internal control that supports the City's ability to initiate, record, process, and report financial data consistent with the assertions of management in the financial statements requires adequate segregation of accounting duties. Condition: The City does not have adequate segregation of accounting duties. Cause: There are a limited number of office employees. Effect or Potential Effect: The lack of adequate segregation of accounting duties could adversely affect the City's ability to initiate, record, process, and report financial data consistent with the assertions of management in the financial statements. Questioned Cost: None. Context: During our audit, we noted the City does not maintain proper separation within the accounting function of the City to ensure proper segregation of accounting duties. Repeat of Prior-Year Finding: 2021-002. Recommendations: For entities of the City's size, it generally is not practical to obtain the internal control that supports the adequate segregation of duties. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the recommendation that it is not cost effective for the City to maintain proper segregation of duties.
Criteria: The City does not have the internal resources to identify all journal entries required to maintain a general ledger and to prepare the full-disclosure financial statements in conformity with regulatory basis of accounting. Condition: The City's Personnel prepare periodic financial information for internal use that meets the needs of management and the City Council. However, the City does not have internal resources to identify all journal entries required to maintain a general ledger and prepare full disclosure financial statements required by regulatory basis of accounting for external reporting. The City is aware of this significant deficiency, and obtains our assistance in the preparation of the City's annual financial statements. Cause: The City does not have the internal expertise needed to handle all aspects of the external financial reporting. Effect or Potential Effect: The City's management is aware of the deficiency and addresses it by reviewing and approving the adjusting journal entries and completed statements prior to distribution to the end users. Questioned Cost: None. Context: During our audit, adjustments were made to the trial balance to prepare financial statements. Repeat of Prior Year Findings:2021-001. Recommendations: For entities of the City's size, it generally is not practical to obtain the internal expertise needed to handle all aspects of the external financial reporting. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the recommendation that it is not cost effective for the City to prepare the financial statements and maintain a working knowledge of the required disclosures.
Criteria: Internal control that supports the City's ability to initiate, record, process, and report financial data consistent with the assertions of management in the financial statements requires adequate segregation of accounting duties. Condition: The City does not have adequate segregation of accounting duties. Cause: There are a limited number of office employees. Effect or Potential Effect: The lack of adequate segregation of accounting duties could adversely affect the City's ability to initiate, record, process, and report financial data consistent with the assertions of management in the financial statements. Questioned Cost: None. Context: During our audit, we noted the City does not maintain proper separation within the accounting function of the City to ensure proper segregation of accounting duties. Repeat of Prior-Year Finding: 2021-002. Recommendations: For entities of the City's size, it generally is not practical to obtain the internal control that supports the adequate segregation of duties. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the recommendation that it is not cost effective for the City to maintain proper segregation of duties.
Criteria: The City does not have the internal resources to identify all journal entries required to maintain a general ledger and to prepare the full-disclosure financial statements in conformity with regulatory basis of accounting. Condition: The City's Personnel prepare periodic financial information for internal use that meets the needs of management and the City Council. However, the City does not have internal resources to identify all journal entries required to maintain a general ledger and prepare full disclosure financial statements required by regulatory basis of accounting for external reporting. The City is aware of this significant deficiency, and obtains our assistance in the preparation of the City's annual financial statements. Cause: The City does not have the internal expertise needed to handle all aspects of the external financial reporting. Effect or Potential Effect: The City's management is aware of the deficiency and addresses it by reviewing and approving the adjusting journal entries and completed statements prior to distribution to the end users. Questioned Cost: None. Context: During our audit, adjustments were made to the trial balance to prepare financial statements. Repeat of Prior Year Findings:2021-001. Recommendations: For entities of the City's size, it generally is not practical to obtain the internal expertise needed to handle all aspects of the external financial reporting. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the recommendation that it is not cost effective for the City to prepare the financial statements and maintain a working knowledge of the required disclosures.
Criteria: Internal control that supports the City's ability to initiate, record, process, and report financial data consistent with the assertions of management in the financial statements requires adequate segregation of accounting duties. Condition: The City does not have adequate segregation of accounting duties. Cause: There are a limited number of office employees. Effect or Potential Effect: The lack of adequate segregation of accounting duties could adversely affect the City's ability to initiate, record, process, and report financial data consistent with the assertions of management in the financial statements. Questioned Cost: None. Context: During our audit, we noted the City does not maintain proper separation within the accounting function of the City to ensure proper segregation of accounting duties. Repeat of Prior-Year Finding: 2021-002. Recommendations: For entities of the City's size, it generally is not practical to obtain the internal control that supports the adequate segregation of duties. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the recommendation that it is not cost effective for the City to maintain proper segregation of duties.
Criteria: The City does not have the internal resources to identify all journal entries required to maintain a general ledger and to prepare the full-disclosure financial statements in conformity with regulatory basis of accounting. Condition: The City's Personnel prepare periodic financial information for internal use that meets the needs of management and the City Council. However, the City does not have internal resources to identify all journal entries required to maintain a general ledger and prepare full disclosure financial statements required by regulatory basis of accounting for external reporting. The City is aware of this significant deficiency, and obtains our assistance in the preparation of the City's annual financial statements. Cause: The City does not have the internal expertise needed to handle all aspects of the external financial reporting. Effect or Potential Effect: The City's management is aware of the deficiency and addresses it by reviewing and approving the adjusting journal entries and completed statements prior to distribution to the end users. Questioned Cost: None. Context: During our audit, adjustments were made to the trial balance to prepare financial statements. Repeat of Prior Year Findings:2021-001. Recommendations: For entities of the City's size, it generally is not practical to obtain the internal expertise needed to handle all aspects of the external financial reporting. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the recommendation that it is not cost effective for the City to prepare the financial statements and maintain a working knowledge of the required disclosures.
Criteria: Internal control that supports the City's ability to initiate, record, process, and report financial data consistent with the assertions of management in the financial statements requires adequate segregation of accounting duties. Condition: The City does not have adequate segregation of accounting duties. Cause: There are a limited number of office employees. Effect or Potential Effect: The lack of adequate segregation of accounting duties could adversely affect the City's ability to initiate, record, process, and report financial data consistent with the assertions of management in the financial statements. Questioned Cost: None. Context: During our audit, we noted the City does not maintain proper separation within the accounting function of the City to ensure proper segregation of accounting duties. Repeat of Prior-Year Finding: 2021-002. Recommendations: For entities of the City's size, it generally is not practical to obtain the internal control that supports the adequate segregation of duties. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the recommendation that it is not cost effective for the City to maintain proper segregation of duties.
Criteria: The City does not have the internal resources to identify all journal entries required to maintain a general ledger and to prepare the full-disclosure financial statements in conformity with regulatory basis of accounting. Condition: The City's Personnel prepare periodic financial information for internal use that meets the needs of management and the City Council. However, the City does not have internal resources to identify all journal entries required to maintain a general ledger and prepare full disclosure financial statements required by regulatory basis of accounting for external reporting. The City is aware of this significant deficiency, and obtains our assistance in the preparation of the City's annual financial statements. Cause: The City does not have the internal expertise needed to handle all aspects of the external financial reporting. Effect or Potential Effect: The City's management is aware of the deficiency and addresses it by reviewing and approving the adjusting journal entries and completed statements prior to distribution to the end users. Questioned Cost: None. Context: During our audit, adjustments were made to the trial balance to prepare financial statements. Repeat of Prior Year Findings:2021-001. Recommendations: For entities of the City's size, it generally is not practical to obtain the internal expertise needed to handle all aspects of the external financial reporting. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the recommendation that it is not cost effective for the City to prepare the financial statements and maintain a working knowledge of the required disclosures.