2024–002 – PREPARATION OF THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS
Funding Agency: All (see Schedule of Expenditures of Federal Awards)
Title: All (see Schedule of Expenditures of Federal Awards)
AL #: All (see Schedule of Expenditures of Federal Awards)
Award #: All (see Schedule of Expenditures of Federal Awards)
Award Period: All (see Schedule of Expenditures of Federal Awards)
Questioned Costs: None
Type of Finding: (E) Significant Deficiency in Internal Control Over Compliance of Federal Awards & (F) Instance of Non-Compliance Related to Federal Awards
Statement of Condition
The SEFA was not prepared timely and required adjustments to correctly present federal expenditures.
Criteria
2 CFR 200.510(b) requires that the auditee prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements.
Effect
The SEFA was not prepared in accordance with Uniform Guidance resulting in noncompliance. Additionally, this could have resulted in an incorrect selection of the major federal program.
Cause
There was turnover in management which caused the preparation of the SEFA to be delayed and requiring adjustments.
Recommendation
Design and implement internal controls to ensure accurate and timely preparation of the SEFA as required by the Uniform Guidance. The SEFA should include the federal portion of expenditures, the name of the grant, name of grantor, the Assistance Listing number, and pass-through entity information as applicable. The SEFA must also be reconciled to federal revenues and expenditures per the general ledger. Additionally, we recommend the QuickBooks job categories are reviewed regularly against the grant trackers to ensure proper coding in QuickBooks.
2024–002 – PREPARATION OF THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS
Funding Agency: All (see Schedule of Expenditures of Federal Awards)
Title: All (see Schedule of Expenditures of Federal Awards)
AL #: All (see Schedule of Expenditures of Federal Awards)
Award #: All (see Schedule of Expenditures of Federal Awards)
Award Period: All (see Schedule of Expenditures of Federal Awards)
Questioned Costs: None
Type of Finding: (E) Significant Deficiency in Internal Control Over Compliance of Federal Awards & (F) Instance of Non-Compliance Related to Federal Awards
Statement of Condition
The SEFA was not prepared timely and required adjustments to correctly present federal expenditures.
Criteria
2 CFR 200.510(b) requires that the auditee prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements.
Effect
The SEFA was not prepared in accordance with Uniform Guidance resulting in noncompliance. Additionally, this could have resulted in an incorrect selection of the major federal program.
Cause
There was turnover in management which caused the preparation of the SEFA to be delayed and requiring adjustments.
Recommendation
Design and implement internal controls to ensure accurate and timely preparation of the SEFA as required by the Uniform Guidance. The SEFA should include the federal portion of expenditures, the name of the grant, name of grantor, the Assistance Listing number, and pass-through entity information as applicable. The SEFA must also be reconciled to federal revenues and expenditures per the general ledger. Additionally, we recommend the QuickBooks job categories are reviewed regularly against the grant trackers to ensure proper coding in QuickBooks.
2024–002 – PREPARATION OF THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS
Funding Agency: All (see Schedule of Expenditures of Federal Awards)
Title: All (see Schedule of Expenditures of Federal Awards)
AL #: All (see Schedule of Expenditures of Federal Awards)
Award #: All (see Schedule of Expenditures of Federal Awards)
Award Period: All (see Schedule of Expenditures of Federal Awards)
Questioned Costs: None
Type of Finding: (E) Significant Deficiency in Internal Control Over Compliance of Federal Awards & (F) Instance of Non-Compliance Related to Federal Awards
Statement of Condition
The SEFA was not prepared timely and required adjustments to correctly present federal expenditures.
Criteria
2 CFR 200.510(b) requires that the auditee prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements.
Effect
The SEFA was not prepared in accordance with Uniform Guidance resulting in noncompliance. Additionally, this could have resulted in an incorrect selection of the major federal program.
Cause
There was turnover in management which caused the preparation of the SEFA to be delayed and requiring adjustments.
Recommendation
Design and implement internal controls to ensure accurate and timely preparation of the SEFA as required by the Uniform Guidance. The SEFA should include the federal portion of expenditures, the name of the grant, name of grantor, the Assistance Listing number, and pass-through entity information as applicable. The SEFA must also be reconciled to federal revenues and expenditures per the general ledger. Additionally, we recommend the QuickBooks job categories are reviewed regularly against the grant trackers to ensure proper coding in QuickBooks.
2024–002 – PREPARATION OF THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS
Funding Agency: All (see Schedule of Expenditures of Federal Awards)
Title: All (see Schedule of Expenditures of Federal Awards)
AL #: All (see Schedule of Expenditures of Federal Awards)
Award #: All (see Schedule of Expenditures of Federal Awards)
Award Period: All (see Schedule of Expenditures of Federal Awards)
Questioned Costs: None
Type of Finding: (E) Significant Deficiency in Internal Control Over Compliance of Federal Awards & (F) Instance of Non-Compliance Related to Federal Awards
Statement of Condition
The SEFA was not prepared timely and required adjustments to correctly present federal expenditures.
Criteria
2 CFR 200.510(b) requires that the auditee prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements.
Effect
The SEFA was not prepared in accordance with Uniform Guidance resulting in noncompliance. Additionally, this could have resulted in an incorrect selection of the major federal program.
Cause
There was turnover in management which caused the preparation of the SEFA to be delayed and requiring adjustments.
Recommendation
Design and implement internal controls to ensure accurate and timely preparation of the SEFA as required by the Uniform Guidance. The SEFA should include the federal portion of expenditures, the name of the grant, name of grantor, the Assistance Listing number, and pass-through entity information as applicable. The SEFA must also be reconciled to federal revenues and expenditures per the general ledger. Additionally, we recommend the QuickBooks job categories are reviewed regularly against the grant trackers to ensure proper coding in QuickBooks.
2024–002 – PREPARATION OF THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS
Funding Agency: All (see Schedule of Expenditures of Federal Awards)
Title: All (see Schedule of Expenditures of Federal Awards)
AL #: All (see Schedule of Expenditures of Federal Awards)
Award #: All (see Schedule of Expenditures of Federal Awards)
Award Period: All (see Schedule of Expenditures of Federal Awards)
Questioned Costs: None
Type of Finding: (E) Significant Deficiency in Internal Control Over Compliance of Federal Awards & (F) Instance of Non-Compliance Related to Federal Awards
Statement of Condition
The SEFA was not prepared timely and required adjustments to correctly present federal expenditures.
Criteria
2 CFR 200.510(b) requires that the auditee prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements.
Effect
The SEFA was not prepared in accordance with Uniform Guidance resulting in noncompliance. Additionally, this could have resulted in an incorrect selection of the major federal program.
Cause
There was turnover in management which caused the preparation of the SEFA to be delayed and requiring adjustments.
Recommendation
Design and implement internal controls to ensure accurate and timely preparation of the SEFA as required by the Uniform Guidance. The SEFA should include the federal portion of expenditures, the name of the grant, name of grantor, the Assistance Listing number, and pass-through entity information as applicable. The SEFA must also be reconciled to federal revenues and expenditures per the general ledger. Additionally, we recommend the QuickBooks job categories are reviewed regularly against the grant trackers to ensure proper coding in QuickBooks.
2024–002 – PREPARATION OF THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS
Funding Agency: All (see Schedule of Expenditures of Federal Awards)
Title: All (see Schedule of Expenditures of Federal Awards)
AL #: All (see Schedule of Expenditures of Federal Awards)
Award #: All (see Schedule of Expenditures of Federal Awards)
Award Period: All (see Schedule of Expenditures of Federal Awards)
Questioned Costs: None
Type of Finding: (E) Significant Deficiency in Internal Control Over Compliance of Federal Awards & (F) Instance of Non-Compliance Related to Federal Awards
Statement of Condition
The SEFA was not prepared timely and required adjustments to correctly present federal expenditures.
Criteria
2 CFR 200.510(b) requires that the auditee prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements.
Effect
The SEFA was not prepared in accordance with Uniform Guidance resulting in noncompliance. Additionally, this could have resulted in an incorrect selection of the major federal program.
Cause
There was turnover in management which caused the preparation of the SEFA to be delayed and requiring adjustments.
Recommendation
Design and implement internal controls to ensure accurate and timely preparation of the SEFA as required by the Uniform Guidance. The SEFA should include the federal portion of expenditures, the name of the grant, name of grantor, the Assistance Listing number, and pass-through entity information as applicable. The SEFA must also be reconciled to federal revenues and expenditures per the general ledger. Additionally, we recommend the QuickBooks job categories are reviewed regularly against the grant trackers to ensure proper coding in QuickBooks.
2024–002 – PREPARATION OF THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS
Funding Agency: All (see Schedule of Expenditures of Federal Awards)
Title: All (see Schedule of Expenditures of Federal Awards)
AL #: All (see Schedule of Expenditures of Federal Awards)
Award #: All (see Schedule of Expenditures of Federal Awards)
Award Period: All (see Schedule of Expenditures of Federal Awards)
Questioned Costs: None
Type of Finding: (E) Significant Deficiency in Internal Control Over Compliance of Federal Awards & (F) Instance of Non-Compliance Related to Federal Awards
Statement of Condition
The SEFA was not prepared timely and required adjustments to correctly present federal expenditures.
Criteria
2 CFR 200.510(b) requires that the auditee prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements.
Effect
The SEFA was not prepared in accordance with Uniform Guidance resulting in noncompliance. Additionally, this could have resulted in an incorrect selection of the major federal program.
Cause
There was turnover in management which caused the preparation of the SEFA to be delayed and requiring adjustments.
Recommendation
Design and implement internal controls to ensure accurate and timely preparation of the SEFA as required by the Uniform Guidance. The SEFA should include the federal portion of expenditures, the name of the grant, name of grantor, the Assistance Listing number, and pass-through entity information as applicable. The SEFA must also be reconciled to federal revenues and expenditures per the general ledger. Additionally, we recommend the QuickBooks job categories are reviewed regularly against the grant trackers to ensure proper coding in QuickBooks.
2024–002 – PREPARATION OF THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS
Funding Agency: All (see Schedule of Expenditures of Federal Awards)
Title: All (see Schedule of Expenditures of Federal Awards)
AL #: All (see Schedule of Expenditures of Federal Awards)
Award #: All (see Schedule of Expenditures of Federal Awards)
Award Period: All (see Schedule of Expenditures of Federal Awards)
Questioned Costs: None
Type of Finding: (E) Significant Deficiency in Internal Control Over Compliance of Federal Awards & (F) Instance of Non-Compliance Related to Federal Awards
Statement of Condition
The SEFA was not prepared timely and required adjustments to correctly present federal expenditures.
Criteria
2 CFR 200.510(b) requires that the auditee prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements.
Effect
The SEFA was not prepared in accordance with Uniform Guidance resulting in noncompliance. Additionally, this could have resulted in an incorrect selection of the major federal program.
Cause
There was turnover in management which caused the preparation of the SEFA to be delayed and requiring adjustments.
Recommendation
Design and implement internal controls to ensure accurate and timely preparation of the SEFA as required by the Uniform Guidance. The SEFA should include the federal portion of expenditures, the name of the grant, name of grantor, the Assistance Listing number, and pass-through entity information as applicable. The SEFA must also be reconciled to federal revenues and expenditures per the general ledger. Additionally, we recommend the QuickBooks job categories are reviewed regularly against the grant trackers to ensure proper coding in QuickBooks.
2024–002 – PREPARATION OF THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS
Funding Agency: All (see Schedule of Expenditures of Federal Awards)
Title: All (see Schedule of Expenditures of Federal Awards)
AL #: All (see Schedule of Expenditures of Federal Awards)
Award #: All (see Schedule of Expenditures of Federal Awards)
Award Period: All (see Schedule of Expenditures of Federal Awards)
Questioned Costs: None
Type of Finding: (E) Significant Deficiency in Internal Control Over Compliance of Federal Awards & (F) Instance of Non-Compliance Related to Federal Awards
Statement of Condition
The SEFA was not prepared timely and required adjustments to correctly present federal expenditures.
Criteria
2 CFR 200.510(b) requires that the auditee prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements.
Effect
The SEFA was not prepared in accordance with Uniform Guidance resulting in noncompliance. Additionally, this could have resulted in an incorrect selection of the major federal program.
Cause
There was turnover in management which caused the preparation of the SEFA to be delayed and requiring adjustments.
Recommendation
Design and implement internal controls to ensure accurate and timely preparation of the SEFA as required by the Uniform Guidance. The SEFA should include the federal portion of expenditures, the name of the grant, name of grantor, the Assistance Listing number, and pass-through entity information as applicable. The SEFA must also be reconciled to federal revenues and expenditures per the general ledger. Additionally, we recommend the QuickBooks job categories are reviewed regularly against the grant trackers to ensure proper coding in QuickBooks.
2024–002 – PREPARATION OF THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS
Funding Agency: All (see Schedule of Expenditures of Federal Awards)
Title: All (see Schedule of Expenditures of Federal Awards)
AL #: All (see Schedule of Expenditures of Federal Awards)
Award #: All (see Schedule of Expenditures of Federal Awards)
Award Period: All (see Schedule of Expenditures of Federal Awards)
Questioned Costs: None
Type of Finding: (E) Significant Deficiency in Internal Control Over Compliance of Federal Awards & (F) Instance of Non-Compliance Related to Federal Awards
Statement of Condition
The SEFA was not prepared timely and required adjustments to correctly present federal expenditures.
Criteria
2 CFR 200.510(b) requires that the auditee prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements.
Effect
The SEFA was not prepared in accordance with Uniform Guidance resulting in noncompliance. Additionally, this could have resulted in an incorrect selection of the major federal program.
Cause
There was turnover in management which caused the preparation of the SEFA to be delayed and requiring adjustments.
Recommendation
Design and implement internal controls to ensure accurate and timely preparation of the SEFA as required by the Uniform Guidance. The SEFA should include the federal portion of expenditures, the name of the grant, name of grantor, the Assistance Listing number, and pass-through entity information as applicable. The SEFA must also be reconciled to federal revenues and expenditures per the general ledger. Additionally, we recommend the QuickBooks job categories are reviewed regularly against the grant trackers to ensure proper coding in QuickBooks.
2024–002 – PREPARATION OF THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS
Funding Agency: All (see Schedule of Expenditures of Federal Awards)
Title: All (see Schedule of Expenditures of Federal Awards)
AL #: All (see Schedule of Expenditures of Federal Awards)
Award #: All (see Schedule of Expenditures of Federal Awards)
Award Period: All (see Schedule of Expenditures of Federal Awards)
Questioned Costs: None
Type of Finding: (E) Significant Deficiency in Internal Control Over Compliance of Federal Awards & (F) Instance of Non-Compliance Related to Federal Awards
Statement of Condition
The SEFA was not prepared timely and required adjustments to correctly present federal expenditures.
Criteria
2 CFR 200.510(b) requires that the auditee prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements.
Effect
The SEFA was not prepared in accordance with Uniform Guidance resulting in noncompliance. Additionally, this could have resulted in an incorrect selection of the major federal program.
Cause
There was turnover in management which caused the preparation of the SEFA to be delayed and requiring adjustments.
Recommendation
Design and implement internal controls to ensure accurate and timely preparation of the SEFA as required by the Uniform Guidance. The SEFA should include the federal portion of expenditures, the name of the grant, name of grantor, the Assistance Listing number, and pass-through entity information as applicable. The SEFA must also be reconciled to federal revenues and expenditures per the general ledger. Additionally, we recommend the QuickBooks job categories are reviewed regularly against the grant trackers to ensure proper coding in QuickBooks.
2024–002 – PREPARATION OF THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS
Funding Agency: All (see Schedule of Expenditures of Federal Awards)
Title: All (see Schedule of Expenditures of Federal Awards)
AL #: All (see Schedule of Expenditures of Federal Awards)
Award #: All (see Schedule of Expenditures of Federal Awards)
Award Period: All (see Schedule of Expenditures of Federal Awards)
Questioned Costs: None
Type of Finding: (E) Significant Deficiency in Internal Control Over Compliance of Federal Awards & (F) Instance of Non-Compliance Related to Federal Awards
Statement of Condition
The SEFA was not prepared timely and required adjustments to correctly present federal expenditures.
Criteria
2 CFR 200.510(b) requires that the auditee prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements.
Effect
The SEFA was not prepared in accordance with Uniform Guidance resulting in noncompliance. Additionally, this could have resulted in an incorrect selection of the major federal program.
Cause
There was turnover in management which caused the preparation of the SEFA to be delayed and requiring adjustments.
Recommendation
Design and implement internal controls to ensure accurate and timely preparation of the SEFA as required by the Uniform Guidance. The SEFA should include the federal portion of expenditures, the name of the grant, name of grantor, the Assistance Listing number, and pass-through entity information as applicable. The SEFA must also be reconciled to federal revenues and expenditures per the general ledger. Additionally, we recommend the QuickBooks job categories are reviewed regularly against the grant trackers to ensure proper coding in QuickBooks.
2024–002 – PREPARATION OF THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS
Funding Agency: All (see Schedule of Expenditures of Federal Awards)
Title: All (see Schedule of Expenditures of Federal Awards)
AL #: All (see Schedule of Expenditures of Federal Awards)
Award #: All (see Schedule of Expenditures of Federal Awards)
Award Period: All (see Schedule of Expenditures of Federal Awards)
Questioned Costs: None
Type of Finding: (E) Significant Deficiency in Internal Control Over Compliance of Federal Awards & (F) Instance of Non-Compliance Related to Federal Awards
Statement of Condition
The SEFA was not prepared timely and required adjustments to correctly present federal expenditures.
Criteria
2 CFR 200.510(b) requires that the auditee prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements.
Effect
The SEFA was not prepared in accordance with Uniform Guidance resulting in noncompliance. Additionally, this could have resulted in an incorrect selection of the major federal program.
Cause
There was turnover in management which caused the preparation of the SEFA to be delayed and requiring adjustments.
Recommendation
Design and implement internal controls to ensure accurate and timely preparation of the SEFA as required by the Uniform Guidance. The SEFA should include the federal portion of expenditures, the name of the grant, name of grantor, the Assistance Listing number, and pass-through entity information as applicable. The SEFA must also be reconciled to federal revenues and expenditures per the general ledger. Additionally, we recommend the QuickBooks job categories are reviewed regularly against the grant trackers to ensure proper coding in QuickBooks.
2024–002 – PREPARATION OF THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS
Funding Agency: All (see Schedule of Expenditures of Federal Awards)
Title: All (see Schedule of Expenditures of Federal Awards)
AL #: All (see Schedule of Expenditures of Federal Awards)
Award #: All (see Schedule of Expenditures of Federal Awards)
Award Period: All (see Schedule of Expenditures of Federal Awards)
Questioned Costs: None
Type of Finding: (E) Significant Deficiency in Internal Control Over Compliance of Federal Awards & (F) Instance of Non-Compliance Related to Federal Awards
Statement of Condition
The SEFA was not prepared timely and required adjustments to correctly present federal expenditures.
Criteria
2 CFR 200.510(b) requires that the auditee prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements.
Effect
The SEFA was not prepared in accordance with Uniform Guidance resulting in noncompliance. Additionally, this could have resulted in an incorrect selection of the major federal program.
Cause
There was turnover in management which caused the preparation of the SEFA to be delayed and requiring adjustments.
Recommendation
Design and implement internal controls to ensure accurate and timely preparation of the SEFA as required by the Uniform Guidance. The SEFA should include the federal portion of expenditures, the name of the grant, name of grantor, the Assistance Listing number, and pass-through entity information as applicable. The SEFA must also be reconciled to federal revenues and expenditures per the general ledger. Additionally, we recommend the QuickBooks job categories are reviewed regularly against the grant trackers to ensure proper coding in QuickBooks.
2024–002 – PREPARATION OF THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS
Funding Agency: All (see Schedule of Expenditures of Federal Awards)
Title: All (see Schedule of Expenditures of Federal Awards)
AL #: All (see Schedule of Expenditures of Federal Awards)
Award #: All (see Schedule of Expenditures of Federal Awards)
Award Period: All (see Schedule of Expenditures of Federal Awards)
Questioned Costs: None
Type of Finding: (E) Significant Deficiency in Internal Control Over Compliance of Federal Awards & (F) Instance of Non-Compliance Related to Federal Awards
Statement of Condition
The SEFA was not prepared timely and required adjustments to correctly present federal expenditures.
Criteria
2 CFR 200.510(b) requires that the auditee prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements.
Effect
The SEFA was not prepared in accordance with Uniform Guidance resulting in noncompliance. Additionally, this could have resulted in an incorrect selection of the major federal program.
Cause
There was turnover in management which caused the preparation of the SEFA to be delayed and requiring adjustments.
Recommendation
Design and implement internal controls to ensure accurate and timely preparation of the SEFA as required by the Uniform Guidance. The SEFA should include the federal portion of expenditures, the name of the grant, name of grantor, the Assistance Listing number, and pass-through entity information as applicable. The SEFA must also be reconciled to federal revenues and expenditures per the general ledger. Additionally, we recommend the QuickBooks job categories are reviewed regularly against the grant trackers to ensure proper coding in QuickBooks.
2024–002 – PREPARATION OF THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS
Funding Agency: All (see Schedule of Expenditures of Federal Awards)
Title: All (see Schedule of Expenditures of Federal Awards)
AL #: All (see Schedule of Expenditures of Federal Awards)
Award #: All (see Schedule of Expenditures of Federal Awards)
Award Period: All (see Schedule of Expenditures of Federal Awards)
Questioned Costs: None
Type of Finding: (E) Significant Deficiency in Internal Control Over Compliance of Federal Awards & (F) Instance of Non-Compliance Related to Federal Awards
Statement of Condition
The SEFA was not prepared timely and required adjustments to correctly present federal expenditures.
Criteria
2 CFR 200.510(b) requires that the auditee prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements.
Effect
The SEFA was not prepared in accordance with Uniform Guidance resulting in noncompliance. Additionally, this could have resulted in an incorrect selection of the major federal program.
Cause
There was turnover in management which caused the preparation of the SEFA to be delayed and requiring adjustments.
Recommendation
Design and implement internal controls to ensure accurate and timely preparation of the SEFA as required by the Uniform Guidance. The SEFA should include the federal portion of expenditures, the name of the grant, name of grantor, the Assistance Listing number, and pass-through entity information as applicable. The SEFA must also be reconciled to federal revenues and expenditures per the general ledger. Additionally, we recommend the QuickBooks job categories are reviewed regularly against the grant trackers to ensure proper coding in QuickBooks.
2024–002 – PREPARATION OF THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS
Funding Agency: All (see Schedule of Expenditures of Federal Awards)
Title: All (see Schedule of Expenditures of Federal Awards)
AL #: All (see Schedule of Expenditures of Federal Awards)
Award #: All (see Schedule of Expenditures of Federal Awards)
Award Period: All (see Schedule of Expenditures of Federal Awards)
Questioned Costs: None
Type of Finding: (E) Significant Deficiency in Internal Control Over Compliance of Federal Awards & (F) Instance of Non-Compliance Related to Federal Awards
Statement of Condition
The SEFA was not prepared timely and required adjustments to correctly present federal expenditures.
Criteria
2 CFR 200.510(b) requires that the auditee prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements.
Effect
The SEFA was not prepared in accordance with Uniform Guidance resulting in noncompliance. Additionally, this could have resulted in an incorrect selection of the major federal program.
Cause
There was turnover in management which caused the preparation of the SEFA to be delayed and requiring adjustments.
Recommendation
Design and implement internal controls to ensure accurate and timely preparation of the SEFA as required by the Uniform Guidance. The SEFA should include the federal portion of expenditures, the name of the grant, name of grantor, the Assistance Listing number, and pass-through entity information as applicable. The SEFA must also be reconciled to federal revenues and expenditures per the general ledger. Additionally, we recommend the QuickBooks job categories are reviewed regularly against the grant trackers to ensure proper coding in QuickBooks.
2024–002 – PREPARATION OF THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS
Funding Agency: All (see Schedule of Expenditures of Federal Awards)
Title: All (see Schedule of Expenditures of Federal Awards)
AL #: All (see Schedule of Expenditures of Federal Awards)
Award #: All (see Schedule of Expenditures of Federal Awards)
Award Period: All (see Schedule of Expenditures of Federal Awards)
Questioned Costs: None
Type of Finding: (E) Significant Deficiency in Internal Control Over Compliance of Federal Awards & (F) Instance of Non-Compliance Related to Federal Awards
Statement of Condition
The SEFA was not prepared timely and required adjustments to correctly present federal expenditures.
Criteria
2 CFR 200.510(b) requires that the auditee prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements.
Effect
The SEFA was not prepared in accordance with Uniform Guidance resulting in noncompliance. Additionally, this could have resulted in an incorrect selection of the major federal program.
Cause
There was turnover in management which caused the preparation of the SEFA to be delayed and requiring adjustments.
Recommendation
Design and implement internal controls to ensure accurate and timely preparation of the SEFA as required by the Uniform Guidance. The SEFA should include the federal portion of expenditures, the name of the grant, name of grantor, the Assistance Listing number, and pass-through entity information as applicable. The SEFA must also be reconciled to federal revenues and expenditures per the general ledger. Additionally, we recommend the QuickBooks job categories are reviewed regularly against the grant trackers to ensure proper coding in QuickBooks.