CRITERIA/SPECIFIC REQUIREMENT: The Code of Federal Regulations (Code) (2 CFR §200.510 (b)), establishes criteria and requirements related to the preparation of the schedule of expenditures of federal awards. The Code (2 CFR §200.303 (a)) requires Regional Office of Education No. 39 to establish and maintain effective internal control over the federal award to provide reasonable assurance the Regional Office is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. Effective internal controls should include procedures over preparation of the schedule of expenditures of federal awards. CONDITION: The Regional Office of Education No. 39 did not have sufficient internal controls over the preparation of the Schedule of Expenditures of Federal Awards (SEFA) to ensure all federal expenditures during the fiscal year were reported and information in the SEFA was accurately reported. CONTEXT: During our review of the SEFA, we noted the following: The Education Stabilization Fund was not specifically categorized in the SEFA and the total federal awards expended for the program was not reported. Program title descriptions were incorrect. Assistance listing number was incorrectly listed. Pass-through subrecipient amount was not indicated. EFFECT: Failure to report an accurate SEFA affects the required audit coverage to meet federal requirements and can delay an audit beyond the reporting deadline. CAUSE: Management indicated the errors on the SEFA was due to oversight. RECOMMENDATION: The Regional Office of Education No. 39 should establish and implement internal controls over preparation of the SEFA to ensure accurate reporting. MANAGEMENT’S RESPONSE: The Regional Office of Education No. 39 agrees with the audit findings and will work with contracted accounting firm to ensure that the schedule of expenditures of federal awards are accurately reported as required.
Criteria: 2 CFR 200.510(b) requires the auditee to prepare a schedule of expenditures of federal awards (SEFA) that contains federal awards expended during the period. Condition: On the original SEFA provided for the audit, the total federal expenditures reflected on the SEFA were inaccurate with excess amounts for some programs and omitting some grants with federal flow through funds. This resulted in a material restatement of the SEFA. Cause: During the year end accounting closing cycle, the Organization did an initial year end close and due to limitations on the staff was unable to ensure the complete accuracy of the SEFA prior to providing it to the auditor. Effect: SEFA was inaccurate Recommendation: We recommend the Organization review its year end close timeline and procedures to ensure that all grants are reviewed and reviewed for activity during the period to ensure that the SEFA is complete and accurate. Views of Responsible Officials: Management agrees with the finding; see corrective action plan.
2 CFR 200.501 requires a non-Federal entity that expends $750,000 or more during the non-Federal entity's fiscal year in Federal awards must have a single or program-specific audit conducted for that year in accordance with the provisions of this part. A non-Federal entity that expends $750,000 or more in Federal awards during the non-Federal entity's fiscal year must have a single audit conducted in accordance with § 200.514 except when it elects to have a program-specific audit conducted in accordance with paragraph (c) or (d) of this section. 2 CFR §200.512(a)(2) states that an audit, the data collection form, and the reporting package must be submitted within 30 calendar days after the auditee receives the auditor's report(s) or nine months after the end of the audit period (whichever is earlier). 2 CFR Subpart F §200.510(b) requires the auditee prepare a Schedule of Expenditures of Federal Awards (the Schedule) for the period covered by the Academy’s financial statements which must include the total federal awards expended as determined in accordance with § 200.502. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the ALN number or other identifying number when the ALN information is not available. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502 Basis for determining Federal awards expended, paragraph (b), identify in the notes to the schedule the balances outstanding at the end of the audit period. (6) Include notes that describe the significant accounting policies used in preparing the schedule, and note whether or not the auditee has elected to use the 10 percent de minimis cost rate as covered in § 200.414 Indirect (F&A) costs. The Academy’s internal control procedures did not identify expenses sufficiently to identify the need for a Single Audit. The Schedule has been presented in this report. Noncompliance with grant requirements as well as errors and omissions on the Schedule could have an adverse effect on future grant awards by the awarding agencies in addition to an inaccurate assessment of major federal programs that would be subjected to audit.
2 CFR 200.501 requires a non-Federal entity that expends $750,000 or more during the non-Federal entity's fiscal year in Federal awards must have a single or program-specific audit conducted for that year in accordance with the provisions of this part. A non-Federal entity that expends $750,000 or more in Federal awards during the non-Federal entity's fiscal year must have a single audit conducted in accordance with § 200.514 except when it elects to have a program-specific audit conducted in accordance with paragraph (c) or (d) of this section. 2 CFR §200.512(a)(2) states that an audit, the data collection form, and the reporting package must be submitted within 30 calendar days after the auditee receives the auditor's report(s) or nine months after the end of the audit period (whichever is earlier). 2 CFR Subpart F §200.510(b) requires the auditee prepare a Schedule of Expenditures of Federal Awards (the Schedule) for the period covered by the Academy’s financial statements which must include the total federal awards expended as determined in accordance with § 200.502. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the ALN number or other identifying number when the ALN information is not available. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502 Basis for determining Federal awards expended, paragraph (b), identify in the notes to the schedule the balances outstanding at the end of the audit period. (6) Include notes that describe the significant accounting policies used in preparing the schedule, and note whether or not the auditee has elected to use the 10 percent de minimis cost rate as covered in § 200.414 Indirect (F&A) costs. The Academy’s internal control procedures did not identify expenses sufficiently to identify the need for a Single Audit. The Schedule has been presented in this report. Noncompliance with grant requirements as well as errors and omissions on the Schedule could have an adverse effect on future grant awards by the awarding agencies in addition to an inaccurate assessment of major federal programs that would be subjected to audit.
2 CFR 200.501 requires a non-Federal entity that expends $750,000 or more during the non-Federal entity's fiscal year in Federal awards must have a single or program-specific audit conducted for that year in accordance with the provisions of this part. A non-Federal entity that expends $750,000 or more in Federal awards during the non-Federal entity's fiscal year must have a single audit conducted in accordance with § 200.514 except when it elects to have a program-specific audit conducted in accordance with paragraph (c) or (d) of this section. 2 CFR §200.512(a)(2) states that an audit, the data collection form, and the reporting package must be submitted within 30 calendar days after the auditee receives the auditor's report(s) or nine months after the end of the audit period (whichever is earlier). 2 CFR Subpart F §200.510(b) requires the auditee prepare a Schedule of Expenditures of Federal Awards (the Schedule) for the period covered by the Academy’s financial statements which must include the total federal awards expended as determined in accordance with § 200.502. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the ALN number or other identifying number when the ALN information is not available. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502 Basis for determining Federal awards expended, paragraph (b), identify in the notes to the schedule the balances outstanding at the end of the audit period. (6) Include notes that describe the significant accounting policies used in preparing the schedule, and note whether or not the auditee has elected to use the 10 percent de minimis cost rate as covered in § 200.414 Indirect (F&A) costs. The Academy’s internal control procedures did not identify expenses sufficiently to identify the need for a Single Audit. The Schedule has been presented in this report. Noncompliance with grant requirements as well as errors and omissions on the Schedule could have an adverse effect on future grant awards by the awarding agencies in addition to an inaccurate assessment of major federal programs that would be subjected to audit.
2 CFR 200.501 requires a non-Federal entity that expends $750,000 or more during the non-Federal entity's fiscal year in Federal awards must have a single or program-specific audit conducted for that year in accordance with the provisions of this part. A non-Federal entity that expends $750,000 or more in Federal awards during the non-Federal entity's fiscal year must have a single audit conducted in accordance with § 200.514 except when it elects to have a program-specific audit conducted in accordance with paragraph (c) or (d) of this section. 2 CFR §200.512(a)(2) states that an audit, the data collection form, and the reporting package must be submitted within 30 calendar days after the auditee receives the auditor's report(s) or nine months after the end of the audit period (whichever is earlier). 2 CFR Subpart F §200.510(b) requires the auditee prepare a Schedule of Expenditures of Federal Awards (the Schedule) for the period covered by the Academy’s financial statements which must include the total federal awards expended as determined in accordance with § 200.502. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the ALN number or other identifying number when the ALN information is not available. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502 Basis for determining Federal awards expended, paragraph (b), identify in the notes to the schedule the balances outstanding at the end of the audit period. (6) Include notes that describe the significant accounting policies used in preparing the schedule, and note whether or not the auditee has elected to use the 10 percent de minimis cost rate as covered in § 200.414 Indirect (F&A) costs. The Academy’s internal control procedures did not identify expenses sufficiently to identify the need for a Single Audit. The Schedule has been presented in this report. Noncompliance with grant requirements as well as errors and omissions on the Schedule could have an adverse effect on future grant awards by the awarding agencies in addition to an inaccurate assessment of major federal programs that would be subjected to audit.
2 CFR 200.501 requires a non-Federal entity that expends $750,000 or more during the non-Federal entity's fiscal year in Federal awards must have a single or program-specific audit conducted for that year in accordance with the provisions of this part. A non-Federal entity that expends $750,000 or more in Federal awards during the non-Federal entity's fiscal year must have a single audit conducted in accordance with § 200.514 except when it elects to have a program-specific audit conducted in accordance with paragraph (c) or (d) of this section. 2 CFR §200.512(a)(2) states that an audit, the data collection form, and the reporting package must be submitted within 30 calendar days after the auditee receives the auditor's report(s) or nine months after the end of the audit period (whichever is earlier). 2 CFR Subpart F §200.510(b) requires the auditee prepare a Schedule of Expenditures of Federal Awards (the Schedule) for the period covered by the Academy’s financial statements which must include the total federal awards expended as determined in accordance with § 200.502. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the ALN number or other identifying number when the ALN information is not available. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502 Basis for determining Federal awards expended, paragraph (b), identify in the notes to the schedule the balances outstanding at the end of the audit period. (6) Include notes that describe the significant accounting policies used in preparing the schedule, and note whether or not the auditee has elected to use the 10 percent de minimis cost rate as covered in § 200.414 Indirect (F&A) costs. The Academy’s internal control procedures did not identify expenses sufficiently to identify the need for a Single Audit. The Schedule has been presented in this report. Noncompliance with grant requirements as well as errors and omissions on the Schedule could have an adverse effect on future grant awards by the awarding agencies in addition to an inaccurate assessment of major federal programs that would be subjected to audit.
2 CFR 200.501 requires a non-Federal entity that expends $750,000 or more during the non-Federal entity's fiscal year in Federal awards must have a single or program-specific audit conducted for that year in accordance with the provisions of this part. A non-Federal entity that expends $750,000 or more in Federal awards during the non-Federal entity's fiscal year must have a single audit conducted in accordance with § 200.514 except when it elects to have a program-specific audit conducted in accordance with paragraph (c) or (d) of this section. 2 CFR §200.512(a)(2) states that an audit, the data collection form, and the reporting package must be submitted within 30 calendar days after the auditee receives the auditor's report(s) or nine months after the end of the audit period (whichever is earlier). 2 CFR Subpart F §200.510(b) requires the auditee prepare a Schedule of Expenditures of Federal Awards (the Schedule) for the period covered by the Academy’s financial statements which must include the total federal awards expended as determined in accordance with § 200.502. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the ALN number or other identifying number when the ALN information is not available. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502 Basis for determining Federal awards expended, paragraph (b), identify in the notes to the schedule the balances outstanding at the end of the audit period. (6) Include notes that describe the significant accounting policies used in preparing the schedule, and note whether or not the auditee has elected to use the 10 percent de minimis cost rate as covered in § 200.414 Indirect (F&A) costs. The Academy’s internal control procedures did not identify expenses sufficiently to identify the need for a Single Audit. The Schedule has been presented in this report. Noncompliance with grant requirements as well as errors and omissions on the Schedule could have an adverse effect on future grant awards by the awarding agencies in addition to an inaccurate assessment of major federal programs that would be subjected to audit.
2 CFR 200.501 requires a non-Federal entity that expends $750,000 or more during the non-Federal entity's fiscal year in Federal awards must have a single or program-specific audit conducted for that year in accordance with the provisions of this part. A non-Federal entity that expends $750,000 or more in Federal awards during the non-Federal entity's fiscal year must have a single audit conducted in accordance with § 200.514 except when it elects to have a program-specific audit conducted in accordance with paragraph (c) or (d) of this section. 2 CFR §200.512(a)(2) states that an audit, the data collection form, and the reporting package must be submitted within 30 calendar days after the auditee receives the auditor's report(s) or nine months after the end of the audit period (whichever is earlier). 2 CFR Subpart F §200.510(b) requires the auditee prepare a Schedule of Expenditures of Federal Awards (the Schedule) for the period covered by the Academy’s financial statements which must include the total federal awards expended as determined in accordance with § 200.502. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the ALN number or other identifying number when the ALN information is not available. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502 Basis for determining Federal awards expended, paragraph (b), identify in the notes to the schedule the balances outstanding at the end of the audit period. (6) Include notes that describe the significant accounting policies used in preparing the schedule, and note whether or not the auditee has elected to use the 10 percent de minimis cost rate as covered in § 200.414 Indirect (F&A) costs. The Academy’s internal control procedures did not identify expenses sufficiently to identify the need for a Single Audit. The Schedule has been presented in this report. Noncompliance with grant requirements as well as errors and omissions on the Schedule could have an adverse effect on future grant awards by the awarding agencies in addition to an inaccurate assessment of major federal programs that would be subjected to audit.
2 CFR 200.501 requires a non-Federal entity that expends $750,000 or more during the non-Federal entity's fiscal year in Federal awards must have a single or program-specific audit conducted for that year in accordance with the provisions of this part. A non-Federal entity that expends $750,000 or more in Federal awards during the non-Federal entity's fiscal year must have a single audit conducted in accordance with § 200.514 except when it elects to have a program-specific audit conducted in accordance with paragraph (c) or (d) of this section. 2 CFR §200.512(a)(2) states that an audit, the data collection form, and the reporting package must be submitted within 30 calendar days after the auditee receives the auditor's report(s) or nine months after the end of the audit period (whichever is earlier). 2 CFR Subpart F §200.510(b) requires the auditee prepare a Schedule of Expenditures of Federal Awards (the Schedule) for the period covered by the Academy’s financial statements which must include the total federal awards expended as determined in accordance with § 200.502. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the ALN number or other identifying number when the ALN information is not available. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502 Basis for determining Federal awards expended, paragraph (b), identify in the notes to the schedule the balances outstanding at the end of the audit period. (6) Include notes that describe the significant accounting policies used in preparing the schedule, and note whether or not the auditee has elected to use the 10 percent de minimis cost rate as covered in § 200.414 Indirect (F&A) costs. The Academy’s internal control procedures did not identify expenses sufficiently to identify the need for a Single Audit. The Schedule has been presented in this report. Noncompliance with grant requirements as well as errors and omissions on the Schedule could have an adverse effect on future grant awards by the awarding agencies in addition to an inaccurate assessment of major federal programs that would be subjected to audit.
2 CFR 200.501 requires a non-Federal entity that expends $750,000 or more during the non-Federal entity's fiscal year in Federal awards must have a single or program-specific audit conducted for that year in accordance with the provisions of this part. A non-Federal entity that expends $750,000 or more in Federal awards during the non-Federal entity's fiscal year must have a single audit conducted in accordance with § 200.514 except when it elects to have a program-specific audit conducted in accordance with paragraph (c) or (d) of this section. 2 CFR §200.512(a)(2) states that an audit, the data collection form, and the reporting package must be submitted within 30 calendar days after the auditee receives the auditor's report(s) or nine months after the end of the audit period (whichever is earlier). 2 CFR Subpart F §200.510(b) requires the auditee prepare a Schedule of Expenditures of Federal Awards (the Schedule) for the period covered by the Academy’s financial statements which must include the total federal awards expended as determined in accordance with § 200.502. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the ALN number or other identifying number when the ALN information is not available. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502 Basis for determining Federal awards expended, paragraph (b), identify in the notes to the schedule the balances outstanding at the end of the audit period. (6) Include notes that describe the significant accounting policies used in preparing the schedule, and note whether or not the auditee has elected to use the 10 percent de minimis cost rate as covered in § 200.414 Indirect (F&A) costs. The Academy’s internal control procedures did not identify expenses sufficiently to identify the need for a Single Audit. The Schedule has been presented in this report. Noncompliance with grant requirements as well as errors and omissions on the Schedule could have an adverse effect on future grant awards by the awarding agencies in addition to an inaccurate assessment of major federal programs that would be subjected to audit.
2 CFR 200.501 requires a non-Federal entity that expends $750,000 or more during the non-Federal entity's fiscal year in Federal awards must have a single or program-specific audit conducted for that year in accordance with the provisions of this part. A non-Federal entity that expends $750,000 or more in Federal awards during the non-Federal entity's fiscal year must have a single audit conducted in accordance with § 200.514 except when it elects to have a program-specific audit conducted in accordance with paragraph (c) or (d) of this section. 2 CFR §200.512(a)(2) states that an audit, the data collection form, and the reporting package must be submitted within 30 calendar days after the auditee receives the auditor's report(s) or nine months after the end of the audit period (whichever is earlier). 2 CFR Subpart F §200.510(b) requires the auditee prepare a Schedule of Expenditures of Federal Awards (the Schedule) for the period covered by the Academy’s financial statements which must include the total federal awards expended as determined in accordance with § 200.502. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the ALN number or other identifying number when the ALN information is not available. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502 Basis for determining Federal awards expended, paragraph (b), identify in the notes to the schedule the balances outstanding at the end of the audit period. (6) Include notes that describe the significant accounting policies used in preparing the schedule, and note whether or not the auditee has elected to use the 10 percent de minimis cost rate as covered in § 200.414 Indirect (F&A) costs. The Academy’s internal control procedures did not identify expenses sufficiently to identify the need for a Single Audit. The Schedule has been presented in this report. Noncompliance with grant requirements as well as errors and omissions on the Schedule could have an adverse effect on future grant awards by the awarding agencies in addition to an inaccurate assessment of major federal programs that would be subjected to audit.
2 CFR 200.501 requires a non-Federal entity that expends $750,000 or more during the non-Federal entity's fiscal year in Federal awards must have a single or program-specific audit conducted for that year in accordance with the provisions of this part. A non-Federal entity that expends $750,000 or more in Federal awards during the non-Federal entity's fiscal year must have a single audit conducted in accordance with § 200.514 except when it elects to have a program-specific audit conducted in accordance with paragraph (c) or (d) of this section. 2 CFR §200.512(a)(2) states that an audit, the data collection form, and the reporting package must be submitted within 30 calendar days after the auditee receives the auditor's report(s) or nine months after the end of the audit period (whichever is earlier). 2 CFR Subpart F §200.510(b) requires the auditee prepare a Schedule of Expenditures of Federal Awards (the Schedule) for the period covered by the Academy’s financial statements which must include the total federal awards expended as determined in accordance with § 200.502. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the ALN number or other identifying number when the ALN information is not available. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502 Basis for determining Federal awards expended, paragraph (b), identify in the notes to the schedule the balances outstanding at the end of the audit period. (6) Include notes that describe the significant accounting policies used in preparing the schedule, and note whether or not the auditee has elected to use the 10 percent de minimis cost rate as covered in § 200.414 Indirect (F&A) costs. The Academy’s internal control procedures did not identify expenses sufficiently to identify the need for a Single Audit. The Schedule has been presented in this report. Noncompliance with grant requirements as well as errors and omissions on the Schedule could have an adverse effect on future grant awards by the awarding agencies in addition to an inaccurate assessment of major federal programs that would be subjected to audit.
2 CFR 200.501 requires a non-Federal entity that expends $750,000 or more during the non-Federal entity's fiscal year in Federal awards must have a single or program-specific audit conducted for that year in accordance with the provisions of this part. A non-Federal entity that expends $750,000 or more in Federal awards during the non-Federal entity's fiscal year must have a single audit conducted in accordance with § 200.514 except when it elects to have a program-specific audit conducted in accordance with paragraph (c) or (d) of this section. 2 CFR §200.512(a)(2) states that an audit, the data collection form, and the reporting package must be submitted within 30 calendar days after the auditee receives the auditor's report(s) or nine months after the end of the audit period (whichever is earlier). 2 CFR Subpart F §200.510(b) requires the auditee prepare a Schedule of Expenditures of Federal Awards (the Schedule) for the period covered by the Academy’s financial statements which must include the total federal awards expended as determined in accordance with § 200.502. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the ALN number or other identifying number when the ALN information is not available. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502 Basis for determining Federal awards expended, paragraph (b), identify in the notes to the schedule the balances outstanding at the end of the audit period. (6) Include notes that describe the significant accounting policies used in preparing the schedule, and note whether or not the auditee has elected to use the 10 percent de minimis cost rate as covered in § 200.414 Indirect (F&A) costs. The Academy’s internal control procedures did not identify expenses sufficiently to identify the need for a Single Audit. The Schedule has been presented in this report. Noncompliance with grant requirements as well as errors and omissions on the Schedule could have an adverse effect on future grant awards by the awarding agencies in addition to an inaccurate assessment of major federal programs that would be subjected to audit.
2 CFR 200.501 requires a non-Federal entity that expends $750,000 or more during the non-Federal entity's fiscal year in Federal awards must have a single or program-specific audit conducted for that year in accordance with the provisions of this part. A non-Federal entity that expends $750,000 or more in Federal awards during the non-Federal entity's fiscal year must have a single audit conducted in accordance with § 200.514 except when it elects to have a program-specific audit conducted in accordance with paragraph (c) or (d) of this section. 2 CFR §200.512(a)(2) states that an audit, the data collection form, and the reporting package must be submitted within 30 calendar days after the auditee receives the auditor's report(s) or nine months after the end of the audit period (whichever is earlier). 2 CFR Subpart F §200.510(b) requires the auditee prepare a Schedule of Expenditures of Federal Awards (the Schedule) for the period covered by the Academy’s financial statements which must include the total federal awards expended as determined in accordance with § 200.502. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the ALN number or other identifying number when the ALN information is not available. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502 Basis for determining Federal awards expended, paragraph (b), identify in the notes to the schedule the balances outstanding at the end of the audit period. (6) Include notes that describe the significant accounting policies used in preparing the schedule, and note whether or not the auditee has elected to use the 10 percent de minimis cost rate as covered in § 200.414 Indirect (F&A) costs. The Academy’s internal control procedures did not identify expenses sufficiently to identify the need for a Single Audit. The Schedule has been presented in this report. Noncompliance with grant requirements as well as errors and omissions on the Schedule could have an adverse effect on future grant awards by the awarding agencies in addition to an inaccurate assessment of major federal programs that would be subjected to audit.
Finding 2023-004 - Accounting for Grants, Schedule of Expenditures of Federal Awards, and Fiscal Manage-ment (Material Weakness) CFDA Title and Number 84.425 Education Stabilization Fund Name of Federal Agency: U.S. Department of Education Criteria: CFR Part 200.508, CFR Part 200.510, Auditee Responsibilities state that the auditee must prepare the Schedule of Expenditures of Federal Awards, which must list individual Federal awards by Federal Agency, in-cluding the total Federal awards expended, name of the pass-through entity, CFDA number, and total amount pro-vided to subrecipients. The information contained in the Schedule of Expenditures of Federal Awards should be derived from and relate directly to the underlying accounting and other records used to prepare the financial state-ments. Condition: The Schedule of Expenditures of Federal Awards (SEFA) was presented for audit with values that were not reconciled with the general ledger. Cause: The District relied on individuals with insufficient training or support to prepare the SEFA and ensure that it was reconciled with general ledger amounts. District management did not have sufficient training or monitoring policies to recognize and correct the deficiency. Effect or Potential Effect: Errors in recording and reporting of revenues and expenditures of federal awards may not be detected and/or corrected. Because the Auditee’s SEFA that was presented for audit was completed incor-rectly, and not reconciled to the general ledger, the SEFA was materially misstated, prior to auditors’ correction recommendations. Questioned Cost: No Context: Lack of adequate controls over the Schedule of Expenditures of Federal Awards and related accounting resulted in the following: • SEFA was originally presented for auditors with incorrect information. • Inadequate reconciliation between federal expenditures reported on the GL and the SEFA was presented. Repeat of a Prior-Year Finding: No Recommendation: We recommend that the District establish policies and procedures to ensure that all Federal awards are identified and reported accurately on future SEFAs. Internal controls should be designed to prevent, detect, or correct errors in a timely manner by performing periodic reconciliations of the SEFA information to the general ledger throughout the fiscal year. The District should provide appropriate training to staff who are assigned to prepare and review the SEFA. District’s Response: The District acknowledges the deficiencies. Corrective Action Plan: The District will establish policies and procedures to ensure that all Federal awards are identified and reported accurately on future SEFAs. Planned Implementation Date: November 1, 2024 Responsible Person: District Business Manager
Finding 2023-004 - Accounting for Grants, Schedule of Expenditures of Federal Awards, and Fiscal Manage-ment (Material Weakness) CFDA Title and Number 84.425 Education Stabilization Fund Name of Federal Agency: U.S. Department of Education Criteria: CFR Part 200.508, CFR Part 200.510, Auditee Responsibilities state that the auditee must prepare the Schedule of Expenditures of Federal Awards, which must list individual Federal awards by Federal Agency, in-cluding the total Federal awards expended, name of the pass-through entity, CFDA number, and total amount pro-vided to subrecipients. The information contained in the Schedule of Expenditures of Federal Awards should be derived from and relate directly to the underlying accounting and other records used to prepare the financial state-ments. Condition: The Schedule of Expenditures of Federal Awards (SEFA) was presented for audit with values that were not reconciled with the general ledger. Cause: The District relied on individuals with insufficient training or support to prepare the SEFA and ensure that it was reconciled with general ledger amounts. District management did not have sufficient training or monitoring policies to recognize and correct the deficiency. Effect or Potential Effect: Errors in recording and reporting of revenues and expenditures of federal awards may not be detected and/or corrected. Because the Auditee’s SEFA that was presented for audit was completed incor-rectly, and not reconciled to the general ledger, the SEFA was materially misstated, prior to auditors’ correction recommendations. Questioned Cost: No Context: Lack of adequate controls over the Schedule of Expenditures of Federal Awards and related accounting resulted in the following: • SEFA was originally presented for auditors with incorrect information. • Inadequate reconciliation between federal expenditures reported on the GL and the SEFA was presented. Repeat of a Prior-Year Finding: No Recommendation: We recommend that the District establish policies and procedures to ensure that all Federal awards are identified and reported accurately on future SEFAs. Internal controls should be designed to prevent, detect, or correct errors in a timely manner by performing periodic reconciliations of the SEFA information to the general ledger throughout the fiscal year. The District should provide appropriate training to staff who are assigned to prepare and review the SEFA. District’s Response: The District acknowledges the deficiencies. Corrective Action Plan: The District will establish policies and procedures to ensure that all Federal awards are identified and reported accurately on future SEFAs. Planned Implementation Date: November 1, 2024 Responsible Person: District Business Manager
2 CFR 2900.4 gives regulatory effect to the Department of Labor for 2 CFR Subpart F § 200.510(b) which requires the auditee to prepare a Schedule of Expenditures of Federal Awards (the Schedule) for the period covered by the Consortium’s financial statements which must include the total federal awards expended as determined in accordance with § 200.502. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502 Basis for determining Federal awards expended, paragraph (b), identify in the notes to the schedule the balances outstanding at the end of the audit period. (6) Include notes that describe the significant accounting policies used in preparing the schedule, and note whether or not the auditee has elected to use the 10 percent de minimis cost rate as covered in § 200.414 Indirect (F&A) costs. The Consortium chose to report their Schedule of Federal Awards on a cash basis. The fiscal agent's accounting system operated on a full accrual basis and the federal schedule that was presented for audit was taken from the CFIS system for tracking federal expenditures for the Ohio Department of Job and Family Services. However, the Consortium was not able to provide support from the accounting system to reconcile the amounts reported on the Schedule to the accounting system. Due to the lack of support for the federal schedule, we were unable to ensure that activity upon which we based our testing of the compliance for major federal programs was complete and therefore we could not obtain the necessary assurances to form an opinion over the major federal programs’ compliance. Noncompliance with grant requirements as well as errors and omissions on the Schedule of Expenditures of Federal Awards could have an adverse effect on future grant awards by the awarding agency in addition to an inaccurate assessment of major federal programs that would be subjected to audit. Management should review all grant and loan award documents in order to execute policies and procedures which help ensure compliance with grant and loan requirements, including Schedule reporting requirements. The Consortium should implement a system to track all federal expenditures and related information separately from other expenditures and report federal expenditures with proper support including, but not limited to, grant agreements, calculation of the expenditures, and any federal reporting requirements. This will help ensure the Consortium is in compliance with grant and loan requirements, the Schedule is complete and accurate, and major federal programs are accurately identified for audit.
2 CFR 2900.4 gives regulatory effect to the Department of Labor for 2 CFR Subpart F § 200.510(b) which requires the auditee to prepare a Schedule of Expenditures of Federal Awards (the Schedule) for the period covered by the Consortium’s financial statements which must include the total federal awards expended as determined in accordance with § 200.502. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502 Basis for determining Federal awards expended, paragraph (b), identify in the notes to the schedule the balances outstanding at the end of the audit period. (6) Include notes that describe the significant accounting policies used in preparing the schedule, and note whether or not the auditee has elected to use the 10 percent de minimis cost rate as covered in § 200.414 Indirect (F&A) costs. The Consortium chose to report their Schedule of Federal Awards on a cash basis. The fiscal agent's accounting system operated on a full accrual basis and the federal schedule that was presented for audit was taken from the CFIS system for tracking federal expenditures for the Ohio Department of Job and Family Services. However, the Consortium was not able to provide support from the accounting system to reconcile the amounts reported on the Schedule to the accounting system. Due to the lack of support for the federal schedule, we were unable to ensure that activity upon which we based our testing of the compliance for major federal programs was complete and therefore we could not obtain the necessary assurances to form an opinion over the major federal programs’ compliance. Noncompliance with grant requirements as well as errors and omissions on the Schedule of Expenditures of Federal Awards could have an adverse effect on future grant awards by the awarding agency in addition to an inaccurate assessment of major federal programs that would be subjected to audit. Management should review all grant and loan award documents in order to execute policies and procedures which help ensure compliance with grant and loan requirements, including Schedule reporting requirements. The Consortium should implement a system to track all federal expenditures and related information separately from other expenditures and report federal expenditures with proper support including, but not limited to, grant agreements, calculation of the expenditures, and any federal reporting requirements. This will help ensure the Consortium is in compliance with grant and loan requirements, the Schedule is complete and accurate, and major federal programs are accurately identified for audit.
2 CFR 2900.4 gives regulatory effect to the Department of Labor for 2 CFR Subpart F § 200.510(b) which requires the auditee to prepare a Schedule of Expenditures of Federal Awards (the Schedule) for the period covered by the Consortium’s financial statements which must include the total federal awards expended as determined in accordance with § 200.502. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502 Basis for determining Federal awards expended, paragraph (b), identify in the notes to the schedule the balances outstanding at the end of the audit period. (6) Include notes that describe the significant accounting policies used in preparing the schedule, and note whether or not the auditee has elected to use the 10 percent de minimis cost rate as covered in § 200.414 Indirect (F&A) costs. The Consortium chose to report their Schedule of Federal Awards on a cash basis. The fiscal agent's accounting system operated on a full accrual basis and the federal schedule that was presented for audit was taken from the CFIS system for tracking federal expenditures for the Ohio Department of Job and Family Services. However, the Consortium was not able to provide support from the accounting system to reconcile the amounts reported on the Schedule to the accounting system. Due to the lack of support for the federal schedule, we were unable to ensure that activity upon which we based our testing of the compliance for major federal programs was complete and therefore we could not obtain the necessary assurances to form an opinion over the major federal programs’ compliance. Noncompliance with grant requirements as well as errors and omissions on the Schedule of Expenditures of Federal Awards could have an adverse effect on future grant awards by the awarding agency in addition to an inaccurate assessment of major federal programs that would be subjected to audit. Management should review all grant and loan award documents in order to execute policies and procedures which help ensure compliance with grant and loan requirements, including Schedule reporting requirements. The Consortium should implement a system to track all federal expenditures and related information separately from other expenditures and report federal expenditures with proper support including, but not limited to, grant agreements, calculation of the expenditures, and any federal reporting requirements. This will help ensure the Consortium is in compliance with grant and loan requirements, the Schedule is complete and accurate, and major federal programs are accurately identified for audit.
2 CFR 2900.4 gives regulatory effect to the Department of Labor for 2 CFR Subpart F § 200.510(b) which requires the auditee to prepare a Schedule of Expenditures of Federal Awards (the Schedule) for the period covered by the Consortium’s financial statements which must include the total federal awards expended as determined in accordance with § 200.502. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502 Basis for determining Federal awards expended, paragraph (b), identify in the notes to the schedule the balances outstanding at the end of the audit period. (6) Include notes that describe the significant accounting policies used in preparing the schedule, and note whether or not the auditee has elected to use the 10 percent de minimis cost rate as covered in § 200.414 Indirect (F&A) costs. The Consortium chose to report their Schedule of Federal Awards on a cash basis. The fiscal agent's accounting system operated on a full accrual basis and the federal schedule that was presented for audit was taken from the CFIS system for tracking federal expenditures for the Ohio Department of Job and Family Services. However, the Consortium was not able to provide support from the accounting system to reconcile the amounts reported on the Schedule to the accounting system. Due to the lack of support for the federal schedule, we were unable to ensure that activity upon which we based our testing of the compliance for major federal programs was complete and therefore we could not obtain the necessary assurances to form an opinion over the major federal programs’ compliance. Noncompliance with grant requirements as well as errors and omissions on the Schedule of Expenditures of Federal Awards could have an adverse effect on future grant awards by the awarding agency in addition to an inaccurate assessment of major federal programs that would be subjected to audit. Management should review all grant and loan award documents in order to execute policies and procedures which help ensure compliance with grant and loan requirements, including Schedule reporting requirements. The Consortium should implement a system to track all federal expenditures and related information separately from other expenditures and report federal expenditures with proper support including, but not limited to, grant agreements, calculation of the expenditures, and any federal reporting requirements. This will help ensure the Consortium is in compliance with grant and loan requirements, the Schedule is complete and accurate, and major federal programs are accurately identified for audit.
2 CFR 2900.4 gives regulatory effect to the Department of Labor for 2 CFR Subpart F § 200.510(b) which requires the auditee to prepare a Schedule of Expenditures of Federal Awards (the Schedule) for the period covered by the Consortium’s financial statements which must include the total federal awards expended as determined in accordance with § 200.502. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502 Basis for determining Federal awards expended, paragraph (b), identify in the notes to the schedule the balances outstanding at the end of the audit period. (6) Include notes that describe the significant accounting policies used in preparing the schedule, and note whether or not the auditee has elected to use the 10 percent de minimis cost rate as covered in § 200.414 Indirect (F&A) costs. The Consortium chose to report their Schedule of Federal Awards on a cash basis. The fiscal agent's accounting system operated on a full accrual basis and the federal schedule that was presented for audit was taken from the CFIS system for tracking federal expenditures for the Ohio Department of Job and Family Services. However, the Consortium was not able to provide support from the accounting system to reconcile the amounts reported on the Schedule to the accounting system. Due to the lack of support for the federal schedule, we were unable to ensure that activity upon which we based our testing of the compliance for major federal programs was complete and therefore we could not obtain the necessary assurances to form an opinion over the major federal programs’ compliance. Noncompliance with grant requirements as well as errors and omissions on the Schedule of Expenditures of Federal Awards could have an adverse effect on future grant awards by the awarding agency in addition to an inaccurate assessment of major federal programs that would be subjected to audit. Management should review all grant and loan award documents in order to execute policies and procedures which help ensure compliance with grant and loan requirements, including Schedule reporting requirements. The Consortium should implement a system to track all federal expenditures and related information separately from other expenditures and report federal expenditures with proper support including, but not limited to, grant agreements, calculation of the expenditures, and any federal reporting requirements. This will help ensure the Consortium is in compliance with grant and loan requirements, the Schedule is complete and accurate, and major federal programs are accurately identified for audit.
2 CFR 2900.4 gives regulatory effect to the Department of Labor for 2 CFR Subpart F § 200.510(b) which requires the auditee to prepare a Schedule of Expenditures of Federal Awards (the Schedule) for the period covered by the Consortium’s financial statements which must include the total federal awards expended as determined in accordance with § 200.502. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502 Basis for determining Federal awards expended, paragraph (b), identify in the notes to the schedule the balances outstanding at the end of the audit period. (6) Include notes that describe the significant accounting policies used in preparing the schedule, and note whether or not the auditee has elected to use the 10 percent de minimis cost rate as covered in § 200.414 Indirect (F&A) costs. The Consortium chose to report their Schedule of Federal Awards on a cash basis. The fiscal agent's accounting system operated on a full accrual basis and the federal schedule that was presented for audit was taken from the CFIS system for tracking federal expenditures for the Ohio Department of Job and Family Services. However, the Consortium was not able to provide support from the accounting system to reconcile the amounts reported on the Schedule to the accounting system. Due to the lack of support for the federal schedule, we were unable to ensure that activity upon which we based our testing of the compliance for major federal programs was complete and therefore we could not obtain the necessary assurances to form an opinion over the major federal programs’ compliance. Noncompliance with grant requirements as well as errors and omissions on the Schedule of Expenditures of Federal Awards could have an adverse effect on future grant awards by the awarding agency in addition to an inaccurate assessment of major federal programs that would be subjected to audit. Management should review all grant and loan award documents in order to execute policies and procedures which help ensure compliance with grant and loan requirements, including Schedule reporting requirements. The Consortium should implement a system to track all federal expenditures and related information separately from other expenditures and report federal expenditures with proper support including, but not limited to, grant agreements, calculation of the expenditures, and any federal reporting requirements. This will help ensure the Consortium is in compliance with grant and loan requirements, the Schedule is complete and accurate, and major federal programs are accurately identified for audit.
Federal Program Child Nutrition Cluster - Passed through the Pennsylvania Department of Education and Pennsylvania Department of Agriculture ALNs 10.555 and 10.553 Education Stabilization Fund - Passed through the Pennsylvania Department of Education ALN 84.425 Criteria Per the Uniform Guidance 2 CFR 200.510, the auditee is required to prepare a schedule of expenditures of federal awards (SEFA). Condition The District prepared a SEFA and provided information relating to the federal programs including grant agreements and other supporting documentation. However, the SEFA prepared by the auditee required material adjustments as a result of audit procedures. Cause Certain account reconciliations were not performed prior to the audit, which impacted amounts reported on the SEFA. Effect Amounts reported on the SEFA provided by the auditee were not accurate. The SEFA was subsequently updated through audit procedures, including inquiry and review of grant documentation of awards received and amounts expended. Questioned Costs None. Context A SEFA was prepared by management; however, several adjustments were required in order for the schedule to accurately reflect the current year activity. Repeat Finding Yes. See finding 2022-003. Recommendation In order to meet Uniform Guidance requirements, the District should prepare the SEFA from the grant award documentation and any other relevant information including the assistance listing numbers, grant award amounts, grant amounts received, grant amounts expended, and grant revenue recorded. The amounts reported in the SEFA should reconcile to the general ledger. Management Response See corrective action plan included in this report package.
Federal Program Child Nutrition Cluster - Passed through the Pennsylvania Department of Education and Pennsylvania Department of Agriculture ALNs 10.555 and 10.553 Education Stabilization Fund - Passed through the Pennsylvania Department of Education ALN 84.425 Criteria Per the Uniform Guidance 2 CFR 200.510, the auditee is required to prepare a schedule of expenditures of federal awards (SEFA). Condition The District prepared a SEFA and provided information relating to the federal programs including grant agreements and other supporting documentation. However, the SEFA prepared by the auditee required material adjustments as a result of audit procedures. Cause Certain account reconciliations were not performed prior to the audit, which impacted amounts reported on the SEFA. Effect Amounts reported on the SEFA provided by the auditee were not accurate. The SEFA was subsequently updated through audit procedures, including inquiry and review of grant documentation of awards received and amounts expended. Questioned Costs None. Context A SEFA was prepared by management; however, several adjustments were required in order for the schedule to accurately reflect the current year activity. Repeat Finding Yes. See finding 2022-003. Recommendation In order to meet Uniform Guidance requirements, the District should prepare the SEFA from the grant award documentation and any other relevant information including the assistance listing numbers, grant award amounts, grant amounts received, grant amounts expended, and grant revenue recorded. The amounts reported in the SEFA should reconcile to the general ledger. Management Response See corrective action plan included in this report package.
Federal Program Child Nutrition Cluster - Passed through the Pennsylvania Department of Education and Pennsylvania Department of Agriculture ALNs 10.555 and 10.553 Education Stabilization Fund - Passed through the Pennsylvania Department of Education ALN 84.425 Criteria Per the Uniform Guidance 2 CFR 200.510, the auditee is required to prepare a schedule of expenditures of federal awards (SEFA). Condition The District prepared a SEFA and provided information relating to the federal programs including grant agreements and other supporting documentation. However, the SEFA prepared by the auditee required material adjustments as a result of audit procedures. Cause Certain account reconciliations were not performed prior to the audit, which impacted amounts reported on the SEFA. Effect Amounts reported on the SEFA provided by the auditee were not accurate. The SEFA was subsequently updated through audit procedures, including inquiry and review of grant documentation of awards received and amounts expended. Questioned Costs None. Context A SEFA was prepared by management; however, several adjustments were required in order for the schedule to accurately reflect the current year activity. Repeat Finding Yes. See finding 2022-003. Recommendation In order to meet Uniform Guidance requirements, the District should prepare the SEFA from the grant award documentation and any other relevant information including the assistance listing numbers, grant award amounts, grant amounts received, grant amounts expended, and grant revenue recorded. The amounts reported in the SEFA should reconcile to the general ledger. Management Response See corrective action plan included in this report package.
Federal Program Child Nutrition Cluster - Passed through the Pennsylvania Department of Education and Pennsylvania Department of Agriculture ALNs 10.555 and 10.553 Education Stabilization Fund - Passed through the Pennsylvania Department of Education ALN 84.425 Criteria Per the Uniform Guidance 2 CFR 200.510, the auditee is required to prepare a schedule of expenditures of federal awards (SEFA). Condition The District prepared a SEFA and provided information relating to the federal programs including grant agreements and other supporting documentation. However, the SEFA prepared by the auditee required material adjustments as a result of audit procedures. Cause Certain account reconciliations were not performed prior to the audit, which impacted amounts reported on the SEFA. Effect Amounts reported on the SEFA provided by the auditee were not accurate. The SEFA was subsequently updated through audit procedures, including inquiry and review of grant documentation of awards received and amounts expended. Questioned Costs None. Context A SEFA was prepared by management; however, several adjustments were required in order for the schedule to accurately reflect the current year activity. Repeat Finding Yes. See finding 2022-003. Recommendation In order to meet Uniform Guidance requirements, the District should prepare the SEFA from the grant award documentation and any other relevant information including the assistance listing numbers, grant award amounts, grant amounts received, grant amounts expended, and grant revenue recorded. The amounts reported in the SEFA should reconcile to the general ledger. Management Response See corrective action plan included in this report package.
Federal Program Child Nutrition Cluster - Passed through the Pennsylvania Department of Education and Pennsylvania Department of Agriculture ALNs 10.555 and 10.553 Education Stabilization Fund - Passed through the Pennsylvania Department of Education ALN 84.425 Criteria Per the Uniform Guidance 2 CFR 200.510, the auditee is required to prepare a schedule of expenditures of federal awards (SEFA). Condition The District prepared a SEFA and provided information relating to the federal programs including grant agreements and other supporting documentation. However, the SEFA prepared by the auditee required material adjustments as a result of audit procedures. Cause Certain account reconciliations were not performed prior to the audit, which impacted amounts reported on the SEFA. Effect Amounts reported on the SEFA provided by the auditee were not accurate. The SEFA was subsequently updated through audit procedures, including inquiry and review of grant documentation of awards received and amounts expended. Questioned Costs None. Context A SEFA was prepared by management; however, several adjustments were required in order for the schedule to accurately reflect the current year activity. Repeat Finding Yes. See finding 2022-003. Recommendation In order to meet Uniform Guidance requirements, the District should prepare the SEFA from the grant award documentation and any other relevant information including the assistance listing numbers, grant award amounts, grant amounts received, grant amounts expended, and grant revenue recorded. The amounts reported in the SEFA should reconcile to the general ledger. Management Response See corrective action plan included in this report package.
2023-001 Program: Highway Planning and Construction Federal Financial Assistance Listing No.: 20.205 Federal Agency: U.S. Department of Transportation Pass-through: Metropolitan Transportation Commission Award Year: 2023 Grant Award Number: MTC/STP Agreement Compliance Requirements: Other - Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) §200.510(b) - Schedule of expenditures of Federal awards Type of Finding: Material Weakness in Internal Control over Compliance Criteria: Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) §200.510(b) states that the auditee (VTA) must prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the auditee’s financial statements, which must include the total federal awards expended as determined in accordance with §200.502. Condition: During our audit procedures performed over the Schedule of Expenditures of Federal Awards, VTA listed a Highway Planning and Construction grant for $3,164,846 within the Federal Transit Formula grant with Assistance Listing Number 20.507 in error. Based on the information from VTA's Project Management, this program should have been reported as part of the Highway Planning and Construction under Assistance Listing Number 20.205. Cause: The Assistance Listing Number was not communicated timely to the unit preparing the Schedule. Effect: The Highway Planning and Construction amount reported on the Schedule of Expenditures of Federal Awards was understated by $3,164,846 which required performing an audit of the program and reissuance of the Single Audit Report because the program is now considered a major federal program. Questioned Costs: No questioned costs were identified as a result of our procedures. Context/Sampling: No sampling was used. Program expenditures on the Schedule of Expenditures of Federal Awards were reconciled to supporting records. Repeat Finding from the Prior Year(s): No. Recommendation: VTA should establish policies and implement internal controls to ensure all federal expenditures are accurately identified on the Schedule of Expenditures of Federal Awards. View of Responsible Official and Planned Corrective Actions See separate corrective action plan.
2023-001 Program: Highway Planning and Construction Federal Financial Assistance Listing No.: 20.205 Federal Agency: U.S. Department of Transportation Pass-through: Metropolitan Transportation Commission Award Year: 2023 Grant Award Number: MTC/STP Agreement Compliance Requirements: Other - Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) §200.510(b) - Schedule of expenditures of Federal awards Type of Finding: Material Weakness in Internal Control over Compliance Criteria: Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) §200.510(b) states that the auditee (VTA) must prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the auditee’s financial statements, which must include the total federal awards expended as determined in accordance with §200.502. Condition: During our audit procedures performed over the Schedule of Expenditures of Federal Awards, VTA listed a Highway Planning and Construction grant for $3,164,846 within the Federal Transit Formula grant with Assistance Listing Number 20.507 in error. Based on the information from VTA's Project Management, this program should have been reported as part of the Highway Planning and Construction under Assistance Listing Number 20.205. Cause: The Assistance Listing Number was not communicated timely to the unit preparing the Schedule. Effect: The Highway Planning and Construction amount reported on the Schedule of Expenditures of Federal Awards was understated by $3,164,846 which required performing an audit of the program and reissuance of the Single Audit Report because the program is now considered a major federal program. Questioned Costs: No questioned costs were identified as a result of our procedures. Context/Sampling: No sampling was used. Program expenditures on the Schedule of Expenditures of Federal Awards were reconciled to supporting records. Repeat Finding from the Prior Year(s): No. Recommendation: VTA should establish policies and implement internal controls to ensure all federal expenditures are accurately identified on the Schedule of Expenditures of Federal Awards. View of Responsible Official and Planned Corrective Actions See separate corrective action plan.
2023-001 Program: Highway Planning and Construction Federal Financial Assistance Listing No.: 20.205 Federal Agency: U.S. Department of Transportation Pass-through: Metropolitan Transportation Commission Award Year: 2023 Grant Award Number: MTC/STP Agreement Compliance Requirements: Other - Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) §200.510(b) - Schedule of expenditures of Federal awards Type of Finding: Material Weakness in Internal Control over Compliance Criteria: Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) §200.510(b) states that the auditee (VTA) must prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the auditee’s financial statements, which must include the total federal awards expended as determined in accordance with §200.502. Condition: During our audit procedures performed over the Schedule of Expenditures of Federal Awards, VTA listed a Highway Planning and Construction grant for $3,164,846 within the Federal Transit Formula grant with Assistance Listing Number 20.507 in error. Based on the information from VTA's Project Management, this program should have been reported as part of the Highway Planning and Construction under Assistance Listing Number 20.205. Cause: The Assistance Listing Number was not communicated timely to the unit preparing the Schedule. Effect: The Highway Planning and Construction amount reported on the Schedule of Expenditures of Federal Awards was understated by $3,164,846 which required performing an audit of the program and reissuance of the Single Audit Report because the program is now considered a major federal program. Questioned Costs: No questioned costs were identified as a result of our procedures. Context/Sampling: No sampling was used. Program expenditures on the Schedule of Expenditures of Federal Awards were reconciled to supporting records. Repeat Finding from the Prior Year(s): No. Recommendation: VTA should establish policies and implement internal controls to ensure all federal expenditures are accurately identified on the Schedule of Expenditures of Federal Awards. View of Responsible Official and Planned Corrective Actions See separate corrective action plan.
Criteria: According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the entity’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2 CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designated to reasonably ensure compliance with Federal laws, regulations and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately and completely reported on the SEFA. Condition and Context: Confition and Context: The University did not have adequate controls relating to the reporting of expenditures on the SEFA for the Supplemental Nutrition Assistance Program Cluster (SNAP). Both the College of Continuing Education (CCE) and the Population Research Center (PRC) which is part of the Sacramento campus incurred SNAP expenditures that were not reported on the fiscal year 2023 SEFA. The SNAP agreement was entered into between the California Department of Social Services and California State University-Sacramento on behalf of CCE. PRC was listed as a sub awardee within the SNAP agreement. Written policies and procedures require each unit/department within the Sacramento campus to send all external grants and contracts to the Sacramento campus Office of Research, Innovation and Economic Development (ORIED). ORIED performs a review of each applicable agreement received to determine that separate general ledger accounts have been established and whether the funding source has been accurately identified in the general ledger (i.e. federal). The CCE did not send the SNAP contract to ORIED and as a result, the review control did not operate as designed. Separate accounts, to track federal funding, were not established in the general ledger and instead, SNAP activity was accounted for within the tuition and fees general ledger accounts which resulted in SNAP activity being managed via manual spreadsheets. While performing budget control reviews during the year ended June 30, 2024, the CCE determined that certain SNAP expenditures had not been reported on the fiscal year 2023 SEFA. The University’s overall SEFA is compiled by the Chancellor’s office and relies on each campus to have internal controls that ensure completeness and accuracy of the SEFA. Cause & Effect: In discussing these conditions with the University, they stated the error was primarily due to significant turnover during fiscal year 2023 in the CCE and as a result the required policies and procedures for identifying, tracking, and communicating federal expenditures were not adhered to. Additionally, management review controls at the campus over the completeness and accuracy of the SEFA were not designed to detect the error. Failure to establish effective internal controls regarding financial reporting for the preparation of the SEFA may prevent the University from completing an audit in accordance with the timelines of Uniform Guidance.
Condition: For the fiscal year ended June 30, 2023, we requested that Day One prepare and send us a Schedule of Expenditures of Federal Awards. Requested that the expenditures reported in the SEFA be reconciled to Day One’s accounting records. We reviewed the SEFA and compared them to the accounting records; we noted that the expenditures reported were inaccurate. Criteria: Recipients of federal awards are subject to requirements documented in section of the Uniform Guidance Sections 200.510, 200.502, and 200.302. The criteria for each are as follows: § 200.510 Financial statements (b) Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with § 200.502.” § 200.502 Basis for determining Federal awards expended (a) Determining Federal awards expended. The determination of when a federal award is expended must be based on when the activity related to the Federal award occurs. Generally, the activity pertains to events that require the non-Federal entity to comply with Federal statutes, regulations, and the terms and conditions of Federal awards, such as: expenditure/expense transactions associated with awards including grants, cost-reimbursement contracts under the FAR, compacts with Indian Tribes, cooperative agreements, and direct appropriations; the disbursement of funds to subrecipients; the use of loan proceeds under loan and loan guarantee programs; the receipt of property; the receipt of surplus property; the receipt or use of program income; the distribution or use of food commodities; the disbursement of amounts entitling the non-Federal entity to an interest subsidy; and the period when insurance is in force.§ 200.302 Financial management (a) Each state must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state's own funds. In addition, the state's and the other non-Federal entity's financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. The financial management system of each non-Federal entity must provide for (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements…..” Questioned Costs: None Cause: The Organization has not implemented policies and procedures requiring that the Schedule of Federal Awards to complete and accurate. Effect and Context: The Organization reported expenditures that exceeded $750,000 for 2022. In determining the major program to be audited for 2022, the auditor could not rely on the SEFA provided because the SEFA was not complete and expenditures reported were inaccurate. Which could have lead to an inaccurate reporting of federal expenditures for the Organization for 2022. Recommendation: We recommend that management implement policies and procedures requiring all federal expenditures be accurately reported in the year end Schedule of Federal Awards. Management’s Response and Corrective Action Plan: See management’s responses documented on page 46-47.
Condition: For the fiscal year ended June 30, 2023, we requested that Day One prepare and send us a Schedule of Expenditures of Federal Awards. Requested that the expenditures reported in the SEFA be reconciled to Day One’s accounting records. We reviewed the SEFA and compared them to the accounting records; we noted that the expenditures reported were inaccurate. Criteria: Recipients of federal awards are subject to requirements documented in section of the Uniform Guidance Sections 200.510, 200.502, and 200.302. The criteria for each are as follows: § 200.510 Financial statements (b) Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with § 200.502.” § 200.502 Basis for determining Federal awards expended (a) Determining Federal awards expended. The determination of when a federal award is expended must be based on when the activity related to the Federal award occurs. Generally, the activity pertains to events that require the non-Federal entity to comply with Federal statutes, regulations, and the terms and conditions of Federal awards, such as: expenditure/expense transactions associated with awards including grants, cost-reimbursement contracts under the FAR, compacts with Indian Tribes, cooperative agreements, and direct appropriations; the disbursement of funds to subrecipients; the use of loan proceeds under loan and loan guarantee programs; the receipt of property; the receipt of surplus property; the receipt or use of program income; the distribution or use of food commodities; the disbursement of amounts entitling the non-Federal entity to an interest subsidy; and the period when insurance is in force.§ 200.302 Financial management (a) Each state must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state's own funds. In addition, the state's and the other non-Federal entity's financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. The financial management system of each non-Federal entity must provide for (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements…..” Questioned Costs: None Cause: The Organization has not implemented policies and procedures requiring that the Schedule of Federal Awards to complete and accurate. Effect and Context: The Organization reported expenditures that exceeded $750,000 for 2022. In determining the major program to be audited for 2022, the auditor could not rely on the SEFA provided because the SEFA was not complete and expenditures reported were inaccurate. Which could have lead to an inaccurate reporting of federal expenditures for the Organization for 2022. Recommendation: We recommend that management implement policies and procedures requiring all federal expenditures be accurately reported in the year end Schedule of Federal Awards. Management’s Response and Corrective Action Plan: See management’s responses documented on page 46-47.
Assistance Listing Numbers: 20.500 Capital Investment Grants (Fixed Guideway Capital Investment Grants), 20.507 Federal Transit – Formula Grants (Urbanized Area Formula), 20.525 State of Good Repair Grants, 20.505 Metropolitan Transportation Planning Grants, and 20.513 Enhanced Mobility of Seniors and Individuals with Disabilities Federal Agency – Department of Transportation Finding Type: Significant Deficiency and Non-Compliance Condition During the audit, it was found that the auditee incorrectly classified the following: • Assistance Listing Number 20.500 Capital Investment Grants (Fixed Guideway Capital Investment Grants) – Management reported $2,455,795 as federal awards expended instead of $1,589,748, which were the amounts validated by the auditors. • Assistance Listing Number 20.507 Federal Transit – Formula Grants (Urbanized Area Formula) – Management reported $25,222,452 as federal awards expended instead of $21,372,923, which were the amounts validated by the auditors. • Assistance Listing Number 20.525 State of Good Repair Grants – Management did not report federal awards expended instead of $4,715,576, which was the amount validated by the auditors. • Assistance Listing Number 20.505 Metropolitan Transportation Planning Grants – Management reported $2,279,469 as federal awards expended instead of $2,210,082, which were the amounts validated by the auditors. • Assistance Listing Number 20.513 Enhanced Mobility of Seniors and Individuals with Disabilities – Management reported $15,848.93 as federal awards expended instead of $14,912.93, which were the amounts validated by the auditors. Criteria Under 2 CFR 200.510(b), auditees are required to prepare a Schedule of Expenditures of Federal Awards (SEFA) and must include accurate information about expenditures for each federal program, including the correct Assistance Listing number. In addition, the auditee must provide total Federal awards expended for each individual Federal program and the Assistance Listings Number or other identifying number when the Assistance Listings information is not available. Cause The misclassification appears to have resulted from a misunderstanding of the program guidelines and a lack of adequate internal controls to ensure the accurate reporting of federal expenditures. Effect This misclassification could result in noncompliance with federal regulations and may impact the federal agency's ability to accurately monitor and allocate funding. Furthermore, it may lead to incorrect conclusions about the auditee's compliance with specific program requirements. Questioned Costs None Recommendation It is recommended that the auditee: • Review and revise its procedures for classifying federal expenditures to ensure accurate alignment with assistance listing numbers. • Implement additional training for staff responsible for preparing the SEFA. • Conduct a thorough review of all federal program expenditures for the current and previous years to identify and correct any similar misclassifications.
Assistance Listing Numbers: 20.500 Capital Investment Grants (Fixed Guideway Capital Investment Grants), 20.507 Federal Transit – Formula Grants (Urbanized Area Formula), 20.525 State of Good Repair Grants, 20.505 Metropolitan Transportation Planning Grants, and 20.513 Enhanced Mobility of Seniors and Individuals with Disabilities Federal Agency – Department of Transportation Finding Type: Significant Deficiency and Non-Compliance Condition During the audit, it was found that the auditee incorrectly classified the following: • Assistance Listing Number 20.500 Capital Investment Grants (Fixed Guideway Capital Investment Grants) – Management reported $2,455,795 as federal awards expended instead of $1,589,748, which were the amounts validated by the auditors. • Assistance Listing Number 20.507 Federal Transit – Formula Grants (Urbanized Area Formula) – Management reported $25,222,452 as federal awards expended instead of $21,372,923, which were the amounts validated by the auditors. • Assistance Listing Number 20.525 State of Good Repair Grants – Management did not report federal awards expended instead of $4,715,576, which was the amount validated by the auditors. • Assistance Listing Number 20.505 Metropolitan Transportation Planning Grants – Management reported $2,279,469 as federal awards expended instead of $2,210,082, which were the amounts validated by the auditors. • Assistance Listing Number 20.513 Enhanced Mobility of Seniors and Individuals with Disabilities – Management reported $15,848.93 as federal awards expended instead of $14,912.93, which were the amounts validated by the auditors. Criteria Under 2 CFR 200.510(b), auditees are required to prepare a Schedule of Expenditures of Federal Awards (SEFA) and must include accurate information about expenditures for each federal program, including the correct Assistance Listing number. In addition, the auditee must provide total Federal awards expended for each individual Federal program and the Assistance Listings Number or other identifying number when the Assistance Listings information is not available. Cause The misclassification appears to have resulted from a misunderstanding of the program guidelines and a lack of adequate internal controls to ensure the accurate reporting of federal expenditures. Effect This misclassification could result in noncompliance with federal regulations and may impact the federal agency's ability to accurately monitor and allocate funding. Furthermore, it may lead to incorrect conclusions about the auditee's compliance with specific program requirements. Questioned Costs None Recommendation It is recommended that the auditee: • Review and revise its procedures for classifying federal expenditures to ensure accurate alignment with assistance listing numbers. • Implement additional training for staff responsible for preparing the SEFA. • Conduct a thorough review of all federal program expenditures for the current and previous years to identify and correct any similar misclassifications.
Assistance Listing Numbers: 20.500 Capital Investment Grants (Fixed Guideway Capital Investment Grants), 20.507 Federal Transit – Formula Grants (Urbanized Area Formula), 20.525 State of Good Repair Grants, 20.505 Metropolitan Transportation Planning Grants, and 20.513 Enhanced Mobility of Seniors and Individuals with Disabilities Federal Agency – Department of Transportation Finding Type: Significant Deficiency and Non-Compliance Condition During the audit, it was found that the auditee incorrectly classified the following: • Assistance Listing Number 20.500 Capital Investment Grants (Fixed Guideway Capital Investment Grants) – Management reported $2,455,795 as federal awards expended instead of $1,589,748, which were the amounts validated by the auditors. • Assistance Listing Number 20.507 Federal Transit – Formula Grants (Urbanized Area Formula) – Management reported $25,222,452 as federal awards expended instead of $21,372,923, which were the amounts validated by the auditors. • Assistance Listing Number 20.525 State of Good Repair Grants – Management did not report federal awards expended instead of $4,715,576, which was the amount validated by the auditors. • Assistance Listing Number 20.505 Metropolitan Transportation Planning Grants – Management reported $2,279,469 as federal awards expended instead of $2,210,082, which were the amounts validated by the auditors. • Assistance Listing Number 20.513 Enhanced Mobility of Seniors and Individuals with Disabilities – Management reported $15,848.93 as federal awards expended instead of $14,912.93, which were the amounts validated by the auditors. Criteria Under 2 CFR 200.510(b), auditees are required to prepare a Schedule of Expenditures of Federal Awards (SEFA) and must include accurate information about expenditures for each federal program, including the correct Assistance Listing number. In addition, the auditee must provide total Federal awards expended for each individual Federal program and the Assistance Listings Number or other identifying number when the Assistance Listings information is not available. Cause The misclassification appears to have resulted from a misunderstanding of the program guidelines and a lack of adequate internal controls to ensure the accurate reporting of federal expenditures. Effect This misclassification could result in noncompliance with federal regulations and may impact the federal agency's ability to accurately monitor and allocate funding. Furthermore, it may lead to incorrect conclusions about the auditee's compliance with specific program requirements. Questioned Costs None Recommendation It is recommended that the auditee: • Review and revise its procedures for classifying federal expenditures to ensure accurate alignment with assistance listing numbers. • Implement additional training for staff responsible for preparing the SEFA. • Conduct a thorough review of all federal program expenditures for the current and previous years to identify and correct any similar misclassifications.
Assistance Listing Numbers: 20.500 Capital Investment Grants (Fixed Guideway Capital Investment Grants), 20.507 Federal Transit – Formula Grants (Urbanized Area Formula), 20.525 State of Good Repair Grants, 20.505 Metropolitan Transportation Planning Grants, and 20.513 Enhanced Mobility of Seniors and Individuals with Disabilities Federal Agency – Department of Transportation Finding Type: Significant Deficiency and Non-Compliance Condition During the audit, it was found that the auditee incorrectly classified the following: • Assistance Listing Number 20.500 Capital Investment Grants (Fixed Guideway Capital Investment Grants) – Management reported $2,455,795 as federal awards expended instead of $1,589,748, which were the amounts validated by the auditors. • Assistance Listing Number 20.507 Federal Transit – Formula Grants (Urbanized Area Formula) – Management reported $25,222,452 as federal awards expended instead of $21,372,923, which were the amounts validated by the auditors. • Assistance Listing Number 20.525 State of Good Repair Grants – Management did not report federal awards expended instead of $4,715,576, which was the amount validated by the auditors. • Assistance Listing Number 20.505 Metropolitan Transportation Planning Grants – Management reported $2,279,469 as federal awards expended instead of $2,210,082, which were the amounts validated by the auditors. • Assistance Listing Number 20.513 Enhanced Mobility of Seniors and Individuals with Disabilities – Management reported $15,848.93 as federal awards expended instead of $14,912.93, which were the amounts validated by the auditors. Criteria Under 2 CFR 200.510(b), auditees are required to prepare a Schedule of Expenditures of Federal Awards (SEFA) and must include accurate information about expenditures for each federal program, including the correct Assistance Listing number. In addition, the auditee must provide total Federal awards expended for each individual Federal program and the Assistance Listings Number or other identifying number when the Assistance Listings information is not available. Cause The misclassification appears to have resulted from a misunderstanding of the program guidelines and a lack of adequate internal controls to ensure the accurate reporting of federal expenditures. Effect This misclassification could result in noncompliance with federal regulations and may impact the federal agency's ability to accurately monitor and allocate funding. Furthermore, it may lead to incorrect conclusions about the auditee's compliance with specific program requirements. Questioned Costs None Recommendation It is recommended that the auditee: • Review and revise its procedures for classifying federal expenditures to ensure accurate alignment with assistance listing numbers. • Implement additional training for staff responsible for preparing the SEFA. • Conduct a thorough review of all federal program expenditures for the current and previous years to identify and correct any similar misclassifications.
Assistance Listing Numbers: 20.500 Capital Investment Grants (Fixed Guideway Capital Investment Grants), 20.507 Federal Transit – Formula Grants (Urbanized Area Formula), 20.525 State of Good Repair Grants, 20.505 Metropolitan Transportation Planning Grants, and 20.513 Enhanced Mobility of Seniors and Individuals with Disabilities Federal Agency – Department of Transportation Finding Type: Significant Deficiency and Non-Compliance Condition During the audit, it was found that the auditee incorrectly classified the following: • Assistance Listing Number 20.500 Capital Investment Grants (Fixed Guideway Capital Investment Grants) – Management reported $2,455,795 as federal awards expended instead of $1,589,748, which were the amounts validated by the auditors. • Assistance Listing Number 20.507 Federal Transit – Formula Grants (Urbanized Area Formula) – Management reported $25,222,452 as federal awards expended instead of $21,372,923, which were the amounts validated by the auditors. • Assistance Listing Number 20.525 State of Good Repair Grants – Management did not report federal awards expended instead of $4,715,576, which was the amount validated by the auditors. • Assistance Listing Number 20.505 Metropolitan Transportation Planning Grants – Management reported $2,279,469 as federal awards expended instead of $2,210,082, which were the amounts validated by the auditors. • Assistance Listing Number 20.513 Enhanced Mobility of Seniors and Individuals with Disabilities – Management reported $15,848.93 as federal awards expended instead of $14,912.93, which were the amounts validated by the auditors. Criteria Under 2 CFR 200.510(b), auditees are required to prepare a Schedule of Expenditures of Federal Awards (SEFA) and must include accurate information about expenditures for each federal program, including the correct Assistance Listing number. In addition, the auditee must provide total Federal awards expended for each individual Federal program and the Assistance Listings Number or other identifying number when the Assistance Listings information is not available. Cause The misclassification appears to have resulted from a misunderstanding of the program guidelines and a lack of adequate internal controls to ensure the accurate reporting of federal expenditures. Effect This misclassification could result in noncompliance with federal regulations and may impact the federal agency's ability to accurately monitor and allocate funding. Furthermore, it may lead to incorrect conclusions about the auditee's compliance with specific program requirements. Questioned Costs None Recommendation It is recommended that the auditee: • Review and revise its procedures for classifying federal expenditures to ensure accurate alignment with assistance listing numbers. • Implement additional training for staff responsible for preparing the SEFA. • Conduct a thorough review of all federal program expenditures for the current and previous years to identify and correct any similar misclassifications.
Finding 2023-003 - Material Weakness in Internal Control over Compliance and Material Noncompliance (Qualified Opinion) - Inadequate Tracking of Expenditures and Retention of Documentation: Activities Allowed or Unallowed: Allowable Costs/Cost Principles and Reporting (A/B/L) for Assistance Listing Number 19.510 and 93.567 Criteria: The Code of Federal Regulations (CFR) Section 200.510(b) states in part, “The auditee must also prepare a schedule of federal expenditures for the period covered by the auditee’s consolidated financial statements which must include the total Federal awards expended as determined in accordance with 200.502.” Also, in accordance with CFR Section 200.302(b) - Financial Management, the auditees financial management system must provide 1) identification of all federal awards received and expended; 2) accurate, current, and complete disclosure of the financial results of each federal award or program; 3) records that identify adequately the source and application of funds for federally‐funded activities; 4) effective control over, and accountability for, all funds, property, and other assets; 5) comparison of expenditures with budget amounts for each Federal award; 6) written procedures to implement the requirements of section 200.305 and; 7) written procedures for determining the allowability of costs in accordance with Subpart E and the terms and conditions of the Federal award. Recipients of federal awards must submit accurate, complete and timely financial and performance reports. The Organization should have internal controls designed to ensure compliance with those provisions. The Organization should retain sufficient documentation such as invoice and allocation support for expenditures to retain documentation for audit purposes. Condition: During detail testing of expenditures, it was noted that the Organization did not maintain adequate documentation to support how certain costs were allocated to the federal program. Several transactions lacked sufficient detail, such as invoice or expense reimbursement form. Several expenditures selected for testing did not obtain sufficient approval by an individual at the Organization. It was noted that quarterly reports provided to the federal program were not reviewed by an individual at the Organization prior to submission to ensure accurate report of expenditures. Cause: The Organization does not have an adequate system in place to ensure quarterly reports have sufficient supporting documentation, proper approval/review, and accurate reporting prior to submission. Responsibilities for expenditure tracking were not clearly assigned, and there was no formal review process in place. The Organization is not following their Document Retention Policy. Effect: The effect of this condition increases the possibility that quarterly financial reports are misstated or inaccurate and increase the risk of noncompliance with federal requirements. The effect of this condition also increases the risk that expenditures are unallowable per the grant, federal regulations, or cost principles due to the insufficient support of proper approval retained. Questioned costs: None Repeat Finding: Yes - 2022-004 Recommendation: Policies and procedures should be in place to ensure quarterly financial reports are properly supported, accurately reported, and adequately approved and reviewed. A formal review process should be established to ensure compliance. The Organization should following the Document Retention Policy that was put in place and required by law. Views of Responsible Officials: Management agrees with this finding and their response is included in the Corrective Action Plan.
Finding 2023-003 - Material Weakness in Internal Control over Compliance and Material Noncompliance (Qualified Opinion) - Inadequate Tracking of Expenditures and Retention of Documentation: Activities Allowed or Unallowed: Allowable Costs/Cost Principles and Reporting (A/B/L) for Assistance Listing Number 19.510 and 93.567 Criteria: The Code of Federal Regulations (CFR) Section 200.510(b) states in part, “The auditee must also prepare a schedule of federal expenditures for the period covered by the auditee’s consolidated financial statements which must include the total Federal awards expended as determined in accordance with 200.502.” Also, in accordance with CFR Section 200.302(b) - Financial Management, the auditees financial management system must provide 1) identification of all federal awards received and expended; 2) accurate, current, and complete disclosure of the financial results of each federal award or program; 3) records that identify adequately the source and application of funds for federally‐funded activities; 4) effective control over, and accountability for, all funds, property, and other assets; 5) comparison of expenditures with budget amounts for each Federal award; 6) written procedures to implement the requirements of section 200.305 and; 7) written procedures for determining the allowability of costs in accordance with Subpart E and the terms and conditions of the Federal award. Recipients of federal awards must submit accurate, complete and timely financial and performance reports. The Organization should have internal controls designed to ensure compliance with those provisions. The Organization should retain sufficient documentation such as invoice and allocation support for expenditures to retain documentation for audit purposes. Condition: During detail testing of expenditures, it was noted that the Organization did not maintain adequate documentation to support how certain costs were allocated to the federal program. Several transactions lacked sufficient detail, such as invoice or expense reimbursement form. Several expenditures selected for testing did not obtain sufficient approval by an individual at the Organization. It was noted that quarterly reports provided to the federal program were not reviewed by an individual at the Organization prior to submission to ensure accurate report of expenditures. Cause: The Organization does not have an adequate system in place to ensure quarterly reports have sufficient supporting documentation, proper approval/review, and accurate reporting prior to submission. Responsibilities for expenditure tracking were not clearly assigned, and there was no formal review process in place. The Organization is not following their Document Retention Policy. Effect: The effect of this condition increases the possibility that quarterly financial reports are misstated or inaccurate and increase the risk of noncompliance with federal requirements. The effect of this condition also increases the risk that expenditures are unallowable per the grant, federal regulations, or cost principles due to the insufficient support of proper approval retained. Questioned costs: None Repeat Finding: Yes - 2022-004 Recommendation: Policies and procedures should be in place to ensure quarterly financial reports are properly supported, accurately reported, and adequately approved and reviewed. A formal review process should be established to ensure compliance. The Organization should following the Document Retention Policy that was put in place and required by law. Views of Responsible Officials: Management agrees with this finding and their response is included in the Corrective Action Plan.
FINDING REFERENCE NUMBER 2023-047 (See Finding Reference Number 2023-019) FEDERAL PROGRAM ALL FEDERAL PROGRAMS ON THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS AWARD NUMBER ALL AWARDS COMPLIANCE REQUIREMENT REPORTING – SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA 2 CFR §200.510 Financial Statements, (b) states that the auditee must prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended. At a minimum, the schedule must: (1) list individual Federal Programs by Federal agency, (2) for Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included, (3) provide total Federal awards expended for each individual Federal program and the ALN number or other identifying number when the ALN information is not available, (4) Include the total amount provided to subrecipients from each Federal program, (5) for loan or loan guarantee programs identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. STATEMENT OF CONDITION During our audit procedures of the Schedule of Expenditures of Federal Awards (SEFA) prepared by the PRDF, we noted significant misstatements pertaining to the program and expenses listed in the PRDF's SEFA throughout our audit procedures. • The expenditures for some Federal programs were not accurately reported. To reconcile the correct amounts contained in the SEFA with the audited financial accounts, the PRDF suggested and posted adjustments. • The PRDF Management does not have an adequate internal control system in place to quickly detect and accurately document the expenditures incurred under each Federal award programs. This led to delays and errors in the amounts initially submitted for the SEFA. • Internal controls over the Federal award data entered the Financial Statement through the PRIFAS, which provided the PRDF’s SEFA and other financial reports, had not been put in place by the PRDF. The SEFA that was submitted for audit procedures contained the following mistakes because of inadequate internal controls: • There are no safeguards in place to keep an accurate and comprehensive list of Notice of Agreements (NOAs). As a result, the different versions received of the SEFA amounts and identification of the programs were reported in an incomplete or erroneous manner. • Expenditures related to COVID-19 appropriations for different Federal programs were not separately disclosed in the SEFA. • Initially, $27,371,670 in expenditures for the Payment to Territories – Adult program (ALN 93.560) was recorded under the Temporary Assistance for Needy Families (TANF) (ALN 93.558). • Due to transactions that were not recorded in PRIFAS, the Social Services Block Grant (ALN 93.667) program expenditures were understated by $7,132,636. Without an appropriate review procedure in place to identify and permit the rectification of errors prior to submission, the ADFAN Finance Department recorded this transactions as encumbrances. PERSPECTIVE INFORMATION The PRDF failed to identify properly in its records and/or accounting records the Federal grants that they received and expended during the fiscal year, this cause that when the PRDF prepared the SEFA with the financial statement and for audit purposes the SEFA was incomplete and misstated. STATEMENT OF CAUSE The PRDF failed to identify the Federal grants expended during the fiscal year and to keep records of the transactions related to the Federal programs in order to properly identify the Federal programs and transactions when the SEFA is prepared causing the preparation of an incomplete and misstated SEFA. POSSIBLE ASSERTED EFFECT The PRDF may fail to include all Federal programs and total expenditures in the SEFA causing misstatements in the SEFA submitted to Auditors. It also leads to an inaccurate Major Program Determination multiple times made by the auditors, affecting the execution of the Single Audit in a reasonable time. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS We recommend the PRDF to maintain adequate records related to the Federal programs in order to properly identify the Federal programs/transactions when the SEFA is prepared. Once a Federal award is granted or received, the information must be shared with all personnel involved in the financial statement and SEFA preparation to provide assurance that all required program activities / expenditures are included on the SEFA. In addition, the PRDF must perform a regular fiscal monitoring over the Federal programs transactions in order to provide reasonable assurance that all Federal programs/transactions are properly recorded and included on the SEFA.
FINDING REFERENCE NUMBER 2023-047 (See Finding Reference Number 2023-019) FEDERAL PROGRAM ALL FEDERAL PROGRAMS ON THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS AWARD NUMBER ALL AWARDS COMPLIANCE REQUIREMENT REPORTING – SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA 2 CFR §200.510 Financial Statements, (b) states that the auditee must prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended. At a minimum, the schedule must: (1) list individual Federal Programs by Federal agency, (2) for Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included, (3) provide total Federal awards expended for each individual Federal program and the ALN number or other identifying number when the ALN information is not available, (4) Include the total amount provided to subrecipients from each Federal program, (5) for loan or loan guarantee programs identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. STATEMENT OF CONDITION During our audit procedures of the Schedule of Expenditures of Federal Awards (SEFA) prepared by the PRDF, we noted significant misstatements pertaining to the program and expenses listed in the PRDF's SEFA throughout our audit procedures. • The expenditures for some Federal programs were not accurately reported. To reconcile the correct amounts contained in the SEFA with the audited financial accounts, the PRDF suggested and posted adjustments. • The PRDF Management does not have an adequate internal control system in place to quickly detect and accurately document the expenditures incurred under each Federal award programs. This led to delays and errors in the amounts initially submitted for the SEFA. • Internal controls over the Federal award data entered the Financial Statement through the PRIFAS, which provided the PRDF’s SEFA and other financial reports, had not been put in place by the PRDF. The SEFA that was submitted for audit procedures contained the following mistakes because of inadequate internal controls: • There are no safeguards in place to keep an accurate and comprehensive list of Notice of Agreements (NOAs). As a result, the different versions received of the SEFA amounts and identification of the programs were reported in an incomplete or erroneous manner. • Expenditures related to COVID-19 appropriations for different Federal programs were not separately disclosed in the SEFA. • Initially, $27,371,670 in expenditures for the Payment to Territories – Adult program (ALN 93.560) was recorded under the Temporary Assistance for Needy Families (TANF) (ALN 93.558). • Due to transactions that were not recorded in PRIFAS, the Social Services Block Grant (ALN 93.667) program expenditures were understated by $7,132,636. Without an appropriate review procedure in place to identify and permit the rectification of errors prior to submission, the ADFAN Finance Department recorded this transactions as encumbrances. PERSPECTIVE INFORMATION The PRDF failed to identify properly in its records and/or accounting records the Federal grants that they received and expended during the fiscal year, this cause that when the PRDF prepared the SEFA with the financial statement and for audit purposes the SEFA was incomplete and misstated. STATEMENT OF CAUSE The PRDF failed to identify the Federal grants expended during the fiscal year and to keep records of the transactions related to the Federal programs in order to properly identify the Federal programs and transactions when the SEFA is prepared causing the preparation of an incomplete and misstated SEFA. POSSIBLE ASSERTED EFFECT The PRDF may fail to include all Federal programs and total expenditures in the SEFA causing misstatements in the SEFA submitted to Auditors. It also leads to an inaccurate Major Program Determination multiple times made by the auditors, affecting the execution of the Single Audit in a reasonable time. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS We recommend the PRDF to maintain adequate records related to the Federal programs in order to properly identify the Federal programs/transactions when the SEFA is prepared. Once a Federal award is granted or received, the information must be shared with all personnel involved in the financial statement and SEFA preparation to provide assurance that all required program activities / expenditures are included on the SEFA. In addition, the PRDF must perform a regular fiscal monitoring over the Federal programs transactions in order to provide reasonable assurance that all Federal programs/transactions are properly recorded and included on the SEFA.
FINDING REFERENCE NUMBER 2023-047 (See Finding Reference Number 2023-019) FEDERAL PROGRAM ALL FEDERAL PROGRAMS ON THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS AWARD NUMBER ALL AWARDS COMPLIANCE REQUIREMENT REPORTING – SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA 2 CFR §200.510 Financial Statements, (b) states that the auditee must prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended. At a minimum, the schedule must: (1) list individual Federal Programs by Federal agency, (2) for Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included, (3) provide total Federal awards expended for each individual Federal program and the ALN number or other identifying number when the ALN information is not available, (4) Include the total amount provided to subrecipients from each Federal program, (5) for loan or loan guarantee programs identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. STATEMENT OF CONDITION During our audit procedures of the Schedule of Expenditures of Federal Awards (SEFA) prepared by the PRDF, we noted significant misstatements pertaining to the program and expenses listed in the PRDF's SEFA throughout our audit procedures. • The expenditures for some Federal programs were not accurately reported. To reconcile the correct amounts contained in the SEFA with the audited financial accounts, the PRDF suggested and posted adjustments. • The PRDF Management does not have an adequate internal control system in place to quickly detect and accurately document the expenditures incurred under each Federal award programs. This led to delays and errors in the amounts initially submitted for the SEFA. • Internal controls over the Federal award data entered the Financial Statement through the PRIFAS, which provided the PRDF’s SEFA and other financial reports, had not been put in place by the PRDF. The SEFA that was submitted for audit procedures contained the following mistakes because of inadequate internal controls: • There are no safeguards in place to keep an accurate and comprehensive list of Notice of Agreements (NOAs). As a result, the different versions received of the SEFA amounts and identification of the programs were reported in an incomplete or erroneous manner. • Expenditures related to COVID-19 appropriations for different Federal programs were not separately disclosed in the SEFA. • Initially, $27,371,670 in expenditures for the Payment to Territories – Adult program (ALN 93.560) was recorded under the Temporary Assistance for Needy Families (TANF) (ALN 93.558). • Due to transactions that were not recorded in PRIFAS, the Social Services Block Grant (ALN 93.667) program expenditures were understated by $7,132,636. Without an appropriate review procedure in place to identify and permit the rectification of errors prior to submission, the ADFAN Finance Department recorded this transactions as encumbrances. PERSPECTIVE INFORMATION The PRDF failed to identify properly in its records and/or accounting records the Federal grants that they received and expended during the fiscal year, this cause that when the PRDF prepared the SEFA with the financial statement and for audit purposes the SEFA was incomplete and misstated. STATEMENT OF CAUSE The PRDF failed to identify the Federal grants expended during the fiscal year and to keep records of the transactions related to the Federal programs in order to properly identify the Federal programs and transactions when the SEFA is prepared causing the preparation of an incomplete and misstated SEFA. POSSIBLE ASSERTED EFFECT The PRDF may fail to include all Federal programs and total expenditures in the SEFA causing misstatements in the SEFA submitted to Auditors. It also leads to an inaccurate Major Program Determination multiple times made by the auditors, affecting the execution of the Single Audit in a reasonable time. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS We recommend the PRDF to maintain adequate records related to the Federal programs in order to properly identify the Federal programs/transactions when the SEFA is prepared. Once a Federal award is granted or received, the information must be shared with all personnel involved in the financial statement and SEFA preparation to provide assurance that all required program activities / expenditures are included on the SEFA. In addition, the PRDF must perform a regular fiscal monitoring over the Federal programs transactions in order to provide reasonable assurance that all Federal programs/transactions are properly recorded and included on the SEFA.
FINDING REFERENCE NUMBER 2023-047 (See Finding Reference Number 2023-019) FEDERAL PROGRAM ALL FEDERAL PROGRAMS ON THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS AWARD NUMBER ALL AWARDS COMPLIANCE REQUIREMENT REPORTING – SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA 2 CFR §200.510 Financial Statements, (b) states that the auditee must prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended. At a minimum, the schedule must: (1) list individual Federal Programs by Federal agency, (2) for Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included, (3) provide total Federal awards expended for each individual Federal program and the ALN number or other identifying number when the ALN information is not available, (4) Include the total amount provided to subrecipients from each Federal program, (5) for loan or loan guarantee programs identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. STATEMENT OF CONDITION During our audit procedures of the Schedule of Expenditures of Federal Awards (SEFA) prepared by the PRDF, we noted significant misstatements pertaining to the program and expenses listed in the PRDF's SEFA throughout our audit procedures. • The expenditures for some Federal programs were not accurately reported. To reconcile the correct amounts contained in the SEFA with the audited financial accounts, the PRDF suggested and posted adjustments. • The PRDF Management does not have an adequate internal control system in place to quickly detect and accurately document the expenditures incurred under each Federal award programs. This led to delays and errors in the amounts initially submitted for the SEFA. • Internal controls over the Federal award data entered the Financial Statement through the PRIFAS, which provided the PRDF’s SEFA and other financial reports, had not been put in place by the PRDF. The SEFA that was submitted for audit procedures contained the following mistakes because of inadequate internal controls: • There are no safeguards in place to keep an accurate and comprehensive list of Notice of Agreements (NOAs). As a result, the different versions received of the SEFA amounts and identification of the programs were reported in an incomplete or erroneous manner. • Expenditures related to COVID-19 appropriations for different Federal programs were not separately disclosed in the SEFA. • Initially, $27,371,670 in expenditures for the Payment to Territories – Adult program (ALN 93.560) was recorded under the Temporary Assistance for Needy Families (TANF) (ALN 93.558). • Due to transactions that were not recorded in PRIFAS, the Social Services Block Grant (ALN 93.667) program expenditures were understated by $7,132,636. Without an appropriate review procedure in place to identify and permit the rectification of errors prior to submission, the ADFAN Finance Department recorded this transactions as encumbrances. PERSPECTIVE INFORMATION The PRDF failed to identify properly in its records and/or accounting records the Federal grants that they received and expended during the fiscal year, this cause that when the PRDF prepared the SEFA with the financial statement and for audit purposes the SEFA was incomplete and misstated. STATEMENT OF CAUSE The PRDF failed to identify the Federal grants expended during the fiscal year and to keep records of the transactions related to the Federal programs in order to properly identify the Federal programs and transactions when the SEFA is prepared causing the preparation of an incomplete and misstated SEFA. POSSIBLE ASSERTED EFFECT The PRDF may fail to include all Federal programs and total expenditures in the SEFA causing misstatements in the SEFA submitted to Auditors. It also leads to an inaccurate Major Program Determination multiple times made by the auditors, affecting the execution of the Single Audit in a reasonable time. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS We recommend the PRDF to maintain adequate records related to the Federal programs in order to properly identify the Federal programs/transactions when the SEFA is prepared. Once a Federal award is granted or received, the information must be shared with all personnel involved in the financial statement and SEFA preparation to provide assurance that all required program activities / expenditures are included on the SEFA. In addition, the PRDF must perform a regular fiscal monitoring over the Federal programs transactions in order to provide reasonable assurance that all Federal programs/transactions are properly recorded and included on the SEFA.
FINDING REFERENCE NUMBER 2023-047 (See Finding Reference Number 2023-019) FEDERAL PROGRAM ALL FEDERAL PROGRAMS ON THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS AWARD NUMBER ALL AWARDS COMPLIANCE REQUIREMENT REPORTING – SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA 2 CFR §200.510 Financial Statements, (b) states that the auditee must prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended. At a minimum, the schedule must: (1) list individual Federal Programs by Federal agency, (2) for Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included, (3) provide total Federal awards expended for each individual Federal program and the ALN number or other identifying number when the ALN information is not available, (4) Include the total amount provided to subrecipients from each Federal program, (5) for loan or loan guarantee programs identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. STATEMENT OF CONDITION During our audit procedures of the Schedule of Expenditures of Federal Awards (SEFA) prepared by the PRDF, we noted significant misstatements pertaining to the program and expenses listed in the PRDF's SEFA throughout our audit procedures. • The expenditures for some Federal programs were not accurately reported. To reconcile the correct amounts contained in the SEFA with the audited financial accounts, the PRDF suggested and posted adjustments. • The PRDF Management does not have an adequate internal control system in place to quickly detect and accurately document the expenditures incurred under each Federal award programs. This led to delays and errors in the amounts initially submitted for the SEFA. • Internal controls over the Federal award data entered the Financial Statement through the PRIFAS, which provided the PRDF’s SEFA and other financial reports, had not been put in place by the PRDF. The SEFA that was submitted for audit procedures contained the following mistakes because of inadequate internal controls: • There are no safeguards in place to keep an accurate and comprehensive list of Notice of Agreements (NOAs). As a result, the different versions received of the SEFA amounts and identification of the programs were reported in an incomplete or erroneous manner. • Expenditures related to COVID-19 appropriations for different Federal programs were not separately disclosed in the SEFA. • Initially, $27,371,670 in expenditures for the Payment to Territories – Adult program (ALN 93.560) was recorded under the Temporary Assistance for Needy Families (TANF) (ALN 93.558). • Due to transactions that were not recorded in PRIFAS, the Social Services Block Grant (ALN 93.667) program expenditures were understated by $7,132,636. Without an appropriate review procedure in place to identify and permit the rectification of errors prior to submission, the ADFAN Finance Department recorded this transactions as encumbrances. PERSPECTIVE INFORMATION The PRDF failed to identify properly in its records and/or accounting records the Federal grants that they received and expended during the fiscal year, this cause that when the PRDF prepared the SEFA with the financial statement and for audit purposes the SEFA was incomplete and misstated. STATEMENT OF CAUSE The PRDF failed to identify the Federal grants expended during the fiscal year and to keep records of the transactions related to the Federal programs in order to properly identify the Federal programs and transactions when the SEFA is prepared causing the preparation of an incomplete and misstated SEFA. POSSIBLE ASSERTED EFFECT The PRDF may fail to include all Federal programs and total expenditures in the SEFA causing misstatements in the SEFA submitted to Auditors. It also leads to an inaccurate Major Program Determination multiple times made by the auditors, affecting the execution of the Single Audit in a reasonable time. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS We recommend the PRDF to maintain adequate records related to the Federal programs in order to properly identify the Federal programs/transactions when the SEFA is prepared. Once a Federal award is granted or received, the information must be shared with all personnel involved in the financial statement and SEFA preparation to provide assurance that all required program activities / expenditures are included on the SEFA. In addition, the PRDF must perform a regular fiscal monitoring over the Federal programs transactions in order to provide reasonable assurance that all Federal programs/transactions are properly recorded and included on the SEFA.
FINDING REFERENCE NUMBER 2023-047 (See Finding Reference Number 2023-019) FEDERAL PROGRAM ALL FEDERAL PROGRAMS ON THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS AWARD NUMBER ALL AWARDS COMPLIANCE REQUIREMENT REPORTING – SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA 2 CFR §200.510 Financial Statements, (b) states that the auditee must prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended. At a minimum, the schedule must: (1) list individual Federal Programs by Federal agency, (2) for Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included, (3) provide total Federal awards expended for each individual Federal program and the ALN number or other identifying number when the ALN information is not available, (4) Include the total amount provided to subrecipients from each Federal program, (5) for loan or loan guarantee programs identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. STATEMENT OF CONDITION During our audit procedures of the Schedule of Expenditures of Federal Awards (SEFA) prepared by the PRDF, we noted significant misstatements pertaining to the program and expenses listed in the PRDF's SEFA throughout our audit procedures. • The expenditures for some Federal programs were not accurately reported. To reconcile the correct amounts contained in the SEFA with the audited financial accounts, the PRDF suggested and posted adjustments. • The PRDF Management does not have an adequate internal control system in place to quickly detect and accurately document the expenditures incurred under each Federal award programs. This led to delays and errors in the amounts initially submitted for the SEFA. • Internal controls over the Federal award data entered the Financial Statement through the PRIFAS, which provided the PRDF’s SEFA and other financial reports, had not been put in place by the PRDF. The SEFA that was submitted for audit procedures contained the following mistakes because of inadequate internal controls: • There are no safeguards in place to keep an accurate and comprehensive list of Notice of Agreements (NOAs). As a result, the different versions received of the SEFA amounts and identification of the programs were reported in an incomplete or erroneous manner. • Expenditures related to COVID-19 appropriations for different Federal programs were not separately disclosed in the SEFA. • Initially, $27,371,670 in expenditures for the Payment to Territories – Adult program (ALN 93.560) was recorded under the Temporary Assistance for Needy Families (TANF) (ALN 93.558). • Due to transactions that were not recorded in PRIFAS, the Social Services Block Grant (ALN 93.667) program expenditures were understated by $7,132,636. Without an appropriate review procedure in place to identify and permit the rectification of errors prior to submission, the ADFAN Finance Department recorded this transactions as encumbrances. PERSPECTIVE INFORMATION The PRDF failed to identify properly in its records and/or accounting records the Federal grants that they received and expended during the fiscal year, this cause that when the PRDF prepared the SEFA with the financial statement and for audit purposes the SEFA was incomplete and misstated. STATEMENT OF CAUSE The PRDF failed to identify the Federal grants expended during the fiscal year and to keep records of the transactions related to the Federal programs in order to properly identify the Federal programs and transactions when the SEFA is prepared causing the preparation of an incomplete and misstated SEFA. POSSIBLE ASSERTED EFFECT The PRDF may fail to include all Federal programs and total expenditures in the SEFA causing misstatements in the SEFA submitted to Auditors. It also leads to an inaccurate Major Program Determination multiple times made by the auditors, affecting the execution of the Single Audit in a reasonable time. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS We recommend the PRDF to maintain adequate records related to the Federal programs in order to properly identify the Federal programs/transactions when the SEFA is prepared. Once a Federal award is granted or received, the information must be shared with all personnel involved in the financial statement and SEFA preparation to provide assurance that all required program activities / expenditures are included on the SEFA. In addition, the PRDF must perform a regular fiscal monitoring over the Federal programs transactions in order to provide reasonable assurance that all Federal programs/transactions are properly recorded and included on the SEFA.
FINDING REFERENCE NUMBER 2023-047 (See Finding Reference Number 2023-019) FEDERAL PROGRAM ALL FEDERAL PROGRAMS ON THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS AWARD NUMBER ALL AWARDS COMPLIANCE REQUIREMENT REPORTING – SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA 2 CFR §200.510 Financial Statements, (b) states that the auditee must prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended. At a minimum, the schedule must: (1) list individual Federal Programs by Federal agency, (2) for Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included, (3) provide total Federal awards expended for each individual Federal program and the ALN number or other identifying number when the ALN information is not available, (4) Include the total amount provided to subrecipients from each Federal program, (5) for loan or loan guarantee programs identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. STATEMENT OF CONDITION During our audit procedures of the Schedule of Expenditures of Federal Awards (SEFA) prepared by the PRDF, we noted significant misstatements pertaining to the program and expenses listed in the PRDF's SEFA throughout our audit procedures. • The expenditures for some Federal programs were not accurately reported. To reconcile the correct amounts contained in the SEFA with the audited financial accounts, the PRDF suggested and posted adjustments. • The PRDF Management does not have an adequate internal control system in place to quickly detect and accurately document the expenditures incurred under each Federal award programs. This led to delays and errors in the amounts initially submitted for the SEFA. • Internal controls over the Federal award data entered the Financial Statement through the PRIFAS, which provided the PRDF’s SEFA and other financial reports, had not been put in place by the PRDF. The SEFA that was submitted for audit procedures contained the following mistakes because of inadequate internal controls: • There are no safeguards in place to keep an accurate and comprehensive list of Notice of Agreements (NOAs). As a result, the different versions received of the SEFA amounts and identification of the programs were reported in an incomplete or erroneous manner. • Expenditures related to COVID-19 appropriations for different Federal programs were not separately disclosed in the SEFA. • Initially, $27,371,670 in expenditures for the Payment to Territories – Adult program (ALN 93.560) was recorded under the Temporary Assistance for Needy Families (TANF) (ALN 93.558). • Due to transactions that were not recorded in PRIFAS, the Social Services Block Grant (ALN 93.667) program expenditures were understated by $7,132,636. Without an appropriate review procedure in place to identify and permit the rectification of errors prior to submission, the ADFAN Finance Department recorded this transactions as encumbrances. PERSPECTIVE INFORMATION The PRDF failed to identify properly in its records and/or accounting records the Federal grants that they received and expended during the fiscal year, this cause that when the PRDF prepared the SEFA with the financial statement and for audit purposes the SEFA was incomplete and misstated. STATEMENT OF CAUSE The PRDF failed to identify the Federal grants expended during the fiscal year and to keep records of the transactions related to the Federal programs in order to properly identify the Federal programs and transactions when the SEFA is prepared causing the preparation of an incomplete and misstated SEFA. POSSIBLE ASSERTED EFFECT The PRDF may fail to include all Federal programs and total expenditures in the SEFA causing misstatements in the SEFA submitted to Auditors. It also leads to an inaccurate Major Program Determination multiple times made by the auditors, affecting the execution of the Single Audit in a reasonable time. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS We recommend the PRDF to maintain adequate records related to the Federal programs in order to properly identify the Federal programs/transactions when the SEFA is prepared. Once a Federal award is granted or received, the information must be shared with all personnel involved in the financial statement and SEFA preparation to provide assurance that all required program activities / expenditures are included on the SEFA. In addition, the PRDF must perform a regular fiscal monitoring over the Federal programs transactions in order to provide reasonable assurance that all Federal programs/transactions are properly recorded and included on the SEFA.
FINDING REFERENCE NUMBER 2023-047 (See Finding Reference Number 2023-019) FEDERAL PROGRAM ALL FEDERAL PROGRAMS ON THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS AWARD NUMBER ALL AWARDS COMPLIANCE REQUIREMENT REPORTING – SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA 2 CFR §200.510 Financial Statements, (b) states that the auditee must prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended. At a minimum, the schedule must: (1) list individual Federal Programs by Federal agency, (2) for Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included, (3) provide total Federal awards expended for each individual Federal program and the ALN number or other identifying number when the ALN information is not available, (4) Include the total amount provided to subrecipients from each Federal program, (5) for loan or loan guarantee programs identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. STATEMENT OF CONDITION During our audit procedures of the Schedule of Expenditures of Federal Awards (SEFA) prepared by the PRDF, we noted significant misstatements pertaining to the program and expenses listed in the PRDF's SEFA throughout our audit procedures. • The expenditures for some Federal programs were not accurately reported. To reconcile the correct amounts contained in the SEFA with the audited financial accounts, the PRDF suggested and posted adjustments. • The PRDF Management does not have an adequate internal control system in place to quickly detect and accurately document the expenditures incurred under each Federal award programs. This led to delays and errors in the amounts initially submitted for the SEFA. • Internal controls over the Federal award data entered the Financial Statement through the PRIFAS, which provided the PRDF’s SEFA and other financial reports, had not been put in place by the PRDF. The SEFA that was submitted for audit procedures contained the following mistakes because of inadequate internal controls: • There are no safeguards in place to keep an accurate and comprehensive list of Notice of Agreements (NOAs). As a result, the different versions received of the SEFA amounts and identification of the programs were reported in an incomplete or erroneous manner. • Expenditures related to COVID-19 appropriations for different Federal programs were not separately disclosed in the SEFA. • Initially, $27,371,670 in expenditures for the Payment to Territories – Adult program (ALN 93.560) was recorded under the Temporary Assistance for Needy Families (TANF) (ALN 93.558). • Due to transactions that were not recorded in PRIFAS, the Social Services Block Grant (ALN 93.667) program expenditures were understated by $7,132,636. Without an appropriate review procedure in place to identify and permit the rectification of errors prior to submission, the ADFAN Finance Department recorded this transactions as encumbrances. PERSPECTIVE INFORMATION The PRDF failed to identify properly in its records and/or accounting records the Federal grants that they received and expended during the fiscal year, this cause that when the PRDF prepared the SEFA with the financial statement and for audit purposes the SEFA was incomplete and misstated. STATEMENT OF CAUSE The PRDF failed to identify the Federal grants expended during the fiscal year and to keep records of the transactions related to the Federal programs in order to properly identify the Federal programs and transactions when the SEFA is prepared causing the preparation of an incomplete and misstated SEFA. POSSIBLE ASSERTED EFFECT The PRDF may fail to include all Federal programs and total expenditures in the SEFA causing misstatements in the SEFA submitted to Auditors. It also leads to an inaccurate Major Program Determination multiple times made by the auditors, affecting the execution of the Single Audit in a reasonable time. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS We recommend the PRDF to maintain adequate records related to the Federal programs in order to properly identify the Federal programs/transactions when the SEFA is prepared. Once a Federal award is granted or received, the information must be shared with all personnel involved in the financial statement and SEFA preparation to provide assurance that all required program activities / expenditures are included on the SEFA. In addition, the PRDF must perform a regular fiscal monitoring over the Federal programs transactions in order to provide reasonable assurance that all Federal programs/transactions are properly recorded and included on the SEFA.
FINDING REFERENCE NUMBER 2023-047 (See Finding Reference Number 2023-019) FEDERAL PROGRAM ALL FEDERAL PROGRAMS ON THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS AWARD NUMBER ALL AWARDS COMPLIANCE REQUIREMENT REPORTING – SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA 2 CFR §200.510 Financial Statements, (b) states that the auditee must prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended. At a minimum, the schedule must: (1) list individual Federal Programs by Federal agency, (2) for Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included, (3) provide total Federal awards expended for each individual Federal program and the ALN number or other identifying number when the ALN information is not available, (4) Include the total amount provided to subrecipients from each Federal program, (5) for loan or loan guarantee programs identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. STATEMENT OF CONDITION During our audit procedures of the Schedule of Expenditures of Federal Awards (SEFA) prepared by the PRDF, we noted significant misstatements pertaining to the program and expenses listed in the PRDF's SEFA throughout our audit procedures. • The expenditures for some Federal programs were not accurately reported. To reconcile the correct amounts contained in the SEFA with the audited financial accounts, the PRDF suggested and posted adjustments. • The PRDF Management does not have an adequate internal control system in place to quickly detect and accurately document the expenditures incurred under each Federal award programs. This led to delays and errors in the amounts initially submitted for the SEFA. • Internal controls over the Federal award data entered the Financial Statement through the PRIFAS, which provided the PRDF’s SEFA and other financial reports, had not been put in place by the PRDF. The SEFA that was submitted for audit procedures contained the following mistakes because of inadequate internal controls: • There are no safeguards in place to keep an accurate and comprehensive list of Notice of Agreements (NOAs). As a result, the different versions received of the SEFA amounts and identification of the programs were reported in an incomplete or erroneous manner. • Expenditures related to COVID-19 appropriations for different Federal programs were not separately disclosed in the SEFA. • Initially, $27,371,670 in expenditures for the Payment to Territories – Adult program (ALN 93.560) was recorded under the Temporary Assistance for Needy Families (TANF) (ALN 93.558). • Due to transactions that were not recorded in PRIFAS, the Social Services Block Grant (ALN 93.667) program expenditures were understated by $7,132,636. Without an appropriate review procedure in place to identify and permit the rectification of errors prior to submission, the ADFAN Finance Department recorded this transactions as encumbrances. PERSPECTIVE INFORMATION The PRDF failed to identify properly in its records and/or accounting records the Federal grants that they received and expended during the fiscal year, this cause that when the PRDF prepared the SEFA with the financial statement and for audit purposes the SEFA was incomplete and misstated. STATEMENT OF CAUSE The PRDF failed to identify the Federal grants expended during the fiscal year and to keep records of the transactions related to the Federal programs in order to properly identify the Federal programs and transactions when the SEFA is prepared causing the preparation of an incomplete and misstated SEFA. POSSIBLE ASSERTED EFFECT The PRDF may fail to include all Federal programs and total expenditures in the SEFA causing misstatements in the SEFA submitted to Auditors. It also leads to an inaccurate Major Program Determination multiple times made by the auditors, affecting the execution of the Single Audit in a reasonable time. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS We recommend the PRDF to maintain adequate records related to the Federal programs in order to properly identify the Federal programs/transactions when the SEFA is prepared. Once a Federal award is granted or received, the information must be shared with all personnel involved in the financial statement and SEFA preparation to provide assurance that all required program activities / expenditures are included on the SEFA. In addition, the PRDF must perform a regular fiscal monitoring over the Federal programs transactions in order to provide reasonable assurance that all Federal programs/transactions are properly recorded and included on the SEFA.