Audit 377452

Criteria: In accordance with 2 CFR section 200.510(b) (Uniform Guidance), “the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements. The schedule must include the total Federal awards expended as determined in accordance with § 200.502.” Condition: The College did not have controls in place to ensure the Schedule of Expenditures of Federal Awards (SEFA) was accurately reconciled with the general ledger. As a result, there were discrepancies between the amounts reported on the SEFA and the actual expenditures in the College’s accounting records. Cause: The College does not have a process in place to reconcile the SEFA to the general ledger to ensure accurate records. Expense entries (expenditures) are posted by several people across the campus when funds are spent. Revenue entries (drawdowns) are posted by the business office, however there is no process to ensure these drawdowns are the same as the amounts expended. Revenue is also not deferred to the appropriate period when necessary as part of a SEFA reconciliation process. Effect: Without proper reconciliation procedures, there is an increased risk that the SEFA may be materially misstated. The current year SEFA contained net adjustments of $209,443 made by the auditors to reconcile to the general ledger and award letters. Repeat Finding from Prior Year: Yes Recommendation: We recommend management establish an informal procedure to reconcile grant funds received with funds expended on a regular basis. We also recommend management implement a formal procedure to reconcile the SEFA with the general ledger at year end. Views of Responsible Officials: The Comptroller will reconcile this report on a monthly basis making sure that all grants and other Federal / State expenditures are on the SEFA and that the two numbers reconcile with the general ledger. This will be kept in a notebook and the calendar kept in the Comptroller’s desk. The Comptroller will also create a folder in the business office folder on the server and input the current SEFA in this folder and show any discrepancies on a monthly basis and every time this report is run for drawdowns. This process will start immediately. The Comptroller will also make sure at year end that all items are on this report and they have been reconciled with the general ledger. This process will also be in the notebook and calendar within the desk of the Comptroller