Audit 314865

FY End
2023-12-31
Total Expended
$25.25M
Findings
0
Programs
33
Organization: City of Bismarck (ND)
Year: 2023 Accepted: 2024-07-11
Auditor: Eide Bailly LLP

Organization Exclusion Status:

Checking exclusion status...

Findings

No findings recorded

Programs

ALN Program Spent Major Findings
20.106 Airport Improvement Program $11.57M Yes 0
20.205 Highway Planning and Construction $871,093 - 0
20.526 Buses and Bus Facilities Formula, Competitive, and Low Or No Emissions Programs $544,931 - 0
97.039 Hazard Mitigation Grant $433,779 - 0
93.391 Activities to Support State, Tribal, Local and Territorial (stlt) Health Department Response to Public Health Or Healthcare Crises $410,025 - 0
20.505 Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research $382,509 - 0
66.458 Capitalization Grants for Clean Water State Revolving Funds $315,436 - 0
97.067 Homeland Security Grant Program $218,249 - 0
93.069 Public Health Emergency Preparedness $193,724 - 0
14.218 Community Development Block Grants/entitlement Grants $172,763 - 0
93.917 Hiv Care Formula Grants $169,764 - 0
93.898 Cancer Prevention and Control Programs for State, Territorial and Tribal Organizations $129,523 - 0
20.513 Enhanced Mobility of Seniors and Individuals with Disabilities $114,689 - 0
93.276 Drug-Free Communities Support Program Grants $105,358 - 0
97.042 Emergency Management Performance Grants $67,604 - 0
93.116 Project Grants and Cooperative Agreements for Tuberculosis Control Programs $52,884 - 0
93.268 Immunization Cooperative Agreements $39,151 - 0
16.607 Bulletproof Vest Partnership Program $35,794 - 0
16.838 Comprehensive Opioid Abuse Site-Based Program $33,379 - 0
93.994 Maternal and Child Health Services Block Grant to the States $25,142 - 0
20.703 Interagency Hazardous Materials Public Sector Training and Planning Grants $21,535 - 0
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $14,195 - 0
93.991 Preventive Health and Health Services Block Grant $12,925 - 0
15.904 Historic Preservation Fund Grants-in-Aid $11,152 - 0
20.600 State and Community Highway Safety $7,274 - 0
93.967 Cdc's Collaboration with Academia to Strengthen Public Health $6,069 - 0
16.738 Edward Byrne Memorial Justice Assistance Grant Program $4,332 - 0
93.940 Hiv Prevention Activities_health Department Based $4,052 - 0
10.664 Cooperative Forestry Assistance $3,895 - 0
97.012 Boating Safety Financial Assistance $3,735 - 0
20.616 National Priority Safety Programs $3,468 - 0
97.137 State and Local Cybersecurity Grant Program $605 - 0
20.507 Federal Transit_formula Grants $2 - 0

Contacts

Name Title Type
HHE6BW32JLP3 Eric Lund Auditee
7013551611 Barb Aasen Auditor
No contacts on file

Notes to SEFA

Title: NOTE A-BASIS OF PRESENTATION Accounting Policies: Governmental fund types account for the majority of the City’s 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 City has not elected to use the 10% de minimis cost rate. The accompanying schedule of expenditures of federal awards (the schedule) includes the federal award activity of the City of Bismarck under programs of the federal government for the year ended December 31, 2023. The information is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Because the schedule presents only a selected portion of the operations of the 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: NOTE B- SUMMARY OF SIGNIGICANT ACCOUNTING POLICIES Accounting Policies: Governmental fund types account for the majority of the City’s 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 City has not elected to use the 10% de minimis cost rate. Governmental fund types account for the majority of the City’s 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.
Title: NOTE C- INDIRECT COST RATE Accounting Policies: Governmental fund types account for the majority of the City’s 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 City has not elected to use the 10% de minimis cost rate. The City has not elected to use the 10% de minimis cost rate.
Title: NOTE D- LOAN PROGRAMS Accounting Policies: Governmental fund types account for the majority of the City’s 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 City has not elected to use the 10% de minimis cost rate. As of December 31, 2023, the City’s liability relating to the Drinking Water State Revolving Fund (SRF) Loan (AL #66.468) is $5,278,200. As of December 31, 2023, the City’s liability relating to the Clean Water State Revolving Fund (SRF) Loan (AL #66.458) is $4,410,000.