Audit 301915

FY End
2023-06-30
Total Expended
$1.48M
Findings
8
Programs
13
Organization: Marshall Public Schools (WI)
Year: 2023 Accepted: 2024-04-01

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
391381 2023-001 Material Weakness - P
391382 2023-002 Material Weakness - P
391383 2023-001 Material Weakness - P
391384 2023-002 Material Weakness - P
967823 2023-001 Material Weakness - P
967824 2023-002 Material Weakness - P
967825 2023-001 Material Weakness - P
967826 2023-002 Material Weakness - P

Contacts

Name Title Type
CE5KUCEMVD97 Kristin Wilkinson Auditee
6086553466 Brent Nelson Auditor
No contacts on file

Notes to SEFA

Title: Reporting Entity Accounting Policies: The accounting records for the grant programs are maintained on the modified accrual basis of accounting. Therefore, some amounts presented in these schedules may differ from amounts presented in, or used in preparation of the financial statements. The information in these schedules 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) and the State Single Audit Guidelines. De Minimis Rate Used: N Rate Explanation: The District does not use an indirect cost rate. The accompanying schedules of expenditures of federal and state awards include the federal and state grant activity of the Marshall School District.
Title: Special Education and School Age Parents Program Accounting Policies: The accounting records for the grant programs are maintained on the modified accrual basis of accounting. Therefore, some amounts presented in these schedules may differ from amounts presented in, or used in preparation of the financial statements. The information in these schedules 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) and the State Single Audit Guidelines. De Minimis Rate Used: N Rate Explanation: The District does not use an indirect cost rate. 2022-2023 eligible costs under the State Special Education Program are $1,964,776. The 2023-2024 estimated special education aid is $618,904.
Title: Food Distribution Accounting Policies: The accounting records for the grant programs are maintained on the modified accrual basis of accounting. Therefore, some amounts presented in these schedules may differ from amounts presented in, or used in preparation of the financial statements. The information in these schedules 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) and the State Single Audit Guidelines. De Minimis Rate Used: N Rate Explanation: The District does not use an indirect cost rate. Nonmonetary assistance is reported in the schedule at the fair value of the commodities received and disbursed ($44,386).
Title: Medical Assistance Accounting Policies: The accounting records for the grant programs are maintained on the modified accrual basis of accounting. Therefore, some amounts presented in these schedules may differ from amounts presented in, or used in preparation of the financial statements. The information in these schedules 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) and the State Single Audit Guidelines. De Minimis Rate Used: N Rate Explanation: The District does not use an indirect cost rate. Expenditures presented for the Medicaid SBS Benefit represent only the federal funds for the program that the District receives from DHS. District records should be consulted to determine the total amount expended for this program.
Title: Subrecipients Accounting Policies: The accounting records for the grant programs are maintained on the modified accrual basis of accounting. Therefore, some amounts presented in these schedules may differ from amounts presented in, or used in preparation of the financial statements. The information in these schedules 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) and the State Single Audit Guidelines. De Minimis Rate Used: N Rate Explanation: The District does not use an indirect cost rate. No amounts were passed through to subrecipients.

Finding Details

