Audit 4224

FY End
2023-06-30
Total Expended
$19.34M
Findings
8
Programs
20
Organization: Newberry County School District (SC)
Year: 2023 Accepted: 2023-11-27

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
2451 2023-002 Significant Deficiency - AB
2452 2023-002 Significant Deficiency - AB
2453 2023-002 Significant Deficiency - AB
2454 2023-002 Significant Deficiency - AB
578893 2023-002 Significant Deficiency - AB
578894 2023-002 Significant Deficiency - AB
578895 2023-002 Significant Deficiency - AB
578896 2023-002 Significant Deficiency - AB

Contacts

Name Title Type
SN13WKYYQWN8 Susan Dowd Auditee
8033212600 David Phillips Auditor
No contacts on file

Notes to SEFA

Accounting Policies: GENERAL: The accompanying Schedule of Expenditures of Federal Awards (the “Schedule”) presents the activity of all federal award programs of The School District of Newberry County, South Carolina (the “School District”) for the year ended June 30, 2023. All federal awards received directly from the federal agencies, as well as those passed through other government agencies, are included on the Schedule. BASIS OF ACCOUNTING: The accompanying Schedule is presented using the modified accrual basis of accounting, which is described in the notes to the School District’s financial statements. RELATIONSHIP TO FINANCIAL STATEMENTS: Federal award expenditures are reported in the School District’s financial statements primarily as expenditures in the Special Revenue Funds and as prepaids in certain cases. RELATIONSHIP TO FEDERAL FINANCIAL REPORTS: Amounts reported in the accompanying schedule agree with the amounts reported in the related federal financial reports except for timing differences relating to expenditures made subsequent to the filing of the federal financial reports. De Minimis Rate Used: N Rate Explanation: The School District has elected not to use the 10-percent de minimis indirect cost rate allowed under the Uniform Guidance.

Finding Details

