Finding Text
Condition: During our review of the December 31, 2022 Schedule of Expenditures of Federal Awards (SEFA) prepared by management, we noted that controls over revenue recognition and preparation of the SEFA were not properly designed resulting in material adjustments to several grants and to the SEFA identified during the audit.
Criteria: The Code of Federal Regulations (CFR) Section 200.510(b) states in part, “The auditee must also prepare a schedule of federal expenditures for the period covered by the auditee’s consolidated financial statements which must include the total Federal awards expended as determined in accordance with 200.502.” Also, in accordance with CFR Section 200.302(b) – Financial Management, the auditees financial management system must provide 1) identification of all federal awards received and expended;
2) accurate, current, and complete disclosure of the financial results of each federal award or program;
3) records that identify adequately the source and application of funds for federally-funded activities;
4) effective control over, and accountability for, all funds, property, and other assets; 5) comparison of expenditures with budget amounts for each Federal award; 6) written procedures to implement the requirements of section 200.305 and; 7) written procedures for determining the allowability of costs in accordance with Subpart E and the terms and conditions of the Federal award.
Further, revenue from grants is to be accounted for in accordance with ASU 2018-08 (Topic 958) Clarifying the Scope and Accounting Guidance for Contributions Received and Contributions Made. As most of the Federal grants received are conditional upon expenditure and expenditure in accordance with cost principles, revenue should not be recognized until the relating conditions have been met and therefore right of return is overcome.
Cause: Internal controls over revenue recognition and preparation of the SEFA are not designed effectively to ensure completeness and accuracy of revenues reported and the SEFA.
Effect: As a result of the condition noted above, material audit adjustments were required to be posted to several grants and to the SEFA to properly report federal expenditures in the correct period, as well as revenues reported on the consolidated statement of activities.
Recommendation: We recommend that management review current internal controls over revenue recognition and preparation and tracking of federal expenditures to ensure that revenue is properly reported and, all federal awards are captured and reported in the correct period and that internal controls are properly designed to detect and correct errors to the SEFA.