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 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 pinion 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 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
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 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 pinion 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 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
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 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 pinion 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 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
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 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 pinion 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 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
2 CFR § 2900.4 gives regulatory effect to the U.S. Department of Labor for 2 CFR § 200.332(a)(3)
which requires a pass-through entity to impose any additional requirements on the subrecipient
necessary 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. Additionally, Ohio Admin. Code 5101:9- 7-29 (D)(2)(c) requires WIOA local areas to
submit the completed quarterly financial statement to the Bureau of County Finance and
Technical Assistance (BCFTA) no later than the tenth calendar day of the second month following the
quarter the report represents. Ohio Admin. Code 5101:9-7-29 further requires the fiscal agent to
reconcile any difference between the WIOA local area's financial records and financial data
submitted to BCFTA via CFIS.
The following issues were noted related to the quarterly submissions:
1. The quarterly financial certification for the fourth quarter of calendar year 2018
was not filed until February 13, 2019, the third quarter of calendar year 2020 was
not filed until at least November 17, 2020. Both of these were considered late filings.
2. For all submissions in fiscal years 2019, 2020, and 2021, the fiscal agent was unable to
provide system reports from their accounting system that reconciled to the actual financial data
(i.e. beginning balances, revenues, expenses, ending balances) submitted to BCFTA via CFIS.
Instead, for 2019 and 2020, the fiscal agent provided only manually maintained records of
undetailed transactions to support the amounts they reported on the financial reports. Then for
2021, they provided nothing to support what was reported.
3. For all submissions in fiscal years 2019, 2020, and 2021, the fiscal agent was unable to
provide any support for the amounts they reported as accruals on the certifications.
This could lead to questions regarding accuracy of the amounts reported to Ohio Department of Job
and Family Services.
The Consortium should implement procedures to ensure quarterly reports are filed no later than the
tenth calendar day of the second month following the quarter the report represents. In addition,
all data reported thru these quarterly reports should be supported by the accounting system of the Fiscal Agent.
2 CFR § 2900.4 gives regulatory effect to the U.S. Department of Labor for 2 CFR § 200.332(a)(3)
which requires a pass-through entity to impose any additional requirements on the subrecipient
necessary 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. Additionally, Ohio Admin. Code 5101:9- 7-29 (D)(2)(c) requires WIOA local areas to
submit the completed quarterly financial statement to the Bureau of County Finance and
Technical Assistance (BCFTA) no later than the tenth calendar day of the second month following the
quarter the report represents. Ohio Admin. Code 5101:9-7-29 further requires the fiscal agent to
reconcile any difference between the WIOA local area's financial records and financial data
submitted to BCFTA via CFIS.
The following issues were noted related to the quarterly submissions:
1. The quarterly financial certification for the fourth quarter of calendar year 2018
was not filed until February 13, 2019, the third quarter of calendar year 2020 was
not filed until at least November 17, 2020. Both of these were considered late filings.
2. For all submissions in fiscal years 2019, 2020, and 2021, the fiscal agent was unable to
provide system reports from their accounting system that reconciled to the actual financial data
(i.e. beginning balances, revenues, expenses, ending balances) submitted to BCFTA via CFIS.
Instead, for 2019 and 2020, the fiscal agent provided only manually maintained records of
undetailed transactions to support the amounts they reported on the financial reports. Then for
2021, they provided nothing to support what was reported.
3. For all submissions in fiscal years 2019, 2020, and 2021, the fiscal agent was unable to
provide any support for the amounts they reported as accruals on the certifications.
This could lead to questions regarding accuracy of the amounts reported to Ohio Department of Job
and Family Services.
The Consortium should implement procedures to ensure quarterly reports are filed no later than the
tenth calendar day of the second month following the quarter the report represents. In addition,
all data reported thru these quarterly reports should be supported by the accounting system of the Fiscal Agent.
2 CFR § 2900.4 gives regulatory effect to the U.S. Department of Labor for 2 CFR § 200.332(a)(3)
which requires a pass-through entity to impose any additional requirements on the subrecipient
necessary 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. Additionally, Ohio Admin. Code 5101:9- 7-29 (D)(2)(c) requires WIOA local areas to
submit the completed quarterly financial statement to the Bureau of County Finance and
Technical Assistance (BCFTA) no later than the tenth calendar day of the second month following the
quarter the report represents. Ohio Admin. Code 5101:9-7-29 further requires the fiscal agent to
reconcile any difference between the WIOA local area's financial records and financial data
submitted to BCFTA via CFIS.
The following issues were noted related to the quarterly submissions:
1. The quarterly financial certification for the fourth quarter of calendar year 2018
was not filed until February 13, 2019, the third quarter of calendar year 2020 was
not filed until at least November 17, 2020. Both of these were considered late filings.
2. For all submissions in fiscal years 2019, 2020, and 2021, the fiscal agent was unable to
provide system reports from their accounting system that reconciled to the actual financial data
(i.e. beginning balances, revenues, expenses, ending balances) submitted to BCFTA via CFIS.
Instead, for 2019 and 2020, the fiscal agent provided only manually maintained records of
undetailed transactions to support the amounts they reported on the financial reports. Then for
2021, they provided nothing to support what was reported.
3. For all submissions in fiscal years 2019, 2020, and 2021, the fiscal agent was unable to
provide any support for the amounts they reported as accruals on the certifications.
This could lead to questions regarding accuracy of the amounts reported to Ohio Department of Job
and Family Services.
The Consortium should implement procedures to ensure quarterly reports are filed no later than the
tenth calendar day of the second month following the quarter the report represents. In addition,
all data reported thru these quarterly reports should be supported by the accounting system of the Fiscal Agent.
2 CFR § 2900.4 gives regulatory effect to the U.S. Department of Labor for 2 CFR § 200.332(a)(3)
which requires a pass-through entity to impose any additional requirements on the subrecipient
necessary 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. Additionally, Ohio Admin. Code 5101:9- 7-29 (D)(2)(c) requires WIOA local areas to
submit the completed quarterly financial statement to the Bureau of County Finance and
Technical Assistance (BCFTA) no later than the tenth calendar day of the second month following the
quarter the report represents. Ohio Admin. Code 5101:9-7-29 further requires the fiscal agent to
reconcile any difference between the WIOA local area's financial records and financial data
submitted to BCFTA via CFIS.
The following issues were noted related to the quarterly submissions:
1. The quarterly financial certification for the fourth quarter of calendar year 2018
was not filed until February 13, 2019, the third quarter of calendar year 2020 was
not filed until at least November 17, 2020. Both of these were considered late filings.
2. For all submissions in fiscal years 2019, 2020, and 2021, the fiscal agent was unable to
provide system reports from their accounting system that reconciled to the actual financial data
(i.e. beginning balances, revenues, expenses, ending balances) submitted to BCFTA via CFIS.
Instead, for 2019 and 2020, the fiscal agent provided only manually maintained records of
undetailed transactions to support the amounts they reported on the financial reports. Then for
2021, they provided nothing to support what was reported.
3. For all submissions in fiscal years 2019, 2020, and 2021, the fiscal agent was unable to
provide any support for the amounts they reported as accruals on the certifications.
This could lead to questions regarding accuracy of the amounts reported to Ohio Department of Job
and Family Services.
The Consortium should implement procedures to ensure quarterly reports are filed no later than the
tenth calendar day of the second month following the quarter the report represents. In addition,
all data reported thru these quarterly reports should be supported by the accounting system of the Fiscal Agent.
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 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 pinion 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 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
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 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 pinion 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 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
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 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 pinion 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 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
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 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 pinion 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 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
2 CFR § 2900.4 gives regulatory effect to the U.S. Department of Labor for 2 CFR § 200.332(a)(3)
which requires a pass-through entity to impose any additional requirements on the subrecipient
necessary 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. Additionally, Ohio Admin. Code 5101:9- 7-29 (D)(2)(c) requires WIOA local areas to
submit the completed quarterly financial statement to the Bureau of County Finance and
Technical Assistance (BCFTA) no later than the tenth calendar day of the second month following the
quarter the report represents. Ohio Admin. Code 5101:9-7-29 further requires the fiscal agent to
reconcile any difference between the WIOA local area's financial records and financial data
submitted to BCFTA via CFIS.
The following issues were noted related to the quarterly submissions:
1. The quarterly financial certification for the fourth quarter of calendar year 2018
was not filed until February 13, 2019, the third quarter of calendar year 2020 was
not filed until at least November 17, 2020. Both of these were considered late filings.
2. For all submissions in fiscal years 2019, 2020, and 2021, the fiscal agent was unable to
provide system reports from their accounting system that reconciled to the actual financial data
(i.e. beginning balances, revenues, expenses, ending balances) submitted to BCFTA via CFIS.
Instead, for 2019 and 2020, the fiscal agent provided only manually maintained records of
undetailed transactions to support the amounts they reported on the financial reports. Then for
2021, they provided nothing to support what was reported.
3. For all submissions in fiscal years 2019, 2020, and 2021, the fiscal agent was unable to
provide any support for the amounts they reported as accruals on the certifications.
This could lead to questions regarding accuracy of the amounts reported to Ohio Department of Job
and Family Services.
The Consortium should implement procedures to ensure quarterly reports are filed no later than the
tenth calendar day of the second month following the quarter the report represents. In addition,
all data reported thru these quarterly reports should be supported by the accounting system of the Fiscal Agent.
2 CFR § 2900.4 gives regulatory effect to the U.S. Department of Labor for 2 CFR § 200.332(a)(3)
which requires a pass-through entity to impose any additional requirements on the subrecipient
necessary 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. Additionally, Ohio Admin. Code 5101:9- 7-29 (D)(2)(c) requires WIOA local areas to
submit the completed quarterly financial statement to the Bureau of County Finance and
Technical Assistance (BCFTA) no later than the tenth calendar day of the second month following the
quarter the report represents. Ohio Admin. Code 5101:9-7-29 further requires the fiscal agent to
reconcile any difference between the WIOA local area's financial records and financial data
submitted to BCFTA via CFIS.
The following issues were noted related to the quarterly submissions:
1. The quarterly financial certification for the fourth quarter of calendar year 2018
was not filed until February 13, 2019, the third quarter of calendar year 2020 was
not filed until at least November 17, 2020. Both of these were considered late filings.
2. For all submissions in fiscal years 2019, 2020, and 2021, the fiscal agent was unable to
provide system reports from their accounting system that reconciled to the actual financial data
(i.e. beginning balances, revenues, expenses, ending balances) submitted to BCFTA via CFIS.
Instead, for 2019 and 2020, the fiscal agent provided only manually maintained records of
undetailed transactions to support the amounts they reported on the financial reports. Then for
2021, they provided nothing to support what was reported.
3. For all submissions in fiscal years 2019, 2020, and 2021, the fiscal agent was unable to
provide any support for the amounts they reported as accruals on the certifications.
This could lead to questions regarding accuracy of the amounts reported to Ohio Department of Job
and Family Services.
The Consortium should implement procedures to ensure quarterly reports are filed no later than the
tenth calendar day of the second month following the quarter the report represents. In addition,
all data reported thru these quarterly reports should be supported by the accounting system of the Fiscal Agent.
2 CFR § 2900.4 gives regulatory effect to the U.S. Department of Labor for 2 CFR § 200.332(a)(3)
which requires a pass-through entity to impose any additional requirements on the subrecipient
necessary 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. Additionally, Ohio Admin. Code 5101:9- 7-29 (D)(2)(c) requires WIOA local areas to
submit the completed quarterly financial statement to the Bureau of County Finance and
Technical Assistance (BCFTA) no later than the tenth calendar day of the second month following the
quarter the report represents. Ohio Admin. Code 5101:9-7-29 further requires the fiscal agent to
reconcile any difference between the WIOA local area's financial records and financial data
submitted to BCFTA via CFIS.
The following issues were noted related to the quarterly submissions:
1. The quarterly financial certification for the fourth quarter of calendar year 2018
was not filed until February 13, 2019, the third quarter of calendar year 2020 was
not filed until at least November 17, 2020. Both of these were considered late filings.
2. For all submissions in fiscal years 2019, 2020, and 2021, the fiscal agent was unable to
provide system reports from their accounting system that reconciled to the actual financial data
(i.e. beginning balances, revenues, expenses, ending balances) submitted to BCFTA via CFIS.
Instead, for 2019 and 2020, the fiscal agent provided only manually maintained records of
undetailed transactions to support the amounts they reported on the financial reports. Then for
2021, they provided nothing to support what was reported.
3. For all submissions in fiscal years 2019, 2020, and 2021, the fiscal agent was unable to
provide any support for the amounts they reported as accruals on the certifications.
This could lead to questions regarding accuracy of the amounts reported to Ohio Department of Job
and Family Services.
The Consortium should implement procedures to ensure quarterly reports are filed no later than the
tenth calendar day of the second month following the quarter the report represents. In addition,
all data reported thru these quarterly reports should be supported by the accounting system of the Fiscal Agent.
2 CFR § 2900.4 gives regulatory effect to the U.S. Department of Labor for 2 CFR § 200.332(a)(3)
which requires a pass-through entity to impose any additional requirements on the subrecipient
necessary 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. Additionally, Ohio Admin. Code 5101:9- 7-29 (D)(2)(c) requires WIOA local areas to
submit the completed quarterly financial statement to the Bureau of County Finance and
Technical Assistance (BCFTA) no later than the tenth calendar day of the second month following the
quarter the report represents. Ohio Admin. Code 5101:9-7-29 further requires the fiscal agent to
reconcile any difference between the WIOA local area's financial records and financial data
submitted to BCFTA via CFIS.
The following issues were noted related to the quarterly submissions:
1. The quarterly financial certification for the fourth quarter of calendar year 2018
was not filed until February 13, 2019, the third quarter of calendar year 2020 was
not filed until at least November 17, 2020. Both of these were considered late filings.
2. For all submissions in fiscal years 2019, 2020, and 2021, the fiscal agent was unable to
provide system reports from their accounting system that reconciled to the actual financial data
(i.e. beginning balances, revenues, expenses, ending balances) submitted to BCFTA via CFIS.
Instead, for 2019 and 2020, the fiscal agent provided only manually maintained records of
undetailed transactions to support the amounts they reported on the financial reports. Then for
2021, they provided nothing to support what was reported.
3. For all submissions in fiscal years 2019, 2020, and 2021, the fiscal agent was unable to
provide any support for the amounts they reported as accruals on the certifications.
This could lead to questions regarding accuracy of the amounts reported to Ohio Department of Job
and Family Services.
The Consortium should implement procedures to ensure quarterly reports are filed no later than the
tenth calendar day of the second month following the quarter the report represents. In addition,
all data reported thru these quarterly reports should be supported by the accounting system of the Fiscal Agent.