Audit 31308

FY End
2022-09-30
Total Expended
$1.76M
Findings
6
Programs
1
Organization: Michigan College Access Network (MI)
Year: 2022 Accepted: 2023-06-29
Auditor: Doeren Mayhew

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
33861 2022-001 Material Weakness Yes P
33862 2022-002 Material Weakness Yes P
33863 2022-003 Material Weakness Yes P
610303 2022-001 Material Weakness Yes P
610304 2022-002 Material Weakness Yes P
610305 2022-003 Material Weakness Yes P

Programs

ALN Program Spent Major Findings
94.006 Americorps $1.76M Yes 3

Contacts

Name Title Type
C3YQB8U9D7F3 Ryan Fewins-Bliss Auditee
5173161713 Kiley Judge Auditor
No contacts on file

Notes to SEFA

Title: Basis of Accounting Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards includes the federal grant activity of Michigan College Access Network (A Nonprofit Organization) under programs of the federal government for the year ended September 30, 2022. 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). Because the Schedule presents only a selected portion of the operations of Michigan College Access Network (A Nonprofit Organization), it is not intended to and does not present the financial position, changes in net assets, or cash flows of Michigan College Access Network (A Nonprofit Organization). De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. Expenditures reported on the Schedule of Expenditures of Federal Awards are reported on the accrual basis of accounting. Such expenditures are recognized following the cost principles contained in Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Michigan College Access Network (A Nonprofit Organization) has elected not to use the 10% de minimus indirect cost rate as allowed under the Uniform Guidance

Finding Details

