FAC Explorer

Audit 327318

FY End
2024-06-30
Total Expended
$1.07M
Findings
10
Programs
10
Organization: Mason Consolidated Schools (MI)
Year: 2024 Accepted: 2024-11-05
Auditor: Calkins Hehl Rafko Cpa's PLLC

Organization Exclusion Status:

Findings

ID Ref Severity Repeat Requirement
504702 2024-006 Material Weakness - L
504703 2024-006 Material Weakness - L
504704 2024-006 Material Weakness - L
504705 2024-006 Material Weakness - L
504706 2024-006 Material Weakness - L
1081144 2024-006 Material Weakness - L
1081145 2024-006 Material Weakness - L
1081146 2024-006 Material Weakness - L
1081147 2024-006 Material Weakness - L
1081148 2024-006 Material Weakness - L

Programs

ALN Program Spent Major Findings
10.553 School Breakfast Program $122,562 Yes 1
84.010 Title I Grants to Local Educational Agencies $117,891 - 0
84.424 Student Support and Academic Enrichment Program $19,560 - 0
84.425 Education Stabilization Fund $9,968 - 0
21.027 Coronavirus State and Local Fiscal Recovery Funds $8,861 - 0
93.778 Medical Assistance Program $4,204 - 0
84.367 Supporting Effective Instruction State Grants (formerly Improving Teacher Quality State Grants) $4,048 - 0
10.558 Child and Adult Care Food Program $1,218 - 0
84.060 Indian Education Grants to Local Educational Agencies $991 - 0
10.555 National School Lunch Program $241 Yes 1

Contacts

Name Title Type
RJN2C9KGGP85 Dawn Nieuwkoop Auditee
7348489302 Sarah Rafko Auditor
No contacts on file

Notes to SEFA

