Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Information 12-19-2022
Information cty of I Elk -�-�=1 River To: Ma�Tor and CinT Council From: Lori Stich, Assistant Finance Director Date: December 19, 2022 SubjeCt: November 2022 Monthly Financial Report Memorandum This report is designed to provide summaryT information regarding the overall level of revenues and expenditures in the General Fund, the Multipurpose Facility Special Revenue Fund, and the Enterprise Funds. These funds provide an important picture of the cit�-'s financial health. For the month of November, actual revenues (excluding propert�T taxes and transfers in) and expenditures should run about 92% of the annual budget. It is natural for some of the items to var�T from month to month, such as exceeding budget for Supplies but being below budget for Services. This is not considered serious as long as the total expenditure budget amount is not oveYspent. Significant variances from budget are highlighted below accompanied `vith a general discussion for the variance. GENERAL FUND Revenues: ■ The second half property taxes were received at the end of November. ■ License & permit collecrions aYe at 106% of budget estimates with November collections consisting primarily of building-related permits and business license rene`vals. ■ InteYgovernmental revenues aYe at about 103% of the estimated budget amount with November collections consisting of the state crime prevention grant. ■ Charges for services are about 106% of estimates �vith plan check fees and recreation fees making up the majorinr of collections in November. ■ Court fines which lag a month are about 90% of budget estimates including October collections received byT the count�T. ■ Transfers in consist of ERIVIU's 4% October electric revenues. Expenditures: ■ Total departmental expenditures are about 86% of budget and most departments are within oY below budget estimates. 2022 Monthly Expenditures Szo,000 Sis,000 Si6,000 o Si4,000 z N $12,000 O $10,000 _ ~ $8,000 � $ 6, 000 $4,000 $ 2, 000 $� Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec �Actual $1,033 $2,333 $3,823 $5,548 $6,916 $8,361 $9,802 $11,218 $13,149 $14,901 $16,277 Budget $1,576 $3,152 $4,728 $6,305 $7,881 $9,457 $11,033 $12,609 $14,185 $15,761 $17,338 $18,914 MULTIPURPOSE FACILITY Through the end of November, revenues of �1,646,848 exceed expenditures of $1,282,504 b�T $364,344. American Rescue Plan Act funds in the amount of �655,000 `vere transferred in to offset the revenue lost during the COVID shutdo`vn. The remaining November revenues consist of ice rental, facilityT rentals, advertising, and sponsorships while expenditures are primarilyT attributable to personal services, utilities and maintenance. ATTAC H M ENTS ■ General Fund Revenue & Expense Report ■ Multipurpose Facilit�T — Budget to Actual ■ EnteYprise Funds — Budget to Actual ■ Cash Report — All Funds 12-14-2022 11:38 AM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2022 101-GENERAL FUND FINANCIAL SUMMARY 91.67o OF YEAR COMPLETED CURRENT CURRENT YEAR TO DATE o OF BUDGET PRIOR FY BUDGET PERIOD ACTUAL BUDGET BALANCE YTD BALANCE REVENUE SUMMARY General Fund 18,913,650.00 6,304,923.25 18,406,896.72 97.32 506,753.28 11,573,185.22 TOTAL REVENUES 18,913,650.00 6,304,923.25 18,406,896.72 97.32 506,753.28 11,573,185.22 EXPENDITURE SUMMARY General Government City Council Communications Administrative Services Human Resources Elections Finance Information Technology Legal Community Development Planning Building Maintenance Contingency TOTAL General Government Public Safety Police Administration Patrol Investigations Police Support Services Police Reserves Public safety building Fire Administration Fire Operations Emergency Management Building Safety Code Enforcement Environmental TOTAL Public Safety Public Works Street Maintenance Snow Removal Equipment Services Engineering TOTAL Public Works 189,250.00 4,901.78 173,452.87 91.65 15,797.13 154,879.57 412,750.00 31,072.34 325,636.65 78.89 87,113.35 291,560.13 618,500.00 48,735.88 538,902.61 87.13 79,597.39 534,086.53 376,600.00 44,814.43 335,947.72 89.21 40,652.28 292,286.75 48,700.00 1,477.76 26,447.30 54.31 22,252.70 6,300.00 686,150.00 45,962.50 614,290.88 89.53 71,859.12 565,721.74 542,550.00 34,847.38 446,941.56 82.38 95,608.44 397,189.93 255,000.00 29,130.05 223,127.58 87.50 31,872.42 201,950.99 213,500.00 13,446.21 185,797.42 87.02 27,702.58 189,193.13 388,100.00 16,891.64 250,447.13 64.53 137,652.87 324,341.30 931,250.00 84,281.22 814,004.38 87.41 117,245.62 722,314.61 0.00 0.00 0.00 0.00 0.00 0.00 4,662,350.00 355,561.19 3,934,996.10 84.40 727,353.90 3,679,824.68 994,200.00 56,806.13 985,356.69 99.11 8,843.31 886,320.62 3,445,600.00 244,394.43 2,824,749.97 81.98 620,850.03 2,607,971.82 1,306,250.00 98,796.95 1,094,004.31 83.75 212,245.69 999,854.71 868,200.00 50,585.04 656,920.74 75.66 211,279.26 626,264.36 16,250.00 0.00 5,022.59 30.91 11,227.41 3,734.71 158,100.00 10,593.96 187,310.66 118.48 ( 29,210.66) 155,983.98 1,097,600.00 65,893.12 1,085,446.71 98.89 12,153.29 945,097.17 483,350.00 33,172.72 418,952.43 86.68 64,397.57 367,346.43 30,250.00 700.13 14,594.51 48.25 15,655.49 19,510.95 548,650.00 40,485.45 551,403.59 100.50 ( 2,753.59) 435,765.55 94,200.00 7,441.12 65,997.77 70.06 28,202.23 76,236.00 62,500.00 8,161.08 92,977.31 148.76 ( 30,477.31) 51,068.42 9,105,150.00 617,030.13 7,982,737.28 87.67 1,122,412.72 7,175,154.72 1,429,500.00 139,113.26 1,243,903.58 87.02 185,596.42 1,269,766.67 338,000.00 14,550.91 237,268.83 70.20 100,731.17 248,031.07 362,800.00 31,434.24 316,272.43 87.18 46,527.57 216,469.14 493,450.00 32,144.67 372,234.19 75.44 121,215.81 351,454.81 2,623,750.00 217,243.08 2,169,679.03 82.69 454,070.97 2,085,721.69 12-14-2022 11:38 AM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2022 101-GENERAL FUND FINANCIAL SUMMARY Culture & Recreation Parks Department Parks & Rec Admin Recreation Programs Farmers Market Sr Citizen Programs TOTAL Culture & Recreation Economic Development Economic Development Energy City TOTAL Economic Development General Transfers Out TOTAL General TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES CURRENT CURRENT BUDGET PERIOD 91.67o OF YEAR COMPLETED YEAR TO DATE o OF BUDGET PRIOR FY ACTUAL BUDGET BALANCE YTD BALANCE 1,548,700.00 139,604.72 1,338,844.04 86.45 209,855.96 1,206,929.88 621,000.00 41,982.84 549,133.37 88.43 71,866.63 476,032.96 171,300.00 3,081.74 95,927.03 56.00 75,372.97 82,395.27 8,750.00 107.94 44,513.58 508.73 ( 35,763.58) 15,773.40 133,950.00 9,535.11 119,167.49 88.96 14,782.51 116,847.10 2,483,700.00 194,312.35 2,147,585.51 86.47 336,114.49 1,897,978.61 0.00 ( 10,908.57) 20,167.76 0.00 ( 20,167.76) 40,475.98 38,700.00 1,944.04 21,611.83 55.84 17,088.17 21,312.19 38,700.00 ( 8,964.53) 41,779.59 107.96 ( 3,079.59) 61,788.17 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 18,913,650.00 1,375,182.22 16,276,777.51 86.06 2,636,872.49 14,900,467.87 0.00 4,929,741.03 2,130,119.21 ( 2,130,119.21)( 3,327,282.65) 12-14-2022 11:38 AM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2022 101-GENERAL FUND 91.67o OF YEAR COMPLETED CURRENT CURRENT YEAR TO DATE o OF BUDGET PRIOR FY REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE YTD BALANCE General Fund raxes 101-3-0000-3111 Current Ad Valorem Taxes 101-3-0000-3112 Delinquent Ad Valorem Taxes 101-3-0000-3121 Gravel Tax 101-3-0000-3131 Penalties/Interest 101-3-0000-3132 Tax Forfeited Land Sale TOTAL Taxes Licenses & Permits 101-3-0000-3211 Liquor License 101-3-0000-3212 THC License 101-3-0000-3213 Cigarette License 101-3-0000-3214 Rental License 101-3-0000-3216 Mining License 101-3-0000-3217 Garbage Hauler License 101-3-0000-3218 Other Business License/Permit 101-3-0000-3229 NPDES Permit 101-3-0000-3231 Building Permit 101-3-0000-3232 Plumbing/Heating Permit 101-3-0000-3233 Permit Surcharge 101-3-0000-3235 Animal License 101-3-0000-3237 Other Non-Business Lic/Permit TOTAL Licenses & Permits Intergovernmental Rev 101-3-0000-3311 Federal Grant 101-3-0000-3322 MV Credit 101-3-0000-3323 Fire State Aid 101-3-0000-3324 PERA Aid 101-3-0000-3325 Police 2o Aid 101-3-0000-3326 Police Training Reimb 101-3-0000-3329 State Crime Prevention Grant 101-3-0000-3330 Other State Grants 101-3-0000-3341 County Reimb/Grant TOTAL Intergovernmental Rev Charges for Services 101-3-0000-3412 Planning & Zoning Fees 101-3-0000-3413 Plan Check Fee 101-3-0000-3415 Special Assessment Search 101-3-0000-3417 Copies 101-3-0000-3418 Other General Govt Services 101-3-0000-3430 Lockout Fees 101-3-0000-3431 Police Services 101-3-0000-3432 School Liaison 13,109,300.00 6,097,520.69 12,830,956.14 97.88 278,343.86 6,468,789.85 0.00 ( 10,522.79) 29,461.35 0.00 ( 29,461.35) 31,598.70 180,000.00 0.00 138,985.74 77.21 41,014.26 178,540.54 0.00 2,109.45 3,618.22 0.00 ( 3,618.22) 2,622.32 0.00 0.00 0.00 0.00 0.00 0.00 13,289,300.00 6,089,107.35 13,003,021.45 97.85 286,278.55 6,681,551.41 76,000.00 0.00 3,000.00 65,000.00 26,000.00 2,000.00 16,000.00 22,000.00 500,000.00 140,000.00 700.00 ( 0.00 15,000.00 865,700.00 100.00 0.00 2,250.00 3,210.00 0.00 0.00 4,575.00 525.00 19,244.45 11,287.03 192.64) 0.00 700.00 41,698.84 81,990.00 0.00 2,350.00 56,125.00 26,107.70 125.00 17,010.00 15,604.51 502,491.30 184,864.31 1,943.20 460.00 28,726.62 917,797.64 107.88 ( 5,990.00) 70,795.00 0.00 0.00 0.00 78.33 650.00 4,161.25 86.35 8,875.00 58,533.00 100.41 ( 107.70) 25,849.37 6.25 1,875.00 420.00 106.31 ( 1,010.00) 14,705.00 70.93 6,395.49 23,100.00 100.50 ( 2,491.30) 567,602.39 132.05 ( 44,864.31) 182,763.46 277.60 ( 1,243.20) 2,553.51 0.00 ( 460.00) 450.00 191.51 ( 13,726.62) 23,700.00 106.02 ( 52,097.64) 974,632.98 0.00 6,000.00 215,000.00 0.00 315,000.00 32,000.00 55,000.00 0.00 0.00 623,000.00 25,000.00 250,000.00 500.00 1,500.00 500.00 5,500.00 18,000.00 162,000.00 0.00 0.00 0.00 0.00 0.00 0.00 7,421.79 0.00 0.00 7,421.79 2,027.50 7,855.00 60.00 2.34 0.00 260.00 2,500.00 0.00 1,375.32 0.00 ( 1,375.32) 0.00 2,947.25 49.12 3,052.75 2,877.79 255,657.77 118.91 ( 40,657.77) 218,908.66 0.00 0.00 0.00 0.00 320,525.85 101.75 ( 5,525.85) 276,543.13 33,488.96 104.65 ( 1,488.96) 38,002.19 27,581.65 50.15 27,418.35 33,524.37 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 641,576.80 102.98 ( 18,576.80) 569,856.14 25,467.50 101.87 ( 467.50) 32,788.00 231,005.95 92.40 18,994.05 270,435.63 330.00 66.00 170.00 1,220.00 883.16 58.88 616.84 1,389.84 13.00 2.60 487.00 0.00 3,145.00 57.18 2,355.00 3,500.00 30,150.00 167.50 ( 12,150.00) 50,133.53 173,863.27 107.32 ( 11,863.27) 155,077.50 12-14-2022 11:38 AM CITY OF ELK RIVER PAGE: 4 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2022 101-GENERAL FUND 91.67o OF YEAR COMPLETED CURRENT CURRENT YEAR TO DATE o OF BUDGET PRIOR FY REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE YTD BALANCE 101-3-0000-3434 Animal Impound Fee 101-3-0000-3436 Fire Contracts 101-3-0000-3437 Fire Services 101-3-0000-3438 Fire Inspections 101-3-0000-3450 Maintenance Facility Rent 101-3-0000-3451 Street Services 101-3-0000-3452 Engineering Services Reimb 101-3-0000-3461 Recreation Fees 101-3-0000-3462 Sr Center Activities 101-3-0000-3463 Farmer's Market 101-3-0000-3469 Elk RiverFest 101-3-0000-3472 Park Use Fee 101-3-0000-3475 Building Rent 101-3-0000-3483 Sewer Inspection Fee 101-3-0000-3484 Contractor License Check TOTAL Charges for Services 1,000.00 335,000.00 6,000.00 0.00 0.00 25,000.00 20,000.00 60,000.00 35,000.00 ( 15,000.00 19,000.00 25,000.00 0.00 13,000.00 1,000.00 1,018,000.00 50.00 0.00 0.00 0.00 0.00 1,035.00 0.00 155.00 42.00) 226.00 0.00 5,827.00 0.00 780.00 50.00 20,785.84 625.00 380,316.61 1,393.50 0.00 0.00 18,542.50 12,375.08 42,353.96 30,678.50 50,381.00 20,845.00 40,255.32 0.00 14,540.00 1,065.00 1,078,229.35 62.50 375.00 250.00 113.53 ( 45,316.61) 289,661.96 23.23 4,606.50 0.00 0.00 0.00 0.00 0.00 0.00 0.00 74.17 6,457.50 21,070.66 61.88 7,624.92 14,793.17 70.59 17,646.04 31,495.00 87.65 4,321.50 29,830.00 335.87 ( 35,381.00) 21,839.01 109.71 ( 1,845.00) 20,422.00 161.02 ( 15,255.32) 27,127.79 0.00 0.00 0.00 111.85 ( 1,540.00) 17,125.00 106.50 ( 65.00) 1,205.00 105.92 ( 60,229.35) 989,364.09 Fines & Forfeits 101-3-0000-3510 Court Fines 101-3-0000-3511 Parking Fines 101-3-0000-3512 Ordinance Violations TOTAL Fines & Forfeits Special Assessments 101-3-0000-3610 Special Assmts-County TOTAL Special Assessments 120,000.00 9,252.10 106,482.26 88.74 13,517.74 108,867.34 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 2,000.00 0.00 ( 2,000.00) 2,000.00 120,000.00 9,252.10 108,482.26 90.40 11,517.74 110,867.34 0.00 6,205.17 �,205.17 0.00 ( 6,205.17) 0.00 0.00 6,205.17 6,205.17 0.00 ( 6,205.17) 0.00 Other Revenue 101-3-0000-3621 Interest Income 100,000.00 0.00 108,402.39 108.40 ( 8,402.39) 103,855.97 101-3-0000-3625 Refunds & Reimbursements 130,000.00 0.00 2,061.16 1.59 127,938.84 20,412.10 101-3-0000-3626 Contributions 20,000.00 0.00 24,811.06 124.06 ( 4,811.06) 19,000.00 101-3-0000-3629 Miscellaneous Revenue 10,000.00 1,580.22 11,611.38 116.11 ( 1,611.38) 13,827.66 TOTAL Other Revenue 260,000.00 1,580.22 146,885.99 56.49 113,114.01 157,095.73 Transfers In 101-3-0000-3921 Transfers 101-3-0000-3924 Transfer - MPF 101-3-0000-3925 Transfer-Landfill 101-3-0000-3926 Transfer-Capital Outlay Resery 101-3-0000-3929 Transfer-GRE Reserve 101-3-0000-3930 Transfer-Development 101-3-0000-3942 Transfer-WGSTS 101-3-0000-3943 Transfer-Liquor 101-3-0000-3944 Transfer-Garbage 101-3-0000-3945 Transfer-Utilities 101-3-0000-3946 Transfer-Stormwater 101-3-0000-3948 Transfer-EDA 101-3-0000-3949 Transfer-HRA TOTAL Transfers In 0.00 0.00 1,656.17 0.00 ( 1,656.17) 460.00 140,000.00 0.00 0.00 0.00 140,000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 50,000.00 0.00 50,000.00 100.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 10,650.00 0.00 10,650.00 100.00 0.00 10,600.00 165,000.00 0.00 165,000.00 100.00 0.00 160,000.00 750,000.00 0.00 750,000.00 100.00 0.00 500,000.00 54,000.00 0.00 54,000.00 100.00 0.00 52,000.00 1,355,000.00 128,871.94 1,260,391.89 93.02 94,608.11 1,162,857.53 135,000.00 0.00 135,000.00 100.00 0.00 121,000.00 43,000.00 0.00 43,000.00 100.00 0.00 41,000.00 35,000.00 0.00 35,000.00 100.00 0.00 41,900.00 2,737,650.00 128,871.94 2,504,698.06 91.49 232,951.94 2,089,817.53 TOTAL General Fund 18,913,650.00 6,304,923.25 18,406,896.72 97.32 506,753.28 11,573,185.22 CITY OF ELK RIVER MULTIPURPOSE FACILITY - BUDGET TO ACTUAL MONTH ENDED NOVEMBER, 2022 Revenues: Ice Rental Admissions Dry Floor Events/Craft Shows Facility Rental Advertising/Naming Rights/Sponsorships Recreation fees (Skating/Hockey) Concessions/vending Other Revenues (interest, etc.) Transfer In (ARPA funds) Total Revenues Operating expenses: Personal services Supplies Service charges Capital Outlay Transfers Out Total Expenditures Revenues over/(under) expenditures Current Year to Date % of Budget Actual Budget $640,000 30,000 17, 000 550,000 153,000 117,000 30,000 11, 200 0 $1,548,200 $851,900 55,500 374,700 20,000 140,000 $1,442,100 $106,100 $465,087 13,338 6,740 166,906 161,683 154, 233 18,978 4,884 655,000 $1, 646, 848 $ 697, 343 96,766 488,395 0 0 $1, 282, 504 $ 364, 344 72.67 % 44.46 % 39.65 % 30.35 % 105.68% 131.82 % 63.26% 43.61 % 106.37 % 81.86 % 174.35 % 130.34% 0.00% 0.00% 88.93 % $1, 800,000 $1, 600,000 $1,400,000 $1, 200,000 $1,000,000 $800,000 $600,000 $400,000 $200,000 $0 FTCenter November 2022 Actual $1,646,848 Budget, $1,548,2 � TotalRevenues TotalExpenditures Budget, $1,442,100Actual IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII $1,282,504 CITY OF ELK RIVER ENTERPRISE FUNDS - BUDGET TO ACTUAL MONTH ENDED NOVEMBER, 2022 Sales and cost of sales: Sales Cost of sales Gross proft Opereting revenues: User charges Delinquency collections Other Total operating revenues Opereting expenses: Personal services Supplies Other service charges Depreciation * Total operating expenses Opereting income (loss) Nonoperetingrevenues�expenses): Interest income Interestexpense/agentfees Total nonoperating revenues (expenses) Income (loss) before contributions & trensfers Contributions - connection fees Transfers out NETINCOME (LOSS) Items reclassified to balance sheet at year end: Capital Outlay Bond Payment (Payoff 2014B Refunded Debt) Revenues over/�under) expenditures Liq�4r - Sewer . Garbage - SYcrrmwat�±r- Current Year to �Date % of Current Year to Date�� % of Current Year to Date % of � Current �� Year to Date % of � Budget Actual Budget Budget Actual Budget Budget Actual Budget Budget Actual Budget $ 7,901,000 $ 7,592,027 96.09% 5,636,000 5,399,915 95.81% 2,265,000 2,192,112 9678% - - - $ 2,45Q000 $ 2,036,594 83.13% $ 1,831,000 $ 1,571,790 85.84% $ 595,000 $ 507,325 8526% - - - 500 1,277 255.40% - 2,826 - - 234 - 9,000 3,630 40.33% 175,000 154,189 88.11% 9,000 3,630 40.33% 2,625,500 2,192,060 83.49% 1,831,000 1,574,617 86.00% 595,000 507,559 85.30% 1,044,800 921,374 88.19% 761,300 666,800 87.59% 34,800 34,627 99.50% - - - 26,600 19,653 73.89% 279,500 249,921 89.42% 21,400 8,010 37.43% 1,000 48 4.80% 367,050 31Q876 8470% 803,350 697,506 86.82% 1,621,250 1,344,397 82.92% 529,450 149,273 28.19% 99,000 0.00% 1,64Q000 0.00% 465,000 0.00% 1,537,450 1,251,903 81.43% 3,484,150 1,614,227 46.33% 1,677,450 1,387,035 82.69% 995,450 149,321 15.00% 736 550 943 839 128.14% (858,650) 577,833 -67.30% 153,550 187,582 122.16% 400 450 358 238 -89.46% SQ000 61,797 7725% 10Q000 116,774 11677% 5,000 8,460 169.19% 1Q000 22,435 224.35% (158,650) (71,871) 45.30% SQ000 61,797 7725% (58,650) 44,903 -76.56% 5,000 8,460 169.19% 1Q000 22,435 224.35% 816,550 1,005,637 123.16% (917,300) 622,736 -67.89% 158,550 196,042 123.65% (390,450) 380,673 -97.50% - - - SOQ000 1,821,062 36421% - - - - - - (1,OOQ000) (1,OOQ000) 100.00% (165,000) (165,000) 100.00% (54,000) (54,000) 100.00% (135,000) (135,000) 100.00% 183 450 5 637 3.07% (582,300) 2,278,798 391.34% 104,550 142,042 135.86% 525 450 245 673 -46.75% (10Q000) (230) - (46Q000) (59,035) - - - - - - - - - - (45Q000) Q,49Q000) - - - - - - - (283,450) 5,407 (1,492,300) (5,270,237) 104,550 142,042 (525,450) 245,673 Recorded at year-end 12-14-2022 11:42 AM CITY OF ELK RIVER PAGE: 1 POOLED CASH REPORT (FUND 999) AS OF: NOVEMBER 30TH, 2022 FUND ACCOUNT# ACCOUNT NAME CLAIM ON CASH 002-1010 Cash - Section 125 101-1010 Cash - General Fund 211-1010 Cash - Library 219-1010 Cash - Federal COVID Fund 221-1010 Cash - Multipurpose Facility 225-1010 Cash - Park Dedication 228-1010 Cash - Landfill 231-1010 Cash - Landfill Const Debris 240-1010 Cash - Micro Loan Fund 242-1010 Cash - State DEED 245-1010 Cash - Development Fund 290-1010 Cash - Capital Outlay Reserve 291-1010 Cash - Insurance Reserve 292-1010 Cash - Govt Bldgs Reserve 294-1010 Cash - Drug Forfeiture 295-1010 Cash - Severance Pay Reserve 296-1010 Cash - GRE Reserve 301-1010 Cash - 2020A GO CIP Bonds 302-1010 Cash - 2021A GO CIP BONDS 333-1010 Cash - 2020B (2010/2012) Bonds 343-1010 Cash - 2019A Sales Tax Bonds 401-1010 Cash - Pavement Mgmt 403-1010 Cash - Street Improvement 406-1010 Cash - City Wide Trunk Util 410-1010 Cash - Equipment Replacement 420-1010 Cash - Active ER 421-1010 Cash - PS Building/Fire Sta 3 440-1010 Cash - Park Improvement 462-1010 Cash - TIF #22 Downtown Redev 463-1010 Cash - TIF #23 Pref Powder 464-1010 Cash - TIF #24 Beaudry Truck 465-1010 Cash - TIF 25 Jackson Hills 602-1010 Cash - Wastewater Treatment 603-1010 Cash - Liquor 605-1010 Cash - Garbage 607-1010 Cash - Storm Water 801-1010 Cash - Interest 821-1010 Cash - Developer Escrow TOTAL CLAIM ON CASH CASH IN BANK - POOLED CASH 999-1000 A/P BANK ACCOUNTS 999-1001 PY BANK ACCOUNT 999-1002 POOLED INVESTMENTS SUBTOTAL CASH IN BANK - POOLED CASH BEGINNING CURRENT CURRENT BALANCE ACTIVITY BALANCE 10,295.53 1,438.24 11,733.77 5,803,060.77 4,932,273.37 10,735,334.14 223,404.18 28,048.06 251,452.24 2,777,163.51 ( 647,121.79) 2,130,041.72 ( 403,800.29) 572,475.95 168,675.66 1,615,071.82 ( 79,124.18) 1,535,947.64 178,593.44 7,935.96 186,529.40 820,883.79 0.00 820,883.79 953,788.30 10,917.31 964,705.61 387,828.67 2,838.43 390,667.10 269,185.38 45,306.20 314,491.58 1,787,880.27 ( 9,341.13) 1,778,539.14 39,959.46 ( 2,027.90) 37,931.56 4,046,480.31 2,499.64 4,048,979.95 41,059.06 34.84 41,093.90 80,200.65 0.00 80,200.65 851,088.18 ( 40,732.63) 810,355.55 4,234.08 0.00 4,234.08 1,452.85 0.00 1,452.85 817,646.52 279,726.12 1,097,372.64 5,425,267.10 346,732.42 5,771,999.52 6,702,373.31 22,727.98 6,725,101.29 548,465.54 ( 3,662.59) 544,802.95 2,661,637.10 41,335.22 2,702,972.32 1,421,868.45 14,480.36 1,436,348.81 1,463,873.06 ( 203,813.02) 1,260,060.04 961,622.19 ( 42,653.16) 918,969.03 255,726.37 1,000.00 256,726.37 0.00 87,484.84 87,484.84 7,211.39 51,672.96 58,884.35 0.00 3,642.20 3,642.20 7,447.25 34,711.23 42,158.48 9,129,614.54 103,639.06 9,233,253.60 4,297,468.19 31,876.08 4,329,344.27 664,784.77 21,285.48 686,070.25 1,712,930.69 19,152.86 1,732,083.55 0.00 94,107.04 94,107.04 1,005,645.99 ( 1,114.25) 1,004,531.74 56,571,412.42 5,727,751.20 62,299,163.62 187,368,988.39 7,031,180.40 194,400,168.79 (159,179,765.53)( 1,303,429.20)(160,483,194.73) 28,382,189.56 0.00 28,382,189.56 56,571,412.42 5,727,751.20 62,299,163.62