Audit 18549

FY End
2022-12-31
Total Expended
$18.29M
Findings
24
Programs
38
Organization: Beltrami County (MN)
Year: 2022 Accepted: 2023-09-26

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
21999 2022-006 Significant Deficiency - E
22000 2022-004 Significant Deficiency Yes E
22001 2022-005 Significant Deficiency - AB
22018 2022-003 Significant Deficiency - I
22019 2022-005 Significant Deficiency - AB
22020 2022-006 Significant Deficiency - E
22021 2022-005 Significant Deficiency - AB
22022 2022-006 Significant Deficiency - E
22023 2022-006 Significant Deficiency - E
22024 2022-004 Significant Deficiency Yes E
22025 2022-005 Significant Deficiency - AB
22026 2022-006 Significant Deficiency - E
598441 2022-006 Significant Deficiency - E
598442 2022-004 Significant Deficiency Yes E
598443 2022-005 Significant Deficiency - AB
598460 2022-003 Significant Deficiency - I
598461 2022-005 Significant Deficiency - AB
598462 2022-006 Significant Deficiency - E
598463 2022-005 Significant Deficiency - AB
598464 2022-006 Significant Deficiency - E
598465 2022-006 Significant Deficiency - E
598466 2022-004 Significant Deficiency Yes E
598467 2022-005 Significant Deficiency - AB
598468 2022-006 Significant Deficiency - E

Programs

ALN Program Spent Major Findings
21.027 Coronavirus State and Local Fiscal Recovery Funds $8.67M Yes 1
93.778 Medical Assistance Program $2.27M Yes 3
20.205 Highway Planning and Construction $2.21M Yes 0
93.658 Foster Care_title IV-E $1.22M Yes 1
93.563 Child Support Enforcement $821,096 - 0
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $820,298 Yes 3
93.558 Temporary Assistance for Needy Families $581,306 Yes 2
93.667 Social Services Block Grant $332,536 - 0
10.557 Special Supplemental Nutrition Program for Women, Infants, and Children $305,035 - 0
21.032 Covid-19 Local Assistance and Tribal Consistency Fund $198,957 - 0
16.738 Edward Byrne Memorial Justice Assistance Grant Program $195,555 - 0
15.226 Payments in Lieu of Taxes $119,438 - 0
16.575 Crime Victim Assistance $69,190 - 0
97.042 Emergency Management Performance Grants $52,473 - 0
93.994 Maternal and Child Health Services Block Grant to the States $50,540 - 0
93.268 Immunization Cooperative Agreements $44,726 - 0
20.608 Minimum Penalties for Repeat Offenders for Driving While Intoxicated $42,651 - 0
90.404 2018 Hava Election Security Grants $34,268 - 0
16.609 Project Safe Neighborhoods $28,986 - 0
93.069 Public Health Emergency Preparedness $27,268 - 0
93.556 Promoting Safe and Stable Families $17,812 - 0
93.575 Child Care and Development Block Grant $11,566 - 0
93.674 John H. Chafee Foster Care Program for Successful Transition to Adulthood $10,962 - 0
97.012 Boating Safety Financial Assistance $10,459 - 0
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $9,476 - 0
93.669 Child Abuse and Neglect State Grants $9,133 - 0
20.600 State and Community Highway Safety $8,878 - 0
10.665 Schools and Roads - Grants to States $7,795 - 0
16.607 Bulletproof Vest Partnership Program $7,071 - 0
93.645 Stephanie Tubbs Jones Child Welfare Services Program $7,048 - 0
93.767 Children's Health Insurance Program $4,075 - 0
16.710 Public Safety Partnership and Community Policing Grants $3,786 - 0
84.181 Special Education-Grants for Infants and Families $2,100 - 0
93.566 Refugee and Entrant Assistance_state Administered Programs $1,324 - 0
93.251 Early Hearing Detection and Intervention $1,125 - 0
20.609 Safety Belt Performance Grants $983 - 0
20.616 National Priority Safety Programs $492 - 0
93.314 Early Hearing Detection and Intervention Information System (ehdi-Is) Surveillance Program $225 - 0

Contacts

Name Title Type
UKEKLT33SPHB Jodee Treat Auditee
2183334175 Douglas P. Host Auditor
No contacts on file

Notes to SEFA

Accounting Policies: 1. The Schedule of Expenditures of Federal Awards presents the activity of federal award programs expended by Beltrami County (the County). The County's reporting entity is defined in Note 1 to the financial statements. 2. The accompanying Schedule of Expenditures of Federal Awards includes the federal grant activity of Beltrami County under programs of the federal government for the year ended December 31, 2022. 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 for Federal Awards (Uniform Guidance) from the Office of Management and Budget (OMB). Because the schedule presents only a selected portion of the operations of Beltrami County, it is not intended to and does not present the financial position, changes in the net position, or cash flows of Beltrami County. 3. Expenditures reported on the schedule are reported on the modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards for all awards. Under these principles certain types of expenditures are not allowed or are limited as to reimbursement. The County has elected not to use the 10% de minimus indirect cost rate allowed under Uniform Guidance. 4. Reconciliation to the Schedule of Intergovernmental Revenue Federal Grant Revenue per Schedule of Intergovernmental Revenue $18,262,614 Expenditures in the Schedule of Expenditures of Federal Awards, not included as revenue reported in the Schedule of Intergovernmental Revenue 58,500 Revenues included on the Schedule of Intergovernmental Revenue that are not considered Federal Grant Expenditures (31,275) Expenditures per Schedule of Expenditures of Federal Awards $18,289,839 De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate.

Finding Details