Title: GRANT AUDITOR REPORT Accounting Policies: The accompanying schedule of expenditures of federal awards (the Schedule) includes the federal award activity of Mason Consolidated Schools under programs of the federal government for the year ended June 30, 2024. 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 the operations of Mason Consolidated Schools, it is not intended to and does not present the financial position, changes in net position, or cash flows of Mason Consolidated Schools. Expenditures reported on the Schedule are reported on the modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as a reimbursement. Cash received is recorded on a cash basis. Revenues are recognized when qualifying expenditures have been incurred and all grant requirements have been met. De Minimis Rate Used: N Rate Explanation: Mason Consolidated Schools has elected not to use the 10% de minimis indirect cost rate as allowed under the Uniform Guidance. Management has utilized the Michigan Department of Education NexSys Grant Auditor Report (GAR) in preparing the schedule of expenditures of federal awards (“SEFA”). See the table for a reconciliation of current year receipts per the SEFA to current payments per the GAR.
Title: PAL REPORT Accounting Policies: The accompanying schedule of expenditures of federal awards (the Schedule) includes the federal award activity of Mason Consolidated Schools under programs of the federal government for the year ended June 30, 2024. 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 the operations of Mason Consolidated Schools, it is not intended to and does not present the financial position, changes in net position, or cash flows of Mason Consolidated Schools. Expenditures reported on the Schedule are reported on the modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as a reimbursement. Cash received is recorded on a cash basis. Revenues are recognized when qualifying expenditures have been incurred and all grant requirements have been met. De Minimis Rate Used: N Rate Explanation: Mason Consolidated Schools has elected not to use the 10% de minimis indirect cost rate as allowed under the Uniform Guidance. The amounts reported on the Recipient Entitlement Balance Report, or PAL Report, agree with this schedule for USDA donated food commodities and are reported in the cash receipts column.
Title: MATCHING FUNDS Accounting Policies: The accompanying schedule of expenditures of federal awards (the Schedule) includes the federal award activity of Mason Consolidated Schools under programs of the federal government for the year ended June 30, 2024. 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 the operations of Mason Consolidated Schools, it is not intended to and does not present the financial position, changes in net position, or cash flows of Mason Consolidated Schools. Expenditures reported on the Schedule are reported on the modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as a reimbursement. Cash received is recorded on a cash basis. Revenues are recognized when qualifying expenditures have been incurred and all grant requirements have been met. De Minimis Rate Used: N Rate Explanation: Mason Consolidated Schools has elected not to use the 10% de minimis indirect cost rate as allowed under the Uniform Guidance. Certain federal programs require that the School District contribute non-federal funds (matching funds) to support the federally-funded programs. The School District has complied with the matching requirements. The expenditure of non-federal matching funds is not included on the Schedule.
Title: LOANS Accounting Policies: The accompanying schedule of expenditures of federal awards (the Schedule) includes the federal award activity of Mason Consolidated Schools under programs of the federal government for the year ended June 30, 2024. 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 the operations of Mason Consolidated Schools, it is not intended to and does not present the financial position, changes in net position, or cash flows of Mason Consolidated Schools. Expenditures reported on the Schedule are reported on the modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as a reimbursement. Cash received is recorded on a cash basis. Revenues are recognized when qualifying expenditures have been incurred and all grant requirements have been met. De Minimis Rate Used: N Rate Explanation: Mason Consolidated Schools has elected not to use the 10% de minimis indirect cost rate as allowed under the Uniform Guidance. There were no federal awards expended for loan or loan guarantee programs.
Title: SUBRECIPIENTS Accounting Policies: The accompanying schedule of expenditures of federal awards (the Schedule) includes the federal award activity of Mason Consolidated Schools under programs of the federal government for the year ended June 30, 2024. 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 the operations of Mason Consolidated Schools, it is not intended to and does not present the financial position, changes in net position, or cash flows of Mason Consolidated Schools. Expenditures reported on the Schedule are reported on the modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as a reimbursement. Cash received is recorded on a cash basis. Revenues are recognized when qualifying expenditures have been incurred and all grant requirements have been met. De Minimis Rate Used: N Rate Explanation: Mason Consolidated Schools has elected not to use the 10% de minimis indirect cost rate as allowed under the Uniform Guidance. Mason Consolidated Schools does not have any subrecipients.
Title: RECONCILIATION Accounting Policies: The accompanying schedule of expenditures of federal awards (the Schedule) includes the federal award activity of Mason Consolidated Schools under programs of the federal government for the year ended June 30, 2024. 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 the operations of Mason Consolidated Schools, it is not intended to and does not present the financial position, changes in net position, or cash flows of Mason Consolidated Schools. Expenditures reported on the Schedule are reported on the modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as a reimbursement. Cash received is recorded on a cash basis. Revenues are recognized when qualifying expenditures have been incurred and all grant requirements have been met. De Minimis Rate Used: N Rate Explanation: Mason Consolidated Schools has elected not to use the 10% de minimis indirect cost rate as allowed under the Uniform Guidance. Revenues from federal sources are reported in the School District’s financial statements. See table for reconciliation.

Finding Details

