Audit 31545

FY End
2022-12-31
Total Expended
$40.00M
Findings
0
Programs
36
Organization: City of Bismarck (ND)
Year: 2022 Accepted: 2023-07-19
Auditor: Eide Bailly LLP

Organization Exclusion Status:

Checking exclusion status...

Findings

No findings recorded

Programs

ALN Program Spent Major Findings
21.027 Coronavirus State and Local Fiscal Recovery Funds $9.66M Yes 0
20.106 Airport Improvement Program $6.35M Yes 0
20.507 Federal Transit_formula Grants $2.39M Yes 0
66.458 Capitalization Grants for Clean Water State Revolving Funds $916,648 - 0
20.526 Buses and Bus Facilities Formula, Competitive, and Low Or No Emissions Programs $838,591 Yes 0
20.205 Highway Planning and Construction $574,285 - 0
93.268 Immunization Cooperative Agreements $572,329 - 0
97.039 Hazard Mitigation Grant $278,118 - 0
20.505 Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research $217,252 - 0
93.069 Public Health Emergency Preparedness $200,178 - 0
97.067 Homeland Security Grant Program $190,107 - 0
93.917 Hiv Care Formula Grants $128,770 - 0
20.513 Enhanced Mobility of Seniors and Individuals with Disabilities $123,584 - 0
93.276 Drug-Free Communities Support Program Grants $123,362 - 0
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $109,815 - 0
93.898 Cancer Prevention and Control Programs for State, Territorial and Tribal Organizations $95,729 - 0
93.391 Activities to Support State, Tribal, Local and Territorial (stlt) Health Department Response to Public Health Or Healthcare Crises $91,938 - 0
97.042 Emergency Management Performance Grants $62,963 - 0
16.838 Comprehensive Opioid Abuse Site-Based Program $61,390 - 0
14.218 Community Development Block Grants/entitlement Grants $54,298 - 0
16.738 Edward Byrne Memorial Justice Assistance Grant Program $45,486 - 0
93.116 Project Grants and Cooperative Agreements for Tuberculosis Control Programs $42,887 - 0
93.991 Preventive Health and Health Services Block Grant $25,979 - 0
10.675 Urban and Community Forestry Program $18,780 - 0
16.607 Bulletproof Vest Partnership Program $14,963 - 0
16.588 Violence Against Women Formula Grants $13,119 - 0
10.664 Cooperative Forestry Assistance $13,111 - 0
15.904 Historic Preservation Fund Grants-in-Aid $12,987 - 0
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $10,458 - 0
20.703 Interagency Hazardous Materials Public Sector Training and Planning Grants $8,428 - 0
16.034 Coronavirus Emergency Supplemental Funding Program $7,991 - 0
20.600 State and Community Highway Safety $7,006 - 0
93.994 Maternal and Child Health Services Block Grant to the States $6,104 - 0
93.940 Hiv Prevention Activities_health Department Based $4,430 - 0
97.012 Boating Safety Financial Assistance $4,064 - 0
20.616 National Priority Safety Programs $3,037 - 0

Contacts

Name Title Type
HHE6BW32JLP3 Tyson Lund Auditee
7013551603 Barb Aasen Auditor
No contacts on file

Notes to SEFA

Title: BASIS OF PRESENTATION Accounting Policies: Governmental fund types account for the majority of the Citys federal grant activity, with the exception of the Airport Improvement Project grants which are recorded in the airport enterprise fund. Therefore, expenditures reported in the schedule of expenditures of federal awards are recognized on the accrual basis of accounting for the airport improvement projects, and the remaining expenditures, except for subrecipient expenditures, reported in the schedule of expenditures of federal awards are recognized on the modified accrual basis when they become a demand on current available financial resources. Subrecipient expenditures are recorded on the cash basis. 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. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. The accompanying schedule of expenditures of federal awards (the schedule) includes the federal award activityof the City of Bismarck under programs of the federal government for the year ended December 31, 2022. The information is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Because the schedule presents only a selected portion of the operations of the City of Bismarck, it is not intended to and does not present the financial position, changes in net position or fund balance, or cash flows of the City of Bismarck.
Title: LOAN PROGRAMS Accounting Policies: Governmental fund types account for the majority of the Citys federal grant activity, with the exception of the Airport Improvement Project grants which are recorded in the airport enterprise fund. Therefore, expenditures reported in the schedule of expenditures of federal awards are recognized on the accrual basis of accounting for the airport improvement projects, and the remaining expenditures, except for subrecipient expenditures, reported in the schedule of expenditures of federal awards are recognized on the modified accrual basis when they become a demand on current available financial resources. Subrecipient expenditures are recorded on the cash basis. 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. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. As of December 31, 2022, the City's liability relating to the Drinking Water State Revolving Fund (SRF) Loan (AL #66.468) is $5,710,489. As of December 31, 2022, the City's liability relating to the Clean Water State Revolving Fund (SRF) Loan (AL #66.458) is $4,705,000