Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2020 - August 2020 Monthly Financial Report - Josh DeLay, Finance Director
City of East Wenatchee September 15, 2020 City Council Meeting August 2020 Financial Report Date: September 15, 2020 To: Councilmembers, Mayor Crawford & Department Heads From: Josh DeLay, Finance Director Subject: August 2020 Financial Report This report provides a summary of the City’s overall financial operations through August 31, 2020. It offers a comparison of total overall revenues and expenditures between the current fiscal year and the same point in time as the last fiscal year. For the purposes of this report, operating funds are funds that receive general local tax support and/or expend wages and other steady expenses to support the day-to-day operations of the City. Non-operating funds are funds that are supported through special revenues and/or include non-wage and varying expenses (i.e. capital, grant projects, etc.). Table 1 below shows the City’s revenue collections through August 31, 2020 compared to revenue collections through August 31, 2019, along with the respective dollar and percentage variances for its operating funds. Table 1 August 31, 2020 August 31, 2019 Variance - Higher/(Lower) Percentage Increase/(Decrease) General Fund - 001 4,232,317 4,234,292 (1,975) (0.05%) Street Fund - 101 765,975 1,099,147 (333,172) (30.31%) Events Board Fund - 117 50,320 55,670 (5,350) (9.61%) Equipment R&R Fund - 501 372,073 450,000 (77,928) (17.32%) Total Revenues - Operating Funds 5,420,684 5,839,109 (418,424) (7.17%) Revenues - Operating Funds CITY OF EAST WENATCHEE Finance Department 271 9th Street NE * East Wenatchee, WA 98802 P: (509) 886-6101 * F: (509) 884-6233 Email: jdelay@eastwenatcheewa.gov 1 of 26 City of East Wenatchee September 15, 2020 City Council Meeting August 2020 Financial Report Chart 1 is a graphical representation of year to year revenue comparisons for the City’s operating funds. Chart 1 Table 2 below shows the City’s revenue collections through August 31, 2020 compared to revenue collections through August 31, 2019, along with the respective dollar and percentage variances for its non-operating funds. Table 2 August 31, 2020 August 31, 2019 Variance - Higher/(Lower) Percentage Increase/(Decrease) Comm Dev Grants Fund - 102 12,893 - 12,893 - Trans Benefit District Fund - 105 165,983 171,448 (5,464) (3.19%) Library Fund - 112 3,500 3,500 - - Hotel/Motel Tax Fund - 113 150,944 109,944 41,000 37.29% Drug Fund - 114 11 448 (437) (97.46%) Criminal Justice Fund - 116 14,604 14,011 594 4.24% Bond Redemption Fund - 202 100,000 30,000 70,000 233.33% Street Improvements Fund - 301 689,794 905,709 (215,914) (23.84%) Capital Improvements Fund - 314 343,975 245,415 98,559 40.16% Storm Water Fund - 401 3,315,149 - 3,315,149 - Total Revenues - Non-Operating Funds 4,796,854 1,480,474 3,316,379 224.01% Revenues - Non-Operating Funds 2 of 26 City of East Wenatchee September 15, 2020 City Council Meeting August 2020 Financial Report Chart 2 is a graphical representation of year to year revenue comparisons for the City’s non-operating funds. Chart 2 Revenue Highlights: General Fund revenues are down $1,975, or .05%, from last year due to: $73,069 less gambling tax due to the gambling establishments being temporarily closed because of COVID-19; $63,646 less phone/cellular utility tax for reasons currently under review; and $50,415 less in interest earnings due to historically low interest rates The above decreases are offset by the following increases from last year: $80,075 increase in sales tax allocation from last year because the City budgeted for this fund to receive $230,000 more sales tax than last year. Overall sales tax collections for each fund year over year are down 2.7%; 3 of 26 City of East Wenatchee September 15, 2020 City Council Meeting August 2020 Financial Report $74,334 increase in property taxes due to how property tax checks have been distributed/receipted to date, and because the City budgeted for this fund to receive $245,000 more property tax than last year; $42,080 increase in fees for building & structure permits; and $20,000 in grant funding from the Washington State Office of Public Defense Street Fund revenues are down $333,172, or 30.31%, from last year because prior to this year stormwater reimbursements we received from Douglas County as our fiduciary agent were deposited into this fund. Those revenues now go directly into the Stormwater Fund. Additionally, this fund has received $138,920 and $50,000 less in property tax and sales tax, respectively, because the City budgeted less in this fund for each of these revenue sources for 2020. Events Fund revenues are down $5,350, or 9.61%, from last year because all events planned for 2020 have been cancelled due to COVID-19. Equipment R&R Fund revenues are down $77,928, or 17.32%, from last year because the City budgeted for this fund to receive less revenue than last year. Hotel/Motel Tax Fund revenues are up $41,000, or 37.29%, from last year presumably due to an increase in hotel stays in the City. Additionally, this fund now receives all hotel/motel taxes; whereas, last year these taxes were also allocated directly to the Events Fund. Bond Redemption Fund revenues are up $70,000, or 233.33%, from last year due to the fund needing a larger allocation of property tax to start paying off the 10th Street loan debt. Street Improvements Fund revenues are down $215,914, or 23.84%, from last year due to delayed reimbursements from the state agencies where these reimbursements originate because of COVID- 19. Capital Improvements Fund revenues are up $98,559, or 40.16%, from last year due to the increased collection of real estate excise tax presumably due to more and/or larger real estate sales transactions. Storm Water Fund revenues are up $3,315,149 because this is a new fund that the City is accounting for due to a terminated Interlocal Agreement with Douglas County for storm water services. Prior to 2020, Douglas County accounted for these monies as a fiduciary agent for the City. Table 3 below shows the City’s expenditures through August 31, 2020 compared to expenditures through August 31, 2019, along with respective dollar and percentage variances for its operating funds. 4 of 26 City of East Wenatchee September 15, 2020 City Council Meeting August 2020 Financial Report Table 3 August 31, 2020 August 31, 2019 Variance - Higher/(Lower) Percentage Increase/(Decrease) General Fund - 001 4,766,811 4,649,681 117,130 2.52% Street Fund - 101 597,013 1,004,062 (407,049) (40.54%) Events Board Fund - 117 51,700 89,233 (37,533) (42.06%) Equipment R&R Fund - 501 254,370 312,048 (57,678) (18.48%) Total Expenditures - Operating Funds 5,669,895 6,055,024 (385,129) (6.36%) Expenditures - Operating Funds Chart 3 is a graphical representation of year to year expenditure comparisons for the City’s operating funds. Chart 3 Table 4 below shows the City’s expenditures through August 31, 2020 compared to expenditures through August 31, 2019, along with respective dollar and percentage variances for its non-operating funds. 5 of 26 City of East Wenatchee September 15, 2020 City Council Meeting August 2020 Financial Report Table 4 August 31, 2020 August 31, 2019 Variance - Higher/(Lower) Percentage Increase/(Decrease) Comm Dev Grants Fund - 102 19,086 59,927 (40,841) (68.15%) Trans Benefit District Fund - 105 1,500 284,381 (282,881) (99.47%) Debt Reserve Fund - 110 - - - - Library Fund - 112 3,163 3,491 (328) (9.39%) Hotel/Motel Tax Fund - 113 60,000 79,184 (19,184) (24.23%) Bond Redemption Fund - 202 47,842 30,420 17,423 57.27% Street Improvements Fund - 301 1,442,042 582,022 860,019 147.76% Storm Water Improvements Fund - 308 66,059 40,748 25,311 62.12% Capital Improvements Fund - 314 52,222 637,499 (585,277) (91.81%) Storm Water Fund - 401 759,993 - 759,993 - Total Expenditures - Non-Operating Funds 2,451,907 1,717,672 734,235 42.75% Expenditures - Non-Operating Funds Chart 4 is a graphical representation of year to year expenditure comparisons for the City’s non- operating funds. Chart 4 6 of 26 City of East Wenatchee September 15, 2020 City Council Meeting August 2020 Financial Report Expenditure Highlights: General Fund expenditures are up $177,130, or 2.52%, from last year due to: General salary and benefit increases, and increases due to retirements and separations; $35,957 increase in bills from the Chelan County Regional Justice Center due to the timing of billings received, and due to the terms of the City’s new contract with them. This variance will equalize towards year-end; and $25,000 increase for a new disaster backup recovery system The above increases are offset by the following decreases: $240,187 purchase of the Colorado Ave. property last year; $37,916 decrease in overtime salaries for the Police Department; and $22,899 decrease in contracted costs for River Com services Street Fund expenditures are down $407,049, or 40.54%, from last year due to a mild winter, which resulted in less snow and ice removal overtime, and getting caught up with delayed Department of Transportation utility billings from prior years that we paid in the early part of 2019. Additionally, the expenses for storm water activities are no longer accounted for in this fund as they were prior to 2020. Events Fund expenditures are down $37,533, or 42.06%, from last year due to the vacant Events Assistant position, and the fact that all events year-to-date have been cancelled because of the COVID-19 pandemic. Hotel/Motel Tax Fund expenditures are down $19,184, or 24.23%, due to the cancellation of events that were scheduled to receive these monies. Expenses for the Wenatchee Valley Museum are currently coming out of the General Fund, but those will be moved to this fund by year-end as approved by the Lodging Tax Advisory Committee. Street Improvements Fund expenditures are up $860,019, or 147.76%, from last year due to the Complete Streets, and Safe Routes to School projects currently underway, and the 3rd Street/Highline roundabout project. Most of these projects are grant funded and reimbursed. Capital Improvements Fund expenditures are down $585,277, or 91.81%, from last year due to the expenses related to the Gateway project in 2019, and no planned projects funded out of this fund in 2020. Storm Water Fund expenditures are up $759,993 from last year because this is a new fund that the City is accounting for due to a terminated Interlocal Agreement with Douglas County for storm water services. Prior to 2020, these expenditures were accounted for in the Street Fund. The reports presented in the following pages represent accounting system generated line-item details of revenues, expenditures, budgets, and cash balances for each fund through August 31, 2020. 7 of 26 Account Number Title Period Fiscal Budget % of Total Balance General Fund Taxes 001-000-000-311-10-00-00 Real & Personal Property Tax $15,748.43 $636,190.11 $1,245,000.00 51.10 %$608,809.89 001-000-000-313-11-00-00 Local Retail Sales & Use Tax $354,642.47 $1,876,832.46 $3,500,000.00 53.62 %$1,623,167.54 001-000-000-313-27-00-00 Affordable & Supportive Housing Sales/Use Tax $38.51 $38.51 $0.00 ($38.51) 001-000-000-313-71-00-00 Criminal Justice Sales Tax $34,636.45 $206,997.11 $300,000.00 69.00 %$93,002.89 001-000-000-316-40-00-00 Electric Utility Tax $24,192.13 $242,402.68 $355,000.00 68.28 %$112,597.32 001-000-000-316-45-00-00 Natural Gas Utility Tax $2,007.41 $31,948.14 $35,000.00 91.28 %$3,051.86 001-000-000-316-49-00-00 Phone/Cellular Utility Tax $39,381.36 $173,398.12 $350,000.00 49.54 %$176,601.88 001-000-000-316-84-00-00 Gambling Tax $65,045.12 $214,156.94 $345,000.00 62.07 %$130,843.06 Total Taxes $535,691.88 $3,381,964.07 $6,130,000.00 55.17 %$2,748,035.93 Licenses and Permits 001-000-000-321-30-01-00 Fireworks Permits $0.00 $300.00 $500.00 60.00 %$200.00 001-000-000-321-60-00-00 Taxicab Licenses & Permits $37.00 $260.00 $800.00 32.50 %$540.00 001-000-000-321-91-00-50 Franchise Fees - Cable $0.00 $47,483.66 $97,000.00 48.95 %$49,516.34 001-000-000-321-99-00-00 Business Licenses & Permits $9,865.93 $73,738.53 $107,100.00 68.85 %$33,361.47 001-000-000-321-99-05-00 Other Business Lic & Permits $0.00 $660.00 $650.00 101.54 %($10.00) 001-000-000-322-10-00-00 Building & Structure Permits $1,541.75 $68,281.74 $50,000.00 136.56 %($18,281.74) 001-000-000-322-90-01-00 Gun Permits $755.00 $3,422.25 $6,500.00 52.65 %$3,077.75 001-000-000-322-90-02-00 Sign Permits $0.00 $0.00 $100.00 0.00 %$100.00 Total Licenses and Permits $12,199.68 $194,146.18 $262,650.00 73.92 %$68,503.82 Intergovernmental Revenues 001-000-000-333-16-50-00 Columbia River Drug Task Force $0.00 $7,541.50 $7,500.00 100.55 %($41.50) 001-000-000-334-01-20-00 WaState Court Equip Reimb $300.00 $300.00 $0.00 ($300.00) 001-000-000-334-03-10-00 Dept. of Ecology SMP Grant $0.00 $0.00 $16,800.00 0.00 %$16,800.00 001-000-000-334-03-51-00 Traffic Safety Commission Grt $0.00 $3,548.12 $0.00 ($3,548.12) 001-000-000-334-03-51-03 TSC - Seatbelt Emphasis Patrols $0.00 $0.00 $1,000.00 0.00 %$1,000.00 001-000-000-334-03-51-04 X-52 TSC-Speed Limit Emphasis $0.00 $0.00 $2,000.00 0.00 %$2,000.00 001-000-000-334-03-51-10 Distracted Driving Enforcement Patrol $0.00 $0.00 $2,000.00 0.00 %$2,000.00 001-000-000-334-03-51-12 TSC - DUI Emphasis Patrol $0.00 $1,692.24 $2,750.00 61.54 %$1,057.76 001-000-000-334-04-20-05 Dept. of Commerce Grant $0.00 $0.00 $15,920.00 0.00 %$15,920.00 001-000-000-334-06-91-00 WA ST Office of Public Defense $0.00 $20,000.00 $20,000.00 100.00 %$0.00 001-000-000-334-06-95-00 RIVERCOM 911 Funding Assistance $0.00 $19,714.23 $21,000.00 93.88 %$1,285.77 001-000-000-335-00-91-00 PUD Privilege Tax $45,460.25 $45,460.25 $42,000.00 108.24 %($3,460.25) 001-000-000-336-00-98-03 City Assistance $0.00 $18,799.51 $0.00 ($18,799.51) 001-000-000-336-06-42-00 Marijuana Excise Tax Distribution $0.00 $16,174.09 $21,000.00 77.02 %$4,825.91 Revenue Starting Account Number: 001-000-000-308-00-00-00 Beginning Net Cash & Invest Ending Account Number: 501-000-000-397-21-00-20 Transfer In - Criminal Justice Period: 2020 - August 2020 8 of 26 Account Number Title Period Fiscal Budget % of Total Balance 001-000-000-336-06-51-00 DUI - Cities Allocation $0.00 $1,446.04 $2,000.00 72.30 %$553.96 001-000-000-336-06-94-00 Liquor Excise Tax $0.00 $62,289.38 $75,000.00 83.05 %$12,710.62 001-000-000-336-06-95-00 Liquor Board Profits $0.00 $55,026.75 $107,500.00 51.19 %$52,473.25 Total Intergovernmental Revenues $45,760.25 $251,992.11 $336,470.00 74.89 %$84,477.89 Charges for Goods and Services 001-000-000-341-33-10-00 Background Check Fees $0.00 $0.00 $60.00 0.00 %$60.00 001-000-000-341-35-30-00 Duplicating Services - Court & Police $0.00 $0.00 $500.00 0.00 %$500.00 001-000-000-341-35-31-00 Copy and Duplication Fees - Admin $0.00 $0.00 $200.00 0.00 %$200.00 001-000-000-341-35-33-00 Recording and Filing Fees $0.00 $0.00 $75.00 0.00 %$75.00 001-000-000-341-35-35-00 Annual Admin Reimb Fees $0.00 $5,000.00 $6,000.00 83.33 %$1,000.00 001-000-000-342-33-00-00 Adult Probation Services $2,939.53 $34,412.18 $70,000.00 49.16 %$35,587.82 001-000-000-342-36-00-00 Housing of Prisoners $532.59 $6,679.96 $25,000.00 26.72 %$18,320.04 001-000-000-342-40-00-01 Fire Marshall Inspection Services $97.00 $3,729.00 $5,000.00 74.58 %$1,271.00 001-000-000-345-83-00-00 Plan Checking Fees $701.51 $33,973.24 $25,000.00 135.89 %($8,973.24) 001-000-000-345-83-41-00 Engineering Review Fees $0.00 $1,026.78 $800.00 128.35 %($226.78) 001-000-000-345-86-00-00 Sepa Permits $0.00 $976.00 $500.00 195.20 %($476.00) 001-000-000-345-89-00-00 Planning & Development Fees $0.00 $5,266.00 $7,500.00 70.21 %$2,234.00 Total Charges for Goods and Services $4,270.63 $91,063.16 $140,635.00 64.75 %$49,571.84 Fines and Penalties 001-000-000-356-50-00-00 Fines And Penalties $6,938.48 $94,719.75 $190,000.00 49.85 %$95,280.25 001-000-000-357-33-00-00 Public Defender Costs $610.30 $9,378.53 $25,000.00 37.51 %$15,621.47 001-000-000-357-35-00-00 Restitution $0.00 $500.00 $150.00 333.33 %($350.00) Total Fines and Penalties $7,548.78 $104,598.28 $215,150.00 48.62 %$110,551.72 Miscellaneous Revenues 001-000-000-361-11-00-00 Interest Earnings $1,763.99 $40,727.36 $100,000.00 40.73 %$59,272.64 001-000-000-361-40-00-00 Sales Tax Interest $307.13 $3,893.22 $5,000.00 77.86 %$1,106.78 001-000-000-362-00-00-00 Rental Income - 311 9th St NE $1,146.26 $9,262.15 $10,000.00 92.62 %$737.85 001-000-000-369-80-00-00 Cash Adjustments $0.00 $6.05 $0.00 ($6.05) 001-000-000-369-91-50-00 Miscellaneous Revenue $205.15 $342.65 $7,500.00 4.57 %$7,157.35 Total Miscellaneous Revenues $3,422.53 $54,231.43 $122,500.00 44.27 %$68,268.57 Other Increases in Fund Resources 001-000-000-389-30-00-03 Fireworks - Cleaning Deposit $0.00 $2,500.00 $2,200.00 113.64 %($300.00) 001-000-000-389-30-00-04 Fireworks - Dcfd Remittance $0.00 $300.00 $250.00 120.00 %($50.00) 001-000-000-389-30-00-05 Crime Victim Assessment $125.14 $1,694.91 $3,500.00 48.43 %$1,805.09 001-000-000-389-30-00-10 State Surcharge $131.50 $727.50 $500.00 145.50 %($227.50) 001-000-000-389-30-00-15 State Share Weapons Permit Fee $1,435.50 $5,853.00 $9,500.00 61.61 %$3,647.00 001-000-000-389-30-00-20 Court Remittance - State $7,375.48 $95,764.86 $200,000.00 47.88 %$104,235.14 Total Other Increases in Fund Resources $9,067.62 $106,840.27 $215,950.00 49.47 %$109,109.73 Other Financing Sources 001-000-000-395-10-00-00 Proceeds - Disposition of Assets $0.00 $12,489.80 $100.00 12,489.80 %($12,389.80) 001-000-000-395-20-00-00 Insurance Recoveries - Capital Assets $0.00 $0.00 $1,000.00 0.00 %$1,000.00 001-000-000-398-10-00-00 Insurance Recoveries $0.00 $34,991.36 $0.00 ($34,991.36) Total Other Financing Sources $0.00 $47,481.16 $1,100.00 4,316.47 %($46,381.16) Total General Fund $617,961.37 $4,232,316.66 $7,424,455.00 57.01 %$3,192,138.34 9 of 26 Account Number Title Period Fiscal Budget % of Total Balance Street Fund 101-000-000-311-10-00-00 Property Taxes - Street Dept $0.00 $291,901.23 $400,000.00 72.98 %$108,098.77 101-000-000-313-11-00-00 Sales & Use Tax $0.00 $300,000.00 $300,000.00 100.00 %$0.00 101-000-000-322-40-00-00 Street Permits $250.00 $1,787.00 $3,000.00 59.57 %$1,213.00 101-000-000-336-00-71-00 Multi-Modal Distribution $0.00 $9,344.92 $18,000.00 51.92 %$8,655.08 101-000-000-336-00-87-00 Gas Tax $19,693.60 $149,619.24 $275,000.00 54.41 %$125,380.76 101-000-000-336-00-87-05 Increased Gas Tax $0.00 $8,176.90 $16,000.00 51.11 %$7,823.10 101-000-000-369-91-01-05 Miscellaneous Revenue $0.00 $725.13 $0.00 ($725.13) 101-000-000-395-20-00-00 Insurance Recoveries - Capital Assets $0.00 $4,420.81 $0.00 ($4,420.81) Total Street Fund $19,943.60 $765,975.23 $1,012,000.00 75.69 %$246,024.77 Community Development Grants Fund 102-000-000-331-14-00-00 HUD CD Block Grant $0.00 $12,892.81 $219,619.00 5.87 %$206,726.19 Total Community Development Grants Fund $0.00 $12,892.81 $219,619.00 5.87 %$206,726.19 Transportation Benefit District Fund 105-000-000-317-60-00-00 Car Tab Fees $19,206.00 $165,983.40 $40,000.00 414.96 %($125,983.40) Total Transportation Benefit District Fund $19,206.00 $165,983.40 $40,000.00 414.96 %($125,983.40) Library Fund 112-000-000-347-20-00-00 Library Services $0.00 $3,500.00 $7,000.00 50.00 %$3,500.00 Total Library Fund $0.00 $3,500.00 $7,000.00 50.00 %$3,500.00 Hotel/Motel Tax Fund 113-000-000-313-31-02-00 Hotel/Motel Tax $19,919.20 $150,944.19 $250,000.00 60.38 %$99,055.81 Total Hotel/Motel Tax Fund $19,919.20 $150,944.19 $250,000.00 60.38 %$99,055.81 Drug Fund 114-000-000-356-50-03-00 Drug Investigation $0.57 $11.37 $100.00 11.37 %$88.63 114-000-000-369-30-00-00 Confiscated/forfeited Property $0.00 $0.00 $0.00 $0.00 Total Drug Fund $0.57 $11.37 $100.00 11.37 %$88.63 Criminal Justice Fund 116-000-000-336-06-21-00 Criminal Justice - Population $0.00 $3,187.09 $3,700.00 86.14 %$512.91 116-000-000-336-06-26-00 Criminal Justice - Special Programs $0.00 $11,417.14 $14,000.00 81.55 %$2,582.86 Total Criminal Justice Fund $0.00 $14,604.23 $17,700.00 82.51 %$3,095.77 Events Board Fund 117-000-100-397-00-00-00 Transfer-In from Fund 113 $0.00 $50,000.00 $135,000.00 37.04 %$85,000.00 117-000-200-347-40-02-01 Easter Egg Hunt Admission Fees $0.00 $0.00 $1,400.00 0.00 %$1,400.00 117-000-300-347-40-12-02 Classy Chassis Parade/Car Show $0.00 $145.00 $9,000.00 1.61 %$8,855.00 117-000-300-347-40-12-03 Classy Chassis Vendor Fees $0.00 $50.00 $150.00 33.33 %$100.00 117-000-300-347-90-00-12 Classy Chassis Sponsorships $0.00 $0.00 $8,000.00 0.00 %$8,000.00 117-000-300-347-90-12-00 Classy Chassis Merchandise Sales $0.00 $0.00 $500.00 0.00 %$500.00 117-000-400-347-40-11-03 Wings & Wheels Car Show Registration $0.00 $125.00 $4,500.00 2.78 %$4,375.00 117-000-400-347-40-11-07 Wings & Wheels Vendor Fees $0.00 $0.00 $100.00 0.00 %$100.00 117-000-400-347-90-00-11 Wings & Wheels Sponsorships $0.00 $0.00 $12,000.00 0.00 %$12,000.00 117-000-400-347-90-11-00 Wings & Wheels Merchandise Sales $0.00 $0.00 $500.00 0.00 %$500.00 117-000-450-347-90-00-12 Parkway Pile-Up Car Show Sponsorships $0.00 $0.00 $500.00 0.00 %$500.00 117-000-500-367-19-00-01 Christmas Sponsorships $0.00 $0.00 $2,000.00 0.00 %$2,000.00 10 of 26 Account Number Title Period Fiscal Budget % of Total Balance Total Events Board Fund $0.00 $50,320.00 $173,650.00 28.98 %$123,330.00 Bond Redemption Fund 202-000-000-311-10-00-00 Property Tax $0.00 $100,000.00 $155,000.00 64.52 %$55,000.00 202-000-000-397-00-00-00 Transfer-In from Fund 110 $0.00 $0.00 $660,000.00 0.00 %$660,000.00 Total Bond Redemption Fund $0.00 $100,000.00 $815,000.00 12.27 %$715,000.00 Street Improvements Fund 301-000-000-311-10-00-00 Property Tax $0.00 $20,000.00 $20,000.00 100.00 %$0.00 301-000-000-333-20-00-13 STP 9th/VMP Intersection $7,765.27 $13,467.83 $901,700.00 1.49 %$888,232.17 301-000-000-334-03-60-01 SRTS - 5th St NE: Sterling $39,376.68 $39,376.68 $220,224.00 17.88 %$180,847.32 301-000-000-334-03-60-02 SRTS - 5th St NE: Kenroy $32,458.72 $32,458.72 $225,778.00 14.38 %$193,319.28 301-000-000-334-03-80-08 TIB 3rd St SE/Highline Drive Roundabout $150,000.00 $419,557.31 $663,000.00 63.28 %$243,442.69 301-000-000-334-03-80-13 TIB N Kentucky Ave Overlay $0.00 $0.00 $637,500.00 0.00 %$637,500.00 301-000-000-334-03-80-15 TIB 3rd/Rock Island Rd. Traffic Signal $0.00 $0.00 $76,500.00 0.00 %$76,500.00 301-000-000-334-04-20-02 PWTFL - 10th Street Design $0.00 $164,737.29 $315,000.00 52.30 %$150,262.71 301-000-000-360-00-00-00 Miscellaneous Revenue $0.00 $110.00 $0.00 ($110.00) 301-000-000-361-10-00-00 Interest Earnings $0.00 $86.63 $0.00 ($86.63) 301-000-000-397-41-10-05 Transfer-In from Fund 105 $0.00 $0.00 $375,000.00 0.00 %$375,000.00 301-000-000-397-95-00-20 Transfer-In from Fund 314 $0.00 $0.00 $150,000.00 0.00 %$150,000.00 Total Street Improvements Fund $229,600.67 $689,794.46 $3,584,702.00 19.24 %$2,894,907.54 Capital Improvements Fund 314-000-000-318-34-00-00 Real Estate Excise Tax $47,167.14 $343,968.35 $350,000.00 98.28 %$6,031.65 314-000-000-361-11-00-00 Interest Earnings $0.00 $6.25 $0.00 ($6.25) 314-000-000-391-10-00-00 LTGO Bond Proceeds $0.00 $0.00 $5,000,000.00 0.00 %$5,000,000.00 Total Capital Improvements Fund $47,167.14 $343,974.60 $5,350,000.00 6.43 %$5,006,025.40 Stormwater Fund 401-000-000-334-03-10-00 Dept. of Ecology Capacity Grant $95,000.00 $95,000.00 $95,000.00 100.00 %$0.00 401-000-000-334-03-10-01 19th St. Ecology Grant $4,564.00 $66,647.59 $170,000.00 39.20 %$103,352.41 401-000-000-337-00-00-00 Transfer-In from Douglas Co.$0.00 $2,567,670.57 $2,500,000.00 102.71 %($67,670.57) 401-000-000-343-10-00-00 SWU Fee $27,605.60 $519,505.10 $518,000.00 100.29 %($1,505.10) 401-000-000-361-00-00-00 Interest Earnings $0.00 $266.67 $0.00 ($266.67) 401-000-000-397-00-00-00 Transfer-In from Fund 308 $0.00 $66,058.66 $103,090.00 64.08 %$37,031.34 Total Stormwater Fund $127,169.60 $3,315,148.59 $3,386,090.00 97.90 %$70,941.41 Equipment Purchase, Repair & Replacement Fund 501-000-000-313-11-00-10 Sales & Use Tax - Police $0.00 $50,000.00 $50,000.00 100.00 %$0.00 501-000-000-313-11-00-20 Sales & Use Tax - Streets $0.00 $300,000.00 $300,000.00 100.00 %$0.00 501-000-000-395-20-00-00 Insurance Recoveries - Police Vehicles $0.00 $22,072.50 $0.00 ($22,072.50) Total Equipment Purchase, Repair & Replacement Fund $0.00 $372,072.50 $350,000.00 106.31 %($22,072.50) Grand Totals $1,080,968.15 $10,217,538.04 $22,630,316.00 45.15 %$12,412,777.96 11 of 26 Totals By Fund Fund Number Title Period Fiscal Budget % of Total Balance 001-000-000-000-00-00-00 General Fund $617,961.37 $4,232,316.66 $7,424,455.00 57.01 %$3,192,138.34 101-000-000-000-00-00-00 Street Fund $19,943.60 $765,975.23 $1,012,000.00 75.69 %$246,024.77 102-000-000-000-00-00-00 Community Development Grants Fund $0.00 $12,892.81 $219,619.00 5.87 %$206,726.19 105-000-000-000-00-00-00 Transportation Benefit District Fund $19,206.00 $165,983.40 $40,000.00 414.96 %($125,983.40) 112-000-000-000-00-00-00 Library Fund $0.00 $3,500.00 $7,000.00 50.00 %$3,500.00 113-000-000-000-00-00-00 Hotel/Motel Tax Fund $19,919.20 $150,944.19 $250,000.00 60.38 %$99,055.81 114-000-000-000-00-00-00 Drug Fund $0.57 $11.37 $100.00 11.37 %$88.63 116-000-000-000-00-00-00 Criminal Justice Fund $0.00 $14,604.23 $17,700.00 82.51 %$3,095.77 117-000-000-000-00-00-00 Events Board Fund $0.00 $50,320.00 $173,650.00 28.98 %$123,330.00 202-000-000-000-00-00-00 Bond Redemption Fund $0.00 $100,000.00 $815,000.00 12.27 %$715,000.00 301-000-000-000-00-00-00 Street Improvements Fund $229,600.67 $689,794.46 $3,584,702.00 19.24 %$2,894,907.54 314-000-000-000-00-00-00 Capital Improvements Fund $47,167.14 $343,974.60 $5,350,000.00 6.43 %$5,006,025.40 401-000-000-000-00-00-00 Stormwater Fund $127,169.60 $3,315,148.59 $3,386,090.00 97.90 %$70,941.41 501-000-000-000-00-00-00 Equipment Purchase, Repair & Replacement Fund $0.00 $372,072.50 $350,000.00 106.31 %($22,072.50) Grand Totals $1,080,968.15 $10,217,538.04 $22,630,316.00 45.15 %$12,412,777.96 12 of 26 Account Number Title Period Fiscal Budget % of Total Balance General Fund General Government 001-000-001-518-20-40-00 Property Management - 311 9th St NE $0.00 $7.45 $0.00 ($7.45) 001-000-001-518-90-40-00 GWATA Membership $0.00 $0.00 $300.00 0.00 %$300.00 001-000-001-518-91-30-00 Wellness $137.49 $649.99 $3,000.00 21.67 %$2,350.01 001-000-001-518-93-49-00 City Theme $0.00 $0.00 $750.00 0.00 %$750.00 001-000-001-521-10-29-00 LEOFF 1 Insurance Premiums $2,227.50 $17,820.00 $27,500.00 64.80 %$9,680.00 001-000-001-528-70-40-00 River Com $25,380.31 $203,042.48 $365,000.00 55.63 %$161,957.52 001-000-001-539-30-40-00 Animal Control $6,126.24 $49,009.92 $73,515.00 66.67 %$24,505.08 001-000-001-558-60-41-00 Chelan-Douglas Transportation Council $0.00 $13,928.00 $13,928.00 100.00 %$0.00 001-000-001-558-70-40-00 Contributions - Region $21,337.00 $41,337.00 $45,000.00 91.86 %$3,663.00 001-000-001-558-70-41-00 NCW Economic Development District $0.00 $0.00 $1,250.00 0.00 %$1,250.00 001-000-001-558-70-41-05 NCWEDD Chelan/Douglas Trends $0.00 $1,500.00 $1,500.00 100.00 %$0.00 001-000-001-558-70-41-07 Wenatchee Valley Chamber of Commerce $0.00 $360.00 $360.00 100.00 %$0.00 001-000-001-558-70-41-10 Spirit of Wenatchee Miss Veedol $0.00 $3,000.00 $3,000.00 100.00 %$0.00 001-000-001-558-70-41-15 Wenatchee Valley Museum $10,124.00 $80,992.00 $121,488.00 66.67 %$40,496.00 001-000-001-564-00-40-00 Comm Mental Health (2% Liquor)$973.10 $2,845.93 $3,600.00 79.05 %$754.07 Total General Government $66,305.64 $414,492.77 $660,191.00 62.78 %$245,698.23 Legislative 001-000-110-511-60-10-00 Salaries $11,404.94 $137,481.47 $197,000.00 69.79 %$59,518.53 001-000-110-511-60-20-00 Benefits $3,476.63 $36,037.98 $60,000.00 60.06 %$23,962.02 001-000-110-511-60-21-50 Public Defender $11,645.46 $90,118.22 $135,000.00 66.75 %$44,881.78 001-000-110-511-60-30-00 Public Defender Conflicts $277.50 $2,280.00 $5,500.00 41.45 %$3,220.00 001-000-110-511-60-31-00 Office Supplies $58.64 $830.08 $300.00 276.69 %($530.08) 001-000-110-511-60-31-05 Newsletter Printing & Mailing $0.00 $3,991.82 $10,500.00 38.02 %$6,508.18 001-000-110-511-60-31-10 Public Records Expenses $0.00 $53.59 $200.00 26.80 %$146.41 001-000-110-511-60-40-00 Training $0.00 $114.81 $3,000.00 3.83 %$2,885.19 001-000-110-511-60-41-00 Professional Services $5,431.25 $52,828.43 $42,000.00 125.78 %($10,828.43) 001-000-110-511-60-41-20 AWC Annual Membership Fee $0.00 $9,967.00 $10,000.00 99.67 %$33.00 001-000-110-511-60-42-01 Cell Phone $0.00 $244.95 $500.00 48.99 %$255.05 001-000-110-511-60-43-00 Travel $0.00 $391.84 $1,500.00 26.12 %$1,108.16 001-000-110-511-60-43-01 Travel - Misawa $0.00 $0.00 $4,750.00 0.00 %$4,750.00 001-000-110-511-60-44-00 Advertising $0.00 $503.30 $2,000.00 25.17 %$1,496.70 001-000-110-511-60-45-00 Election Costs - Registered Voters $0.00 $6,257.57 $22,000.00 28.44 %$15,742.43 001-000-110-511-60-46-00 Insurance $36.35 $271.27 $13,000.00 2.09 %$12,728.73 001-000-110-511-60-47-00 Background Check Costs $0.00 $77.00 $200.00 38.50 %$123.00 001-000-110-511-60-49-00 Miscellaneous $287.29 $2,158.76 $5,000.00 43.18 %$2,841.24 Expenditure Starting Account Number: 001-000-001-518-20-40-00 Property Management - 311 9th St NE Ending Account Number: 501-001-000-508-80-00-00 Ending EPM&R Fund Balance - Unreserved Period: 2020 - August 2020 13 of 26 Account Number Title Period Fiscal Budget % of Total Balance Total Legislative $32,618.06 $343,608.09 $512,450.00 67.05 %$168,841.91 Municipal Court 001-000-120-512-50-10-00 Salaries $18,323.40 $141,144.52 $199,000.00 70.93 %$57,855.48 001-000-120-512-50-12-00 Salaries - Probation Services $4,730.63 $37,384.64 $55,000.00 67.97 %$17,615.36 001-000-120-512-50-20-00 Benefits $5,630.15 $44,947.54 $74,000.00 60.74 %$29,052.46 001-000-120-512-50-22-00 Benefits - Probation Services $2,964.86 $23,887.08 $41,000.00 58.26 %$17,112.92 001-000-120-512-50-31-00 Office Supplies $0.00 $1,051.12 $1,500.00 70.07 %$448.88 001-000-120-512-50-40-00 Training $0.00 $690.00 $1,500.00 46.00 %$810.00 001-000-120-512-50-43-00 Travel $0.00 $2,005.13 $6,000.00 33.42 %$3,994.87 001-000-120-512-50-46-00 Insurance $72.69 $861.11 $13,860.00 6.21 %$12,998.89 001-000-120-512-50-49-00 Miscellaneous $0.00 $179.08 $0.00 ($179.08) 001-000-120-512-50-49-01 Interpreting $0.00 $435.00 $5,000.00 8.70 %$4,565.00 001-000-120-512-50-49-02 Judge Protems $75.00 $1,125.00 $4,000.00 28.13 %$2,875.00 001-000-120-512-50-49-03 Witness Fees $0.00 $59.90 $500.00 11.98 %$440.10 001-000-120-512-50-49-04 Juror Fees $0.00 $1,199.98 $2,000.00 60.00 %$800.02 001-000-120-512-50-49-09 Security $406.25 $2,033.25 $6,000.00 33.89 %$3,966.75 001-000-120-594-12-60-00 Capital Outlay $278.19 $1,964.52 $5,000.00 39.29 %$3,035.48 Total Municipal Court $32,481.17 $258,967.87 $414,360.00 62.50 %$155,392.13 City Clerk 001-000-140-514-20-10-00 Salaries $7,017.81 $52,728.24 $78,000.00 67.60 %$25,271.76 001-000-140-514-20-20-00 Benefits $4,485.32 $25,275.81 $42,000.00 60.18 %$16,724.19 001-000-140-514-20-31-00 Office Supplies $0.00 $759.62 $3,000.00 25.32 %$2,240.38 001-000-140-514-20-31-01 Central Stores $263.18 $6,597.38 $5,000.00 131.95 %($1,597.38) 001-000-140-514-20-40-00 Training $35.00 $70.00 $2,000.00 3.50 %$1,930.00 001-000-140-514-20-41-00 Membership Dues & Publications $478.88 $942.88 $1,200.00 78.57 %$257.12 001-000-140-514-20-43-00 Travel $0.00 $231.60 $2,500.00 9.26 %$2,268.40 001-000-140-514-20-44-00 Advertising $373.63 $924.00 $2,000.00 46.20 %$1,076.00 001-000-140-514-20-46-00 Insurance $24.23 $648.16 $8,800.00 7.37 %$8,151.84 001-000-140-514-20-48-00 Repairs & Maintenance $0.00 $0.00 $250.00 0.00 %$250.00 001-000-140-514-20-49-00 Miscellaneous $0.00 $58.58 $750.00 7.81 %$691.42 001-000-140-514-30-20-00 Records Services $0.00 $461.00 $1,000.00 46.10 %$539.00 001-000-140-514-30-25-00 Codification $0.00 $777.42 $2,100.00 37.02 %$1,322.58 Total City Clerk $12,678.05 $89,474.69 $148,600.00 60.21 %$59,125.31 Internal Services 001-000-141-514-20-31-01 Office Machine Costs $101.28 $1,619.46 $14,000.00 11.57 %$12,380.54 001-000-141-514-20-42-01 Telephone Line Charges $1,348.86 $7,454.76 $14,000.00 53.25 %$6,545.24 001-000-141-514-20-42-03 Postage $24.54 $5,040.19 $7,000.00 72.00 %$1,959.81 001-000-141-514-20-48-00 Repairs & Maintenance $769.20 $6,953.23 $3,000.00 231.77 %($3,953.23) Total Internal Services $2,243.88 $21,067.64 $38,000.00 55.44 %$16,932.36 Finance 001-000-142-514-20-10-00 Salaries $13,534.14 $151,052.66 $210,000.00 71.93 %$58,947.34 001-000-142-514-20-20-00 Benefits $5,705.63 $54,748.00 $95,000.00 57.63 %$40,252.00 001-000-142-514-20-31-00 Office Supplies $0.00 $1,039.14 $1,700.00 61.13 %$660.86 001-000-142-514-20-43-00 Travel $0.00 $106.26 $1,000.00 10.63 %$893.74 001-000-142-514-20-46-00 Insurance $36.35 $1,495.48 $9,680.00 15.45 %$8,184.52 14 of 26 Account Number Title Period Fiscal Budget % of Total Balance 001-000-142-514-23-20-00 State Audit $0.00 $0.00 $18,000.00 0.00 %$18,000.00 001-000-142-514-25-30-00 Bank Charges & Fees $539.47 $2,658.02 $5,000.00 53.16 %$2,341.98 001-000-142-514-40-20-00 Training $120.00 $245.00 $2,000.00 12.25 %$1,755.00 Total Finance $19,935.59 $211,344.56 $342,380.00 61.73 %$131,035.44 Information Technology 001-000-145-514-20-10-00 Salaries $7,949.86 $63,892.94 $96,000.00 66.56 %$32,107.06 001-000-145-514-20-20-00 Benefits $3,663.64 $29,282.53 $50,000.00 58.57 %$20,717.47 001-000-145-514-20-31-00 Supplies $0.00 $134.32 $1,000.00 13.43 %$865.68 001-000-145-514-20-40-01 Memberships $0.00 $75.00 $100.00 75.00 %$25.00 001-000-145-514-20-40-05 Disaster Backup System Support $0.00 $25,000.00 $25,000.00 100.00 %$0.00 001-000-145-514-20-40-10 Annual Fee - ESRI GIS System License $0.00 $2,057.70 $1,100.00 187.06 %($957.70) 001-000-145-514-20-40-20 Annual License - Spillman, NetMotion & Ragnasoft $1,225.00 $16,997.28 $20,645.00 82.33 %$3,647.72 001-000-145-514-20-40-30 Annual Fee - Vision Financial Software $0.00 $5,908.32 $6,000.00 98.47 %$91.68 001-000-145-514-20-40-35 Annual License Fee - Evidence.com $0.00 $2,635.27 $7,000.00 37.65 %$4,364.73 001-000-145-514-20-40-40 Annual Subscription - Granicus $0.00 $594.64 $7,000.00 8.49 %$6,405.36 001-000-145-514-20-40-50 Annual License - FTR Recording System $0.00 $0.00 $1,500.00 0.00 %$1,500.00 001-000-145-514-20-40-55 Annual Support & Maintenance - Laserfiche $0.00 $10,430.76 $9,800.00 106.44 %($630.76) 001-000-145-514-20-40-60 Service Package - Laserfiche (Legal, Police, & Planning) $0.00 $3,462.40 $8,000.00 43.28 %$4,537.60 001-000-145-514-20-41-00 Professional Services $1,307.69 $8,645.58 $5,000.00 172.91 %($3,645.58) 001-000-145-514-20-42-00 Cell Phone $0.00 $464.96 $750.00 61.99 %$285.04 001-000-145-514-20-43-00 Training $0.00 $0.00 $4,000.00 0.00 %$4,000.00 001-000-145-514-20-44-00 Travel $0.00 $0.00 $4,000.00 0.00 %$4,000.00 001-000-145-514-20-45-00 Insurance $24.23 $615.91 $0.00 ($615.91) 001-000-145-514-20-49-00 Miscellaneous $0.00 $515.20 $0.00 ($515.20) 001-000-145-594-14-60-20 Capital - PC Software Admin $6,179.90 $22,861.38 $20,000.00 114.31 %($2,861.38) 001-000-145-594-14-60-25 Capital - PC Hardware Admin $781.17 $28,076.08 $50,000.00 56.15 %$21,923.92 Total Information Technology $21,131.49 $221,650.27 $316,895.00 69.94 %$95,244.73 Legal 001-000-151-515-31-10-00 Salaries $16,183.20 $116,939.68 $195,000.00 59.97 %$78,060.32 001-000-151-515-31-20-00 Benefits $6,652.03 $47,966.81 $104,000.00 46.12 %$56,033.19 001-000-151-515-31-20-10 Training $0.00 $300.00 $2,000.00 15.00 %$1,700.00 001-000-151-515-31-25-00 Professional Services $0.00 $10,418.00 $1,500.00 694.53 %($8,918.00) 001-000-151-515-31-25-10 Licensing $0.00 $0.00 $1,000.00 0.00 %$1,000.00 001-000-151-515-31-31-00 Office Supplies $0.00 $225.95 $300.00 75.32 %$74.05 001-000-151-515-31-42-03 Postage $0.00 $28.93 $0.00 ($28.93) 001-000-151-515-31-43-00 Travel $0.00 $0.00 $2,000.00 0.00 %$2,000.00 001-000-151-515-31-46-00 Insurance $24.23 $56.48 $12,100.00 0.47 %$12,043.52 001-000-151-515-31-49-00 Miscellaneous $123.14 $832.14 $3,000.00 27.74 %$2,167.86 001-000-151-515-35-25-05 Litigation Expenses $0.00 $0.00 $10,000.00 0.00 %$10,000.00 Total Legal $22,982.60 $176,767.99 $330,900.00 53.42 %$154,132.01 Civil Service 15 of 26 Account Number Title Period Fiscal Budget % of Total Balance 001-000-160-521-10-10-00 Salaries $260.00 $1,820.00 $3,214.00 56.63 %$1,394.00 001-000-160-521-10-46-00 Insurance $24.23 $56.48 $7,150.00 0.79 %$7,093.52 Total Civil Service $284.23 $1,876.48 $10,364.00 18.11 %$8,487.52 Central Services 001-000-180-518-30-31-01 Central Stores $17.98 $313.07 $0.00 ($313.07) 001-000-180-518-30-31-06 Cleaning & Sanitation Supplies $368.87 $2,348.70 $2,000.00 117.44 %($348.70) 001-000-180-518-30-35-00 Small Tools & Equipment $0.00 $625.26 $10,000.00 6.25 %$9,374.74 001-000-180-518-30-41-00 Professional Services $1,015.58 $6,960.58 $25,000.00 27.84 %$18,039.42 001-000-180-518-30-41-01 Contracted Custodial Services $2,426.74 $18,103.62 $24,000.00 75.43 %$5,896.38 001-000-180-518-30-46-00 Insurance $48.46 $112.95 $47,300.00 0.24 %$47,187.05 001-000-180-518-30-47-00 Utilities $1,353.91 $16,386.55 $25,000.00 65.55 %$8,613.45 001-000-180-518-30-48-00 Repairs & Maintenance $58.85 $4,578.94 $12,000.00 38.16 %$7,421.06 001-000-180-518-30-49-00 Miscellaneous $0.00 $18.93 $2,000.00 0.95 %$1,981.07 001-000-180-518-30-49-01 Landscaping $0.00 $380.85 $12,000.00 3.17 %$11,619.15 001-000-180-518-61-41-00 Judgements & Settlements $0.00 $0.00 $10,000.00 0.00 %$10,000.00 001-000-180-518-92-20-00 Ancillary (Interfund Maintenance)$611.35 $5,572.81 $6,000.00 92.88 %$427.19 001-000-180-594-18-60-00 Capital Outlay $0.00 $3,783.42 $22,000.00 17.20 %$18,216.58 Total Central Services $5,901.74 $59,185.68 $197,300.00 30.00 %$138,114.32 Law Enforcement 001-000-210-521-10-10-00 Salaries $167,366.75 $1,516,038.35 $2,100,000.00 72.19 %$583,961.65 001-000-210-521-10-10-02 Overtime Salaries $7,648.55 $89,152.01 $175,000.00 50.94 %$85,847.99 001-000-210-521-10-10-03 Overtime Salaries - Traffic Control $0.00 $555.26 $8,000.00 6.94 %$7,444.74 001-000-210-521-10-20-00 Benefits $54,469.33 $496,162.99 $900,000.00 55.13 %$403,837.01 001-000-210-521-10-20-01 Clothing Allowance $0.00 $4,919.47 $14,400.00 34.16 %$9,480.53 001-000-210-521-10-31-00 Office Supplies $91.44 $2,947.71 $8,500.00 34.68 %$5,552.29 001-000-210-521-10-31-05 Office Machine Costs $306.39 $2,194.23 $5,000.00 43.88 %$2,805.77 001-000-210-521-10-32-00 Fuel Consumed $3,262.85 $23,232.60 $52,000.00 44.68 %$28,767.40 001-000-210-521-10-35-00 Small Tools & Equipment $2,287.15 $13,950.48 $13,000.00 107.31 %($950.48) 001-000-210-521-10-35-02 WASPC Traffic Safety Grant $0.00 $3,575.53 $3,000.00 119.18 %($575.53) 001-000-210-521-10-35-05 Bulletproof Vests $0.00 $0.00 $4,000.00 0.00 %$4,000.00 001-000-210-521-10-35-06 US Marshall Fugitive Task Force $0.00 $0.00 $1,500.00 0.00 %$1,500.00 001-000-210-521-10-41-00 Professional Services $3,221.85 $12,192.46 $15,000.00 81.28 %$2,807.54 001-000-210-521-10-42-01 Telephone $363.64 $15,201.95 $28,000.00 54.29 %$12,798.05 001-000-210-521-10-42-03 Postage $115.65 $509.95 $1,200.00 42.50 %$690.05 001-000-210-521-10-43-00 Travel $0.00 $1,751.96 $22,000.00 7.96 %$20,248.04 001-000-210-521-10-46-00 Insurance $533.12 $3,294.23 $69,000.00 4.77 %$65,705.77 001-000-210-521-10-48-00 Repairs & Maintenance $257.04 $1,711.12 $8,000.00 21.39 %$6,288.88 001-000-210-521-10-49-00 Miscellaneous $0.00 $2,167.95 $5,500.00 39.42 %$3,332.05 001-000-210-521-10-49-01 Reserves $0.00 $0.00 $500.00 0.00 %$500.00 001-000-210-521-10-49-02 Dry Cleaning Services $15.16 $162.43 $1,500.00 10.83 %$1,337.57 001-000-210-521-30-40-00 Crime Prevention $0.00 $850.00 $850.00 100.00 %$0.00 001-000-210-521-40-22-00 Training - Police Chief $0.00 ($390.00)$1,000.00 -39.00 %$1,390.00 001-000-210-521-40-25-00 Training - Officers $0.00 $3,129.00 $9,000.00 34.77 %$5,871.00 001-000-210-521-40-27-00 Training - Office Staff $0.00 $0.00 $900.00 0.00 %$900.00 001-000-210-521-40-30-00 Training - Academy $0.00 $530.31 $9,600.00 5.52 %$9,069.69 16 of 26 Account Number Title Period Fiscal Budget % of Total Balance 001-000-210-521-50-10-00 Ancillary (Interfund Vehicle Maintenance) $0.00 $0.00 $2,400.00 0.00 %$2,400.00 001-000-210-521-50-49-00 Other Services $0.00 $0.00 $1,500.00 0.00 %$1,500.00 001-000-210-594-21-60-00 Capital Outlay $0.00 $92,512.23 $33,000.00 280.34 %($59,512.23) Total Law Enforcement $239,938.92 $2,286,352.22 $3,493,350.00 65.45 %$1,206,997.78 Jail Services 001-000-230-523-21-10-00 Housing & Monitoring Prisoners $0.00 $203,199.38 $378,000.00 53.76 %$174,800.62 001-000-230-523-60-20-00 Medical Care - Prisoners $0.00 $482.00 $10,000.00 4.82 %$9,518.00 001-000-230-527-60-30-00 Juvenile Detention $0.00 $2,040.00 $6,500.00 31.38 %$4,460.00 Total Jail Services $0.00 $205,721.38 $394,500.00 52.15 %$188,778.62 001-000-310-531-30-44-00 Swu - Maint - Advertising $0.00 $19.08 $0.00 ($19.08) 001-000-310-531-30-45-00 Swu Maintenance Rentals/leases $0.00 $23.68 $0.00 ($23.68) Public Works 001-000-315-542-10-10-00 Salaries $7,810.12 $62,492.34 $94,000.00 66.48 %$31,507.66 001-000-315-542-10-20-00 Benefits $3,493.42 $27,859.07 $46,000.00 60.56 %$18,140.93 001-000-315-542-10-31-00 Office Supplies $0.00 $0.00 $750.00 0.00 %$750.00 001-000-315-542-10-35-00 Small Tools & Equipment $0.00 $0.00 $500.00 0.00 %$500.00 001-000-315-542-10-40-00 Cell Phone $0.00 $354.55 $750.00 47.27 %$395.45 001-000-315-542-10-43-00 Travel $0.00 $0.00 $1,000.00 0.00 %$1,000.00 001-000-315-542-10-46-00 Insurance $24.23 $56.48 $11,000.00 0.51 %$10,943.52 001-000-315-542-10-49-00 Training $0.00 $227.00 $2,000.00 11.35 %$1,773.00 001-000-315-542-10-49-01 Miscellaneous $0.00 $0.00 $1,000.00 0.00 %$1,000.00 001-000-315-542-10-49-10 Memberships $0.00 $0.00 $500.00 0.00 %$500.00 001-000-315-544-20-45-00 Engineering Support Services $227.55 $3,181.12 $15,000.00 21.21 %$11,818.88 Total Public Works $11,555.32 $94,170.56 $172,500.00 54.59 %$78,329.44 Planning 001-000-580-558-60-10-00 Salaries $14,837.74 $119,038.20 $179,500.00 66.32 %$60,461.80 001-000-580-558-60-20-00 Benefits $5,062.88 $40,519.27 $62,000.00 65.35 %$21,480.73 001-000-580-558-60-31-00 Office Supplies $618.72 $8,519.37 $1,000.00 851.94 %($7,519.37) 001-000-580-558-60-32-00 Fuel Consumed $0.00 $43.36 $200.00 21.68 %$156.64 001-000-580-558-60-35-00 Small Tools & Equipment $0.00 $0.00 $100.00 0.00 %$100.00 001-000-580-558-60-40-00 Training $0.00 $20.00 $2,000.00 1.00 %$1,980.00 001-000-580-558-60-41-00 Professional Services $0.00 $0.00 $25,000.00 0.00 %$25,000.00 001-000-580-558-60-41-01 Hearings Examiner $0.00 $0.00 $600.00 0.00 %$600.00 001-000-580-558-60-41-02 Engineer/Architect Services $0.00 $0.00 $1,200.00 0.00 %$1,200.00 001-000-580-558-60-43-00 Travel $0.00 $0.00 $3,000.00 0.00 %$3,000.00 001-000-580-558-60-44-00 Advertising $130.05 $917.28 $3,500.00 26.21 %$2,582.72 001-000-580-558-60-46-00 Insurance $48.46 $112.95 $11,440.00 0.99 %$11,327.05 001-000-580-558-60-48-00 Repairs & Maintenance $0.00 $8.27 $100.00 8.27 %$91.73 001-000-580-558-60-49-00 Miscellaneous $0.00 $915.00 $2,200.00 41.59 %$1,285.00 Total Planning $20,697.85 $170,093.70 $291,840.00 58.28 %$121,746.30 Code Compliance 001-000-590-558-50-10-00 Salaries $8,766.79 $70,047.24 $111,000.00 63.11 %$40,952.76 001-000-590-558-50-20-00 Benefits $4,265.38 $34,227.61 $56,000.00 61.12 %$21,772.39 001-000-590-558-50-31-00 Office Supplies $0.00 $71.67 $2,200.00 3.26 %$2,128.33 17 of 26 Account Number Title Period Fiscal Budget % of Total Balance 001-000-590-558-50-32-00 Fuel Consumed $32.95 $217.35 $460.00 47.25 %$242.65 001-000-590-558-50-35-00 Small Tools & Equipment $0.00 $0.00 $100.00 0.00 %$100.00 001-000-590-558-50-40-00 Training $0.00 $0.00 $300.00 0.00 %$300.00 001-000-590-558-50-41-01 Fire Marshal Services $0.00 $10,291.74 $21,500.00 47.87 %$11,208.26 001-000-590-558-50-42-00 Abatement $0.00 $0.00 $30,000.00 0.00 %$30,000.00 001-000-590-558-50-43-00 Travel $0.00 $0.00 $475.00 0.00 %$475.00 001-000-590-558-50-46-00 Insurance $24.23 $56.48 $8,690.00 0.65 %$8,633.52 001-000-590-558-50-48-00 Repairs & Maintenance $0.00 $37.91 $0.00 ($37.91) 001-000-590-558-50-49-00 Miscellaneous $0.00 $95.00 $300.00 31.67 %$205.00 Total Code Compliance $13,089.35 $115,045.00 $231,025.00 49.80 %$115,980.00 Other Expenditures 001-001-000-589-30-00-03 Fireworks - Deposit Refund $0.00 $1,000.00 $2,500.00 40.00 %$1,500.00 001-001-000-589-30-00-04 Fireworks - DCFD Remittance $0.00 $250.00 $500.00 50.00 %$250.00 001-001-000-589-30-00-05 County Share of Crime Victims $618.90 $2,121.33 $4,000.00 53.03 %$1,878.67 001-001-000-589-30-00-10 Remittance: State Building Code Surcharge $124.50 $596.00 $500.00 119.20 %($96.00) 001-001-000-589-30-00-15 State Share of Permits & Licenses $1,076.00 $4,666.00 $11,500.00 40.57 %$6,834.00 001-001-000-589-30-00-20 Court Remittances $10,204.24 $88,316.40 $211,000.00 41.86 %$122,683.60 Total Other Expenditures $12,023.64 $96,949.73 $230,000.00 42.15 %$133,050.27 Total General Fund $513,867.53 $4,766,811.39 $7,784,655.00 61.23 %$3,017,843.61 Street Fund Storm Water Administration 101-000-311-542-42-10-00 SWU Administration - Salaries $0.00 $1,703.52 $0.00 ($1,703.52) 101-000-311-542-42-20-00 SWU Administration - Benefits $0.00 ($288.52)$0.00 $288.52 Total Storm Water Administration $0.00 $1,415.00 $0.00 ($1,415.00) NPDES 101-000-313-542-42-10-00 NPDES Maintenance Salaries $0.00 $269.47 $0.00 ($269.47) 101-000-313-542-42-10-10 NPDES Sweeping Salaries $0.00 $641.61 $0.00 ($641.61) 101-000-313-542-42-20-00 NPDES Maintenance Benefits $0.00 $801.54 $0.00 ($801.54) 101-000-313-542-42-20-10 NPDES Sweeping Benefits $0.00 $322.24 $0.00 ($322.24) Total NPDES $0.00 $2,034.86 $0.00 ($2,034.86) 101-000-420-542-30-10-00 Salaries - Roadway $14,320.88 $38,722.30 $80,000.00 48.40 %$41,277.70 101-000-420-542-30-20-00 Benefits - Roadway $6,503.02 $23,219.89 $53,000.00 43.81 %$29,780.11 101-000-420-542-30-30-00 Supplies - Roadway $436.37 $33,507.00 $50,000.00 67.01 %$16,493.00 101-000-420-542-30-48-00 Repairs & Maintenance - Roadway $812.63 $6,902.44 $6,000.00 115.04 %($902.44) 101-000-420-542-61-10-00 Salaries - Sidewalks $250.04 $299.27 $4,500.00 6.65 %$4,200.73 101-000-420-542-61-20-00 Benefits - Sidewalks $51.29 $97.14 $2,400.00 4.05 %$2,302.86 101-000-420-542-61-30-00 Supplies - Sidewalks $0.00 $0.00 $2,000.00 0.00 %$2,000.00 101-000-420-542-61-48-00 Repairs & Maintenance - Sidewalks $0.00 $0.00 $3,000.00 0.00 %$3,000.00 101-000-420-542-62-10-00 Salaries - Special Purpose Paths $173.82 $498.82 $500.00 99.76 %$1.18 101-000-420-542-62-20-00 Benefits - Special Purpose Paths $107.98 $204.75 $250.00 81.90 %$45.25 101-000-420-542-62-30-00 Supplies - Special Purpose Paths $0.00 $0.00 $2,500.00 0.00 %$2,500.00 101-000-420-542-63-10-00 Salaries - Street Lighting $95.62 $546.46 $2,000.00 27.32 %$1,453.54 101-000-420-542-63-20-00 Benefits - Street Lighting $19.60 $174.53 $1,200.00 14.54 %$1,025.47 18 of 26 Account Number Title Period Fiscal Budget % of Total Balance 101-000-420-542-63-30-00 Supplies - Street Lighting $25.09 $71.69 $500.00 14.34 %$428.31 101-000-420-542-63-47-00 Utilities - Street Lighting $1,732.00 $16,725.18 $60,000.00 27.88 %$43,274.82 101-000-420-542-63-48-00 Repairs & Maintenance - Street Lighting $0.00 $0.00 $5,000.00 0.00 %$5,000.00 101-000-420-542-64-10-00 Salaries - Traffic Control Devices $792.66 $47,305.32 $40,000.00 118.26 %($7,305.32) 101-000-420-542-64-20-00 Benefits - Traffic Control Devices $579.03 $27,388.43 $23,000.00 119.08 %($4,388.43) 101-000-420-542-64-30-00 Supplies - Traffic Control Devices $0.00 $28,144.59 $48,000.00 58.63 %$19,855.41 101-000-420-542-64-47-00 Utilities - Traffic Control Devices $553.45 $3,942.01 $9,000.00 43.80 %$5,057.99 101-000-420-542-64-48-00 Repairs & Maintenance - Traffic Control Devices $0.00 $226.41 $14,000.00 1.62 %$13,773.59 101-000-420-542-65-10-00 Salaries - Parking Facilities $0.00 $371.18 $1,000.00 37.12 %$628.82 101-000-420-542-65-20-00 Benefits - Parking Facilities $0.00 $347.05 $500.00 69.41 %$152.95 101-000-420-542-65-30-00 Supplies - Parking Facilities $0.00 $0.00 $300.00 0.00 %$300.00 101-000-420-542-65-47-00 Utilities - Parking Facilities $0.00 $270.00 $500.00 54.00 %$230.00 101-000-420-542-66-10-00 Salaries - Snow & Ice Control $0.00 $9,313.30 $70,000.00 13.30 %$60,686.70 101-000-420-542-66-20-00 Benefits - Snow & Ice Control $0.00 $5,999.65 $47,000.00 12.77 %$41,000.35 101-000-420-542-66-30-00 Supplies - Snow & Ice Control $0.00 $42,428.00 $100,000.00 42.43 %$57,572.00 101-000-420-542-66-48-00 Repairs & Maintenance - Snow & Ice Control $0.00 $2,082.97 $5,000.00 41.66 %$2,917.03 101-000-420-542-69-10-00 Salaries - Flags/Banners $0.00 $1,783.91 $30,000.00 5.95 %$28,216.09 101-000-420-542-69-20-00 Benefits - Flags/Banners $0.00 $653.00 $25,000.00 2.61 %$24,347.00 101-000-420-542-69-30-00 Supplies - Flags/Banners $0.00 $825.93 $2,000.00 41.30 %$1,174.07 101-000-420-542-70-10-00 Salaries - Roadside $13,045.31 $120,911.26 $180,000.00 67.17 %$59,088.74 101-000-420-542-70-20-00 Benefits - Roadside $6,922.29 $62,520.45 $94,000.00 66.51 %$31,479.55 101-000-420-542-70-30-00 Supplies - Roadside $0.00 $613.86 $5,000.00 12.28 %$4,386.14 101-000-420-542-70-41-00 Professional Services - Roadside $0.00 $0.00 $3,000.00 0.00 %$3,000.00 101-000-420-542-70-47-00 Utilities - Roadside $0.00 $796.20 $1,000.00 79.62 %$203.80 101-000-420-542-70-48-00 Repairs & Maintenance - Roadside $0.00 $0.00 $1,000.00 0.00 %$1,000.00 101-000-420-542-75-10-00 Salaries - City Parks $3,642.34 $42,490.26 $45,000.00 94.42 %$2,509.74 101-000-420-542-75-20-00 Benefits - City Parks $1,935.99 $21,341.95 $23,000.00 92.79 %$1,658.05 101-000-420-542-75-30-00 Supplies - City Parks $406.35 $1,560.44 $15,000.00 10.40 %$13,439.56 101-000-420-542-75-47-00 Utilities - City Parks $64.00 $3,576.61 $4,000.00 89.42 %$423.39 101-000-420-542-75-48-00 Repairs & Maintenance - City Parks $580.55 $1,660.26 $4,000.00 41.51 %$2,339.74 101-000-420-542-80-48-00 Japanese Garden Agreement $0.00 $6,000.00 $18,000.00 33.33 %$12,000.00 101-000-420-542-90-10-00 Salaries - Maintenance Admin $0.00 $1,416.24 $0.00 ($1,416.24) 101-000-420-542-90-20-00 Benefits - Maintenance Admin $0.00 $487.27 $0.00 ($487.27) 101-000-430-543-30-10-00 Salaries - General Services $1,996.27 $16,046.76 $0.00 ($16,046.76) 101-000-430-543-30-20-00 Benefits - General Services $855.32 $6,449.71 $0.00 ($6,449.71) 101-000-430-543-30-30-00 Supplies - General Services $284.98 $5,371.37 $6,000.00 89.52 %$628.63 101-000-430-543-30-46-00 Insurance $203.16 $532.65 $54,000.00 0.99 %$53,467.35 101-000-430-543-30-49-00 Miscellaneous - General Services $0.00 $1,048.26 $3,000.00 34.94 %$1,951.74 101-000-430-543-50-10-00 Salaries - Facilities $0.00 $1,742.92 $3,000.00 58.10 %$1,257.08 101-000-430-543-50-20-00 Benefits - Facilities $0.00 $696.43 $1,600.00 43.53 %$903.57 101-000-430-543-50-30-00 Supplies - Facilities $0.00 $0.00 $2,000.00 0.00 %$2,000.00 101-000-430-543-50-42-01 Cell Phone $0.00 $354.25 $750.00 47.23 %$395.75 101-000-430-543-50-47-00 Utilities - Facilities $106.66 $3,177.98 $6,000.00 52.97 %$2,822.02 101-000-430-543-50-48-00 Repairs & Maintenance - Facilities $287.00 $287.00 $2,500.00 11.48 %$2,213.00 19 of 26 Account Number Title Period Fiscal Budget % of Total Balance 101-000-430-544-90-10-00 Salaries - Training $0.00 $708.08 $6,500.00 10.89 %$5,791.92 101-000-430-544-90-20-00 Benefits - Training $0.00 $331.56 $3,872.00 8.56 %$3,540.44 101-000-430-544-90-30-00 Supplies - Training $0.00 $14.15 $500.00 2.83 %$485.85 101-000-430-544-90-35-00 Travel $0.00 $27.00 $4,000.00 0.68 %$3,973.00 101-000-430-544-90-49-01 Training $0.00 $1,348.99 $1,000.00 134.90 %($348.99) Total Street Fund $56,783.70 $597,012.99 $1,175,872.00 50.77 %$578,859.01 Community Development Grants Fund 102-000-000-558-70-40-00 CDBG Housing Program Costs $0.00 $0.00 $192,619.00 0.00 %$192,619.00 102-000-000-558-70-41-00 CDBG Professional Services $3,867.50 $18,105.00 $25,300.00 71.56 %$7,195.00 102-000-000-558-70-44-00 CDBG Advertising $504.24 $981.09 $1,600.00 61.32 %$618.91 102-000-000-558-70-49-00 CDBG Miscellaneous $0.00 $0.00 $100.00 0.00 %$100.00 Total Community Development Grants Fund $4,371.74 $19,086.09 $219,619.00 8.69 %$200,532.91 Transportation Benefit District Fund 105-000-000-595-90-60-00 StreetSaver Program $0.00 $1,500.00 $0.00 ($1,500.00) 105-000-000-597-91-00-00 Transfer-Out to Fund 301 $0.00 $0.00 $375,000.00 0.00 %$375,000.00 Total Transportation Benefit District Fund $0.00 $1,500.00 $375,000.00 0.40 %$373,500.00 Financing Reserves Fund 110-000-000-597-00-00-00 Transfer-Out to Fund 202 $0.00 $0.00 $660,000.00 0.00 %$660,000.00 Total Financing Reserves Fund $0.00 $0.00 $660,000.00 0.00 %$660,000.00 Library Fund 112-000-000-572-50-41-00 Facilities - Professional Services $0.00 $0.00 $2,000.00 0.00 %$2,000.00 112-000-000-572-50-47-00 Facilities - Utilities $142.17 $3,163.14 $4,000.00 79.08 %$836.86 112-000-000-572-50-49-00 Facilities - Supplies & Miscellaneous $0.00 $0.00 $40.00 0.00 %$40.00 Total Library Fund $142.17 $3,163.14 $6,040.00 52.37 %$2,876.86 Hotel/Motel Tax Fund 113-000-000-557-30-41-00 Sports Foundation - Special Olympics $0.00 $5,000.00 $0.00 ($5,000.00) 113-000-000-557-30-41-01 EMPD Winter Classic AAU Tournament $0.00 $5,000.00 $0.00 ($5,000.00) 113-000-000-557-30-41-10 Contributions to Other Entities $0.00 $0.00 $70,000.00 0.00 %$70,000.00 113-001-000-597-00-00-01 Transfer-Out to Fund 117 $0.00 $50,000.00 $135,000.00 37.04 %$85,000.00 Total Hotel/Motel Tax Fund $0.00 $60,000.00 $205,000.00 29.27 %$145,000.00 Events Board Fund 117-000-050-557-30-10-00 Salaries $2,096.01 $28,655.32 $78,000.00 36.74 %$49,344.68 117-000-050-557-30-20-00 Benefits $1,662.06 $16,472.15 $41,000.00 40.18 %$24,527.85 117-000-100-557-30-25-00 Marketing - Regional Tourism $0.00 $249.00 $3,000.00 8.30 %$2,751.00 117-000-100-557-30-32-00 Fuel $0.00 $0.00 $200.00 0.00 %$200.00 117-000-100-557-30-40-00 Training $0.00 $0.00 $2,000.00 0.00 %$2,000.00 117-000-100-557-30-41-00 Professional Services $12.95 $91.65 $600.00 15.28 %$508.35 117-000-100-557-30-42-00 Cell Phone $0.00 $434.36 $600.00 72.39 %$165.64 117-000-100-557-30-43-00 Travel $0.00 $0.00 $500.00 0.00 %$500.00 117-000-100-557-30-44-00 Advertising $0.00 $0.00 $500.00 0.00 %$500.00 117-000-105-557-30-40-00 Insurance $48.46 $287.95 $8,360.00 3.44 %$8,072.05 117-000-115-557-30-31-05 Office Supplies $0.00 $0.00 $1,000.00 0.00 %$1,000.00 117-000-200-557-30-35-02 Easter - Small Tools & Equipment $0.00 $0.00 $200.00 0.00 %$200.00 117-000-200-557-30-44-02 Easter - Advertising $0.00 $427.91 $500.00 85.58 %$72.09 20 of 26 Account Number Title Period Fiscal Budget % of Total Balance 117-000-200-557-30-46-02 Easter - Office Supplies $0.00 $0.00 $100.00 0.00 %$100.00 117-000-200-557-30-49-02 Easter - Miscellaneous $0.00 $1,805.35 $600.00 300.89 %($1,205.35) 117-000-300-557-30-35-12 CC - Small Tools & Equipment $0.00 $0.00 $500.00 0.00 %$500.00 117-000-300-557-30-41-12 CC - Professional Services $0.00 $259.68 $2,300.00 11.29 %$2,040.32 117-000-300-557-30-42-14 CC - Postage $0.00 $758.16 $500.00 151.63 %($258.16) 117-000-300-557-30-43-12 CC - EMPD Facility Fee $0.00 $0.00 $1,000.00 0.00 %$1,000.00 117-000-300-557-30-44-12 CC - Advertising $0.00 $1,438.20 $3,000.00 47.94 %$1,561.80 117-000-300-557-30-49-12 CC - Miscellaneous $0.00 $0.00 $2,000.00 0.00 %$2,000.00 117-000-400-557-30-35-11 W&W - Small Tools & Equipment $0.00 $0.00 $500.00 0.00 %$500.00 117-000-400-557-30-41-00 W&W - Professional Services $0.00 $0.00 $5,200.00 0.00 %$5,200.00 117-000-400-557-30-42-13 W&W - Postage $0.00 $0.00 $550.00 0.00 %$550.00 117-000-400-557-30-43-12 W&W - EMPD Facility Fee $0.00 $0.00 $1,000.00 0.00 %$1,000.00 117-000-400-557-30-44-11 W&W - Advertising $0.00 $749.00 $5,000.00 14.98 %$4,251.00 117-000-400-557-30-49-11 W&W - Miscellaneous $0.00 $0.00 $300.00 0.00 %$300.00 117-000-400-557-30-49-13 W&W - Schedule of Events Brochure $0.00 $0.00 $1,600.00 0.00 %$1,600.00 117-000-450-557-30-41-00 Parkway Pile-Up - Professional Services $0.00 $0.00 $600.00 0.00 %$600.00 117-000-450-557-30-44-12 Parkway Pile-Up - Advertising $0.00 $10.00 $500.00 2.00 %$490.00 117-000-450-557-30-49-01 Parkway Pile-Up - Miscellaneous $0.00 $0.00 $300.00 0.00 %$300.00 117-000-500-557-30-35-01 Christmas - Small Tools & Equipment $0.00 $61.64 $150.00 41.09 %$88.36 117-000-500-557-30-40-05 Christmas - Events & Decorations $0.00 $0.00 $10,000.00 0.00 %$10,000.00 117-000-500-557-30-41-01 Christmas - Professional Services $0.00 $0.00 $400.00 0.00 %$400.00 117-000-500-557-30-44-01 Christmas - Advertising $0.00 $0.00 $750.00 0.00 %$750.00 117-000-500-557-30-49-01 Christmas - Miscellaneous $0.00 $0.00 $500.00 0.00 %$500.00 Total Events Board Fund $3,819.48 $51,700.37 $173,810.00 29.75 %$122,109.63 Bond Redemption Fund 202-000-000-591-48-70-00 Principal - 2020 LTGO Bond (Public Works Area) $0.00 $0.00 $150,000.00 0.00 %$150,000.00 202-000-000-591-95-70-00 Principal - PWTFL 10th St. NE $0.00 $14,728.88 $125,000.00 11.78 %$110,271.12 202-000-000-591-95-71-05 Principal - PWTFL 11th St. NE $0.00 $29,712.48 $29,713.00 100.00 %$0.52 202-000-000-592-48-80-00 Interest - 2020 LTGO Bond (Public Works Area) $0.00 $0.00 $223,300.00 0.00 %$223,300.00 202-000-000-592-95-80-00 Interest - PWTFL 10th St. NE $0.00 $3,103.61 $7,500.00 41.38 %$4,396.39 202-000-000-592-95-89-05 Interest - PWTFL 11th St. NE $0.00 $297.12 $298.00 99.70 %$0.88 Total Bond Redemption Fund $0.00 $47,842.09 $535,811.00 8.93 %$487,968.91 Street Improvements Fund 301-000-000-595-10-40-01 Design 2020 TBD Paving $0.00 $3,687.16 $30,000.00 12.29 %$26,312.84 301-000-000-595-10-40-02 Design - TIB N. Kentucky Overlay $0.00 $0.00 $80,000.00 0.00 %$80,000.00 301-000-000-595-10-40-03 Design - TIB 3rd/Rock Island Rd. Traffic Signal $0.00 $0.00 $90,000.00 0.00 %$90,000.00 301-000-000-595-10-40-19 Design - TIB 3rd St SE/Highline Dr Roundabout $0.00 $5,135.04 $5,000.00 102.70 %($135.04) 301-000-000-595-10-40-23 Design - SRTS - 5th St NE: Sterling $0.00 $53,651.00 $259,087.00 20.71 %$205,436.00 301-000-000-595-10-40-24 Design - SRTS - 5th St NE: Kenroy $270.00 $44,605.48 $265,321.00 16.81 %$220,715.52 301-000-000-595-10-40-26 Design - PWTFL - 10th St $14,453.15 $84,945.53 $320,000.00 26.55 %$235,054.47 301-000-000-595-20-60-01 ROW - PWTFL -10th St. Design $9,664.87 $36,640.84 $78,000.00 46.98 %$41,359.16 301-000-000-595-30-40-41 SDC - TIB 3rd St/Highline Roundabout $18,992.80 $68,947.67 $75,000.00 91.93 %$6,052.33 21 of 26 Account Number Title Period Fiscal Budget % of Total Balance 301-000-000-595-30-60-00 Construction - TIB 3rd St/Highline Roundabout $0.00 $697,086.06 $700,000.00 99.58 %$2,913.94 301-000-000-595-30-60-01 SDC 2020 TBD Paving $0.00 $0.00 $20,000.00 0.00 %$20,000.00 301-000-000-595-30-60-02 Construction 2020 TBD Paving $0.00 $0.00 $325,000.00 0.00 %$325,000.00 301-000-000-595-30-60-03 SDC - TIB N. Kentucky Overlay $0.00 $0.00 $45,000.00 0.00 %$45,000.00 301-000-000-595-30-60-04 Construction - TIB N. Kentucky Overlay $0.00 $0.00 $625,000.00 0.00 %$625,000.00 301-000-000-595-61-60-00 TIB Complete Streets - Grant/Georgia Crossing $0.00 $36,449.82 $75,000.00 48.60 %$38,550.18 301-000-000-595-61-60-01 TIB Complete Streets - Grant/June Crossing $0.00 $172,225.88 $100,000.00 172.23 %($72,225.88) 301-000-000-595-61-60-02 TIB Complete Streets - 3rd St. Sidewalk $0.00 $212,689.94 $225,000.00 94.53 %$12,310.06 301-000-000-595-64-40-01 Design - 9th/VMP Intersection $0.00 $25,977.23 $156,400.00 16.61 %$130,422.77 301-000-000-595-64-60-00 SDC - 9th/VMP Intersection $0.00 $0.00 $93,100.00 0.00 %$93,100.00 301-000-000-595-64-60-01 Construction - 9th/VMP Intersection $0.00 $0.00 $795,000.00 0.00 %$795,000.00 Total Street Improvements Fund $43,380.82 $1,442,041.65 $4,361,908.00 33.06 %$2,919,866.35 Storm Water Improvements Fund 308-000-000-597-00-00-00 Transfer-Out to 401 Fund $0.00 $66,058.66 $103,090.00 64.08 %$37,031.34 308-000-312-595-40-20-00 Benefits - SWA Improvement Projects $0.00 $0.00 $0.00 $0.00 Total Storm Water Improvements Fund $0.00 $66,058.66 $103,090.00 64.08 %$37,031.34 Capital Improvements Fund 314-000-000-594-22-60-50 Maintenance Facilities Design $32,260.00 $49,816.78 $145,000.00 34.36 %$95,183.22 314-000-000-594-48-60-00 Maintenance Facilities Construction $0.00 $0.00 $2,500,000.00 0.00 %$2,500,000.00 314-000-000-594-59-60-01 Gateway Property Construction $0.00 $2,405.34 $0.00 ($2,405.34) 314-001-000-597-00-00-01 Transfer-Out to 301 Fund $0.00 $0.00 $150,000.00 0.00 %$150,000.00 Total Capital Improvements Fund $32,260.00 $52,222.12 $2,795,000.00 1.87 %$2,742,777.88 Stormwater Fund Stormwater Utility Admin 401-000-001-531-00-10-00 Salaries - Stormwater Admin $2,214.79 $17,717.86 $15,750.00 112.49 %($1,967.86) 401-000-001-531-00-20-00 Benefits - Stormwater Admin $795.17 $7,452.12 $6,300.00 118.29 %($1,152.12) 401-000-001-531-00-30-00 Supplies - Stormwater Admin $0.00 $0.00 $500.00 0.00 %$500.00 401-000-001-531-00-30-01 Small Tools & Equipment $0.00 $0.00 $1,000.00 0.00 %$1,000.00 401-000-001-531-00-40-00 Cell Phone $0.00 $354.55 $750.00 47.27 %$395.45 401-000-001-531-00-40-01 Fee Collection - Douglas Co.$0.00 $7,038.71 $8,500.00 82.81 %$1,461.29 401-000-001-531-00-40-02 Insurance $48.46 $367.92 $5,000.00 7.36 %$4,632.08 401-000-001-531-00-40-03 City Stormwater Utility Charge $0.00 $164,430.00 $165,000.00 99.65 %$570.00 401-000-001-531-00-40-04 Miscellaneous $61.25 $128.92 $0.00 ($128.92) 401-000-001-531-00-40-06 Travel - Stormwater Admin $0.00 $10.66 $0.00 ($10.66) Total Stormwater Utility Admin $3,119.67 $197,500.74 $202,800.00 97.39 %$5,299.26 NPDES Admin 401-000-002-531-00-10-01 Salaries - NPDES Admin $1,632.34 $12,943.03 $9,000.00 143.81 %($3,943.03) 401-000-002-531-00-20-01 Benefits - NPDES Admin $604.21 $4,660.96 $3,600.00 129.47 %($1,060.96) 401-000-002-531-00-40-02 Repairs & Maint. - NPDES Admin $0.00 $145.12 $0.00 ($145.12) 401-000-002-531-00-40-03 Aerial Pictometry - NPDES Admin $0.00 $3,749.24 $0.00 ($3,749.24) 401-000-002-531-00-40-04 Municipal Stormwater Permit Fee $0.00 $5,071.29 $8,000.00 63.39 %$2,928.71 Total NPDES Admin $2,236.55 $26,569.64 $20,600.00 128.98 %($5,969.64) 22 of 26 Account Number Title Period Fiscal Budget % of Total Balance NPDES Outreach 401-000-003-531-00-10-02 Salaries - NPDES Outreach $0.00 $0.00 $1,500.00 0.00 %$1,500.00 401-000-003-531-00-20-02 Benefits - NPDES Outreach $0.00 $0.00 $600.00 0.00 %$600.00 401-000-003-531-00-30-02 Supplies - NPDES Outreach $0.00 $0.00 $1,000.00 0.00 %$1,000.00 Total NPDES Outreach $0.00 $0.00 $3,100.00 0.00 %$3,100.00 NPDES Public Involvement 401-000-004-531-00-10-03 Salaries - NPDES Public Involvement $0.00 $0.00 $500.00 0.00 %$500.00 401-000-004-531-00-20-03 Benefits - NPDES Public Involvement $0.00 $0.00 $200.00 0.00 %$200.00 401-000-004-531-00-30-03 Supplies - NPDES Public Involvement $0.00 $0.00 $1,000.00 0.00 %$1,000.00 Total NPDES Public Involvement $0.00 $0.00 $1,700.00 0.00 %$1,700.00 NPDES IDDE 401-000-005-531-00-10-04 Salaries - NPDES IDDE $0.00 $30.43 $6,500.00 0.47 %$6,469.57 401-000-005-531-00-20-04 Benefits - NPDES IDDE $0.00 $15.35 $2,600.00 0.59 %$2,584.65 401-000-005-531-00-30-04 Supplies - NPDES IDDE $0.00 $0.00 $1,000.00 0.00 %$1,000.00 Total NPDES IDDE $0.00 $45.78 $10,100.00 0.45 %$10,054.22 NPDES Construction 401-000-006-531-00-10-05 Salaries - NPDES Construction $60.84 $699.66 $1,500.00 46.64 %$800.34 401-000-006-531-00-20-05 Benefits - NPDES Construction $12.47 $222.83 $600.00 37.14 %$377.17 Total NPDES Construction $73.31 $922.49 $2,100.00 43.93 %$1,177.51 NPDES Post Construction 401-000-007-531-00-10-06 Salaries - NPDES Post Construction $0.00 $136.89 $1,500.00 9.13 %$1,363.11 401-000-007-531-00-20-06 Benefits - NPDES Post Construction $0.00 $47.11 $600.00 7.85 %$552.89 Total NPDES Post Construction $0.00 $184.00 $2,100.00 8.76 %$1,916.00 NPDES PPGH 401-000-008-531-00-10-07 Salaries - NPDES PPGH $4,560.06 $30,227.86 $73,000.00 41.41 %$42,772.14 401-000-008-531-00-10-08 Salaries - Sweeping $2,945.19 $12,434.00 $12,000.00 103.62 %($434.00) 401-000-008-531-00-20-07 Benefits - NPDES PPGH $1,875.16 $16,951.14 $29,200.00 58.05 %$12,248.86 401-000-008-531-00-20-08 Benefits - Sweeping $2,239.42 $6,787.19 $4,800.00 141.40 %($1,987.19) 401-000-008-531-00-30-05 Supplies - NPDES PPGH $4,489.10 $10,383.82 $30,000.00 34.61 %$19,616.18 401-000-008-531-00-40-04 Repairs & Maint. - NPDES PPGH $106.50 $1,770.43 $0.00 ($1,770.43) 401-000-008-531-00-40-05 Rental Equipment $0.00 $0.00 $35,000.00 0.00 %$35,000.00 401-000-008-531-00-40-06 Utilities $0.00 $1,925.06 $2,200.00 87.50 %$274.94 Total NPDES PPGH $16,215.43 $80,479.50 $186,200.00 43.22 %$105,720.50 NPDES Monitoring 401-000-009-531-00-10-09 Salaries - NPDES Monitoring $0.00 $0.00 $1,000.00 0.00 %$1,000.00 401-000-009-531-00-20-09 Benefits - NPDES Monitoring $0.00 $0.00 $400.00 0.00 %$400.00 401-000-009-531-00-30-06 Supplies - NPDES Monitoring $0.00 $0.00 $100.00 0.00 %$100.00 Total NPDES Monitoring $0.00 $0.00 $1,500.00 0.00 %$1,500.00 Capital Outlay 401-000-010-594-31-60-00 Mechanical Sweeper $0.00 $336,652.16 $355,000.00 94.83 %$18,347.84 401-000-010-594-31-60-01 Storm Sewer Camera $0.00 $10,918.81 $15,000.00 72.79 %$4,081.19 401-000-010-594-31-60-03 Devon Pond $0.00 $0.00 $15,000.00 0.00 %$15,000.00 Total Capital Outlay $0.00 $347,570.97 $385,000.00 90.28 %$37,429.03 23 of 26 Account Number Title Period Fiscal Budget % of Total Balance 401-000-011-594-31-60-04 19th Stormwater Facility Design $0.00 $15,676.50 $130,000.00 12.06 %$114,323.50 401-000-012-594-31-60-05 Small Improvements Projects $2,850.00 $8,650.99 $100,000.00 8.65 %$91,349.01 401-000-013-531-00-40-08 Payment to Douglas Co. for PWTFL $0.00 $75,768.16 $76,000.00 99.69 %$231.84 401-000-014-531-00-40-07 Stormwater Comp Plan Update $5,256.42 $6,624.46 $150,000.00 4.42 %$143,375.54 401-000-015-594-31-60-02 ConTech Filter Design $0.00 $0.00 $50,000.00 0.00 %$50,000.00 401-000-016-594-31-60-06 VMP LID Landscape $0.00 $0.00 $20,000.00 0.00 %$20,000.00 Total Stormwater Fund $29,751.38 $759,993.23 $1,341,200.00 56.67 %$581,206.77 Equipment Purchase, Repair & Replacement Fund 501-000-000-521-10-10-00 Police Vehicle Repair Labor $434.85 $5,568.67 $5,000.00 111.37 %($568.67) 501-000-000-521-10-20-00 Police Vehicle Repair Benefits $194.80 $2,507.79 $2,600.00 96.45 %$92.21 501-000-000-521-10-48-00 Police Vehicle Repairs & Maintenance $5,465.12 $30,308.96 $30,000.00 101.03 %($308.96) 501-000-000-542-90-10-00 Street Vehicle Repair Labor $1,500.47 $12,401.21 $23,000.00 53.92 %$10,598.79 501-000-000-542-90-20-00 Street Vehicle Repair Benefits $882.77 $5,741.79 $12,000.00 47.85 %$6,258.21 501-000-000-542-90-48-20 Street Vehicle Repairs & Maintenance $721.97 $14,019.75 $31,000.00 45.23 %$16,980.25 501-000-000-542-90-48-25 Street Vehicle Repair Supplies $145.99 $2,953.17 $5,000.00 59.06 %$2,046.83 501-000-000-542-90-48-30 Street Equipment Repairs $163.20 $916.02 $1,600.00 57.25 %$683.98 501-000-000-594-21-60-00 Capital Outlay - Police Vehicles $0.00 $48,835.83 $58,500.00 83.48 %$9,664.17 501-000-000-594-42-60-20 Capital Outlay - Street Vehicles $0.00 $0.00 $8,000.00 0.00 %$8,000.00 501-000-000-594-42-60-30 Capital - Street Equipment $0.00 $131,116.90 $250,000.00 52.45 %$118,883.10 Total Equipment Purchase, Repair & Replacement Fund $9,509.17 $254,370.09 $426,700.00 59.61 %$172,329.91 Grand Totals $693,885.99 $8,121,801.82 $20,163,705.00 40.28 %$12,041,903.18 24 of 26 Totals By Fund Fund Number Title Period Fiscal Budget % of Total Balance 001-000-000-000-00-00-00 General Fund $513,867.53 $4,766,811.39 $7,784,655.00 61.23 %$3,017,843.61 101-000-000-000-00-00-00 Street Fund $56,783.70 $597,012.99 $1,175,872.00 50.77 %$578,859.01 102-000-000-000-00-00-00 Community Development Grants Fund $4,371.74 $19,086.09 $219,619.00 8.69 %$200,532.91 105-000-000-000-00-00-00 Transportation Benefit District Fund $0.00 $1,500.00 $375,000.00 0.40 %$373,500.00 110-000-000-000-00-00-00 Financing Reserves Fund $0.00 $0.00 $660,000.00 0.00 %$660,000.00 112-000-000-000-00-00-00 Library Fund $142.17 $3,163.14 $6,040.00 52.37 %$2,876.86 113-000-000-000-00-00-00 Hotel/Motel Tax Fund $0.00 $60,000.00 $205,000.00 29.27 %$145,000.00 117-000-000-000-00-00-00 Events Board Fund $3,819.48 $51,700.37 $173,810.00 29.75 %$122,109.63 202-000-000-000-00-00-00 Bond Redemption Fund $0.00 $47,842.09 $535,811.00 8.93 %$487,968.91 301-000-000-000-00-00-00 Street Improvements Fund $43,380.82 $1,442,041.65 $4,361,908.00 33.06 %$2,919,866.35 308-000-000-000-00-00-00 Storm Water Improvements Fund $0.00 $66,058.66 $103,090.00 64.08 %$37,031.34 314-000-000-000-00-00-00 Capital Improvements Fund $32,260.00 $52,222.12 $2,795,000.00 1.87 %$2,742,777.88 401-000-000-000-00-00-00 Stormwater Fund $29,751.38 $759,993.23 $1,341,200.00 56.67 %$581,206.77 501-000-000-000-00-00-00 Equipment Purchase, Repair & Replacement Fund $9,509.17 $254,370.09 $426,700.00 59.61 %$172,329.91 Grand Totals $693,885.99 $8,121,801.82 $20,163,705.00 40.28 %$12,041,903.18 25 of 26 Beginning Activity Ending August 2019 Variance Cash In Cash Ending Cash (Decrease)/Increase 001 $3,088,243.67 $4,235,575.24 $2,553,748.94 $2,804,854.37 ($251,105.43) 101 $225,970.94 $767,416.53 $394,933.18 $418,609.99 ($23,676.81) 102 $77,431.47 $12,892.81 $71,238.19 $18,027.37 $53,210.82 105 $334,569.98 $165,983.40 $499,053.38 $267,045.05 $232,008.33 110 $660,000.00 $0.00 $660,000.00 $495,000.00 $165,000.00 112 $12,079.33 $3,500.00 $12,416.19 $10,380.92 $2,035.27 113 $81,632.99 $150,944.19 $172,577.18 $107,318.83 $65,258.35 114 $1,514.77 $885.37 $1,526.14 $1,511.80 $14.34 116 $47,204.19 $14,604.23 $61,808.42 $42,374.22 $19,434.20 117 $52,972.21 $50,670.00 $51,591.84 $76,327.87 ($24,736.03) 202 $8,668.69 $100,000.00 $60,826.60 $8,668.69 $52,157.91 301 $940,019.68 $689,794.46 $187,772.49 $940,829.13 ($753,056.64) 308 $66,058.66 $0.00 $0.00 $76,638.36 ($76,638.36) 314 $1,076,863.08 $343,974.60 $1,368,615.56 $679,447.16 $689,168.40 401 $0.00 $3,315,148.59 $2,555,155.36 $0.00 $2,555,155.36 501 $121,658.96 $372,417.39 $239,361.37 $269,564.30 ($30,202.93) $6,794,888.62 $10,223,806.81 $8,890,624.84 $6,216,598.06 $2,674,026.78$8,128,070.59 Stormwater Fund $759,993.23 Equipment Purchase, Repair & Replacement Fund $254,714.98 Storm Water Improvements Fund $66,058.66 Capital Improvements Fund $52,222.12 Bond Redemption Fund $47,842.09 Street Improvements Fund $1,442,041.65 Criminal Justice Fund $0.00 Events Board Fund $52,050.37 Hotel/Motel Tax Fund $60,000.00 Drug Fund $874.00 Financing Reserves Fund $0.00 Library Fund $3,163.14 Community Development Grants Fund $19,086.09 Transportation Benefit District Fund $1,500.00 Cash and Investment Activity Period: 2020 - August 2020Fund Activity Street Fund $598,454.29 Out General Fund $4,770,069.97 26 of 26