Loading...
5.b Treasurer's July 2019 Reportmin Beginning Balance 7/1/2019 Receipts Expenditures Payroll City of Scandia Treasurer's Report 7/31/2019 $ 3,664,100.38 $ 1,273,321.83 $ 192,261.28 $ 27,971.00 $ (220,232.28) Adjustments: Transfer to EDA to correct cash account $ (2,536.00) Ending Balance 7/31/2019 $ 4,714,653.93 Ending Balance includes the following Investments: Checking *102 $ 59,383.66 Money Market *105 - Rate .25% $ 2,687,773.02 CD *2920/4426 - Rate 2.50% 12 mo., 1/29/2020 $ 520,542.02 CD *4422 - Rate 1.90% 12 mo., 3/21/2019 $ 307,631.31 CD *4424 - Rate 2.40% 12 mo., 7/25/20198 $ 430,006.32 CD *4425 - Rate 2.50% 12 mo., 9/28/2019 $ 713,170.78 Total Undesignated Funds $ 4,718,507.11 Checks in Transit *3102 $ (1,317.18) Transfer to EDA correct cash account *105 $ (2,536.00) Deposit in transit Total Undesignated Funds $ 4,714,653.93 Scandia EDA *6301 Bal 6/30/19 $ 19,813.34 Receipts Expenditures $ (735.00) Checks in Transit $ - Deposit in Transit $ 2,536.00 Total Designated Funds $ 21,614.34 Total Funds $ 4,736,268.27 Submitted by: Colleen Firkus, Treasurer City of Scandia ill r Expenditure Summary SCANDIA $473,133.00 $255,086.50 July -19 $218,046.50 53.91% CAPITAL IMPROVEMENTS $224,20000 $118,801 61 $20,316.50 $105,398.39 5299% 2019 YTD Budget % of YTD GENERAL FUND 2019 YTD Budget 2019 YTD Amount 2019 MTD Amount Balance Budget Administration & Finance- $791,86200 $641,95905 $458,64857 $149,902.95 8107% City Council $31,000.00 $19.38490 $4,689.83 $11,61510 6253% Elections $2,200.00 $83000 $0,00 $1,370.00 3773% Planning & Building $119.20000 $73.30520 $19,68087 $45,894.80 61.50% Police $136,000.00 $30936 $000 $135,690.64 023% Fire Department $262,40000 $130.30255 $17.08340 $132,097.45 49.66% Public Works $661,00000 $343,431 10 $37,24544 $317,56890 51.96% Parks & Recreation $85,100 00 $42,65391 $4,469.46 $42,44609 5012% Community Center $49,80000 $21,706.19 $2,44713 $28,09381 4359% Total General Fund $2,138,562.00 $1,273,882.26 $544,264.70 $864,679.74 59.57% EDA $80000 $2,23500 $73500 -$1,43500 0.00% CABLE TV $22.20000 $13,335 12 $000 $8,86488 GATEWAY DONATIONS $000 $000 $0.00 $000 000% DEBT 2007 ROAD PROJECT BOND $000 $000 $000 $000 0.00% 2013 EQUIPMENT CERTIFICATI $62,91800 $59,49250 $000 $3,42550 9456% 2015 EQUIPMENT CERTIFICATI $44,941 00 $43,946.00 $43,946.00 $99500 9779% 2017 EQUIPMENT CERTIFICATI $35,63600 $35,328.00 $33,66400 $308.00 9914% 2018 BLACKTOP $329,638.00 $116.32000 $000 $213.31800 3529% $473,133.00 $255,086.50 $77,610.00 $218,046.50 53.91% CAPITAL IMPROVEMENTS $224,20000 $118,801 61 $20,316.50 $105,398.39 5299% ROAD CONSTRUCTION $000 $0.00 $000 $000 #DIV/0! PARK CAPITAL IMPROVEMENT $207.24000 $105,48593 $1,289.50 $101,754.07 50.90% EQUIPMENT REPLACEMENT $73,00000 $000 $000 $73,00000 0.00% LOCAL ROAD IMPROVEMENT F $368,29000 $22,57800 $8,85000 $345,71200 613% 201 SEWER FUND $137,52500 $39,765.87 $2,76367 $97,75913 28.92% UPTOWN SEWER $21,39700 $6,8G2. 80 $61508 $14,53420 3207% Repos. Total $3,666,347.00 $1,838,033.09 $656,444.45 $1,828,313.91 SCA N MA 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 IMPR 402 ROAD CONSTRUCTION 404 PARK CAP IMPR 406 EQUIPMENT REPLACEMENT 408 LOCAL ROAD IMPROVEMENT 602 201 SEWER 612 UPTOWN SEWER 801 ESCROW TOTAL CASH BALANCES $0 END OF MONTH $251,594 JANUARY FEBRUARY $1,620,605 $1,452,297 $14,839 $21,313 $6,302 $6,666 $175 $175 $164 $164 $19,059 $19,059 $15,495 $15,495 -$2,201 -$2,201 $581,181 $568,810 $0 $0 $118,585 $251,594 $275,777 $276,977 $1,449,555 $1,447,207 $108,142 $104,598 $8,131 $12,893 $31,058 $59,389 $4,246,868 $4,234,437 MARCH $1,355,921 $21,313 $8,167 $175 $172 $19,059 $15,495 -$2,201 $575,410 $0 $251,564 $276,977 $1,444,363 $115,480 $12,281 $61,170 $4,155,346 APRIL $1,260,238 $20,793 $9,655 $175 $172 $19,059 $15,495 -$2,201 $676,096 $0 $153,492 $276,977 $1,443,648 $104,513 $8,567 $60,244 $4,046,923 MAY $1,216,414 $20,793 $9,588 $175 $172 -$40,434 $15,495 -$2,201 -$116,320 $642,094 $0 $153,803 $276,977 $1,442,783 $97,954 $11,598 $59,738 $3,788,630 JUNE $1,134,328 $19,813 -$700 $175 $1,339 -$40,434 $15,495 -$2,201 -$116,320 $638,668 $0 $150,663 $276,977 $1,433,471 $105,056 $10,862 $56,721 $3,683,914 JULY $1,380,400 $21,614 $815 $175 $1,339 -$5,527 -$3,598 -$16,885 $59,249 $1,050,314 $0 $159,374 $292,195 $1,616,833 $114,923 $10,247 $54,801 $4,736,268