Loading...
5.b August 2019 Treasurer's Report■ ` ■ m i n n c s o t a Beginning Balance 8/1/2019 Receipts Expenditures Payroll Adjustments: City of Scandia Treasurer's Report 8/31/2019 $ 262,714.30 $ 26,109.36 $ 4,714,653.93 $ 47,636.30 $ (288,823.66) Ending Balance 8/31/2019 $ 4,473,466.57 Ending Balance includes the following Investments; Checking *102 Money Market *105 - Rate .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 to EDA correct cash account *105 Deposit in transit Adj: Further HSA payment did not clear bank in Aug. Total Undesignated Funds Scandia EDA *6301 Bal 6/30/19 Receipts Expenditures Checks in Transit Deposit in Transit Total Designated Funds Total Funds Submitted by: Colleen Firkus, Treasurer $ 41,668.78 $ 2,465,379.05 $ 520,542.02 $ 307,631.31 $ 430,006.32 $ 713,170.78 $ 21,614.34 $ 4,478,398.26 $ (4,929.64) $ (2.05) $ 4,473,466.57 $ 21,614.34 $ 4,495,080.91 scr L 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 498 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 $8,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 $251,564 $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 $1,216,414 $1,134,328 $1,380,400 $1,242,710 $20,793 $19,813 $21,614 $21,614 $9,588 -$700 $815 $2,349 $175 $175 $175 $175 $172 $1,339 $1,339 $1,339 -$40,434 -$40,434 -$5,527 -$5,527 $15,495 $15,495 -$3,598 -$3,598 -$2,201 -$2,201 -$16,885 -$16,885 -$116,320 -$116,320 $59,249 $59,249 $642,094 $638,668 $1,050,314 $1,056,381 $0 $0 $0 $0 $153,803 $150,663 $159,374 $159,153 $276,977 $276,977 $292,195 $292,195 $1,442,783 $1,433,471 $1,616,833 $1,518,222 $97,954 $105,056 $114,923 $98,617 $11,598 $10,862 $10,247 $14,641 $59,738 $56,721 $54,801 $54,446 $3,788,630 $3,683,914 $4,736,268 $4,495,081 City of Scandia � Expenditure Summary SCANDU } August -19 2019 YTD Budget % of YTD GENERAL FUND 2019 YTD Budget 2019 YTD Amount 2019 MTD Amount Balance Budget Administration & Finance- $791,862.00 $667,74736 $25,788.31 $124,114.64 84.33% City Council $31,00000 $19,384.90 $000 $11,61510 62.53% Elections $2,20000 $83000 $000 $1,37000 37.73% Planning & Building $119,200.00 $81,81817 $8,512.97 $37,381.83 68.64% Police $136,000.00 $68,12751 $67,818.15 $67,87249 50.09% Fire Department $262,40000 $144,04011 $13,73756 $118,35989 5489% Public Works $661,00000 $382,27459 $38,843.49 $278,725.41 5783% Parks & Recreation $85,100.00 $48,57553 $5,921.62 $36,524.47 57.08% Community Center $49,80000 $23,43655 $1,732.36 $26,361.45 47.07% Total General Fund $2,138,562.00 $1,436,236.72 $162,354.46 $702,325.28 67.16% EDA $80000 $2,235.00 $000 -$1,435.00 000% CABLE TV $22,20000 $13,335.12 $000 $8,864.88 GATEWAY DONATIONS $000 $0.00 $000 $0.00 000% DEBT 2007 ROAD PROJECT BOND $000 $000 $0.00 $000 0.00% 2013 EQUIPMENT CERTIFICATI $62,918.00 $59,49250 $0.00 $3,42550 94.56% 2015 EQUIPMENT CERTIFICATI $44,941 00 $43,94600 $000 $99500 97.79% 2017 EQUIPMENT CERTIFICATI $35,63600 $35,32800 $0.00 $30800 9914% 2016 BLACKTOP $329,638.00 $116,320.00 $0.00 $213,31800 3529% $473,133.00 $255,086.50 $0.00 $218,046.50 53.91% CAPITAL IMPROVEMENTS $224,20000 $128,26606 $9,464.45 $95,93394 5721% ROAD CONSTRUCTION $0.00 $0.00 $0.00 $000 #DIV/0! PARK CAPITAL IMPROVEMENT $207,24000 $105,705.93 $22000 $101,534.07 5101% EQUIPMENT REPLACEMENT $73,000.00 $000 $000 $73,000.00 0.00% LOCAL ROAD IMPROVEMENT F $368,29000 $121,189.77 $98,611.77 $247,100.23 32.91% 201 SEWER FUND $137,52500 $56,321 59 $16,555.72 $81,203.41 40.95% UPTOWN SEWER $21,397.00 $7,430.96 $568.16 $13,96604 3473% Report Total $3,666,347.00 $2,125,807.65 $287,774.56 $1,540,539.35