CASE FILE REVIEWS (2022?006) Federal Agency: U.S. Department of Human Services and U.S. Department of Agriculture Federal Program Name: Medical Assistance (Medicaid Cluster), Temporary Assistance for Needy families (TANF), Title IV-E Foster Care and State Administrative Matching Grants for Supplemental Nutrition Assistance Program (SNAP Cluster) Assistance Listing Number: 93.778, 93.558, 93.658 and 10.561 Pass-Through Agency: Minnesota Department of Human Services and Minnesota Department of Agriculture Federal Award Identification and Pass-Through Numbers: 2205MN5ADM, 2201MNTANF, 2201MNFOS and 222MN101S2520 Award Period: Year Ended December 31, 2022 Compliance Requirement: Eligibility Type of Finding: Significant Deficiency in Internal Control over Compliance Criteria or Specific Requirement: Federal guidelines require grant recipients to implement internal controls for each direct and material compliance requirement applicable to the federal grant to ensure compliance with said requirements. Condition and Context: During testing of controls over Eligibility (i.e., casefile reviews), it was noted that less than 10 documented reviews were completed for each program. This is less than 0.1% of the casefiles and is insufficient sample sizes for the number of clients the county handles. The sample sizes were based on guidance from chapter 11 of the AICPA Audit Guide, Government Auditing Standards and Single Audits. Questioned Costs: None noted. Cause: Significant staff turnover occurred with regard to these major program case workers. Effect: The County may be incorrectly concluding that an applicant is eligible for the federal programs they are applying for. Repeat Finding: No. Recommendation: We recommend the County perform case file reviews on a more representative sample of the total clients served and that adequate supporting documentation be retained of those reviews. Views of responsible officials: There is no disagreement with the audit finding. Additional documentation and specific casefile reviews will be implemented.
ELIGIBILITY DETERMINATION INCOME AND ASSET VERIFICATION (2022?004) Federal Agency: U.S. Department of Human Services and U.S. Department of Agriculture Federal Program Name: Medical Assistance (Medicaid Cluster) and State Administrative Matching Grants for Supplemental Nutrition Assistance Program (SNAP Cluster) Assistance Listing Number: 93.778 and 10.561 Pass-Through Agency: Minnesota Department of Human Services and Minnesota Department of Agriculture Federal Award Identification and Pass-Through Numbers: 2205MN5ADM and 222MN101S2520 Award Period: Year Ended December 31, 2022 Compliance Requirement: Eligibility Type of Finding: Significant Deficiency in Internal Control over Compliance and Other Matter Criteria or Specific Requirement: Uniform Guidance requires the County to ensure compliance over eligibility by having the proper documentation of income and assets in the METS system. Condition and Context: During our testing of compliance over eligibility, we noted 1 of 60 Medical Assistance case files tested did not have proper asset documentation updated in METS. In the 2021 audit this finding related to retention of income documentation. In addition, our testing of compliance eligibility for the SNAP program we 2 of 60 SNAP case files tested did not have proper income documentation on file. The sample sizes were based on guidance from chapter 11 of the AICPA Audit Guide, Government Auditing Standards and Single Audits. Questioned Costs: None noted. Cause: The County?s internal review process has a limited number of personnel available. Effect: Errors made in determining eligibility may not be discovered and benefits may be issued to clients who are not eligible. Repeat Finding: Yes ? 2021-004. Recommendation: We recommend the County implement procedures to ensure that asset and income documentation in the casefiles be retained and that it matches the information input into the METS eligibility system. Views of responsible officials: There is no disagreement with the audit finding. Training will be provided to health and human services staff regarding proper documentation and entry into METS.
RANDOM MOMENT STUDY (RMS) EMPLOYEE LISTING (2022?005) Federal Agency: U.S. Department of Human Services and U.S. Department of Agriculture Federal Program Name: Medical Assistance (Medicaid Cluster), Temporary Assistance for Needy families (TANF), and State Administrative Matching Grants for Supplemental Nutrition Assistance Program (SNAP Cluster) Assistance Listing Number: 93.778, 93.558, and 10.561 Pass-Through Agency: Minnesota Department of Human Services and Minnesota Department of Agriculture Federal Award Identification and Pass-Through Numbers: 2205MN5ADM, 2201MNTANF, and 222MN101S2520 Award Period: Year Ended December 31, 2022 Compliance Requirement: Activities Allowed/Allowable Costs Type of Finding: Significant Deficiency in Internal Control over Compliance and Other Matter Criteria or Specific Requirement: Compliance standards require the County to include all individuals working on income maintenance activities on the RMS listings. Standards also require the County to separate those individuals into separate account codes for use on the quarterly reports. Condition and Context: During testing of the Income Maintenance Random Moment Study listings, 1 of 2 quarterly reports had individuals that were left off the listing and should have been on the listing. We also noted that there were individuals coded to the RMS listing account codes that should not have been. The sample sizes were based on guidance from chapter 11 of the AICPA Audit Guide, Government Auditing Standards and Single Audits. Questioned Costs: None noted. Cause: Lack of management oversight Effect: There is minimal effect on the programs because due to the funding structure the random moment studies are only used to determine the allocation percentages to the various federal programs and not to determine the total amount of reimbursements. Repeat Finding: No. Recommendation: We recommend the County review the RMS listings and employees within the department and account codes to ensure the proper employees are included on the listing and general ledger accounts. Views of responsible officials: There is no disagreement with the audit finding. Training will be provided to health and human services staff regarding accurate reporting for the random moment studies.
DOCUMENTATION OF PROCUREMENT, SUSPENSION, AND DEBARMENT (2022?003) Federal Agency: U.S. Department of Treasury Federal Program Name: Coronavirus State and Local Fiscal Recovery Funds Assistance Listing Number: 21.027 Pass-Through Agency: N/A - Direct Federal Award Identification and Pass-Through Numbers: N/A - Direct Award Period: Year Ended December 31, 2022 Compliance Requirement: Suspension and Debarment Type of Finding: Significant Deficiency in Internal Control over Compliance and Other Matter Criteria or Specific Requirement: The Uniform Guidance requires that the county maintain supporting documentation to demonstrate the procedures performed to demonstrate that it is not entering into agreements with vendors, paid with federal funds, that are suspended or debarred. Condition and Context: During our testing, we were not presented with supporting documentation for 1 out of 5 transactions tested demonstrating the County performed the search of the suspended and debarred entities nor were we provided with documentation of the review and approval of these procedures. The sample size was based on guidance from chapter 11 of the AICPA Audit Guide, Government Auditing Standards and Single Audits. Questioned Costs: None noted. Cause: Lack of oversight by management. Effect: Improper vendors could be used for services. Repeat Finding: No. Recommendation: We recommend the County retain documentation related to the applicable federal requirements to ensure compliance with said federal requirements. Views of responsible officials: There is no disagreement with the audit finding. A training with department staff will be scheduled to identify areas and best practices to fully implement County policy.
RANDOM MOMENT STUDY (RMS) EMPLOYEE LISTING (2022?005) Federal Agency: U.S. Department of Human Services and U.S. Department of Agriculture Federal Program Name: Medical Assistance (Medicaid Cluster), Temporary Assistance for Needy families (TANF), and State Administrative Matching Grants for Supplemental Nutrition Assistance Program (SNAP Cluster) Assistance Listing Number: 93.778, 93.558, and 10.561 Pass-Through Agency: Minnesota Department of Human Services and Minnesota Department of Agriculture Federal Award Identification and Pass-Through Numbers: 2205MN5ADM, 2201MNTANF, and 222MN101S2520 Award Period: Year Ended December 31, 2022 Compliance Requirement: Activities Allowed/Allowable Costs Type of Finding: Significant Deficiency in Internal Control over Compliance and Other Matter Criteria or Specific Requirement: Compliance standards require the County to include all individuals working on income maintenance activities on the RMS listings. Standards also require the County to separate those individuals into separate account codes for use on the quarterly reports. Condition and Context: During testing of the Income Maintenance Random Moment Study listings, 1 of 2 quarterly reports had individuals that were left off the listing and should have been on the listing. We also noted that there were individuals coded to the RMS listing account codes that should not have been. The sample sizes were based on guidance from chapter 11 of the AICPA Audit Guide, Government Auditing Standards and Single Audits. Questioned Costs: None noted. Cause: Lack of management oversight Effect: There is minimal effect on the programs because due to the funding structure the random moment studies are only used to determine the allocation percentages to the various federal programs and not to determine the total amount of reimbursements. Repeat Finding: No. Recommendation: We recommend the County review the RMS listings and employees within the department and account codes to ensure the proper employees are included on the listing and general ledger accounts. Views of responsible officials: There is no disagreement with the audit finding. Training will be provided to health and human services staff regarding accurate reporting for the random moment studies.
CASE FILE REVIEWS (2022?006) Federal Agency: U.S. Department of Human Services and U.S. Department of Agriculture Federal Program Name: Medical Assistance (Medicaid Cluster), Temporary Assistance for Needy families (TANF), Title IV-E Foster Care and State Administrative Matching Grants for Supplemental Nutrition Assistance Program (SNAP Cluster) Assistance Listing Number: 93.778, 93.558, 93.658 and 10.561 Pass-Through Agency: Minnesota Department of Human Services and Minnesota Department of Agriculture Federal Award Identification and Pass-Through Numbers: 2205MN5ADM, 2201MNTANF, 2201MNFOS and 222MN101S2520 Award Period: Year Ended December 31, 2022 Compliance Requirement: Eligibility Type of Finding: Significant Deficiency in Internal Control over Compliance Criteria or Specific Requirement: Federal guidelines require grant recipients to implement internal controls for each direct and material compliance requirement applicable to the federal grant to ensure compliance with said requirements. Condition and Context: During testing of controls over Eligibility (i.e., casefile reviews), it was noted that less than 10 documented reviews were completed for each program. This is less than 0.1% of the casefiles and is insufficient sample sizes for the number of clients the county handles. The sample sizes were based on guidance from chapter 11 of the AICPA Audit Guide, Government Auditing Standards and Single Audits. Questioned Costs: None noted. Cause: Significant staff turnover occurred with regard to these major program case workers. Effect: The County may be incorrectly concluding that an applicant is eligible for the federal programs they are applying for. Repeat Finding: No. Recommendation: We recommend the County perform case file reviews on a more representative sample of the total clients served and that adequate supporting documentation be retained of those reviews. Views of responsible officials: There is no disagreement with the audit finding. Additional documentation and specific casefile reviews will be implemented.
RANDOM MOMENT STUDY (RMS) EMPLOYEE LISTING (2022?005) Federal Agency: U.S. Department of Human Services and U.S. Department of Agriculture Federal Program Name: Medical Assistance (Medicaid Cluster), Temporary Assistance for Needy families (TANF), and State Administrative Matching Grants for Supplemental Nutrition Assistance Program (SNAP Cluster) Assistance Listing Number: 93.778, 93.558, and 10.561 Pass-Through Agency: Minnesota Department of Human Services and Minnesota Department of Agriculture Federal Award Identification and Pass-Through Numbers: 2205MN5ADM, 2201MNTANF, and 222MN101S2520 Award Period: Year Ended December 31, 2022 Compliance Requirement: Activities Allowed/Allowable Costs Type of Finding: Significant Deficiency in Internal Control over Compliance and Other Matter Criteria or Specific Requirement: Compliance standards require the County to include all individuals working on income maintenance activities on the RMS listings. Standards also require the County to separate those individuals into separate account codes for use on the quarterly reports. Condition and Context: During testing of the Income Maintenance Random Moment Study listings, 1 of 2 quarterly reports had individuals that were left off the listing and should have been on the listing. We also noted that there were individuals coded to the RMS listing account codes that should not have been. The sample sizes were based on guidance from chapter 11 of the AICPA Audit Guide, Government Auditing Standards and Single Audits. Questioned Costs: None noted. Cause: Lack of management oversight Effect: There is minimal effect on the programs because due to the funding structure the random moment studies are only used to determine the allocation percentages to the various federal programs and not to determine the total amount of reimbursements. Repeat Finding: No. Recommendation: We recommend the County review the RMS listings and employees within the department and account codes to ensure the proper employees are included on the listing and general ledger accounts. Views of responsible officials: There is no disagreement with the audit finding. Training will be provided to health and human services staff regarding accurate reporting for the random moment studies.
CASE FILE REVIEWS (2022?006) Federal Agency: U.S. Department of Human Services and U.S. Department of Agriculture Federal Program Name: Medical Assistance (Medicaid Cluster), Temporary Assistance for Needy families (TANF), Title IV-E Foster Care and State Administrative Matching Grants for Supplemental Nutrition Assistance Program (SNAP Cluster) Assistance Listing Number: 93.778, 93.558, 93.658 and 10.561 Pass-Through Agency: Minnesota Department of Human Services and Minnesota Department of Agriculture Federal Award Identification and Pass-Through Numbers: 2205MN5ADM, 2201MNTANF, 2201MNFOS and 222MN101S2520 Award Period: Year Ended December 31, 2022 Compliance Requirement: Eligibility Type of Finding: Significant Deficiency in Internal Control over Compliance Criteria or Specific Requirement: Federal guidelines require grant recipients to implement internal controls for each direct and material compliance requirement applicable to the federal grant to ensure compliance with said requirements. Condition and Context: During testing of controls over Eligibility (i.e., casefile reviews), it was noted that less than 10 documented reviews were completed for each program. This is less than 0.1% of the casefiles and is insufficient sample sizes for the number of clients the county handles. The sample sizes were based on guidance from chapter 11 of the AICPA Audit Guide, Government Auditing Standards and Single Audits. Questioned Costs: None noted. Cause: Significant staff turnover occurred with regard to these major program case workers. Effect: The County may be incorrectly concluding that an applicant is eligible for the federal programs they are applying for. Repeat Finding: No. Recommendation: We recommend the County perform case file reviews on a more representative sample of the total clients served and that adequate supporting documentation be retained of those reviews. Views of responsible officials: There is no disagreement with the audit finding. Additional documentation and specific casefile reviews will be implemented.
CASE FILE REVIEWS (2022?006) Federal Agency: U.S. Department of Human Services and U.S. Department of Agriculture Federal Program Name: Medical Assistance (Medicaid Cluster), Temporary Assistance for Needy families (TANF), Title IV-E Foster Care and State Administrative Matching Grants for Supplemental Nutrition Assistance Program (SNAP Cluster) Assistance Listing Number: 93.778, 93.558, 93.658 and 10.561 Pass-Through Agency: Minnesota Department of Human Services and Minnesota Department of Agriculture Federal Award Identification and Pass-Through Numbers: 2205MN5ADM, 2201MNTANF, 2201MNFOS and 222MN101S2520 Award Period: Year Ended December 31, 2022 Compliance Requirement: Eligibility Type of Finding: Significant Deficiency in Internal Control over Compliance Criteria or Specific Requirement: Federal guidelines require grant recipients to implement internal controls for each direct and material compliance requirement applicable to the federal grant to ensure compliance with said requirements. Condition and Context: During testing of controls over Eligibility (i.e., casefile reviews), it was noted that less than 10 documented reviews were completed for each program. This is less than 0.1% of the casefiles and is insufficient sample sizes for the number of clients the county handles. The sample sizes were based on guidance from chapter 11 of the AICPA Audit Guide, Government Auditing Standards and Single Audits. Questioned Costs: None noted. Cause: Significant staff turnover occurred with regard to these major program case workers. Effect: The County may be incorrectly concluding that an applicant is eligible for the federal programs they are applying for. Repeat Finding: No. Recommendation: We recommend the County perform case file reviews on a more representative sample of the total clients served and that adequate supporting documentation be retained of those reviews. Views of responsible officials: There is no disagreement with the audit finding. Additional documentation and specific casefile reviews will be implemented.
ELIGIBILITY DETERMINATION INCOME AND ASSET VERIFICATION (2022?004) Federal Agency: U.S. Department of Human Services and U.S. Department of Agriculture Federal Program Name: Medical Assistance (Medicaid Cluster) and State Administrative Matching Grants for Supplemental Nutrition Assistance Program (SNAP Cluster) Assistance Listing Number: 93.778 and 10.561 Pass-Through Agency: Minnesota Department of Human Services and Minnesota Department of Agriculture Federal Award Identification and Pass-Through Numbers: 2205MN5ADM and 222MN101S2520 Award Period: Year Ended December 31, 2022 Compliance Requirement: Eligibility Type of Finding: Significant Deficiency in Internal Control over Compliance and Other Matter Criteria or Specific Requirement: Uniform Guidance requires the County to ensure compliance over eligibility by having the proper documentation of income and assets in the METS system. Condition and Context: During our testing of compliance over eligibility, we noted 1 of 60 Medical Assistance case files tested did not have proper asset documentation updated in METS. In the 2021 audit this finding related to retention of income documentation. In addition, our testing of compliance eligibility for the SNAP program we 2 of 60 SNAP case files tested did not have proper income documentation on file. The sample sizes were based on guidance from chapter 11 of the AICPA Audit Guide, Government Auditing Standards and Single Audits. Questioned Costs: None noted. Cause: The County?s internal review process has a limited number of personnel available. Effect: Errors made in determining eligibility may not be discovered and benefits may be issued to clients who are not eligible. Repeat Finding: Yes ? 2021-004. Recommendation: We recommend the County implement procedures to ensure that asset and income documentation in the casefiles be retained and that it matches the information input into the METS eligibility system. Views of responsible officials: There is no disagreement with the audit finding. Training will be provided to health and human services staff regarding proper documentation and entry into METS.
RANDOM MOMENT STUDY (RMS) EMPLOYEE LISTING (2022?005) Federal Agency: U.S. Department of Human Services and U.S. Department of Agriculture Federal Program Name: Medical Assistance (Medicaid Cluster), Temporary Assistance for Needy families (TANF), and State Administrative Matching Grants for Supplemental Nutrition Assistance Program (SNAP Cluster) Assistance Listing Number: 93.778, 93.558, and 10.561 Pass-Through Agency: Minnesota Department of Human Services and Minnesota Department of Agriculture Federal Award Identification and Pass-Through Numbers: 2205MN5ADM, 2201MNTANF, and 222MN101S2520 Award Period: Year Ended December 31, 2022 Compliance Requirement: Activities Allowed/Allowable Costs Type of Finding: Significant Deficiency in Internal Control over Compliance and Other Matter Criteria or Specific Requirement: Compliance standards require the County to include all individuals working on income maintenance activities on the RMS listings. Standards also require the County to separate those individuals into separate account codes for use on the quarterly reports. Condition and Context: During testing of the Income Maintenance Random Moment Study listings, 1 of 2 quarterly reports had individuals that were left off the listing and should have been on the listing. We also noted that there were individuals coded to the RMS listing account codes that should not have been. The sample sizes were based on guidance from chapter 11 of the AICPA Audit Guide, Government Auditing Standards and Single Audits. Questioned Costs: None noted. Cause: Lack of management oversight Effect: There is minimal effect on the programs because due to the funding structure the random moment studies are only used to determine the allocation percentages to the various federal programs and not to determine the total amount of reimbursements. Repeat Finding: No. Recommendation: We recommend the County review the RMS listings and employees within the department and account codes to ensure the proper employees are included on the listing and general ledger accounts. Views of responsible officials: There is no disagreement with the audit finding. Training will be provided to health and human services staff regarding accurate reporting for the random moment studies.
CASE FILE REVIEWS (2022?006) Federal Agency: U.S. Department of Human Services and U.S. Department of Agriculture Federal Program Name: Medical Assistance (Medicaid Cluster), Temporary Assistance for Needy families (TANF), Title IV-E Foster Care and State Administrative Matching Grants for Supplemental Nutrition Assistance Program (SNAP Cluster) Assistance Listing Number: 93.778, 93.558, 93.658 and 10.561 Pass-Through Agency: Minnesota Department of Human Services and Minnesota Department of Agriculture Federal Award Identification and Pass-Through Numbers: 2205MN5ADM, 2201MNTANF, 2201MNFOS and 222MN101S2520 Award Period: Year Ended December 31, 2022 Compliance Requirement: Eligibility Type of Finding: Significant Deficiency in Internal Control over Compliance Criteria or Specific Requirement: Federal guidelines require grant recipients to implement internal controls for each direct and material compliance requirement applicable to the federal grant to ensure compliance with said requirements. Condition and Context: During testing of controls over Eligibility (i.e., casefile reviews), it was noted that less than 10 documented reviews were completed for each program. This is less than 0.1% of the casefiles and is insufficient sample sizes for the number of clients the county handles. The sample sizes were based on guidance from chapter 11 of the AICPA Audit Guide, Government Auditing Standards and Single Audits. Questioned Costs: None noted. Cause: Significant staff turnover occurred with regard to these major program case workers. Effect: The County may be incorrectly concluding that an applicant is eligible for the federal programs they are applying for. Repeat Finding: No. Recommendation: We recommend the County perform case file reviews on a more representative sample of the total clients served and that adequate supporting documentation be retained of those reviews. Views of responsible officials: There is no disagreement with the audit finding. Additional documentation and specific casefile reviews will be implemented.
CASE FILE REVIEWS (2022?006) Federal Agency: U.S. Department of Human Services and U.S. Department of Agriculture Federal Program Name: Medical Assistance (Medicaid Cluster), Temporary Assistance for Needy families (TANF), Title IV-E Foster Care and State Administrative Matching Grants for Supplemental Nutrition Assistance Program (SNAP Cluster) Assistance Listing Number: 93.778, 93.558, 93.658 and 10.561 Pass-Through Agency: Minnesota Department of Human Services and Minnesota Department of Agriculture Federal Award Identification and Pass-Through Numbers: 2205MN5ADM, 2201MNTANF, 2201MNFOS and 222MN101S2520 Award Period: Year Ended December 31, 2022 Compliance Requirement: Eligibility Type of Finding: Significant Deficiency in Internal Control over Compliance Criteria or Specific Requirement: Federal guidelines require grant recipients to implement internal controls for each direct and material compliance requirement applicable to the federal grant to ensure compliance with said requirements. Condition and Context: During testing of controls over Eligibility (i.e., casefile reviews), it was noted that less than 10 documented reviews were completed for each program. This is less than 0.1% of the casefiles and is insufficient sample sizes for the number of clients the county handles. The sample sizes were based on guidance from chapter 11 of the AICPA Audit Guide, Government Auditing Standards and Single Audits. Questioned Costs: None noted. Cause: Significant staff turnover occurred with regard to these major program case workers. Effect: The County may be incorrectly concluding that an applicant is eligible for the federal programs they are applying for. Repeat Finding: No. Recommendation: We recommend the County perform case file reviews on a more representative sample of the total clients served and that adequate supporting documentation be retained of those reviews. Views of responsible officials: There is no disagreement with the audit finding. Additional documentation and specific casefile reviews will be implemented.
ELIGIBILITY DETERMINATION INCOME AND ASSET VERIFICATION (2022?004) Federal Agency: U.S. Department of Human Services and U.S. Department of Agriculture Federal Program Name: Medical Assistance (Medicaid Cluster) and State Administrative Matching Grants for Supplemental Nutrition Assistance Program (SNAP Cluster) Assistance Listing Number: 93.778 and 10.561 Pass-Through Agency: Minnesota Department of Human Services and Minnesota Department of Agriculture Federal Award Identification and Pass-Through Numbers: 2205MN5ADM and 222MN101S2520 Award Period: Year Ended December 31, 2022 Compliance Requirement: Eligibility Type of Finding: Significant Deficiency in Internal Control over Compliance and Other Matter Criteria or Specific Requirement: Uniform Guidance requires the County to ensure compliance over eligibility by having the proper documentation of income and assets in the METS system. Condition and Context: During our testing of compliance over eligibility, we noted 1 of 60 Medical Assistance case files tested did not have proper asset documentation updated in METS. In the 2021 audit this finding related to retention of income documentation. In addition, our testing of compliance eligibility for the SNAP program we 2 of 60 SNAP case files tested did not have proper income documentation on file. The sample sizes were based on guidance from chapter 11 of the AICPA Audit Guide, Government Auditing Standards and Single Audits. Questioned Costs: None noted. Cause: The County?s internal review process has a limited number of personnel available. Effect: Errors made in determining eligibility may not be discovered and benefits may be issued to clients who are not eligible. Repeat Finding: Yes ? 2021-004. Recommendation: We recommend the County implement procedures to ensure that asset and income documentation in the casefiles be retained and that it matches the information input into the METS eligibility system. Views of responsible officials: There is no disagreement with the audit finding. Training will be provided to health and human services staff regarding proper documentation and entry into METS.
RANDOM MOMENT STUDY (RMS) EMPLOYEE LISTING (2022?005) Federal Agency: U.S. Department of Human Services and U.S. Department of Agriculture Federal Program Name: Medical Assistance (Medicaid Cluster), Temporary Assistance for Needy families (TANF), and State Administrative Matching Grants for Supplemental Nutrition Assistance Program (SNAP Cluster) Assistance Listing Number: 93.778, 93.558, and 10.561 Pass-Through Agency: Minnesota Department of Human Services and Minnesota Department of Agriculture Federal Award Identification and Pass-Through Numbers: 2205MN5ADM, 2201MNTANF, and 222MN101S2520 Award Period: Year Ended December 31, 2022 Compliance Requirement: Activities Allowed/Allowable Costs Type of Finding: Significant Deficiency in Internal Control over Compliance and Other Matter Criteria or Specific Requirement: Compliance standards require the County to include all individuals working on income maintenance activities on the RMS listings. Standards also require the County to separate those individuals into separate account codes for use on the quarterly reports. Condition and Context: During testing of the Income Maintenance Random Moment Study listings, 1 of 2 quarterly reports had individuals that were left off the listing and should have been on the listing. We also noted that there were individuals coded to the RMS listing account codes that should not have been. The sample sizes were based on guidance from chapter 11 of the AICPA Audit Guide, Government Auditing Standards and Single Audits. Questioned Costs: None noted. Cause: Lack of management oversight Effect: There is minimal effect on the programs because due to the funding structure the random moment studies are only used to determine the allocation percentages to the various federal programs and not to determine the total amount of reimbursements. Repeat Finding: No. Recommendation: We recommend the County review the RMS listings and employees within the department and account codes to ensure the proper employees are included on the listing and general ledger accounts. Views of responsible officials: There is no disagreement with the audit finding. Training will be provided to health and human services staff regarding accurate reporting for the random moment studies.
DOCUMENTATION OF PROCUREMENT, SUSPENSION, AND DEBARMENT (2022?003) Federal Agency: U.S. Department of Treasury Federal Program Name: Coronavirus State and Local Fiscal Recovery Funds Assistance Listing Number: 21.027 Pass-Through Agency: N/A - Direct Federal Award Identification and Pass-Through Numbers: N/A - Direct Award Period: Year Ended December 31, 2022 Compliance Requirement: Suspension and Debarment Type of Finding: Significant Deficiency in Internal Control over Compliance and Other Matter Criteria or Specific Requirement: The Uniform Guidance requires that the county maintain supporting documentation to demonstrate the procedures performed to demonstrate that it is not entering into agreements with vendors, paid with federal funds, that are suspended or debarred. Condition and Context: During our testing, we were not presented with supporting documentation for 1 out of 5 transactions tested demonstrating the County performed the search of the suspended and debarred entities nor were we provided with documentation of the review and approval of these procedures. The sample size was based on guidance from chapter 11 of the AICPA Audit Guide, Government Auditing Standards and Single Audits. Questioned Costs: None noted. Cause: Lack of oversight by management. Effect: Improper vendors could be used for services. Repeat Finding: No. Recommendation: We recommend the County retain documentation related to the applicable federal requirements to ensure compliance with said federal requirements. Views of responsible officials: There is no disagreement with the audit finding. A training with department staff will be scheduled to identify areas and best practices to fully implement County policy.
RANDOM MOMENT STUDY (RMS) EMPLOYEE LISTING (2022?005) Federal Agency: U.S. Department of Human Services and U.S. Department of Agriculture Federal Program Name: Medical Assistance (Medicaid Cluster), Temporary Assistance for Needy families (TANF), and State Administrative Matching Grants for Supplemental Nutrition Assistance Program (SNAP Cluster) Assistance Listing Number: 93.778, 93.558, and 10.561 Pass-Through Agency: Minnesota Department of Human Services and Minnesota Department of Agriculture Federal Award Identification and Pass-Through Numbers: 2205MN5ADM, 2201MNTANF, and 222MN101S2520 Award Period: Year Ended December 31, 2022 Compliance Requirement: Activities Allowed/Allowable Costs Type of Finding: Significant Deficiency in Internal Control over Compliance and Other Matter Criteria or Specific Requirement: Compliance standards require the County to include all individuals working on income maintenance activities on the RMS listings. Standards also require the County to separate those individuals into separate account codes for use on the quarterly reports. Condition and Context: During testing of the Income Maintenance Random Moment Study listings, 1 of 2 quarterly reports had individuals that were left off the listing and should have been on the listing. We also noted that there were individuals coded to the RMS listing account codes that should not have been. The sample sizes were based on guidance from chapter 11 of the AICPA Audit Guide, Government Auditing Standards and Single Audits. Questioned Costs: None noted. Cause: Lack of management oversight Effect: There is minimal effect on the programs because due to the funding structure the random moment studies are only used to determine the allocation percentages to the various federal programs and not to determine the total amount of reimbursements. Repeat Finding: No. Recommendation: We recommend the County review the RMS listings and employees within the department and account codes to ensure the proper employees are included on the listing and general ledger accounts. Views of responsible officials: There is no disagreement with the audit finding. Training will be provided to health and human services staff regarding accurate reporting for the random moment studies.
CASE FILE REVIEWS (2022?006) Federal Agency: U.S. Department of Human Services and U.S. Department of Agriculture Federal Program Name: Medical Assistance (Medicaid Cluster), Temporary Assistance for Needy families (TANF), Title IV-E Foster Care and State Administrative Matching Grants for Supplemental Nutrition Assistance Program (SNAP Cluster) Assistance Listing Number: 93.778, 93.558, 93.658 and 10.561 Pass-Through Agency: Minnesota Department of Human Services and Minnesota Department of Agriculture Federal Award Identification and Pass-Through Numbers: 2205MN5ADM, 2201MNTANF, 2201MNFOS and 222MN101S2520 Award Period: Year Ended December 31, 2022 Compliance Requirement: Eligibility Type of Finding: Significant Deficiency in Internal Control over Compliance Criteria or Specific Requirement: Federal guidelines require grant recipients to implement internal controls for each direct and material compliance requirement applicable to the federal grant to ensure compliance with said requirements. Condition and Context: During testing of controls over Eligibility (i.e., casefile reviews), it was noted that less than 10 documented reviews were completed for each program. This is less than 0.1% of the casefiles and is insufficient sample sizes for the number of clients the county handles. The sample sizes were based on guidance from chapter 11 of the AICPA Audit Guide, Government Auditing Standards and Single Audits. Questioned Costs: None noted. Cause: Significant staff turnover occurred with regard to these major program case workers. Effect: The County may be incorrectly concluding that an applicant is eligible for the federal programs they are applying for. Repeat Finding: No. Recommendation: We recommend the County perform case file reviews on a more representative sample of the total clients served and that adequate supporting documentation be retained of those reviews. Views of responsible officials: There is no disagreement with the audit finding. Additional documentation and specific casefile reviews will be implemented.
RANDOM MOMENT STUDY (RMS) EMPLOYEE LISTING (2022?005) Federal Agency: U.S. Department of Human Services and U.S. Department of Agriculture Federal Program Name: Medical Assistance (Medicaid Cluster), Temporary Assistance for Needy families (TANF), and State Administrative Matching Grants for Supplemental Nutrition Assistance Program (SNAP Cluster) Assistance Listing Number: 93.778, 93.558, and 10.561 Pass-Through Agency: Minnesota Department of Human Services and Minnesota Department of Agriculture Federal Award Identification and Pass-Through Numbers: 2205MN5ADM, 2201MNTANF, and 222MN101S2520 Award Period: Year Ended December 31, 2022 Compliance Requirement: Activities Allowed/Allowable Costs Type of Finding: Significant Deficiency in Internal Control over Compliance and Other Matter Criteria or Specific Requirement: Compliance standards require the County to include all individuals working on income maintenance activities on the RMS listings. Standards also require the County to separate those individuals into separate account codes for use on the quarterly reports. Condition and Context: During testing of the Income Maintenance Random Moment Study listings, 1 of 2 quarterly reports had individuals that were left off the listing and should have been on the listing. We also noted that there were individuals coded to the RMS listing account codes that should not have been. The sample sizes were based on guidance from chapter 11 of the AICPA Audit Guide, Government Auditing Standards and Single Audits. Questioned Costs: None noted. Cause: Lack of management oversight Effect: There is minimal effect on the programs because due to the funding structure the random moment studies are only used to determine the allocation percentages to the various federal programs and not to determine the total amount of reimbursements. Repeat Finding: No. Recommendation: We recommend the County review the RMS listings and employees within the department and account codes to ensure the proper employees are included on the listing and general ledger accounts. Views of responsible officials: There is no disagreement with the audit finding. Training will be provided to health and human services staff regarding accurate reporting for the random moment studies.
CASE FILE REVIEWS (2022?006) Federal Agency: U.S. Department of Human Services and U.S. Department of Agriculture Federal Program Name: Medical Assistance (Medicaid Cluster), Temporary Assistance for Needy families (TANF), Title IV-E Foster Care and State Administrative Matching Grants for Supplemental Nutrition Assistance Program (SNAP Cluster) Assistance Listing Number: 93.778, 93.558, 93.658 and 10.561 Pass-Through Agency: Minnesota Department of Human Services and Minnesota Department of Agriculture Federal Award Identification and Pass-Through Numbers: 2205MN5ADM, 2201MNTANF, 2201MNFOS and 222MN101S2520 Award Period: Year Ended December 31, 2022 Compliance Requirement: Eligibility Type of Finding: Significant Deficiency in Internal Control over Compliance Criteria or Specific Requirement: Federal guidelines require grant recipients to implement internal controls for each direct and material compliance requirement applicable to the federal grant to ensure compliance with said requirements. Condition and Context: During testing of controls over Eligibility (i.e., casefile reviews), it was noted that less than 10 documented reviews were completed for each program. This is less than 0.1% of the casefiles and is insufficient sample sizes for the number of clients the county handles. The sample sizes were based on guidance from chapter 11 of the AICPA Audit Guide, Government Auditing Standards and Single Audits. Questioned Costs: None noted. Cause: Significant staff turnover occurred with regard to these major program case workers. Effect: The County may be incorrectly concluding that an applicant is eligible for the federal programs they are applying for. Repeat Finding: No. Recommendation: We recommend the County perform case file reviews on a more representative sample of the total clients served and that adequate supporting documentation be retained of those reviews. Views of responsible officials: There is no disagreement with the audit finding. Additional documentation and specific casefile reviews will be implemented.
CASE FILE REVIEWS (2022?006) Federal Agency: U.S. Department of Human Services and U.S. Department of Agriculture Federal Program Name: Medical Assistance (Medicaid Cluster), Temporary Assistance for Needy families (TANF), Title IV-E Foster Care and State Administrative Matching Grants for Supplemental Nutrition Assistance Program (SNAP Cluster) Assistance Listing Number: 93.778, 93.558, 93.658 and 10.561 Pass-Through Agency: Minnesota Department of Human Services and Minnesota Department of Agriculture Federal Award Identification and Pass-Through Numbers: 2205MN5ADM, 2201MNTANF, 2201MNFOS and 222MN101S2520 Award Period: Year Ended December 31, 2022 Compliance Requirement: Eligibility Type of Finding: Significant Deficiency in Internal Control over Compliance Criteria or Specific Requirement: Federal guidelines require grant recipients to implement internal controls for each direct and material compliance requirement applicable to the federal grant to ensure compliance with said requirements. Condition and Context: During testing of controls over Eligibility (i.e., casefile reviews), it was noted that less than 10 documented reviews were completed for each program. This is less than 0.1% of the casefiles and is insufficient sample sizes for the number of clients the county handles. The sample sizes were based on guidance from chapter 11 of the AICPA Audit Guide, Government Auditing Standards and Single Audits. Questioned Costs: None noted. Cause: Significant staff turnover occurred with regard to these major program case workers. Effect: The County may be incorrectly concluding that an applicant is eligible for the federal programs they are applying for. Repeat Finding: No. Recommendation: We recommend the County perform case file reviews on a more representative sample of the total clients served and that adequate supporting documentation be retained of those reviews. Views of responsible officials: There is no disagreement with the audit finding. Additional documentation and specific casefile reviews will be implemented.
ELIGIBILITY DETERMINATION INCOME AND ASSET VERIFICATION (2022?004) Federal Agency: U.S. Department of Human Services and U.S. Department of Agriculture Federal Program Name: Medical Assistance (Medicaid Cluster) and State Administrative Matching Grants for Supplemental Nutrition Assistance Program (SNAP Cluster) Assistance Listing Number: 93.778 and 10.561 Pass-Through Agency: Minnesota Department of Human Services and Minnesota Department of Agriculture Federal Award Identification and Pass-Through Numbers: 2205MN5ADM and 222MN101S2520 Award Period: Year Ended December 31, 2022 Compliance Requirement: Eligibility Type of Finding: Significant Deficiency in Internal Control over Compliance and Other Matter Criteria or Specific Requirement: Uniform Guidance requires the County to ensure compliance over eligibility by having the proper documentation of income and assets in the METS system. Condition and Context: During our testing of compliance over eligibility, we noted 1 of 60 Medical Assistance case files tested did not have proper asset documentation updated in METS. In the 2021 audit this finding related to retention of income documentation. In addition, our testing of compliance eligibility for the SNAP program we 2 of 60 SNAP case files tested did not have proper income documentation on file. The sample sizes were based on guidance from chapter 11 of the AICPA Audit Guide, Government Auditing Standards and Single Audits. Questioned Costs: None noted. Cause: The County?s internal review process has a limited number of personnel available. Effect: Errors made in determining eligibility may not be discovered and benefits may be issued to clients who are not eligible. Repeat Finding: Yes ? 2021-004. Recommendation: We recommend the County implement procedures to ensure that asset and income documentation in the casefiles be retained and that it matches the information input into the METS eligibility system. Views of responsible officials: There is no disagreement with the audit finding. Training will be provided to health and human services staff regarding proper documentation and entry into METS.
RANDOM MOMENT STUDY (RMS) EMPLOYEE LISTING (2022?005) Federal Agency: U.S. Department of Human Services and U.S. Department of Agriculture Federal Program Name: Medical Assistance (Medicaid Cluster), Temporary Assistance for Needy families (TANF), and State Administrative Matching Grants for Supplemental Nutrition Assistance Program (SNAP Cluster) Assistance Listing Number: 93.778, 93.558, and 10.561 Pass-Through Agency: Minnesota Department of Human Services and Minnesota Department of Agriculture Federal Award Identification and Pass-Through Numbers: 2205MN5ADM, 2201MNTANF, and 222MN101S2520 Award Period: Year Ended December 31, 2022 Compliance Requirement: Activities Allowed/Allowable Costs Type of Finding: Significant Deficiency in Internal Control over Compliance and Other Matter Criteria or Specific Requirement: Compliance standards require the County to include all individuals working on income maintenance activities on the RMS listings. Standards also require the County to separate those individuals into separate account codes for use on the quarterly reports. Condition and Context: During testing of the Income Maintenance Random Moment Study listings, 1 of 2 quarterly reports had individuals that were left off the listing and should have been on the listing. We also noted that there were individuals coded to the RMS listing account codes that should not have been. The sample sizes were based on guidance from chapter 11 of the AICPA Audit Guide, Government Auditing Standards and Single Audits. Questioned Costs: None noted. Cause: Lack of management oversight Effect: There is minimal effect on the programs because due to the funding structure the random moment studies are only used to determine the allocation percentages to the various federal programs and not to determine the total amount of reimbursements. Repeat Finding: No. Recommendation: We recommend the County review the RMS listings and employees within the department and account codes to ensure the proper employees are included on the listing and general ledger accounts. Views of responsible officials: There is no disagreement with the audit finding. Training will be provided to health and human services staff regarding accurate reporting for the random moment studies.
CASE FILE REVIEWS (2022?006) Federal Agency: U.S. Department of Human Services and U.S. Department of Agriculture Federal Program Name: Medical Assistance (Medicaid Cluster), Temporary Assistance for Needy families (TANF), Title IV-E Foster Care and State Administrative Matching Grants for Supplemental Nutrition Assistance Program (SNAP Cluster) Assistance Listing Number: 93.778, 93.558, 93.658 and 10.561 Pass-Through Agency: Minnesota Department of Human Services and Minnesota Department of Agriculture Federal Award Identification and Pass-Through Numbers: 2205MN5ADM, 2201MNTANF, 2201MNFOS and 222MN101S2520 Award Period: Year Ended December 31, 2022 Compliance Requirement: Eligibility Type of Finding: Significant Deficiency in Internal Control over Compliance Criteria or Specific Requirement: Federal guidelines require grant recipients to implement internal controls for each direct and material compliance requirement applicable to the federal grant to ensure compliance with said requirements. Condition and Context: During testing of controls over Eligibility (i.e., casefile reviews), it was noted that less than 10 documented reviews were completed for each program. This is less than 0.1% of the casefiles and is insufficient sample sizes for the number of clients the county handles. The sample sizes were based on guidance from chapter 11 of the AICPA Audit Guide, Government Auditing Standards and Single Audits. Questioned Costs: None noted. Cause: Significant staff turnover occurred with regard to these major program case workers. Effect: The County may be incorrectly concluding that an applicant is eligible for the federal programs they are applying for. Repeat Finding: No. Recommendation: We recommend the County perform case file reviews on a more representative sample of the total clients served and that adequate supporting documentation be retained of those reviews. Views of responsible officials: There is no disagreement with the audit finding. Additional documentation and specific casefile reviews will be implemented.