Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
05-12-23 City Manager Report
1 City of Kalispell OFFICE OF THE CITY MANAGER Information Memorandum 5/12/2023 1. Parks and Recreation 350 third graders from School District 5 participated in our Arbor Day celebration at Woodland Park. Education booths were hosted by fourteen organizations and twenty-one businesses sponsored the event. Twenty volunteers assisted in planting seven trees in Woodland Park and another twenty- four trees in other parks and boulevards throughout the community. DNRC was on hand to present Kalispell’s thirty-sixth award as a Tree City USA. Park Staff are charging park irrigation systems and completing seasonal turf maintenance in city parks. The north parking lots at the Kalispell Youth Athletics Complex (KYAC) recently received striping creating approximately five hundred parking spaces. This is one of the final pieces to create seven multipurpose sports fields on the north end of KYAC. Registration for the Adult 7v7 Outdoor Co-Rec Soccer League will open in May. Teams will play eleven games plus playoffs on Monday and Thursday evenings starting June 15. We are entering week 4 of Spring Soccer. Games are played on Wednesdays and Fridays from 5:30-7:45 at the Kalispell Youth Athletic Complex. We are putting the finishing touches on our Camp Woodland summer program. We have a few spots open, but the days are limited. Summer Camp begins June 12. Our other summer camps have spots open for kids to stay engaged this summer including sports camps, art camps, dance camps, and more. Registration for Summer Swim Lessons will open on June 3 at 8:00am with a registration event at Woodland Water Park. The pool will open to the public on Wednesday, June 14. 2 2. Public Works 2023 Street and Alley Restoration Projects Annually, the Street Department performs pavement restoration projects. The restoration consists of asphalt milling and overlay of streets and alleys, major patching, and crack sealing. This summer, the larger projects will have a contractor perform the milling. The paving will be performed by city crews. The projects and activities are prioritized each year based on pavement conditions and budgets. Streets and alleys slated for in-house restoration projects for 2023 construction season are listed below: Assignment 2023 Season Street Name From Location To Location Linear Feet City Alley Mill & Overlay Alley Six blocks per year Six blocks alleys/year 1,800 City Reconstruct 9th St E 8th Ave E Woodland Ave 565 Contractor Mill & City Overlay Denver Ave Sunnyside Dr Bluestone ,1500 Contractor Mill & City Overlay 3rd St E Main Woodland Ave 2,020 Contractor Mill & City Overlay Stratford Dr Teal Drive Blue Stone 1,200 Contractor Mill & City Overlay E Nicklaus Ave Ritzman E Nicklaus Ave 2,600 Contractor Mill &Overlay Woodland Park Dr Hwy 2 E Collage Ave 2,445 Contractor Reconstruct 8th Ave W Center Street 11th St to 7th Ave W 4,360 City Mill & Overlay Memory Ln Rogers Dr Cul-de-sac 1,085 City Mill & Overlay Albina Woodland Ave Memory Ln 215 All projects are subject to change based on weather, workload, and any unforeseeable incidents that may occur in the construction season Public Water System – Chlorine Kalispell’s Public Water Supply is required to be disinfected with chlorine prior to distribution to the public. Liquid chlorine is purchased, delivered, and stored on site at each well facility on a monthly basis. Recently, the Water Superintendent and Operators have updated the delivery receiving methods and created additional opportunities for chemical companies to provide quotes. Starting in May, this change will create a $4.36 per gallon cost savings for the purchase of chlorine. For reference, Kalispell purchases approximately 6,000 gallons of chlorine per year. 3. Information Services The Council Chambers Audio Video/AV upgrade changed the in-room electronics from 3 analog to digital. Higher resolution settings have been enabled through cameras, screens, and output improvement. TVs were replaced on the walls to improve viewing content being shared on the screens. The existing projector resolution was changed to support the higher resolution capability of the AV components. The standalone TV, laptop, and Meeting Owl are no longer used to integrate Zoom meetings in the Council Chambers. Zoom can be run with the AV production system in the AV room or from a laptop along the staff table if the Council Chambers are used for a training or meeting that is not broadcast. Staff continue to work on the TV broadcast signal for Council and Planning board meetings. Equipment within the fiscal year 2024 budget will replace the analog event controller used to program cable TV channel 190. Currently the high-definition AV signal is downgraded to analog to send the signal to the TV programming device. 4. Police Department Year to date calls for service volume is 13,031. This compares with 12,480 in 2022, and 11,821 in 2021. Detective case load volume is 220 for the year. This compares with 254 in 2022 and 196 in 2021. On May 2, Kalispell Police Officers and our local partner agencies participated in the Montana Law Enforcement Torch Run. Members of the Kalispell Special Response Team, along with other regional teams, participated in a three-day training event. The focus of this training was to build tactical concepts to provide for the safe recovery of bus occupants during a critical incident, such as a hostage situation. Treasure State Transit provided a variety of school buses and other local charter bus platforms for the training. Detective Sweigart attended a Fire Investigation Course that covered the NFPA guidelines of origin and cause, photography, arc mapping, electrical overview, evidence and interviewing, and fire dynamics. 5. Fire Department From April 26 to May 9, the Fire Department had 152 responses. Of these, there were 103 medical incidents, 1 structure fire, 1 technical rescue, 1 grass fire, 6 motor vehicle accidents with injuries, 3 illegal burns, 7 fire alarm activations, 6 public assists, 1 haz-mat incident, and 23 dispatched and canceled enroute. 2 KFD members attended a weeklong CIT (Crisis Intervention Team) training to help better understand and respond to behavioral health patients. 4 The Assistant Chief is attending a weeklong Fire Investigation course in Butte. KFD assisted Smith Valley to a structure fire which resulted in a near total loss. KFD performed a technical rescue from a 25’ deep concrete well vault. The Whitefish Fire Department provided assistance. 6. Planning Department The Planning Board held a public hearing on May 9 and heard two application requests, consisting of the following: 1. File #KCU-23-02 – Immanuel Lutheran Communities has submitted an application for a conditional use permit for a day care center at Northridge Lutheran Church, which is located at 323 Northridge Drive. The day care center would eventually serve up to 100 children, generally from ages 0-6, although initially there would be up to 48 children. 2. File #KA-23-04 – Summit Holdings, LP, has submitted an application for annexation and initial zoning of RA-1 (Residential Apartment) for property located at 249 Reserve Place. The property is currently occupied by Mountain Villa Apartments and the annexation would allow for connection of the existing apartments to city sanitary sewer. The Board recommended approval of the two application requests. The recommendations will be forwarded to the Council for consideration at the June 5 meeting. The Planning Board also held a public hearing on the following items: 1. Housing Solutions LLC, a nonprofit corporation specializing in the preservation and development of affordable housing, are planning to develop Creekside Commons, an affordable multi-family rental housing complex on the site at 76 Glenwood Dr., Kalispell, Montana 59901. This complex will consist of 25 one- bedroom units and 6 two-bedroom units for elderly persons. 2. A request for public comment regarding the Morning Star Court Community Water and Wastewater Improvement Project application to the Montana Department of Commerce, Community Development Block Grant program. 3. A request for public comment regarding the Green Acres Court Community Wastewater Improvement Project application to the Montana Department of Commerce, Community Development Block Grant program. 7. Building Department In the last 2 weeks, we have issued permits for 2 single-family homes. This brings the 5 total of new single-family/duplex and townhouse units for the year to 19, compared to 70 last year at this time. There have been 67 multi-family housing units issued so far this year. Last year, at this time, we had issued 85 multi-family housing units. There were a total of 277 combined building and/or fire inspections completed in the last 2 weeks. Residential – 38 Plumbing – 24 Commercial – 41 Mechanical - 17 Electrical – 22 Fire – 135 8. Community Development The city is in the beginning stages of its 2022 USDOT Safe Streets and Roads for All (SS4A) grant project to create a Main Street Corridor Comprehensive Plan. The planning project will be carried out over two years and will culminate with a plan for City Council consideration. Community stakeholders will be invited to participate in this effort through multiple public engagement efforts in the coming months. 9. Finance Department Quarterly Finance Report Please find attached the printouts reflecting the activity for the first nine months of fiscal year 2023. This printout reflects payroll earned through March 31, and accounts payable claims received by the end of March. Most funds are included in the report. However, some funds are excluded due to insignificant activity. Revenues are displayed for funds that have significant revenues that are not “taxes and/or assessments.” Debt service funds are not included. GENERAL FUND The general fund receives about 63% of its revenue from tax levies (general and permissive health), and another 25% from intergovernmental revenues (entitlement share, etc.). Generally speaking, for every $1,000,000 of budgeted expenditures, the general fund should have $200,000 of cash carryover to begin the fiscal year. State law allows a 50% carryover for tax supported funds. Since taxes are not received by the City until January and July, 50% is needed in some municipalities to pay 6 months of bills. The City of Kalispell has enough non-tax revenue in the general fund to reduce the necessary carryover to 20%-30%. Beginning cash carryover was 35% (FY22) and 28% (FY23). General Fund tax revenue reflects taxes collected through March 31. Historically, the general fund receives about 45% of its property tax revenue in the fourth quarter. A similar distribution for this fiscal year would bring collections to $6.9M or about 102% of 6 budget. The City is currently carrying over $12,000 in protest taxes. Liquor licenses are billed once a year and are due by June 30. Planning fees have already exceeded the budget. City Court fines and fees revenue reflects July through February (8 months). Investment earnings have increased with the increase in interest rates. General Fund expenditures reflect 68% spent, compared to 66% for the same 9 months last fiscal period. All general fund departments have at least 3 months (25%) budget remaining. PARKS The parks fund receives approximately two-thirds of its revenue from tax levies (general and permissive health). A majority of parks charges for services revenue is received in the second half of the fiscal year. Similar to a solely tax supported fund, the parks fund should have enough cash available on July 1st (and January 1st) to pay expenditures, less revenues other than taxes, through December (June). Beginning cash carryover was 51% (FY22) and 59% (FY23). Parks fund tax collections are 58% at the end of March, compared to 60% one year ago. Parks fund expenditures reflect 58% spent, compared to 52% over the same period last fiscal year. All parks fund departments have at least 3 months (25%) budget remaining. AMBULANCE The ambulance fund is a special revenue fund that receives approximately one-half of its revenue from charges for services. Because ambulance fees for services are insufficient to support the cost to operate this fund, a transfer from the general fund is necessary. Ambulance fees for services ($319,345) are down over 11% from the same period last year ($366,521), and over 28% from the fiscal year 21 amount of $410,375. BUILDING DEPARTMENT The building fund is supported by permits and fees. At a minimum, this fund should have enough cash available on July 1st to pay expenditures through December. Beginning cash carryover was 179% (FY22) and 201% (FY23). Building department permits and fees are about 57% of the budgeted annual amounts. The approximately $765,629 of permits and fees collected this fiscal year is over $500,000 less than what was collected through 75% of last fiscal year. WATER 7 The water fund is supported by charges for water service. Metered water sales through March were $3,804,577 (88%), an increase from the same period last fiscal year of about 15%. It is normal for metered water sales to be more than 75% of the annual amount because of late summer and fall sprinkling and irrigation. The increase from fiscal year 2022 water revenue can be mostly attributed to an increase in rates. Water impact fees are 34% of the fiscal year 23 budget. Capital project expenditures in the water department through the first three quarters were $1,415,719. This includes about $300,000 in purchases with the use of impact fees. Water projects include the meter replacement project ($218,674), Noffsinger rehab project ($177,500), contract main upsize project ($52,661), elevated tank and well ($881,743), and 2nd Avenue West main repairs. SEWER The sewer fund is supported by charges for sewer service. Sewer service charges through March 31 were $5,970,193, 82% of the budgeted amount. Last year’s sewer service charges were $5,283,360 for the same period. The increase from fiscal year 2022 sewer revenue can be mostly attributed to an increase in rates. Capital expenditures in the sewer department through the first three quarters were $996,346. This includes about $140,000 in expenditures with the use of impact fees. Sewer projects include lift station improvements, replacements, and reconstructions at the wastewater treatment plant, a new eq basin at the wastewater treatment plant, and design for the fermenter reconstruction. EXPENDITURES/EXPENSES: Most departments and/or funds have at least 27% remaining in the salaries and retirement lines, which should be adequate. Health insurance is paid twelve times per year and includes 8 months (66%) in this report for all funds. With a few exceptions, administrative, central garage, and information technology transfers are done monthly and should show 25% remaining. This is the same on the revenue side for fees for services (Central Garage), Internal Services (Information Technology), administrative charges (General Fund), and many of the transfers between funds. The general fund administrative charges may vary slightly as some charges are based on a percentage of revenues collected. QTR 3 2023 THE CITY OF KALISPELL, MONTANA05.03.2023 12:59 gb8501_pg.php/Job No: 3302 Page 1 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2023 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING GENERAL FUND - REVENUE 1000-000-311100-000 REAL PROPERTY TAXES 3,958,210 6,800,000 2,841,790 42% 1000-000-311200-000 PERSONAL PROPERTY TAXES 85,921 180,000 94,079 52% 1000-000-312000-000 PEN & INTEREST DEL. TAXES 9,016 10,000 984 10% 1000-000-322101-000 LIQUOR LICENSES 0 33,000 33,000 100% 1000-000-322300-000 BUSINESS LICENSES 248 1,500 1,252 83% 1000-000-323012-000 PLANNING FEES 116,604 100,000 16,604- -17% 1000-000-323109-000 SITE REVIEW 5,273 30,000 24,727 82% 1000-000-323200-000 PARADE PERMITS 400 500 100 20% 1000-000-331023-000 MRVCTF 924 0 924- 0% 1000-000-331112-000 KPD - SAFE STREET TASK FORCE 0 8,000 8,000 100% 1000-000-331990-000 CARES ACT GRANT/ COVID-19 STIMULUS 25,161 0 25,161- 0% 1000-000-335030-000 M.V. TAX - AD VALOREM 0 1,128 1,128 100% 1000-000-335076-000 ST VIDEO -LIC FEE AND TAX DIST 55,600 60,000 4,400 7% 1000-000-335110-000 LIVE CARD TABLE PERMIT 1,650 1,650 0 0% 1000-000-335230-000 ENTITLEMENT SHARE PMT/HB124 2,405,969 3,186,286 780,317 24% 1000-000-341020-000 ADMINISTRATIVE CHARGES 537,071 700,531 163,460 23% 1000-000-341021-000 GRANT ADMIN FEES 16,844 30,000 13,156 44% 1000-000-341025-000 CITY COLLECTIONS 9,548 5,000 4,548- -91% 1000-000-342010-000 POLICE SERVICES 19,327 29,000 9,673 33% 1000-000-342014-000 RESOURCE OFFICERS 258,836 258,836 0 0% 1000-000-342016-000 KPD REGIONAL TRAINING 4,125 14,500 10,375 72% 1000-000-343018-000 PARKING PERMITS 70,803 90,000 19,197 21% 1000-000-343062-000 AIRPORT FUEL TAXES 2,666 4,000 1,334 33% 1000-000-343063-000 AIRPORT GROUND LEASE (HILTON) 13,532 13,259 273- -2% 1000-000-351000-000 CITY COURT FINES & FEES 175,583 430,000 254,417 59% 1000-000-351017-000 COURT SECURITY & TECHNOLOGY FEE 15,760 25,000 9,240 37% 1000-000-351035-000 PARKING FINES & BOOT REMOVAL 37,927 40,000 2,074 5% 1000-000-362000-000 RENT (Central School) 180 0 180- 0% 1000-000-362015-000 INSURANCE REIMBURSEMENTS 0 20,000 20,000 100% 1000-000-362020-000 MMIA LIABILITY RETRO 24,458 20,000 4,458- -22% 1000-000-364030-000 SALE OF MISCELLANEOUS/AUCTION 51,335 10,000 41,335- -413% 1000-000-371010-000 INVESTMENT EARNINGS 260,130 30,000 230,130- -767% 1000-000-381060-000 OPERATING TRANSFER- FUND 2372 550,000 1,100,000 550,000 50% 1000-000-382030-000 GAIN (LOSS)SALE OF ASSET 59,851 0 59,851- 0% ------------------------------------------------- TOTAL GENERAL FUND REVENUE 8,772,952 13,232,190 4,459,238 34% ================================================= QTR 3 2023 THE CITY OF KALISPELL, MONTANA05.03.2023 12:59 gb8501_pg.php/Job No: 3302 Page 2 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2023 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING GENERAL FUND - EXPENDITURES GENERAL GOV'T. 1000-400-410530-331 ANNUAL REPORT FILING FEES 2,555 3,530 975 28% 1000-400-410530-353 CONTRACT SERVICES - AUDIT 0 14,250 14,250 100% 1000-400-410530-354 GASB 75 ACTUARIAL VALUATION 1,750 1,750 0 0% 1000-400-410560-210 PURCHASING/OFFICE SUPPLIES 1,109 4,500 3,391 75% 1000-400-410560-312 POSTAGE 13,249 17,500 4,251 24% 1000-400-410560-320 PRINTING & ENVELOPES 5,662 5,500 162- -3% 1000-400-410560-354 CONTRACT SERVICES - DOC. SHRED / 10 791 1,200 409 34% 1000-400-410900-331 RECORDS ADMIN./FILING FEES 4,977 4,500 477- -11% 1000-400-420000-356 SMITH VALLEY FIRE LEVY REIMB. 264 350 86 24% 1000-400-430300-355 AIRPORT REIMBURSEMENT 76,771 25,000 51,771- -207% 1000-400-460452-355 EAGLE TRANSIT CONTRIBUTION 15,000 15,000 0 0% 1000-400-460452-366 HOCKADAY MAINTENANCE 6,600 6,600 0 0% 1000-400-510300-000 CONTINGENCY 0 30,000 30,000 100% 1000-400-510330-513 LIABILITY INSURANCE 330,841 330,842 1 0% 1000-400-510330-516 UNINSURED LOSS -PROPERTY/LIABILITY 89,314 50,000 39,314- -79% 1000-400-510330-517 PROPERTY INSURANCE 72,813 72,813 0 0% ------------------------------------------------- SUBTOTAL GEN.GOV'T. 621,695 583,335 38,360- -7% CITY MANAGER 1000-401-410210-110 SALARIES-CITY MANAGER'S OFFICE 125,832 175,140 49,308 28% 1000-401-410210-153 HEALTH INSURANCE 15,896 25,228 9,332 37% 1000-401-410210-155 RETIREMENT 13,526 18,663 5,137 28% 1000-401-410210-210 SUPPLIES 52 1,000 948 95% 1000-401-410210-312 NEWSLETTER/BOOKS 0 400 400 100% 1000-401-410210-345 TELEPHONE & COMMUNICATION 680 1,200 520 43% 1000-401-410210-373 DUES & TRAINING 5,605 12,000 6,395 53% 1000-401-410210-379 MEETINGS 2,874 6,500 3,626 56% INFORMATION TECHNOLOGY ------------------------------------------------- SUBTOTAL CITY MANAGER 164,465 240,131 75,666 32% HUMAN RESOURCES 1000-401-410830-110 SALARIES-HR DEPT. 129,865 179,526 49,661 28% 1000-401-410830-153 HEALTH INSURANCE 14,855 22,403 7,548 34% 1000-401-410830-155 RETIREMENT 10,791 14,749 3,958 27% 1000-401-410830-210 OFFICE SUPPLIES 668 1,500 832 55% 1000-401-410830-338 RECRUITMENT/RELOCATION 19,154 24,000 4,846 20% 1000-401-410830-345 TELEPHONE 0 625 625 100% 1000-401-410830-354 CONTRACT SERVICES 3,210 2,500 710- -28% 1000-401-410830-373 DUES & TRAINING 11,582 17,000 5,418 32% ------------------------------------------------- SUBTOTAL HUMAN RESOURCES 190,123 262,303 72,180 28% QTR 3 2023 THE CITY OF KALISPELL, MONTANA05.03.2023 12:59 gb8501_pg.php/Job No: 3302 Page 3 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2023 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING MAYOR/COUNCIL 1000-402-410100-110 SALARIES-MAYOR/COUNCIL 45,610 63,179 17,569 28% 1000-402-410100-153 HEALTH INSURANCE 28,880 45,560 16,680 37% 1000-402-410100-155 RETIREMENT 1,922 2,646 724 27% 1000-402-410100-210 OFFICE SUPPLIES 0 6,500 6,500 100% 1000-402-410100-335 MT LEAGUE OF CITIES 299 1,500 1,201 80% 1000-402-410100-354 CONTRACT SERVICES 2,446 5,500 3,054 56% 1000-402-410100-373 DUES & TRAINING 12,546 11,500 1,046- -9% 1000-402-410100-379 MEETINGS 19,685 36,000 16,315 45% ------------------------------------------------- SUBTOTAL MAYOR/COUNCIL 111,388 172,385 60,997 35% CITY CLERK 1000-402-410150-110 SALARIES-CITY CLERK 85,667 118,594 32,927 28% 1000-402-410150-121 OVERTIME 66 250 184 73% 1000-402-410150-153 HEALTH INSURANCE 10,985 16,566 5,581 34% 1000-402-410150-155 RETIREMENT 7,115 9,764 2,649 27% 1000-402-410150-210 OFFICE SUPPLIES 216 600 384 64% 1000-402-410150-331 COMMUNICATIONS - ADVERTISING 64 500 436 87% 1000-402-410150-345 TELEPHONE & COMMUNICATION 360 480 120 25% 1000-402-410150-352 CODIFICATION 2,866 4,100 1,234 30% 1000-402-410150-354 CONTRACT SERVICES 104 650 546 84% 1000-402-410150-373 DUES & TRAINING 4,156 6,200 2,044 33% ------------------------------------------------- SUBTOTAL CITY CLERK 111,599 157,704 46,105 29% FINANCE DEPARTMENT 1000-403-410550-110 SALARIES-FINANCE OFFICE 182,917 260,655 77,738 30% 1000-403-410550-112 SALARIES-RETIREMENT 38,450 36,940 1,510- -4% 1000-403-410550-121 OVERTIME 0 500 500 100% 1000-403-410550-153 HEALTH INSURANCE 30,159 41,548 11,389 27% 1000-403-410550-155 RETIREMENT 15,172 21,402 6,230 29% 1000-403-410550-210 SUPPLIES 416 1,500 1,084 72% 1000-403-410550-322 BOOKS 0 500 500 100% 1000-403-410550-353 CONTRACT SERVICES 1,558 250 1,308- -523% 1000-403-410550-354 CONTRACT-GRIZZLY SECURITY 1,173 1,500 327 22% 1000-403-410550-355 BANK CHARGES & FEES 2,314 3,500 1,186 34% 1000-403-410550-373 DUES & TRAINING 1,828 12,000 10,172 85% ------------------------------------------------- SUBTOTAL FINANCE 273,985 380,295 106,310 28% CITY ATTORNEY 1000-404-411110-110 SALARIES-CITY ATTORNEY'S 346,527 535,511 188,984 35% 1000-404-411110-112 SALARIES - SEVERANCE 126,413 135,000 8,587 6% 1000-404-411110-121 OVERTIME 135 0 135- 0% 1000-404-411110-153 HEALTH INSURANCE 49,669 92,560 42,891 46% 1000-404-411110-155 RETIREMENT 28,694 44,037 15,343 35% 1000-404-411110-210 OFFICE/COMPUTER SUPPLIES 3,105 6,000 2,895 48% 1000-404-411110-322 LEXIS-NEXIS/BOOKS/SUBSCRIPTIONS 10,987 20,000 9,013 45% 1000-404-411110-345 TELEPHONE & COMMUNICATION 577 1,000 423 42% 1000-404-411110-354 CONTRACT SERVICES/CONTINGENCY 753 10,000 9,247 92% 1000-404-411110-373 DUES & TRAINING 5,527 8,000 2,473 31% ------------------------------------------------- SUBTOTAL CITY ATTORNEY 572,387 852,108 279,721 33% QTR 3 2023 THE CITY OF KALISPELL, MONTANA05.03.2023 12:59 gb8501_pg.php/Job No: 3302 Page 4 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2023 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING MUNICIPAL COURT 1000-406-410360-110 SALARIES-COURT 174,031 274,694 100,663 37% 1000-406-410360-121 OVERTIME 0 3,500 3,500 100% 1000-406-410360-153 HEALTH INSURANCE 26,347 46,394 20,047 43% 1000-406-410360-155 RETIREMENT 14,460 22,546 8,087 36% 1000-406-410360-210 SUPPLIES 946 4,500 3,554 79% 1000-406-410360-320 PRINTING/BOOKS 158 1,500 1,342 89% 1000-406-410360-345 TELEPHONE & COMMUNICATION 527 1,000 473 47% 1000-406-410360-353 SECURITY & TECHNOLOGY 18,152 40,000 21,848 55% 1000-406-410360-354 CONTRACT SERVICES 5,080 7,000 1,920 27% 1000-406-410360-373 DUES & TRAINING 2,796 10,000 7,204 72% 1000-406-410360-394 JURY & WITNESS FEES 4,010 10,000 5,990 60% ------------------------------------------------- SUBTOTAL COURT 246,507 421,134 174,627 41% QTR 3 2023 THE CITY OF KALISPELL, MONTANA05.03.2023 12:59 gb8501_pg.php/Job No: 3302 Page 5 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2023 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING PUBLIC WORKS ADMINISTRATION 1000-410-430100-110 SALARIES-PUBLIC WORKS 16,492 25,394 8,902 35% 1000-410-430100-153 HEALTH INSURANCE 2,181 3,631 1,450 40% 1000-410-430100-155 RETIREMENT 1,355 2,055 700 34% 1000-410-430100-210 COMPUTER/OFFICE SUPPLIES 9,044 15,500 6,456 42% 1000-410-430100-218 NON CAPITAL EQUIP/ENGINEERING TOOLS 0 3,500 3,500 100% 1000-410-430100-231 GAS 3,882 4,500 618 14% 1000-410-430100-345 TELEPHONE & COMMUNICATION 716 900 184 20% 1000-410-430100-354 CONTRACT SERVICES 4,598 8,000 3,402 43% 1000-410-430100-373 DUES & TRAINING 2,619 5,000 2,381 48% 1000-410-430100-521 CENTRAL GARAGE TRANSFER 3,246 4,327 1,081 25% ------------------------------------------------- SUBTOTAL PUBLIC WORKS ADMIN 44,135 72,807 28,672 39% QTR 3 2023 THE CITY OF KALISPELL, MONTANA05.03.2023 12:59 gb8501_pg.php/Job No: 3302 Page 6 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2023 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING CITY HALL MAINT. 1000-412-411230-110 SALARIES-CITY HALL 53,349 74,374 21,025 28% 1000-412-411230-153 HEALTH INSURANCE 8,604 14,564 5,960 41% 1000-412-411230-155 RETIREMENT 4,388 6,055 1,667 28% 1000-412-411230-220 SECURITY IMPROVEMENTS 0 5,000 5,000 100% 1000-412-411230-224 JANITORIAL SUPPLIES 4,468 7,500 3,032 40% 1000-412-411230-241 TOOLS & SUPPLIES 367 1,500 1,133 76% 1000-412-411230-341 ELECTRICITY 32,929 50,000 17,071 34% 1000-412-411230-344 NATURAL GAS 31,387 35,000 3,613 10% 1000-412-411230-345 TELEPHONE & COMMUNICATION 298 500 202 40% 1000-412-411230-354 CONTRACT SERVICES 7,650 15,000 7,350 49% 1000-412-411230-355 HVAC MAINTENANCE CONTRACT 18,076 18,076 0 0% 1000-412-411230-361 ELEVATOR MAINT/FIRE ALARM MAINT 4,670 7,200 2,530 35% 1000-412-411230-362 EQUIPMENT MAINTENANCE 9,480 10,000 520 5% 1000-412-411230-366 BUILDING MAINTENANCE 17,846 22,000 4,154 19% 1000-412-411230-545 COUNTY LANDFILL/RECYCLING 3,351 3,780 429 11% 1000-412-411230-920 BLDG IMPROVEMENT 0 73,000 73,000 100% ------------------------------------------------- SUBTOTAL CITY HALL 196,863 343,549 146,686 43% QTR 3 2023 THE CITY OF KALISPELL, MONTANA05.03.2023 12:59 gb8501_pg.php/Job No: 3302 Page 7 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2023 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 420 PLANNING DEPARTMENT 1000-420-411020-110 SALARIES-PLANNING & ZONING 177,192 256,086 78,894 31% 1000-420-411020-153 HEALTH INSURANCE 28,570 39,816 11,246 28% 1000-420-411020-155 RETIREMENT 14,703 21,079 6,376 30% 1000-420-411020-210 SUPPLIES/EQUIPMENT/SOFTWARE 1,809 4,000 2,191 55% 1000-420-411020-231 GAS 285 500 215 43% 1000-420-411020-331 PUBLICATION/FILING FEES/BOOKS 1,225 2,500 1,275 51% 1000-420-411020-345 TELEPHONE 354 1,000 646 65% 1000-420-411020-354 CONTRACT SERVICES 175 6,000 5,825 97% 1000-420-411020-373 DUES & TRAINING 4,106 8,000 3,894 49% 1000-420-411020-521 CENTRAL GARAGE TRANSFER 61 81 20 25% ------------------------------------------------- SUBTOTAL PLANNING DEPT. 228,479 339,062 110,583 33% 480 COMMUNITY DEVELOPMENT 1000-480-470210-110 SALARIES - COMM. DEV. DEPT. 27,553 52,217 24,664 47% 1000-480-470210-153 HEALTH INSURANCE 3,556 9,856 6,300 64% 1000-480-470210-155 RETIREMENT 2,288 4,271 1,983 46% 1000-480-470210-210 OFFICE SUPPLIES 72 1,600 1,528 95% 1000-480-470210-211 GRANT ADMIN EXP/PROJECT EXP 120 600 480 80% 1000-480-470210-312 POSTAGE & PRINTING 0 300 300 100% 1000-480-470210-334 MT WEST ECONOMIC DEV MEMBERSHIP 0 500 500 100% 1000-480-470210-345 TELEPHONE/COMMUNICATIONS 172 450 278 62% 1000-480-470210-354 CONTRACT SERVICES 84 250 166 66% 1000-480-470210-373 DUES & TRAINING 4,281 5,000 719 14% 1000-480-470210-379 MEETINGS 60 750 690 92% ------------------------------------------------- SUBTOTAL COMMUNITY DEVELOPMENT 38,187 75,794 37,607 50% QTR 3 2023 THE CITY OF KALISPELL, MONTANA05.03.2023 12:59 gb8501_pg.php/Job No: 3302 Page 8 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2023 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING POLICE DEPARTMENT 1000-413-420140-110 SALARIES-POLICE 1,882,567 2,807,937 925,370 33% 1000-413-420140-112 SALARIES-SEVERANCE 17,780 50,000 32,220 64% 1000-413-420140-114 SALARY -comptime buyout 8,753 10,050 1,297 13% 1000-413-420140-121 OVERTIME (REG & AET OT) 62,929 80,000 17,071 21% 1000-413-420140-123 SPECIAL ASSIGN OVERTIME/SRT-MCU 17,854 35,000 17,146 49% 1000-413-420140-153 HEALTH INSURANCE 314,070 521,963 207,893 40% 1000-413-420140-155 RETIREMENT 242,106 369,130 127,024 34% 1000-413-420140-210 OFFICE SUPPLIES 1,463 4,500 3,037 67% 1000-413-420140-215 COMPUTER SUPPLIES/EQUIP./MAINT. 4,781 5,560 779 14% 1000-413-420140-218 EQUIPMENT (NON CAPITAL) 29,816 36,000 6,184 17% 1000-413-420140-220 INVESTIGATIVE SUPPLIES 2,642 5,500 2,858 52% 1000-413-420140-221 SAFETY EQUIP & SUPPLIES 11,743 13,000 1,257 10% 1000-413-420140-225 MAJOR CASE UNIT SUPPLIES 202 3,400 3,198 94% 1000-413-420140-226 SRT SUPPORT/SUPPLIES 4,964 8,600 3,636 42% 1000-413-420140-227 AMMO & RELATED SUPPLIES 46,376 50,900 4,524 9% 1000-413-420140-228 PATROL CAR SUPPLIES 5,410 8,000 2,590 32% 1000-413-420140-229 OTHER SUPPLIES 4,744 13,000 8,256 64% 1000-413-420140-230 CRIME PREVENTION SUPPLIES 0 1,000 1,000 100% 1000-413-420140-231 GAS 51,812 85,000 33,188 39% 1000-413-420140-234 CRISIS NEGOTIATIONS 168 500 332 66% 1000-413-420140-237 RESERVE PROGRAM SUPPLIES 80 1,500 1,420 95% 1000-413-420140-320 PRINTING 2,090 4,500 2,410 54% 1000-413-420140-345 TELEPHONE & COMMUNICATION 15,238 23,000 7,762 34% 1000-413-420140-354 CONTRACT SERVICES 53,662 78,220 24,558 31% 1000-413-420140-357 FORENSIC ANALYSIS/PATHOLOGY 2,785 10,500 7,715 73% 1000-413-420140-358 SHELTER/ANIMAL:VET. TREATMENT 8,910 23,000 14,090 61% 1000-413-420140-363 OFFICE EQUIP MAINTENANCE 2,442 2,100 342- -16% 1000-413-420140-365 SOFTWARE-MAINT. & LISC. 21,744 58,000 36,256 63% 1000-413-420140-369 RADIO EQUIPMENT & MAINT. 2,082 6,000 3,918 65% 1000-413-420140-373 DUES & TRAINING 42,783 61,450 18,667 30% 1000-413-420140-375 REG. TRAINING/TESTING REIMB. 4,956 14,500 9,545 66% 1000-413-420140-380 TRAINING MATERIALS 4,000 4,000 0 0% 1000-413-420140-388 MEDICAL SERVICES 4,650 3,000 1,650- -55% 1000-413-420140-392 BOARDING/TREATING PRISONERS 1,278 3,255 1,977 61% 1000-413-420140-521 CENTRAL GARAGE TRANSFER 60,542 80,722 20,180 25% 1000-413-420140-530 RENT 6,300 8,400 2,100 25% ------------------------------------------------- SUBTOTAL O & M 2,943,722 4,491,187 1,547,465 34% TRANSFERS 1000-413-420140-827 TRANSFER TO 2916 DRUG GRANT 48,000 64,000 16,000 25% 1000-413-420140-829 TRANSFER TO 2919 BLOCK GRANT 4,500 6,000 1,500 25% ------------------------------------------------- TOTAL TRANSFERS 52,500 70,000 17,500 25% CAPITAL OUTLAY 1000-413-420140-944 VEHICLES 30,399 160,000 129,601 81% ------------------------------------------------- TOTAL CAPITAL OUTLAY 30,399 160,000 129,601 81% QTR 3 2023 THE CITY OF KALISPELL, MONTANA05.03.2023 12:59 gb8501_pg.php/Job No: 3302 Page 9 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2023 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING DETECTIVES 1000-413-420141-110 SALARIES-DETECTIVES 292,155 402,264 110,109 27% 1000-413-420141-121 DETECTIVE-OVERTIME 9,137 15,000 5,863 39% 1000-413-420141-123 OVERTIME (SAFE NEIGHBORHOOD TASK FO 2,151 8,000 5,849 73% 1000-413-420141-153 HEALTH INSURANCE 50,276 76,798 26,522 35% 1000-413-420141-155 DETECTIVE-RETIREMENT 39,058 53,903 14,845 28% ------------------------------------------------- TOTAL DETECTIVES 392,776 555,965 163,189 29% RECORDS 1000-413-420142-110 SALARIES-RECORDS DIVISION 119,925 179,369 59,444 33% 1000-413-420142-121 OVERTIME 2,244 6,500 4,256 65% 1000-413-420142-153 HEALTH INSURANCE 28,718 46,394 17,676 38% 1000-413-420142-155 RETIREMENT 10,105 14,683 4,578 31% ------------------------------------------------- TOTAL RECORDS 160,992 246,946 85,954 35% RESOURCE OFFICERS 1000-413-420144-110 SALARIES-SRO 192,305 295,851 103,546 35% 1000-413-420144-153 HEALTH INSURANCE 29,125 59,540 30,415 51% 1000-413-420144-155 SRO RETIREMENT 24,807 39,733 14,926 38% ------------------------------------------------- TOTAL RESOURCE OFFICERS 246,237 395,124 148,887 38% ANIMAL CONTROL 1000-413-420145-110 ANIMAL CONTROL-SALARIES 23,448 53,717 30,269 56% 1000-413-420145-121 OVERTIME 0 500 500 100% 1000-413-420145-153 HEALTH INSURANCE 4,332 9,235 4,903 53% 1000-413-420145-155 RETIREMENT 1,922 4,234 2,312 55% ------------------------------------------------- SUBTOTAL ANIMAL CONTROL 29,702 67,686 37,984 56% PARKING 1000-413-420147-110 PARKINGS -SALARIES 70,086 97,881 27,795 28% 1000-413-420147-153 HEALTH INSURANCE 21,191 31,949 10,758 34% 1000-413-420147-155 RETIREMENT 5,748 7,930 2,182 28% 1000-413-420147-210 SUPPLIES-OFFICE/FUEL/OTHER 1,982 3,000 1,018 34% 1000-413-420147-354 CONTRACTED SERVICES 1,783 3,000 1,217 41% 1000-413-420147-362 LOT MAINT 3,356 10,000 6,645 66% 1000-413-420147-365 SNOW REMOVAL -Parking Lots 23,820 17,500 6,320- -36% 1000-413-420147-550 LOT LEASE PAYMENTS 802 1,500 698 47% ------------------------------------------------- SUBTOTAL PARKING 128,769 172,760 43,992 25% ------------------------------------------------- SUBTOTAL POLICE DEPT. 3,985,097 6,159,668 2,174,571 35% QTR 3 2023 THE CITY OF KALISPELL, MONTANA05.03.2023 12:59 gb8501_pg.php/Job No: 3302 Page 10 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2023 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING FIRE DEPARTMENT 1000-416-420400-110 SALARIES-FIRE SUPPRESSION 1,706,707 2,366,445 659,738 28% 1000-416-420400-112 SALARY-SEVERANCE 0 15,000 15,000 100% 1000-416-420400-114 COMPTIME BUYOUT 4,555 5,500 945 17% 1000-416-420400-115 OUT OF RANK PAY 8,733 12,500 3,767 30% 1000-416-420400-121 OVERTIME 83,511 60,000 23,511- -39% 1000-416-420400-153 HEALTH INSURANCE 280,394 406,835 126,441 31% 1000-416-420400-155 RETIREMENT 224,194 331,503 107,309 32% 1000-416-420400-210 OFFICE/COMPUTER SUPPLIES 2,547 5,180 2,633 51% 1000-416-420400-218 EQUIPMENT (Non Capital) 12,059 22,500 10,441 46% 1000-416-420400-221 SAFETY EQUIP & SUPPLIES 10,803 95,000 84,197 89% 1000-416-420400-224 JANITORIAL SUPPLIES 3,821 5,575 1,754 31% 1000-416-420400-231 GAS 17,018 20,800 3,783 18% 1000-416-420400-241 CONSUMABLE TOOLS/UNIFORMS 13,993 17,325 3,332 19% 1000-416-420400-320 PRINTING 0 200 200 100% 1000-416-420400-322 SUBSCRIPTIONS/PUBLICATIONS/MATERIAL 279 1,250 971 78% 1000-416-420400-345 TELEPHONE & COMMUNICATION 2,636 5,500 2,864 52% 1000-416-420400-354 CONTRACT SERVICES 37,529 68,250 30,721 45% 1000-416-420400-362 EQUIPMENT MAINTENANCE 4,758 6,500 1,742 27% 1000-416-420400-366 BUILDING MAINTENANCE-STATION 62 23,655 26,000 2,345 9% 1000-416-420400-369 RADIO EQUIPMENT & MAINT. 2,407 5,000 2,593 52% 1000-416-420400-373 DUES & TRAINING 13,626 20,000 6,374 32% 1000-416-420400-388 FIREFIGHTER PHYSICALS 9,038 31,000 21,962 71% 1000-416-420400-521 CENTRAL GARAGE TRANSFER 14,194 18,926 4,732 25% ------------------------------------------------- TOTAL O & M 2,476,456 3,546,789 1,070,333 30% DEBT SERVICE 1000-416-420400-610 DEBT RETIREMENT-FIRE TRUCK 47,106 65,921 18,815 29% 1000-416-420400-620 INTEREST EXPENSE-FIRE TRUCK 4,338 10,665 6,327 59% ------------------------------------------------- TOTAL DEBT SERVICE 51,444 76,586 25,142 33% TRANSFERS 1000-416-420400-820 TRANSFER TO AMBULANCE FUND 667,500 890,000 222,500 25% 1000-416-420400-821 TFR - 2956 AFG ($5,300) 0 5,300 5,300 100% ------------------------------------------------- TOTAL TRANSFERS 667,500 895,300 227,800 25% CAPITAL OUTLAY 1000-416-420400-940 CAPITAL EQUIPMENT-VEHICLE/SCBA/SERV 5,167 34,304 29,137 85% ------------------------------------------------- TOTAL CAPITAL OUTLAY 5,167 34,304 29,137 85% QTR 3 2023 THE CITY OF KALISPELL, MONTANA05.03.2023 12:59 gb8501_pg.php/Job No: 3302 Page 11 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2023 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING PREVENTION 1000-416-420440-110 SALARIES-FIRE PREVENTION 17,360 25,679 8,320 32% 1000-416-420440-121 OVERTIME 622 0 622- 0% 1000-416-420440-153 HEALTH INSURANCE 3,632 5,476 1,844 34% 1000-416-420440-155 RETIREMENT 1,477 1,942 465 24% ------------------------------------------------- TOTAL PREVENTION 23,091 33,097 10,006 30% ------------------------------------------------- TOTAL FIRE DEPARTMENT 3,223,659 4,586,076 1,362,417 30% ------------------------------------------------- QTR 3 2023 THE CITY OF KALISPELL, MONTANA05.03.2023 12:59 gb8501_pg.php/Job No: 3302 Page 12 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2023 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING GRAND TOTAL GENERAL FUND 10,008,569 14,646,351 4,637,782 32% ================================================= QTR 3 2023 THE CITY OF KALISPELL, MONTANA05.03.2023 12:59 gb8501_pg.php/Job No: 3302 Page 13 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2023 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING INFORMATION TECHNOLOGY REVENUE 6030-000-335230-000 ENTITLEMENT SHARE PMT/HB124 277,500 370,000 92,500 25% 6030-000-341025-000 MISC REVENUE 185 0 185- 0% 6030-000-341027-000 CHARTER COMMUNICATION/FRANCISE FEES 97,260 210,000 112,740 54% 6030-000-371010-000 INVESTMENT EARNINGS 10,950 1,100 9,850- -895% 6030-000-393000-000 INTERNAL SERVICES-DATA 471,845 628,947 157,102 25% ------------------------------------------------- TOTAL REVENUE 857,740 1,210,047 352,307 29% ================================================= EXPENSES 6030-401-410580-110 SALARIES 283,125 458,353 175,228 38% 6030-401-410580-112 SALARIES - RETIREMENT 0 12,500 12,500 100% 6030-401-410580-121 OVERTIME 760 1,000 240 24% 6030-401-410580-153 HEALTH INSURANCE 51,419 91,042 39,623 44% 6030-401-410580-155 RETIREMENT 23,551 37,669 14,118 37% 6030-401-410588-218 COMPUTERS - ADMINISTRATIVE DEPTS 2,309 8,021 5,712 71% 6030-403-410580-215 COMPUTER SUPPLIES 2,019 5,280 3,261 62% 6030-403-410580-218 EQUIPMENT-NOT CAPITAL 16,142 30,472 14,330 47% 6030-403-410580-325 WEBSITE 9,017 9,000 17- -0% 6030-403-410580-345 PAGER/PHONE 0 2,800 2,800 100% 6030-403-410580-346 SUMMITNET & ISPS 4,173 8,716 4,543 52% 6030-403-410580-353 LASER FICHE MAINTENANCE 679 20,000 19,321 97% 6030-403-410580-354 MAINTENANCE CONTRACTS 30,914 60,000 29,086 48% 6030-403-410580-355 LICENSES 9,377 23,696 14,319 60% 6030-403-410580-356 MAINTENANCE CONTRACTS 101,703 187,794 86,091 46% 6030-403-410580-357 GRANICUS 7,800 7,200 600- -8% 6030-403-410580-358 MICROSOFT EXCHANGE EMAIL HOSTING 58,480 67,424 8,944 13% 6030-403-410580-359 PRIVATE FIBER - CITY NETWORK 11,133 23,616 12,483 53% 6030-403-410580-360 MULTI-FACTOR AUTHENTICATION 9,792 1,500 8,292- -553% 6030-403-410580-373 DUES & TRAINING 6,078 20,465 14,387 70% 6030-403-410580-510 INSURANCE 8,221 8,221 0 0% 6030-403-410580-660 LEASE INTEREST EXPENSE 55 0 55- 0% 6030-403-410580-835 LEASE AMORTIZATION EXPENSE 655 0 655- 0% 6030-403-410583-218 TV-Video Equipment & programming 44,070 105,269 61,199 58% 6030-403-410585-229 COPIER,FAX, SUPPLIES 9,072 17,365 8,293 48% 6030-403-410585-345 TELEPHONE & COMMUNICATIONS 65,247 200,045 134,798 67% 6030-403-410585-532 COPIER LEASES 0 14,578 14,578 100% 6030-403-410585-942 Servers - capital contingency 8,401 54,000 45,599 84% 6030-403-510400-831 DEPRECIATION EXPENSE 0 50,000 50,000 100% 6030-404-410588-218 COMPUTERS - ATTORNEYS 609 1,450 841 58% 6030-405-410588-940 COMPUTERS - SWITCHES 44,725 120,000 75,275 63% 6030-410-410588-218 COMPUTERS - DPW 6,816 7,295 479 7% 6030-413-410588-218 COMPUTERS - POLICE DEPT 10,657 23,034 12,377 54% 6030-413-410588-354 POLICE - HOSTED SERVER 2,008 0 2,008- 0% 6030-416-410588-218 COMPUTERS - FIRE 7,761 9,262 1,501 16% 6030-420-410588-218 COMPUTERS - PLANNING DEPT 457 750 293 39% 6030-436-410588-218 COMPUTERS - PARKS 3,581 4,050 469 12% 6030-480-410588-218 COMMUNITY DEVELOPMENT 319 0 319- 0% ------------------------------------------------- TOTAL EXPENSE 841,125 1,691,867 850,742 50% ================================================= QTR 3 2023 THE CITY OF KALISPELL, MONTANA05.03.2023 12:59 gb8501_pg.php/Job No: 3302 Page 14 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2023 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING PUBLIC SAFETY - EMERGENCY SERV AMBULANCE FUND REVENUE 2230-000-342050-000 FEES FOR SERVICES 319,345 600,000 280,655 47% 2230-000-342070-000 COUNTY EMS LEVY 82,611 140,000 57,389 41% 2230-000-365000-000 DONATIONS/SALE OF EQUIP/MISC 134 0 134- 0% 2230-000-383010-000 TRANSFER FROM GENERAL FUND 667,500 890,000 222,500 25% ------------------------------------------------- TOTAL REVENUE 1,069,590 1,630,000 560,410 34% ================================================= EXPENSE 2230-440-420730-110 SALARIES 520,010 715,828 195,818 27% 2230-440-420730-113 KELLY DAYS 40 0 40- 0% 2230-440-420730-114 COMPTIME BUYBACK 0 3,500 3,500 100% 2230-440-420730-115 OUT OF RANK PAY 0 3,300 3,300 100% 2230-440-420730-121 OVERTIME 40,359 30,000 10,359- -35% 2230-440-420730-153 HEALTH INSURANCE 90,170 135,494 45,324 33% 2230-440-420730-155 RETIREMENT 66,782 93,027 26,245 28% 2230-440-420730-210 OFFICE/COMPUTER SUPPLIES 376 3,400 3,024 89% 2230-440-420730-218 NON-CAPITAL EQUIPMENT 2,928 4,500 1,572 35% 2230-440-420730-231 GAS & OIL 9,099 9,500 401 4% 2230-440-420730-241 CONSUMABLE TOOLS/UNIFORMS 4,297 4,500 203 5% 2230-440-420730-312 POSTAGE/PRINTING 178 1,000 822 82% 2230-440-420730-345 TELEPHONE & COMMUNICATION 682 2,000 1,318 66% 2230-440-420730-354 CONTRACT SERVICES 6,020 21,500 15,480 72% 2230-440-420730-359 COLLECTION SERV. / CC FEES / AUDIT 3,826 5,000 1,174 23% 2230-440-420730-362 EQUIPMENT/RADIO MAINTENANCE 942 5,000 4,058 81% 2230-440-420730-373 DUES & TRAINING 589 16,500 15,911 96% 2230-440-420730-388 EXP. TESTING/IMMUNIZATION 0 2,000 2,000 100% 2230-440-420730-391 MEDICAL TREATMENT-SUPPLIES 32,136 60,000 27,864 46% 2230-440-420730-510 PROPERTY & LIABILITY INSURANCE 14,855 14,855 0- 0% 2230-440-420730-521 CENTRAL GARAGE TRANSFER 11,651 15,535 3,884 25% 2230-440-420730-522 ADMINISTRATIVE TRANSFER 36,492 48,656 12,164 25% 2230-440-420730-528 INFORMATION TECHNOLOGY TRANSFER 29,014 38,686 9,672 25% 2230-440-420730-610 PRINCIPAL - AMBULANCE 36,947 36,947 0- 0% 2230-440-420730-620 INTEREST - AMBULANCE 2,156 2,372 216 9% 2230-440-420730-940 EQUIPMENT 264,599 370,000 105,401 28% ------------------------------------------------- TOTAL EXPENDITURES 1,174,150 1,643,100 468,950 29% ================================================= 2230 AMBULANCE CASH 2230-000-010100-000 CASH, AMBULANCE 77,695- 0 77,695 0% ------------------------------------------------- AMBULANCE CASH BALANCE 77,695- 0 77,695 0% ================================================= QTR 3 2023 THE CITY OF KALISPELL, MONTANA05.03.2023 12:59 gb8501_pg.php/Job No: 3302 Page 15 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2023 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2995 SAFER GRANT ------------------------------------------------- TOTAL SAFER REVENUE 0 0 0 0% ================================================= ------------------------------------------------- TOTAL SAFER EXP 0 0 0 0% ================================================= 2956 FIRE GRANTS 2956-416-420400-221 SAFETY EQUIP (ROUNDUP FOR SAFETY) 1,816 5,000 3,184 64% 2956-416-420415-940 AFG GRT FY22 RADIO 0 58,300 58,300 100% ------------------------------------------------- 2956 TOTAL FIRE GRANTS 1,816 63,300 61,484 97% ================================================= 2957 HAZMAT GRANT 2957-416-420400-221 DoMA EQUIP (REIMB) 174 0 174- 0% 2957-416-420410-125 PASS THRU HAZMAT OT 3,179 5,000 1,821 36% 2957-416-420410-218 PASS THRU HAZMAT EQUIP 320 10,000 9,680 97% 2957-416-420410-373 PASS THRU HAZMAT TRAVEL 278 3,000 2,722 91% ------------------------------------------------- TOTAL HAZMA GRANT EXPENDITURES 3,951 18,000 14,049 78% ================================================= 2958 HAZMAT TEAM SUSTAINMENT G 2958-416-420455-240 OTHER SUPPLIES AND EQUIPMENT 16,167 37,381 21,214 57% ------------------------------------------------- TOTAL HAZMAT TEAM SUSTAINMENT 16,167 37,381 21,214 57% ================================================= QTR 3 2023 THE CITY OF KALISPELL, MONTANA05.03.2023 12:59 gb8501_pg.php/Job No: 3302 Page 16 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2023 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING PUBLIC SAFETY - LAW ENFORCEMEN 2915 STONGARDEN GRANT 2915-413-420140-121 OT&FRINGES/KPD 2,655 10,000 7,345 73% 2915-413-420140-218 SMALL EQUIP -Stonegarden 0 30,000 30,000 100% ------------------------------------------------- TOTAL STONEGARDEN GRANT 2,655 40,000 37,345 93% ================================================= 2916 DRUG ENFORCEMENT GRANT 2916-413-420140-110 SALARIES - DRUG ENFORCEMENT GRANT 35,837 70,949 35,112 49% 2916-413-420140-121 OVERTIME 13,718 13,000 718- -6% 2916-413-420140-153 HEALTH INSURANCE 12,112 13,312 1,200 9% 2916-413-420140-155 RETIREMENT 6,202 9,523 3,321 35% ------------------------------------------------- TOTAL DRUG ENFORCEMENT GRANT 67,869 106,784 38,915 36% ================================================= 2918 COPS HIRING RECOVERY PROG ------------------------------------------------- TOTAL COPS HIRING RECOVERY GRA 0 0 0 0% ================================================= 2919 LAW ENFORCEMENT GRANT 2919-413-420140-110 SALARIES - BENEFITS 968 3,000 2,032 68% 2919-413-420140-121 OVERTIME - DISPATCH 555 0 555- 0% 2919-413-420140-126 HOLIDAY OT REIMB (STEP GRT) 5,534 35,000 29,466 84% 2919-413-420140-127 SCHOOL DIST. OT 12,943 17,000 4,057 24% 2919-413-420140-218 JAG GRT/BODY ARMOR & BODY WORN CAME 6,381 13,500 7,119 53% 2919-413-420140-219 EQUIPMENT FROM WALMART COMMUNITY GR 0 5,000 5,000 100% 2919-413-420140-220 EQUIPMENT-FUNDED BY DONATIONS 140 4,000 3,860 97% 2919-413-420140-221 BULLET PROOF VESTS & HSPG GRT VESTS 0 6,000 6,000 100% 2919-413-420140-373 TRAINING - FORFEITURE FUNDS 0 9,946 9,946 100% ------------------------------------------------- TOTAL LAW ENFORCEMENT GRANTS 26,521 93,446 66,925 72% ================================================= 4170 IMPOUND/STORAGE FACILITY 4170-400-411230-925 IMPOUND STORAGE FACILITY 0 430,000 430,000 100% ------------------------------------------------- TOTAL IMPOUND STORAGE FACILITY 0 430,000 430,000 100% ================================================= 2399 IMPACT FEE FUND 2399-400-420100-522 ADMIN CHARGE - IMPACT FEES 5% 11,250 15,000 3,750 25% 2399-413-420140-610 PRINCIPAL - IMPOUND/STORAGE 0 28,500 28,500 100% 2399-413-420140-620 INTEREST - IMPOUND/STORAGE 0 6,500 6,500 100% 2399-413-420140-920 IMPOUND/STORAGE FACILITY 0 75,000 75,000 100% 2399-416-420400-940 FIRE DEPT. EQUIPMENT 0 1,700,000 1,700,000 100% ------------------------------------------------- TOTAL PUBLIC SAFETY IMPACT FEE 11,250 1,825,000 1,813,750 99% ================================================= QTR 3 2023 THE CITY OF KALISPELL, MONTANA05.03.2023 12:59 gb8501_pg.php/Job No: 3302 Page 17 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2023 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING PUBLIC WORKS 2500 SPECIAL STREET MAINT. 2500-421-430240-110 SALARIES-SPEC.STREET MAINT. 613,338 976,681 363,343 37% 2500-421-430240-121 OVERTIME 13,429 28,000 14,571 52% 2500-421-430240-153 HEALTH INSURANCE 103,878 204,005 100,127 49% 2500-421-430240-155 RETIREMENT 50,094 77,516 27,422 35% 2500-421-430240-210 COMPUTER EQUIP./SUPPLIES 14,375 26,500 12,125 46% 2500-421-430240-218 SAFETY/OTHER EQUIP. & SUPPLIES 8,731 14,000 5,269 38% 2500-421-430240-220 OTHER SUPPLIES 2,018 4,600 2,582 56% 2500-421-430240-231 GAS & OIL 43,924 51,000 7,076 14% 2500-421-430240-341 ELECTRICITY 2,455 3,600 1,145 32% 2500-421-430240-345 TELEPHONE/COMMUNICATIONS 2,775 4,330 1,555 36% 2500-421-430240-353 AUDITING 0 1,600 1,600 100% 2500-421-430240-354 CONTRACT SERVICES 4,929 25,000 20,071 80% 2500-421-430240-356 CONSULTANT REVIEWS 11,463 30,000 18,537 62% 2500-421-430240-362 EQUIP. MAINT./SUPPLIES 33,294 43,000 9,706 23% 2500-421-430240-366 BUILDING MAINTENANCE 4,956 5,000 44 1% 2500-421-430240-373 DUES & TRAINING 3,129 14,000 10,871 78% 2500-421-430240-388 MEDICAL SERVICES 490 1,000 510 51% 2500-421-430240-510 LIABILITY INSURANCE 51,088 51,088 0- 0% 2500-421-430240-512 UNINSURED LOSS-DEDUCTIBLE 0 45,000 45,000 100% 2500-421-430240-521 CENTRAL GARAGE TRANSFER 128,578 171,438 42,860 25% 2500-421-430240-522 ADMINISTRATIVE TRANSFER 85,109 113,478 28,369 25% 2500-421-430240-528 INFORMATION TECHNOLOGY TRANSFER 31,484 41,978 10,494 25% 2500-421-430240-610 DEBT SERVICE - PRINCIPAL 0 25,000 25,000 100% 2500-421-430240-620 DEBT SERVICE - INTEREST 718 1,938 1,220 63% 2500-421-430240-840 MACI GRANT MATCH - WTR/DE-ICER TRK 0 19,500 19,500 100% 2500-421-430241-610 PRINCIPAL-2017 4TH AVE E PROJECT 13,633 27,266 13,633 50% 2500-421-430241-620 INTEREST-2017 4TH AVE E PROJECT 6,129 12,088 5,959 49% 2500-421-430244-354 PAVEMENT REPAIRS-PAVEMENT MNT FUNDS 169,381 512,399 343,018 67% 2500-421-430244-820 TRANSFER TO BaRSAA 0 30,000 30,000 100% 2500-421-430245-940 MACHINERY/EQUIP (replacement funds) 364,443 501,023 136,580 27% 2500-421-430248-354 SIDEWALK REPAIR/MAINT. $ 0 15,652 15,652 100% ------------------------------------------------- TOTAL STREET MAINT 1,763,842 3,077,680 1,313,838 43% ------------------------------------------------- TSS 2500-421-430264-110 TSS - SALARIES 78,585 115,226 36,641 32% 2500-421-430264-121 OVERTIME 0 7,500 7,500 100% 2500-421-430264-153 HEALTH INSURANCE 17,923 36,516 18,593 51% 2500-421-430264-155 RETIREMENT 6,241 9,080 2,839 31% 2500-421-430264-210 COMPUTER EQUIP. & SUPPLIES 1,838 5,960 4,122 69% 2500-421-430264-218 SAFETY/OTHER EQUIP. & SUPPLIES 3,338 8,000 4,662 58% 2500-421-430264-220 JANITORIAL/OTHER SUPPLIES/TOOLS 1,030 4,500 3,470 77% 2500-421-430264-242 STREET SIGNS 9,881 30,000 20,119 67% 2500-421-430264-243 TRAFFIC SIGNALS 542 50,459 49,917 99% 2500-421-430264-245 BARRICADE MATERIALS 0 6,000 6,000 100% 2500-421-430264-341 ELECTRICITY 1,219 3,000 1,781 59% 2500-421-430264-345 COMMUNICATIONS 736 1,350 614 45% 2500-421-430264-354 CONTRACT SERVICES 1,428 10,000 8,572 86% 2500-421-430264-362 EQUIPMENT MAINTENANCE 160 3,000 2,840 95% 2500-421-430264-366 BUILDING MAINTENANCE 1,293 5,000 3,707 74% 2500-421-430264-373 DUES & TRAINING 4,114 7,500 3,386 45% QTR 3 2023 THE CITY OF KALISPELL, MONTANA05.03.2023 12:59 gb8501_pg.php/Job No: 3302 Page 18 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2023 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2500-421-430264-428 PAINT MATERIALS 8 5,000 4,992 100% 2500-421-430264-510 LIABILITY INS.-TSS 3,783 3,783 0 0% 2500-421-430264-512 UNINSURED LOSS-DEDUCTIBLE 0 1,000 1,000 100% 2500-421-430264-521 CENTRAL GARAGE TRANSFER 3,389 4,519 1,130 25% 2500-421-430264-940 MACHINERY & EQUIPMENT 10,500 10,500 0 0% ------------------------------------------------- TOTAL TSS 146,009 327,893 181,884 55% ------------------------------------------------- TOTAL SPECIAL STREET 1,909,851 3,405,573 1,495,722 44% ================================================= 2420 GAS TAX 2420-421-430234-956 SIDEWALK & CURB CONSTRUCTION 27,669 90,740 63,071 70% 2420-421-430234-957 ALLEY PAVING 17,683 51,223 33,540 65% 2420-421-430240-231 GAS & OIL 42,929 51,000 8,071 16% 2420-421-430240-344 NATURAL GAS 3,387 5,000 1,613 32% 2420-421-430240-354 CONTRACT SERVICES - STRIPING 0 20,000 20,000 100% 2420-421-430240-360 REPAIR & MAINT SERVICES 0 1,500 1,500 100% 2420-421-430240-368 OVERLAY/CHIPSEALS 148,275 611,354 463,079 76% 2420-421-430240-452 GRAVEL 1,148 6,000 4,852 81% 2420-421-430240-453 EQUIPMENT RENTAL 0 7,500 7,500 100% 2420-421-430240-471 DE-ICER/ROAD OIL 44,782 78,000 33,218 43% 2420-421-430240-472 ASPHALT 9,887 50,000 40,113 80% 2420-421-430240-473 CRACK SEALING 0 20,000 20,000 100% 2420-421-430240-474 PAINT STRIPING MATERIALS 13,514 30,000 16,486 55% ------------------------------------------------- TOTAL GAS TAX 309,275 1,022,317 713,042 70% ================================================= BARSAA 2421-421-430240-354 PAVEMENT MAINTENANCE 0 542,685 542,685 100% ------------------------------------------------- TOTAL BARSAA 0 542,685 542,685 100% ================================================= 2400 LIGHT MAINT. 2400-410-430263-110 SALARIES 63,451 92,131 28,680 31% 2400-410-430263-153 HEALTH INSURANCE 11,580 14,670 3,090 21% 2400-410-430263-155 RETIREMENT 5,097 7,367 2,270 31% 2400-410-430263-244 STREET LIGHT SUPPLIES 758 18,000 17,242 96% 2400-410-430263-245 LUMINAIRES 0 31,000 31,000 100% 2400-410-430263-341 ELECTRICITY 110,047 182,000 71,953 40% 2400-410-430263-360 REPAIR & MAINT SERVICES 12,244 22,500 10,256 46% 2400-410-430263-373 DUES & TRAINING 0 4,000 4,000 100% 2400-410-430263-510 INSURANCE 2,245 2,245 0- -0% 2400-410-430263-522 ADMINISTRATIVE TRANSFER 10,488 13,984 3,496 25% 2400-410-430263-528 INFORMATION TECH TRANSFER 16,708 22,277 5,569 25% 2400-410-430265-944 MACHINERY & EQUIP (replacement fund 0 70,000 70,000 100% ------------------------------------------------- TOTAL LIGHT MAINT. 232,619 480,174 247,555 52% ================================================= 2825 MACI GRANT-SWEEPER 2825-421-430240-940 EQUIPMENT 0 292,481 292,481 100% ------------------------------------------------- TOTAL MACI GRANT 0 292,481 292,481 100% ================================================= QTR 3 2023 THE CITY OF KALISPELL, MONTANA05.03.2023 12:59 gb8501_pg.php/Job No: 3302 Page 19 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2023 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5210 WATER FUND REVENUE 5210-000-323108-000 PW PLAN REVIEW FEES 11,313 2,000 9,313- -466% 5210-000-343210-000 METERED WATER SALES 3,804,577 4,300,000 495,423 12% 5210-000-343220-000 OTHER (CONST.) WATER SALES 40,605 25,000 15,605- -62% 5210-000-343230-000 METER REPLACEMENT FEE 164,919 160,000 4,919- -3% 5210-000-343260-000 INSTALL/SALE OF MAT./TOWER RENT/OTH 18,947 71,000 52,053 73% 5210-000-343270-000 WATER TURN ON FEES 3,690 4,000 310 8% 5210-000-343275-000 TAG FEE 25,520 33,000 7,480 23% 5210-000-343365-000 LATECOMER ADMIN FEE 6,059 10,000 3,941 39% 5210-000-365016-000 INSURANCE REIMBURSEMENTS 19,048 0 19,048- 0% 5210-000-371010-000 INVESTMENT EARNINGS 249,554 45,000 204,554- -455% 5210-000-371500-000 LEASE INTEREST INCOME 52,662 0 52,662- 0% 5210-000-383010-000 TRANSFER FROM IMPACT FEE FUND (ADMI 26,250 30,000 3,750 13% 5210-000-383015-000 DEBT SERVICE TRANSFER FROM IMPACT F 187,500 250,000 62,500 25% ------------------------------------------------- TOTAL REVENUE 4,610,644 4,930,000 319,356 6% ================================================= EXPENSES WATER FACILITIES 5210-447-430550-110 SALARIES-WATER 573,931 873,444 299,513 34% 5210-447-430550-111 SEASONAL SALARIES 0 5,000 5,000 100% 5210-447-430550-121 OVERTIME 9,587 20,000 10,413 52% 5210-447-430550-153 HEALTH INSURANCE 105,047 193,108 88,061 46% 5210-447-430550-155 RETIREMENT 46,429 69,471 23,042 33% 5210-447-430550-210 OFFICE SUPPLIES /EQUIP/COMPUTERS/GI 11,298 24,500 13,202 54% 5210-447-430550-218 NON CAP & SAFETY EQUIP/SUPPLIES 2,067 9,000 6,933 77% 5210-447-430550-226 CHLORINE & CHEMICALS 58,514 70,000 11,486 16% 5210-447-430550-229 JANITORIAL/OTHER SUPPLIES 2,942 4,650 1,708 37% 5210-447-430550-231 GAS & OIL 23,674 35,000 11,326 32% 5210-447-430550-312 POSTAGE & PRINTING/ADVERTISING 18 1,000 982 98% 5210-447-430550-336 LICENSES & FEES 17,752 20,000 2,248 11% 5210-447-430550-341 ELECTRICITY 117,634 168,000 50,366 30% 5210-447-430550-344 NATURAL GAS 8,650 15,500 6,850 44% 5210-447-430550-345 TELEPHONE & COMMUNICATION 7,817 14,500 6,683 46% 5210-447-430550-349 LAB SERVICES 11,745 20,000 8,255 41% 5210-447-430550-352 CONTRACT SERVICES - HOSTING FEES 9,159 27,000 17,841 66% 5210-447-430550-353 AUDITING 0 3,500 3,500 100% 5210-447-430550-354 CONTRACT SERVICES 12,701 56,000 43,299 77% 5210-447-430550-355 NOFFSINGER TRANSMISSION CONDITION A 51,333 140,872 89,539 64% 5210-447-430550-356 BACKBONE CONDITION ASSESS./WTR RIGH 3,540 75,000 71,460 95% 5210-447-430550-362 EQUIP REPAIRS/MAINT/RENTAL 4,256 15,000 10,744 72% 5210-447-430550-366 BUILDING MAINTENANCE 3,546 15,000 11,454 76% 5210-447-430550-373 DUES & TRAINING 1,581 14,000 12,419 89% 5210-447-430550-388 MEDICAL SERVICES 463 700 238 34% 5210-447-430550-410 CONSTRUCTION MATERIALS 22,589 50,000 27,411 55% 5210-447-430550-422 HYDRANTS 1,850 10,000 8,150 82% 5210-447-430550-423 MATERIALS FOR MAINS 10,319 11,000 681 6% 5210-447-430550-424 MATERIALS -SERVICE LINES 7,216 20,000 12,784 64% 5210-447-430550-425 MATERIALS PUMPS/WELLS 4,242 100,000 95,758 96% 5210-447-430550-510 PROPERTY & LIABILITY INS. 44,539 44,539 0- 0% 5210-447-430550-512 UNINSURED LOSS-DEDUCTIBLE 1,100 10,000 8,900 89% 5210-447-430550-521 CENTRAL GARAGE TRANSFER 33,844 45,125 11,281 25% QTR 3 2023 THE CITY OF KALISPELL, MONTANA05.03.2023 12:59 gb8501_pg.php/Job No: 3302 Page 20 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2023 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5210-447-430550-522 ADMINISTRATIVE TRANSFER 93,965 125,287 31,322 25% 5210-447-430550-528 INFORMATION TECH TRANSFER 56,888 75,851 18,963 25% 5210-447-430550-532 LEASE PAYMENTS 0 4,000 4,000 100% ------------------------------------------------- TOTAL OPERATING EXPENSES 1,360,238 2,386,047 1,025,809 43% ------------------------------------------------- CAPITAL FROM OPERATING/BONDS 5210-447-430550-925 NOFFSINGER REHAB ALTERNATIVE 177,500 2,124,968 1,947,468 92% 5210-447-430550-935 METER SYSTEM REPLACEMENT 218,617 532,906 314,289 59% 5210-447-430550-940 MACHINERY & EQUIPMENT 0 240,000 240,000 100% 5210-447-430550-951 SECURITY SCADA UPGRADES 566 25,000 24,434 98% 5210-447-430550-952 8TH AVE W R&R (ARPA WTR/SWR PRJ) 0 350,000 350,000 100% 5210-447-430550-954 ELEVATED STORAGE TANK & WELL 640,092 1,241,048 600,956 48% 5210-447-430550-958 2ND AVE W RR FROM CENTER TO 2ND ST 3,785 13,216 9,431 71% 5210-447-430550-967 WELL REPLC & UPSIZE 0 115,000 115,000 100% 5210-447-430550-969 DESIGN - LOWER ZONE RESERVOIRS ROOF 80,848 549,036 468,188 85% 5210-447-430550-970 DESIGN-NORTHWEST WELL #2 0 307,000 307,000 100% ------------------------------------------------- TOTAL CAPITAL FROM OP/BONDS 1,121,407 5,498,174 4,376,767 80% ------------------------------------------------- CAPITAL OUTLAY - BONDED 5210-447-430551-954 1 MG STORAGE TANK & WELLS (BONDED) 0 10,708,885 10,708,885 100% 5210-447-430551-969 LOWER ZONE RESERVOIRS ROOF REPLC (B 0 7,270,000 7,270,000 100% ------------------------------------------------- TOTAL CAPITAL BONDED 0 17,978,885 17,978,885 100% ------------------------------------------------- WATER BILLING 5210-447-430560-110 SALARIES-WATER BILLING 104,448 145,340 40,892 28% 5210-447-430560-153 HEALTH INSURANCE 16,836 32,937 16,101 49% 5210-447-430560-155 RETIREMENT 7,874 11,194 3,320 30% 5210-447-430560-210 OFFICE & COMPUTER SUPPLIES 5,066 11,500 6,434 56% 5210-447-430560-353 AUDITING 0 2,000 2,000 100% 5210-447-430560-354 GRIZZLY SEC./MAIL ROOM 31,898 55,000 23,102 42% 5210-447-430560-355 BANK & CC FEES/CENTURYLINK 29,907 35,000 5,093 15% 5210-447-430560-356 OTHER CONTRACT SERVICES 526 1,000 474 47% 5210-447-430560-373 DUES & TRAINING 690 4,000 3,310 83% 5210-447-430560-522 ADMINISTRATIVE TRANSFER 9,236 12,314 3,078 25% 5210-447-430560-528 INFORMATION TECH TRANSFER 50,775 67,700 16,925 25% ------------------------------------------------- TOTAL WATER BILLING 257,256 377,985 120,729 32% ------------------------------------------------- REVENUE BONDS/BOI LOANS 5210-447-490200-610 PRIN - 4 MILE DR TRANSMISSION / WRF 0 88,000 88,000 100% 5210-447-490200-620 INT - 4 MILE DR TRANSMISSION / WRF 47,625 47,625 0 0% 5210-447-490204-610 BOND PRIN-HWY 93 S WTR - 2004 0 83,000 83,000 100% 5210-447-490204-620 BOND INT-HWY 93 S WTR 2004 3,679 3,679 0 0% 5210-447-490204-630 BOND FEES-HWY 93 S WTR 2004 0 350 350 100% 5210-447-490206-610 PRIN-WELL/TANK/8114 2.25% 4TH ST 0 95,000 95,000 100% 5210-447-490206-620 INT-WELL&TANK/8114 2.25% 4TH ST WT 10,654 10,654 0 0% 5210-447-490210-610 4TH AVE E MAIN REPL/WRF 17393 0 87,545 87,545 100% 5210-447-490210-620 4TH AVE E MAIN REPL/WFR 17393 38,811 38,811 0- 0% ------------------------------------------------- TOTAL REVENUE BONDS 100,769 454,664 353,895 78% QTR 3 2023 THE CITY OF KALISPELL, MONTANA05.03.2023 12:59 gb8501_pg.php/Job No: 3302 Page 21 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2023 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ------------------------------------------------- DEPRECIATION 5210-447-510400-831 DEPRECIATION EXPENSE 0 950,000 950,000 100% ------------------------------------------------- TOTAL DEPRECIATION 0 950,000 950,000 100% ------------------------------------------------- TOTAL WATER FUND 2,839,670 27,645,755 24,806,085 90% ================================================= QTR 3 2023 THE CITY OF KALISPELL, MONTANA05.03.2023 12:59 gb8501_pg.php/Job No: 3302 Page 22 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2023 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING WATER IMPACT FEE REVENUE: 5211-000-343225-000 IMPACT FEES 213,629 700,000 486,371 69% 5211-000-371010-000 INTEREST EARNINGS 23,370 4,000 19,370- -484% ------------------------------------------------- TOTAL WATER IMPACT FEES REVENU 236,998 704,000 467,002 66% ================================================= WATER IMPACT FEES EXPENSES: 5211-447-430555-424 METERS - NEW DEVELOPMENT 52,871 65,000 12,129 19% 5211-447-430555-820 DEBT SERVICE TRANSFER TO 5210 187,500 250,000 62,500 25% 5211-447-430555-825 TRANSFER TO 5210 FOR ADMIN 26,250 35,000 8,750 25% 5211-447-430555-930 CONTRACT MAIN UPSIZE 52,661 766,055 713,394 93% 5211-447-430555-954 ELEVATED TANK & WELL 241,651 493,868 252,217 51% ------------------------------------------------- TOTAL IMPACT FEES 560,933 1,609,923 1,048,990 65% ================================================= QTR 3 2023 THE CITY OF KALISPELL, MONTANA05.03.2023 12:59 gb8501_pg.php/Job No: 3302 Page 23 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2023 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5310 SEWER FUND REVENUE 5310-000-323108-000 PW PLAN REVIEW FEES 11,313 1,500 9,813- -654% 5310-000-343310-000 SEWER SERVICE CHARGES 5,970,193 7,300,000 1,329,807 18% 5310-000-343360-000 INSTALLATION,SALE OF MAT./OTHER 7,710 1,500 6,210- -414% 5310-000-343365-000 LATECOMER ADMIN FEES 1,136 2,000 864 43% 5310-000-371010-000 INVESTMENT EARNINGS 226,926 31,000 195,926- -632% 5310-000-383010-000 ADMIN TRANSFER FROM IMPACT FEE FUND 75,000 100,000 25,000 25% 5310-000-383015-000 DEBT SERVICE TRANSFER FROM IMPACT F 862,500 1,150,000 287,500 25% ------------------------------------------------- TOTAL REVENUE 7,154,777 8,586,000 1,431,223 17% ================================================= SEWER BILLING COSTS 5310-454-430620-110 SALARIES-SEWER BILLING 92,391 125,965 33,575 27% 5310-454-430620-153 HEALTH INSURANCE 14,355 25,347 10,992 43% 5310-454-430620-155 RETIREMENT - PERD 6,875 9,569 2,694 28% 5310-454-430620-215 OFFICE SUPPLIES/computers 5,095 11,500 6,406 56% 5310-454-430620-353 AUDITING/OTHER CONTRACT SERVICES 0 2,000 2,000 100% 5310-454-430620-354 GRIZZLY SEC./MAIL ROOM 34,708 55,000 20,292 37% 5310-454-430620-355 BANK & CC FEES/CENTURYLINK 29,911 35,000 5,089 15% 5310-454-430620-356 OTHER CONTRACT SERVICES 526 1,000 474 47% 5310-454-430620-373 DUES & TRAINING 513 4,000 3,487 87% 5310-454-430620-522 ADMINISTRATIVE TRANSFER 8,393 11,191 2,798 25% 5310-454-430620-528 INFORMATION TECH. TRANSFER 50,775 67,700 16,925 25% ------------------------------------------------- TOTAL SEWER BILLING COSTS 243,543 348,272 104,729 30% ------------------------------------------------- SANITARY SEWER/COLLECTION 5310-454-430630-110 SALARIES-SANITARY SEWER 238,278 370,013 131,735 36% 5310-454-430630-121 OVERTIME 87 5,500 5,413 98% 5310-454-430630-153 HEALTH INSURANCE 39,853 74,895 35,042 47% 5310-454-430630-155 RETIREMENT 19,255 29,522 10,267 35% 5310-454-430630-210 OFFICE/COMPUTER SUPPLIES/EQUIP 8,145 15,800 7,655 48% 5310-454-430630-218 NON CAP/SAFETY EQUIP & SUPPLIES 6,367 8,500 2,133 25% 5310-454-430630-229 JANITORIAL/OTHER SUPPLIES 840 2,500 1,660 66% 5310-454-430630-231 GAS & OIL 10,019 14,500 4,481 31% 5310-454-430630-312 POSTAGE, PRINTING & ADVERTISING 117 500 383 77% 5310-454-430630-341 ELECTRICITY 34,359 57,000 22,641 40% 5310-454-430630-344 NATURAL GAS 10,184 16,500 6,316 38% 5310-454-430630-345 TELEPHONE & COMMUNICATION 12,937 27,500 14,563 53% 5310-454-430630-353 AUDITING 0 3,000 3,000 100% 5310-454-430630-354 CONTRACT SERVICES 8,804 45,000 36,196 80% 5310-454-430630-355 CONTRACT SERVICES - EVERGREEN MTR R 18,585 31,200 12,615 40% 5310-454-430630-356 CONSULTANTS - MODELING/REVIEWS 6,732 20,000 13,268 66% 5310-454-430630-362 BLDGS/EQUIPMENT MAINTENANCE 5,388 11,500 6,112 53% 5310-454-430630-373 DUES & TRAINING 1,284 10,250 8,966 87% 5310-454-430630-388 MEDICAL SERVICES 365 650 286 44% 5310-454-430630-410 CONSTRUCTION MATERIALS 3,470 12,000 8,530 71% 5310-454-430630-425 MATERIALS PUMPS/LIFT ST. 18,295 96,000 77,705 81% 5310-454-430630-510 PROPERTY & LIABILITY INS. 25,389 25,389 0 0% 5310-454-430630-512 UNINSURED LOSS-DEDUCTIBLE 2,736 25,000 22,264 89% 5310-454-430630-521 CENTRAL GARAGE TRANSFER 8,230 10,974 2,744 25% 5310-454-430630-522 ADMINISTRATIVE TRANSFER 55,540 74,053 18,513 25% 5310-454-430630-528 INFORMATION TECH TRANSFER 34,725 46,300 11,575 25% QTR 3 2023 THE CITY OF KALISPELL, MONTANA05.03.2023 12:59 gb8501_pg.php/Job No: 3302 Page 24 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2023 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5310-454-430630-532 OFFICE RENT / BNSF LEASE 7,096 7,000 96- -1% ------------------------------------------------- TOTAL COLLECTION OPERATING EX 577,079 1,041,046 463,967 45% ------------------------------------------------- CAPITAL FROM OPERATING/BONDS 5310-454-430630-922 L.S. #9 IMPROVEMENTS/DESIGN 708 217,168 216,460 100% 5310-454-430630-950 RR & UPSIZE - WWTP MAIN (34% - 66% 0 93,718 93,718 100% 5310-454-430630-951 5TH ALLEY E, 4TH AVE EN, 7TH AVE EN 1,750 750,000 748,250 100% 5310-454-430630-954 MN REPL. DESIGN - 1ST & 2ND AVE EN 617,867 1,200,961 583,094 49% 5310-454-430630-956 LIFT STATION COMMUNICATION UPGRADE 0 10,000 10,000 100% 5310-454-430630-958 DESIGN - L.S. #3 IMPROVEMENTS 106,559 464,094 357,535 77% 5310-454-430630-959 L.S. #10 CONTROL PANEL RELOCATION & 0 60,000 60,000 100% 5310-454-430630-960 MANHOLE REHAB/MAIN REPLACEMENT 8,118 50,000 41,882 84% ------------------------------------------------- TOTAL CAP. FROM OP/BONDS 735,002 2,845,941 2,110,939 74% ------------------------------------------------- CAPITAL FROM BONDS 5310-454-430631-922 L.S. #9 IMPROVMENTS 62,601 1,980,500 1,917,899 97% 5310-454-430631-958 L.S. #3 IMPROVEMENTS 0 3,020,000 3,020,000 100% ------------------------------------------------- TOTAL CAPITAL FROM BONDS 62,601 5,000,500 4,937,899 99% ------------------------------------------------- CAPITAL FROM EQUIP REPLACEMENT 5310-454-430635-940 MACHINERY & EQUIPMENT (10126) 0 7,200 7,200 100% ------------------------------------------------- TOTAL CAP. FROM EQUIP. REPLACE 0 7,200 7,200 100% ------------------------------------------------- REVENUE BONDS/SANITARY 5310-454-490200-610 PRINCIPAL WESTSIDE INTERCEPTOR BOND 0 302,000 302,000 100% 5310-454-490200-620 INTEREST-WESTSIDE INTERCEPTOR BOND 271,750 271,750 0 0% 5310-454-490204-610 PRINCIPAL - HWY 93 S/SRF5125/2.25% 0 92,000 92,000 100% 5310-454-490204-620 INT-HWY 93 S/SRF5125/2.25% 3,668 3,668 1 0% 5310-454-490206-610 PRINCIPAL LIFT STATION #9 BOND 0 80,000 80,000 100% 5310-454-490206-620 INTEREST LIFT STATION #9 BOND 0 50,921 50,921 100% ------------------------------------------------- TOTAL REVENUE BONDS 275,418 800,339 524,922 66% ------------------------------------------------- DEPRECIATION-SANITARY SEWER 5310-454-510400-831 DEPRECIATION EXPENSE 0 500,000 500,000 100% ------------------------------------------------- TOTAL DEPRECIATION-SANITARY 0 500,000 500,000 100% ------------------------------------------------- TOTAL SANITARY SEWER 1,893,642 10,543,298 8,649,656 82% ------------------------------------------------- WWTP OPERATING 5310-455-430640-110 SALARIES-WWTP 361,312 574,139 212,827 37% 5310-455-430640-111 SEASONAL SALARIES 0 5,000 5,000 100% 5310-455-430640-112 SALARIES-RETIREMENT 5,828 0 5,828- 0% 5310-455-430640-121 OVERTIME 18,073 22,500 4,427 20% 5310-455-430640-153 HEALTH INSURANCE 57,866 117,561 59,695 51% 5310-455-430640-155 RETIREMENT 30,895 45,581 14,686 32% 5310-455-430640-210 OFFICE/COMPUTER SUPPLIES/EQUIP 8,202 14,800 6,598 45% 5310-455-430640-218 SAFETY EQUIP & SUPPLIES 2,637 3,500 863 25% 5310-455-430640-225 ALUM 0 42,000 42,000 100% QTR 3 2023 THE CITY OF KALISPELL, MONTANA05.03.2023 12:59 gb8501_pg.php/Job No: 3302 Page 25 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2023 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5310-455-430640-226 CHLORINE & CHEMICALS 114,286 154,000 39,714 26% 5310-455-430640-229 JANITORIAL/OTHER SUPPLIES/RENTAL 5,660 8,000 2,340 29% 5310-455-430640-231 GAS & OIL 14,544 19,000 4,456 23% 5310-455-430640-312 POSTAGE, PRINTING & ADVERTISING 21 550 529 96% 5310-455-430640-336 LICENSES & FEES 11,542 16,000 4,459 28% 5310-455-430640-341 ELECTRICITY 125,507 195,000 69,493 36% 5310-455-430640-342 WATER 2,848 7,000 4,152 59% 5310-455-430640-344 NATURAL GAS 39,357 82,000 42,643 52% 5310-455-430640-345 TELEPHONE & COMMUNICATION 4,066 15,000 10,934 73% 5310-455-430640-353 AUDITING 0 2,500 2,500 100% 5310-455-430640-354 CONTRACT-GLACIER GOLD 75,932 135,000 59,068 44% 5310-455-430640-355 CONTRACT - LAND FILL & OTHER 46,055 57,500 11,445 20% 5310-455-430640-356 CONSULTANTS 33,496 220,000 186,504 85% 5310-455-430640-358 CONSULTANT- PERMIT/TMDL 12,356 100,000 87,644 88% 5310-455-430640-360 MISC. MAINT SERVICES 22,308 35,000 12,692 36% 5310-455-430640-366 BUILDING MAINTENANCE 15,794 40,000 24,206 61% 5310-455-430640-373 DUES & TRAINING 5,030 10,500 5,470 52% 5310-455-430640-388 MEDICAL SERVICES 397 500 103 21% 5310-455-430640-510 PROPERTY & LIABILITY INS. 78,833 78,833 0- 0% 5310-455-430640-521 CENTRAL GARAGE TRANSFER 13,549 18,065 4,516 25% 5310-455-430640-522 ADMINISTRATIVE TRANSFER 99,823 133,097 33,274 25% 5310-455-430640-528 INFORMATION TECH TRANSFER 36,268 48,357 12,089 25% ------------------------------------------------- TOTAL WWTP OPERATING EXPENSE 1,242,484 2,200,983 958,499 44% ------------------------------------------------- WWTP CAPITAL FM OPERATING/BOND 5310-455-430640-921 DESIGN-DOME FOR SECONDARY CLARIFIER 0 419,000 419,000 100% 5310-455-430640-922 CONSTRUCT NEW FERMENTER (rehab) 0 1,675,500 1,675,500 100% 5310-455-430640-930 BIOSOLIDS ALTERNATE DISPOSAL ENG 0 61,000 61,000 100% 5310-455-430640-933 NEW EQ BASIN 0 2,515,000 2,515,000 100% ------------------------------------------------- TOTAL WWTP CAP. FM OP/BOND 0 4,670,500 4,670,500 100% ------------------------------------------------- WWTP LAB 5310-455-430646-110 SALARIES-WWTP LAB 91,909 136,840 44,931 33% 5310-455-430646-121 OVERTIME 87 0 87- 0% 5310-455-430646-153 HEALTH INSURANCE 10,830 18,424 7,594 41% 5310-455-430646-155 RETIREMENT 7,437 10,792 3,355 31% 5310-455-430646-210 COMPUTER/OTHER SUPPLIES 3,680 7,000 3,320 47% 5310-455-430646-218 NON-CAPITAL EQUIPMENT 7,133 8,500 1,367 16% 5310-455-430646-222 LAB SUPPLIES 10,925 18,500 7,575 41% 5310-455-430646-349 LAB SERVICES 11,714 22,000 10,286 47% 5310-455-430646-350 PRETREATMENT SERVICE 4,448 15,000 10,552 70% 5310-455-430646-362 EQUIPMENT MAINTENANCE 9,841 10,000 159 2% 5310-455-430646-373 DUES & TRAINING 0 5,500 5,500 100% ------------------------------------------------- TOTAL WWTP LAB 158,005 252,556 94,551 37% ------------------------------------------------- WWTP REPLACE(10125) 5310-455-430645-362 EQUIPMENT MAINTENANCE 106,056 153,000 46,944 31% 5310-455-430645-922 DESIGN FERMENTER RECONSTRUCTION 20,581 263,689 243,108 92% 5310-455-430645-934 SECONDARY DIGESTER LID REPLC 22,728 20,000 2,728- -14% 5310-455-430645-940 MACHINERY & EQUIPMENT 7,945 123,800 115,855 94% 5310-455-430645-950 RR & UPSIZE - WWTP MAIN (34% - 66% 250 137,500 137,250 100% QTR 3 2023 THE CITY OF KALISPELL, MONTANA05.03.2023 12:59 gb8501_pg.php/Job No: 3302 Page 26 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2023 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ------------------------------------------------- TOTAL WWTP REPLACEMENT 157,561 697,989 540,428 77% ------------------------------------------------- REVENUE BONDS/WWTP 5310-455-490227-610 PRINCIPAL - WWTP IMP/SRF8164R/2.25% 0 910,000 910,000 100% 5310-455-490227-620 INT-WWTP IMP/SRF8164R/2.25% 102,060 102,060 0 0% 5310-455-490228-610 PRINC - WWTP DIGESTER LID/SRF 13326 0 53,000 53,000 100% 5310-455-490228-620 INT-WWTP DIGESTER LID/SRF13326/3.0% 19,980 19,980 0 0% ------------------------------------------------- TOTAL REVENUE BONDS/WWTP 122,040 1,085,040 963,000 89% ------------------------------------------------- DEPRECIATION 5310-455-510400-831 DEPR. EXP. - WWTP (INCLUDES 010125 0 1,300,000 1,300,000 100% ------------------------------------------------- TOTAL DEPRECIATION 0 1,300,000 1,300,000 100% ------------------------------------------------- TOTAL WWTP 1,680,090 10,207,068 8,526,978 84% ------------------------------------------------- TOTAL BILLING/SANITARY/WWTP 3,573,732 20,750,366 17,176,634 83% ================================================= QTR 3 2023 THE CITY OF KALISPELL, MONTANA05.03.2023 12:59 gb8501_pg.php/Job No: 3302 Page 27 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2023 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING SEWER IMPACT FEE REVENUE 5311-000-343330-000 SANITARY IMPACT FEES 524,213 1,000,000 475,787 48% 5311-000-343335-000 TREATMENT IMPACT FEES 375,007 588,000 212,993 36% 5311-000-371010-000 SANITARY INTEREST EARNINGS 73,537 11,000 62,537- -569% 5311-000-371015-000 TREATMENT INTEREST EARNINGS 54,157 9,500 44,657- -470% ------------------------------------------------- TOTAL SEWER IMPACT FEES REVENU 1,026,914 1,608,500 581,586 36% ================================================= COLLECTION IMP. FEE EXPENSES 5311-454-430635-820 TRANSFER TO 5310 FOR DEBT (SANITARY 375,000 500,000 125,000 25% 5311-454-430635-825 TRANSFER TO 5310 FOR ADMIN 48,750 65,000 16,250 25% ------------------------------------------------- TOTAL COLL. IMP. FEES TRANSFER 423,750 565,000 141,250 25% ------------------------------------------------- CAPITAL FROM COLL. IMP. FEES 5311-454-430635-950 RR & UPSIZE - WWTP MAIN (66% - 34% 0 231,922 231,922 100% 5311-454-430635-955 MAIN & L.S. UPSIZE 0 1,172,000 1,172,000 100% 5311-454-430635-958 DESIGN-L.S #3 IMPROVEMENTS 106,559 392,593 286,034 73% ------------------------------------------------- TOTAL CAP. FM COLL. IMP. FEES 106,559 1,796,515 1,689,956 94% ------------------------------------------------- TOTAL COLL. IMP. FEE EXPENSE 530,309 2,361,515 1,831,206 78% ------------------------------------------------- TREATMENT IMP. FEE EXPENSES 5311-455-430644-820 TRANSFER TO 5310 FOR DEBT 487,500 650,000 162,500 25% 5311-455-430644-825 TRANSFER TO 5310 FOR ADMIN 26,250 35,000 8,750 25% ------------------------------------------------- TOTAL TREATMT IMP. FEES TRANSF 513,750 685,000 171,250 25% ------------------------------------------------- CAPITAL FROM TREATMT IMP. FEES 5311-455-430644-929 CONSTRUCT NEW EQ BASIN 39,928 386,869 346,941 90% 5311-455-430644-930 BIOSOLIDS ALT. DISPOSAL ENG. (39%) 0 39,000 39,000 100% 5311-455-430644-950 RR & UPSIZE - WWTP MAIN (66% - 34% 752 317,500 316,748 100% ------------------------------------------------- TOTAL CAP FM TRTMNT IMP. FEES 40,680 743,369 702,689 95% ------------------------------------------------- TOTAL WWTP IMPACT FEES EXPENSE 554,430 1,428,369 873,939 61% ------------------------------------------------- TOTAL SEWER IMPACT FEE EXPENSE 1,084,739 3,789,884 2,705,145 71% ================================================= QTR 3 2023 THE CITY OF KALISPELL, MONTANA05.03.2023 12:59 gb8501_pg.php/Job No: 3302 Page 28 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2023 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5349 STORM SEWER FUND REVENUE 5349-000-323108-000 PW PLAN REVIEW FEES 3,898 1,500 2,398- -160% 5349-000-334040-000 PETRO TANK RELEASE/MONITORING REIMB 4,592 1,000 3,592- -359% 5349-000-343034-000 PERMIT FEES 935 1,500 565 38% 5349-000-343035-000 STORM SEWER CHARGES 0 1,000 1,000 100% 5349-000-343370-000 STORM SEWER ASSESSMENTS (Billed) 2,004,552 1,924,487 80,065- -4% 5349-000-363040-000 PEN & INT ON SPEC ASSESS. 3,441 2,500 941- -38% 5349-000-371010-000 INTEREST ON INVESTMENTS 88,661 15,000 73,661- -491% 5349-000-383010-000 IMPACT FEE 5% ADMIN - TFR FROM IMPA 7,500 10,000 2,500 25% 5349-000-383015-000 DEBT SERVICE TRANSFER FROM IMPACT F 0 150,000 150,000 100% ------------------------------------------------- TOTAL REVENUE 2,113,578 2,106,987 6,591- -0% ================================================= STORM OPERATING EXPENSES 5349-453-430246-110 SALARIES-STORM SEWER 359,211 575,707 216,496 38% 5349-453-430246-121 OVERTIME 104 4,000 3,896 97% 5349-453-430246-153 HEALTH INSURANCE 54,806 106,252 51,446 48% 5349-453-430246-155 RETIREMENT 28,573 45,839 17,266 38% 5349-453-430246-210 OFFICE/COMPUTER SUPPLIES 8,924 18,500 9,576 52% 5349-453-430246-218 NON CAP. & SAFETY EQUIP. & SUPPLIES 5,724 6,000 276 5% 5349-453-430246-229 OTHER SUPPLIES/TOOLS 294 2,200 1,906 87% 5349-453-430246-231 GAS & OIL 9,579 14,500 4,921 34% 5349-453-430246-345 TELEPHONE & COMMUNICATION 1,341 3,250 1,909 59% 5349-453-430246-353 AUDITING 0 1,150 1,150 100% 5349-453-430246-354 CONTRACT SERVICE 4,428 10,000 5,572 56% 5349-453-430246-356 STORMWATER REG COMPLIANCE PROGRAM 7,706 35,000 27,294 78% 5349-453-430246-358 CONSULTANTS 0 260,000 260,000 100% 5349-453-430246-359 CONSULTANTS-TMDL / PERMIT 0 30,000 30,000 100% 5349-453-430246-360 REPAIR & MAINT SERVICES 1,149 5,000 3,851 77% 5349-453-430246-362 GROUNDWATER MONITORING 0 6,500 6,500 100% 5349-453-430246-371 CURB & GUTTER 5,676 21,000 15,324 73% 5349-453-430246-373 DUES & TRAINING 1,172 10,250 9,078 89% 5349-453-430246-388 MEDICAL SERVICES 0 100 100 100% 5349-453-430246-410 CONSTRUCTION MATERIALS 1,842 12,000 10,158 85% 5349-453-430246-510 PROPERTY & LIABILITY INS. 15,340 15,340 0 0% 5349-453-430246-521 CENTRAL GARAGE TRANSFER 8,230 10,974 2,744 25% 5349-453-430246-522 ADMINISTRATIVE TRANSFER 37,643 50,191 12,548 25% 5349-453-430246-528 INFORMATION TECH TRANSFER 31,618 42,157 10,539 25% 5349-453-430246-530 BNSF LEASE PMT 4,496 5,500 1,004 18% ------------------------------------------------- TOTAL STORM OPERATING EXPENSE 587,857 1,291,410 703,553 54% ------------------------------------------------- CAPITAL FROM OPERATING/BONDS ------------------------------------------------- TOTAL CAP. FROM OPERATING/BOND 0 0 0 0% ------------------------------------------------- CAPITAL FROM DES. CAP. PROJECT 5349-453-430247-952 STORM DRAIN CORRECTION (NEW & C/O) 3,503 500,000 496,497 99% 5349-453-430247-954 N. MAIN ST STORMWATER PROJ. 0 252,500 252,500 100% 5349-453-430247-956 WYOMING STREET OUTFALL 0 225,000 225,000 100% 5349-453-430247-957 WEDGEWOOD & SHERWOOD DESIGN/SURVEY 0 50,000 50,000 100% 5349-453-430247-959 REGIONAL FACILITIES & PIPING DESIGN 1,704 50,000 48,296 97% 5349-453-430247-961 NORTH REGIONAL CONVEYANCE SYSTEM 0 50,000 50,000 100% 5349-453-430247-969 1ST AVE W - S. OF CITY SHOPS 82,632 468,981 386,349 82% QTR 3 2023 THE CITY OF KALISPELL, MONTANA05.03.2023 12:59 gb8501_pg.php/Job No: 3302 Page 29 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2023 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ------------------------------------------------- TOTAL CAP. FROM DES. CAP. PROJ 87,838 1,596,481 1,508,643 95% ------------------------------------------------- CAPITAL/OTHER FROM REPLACEMENT 5349-453-430249-940 MACHINERY FROM REPLACEMENT 0 62,500 62,500 100% ------------------------------------------------- TOTAL CAPITAL/OTHER FROM REPLA 0 62,500 62,500 100% ------------------------------------------------- REVENUE BONDS 5349-453-490200-610 PRINCIPAL - 4TH AVE E BOND 0 3,188 3,188 100% 5349-453-490200-620 INTEREST-4TH AVE E BOND 1,413 1,413 0- -0% 5349-453-490225-610 PRINCIPAL - REGIONAL FACILITIES 0 99,000 99,000 100% 5349-453-490225-620 INTEREST - REGIONAL FACILITIES 51,013 58,488 7,476 13% ------------------------------------------------- TOTAL REVENUE BONDS 52,426 162,089 109,663 68% ------------------------------------------------- DEPRECIATION 5349-453-510400-831 DEPRECIATION (FUND $40,000) 0 360,000 360,000 100% ------------------------------------------------- TOTAL DEPRECIATION 0 360,000 360,000 100% ------------------------------------------------- TOTAL STORM EXPENSE 728,121 3,472,480 2,744,359 79% ================================================= QTR 3 2023 THE CITY OF KALISPELL, MONTANA05.03.2023 12:59 gb8501_pg.php/Job No: 3302 Page 30 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2023 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING STORM SEWER IMPACT FEE REVENUE 5348-000-343033-000 IMPACT FEES 107,890 280,000 172,110 61% 5348-000-371010-000 INTEREST EARNINGS 33,588 6,000 27,588- -460% ------------------------------------------------- TOTAL STORM IMPACT FEES REVENU 141,478 286,000 144,522 51% ================================================= STORM SWR IMPACT FEE EXPENSES 5348-453-430248-820 DEBT SERVICE TRANSFER TO 5349 0 150,000 150,000 100% 5348-453-430248-825 TRANSFER TO 5349 FOR ADMIN 7,500 10,000 2,500 25% ------------------------------------------------- TOTAL IMPACT FEE TRANSFERS 7,500 160,000 152,500 95% ------------------------------------------------- CAPITAL FROM IMPACT FEES 5348-453-430248-959 REG FACILITIES & PIPING DESIGN 1,704 50,000 48,296 97% 5348-453-430248-960 STORMWATER FACILITY UPSIZING (CARRY 0 230,000 230,000 100% 5348-453-430248-961 NORTH REGIONAL CONVEYANCE SYSTEM 0 50,000 50,000 100% ------------------------------------------------- TOTAL CAPITAL FROM IMPACT FEES 1,704 330,000 328,296 99% ------------------------------------------------- TOTAL STORM IMPACT FEE EXPENSE 9,204 490,000 480,796 98% ================================================= QTR 3 2023 THE CITY OF KALISPELL, MONTANA05.03.2023 12:59 gb8501_pg.php/Job No: 3302 Page 31 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2023 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5510 SOLID WASTE REVENUE 5510-000-343360-000 SALE OF MAT/AUCTION 0 2,500 2,500 100% 5510-000-343410-000 GARBAGE COLLECTION-ASSESSED 1,278,177 1,270,000 8,177- -1% 5510-000-343420-000 GARBAGE COLLECTION-NOT ASSESSED 35,673 29,185 6,488- -22% 5510-000-363040-000 PEN & INT ON SPEC ASSESS. 2,072 2,000 72- -4% 5510-000-371010-000 INVESTMENT EARNINGS 25,123 5,000 20,123- -402% ------------------------------------------------- TOTAL REVENUE 1,341,045 1,308,685 32,360- -2% ================================================= EXPENSES 5510-460-430840-110 SALARIES-SOLID WASTE 334,926 526,843 191,917 36% 5510-460-430840-121 OVERTIME 6,951 6,500 451- -7% 5510-460-430840-153 HEALTH INSURANCE 61,825 124,920 63,095 51% 5510-460-430840-155 RETIREMENT 27,238 41,736 14,498 35% 5510-460-430840-213 OFFICE/COMPUTER EQUIP/SUPPLIES 8,482 16,500 8,018 49% 5510-460-430840-218 EQUIPMENT-GARBAGE CONTAINERS 49,098 69,125 20,027 29% 5510-460-430840-229 SAFETY/OTHER SUPPLIES & EQUIPMENT 3,665 5,500 1,835 33% 5510-460-430840-231 GAS & OIL 68,662 73,000 4,338 6% 5510-460-430840-341 ELECTRICITY 935 2,050 1,115 54% 5510-460-430840-344 NATURAL GAS 2,462 4,500 2,038 45% 5510-460-430840-345 TELEPHONE & COMMUNICATION 1,463 3,500 2,037 58% 5510-460-430840-354 CONTRACT SERVICES 7,718 122,000 114,282 94% 5510-460-430840-362 EQUIPMENT MAINT & SUPPLIES 43,995 55,000 11,005 20% 5510-460-430840-366 BUILDING MAINTENANCE 1,204 5,000 3,796 76% 5510-460-430840-373 DUES & TRAINING 2,022 8,000 5,978 75% 5510-460-430840-388 MEDICAL SERVICES 634 700 66 9% 5510-460-430840-510 PROPERTY & LIABILITY INS. 24,861 24,861 0 0% 5510-460-430840-512 UNINSURED LOSS-DEDUCTIBLE 1,554 4,000 2,446 61% 5510-460-430840-521 CENTRAL GARAGE TRANSFER 69,030 92,039 23,009 25% 5510-460-430840-522 ADMINISTRATIVE TRANSFER 32,986 43,982 10,996 25% 5510-460-430840-528 INFORMATION TECH TRANSFER 31,484 41,978 10,494 25% 5510-460-430840-820 ALLEY PAVING - TRANSFER TO GAS TAX 30,000 40,000 10,000 25% 5510-460-430840-944 VEHICLES (Replacement $) 0 900,000 900,000 100% 5510-460-510400-831 DEPRECIATION EXPENSE 0 150,000 150,000 100% ------------------------------------------------- TOTAL SOLID WASTE 811,193 2,361,734 1,550,541 66% ================================================= QTR 3 2023 THE CITY OF KALISPELL, MONTANA05.03.2023 12:59 gb8501_pg.php/Job No: 3302 Page 32 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2023 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 4290 WALK & CURB CONSTRUCTION 4290-410-430234-937 CONSTRUCTION 14,381 25,000 10,619 42% ------------------------------------------------- TOTAL WALK & CURB CONSTRUCTION 14,381 25,000 10,619 42% ================================================= 4393 AMERICAN RESCUE PLAN PROJ 4393-410-430550-950 LRF PROJECT - L.S. #3 RECOVERY ACT 0 4,720,305 4,720,305 100% 4393-410-430550-951 DOWNTOWN WTR/SWR MAIN ARPA PROJECT 217,309 1,374,049 1,156,740 84% ------------------------------------------------- TOTAL AMERICAN RESCUE PLAN PRO 217,309 6,094,354 5,877,045 96% ================================================= 5720 WATER/SEWER ARPA PROJECT 5720-410-430550-922 WWTP - FERMENTER REHAB 0 1,000,000 1,000,000 100% 5720-410-430550-925 WATER - NOFFSINGER WATER SOURCE 0 1,000,000 1,000,000 100% 5720-410-430550-950 WWTP - INF. PIPE/DIV. STRUCTURE 0 347,957 347,957 100% 5720-410-430550-951 DOWNTOWN WTR/SWR MAIN ARPA PROJECT 0 5,554,001 5,554,001 100% 5720-410-430550-954 SEWER MAIN REPLACEMENT 694,000 694,000 0 0% 5720-410-430550-956 STORMWATER-MAIN & WYOMING ARPA PROJ 114,550 377,766 263,216 70% 5720-410-430550-969 STORMWATER-ASHLEY CR. DRAINAGE 0 528,264 528,264 100% ------------------------------------------------- TOTAL WTR/SWR ARPA GRANT 808,550 9,501,988 8,693,438 91% ================================================= QTR 3 2023 THE CITY OF KALISPELL, MONTANA05.03.2023 12:59 gb8501_pg.php/Job No: 3302 Page 33 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2023 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING CENTRAL GARAGE 6010-410-431330-110 SALARIES 125,997 191,323 65,326 34% 6010-410-431330-121 OVERTIME 0 2,500 2,500 100% 6010-410-431330-153 HEALTH INSURANCE 25,295 36,215 10,920 30% 6010-410-431330-155 RETIREMENT 9,721 14,789 5,068 34% 6010-410-431330-210 OFFICE/COMPUTER SUPPLIES 10,293 19,500 9,207 47% 6010-410-431330-229 NON CAPITAL EQUIP-SAFETY/OTHER 9,114 9,000 114- -1% 6010-410-431330-230 OIL 9,264 26,500 17,236 65% 6010-410-431330-231 GAS 939 1,700 761 45% 6010-410-431330-232 VEHICLE PARTS 107,911 144,200 36,289 25% 6010-410-431330-233 TIRES 20,738 58,000 37,262 64% 6010-410-431330-238 FILTERS 7,013 9,500 2,487 26% 6010-410-431330-241 CONSUMABLE TOOLS/BOOKS 381 2,100 1,719 82% 6010-410-431330-341 ELECTRICITY 2,570 5,900 3,330 56% 6010-410-431330-342 WATER 553 2,000 1,447 72% 6010-410-431330-344 NATURAL GAS 6,758 12,500 5,742 46% 6010-410-431330-354 CONTRACT SERVICES 25,326 34,000 8,674 26% 6010-410-431330-360 WASH BAY REPAIRS & MAINTENANCE 155 6,000 5,845 97% 6010-410-431330-362 EQUIP/BLDG MAINTENANCE 1,105 6,000 4,895 82% 6010-410-431330-373 DUES & TRAINING 804 9,000 8,196 91% 6010-410-431330-388 MEDICAL SERVICES 55 500 445 89% 6010-410-431330-510 INSURANCE 5,328 5,328 1 0% 6010-410-431330-528 INFORMATION TECH TRANSFER 14,776 19,701 4,925 25% ------------------------------------------------- TOTAL CENTRAL GARAGE 384,096 616,256 232,160 38% ================================================= QTR 3 2023 THE CITY OF KALISPELL, MONTANA05.03.2023 12:59 gb8501_pg.php/Job No: 3302 Page 34 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2023 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING PARKS & RECREATION REVENUE: 2215-000-311100-000 REAL PROPERTY TAXES 707,869 1,215,000 507,131 42% 2215-000-311200-000 PERSONAL PROPERTY TAXES 15,890 24,675 8,785 36% 2215-000-312000-000 PEN & INTEREST DEL TAXES 1,587 1,500 87- -6% 2215-000-334000-000 GRANT - POOL IMPROVEMENTS 0 86,000 86,000 100% 2215-000-346030-000 SWIMMING POOL FEES 92,407 165,000 72,593 44% 2215-000-346040-000 CONCESSION STAND REVENUE 40,687 46,000 5,313 12% 2215-000-346050-000 PARKS USAGE FEES 14,478 20,000 5,522 28% 2215-000-346051-000 RECREATION FEES 23,749 40,045 16,296 41% 2215-000-346052-000 SPORTS PROGRAMS 76,600 91,788 15,188 17% 2215-000-346053-000 SCHOLARSHIPS (DONATIONS) 2,650 3,200 550 17% 2215-000-346054-000 AFTER SCHOOL PROGRAMS 60,886 73,000 12,115 17% 2215-000-346055-000 ICE RINK 12,707 20,000 7,293 36% 2215-000-346056-000 KIDSPORT USAGE 626 1,600 974 61% 2215-000-346057-000 YOUTH CAMPS 24,259 207,344 183,085 88% 2215-000-346059-000 PICNIC IN THE PARK 11,582 26,500 14,918 56% 2215-000-365010-000 DONATIONS/TELETECH ART ED/FEC REFUN 5,047 0 5,047- 0% 2215-000-365015-000 KIDSPORTS MAINTENANCE 0 19,000 19,000 100% 2215-000-365016-000 INSURANCE REIMBURSEMENTS 37,395 0 37,395- 0% 2215-000-371010-000 INVESTMENTS 20,804 4,800 16,004- -333% 2215-000-381050-000 INCEPTION OF LOAN 0 172,000 172,000 100% 2215-000-381060-000 HEALTH INSURANCE TRANSFER 55,500 111,000 55,500 50% ------------------------------------------------- TOTAL PARKS & REC REVENUE 1,204,721 2,328,452 1,123,731 48% ================================================= EXPENDITURES PARKS DEPARTMENT: 2215-436-460430-110 SALARIES-PARKS 281,754 387,869 106,115 27% 2215-436-460430-111 SEASONAL SALARIES 22,446 51,878 29,432 57% 2215-436-460430-121 OVERTIME 0 300 300 100% 2215-436-460430-153 HEALTH INSURANCE 41,965 70,540 28,575 41% 2215-436-460430-155 RETIREMENT 25,578 33,821 8,243 24% 2215-436-460430-210 OFFICE/COMPUTER SUPPLIES/EQUIP 559 2,000 1,441 72% 2215-436-460430-215 EQUIPMENT - not capital 0 3,000 3,000 100% 2215-436-460430-224 JANITORIAL SUPPLIES 4,250 7,000 2,750 39% 2215-436-460430-229 OTHER SUPPLIES 1,464 10,000 8,536 85% 2215-436-460430-231 GAS 20,433 19,000 1,433- -8% 2215-436-460430-241 SAFETY/OTHER EQUIPMENT/TOOLS 1,104 3,000 1,896 63% 2215-436-460430-320 PRINTING & ADVERTISING 178 200 22 11% 2215-436-460430-341 ELECTRICITY 8,932 13,500 4,568 34% 2215-436-460430-343 ICE RINK UTILITIES(REIMB.) 16,340 20,000 3,660 18% 2215-436-460430-344 NATURAL GAS 1,795 2,200 405 18% 2215-436-460430-345 TELEPHONE & COMMUNICATIONS 1,225 2,500 1,275 51% 2215-436-460430-351 SPORTS COURT & SPORT MAINTENANCE 0 7,550 7,550 100% 2215-436-460430-354 CONTRACT SERVICES-TENNIS,SECURITY 2,000 2,000 0 0% 2215-436-460430-355 CONTRACT SERV. TRAIL MAINT/WEED CON 23,614 40,000 16,386 41% 2215-436-460430-356 CONSULTANTS - PRELIMINARY DESIGN HW 0 40,000 40,000 100% 2215-436-460430-357 CONSULTANTS - PARKS MASTER PLAN 0 100,000 100,000 100% 2215-436-460430-362 EQUIPMENT/BLDG MAINTENANCE 1,061 8,000 6,939 87% 2215-436-460430-364 LANDSCAPE MATERIALS, PERENNIALS & R 1,895 5,500 3,605 66% 2215-436-460430-367 VANDALISM REPAIRS 2,369 4,000 1,631 41% QTR 3 2023 THE CITY OF KALISPELL, MONTANA05.03.2023 12:59 gb8501_pg.php/Job No: 3302 Page 35 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2023 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2215-436-460430-373 DUES & TRAINING 3,697 8,000 4,303 54% 2215-436-460430-388 MEDICAL SERVICES/DRUG TESTING 180 600 420 70% 2215-436-460430-395 EQUIPMENT RENTAL 0 700 700 100% 2215-436-460430-420 FENCING/PICNIC TABLES/OTHER 2,390 6,500 4,110 63% 2215-436-460430-440 IRRIGATION SUPPLIES 4,345 6,000 1,655 28% 2215-436-460430-452 GRAVEL, TOP SOIL, SAND AND COMPOST 264 2,000 1,736 87% 2215-436-460430-521 CENTRAL GARAGE TRANSFER 17,823 23,765 5,942 25% 2215-436-460430-545 COUNTY LANDFILL 3,735 6,273 2,538 40% 2215-436-460430-610 DEBT SERVICE PRINCIPAL 33,385 37,685 4,300 11% 2215-436-460430-620 DEBT SERVICE INTEREST 840 1,331 491 37% 2215-436-460430-941 EQUIPMENT - FY 23 TRACTOR 0 43,000 43,000 100% ------------------------------------------------- SUBTOTAL PARKS EXPENDITURES 525,621 969,712 444,091 46% ATHLETIC COMPLEX EXPENDITURES 2215-436-460440-110 SALARIES-COMPLEX 84,778 122,702 37,924 31% 2215-436-460440-111 SEASONAL SALARIES 26,526 45,983 19,457 42% 2215-436-460440-121 OVERTIME 0 300 300 100% 2215-436-460440-153 HEALTH INSURANCE 20,972 30,361 9,389 31% 2215-436-460440-155 RETIREMENT 8,663 11,847 3,184 27% 2215-436-460440-221 SAFETY EQUIPMENT 120 300 180 60% 2215-436-460440-229 OTHER SUPPLIES 2,666 22,000 19,334 88% 2215-436-460440-231 GAS 5,367 10,000 4,633 46% 2215-436-460440-241 CONSUMABLE TOOLS 295 780 485 62% 2215-436-460440-341 ELECTRICITY 7,468 12,000 4,532 38% 2215-436-460440-345 TELEPHONE & COMMUNICATION 49 251 202 81% 2215-436-460440-354 CONTRACT SERVICES 0 21,800 21,800 100% 2215-436-460440-362 EQUIPMENT MAINTENANCE 641 1,000 359 36% 2215-436-460440-364 LANDSCAPING 300 300 0 0% 2215-436-460440-367 VANDALISM REPAIRS 0 500 500 100% 2215-436-460440-373 DUES & TRAINING 917 1,500 583 39% 2215-436-460440-388 MEDICAL SERVICES: DRUG TESTING 0 300 300 100% 2215-436-460440-395 RENTAL EQUIPMENT 0 200 200 100% 2215-436-460440-420 METAL PRODUCTS 2,156 7,500 5,344 71% 2215-436-460440-440 IRRIGATION 10,334 7,000 3,334- -48% 2215-436-460440-452 SAND & GRAVEL 452 1,500 1,048 70% 2215-436-460440-521 CENTRAL GARAGE TRANSFER 4,426 5,901 1,475 25% 2215-436-460440-545 COUNTY LANDFILL 3,470 3,500 30 1% 2215-436-460440-610 DEBT SERVICE - PRINCIPAL 0 5,000 5,000 100% 2215-436-460440-620 DEBT SERVICE - INTEREST 0 386 386 100% 2215-436-460440-940 EQUIPMENT - FY23 TRUCK & ZERO TURN 50,000 50,000 0 0% ------------------------------------------------- SUBTOTAL ATHLETIC COMPLEX 229,599 362,911 133,312 37% RECREATION EXPENDITURES 2215-436-460431-110 SALARIES-RECREATION 66,120 100,317 34,197 34% 2215-436-460431-111 SEASONAL SALARIES 10,935 26,496 15,561 59% 2215-436-460431-121 OVERTIME 8 0 8- 0% 2215-436-460431-153 HEALTH INSURANCE 8,967 22,012 13,045 59% 2215-436-460431-155 RETIREMENT 5,476 10,219 4,743 46% 2215-436-460431-229 MISC. SUPPLIES 12,587 15,020 2,433 16% 2215-436-460431-231 GAS 112 575 463 81% 2215-436-460431-320 PRINTING & ADVERTISING 421 7,850 7,429 95% 2215-436-460431-345 TELEPHONE & COMMUNICATION 665 800 135 17% QTR 3 2023 THE CITY OF KALISPELL, MONTANA05.03.2023 12:59 gb8501_pg.php/Job No: 3302 Page 36 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2023 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2215-436-460431-354 CONTRACT SERVICES 38,418 41,113 2,695 7% 2215-436-460431-357 MUSIC FRANCHISE FEES 1,324 1,400 76 5% 2215-436-460431-373 DUES & TRAINING 1,310 1,000 310- -31% ------------------------------------------------- SUBTOTAL RECREATION 146,342 226,802 80,460 35% YOUTH CAMPS 2215-436-460448-110 SALARIES-YOUTH CAMPS 58,084 89,347 31,263 35% 2215-436-460448-111 SEASONAL SALARIES 120,884 171,201 50,317 29% 2215-436-460448-121 OVERTIME 160- 150 310 207% 2215-436-460448-153 HEALTH INSURANCE 8,390 20,641 12,251 59% 2215-436-460448-155 RETIREMENT 4,728 8,236 3,508 43% 2215-436-460448-224 JANITORIAL SUPPLIES (DAYCAMP FACILI 0 300 300 100% 2215-436-460448-229 MISC. SUPPLIES 1,562 3,675 2,113 58% 2215-436-460448-231 GAS 0 400 400 100% 2215-436-460448-320 PRINTING & ADVERTISING 50 355 305 86% 2215-436-460448-345 TELEPHONE & COMMUNICATION 751 1,250 499 40% 2215-436-460448-354 CONTRACT SERVICES 11,077 20,147 9,070 45% 2215-436-460448-355 AFTER SCHOOL PROGRAM 692 1,200 508 42% 2215-436-460448-356 BANK FEES/CC CHARGES 2,613 6,000 3,387 56% 2215-436-460448-373 DUES & TRAINING 770 1,000 230 23% ------------------------------------------------- SUBTOTAL YOUTH CAMPS 209,440 323,902 114,462 35% PARKLINE TRAIL MAINTENANCE 2215-436-460457-110 SALARIES - PARK LINE TRAIL 32,471 45,874 13,403 29% 2215-436-460457-111 SALARIES - SEASONAL 7,897 21,001 13,105 62% 2215-436-460457-121 OVERTIME 0 300 300 100% 2215-436-460457-153 HEALTH INSURANCE 12,585 13,691 1,106 8% 2215-436-460457-155 RETIREMENT 2,664 3,751 1,087 29% 2215-436-460457-210 OFFICE SUPPLIES - EQUIP / COMPUTERS 56 300 244 81% 2215-436-460457-215 EQUIPMENT - NOT CAPITAL 560 1,300 740 57% 2215-436-460457-224 JANITORIAL SUPPLIES 0 2,200 2,200 100% 2215-436-460457-229 OTHER SUPPLIES (FERTILIZER, WEED SP 41 3,500 3,459 99% 2215-436-460457-231 GAS 1,688 4,000 2,312 58% 2215-436-460457-241 TOOLS / SMALL EQUIP / SAFETY EQUIP 606 700 94 13% 2215-436-460457-341 ELECTRICITY 0 4,000 4,000 100% 2215-436-460457-345 TELEPHONE & COMMUNICATIONS 0 2,235 2,235 100% 2215-436-460457-355 CONTRACT SERVICES - TRAIL MAINT / W 8,382 6,000 2,382- -40% 2215-436-460457-362 EQUIUPMENT / AMENITY MAINTENANCE 1,083 1,500 417 28% 2215-436-460457-364 LANDSCAPE MATERIALS 0 3,000 3,000 100% 2215-436-460457-367 VANDALISM REPAIRS 484 1,200 716 60% 2215-436-460457-373 DUES & TRAINING 386 600 214 36% 2215-436-460457-388 MEDICAL SERVICES - DRUG TESTING 0 100 100 100% 2215-436-460457-395 EQUIPMENT RENTAL 0 500 500 100% 2215-436-460457-440 IRRIGATION SUPPLIES 0 1,200 1,200 100% 2215-436-460457-452 TOP SOIL / MULCH & COMPOST 0 750 750 100% 2215-436-460457-545 COUNTY LANDFILL 0 3,500 3,500 100% 2215-436-460457-610 DEBT SERVICE - PRINCIPAL 0 7,900 7,900 100% 2215-436-460457-620 DEBT SERVICE - INTEREST 0 612 612 100% 2215-436-460457-941 EQUIPMENT - TOOLCAT 79,000 79,000 0 0% ------------------------------------------------- SUBTOTAL PARKLINE TRAIL MAINTE 147,904 208,714 60,810 29% QTR 3 2023 THE CITY OF KALISPELL, MONTANA05.03.2023 12:59 gb8501_pg.php/Job No: 3302 Page 37 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2023 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING POOL 2215-437-460445-111 SEASONAL SALARIES-POOL 119,733 222,525 102,792 46% 2215-437-460445-121 OVERTIME 657 200 457- -229% 2215-437-460445-155 RETIREMENT 1,207 1,500 293 20% 2215-437-460445-210 OFFICE EQUIP/SUPPLIES/PRINTING 309 500 191 38% 2215-437-460445-224 JANITORIAL/SAFETY SUPPLIES 1,606 3,000 1,394 46% 2215-437-460445-226 CHLORINE/CHEMICALS 38,918 48,000 9,082 19% 2215-437-460445-228 CONCESSION STAND SUPPLIES 25,146 23,000 2,146- -9% 2215-437-460445-229 TOOLS/OTHER SUPPLIES 352 4,000 3,648 91% 2215-437-460445-341 ELECTRICITY 5,318 10,500 5,182 49% 2215-437-460445-344 NATURAL GAS 23,686 24,000 314 1% 2215-437-460445-345 TELEPHONE/SECURITY CAMERAS 1,965 9,855 7,890 80% 2215-437-460445-354 LICENSES & FEES 1,781 1,835 54 3% 2215-437-460445-356 BANK FEES/ CC CHARGES 2,730 3,500 770 22% 2215-437-460445-362 BLDG/EQUIPMENT MAINTENANCE 16,685 73,800 57,115 77% 2215-437-460445-367 VANDALISM 0 1,000 1,000 100% 2215-437-460445-380 TRAINING MATERIALS 1,012 1,800 788 44% 2215-437-460445-932 EQUIPMENT / POOL IMPROVEMENTS 63,180 172,000 108,820 63% ------------------------------------------------- SUBTOTAL POOL EXPENDITURES 304,287 601,015 296,728 49% ------------------------------------------------- TOTAL PARKS & RECREATION/POOL 1,563,192 2,693,056 1,129,864 42% ================================================= 2210 PARKS IN LIEU 2210-436-460430-935 JAXSON RIDGE 0 36,923 36,923 100% 2210-436-460430-936 LAWRENCE PARK IMPROVEMENTS 0 7,423 7,423 100% 2210-436-460430-937 COTTAGE GARDENS 0 9,449 9,449 100% 2210-436-460430-938 3RD AVE APT - LIONS PARK IMPROVEMEN 0 29,659 29,659 100% 2210-436-460430-939 WESTCRAFT - KYAC IMPROVEMENTS SUPPO 0 42,250 42,250 100% ------------------------------------------------- TOTAL PARKS IN LIEU 0 125,704 125,704 100% ================================================= QTR 3 2023 THE CITY OF KALISPELL, MONTANA05.03.2023 12:59 gb8501_pg.php/Job No: 3302 Page 38 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2023 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING URBAN FORESTRY 2600-436-460433-110 SALARIES-URBAN FORESTRY 159,921 219,698 59,777 27% 2600-436-460433-111 SEASONAL SERVICES 12,592 50,062 37,470 75% 2600-436-460433-121 OVERTIME 522 1,000 478 48% 2600-436-460433-153 HEALTH INSURANCE 29,006 49,140 20,134 41% 2600-436-460433-155 RETIREMENT 13,339 21,790 8,451 39% 2600-436-460433-229 OFFICE/OTHER SUPPLIES 4,170 4,500 330 7% 2600-436-460433-231 GAS 5,043 7,000 1,957 28% 2600-436-460433-241 CONSUMABLE TOOLS 1,792 5,200 3,408 66% 2600-436-460433-345 TELEPHONE / COMMUNICATIONS 413 662 249 38% 2600-436-460433-354 CONTRACT SERVICES 64,410 170,000 105,590 62% 2600-436-460433-358 EAB MONITORING/ARBOR DAY 0 4,750 4,750 100% 2600-436-460433-362 EQUIPMENT MAINTENANCE 1,005 4,000 2,995 75% 2600-436-460433-364 LANDSCAPING & TREES 0 8,000 8,000 100% 2600-436-460433-373 DUES & TRAINING 3,279 5,000 1,721 34% 2600-436-460433-388 MEDICAL 90- 300 390 130% 2600-436-460433-395 EQUIPMENT RENTAL 5,549 8,000 2,451 31% 2600-436-460433-510 LIABILITY & PROPERTY INSURANCE 7,202 7,202 1 0% 2600-436-460433-521 CENTRAL GARAGE TRANSFER 7,464 9,952 2,488 25% 2600-436-460433-522 ADMINISTRATIVE TRANSFER 18,349 24,465 6,116 25% 2600-436-460433-528 INFORMATION TECHNOLOGY TRANSFER 7,254 9,671 2,417 25% 2600-436-460433-610 DEBT SERVICE PRINCIPAL 0 8,000 8,000 100% 2600-436-460433-620 INTEREST EXPENSE 0 620 620 100% 2600-436-460433-940 MACHINERY & EQUIPMENT 25,898 80,000 54,102 68% ------------------------------------------------- TOTAL URBAN FORESTRY 367,119 699,012 331,893 47% ================================================= 2601 DEVELOPER TREES 2601-436-460430-350 ADMIN 5% 0 1,798 1,798 100% 2601-436-460435-351 EMPIRE ESTATES ($44,911) 0 8,653 8,653 100% 2601-436-460435-352 APPLEWAY ($4,564) 0 4,336 4,336 100% 2601-436-460435-353 SIDERIUS - JAXSON RIDGE 0 8,861 8,861 100% 2601-436-460435-354 PW - WEST SIDE INT 0 5,548 5,548 100% 2601-436-460435-356 SINOPAH SUBD ($5,790) 0 667 667 100% 2601-436-460435-357 COTTONWOOD SUBD ($13,100) 0 1,928 1,928 100% 2601-436-460435-359 MTN VISTA ESTATES ($35,903+34,660) 0 14,849 14,849 100% 2601-436-460435-360 OWL VIEW TH ($3,780) 0 3,780 3,780 100% 2601-436-460435-361 VILLAGE GREENS PHASE 19 ($16,497) 0 15,551 15,551 100% 2601-436-460435-362 WESTVIEW BUSINESS CNTR ($1,618) 0 948 948 100% 2601-436-460435-363 MUSKRAT SLOUGH ($1,446) 0 1,390 1,390 100% 2601-436-460435-364 MTN VISTA ESTATES IV 0 17,300 17,300 100% 2601-436-460435-365 VILLAGE GREENS $3,540 0 1,012 1,012 100% 2601-436-460435-366 W VIEW ESTATES $20,060 0 12,736 12,736 100% 2601-436-460435-367 ABIGAIL SUBDIVISION ($4,253.90) 0 2,716 2,716 100% 2601-436-460435-368 NORTHLAND SUBD PHASE 4 0 16,407 16,407 100% 2601-436-460435-369 ADLER HOMES - SANTA PROP. ($1,776) 0 1,687 1,687 100% 2601-436-460435-370 GL VILLAGE GREENS PH22C ($5,600) 0 5,233 5,233 100% 2601-436-460435-371 NORTHLAND PH. 5 ($15,989) 0 15,190 15,190 100% 2601-436-460435-372 GL VILLAGE GREENS, PH 21 ($11,103. 0 9,412 9,412 100% ------------------------------------------------- TOTAL DEVELOPER TREES 0 150,002 150,002 100% ================================================= QTR 3 2023 THE CITY OF KALISPELL, MONTANA05.03.2023 12:59 gb8501_pg.php/Job No: 3302 Page 39 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2023 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING DEVELOPMENT SERVICES 2394 BUILDING DEPARTMENT REVENUE: 2394-000-323101-000 BUILDING PERMITS 420,521 800,000 379,479 47% 2394-000-323103-000 PLUMBING PERMITS 49,584 70,000 20,416 29% 2394-000-323104-000 MECHANICAL PERMITS 46,721 70,000 23,279 33% 2394-000-323105-000 ELECTRICAL PERMITS 51,504 90,000 38,496 43% 2394-000-323108-000 PLAN REVIEW FEES 197,300 325,000 127,700 39% 2394-000-371010-000 INVESTMENT EARNINGS 52,582 11,500 41,082- -357% ------------------------------------------------- TOTAL REVENUE 818,212 1,366,500 548,288 40% ================================================= BUILDING EXPENDITURES: 2394-420-420530-110 SALARIES-BUILDING DEPT. 423,852 646,981 223,129 34% 2394-420-420530-112 SALARIES-SEVERANCE 0 28,378 28,378 100% 2394-420-420530-121 OVERTIME 24,408 20,000 4,408- -22% 2394-420-420530-153 HEALTH INSURANCE 68,173 121,556 53,383 44% 2394-420-420530-155 RETIREMENT 36,804 51,100 14,296 28% 2394-420-420530-210 COMPUTER/OTHER SUPPLIES 38,633 70,000 31,367 45% 2394-420-420530-231 GAS & OIL 3,007 5,000 1,993 40% 2394-420-420530-320 POSTAGE/PRINTING/CODE BOOKS 8,360 6,000 2,360- -39% 2394-420-420530-323 ST. ED. ASSESSMENTS 2,608 7,500 4,892 65% 2394-420-420530-345 TELEPHONE & COMMUNICATION 5,200 7,500 2,300 31% 2394-420-420530-353 AUDITING 0 5,500 5,500 100% 2394-420-420530-354 CONTRACT SERVICES 8,087 40,000 31,913 80% 2394-420-420530-355 LICENSING FEE 19,046 25,000 5,954 24% 2394-420-420530-356 ArcGIS SERVER UPGRADE LICENSE 8,839 8,500 339- -4% 2394-420-420530-357 CREDIT CARD / PAYPAL FEES 9,339 15,000 5,661 38% 2394-420-420530-360 FURNITURE 1,265 7,500 6,235 83% 2394-420-420530-373 DUES & TRAINING 15,685 30,000 14,315 48% 2394-420-420530-510 PROPERTY INSURANCE 14,088 14,088 0- 0% 2394-420-420530-521 CENTRAL GARAGE TRANSFER 1,993 2,658 665 25% 2394-420-420530-522 ADMINISTRATIVE TRANSFER 32,067 42,756 10,689 25% 2394-420-420530-528 INFORMATION TECHNOLOGY TRANSFER 80,076 106,767 26,691 25% 2394-420-420530-944 VEHICLE (FY22) 31,062 127,500 96,438 76% ------------------------------------------------- TOTAL BUILDING DEPT. 832,593 1,389,284 556,691 40% ================================================= QTR 3 2023 THE CITY OF KALISPELL, MONTANA05.03.2023 12:59 gb8501_pg.php/Job No: 3302 Page 40 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2023 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2188 WESTSIDE TIF REVENUE 2188-000-371010-000 INVESTMENT EARNINGS 6,611 2,500 4,111- -164% 2188-000-373010-000 INTEREST / LOANS 10,135 13,425 3,290 25% 2188-000-373020-000 PRINCIPAL / LOANS 14,822 19,851 5,029 25% 2188-000-383005-000 TRANSFER FROM DEBT SERVICE (3188) 450,000 600,000 150,000 25% ------------------------------------------------- TOTAL REVENUE 2,132,373 3,541,562 1,409,189 40% ================================================= EXPENDITURES 2188-480-470230-110 SALARIES 31,054 57,392 26,338 46% 2188-480-470230-153 HEALTH INSURANCE 4,010 10,341 6,331 61% 2188-480-470230-155 RETIREMENT 2,578 4,682 2,104 45% 2188-480-470230-353 AUDIT 0 1,500 1,500 100% 2188-480-470230-356 TELEPHONE 144 192 48 25% 2188-480-470230-522 ADMINISTRATIVE TRANSFER 1,075 1,434 359 25% 2188-480-470230-720 TIF DISTRIBUTION/ or REDEVELOPMENT 22,085 300,000 277,915 93% ------------------------------------------------- TOTAL WESTSIDE TIF 60,946 375,541 314,595 84% ================================================= QTR 3 2023 THE CITY OF KALISPELL, MONTANA05.03.2023 12:59 gb8501_pg.php/Job No: 3302 Page 41 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2023 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2180 DOWNTOWN TIF 2180-480-470230-110 SALARIES 20,025 42,049 22,024 52% 2180-480-470230-153 HEALTH 2,648 8,187 5,539 68% 2180-480-470230-155 RETIREMENT 1,661 3,462 1,801 52% 2180-480-470230-353 AUDITING 0 1,500 1,500 100% 2180-480-470230-354 CONTRACT SERVICES - CORRIDOR STUDY 0 75,000 75,000 100% 2180-480-470230-356 LEGAL SURVEY/TITLE SEARCH/APPRAISAL 90 1,500 1,410 94% 2180-480-470230-720 PARKING STRUCTURE REIMBURSEMENT 0 150,000 150,000 100% 2180-480-470230-840 REDEVELOPMENT ACTIVITY 0 160,000 160,000 100% ------------------------------------------------- TOTAL 2180 AIRPORT TIF 24,425 441,698 417,273 94% ================================================= 2185 AIRPORT TIF 2185-000-430300-840 REDEVELOPMENT ACTIVITY 43,050 214,339 171,289 80% ------------------------------------------------- TOTAL 2185 AIRPORT TIF 43,050 214,339 171,289 80% ================================================= OLD SCHOOL TIFS 2310-480-470210-355 GLACIER INVESTMENTS -TIF REIMBS. 0 10,000 10,000 100% 2310-480-470210-356 FED-EX REIMBURSEMENT 8,151 10,000 1,849 18% 2310-480-470210-820 OPERATING TRANSFER TO 3644 DEBT SER 37,500 50,000 12,500 25% 2311-480-470210-820 OPERATING TRANSFER TO 3644 DEBT SER 4,500 6,000 1,500 25% ------------------------------------------------- TOTAL OLD SCHOOL TIFS 50,151 76,000 25,849 34% ================================================= GLACIER RAIL PARK TEDD 2312-480-470210-110 SALARIES & WAGES 2,110 17,090 14,980 88% 2312-480-470210-153 HEALTH INSURANCE 379 4,765 4,387 92% 2312-480-470210-155 RETIREMENT 176 1,406 1,230 87% 2312-480-470210-345 TELEPHONE 0 48 48 100% 2312-480-470210-353 AUDIT 0 1,500 1,500 100% 2312-480-470210-522 ADMINISTRATIVE TRANSFER 1,075 1,434 359 25% 2312-480-470210-795 REDEVELOPMENT - FCEDA REIMB. 29,238 75,000 45,762 61% 2312-480-470210-796 REDEVELOPMENT/SIDEWALK 0 100,000 100,000 100% ------------------------------------------------- TOTAL GLACIER RAIL PARK TEDD 32,978 201,243 168,265 84% ================================================= QTR 3 2023 THE CITY OF KALISPELL, MONTANA05.03.2023 12:59 gb8501_pg.php/Job No: 3302 Page 42 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2023 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2880 COM DEV REVOLVING FUND 2880-480-470210-353 AUDITING 0 1,000 1,000 100% 2880-480-470210-354 CONTRACT SERVICES 1,306 1,500 194 13% 2880-480-470210-711 REDEVELOPMENT 0 55,000 55,000 100% ------------------------------------------------- TOTAL LOAN REVOLVING 1,306 57,500 56,194 98% ================================================= 2881 CD LOAN REV. #2 2881-480-470210-354 CONT SERV (LOAN SOFTWARE, ETC) 405 405 0 0% 2881-480-470210-711 REDEVELOPMENT 0 50,000 50,000 100% ------------------------------------------------- TOTAL 2881 CD REV. #2 405 50,405 50,000 99% ================================================= 2886 CD MISC. ------------------------------------------------- TOTAL CD MISC. 0 0 0 0% ================================================= 2887 RURAL DEVELOPMENT #1 2887-480-470210-610 DEBT SERVICE/PRIN-L#61-01 19,396 19,396 0- 0% 2887-480-470210-620 INTEREST EXPENSE/L#61-01 2,678 2,678 0 0% 2887-480-470210-750 REDEVELOPMENT LOANS 0 170,000 170,000 100% ------------------------------------------------- TOTAL RURAL DEVELOPMENT #1 22,074 192,074 170,000 89% ================================================= 2888 RURAL DEVELOPMENT #2 2888-480-470210-354 CONT SERV (LOAN SOFTWARE) 500 500 0 0% 2888-480-470210-610 DEBT SERVICE/PRIN-L#61-03 8,638 8,638 0- 0% 2888-480-470210-620 INTEREST EXPENSE-USDA LOAN 61-03 1,387 1,387 0 0% 2888-480-470210-750 REDEVELOPMENT LOANS 0 289,000 289,000 100% ------------------------------------------------- TOTAL RURAL DEVELOPMENT #2 10,525 299,525 289,000 96% ================================================= QTR 3 2023 THE CITY OF KALISPELL, MONTANA05.03.2023 12:59 gb8501_pg.php/Job No: 3302 Page 43 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2023 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2945 SAMARITAN HOUSE GRANT 2945-480-470243-790 SAMARITIN HOUSE PROJECT 15,000 30,000 15,000 50% ------------------------------------------------- TOTAL SAMARITAN HOUSE GRANT 15,000 30,000 15,000 50% ================================================= 2953 EPA BROWNFIELDS 2953-480-470210-353 CONT. SERV - (STATE PETRO REIMB) 26,481 27,596 1,115 4% 2953-480-470210-354 CONT SERV/PETROLEUM 1,628 688 940- -137% 2953-480-470210-373 TRAVEL/PETROLEUM 809 0 809- 0% 2953-480-470215-354 CONT SERV/HAZARDOUS 47 0 47- 0% 2953-480-470215-373 TRAVEL/HAZARDOUS 107 1,905 1,798 94% ------------------------------------------------- TOTAL EPA BROWNSFIELD 29,073 30,189 1,116 4% ================================================= 2955 BROWNFIELDS LOAN REV. 2955-480-470210-229 SUPPLIES-PETROLEUM 0 218,322 218,322 100% 2955-480-470210-725 REVOLVED FUNDS-PETROLEUM 0 100,500 100,500 100% 2955-480-470215-229 SUPPLIES-HAZARDOUS SUBSTANCES 0 267,673 267,673 100% ------------------------------------------------- TOTAL BROWNFIELDS LOAN REV. 0 586,495 586,495 100% ================================================= FY21 AIRPORT GRANT 2974-430-430310-934 CAPITAL IMROVEMENTS - LIGHT/FENCING 0 394,187 394,187 100% ------------------------------------------------- TOTAL 2974 FY21 AIRPORT GRANT 0 394,187 394,187 100% ================================================= 2991 TIGER GRANT ------------------------------------------------- TOTAL TIGER GRANT 0 394,187 394,187 100% =================================================