Audit 321245

FY End
2023-12-31
Total Expended
$10.08M
Findings
16
Programs
32
Organization: Marquette County (WI)
Year: 2023 Accepted: 2024-09-26

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
498517 2023-002 Significant Deficiency - CL
498518 2023-004 Significant Deficiency - AB
498519 2023-002 Significant Deficiency - CL
498520 2023-004 Significant Deficiency - AB
498521 2023-002 Significant Deficiency - CL
498522 2023-004 Significant Deficiency - AB
498523 2023-002 Significant Deficiency - CL
498524 2023-004 Significant Deficiency - AB
1074959 2023-002 Significant Deficiency - CL
1074960 2023-004 Significant Deficiency - AB
1074961 2023-002 Significant Deficiency - CL
1074962 2023-004 Significant Deficiency - AB
1074963 2023-002 Significant Deficiency - CL
1074964 2023-004 Significant Deficiency - AB
1074965 2023-002 Significant Deficiency - CL
1074966 2023-004 Significant Deficiency - AB

Programs

ALN Program Spent Major Findings
21.027 Coronavirus State and Local Fiscal Recovery Funds $1.21M Yes 0
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $342,363 - 0
93.563 Child Support Enforcement $180,928 - 0
93.658 Foster Care_title IV-E $166,169 - 0
93.778 Medical Assistance Program $122,763 Yes 2
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $102,963 - 0
93.959 Block Grants for Prevention and Treatment of Substance Abuse $80,817 - 0
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $64,900 - 0
93.958 Block Grants for Community Mental Health Services $53,114 - 0
93.045 Special Programs for the Aging_title Iii, Part C_nutrition Services $36,884 - 0
93.069 Public Health Emergency Preparedness $33,685 - 0
93.556 Promoting Safe and Stable Families $33,310 - 0
97.042 Emergency Management Performance Grants $26,059 - 0
93.667 Social Services Block Grant $23,904 - 0
93.994 Maternal and Child Health Services Block Grant to the States $22,074 - 0
84.181 Special Education-Grants for Infants and Families $19,745 - 0
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers $18,381 - 0
93.053 Nutrition Services Incentive Program $14,548 - 0
93.575 Child Care and Development Block Grant $13,708 - 0
93.568 Low-Income Home Energy Assistance $13,163 - 0
97.024 Emergency Food and Shelter National Board Program $12,730 - 0
93.645 Stephanie Tubbs Jones Child Welfare Services Program $9,733 - 0
93.558 Temporary Assistance for Needy Families $7,116 - 0
93.268 Immunization Cooperative Agreements $5,535 - 0
93.991 Preventive Health and Health Services Block Grant $5,087 - 0
93.747 Elder Abuse Prevention Interventions Program $5,077 - 0
93.324 State Health Insurance Assistance Program $3,500 - 0
93.767 Children's Health Insurance Program $2,059 - 0
93.043 Special Programs for the Aging_title Iii, Part D_disease Prevention and Health Promotion Services $1,898 - 0
93.071 Medicare Enrollment Assistance Program $1,766 - 0
93.659 Adoption Assistance $1,112 - 0
93.052 National Family Caregiver Support, Title Iii, Part E $220 - 0

Contacts

Name Title Type
FYZADTY74R93 Ron Barger Auditee
6082973301 Andrea Jansen Auditor
No contacts on file

Notes to SEFA

