Audit 353088

FY End
2023-06-30
Total Expended
$7.38M
Findings
64
Programs
15
Organization: Leech Lake Tribal College (AZ)
Year: 2023 Accepted: 2025-04-08
Auditor: Redw

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
554420 2023-003 Material Weakness - A
554421 2023-003 Material Weakness - A
554422 2023-003 Material Weakness - A
554423 2023-003 Material Weakness - A
554424 2023-003 Material Weakness - A
554425 2023-003 Material Weakness - A
554426 2023-004 Material Weakness - A
554427 2023-004 Material Weakness - A
554428 2023-004 Material Weakness - A
554429 2023-004 Material Weakness - A
554430 2023-004 Material Weakness - A
554431 2023-004 Material Weakness - A
554432 2023-005 Material Weakness Yes L
554433 2023-005 Material Weakness Yes L
554434 2023-005 Material Weakness Yes L
554435 2023-005 Material Weakness Yes L
554436 2023-005 Material Weakness Yes L
554437 2023-005 Material Weakness Yes L
554438 2023-006 Material Weakness Yes I
554439 2023-006 Material Weakness Yes I
554440 2023-006 Material Weakness Yes I
554441 2023-006 Material Weakness Yes I
554442 2023-006 Material Weakness Yes I
554443 2023-006 Material Weakness Yes I
554444 2023-007 Significant Deficiency Yes L
554445 2023-007 Significant Deficiency Yes L
554446 2023-007 Significant Deficiency Yes L
554447 2023-007 Significant Deficiency Yes L
554448 2023-007 Significant Deficiency Yes L
554449 2023-007 Significant Deficiency Yes L
554450 2023-008 Significant Deficiency - A
554451 2023-008 Significant Deficiency - A
1130862 2023-003 Material Weakness - A
1130863 2023-003 Material Weakness - A
1130864 2023-003 Material Weakness - A
1130865 2023-003 Material Weakness - A
1130866 2023-003 Material Weakness - A
1130867 2023-003 Material Weakness - A
1130868 2023-004 Material Weakness - A
1130869 2023-004 Material Weakness - A
1130870 2023-004 Material Weakness - A
1130871 2023-004 Material Weakness - A
1130872 2023-004 Material Weakness - A
1130873 2023-004 Material Weakness - A
1130874 2023-005 Material Weakness Yes L
1130875 2023-005 Material Weakness Yes L
1130876 2023-005 Material Weakness Yes L
1130877 2023-005 Material Weakness Yes L
1130878 2023-005 Material Weakness Yes L
1130879 2023-005 Material Weakness Yes L
1130880 2023-006 Material Weakness Yes I
1130881 2023-006 Material Weakness Yes I
1130882 2023-006 Material Weakness Yes I
1130883 2023-006 Material Weakness Yes I
1130884 2023-006 Material Weakness Yes I
1130885 2023-006 Material Weakness Yes I
1130886 2023-007 Significant Deficiency Yes L
1130887 2023-007 Significant Deficiency Yes L
1130888 2023-007 Significant Deficiency Yes L
1130889 2023-007 Significant Deficiency Yes L
1130890 2023-007 Significant Deficiency Yes L
1130891 2023-007 Significant Deficiency Yes L
1130892 2023-008 Significant Deficiency - A
1130893 2023-008 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, 2023. 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, 2023, is as follows: Federal Program ALN Amount Higher Education Institutional Aid 84.031 $ 3,707,435 Assistance to Tribally Controlled Community Colleges 15.027 1,308,725 $ 5,016,160 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,382,324 Total expenditures of federal awards $ 7,382,324
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, 2023.

Finding Details

