Loading...
Information 05-17-2021Information Memorandum To: Mayor and City Council From: Lori Stich, Assistant Finance Director Date: May 17, 2021 Subject: April 2021 Monthly Financial Report This report is designed to provide summary 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 city’s financial health. For the month of April, actual revenues (excluding property taxes and transfers in) and expenditures should run about 33% of the annual budget. It is natural for some of the items to vary 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 overspent. Significant variances from budget are highlighted below accompanied with a general discussion for the variance. GENERAL FUND Revenues:  Property taxes, our largest revenue source, will be received in July and December.  License & permit collections are about 36% of budget estimates consisting primarily of building-related permits and rental licenses.  Charges for services are about 32% of budget estimates with plan check fees, fire contracts and recreation fees making up the majority of April collections.  Transfers in consists of ERMU’s 4% March electric revenues, the remaining transfers in from other funds will be recorded mid-year. Expenditures:  Total departmental expenditures are about 29% of budget and most departments are within or below budget estimates. Jan 2021 Monthly Expenditures$ THOUSANDS $20,000$18,000$16,000$14,000$12,000$10,000$8,000$6,000$4,000$2,000$0$17,533$16,071$14,610$13,149$11,688$10,227$8,766$7,305$5,844$4,383$2,922$1,461Budget$5,009 $3,408$2,094$1,240ActualDecNovOctSepAugJulJunMayAprMarFeb MULTIPURPOSE FACILITY Through the end of April, expenditures of $387,772 exceed revenues of $332,776 by $54,996. The majority of April collections consist of ice rentals, while expenditures are primarily attributable to personal services and utilities. ATTACHMENTS  General Fund Revenue & Expense Report  Multipurpose Facility Revenue & Expense Report  Enterprise Funds – Budget to Actual  Cash Report – All Funds 5-11-2021 03:07 PM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2021 101-GENERAL FUND101-GENERAL FUND FINANCIAL SUMMARY 33.33% OF YEAR COMPLETED CURRENT CURRENT YEAR TO DATE % OF BUDGET PRIOR FY CURRENT CURRENT YEAR TO DATE % OF BUDGET PRIOR FY CURRENT CURRENT YEAR TO DATE % OF BUDGET PRIOR FY CURRENT CURRENT YEAR TO DATE % OF BUDGET PRIOR FY BUDGET PERIOD ACTUAL BUDGET BALANCE YTD BALANCE BUDGET PERIOD ACTUAL BUDGET BALANCE YTD BALANCE BUDGET PERIOD ACTUAL BUDGET BALANCE YTD BALANCE BUDGET PERIOD ACTUAL BUDGET BALANCE YTD BALANCE __________________________________________________________________________________________________________________________________ REVENUE SUMMARY General Fund 17,532,500.00 301,685.50 934,029.22 5.3316,598,470.78 854,364.90 TOTAL REVENUES 17,532,500.00 301,685.50 934,029.22 5.33 16,598,470.78 854,364.90 ============= ============= ============= ======= ============= ============= EXPENDITURE SUMMARY General Government City Council 173,200.00 4,512.64 42,230.00 24.38 130,970.00 45,629.40 Communications 336,000.00 35,258.24 96,645.66 28.76 239,354.34 75,707.22 Administrative Services 593,150.00 66,112.47 181,077.89 30.53 412,072.11 159,568.07 Human Resources 355,750.00 32,736.49 81,237.78 22.84 274,512.22 79,589.81 Elections 6,800.00 0.00 6,300.00 92.65 500.00 32,534.46 Finance 655,800.00 63,783.21 178,743.25 27.26 477,056.75 227,563.46 Information Technology 489,800.00 41,014.13 140,696.40 28.73 349,103.60 124,770.05 Legal 255,000.00 22,811.13 53,921.15 21.15 201,078.85 68,444.83 Community Development 209,500.00 19,555.01 88,616.74 42.30 120,883.26 83,696.64 Planning 364,150.00 39,766.24 112,161.03 30.80 251,988.97 98,011.95 Building Maintenance 788,500.00 86,813.97 256,049.26 32.47 532,450.74 219,557.68 TOTAL General Government 4,227,650.00 412,363.53 1,237,679.16 29.28 2,989,970.84 1,215,073.57 Public Safety Police Administration 925,200.00 74,049.41 342,009.69 36.97 583,190.31 321,153.22 Patrol 3,274,300.00 308,296.90 858,345.75 26.21 2,415,954.25 769,928.01 Investigations 1,238,700.00 127,997.92 348,595.37 28.14 890,104.63 267,096.69 Police Support Services 834,550.00 79,167.20 213,538.36 25.59 621,011.64 194,656.07 Police Reserves 16,750.00 157.40 1,708.46 10.20 15,041.54 570.03 Public safety building 160,600.00 8,923.22 54,643.32 34.02 105,956.68 44,227.30 Fire Administration 981,700.00 79,977.84 248,166.20 25.28 733,533.80 171,652.28 Fire Operations 422,200.00 22,004.49 118,989.94 28.18 303,210.06 128,721.75 Emergency Management 62,700.00 595.40 5,639.05 8.99 57,060.95 5,448.93 Building Safety 531,850.00 56,732.65 155,377.62 29.21 376,472.38 151,310.46 Code Enforcement 86,300.00 9,011.03 26,168.73 30.32 60,131.27 23,112.68 Environmental 58,300.00 5,924.65 17,122.15 29.37 41,177.85 15,133.29 TOTAL Public Safety 8,593,150.00 772,838.11 2,390,304.64 27.82 6,202,845.36 2,093,010.71 Public Works Street Maintenance 1,462,850.00 145,688.68 393,135.28 26.87 1,069,714.72 371,696.17 Snow Removal 345,800.00 23,677.11 216,886.44 62.72 128,913.56 174,155.55 Equipment Services 254,050.00 20,243.82 81,743.39 32.18 172,306.61 58,292.87 Engineering 492,800.00 44,602.17 122,404.99 24.84 370,395.01 108,386.80 TOTAL Public Works 2,555,500.00 234,211.78 814,170.10 31.86 1,741,329.90 712,531.39 5-11-2021 03:07 PM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2021 101-GENERAL FUND FINANCIAL SUMMARY 33.33% OF YEAR COMPLETED CURRENT CURRENT YEAR TO DATE % OF BUDGET PRIOR FY CURRENT CURRENT YEAR TO DATE % OF BUDGET PRIOR FY CURRENT CURRENT YEAR TO DATE % OF BUDGET PRIOR FY CURRENT CURRENT YEAR TO DATE % OF BUDGET PRIOR FY BUDGET PERIOD ACTUAL BUDGET BALANCE YTD BALANCE BUDGET PERIOD ACTUAL BUDGET BALANCE YTD BALANCE BUDGET PERIOD ACTUAL BUDGET BALANCE YTD BALANCE BUDGET PERIOD ACTUAL BUDGET BALANCE YTD BALANCE __________________________________________________________________________________________________________________________________ Culture & Recreation Parks Department 1,307,700.00 108,173.64 332,438.26 25.42 975,261.74 291,607.92 Parks & Rec Admin 553,850.00 50,277.84 160,569.20 28.99 393,280.80 201,114.96 Recreation Programs 122,700.00 1,918.98 12,329.97 10.05 110,370.03 17,740.89 Farmers Market 8,750.00 330.56 880.20 10.06 7,869.80 107.44 Sr Citizen Programs 129,300.00 12,196.67 36,410.33 28.16 92,889.67 54,536.55 TOTAL Culture & Recreation 2,122,300.00 172,897.69 542,627.96 25.57 1,579,672.04 565,107.76 Economic Development Economic Development 0.00 6,198.81 16,142.46 0.00 ( 16,142.46) 27,589.93 Energy City 33,900.00 2,345.78 8,178.03 24.12 25,721.97 5,857.80 TOTAL Economic Development 33,900.00 8,544.59 24,320.49 71.74 9,579.51 33,447.73 General ________________________________________________________________________ TOTAL EXPENDITURES 17,532,500.00 1,600,855.70 5,009,102.35 28.57 12,523,397.65 4,619,171.16 ============= ============= ============= ======= ============= ============= REVENUES OVER/(UNDER) EXPENDITURES 0.00 ( 1,299,170.20)( 4,075,073.13) 4,075,073.13 ( 3,764,806.26) 5-11-2021 03:07 PM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2021 101-GENERAL FUND 33.33% OF YEAR COMPLETED CURRENT CURRENT YEAR TO DATE % OF BUDGET PRIOR FY CURRENT CURRENT YEAR TO DATE % OF BUDGET PRIOR FY CURRENT CURRENT YEAR TO DATE % OF BUDGET PRIOR FY CURRENT CURRENT YEAR TO DATE % OF BUDGET PRIOR FY REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE YTD BALANCEREVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE YTD BALANCEREVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE YTD BALANCEREVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE YTD BALANCE __________________________________________________________________________________________________________________________________ General Fund ============ Taxes 101-3-0000-3111 Current Ad Valorem Taxes 12,315,000.00 0.00 0.00 0.00 12,315,000.00 4.06 101-3-0000-3121 Gravel Tax 150,000.00 18,860.28 18,860.28 12.57 131,139.72 0.00 TOTAL Taxes 12,465,000.00 18,860.28 18,860.28 0.15 12,446,139.72 4.06 Licenses & Permits 101-3-0000-3211 Liquor License 76,000.00 240.00 475.00 0.63 75,525.00 155.00 101-3-0000-3213 Cigarette License 3,000.00 0.00 150.00 5.00 2,850.00 0.00 101-3-0000-3214 Rental License 65,000.00 4,618.00 35,071.00 53.96 29,929.00 32,777.00 101-3-0000-3216 Mining License 25,000.00 1,990.80 2,057.47 8.23 22,942.53 1,521.60 101-3-0000-3217 Garbage Hauler License 2,000.00 0.00 420.00 21.00 1,580.00 360.00 101-3-0000-3218 Other Business License/Permit 15,000.00 780.00 3,720.00 24.80 11,280.00 3,520.00 101-3-0000-3229 NPDES Permit 20,000.00 1,925.00 5,775.00 28.88 14,225.00 4,928.25 101-3-0000-3231 Building Permit 450,000.00 47,487.00 166,470.79 36.99 283,529.21 88,553.65 101-3-0000-3232 Plumbing/Heating Permit 110,000.00 8,013.90 54,014.56 49.10 55,985.44 19,904.95 101-3-0000-3233 Permit Surcharge 500.00 ( 291.24) 3,364.05 672.81 ( 2,864.05) 2,106.48 101-3-0000-3235 Animal License 0.00 0.00 150.00 0.00 ( 150.00) 315.00 101-3-0000-3237 Other Non-Business Lic/Permit 12,000.00 2,175.00 5,115.00 42.63 6,885.00 4,722.50 TOTAL Licenses & Permits 778,500.00 66,938.46 276,782.87 35.55 501,717.13 158,864.43 Intergovernmental Rev 101-3-0000-3322 MV Credit 5,500.00 0.00 0.00 0.00 5,500.00 0.00 101-3-0000-3323 Fire State Aid 200,000.00 0.00 1,000.00 0.50 199,000.00 1,000.00 101-3-0000-3325 Police 2% Aid 305,000.00 0.00 0.00 0.00 305,000.00 0.00 101-3-0000-3326 Police Training Reimb 32,000.00 1,000.00 3,000.00 9.38 29,000.00 0.00 101-3-0000-3329 State Crime Prevention Grant 60,000.00 10,476.11 10,476.11 17.46 49,523.89 0.00 TOTAL Intergovernmental Rev 602,500.00 11,476.11 14,476.11 2.40 588,023.89 1,000.00 Charges for Services 101-3-0000-3412 Planning & Zoning Fees 25,000.00 2,606.25 6,871.25 27.49 18,128.75 9,035.00 101-3-0000-3413 Plan Check Fee 220,000.00 23,973.58 89,507.50 40.69 130,492.50 37,123.09 101-3-0000-3415 Special Assessment Search 500.00 210.00 570.00 114.00 ( 70.00) 210.00 101-3-0000-3417 Copies 1,500.00 239.56 661.98 44.13 838.02 382.02 101-3-0000-3418 Other General Govt Services 500.00 0.00 0.00 0.00 500.00 0.00 101-3-0000-3430 Lockout Fees 5,500.00 560.00 1,420.00 25.82 4,080.00 1,520.00 101-3-0000-3431 Police Services 15,000.00 3,110.50 3,260.50 21.74 11,739.50 4,054.43 101-3-0000-3432 School Liaison 151,000.00 0.00 75,832.50 50.22 75,167.50 73,536.00 101-3-0000-3434 Animal Impound Fee 2,500.00 0.00 0.00 0.00 2,500.00 550.00 101-3-0000-3436 Fire Contracts 286,000.00 33,428.96 33,428.96 11.69 252,571.04 155,767.80 101-3-0000-3437 Fire Services 6,000.00 0.00 0.00 0.00 6,000.00 6,137.50 101-3-0000-3451 Street Services 25,000.00 3,209.33 6,127.66 24.51 18,872.34 9,665.00 101-3-0000-3452 Engineering Services Reimb 25,000.00 0.00 0.00 0.00 25,000.00 5,802.23 101-3-0000-3461 Recreation Fees 60,000.00 6,542.00 23,457.00 39.10 36,543.00 8,181.50 101-3-0000-3462 Sr Center Activities 30,000.00 995.00 7,617.00 25.39 22,383.00 8,340.00 101-3-0000-3463 Farmer's Market 12,000.00 0.00 18,100.00 150.83 ( 6,100.00) 9,775.00 5-11-2021 03:07 PM CITY OF ELK RIVER PAGE: 4 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2021 101-GENERAL FUND 33.33% OF YEAR COMPLETED CURRENT CURRENT YEAR TO DATE % OF BUDGET PRIOR FY CURRENT CURRENT YEAR TO DATE % OF BUDGET PRIOR FY CURRENT CURRENT YEAR TO DATE % OF BUDGET PRIOR FY CURRENT CURRENT YEAR TO DATE % OF BUDGET PRIOR FY REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE YTD BALANCEREVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE YTD BALANCEREVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE YTD BALANCEREVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE YTD BALANCE __________________________________________________________________________________________________________________________________ 101-3-0000-3469 Elk RiverFest 10,000.00 6,260.00 11,625.00 116.25 ( 1,625.00) 1,000.00 101-3-0000-3472 Park Use Fee 20,000.00 1,868.10 6,640.10 33.20 13,359.90 5,290.25 101-3-0000-3483 Sewer Inspection Fee 12,000.00 1,600.00 3,440.00 28.67 8,560.00 3,185.00 101-3-0000-3484 Contractor License Check 1,000.00 145.00 335.00 33.50 665.00 195.00 TOTAL Charges for Services 908,500.00 84,748.28 288,894.45 31.80 619,605.55 339,749.82 Fines & Forfeits 101-3-0000-3510 Court Fines 120,000.00 15,686.71 27,574.11 22.98 92,425.89 30,827.19 101-3-0000-3511 Parking Fines 0.00 0.00 0.00 0.00 0.00 150.00 TOTAL Fines & Forfeits 120,000.00 15,686.71 27,574.11 22.98 92,425.89 30,977.19 Special Assessments _____________ _____________ _____________ _______ _____________ _____________ Other Revenue 101-3-0000-3621 Interest Income 75,000.00 0.00 9,687.52 12.92 65,312.48 47,418.15 101-3-0000-3625 Refunds & Reimbursements 130,000.00 ( 97.07) 501.76 0.39 129,498.24 ( 3,453.19) 101-3-0000-3626 Contributions 25,000.00 0.00 0.00 0.00 25,000.00 0.00 101-3-0000-3629 Miscellaneous Revenue 6,500.00 3,408.08 8,072.50 124.19 ( 1,572.50) 1,934.38 TOTAL Other Revenue 236,500.00 3,311.01 18,261.78 7.72 218,238.22 45,899.34 Transfers In 101-3-0000-3921 Transfers 0.00 0.00 460.00 0.00 ( 460.00) 0.00 101-3-0000-3924 Transfer - MPF 140,000.00 0.00 0.00 0.00 140,000.00 0.00 101-3-0000-3930 Transfer-Development 10,600.00 0.00 0.00 0.00 10,600.00 0.00 101-3-0000-3942 Transfer-WWTS 160,000.00 0.00 0.00 0.00 160,000.00 0.00 101-3-0000-3943 Transfer-Liquor 500,000.00 0.00 0.00 0.00 500,000.00 0.00 101-3-0000-3944 Transfer-Garbage 52,000.00 0.00 0.00 0.00 52,000.00 0.00 101-3-0000-3945 Transfer-Utilities 1,355,000.00 100,664.65 288,719.62 21.31 1,066,280.38 277,870.06 101-3-0000-3946 Transfer-Stormwater 121,000.00 0.00 0.00 0.00 121,000.00 0.00 101-3-0000-3948 Transfer-EDA 41,000.00 0.00 0.00 0.00 41,000.00 0.00 101-3-0000-3949 Transfer-HRA 41,900.00 0.00 0.00 0.00 41,900.00 0.00 TOTAL Transfers In 2,421,500.00 100,664.65 289,179.62 11.94 2,132,320.38 277,870.06 ____________________________________________________________________________________________ TOTAL General Fund 17,532,500.00 301,685.50 934,029.22 5.33 16,598,470.78 854,364.90 __________________________________________________________________________________________________________________________________ TOTAL REVENUE 17,532,500.00 301,685.50 934,029.22 5.33 16,598,470.78 854,364.90 ============= ============= ============= ======= ============= ============= 5-11-2021 03:10 PM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2021 221-MULTIPURPOSE FACILITY221-MULTIPURPOSE FACILITY FINANCIAL SUMMARY 33.33% OF YEAR COMPLETED CURRENT CURRENT YEAR TO DATE % OF BUDGET PRIOR FY CURRENT CURRENT YEAR TO DATE % OF BUDGET PRIOR FY CURRENT CURRENT YEAR TO DATE % OF BUDGET PRIOR FY CURRENT CURRENT YEAR TO DATE % OF BUDGET PRIOR FY BUDGET PERIOD ACTUAL BUDGET BALANCE YTD BALANCE BUDGET PERIOD ACTUAL BUDGET BALANCE YTD BALANCE BUDGET PERIOD ACTUAL BUDGET BALANCE YTD BALANCE BUDGET PERIOD ACTUAL BUDGET BALANCE YTD BALANCE __________________________________________________________________________________________________________________________________ REVENUE SUMMARY Multipurpose Facility 1,521,850.00 18,340.58 266,380.42 17.50 1,255,469.58 106,920.04 Hockey 61,000.00 165.00 57,090.00 93.59 3,910.00 4,509.00 Skating 35,000.00 605.00 5,341.00 15.26 29,659.00 ( 830.00) Concessions 139,300.00 1,101.89 3,964.72 2.85 135,335.28 15,082.74 TOTAL REVENUES 1,757,150.00 20,212.47 332,776.14 18.94 1,424,373.86 125,681.78 ============= ============= ============= ======= ============= ============= EXPENDITURE SUMMARY Culture & Recreation Multipurpose Facility 1,324,300.00 116,216.33 369,599.50 27.91 954,700.50 175,711.94 Hockey 30,150.00 2,231.77 14,818.37 49.15 15,331.63 14,058.32 Skating 19,950.00 1,333.65 2,242.97 11.24 17,707.03 2,767.48 Concessions 87,500.00 749.39 1,111.52 1.27 86,388.48 11,895.39 TOTAL Culture & Recreation 1,461,900.00 120,531.14 387,772.36 26.53 1,074,127.64 204,433.13 TOTAL EXPENDITURES 1,461,900.00 120,531.14 387,772.36 26.53 1,074,127.64 204,433.13 ============= ============= ============= ======= ============= ============= REVENUES OVER/(UNDER) EXPENDITURES 295,250.00 ( 100,318.67)( 54,996.22) 350,246.22 ( 78,751.35) ------ 0.00%0.67%0.00%0.35%0.00%0.00%0.00% 25.35%25.35%25.16%25.16% % of -34.97%-35.72%-27.46% Budget - - - - - - - - - - - 3,4803,4801,2581,258 145,784145,784 142,304143,562143,562143,562 Actual $ Year to Date Stormwater - - - - - - - - - 1,0005,0005,000 575,000575,000 522,900458,000981,900 (406,900) (401,900) (121,000) (522,900) (522,900) Budget Current $ - ----- 2.39%0.00%0.00%0.00% 19.79%19.72%26.55% 25.00%25.00%30.88%25.86%25.67%15.20%15.20% % of Budget --------- 464456456 10,053 39,40839,86539,86539,865 433,695433,695 383,770394,286 Actual $ Year to Date Garbage -------- 3,0003,000 32,55019,400 (52,000) 199,150202,150150,150150,150 1,735,0001,735,000 1,483,9001,535,850 Budget Current $ -- 0.00%0.00%0.00%0.00%0.00% -7.76% 25.09%27.26%25.19%30.22%32.25%29.78%15.44%13.69%12.80%12.55% % of -11.94%-55.48% 539.58% Budget - - - - - 6,847 32,71783,871 82,300 (29,584) (22,736) (11,845) 589,557622,274 224,783208,584517,238 105,036 539,584 621,884170,039 (440,000) Actual Sewer $ Year to Date - - 500 50,000 120,000743,800260,100700,400100,000 (879,800) (231,100) (181,100) (160,000) (135,000) (440,000) CITY OF ELK RIVER 2,350,0002,470,500 1,646,0003,350,300 Budget Current (1,060,900) (1,120,900) (1,695,900) $ MONTH ENDED APRIL, 2021 ------ ENTERPRISE FUNDS - BUDGET TO ACTUAL 0.00%0.00%0.00%0.00% 55.26%52.76% 33.30%30.71%39.48%40.29%40.29%32.26%30.92%35.12%30.04%10.32%10.32% % of 316.31% Budget --------- 1,9341,934 6,0615,1585,158 (9,000) 894,937313,383107,640427,083 469,788474,946474,946465,946 Actual 2,554,186 (1,659,249) Liquor $ Year to Date ------- 4,8004,800 19,60050,00050,000 (20,000) 971,550306,500124,000 850,150900,150150,150130,150 (750,000) 7,670,5002,267,0001,421,650 Current Budget (5,403,500) $ Sales and cost of sales: Sales Cost of sales Gross profit Operating revenues: User charges Delinquency collections Other Total operating revenues Operating expenses: Personal services Supplies Other service charges Depreciation * Total operating expenses Operating income (loss)Nonoperating revenues (expenses): Interest income Interest expense/agent fees Total nonoperating revenues (expenses)Income (loss) before contributions & transfers Contributions - connection feesSale of assetsTransfers inTransfers out NET INCOME (LOSS)Items reclassified to balance sheet at year end: Capital Outlay Bond Payment Revenues over/(under) expenditures * Recorded at yearend 5-12-2021 04:17 PM CITY OF ELK RIVER PAGE: 1 POOLED CASH REPORT (FUND 999) AS OF: APRIL 30TH, 2021 BEGINNING CURRENT CURRENT FUND ACCOUNT# ACCOUNT NAME BALANCE ACTIVITY BALANCE __________________________________________________________________________________________________________________ CLAIM ON CASH 002-1010 Cash - Section 125 5,904.20 1,838.72 7,742.92 101-1010 Cash - General Fund 5,252,830.63 ( 1,325,447.93) 3,927,382.70 211-1010 Cash - Library 332,642.85 ( 27,679.64) 304,963.21 221-1010 Cash - Multipurpose Facility 215,186.41 ( 69,200.85) 145,985.56 222-1010 Cash - Pinewood Golf Course ( 382.76) 0.00 ( 382.76) 225-1010 Cash - Park Dedication 873,470.38 1,425.93 874,896.31 228-1010 Cash - Landfill 205,282.10 457.97 205,740.07 231-1010 Cash - Landfill Const Debris 798,345.05 0.00 798,345.05 240-1010 Cash - Micro Loan Fund 828,299.90 2,457.11 830,757.01 242-1010 Cash - State DEED 169,722.61 4,034.40 173,757.01 245-1010 Cash - Development Fund 1,512,594.19 ( 39,886.25) 1,472,707.94 290-1010 Cash - Capital Outlay Reserve 1,667,127.42 ( 37,773.04) 1,629,354.38 291-1010 Cash - Insurance Reserve 55,642.56 ( 983.66) 54,658.90 292-1010 Cash - Govt Bldgs Reserve 3,067,722.59 ( 58,316.15) 3,009,406.44 294-1010 Cash - Drug Forfeiture 33,635.46 ( 63.23) 33,572.23 295-1010 Cash - Severance Pay Reserve 77,998.45 0.00 77,998.45 296-1010 Cash - GRE Reserve 1,001,417.06 ( 915.65) 1,000,501.41 301-1010 Cash - 2020A CIP Bonds 4,118.36 ( 850.00) 3,268.36 333-1010 Cash - 2010A GO Cap Imp Bonds 453,086.97 ( 2,400.00) 450,686.97 343-1010 Cash - 2019A Sales Tax Bonds 1,986,344.62 189,004.50 2,175,349.12 345-1010 Cash - 2012A CIP Bonds-PW ( 377,590.86)( 7,600.00)( 385,190.86) 401-1010 Cash - Pavement Mgmt 5,678,392.96 ( 3,435.50) 5,674,957.46 403-1010 Cash - Street Improvement 670,118.39 ( 18,237.89) 651,880.50 406-1010 Cash - City Wide Trunk Util 4,377,404.06 ( 152,981.31) 4,224,422.75 410-1010 Cash - Equipment Replacement 585,841.56 2,171.63 588,013.19 420-1010 Cash - Active ER 5,882,421.24 ( 266,979.55) 5,615,441.69 421-1010 Cash - PS Building/Fire Sta 3 7,565,247.48 ( 823,242.78) 6,742,004.70 440-1010 Cash - Park Improvement 118,959.50 0.00 118,959.50 462-1010 Cash - TIF #22 Downtown Redev ( 51.55) 0.00 ( 51.55) 463-1010 Cash - TIF #23 Pref Powder 5,641.26 0.00 5,641.26 602-1010 Cash - Wastewater Treatment 6,221,787.64 146,241.92 6,368,029.56 603-1010 Cash - Liquor 4,908,586.95 29,729.14 4,938,316.09 605-1010 Cash - Garbage 469,940.57 9,627.03 479,567.60 607-1010 Cash - Storm Water 1,292,342.41 47,800.41 1,340,142.82 801-1010 Cash - Interest 138,810.85 35,669.88 174,480.73 821-1010 Cash - Developer Escrow 639,859.04 ( 28,971.39) 610,887.65 TOTAL CLAIM ON CASH 56,718,700.55 ( 2,394,506.18) 54,324,194.37 =============== ============== ============== CASH IN BANK - POOLED CASH 999-1000 A/P BANK ACCOUNTS 161,987,626.06 ( 736,087.36) 161,251,538.70 999-1001 PY BANK ACCOUNT (133,651,115.07)( 1,658,418.82)(135,309,533.89) 999-1002 POOLED INVESTMENTS 28,382,189.56 0.00 28,382,189.56 SUBTOTAL CASH IN BANK - POOLED CASH 56,718,700.55 ( 2,394,506.18) 54,324,194.37