Finding Type Material Weakness Condition During the audit, we noted a significant amount of adjusting journal entries were required to be recorded in order to adjust the year end balances to their appropriate amounts. This includes journal entries related to the Organization?s funding sources as of September 30, 2022. Criteria Accounting books and records should be complete and accurate and include all relevant documentation to support the amounts. Cause Formal procedures related to proper accounting practices were not in place to ensure all activities were addressed and reported appropriately in conformity with generally accepted accounting principles. Effect General ledger accounts were not analyzed and reviewed by management prior to the start of the audit to ensure financial records were properly recorded. Recommendation We recommend the Organization review and update, as necessary, its written procedures regarding processing and recording of transactions and monitor such processing to ensure that transactions are processed and reported and reconciled in an accurate manner. This includes maintaining documentation and support for each entry in an orderly fashion. Furthermore, the Organization should review each funding source agreement on a timely basis to verify the accounting treatment is in conformity with generally accepted accounting principles. Response Although management acknowledges that the number of journal entries was less than prior year, it will continue the implementation of new accounting processes and grant accounting treatment recommended from the current and previous year audits to limit the number of changes to the financial statements presented at the beginning of the audit to ensure that the journal entries recorded during future audit periods are non-substantive.
Finding Type Material Weakness Condition During the audit, we noted several instances in which the proper grant accounting was not applied to grant receivables and therefore contribution revenue. We also noted the proper classification between contributions with donor restrictions and without donor restrictions was not achieved. Criteria ASU 2018-08 updates the definition of a contribution and distinguishes transactions between contributions and exchange transactions. For transactions determined to be contributions, the Organization must also determine if the contribution is conditional or unconditional as well as if there are any time or purpose restrictions resulting in the funds being classified as with donor restrictions until the restrictions are satisfied. Cause The proper procedures, including review of agreements and subsequent cash receipts, and related support documents, were not performed by the Organization. Effect The financial statements were not complete with respect to grants receivable and contribution revenue as well as the proper classification of contribution revenue between with donor restrictions and without donor restrictions. Recommendation We recommend all grant agreements and related support documents are reviewed to ensure proper cut-off is achieved. Response The organization has worked to improve its organizational knowledge regarding the accounting of all grant transactions. Key management personnel meet upon awarding of each new grant to discuss the accounting treatment of the grant. With this new process in place, we have made a significant shift to the new standard of recording revenue. While this process has been successful in the majority of grant recordings this past fiscal year, management recognizes we still have some room for growth. We plan to implement a new tracking document and updated spreadsheet as part of this process to ensure we are capturing all relevant information and recording revenue accordingly. This includes a detailed discussion considering the determinations of condition and restrictions. Management expects the new process to reduce the number of year-end adjustments. Management also welcomes assistance and/or tools to better guide revenue recognition.
Finding Type Material Weakness, Repeat Finding Federal Program AmeriCorps, ALN #94.006 Condition During the audit, we noted a significant amount of adjusting journal entries were required to be recorded in order to adjust the year end balances to their appropriate amounts. This includes journal entries related to the Organization?s funding sources as of September 30, 2022. Criteria Accounting books and records should be complete and accurate and include all relevant documentation to support the amounts. Cause Formal procedures related to proper accounting practices were not in place to ensure all activities were addressed and reported appropriately in conformity with generally accepted accounting principles. Effect General ledger accounts were not analyzed and reviewed by management prior to the start of the audit to ensure financial records were properly recorded. Identification of a Repeat Finding This is a repeat finding from the 2021 audit, 2021-004. Recommendation We recommend the Organization review and update, as necessary, its written procedures regarding processing and recording of transactions and monitor such processing to ensure that transactions are processed and reported and reconciled in an accurate manner. This includes maintaining documentation and support for each entry in an orderly fashion. Furthermore, the Organization should review each funding source agreement on a timely basis to verify the accounting treatment is in conformity with generally accepted accounting principles. Response Although management acknowledges that the number of journal entries was less than prior year, it will continue the implementation of new accounting processes and grant accounting treatment recommended from the current and previous year audits to limit the number of changes to the financial statements presented at the beginning of the audit to ensure that the journal entries recorded during future audit periods are non-substantive.
Finding Type Material Weakness Condition During the audit, we noted a significant amount of adjusting journal entries were required to be recorded in order to adjust the year end balances to their appropriate amounts. This includes journal entries related to the Organization?s funding sources as of September 30, 2022. Criteria Accounting books and records should be complete and accurate and include all relevant documentation to support the amounts. Cause Formal procedures related to proper accounting practices were not in place to ensure all activities were addressed and reported appropriately in conformity with generally accepted accounting principles. Effect General ledger accounts were not analyzed and reviewed by management prior to the start of the audit to ensure financial records were properly recorded. Recommendation We recommend the Organization review and update, as necessary, its written procedures regarding processing and recording of transactions and monitor such processing to ensure that transactions are processed and reported and reconciled in an accurate manner. This includes maintaining documentation and support for each entry in an orderly fashion. Furthermore, the Organization should review each funding source agreement on a timely basis to verify the accounting treatment is in conformity with generally accepted accounting principles. Response Although management acknowledges that the number of journal entries was less than prior year, it will continue the implementation of new accounting processes and grant accounting treatment recommended from the current and previous year audits to limit the number of changes to the financial statements presented at the beginning of the audit to ensure that the journal entries recorded during future audit periods are non-substantive.
Finding Type Material Weakness Condition During the audit, we noted several instances in which the proper grant accounting was not applied to grant receivables and therefore contribution revenue. We also noted the proper classification between contributions with donor restrictions and without donor restrictions was not achieved. Criteria ASU 2018-08 updates the definition of a contribution and distinguishes transactions between contributions and exchange transactions. For transactions determined to be contributions, the Organization must also determine if the contribution is conditional or unconditional as well as if there are any time or purpose restrictions resulting in the funds being classified as with donor restrictions until the restrictions are satisfied. Cause The proper procedures, including review of agreements and subsequent cash receipts, and related support documents, were not performed by the Organization. Effect The financial statements were not complete with respect to grants receivable and contribution revenue as well as the proper classification of contribution revenue between with donor restrictions and without donor restrictions. Recommendation We recommend all grant agreements and related support documents are reviewed to ensure proper cut-off is achieved. Response The organization has worked to improve its organizational knowledge regarding the accounting of all grant transactions. Key management personnel meet upon awarding of each new grant to discuss the accounting treatment of the grant. With this new process in place, we have made a significant shift to the new standard of recording revenue. While this process has been successful in the majority of grant recordings this past fiscal year, management recognizes we still have some room for growth. We plan to implement a new tracking document and updated spreadsheet as part of this process to ensure we are capturing all relevant information and recording revenue accordingly. This includes a detailed discussion considering the determinations of condition and restrictions. Management expects the new process to reduce the number of year-end adjustments. Management also welcomes assistance and/or tools to better guide revenue recognition.
Finding Type Material Weakness, Repeat Finding Federal Program AmeriCorps, ALN #94.006 Condition During the audit, we noted a significant amount of adjusting journal entries were required to be recorded in order to adjust the year end balances to their appropriate amounts. This includes journal entries related to the Organization?s funding sources as of September 30, 2022. Criteria Accounting books and records should be complete and accurate and include all relevant documentation to support the amounts. Cause Formal procedures related to proper accounting practices were not in place to ensure all activities were addressed and reported appropriately in conformity with generally accepted accounting principles. Effect General ledger accounts were not analyzed and reviewed by management prior to the start of the audit to ensure financial records were properly recorded. Identification of a Repeat Finding This is a repeat finding from the 2021 audit, 2021-004. Recommendation We recommend the Organization review and update, as necessary, its written procedures regarding processing and recording of transactions and monitor such processing to ensure that transactions are processed and reported and reconciled in an accurate manner. This includes maintaining documentation and support for each entry in an orderly fashion. Furthermore, the Organization should review each funding source agreement on a timely basis to verify the accounting treatment is in conformity with generally accepted accounting principles. Response Although management acknowledges that the number of journal entries was less than prior year, it will continue the implementation of new accounting processes and grant accounting treatment recommended from the current and previous year audits to limit the number of changes to the financial statements presented at the beginning of the audit to ensure that the journal entries recorded during future audit periods are non-substantive.