Audit 364132

FY End
2024-06-30
Total Expended
$7.93M
Findings
66
Programs
12
Organization: Leech Lake Tribal College (AZ)
Year: 2024 Accepted: 2025-08-12
Auditor: Redw

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
573328 2024-002 Material Weakness Yes ABCGIL
573329 2024-002 Material Weakness Yes ABCFGIL
573330 2024-002 Material Weakness Yes ABCFGIL
573331 2024-002 Material Weakness Yes CELN
573332 2024-002 Material Weakness Yes ABIL
573333 2024-002 Material Weakness Yes ABIL
573334 2024-003 Material Weakness Yes L
573335 2024-003 Material Weakness Yes L
573336 2024-003 Material Weakness Yes L
573337 2024-003 Material Weakness Yes L
573338 2024-003 Material Weakness Yes L
573339 2024-003 Material Weakness Yes L
573340 2024-004 Significant Deficiency - F
573341 2024-004 Significant Deficiency - F
573342 2024-005 Material Weakness Yes I
573343 2024-005 Material Weakness Yes I
573344 2024-005 Material Weakness Yes I
573345 2024-005 Material Weakness Yes I
573346 2024-005 Material Weakness Yes I
573347 2024-006 Significant Deficiency Yes L
573348 2024-006 Significant Deficiency Yes L
573349 2024-006 Significant Deficiency Yes L
573350 2024-006 Significant Deficiency Yes L
573351 2024-006 Significant Deficiency Yes L
573352 2024-007 Significant Deficiency - L
573353 2024-008 Material Weakness - N
573354 2024-009 Material Weakness - N
573355 2024-010 Material Weakness - N
573356 2024-011 Material Weakness - N
573357 2024-012 Significant Deficiency - A
573358 2024-012 Significant Deficiency - A
573359 2024-012 Significant Deficiency - A
573360 2024-012 Significant Deficiency - A
1149770 2024-002 Material Weakness Yes ABCGIL
1149771 2024-002 Material Weakness Yes ABCFGIL
1149772 2024-002 Material Weakness Yes ABCFGIL
1149773 2024-002 Material Weakness Yes CELN
1149774 2024-002 Material Weakness Yes ABIL
1149775 2024-002 Material Weakness Yes ABIL
1149776 2024-003 Material Weakness Yes L
1149777 2024-003 Material Weakness Yes L
1149778 2024-003 Material Weakness Yes L
1149779 2024-003 Material Weakness Yes L
1149780 2024-003 Material Weakness Yes L
1149781 2024-003 Material Weakness Yes L
1149782 2024-004 Significant Deficiency - F
1149783 2024-004 Significant Deficiency - F
1149784 2024-005 Material Weakness Yes I
1149785 2024-005 Material Weakness Yes I
1149786 2024-005 Material Weakness Yes I
1149787 2024-005 Material Weakness Yes I
1149788 2024-005 Material Weakness Yes I
1149789 2024-006 Significant Deficiency Yes L
1149790 2024-006 Significant Deficiency Yes L
1149791 2024-006 Significant Deficiency Yes L
1149792 2024-006 Significant Deficiency Yes L
1149793 2024-006 Significant Deficiency Yes L
1149794 2024-007 Significant Deficiency - L
1149795 2024-008 Material Weakness - N
1149796 2024-009 Material Weakness - N
1149797 2024-010 Material Weakness - N
1149798 2024-011 Material Weakness - N
1149799 2024-012 Significant Deficiency - A
1149800 2024-012 Significant Deficiency - A
1149801 2024-012 Significant Deficiency - A
1149802 2024-012 Significant Deficiency - A

Contacts

Name Title Type
N4FUN5A9WCN8 Burt Howard Auditee
2183354253 Kyle Foutz Auditor
No contacts on file

Notes to SEFA