CONDITION: It was noted that for some of the employees who worked overtime in the ESSER program, that their overtime pay was not calculated correctly (formula error in the spreadsheet). This resulted in the wages being underpaid by less than $1,000 and also resulted in less amounts being charged to the ESSER program versus what was allowed. CRITERIA, CONTEXT AND EFFECT: The School District uses an excel spreadsheet to calculate overtime for ESSER pay. When the ESSER item was added to the excel spreadsheet, the formulas were not calculating properly. CAUSE: The School District thought the spreadsheet was calculating the overtime portion of these ESSER employees correctly. RECOMMENDATION: We would encourage the District to correct this spreadsheet and ensure the correct amount is being calculated going forward as well as periodically reviewing a sample for accuracy. RESPONSE: The School District agrees with this finding and will adhere to the corrective action plan on page 165 in this report.
CONDITION: It was noted that for some of the employees who worked overtime in the ESSER program, that their overtime pay was not calculated correctly (formula error in the spreadsheet). This resulted in the wages being underpaid by less than $1,000 and also resulted in less amounts being charged to the ESSER program versus what was allowed. CRITERIA, CONTEXT AND EFFECT: The School District uses an excel spreadsheet to calculate overtime for ESSER pay. When the ESSER item was added to the excel spreadsheet, the formulas were not calculating properly. CAUSE: The School District thought the spreadsheet was calculating the overtime portion of these ESSER employees correctly. RECOMMENDATION: We would encourage the District to correct this spreadsheet and ensure the correct amount is being calculated going forward as well as periodically reviewing a sample for accuracy. RESPONSE: The School District agrees with this finding and will adhere to the corrective action plan on page 165 in this report.
CONDITION: It was noted that for some of the employees who worked overtime in the ESSER program, that their overtime pay was not calculated correctly (formula error in the spreadsheet). This resulted in the wages being underpaid by less than $1,000 and also resulted in less amounts being charged to the ESSER program versus what was allowed. CRITERIA, CONTEXT AND EFFECT: The School District uses an excel spreadsheet to calculate overtime for ESSER pay. When the ESSER item was added to the excel spreadsheet, the formulas were not calculating properly. CAUSE: The School District thought the spreadsheet was calculating the overtime portion of these ESSER employees correctly. RECOMMENDATION: We would encourage the District to correct this spreadsheet and ensure the correct amount is being calculated going forward as well as periodically reviewing a sample for accuracy. RESPONSE: The School District agrees with this finding and will adhere to the corrective action plan on page 165 in this report.
CONDITION: It was noted that for some of the employees who worked overtime in the ESSER program, that their overtime pay was not calculated correctly (formula error in the spreadsheet). This resulted in the wages being underpaid by less than $1,000 and also resulted in less amounts being charged to the ESSER program versus what was allowed. CRITERIA, CONTEXT AND EFFECT: The School District uses an excel spreadsheet to calculate overtime for ESSER pay. When the ESSER item was added to the excel spreadsheet, the formulas were not calculating properly. CAUSE: The School District thought the spreadsheet was calculating the overtime portion of these ESSER employees correctly. RECOMMENDATION: We would encourage the District to correct this spreadsheet and ensure the correct amount is being calculated going forward as well as periodically reviewing a sample for accuracy. RESPONSE: The School District agrees with this finding and will adhere to the corrective action plan on page 165 in this report.
CONDITION: It was noted that for some of the employees who worked overtime in the ESSER program, that their overtime pay was not calculated correctly (formula error in the spreadsheet). This resulted in the wages being underpaid by less than $1,000 and also resulted in less amounts being charged to the ESSER program versus what was allowed. CRITERIA, CONTEXT AND EFFECT: The School District uses an excel spreadsheet to calculate overtime for ESSER pay. When the ESSER item was added to the excel spreadsheet, the formulas were not calculating properly. CAUSE: The School District thought the spreadsheet was calculating the overtime portion of these ESSER employees correctly. RECOMMENDATION: We would encourage the District to correct this spreadsheet and ensure the correct amount is being calculated going forward as well as periodically reviewing a sample for accuracy. RESPONSE: The School District agrees with this finding and will adhere to the corrective action plan on page 165 in this report.
CONDITION: It was noted that for some of the employees who worked overtime in the ESSER program, that their overtime pay was not calculated correctly (formula error in the spreadsheet). This resulted in the wages being underpaid by less than $1,000 and also resulted in less amounts being charged to the ESSER program versus what was allowed. CRITERIA, CONTEXT AND EFFECT: The School District uses an excel spreadsheet to calculate overtime for ESSER pay. When the ESSER item was added to the excel spreadsheet, the formulas were not calculating properly. CAUSE: The School District thought the spreadsheet was calculating the overtime portion of these ESSER employees correctly. RECOMMENDATION: We would encourage the District to correct this spreadsheet and ensure the correct amount is being calculated going forward as well as periodically reviewing a sample for accuracy. RESPONSE: The School District agrees with this finding and will adhere to the corrective action plan on page 165 in this report.
CONDITION: It was noted that for some of the employees who worked overtime in the ESSER program, that their overtime pay was not calculated correctly (formula error in the spreadsheet). This resulted in the wages being underpaid by less than $1,000 and also resulted in less amounts being charged to the ESSER program versus what was allowed. CRITERIA, CONTEXT AND EFFECT: The School District uses an excel spreadsheet to calculate overtime for ESSER pay. When the ESSER item was added to the excel spreadsheet, the formulas were not calculating properly. CAUSE: The School District thought the spreadsheet was calculating the overtime portion of these ESSER employees correctly. RECOMMENDATION: We would encourage the District to correct this spreadsheet and ensure the correct amount is being calculated going forward as well as periodically reviewing a sample for accuracy. RESPONSE: The School District agrees with this finding and will adhere to the corrective action plan on page 165 in this report.
CONDITION: It was noted that for some of the employees who worked overtime in the ESSER program, that their overtime pay was not calculated correctly (formula error in the spreadsheet). This resulted in the wages being underpaid by less than $1,000 and also resulted in less amounts being charged to the ESSER program versus what was allowed. CRITERIA, CONTEXT AND EFFECT: The School District uses an excel spreadsheet to calculate overtime for ESSER pay. When the ESSER item was added to the excel spreadsheet, the formulas were not calculating properly. CAUSE: The School District thought the spreadsheet was calculating the overtime portion of these ESSER employees correctly. RECOMMENDATION: We would encourage the District to correct this spreadsheet and ensure the correct amount is being calculated going forward as well as periodically reviewing a sample for accuracy. RESPONSE: The School District agrees with this finding and will adhere to the corrective action plan on page 165 in this report.