Finding #2023-001 – Material Audit Adjustments Condition: The auditors proposed audit adjustments that, if not made, would have resulted in the financial statements being materially misstated. Effect: The District’s system of internal control may not prevent, detect, or correct misstatements in the financial statements. 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: Proper financial closing and year-end reconciliation procedures should be in place to identify and adjust the financial records to ensure the financial statements are fairly stated. Recommendation: Policies and procedures should be implemented to ensure account balances are properly recorded and reconciled in a timely manner. Response: The District acknowledges their responsibility for the financial statements and recording of the current year activity. Going forward, the District will verify that all activity is completely and accurately recorded in the financial records and reflected on the financial statements.
Finding #2023-002 – Lack of Financial Close Process and Delayed Accounting Condition: Cash and other accounts were adjusted during the audit process. Many audit journal entries were required to record and adjust activity. Multiple grant claims were not filed throughout the year and large adjustments were needed to record revenues. Effect: Financial reporting from the District’s general ledger could be materially misstated. Delayed grant claims could cause cash flow issues. 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: During the close of the monthly financial statements, other balances should be reconciled to subsidiary detailed listings. Grant claims should be reconciled to the general ledger and submitted throughout the year. Receivables should be recorded as of year end as needed. 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. Reconcile payroll liabilities. Develop procedures to review and submit grant claims throughout the year and reconcile to the general ledger. Response: The District will work to establish procedures to reconcile accounts monthly and grant claims are reconciled and submitted throughout the year.
Finding #2023-001 – Material Audit Adjustments Condition: The auditors proposed audit adjustments that, if not made, would have resulted in the financial statements being materially misstated. Effect: The District’s system of internal control may not prevent, detect, or correct misstatements in the financial statements. 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: Proper financial closing and year-end reconciliation procedures should be in place to identify and adjust the financial records to ensure the financial statements are fairly stated. Recommendation: Policies and procedures should be implemented to ensure account balances are properly recorded and reconciled in a timely manner. Response: The District acknowledges their responsibility for the financial statements and recording of the current year activity. Going forward, the District will verify that all activity is completely and accurately recorded in the financial records and reflected on the financial statements.
Finding #2023-002 – Lack of Financial Close Process and Delayed Accounting Condition: Cash and other accounts were adjusted during the audit process. Many audit journal entries were required to record and adjust activity. Multiple grant claims were not filed throughout the year and large adjustments were needed to record revenues. Effect: Financial reporting from the District’s general ledger could be materially misstated. Delayed grant claims could cause cash flow issues. 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: During the close of the monthly financial statements, other balances should be reconciled to subsidiary detailed listings. Grant claims should be reconciled to the general ledger and submitted throughout the year. Receivables should be recorded as of year end as needed. 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. Reconcile payroll liabilities. Develop procedures to review and submit grant claims throughout the year and reconcile to the general ledger. Response: The District will work to establish procedures to reconcile accounts monthly and grant claims are reconciled and submitted throughout the year.
Finding #2023-001 – Material Audit Adjustments Condition: The auditors proposed audit adjustments that, if not made, would have resulted in the financial statements being materially misstated. Effect: The District’s system of internal control may not prevent, detect, or correct misstatements in the financial statements. 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: Proper financial closing and year-end reconciliation procedures should be in place to identify and adjust the financial records to ensure the financial statements are fairly stated. Recommendation: Policies and procedures should be implemented to ensure account balances are properly recorded and reconciled in a timely manner. Response: The District acknowledges their responsibility for the financial statements and recording of the current year activity. Going forward, the District will verify that all activity is completely and accurately recorded in the financial records and reflected on the financial statements.
Finding #2023-002 – Lack of Financial Close Process and Delayed Accounting Condition: Cash and other accounts were adjusted during the audit process. Many audit journal entries were required to record and adjust activity. Multiple grant claims were not filed throughout the year and large adjustments were needed to record revenues. Effect: Financial reporting from the District’s general ledger could be materially misstated. Delayed grant claims could cause cash flow issues. 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: During the close of the monthly financial statements, other balances should be reconciled to subsidiary detailed listings. Grant claims should be reconciled to the general ledger and submitted throughout the year. Receivables should be recorded as of year end as needed. 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. Reconcile payroll liabilities. Develop procedures to review and submit grant claims throughout the year and reconcile to the general ledger. Response: The District will work to establish procedures to reconcile accounts monthly and grant claims are reconciled and submitted throughout the year.
Finding #2023-001 – Material Audit Adjustments Condition: The auditors proposed audit adjustments that, if not made, would have resulted in the financial statements being materially misstated. Effect: The District’s system of internal control may not prevent, detect, or correct misstatements in the financial statements. 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: Proper financial closing and year-end reconciliation procedures should be in place to identify and adjust the financial records to ensure the financial statements are fairly stated. Recommendation: Policies and procedures should be implemented to ensure account balances are properly recorded and reconciled in a timely manner. Response: The District acknowledges their responsibility for the financial statements and recording of the current year activity. Going forward, the District will verify that all activity is completely and accurately recorded in the financial records and reflected on the financial statements.
Finding #2023-002 – Lack of Financial Close Process and Delayed Accounting Condition: Cash and other accounts were adjusted during the audit process. Many audit journal entries were required to record and adjust activity. Multiple grant claims were not filed throughout the year and large adjustments were needed to record revenues. Effect: Financial reporting from the District’s general ledger could be materially misstated. Delayed grant claims could cause cash flow issues. 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: During the close of the monthly financial statements, other balances should be reconciled to subsidiary detailed listings. Grant claims should be reconciled to the general ledger and submitted throughout the year. Receivables should be recorded as of year end as needed. 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. Reconcile payroll liabilities. Develop procedures to review and submit grant claims throughout the year and reconcile to the general ledger. Response: The District will work to establish procedures to reconcile accounts monthly and grant claims are reconciled and submitted throughout the year.