Loading...
6.b Treasurer's Report - July 2020Beginning Balance 7/1/2020 Receipts Expenditures Payroll Transfers Adjustments: City of Scandia Treasurer's Report 7/31/2020 $ 3,389,595.50 $ 5,009,690.02 $ 3,515,327.38 $ 32,945.73 $ 50,000.00 $ (3,598,273.11) Ending Balance 7/31/2020 $4,801,012.41 Ending Balance includes the following Investments: Checking *102 Beg Bal $ 108,298.64 Credits $ 1,709,239.92 Debits $ (269,394.25) End Bal $ 1,548,144.31 Money Market *105 - Rate .25% Beg Bal $ 1,274,392.51 rate change from 1.25% Credits $ 17,235.86 Debits $ (50,000.00) End Bal $ 1,241,628.37 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,801,012.41 Checks in Transit *3102 $ (38,315.72) Deposit in transit $ - Total Adjusted Undesignated Funds $ 4,762,696.69 Scandia EDA *6301 Bal 6/30/19 $ 22,880.76 Receipts $ 2,418.00 Expenditures $ - Checks in Transit $ Deposit in Transit Total Designated Funds $ 25,298.76 Total Funds $ 4,787,995.45 Submitted by: Colleen Firkus, Treasurer I" CASH BALANCES 2020 END OF MONTH FUND JANUARY FEBRUARY MARCH APRIL MAY JUNE JULY 101 GENERAL $1,241,912 $1,132,679 $1,034,252 $965,646 $874,738 $809,046 $1,515,430 203 COVID-19 RELIEF $311,080 226 CABLE TV $4,853 $6,424 $7,974 $9,558 $11,191 $11,232 $11,412 230 RESTRICTED DONATIONS $175 $175 $175 $175 $175 $175 $175 307 BLACKTOP 2007 $111 $111 $111 $111 $0 $0 $91 313 EQUIPMENT CERTIFICATES $19,767 $19,767 $19,767 $19,767 $20,131 -$43,784 -$8,570 315 EQUIPMENT CERTIFICATES $16,352 $16,352 $16,352 $16,352 $16,611 -$26,884 -$4,802 317 EQUIPMENT CERTIFICATES -$2,544 -$2,544 -$2,544 -$2,544 -$2,347 -$2,347 -$17,877 318 BLACKTOP PROJECT -$7,413 -$7,413 -$7,413 -$63,495 -$63,495 -$63,495 $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 404 PARK CAP IMPR $151,637 $151,939 $151,939 $151,939 $133,139 $131,854 $147,681 406 EQUIPMENT REPLACEMENT $233,285 $139,787 $140,287 $153,787 $153,787 $153,787 $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 602 201 SEWER $94,211 $91,322 $5,431 $8,097 $14,487 $10,986 $10,808 612 UPTOWN SEWER $18,727 $23,348 $22,265 $21,231 $24,447 $23,469 $22,949 801 ESCROW $46,678 $44,931 $47,929 $50,534 $51,738 $38,580 $30,359 SUBTOTAL $4,527,236 $4,316,836 $4,126,596 $3,991,489 $3,637,604 $3,342,739 $4,762,697 SCANDIA GENERALFUND Administration & Finance" City Council Elections Planning & Building Police Fire Department Public Works Parks & Recreation Community Center Total General Fund COVID-19 RELIEF EDA CABLE TV GATEWAY DONATIONS DEBT 2007 ROAD PROJECT BOND 2013 EQUIPMENT CERTIFICATI 2015 EQUIPMENT CERTIFICATI 2017 EQUIPMENT CERTIFICATI 2018 BLACKTOP CAPITAL IMPROVEMENTS ROAD CONSTRUCTION PARK CAPITAL IMPROVEMENT EQUIPMENT REPLACEMENT LOCALROADIMPROVEMENTF 201 SEWER FUND UPTOWN SEWER City of Scandia Expenditure Summary $1,816,414.00 $000 $800.00 $8,92000 $0.00 $0.00 $66,56000 $43,99500 $34,948.00 $327,17500 $472,678.00 $430,000.00 $000 $81,62000 $256,00000 $637,00000 $135,57500 $22.44700 $862,707.17 $311,080.00 $32500 $3,080.51 $0.00 $0.00 $63,915.00 $43,494.50 $34.54400 $56,08251 $198,036.01 $30,08453 $0.00 $22,51364 $93,49807 $390,85861 $139,467.90 $5,522.30 $196,103.21 $311,080.00 $0.00 $1,432.02 $000 $000 $0.00 $000 $33,272.00 $0.00 $33,272.00 $353.00 $000 $1,92794 $0.00 $11,17038 $3,20035 $519.39 $953,706.83 47.50% July -20 $47500 0.00% $5,83949 0.00% $0.00 0.00% $000 0.00% 2020 YTD Budget % of YTD 2020 YTD Budget 2020 YTD Amount 2020 MTD Amount Balance Budget $404,60000 $233,16517 $36,954.52 41.90% $171,43483 5763% $21,000.00 $9,297 16 $4,68983 $11,70284 44.27% $6.40000 $2,48946 $000 $3,910.54 3890% $131,40000 $53,20254 $15,701 57 $78,197.46 40.49% $139,10000 $69,73850 $69,377.14 $69,361 50 50.14% $296,114.00 $125,80000 $22,16986 $170,314.00 4248% $690,70000 $296,851 14 $38,001 81 $393,84886 42.98% $77,600.00 $50,322.45 $6,59410 $27,277.55 6485% $49,50000 $21,84075 $2,61438 $27,65925 44 12% $1,816,414.00 $000 $800.00 $8,92000 $0.00 $0.00 $66,56000 $43,99500 $34,948.00 $327,17500 $472,678.00 $430,000.00 $000 $81,62000 $256,00000 $637,00000 $135,57500 $22.44700 $862,707.17 $311,080.00 $32500 $3,080.51 $0.00 $0.00 $63,915.00 $43,494.50 $34.54400 $56,08251 $198,036.01 $30,08453 $0.00 $22,51364 $93,49807 $390,85861 $139,467.90 $5,522.30 $196,103.21 $311,080.00 $0.00 $1,432.02 $000 $000 $0.00 $000 $33,272.00 $0.00 $33,272.00 $353.00 $000 $1,92794 $0.00 $11,17038 $3,20035 $519.39 $953,706.83 47.50% -$311,080 00 $47500 0.00% $5,83949 0.00% $0.00 0.00% $000 0.00% $2,645.00 96.03% $50050 9886% $404.00 9884% $271,092.49 1714% $274,641.99 41.90% $399,915.47 700% $0.00 #DIV/0! $59,106.36 2758% $162,50193 36.52% $246,141.39 61.36% -$3,89290 10287% $16,924.70 24.60% Report Total $3,861,454.00 $1,746,093.74 $247,978.29 $2,115,360.26