Audit 35462

FY End
2022-08-31
Total Expended
$4.16M
Findings
8
Programs
10
Organization: Borger Junior College District (TX)
Year: 2022 Accepted: 2023-01-04

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
38291 2022-003 Significant Deficiency Yes L
38292 2022-002 Significant Deficiency Yes L
38293 2022-003 Significant Deficiency Yes L
38294 2022-004 Significant Deficiency Yes I
614733 2022-003 Significant Deficiency Yes L
614734 2022-002 Significant Deficiency Yes L
614735 2022-003 Significant Deficiency Yes L
614736 2022-004 Significant Deficiency Yes I

Contacts

Name Title Type
WGASX9FUY5C4 Glendon Forgey Auditee
8064574200 Janie Arnold Auditor
No contacts on file

Notes to SEFA

Title: Loan/loan guarantee outstanding balances Accounting Policies: NOTE 1 - FEDERAL ASSISTANCE RECONCILIATION Federal grants and contracts revenue, operating - per Schedule A $1,720,642 Federal grants and contracts revenue, nonoperating-per Schedule C $2,072,761 Federal Direct Student Loans $366,626 Total federal revenues per Schedule of Expenditures of Federal Awards $ 4,160,029 NOTE 2 - SIGNIFICANT ACCOUNTING POLICIES USED IN PREPARING THE SCHEDULE - The expenditures included in the schedule are reported for the College's fiscal year. Expenditure reports to funding agencies are prepared on the award period basis. The expenditures reported above represent funds which have been expended by the College for the purposes of the award. The expenditures reported above may not have been reimbursed by the funding agencies as of the end of the fiscal year. Some amounts reported in the schedule may differ from amounts used in the preparation of the basic financial statements. Separate accounts are maintained for the different awards to aid in the observance of limitations and restrictions imposed by the funding agencies. The College has followed all applicable guidelines issued by various entities in the preparation of the schedule. The College elected not to use the 10% de minimis indirect cost rate. The College uses 8% indirect cost rate for TRIO as authorized by the grant. The College did not provide pass-through funds to subrecipients for the year ended August 31, 2022. NOTE 3 - NONCASH AWARDS - There were no federal noncash awards in fiscal year 2022 other than Federal Direct Student Loans discussed in Note 1 above. NOTE 4 - HIGHER EDUCATION EMERGENCY FUND - The Coronavirus Aid, Relief, and Economic Security (CARES) Act was signed into law on March 27, 2020, by the President and established the Higher Education Emergency Relief Fund (HEERF). The HEERF grant programs allowed (Assistance Listing 84.425F,L) for reimbursement of lost revenue. For the year ended, August 31, 2022, $103,042 of estimated lost revenue is included in the schedule of expenditures of federal awards for Assistant Listing 84.425L and $31,342 of estimated lost revenue is included in the schedule of expenditures of federal awards for Assistance Listing 84.425F. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. FEDERAL DIRECT STUDENT LOANS (84.268) - Balances outstanding at the end of the audit period were $366,626.

Finding Details

