Loading...
5.b Treasurer's Report June 2020GENERALFUND Administration & Finance" City Council Elections Planning & Building Police Fire Department Public Works Parks & Recreation Community Center Total General Fund EDA CABLE N GATEWAY DONATIONS DEBT 2007 ROAD PROJECT BOND 2013 EQUIPMENT CERTIFICATI 2015 EQUIPMENT CERTIFICATI 2017 EQUIPMENT CERTIFICATI 2018 BLACKTOP CAPITAL IMPROVEMENTS ROAD CONSTRUCTION PARK CAPITAL IMPROVEMENT EQUIPMENT REPLACEMENT LOCAL ROAD IMPROVEMENT I 201 SEWER FUND UPTOWN SEWER City of Scandia Expenditure Summary $1,816,414.00 June -20 $119,038.28 $1,149,810.04 36.70% $800.00 $32500 $0.00 $47500 0.00% 2020 YTD Budget % of YTD 2020 YTD Budget 2020 YTD Amount 2020 MTD Amount Balance Budget $404,600.00 $196,210.65 $28,87944 $000 $208,38935 48.49% $21,00000 $4,60733 $0.00 $63,91500 $16,39267 2194% $6,40000 $2,489.46 $0.00 $43,49450 $3,91054 3890% $131,40000 $37,500.97 $9,812.52 $33,676.00 $93,89903 28.54% $139,10000 $361.36 $0.00 1714% $138,738.64 0.26% $296,114.00 $103,63014 $21,653.77 $430,00000 $192,48386 35.00% $690,70000 $258,849.33 $50,62440 $0.00 $431,85067 37.48% $77,600.00 $43,728.35 $6,152.95 $1,78570 $33,87165 56.35% $49,50000 $19,226.37 $1.91520 $162,501 93 $30,273.63 38.84% $1,816,414.00 $666,603.96 $119,038.28 $1,149,810.04 36.70% $800.00 $32500 $0.00 $47500 0.00% $8,92000 $1,648.49 $1,582.51 $7,271 51 $0.00 $0.00 $000 $000 0.00% $000 $000 $000 $0.00 0.00% $66,56000 $63,91500 $63,915.00 $2,645.00 9603% $43,99500 $43,49450 $43,49450 $500.50 98.86% $34,948.00 $1,272.00 $000 $33,676.00 3.64% $327,175.00 $56,08251 $000 $271,09249 1714% $472,678.00 $164,764.01 $107,409.50 $307,913.99 34.86% $430,00000 $29,731 53 $4,000 10 $400,26847 6.91% $0.00 $0.00 $0.00 $0.00 #DIV/0! $81,62000 $20,58570 $1,78570 $61,03430 2522% $256,000.00 $93,498.07 $0.00 $162,501 93 3652% $637,000.00 $379,68823 $98,882.75 $257,311.77 59.61% $135.57500 $136,267.55 $15,10047 -$69255 100.51% $22,44700 $5,002.91 $978 10 $17,444.09 22.29% Report Total $3,861,454.00 $1,498,115.45 $348,777.41 $2,363,338.55 R � rsr_ .:niL _ o .a 2020 FUND 101 GENERAL 226 CABLE TV 230 RESTRICTED DONATIONS 307 BLACKTOP 2007 313 EQUIPMENT CERTIFICATES 315 EQUIPMENT CERTIFICATES 317 EQUIPMENT CERTIFICATES 318 BLACKTOP PROJECT 401 CAPITAL IMPR 402 ROAD CONSTRUCTION 404 PARK CAP IMPR 406 EQUIPMENT REPLACEMENT 408 LOCAL ROAD IMPROVEMENT 602 201 SEWER 612 UPTOWN SEWER 801 ESCROW SUBTOTAL 225 EDA TOTAL CASH BALANCES END OF MONTH JANUARY FEBRUARY $1,241,912 $1,132,679 $4,853 $6,424 $175 $175 $111 $111 $19,767 $19,767 $16,352 $16,352 -$2,544 -$2,544 -$7,413 -$7,413 $1,048,268 $1,048,998 $0 $0 $151,637 $151,939 $233,285 $139,787 $1,661,216 $1,650,960 $94,211 $91,322 $18,727 $23,348 $46,678 $44,931 $4,527,236 $4,316,836 $23,206 $23,206 $4,550,441 $4,340,041 MARCH $1,034,252 $7,974 $175 $111 $19,767 $16,352 -$2,544 -$7,413 $1,047,458 $0 $151,939 $140,287 $1,642,612 $5,431 $22,265 $47,929 $4,126,596 $23,206 $4,149,802 APRIL $965,646 $9,558 $175 $111 $19,767 $16,352 -$2,544 -$63,495 $1,028,529 $0 $151,939 $153,787 $1,631,801 $8,097 $21,231 $50,534 $3,991,489 $22,981 $4,014,470 MAY $874,738 $11,191 $175 $0 $20,131 $16,611 -$2,347 -$63,495 $1,021,727 $0 $133,139 $153,787 $1,381,276 $14,487 $24,447 $51,738 $3,637,604 $22,881 $3,660,485 JUNE $809,046 $11,232 $175 $0 -$43,784 -$26,884 -$2,347 -$63,495 $1,017,727 $0 $131,854 $153,787 $1,282,393 $10,986 $23,469 $38,580 $3,342,739 $22,881 $3,365,620