Loading...
5.b Treasurer's Oct. 2019 ReportCity of •' Treasurer's Repo 10/31/2019 1 Beginning Balance 10/1/2019 $ 4,367,473.81 Receipts $ 33,298.34 Expenditures $208,024.10 Payroll $41,794.03 $ (249,818.13) Ending Balance 10/31/2019 $ 4,150,954.02 Checking *102 $ 39,135.63 Money Market *105 - Rate .25% $ 2,145,983.63 CID *2920/4426 - Rate 2.50% 12 mo., 1/29/2020 $ 523,822.15 CID *4422 - Rate 2.50% 12 mo., 3/25/2020 $ 309,569.81 CD *4424 - Rate 2.00% 12 mo., 7/25/2020 $ 432,154.59 CID *4425 - Rate 1.75% 12 mo., 9/28/2020 $ 717,664.73 krism— a - - • - - - • EDA *6301 Checks in Transit $ 4,185,119.88 City of Scandia Expenditure Summary SCANDIA 3MOMMEEM October -1 9 2019 YTD Budget % of YTD GENE RALFUND 2019 YTD Budget 2019 YTD Amount 2019 MTD Amount Balance Budget Administration & Finance- $791,862.00 $748,239.59 $56,657.53 $43,622.41 94,49% City Council $31,00000 $24,129,73 $4,74483 $6,87027 77,84% Elections $2,20000 $830.00 $000 $1,37000 3773% Planning & Building $119,200,00 $99,652.66 $14,662.03 $19,54734 83,60% Police $136,00000 $68,127,51 $000 $67,87249 5009% Fire Department $262,400.00 $180,412.73 $24,198,79 $81,98727 6875% Public Works $661,000.00 $479,205.89 $48,608.63 $181,794.11 72,50% Parks & Recreation $85,10000 $58,561 93 $7,21502 $26,53807 6882% Community Center $49,80000 $31,70617 $5,56369 $18.093.73 63,67% Total General Fund $2,138,562.00 $1,690,866.31 $161,650.52 $447,695.69 79.07%® EDA $800,00 $7,060.00 $0,00 -$6,260,00 000% CABLE TV $22,200,00 $17,265,59 $1565 $4,93441 GATEWAY DONATIONS $0,00 $0,00 $0,00 $0.00 0.00% DEBT 2007 ROAD PROJECT BOND $0,00 $0.00 $0.00 $0.00 0-00% 2013 EQUIPMENT CERTIFICATES $62,91800 $59,492,50 $0-00 $3,425,50 94.56% 2015 EQUIPMENT CERTIFICATE $44,941 00 $43,94600 $000 $99500 97.79% 2017 EQUIPMENT CERTIFICATE $35,636.00 $35,328.00 $0.00 $308,00 99.14% 2018 BLACKTOP $329,63800 $116,32000 $000 $213,318.00 3529% $473,133.00 $255,086.50 $0.00 $218,046Z0 53.91% CAPITAL IMPROVEMENTS $224,20000 $159,131,44 $28,607,50 $65,06856 70,98% ROAD CONSTRUCTION $000 $000 $0-00 $000 #DIV/O! PARK CAPITAL IMPROVEMENTS $207,24000 $107,80526 $14673 $99,43474 52.02% EQUIPMENT REPLACEMENT $73,00000 $68,03683 $35,68200 $4,96317 93.20% LOCAL ROAD IMPROVEMENT FUND $368,290.00 $134,661>27 $10,461.50 $233,62873 3656% 201 SEWER FUND $137,525,00 $77,29898 $13,059.54 $60,226,02 5621% UPTOWN SEWER $21,39700 $8,951,42 $885.22 $12.445.58 41,83% Report Total $3,666,347.00 $2,526,163.60 $250,408.66 $1,140,183.40 2019 FUND 101 GENERAL 225 EDA 226 CABLE TV 230 RESTRICTED DONATIONS 307 BLACKTOP 2007 313 EQUIPMENT CERTIFICATES 315 EQUIPMENT CERTIFICATES 317 EQUIPMENT CERTIFICATES 318 BLACKTOP PROJECT 401 CAPITAL IMPS 402 ROAD CONSTRUCTION 404 PARK CAP IMPS 406 EQUIPMENT REPLACEMENT 408 LOCAL ROAD IMPROVEMENT 602 201 SEWER 612 UPTOWN SEWER 801 ESCROW TOTAL CASH BALANCES END OF MONTH JANUARY FEBRUARY MARCH APRIL $1,620,605 $1.452,297 $1,355,921 $1,260,238 $14,839 $21,313 $21,313 $20,793 $6,302 $6,666 $6,167 $9,655 $175 $175 $175 $175 $164 $164 $172 $172 $19,059 $19,059 $19,059 $19,059 $15,495 $15,495 $15,495 $15,495 -$2,201 -$2,201 -$2,201 -$2,201 $581,181 $568,810 $575,410 $676,096 $0 $0 $0 $0 $118,585 $251,594 $261,664 $153,492 $275,777 $276,977 $276.977 $276,977 $1,449,555 $1,447,207 $1,444,363 $1,443,648 $108,142 $104,598 $115,480 $104,513 $8,131 $12.893 $12,281 $8,567 $31,058 $59,389 $61,170 $60,244 $4,246,868 $4,234,437 $4,155,346 $4,046,923 MAY JUNE JULY AUGUST SEPTEMBER OCTOBER $1,216,414 $1,134,328 $1.380400 $1L242.710 $1,171,623 S 1,028.866 $20,793 $19.813 $21,614 $21,614 $16,709 $ 16,789 $9,688 -$700 $815 $2,349 -$40 $ 1,487 $175 $175 $175 $175 $175 S 175 $172 $1,339 $1,339 $1,339 $1,339 $ 1,339 -$40434 -$40,434 -$5,527 -$5,527 -$5,527 S (5,527) $15,495 $15,495 -$3,598 -$3,598 -$3598 $ (3,596) -$2,201 -$2,201 -$16,885 -$16,885 -$16,885 s (16,885) -$116,320 -$116,320 $59,249 $59,249 $59,249 $ 59,249 $642,094 $638,668 $1,050.314 $1,056,381 $1,056.963 $ 1,028,356 $0 $0 $0 $0 $0 $ $153,803 $150,663 $159,374 $159,153 $161,076 $ 160,929 $276.977 $276,977 $292,195 $292,195 $259,740 $ 224,158 $1,442,783 $1,433,471 $1,616,833 $1,518,222 $1,515,212 $ 1,504,750 $97,954 $105,056 $114,923 $98,617 $102,941 $ 100,993 $11,598 $10,862 $10.247 $14.641 $14,005 $ 13,120 $59,738 $56,721 $54,801 $54,446 $51,200 S 53,542 $3,786,630 $3,603,914 $4,736,268 $4,495,081 $4,384,263 $ 4,167,743