2023-003 — IT – Material Weakness in Internal Control Over Compliance and Noncompliance 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: 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: Management concurs with this finding.
2023-003 — IT – Material Weakness in Internal Control Over Compliance and Noncompliance 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: 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: Management concurs with this finding.
2023-003 — IT – Material Weakness in Internal Control Over Compliance and Noncompliance 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: 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: Management concurs with this finding.
2023-003 — IT – Material Weakness in Internal Control Over Compliance and Noncompliance 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: 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: Management concurs with this finding.
2023-003 — IT – Material Weakness in Internal Control Over Compliance and Noncompliance 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: 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: Management concurs with this finding.
2023-003 — IT – Material Weakness in Internal Control Over Compliance and Noncompliance 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: 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: Management concurs with this finding.
2023-004 — Journal Entry Approval Process – Material Weakness in Internal Control Over Compliance and Noncompliance 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: A fundamental concept in a good system of internal control is a proper segregation of duties. Without adequate segregation of duties, the risk of an error or irregularity occurring and going undetected increases. Journal entries should be independently reviewed by someone other than the preparer of the entries prior to posting into the general ledger. No single individual should manage too many functions within a transaction cycle, and proper documentation should be maintained to show the review and approval process. Condition: Journal entries selected as part of our single audit testing were not reviewed or approved by anyone other than the preparer. Additionally, there was no documentation showing the review and approval process. The journal entries provided did not contain sufficient supporting documentation. Questioned Costs: N/A Cause: The College has limited staff and therefore proper segregation of duties has been difficult to accomplish. Effect: Without strong segregation of duties, there is an increase in the likelihood of errors or fraud. Auditor’s Recommendations: Establishing journal entry controls including an independent review and approval process for all entries and ensuring sufficient documentation is maintained for each entry. Management’s Response: Management concurs with this finding.
2023-004 — Journal Entry Approval Process – Material Weakness in Internal Control Over Compliance and Noncompliance 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: A fundamental concept in a good system of internal control is a proper segregation of duties. Without adequate segregation of duties, the risk of an error or irregularity occurring and going undetected increases. Journal entries should be independently reviewed by someone other than the preparer of the entries prior to posting into the general ledger. No single individual should manage too many functions within a transaction cycle, and proper documentation should be maintained to show the review and approval process. Condition: Journal entries selected as part of our single audit testing were not reviewed or approved by anyone other than the preparer. Additionally, there was no documentation showing the review and approval process. The journal entries provided did not contain sufficient supporting documentation. Questioned Costs: N/A Cause: The College has limited staff and therefore proper segregation of duties has been difficult to accomplish. Effect: Without strong segregation of duties, there is an increase in the likelihood of errors or fraud. Auditor’s Recommendations: Establishing journal entry controls including an independent review and approval process for all entries and ensuring sufficient documentation is maintained for each entry. Management’s Response: Management concurs with this finding.
2023-004 — Journal Entry Approval Process – Material Weakness in Internal Control Over Compliance and Noncompliance 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: A fundamental concept in a good system of internal control is a proper segregation of duties. Without adequate segregation of duties, the risk of an error or irregularity occurring and going undetected increases. Journal entries should be independently reviewed by someone other than the preparer of the entries prior to posting into the general ledger. No single individual should manage too many functions within a transaction cycle, and proper documentation should be maintained to show the review and approval process. Condition: Journal entries selected as part of our single audit testing were not reviewed or approved by anyone other than the preparer. Additionally, there was no documentation showing the review and approval process. The journal entries provided did not contain sufficient supporting documentation. Questioned Costs: N/A Cause: The College has limited staff and therefore proper segregation of duties has been difficult to accomplish. Effect: Without strong segregation of duties, there is an increase in the likelihood of errors or fraud. Auditor’s Recommendations: Establishing journal entry controls including an independent review and approval process for all entries and ensuring sufficient documentation is maintained for each entry. Management’s Response: Management concurs with this finding.
2023-004 — Journal Entry Approval Process – Material Weakness in Internal Control Over Compliance and Noncompliance 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: A fundamental concept in a good system of internal control is a proper segregation of duties. Without adequate segregation of duties, the risk of an error or irregularity occurring and going undetected increases. Journal entries should be independently reviewed by someone other than the preparer of the entries prior to posting into the general ledger. No single individual should manage too many functions within a transaction cycle, and proper documentation should be maintained to show the review and approval process. Condition: Journal entries selected as part of our single audit testing were not reviewed or approved by anyone other than the preparer. Additionally, there was no documentation showing the review and approval process. The journal entries provided did not contain sufficient supporting documentation. Questioned Costs: N/A Cause: The College has limited staff and therefore proper segregation of duties has been difficult to accomplish. Effect: Without strong segregation of duties, there is an increase in the likelihood of errors or fraud. Auditor’s Recommendations: Establishing journal entry controls including an independent review and approval process for all entries and ensuring sufficient documentation is maintained for each entry. Management’s Response: Management concurs with this finding.
2023-004 — Journal Entry Approval Process – Material Weakness in Internal Control Over Compliance and Noncompliance 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: A fundamental concept in a good system of internal control is a proper segregation of duties. Without adequate segregation of duties, the risk of an error or irregularity occurring and going undetected increases. Journal entries should be independently reviewed by someone other than the preparer of the entries prior to posting into the general ledger. No single individual should manage too many functions within a transaction cycle, and proper documentation should be maintained to show the review and approval process. Condition: Journal entries selected as part of our single audit testing were not reviewed or approved by anyone other than the preparer. Additionally, there was no documentation showing the review and approval process. The journal entries provided did not contain sufficient supporting documentation. Questioned Costs: N/A Cause: The College has limited staff and therefore proper segregation of duties has been difficult to accomplish. Effect: Without strong segregation of duties, there is an increase in the likelihood of errors or fraud. Auditor’s Recommendations: Establishing journal entry controls including an independent review and approval process for all entries and ensuring sufficient documentation is maintained for each entry. Management’s Response: Management concurs with this finding.
2023-004 — Journal Entry Approval Process – Material Weakness in Internal Control Over Compliance and Noncompliance 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: A fundamental concept in a good system of internal control is a proper segregation of duties. Without adequate segregation of duties, the risk of an error or irregularity occurring and going undetected increases. Journal entries should be independently reviewed by someone other than the preparer of the entries prior to posting into the general ledger. No single individual should manage too many functions within a transaction cycle, and proper documentation should be maintained to show the review and approval process. Condition: Journal entries selected as part of our single audit testing were not reviewed or approved by anyone other than the preparer. Additionally, there was no documentation showing the review and approval process. The journal entries provided did not contain sufficient supporting documentation. Questioned Costs: N/A Cause: The College has limited staff and therefore proper segregation of duties has been difficult to accomplish. Effect: Without strong segregation of duties, there is an increase in the likelihood of errors or fraud. Auditor’s Recommendations: Establishing journal entry controls including an independent review and approval process for all entries and ensuring sufficient documentation is maintained for each entry. Management’s Response: Management concurs with this finding.
2023-005 — Single Audit Report Submission – Material Weakness in Internal Control Over Compliance and Noncompliance (Repeat of finding 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; and Education Stabilization Fund ALN Number: 15.027, 84.031, and 84.425 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 2023 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: Management has implemented policies and procedures to ensure the timely submission of single audit reporting package.
2023-005 — Single Audit Report Submission – Material Weakness in Internal Control Over Compliance and Noncompliance (Repeat of finding 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; and Education Stabilization Fund ALN Number: 15.027, 84.031, and 84.425 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 2023 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: Management has implemented policies and procedures to ensure the timely submission of single audit reporting package.
2023-005 — Single Audit Report Submission – Material Weakness in Internal Control Over Compliance and Noncompliance (Repeat of finding 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; and Education Stabilization Fund ALN Number: 15.027, 84.031, and 84.425 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 2023 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: Management has implemented policies and procedures to ensure the timely submission of single audit reporting package.
2023-005 — Single Audit Report Submission – Material Weakness in Internal Control Over Compliance and Noncompliance (Repeat of finding 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; and Education Stabilization Fund ALN Number: 15.027, 84.031, and 84.425 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 2023 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: Management has implemented policies and procedures to ensure the timely submission of single audit reporting package.
2023-005 — Single Audit Report Submission – Material Weakness in Internal Control Over Compliance and Noncompliance (Repeat of finding 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; and Education Stabilization Fund ALN Number: 15.027, 84.031, and 84.425 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 2023 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: Management has implemented policies and procedures to ensure the timely submission of single audit reporting package.
2023-005 — Single Audit Report Submission – Material Weakness in Internal Control Over Compliance and Noncompliance (Repeat of finding 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; and Education Stabilization Fund ALN Number: 15.027, 84.031, and 84.425 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 2023 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: Management has implemented policies and procedures to ensure the timely submission of single audit reporting package.
2023-006 — Procurement – Material Weakness in Internal Control Over Compliance and Noncompliance (Repeat of Finding 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 concurs with this finding.
2023-006 — Procurement – Material Weakness in Internal Control Over Compliance and Noncompliance (Repeat of Finding 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 concurs with this finding.
2023-006 — Procurement – Material Weakness in Internal Control Over Compliance and Noncompliance (Repeat of Finding 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 concurs with this finding.
2023-006 — Procurement – Material Weakness in Internal Control Over Compliance and Noncompliance (Repeat of Finding 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 concurs with this finding.
2023-006 — Procurement – Material Weakness in Internal Control Over Compliance and Noncompliance (Repeat of Finding 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 concurs with this finding.
2023-006 — Procurement – Material Weakness in Internal Control Over Compliance and Noncompliance (Repeat of Finding 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 concurs with this finding.
2023-007 — Reporting – Significant Deficiency in Internal Control Over Compliance and Noncompliance (Repeat of Finding 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, and 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 all three programs. The annual report for ALN 84.031 was inaccurate. In addition, two quarterly 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 ensure that all grant reports are reviewed in detail and information reported will be traced to the source reports by the reviewer. The College also implemented policies and procedures to ensure all grant reports are submitted prior to the due date.
2023-007 — Reporting – Significant Deficiency in Internal Control Over Compliance and Noncompliance (Repeat of Finding 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, and 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 all three programs. The annual report for ALN 84.031 was inaccurate. In addition, two quarterly 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 ensure that all grant reports are reviewed in detail and information reported will be traced to the source reports by the reviewer. The College also implemented policies and procedures to ensure all grant reports are submitted prior to the due date.
2023-007 — Reporting – Significant Deficiency in Internal Control Over Compliance and Noncompliance (Repeat of Finding 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, and 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 all three programs. The annual report for ALN 84.031 was inaccurate. In addition, two quarterly 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 ensure that all grant reports are reviewed in detail and information reported will be traced to the source reports by the reviewer. The College also implemented policies and procedures to ensure all grant reports are submitted prior to the due date.
2023-007 — Reporting – Significant Deficiency in Internal Control Over Compliance and Noncompliance (Repeat of Finding 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, and 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 all three programs. The annual report for ALN 84.031 was inaccurate. In addition, two quarterly 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 ensure that all grant reports are reviewed in detail and information reported will be traced to the source reports by the reviewer. The College also implemented policies and procedures to ensure all grant reports are submitted prior to the due date.
2023-007 — Reporting – Significant Deficiency in Internal Control Over Compliance and Noncompliance (Repeat of Finding 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, and 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 all three programs. The annual report for ALN 84.031 was inaccurate. In addition, two quarterly 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 ensure that all grant reports are reviewed in detail and information reported will be traced to the source reports by the reviewer. The College also implemented policies and procedures to ensure all grant reports are submitted prior to the due date.
2023-007 — Reporting – Significant Deficiency in Internal Control Over Compliance and Noncompliance (Repeat of Finding 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, and 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 all three programs. The annual report for ALN 84.031 was inaccurate. In addition, two quarterly 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 ensure that all grant reports are reviewed in detail and information reported will be traced to the source reports by the reviewer. The College also implemented policies and procedures to ensure all grant reports are submitted prior to the due date.
2023-008 —Allowable Costs and Cost Principles– Significant Deficiency in Internal Control Over Compliance and Noncompliance Federal program information: Funding agencies: U.S. Department of Interior Titles: Assistance to Tribally Controlled Community Colleges ALN Number: 15.027 Award years: 2023 Criteria: According to 2 CFR Section 200.405(b) All activities which benefit from the recipient’s or subrecipient’s indirect cost, including unallowable activities and donated services by the recipient or subrecipient of third parties, will receive an appropriate allocation of indirect costs. Condition: The College improperly calculated indirect costs for the fiscal year and overcharged for the federal program by $49,481. Cause: The College did not have sufficient procedures in place to ensure that indirect cost charges were calculated correctly. Effect: The College is not in compliance with Allowable Costs and Cost Principles requirements. Questioned Costs: $49,481 Context: Indirect Costs were overcharged by $49,481 during fiscal year 2023. Recommendation: Enforce policies and procedures to ensure that the calculated rates are in agreement with the approved indirect cost rate, management should perform reviews of the calculation to ensure accuracy. Management’s Response: The College concurs with this finding.
2023-008 —Allowable Costs and Cost Principles– Significant Deficiency in Internal Control Over Compliance and Noncompliance Federal program information: Funding agencies: U.S. Department of Interior Titles: Assistance to Tribally Controlled Community Colleges ALN Number: 15.027 Award years: 2023 Criteria: According to 2 CFR Section 200.405(b) All activities which benefit from the recipient’s or subrecipient’s indirect cost, including unallowable activities and donated services by the recipient or subrecipient of third parties, will receive an appropriate allocation of indirect costs. Condition: The College improperly calculated indirect costs for the fiscal year and overcharged for the federal program by $49,481. Cause: The College did not have sufficient procedures in place to ensure that indirect cost charges were calculated correctly. Effect: The College is not in compliance with Allowable Costs and Cost Principles requirements. Questioned Costs: $49,481 Context: Indirect Costs were overcharged by $49,481 during fiscal year 2023. Recommendation: Enforce policies and procedures to ensure that the calculated rates are in agreement with the approved indirect cost rate, management should perform reviews of the calculation to ensure accuracy. Management’s Response: The College concurs with this finding.
2023-003 — IT – Material Weakness in Internal Control Over Compliance and Noncompliance 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: 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: Management concurs with this finding.
2023-003 — IT – Material Weakness in Internal Control Over Compliance and Noncompliance 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: 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: Management concurs with this finding.
2023-003 — IT – Material Weakness in Internal Control Over Compliance and Noncompliance 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: 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: Management concurs with this finding.
2023-003 — IT – Material Weakness in Internal Control Over Compliance and Noncompliance 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: 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: Management concurs with this finding.
2023-003 — IT – Material Weakness in Internal Control Over Compliance and Noncompliance 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: 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: Management concurs with this finding.
2023-003 — IT – Material Weakness in Internal Control Over Compliance and Noncompliance 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: 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: Management concurs with this finding.
2023-004 — Journal Entry Approval Process – Material Weakness in Internal Control Over Compliance and Noncompliance 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: A fundamental concept in a good system of internal control is a proper segregation of duties. Without adequate segregation of duties, the risk of an error or irregularity occurring and going undetected increases. Journal entries should be independently reviewed by someone other than the preparer of the entries prior to posting into the general ledger. No single individual should manage too many functions within a transaction cycle, and proper documentation should be maintained to show the review and approval process. Condition: Journal entries selected as part of our single audit testing were not reviewed or approved by anyone other than the preparer. Additionally, there was no documentation showing the review and approval process. The journal entries provided did not contain sufficient supporting documentation. Questioned Costs: N/A Cause: The College has limited staff and therefore proper segregation of duties has been difficult to accomplish. Effect: Without strong segregation of duties, there is an increase in the likelihood of errors or fraud. Auditor’s Recommendations: Establishing journal entry controls including an independent review and approval process for all entries and ensuring sufficient documentation is maintained for each entry. Management’s Response: Management concurs with this finding.
2023-004 — Journal Entry Approval Process – Material Weakness in Internal Control Over Compliance and Noncompliance 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: A fundamental concept in a good system of internal control is a proper segregation of duties. Without adequate segregation of duties, the risk of an error or irregularity occurring and going undetected increases. Journal entries should be independently reviewed by someone other than the preparer of the entries prior to posting into the general ledger. No single individual should manage too many functions within a transaction cycle, and proper documentation should be maintained to show the review and approval process. Condition: Journal entries selected as part of our single audit testing were not reviewed or approved by anyone other than the preparer. Additionally, there was no documentation showing the review and approval process. The journal entries provided did not contain sufficient supporting documentation. Questioned Costs: N/A Cause: The College has limited staff and therefore proper segregation of duties has been difficult to accomplish. Effect: Without strong segregation of duties, there is an increase in the likelihood of errors or fraud. Auditor’s Recommendations: Establishing journal entry controls including an independent review and approval process for all entries and ensuring sufficient documentation is maintained for each entry. Management’s Response: Management concurs with this finding.
2023-004 — Journal Entry Approval Process – Material Weakness in Internal Control Over Compliance and Noncompliance 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: A fundamental concept in a good system of internal control is a proper segregation of duties. Without adequate segregation of duties, the risk of an error or irregularity occurring and going undetected increases. Journal entries should be independently reviewed by someone other than the preparer of the entries prior to posting into the general ledger. No single individual should manage too many functions within a transaction cycle, and proper documentation should be maintained to show the review and approval process. Condition: Journal entries selected as part of our single audit testing were not reviewed or approved by anyone other than the preparer. Additionally, there was no documentation showing the review and approval process. The journal entries provided did not contain sufficient supporting documentation. Questioned Costs: N/A Cause: The College has limited staff and therefore proper segregation of duties has been difficult to accomplish. Effect: Without strong segregation of duties, there is an increase in the likelihood of errors or fraud. Auditor’s Recommendations: Establishing journal entry controls including an independent review and approval process for all entries and ensuring sufficient documentation is maintained for each entry. Management’s Response: Management concurs with this finding.
2023-004 — Journal Entry Approval Process – Material Weakness in Internal Control Over Compliance and Noncompliance 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: A fundamental concept in a good system of internal control is a proper segregation of duties. Without adequate segregation of duties, the risk of an error or irregularity occurring and going undetected increases. Journal entries should be independently reviewed by someone other than the preparer of the entries prior to posting into the general ledger. No single individual should manage too many functions within a transaction cycle, and proper documentation should be maintained to show the review and approval process. Condition: Journal entries selected as part of our single audit testing were not reviewed or approved by anyone other than the preparer. Additionally, there was no documentation showing the review and approval process. The journal entries provided did not contain sufficient supporting documentation. Questioned Costs: N/A Cause: The College has limited staff and therefore proper segregation of duties has been difficult to accomplish. Effect: Without strong segregation of duties, there is an increase in the likelihood of errors or fraud. Auditor’s Recommendations: Establishing journal entry controls including an independent review and approval process for all entries and ensuring sufficient documentation is maintained for each entry. Management’s Response: Management concurs with this finding.
2023-004 — Journal Entry Approval Process – Material Weakness in Internal Control Over Compliance and Noncompliance 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: A fundamental concept in a good system of internal control is a proper segregation of duties. Without adequate segregation of duties, the risk of an error or irregularity occurring and going undetected increases. Journal entries should be independently reviewed by someone other than the preparer of the entries prior to posting into the general ledger. No single individual should manage too many functions within a transaction cycle, and proper documentation should be maintained to show the review and approval process. Condition: Journal entries selected as part of our single audit testing were not reviewed or approved by anyone other than the preparer. Additionally, there was no documentation showing the review and approval process. The journal entries provided did not contain sufficient supporting documentation. Questioned Costs: N/A Cause: The College has limited staff and therefore proper segregation of duties has been difficult to accomplish. Effect: Without strong segregation of duties, there is an increase in the likelihood of errors or fraud. Auditor’s Recommendations: Establishing journal entry controls including an independent review and approval process for all entries and ensuring sufficient documentation is maintained for each entry. Management’s Response: Management concurs with this finding.
2023-004 — Journal Entry Approval Process – Material Weakness in Internal Control Over Compliance and Noncompliance 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: A fundamental concept in a good system of internal control is a proper segregation of duties. Without adequate segregation of duties, the risk of an error or irregularity occurring and going undetected increases. Journal entries should be independently reviewed by someone other than the preparer of the entries prior to posting into the general ledger. No single individual should manage too many functions within a transaction cycle, and proper documentation should be maintained to show the review and approval process. Condition: Journal entries selected as part of our single audit testing were not reviewed or approved by anyone other than the preparer. Additionally, there was no documentation showing the review and approval process. The journal entries provided did not contain sufficient supporting documentation. Questioned Costs: N/A Cause: The College has limited staff and therefore proper segregation of duties has been difficult to accomplish. Effect: Without strong segregation of duties, there is an increase in the likelihood of errors or fraud. Auditor’s Recommendations: Establishing journal entry controls including an independent review and approval process for all entries and ensuring sufficient documentation is maintained for each entry. Management’s Response: Management concurs with this finding.
2023-005 — Single Audit Report Submission – Material Weakness in Internal Control Over Compliance and Noncompliance (Repeat of finding 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; and Education Stabilization Fund ALN Number: 15.027, 84.031, and 84.425 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 2023 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: Management has implemented policies and procedures to ensure the timely submission of single audit reporting package.
2023-005 — Single Audit Report Submission – Material Weakness in Internal Control Over Compliance and Noncompliance (Repeat of finding 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; and Education Stabilization Fund ALN Number: 15.027, 84.031, and 84.425 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 2023 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: Management has implemented policies and procedures to ensure the timely submission of single audit reporting package.
2023-005 — Single Audit Report Submission – Material Weakness in Internal Control Over Compliance and Noncompliance (Repeat of finding 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; and Education Stabilization Fund ALN Number: 15.027, 84.031, and 84.425 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 2023 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: Management has implemented policies and procedures to ensure the timely submission of single audit reporting package.
2023-005 — Single Audit Report Submission – Material Weakness in Internal Control Over Compliance and Noncompliance (Repeat of finding 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; and Education Stabilization Fund ALN Number: 15.027, 84.031, and 84.425 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 2023 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: Management has implemented policies and procedures to ensure the timely submission of single audit reporting package.
2023-005 — Single Audit Report Submission – Material Weakness in Internal Control Over Compliance and Noncompliance (Repeat of finding 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; and Education Stabilization Fund ALN Number: 15.027, 84.031, and 84.425 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 2023 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: Management has implemented policies and procedures to ensure the timely submission of single audit reporting package.
2023-005 — Single Audit Report Submission – Material Weakness in Internal Control Over Compliance and Noncompliance (Repeat of finding 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; and Education Stabilization Fund ALN Number: 15.027, 84.031, and 84.425 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 2023 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: Management has implemented policies and procedures to ensure the timely submission of single audit reporting package.
2023-006 — Procurement – Material Weakness in Internal Control Over Compliance and Noncompliance (Repeat of Finding 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 concurs with this finding.
2023-006 — Procurement – Material Weakness in Internal Control Over Compliance and Noncompliance (Repeat of Finding 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 concurs with this finding.
2023-006 — Procurement – Material Weakness in Internal Control Over Compliance and Noncompliance (Repeat of Finding 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 concurs with this finding.
2023-006 — Procurement – Material Weakness in Internal Control Over Compliance and Noncompliance (Repeat of Finding 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 concurs with this finding.
2023-006 — Procurement – Material Weakness in Internal Control Over Compliance and Noncompliance (Repeat of Finding 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 concurs with this finding.
2023-006 — Procurement – Material Weakness in Internal Control Over Compliance and Noncompliance (Repeat of Finding 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 concurs with this finding.
2023-007 — Reporting – Significant Deficiency in Internal Control Over Compliance and Noncompliance (Repeat of Finding 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, and 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 all three programs. The annual report for ALN 84.031 was inaccurate. In addition, two quarterly 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 ensure that all grant reports are reviewed in detail and information reported will be traced to the source reports by the reviewer. The College also implemented policies and procedures to ensure all grant reports are submitted prior to the due date.
2023-007 — Reporting – Significant Deficiency in Internal Control Over Compliance and Noncompliance (Repeat of Finding 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, and 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 all three programs. The annual report for ALN 84.031 was inaccurate. In addition, two quarterly 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 ensure that all grant reports are reviewed in detail and information reported will be traced to the source reports by the reviewer. The College also implemented policies and procedures to ensure all grant reports are submitted prior to the due date.
2023-007 — Reporting – Significant Deficiency in Internal Control Over Compliance and Noncompliance (Repeat of Finding 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, and 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 all three programs. The annual report for ALN 84.031 was inaccurate. In addition, two quarterly 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 ensure that all grant reports are reviewed in detail and information reported will be traced to the source reports by the reviewer. The College also implemented policies and procedures to ensure all grant reports are submitted prior to the due date.
2023-007 — Reporting – Significant Deficiency in Internal Control Over Compliance and Noncompliance (Repeat of Finding 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, and 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 all three programs. The annual report for ALN 84.031 was inaccurate. In addition, two quarterly 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 ensure that all grant reports are reviewed in detail and information reported will be traced to the source reports by the reviewer. The College also implemented policies and procedures to ensure all grant reports are submitted prior to the due date.
2023-007 — Reporting – Significant Deficiency in Internal Control Over Compliance and Noncompliance (Repeat of Finding 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, and 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 all three programs. The annual report for ALN 84.031 was inaccurate. In addition, two quarterly 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 ensure that all grant reports are reviewed in detail and information reported will be traced to the source reports by the reviewer. The College also implemented policies and procedures to ensure all grant reports are submitted prior to the due date.
2023-007 — Reporting – Significant Deficiency in Internal Control Over Compliance and Noncompliance (Repeat of Finding 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, and 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 all three programs. The annual report for ALN 84.031 was inaccurate. In addition, two quarterly 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 ensure that all grant reports are reviewed in detail and information reported will be traced to the source reports by the reviewer. The College also implemented policies and procedures to ensure all grant reports are submitted prior to the due date.
2023-008 —Allowable Costs and Cost Principles– Significant Deficiency in Internal Control Over Compliance and Noncompliance Federal program information: Funding agencies: U.S. Department of Interior Titles: Assistance to Tribally Controlled Community Colleges ALN Number: 15.027 Award years: 2023 Criteria: According to 2 CFR Section 200.405(b) All activities which benefit from the recipient’s or subrecipient’s indirect cost, including unallowable activities and donated services by the recipient or subrecipient of third parties, will receive an appropriate allocation of indirect costs. Condition: The College improperly calculated indirect costs for the fiscal year and overcharged for the federal program by $49,481. Cause: The College did not have sufficient procedures in place to ensure that indirect cost charges were calculated correctly. Effect: The College is not in compliance with Allowable Costs and Cost Principles requirements. Questioned Costs: $49,481 Context: Indirect Costs were overcharged by $49,481 during fiscal year 2023. Recommendation: Enforce policies and procedures to ensure that the calculated rates are in agreement with the approved indirect cost rate, management should perform reviews of the calculation to ensure accuracy. Management’s Response: The College concurs with this finding.
2023-008 —Allowable Costs and Cost Principles– Significant Deficiency in Internal Control Over Compliance and Noncompliance Federal program information: Funding agencies: U.S. Department of Interior Titles: Assistance to Tribally Controlled Community Colleges ALN Number: 15.027 Award years: 2023 Criteria: According to 2 CFR Section 200.405(b) All activities which benefit from the recipient’s or subrecipient’s indirect cost, including unallowable activities and donated services by the recipient or subrecipient of third parties, will receive an appropriate allocation of indirect costs. Condition: The College improperly calculated indirect costs for the fiscal year and overcharged for the federal program by $49,481. Cause: The College did not have sufficient procedures in place to ensure that indirect cost charges were calculated correctly. Effect: The College is not in compliance with Allowable Costs and Cost Principles requirements. Questioned Costs: $49,481 Context: Indirect Costs were overcharged by $49,481 during fiscal year 2023. Recommendation: Enforce policies and procedures to ensure that the calculated rates are in agreement with the approved indirect cost rate, management should perform reviews of the calculation to ensure accuracy. Management’s Response: The College concurs with this finding.