Audit 42083

FY End
2022-06-30
Total Expended
$3.77M
Findings
12
Programs
14
Organization: Cedarburg School District (WI)
Year: 2022 Accepted: 2023-01-18

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
48865 2022-001 Material Weakness Yes P
48866 2022-002 Material Weakness Yes P
48867 2022-001 Material Weakness Yes P
48868 2022-002 Material Weakness Yes P
48869 2022-001 Material Weakness - P
48870 2022-002 Material Weakness - P
625307 2022-001 Material Weakness Yes P
625308 2022-002 Material Weakness Yes P
625309 2022-001 Material Weakness Yes P
625310 2022-002 Material Weakness Yes P
625311 2022-001 Material Weakness - P
625312 2022-002 Material Weakness - P

Contacts

Name Title Type
LRRWLSRTCTN5 Ben Irwin Auditee
2623766114 Brent Nelson Auditor
No contacts on file

Notes to SEFA

Title: Subrecipients Accounting Policies: The accompanying schedules of expenditures of federal and state awards includes the federal and state grant activity of the Cedarburg School District and is presented on the accrual basis of accounting. The information in these schedules are presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations (CFR) 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. Therefore, some amounts presented in these schedules 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. There were no awards passed through to subrecipients.
Title: Special Education and School Age Parents Accounting Policies: The accompanying schedules of expenditures of federal and state awards includes the federal and state grant activity of the Cedarburg School District and is presented on the accrual basis of accounting. The information in these schedules are presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations (CFR) 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. Therefore, some amounts presented in these schedules 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. 2021-2022 eligible costs under the Special Education and School Age Parents Program are $4,692,326. The 2022-2023 aid estimate is $1,266,928.

Finding Details

