Loading...
5.b June 2019 Treasurer's Report�7 m i n n c s o E z Beginning Balance 6/1/2019 Receipts Expenditures Payroll Adjustments: Ending Balance 6/30/2019 City of Scandia Treasurer's Report 6/30/2019 Ending Balance includes the following Investments: Checking *102 Money Market *105 - Rate 1.25% CD *2920/4426 - Rate 2.50% 12 mo., 1/29/2020 CD *4422 - Rate 1.90% 12 mo., 3/21/2019 CD *4424 - Rate 2.40% 12 mo., 7/25/20198 CD *4425 - Rate 2.50% 12 mo., 9/28/2019 Total Undesignated Funds Checks in Transit *3102 Transfer EDA cash to separate account Deposit in transit Total Undesignated Funds Scandia EDA *6301 Bal 5/31/19 Receipts Expenditures Checks in Transit Total Designated Funds Total Funds Submitted by: Colleen Firkus, Treasurer $ 3,767,836.51 $ 97,658.77 $ 176,332.69 $ 25,062.21 $ (201,394.90) $ 53,608.10 $ 1,633,053.19 $ 517,317.64 $ 307,631.31 $ 427,504.54 $ 713,170.78 $ 16,939.07 $ 3,854.27 $ (980.00) $ 3,664,100.38 $ 3,652,285.56 $ (4,925.84) $ 16,740.66 $ 3,664,100.38 $ 19,813.34 $ 3,683,913.72 City of Scandia Mai Expenditure Summary SCANDIA June -19 2019 YTD Budget % of YTD GENERAL FUND 2019 YTD Budget 2019 YTD Amount 2019 MTD Amount Balance Budget Administration & Finance— $791,862.00 $183,310.48 $33,475.57 $608,551.52 23,15% City Council $31,00000 $14.69507 $000 $16,304.93 47,40% Elections $2,200.00 $830.00 $0.00 $1,370.00 37.73% Planning & Building $119,200.00 $53,624.33 $17,468.75 $65,575.67 44.99% Police $136,000,00 $309.36 $000 $135,690.64 0,23% Fire Department $262,400.00 $113,219 15 $14,710.36 $149,180.85 43.15% Public Works $661,00000 $306,18566 $74,227.44 $354,814.34 46.32% Parks & Recreation $85,100.00 $38,184.45 $7,345.19 $46,915.55 44.87% Community Center $49,800.00 $19,259.06 $1,583.37 $30,540.94 3867% Total General Fund $2,138,562.00 $729,617.56 $148,810.68 $1,408,944.44 34.12% EDA $800.00 $1,50000 $98000 -$70000 000% CABLE TV $22,200.00 $13,335 12 $11,775.36 $8.86488 GATEWAY DONATIONS $0.00 $000 $0.00 $000 0.00% DEBT 2007 ROAD PROJECT BOND $0.00 $0.00 $0.00 $000 0.00% 2013 EQUIPMENT CERTIFICATI $62,918.00 $59,492.50 $0.00 $3,42550 94.56% 2015 EQUIPMENT CERTIFICATI $44,941.00 $000 $0.00 $44,941 00 000% 2017 EQUIPMENT CERTIFICATI $35,636.00 $1,664.00 $000 $33.97200 4.67% 2018 BLACKTOP $329,63800 $116,32000 $0.00 $213,31800 35.29% $473,133.00 $177,476.50 $0.00 $295,656.50 37.51% CAPITAL IMPROVEMENTS $224,20000 $98,485.11 $18,392.00 $125,714.89 43.93% ROAD CONSTRUCTION $000 $000 $0.00 $000 #DIV/0! PARK CAPITAL IMPROVEMENT $207,240.00 $104,19643 $3,939.65 $103,043.57 50.28% EQUIPMENT REPLACEMENT $73.00000 $0.00 $000 $73,00000 0.00% LOCAL ROAD IMPROVEMENT F $368,290.00 $13,728.00 $9,31200 $354.56200 3.73% 201 SEWER FUND $137,525.00 $37,002.20 $2,939.06 $100,52280 26.91% UPTOWN SEWER $21,39.7.00 $6,247.72 $736.52 $15,149.28 2920% Report Total $3,666,347.00 $1,181,588.64 $196,885.27 $2,484,758.36 "Note Administration Budget increased by approved transfer of $438,962, but transfer will be in June report. 194 SCAN DLA all CASH BALANCES 2019 END OF MONTH FUND JANUARY FEBRUARY MARCH APRIL MAY JUNE 101 GENERAL $1,620,605 $1,452,297 $1,355,921 $1,260,238 $1,216,414 $1,134,328 225 EDA $14,839 $21,313 $21,313 $20,793 $20,793 $19,813 226 CABLE TV $6,302 $6,666 $8,167 $9,655 $9,588 -$700 230 RESTRICTED DONATIONS $175 $175 $175 $175 $175 $175 307 BLACKTOP 2007 $164 $164 $172 $172 $172 $1,339 313 EQUIPMENT CERTIFICATES $19,059 $19,059 $19,059 $19,059 -$40,434 -$40,434 315 EQUIPMENT CERTIFICATES $15,495 $15,495 $15,495 $15,495 $15,495 $15,495 317 EQUIPMENT CERTIFICATES -$2,201 -$2,201 -$2,201 -$2,201 -$2,201 -$2,201 318 BLACKTOP PROJECT -$116,320 -$116,320 401 CAPITAL IMPR $581,181 $568,810 $575,410 $676,096 $642,094 $638,668 402 ROAD CONSTRUCTION $0 $0 $0 $0 $0 $0 404 PARK CAP IMPR $118,585 $251,594 $251,564 $153,492 $153,803 $150,663 406 EQUIPMENT REPLACEMENT $275,777 $276,977 $276,977 $276,977 $276,977 $276,977 408 LOCAL ROAD IMPROVEMENT $1,449,555 $1,447,207 $1,444,363 $1,443,648 $1,442,783 $1,433,471 602 201 SEWER $108,142 $104,598 $115,480 $104,513 $97,954 $105,056 612 UPTOWN SEWER $8,131 $12,893 $12,281 $8,567 $11,598 $10,862 801 ESCROW $31,058 $59,389 $61,170 $60,244 $59,738 $56,721 TOTAL $4,246,868 $4,234,437 $4,155,346 $4,046,923 $3,788,630 $3,683,914