Program: COVID-19 Education Stabilization Fund ALN 84.425F, Higher Education Emergency Relief Fund ? Institutional Portion COVID-19 Education Stabilization Fund ALN 84.425E, Higher Education Emergency Relief Fund ? Student Funds??.Program Requirement: Reporting Criteria: Pursuant to 2022 Compliance Supplement ESF Section 2 III L, an institution must post a report covering amounts spent during the quarter for HEERF I, HEERF II, and HEERF III funds each quarterly reporting period no later than 10 days after the end of each calendar quarter. Condition: The quarterly report for 84.425F for June 2022 was not posted to the College website within 10 days. The quarterly report for 84.425E for December 2021 was not posted to the College website. Context: One out of four reports for ALN 84.425F were not posted timely. Three out of three quarterly reports for ALN 84.425E were not posted. Cause: For ALN 84.425F, the person responsible for completing the report did not complete the report timely. For ALN 84.425E, the person responsible for the report was not aware of the reporting requirement. Effect: The College was not in compliance with reporting requirements. Questioned Costs: None Repeat Finding: Yes Recommendation: The College needs to ensure reports are posted timely Views of Responsible Officials: The College agrees with the recommendation to post the reports timely.
Program: COVID-19 Education Stabilization Fund ALN 84.425F Higher Education Emergency Relief Fund ? Institutional Portion Program Requirement: Reporting Criteria: Pursuant to 2022 Compliance Supplement ESF Section 2 III L, an institution must post a report covering amounts spent during the quarter for HEERF I, HEERF II, and HEERF III funds each quarterly reporting period no later than 10 days after the end of each calendar quarter. The report includes the total amount of funds received to date for each Suffix. Condition: The total funds received to date reported under suffix F was the amount of both the suffix E and F grants. The general ledger accounts used to support the HEERF Institutional Portion reporting did not include all of the HEERF expenditures due to a journal entry post error. The error was not timely detected during the College?s quarterly reconciliation of grant revenues and expenditures. The error was detected and corrected prior to year end. Context: Journal entries were recorded incorrectly to the general ledger, resulting in incorrect reports for the quarters tested. The entries were corrected between the report date and year end. The total funds received to date was incorrect on three out of four quarterly reports. Cause: The Business Office did not properly review the reconciliation of grant expenditures or the total funding by suffix. Effect: Errors could go unnoticed and not be detected and corrected in a timely manner. Questioned Costs: None Repeat Finding: Yes Recommendation: Reconciliations of grant revenue and expenditures should be performed monthly, with a detailed review of account balances to ensure accuracy and proper reporting. Views of Responsible Officials: The College agrees with the recommendation to perform monthly reconciliations, a detailed review of account balances to ensure accuracy and proper reporting.
Program: COVID-19 Education Stabilization Fund ALN 84.425F, Higher Education Emergency Relief Fund ? Institutional Portion COVID-19 Education Stabilization Fund ALN 84.425E, Higher Education Emergency Relief Fund ? Student Funds??.Program Requirement: Reporting Criteria: Pursuant to 2022 Compliance Supplement ESF Section 2 III L, an institution must post a report covering amounts spent during the quarter for HEERF I, HEERF II, and HEERF III funds each quarterly reporting period no later than 10 days after the end of each calendar quarter. Condition: The quarterly report for 84.425F for June 2022 was not posted to the College website within 10 days. The quarterly report for 84.425E for December 2021 was not posted to the College website. Context: One out of four reports for ALN 84.425F were not posted timely. Three out of three quarterly reports for ALN 84.425E were not posted. Cause: For ALN 84.425F, the person responsible for completing the report did not complete the report timely. For ALN 84.425E, the person responsible for the report was not aware of the reporting requirement. Effect: The College was not in compliance with reporting requirements. Questioned Costs: None Repeat Finding: Yes Recommendation: The College needs to ensure reports are posted timely Views of Responsible Officials: The College agrees with the recommendation to post the reports timely.
Program: COVID-19 Education Stabilization Fund ALN 84.425F, Higher Education Emergency Relief Fund ? Institutional Portion Program Requirement: Procurement Criteria: Pursuant to 2 CFR Section 200.320 (a) 2 (i) If small purchase procedures are used, price or rate quotations must be obtained from an adequate number of qualified sources as determined appropriate by the non-Federal entity. Condition: Procurement files did not have adequate supporting documentation. Items purchased under small purchase procedures did not have written documentation of quotes obtained or only contained one quote. Context: Four out of five items tested subject to small purchase procurement requirements did not have written quotes. One out of five items tested only had one quote and no justification for why more than one quote was not obtained. Four out of five items would have complied with the Compliance Supplement if they had updated their policy to reflect the higher micro-purchase limit allowed by state law and the Compliance Supplement. Cause: The College noted that the State allowed a micro-purchase threshold up to $25,000 but did not update their policy or complete the annual self-certification for micro-purchase thresholds greater than $10,000 prior to implementing the new threshold. The College did not document verbal quotes for items over $25,000. Effect: The College is not able to provide proper supporting documentation of compliance with the small purchase requirements. Questioned Costs: None Repeat Finding: Yes Recommendation: The College needs to implement a review process of procurement files to ensure that proper supporting documentation is obtained and included in the procurement files. The College to update their policy to reflect the micro-purchase threshold they have deemed appropriate and complete the required annual self-certification. Views of Responsible Officials: The College agrees with the recommendation to obtain written quotes from vendors for purchases and to update their policy and to complete an annual self-certification for micro-purchase threshold over $10,000.
Program: COVID-19 Education Stabilization Fund ALN 84.425F, Higher Education Emergency Relief Fund ? Institutional Portion COVID-19 Education Stabilization Fund ALN 84.425E, Higher Education Emergency Relief Fund ? Student Funds??.Program Requirement: Reporting Criteria: Pursuant to 2022 Compliance Supplement ESF Section 2 III L, an institution must post a report covering amounts spent during the quarter for HEERF I, HEERF II, and HEERF III funds each quarterly reporting period no later than 10 days after the end of each calendar quarter. Condition: The quarterly report for 84.425F for June 2022 was not posted to the College website within 10 days. The quarterly report for 84.425E for December 2021 was not posted to the College website. Context: One out of four reports for ALN 84.425F were not posted timely. Three out of three quarterly reports for ALN 84.425E were not posted. Cause: For ALN 84.425F, the person responsible for completing the report did not complete the report timely. For ALN 84.425E, the person responsible for the report was not aware of the reporting requirement. Effect: The College was not in compliance with reporting requirements. Questioned Costs: None Repeat Finding: Yes Recommendation: The College needs to ensure reports are posted timely Views of Responsible Officials: The College agrees with the recommendation to post the reports timely.
Program: COVID-19 Education Stabilization Fund ALN 84.425F Higher Education Emergency Relief Fund ? Institutional Portion Program Requirement: Reporting Criteria: Pursuant to 2022 Compliance Supplement ESF Section 2 III L, an institution must post a report covering amounts spent during the quarter for HEERF I, HEERF II, and HEERF III funds each quarterly reporting period no later than 10 days after the end of each calendar quarter. The report includes the total amount of funds received to date for each Suffix. Condition: The total funds received to date reported under suffix F was the amount of both the suffix E and F grants. The general ledger accounts used to support the HEERF Institutional Portion reporting did not include all of the HEERF expenditures due to a journal entry post error. The error was not timely detected during the College?s quarterly reconciliation of grant revenues and expenditures. The error was detected and corrected prior to year end. Context: Journal entries were recorded incorrectly to the general ledger, resulting in incorrect reports for the quarters tested. The entries were corrected between the report date and year end. The total funds received to date was incorrect on three out of four quarterly reports. Cause: The Business Office did not properly review the reconciliation of grant expenditures or the total funding by suffix. Effect: Errors could go unnoticed and not be detected and corrected in a timely manner. Questioned Costs: None Repeat Finding: Yes Recommendation: Reconciliations of grant revenue and expenditures should be performed monthly, with a detailed review of account balances to ensure accuracy and proper reporting. Views of Responsible Officials: The College agrees with the recommendation to perform monthly reconciliations, a detailed review of account balances to ensure accuracy and proper reporting.
Program: COVID-19 Education Stabilization Fund ALN 84.425F, Higher Education Emergency Relief Fund ? Institutional Portion COVID-19 Education Stabilization Fund ALN 84.425E, Higher Education Emergency Relief Fund ? Student Funds??.Program Requirement: Reporting Criteria: Pursuant to 2022 Compliance Supplement ESF Section 2 III L, an institution must post a report covering amounts spent during the quarter for HEERF I, HEERF II, and HEERF III funds each quarterly reporting period no later than 10 days after the end of each calendar quarter. Condition: The quarterly report for 84.425F for June 2022 was not posted to the College website within 10 days. The quarterly report for 84.425E for December 2021 was not posted to the College website. Context: One out of four reports for ALN 84.425F were not posted timely. Three out of three quarterly reports for ALN 84.425E were not posted. Cause: For ALN 84.425F, the person responsible for completing the report did not complete the report timely. For ALN 84.425E, the person responsible for the report was not aware of the reporting requirement. Effect: The College was not in compliance with reporting requirements. Questioned Costs: None Repeat Finding: Yes Recommendation: The College needs to ensure reports are posted timely Views of Responsible Officials: The College agrees with the recommendation to post the reports timely.
Program: COVID-19 Education Stabilization Fund ALN 84.425F, Higher Education Emergency Relief Fund ? Institutional Portion Program Requirement: Procurement Criteria: Pursuant to 2 CFR Section 200.320 (a) 2 (i) If small purchase procedures are used, price or rate quotations must be obtained from an adequate number of qualified sources as determined appropriate by the non-Federal entity. Condition: Procurement files did not have adequate supporting documentation. Items purchased under small purchase procedures did not have written documentation of quotes obtained or only contained one quote. Context: Four out of five items tested subject to small purchase procurement requirements did not have written quotes. One out of five items tested only had one quote and no justification for why more than one quote was not obtained. Four out of five items would have complied with the Compliance Supplement if they had updated their policy to reflect the higher micro-purchase limit allowed by state law and the Compliance Supplement. Cause: The College noted that the State allowed a micro-purchase threshold up to $25,000 but did not update their policy or complete the annual self-certification for micro-purchase thresholds greater than $10,000 prior to implementing the new threshold. The College did not document verbal quotes for items over $25,000. Effect: The College is not able to provide proper supporting documentation of compliance with the small purchase requirements. Questioned Costs: None Repeat Finding: Yes Recommendation: The College needs to implement a review process of procurement files to ensure that proper supporting documentation is obtained and included in the procurement files. The College to update their policy to reflect the micro-purchase threshold they have deemed appropriate and complete the required annual self-certification. Views of Responsible Officials: The College agrees with the recommendation to obtain written quotes from vendors for purchases and to update their policy and to complete an annual self-certification for micro-purchase threshold over $10,000.