Title: Basis of Presentation Accounting Policies: Expenditures reported on the Schedule are reported on the accrual or modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts shown on the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. Pass-through entity identifying numbers are presented where available. The underlying accounting records for some grant programs are maintained on the modified accrual basis of accounting. Under the modified accrual basis, revenues are recorded when susceptible to accrual, i.e., both measurable and available. Available means collectible within the current period or soon enough thereafter to be used to pay liabilities of the current period. Expenditures are recorded when the liability is incurred. The accounting records for other grant programs are maintained on the accrual basis, i.e., when the revenue has been earned and the liability is incurred. De Minimis Rate Used: N Rate Explanation: Marquette County has not elected to use the 10% de minimis indirect cost rate. The accompanying schedule of expenditures of federal and state awards (the Schedule) includes the federal and state award activity of Marquette County, Wisconsin under programs of the federal and state government for the year ended December 31, 2023. The information in this Schedule 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)and the State Single Audit Guidelines. Because the Schedule presents only a selected portion of the operations of Marquette County, it is not intended to and does not present the financial position, changes in net position or cash flows of Marquette County.
Title: GEARS>SPARC Report Dates Accounting Policies: Expenditures reported on the Schedule are reported on the accrual or modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts shown on the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. Pass-through entity identifying numbers are presented where available. The underlying accounting records for some grant programs are maintained on the modified accrual basis of accounting. Under the modified accrual basis, revenues are recorded when susceptible to accrual, i.e., both measurable and available. Available means collectible within the current period or soon enough thereafter to be used to pay liabilities of the current period. Expenditures are recorded when the liability is incurred. The accounting records for other grant programs are maintained on the accrual basis, i.e., when the revenue has been earned and the liability is incurred. De Minimis Rate Used: N Rate Explanation: Marquette County has not elected to use the 10% de minimis indirect cost rate. The Schedule of Expenditures of Federal and State Awards includes adjustments through the Grant Enrollment, Application and Reporting System (GEARS) reports dated March 30, 2024 and the SPARC reports for December 2023. Federal/state funding splits for awards passed through Wisconsin Department of Health Services (DHS) are based on the splits provided by DHS on February 14, 2024. Federal/state funding splits for awards passed through Wisconsin Department of Children and Families (DCF) are based on the splits provided by DCF on April 2, 2024.
Title: Pass-Through Agencies Accounting Policies: Expenditures reported on the Schedule are reported on the accrual or modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts shown on the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. Pass-through entity identifying numbers are presented where available. The underlying accounting records for some grant programs are maintained on the modified accrual basis of accounting. Under the modified accrual basis, revenues are recorded when susceptible to accrual, i.e., both measurable and available. Available means collectible within the current period or soon enough thereafter to be used to pay liabilities of the current period. Expenditures are recorded when the liability is incurred. The accounting records for other grant programs are maintained on the accrual basis, i.e., when the revenue has been earned and the liability is incurred. De Minimis Rate Used: N Rate Explanation: Marquette County has not elected to use the 10% de minimis indirect cost rate. The County of Marquette received federal awards from the following pass-through agencies: DHS Wisconsin Department of Health Services DCF Wisconsin Department of Children and Families DMA Wisconsin Department of Military Affairs

Finding Details