Finding #2022-001 ? Material Adjustments (Prior year finding #2021-001) Condition: Material adjusting journal entries not prepared by the District before the audit were required to record and reconcile account balances. Effect: Financial reports generated by the accounting system may not provide an accurate reflection of the District?s financial position or activities. Not reconciling accounts on a timely basis could lead to errors or other problems not being recognized and resolved. Cause: Financial information was not recorded in a timely manner and material adjustments were needed in order to correct various transactions. Criteria: Material adjusting journal entries not prepared by the District before the audit are considered an internal control weakness. Recommendation: Policies and procedures should be implemented to ensure account balances are properly recorded in a timely manner. Response: The District will work to establish policies and procedures to reduce the materiality of adjusting journal entries proposed by the auditor.
Finding #2022-002 ? Lack of Financial Close Process (Prior year finding #2021-001) Condition: Cash and other accounts were adjusted during the audit process. Many audit journal entries were required to record and adjust activity. During the year and as of June 30, 2022, cash balances on the general ledger had unreconciled differences compared to the bank balances. Effect: Financial reporting from the District?s general ledger could be materially misstated. Cause: The District did not have procedures in place to ensure that all transactions were properly recorded on the general ledger prior to the audit. Criteria: Cash and other accounts should be timely reconciled. General ledger cash balances should be reconciled to the monthly or quarterly bank statements. During the close of the monthly financial statements, other balances should be reconciled to subsidiary detailed listings Recommendation: The District should develop procedures to timely reconcile cash and other balance sheet accounts. The reconciliations should be reviewed by someone other than the person preparing the reconciliations. The reviewer should initial and date the reconciliations when the review is complete. Response: The District will work to establish procedures to reconcile accounts monthly. Timely bank reconciliations are being completed in 2022-2023.
Finding #2022-001 ? Material Adjustments (Prior year finding #2021-001) Condition: Material adjusting journal entries not prepared by the District before the audit were required to record and reconcile account balances. Effect: Financial reports generated by the accounting system may not provide an accurate reflection of the District?s financial position or activities. Not reconciling accounts on a timely basis could lead to errors or other problems not being recognized and resolved. Cause: Financial information was not recorded in a timely manner and material adjustments were needed in order to correct various transactions. Criteria: Material adjusting journal entries not prepared by the District before the audit are considered an internal control weakness. Recommendation: Policies and procedures should be implemented to ensure account balances are properly recorded in a timely manner. Response: The District will work to establish policies and procedures to reduce the materiality of adjusting journal entries proposed by the auditor.
Finding #2022-002 ? Lack of Financial Close Process (Prior year finding #2021-001) Condition: Cash and other accounts were adjusted during the audit process. Many audit journal entries were required to record and adjust activity. During the year and as of June 30, 2022, cash balances on the general ledger had unreconciled differences compared to the bank balances. Effect: Financial reporting from the District?s general ledger could be materially misstated. Cause: The District did not have procedures in place to ensure that all transactions were properly recorded on the general ledger prior to the audit. Criteria: Cash and other accounts should be timely reconciled. General ledger cash balances should be reconciled to the monthly or quarterly bank statements. During the close of the monthly financial statements, other balances should be reconciled to subsidiary detailed listings Recommendation: The District should develop procedures to timely reconcile cash and other balance sheet accounts. The reconciliations should be reviewed by someone other than the person preparing the reconciliations. The reviewer should initial and date the reconciliations when the review is complete. Response: The District will work to establish procedures to reconcile accounts monthly. Timely bank reconciliations are being completed in 2022-2023.
Finding #2022-001 ? Material Adjustments (Prior year finding #2021-001) Condition: Material adjusting journal entries not prepared by the District before the audit were required to record and reconcile account balances. Effect: Financial reports generated by the accounting system may not provide an accurate reflection of the District?s financial position or activities. Not reconciling accounts on a timely basis could lead to errors or other problems not being recognized and resolved. Cause: Financial information was not recorded in a timely manner and material adjustments were needed in order to correct various transactions. Criteria: Material adjusting journal entries not prepared by the District before the audit are considered an internal control weakness. Recommendation: Policies and procedures should be implemented to ensure account balances are properly recorded in a timely manner. Response: The District will work to establish policies and procedures to reduce the materiality of adjusting journal entries proposed by the auditor.
Finding #2022-002 ? Lack of Financial Close Process (Prior year finding #2021-001) Condition: Cash and other accounts were adjusted during the audit process. Many audit journal entries were required to record and adjust activity. During the year and as of June 30, 2022, cash balances on the general ledger had unreconciled differences compared to the bank balances. Effect: Financial reporting from the District?s general ledger could be materially misstated. Cause: The District did not have procedures in place to ensure that all transactions were properly recorded on the general ledger prior to the audit. Criteria: Cash and other accounts should be timely reconciled. General ledger cash balances should be reconciled to the monthly or quarterly bank statements. During the close of the monthly financial statements, other balances should be reconciled to subsidiary detailed listings Recommendation: The District should develop procedures to timely reconcile cash and other balance sheet accounts. The reconciliations should be reviewed by someone other than the person preparing the reconciliations. The reviewer should initial and date the reconciliations when the review is complete. Response: The District will work to establish procedures to reconcile accounts monthly. Timely bank reconciliations are being completed in 2022-2023.
Finding #2022-001 ? Material Adjustments (Prior year finding #2021-001) Condition: Material adjusting journal entries not prepared by the District before the audit were required to record and reconcile account balances. Effect: Financial reports generated by the accounting system may not provide an accurate reflection of the District?s financial position or activities. Not reconciling accounts on a timely basis could lead to errors or other problems not being recognized and resolved. Cause: Financial information was not recorded in a timely manner and material adjustments were needed in order to correct various transactions. Criteria: Material adjusting journal entries not prepared by the District before the audit are considered an internal control weakness. Recommendation: Policies and procedures should be implemented to ensure account balances are properly recorded in a timely manner. Response: The District will work to establish policies and procedures to reduce the materiality of adjusting journal entries proposed by the auditor.
Finding #2022-002 ? Lack of Financial Close Process (Prior year finding #2021-001) Condition: Cash and other accounts were adjusted during the audit process. Many audit journal entries were required to record and adjust activity. During the year and as of June 30, 2022, cash balances on the general ledger had unreconciled differences compared to the bank balances. Effect: Financial reporting from the District?s general ledger could be materially misstated. Cause: The District did not have procedures in place to ensure that all transactions were properly recorded on the general ledger prior to the audit. Criteria: Cash and other accounts should be timely reconciled. General ledger cash balances should be reconciled to the monthly or quarterly bank statements. During the close of the monthly financial statements, other balances should be reconciled to subsidiary detailed listings Recommendation: The District should develop procedures to timely reconcile cash and other balance sheet accounts. The reconciliations should be reviewed by someone other than the person preparing the reconciliations. The reviewer should initial and date the reconciliations when the review is complete. Response: The District will work to establish procedures to reconcile accounts monthly. Timely bank reconciliations are being completed in 2022-2023.
Finding #2022-001 ? Material Adjustments (Prior year finding #2021-001) Condition: Material adjusting journal entries not prepared by the District before the audit were required to record and reconcile account balances. Effect: Financial reports generated by the accounting system may not provide an accurate reflection of the District?s financial position or activities. Not reconciling accounts on a timely basis could lead to errors or other problems not being recognized and resolved. Cause: Financial information was not recorded in a timely manner and material adjustments were needed in order to correct various transactions. Criteria: Material adjusting journal entries not prepared by the District before the audit are considered an internal control weakness. Recommendation: Policies and procedures should be implemented to ensure account balances are properly recorded in a timely manner. Response: The District will work to establish policies and procedures to reduce the materiality of adjusting journal entries proposed by the auditor.
Finding #2022-002 ? Lack of Financial Close Process (Prior year finding #2021-001) Condition: Cash and other accounts were adjusted during the audit process. Many audit journal entries were required to record and adjust activity. During the year and as of June 30, 2022, cash balances on the general ledger had unreconciled differences compared to the bank balances. Effect: Financial reporting from the District?s general ledger could be materially misstated. Cause: The District did not have procedures in place to ensure that all transactions were properly recorded on the general ledger prior to the audit. Criteria: Cash and other accounts should be timely reconciled. General ledger cash balances should be reconciled to the monthly or quarterly bank statements. During the close of the monthly financial statements, other balances should be reconciled to subsidiary detailed listings Recommendation: The District should develop procedures to timely reconcile cash and other balance sheet accounts. The reconciliations should be reviewed by someone other than the person preparing the reconciliations. The reviewer should initial and date the reconciliations when the review is complete. Response: The District will work to establish procedures to reconcile accounts monthly. Timely bank reconciliations are being completed in 2022-2023.
Finding #2022-001 ? Material Adjustments (Prior year finding #2021-001) Condition: Material adjusting journal entries not prepared by the District before the audit were required to record and reconcile account balances. Effect: Financial reports generated by the accounting system may not provide an accurate reflection of the District?s financial position or activities. Not reconciling accounts on a timely basis could lead to errors or other problems not being recognized and resolved. Cause: Financial information was not recorded in a timely manner and material adjustments were needed in order to correct various transactions. Criteria: Material adjusting journal entries not prepared by the District before the audit are considered an internal control weakness. Recommendation: Policies and procedures should be implemented to ensure account balances are properly recorded in a timely manner. Response: The District will work to establish policies and procedures to reduce the materiality of adjusting journal entries proposed by the auditor.
Finding #2022-002 ? Lack of Financial Close Process (Prior year finding #2021-001) Condition: Cash and other accounts were adjusted during the audit process. Many audit journal entries were required to record and adjust activity. During the year and as of June 30, 2022, cash balances on the general ledger had unreconciled differences compared to the bank balances. Effect: Financial reporting from the District?s general ledger could be materially misstated. Cause: The District did not have procedures in place to ensure that all transactions were properly recorded on the general ledger prior to the audit. Criteria: Cash and other accounts should be timely reconciled. General ledger cash balances should be reconciled to the monthly or quarterly bank statements. During the close of the monthly financial statements, other balances should be reconciled to subsidiary detailed listings Recommendation: The District should develop procedures to timely reconcile cash and other balance sheet accounts. The reconciliations should be reviewed by someone other than the person preparing the reconciliations. The reviewer should initial and date the reconciliations when the review is complete. Response: The District will work to establish procedures to reconcile accounts monthly. Timely bank reconciliations are being completed in 2022-2023.