Audit 304121

FY End
2023-06-30
Total Expended
$29.22M
Findings
0
Programs
27
Organization: City of Billings (MT)
Year: 2023 Accepted: 2024-04-22
Auditor: Jccs PC

Organization Exclusion Status:

Checking exclusion status...

Findings

No findings recorded

Programs

ALN Program Spent Major Findings
20.106 Airport Improvement Program $10.30M Yes 0
20.933 National Infrastructure Investments $3.73M Yes 0
21.027 Coronavirus State and Local Fiscal Recovery Funds $3.51M Yes 0
20.507 Federal Transit_formula Grants $1.61M Yes 0
14.218 Community Development Block Grants/entitlement Grants $1.39M Yes 0
20.205 Highway Planning and Construction $1.27M - 0
20.509 Formula Grants for Rural Areas and Tribal Transit Program $1.24M Yes 0
20.526 Buses and Bus Facilities Formula, Competitive, and Low Or No Emissions Programs $841,336 Yes 0
16.922 Equitable Sharing Program $704,548 - 0
97.067 Homeland Security Grant Program $387,504 - 0
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $332,554 - 0
20.505 Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research $277,120 - 0
93.243 Substance Abuse and Mental Health Services_projects of Regional and National Significance $275,102 - 0
95.001 High Intensity Drug Trafficking Areas Program $251,130 - 0
16.738 Edward Byrne Memorial Justice Assistance Grant Program $175,374 - 0
16.585 Drug Court Discretionary Grant Program $142,193 - 0
16.588 Violence Against Women Formula Grants $137,438 - 0
16.838 Comprehensive Opioid Abuse Site-Based Program $127,377 - 0
14.239 Home Investment Partnerships Program $124,350 - 0
94.013 Volunteers in Service to America $81,718 - 0
20.219 Recreational Trails Program $44,335 - 0
20.703 Interagency Hazardous Materials Public Sector Training and Planning Grants $22,015 - 0
45.024 Promotion of the Arts_grants to Organizations and Individuals $16,244 - 0
16.609 Project Safe Neighborhoods $14,419 - 0
20.325 Consolidated Rail Infrastructure and Safety Improvements $14,311 - 0
20.600 State and Community Highway Safety $12,838 - 0
15.904 Historic Preservation Fund Grants-in-Aid $6,000 - 0

Contacts

Name Title Type
FAEFYK4YL4M1 Andrew Zoeller Auditee
4066578209 Tyler Bryant Auditor
No contacts on file

Notes to SEFA

Title: Basis of Presentation Accounting Policies: Amounts reported in the schedule of expenditures of federal awards are recognized on the modified accrual basis when they become a demand on current available federal resources and eligibility requirements are met, or on the accrual basis, at the time liabilities are incurred and all eligibility requirements are met, depending on the basis of accounting used by the respective fund. Such expenditures are recognized following the cost principles 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: Indirect costs are not allocated to federal grants The accompanying Schedule of Expenditures of Federal Awards includes the federal grant activity of the City of Billings, Montana for the year ended June 30, 2023. The City’s reporting entity is described in Note 1 in the City’s basic financial statements. All federal financial assistance received directly from federal agencies, as well as federal financial assistance passed through other governmental agencies, is included in the schedule. The information in this schedule is presented in accordance with 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). Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in the presentation of, the basic financial statements.
Title: Significant Accounting Policies Accounting Policies: Amounts reported in the schedule of expenditures of federal awards are recognized on the modified accrual basis when they become a demand on current available federal resources and eligibility requirements are met, or on the accrual basis, at the time liabilities are incurred and all eligibility requirements are met, depending on the basis of accounting used by the respective fund. Such expenditures are recognized following the cost principles 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: Indirect costs are not allocated to federal grants Amounts reported in the schedule of expenditures of federal awards are recognized on the modified accrual basis when they become a demand on current available federal resources and eligibility requirements are met, or on the accrual basis, at the time liabilities are incurred and all eligibility requirements are met, depending on the basis of accounting used by the respective fund. Such expenditures are recognized following the cost principles in the Uniform Guidance wherein certain types of expenditures are not allowable or are limited as to reimbursement.
Title: Indirect Cost Rate Accounting Policies: Amounts reported in the schedule of expenditures of federal awards are recognized on the modified accrual basis when they become a demand on current available federal resources and eligibility requirements are met, or on the accrual basis, at the time liabilities are incurred and all eligibility requirements are met, depending on the basis of accounting used by the respective fund. Such expenditures are recognized following the cost principles 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: Indirect costs are not allocated to federal grants The City has elected not to use the 10% De Minimis indirect cost rate allowed under the Uniform Guidance.
Title: ARPA Reconciliation Accounting Policies: Amounts reported in the schedule of expenditures of federal awards are recognized on the modified accrual basis when they become a demand on current available federal resources and eligibility requirements are met, or on the accrual basis, at the time liabilities are incurred and all eligibility requirements are met, depending on the basis of accounting used by the respective fund. Such expenditures are recognized following the cost principles 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: Indirect costs are not allocated to federal grants ARPA fund eligibility requirements are considered to be met at the time of project completion. The State of Montana withholds payments to the City until projects are complete, therefore, the City considers that the eligibility of the expenditures as being met at that point in time. Once these projects are complete and the grant funds are remitted to the City from the State is the point in which the expenditures are recognized in the Schedule of Expenditures and Federal Awards. The below reconciliation depicts the reconciliation of each of the relevant grant awards that are affected: