Audit 307822

FY End
2023-06-30
Total Expended
$9.30M
Findings
18
Programs
18
Year: 2023 Accepted: 2024-05-31

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
399342 2023-002 Material Weakness Yes P
399343 2023-002 Material Weakness Yes P
399344 2023-002 Material Weakness Yes P
399345 2023-002 Material Weakness Yes P
399346 2023-002 Material Weakness Yes P
399347 2023-002 Material Weakness Yes P
399348 2023-002 Material Weakness Yes P
399349 2023-002 Material Weakness Yes P
399350 2023-002 Material Weakness Yes P
975784 2023-002 Material Weakness Yes P
975785 2023-002 Material Weakness Yes P
975786 2023-002 Material Weakness Yes P
975787 2023-002 Material Weakness Yes P
975788 2023-002 Material Weakness Yes P
975789 2023-002 Material Weakness Yes P
975790 2023-002 Material Weakness Yes P
975791 2023-002 Material Weakness Yes P
975792 2023-002 Material Weakness Yes P

Contacts

Name Title Type
PJ2MR4QQF8J7 Melissa Labbe Auditee
8037445159 Michael Slapnik Auditor
No contacts on file

Notes to SEFA

Title: NOTE A - GENERAL Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards (the “Schedule”) presents the activity of all federal award programs of the Central Midlands Council of Governments (the “Council”) for the year ended June 30, 2023. All federal awards received directly from federal agencies, as well as those passed through other government agencies, are included on the Schedule. The accompanying Schedule of Expenditures of Federal Awards includes the federal grant activity of the Council under programs of the federal government for the year ended June 30, 2023. The information in the 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”). Therefore, some amounts presented in this schedule may differ from amounts presented in or used in the preparation of the financial statements. Because the Schedule presents only a selected portion of the operations of the Council, it is not intended to and does not present the financial position, changes in net position, or cash flows of the Council. De Minimis Rate Used: N Rate Explanation: The Council uses a restricted indirect cost rate between 29.25% and 30.39% depending on grant year that is used for its federal programs and did not use the 10% de Minimis indirect cost rate as allowed under the Uniform Guidance and covered in 2 CFR Part 200.414. The accompanying Schedule of Expenditures of Federal Awards (the “Schedule”) presents the activity of all federal award programs of the Central Midlands Council of Governments (the “Council”) for the year ended June 30, 2023. All federal awards received directly from federal agencies, as well as those passed through other government agencies, are included on the Schedule.
Title: NOTE B - Basis of Accounting Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards (the “Schedule”) presents the activity of all federal award programs of the Central Midlands Council of Governments (the “Council”) for the year ended June 30, 2023. All federal awards received directly from federal agencies, as well as those passed through other government agencies, are included on the Schedule. The accompanying Schedule of Expenditures of Federal Awards includes the federal grant activity of the Council under programs of the federal government for the year ended June 30, 2023. The information in the 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”). Therefore, some amounts presented in this schedule may differ from amounts presented in or used in the preparation of the financial statements. Because the Schedule presents only a selected portion of the operations of the Council, it is not intended to and does not present the financial position, changes in net position, or cash flows of the Council. De Minimis Rate Used: N Rate Explanation: The Council uses a restricted indirect cost rate between 29.25% and 30.39% depending on grant year that is used for its federal programs and did not use the 10% de Minimis indirect cost rate as allowed under the Uniform Guidance and covered in 2 CFR Part 200.414. The accompanying Schedule of Expenditures of Federal Awards includes the federal grant activity of the Council under programs of the federal government for the year ended June 30, 2023. The information in the 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”). Therefore, some amounts presented in this schedule may differ from amounts presented in or used in the preparation of the financial statements. Because the Schedule presents only a selected portion of the operations of the Council, it is not intended to and does not present the financial position, changes in net position, or cash flows of the Council.
Title: Note C – Relationship to Basic Financial Statements Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards (the “Schedule”) presents the activity of all federal award programs of the Central Midlands Council of Governments (the “Council”) for the year ended June 30, 2023. All federal awards received directly from federal agencies, as well as those passed through other government agencies, are included on the Schedule. The accompanying Schedule of Expenditures of Federal Awards includes the federal grant activity of the Council under programs of the federal government for the year ended June 30, 2023. The information in the 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”). Therefore, some amounts presented in this schedule may differ from amounts presented in or used in the preparation of the financial statements. Because the Schedule presents only a selected portion of the operations of the Council, it is not intended to and does not present the financial position, changes in net position, or cash flows of the Council. De Minimis Rate Used: N Rate Explanation: The Council uses a restricted indirect cost rate between 29.25% and 30.39% depending on grant year that is used for its federal programs and did not use the 10% de Minimis indirect cost rate as allowed under the Uniform Guidance and covered in 2 CFR Part 200.414. Federal award expenditures are reported in the Council’s basic financial statements as expenditures in the General Fund and Special Revenue Funds. Amounts reported in the accompanying Schedule agree with the amounts reported in the related federal financial reports except for timing differences related to expenditures made subsequent to the filing of the federal financial reports. Matching costs, i.e. the non-federal share of certain program costs, are not included in the accompanying schedule.
Title: Note D - Contingencies Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards (the “Schedule”) presents the activity of all federal award programs of the Central Midlands Council of Governments (the “Council”) for the year ended June 30, 2023. All federal awards received directly from federal agencies, as well as those passed through other government agencies, are included on the Schedule. The accompanying Schedule of Expenditures of Federal Awards includes the federal grant activity of the Council under programs of the federal government for the year ended June 30, 2023. The information in the 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”). Therefore, some amounts presented in this schedule may differ from amounts presented in or used in the preparation of the financial statements. Because the Schedule presents only a selected portion of the operations of the Council, it is not intended to and does not present the financial position, changes in net position, or cash flows of the Council. De Minimis Rate Used: N Rate Explanation: The Council uses a restricted indirect cost rate between 29.25% and 30.39% depending on grant year that is used for its federal programs and did not use the 10% de Minimis indirect cost rate as allowed under the Uniform Guidance and covered in 2 CFR Part 200.414. The Council receives funds under various federal grant programs, and such awards are to be expended in accordance with the provisions of the various grants. Compliance with the grants is subject to audit by various government agencies which may impose sanctions in the event of non-compliance.
Title: Note E – Major Programs and Clusters Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards (the “Schedule”) presents the activity of all federal award programs of the Central Midlands Council of Governments (the “Council”) for the year ended June 30, 2023. All federal awards received directly from federal agencies, as well as those passed through other government agencies, are included on the Schedule. The accompanying Schedule of Expenditures of Federal Awards includes the federal grant activity of the Council under programs of the federal government for the year ended June 30, 2023. The information in the 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”). Therefore, some amounts presented in this schedule may differ from amounts presented in or used in the preparation of the financial statements. Because the Schedule presents only a selected portion of the operations of the Council, it is not intended to and does not present the financial position, changes in net position, or cash flows of the Council. De Minimis Rate Used: N Rate Explanation: The Council uses a restricted indirect cost rate between 29.25% and 30.39% depending on grant year that is used for its federal programs and did not use the 10% de Minimis indirect cost rate as allowed under the Uniform Guidance and covered in 2 CFR Part 200.414. * Denotes major programs As defined in the Uniform Guidance, WIOA, Federal Transit, and Aging programs are considered to be clusters of programs and, accordingly, have been classified as one program for testing purposes.
Title: Note F – Indirect Cost Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards (the “Schedule”) presents the activity of all federal award programs of the Central Midlands Council of Governments (the “Council”) for the year ended June 30, 2023. All federal awards received directly from federal agencies, as well as those passed through other government agencies, are included on the Schedule. The accompanying Schedule of Expenditures of Federal Awards includes the federal grant activity of the Council under programs of the federal government for the year ended June 30, 2023. The information in the 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”). Therefore, some amounts presented in this schedule may differ from amounts presented in or used in the preparation of the financial statements. Because the Schedule presents only a selected portion of the operations of the Council, it is not intended to and does not present the financial position, changes in net position, or cash flows of the Council. De Minimis Rate Used: N Rate Explanation: The Council uses a restricted indirect cost rate between 29.25% and 30.39% depending on grant year that is used for its federal programs and did not use the 10% de Minimis indirect cost rate as allowed under the Uniform Guidance and covered in 2 CFR Part 200.414. The Council uses a restricted indirect cost rate between 29.25% and 30.39% depending on grant year that is used for its federal programs and did not use the 10% de Minimis indirect cost rate as allowed under the Uniform Guidance and covered in 2 CFR Part 200.414.

Finding Details

Item 2023-002: Report Submission to the Federal Audit Clearinghouse (Other Matter Required to be Reported Under the Uniform Guidance) (Material Weakness) Condition: The Council did not prepare and submit its Data Collection Form and Reporting Package for the year ended June 30, 2023 to the Federal Audit Clearinghouse by the due date of March 31, 2024. Criteria: Per §200.512 of the Uniform Guidance, Report Submission, the audit shall be completed and the Data Collection Form and Reporting Package shall be electronically transmitted within the earlier of thirty (30) days after receipt of the auditor’s reports, or nine (9) months after the end of the audit period. If the due date falls on a Saturday, Sunday, or federal holiday, the Data Collection Form and Reporting Package are due the next business day. The Uniform Guidance does not permit the recipient to extend the due date. Cause: Management did not review subsidiary ledgers for accuracy and reconcile them to the general ledger on a timely basis. The Council also replaced their Finance Director and other finance staff in fiscal year 2023, which also impacted the timely reconciliation of their accounting records. Accordingly, the Council’s general ledger for the year ended June 30, 2023 was not closed out in a timely manner. Effect: The Council’s Data Collection Form and Reporting Package for the year ended June 30, 2023 was not prepared and submitted to the Federal Audit Clearinghouse by the due date. Recommendation: We recommend that management implement monthly financial reporting and closeout processes so that the financial closeout process can be performed timely.
Item 2023-002: Report Submission to the Federal Audit Clearinghouse (Other Matter Required to be Reported Under the Uniform Guidance) (Material Weakness) Condition: The Council did not prepare and submit its Data Collection Form and Reporting Package for the year ended June 30, 2023 to the Federal Audit Clearinghouse by the due date of March 31, 2024. Criteria: Per §200.512 of the Uniform Guidance, Report Submission, the audit shall be completed and the Data Collection Form and Reporting Package shall be electronically transmitted within the earlier of thirty (30) days after receipt of the auditor’s reports, or nine (9) months after the end of the audit period. If the due date falls on a Saturday, Sunday, or federal holiday, the Data Collection Form and Reporting Package are due the next business day. The Uniform Guidance does not permit the recipient to extend the due date. Cause: Management did not review subsidiary ledgers for accuracy and reconcile them to the general ledger on a timely basis. The Council also replaced their Finance Director and other finance staff in fiscal year 2023, which also impacted the timely reconciliation of their accounting records. Accordingly, the Council’s general ledger for the year ended June 30, 2023 was not closed out in a timely manner. Effect: The Council’s Data Collection Form and Reporting Package for the year ended June 30, 2023 was not prepared and submitted to the Federal Audit Clearinghouse by the due date. Recommendation: We recommend that management implement monthly financial reporting and closeout processes so that the financial closeout process can be performed timely.
Item 2023-002: Report Submission to the Federal Audit Clearinghouse (Other Matter Required to be Reported Under the Uniform Guidance) (Material Weakness) Condition: The Council did not prepare and submit its Data Collection Form and Reporting Package for the year ended June 30, 2023 to the Federal Audit Clearinghouse by the due date of March 31, 2024. Criteria: Per §200.512 of the Uniform Guidance, Report Submission, the audit shall be completed and the Data Collection Form and Reporting Package shall be electronically transmitted within the earlier of thirty (30) days after receipt of the auditor’s reports, or nine (9) months after the end of the audit period. If the due date falls on a Saturday, Sunday, or federal holiday, the Data Collection Form and Reporting Package are due the next business day. The Uniform Guidance does not permit the recipient to extend the due date. Cause: Management did not review subsidiary ledgers for accuracy and reconcile them to the general ledger on a timely basis. The Council also replaced their Finance Director and other finance staff in fiscal year 2023, which also impacted the timely reconciliation of their accounting records. Accordingly, the Council’s general ledger for the year ended June 30, 2023 was not closed out in a timely manner. Effect: The Council’s Data Collection Form and Reporting Package for the year ended June 30, 2023 was not prepared and submitted to the Federal Audit Clearinghouse by the due date. Recommendation: We recommend that management implement monthly financial reporting and closeout processes so that the financial closeout process can be performed timely.
Item 2023-002: Report Submission to the Federal Audit Clearinghouse (Other Matter Required to be Reported Under the Uniform Guidance) (Material Weakness) Condition: The Council did not prepare and submit its Data Collection Form and Reporting Package for the year ended June 30, 2023 to the Federal Audit Clearinghouse by the due date of March 31, 2024. Criteria: Per §200.512 of the Uniform Guidance, Report Submission, the audit shall be completed and the Data Collection Form and Reporting Package shall be electronically transmitted within the earlier of thirty (30) days after receipt of the auditor’s reports, or nine (9) months after the end of the audit period. If the due date falls on a Saturday, Sunday, or federal holiday, the Data Collection Form and Reporting Package are due the next business day. The Uniform Guidance does not permit the recipient to extend the due date. Cause: Management did not review subsidiary ledgers for accuracy and reconcile them to the general ledger on a timely basis. The Council also replaced their Finance Director and other finance staff in fiscal year 2023, which also impacted the timely reconciliation of their accounting records. Accordingly, the Council’s general ledger for the year ended June 30, 2023 was not closed out in a timely manner. Effect: The Council’s Data Collection Form and Reporting Package for the year ended June 30, 2023 was not prepared and submitted to the Federal Audit Clearinghouse by the due date. Recommendation: We recommend that management implement monthly financial reporting and closeout processes so that the financial closeout process can be performed timely.
Item 2023-002: Report Submission to the Federal Audit Clearinghouse (Other Matter Required to be Reported Under the Uniform Guidance) (Material Weakness) Condition: The Council did not prepare and submit its Data Collection Form and Reporting Package for the year ended June 30, 2023 to the Federal Audit Clearinghouse by the due date of March 31, 2024. Criteria: Per §200.512 of the Uniform Guidance, Report Submission, the audit shall be completed and the Data Collection Form and Reporting Package shall be electronically transmitted within the earlier of thirty (30) days after receipt of the auditor’s reports, or nine (9) months after the end of the audit period. If the due date falls on a Saturday, Sunday, or federal holiday, the Data Collection Form and Reporting Package are due the next business day. The Uniform Guidance does not permit the recipient to extend the due date. Cause: Management did not review subsidiary ledgers for accuracy and reconcile them to the general ledger on a timely basis. The Council also replaced their Finance Director and other finance staff in fiscal year 2023, which also impacted the timely reconciliation of their accounting records. Accordingly, the Council’s general ledger for the year ended June 30, 2023 was not closed out in a timely manner. Effect: The Council’s Data Collection Form and Reporting Package for the year ended June 30, 2023 was not prepared and submitted to the Federal Audit Clearinghouse by the due date. Recommendation: We recommend that management implement monthly financial reporting and closeout processes so that the financial closeout process can be performed timely.
Item 2023-002: Report Submission to the Federal Audit Clearinghouse (Other Matter Required to be Reported Under the Uniform Guidance) (Material Weakness) Condition: The Council did not prepare and submit its Data Collection Form and Reporting Package for the year ended June 30, 2023 to the Federal Audit Clearinghouse by the due date of March 31, 2024. Criteria: Per §200.512 of the Uniform Guidance, Report Submission, the audit shall be completed and the Data Collection Form and Reporting Package shall be electronically transmitted within the earlier of thirty (30) days after receipt of the auditor’s reports, or nine (9) months after the end of the audit period. If the due date falls on a Saturday, Sunday, or federal holiday, the Data Collection Form and Reporting Package are due the next business day. The Uniform Guidance does not permit the recipient to extend the due date. Cause: Management did not review subsidiary ledgers for accuracy and reconcile them to the general ledger on a timely basis. The Council also replaced their Finance Director and other finance staff in fiscal year 2023, which also impacted the timely reconciliation of their accounting records. Accordingly, the Council’s general ledger for the year ended June 30, 2023 was not closed out in a timely manner. Effect: The Council’s Data Collection Form and Reporting Package for the year ended June 30, 2023 was not prepared and submitted to the Federal Audit Clearinghouse by the due date. Recommendation: We recommend that management implement monthly financial reporting and closeout processes so that the financial closeout process can be performed timely.
Item 2023-002: Report Submission to the Federal Audit Clearinghouse (Other Matter Required to be Reported Under the Uniform Guidance) (Material Weakness) Condition: The Council did not prepare and submit its Data Collection Form and Reporting Package for the year ended June 30, 2023 to the Federal Audit Clearinghouse by the due date of March 31, 2024. Criteria: Per §200.512 of the Uniform Guidance, Report Submission, the audit shall be completed and the Data Collection Form and Reporting Package shall be electronically transmitted within the earlier of thirty (30) days after receipt of the auditor’s reports, or nine (9) months after the end of the audit period. If the due date falls on a Saturday, Sunday, or federal holiday, the Data Collection Form and Reporting Package are due the next business day. The Uniform Guidance does not permit the recipient to extend the due date. Cause: Management did not review subsidiary ledgers for accuracy and reconcile them to the general ledger on a timely basis. The Council also replaced their Finance Director and other finance staff in fiscal year 2023, which also impacted the timely reconciliation of their accounting records. Accordingly, the Council’s general ledger for the year ended June 30, 2023 was not closed out in a timely manner. Effect: The Council’s Data Collection Form and Reporting Package for the year ended June 30, 2023 was not prepared and submitted to the Federal Audit Clearinghouse by the due date. Recommendation: We recommend that management implement monthly financial reporting and closeout processes so that the financial closeout process can be performed timely.
Item 2023-002: Report Submission to the Federal Audit Clearinghouse (Other Matter Required to be Reported Under the Uniform Guidance) (Material Weakness) Condition: The Council did not prepare and submit its Data Collection Form and Reporting Package for the year ended June 30, 2023 to the Federal Audit Clearinghouse by the due date of March 31, 2024. Criteria: Per §200.512 of the Uniform Guidance, Report Submission, the audit shall be completed and the Data Collection Form and Reporting Package shall be electronically transmitted within the earlier of thirty (30) days after receipt of the auditor’s reports, or nine (9) months after the end of the audit period. If the due date falls on a Saturday, Sunday, or federal holiday, the Data Collection Form and Reporting Package are due the next business day. The Uniform Guidance does not permit the recipient to extend the due date. Cause: Management did not review subsidiary ledgers for accuracy and reconcile them to the general ledger on a timely basis. The Council also replaced their Finance Director and other finance staff in fiscal year 2023, which also impacted the timely reconciliation of their accounting records. Accordingly, the Council’s general ledger for the year ended June 30, 2023 was not closed out in a timely manner. Effect: The Council’s Data Collection Form and Reporting Package for the year ended June 30, 2023 was not prepared and submitted to the Federal Audit Clearinghouse by the due date. Recommendation: We recommend that management implement monthly financial reporting and closeout processes so that the financial closeout process can be performed timely.
Item 2023-002: Report Submission to the Federal Audit Clearinghouse (Other Matter Required to be Reported Under the Uniform Guidance) (Material Weakness) Condition: The Council did not prepare and submit its Data Collection Form and Reporting Package for the year ended June 30, 2023 to the Federal Audit Clearinghouse by the due date of March 31, 2024. Criteria: Per §200.512 of the Uniform Guidance, Report Submission, the audit shall be completed and the Data Collection Form and Reporting Package shall be electronically transmitted within the earlier of thirty (30) days after receipt of the auditor’s reports, or nine (9) months after the end of the audit period. If the due date falls on a Saturday, Sunday, or federal holiday, the Data Collection Form and Reporting Package are due the next business day. The Uniform Guidance does not permit the recipient to extend the due date. Cause: Management did not review subsidiary ledgers for accuracy and reconcile them to the general ledger on a timely basis. The Council also replaced their Finance Director and other finance staff in fiscal year 2023, which also impacted the timely reconciliation of their accounting records. Accordingly, the Council’s general ledger for the year ended June 30, 2023 was not closed out in a timely manner. Effect: The Council’s Data Collection Form and Reporting Package for the year ended June 30, 2023 was not prepared and submitted to the Federal Audit Clearinghouse by the due date. Recommendation: We recommend that management implement monthly financial reporting and closeout processes so that the financial closeout process can be performed timely.
Item 2023-002: Report Submission to the Federal Audit Clearinghouse (Other Matter Required to be Reported Under the Uniform Guidance) (Material Weakness) Condition: The Council did not prepare and submit its Data Collection Form and Reporting Package for the year ended June 30, 2023 to the Federal Audit Clearinghouse by the due date of March 31, 2024. Criteria: Per §200.512 of the Uniform Guidance, Report Submission, the audit shall be completed and the Data Collection Form and Reporting Package shall be electronically transmitted within the earlier of thirty (30) days after receipt of the auditor’s reports, or nine (9) months after the end of the audit period. If the due date falls on a Saturday, Sunday, or federal holiday, the Data Collection Form and Reporting Package are due the next business day. The Uniform Guidance does not permit the recipient to extend the due date. Cause: Management did not review subsidiary ledgers for accuracy and reconcile them to the general ledger on a timely basis. The Council also replaced their Finance Director and other finance staff in fiscal year 2023, which also impacted the timely reconciliation of their accounting records. Accordingly, the Council’s general ledger for the year ended June 30, 2023 was not closed out in a timely manner. Effect: The Council’s Data Collection Form and Reporting Package for the year ended June 30, 2023 was not prepared and submitted to the Federal Audit Clearinghouse by the due date. Recommendation: We recommend that management implement monthly financial reporting and closeout processes so that the financial closeout process can be performed timely.
Item 2023-002: Report Submission to the Federal Audit Clearinghouse (Other Matter Required to be Reported Under the Uniform Guidance) (Material Weakness) Condition: The Council did not prepare and submit its Data Collection Form and Reporting Package for the year ended June 30, 2023 to the Federal Audit Clearinghouse by the due date of March 31, 2024. Criteria: Per §200.512 of the Uniform Guidance, Report Submission, the audit shall be completed and the Data Collection Form and Reporting Package shall be electronically transmitted within the earlier of thirty (30) days after receipt of the auditor’s reports, or nine (9) months after the end of the audit period. If the due date falls on a Saturday, Sunday, or federal holiday, the Data Collection Form and Reporting Package are due the next business day. The Uniform Guidance does not permit the recipient to extend the due date. Cause: Management did not review subsidiary ledgers for accuracy and reconcile them to the general ledger on a timely basis. The Council also replaced their Finance Director and other finance staff in fiscal year 2023, which also impacted the timely reconciliation of their accounting records. Accordingly, the Council’s general ledger for the year ended June 30, 2023 was not closed out in a timely manner. Effect: The Council’s Data Collection Form and Reporting Package for the year ended June 30, 2023 was not prepared and submitted to the Federal Audit Clearinghouse by the due date. Recommendation: We recommend that management implement monthly financial reporting and closeout processes so that the financial closeout process can be performed timely.
Item 2023-002: Report Submission to the Federal Audit Clearinghouse (Other Matter Required to be Reported Under the Uniform Guidance) (Material Weakness) Condition: The Council did not prepare and submit its Data Collection Form and Reporting Package for the year ended June 30, 2023 to the Federal Audit Clearinghouse by the due date of March 31, 2024. Criteria: Per §200.512 of the Uniform Guidance, Report Submission, the audit shall be completed and the Data Collection Form and Reporting Package shall be electronically transmitted within the earlier of thirty (30) days after receipt of the auditor’s reports, or nine (9) months after the end of the audit period. If the due date falls on a Saturday, Sunday, or federal holiday, the Data Collection Form and Reporting Package are due the next business day. The Uniform Guidance does not permit the recipient to extend the due date. Cause: Management did not review subsidiary ledgers for accuracy and reconcile them to the general ledger on a timely basis. The Council also replaced their Finance Director and other finance staff in fiscal year 2023, which also impacted the timely reconciliation of their accounting records. Accordingly, the Council’s general ledger for the year ended June 30, 2023 was not closed out in a timely manner. Effect: The Council’s Data Collection Form and Reporting Package for the year ended June 30, 2023 was not prepared and submitted to the Federal Audit Clearinghouse by the due date. Recommendation: We recommend that management implement monthly financial reporting and closeout processes so that the financial closeout process can be performed timely.
Item 2023-002: Report Submission to the Federal Audit Clearinghouse (Other Matter Required to be Reported Under the Uniform Guidance) (Material Weakness) Condition: The Council did not prepare and submit its Data Collection Form and Reporting Package for the year ended June 30, 2023 to the Federal Audit Clearinghouse by the due date of March 31, 2024. Criteria: Per §200.512 of the Uniform Guidance, Report Submission, the audit shall be completed and the Data Collection Form and Reporting Package shall be electronically transmitted within the earlier of thirty (30) days after receipt of the auditor’s reports, or nine (9) months after the end of the audit period. If the due date falls on a Saturday, Sunday, or federal holiday, the Data Collection Form and Reporting Package are due the next business day. The Uniform Guidance does not permit the recipient to extend the due date. Cause: Management did not review subsidiary ledgers for accuracy and reconcile them to the general ledger on a timely basis. The Council also replaced their Finance Director and other finance staff in fiscal year 2023, which also impacted the timely reconciliation of their accounting records. Accordingly, the Council’s general ledger for the year ended June 30, 2023 was not closed out in a timely manner. Effect: The Council’s Data Collection Form and Reporting Package for the year ended June 30, 2023 was not prepared and submitted to the Federal Audit Clearinghouse by the due date. Recommendation: We recommend that management implement monthly financial reporting and closeout processes so that the financial closeout process can be performed timely.
Item 2023-002: Report Submission to the Federal Audit Clearinghouse (Other Matter Required to be Reported Under the Uniform Guidance) (Material Weakness) Condition: The Council did not prepare and submit its Data Collection Form and Reporting Package for the year ended June 30, 2023 to the Federal Audit Clearinghouse by the due date of March 31, 2024. Criteria: Per §200.512 of the Uniform Guidance, Report Submission, the audit shall be completed and the Data Collection Form and Reporting Package shall be electronically transmitted within the earlier of thirty (30) days after receipt of the auditor’s reports, or nine (9) months after the end of the audit period. If the due date falls on a Saturday, Sunday, or federal holiday, the Data Collection Form and Reporting Package are due the next business day. The Uniform Guidance does not permit the recipient to extend the due date. Cause: Management did not review subsidiary ledgers for accuracy and reconcile them to the general ledger on a timely basis. The Council also replaced their Finance Director and other finance staff in fiscal year 2023, which also impacted the timely reconciliation of their accounting records. Accordingly, the Council’s general ledger for the year ended June 30, 2023 was not closed out in a timely manner. Effect: The Council’s Data Collection Form and Reporting Package for the year ended June 30, 2023 was not prepared and submitted to the Federal Audit Clearinghouse by the due date. Recommendation: We recommend that management implement monthly financial reporting and closeout processes so that the financial closeout process can be performed timely.
Item 2023-002: Report Submission to the Federal Audit Clearinghouse (Other Matter Required to be Reported Under the Uniform Guidance) (Material Weakness) Condition: The Council did not prepare and submit its Data Collection Form and Reporting Package for the year ended June 30, 2023 to the Federal Audit Clearinghouse by the due date of March 31, 2024. Criteria: Per §200.512 of the Uniform Guidance, Report Submission, the audit shall be completed and the Data Collection Form and Reporting Package shall be electronically transmitted within the earlier of thirty (30) days after receipt of the auditor’s reports, or nine (9) months after the end of the audit period. If the due date falls on a Saturday, Sunday, or federal holiday, the Data Collection Form and Reporting Package are due the next business day. The Uniform Guidance does not permit the recipient to extend the due date. Cause: Management did not review subsidiary ledgers for accuracy and reconcile them to the general ledger on a timely basis. The Council also replaced their Finance Director and other finance staff in fiscal year 2023, which also impacted the timely reconciliation of their accounting records. Accordingly, the Council’s general ledger for the year ended June 30, 2023 was not closed out in a timely manner. Effect: The Council’s Data Collection Form and Reporting Package for the year ended June 30, 2023 was not prepared and submitted to the Federal Audit Clearinghouse by the due date. Recommendation: We recommend that management implement monthly financial reporting and closeout processes so that the financial closeout process can be performed timely.
Item 2023-002: Report Submission to the Federal Audit Clearinghouse (Other Matter Required to be Reported Under the Uniform Guidance) (Material Weakness) Condition: The Council did not prepare and submit its Data Collection Form and Reporting Package for the year ended June 30, 2023 to the Federal Audit Clearinghouse by the due date of March 31, 2024. Criteria: Per §200.512 of the Uniform Guidance, Report Submission, the audit shall be completed and the Data Collection Form and Reporting Package shall be electronically transmitted within the earlier of thirty (30) days after receipt of the auditor’s reports, or nine (9) months after the end of the audit period. If the due date falls on a Saturday, Sunday, or federal holiday, the Data Collection Form and Reporting Package are due the next business day. The Uniform Guidance does not permit the recipient to extend the due date. Cause: Management did not review subsidiary ledgers for accuracy and reconcile them to the general ledger on a timely basis. The Council also replaced their Finance Director and other finance staff in fiscal year 2023, which also impacted the timely reconciliation of their accounting records. Accordingly, the Council’s general ledger for the year ended June 30, 2023 was not closed out in a timely manner. Effect: The Council’s Data Collection Form and Reporting Package for the year ended June 30, 2023 was not prepared and submitted to the Federal Audit Clearinghouse by the due date. Recommendation: We recommend that management implement monthly financial reporting and closeout processes so that the financial closeout process can be performed timely.
Item 2023-002: Report Submission to the Federal Audit Clearinghouse (Other Matter Required to be Reported Under the Uniform Guidance) (Material Weakness) Condition: The Council did not prepare and submit its Data Collection Form and Reporting Package for the year ended June 30, 2023 to the Federal Audit Clearinghouse by the due date of March 31, 2024. Criteria: Per §200.512 of the Uniform Guidance, Report Submission, the audit shall be completed and the Data Collection Form and Reporting Package shall be electronically transmitted within the earlier of thirty (30) days after receipt of the auditor’s reports, or nine (9) months after the end of the audit period. If the due date falls on a Saturday, Sunday, or federal holiday, the Data Collection Form and Reporting Package are due the next business day. The Uniform Guidance does not permit the recipient to extend the due date. Cause: Management did not review subsidiary ledgers for accuracy and reconcile them to the general ledger on a timely basis. The Council also replaced their Finance Director and other finance staff in fiscal year 2023, which also impacted the timely reconciliation of their accounting records. Accordingly, the Council’s general ledger for the year ended June 30, 2023 was not closed out in a timely manner. Effect: The Council’s Data Collection Form and Reporting Package for the year ended June 30, 2023 was not prepared and submitted to the Federal Audit Clearinghouse by the due date. Recommendation: We recommend that management implement monthly financial reporting and closeout processes so that the financial closeout process can be performed timely.
Item 2023-002: Report Submission to the Federal Audit Clearinghouse (Other Matter Required to be Reported Under the Uniform Guidance) (Material Weakness) Condition: The Council did not prepare and submit its Data Collection Form and Reporting Package for the year ended June 30, 2023 to the Federal Audit Clearinghouse by the due date of March 31, 2024. Criteria: Per §200.512 of the Uniform Guidance, Report Submission, the audit shall be completed and the Data Collection Form and Reporting Package shall be electronically transmitted within the earlier of thirty (30) days after receipt of the auditor’s reports, or nine (9) months after the end of the audit period. If the due date falls on a Saturday, Sunday, or federal holiday, the Data Collection Form and Reporting Package are due the next business day. The Uniform Guidance does not permit the recipient to extend the due date. Cause: Management did not review subsidiary ledgers for accuracy and reconcile them to the general ledger on a timely basis. The Council also replaced their Finance Director and other finance staff in fiscal year 2023, which also impacted the timely reconciliation of their accounting records. Accordingly, the Council’s general ledger for the year ended June 30, 2023 was not closed out in a timely manner. Effect: The Council’s Data Collection Form and Reporting Package for the year ended June 30, 2023 was not prepared and submitted to the Federal Audit Clearinghouse by the due date. Recommendation: We recommend that management implement monthly financial reporting and closeout processes so that the financial closeout process can be performed timely.