Title: Summary of Significant Accounting Policies Accounting Policies: Expenditures reported on the Schedule are reported on the modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: Leech Lake Tribal College, has not elected to use the 10-percent de minimis indirect cost rate as allowed under the Uniform Guidance. Expenditures reported on the Schedule are reported on the modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement.
Title: Indirect Cost Rate Accounting Policies: Expenditures reported on the Schedule are reported on the modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: Leech Lake Tribal College, has not elected to use the 10-percent de minimis indirect cost rate as allowed under the Uniform Guidance. Leech Lake Tribal College, has not elected to use the 10-percent de minimis indirect cost rate as allowed under the Uniform Guidance.
Title: Basis of Presentation Accounting Policies: Expenditures reported on the Schedule are reported on the modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: Leech Lake Tribal College, has not elected to use the 10-percent de minimis indirect cost rate as allowed under the Uniform Guidance. The accompanying schedule of expenditures of federal awards (the “Schedule” includes the Federal grant activity of Leech Lake Tribal College under programs of the federal government for the year ended June 30, 2024. The information in this schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Because the Schedule presents only a selected portion of the operations of Leech Lake Tribal College it is not intended to and does not present the financial position, changes in net position or cash flows of Leech Lake Tribal College.
Title: Endowment Accounting Policies: Expenditures reported on the Schedule are reported on the modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: Leech Lake Tribal College, has not elected to use the 10-percent de minimis indirect cost rate as allowed under the Uniform Guidance. The amount of federal endowment funds received by the College and restricted as of June 30, 2024, is as follows: Federal Program ALN Amount Higher Education Institutional Aid 84.031 $ 4,322,652 Assistance to Tribally Controlled Community Colleges 15.027 $1,454,391 $ 5,777,043 These funds are reported as restricted investments in the other governmental funds on the governmental funds balance sheet.
Title: Reconciliation of Total Federal Awards to Total Federal Expenditures Accounting Policies: Expenditures reported on the Schedule are reported on the modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: Leech Lake Tribal College, has not elected to use the 10-percent de minimis indirect cost rate as allowed under the Uniform Guidance. Total revenues reported on the statement of revenues, expenses, and changes in net position $ 7,928,252 Total expenditures of federal awards $ 7,928,252
Title: Subrecipients Accounting Policies: Expenditures reported on the Schedule are reported on the modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: Leech Lake Tribal College, has not elected to use the 10-percent de minimis indirect cost rate as allowed under the Uniform Guidance. The College did not provide federal awards to subrecipients during the year ended June 30, 2024.

Finding Details

2024-002 — IT – Material Weakness in Internal Control Over Compliance and Noncompliance (Repeat of finding 2023-003) Federal program information: Funding agencies: U.S. Department of Interior and U.S. Department of Education Titles: Assistance to Tribally Controlled Community Colleges; Higher Education Institutional Aid; Education Stabilization Fund; and SFA Cluster- Pell Grant Program ALN Number: 15.027, 84.031, 84.425, and 84.063 Award years: Various Criteria: Without strong information technology internal controls and established policies and procedures, there is the potential for integrity of financial records, the confidentiality, integrity and/or availability of data to be compromised. This compromise could be by an internal user of the system, by an external source (hacker) and could be intentional or unintentional. Condition: The College’s IT control environment is lacking certain key controls. There are currently no formalized IT policies and procedures, sufficient data backup processes, or a formalized disaster recovery plan. IT controls are not in place to ensure non-authorized individuals are restricted from adding new vendors, recording journal entries, and making/or changes to employee pay records. Questioned Costs: N/A Cause: The IT controls have not been properly designed and implemented. Effect: The College is exposed to many risks regarding the integrity of the financial records, confidentiality, integrity, and/or availability of its data. It is possible that their data could be compromised. Compromise could be by an internal user of the system, by an external source (hacker) and could be intentional or unintentional. Additionally, during fiscal year 2024, the College experienced an outage which resulted in a loss of data. As no backup procedures were in place, amounts had to be restored in the system using other financial source data. Auditor’s Recommendations: Establishing IT controls, policies and procedures, off-site electronic data backups, and a disaster recovery plan would better prepare the College for technology related issues, system crashes, or data breaches. Management’s Response: The College is implementing policies and procedures.
2024-002 — IT – Material Weakness in Internal Control Over Compliance and Noncompliance (Repeat of finding 2023-003) Federal program information: Funding agencies: U.S. Department of Interior and U.S. Department of Education Titles: Assistance to Tribally Controlled Community Colleges; Higher Education Institutional Aid; Education Stabilization Fund; and SFA Cluster- Pell Grant Program ALN Number: 15.027, 84.031, 84.425, and 84.063 Award years: Various Criteria: Without strong information technology internal controls and established policies and procedures, there is the potential for integrity of financial records, the confidentiality, integrity and/or availability of data to be compromised. This compromise could be by an internal user of the system, by an external source (hacker) and could be intentional or unintentional. Condition: The College’s IT control environment is lacking certain key controls. There are currently no formalized IT policies and procedures, sufficient data backup processes, or a formalized disaster recovery plan. IT controls are not in place to ensure non-authorized individuals are restricted from adding new vendors, recording journal entries, and making/or changes to employee pay records. Questioned Costs: N/A Cause: The IT controls have not been properly designed and implemented. Effect: The College is exposed to many risks regarding the integrity of the financial records, confidentiality, integrity, and/or availability of its data. It is possible that their data could be compromised. Compromise could be by an internal user of the system, by an external source (hacker) and could be intentional or unintentional. Additionally, during fiscal year 2024, the College experienced an outage which resulted in a loss of data. As no backup procedures were in place, amounts had to be restored in the system using other financial source data. Auditor’s Recommendations: Establishing IT controls, policies and procedures, off-site electronic data backups, and a disaster recovery plan would better prepare the College for technology related issues, system crashes, or data breaches. Management’s Response: The College is implementing policies and procedures.
2024-002 — IT – Material Weakness in Internal Control Over Compliance and Noncompliance (Repeat of finding 2023-003) Federal program information: Funding agencies: U.S. Department of Interior and U.S. Department of Education Titles: Assistance to Tribally Controlled Community Colleges; Higher Education Institutional Aid; Education Stabilization Fund; and SFA Cluster- Pell Grant Program ALN Number: 15.027, 84.031, 84.425, and 84.063 Award years: Various Criteria: Without strong information technology internal controls and established policies and procedures, there is the potential for integrity of financial records, the confidentiality, integrity and/or availability of data to be compromised. This compromise could be by an internal user of the system, by an external source (hacker) and could be intentional or unintentional. Condition: The College’s IT control environment is lacking certain key controls. There are currently no formalized IT policies and procedures, sufficient data backup processes, or a formalized disaster recovery plan. IT controls are not in place to ensure non-authorized individuals are restricted from adding new vendors, recording journal entries, and making/or changes to employee pay records. Questioned Costs: N/A Cause: The IT controls have not been properly designed and implemented. Effect: The College is exposed to many risks regarding the integrity of the financial records, confidentiality, integrity, and/or availability of its data. It is possible that their data could be compromised. Compromise could be by an internal user of the system, by an external source (hacker) and could be intentional or unintentional. Additionally, during fiscal year 2024, the College experienced an outage which resulted in a loss of data. As no backup procedures were in place, amounts had to be restored in the system using other financial source data. Auditor’s Recommendations: Establishing IT controls, policies and procedures, off-site electronic data backups, and a disaster recovery plan would better prepare the College for technology related issues, system crashes, or data breaches. Management’s Response: The College is implementing policies and procedures.
2024-002 — IT – Material Weakness in Internal Control Over Compliance and Noncompliance (Repeat of finding 2023-003) Federal program information: Funding agencies: U.S. Department of Interior and U.S. Department of Education Titles: Assistance to Tribally Controlled Community Colleges; Higher Education Institutional Aid; Education Stabilization Fund; and SFA Cluster- Pell Grant Program ALN Number: 15.027, 84.031, 84.425, and 84.063 Award years: Various Criteria: Without strong information technology internal controls and established policies and procedures, there is the potential for integrity of financial records, the confidentiality, integrity and/or availability of data to be compromised. This compromise could be by an internal user of the system, by an external source (hacker) and could be intentional or unintentional. Condition: The College’s IT control environment is lacking certain key controls. There are currently no formalized IT policies and procedures, sufficient data backup processes, or a formalized disaster recovery plan. IT controls are not in place to ensure non-authorized individuals are restricted from adding new vendors, recording journal entries, and making/or changes to employee pay records. Questioned Costs: N/A Cause: The IT controls have not been properly designed and implemented. Effect: The College is exposed to many risks regarding the integrity of the financial records, confidentiality, integrity, and/or availability of its data. It is possible that their data could be compromised. Compromise could be by an internal user of the system, by an external source (hacker) and could be intentional or unintentional. Additionally, during fiscal year 2024, the College experienced an outage which resulted in a loss of data. As no backup procedures were in place, amounts had to be restored in the system using other financial source data. Auditor’s Recommendations: Establishing IT controls, policies and procedures, off-site electronic data backups, and a disaster recovery plan would better prepare the College for technology related issues, system crashes, or data breaches. Management’s Response: The College is implementing policies and procedures.
2024-002 — IT – Material Weakness in Internal Control Over Compliance and Noncompliance (Repeat of finding 2023-003) Federal program information: Funding agencies: U.S. Department of Interior and U.S. Department of Education Titles: Assistance to Tribally Controlled Community Colleges; Higher Education Institutional Aid; Education Stabilization Fund; and SFA Cluster- Pell Grant Program ALN Number: 15.027, 84.031, 84.425, and 84.063 Award years: Various Criteria: Without strong information technology internal controls and established policies and procedures, there is the potential for integrity of financial records, the confidentiality, integrity and/or availability of data to be compromised. This compromise could be by an internal user of the system, by an external source (hacker) and could be intentional or unintentional. Condition: The College’s IT control environment is lacking certain key controls. There are currently no formalized IT policies and procedures, sufficient data backup processes, or a formalized disaster recovery plan. IT controls are not in place to ensure non-authorized individuals are restricted from adding new vendors, recording journal entries, and making/or changes to employee pay records. Questioned Costs: N/A Cause: The IT controls have not been properly designed and implemented. Effect: The College is exposed to many risks regarding the integrity of the financial records, confidentiality, integrity, and/or availability of its data. It is possible that their data could be compromised. Compromise could be by an internal user of the system, by an external source (hacker) and could be intentional or unintentional. Additionally, during fiscal year 2024, the College experienced an outage which resulted in a loss of data. As no backup procedures were in place, amounts had to be restored in the system using other financial source data. Auditor’s Recommendations: Establishing IT controls, policies and procedures, off-site electronic data backups, and a disaster recovery plan would better prepare the College for technology related issues, system crashes, or data breaches. Management’s Response: The College is implementing policies and procedures.
2024-002 — IT – Material Weakness in Internal Control Over Compliance and Noncompliance (Repeat of finding 2023-003) Federal program information: Funding agencies: U.S. Department of Interior and U.S. Department of Education Titles: Assistance to Tribally Controlled Community Colleges; Higher Education Institutional Aid; Education Stabilization Fund; and SFA Cluster- Pell Grant Program ALN Number: 15.027, 84.031, 84.425, and 84.063 Award years: Various Criteria: Without strong information technology internal controls and established policies and procedures, there is the potential for integrity of financial records, the confidentiality, integrity and/or availability of data to be compromised. This compromise could be by an internal user of the system, by an external source (hacker) and could be intentional or unintentional. Condition: The College’s IT control environment is lacking certain key controls. There are currently no formalized IT policies and procedures, sufficient data backup processes, or a formalized disaster recovery plan. IT controls are not in place to ensure non-authorized individuals are restricted from adding new vendors, recording journal entries, and making/or changes to employee pay records. Questioned Costs: N/A Cause: The IT controls have not been properly designed and implemented. Effect: The College is exposed to many risks regarding the integrity of the financial records, confidentiality, integrity, and/or availability of its data. It is possible that their data could be compromised. Compromise could be by an internal user of the system, by an external source (hacker) and could be intentional or unintentional. Additionally, during fiscal year 2024, the College experienced an outage which resulted in a loss of data. As no backup procedures were in place, amounts had to be restored in the system using other financial source data. Auditor’s Recommendations: Establishing IT controls, policies and procedures, off-site electronic data backups, and a disaster recovery plan would better prepare the College for technology related issues, system crashes, or data breaches. Management’s Response: The College is implementing policies and procedures.
2024-003 — Single Audit Report Submission – Material Weakness in Internal Control Over Compliance and Noncompliance (Repeat of finding 2023-005, 2022-003, and 2021-001) Federal program information: Funding agencies: U.S. Department of Interior and U.S. Department of Education Titles: Assistance to Tribally Controlled Community Colleges; Higher Education Institutional Aid; Education Stabilization Fund; and SFA Cluster- Pell Grant Program ALN Number: 15.027, 84.031, 84.425, and 84.063 Award years: Various Criteria: The Uniform Guidance 2 CFR 200.512 (a) requires the audit package and data collection from be submitted 30 days after receipt of the auditor’s report or 9 months after the end of the fiscal year, whichever comes first. Condition: The College’s fiscal year 2024 single audit reporting package was not submitted within nine months after the end of the audit period. Questioned Costs: N/A Cause: The College did not have appropriate internal control policies and procedures in place to ensure accounting records and financial statements were reconciled timely and the audit conducted to meet compliance requirements. Effect: The single audit reporting package was submitted after the required reporting time period. Auditor’s Recommendations: To ensure compliance with the Uniform Guidance, the College should prepare accurate, complete, and timely financial statements and ensure an audit is performed to ensure the timely submission of the single audit reporting package. Management’s Response: The College had plan to remain current with submitting its annual report.
2024-003 — Single Audit Report Submission – Material Weakness in Internal Control Over Compliance and Noncompliance (Repeat of finding 2023-005, 2022-003, and 2021-001) Federal program information: Funding agencies: U.S. Department of Interior and U.S. Department of Education Titles: Assistance to Tribally Controlled Community Colleges; Higher Education Institutional Aid; Education Stabilization Fund; and SFA Cluster- Pell Grant Program ALN Number: 15.027, 84.031, 84.425, and 84.063 Award years: Various Criteria: The Uniform Guidance 2 CFR 200.512 (a) requires the audit package and data collection from be submitted 30 days after receipt of the auditor’s report or 9 months after the end of the fiscal year, whichever comes first. Condition: The College’s fiscal year 2024 single audit reporting package was not submitted within nine months after the end of the audit period. Questioned Costs: N/A Cause: The College did not have appropriate internal control policies and procedures in place to ensure accounting records and financial statements were reconciled timely and the audit conducted to meet compliance requirements. Effect: The single audit reporting package was submitted after the required reporting time period. Auditor’s Recommendations: To ensure compliance with the Uniform Guidance, the College should prepare accurate, complete, and timely financial statements and ensure an audit is performed to ensure the timely submission of the single audit reporting package. Management’s Response: The College had plan to remain current with submitting its annual report.
2024-003 — Single Audit Report Submission – Material Weakness in Internal Control Over Compliance and Noncompliance (Repeat of finding 2023-005, 2022-003, and 2021-001) Federal program information: Funding agencies: U.S. Department of Interior and U.S. Department of Education Titles: Assistance to Tribally Controlled Community Colleges; Higher Education Institutional Aid; Education Stabilization Fund; and SFA Cluster- Pell Grant Program ALN Number: 15.027, 84.031, 84.425, and 84.063 Award years: Various Criteria: The Uniform Guidance 2 CFR 200.512 (a) requires the audit package and data collection from be submitted 30 days after receipt of the auditor’s report or 9 months after the end of the fiscal year, whichever comes first. Condition: The College’s fiscal year 2024 single audit reporting package was not submitted within nine months after the end of the audit period. Questioned Costs: N/A Cause: The College did not have appropriate internal control policies and procedures in place to ensure accounting records and financial statements were reconciled timely and the audit conducted to meet compliance requirements. Effect: The single audit reporting package was submitted after the required reporting time period. Auditor’s Recommendations: To ensure compliance with the Uniform Guidance, the College should prepare accurate, complete, and timely financial statements and ensure an audit is performed to ensure the timely submission of the single audit reporting package. Management’s Response: The College had plan to remain current with submitting its annual report.
2024-003 — Single Audit Report Submission – Material Weakness in Internal Control Over Compliance and Noncompliance (Repeat of finding 2023-005, 2022-003, and 2021-001) Federal program information: Funding agencies: U.S. Department of Interior and U.S. Department of Education Titles: Assistance to Tribally Controlled Community Colleges; Higher Education Institutional Aid; Education Stabilization Fund; and SFA Cluster- Pell Grant Program ALN Number: 15.027, 84.031, 84.425, and 84.063 Award years: Various Criteria: The Uniform Guidance 2 CFR 200.512 (a) requires the audit package and data collection from be submitted 30 days after receipt of the auditor’s report or 9 months after the end of the fiscal year, whichever comes first. Condition: The College’s fiscal year 2024 single audit reporting package was not submitted within nine months after the end of the audit period. Questioned Costs: N/A Cause: The College did not have appropriate internal control policies and procedures in place to ensure accounting records and financial statements were reconciled timely and the audit conducted to meet compliance requirements. Effect: The single audit reporting package was submitted after the required reporting time period. Auditor’s Recommendations: To ensure compliance with the Uniform Guidance, the College should prepare accurate, complete, and timely financial statements and ensure an audit is performed to ensure the timely submission of the single audit reporting package. Management’s Response: The College had plan to remain current with submitting its annual report.
2024-003 — Single Audit Report Submission – Material Weakness in Internal Control Over Compliance and Noncompliance (Repeat of finding 2023-005, 2022-003, and 2021-001) Federal program information: Funding agencies: U.S. Department of Interior and U.S. Department of Education Titles: Assistance to Tribally Controlled Community Colleges; Higher Education Institutional Aid; Education Stabilization Fund; and SFA Cluster- Pell Grant Program ALN Number: 15.027, 84.031, 84.425, and 84.063 Award years: Various Criteria: The Uniform Guidance 2 CFR 200.512 (a) requires the audit package and data collection from be submitted 30 days after receipt of the auditor’s report or 9 months after the end of the fiscal year, whichever comes first. Condition: The College’s fiscal year 2024 single audit reporting package was not submitted within nine months after the end of the audit period. Questioned Costs: N/A Cause: The College did not have appropriate internal control policies and procedures in place to ensure accounting records and financial statements were reconciled timely and the audit conducted to meet compliance requirements. Effect: The single audit reporting package was submitted after the required reporting time period. Auditor’s Recommendations: To ensure compliance with the Uniform Guidance, the College should prepare accurate, complete, and timely financial statements and ensure an audit is performed to ensure the timely submission of the single audit reporting package. Management’s Response: The College had plan to remain current with submitting its annual report.
2024-003 — Single Audit Report Submission – Material Weakness in Internal Control Over Compliance and Noncompliance (Repeat of finding 2023-005, 2022-003, and 2021-001) Federal program information: Funding agencies: U.S. Department of Interior and U.S. Department of Education Titles: Assistance to Tribally Controlled Community Colleges; Higher Education Institutional Aid; Education Stabilization Fund; and SFA Cluster- Pell Grant Program ALN Number: 15.027, 84.031, 84.425, and 84.063 Award years: Various Criteria: The Uniform Guidance 2 CFR 200.512 (a) requires the audit package and data collection from be submitted 30 days after receipt of the auditor’s report or 9 months after the end of the fiscal year, whichever comes first. Condition: The College’s fiscal year 2024 single audit reporting package was not submitted within nine months after the end of the audit period. Questioned Costs: N/A Cause: The College did not have appropriate internal control policies and procedures in place to ensure accounting records and financial statements were reconciled timely and the audit conducted to meet compliance requirements. Effect: The single audit reporting package was submitted after the required reporting time period. Auditor’s Recommendations: To ensure compliance with the Uniform Guidance, the College should prepare accurate, complete, and timely financial statements and ensure an audit is performed to ensure the timely submission of the single audit reporting package. Management’s Response: The College had plan to remain current with submitting its annual report.
2024-004 — Equipment and Real Property Management – Significant Deficiency in Internal Control Over Compliance and Noncompliance Federal program information: Funding agencies: U.S. Department of Education Titles: Higher Education Institutional Aid ALN Number: 84.031 Award years: Various Criteria: 2 CFR 200.313(c) through (e), requires that equipment be used in federal programs for which it was acquired for, when appropriate, other federal programs. Equipment records shall be maintained including required elements, a physical inventory of equipment be taken at least once every 2 years and reconciled to the equipment records, an appropriate control system shall be used to safeguard equipment, and equipment shall be adequately maintained. Condition: The College has not completed a physical inventory within the previous two fiscal years as required. In addition, the records were not detailed enough that program management is able to adequately and efficiently identify and locate any and all items. Questioned Costs: None Cause: The College is not enforcing their procedures to verify that the capital assets inventory has been taken annually and reconciled to the general ledger. Effect: Without a physical inventory, there is an increase in the probability that the capital asset listing will be incorrect, or assets listed may not exist. Auditor’s Recommendations: Enforce internal control procedures and complete an inventory of the school’s capital assets annually. Management’s Response: The College will take an inventory of its capital assets as required by policies.
2024-004 — Equipment and Real Property Management – Significant Deficiency in Internal Control Over Compliance and Noncompliance Federal program information: Funding agencies: U.S. Department of Education Titles: Higher Education Institutional Aid ALN Number: 84.031 Award years: Various Criteria: 2 CFR 200.313(c) through (e), requires that equipment be used in federal programs for which it was acquired for, when appropriate, other federal programs. Equipment records shall be maintained including required elements, a physical inventory of equipment be taken at least once every 2 years and reconciled to the equipment records, an appropriate control system shall be used to safeguard equipment, and equipment shall be adequately maintained. Condition: The College has not completed a physical inventory within the previous two fiscal years as required. In addition, the records were not detailed enough that program management is able to adequately and efficiently identify and locate any and all items. Questioned Costs: None Cause: The College is not enforcing their procedures to verify that the capital assets inventory has been taken annually and reconciled to the general ledger. Effect: Without a physical inventory, there is an increase in the probability that the capital asset listing will be incorrect, or assets listed may not exist. Auditor’s Recommendations: Enforce internal control procedures and complete an inventory of the school’s capital assets annually. Management’s Response: The College will take an inventory of its capital assets as required by policies.
2024-005 — Procurement – Material Weakness in Internal Control Over Compliance and Noncompliance (Repeat of Finding 2023-006 and 2022-004) Federal program information: Funding agencies: U.S. Department of Interior and U.S. Department of Education Titles: Assistance to Tribally Controlled Community Colleges; Higher Education Institutional Aid; and Education Stabilization Fund ALN Number: 15.027, 84.031, and 84.425 Award years: Various Criteria: According to 2 CFR Section 200.318i, the recipient or subrecipient must maintain records sufficient to detail the history of each procurement transaction. These records must include the rationale for the procurement method, contract type selection, contractor selection or rejection, and the basis for the contract price. According to 2 CFR Section 0200.319a, all procurement transactions under the federal award must be conducted in a manner that provides full and open competition. Condition: The College did not maintain records sufficient to detail the history of each procurement transaction for the nine procurements contracts tested. Cause: The College did not have sufficient procedures in place to ensure that procurement records are maintained. Effect: The College is not in compliance with procurement requirements. Questioned Costs: None Context: Procurement documents were not retained for nine out of nine transactions tested. Recommendation: Formally document and enforce policies and procedures that will promote adequate monitoring of the procurement and bidding process. Ensure that any contract over the College’s threshold ($150,000) follow the sealed bid requirements listed in 2 CFR Section 200.320b1. Management’s Response: The College will follow its policies as required.
2024-005 — Procurement – Material Weakness in Internal Control Over Compliance and Noncompliance (Repeat of Finding 2023-006 and 2022-004) Federal program information: Funding agencies: U.S. Department of Interior and U.S. Department of Education Titles: Assistance to Tribally Controlled Community Colleges; Higher Education Institutional Aid; and Education Stabilization Fund ALN Number: 15.027, 84.031, and 84.425 Award years: Various Criteria: According to 2 CFR Section 200.318i, the recipient or subrecipient must maintain records sufficient to detail the history of each procurement transaction. These records must include the rationale for the procurement method, contract type selection, contractor selection or rejection, and the basis for the contract price. According to 2 CFR Section 0200.319a, all procurement transactions under the federal award must be conducted in a manner that provides full and open competition. Condition: The College did not maintain records sufficient to detail the history of each procurement transaction for the nine procurements contracts tested. Cause: The College did not have sufficient procedures in place to ensure that procurement records are maintained. Effect: The College is not in compliance with procurement requirements. Questioned Costs: None Context: Procurement documents were not retained for nine out of nine transactions tested. Recommendation: Formally document and enforce policies and procedures that will promote adequate monitoring of the procurement and bidding process. Ensure that any contract over the College’s threshold ($150,000) follow the sealed bid requirements listed in 2 CFR Section 200.320b1. Management’s Response: The College will follow its policies as required.
2024-005 — Procurement – Material Weakness in Internal Control Over Compliance and Noncompliance (Repeat of Finding 2023-006 and 2022-004) Federal program information: Funding agencies: U.S. Department of Interior and U.S. Department of Education Titles: Assistance to Tribally Controlled Community Colleges; Higher Education Institutional Aid; and Education Stabilization Fund ALN Number: 15.027, 84.031, and 84.425 Award years: Various Criteria: According to 2 CFR Section 200.318i, the recipient or subrecipient must maintain records sufficient to detail the history of each procurement transaction. These records must include the rationale for the procurement method, contract type selection, contractor selection or rejection, and the basis for the contract price. According to 2 CFR Section 0200.319a, all procurement transactions under the federal award must be conducted in a manner that provides full and open competition. Condition: The College did not maintain records sufficient to detail the history of each procurement transaction for the nine procurements contracts tested. Cause: The College did not have sufficient procedures in place to ensure that procurement records are maintained. Effect: The College is not in compliance with procurement requirements. Questioned Costs: None Context: Procurement documents were not retained for nine out of nine transactions tested. Recommendation: Formally document and enforce policies and procedures that will promote adequate monitoring of the procurement and bidding process. Ensure that any contract over the College’s threshold ($150,000) follow the sealed bid requirements listed in 2 CFR Section 200.320b1. Management’s Response: The College will follow its policies as required.
2024-005 — Procurement – Material Weakness in Internal Control Over Compliance and Noncompliance (Repeat of Finding 2023-006 and 2022-004) Federal program information: Funding agencies: U.S. Department of Interior and U.S. Department of Education Titles: Assistance to Tribally Controlled Community Colleges; Higher Education Institutional Aid; and Education Stabilization Fund ALN Number: 15.027, 84.031, and 84.425 Award years: Various Criteria: According to 2 CFR Section 200.318i, the recipient or subrecipient must maintain records sufficient to detail the history of each procurement transaction. These records must include the rationale for the procurement method, contract type selection, contractor selection or rejection, and the basis for the contract price. According to 2 CFR Section 0200.319a, all procurement transactions under the federal award must be conducted in a manner that provides full and open competition. Condition: The College did not maintain records sufficient to detail the history of each procurement transaction for the nine procurements contracts tested. Cause: The College did not have sufficient procedures in place to ensure that procurement records are maintained. Effect: The College is not in compliance with procurement requirements. Questioned Costs: None Context: Procurement documents were not retained for nine out of nine transactions tested. Recommendation: Formally document and enforce policies and procedures that will promote adequate monitoring of the procurement and bidding process. Ensure that any contract over the College’s threshold ($150,000) follow the sealed bid requirements listed in 2 CFR Section 200.320b1. Management’s Response: The College will follow its policies as required.
2024-005 — Procurement – Material Weakness in Internal Control Over Compliance and Noncompliance (Repeat of Finding 2023-006 and 2022-004) Federal program information: Funding agencies: U.S. Department of Interior and U.S. Department of Education Titles: Assistance to Tribally Controlled Community Colleges; Higher Education Institutional Aid; and Education Stabilization Fund ALN Number: 15.027, 84.031, and 84.425 Award years: Various Criteria: According to 2 CFR Section 200.318i, the recipient or subrecipient must maintain records sufficient to detail the history of each procurement transaction. These records must include the rationale for the procurement method, contract type selection, contractor selection or rejection, and the basis for the contract price. According to 2 CFR Section 0200.319a, all procurement transactions under the federal award must be conducted in a manner that provides full and open competition. Condition: The College did not maintain records sufficient to detail the history of each procurement transaction for the nine procurements contracts tested. Cause: The College did not have sufficient procedures in place to ensure that procurement records are maintained. Effect: The College is not in compliance with procurement requirements. Questioned Costs: None Context: Procurement documents were not retained for nine out of nine transactions tested. Recommendation: Formally document and enforce policies and procedures that will promote adequate monitoring of the procurement and bidding process. Ensure that any contract over the College’s threshold ($150,000) follow the sealed bid requirements listed in 2 CFR Section 200.320b1. Management’s Response: The College will follow its policies as required.
2024-006 —Reporting – Significant Deficiency in Internal Control Over Compliance and Noncompliance (Repeat of Finding 2023-007, 2022-005, 2021-002, and 2020-004) Federal program information: Funding agencies: U.S. Department of Interior and U.S. Department of Education Titles: Assistance to Tribally Controlled Community Colleges; Higher Education Institutional Aid; and Education Stabilization Fund ALN Number: 15.027, 84.031, 84.425 Award years: Various Criteria: According to 2 CFR Section 200.328, nonfederal entities may be required to submit performance reports at least annually as required by the terms of the federal award. In addition, ALN 84.425 requires quarterly expenditure and budget reports. Condition: The College did not submit annual performance reports on time for three programs. The annual report for ALN 84.031 was inaccurate. In addition, two quarterly financial reports required for ALN 84.425 were not submitted timely. Cause: The College did not have sufficient procedures in place to ensure that the reports were completed timely and accurately. Effect: The three annual reports and two quarterly reports examined were submitted after the required time and one report was inaccurate. Questioned Costs: None Context: The annual reports and two quarterly reports were not submitted timely, and one report was not accurate. Recommendation: The College should ensure that all grant reports are prepared in a timely manner and are accurate. Management’s Response: The College will submit annual performance reports in a timely manner.
2024-006 —Reporting – Significant Deficiency in Internal Control Over Compliance and Noncompliance (Repeat of Finding 2023-007, 2022-005, 2021-002, and 2020-004) Federal program information: Funding agencies: U.S. Department of Interior and U.S. Department of Education Titles: Assistance to Tribally Controlled Community Colleges; Higher Education Institutional Aid; and Education Stabilization Fund ALN Number: 15.027, 84.031, 84.425 Award years: Various Criteria: According to 2 CFR Section 200.328, nonfederal entities may be required to submit performance reports at least annually as required by the terms of the federal award. In addition, ALN 84.425 requires quarterly expenditure and budget reports. Condition: The College did not submit annual performance reports on time for three programs. The annual report for ALN 84.031 was inaccurate. In addition, two quarterly financial reports required for ALN 84.425 were not submitted timely. Cause: The College did not have sufficient procedures in place to ensure that the reports were completed timely and accurately. Effect: The three annual reports and two quarterly reports examined were submitted after the required time and one report was inaccurate. Questioned Costs: None Context: The annual reports and two quarterly reports were not submitted timely, and one report was not accurate. Recommendation: The College should ensure that all grant reports are prepared in a timely manner and are accurate. Management’s Response: The College will submit annual performance reports in a timely manner.
2024-006 —Reporting – Significant Deficiency in Internal Control Over Compliance and Noncompliance (Repeat of Finding 2023-007, 2022-005, 2021-002, and 2020-004) Federal program information: Funding agencies: U.S. Department of Interior and U.S. Department of Education Titles: Assistance to Tribally Controlled Community Colleges; Higher Education Institutional Aid; and Education Stabilization Fund ALN Number: 15.027, 84.031, 84.425 Award years: Various Criteria: According to 2 CFR Section 200.328, nonfederal entities may be required to submit performance reports at least annually as required by the terms of the federal award. In addition, ALN 84.425 requires quarterly expenditure and budget reports. Condition: The College did not submit annual performance reports on time for three programs. The annual report for ALN 84.031 was inaccurate. In addition, two quarterly financial reports required for ALN 84.425 were not submitted timely. Cause: The College did not have sufficient procedures in place to ensure that the reports were completed timely and accurately. Effect: The three annual reports and two quarterly reports examined were submitted after the required time and one report was inaccurate. Questioned Costs: None Context: The annual reports and two quarterly reports were not submitted timely, and one report was not accurate. Recommendation: The College should ensure that all grant reports are prepared in a timely manner and are accurate. Management’s Response: The College will submit annual performance reports in a timely manner.
2024-006 —Reporting – Significant Deficiency in Internal Control Over Compliance and Noncompliance (Repeat of Finding 2023-007, 2022-005, 2021-002, and 2020-004) Federal program information: Funding agencies: U.S. Department of Interior and U.S. Department of Education Titles: Assistance to Tribally Controlled Community Colleges; Higher Education Institutional Aid; and Education Stabilization Fund ALN Number: 15.027, 84.031, 84.425 Award years: Various Criteria: According to 2 CFR Section 200.328, nonfederal entities may be required to submit performance reports at least annually as required by the terms of the federal award. In addition, ALN 84.425 requires quarterly expenditure and budget reports. Condition: The College did not submit annual performance reports on time for three programs. The annual report for ALN 84.031 was inaccurate. In addition, two quarterly financial reports required for ALN 84.425 were not submitted timely. Cause: The College did not have sufficient procedures in place to ensure that the reports were completed timely and accurately. Effect: The three annual reports and two quarterly reports examined were submitted after the required time and one report was inaccurate. Questioned Costs: None Context: The annual reports and two quarterly reports were not submitted timely, and one report was not accurate. Recommendation: The College should ensure that all grant reports are prepared in a timely manner and are accurate. Management’s Response: The College will submit annual performance reports in a timely manner.
2024-006 —Reporting – Significant Deficiency in Internal Control Over Compliance and Noncompliance (Repeat of Finding 2023-007, 2022-005, 2021-002, and 2020-004) Federal program information: Funding agencies: U.S. Department of Interior and U.S. Department of Education Titles: Assistance to Tribally Controlled Community Colleges; Higher Education Institutional Aid; and Education Stabilization Fund ALN Number: 15.027, 84.031, 84.425 Award years: Various Criteria: According to 2 CFR Section 200.328, nonfederal entities may be required to submit performance reports at least annually as required by the terms of the federal award. In addition, ALN 84.425 requires quarterly expenditure and budget reports. Condition: The College did not submit annual performance reports on time for three programs. The annual report for ALN 84.031 was inaccurate. In addition, two quarterly financial reports required for ALN 84.425 were not submitted timely. Cause: The College did not have sufficient procedures in place to ensure that the reports were completed timely and accurately. Effect: The three annual reports and two quarterly reports examined were submitted after the required time and one report was inaccurate. Questioned Costs: None Context: The annual reports and two quarterly reports were not submitted timely, and one report was not accurate. Recommendation: The College should ensure that all grant reports are prepared in a timely manner and are accurate. Management’s Response: The College will submit annual performance reports in a timely manner.
2024-007 —Financial Reporting– Significant Deficiency in Internal Control Over Compliance and Noncompliance Federal program information: Funding agencies: U.S. Department of Education Titles: SFA Cluster-Federal Pell Grant Program ALN Number: 84.063 Award years: 2024 Criteria: According to 2 CFR Section 200.328, nonfederal entities may be required to submit financial reports at least annually as required by the terms of the federal award. In addition, the grant requires origination and disbursement records be submitted to the Common Origination and Disbursement (COD) system. Condition: The College did not submit disbursement records for students as required. Cause: The College was affected by a ransomware attack that restricted access from their system in order to submit the disbursement records to the COD system. Effect: The College is not in compliance with reporting requirements. Questioned Costs: None Context: Disbursement records were not reported for fall 2023 to the COD system. Recommendation: Work with Department of Education to report the disbursement records for the time period not reported to the COD system. Management’s Response: The College will submit disbursement records to the COD system as required.
2024-008 — Disbursements to or on Behalf of Students (Special Test #3) – Material Weakness in Internal Control Over Compliance and Noncompliance Federal program information: Funding agencies: U.S. Department of Education Titles: SFA Cluster-Federal PELL Grant Program ALN Number: 84.063 Award years: Various Criteria: According to 34 CFR Section 668.165(a)(1), prior to make a disbursement, the school must notify students of the amount and type of Title IV funds (PELL grants) they are expected to receive, and how and when those disbursements will be made. Condition: The College did not have documentation of notification of disbursements. Cause: The College was affected by a ransomware attack that restricted access from their system in order to notify the students individually, as such the College notified the students verbally at a campus meeting. Effect: The College is not in compliance with Special Test Requirements of notification of disbursements. Questioned Costs: None Context: Disbursement notification documentation was not maintained for fall 2023. Recommendation: The College should comply with grant requirements and maintain documentation of compliance. Management’s Response: The College will document notifications of disbursement as required.
2024-009 — Return of Title IV Funds (Special Test #5)– Material Weakness in Internal Control Over Compliance and Noncompliance Federal program information: Funding agencies: U.S. Department of Education Titles: SFA Cluster-Federal PELL Grant Program ALN Number: 84.063 Award years: Various Criteria: According to 34 CFR Section 668.22(a)(1) through (a)(5), when a recipient of Title IV grant (PELL grants) withdraws from an institution during a payment period or period of enrollment in with the recipient began attendance, the institution must determine the amount of aid earned by the student as of the student’s withdrawal date. If the total amount of assistance earned by the student is less than the amount disbursed to the student, the difference must be returned to the Title IV program as outlined in the requirements. Condition: The College uses credit hours for measurement of the program as such, the amount of aid earned by the student is required to be determined by dividing the total number of calendar days in the enrollment period into the number of days completed in that period as of the student’s withdrawal date. The College was determining the amount of funds earned by the amount of credit hours the student was still enrolled in. Additionally, the timing of the withdrawals was incorrect in the calculations. Cause: The College was unaware of the percentage earned calculation and forms were not being submitted timely to the financial aid office to indicate student attendance. Effect: Return of funds were incorrectly calculated resulting in over and underpayments to students. Questioned Costs: $40,368 Context: The College did not properly calculate and return Title IV funds for students who withdrew. Recommendation: The College should comply with grant requirements for calculation of determining funds earned and those that need to be returned. Management’s Response: The College will return unearned Pell grant funds and properly determine unearned scholarship awards.
2024-010 — Enrollment Reporting (Special Test #6)– Material Weakness in Internal Control Over Compliance and Noncompliance Federal program information: Funding agencies: U.S. Department of Education Titles: SFA Cluster-Federal PELL Grant Program ALN Number: 84.063 Award years: Various Criteria: According to 34 CFR Section 690.83(b)(2), institutions are required to report enrollment information under the Pell grant via the NSLDS. Condition: The College failed to report enrollment data during the audit period. Cause: Due to staffing issues the College did not complete the submission. Effect: The enrollment information that appears on the NSLDS Professional Access website which the administration of the Title IV program depends on heavily to be accurate and up to date is missing information from the College. Questioned Costs: None Context: The College did not accurately report enrollment information for the PELL grant. Recommendation: The College should comply with grant requirements and submit Enrollment Reporting. Management’s Response: The College will accurately report enrollment information.
2024-011 — Gramm-Leach-Bliley Act- Student Information Security (Special Test #11)– Material Weakness in Internal Control Over Compliance and Noncompliance Federal program information: Funding agencies: U.S. Department of Education Titles: SFA Cluster-Federal PELL Grant Program ALN Number: 84.063 Award years: Various Criteria: According to 16 CFR 314. The Gramm-Leach-Bliley Act (GLBA) requires financial institutions to explain their information sharing practices to their customers and to safeguard sensitive data. The Federal Trade Commission considers Title IV-eligible institutions that participate in the Title IV Education Assistance programs as “financial institutions” and subject to the GLBA. Institutions must protect student financial aid information, with particular attention to information. Condition: Institutions are required to develop, implement, and maintain a comprehensive information security program that is written in one or more readily accessible parts and includes specific elements. The College did not have a comprehensive information security program in place, written or otherwise, that met the specific elements. Cause: The College’s IT control environment is lacking certain key controls. There are currently no formalized IT policies and procedures, sufficient data backup processes, or a formalized disaster recovery plan. IT controls are not in place to ensure non-authorized individuals are restricted from adding new vendors, recording journal entries, and making/or changes to employee pay records. Effect: The College is not in compliance with the requirements of the program and student data may be compromised without policies in place to ensure otherwise. Questioned Costs: None Context: The College is not in compliance with the GLBA requirements. Recommendation: The College should comply with grant requirements and develop, implement, and maintain a comprehensive security program that includes the specific elements required. Management’s Response: The College is in process of developing policies for the GLBA
2024-012 — Maintenance of Payroll Records- Significant Deficiency in Internal Control Over Compliance Federal program information: Funding agencies: U.S. Department of Education Titles: Assistance to Tribally Controlled Community Colleges; Higher Education Institutional Aid ALN Number: 15.027 and 84.031 Award years: Various Criteria: The College is required to process payroll in accordance with its financial policies and procedures, grant requirements and federal regulations and guidelines. Payroll disbursements require authorized supporting documentation such as cancelled checks, time and attendance records, authorized personnel action forms, etc. Condition: Payroll records, such as personnel action forms, were either missing or did not agree with the amount of wages paid through the payroll system. Cause: Policies and Procedures regarding the review and maintenance of the College’s payroll records and supporting documentation are not being consistently maintained. Effect: The College may not be able to demonstrate that the costs charged to federal programs are allowable. Questioned Costs: Undeterminable. Context: Of the 25 payroll transactions tested, 9 personnel action forms could not be located. Auditor’s Recommendations: Enforce policies and procedures to ensure adequate supporting documentation is maintained for all payroll transactions. Management’s Response: The College will enforce its payroll documentation policies.
2024-012 — Maintenance of Payroll Records- Significant Deficiency in Internal Control Over Compliance Federal program information: Funding agencies: U.S. Department of Education Titles: Assistance to Tribally Controlled Community Colleges; Higher Education Institutional Aid ALN Number: 15.027 and 84.031 Award years: Various Criteria: The College is required to process payroll in accordance with its financial policies and procedures, grant requirements and federal regulations and guidelines. Payroll disbursements require authorized supporting documentation such as cancelled checks, time and attendance records, authorized personnel action forms, etc. Condition: Payroll records, such as personnel action forms, were either missing or did not agree with the amount of wages paid through the payroll system. Cause: Policies and Procedures regarding the review and maintenance of the College’s payroll records and supporting documentation are not being consistently maintained. Effect: The College may not be able to demonstrate that the costs charged to federal programs are allowable. Questioned Costs: Undeterminable. Context: Of the 25 payroll transactions tested, 9 personnel action forms could not be located. Auditor’s Recommendations: Enforce policies and procedures to ensure adequate supporting documentation is maintained for all payroll transactions. Management’s Response: The College will enforce its payroll documentation policies.
2024-012 — Maintenance of Payroll Records- Significant Deficiency in Internal Control Over Compliance Federal program information: Funding agencies: U.S. Department of Education Titles: Assistance to Tribally Controlled Community Colleges; Higher Education Institutional Aid ALN Number: 15.027 and 84.031 Award years: Various Criteria: The College is required to process payroll in accordance with its financial policies and procedures, grant requirements and federal regulations and guidelines. Payroll disbursements require authorized supporting documentation such as cancelled checks, time and attendance records, authorized personnel action forms, etc. Condition: Payroll records, such as personnel action forms, were either missing or did not agree with the amount of wages paid through the payroll system. Cause: Policies and Procedures regarding the review and maintenance of the College’s payroll records and supporting documentation are not being consistently maintained. Effect: The College may not be able to demonstrate that the costs charged to federal programs are allowable. Questioned Costs: Undeterminable. Context: Of the 25 payroll transactions tested, 9 personnel action forms could not be located. Auditor’s Recommendations: Enforce policies and procedures to ensure adequate supporting documentation is maintained for all payroll transactions. Management’s Response: The College will enforce its payroll documentation policies.
2024-012 — Maintenance of Payroll Records- Significant Deficiency in Internal Control Over Compliance Federal program information: Funding agencies: U.S. Department of Education Titles: Assistance to Tribally Controlled Community Colleges; Higher Education Institutional Aid ALN Number: 15.027 and 84.031 Award years: Various Criteria: The College is required to process payroll in accordance with its financial policies and procedures, grant requirements and federal regulations and guidelines. Payroll disbursements require authorized supporting documentation such as cancelled checks, time and attendance records, authorized personnel action forms, etc. Condition: Payroll records, such as personnel action forms, were either missing or did not agree with the amount of wages paid through the payroll system. Cause: Policies and Procedures regarding the review and maintenance of the College’s payroll records and supporting documentation are not being consistently maintained. Effect: The College may not be able to demonstrate that the costs charged to federal programs are allowable. Questioned Costs: Undeterminable. Context: Of the 25 payroll transactions tested, 9 personnel action forms could not be located. Auditor’s Recommendations: Enforce policies and procedures to ensure adequate supporting documentation is maintained for all payroll transactions. Management’s Response: The College will enforce its payroll documentation policies.
2024-002 — IT – Material Weakness in Internal Control Over Compliance and Noncompliance (Repeat of finding 2023-003) Federal program information: Funding agencies: U.S. Department of Interior and U.S. Department of Education Titles: Assistance to Tribally Controlled Community Colleges; Higher Education Institutional Aid; Education Stabilization Fund; and SFA Cluster- Pell Grant Program ALN Number: 15.027, 84.031, 84.425, and 84.063 Award years: Various Criteria: Without strong information technology internal controls and established policies and procedures, there is the potential for integrity of financial records, the confidentiality, integrity and/or availability of data to be compromised. This compromise could be by an internal user of the system, by an external source (hacker) and could be intentional or unintentional. Condition: The College’s IT control environment is lacking certain key controls. There are currently no formalized IT policies and procedures, sufficient data backup processes, or a formalized disaster recovery plan. IT controls are not in place to ensure non-authorized individuals are restricted from adding new vendors, recording journal entries, and making/or changes to employee pay records. Questioned Costs: N/A Cause: The IT controls have not been properly designed and implemented. Effect: The College is exposed to many risks regarding the integrity of the financial records, confidentiality, integrity, and/or availability of its data. It is possible that their data could be compromised. Compromise could be by an internal user of the system, by an external source (hacker) and could be intentional or unintentional. Additionally, during fiscal year 2024, the College experienced an outage which resulted in a loss of data. As no backup procedures were in place, amounts had to be restored in the system using other financial source data. Auditor’s Recommendations: Establishing IT controls, policies and procedures, off-site electronic data backups, and a disaster recovery plan would better prepare the College for technology related issues, system crashes, or data breaches. Management’s Response: The College is implementing policies and procedures.
2024-002 — IT – Material Weakness in Internal Control Over Compliance and Noncompliance (Repeat of finding 2023-003) Federal program information: Funding agencies: U.S. Department of Interior and U.S. Department of Education Titles: Assistance to Tribally Controlled Community Colleges; Higher Education Institutional Aid; Education Stabilization Fund; and SFA Cluster- Pell Grant Program ALN Number: 15.027, 84.031, 84.425, and 84.063 Award years: Various Criteria: Without strong information technology internal controls and established policies and procedures, there is the potential for integrity of financial records, the confidentiality, integrity and/or availability of data to be compromised. This compromise could be by an internal user of the system, by an external source (hacker) and could be intentional or unintentional. Condition: The College’s IT control environment is lacking certain key controls. There are currently no formalized IT policies and procedures, sufficient data backup processes, or a formalized disaster recovery plan. IT controls are not in place to ensure non-authorized individuals are restricted from adding new vendors, recording journal entries, and making/or changes to employee pay records. Questioned Costs: N/A Cause: The IT controls have not been properly designed and implemented. Effect: The College is exposed to many risks regarding the integrity of the financial records, confidentiality, integrity, and/or availability of its data. It is possible that their data could be compromised. Compromise could be by an internal user of the system, by an external source (hacker) and could be intentional or unintentional. Additionally, during fiscal year 2024, the College experienced an outage which resulted in a loss of data. As no backup procedures were in place, amounts had to be restored in the system using other financial source data. Auditor’s Recommendations: Establishing IT controls, policies and procedures, off-site electronic data backups, and a disaster recovery plan would better prepare the College for technology related issues, system crashes, or data breaches. Management’s Response: The College is implementing policies and procedures.
2024-002 — IT – Material Weakness in Internal Control Over Compliance and Noncompliance (Repeat of finding 2023-003) Federal program information: Funding agencies: U.S. Department of Interior and U.S. Department of Education Titles: Assistance to Tribally Controlled Community Colleges; Higher Education Institutional Aid; Education Stabilization Fund; and SFA Cluster- Pell Grant Program ALN Number: 15.027, 84.031, 84.425, and 84.063 Award years: Various Criteria: Without strong information technology internal controls and established policies and procedures, there is the potential for integrity of financial records, the confidentiality, integrity and/or availability of data to be compromised. This compromise could be by an internal user of the system, by an external source (hacker) and could be intentional or unintentional. Condition: The College’s IT control environment is lacking certain key controls. There are currently no formalized IT policies and procedures, sufficient data backup processes, or a formalized disaster recovery plan. IT controls are not in place to ensure non-authorized individuals are restricted from adding new vendors, recording journal entries, and making/or changes to employee pay records. Questioned Costs: N/A Cause: The IT controls have not been properly designed and implemented. Effect: The College is exposed to many risks regarding the integrity of the financial records, confidentiality, integrity, and/or availability of its data. It is possible that their data could be compromised. Compromise could be by an internal user of the system, by an external source (hacker) and could be intentional or unintentional. Additionally, during fiscal year 2024, the College experienced an outage which resulted in a loss of data. As no backup procedures were in place, amounts had to be restored in the system using other financial source data. Auditor’s Recommendations: Establishing IT controls, policies and procedures, off-site electronic data backups, and a disaster recovery plan would better prepare the College for technology related issues, system crashes, or data breaches. Management’s Response: The College is implementing policies and procedures.
2024-002 — IT – Material Weakness in Internal Control Over Compliance and Noncompliance (Repeat of finding 2023-003) Federal program information: Funding agencies: U.S. Department of Interior and U.S. Department of Education Titles: Assistance to Tribally Controlled Community Colleges; Higher Education Institutional Aid; Education Stabilization Fund; and SFA Cluster- Pell Grant Program ALN Number: 15.027, 84.031, 84.425, and 84.063 Award years: Various Criteria: Without strong information technology internal controls and established policies and procedures, there is the potential for integrity of financial records, the confidentiality, integrity and/or availability of data to be compromised. This compromise could be by an internal user of the system, by an external source (hacker) and could be intentional or unintentional. Condition: The College’s IT control environment is lacking certain key controls. There are currently no formalized IT policies and procedures, sufficient data backup processes, or a formalized disaster recovery plan. IT controls are not in place to ensure non-authorized individuals are restricted from adding new vendors, recording journal entries, and making/or changes to employee pay records. Questioned Costs: N/A Cause: The IT controls have not been properly designed and implemented. Effect: The College is exposed to many risks regarding the integrity of the financial records, confidentiality, integrity, and/or availability of its data. It is possible that their data could be compromised. Compromise could be by an internal user of the system, by an external source (hacker) and could be intentional or unintentional. Additionally, during fiscal year 2024, the College experienced an outage which resulted in a loss of data. As no backup procedures were in place, amounts had to be restored in the system using other financial source data. Auditor’s Recommendations: Establishing IT controls, policies and procedures, off-site electronic data backups, and a disaster recovery plan would better prepare the College for technology related issues, system crashes, or data breaches. Management’s Response: The College is implementing policies and procedures.
2024-002 — IT – Material Weakness in Internal Control Over Compliance and Noncompliance (Repeat of finding 2023-003) Federal program information: Funding agencies: U.S. Department of Interior and U.S. Department of Education Titles: Assistance to Tribally Controlled Community Colleges; Higher Education Institutional Aid; Education Stabilization Fund; and SFA Cluster- Pell Grant Program ALN Number: 15.027, 84.031, 84.425, and 84.063 Award years: Various Criteria: Without strong information technology internal controls and established policies and procedures, there is the potential for integrity of financial records, the confidentiality, integrity and/or availability of data to be compromised. This compromise could be by an internal user of the system, by an external source (hacker) and could be intentional or unintentional. Condition: The College’s IT control environment is lacking certain key controls. There are currently no formalized IT policies and procedures, sufficient data backup processes, or a formalized disaster recovery plan. IT controls are not in place to ensure non-authorized individuals are restricted from adding new vendors, recording journal entries, and making/or changes to employee pay records. Questioned Costs: N/A Cause: The IT controls have not been properly designed and implemented. Effect: The College is exposed to many risks regarding the integrity of the financial records, confidentiality, integrity, and/or availability of its data. It is possible that their data could be compromised. Compromise could be by an internal user of the system, by an external source (hacker) and could be intentional or unintentional. Additionally, during fiscal year 2024, the College experienced an outage which resulted in a loss of data. As no backup procedures were in place, amounts had to be restored in the system using other financial source data. Auditor’s Recommendations: Establishing IT controls, policies and procedures, off-site electronic data backups, and a disaster recovery plan would better prepare the College for technology related issues, system crashes, or data breaches. Management’s Response: The College is implementing policies and procedures.
2024-002 — IT – Material Weakness in Internal Control Over Compliance and Noncompliance (Repeat of finding 2023-003) Federal program information: Funding agencies: U.S. Department of Interior and U.S. Department of Education Titles: Assistance to Tribally Controlled Community Colleges; Higher Education Institutional Aid; Education Stabilization Fund; and SFA Cluster- Pell Grant Program ALN Number: 15.027, 84.031, 84.425, and 84.063 Award years: Various Criteria: Without strong information technology internal controls and established policies and procedures, there is the potential for integrity of financial records, the confidentiality, integrity and/or availability of data to be compromised. This compromise could be by an internal user of the system, by an external source (hacker) and could be intentional or unintentional. Condition: The College’s IT control environment is lacking certain key controls. There are currently no formalized IT policies and procedures, sufficient data backup processes, or a formalized disaster recovery plan. IT controls are not in place to ensure non-authorized individuals are restricted from adding new vendors, recording journal entries, and making/or changes to employee pay records. Questioned Costs: N/A Cause: The IT controls have not been properly designed and implemented. Effect: The College is exposed to many risks regarding the integrity of the financial records, confidentiality, integrity, and/or availability of its data. It is possible that their data could be compromised. Compromise could be by an internal user of the system, by an external source (hacker) and could be intentional or unintentional. Additionally, during fiscal year 2024, the College experienced an outage which resulted in a loss of data. As no backup procedures were in place, amounts had to be restored in the system using other financial source data. Auditor’s Recommendations: Establishing IT controls, policies and procedures, off-site electronic data backups, and a disaster recovery plan would better prepare the College for technology related issues, system crashes, or data breaches. Management’s Response: The College is implementing policies and procedures.
2024-003 — Single Audit Report Submission – Material Weakness in Internal Control Over Compliance and Noncompliance (Repeat of finding 2023-005, 2022-003, and 2021-001) Federal program information: Funding agencies: U.S. Department of Interior and U.S. Department of Education Titles: Assistance to Tribally Controlled Community Colleges; Higher Education Institutional Aid; Education Stabilization Fund; and SFA Cluster- Pell Grant Program ALN Number: 15.027, 84.031, 84.425, and 84.063 Award years: Various Criteria: The Uniform Guidance 2 CFR 200.512 (a) requires the audit package and data collection from be submitted 30 days after receipt of the auditor’s report or 9 months after the end of the fiscal year, whichever comes first. Condition: The College’s fiscal year 2024 single audit reporting package was not submitted within nine months after the end of the audit period. Questioned Costs: N/A Cause: The College did not have appropriate internal control policies and procedures in place to ensure accounting records and financial statements were reconciled timely and the audit conducted to meet compliance requirements. Effect: The single audit reporting package was submitted after the required reporting time period. Auditor’s Recommendations: To ensure compliance with the Uniform Guidance, the College should prepare accurate, complete, and timely financial statements and ensure an audit is performed to ensure the timely submission of the single audit reporting package. Management’s Response: The College had plan to remain current with submitting its annual report.
2024-003 — Single Audit Report Submission – Material Weakness in Internal Control Over Compliance and Noncompliance (Repeat of finding 2023-005, 2022-003, and 2021-001) Federal program information: Funding agencies: U.S. Department of Interior and U.S. Department of Education Titles: Assistance to Tribally Controlled Community Colleges; Higher Education Institutional Aid; Education Stabilization Fund; and SFA Cluster- Pell Grant Program ALN Number: 15.027, 84.031, 84.425, and 84.063 Award years: Various Criteria: The Uniform Guidance 2 CFR 200.512 (a) requires the audit package and data collection from be submitted 30 days after receipt of the auditor’s report or 9 months after the end of the fiscal year, whichever comes first. Condition: The College’s fiscal year 2024 single audit reporting package was not submitted within nine months after the end of the audit period. Questioned Costs: N/A Cause: The College did not have appropriate internal control policies and procedures in place to ensure accounting records and financial statements were reconciled timely and the audit conducted to meet compliance requirements. Effect: The single audit reporting package was submitted after the required reporting time period. Auditor’s Recommendations: To ensure compliance with the Uniform Guidance, the College should prepare accurate, complete, and timely financial statements and ensure an audit is performed to ensure the timely submission of the single audit reporting package. Management’s Response: The College had plan to remain current with submitting its annual report.
2024-003 — Single Audit Report Submission – Material Weakness in Internal Control Over Compliance and Noncompliance (Repeat of finding 2023-005, 2022-003, and 2021-001) Federal program information: Funding agencies: U.S. Department of Interior and U.S. Department of Education Titles: Assistance to Tribally Controlled Community Colleges; Higher Education Institutional Aid; Education Stabilization Fund; and SFA Cluster- Pell Grant Program ALN Number: 15.027, 84.031, 84.425, and 84.063 Award years: Various Criteria: The Uniform Guidance 2 CFR 200.512 (a) requires the audit package and data collection from be submitted 30 days after receipt of the auditor’s report or 9 months after the end of the fiscal year, whichever comes first. Condition: The College’s fiscal year 2024 single audit reporting package was not submitted within nine months after the end of the audit period. Questioned Costs: N/A Cause: The College did not have appropriate internal control policies and procedures in place to ensure accounting records and financial statements were reconciled timely and the audit conducted to meet compliance requirements. Effect: The single audit reporting package was submitted after the required reporting time period. Auditor’s Recommendations: To ensure compliance with the Uniform Guidance, the College should prepare accurate, complete, and timely financial statements and ensure an audit is performed to ensure the timely submission of the single audit reporting package. Management’s Response: The College had plan to remain current with submitting its annual report.
2024-003 — Single Audit Report Submission – Material Weakness in Internal Control Over Compliance and Noncompliance (Repeat of finding 2023-005, 2022-003, and 2021-001) Federal program information: Funding agencies: U.S. Department of Interior and U.S. Department of Education Titles: Assistance to Tribally Controlled Community Colleges; Higher Education Institutional Aid; Education Stabilization Fund; and SFA Cluster- Pell Grant Program ALN Number: 15.027, 84.031, 84.425, and 84.063 Award years: Various Criteria: The Uniform Guidance 2 CFR 200.512 (a) requires the audit package and data collection from be submitted 30 days after receipt of the auditor’s report or 9 months after the end of the fiscal year, whichever comes first. Condition: The College’s fiscal year 2024 single audit reporting package was not submitted within nine months after the end of the audit period. Questioned Costs: N/A Cause: The College did not have appropriate internal control policies and procedures in place to ensure accounting records and financial statements were reconciled timely and the audit conducted to meet compliance requirements. Effect: The single audit reporting package was submitted after the required reporting time period. Auditor’s Recommendations: To ensure compliance with the Uniform Guidance, the College should prepare accurate, complete, and timely financial statements and ensure an audit is performed to ensure the timely submission of the single audit reporting package. Management’s Response: The College had plan to remain current with submitting its annual report.
2024-003 — Single Audit Report Submission – Material Weakness in Internal Control Over Compliance and Noncompliance (Repeat of finding 2023-005, 2022-003, and 2021-001) Federal program information: Funding agencies: U.S. Department of Interior and U.S. Department of Education Titles: Assistance to Tribally Controlled Community Colleges; Higher Education Institutional Aid; Education Stabilization Fund; and SFA Cluster- Pell Grant Program ALN Number: 15.027, 84.031, 84.425, and 84.063 Award years: Various Criteria: The Uniform Guidance 2 CFR 200.512 (a) requires the audit package and data collection from be submitted 30 days after receipt of the auditor’s report or 9 months after the end of the fiscal year, whichever comes first. Condition: The College’s fiscal year 2024 single audit reporting package was not submitted within nine months after the end of the audit period. Questioned Costs: N/A Cause: The College did not have appropriate internal control policies and procedures in place to ensure accounting records and financial statements were reconciled timely and the audit conducted to meet compliance requirements. Effect: The single audit reporting package was submitted after the required reporting time period. Auditor’s Recommendations: To ensure compliance with the Uniform Guidance, the College should prepare accurate, complete, and timely financial statements and ensure an audit is performed to ensure the timely submission of the single audit reporting package. Management’s Response: The College had plan to remain current with submitting its annual report.
2024-003 — Single Audit Report Submission – Material Weakness in Internal Control Over Compliance and Noncompliance (Repeat of finding 2023-005, 2022-003, and 2021-001) Federal program information: Funding agencies: U.S. Department of Interior and U.S. Department of Education Titles: Assistance to Tribally Controlled Community Colleges; Higher Education Institutional Aid; Education Stabilization Fund; and SFA Cluster- Pell Grant Program ALN Number: 15.027, 84.031, 84.425, and 84.063 Award years: Various Criteria: The Uniform Guidance 2 CFR 200.512 (a) requires the audit package and data collection from be submitted 30 days after receipt of the auditor’s report or 9 months after the end of the fiscal year, whichever comes first. Condition: The College’s fiscal year 2024 single audit reporting package was not submitted within nine months after the end of the audit period. Questioned Costs: N/A Cause: The College did not have appropriate internal control policies and procedures in place to ensure accounting records and financial statements were reconciled timely and the audit conducted to meet compliance requirements. Effect: The single audit reporting package was submitted after the required reporting time period. Auditor’s Recommendations: To ensure compliance with the Uniform Guidance, the College should prepare accurate, complete, and timely financial statements and ensure an audit is performed to ensure the timely submission of the single audit reporting package. Management’s Response: The College had plan to remain current with submitting its annual report.
2024-004 — Equipment and Real Property Management – Significant Deficiency in Internal Control Over Compliance and Noncompliance Federal program information: Funding agencies: U.S. Department of Education Titles: Higher Education Institutional Aid ALN Number: 84.031 Award years: Various Criteria: 2 CFR 200.313(c) through (e), requires that equipment be used in federal programs for which it was acquired for, when appropriate, other federal programs. Equipment records shall be maintained including required elements, a physical inventory of equipment be taken at least once every 2 years and reconciled to the equipment records, an appropriate control system shall be used to safeguard equipment, and equipment shall be adequately maintained. Condition: The College has not completed a physical inventory within the previous two fiscal years as required. In addition, the records were not detailed enough that program management is able to adequately and efficiently identify and locate any and all items. Questioned Costs: None Cause: The College is not enforcing their procedures to verify that the capital assets inventory has been taken annually and reconciled to the general ledger. Effect: Without a physical inventory, there is an increase in the probability that the capital asset listing will be incorrect, or assets listed may not exist. Auditor’s Recommendations: Enforce internal control procedures and complete an inventory of the school’s capital assets annually. Management’s Response: The College will take an inventory of its capital assets as required by policies.
2024-004 — Equipment and Real Property Management – Significant Deficiency in Internal Control Over Compliance and Noncompliance Federal program information: Funding agencies: U.S. Department of Education Titles: Higher Education Institutional Aid ALN Number: 84.031 Award years: Various Criteria: 2 CFR 200.313(c) through (e), requires that equipment be used in federal programs for which it was acquired for, when appropriate, other federal programs. Equipment records shall be maintained including required elements, a physical inventory of equipment be taken at least once every 2 years and reconciled to the equipment records, an appropriate control system shall be used to safeguard equipment, and equipment shall be adequately maintained. Condition: The College has not completed a physical inventory within the previous two fiscal years as required. In addition, the records were not detailed enough that program management is able to adequately and efficiently identify and locate any and all items. Questioned Costs: None Cause: The College is not enforcing their procedures to verify that the capital assets inventory has been taken annually and reconciled to the general ledger. Effect: Without a physical inventory, there is an increase in the probability that the capital asset listing will be incorrect, or assets listed may not exist. Auditor’s Recommendations: Enforce internal control procedures and complete an inventory of the school’s capital assets annually. Management’s Response: The College will take an inventory of its capital assets as required by policies.
2024-005 — Procurement – Material Weakness in Internal Control Over Compliance and Noncompliance (Repeat of Finding 2023-006 and 2022-004) Federal program information: Funding agencies: U.S. Department of Interior and U.S. Department of Education Titles: Assistance to Tribally Controlled Community Colleges; Higher Education Institutional Aid; and Education Stabilization Fund ALN Number: 15.027, 84.031, and 84.425 Award years: Various Criteria: According to 2 CFR Section 200.318i, the recipient or subrecipient must maintain records sufficient to detail the history of each procurement transaction. These records must include the rationale for the procurement method, contract type selection, contractor selection or rejection, and the basis for the contract price. According to 2 CFR Section 0200.319a, all procurement transactions under the federal award must be conducted in a manner that provides full and open competition. Condition: The College did not maintain records sufficient to detail the history of each procurement transaction for the nine procurements contracts tested. Cause: The College did not have sufficient procedures in place to ensure that procurement records are maintained. Effect: The College is not in compliance with procurement requirements. Questioned Costs: None Context: Procurement documents were not retained for nine out of nine transactions tested. Recommendation: Formally document and enforce policies and procedures that will promote adequate monitoring of the procurement and bidding process. Ensure that any contract over the College’s threshold ($150,000) follow the sealed bid requirements listed in 2 CFR Section 200.320b1. Management’s Response: The College will follow its policies as required.
2024-005 — Procurement – Material Weakness in Internal Control Over Compliance and Noncompliance (Repeat of Finding 2023-006 and 2022-004) Federal program information: Funding agencies: U.S. Department of Interior and U.S. Department of Education Titles: Assistance to Tribally Controlled Community Colleges; Higher Education Institutional Aid; and Education Stabilization Fund ALN Number: 15.027, 84.031, and 84.425 Award years: Various Criteria: According to 2 CFR Section 200.318i, the recipient or subrecipient must maintain records sufficient to detail the history of each procurement transaction. These records must include the rationale for the procurement method, contract type selection, contractor selection or rejection, and the basis for the contract price. According to 2 CFR Section 0200.319a, all procurement transactions under the federal award must be conducted in a manner that provides full and open competition. Condition: The College did not maintain records sufficient to detail the history of each procurement transaction for the nine procurements contracts tested. Cause: The College did not have sufficient procedures in place to ensure that procurement records are maintained. Effect: The College is not in compliance with procurement requirements. Questioned Costs: None Context: Procurement documents were not retained for nine out of nine transactions tested. Recommendation: Formally document and enforce policies and procedures that will promote adequate monitoring of the procurement and bidding process. Ensure that any contract over the College’s threshold ($150,000) follow the sealed bid requirements listed in 2 CFR Section 200.320b1. Management’s Response: The College will follow its policies as required.
2024-005 — Procurement – Material Weakness in Internal Control Over Compliance and Noncompliance (Repeat of Finding 2023-006 and 2022-004) Federal program information: Funding agencies: U.S. Department of Interior and U.S. Department of Education Titles: Assistance to Tribally Controlled Community Colleges; Higher Education Institutional Aid; and Education Stabilization Fund ALN Number: 15.027, 84.031, and 84.425 Award years: Various Criteria: According to 2 CFR Section 200.318i, the recipient or subrecipient must maintain records sufficient to detail the history of each procurement transaction. These records must include the rationale for the procurement method, contract type selection, contractor selection or rejection, and the basis for the contract price. According to 2 CFR Section 0200.319a, all procurement transactions under the federal award must be conducted in a manner that provides full and open competition. Condition: The College did not maintain records sufficient to detail the history of each procurement transaction for the nine procurements contracts tested. Cause: The College did not have sufficient procedures in place to ensure that procurement records are maintained. Effect: The College is not in compliance with procurement requirements. Questioned Costs: None Context: Procurement documents were not retained for nine out of nine transactions tested. Recommendation: Formally document and enforce policies and procedures that will promote adequate monitoring of the procurement and bidding process. Ensure that any contract over the College’s threshold ($150,000) follow the sealed bid requirements listed in 2 CFR Section 200.320b1. Management’s Response: The College will follow its policies as required.
2024-005 — Procurement – Material Weakness in Internal Control Over Compliance and Noncompliance (Repeat of Finding 2023-006 and 2022-004) Federal program information: Funding agencies: U.S. Department of Interior and U.S. Department of Education Titles: Assistance to Tribally Controlled Community Colleges; Higher Education Institutional Aid; and Education Stabilization Fund ALN Number: 15.027, 84.031, and 84.425 Award years: Various Criteria: According to 2 CFR Section 200.318i, the recipient or subrecipient must maintain records sufficient to detail the history of each procurement transaction. These records must include the rationale for the procurement method, contract type selection, contractor selection or rejection, and the basis for the contract price. According to 2 CFR Section 0200.319a, all procurement transactions under the federal award must be conducted in a manner that provides full and open competition. Condition: The College did not maintain records sufficient to detail the history of each procurement transaction for the nine procurements contracts tested. Cause: The College did not have sufficient procedures in place to ensure that procurement records are maintained. Effect: The College is not in compliance with procurement requirements. Questioned Costs: None Context: Procurement documents were not retained for nine out of nine transactions tested. Recommendation: Formally document and enforce policies and procedures that will promote adequate monitoring of the procurement and bidding process. Ensure that any contract over the College’s threshold ($150,000) follow the sealed bid requirements listed in 2 CFR Section 200.320b1. Management’s Response: The College will follow its policies as required.
2024-005 — Procurement – Material Weakness in Internal Control Over Compliance and Noncompliance (Repeat of Finding 2023-006 and 2022-004) Federal program information: Funding agencies: U.S. Department of Interior and U.S. Department of Education Titles: Assistance to Tribally Controlled Community Colleges; Higher Education Institutional Aid; and Education Stabilization Fund ALN Number: 15.027, 84.031, and 84.425 Award years: Various Criteria: According to 2 CFR Section 200.318i, the recipient or subrecipient must maintain records sufficient to detail the history of each procurement transaction. These records must include the rationale for the procurement method, contract type selection, contractor selection or rejection, and the basis for the contract price. According to 2 CFR Section 0200.319a, all procurement transactions under the federal award must be conducted in a manner that provides full and open competition. Condition: The College did not maintain records sufficient to detail the history of each procurement transaction for the nine procurements contracts tested. Cause: The College did not have sufficient procedures in place to ensure that procurement records are maintained. Effect: The College is not in compliance with procurement requirements. Questioned Costs: None Context: Procurement documents were not retained for nine out of nine transactions tested. Recommendation: Formally document and enforce policies and procedures that will promote adequate monitoring of the procurement and bidding process. Ensure that any contract over the College’s threshold ($150,000) follow the sealed bid requirements listed in 2 CFR Section 200.320b1. Management’s Response: The College will follow its policies as required.
2024-006 —Reporting – Significant Deficiency in Internal Control Over Compliance and Noncompliance (Repeat of Finding 2023-007, 2022-005, 2021-002, and 2020-004) Federal program information: Funding agencies: U.S. Department of Interior and U.S. Department of Education Titles: Assistance to Tribally Controlled Community Colleges; Higher Education Institutional Aid; and Education Stabilization Fund ALN Number: 15.027, 84.031, 84.425 Award years: Various Criteria: According to 2 CFR Section 200.328, nonfederal entities may be required to submit performance reports at least annually as required by the terms of the federal award. In addition, ALN 84.425 requires quarterly expenditure and budget reports. Condition: The College did not submit annual performance reports on time for three programs. The annual report for ALN 84.031 was inaccurate. In addition, two quarterly financial reports required for ALN 84.425 were not submitted timely. Cause: The College did not have sufficient procedures in place to ensure that the reports were completed timely and accurately. Effect: The three annual reports and two quarterly reports examined were submitted after the required time and one report was inaccurate. Questioned Costs: None Context: The annual reports and two quarterly reports were not submitted timely, and one report was not accurate. Recommendation: The College should ensure that all grant reports are prepared in a timely manner and are accurate. Management’s Response: The College will submit annual performance reports in a timely manner.
2024-006 —Reporting – Significant Deficiency in Internal Control Over Compliance and Noncompliance (Repeat of Finding 2023-007, 2022-005, 2021-002, and 2020-004) Federal program information: Funding agencies: U.S. Department of Interior and U.S. Department of Education Titles: Assistance to Tribally Controlled Community Colleges; Higher Education Institutional Aid; and Education Stabilization Fund ALN Number: 15.027, 84.031, 84.425 Award years: Various Criteria: According to 2 CFR Section 200.328, nonfederal entities may be required to submit performance reports at least annually as required by the terms of the federal award. In addition, ALN 84.425 requires quarterly expenditure and budget reports. Condition: The College did not submit annual performance reports on time for three programs. The annual report for ALN 84.031 was inaccurate. In addition, two quarterly financial reports required for ALN 84.425 were not submitted timely. Cause: The College did not have sufficient procedures in place to ensure that the reports were completed timely and accurately. Effect: The three annual reports and two quarterly reports examined were submitted after the required time and one report was inaccurate. Questioned Costs: None Context: The annual reports and two quarterly reports were not submitted timely, and one report was not accurate. Recommendation: The College should ensure that all grant reports are prepared in a timely manner and are accurate. Management’s Response: The College will submit annual performance reports in a timely manner.
2024-006 —Reporting – Significant Deficiency in Internal Control Over Compliance and Noncompliance (Repeat of Finding 2023-007, 2022-005, 2021-002, and 2020-004) Federal program information: Funding agencies: U.S. Department of Interior and U.S. Department of Education Titles: Assistance to Tribally Controlled Community Colleges; Higher Education Institutional Aid; and Education Stabilization Fund ALN Number: 15.027, 84.031, 84.425 Award years: Various Criteria: According to 2 CFR Section 200.328, nonfederal entities may be required to submit performance reports at least annually as required by the terms of the federal award. In addition, ALN 84.425 requires quarterly expenditure and budget reports. Condition: The College did not submit annual performance reports on time for three programs. The annual report for ALN 84.031 was inaccurate. In addition, two quarterly financial reports required for ALN 84.425 were not submitted timely. Cause: The College did not have sufficient procedures in place to ensure that the reports were completed timely and accurately. Effect: The three annual reports and two quarterly reports examined were submitted after the required time and one report was inaccurate. Questioned Costs: None Context: The annual reports and two quarterly reports were not submitted timely, and one report was not accurate. Recommendation: The College should ensure that all grant reports are prepared in a timely manner and are accurate. Management’s Response: The College will submit annual performance reports in a timely manner.
2024-006 —Reporting – Significant Deficiency in Internal Control Over Compliance and Noncompliance (Repeat of Finding 2023-007, 2022-005, 2021-002, and 2020-004) Federal program information: Funding agencies: U.S. Department of Interior and U.S. Department of Education Titles: Assistance to Tribally Controlled Community Colleges; Higher Education Institutional Aid; and Education Stabilization Fund ALN Number: 15.027, 84.031, 84.425 Award years: Various Criteria: According to 2 CFR Section 200.328, nonfederal entities may be required to submit performance reports at least annually as required by the terms of the federal award. In addition, ALN 84.425 requires quarterly expenditure and budget reports. Condition: The College did not submit annual performance reports on time for three programs. The annual report for ALN 84.031 was inaccurate. In addition, two quarterly financial reports required for ALN 84.425 were not submitted timely. Cause: The College did not have sufficient procedures in place to ensure that the reports were completed timely and accurately. Effect: The three annual reports and two quarterly reports examined were submitted after the required time and one report was inaccurate. Questioned Costs: None Context: The annual reports and two quarterly reports were not submitted timely, and one report was not accurate. Recommendation: The College should ensure that all grant reports are prepared in a timely manner and are accurate. Management’s Response: The College will submit annual performance reports in a timely manner.
2024-006 —Reporting – Significant Deficiency in Internal Control Over Compliance and Noncompliance (Repeat of Finding 2023-007, 2022-005, 2021-002, and 2020-004) Federal program information: Funding agencies: U.S. Department of Interior and U.S. Department of Education Titles: Assistance to Tribally Controlled Community Colleges; Higher Education Institutional Aid; and Education Stabilization Fund ALN Number: 15.027, 84.031, 84.425 Award years: Various Criteria: According to 2 CFR Section 200.328, nonfederal entities may be required to submit performance reports at least annually as required by the terms of the federal award. In addition, ALN 84.425 requires quarterly expenditure and budget reports. Condition: The College did not submit annual performance reports on time for three programs. The annual report for ALN 84.031 was inaccurate. In addition, two quarterly financial reports required for ALN 84.425 were not submitted timely. Cause: The College did not have sufficient procedures in place to ensure that the reports were completed timely and accurately. Effect: The three annual reports and two quarterly reports examined were submitted after the required time and one report was inaccurate. Questioned Costs: None Context: The annual reports and two quarterly reports were not submitted timely, and one report was not accurate. Recommendation: The College should ensure that all grant reports are prepared in a timely manner and are accurate. Management’s Response: The College will submit annual performance reports in a timely manner.
2024-007 —Financial Reporting– Significant Deficiency in Internal Control Over Compliance and Noncompliance Federal program information: Funding agencies: U.S. Department of Education Titles: SFA Cluster-Federal Pell Grant Program ALN Number: 84.063 Award years: 2024 Criteria: According to 2 CFR Section 200.328, nonfederal entities may be required to submit financial reports at least annually as required by the terms of the federal award. In addition, the grant requires origination and disbursement records be submitted to the Common Origination and Disbursement (COD) system. Condition: The College did not submit disbursement records for students as required. Cause: The College was affected by a ransomware attack that restricted access from their system in order to submit the disbursement records to the COD system. Effect: The College is not in compliance with reporting requirements. Questioned Costs: None Context: Disbursement records were not reported for fall 2023 to the COD system. Recommendation: Work with Department of Education to report the disbursement records for the time period not reported to the COD system. Management’s Response: The College will submit disbursement records to the COD system as required.
2024-008 — Disbursements to or on Behalf of Students (Special Test #3) – Material Weakness in Internal Control Over Compliance and Noncompliance Federal program information: Funding agencies: U.S. Department of Education Titles: SFA Cluster-Federal PELL Grant Program ALN Number: 84.063 Award years: Various Criteria: According to 34 CFR Section 668.165(a)(1), prior to make a disbursement, the school must notify students of the amount and type of Title IV funds (PELL grants) they are expected to receive, and how and when those disbursements will be made. Condition: The College did not have documentation of notification of disbursements. Cause: The College was affected by a ransomware attack that restricted access from their system in order to notify the students individually, as such the College notified the students verbally at a campus meeting. Effect: The College is not in compliance with Special Test Requirements of notification of disbursements. Questioned Costs: None Context: Disbursement notification documentation was not maintained for fall 2023. Recommendation: The College should comply with grant requirements and maintain documentation of compliance. Management’s Response: The College will document notifications of disbursement as required.
2024-009 — Return of Title IV Funds (Special Test #5)– Material Weakness in Internal Control Over Compliance and Noncompliance Federal program information: Funding agencies: U.S. Department of Education Titles: SFA Cluster-Federal PELL Grant Program ALN Number: 84.063 Award years: Various Criteria: According to 34 CFR Section 668.22(a)(1) through (a)(5), when a recipient of Title IV grant (PELL grants) withdraws from an institution during a payment period or period of enrollment in with the recipient began attendance, the institution must determine the amount of aid earned by the student as of the student’s withdrawal date. If the total amount of assistance earned by the student is less than the amount disbursed to the student, the difference must be returned to the Title IV program as outlined in the requirements. Condition: The College uses credit hours for measurement of the program as such, the amount of aid earned by the student is required to be determined by dividing the total number of calendar days in the enrollment period into the number of days completed in that period as of the student’s withdrawal date. The College was determining the amount of funds earned by the amount of credit hours the student was still enrolled in. Additionally, the timing of the withdrawals was incorrect in the calculations. Cause: The College was unaware of the percentage earned calculation and forms were not being submitted timely to the financial aid office to indicate student attendance. Effect: Return of funds were incorrectly calculated resulting in over and underpayments to students. Questioned Costs: $40,368 Context: The College did not properly calculate and return Title IV funds for students who withdrew. Recommendation: The College should comply with grant requirements for calculation of determining funds earned and those that need to be returned. Management’s Response: The College will return unearned Pell grant funds and properly determine unearned scholarship awards.
2024-010 — Enrollment Reporting (Special Test #6)– Material Weakness in Internal Control Over Compliance and Noncompliance Federal program information: Funding agencies: U.S. Department of Education Titles: SFA Cluster-Federal PELL Grant Program ALN Number: 84.063 Award years: Various Criteria: According to 34 CFR Section 690.83(b)(2), institutions are required to report enrollment information under the Pell grant via the NSLDS. Condition: The College failed to report enrollment data during the audit period. Cause: Due to staffing issues the College did not complete the submission. Effect: The enrollment information that appears on the NSLDS Professional Access website which the administration of the Title IV program depends on heavily to be accurate and up to date is missing information from the College. Questioned Costs: None Context: The College did not accurately report enrollment information for the PELL grant. Recommendation: The College should comply with grant requirements and submit Enrollment Reporting. Management’s Response: The College will accurately report enrollment information.
2024-011 — Gramm-Leach-Bliley Act- Student Information Security (Special Test #11)– Material Weakness in Internal Control Over Compliance and Noncompliance Federal program information: Funding agencies: U.S. Department of Education Titles: SFA Cluster-Federal PELL Grant Program ALN Number: 84.063 Award years: Various Criteria: According to 16 CFR 314. The Gramm-Leach-Bliley Act (GLBA) requires financial institutions to explain their information sharing practices to their customers and to safeguard sensitive data. The Federal Trade Commission considers Title IV-eligible institutions that participate in the Title IV Education Assistance programs as “financial institutions” and subject to the GLBA. Institutions must protect student financial aid information, with particular attention to information. Condition: Institutions are required to develop, implement, and maintain a comprehensive information security program that is written in one or more readily accessible parts and includes specific elements. The College did not have a comprehensive information security program in place, written or otherwise, that met the specific elements. Cause: The College’s IT control environment is lacking certain key controls. There are currently no formalized IT policies and procedures, sufficient data backup processes, or a formalized disaster recovery plan. IT controls are not in place to ensure non-authorized individuals are restricted from adding new vendors, recording journal entries, and making/or changes to employee pay records. Effect: The College is not in compliance with the requirements of the program and student data may be compromised without policies in place to ensure otherwise. Questioned Costs: None Context: The College is not in compliance with the GLBA requirements. Recommendation: The College should comply with grant requirements and develop, implement, and maintain a comprehensive security program that includes the specific elements required. Management’s Response: The College is in process of developing policies for the GLBA
2024-012 — Maintenance of Payroll Records- Significant Deficiency in Internal Control Over Compliance Federal program information: Funding agencies: U.S. Department of Education Titles: Assistance to Tribally Controlled Community Colleges; Higher Education Institutional Aid ALN Number: 15.027 and 84.031 Award years: Various Criteria: The College is required to process payroll in accordance with its financial policies and procedures, grant requirements and federal regulations and guidelines. Payroll disbursements require authorized supporting documentation such as cancelled checks, time and attendance records, authorized personnel action forms, etc. Condition: Payroll records, such as personnel action forms, were either missing or did not agree with the amount of wages paid through the payroll system. Cause: Policies and Procedures regarding the review and maintenance of the College’s payroll records and supporting documentation are not being consistently maintained. Effect: The College may not be able to demonstrate that the costs charged to federal programs are allowable. Questioned Costs: Undeterminable. Context: Of the 25 payroll transactions tested, 9 personnel action forms could not be located. Auditor’s Recommendations: Enforce policies and procedures to ensure adequate supporting documentation is maintained for all payroll transactions. Management’s Response: The College will enforce its payroll documentation policies.
2024-012 — Maintenance of Payroll Records- Significant Deficiency in Internal Control Over Compliance Federal program information: Funding agencies: U.S. Department of Education Titles: Assistance to Tribally Controlled Community Colleges; Higher Education Institutional Aid ALN Number: 15.027 and 84.031 Award years: Various Criteria: The College is required to process payroll in accordance with its financial policies and procedures, grant requirements and federal regulations and guidelines. Payroll disbursements require authorized supporting documentation such as cancelled checks, time and attendance records, authorized personnel action forms, etc. Condition: Payroll records, such as personnel action forms, were either missing or did not agree with the amount of wages paid through the payroll system. Cause: Policies and Procedures regarding the review and maintenance of the College’s payroll records and supporting documentation are not being consistently maintained. Effect: The College may not be able to demonstrate that the costs charged to federal programs are allowable. Questioned Costs: Undeterminable. Context: Of the 25 payroll transactions tested, 9 personnel action forms could not be located. Auditor’s Recommendations: Enforce policies and procedures to ensure adequate supporting documentation is maintained for all payroll transactions. Management’s Response: The College will enforce its payroll documentation policies.
2024-012 — Maintenance of Payroll Records- Significant Deficiency in Internal Control Over Compliance Federal program information: Funding agencies: U.S. Department of Education Titles: Assistance to Tribally Controlled Community Colleges; Higher Education Institutional Aid ALN Number: 15.027 and 84.031 Award years: Various Criteria: The College is required to process payroll in accordance with its financial policies and procedures, grant requirements and federal regulations and guidelines. Payroll disbursements require authorized supporting documentation such as cancelled checks, time and attendance records, authorized personnel action forms, etc. Condition: Payroll records, such as personnel action forms, were either missing or did not agree with the amount of wages paid through the payroll system. Cause: Policies and Procedures regarding the review and maintenance of the College’s payroll records and supporting documentation are not being consistently maintained. Effect: The College may not be able to demonstrate that the costs charged to federal programs are allowable. Questioned Costs: Undeterminable. Context: Of the 25 payroll transactions tested, 9 personnel action forms could not be located. Auditor’s Recommendations: Enforce policies and procedures to ensure adequate supporting documentation is maintained for all payroll transactions. Management’s Response: The College will enforce its payroll documentation policies.
2024-012 — Maintenance of Payroll Records- Significant Deficiency in Internal Control Over Compliance Federal program information: Funding agencies: U.S. Department of Education Titles: Assistance to Tribally Controlled Community Colleges; Higher Education Institutional Aid ALN Number: 15.027 and 84.031 Award years: Various Criteria: The College is required to process payroll in accordance with its financial policies and procedures, grant requirements and federal regulations and guidelines. Payroll disbursements require authorized supporting documentation such as cancelled checks, time and attendance records, authorized personnel action forms, etc. Condition: Payroll records, such as personnel action forms, were either missing or did not agree with the amount of wages paid through the payroll system. Cause: Policies and Procedures regarding the review and maintenance of the College’s payroll records and supporting documentation are not being consistently maintained. Effect: The College may not be able to demonstrate that the costs charged to federal programs are allowable. Questioned Costs: Undeterminable. Context: Of the 25 payroll transactions tested, 9 personnel action forms could not be located. Auditor’s Recommendations: Enforce policies and procedures to ensure adequate supporting documentation is maintained for all payroll transactions. Management’s Response: The College will enforce its payroll documentation policies.