Audit 316830

FY End
2022-06-30
Total Expended
$831,313
Findings
4
Programs
3
Year: 2022 Accepted: 2024-08-07

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
480639 2022-002 Significant Deficiency - A
480640 2022-003 Material Weakness - A
1057081 2022-002 Significant Deficiency - A
1057082 2022-003 Material Weakness - A

Programs

ALN Program Spent Major Findings
10.558 Child and Adult Care Food Program $681,994 Yes 2
21.027 Coronavirus State and Local Fiscal Recovery Funds $80,822 - 0
14.218 Community Development Block Grants/entitlement Grants $52,772 - 0

Contacts

Name Title Type
SQ3HHTQZWL59 Missie Forbes Auditee
3193387684 Ross Van Laar Auditor
No contacts on file

Notes to SEFA

Title: Basis of Presentation Accounting Policies: Expenditures reported on the Schedule are reported on the 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 to reimbursement. De Minimis Rate Used: N Rate Explanation: Community Coordinated Child Care opted not to use the 10-percent de minimis indirect cost rate allowed under the Uniform Guidance The accompanying schedule of expenditures of federal awards (Schedule) includes the federal award activity of Community Coordinated Child Care under programs of the federal government for the year ended June 30, 2022. 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 Community Coordinated Child Care, it is not intended to and does not present the financial position, changes in net assets, or cash flows of Community Coordinated Child Care.
Title: Subrecipients Accounting Policies: Expenditures reported on the Schedule are reported on the 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 to reimbursement. De Minimis Rate Used: N Rate Explanation: Community Coordinated Child Care opted not to use the 10-percent de minimis indirect cost rate allowed under the Uniform Guidance There were noawards passed through to subrecipients.

Finding Details

Significant Deficiency in Internal Control Over Financial Reporting and Significant Deficiency in Internal Control Over Compliance: Auditing Finding 2022-002 - Transactions Recorded from Bank Statement Criteria: Transactions should be recorded in the accounting system based on the dates they occur. Condition: The Organization works with an outsourced provider to maintain its accounting system and record transactions. We noted a number of transactions were recorded from the bank statement with some inconsistencies in dates and classification. Some of these inconsistencies were present in documentation reviewed during testing of the major program. Cause: Internal controls are not designed to ensure recorded transactions are accurately entered into the accounting system and correctly classified. No formal review of the entries made occurs, besides high-level review by the Executive Director and Board of Directors in scheduled meetings. Effect: Misstatements could occur and not be detected. Recommendation: We suggest the Organization implement a more detailed review of recorded transactions and the reports generated at month-end to ensure accuracy, completeness, and proper classification of transactions. Views of responsible officials: Management agrees with the finding. Procedures will be discussed to provide information to third-party accountant to reconcile transactions based on source documentation instead of recording from the bank statement, and management will perform a more detailed review on recorded transaction.
Material Weakness in Internal Control Over Compliance Auditing Finding 2022-003 - Preparation of Schedule of Expenditures of Federal Awards Criteria: The Organization should have procedures in place to prepare an accurate Schedule of Expenditures of Federal Awards, capturing proper amounts of expenditures during the year, and reporting the correct CFDA catalog numbers. Condition: As discussed in Finding 2022-001, material audit adjustments were necessary to report the correct federal expenditures, and federal award program information was not available from management at the time of the audit. Management reviewed and took responsibility for the Schedule after the adjustments had been made. Cause: Internal controls are not designed to facilitate an accurate and complete presentation of the Schedule of Expenditures of Federal Awards. Effect: Adjustments were necessary to report the Schedule of Expenditures of Federal Awards on an accrual basis and in compliance with the Uniform Guidance. Questioned Costs: $0 Recommendation: We suggest the Organization evaluate its procedures for accumulating its federal awards and reconcile on an accrual basis to properly determine whether Single Audit thresholds are met, and whether the Schedule is prepared in accordance with the requirements of the Uniform Guidance. Views of responsible officials: Management agrees with the finding. An accrual basis Schedule of Expenditures of Federal Awards will be prepared in the future as part of year-end close procedures.
Significant Deficiency in Internal Control Over Financial Reporting and Significant Deficiency in Internal Control Over Compliance: Auditing Finding 2022-002 - Transactions Recorded from Bank Statement Criteria: Transactions should be recorded in the accounting system based on the dates they occur. Condition: The Organization works with an outsourced provider to maintain its accounting system and record transactions. We noted a number of transactions were recorded from the bank statement with some inconsistencies in dates and classification. Some of these inconsistencies were present in documentation reviewed during testing of the major program. Cause: Internal controls are not designed to ensure recorded transactions are accurately entered into the accounting system and correctly classified. No formal review of the entries made occurs, besides high-level review by the Executive Director and Board of Directors in scheduled meetings. Effect: Misstatements could occur and not be detected. Recommendation: We suggest the Organization implement a more detailed review of recorded transactions and the reports generated at month-end to ensure accuracy, completeness, and proper classification of transactions. Views of responsible officials: Management agrees with the finding. Procedures will be discussed to provide information to third-party accountant to reconcile transactions based on source documentation instead of recording from the bank statement, and management will perform a more detailed review on recorded transaction.
Material Weakness in Internal Control Over Compliance Auditing Finding 2022-003 - Preparation of Schedule of Expenditures of Federal Awards Criteria: The Organization should have procedures in place to prepare an accurate Schedule of Expenditures of Federal Awards, capturing proper amounts of expenditures during the year, and reporting the correct CFDA catalog numbers. Condition: As discussed in Finding 2022-001, material audit adjustments were necessary to report the correct federal expenditures, and federal award program information was not available from management at the time of the audit. Management reviewed and took responsibility for the Schedule after the adjustments had been made. Cause: Internal controls are not designed to facilitate an accurate and complete presentation of the Schedule of Expenditures of Federal Awards. Effect: Adjustments were necessary to report the Schedule of Expenditures of Federal Awards on an accrual basis and in compliance with the Uniform Guidance. Questioned Costs: $0 Recommendation: We suggest the Organization evaluate its procedures for accumulating its federal awards and reconcile on an accrual basis to properly determine whether Single Audit thresholds are met, and whether the Schedule is prepared in accordance with the requirements of the Uniform Guidance. Views of responsible officials: Management agrees with the finding. An accrual basis Schedule of Expenditures of Federal Awards will be prepared in the future as part of year-end close procedures.