Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My Public Portal
About
2023-08-24 NO meeting packet
Notice of CANCELLATION of Meeting CITY OF JEFFERSON Finance Committee Thursday, August 24, 2023 at 7:30 AM City Hall, 320 E. McCarty Street, Jefferson City, MO ~ Boone-Bancroft Room Memo To:Shiela Pearre From:Shelby Convery Date:August 7, 2023 Re:Sales Tax Revenues The City received the July 1 % Sales Tax in the amount of $1,164,947 which is $16,992 more than projected for August. January through August overage is $581,738 (4.31%) in the General Fund. 1% General Sales Tax Receipt Actual Budget Period Receipts Projection Variance Nov-22 Jan-23 $1,259,616 $1,026,648 $232,968 Dec-22 Feb-23 $1,216,173 $1,120,272 $95,901 Jan-23 & Oct-Dec 22 Qtrly Mar-23 $1,022,304 $1,125,672 ($103,368) Feb-23 Apr-23 $1,159,734 $959,706 $200,029 Mar-23 May-23 $1,016,572 $941,216 $75,356 Apr-23 & Jan-Mar 23 Qtrly Jun-23 $1,278,048 $1,289,592 ($11,545) May-23 Jul-23 $1,210,579 $1,135,175 $75,404 Jun-23 Aug-23 $1,164,947 $1,147,955 $16,992 Jul-23 & Apr-June 23 Qtrly Sep-23 $1,270,875 Aug-23 Oct-23 $1,170,133 Sep-23 Nov-23 $1,051,691 Oct-23 & Jul-Sept 23 Qtrly Dec-23 $1,261,065 Total Overage/Shortfall $9,327,973 $13,500,000 $581,738 1/2% Capital Improvement Tax - Sales Tax H Receipt Actual Budget Period Receipts Projection Variance Nov-22 Jan-23 $614,170 $ 519,792 $94,378 Dec-22 Feb-23 $603,664 $ 556,425 $47,239 Jan-23 & Oct-Dec 22 Qtrly Mar-23 $492,760 $ 563,512 ($70,752) Feb-23 Apr-23 $560,057 $ 477,122 $82,935 Mar-23 May-23 $490,388 $ 474,411 $15,977 Apr-23 & Jan-Mar 23 Qtrly Jun-23 $621,539 $ 641,494 ($19,955) May-23 Jul-23 $584,311 $ 572,975 $11,337 Jun-23 Aug-23 $577,849 $ 577,523 $326 Jul-23 & Apr-June 23 Qtrly Sep-23 $ 636,773 Aug-23 Oct-23 $ 578,954 Sep-23 Nov-23 $ 520,413 Oct-23 & Jul-Sept 23 Qtrly Dec-23 $ 630,606 Total Overage/Shortfall $4,544,739 $6,750,000 $161,485 1/2% Parks Sales Tax Receipt Actual Budget Period Receipts Projection Variance Nov-22 Jan-23 $614,170 $ 469,739 $144,431 Dec-22 Feb-23 $603,664 $ 502,835 $100,829 Jan-23 & Oct-Dec 22 Qtrly Mar-23 $492,761 $ 509,438 ($16,677) Feb-23 Apr-23 $560,057 $ 431,180 $128,878 Mar-23 May-23 $490,388 $ 428,728 $61,660 Apr-23 & Jan-Mar 23 Qtrly Jun-23 $621,540 $ 579,722 $41,818 May-23 Jul-23 $584,311 $ 517,610 $66,702 Jun-23 Aug-23 $577,849 $ 521,910 $55,939 Jul-23 & Apr-June 23 Qtrly Sep-23 $ 575,455 Aug-23 Oct-23 $ 523,202 Sep-23 Nov-23 $ 470,300 Oct-23 & Jul-Sept 23 Qtrly Dec-23 $ 569,882 Total Overage/Shortfall $4,544,740 $6,100,000 $583,579 1/4% Public Safety Tax Receipt Actual Budget Period Receipts Projection Variance Nov-22 Jan-23 $305,603 $ 259,896 $45,707 Dec-22 Feb-23 $301,101 $ 278,212 $22,889 Jan-23 & Oct-Dec 22 Qtrly Mar-23 $245,290 $ 281,756 ($36,466) Feb-23 Apr-23 $278,185 $ 238,561 $39,624 Mar-23 May-23 $243,340 $ 237,206 $6,134 Apr-23 & Jan-Mar 23 Qtrly Jun-23 $310,277 $ 320,747 ($10,470) May-23 Jul-23 $290,835 $ 286,487 $4,347 Jun-23 Aug-23 $282,943 $ 288,761 ($5,818) Jul-23 & Apr-June 23 Qtrly Sep-23 $ 318,386 Aug-23 Oct-23 $ 289,477 Sep-23 Nov-23 $ 260,207 Oct-23 & Jul-Sept 23 Qtrly Dec-23 $ 315,303 Total Overage/Shortfall $2,257,574 $3,375,000 $65,947 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 2023 Account Number 10-100-400010 Prior 5 years Monthly REPORTING PERIOD RECEIPT PERIOD 2015 2016 2017 2018 2019 2020 2021 2022 2023 Average Nov January 944,619 929,179 1,083,570 884,259 1,071,917 1,049,305 986,180 1,023,976 1,259,616 act. 1,003,128 Dec February 727,437 812,670 806,789 927,290 885,496 942,049 971,262 1,222,207 1,216,173 act. 989,661 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 1,022,304 act. 1,105,988 Feb April 1,059,943 893,024 843,561 986,714 892,285 949,276 895,779 1,000,444 1,159,734 act. 944,900 Mar May 618,854 648,305 687,741 709,248 731,421 828,799 861,134 981,749 1,016,572 act. 822,470 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 1,278,048 act. 1,157,354 May July 963,280 1,012,207 1,154,051 1,117,038 979,846 1,139,419 1,112,675 1,109,974 1,210,579 act. 1,091,790 Jun August 562,996 661,518 678,636 821,132 770,155 912,996 996,635 1,251,810 1,164,947 act. 950,546 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,263,389 1,270,875 est. 1,221,900 Aug October 918,839 903,829 883,215 879,331 875,539 1,020,452 1,113,777 1,177,321 1,170,133 est. 1,013,284 Sept November 661,849 623,645 615,667 774,337 818,656 856,748 971,814 1,087,375 1,051,691 est. 901,786 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,237,576 1,261,065 est. 1,130,553 Actual to Date $ 10,856,302 $ 11,002,277 $ 11,304,678 $ 11,470,052 $ 11,511,614 $ 12,219,110 $ 12,778,432 $ 13,687,585 $9,327,973 Estimated to Fiscal Year end (based on averages and on Budgeted amount)$4,753,765 Total Actual & Estimated $14,081,738 Less: Budget $13,500,000 Over (Under) Budget $581,738 1,259,616 2,475,790 3,498,094 4,657,828 5,674,400 6,952,448 8,163,027 9,327,973 1,026,648 2,146,920 3,272,591 4,232,297 5,173,513 6,463,106 7,598,280 8,746,235 10,017,111 11,187,244 12,238,935 13,500,000 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 14,000,000 14,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/7/2023 City of Jefferson, Mo. - Account Analysis Account Name Capital Imprs Sales Tax Rate: One-Half percent (½%) Receipt Month: AUGUST 2023 Account Number 46-100-400010 Prior 5 years Monthly REPORTING PERIOD RECEIPT PERIOD 2015 2016 2017 2018 2019 2020 2021 2022 2023 Average Nov January 461,560 455,278 525,521 424,160 525,696 513,808 483,288 509,721 614,170 act. 491,335 Dec February 362,597 405,543 402,964 444,476 427,711 458,324 473,674 589,318 603,664 act. 478,700 Jan & Oct-Dec Qtrly March 511,685 563,056 506,597 575,894 527,714 518,493 542,898 534,222 492,760 act. 539,844 Feb April 512,808 431,353 411,020 455,943 430,468 458,553 430,804 480,689 560,057 act. 451,291 Mar May 308,247 322,957 340,162 340,740 351,775 402,202 430,383 475,930 490,388 act. 400,206 Apr & Jan-Mar Qtrly June 496,466 539,529 489,008 508,225 554,062 537,105 626,235 599,274 621,539 act. 564,980 May July 473,120 498,229 559,119 548,625 481,405 560,720 547,153 547,456 584,311 act. 537,072 Jun August 280,733 330,112 338,618 393,512 372,416 443,962 487,128 616,545 577,849 act. 462,713 Jul & Apr-Jun Qtrly September 565,296 570,134 542,457 545,731 615,998 597,489 596,853 619,635 636,773 est. 595,141 Aug October 442,371 435,416 425,493 423,478 421,199 494,618 538,917 567,114 578,954 est. 489,065 Sept November 330,393 310,506 307,281 374,512 395,311 415,079 469,176 525,019 520,413 est. 435,819 Oct & Jul-Sept Qtrly December 515,478 494,218 652,070 510,228 495,454 558,134 604,664 600,044 630,606 est. 553,705 Actual to Date $ 5,260,753 $ 5,356,330 $ 5,500,311 $ 5,545,522 $ 5,599,211 $ 5,958,488 $ 6,231,172 $ 6,664,966 $4,544,740 Estimated to Fiscal Year end (based on averages and on Budgeted amount)$2,366,746 Total Actual & Estimated $6,911,486 Less: Budget $6,750,000 Over (Under) Budget $161,486 614,170 1,217,835 1,710,595 2,270,652 2,761,040 3,382,579 3,966,891 4,544,740 519,792 1,076,217 1,639,728 2,116,851 2,591,262 3,232,756 3,805,731 4,383,254 5,020,027 5,598,981 6,119,394 6,750,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 5,850,000 6,100,000 6,350,000 6,600,000 6,850,000 7,100,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/7/2023 City of Jefferson, Mo. - Account Analysis Account Name Parks Sales Tax Rate: One-Half percent (½%) Receipt Month: AUGUST 2023 Account Number 21-210-400010 Prior 5 years Monthly REPORTING PERIOD RECEIPT PERIOD 2015 2016 2017 2018 2019 2020 2021 2022 2023 Average Nov January 461,472 455,239 525,521 424,192 525,690 513,808 483,288 509,721 614,170 act. 491,340 Dec February 362,371 405,543 395,217 450,479 427,689 458,324 473,676 589,297 603,664 act. 479,893 Jan & Oct-Dec Qtrly March 511,582 563,039 506,524 577,148 527,588 518,493 542,898 534,624 492,761 act. 540,150 Feb April 512,738 431,353 411,020 457,060 430,459 458,632 430,808 480,688 560,057 act. 451,529 Mar May 308,030 322,957 340,162 340,708 350,479 402,202 430,383 475,930 490,388 act. 399,941 Apr & Jan-Mar Qtrly June 496,386 539,529 489,008 508,266 554,065 537,107 626,235 599,274 621,540 act. 564,989 May July 473,038 498,229 559,115 548,639 481,406 560,720 547,152 547,054 584,311 act. 536,994 Jun August 280,513 330,112 338,470 393,578 372,405 443,965 487,128 616,545 577,849 act. 462,724 Jul & Apr-Jun Qtrly September 565,217 572,847 542,457 545,842 616,012 597,492 596,854 619,635 575,455 est. 595,167 Aug October 442,370 435,416 425,497 423,387 421,199 494,618 538,913 567,114 523,202 est. 489,046 Sept November 330,393 310,506 307,305 374,484 395,311 415,079 469,176 525,019 470,300 est. 435,814 Oct & Jul-Sept Qtrly December 515,368 494,218 652,101 510,220 495,452 558,134 604,664 600,044 569,882 est. 553,703 Actual to Date $ 5,259,477 $ 5,358,988 $ 5,492,397 $ 5,554,002 $ 5,597,755 $ 5,958,575 $ 6,231,173 $ 6,664,945 $4,544,740 Estimated to Fiscal Year end (based on averages and on Budgeted amount)$2,138,839 Total Actual & Estimated $6,683,579 Less: Budget $6,100,000 Over (Under) Budget $583,579 614,170 1,217,834 1,710,595 2,270,652 2,761,040 3,382,579 3,966,891 4,544,740 469,739 972,574 1,482,012 1,913,192 2,341,920 2,921,642 3,439,251 3,961,161 4,536,616 5,059,818 5,530,118 6,100,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 5,850,000 6,100,000 6,350,000 6,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/7/2023 City of Jefferson, Mo. - Account Analysis Account Name Public Safety Rate: One-Quarter percent (1/4%) Receipt Month: AUGUST 2023 Account Number 55-100-400010 REPORTING PERIOD RECEIPT PERIOD 2022 2023 Nov January 0.00 305,603 act. Dec February 0.00 301,101 act. Jan & Oct-Dec Qtrly March 0.00 245,290 act. Feb April 0.00 278,185 act. Mar May 0.00 243,340 act. Apr & Jan-Mar Qtrly June 194,548.64 310,277 act. May July 239,893.32 290,835 act. Jun August 303,285.52 282,943 act. Jul & Apr-Jun Qtrly September 308,722.21 318,386 est. Aug October 281,012.20 289,477 est. Sept November 259,718.13 260,207 est. Oct & Jul-Sept Qtrly December 297,156.18 315,303 est. Actual to Date $1,884,336 $2,257,574 Estimated to Fiscal Year end (based on averages and on Budgeted amount)$1,183,373 Total Actual & Estimated $3,440,947 Less: Estimated Revenue $3,375,000 Over (Under) Budget $65,947 305,603 606,704 851,993 1,130,179 1,373,518 1,683,795 1,974,630 2,257,574 259,896 538,108 819,864 1,058,425 1,295,631 1,616,378 1,902,866 2,191,627 2,510,013 2,799,490 3,059,697 3,375,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 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/7/2023 Revenue Model Report For the Period Ending July 31, 2023 Data as of August 15, 2023 FY 2023 YTD Actual Projected Over/ Description Budget As of 8/15/2023 (Under) Budget Sales Tax and Use Tax $13,500,000.00 $9,327,973.44 $581,738.03 Intergovernmental Taxes $2,586,000.00 $1,918,406.42 $183,358.43 Other Taxes $94,000.00 $51,637.36 ($10,697.77) Franchise & Utility Tax $6,287,000.00 $4,210,722.12 $323,929.25 Property Taxes $5,791,659.76 $5,960,459.84 $208,355.29 Charges for Services $3,085,247.19 $2,658,679.32 ($28,491.09) Fees, Licenses, & Permits $956,105.14 $775,420.31 ($72,176.91) Fines & Forfeitures $406,500.00 $316,742.82 $11,594.54 Contributions/Donations $362,344.33 $208,758.27 $0.04 Other Operating Revenues $193,916.00 $231,546.53 $70,119.08 Interest Income $120,000.00 $315,013.36 $238,034.98 Other Non Operating Revenue $88,775.00 $143,611.01 $0.00 Operating Transfers In $2,669,450.46 $3,024,441.41 $361,196.75 Totals $36,140,997.88 $29,143,412.21 $1,866,960.63 This schedule does not reflect variances in budget vs. actual for grants, as grants are typically reappropriated from year to year until the grant expires. This schedule does not reflect variances in budget vs. actual for contributions/donations that have designated reserve accounts. FY2023Revenue Model Report (Detail)Remaining For the Period Ending July 31, 2023 YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification Description Budget As of 8/15/2023 As of 8/15/2023 TOTAL (Under) Budget of FormulasSales Tax and Use Tax 10-100-400010 Sales Tax $13,500,000.00 $9,327,973.44 $4,753,764.59 $14,081,738.03 $581,738.03 $581,738.03 10-100-400020 Sales Tax Interest $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $13,500,000.00 $9,327,973.44 $4,753,764.59 $14,081,738.03 $581,738.03 $581,738.03Intergovernmental Taxes 10-100-401030 Motor Vehicle Sales Tax $637,000.00 $385,530.52 $263,812.87 $649,343.39 $12,343.39 $12,343.39 10-100-403010 Gasoline Tax $1,299,000.00 $857,687.83 $587,139.14 $1,444,826.97 $145,826.97 $145,826.97 10-100-430080 Road & Bridge Tax $650,000.00 $675,188.07 $0.00 $675,188.07 $25,188.07 $25,188.07 $2,586,000.00 $1,918,406.42 $850,952.01 $2,769,358.43 $183,358.43 $183,358.43Other Taxes 10-100-403020 Cig Tax $94,000.00 $51,637.36 $31,664.87 $83,302.23 ($10,697.77)($10,697.77) $94,000.00 $51,637.36 $31,664.87 $83,302.23 ($10,697.77)($10,697.77)Franchise & Utility Tax 10-100-410020 Electric Utility Lic Tax $4,019,000.00 $2,334,642.18 $1,832,035.52 $4,166,677.70 $147,677.70 $147,677.70 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 $920,000.00 $1,038,698.58 $143,233.08 $1,181,931.66 $261,931.66 $261,931.66 10-100-410052 Telephone/Cell Utility $1,090,000.00 $635,003.67 $360,749.77 $995,753.44 ($94,246.56)($94,246.56) 10-100-410053 Telephone/Cell Audit $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-410060 Cable Franchise Fee $258,000.00 $202,377.69 $64,188.76 $266,566.45 $8,566.45 $8,566.45 $6,287,000.00 $4,210,722.12 $2,400,207.13 $6,610,929.25 $323,929.25 $323,929.25Property Taxes 10-100-420010 Current Property Tax $5,053,000.00 $5,350,687.76 $16,780.14 $5,367,467.90 $314,467.90 $314,467.90 10-100-420020 Del Property Tax $60,000.00 $38,852.70 ($7,379.82)$31,472.88 ($28,527.12)($28,527.12) 10-100-420040 Fin Institution Tax $32,000.00 $40,355.49 $0.00 $40,355.49 $8,355.49 $8,355.49 10-100-420050 Prop Tax Int & Penalties $31,000.00 $23,355.32 $8,675.90 $32,031.22 $1,031.22 $1,031.22 10-100-420055 Surtax Receipts - County Reimb $41,659.76 $41,659.76 $0.00 $41,659.76 $0.00 $0.00 10-100-420060 Surtax Receipts $508,000.00 $428,959.07 $1,825.67 $430,784.74 ($77,215.26)($77,215.26) 10-100-420080 Special Tax Rev $66,000.00 $36,589.74 $19,653.32 $56,243.06 ($9,756.94)($9,756.94) $5,791,659.76 $5,960,459.84 $39,555.21 $6,000,015.05 $208,355.29 $208,355.29Charges for Services 10-100-440010 Admin Charge Backs $1,638,418.00 $1,639,825.00 $0.00 $1,639,825.00 $1,407.00 $1,407.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 $32,000.00 $29,900.00 $8,929.13 $38,829.13 $6,829.13 $6,829.13 10-100-440910 Fuel Charge - backs $20,000.00 $14,275.16 $8,213.53 $22,488.69 $2,488.69 $2,488.69 10-100-440920 Parts Charge backs $236,410.00 $189,794.92 $71,719.29 $261,514.21 $25,104.21 $25,104.21 10-100-440930 Labor Charge backs $266,590.00 $163,068.00 $65,048.36 $228,116.36 ($38,473.64)($38,473.64) 10-100-481020 Cole Cty Animal Rescue $127,260.12 $94,045.35 $31,815.03 $125,860.38 ($1,399.74)($1,399.74) 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 $0.00 $12,000.00 $12,000.00 $0.00 $0.00 10-100-481045 Rent-tower Sites $186,000.00 $126,104.39 $41,902.51 $168,006.90 ($17,993.10)($17,993.10) 10-100-481065 Parking Spot Maintenance $30,000.00 $30,000.00 $0.00 $30,000.00 $0.00 $0.00 10-100-481075 Cole Cty 911 Reimb $472,493.07 $345,912.50 $118,123.26 $464,035.76 ($8,457.31)($8,457.31) 10-100-481080 Sale Of Maps/GIS Data $0.00 $15.00 $0.00 $15.00 $15.00 $15.00 10-100-481085 Cole Cty GIS Joint Coop $15,000.00 $14,258.00 $3,750.00 $18,008.00 $3,008.00 $3,008.00 10-100-481100 Sale Of Grave Sites $2,919.00 $1,251.00 $648.67 $1,899.67 ($1,019.33)($1,019.33) 10-100-481105 TIF Administration Fee $21,157.00 $10,230.00 $10,927.00 $21,157.00 $0.00 $0.00 10-100-481110 Long & Short $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3,085,247.19 $2,658,679.32 $398,076.78 $3,056,756.10 ($28,491.09)($28,491.09)Fees, Licenses, & Permits 10-100-450010 Liquor Licenses $78,000.00 $78,846.25 $2,201.94 $81,048.19 $3,048.19 $3,048.19 10-100-450020 Business Licenses $220,000.00 $202,930.73 $16,883.10 $219,813.83 ($186.17)($186.17) 10-100-450021 Home Occupation Permit $1,800.00 $0.00 $436.36 $436.36 ($1,363.64)($1,363.64) 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 $26,200.00 ($18,200.00)$8,000.00 $0.00 $0.00 10-100-450045 Building Construct. Fees $316,355.14 $188,656.72 $44,896.06 $233,552.78 ($82,802.36)($82,802.36) 10-100-450050 Electrical Certificates $30,000.00 $20,801.00 $3,753.15 $24,554.15 ($5,445.85)($5,445.85) 10-100-450060 Electrical Permits $10,000.00 $7,798.30 $2,693.12 $10,491.42 $491.42 $491.42 10-100-450070 Plumbing Licenses $12,400.00 $12,451.00 $842.71 $13,293.71 $893.71 $893.71 10-100-450080 Plumbing Permits $11,500.00 $15,775.25 $2,597.54 $18,372.79 $6,872.79 $6,872.79 10-100-450090 Other Lic & Permits $2,000.00 $2,378.00 $603.60 $2,981.60 $981.60 $981.60 10-100-450091 Day Care Inspection Fees $4,500.00 $4,555.00 $1,264.40 $5,819.40 $1,319.40 $1,319.40 10-100-450092 Food Inspection Fees $90,000.00 $92,151.08 ($743.04)$91,408.04 $1,408.04 $1,408.04 10-100-450100 Curb Cut Permits $1,000.00 $935.00 $302.67 $1,237.67 $237.67 $237.67 10-100-450110 Board Of Adj Fees $1,600.00 $2,400.00 $553.09 $2,953.09 $1,353.09 $1,353.09 10-100-450120 Sign Permits $6,000.00 $4,590.00 $1,188.09 $5,778.09 ($221.91)($221.91) 10-100-450130 Demolition Permits $3,000.00 $3,138.00 $819.75 $3,957.75 $957.75 $957.75 FY2023Revenue Model Report (Detail)Remaining For the Period Ending July 31, 2023 YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification Description Budget As of 8/15/2023 As of 8/15/2023 TOTAL (Under) Budget of Formulas 10-100-450150 Acc Rep Fees-police $7,000.00 $5,817.50 $1,841.86 $7,659.36 $659.36 $659.36 10-100-450160 Accrpt/blastg P-fire $1,150.00 $183.48 $723.33 $906.81 ($243.19)($243.19) 10-100-450170 Animal Redemption Fees $98,000.00 $58,090.00 $27,799.30 $85,889.30 ($12,110.70)($12,110.70) 10-100-450180 Animal Vaccinations Fees $4,000.00 $3,175.00 $947.69 $4,122.69 $122.69 $122.69 10-100-450185 Animal Cremation Fees $35,000.00 $23,131.00 $12,382.32 $35,513.32 $513.32 $513.32 10-100-450186 Animal Boarding Fees $0.00 $1,790.00 $0.00 $1,790.00 $1,790.00 $1,790.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 $0.00 $136.00 $0.00 $136.00 $136.00 $136.00 10-100-450250 Rezoning Request $0.00 $6,173.00 $0.00 $6,173.00 $6,173.00 $6,173.00 10-100-450255 Planning & Zoning Review Fees $13,500.00 $13,238.00 $4,316.24 $17,554.24 $4,054.24 $4,054.24 10-100-450260 Non-refundable Plans/spec $1,300.00 $80.00 $404.64 $484.64 ($815.36)($815.36) $956,105.14 $775,420.31 $108,507.92 $883,928.23 ($72,176.91)($72,176.91)Fines & Forfeitures 10-100-460010 Court Cost $34,000.00 $25,344.74 $8,694.57 $34,039.31 $39.31 $39.31 10-100-460015 Court Restitutions $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-460018 Inmate Security Fund $5,300.00 $4,227.80 $1,430.47 $5,658.27 $358.27 $358.27 10-100-460020 Jail Cost Recovery $200.00 $0.00 $38.95 $38.95 ($161.05)($161.05) 10-100-460025 Alcohol Offense Cost Rec $5,300.00 $4,531.72 $1,379.62 $5,911.34 $611.34 $611.34 10-100-460030 Pol Fines-traffic $330,000.00 $264,258.07 $82,475.68 $346,733.75 $16,733.75 $16,733.75 10-100-460090 Parking Fines $38,000.00 $23,230.00 $8,912.86 $32,142.86 ($5,857.14)($5,857.14) 10-100-460100 Bankcard Charges ($6,300.00)($4,849.51)($1,580.42)($6,429.93)($129.93)($129.93) $406,500.00 $316,742.82 $101,351.72 $418,094.54 $11,594.54 $11,594.54Contributions/Donations 10-100-480055 JC Fire Museum $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-480090 Police K-9 Donations $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-481055 Street Repair-Solid Waste Cntr $362,344.33 $208,758.27 $153,586.10 $362,344.37 $0.04 $0.04 $362,344.33 $208,758.27 $153,586.10 $362,344.37 $0.04 $0.04Other 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 $46,141.91 $0.00 $46,141.91 $46,141.91 $46,141.91 10-100-481070 Miscellaneous $87,678.27 $106,209.98 $2,197.82 $108,407.80 $20,729.53 $20,729.53 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 $16,000.00 $8,932.93 $5,178.15 $14,111.08 ($1,888.92)($1,888.92) 10-100-481077 Insurance Claims $70,237.73 $70,261.71 $5,112.59 $75,374.30 $5,136.57 $5,136.57 10-100-481078 Cafeteria Refunds $20,000.00 $0.00 $20,000.00 $20,000.00 $0.00 $0.00 $193,916.00 $231,546.53 $32,488.55 $264,035.08 $70,119.08 $70,119.08Interest Income 10-100-470010 Interest $120,000.00 $315,013.36 $43,021.62 $358,034.98 $238,034.98 $238,034.98 $120,000.00 $315,013.36 $43,021.62 $358,034.98 $238,034.98 $238,034.98Other Non Operating Revenue 10-100-485050 Sale Of Assets $88,775.00 $143,611.01 ($54,836.01)$88,775.00 $0.00 $0.00 10-100-486020 Capital Contribution-Developer $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $88,775.00 $143,611.01 ($54,836.01)$88,775.00 $0.00 $0.00Operating Transfers In 10-100-490240 Trsfr From Lodging Tax $24,700.00 $25,146.81 $6,205.80 $31,352.61 $6,652.61 $6,652.61 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 $2,644,750.46 $2,999,294.60 $0.00 $2,999,294.60 $354,544.14 $354,544.14 10-100-490630 Transfer from Self Funded Hlth Ins $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2,669,450.46 $3,024,441.41 $6,205.80 $3,030,647.21 $361,196.75 $361,196.75 $36,140,997.88 $29,143,412.21 $8,864,546.30 $38,007,958.51 $1,866,960.63 $1,866,960.63 General Ledger Trial Balance by Acct Type and Full Acct Number User: spearre Printed: 8/16/2023 2:42:24 PM Period 01 - 13 Fiscal Year 2023 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10 General Fund Expense Expense 110 Mayor & Council 10-110-501010 Salary-Elected Officials 65,925.00 49,275.00 0.00 16,650.00 25.26 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)14,598.40 4,967.09 0.00 9,631.31 65.98 10-110-502010 Social Security 8,990.53 5,977.20 0.00 3,013.33 33.52 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 124,585.44 86,540.82 0.00 38,044.62 30.54 10-110-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-110-511020 Postage 100.00 31.59 0.00 68.41 68.41 10-110-512010 Printing 400.00 273.00 0.00 127.00 31.75 10-110-512020 Copies 96.00 0.29 0.00 95.71 99.70 10-110-513010 Office Supplies 1,435.00 1,753.21 0.00 -318.21 -22.17 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,031.00 2,058.09 0.00 -27.09 -1.33 10-110-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-110-520015 Contractual Obligations 0.00 153,784.95 0.00 -153,784.95 0.00 10-110-520025 Security 1,500.00 1,060.22 0.00 439.78 29.32 10-110-520030 Dues And Publications 4,165.00 6,501.92 0.00 -2,336.92 -56.11 10-110-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-110-520070 Training & Education 1,189.84 870.00 0.00 319.84 26.88 10-110-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-110-529010 Special Events 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 6,854.84 162,217.09 0.00 -155,362.25 -2,266.46 10-110-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-110-547020 Maintenance Agreements 124.00 92.84 30.95 0.21 0.17 E25 Repairs & Maintenance 124.00 92.84 30.95 0.21 0.17 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)Page 1 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-110-572020 Purchase Of Equipment 0.00 1,529.88 0.00 -1,529.88 0.00 E70 Capital Purchases 0.00 1,529.88 0.00 -1,529.88 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 133,595.28 252,438.72 30.95 -118,874.39 -88.981 Grand Total -133,595.28 -252,438.72 -30.95 118,874.39 -0.8898 110 Mayor & Council 133,595.28 252,438.72 30.95 -118,874.39 -88.98 120 City Clerk 10-120-501020 Salaries 58,320.25 44,309.72 0.00 14,010.53 24.02 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,356.55 3,134.05 0.00 1,222.50 28.06 10-120-502020 Group Health Insurance 13,245.50 9,641.85 0.00 3,603.65 27.21 10-120-502030 Retirement 7,289.39 5,671.67 0.00 1,617.72 22.19 10-120-502040 Workers Compensation 49.99 49.99 0.00 0.00 0.00 10-120-502050 Life Insurance 69.77 50.72 0.00 19.05 27.30 10-120-502060 Long Term Disability 174.26 136.29 0.00 37.97 21.79 10-120-502070 Employee Assistance Prgm 21.84 15.33 0.00 6.51 29.81 E05 Personnel Services 83,527.55 63,009.62 0.00 20,517.93 24.56 10-120-511020 Postage 200.00 197.29 0.00 2.71 1.36 10-120-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-120-512020 Copies 300.00 269.00 0.00 31.00 10.33 10-120-513010 Office Supplies 200.00 82.86 0.00 117.14 58.57 10-120-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 700.00 549.15 0.00 150.85 21.55 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 164.10 0.00 235.90 58.98 10-120-522020 Professional Services 200.00 105.89 0.00 94.11 47.06 10-120-529030 Election Expense 18,579.79 10,232.77 0.00 8,347.02 44.93 E15 Contractual Services 19,254.79 10,567.76 0.00 8,687.03 45.12 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,675.00 2,773.82 30.95 7,870.23 73.73 E25 Repairs & Maintenance 10,675.00 2,773.82 30.95 7,870.23 73.73 10-120-572020 Purchase Of Equipment 465.33 465.33 0.00 0.00 0.00 E70 Capital Purchases 465.33 465.33 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 114,622.67 77,365.68 30.95 37,226.04 32.477 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)Page 2 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable Grand Total -114,622.67 -77,365.68 -30.95 -37,226.04 0.3248 120 City Clerk 114,622.67 77,365.68 30.95 37,226.04 32.48 140 City Administrator 10-140-501020 Salaries 218,687.56 144,663.93 0.00 74,023.63 33.85 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,311.43 8,062.47 0.00 8,248.96 50.57 10-140-502020 Group Health Insurance 21,732.71 12,858.81 0.00 8,873.90 40.83 10-140-502030 Retirement 27,292.33 24,540.57 0.00 2,751.76 10.08 10-140-502040 Workers Compensation 201.22 201.22 0.00 0.00 0.00 10-140-502050 Life Insurance 113.83 103.92 0.00 9.91 8.71 10-140-502060 Long Term Disability 374.04 343.29 0.00 30.75 8.22 10-140-502070 Employee Assistance Prgm 43.68 30.69 0.00 12.99 29.74 E05 Personnel Services 284,756.80 190,804.90 0.00 93,951.90 32.99 10-140-511010 Advertising 0.00 2,106.73 0.00 -2,106.73 0.00 10-140-511020 Postage 150.00 25.53 0.00 124.47 82.98 10-140-512010 Printing 100.00 0.00 0.00 100.00 100.00 10-140-512020 Copies 150.00 52.64 0.00 97.36 64.91 10-140-513010 Office Supplies 525.00 320.86 0.00 204.14 38.88 10-140-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-140-517010 Operational Supplies 678.74 668.51 0.00 10.23 1.51 E10 Materials & Supplies 1,603.74 3,174.27 0.00 -1,570.53 -97.93 10-140-520030 Dues And Publications 1,700.00 1,302.09 0.00 397.91 23.41 10-140-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-140-520070 Training And Education 700.00 330.00 0.00 370.00 52.86 10-140-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-140-520090 Recruitment 0.00 182.74 0.00 -182.74 0.00 10-140-520095 Relocation Fees 0.00 0.00 0.00 0.00 0.00 10-140-522020 Professional Services 0.00 38.90 0.00 -38.90 0.00 E15 Contractual Services 2,400.00 1,853.73 0.00 546.27 22.76 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 362.98 120.50 -183.48 -61.16 E25 Repairs & Maintenance 300.00 362.98 120.50 -183.48 -61.16 10-140-572020 Purchase Of Equipment 472.60 472.60 0.00 0.00 0.00 E70 Capital Purchases 472.60 472.60 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 289,533.14 196,668.48 120.50 92,744.16 32.0323 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)Page 3 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable Grand Total -289,533.14 -196,668.48 -120.50 -92,744.16 0.3203 140 City Administrator 289,533.14 196,668.48 120.50 92,744.16 32.03 141 Local Tourism Asset Develop 10-141-501020 Salaries 82,499.00 0.00 0.00 82,499.00 100.00 10-141-502010 Social Security 0.00 0.00 0.00 0.00 0.00 10-141-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-141-502030 Retirement 0.00 0.00 0.00 0.00 0.00 10-141-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-141-502050 Life Insurance 0.00 0.00 0.00 0.00 0.00 10-141-502060 Long Term Disability 0.00 0.00 0.00 0.00 0.00 10-141-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 82,499.00 0.00 0.00 82,499.00 100.00 10-141-520072 Subrecipient Reimbursements 2,062,476.00 0.00 0.00 2,062,476.00 100.00 E15 Contractual Services 2,062,476.00 0.00 0.00 2,062,476.00 100.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 2,144,975.00 0.00 0.00 2,144,975.00 100 Grand Total -2,144,975.00 0.00 0.00 -2,144,975.00 1 141 Local Tourism Asset Develop 2,144,975.00 0.00 0.00 2,144,975.00 100.00 142 Community Revitalization 10-142-501020 Salaries 81,276.00 0.00 0.00 81,276.00 100.00 10-142-502010 Social Security 0.00 0.00 0.00 0.00 0.00 10-142-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-142-502030 Retirement 0.00 0.00 0.00 0.00 0.00 10-142-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-142-502050 Life Insurance 0.00 0.00 0.00 0.00 0.00 10-142-502060 Long Term Disability 0.00 0.00 0.00 0.00 0.00 10-142-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 81,276.00 0.00 0.00 81,276.00 100.00 10-142-522017 Rehabilitation 378,463.00 0.00 0.00 378,463.00 100.00 10-142-522018 Streetscaping 182,000.00 0.00 0.00 182,000.00 100.00 10-142-522021 Asbestos Abatement 291,574.00 0.00 0.00 291,574.00 100.00 10-142-522022 Demo 1,179,856.00 0.00 0.00 1,179,856.00 100.00 E15 Contractual Services 2,031,893.00 0.00 0.00 2,031,893.00 100.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 2,113,169.00 0.00 0.00 2,113,169.00 100 Grand Total -2,113,169.00 0.00 0.00 -2,113,169.00 1 142 Community Revitalization 2,113,169.00 0.00 0.00 2,113,169.00 100.00 143 CDBG-CV Compass Health 10-143-501020 Salaries 11,601.91 3,152.30 0.00 8,449.61 72.83 10-143-502010 Social Security 361.34 215.34 0.00 146.00 40.41 10-143-502020 Group Health Insurance 1,323.00 812.00 0.00 511.00 38.62 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)Page 4 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-143-502030 Retirement 695.50 403.50 0.00 292.00 41.98 10-143-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-143-502050 Life Insurance 4.92 3.69 0.00 1.23 25.00 10-143-502060 Long Term Disability 13.33 10.00 0.00 3.33 24.98 10-143-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 14,000.00 4,596.83 0.00 9,403.17 67.17 10-143-520072 Subrecipient Reimbursements 100,000.00 0.00 0.00 100,000.00 100.00 E15 Contractual Services 100,000.00 0.00 0.00 100,000.00 100.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 114,000.00 4,596.83 0.00 109,403.17 95.9677 Grand Total -114,000.00 -4,596.83 0.00 -109,403.17 0.9597 143 CDBG-CV Compass Health 114,000.00 4,596.83 0.00 109,403.17 95.97 144 CDBG-DR 10-144-501020 Salaries 262,586.37 25,753.15 0.00 236,833.22 90.19 10-144-502010 Social Security 3,526.27 1,883.60 0.00 1,642.67 46.58 10-144-502020 Group Health Insurance 9,875.25 5,006.92 0.00 4,868.33 49.30 10-144-502030 Retirement 6,250.63 3,296.41 0.00 2,954.22 47.26 10-144-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-144-502050 Life Insurance 36.01 30.27 0.00 5.74 15.94 10-144-502060 Long Term Disability 97.47 81.89 0.00 15.58 15.98 10-144-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 282,372.00 36,052.24 0.00 246,319.76 87.23 10-144-528041 Acquisition for Demo 200,000.00 0.00 0.00 200,000.00 100.00 10-144-528042 New Construction SF 521,928.00 0.00 0.00 521,928.00 100.00 10-144-528043 Multi-Family 4,800,000.00 0.00 0.00 4,800,000.00 100.00 10-144-528044 Down Payment Assistance 50,000.00 0.00 0.00 50,000.00 100.00 10-144-528046 Homeowner Rehab 200,000.00 0.00 0.00 200,000.00 100.00 10-144-528047 Infrastructure 1,000,000.00 0.00 0.00 1,000,000.00 100.00 10-144-528048 Public Service 5,000.00 0.00 0.00 5,000.00 100.00 10-144-528049 Planning 250,000.00 0.00 0.00 250,000.00 100.00 E15 Contractual Services 7,026,928.00 0.00 0.00 7,026,928.00 100.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 7,309,300.00 36,052.24 0.00 7,273,247.76 99.5068 Grand Total -7,309,300.00 -36,052.24 0.00 -7,273,247.76 0.9951 144 CDBG-DR 7,309,300.00 36,052.24 0.00 7,273,247.76 99.51 145 CDBG-CV Cole Co EMS Station 10-145-501020 Salaries 38,295.11 10,481.71 0.00 27,813.40 72.63 10-145-502010 Social Security 1,205.81 712.23 0.00 493.58 40.93 10-145-502020 Group Health Insurance 3,666.95 2,633.69 0.00 1,033.26 28.18 10-145-502030 Retirement 1,771.85 1,341.66 0.00 430.19 24.28 10-145-502040 Workers Compensation 8.34 8.34 0.00 0.00 0.00 10-145-502050 Life Insurance 13.58 11.60 0.00 1.98 14.58 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)Page 5 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-145-502060 Long Term Disability 33.34 30.79 0.00 2.55 7.65 10-145-502070 Employee Assistance Prgm 5.02 0.00 0.00 5.02 100.00 E05 Personnel Services 45,000.00 15,220.02 0.00 29,779.98 66.18 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 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 2,000,000.00 15,220.02 0.00 1,984,779.98 99.239 Grand Total -2,000,000.00 -15,220.02 0.00 -1,984,779.98 0.9924 145 CDBG-CV Cole Co EMS Station 2,000,000.00 15,220.02 0.00 1,984,779.98 99.24 146 HPF-P Bruhn Revitalization 10-146-501020 Salaries 44,066.84 22,802.67 0.00 21,264.17 48.25 10-146-502010 Social Security 2,060.37 1,552.34 0.00 508.03 24.66 10-146-502020 Group Health Insurance 8,016.94 6,058.30 0.00 1,958.64 24.43 10-146-502030 Retirement 3,870.14 2,918.76 0.00 951.38 24.58 10-146-502040 Workers Compensation 9.83 7.37 0.00 2.46 25.03 10-146-502050 Life Insurance 35.19 27.80 0.00 7.39 21.00 10-146-502060 Long Term Disability 94.24 74.48 0.00 19.76 20.97 10-146-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 58,153.55 33,441.72 0.00 24,711.83 42.49 10-146-511020 Postage 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 0.00 0.00 0.00 0.00 0.00 10-146-522020 Professional Services 355.76 293.94 0.00 61.82 17.38 E15 Contractual Services 355.76 293.94 0.00 61.82 17.38 10-146-550068 Pass-Through Grants 640,830.00 0.00 0.00 640,830.00 100.00 E65 Other Non-Operating Expenses 640,830.00 0.00 0.00 640,830.00 100.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 699,339.31 33,735.66 0.00 665,603.65 95.1761 Grand Total -699,339.31 -33,735.66 0.00 -665,603.65 0.9518 146 HPF-P Bruhn Revitalization 699,339.31 33,735.66 0.00 665,603.65 95.18 147 CDBG-CV Transform Housing 10-147-501020 Salaries 26,883.63 7,198.62 0.00 19,685.01 73.22 10-147-502010 Social Security 868.14 489.24 0.00 378.90 43.65 10-147-502020 Group Health Insurance 2,586.82 1,713.40 0.00 873.42 33.76 10-147-502030 Retirement 1,380.10 921.42 0.00 458.68 33.24 10-147-502040 Workers Compensation 5.72 5.72 0.00 0.00 0.00 10-147-502050 Life Insurance 9.30 7.66 0.00 1.64 17.63 10-147-502060 Long Term Disability 22.85 20.32 0.00 2.53 11.07 10-147-502070 Employee Assistance Prgm 3.44 0.00 0.00 3.44 100.00 E05 Personnel Services 31,760.00 10,356.38 0.00 21,403.62 67.39 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)Page 6 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 575,760.00 10,356.38 0.00 565,403.62 98.2013 Grand Total -575,760.00 -10,356.38 0.00 -565,403.62 0.982 147 CDBG-CV Transform Housing 575,760.00 10,356.38 0.00 565,403.62 98.20 148 CDBG-CV 10-148-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-148-502010 Social Security 0.00 0.00 0.00 0.00 0.00 10-148-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-148-502030 Retirement 0.00 0.00 0.00 0.00 0.00 10-148-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-148-502050 Life Insurance 0.00 0.00 0.00 0.00 0.00 10-148-502060 Long Term Disability 0.00 0.00 0.00 0.00 0.00 10-148-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-148-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-148-511020 Postage 0.00 0.00 0.00 0.00 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 0.00 0.00 0.00 0.00 10-148-520070 Training and Education 0.00 0.00 0.00 0.00 0.00 10-148-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-148-528025 CARES-Childcare Services 19,944.00 0.00 0.00 19,944.00 100.00 10-148-528035 CARES-ED For-Profit Business 59,962.32 29,351.32 0.00 30,611.00 51.05 10-148-528045 CARES-ED Microenterprise 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 79,906.32 29,351.32 0.00 50,555.00 63.27 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 79,906.32 29,351.32 0.00 50,555.00 63.2678 Grand Total -79,906.32 -29,351.32 0.00 -50,555.00 0.6327 148 CDBG-CV 79,906.32 29,351.32 0.00 50,555.00 63.27 149 Entitlement Grant 10-149-501020 Salaries 43,452.14 20,501.18 0.00 22,950.96 52.82 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 4,046.91 1,460.63 0.00 2,586.28 63.91 10-149-502011 CARES-Social Security 0.00 0.00 0.00 0.00 0.00 10-149-502020 Group Health Insurance 12,883.67 4,301.52 0.00 8,582.15 66.61 10-149-502024 CARES-Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-149-502030 Retirement 7,133.44 2,624.23 0.00 4,509.21 63.21 10-149-502031 CARES-Retirement 0.00 0.00 0.00 0.00 0.00 10-149-502040 Workers Compensation 35.81 35.81 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)Page 7 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-149-502041 CARES-Workers Comp 0.00 0.00 0.00 0.00 0.00 10-149-502050 Life Insurance 58.28 23.57 0.00 34.71 59.56 10-149-502051 CARES-Life Insurance 0.00 0.00 0.00 0.00 0.00 10-149-502060 Long Term Disability 143.12 62.63 0.00 80.49 56.24 10-149-502061 CARES-Long Term Disability 0.00 0.00 0.00 0.00 0.00 10-149-502070 Employee Assistance Program 21.56 23.01 0.00 -1.45 -6.73 10-149-502071 CARES-Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 67,774.93 29,032.58 0.00 38,742.35 57.16 10-149-511010 Advertising 1,400.00 1,031.25 0.00 368.75 26.34 10-149-511011 CARES-Advertising 0.00 0.00 0.00 0.00 0.00 10-149-511020 Postage 70.00 106.74 0.00 -36.74 -52.49 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 250.00 23.65 0.00 226.35 90.54 10-149-513011 CARES-Office Supplies 0.00 0.00 0.00 0.00 0.00 10-149-517010 Operational Supplies 100.00 0.00 0.00 100.00 100.00 10-149-517011 CARES-Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 1,820.00 1,161.64 0.00 658.36 36.17 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 38,510.00 12,500.00 26,010.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 40,000.00 4,189.00 0.00 35,811.00 89.53 10-149-528012 Housing Rehab-Energy Efficienc 0.00 0.00 0.00 0.00 0.00 10-149-528020 Housing Assistance 140,000.00 36,185.00 0.00 103,815.00 74.15 10-149-528025 CARES-Childcare Services 0.00 0.00 0.00 0.00 0.00 10-149-528030 Public Improvement 313,000.00 313,000.00 0.00 0.00 0.00 10-149-528035 CARES-ED For-Profit Business 365,932.02 0.00 0.00 365,932.02 100.00 10-149-528040 Neighborhood Redevelopmnt 40,000.00 54.00 0.00 39,946.00 99.87 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 958,467.02 365,955.00 26,010.00 566,502.02 59.11 10-149-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-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 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)Page 8 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 1,028,061.95 396,149.22 26,010.00 605,902.73 58.9364 Grand Total -1,028,061.95 -396,149.22 -26,010.00 -605,902.73 0.5894 149 Entitlement Grant 1,028,061.95 396,149.22 26,010.00 605,902.73 58.94 150 City Attorney 10-150-501020 Salaries 240,166.03 175,103.12 0.00 65,062.91 27.09 10-150-501040 Part-time (w\benefits)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 10-150-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-150-502010 Social Security 17,884.00 12,950.31 0.00 4,933.69 27.59 10-150-502020 Group Health Insurance 35,360.71 23,884.79 0.00 11,475.92 32.45 10-150-502030 Retirement 29,923.56 21,595.84 0.00 8,327.72 27.83 10-150-502040 Workers Compensation 230.79 230.79 0.00 0.00 0.00 10-150-502050 Life Insurance 286.42 191.46 0.00 94.96 33.15 10-150-502060 Long Term Disability 607.87 500.37 0.00 107.50 17.68 10-150-502070 Employee Assistance Prgm 65.52 46.02 0.00 19.50 29.76 10-150-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 324,524.90 234,502.70 0.00 90,022.20 27.74 10-150-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-150-511020 Postage 600.00 190.96 0.00 409.04 68.17 10-150-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-150-512020 Copies 0.00 19.88 0.00 -19.88 0.00 10-150-513010 Office Supplies 1,275.00 102.41 0.00 1,172.59 91.97 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 1,875.00 313.25 0.00 1,561.75 83.29 10-150-520020 Auditing Travel Expense 0.00 0.00 0.00 0.00 0.00 10-150-520030 Dues And Publications 11,288.92 7,036.53 2,493.70 1,758.69 15.58 10-150-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-150-520070 Training And Education 6,255.00 4,934.01 0.00 1,320.99 21.12 10-150-520080 Tuition Reimbursement 0.00 0.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 4,556.08 1,363.35 0.00 3,192.73 70.08 10-150-525030 Litigation Expenses 500.00 365.00 0.00 135.00 27.00 10-150-525031 Special Litigation Expenses 0.00 56,815.96 0.00 -56,815.96 0.00 E15 Contractual Services 22,600.00 70,514.85 2,493.70 -50,408.55 -223.05 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 371.00 317.85 105.95 -52.80 -14.23 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)Page 9 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E25 Repairs & Maintenance 371.00 317.85 105.95 -52.80 -14.23 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 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 349,370.90 305,648.65 2,599.65 41,122.60 11.7705 Grand Total -349,370.90 -305,648.65 -2,599.65 -41,122.60 0.1177 150 City Attorney 349,370.90 305,648.65 2,599.65 41,122.60 11.77 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 133,379.83 102,299.91 0.00 31,079.92 23.30 10-160-501040 Part-time (w\benefits)0.00 0.00 0.00 0.00 0.00 10-160-501050 Parttime(wo Benefits)7,000.00 4,348.00 0.00 2,652.00 37.89 10-160-501090 Overtime 1,000.00 106.48 0.00 893.52 89.35 10-160-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-160-502010 Social Security 12,831.35 10,016.48 0.00 2,814.87 21.94 10-160-502020 Group Health Insurance 25,616.32 17,132.32 0.00 8,484.00 33.12 10-160-502030 Retirement 16,093.46 13,108.11 0.00 2,985.35 18.55 10-160-502040 Workers Compensation 198.17 198.17 0.00 0.00 0.00 10-160-502050 Life Insurance 153.00 110.95 0.00 42.05 27.48 10-160-502060 Long Term Disability 381.67 297.72 0.00 83.95 22.00 10-160-502070 Employee Assistance Prgm 65.52 46.02 0.00 19.50 29.76 10-160-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 231,719.24 173,914.10 0.00 57,805.14 24.95 10-160-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-160-511020 Postage 2,000.00 1,285.32 0.00 714.68 35.73 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 2,500.00 578.35 777.95 1,143.70 45.75 10-160-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 4,900.00 1,863.67 777.95 2,258.38 46.09 10-160-520025 Security 12,500.00 7,065.37 0.00 5,434.63 43.48 10-160-520030 Dues And Publications 0.00 0.00 0.00 0.00 0.00 10-160-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-160-520070 Training And Education 2,500.00 480.00 0.00 2,020.00 80.80 10-160-522020 Professional Services 4,500.00 77.81 0.00 4,422.19 98.27 10-160-525005 Appointed Counsel 3,000.00 707.50 0.00 2,292.50 76.42 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 22,790.00 8,330.68 0.00 14,459.32 63.45 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 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)Page 10 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-160-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-160-547020 Maintenance Agreements 6,295.00 5,827.30 329.10 138.60 2.20 E25 Repairs & Maintenance 6,295.00 5,827.30 329.10 138.60 2.20 10-160-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-160-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 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 265,704.24 189,935.75 1,107.05 74,661.44 28.0995 Grand Total -265,704.24 -189,935.75 -1,107.05 -74,661.44 0.281 160 Municipal Court 265,704.24 189,935.75 1,107.05 74,661.44 28.10 170 Human Resources 10-170-501020 Salaries 238,448.92 183,201.40 0.00 55,247.52 23.17 10-170-501050 Parttime(wo Benefits)13,000.00 9,992.41 0.00 3,007.59 23.14 10-170-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-170-501090 Overtime 100.00 146.82 0.00 -46.82 -46.82 10-170-501095 Overtime Straight Pay 0.00 30.59 0.00 -30.59 0.00 10-170-502010 Social Security 18,543.62 14,530.02 0.00 4,013.60 21.64 10-170-502020 Group Health Insurance 25,708.58 18,477.98 0.00 7,230.60 28.13 10-170-502030 Retirement 29,363.23 23,159.48 0.00 6,203.75 21.13 10-170-502040 Workers Compensation 325.69 325.69 0.00 0.00 0.00 10-170-502050 Life Insurance 280.30 202.58 0.00 77.72 27.73 10-170-502060 Long Term Disability 589.14 535.12 0.00 54.02 9.17 10-170-502070 Employee Assistance Prgm 65.52 46.02 0.00 19.50 29.76 10-170-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 326,425.00 250,648.11 0.00 75,776.89 23.21 10-170-511010 Advertising 50.00 0.00 0.00 50.00 100.00 10-170-511020 Postage 300.00 133.35 0.00 166.65 55.55 10-170-512010 Printing 800.00 0.00 0.00 800.00 100.00 10-170-512020 Copies 500.00 291.80 0.00 208.20 41.64 10-170-513010 Office Supplies 600.00 305.79 0.00 294.21 49.04 10-170-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-170-517010 Operational Supplies 680.00 65.44 0.00 614.56 90.38 E10 Materials & Supplies 2,930.00 796.38 0.00 2,133.62 72.82 10-170-520030 Dues And Publications 700.00 249.98 0.00 450.02 64.29 10-170-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-170-520060 Wellness Program 3,000.00 1,416.71 0.00 1,583.29 52.78 10-170-520070 Training And Education 4,437.00 2,288.63 0.00 2,148.37 48.42 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 432.25 0.00 67.75 13.55 10-170-522020 Professional Services 11,600.00 10,013.21 0.00 1,586.79 13.68 10-170-529010 Special Events 800.00 9.58 0.00 790.42 98.80 10-170-529015 Human Relations Commission 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 21,037.00 14,410.36 0.00 6,626.64 31.50 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)Page 11 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 52,738.61 51,865.20 120.50 752.91 1.43 E25 Repairs & Maintenance 52,738.61 51,865.20 120.50 752.91 1.43 10-170-572020 Purchase Of Equipment 3,175.24 3,175.24 0.00 0.00 0.00 E70 Capital Purchases 3,175.24 3,175.24 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 406,305.85 320,895.29 120.50 85,290.06 20.9916 Grand Total -406,305.85 -320,895.29 -120.50 -85,290.06 0.2099 170 Human Resources 406,305.85 320,895.29 120.50 85,290.06 20.99 180 Finance Department 10-180-501020 Salaries 585,933.62 378,682.90 0.00 207,250.72 35.37 10-180-501040 Part-time (w\benefits)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 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 43,659.19 28,340.79 0.00 15,318.40 35.09 10-180-502020 Group Health Insurance 96,970.17 58,721.59 0.00 38,248.58 39.44 10-180-502030 Retirement 73,050.67 46,443.99 0.00 26,606.68 36.42 10-180-502040 Workers Compensation 498.83 498.80 0.00 0.03 0.01 10-180-502050 Life Insurance 703.80 424.75 0.00 279.05 39.65 10-180-502060 Long Term Disability 1,743.45 1,133.30 0.00 610.15 35.00 10-180-502070 Employee Assistance Prgm 234.78 131.31 0.00 103.47 44.07 10-180-503020 Unemployment Compensation 0.00 200.28 0.00 -200.28 0.00 E05 Personnel Services 802,794.51 514,577.71 0.00 288,216.80 35.90 10-180-511010 Advertising 1,000.00 164.00 0.00 836.00 83.60 10-180-511020 Postage 10,000.00 7,285.29 0.00 2,714.71 27.15 10-180-511021 Mail Machine Cost 3,000.00 1,690.21 0.00 1,309.79 43.66 10-180-512010 Printing 3,000.00 2,020.68 0.00 979.32 32.64 10-180-512020 Copies 1,000.00 23.86 0.00 976.14 97.61 10-180-512021 Copy Machine Cost 190.00 -301.74 181.96 309.78 163.04 10-180-513010 Office Supplies 1,250.00 201.63 0.00 1,048.37 83.87 10-180-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-180-517010 Operational Supplies 3,655.00 212.56 0.00 3,442.44 94.18 E10 Materials & Supplies 23,095.00 11,296.49 181.96 11,616.55 50.30 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 1,955.00 142.06 0.00 1,812.94 92.73 10-180-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-180-520070 Training And Education 5,450.00 3,004.36 0.00 2,445.64 44.87 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)Page 12 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-180-520080 Tuition Reimbursement 2,804.00 2,808.00 0.00 -4.00 -0.14 10-180-522010 Audit 59,643.71 45,377.88 0.00 14,265.83 23.92 10-180-522015 Budget Expense 0.00 0.00 0.00 0.00 0.00 10-180-522020 Professional Services 150.00 38.90 0.00 111.10 74.07 E15 Contractual Services 70,002.71 51,371.20 0.00 18,631.51 26.62 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 14,120.00 13,645.16 312.30 162.54 1.15 E25 Repairs & Maintenance 14,120.00 13,645.16 312.30 162.54 1.15 10-180-572020 Purchase Of Equipment 4,210.45 2,923.35 0.00 1,287.10 30.57 E70 Capital Purchases 4,210.45 2,923.35 0.00 1,287.10 30.57 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 914,222.67 593,813.91 494.26 319,914.50 34.9931 Grand Total -914,222.67 -593,813.91 -494.26 -319,914.50 0.3499 180 Finance Department 914,222.67 593,813.91 494.26 319,914.50 34.99 185 Non-Departmental 10-185-501020 Salaries 16,385.95 0.00 0.00 16,385.95 100.00 10-185-501021 Vacancy Savings 0.00 0.00 0.00 0.00 0.00 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 34,558.92 0.00 2,408.51 6.52 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 4,200.00 481.75 0.00 3,718.25 88.53 10-185-504010 Employee Salary Guarantee Fund 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 57,553.38 35,040.67 0.00 22,512.71 39.12 10-185-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-185-514010 Gas 20,000.00 15,938.46 0.00 4,061.54 20.31 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 10-185-550034 National Opioid Settlement 67,382.35 570.00 0.00 66,812.35 99.15 E10 Materials & Supplies 87,382.35 16,508.46 0.00 70,873.89 81.11 10-185-520030 Dues and Publications 0.00 0.00 0.00 0.00 0.00 10-185-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-185-521010 General Insurance 481,601.50 497,327.60 0.00 -15,726.10 -3.27 10-185-521020 Insurance Deductible 25,000.00 94,912.11 0.00 -69,912.11 -279.65 10-185-521030 Self Ins Prop & Casualty 15,000.00 701.63 0.00 14,298.37 95.32 10-185-521060 Drugalcohol screening 3,564.00 3,265.00 0.00 299.00 8.39 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)Page 13 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 111,800.00 46,791.00 17,697.00 47,312.00 42.32 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 138,750.00 0.00 46,250.00 25.00 10-185-529010 Special Events 5,000.00 2,126.06 0.00 2,873.94 57.48 E15 Contractual Services 873,965.50 783,873.40 17,697.00 72,395.10 8.28 10-185-531010 Electricity 32,000.00 22,922.40 0.00 9,077.60 28.37 10-185-533010 Natural Gas 6,200.00 5,295.66 0.00 904.34 14.59 10-185-535010 Water 7,250.00 5,257.88 0.00 1,992.12 27.48 10-185-535020 Downtown Irrigation 0.00 0.00 0.00 0.00 0.00 E20 Utilities 45,450.00 33,475.94 0.00 11,974.06 26.35 10-185-540010 Building & Grounds Maint.15,000.00 42,809.75 0.00 -27,809.75 -185.40 10-185-540015 Amtrak Station 4,000.00 1,810.62 0.00 2,189.38 54.73 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,696.00 0.00 364.00 17.67 E25 Repairs & Maintenance 46,060.00 71,316.37 0.00 -25,256.37 -54.83 10-185-550010 Miscellaneous 2,800.00 2,199.52 0.00 600.48 21.45 10-185-550015 Bad Debt Expense 0.00 0.00 0.00 0.00 0.00 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 451,560.76 286,222.17 0.00 165,338.59 36.61 E30 Other Operating Expenses 464,360.76 298,421.69 0.00 165,939.07 35.73 10-185-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)Page 14 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 0.00 45,871.97 0.00 -45,871.97 0.00 10-185-578073 Council Infrastructure Proj 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 0.00 45,871.97 0.00 -45,871.97 0.00 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 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 1,574,771.99 1,284,508.50 17,697.00 272,566.49 17.3083 Grand Total -1,574,771.99 -1,284,508.50 -17,697.00 -272,566.49 0.1731 185 Non-Departmental 1,574,771.99 1,284,508.50 17,697.00 272,566.49 17.31 186 Emerg Mgmt Operations 10-186-544030 Emerg Mgmt Operations 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 0.00 0.00 0.00 0.00 0 Grand Total 0.00 0.00 0.00 0.00 0 186 Emerg Mgmt Operations 0.00 0.00 0.00 0.00 0.00 190 Information Technology Svcs 10-190-501020 Salaries 570,896.20 447,490.50 0.00 123,405.70 21.62 10-190-501040 Part-time (w\benefits)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 500.00 0.00 0.00 500.00 100.00 10-190-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-190-502010 Social Security 46,425.69 33,301.82 0.00 13,123.87 28.27 10-190-502020 Group Health Insurance 96,814.24 56,771.51 0.00 40,042.73 41.36 10-190-502030 Retirement 77,679.59 49,025.86 0.00 28,653.73 36.89 10-190-502040 Workers Compensation 1,358.21 1,358.21 0.00 0.00 0.00 10-190-502050 Life Insurance 744.19 486.01 0.00 258.18 34.69 10-190-502060 Long Term Disability 1,815.32 1,318.37 0.00 496.95 27.38 10-190-502070 Employee Assistance Prgm 207.48 145.77 0.00 61.71 29.74 E05 Personnel Services 796,440.92 589,898.05 0.00 206,542.87 25.93 10-190-511010 Advertising 100.00 54.00 0.00 46.00 46.00 10-190-511020 Postage 50.00 0.00 0.00 50.00 100.00 10-190-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-190-512020 Copies 10.00 8.27 0.00 1.73 17.30 10-190-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-190-513010 Office Supplies 500.00 439.86 0.00 60.14 12.03 10-190-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)Page 15 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 2,000.00 3,079.50 0.00 -1,079.50 -53.98 E10 Materials & Supplies 2,660.00 3,581.63 0.00 -921.63 -34.65 10-190-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-190-520030 Dues And Publications 150.00 139.00 0.00 11.00 7.33 10-190-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-190-520070 Training And Education 8,500.00 3,902.61 0.00 4,597.39 54.09 10-190-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-190-522020 Professional Services 44,000.00 41,600.89 0.00 2,399.11 5.45 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 18,878.22 0.00 4,121.78 17.92 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 80,050.00 68,835.72 0.00 11,214.28 14.01 10-190-534010 Telephone 96,000.00 63,618.89 0.00 32,381.11 33.73 E20 Utilities 96,000.00 63,618.89 0.00 32,381.11 33.73 10-190-545010 Software License\maint 197,000.00 190,391.90 1,080.00 5,528.10 2.81 10-190-545020 Citywide Wiring\network 0.00 0.00 0.00 0.00 0.00 10-190-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-190-547020 Maintenance Agreements 22,000.00 19,516.76 104.10 2,379.14 10.81 10-190-547025 Coun Chamber MediaEquip Repr 0.00 273.06 0.00 -273.06 0.00 E25 Repairs & Maintenance 219,000.00 210,181.72 1,184.10 7,634.18 3.49 10-190-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 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 1,194,150.92 936,116.01 1,184.10 256,850.81 21.5091 Grand Total -1,194,150.92 -936,116.01 -1,184.10 -256,850.81 0.2151 190 Information Technology Svcs 1,194,150.92 936,116.01 1,184.10 256,850.81 21.51 300 Police Department 10-300-501020 Salaries 5,510,756.15 3,863,734.31 0.00 1,647,021.84 29.89 10-300-501030 Holiday Pay 162,165.48 116,981.39 0.00 45,184.09 27.86 10-300-501040 Part-time (w\benefits)40,192.30 0.00 0.00 40,192.30 100.00 10-300-501050 Parttime(wo Benefits)45,858.01 23,300.03 0.00 22,557.98 49.19 10-300-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-300-501070 Stand-by Plan 5,000.00 8,541.68 0.00 -3,541.68 -70.83 10-300-501090 Overtime 304,257.77 317,360.11 0.00 -13,102.34 -4.31 10-300-501095 Overtime Straight Pay 13,275.00 13,528.38 0.00 -253.38 -1.91 10-300-502010 Social Security 444,750.67 316,651.59 0.00 128,099.08 28.80 10-300-502020 Group Health Insurance 960,547.52 639,738.71 0.00 320,808.81 33.40 10-300-502030 Retirement 1,009,334.34 736,677.47 0.00 272,656.87 27.01 10-300-502040 Workers Compensation 75,085.94 75,085.94 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)Page 16 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-300-502050 Life Insurance 6,542.28 4,351.04 0.00 2,191.24 33.49 10-300-502060 Long Term Disability 15,894.91 11,633.28 0.00 4,261.63 26.81 10-300-502070 Employee Assistance Prgm 1,960.14 1,388.70 0.00 571.44 29.15 10-300-503010 Awards Program 2,500.00 687.00 0.00 1,813.00 72.52 10-300-503020 Unemployment Compensation 0.00 863.52 0.00 -863.52 0.00 E05 Personnel Services 8,598,120.51 6,130,523.15 0.00 2,467,597.36 28.70 10-300-511010 Advertising 5,665.00 4,319.80 0.00 1,345.20 23.75 10-300-511020 Postage 1,395.00 1,068.67 0.00 326.33 23.39 10-300-512010 Printing 5,952.00 2,728.40 0.00 3,223.60 54.16 10-300-512020 Copies 0.00 0.07 0.00 -0.07 0.00 10-300-512030 Photographic Supplies 1,860.00 0.00 0.00 1,860.00 100.00 10-300-513010 Office Supplies 15,670.50 15,365.68 0.00 304.82 1.95 10-300-514010 Gas 188,862.00 146,729.72 0.00 42,132.28 22.31 10-300-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-300-514040 Food 651.00 765.53 0.00 -114.53 -17.59 10-300-515040 First Aid Supplies 1,378.00 1,584.03 0.00 -206.03 -14.95 10-300-516010 Ammunition & Firearms Supplies 63,136.25 57,359.96 4,822.56 953.73 1.51 10-300-516020 Dare Program 0.00 0.00 0.00 0.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 255.00 0.00 -255.00 0.00 10-300-516050 Community Projects 11,100.00 11,100.00 0.00 0.00 0.00 10-300-517010 Operational Supplies 46,278.00 43,181.40 3,543.36 -446.76 -0.97 E10 Materials & Supplies 344,272.75 284,458.26 8,365.92 51,448.57 14.94 10-300-520030 Dues And Publications 5,400.00 4,824.40 0.00 575.60 10.66 10-300-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-300-520070 Training And Education 76,000.00 67,511.45 0.00 8,488.55 11.17 10-300-520080 Tuition Reimbursement 11,625.00 107.00 0.00 11,518.00 99.08 10-300-520090 Recruitment 1,287.00 1,330.74 0.00 -43.74 -3.40 10-300-521040 Medical Claimsservices 6,510.00 6,665.20 0.00 -155.20 -2.38 10-300-521050 Medical Services 0.00 0.00 0.00 0.00 0.00 10-300-522020 Professional Services 16,000.00 17,005.14 0.00 -1,005.14 -6.28 10-300-522026 Drug Forfeiture - Justice 29,750.00 29,761.01 0.00 -11.01 -0.04 10-300-522027 Drug Forfeiture - Treasury 0.00 0.00 0.00 0.00 0.00 10-300-522028 Police Evidence Funds 44,836.00 44,836.00 0.00 0.00 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 655.56 0.00 1,390.44 67.96 E15 Contractual Services 193,454.00 172,696.50 0.00 20,757.50 10.73 10-300-531010 Electricity 44,640.00 26,452.01 0.00 18,187.99 40.74 10-300-533010 Natural Gas 1,116.00 505.75 0.00 610.25 54.68 10-300-534010 Telephone 24,101.00 21,396.21 0.00 2,704.79 11.22 10-300-535010 Water 3,348.00 3,287.69 0.00 60.31 1.80 E20 Utilities 73,205.00 51,641.66 0.00 21,563.34 29.46 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)Page 17 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-300-540010 Building & Grounds Maint.37,200.00 100,983.05 200.00 -63,983.05 -172.00 10-300-541030 Vehicle Wash 9,752.00 8,476.00 0.00 1,276.00 13.08 10-300-544010 K-9 Operations 16,740.00 10,914.83 880.36 4,944.81 29.54 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 27,950.00 25,882.23 0.00 2,067.77 7.40 10-300-545010 Software License\maint 82,414.00 64,645.16 0.00 17,768.84 21.56 10-300-546010 Clothing Expense 48,920.00 20,244.65 130.50 28,544.85 58.35 10-300-546020 Uniform Cleaning 23,715.00 22,266.10 0.00 1,448.90 6.11 10-300-547010 Equipment Maintenance 10,000.00 1,357.82 0.00 8,642.18 86.42 10-300-547020 Maintenance Agreements 56,248.00 39,207.84 6,114.00 10,926.16 19.42 10-300-547030 Radio Maintenance 8,025.00 108.52 0.00 7,916.48 98.65 E25 Repairs & Maintenance 320,964.00 294,086.20 7,324.86 19,552.94 6.09 10-300-572010 Purchase Of Vehicles 46,849.80 46,832.80 0.00 17.00 0.04 10-300-572011 Purchase of Vehicles-Lease Pmt 0.00 0.00 0.00 0.00 0.00 10-300-572020 Purchase Of Equipment 37,162.93 0.00 17,130.00 20,032.93 53.91 10-300-572070 MDT Year 2 Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572075 LLEBG Annual Grant Equipment 131,750.00 131,750.00 0.00 0.00 0.00 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 13,538.67 0.00 12,992.32 546.35 4.04 10-300-572090 Body Worn Cameras 180,000.00 60,000.00 0.00 120,000.00 66.67 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 0.00 0.00 0.00 0.00 0.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 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 409,301.40 238,582.80 30,122.32 140,596.28 34.35 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)Page 18 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 9,939,317.66 7,171,988.57 45,813.10 2,721,515.99 27.3813 Grand Total -9,939,317.66 -7,171,988.57 -45,813.10 -2,721,515.99 0.2738 300 Police Department 9,939,317.66 7,171,988.57 45,813.10 2,721,515.99 27.38 310 School Resource Officer 10-310-501020 Salaries 489,893.97 305,597.29 0.00 184,296.68 37.62 10-310-501030 Holiday Pay 20,720.19 256.24 0.00 20,463.95 98.76 10-310-501090 Overtime 45,106.00 69,547.43 0.00 -24,441.43 -54.19 10-310-501095 Overtime Straight Pay 1,311.00 2,099.20 0.00 -788.20 -60.12 10-310-502010 Social Security 42,612.88 27,256.76 0.00 15,356.12 36.04 10-310-502020 Group Health Insurance 89,715.43 56,609.58 0.00 33,105.85 36.90 10-310-502030 Retirement 100,265.61 67,950.07 0.00 32,315.54 32.23 10-310-502040 Workers Compensation 6,552.86 6,552.86 0.00 0.00 0.00 10-310-502050 Life Insurance 603.43 343.26 0.00 260.17 43.12 10-310-502060 Long Term Disability 1,498.63 921.07 0.00 577.56 38.54 10-310-502070 Employee Assistance Prgm 174.72 122.76 0.00 51.96 29.74 E05 Personnel Services 798,454.72 537,256.52 0.00 261,198.20 32.71 10-310-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-310-516020 Dare Program 15,345.00 2,775.44 0.00 12,569.56 81.91 10-310-517010 Operational Supplies 6,995.00 0.00 1,181.12 5,813.88 83.11 E10 Materials & Supplies 22,340.00 2,775.44 1,181.12 18,383.44 82.29 10-310-520070 Training And Education 4,650.00 1,075.00 0.00 3,575.00 76.88 10-310-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 4,650.00 1,075.00 0.00 3,575.00 76.88 10-310-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-310-546010 Clothing Expense 5,974.00 147.11 0.00 5,826.89 97.54 10-310-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-310-547020 Maintenance Agreements 360.00 1,002.30 104.10 -746.40 -207.33 E25 Repairs & Maintenance 6,334.00 1,149.41 104.10 5,080.49 80.21 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 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 831,778.72 542,256.37 1,285.22 288,237.13 34.6531 Grand Total -831,778.72 -542,256.37 -1,285.22 -288,237.13 0.3465 310 School Resource Officer 831,778.72 542,256.37 1,285.22 288,237.13 34.65 320 M.U.S.T.A.N.G. 10-320-501020 Salaries 127,606.96 97,639.56 0.00 29,967.40 23.48 10-320-501030 Holiday Pay 5,319.56 0.00 0.00 5,319.56 100.00 10-320-501090 Overtime 29,418.22 28,730.49 0.00 687.73 2.34 10-320-501095 Overtime Straight Pay 0.00 1,160.02 0.00 -1,160.02 0.00 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)Page 19 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-320-502010 Social Security 11,037.18 9,265.54 0.00 1,771.64 16.05 10-320-502020 Group Health Insurance 20,462.81 14,860.75 0.00 5,602.06 27.38 10-320-502030 Retirement 25,969.83 22,955.41 0.00 3,014.42 11.61 10-320-502040 Workers Compensation 2,004.39 2,004.39 0.00 0.00 0.00 10-320-502050 Life Insurance 155.45 109.49 0.00 45.96 29.57 10-320-502060 Long Term Disability 384.75 292.15 0.00 92.60 24.07 10-320-502070 Employee Assistance Prgm 43.68 30.69 0.00 12.99 29.74 E05 Personnel Services 222,402.83 177,048.49 0.00 45,354.34 20.39 10-320-514010 Gas 11,848.00 6,943.56 0.00 4,904.44 41.39 10-320-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-320-516040 Investigations 15,106.00 7,708.40 0.00 7,397.60 48.97 10-320-517010 Operational Supplies 5,194.28 600.00 0.00 4,594.28 88.45 E10 Materials & Supplies 32,148.28 15,251.96 0.00 16,896.32 52.56 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 17,500.00 9,300.00 0.00 8,200.00 46.86 10-320-523020 Building Lease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 17,500.00 9,300.00 0.00 8,200.00 46.86 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 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 272,051.11 201,600.45 0.00 70,450.66 25.8961 Grand Total -272,051.11 -201,600.45 0.00 -70,450.66 0.259 320 M.U.S.T.A.N.G.272,051.11 201,600.45 0.00 70,450.66 25.90 330 Animal Control 10-330-501020 Salaries 381,537.88 250,477.26 0.00 131,060.62 34.35 10-330-501040 Part-time (w\benefits)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,141.09 0.00 2,458.91 28.59 10-330-501090 Overtime 2,000.00 10,263.63 0.00 -8,263.63 -413.18 10-330-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-330-502010 Social Security 29,122.87 18,305.24 0.00 10,817.63 37.14 10-330-502020 Group Health Insurance 93,298.71 58,513.65 0.00 34,785.06 37.28 10-330-502030 Retirement 48,728.46 32,434.66 0.00 16,293.80 33.44 10-330-502040 Workers Compensation 4,681.08 4,681.08 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)Page 20 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-330-502050 Life Insurance 456.55 271.78 0.00 184.77 40.47 10-330-502060 Long Term Disability 1,117.06 754.02 0.00 363.04 32.50 10-330-502070 Employee Assistance Prgm 174.72 122.76 0.00 51.96 29.74 10-330-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 569,717.33 381,965.17 0.00 187,752.16 32.96 10-330-511010 Advertising 905.00 0.00 0.00 905.00 100.00 10-330-511020 Postage 152.00 62.00 0.00 90.00 59.21 10-330-512010 Printing 1,860.00 898.59 0.00 961.41 51.69 10-330-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-330-513010 Office Supplies 1,281.00 270.73 0.00 1,010.27 78.87 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 163.83 0.00 59.17 26.53 10-330-515040 First Aid Supplies 295.00 355.95 0.00 -60.95 -20.66 10-330-517010 Operational Supplies 11,000.00 5,343.49 0.00 5,656.51 51.42 E10 Materials & Supplies 15,716.00 7,094.59 0.00 8,621.41 54.86 10-330-520030 Dues And Publications 900.00 56.35 0.00 843.65 93.74 10-330-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-330-520070 Training And Education 1,000.00 0.00 0.00 1,000.00 100.00 10-330-521040 Medical Claimsservices 690.00 421.60 0.00 268.40 38.90 10-330-522020 Professional Services 3,361.00 1,373.20 0.00 1,987.80 59.14 10-330-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-330-529045 Veterinary Services 3,708.00 3,024.72 0.00 683.28 18.43 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 4,580.00 4,580.00 0.00 0.00 0.00 E15 Contractual Services 14,239.00 9,455.87 0.00 4,783.13 33.59 10-330-531010 Electricity 22,789.00 20,311.82 0.00 2,477.18 10.87 10-330-533010 Natural Gas 21,000.00 20,788.17 0.00 211.83 1.01 10-330-534010 Telephone 810.00 686.19 0.00 123.81 15.29 10-330-535010 Water 3,800.00 3,062.96 0.00 737.04 19.40 E20 Utilities 48,399.00 44,849.14 0.00 3,549.86 7.33 10-330-540010 Building & Grounds Maint.15,000.00 18,357.89 0.00 -3,357.89 -22.39 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 48,790.00 43,465.52 0.00 5,324.48 10.91 10-330-544050 Animal Food 6,103.00 3,570.70 0.00 2,532.30 41.49 10-330-545010 Software Licensemaint 3,191.00 2,720.07 0.00 470.93 14.76 10-330-546010 Clothing Expense 2,025.00 1,827.64 0.00 197.36 9.75 10-330-546020 Uniform Cleaning 0.00 0.00 0.00 0.00 0.00 10-330-547010 Equipment Maintenance 255.00 0.00 0.00 255.00 100.00 10-330-547020 Maintenance Agreements 360.00 312.30 104.10 -56.40 -15.67 10-330-547030 Radio Maintenance 60.00 0.00 0.00 60.00 100.00 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)Page 21 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-330-547040 Crematory Maint & Repair 1,750.00 2,086.00 0.00 -336.00 -19.20 E25 Repairs & Maintenance 78,074.00 72,880.12 104.10 5,089.78 6.52 10-330-572010 Purchase of Vehicles 42,695.00 42,695.00 0.00 0.00 0.00 10-330-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-330-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 42,695.00 42,695.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 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 768,840.33 558,939.89 104.10 209,796.34 27.2874 Grand Total -768,840.33 -558,939.89 -104.10 -209,796.34 0.2729 330 Animal Control 768,840.33 558,939.89 104.10 209,796.34 27.29 390 9-1-1 Police 10-390-501020 Salaries 1,068,038.89 666,609.97 0.00 401,428.92 37.59 10-390-501030 Holiday Pay 38,718.75 27,402.44 0.00 11,316.31 29.23 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-501070 Stand-by Plan 0.00 11,881.69 0.00 -11,881.69 0.00 10-390-501090 Overtime 22,814.00 93,292.54 0.00 -70,478.54 -308.93 10-390-501095 Overtime Straight Pay 1,850.00 3,492.38 0.00 -1,642.38 -88.78 10-390-502010 Social Security 87,556.95 58,999.58 0.00 28,557.37 32.62 10-390-502020 Group Health Insurance 223,648.25 123,017.63 0.00 100,630.62 45.00 10-390-502030 Retirement 152,546.30 86,299.74 0.00 66,246.56 43.43 10-390-502040 Workers Compensation 2,719.96 2,719.96 0.00 0.00 0.00 10-390-502050 Life Insurance 1,332.94 731.54 0.00 601.40 45.12 10-390-502060 Long Term Disability 3,302.13 1,952.99 0.00 1,349.14 40.86 10-390-502070 Employee Assistance Prgm 480.48 326.07 0.00 154.41 32.14 10-390-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 1,603,008.65 1,076,726.53 0.00 526,282.12 32.83 10-390-511010 Advertising 1,400.00 0.00 0.00 1,400.00 100.00 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,800.00 4,728.11 0.00 2,071.89 30.47 E10 Materials & Supplies 8,200.00 4,728.11 0.00 3,471.89 42.34 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 5,650.00 2,204.93 0.00 3,445.07 60.97 10-390-522020 Professional Services 4,300.00 4,016.47 0.00 283.53 6.59 10-390-523010 Equipment Rentlease 99,260.00 46,859.76 0.00 52,400.24 52.79 E15 Contractual Services 109,768.00 53,081.16 0.00 56,686.84 51.64 10-390-531010 Electricity 11,160.00 13,437.10 0.00 -2,277.10 -20.40 10-390-533010 Natural Gas 279.00 361.79 0.00 -82.79 -29.67 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)Page 22 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-390-534010 Telephone 0.00 0.00 0.00 0.00 0.00 10-390-535010 Water 837.00 1,026.88 0.00 -189.88 -22.69 E20 Utilities 12,276.00 14,825.77 0.00 -2,549.77 -20.77 10-390-545010 Software License\maint 51,200.00 48,552.85 0.00 2,647.15 5.17 10-390-546010 Clothing Expense 5,580.00 97.79 0.00 5,482.21 98.25 10-390-546020 Uniform Cleaning 2,976.00 0.00 0.00 2,976.00 100.00 10-390-547010 Equipment Maintenance 4,200.00 12,744.07 0.00 -8,544.07 -203.43 10-390-547020 Maintenance Agreements 75,000.00 71,803.16 192.66 3,004.18 4.01 10-390-547030 Radio Maintenance 4,650.00 0.00 0.00 4,650.00 100.00 E25 Repairs & Maintenance 143,606.00 133,197.87 192.66 10,215.47 7.11 10-390-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 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 1,876,858.65 1,282,559.44 192.66 594,106.55 31.6543 Grand Total -1,876,858.65 -1,282,559.44 -192.66 -594,106.55 0.3165 390 9-1-1 Police 1,876,858.65 1,282,559.44 192.66 594,106.55 31.65 400 Fire Department 10-400-501020 Salaries 4,763,879.64 3,188,525.05 0.00 1,575,354.59 33.07 10-400-501025 Other Hours 0.00 1,756.58 0.00 -1,756.58 0.00 10-400-501030 Holiday Pay 341,978.12 308,418.25 0.00 33,559.87 9.81 10-400-501035 Training & Essential Functions 0.00 12,444.01 0.00 -12,444.01 0.00 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 28,440.73 0.00 9,559.27 25.16 10-400-501090 Overtime-FLSA 48,689.59 146,583.81 0.00 -97,894.22 -201.06 10-400-501092 Overtime-Constant Staffing 0.00 23,566.99 0.00 -23,566.99 0.00 10-400-501095 Overtime Straight Pay 36,310.41 37,845.08 0.00 -1,534.67 -4.23 10-400-502010 Social Security 69,573.39 53,627.83 0.00 15,945.56 22.92 10-400-502020 Group Health Insurance 877,737.91 622,144.22 0.00 255,593.69 29.12 10-400-502030 Retirement 2,292,378.67 1,811,229.90 0.00 481,148.77 20.99 10-400-502040 Workers Compensation 153,030.95 153,030.95 0.00 0.00 0.00 10-400-502050 Life Insurance 5,068.58 3,573.26 0.00 1,495.32 29.50 10-400-502060 Long Term Disability 12,419.68 9,507.25 0.00 2,912.43 23.45 10-400-502070 Employee Assistance Prgm 1,681.68 1,166.19 0.00 515.49 30.65 10-400-503010 Awards Program 1,194.49 244.35 0.00 950.14 79.54 E05 Personnel Services 8,641,943.11 6,402,104.45 0.00 2,239,838.66 25.92 10-400-511010 Advertising 300.00 277.50 0.00 22.50 7.50 10-400-511020 Postage 320.00 302.96 0.00 17.04 5.33 10-400-512010 Printing 834.12 834.12 0.00 0.00 0.00 10-400-512020 Copies 50.00 0.14 0.00 49.86 99.72 10-400-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-400-513010 Office Supplies 1,395.00 1,359.45 0.00 35.55 2.55 10-400-514010 Gas 61,175.00 58,602.24 0.00 2,572.76 4.21 10-400-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-400-514020 Chemicals 317.27 16.95 0.00 300.32 94.66 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)Page 23 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-400-514030 Small Tools 6,248.61 6,248.61 0.00 0.00 0.00 10-400-514040 Food 0.00 0.00 0.00 0.00 0.00 10-400-515040 First Aid Supplies 2,100.00 1,893.17 0.00 206.83 9.85 10-400-517010 Operational Supplies 18,000.00 12,296.19 0.00 5,703.81 31.69 E10 Materials & Supplies 90,740.00 81,831.33 0.00 8,908.67 9.82 10-400-520030 Dues And Publications 3,400.00 2,502.04 0.00 897.96 26.41 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,000.00 30,885.31 0.00 1,114.69 3.48 10-400-520080 Tuition Reimbursement 7,500.00 10,701.00 0.00 -3,201.00 -42.68 10-400-520085 Traing-Home Land Security 0.00 0.00 0.00 0.00 0.00 10-400-521040 Medical Claimsservices 44,451.80 44,451.80 0.00 0.00 0.00 10-400-522020 Professional Services 1,000.00 660.00 0.00 340.00 34.00 10-400-523010 Equipment Rentlease 100.00 0.00 0.00 100.00 100.00 10-400-524010 Trash Collections 93.00 0.00 0.00 93.00 100.00 10-400-529010 Special Events 5,405.51 5,405.51 0.00 0.00 0.00 10-400-529040 Child Safety Seat Pass-through 2,500.00 780.00 0.00 1,720.00 68.80 E15 Contractual Services 96,450.31 95,385.66 0.00 1,064.65 1.10 10-400-531010 Electricity 34,000.00 26,512.24 0.00 7,487.76 22.02 10-400-533010 Natural Gas 20,922.45 21,297.08 0.00 -374.63 -1.79 10-400-534010 Telephone 25,731.75 20,066.17 0.00 5,665.58 22.02 10-400-535010 Water 10,000.00 9,025.60 0.00 974.40 9.74 E20 Utilities 90,654.20 76,901.09 0.00 13,753.11 15.17 10-400-540010 Building & Grounds Maint.90,000.00 44,020.26 21,240.00 24,739.74 27.49 10-400-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-400-546010 Clothing Expense 92,548.20 80,057.76 0.00 12,490.44 13.50 10-400-546020 Uniform Cleaning 500.00 370.20 0.00 129.80 25.96 10-400-547010 Equipment Maintenance 20,000.00 13,654.19 0.00 6,345.81 31.73 10-400-547020 Maintenance Agreements 39,487.50 30,597.39 787.90 8,102.21 20.52 10-400-547030 Radio Maintenance 20,925.00 10,243.26 0.00 10,681.74 51.05 E25 Repairs & Maintenance 263,460.70 178,943.06 22,027.90 62,489.74 23.72 10-400-572010 Purchase Of Vehicles 67,456.00 48,047.93 17,234.42 2,173.65 3.22 10-400-572011 Purchase of Vehicles-Lease Pmt 0.00 0.00 0.00 0.00 0.00 10-400-572020 Purchase Of Equipment 1,500.00 220.11 0.00 1,279.89 85.33 10-400-572021 Purchase of Equipment-ONE TIME 163,699.68 120,544.82 41,069.50 2,085.36 1.27 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 232,655.68 168,812.86 58,303.92 5,538.90 2.38 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 9,415,904.00 7,003,978.45 80,331.82 2,331,593.73 24.7623 Grand Total -9,415,904.00 -7,003,978.45 -80,331.82 -2,331,593.73 0.2476 400 Fire Department 9,415,904.00 7,003,978.45 80,331.82 2,331,593.73 24.76 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)Page 24 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 401 Fire Museum 10-401-531010 Electricity 1,700.00 1,634.46 0.00 65.54 3.86 10-401-533010 Natural Gas 0.00 0.00 0.00 0.00 0.00 10-401-535010 Water 0.00 12.74 0.00 -12.74 0.00 E20 Utilities 1,700.00 1,647.20 0.00 52.80 3.11 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 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 1,700.00 1,647.20 0.00 52.80 3.1059 Grand Total -1,700.00 -1,647.20 0.00 -52.80 0.0311 401 Fire Museum 1,700.00 1,647.20 0.00 52.80 3.11 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 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 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)Page 25 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 0.00 0.00 0.00 0.00 0 Grand Total 0.00 0.00 0.00 0.00 0 500 Public Works 0.00 0.00 0.00 0.00 0.00 520 Plan & Protect Svcs-Admin 10-520-501020 Salaries 240,970.33 193,932.65 0.00 47,037.68 19.52 10-520-501040 Part-time (w\benefits)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 18,375.72 14,224.85 0.00 4,150.87 22.59 10-520-502020 Group Health Insurance 52,232.32 33,960.46 0.00 18,271.86 34.98 10-520-502030 Retirement 30,746.30 22,398.05 0.00 8,348.25 27.15 10-520-502040 Workers Compensation 196.90 196.90 0.00 0.00 0.00 10-520-502050 Life Insurance 296.21 185.57 0.00 110.64 37.35 10-520-502060 Long Term Disability 636.77 482.53 0.00 154.24 24.22 10-520-502070 Employee Assistance Prgm 87.36 46.02 0.00 41.34 47.32 10-520-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 343,541.91 265,427.03 0.00 78,114.88 22.74 10-520-511010 Advertising 100.00 1,022.50 0.00 -922.50 -922.50 10-520-511020 Postage 75.00 33.27 0.00 41.73 55.64 10-520-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-520-512020 Copies 0.00 0.08 0.00 -0.08 0.00 10-520-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-520-513010 Office Supplies 850.00 439.70 0.00 410.30 48.27 10-520-514010 Gas 12,975.00 11,017.53 0.00 1,957.47 15.09 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 1,214.04 0.00 -714.04 -142.81 E10 Materials & Supplies 14,500.00 13,727.12 0.00 772.88 5.33 10-520-520030 Dues And Publications 1,200.00 239.06 0.00 960.94 80.08 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 900.00 0.00 900.00 50.00 10-520-522020 Professional Services 3,000.00 4,035.45 0.00 -1,035.45 -34.52 E15 Contractual Services 6,000.00 5,174.51 0.00 825.49 13.76 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 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)Page 26 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-520-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-520-547020 Maintenance Agreements 29,089.01 32,135.03 272.70 -3,318.72 -11.41 E25 Repairs & Maintenance 29,089.01 32,135.03 272.70 -3,318.72 -11.41 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 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 393,130.92 316,463.69 272.70 76,394.53 19.4323 Grand Total -393,130.92 -316,463.69 -272.70 -76,394.53 0.1943 520 Plan & Protect Svcs-Admin 393,130.92 316,463.69 272.70 76,394.53 19.43 521 Plan & Protect Svcs-Planning 10-521-501020 Salaries 57,618.37 78,108.40 0.00 -20,490.03 -35.56 10-521-501040 Part-time (w\benefits)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 3,932.77 5,836.41 0.00 -1,903.64 -48.40 10-521-502020 Group Health Insurance 9,239.72 12,715.40 0.00 -3,475.68 -37.62 10-521-502030 Retirement 6,580.32 9,997.70 0.00 -3,417.38 -51.93 10-521-502040 Workers Compensation 158.35 158.35 0.00 0.00 0.00 10-521-502050 Life Insurance 62.42 87.81 0.00 -25.39 -40.68 10-521-502060 Long Term Disability 156.03 234.20 0.00 -78.17 -50.10 10-521-502070 Employee Assistance Prgm 15.29 41.43 0.00 -26.14 -170.96 10-521-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 77,763.27 107,179.70 0.00 -29,416.43 -37.83 10-521-511010 Advertising 3,336.00 2,691.95 0.00 644.05 19.31 10-521-511020 Postage 500.00 252.35 0.00 247.65 49.53 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 202.72 0.00 597.28 74.66 10-521-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-521-514040 Food 200.00 87.66 0.00 112.34 56.17 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,112.53 0.00 387.47 25.83 E10 Materials & Supplies 6,336.00 4,347.21 0.00 1,988.79 31.39 10-521-520030 Dues And Publications 14,032.68 14,032.68 0.00 0.00 0.00 10-521-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-521-520070 Training And Education 687.32 180.00 0.00 507.32 73.81 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 14,720.00 14,212.68 0.00 507.32 3.45 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)Page 27 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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,271.00 1,017.32 182.25 71.43 5.62 E25 Repairs & Maintenance 1,271.00 1,017.32 182.25 71.43 5.62 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 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 100,090.27 126,756.91 182.25 -26,848.89 -26.8247 Grand Total -100,090.27 -126,756.91 -182.25 26,848.89 -0.2682 521 Plan & Protect Svcs-Planning 100,090.27 126,756.91 182.25 -26,848.89 -26.82 522 Plan & Protect Svcs-MPO 10-522-501020 Salaries 131,978.86 61,044.68 0.00 70,934.18 53.75 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,974.68 4,614.82 0.00 5,359.86 53.73 10-522-502020 Group Health Insurance 20,902.54 8,284.58 0.00 12,617.96 60.37 10-522-502030 Retirement 16,689.66 7,813.88 0.00 8,875.78 53.18 10-522-502040 Workers Compensation 102.55 102.55 0.00 0.00 0.00 10-522-502050 Life Insurance 161.04 69.39 0.00 91.65 56.91 10-522-502060 Long Term Disability 397.13 185.05 0.00 212.08 53.40 10-522-502070 Employee Assistance Prgm 50.23 35.28 0.00 14.95 29.76 E05 Personnel Services 180,256.69 82,150.23 0.00 98,106.46 54.43 10-522-511010 Advertising 2,389.73 764.74 0.00 1,624.99 68.00 10-522-511020 Postage 300.00 21.60 0.00 278.40 92.80 10-522-512010 Printing 200.00 0.00 0.00 200.00 100.00 10-522-512020 Copies 200.00 0.00 0.00 200.00 100.00 10-522-513010 Office Supplies 1,000.00 0.00 0.00 1,000.00 100.00 10-522-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-522-514040 Food 510.27 510.27 0.00 0.00 0.00 10-522-517010 Operational Supplies 1,000.00 920.43 0.00 79.57 7.96 E10 Materials & Supplies 5,600.00 2,217.04 0.00 3,382.96 60.41 10-522-520030 Dues And Publications 1,500.00 1,435.73 0.00 64.27 4.28 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 0.00 0.00 4,500.00 100.00 10-522-520080 Tuition Reimbursement 3,000.00 0.00 0.00 3,000.00 100.00 10-522-522020 Professional Services 80,000.00 36,410.00 16,508.60 27,081.40 33.85 10-522-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 89,000.00 37,845.73 16,508.60 34,645.67 38.93 10-522-534010 Telephone 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)Page 28 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 2,400.00 1,143.58 161.63 1,094.79 45.62 10-522-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,400.00 1,143.58 161.63 1,094.79 45.62 10-522-572020 Purchase Of Equipment 3,400.00 0.00 0.00 3,400.00 100.00 E70 Capital Purchases 3,400.00 0.00 0.00 3,400.00 100.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 280,656.69 123,356.58 16,670.23 140,629.88 50.1074 Grand Total -280,656.69 -123,356.58 -16,670.23 -140,629.88 0.5011 522 Plan & Protect Svcs-MPO 280,656.69 123,356.58 16,670.23 140,629.88 50.11 530 Plan & Protect Svc-RedevGrant 10-530-501020 Salaries 63,767.96 34,410.44 0.00 29,357.52 46.04 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 8,696.19 2,527.45 0.00 6,168.74 70.94 10-530-502020 Group Health Insurance 25,767.93 5,464.19 0.00 20,303.74 78.79 10-530-502030 Retirement 14,550.48 4,002.75 0.00 10,547.73 72.49 10-530-502040 Workers Compensation 86.30 87.87 0.00 -1.57 -1.82 10-530-502050 Life Insurance 140.44 33.97 0.00 106.47 75.81 10-530-502060 Long Term Disability 344.86 87.63 0.00 257.23 74.59 10-530-502070 Employee Assistance Prgm 51.96 10.22 0.00 41.74 80.33 E05 Personnel Services 113,406.12 46,624.52 0.00 66,781.60 58.89 10-530-511010 Advertising 540.00 205.75 0.00 334.25 61.90 10-530-511020 Postage 150.00 120.57 0.00 29.43 19.62 10-530-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-530-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-530-513010 Office Supplies 110.00 14.35 0.00 95.65 86.95 10-530-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-530-517010 Operational Supplies 580.00 377.04 0.00 202.96 34.99 E10 Materials & Supplies 1,380.00 717.71 0.00 662.29 47.99 10-530-520030 Dues And Publications 604.82 724.70 0.00 -119.88 -19.82 10-530-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-530-520070 Training And Education 1,895.18 2,022.19 0.00 -127.01 -6.70 10-530-522020 Professional Services 0.00 0.00 0.00 0.00 0.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 33,334.00 0.00 0.00 33,334.00 100.00 10-530-524025 Glass Recycling 10,000.00 10,000.00 0.00 0.00 0.00 10-530-524026 Household Hazardous Waste 19,000.00 12,240.99 0.00 6,759.01 35.57 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 27,000.00 0.00 0.00 27,000.00 100.00 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)Page 29 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-530-526060 Refund of Grant Proceeds 0.00 0.00 0.00 0.00 0.00 10-530-528085 Fair Housing Assistance Prog 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 91,834.00 24,987.88 0.00 66,846.12 72.79 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 672.02 540.47 93.73 37.82 5.63 E25 Repairs & Maintenance 672.02 540.47 93.73 37.82 5.63 10-530-550020 NRA-Residential 45,539.18 40,038.77 0.00 5,500.41 12.08 10-530-550030 NRA-Commercial Facade 13,960.82 6,000.00 0.00 7,960.82 57.02 10-530-550031 Historic Preservation Grant 23,030.99 55.75 22,975.24 0.00 0.00 10-530-550032 NRA-Rental Facade 11,281.52 27.00 0.00 11,254.52 99.76 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 1,169.01 92.20 0.00 1,076.81 92.11 10-530-550039 Historic Preservation Grant 50,000.00 67.50 0.00 49,932.50 99.87 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 0.00 0.00 0.00 0.00 0.00 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 144,981.52 46,281.22 22,975.24 75,725.06 52.23 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 352,273.66 119,151.80 23,068.97 210,052.89 59.6278 Grand Total -352,273.66 -119,151.80 -23,068.97 -210,052.89 0.5963 530 Plan & Protect Svc-RedevGrant 352,273.66 119,151.80 23,068.97 210,052.89 59.63 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 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 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)Page 30 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 0.00 0.00 0.00 0.00 0 Grand Total 0.00 0.00 0.00 0.00 0 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 207,768.04 148,762.10 0.00 59,005.94 28.40 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,908.31 10,606.89 0.00 4,301.42 28.85 10-532-502020 Group Health Insurance 39,644.71 27,996.02 0.00 11,648.69 29.38 10-532-502030 Retirement 24,944.62 19,041.52 0.00 5,903.10 23.66 10-532-502040 Workers Compensation 3,753.42 3,753.42 0.00 0.00 0.00 10-532-502050 Life Insurance 238.68 144.91 0.00 93.77 39.29 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)Page 31 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-532-502060 Long Term Disability 592.66 434.86 0.00 157.80 26.63 10-532-502070 Employee Assistance Prgm 65.52 63.92 0.00 1.60 2.44 10-532-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 291,915.96 210,803.64 0.00 81,112.32 27.79 10-532-511010 Advertising 90.00 0.00 0.00 90.00 100.00 10-532-511020 Postage 150.00 75.12 0.00 74.88 49.92 10-532-512010 Printing 20.00 293.00 0.00 -273.00 -1,365.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 411.17 0.00 888.83 68.37 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 355.99 0.00 644.01 64.40 E10 Materials & Supplies 2,625.00 1,135.28 0.00 1,489.72 56.75 10-532-520030 Dues And Publications 900.00 720.00 0.00 180.00 20.00 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 552.90 0.00 447.10 44.71 10-532-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-532-522020 Professional Services 0.00 0.00 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 201,600.00 151,278.00 50,400.00 -78.00 -0.04 10-532-529010 Special Events 600.00 0.00 0.00 600.00 100.00 10-532-529020 Historic Preservation Com 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 204,100.00 152,550.90 50,400.00 1,149.10 0.56 10-532-534010 Telephone 1,200.00 989.76 0.00 210.24 17.52 E20 Utilities 1,200.00 989.76 0.00 210.24 17.52 10-532-540060 Cemetery Maintenance 37,750.00 27,823.39 9,189.00 737.61 1.95 10-532-540065 Cemetery Restoration 0.00 0.00 0.00 0.00 0.00 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 560.42 0.00 519.58 48.11 10-532-547010 Equipment Maintenance 40.00 0.00 0.00 40.00 100.00 10-532-547020 Maintenance Agreements 910.00 973.98 253.45 -317.43 -34.88 10-532-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 41,070.00 30,641.79 9,442.45 985.76 2.40 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 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)Page 32 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 540,910.96 396,121.37 59,842.45 84,947.14 15.7045 Grand Total -540,910.96 -396,121.37 -59,842.45 -84,947.14 0.157 532 Plan & Protect Svcs-Env Health 540,910.96 396,121.37 59,842.45 84,947.14 15.70 533 PPS - Prop MaintCode Enforce 10-533-501020 Salaries 170,055.53 146,675.33 0.00 23,380.20 13.75 10-533-501050 Parttime(wo Benefits)20,000.00 20,187.35 0.00 -187.35 -0.94 10-533-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 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 14,138.32 12,617.79 0.00 1,520.53 10.75 10-533-502020 Group Health Insurance 30,239.78 18,999.80 0.00 11,239.98 37.17 10-533-502030 Retirement 21,096.27 15,723.60 0.00 5,372.67 25.47 10-533-502040 Workers Compensation 2,257.38 2,257.38 0.00 0.00 0.00 10-533-502050 Life Insurance 203.81 136.21 0.00 67.60 33.17 10-533-502060 Long Term Disability 505.89 377.19 0.00 128.70 25.44 10-533-502070 Employee Assistance Prgm 65.52 40.91 0.00 24.61 37.56 E05 Personnel Services 258,562.50 217,015.56 0.00 41,546.94 16.07 10-533-511010 Advertising 100.00 205.63 0.00 -105.63 -105.63 10-533-511020 Postage 1,800.00 1,506.81 0.00 293.19 16.29 10-533-512010 Printing 300.00 194.00 0.00 106.00 35.33 10-533-512020 Copies 0.00 0.04 0.00 -0.04 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 968.91 0.00 31.09 3.11 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,084.07 0.00 265.93 19.70 E10 Materials & Supplies 4,690.00 3,959.46 0.00 730.54 15.58 10-533-520030 Dues And Publications 500.00 220.44 0.00 279.56 55.91 10-533-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-533-520070 Training And Education 1,200.00 1,013.47 0.00 186.53 15.54 10-533-520080 Tuition Reimbursement 0.00 5,082.50 0.00 -5,082.50 0.00 10-533-522019 Demo-Grant Funded 78,457.55 43,780.00 0.00 34,677.55 44.20 10-533-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-533-522021 Abatement 0.00 23,502.80 0.00 -23,502.80 0.00 10-533-522022 Demo 259,433.60 119,072.12 58,566.88 81,794.60 31.53 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 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 339,591.15 192,671.33 58,566.88 88,352.94 26.02 10-533-534010 Telephone 3,701.40 2,893.76 0.00 807.64 21.82 E20 Utilities 3,701.40 2,893.76 0.00 807.64 21.82 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)Page 33 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-533-541030 Vehicle Wash 270.00 270.00 0.00 0.00 0.00 10-533-546010 Clothing Expense 1,280.00 849.43 0.00 430.57 33.64 10-533-547010 Equipment Maintenance 30.00 0.00 0.00 30.00 100.00 10-533-547020 Maintenance Agreements 1,271.00 1,051.03 229.95 -9.98 -0.78 10-533-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,851.00 2,170.46 229.95 450.59 15.80 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 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 609,396.05 418,710.57 58,796.83 131,888.65 21.6425 Grand Total -609,396.05 -418,710.57 -58,796.83 -131,888.65 0.2164 533 PPS - Prop MaintCode Enforce 609,396.05 418,710.57 58,796.83 131,888.65 21.64 534 Plan & Protect Svcs-Bldg Regs 10-534-501020 Salaries 314,201.68 238,388.46 0.00 75,813.22 24.13 10-534-501050 Parttime(wo Benefits)15,900.00 9,243.93 0.00 6,656.07 41.86 10-534-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 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 24,587.69 17,394.54 0.00 7,193.15 29.26 10-534-502020 Group Health Insurance 79,982.22 57,944.00 0.00 22,038.22 27.55 10-534-502030 Retirement 39,104.99 30,513.60 0.00 8,591.39 21.97 10-534-502040 Workers Compensation 4,756.07 4,756.07 0.00 0.00 0.00 10-534-502050 Life Insurance 374.54 272.26 0.00 102.28 27.31 10-534-502060 Long Term Disability 929.35 726.99 0.00 202.36 21.77 10-534-502070 Employee Assistance Prgm 109.20 92.07 0.00 17.13 15.69 10-534-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 479,945.74 359,331.92 0.00 120,613.82 25.13 10-534-511010 Advertising 100.00 0.00 0.00 100.00 100.00 10-534-511020 Postage 1,100.00 196.57 0.00 903.43 82.13 10-534-512010 Printing 100.00 0.00 0.00 100.00 100.00 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 241.80 0.00 658.20 73.13 10-534-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-534-514030 Small Tools 100.00 0.00 0.00 100.00 100.00 10-534-515040 First Aid Supplies 15.00 0.00 0.00 15.00 100.00 10-534-517010 Operational Supplies 1,800.00 491.73 0.00 1,308.27 72.68 E10 Materials & Supplies 4,115.00 930.10 0.00 3,184.90 77.40 10-534-520030 Dues And Publications 2,500.00 734.00 0.00 1,766.00 70.64 10-534-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-534-520070 Training And Education 5,000.00 5,910.99 0.00 -910.99 -18.22 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 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)Page 34 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 7,500.00 6,644.99 0.00 855.01 11.40 10-534-534010 Telephone 3,060.00 2,258.80 0.00 801.20 26.18 E20 Utilities 3,060.00 2,258.80 0.00 801.20 26.18 10-534-541030 Vehicle Wash 270.00 290.00 0.00 -20.00 -7.41 10-534-546010 Clothing Expense 1,400.00 931.00 0.00 469.00 33.50 10-534-547010 Equipment Maintenance 20.00 5.00 0.00 15.00 75.00 10-534-547020 Maintenance Agreements 988.00 893.04 128.28 -33.32 -3.37 10-534-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,678.00 2,119.04 128.28 430.68 16.08 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 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 497,298.74 371,284.85 128.28 125,885.61 25.3139 Grand Total -497,298.74 -371,284.85 -128.28 -125,885.61 0.2531 534 Plan & Protect Svcs-Bldg Regs 497,298.74 371,284.85 128.28 125,885.61 25.31 535 Public Works-Central Maintenan 10-535-501020 Salaries 413,657.31 309,590.86 0.00 104,066.45 25.16 10-535-501040 Part-time (w\benefits)0.00 0.00 0.00 0.00 0.00 10-535-501050 Parttime(wo Benefits)4,000.00 0.00 0.00 4,000.00 100.00 10-535-501070 Stand-by Plan 0.00 0.00 0.00 0.00 0.00 10-535-501090 Overtime 4,500.00 1,812.54 0.00 2,687.46 59.72 10-535-501095 Overtime Straight Pay 500.00 107.59 0.00 392.41 78.48 10-535-502010 Social Security 30,175.52 22,770.97 0.00 7,404.55 24.54 10-535-502020 Group Health Insurance 79,635.09 58,108.55 0.00 21,526.54 27.03 10-535-502030 Retirement 49,977.76 39,873.35 0.00 10,104.41 20.22 10-535-502040 Workers Compensation 4,469.36 4,469.36 0.00 0.00 0.00 10-535-502050 Life Insurance 472.46 343.43 0.00 129.03 27.31 10-535-502060 Long Term Disability 1,177.64 920.82 0.00 256.82 21.81 10-535-502070 Employee Assistance Prgm 152.88 107.40 0.00 45.48 29.75 10-535-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 588,718.02 438,104.87 0.00 150,613.15 25.58 10-535-511010 Advertising 80.00 16.50 0.00 63.50 79.38 10-535-511020 Postage 50.00 2.37 0.00 47.63 95.26 10-535-512020 Copies 10.00 0.00 0.00 10.00 100.00 10-535-513010 Office Supplies 1,000.00 819.02 0.00 180.98 18.10 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 5,000.00 1,437.53 0.00 3,562.47 71.25 10-535-517010 Operational Supplies 7,000.00 6,381.15 0.00 618.85 8.84 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)Page 35 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E10 Materials & Supplies 13,140.00 8,656.57 0.00 4,483.43 34.12 10-535-520030 Dues And Publications 350.00 191.00 0.00 159.00 45.43 10-535-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-535-520070 Training And Education 1,100.00 189.90 0.00 910.10 82.74 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 1,950.00 380.90 0.00 1,569.10 80.47 10-535-531010 Electricity 6,560.00 4,720.36 0.00 1,839.64 28.04 10-535-533010 Natural Gas 3,200.00 3,187.73 0.00 12.27 0.38 10-535-534010 Telephone 420.00 345.69 0.00 74.31 17.69 10-535-535010 Water 1,442.00 937.98 0.00 504.02 34.95 E20 Utilities 11,622.00 9,191.76 0.00 2,430.24 20.91 10-535-540010 Building & Grounds Maint.10,000.00 9,310.60 17.50 671.90 6.72 10-535-541010 Veh & Equip Parts Etc 393,400.00 325,479.02 15,567.13 52,353.85 13.31 10-535-541015 Vehicle Hail Damage Repair 0.00 0.00 0.00 0.00 0.00 10-535-546010 Clothing Expense 10,700.00 10,494.10 0.00 205.90 1.92 10-535-547010 Equipment Maintenance 1,000.00 294.19 94.73 611.08 61.11 10-535-547020 Maintenance Agreements 15,551.00 13,295.51 104.10 2,151.39 13.83 10-535-547030 Radio Maintenance 100.00 0.00 0.00 100.00 100.00 E25 Repairs & Maintenance 430,751.00 358,873.42 15,783.46 56,094.12 13.02 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 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 1,046,181.02 815,207.52 15,783.46 215,190.04 20.5691 Grand Total -1,046,181.02 -815,207.52 -15,783.46 -215,190.04 0.2057 535 Public Works-Central Maintenan 1,046,181.02 815,207.52 15,783.46 215,190.04 20.57 540 Public Works-Admin 10-540-501020 Salaries 246,836.90 188,618.28 0.00 58,218.62 23.59 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 18,049.00 14,394.93 0.00 3,654.07 20.25 10-540-502020 Group Health Insurance 20,506.66 14,055.08 0.00 6,451.58 31.46 10-540-502030 Retirement 30,199.64 22,884.66 0.00 7,314.98 24.22 10-540-502040 Workers Compensation 219.23 219.23 0.00 0.00 0.00 10-540-502050 Life Insurance 290.09 196.89 0.00 93.20 32.13 10-540-502060 Long Term Disability 569.01 507.35 0.00 61.66 10.84 10-540-502070 Employee Assistance Prgm 65.52 46.02 0.00 19.50 29.76 E05 Personnel Services 316,736.05 240,922.44 0.00 75,813.61 23.94 10-540-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-540-511020 Postage 200.00 3.00 0.00 197.00 98.50 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)Page 36 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-540-512010 Printing 100.00 47.00 0.00 53.00 53.00 10-540-512020 Copies 100.00 0.00 0.00 100.00 100.00 10-540-513010 Office Supplies 1,000.00 126.17 0.00 873.83 87.38 10-540-514010 Gas 104,350.00 70,888.96 0.00 33,461.04 32.07 10-540-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-540-514040 Food 1,050.00 1,025.80 0.00 24.20 2.30 10-540-517010 Operational Supplies 300.00 79.99 0.00 220.01 73.34 E10 Materials & Supplies 107,100.00 72,170.92 0.00 34,929.08 32.61 10-540-520030 Dues And Publications 800.00 684.40 0.00 115.60 14.45 10-540-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-540-520070 Training And Education 1,150.00 349.00 0.00 801.00 69.65 10-540-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-540-522020 Professional Services 200.00 60.50 0.00 139.50 69.75 10-540-527010 Comm Serv Projects 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 2,150.00 1,093.90 0.00 1,056.10 49.12 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 405.00 278.13 42.63 84.24 20.80 E25 Repairs & Maintenance 405.00 278.13 42.63 84.24 20.80 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 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 426,391.05 314,465.39 42.63 111,883.03 26.2395 Grand Total -426,391.05 -314,465.39 -42.63 -111,883.03 0.2624 540 Public Works-Admin 426,391.05 314,465.39 42.63 111,883.03 26.24 541 Public Works-Engineering 10-541-501020 Salaries 884,371.34 660,958.92 0.00 223,412.42 25.26 10-541-501040 Part-time (w\benefits)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 3,553.66 3,553.66 0.00 0.00 0.00 10-541-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-541-502010 Social Security 65,834.22 48,375.00 0.00 17,459.22 26.52 10-541-502020 Group Health Insurance 132,614.06 102,770.18 0.00 29,843.88 22.50 10-541-502030 Retirement 110,153.99 83,530.74 0.00 26,623.25 24.17 10-541-502040 Workers Compensation 6,055.72 6,055.72 0.00 0.00 0.00 10-541-502050 Life Insurance 1,055.09 757.76 0.00 297.33 28.18 10-541-502060 Long Term Disability 2,488.48 2,011.09 0.00 477.39 19.18 10-541-502070 Employee Assistance Prgm 262.08 184.14 0.00 77.94 29.74 10-541-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 1,206,388.64 908,197.21 0.00 298,191.43 24.72 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)Page 37 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-541-511010 Advertising 400.00 116.50 0.00 283.50 70.88 10-541-511020 Postage 400.00 56.99 0.00 343.01 85.75 10-541-512010 Printing 50.00 41.00 0.00 9.00 18.00 10-541-512020 Copies 25.00 0.47 0.00 24.53 98.12 10-541-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-541-513010 Office Supplies 1,650.00 626.61 0.00 1,023.39 62.02 10-541-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-541-514030 Small Tools 125.00 0.00 0.00 125.00 100.00 10-541-514040 Food 150.00 0.00 0.00 150.00 100.00 10-541-515040 First Aid Supplies 50.00 0.00 0.00 50.00 100.00 10-541-515070 Const & Inspect Supplies 1,000.00 539.30 0.00 460.70 46.07 10-541-515080 Surveying Supplies 1,500.00 273.89 0.00 1,226.11 81.74 10-541-517010 Operational Supplies 2,000.00 1,908.98 0.00 91.02 4.55 E10 Materials & Supplies 7,350.00 3,563.74 0.00 3,786.26 51.51 10-541-520030 Dues And Publications 3,500.00 2,792.00 0.00 708.00 20.23 10-541-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-541-520070 Training And Education 2,500.00 1,944.00 0.00 556.00 22.24 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 0.00 0.00 500.00 100.00 10-541-522055 Stormwater Compliance 500.00 0.00 0.00 500.00 100.00 E15 Contractual Services 7,000.00 4,736.00 0.00 2,264.00 32.34 10-541-534010 Telephone 500.00 310.93 0.00 189.07 37.81 E20 Utilities 500.00 310.93 0.00 189.07 37.81 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 422.00 0.00 1,078.00 71.87 10-541-547010 Equipment Maintenance 1,000.00 650.00 0.00 350.00 35.00 10-541-547020 Maintenance Agreements 10,665.00 9,023.01 325.98 1,316.01 12.34 10-541-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 14,165.00 11,055.01 325.98 2,784.01 19.65 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 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 1,235,403.64 927,862.89 325.98 307,214.77 24.8676 Grand Total -1,235,403.64 -927,862.89 -325.98 -307,214.77 0.2487 541 Public Works-Engineering 1,235,403.64 927,862.89 325.98 307,214.77 24.87 542 Public Works-Street GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)Page 38 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-542-501020 Salaries 1,420,739.10 1,012,423.42 0.00 408,315.68 28.74 10-542-501024 Salaries-Stormwater 0.00 0.00 0.00 0.00 0.00 10-542-501060 Seasonal Salaries 20,000.00 19,039.50 0.00 960.50 4.80 10-542-501070 Stand-by Plan 7,500.00 7,544.05 0.00 -44.05 -0.59 10-542-501090 Overtime 21,542.08 11,013.88 0.00 10,528.20 48.87 10-542-501095 Overtime Straight Pay 6,457.92 1,696.14 0.00 4,761.78 73.74 10-542-502010 Social Security 109,348.68 77,507.22 0.00 31,841.46 29.12 10-542-502020 Group Health Insurance 304,688.92 195,577.39 0.00 109,111.53 35.81 10-542-502030 Retirement 180,402.50 127,923.64 0.00 52,478.86 29.09 10-542-502040 Workers Compensation 39,110.84 39,110.84 0.00 0.00 0.00 10-542-502050 Life Insurance 1,684.22 1,134.98 0.00 549.24 32.61 10-542-502060 Long Term Disability 4,165.34 3,014.54 0.00 1,150.80 27.63 10-542-502070 Employee Assistance Prgm 622.44 437.31 0.00 185.13 29.74 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 2,116,462.04 1,496,422.91 0.00 620,039.13 29.30 10-542-511010 Advertising 750.00 580.00 0.00 170.00 22.67 10-542-511020 Postage 150.00 1.41 0.00 148.59 99.06 10-542-512010 Printing 94.00 94.00 0.00 0.00 0.00 10-542-512020 Copies 10.00 0.42 0.00 9.58 95.80 10-542-513010 Office Supplies 1,396.00 488.33 0.00 907.67 65.02 10-542-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-542-514020 Chemicals 234,534.87 135,261.70 0.00 99,273.17 42.33 10-542-514030 Small Tools 12,362.18 9,475.11 0.00 2,887.07 23.35 10-542-514040 Food 1,637.82 596.58 0.00 1,041.24 63.57 10-542-515010 Stormwater Material 0.00 0.00 0.00 0.00 0.00 10-542-515020 Street Materials 275,000.00 211,884.66 0.00 63,115.34 22.95 10-542-515040 First Aid Supplies 500.00 256.02 0.00 243.98 48.80 10-542-515060 Weed Control 2,000.00 1,592.41 0.00 407.59 20.38 10-542-515070 Const & Inspect Supplies 200.00 144.73 0.00 55.27 27.64 10-542-517010 Operational Supplies 10,811.47 9,081.38 0.00 1,730.09 16.00 E10 Materials & Supplies 539,446.34 369,456.75 0.00 169,989.59 31.51 10-542-520030 Dues And Publications 1,320.00 554.00 0.00 766.00 58.03 10-542-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-542-520070 Training And Education 8,684.40 8,684.40 0.00 0.00 0.00 10-542-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-542-522020 Professional Services 13,495.60 10,602.30 0.00 2,893.30 21.44 10-542-523010 Equipment Rentlease 200.00 0.00 0.00 200.00 100.00 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,700.00 19,840.70 0.00 3,859.30 16.28 10-542-531010 Electricity 24,364.00 17,244.60 0.00 7,119.40 29.22 10-542-531020 Street Lights 571,962.00 476,746.64 0.00 95,215.36 16.65 10-542-533010 Natural Gas 12,500.00 12,317.89 0.00 182.11 1.46 10-542-534010 Telephone 2,080.00 2,053.97 0.00 26.03 1.25 10-542-535010 Water 8,390.00 3,414.36 0.00 4,975.64 59.30 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)Page 39 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E20 Utilities 619,296.00 511,777.46 0.00 107,518.54 17.36 10-542-540010 Building & Grounds Maint.10,000.00 10,636.26 150.00 -786.26 -7.86 10-542-541030 Vehicle Wash 7,000.00 6,675.00 0.00 325.00 4.64 10-542-542010 Repairs - StopStreet Lights 35,000.00 16,438.69 0.00 18,561.31 53.03 10-542-542030 Signs & Marking Paint 60,000.00 42,343.84 9,305.92 8,350.24 13.92 10-542-546010 Clothing Expense 13,000.00 10,821.03 0.00 2,178.97 16.76 10-542-547010 Equipment Maintenance 3,100.00 809.32 0.00 2,290.68 73.89 10-542-547020 Maintenance Agreements 460.00 312.30 104.10 43.60 9.48 10-542-547030 Radio Maintenance 1,000.00 0.00 0.00 1,000.00 100.00 E25 Repairs & Maintenance 129,560.00 88,036.44 9,560.02 31,963.54 24.67 10-542-572010 Purchase Of Vehicles 0.00 0.00 0.00 0.00 0.00 10-542-572020 Purchase Of Equipment 16,000.00 15,377.53 0.00 622.47 3.89 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 16,000.00 15,377.53 0.00 622.47 3.89 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 3,444,464.38 2,500,911.79 9,560.02 933,992.57 27.1158 Grand Total -3,444,464.38 -2,500,911.79 -9,560.02 -933,992.57 0.2712 542 Public Works-Street 3,444,464.38 2,500,911.79 9,560.02 933,992.57 27.12 700 Transfers & Subsidies 10-700-590050 Transfer To Tif Fund 26,328.02 6,682.21 0.00 19,645.81 74.62 10-700-590051 Trans to Parks 0.00 0.00 0.00 0.00 0.00 10-700-590052 Trans to Airport 0.00 0.00 0.00 0.00 0.00 10-700-590053 Trans to Parking 0.00 0.00 0.00 0.00 0.00 10-700-590054 Trans to Transit 0.00 0.00 0.00 0.00 0.00 10-700-590055 Trans to Wastewater 0.00 0.00 0.00 0.00 0.00 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 97,015.10 97,015.08 0.00 0.02 0.00 10-700-590075 Transit Subsidy 1,218,542.04 1,218,542.04 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 1,341,885.16 1,322,239.33 0.00 19,645.83 1.46 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 1,341,885.16 1,322,239.33 0.00 19,645.83 1.464 Grand Total -1,341,885.16 -1,322,239.33 0.00 -19,645.83 0.0146 700 Transfers & Subsidies 1,341,885.16 1,322,239.33 0.00 19,645.83 1.46 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 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)Page 40 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 0.00 0.00 0.00 0.00 0 Grand Total 0.00 0.00 0.00 0.00 0 900 CapitalVehicleEquipment 0.00 0.00 0.00 0.00 0.00 990 Capital Projects 10-990-599501 JCCVB Lost Revenue 175,000.00 175,000.00 0.00 0.00 0.00 10-990-599502 Downtown Beautification-Match 150,000.00 0.00 0.00 150,000.00 100.00 10-990-599504 Lincoln-Hlth Science & Crisis 500,000.00 0.00 0.00 500,000.00 100.00 10-990-599511 United Cap City Soccer Complex 100,000.00 0.00 0.00 100,000.00 100.00 E65 Other Non-Operating Expenses 925,000.00 175,000.00 0.00 750,000.00 81.08 10-990-540060 Cemetery Maintenance 30,000.00 3,650.00 0.00 26,350.00 87.83 10-990-572015 Vehicle Leasing 0.00 0.00 0.00 0.00 0.00 10-990-575006 New Fire Station Number 2 0.00 0.00 0.00 0.00 0.00 10-990-575010 Police Renov & Upgrades 220,635.00 0.00 0.00 220,635.00 100.00 10-990-575015 Police HVAC 0.00 0.00 0.00 0.00 0.00 10-990-575022 Future Fire Stations 6,992.53 0.00 0.00 6,992.53 100.00 10-990-575023 Fire Station 4 Rehab 0.00 0.00 0.00 0.00 0.00 10-990-576007 Stormwater Improvements 65,917.60 0.00 0.00 65,917.60 100.00 10-990-576008 Air Streets Stormwater 425,000.00 127.00 411,883.75 12,989.25 3.06 10-990-576020 Pipe Lining 2019 0.00 0.00 0.00 0.00 0.00 10-990-576023 Norris Drive Culvert 0.00 0.00 927.75 -927.75 0.00 10-990-576025 Douglas Davis Stormwater 125,267.16 118,201.81 6,710.62 354.73 0.28 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-577047 SW & Lafayette XWalks 222,743.60 0.00 0.00 222,743.60 100.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 5,700.06 0.00 0.00 5,700.06 100.00 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 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)Page 41 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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-578063 Contingency 94,461.02 0.00 0.00 94,461.02 100.00 10-990-590071 Mo Blvd1400-1800 Block 0.00 0.00 0.00 0.00 0.00 10-990-599503 Organizational Review Study 150,000.00 79.75 145,000.00 4,920.25 3.28 10-990-599505 PD Elevator Replacement 200,000.00 200,000.00 0.00 0.00 0.00 10-990-599506 MSP Redevelopment 1,000,000.00 0.00 0.00 1,000,000.00 100.00 10-990-599507 Hyde Park Burn Bldg 1,500,000.00 411,619.24 1,088,380.76 0.00 0.00 10-990-599508 High Street Viaduct 1,077,827.75 129,655.00 98,000.00 850,172.75 78.88 10-990-599509 Private Prop Strmwtr Repair 200,000.00 0.00 0.00 200,000.00 100.00 10-990-599512 Street Resurfacing 276,509.44 276,501.00 0.00 8.44 0.00 E75 Capital Projects 8,701,449.16 1,139,833.80 1,750,902.88 5,810,712.48 66.78 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 9,626,449.16 1,314,833.80 1,750,902.88 6,560,712.48 68.153 Grand Total -9,626,449.16 -1,314,833.80 -1,750,902.88 -6,560,712.48 0.6815 990 Capital Projects 9,626,449.16 1,314,833.80 1,750,902.88 6,560,712.48 68.15 995 ARPA 10-995-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-995-502010 Social Security 0.00 0.00 0.00 0.00 0.00 10-995-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-995-502030 Retirement 0.00 0.00 0.00 0.00 0.00 10-995-502050 Life Insurance 0.00 0.00 0.00 0.00 0.00 10-995-502060 Long Term Disability 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 0.00 0.00 0.00 0.00 0.00 10-995-515010 Stormwater Materials 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 0.00 0.00 0.00 0.00 0.00 10-995-540060 Cemetery 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-995-599501 JCCVB Lost Revenue 0.00 0.00 0.00 0.00 0.00 10-995-599504 Lincoln-Hlth Science & Crisis 0.00 0.00 0.00 0.00 0.00 10-995-599511 United Cap City Soccer Complex 0.00 0.00 0.00 0.00 0.00 E65 Other Non-Operating Expenses 0.00 0.00 0.00 0.00 0.00 10-995-572010 Purchase of Vehicles 0.00 0.00 0.00 0.00 0.00 10-995-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-995-000508 High Street Viaduct 0.00 0.00 0.00 0.00 0.00 10-995-522022 Demo 0.00 0.00 0.00 0.00 0.00 10-995-575010 Police Renov & Upgrades 0.00 0.00 0.00 0.00 0.00 10-995-576007 Stormwater Improvements 0.00 0.00 0.00 0.00 0.00 10-995-599502 Downtown Beautification-Match 0.00 0.00 0.00 0.00 0.00 10-995-599503 Organizational Review Study 0.00 0.00 0.00 0.00 0.00 10-995-599505 PD Elevator Replacement 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)Page 42 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-995-599506 MSP Redevelopment 0.00 0.00 0.00 0.00 0.00 10-995-599507 Hyde Park Burn Bldg 0.00 0.00 0.00 0.00 0.00 10-995-599508 High Street Viaduct 0.00 0.00 0.00 0.00 0.00 10-995-599509 Private Prop Strmwtr Repair 0.00 0.00 0.00 0.00 0.00 10-995-599510 Demolitions 0.00 0.00 0.00 0.00 0.00 10-995-599512 Street Resurfacing 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 0.00 0.00 0.00 0.00 0.00 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 0.00 0.00 0.00 0.00 0 Grand Total 0.00 0.00 0.00 0.00 0 995 ARPA 0.00 0.00 0.00 0.00 0.00 Expense Expense 64,307,771.41 30,513,189.52 2,112,698.50 31,681,883.39 49.27 Revenue Total 0.00 0.00 0.00 0.00 0 Expense Total 64,307,771.41 30,513,189.52 2,112,698.50 31,681,883.39 49.266 Grand Total -64,307,771.41 -30,513,189.52 -2,112,698.50 -31,681,883.39 0.4927 GL - Trial Balance by Acct Type and Full Acct Number (08/16/2023 - 02:42 PM)Page 43 CITY OF JEFFERSON FISCAL YEAR 2022 - 2023 ESTIMATED FUND BALANCE FYE2022 UNASSIGNED FUND BALANCE - AUDITED 8,195,657.00$ Reappropriations from FY2022 to FY2023 Repair & Repaint Recycling Bins (9,615.52)$ Ammunition and Firearms Supplies (13,136.25)$ Remainder of Evergreen Study Funds - Ordinance 16210 (9,500.00)$ Remainder of Capitol Ave Demo & Acquisition Funds - Ordinance 16216 (451,560.76)$ Finance Color Printer - ordered in FY22 and not received (4,210.45)$ Remaining Mo American Water grant funds - received in advance (2,400.00)$ Remainder of Demo Funds - Ordinance 16145 (63,433.60)$ Contractual obligation from Allied contract (18,000.00)$ Future Fire Stations (6,000.00)$ Fire Station 4 Rehab (992.53)$ Downtown Streetscape (800.00)$ Ongoing Infrastructure/Facility Needs (5,700.06)$ MSP - EDA Grant matching portion (1,599,595.00)$ (2,184,944.17)$ 2023 Adjustments/Supplementals (Does not include other "Reserve" accounts as they are not "Unassigned" fund balance) Bill 2023-026; Ordinance 16359 - Supplemental for Air Service Guarantee Participation Agreement (50,000.00)$ Bill 2023-033; Ordinance 16370 - Supplemental for PD Recruitment & Marketing Campaign (50,000.00)$ PENDING - Potential Supplemental for Self-Funded Health Insurance - (current shortage)(1,425,307.35)$ PENDING - Potential Supplemental for Contract Obligations (153,784.95)$ ** PENDING - Potential Supplemental for Insurance Deductible expenses - (current shortage)(67,015.90)$ ** PENDING - Potential Supplemental for Building & Grounds Maintenance expenses - (current shortage)(27,636.79)$ ** PENDING - Potential Supplemental for Vehicle Leasing expenses - (estimated FYE shortage)(80,103.96)$ ** PENDING - Potential Supplemental for PD Building & Grounds Maint expenses - (current shortage)(63,821.80)$ ** PENDING - Potential Supplemental for PPS-Planning Salary Issues - (estimated FYE shortage)(65,013.96)$ ** (1,982,684.71)$ FYE2023 ESTIMATED Unassigned Fund Balance 4,028,028.12$ FYE2023 ESTIMATED Fund Balance % of Adopted Budget 10.60% 17% of FY2023 Adopted Budget ($37,996,179) = $6,459,350 IMPORTANT NOTE: Fund Balance figures do not make allowance for the following: **Staff believes a substantial portion of this item can be covered by unexpended existing budget authority within the General Fund. The exact amount that can be covered cannot be determined until FYE. Any potential revenue overages at FYE - in many cases the final revenue receipts don’t come in until 2 months after the close of our fiscal year (Ex: sales tax) Any potential expense savings at FYE - we would not know this figure until all expenses are in, by which time we are already into the new fiscal year. This figure is difficult to monitor, because grant expenses are put into the budget as soon as the grant is awarded and the expenses may not all be used in the current year but reappropriated to future years. Any change in committed/restricted/assigned at FYE from prior fiscal year to current fiscal year. If all items can be covered by the unexpended budget authority, the Estimated Fund Balance % would be 11.80%. 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 1,299.22 8/2022 interest Received (7,393.75) CK# 1028 Jul-22 8/20/22 112,285.35 47,159.85 62,879.80 2,431.68 9/2022 interest Received (2,031.25) CK# 1029 Aug-22 9/20/22 110,542.82 46,427.98 61,903.98 4,959.09 10/2022 Interest Received Sep-22 10/31/22 124,544.26 52,308.59 69,744.79 4,828.29 11/2022 Interest Received Oct-22 11/20/22 173,804.06 72,997.71 97,330.27 5,069.47 12/2022 Interest Received (7.18) 12/2022 service charge Nov-22 12/20/22 134,581.30 56,524.15 75,365.53 5,102.62 1/2023 Interest Received (7.18) 1/2023 service charge Dec-22 1/31/23 99,593.29 41,829.18 55,772.24 6,145.14 2/2023 Interest Received (7.18) 2/2023 service charge (17,745.34) CK# 1030 (4,245.00) CK# 1031 Jan-23 2/20/23 117,576.18 49,382.00 65,842.66 6,924.27 3/2023 Interest Received (7.36) 3/2023 service charge Feb-23 3/20/23 121,817.95 51,163.54 68,218.05 6,761.54 4/2023 Interest Received (7.18) 4/2023 service charge Mar-23 4/30/23 164,645.31 69,151.03 92,201.37 7,045.91 5/2023 Interest Received (7.18) 5/2023 service charge (6,120.00) CK# 1032 Apr-23 5/20/23 141,973.70 59,628.95 79,505.27 6,892.18 6/2023 Interest Received (7.27) 6/2023 service charge (2,625.00) CK# 1033 May-23 6/20/23 180,717.59 75,901.39 101,201.85 7,204.40 7/2023 Interest Received (7.27) 7/2023 service charge Jun-23 7/31/23 122,630.91 51,504.98 68,673.31 Total 14,786,328.45 6,210,257.95 8,601,365.66 Tax Period Due Date to City Total Lodging Tax JCCVB (3/7) JCCVB/Tourism Fund (4/7)** average monthly amount for 4 cent lockbox fund 56,328.87$ **Effective for 25 years starting May 1, 2011 2023 Occupancy 2022 Occupancy 2021 Occupancy 2020 Occupancy 2019 Occupancy 2018 Occupancy 2017 Occupancy January 38.50%35.70%37.70%47.30%49.40%48.10%48.70% February 45.20%42.10%37.80%55.50%58.00%53.40%56.80% March 56.50%50.40%48.20%41.60%58.00%57.60%62.20% April 51.40%56.80%55.10%34.90%63.10%61.70%62.40% May 57.60%55.30%52.90%42.10%60.90%64.60%63.80% June 47.30%49.50%54.20%55.00%60.50%63.20%70.40% July 43.20%47.70%53.40%58.80%60.30%65.90% August 43.40%43.80%46.20%59.00%56.80%61.50% September 54.40%48.20%48.20%63.40%59.90%64.50% October 55.70%51.60%45.30%63.80%65.60%66.50% November 45.30%43.50%34.60%50.30%54.80%51.50% December 34.10%32.60%30.30%44.90%46.00%40.80% COMPARATIVE OCCUPANCY RATE Tab 2 - Multi-Segment Currency: USD - US Dollar Missouri Hotel & Lodging Association For the month of: June 2023 Percent Change from June 2022 Percent Change from YTD 2022 2023 2022 2023 2022 2023 2022 Occ ADR RevPAR Room Rev Room Avail Room Sold 2023 2022 2023 2022 2023 2022 Occ ADR RevPAR Room Rev Room Avail Room Sold Census Sample Census Sample United States 69.7 69.9 158.40 154.81 110.33 108.23 -0.4 2.3 1.9 2.2 0.3 -0.1 62.9 61.4 154.45 145.40 97.08 89.33 2.3 6.2 8.7 9.0 0.3 2.6 63465 37293 5622314 4250804 West North Central 68.0 67.1 124.83 117.99 84.91 79.20 1.3 5.8 7.2 7.1 -0.1 1.2 54.6 52.6 112.37 105.01 61.38 55.27 3.8 7.0 11.1 11.0 -0.1 3.7 5147 3035 386428 290246 Missouri 66.7 66.1 124.77 119.32 83.28 78.87 1.0 4.6 5.6 5.2 -0.4 0.6 56.0 54.1 117.64 109.65 65.89 59.28 3.6 7.3 11.2 10.6 -0.5 3.0 1249 730 108332 80467 Kansas City, MO 70.6 69.2 126.71 119.00 89.48 82.35 2.1 6.5 8.7 7.5 -1.1 0.9 61.5 57.5 123.33 112.39 75.81 64.68 6.8 9.7 17.2 16.2 -0.9 5.9 329 272 35294 32237 Saint Louis, MO 69.4 67.6 132.92 126.32 92.20 85.43 2.6 5.2 7.9 7.1 -0.8 1.8 58.6 56.5 122.64 113.79 71.87 64.35 3.6 7.8 11.7 11.7 -0.0 3.6 375 276 41334 35333 Columbia, MO+66.8 66.5 103.38 102.46 69.10 68.14 0.5 0.9 1.4 1.4 -0.1 0.5 58.6 56.7 107.65 101.39 63.05 57.46 3.4 6.2 9.7 9.7 -0.0 3.3 38 31 3882 3334 Jefferson City, MO+47.3 49.5 107.21 103.67 50.73 51.33 -4.4 3.4 -1.2 -1.2 0.0 -4.4 49.4 48.0 109.49 103.77 54.14 49.80 3.0 5.5 8.7 8.7 0.0 3.0 16 14 1513 1391 Springfield, MO 66.9 70.4 102.95 100.55 68.87 70.77 -5.0 2.4 -2.7 -2.7 0.0 -4.9 58.3 61.4 101.54 97.26 59.17 59.70 -5.1 4.4 -0.9 -0.3 0.6 -4.5 74 53 6601 5075 Branson, MO 64.0 61.3 139.72 137.85 89.35 84.51 4.3 1.4 5.7 4.3 -1.3 2.9 47.4 43.3 121.33 119.79 57.52 51.91 9.4 1.3 10.8 5.7 -4.6 4.4 169 41 13812 5014 Lake of the Ozarks+67.9 69.5 140.48 133.36 95.34 92.70 -2.4 5.3 2.9 2.9 0.1 -2.3 53.7 50.8 121.35 114.34 65.13 58.12 5.6 6.1 12.0 12.1 0.0 5.6 43 7 2839 889 Joplin, MO 63.1 68.1 98.83 97.56 62.32 66.41 -7.4 1.3 -6.2 -6.2 0.0 -7.4 53.5 56.4 96.12 91.67 51.39 51.75 -5.3 4.9 -0.7 -1.9 -1.2 -6.4 35 25 2584 2175 Saint Joseph, MO+82.1 78.5 117.66 111.45 96.65 87.44 4.7 5.6 10.5 10.5 0.0 4.7 65.6 67.6 112.42 100.69 73.78 68.11 -3.0 11.7 8.3 8.2 -0.1 -3.1 11 8 991 786 Independence, MO+62.9 67.2 105.58 95.97 66.41 64.45 -6.3 10.0 3.0 3.0 0.0 -6.3 53.7 55.5 99.31 92.23 53.33 51.14 -3.2 7.7 4.3 4.3 0.0 -3.2 21 15 1628 1422 A blank row indicates insufficient data. Rooms Participation PropertiesADRRevPARADR Current Month - June 2023 vs June 2022 Occ % 2023 © 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: 2023 STR, LLC / STR Global, Ltd. trading as "STR". Year to Date - June 2023 vs June 2022 Occ %RevPAR