FAC Explorer

Audit 5788

FY End
2023-06-30
Total Expended
$6.50M
Findings
10
Programs
6
Organization: St. John's College (NM)
Year: 2023 Accepted: 2023-12-07
Auditor: Marcum LLP

Organization Exclusion Status:

Findings

ID Ref Severity Repeat Requirement
3686 2023-002 Material Weakness - L
3687 2023-002 Material Weakness - L
3688 2023-002 Material Weakness - L
3689 2023-002 Material Weakness - L
3690 2023-002 Material Weakness - L
580128 2023-002 Material Weakness - L
580129 2023-002 Material Weakness - L
580130 2023-002 Material Weakness - L
580131 2023-002 Material Weakness - L
580132 2023-002 Material Weakness - L

Programs

ALN Program Spent Major Findings
84.268 Federal Direct Student Loans $4.27M Yes 1
84.063 Federal Pell Grant Program $1.09M Yes 1
84.038 Federal Perkins Loan Program $413,278 Yes 1
84.033 Federal Work-Study Program $261,511 Yes 1
84.007 Federal Supplemental Educational Opportunity Grants $240,299 Yes 1
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $230,238 - 0

Contacts

Name Title Type
Z2RUETN8LLM4 Ally Gontang-Highfield Auditee
4106262514 Matt Huffner Auditor
No contacts on file

Notes to SEFA

Title: 2. Basis of Accounting Accounting Policies: The accompanying schedule of expenditures of federal awards (the “Schedule”) includes the federal award activity of the 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 the College, it is not intended to and does not present the financial position, changes in net assets, or cash flows of the College. De Minimis Rate Used: N Rate Explanation: The College has elected not to use the 10% de minimis indirect cost rate as allowed under Uniform Guidance. Expenditures reported on the Schedule are reported on the 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. Expenditures for federal student financial aid programs are recognized as incurred and include Federal Pell program grants to students, loan disbursements under the Federal Perkins Loan Programs, Federal Direct Loans and Parent Loans for Undergraduate Students (PLUS) programs (Direct Student Loans), the federal share of students’ Federal Supplemental Educational Opportunity Grant program grants and Federal Work Study program earnings, and administrative cost allowances, where applicable. Loans made under the Federal Direct and PLUS programs are disbursed by the Federal government. The Federal Perkins Loan Program ended during fiscal year 2018 and the College is making the required repayments to the government.
Title: 4. Federal Student Loan Programs and Related Matters Accounting Policies: The accompanying schedule of expenditures of federal awards (the “Schedule”) includes the federal award activity of the 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 the College, it is not intended to and does not present the financial position, changes in net assets, or cash flows of the College. De Minimis Rate Used: N Rate Explanation: The College has elected not to use the 10% de minimis indirect cost rate as allowed under Uniform Guidance. The Federal Perkins Loan Program (the Program) is administered directly by the College and balances and transactions relating to the Program are included in the College’s financial statements. Loans outstanding at the beginning of the year are included in the federal expenditures presented in the Schedule. The Program ended in fiscal year 2018, and there were no new loans disbursed for the year ended June 30, 2023. The balance of loans outstanding under the Program was $217,729 as of June 30, 2023. The College is responsible only for the performance of certain administrative duties with respect to the Federal Direct Student Loans, and accordingly, these loans are not included in its financial statements. The principal amount of loans disbursed under these programs during the year ended June 30, 2023, is included on the Schedule.
Title: 5. Subrecipients Accounting Policies: The accompanying schedule of expenditures of federal awards (the “Schedule”) includes the federal award activity of the 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 the College, it is not intended to and does not present the financial position, changes in net assets, or cash flows of the College. De Minimis Rate Used: N Rate Explanation: The College has elected not to use the 10% de minimis indirect cost rate as allowed under Uniform Guidance. The College did not pass any federal awards through to subrecipients during the year ended June 30, 2023.

Finding Details