Finding 2024-006
Assistance Listing Number: 10.553, 10.555, 10.559 – Child Nutrition Cluster Pass-through Entity: Michigan Department of Education Finding Type: Material weakness in internal controls over compliance. Repeat Finding: No Criteria: 2CFR 200.510(b) requires organizations to prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the auditee’s financial statements, which must include the total of federal awards as determined in accordance with 2 CFR 200.502. Condition: The original SEFA provided by the School District was not complete and accurate. The audit team identified numerous errors throughout the course of our procedures which were brought to management’s attention. Questioned Costs: None Cause: Controls and processes in place to prepare the SEFA did not ensure that the SEFA was complete and accurate. Effect: The School District accumulates the financial data and other required information to complete the SEFA. The original SEFA provided by the School District to the audit team included several inaccuracies, including missing or incomplete expenditure amounts. The SEFA most significantly included the following inaccuracies: - $18,063 spent under ALN 10.553 (National School Breakfast Program) was improperly excluded from the SEFA. - $41,653 spent under ALN 10.555 (National School Lunch Program) was improperly excluded from the SEFA. Recommendation: The School District’s process for preparing the SEFA should be adjusted to ensure that accounting records are closed timely, internal accounts are reconciled (the SEFA should reconcile to the federal revenues recorded), and appropriate workpapers are prepared to support the SEFA balances. View of Responsible Officials: Management agrees with the finding and will implement procedures to ensure the SEFA is prepared accurately in the future.
Finding 2024-006
Assistance Listing Number: 10.553, 10.555, 10.559 – Child Nutrition Cluster Pass-through Entity: Michigan Department of Education Finding Type: Material weakness in internal controls over compliance. Repeat Finding: No Criteria: 2CFR 200.510(b) requires organizations to prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the auditee’s financial statements, which must include the total of federal awards as determined in accordance with 2 CFR 200.502. Condition: The original SEFA provided by the School District was not complete and accurate. The audit team identified numerous errors throughout the course of our procedures which were brought to management’s attention. Questioned Costs: None Cause: Controls and processes in place to prepare the SEFA did not ensure that the SEFA was complete and accurate. Effect: The School District accumulates the financial data and other required information to complete the SEFA. The original SEFA provided by the School District to the audit team included several inaccuracies, including missing or incomplete expenditure amounts. The SEFA most significantly included the following inaccuracies: - $18,063 spent under ALN 10.553 (National School Breakfast Program) was improperly excluded from the SEFA. - $41,653 spent under ALN 10.555 (National School Lunch Program) was improperly excluded from the SEFA. Recommendation: The School District’s process for preparing the SEFA should be adjusted to ensure that accounting records are closed timely, internal accounts are reconciled (the SEFA should reconcile to the federal revenues recorded), and appropriate workpapers are prepared to support the SEFA balances. View of Responsible Officials: Management agrees with the finding and will implement procedures to ensure the SEFA is prepared accurately in the future.
Finding 2024-006
Assistance Listing Number: 10.553, 10.555, 10.559 – Child Nutrition Cluster Pass-through Entity: Michigan Department of Education Finding Type: Material weakness in internal controls over compliance. Repeat Finding: No Criteria: 2CFR 200.510(b) requires organizations to prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the auditee’s financial statements, which must include the total of federal awards as determined in accordance with 2 CFR 200.502. Condition: The original SEFA provided by the School District was not complete and accurate. The audit team identified numerous errors throughout the course of our procedures which were brought to management’s attention. Questioned Costs: None Cause: Controls and processes in place to prepare the SEFA did not ensure that the SEFA was complete and accurate. Effect: The School District accumulates the financial data and other required information to complete the SEFA. The original SEFA provided by the School District to the audit team included several inaccuracies, including missing or incomplete expenditure amounts. The SEFA most significantly included the following inaccuracies: - $18,063 spent under ALN 10.553 (National School Breakfast Program) was improperly excluded from the SEFA. - $41,653 spent under ALN 10.555 (National School Lunch Program) was improperly excluded from the SEFA. Recommendation: The School District’s process for preparing the SEFA should be adjusted to ensure that accounting records are closed timely, internal accounts are reconciled (the SEFA should reconcile to the federal revenues recorded), and appropriate workpapers are prepared to support the SEFA balances. View of Responsible Officials: Management agrees with the finding and will implement procedures to ensure the SEFA is prepared accurately in the future.
Finding 2024-006
Assistance Listing Number: 10.553, 10.555, 10.559 – Child Nutrition Cluster Pass-through Entity: Michigan Department of Education Finding Type: Material weakness in internal controls over compliance. Repeat Finding: No Criteria: 2CFR 200.510(b) requires organizations to prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the auditee’s financial statements, which must include the total of federal awards as determined in accordance with 2 CFR 200.502. Condition: The original SEFA provided by the School District was not complete and accurate. The audit team identified numerous errors throughout the course of our procedures which were brought to management’s attention. Questioned Costs: None Cause: Controls and processes in place to prepare the SEFA did not ensure that the SEFA was complete and accurate. Effect: The School District accumulates the financial data and other required information to complete the SEFA. The original SEFA provided by the School District to the audit team included several inaccuracies, including missing or incomplete expenditure amounts. The SEFA most significantly included the following inaccuracies: - $18,063 spent under ALN 10.553 (National School Breakfast Program) was improperly excluded from the SEFA. - $41,653 spent under ALN 10.555 (National School Lunch Program) was improperly excluded from the SEFA. Recommendation: The School District’s process for preparing the SEFA should be adjusted to ensure that accounting records are closed timely, internal accounts are reconciled (the SEFA should reconcile to the federal revenues recorded), and appropriate workpapers are prepared to support the SEFA balances. View of Responsible Officials: Management agrees with the finding and will implement procedures to ensure the SEFA is prepared accurately in the future.
Finding 2024-006
Assistance Listing Number: 10.553, 10.555, 10.559 – Child Nutrition Cluster Pass-through Entity: Michigan Department of Education Finding Type: Material weakness in internal controls over compliance. Repeat Finding: No Criteria: 2CFR 200.510(b) requires organizations to prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the auditee’s financial statements, which must include the total of federal awards as determined in accordance with 2 CFR 200.502. Condition: The original SEFA provided by the School District was not complete and accurate. The audit team identified numerous errors throughout the course of our procedures which were brought to management’s attention. Questioned Costs: None Cause: Controls and processes in place to prepare the SEFA did not ensure that the SEFA was complete and accurate. Effect: The School District accumulates the financial data and other required information to complete the SEFA. The original SEFA provided by the School District to the audit team included several inaccuracies, including missing or incomplete expenditure amounts. The SEFA most significantly included the following inaccuracies: - $18,063 spent under ALN 10.553 (National School Breakfast Program) was improperly excluded from the SEFA. - $41,653 spent under ALN 10.555 (National School Lunch Program) was improperly excluded from the SEFA. Recommendation: The School District’s process for preparing the SEFA should be adjusted to ensure that accounting records are closed timely, internal accounts are reconciled (the SEFA should reconcile to the federal revenues recorded), and appropriate workpapers are prepared to support the SEFA balances. View of Responsible Officials: Management agrees with the finding and will implement procedures to ensure the SEFA is prepared accurately in the future.
Finding 2024-006
Assistance Listing Number: 10.553, 10.555, 10.559 – Child Nutrition Cluster Pass-through Entity: Michigan Department of Education Finding Type: Material weakness in internal controls over compliance. Repeat Finding: No Criteria: 2CFR 200.510(b) requires organizations to prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the auditee’s financial statements, which must include the total of federal awards as determined in accordance with 2 CFR 200.502. Condition: The original SEFA provided by the School District was not complete and accurate. The audit team identified numerous errors throughout the course of our procedures which were brought to management’s attention. Questioned Costs: None Cause: Controls and processes in place to prepare the SEFA did not ensure that the SEFA was complete and accurate. Effect: The School District accumulates the financial data and other required information to complete the SEFA. The original SEFA provided by the School District to the audit team included several inaccuracies, including missing or incomplete expenditure amounts. The SEFA most significantly included the following inaccuracies: - $18,063 spent under ALN 10.553 (National School Breakfast Program) was improperly excluded from the SEFA. - $41,653 spent under ALN 10.555 (National School Lunch Program) was improperly excluded from the SEFA. Recommendation: The School District’s process for preparing the SEFA should be adjusted to ensure that accounting records are closed timely, internal accounts are reconciled (the SEFA should reconcile to the federal revenues recorded), and appropriate workpapers are prepared to support the SEFA balances. View of Responsible Officials: Management agrees with the finding and will implement procedures to ensure the SEFA is prepared accurately in the future.
Finding 2024-006
Assistance Listing Number: 10.553, 10.555, 10.559 – Child Nutrition Cluster Pass-through Entity: Michigan Department of Education Finding Type: Material weakness in internal controls over compliance. Repeat Finding: No Criteria: 2CFR 200.510(b) requires organizations to prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the auditee’s financial statements, which must include the total of federal awards as determined in accordance with 2 CFR 200.502. Condition: The original SEFA provided by the School District was not complete and accurate. The audit team identified numerous errors throughout the course of our procedures which were brought to management’s attention. Questioned Costs: None Cause: Controls and processes in place to prepare the SEFA did not ensure that the SEFA was complete and accurate. Effect: The School District accumulates the financial data and other required information to complete the SEFA. The original SEFA provided by the School District to the audit team included several inaccuracies, including missing or incomplete expenditure amounts. The SEFA most significantly included the following inaccuracies: - $18,063 spent under ALN 10.553 (National School Breakfast Program) was improperly excluded from the SEFA. - $41,653 spent under ALN 10.555 (National School Lunch Program) was improperly excluded from the SEFA. Recommendation: The School District’s process for preparing the SEFA should be adjusted to ensure that accounting records are closed timely, internal accounts are reconciled (the SEFA should reconcile to the federal revenues recorded), and appropriate workpapers are prepared to support the SEFA balances. View of Responsible Officials: Management agrees with the finding and will implement procedures to ensure the SEFA is prepared accurately in the future.
Finding 2024-006
Assistance Listing Number: 10.553, 10.555, 10.559 – Child Nutrition Cluster Pass-through Entity: Michigan Department of Education Finding Type: Material weakness in internal controls over compliance. Repeat Finding: No Criteria: 2CFR 200.510(b) requires organizations to prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the auditee’s financial statements, which must include the total of federal awards as determined in accordance with 2 CFR 200.502. Condition: The original SEFA provided by the School District was not complete and accurate. The audit team identified numerous errors throughout the course of our procedures which were brought to management’s attention. Questioned Costs: None Cause: Controls and processes in place to prepare the SEFA did not ensure that the SEFA was complete and accurate. Effect: The School District accumulates the financial data and other required information to complete the SEFA. The original SEFA provided by the School District to the audit team included several inaccuracies, including missing or incomplete expenditure amounts. The SEFA most significantly included the following inaccuracies: - $18,063 spent under ALN 10.553 (National School Breakfast Program) was improperly excluded from the SEFA. - $41,653 spent under ALN 10.555 (National School Lunch Program) was improperly excluded from the SEFA. Recommendation: The School District’s process for preparing the SEFA should be adjusted to ensure that accounting records are closed timely, internal accounts are reconciled (the SEFA should reconcile to the federal revenues recorded), and appropriate workpapers are prepared to support the SEFA balances. View of Responsible Officials: Management agrees with the finding and will implement procedures to ensure the SEFA is prepared accurately in the future.
Finding 2024-006
Assistance Listing Number: 10.553, 10.555, 10.559 – Child Nutrition Cluster Pass-through Entity: Michigan Department of Education Finding Type: Material weakness in internal controls over compliance. Repeat Finding: No Criteria: 2CFR 200.510(b) requires organizations to prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the auditee’s financial statements, which must include the total of federal awards as determined in accordance with 2 CFR 200.502. Condition: The original SEFA provided by the School District was not complete and accurate. The audit team identified numerous errors throughout the course of our procedures which were brought to management’s attention. Questioned Costs: None Cause: Controls and processes in place to prepare the SEFA did not ensure that the SEFA was complete and accurate. Effect: The School District accumulates the financial data and other required information to complete the SEFA. The original SEFA provided by the School District to the audit team included several inaccuracies, including missing or incomplete expenditure amounts. The SEFA most significantly included the following inaccuracies: - $18,063 spent under ALN 10.553 (National School Breakfast Program) was improperly excluded from the SEFA. - $41,653 spent under ALN 10.555 (National School Lunch Program) was improperly excluded from the SEFA. Recommendation: The School District’s process for preparing the SEFA should be adjusted to ensure that accounting records are closed timely, internal accounts are reconciled (the SEFA should reconcile to the federal revenues recorded), and appropriate workpapers are prepared to support the SEFA balances. View of Responsible Officials: Management agrees with the finding and will implement procedures to ensure the SEFA is prepared accurately in the future.
Finding 2024-006
Assistance Listing Number: 10.553, 10.555, 10.559 – Child Nutrition Cluster Pass-through Entity: Michigan Department of Education Finding Type: Material weakness in internal controls over compliance. Repeat Finding: No Criteria: 2CFR 200.510(b) requires organizations to prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the auditee’s financial statements, which must include the total of federal awards as determined in accordance with 2 CFR 200.502. Condition: The original SEFA provided by the School District was not complete and accurate. The audit team identified numerous errors throughout the course of our procedures which were brought to management’s attention. Questioned Costs: None Cause: Controls and processes in place to prepare the SEFA did not ensure that the SEFA was complete and accurate. Effect: The School District accumulates the financial data and other required information to complete the SEFA. The original SEFA provided by the School District to the audit team included several inaccuracies, including missing or incomplete expenditure amounts. The SEFA most significantly included the following inaccuracies: - $18,063 spent under ALN 10.553 (National School Breakfast Program) was improperly excluded from the SEFA. - $41,653 spent under ALN 10.555 (National School Lunch Program) was improperly excluded from the SEFA. Recommendation: The School District’s process for preparing the SEFA should be adjusted to ensure that accounting records are closed timely, internal accounts are reconciled (the SEFA should reconcile to the federal revenues recorded), and appropriate workpapers are prepared to support the SEFA balances. View of Responsible Officials: Management agrees with the finding and will implement procedures to ensure the SEFA is prepared accurately in the future.