Finding 2023-002 Program Federal Assistance Listing and Title: 93.778 Medicaid Cluster State ID Number and Title: 435.283 IMAA State Share Award Number: Unknown Federal Agency: U.S. Department of Health and Human Services Pass-Through Agency: Wisconsin Department of Health Services State Agency: Wisconsin Department of Health Services Criteria: The Uniform Guidance and State Single Audit Guidelines require that local entities receiving federal and state awards establish and maintain internal control designed to reasonably ensure compliance with laws, regulations and program compliance requirements. The Uniform Guidance and State Single Audit Guidelines further require auditors to obtain an understanding of the local entity's internal control over federal and state programs. To minimize the risk of errors, internal controls should be in place for all program compliance requirements, including the preparation and submission of monthly reports, which should be reviewed and approved by a responsible party other than the original preparer. Condition/Context: After the Human Services Manager left the County in June of 2023, the County did not replace the position with another individual to continue performing the control of reviewing GEARS reports prior to submission for reimbursement. Two of the three GEARS reports tested in each program were not reviewed prior to submission as required by the state. The sample was not statistically valid. Cause: The County did not have internal control procedures in place requiring an independent person to review the reports before submission and ensure the reports were accurately and timely submitted. Effect: Reports were not submitted and those that were submitted could contain errors. Questioned Costs: None noted. Recommendation: The County should review its internal control procedures to ensure there are proper review and approval processes over completeness and accuracy of reports are in place before submissions to state agencies are completed. Management Response: Efforts to fill the Human Services Financial Manager position were being actively pursued during the vacancy. The position was re-filled January 29, 2024. Discussion about a backup plan should this position be vacant again are occurring between human services and county administration.
Finding 2023-004 Program Federal Assistance Listing and Title: 93.778 Medicaid Cluster State ID Numbers and Titles: 435.283 IMAA State Share 395.168 Elderly and Handicapped County Aids Award Numbers: Unknown Federal Agency: U.S. Department of Health and Human Services Pass-Through Agency: Wisconsin Department of Health Services State Agencies: Wisconsin Department of Health Services Wisconsin Department of Transportation Criteria: 2 CRF 200.303 Internal Controls requires that non-federal entities receiving federal awards establish and maintain internal control designed to reasonably ensure compliance with federal laws, regulations and program compliance requirements. The State Single Audit Guidelines (SSAG) require that local entities receiving State awards establish and maintain internal control designed to reasonably ensure compliance with laws, regulations and program compliance requirements. To minimize the risk of errors, internal controls should be in place for all program compliance requirements, including appropriate review and approval of expenditures. Condition/Context: During our testing, we were unable to view approval for the following number of expenditures in each program: • 93.778: 4 out of 7 of the expenditures tested. • 395.168: 15 out of 40 of the expenditures tested. • 435.283: 3 out of 6 of the expenditures tested. These samples were not statistically valid. Cause: While review controls are in place, the County's system does not currently allow access to view the documentation of approval of payroll expenses beyond 365 days. Effect: Record retention requirements are not currently being met, which prevents outside reviewers from verifying whether or not effective controls over payroll exist for transactions older than 365 days. Questioned Costs: None noted. Recommendation: The County should work with its software provider and IT personnel to enhance documentation retention surrounding payroll approval support. Management Response: The County is aware that there is a lack of controls over its year-end financial reporting process. The County will endeavor to evaluate the need to increase additional staff to meet the deficiencies noted in the finding. However, because of its size, the County does not feel it is cost-effective to hire the number of employees needed to complete these tasks in-house at this point in time and will rely on an outside audit firm to review financial statements, disclosures and schedules. County administration and financial staff review the adjustments and reports prepared by the auditors to ensure the accuracy of the information.
Finding 2023-002 Program Federal Assistance Listing and Title: 93.778 Medicaid Cluster State ID Number and Title: 435.283 IMAA State Share Award Number: Unknown Federal Agency: U.S. Department of Health and Human Services Pass-Through Agency: Wisconsin Department of Health Services State Agency: Wisconsin Department of Health Services Criteria: The Uniform Guidance and State Single Audit Guidelines require that local entities receiving federal and state awards establish and maintain internal control designed to reasonably ensure compliance with laws, regulations and program compliance requirements. The Uniform Guidance and State Single Audit Guidelines further require auditors to obtain an understanding of the local entity's internal control over federal and state programs. To minimize the risk of errors, internal controls should be in place for all program compliance requirements, including the preparation and submission of monthly reports, which should be reviewed and approved by a responsible party other than the original preparer. Condition/Context: After the Human Services Manager left the County in June of 2023, the County did not replace the position with another individual to continue performing the control of reviewing GEARS reports prior to submission for reimbursement. Two of the three GEARS reports tested in each program were not reviewed prior to submission as required by the state. The sample was not statistically valid. Cause: The County did not have internal control procedures in place requiring an independent person to review the reports before submission and ensure the reports were accurately and timely submitted. Effect: Reports were not submitted and those that were submitted could contain errors. Questioned Costs: None noted. Recommendation: The County should review its internal control procedures to ensure there are proper review and approval processes over completeness and accuracy of reports are in place before submissions to state agencies are completed. Management Response: Efforts to fill the Human Services Financial Manager position were being actively pursued during the vacancy. The position was re-filled January 29, 2024. Discussion about a backup plan should this position be vacant again are occurring between human services and county administration.
Finding 2023-004 Program Federal Assistance Listing and Title: 93.778 Medicaid Cluster State ID Numbers and Titles: 435.283 IMAA State Share 395.168 Elderly and Handicapped County Aids Award Numbers: Unknown Federal Agency: U.S. Department of Health and Human Services Pass-Through Agency: Wisconsin Department of Health Services State Agencies: Wisconsin Department of Health Services Wisconsin Department of Transportation Criteria: 2 CRF 200.303 Internal Controls requires that non-federal entities receiving federal awards establish and maintain internal control designed to reasonably ensure compliance with federal laws, regulations and program compliance requirements. The State Single Audit Guidelines (SSAG) require that local entities receiving State awards establish and maintain internal control designed to reasonably ensure compliance with laws, regulations and program compliance requirements. To minimize the risk of errors, internal controls should be in place for all program compliance requirements, including appropriate review and approval of expenditures. Condition/Context: During our testing, we were unable to view approval for the following number of expenditures in each program: • 93.778: 4 out of 7 of the expenditures tested. • 395.168: 15 out of 40 of the expenditures tested. • 435.283: 3 out of 6 of the expenditures tested. These samples were not statistically valid. Cause: While review controls are in place, the County's system does not currently allow access to view the documentation of approval of payroll expenses beyond 365 days. Effect: Record retention requirements are not currently being met, which prevents outside reviewers from verifying whether or not effective controls over payroll exist for transactions older than 365 days. Questioned Costs: None noted. Recommendation: The County should work with its software provider and IT personnel to enhance documentation retention surrounding payroll approval support. Management Response: The County is aware that there is a lack of controls over its year-end financial reporting process. The County will endeavor to evaluate the need to increase additional staff to meet the deficiencies noted in the finding. However, because of its size, the County does not feel it is cost-effective to hire the number of employees needed to complete these tasks in-house at this point in time and will rely on an outside audit firm to review financial statements, disclosures and schedules. County administration and financial staff review the adjustments and reports prepared by the auditors to ensure the accuracy of the information.
Finding 2023-002 Program Federal Assistance Listing and Title: 93.778 Medicaid Cluster State ID Number and Title: 435.283 IMAA State Share Award Number: Unknown Federal Agency: U.S. Department of Health and Human Services Pass-Through Agency: Wisconsin Department of Health Services State Agency: Wisconsin Department of Health Services Criteria: The Uniform Guidance and State Single Audit Guidelines require that local entities receiving federal and state awards establish and maintain internal control designed to reasonably ensure compliance with laws, regulations and program compliance requirements. The Uniform Guidance and State Single Audit Guidelines further require auditors to obtain an understanding of the local entity's internal control over federal and state programs. To minimize the risk of errors, internal controls should be in place for all program compliance requirements, including the preparation and submission of monthly reports, which should be reviewed and approved by a responsible party other than the original preparer. Condition/Context: After the Human Services Manager left the County in June of 2023, the County did not replace the position with another individual to continue performing the control of reviewing GEARS reports prior to submission for reimbursement. Two of the three GEARS reports tested in each program were not reviewed prior to submission as required by the state. The sample was not statistically valid. Cause: The County did not have internal control procedures in place requiring an independent person to review the reports before submission and ensure the reports were accurately and timely submitted. Effect: Reports were not submitted and those that were submitted could contain errors. Questioned Costs: None noted. Recommendation: The County should review its internal control procedures to ensure there are proper review and approval processes over completeness and accuracy of reports are in place before submissions to state agencies are completed. Management Response: Efforts to fill the Human Services Financial Manager position were being actively pursued during the vacancy. The position was re-filled January 29, 2024. Discussion about a backup plan should this position be vacant again are occurring between human services and county administration.
Finding 2023-004 Program Federal Assistance Listing and Title: 93.778 Medicaid Cluster State ID Numbers and Titles: 435.283 IMAA State Share 395.168 Elderly and Handicapped County Aids Award Numbers: Unknown Federal Agency: U.S. Department of Health and Human Services Pass-Through Agency: Wisconsin Department of Health Services State Agencies: Wisconsin Department of Health Services Wisconsin Department of Transportation Criteria: 2 CRF 200.303 Internal Controls requires that non-federal entities receiving federal awards establish and maintain internal control designed to reasonably ensure compliance with federal laws, regulations and program compliance requirements. The State Single Audit Guidelines (SSAG) require that local entities receiving State awards establish and maintain internal control designed to reasonably ensure compliance with laws, regulations and program compliance requirements. To minimize the risk of errors, internal controls should be in place for all program compliance requirements, including appropriate review and approval of expenditures. Condition/Context: During our testing, we were unable to view approval for the following number of expenditures in each program: • 93.778: 4 out of 7 of the expenditures tested. • 395.168: 15 out of 40 of the expenditures tested. • 435.283: 3 out of 6 of the expenditures tested. These samples were not statistically valid. Cause: While review controls are in place, the County's system does not currently allow access to view the documentation of approval of payroll expenses beyond 365 days. Effect: Record retention requirements are not currently being met, which prevents outside reviewers from verifying whether or not effective controls over payroll exist for transactions older than 365 days. Questioned Costs: None noted. Recommendation: The County should work with its software provider and IT personnel to enhance documentation retention surrounding payroll approval support. Management Response: The County is aware that there is a lack of controls over its year-end financial reporting process. The County will endeavor to evaluate the need to increase additional staff to meet the deficiencies noted in the finding. However, because of its size, the County does not feel it is cost-effective to hire the number of employees needed to complete these tasks in-house at this point in time and will rely on an outside audit firm to review financial statements, disclosures and schedules. County administration and financial staff review the adjustments and reports prepared by the auditors to ensure the accuracy of the information.
Finding 2023-002 Program Federal Assistance Listing and Title: 93.778 Medicaid Cluster State ID Number and Title: 435.283 IMAA State Share Award Number: Unknown Federal Agency: U.S. Department of Health and Human Services Pass-Through Agency: Wisconsin Department of Health Services State Agency: Wisconsin Department of Health Services Criteria: The Uniform Guidance and State Single Audit Guidelines require that local entities receiving federal and state awards establish and maintain internal control designed to reasonably ensure compliance with laws, regulations and program compliance requirements. The Uniform Guidance and State Single Audit Guidelines further require auditors to obtain an understanding of the local entity's internal control over federal and state programs. To minimize the risk of errors, internal controls should be in place for all program compliance requirements, including the preparation and submission of monthly reports, which should be reviewed and approved by a responsible party other than the original preparer. Condition/Context: After the Human Services Manager left the County in June of 2023, the County did not replace the position with another individual to continue performing the control of reviewing GEARS reports prior to submission for reimbursement. Two of the three GEARS reports tested in each program were not reviewed prior to submission as required by the state. The sample was not statistically valid. Cause: The County did not have internal control procedures in place requiring an independent person to review the reports before submission and ensure the reports were accurately and timely submitted. Effect: Reports were not submitted and those that were submitted could contain errors. Questioned Costs: None noted. Recommendation: The County should review its internal control procedures to ensure there are proper review and approval processes over completeness and accuracy of reports are in place before submissions to state agencies are completed. Management Response: Efforts to fill the Human Services Financial Manager position were being actively pursued during the vacancy. The position was re-filled January 29, 2024. Discussion about a backup plan should this position be vacant again are occurring between human services and county administration.
Finding 2023-004 Program Federal Assistance Listing and Title: 93.778 Medicaid Cluster State ID Numbers and Titles: 435.283 IMAA State Share 395.168 Elderly and Handicapped County Aids Award Numbers: Unknown Federal Agency: U.S. Department of Health and Human Services Pass-Through Agency: Wisconsin Department of Health Services State Agencies: Wisconsin Department of Health Services Wisconsin Department of Transportation Criteria: 2 CRF 200.303 Internal Controls requires that non-federal entities receiving federal awards establish and maintain internal control designed to reasonably ensure compliance with federal laws, regulations and program compliance requirements. The State Single Audit Guidelines (SSAG) require that local entities receiving State awards establish and maintain internal control designed to reasonably ensure compliance with laws, regulations and program compliance requirements. To minimize the risk of errors, internal controls should be in place for all program compliance requirements, including appropriate review and approval of expenditures. Condition/Context: During our testing, we were unable to view approval for the following number of expenditures in each program: • 93.778: 4 out of 7 of the expenditures tested. • 395.168: 15 out of 40 of the expenditures tested. • 435.283: 3 out of 6 of the expenditures tested. These samples were not statistically valid. Cause: While review controls are in place, the County's system does not currently allow access to view the documentation of approval of payroll expenses beyond 365 days. Effect: Record retention requirements are not currently being met, which prevents outside reviewers from verifying whether or not effective controls over payroll exist for transactions older than 365 days. Questioned Costs: None noted. Recommendation: The County should work with its software provider and IT personnel to enhance documentation retention surrounding payroll approval support. Management Response: The County is aware that there is a lack of controls over its year-end financial reporting process. The County will endeavor to evaluate the need to increase additional staff to meet the deficiencies noted in the finding. However, because of its size, the County does not feel it is cost-effective to hire the number of employees needed to complete these tasks in-house at this point in time and will rely on an outside audit firm to review financial statements, disclosures and schedules. County administration and financial staff review the adjustments and reports prepared by the auditors to ensure the accuracy of the information.
Finding 2023-002 Program Federal Assistance Listing and Title: 93.778 Medicaid Cluster State ID Number and Title: 435.283 IMAA State Share Award Number: Unknown Federal Agency: U.S. Department of Health and Human Services Pass-Through Agency: Wisconsin Department of Health Services State Agency: Wisconsin Department of Health Services Criteria: The Uniform Guidance and State Single Audit Guidelines require that local entities receiving federal and state awards establish and maintain internal control designed to reasonably ensure compliance with laws, regulations and program compliance requirements. The Uniform Guidance and State Single Audit Guidelines further require auditors to obtain an understanding of the local entity's internal control over federal and state programs. To minimize the risk of errors, internal controls should be in place for all program compliance requirements, including the preparation and submission of monthly reports, which should be reviewed and approved by a responsible party other than the original preparer. Condition/Context: After the Human Services Manager left the County in June of 2023, the County did not replace the position with another individual to continue performing the control of reviewing GEARS reports prior to submission for reimbursement. Two of the three GEARS reports tested in each program were not reviewed prior to submission as required by the state. The sample was not statistically valid. Cause: The County did not have internal control procedures in place requiring an independent person to review the reports before submission and ensure the reports were accurately and timely submitted. Effect: Reports were not submitted and those that were submitted could contain errors. Questioned Costs: None noted. Recommendation: The County should review its internal control procedures to ensure there are proper review and approval processes over completeness and accuracy of reports are in place before submissions to state agencies are completed. Management Response: Efforts to fill the Human Services Financial Manager position were being actively pursued during the vacancy. The position was re-filled January 29, 2024. Discussion about a backup plan should this position be vacant again are occurring between human services and county administration.
Finding 2023-004 Program Federal Assistance Listing and Title: 93.778 Medicaid Cluster State ID Numbers and Titles: 435.283 IMAA State Share 395.168 Elderly and Handicapped County Aids Award Numbers: Unknown Federal Agency: U.S. Department of Health and Human Services Pass-Through Agency: Wisconsin Department of Health Services State Agencies: Wisconsin Department of Health Services Wisconsin Department of Transportation Criteria: 2 CRF 200.303 Internal Controls requires that non-federal entities receiving federal awards establish and maintain internal control designed to reasonably ensure compliance with federal laws, regulations and program compliance requirements. The State Single Audit Guidelines (SSAG) require that local entities receiving State awards establish and maintain internal control designed to reasonably ensure compliance with laws, regulations and program compliance requirements. To minimize the risk of errors, internal controls should be in place for all program compliance requirements, including appropriate review and approval of expenditures. Condition/Context: During our testing, we were unable to view approval for the following number of expenditures in each program: • 93.778: 4 out of 7 of the expenditures tested. • 395.168: 15 out of 40 of the expenditures tested. • 435.283: 3 out of 6 of the expenditures tested. These samples were not statistically valid. Cause: While review controls are in place, the County's system does not currently allow access to view the documentation of approval of payroll expenses beyond 365 days. Effect: Record retention requirements are not currently being met, which prevents outside reviewers from verifying whether or not effective controls over payroll exist for transactions older than 365 days. Questioned Costs: None noted. Recommendation: The County should work with its software provider and IT personnel to enhance documentation retention surrounding payroll approval support. Management Response: The County is aware that there is a lack of controls over its year-end financial reporting process. The County will endeavor to evaluate the need to increase additional staff to meet the deficiencies noted in the finding. However, because of its size, the County does not feel it is cost-effective to hire the number of employees needed to complete these tasks in-house at this point in time and will rely on an outside audit firm to review financial statements, disclosures and schedules. County administration and financial staff review the adjustments and reports prepared by the auditors to ensure the accuracy of the information.
Finding 2023-002 Program Federal Assistance Listing and Title: 93.778 Medicaid Cluster State ID Number and Title: 435.283 IMAA State Share Award Number: Unknown Federal Agency: U.S. Department of Health and Human Services Pass-Through Agency: Wisconsin Department of Health Services State Agency: Wisconsin Department of Health Services Criteria: The Uniform Guidance and State Single Audit Guidelines require that local entities receiving federal and state awards establish and maintain internal control designed to reasonably ensure compliance with laws, regulations and program compliance requirements. The Uniform Guidance and State Single Audit Guidelines further require auditors to obtain an understanding of the local entity's internal control over federal and state programs. To minimize the risk of errors, internal controls should be in place for all program compliance requirements, including the preparation and submission of monthly reports, which should be reviewed and approved by a responsible party other than the original preparer. Condition/Context: After the Human Services Manager left the County in June of 2023, the County did not replace the position with another individual to continue performing the control of reviewing GEARS reports prior to submission for reimbursement. Two of the three GEARS reports tested in each program were not reviewed prior to submission as required by the state. The sample was not statistically valid. Cause: The County did not have internal control procedures in place requiring an independent person to review the reports before submission and ensure the reports were accurately and timely submitted. Effect: Reports were not submitted and those that were submitted could contain errors. Questioned Costs: None noted. Recommendation: The County should review its internal control procedures to ensure there are proper review and approval processes over completeness and accuracy of reports are in place before submissions to state agencies are completed. Management Response: Efforts to fill the Human Services Financial Manager position were being actively pursued during the vacancy. The position was re-filled January 29, 2024. Discussion about a backup plan should this position be vacant again are occurring between human services and county administration.
Finding 2023-004 Program Federal Assistance Listing and Title: 93.778 Medicaid Cluster State ID Numbers and Titles: 435.283 IMAA State Share 395.168 Elderly and Handicapped County Aids Award Numbers: Unknown Federal Agency: U.S. Department of Health and Human Services Pass-Through Agency: Wisconsin Department of Health Services State Agencies: Wisconsin Department of Health Services Wisconsin Department of Transportation Criteria: 2 CRF 200.303 Internal Controls requires that non-federal entities receiving federal awards establish and maintain internal control designed to reasonably ensure compliance with federal laws, regulations and program compliance requirements. The State Single Audit Guidelines (SSAG) require that local entities receiving State awards establish and maintain internal control designed to reasonably ensure compliance with laws, regulations and program compliance requirements. To minimize the risk of errors, internal controls should be in place for all program compliance requirements, including appropriate review and approval of expenditures. Condition/Context: During our testing, we were unable to view approval for the following number of expenditures in each program: • 93.778: 4 out of 7 of the expenditures tested. • 395.168: 15 out of 40 of the expenditures tested. • 435.283: 3 out of 6 of the expenditures tested. These samples were not statistically valid. Cause: While review controls are in place, the County's system does not currently allow access to view the documentation of approval of payroll expenses beyond 365 days. Effect: Record retention requirements are not currently being met, which prevents outside reviewers from verifying whether or not effective controls over payroll exist for transactions older than 365 days. Questioned Costs: None noted. Recommendation: The County should work with its software provider and IT personnel to enhance documentation retention surrounding payroll approval support. Management Response: The County is aware that there is a lack of controls over its year-end financial reporting process. The County will endeavor to evaluate the need to increase additional staff to meet the deficiencies noted in the finding. However, because of its size, the County does not feel it is cost-effective to hire the number of employees needed to complete these tasks in-house at this point in time and will rely on an outside audit firm to review financial statements, disclosures and schedules. County administration and financial staff review the adjustments and reports prepared by the auditors to ensure the accuracy of the information.
Finding 2023-002 Program Federal Assistance Listing and Title: 93.778 Medicaid Cluster State ID Number and Title: 435.283 IMAA State Share Award Number: Unknown Federal Agency: U.S. Department of Health and Human Services Pass-Through Agency: Wisconsin Department of Health Services State Agency: Wisconsin Department of Health Services Criteria: The Uniform Guidance and State Single Audit Guidelines require that local entities receiving federal and state awards establish and maintain internal control designed to reasonably ensure compliance with laws, regulations and program compliance requirements. The Uniform Guidance and State Single Audit Guidelines further require auditors to obtain an understanding of the local entity's internal control over federal and state programs. To minimize the risk of errors, internal controls should be in place for all program compliance requirements, including the preparation and submission of monthly reports, which should be reviewed and approved by a responsible party other than the original preparer. Condition/Context: After the Human Services Manager left the County in June of 2023, the County did not replace the position with another individual to continue performing the control of reviewing GEARS reports prior to submission for reimbursement. Two of the three GEARS reports tested in each program were not reviewed prior to submission as required by the state. The sample was not statistically valid. Cause: The County did not have internal control procedures in place requiring an independent person to review the reports before submission and ensure the reports were accurately and timely submitted. Effect: Reports were not submitted and those that were submitted could contain errors. Questioned Costs: None noted. Recommendation: The County should review its internal control procedures to ensure there are proper review and approval processes over completeness and accuracy of reports are in place before submissions to state agencies are completed. Management Response: Efforts to fill the Human Services Financial Manager position were being actively pursued during the vacancy. The position was re-filled January 29, 2024. Discussion about a backup plan should this position be vacant again are occurring between human services and county administration.
Finding 2023-004 Program Federal Assistance Listing and Title: 93.778 Medicaid Cluster State ID Numbers and Titles: 435.283 IMAA State Share 395.168 Elderly and Handicapped County Aids Award Numbers: Unknown Federal Agency: U.S. Department of Health and Human Services Pass-Through Agency: Wisconsin Department of Health Services State Agencies: Wisconsin Department of Health Services Wisconsin Department of Transportation Criteria: 2 CRF 200.303 Internal Controls requires that non-federal entities receiving federal awards establish and maintain internal control designed to reasonably ensure compliance with federal laws, regulations and program compliance requirements. The State Single Audit Guidelines (SSAG) require that local entities receiving State awards establish and maintain internal control designed to reasonably ensure compliance with laws, regulations and program compliance requirements. To minimize the risk of errors, internal controls should be in place for all program compliance requirements, including appropriate review and approval of expenditures. Condition/Context: During our testing, we were unable to view approval for the following number of expenditures in each program: • 93.778: 4 out of 7 of the expenditures tested. • 395.168: 15 out of 40 of the expenditures tested. • 435.283: 3 out of 6 of the expenditures tested. These samples were not statistically valid. Cause: While review controls are in place, the County's system does not currently allow access to view the documentation of approval of payroll expenses beyond 365 days. Effect: Record retention requirements are not currently being met, which prevents outside reviewers from verifying whether or not effective controls over payroll exist for transactions older than 365 days. Questioned Costs: None noted. Recommendation: The County should work with its software provider and IT personnel to enhance documentation retention surrounding payroll approval support. Management Response: The County is aware that there is a lack of controls over its year-end financial reporting process. The County will endeavor to evaluate the need to increase additional staff to meet the deficiencies noted in the finding. However, because of its size, the County does not feel it is cost-effective to hire the number of employees needed to complete these tasks in-house at this point in time and will rely on an outside audit firm to review financial statements, disclosures and schedules. County administration and financial staff review the adjustments and reports prepared by the auditors to ensure the accuracy of the information.
Finding 2023-002 Program Federal Assistance Listing and Title: 93.778 Medicaid Cluster State ID Number and Title: 435.283 IMAA State Share Award Number: Unknown Federal Agency: U.S. Department of Health and Human Services Pass-Through Agency: Wisconsin Department of Health Services State Agency: Wisconsin Department of Health Services Criteria: The Uniform Guidance and State Single Audit Guidelines require that local entities receiving federal and state awards establish and maintain internal control designed to reasonably ensure compliance with laws, regulations and program compliance requirements. The Uniform Guidance and State Single Audit Guidelines further require auditors to obtain an understanding of the local entity's internal control over federal and state programs. To minimize the risk of errors, internal controls should be in place for all program compliance requirements, including the preparation and submission of monthly reports, which should be reviewed and approved by a responsible party other than the original preparer. Condition/Context: After the Human Services Manager left the County in June of 2023, the County did not replace the position with another individual to continue performing the control of reviewing GEARS reports prior to submission for reimbursement. Two of the three GEARS reports tested in each program were not reviewed prior to submission as required by the state. The sample was not statistically valid. Cause: The County did not have internal control procedures in place requiring an independent person to review the reports before submission and ensure the reports were accurately and timely submitted. Effect: Reports were not submitted and those that were submitted could contain errors. Questioned Costs: None noted. Recommendation: The County should review its internal control procedures to ensure there are proper review and approval processes over completeness and accuracy of reports are in place before submissions to state agencies are completed. Management Response: Efforts to fill the Human Services Financial Manager position were being actively pursued during the vacancy. The position was re-filled January 29, 2024. Discussion about a backup plan should this position be vacant again are occurring between human services and county administration.
Finding 2023-004 Program Federal Assistance Listing and Title: 93.778 Medicaid Cluster State ID Numbers and Titles: 435.283 IMAA State Share 395.168 Elderly and Handicapped County Aids Award Numbers: Unknown Federal Agency: U.S. Department of Health and Human Services Pass-Through Agency: Wisconsin Department of Health Services State Agencies: Wisconsin Department of Health Services Wisconsin Department of Transportation Criteria: 2 CRF 200.303 Internal Controls requires that non-federal entities receiving federal awards establish and maintain internal control designed to reasonably ensure compliance with federal laws, regulations and program compliance requirements. The State Single Audit Guidelines (SSAG) require that local entities receiving State awards establish and maintain internal control designed to reasonably ensure compliance with laws, regulations and program compliance requirements. To minimize the risk of errors, internal controls should be in place for all program compliance requirements, including appropriate review and approval of expenditures. Condition/Context: During our testing, we were unable to view approval for the following number of expenditures in each program: • 93.778: 4 out of 7 of the expenditures tested. • 395.168: 15 out of 40 of the expenditures tested. • 435.283: 3 out of 6 of the expenditures tested. These samples were not statistically valid. Cause: While review controls are in place, the County's system does not currently allow access to view the documentation of approval of payroll expenses beyond 365 days. Effect: Record retention requirements are not currently being met, which prevents outside reviewers from verifying whether or not effective controls over payroll exist for transactions older than 365 days. Questioned Costs: None noted. Recommendation: The County should work with its software provider and IT personnel to enhance documentation retention surrounding payroll approval support. Management Response: The County is aware that there is a lack of controls over its year-end financial reporting process. The County will endeavor to evaluate the need to increase additional staff to meet the deficiencies noted in the finding. However, because of its size, the County does not feel it is cost-effective to hire the number of employees needed to complete these tasks in-house at this point in time and will rely on an outside audit firm to review financial statements, disclosures and schedules. County administration and financial staff review the adjustments and reports prepared by the auditors to ensure the accuracy of the information.