2023-012– Support for Payroll Allocations Finding Type. Immaterial Noncompliance/Significant Deficiency in Internal Controls over Compliance (Allowable Costs/Cost Principles). Program. Community Block Grants/Entitlement Grants; U.S. Department of Housing and Urban Development; Assistance Listing Number 14.218; All awards. Criteria. Per 2 CFR § 200.430(g)(1)(vi), Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity." Condition. During testing it was noted that the actual amounts charged to the grant were initially charged using the allocation rates from the previous pay period, and subsequently adjusted to the proper amount through a manual journal entry. When factoring in the amounts of the journal entries, the amount charged to the grant still differed from the support provided for 3 items of the 29 tested. Cause. The City does not have the proper internal controls in place to ensure that all allocations of personnel cost are allocated according to the support retained. Effect. The City is exposed to an increased risk that future noncompliance could occur and not be prevented or detected by the City's internal controls. Questioned Costs. No costs were required to be questioned as a result of this finding inasmuch as the amount of likely questioned cost did not exceed the required threshold. Recommendation. We recommend that the City implement necessary internal controls to ensure that all allocations of personnel cost are allocated according to the support retained. View of Responsible Officials. The City will implement the necessary internal controls to ensure the policy for compliance is followed and documented.
2023-012– Support for Payroll Allocations Finding Type. Immaterial Noncompliance/Significant Deficiency in Internal Controls over Compliance (Allowable Costs/Cost Principles). Program. Community Block Grants/Entitlement Grants; U.S. Department of Housing and Urban Development; Assistance Listing Number 14.218; All awards. Criteria. Per 2 CFR § 200.430(g)(1)(vi), Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity." Condition. During testing it was noted that the actual amounts charged to the grant were initially charged using the allocation rates from the previous pay period, and subsequently adjusted to the proper amount through a manual journal entry. When factoring in the amounts of the journal entries, the amount charged to the grant still differed from the support provided for 3 items of the 29 tested. Cause. The City does not have the proper internal controls in place to ensure that all allocations of personnel cost are allocated according to the support retained. Effect. The City is exposed to an increased risk that future noncompliance could occur and not be prevented or detected by the City's internal controls. Questioned Costs. No costs were required to be questioned as a result of this finding inasmuch as the amount of likely questioned cost did not exceed the required threshold. Recommendation. We recommend that the City implement necessary internal controls to ensure that all allocations of personnel cost are allocated according to the support retained. View of Responsible Officials. The City will implement the necessary internal controls to ensure the policy for compliance is followed and documented.
Finding Number: 2023-003 Program: Research and Development Cluster – Geographic Programs-Great Lakes Restoration Initiative Federal Agency Name: Environmental Protection Agency Federal Award Year: July 1, 2022 – June 30, 2023 Federal Assistance Listing Numbers: 66.469 Finding Type: Significant Deficiency Compliance Requirement: Allowable Costs/Cost Principles Criteria The Uniform Guidance Section 200.430, states that charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities (iv) Encompass federally-assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity’s written policy; (v) Comply with the established accounting policies and practices of the non-Federal entity and (vi) Support the distribution of the employee’s salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. Further, in accordance with 2 CFR 200.303(a), non-federal entities must establish and maintain effective internal control over the federal award that provides reasonable assurance that the non-federal entity is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. Condition The University performs certain manual calculations when a faculty or graduate assistant has multiple appointments in order to determine the appropriate percentage allocation to each federal award or non-federal activity. During our testing internal controls and compliance over allowable costs/cost principles specific to payroll we noted that the University did not have internal controls designed at a sufficient level of precision to detect errors in manual calculations when the employee has more than one supplemental pay authorization. As a result we noted that, 2 out of 62 payroll transactions tested the amount allocated and charged to the grant was incorrect. We noted that the 2 transactions were for the same employee and impacted the same award. Cause In discussing this with the University, this employee had submitted two separate payroll authorizations for his summer research salary at different times and a manual calculation error was made in the allocation to the appropriate grant. The University’s internal controls over review of supplemental pay authorizations did not include a secondary review of the calculation by someone other than the preparer before the allocation was input into the payroll system. Effect The lack of internal controls at a sufficient level of precision and in particular where there are manual calculations can result in incorrect allocations and charges to federal awards and ultimately unallowable costs. Questioned Costs None. Statistical Sampling Our sample was not and was not intended to be statistically valid. Identification of Whether the Audit Finding was a Repeat Finding This finding is a repeat finding in the immediately prior audit finding 2022-003 Recommendation We recommend that the University implement a more thorough and detailed process and related internal controls to review payroll authorization forms and manual calculations performed before the payroll allocation is recorded to the federal grant, including a review by someone other than the preparer.
Criteria: 2 CFR 200.430(h)(8)(i) requires that amounts of personnel expenses are properly documented and include appropriate controls and documentation to support the distribution of the employee's wages among specific activities if the employee works on more than one award. Condition: Of the testing population of 60 payroll transactions tested, for 10 transactions the Organization was unable to provide a timesheet or other documentation to substantiate the application of the individual's time for that period. In addition for 17 transactions, the allocation on the time sheet provided does not agree to the allocation of the individual's wages to the program in the general ledger and voucher. Cause: Due to limited staffing resources, the Organization was not able to ensure maintenance of adequate documentation. Effect: The Organization is not able to demonstrate that the personnel expenses allocated to the grant was proper and ensure avoidance of duplication of funding requests for the same amounts. Questioned Costs: Unknown Recommendation: Management should review and refine its process of tracking payroll costs by grant to ensure that the costs are supported by a system of internal controls which provides reasonable assurance that the charges are accurate, are properly allocated, and reasonably reflect the total activity for which the employee is compensated. Views of Responsible Officials: Management agrees with the finding; see corrective action plan.
2023-003 Allowable Costs/Cost Principles Federal Program Information Funding Agency: U.S. Department of Education Title: Title I Grants to Local Educational Agencies AL Number: 84.010 Criteria In accordance with 2 CFR Section 200.430(g)(1)(vi), the District must document employee time and effort spent in the Title I program, if under the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. Furthermore, a system of internal controls would have an entity file all approved wages in the employee personal file. Condition The District was missing documentation to support time and effort of faculty members who had wages less than 100% being charged to the Title I program. Also, we noted during testing that 1 employee of the 11 hourly employees tested had the timecard not calculated correctly and 7 time documents out of 48 tested did not have the proper approval. Questioned Costs None Context The District had recorded partial or entire salaries of 132 employees to the program. Of this listing of employees, we tested 11. Effect Expenditures improperly or inaccurately being charged to the program. Cause Management oversight. Recommendation We recommend the District require all faculty in the Title I program complete time and effort reports. We also recommend that the District calculates timecards to be reviewed before payroll is processed. We also recommend the District implement a policy that all timecards submitted are reviewed and approved by employee’s supervisor. Repeat Finding This is a repeat finding of 2022-005. Views of Responsible Officials See corrective action plan.
Criteria: In accordance with 2 CFR 200 Subpart E, the University is required to conform to allowability of cost provisions, and 2 CFR 200.303 requires the organization to establish and maintain effective controls over federal awards. Allowable costs charged to federal programs, whether direct or indirect, must be allowable and be determined in accordance with Subpart E – Cost Principles of the Uniform Guidance. Effective internal controls should include procedures to ensure federal expenditures and amounts are for activities allowed or unallowed and allowable costs/cost principles, as well as accurately and completely reported on the SEFA. According to 2 CFR 200.430, charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control that provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the recipient or subrecipient; (iii) Reasonably reflect the total activity for which the employee is compensated by the recipient or subrecipient, not exceeding 100 percent of compensated activities; (iv) Encompass federally-assisted and all other activities compensated by the recipient or subrecipient on an integrated basis but may include the use of subsidiary records as defined in the recipient's or subrecipient's written policy; (v) Comply with the established accounting policies and procedures of the recipient or subrecipient and (vi) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. Condition and Context: The University receives Supplemental Nutrition Assistance Program (SNAP) Cluster program funding at its Sacramento campus to perform nutrition outreach and education services to residents of the State of California. The Sacramento campus administers the SNAP Cluster nutrition education programs through its College of Continuing Education (CCE) and Population Research Center (PRC) offices. SNAP Cluster program expenditures are primarily comprised of payroll for program personnel performing various program activities and related fringe benefits and indirect costs. During our testing of 18 payroll expenditures for CCE employees (totaling $90,946) and 40 payroll expenditures for PRC employees (totaling $66,458), we noted effort reports detailing 100% of the employee's activities were not prepared for certain employees. Upon further investigation and discussion with CCE and PRC program management, we noted effort reports were not prepared for any employees whose payroll expenditures were charged to the SNAP Cluster program, except for student workers who solely worked on SNAP Cluster program activities. The payroll expenditures and related costs impacted by the inadequate effort reports, are described in the table below: Expenditure category Questioned costs Excerpt of total SNAP Cluster program expenditures by impacted expenditure category Payroll $1,151,941 $1,354,046 Fringe benefits $641,501 $641,501 Indirect costs $448,286 $660,709 Total $2,241,728 $2,656,257 Total SNAP Cluster program expenditures were $3,688,927 for the year ended June 30, 2023. We noted additional instances of noncompliance as follows: • In our testing of 58 payroll expenditures, the hourly payroll rates used to prepare the quarterly payroll remittances submitted to the State of California exceeded the actual payroll rates paid for 15 employees resulting in an overcharge of payroll, fringe benefits, and indirect costs to the SNAP program of $11,710, $9,684, and $5,348, respectively. As these 15 employees did not have effort reports as discussed above, payroll, fringe benefits, and indirect costs associated with these 15 employees has already been included in the table above. • One individually significant payroll expenditure that was associated with one employee was double counted in the quarterly State of California remittance billing resulting in an overcharge to the SNAP Cluster program of $27,004, $10,801, and $9,451, respectively. As the employee did not have an effort report as discussed above, payroll, fringe benefits, and indirect costs associated with this employee has already been included in the table above. • In our testing of 7 indirect cost charges, we identified 4 indirect cost charges that utilized higher than the allowed hourly rates within the calculation. These 4 indirect cost charges related to CCE employees in which the hourly rate listed in the program agreement was billed versus the employee’s actual hourly pay rate and fringe benefit costs. As a result, the total payroll charges used to bill the indirect cost rate of 25% utilized unallowable payroll expenditures, which resulted in the SNAP Cluster program being overcharged by $46,922. As these employees also did not have effort reports as discussed above, payroll, fringe benefits, and indirect costs associated with these CCE employees has already been included in the table above. In addition, we noted the Sacramento campus has not established adequate internal controls to ensure: (1) payroll expenditures charged to the SNAP Cluster program are properly determined and supported in accordance with the requirements of the Uniform Guidance and (2) fringe benefit and indirect costs are properly calculated by applying the approved fringe or indirect cost rate to a base that includes only allowable costs. Cause & Effect: The errors noted above were primarily due to insufficient controls over the establishment and tracking of SNAP Cluster program activities as federal funding within Sacramento’s general ledger. As a result, a portion of SNAP program expenditures and activities were not processed in accordance with applicable federal guidelines. Additional errors noted above relate to insufficient controls over the accuracy of the payroll, fringe benefits, and indirect cost charged to the SNAP Cluster program. The inadequate review procedures over payroll, fringe benefits, and indirect cost expenditures resulted in unallowable charges to the SNAP Cluster program in the amount of $2,241,728.
FINDING 2023-004 Subject: Child Nutrition Cluster - Allowable Costs/Cost Principles Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, Summer Food Service Program for Children Assistance Listings Numbers: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): FY2022, FY2023 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Allowable Costs/Cost Principles Audit Findings: Material Weakness, Other Matters Condition and Context A cash reimbursement is provided to the School Corporation based on meals served under the School Breakfast Program, National School Lunch Program, and Summer Food Service Program for Children. The cash reimbursement is to be used for the benefit of the food service program. An effective system of internal controls, which would include segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance should be designed and implemented to ensure expenditures charged to the food service program fund (fund 800) are for the benefit of the food service program. The School Corporation's process for payroll disbursements included a segregation of duties; however, no individual reviewer or approver was provided detailed payroll information that would have allowed them to determine the expense was being paid from the food service program. Due to the lack of internal controls, the School Corporation paid $23,682 of administrative salaries based on fixed percentages without supporting documentation to indicate how the percentages were determined or time records indicating time spent on the program by the applicable administrators. The amount paid, $23,682, is considered questioned costs. INDIANA STATE BOARD OF ACCOUNTS 19 SHENANDOAH SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) The lack of internal controls was a systemic issue throughout the audit period. The noncompliance was isolated to the salaries identified above. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.403 states in part: "Except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: (a) Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles. (b) Conform to any limitations or exclusions set forth in these principles or in the Federal award as to types or amount of cost items. . . . (g) Be adequately documented. . . ." 2 CFR 200.430 states in part: "Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non- Federal entity, not exceeding 100% of compensated activities . . . (vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; or two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. . . ." INDIANA STATE BOARD OF ACCOUNTS 20 SHENANDOAH SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause A proper system of internal controls was not designed by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, administrative payroll was charged to the school lunch fund without appropriate supporting documentation. Noncompliance with the grant agreement and the compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs Known questioned costs of $23,682 were identified as noted in the Condition and Context. Recommendation We recommended the School Corporation's management establish a proper system of internal controls and develop policies and procedures to ensure costs are adequately documented. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-004 Subject: Child Nutrition Cluster - Allowable Costs/Cost Principles Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, Summer Food Service Program for Children Assistance Listings Numbers: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): FY2022, FY2023 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Allowable Costs/Cost Principles Audit Findings: Material Weakness, Other Matters Condition and Context A cash reimbursement is provided to the School Corporation based on meals served under the School Breakfast Program, National School Lunch Program, and Summer Food Service Program for Children. The cash reimbursement is to be used for the benefit of the food service program. An effective system of internal controls, which would include segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance should be designed and implemented to ensure expenditures charged to the food service program fund (fund 800) are for the benefit of the food service program. The School Corporation's process for payroll disbursements included a segregation of duties; however, no individual reviewer or approver was provided detailed payroll information that would have allowed them to determine the expense was being paid from the food service program. Due to the lack of internal controls, the School Corporation paid $23,682 of administrative salaries based on fixed percentages without supporting documentation to indicate how the percentages were determined or time records indicating time spent on the program by the applicable administrators. The amount paid, $23,682, is considered questioned costs. INDIANA STATE BOARD OF ACCOUNTS 19 SHENANDOAH SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) The lack of internal controls was a systemic issue throughout the audit period. The noncompliance was isolated to the salaries identified above. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.403 states in part: "Except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: (a) Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles. (b) Conform to any limitations or exclusions set forth in these principles or in the Federal award as to types or amount of cost items. . . . (g) Be adequately documented. . . ." 2 CFR 200.430 states in part: "Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non- Federal entity, not exceeding 100% of compensated activities . . . (vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; or two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. . . ." INDIANA STATE BOARD OF ACCOUNTS 20 SHENANDOAH SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause A proper system of internal controls was not designed by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, administrative payroll was charged to the school lunch fund without appropriate supporting documentation. Noncompliance with the grant agreement and the compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs Known questioned costs of $23,682 were identified as noted in the Condition and Context. Recommendation We recommended the School Corporation's management establish a proper system of internal controls and develop policies and procedures to ensure costs are adequately documented. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-004 Subject: Child Nutrition Cluster - Allowable Costs/Cost Principles Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, Summer Food Service Program for Children Assistance Listings Numbers: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): FY2022, FY2023 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Allowable Costs/Cost Principles Audit Findings: Material Weakness, Other Matters Condition and Context A cash reimbursement is provided to the School Corporation based on meals served under the School Breakfast Program, National School Lunch Program, and Summer Food Service Program for Children. The cash reimbursement is to be used for the benefit of the food service program. An effective system of internal controls, which would include segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance should be designed and implemented to ensure expenditures charged to the food service program fund (fund 800) are for the benefit of the food service program. The School Corporation's process for payroll disbursements included a segregation of duties; however, no individual reviewer or approver was provided detailed payroll information that would have allowed them to determine the expense was being paid from the food service program. Due to the lack of internal controls, the School Corporation paid $23,682 of administrative salaries based on fixed percentages without supporting documentation to indicate how the percentages were determined or time records indicating time spent on the program by the applicable administrators. The amount paid, $23,682, is considered questioned costs. INDIANA STATE BOARD OF ACCOUNTS 19 SHENANDOAH SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) The lack of internal controls was a systemic issue throughout the audit period. The noncompliance was isolated to the salaries identified above. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.403 states in part: "Except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: (a) Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles. (b) Conform to any limitations or exclusions set forth in these principles or in the Federal award as to types or amount of cost items. . . . (g) Be adequately documented. . . ." 2 CFR 200.430 states in part: "Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non- Federal entity, not exceeding 100% of compensated activities . . . (vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; or two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. . . ." INDIANA STATE BOARD OF ACCOUNTS 20 SHENANDOAH SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause A proper system of internal controls was not designed by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, administrative payroll was charged to the school lunch fund without appropriate supporting documentation. Noncompliance with the grant agreement and the compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs Known questioned costs of $23,682 were identified as noted in the Condition and Context. Recommendation We recommended the School Corporation's management establish a proper system of internal controls and develop policies and procedures to ensure costs are adequately documented. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-004 Subject: Child Nutrition Cluster - Allowable Costs/Cost Principles Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, Summer Food Service Program for Children Assistance Listings Numbers: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): FY2022, FY2023 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Allowable Costs/Cost Principles Audit Findings: Material Weakness, Other Matters Condition and Context A cash reimbursement is provided to the School Corporation based on meals served under the School Breakfast Program, National School Lunch Program, and Summer Food Service Program for Children. The cash reimbursement is to be used for the benefit of the food service program. An effective system of internal controls, which would include segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance should be designed and implemented to ensure expenditures charged to the food service program fund (fund 800) are for the benefit of the food service program. The School Corporation's process for payroll disbursements included a segregation of duties; however, no individual reviewer or approver was provided detailed payroll information that would have allowed them to determine the expense was being paid from the food service program. Due to the lack of internal controls, the School Corporation paid $23,682 of administrative salaries based on fixed percentages without supporting documentation to indicate how the percentages were determined or time records indicating time spent on the program by the applicable administrators. The amount paid, $23,682, is considered questioned costs. INDIANA STATE BOARD OF ACCOUNTS 19 SHENANDOAH SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) The lack of internal controls was a systemic issue throughout the audit period. The noncompliance was isolated to the salaries identified above. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.403 states in part: "Except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: (a) Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles. (b) Conform to any limitations or exclusions set forth in these principles or in the Federal award as to types or amount of cost items. . . . (g) Be adequately documented. . . ." 2 CFR 200.430 states in part: "Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non- Federal entity, not exceeding 100% of compensated activities . . . (vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; or two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. . . ." INDIANA STATE BOARD OF ACCOUNTS 20 SHENANDOAH SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause A proper system of internal controls was not designed by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, administrative payroll was charged to the school lunch fund without appropriate supporting documentation. Noncompliance with the grant agreement and the compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs Known questioned costs of $23,682 were identified as noted in the Condition and Context. Recommendation We recommended the School Corporation's management establish a proper system of internal controls and develop policies and procedures to ensure costs are adequately documented. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-004 Subject: Child Nutrition Cluster - Allowable Costs/Cost Principles Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, Summer Food Service Program for Children Assistance Listings Numbers: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): FY2022, FY2023 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Allowable Costs/Cost Principles Audit Findings: Material Weakness, Other Matters Condition and Context A cash reimbursement is provided to the School Corporation based on meals served under the School Breakfast Program, National School Lunch Program, and Summer Food Service Program for Children. The cash reimbursement is to be used for the benefit of the food service program. An effective system of internal controls, which would include segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance should be designed and implemented to ensure expenditures charged to the food service program fund (fund 800) are for the benefit of the food service program. The School Corporation's process for payroll disbursements included a segregation of duties; however, no individual reviewer or approver was provided detailed payroll information that would have allowed them to determine the expense was being paid from the food service program. Due to the lack of internal controls, the School Corporation paid $23,682 of administrative salaries based on fixed percentages without supporting documentation to indicate how the percentages were determined or time records indicating time spent on the program by the applicable administrators. The amount paid, $23,682, is considered questioned costs. INDIANA STATE BOARD OF ACCOUNTS 19 SHENANDOAH SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) The lack of internal controls was a systemic issue throughout the audit period. The noncompliance was isolated to the salaries identified above. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.403 states in part: "Except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: (a) Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles. (b) Conform to any limitations or exclusions set forth in these principles or in the Federal award as to types or amount of cost items. . . . (g) Be adequately documented. . . ." 2 CFR 200.430 states in part: "Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non- Federal entity, not exceeding 100% of compensated activities . . . (vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; or two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. . . ." INDIANA STATE BOARD OF ACCOUNTS 20 SHENANDOAH SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause A proper system of internal controls was not designed by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, administrative payroll was charged to the school lunch fund without appropriate supporting documentation. Noncompliance with the grant agreement and the compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs Known questioned costs of $23,682 were identified as noted in the Condition and Context. Recommendation We recommended the School Corporation's management establish a proper system of internal controls and develop policies and procedures to ensure costs are adequately documented. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-010 Subject: COVID-19 - Education Stabilization Fund - Allowable Costs/Cost Principles Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D210013, S425U210013 Pass-Through Entity: Department of Education Compliance Requirement: Allowable Costs/Cost Principles Audit Findings: Material Weakness, Other Matters Condition and Context The Elementary and Secondary School Emergency Relief (ESSER) Fund provided funding to states and school districts to help safely reopen and sustain the safe operation of schools and to address the impact of the coronavirus pandemic on the nation's students. States were required to subgrant a portion of their ESSER allocations to Local Educational Agencies (LEA). Prior to the LEAs receiving their respective subgrants, the LEAs were required to complete an application for the ESSER funding, which was submitted to the Indiana Department of Education (IDOE), the pass-through entity for approval. The application included a district level budget identifying how the LEA intended to spend program funds. A sample of 25 claims charged to the ESSER grant program for which reimbursement was received during the audit period was selected for testing to verify that the expenditures were in conformance with the applicable cost principles. Of the 25 claims tested, the following errors were noted: INDIANA STATE BOARD OF ACCOUNTS 32 SHENANDOAH SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Two claims, totaling $983, were for payments to a teacher for part-time tutoring. However, there was not a School Board approved contract or Salary Ordinance that showed the approval of this position or the rate to be paid. Two claims, totaling $318,922, were for payments for playground equipment; however, the related contract supporting the purchase was not provided. The lack of effective internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.403 states in part: "Except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: (a) Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles. (b) Conform to any limitations or exclusions set forth in these principles or in the Federal award as to types or amount of cost items. . . . (g) Be adequately documented. . . ." 2 CFR 200.430(i) states in part: "Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non- Federal entity, not exceeding 100% of compensated activities (for IHE, this per the IHE's definition of IBS); . . . INDIANA STATE BOARD OF ACCOUNTS 33 SHENANDOAH SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. . . ." Cause A proper system of internal controls was not designed by the School Corporation's management. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, expenses were paid without adequate supporting documentation. Noncompliance with the grant agreement and the compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a proper system of internal controls and develop policies and procedures to ensure costs are adequately documented. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-010 Subject: COVID-19 - Education Stabilization Fund - Allowable Costs/Cost Principles Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D210013, S425U210013 Pass-Through Entity: Department of Education Compliance Requirement: Allowable Costs/Cost Principles Audit Findings: Material Weakness, Other Matters Condition and Context The Elementary and Secondary School Emergency Relief (ESSER) Fund provided funding to states and school districts to help safely reopen and sustain the safe operation of schools and to address the impact of the coronavirus pandemic on the nation's students. States were required to subgrant a portion of their ESSER allocations to Local Educational Agencies (LEA). Prior to the LEAs receiving their respective subgrants, the LEAs were required to complete an application for the ESSER funding, which was submitted to the Indiana Department of Education (IDOE), the pass-through entity for approval. The application included a district level budget identifying how the LEA intended to spend program funds. A sample of 25 claims charged to the ESSER grant program for which reimbursement was received during the audit period was selected for testing to verify that the expenditures were in conformance with the applicable cost principles. Of the 25 claims tested, the following errors were noted: INDIANA STATE BOARD OF ACCOUNTS 32 SHENANDOAH SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Two claims, totaling $983, were for payments to a teacher for part-time tutoring. However, there was not a School Board approved contract or Salary Ordinance that showed the approval of this position or the rate to be paid. Two claims, totaling $318,922, were for payments for playground equipment; however, the related contract supporting the purchase was not provided. The lack of effective internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.403 states in part: "Except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: (a) Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles. (b) Conform to any limitations or exclusions set forth in these principles or in the Federal award as to types or amount of cost items. . . . (g) Be adequately documented. . . ." 2 CFR 200.430(i) states in part: "Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non- Federal entity, not exceeding 100% of compensated activities (for IHE, this per the IHE's definition of IBS); . . . INDIANA STATE BOARD OF ACCOUNTS 33 SHENANDOAH SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. . . ." Cause A proper system of internal controls was not designed by the School Corporation's management. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, expenses were paid without adequate supporting documentation. Noncompliance with the grant agreement and the compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a proper system of internal controls and develop policies and procedures to ensure costs are adequately documented. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-010 Subject: COVID-19 - Education Stabilization Fund - Allowable Costs/Cost Principles Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D210013, S425U210013 Pass-Through Entity: Department of Education Compliance Requirement: Allowable Costs/Cost Principles Audit Findings: Material Weakness, Other Matters Condition and Context The Elementary and Secondary School Emergency Relief (ESSER) Fund provided funding to states and school districts to help safely reopen and sustain the safe operation of schools and to address the impact of the coronavirus pandemic on the nation's students. States were required to subgrant a portion of their ESSER allocations to Local Educational Agencies (LEA). Prior to the LEAs receiving their respective subgrants, the LEAs were required to complete an application for the ESSER funding, which was submitted to the Indiana Department of Education (IDOE), the pass-through entity for approval. The application included a district level budget identifying how the LEA intended to spend program funds. A sample of 25 claims charged to the ESSER grant program for which reimbursement was received during the audit period was selected for testing to verify that the expenditures were in conformance with the applicable cost principles. Of the 25 claims tested, the following errors were noted: INDIANA STATE BOARD OF ACCOUNTS 32 SHENANDOAH SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Two claims, totaling $983, were for payments to a teacher for part-time tutoring. However, there was not a School Board approved contract or Salary Ordinance that showed the approval of this position or the rate to be paid. Two claims, totaling $318,922, were for payments for playground equipment; however, the related contract supporting the purchase was not provided. The lack of effective internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.403 states in part: "Except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: (a) Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles. (b) Conform to any limitations or exclusions set forth in these principles or in the Federal award as to types or amount of cost items. . . . (g) Be adequately documented. . . ." 2 CFR 200.430(i) states in part: "Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non- Federal entity, not exceeding 100% of compensated activities (for IHE, this per the IHE's definition of IBS); . . . INDIANA STATE BOARD OF ACCOUNTS 33 SHENANDOAH SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. . . ." Cause A proper system of internal controls was not designed by the School Corporation's management. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, expenses were paid without adequate supporting documentation. Noncompliance with the grant agreement and the compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a proper system of internal controls and develop policies and procedures to ensure costs are adequately documented. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-010 Subject: COVID-19 - Education Stabilization Fund - Allowable Costs/Cost Principles Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D210013, S425U210013 Pass-Through Entity: Department of Education Compliance Requirement: Allowable Costs/Cost Principles Audit Findings: Material Weakness, Other Matters Condition and Context The Elementary and Secondary School Emergency Relief (ESSER) Fund provided funding to states and school districts to help safely reopen and sustain the safe operation of schools and to address the impact of the coronavirus pandemic on the nation's students. States were required to subgrant a portion of their ESSER allocations to Local Educational Agencies (LEA). Prior to the LEAs receiving their respective subgrants, the LEAs were required to complete an application for the ESSER funding, which was submitted to the Indiana Department of Education (IDOE), the pass-through entity for approval. The application included a district level budget identifying how the LEA intended to spend program funds. A sample of 25 claims charged to the ESSER grant program for which reimbursement was received during the audit period was selected for testing to verify that the expenditures were in conformance with the applicable cost principles. Of the 25 claims tested, the following errors were noted: INDIANA STATE BOARD OF ACCOUNTS 32 SHENANDOAH SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Two claims, totaling $983, were for payments to a teacher for part-time tutoring. However, there was not a School Board approved contract or Salary Ordinance that showed the approval of this position or the rate to be paid. Two claims, totaling $318,922, were for payments for playground equipment; however, the related contract supporting the purchase was not provided. The lack of effective internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.403 states in part: "Except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: (a) Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles. (b) Conform to any limitations or exclusions set forth in these principles or in the Federal award as to types or amount of cost items. . . . (g) Be adequately documented. . . ." 2 CFR 200.430(i) states in part: "Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non- Federal entity, not exceeding 100% of compensated activities (for IHE, this per the IHE's definition of IBS); . . . INDIANA STATE BOARD OF ACCOUNTS 33 SHENANDOAH SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. . . ." Cause A proper system of internal controls was not designed by the School Corporation's management. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, expenses were paid without adequate supporting documentation. Noncompliance with the grant agreement and the compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a proper system of internal controls and develop policies and procedures to ensure costs are adequately documented. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
2023-003 (2022-003) – Payroll Time Approval – Significant Deficiency in Internal Controls over Compliance ALN: 84.126 Federal Award Title: Rehabilitation Services Vocational Rehabilitation Grants to States Federal Agency: United States Department of Education Pass-Through Entity: Texas Health and Human Services Commission Award Number(s): HHS000186000005, HHS000202900008 Federal Award Year: 2023 Condition: During our review of payroll related transactions, 2 of the 25 payroll samples tested did not have review and approval of the Executive Director or Employee on the timecard. Criteria: 2 CFR section 200.303 – Internal Controls of the Uniform Guidance states that the non-federal entity must: (a) Establish and maintain effective internal controls over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Per 2 CFR section 200.430 – Compensation – personal services, paragraph (i) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. Effect: The Organization may unintentionally under/over compensate what is applicable for the work performed by that employee. This could lead to questioned costs and repayment of funds to the grantor agency. Cause: The Organization does not have proper controls in place to verify that documentation was maintained to indicate the employees’ time paid under the Federal grant. Questioned Costs: No questioned costs identified.
2023-003 (2022-003) – Payroll Time Approval – Significant Deficiency in Internal Controls over Compliance ALN: 84.126 Federal Award Title: Rehabilitation Services Vocational Rehabilitation Grants to States Federal Agency: United States Department of Education Pass-Through Entity: Texas Health and Human Services Commission Award Number(s): HHS000186000005, HHS000202900008 Federal Award Year: 2023 Condition: During our review of payroll related transactions, 2 of the 25 payroll samples tested did not have review and approval of the Executive Director or Employee on the timecard. Criteria: 2 CFR section 200.303 – Internal Controls of the Uniform Guidance states that the non-federal entity must: (a) Establish and maintain effective internal controls over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Per 2 CFR section 200.430 – Compensation – personal services, paragraph (i) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. Effect: The Organization may unintentionally under/over compensate what is applicable for the work performed by that employee. This could lead to questioned costs and repayment of funds to the grantor agency. Cause: The Organization does not have proper controls in place to verify that documentation was maintained to indicate the employees’ time paid under the Federal grant. Questioned Costs: No questioned costs identified.
Opioid STR Grant ALN 93.788 Criteria The Office of Management and Budget issuance of the Code of Federal Regulations (CFR) specifically states uniform administrative requirements, cost principles, and audit requirements for federal awards. CFR 200.430(i)(viii) states, “Budget estimates alone do not qualify as support for charges to Federal awards, but may be used for interim accounting purposes, provided that: (A) the system for establishing the estimates produces reasonable approximations of the activity actually performed; (B) significant changes in the corresponding work activity are identified and entered into the records in a timely manner; and (C) the non-Federal entity’s system of internal controls includes processes to review after-the-fact interim charges made to a Federal award based on budget estimates. All necessary adjustment must be made such that the final amount charged to the Federal award is accurate, allowable, and properly allocated.” Condition During the course of the audit, we noted that employee time charged to multiple programs was based on an estimated percentage of time established at the beginning of the fiscal year. The methodology is allowable when an after-the-fact review of the estimate is completed to ensure the federal award is charged the proper amount. The Organization reviews and adjusts allocations annually but makes changes on a prospective basis. Cause The Organization’s internal controls do not include a process for adjustments to estimated percentages for charging employee time. Effect The potential effects of not reconciling contemporaneous time and effort reporting to allocated payroll expenses could include an over or understatement of salary expenses allocated to the federal grant. Questioned Costs None Perspective Information The finding noted related to four (4) pay periods tested where it was noted that no allocation based on actual time spent on the grants was performed. It was noted that all employees tested were allocated 100% to the grant. Identification as a repeat finding There was a similar finding in the prior year. Recommendation We recommend the Organization develop a process to review the percentages used to charge employee time to the Federal grants during the fiscal year and update accounting records accordingly. View of Responsible Official Currently, the Organization’s CEO and the bookkeeper will review each grant’s funding details prior to the grant’s fiscal year to determine how each employee’s salary percentages should be allocated according to the grant contract. Throughout the fiscal year, the CEO and bookkeeper will meet regularly to review and incorporate any new hires to determine how their salary is expected to be allocated. Additionally, the outsourced accountant will review the allocations periodically throughout the year to ensure that it is being done properly. Over the next year, as considered efficient, the Organization will implement a daily timesheet record, which requires each program service employee to classify their daily time between federal grant programs. At the end of each week, staff members will submit their timesheet to their supervisor. The supervisor will review each week’s daily timesheet to confirm the staff are recognizing their activities properly. At the end of each month, the Organization’s outsourced accountant, will review these timesheets and determine the proper allocation needed to record each employee’s payroll activities in the accounting software by appropriate federal program. This process will allow for the allocation of actuals to each federal program by the end of the month.
Opioid STR Grant ALN 93.788 Criteria The Office of Management and Budget issuance of the Code of Federal Regulations (CFR) specifically states uniform administrative requirements, cost principles, and audit requirements for federal awards. CFR 200.430(i)(viii) states, “Budget estimates alone do not qualify as support for charges to Federal awards, but may be used for interim accounting purposes, provided that: (A) the system for establishing the estimates produces reasonable approximations of the activity actually performed; (B) significant changes in the corresponding work activity are identified and entered into the records in a timely manner; and (C) the non-Federal entity’s system of internal controls includes processes to review after-the-fact interim charges made to a Federal award based on budget estimates. All necessary adjustment must be made such that the final amount charged to the Federal award is accurate, allowable, and properly allocated.” Condition During the course of the audit, we noted that employee time charged to multiple programs was based on an estimated percentage of time established at the beginning of the fiscal year. The methodology is allowable when an after-the-fact review of the estimate is completed to ensure the federal award is charged the proper amount. The Organization reviews and adjusts allocations annually but makes changes on a prospective basis. Cause The Organization’s internal controls do not include a process for adjustments to estimated percentages for charging employee time. Effect The potential effects of not reconciling contemporaneous time and effort reporting to allocated payroll expenses could include an over or understatement of salary expenses allocated to the federal grant. Questioned Costs None Perspective Information The finding noted related to four (4) pay periods tested where it was noted that no allocation based on actual time spent on the grants was performed. It was noted that all employees tested were allocated 100% to the grant. Identification as a repeat finding There was a similar finding in the prior year. Recommendation We recommend the Organization develop a process to review the percentages used to charge employee time to the Federal grants during the fiscal year and update accounting records accordingly. View of Responsible Official Currently, the Organization’s CEO and the bookkeeper will review each grant’s funding details prior to the grant’s fiscal year to determine how each employee’s salary percentages should be allocated according to the grant contract. Throughout the fiscal year, the CEO and bookkeeper will meet regularly to review and incorporate any new hires to determine how their salary is expected to be allocated. Additionally, the outsourced accountant will review the allocations periodically throughout the year to ensure that it is being done properly. Over the next year, as considered efficient, the Organization will implement a daily timesheet record, which requires each program service employee to classify their daily time between federal grant programs. At the end of each week, staff members will submit their timesheet to their supervisor. The supervisor will review each week’s daily timesheet to confirm the staff are recognizing their activities properly. At the end of each month, the Organization’s outsourced accountant, will review these timesheets and determine the proper allocation needed to record each employee’s payroll activities in the accounting software by appropriate federal program. This process will allow for the allocation of actuals to each federal program by the end of the month.
Opioid STR Grant ALN 93.788 Criteria The Office of Management and Budget issuance of the Code of Federal Regulations (CFR) specifically states uniform administrative requirements, cost principles, and audit requirements for federal awards. CFR 200.430(i)(viii) states, “Budget estimates alone do not qualify as support for charges to Federal awards, but may be used for interim accounting purposes, provided that: (A) the system for establishing the estimates produces reasonable approximations of the activity actually performed; (B) significant changes in the corresponding work activity are identified and entered into the records in a timely manner; and (C) the non-Federal entity’s system of internal controls includes processes to review after-the-fact interim charges made to a Federal award based on budget estimates. All necessary adjustment must be made such that the final amount charged to the Federal award is accurate, allowable, and properly allocated.” Condition During the course of the audit, we noted that employee time charged to multiple programs was based on an estimated percentage of time established at the beginning of the fiscal year. The methodology is allowable when an after-the-fact review of the estimate is completed to ensure the federal award is charged the proper amount. The Organization reviews and adjusts allocations annually but makes changes on a prospective basis. Cause The Organization’s internal controls do not include a process for adjustments to estimated percentages for charging employee time. Effect The potential effects of not reconciling contemporaneous time and effort reporting to allocated payroll expenses could include an over or understatement of salary expenses allocated to the federal grant. Questioned Costs None Perspective Information The finding noted related to four (4) pay periods tested where it was noted that no allocation based on actual time spent on the grants was performed. It was noted that all employees tested were allocated 100% to the grant. Identification as a repeat finding There was a similar finding in the prior year. Recommendation We recommend the Organization develop a process to review the percentages used to charge employee time to the Federal grants during the fiscal year and update accounting records accordingly. View of Responsible Official Currently, the Organization’s CEO and the bookkeeper will review each grant’s funding details prior to the grant’s fiscal year to determine how each employee’s salary percentages should be allocated according to the grant contract. Throughout the fiscal year, the CEO and bookkeeper will meet regularly to review and incorporate any new hires to determine how their salary is expected to be allocated. Additionally, the outsourced accountant will review the allocations periodically throughout the year to ensure that it is being done properly. Over the next year, as considered efficient, the Organization will implement a daily timesheet record, which requires each program service employee to classify their daily time between federal grant programs. At the end of each week, staff members will submit their timesheet to their supervisor. The supervisor will review each week’s daily timesheet to confirm the staff are recognizing their activities properly. At the end of each month, the Organization’s outsourced accountant, will review these timesheets and determine the proper allocation needed to record each employee’s payroll activities in the accounting software by appropriate federal program. This process will allow for the allocation of actuals to each federal program by the end of the month.
Criteria: The Uniform Guidance, 2 CFR 200.430, requires that payroll charges be based on actual costs incurred and accurately reflects the work performed. Further, documentation must be maintained that supports payroll related costs that are allocated to more than one federal program or to a federal program and nonfederal programs. Condition: We selected thirty-five payroll transactions charged to the program with thirty-five different employees. Of these thirty-five transactions, the Organization did not charge 100% of the employees’ payroll to the program for fourteen employees, indicating that the remaining amount was charged to other federal and nonfederal programs. The Organization did not maintain detailed timesheets or time studies to support the actual time spent on the activities funded by the Coronavirus State and Local Fiscal Recovery Funds program that corresponded to the percentage of time charged to this program for each employee. Our sample of payroll transactions totaled $41,701 charged to the program of the total wages of these employees for these pay periods selected of $59,886. Cause and Effect: The Organization has not implemented procedures that require payroll costs that are allocated to multiple programs be supported by detailed documentation (such as timesheets or recent time studies) supporting the allocation. As a result, costs could be charged to federal programs that do not coincide with actual work performed by the employee. Auditors’ Recommendations: The Organization should establish policies to ensure that payroll costs charged to multiple departments or programs be based on actual time incurred by each employee and that the allocation be supported by time and attendance records.
Criteria: The Uniform Guidance, 2 CFR 200.430, requires that payroll charges be based on actual costs incurred and accurately reflects the work performed. Further, documentation must be maintained that supports payroll related costs that are allocated to more than one federal program or to a federal program and nonfederal programs. Condition: We selected thirty-five payroll transactions charged to the program with thirty-five different employees. Of these thirty-five transactions, the Organization did not charge 100% of the employees’ payroll to the program for fourteen employees, indicating that the remaining amount was charged to other federal and nonfederal programs. The Organization did not maintain detailed timesheets or time studies to support the actual time spent on the activities funded by the Coronavirus State and Local Fiscal Recovery Funds program that corresponded to the percentage of time charged to this program for each employee. Our sample of payroll transactions totaled $41,701 charged to the program of the total wages of these employees for these pay periods selected of $59,886. Cause and Effect: The Organization has not implemented procedures that require payroll costs that are allocated to multiple programs be supported by detailed documentation (such as timesheets or recent time studies) supporting the allocation. As a result, costs could be charged to federal programs that do not coincide with actual work performed by the employee. Auditors’ Recommendations: The Organization should establish policies to ensure that payroll costs charged to multiple departments or programs be based on actual time incurred by each employee and that the allocation be supported by time and attendance records.
2023-005 – Delayed Approval of Compensation Rates (SD) Federal Program Title: Section 8 Housing Choice Vouchers Assistance Listing Number: 14.871 Federal Agency: U.S. Department of Housing and Urban Development Category of Finding: Allowable Costs and Cost Principles Criteria: Per 2 CFR §200.430 of the Uniform Guidance, compensation for personnel services, including any adjustments, must be based on documented and approved procedures in accordance with the organization’s established policies. All changes to compensation must be approved and documented in a timely manner to ensure compliance with both federal and non-federal funding requirements. The City uses personnel action forms (PAF) to document changes to compensation. The PAF must be approved by authorized personnel in advance. Condition: During the review of personnel costs, it was observed that changes in the compensation rates for employees charged to the federally funded project were not approved in a timely manner. Documentation showed delays in the authorization of salary adjustments, with compensation changes becoming effective before formal approval by the City. Cause: The City’s internal control processes for reviewing and approving compensation changes were not followed promptly. There was a lack of procedures ensuring that salary adjustments were approved prior to the effective date. Effect or Potential Effect: Untimely approval of compensation changes increases the risk of inaccurate or unallowable personnel costs being charged to the federal award. This may result in questioned costs, noncompliance with federal regulations, and potential audit findings. Questioned Cost: None. Context: We selected four employees who worked on the program and in all cases, the PAF were authorized much later than the effective date of the compensation change. Statistical Sampling Validity: More than 50% of employees who work on the program were selected. Repeat of a Prior-Year Finding: 2022-005. Recommendation: The City should reinforce internal controls to ensure that all compensation changes are reviewed and approved promptly. This should include: Establishing a timeline for the approval of compensation adjustments. Implementing procedures that prevent compensation changes from being applied until formal approval is obtained. Ensuring proper documentation of all approved salary changes is maintained. Management Response and Corrective Action Plan City's Response: The City concurs with the recommendation and has implemented hiring for temporary work assignments in order to facilitate update. Corrective Action Plan: The HR and payroll software will be updated by the City by December 2025. Planned Implementation Date: December 2025 Responsible Person(s): City Manager
Criteria: Payroll payments are based on the timecard submitted for work performed, and the approved rate of pay the employee is entitled to. Time and effort requirements are outlined in 2 CFR 200.430. Condition: In testing payroll transactions, there were numerous instances of inadequate documentation for payroll. There were missing approved pay rate forms and lack of supporting documentation for stipends and differentials paid. There were timecards submitted for support of the payroll which were unapproved, mathematically incorrect, and/or which did not agree to the payroll paid. Cause: The lack of formal processes and procedures for payroll documentation paired with the limited oversight of payroll processing resulted in insufficient supporting information for payroll payments made. Effect or potential effect: Internal control over the financial activities of the YWCA New Hampshire is weakened. Failure to maintain accurate supporting documentation for payroll increases the risk employees are over- or under- paid for work performed. Questioned costs: The questioned costs are unknown, as the amount of payroll that could have been inappropriately charged is unable to be recalculated at this time. Context: The YWCA New Hampshire expended in excess of $750,000 in federal awards and assistance during the year ending June 30, 2023 requiring a compliance audit in accordance with the Uniform Guidance. The organization has not required a compliance audit in previous years and management was not aware of the various requirements of the Uniform Guidance. The payroll deficiencies were a systemic problem noted during the audit. Recommendation: Policies and procedures surrounding payroll should be reviewed with all relevant personnel. Rate of pay forms should be maintained for each employee, signed and approved, and updated for any rate changes. Formal pay rates should be established for all shift differentials and stipends. Timecards should be appropriately completed each week, approved, and reviewed during the payroll processing. Views of Responsible Officials: YWCA New Hampshire’s management concurs with this audit finding.
Criteria: Payroll payments are based on the timecard submitted for work performed, and the approved rate of pay the employee is entitled to. Time and effort requirements are outlined in 2 CFR 200.430. Condition: In testing payroll transactions, there were numerous instances of inadequate documentation for payroll. There were missing approved pay rate forms and lack of supporting documentation for stipends and differentials paid. There were timecards submitted for support of the payroll which were unapproved, mathematically incorrect, and/or which did not agree to the payroll paid. Cause: The lack of formal processes and procedures for payroll documentation paired with the limited oversight of payroll processing resulted in insufficient supporting information for payroll payments made. Effect or potential effect: Internal control over the financial activities of the YWCA New Hampshire is weakened. Failure to maintain accurate supporting documentation for payroll increases the risk employees are over- or under- paid for work performed. Questioned costs: The questioned costs are unknown, as the amount of payroll that could have been inappropriately charged is unable to be recalculated at this time. Context: The YWCA New Hampshire expended in excess of $750,000 in federal awards and assistance during the year ending June 30, 2023 requiring a compliance audit in accordance with the Uniform Guidance. The organization has not required a compliance audit in previous years and management was not aware of the various requirements of the Uniform Guidance. The payroll deficiencies were a systemic problem noted during the audit. Recommendation: Policies and procedures surrounding payroll should be reviewed with all relevant personnel. Rate of pay forms should be maintained for each employee, signed and approved, and updated for any rate changes. Formal pay rates should be established for all shift differentials and stipends. Timecards should be appropriately completed each week, approved, and reviewed during the payroll processing. Views of Responsible Officials: YWCA New Hampshire’s management concurs with this audit finding.
Criteria: Time and effort requirements state that employee time must be maintained with sufficient documentation to provide for appropriate allocation to the federal program. Time and effort requirements are outlined in 2 CFR 200.430. 32 Condition: Payroll charges for the grant were based on a percentage of time by employee. This percentage was based on management’s decision and set when budgeting; the percentage charged to the grant was not based on actual hours worked. Cause: Payroll was processed by an outside service provider based on information provided by management. Management did not require the breakdown of hours as it relates to the federal programs which were being charged. Management was unaware of this time and effort requirement. Effect or potential effect: The costs submitted for reimbursement under the grant may not be appropriate. The failure to report time appropriately and allocate by program could increase the risk of errors in amounts reported as expended. Questioned costs: The questioned costs are unknown, as the amount of payroll that could have been inappropriately charged to the grant is unable to be recalculated at this time. The true allocation of hours was not recorded. Context: The YWCA New Hampshire expended in excess of $750,000 in federal awards and assistance during the year ending June 30, 2023 requiring a compliance audit in accordance with the Uniform Guidance. The organization has not required a compliance audit in previous years and management was not aware of the various requirements of the Uniform Guidance. The payroll deficiencies were a systemic problem noted during the audit. Recommendation: We recommend that time and effort be maintained in accordance with the Uniform Guidance. We recommend that employees clearly identify hours by grant program for appropriate allocation of the expenses. Views of Responsible Officials: YWCA New Hampshire’s management concurs with this audit finding.
Condition: The auditee submitted reimbursement requests to the Mississippi Department of Education (MDE) that were not fully supported: Standard monthly amounts requested for Digital Learning Instructor (DLI) labor exceeded actual contract costs, resulting in overstatements. 1 of 60 items sampled lacked support for $11,700 in charges. Cause: The Consortium requested funds before receiving invoices or verifying actual expenses. There was no reconciliation process in place to verify that reimbursement requests matched actual expenditures. Effect: Federal funds were received in excess of allowable costs and not returned to the grantor. These excess reimbursements represent questioned costs which the grantor could request funds to be refunded. Criteria: In accordance with 2 CFR §200.403 and §200.430, costs must be necessary, reasonable, and allocable, and adequately documented to be allowable under federal awards. Questioned Costs: Total known questioned costs are $49,082, which includes: $37,382 related to Digital Learning Instructor (DLI) contract labor, including $34,445 in excess labor charges and $2,937 in related indirect costs. These charges were identified through a 100% review of all DLI contract labor activity for fiscal year 2023. $11,700 from a single reimbursement request that partially lacked supporting documentation. This item was identified during testing of a sample of 60 items totaling $6,545,759.87. Based on this sample, we project likely questioned costs of $16,918, using a non-statistical method. Therefore, total questioned costs are estimated at $54,300. Recommendation: Reimbursement requests should only be submitted after expenses are incurred and documented. The Consortium should wait for invoices before requesting funds, or reconcile estimates to actual costs and return excess funds, and maintain full documentation for all requests. Views of Responsible Officials: The Consortium acknowledges the finding and is working to establish a reconciliation process to identify and return any excess funds, and providing staff training on documentation and cost principles.
2023-002 Payroll Costs Federal Program - U.S. Department of the Treasury – Coronavirus State and Local Fiscal Recovery Funds (ALN 21.027) Federal Award Number - SLFRP0136 Compliance Requirement - Allowable Costs/Cost Principles (2 CFR § 200.430) Criteria - Under 2 CFR § 200.430(g), charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed. Compensation for leave must be granted under established leave policies and must be allocable and reasonable for the services rendered. Costs for leave that is not earned or used, or that is forfeited, are generally not allowable under federal awards. Condition - The organization uses a calculated hourly rate to allocate payroll costs to programs. This rate includes a pro rata amount for vacation and sick time earned each pay period. However, the organization’s leave policy does not allow for carryover of unused vacation or sick time. As a result, some of the accrued leave may never be used or paid out but was still charged to federal programs through the calculated rate. Cause - The organization’s methodology for allocating payroll costs does not differentiate between earned and used leave and does not account for the forfeiture of unused time at year-end. Effect - Federal awards may have been charged for leave benefits that were never realized or paid to employees, resulting in an overstatement of payroll costs charged to the program. However, based on our analysis, the financial impact of this condition was not material to the federal award and the estimated questioned costs were below the $25,000 reporting threshold. Questioned Costs - $0. No questioned costs are reported as the estimated impact is below the reporting threshold and not material to the award. Recommendation - We recommend that the organization revise its payroll allocation methodology to ensure only used or vested leave is charged to federal awards. If estimates are used, they should be supported by documentation and periodically reconciled to actual costs. Non-vested leave that may be forfeited should not be included in federally funded rates. Views of Responsible Officials - We agree with the findings and determined it was due to outdated processes and a gap in technical expertise utilizing the payroll allocations within the accounting software.
2023-001 Lack of Documentation to Support Distribution of Wages (Material Weakness) Federal Agency: Department of Education Pass-through Agency: New Hampshire Department of Education Cluster/Program: Education Stabilization Fund Assistance Listing Number: 84.425U Passed-through Identification: #20221232 Compliance Requirement: Activities Allowed or Unallowed and Allowable Costs/Cost Principles Type of Finding: Internal Control over Compliance – Material Weakness Material Noncompliance Criteria or Specific Requirement: Federal regulations 2 CFR 200.303 states, the School District, as a recipient of Federal funds, must establish and maintain effective internal controls over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In addition, under 2 CFR 200.430, it states that charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must (1) be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated, (2) be incorporated into the official records of the non-Federal entity, (3) reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities, and (4) support the distribution of the employee’s salary or wages among specific activities or cost objectives if the employee works on more than one Federal award or a federal award and non-Federal award. Condition: During our review of payroll expenditures charged to the grant, we noted that one employee who worked solely on a single federal program did not have a completed semi-annual certification on file to support the time and effort charged to the grant. As required by 2 CFR 200.430, charges to federal awards for salaries must be supported by documentation that accurately reflects the work performed. For employees working 100% on a single federal program, this requirement is typically met through semi-annual certifications. Cause: Administrative oversight, turnover of internal staffing. Effect: By not obtaining a completed semi-annual certification for an employee working solely on a federal program, the School District did not comply with federal requirements under 2 CFR 200.430. This lack of documentation diminishes the School District’s ability to demonstrate that salary costs charged to the grant were accurate, allowable, and properly supported, potentially placing the $27,615 in questioned costs at risk of disallowance. Questioned Costs: $27,615 Repeat Finding: No Recommendation: We recommend that the School District implement procedures to ensure that semi-annual certifications are completed and retained for all employees whose salaries are charged 100% to a single federal program. These certifications should be signed by the employee or a supervisory official with firsthand knowledge of the work performed and maintained as part of the School District’s official records to support compliance with 2 CFR 200.430. Views of Responsible Officials: Management’s views and corrective action plan is included at the end of this report.
2023-006 – Payroll (Material Weakness in Internal Controls over Compliance/Material Noncompliance) Federal Program Information Federal Award Title and ALN: Research & Development Cluster, 84.031 Federal Awarding Agency: U.S. Department of Education Federal Award ID Number: P031S210287, P031S210288, P031C200002, P031C210215 Federal Award Year: 2023 Condition: The College’s supporting documentation did not match to the amount of employee’s pay charged to grant. Criteria: Per 2 CFR 200.303(a), the non-federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Per 2 CFR section 200.430(i)(1) – Compensation – personal services, Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. Cause: The College does not have sufficient controls in place to ensure the accuracy of the amounts paid to employees nor include appropriate approvals documented to be allowable to be charged to the federal grant. Effect: Lack of approval and inaccurate documentation for costs charged to grants puts the College at risk of charging unallowable costs, which in turn could result in required repayment to grantor agencies. Questioned Costs: Known questioned costs of $6,812 and likely questioned costs of $83,407. Auditor recommendation: We recommend the College develop and implement adequate policies and procedures to ensure charging of expenses for allowability are based off approved amounts.
2023-006 – Payroll (Material Weakness in Internal Controls over Compliance/Material Noncompliance) Federal Program Information Federal Award Title and ALN: Research & Development Cluster, 84.031 Federal Awarding Agency: U.S. Department of Education Federal Award ID Number: P031S210287, P031S210288, P031C200002, P031C210215 Federal Award Year: 2023 Condition: The College’s supporting documentation did not match to the amount of employee’s pay charged to grant. Criteria: Per 2 CFR 200.303(a), the non-federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Per 2 CFR section 200.430(i)(1) – Compensation – personal services, Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. Cause: The College does not have sufficient controls in place to ensure the accuracy of the amounts paid to employees nor include appropriate approvals documented to be allowable to be charged to the federal grant. Effect: Lack of approval and inaccurate documentation for costs charged to grants puts the College at risk of charging unallowable costs, which in turn could result in required repayment to grantor agencies. Questioned Costs: Known questioned costs of $6,812 and likely questioned costs of $83,407. Auditor recommendation: We recommend the College develop and implement adequate policies and procedures to ensure charging of expenses for allowability are based off approved amounts.
2023-006 – Payroll (Material Weakness in Internal Controls over Compliance/Material Noncompliance) Federal Program Information Federal Award Title and ALN: Research & Development Cluster, 84.031 Federal Awarding Agency: U.S. Department of Education Federal Award ID Number: P031S210287, P031S210288, P031C200002, P031C210215 Federal Award Year: 2023 Condition: The College’s supporting documentation did not match to the amount of employee’s pay charged to grant. Criteria: Per 2 CFR 200.303(a), the non-federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Per 2 CFR section 200.430(i)(1) – Compensation – personal services, Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. Cause: The College does not have sufficient controls in place to ensure the accuracy of the amounts paid to employees nor include appropriate approvals documented to be allowable to be charged to the federal grant. Effect: Lack of approval and inaccurate documentation for costs charged to grants puts the College at risk of charging unallowable costs, which in turn could result in required repayment to grantor agencies. Questioned Costs: Known questioned costs of $6,812 and likely questioned costs of $83,407. Auditor recommendation: We recommend the College develop and implement adequate policies and procedures to ensure charging of expenses for allowability are based off approved amounts.
2023-006 – Payroll (Material Weakness in Internal Controls over Compliance/Material Noncompliance) Federal Program Information Federal Award Title and ALN: Research & Development Cluster, 84.031 Federal Awarding Agency: U.S. Department of Education Federal Award ID Number: P031S210287, P031S210288, P031C200002, P031C210215 Federal Award Year: 2023 Condition: The College’s supporting documentation did not match to the amount of employee’s pay charged to grant. Criteria: Per 2 CFR 200.303(a), the non-federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Per 2 CFR section 200.430(i)(1) – Compensation – personal services, Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. Cause: The College does not have sufficient controls in place to ensure the accuracy of the amounts paid to employees nor include appropriate approvals documented to be allowable to be charged to the federal grant. Effect: Lack of approval and inaccurate documentation for costs charged to grants puts the College at risk of charging unallowable costs, which in turn could result in required repayment to grantor agencies. Questioned Costs: Known questioned costs of $6,812 and likely questioned costs of $83,407. Auditor recommendation: We recommend the College develop and implement adequate policies and procedures to ensure charging of expenses for allowability are based off approved amounts.
Finding 2023-001 – ALLOWABLE COSTS/COST PRINCIPLES – PAYROLL DOCUMENTATION Type: Significant Deficiency in Internal Control / Noncompliance Program: Education Stabilization Fund (ALN 84.425) – COVID 19 - all project numbers Condition: The District was unable to provide a semi-annual time certification, or equivalent documentation, for 8 of the 8 payroll transactions tested. Criteria: 2 CFR 200.430(i)(1)(viii) states that entities must, “Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity.” Cause: Management oversight. Effect: As a result of this condition, the District does not have required payroll support for transactions tested which were charged to the grant. Questioned Costs: The total charges included in our sample that were not supported by allowable documentation amounted to $59,925. Recommendation: We recommend that the District review their policies and procedures regarding the documentation requirements of the grant and make the necessary changes, if needed, to assure that semi-annual time certifications (or equivalent documentation) are obtained. Management’s Resp: We are in agreement with this finding.
Finding 2023-001 – ALLOWABLE COSTS/COST PRINCIPLES – PAYROLL DOCUMENTATION Type: Significant Deficiency in Internal Control / Noncompliance Program: Education Stabilization Fund (ALN 84.425) – COVID 19 - all project numbers Condition: The District was unable to provide a semi-annual time certification, or equivalent documentation, for 8 of the 8 payroll transactions tested. Criteria: 2 CFR 200.430(i)(1)(viii) states that entities must, “Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity.” Cause: Management oversight. Effect: As a result of this condition, the District does not have required payroll support for transactions tested which were charged to the grant. Questioned Costs: The total charges included in our sample that were not supported by allowable documentation amounted to $59,925. Recommendation: We recommend that the District review their policies and procedures regarding the documentation requirements of the grant and make the necessary changes, if needed, to assure that semi-annual time certifications (or equivalent documentation) are obtained. Management’s Resp: We are in agreement with this finding.
Finding 2023-001 – ALLOWABLE COSTS/COST PRINCIPLES – PAYROLL DOCUMENTATION Type: Significant Deficiency in Internal Control / Noncompliance Program: Education Stabilization Fund (ALN 84.425) – COVID 19 - all project numbers Condition: The District was unable to provide a semi-annual time certification, or equivalent documentation, for 8 of the 8 payroll transactions tested. Criteria: 2 CFR 200.430(i)(1)(viii) states that entities must, “Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity.” Cause: Management oversight. Effect: As a result of this condition, the District does not have required payroll support for transactions tested which were charged to the grant. Questioned Costs: The total charges included in our sample that were not supported by allowable documentation amounted to $59,925. Recommendation: We recommend that the District review their policies and procedures regarding the documentation requirements of the grant and make the necessary changes, if needed, to assure that semi-annual time certifications (or equivalent documentation) are obtained. Management’s Resp: We are in agreement with this finding.
Finding 2023-001 – ALLOWABLE COSTS/COST PRINCIPLES – PAYROLL DOCUMENTATION Type: Significant Deficiency in Internal Control / Noncompliance Program: Education Stabilization Fund (ALN 84.425) – COVID 19 - all project numbers Condition: The District was unable to provide a semi-annual time certification, or equivalent documentation, for 8 of the 8 payroll transactions tested. Criteria: 2 CFR 200.430(i)(1)(viii) states that entities must, “Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity.” Cause: Management oversight. Effect: As a result of this condition, the District does not have required payroll support for transactions tested which were charged to the grant. Questioned Costs: The total charges included in our sample that were not supported by allowable documentation amounted to $59,925. Recommendation: We recommend that the District review their policies and procedures regarding the documentation requirements of the grant and make the necessary changes, if needed, to assure that semi-annual time certifications (or equivalent documentation) are obtained. Management’s Resp: We are in agreement with this finding.
Finding 2023-001 – ALLOWABLE COSTS/COST PRINCIPLES – PAYROLL DOCUMENTATION Type: Significant Deficiency in Internal Control / Noncompliance Program: Education Stabilization Fund (ALN 84.425) – COVID 19 - all project numbers Condition: The District was unable to provide a semi-annual time certification, or equivalent documentation, for 8 of the 8 payroll transactions tested. Criteria: 2 CFR 200.430(i)(1)(viii) states that entities must, “Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity.” Cause: Management oversight. Effect: As a result of this condition, the District does not have required payroll support for transactions tested which were charged to the grant. Questioned Costs: The total charges included in our sample that were not supported by allowable documentation amounted to $59,925. Recommendation: We recommend that the District review their policies and procedures regarding the documentation requirements of the grant and make the necessary changes, if needed, to assure that semi-annual time certifications (or equivalent documentation) are obtained. Management’s Resp: We are in agreement with this finding.
A. Finding on Internal Control over Compliance Finding Reference: 2023-001 Federal Agency: U.S. Dept of Education Federal program: IDEA - Part B, Section 611 (84.027) IDEA- Part B, Section 619 (84.173) Compliance Requirement: Activities Allowed or Unallowed Type of Finding: a.) Significant Deficiencies in Internal Control Over Compliance b.) Compliance Finding Criteria: According to 2 CFR, Part 200.430(i)(l) of the Office of Management and Budget's Uniform Grant Guidance, charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed, which must, amoung other things: a) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; b) Be incorporated into the official records of the non-Federal entity; c) reasonably reflect the total activity for which the employee is compensated by the non-Federal entity; d) Encompass both federally assisted and all other actvities compensated by the non-Federal entity; e) Support for the distribution of the employee's salary or wages amount specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. Condition: Several of the District employees whose time was being charged to the grants but who were working less than 100% of the time in the federal award program, where required to complete monthly certifications of the percentage of time they worked in each federal award program however, they were not completed timely. Cause: The School District did not have adequate review procedures in place to ensure that the monthly certifications were being completed by each employee working in the federal award programs timely. Effect: Without adequate internal contyrols over the employee's time being charged to the grant and the certification requirement, the School District cannot ensure that the federal funds are paid in accordance with allowable costs and the time worked in the grant. Additionally, they cannot easily monitor the amount of funds that can be charged to the grant for salaries and benefits. Payments that do not agree with the time worked are unallowable and subject to recovery by the grantor. Indentification of a Repeat Finding: This is a repeat finding for IDEA, Section 611 (84.027) and Section 619 (84.173), from the immediate previous audit, 2022-001. Questioned Costs: The employee's certifications in questions were reviewed and after reviewing the allocation of each employee's time it was determined that the time being charged to the gratn was appropriate, therefore, there were no questioned costs. Recommendation: We recommend that the District have propert internal controls in place to ensure that the employees working in the grants are certifying their actual percent of time and effort that is being spent working in the federal award program. Monthly certifications should be completed if thless than 100% of time is being worked in the federal award program or semiannually if 100% of time is being spent. Management Response: The District agrees with the audit finding and will implement adequate checks and balances to ensure that this problem does not recur. Please refer to the corrective action plan.
A. Finding on Internal Control over Compliance Finding Reference: 2023-001 Federal Agency: U.S. Dept of Education Federal program: IDEA - Part B, Section 611 (84.027) IDEA- Part B, Section 619 (84.173) Compliance Requirement: Activities Allowed or Unallowed Type of Finding: a.) Significant Deficiencies in Internal Control Over Compliance b.) Compliance Finding Criteria: According to 2 CFR, Part 200.430(i)(l) of the Office of Management and Budget's Uniform Grant Guidance, charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed, which must, amoung other things: a) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; b) Be incorporated into the official records of the non-Federal entity; c) reasonably reflect the total activity for which the employee is compensated by the non-Federal entity; d) Encompass both federally assisted and all other actvities compensated by the non-Federal entity; e) Support for the distribution of the employee's salary or wages amount specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. Condition: Several of the District employees whose time was being charged to the grants but who were working less than 100% of the time in the federal award program, where required to complete monthly certifications of the percentage of time they worked in each federal award program however, they were not completed timely. Cause: The School District did not have adequate review procedures in place to ensure that the monthly certifications were being completed by each employee working in the federal award programs timely. Effect: Without adequate internal contyrols over the employee's time being charged to the grant and the certification requirement, the School District cannot ensure that the federal funds are paid in accordance with allowable costs and the time worked in the grant. Additionally, they cannot easily monitor the amount of funds that can be charged to the grant for salaries and benefits. Payments that do not agree with the time worked are unallowable and subject to recovery by the grantor. Indentification of a Repeat Finding: This is a repeat finding for IDEA, Section 611 (84.027) and Section 619 (84.173), from the immediate previous audit, 2022-001. Questioned Costs: The employee's certifications in questions were reviewed and after reviewing the allocation of each employee's time it was determined that the time being charged to the gratn was appropriate, therefore, there were no questioned costs. Recommendation: We recommend that the District have propert internal controls in place to ensure that the employees working in the grants are certifying their actual percent of time and effort that is being spent working in the federal award program. Monthly certifications should be completed if thless than 100% of time is being worked in the federal award program or semiannually if 100% of time is being spent. Management Response: The District agrees with the audit finding and will implement adequate checks and balances to ensure that this problem does not recur. Please refer to the corrective action plan.
Finding 2023-001 – Special Education Cluster (IDEA) AL# 84.027, 84.173; Federal Agency – U.S. Department of Education; Pass-through Agency – New York State Department of Education; Grant period – July 1, 2022 – June 30, 2023 Condition: The School District did not have a control in place to ensure that there was adequate documentation, in accordance with 2 CFR section 200.430, of the distribution of an employee’s salary among specific activities when an employee worked on both a Federal award and a non- Federal award. Certification of Federal Award forms were prepared, but they did not indicate the fulltime equivalent (FTE) time to be allocated to the grant and they were not reviewed. Criteria: The Department of Education Cross-Cutting Section of the 2023 Compliance Supplement indicates, “if a school operating a schoolwide program does not consolidate Federal funds with State and local funds in a consolidated schoolwide pool, an employee who works, in whole or in part, on a Federal program or cost objective must document time and effort as follows: (a) For an employee who works solely on a single cost objective (e.g., a single Federal program whose funds have not been consolidated or Federal programs whose funds have been consolidated but not with State and local funds), an LEA is not required to maintain records reflecting the distribution of the employee’s salary and wages, including among the Federal programs included in the consolidation, if applicable. (b) For an employee who works on multiple activities or cost objectives (e.g., in part on a Federal program whose funds have not been consolidated in a consolidated schoolwide pool and in part on Federal programs supported with funds consolidated in a schoolwide pool or on activities that are not part of the same cost objective), an LEA must maintain time and effort distribution records in accordance with 2 CFR section 200.430(i)(1)(vii) that support the portion of time and effort dedicated to: i. The Federal program or cost objective; and ii. Each other program or cost objective supported by consolidated Federal funds or other revenue sources. Cause: There was turnover in the Chief Executive Director of HR & Grants Management position, and as such, there was no position clearly tasked with the responsibility of reviewing the Certification of Federal Award forms during the year. Effect: The School District could have claimed grant reimbursement for an employee when the employee may not have actually worked hours related to, or allowable under, that program. Context: The School District indicated that the Certification of Federal Award forms were not reviewed for any of the employees charged to the grants under the Special Education Cluster. Auditor’s Recommendation: The School District should implement a process in which employee’s time is documented on the Certification of Federal Award forms and the forms are reviewed by an individual with sufficient knowledge about the employee’s duties and the Federal program in order to ensure the costs are allowable and adequately documented. View of Responsible Officials and Planned Corrective Actions: The Assistant Superintendent of Curriculum & Instruction will work with the Business office and the Human Resources department to ensure that the Certification of Federal Awards forms accurately reflect the employee's time charged to the grant. The forms will be reviewed to ensure the costs are allowable and properly documented.
Finding 2023-001 – Special Education Cluster (IDEA) AL# 84.027, 84.173; Federal Agency – U.S. Department of Education; Pass-through Agency – New York State Department of Education; Grant period – July 1, 2022 – June 30, 2023 Condition: The School District did not have a control in place to ensure that there was adequate documentation, in accordance with 2 CFR section 200.430, of the distribution of an employee’s salary among specific activities when an employee worked on both a Federal award and a non- Federal award. Certification of Federal Award forms were prepared, but they did not indicate the fulltime equivalent (FTE) time to be allocated to the grant and they were not reviewed. Criteria: The Department of Education Cross-Cutting Section of the 2023 Compliance Supplement indicates, “if a school operating a schoolwide program does not consolidate Federal funds with State and local funds in a consolidated schoolwide pool, an employee who works, in whole or in part, on a Federal program or cost objective must document time and effort as follows: (a) For an employee who works solely on a single cost objective (e.g., a single Federal program whose funds have not been consolidated or Federal programs whose funds have been consolidated but not with State and local funds), an LEA is not required to maintain records reflecting the distribution of the employee’s salary and wages, including among the Federal programs included in the consolidation, if applicable. (b) For an employee who works on multiple activities or cost objectives (e.g., in part on a Federal program whose funds have not been consolidated in a consolidated schoolwide pool and in part on Federal programs supported with funds consolidated in a schoolwide pool or on activities that are not part of the same cost objective), an LEA must maintain time and effort distribution records in accordance with 2 CFR section 200.430(i)(1)(vii) that support the portion of time and effort dedicated to: i. The Federal program or cost objective; and ii. Each other program or cost objective supported by consolidated Federal funds or other revenue sources. Cause: There was turnover in the Chief Executive Director of HR & Grants Management position, and as such, there was no position clearly tasked with the responsibility of reviewing the Certification of Federal Award forms during the year. Effect: The School District could have claimed grant reimbursement for an employee when the employee may not have actually worked hours related to, or allowable under, that program. Context: The School District indicated that the Certification of Federal Award forms were not reviewed for any of the employees charged to the grants under the Special Education Cluster. Auditor’s Recommendation: The School District should implement a process in which employee’s time is documented on the Certification of Federal Award forms and the forms are reviewed by an individual with sufficient knowledge about the employee’s duties and the Federal program in order to ensure the costs are allowable and adequately documented. View of Responsible Officials and Planned Corrective Actions: The Assistant Superintendent of Curriculum & Instruction will work with the Business office and the Human Resources department to ensure that the Certification of Federal Awards forms accurately reflect the employee's time charged to the grant. The forms will be reviewed to ensure the costs are allowable and properly documented.
Finding 2023-001 – Special Education Cluster (IDEA) AL# 84.027, 84.173; Federal Agency – U.S. Department of Education; Pass-through Agency – New York State Department of Education; Grant period – July 1, 2022 – June 30, 2023 Condition: The School District did not have a control in place to ensure that there was adequate documentation, in accordance with 2 CFR section 200.430, of the distribution of an employee’s salary among specific activities when an employee worked on both a Federal award and a non- Federal award. Certification of Federal Award forms were prepared, but they did not indicate the fulltime equivalent (FTE) time to be allocated to the grant and they were not reviewed. Criteria: The Department of Education Cross-Cutting Section of the 2023 Compliance Supplement indicates, “if a school operating a schoolwide program does not consolidate Federal funds with State and local funds in a consolidated schoolwide pool, an employee who works, in whole or in part, on a Federal program or cost objective must document time and effort as follows: (a) For an employee who works solely on a single cost objective (e.g., a single Federal program whose funds have not been consolidated or Federal programs whose funds have been consolidated but not with State and local funds), an LEA is not required to maintain records reflecting the distribution of the employee’s salary and wages, including among the Federal programs included in the consolidation, if applicable. (b) For an employee who works on multiple activities or cost objectives (e.g., in part on a Federal program whose funds have not been consolidated in a consolidated schoolwide pool and in part on Federal programs supported with funds consolidated in a schoolwide pool or on activities that are not part of the same cost objective), an LEA must maintain time and effort distribution records in accordance with 2 CFR section 200.430(i)(1)(vii) that support the portion of time and effort dedicated to: i. The Federal program or cost objective; and ii. Each other program or cost objective supported by consolidated Federal funds or other revenue sources. Cause: There was turnover in the Chief Executive Director of HR & Grants Management position, and as such, there was no position clearly tasked with the responsibility of reviewing the Certification of Federal Award forms during the year. Effect: The School District could have claimed grant reimbursement for an employee when the employee may not have actually worked hours related to, or allowable under, that program. Context: The School District indicated that the Certification of Federal Award forms were not reviewed for any of the employees charged to the grants under the Special Education Cluster. Auditor’s Recommendation: The School District should implement a process in which employee’s time is documented on the Certification of Federal Award forms and the forms are reviewed by an individual with sufficient knowledge about the employee’s duties and the Federal program in order to ensure the costs are allowable and adequately documented. View of Responsible Officials and Planned Corrective Actions: The Assistant Superintendent of Curriculum & Instruction will work with the Business office and the Human Resources department to ensure that the Certification of Federal Awards forms accurately reflect the employee's time charged to the grant. The forms will be reviewed to ensure the costs are allowable and properly documented.
Finding 2023-001 – Special Education Cluster (IDEA) AL# 84.027, 84.173; Federal Agency – U.S. Department of Education; Pass-through Agency – New York State Department of Education; Grant period – July 1, 2022 – June 30, 2023 Condition: The School District did not have a control in place to ensure that there was adequate documentation, in accordance with 2 CFR section 200.430, of the distribution of an employee’s salary among specific activities when an employee worked on both a Federal award and a non- Federal award. Certification of Federal Award forms were prepared, but they did not indicate the fulltime equivalent (FTE) time to be allocated to the grant and they were not reviewed. Criteria: The Department of Education Cross-Cutting Section of the 2023 Compliance Supplement indicates, “if a school operating a schoolwide program does not consolidate Federal funds with State and local funds in a consolidated schoolwide pool, an employee who works, in whole or in part, on a Federal program or cost objective must document time and effort as follows: (a) For an employee who works solely on a single cost objective (e.g., a single Federal program whose funds have not been consolidated or Federal programs whose funds have been consolidated but not with State and local funds), an LEA is not required to maintain records reflecting the distribution of the employee’s salary and wages, including among the Federal programs included in the consolidation, if applicable. (b) For an employee who works on multiple activities or cost objectives (e.g., in part on a Federal program whose funds have not been consolidated in a consolidated schoolwide pool and in part on Federal programs supported with funds consolidated in a schoolwide pool or on activities that are not part of the same cost objective), an LEA must maintain time and effort distribution records in accordance with 2 CFR section 200.430(i)(1)(vii) that support the portion of time and effort dedicated to: i. The Federal program or cost objective; and ii. Each other program or cost objective supported by consolidated Federal funds or other revenue sources. Cause: There was turnover in the Chief Executive Director of HR & Grants Management position, and as such, there was no position clearly tasked with the responsibility of reviewing the Certification of Federal Award forms during the year. Effect: The School District could have claimed grant reimbursement for an employee when the employee may not have actually worked hours related to, or allowable under, that program. Context: The School District indicated that the Certification of Federal Award forms were not reviewed for any of the employees charged to the grants under the Special Education Cluster. Auditor’s Recommendation: The School District should implement a process in which employee’s time is documented on the Certification of Federal Award forms and the forms are reviewed by an individual with sufficient knowledge about the employee’s duties and the Federal program in order to ensure the costs are allowable and adequately documented. View of Responsible Officials and Planned Corrective Actions: The Assistant Superintendent of Curriculum & Instruction will work with the Business office and the Human Resources department to ensure that the Certification of Federal Awards forms accurately reflect the employee's time charged to the grant. The forms will be reviewed to ensure the costs are allowable and properly documented.
Federal Agency: U.S. Department of Education Federal Program: Education Stabilization Fund ALN(s): 84.425U Pass-through Agency: Michigan Department of Education Grant Number(s): 213713 Project 2122; 213723 Project 2122 Criteria: Title 2 CFR 200.430 states that charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. It is the School District’s procedure to utilize semi-annual certifications or personnel activity reports (PARs) for its records to accurately reflect the work performed. Condition: For interim purposes the School District utilized budgets to allocate employee time between programs. During the audit of the Elementary and Secondary School Emergency Relief (ESSER III) federal grant the School District did not sufficiently document its employees’ actual time spent between federal and/or state programs by completing semi-annual certifications and/or PARs for all employees charged to ESSER III. Cause: The School District has suffered from mass turnover in key positions within the past year including Human Resources, Payroll, and Business Manager positions. The timing of the loss of these key positions and the subsequent delay in finding qualified replacements for these key positions left the School District short-staffed for a good portion of the year while state and federal funding hit unprecedented levels due to the response to the COVID-19 pandemic. With the added funding there was additional reporting which led to even more work having to be spread and managed to an already handicapped staff. Effect: The School District did not follow Board Policy 6116 “Time and Effort Reporting”. Additionally, the accuracy of its interim budgets for ESSER III was not able to be adjusted against after-the fact charges based on comparison with the semi-annual certifications and PARs; accordingly, actual time allocations may vary from budgeted allocations. Perspective: Only employees charged to the Education Stabilization Fund did not have appropriate documentation. All employees selected related to Title I had appropriate documentation to validate employee time to federal and state programs. Recommendation: The School District should follow its policy to appropriately document (through the use of semi-annual certifications or PARs) and adjust budget allocations to actual based on after-the-fact charges to all federal and/or state programs.
Federal Agency: U.S. Department of Education Federal Program: Education Stabilization Fund ALN(s): 84.425U Pass-through Agency: Michigan Department of Education Grant Number(s): 213713 Project 2122; 213723 Project 2122 Criteria: Title 2 CFR 200.430 states that charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. It is the School District’s procedure to utilize semi-annual certifications or personnel activity reports (PARs) for its records to accurately reflect the work performed. Condition: For interim purposes the School District utilized budgets to allocate employee time between programs. During the audit of the Elementary and Secondary School Emergency Relief (ESSER III) federal grant the School District did not sufficiently document its employees’ actual time spent between federal and/or state programs by completing semi-annual certifications and/or PARs for all employees charged to ESSER III. Cause: The School District has suffered from mass turnover in key positions within the past year including Human Resources, Payroll, and Business Manager positions. The timing of the loss of these key positions and the subsequent delay in finding qualified replacements for these key positions left the School District short-staffed for a good portion of the year while state and federal funding hit unprecedented levels due to the response to the COVID-19 pandemic. With the added funding there was additional reporting which led to even more work having to be spread and managed to an already handicapped staff. Effect: The School District did not follow Board Policy 6116 “Time and Effort Reporting”. Additionally, the accuracy of its interim budgets for ESSER III was not able to be adjusted against after-the fact charges based on comparison with the semi-annual certifications and PARs; accordingly, actual time allocations may vary from budgeted allocations. Perspective: Only employees charged to the Education Stabilization Fund did not have appropriate documentation. All employees selected related to Title I had appropriate documentation to validate employee time to federal and state programs. Recommendation: The School District should follow its policy to appropriately document (through the use of semi-annual certifications or PARs) and adjust budget allocations to actual based on after-the-fact charges to all federal and/or state programs.
Federal Agency: U.S. Department of Education Federal Program: Education Stabilization Fund ALN(s): 84.425U Pass-through Agency: Michigan Department of Education Grant Number(s): 213713 Project 2122; 213723 Project 2122 Criteria: Title 2 CFR 200.430 states that charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. It is the School District’s procedure to utilize semi-annual certifications or personnel activity reports (PARs) for its records to accurately reflect the work performed. Condition: For interim purposes the School District utilized budgets to allocate employee time between programs. During the audit of the Elementary and Secondary School Emergency Relief (ESSER III) federal grant the School District did not sufficiently document its employees’ actual time spent between federal and/or state programs by completing semi-annual certifications and/or PARs for all employees charged to ESSER III. Cause: The School District has suffered from mass turnover in key positions within the past year including Human Resources, Payroll, and Business Manager positions. The timing of the loss of these key positions and the subsequent delay in finding qualified replacements for these key positions left the School District short-staffed for a good portion of the year while state and federal funding hit unprecedented levels due to the response to the COVID-19 pandemic. With the added funding there was additional reporting which led to even more work having to be spread and managed to an already handicapped staff. Effect: The School District did not follow Board Policy 6116 “Time and Effort Reporting”. Additionally, the accuracy of its interim budgets for ESSER III was not able to be adjusted against after-the fact charges based on comparison with the semi-annual certifications and PARs; accordingly, actual time allocations may vary from budgeted allocations. Perspective: Only employees charged to the Education Stabilization Fund did not have appropriate documentation. All employees selected related to Title I had appropriate documentation to validate employee time to federal and state programs. Recommendation: The School District should follow its policy to appropriately document (through the use of semi-annual certifications or PARs) and adjust budget allocations to actual based on after-the-fact charges to all federal and/or state programs.
Federal Agency: U.S. Department of Education Federal Program: Education Stabilization Fund ALN(s): 84.425U Pass-through Agency: Michigan Department of Education Grant Number(s): 213713 Project 2122; 213723 Project 2122 Criteria: Title 2 CFR 200.430 states that charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. It is the School District’s procedure to utilize semi-annual certifications or personnel activity reports (PARs) for its records to accurately reflect the work performed. Condition: For interim purposes the School District utilized budgets to allocate employee time between programs. During the audit of the Elementary and Secondary School Emergency Relief (ESSER III) federal grant the School District did not sufficiently document its employees’ actual time spent between federal and/or state programs by completing semi-annual certifications and/or PARs for all employees charged to ESSER III. Cause: The School District has suffered from mass turnover in key positions within the past year including Human Resources, Payroll, and Business Manager positions. The timing of the loss of these key positions and the subsequent delay in finding qualified replacements for these key positions left the School District short-staffed for a good portion of the year while state and federal funding hit unprecedented levels due to the response to the COVID-19 pandemic. With the added funding there was additional reporting which led to even more work having to be spread and managed to an already handicapped staff. Effect: The School District did not follow Board Policy 6116 “Time and Effort Reporting”. Additionally, the accuracy of its interim budgets for ESSER III was not able to be adjusted against after-the fact charges based on comparison with the semi-annual certifications and PARs; accordingly, actual time allocations may vary from budgeted allocations. Perspective: Only employees charged to the Education Stabilization Fund did not have appropriate documentation. All employees selected related to Title I had appropriate documentation to validate employee time to federal and state programs. Recommendation: The School District should follow its policy to appropriately document (through the use of semi-annual certifications or PARs) and adjust budget allocations to actual based on after-the-fact charges to all federal and/or state programs.
Federal Agency: U.S. Department of Education Federal Program: Education Stabilization Fund ALN(s): 84.425U Pass-through Agency: Michigan Department of Education Grant Number(s): 213713 Project 2122; 213723 Project 2122 Criteria: Title 2 CFR 200.430 states that charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. It is the School District’s procedure to utilize semi-annual certifications or personnel activity reports (PARs) for its records to accurately reflect the work performed. Condition: For interim purposes the School District utilized budgets to allocate employee time between programs. During the audit of the Elementary and Secondary School Emergency Relief (ESSER III) federal grant the School District did not sufficiently document its employees’ actual time spent between federal and/or state programs by completing semi-annual certifications and/or PARs for all employees charged to ESSER III. Cause: The School District has suffered from mass turnover in key positions within the past year including Human Resources, Payroll, and Business Manager positions. The timing of the loss of these key positions and the subsequent delay in finding qualified replacements for these key positions left the School District short-staffed for a good portion of the year while state and federal funding hit unprecedented levels due to the response to the COVID-19 pandemic. With the added funding there was additional reporting which led to even more work having to be spread and managed to an already handicapped staff. Effect: The School District did not follow Board Policy 6116 “Time and Effort Reporting”. Additionally, the accuracy of its interim budgets for ESSER III was not able to be adjusted against after-the fact charges based on comparison with the semi-annual certifications and PARs; accordingly, actual time allocations may vary from budgeted allocations. Perspective: Only employees charged to the Education Stabilization Fund did not have appropriate documentation. All employees selected related to Title I had appropriate documentation to validate employee time to federal and state programs. Recommendation: The School District should follow its policy to appropriately document (through the use of semi-annual certifications or PARs) and adjust budget allocations to actual based on after-the-fact charges to all federal and/or state programs.
Criteria: Section 200.430 of 2 CFR Part 200 states standards for documentation for personnel expenses for the support of federal salaries and wages. Condition/Effect: The Institute did not fully comply with the South Carolina Department of Education’s (“SCDE”) requirements for support for federal salaries and wages with regard to budget estimates used for interim accounting purposes. At least quarterly, comparisons of actual costs to budgeted distributions based on the monthly activity reports should be made. Costs charged to federal awards to reflect adjustments made as a result of the activity actually performed may be recorded annually if the quarterly comparisons show the differences between budgeted and actual costs are less than ten percent. The budget estimates should be revised at least quarterly, if necessary, to reflect changed circumstances. Cause: The Institute’s internal controls over salaries and wages charged to federal programs were not operating effectively to ensure that the budget estimates were reviewed quarterly and the costs charged to the federal program were adjusted based on the activity actually performed. Recommendation: The Institute should implement procedures to ensure any budget estimates used for salaries and wages are reviewed quarterly and adjusted to reflect actual cost for the activity performed in accordance with the SCDE requirements. Views of Responsible Officials and Planned Corrective Actions: The Institute agrees with the finding and has proactively taken action to ensure compliance with SCDE requirements. See management's corrective action plan.