Audit 32664

FY End
2022-12-31
Total Expended
$2.63M
Findings
20
Programs
5
Organization: City of Tracy (MN)
Year: 2022 Accepted: 2023-07-30

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
34510 2022-001 Significant Deficiency Yes L
34511 2022-002 Significant Deficiency Yes P
34512 2022-001 Significant Deficiency Yes L
34513 2022-002 Significant Deficiency Yes P
34514 2022-001 Significant Deficiency Yes L
34515 2022-002 Significant Deficiency Yes P
34516 2022-001 Significant Deficiency Yes L
34517 2022-002 Significant Deficiency Yes P
34518 2022-001 Significant Deficiency Yes L
34519 2022-002 Significant Deficiency Yes P
610952 2022-001 Significant Deficiency Yes L
610953 2022-002 Significant Deficiency Yes P
610954 2022-001 Significant Deficiency Yes L
610955 2022-002 Significant Deficiency Yes P
610956 2022-001 Significant Deficiency Yes L
610957 2022-002 Significant Deficiency Yes P
610958 2022-001 Significant Deficiency Yes L
610959 2022-002 Significant Deficiency Yes P
610960 2022-001 Significant Deficiency Yes L
610961 2022-002 Significant Deficiency Yes P

Contacts

Name Title Type
LFCEEHFEJQM3 Tyler Twistol Auditee
5072129716 Sara Oberloh Auditor
No contacts on file

Notes to SEFA

Accounting Policies: Basis of Presentation: The accompanying schedule of expenditures of federal awards includes the federal grant activity of City of Tracy 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 Tracy it is not intended to and does not present the financial position, change in net position, or cash flows of the City of Tracy. 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 Tracy 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 Tracy had been approved by the US Department of Agriculture to receive loans in theamount of $18,129,000. The amount listed for the loans includes the beginning of the period loan balance plus proceeds used During the year. The balance owing at December 31, 2022 is $17,800,000. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate.

Finding Details

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 generally accepted accounting principles. 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 generally accepted accounting principles 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 Finding: 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 generally accepted accounting principles. 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 generally accepted accounting principles 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 Finding: 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 generally accepted accounting principles. 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 generally accepted accounting principles 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 Finding: 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 generally accepted accounting principles. 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 generally accepted accounting principles 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 Finding: 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 generally accepted accounting principles. 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 generally accepted accounting principles 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 Finding: 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 generally accepted accounting principles. 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 generally accepted accounting principles 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 Finding: 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 generally accepted accounting principles. 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 generally accepted accounting principles 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 Finding: 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 generally accepted accounting principles. 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 generally accepted accounting principles 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 Finding: 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 generally accepted accounting principles. 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 generally accepted accounting principles 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 Finding: 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 generally accepted accounting principles. 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 generally accepted accounting principles 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 Finding: 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.