Finding Text
Preparation of the Schedule of Expenditures of Federal Awards.
Federal Program Information: Child and Adult Care Food Program (Federal Assistance Listing #10.558) and the Twenty-First Century Community Centers Program (Federal Assistance Listing #84.287C)
Condition and Criteria: The Schedule of Expenditures of Federal Awards (“SEFA”) is prepared using source information other than the financial reports generated by the accounting system. As a result, the Organization’s internally prepared SEFA did not agree to the Organization’s financial records.
Prior Year Audit Finding: 2022-002
Cause and Effect: The SEFA was prepared based on information obtained outside of the accounting system due to the complexity of tracking the various expenditures by funding source within the accounting system. This could result in an incomplete or inaccurate SEFA.
Context: This represents a systemic problem.
Questioned Costs: None.
Recommendation: Total expenditures reported on the SEFA are compiled through reviewing draw down reports and estimated spending amounts. These amounts do not always tie out to financial information in the accounting system due to the complexity of tracking the federal grant expenditures by funding source. Therefore, we recommend management create a reconciliation of the financial information maintained obtained outside of the accounting system and the accounting system in order to ensure all federal expenditures are included and reported accurately on the SEFA.
Management’s Response: Management has determined it is not practical to enter all expenditures into the accounting software by fund source, and tracks the data outside of the accounting software. Management will continue to search for alternatives for entry into the accounting software which are financially feasible.