Finding 2023-002
Finding No. 2023-002: Improper Preparation of the Schedule of Expenditures of Federal Awards – Material Weakness in Internal Control over Compliance Criteria Nonfederal entities must record expenditures related to ALN 97.036 on the Schedule of Expenditures of Federal Awards (SEFA) when (1) FEMA has approved the nonfederal entity’s Project, and (2) the nonfederal entity has incurred the eligible expenditures. Federal awards expended in years subsequent to the fiscal year in which the Project is approved are to be recorded on the nonfederal entity’s SEFA in those subsequent years. SECTION III – FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (CONTINUED) Finding No. 2023-002: Improper Preparation of the Schedule of Expenditures of Federal Awards – Material Weakness in Internal Control over Compliance (continued) Condition and Context Expenditures related to ALN 97-036 which met both requirements listed above during the year ended June 30, 2023, were not included on the SEFA. Cause Internal controls were not designed effectively to ensure that the SEFA was complete. Effect The SEFA was understated by $196,367 which could impact major program determinations and required coverage to be tested. Questioned Cost None. Repeat Finding No. Recommendation We recommend that the College enhance its completeness review process of internal control to ensure that the SEFA is complete. Views of Responsible Officials See corrective action plan.
Finding 2023-002
Finding No. 2023-002: Improper Preparation of the Schedule of Expenditures of Federal Awards – Material Weakness in Internal Control over Compliance Criteria Nonfederal entities must record expenditures related to ALN 97.036 on the Schedule of Expenditures of Federal Awards (SEFA) when (1) FEMA has approved the nonfederal entity’s Project, and (2) the nonfederal entity has incurred the eligible expenditures. Federal awards expended in years subsequent to the fiscal year in which the Project is approved are to be recorded on the nonfederal entity’s SEFA in those subsequent years. SECTION III – FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (CONTINUED) Finding No. 2023-002: Improper Preparation of the Schedule of Expenditures of Federal Awards – Material Weakness in Internal Control over Compliance (continued) Condition and Context Expenditures related to ALN 97-036 which met both requirements listed above during the year ended June 30, 2023, were not included on the SEFA. Cause Internal controls were not designed effectively to ensure that the SEFA was complete. Effect The SEFA was understated by $196,367 which could impact major program determinations and required coverage to be tested. Questioned Cost None. Repeat Finding No. Recommendation We recommend that the College enhance its completeness review process of internal control to ensure that the SEFA is complete. Views of Responsible Officials See corrective action plan.
Finding 2023-002
Finding No. 2023-002: Improper Preparation of the Schedule of Expenditures of Federal Awards – Material Weakness in Internal Control over Compliance Criteria Nonfederal entities must record expenditures related to ALN 97.036 on the Schedule of Expenditures of Federal Awards (SEFA) when (1) FEMA has approved the nonfederal entity’s Project, and (2) the nonfederal entity has incurred the eligible expenditures. Federal awards expended in years subsequent to the fiscal year in which the Project is approved are to be recorded on the nonfederal entity’s SEFA in those subsequent years. SECTION III – FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (CONTINUED) Finding No. 2023-002: Improper Preparation of the Schedule of Expenditures of Federal Awards – Material Weakness in Internal Control over Compliance (continued) Condition and Context Expenditures related to ALN 97-036 which met both requirements listed above during the year ended June 30, 2023, were not included on the SEFA. Cause Internal controls were not designed effectively to ensure that the SEFA was complete. Effect The SEFA was understated by $196,367 which could impact major program determinations and required coverage to be tested. Questioned Cost None. Repeat Finding No. Recommendation We recommend that the College enhance its completeness review process of internal control to ensure that the SEFA is complete. Views of Responsible Officials See corrective action plan.
Finding 2023-002
Finding No. 2023-002: Improper Preparation of the Schedule of Expenditures of Federal Awards – Material Weakness in Internal Control over Compliance Criteria Nonfederal entities must record expenditures related to ALN 97.036 on the Schedule of Expenditures of Federal Awards (SEFA) when (1) FEMA has approved the nonfederal entity’s Project, and (2) the nonfederal entity has incurred the eligible expenditures. Federal awards expended in years subsequent to the fiscal year in which the Project is approved are to be recorded on the nonfederal entity’s SEFA in those subsequent years. SECTION III – FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (CONTINUED) Finding No. 2023-002: Improper Preparation of the Schedule of Expenditures of Federal Awards – Material Weakness in Internal Control over Compliance (continued) Condition and Context Expenditures related to ALN 97-036 which met both requirements listed above during the year ended June 30, 2023, were not included on the SEFA. Cause Internal controls were not designed effectively to ensure that the SEFA was complete. Effect The SEFA was understated by $196,367 which could impact major program determinations and required coverage to be tested. Questioned Cost None. Repeat Finding No. Recommendation We recommend that the College enhance its completeness review process of internal control to ensure that the SEFA is complete. Views of Responsible Officials See corrective action plan.
Finding 2023-002
Finding No. 2023-002: Improper Preparation of the Schedule of Expenditures of Federal Awards – Material Weakness in Internal Control over Compliance Criteria Nonfederal entities must record expenditures related to ALN 97.036 on the Schedule of Expenditures of Federal Awards (SEFA) when (1) FEMA has approved the nonfederal entity’s Project, and (2) the nonfederal entity has incurred the eligible expenditures. Federal awards expended in years subsequent to the fiscal year in which the Project is approved are to be recorded on the nonfederal entity’s SEFA in those subsequent years. SECTION III – FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (CONTINUED) Finding No. 2023-002: Improper Preparation of the Schedule of Expenditures of Federal Awards – Material Weakness in Internal Control over Compliance (continued) Condition and Context Expenditures related to ALN 97-036 which met both requirements listed above during the year ended June 30, 2023, were not included on the SEFA. Cause Internal controls were not designed effectively to ensure that the SEFA was complete. Effect The SEFA was understated by $196,367 which could impact major program determinations and required coverage to be tested. Questioned Cost None. Repeat Finding No. Recommendation We recommend that the College enhance its completeness review process of internal control to ensure that the SEFA is complete. Views of Responsible Officials See corrective action plan.
Finding 2023-002
Finding No. 2023-002: Improper Preparation of the Schedule of Expenditures of Federal Awards – Material Weakness in Internal Control over Compliance Criteria Nonfederal entities must record expenditures related to ALN 97.036 on the Schedule of Expenditures of Federal Awards (SEFA) when (1) FEMA has approved the nonfederal entity’s Project, and (2) the nonfederal entity has incurred the eligible expenditures. Federal awards expended in years subsequent to the fiscal year in which the Project is approved are to be recorded on the nonfederal entity’s SEFA in those subsequent years. SECTION III – FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (CONTINUED) Finding No. 2023-002: Improper Preparation of the Schedule of Expenditures of Federal Awards – Material Weakness in Internal Control over Compliance (continued) Condition and Context Expenditures related to ALN 97-036 which met both requirements listed above during the year ended June 30, 2023, were not included on the SEFA. Cause Internal controls were not designed effectively to ensure that the SEFA was complete. Effect The SEFA was understated by $196,367 which could impact major program determinations and required coverage to be tested. Questioned Cost None. Repeat Finding No. Recommendation We recommend that the College enhance its completeness review process of internal control to ensure that the SEFA is complete. Views of Responsible Officials See corrective action plan.
Finding 2023-002
Finding No. 2023-002: Improper Preparation of the Schedule of Expenditures of Federal Awards – Material Weakness in Internal Control over Compliance Criteria Nonfederal entities must record expenditures related to ALN 97.036 on the Schedule of Expenditures of Federal Awards (SEFA) when (1) FEMA has approved the nonfederal entity’s Project, and (2) the nonfederal entity has incurred the eligible expenditures. Federal awards expended in years subsequent to the fiscal year in which the Project is approved are to be recorded on the nonfederal entity’s SEFA in those subsequent years. SECTION III – FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (CONTINUED) Finding No. 2023-002: Improper Preparation of the Schedule of Expenditures of Federal Awards – Material Weakness in Internal Control over Compliance (continued) Condition and Context Expenditures related to ALN 97-036 which met both requirements listed above during the year ended June 30, 2023, were not included on the SEFA. Cause Internal controls were not designed effectively to ensure that the SEFA was complete. Effect The SEFA was understated by $196,367 which could impact major program determinations and required coverage to be tested. Questioned Cost None. Repeat Finding No. Recommendation We recommend that the College enhance its completeness review process of internal control to ensure that the SEFA is complete. Views of Responsible Officials See corrective action plan.
Finding 2023-002
Finding No. 2023-002: Improper Preparation of the Schedule of Expenditures of Federal Awards – Material Weakness in Internal Control over Compliance Criteria Nonfederal entities must record expenditures related to ALN 97.036 on the Schedule of Expenditures of Federal Awards (SEFA) when (1) FEMA has approved the nonfederal entity’s Project, and (2) the nonfederal entity has incurred the eligible expenditures. Federal awards expended in years subsequent to the fiscal year in which the Project is approved are to be recorded on the nonfederal entity’s SEFA in those subsequent years. SECTION III – FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (CONTINUED) Finding No. 2023-002: Improper Preparation of the Schedule of Expenditures of Federal Awards – Material Weakness in Internal Control over Compliance (continued) Condition and Context Expenditures related to ALN 97-036 which met both requirements listed above during the year ended June 30, 2023, were not included on the SEFA. Cause Internal controls were not designed effectively to ensure that the SEFA was complete. Effect The SEFA was understated by $196,367 which could impact major program determinations and required coverage to be tested. Questioned Cost None. Repeat Finding No. Recommendation We recommend that the College enhance its completeness review process of internal control to ensure that the SEFA is complete. Views of Responsible Officials See corrective action plan.
Finding 2023-002
Finding No. 2023-002: Improper Preparation of the Schedule of Expenditures of Federal Awards – Material Weakness in Internal Control over Compliance Criteria Nonfederal entities must record expenditures related to ALN 97.036 on the Schedule of Expenditures of Federal Awards (SEFA) when (1) FEMA has approved the nonfederal entity’s Project, and (2) the nonfederal entity has incurred the eligible expenditures. Federal awards expended in years subsequent to the fiscal year in which the Project is approved are to be recorded on the nonfederal entity’s SEFA in those subsequent years. SECTION III – FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (CONTINUED) Finding No. 2023-002: Improper Preparation of the Schedule of Expenditures of Federal Awards – Material Weakness in Internal Control over Compliance (continued) Condition and Context Expenditures related to ALN 97-036 which met both requirements listed above during the year ended June 30, 2023, were not included on the SEFA. Cause Internal controls were not designed effectively to ensure that the SEFA was complete. Effect The SEFA was understated by $196,367 which could impact major program determinations and required coverage to be tested. Questioned Cost None. Repeat Finding No. Recommendation We recommend that the College enhance its completeness review process of internal control to ensure that the SEFA is complete. Views of Responsible Officials See corrective action plan.
Finding 2023-002
Finding No. 2023-002: Improper Preparation of the Schedule of Expenditures of Federal Awards – Material Weakness in Internal Control over Compliance Criteria Nonfederal entities must record expenditures related to ALN 97.036 on the Schedule of Expenditures of Federal Awards (SEFA) when (1) FEMA has approved the nonfederal entity’s Project, and (2) the nonfederal entity has incurred the eligible expenditures. Federal awards expended in years subsequent to the fiscal year in which the Project is approved are to be recorded on the nonfederal entity’s SEFA in those subsequent years. SECTION III – FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (CONTINUED) Finding No. 2023-002: Improper Preparation of the Schedule of Expenditures of Federal Awards – Material Weakness in Internal Control over Compliance (continued) Condition and Context Expenditures related to ALN 97-036 which met both requirements listed above during the year ended June 30, 2023, were not included on the SEFA. Cause Internal controls were not designed effectively to ensure that the SEFA was complete. Effect The SEFA was understated by $196,367 which could impact major program determinations and required coverage to be tested. Questioned Cost None. Repeat Finding No. Recommendation We recommend that the College enhance its completeness review process of internal control to ensure that the SEFA is complete. Views of Responsible Officials See corrective action plan.