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 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.
Reference Number: 2023-006 Category of Finding: Subrecipient Monitoring Type of Finding: Material Weakness and Material Instance of Noncompliance State Administering Department: California Department of Transportation Assistance Listing Number: 20.205 Federal Program Title: Highway Planning and Construction Federal Award Numbers and Years: Q101310; 2023 Q101403; 2023 7500257; 2023 P020177; 2023 8801073; 2023 Criteria Title 2 – Grants and Agreements. Subtitle A – Office of Management and Budget Guidance for Grants and Agreements. Chapter II – Office of Management and Budget Guidance. Part 200 – Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. Subpart D – Post Federal Award Requirements. Standards for Financial and Program Management. §200.303 Internal controls (2 CFR 200.303): The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Title 2 – Grants and Agreements. Subtitle A – Office of Management and Budget Guidance for Grants and Agreements. Chapter II – Office of Management and Budget Guidance. Part 200 – Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. Subpart D – Post Federal Award Requirements. Subrecipient Monitoring and Management §200.322 Requirements for pass-through entities (2 CFR 200.332): (a) Ensure that every subaward is clearly identified to the subrecipient as a subaward and includes the following information at the time of the subaward and if any of these data elements change, include the changes in subsequent subaward modification. When some of this information is not available, the pass-through entity must provide the best information available to describe the Federal award and subaward. Required information includes: 1. Federal award identification. i. Subrecipient name (which must match the name associated with its unique entity identifier); ii. Subrecipient’s unique entity identifier; Federal Award Identification Number (FAIN); iii. Federal Award Date (see the definition of Federal award date in § 200.1 of this part) of award to the recipient by the Federal agency; iv. Subaward Period of Performance Start and End Date; v. Subaward Budget Period Start and End Date; vi. Amount of Federal Funds Obligated by this action by the pass-through entity to the subrecipient; vii. Total Amount of Federal Funds Obligated to the subrecipient by the pass-through entity including the current financial obligation; viii. Total Amount of the Federal Award committed to the subrecipient by the pass-through entity; ix. Federal award project description, as required to be responsive to the Federal Funding Accountability and Transparency Act (FFATA); x. Name of Federal awarding agency, pass-through entity, and contact information for awarding official of the Pass-through entity; xi. Assistance Listings number and Title; the pass-through entity must identify the dollar amount made available under each Federal award and the Assistance Listings Number at time of disbursement; xii. Identification of whether the award is R&D; and xiii. Indirect cost rate for the Federal award (including if the de minimis rate is charged) per § 200.414. 2. All requirements imposed by the pass-through entity on the subrecipient so that the Federal award is used in accordance with Federal statutes, regulations and the terms and conditions of the Federal award; 3. Any additional requirements that the pass-through entity imposes on the subrecipient in order for the pass-through entity to meet its own responsibility to the Federal awarding agency including identification of any required financial and performance reports; 4. i. An approved federally recognized indirect cost rate negotiated between the subrecipient and the Federal Government. If no approved rate exists, the pass-through entity must determine the appropriate rate in collaboration with the subrecipient, which is either: 1. The negotiated indirect cost rate between the pass-through entity and the subrecipient; which can be based on a prior negotiated rate between a different PTE and the same subrecipient. If basing the rate on a previously negotiated rate, the pass-through entity is not required to collect information justifying this rate, but may elect to do so; 2. The de minimis indirect cost rate. ii. The pass-through entity must not require use of a de minimis indirect cost rate if the subrecipient has a Federally approved rate. Subrecipients can elect to use the cost allocation method to account for indirect costs in accordance with § 200.405(d). 5. A requirement that the subrecipient permit the pass-through entity and auditors to have access to the subrecipient’s records and financial statements as necessary for the pass-through entity to meet the requirements of this part; and 6. Appropriate terms and conditions concerning closeout of the subaward. (b) Evaluate each subrecipient’s risk of noncompliance with Federal statutes, regulations, and the terms and conditions of the subaward for purposes of determining the appropriate subrecipient monitoring described in paragraphs (d) and (e) of this section, which may include consideration of such factors as: (1) The subrecipient’s prior experience with the same or similar subawards; (2) The results of previous audits including whether or not the subrecipient receives a Single Audit in accordance with Subpart F of this part, and the extent to which the same or similar subaward has been audited as a major program; (3) Whether the subrecipient has new personnel or new or substantially changed systems; and (4) The extent and results of Federal awarding agency monitoring (e.g., if the subrecipient also receives Federal awards directly from a Federal awarding agency). (d) Monitor the activities of the subrecipient as necessary to ensure that the subaward is used for authorized purposes, in compliance with Federal statutes, regulations, and the terms and conditions of the subaward; and that subaward performance goals are achieved. Pass-through entity monitoring of the subrecipient must include: (1) Reviewing financial and performance reports required by the pass-through entity. Condition The California Department of Transportation (Caltrans) did not clearly identify subaward agreements made to subrecipients as subawards and did not include all required elements for 5 of 40 subrecipients sampled. Additionally, the monitoring of the 5 of 40 sampled subrecipients was not sufficient to detect whether the subrecipients’ expenditures were properly reported on the respective subrecipients’ schedules of expenditures of federal awards. Identification as a Repeat Finding This was not a repeat finding from the immediate prior year. Cause Due to the decentralized administration of federal-aid highway projects, not all subaward agreements are administered in a consistent manner throughout various divisions and district offices. Effect Inadequate subaward communication may result in subrecipients being unaware of all federal laws, statutes and regulations that apply to the funding received and potentially expending the funds in an unallowable manner. Additionally, subrecipients may fail to report the expenditures made pursuant to the subawards of their schedule of expenditures of federal awards. Questioned Costs No questioned costs were identified. Context Expenditures passed to subrecipients totaled $1,222,104,172. Sampled expenditures totaled $14,694,125 and $670,937 of the total sampled expenditures related to the exceptions identified. Recommendation Caltrans should develop and implement a consistent policy and process for all divisions and district offices to use in making and monitoring subawards under the highway planning and construction program to ensure that all required subaward information is communicated to subrecipients at the time of the award and the federal funds disbursed to subrecipients are adequately monitored. Views of Responsible Officials and Corrective Action Plan Management’s response is reported in “Management’s Response and Corrective Action Plan” included in a separate section at the end of this report.
Reference Number: 2023-006 Category of Finding: Subrecipient Monitoring Type of Finding: Material Weakness and Material Instance of Noncompliance State Administering Department: California Department of Transportation Assistance Listing Number: 20.205 Federal Program Title: Highway Planning and Construction Federal Award Numbers and Years: Q101310; 2023 Q101403; 2023 7500257; 2023 P020177; 2023 8801073; 2023 Criteria Title 2 – Grants and Agreements. Subtitle A – Office of Management and Budget Guidance for Grants and Agreements. Chapter II – Office of Management and Budget Guidance. Part 200 – Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. Subpart D – Post Federal Award Requirements. Standards for Financial and Program Management. §200.303 Internal controls (2 CFR 200.303): The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Title 2 – Grants and Agreements. Subtitle A – Office of Management and Budget Guidance for Grants and Agreements. Chapter II – Office of Management and Budget Guidance. Part 200 – Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. Subpart D – Post Federal Award Requirements. Subrecipient Monitoring and Management §200.322 Requirements for pass-through entities (2 CFR 200.332): (a) Ensure that every subaward is clearly identified to the subrecipient as a subaward and includes the following information at the time of the subaward and if any of these data elements change, include the changes in subsequent subaward modification. When some of this information is not available, the pass-through entity must provide the best information available to describe the Federal award and subaward. Required information includes: 1. Federal award identification. i. Subrecipient name (which must match the name associated with its unique entity identifier); ii. Subrecipient’s unique entity identifier; Federal Award Identification Number (FAIN); iii. Federal Award Date (see the definition of Federal award date in § 200.1 of this part) of award to the recipient by the Federal agency; iv. Subaward Period of Performance Start and End Date; v. Subaward Budget Period Start and End Date; vi. Amount of Federal Funds Obligated by this action by the pass-through entity to the subrecipient; vii. Total Amount of Federal Funds Obligated to the subrecipient by the pass-through entity including the current financial obligation; viii. Total Amount of the Federal Award committed to the subrecipient by the pass-through entity; ix. Federal award project description, as required to be responsive to the Federal Funding Accountability and Transparency Act (FFATA); x. Name of Federal awarding agency, pass-through entity, and contact information for awarding official of the Pass-through entity; xi. Assistance Listings number and Title; the pass-through entity must identify the dollar amount made available under each Federal award and the Assistance Listings Number at time of disbursement; xii. Identification of whether the award is R&D; and xiii. Indirect cost rate for the Federal award (including if the de minimis rate is charged) per § 200.414. 2. All requirements imposed by the pass-through entity on the subrecipient so that the Federal award is used in accordance with Federal statutes, regulations and the terms and conditions of the Federal award; 3. Any additional requirements that the pass-through entity imposes on the subrecipient in order for the pass-through entity to meet its own responsibility to the Federal awarding agency including identification of any required financial and performance reports; 4. i. An approved federally recognized indirect cost rate negotiated between the subrecipient and the Federal Government. If no approved rate exists, the pass-through entity must determine the appropriate rate in collaboration with the subrecipient, which is either: 1. The negotiated indirect cost rate between the pass-through entity and the subrecipient; which can be based on a prior negotiated rate between a different PTE and the same subrecipient. If basing the rate on a previously negotiated rate, the pass-through entity is not required to collect information justifying this rate, but may elect to do so; 2. The de minimis indirect cost rate. ii. The pass-through entity must not require use of a de minimis indirect cost rate if the subrecipient has a Federally approved rate. Subrecipients can elect to use the cost allocation method to account for indirect costs in accordance with § 200.405(d). 5. A requirement that the subrecipient permit the pass-through entity and auditors to have access to the subrecipient’s records and financial statements as necessary for the pass-through entity to meet the requirements of this part; and 6. Appropriate terms and conditions concerning closeout of the subaward. (b) Evaluate each subrecipient’s risk of noncompliance with Federal statutes, regulations, and the terms and conditions of the subaward for purposes of determining the appropriate subrecipient monitoring described in paragraphs (d) and (e) of this section, which may include consideration of such factors as: (1) The subrecipient’s prior experience with the same or similar subawards; (2) The results of previous audits including whether or not the subrecipient receives a Single Audit in accordance with Subpart F of this part, and the extent to which the same or similar subaward has been audited as a major program; (3) Whether the subrecipient has new personnel or new or substantially changed systems; and (4) The extent and results of Federal awarding agency monitoring (e.g., if the subrecipient also receives Federal awards directly from a Federal awarding agency). (d) Monitor the activities of the subrecipient as necessary to ensure that the subaward is used for authorized purposes, in compliance with Federal statutes, regulations, and the terms and conditions of the subaward; and that subaward performance goals are achieved. Pass-through entity monitoring of the subrecipient must include: (1) Reviewing financial and performance reports required by the pass-through entity. Condition The California Department of Transportation (Caltrans) did not clearly identify subaward agreements made to subrecipients as subawards and did not include all required elements for 5 of 40 subrecipients sampled. Additionally, the monitoring of the 5 of 40 sampled subrecipients was not sufficient to detect whether the subrecipients’ expenditures were properly reported on the respective subrecipients’ schedules of expenditures of federal awards. Identification as a Repeat Finding This was not a repeat finding from the immediate prior year. Cause Due to the decentralized administration of federal-aid highway projects, not all subaward agreements are administered in a consistent manner throughout various divisions and district offices. Effect Inadequate subaward communication may result in subrecipients being unaware of all federal laws, statutes and regulations that apply to the funding received and potentially expending the funds in an unallowable manner. Additionally, subrecipients may fail to report the expenditures made pursuant to the subawards of their schedule of expenditures of federal awards. Questioned Costs No questioned costs were identified. Context Expenditures passed to subrecipients totaled $1,222,104,172. Sampled expenditures totaled $14,694,125 and $670,937 of the total sampled expenditures related to the exceptions identified. Recommendation Caltrans should develop and implement a consistent policy and process for all divisions and district offices to use in making and monitoring subawards under the highway planning and construction program to ensure that all required subaward information is communicated to subrecipients at the time of the award and the federal funds disbursed to subrecipients are adequately monitored. Views of Responsible Officials and Corrective Action Plan Management’s response is reported in “Management’s Response and Corrective Action Plan” included in a separate section at the end of this report.
Reference Number: 2023-009 Category of Finding: Subrecipient Monitoring Type of Finding: Material Weakness and Material Instance of Noncompliance State Administering Department: California Department of Public Health (Public Health) Assistance Listing Number: 93.323 Federal Program Title: Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) Federal Award Number and Year: NU50CK000539; 2021 Criteria Title 2 – Grants and Agreements. Subtitle A – Office of Management and Budget Guidance for Grants and Agreements. Chapter II – Office of Management and Budget Guidance. Part 200 – Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. Subpart D – Post Federal Award Requirements. §200.303 Internal controls (2 CFR 200.303): The non-Federal entity must: (e) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control-Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Title 2 – Grants and Agreements. Subtitle A – Office of Management and Budget Guidance for Grants and Agreements. Chapter II – Office of Management and Budget Guidance. Part 200 – Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. Subpart D – Post Federal Award Requirements. §200.332 Requirements for pass-through entities (2 CFR 200.332): All pass-through entities must: (a) Verify that the subrecipient is not excluded or disqualified in accordance with §180.300. Verification methods are provided in §180.300, which include confirming in SAM.gov that a potential subrecipient is not suspended, debarred, or otherwise excluded from receiving Federal funds. (b) Ensure that every subaward is clearly identified to the subrecipient as a subaward and includes the following information at the time of the subaward and if any of these data elements change, include the changes in subsequent subaward modification. When some of this information is not available, the pass-through entity must provide the best information available to describe the Federal award and subaward. (1) Federal award identification. (i) Subrecipient name (which must match the name associated with its unique entity identifier); (ii) Subrecipient’s unique entity identifier; (iii) Federal Award Identification Number (FAIN); (iv) Federal Award Date (see the definition of Federal award date in § 200.1 of this part) of award to the recipient by the Federal agency; (v) Subaward Period of Performance Start and End Date; (vi) Subaward Budget Period Start and End Date; (vii) Amount of Federal Funds Obligated by this action by the pass-through entity to the subrecipient; (viii) Total Amount of Federal Funds Obligated to the subrecipient by the pass-through entity including the current financial obligation; (ix) Total Amount of the Federal Award committed to the subrecipient by the pass-through entity; (x) Federal award project description, as required to be responsive to the Federal Funding Accountability and Transparency Act (FFATA); (xi) Name of Federal awarding agency, pass-through entity, and contact information for awarding official of the Pass-through entity; (xii) Assistance Listings number and Title; the pass-through entity must identify the dollar amount made available under each Federal award and the Assistance Listings Number at time of disbursement; (xiii) Identification of whether the award is R&D; and (xiv) Indirect cost rate for the Federal award (including if the de minimis rate is charged) per §200.414. (c) Evaluate each subrecipient’s fraud risk and risk of noncompliance with a subaward to determine the appropriate subrecipient monitoring described in paragraphs (f) of this section. When evaluating a subrecipient’s risk, a pass-through entity should consider the following: (1) The subrecipient’s prior experience with the same or similar subawards: (2) The results of previous audits. This includes considering whether or not the subrecipient receives a Single Audit in accordance with Subpart F and the extent to which the same or similar subawards have been audited as a major program; (3) Whether the subrecipient has new personnel or new or substantially changed systems; and (4) The extent and results of Federal agency monitoring (for example, if the subrecipient also receives Federal awards directly from the Federal agency). (e) Monitor the activities of the subrecipient as necessary to ensure that the subaward is used for authorized purposes, in compliance with Federal statutes, regulations, and the terms and conditions of the subaward; and that subaward performance goals are achieved. Pass-through entity monitoring of the subrecipient must include: (1) Reviewing financial and performance reports required by the pass-through entity. (2) Following-up and ensuring that the subrecipient takes timely and appropriate action on all deficiencies pertaining to the Federal award provided to the subrecipient from the pass-through entity detected through audits, on-site reviews, and written confirmation from the subrecipient, highlighting the status of actions planned or taken to address Single Audit findings related to the particular subaward. (3) Issuing a management decision for applicable audit findings pertaining only to the Federal award provided to the subrecipient from the pass-through entity as required by §200.521. (4) The pass-through entity is responsible for resolving audit findings specifically related to the subaward and not responsible for resolving cross-cutting findings. If a subrecipient has a current Single Audit report posted in the Federal Audit Clearinghouse and has not otherwise been excluded from receipt of Federal funding (e.g., has been debarred or suspended), the passthrough entity may rely on the subrecipient’s cognizant audit agency or cognizant oversight agency to perform audit follow-up and make management decisions related to cross-cutting findings in accordance with section §200.513(a)(3)(vii). Such reliance does not eliminate the responsibility of the pass-through entity to issue subawards that conform to agency and award-specific requirements, to manage risk through ongoing subaward monitoring, and to monitor the status of the findings that are specifically related to the subaward. (f) Verify that every subrecipient is audited as required by Subpart F of this part when it is expected that the subrecipient’s Federal awards expended during the respective fiscal year equaled or exceeded the threshold set forth in §200.501. (g) Consider whether the results of the subrecipient’s audits, on-site reviews, or other monitoring indicate conditions that necessitate adjustments to the pass-through entity’s own records. Condition Public Health did not establish a formal risk assessment process over its subrecipients of federal awards by which to determine the frequency and extent of subrecipient monitoring to be performed. While Public Health received reimbursement invoices from subrecipients, there did not appear to be other financial or programmatic monitoring to verify subrecipients complied with applicable requirements. In addition, Public Health did not obtain supporting documentation for any expenditures invoiced by the subrecipients. Follow-up monitoring for subrecipients with no single audit reports did not appear to be performed. On-site monitoring visits were not completed. Public Health was unable to provide evidence that suspension and debarment status of subrecipients was checked prior to entering into subaward. Public Health used a Department Allocation Letter (DAL) for the COVID-19 program instead of an agreement or contract for the subaward to subrecipients. Certain required information for the subaward federal award information such as Assistance Listings number and Title and Federal Award Identification Number (FAIN) were not clearly identified in the DAL. Identification as a Repeat Finding Finding 2022-011 was reported in the immediate prior year. Cause Procedures to perform the required subrecipient monitoring were not established nor did Public Health perform an appropriate level of monitoring. Effect By not properly evaluating the risk of noncompliance, Public Health may inadvertently award grant funds to subrecipients who lack the necessary mechanisms or understanding to comply with federal statutes. This increases the likelihood of noncompliance arising during the performance of the grant-funded activities. Furthermore, failure to obtain and review single audit reports increases the risk of not properly identifying subrecipient program control weaknesses, noncompliance and performing sufficient follow-up on any subrecipient corrective action. Questioned Costs No questioned costs were identified. Context Disbursements to subrecipients for the ELC totaled $282,954,398, or 49% of total reported program expenditures. Recommendation Public Health should establish and document formal procedures for conducting risk assessments of subrecipient funding, including criteria for evaluating organizational capacity, financial stability, compliance history, and programmatic capabilities. Public Health should also develop and implement procedures outlining the process for obtaining single audit reports from subrecipients. Furthermore, a monitoring mechanism should be implemented to track compliance with the single audit mandate among subrecipients, including regular follow-ups and documentation of communication efforts. Public Health should ensure every subaward includes all requirements imposed on the subrecipient so that the federal award is used in accordance with Federal statutes, regulations and the terms and conditions of the federal award. Views of Responsible Officials and Corrective Action Plan Management’s response is reported in “Management’s Response and Corrective Action Plan” included in a separate section at the end of this report.
FINDING REFERENCE NUMBER 2023-061 FEDERAL PROGRAMS (ALN – 93.558) TEMPORARY ASSISTANCE FOR NEEDY FAMILIES (TANF) U.S. DEPARTMENT OF HEALTH AND HUMAN SERVICES AWARD NUMBERS 2022G996117; 2023996117 (Federal Award Years: 2022 through 2023) ADMINISTRATION ADMINISTRATION FOR SOCIOECONOMIC DEVELOPMENT OF THE FAMILY (ADSEF, BY ITS SPANISH ACRONYM) COMPLIANCE REQUIREMENT SUBRECIPIENT MONITORING TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA In accordance with 2 CFR 200.332, a pass-through entity must: (a) Verify that the subrecipient is not excluded or disqualified in accordance with § 180.300. Verification methods are provided in § 180.300, which include confirming in SAM.gov that a potential subrecipient is not suspended, debarred, or otherwise excluded from receiving Federal funds. (b) Ensure that every subaward is clearly identified to the subrecipient as a subaward and includes the information provided below. A pass-through entity must provide the best available information when some of the information below is unavailable. A pass-through entity must provide the unavailable information when it is obtained. Required information includes: (1) Federal award identification. (i) Subrecipient's name (must match the name associated with its unique entity identifier); (ii) Subrecipient's unique entity identifier; (iii) Federal Award Identification Number (FAIN); (iv) Federal Award Date; (v) Subaward Period of Performance Start and End Date; (vi) Subaward Budget Period Start and End Date; (vii) Amount of Federal Funds Obligated in the subaward; (viii) Total Amount of Federal Funds Obligated to the subrecipient by the pass-through entity, including the current financial obligation; (ix) Total Amount of the Federal Award committed to the subrecipient by the pass-through entity; (x) Federal award project description, as required by the Federal Funding Accountability and Transparency Act (FFATA); (xi) Name of the Federal agency, pass-through entity, and contact information for awarding official of the pass-through entity; (xii) Assistance Listings title and number; the pass-through entity must identify the dollar amount made available under each Federal award and the Assistance Listings Number at the time of disbursement; (xiii) Identification of whether the Federal award is for research and development; and (xiv) Indirect cost rate for the Federal award (including if the de minimis rate is used in accordance with § 200.414). (2) All requirements of the subaward, including requirements imposed by Federal statutes, regulations, and the terms and conditions of the Federal award; (3) Any additional requirements that the pass-through entity imposes on the subrecipient for the pass-through entity to meet its responsibilities under the Federal award. This includes information and certifications (see § 200.415) required for submitting financial and performance reports that the pass-through entity must provide to the Federal agency; … (5) A requirement that the subrecipient permit the pass-through entity and auditors to access the subrecipient's records and financial statements for the pass-through entity to fulfill its monitoring requirements; and (6) Appropriate terms and conditions concerning the closeout of the subaward. (c) Evaluate each subrecipient's fraud risk and risk of noncompliance with a subaward to determine the appropriate subrecipient monitoring described in paragraph (f) of this section. When evaluating a subrecipient's risk, a pass-through entity should consider the following: (1) The subrecipient's prior experience with the same or similar subawards; (2) The results of previous audits. This includes considering whether or not the subrecipient receives a Single Audit in accordance with subpart F and the extent to which the same or similar subawards have been audited as a major program; (3) Whether the subrecipient has new personnel or new or substantially changed systems; and (4) The extent and results of any Federal agency monitoring (for example, if the subrecipient also receives Federal awards directly from the Federal agency). (d) If appropriate, consider implementing specific conditions in a subaward as described in § 200.208 and notify the Federal agency of the specific conditions. (e) Monitor the activities of a subrecipient as necessary to ensure that the subrecipient complies with Federal statutes, regulations, and the terms and conditions of the subaward. The pass-through entity is responsible for monitoring the overall performance of a subrecipient to ensure that the goals and objectives of the subaward are achieved. In monitoring a subrecipient, a pass-through entity must: (1) Review financial and performance reports. (2) Ensure that the subrecipient takes corrective action on all significant developments that negatively affect the subaward. Significant developments include Single Audit findings related to the subaward, other audit findings, site visits, and written notifications from a subrecipient of adverse conditions which will impact their ability to meet the milestones or the objectives of a subaward. When significant developments negatively impact the subaward, a subrecipient must provide the pass-through entity with information on their plan for corrective action and any assistance needed to resolve the situation. (3) Issue a management decision for audit findings pertaining only to the Federal award provided to the subrecipient from the pass-through entity as required by § 200.521. (4) Resolve audit findings specifically related to the subaward. However, the pass-through entity is not responsible for resolving cross-cutting audit findings that apply to the subaward and other Federal awards or subawards. If a subrecipient has a current Single Audit report and has not been excluded from receiving Federal funding (meaning, has not been debarred or suspended), the pass-through entity may rely on the subrecipient's cognizant agency for audit or oversight agency for audit to perform audit follow-up and make management decisions related to cross-cutting audit findings in accordance with section § 200.513(a)(4)(viii). Such reliance does not eliminate the responsibility of the pass-through entity to issue subawards that conform to agency and award-specific requirements, to manage risk through ongoing subaward monitoring, and to monitor the status of the findings that are specifically related to the subaward. (f) Depending upon the pass-through entity's assessment of the risk posed by the subrecipient (as described in paragraph (c) of this section), the following monitoring tools may be useful for the pass-through entity to ensure proper accountability and compliance with program requirements and achievement of performance goals: (1) Providing subrecipients with training and technical assistance on program-related matters; (2) Performing site visits to review the subrecipient's program operations; and (3) Arranging for agreed-upon-procedures engagements as described in § 200.425. (g) Verify that a subrecipient is audited as required by subpart F of this part. (h) Consider whether the results of a subrecipient's audit, site visits, or other monitoring necessitate adjustments to the pass-through entity's records. (i) Consider taking enforcement action against noncompliant subrecipients as described in § 200.339 and in program regulations. STATEMENT OF CONDITION As part of our understanding of the program, program staff were interviewed regarding the existence of subrecipients. None of the staff interviewed identified any transactions involving subrecipients. However, in our testing of internal controls and compliance with the allowable costs/cost principles requirement, transactions were selected to assess compliance with this requirement. Upon receiving documentation from a contractor, we realized that the transactions with this supplier were in the capacity of a subrecipient. In addition, the SEFA submitted by the PRDF does not identify any transaction under a subrecipient related to this program. In the final draft of the SEFA submitted for audit procedures, ADSEF reported the amount of $2,411,184, which included all transactions related to preventive services. We examined four (4) vouchers related to these services; the contract, proposal and invoices do not indicate information related to subrecipients. QUESTIONED COSTS No questioned costs identified. PERSPECTIVE INFORMATION This is a systemic deficiency. The staff in charge of administering TANF funds were unaware of the factors required to properly identify subrecipient transactions. The total expenditure reflected in the database related to subrecipient activities totaled $686,052.17 for the audited fiscal year. After providing the requirements for a subrecipient, staff were interviewed again to verify whether other providers met the subrecipient requirements, but no other entities were identified. From our testing, we identified no other subrecipients. Although, in the final draft of the SEFA submitted for audit procedures, all expenditures related to preventive services were included as pass-through expenditures. STATEMENT OF CAUSE The staff in charge of administering the program were unaware of the factors that determine whether a contractor is a subrecipient or a contractor. ADSEF has not established an adequate procedures manual that demonstrates compliance with all requirements for subrecipient activities. POSSIBLE ASSERTED EFFECT ADSEF does not have internal controls related to the identification, management, and reporting of subrecipient activities. This situation prevents compliance with all compliance requirements related to subrecipient monitoring. This situation prevented the proper presentation of Federal expenditures incurred under this program in the SEFA or other financial reports required by Federal agencies. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS The PRDF must provide training to ADSEF personnel on the requirements and regulations related to subrecipient monitoring. We recommend that management establish internal controls and compliance measures that allow for the identification, reporting, and monitoring of subrecipient activities.
Material Weakness/Noncompliance – Schedule of Expenditures of Federal Awards 2 CFR § 200.510(b) states, in part, 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 as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) 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. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), 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. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $675,306. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided. Officials' Response: See Corrective Action Plan
Material Weakness/Noncompliance – Schedule of Expenditures of Federal Awards 2 CFR § 200.510(b) states, in part, 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 as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) 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. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), 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. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $675,306. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided. Officials' Response: See Corrective Action Plan
Material Weakness/Noncompliance – Schedule of Expenditures of Federal Awards 2 CFR § 200.510(b) states, in part, 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 as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) 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. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), 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. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $675,306. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided. Officials' Response: See Corrective Action Plan
Material Weakness/Noncompliance – Schedule of Expenditures of Federal Awards 2 CFR § 200.510(b) states, in part, 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 as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) 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. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), 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. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $675,306. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided. Officials' Response: See Corrective Action Plan
Material Weakness/Noncompliance – Schedule of Expenditures of Federal Awards 2 CFR § 200.510(b) states, in part, 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 as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) 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. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), 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. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $675,306. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided. Officials' Response: See Corrective Action Plan
Material Weakness/Noncompliance – Schedule of Expenditures of Federal Awards 2 CFR § 200.510(b) states, in part, 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 as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) 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. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), 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. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $675,306. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided. Officials' Response: See Corrective Action Plan
Material Weakness/Noncompliance – Schedule of Expenditures of Federal Awards 2 CFR § 200.510(b) states, in part, 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 as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) 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. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), 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. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $675,306. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided. Officials' Response: See Corrective Action Plan
Material Weakness/Noncompliance – Schedule of Expenditures of Federal Awards 2 CFR § 200.510(b) states, in part, 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 as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) 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. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), 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. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $675,306. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided. Officials' Response: See Corrective Action Plan
Material Weakness/Noncompliance – Schedule of Expenditures of Federal Awards 2 CFR § 200.510(b) states, in part, 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 as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) 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. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), 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. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $675,306. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided. Officials' Response: See Corrective Action Plan
Material Weakness/Noncompliance – Schedule of Expenditures of Federal Awards 2 CFR § 200.510(b) states, in part, 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 as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) 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. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), 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. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $675,306. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided. Officials' Response: See Corrective Action Plan
Material Weakness/Noncompliance – Schedule of Expenditures of Federal Awards 2 CFR § 200.510(b) states, in part, 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 as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) 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. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), 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. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $675,306. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided. Officials' Response: See Corrective Action Plan
Material Weakness/Noncompliance – Schedule of Expenditures of Federal Awards 2 CFR § 200.510(b) states, in part, 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 as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) 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. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), 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. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $675,306. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided. Officials' Response: See Corrective Action Plan
Material Weakness/Noncompliance – Schedule of Expenditures of Federal Awards 2 CFR § 200.510(b) states, in part, 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 as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) 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. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), 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. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $675,306. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided. Officials' Response: See Corrective Action Plan
Material Weakness/Noncompliance – Schedule of Expenditures of Federal Awards 2 CFR § 200.510(b) states, in part, 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 as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) 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. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), 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. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $675,306. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided. Officials' Response: See Corrective Action Plan
Material Weakness/Noncompliance – Schedule of Expenditures of Federal Awards 2 CFR § 200.510(b) states, in part, 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 as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) 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. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), 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. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $675,306. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided. Officials' Response: See Corrective Action Plan
Material Weakness/Noncompliance – Schedule of Expenditures of Federal Awards 2 CFR § 200.510(b) states, in part, 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 as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) 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. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), 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. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $675,306. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided. Officials' Response: See Corrective Action Plan
Material Weakness/Noncompliance – Schedule of Expenditures of Federal Awards 2 CFR § 200.510(b) states, in part, 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 as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) 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. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), 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. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $675,306. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided. Officials' Response: See Corrective Action Plan
Material Weakness/Noncompliance – Schedule of Expenditures of Federal Awards 2 CFR § 200.510(b) states, in part, 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 as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) 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. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), 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. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $675,306. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided. Officials' Response: See Corrective Action Plan
FINDING NO: 2023-096 (Repeat finding 2022-071) STATE AGENCY: State of Oklahoma FEDERAL AGENCY: US Department of the Treasury ALN: 21.019 FEDERAL PROGRAM NAME: Coronavirus Relief Fund (CRF) FEDERAL AWARD NUMBER: N/A FEDERAL AWARD YEAR: 2023 CONTROL CATEGORY: Subrecipient Monitoring QUESTIONED COSTS: $248,779 Criteria: 2 CFR § 200.303 - Internal controls states in part, “The Non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award.” 2 CFR § 200.332 - Requirements for pass-through entities states in part, “All pass-through entities must: … (b) Ensure that every subaward is clearly identified to the subrecipient as a subaward and includes the information provided below. A pass-through entity must provide the best available information when some of the information below is unavailable. A pass-through entity must provide the unavailable information when it is obtained. Required information includes: (1) Federal award identification. (i) Subrecipient's name (must match the name associated with its unique entity identifier); (ii) Subrecipient's unique entity identifier; (iii) Federal Award Identification Number (FAIN); (iv) Federal Award Date; (v) Subaward Period of Performance Start and End Date; (vi) Subaward Budget Period Start and End Date; (vii) Amount of Federal Funds Obligated in the subaward; (viii) Total Amount of Federal Funds Obligated to the subrecipient by the pass-through entity, including the current financial obligation; (ix) Total Amount of the Federal Award committed to the subrecipient by the pass-through entity; (x) Federal award project description, as required by the Federal Funding Accountability and Transparency Act (FFATA); (xi) Name of the Federal agency, pass-through entity, and contact information for awarding official of the pass-through entity; (xii) Assistance Listings title and number; the pass-through entity must identify the dollar amount made available under each Federal award and the Assistance Listings Number at the time of disbursement; (xiii) Identification of whether the Federal award is for research and development; and (xiv) Indirect cost rate for the Federal award (including if the de minimis rate is used in accordance with § 200.414). (2) All requirements of the subaward, including requirements imposed by Federal statutes, regulations, and the terms and conditions of the Federal award; (3) Any additional requirements that the pass-through entity imposes on the subrecipient for the pass-through entity to meet its responsibilities under the Federal award. This includes information and certifications (see § 200.415) required for submitting financial and performance reports that the pass-through entity must provide to the Federal agency; … (c) Evaluate each subrecipient's fraud risk and risk of noncompliance with a subaward to determine the appropriate subrecipient monitoring described in paragraph (f) of this section. When evaluating a subrecipient's risk, a passthrough entity should consider the following: (1) The subrecipient's prior experience with the same or similar subawards; (2) The results of previous audits. This includes considering whether or not the subrecipient receives a Single Audit in accordance with subpart F and the extent to which the same or similar subawards have been audited as a major program; (3) Whether the subrecipient has new personnel or new or substantially changed systems; and (4) The extent and results of any Federal agency monitoring (for example, if the subrecipient also receives Federal awards directly from the Federal agency). (d) If appropriate, consider implementing specific conditions in a subaward as described in § 200.208 and notify the Federal agency of the specific conditions. (e) Monitor the activities of a subrecipient as necessary to ensure that the subrecipient complies with Federal statutes, regulations, and the terms and conditions of the subaward. The pass-through entity is responsible for monitoring the overall performance of a subrecipient to ensure that the goals and objectives of the subaward are achieved. In monitoring a subrecipient, a pass-through entity must: (1) Review financial and performance reports. (2) Ensure that the subrecipient takes corrective action on all significant developments that negatively affect the subaward. Significant developments include Single Audit findings related to the subaward, other audit findings, site visits, and written notifications from a subrecipient of adverse conditions which will impact their ability to meet the milestones or the objectives of a subaward. When significant developments negatively impact the subaward, a subrecipient must provide the pass-through entity with information on their plan for corrective action and any assistance needed to resolve the situation. (3) Issue a management decision for audit findings pertaining only to the Federal award provided to the subrecipient from the pass-through entity as required by § 200.521. … .” The Department of the Treasury Federal Register, Vol. 86, No. 10 from January 15, 2021 states in part, “The CARES [Coronavirus Aid, Relief, & Economic Security Act] Act provides that payments from the Fund may only be used to cover costs that— 1. are necessary expenditures incurred due to the public health emergency with respect to the Coronavirus Disease 2019 (COVID–19); 2. were not accounted for in the budget most recently approved as of March 27, 2020 (the date of enactment of the CARES Act) for the State or government; and 3. were incurred during the period that begins on March 1, 2020 and ends on December 31, 2021. … This guidance applies in a like manner to costs of subrecipients. Thus, a grant or loan, for example, provided by a recipient using payments from the Fund must be used by the subrecipient only to purchase (or reimburse a purchase of) goods or services for which receipt both is needed within the covered period and occurs within the covered period. The direct recipient of payments from the Fund is ultimately responsible for compliance with this limitation on use of payments from the Fund. Condition and Context: Per the GAAP Package Z - Schedule of Expenditures of Federal Awards (SEFA), the State of Oklahoma reported $249,660.69 in CRF cash basis expenditures reimbursed to subrecipients by the CARES FORWARD1 team. We tested all five (5) reimbursement transactions for one subrecipient and noted the following: • One (20%) of the five (5) transactions totaling $4,594.40 contained no supporting documentation. • Four (80%) of the five (5) transactions totaling $245,066.29 contained costs totaling $244,184.29 that were incurred by the subrecipient after 12/31/2021 (covered period). The State of Oklahoma – CARES FORWARD team failed to perform an adequate review to ensure the subrecipient purchased (or reimbursed a purchase of) goods or services for which receipt both is needed within the covered period and occurs within the covered period. Further, we noted Award documents provided to the subrecipient did not include the terms and conditions of the subaward. Also, the CARES FORWARD team did not perform a risk assessment on subrecipients receiving continued funding during SFY 2023. Lastly, while performing Single Audit monitoring testwork on three (3) subrecipients for SFY 2022, we determined that the State of Oklahoma - CARES FORWARD team did not perform tracking on two (2) of the subrecipients that received CRF funds. For the two subrecipients, there is no documentation to show that OMES received the SFY 2022 Single Audit, evaluated whether the subrecipient took corrective action on all significant developments that affect the subaward, and issued a management decision for any audit findings pertaining to the federal award. Cause: Adequate controls were not in place to ensure the monitoring process utilized by the CARES FORWARD team considered the Department of Treasury guidance when determining whether the financial activities of the subrecipients complied with Federal statutes, regulations, and the terms and conditions of the Federal award prior to payment. Also, the State of Oklahoma – CARES FORWARD2 team did not have sufficient internal controls in place to ensure subrecipient award documentation included the terms and conditions of the subaward in accordance with 2 CFR § 200.332. Further, the State of Oklahoma – CARES FORWARD team did not have sufficient internal controls in place to ensure subrecipients are assessed for risk in accordance with 2 CFR § 200.332. Lastly, the State of Oklahoma – CARES Forward team did not have sufficient internal controls in place to ensure subrecipients are monitored for a Single Audit in accordance with 2 CFR § 200.332. Effect: These deficiencies resulted in questioned costs of $248,779 goods or services for which receipt both was needed and occurred within the covered period. The $248,779 in questioned costs related to subrecipient expenses is included in Finding 2023-108 (Activities Allowed or Unallowed, Allowable Costs/Cost Principles, Period of Performance) as well, as the same transactions failed to meet requirements under all these compliance areas. The amount should not be considered cumulative. The State of Oklahoma – CARES FORWARD team did not comply with 2 CFR § 200.332. Recommendation: We recommend for future grants that the State of Oklahoma strengthen their control process related to subrecipients to ensure compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. Views of Responsible Official(s) Contact Person: Brandy Manek Anticipated Completion Date: September 2022 Corrective Action Planned: The State of Oklahoma/Office of Management and Enterprise Services partially agrees with this finding. See corrective action plan located in the corrective action plan section of the report. Auditor Response: The State Auditor & Inspector’s Office questioned $248,779 to one subrecipient for SFY 2023 based on the expenditures for goods or services both needing to be within the covered period and occurring within the covered period. Therefore, since the subrecipient payments were after the covered period (December 31, 2021), the finding will stand. Further, since there was not a risk assessment performed during the year and the Single Audit tracking was not performed for SFY 2022 for 2 of the 3 subrecipients, the finding will stand.
FINDING NO: 2023-096 (Repeat finding 2022-071) STATE AGENCY: State of Oklahoma FEDERAL AGENCY: US Department of the Treasury ALN: 21.019 FEDERAL PROGRAM NAME: Coronavirus Relief Fund (CRF) FEDERAL AWARD NUMBER: N/A FEDERAL AWARD YEAR: 2023 CONTROL CATEGORY: Subrecipient Monitoring QUESTIONED COSTS: $248,779 Criteria: 2 CFR § 200.303 - Internal controls states in part, “The Non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award.” 2 CFR § 200.332 - Requirements for pass-through entities states in part, “All pass-through entities must: … (b) Ensure that every subaward is clearly identified to the subrecipient as a subaward and includes the information provided below. A pass-through entity must provide the best available information when some of the information below is unavailable. A pass-through entity must provide the unavailable information when it is obtained. Required information includes: (1) Federal award identification. (i) Subrecipient's name (must match the name associated with its unique entity identifier); (ii) Subrecipient's unique entity identifier; (iii) Federal Award Identification Number (FAIN); (iv) Federal Award Date; (v) Subaward Period of Performance Start and End Date; (vi) Subaward Budget Period Start and End Date; (vii) Amount of Federal Funds Obligated in the subaward; (viii) Total Amount of Federal Funds Obligated to the subrecipient by the pass-through entity, including the current financial obligation; (ix) Total Amount of the Federal Award committed to the subrecipient by the pass-through entity; (x) Federal award project description, as required by the Federal Funding Accountability and Transparency Act (FFATA); (xi) Name of the Federal agency, pass-through entity, and contact information for awarding official of the pass-through entity; (xii) Assistance Listings title and number; the pass-through entity must identify the dollar amount made available under each Federal award and the Assistance Listings Number at the time of disbursement; (xiii) Identification of whether the Federal award is for research and development; and (xiv) Indirect cost rate for the Federal award (including if the de minimis rate is used in accordance with § 200.414). (2) All requirements of the subaward, including requirements imposed by Federal statutes, regulations, and the terms and conditions of the Federal award; (3) Any additional requirements that the pass-through entity imposes on the subrecipient for the pass-through entity to meet its responsibilities under the Federal award. This includes information and certifications (see § 200.415) required for submitting financial and performance reports that the pass-through entity must provide to the Federal agency; … (c) Evaluate each subrecipient's fraud risk and risk of noncompliance with a subaward to determine the appropriate subrecipient monitoring described in paragraph (f) of this section. When evaluating a subrecipient's risk, a passthrough entity should consider the following: (1) The subrecipient's prior experience with the same or similar subawards; (2) The results of previous audits. This includes considering whether or not the subrecipient receives a Single Audit in accordance with subpart F and the extent to which the same or similar subawards have been audited as a major program; (3) Whether the subrecipient has new personnel or new or substantially changed systems; and (4) The extent and results of any Federal agency monitoring (for example, if the subrecipient also receives Federal awards directly from the Federal agency). (d) If appropriate, consider implementing specific conditions in a subaward as described in § 200.208 and notify the Federal agency of the specific conditions. (e) Monitor the activities of a subrecipient as necessary to ensure that the subrecipient complies with Federal statutes, regulations, and the terms and conditions of the subaward. The pass-through entity is responsible for monitoring the overall performance of a subrecipient to ensure that the goals and objectives of the subaward are achieved. In monitoring a subrecipient, a pass-through entity must: (1) Review financial and performance reports. (2) Ensure that the subrecipient takes corrective action on all significant developments that negatively affect the subaward. Significant developments include Single Audit findings related to the subaward, other audit findings, site visits, and written notifications from a subrecipient of adverse conditions which will impact their ability to meet the milestones or the objectives of a subaward. When significant developments negatively impact the subaward, a subrecipient must provide the pass-through entity with information on their plan for corrective action and any assistance needed to resolve the situation. (3) Issue a management decision for audit findings pertaining only to the Federal award provided to the subrecipient from the pass-through entity as required by § 200.521. … .” The Department of the Treasury Federal Register, Vol. 86, No. 10 from January 15, 2021 states in part, “The CARES [Coronavirus Aid, Relief, & Economic Security Act] Act provides that payments from the Fund may only be used to cover costs that— 1. are necessary expenditures incurred due to the public health emergency with respect to the Coronavirus Disease 2019 (COVID–19); 2. were not accounted for in the budget most recently approved as of March 27, 2020 (the date of enactment of the CARES Act) for the State or government; and 3. were incurred during the period that begins on March 1, 2020 and ends on December 31, 2021. … This guidance applies in a like manner to costs of subrecipients. Thus, a grant or loan, for example, provided by a recipient using payments from the Fund must be used by the subrecipient only to purchase (or reimburse a purchase of) goods or services for which receipt both is needed within the covered period and occurs within the covered period. The direct recipient of payments from the Fund is ultimately responsible for compliance with this limitation on use of payments from the Fund. Condition and Context: Per the GAAP Package Z - Schedule of Expenditures of Federal Awards (SEFA), the State of Oklahoma reported $249,660.69 in CRF cash basis expenditures reimbursed to subrecipients by the CARES FORWARD1 team. We tested all five (5) reimbursement transactions for one subrecipient and noted the following: • One (20%) of the five (5) transactions totaling $4,594.40 contained no supporting documentation. • Four (80%) of the five (5) transactions totaling $245,066.29 contained costs totaling $244,184.29 that were incurred by the subrecipient after 12/31/2021 (covered period). The State of Oklahoma – CARES FORWARD team failed to perform an adequate review to ensure the subrecipient purchased (or reimbursed a purchase of) goods or services for which receipt both is needed within the covered period and occurs within the covered period. Further, we noted Award documents provided to the subrecipient did not include the terms and conditions of the subaward. Also, the CARES FORWARD team did not perform a risk assessment on subrecipients receiving continued funding during SFY 2023. Lastly, while performing Single Audit monitoring testwork on three (3) subrecipients for SFY 2022, we determined that the State of Oklahoma - CARES FORWARD team did not perform tracking on two (2) of the subrecipients that received CRF funds. For the two subrecipients, there is no documentation to show that OMES received the SFY 2022 Single Audit, evaluated whether the subrecipient took corrective action on all significant developments that affect the subaward, and issued a management decision for any audit findings pertaining to the federal award. Cause: Adequate controls were not in place to ensure the monitoring process utilized by the CARES FORWARD team considered the Department of Treasury guidance when determining whether the financial activities of the subrecipients complied with Federal statutes, regulations, and the terms and conditions of the Federal award prior to payment. Also, the State of Oklahoma – CARES FORWARD2 team did not have sufficient internal controls in place to ensure subrecipient award documentation included the terms and conditions of the subaward in accordance with 2 CFR § 200.332. Further, the State of Oklahoma – CARES FORWARD team did not have sufficient internal controls in place to ensure subrecipients are assessed for risk in accordance with 2 CFR § 200.332. Lastly, the State of Oklahoma – CARES Forward team did not have sufficient internal controls in place to ensure subrecipients are monitored for a Single Audit in accordance with 2 CFR § 200.332. Effect: These deficiencies resulted in questioned costs of $248,779 goods or services for which receipt both was needed and occurred within the covered period. The $248,779 in questioned costs related to subrecipient expenses is included in Finding 2023-108 (Activities Allowed or Unallowed, Allowable Costs/Cost Principles, Period of Performance) as well, as the same transactions failed to meet requirements under all these compliance areas. The amount should not be considered cumulative. The State of Oklahoma – CARES FORWARD team did not comply with 2 CFR § 200.332. Recommendation: We recommend for future grants that the State of Oklahoma strengthen their control process related to subrecipients to ensure compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. Views of Responsible Official(s) Contact Person: Brandy Manek Anticipated Completion Date: September 2022 Corrective Action Planned: The State of Oklahoma/Office of Management and Enterprise Services partially agrees with this finding. See corrective action plan located in the corrective action plan section of the report. Auditor Response: The State Auditor & Inspector’s Office questioned $248,779 to one subrecipient for SFY 2023 based on the expenditures for goods or services both needing to be within the covered period and occurring within the covered period. Therefore, since the subrecipient payments were after the covered period (December 31, 2021), the finding will stand. Further, since there was not a risk assessment performed during the year and the Single Audit tracking was not performed for SFY 2022 for 2 of the 3 subrecipients, the finding will stand.
FINDING NO: 2023-096 (Repeat finding 2022-071) STATE AGENCY: State of Oklahoma FEDERAL AGENCY: US Department of the Treasury ALN: 21.019 FEDERAL PROGRAM NAME: Coronavirus Relief Fund (CRF) FEDERAL AWARD NUMBER: N/A FEDERAL AWARD YEAR: 2023 CONTROL CATEGORY: Subrecipient Monitoring QUESTIONED COSTS: $248,779 Criteria: 2 CFR § 200.303 - Internal controls states in part, “The Non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award.” 2 CFR § 200.332 - Requirements for pass-through entities states in part, “All pass-through entities must: … (b) Ensure that every subaward is clearly identified to the subrecipient as a subaward and includes the information provided below. A pass-through entity must provide the best available information when some of the information below is unavailable. A pass-through entity must provide the unavailable information when it is obtained. Required information includes: (1) Federal award identification. (i) Subrecipient's name (must match the name associated with its unique entity identifier); (ii) Subrecipient's unique entity identifier; (iii) Federal Award Identification Number (FAIN); (iv) Federal Award Date; (v) Subaward Period of Performance Start and End Date; (vi) Subaward Budget Period Start and End Date; (vii) Amount of Federal Funds Obligated in the subaward; (viii) Total Amount of Federal Funds Obligated to the subrecipient by the pass-through entity, including the current financial obligation; (ix) Total Amount of the Federal Award committed to the subrecipient by the pass-through entity; (x) Federal award project description, as required by the Federal Funding Accountability and Transparency Act (FFATA); (xi) Name of the Federal agency, pass-through entity, and contact information for awarding official of the pass-through entity; (xii) Assistance Listings title and number; the pass-through entity must identify the dollar amount made available under each Federal award and the Assistance Listings Number at the time of disbursement; (xiii) Identification of whether the Federal award is for research and development; and (xiv) Indirect cost rate for the Federal award (including if the de minimis rate is used in accordance with § 200.414). (2) All requirements of the subaward, including requirements imposed by Federal statutes, regulations, and the terms and conditions of the Federal award; (3) Any additional requirements that the pass-through entity imposes on the subrecipient for the pass-through entity to meet its responsibilities under the Federal award. This includes information and certifications (see § 200.415) required for submitting financial and performance reports that the pass-through entity must provide to the Federal agency; … (c) Evaluate each subrecipient's fraud risk and risk of noncompliance with a subaward to determine the appropriate subrecipient monitoring described in paragraph (f) of this section. When evaluating a subrecipient's risk, a passthrough entity should consider the following: (1) The subrecipient's prior experience with the same or similar subawards; (2) The results of previous audits. This includes considering whether or not the subrecipient receives a Single Audit in accordance with subpart F and the extent to which the same or similar subawards have been audited as a major program; (3) Whether the subrecipient has new personnel or new or substantially changed systems; and (4) The extent and results of any Federal agency monitoring (for example, if the subrecipient also receives Federal awards directly from the Federal agency). (d) If appropriate, consider implementing specific conditions in a subaward as described in § 200.208 and notify the Federal agency of the specific conditions. (e) Monitor the activities of a subrecipient as necessary to ensure that the subrecipient complies with Federal statutes, regulations, and the terms and conditions of the subaward. The pass-through entity is responsible for monitoring the overall performance of a subrecipient to ensure that the goals and objectives of the subaward are achieved. In monitoring a subrecipient, a pass-through entity must: (1) Review financial and performance reports. (2) Ensure that the subrecipient takes corrective action on all significant developments that negatively affect the subaward. Significant developments include Single Audit findings related to the subaward, other audit findings, site visits, and written notifications from a subrecipient of adverse conditions which will impact their ability to meet the milestones or the objectives of a subaward. When significant developments negatively impact the subaward, a subrecipient must provide the pass-through entity with information on their plan for corrective action and any assistance needed to resolve the situation. (3) Issue a management decision for audit findings pertaining only to the Federal award provided to the subrecipient from the pass-through entity as required by § 200.521. … .” The Department of the Treasury Federal Register, Vol. 86, No. 10 from January 15, 2021 states in part, “The CARES [Coronavirus Aid, Relief, & Economic Security Act] Act provides that payments from the Fund may only be used to cover costs that— 1. are necessary expenditures incurred due to the public health emergency with respect to the Coronavirus Disease 2019 (COVID–19); 2. were not accounted for in the budget most recently approved as of March 27, 2020 (the date of enactment of the CARES Act) for the State or government; and 3. were incurred during the period that begins on March 1, 2020 and ends on December 31, 2021. … This guidance applies in a like manner to costs of subrecipients. Thus, a grant or loan, for example, provided by a recipient using payments from the Fund must be used by the subrecipient only to purchase (or reimburse a purchase of) goods or services for which receipt both is needed within the covered period and occurs within the covered period. The direct recipient of payments from the Fund is ultimately responsible for compliance with this limitation on use of payments from the Fund. Condition and Context: Per the GAAP Package Z - Schedule of Expenditures of Federal Awards (SEFA), the State of Oklahoma reported $249,660.69 in CRF cash basis expenditures reimbursed to subrecipients by the CARES FORWARD1 team. We tested all five (5) reimbursement transactions for one subrecipient and noted the following: • One (20%) of the five (5) transactions totaling $4,594.40 contained no supporting documentation. • Four (80%) of the five (5) transactions totaling $245,066.29 contained costs totaling $244,184.29 that were incurred by the subrecipient after 12/31/2021 (covered period). The State of Oklahoma – CARES FORWARD team failed to perform an adequate review to ensure the subrecipient purchased (or reimbursed a purchase of) goods or services for which receipt both is needed within the covered period and occurs within the covered period. Further, we noted Award documents provided to the subrecipient did not include the terms and conditions of the subaward. Also, the CARES FORWARD team did not perform a risk assessment on subrecipients receiving continued funding during SFY 2023. Lastly, while performing Single Audit monitoring testwork on three (3) subrecipients for SFY 2022, we determined that the State of Oklahoma - CARES FORWARD team did not perform tracking on two (2) of the subrecipients that received CRF funds. For the two subrecipients, there is no documentation to show that OMES received the SFY 2022 Single Audit, evaluated whether the subrecipient took corrective action on all significant developments that affect the subaward, and issued a management decision for any audit findings pertaining to the federal award. Cause: Adequate controls were not in place to ensure the monitoring process utilized by the CARES FORWARD team considered the Department of Treasury guidance when determining whether the financial activities of the subrecipients complied with Federal statutes, regulations, and the terms and conditions of the Federal award prior to payment. Also, the State of Oklahoma – CARES FORWARD2 team did not have sufficient internal controls in place to ensure subrecipient award documentation included the terms and conditions of the subaward in accordance with 2 CFR § 200.332. Further, the State of Oklahoma – CARES FORWARD team did not have sufficient internal controls in place to ensure subrecipients are assessed for risk in accordance with 2 CFR § 200.332. Lastly, the State of Oklahoma – CARES Forward team did not have sufficient internal controls in place to ensure subrecipients are monitored for a Single Audit in accordance with 2 CFR § 200.332. Effect: These deficiencies resulted in questioned costs of $248,779 goods or services for which receipt both was needed and occurred within the covered period. The $248,779 in questioned costs related to subrecipient expenses is included in Finding 2023-108 (Activities Allowed or Unallowed, Allowable Costs/Cost Principles, Period of Performance) as well, as the same transactions failed to meet requirements under all these compliance areas. The amount should not be considered cumulative. The State of Oklahoma – CARES FORWARD team did not comply with 2 CFR § 200.332. Recommendation: We recommend for future grants that the State of Oklahoma strengthen their control process related to subrecipients to ensure compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. Views of Responsible Official(s) Contact Person: Brandy Manek Anticipated Completion Date: September 2022 Corrective Action Planned: The State of Oklahoma/Office of Management and Enterprise Services partially agrees with this finding. See corrective action plan located in the corrective action plan section of the report. Auditor Response: The State Auditor & Inspector’s Office questioned $248,779 to one subrecipient for SFY 2023 based on the expenditures for goods or services both needing to be within the covered period and occurring within the covered period. Therefore, since the subrecipient payments were after the covered period (December 31, 2021), the finding will stand. Further, since there was not a risk assessment performed during the year and the Single Audit tracking was not performed for SFY 2022 for 2 of the 3 subrecipients, the finding will stand.
FINDING NO: 2023-096 (Repeat finding 2022-071) STATE AGENCY: State of Oklahoma FEDERAL AGENCY: US Department of the Treasury ALN: 21.019 FEDERAL PROGRAM NAME: Coronavirus Relief Fund (CRF) FEDERAL AWARD NUMBER: N/A FEDERAL AWARD YEAR: 2023 CONTROL CATEGORY: Subrecipient Monitoring QUESTIONED COSTS: $248,779 Criteria: 2 CFR § 200.303 - Internal controls states in part, “The Non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award.” 2 CFR § 200.332 - Requirements for pass-through entities states in part, “All pass-through entities must: … (b) Ensure that every subaward is clearly identified to the subrecipient as a subaward and includes the information provided below. A pass-through entity must provide the best available information when some of the information below is unavailable. A pass-through entity must provide the unavailable information when it is obtained. Required information includes: (1) Federal award identification. (i) Subrecipient's name (must match the name associated with its unique entity identifier); (ii) Subrecipient's unique entity identifier; (iii) Federal Award Identification Number (FAIN); (iv) Federal Award Date; (v) Subaward Period of Performance Start and End Date; (vi) Subaward Budget Period Start and End Date; (vii) Amount of Federal Funds Obligated in the subaward; (viii) Total Amount of Federal Funds Obligated to the subrecipient by the pass-through entity, including the current financial obligation; (ix) Total Amount of the Federal Award committed to the subrecipient by the pass-through entity; (x) Federal award project description, as required by the Federal Funding Accountability and Transparency Act (FFATA); (xi) Name of the Federal agency, pass-through entity, and contact information for awarding official of the pass-through entity; (xii) Assistance Listings title and number; the pass-through entity must identify the dollar amount made available under each Federal award and the Assistance Listings Number at the time of disbursement; (xiii) Identification of whether the Federal award is for research and development; and (xiv) Indirect cost rate for the Federal award (including if the de minimis rate is used in accordance with § 200.414). (2) All requirements of the subaward, including requirements imposed by Federal statutes, regulations, and the terms and conditions of the Federal award; (3) Any additional requirements that the pass-through entity imposes on the subrecipient for the pass-through entity to meet its responsibilities under the Federal award. This includes information and certifications (see § 200.415) required for submitting financial and performance reports that the pass-through entity must provide to the Federal agency; … (c) Evaluate each subrecipient's fraud risk and risk of noncompliance with a subaward to determine the appropriate subrecipient monitoring described in paragraph (f) of this section. When evaluating a subrecipient's risk, a passthrough entity should consider the following: (1) The subrecipient's prior experience with the same or similar subawards; (2) The results of previous audits. This includes considering whether or not the subrecipient receives a Single Audit in accordance with subpart F and the extent to which the same or similar subawards have been audited as a major program; (3) Whether the subrecipient has new personnel or new or substantially changed systems; and (4) The extent and results of any Federal agency monitoring (for example, if the subrecipient also receives Federal awards directly from the Federal agency). (d) If appropriate, consider implementing specific conditions in a subaward as described in § 200.208 and notify the Federal agency of the specific conditions. (e) Monitor the activities of a subrecipient as necessary to ensure that the subrecipient complies with Federal statutes, regulations, and the terms and conditions of the subaward. The pass-through entity is responsible for monitoring the overall performance of a subrecipient to ensure that the goals and objectives of the subaward are achieved. In monitoring a subrecipient, a pass-through entity must: (1) Review financial and performance reports. (2) Ensure that the subrecipient takes corrective action on all significant developments that negatively affect the subaward. Significant developments include Single Audit findings related to the subaward, other audit findings, site visits, and written notifications from a subrecipient of adverse conditions which will impact their ability to meet the milestones or the objectives of a subaward. When significant developments negatively impact the subaward, a subrecipient must provide the pass-through entity with information on their plan for corrective action and any assistance needed to resolve the situation. (3) Issue a management decision for audit findings pertaining only to the Federal award provided to the subrecipient from the pass-through entity as required by § 200.521. … .” The Department of the Treasury Federal Register, Vol. 86, No. 10 from January 15, 2021 states in part, “The CARES [Coronavirus Aid, Relief, & Economic Security Act] Act provides that payments from the Fund may only be used to cover costs that— 1. are necessary expenditures incurred due to the public health emergency with respect to the Coronavirus Disease 2019 (COVID–19); 2. were not accounted for in the budget most recently approved as of March 27, 2020 (the date of enactment of the CARES Act) for the State or government; and 3. were incurred during the period that begins on March 1, 2020 and ends on December 31, 2021. … This guidance applies in a like manner to costs of subrecipients. Thus, a grant or loan, for example, provided by a recipient using payments from the Fund must be used by the subrecipient only to purchase (or reimburse a purchase of) goods or services for which receipt both is needed within the covered period and occurs within the covered period. The direct recipient of payments from the Fund is ultimately responsible for compliance with this limitation on use of payments from the Fund. Condition and Context: Per the GAAP Package Z - Schedule of Expenditures of Federal Awards (SEFA), the State of Oklahoma reported $249,660.69 in CRF cash basis expenditures reimbursed to subrecipients by the CARES FORWARD1 team. We tested all five (5) reimbursement transactions for one subrecipient and noted the following: • One (20%) of the five (5) transactions totaling $4,594.40 contained no supporting documentation. • Four (80%) of the five (5) transactions totaling $245,066.29 contained costs totaling $244,184.29 that were incurred by the subrecipient after 12/31/2021 (covered period). The State of Oklahoma – CARES FORWARD team failed to perform an adequate review to ensure the subrecipient purchased (or reimbursed a purchase of) goods or services for which receipt both is needed within the covered period and occurs within the covered period. Further, we noted Award documents provided to the subrecipient did not include the terms and conditions of the subaward. Also, the CARES FORWARD team did not perform a risk assessment on subrecipients receiving continued funding during SFY 2023. Lastly, while performing Single Audit monitoring testwork on three (3) subrecipients for SFY 2022, we determined that the State of Oklahoma - CARES FORWARD team did not perform tracking on two (2) of the subrecipients that received CRF funds. For the two subrecipients, there is no documentation to show that OMES received the SFY 2022 Single Audit, evaluated whether the subrecipient took corrective action on all significant developments that affect the subaward, and issued a management decision for any audit findings pertaining to the federal award. Cause: Adequate controls were not in place to ensure the monitoring process utilized by the CARES FORWARD team considered the Department of Treasury guidance when determining whether the financial activities of the subrecipients complied with Federal statutes, regulations, and the terms and conditions of the Federal award prior to payment. Also, the State of Oklahoma – CARES FORWARD2 team did not have sufficient internal controls in place to ensure subrecipient award documentation included the terms and conditions of the subaward in accordance with 2 CFR § 200.332. Further, the State of Oklahoma – CARES FORWARD team did not have sufficient internal controls in place to ensure subrecipients are assessed for risk in accordance with 2 CFR § 200.332. Lastly, the State of Oklahoma – CARES Forward team did not have sufficient internal controls in place to ensure subrecipients are monitored for a Single Audit in accordance with 2 CFR § 200.332. Effect: These deficiencies resulted in questioned costs of $248,779 goods or services for which receipt both was needed and occurred within the covered period. The $248,779 in questioned costs related to subrecipient expenses is included in Finding 2023-108 (Activities Allowed or Unallowed, Allowable Costs/Cost Principles, Period of Performance) as well, as the same transactions failed to meet requirements under all these compliance areas. The amount should not be considered cumulative. The State of Oklahoma – CARES FORWARD team did not comply with 2 CFR § 200.332. Recommendation: We recommend for future grants that the State of Oklahoma strengthen their control process related to subrecipients to ensure compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. Views of Responsible Official(s) Contact Person: Brandy Manek Anticipated Completion Date: September 2022 Corrective Action Planned: The State of Oklahoma/Office of Management and Enterprise Services partially agrees with this finding. See corrective action plan located in the corrective action plan section of the report. Auditor Response: The State Auditor & Inspector’s Office questioned $248,779 to one subrecipient for SFY 2023 based on the expenditures for goods or services both needing to be within the covered period and occurring within the covered period. Therefore, since the subrecipient payments were after the covered period (December 31, 2021), the finding will stand. Further, since there was not a risk assessment performed during the year and the Single Audit tracking was not performed for SFY 2022 for 2 of the 3 subrecipients, the finding will stand.
FINDING NO: 2023-006 (Repeat Finding 2022-018) STATE AGENCY: Oklahoma Department of Human Services FEDERAL AGENCY: Department of Health and Human Services ALN: 93.658 FEDERAL PROGRAM NAME: Foster Care – Title IV-E FEDERAL AWARD NUMBER: 2201OKFOST and 2301OKFOST FEDERAL AWARD YEAR: 2022 and 2023 CONTROL CATEGORY: Subrecipient Monitoring QUESTIONED COSTS: $0 Criteria: 45 CFR §75.303(a) states in part “The Non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).” Per 2 CFR §200.1 Definitions, “Subaward means an award provided by a pass-through entity to a subrecipient for the subrecipient to carry out part of a federal award received by the pass-through entity. It does not include payments to a contractor or payments to an individual that is a beneficiary of a federal program. A subaward may be provided through any form of legal agreement, including an agreement that the pass-through entity considers a contract [emphasis added].” 2 CFR §200.332 Requirements for pass-through entities states in part “All pass-through entities must: (a) Ensure that every subaward is clearly identified to the subrecipient as a subaward and includes the following information at the time of the subaward and if any of these data elements change, include the changes in subsequent subaward modification. When some of this information is not available, the pass-through entity must provide the best information available to describe the Federal award and subaward. Required information includes: (1) Federal award identification. (i) Subrecipient name (which must match the name associated with its unique entity identifier); (ii) Subrecipient's unique entity identifier; (iii) Federal Award Identification Number (FAIN); (iv) Federal Award Date (see the definition of Federal award date in § 200.1 of this part) of award to the recipient by the Federal agency; (v) Subaward Period of Performance Start and End Date; (vi) Subaward Budget Period Start and End Date; (vii) Amount of Federal Funds Obligated by this action by the pass-through entity to the subrecipient; (viii) Total Amount of Federal Funds Obligated to the subrecipient by the pass-through entity including the current financial obligation; (ix) Total Amount of the Federal Award committed to the subrecipient by the pass-through entity; (x) Federal award project description, as required to be responsive to the Federal Funding Accountability and Transparency Act (FFATA); (xi) Name of Federal awarding agency, pass-through entity, and contact information for awarding official of the Pass-through entity; (xii) Assistance Listings number and Title; the pass-through entity must identify the dollar amount made available under each Federal award and the Assistance Listings Number at time of disbursement; (xiii) Identification of whether the award is R&D; and (xiv) Indirect cost rate for the Federal award (including if the de minimis rate is charged) per § 200.414. (2) All requirements imposed by the pass-through entity on the subrecipient so that the Federal award is used in accordance with Federal statutes, regulations and the terms and conditions of the Federal award; (b) Evaluate each subrecipient's risk of noncompliance with Federal statutes, regulations, and the terms and conditions of the subaward for purposes of determining the appropriate subrecipient monitoring described in paragraphs (d) and (e) of this section, which may include consideration of such factors as: (1) The subrecipient's prior experience with the same or similar subawards; (2) The results of previous audits including whether or not the subrecipient receives a Single Audit in accordance with Subpart F of this part, and the extent to which the same or similar subaward has been audited as a major program; (3) Whether the subrecipient has new personnel or new or substantially changed systems; and (4) The extent and results of Federal awarding agency monitoring (e.g., if the subrecipient also receives Federal awards directly from a federal awarding agency).” Condition and Context: We tested 10 of the 10 subrecipient contracts and we noted the following exceptions: • Two of ten (20%) subawards, did not contain the subrecipient’s unique entity identifier, federal award identification number, and federal award date. • One of 10 (10%) subawards, did not include the period of performance in the subaward contract. • One of 10 (10%) subawards, did not include the AL# on the contract. • Ten of ten (100%) subawards did not include the indirect cost rate, or if the indirect cost rate was federally recognized. • Ten of Ten (100%) subawards, did not contain all the information required in accordance with 2CFR section 200.332(a) (1) & (2). For a sample of 2 of the 10 subrecipients, management confirmed the subrecipient risk assessments were not completed until after the end of the fiscal year and thus were not utilized to determine the appropriate subrecipient monitoring to be performed during the fiscal year for those subrecipients. Cause: This is a prior audit finding dating back to SFY2017; DHS Management showed some corrective action has been implemented to address identifying the award and applicable requirements or monitoring as required in 2 CFR 200.332. Management does not properly understand the program requirements. Effect: OKDHS is not in compliance with the monitoring requirements for this program. Therefore, subrecipients may not be spending federal funds in accordance with program requirements. Recommendation: We recommend OKDHS further modify its subrecipient agreements and related documentation to ensure all required award identification is provided. Additionally, we recommend OKDHS perform risk assessments on all subrecipients at the start of the fiscal year to determine the level of monitoring necessary. Views of Responsible Official(s) Contact Person: Kevin Haddock Anticipated Completion Date: February 2025 Corrective Action Planned: The Department of Human Services partially agrees with the finding. Please see the corrective action plan located in the corrective action plan section of this report. Auditor Response: During audit work, program personnel informed SAI staff, that risk assessments are completed at the fiscal year end when they have final draw amounts. There is no date on the risk assessment so we had to rely on the information provided by program personnel.
FINDING NO: 2023-006 (Repeat Finding 2022-018) STATE AGENCY: Oklahoma Department of Human Services FEDERAL AGENCY: Department of Health and Human Services ALN: 93.658 FEDERAL PROGRAM NAME: Foster Care – Title IV-E FEDERAL AWARD NUMBER: 2201OKFOST and 2301OKFOST FEDERAL AWARD YEAR: 2022 and 2023 CONTROL CATEGORY: Subrecipient Monitoring QUESTIONED COSTS: $0 Criteria: 45 CFR §75.303(a) states in part “The Non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).” Per 2 CFR §200.1 Definitions, “Subaward means an award provided by a pass-through entity to a subrecipient for the subrecipient to carry out part of a federal award received by the pass-through entity. It does not include payments to a contractor or payments to an individual that is a beneficiary of a federal program. A subaward may be provided through any form of legal agreement, including an agreement that the pass-through entity considers a contract [emphasis added].” 2 CFR §200.332 Requirements for pass-through entities states in part “All pass-through entities must: (a) Ensure that every subaward is clearly identified to the subrecipient as a subaward and includes the following information at the time of the subaward and if any of these data elements change, include the changes in subsequent subaward modification. When some of this information is not available, the pass-through entity must provide the best information available to describe the Federal award and subaward. Required information includes: (1) Federal award identification. (i) Subrecipient name (which must match the name associated with its unique entity identifier); (ii) Subrecipient's unique entity identifier; (iii) Federal Award Identification Number (FAIN); (iv) Federal Award Date (see the definition of Federal award date in § 200.1 of this part) of award to the recipient by the Federal agency; (v) Subaward Period of Performance Start and End Date; (vi) Subaward Budget Period Start and End Date; (vii) Amount of Federal Funds Obligated by this action by the pass-through entity to the subrecipient; (viii) Total Amount of Federal Funds Obligated to the subrecipient by the pass-through entity including the current financial obligation; (ix) Total Amount of the Federal Award committed to the subrecipient by the pass-through entity; (x) Federal award project description, as required to be responsive to the Federal Funding Accountability and Transparency Act (FFATA); (xi) Name of Federal awarding agency, pass-through entity, and contact information for awarding official of the Pass-through entity; (xii) Assistance Listings number and Title; the pass-through entity must identify the dollar amount made available under each Federal award and the Assistance Listings Number at time of disbursement; (xiii) Identification of whether the award is R&D; and (xiv) Indirect cost rate for the Federal award (including if the de minimis rate is charged) per § 200.414. (2) All requirements imposed by the pass-through entity on the subrecipient so that the Federal award is used in accordance with Federal statutes, regulations and the terms and conditions of the Federal award; (b) Evaluate each subrecipient's risk of noncompliance with Federal statutes, regulations, and the terms and conditions of the subaward for purposes of determining the appropriate subrecipient monitoring described in paragraphs (d) and (e) of this section, which may include consideration of such factors as: (1) The subrecipient's prior experience with the same or similar subawards; (2) The results of previous audits including whether or not the subrecipient receives a Single Audit in accordance with Subpart F of this part, and the extent to which the same or similar subaward has been audited as a major program; (3) Whether the subrecipient has new personnel or new or substantially changed systems; and (4) The extent and results of Federal awarding agency monitoring (e.g., if the subrecipient also receives Federal awards directly from a federal awarding agency).” Condition and Context: We tested 10 of the 10 subrecipient contracts and we noted the following exceptions: • Two of ten (20%) subawards, did not contain the subrecipient’s unique entity identifier, federal award identification number, and federal award date. • One of 10 (10%) subawards, did not include the period of performance in the subaward contract. • One of 10 (10%) subawards, did not include the AL# on the contract. • Ten of ten (100%) subawards did not include the indirect cost rate, or if the indirect cost rate was federally recognized. • Ten of Ten (100%) subawards, did not contain all the information required in accordance with 2CFR section 200.332(a) (1) & (2). For a sample of 2 of the 10 subrecipients, management confirmed the subrecipient risk assessments were not completed until after the end of the fiscal year and thus were not utilized to determine the appropriate subrecipient monitoring to be performed during the fiscal year for those subrecipients. Cause: This is a prior audit finding dating back to SFY2017; DHS Management showed some corrective action has been implemented to address identifying the award and applicable requirements or monitoring as required in 2 CFR 200.332. Management does not properly understand the program requirements. Effect: OKDHS is not in compliance with the monitoring requirements for this program. Therefore, subrecipients may not be spending federal funds in accordance with program requirements. Recommendation: We recommend OKDHS further modify its subrecipient agreements and related documentation to ensure all required award identification is provided. Additionally, we recommend OKDHS perform risk assessments on all subrecipients at the start of the fiscal year to determine the level of monitoring necessary. Views of Responsible Official(s) Contact Person: Kevin Haddock Anticipated Completion Date: February 2025 Corrective Action Planned: The Department of Human Services partially agrees with the finding. Please see the corrective action plan located in the corrective action plan section of this report. Auditor Response: During audit work, program personnel informed SAI staff, that risk assessments are completed at the fiscal year end when they have final draw amounts. There is no date on the risk assessment so we had to rely on the information provided by program personnel.
FINDING NO: 2023-006 (Repeat Finding 2022-018) STATE AGENCY: Oklahoma Department of Human Services FEDERAL AGENCY: Department of Health and Human Services ALN: 93.658 FEDERAL PROGRAM NAME: Foster Care – Title IV-E FEDERAL AWARD NUMBER: 2201OKFOST and 2301OKFOST FEDERAL AWARD YEAR: 2022 and 2023 CONTROL CATEGORY: Subrecipient Monitoring QUESTIONED COSTS: $0 Criteria: 45 CFR §75.303(a) states in part “The Non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).” Per 2 CFR §200.1 Definitions, “Subaward means an award provided by a pass-through entity to a subrecipient for the subrecipient to carry out part of a federal award received by the pass-through entity. It does not include payments to a contractor or payments to an individual that is a beneficiary of a federal program. A subaward may be provided through any form of legal agreement, including an agreement that the pass-through entity considers a contract [emphasis added].” 2 CFR §200.332 Requirements for pass-through entities states in part “All pass-through entities must: (a) Ensure that every subaward is clearly identified to the subrecipient as a subaward and includes the following information at the time of the subaward and if any of these data elements change, include the changes in subsequent subaward modification. When some of this information is not available, the pass-through entity must provide the best information available to describe the Federal award and subaward. Required information includes: (1) Federal award identification. (i) Subrecipient name (which must match the name associated with its unique entity identifier); (ii) Subrecipient's unique entity identifier; (iii) Federal Award Identification Number (FAIN); (iv) Federal Award Date (see the definition of Federal award date in § 200.1 of this part) of award to the recipient by the Federal agency; (v) Subaward Period of Performance Start and End Date; (vi) Subaward Budget Period Start and End Date; (vii) Amount of Federal Funds Obligated by this action by the pass-through entity to the subrecipient; (viii) Total Amount of Federal Funds Obligated to the subrecipient by the pass-through entity including the current financial obligation; (ix) Total Amount of the Federal Award committed to the subrecipient by the pass-through entity; (x) Federal award project description, as required to be responsive to the Federal Funding Accountability and Transparency Act (FFATA); (xi) Name of Federal awarding agency, pass-through entity, and contact information for awarding official of the Pass-through entity; (xii) Assistance Listings number and Title; the pass-through entity must identify the dollar amount made available under each Federal award and the Assistance Listings Number at time of disbursement; (xiii) Identification of whether the award is R&D; and (xiv) Indirect cost rate for the Federal award (including if the de minimis rate is charged) per § 200.414. (2) All requirements imposed by the pass-through entity on the subrecipient so that the Federal award is used in accordance with Federal statutes, regulations and the terms and conditions of the Federal award; (b) Evaluate each subrecipient's risk of noncompliance with Federal statutes, regulations, and the terms and conditions of the subaward for purposes of determining the appropriate subrecipient monitoring described in paragraphs (d) and (e) of this section, which may include consideration of such factors as: (1) The subrecipient's prior experience with the same or similar subawards; (2) The results of previous audits including whether or not the subrecipient receives a Single Audit in accordance with Subpart F of this part, and the extent to which the same or similar subaward has been audited as a major program; (3) Whether the subrecipient has new personnel or new or substantially changed systems; and (4) The extent and results of Federal awarding agency monitoring (e.g., if the subrecipient also receives Federal awards directly from a federal awarding agency).” Condition and Context: We tested 10 of the 10 subrecipient contracts and we noted the following exceptions: • Two of ten (20%) subawards, did not contain the subrecipient’s unique entity identifier, federal award identification number, and federal award date. • One of 10 (10%) subawards, did not include the period of performance in the subaward contract. • One of 10 (10%) subawards, did not include the AL# on the contract. • Ten of ten (100%) subawards did not include the indirect cost rate, or if the indirect cost rate was federally recognized. • Ten of Ten (100%) subawards, did not contain all the information required in accordance with 2CFR section 200.332(a) (1) & (2). For a sample of 2 of the 10 subrecipients, management confirmed the subrecipient risk assessments were not completed until after the end of the fiscal year and thus were not utilized to determine the appropriate subrecipient monitoring to be performed during the fiscal year for those subrecipients. Cause: This is a prior audit finding dating back to SFY2017; DHS Management showed some corrective action has been implemented to address identifying the award and applicable requirements or monitoring as required in 2 CFR 200.332. Management does not properly understand the program requirements. Effect: OKDHS is not in compliance with the monitoring requirements for this program. Therefore, subrecipients may not be spending federal funds in accordance with program requirements. Recommendation: We recommend OKDHS further modify its subrecipient agreements and related documentation to ensure all required award identification is provided. Additionally, we recommend OKDHS perform risk assessments on all subrecipients at the start of the fiscal year to determine the level of monitoring necessary. Views of Responsible Official(s) Contact Person: Kevin Haddock Anticipated Completion Date: February 2025 Corrective Action Planned: The Department of Human Services partially agrees with the finding. Please see the corrective action plan located in the corrective action plan section of this report. Auditor Response: During audit work, program personnel informed SAI staff, that risk assessments are completed at the fiscal year end when they have final draw amounts. There is no date on the risk assessment so we had to rely on the information provided by program personnel.
2023-003 Indirect Cost Allocations - Activities Allowed or Unallowed and Allowable Costs/Cost Principles Federal Program: Research and Development Cluster (ALN 47.041-Engineering, Award 1940055, Award Period 9/1/19 – 3/31/25 and ALN 47.084-Technology, Innovation and Partnerships, Award 1940055, Award Period 9/19/22 – 3/31/25) Federal Agency: National Science Foundation Criteria: Program costs for allocation of indirect costs should be based on percentage of total costs at year end and allocated based on specific allocations of costs incurred and approved in a timely manner as required by 2 CFR 200.414. Condition: Our testing noted that program charges included nine monthly journal entries to allocate indirect costs based on budgeted calculations and one year-end entry to adjust the calculation based on actual results. The entries did not have the necessary review and approvals to ensure allowability of the costs to activities. Cause: The Organization lacks written policies, approval procedures and documentation to allocate indirect costs to the program. Effect: The Organization is not compliant with 2 CFR 2 CFR 200.414 which requires accurate, and complete disclosure of financial results including the allocation of approved and identified actual indirect costs incurred to the program in accordance with 2 CFR 200.414. Without a policy of reviewing and approving indirect costs on a regular basis, there is a risk that unallowable costs are allocated to the program. Identification as a repeat finding, if applicable: The finding is a repeat of Finding 2022-005 in the prior year. Recommendation: We recommend the Organization establish policy and procedures to identify and approve allowable indirect costs chargeable to the program on a monthly basis and report this allocation in the accounting ledger separately from the general expenses of the company. View of Responsible Officials: The Organization has since implemented controls and procedures to allocate indirect costs to program costs based on incurred costs. Monthly allocations are approved by the program administrator and separately reported in the general ledger. Questioned Costs: $202,309 – This is the amount of indirect costs charged to the program.
Program Information: Temporary Assistance for Needy Families (ALN #93.558) Criteria or Specific Requirement (Including Statutory, Regulatory or Other Citation): L. Reporting- The auditee must prepare a schedule of expenditures of Federal awards (the “SEFA”) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For Research and Development (“R&D”), total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the passthrough 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 Assistance Listing number or other identifying number when the Assistance Listing information is not available. For a cluster of programs also provide the total for the cluster. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in 2 CFR 200.502(b), 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. (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in 2 CFR 200.414. Condition: The SEFA, as prepared by management, erroneously excluded certain pass-through federal funds from the State. Cause: Administrative oversight with respect to preparation of the SEFA. Effect or Potential Effect: The original draft SEFA was prepared in error. Questioned Costs: None. Context: The original draft SEFA was prepared in error. Identification as a Repeat Finding: No similar findings noted in the prior year. Recommendation: We recommend that the Alliance enhance its procedures and internal controls with respect to preparation and review of the SEFA. Views of Responsible Officials and Planned Corrective Actions: Grant agreements will be reviewed to confirm if expenditures from pass-through entities are related to federal or state grants, and appropriately include applicable federal grants and pass-through funds in the SEFA.
Federal Programs: 93.224, 93.870 Criteria: As stated in 2 CFR §200.303, the non-Federal entity (i.e. the Center) must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations and terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or in the “Internal Control Integrated Framework” issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). According to 2 CFR §200.414 Subpart F, Appendix IV, Section C.2.f, the provisional and final rates must be negotiated where neither predetermined nor fixed rates are appropriate. Predetermined or fixed rates may replace provisional rates at any time prior to the close of the organization's fiscal year. If that event does not occur, a final rate will be established and upward or downward adjustments will be made based on the actual allowable costs incurred for the period involved. Condition: During our review of the Center's indirect cost rate calculation, we were unable to be provided with a true-of actual indirect costs based on the final rates versus the provisional rate used by the Center. Cause: The Center did not have adequate controls in place to ensure that final rates provided were used to determine if any upward or downward adjustments were necessary. Effect or Potential Effect: Total indirect costs charged by the Center were not in line with the final rates as determined by the oversight agency. Questioned Costs: None. Context: 2 of 3 major programs tested did not have calculated indirect cost rates that agreed with their respective agreements. Identification as a Repeat Finding: 2021-004 Recommendation: We recommend the Center establish an internal control procedure to ensure that once a final rate has been determined, that procedures are applied to true-up the costs for the prior charges on grants and any upward or downward adjustments are properly recorded, reported, and applied to future reimbursement requests.
Federal Programs: 93.224, 93.870 Criteria: As stated in 2 CFR §200.303, the non-Federal entity (i.e. the Center) must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations and terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or in the “Internal Control Integrated Framework” issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). According to 2 CFR §200.414 Subpart F, Appendix IV, Section C.2.f, the provisional and final rates must be negotiated where neither predetermined nor fixed rates are appropriate. Predetermined or fixed rates may replace provisional rates at any time prior to the close of the organization's fiscal year. If that event does not occur, a final rate will be established and upward or downward adjustments will be made based on the actual allowable costs incurred for the period involved. Condition: During our review of the Center's indirect cost rate calculation, we were unable to be provided with a true-of actual indirect costs based on the final rates versus the provisional rate used by the Center. Cause: The Center did not have adequate controls in place to ensure that final rates provided were used to determine if any upward or downward adjustments were necessary. Effect or Potential Effect: Total indirect costs charged by the Center were not in line with the final rates as determined by the oversight agency. Questioned Costs: None. Context: 2 of 3 major programs tested did not have calculated indirect cost rates that agreed with their respective agreements. Identification as a Repeat Finding: 2021-004 Recommendation: We recommend the Center establish an internal control procedure to ensure that once a final rate has been determined, that procedures are applied to true-up the costs for the prior charges on grants and any upward or downward adjustments are properly recorded, reported, and applied to future reimbursement requests.
Federal Programs: 93.224, 93.870 Criteria: As stated in 2 CFR §200.303, the non-Federal entity (i.e. the Center) must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations and terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or in the “Internal Control Integrated Framework” issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). According to 2 CFR §200.414 Subpart F, Appendix IV, Section C.2.f, the provisional and final rates must be negotiated where neither predetermined nor fixed rates are appropriate. Predetermined or fixed rates may replace provisional rates at any time prior to the close of the organization's fiscal year. If that event does not occur, a final rate will be established and upward or downward adjustments will be made based on the actual allowable costs incurred for the period involved. Condition: During our review of the Center's indirect cost rate calculation, we were unable to be provided with a true-of actual indirect costs based on the final rates versus the provisional rate used by the Center. Cause: The Center did not have adequate controls in place to ensure that final rates provided were used to determine if any upward or downward adjustments were necessary. Effect or Potential Effect: Total indirect costs charged by the Center were not in line with the final rates as determined by the oversight agency. Questioned Costs: None. Context: 2 of 3 major programs tested did not have calculated indirect cost rates that agreed with their respective agreements. Identification as a Repeat Finding: 2021-004 Recommendation: We recommend the Center establish an internal control procedure to ensure that once a final rate has been determined, that procedures are applied to true-up the costs for the prior charges on grants and any upward or downward adjustments are properly recorded, reported, and applied to future reimbursement requests.
2 C.F.R. Subpart F 200.510(b) requires that the auditee prepare a Schedule of Expenditures of Federal Awards (the Schedule) for the period covered by the County'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. 2 CFR Part 170 "subaward" has the meaning given in 2 CFR 200.1 and means an award provided by a pass-through entity to a subrecipient for the subrecipient to carry out part of a federal award received by the pass-through entity. It does not include payments to a contractor or payments to an individual that is a beneficiary of a federal program. A subaward may be provided through any form of legal agreement, including an agreement that the pass-through entity considers a contract. The County's Federal Schedule had the following error: Funds provided to subrecipients for the Coronavirus State and Local Fiscal Recovery Funds (AL 21.027) were understated by $3,000,000. Errors and omissions to the Schedule of Expenditures of Federal Awards could adversely affect future grant awards in addition to causing an inaccurate assessment of major federal programs that would be subjected to audit. Adjustments, to which management have agreed, are reflected in the accompanying Schedule. County management should review all grant and loan awards and be familiar with federal reporting requirements. The County 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 may help ensure the Schedule is complete and accurate and major federal programs are correctly identified for audit.