Finding 384162 (2023-001)

Significant Deficiency
Requirement
P
Questioned Costs
-
Year
2023
Accepted
2024-03-25
Audit: 297272
Organization: Capitol Technology University (MD)
Auditor: Sb & Company LLC

AI Summary

  • Core Issue: The University failed to complete a full close and review of trial balance accounts by the audit start date, leading to multiple trial balances and unrolled net assets.
  • Impacted Requirements: This situation violates the requirement for maintaining adequate internal controls over financial reporting as per GAAP.
  • Recommended Follow-Up: Management should implement timely year-end close procedures and ensure a thorough review before the audit begins.

Finding Text

Condition: For the year ended June 30, 2023, the University did not complete a full close and review of the trial balance accounts by the start of the audit and multiple trial balances were generated. Net assets were not properly rolled at year end and the balance did not reconcile to the trial balance. Trial balance adjustments were booked after the close process was completed. Criteria: The University is responsible for maintaining an adequate system of internal controls over financial reporting in order to initiate, authorize, record and process and report financial data reliably in accordance with generally accepted accounting principles in the United States of America. Cause: The University did not have the June 30, 2023 financial records closed timely. Effect: The University’s 2023 audit was delayed, and journal entries were required. Questioned Costs: None Recommendation: We recommend management of the University implement close procedures at year end to complete a timely close with review prior to the start of the audit. Auditee’s Response and Corrective Action Plan: Management agrees with the finding. See the corrective action plan.

Corrective Action Plan

Finding 2023-001 Significant Deficiency over Financial Reporting Management agrees with the finding. Corrective action plan follows. The College acknowledges that it did not complete a full close and review of the trial balance accounts by the start of the audit and that multiple trial balances were generated. It acknowledges that net assets were not properly rolled at year end and the balance did not reconcile to the trial balance, and that trial balance adjustments were booked after the close process was completed. Management has reviewed its yearend close procedures and has implemented the following guidelines to ensure an accurate and timely close: The College can better prepare for yearend close by reinforcing its month end close procedures. Month end close procedures and reconciliations were inconsistent throughout the year. The College has established a checklist of monthly processes, recurring journal entries, and the support needed to complete the reconciliation process. Reconciling accounts on a monthly basis allows for the identification and correction of errors in a timely manner. Monthly reconciliations are kept on a shared network and can be accessed by all Business Office team members. The VP of Finance will review monthly bank reconciliations to ensure accuracy and timeliness. Net Assets have been reviewed and agreed to the prior year audit report. The College has a detailed yearend checklist which includes a list of yearend journal entries, and a detailed list of the schedules provided to auditors. The College will prepare a close schedule identifying important dates, activities and responsibilities to ensure items are completed in a timely manner and that all necessary deadlines are met. Yearend schedules are on a shared network drive so that progress and accuracy can be monitored. The VP of Finance will hold regular meetings with the Business Office team to monitor yearend close progress. Once the yearend close has been established, all reports will be reviewed and compared to previous year’s figures to identify any unexpected changes, and agreed to the final trial balance prior to uploading to the audit portal. No adjustments will be allowed once the trial balance has been finalized without consultation with the auditors. The Business Office team will continue to reevaluate any processes or systems used during the previous yearend closes and update them as needed, such as setting up new accounts, reviewing current statements for accuracy, or revising account coding. Contact Person: Kathleen Werner, Interim VP Finance Completion Date: June 30, 2024

Categories

Reporting Internal Control / Segregation of Duties

Other Findings in this Audit

  • 384163 2023-001
    Significant Deficiency
  • 384164 2023-001
    Significant Deficiency
  • 384165 2023-001
    Significant Deficiency
  • 384166 2023-001
    Significant Deficiency
  • 384167 2023-001
    Significant Deficiency
  • 384168 2023-001
    Significant Deficiency
  • 384169 2023-001
    Significant Deficiency
  • 384170 2023-001
    Significant Deficiency
  • 384171 2023-001
    Significant Deficiency
  • 384172 2023-002
    Significant Deficiency Repeat
  • 384173 2023-002
    Significant Deficiency Repeat
  • 384174 2023-002
    Significant Deficiency Repeat
  • 384175 2023-002
    Significant Deficiency Repeat
  • 384176 2023-002
    Significant Deficiency Repeat
  • 960604 2023-001
    Significant Deficiency
  • 960605 2023-001
    Significant Deficiency
  • 960606 2023-001
    Significant Deficiency
  • 960607 2023-001
    Significant Deficiency
  • 960608 2023-001
    Significant Deficiency
  • 960609 2023-001
    Significant Deficiency
  • 960610 2023-001
    Significant Deficiency
  • 960611 2023-001
    Significant Deficiency
  • 960612 2023-001
    Significant Deficiency
  • 960613 2023-001
    Significant Deficiency
  • 960614 2023-002
    Significant Deficiency Repeat
  • 960615 2023-002
    Significant Deficiency Repeat
  • 960616 2023-002
    Significant Deficiency Repeat
  • 960617 2023-002
    Significant Deficiency Repeat
  • 960618 2023-002
    Significant Deficiency Repeat

Programs in Audit

ALN Program Name Expenditures
84.268 Federal Direct Student Loans (fdsl) $5.98M
84.038 Federal Perkins Loans (fpl) $757,340
84.063 Federal Pell Grant Program (pell) $524,052
12.902 Cysp $240,101
12.902 Ncaec $89,650
84.007 Federal Supplemental Educational Opportunity Grants (seog) $77,274
84.033 Federal Work-Study Program (fws) $66,105
84.425 Heerf - Institutional - Covid-19 $55,716
12.902 Cae Regional Hub (subaward Dod) $49,905
12.902 National Security Agency $43,770