Loading...
5.b Treasuer's Report August 2020ac-g , City of Scandia Treasurer's Report LSC A '1 DIA 8/31/2019 Beginning Cash Balance 8/1/2020 $ 4,762,696.69 Receipts Checking $ 5,665.84 Transfers to Checking $ 49,000.00 Receipts Money Mrkt $ 14,319.27 Expenditures $ 128,300.41 Payroll $ 30,954.16 Transfers $ 49,000.00 Total Disbursements $ (208,254.57) Adjustments: Beg Bal Ending Cash Balance 8/31/2019 $ 4,623,427.23 Ending Balance includes the following Investments Checking *102 Beg Bal $ 1,548,144.31 Credits $ 54,665.84 Debits $ (191,356.66) End Bal $ 1,411,453.49 Money Market *105 - Rate .25% Beg Bal $ 1,241,628.37 rate change from 1.25% Credits $ 14,319.27 Debits $ (49,000.00) End Bal $ 1,206,947.64 Investments CD *4422 - Rate .90% 12 mo., 3/25/2021 $ 314,147.18 CD *4424 - Rate .30% 12 mo., 7/25/2021 $ 438,723.19 CD *4425 - Rate 1.75% 12 mo., 9/28/2020 $ 727,050.72 CD *4426 - Rate 1.60% 12 mo., 1/29/2021 $ 531,318.64 Total Investments $ 2,011,239.73 Total Bank & Investment Accounts $ 4,629,640.86 Checks in Transit *3102 $ (6,213.63) Deposit in transit $ Total Adjusted Undesignated Funds $ 4,623,427.23 Scandia EDA *6301 Bal 6/30/19 $ 25,298,76 Receipts $ Expenditures $ Checks in Transit $ Deposit in Transit Total Designated Funds $ 25,298.76 Total Funds $ 4,648,725.99 Submitted by: Colleen Firkus, Treasurer City of Scandia SCANDIA Expenditure Summary Report Total $3,966,787.50 $1,898,957.01 $152,863.27 $2,067,830.49 August -20 2020 YTD Budget % of YTD GENERAL FUND 2020 YTD Budget 2020 YTD Amount 2020 MTD Amount Balance Budget Administration & Finance— $404,60000 $263,79420 $30,629.03 $140,805.80 65.20% City Council $21,00000 $9,29716 $0.00 $11,702.84 44.27% Elections $6.40000 $5,78741 $3,297.95 $612,59 90.43% Planning & Building $131,400.00 $59,965.55 $6,763.01 $71,43445 45.64% Police $139,100.00 $69,73850 $0.00 $69,361.50 50.14% Fire Department $296,11400 $144,24499 $18,444.99 $151,86901 48.71% Public Works $690,70000 $366.07411 $69,222.97 $324,625.89 53.00% Parks & Recreation $77,600.00 $54,571 41 $4,248.96 $23,02859 70.32% Community Center $49.50000 $23,486.94 $1,646.19 $26,01306 47.45% Total General Fund $1,816,414.00 $996,960.27 $134,253.10 $819,453.73 54.89% EDA $800.00 $32500 $0.00 $475.00 0.00% CABLE TV $8.92000 $3,08051 $000 $5,83949 GATEWAY DONATIONS $000 $0.00 $0.00 $0.00 0.00% DEBT 2007 ROAD PROJECT BOND $0.00 $000 $0.00 $0.00 0.00% 2013 EQUIPMENT CERTIFICATI $66,56000 $63,91500 $000 $2,645.00 96.03% 2015 EQUIPMENT CERTIFICATI $43,99500 $43,494.50 $0.00 $500.50 98.86% 2017 EQUIPMENT CERTIFICATI $34,948.00 $34,54400 $0.00 $404.00 98.84% 2018 BLACKTOP $327,17500 $56,08251 $0.00 $271,09249 17.14% $472,678.00 $198,036.01 $0.00 $274,641.99 41.90% CAPITAL IMPROVEMENTS $430,000.00 $30,30353 $21900 $399,696.47 7.05% PARK CAPITAL IMPROVEMENT $81,620.00 $24.21409 $1,70045 $57,405.91 29.67% EQUIPMENT REPLACEMENT $256,000.00 $93,498.07 $0.00 $162,501.93 36.52% LOCAL ROAD IMPROVEMENT F $637,00000 $394,720.61 $3,86200 $242,279.39 61.97% BIG MARINE SEWER FUND $240,90850 $151,679.97 $12,21207 $89,228.53 62.96% UPTOWN SEWER $22,44700 $6,138.95 $61665 $16,308.05 27.35% Report Total $3,966,787.50 $1,898,957.01 $152,863.27 $2,067,830.49 III, SCAPr TDIA CASH BALANCES 2020 END OF MONTH FUND JANUARY FEBRUARY MARCH APRIL MAY JUNE JULY AUGUST 101 GENERAL $1,241,912 $1,132,679 $1,034,252 $965,646 $874,738 $809,046 $1,515,430 $1,384,891 203 COVID-19 RELIEF $311,080 $311,080 226 CABLE TV $4,853 $6,424 $7,974 $9,558 $11,191 $11,232 $11,412 $13,060 230 RESTRICTED DONATIONS $175 $175 $175 $175 $175 $175 $175 $175 307 BLACKTOP 2007 $111 $111 $111 $111 $0 $0 $91 $91 313 EQUIPMENT CERTIFICATES $19,767 $19,767 $19,767 $19,767 $20,131 -$43,784 -$8,570 -$8,570 315 EQUIPMENT CERTIFICATES $16,352 $16,352 $16,352 $16,352 $16,611 -$26,884 -$4,802 -$4,802 317 EQUIPMENT CERTIFICATES -$2,544 -$2,544 -$2,544 -$2,544 -$2,347 -$2,347 -$17,877 -$17,877 318 BLACKTOP PROJECT -$7,413 -$7,413 -$7,413 -$63,495 -$63,495 -$63,495 $102,606 $102,606 401 CAPITAL IMPR $1,048,268 $1,048,998 $1,047,458 $1,028,529 $1,021,727 $1,017,727 $1,017,374 $1,017,155 404 PARK CAP IMPR $151,637 $151,939 $151,939 $151,939 $133,139 $131,854 $147,681 $145,980 406 EQUIPMENT REPLACEMENT $233,285 $139,787 $140,287 $153,787 $153,787 $153,787 $168,292 $168,292 408 LOCAL ROAD IMPROVEMENT $1,661,216 $1,650,960 $1,642,612 $1,631,801 $1,381,276 $1,282,393 $1,455,688 $1,451,826 602201 SEWER $94,211 $91,322 $5,431 $8,097 $14,487 $10,986 $10,808 $3,780 612 UPTOWN SEWER $18,727 $23,348 $22,265 $21,231 $24,447 $23,469 $22,949 $25,041 801 ESCROW $46,678 $44,931 $47,929 $50,534 $51,738 $38,580 $30,359 $30,697 SUBTOTAL $4,527,236 $4,316,836 $4,126,596 $3,991,489 $3,637,604 $3,342,739 $4,762,697 $4,623,427 225 EDA $23,206 $23,206 $23,206 $22,981 $22,881 $22,881 $25,299 $25,299 TOTAL $4,550,441 $4,340,041 $4,149,802 $4,014,470 $3,660,485 $3,365,620 $4,787,995 $4,648,726