Audit 7223

FY End
2023-06-30
Total Expended
$1.13M
Findings
2
Programs
12
Year: 2023 Accepted: 2023-12-18

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
4977 2023-004 Material Weakness Yes P
581419 2023-004 Material Weakness Yes P

Contacts

Name Title Type
HHKTZ2MQGXN7 Andrea Lee Auditee
6185762722 Suzanne Steckel Auditor
No contacts on file

Notes to SEFA

Title: Subrecipients Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards includes the federal grant activity of Calhoun CUSD 40 and is presented on the cash basis of accounting. The information in this schedule is presented in accordance with the requirements of the Office of Management and Budget Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in the preparation of, the basic financial statements. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. Of the federal expenditures presented in the schedule, Calhoun CUSD 40 did not provide any federal awards to subreceipients.
Title: Non-Cash Assistance Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards includes the federal grant activity of Calhoun CUSD 40 and is presented on the cash basis of accounting. The information in this schedule is presented in accordance with the requirements of the Office of Management and Budget Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in the preparation of, the basic financial statements. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. The following amounts were expended in the form of non-cash assistance by Calhoun CUSD 40 and are included in the Schedule of Expenditures of Federal Awards: NON-CASH COMMODITIES (AL NUMBER 10.555) $18,631. Total non-cash assistance amounts to $18,631.
Title: Other Information Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards includes the federal grant activity of Calhoun CUSD 40 and is presented on the cash basis of accounting. The information in this schedule is presented in accordance with the requirements of the Office of Management and Budget Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in the preparation of, the basic financial statements. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. Calhoun CUSD 40 did not expend any federal awards for insurance coverage, nor did it have any federal loans or loan guarantees in effect at June 30, 2023. Calhoun CUSD 40 did not have federal grants requiring matching expenditures.
Title: Reconciliation of SEFA to Financial Statement Expenditures Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards includes the federal grant activity of Calhoun CUSD 40 and is presented on the cash basis of accounting. The information in this schedule is presented in accordance with the requirements of the Office of Management and Budget Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in the preparation of, the basic financial statements. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. Total expenditures per SEFA $1,134,053 LESS $18,631 government-donated commodities not reported in the financial statements LESS $670 Medicaid Administrative Assessment of 4% not reported in the financial statements EQUALS $1,114,752 total federal expenditures per the statements of revenue received, expenditures disbursed, other financing sources (uses), and changes in fund balance.
Title: Reconciliation of Final Status Column Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards includes the federal grant activity of Calhoun CUSD 40 and is presented on the cash basis of accounting. The information in this schedule is presented in accordance with the requirements of the Office of Management and Budget Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in the preparation of, the basic financial statements. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. 7/1/21-6/30/22 expenditures per SEFA $1,048,312 PLUS 7/1/22-6/30/23 expenditures per SEFA $1,134,053 PLUS obligations/encumbrances $1,528 PLUS 7/1/20-6/30/21 expenditures not on SEFA (ESSER II, 2021-4998-E2, AL 84.425D) $3,419 PLUS 7/1/19-6/30/21 expenditures not on SEFA (Public Assistance Grant, 013-03622-00, AL 97.036) $34,671 EQUALS Final Status per SEFA $2,221,983.

Finding Details

Finding Number 2023-004: Criteria or specific requirement: The accounting function should be controlled by a sufficient number of individuals in order to have adequate segregation of duties. Condition: The District's accounting function is controlled by a limited number of individuals resulting in the inadequate segregation of duties. Context: The District's accounting function is mainly controlled by two individuals. Effect: The limited number of personnel limits the overall effectiveness of internal control. Cause: The District is unable to hire an adequate number of staff to increase the effectiveness of internal control. Recommendation: The District needs to segregate duties where possible and create checks and balances. The Board should be aware of this issue and closely review and approve all financial related information. Management's Response: The District is reviewing its financial policies and procedures to better segregate duties where possible. The Superintendent will make the Board aware of their responsibility in regards to reviewing and approving financial items and asking questions.
Finding Number 2023-004: Criteria or specific requirement: The accounting function should be controlled by a sufficient number of individuals in order to have adequate segregation of duties. Condition: The District's accounting function is controlled by a limited number of individuals resulting in the inadequate segregation of duties. Context: The District's accounting function is mainly controlled by two individuals. Effect: The limited number of personnel limits the overall effectiveness of internal control. Cause: The District is unable to hire an adequate number of staff to increase the effectiveness of internal control. Recommendation: The District needs to segregate duties where possible and create checks and balances. The Board should be aware of this issue and closely review and approve all financial related information. Management's Response: The District is reviewing its financial policies and procedures to better segregate duties where possible. The Superintendent will make the Board aware of their responsibility in regards to reviewing and approving financial items and asking questions.