Audit 94856

FY End
2022-06-30
Total Expended
$134.06M
Findings
2
Programs
91
Organization: Pima County (AZ)
Year: 2022 Accepted: 2023-03-29

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
98125 2022-101 Material Weakness - M
674567 2022-101 Material Weakness - M

Programs

ALN Program Spent Major Findings
21.027 Coronavirus State and Local Fiscal Recovery Funds $37.14M Yes 0
21.023 Emergency Rental Assistance Program $20.69M Yes 0
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $12.05M - 0
97.024 Emergency Food and Shelter National Board Program $10.51M Yes 1
14.218 Community Development Block Grants/entitlement Grants $3.44M - 0
17.259 Wia Youth Activities $3.24M - 0
17.258 Wia Adult Program $3.07M - 0
17.278 Wia Dislocated Worker Formula Grants $2.73M - 0
93.268 Immunization Cooperative Agreements $2.53M - 0
10.557 Special Supplemental Nutrition Program for Women, Infants, and Children $2.01M - 0
93.658 Foster Care_title IV-E $1.46M - 0
93.243 Substance Abuse and Mental Health Services_projects of Regional and National Significance $1.35M - 0
93.391 Activities to Support State, Tribal, Local and Territorial (stlt) Health Department Response to Public Health Or Healthcare Crises $1.05M Yes 0
93.738 Pphf: Racial and Ethnic Approaches to Community Health Program Financed Solely by Public Prevention and Health Funds $1.02M - 0
16.575 Crime Victim Assistance $984,143 - 0
90.404 2018 Hava Election Security Grants $745,140 - 0
93.137 Community Programs to Improve Minority Health Grant Program $730,199 - 0
93.217 Family Planning_services $729,124 - 0
93.558 Temporary Assistance for Needy Families $691,665 - 0
93.069 Public Health Emergency Preparedness $689,734 - 0
97.042 Emergency Management Performance Grants $642,608 - 0
66.001 Air Pollution Control Program Support $619,325 - 0
16.710 Public Safety Partnership and Community Policing Grants $531,379 - 0
93.994 Maternal and Child Health Services Block Grant to the States $471,798 - 0
17.268 H-1b Job Training Grants $449,054 - 0
16.833 National Sexual Assault Kit Initiative $415,636 - 0
14.239 Home Investment Partnerships Program $402,281 - 0
93.569 Community Services Block Grant $399,379 - 0
93.136 Injury Prevention and Control Research and State and Community Based Programs $376,055 - 0
16.812 Second Chance Act Reentry Initiative $374,291 - 0
93.870 Maternal, Infant and Early Childhood Home Visiting Grant $349,163 - 0
93.940 Hiv Prevention Activities_health Department Based $341,664 - 0
97.045 Cooperating Technical Partners $285,359 - 0
93.898 Cancer Prevention and Control Programs for State, Territorial and Tribal Organizations $258,145 - 0
16.590 Grants to Encourage Arrest Policies and Enforcement of Protection Orders Program $257,928 - 0
95.001 High Intensity Drug Trafficking Areas Program $234,830 - 0
16.606 State Criminal Alien Assistance Program $232,297 - 0
16.738 Edward Byrne Memorial Justice Assistance Grant Program $217,480 - 0
45.310 Grants to States $202,029 - 0
93.788 Opioid Str $195,024 - 0
16.585 Drug Court Discretionary Grant Program $194,872 - 0
66.605 Performance Partnership Grants $193,501 - 0
93.568 Low-Income Home Energy Assistance $182,387 - 0
84.010 Title I Grants to Local Educational Agencies $178,153 - 0
16.034 Coronavirus Emergency Supplemental Funding Program $172,355 - 0
20.600 State and Community Highway Safety $153,377 - 0
93.917 Hiv Care Formula Grants $148,691 - 0
84.002 Adult Education - Basic Grants to States $148,298 - 0
17.805 Homeless Veterans Reintegration Project $144,128 - 0
14.256 Neighborhood Stabilization Program (recovery Act Funded) $119,841 - 0
17.277 Workforce Investment Act (wia) National Emergency Grants $111,345 - 0
14.231 Emergency Solutions Grant Program $110,839 - 0
66.034 Surveys, Studies, Research, Investigations, Demonstrations, and Special Purpose Activities Relating to the Clean Air Act $107,936 - 0
10.904 Watershed Protection and Flood Prevention $105,324 - 0
93.991 Preventive Health and Health Services Block Grant $85,286 - 0
10.555 National School Lunch Program $79,436 - 0
16.540 Juvenile Justice and Delinquency Prevention_allocation to States $74,029 - 0
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $64,951 - 0
14.267 Continuum of Care Program $64,585 - 0
93.421 Strengthening Public Health Systems and Services Through National Partnerships to Improve and Protect the Nations Health $60,729 - 0
14.241 Housing Opportunities for Persons with Aids $60,533 - 0
93.093 Affordable Care Act (aca) Health Profession Opportunity Grants $58,933 - 0
93.103 Food and Drug Administration_research $56,700 - 0
96.U03 Funds Received From the Social Security Administration $50,200 - 0
10.553 School Breakfast Program $49,876 - 0
16.U00 Justice Department $44,162 - 0
93.944 Human Immunodeficiency Virus (hiv)/acquired Immunodeficiency Virus Syndrome (aids) Surveillance $39,937 - 0
81.042 Weatherization Assistance for Low-Income Persons $39,436 - 0
10.704 Law Enforcement Agreements $37,994 - 0
93.116 Project Grants and Cooperative Agreements for Tuberculosis Control Programs $37,935 - 0
93.110 Maternal and Child Health Federal Consolidated Programs $36,660 - 0
16.726 Juvenile Mentoring Program $35,184 - 0
10.923 Emergency Watershed Protection Program $34,400 - 0
10.540 Participant Research Innovation Laboratory for Enhancing Wic Services $33,924 - 0
93.597 Grants to States for Access and Visitation Programs $32,561 - 0
93.667 Social Services Block Grant $30,315 - 0
10.433 Rural Housing Preservation Grants $28,936 - 0
94.006 Americorps $27,216 - 0
84.425 Education Stabilization Fund $23,881 - 0
93.135 Centers for Research and Demonstration for Health Promotion and Disease Prevention $23,501 - 0
93.977 Preventive Health Services_sexually Transmitted Diseases Control Grants $17,138 - 0
84.424 Student Support and Academic Enrichment Program $10,001 - 0
84.027 Special Education_grants to States $9,830 - 0
21.U01 Treasury Unknown $7,308 - 0
20.616 National Priority Safety Programs $4,665 - 0
84.367 Improving Teacher Quality State Grants $3,479 - 0
97.067 Homeland Security Grant Program $2,584 - 0
20.205 Highway Planning and Construction $1,974 Yes 0
93.236 Grants to States to Support Oral Health Workforce Activities $1,638 - 0
97.070 Map Modernization Management Support $1,375 - 0
93.070 Environmental Public Health and Emergency Response $768 - 0

