Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My Public Portal
About
2022-08-18 NO meeting packet
Notice of CANCELLATION of Meeting CITY OF JEFFERSON Finance Committee Thursday, August 18, 2022 at 7:30 AM City Hall, 320 E. McCarty Street, Jefferson City, MO ~ Boone-Bancroft Room Memo To:Steve Crowell From:Shiela Pearre Date:August 5, 2022 Re:Sales Tax Revenues The City received the August 1% Sales Tax in the amount of $1,251,038 which is $292,741 more than projected for August. January through August overage is $802,486 (6.41%) in the General Fund. 1% General Sales Tax Receipt Actual Budget Period Receipts Projection1 Variance Nov-21 Jan-22 $1,023,976 $1,021,454 $2,523 Dec-21 Feb-22 $1,222,207 $956,778 $265,429 Jan-22 & Oct-Dec 21 Qtrly Mar-22 $1,103,825 $1,087,131 $16,694 Feb-22 Apr-22 $1,000,444 $917,291 $83,153 Mar-22 May-22 $981,749 $848,048 $133,701 Apr-22 & Jan-Mar 22 Qtrly Jun-22 $1,227,939 $1,199,514 $28,424 May-22 Jul-22 $1,109,974 $1,130,153 ($20,178) Jun-22 Aug-22 $1,251,038 $958,297 $292,741 Jul-22 & Apr-June 22 Qtrly Sep-22 $1,228,151 Aug-22 Oct-22 $1,071,005 Sep-22 Nov-22 $917,615 Oct-22 & Jul-Sept 22 Qtrly Dec-22 $1,186,039 Total Overage/Shortfall $8,921,152 $12,521,475 $802,486 1Budgeted based on 3-year average percentage 1/2% Capital Improvement Tax - Sales Tax G & H Receipt Actual Budget Period Receipts Projection2 Variance Nov-21 Jan-22 $509,721 $ 432,354 $77,367 Dec-21 Feb-22 $589,318 $ 404,978 $184,339 Jan-22 & Oct-Dec 21 Qtrly Mar-22 $534,222 $ 460,153 $74,069 Feb-22 Apr-22 $480,689 $ 388,264 $92,424 Mar-22 May-22 $475,930 $ 358,956 $116,975 Apr-22 & Jan-Mar 22 Qtrly Jun-22 $599,274 $ 507,722 $91,552 May-22 Jul-22 $547,456 $ 478,363 $69,093 Jun-22 Aug-22 $616,170 $ 405,621 $210,549 Jul-22 & Apr-June 22 Qtrly Sep-22 $ 519,843 Aug-22 Oct-22 $ 453,327 Sep-22 Nov-22 $ 388,401 Oct-22 & Jul-Sept 22 Qtrly Dec-22 $ 502,018 Total Overage/Shortfall $4,352,779 $5,300,000 $916,369 2Budgeted based on 3-year average percentage 1/2% Parks Sales Tax Receipt Actual Budget Period Receipts Projection3 Variance Nov-21 Jan-22 $509,721 $ 490,007 $19,714 Dec-21 Feb-22 $589,297 $ 458,981 $130,316 Jan-22 & Oct-Dec 21 Qtrly Mar-22 $534,624 $ 521,514 $13,110 Feb-22 Apr-22 $480,688 $ 440,038 $40,650 Mar-22 May-22 $475,930 $ 406,822 $69,109 Apr-22 & Jan-Mar 22 Qtrly Jun-22 $599,274 $ 575,425 $23,848 May-22 Jul-22 $547,054 $ 542,152 $4,903 Jun-22 Aug-22 $616,170 $ 459,710 $156,460 Jul-22 & Apr-June 22 Qtrly Sep-22 $ 589,163 Aug-22 Oct-22 $ 513,778 Sep-22 Nov-22 $ 440,194 Oct-22 & Jul-Sept 22 Qtrly Dec-22 $ 568,961 Total Overage/Shortfall $4,352,758 $6,006,745 $458,110 3Budgeted based on 3-year average percentage 1/4% Public Safety Tax Receipt Actual Budget Period Receipts Projection4 Variance Nov-21 Jan-22 $0 $ 0 $0 Dec-21 Feb-22 $0 $ 0 $0 Jan-22 & Oct-Dec 21 Qtrly Mar-22 $0 $ 0 $0 Feb-22 Apr-22 $0 $ 0 $0 Mar-22 May-22 $0 $ 0 $0 Apr-22 & Jan-Mar 22 Qtrly Jun-22 $194,549 $ 266,532 ($71,984) May-22 Jul-22 $239,893 $ 228,643 $11,250 Jun-22 Aug-22 $303,233 $ 204,799 $98,435 Jul-22 & Apr-June 22 Qtrly Sep-22 $ 251,717 Aug-22 Oct-22 $ 228,870 Sep-22 Nov-22 $ 199,698 Oct-22 & Jul-Sept 22 Qtrly Dec-22 $ 253,074 Total Overage/Shortfall $737,675 $1,633,333 $37,701 4Budgeted based on 7 of 12 months - $2,800,000 annual collections - using General Fund FY2021 monthly collection percentages Period Reporting Period Reporting Period Reporting Period Reporting City of Jefferson, Mo. - Account Analysis Account Name General Fund Sales Tax Rate:One percent (1%)Receipt Month: AUGUST 2022 Account Number 10-100-400010 Prior 5 years Monthly REPORTING PERIOD RECEIPT PERIOD 2015 2016 2017 2018 2019 2020 2021 2022 Average Nov January 944,619 929,179 1,083,570 884,259 1,071,917 1,049,305 986,180 1,023,976 act.1,015,046 Dec February 727,437 812,670 806,789 927,290 885,496 942,049 971,262 1,222,207 act.906,577 Jan & Oct-Dec Qtrly March 1,091,021 1,183,675 1,073,842 1,155,742 1,088,631 1,066,146 1,115,596 1,103,825 act.1,099,991 Feb April 1,059,943 893,024 843,561 986,714 892,285 949,276 895,779 1,000,444 act.913,523 Mar May 618,854 648,305 687,741 709,248 731,421 828,799 861,134 981,749 act.763,669 Apr & Jan-Mar Qtrly June 1,045,933 1,119,566 1,000,942 1,042,310 1,126,211 1,093,256 1,297,057 1,227,939 act.1,111,955 May July 963,280 1,012,207 1,154,051 1,117,038 979,846 1,139,419 1,112,675 1,109,974 act.1,100,606 Jun August 562,996 661,518 678,636 821,132 770,155 912,996 996,635 1,251,038 act.835,911 Jul & Apr-Jun Qtrly September 1,185,891 1,197,976 1,143,504 1,129,543 1,262,838 1,228,769 1,224,960 1,228,151 est.1,197,923 Aug October 918,839 903,829 883,215 879,331 875,539 1,020,452 1,113,777 1,071,005 est.954,463 Sept November 661,849 623,645 615,667 774,337 818,656 856,748 971,814 917,615 est.807,444 Oct & Jul-Sept Qtrly December 1,075,638 1,016,682 1,333,160 1,043,108 1,008,620 1,131,896 1,231,564 1,186,039 est.1,149,670 Actual to Date $ 10,856,302 $ 11,002,277 $ 11,304,678 $ 11,470,052 $ 11,511,614 $ 12,219,110 $ 12,778,432 $8,921,152 Estimated to Fiscal Year end (based on averages and on Budgeted amount)$4,402,810 Total Actual & Estimated $13,323,961 Less: Budget $12,521,475 Over (Under) Budget $802,486 1,023,976 2,246,183 3,350,008 4,350,452 5,332,201 6,560,139 7,670,114 8,921,152 1,021,454 1,978,232 3,065,363 3,982,653 4,830,701 6,030,216 7,160,368 8,118,666 9,346,817 10,417,822 11,335,437 12,521,475 500,000 1,000,000 1,500,000 2,000,000 2,500,000 3,000,000 3,500,000 4,000,000 4,500,000 5,000,000 5,500,000 6,000,000 6,500,000 7,000,000 7,500,000 8,000,000 8,500,000 9,000,000 9,500,000 10,000,000 10,500,000 11,000,000 11,500,000 12,000,000 12,500,000 13,000,000 13,500,000 Nov Dec Jan & Oct-Dec Qtrly Feb Mar Apr & Jan-Mar Qtrly May Jun Jul & Apr-Jun Qtrly Aug Sept Oct & Jul-Sept Qtrly REPORTING PERIOD YTD Actuals vs. YTD Budget Actual Budget Printed 8/5/2022 City of Jefferson, Mo. - Account Analysis Account Name Capital Imprs Sales Tax Rate:One-Half percent (½%)Receipt Month: AUGUST 2022 Account Number 45/46-100-400010 Prior 5 years Monthly REPORTING PERIOD RECEIPT PERIOD 2015 2016 2017 2018 2019 2020 2021 2022 Average Nov January 461,560 455,278 525,521 424,160 525,696 513,808 483,288 509,721 act.494,495 Dec February 362,597 405,543 402,964 444,476 427,711 458,324 473,674 589,318 act.441,430 Jan & Oct-Dec Qtrly March 511,685 563,056 506,597 575,894 527,714 518,493 542,898 534,222 act.534,319 Feb April 512,808 431,353 411,020 455,943 430,468 458,553 430,804 480,689 act.437,358 Mar May 308,247 322,957 340,162 340,740 351,775 402,202 430,383 475,930 act.373,052 Apr & Jan-Mar Qtrly June 496,466 539,529 489,008 508,225 554,062 537,105 626,235 599,274 act.542,927 May July 473,120 498,229 559,119 548,625 481,405 560,720 547,153 547,456 act.539,404 Jun August 280,733 330,112 338,618 393,512 372,416 443,962 487,128 616,170 act.407,127 Jul & Apr-Jun Qtrly September 565,296 570,134 542,457 545,731 615,998 597,489 596,853 519,843 est.579,706 Aug October 442,371 435,416 425,493 423,478 421,199 494,618 538,917 453,327 est.460,741 Sept November 330,393 310,506 307,281 374,512 395,311 415,079 469,176 388,401 est.392,272 Oct & Jul-Sept Qtrly December 515,478 494,218 652,070 510,228 495,454 558,134 604,664 502,018 est.564,110 Actual to Date $ 5,260,753 $ 5,356,330 $ 5,500,311 $ 5,545,522 $ 5,599,211 $ 5,958,488 $ 6,231,172 $4,352,779 Estimated to Fiscal Year end (based on averages and on Budgeted amount)$1,863,590 Total Actual & Estimated $6,216,369 Less: Budget $5,300,000 Over (Under) Budget $916,369 509,721 1,099,039 1,633,261 2,113,949 2,589,880 3,189,154 3,736,609 4,352,779 432,354 837,332 1,297,485 1,685,749 2,044,704 2,552,426 3,030,789 3,436,410 3,956,253 4,409,581 4,797,982 5,300,000 100,000 350,000 600,000 850,000 1,100,000 1,350,000 1,600,000 1,850,000 2,100,000 2,350,000 2,600,000 2,850,000 3,100,000 3,350,000 3,600,000 3,850,000 4,100,000 4,350,000 4,600,000 4,850,000 5,100,000 5,350,000 5,600,000 Nov Dec Jan & Oct-Dec Qtrly Feb Mar Apr & Jan-Mar Qtrly May Jun Jul & Apr-Jun Qtrly Aug Sept Oct & Jul-Sept Qtrly REPORTING PERIOD YTD Actuals vs. YTD Budget Actual Budget Printed 8/5/2022 City of Jefferson, Mo. - Account Analysis Account Name Parks Sales Tax Rate:One-Half percent (½%)Receipt Month: AUGUST 2022 Account Number 21-210-400010 Prior 5 years Monthly REPORTING PERIOD RECEIPT PERIOD 2015 2016 2017 2018 2019 2020 2021 2022 Average Nov January 461,472 455,239 525,521 424,192 $525,690 513,808 483,288 509,721 act.494,500 Dec February 362,371 405,543 395,217 450,479 $427,689 458,324 473,676 589,297 act.441,077 Jan & Oct-Dec Qtrly March 511,582 563,039 506,524 577,148 $527,588 518,493 542,898 534,624 act.534,530 Feb April 512,738 431,353 411,020 457,060 $430,459 458,632 430,808 480,688 act.437,596 Mar May 308,030 322,957 340,162 340,708 $350,479 402,202 430,383 475,930 act.372,787 Apr & Jan-Mar Qtrly June 496,386 539,529 489,008 508,266 $554,065 537,107 626,235 599,274 act.542,936 May July 473,038 498,229 559,115 548,639 $481,406 560,720 547,152 547,054 act.539,406 Jun August 280,513 330,112 338,470 393,578 $372,405 443,965 487,128 616,170 act.407,109 Jul & Apr-Jun Qtrly September 565,217 572,847 542,457 545,842 $616,012 597,492 596,854 589,163 est.579,731 Aug October 442,370 435,416 425,497 423,387 $421,199 494,618 538,913 513,778 est.460,723 Sept November 330,393 310,506 307,305 374,484 $395,311 415,079 469,176 440,194 est.392,271 Oct & Jul-Sept Qtrly December 515,368 494,218 652,101 510,220 $495,452 558,134 604,664 568,961 est.564,114 Actual to Date $ 5,259,477 $ 5,358,988 $ 5,492,397 $ 5,554,002 $ 5,597,755 $ 5,958,575 $ 6,231,173 $4,352,758 Estimated to Fiscal Year end (based on averages and on Budgeted amount)$2,112,096 Total Actual & Estimated $6,464,854 Less: Budget $6,006,745 Over (Under) Budget $458,110 509,721 1,099,018 1,633,642 2,114,330 2,590,261 3,189,534 3,736,589 4,352,758 490,007 948,988 1,470,502 1,910,540 2,317,362 2,892,787 3,434,939 3,894,649 4,483,812 4,997,590 5,437,783 6,006,745 100,000 350,000 600,000 850,000 1,100,000 1,350,000 1,600,000 1,850,000 2,100,000 2,350,000 2,600,000 2,850,000 3,100,000 3,350,000 3,600,000 3,850,000 4,100,000 4,350,000 4,600,000 4,850,000 5,100,000 5,350,000 5,600,000 5,850,000 6,100,000 6,350,000 Nov Dec Jan & Oct-Dec Qtrly Feb Mar Apr & Jan-Mar Qtrly May Jun Jul & Apr-Jun Qtrly Aug Sept Oct & Jul-Sept Qtrly REPORTING PERIOD YTD Actuals vs. YTD Budget Actual Budget Printed 8/5/2022 City of Jefferson, Mo. - Account Analysis Account Name Public Safety Rate:One-Quarter percent (1/4%)Receipt Month: AUGUST 2022 Account Number 55-100-400010 REPORTING PERIOD RECEIPT PERIOD 2022 Nov January 0 act. Dec February 0 act. Jan & Oct-Dec Qtrly March 0 act. Feb April 0 act. Mar May 0 act. Apr & Jan-Mar Qtrly June 194,549 act. May July 239,893 act. Jun August 303,233 act. Jul & Apr-Jun Qtrly September 251,717 est. Aug October 228,870 est. Sept November 199,698 est. Oct & Jul-Sept Qtrly December 253,074 est. Actual to Date $737,675 Estimated to Fiscal Year end (based on averages and on Budgete $933,359 Total Actual & Estimated $1,671,034 Less: Estimated Revenue $1,633,333 7 of 12 months - $2,800,000 annually Over (Under) Budget $37,701 194,549 434,442 737,675 266,532 495,176 699,974 951,691 1,180,561 1,380,259 1,633,333 100,000 350,000 600,000 850,000 1,100,000 1,350,000 1,600,000 1,850,000 Nov Dec Jan & Oct-Dec Qtrly Feb Mar Apr & Jan- Mar Qtrly May Jun Jul & Apr-Jun Qtrly Aug Sept Oct & Jul- Sept Qtrly REPORTING PERIOD YTD Actuals vs. YTD Budget Actual Budget Printed 8/5/2022 Revenue Model Report For the Period Ending July 31, 2022 Data as of August 17, 2022 FY 2022 YTD Actual Projected Over/ Description Budget As of 8/17 (Under) Budget Sales Tax and Use Tax $12,521,475.39 $8,921,151.58 $802,486.02 Intergovernmental Taxes $2,512,000.00 $1,753,946.29 $54,197.20 Other Taxes $96,000.00 $58,120.56 ($5,338.40) Franchise & Utility Tax $6,450,000.00 $3,977,082.66 $34,805.33 Property Taxes $5,709,659.76 $5,809,996.63 $174,640.77 Intergovernmental $4,990,917.60 $8,335.00 $8,335.00 Charges for Services $3,000,478.08 $2,694,395.39 $69,905.55 Fees, Licenses, & Permits $1,066,437.50 $792,338.08 ($57,671.83) Fines & Forfeitures $580,000.00 $307,897.40 ($152,399.21) Contributions/Donations $383,616.57 $314,970.83 $86,141.43 Other Operating Revenues $164,281.57 $161,366.54 $51,693.85 Interest Income $170,000.00 $168,307.00 $62,957.65 Other Non Operating Revenue $55,000.00 $177,855.06 $177,855.06 Operating Transfers In $388,497.37 $384,069.56 $3,084.76 Totals $38,088,363.84 $25,529,832.58 $1,310,693.19 FY2022Revenue Model Report (Detail)Remaining For the Period Ending July 31, 2022 YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification Description Budget As of 8/17 As of 8/17 TOTAL (Under) Budget of FormulasSales Tax and Use Tax 10-100-400010 Sales Tax $12,521,475.39 $8,921,151.58 $4,402,809.83 $13,323,961.41 $802,486.02 $802,486.02 10-100-400020 Sales Tax Interest $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $12,521,475.39 $8,921,151.58 $4,402,809.83 $13,323,961.41 $802,486.02 $802,486.02Intergovernmental Taxes 10-100-401030 Motor Vehicle Sales Tax $612,000.00 $363,248.23 $264,101.39 $627,349.62 $15,349.62 $15,349.62 10-100-403010 Gasoline Tax $1,250,000.00 $749,135.48 $548,149.52 $1,297,285.00 $47,285.00 $47,285.00 10-100-430080 Road & Bridge Tax $650,000.00 $641,562.58 $0.00 $641,562.58 ($8,437.42)($8,437.42) $2,512,000.00 $1,753,946.29 $812,250.91 $2,566,197.20 $54,197.20 $54,197.20Other Taxes 10-100-403020 Cig Tax $96,000.00 $58,120.56 $32,541.04 $90,661.60 ($5,338.40)($5,338.40) $96,000.00 $58,120.56 $32,541.04 $90,661.60 ($5,338.40)($5,338.40)Franchise & Utility Tax 10-100-410020 Electric Utility Lic Tax $3,900,000.00 $2,214,500.93 $1,794,842.91 $4,009,343.84 $109,343.84 $109,343.84 10-100-410021 Electric Utility-AUDIT $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-410030 Gas Utility License Tax $800,000.00 $908,572.96 $121,099.88 $1,029,672.84 $229,672.84 $229,672.84 10-100-410052 Telephone/Cell Utility $1,450,000.00 $711,948.93 $437,443.97 $1,149,392.90 ($300,607.10)($300,607.10) 10-100-410053 Telephone/Cell Audit $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-410060 Cable Franchise Fee $300,000.00 $142,059.84 $154,335.91 $296,395.75 ($3,604.25)($3,604.25) $6,450,000.00 $3,977,082.66 $2,507,722.67 $6,484,805.33 $34,805.33 $34,805.33Property Taxes 10-100-420010 Current Property Tax $4,985,000.00 $5,037,889.80 $16,457.84 $5,054,347.64 $69,347.64 $69,347.64 10-100-420020 Del Property Tax $60,000.00 $57,094.02 $14,396.86 $71,490.88 $11,490.88 $11,490.88 10-100-420040 Fin Institution Tax $30,000.00 $32,244.53 $0.00 $32,244.53 $2,244.53 $2,244.53 10-100-420050 Prop Tax Int & Penalties $27,000.00 $22,805.41 $9,009.99 $31,815.40 $4,815.40 $4,815.40 10-100-420055 Surtax Receipts - County Reimb $41,659.76 $54,399.28 $0.00 $54,399.28 $12,739.52 $12,739.52 10-100-420060 Surtax Receipts $500,000.00 $505,141.89 $2,003.70 $507,145.59 $7,145.59 $7,145.59 10-100-420080 Special Tax Rev $66,000.00 $100,421.70 $32,435.52 $132,857.22 $66,857.22 $66,857.22 $5,709,659.76 $5,809,996.63 $74,303.90 $5,884,300.53 $174,640.77 $174,640.77Intergovernmental 10-100-430010 Federal Grant $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-430012 Federal Grant $4,990,917.60 $0.00 $4,990,917.60 $4,990,917.60 $0.00 $0.00 10-100-430040 Local Grant $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-430060 Drug Forfeiture $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-480020 NSP Rehab Sales $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-480025 HUD Program Income $0.00 $8,335.00 $0.00 $8,335.00 $8,335.00 $8,335.00 $4,990,917.60 $8,335.00 $4,990,917.60 $4,999,252.60 $8,335.00 $8,335.00Charges for Services 10-100-440010 Admin Charge Backs $1,614,977.00 $1,614,977.00 $0.00 $1,614,977.00 $0.00 $0.00 10-100-440050 Emt Reimbursement $25,000.00 $0.00 $25,000.00 $25,000.00 $0.00 $0.00 10-100-440210 Street Cuts $36,000.00 $23,317.50 $9,218.60 $32,536.10 ($3,463.90)($3,463.90) 10-100-440910 Fuel Charge - backs $13,000.00 $12,894.50 $4,799.10 $17,693.60 $4,693.60 $4,693.60 10-100-440920 Parts Charge backs $242,732.58 $197,098.54 $72,794.05 $269,892.59 $27,160.01 $27,160.01 10-100-440930 Labor Charge backs $273,719.72 $190,807.41 $74,417.46 $265,224.87 ($8,494.85)($8,494.85) 10-100-481020 Cole Cty Animal Rescue $116,645.39 $87,484.05 $29,161.34 $116,645.39 $0.00 $0.00 10-100-481030 Rent City Hall/Annex $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-481040 Rent Other $12,000.00 $12,000.00 $0.00 $12,000.00 $0.00 $0.00 10-100-481045 Rent-tower Sites $185,000.00 $193,350.08 $41,069.64 $234,419.72 $49,419.72 $49,419.72 10-100-481065 Parking Spot Maintenance $25,000.00 $25,000.00 $0.00 $25,000.00 $0.00 $0.00 10-100-481075 Cole Cty 911 Reimb $417,564.39 $310,865.06 $104,623.59 $415,488.65 ($2,075.74)($2,075.74) 10-100-481080 Sale Of Maps/GIS Data $0.00 $10.00 $0.00 $10.00 $10.00 $10.00 10-100-481085 Cole Cty GIS Joint Coop $15,000.00 $14,035.00 $3,750.00 $17,785.00 $2,785.00 $2,785.00 10-100-481100 Sale Of Grave Sites $3,000.00 $2,085.00 $545.45 $2,630.45 ($369.55)($369.55) 10-100-481105 TIF Administration Fee $20,839.00 $10,230.00 $10,609.00 $20,839.00 $0.00 $0.00 10-100-481110 Long & Short $0.00 $241.25 $0.00 $241.25 $241.25 $241.25 $3,000,478.08 $2,694,395.39 $375,988.24 $3,070,383.63 $69,905.55 $69,905.55Fees, Licenses, & Permits 10-100-450010 Liquor Licenses $72,000.00 $72,260.50 $1,273.21 $73,533.71 $1,533.71 $1,533.71 10-100-450020 Business Licenses $220,000.00 $202,916.01 $21,773.53 $224,689.54 $4,689.54 $4,689.54 10-100-450021 Home Occupation Permit $2,500.00 $1,375.00 $591.40 $1,966.40 ($533.60)($533.60) 10-100-450040 Abandoned Bldg. Regist.$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-450041 Abandoned Bldg. Admin Fee $8,000.00 $16,139.38 $0.00 $16,139.38 $8,139.38 $8,139.38 10-100-450045 Building Construct. Fees $421,687.50 $218,402.21 $134,502.59 $352,904.80 ($68,782.70)($68,782.70) 10-100-450050 Electrical Certificates $22,000.00 $26,725.00 $3,041.32 $29,766.32 $7,766.32 $7,766.32 10-100-450060 Electrical Permits $5,000.00 $5,284.55 $1,050.50 $6,335.05 $1,335.05 $1,335.05 10-100-450070 Plumbing Licenses $12,400.00 $15,258.00 $444.33 $15,702.33 $3,302.33 $3,302.33 10-100-450080 Plumbing Permits $10,000.00 $10,300.50 $1,846.23 $12,146.73 $2,146.73 $2,146.73 10-100-450090 Other Lic & Permits $2,000.00 $1,820.00 $362.38 $2,182.38 $182.38 $182.38 FY2022Revenue Model Report (Detail)Remaining For the Period Ending July 31, 2022 YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification Description Budget As of 8/17 As of 8/17 TOTAL (Under) Budget of Formulas 10-100-450091 Day Care Inspection Fees $5,500.00 $3,050.00 $1,274.25 $4,324.25 ($1,175.75)($1,175.75) 10-100-450092 Food Inspection Fees $88,000.00 $91,501.00 ($2,070.72)$89,430.28 $1,430.28 $1,430.28 10-100-450100 Curb Cut Permits $1,000.00 $825.00 $308.74 $1,133.74 $133.74 $133.74 10-100-450110 Board Of Adj Fees $2,000.00 $2,900.00 $666.67 $3,566.67 $1,566.67 $1,566.67 10-100-450120 Sign Permits $6,900.00 $5,376.00 $2,028.04 $7,404.04 $504.04 $504.04 10-100-450130 Demolition Permits $3,000.00 $2,281.00 $833.61 $3,114.61 $114.61 $114.61 10-100-450150 Acc Rep Fees-police $8,000.00 $5,132.80 $2,116.28 $7,249.08 ($750.92)($750.92) 10-100-450160 Accrpt/blastg P-fire $1,150.00 $229.13 $658.30 $887.43 ($262.57)($262.57) 10-100-450170 Animal Redemption Fees $98,000.00 $68,704.00 $27,828.43 $96,532.43 ($1,467.57)($1,467.57) 10-100-450180 Animal Vaccinations Fees $5,200.00 $3,000.00 $867.62 $3,867.62 ($1,332.38)($1,332.38) 10-100-450185 Animal Cremation Fees $50,000.00 $23,545.00 $11,618.58 $35,163.58 ($14,836.42)($14,836.42) 10-100-450186 Animal Boarding Fees $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-450190 Taxi Permits $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-450230 Vacating Right Of Way $800.00 $463.00 $171.43 $634.43 ($165.57)($165.57) 10-100-450250 Rezoning Request $0.00 $3,960.00 $0.00 $3,960.00 $3,960.00 $3,960.00 10-100-450255 Planning & Zoning Review Fees $20,000.00 $9,855.00 $4,874.54 $14,729.54 ($5,270.46)($5,270.46) 10-100-450260 Non-refundable Plans/spec $1,300.00 $1,035.00 $366.33 $1,401.33 $101.33 $101.33 $1,066,437.50 $792,338.08 $216,427.59 $1,008,765.67 ($57,671.83)($57,671.83)Fines & Forfeitures 10-100-460010 Court Cost $51,000.00 $23,299.22 $10,326.33 $33,625.55 ($17,374.45)($17,374.45) 10-100-460015 Court Restitutions $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-460018 Inmate Security Fund $8,500.00 $3,879.90 $1,717.90 $5,597.80 ($2,902.20)($2,902.20) 10-100-460020 Jail Cost Recovery $1,000.00 $157.50 $0.00 $157.50 ($842.50)($842.50) 10-100-460025 Alcohol Offense Cost Rec $6,000.00 $4,094.47 $1,375.75 $5,470.22 ($529.78)($529.78) 10-100-460030 Pol Fines-traffic $490,000.00 $252,124.46 $101,210.33 $353,334.79 ($136,665.21)($136,665.21) 10-100-460090 Parking Fines $29,000.00 $29,365.00 $6,518.56 $35,883.56 $6,883.56 $6,883.56 10-100-460100 Bankcard Charges ($5,500.00)($5,023.15)($1,445.49)($6,468.64)($968.64)($968.64) $580,000.00 $307,897.40 $119,703.39 $427,600.79 ($152,399.21)($152,399.21)Contributions/Donations 10-100-480055 JC Fire Museum $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-480070 Community Projects Donations $10,828.57 $11,843.57 $0.00 $11,843.57 $1,015.00 $1,015.00 10-100-480080 Dare Donations $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-480090 Police K-9 Donations $0.00 $1,000.00 $0.00 $1,000.00 $1,000.00 $1,000.00 10-100-480165 Animal S Donations $21,000.00 $99,449.33 $5,677.10 $105,126.43 $84,126.43 $84,126.43 10-100-481055 Street Repair-Solid Waste Cntr $351,788.00 $202,677.93 $149,110.07 $351,788.00 $0.00 $0.00 10-100-481095 Cemetery Donations $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $383,616.57 $314,970.83 $154,787.17 $469,758.00 $86,141.43 $86,141.43 Other Operating Revenues 10-100-480010 Citizen Participation $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-480011 Police Evidence Funds $0.00 $58,569.67 $0.00 $58,569.67 $58,569.67 $58,569.67 10-100-481070 Miscellaneous $82,921.21 $46,560.60 $17,477.49 $64,038.09 ($18,883.12)($18,883.12) 10-100-481072 TIF Prof Svcs Deposit $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-481074 Revenue Share - Purchasing Card $17,000.00 $9,932.45 $5,669.81 $15,602.26 ($1,397.74)($1,397.74) 10-100-481077 Insurance Claims $44,360.36 $46,303.82 $11,461.58 $57,765.40 $13,405.04 $13,405.04 10-100-481078 Cafeteria Refunds $20,000.00 $0.00 $20,000.00 $20,000.00 $0.00 $0.00 $164,281.57 $161,366.54 $54,608.88 $215,975.42 $51,693.85 $51,693.85Interest Income 10-100-470010 Interest $170,000.00 $168,307.00 $64,650.65 $232,957.65 $62,957.65 $62,957.65 $170,000.00 $168,307.00 $64,650.65 $232,957.65 $62,957.65 $62,957.65Other Non Operating Revenue 10-100-485050 Sale Of Assets $55,000.00 $177,855.06 $55,000.00 $232,855.06 $177,855.06 $177,855.06 10-100-486020 Capital Contribution-Developer $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $55,000.00 $177,855.06 $55,000.00 $232,855.06 $177,855.06 $177,855.06Operating Transfers In 10-100-490240 Trsfr From Lodging Tax $26,400.00 $21,972.19 $7,512.57 $29,484.76 $3,084.76 $3,084.76 10-100-490355 Transfer from CIT 'G'$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-490500 Transfer from Public Safety Tax $362,097.37 $362,097.37 $0.00 $362,097.37 $0.00 $0.00 10-100-490630 Transfer from Self Funded Hlth Ins $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $388,497.37 $384,069.56 $7,512.57 $391,582.13 $3,084.76 $3,084.76 $38,088,363.84 $25,529,832.58 $13,869,224.45 $39,399,057.03 $1,310,693.19 $1,310,693.19 General Ledger Trial Balance by Acct Type and Full Acct Number User: spearre Printed: 08/17/22 07:33:50 Period 01 - 12 Fiscal Year 2022 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10 General Fund Revenue Revenue 100 Revenue 10-100-400010 Sales Tax 12,521,475.39 8,921,151.58 0.00 3,600,323.81 28.75 10-100-400020 Sales Tax Interest 0.00 0.00 0.00 0.00 0.00 R10 Sales & Use Taxes 12,521,475.39 8,921,151.58 0.00 3,600,323.81 28.75 10-100-401030 Motor Vehicle Tax 612,000.00 363,248.23 0.00 248,751.77 40.65 10-100-403010 Gasoline Tax 1,250,000.00 749,135.48 0.00 500,864.52 40.07 10-100-430080 Road & Bridge Tax 650,000.00 641,562.58 0.00 8,437.42 1.30 R16 Intergovernmental Taxes 2,512,000.00 1,753,946.29 0.00 758,053.71 30.18 10-100-403020 Cigarette Tax 96,000.00 61,022.56 0.00 34,977.44 36.43 R20 Other Taxes 96,000.00 61,022.56 0.00 34,977.44 36.43 10-100-410020 Electric Utility Lic Tax 3,900,000.00 2,214,500.93 0.00 1,685,499.07 43.22 10-100-410021 Electric Utility-AUDIT 0.00 0.00 0.00 0.00 0.00 10-100-410030 Gas Utility License Tax 800,000.00 908,572.96 0.00 -108,572.96 -13.57 10-100-410031 Gas Utility-AUDIT 0.00 0.00 0.00 0.00 0.00 10-100-410050 INACTIVE - Phone Utility Tax 0.00 0.00 0.00 0.00 0.00 10-100-410051 INACTIVE - Cell Utility Tax 0.00 0.00 0.00 0.00 0.00 10-100-410052 TelephoneCell Utility Tax 1,450,000.00 717,790.71 0.00 732,209.29 50.50 10-100-410053 TelephoneCell Utility-AUDIT 0.00 -11,210.20 0.00 11,210.20 0.00 10-100-410060 Cable Franchise Fee 300,000.00 217,433.56 0.00 82,566.44 27.52 10-100-410061 Cable Utility-AUDIT 0.00 0.00 0.00 0.00 0.00 R30 Franchise & Utility Tax 6,450,000.00 4,047,087.96 0.00 2,402,912.04 37.25 10-100-420010 Cur Property Tax 4,985,000.00 5,043,996.30 0.00 -58,996.30 -1.18 10-100-420020 Del Property Tax 60,000.00 62,926.15 0.00 -2,926.15 -4.88 10-100-420040 Fin Inst Tax 30,000.00 32,244.53 0.00 -2,244.53 -7.48 10-100-420050 Prop Tax Int & Penalties 27,000.00 26,747.51 0.00 252.49 0.94 10-100-420055 Surtax Receipts - County Reimb 41,659.76 54,399.28 0.00 -12,739.52 -30.58 10-100-420060 Surtax Receipts 500,000.00 505,645.71 0.00 -5,645.71 -1.13 10-100-420080 Special Tax Rev 66,000.00 107,042.15 0.00 -41,042.15 -62.19 R40 Property Taxes 5,709,659.76 5,833,001.63 0.00 -123,341.87 -2.16 GL - Trial Balance by Acct Type and Full Acct Number (08/17/2022 - 7:33 AM)Page 1 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-100-430010 Federal Grants 0.00 0.00 0.00 0.00 0.00 10-100-430012 Federal Grants-ARPA 4,990,917.60 0.00 0.00 4,990,917.60 100.00 10-100-430020 State Grants 0.00 0.00 0.00 0.00 0.00 10-100-430040 Local Grants 0.00 0.00 0.00 0.00 0.00 10-100-430060 Drug Forfeiture 0.00 0.00 0.00 0.00 0.00 10-100-430074 Overtime Reimb 0.00 0.00 0.00 0.00 0.00 10-100-430100 State DNR Historic Pres.0.00 0.00 0.00 0.00 0.00 10-100-480020 NSP Rehab Sales 0.00 0.00 0.00 0.00 0.00 10-100-480025 HUD Program Income 0.00 8,335.00 0.00 -8,335.00 0.00 R50 Intergovernmental 4,990,917.60 8,335.00 0.00 4,982,582.60 99.83 10-100-440010 Admin Charge Backs 1,614,977.00 1,614,977.00 0.00 0.00 0.00 10-100-440050 Emt Reimbursement 25,000.00 0.00 0.00 25,000.00 100.00 10-100-440210 Street Cuts 36,000.00 25,907.50 0.00 10,092.50 28.03 10-100-440910 Fuel Charge-backs 13,000.00 15,415.78 0.00 -2,415.78 -18.58 10-100-440920 Parts Charge-back 242,732.58 198,453.47 0.00 44,279.11 18.24 10-100-440930 Labor Charge-backs 273,719.72 191,729.91 0.00 81,989.81 29.95 10-100-450189 Animal Shelter Bricks 0.00 0.00 0.00 0.00 0.00 10-100-481020 Cole Cty Animal Rescue 116,645.39 87,484.05 0.00 29,161.34 25.00 10-100-481030 Rent City Hallannex 0.00 0.00 0.00 0.00 0.00 10-100-481039 Rent-Hyde Park Facility 0.00 0.00 0.00 0.00 0.00 10-100-481040 Rent Other 12,000.00 12,000.00 0.00 0.00 0.00 10-100-481045 Rent-tower Sites 185,000.00 211,738.19 0.00 -26,738.19 -14.45 10-100-481065 Parking Spot Maintenance 25,000.00 25,000.00 0.00 0.00 0.00 10-100-481075 Cole Cty 911 Reimb 417,564.39 345,739.59 0.00 71,824.80 17.20 10-100-481080 Sale Of Mapsgis Data 0.00 10.00 0.00 -10.00 0.00 10-100-481085 Cole Cty Gis Joint Coop 15,000.00 15,285.00 0.00 -285.00 -1.90 10-100-481090 Cole Cty Sheriff-New World 0.00 0.00 0.00 0.00 0.00 10-100-481100 Sale Of Grave Sites 3,000.00 2,085.00 0.00 915.00 30.50 10-100-481105 TIF Administration Fee 20,839.00 10,230.00 0.00 10,609.00 50.91 10-100-481110 Long & Short 0.00 241.25 0.00 -241.25 0.00 R60 Charges for Services 3,000,478.08 2,756,296.74 0.00 244,181.34 8.14 10-100-450010 Liquor Licenses 72,000.00 72,765.92 0.00 -765.92 -1.06 10-100-450020 Business Licenses 220,000.00 208,786.84 0.00 11,213.16 5.10 10-100-450021 Home Occupation Permit 2,500.00 1,485.00 0.00 1,015.00 40.60 10-100-450030 Soliciters Licenses 0.00 0.00 0.00 0.00 0.00 10-100-450040 Abandoned Bldg Registration 0.00 0.00 0.00 0.00 0.00 10-100-450041 Abandoned Bldg Admin Fee 8,000.00 79,839.38 0.00 -71,839.38 -897.99 10-100-450045 Bldg Constr Fees 421,687.50 224,834.87 0.00 196,852.63 46.68 10-100-450050 Electrical Certificates 22,000.00 27,731.00 0.00 -5,731.00 -26.05 10-100-450060 Electrical Permits 5,000.00 6,089.28 0.00 -1,089.28 -21.79 10-100-450070 Plumbing Licenses 12,400.00 15,639.00 0.00 -3,239.00 -26.12 10-100-450080 Plumbing Permits 10,000.00 12,812.12 0.00 -2,812.12 -28.12 10-100-450090 Other Lic & Permits 2,000.00 1,820.00 0.00 180.00 9.00 10-100-450091 Day Care Inspection Fees 5,500.00 3,270.00 0.00 2,230.00 40.55 10-100-450092 Food Inspection Fees 88,000.00 91,529.00 0.00 -3,529.00 -4.01 10-100-450100 Curb Cut Permits 1,000.00 825.00 0.00 175.00 17.50 10-100-450110 Board Of Adj Fees 2,000.00 2,900.00 0.00 -900.00 -45.00 GL - Trial Balance by Acct Type and Full Acct Number (08/17/2022 - 7:33 AM)Page 2 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-100-450120 Sign Permits 6,900.00 5,817.00 0.00 1,083.00 15.70 10-100-450130 Demolition Permits 3,000.00 2,999.00 0.00 1.00 0.03 10-100-450150 Acc Rep Fees-police 8,000.00 5,589.80 0.00 2,410.20 30.13 10-100-450160 Accrptblastg P-fire 1,150.00 242.41 0.00 907.59 78.92 10-100-450170 Animal Redemption Fees 98,000.00 71,424.00 0.00 26,576.00 27.12 10-100-450180 Animal Vaccinations Fees 5,200.00 3,175.00 0.00 2,025.00 38.94 10-100-450185 Animal Cremation Fees 50,000.00 26,506.00 0.00 23,494.00 46.99 10-100-450186 Animal Boarding Fees 0.00 0.00 0.00 0.00 0.00 10-100-450190 Taxi Permits 0.00 0.00 0.00 0.00 0.00 10-100-450230 Vacating Right Of Way 800.00 463.00 0.00 337.00 42.13 10-100-450250 Rezoning Request 0.00 3,960.00 0.00 -3,960.00 0.00 10-100-450255 Planning & Zoning Review Fees 20,000.00 11,845.00 0.00 8,155.00 40.78 10-100-450260 Non-refundable Plansspec 1,300.00 1,035.00 0.00 265.00 20.38 R65 Fees Licenses & Permits 1,066,437.50 883,383.62 0.00 183,053.88 17.16 10-100-460010 Court Cost 51,000.00 24,295.56 0.00 26,704.44 52.36 10-100-460015 Court Restitutions 0.00 0.00 0.00 0.00 0.00 10-100-460018 Inmate Security Fund 8,500.00 4,046.40 0.00 4,453.60 52.40 10-100-460020 Jail Cost Recovery 1,000.00 157.50 0.00 842.50 84.25 10-100-460025 Alcohol Offense Cost Rec 6,000.00 4,228.50 0.00 1,771.50 29.53 10-100-460030 Pol Fines-traffic 490,000.00 262,658.84 0.00 227,341.16 46.40 10-100-460040 Pol Tickets-parking 0.00 0.00 0.00 0.00 0.00 10-100-460050 Pol Fines-other 0.00 0.00 0.00 0.00 0.00 10-100-460060 Dog Fines 0.00 0.00 0.00 0.00 0.00 10-100-460070 P & Code Violations 0.00 0.00 0.00 0.00 0.00 10-100-460090 Parking Fines 29,000.00 30,265.00 0.00 -1,265.00 -4.36 10-100-460100 Bankcard Charges -5,500.00 -5,023.15 0.00 -476.85 8.67 R70 Fines & Forfeitures 580,000.00 320,628.65 0.00 259,371.35 44.72 10-100-430055 INACTIVE - DARE Contributions 0.00 0.00 0.00 0.00 0.00 10-100-480015 Sidewalk Waiver Revenue 0.00 0.00 0.00 0.00 0.00 10-100-480030 Donations-Recycling 0.00 0.00 0.00 0.00 0.00 10-100-480050 Sober Driver Program 0.00 0.00 0.00 0.00 0.00 10-100-480055 JC Fire Museum 0.00 0.00 0.00 0.00 0.00 10-100-480063 Private Donations-Cultural Art 0.00 0.00 0.00 0.00 0.00 10-100-480065 Cultural Arts 0.00 0.00 0.00 0.00 0.00 10-100-480070 Community Projects Donations 10,828.57 11,843.57 0.00 -1,015.00 -9.37 10-100-480080 Dare Donations 0.00 0.00 0.00 0.00 0.00 10-100-480090 Police K-9 Donations 0.00 1,000.00 0.00 -1,000.00 0.00 10-100-480165 Animal S Donations 21,000.00 99,929.33 0.00 -78,929.33 -375.85 10-100-481050 Transfer StnPlng-Sld Wst Cntr 0.00 0.00 0.00 0.00 0.00 10-100-481055 Street Repair-Solid Waste Cntr 351,788.00 202,677.93 0.00 149,110.07 42.39 10-100-481095 Cemetery Donations 0.00 0.00 0.00 0.00 0.00 10-100-486070 Cap Contr-Neighborhood Imp Pro 0.00 0.00 0.00 0.00 0.00 R72 ContributionsDonations 383,616.57 315,450.83 0.00 68,165.74 17.77 10-100-450187 Special Sn Program 0.00 0.00 0.00 0.00 0.00 10-100-450188 Adoption Voucher Program 0.00 0.00 0.00 0.00 0.00 10-100-480010 Citizen Participation 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (08/17/2022 - 7:33 AM)Page 3 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-100-480011 Police Evidence Funds 0.00 58,569.67 0.00 -58,569.67 0.00 10-100-481069 Utility Audit Revenue 0.00 0.00 0.00 0.00 0.00 10-100-481070 Miscellaneous 82,921.21 47,025.02 0.00 35,896.19 43.29 10-100-481072 TIF Developer Reimbursements 0.00 0.00 0.00 0.00 0.00 10-100-481074 Revenue Share 17,000.00 11,342.64 0.00 5,657.36 33.28 10-100-481077 Insurance Claims 44,360.36 55,973.32 0.00 -11,612.96 -26.18 10-100-481078 Cafeteria Refunds 20,000.00 0.00 0.00 20,000.00 100.00 R75 Other Operating Revenues 164,281.57 172,910.65 0.00 -8,629.08 -5.25 10-100-470010 Interest 170,000.00 168,307.00 0.00 1,693.00 1.00 10-100-470051 Unrealized Gainslosses 0.00 0.00 0.00 0.00 0.00 R80 Interest Income 170,000.00 168,307.00 0.00 1,693.00 1.00 10-100-485049 Capvhcleqp-sale Of Assets 0.00 0.00 0.00 0.00 0.00 10-100-485050 Sale Of Assets 55,000.00 177,855.06 0.00 -122,855.06 -223.37 10-100-486020 Cap Contr-developer 0.00 0.00 0.00 0.00 0.00 R85 Other Non-Operating Revenue 55,000.00 177,855.06 0.00 -122,855.06 -223.37 10-100-490193 Trsfr From Grant Fund 0.00 0.00 0.00 0.00 0.00 10-100-490240 Trsfr From Lodging Tax 26,400.00 21,972.19 0.00 4,427.81 16.77 10-100-490260 Trans from Firemen's Spec Rev 0.00 0.00 0.00 0.00 0.00 10-100-490280 Trnf From Stoneridge Tdd 0.00 0.00 0.00 0.00 0.00 10-100-490320 Trans from Cap Proj-Street&PF 0.00 0.00 0.00 0.00 0.00 10-100-490353 Transfer From Cit 'e'0.00 0.00 0.00 0.00 0.00 10-100-490355 Transfer from Cit 'G'0.00 0.00 0.00 0.00 0.00 10-100-490500 Trans from Public Safety Tax 362,097.37 362,097.37 0.00 0.00 0.00 10-100-490600 Transfer from Water Fund 0.00 0.00 0.00 0.00 0.00 10-100-490620 Transfer from Parking Fund 0.00 0.00 0.00 0.00 0.00 10-100-490630 Tran from Self-Funded Hlth Ins 0.00 0.00 0.00 0.00 0.00 R90 Transfers In 388,497.37 384,069.56 0.00 4,427.81 1.14 10-100-495995 Transfer From(to) Surplus 3,167,825.95 0.00 0.00 3,167,825.95 100.00 10-100-495996 Trnasfer From(To) Surplus 0.00 0.00 0.00 0.00 0.00 10-100-495998 Loan Proceeds 0.00 0.00 0.00 0.00 0.00 R99 Carry Over Surplus 3,167,825.95 0.00 0.00 3,167,825.95 100.00 100 Revenue 41,256,189.79 25,803,447.13 0.00 15,452,742.66 37.46 145 CDBG-CV Cole Co EMS Station 10-145-430010 Federal Grants 2,000,000.00 0.00 0.00 2,000,000.00 100.00 R50 Intergovernmental 2,000,000.00 0.00 0.00 2,000,000.00 100.00 145 CDBG-CV Cole Co EMS Station 2,000,000.00 0.00 0.00 2,000,000.00 100.00 146 HPF-P Bruhn Revitalization 10-146-430010 Federal Grants 675,000.00 0.00 0.00 675,000.00 100.00 R50 Intergovernmental 675,000.00 0.00 0.00 675,000.00 100.00 146 HPF-P Bruhn Revitalization 675,000.00 0.00 0.00 675,000.00 100.00 GL - Trial Balance by Acct Type and Full Acct Number (08/17/2022 - 7:33 AM)Page 4 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 147 CDBG-CV Transform Housing 10-147-430010 Federal Grants 575,760.00 0.00 0.00 575,760.00 100.00 R50 Intergovernmental 575,760.00 0.00 0.00 575,760.00 100.00 147 CDBG-CV Transform Housing 575,760.00 0.00 0.00 575,760.00 100.00 148 CDBG-CV 10-148-430010 Federal Grants 410,435.00 241,090.44 0.00 169,344.56 41.26 R50 Intergovernmental 410,435.00 241,090.44 0.00 169,344.56 41.26 148 CDBG-CV 410,435.00 241,090.44 0.00 169,344.56 41.26 149 Entitlement Grant 10-149-430010 Federal Grants 819,214.30 122,458.14 0.00 696,756.16 85.05 10-149-430020 State Grants 0.00 0.00 0.00 0.00 0.00 10-149-430040 Local Grants 0.00 0.00 0.00 0.00 0.00 R50 Intergovernmental 819,214.30 122,458.14 0.00 696,756.16 85.05 149 Entitlement Grant 819,214.30 122,458.14 0.00 696,756.16 85.05 185 Non-Departmental 10-185-430010 Federal Grants 0.00 0.00 0.00 0.00 0.00 10-185-430020 State Grants 0.00 0.00 0.00 0.00 0.00 10-185-430040 Local Grants 0.00 0.00 0.00 0.00 0.00 R50 Intergovernmental 0.00 0.00 0.00 0.00 0.00 185 Non-Departmental 0.00 0.00 0.00 0.00 0.00 300 Police Department 10-300-430010 Federal Grants 147,525.75 2,577.00 0.00 144,948.75 98.25 10-300-430011 Federal Grants-Overtime Reimb 64,460.53 5,799.11 0.00 58,661.42 91.00 10-300-430020 State Grants 0.00 0.00 0.00 0.00 0.00 10-300-430040 Local Grants 0.00 0.00 0.00 0.00 0.00 10-300-430074 Overtime Reimb 6,794.74 4,992.45 0.00 1,802.29 26.52 R50 Intergovernmental 218,781.02 13,368.56 0.00 205,412.46 93.89 300 Police Department 218,781.02 13,368.56 0.00 205,412.46 93.89 310 School Resource Officer 10-310-430010 Federal Grants 0.00 0.00 0.00 0.00 0.00 10-310-430020 State Grants 0.00 0.00 0.00 0.00 0.00 10-310-430040 Local Grants 370,878.49 370,878.49 0.00 0.00 0.00 R50 Intergovernmental 370,878.49 370,878.49 0.00 0.00 0.00 310 School Resource Officer 370,878.49 370,878.49 0.00 0.00 0.00 320 M.U.S.T.A.N.G. 10-320-430010 Federal Grants 28,946.92 8,066.85 0.00 20,880.07 72.13 GL - Trial Balance by Acct Type and Full Acct Number (08/17/2022 - 7:33 AM)Page 5 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-320-430011 Federal Grants-Overtime Reimb 0.00 0.00 0.00 0.00 0.00 10-320-430020 State Grants 0.00 0.00 0.00 0.00 0.00 10-320-430040 Local Grants 0.00 0.00 0.00 0.00 0.00 10-320-430060 Drug Forfeiture 0.00 0.00 0.00 0.00 0.00 10-320-430074 Overtime Reimb 18,426.57 14,787.24 0.00 3,639.33 19.75 R50 Intergovernmental 47,373.49 22,854.09 0.00 24,519.40 51.76 320 M.U.S.T.A.N.G.47,373.49 22,854.09 0.00 24,519.40 51.76 330 Animal Control 10-330-430040 Local Grants 0.00 0.00 0.00 0.00 0.00 R50 Intergovernmental 0.00 0.00 0.00 0.00 0.00 330 Animal Control 0.00 0.00 0.00 0.00 0.00 390 9-1-1 Police 10-390-430040 Local Grants 30,545.00 0.00 0.00 30,545.00 100.00 R50 Intergovernmental 30,545.00 0.00 0.00 30,545.00 100.00 390 9-1-1 Police 30,545.00 0.00 0.00 30,545.00 100.00 400 Fire Department 10-400-430010 Federal Grant 25,940.00 1,605.00 0.00 24,335.00 93.81 10-400-430040 Local Grants 1,200.00 1,200.00 0.00 0.00 0.00 R50 Intergovernmental 27,140.00 2,805.00 0.00 24,335.00 89.66 400 Fire Department 27,140.00 2,805.00 0.00 24,335.00 89.66 520 Plan & Protect Svcs-Admin 10-520-430040 Local Grants 0.00 0.00 0.00 0.00 0.00 R50 Intergovernmental 0.00 0.00 0.00 0.00 0.00 520 Plan & Protect Svcs-Admin 0.00 0.00 0.00 0.00 0.00 522 Plan & Protect Svcs-MPO 10-522-430010 Federal Grants 252,359.00 66,526.83 0.00 185,832.17 73.64 10-522-430020 State Grants 0.00 0.00 0.00 0.00 0.00 10-522-430040 Local Grants 9,522.50 4,037.93 0.00 5,484.57 57.60 R50 Intergovernmental 261,881.50 70,564.76 0.00 191,316.74 73.05 522 Plan & Protect Svcs-MPO 261,881.50 70,564.76 0.00 191,316.74 73.05 530 Plan & Protect Svc-RedevGrant 10-530-430010 Federal Grants 57,600.00 0.00 0.00 57,600.00 100.00 10-530-430020 State Grants 0.00 0.00 0.00 0.00 0.00 10-530-430040 Local Grants 20,500.00 20,500.00 0.00 0.00 0.00 R50 Intergovernmental 78,100.00 20,500.00 0.00 57,600.00 73.75 530 Plan & Protect Svc-RedevGrant 78,100.00 20,500.00 0.00 57,600.00 73.75 GL - Trial Balance by Acct Type and Full Acct Number (08/17/2022 - 7:33 AM)Page 6 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 532 Plan & Protect Svcs-Env Health 10-532-430010 Federal Grants 0.00 0.00 0.00 0.00 0.00 10-532-430020 State Grants 0.00 0.00 0.00 0.00 0.00 10-532-430040 Local Grants 0.00 0.00 0.00 0.00 0.00 R50 Intergovernmental 0.00 0.00 0.00 0.00 0.00 532 Plan & Protect Svcs-Env Health 0.00 0.00 0.00 0.00 0.00 990 Capital Projects 10-990-430010 Federal Grants 1,743,750.00 0.00 0.00 1,743,750.00 100.00 10-990-430020 State Grants 124,019.00 0.00 0.00 124,019.00 100.00 10-990-430040 Local Grants 0.00 0.00 0.00 0.00 0.00 R50 Intergovernmental 1,867,769.00 0.00 0.00 1,867,769.00 100.00 990 Capital Projects 1,867,769.00 0.00 0.00 1,867,769.00 100.00 Revenue Revenue 48,639,067.59 26,667,966.61 0.00 21,971,100.98 45.17 Expense Expense 110 Mayor & Council 10-110-501010 Salary-Elected Officials 65,925.00 48,825.00 0.00 17,100.00 25.94 10-110-501015 Salary-Prosecuting Attorney 34,999.92 26,249.94 0.00 8,749.98 25.00 10-110-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-110-501050 Parttime(wo Benefits)16,598.40 4,660.32 0.00 11,938.08 71.92 10-110-502010 Social Security 8,990.53 5,722.50 0.00 3,268.03 36.35 10-110-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-110-502040 Workers Compensation 71.59 71.59 0.00 0.00 0.00 E05 Personnel Services 126,585.44 85,529.35 0.00 41,056.09 32.43 10-110-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-110-511020 Postage 100.00 7.26 0.00 92.74 92.74 10-110-512010 Printing 400.00 326.93 0.00 73.07 18.27 10-110-512020 Copies 100.00 2.04 0.00 97.96 97.96 10-110-513010 Office Supplies 2,050.00 1,638.84 0.00 411.16 20.06 10-110-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-110-514040 Food 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 2,650.00 1,975.07 0.00 674.93 25.47 10-110-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-110-520025 Security 1,250.00 1,175.59 0.00 74.41 5.95 10-110-520030 Dues And Publications 4,900.00 4,722.80 0.00 177.20 3.62 10-110-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-110-520070 Training & Education 1,089.84 270.00 0.00 819.84 75.23 10-110-522020 Professional Services 100.00 0.00 0.00 100.00 100.00 10-110-529010 Special Events 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 7,339.84 6,168.39 0.00 1,171.45 15.96 10-110-534010 Telephone 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (08/17/2022 - 7:33 AM)Page 7 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-110-547020 Maintenance Agreements 120.00 95.60 19.12 5.28 4.40 E25 Repairs & Maintenance 120.00 95.60 19.12 5.28 4.40 10-110-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 110 Mayor & Council 136,695.28 93,768.41 19.12 42,907.75 31.39 120 City Clerk 10-120-501020 Salaries 54,908.25 44,881.46 0.00 10,026.79 18.26 10-120-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-120-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-120-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-120-502010 Social Security 4,200.48 3,156.79 0.00 1,043.69 24.85 10-120-502020 Group Health Insurance 12,676.22 8,847.87 0.00 3,828.35 30.20 10-120-502030 Retirement 7,577.34 5,848.62 0.00 1,728.72 22.81 10-120-502040 Workers Compensation 49.99 49.99 0.00 0.00 0.00 10-120-502050 Life Insurance 62.42 48.90 0.00 13.52 21.66 10-120-502060 Long Term Disability 155.45 121.95 0.00 33.50 21.55 10-120-502070 Employee Assistance Prgm 21.84 20.44 0.00 1.40 6.41 E05 Personnel Services 79,651.99 62,976.02 0.00 16,675.97 20.94 10-120-511020 Postage 200.00 148.38 0.00 51.62 25.81 10-120-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-120-512020 Copies 300.00 159.62 0.00 140.38 46.79 10-120-513010 Office Supplies 200.00 140.49 0.00 59.51 29.76 10-120-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 700.00 448.49 0.00 251.51 35.93 10-120-520030 Dues And Publications 75.00 65.00 0.00 10.00 13.33 10-120-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-120-520070 Training And Education 400.00 378.05 0.00 21.95 5.49 10-120-522020 Professional Services 200.00 39.00 0.00 161.00 80.50 10-120-529030 Election Expense 18,579.79 39,171.92 0.00 -20,592.13 -110.83 E15 Contractual Services 19,254.79 39,653.97 0.00 -20,399.18 -105.94 10-120-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-120-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-120-547020 Maintenance Agreements 10,555.00 4,850.47 19.10 5,685.43 53.86 E25 Repairs & Maintenance 10,555.00 4,850.47 19.10 5,685.43 53.86 10-120-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 120 City Clerk 110,161.78 107,928.95 19.10 2,213.73 2.01 GL - Trial Balance by Acct Type and Full Acct Number (08/17/2022 - 7:33 AM)Page 8 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 140 City Administrator 10-140-501020 Salaries 211,181.31 167,448.04 0.00 43,733.27 20.71 10-140-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-140-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-140-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-140-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-140-502010 Social Security 16,155.37 11,341.42 0.00 4,813.95 29.80 10-140-502020 Group Health Insurance 24,948.52 14,536.74 0.00 10,411.78 41.73 10-140-502030 Retirement 29,143.02 22,417.81 0.00 6,725.21 23.08 10-140-502040 Workers Compensation 201.22 201.22 0.00 0.00 0.00 10-140-502050 Life Insurance 89.35 66.45 0.00 22.90 25.63 10-140-502060 Long Term Disability 218.85 252.12 0.00 -33.27 -15.20 10-140-502070 Employee Assistance Prgm 43.68 40.92 0.00 2.76 6.32 E05 Personnel Services 281,981.32 216,304.72 0.00 65,676.60 23.29 10-140-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-140-511020 Postage 150.00 38.66 0.00 111.34 74.23 10-140-512010 Printing 100.00 80.00 0.00 20.00 20.00 10-140-512020 Copies 150.00 44.49 0.00 105.51 70.34 10-140-513010 Office Supplies 750.00 481.12 0.00 268.88 35.85 10-140-514017 COVID-19 0.00 4,934.00 0.00 -4,934.00 0.00 10-140-517010 Operational Supplies 678.74 122.73 0.00 556.01 81.92 E10 Materials & Supplies 1,828.74 5,701.00 0.00 -3,872.26 -211.74 10-140-520030 Dues And Publications 700.00 1,786.78 0.00 -1,086.78 -155.25 10-140-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-140-520070 Training And Education 2,000.00 500.00 0.00 1,500.00 75.00 10-140-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-140-520090 Recruitment 0.00 0.00 0.00 0.00 0.00 10-140-520095 Relocation Fees 0.00 0.00 0.00 0.00 0.00 10-140-522020 Professional Services 400.00 0.00 0.00 400.00 100.00 E15 Contractual Services 3,100.00 2,286.78 0.00 813.22 26.23 10-140-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-140-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-140-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-140-547020 Maintenance Agreements 300.00 275.50 19.10 5.40 1.80 E25 Repairs & Maintenance 300.00 275.50 19.10 5.40 1.80 10-140-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 140 City Administrator 287,210.06 224,568.00 19.10 62,622.96 21.80 145 CDBG-CV Cole Co EMS Station 10-145-501020 Salaries 45,000.00 0.00 0.00 45,000.00 100.00 GL - Trial Balance by Acct Type and Full Acct Number (08/17/2022 - 7:33 AM)Page 9 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-145-502010 Social Security 0.00 0.00 0.00 0.00 0.00 10-145-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-145-502030 Retirement 0.00 0.00 0.00 0.00 0.00 10-145-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-145-502050 Life Insurance 0.00 0.00 0.00 0.00 0.00 10-145-502060 Long Term Disability 0.00 0.00 0.00 0.00 0.00 10-145-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 45,000.00 0.00 0.00 45,000.00 100.00 10-145-520072 Subrecipient Reimbursements 1,955,000.00 0.00 0.00 1,955,000.00 100.00 E15 Contractual Services 1,955,000.00 0.00 0.00 1,955,000.00 100.00 145 CDBG-CV Cole Co EMS Station 2,000,000.00 0.00 0.00 2,000,000.00 100.00 146 HPF-P Bruhn Revitalization 10-146-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-146-502010 Social Security 0.00 0.00 0.00 0.00 0.00 10-146-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-146-502030 Retirement 0.00 0.00 0.00 0.00 0.00 10-146-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-146-502050 Life Insurance 0.00 0.00 0.00 0.00 0.00 10-146-502060 Long Term Disability 0.00 0.00 0.00 0.00 0.00 10-146-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 0.00 0.00 0.00 0.00 0.00 10-146-511020 Postage 0.00 64.24 0.00 -64.24 0.00 E10 Materials & Supplies 0.00 64.24 0.00 -64.24 0.00 10-146-522020 Professional Services 420.00 0.00 0.00 420.00 100.00 E15 Contractual Services 420.00 0.00 0.00 420.00 100.00 10-146-550068 Pass-Through Grants 674,580.00 0.00 0.00 674,580.00 100.00 E65 Other Non-Operating Expenses 674,580.00 0.00 0.00 674,580.00 100.00 146 HPF-P Bruhn Revitalization 675,000.00 64.24 0.00 674,935.76 99.99 147 CDBG-CV Transform Housing 10-147-501020 Salaries 31,760.00 0.00 0.00 31,760.00 100.00 10-147-502010 Social Security 0.00 0.00 0.00 0.00 0.00 10-147-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-147-502030 Retirement 0.00 0.00 0.00 0.00 0.00 10-147-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-147-502050 Life Insurance 0.00 0.00 0.00 0.00 0.00 10-147-502060 Long Term Disability 0.00 0.00 0.00 0.00 0.00 10-147-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 31,760.00 0.00 0.00 31,760.00 100.00 10-147-520072 Subrecipient Reimbursements 544,000.00 0.00 0.00 544,000.00 100.00 E15 Contractual Services 544,000.00 0.00 0.00 544,000.00 100.00 GL - Trial Balance by Acct Type and Full Acct Number (08/17/2022 - 7:33 AM)Page 10 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 147 CDBG-CV Transform Housing 575,760.00 0.00 0.00 575,760.00 100.00 148 CDBG-CV 10-148-501020 Salaries 48,187.00 36,638.43 0.00 11,548.57 23.97 10-148-502010 Social Security 0.00 2,392.47 0.00 -2,392.47 0.00 10-148-502020 Group Health Insurance 0.00 10,758.30 0.00 -10,758.30 0.00 10-148-502030 Retirement 0.00 5,056.14 0.00 -5,056.14 0.00 10-148-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-148-502050 Life Insurance 0.00 45.26 0.00 -45.26 0.00 10-148-502060 Long Term Disability 0.00 112.31 0.00 -112.31 0.00 10-148-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 48,187.00 55,002.91 0.00 -6,815.91 -14.14 10-148-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-148-511020 Postage 0.00 10.12 0.00 -10.12 0.00 10-148-513010 Office Supplies 0.00 0.00 0.00 0.00 0.00 10-148-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 0.00 10.12 0.00 -10.12 0.00 10-148-520070 Training and Education 0.00 0.00 0.00 0.00 0.00 10-148-522020 Professional Services 31,500.00 22,500.00 9,000.00 0.00 0.00 10-148-528025 CARES-Childcare Services 124,030.00 38,346.00 0.00 85,684.00 69.08 10-148-528035 CARES-ED For-Profit Business 103,359.00 107,334.23 0.00 -3,975.23 -3.85 10-148-528045 CARES-ED Microenterprise 103,359.00 40,867.96 0.00 62,491.04 60.46 E15 Contractual Services 362,248.00 209,048.19 9,000.00 144,199.81 39.81 148 CDBG-CV 410,435.00 264,061.22 9,000.00 137,373.78 33.47 149 Entitlement Grant 10-149-501020 Salaries 51,247.02 29,779.29 0.00 21,467.73 41.89 10-149-501023 CARES-Salaries 0.00 0.00 0.00 0.00 0.00 10-149-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-149-502010 Social Security 3,920.40 2,067.78 0.00 1,852.62 47.26 10-149-502011 CARES-Social Security 0.00 0.00 0.00 0.00 0.00 10-149-502020 Group Health Insurance 14,746.59 6,468.22 0.00 8,278.37 56.14 10-149-502024 CARES-Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-149-502030 Retirement 7,072.09 3,764.49 0.00 3,307.60 46.77 10-149-502031 CARES-Retirement 0.00 0.00 0.00 0.00 0.00 10-149-502040 Workers Compensation 87.03 87.03 0.00 0.00 0.00 10-149-502041 CARES-Workers Comp 0.00 0.00 0.00 0.00 0.00 10-149-502050 Life Insurance 60.59 29.45 0.00 31.14 51.39 10-149-502051 CARES-Life Insurance 0.00 0.00 0.00 0.00 0.00 10-149-502060 Long Term Disability 149.89 72.26 0.00 77.63 51.79 10-149-502061 CARES-Long Term Disability 0.00 0.00 0.00 0.00 0.00 10-149-502070 Employee Assistance Program 21.84 30.68 0.00 -8.84 -40.48 10-149-502071 CARES-Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 77,305.45 42,299.20 0.00 35,006.25 45.28 GL - Trial Balance by Acct Type and Full Acct Number (08/17/2022 - 7:33 AM)Page 11 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-149-511010 Advertising 1,880.00 192.50 0.00 1,687.50 89.76 10-149-511011 CARES-Advertising 0.00 0.00 0.00 0.00 0.00 10-149-511020 Postage 270.00 25.22 0.00 244.78 90.66 10-149-511022 CARES-Postage 0.00 0.00 0.00 0.00 0.00 10-149-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-149-513010 Office Supplies 295.00 0.00 0.00 295.00 100.00 10-149-513011 CARES-Office Supplies 0.00 0.00 0.00 0.00 0.00 10-149-517010 Operational Supplies 220.00 0.00 0.00 220.00 100.00 10-149-517011 CARES-Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 2,665.00 217.72 0.00 2,447.28 91.83 10-149-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-149-520070 Training And Education 1,025.00 0.00 0.00 1,025.00 100.00 10-149-520071 CARES-Training and Education 0.00 0.00 0.00 0.00 0.00 10-149-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-149-528010 Housing Rehabilitation 0.00 0.00 0.00 0.00 0.00 10-149-528011 Housing Rehab-Code Deficiency 0.00 2,615.00 0.00 -2,615.00 0.00 10-149-528012 Housing Rehab-Energy Efficienc 0.00 0.00 0.00 0.00 0.00 10-149-528020 Housing Assistance 363,643.35 56,184.00 0.00 307,459.35 84.55 10-149-528025 CARES-Childcare Services 0.00 0.00 0.00 0.00 0.00 10-149-528030 Public Improvement 313,000.00 0.00 313,000.00 0.00 0.00 10-149-528035 CARES-ED For-Profit Business 0.00 0.00 0.00 0.00 0.00 10-149-528040 Neighborhood Redevelopmnt 41,214.50 41,214.50 0.00 0.00 0.00 10-149-528045 CARES-ED Microenterprise 0.00 0.00 0.00 0.00 0.00 10-149-528050 Neighborhood Facility 0.00 0.00 0.00 0.00 0.00 10-149-528060 Economic Development 0.00 0.00 0.00 0.00 0.00 10-149-528070 Emergency Assistance 20,000.00 27.00 0.00 19,973.00 99.87 10-149-528080 Homeless Objectives 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 738,882.85 100,040.50 313,000.00 325,842.35 44.10 10-149-547020 Maintenance Agreements 361.00 727.51 72.32 -438.83 -121.56 E25 Repairs & Maintenance 361.00 727.51 72.32 -438.83 -121.56 10-149-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 10-149-577045 Clay Street Plaza 0.00 0.00 0.00 0.00 0.00 10-149-577055 Marshall & Roland Sidewalk 0.00 0.00 0.00 0.00 0.00 10-149-577064 Broadway St Sidewalk 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 0.00 0.00 0.00 0.00 0.00 149 Entitlement Grant 819,214.30 143,284.93 313,072.32 362,857.05 44.29 150 City Attorney 10-150-501020 Salaries 229,698.16 179,349.45 0.00 50,348.71 21.92 10-150-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-150-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-150-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-150-501090 Overtime 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (08/17/2022 - 7:33 AM)Page 12 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-150-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-150-502010 Social Security 17,571.91 13,283.02 0.00 4,288.89 24.41 10-150-502020 Group Health Insurance 33,887.26 22,591.29 0.00 11,295.97 33.33 10-150-502030 Retirement 31,698.35 23,714.17 0.00 7,984.18 25.19 10-150-502040 Workers Compensation 230.79 230.79 0.00 0.00 0.00 10-150-502050 Life Insurance 274.18 199.35 0.00 74.83 27.29 10-150-502060 Long Term Disability 591.19 424.32 0.00 166.87 28.23 10-150-502070 Employee Assistance Prgm 65.52 61.36 0.00 4.16 6.35 10-150-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 314,017.36 239,853.75 0.00 74,163.61 23.62 10-150-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-150-511020 Postage 500.00 408.15 0.00 91.85 18.37 10-150-512010 Printing 100.00 0.00 0.00 100.00 100.00 10-150-512020 Copies 50.00 5.89 0.00 44.11 88.22 10-150-513010 Office Supplies 3,369.00 2,101.82 0.00 1,267.18 37.61 10-150-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-150-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 4,019.00 2,515.86 0.00 1,503.14 37.40 10-150-520020 Auditing Travel Expense 0.00 0.00 0.00 0.00 0.00 10-150-520030 Dues And Publications 11,200.00 4,915.63 2,153.30 4,131.07 36.88 10-150-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-150-520070 Training And Education 7,000.00 4,229.80 0.00 2,770.20 39.57 10-150-520080 Tuition Reimbursement 1,869.00 1,869.00 0.00 0.00 0.00 10-150-520095 Relocation Fees 0.00 0.00 0.00 0.00 0.00 10-150-521010 Malpractice Insurance 0.00 0.00 0.00 0.00 0.00 10-150-522020 Professional Services 10,000.00 2,490.00 0.00 7,510.00 75.10 10-150-525030 Litigation Expenses 500.00 0.00 0.00 500.00 100.00 10-150-525031 Special Litigation Expenses 0.00 109,172.02 0.00 -109,172.02 0.00 E15 Contractual Services 30,569.00 122,676.45 2,153.30 -94,260.75 -308.35 10-150-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-150-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-150-547020 Maintenance Agreements 360.00 335.50 19.10 5.40 1.50 E25 Repairs & Maintenance 360.00 335.50 19.10 5.40 1.50 10-150-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-150-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 150 City Attorney 348,965.36 365,381.56 2,172.40 -18,588.60 -5.33 160 Municipal Court 10-160-501010 Salary-elected Officals 34,999.92 26,249.94 0.00 8,749.98 25.00 10-160-501020 Salaries 118,610.12 99,232.98 0.00 19,377.14 16.34 10-160-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (08/17/2022 - 7:33 AM)Page 13 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-160-501050 Parttime(wo Benefits)7,000.00 3,924.55 0.00 3,075.45 43.94 10-160-501090 Overtime 1,500.00 563.72 0.00 936.28 62.42 10-160-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-160-502010 Social Security 12,401.42 9,688.78 0.00 2,712.64 21.87 10-160-502020 Group Health Insurance 26,475.46 17,702.76 0.00 8,772.70 33.14 10-160-502030 Retirement 16,575.20 12,736.96 0.00 3,838.24 23.16 10-160-502040 Workers Compensation 198.17 198.17 0.00 0.00 0.00 10-160-502050 Life Insurance 141.98 106.65 0.00 35.33 24.88 10-160-502060 Long Term Disability 352.27 265.62 0.00 86.65 24.60 10-160-502070 Employee Assistance Prgm 65.52 61.36 0.00 4.16 6.35 10-160-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 218,320.06 170,731.49 0.00 47,588.57 21.80 10-160-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-160-511020 Postage 3,050.00 1,110.43 0.00 1,939.57 63.59 10-160-512010 Printing 400.00 0.00 0.00 400.00 100.00 10-160-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-160-513010 Office Supplies 4,000.00 525.98 0.00 3,474.02 86.85 10-160-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 7,450.00 1,636.41 0.00 5,813.59 78.03 10-160-520025 Security 10,000.00 6,919.71 0.00 3,080.29 30.80 10-160-520030 Dues And Publications 200.00 180.00 0.00 20.00 10.00 10-160-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-160-520070 Training And Education 1,500.00 695.00 0.00 805.00 53.67 10-160-522020 Professional Services 6,000.00 412.50 0.00 5,587.50 93.13 10-160-525005 Appointed Counsel 4,000.00 1,362.75 0.00 2,637.25 65.93 10-160-525010 Care Of Prisoners 250.00 0.00 0.00 250.00 100.00 10-160-525030 Litigation Expenses 40.00 0.00 0.00 40.00 100.00 E15 Contractual Services 21,990.00 9,569.96 0.00 12,420.04 56.48 10-160-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-160-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-160-547020 Maintenance Agreements 6,295.00 5,695.00 66.33 533.67 8.48 E25 Repairs & Maintenance 6,295.00 5,695.00 66.33 533.67 8.48 10-160-572020 Purchase Of Equipment 3,000.00 0.00 0.00 3,000.00 100.00 10-160-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 3,000.00 0.00 0.00 3,000.00 100.00 160 Municipal Court 257,055.06 187,632.86 66.33 69,355.87 26.98 170 Human Resources 10-170-501020 Salaries 223,180.43 179,653.30 0.00 43,527.13 19.50 10-170-501050 Parttime(wo Benefits)13,000.00 12,979.46 0.00 20.54 0.16 10-170-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-170-501090 Overtime 100.00 42.98 0.00 57.02 57.02 GL - Trial Balance by Acct Type and Full Acct Number (08/17/2022 - 7:33 AM)Page 14 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-170-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-170-502010 Social Security 18,075.45 14,518.22 0.00 3,557.23 19.68 10-170-502020 Group Health Insurance 24,473.08 17,204.13 0.00 7,268.95 29.70 10-170-502030 Retirement 30,812.70 23,763.10 0.00 7,049.60 22.88 10-170-502040 Workers Compensation 325.69 325.69 0.00 0.00 0.00 10-170-502050 Life Insurance 265.61 199.80 0.00 65.81 24.78 10-170-502060 Long Term Disability 566.96 422.88 0.00 144.08 25.41 10-170-502070 Employee Assistance Prgm 65.52 61.36 0.00 4.16 6.35 10-170-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 310,865.44 249,170.92 0.00 61,694.52 19.85 10-170-511010 Advertising 0.00 99.75 0.00 -99.75 0.00 10-170-511020 Postage 300.00 153.17 0.00 146.83 48.94 10-170-512010 Printing 800.00 0.00 0.00 800.00 100.00 10-170-512020 Copies 500.00 313.80 0.00 186.20 37.24 10-170-513010 Office Supplies 900.00 378.78 0.00 521.22 57.91 10-170-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-170-517010 Operational Supplies 800.00 168.03 0.00 631.97 79.00 E10 Materials & Supplies 3,300.00 1,113.53 0.00 2,186.47 66.26 10-170-520030 Dues And Publications 1,000.00 467.00 0.00 533.00 53.30 10-170-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-170-520060 Wellness Program 3,500.00 909.78 0.00 2,590.22 74.01 10-170-520070 Training And Education 5,220.00 1,445.98 0.00 3,774.02 72.30 10-170-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-170-521060 Drugalcohol Screening 0.00 0.00 0.00 0.00 0.00 10-170-521065 Background Checks 500.00 299.25 0.00 200.75 40.15 10-170-522020 Professional Services 32,500.00 9,967.86 19,000.00 3,532.14 10.87 10-170-529010 Special Events 800.00 67.40 0.00 732.60 91.58 10-170-529015 Human Relations Commission 500.00 0.00 0.00 500.00 100.00 E15 Contractual Services 44,020.00 13,157.27 19,000.00 11,862.73 26.95 10-170-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-170-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-170-547020 Maintenance Agreements 21,186.77 21,503.11 19.10 -335.44 -1.58 E25 Repairs & Maintenance 21,186.77 21,503.11 19.10 -335.44 -1.58 10-170-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 170 Human Resources 379,372.21 284,944.83 19,019.10 75,408.28 19.88 180 Finance Department 10-180-501020 Salaries 586,557.91 419,394.45 0.00 167,163.46 28.50 10-180-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-180-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-180-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (08/17/2022 - 7:33 AM)Page 15 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-180-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-180-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-180-502010 Social Security 47,143.35 31,619.15 0.00 15,524.20 32.93 10-180-502020 Group Health Insurance 103,286.70 58,468.61 0.00 44,818.09 43.39 10-180-502030 Retirement 85,042.90 50,387.90 0.00 34,655.00 40.75 10-180-502040 Workers Compensation 498.83 498.83 0.00 0.00 0.00 10-180-502050 Life Insurance 746.95 446.30 0.00 300.65 40.25 10-180-502060 Long Term Disability 1,758.64 1,071.53 0.00 687.11 39.07 10-180-502070 Employee Assistance Prgm 256.62 224.22 0.00 32.40 12.63 10-180-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 825,291.90 562,110.99 0.00 263,180.91 31.89 10-180-511010 Advertising 1,000.00 197.25 0.00 802.75 80.28 10-180-511020 Postage 10,000.00 7,203.98 0.00 2,796.02 27.96 10-180-511021 Mail Machine Cost 3,000.00 1,690.21 0.00 1,309.79 43.66 10-180-512010 Printing 3,300.00 771.97 0.00 2,528.03 76.61 10-180-512020 Copies 1,000.00 44.58 0.00 955.42 95.54 10-180-512021 Copy Machine Cost 190.00 -404.38 168.48 425.90 224.16 10-180-513010 Office Supplies 3,000.00 338.38 0.00 2,661.62 88.72 10-180-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-180-517010 Operational Supplies 4,500.00 4,059.87 0.00 440.13 9.78 E10 Materials & Supplies 25,990.00 13,901.86 168.48 11,919.66 45.86 10-180-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-180-520020 Auditing Travel Expenses 0.00 0.00 0.00 0.00 0.00 10-180-520030 Dues And Publications 2,300.00 1,330.00 0.00 970.00 42.17 10-180-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-180-520070 Training And Education 7,975.76 4,072.00 0.00 3,903.76 48.95 10-180-520080 Tuition Reimbursement 0.00 4,032.00 0.00 -4,032.00 0.00 10-180-522010 Audit 56,553.73 53,642.17 0.00 2,911.56 5.15 10-180-522015 Budget Expense 0.00 0.00 0.00 0.00 0.00 10-180-522020 Professional Services 300.00 160.00 0.00 140.00 46.67 E15 Contractual Services 67,129.49 63,236.17 0.00 3,893.32 5.80 10-180-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-180-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-180-547020 Maintenance Agreements 1,260.00 1,260.00 0.00 0.00 0.00 E25 Repairs & Maintenance 1,260.00 1,260.00 0.00 0.00 0.00 10-180-572020 Purchase Of Equipment 0.00 0.00 2,923.35 -2,923.35 0.00 E70 Capital Purchases 0.00 0.00 2,923.35 -2,923.35 0.00 180 Finance Department 919,671.39 640,509.02 3,091.83 276,070.54 30.02 185 Non-Departmental 10-185-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-185-501021 Vacancy Savings 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (08/17/2022 - 7:33 AM)Page 16 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-185-501022 Separation Incentive Prog Svgs 0.00 0.00 0.00 0.00 0.00 10-185-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-185-502021 Self Insurance-Group Health 0.00 0.00 0.00 0.00 0.00 10-185-502022 Wellness Assessment 36,967.43 35,758.52 0.00 1,208.91 3.27 10-185-502023 Self Insurance-Retirees 0.00 0.00 0.00 0.00 0.00 10-185-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-185-503010 Awards Program 6,000.00 0.00 0.00 6,000.00 100.00 10-185-504010 Employee Salary Guarantee Fund 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 42,967.43 35,758.52 0.00 7,208.91 16.78 10-185-514010 Gas 13,000.00 15,415.78 0.00 -2,415.78 -18.58 10-185-514011 Gas Oil & Antifreeze 0.00 0.00 0.00 0.00 0.00 10-185-514012 Gas, Oil, Antifreeze ALLOCATE 0.00 0.00 0.00 0.00 0.00 10-185-514015 Tornado 0.00 0.00 0.00 0.00 0.00 10-185-514016 Flooding 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 13,000.00 15,415.78 0.00 -2,415.78 -18.58 10-185-520030 Dues and Publications 0.00 49.00 0.00 -49.00 0.00 10-185-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-185-521010 General Insurance 445,389.47 670,148.15 0.00 -224,758.68 -50.46 10-185-521020 Insurance Deductible 25,000.00 69,126.07 0.00 -44,126.07 -176.50 10-185-521030 Self Ins Prop & Casualty 40,000.00 36,027.05 0.00 3,972.95 9.93 10-185-521060 Drugalcohol screening 3,564.00 2,443.00 0.00 1,121.00 31.45 10-185-521070 Prov For Unsettled Claims 0.00 0.00 0.00 0.00 0.00 10-185-522015 TIF Prof Svcs 0.00 0.00 0.00 0.00 0.00 10-185-522020 Professional Services 44,104.18 49,250.00 8,400.00 -13,545.82 -30.71 10-185-522023 LCRA Reimbursement 0.00 0.00 0.00 0.00 0.00 10-185-522025 JCTV 0.00 0.00 0.00 0.00 0.00 10-185-522035 Meeting Streaming & Recording 0.00 0.00 0.00 0.00 0.00 10-185-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-185-526030 Assessment Charge 47,000.00 0.00 0.00 47,000.00 100.00 10-185-527020 Economic Development 185,000.00 186,668.00 0.00 -1,668.00 -0.90 10-185-529010 Special Events 7,000.00 2,422.17 0.00 4,577.83 65.40 E15 Contractual Services 797,057.65 1,016,133.44 8,400.00 -227,475.79 -28.54 10-185-531010 Electricity 30,000.00 21,994.65 0.00 8,005.35 26.68 10-185-533010 Natural Gas 5,200.00 5,836.45 0.00 -636.45 -12.24 10-185-535010 Water 7,250.00 4,875.80 0.00 2,374.20 32.75 10-185-535020 Downtown Irrigation 0.00 0.00 0.00 0.00 0.00 E20 Utilities 42,450.00 32,706.90 0.00 9,743.10 22.95 10-185-540010 Building & Grounds Maint.122,417.27 124,252.14 0.00 -1,834.87 -1.50 10-185-540015 Amtrak Station 8,000.00 1,711.39 0.00 6,288.61 78.61 10-185-540020 Tree & Landscape Maint 25,000.00 25,000.00 0.00 0.00 0.00 10-185-547020 Maintenance Agreements 2,060.00 1,524.00 0.00 536.00 26.02 E25 Repairs & Maintenance 157,477.27 152,487.53 0.00 4,989.74 3.17 10-185-550010 Miscellaneous 4,000.00 13,098.00 0.00 -9,098.00 -227.45 10-185-550015 Bad Debt Expense 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (08/17/2022 - 7:33 AM)Page 17 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-185-550020 Neighborhood Reinvestment 0.00 0.00 0.00 0.00 0.00 10-185-550025 Contingency 0.00 0.00 0.00 0.00 0.00 10-185-550026 Addt'l PositionsEquipment 0.00 0.00 0.00 0.00 0.00 10-185-550030 Old Town Projects 0.00 0.00 0.00 0.00 0.00 10-185-550035 Old Town Redev Committee 0.00 0.00 0.00 0.00 0.00 10-185-550036 Salute to America 10,000.00 10,000.00 0.00 0.00 0.00 10-185-550037 Historic Preservation Comm 0.00 0.00 0.00 0.00 0.00 10-185-550038 Civil War Reenactment Comm 0.00 0.00 0.00 0.00 0.00 10-185-550040 Public Art 0.00 0.00 0.00 0.00 0.00 10-185-550041 ALPLA Settlement 0.00 0.00 0.00 0.00 0.00 10-185-550042 Jefferson Day Celebration 0.00 0.00 0.00 0.00 0.00 10-185-550043 JC Fire Museum 0.00 0.00 0.00 0.00 0.00 10-185-550044 Bicentennial Event 0.00 0.00 0.00 0.00 0.00 10-185-550045 Conference Center 0.00 0.00 0.00 0.00 0.00 10-185-550050 Neighb Stablization Prog 0.00 0.00 0.00 0.00 0.00 10-185-550060 MSP 0.00 0.00 0.00 0.00 0.00 10-185-550070 Energy Grant Expenditures 0.00 0.00 0.00 0.00 0.00 10-185-550080 Neighborhd Improvement Progr 0.00 0.00 0.00 0.00 0.00 10-185-550090 Hazard Mitigation 0.00 0.00 0.00 0.00 0.00 10-185-550095 Cap Ave Demos & Acquisitions 575,000.00 138,462.92 313,953.00 122,584.08 21.32 E30 Other Operating Expenses 589,000.00 161,560.92 313,953.00 113,486.08 19.27 10-185-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-185-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 10-185-572015 Vehicle Leasing 159,452.75 148,938.14 0.00 10,514.61 6.59 10-185-578073 Council Infrastructure Proj 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 159,452.75 148,938.14 0.00 10,514.61 6.59 10-185-580080 Note Principal 0.00 0.00 0.00 0.00 0.00 10-185-580090 Note Interest 0.00 0.00 0.00 0.00 0.00 E90 Debt Service 0.00 0.00 0.00 0.00 0.00 185 Non-Departmental 1,801,405.10 1,563,001.23 322,353.00 -83,949.13 -4.66 190 Information Technology Svcs 10-190-501020 Salaries 548,889.18 475,855.92 0.00 73,033.26 13.31 10-190-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-190-501050 Parttime(wo benefits)0.00 0.00 0.00 0.00 0.00 10-190-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-190-501090 Overtime 1,200.00 0.00 0.00 1,200.00 100.00 10-190-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-190-502010 Social Security 45,134.17 35,075.74 0.00 10,058.43 22.29 10-190-502020 Group Health Insurance 94,024.95 62,976.76 0.00 31,048.19 33.02 10-190-502030 Retirement 81,418.51 54,749.16 0.00 26,669.35 32.76 10-190-502040 Workers Compensation 1,358.21 1,358.21 0.00 0.00 0.00 10-190-502050 Life Insurance 699.52 500.14 0.00 199.38 28.50 10-190-502060 Long Term Disability 1,688.08 1,208.09 0.00 479.99 28.43 GL - Trial Balance by Acct Type and Full Acct Number (08/17/2022 - 7:33 AM)Page 18 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-190-502070 Employee Assistance Prgm 207.48 194.36 0.00 13.12 6.32 E05 Personnel Services 774,620.10 631,918.38 0.00 142,701.72 18.42 10-190-511010 Advertising 2,304.00 2,444.00 0.00 -140.00 -6.08 10-190-511020 Postage 115.00 110.87 0.00 4.13 3.59 10-190-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-190-512020 Copies 20.00 0.39 0.00 19.61 98.05 10-190-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-190-513010 Office Supplies 900.00 529.25 0.00 370.75 41.19 10-190-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-190-514030 Small Tools 0.00 0.00 0.00 0.00 0.00 10-190-514040 Food 0.00 0.00 0.00 0.00 0.00 10-190-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-190-517010 Operational Supplies 5,559.67 5,559.67 0.00 0.00 0.00 E10 Materials & Supplies 8,898.67 8,644.18 0.00 254.49 2.86 10-190-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-190-520030 Dues And Publications 300.00 139.00 0.00 161.00 53.67 10-190-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-190-520070 Training And Education 8,940.33 5,557.81 0.00 3,382.52 37.83 10-190-520080 Tuition Reimbursement 4,032.00 1,344.00 0.00 2,688.00 66.67 10-190-522020 Professional Services 44,195.71 250.00 39,900.00 4,045.71 9.15 10-190-522030 Services - Prof Training 0.00 0.00 0.00 0.00 0.00 10-190-522040 Service-internet T1 Web 23,000.00 17,440.78 0.00 5,559.22 24.17 10-190-522050 Service-remote Locations 0.00 0.00 0.00 0.00 0.00 10-190-522060 City Web Site 4,400.00 4,315.00 0.00 85.00 1.93 E15 Contractual Services 84,868.04 29,046.59 39,900.00 15,921.45 18.76 10-190-534010 Telephone 56,000.00 62,196.70 0.00 -6,196.70 -11.07 E20 Utilities 56,000.00 62,196.70 0.00 -6,196.70 -11.07 10-190-545010 Software Licensemaint 217,595.35 189,590.75 29,041.24 -1,036.64 -0.48 10-190-545020 Citywide Wiringnetwork 2,000.00 0.00 0.00 2,000.00 100.00 10-190-547010 Equipment Maintenance 2,000.00 759.98 0.00 1,240.02 62.00 10-190-547020 Maintenance Agreements 22,000.00 10,712.00 0.00 11,288.00 51.31 E25 Repairs & Maintenance 243,595.35 201,062.73 29,041.24 13,491.38 5.54 10-190-572020 Purchase Of Equipment 435.29 435.29 0.00 0.00 0.00 E70 Capital Purchases 435.29 435.29 0.00 0.00 0.00 190 Information Technology Svcs 1,168,417.45 933,303.87 68,941.24 166,172.34 14.22 300 Police Department 10-300-501020 Salaries 4,862,486.77 3,656,663.58 0.00 1,205,823.19 24.80 10-300-501030 Holiday Pay 176,918.37 77,278.58 0.00 99,639.79 56.32 10-300-501040 Part-time (wbenefits)34,764.59 0.00 0.00 34,764.59 100.00 10-300-501050 Parttime(wo Benefits)47,304.18 23,379.56 0.00 23,924.62 50.58 10-300-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-300-501070 Stand-by Plan 9,360.00 13,673.71 0.00 -4,313.71 -46.09 GL - Trial Balance by Acct Type and Full Acct Number (08/17/2022 - 7:33 AM)Page 19 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-300-501090 Overtime 307,140.24 222,411.56 0.00 84,728.68 27.59 10-300-501095 Overtime Straight Pay 13,275.00 14,292.82 0.00 -1,017.82 -7.67 10-300-502010 Social Security 413,014.82 290,303.54 0.00 122,711.28 29.71 10-300-502020 Group Health Insurance 920,452.34 602,821.29 0.00 317,631.05 34.51 10-300-502030 Retirement 988,207.96 642,238.14 0.00 345,969.82 35.01 10-300-502040 Workers Compensation 75,085.94 75,085.91 0.00 0.03 0.00 10-300-502050 Life Insurance 5,495.76 3,734.54 0.00 1,761.22 32.05 10-300-502060 Long Term Disability 13,637.73 9,259.41 0.00 4,378.32 32.10 10-300-502070 Employee Assistance Prgm 1,976.52 1,851.60 0.00 124.92 6.32 10-300-503010 Awards Program 4,233.00 4,233.00 0.00 0.00 0.00 10-300-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 7,873,353.22 5,637,227.24 0.00 2,236,125.98 28.40 10-300-511010 Advertising 5,665.00 8,754.50 0.00 -3,089.50 -54.54 10-300-511020 Postage 1,395.00 1,035.20 0.00 359.80 25.79 10-300-512010 Printing 4,452.00 4,345.49 0.00 106.51 2.39 10-300-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-300-512030 Photographic Supplies 634.90 79.99 0.00 554.91 87.40 10-300-513010 Office Supplies 15,670.50 17,800.35 0.00 -2,129.85 -13.59 10-300-514010 Gas 164,000.00 156,267.97 0.00 7,732.03 4.71 10-300-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-300-514040 Food 651.00 863.13 0.00 -212.13 -32.59 10-300-515040 First Aid Supplies 1,378.00 1,205.52 0.00 172.48 12.52 10-300-516010 Ammunition & Firearms Supplies 34,365.57 20,675.64 13,405.25 284.68 0.83 10-300-516020 Dare Program 0.00 90.00 0.00 -90.00 0.00 10-300-516030 Special Investigation 2,325.00 0.00 0.00 2,325.00 100.00 10-300-516040 Investigations (Grant)0.00 0.00 0.00 0.00 0.00 10-300-516050 Community Projects 12,750.00 12,750.00 0.00 0.00 0.00 10-300-517010 Operational Supplies 70,050.00 59,620.69 11,400.21 -970.90 -1.39 E10 Materials & Supplies 313,336.97 283,488.48 24,805.46 5,043.03 1.61 10-300-520030 Dues And Publications 5,400.00 5,085.36 0.00 314.64 5.83 10-300-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-300-520070 Training And Education 75,900.00 66,351.90 0.00 9,548.10 12.58 10-300-520080 Tuition Reimbursement 5,625.00 0.00 0.00 5,625.00 100.00 10-300-520090 Recruitment 2,325.00 3,078.07 0.00 -753.07 -32.39 10-300-521040 Medical Claimsservices 6,510.00 6,424.20 0.00 85.80 1.32 10-300-521050 Medical Services 0.00 0.00 0.00 0.00 0.00 10-300-522020 Professional Services 16,082.00 15,799.33 0.00 282.67 1.76 10-300-522026 Drug Forfeiture - Justice 74,953.39 60,486.70 13,065.60 1,401.09 1.87 10-300-522027 Drug Forfeiture - Treasury 0.00 0.00 0.00 0.00 0.00 10-300-522028 Police Evidence Funds 0.00 35,515.20 0.00 -35,515.20 0.00 10-300-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-300-523030 Building Lease 0.00 0.00 0.00 0.00 0.00 10-300-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-300-525020 Sober Driver Program 0.00 0.00 0.00 0.00 0.00 10-300-525050 Police Reserve 0.00 0.00 0.00 0.00 0.00 10-300-529010 Special Events 2,046.00 1,502.58 0.00 543.42 26.56 E15 Contractual Services 188,841.39 194,243.34 13,065.60 -18,467.55 -9.78 GL - Trial Balance by Acct Type and Full Acct Number (08/17/2022 - 7:33 AM)Page 20 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-300-531010 Electricity 32,140.00 23,160.88 0.00 8,979.12 27.94 10-300-533010 Natural Gas 1,116.00 714.35 0.00 401.65 35.99 10-300-534010 Telephone 24,101.00 19,401.78 0.00 4,699.22 19.50 10-300-535010 Water 3,348.00 2,083.56 0.00 1,264.44 37.77 E20 Utilities 60,705.00 45,360.57 0.00 15,344.43 25.28 10-300-540010 Building & Grounds Maint.49,700.00 55,040.16 0.00 -5,340.16 -10.74 10-300-541030 Vehicle Wash 9,752.00 7,881.80 0.00 1,870.20 19.18 10-300-544010 K-9 Operations 16,740.00 17,203.43 0.00 -463.43 -2.77 10-300-544015 Care of Animals 0.00 0.00 0.00 0.00 0.00 10-300-544020 Civil Defense 0.00 0.00 0.00 0.00 0.00 10-300-544030 Emerg Mgmt Operations 22,599.00 12,158.53 0.00 10,440.47 46.20 10-300-545010 Software Licensemaint 74,123.00 61,159.98 0.00 12,963.02 17.49 10-300-546010 Clothing Expense 51,687.00 17,667.80 37,859.55 -3,840.35 -7.43 10-300-546020 Uniform Cleaning 20,715.00 17,247.46 0.00 3,467.54 16.74 10-300-547010 Equipment Maintenance 6,500.00 2,875.23 0.00 3,624.77 55.77 10-300-547020 Maintenance Agreements 57,121.00 42,665.84 754.01 13,701.15 23.99 10-300-547030 Radio Maintenance 2,300.00 756.51 0.00 1,543.49 67.11 E25 Repairs & Maintenance 311,237.00 234,656.74 38,613.56 37,966.70 12.20 10-300-572010 Purchase Of Vehicles 88,833.60 88,468.28 0.00 365.32 0.41 10-300-572011 Purchase of Vehicles-Lease Pmt 0.00 0.00 0.00 0.00 0.00 10-300-572020 Purchase Of Equipment 65,930.10 36,382.50 29,547.60 0.00 0.00 10-300-572070 MDT Year 2 Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572075 LLEBG Annual Grant Equipment 53,192.80 0.00 46,750.00 6,442.80 12.11 10-300-572076 LLEBG Stimulus Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572078 BJA COVID Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572080 DEA Equipment Grant 0.00 0.00 0.00 0.00 0.00 10-300-572085 Bullet Proof Vest Grant 11,260.75 0.00 6,397.49 4,863.26 43.19 10-300-572100 MDT Year 3 Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572110 Jcpd Mdt Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572120 Cole Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572130 Osage B Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572140 Camden Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572150 Callaway Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572160 Fulton Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572170 Eldon Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572180 Miller Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572190 Camdenton Cty Mtd 0.00 0.00 0.00 0.00 0.00 10-300-572200 Lake Ozark Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572210 Cole Co Reimbursable Grant Exp 4,295.20 0.00 0.00 4,295.20 100.00 10-300-572310 Software-camdnmilob 0.00 0.00 0.00 0.00 0.00 10-300-572320 Software-morgan Cty 0.00 0.00 0.00 0.00 0.00 10-300-572330 Software-jcpdcole Cty 0.00 0.00 0.00 0.00 0.00 10-300-572340 Software-colboone Cty 0.00 0.00 0.00 0.00 0.00 10-300-572350 Software-fultncallaway 0.00 0.00 0.00 0.00 0.00 10-300-572360 Software-vpnfirewl 0.00 0.00 0.00 0.00 0.00 10-300-572370 Software-prof Serv 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (08/17/2022 - 7:33 AM)Page 21 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-300-572410 Project Mgmt Fees 0.00 0.00 0.00 0.00 0.00 10-300-572420 Contingency 0.00 0.00 0.00 0.00 0.00 10-300-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 223,512.45 124,850.78 82,695.09 15,966.58 7.14 300 Police Department 8,970,986.03 6,519,827.15 159,179.71 2,291,979.17 25.55 310 School Resource Officer 10-310-501020 Salaries 444,344.05 262,052.14 0.00 182,291.91 41.02 10-310-501030 Holiday Pay 17,071.90 4,459.23 0.00 12,612.67 73.88 10-310-501090 Overtime 45,106.00 33,425.13 0.00 11,680.87 25.90 10-310-501095 Overtime Straight Pay 1,311.00 2,627.53 0.00 -1,316.53 -100.42 10-310-502010 Social Security 38,850.99 21,702.26 0.00 17,148.73 44.14 10-310-502020 Group Health Insurance 94,284.62 48,862.11 0.00 45,422.51 48.18 10-310-502030 Retirement 96,492.66 54,637.23 0.00 41,855.43 43.38 10-310-502040 Workers Compensation 6,552.86 6,552.86 0.00 0.00 0.00 10-310-502050 Life Insurance 504.29 273.69 0.00 230.60 45.73 10-310-502060 Long Term Disability 1,247.26 679.13 0.00 568.13 45.55 10-310-502070 Employee Assistance Prgm 174.72 163.68 0.00 11.04 6.32 E05 Personnel Services 745,940.35 435,434.99 0.00 310,505.36 41.63 10-310-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-310-516020 Dare Program 15,345.00 3,036.46 0.00 12,308.54 80.21 10-310-517010 Operational Supplies 5,995.00 6,208.10 0.00 -213.10 -3.55 E10 Materials & Supplies 21,340.00 9,244.56 0.00 12,095.44 56.68 10-310-520070 Training And Education 4,650.00 1,264.00 0.00 3,386.00 72.82 10-310-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 4,650.00 1,264.00 0.00 3,386.00 72.82 10-310-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-310-546010 Clothing Expense 6,974.00 2,736.90 4,899.00 -661.90 -9.49 10-310-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-310-547020 Maintenance Agreements 360.00 0.00 0.00 360.00 100.00 E25 Repairs & Maintenance 7,334.00 2,736.90 4,899.00 -301.90 -4.12 10-310-572010 Purchase Of Vehicles 0.00 0.00 0.00 0.00 0.00 10-310-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 310 School Resource Officer 779,264.35 448,680.45 4,899.00 325,684.90 41.79 320 M.U.S.T.A.N.G. 10-320-501020 Salaries 108,859.54 88,677.09 0.00 20,182.45 18.54 10-320-501030 Holiday Pay 4,112.08 0.00 0.00 4,112.08 100.00 10-320-501090 Overtime 29,776.88 18,473.38 0.00 11,303.50 37.96 10-320-501095 Overtime Straight Pay 0.00 428.36 0.00 -428.36 0.00 10-320-502010 Social Security 9,511.13 7,941.08 0.00 1,570.05 16.51 10-320-502020 Group Health Insurance 19,512.74 13,602.99 0.00 5,909.75 30.29 GL - Trial Balance by Acct Type and Full Acct Number (08/17/2022 - 7:33 AM)Page 22 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-320-502030 Retirement 23,622.41 19,489.99 0.00 4,132.42 17.49 10-320-502040 Workers Compensation 2,004.39 2,004.39 0.00 0.00 0.00 10-320-502050 Life Insurance 118.73 89.55 0.00 29.18 24.58 10-320-502060 Long Term Disability 293.76 221.40 0.00 72.36 24.63 10-320-502070 Employee Assistance Prgm 43.68 40.92 0.00 2.76 6.32 E05 Personnel Services 197,855.34 150,969.15 0.00 46,886.19 23.70 10-320-514010 Gas 11,348.00 9,547.62 0.00 1,800.38 15.87 10-320-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-320-516040 Investigations 13,906.00 11,280.71 0.00 2,625.29 18.88 10-320-517010 Operational Supplies 8,446.20 999.95 0.00 7,446.25 88.16 E10 Materials & Supplies 33,700.20 21,828.28 0.00 11,871.92 35.23 10-320-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-320-520070 Training And Education 0.00 0.00 0.00 0.00 0.00 10-320-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-320-522025 Drug Forfeiture - MUSTANG 0.00 0.00 0.00 0.00 0.00 10-320-523010 Equipment Rentlease 22,152.72 13,500.00 0.00 8,652.72 39.06 10-320-523020 Building Lease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 22,152.72 13,500.00 0.00 8,652.72 39.06 10-320-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-320-546010 Clothing Expense 0.00 0.00 0.00 0.00 0.00 10-320-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-320-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 10-320-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 320 M.U.S.T.A.N.G.253,708.26 186,297.43 0.00 67,410.83 26.57 330 Animal Control 10-330-501020 Salaries 363,190.92 263,962.96 0.00 99,227.96 27.32 10-330-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-330-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-330-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-330-501070 Stand-by Plan 8,600.00 6,308.00 0.00 2,292.00 26.65 10-330-501090 Overtime 2,000.00 6,492.61 0.00 -4,492.61 -224.63 10-330-501095 Overtime Straight Pay 0.00 79.09 0.00 -79.09 0.00 10-330-502010 Social Security 28,595.00 19,546.67 0.00 9,048.33 31.64 10-330-502020 Group Health Insurance 93,893.80 54,067.32 0.00 39,826.48 42.42 10-330-502030 Retirement 51,583.15 30,343.70 0.00 21,239.45 41.18 10-330-502040 Workers Compensation 4,681.08 4,681.08 0.00 0.00 0.00 10-330-502050 Life Insurance 434.52 270.43 0.00 164.09 37.76 10-330-502060 Long Term Disability 1,077.61 664.44 0.00 413.17 38.34 10-330-502070 Employee Assistance Prgm 174.72 163.68 0.00 11.04 6.32 10-330-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 554,230.80 386,579.98 0.00 167,650.82 30.25 GL - Trial Balance by Acct Type and Full Acct Number (08/17/2022 - 7:33 AM)Page 23 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-330-511010 Advertising 405.00 991.75 0.00 -586.75 -144.88 10-330-511020 Postage 152.00 157.12 0.00 -5.12 -3.37 10-330-512010 Printing 1,860.00 871.74 0.00 988.26 53.13 10-330-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-330-513010 Office Supplies 1,581.00 558.59 0.00 1,022.41 64.67 10-330-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-330-514030 Small Tools 0.00 0.00 0.00 0.00 0.00 10-330-514040 Food 223.00 140.94 0.00 82.06 36.80 10-330-515040 First Aid Supplies 295.00 261.64 0.00 33.36 11.31 10-330-517010 Operational Supplies 12,016.00 4,089.30 0.00 7,926.70 65.97 E10 Materials & Supplies 16,532.00 7,071.08 0.00 9,460.92 57.23 10-330-520030 Dues And Publications 1,491.00 31.25 0.00 1,459.75 97.90 10-330-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-330-520070 Training And Education 2,611.00 1,538.00 0.00 1,073.00 41.10 10-330-521040 Medical Claimsservices 432.00 1,298.60 0.00 -866.60 -200.60 10-330-522020 Professional Services 6,510.00 1,352.00 0.00 5,158.00 79.23 10-330-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-330-529045 Veterinary Services 5,208.00 3,434.61 0.00 1,773.39 34.05 10-330-529050 Spay & Neuter Program 0.00 0.00 0.00 0.00 0.00 10-330-529060 Special Sn Program 0.00 0.00 0.00 0.00 0.00 10-330-529065 Adoption Voucher Program 0.00 0.00 0.00 0.00 0.00 10-330-529067 Animal Shelter Bricks 0.00 0.00 0.00 0.00 0.00 10-330-529068 Animal Shelter Donations 33,031.25 0.00 33,031.25 0.00 0.00 E15 Contractual Services 49,283.25 7,654.46 33,031.25 8,597.54 17.45 10-330-531010 Electricity 22,789.00 17,510.86 0.00 5,278.14 23.16 10-330-533010 Natural Gas 18,000.00 20,529.61 0.00 -2,529.61 -14.05 10-330-534010 Telephone 580.00 738.23 0.00 -158.23 -27.28 10-330-535010 Water 3,800.00 2,365.14 0.00 1,434.86 37.76 E20 Utilities 45,169.00 41,143.84 0.00 4,025.16 8.91 10-330-540010 Building & Grounds Maint.15,000.00 24,782.98 30.00 -9,812.98 -65.42 10-330-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-330-541030 Vehicle Wash 540.00 540.00 0.00 0.00 0.00 10-330-544040 Care Of Animals 49,290.00 36,923.96 0.00 12,366.04 25.09 10-330-544050 Animal Food 6,603.00 3,531.33 0.00 3,071.67 46.52 10-330-545010 Software Licensemaint 3,191.00 2,778.08 495.29 -82.37 -2.58 10-330-546010 Clothing Expense 2,325.00 1,055.12 0.00 1,269.88 54.62 10-330-546020 Uniform Cleaning 0.00 0.00 0.00 0.00 0.00 10-330-547010 Equipment Maintenance 837.00 836.17 0.00 0.83 0.10 10-330-547020 Maintenance Agreements 360.00 510.02 0.00 -150.02 -41.67 10-330-547030 Radio Maintenance 60.00 0.00 0.00 60.00 100.00 10-330-547040 Crematory Maint & Repair 1,750.00 61.20 0.00 1,688.80 96.50 E25 Repairs & Maintenance 79,956.00 71,018.86 525.29 8,411.85 10.52 10-330-572010 Purchase of Vehicles 25,523.00 25,523.00 0.00 0.00 0.00 10-330-572020 Purchase Of Equipment 4,600.00 4,600.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (08/17/2022 - 7:33 AM)Page 24 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-330-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 30,123.00 30,123.00 0.00 0.00 0.00 10-330-578069 Animal Shelter 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 0.00 0.00 0.00 0.00 0.00 330 Animal Control 775,294.05 543,591.22 33,556.54 198,146.29 25.56 390 9-1-1 Police 10-390-501020 Salaries 912,707.94 641,965.65 0.00 270,742.29 29.66 10-390-501030 Holiday Pay 31,748.70 22,801.48 0.00 8,947.22 28.18 10-390-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-390-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-390-501090 Overtime 22,814.00 36,855.23 0.00 -14,041.23 -61.55 10-390-501095 Overtime Straight Pay 500.00 1,509.06 0.00 -1,009.06 -201.81 10-390-502010 Social Security 74,033.04 51,341.45 0.00 22,691.59 30.65 10-390-502020 Group Health Insurance 217,337.41 123,596.85 0.00 93,740.56 43.13 10-390-502030 Retirement 135,500.14 91,771.58 0.00 43,728.56 32.27 10-390-502040 Workers Compensation 2,719.96 2,719.96 0.00 0.00 0.00 10-390-502050 Life Insurance 1,093.34 685.05 0.00 408.29 37.34 10-390-502060 Long Term Disability 2,691.88 1,696.89 0.00 994.99 36.96 10-390-502070 Employee Assistance Prgm 464.10 434.76 0.00 29.34 6.32 10-390-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 1,401,610.51 975,377.96 0.00 426,232.55 30.41 10-390-511010 Advertising 928.00 1,702.50 0.00 -774.50 -83.46 10-390-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-390-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-390-517010 Operational Supplies 6,225.00 8,412.02 0.00 -2,187.02 -35.13 E10 Materials & Supplies 7,153.00 10,114.52 0.00 -2,961.52 -41.40 10-390-520030 Dues And Publications 558.00 0.00 0.00 558.00 100.00 10-390-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-390-520070 Training And Education 4,650.00 1,020.40 0.00 3,629.60 78.06 10-390-522020 Professional Services 3,000.00 2,439.41 0.00 560.59 18.69 10-390-523010 Equipment Rentlease 96,760.00 63,529.82 0.00 33,230.18 34.34 E15 Contractual Services 104,968.00 66,989.63 0.00 37,978.37 36.18 10-390-531010 Electricity 11,160.00 9,559.40 0.00 1,600.60 14.34 10-390-533010 Natural Gas 279.00 234.00 0.00 45.00 16.13 10-390-534010 Telephone 0.00 0.00 0.00 0.00 0.00 10-390-535010 Water 837.00 715.23 0.00 121.77 14.55 E20 Utilities 12,276.00 10,508.63 0.00 1,767.37 14.40 10-390-545010 Software Licensemaint 42,901.00 46,535.53 0.00 -3,634.53 -8.47 10-390-546010 Clothing Expense 5,580.00 2,119.91 0.00 3,460.09 62.01 10-390-546020 Uniform Cleaning 2,976.00 1,315.80 0.00 1,660.20 55.79 10-390-547010 Equipment Maintenance 6,700.00 5,341.01 1,043.62 315.37 4.71 10-390-547020 Maintenance Agreements 88,613.00 61,583.09 8,747.57 18,282.34 20.63 GL - Trial Balance by Acct Type and Full Acct Number (08/17/2022 - 7:33 AM)Page 25 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-390-547030 Radio Maintenance 4,650.00 0.00 0.00 4,650.00 100.00 E25 Repairs & Maintenance 151,420.00 116,895.34 9,791.19 24,733.47 16.33 10-390-572020 Purchase Of Equipment 30,545.00 16,310.00 14,235.01 -0.01 0.00 E70 Capital Purchases 30,545.00 16,310.00 14,235.01 -0.01 0.00 390 9-1-1 Police 1,707,972.51 1,196,196.08 24,026.20 487,750.23 28.56 400 Fire Department 10-400-501020 Salaries 4,001,867.89 3,162,911.70 0.00 838,956.19 20.96 10-400-501030 Holiday Pay 329,190.84 303,924.46 0.00 25,266.38 7.68 10-400-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-400-501080 Step-up Pay 38,000.00 24,668.85 0.00 13,331.15 35.08 10-400-501090 Overtime 45,000.00 86,461.54 0.00 -41,461.54 -92.14 10-400-501095 Overtime Straight Pay 40,000.00 69,998.57 0.00 -29,998.57 -75.00 10-400-502010 Social Security 67,074.57 52,101.09 0.00 14,973.48 22.32 10-400-502020 Group Health Insurance 857,281.66 574,690.93 0.00 282,590.73 32.96 10-400-502030 Retirement 2,168,347.96 1,652,242.27 0.00 516,105.69 23.80 10-400-502040 Workers Compensation 153,030.95 153,030.95 0.00 0.00 0.00 10-400-502050 Life Insurance 4,724.64 3,462.61 0.00 1,262.03 26.71 10-400-502060 Long Term Disability 11,754.80 8,486.94 0.00 3,267.86 27.80 10-400-502070 Employee Assistance Prgm 1,659.84 1,554.92 0.00 104.92 6.32 10-400-503010 Awards Program 1,500.00 499.02 0.00 1,000.98 66.73 E05 Personnel Services 7,719,433.15 6,094,033.85 0.00 1,625,399.30 21.06 10-400-511010 Advertising 300.00 105.00 0.00 195.00 65.00 10-400-511020 Postage 139.50 143.83 0.00 -4.33 -3.10 10-400-512010 Printing 700.00 263.22 0.00 436.78 62.40 10-400-512020 Copies 46.50 0.00 0.00 46.50 100.00 10-400-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-400-513010 Office Supplies 1,395.00 1,006.72 0.00 388.28 27.83 10-400-514010 Gas 59,000.00 68,115.50 0.00 -9,115.50 -15.45 10-400-514017 COVID-19 8,481.00 10,069.27 0.00 -1,588.27 -18.73 10-400-514020 Chemicals 930.00 100.00 0.00 830.00 89.25 10-400-514030 Small Tools 6,000.00 3,830.99 0.00 2,169.01 36.15 10-400-514040 Food 0.00 0.00 0.00 0.00 0.00 10-400-515040 First Aid Supplies 2,046.00 1,465.55 0.00 580.45 28.37 10-400-517010 Operational Supplies 17,000.00 5,812.02 0.00 11,187.98 65.81 E10 Materials & Supplies 96,038.00 90,912.10 0.00 5,125.90 5.34 10-400-520030 Dues And Publications 3,373.65 3,462.09 0.00 -88.44 -2.62 10-400-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-400-520060 Wellness Program 0.00 0.00 0.00 0.00 0.00 10-400-520070 Training And Education 32,427.51 24,775.34 0.00 7,652.17 23.60 10-400-520080 Tuition Reimbursement 7,045.00 6,048.00 0.00 997.00 14.15 10-400-520085 Traing-Home Land Security 0.00 0.00 0.00 0.00 0.00 10-400-521040 Medical Claimsservices 40,000.00 33,440.00 0.00 6,560.00 16.40 10-400-522020 Professional Services 3,333.00 2,067.73 0.00 1,265.27 37.96 10-400-523010 Equipment Rentlease 186.00 0.00 0.00 186.00 100.00 GL - Trial Balance by Acct Type and Full Acct Number (08/17/2022 - 7:33 AM)Page 26 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-400-524010 Trash Collections 93.00 0.00 0.00 93.00 100.00 10-400-529010 Special Events 6,510.00 4,969.33 0.00 1,540.67 23.67 10-400-529040 Child Safety Seat Pass-through 2,500.00 1,605.00 0.00 895.00 35.80 E15 Contractual Services 95,468.16 76,367.49 0.00 19,100.67 20.01 10-400-531010 Electricity 35,000.00 27,010.92 0.00 7,989.08 22.83 10-400-533010 Natural Gas 17,670.00 19,392.49 0.00 -1,722.49 -9.75 10-400-534010 Telephone 25,984.20 19,834.91 0.00 6,149.29 23.67 10-400-535010 Water 12,000.00 8,393.81 0.00 3,606.19 30.05 E20 Utilities 90,654.20 74,632.13 0.00 16,022.07 17.67 10-400-540010 Building & Grounds Maint.98,455.49 74,515.86 17,100.00 6,839.63 6.95 10-400-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-400-546010 Clothing Expense 96,004.91 84,628.61 0.00 11,376.30 11.85 10-400-546020 Uniform Cleaning 500.00 0.00 0.00 500.00 100.00 10-400-547010 Equipment Maintenance 20,667.24 7,759.73 0.00 12,907.51 62.45 10-400-547020 Maintenance Agreements 38,412.76 33,325.69 -51.19 5,138.26 13.38 10-400-547030 Radio Maintenance 20,925.00 13,585.11 0.00 7,339.89 35.08 E25 Repairs & Maintenance 274,965.40 213,815.00 17,048.81 44,101.59 16.04 10-400-572010 Purchase Of Vehicles 0.00 0.00 0.00 0.00 0.00 10-400-572011 Purchase of Vehicles-Lease Pmt 0.00 0.00 0.00 0.00 0.00 10-400-572020 Purchase Of Equipment 0.00 1,719.69 0.00 -1,719.69 0.00 10-400-572021 Purchase of Equipment-ONE TIME 24,640.00 22,310.00 0.00 2,330.00 9.46 10-400-572022 Fitness-ONE TIME 0.00 0.00 0.00 0.00 0.00 10-400-572060 Fire Grant Equipgear 0.00 0.00 0.00 0.00 0.00 10-400-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 10-400-575004 Fire Apparatus 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 24,640.00 24,029.69 0.00 610.31 2.48 400 Fire Department 8,301,198.91 6,573,790.26 17,048.81 1,710,359.84 20.60 401 Fire Museum 10-401-531010 Electricity 1,860.00 1,941.03 0.00 -81.03 -4.36 10-401-533010 Natural Gas 0.00 0.00 0.00 0.00 0.00 10-401-535010 Water 0.00 0.00 0.00 0.00 0.00 E20 Utilities 1,860.00 1,941.03 0.00 -81.03 -4.36 10-401-540010 Building & Grounds Maint.0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 401 Fire Museum 1,860.00 1,941.03 0.00 -81.03 -4.36 500 Public Works 10-500-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-500-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-500-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-500-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-500-502010 Social Security 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (08/17/2022 - 7:33 AM)Page 27 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-500-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-500-502030 Retirement 0.00 0.00 0.00 0.00 0.00 10-500-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-500-502050 Life Insurance 0.00 0.00 0.00 0.00 0.00 10-500-502060 Long Term Disability 0.00 0.00 0.00 0.00 0.00 10-500-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 0.00 0.00 0.00 0.00 0.00 10-500-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-500-511020 Postage 0.00 0.00 0.00 0.00 0.00 10-500-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-500-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-500-513010 Office Supplies 0.00 0.00 0.00 0.00 0.00 10-500-514040 Food 0.00 0.00 0.00 0.00 0.00 10-500-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 0.00 0.00 0.00 0.00 0.00 10-500-520030 Dues And Publications 0.00 0.00 0.00 0.00 0.00 10-500-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-500-520070 Training And Education 0.00 0.00 0.00 0.00 0.00 10-500-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-500-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-500-527010 Comm Serv Projects 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 0.00 0.00 0.00 0.00 0.00 10-500-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-500-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 10-500-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-500-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 500 Public Works 0.00 0.00 0.00 0.00 0.00 520 Plan & Protect Svcs-Admin 10-520-501020 Salaries 233,614.13 180,562.13 0.00 53,052.00 22.71 10-520-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-520-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-520-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-520-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-520-502010 Social Security 17,871.48 13,195.47 0.00 4,676.01 26.16 10-520-502020 Group Health Insurance 31,670.84 28,473.51 0.00 3,197.33 10.10 10-520-502030 Retirement 32,238.75 21,555.14 0.00 10,683.61 33.14 10-520-502040 Workers Compensation 196.90 196.90 0.00 0.00 0.00 10-520-502050 Life Insurance 275.40 191.70 0.00 83.70 30.39 10-520-502060 Long Term Disability 605.64 411.56 0.00 194.08 32.05 GL - Trial Balance by Acct Type and Full Acct Number (08/17/2022 - 7:33 AM)Page 28 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-520-502070 Employee Assistance Prgm 87.36 61.36 0.00 26.00 29.76 10-520-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 316,560.50 244,647.77 0.00 71,912.73 22.72 10-520-511010 Advertising 100.00 0.00 0.00 100.00 100.00 10-520-511020 Postage 75.00 157.04 0.00 -82.04 -109.39 10-520-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-520-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-520-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-520-513010 Office Supplies 850.00 444.36 0.00 405.64 47.72 10-520-514010 Gas 13,000.00 11,667.35 0.00 1,332.65 10.25 10-520-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-520-514030 Small Tools 0.00 0.00 0.00 0.00 0.00 10-520-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-520-517010 Operational Supplies 500.00 254.48 0.00 245.52 49.10 E10 Materials & Supplies 14,525.00 12,523.23 0.00 2,001.77 13.78 10-520-520030 Dues And Publications 1,200.00 1,320.85 0.00 -120.85 -10.07 10-520-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-520-520070 Training And Education 1,800.00 25.00 0.00 1,775.00 98.61 10-520-522020 Professional Services 9,756.70 7,251.21 0.00 2,505.49 25.68 E15 Contractual Services 12,756.70 8,597.06 0.00 4,159.64 32.61 10-520-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-520-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-520-547020 Maintenance Agreements 28,348.00 38,647.96 7.49 -10,307.45 -36.36 E25 Repairs & Maintenance 28,348.00 38,647.96 7.49 -10,307.45 -36.36 10-520-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 520 Plan & Protect Svcs-Admin 372,190.20 304,416.02 7.49 67,766.69 18.21 521 Plan & Protect Svcs-Planning 10-521-501020 Salaries 136,004.52 78,553.82 0.00 57,450.70 42.24 10-521-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-521-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-521-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-521-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-521-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-521-502010 Social Security 11,226.98 5,870.36 0.00 5,356.62 47.71 10-521-502020 Group Health Insurance 25,099.96 11,809.92 0.00 13,290.04 52.95 10-521-502030 Retirement 20,252.59 8,780.21 0.00 11,472.38 56.65 10-521-502040 Workers Compensation 158.35 158.35 0.00 0.00 0.00 10-521-502050 Life Insurance 176.62 86.12 0.00 90.50 51.24 10-521-502060 Long Term Disability 435.33 214.16 0.00 221.17 50.81 10-521-502070 Employee Assistance Prgm 58.97 55.24 0.00 3.73 6.33 GL - Trial Balance by Acct Type and Full Acct Number (08/17/2022 - 7:33 AM)Page 29 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-521-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 193,413.32 105,528.18 0.00 87,885.14 45.44 10-521-511010 Advertising 4,000.00 2,891.50 0.00 1,108.50 27.71 10-521-511020 Postage 500.00 81.06 0.00 418.94 83.79 10-521-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-521-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-521-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-521-513010 Office Supplies 800.00 258.79 0.00 541.21 67.65 10-521-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-521-514040 Food 200.00 0.00 0.00 200.00 100.00 10-521-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-521-517010 Operational Supplies 1,500.00 1,051.96 0.00 448.04 29.87 E10 Materials & Supplies 7,000.00 4,283.31 0.00 2,716.69 38.81 10-521-520030 Dues And Publications 14,329.49 14,373.68 0.00 -44.19 -0.31 10-521-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-521-520070 Training And Education 2,400.00 0.00 0.00 2,400.00 100.00 10-521-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-521-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-521-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 16,729.49 14,373.68 0.00 2,355.81 14.08 10-521-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-521-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-521-547020 Maintenance Agreements 1,552.00 975.14 130.10 446.76 28.79 E25 Repairs & Maintenance 1,552.00 975.14 130.10 446.76 28.79 10-521-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 521 Plan & Protect Svcs-Planning 218,694.81 125,160.31 130.10 93,404.40 42.71 522 Plan & Protect Svcs-MPO 10-522-501020 Salaries 121,616.91 95,058.92 0.00 26,557.99 21.84 10-522-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-522-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-522-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-522-502010 Social Security 9,686.19 7,214.80 0.00 2,471.39 25.51 10-522-502020 Group Health Insurance 20,600.84 12,748.61 0.00 7,852.23 38.12 10-522-502030 Retirement 17,473.13 12,216.22 0.00 5,256.91 30.09 10-522-502040 Workers Compensation 102.55 102.55 0.00 0.00 0.00 10-522-502050 Life Insurance 150.91 102.43 0.00 48.48 32.13 10-522-502060 Long Term Disability 374.46 253.98 0.00 120.48 32.17 10-522-502070 Employee Assistance Prgm 50.23 47.04 0.00 3.19 6.35 E05 Personnel Services 170,055.22 127,744.55 0.00 42,310.67 24.88 GL - Trial Balance by Acct Type and Full Acct Number (08/17/2022 - 7:33 AM)Page 30 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-522-511010 Advertising 1,800.00 546.05 0.00 1,253.95 69.66 10-522-511020 Postage 200.00 0.00 0.00 200.00 100.00 10-522-512010 Printing 125.00 0.00 0.00 125.00 100.00 10-522-512020 Copies 10.00 0.00 0.00 10.00 100.00 10-522-513010 Office Supplies 1,000.00 29.28 0.00 970.72 97.07 10-522-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-522-514040 Food 250.00 0.00 0.00 250.00 100.00 10-522-517010 Operational Supplies 1,620.00 31.89 0.00 1,588.11 98.03 E10 Materials & Supplies 5,005.00 607.22 0.00 4,397.78 87.87 10-522-520030 Dues And Publications 1,500.00 1,273.87 0.00 226.13 15.08 10-522-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-522-520070 Training And Education 4,500.00 20.00 0.00 4,480.00 99.56 10-522-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-522-522020 Professional Services 108,000.00 18,988.00 89,112.00 -100.00 -0.09 10-522-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 114,000.00 20,281.87 89,112.00 4,606.13 4.04 10-522-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-522-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-522-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-522-547020 Maintenance Agreements 1,533.00 1,000.36 119.79 412.85 26.93 10-522-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 1,533.00 1,000.36 119.79 412.85 26.93 10-522-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 522 Plan & Protect Svcs-MPO 290,593.22 149,634.00 89,231.79 51,727.43 17.80 530 Plan & Protect Svc-RedevGrant 10-530-501020 Salaries 64,752.71 62,981.41 0.00 1,771.30 2.74 10-530-501050 Parttime (wo Benefits)0.00 0.00 0.00 0.00 0.00 10-530-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-530-502010 Social Security 4,953.58 4,726.24 0.00 227.34 4.59 10-530-502020 Group Health Insurance 12,101.67 7,844.59 0.00 4,257.08 35.18 10-530-502030 Retirement 8,935.87 7,828.95 0.00 1,106.92 12.39 10-530-502040 Workers Compensation 58.08 58.08 0.00 0.00 0.00 10-530-502050 Life Insurance 77.72 64.88 0.00 12.84 16.52 10-530-502060 Long Term Disability 191.56 160.21 0.00 31.35 16.37 10-530-502070 Employee Assistance Prgm 32.76 20.44 0.00 12.32 37.61 E05 Personnel Services 91,103.95 83,684.80 0.00 7,419.15 8.14 10-530-511010 Advertising 45.00 1,820.00 0.00 -1,775.00 -3,944.44 10-530-511020 Postage 25.00 70.92 0.00 -45.92 -183.68 10-530-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-530-512020 Copies 0.00 1.16 0.00 -1.16 0.00 GL - Trial Balance by Acct Type and Full Acct Number (08/17/2022 - 7:33 AM)Page 31 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-530-513010 Office Supplies 0.00 633.94 0.00 -633.94 0.00 10-530-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-530-517010 Operational Supplies 2,805.37 3,069.24 0.00 -263.87 -9.41 E10 Materials & Supplies 2,875.37 5,595.26 0.00 -2,719.89 -94.59 10-530-520030 Dues And Publications 500.00 688.78 0.00 -188.78 -37.76 10-530-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-530-520070 Training And Education 1,494.63 3,963.74 0.00 -2,469.11 -165.20 10-530-522020 Professional Services 240.00 0.00 0.00 240.00 100.00 10-530-524020 Recycle Collectprocess 0.00 0.00 0.00 0.00 0.00 10-530-524024 Mid-Mo Solid Wast Mgmt Dist 0.00 0.00 0.00 0.00 0.00 10-530-524025 Glass Recycling 5,000.00 0.00 0.00 5,000.00 100.00 10-530-524026 Household Hazardous Waste 31,300.00 22,892.09 0.00 8,407.91 26.86 10-530-524027 Portable Recycling 0.00 0.00 0.00 0.00 0.00 10-530-524028 Misc Recycling 0.00 0.00 0.00 0.00 0.00 10-530-524029 Recycling Education 18,000.00 0.00 0.00 18,000.00 100.00 10-530-526060 Refund of Grant Proceeds 78,805.90 78,457.55 0.00 348.35 0.44 10-530-528085 Fair Housing Assistance Prog 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 135,340.53 106,002.16 0.00 29,338.37 21.68 10-530-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-530-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-530-547020 Maintenance Agreements 361.00 0.00 0.00 361.00 100.00 E25 Repairs & Maintenance 361.00 0.00 0.00 361.00 100.00 10-530-550020 NRA-Residential 40,000.00 33,852.51 0.00 6,147.49 15.37 10-530-550030 NRA-Commercial Facade 19,500.00 12,000.00 0.00 7,500.00 38.46 10-530-550031 Historic Preservation Grant 23,000.00 10,016.33 2,750.00 10,233.67 44.49 10-530-550032 NRA-Rental Facade 15,000.00 108.00 0.00 14,892.00 99.28 10-530-550033 HPF Grant-Structural Survey 0.00 0.00 0.00 0.00 0.00 10-530-550035 Old Town Redev Committee 0.00 0.00 0.00 0.00 0.00 10-530-550037 Historic Preservation Comm 500.00 60.00 0.00 440.00 88.00 10-530-550039 Historic Preservation Grant 23,000.00 10,016.33 2,750.00 10,233.67 44.49 10-530-550050 Neighb Stablization Prog 0.00 0.00 0.00 0.00 0.00 10-530-550055 HERO 0.00 0.00 0.00 0.00 0.00 10-530-550060 MSP 0.00 0.00 0.00 0.00 0.00 10-530-550066 HPF-Historic Context 50,000.00 16.34 42,500.00 7,483.66 14.97 10-530-550067 HPF PBruhn Revitalization 0.00 0.00 0.00 0.00 0.00 10-530-550090 Hazard Mitigation 0.00 0.00 0.00 0.00 0.00 E30 Other Operating Expenses 171,000.00 66,069.51 48,000.00 56,930.49 33.29 530 Plan & Protect Svc-RedevGrant 400,680.85 261,351.73 48,000.00 91,329.12 22.79 531 Plan & Protect Svcs-Build Reg 10-531-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-531-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-531-501090 Overtime 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (08/17/2022 - 7:33 AM)Page 32 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-531-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-531-502010 Social Security 0.00 0.00 0.00 0.00 0.00 10-531-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-531-502030 Retirement 0.00 0.00 0.00 0.00 0.00 10-531-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-531-502050 Life Insurance 0.00 0.00 0.00 0.00 0.00 10-531-502060 Long Term Disability 0.00 0.00 0.00 0.00 0.00 10-531-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 0.00 0.00 0.00 0.00 0.00 10-531-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-531-511020 Postage 0.00 0.00 0.00 0.00 0.00 10-531-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-531-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-531-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-531-513010 Office Supplies 0.00 0.00 0.00 0.00 0.00 10-531-514030 Small Tools 0.00 0.00 0.00 0.00 0.00 10-531-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-531-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 0.00 0.00 0.00 0.00 0.00 10-531-520030 Dues And Publications 0.00 0.00 0.00 0.00 0.00 10-531-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-531-520070 Training And Education 0.00 0.00 0.00 0.00 0.00 10-531-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-531-522021 Abatement 0.00 0.00 0.00 0.00 0.00 10-531-522022 Demo 0.00 0.00 0.00 0.00 0.00 10-531-522070 Legal Services 0.00 0.00 0.00 0.00 0.00 10-531-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-531-529020 Historic Preservation Com 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 0.00 0.00 0.00 0.00 0.00 10-531-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-531-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-531-546010 Clothing Expense 0.00 0.00 0.00 0.00 0.00 10-531-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-531-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 10-531-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 10-531-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 531 Plan & Protect Svcs-Build Reg 0.00 0.00 0.00 0.00 0.00 532 Plan & Protect Svcs-Env Health 10-532-501020 Salaries 188,759.82 153,147.27 0.00 35,612.55 18.87 GL - Trial Balance by Acct Type and Full Acct Number (08/17/2022 - 7:33 AM)Page 33 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-532-501050 Parttime (wo Benefits)0.00 0.00 0.00 0.00 0.00 10-532-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-532-501070 Stand-by Plan 0.00 0.00 0.00 0.00 0.00 10-532-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-532-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-532-502010 Social Security 14,440.13 10,730.32 0.00 3,709.81 25.69 10-532-502020 Group Health Insurance 37,936.86 26,701.11 0.00 11,235.75 29.62 10-532-502030 Retirement 26,048.86 20,099.27 0.00 5,949.59 22.84 10-532-502040 Workers Compensation 3,753.42 3,753.42 0.00 0.00 0.00 10-532-502050 Life Insurance 223.99 169.20 0.00 54.79 24.46 10-532-502060 Long Term Disability 557.41 419.91 0.00 137.50 24.67 10-532-502070 Employee Assistance Prgm 65.52 61.36 0.00 4.16 6.35 10-532-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 271,786.01 215,081.86 0.00 56,704.15 20.86 10-532-511010 Advertising 90.00 0.00 0.00 90.00 100.00 10-532-511020 Postage 150.00 117.80 0.00 32.20 21.47 10-532-512010 Printing 20.00 0.00 0.00 20.00 100.00 10-532-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-532-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-532-513010 Office Supplies 1,300.00 310.35 0.00 989.65 76.13 10-532-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-532-514030 Small Tools 50.00 0.00 0.00 50.00 100.00 10-532-515030 Insect Control 0.00 0.00 0.00 0.00 0.00 10-532-515040 First Aid Supplies 15.00 0.00 0.00 15.00 100.00 10-532-517010 Operational Supplies 1,000.00 133.56 0.00 866.44 86.64 E10 Materials & Supplies 2,625.00 561.71 0.00 2,063.29 78.60 10-532-520030 Dues And Publications 900.00 902.00 0.00 -2.00 -0.22 10-532-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-532-520070 Training And Education 1,000.00 96.99 0.00 903.01 90.30 10-532-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-532-522020 Professional Services 4,996.70 4,996.70 0.00 0.00 0.00 10-532-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-532-524020 Recycle Collectprocess 0.00 0.00 0.00 0.00 0.00 10-532-524025 Glass Recycling 0.00 0.00 0.00 0.00 0.00 10-532-524026 Household Hazardous Waste 0.00 0.00 0.00 0.00 0.00 10-532-524027 INACTIVE - Portable Recycling 0.00 0.00 0.00 0.00 0.00 10-532-524028 Misc Recycling 0.00 0.00 0.00 0.00 0.00 10-532-524030 Compost Services 199,200.00 149,400.00 49,800.00 0.00 0.00 10-532-529010 Special Events 600.00 600.00 0.00 0.00 0.00 10-532-529020 Historic Preservation Com 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 206,696.70 155,995.69 49,800.00 901.01 0.44 10-532-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-532-540060 Cemetery Maintenance 39,500.00 27,012.78 8,886.00 3,601.22 9.12 10-532-540065 Cemetery Restoration 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (08/17/2022 - 7:33 AM)Page 34 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-532-541030 Vehicle Wash 1,290.00 1,284.00 0.00 6.00 0.47 10-532-546010 Clothing Expense 1,080.00 438.00 0.00 642.00 59.44 10-532-547010 Equipment Maintenance 40.00 0.00 0.00 40.00 100.00 10-532-547020 Maintenance Agreements 1,081.00 1,243.75 68.95 -231.70 -21.43 10-532-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 42,991.00 29,978.53 8,954.95 4,057.52 9.44 10-532-572010 Purchase of Vehicles 0.00 0.00 0.00 0.00 0.00 10-532-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 532 Plan & Protect Svcs-Env Health 524,098.71 401,617.79 58,754.95 63,725.97 12.16 533 PPS - Prop MaintCode Enforce 10-533-501020 Salaries 183,639.02 142,589.56 0.00 41,049.46 22.35 10-533-501050 Parttime(wo Benefits)20,000.00 13,196.64 0.00 6,803.36 34.02 10-533-501060 Seasonal Salaries 0.00 3,490.79 0.00 -3,490.79 0.00 10-533-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-533-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-533-502010 Social Security 15,578.39 11,745.26 0.00 3,833.13 24.61 10-533-502020 Group Health Insurance 35,121.60 22,780.34 0.00 12,341.26 35.14 10-533-502030 Retirement 25,342.19 18,469.77 0.00 6,872.42 27.12 10-533-502040 Workers Compensation 2,257.38 2,257.38 0.00 0.00 0.00 10-533-502050 Life Insurance 198.90 141.21 0.00 57.69 29.00 10-533-502060 Long Term Disability 523.14 388.54 0.00 134.60 25.73 10-533-502070 Employee Assistance Prgm 76.44 71.60 0.00 4.84 6.33 E05 Personnel Services 282,737.06 215,131.09 0.00 67,605.97 23.91 10-533-511010 Advertising 100.00 52.44 0.00 47.56 47.56 10-533-511020 Postage 2,300.00 1,006.97 0.00 1,293.03 56.22 10-533-512010 Printing 300.00 509.50 0.00 -209.50 -69.83 10-533-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-533-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-533-513010 Office Supplies 1,000.00 196.70 0.00 803.30 80.33 10-533-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-533-514030 Small Tools 125.00 0.00 0.00 125.00 100.00 10-533-515040 First Aid Supplies 15.00 0.00 0.00 15.00 100.00 10-533-517010 Operational Supplies 1,350.00 1,209.38 0.00 140.62 10.42 E10 Materials & Supplies 5,190.00 2,974.99 0.00 2,215.01 42.68 10-533-520030 Dues And Publications 500.00 75.00 0.00 425.00 85.00 10-533-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-533-520070 Training And Education 1,400.00 761.02 0.00 638.98 45.64 10-533-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-533-522020 Professional Services 0.00 160.00 0.00 -160.00 0.00 10-533-522021 Abatement 10,000.00 23,017.87 0.00 -13,017.87 -130.18 10-533-522022 Demo 230,782.57 166,063.32 0.00 64,719.25 28.04 10-533-522031 Dangerous Bldg Escrow Expenses 0.00 0.00 0.00 0.00 0.00 10-533-522070 Legal Services 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (08/17/2022 - 7:33 AM)Page 35 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-533-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-533-529020 Historic Preservation Comm 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 242,682.57 190,077.21 0.00 52,605.36 21.68 10-533-534010 Telephone 3,701.40 2,600.40 0.00 1,101.00 29.75 E20 Utilities 3,701.40 2,600.40 0.00 1,101.00 29.75 10-533-541030 Vehicle Wash 270.00 270.00 0.00 0.00 0.00 10-533-546010 Clothing Expense 1,280.00 446.28 0.00 833.72 65.13 10-533-547010 Equipment Maintenance 30.00 0.00 0.00 30.00 100.00 10-533-547020 Maintenance Agreements 1,183.00 1,073.82 97.37 11.81 1.00 10-533-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,763.00 1,790.10 97.37 875.53 31.69 10-533-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 533 PPS - Prop MaintCode Enforce 537,074.03 412,573.79 97.37 124,402.87 23.16 534 Plan & Protect Svcs-Bldg Regs 10-534-501020 Salaries 285,185.83 234,930.11 0.00 50,255.72 17.62 10-534-501050 Parttime(wo Benefits)15,900.00 0.00 0.00 15,900.00 100.00 10-534-501060 Seasonal Salaries 0.00 9,267.07 0.00 -9,267.07 0.00 10-534-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-534-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-534-502010 Social Security 23,033.07 17,103.74 0.00 5,929.33 25.74 10-534-502020 Group Health Insurance 67,522.51 50,938.17 0.00 16,584.34 24.56 10-534-502030 Retirement 39,355.64 30,695.42 0.00 8,660.22 22.01 10-534-502040 Workers Compensation 4,756.07 4,756.07 0.00 0.00 0.00 10-534-502050 Life Insurance 345.17 258.65 0.00 86.52 25.07 10-534-502060 Long Term Disability 845.87 643.06 0.00 202.81 23.98 10-534-502070 Employee Assistance Prgm 109.20 122.76 0.00 -13.56 -12.42 10-534-503020 Unemployment Compensation 0.00 3,200.00 0.00 -3,200.00 0.00 E05 Personnel Services 437,053.36 351,915.05 0.00 85,138.31 19.48 10-534-511010 Advertising 100.00 0.00 0.00 100.00 100.00 10-534-511020 Postage 1,100.00 529.12 0.00 570.88 51.90 10-534-512010 Printing 100.00 180.47 0.00 -80.47 -80.47 10-534-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-534-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-534-513010 Office Supplies 900.00 583.92 0.00 316.08 35.12 10-534-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-534-514030 Small Tools 100.00 132.86 0.00 -32.86 -32.86 10-534-515040 First Aid Supplies 15.00 0.00 0.00 15.00 100.00 10-534-517010 Operational Supplies 1,800.00 127.98 0.00 1,672.02 92.89 E10 Materials & Supplies 4,115.00 1,554.35 0.00 2,560.65 62.23 10-534-520030 Dues And Publications 3,000.00 744.00 0.00 2,256.00 75.20 10-534-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (08/17/2022 - 7:33 AM)Page 36 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-534-520070 Training And Education 8,000.00 4,305.56 0.00 3,694.44 46.18 10-534-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-534-522021 Abatement 0.00 0.00 0.00 0.00 0.00 10-534-522022 Demo 0.00 0.00 0.00 0.00 0.00 10-534-522070 Legal Services 0.00 0.00 0.00 0.00 0.00 10-534-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-534-529020 Historic Preservation Comm 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 11,000.00 5,049.56 0.00 5,950.44 54.09 10-534-534010 Telephone 2,100.00 2,542.22 0.00 -442.22 -21.06 E20 Utilities 2,100.00 2,542.22 0.00 -442.22 -21.06 10-534-541030 Vehicle Wash 270.00 270.00 0.00 0.00 0.00 10-534-546010 Clothing Expense 1,180.00 616.97 0.00 563.03 47.71 10-534-547010 Equipment Maintenance 20.00 0.00 0.00 20.00 100.00 10-534-547020 Maintenance Agreements 1,022.00 817.82 118.42 85.76 8.39 10-534-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,492.00 1,704.79 118.42 668.79 26.84 10-534-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 534 Plan & Protect Svcs-Bldg Regs 456,760.36 362,765.97 118.42 93,875.97 20.55 535 Public Works-Central Maintenan 10-535-501020 Salaries 371,172.19 304,103.78 0.00 67,068.41 18.07 10-535-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-535-501050 Parttime(wo Benefits)4,000.00 575.59 0.00 3,424.41 85.61 10-535-501070 Stand-by Plan 0.00 0.00 0.00 0.00 0.00 10-535-501090 Overtime 4,500.00 3,476.32 0.00 1,023.68 22.75 10-535-501095 Overtime Straight Pay 500.00 184.87 0.00 315.13 63.03 10-535-502010 Social Security 29,083.17 22,656.45 0.00 6,426.72 22.10 10-535-502020 Group Health Insurance 85,350.94 54,547.23 0.00 30,803.71 36.09 10-535-502030 Retirement 51,911.76 40,056.68 0.00 11,855.08 22.84 10-535-502040 Workers Compensation 4,469.36 4,469.36 0.00 0.00 0.00 10-535-502050 Life Insurance 445.54 333.60 0.00 111.94 25.12 10-535-502060 Long Term Disability 1,101.36 829.92 0.00 271.44 24.65 10-535-502070 Employee Assistance Prgm 152.88 143.20 0.00 9.68 6.33 10-535-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 552,687.20 431,377.00 0.00 121,310.20 21.95 10-535-511010 Advertising 80.00 0.00 0.00 80.00 100.00 10-535-511020 Postage 50.00 0.00 0.00 50.00 100.00 10-535-512020 Copies 10.00 0.00 0.00 10.00 100.00 10-535-513010 Office Supplies 1,500.00 538.10 0.00 961.90 64.13 10-535-514011 Gas, Oil, & Antifreeze 0.00 0.00 0.00 0.00 0.00 10-535-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-535-514030 Small Tools 7,000.00 4,687.52 0.00 2,312.48 33.04 10-535-517010 Operational Supplies 7,000.00 5,851.66 0.00 1,148.34 16.40 GL - Trial Balance by Acct Type and Full Acct Number (08/17/2022 - 7:33 AM)Page 37 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E10 Materials & Supplies 15,640.00 11,077.28 0.00 4,562.72 29.17 10-535-520030 Dues And Publications 350.00 185.00 0.00 165.00 47.14 10-535-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-535-520070 Training And Education 2,000.00 184.00 0.00 1,816.00 90.80 10-535-521005 Tank Insurance 500.00 0.00 0.00 500.00 100.00 10-535-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-535-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-535-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 2,850.00 369.00 0.00 2,481.00 87.05 10-535-531010 Electricity 6,560.00 4,567.15 0.00 1,992.85 30.38 10-535-533010 Natural Gas 3,000.00 2,771.33 0.00 228.67 7.62 10-535-534010 Telephone 220.00 271.12 0.00 -51.12 -23.24 10-535-535010 Water 1,442.00 904.11 0.00 537.89 37.30 E20 Utilities 11,222.00 8,513.71 0.00 2,708.29 24.13 10-535-540010 Building & Grounds Maint.10,000.00 15,613.08 17.50 -5,630.58 -56.31 10-535-541010 Veh & Equip Parts Etc 600,000.00 564,081.06 0.00 35,918.94 5.99 10-535-541015 Vehicle Hail Damage Repair 24,360.36 24,360.36 0.00 0.00 0.00 10-535-546010 Clothing Expense 5,500.00 7,110.03 0.00 -1,610.03 -29.27 10-535-547010 Equipment Maintenance 1,000.00 368.16 0.00 631.84 63.18 10-535-547020 Maintenance Agreements 17,251.00 14,937.74 89.35 2,223.91 12.89 10-535-547030 Radio Maintenance 100.00 0.00 0.00 100.00 100.00 E25 Repairs & Maintenance 658,211.36 626,470.43 106.85 31,634.08 4.81 10-535-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 535 Public Works-Central Maintenan 1,240,610.56 1,077,807.42 106.85 162,696.29 13.11 540 Public Works-Admin 10-540-501020 Salaries 229,814.59 184,734.11 0.00 45,080.48 19.62 10-540-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-540-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-540-502010 Social Security 17,580.82 14,110.80 0.00 3,470.02 19.74 10-540-502020 Group Health Insurance 21,189.53 14,463.75 0.00 6,725.78 31.74 10-540-502030 Retirement 31,714.41 24,458.33 0.00 7,256.08 22.88 10-540-502040 Workers Compensation 219.23 219.23 0.00 0.00 0.00 10-540-502050 Life Insurance 272.95 206.70 0.00 66.25 24.27 10-540-502060 Long Term Disability 547.62 408.21 0.00 139.41 25.46 10-540-502070 Employee Assistance Prgm 65.52 61.36 0.00 4.16 6.35 E05 Personnel Services 301,404.67 238,662.49 0.00 62,742.18 20.82 10-540-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-540-511020 Postage 200.00 0.53 0.00 199.47 99.74 10-540-512010 Printing 200.00 0.00 0.00 200.00 100.00 10-540-512020 Copies 100.00 0.11 0.00 99.89 99.89 10-540-513010 Office Supplies 1,000.00 489.98 0.00 510.02 51.00 GL - Trial Balance by Acct Type and Full Acct Number (08/17/2022 - 7:33 AM)Page 38 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-540-514010 Gas 100,000.00 92,319.34 0.00 7,680.66 7.68 10-540-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-540-514040 Food 200.00 -141.87 0.00 341.87 170.94 10-540-517010 Operational Supplies 300.00 0.00 0.00 300.00 100.00 E10 Materials & Supplies 102,000.00 92,668.09 0.00 9,331.91 9.15 10-540-520030 Dues And Publications 800.00 738.63 0.00 61.37 7.67 10-540-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-540-520070 Training And Education 3,000.00 0.00 0.00 3,000.00 100.00 10-540-522020 Professional Services 200.00 0.00 0.00 200.00 100.00 10-540-527010 Comm Serv Projects 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 4,000.00 738.63 0.00 3,261.37 81.53 10-540-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-540-547020 Maintenance Agreements 305.00 256.35 39.47 9.18 3.01 E25 Repairs & Maintenance 305.00 256.35 39.47 9.18 3.01 10-540-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 540 Public Works-Admin 407,709.67 332,325.56 39.47 75,344.64 18.48 541 Public Works-Engineering 10-541-501020 Salaries 844,425.89 688,608.11 0.00 155,817.78 18.45 10-541-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-541-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-541-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-541-501080 Step-up Pay 0.00 0.00 0.00 0.00 0.00 10-541-501090 Overtime 400.00 1,386.38 0.00 -986.38 -246.60 10-541-501095 Overtime Straight Pay 0.00 23.62 0.00 -23.62 0.00 10-541-502010 Social Security 64,629.18 50,353.54 0.00 14,275.64 22.09 10-541-502020 Group Health Insurance 143,366.51 91,029.16 0.00 52,337.35 36.51 10-541-502030 Retirement 116,585.97 87,072.99 0.00 29,512.98 25.31 10-541-502040 Workers Compensation 6,055.72 6,055.72 0.00 0.00 0.00 10-541-502050 Life Insurance 976.75 730.27 0.00 246.48 25.23 10-541-502060 Long Term Disability 2,422.05 1,762.94 0.00 659.11 27.21 10-541-502070 Employee Assistance Prgm 262.08 245.52 0.00 16.56 6.32 10-541-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 1,179,124.15 927,268.25 0.00 251,855.90 21.36 10-541-511010 Advertising 400.00 714.25 0.00 -314.25 -78.56 10-541-511020 Postage 400.00 89.39 0.00 310.61 77.65 10-541-512010 Printing 0.00 46.50 0.00 -46.50 0.00 10-541-512020 Copies 0.00 0.74 0.00 -0.74 0.00 10-541-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-541-513010 Office Supplies 1,650.00 1,101.19 0.00 548.81 33.26 10-541-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (08/17/2022 - 7:33 AM)Page 39 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-541-514030 Small Tools 200.00 0.00 0.00 200.00 100.00 10-541-514040 Food 150.00 520.10 0.00 -370.10 -246.73 10-541-515040 First Aid Supplies 50.00 110.51 0.00 -60.51 -121.02 10-541-515070 Const & Inspect Supplies 1,000.00 1,380.72 0.00 -380.72 -38.07 10-541-515080 Surveying Supplies 1,500.00 908.41 0.00 591.59 39.44 10-541-517010 Operational Supplies 4,350.00 3,518.93 0.00 831.07 19.11 E10 Materials & Supplies 9,700.00 8,390.74 0.00 1,309.26 13.50 10-541-520030 Dues And Publications 4,000.00 6,014.75 0.00 -2,014.75 -50.37 10-541-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-541-520070 Training And Education 4,000.00 1,878.68 0.00 2,121.32 53.03 10-541-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-541-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-541-522020 Professional Services 500.00 135.00 0.00 365.00 73.00 10-541-522055 Stormwater Compliance 500.00 0.00 0.00 500.00 100.00 E15 Contractual Services 9,000.00 8,028.43 0.00 971.57 10.80 10-541-534010 Telephone 500.00 234.02 0.00 265.98 53.20 E20 Utilities 500.00 234.02 0.00 265.98 53.20 10-541-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-541-541030 Vehicle Wash 1,000.00 960.00 0.00 40.00 4.00 10-541-546010 Clothing Expense 1,500.00 1,564.96 0.00 -64.96 -4.33 10-541-547010 Equipment Maintenance 1,000.00 1,170.00 0.00 -170.00 -17.00 10-541-547020 Maintenance Agreements 10,665.00 8,668.84 1,599.77 396.39 3.72 10-541-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 14,165.00 12,363.80 1,599.77 201.43 1.42 10-541-572010 Purchase of Vehicles 0.00 0.00 0.00 0.00 0.00 10-541-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 10-541-576031 Misc Stormwater Projects 0.00 0.00 0.00 0.00 0.00 10-541-576035 SidewalkGreenway-JCMG 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 0.00 0.00 0.00 0.00 0.00 541 Public Works-Engineering 1,212,489.15 956,285.24 1,599.77 254,604.14 21.00 542 Public Works-Street 10-542-501020 Salaries 1,223,006.34 970,379.14 0.00 252,627.20 20.66 10-542-501024 Salaries-Stormwater 0.00 13,195.22 0.00 -13,195.22 0.00 10-542-501060 Seasonal Salaries 20,000.00 14,956.80 0.00 5,043.20 25.22 10-542-501070 Stand-by Plan 9,248.00 6,847.50 0.00 2,400.50 25.96 10-542-501090 Overtime 30,000.00 25,926.97 0.00 4,073.03 13.58 10-542-501095 Overtime Straight Pay 500.00 1,384.10 0.00 -884.10 -176.82 10-542-502010 Social Security 98,371.27 76,251.75 0.00 22,119.52 22.49 10-542-502020 Group Health Insurance 280,799.01 177,040.04 0.00 103,758.97 36.95 10-542-502030 Retirement 174,945.32 126,073.97 0.00 48,871.35 27.94 10-542-502040 Workers Compensation 39,110.84 39,110.84 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (08/17/2022 - 7:33 AM)Page 40 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-542-502050 Life Insurance 1,462.73 1,046.03 0.00 416.70 28.49 10-542-502060 Long Term Disability 3,575.74 2,552.24 0.00 1,023.50 28.62 10-542-502070 Employee Assistance Prgm 622.44 583.08 0.00 39.36 6.32 10-542-503010 Awards Program 200.00 0.00 0.00 200.00 100.00 10-542-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 1,881,841.69 1,455,347.68 0.00 426,494.01 22.66 10-542-511010 Advertising 1,000.00 544.50 0.00 455.50 45.55 10-542-511020 Postage 150.00 21.20 0.00 128.80 85.87 10-542-512010 Printing 90.00 0.00 0.00 90.00 100.00 10-542-512020 Copies 10.00 0.00 0.00 10.00 100.00 10-542-513010 Office Supplies 1,600.00 347.95 0.00 1,252.05 78.25 10-542-514017 COVID-19 0.00 199.64 0.00 -199.64 0.00 10-542-514020 Chemicals 300,000.00 289,641.60 0.00 10,358.40 3.45 10-542-514030 Small Tools 9,000.00 5,440.15 0.00 3,559.85 39.55 10-542-514040 Food 2,000.00 1,809.53 0.00 190.47 9.52 10-542-515010 Stormwater Material 73,647.86 134.96 0.00 73,512.90 99.82 10-542-515020 Street Materials 225,000.00 209,916.64 0.00 15,083.36 6.70 10-542-515040 First Aid Supplies 500.00 332.07 0.00 167.93 33.59 10-542-515060 Weed Control 1,500.00 814.97 0.00 685.03 45.67 10-542-515070 Const & Inspect Supplies 200.00 0.00 0.00 200.00 100.00 10-542-517010 Operational Supplies 5,000.00 6,134.25 0.00 -1,134.25 -22.69 E10 Materials & Supplies 619,697.86 515,337.46 0.00 104,360.40 16.84 10-542-520030 Dues And Publications 1,320.00 692.00 0.00 628.00 47.58 10-542-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-542-520070 Training And Education 7,680.00 7,571.24 0.00 108.76 1.42 10-542-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-542-522020 Professional Services 14,000.00 14,738.75 0.00 -738.75 -5.28 10-542-523010 Equipment Rentlease 200.00 218.02 0.00 -18.02 -9.01 10-542-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-542-529070 Street Light Installation 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 23,200.00 23,220.01 0.00 -20.01 -0.09 10-542-531010 Electricity 24,364.00 18,551.50 0.00 5,812.50 23.86 10-542-531020 Street Lights 593,000.00 461,078.72 0.00 131,921.28 22.25 10-542-533010 Natural Gas 10,000.00 13,429.82 0.00 -3,429.82 -34.30 10-542-534010 Telephone 580.00 1,211.67 0.00 -631.67 -108.91 10-542-535010 Water 12,390.00 3,095.53 0.00 9,294.47 75.02 E20 Utilities 640,334.00 497,367.24 0.00 142,966.76 22.33 10-542-540010 Building & Grounds Maint.12,000.00 12,858.80 240.00 -1,098.80 -9.16 10-542-541030 Vehicle Wash 7,000.00 6,657.94 0.00 342.06 4.89 10-542-542010 Repairs - StopStreet Lights 35,000.00 27,710.40 0.00 7,289.60 20.83 10-542-542030 Signs & Marking Paint 50,000.00 50,388.62 498.20 -886.82 -1.77 10-542-546010 Clothing Expense 15,000.00 10,787.34 0.00 4,212.66 28.08 10-542-547010 Equipment Maintenance 3,200.00 4,321.75 0.00 -1,121.75 -35.05 10-542-547020 Maintenance Agreements 360.00 360.00 0.00 0.00 0.00 10-542-547030 Radio Maintenance 1,000.00 0.00 0.00 1,000.00 100.00 GL - Trial Balance by Acct Type and Full Acct Number (08/17/2022 - 7:33 AM)Page 41 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E25 Repairs & Maintenance 123,560.00 113,084.85 738.20 9,736.95 7.88 10-542-572010 Purchase Of Vehicles 152,000.00 152,000.00 0.00 0.00 0.00 10-542-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-542-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 10-542-573050 Neighborhood Impr Projs 0.00 0.00 0.00 0.00 0.00 10-542-573060 Sidewalk Rep Program 0.00 0.00 0.00 0.00 0.00 10-542-573061 Street Crack Sealing 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 152,000.00 152,000.00 0.00 0.00 0.00 542 Public Works-Street 3,440,633.55 2,756,357.24 738.20 683,538.11 19.87 700 Transfers & Subsidies 10-700-590050 Transfer To Tif Fund 15,000.00 5,863.77 0.00 9,136.23 60.91 10-700-590065 Trans to Self-Funded Hlth Ins 0.00 0.00 0.00 0.00 0.00 10-700-590066 Trans to Workers Comp 0.00 0.00 0.00 0.00 0.00 10-700-590070 Airport Subsidy 113,316.60 113,316.60 0.00 0.00 0.00 10-700-590075 Transit Subsidy 187,072.59 187,072.59 0.00 0.00 0.00 10-700-590080 Transfer To Amb Serv 0.00 0.00 0.00 0.00 0.00 E80 Transfers Out 315,389.19 306,252.96 0.00 9,136.23 2.90 700 Transfers & Subsidies 315,389.19 306,252.96 0.00 9,136.23 2.90 900 CapitalVehicleEquipment 10-900-571010 Capvehclequip-city Admin 0.00 0.00 0.00 0.00 0.00 10-900-571020 Capvhcleqp-code Enf-adm 0.00 0.00 0.00 0.00 0.00 10-900-571030 Capvhcleqp-bldg Regs 0.00 0.00 0.00 0.00 0.00 10-900-571040 Capvhcleqp-envir Health 0.00 0.00 0.00 0.00 0.00 10-900-571050 Capvhcleqp-p & Transp-adm 0.00 0.00 0.00 0.00 0.00 10-900-571060 Capvhcleqp-pub Works-adm 0.00 0.00 0.00 0.00 0.00 10-900-571070 Capvhcleqp-engineering 0.00 0.00 0.00 0.00 0.00 10-900-571080 Capvhcleqp-street 0.00 0.00 0.00 0.00 0.00 10-900-571090 Capvhcleqp-police 0.00 0.00 0.00 0.00 0.00 10-900-571100 Capvhcleqp-fire 0.00 0.00 0.00 0.00 0.00 10-900-571110 Capvhcleqp-Animal Control 0.00 0.00 0.00 0.00 0.00 10-900-571120 Capvhcleqp-central Maint 0.00 0.00 0.00 0.00 0.00 10-900-571130 Capvhcleqp-airport 0.00 0.00 0.00 0.00 0.00 10-900-571140 Capvhcleqp-contingency 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 900 CapitalVehicleEquipment 0.00 0.00 0.00 0.00 0.00 990 Capital Projects 10-990-575006 New Fire Station Number 2 0.00 0.00 0.00 0.00 0.00 10-990-575015 Police HVAC 0.00 0.00 0.00 0.00 0.00 10-990-575022 Future Fire Stations 6,000.00 0.00 0.00 6,000.00 100.00 10-990-575023 Fire Station 4 Rehab 3,579.28 2,586.75 0.00 992.53 27.73 10-990-576007 Stormwater Improvements 0.00 0.00 0.00 0.00 0.00 10-990-576020 Pipe Lining 2019 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (08/17/2022 - 7:33 AM)Page 42 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-990-576023 Norris Drive Culvert 243,750.00 203,409.56 40,340.44 0.00 0.00 10-990-576025 Douglas Davis Stormwater 124,019.00 0.00 124,019.00 0.00 0.00 10-990-577042 Mo Blvd Sidewalks 0.00 0.00 0.00 0.00 0.00 10-990-577044 Water Street @ Lohman Landing 0.00 0.00 0.00 0.00 0.00 10-990-577045 Clay Street Plaza 0.00 0.00 0.00 0.00 0.00 10-990-577046 Hwy 54 & Stadium Interchange 0.00 0.00 0.00 0.00 0.00 10-990-577054 Wayfinding 0.00 0.00 0.00 0.00 0.00 10-990-577056 SOMO Sewer Extension 0.00 0.00 0.00 0.00 0.00 10-990-577058 Downtown Streetscape 800.00 0.00 0.00 800.00 100.00 10-990-577060 Ongoing InfrastFacility Needs 73,835.29 35,058.50 30,319.00 8,457.79 11.45 10-990-577063 Clark Avenue 0.00 0.00 0.00 0.00 0.00 10-990-577064 Broadway St Sidewalk 0.00 0.00 0.00 0.00 0.00 10-990-577065 South Lincoln Street 0.00 0.00 0.00 0.00 0.00 10-990-577066 Stormwater Projects 0.00 0.00 0.00 0.00 0.00 10-990-577071 MSP EDA Grant 3,099,595.00 0.00 0.00 3,099,595.00 100.00 10-990-590071 Mo Blvd1400-1800 Block 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 3,551,578.57 241,054.81 194,678.44 3,115,845.32 87.73 990 Capital Projects 3,551,578.57 241,054.81 194,678.44 3,115,845.32 87.73 995 ARPA 10-995-501020 Salaries 87,700.27 87,700.27 0.00 0.00 0.00 10-995-502010 Social Security 6,468.51 6,468.51 0.00 0.00 0.00 10-995-502020 Group Health Insurance 17,740.61 17,740.61 0.00 0.00 0.00 10-995-502030 Retirement 11,417.41 11,417.41 0.00 0.00 0.00 10-995-502050 Life Insurance 92.36 92.36 0.00 0.00 0.00 10-995-502060 Long Term Disability 228.70 228.70 0.00 0.00 0.00 E05 Personnel Services 123,647.86 123,647.86 0.00 0.00 0.00 10-995-515010 Stormwater Materials 126,352.14 118,617.09 2,703.96 5,031.09 3.98 E10 Materials & Supplies 126,352.14 118,617.09 2,703.96 5,031.09 3.98 10-995-599501 JCCVB Lost Revenue 175,000.00 0.00 0.00 175,000.00 100.00 10-995-599504 Lincoln-Hlth Science & Crisis 500,000.00 0.00 0.00 500,000.00 100.00 10-995-599511 United Cap City Soccer Complex 100,000.00 0.00 0.00 100,000.00 100.00 E65 Other Non-Operating Expenses 775,000.00 0.00 0.00 775,000.00 100.00 10-995-576007 Stormwater Improvements 540,917.60 0.00 0.00 540,917.60 100.00 10-995-599502 Downtown Beautification-Match 150,000.00 0.00 0.00 150,000.00 100.00 10-995-599503 Organizational Review Study 150,000.00 0.00 0.00 150,000.00 100.00 10-995-599505 PD Elevator Replacement 200,000.00 0.00 0.00 200,000.00 100.00 10-995-599506 MSP Redevelopment 1,000,000.00 0.00 0.00 1,000,000.00 100.00 10-995-599507 Hyde Park Burn Bldg 1,000,000.00 0.00 0.00 1,000,000.00 100.00 10-995-599508 High Street Viaduct 300,000.00 0.00 0.00 300,000.00 100.00 10-995-599509 Private Prop Strmwtr Repair 200,000.00 0.00 0.00 200,000.00 100.00 10-995-599510 Demolitions 100,000.00 0.00 0.00 100,000.00 100.00 10-995-599512 Street Resurfacing 325,000.00 0.00 48,490.56 276,509.44 85.08 E75 Capital Projects 3,965,917.60 0.00 48,490.56 3,917,427.04 98.78 GL - Trial Balance by Acct Type and Full Acct Number (08/17/2022 - 7:33 AM)Page 43 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 995 ARPA 4,990,917.60 242,264.95 51,194.52 4,697,458.13 94.12 Expense Expense 48,639,067.57 28,208,640.53 1,421,181.17 19,009,245.87 39.08 GL - Trial Balance by Acct Type and Full Acct Number (08/17/2022 - 7:33 AM)Page 44 CITY OF JEFFERSON FISCAL YEAR 2021 - 2022 ESTIMATED FUND BALANCE FYE2021 UNASSIGNED FUND BALANCE (Audited)8,791,173.00$ Reappropriations from FY2021 to FY2022 MSP - EDA Grant matching portion (1,599,595.00)$ Future Fire Stations (6,000.00)$ Fire Station 4 Rehab (3,579.28)$ Downtown Streetscape (800.00)$ Ongoing Infrastructure/Facility Needs (63,760.11)$ Demolitions (210,782.57)$ Roof Repairs at Hyde Park (82,417.27)$ Vehicle Leasing (109,042.75)$ Springbrook Software Upgrade (12,136.25)$ Friend of the Animal Shelter grant for cat kennels (4,600.00)$ Bunker/Turnout Gear (18,634.03)$ Station 4 Renovation Lockers & Extractor (16,936.49)$ Ammunition and Firearms Supplies (34,365.57)$ Purchase of Animal Control Vehicle (25,523.00)$ Historic Preservation Grants for Surveys (38,400.00)$ Remaining FY21 HUD NSP grant funds (78,805.90)$ Contractual obligation from Allied & Cole County contracts (20,500.00)$ (2,325,878.22)$ 2022 Adjustments/Supplementals (Does not include other "Reserve" accounts as they are not "Unassigned" fund balance) FY2022 Supplemental Appropriations: Budget Amendments for Vehicle Leasing (50,410.00)$ Supplemental for Compensation Study Contract (28,500.00)$ Supplemental for Capitol Avenue Demos & Acquisitions (575,000.00)$ Supplemental for Juneteenth Holiday (78,131.66)$ ITS Software License/maint - returned to fund balance - replaced with ARPA 140,000.00$ (592,041.66)$ FYE2022 ESTIMATED Unassigned Fund Balance 5,873,253.12$ FYE2022 ESTIMATED Fund Balance % of Adopted Budget 17.09% 17% of FY2022 Adopted Budget ($34,370,541) = $5,842,992 Tax Period Due Date to City Total Lodging Tax JCCVB (3/7) JCCVB/Tourism Fund (4/7)** May-11 6/20/11 91,258.41 38,328.53 51,104.71 Jun-11 7/20/11 101,479.82 42,621.54 56,828.68 Jul-11 8/20/11 88,392.47 37,124.82 49,499.80 Aug-11 9/20/11 73,144.02 30,720.48 40,960.66 Sep-11 10/20/11 103,618.61 43,519.80 58,026.44 Oct-11 11/20/11 105,531.99 44,323.44 59,097.91 Nov-11 12/20/11 66,556.88 27,953.89 37,271.85 Dec-11 1/20/12 52,204.97 21,926.07 29,234.80 Jan-12 2/20/12 65,645.72 27,571.20 36,761.61 566.37 Interest Received Feb-12 3/20/12 85,143.89 35,760.45 47,680.56 383.96 4/2012 Interest Received Mar-12 4/20/12 81,904.23 34,399.77 45,866.38 636.05 5/2012 Interest Received (8.11) 5/2012 Service Charge Apr-12 5/20/12 103,406.71 43,430.82 57,907.76 685.97 6/2012 Interest Received (7.25) 6/2012 Service Charge May-12 6/20/12 89,713.24 37,679.58 50,239.40 785.01 7/2012 Interest Received (7.25) 7/2012 Service Charge Jun-12 7/20/12 86,753.72 36,436.56 48,582.08 832.99 8/2012 Interest Received (7.25) 8/2012 Service Charge Jul-12 8/20/12 89,904.69 37,759.97 50,346.63 Aug-12 9/20/12 76,708.71 32,217.66 42,956.88 887.55 9/2012 Interest Received (7.25) 9/2012 Service Charge 987.59 10/2012 Interest Received (7.50) 10/2012 Service Charge Sep-12 10/20/12 109,335.16 45,920.77 61,227.69 1,011.18 11/2012 Interest Received (7.00) 11/2012 Service Charge Oct-12 11/20/12 109,059.34 45,804.92 61,073.23 45,804.92 JCCVB 3/7 Check Deposited in Error 1,166.54 12/2012 Interest Received (7.50) 12/2012 Service Charge Nov-12 12/20/12 69,756.75 29,297.84 39,063.77 (45,804.92) Correction of Deposit Error 1,185.18 1/2013 Interest Received (7.33) 1/2013 Service Charge Dec-12 1/20/13 55,126.67 23,153.20 30,870.94 1,108.23 2/2013 Interest Received (7.35) 2/2013 Service Charge Jan-13 2/20/13 84,295.92 35,404.29 47,205.71 1,271.02 3/2013 Interest Received (8.28) 3/2013 Service Charge Feb-13 3/20/13 84,199.16 35,363.65 47,151.53 1,297.26 4/2013 Interest Received (8.28) 4/2013 Service Charge Mar-13 4/20/13 98,008.06 41,163.39 54,884.51 1,413.79 5/2013 Interest Received (7.37) 5/2013 Service Charge Apr-13 5/20/13 100,022.48 42,009.44 56,012.59 Tax Period Due Date to City Total Lodging Tax JCCVB (3/7) JCCVB/Tourism Fund (4/7)** 1,450.30 6/2013 Interest Received (8.56) 6/2013 Service Charge (10,000.00) Ck #50 - C H Johnson Consulting May-13 6/20/13 97,602.44 40,993.02 54,657.37 1,570.41 7/2013 Interest Received (8.45) 7/2013 Service Charge (1,187.09) Ck #1001 - C H Johnson Consulting Jun-13 7/20/13 92,796.57 38,974.56 51,966.08 1,620.41 8/2013 Interest Received (8.45) 8/2013 Service Charge (33.25) Ck #1002 - City of Jefferson - RFP Ad (15,000.00) Ck #1003 - C H Johnson Consulting (10,000.00) Ck #1004 - C H Johnson Consulting Jul-13 8/20/13 93,352.06 39,207.87 52,277.15 1,606.48 9/2013 Interest Received (8.79) 9/2013 Service Charge (5,000.00) Ck #1005 - C H Johnson Consulting Aug-13 9/20/13 89,778.97 37,707.17 50,276.22 1,726.08 10/2013 Interest Received (8.45) 10/2013 Service Charge (3,000.00) Ck #1006 - C H Johnson Consulting Sep-13 10/20/13 108,879.17 45,729.25 60,972.34 1,728.36 11/2013 Interest Received (8.45) 11/2013 Service Charge Oct-13 11/20/13 120,248.83 50,504.51 67,339.34 1,864.47 12/2013 Interest Received (8.28) 12/2013 Service Charge Nov-13 12/20/13 84,253.54 35,386.49 47,181.98 1,918.75 1/2014 Interest Received (8.28) 1/2014 Service Charge Dec-13 1/20/14 63,745.74 26,773.21 35,697.61 1,807.90 2/2014 Interest Received (8.28) 2/2014 Service Charge Jan-14 2/20/14 92,051.62 38,661.68 51,548.91 (1,562.61) Ck #1007 - C H Johnson Consulting 2,078.72 3/2014 Interest Received (8.45) 3/2014 Service Charge Feb-14 3/20/14 80,825.68 33,946.79 45,262.38 2,052.68 4/2014 Interest Received (8.28) 4/2014 Service Charge Mar-14 4/30/14 106,553.94 44,752.65 59,670.21 2,198.76 5/2014 Interest Received (8.29) 5/2014 Service Charge Apr-14 5/20/14 104,278.69 43,797.05 58,396.07 2,203.13 6/2014 Interest Received (8.29) 6/2014 Service Charge May-14 6/20/14 116,059.44 48,744.96 64,993.29 2,391.04 7/2014 Interest Received (8.29) 7/2014 Service Charge Jun-14 7/20/14 104,333.69 43,820.15 58,426.87 2,457.38 8/2014 Interest Received (8.29) 8/2014 Service Charge Jul-14 8/20/14 98,901.39 41,538.58 55,384.78 2,459.73 9/2014 Interest Received Tax Period Due Date to City Total Lodging Tax JCCVB (3/7) JCCVB/Tourism Fund (4/7)** (8.29) 9/2014 Service Charge Aug-14 9/20/14 75,962.88 31,904.41 42,539.21 2,593.43 10/2014 Interest Received (8.29) 10/2014 Service Charge Sep-14 10/20/14 112,370.02 47,195.41 62,927.21 2,586.87 11/2014 Interest Received (8.29) 11/2014 Service Charge Oct-14 11/20/14 116,992.89 49,137.01 65,516.02 2,736.57 12/2014 Interest Received (14.65) 12/2014 Service Charge Nov-14 12/20/14 72,761.33 30,559.76 40,746.34 2,798.53 1/2015 Interest Received (8.29) 1/2015 Service Charge Dec-14 1/20/15 60,394.73 25,365.79 33,821.05 2,575.56 2/2015 Interest Received (8.29) 2/2015 Service Charge Jan-15 2/20/15 85,741.83 36,011.57 48,015.42 2,935.34 3/2015 Interest Received (8.29) 3/2015 Service Charge Feb-15 3/20/15 84,317.61 35,413.40 47,217.86 2,911.14 4/2015 Interest Received (10.54) 4/2015 Service Charge Mar-15 4/20/15 114,789.97 48,211.79 64,282.38 3,049.41 5/2015 Interest Received (8.29) 5/2015 Service Charge Apr-15 5/20/15 102,479.43 43,041.36 57,388.48 3,046.67 6/2015 Interest Received (8.29) 6/2015 Service Charge May-15 6/20/15 116,174.48 48,793.28 65,057.71 3,217.49 7/2015 Interest Received (8.29) 7/2015 Service Charge Jun-15 7/31/15 97,379.11 40,899.23 54,532.30 3,287.90 8/2015 Interest Received (10.67) 8/2015 Service Charge Jul-15 8/20/15 102,541.78 43,067.55 57,423.40 3,307.41 9/2015 Interest Received (8.58) 9/2015 Service Charge Aug-15 9/20/15 81,248.87 34,124.53 45,499.37 3,476.74 10/2015 Interest Received (8.29) 10/2015 Service Charge Sep-15 10/20/15 102,709.81 43,138.12 57,517.49 3,421.47 11/2015 Interest Received (8.00) 11/2015 Service Charge Oct-15 12/1/15 107,837.70 45,291.83 60,389.11 3,605.14 12/2015 Interest Received (8.29) 12/2015 Service Charge Nov-15 12/31/15 67,119.58 28,190.22 37,586.96 Sep-15 1,908.92 801.75 1,069.00 late pays 3,666.35 1/2016 Interest Received (8.29) 1/2016 Service Charge Dec-15 1/31/16 66,959.22 28,122.88 37,497.16 3,478.72 2/2016 Interest Received (8.49) 2/2016 Service Charge Jan-16 2/20/16 83,239.99 34,960.80 46,614.39 Tax Period Due Date to City Total Lodging Tax JCCVB (3/7) JCCVB/Tourism Fund (4/7)** 3,786.20 3/2016 Interest Received (8.28) 3/2016 Service Charge Feb-16 3/20/16 97,559.96 40,975.18 54,633.58 3,718.19 4/2016 Interest Received (8.27) 4/2016 Service Charge Mar-16 4/29/16 101,134.20 42,476.36 56,635.16 3,914.86 5/2016 Interest Received (8.26) 5/2016 Service Charge Apr-16 5/20/16 140,992.87 59,217.01 78,956.01 3,905.43 6/2016 Interest Received May-16 6/20/16 112,152.91 47,104.22 62,805.63 3,985.42 7/2016 Interest Received Jun-16 7/31/16 106,704.37 44,815.83 59,754.44 4,207.43 8/2016 Interest Received Jul-16 8/20/16 96,811.40 40,660.79 54,214.38 4,136.69 9/2016 Interest Received Aug-16 9/20/16 88,674.86 37,243.44 49,657.92 4,350.78 10/2016 Interest Received Sep-16 10/31/16 100,606.10 42,254.56 56,339.42 4,292.30 11/2016 Interest Received Oct-16 11/20/16 120,471.15 50,597.88 67,463.85 4,531.06 12/2016 Interest Received Nov-16 12/20/16 88,755.07 37,277.13 49,702.83 4,602.85 1/2017 Interest Received Dec-16 1/31/17 65,709.30 27,597.91 36,797.21 4,207.06 2/2017 Interest Received Jan-17 2/20/17 95,905.35 40,280.25 53,706.99 4,726.10 3/2017 Interest Received Feb-17 3/31/17 95,135.98 39,957.11 53,276.15 4,651.72 4/2017 Interest Received Mar-17 4/30/17 111,370.63 46,775.67 62,367.55 4,885.76 5/2017 Interest Received Apr-17 5/30/17 109,652.93 46,054.23 61,405.64 4,807.94 6/2017 Interest Received May-17 6/30/17 123,148.39 51,722.32 68,963.10 5,089.00 7/2017 Interest Received Jun-17 7/31/17 120,310.25 50,530.30 67,373.74 5,141.00 8/2017 Interest Received Jul-17 8/20/17 101,096.32 42,460.45 56,613.94 5,081.97 9/2017 Interest Received Aug-17 9/30/17 99,136.13 41,637.18 55,516.23 5,325.63 10/2017 Interest Received Sep-17 10/31/17 112,835.87 47,391.06 63,188.09 5,243.98 11/2017 Interest Received Oct-17 11/20/17 118,132.32 49,615.57 66,154.10 5,519.00 12/2017 Interest Received Nov-17 12/20/17 84,414.19 35,453.96 47,271.95 5,565.66 1/2018 interest Received Dec-17 1/31/18 64,644.90 27,150.86 36,201.14 5,076.25 2/2018 interest Received Jan-18 2/20/18 90,463.34 37,994.60 50,659.47 5,710.59 3/2018 interest Received Feb-18 3/31/18 72,376.53 30,398.14 40,530.86 5,580.76 4/2018 interest Received Tax Period Due Date to City Total Lodging Tax JCCVB (3/7) JCCVB/Tourism Fund (4/7)** Mar-18 4/30/18 128,168.74 53,830.87 71,774.50 5,862.91 5/2018 interest Received Apr-18 5/30/18 115,538.43 48,526.14 64,701.52 5,744.27 6/2018 interest Received May-18 6/20/18 127,840.04 53,692.82 71,590.42 6,020.86 7/2018 interest Received Jun-18 7/31/18 108,499.02 45,569.59 60,759.45 6,145.34 8/2018 interest Received Jul-18 8/20/18 99,948.25 41,978.26 55,971.02 5,929.16 9/2018 interest Received Aug-18 9/20/18 92,260.57 38,749.44 51,665.92 6,303.93 10/2018 interest Received Sep-18 10/31/18 102,804.82 43,178.02 57,570.70 6,160.57 11/2018 interest Received Oct-18 11/20/18 130,250.45 54,705.19 72,940.25 6,496.60 12/2018 interest Received Nov-18 12/20/18 87,460.75 36,733.51 48,978.02 6,531.01 1/2019 interest Received (3,908.75) CK# 1008 Dec-18 1/31/19 70,508.84 29,613.71 39,484.95 5,949.48 2/2019 interest Received (2,623.75) CK# 1009 Jan-19 2/20/19 88,590.00 37,207.80 49,610.40 6,683.16 3/2019 interest Received Feb-19 3/31/19 99,690.19 41,869.88 55,826.51 6,537.39 4/2019 interest Received Mar-19 4/30/19 121,611.98 51,077.03 68,102.71 6,844.11 5/2019 interest Received (50.75) CK# 1011 (4,867.50) CK# 1012 Apr-19 5/30/19 131,434.04 55,202.30 73,603.06 6,731.55 6/2019 interest Received 200.00 6/26/19 bank deposit May-19 6/20/19 134,504.89 56,492.05 75,322.74 7,065.89 7/2019 interest Received Jun-19 7/31/19 120,530.50 50,622.81 67,497.08 7,131.88 8/2019 interest Received Jul-19 8/20/19 117,844.99 49,494.90 65,993.19 7,014.55 9/2019 interest Received (2,136.63) CK# 1012 Aug-19 9/20/19 114,393.96 48,045.46 64,060.62 7,349.16 10/2019 interest Received Sep-19 10/31/19 125,692.73 52,790.95 70,387.93 7,179.27 11/2019 interest Received (737.50) CK# 1014 Oct-19 11/20/19 136,035.67 57,134.98 76,179.98 7,549.02 12/2019 interest Received Nov-19 12/20/19 98,690.15 41,449.86 55,266.49 7,603.34 1/2020 interest Received Dec-19 1/31/20 85,935.20 36,092.79 48,123.71 7,157.65 2/2020 interest Received (10,000.00) CK# 1015 (10,000.00) CK# 1016 (2,810.43) CK# 1017 Tax Period Due Date to City Total Lodging Tax JCCVB (3/7) JCCVB/Tourism Fund (4/7)** Jan-20 2/20/20 100,143.20 42,060.15 56,080.19 7,723.92 3/2020 interest Received Feb-20 3/31/20 111,144.21 46,680.58 62,240.76 7,575.08 4/2020 interest Received Mar-20 4/30/20 80,913.29 33,983.58 45,311.44 6,861.56 5/2020 interest Received (2,205.79) CK# 1018 Apr-20 5/30/20 60,499.04 25,409.60 33,879.46 2,527.02 6/2020 interest Received (6,500.00) CK# 1019 May-20 6/20/20 61,880.21 25,989.69 34,652.92 2,625.49 7/2020 interest Received Jun-20 7/31/20 94,499.61 39,689.84 52,919.78 2,644.87 8/2020 interest Received (5,967.50) CK# 1020 Jul-20 8/20/20 96,451.62 40,509.68 54,012.91 2,581.92 9/2020 interest Received Aug-20 9/20/20 67,013.43 28,145.64 37,527.52 2,687.74 10/2020 interest Received Sep-20 10/31/20 83,113.75 34,907.77 46,543.70 1,437.91 11/2020 interest Received Oct-20 11/20/20 78,606.00 33,014.52 44,019.36 272.79 12/2020 interest Received (1,937.50) CK# 1021 Nov-20 12/20/20 60,099.25 25,241.68 33,655.58 264.28 1/2021 interest Received Dec-20 1/31/21 65,475.65 27,499.77 36,666.37 188.91 2/2021 interest Received Jan-21 2/20/21 82,813.97 34,781.87 46,375.82 (1,705.00) CK# 1022 111.35 3/2021 interest Received Feb-21 3/31/21 77,646.44 32,611.50 43,482.01 108.55 4/2021 interest Received Mar-21 4/30/21 110,467.63 46,396.41 61,861.87 113.04 5/2021 interest Received Apr-21 5/30/21 114,792.54 48,212.87 64,283.82 110.52 6/2021 interest Received (1,472.50) CK# 1023 May-21 6/20/21 131,092.96 55,059.04 73,412.06 115.52 7/2021 interest Received Jun-21 7/31/21 132,627.36 55,703.49 74,271.32 116.66 8/2021 interest Received Jul-21 8/20/21 118,674.04 49,843.10 66,457.46 114.15 9/2021 interest Received Aug-21 9/20/21 103,990.65 43,676.07 58,234.76 118.82 10/2021 interest Received Sep-21 10/31/21 116,868.16 49,084.63 65,446.17 115.85 11/2021 interest Received (1,240.00) CK# 1024 Oct-21 11/20/21 142,704.05 59,935.70 79,914.27 121.00 12/2021 interest Received Nov-21 12/20/21 107,616.01 45,198.72 60,264.97 122.09 1/2022 interest Received Dec-21 1/31/21 80,860.10 33,961.24 45,281.66 Tax Period Due Date to City Total Lodging Tax JCCVB (3/7) JCCVB/Tourism Fund (4/7)** 111.01 2/2022 interest Received (1,790.00) CK# 1025 Jan-22 2/20/22 97,059.17 40,764.85 54,353.14 123.64 3/2022 interest Received Feb-22 3/20/22 99,315.44 41,712.48 55,616.65 120.85 4/2022 interest Received Mar-22 4/30/22 133,358.96 56,010.76 74,681.02 354.10 5/2022 Interest Received (3,006.25) CK# 1026 (2,031.25) CK# 1027 Apr-22 5/20/22 149,339.45 62,722.57 83,630.09 819.86 6/2022 interest Received May-22 6/20/22 149,890.31 62,953.93 83,938.57 1,287.65 7/2022 interest Received Jun-22 7/31/22 138,466.16 58,155.79 77,541.05 Total 13,181,615.73 5,536,278.60 7,678,280.87 average monthly amount for 4 cent lockbox fund 54,679.30$ **Effective for 25 years starting May 1, 2011 2022 Occupancy 2021 Occupancy 2020 Occupancy 2019 Occupancy 2018 Occupancy 2017 Occupancy 2016 Occupancy January 35.70%37.70%47.30%49.40%48.10%48.70%51.30% February 42.10%37.80%55.50%58.00%53.40%56.80%58.60% March 50.40%48.20%41.60%58.00%57.60%62.20%59.80% April 56.80%55.10%34.90%63.10%61.70%62.40%67.20% May 55.30%52.90%42.10%60.90%64.60%63.80%64.90% June 49.50%54.20%55.00%60.50%63.20%70.40%64.00% July 47.70%53.40%58.80%60.30%65.90%58.20% August 43.80%46.20%59.00%56.80%61.50%56.50% September 48.20%48.20%63.40%59.90%64.50%62.60% October 51.60%45.30%63.80%65.60%66.50%62.90% November 43.50%34.60%50.30%54.80%51.50%50.60% December 32.60%30.30%44.90%46.00%40.80%42.10% COMPARATIVE OCCUPANCY RATE Tab 2 - Multi-Segment Currency: USD - US Dollar Missouri Hotel & Lodging Association For the month of: June 2022 Percent Change from June 2021 Percent Change from YTD 2021 2022 2021 2022 2021 2022 2021 Occ ADR RevPAR Room Rev Room Avail Room Sold 2022 2021 2022 2021 2022 2021 Occ ADR RevPAR Room Rev Room Avail Room Sold Census Sample Census Sample United States 70.1 66.0 155.04 129.92 108.64 85.68 6.3 19.3 26.8 28.9 1.7 8.0 61.6 53.6 145.15 111.59 89.37 59.84 14.8 30.1 49.4 53.9 3.1 18.3 61786 36897 5578806 4218181 West North Central 67.5 63.2 118.64 105.32 80.05 66.53 6.8 12.6 20.3 20.4 0.1 6.9 53.0 46.6 105.51 89.67 55.94 41.75 13.9 17.7 34.0 34.7 0.5 14.5 5042 3047 385736 291373 Missouri 66.6 63.2 123.10 110.24 81.93 69.69 5.3 11.7 17.6 18.1 0.5 5.8 54.3 48.5 111.92 94.06 60.82 45.59 12.1 19.0 33.4 34.5 0.8 13.0 1220 732 108565 81246 Kansas City, MO 69.6 60.7 118.61 100.64 82.55 61.13 14.6 17.9 35.0 36.0 0.7 15.4 58.0 47.3 111.72 90.33 64.77 42.68 22.7 23.7 51.7 55.0 2.2 25.3 327 272 35821 32258 Saint Louis, MO 68.1 62.5 127.53 109.17 86.80 68.19 9.0 16.8 27.3 30.2 2.3 11.5 56.9 48.9 114.43 93.13 65.15 45.50 16.5 22.9 43.2 45.4 1.5 18.3 376 281 41614 35966 Columbia, MO+68.3 66.4 99.62 85.30 68.05 56.64 2.9 16.8 20.1 20.1 0.0 2.9 58.9 52.2 98.35 80.34 57.89 41.92 12.8 22.4 38.1 39.5 1.0 13.9 39 31 4040 3336 Jefferson City, MO+49.5 54.1 103.12 96.02 51.06 51.95 -8.5 7.4 -1.7 -1.7 0.0 -8.5 48.3 47.6 103.25 90.06 49.85 42.86 1.4 14.6 16.3 16.3 0.0 1.4 16 14 1513 1391 Springfield, MO 72.5 76.8 100.86 95.63 73.17 73.44 -5.5 5.5 -0.4 1.5 1.9 -3.8 64.5 64.0 97.09 84.24 62.64 53.91 0.8 15.2 16.2 17.7 1.3 2.1 73 53 6589 5074 Branson, MO 59.1 65.2 170.10 159.18 100.54 103.82 -9.4 6.9 -3.2 -7.8 -4.8 -13.7 37.2 39.7 150.88 131.61 56.08 52.30 -6.5 14.6 7.2 3.7 -3.3 -9.5 164 44 13889 5639 Lake of the Ozarks+71.1 64.0 138.78 133.40 98.73 85.33 11.2 4.0 15.7 15.7 0.0 11.2 52.1 41.0 114.99 111.20 59.92 45.63 27.0 3.4 31.3 27.3 -3.0 23.1 39 7 2624 889 Joplin, MO 69.6 70.4 96.48 89.91 67.18 63.30 -1.1 7.3 6.1 9.2 2.9 1.8 58.9 59.3 90.82 81.57 53.46 48.36 -0.7 11.3 10.6 13.8 2.9 2.2 35 25 2650 2175 Saint Joseph, MO+78.3 75.8 111.27 102.29 87.14 77.55 3.3 8.8 12.4 12.3 -0.1 3.2 67.6 63.1 100.49 90.31 67.97 57.02 7.1 11.3 19.2 19.2 -0.0 7.1 11 9 991 837 Independence, MO+67.7 62.9 97.35 86.93 65.88 54.67 7.6 12.0 20.5 28.6 6.7 14.8 55.7 51.4 93.47 80.90 52.06 41.60 8.3 15.5 25.2 33.5 6.7 15.6 21 15 1628 1422 A blank row indicates insufficient data. Rooms Participation PropertiesADRRevPARADR Current Month - June 2022 vs June 2021 Occ % 2022 © CoStar Group. This STR Report is a publication of STR, LLC and STR Global, Ltd., CoStar Group companies, and is intended solely for use by paid subscribers. The information in the STR Report is provided on an “as is” and “as available” basis and should not be construed as investment, tax, accounting or legal advice. Reproduction or distribution of this STR Report, in whole or part, without written permission is prohibited and subject to legal action. If you have received this report and are NOT a subscriber to this STR Report, please contact us immediately. Source: 2022 STR, LLC / STR Global, Ltd. trading as "STR". Year to Date - June 2022 vs June 2021 Occ %RevPAR