CONDITION: The District did not properly record its federal program expenditures for the GEER, ESSER, and ARP ESSER federal grant programs using the various federal funding source expenditure codes as prescribed by the Chart of Accounts for PA Local Educational Agencies maintained by the PA Office of the Budget, Office of Comptroller Operations. CRITERIA: The Pennsylvania Department of Education (PDE), through the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts requires School Districts to utilize specific funding source codes for federal program expenditures. In addition, Section 2 CFR 200.302(a) and 302(b) of the Uniform Guidance requires non-federal organizations such as the School District to maintain financial records which account for federal funds in such a manner as to be able to properly track the identification and use of federal funds. EFFECT: By not using federal source codes to properly track its federal program expenditures for the GEER, ESSER, and ARP ESSER federal grant programs, the School District did not comply with the financial reporting standards for federal program expenditures as prescribed by the Pennsylvania Department of Education, through the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts and Section 2 CFR 200.302(a) and 302(b) of the Uniform Guidance. This situation significantly reduced the District’s internal controls over the ability to properly manage and account for these federal program expenditures in accordance with the compliance requirements of PDE and the Uniform Guidance. CAUSE: Management used proper funding source codes for the revenues received under the GEER, ESSER, and ARP ESSER federal grant programs, but erroneously did not realize the federal funding source coding applied to expenditures as well. QUESTIONED COSTS: None RECOMMENDATION: I am recommending that the School District properly follow the guidance contained within the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts for recording all expenditures of the School District, most specifically, federal program grant expenditures to 1) enhance internal controls for tracking and monitoring federal program expenditures and 2) comply with the recordkeeping requirements for federal funds as specified in Section 2 CFR Part 200.302(a) and 302(b) of the Uniform Guidance and PDE regulations. VIEWS OF RESPONSIBLE OFFICIALS: The School District concurs with the above noted finding and addresses this issue in the ‘Corrective Action Plan’ included within this report.
CONDITION: During my sample review of the District’s completion of its federal grant program ‘Quarterly Cash On Hand Reconciliations’ for the 3rd and 4th fiscal quarters for the GEER grant and the 4th fiscal quarter for the ESSER II grant, I noted that the amounts reported to date for ‘total disbursements’ could not be ascertained from the coding of these expenditures in the District’s general ledger (See Finding 2021-005) and did not reconcile to the separate spreadsheets maintained by the School District. CRITERIA: Section 2 CFR 200.302(a) and 302(b) of the Uniform Guidance requires non-federal organizations such as the School District to maintain financial records which account for federal funds in such a manner as to be able to properly track the identification and use of federal funds.
EFFECT: The School District did not comply with Section 2 CFR 200.302(a) and 302(b) of the Uniform Guidance which prescribes the proper financial management system for the tracking of federal program expenditures.
CAUSE: The School District did not utilize the federal source code tracking system as prescribed by the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts, which would have enabled the District to print reports from the accounting software system, by federal source program, to properly prepare the quarterly reconciliations. It was not readily determinable as to why the ‘total disbursements’ line on the quarterly cash on hand reconciliations did not match the separate spreadsheets the School District utilized for tracking federal program expenditures.
QUESTIONED COSTS: None
RECOMMENDATION: I am recommending that the School District properly follow the guidance contained within the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts for recording all expenditures of the School District, most specifically, federal program grant expenditures to comply with the recordkeeping requirements for federal funds as specified in Section 2 CFR Part 200.302(a) and 302(b) of the Uniform Guidance, to allow for the proper completion of the ‘quarterly cash on hand reconciliations’.
VIEWS OF RESPONSIBLE OFFICIALS: The School District concurs with the above noted finding and addresses this issue in the ‘Corrective Action Plan’ included within this report.
CONDITION: The District did not properly record its federal program expenditures for the GEER, ESSER, and ARP ESSER federal grant programs using the various federal funding source expenditure codes as prescribed by the Chart of Accounts for PA Local Educational Agencies maintained by the PA Office of the Budget, Office of Comptroller Operations. CRITERIA: The Pennsylvania Department of Education (PDE), through the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts requires School Districts to utilize specific funding source codes for federal program expenditures. In addition, Section 2 CFR 200.302(a) and 302(b) of the Uniform Guidance requires non-federal organizations such as the School District to maintain financial records which account for federal funds in such a manner as to be able to properly track the identification and use of federal funds. EFFECT: By not using federal source codes to properly track its federal program expenditures for the GEER, ESSER, and ARP ESSER federal grant programs, the School District did not comply with the financial reporting standards for federal program expenditures as prescribed by the Pennsylvania Department of Education, through the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts and Section 2 CFR 200.302(a) and 302(b) of the Uniform Guidance. This situation significantly reduced the District’s internal controls over the ability to properly manage and account for these federal program expenditures in accordance with the compliance requirements of PDE and the Uniform Guidance. CAUSE: Management used proper funding source codes for the revenues received under the GEER, ESSER, and ARP ESSER federal grant programs, but erroneously did not realize the federal funding source coding applied to expenditures as well. QUESTIONED COSTS: None RECOMMENDATION: I am recommending that the School District properly follow the guidance contained within the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts for recording all expenditures of the School District, most specifically, federal program grant expenditures to 1) enhance internal controls for tracking and monitoring federal program expenditures and 2) comply with the recordkeeping requirements for federal funds as specified in Section 2 CFR Part 200.302(a) and 302(b) of the Uniform Guidance and PDE regulations. VIEWS OF RESPONSIBLE OFFICIALS: The School District concurs with the above noted finding and addresses this issue in the ‘Corrective Action Plan’ included within this report.
CONDITION: During my sample review of the District’s completion of its federal grant program ‘Quarterly Cash On Hand Reconciliations’ for the 3rd and 4th fiscal quarters for the GEER grant and the 4th fiscal quarter for the ESSER II grant, I noted that the amounts reported to date for ‘total disbursements’ could not be ascertained from the coding of these expenditures in the District’s general ledger (See Finding 2021-005) and did not reconcile to the separate spreadsheets maintained by the School District. CRITERIA: Section 2 CFR 200.302(a) and 302(b) of the Uniform Guidance requires non-federal organizations such as the School District to maintain financial records which account for federal funds in such a manner as to be able to properly track the identification and use of federal funds.
EFFECT: The School District did not comply with Section 2 CFR 200.302(a) and 302(b) of the Uniform Guidance which prescribes the proper financial management system for the tracking of federal program expenditures.
CAUSE: The School District did not utilize the federal source code tracking system as prescribed by the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts, which would have enabled the District to print reports from the accounting software system, by federal source program, to properly prepare the quarterly reconciliations. It was not readily determinable as to why the ‘total disbursements’ line on the quarterly cash on hand reconciliations did not match the separate spreadsheets the School District utilized for tracking federal program expenditures.
QUESTIONED COSTS: None
RECOMMENDATION: I am recommending that the School District properly follow the guidance contained within the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts for recording all expenditures of the School District, most specifically, federal program grant expenditures to comply with the recordkeeping requirements for federal funds as specified in Section 2 CFR Part 200.302(a) and 302(b) of the Uniform Guidance, to allow for the proper completion of the ‘quarterly cash on hand reconciliations’.
VIEWS OF RESPONSIBLE OFFICIALS: The School District concurs with the above noted finding and addresses this issue in the ‘Corrective Action Plan’ included within this report.
CONDITION: During my review of the District’s compliance with the requirements for noncompetitive procurement, I noted the District did not document its rationale for purchases made from ‘CJAWS, Inc.’ totaling $140,389.
CRITERIA: In accordance with Section 2 CFR 200.318(i) of the Uniform Guidance, the District must maintain records sufficient to detail the history of procurement. These records include but are not limited to the rationale for the method of procurement, selection of contract type, contractor selection or rejection, and the basis for the contract price. Furthermore, Section 2 CFR 200.320(c’) of the Uniform Guidance details five (5) circumstances in which noncompetitive procurement can be used.
EFFECT: The District did not comply with Section 2 CFR 200.318(i) and Section 2 CFR 200.320(c’) of the Uniform Guidance regarding the proper documentation required for noncompetitive procurement.
QUESTIONED COST: $140,389
CAUSE: From a review of the School District’s policies as published on the District’s website, the District has not updated their policies to include those related to ‘federal fiscal compliance’ in accordance with the Uniform Guidance, in particular, procurement policies to address the requirements of Section 2 CFR 200.318(i) and 320(c).
RECOMMENDATION: I recommend that the School District update their policies to include those most recent related to ‘federal fiscal compliance’ in accordance with the Uniform Guidance, in particular, procurement policies to address the requirements of Section 2 CFR 200.318(i) and 320(c). In addition, I would recommend that District personnel responsible for expenditures related to federal funding receive updated training related to ‘procurement’ policies and procedures as they relate to federal funding.
VIEWS OF RESPONSIBLE OFFICIALS: The School District concurs with the above noted finding and addresses this issue in the ‘Corrective Action Plan’ included within this report.
CONDITION: The Cambria Heights School District contracted with a third-party vendor (Trafera) for the purchase of technology equipment. The contract with Trafera was procured through a cooperative purchasing group (COSTARS). The District did not obtain an adequate number of price or rate quotations for the technology equipment as required by the Uniform Guidance and 24 PS 8.807.1.
CRITERIA: As specified in Section 2 CFR 200. 318(i) of the Uniform Guidance, the District must maintain records sufficient to detail the history of procurement. These records will include, but are not necessarily limited to, the following: rationale for the method of procurement, selection of contract type, contractor selection or rejection, and the basis for the contract price. In addition, small purchase procedures per Section 2 CFR 200.320(a)(2)(i) for acquisitions between the micro-purchase threshold (currently $10,000) and the simplified acquisition threshold (current $250,000), price or rate quotations must be obtained from an adequate number of qualified sources as determined appropriate. Per 24 PS 8.807.1, there should be three quotes that are either written or well documented. The use of COSTARS only constitutes one quotation.
CAUSE: School District personnel directly responsible for the acquisition of the technology equipment through COSTARS interpreted that the requirements specified by Section 2 CFR 200.318(i) and Section 2 CFR 200.320(a)(2)(i), would be met by using this cooperative purchasing organization.
EFFECT: The School District did not comply with the requirements of 2 CFR 200.318(i) and 2 CFR 200.320(a)(2)(i) of the Uniform Guidance, and 24 PS 8.807.1, regarding maintaining records sufficient to detail the history of procurement for the technology equipment to ensure that an adequate number of price quotations were solicited for this purchase.
QUESTIONED COST: $106,250
RECOMMENDATION: I recommend that the School District update their policies to include those most recent related to ‘federal fiscal compliance’ in accordance with the Uniform Guidance, in particular, procurement policies to address the requirements of Section 2 CFR 200.318(i) and 2 CFR.320(a)(2)(i). In addition, I would recommend that District personnel responsible for expenditures related to federal funding receive updated training related to ‘procurement’ policies and procedures as they relate to federal funding.
VIEWS OF RESPONSIBLE OFFICIALS: The School District concurs with the above noted finding and addresses this issue in the ‘Corrective Action Plan’ included within this report.
CONDITION: The District did not properly record its federal program expenditures for the GEER, ESSER, and ARP ESSER federal grant programs using the various federal funding source expenditure codes as prescribed by the Chart of Accounts for PA Local Educational Agencies maintained by the PA Office of the Budget, Office of Comptroller Operations. CRITERIA: The Pennsylvania Department of Education (PDE), through the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts requires School Districts to utilize specific funding source codes for federal program expenditures. In addition, Section 2 CFR 200.302(a) and 302(b) of the Uniform Guidance requires non-federal organizations such as the School District to maintain financial records which account for federal funds in such a manner as to be able to properly track the identification and use of federal funds. EFFECT: By not using federal source codes to properly track its federal program expenditures for the GEER, ESSER, and ARP ESSER federal grant programs, the School District did not comply with the financial reporting standards for federal program expenditures as prescribed by the Pennsylvania Department of Education, through the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts and Section 2 CFR 200.302(a) and 302(b) of the Uniform Guidance. This situation significantly reduced the District’s internal controls over the ability to properly manage and account for these federal program expenditures in accordance with the compliance requirements of PDE and the Uniform Guidance. CAUSE: Management used proper funding source codes for the revenues received under the GEER, ESSER, and ARP ESSER federal grant programs, but erroneously did not realize the federal funding source coding applied to expenditures as well. QUESTIONED COSTS: None RECOMMENDATION: I am recommending that the School District properly follow the guidance contained within the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts for recording all expenditures of the School District, most specifically, federal program grant expenditures to 1) enhance internal controls for tracking and monitoring federal program expenditures and 2) comply with the recordkeeping requirements for federal funds as specified in Section 2 CFR Part 200.302(a) and 302(b) of the Uniform Guidance and PDE regulations. VIEWS OF RESPONSIBLE OFFICIALS: The School District concurs with the above noted finding and addresses this issue in the ‘Corrective Action Plan’ included within this report.
CONDITION: During my sample review of the District’s completion of its federal grant program ‘Quarterly Cash On Hand Reconciliations’ for the 3rd and 4th fiscal quarters for the GEER grant and the 4th fiscal quarter for the ESSER II grant, I noted that the amounts reported to date for ‘total disbursements’ could not be ascertained from the coding of these expenditures in the District’s general ledger (See Finding 2021-005) and did not reconcile to the separate spreadsheets maintained by the School District. CRITERIA: Section 2 CFR 200.302(a) and 302(b) of the Uniform Guidance requires non-federal organizations such as the School District to maintain financial records which account for federal funds in such a manner as to be able to properly track the identification and use of federal funds.
EFFECT: The School District did not comply with Section 2 CFR 200.302(a) and 302(b) of the Uniform Guidance which prescribes the proper financial management system for the tracking of federal program expenditures.
CAUSE: The School District did not utilize the federal source code tracking system as prescribed by the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts, which would have enabled the District to print reports from the accounting software system, by federal source program, to properly prepare the quarterly reconciliations. It was not readily determinable as to why the ‘total disbursements’ line on the quarterly cash on hand reconciliations did not match the separate spreadsheets the School District utilized for tracking federal program expenditures.
QUESTIONED COSTS: None
RECOMMENDATION: I am recommending that the School District properly follow the guidance contained within the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts for recording all expenditures of the School District, most specifically, federal program grant expenditures to comply with the recordkeeping requirements for federal funds as specified in Section 2 CFR Part 200.302(a) and 302(b) of the Uniform Guidance, to allow for the proper completion of the ‘quarterly cash on hand reconciliations’.
VIEWS OF RESPONSIBLE OFFICIALS: The School District concurs with the above noted finding and addresses this issue in the ‘Corrective Action Plan’ included within this report.
CONDITION: During my review of the District’s compliance with the requirements for noncompetitive procurement, I noted the District did not document its rationale for purchases made from ‘CJAWS, Inc.’ totaling $140,389.
CRITERIA: In accordance with Section 2 CFR 200.318(i) of the Uniform Guidance, the District must maintain records sufficient to detail the history of procurement. These records include but are not limited to the rationale for the method of procurement, selection of contract type, contractor selection or rejection, and the basis for the contract price. Furthermore, Section 2 CFR 200.320(c’) of the Uniform Guidance details five (5) circumstances in which noncompetitive procurement can be used.
EFFECT: The District did not comply with Section 2 CFR 200.318(i) and Section 2 CFR 200.320(c’) of the Uniform Guidance regarding the proper documentation required for noncompetitive procurement.
QUESTIONED COST: $140,389
CAUSE: From a review of the School District’s policies as published on the District’s website, the District has not updated their policies to include those related to ‘federal fiscal compliance’ in accordance with the Uniform Guidance, in particular, procurement policies to address the requirements of Section 2 CFR 200.318(i) and 320(c).
RECOMMENDATION: I recommend that the School District update their policies to include those most recent related to ‘federal fiscal compliance’ in accordance with the Uniform Guidance, in particular, procurement policies to address the requirements of Section 2 CFR 200.318(i) and 320(c). In addition, I would recommend that District personnel responsible for expenditures related to federal funding receive updated training related to ‘procurement’ policies and procedures as they relate to federal funding.
VIEWS OF RESPONSIBLE OFFICIALS: The School District concurs with the above noted finding and addresses this issue in the ‘Corrective Action Plan’ included within this report.
CONDITION: The Cambria Heights School District contracted with a third-party vendor (Trafera) for the purchase of technology equipment. The contract with Trafera was procured through a cooperative purchasing group (COSTARS). The District did not obtain an adequate number of price or rate quotations for the technology equipment as required by the Uniform Guidance and 24 PS 8.807.1.
CRITERIA: As specified in Section 2 CFR 200. 318(i) of the Uniform Guidance, the District must maintain records sufficient to detail the history of procurement. These records will include, but are not necessarily limited to, the following: rationale for the method of procurement, selection of contract type, contractor selection or rejection, and the basis for the contract price. In addition, small purchase procedures per Section 2 CFR 200.320(a)(2)(i) for acquisitions between the micro-purchase threshold (currently $10,000) and the simplified acquisition threshold (current $250,000), price or rate quotations must be obtained from an adequate number of qualified sources as determined appropriate. Per 24 PS 8.807.1, there should be three quotes that are either written or well documented. The use of COSTARS only constitutes one quotation.
CAUSE: School District personnel directly responsible for the acquisition of the technology equipment through COSTARS interpreted that the requirements specified by Section 2 CFR 200.318(i) and Section 2 CFR 200.320(a)(2)(i), would be met by using this cooperative purchasing organization.
EFFECT: The School District did not comply with the requirements of 2 CFR 200.318(i) and 2 CFR 200.320(a)(2)(i) of the Uniform Guidance, and 24 PS 8.807.1, regarding maintaining records sufficient to detail the history of procurement for the technology equipment to ensure that an adequate number of price quotations were solicited for this purchase.
QUESTIONED COST: $106,250
RECOMMENDATION: I recommend that the School District update their policies to include those most recent related to ‘federal fiscal compliance’ in accordance with the Uniform Guidance, in particular, procurement policies to address the requirements of Section 2 CFR 200.318(i) and 2 CFR.320(a)(2)(i). In addition, I would recommend that District personnel responsible for expenditures related to federal funding receive updated training related to ‘procurement’ policies and procedures as they relate to federal funding.
VIEWS OF RESPONSIBLE OFFICIALS: The School District concurs with the above noted finding and addresses this issue in the ‘Corrective Action Plan’ included within this report.
CONDITION: The District did not properly record its federal program expenditures for the GEER, ESSER, and ARP ESSER federal grant programs using the various federal funding source expenditure codes as prescribed by the Chart of Accounts for PA Local Educational Agencies maintained by the PA Office of the Budget, Office of Comptroller Operations. CRITERIA: The Pennsylvania Department of Education (PDE), through the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts requires School Districts to utilize specific funding source codes for federal program expenditures. In addition, Section 2 CFR 200.302(a) and 302(b) of the Uniform Guidance requires non-federal organizations such as the School District to maintain financial records which account for federal funds in such a manner as to be able to properly track the identification and use of federal funds. EFFECT: By not using federal source codes to properly track its federal program expenditures for the GEER, ESSER, and ARP ESSER federal grant programs, the School District did not comply with the financial reporting standards for federal program expenditures as prescribed by the Pennsylvania Department of Education, through the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts and Section 2 CFR 200.302(a) and 302(b) of the Uniform Guidance. This situation significantly reduced the District’s internal controls over the ability to properly manage and account for these federal program expenditures in accordance with the compliance requirements of PDE and the Uniform Guidance. CAUSE: Management used proper funding source codes for the revenues received under the GEER, ESSER, and ARP ESSER federal grant programs, but erroneously did not realize the federal funding source coding applied to expenditures as well. QUESTIONED COSTS: None RECOMMENDATION: I am recommending that the School District properly follow the guidance contained within the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts for recording all expenditures of the School District, most specifically, federal program grant expenditures to 1) enhance internal controls for tracking and monitoring federal program expenditures and 2) comply with the recordkeeping requirements for federal funds as specified in Section 2 CFR Part 200.302(a) and 302(b) of the Uniform Guidance and PDE regulations. VIEWS OF RESPONSIBLE OFFICIALS: The School District concurs with the above noted finding and addresses this issue in the ‘Corrective Action Plan’ included within this report.
CONDITION: The District did not properly record its federal program expenditures for the GEER, ESSER, and ARP ESSER federal grant programs using the various federal funding source expenditure codes as prescribed by the Chart of Accounts for PA Local Educational Agencies maintained by the PA Office of the Budget, Office of Comptroller Operations. CRITERIA: The Pennsylvania Department of Education (PDE), through the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts requires School Districts to utilize specific funding source codes for federal program expenditures. In addition, Section 2 CFR 200.302(a) and 302(b) of the Uniform Guidance requires non-federal organizations such as the School District to maintain financial records which account for federal funds in such a manner as to be able to properly track the identification and use of federal funds. EFFECT: By not using federal source codes to properly track its federal program expenditures for the GEER, ESSER, and ARP ESSER federal grant programs, the School District did not comply with the financial reporting standards for federal program expenditures as prescribed by the Pennsylvania Department of Education, through the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts and Section 2 CFR 200.302(a) and 302(b) of the Uniform Guidance. This situation significantly reduced the District’s internal controls over the ability to properly manage and account for these federal program expenditures in accordance with the compliance requirements of PDE and the Uniform Guidance. CAUSE: Management used proper funding source codes for the revenues received under the GEER, ESSER, and ARP ESSER federal grant programs, but erroneously did not realize the federal funding source coding applied to expenditures as well. QUESTIONED COSTS: None RECOMMENDATION: I am recommending that the School District properly follow the guidance contained within the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts for recording all expenditures of the School District, most specifically, federal program grant expenditures to 1) enhance internal controls for tracking and monitoring federal program expenditures and 2) comply with the recordkeeping requirements for federal funds as specified in Section 2 CFR Part 200.302(a) and 302(b) of the Uniform Guidance and PDE regulations. VIEWS OF RESPONSIBLE OFFICIALS: The School District concurs with the above noted finding and addresses this issue in the ‘Corrective Action Plan’ included within this report.
CONDITION: The District did not properly record its federal program expenditures for the GEER, ESSER, and ARP ESSER federal grant programs using the various federal funding source expenditure codes as prescribed by the Chart of Accounts for PA Local Educational Agencies maintained by the PA Office of the Budget, Office of Comptroller Operations. CRITERIA: The Pennsylvania Department of Education (PDE), through the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts requires School Districts to utilize specific funding source codes for federal program expenditures. In addition, Section 2 CFR 200.302(a) and 302(b) of the Uniform Guidance requires non-federal organizations such as the School District to maintain financial records which account for federal funds in such a manner as to be able to properly track the identification and use of federal funds. EFFECT: By not using federal source codes to properly track its federal program expenditures for the GEER, ESSER, and ARP ESSER federal grant programs, the School District did not comply with the financial reporting standards for federal program expenditures as prescribed by the Pennsylvania Department of Education, through the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts and Section 2 CFR 200.302(a) and 302(b) of the Uniform Guidance. This situation significantly reduced the District’s internal controls over the ability to properly manage and account for these federal program expenditures in accordance with the compliance requirements of PDE and the Uniform Guidance. CAUSE: Management used proper funding source codes for the revenues received under the GEER, ESSER, and ARP ESSER federal grant programs, but erroneously did not realize the federal funding source coding applied to expenditures as well. QUESTIONED COSTS: None RECOMMENDATION: I am recommending that the School District properly follow the guidance contained within the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts for recording all expenditures of the School District, most specifically, federal program grant expenditures to 1) enhance internal controls for tracking and monitoring federal program expenditures and 2) comply with the recordkeeping requirements for federal funds as specified in Section 2 CFR Part 200.302(a) and 302(b) of the Uniform Guidance and PDE regulations. VIEWS OF RESPONSIBLE OFFICIALS: The School District concurs with the above noted finding and addresses this issue in the ‘Corrective Action Plan’ included within this report.
CONDITION: The District did not properly record its federal program expenditures for the GEER, ESSER, and ARP ESSER federal grant programs using the various federal funding source expenditure codes as prescribed by the Chart of Accounts for PA Local Educational Agencies maintained by the PA Office of the Budget, Office of Comptroller Operations. CRITERIA: The Pennsylvania Department of Education (PDE), through the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts requires School Districts to utilize specific funding source codes for federal program expenditures. In addition, Section 2 CFR 200.302(a) and 302(b) of the Uniform Guidance requires non-federal organizations such as the School District to maintain financial records which account for federal funds in such a manner as to be able to properly track the identification and use of federal funds. EFFECT: By not using federal source codes to properly track its federal program expenditures for the GEER, ESSER, and ARP ESSER federal grant programs, the School District did not comply with the financial reporting standards for federal program expenditures as prescribed by the Pennsylvania Department of Education, through the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts and Section 2 CFR 200.302(a) and 302(b) of the Uniform Guidance. This situation significantly reduced the District’s internal controls over the ability to properly manage and account for these federal program expenditures in accordance with the compliance requirements of PDE and the Uniform Guidance. CAUSE: Management used proper funding source codes for the revenues received under the GEER, ESSER, and ARP ESSER federal grant programs, but erroneously did not realize the federal funding source coding applied to expenditures as well. QUESTIONED COSTS: None RECOMMENDATION: I am recommending that the School District properly follow the guidance contained within the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts for recording all expenditures of the School District, most specifically, federal program grant expenditures to 1) enhance internal controls for tracking and monitoring federal program expenditures and 2) comply with the recordkeeping requirements for federal funds as specified in Section 2 CFR Part 200.302(a) and 302(b) of the Uniform Guidance and PDE regulations. VIEWS OF RESPONSIBLE OFFICIALS: The School District concurs with the above noted finding and addresses this issue in the ‘Corrective Action Plan’ included within this report.
CONDITION: The District did not properly record its federal program expenditures for the GEER, ESSER, and ARP ESSER federal grant programs using the various federal funding source expenditure codes as prescribed by the Chart of Accounts for PA Local Educational Agencies maintained by the PA Office of the Budget, Office of Comptroller Operations. CRITERIA: The Pennsylvania Department of Education (PDE), through the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts requires School Districts to utilize specific funding source codes for federal program expenditures. In addition, Section 2 CFR 200.302(a) and 302(b) of the Uniform Guidance requires non-federal organizations such as the School District to maintain financial records which account for federal funds in such a manner as to be able to properly track the identification and use of federal funds. EFFECT: By not using federal source codes to properly track its federal program expenditures for the GEER, ESSER, and ARP ESSER federal grant programs, the School District did not comply with the financial reporting standards for federal program expenditures as prescribed by the Pennsylvania Department of Education, through the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts and Section 2 CFR 200.302(a) and 302(b) of the Uniform Guidance. This situation significantly reduced the District’s internal controls over the ability to properly manage and account for these federal program expenditures in accordance with the compliance requirements of PDE and the Uniform Guidance. CAUSE: Management used proper funding source codes for the revenues received under the GEER, ESSER, and ARP ESSER federal grant programs, but erroneously did not realize the federal funding source coding applied to expenditures as well. QUESTIONED COSTS: None RECOMMENDATION: I am recommending that the School District properly follow the guidance contained within the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts for recording all expenditures of the School District, most specifically, federal program grant expenditures to 1) enhance internal controls for tracking and monitoring federal program expenditures and 2) comply with the recordkeeping requirements for federal funds as specified in Section 2 CFR Part 200.302(a) and 302(b) of the Uniform Guidance and PDE regulations. VIEWS OF RESPONSIBLE OFFICIALS: The School District concurs with the above noted finding and addresses this issue in the ‘Corrective Action Plan’ included within this report.
CONDITION: During my sample review of the District’s completion of its federal grant program ‘Quarterly Cash On Hand Reconciliations’ for the 3rd and 4th fiscal quarters for the GEER grant and the 4th fiscal quarter for the ESSER II grant, I noted that the amounts reported to date for ‘total disbursements’ could not be ascertained from the coding of these expenditures in the District’s general ledger (See Finding 2021-005) and did not reconcile to the separate spreadsheets maintained by the School District. CRITERIA: Section 2 CFR 200.302(a) and 302(b) of the Uniform Guidance requires non-federal organizations such as the School District to maintain financial records which account for federal funds in such a manner as to be able to properly track the identification and use of federal funds.
EFFECT: The School District did not comply with Section 2 CFR 200.302(a) and 302(b) of the Uniform Guidance which prescribes the proper financial management system for the tracking of federal program expenditures.
CAUSE: The School District did not utilize the federal source code tracking system as prescribed by the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts, which would have enabled the District to print reports from the accounting software system, by federal source program, to properly prepare the quarterly reconciliations. It was not readily determinable as to why the ‘total disbursements’ line on the quarterly cash on hand reconciliations did not match the separate spreadsheets the School District utilized for tracking federal program expenditures.
QUESTIONED COSTS: None
RECOMMENDATION: I am recommending that the School District properly follow the guidance contained within the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts for recording all expenditures of the School District, most specifically, federal program grant expenditures to comply with the recordkeeping requirements for federal funds as specified in Section 2 CFR Part 200.302(a) and 302(b) of the Uniform Guidance, to allow for the proper completion of the ‘quarterly cash on hand reconciliations’.
VIEWS OF RESPONSIBLE OFFICIALS: The School District concurs with the above noted finding and addresses this issue in the ‘Corrective Action Plan’ included within this report.
CONDITION: During my review of the District’s compliance with the requirements for noncompetitive procurement, I noted the District did not document its rationale for purchases made from ‘CJAWS, Inc.’ totaling $140,389.
CRITERIA: In accordance with Section 2 CFR 200.318(i) of the Uniform Guidance, the District must maintain records sufficient to detail the history of procurement. These records include but are not limited to the rationale for the method of procurement, selection of contract type, contractor selection or rejection, and the basis for the contract price. Furthermore, Section 2 CFR 200.320(c’) of the Uniform Guidance details five (5) circumstances in which noncompetitive procurement can be used.
EFFECT: The District did not comply with Section 2 CFR 200.318(i) and Section 2 CFR 200.320(c’) of the Uniform Guidance regarding the proper documentation required for noncompetitive procurement.
QUESTIONED COST: $140,389
CAUSE: From a review of the School District’s policies as published on the District’s website, the District has not updated their policies to include those related to ‘federal fiscal compliance’ in accordance with the Uniform Guidance, in particular, procurement policies to address the requirements of Section 2 CFR 200.318(i) and 320(c).
RECOMMENDATION: I recommend that the School District update their policies to include those most recent related to ‘federal fiscal compliance’ in accordance with the Uniform Guidance, in particular, procurement policies to address the requirements of Section 2 CFR 200.318(i) and 320(c). In addition, I would recommend that District personnel responsible for expenditures related to federal funding receive updated training related to ‘procurement’ policies and procedures as they relate to federal funding.
VIEWS OF RESPONSIBLE OFFICIALS: The School District concurs with the above noted finding and addresses this issue in the ‘Corrective Action Plan’ included within this report.
CONDITION: The Cambria Heights School District contracted with a third-party vendor (Trafera) for the purchase of technology equipment. The contract with Trafera was procured through a cooperative purchasing group (COSTARS). The District did not obtain an adequate number of price or rate quotations for the technology equipment as required by the Uniform Guidance and 24 PS 8.807.1.
CRITERIA: As specified in Section 2 CFR 200. 318(i) of the Uniform Guidance, the District must maintain records sufficient to detail the history of procurement. These records will include, but are not necessarily limited to, the following: rationale for the method of procurement, selection of contract type, contractor selection or rejection, and the basis for the contract price. In addition, small purchase procedures per Section 2 CFR 200.320(a)(2)(i) for acquisitions between the micro-purchase threshold (currently $10,000) and the simplified acquisition threshold (current $250,000), price or rate quotations must be obtained from an adequate number of qualified sources as determined appropriate. Per 24 PS 8.807.1, there should be three quotes that are either written or well documented. The use of COSTARS only constitutes one quotation.
CAUSE: School District personnel directly responsible for the acquisition of the technology equipment through COSTARS interpreted that the requirements specified by Section 2 CFR 200.318(i) and Section 2 CFR 200.320(a)(2)(i), would be met by using this cooperative purchasing organization.
EFFECT: The School District did not comply with the requirements of 2 CFR 200.318(i) and 2 CFR 200.320(a)(2)(i) of the Uniform Guidance, and 24 PS 8.807.1, regarding maintaining records sufficient to detail the history of procurement for the technology equipment to ensure that an adequate number of price quotations were solicited for this purchase.
QUESTIONED COST: $106,250
RECOMMENDATION: I recommend that the School District update their policies to include those most recent related to ‘federal fiscal compliance’ in accordance with the Uniform Guidance, in particular, procurement policies to address the requirements of Section 2 CFR 200.318(i) and 2 CFR.320(a)(2)(i). In addition, I would recommend that District personnel responsible for expenditures related to federal funding receive updated training related to ‘procurement’ policies and procedures as they relate to federal funding.
VIEWS OF RESPONSIBLE OFFICIALS: The School District concurs with the above noted finding and addresses this issue in the ‘Corrective Action Plan’ included within this report.
CONDITION: The District did not maintain a general ledger system of accounting for its Cafeteria Fund which reports the financial activity of the federal National School Lunch and School Breakfast Programs. The financial activity occurring in this Fund is maintained in checkbook fashion during the fiscal year. This is a repeat finding (2020-004) from the previous fiscal year. CRITERIA: Prudent internal control over accounting for federal program funds requires non-federal organizations such as the School District to maintain financial records which account for federal funds in such a manner as to be able to properly track the receipt and use of federal funds as stated in Section 2 CFR Part 200 of the Uniform Guidance. Best practices suggest that the use of a general ledger system of accounting would enable the District to aggregate financial information involving federal funds during the fiscal year in such a manner to properly manage, monitor, and report the financial activity in compliance with federal program guidelines. EFFECT: The lack of maintaining a general ledger system of accounting for the District’s Cafeteria Fund significantly reduces the District-wide internal controls over the ability to properly manage and account for the assets contained within this Fund, as well as reduces the District’s ability to comply with the compliance requirements for internal control over financial reporting for federal programs as stated in Section 2 CFR Part 200 of the Uniform Guidance. CAUSE: As a result of the minimal staff size in the District’s business office, management has opted to simplify the process by which they account for and monitor the financial activities of the Cafeteria Fund by utilizing a checkbook system of accounting rather than maintaining a general ledger system of accounting for these Funds. QUESTIONED COSTS: None RECOMMENDATION: During the 2018-2019 fiscal year, the District implemented new accounting software that can readily account for the financial activity of all Funds in a manner like the District’s General Fund. I am recommending that the management of the School District utilize the new accounting software to enter the financial activity (Receipts and Disbursements) of the Cafeteria Fund in a manner like the General Fund. This procedure will significantly enhance the District-wide internal controls over financial reporting for the Cafeteria Fund, as well as provide management the ability to produce meaningful financial reports reflecting the activity in the Cafeteria Fund for prudent oversight by the Board of Education. In addition, this procedure will enable the District to comply with the recordkeeping requirements for federal funds as specified in Section 2 CFR Part 200 of the Uniform Guidance. VIEWS OF RESPONSIBLE OFFICIALS: The School District concurs with the above noted finding and addresses this issue in the ‘Corrective Action Plan’ included within this report.
CONDITION: The District did not maintain a general ledger system of accounting for its Cafeteria Fund which reports the financial activity of the federal National School Lunch and School Breakfast Programs. The financial activity occurring in this Fund is maintained in checkbook fashion during the fiscal year. This is a repeat finding (2020-004) from the previous fiscal year. CRITERIA: Prudent internal control over accounting for federal program funds requires non-federal organizations such as the School District to maintain financial records which account for federal funds in such a manner as to be able to properly track the receipt and use of federal funds as stated in Section 2 CFR Part 200 of the Uniform Guidance. Best practices suggest that the use of a general ledger system of accounting would enable the District to aggregate financial information involving federal funds during the fiscal year in such a manner to properly manage, monitor, and report the financial activity in compliance with federal program guidelines. EFFECT: The lack of maintaining a general ledger system of accounting for the District’s Cafeteria Fund significantly reduces the District-wide internal controls over the ability to properly manage and account for the assets contained within this Fund, as well as reduces the District’s ability to comply with the compliance requirements for internal control over financial reporting for federal programs as stated in Section 2 CFR Part 200 of the Uniform Guidance. CAUSE: As a result of the minimal staff size in the District’s business office, management has opted to simplify the process by which they account for and monitor the financial activities of the Cafeteria Fund by utilizing a checkbook system of accounting rather than maintaining a general ledger system of accounting for these Funds. QUESTIONED COSTS: None RECOMMENDATION: During the 2018-2019 fiscal year, the District implemented new accounting software that can readily account for the financial activity of all Funds in a manner like the District’s General Fund. I am recommending that the management of the School District utilize the new accounting software to enter the financial activity (Receipts and Disbursements) of the Cafeteria Fund in a manner like the General Fund. This procedure will significantly enhance the District-wide internal controls over financial reporting for the Cafeteria Fund, as well as provide management the ability to produce meaningful financial reports reflecting the activity in the Cafeteria Fund for prudent oversight by the Board of Education. In addition, this procedure will enable the District to comply with the recordkeeping requirements for federal funds as specified in Section 2 CFR Part 200 of the Uniform Guidance. VIEWS OF RESPONSIBLE OFFICIALS: The School District concurs with the above noted finding and addresses this issue in the ‘Corrective Action Plan’ included within this report.
CONDITION: The District did not maintain a general ledger system of accounting for its Cafeteria Fund which reports the financial activity of the federal National School Lunch and School Breakfast Programs. The financial activity occurring in this Fund is maintained in checkbook fashion during the fiscal year. This is a repeat finding (2020-004) from the previous fiscal year. CRITERIA: Prudent internal control over accounting for federal program funds requires non-federal organizations such as the School District to maintain financial records which account for federal funds in such a manner as to be able to properly track the receipt and use of federal funds as stated in Section 2 CFR Part 200 of the Uniform Guidance. Best practices suggest that the use of a general ledger system of accounting would enable the District to aggregate financial information involving federal funds during the fiscal year in such a manner to properly manage, monitor, and report the financial activity in compliance with federal program guidelines. EFFECT: The lack of maintaining a general ledger system of accounting for the District’s Cafeteria Fund significantly reduces the District-wide internal controls over the ability to properly manage and account for the assets contained within this Fund, as well as reduces the District’s ability to comply with the compliance requirements for internal control over financial reporting for federal programs as stated in Section 2 CFR Part 200 of the Uniform Guidance. CAUSE: As a result of the minimal staff size in the District’s business office, management has opted to simplify the process by which they account for and monitor the financial activities of the Cafeteria Fund by utilizing a checkbook system of accounting rather than maintaining a general ledger system of accounting for these Funds. QUESTIONED COSTS: None RECOMMENDATION: During the 2018-2019 fiscal year, the District implemented new accounting software that can readily account for the financial activity of all Funds in a manner like the District’s General Fund. I am recommending that the management of the School District utilize the new accounting software to enter the financial activity (Receipts and Disbursements) of the Cafeteria Fund in a manner like the General Fund. This procedure will significantly enhance the District-wide internal controls over financial reporting for the Cafeteria Fund, as well as provide management the ability to produce meaningful financial reports reflecting the activity in the Cafeteria Fund for prudent oversight by the Board of Education. In addition, this procedure will enable the District to comply with the recordkeeping requirements for federal funds as specified in Section 2 CFR Part 200 of the Uniform Guidance. VIEWS OF RESPONSIBLE OFFICIALS: The School District concurs with the above noted finding and addresses this issue in the ‘Corrective Action Plan’ included within this report.
CONDITION: The District did not properly record its federal program expenditures for the GEER, ESSER, and ARP ESSER federal grant programs using the various federal funding source expenditure codes as prescribed by the Chart of Accounts for PA Local Educational Agencies maintained by the PA Office of the Budget, Office of Comptroller Operations. CRITERIA: The Pennsylvania Department of Education (PDE), through the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts requires School Districts to utilize specific funding source codes for federal program expenditures. In addition, Section 2 CFR 200.302(a) and 302(b) of the Uniform Guidance requires non-federal organizations such as the School District to maintain financial records which account for federal funds in such a manner as to be able to properly track the identification and use of federal funds. EFFECT: By not using federal source codes to properly track its federal program expenditures for the GEER, ESSER, and ARP ESSER federal grant programs, the School District did not comply with the financial reporting standards for federal program expenditures as prescribed by the Pennsylvania Department of Education, through the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts and Section 2 CFR 200.302(a) and 302(b) of the Uniform Guidance. This situation significantly reduced the District’s internal controls over the ability to properly manage and account for these federal program expenditures in accordance with the compliance requirements of PDE and the Uniform Guidance. CAUSE: Management used proper funding source codes for the revenues received under the GEER, ESSER, and ARP ESSER federal grant programs, but erroneously did not realize the federal funding source coding applied to expenditures as well. QUESTIONED COSTS: None RECOMMENDATION: I am recommending that the School District properly follow the guidance contained within the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts for recording all expenditures of the School District, most specifically, federal program grant expenditures to 1) enhance internal controls for tracking and monitoring federal program expenditures and 2) comply with the recordkeeping requirements for federal funds as specified in Section 2 CFR Part 200.302(a) and 302(b) of the Uniform Guidance and PDE regulations. VIEWS OF RESPONSIBLE OFFICIALS: The School District concurs with the above noted finding and addresses this issue in the ‘Corrective Action Plan’ included within this report.
CONDITION: During my sample review of the District’s completion of its federal grant program ‘Quarterly Cash On Hand Reconciliations’ for the 3rd and 4th fiscal quarters for the GEER grant and the 4th fiscal quarter for the ESSER II grant, I noted that the amounts reported to date for ‘total disbursements’ could not be ascertained from the coding of these expenditures in the District’s general ledger (See Finding 2021-005) and did not reconcile to the separate spreadsheets maintained by the School District. CRITERIA: Section 2 CFR 200.302(a) and 302(b) of the Uniform Guidance requires non-federal organizations such as the School District to maintain financial records which account for federal funds in such a manner as to be able to properly track the identification and use of federal funds.
EFFECT: The School District did not comply with Section 2 CFR 200.302(a) and 302(b) of the Uniform Guidance which prescribes the proper financial management system for the tracking of federal program expenditures.
CAUSE: The School District did not utilize the federal source code tracking system as prescribed by the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts, which would have enabled the District to print reports from the accounting software system, by federal source program, to properly prepare the quarterly reconciliations. It was not readily determinable as to why the ‘total disbursements’ line on the quarterly cash on hand reconciliations did not match the separate spreadsheets the School District utilized for tracking federal program expenditures.
QUESTIONED COSTS: None
RECOMMENDATION: I am recommending that the School District properly follow the guidance contained within the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts for recording all expenditures of the School District, most specifically, federal program grant expenditures to comply with the recordkeeping requirements for federal funds as specified in Section 2 CFR Part 200.302(a) and 302(b) of the Uniform Guidance, to allow for the proper completion of the ‘quarterly cash on hand reconciliations’.
VIEWS OF RESPONSIBLE OFFICIALS: The School District concurs with the above noted finding and addresses this issue in the ‘Corrective Action Plan’ included within this report.
CONDITION: The District did not properly record its federal program expenditures for the GEER, ESSER, and ARP ESSER federal grant programs using the various federal funding source expenditure codes as prescribed by the Chart of Accounts for PA Local Educational Agencies maintained by the PA Office of the Budget, Office of Comptroller Operations. CRITERIA: The Pennsylvania Department of Education (PDE), through the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts requires School Districts to utilize specific funding source codes for federal program expenditures. In addition, Section 2 CFR 200.302(a) and 302(b) of the Uniform Guidance requires non-federal organizations such as the School District to maintain financial records which account for federal funds in such a manner as to be able to properly track the identification and use of federal funds. EFFECT: By not using federal source codes to properly track its federal program expenditures for the GEER, ESSER, and ARP ESSER federal grant programs, the School District did not comply with the financial reporting standards for federal program expenditures as prescribed by the Pennsylvania Department of Education, through the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts and Section 2 CFR 200.302(a) and 302(b) of the Uniform Guidance. This situation significantly reduced the District’s internal controls over the ability to properly manage and account for these federal program expenditures in accordance with the compliance requirements of PDE and the Uniform Guidance. CAUSE: Management used proper funding source codes for the revenues received under the GEER, ESSER, and ARP ESSER federal grant programs, but erroneously did not realize the federal funding source coding applied to expenditures as well. QUESTIONED COSTS: None RECOMMENDATION: I am recommending that the School District properly follow the guidance contained within the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts for recording all expenditures of the School District, most specifically, federal program grant expenditures to 1) enhance internal controls for tracking and monitoring federal program expenditures and 2) comply with the recordkeeping requirements for federal funds as specified in Section 2 CFR Part 200.302(a) and 302(b) of the Uniform Guidance and PDE regulations. VIEWS OF RESPONSIBLE OFFICIALS: The School District concurs with the above noted finding and addresses this issue in the ‘Corrective Action Plan’ included within this report.
CONDITION: During my sample review of the District’s completion of its federal grant program ‘Quarterly Cash On Hand Reconciliations’ for the 3rd and 4th fiscal quarters for the GEER grant and the 4th fiscal quarter for the ESSER II grant, I noted that the amounts reported to date for ‘total disbursements’ could not be ascertained from the coding of these expenditures in the District’s general ledger (See Finding 2021-005) and did not reconcile to the separate spreadsheets maintained by the School District. CRITERIA: Section 2 CFR 200.302(a) and 302(b) of the Uniform Guidance requires non-federal organizations such as the School District to maintain financial records which account for federal funds in such a manner as to be able to properly track the identification and use of federal funds.
EFFECT: The School District did not comply with Section 2 CFR 200.302(a) and 302(b) of the Uniform Guidance which prescribes the proper financial management system for the tracking of federal program expenditures.
CAUSE: The School District did not utilize the federal source code tracking system as prescribed by the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts, which would have enabled the District to print reports from the accounting software system, by federal source program, to properly prepare the quarterly reconciliations. It was not readily determinable as to why the ‘total disbursements’ line on the quarterly cash on hand reconciliations did not match the separate spreadsheets the School District utilized for tracking federal program expenditures.
QUESTIONED COSTS: None
RECOMMENDATION: I am recommending that the School District properly follow the guidance contained within the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts for recording all expenditures of the School District, most specifically, federal program grant expenditures to comply with the recordkeeping requirements for federal funds as specified in Section 2 CFR Part 200.302(a) and 302(b) of the Uniform Guidance, to allow for the proper completion of the ‘quarterly cash on hand reconciliations’.
VIEWS OF RESPONSIBLE OFFICIALS: The School District concurs with the above noted finding and addresses this issue in the ‘Corrective Action Plan’ included within this report.
CONDITION: During my review of the District’s compliance with the requirements for noncompetitive procurement, I noted the District did not document its rationale for purchases made from ‘CJAWS, Inc.’ totaling $140,389.
CRITERIA: In accordance with Section 2 CFR 200.318(i) of the Uniform Guidance, the District must maintain records sufficient to detail the history of procurement. These records include but are not limited to the rationale for the method of procurement, selection of contract type, contractor selection or rejection, and the basis for the contract price. Furthermore, Section 2 CFR 200.320(c’) of the Uniform Guidance details five (5) circumstances in which noncompetitive procurement can be used.
EFFECT: The District did not comply with Section 2 CFR 200.318(i) and Section 2 CFR 200.320(c’) of the Uniform Guidance regarding the proper documentation required for noncompetitive procurement.
QUESTIONED COST: $140,389
CAUSE: From a review of the School District’s policies as published on the District’s website, the District has not updated their policies to include those related to ‘federal fiscal compliance’ in accordance with the Uniform Guidance, in particular, procurement policies to address the requirements of Section 2 CFR 200.318(i) and 320(c).
RECOMMENDATION: I recommend that the School District update their policies to include those most recent related to ‘federal fiscal compliance’ in accordance with the Uniform Guidance, in particular, procurement policies to address the requirements of Section 2 CFR 200.318(i) and 320(c). In addition, I would recommend that District personnel responsible for expenditures related to federal funding receive updated training related to ‘procurement’ policies and procedures as they relate to federal funding.
VIEWS OF RESPONSIBLE OFFICIALS: The School District concurs with the above noted finding and addresses this issue in the ‘Corrective Action Plan’ included within this report.
CONDITION: The Cambria Heights School District contracted with a third-party vendor (Trafera) for the purchase of technology equipment. The contract with Trafera was procured through a cooperative purchasing group (COSTARS). The District did not obtain an adequate number of price or rate quotations for the technology equipment as required by the Uniform Guidance and 24 PS 8.807.1.
CRITERIA: As specified in Section 2 CFR 200. 318(i) of the Uniform Guidance, the District must maintain records sufficient to detail the history of procurement. These records will include, but are not necessarily limited to, the following: rationale for the method of procurement, selection of contract type, contractor selection or rejection, and the basis for the contract price. In addition, small purchase procedures per Section 2 CFR 200.320(a)(2)(i) for acquisitions between the micro-purchase threshold (currently $10,000) and the simplified acquisition threshold (current $250,000), price or rate quotations must be obtained from an adequate number of qualified sources as determined appropriate. Per 24 PS 8.807.1, there should be three quotes that are either written or well documented. The use of COSTARS only constitutes one quotation.
CAUSE: School District personnel directly responsible for the acquisition of the technology equipment through COSTARS interpreted that the requirements specified by Section 2 CFR 200.318(i) and Section 2 CFR 200.320(a)(2)(i), would be met by using this cooperative purchasing organization.
EFFECT: The School District did not comply with the requirements of 2 CFR 200.318(i) and 2 CFR 200.320(a)(2)(i) of the Uniform Guidance, and 24 PS 8.807.1, regarding maintaining records sufficient to detail the history of procurement for the technology equipment to ensure that an adequate number of price quotations were solicited for this purchase.
QUESTIONED COST: $106,250
RECOMMENDATION: I recommend that the School District update their policies to include those most recent related to ‘federal fiscal compliance’ in accordance with the Uniform Guidance, in particular, procurement policies to address the requirements of Section 2 CFR 200.318(i) and 2 CFR.320(a)(2)(i). In addition, I would recommend that District personnel responsible for expenditures related to federal funding receive updated training related to ‘procurement’ policies and procedures as they relate to federal funding.
VIEWS OF RESPONSIBLE OFFICIALS: The School District concurs with the above noted finding and addresses this issue in the ‘Corrective Action Plan’ included within this report.
CONDITION: The District did not properly record its federal program expenditures for the GEER, ESSER, and ARP ESSER federal grant programs using the various federal funding source expenditure codes as prescribed by the Chart of Accounts for PA Local Educational Agencies maintained by the PA Office of the Budget, Office of Comptroller Operations. CRITERIA: The Pennsylvania Department of Education (PDE), through the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts requires School Districts to utilize specific funding source codes for federal program expenditures. In addition, Section 2 CFR 200.302(a) and 302(b) of the Uniform Guidance requires non-federal organizations such as the School District to maintain financial records which account for federal funds in such a manner as to be able to properly track the identification and use of federal funds. EFFECT: By not using federal source codes to properly track its federal program expenditures for the GEER, ESSER, and ARP ESSER federal grant programs, the School District did not comply with the financial reporting standards for federal program expenditures as prescribed by the Pennsylvania Department of Education, through the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts and Section 2 CFR 200.302(a) and 302(b) of the Uniform Guidance. This situation significantly reduced the District’s internal controls over the ability to properly manage and account for these federal program expenditures in accordance with the compliance requirements of PDE and the Uniform Guidance. CAUSE: Management used proper funding source codes for the revenues received under the GEER, ESSER, and ARP ESSER federal grant programs, but erroneously did not realize the federal funding source coding applied to expenditures as well. QUESTIONED COSTS: None RECOMMENDATION: I am recommending that the School District properly follow the guidance contained within the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts for recording all expenditures of the School District, most specifically, federal program grant expenditures to 1) enhance internal controls for tracking and monitoring federal program expenditures and 2) comply with the recordkeeping requirements for federal funds as specified in Section 2 CFR Part 200.302(a) and 302(b) of the Uniform Guidance and PDE regulations. VIEWS OF RESPONSIBLE OFFICIALS: The School District concurs with the above noted finding and addresses this issue in the ‘Corrective Action Plan’ included within this report.
CONDITION: During my sample review of the District’s completion of its federal grant program ‘Quarterly Cash On Hand Reconciliations’ for the 3rd and 4th fiscal quarters for the GEER grant and the 4th fiscal quarter for the ESSER II grant, I noted that the amounts reported to date for ‘total disbursements’ could not be ascertained from the coding of these expenditures in the District’s general ledger (See Finding 2021-005) and did not reconcile to the separate spreadsheets maintained by the School District. CRITERIA: Section 2 CFR 200.302(a) and 302(b) of the Uniform Guidance requires non-federal organizations such as the School District to maintain financial records which account for federal funds in such a manner as to be able to properly track the identification and use of federal funds.
EFFECT: The School District did not comply with Section 2 CFR 200.302(a) and 302(b) of the Uniform Guidance which prescribes the proper financial management system for the tracking of federal program expenditures.
CAUSE: The School District did not utilize the federal source code tracking system as prescribed by the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts, which would have enabled the District to print reports from the accounting software system, by federal source program, to properly prepare the quarterly reconciliations. It was not readily determinable as to why the ‘total disbursements’ line on the quarterly cash on hand reconciliations did not match the separate spreadsheets the School District utilized for tracking federal program expenditures.
QUESTIONED COSTS: None
RECOMMENDATION: I am recommending that the School District properly follow the guidance contained within the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts for recording all expenditures of the School District, most specifically, federal program grant expenditures to comply with the recordkeeping requirements for federal funds as specified in Section 2 CFR Part 200.302(a) and 302(b) of the Uniform Guidance, to allow for the proper completion of the ‘quarterly cash on hand reconciliations’.
VIEWS OF RESPONSIBLE OFFICIALS: The School District concurs with the above noted finding and addresses this issue in the ‘Corrective Action Plan’ included within this report.
CONDITION: During my review of the District’s compliance with the requirements for noncompetitive procurement, I noted the District did not document its rationale for purchases made from ‘CJAWS, Inc.’ totaling $140,389.
CRITERIA: In accordance with Section 2 CFR 200.318(i) of the Uniform Guidance, the District must maintain records sufficient to detail the history of procurement. These records include but are not limited to the rationale for the method of procurement, selection of contract type, contractor selection or rejection, and the basis for the contract price. Furthermore, Section 2 CFR 200.320(c’) of the Uniform Guidance details five (5) circumstances in which noncompetitive procurement can be used.
EFFECT: The District did not comply with Section 2 CFR 200.318(i) and Section 2 CFR 200.320(c’) of the Uniform Guidance regarding the proper documentation required for noncompetitive procurement.
QUESTIONED COST: $140,389
CAUSE: From a review of the School District’s policies as published on the District’s website, the District has not updated their policies to include those related to ‘federal fiscal compliance’ in accordance with the Uniform Guidance, in particular, procurement policies to address the requirements of Section 2 CFR 200.318(i) and 320(c).
RECOMMENDATION: I recommend that the School District update their policies to include those most recent related to ‘federal fiscal compliance’ in accordance with the Uniform Guidance, in particular, procurement policies to address the requirements of Section 2 CFR 200.318(i) and 320(c). In addition, I would recommend that District personnel responsible for expenditures related to federal funding receive updated training related to ‘procurement’ policies and procedures as they relate to federal funding.
VIEWS OF RESPONSIBLE OFFICIALS: The School District concurs with the above noted finding and addresses this issue in the ‘Corrective Action Plan’ included within this report.
CONDITION: The Cambria Heights School District contracted with a third-party vendor (Trafera) for the purchase of technology equipment. The contract with Trafera was procured through a cooperative purchasing group (COSTARS). The District did not obtain an adequate number of price or rate quotations for the technology equipment as required by the Uniform Guidance and 24 PS 8.807.1.
CRITERIA: As specified in Section 2 CFR 200. 318(i) of the Uniform Guidance, the District must maintain records sufficient to detail the history of procurement. These records will include, but are not necessarily limited to, the following: rationale for the method of procurement, selection of contract type, contractor selection or rejection, and the basis for the contract price. In addition, small purchase procedures per Section 2 CFR 200.320(a)(2)(i) for acquisitions between the micro-purchase threshold (currently $10,000) and the simplified acquisition threshold (current $250,000), price or rate quotations must be obtained from an adequate number of qualified sources as determined appropriate. Per 24 PS 8.807.1, there should be three quotes that are either written or well documented. The use of COSTARS only constitutes one quotation.
CAUSE: School District personnel directly responsible for the acquisition of the technology equipment through COSTARS interpreted that the requirements specified by Section 2 CFR 200.318(i) and Section 2 CFR 200.320(a)(2)(i), would be met by using this cooperative purchasing organization.
EFFECT: The School District did not comply with the requirements of 2 CFR 200.318(i) and 2 CFR 200.320(a)(2)(i) of the Uniform Guidance, and 24 PS 8.807.1, regarding maintaining records sufficient to detail the history of procurement for the technology equipment to ensure that an adequate number of price quotations were solicited for this purchase.
QUESTIONED COST: $106,250
RECOMMENDATION: I recommend that the School District update their policies to include those most recent related to ‘federal fiscal compliance’ in accordance with the Uniform Guidance, in particular, procurement policies to address the requirements of Section 2 CFR 200.318(i) and 2 CFR.320(a)(2)(i). In addition, I would recommend that District personnel responsible for expenditures related to federal funding receive updated training related to ‘procurement’ policies and procedures as they relate to federal funding.
VIEWS OF RESPONSIBLE OFFICIALS: The School District concurs with the above noted finding and addresses this issue in the ‘Corrective Action Plan’ included within this report.
CONDITION: The District did not properly record its federal program expenditures for the GEER, ESSER, and ARP ESSER federal grant programs using the various federal funding source expenditure codes as prescribed by the Chart of Accounts for PA Local Educational Agencies maintained by the PA Office of the Budget, Office of Comptroller Operations. CRITERIA: The Pennsylvania Department of Education (PDE), through the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts requires School Districts to utilize specific funding source codes for federal program expenditures. In addition, Section 2 CFR 200.302(a) and 302(b) of the Uniform Guidance requires non-federal organizations such as the School District to maintain financial records which account for federal funds in such a manner as to be able to properly track the identification and use of federal funds. EFFECT: By not using federal source codes to properly track its federal program expenditures for the GEER, ESSER, and ARP ESSER federal grant programs, the School District did not comply with the financial reporting standards for federal program expenditures as prescribed by the Pennsylvania Department of Education, through the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts and Section 2 CFR 200.302(a) and 302(b) of the Uniform Guidance. This situation significantly reduced the District’s internal controls over the ability to properly manage and account for these federal program expenditures in accordance with the compliance requirements of PDE and the Uniform Guidance. CAUSE: Management used proper funding source codes for the revenues received under the GEER, ESSER, and ARP ESSER federal grant programs, but erroneously did not realize the federal funding source coding applied to expenditures as well. QUESTIONED COSTS: None RECOMMENDATION: I am recommending that the School District properly follow the guidance contained within the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts for recording all expenditures of the School District, most specifically, federal program grant expenditures to 1) enhance internal controls for tracking and monitoring federal program expenditures and 2) comply with the recordkeeping requirements for federal funds as specified in Section 2 CFR Part 200.302(a) and 302(b) of the Uniform Guidance and PDE regulations. VIEWS OF RESPONSIBLE OFFICIALS: The School District concurs with the above noted finding and addresses this issue in the ‘Corrective Action Plan’ included within this report.
CONDITION: The District did not properly record its federal program expenditures for the GEER, ESSER, and ARP ESSER federal grant programs using the various federal funding source expenditure codes as prescribed by the Chart of Accounts for PA Local Educational Agencies maintained by the PA Office of the Budget, Office of Comptroller Operations. CRITERIA: The Pennsylvania Department of Education (PDE), through the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts requires School Districts to utilize specific funding source codes for federal program expenditures. In addition, Section 2 CFR 200.302(a) and 302(b) of the Uniform Guidance requires non-federal organizations such as the School District to maintain financial records which account for federal funds in such a manner as to be able to properly track the identification and use of federal funds. EFFECT: By not using federal source codes to properly track its federal program expenditures for the GEER, ESSER, and ARP ESSER federal grant programs, the School District did not comply with the financial reporting standards for federal program expenditures as prescribed by the Pennsylvania Department of Education, through the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts and Section 2 CFR 200.302(a) and 302(b) of the Uniform Guidance. This situation significantly reduced the District’s internal controls over the ability to properly manage and account for these federal program expenditures in accordance with the compliance requirements of PDE and the Uniform Guidance. CAUSE: Management used proper funding source codes for the revenues received under the GEER, ESSER, and ARP ESSER federal grant programs, but erroneously did not realize the federal funding source coding applied to expenditures as well. QUESTIONED COSTS: None RECOMMENDATION: I am recommending that the School District properly follow the guidance contained within the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts for recording all expenditures of the School District, most specifically, federal program grant expenditures to 1) enhance internal controls for tracking and monitoring federal program expenditures and 2) comply with the recordkeeping requirements for federal funds as specified in Section 2 CFR Part 200.302(a) and 302(b) of the Uniform Guidance and PDE regulations. VIEWS OF RESPONSIBLE OFFICIALS: The School District concurs with the above noted finding and addresses this issue in the ‘Corrective Action Plan’ included within this report.
CONDITION: The District did not properly record its federal program expenditures for the GEER, ESSER, and ARP ESSER federal grant programs using the various federal funding source expenditure codes as prescribed by the Chart of Accounts for PA Local Educational Agencies maintained by the PA Office of the Budget, Office of Comptroller Operations. CRITERIA: The Pennsylvania Department of Education (PDE), through the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts requires School Districts to utilize specific funding source codes for federal program expenditures. In addition, Section 2 CFR 200.302(a) and 302(b) of the Uniform Guidance requires non-federal organizations such as the School District to maintain financial records which account for federal funds in such a manner as to be able to properly track the identification and use of federal funds. EFFECT: By not using federal source codes to properly track its federal program expenditures for the GEER, ESSER, and ARP ESSER federal grant programs, the School District did not comply with the financial reporting standards for federal program expenditures as prescribed by the Pennsylvania Department of Education, through the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts and Section 2 CFR 200.302(a) and 302(b) of the Uniform Guidance. This situation significantly reduced the District’s internal controls over the ability to properly manage and account for these federal program expenditures in accordance with the compliance requirements of PDE and the Uniform Guidance. CAUSE: Management used proper funding source codes for the revenues received under the GEER, ESSER, and ARP ESSER federal grant programs, but erroneously did not realize the federal funding source coding applied to expenditures as well. QUESTIONED COSTS: None RECOMMENDATION: I am recommending that the School District properly follow the guidance contained within the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts for recording all expenditures of the School District, most specifically, federal program grant expenditures to 1) enhance internal controls for tracking and monitoring federal program expenditures and 2) comply with the recordkeeping requirements for federal funds as specified in Section 2 CFR Part 200.302(a) and 302(b) of the Uniform Guidance and PDE regulations. VIEWS OF RESPONSIBLE OFFICIALS: The School District concurs with the above noted finding and addresses this issue in the ‘Corrective Action Plan’ included within this report.
CONDITION: The District did not properly record its federal program expenditures for the GEER, ESSER, and ARP ESSER federal grant programs using the various federal funding source expenditure codes as prescribed by the Chart of Accounts for PA Local Educational Agencies maintained by the PA Office of the Budget, Office of Comptroller Operations. CRITERIA: The Pennsylvania Department of Education (PDE), through the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts requires School Districts to utilize specific funding source codes for federal program expenditures. In addition, Section 2 CFR 200.302(a) and 302(b) of the Uniform Guidance requires non-federal organizations such as the School District to maintain financial records which account for federal funds in such a manner as to be able to properly track the identification and use of federal funds. EFFECT: By not using federal source codes to properly track its federal program expenditures for the GEER, ESSER, and ARP ESSER federal grant programs, the School District did not comply with the financial reporting standards for federal program expenditures as prescribed by the Pennsylvania Department of Education, through the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts and Section 2 CFR 200.302(a) and 302(b) of the Uniform Guidance. This situation significantly reduced the District’s internal controls over the ability to properly manage and account for these federal program expenditures in accordance with the compliance requirements of PDE and the Uniform Guidance. CAUSE: Management used proper funding source codes for the revenues received under the GEER, ESSER, and ARP ESSER federal grant programs, but erroneously did not realize the federal funding source coding applied to expenditures as well. QUESTIONED COSTS: None RECOMMENDATION: I am recommending that the School District properly follow the guidance contained within the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts for recording all expenditures of the School District, most specifically, federal program grant expenditures to 1) enhance internal controls for tracking and monitoring federal program expenditures and 2) comply with the recordkeeping requirements for federal funds as specified in Section 2 CFR Part 200.302(a) and 302(b) of the Uniform Guidance and PDE regulations. VIEWS OF RESPONSIBLE OFFICIALS: The School District concurs with the above noted finding and addresses this issue in the ‘Corrective Action Plan’ included within this report.
CONDITION: The District did not properly record its federal program expenditures for the GEER, ESSER, and ARP ESSER federal grant programs using the various federal funding source expenditure codes as prescribed by the Chart of Accounts for PA Local Educational Agencies maintained by the PA Office of the Budget, Office of Comptroller Operations. CRITERIA: The Pennsylvania Department of Education (PDE), through the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts requires School Districts to utilize specific funding source codes for federal program expenditures. In addition, Section 2 CFR 200.302(a) and 302(b) of the Uniform Guidance requires non-federal organizations such as the School District to maintain financial records which account for federal funds in such a manner as to be able to properly track the identification and use of federal funds. EFFECT: By not using federal source codes to properly track its federal program expenditures for the GEER, ESSER, and ARP ESSER federal grant programs, the School District did not comply with the financial reporting standards for federal program expenditures as prescribed by the Pennsylvania Department of Education, through the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts and Section 2 CFR 200.302(a) and 302(b) of the Uniform Guidance. This situation significantly reduced the District’s internal controls over the ability to properly manage and account for these federal program expenditures in accordance with the compliance requirements of PDE and the Uniform Guidance. CAUSE: Management used proper funding source codes for the revenues received under the GEER, ESSER, and ARP ESSER federal grant programs, but erroneously did not realize the federal funding source coding applied to expenditures as well. QUESTIONED COSTS: None RECOMMENDATION: I am recommending that the School District properly follow the guidance contained within the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts for recording all expenditures of the School District, most specifically, federal program grant expenditures to 1) enhance internal controls for tracking and monitoring federal program expenditures and 2) comply with the recordkeeping requirements for federal funds as specified in Section 2 CFR Part 200.302(a) and 302(b) of the Uniform Guidance and PDE regulations. VIEWS OF RESPONSIBLE OFFICIALS: The School District concurs with the above noted finding and addresses this issue in the ‘Corrective Action Plan’ included within this report.
CONDITION: During my sample review of the District’s completion of its federal grant program ‘Quarterly Cash On Hand Reconciliations’ for the 3rd and 4th fiscal quarters for the GEER grant and the 4th fiscal quarter for the ESSER II grant, I noted that the amounts reported to date for ‘total disbursements’ could not be ascertained from the coding of these expenditures in the District’s general ledger (See Finding 2021-005) and did not reconcile to the separate spreadsheets maintained by the School District. CRITERIA: Section 2 CFR 200.302(a) and 302(b) of the Uniform Guidance requires non-federal organizations such as the School District to maintain financial records which account for federal funds in such a manner as to be able to properly track the identification and use of federal funds.
EFFECT: The School District did not comply with Section 2 CFR 200.302(a) and 302(b) of the Uniform Guidance which prescribes the proper financial management system for the tracking of federal program expenditures.
CAUSE: The School District did not utilize the federal source code tracking system as prescribed by the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts, which would have enabled the District to print reports from the accounting software system, by federal source program, to properly prepare the quarterly reconciliations. It was not readily determinable as to why the ‘total disbursements’ line on the quarterly cash on hand reconciliations did not match the separate spreadsheets the School District utilized for tracking federal program expenditures.
QUESTIONED COSTS: None
RECOMMENDATION: I am recommending that the School District properly follow the guidance contained within the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts for recording all expenditures of the School District, most specifically, federal program grant expenditures to comply with the recordkeeping requirements for federal funds as specified in Section 2 CFR Part 200.302(a) and 302(b) of the Uniform Guidance, to allow for the proper completion of the ‘quarterly cash on hand reconciliations’.
VIEWS OF RESPONSIBLE OFFICIALS: The School District concurs with the above noted finding and addresses this issue in the ‘Corrective Action Plan’ included within this report.
CONDITION: During my review of the District’s compliance with the requirements for noncompetitive procurement, I noted the District did not document its rationale for purchases made from ‘CJAWS, Inc.’ totaling $140,389.
CRITERIA: In accordance with Section 2 CFR 200.318(i) of the Uniform Guidance, the District must maintain records sufficient to detail the history of procurement. These records include but are not limited to the rationale for the method of procurement, selection of contract type, contractor selection or rejection, and the basis for the contract price. Furthermore, Section 2 CFR 200.320(c’) of the Uniform Guidance details five (5) circumstances in which noncompetitive procurement can be used.
EFFECT: The District did not comply with Section 2 CFR 200.318(i) and Section 2 CFR 200.320(c’) of the Uniform Guidance regarding the proper documentation required for noncompetitive procurement.
QUESTIONED COST: $140,389
CAUSE: From a review of the School District’s policies as published on the District’s website, the District has not updated their policies to include those related to ‘federal fiscal compliance’ in accordance with the Uniform Guidance, in particular, procurement policies to address the requirements of Section 2 CFR 200.318(i) and 320(c).
RECOMMENDATION: I recommend that the School District update their policies to include those most recent related to ‘federal fiscal compliance’ in accordance with the Uniform Guidance, in particular, procurement policies to address the requirements of Section 2 CFR 200.318(i) and 320(c). In addition, I would recommend that District personnel responsible for expenditures related to federal funding receive updated training related to ‘procurement’ policies and procedures as they relate to federal funding.
VIEWS OF RESPONSIBLE OFFICIALS: The School District concurs with the above noted finding and addresses this issue in the ‘Corrective Action Plan’ included within this report.
CONDITION: The Cambria Heights School District contracted with a third-party vendor (Trafera) for the purchase of technology equipment. The contract with Trafera was procured through a cooperative purchasing group (COSTARS). The District did not obtain an adequate number of price or rate quotations for the technology equipment as required by the Uniform Guidance and 24 PS 8.807.1.
CRITERIA: As specified in Section 2 CFR 200. 318(i) of the Uniform Guidance, the District must maintain records sufficient to detail the history of procurement. These records will include, but are not necessarily limited to, the following: rationale for the method of procurement, selection of contract type, contractor selection or rejection, and the basis for the contract price. In addition, small purchase procedures per Section 2 CFR 200.320(a)(2)(i) for acquisitions between the micro-purchase threshold (currently $10,000) and the simplified acquisition threshold (current $250,000), price or rate quotations must be obtained from an adequate number of qualified sources as determined appropriate. Per 24 PS 8.807.1, there should be three quotes that are either written or well documented. The use of COSTARS only constitutes one quotation.
CAUSE: School District personnel directly responsible for the acquisition of the technology equipment through COSTARS interpreted that the requirements specified by Section 2 CFR 200.318(i) and Section 2 CFR 200.320(a)(2)(i), would be met by using this cooperative purchasing organization.
EFFECT: The School District did not comply with the requirements of 2 CFR 200.318(i) and 2 CFR 200.320(a)(2)(i) of the Uniform Guidance, and 24 PS 8.807.1, regarding maintaining records sufficient to detail the history of procurement for the technology equipment to ensure that an adequate number of price quotations were solicited for this purchase.
QUESTIONED COST: $106,250
RECOMMENDATION: I recommend that the School District update their policies to include those most recent related to ‘federal fiscal compliance’ in accordance with the Uniform Guidance, in particular, procurement policies to address the requirements of Section 2 CFR 200.318(i) and 2 CFR.320(a)(2)(i). In addition, I would recommend that District personnel responsible for expenditures related to federal funding receive updated training related to ‘procurement’ policies and procedures as they relate to federal funding.
VIEWS OF RESPONSIBLE OFFICIALS: The School District concurs with the above noted finding and addresses this issue in the ‘Corrective Action Plan’ included within this report.
CONDITION: The District did not maintain a general ledger system of accounting for its Cafeteria Fund which reports the financial activity of the federal National School Lunch and School Breakfast Programs. The financial activity occurring in this Fund is maintained in checkbook fashion during the fiscal year. This is a repeat finding (2020-004) from the previous fiscal year. CRITERIA: Prudent internal control over accounting for federal program funds requires non-federal organizations such as the School District to maintain financial records which account for federal funds in such a manner as to be able to properly track the receipt and use of federal funds as stated in Section 2 CFR Part 200 of the Uniform Guidance. Best practices suggest that the use of a general ledger system of accounting would enable the District to aggregate financial information involving federal funds during the fiscal year in such a manner to properly manage, monitor, and report the financial activity in compliance with federal program guidelines. EFFECT: The lack of maintaining a general ledger system of accounting for the District’s Cafeteria Fund significantly reduces the District-wide internal controls over the ability to properly manage and account for the assets contained within this Fund, as well as reduces the District’s ability to comply with the compliance requirements for internal control over financial reporting for federal programs as stated in Section 2 CFR Part 200 of the Uniform Guidance. CAUSE: As a result of the minimal staff size in the District’s business office, management has opted to simplify the process by which they account for and monitor the financial activities of the Cafeteria Fund by utilizing a checkbook system of accounting rather than maintaining a general ledger system of accounting for these Funds. QUESTIONED COSTS: None RECOMMENDATION: During the 2018-2019 fiscal year, the District implemented new accounting software that can readily account for the financial activity of all Funds in a manner like the District’s General Fund. I am recommending that the management of the School District utilize the new accounting software to enter the financial activity (Receipts and Disbursements) of the Cafeteria Fund in a manner like the General Fund. This procedure will significantly enhance the District-wide internal controls over financial reporting for the Cafeteria Fund, as well as provide management the ability to produce meaningful financial reports reflecting the activity in the Cafeteria Fund for prudent oversight by the Board of Education. In addition, this procedure will enable the District to comply with the recordkeeping requirements for federal funds as specified in Section 2 CFR Part 200 of the Uniform Guidance. VIEWS OF RESPONSIBLE OFFICIALS: The School District concurs with the above noted finding and addresses this issue in the ‘Corrective Action Plan’ included within this report.
CONDITION: The District did not maintain a general ledger system of accounting for its Cafeteria Fund which reports the financial activity of the federal National School Lunch and School Breakfast Programs. The financial activity occurring in this Fund is maintained in checkbook fashion during the fiscal year. This is a repeat finding (2020-004) from the previous fiscal year. CRITERIA: Prudent internal control over accounting for federal program funds requires non-federal organizations such as the School District to maintain financial records which account for federal funds in such a manner as to be able to properly track the receipt and use of federal funds as stated in Section 2 CFR Part 200 of the Uniform Guidance. Best practices suggest that the use of a general ledger system of accounting would enable the District to aggregate financial information involving federal funds during the fiscal year in such a manner to properly manage, monitor, and report the financial activity in compliance with federal program guidelines. EFFECT: The lack of maintaining a general ledger system of accounting for the District’s Cafeteria Fund significantly reduces the District-wide internal controls over the ability to properly manage and account for the assets contained within this Fund, as well as reduces the District’s ability to comply with the compliance requirements for internal control over financial reporting for federal programs as stated in Section 2 CFR Part 200 of the Uniform Guidance. CAUSE: As a result of the minimal staff size in the District’s business office, management has opted to simplify the process by which they account for and monitor the financial activities of the Cafeteria Fund by utilizing a checkbook system of accounting rather than maintaining a general ledger system of accounting for these Funds. QUESTIONED COSTS: None RECOMMENDATION: During the 2018-2019 fiscal year, the District implemented new accounting software that can readily account for the financial activity of all Funds in a manner like the District’s General Fund. I am recommending that the management of the School District utilize the new accounting software to enter the financial activity (Receipts and Disbursements) of the Cafeteria Fund in a manner like the General Fund. This procedure will significantly enhance the District-wide internal controls over financial reporting for the Cafeteria Fund, as well as provide management the ability to produce meaningful financial reports reflecting the activity in the Cafeteria Fund for prudent oversight by the Board of Education. In addition, this procedure will enable the District to comply with the recordkeeping requirements for federal funds as specified in Section 2 CFR Part 200 of the Uniform Guidance. VIEWS OF RESPONSIBLE OFFICIALS: The School District concurs with the above noted finding and addresses this issue in the ‘Corrective Action Plan’ included within this report.
CONDITION: The District did not maintain a general ledger system of accounting for its Cafeteria Fund which reports the financial activity of the federal National School Lunch and School Breakfast Programs. The financial activity occurring in this Fund is maintained in checkbook fashion during the fiscal year. This is a repeat finding (2020-004) from the previous fiscal year. CRITERIA: Prudent internal control over accounting for federal program funds requires non-federal organizations such as the School District to maintain financial records which account for federal funds in such a manner as to be able to properly track the receipt and use of federal funds as stated in Section 2 CFR Part 200 of the Uniform Guidance. Best practices suggest that the use of a general ledger system of accounting would enable the District to aggregate financial information involving federal funds during the fiscal year in such a manner to properly manage, monitor, and report the financial activity in compliance with federal program guidelines. EFFECT: The lack of maintaining a general ledger system of accounting for the District’s Cafeteria Fund significantly reduces the District-wide internal controls over the ability to properly manage and account for the assets contained within this Fund, as well as reduces the District’s ability to comply with the compliance requirements for internal control over financial reporting for federal programs as stated in Section 2 CFR Part 200 of the Uniform Guidance. CAUSE: As a result of the minimal staff size in the District’s business office, management has opted to simplify the process by which they account for and monitor the financial activities of the Cafeteria Fund by utilizing a checkbook system of accounting rather than maintaining a general ledger system of accounting for these Funds. QUESTIONED COSTS: None RECOMMENDATION: During the 2018-2019 fiscal year, the District implemented new accounting software that can readily account for the financial activity of all Funds in a manner like the District’s General Fund. I am recommending that the management of the School District utilize the new accounting software to enter the financial activity (Receipts and Disbursements) of the Cafeteria Fund in a manner like the General Fund. This procedure will significantly enhance the District-wide internal controls over financial reporting for the Cafeteria Fund, as well as provide management the ability to produce meaningful financial reports reflecting the activity in the Cafeteria Fund for prudent oversight by the Board of Education. In addition, this procedure will enable the District to comply with the recordkeeping requirements for federal funds as specified in Section 2 CFR Part 200 of the Uniform Guidance. VIEWS OF RESPONSIBLE OFFICIALS: The School District concurs with the above noted finding and addresses this issue in the ‘Corrective Action Plan’ included within this report.