Audit 292802

FY End
2023-06-30
Total Expended
$5.07M
Findings
10
Programs
10
Year: 2023 Accepted: 2024-02-29
Auditor: Eide Bailly LLP

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
371167 2023-003 Significant Deficiency Yes AB
371168 2023-004 Material Weakness Yes AB
371169 2023-005 Significant Deficiency - AB
371170 2023-005 Significant Deficiency - AB
371171 2023-006 Significant Deficiency - G
947609 2023-003 Significant Deficiency Yes AB
947610 2023-004 Material Weakness Yes AB
947611 2023-005 Significant Deficiency - AB
947612 2023-005 Significant Deficiency - AB
947613 2023-006 Significant Deficiency - G

Contacts

Name Title Type
GAUSJJEEXJZ9 Dan Ries Auditee
7122622922 Joy Feige Auditor
No contacts on file

Notes to SEFA

Title: Basis of Presentation Accounting Policies: Expenditures reported in the schedule are reported on the accrual basis of accounting. When applicable, such expenditures are recognized following the cost principles contained in Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. No federal financial assistance has been provided to a subrecipient. De Minimis Rate Used: N Rate Explanation: The Center has not elected to use the 10% de minimis cost rate. The accompanying schedule of expenditures of federal awards (the schedule) includes the federal award activity of Northwest Iowa Mental Health Center d/b/a Seasons Center For Behavioral Health (the Center) under programs of the federal government for the year ended June 30, 2023. The information is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Because the schedule presents only a selected portion of the operations of the Center, it is not intended to and does not present the financial position, changes in net assets, or cash flows of the Center.
Title: Provider Relief Fund and American Rescue Plan (ARP) Rural Distribution Program Accounting Policies: Expenditures reported in the schedule are reported on the accrual basis of accounting. When applicable, such expenditures are recognized following the cost principles contained in Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. No federal financial assistance has been provided to a subrecipient. De Minimis Rate Used: N Rate Explanation: The Center has not elected to use the 10% de minimis cost rate. The Center received amounts from the U.S. Department of Health and Human Services (HHS) through the Provider Relief Fund and American Rescue Plan (ARP) Rural Distribution (PRF) program (Federal Financial Assistance Listing #93.498) in the amount of $178,971. The PRF expenditures are not recognized on the schedule until the expenditures are included in the reporting to HHS as required under the PRF Program. In accordance with the 2023 Compliance Supplement, the PRF expenditures recognized on the schedule are based on the reporting to HHS for Period 4, defined as payments received during July 1, 2021 to December 31, 2021 of $178,971 and Period 5, defined as payments received during January 1, 2022 to June 30, 2022 as required under the PRF program. The Center did not receive funding during Period 5.

Finding Details

Department of Health and Human Services FFLA #93.087, 90CU0090, 9/30/2020 – 9/29/2023; 90CU0095, 9/30/2018 – 9/29/2024 Enhance Safety of Children Affected by Substance Abuse Activities Allowed and Allowable Costs Significant Deficiency in Internal Control over Compliance Criteria: The Center is required to have procedures in place to ensure that federal awards are expended only for allowable costs in accordance with Subpart E – Cost Principles of the Uniform Guidance. Allowable costs are supported by appropriate documentation and correctly charged as to account, amount, and period. 2 CFR 200.303(a) establishes that the auditee must establish and maintain effective internal control over the federal award that provides assurance that the entity is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. 2 CFR 200.430(i) establishes the standards for documentation of personnel expenses including charges to Federal awards for salaries and wages. Charges must be based on records that accurately reflect the work performed with the records meeting the following standards: 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 office records of the non-Federal entity. c) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities. d) Encompass both 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. e) Comply with the established accounting policies and practices of the non-Federal entity. f) Support the distribution of the employee’s salary or wages among specific activities or cost objectives. g) Budget estimates alone do not qualify as support for charges to Federal awards, but may be used for interim accounting purposes. Condition: In our sample of expenditures selected for testing, we noted the following items: a) ClickTime timecard, which tracks federal and nonfederal hours for employees, did not properly reflect the employees total federal and nonfederal hours being paid within the payroll register (3 instances). b) Calculation errors for expenses allocated to the grant (1 instance). Cause: Employees did not enter all nonfederal hours within the ClickTime system and the secondary review of the employee ClickTime timecards did not identify the missing hours. In addition, the secondary review of federal grant expenditure tracking spreadsheet did not identify the calculation errors. Effect: The Center’s controls did not detect or correct the errors identified, which results in a reasonable possibility that the Center could submit disallowed costs under the federal awards and would not be able to detect and correct noncompliance in a timely manner. Questioned Costs: None reported. The program was underallocated. Context: A total non-statistical sample of 60 nonpayroll and payroll transactions were tested which accounted for $119,973 out of $1,006,904 of federal payroll and nonpayroll direct program expenditures. Repeat Finding from Prior Year: Yes, prior year finding 2022-003 Recommendation: We recommend management review the procedures and control processes involving timecards and the federal grant expenditure tracking spreadsheet to ensure compliance with the federal grant. Views of Responsible Officials: Management is in agreement.
Department of Health and Human Services FFLA #93.829, H79SM083331, 5/1/2021 – 12/31/2023 Section 223 Demonstration Programs to Improve Community Mental Health Services Activities Allowed and Allowable Costs Material Weakness in Internal Control over Compliance Criteria: The Center is required to have procedures in place to ensure that federal awards are expended only for allowable costs in accordance with Subpart E – Cost Principles of the Uniform Guidance. Allowable costs are supported by appropriate documentation and correctly charged as to account, amount, and period. 2 CFR 200.303(a) establishes that the auditee must establish and maintain effective internal control over the federal award that provides assurance that the entity is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. 2 CFR 200.430(i) establishes the standards for documentation of personnel expenses including charges to Federal awards for salaries and wages. Charges must be based on records that accurately reflect the work performed with the records meeting the following standards: 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 office records of the non-Federal entity. c) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities. d) Encompass both 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. e) Comply with the established accounting policies and practices of the non-Federal entity. f) Support the distribution of the employee’s salary or wages among specific activities or cost objectives. g) Budget estimates alone do not qualify as support for charges to Federal awards, but may be used for interim accounting purposes. Condition: In our sample of expenditures selected for testing, we noted the following items: a) ClickTime timecard, which tracks federal and nonfederal hours for employees, did not properly reflect the employees total federal and nonfederal hours being paid within the payroll register (2 instances). b) Calculation errors for expenses allocated to the grant (2 instances). c) Employee’s overtime hours were not properly tracked in ClickTime (2 instances). d) Employee tracked paid time off under PTO and CCBHC lines in ClickTime (1 instance) causing it to be double tracked. e) Grant was overcharged as it relates to a client’s gym membership (1 instance). Cause: Employees did not enter all nonfederal hours within the ClickTime system and the secondary review of the employee ClickTime timecards did not identify the missing hours, the incorrectly tracked hours, and double tracked time. Also, the secondary review of federal grant expenditure tracking spreadsheet did not identify the calculation errors. In addition, the grant was overcharged for nonpayroll as it relates to a gym membership claimed for a customer of the grant. Effect: The Center’s controls did not detect or correct the errors identified, which results in a reasonable possibility that the Center could submit disallowed costs under the federal awards and would not be able to detect and correct noncompliance in a timely manner. Questioned Costs: The program was overcharged by $127. Context: A total non-statistical sample of 60 payroll and nonpayroll transactions were tested which accounted for $170,945 out of $702,139 of federal payroll and nonpayroll direct program expenditures. Repeat Finding from Prior Year: Yes, prior year finding 2022-005 Recommendation: We recommend management review the procedures and control processes involving timecards and the federal grant expenditure tracking spreadsheet to ensure compliance with the federal grant. Views of Responsible Officials: Management is in agreement.
Department of Health and Human Services FFLA #93.958, 6H79SM085542, 9/30/2021 – 9/29/2023 Block Grants for Community Mental Health Services Activities Allowed and Allowable Costs Significant Deficiency in Internal Control over Compliance Criteria: The Center is required to have procedures in place to ensure that federal awards are expended only for allowable costs in accordance with Subpart E – Cost Principles of the Uniform Guidance. Allowable costs are supported by appropriate documentation and correctly charged as to account, amount, and period. 2 CFR 200.303(a) establishes that the auditee must establish and maintain effective internal control over the federal award that provides assurance that the entity is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. 2 CFR 200.430(i) establishes the standards for documentation of personnel expenses including charges to Federal awards for salaries and wages. Charges must be based on records that accurately reflect the work performed with the records meeting the following standards: 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 office records of the non-Federal entity. c) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities. d) Encompass both 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. e) Comply with the established accounting policies and practices of the non-Federal entity. f) Support the distribution of the employee’s salary or wages among specific activities or cost objectives. g) Budget estimates alone do not qualify as support for charges to Federal awards, but may be used for interim accounting purposes. Condition: In our sample of expenditures selected for testing, we noted the following items: a) ClickTime timecard, which tracks federal and nonfederal hours for employees, did not properly reflect the employees total federal and nonfederal hours being paid within the payroll register (2 instances). b) The tracking spreadsheet did not reflect the entire months payroll and instead only included 2 weeks of payroll and benefits which resulted in a calculation error for expenses allocated to the grant (1 instance). Cause: Employees did not enter all nonfederal hours within the ClickTime system and the secondary review of the employee ClickTime timecards did not identify the missing hours. In addition, the secondary review of federal grant expenditure tracking spreadsheet did not identify the missing pay periods. Effect: The Center’s controls did not detect or correct the errors identified, which results in a reasonable possibility that the Center could submit disallowed costs under the federal awards and would not be able to detect and correct noncompliance in a timely manner. Questioned Costs: None reported. The program was underallocated. Context: A total non-statistical sample of 60 nonpayroll and payroll transactions were tested which accounted for $99,320 out of $844,289 of federal payroll and nonpayroll direct program expenditures. Repeat Finding from Prior Year: No. Recommendation: We recommend management review the procedures and control processes involving timecards and the federal grant expenditure tracking spreadsheet to ensure compliance with the federal grant. Views of Responsible Officials: Management is in agreement.
Department of Health and Human Services FFLA #93.958, 6H79SM085542, 9/30/2021 – 9/29/2023 Block Grants for Community Mental Health Services Activities Allowed and Allowable Costs Significant Deficiency in Internal Control over Compliance Criteria: The Center is required to have procedures in place to ensure that federal awards are expended only for allowable costs in accordance with Subpart E – Cost Principles of the Uniform Guidance. Allowable costs are supported by appropriate documentation and correctly charged as to account, amount, and period. 2 CFR 200.303(a) establishes that the auditee must establish and maintain effective internal control over the federal award that provides assurance that the entity is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. 2 CFR 200.430(i) establishes the standards for documentation of personnel expenses including charges to Federal awards for salaries and wages. Charges must be based on records that accurately reflect the work performed with the records meeting the following standards: 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 office records of the non-Federal entity. c) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities. d) Encompass both 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. e) Comply with the established accounting policies and practices of the non-Federal entity. f) Support the distribution of the employee’s salary or wages among specific activities or cost objectives. g) Budget estimates alone do not qualify as support for charges to Federal awards, but may be used for interim accounting purposes. Condition: In our sample of expenditures selected for testing, we noted the following items: a) ClickTime timecard, which tracks federal and nonfederal hours for employees, did not properly reflect the employees total federal and nonfederal hours being paid within the payroll register (2 instances). b) The tracking spreadsheet did not reflect the entire months payroll and instead only included 2 weeks of payroll and benefits which resulted in a calculation error for expenses allocated to the grant (1 instance). Cause: Employees did not enter all nonfederal hours within the ClickTime system and the secondary review of the employee ClickTime timecards did not identify the missing hours. In addition, the secondary review of federal grant expenditure tracking spreadsheet did not identify the missing pay periods. Effect: The Center’s controls did not detect or correct the errors identified, which results in a reasonable possibility that the Center could submit disallowed costs under the federal awards and would not be able to detect and correct noncompliance in a timely manner. Questioned Costs: None reported. The program was underallocated. Context: A total non-statistical sample of 60 nonpayroll and payroll transactions were tested which accounted for $99,320 out of $844,289 of federal payroll and nonpayroll direct program expenditures. Repeat Finding from Prior Year: No. Recommendation: We recommend management review the procedures and control processes involving timecards and the federal grant expenditure tracking spreadsheet to ensure compliance with the federal grant. Views of Responsible Officials: Management is in agreement.
Department of Health and Human Services FFLA #93.087, 90CU0090, 9/30/2020 – 9/29/2023; 90CU0095, 9/30/2018 – 9/29/2024 Enhance Safety of Children Affected by Substance Abuse Matching Significant Deficiency in Internal Control over Compliance Criteria: 2 CFR 200.303(a) establishes that the auditee must establish and maintain effective internal control over the federal award that provides assurance that the entity is managing the federal award in compliance with federal statutes, regulations, and conditions of the federal award. In addition, 2 CFR 200.306 establishes that matching funds be verifiable from the non-federal entity’s records and are allowable under Subpart E – Cost Principles and 2 CFR 200.403(g) establishes that costs be adequately documented. Condition: In our sample of expenditures selected for testing, we noted the following items: a) The number of hours an employee worked per the approved timesheet vs. the hours claimed in the match claim workbook resulted in a clerical error. (1 instance) b) Per review of the supporting timesheet and paystub, an employee had mobile crisis pay which was not accurately reduced in the calculation for match in the match claim workbook (2 instances). Cause: The secondary review of match claim workbook did not identify the clerical errors. Effect: The Center’s controls did not detect or correct the errors identified, which results in a reasonable possibility that the Center could submit disallowed costs under the federal awards and would not be able to detect and correct noncompliance in a timely manner. Questioned Costs: None reported. The program was underallocated. Context: A total non-statistical sample of 25 match transactions were tested which accounted for $97,208 out of $488,366 of federal match direct program expenditures. Repeat Finding from Prior Year: No. Recommendation: We recommend management review the procedures and control processes involving the match claim workbook to ensure compliance with the federal grant. Views of Responsible Officials: Management is in agreement.
Department of Health and Human Services FFLA #93.087, 90CU0090, 9/30/2020 – 9/29/2023; 90CU0095, 9/30/2018 – 9/29/2024 Enhance Safety of Children Affected by Substance Abuse Activities Allowed and Allowable Costs Significant Deficiency in Internal Control over Compliance Criteria: The Center is required to have procedures in place to ensure that federal awards are expended only for allowable costs in accordance with Subpart E – Cost Principles of the Uniform Guidance. Allowable costs are supported by appropriate documentation and correctly charged as to account, amount, and period. 2 CFR 200.303(a) establishes that the auditee must establish and maintain effective internal control over the federal award that provides assurance that the entity is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. 2 CFR 200.430(i) establishes the standards for documentation of personnel expenses including charges to Federal awards for salaries and wages. Charges must be based on records that accurately reflect the work performed with the records meeting the following standards: 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 office records of the non-Federal entity. c) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities. d) Encompass both 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. e) Comply with the established accounting policies and practices of the non-Federal entity. f) Support the distribution of the employee’s salary or wages among specific activities or cost objectives. g) Budget estimates alone do not qualify as support for charges to Federal awards, but may be used for interim accounting purposes. Condition: In our sample of expenditures selected for testing, we noted the following items: a) ClickTime timecard, which tracks federal and nonfederal hours for employees, did not properly reflect the employees total federal and nonfederal hours being paid within the payroll register (3 instances). b) Calculation errors for expenses allocated to the grant (1 instance). Cause: Employees did not enter all nonfederal hours within the ClickTime system and the secondary review of the employee ClickTime timecards did not identify the missing hours. In addition, the secondary review of federal grant expenditure tracking spreadsheet did not identify the calculation errors. Effect: The Center’s controls did not detect or correct the errors identified, which results in a reasonable possibility that the Center could submit disallowed costs under the federal awards and would not be able to detect and correct noncompliance in a timely manner. Questioned Costs: None reported. The program was underallocated. Context: A total non-statistical sample of 60 nonpayroll and payroll transactions were tested which accounted for $119,973 out of $1,006,904 of federal payroll and nonpayroll direct program expenditures. Repeat Finding from Prior Year: Yes, prior year finding 2022-003 Recommendation: We recommend management review the procedures and control processes involving timecards and the federal grant expenditure tracking spreadsheet to ensure compliance with the federal grant. Views of Responsible Officials: Management is in agreement.
Department of Health and Human Services FFLA #93.829, H79SM083331, 5/1/2021 – 12/31/2023 Section 223 Demonstration Programs to Improve Community Mental Health Services Activities Allowed and Allowable Costs Material Weakness in Internal Control over Compliance Criteria: The Center is required to have procedures in place to ensure that federal awards are expended only for allowable costs in accordance with Subpart E – Cost Principles of the Uniform Guidance. Allowable costs are supported by appropriate documentation and correctly charged as to account, amount, and period. 2 CFR 200.303(a) establishes that the auditee must establish and maintain effective internal control over the federal award that provides assurance that the entity is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. 2 CFR 200.430(i) establishes the standards for documentation of personnel expenses including charges to Federal awards for salaries and wages. Charges must be based on records that accurately reflect the work performed with the records meeting the following standards: 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 office records of the non-Federal entity. c) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities. d) Encompass both 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. e) Comply with the established accounting policies and practices of the non-Federal entity. f) Support the distribution of the employee’s salary or wages among specific activities or cost objectives. g) Budget estimates alone do not qualify as support for charges to Federal awards, but may be used for interim accounting purposes. Condition: In our sample of expenditures selected for testing, we noted the following items: a) ClickTime timecard, which tracks federal and nonfederal hours for employees, did not properly reflect the employees total federal and nonfederal hours being paid within the payroll register (2 instances). b) Calculation errors for expenses allocated to the grant (2 instances). c) Employee’s overtime hours were not properly tracked in ClickTime (2 instances). d) Employee tracked paid time off under PTO and CCBHC lines in ClickTime (1 instance) causing it to be double tracked. e) Grant was overcharged as it relates to a client’s gym membership (1 instance). Cause: Employees did not enter all nonfederal hours within the ClickTime system and the secondary review of the employee ClickTime timecards did not identify the missing hours, the incorrectly tracked hours, and double tracked time. Also, the secondary review of federal grant expenditure tracking spreadsheet did not identify the calculation errors. In addition, the grant was overcharged for nonpayroll as it relates to a gym membership claimed for a customer of the grant. Effect: The Center’s controls did not detect or correct the errors identified, which results in a reasonable possibility that the Center could submit disallowed costs under the federal awards and would not be able to detect and correct noncompliance in a timely manner. Questioned Costs: The program was overcharged by $127. Context: A total non-statistical sample of 60 payroll and nonpayroll transactions were tested which accounted for $170,945 out of $702,139 of federal payroll and nonpayroll direct program expenditures. Repeat Finding from Prior Year: Yes, prior year finding 2022-005 Recommendation: We recommend management review the procedures and control processes involving timecards and the federal grant expenditure tracking spreadsheet to ensure compliance with the federal grant. Views of Responsible Officials: Management is in agreement.
Department of Health and Human Services FFLA #93.958, 6H79SM085542, 9/30/2021 – 9/29/2023 Block Grants for Community Mental Health Services Activities Allowed and Allowable Costs Significant Deficiency in Internal Control over Compliance Criteria: The Center is required to have procedures in place to ensure that federal awards are expended only for allowable costs in accordance with Subpart E – Cost Principles of the Uniform Guidance. Allowable costs are supported by appropriate documentation and correctly charged as to account, amount, and period. 2 CFR 200.303(a) establishes that the auditee must establish and maintain effective internal control over the federal award that provides assurance that the entity is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. 2 CFR 200.430(i) establishes the standards for documentation of personnel expenses including charges to Federal awards for salaries and wages. Charges must be based on records that accurately reflect the work performed with the records meeting the following standards: 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 office records of the non-Federal entity. c) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities. d) Encompass both 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. e) Comply with the established accounting policies and practices of the non-Federal entity. f) Support the distribution of the employee’s salary or wages among specific activities or cost objectives. g) Budget estimates alone do not qualify as support for charges to Federal awards, but may be used for interim accounting purposes. Condition: In our sample of expenditures selected for testing, we noted the following items: a) ClickTime timecard, which tracks federal and nonfederal hours for employees, did not properly reflect the employees total federal and nonfederal hours being paid within the payroll register (2 instances). b) The tracking spreadsheet did not reflect the entire months payroll and instead only included 2 weeks of payroll and benefits which resulted in a calculation error for expenses allocated to the grant (1 instance). Cause: Employees did not enter all nonfederal hours within the ClickTime system and the secondary review of the employee ClickTime timecards did not identify the missing hours. In addition, the secondary review of federal grant expenditure tracking spreadsheet did not identify the missing pay periods. Effect: The Center’s controls did not detect or correct the errors identified, which results in a reasonable possibility that the Center could submit disallowed costs under the federal awards and would not be able to detect and correct noncompliance in a timely manner. Questioned Costs: None reported. The program was underallocated. Context: A total non-statistical sample of 60 nonpayroll and payroll transactions were tested which accounted for $99,320 out of $844,289 of federal payroll and nonpayroll direct program expenditures. Repeat Finding from Prior Year: No. Recommendation: We recommend management review the procedures and control processes involving timecards and the federal grant expenditure tracking spreadsheet to ensure compliance with the federal grant. Views of Responsible Officials: Management is in agreement.
Department of Health and Human Services FFLA #93.958, 6H79SM085542, 9/30/2021 – 9/29/2023 Block Grants for Community Mental Health Services Activities Allowed and Allowable Costs Significant Deficiency in Internal Control over Compliance Criteria: The Center is required to have procedures in place to ensure that federal awards are expended only for allowable costs in accordance with Subpart E – Cost Principles of the Uniform Guidance. Allowable costs are supported by appropriate documentation and correctly charged as to account, amount, and period. 2 CFR 200.303(a) establishes that the auditee must establish and maintain effective internal control over the federal award that provides assurance that the entity is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. 2 CFR 200.430(i) establishes the standards for documentation of personnel expenses including charges to Federal awards for salaries and wages. Charges must be based on records that accurately reflect the work performed with the records meeting the following standards: 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 office records of the non-Federal entity. c) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities. d) Encompass both 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. e) Comply with the established accounting policies and practices of the non-Federal entity. f) Support the distribution of the employee’s salary or wages among specific activities or cost objectives. g) Budget estimates alone do not qualify as support for charges to Federal awards, but may be used for interim accounting purposes. Condition: In our sample of expenditures selected for testing, we noted the following items: a) ClickTime timecard, which tracks federal and nonfederal hours for employees, did not properly reflect the employees total federal and nonfederal hours being paid within the payroll register (2 instances). b) The tracking spreadsheet did not reflect the entire months payroll and instead only included 2 weeks of payroll and benefits which resulted in a calculation error for expenses allocated to the grant (1 instance). Cause: Employees did not enter all nonfederal hours within the ClickTime system and the secondary review of the employee ClickTime timecards did not identify the missing hours. In addition, the secondary review of federal grant expenditure tracking spreadsheet did not identify the missing pay periods. Effect: The Center’s controls did not detect or correct the errors identified, which results in a reasonable possibility that the Center could submit disallowed costs under the federal awards and would not be able to detect and correct noncompliance in a timely manner. Questioned Costs: None reported. The program was underallocated. Context: A total non-statistical sample of 60 nonpayroll and payroll transactions were tested which accounted for $99,320 out of $844,289 of federal payroll and nonpayroll direct program expenditures. Repeat Finding from Prior Year: No. Recommendation: We recommend management review the procedures and control processes involving timecards and the federal grant expenditure tracking spreadsheet to ensure compliance with the federal grant. Views of Responsible Officials: Management is in agreement.
Department of Health and Human Services FFLA #93.087, 90CU0090, 9/30/2020 – 9/29/2023; 90CU0095, 9/30/2018 – 9/29/2024 Enhance Safety of Children Affected by Substance Abuse Matching Significant Deficiency in Internal Control over Compliance Criteria: 2 CFR 200.303(a) establishes that the auditee must establish and maintain effective internal control over the federal award that provides assurance that the entity is managing the federal award in compliance with federal statutes, regulations, and conditions of the federal award. In addition, 2 CFR 200.306 establishes that matching funds be verifiable from the non-federal entity’s records and are allowable under Subpart E – Cost Principles and 2 CFR 200.403(g) establishes that costs be adequately documented. Condition: In our sample of expenditures selected for testing, we noted the following items: a) The number of hours an employee worked per the approved timesheet vs. the hours claimed in the match claim workbook resulted in a clerical error. (1 instance) b) Per review of the supporting timesheet and paystub, an employee had mobile crisis pay which was not accurately reduced in the calculation for match in the match claim workbook (2 instances). Cause: The secondary review of match claim workbook did not identify the clerical errors. Effect: The Center’s controls did not detect or correct the errors identified, which results in a reasonable possibility that the Center could submit disallowed costs under the federal awards and would not be able to detect and correct noncompliance in a timely manner. Questioned Costs: None reported. The program was underallocated. Context: A total non-statistical sample of 25 match transactions were tested which accounted for $97,208 out of $488,366 of federal match direct program expenditures. Repeat Finding from Prior Year: No. Recommendation: We recommend management review the procedures and control processes involving the match claim workbook to ensure compliance with the federal grant. Views of Responsible Officials: Management is in agreement.