Contacts

Name Title Type
JBMBVGUK5LF1 Regina Kelly Auditee
5207246679 Michael P. Manion, CPA Auditor
No contacts on file

Notes to SEFA

Title: Basis of presentation Accounting Policies: 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 Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in the preparation of, the financial statements. De Minimis Rate Used: Y Rate Explanation: The County elected to use the 10 percent de minimis indirect cost rate as covered in 2 CFR ?200.414. The accompanying schedule of expenditures of federal awards (schedule) includes Pima County's federal grant activity for the year ended June 30, 2022. The information in this schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance).
Title: Federal Assistance Listings number Accounting Policies: 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 Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in the preparation of, the financial statements. De Minimis Rate Used: Y Rate Explanation: The County elected to use the 10 percent de minimis indirect cost rate as covered in 2 CFR ?200.414. The program titles and Federal Assistance Listings numbers were obtained from the federal or pass-through grantor or the 2022 Federal Assistance Listings as well as SAM.GOV and Grants.gov websites. When no Federal Assistance Listings number had been assigned to a program, the 2-digit federal agency identifier and the federal contract number were used. When there was no federal contract number, the 2-digit federal agency identifier and the word unknown were used.
Title: Coronavirus State & Local Fiscal Recovery Fund Revenue Loss Accounting Policies: 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 Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in the preparation of, the financial statements. De Minimis Rate Used: Y Rate Explanation: The County elected to use the 10 percent de minimis indirect cost rate as covered in 2 CFR ?200.414. The County elected to claim the $10 million revenue loss standard allowance rather than using the calculated revenue loss option. The expenditure amount reported on this schedule is the aggregate expenditure amount for all four eligible use categories and not the result of the revenue loss calculation or standard allowance.

Finding Details

Assistance Listings number and name: 97.024 Emergency Food and Shelter National Board Program Award number and year: 0727200-056, April 1, 2021 through September 30, 2022 Federal agency: Federal Emergency Management Agency Pass-through grantor: United Way Compliance requirement: Subrecipient monitoring Questioned costs: Unknown Condition?The County?s Grants Management and Innovation Department awarded $1.6 million to 1 of 2 subrecipients during the year, or 15 percent of the Department?s $10.6 million total program expenditures, but did not perform all the required monitoring activities of the subrecipient?s activities or compliance with the award terms and program requirements. Specifically, the Department performed insufficient monitoring during the year, which consisted only of reviewing and approving the subrecipient?s invoices of program expenditures for reimbursement. However, those monitoring procedures alone were not sufficient to evaluate whether the subrecipient used program monies in accordance with the award terms and program requirements. Effect?The Department?s lack of required monitoring increased the risk that the $1.6 million of program monies the Department awarded to this subrecipient may not have been spent in accordance with the award terms and program requirements. Cause?Department management reported that it had a previous contractor relationship with the subrecipient and had not reevaluated the substance of its federal award agreement with it, as required by federal regulation, to properly identify the need to implement subrecipient monitoring procedures. Criteria?Federal regulations require the County to evaluate the substance of its federal award agreements with other parties to determine whether each of the other parties receiving the monies have the role of a subrecipient or contractor and whether they are required to comply with any of the federal program?s requirements that the County should monitor (2 Code of Federal Regulation [CFR] ?200.331). Additionally, federal regulations require the County to monitor subrecipients, which includes required monitoring procedures for assessing the risk of each subrecipient?s noncompliance and monitoring activities based on those risk assessments; verifying single audits were conducted timely; following up on and ensuring corrective action is taken on audit findings that could potentially affect the program; and issuing a management decision for audit findings pertaining to the federal award. Those federal regulations also provide that monitoring procedures may include reviewing financial and performance reports, providing training or technical assistance on program-related matters, and performing onsite reviews, selective audits, and/or other monitoring procedures (2 CFR ?200.332[b] and [d ? e]). Also, federal regulation requires establishing and maintaining effective internal control over federal awards that provides reasonable assurance that the federal program is being managed in compliance with all applicable laws, regulations, and award terms (2 CFR ?200.303). Recommendations?The Department should: 1. Evaluate the substance of its federal award agreements with other parties to determine whether each of the other parties receiving the monies have the role of a subrecipient or contractor and whether they are required to comply with any of the federal program?s requirements that the Department should monitor. 2. Ensure it performs required monitoring of its subrecipients and their compliance with the award terms and program requirements by following its existing policies and procedures that require the Department to: a. Assess the risk of each subrecipient?s noncompliance and carry out monitoring activities based on those risk assessments such as reviewing financial and performance reports, providing training or technical assistance on program-related matters, and performing on-site reviews, selective audits, and/or other monitoring procedures. b. Verify subrecipients receive timely single audits, follow up on and ensure that corrective action is taken on any audit findings that could potentially affect the program, and issue management decisions for any audit findings pertaining to the federal award. c. Maintain documentation of monitoring procedures demonstrating they were performed, including the monitoring procedures? results and any County actions taken, if appropriate. The County?s corrective action plan at the end of this report includes the views and planned corrective action of its responsible officials. We are not required to audit and have not audited these responses and planned corrective actions and therefore provide no assurances as to their accuracy.
Assistance Listings number and name: 97.024 Emergency Food and Shelter National Board Program Award number and year: 0727200-056, April 1, 2021 through September 30, 2022 Federal agency: Federal Emergency Management Agency Pass-through grantor: United Way Compliance requirement: Subrecipient monitoring Questioned costs: Unknown Condition?The County?s Grants Management and Innovation Department awarded $1.6 million to 1 of 2 subrecipients during the year, or 15 percent of the Department?s $10.6 million total program expenditures, but did not perform all the required monitoring activities of the subrecipient?s activities or compliance with the award terms and program requirements. Specifically, the Department performed insufficient monitoring during the year, which consisted only of reviewing and approving the subrecipient?s invoices of program expenditures for reimbursement. However, those monitoring procedures alone were not sufficient to evaluate whether the subrecipient used program monies in accordance with the award terms and program requirements. Effect?The Department?s lack of required monitoring increased the risk that the $1.6 million of program monies the Department awarded to this subrecipient may not have been spent in accordance with the award terms and program requirements. Cause?Department management reported that it had a previous contractor relationship with the subrecipient and had not reevaluated the substance of its federal award agreement with it, as required by federal regulation, to properly identify the need to implement subrecipient monitoring procedures. Criteria?Federal regulations require the County to evaluate the substance of its federal award agreements with other parties to determine whether each of the other parties receiving the monies have the role of a subrecipient or contractor and whether they are required to comply with any of the federal program?s requirements that the County should monitor (2 Code of Federal Regulation [CFR] ?200.331). Additionally, federal regulations require the County to monitor subrecipients, which includes required monitoring procedures for assessing the risk of each subrecipient?s noncompliance and monitoring activities based on those risk assessments; verifying single audits were conducted timely; following up on and ensuring corrective action is taken on audit findings that could potentially affect the program; and issuing a management decision for audit findings pertaining to the federal award. Those federal regulations also provide that monitoring procedures may include reviewing financial and performance reports, providing training or technical assistance on program-related matters, and performing onsite reviews, selective audits, and/or other monitoring procedures (2 CFR ?200.332[b] and [d ? e]). Also, federal regulation requires establishing and maintaining effective internal control over federal awards that provides reasonable assurance that the federal program is being managed in compliance with all applicable laws, regulations, and award terms (2 CFR ?200.303). Recommendations?The Department should: 1. Evaluate the substance of its federal award agreements with other parties to determine whether each of the other parties receiving the monies have the role of a subrecipient or contractor and whether they are required to comply with any of the federal program?s requirements that the Department should monitor. 2. Ensure it performs required monitoring of its subrecipients and their compliance with the award terms and program requirements by following its existing policies and procedures that require the Department to: a. Assess the risk of each subrecipient?s noncompliance and carry out monitoring activities based on those risk assessments such as reviewing financial and performance reports, providing training or technical assistance on program-related matters, and performing on-site reviews, selective audits, and/or other monitoring procedures. b. Verify subrecipients receive timely single audits, follow up on and ensure that corrective action is taken on any audit findings that could potentially affect the program, and issue management decisions for any audit findings pertaining to the federal award. c. Maintain documentation of monitoring procedures demonstrating they were performed, including the monitoring procedures? results and any County actions taken, if appropriate. The County?s corrective action plan at the end of this report includes the views and planned corrective action of its responsible officials. We are not required to audit and have not audited these responses and planned corrective actions and therefore provide no assurances as to their accuracy.