Loading...
5.b Treasurer's Report January 2018aGg i"O, CAN II I A Beginning Balance 01/01/18 Receipts Expenditures Payroll Adjustments: City of Scandia Treasurer's Report 1/31/2018 $ 162,434.51 $ 31,775.06 $ 4,320,907.66 $ 50,739.75 $ (194,209.57) Ending Balance 1/31/2018 $ 4,177,437.84 Checking *102 $ 67,636.32 Money Market *105 - Rate .25% $ 1,609,891.16 CD *3138 — Rate 1.20% 18 mo., 7/24/2018 $ 1,113,259.51 CD *2920 — Rate 1.00% 12 mo., 1/24/2018 $ 505,018.78 CD *4420 — Rate 1.00% 12 mo., 3/21/2018 $ 503,776.59 CD *4421— Rate 1.35% 9 mo., 9/19/2018 $ 402,496.98 Total Undesignated Funds $ 4,202,079.34 Scandia EDA *6301 $ 9,391.89 Total Designated Funds $ 9,391.89 Checks in Transit $ (34,030.39) Select Account in process $ (3.00) Total Funds $ 4,177,437.84 Submitted by: Colleen Firkus, Treasurer 4 _ City of Scandia SCIANDI A Expenditure Summary Gomm January 2018 2018 YTD Budget % of YTD GENERAL FUND 2018 YTD Budget 2018 YTD Amount 2018 MTD Amount Balance Budget Administration & Finance $364,000.00 $16,269.45 $16,269.45 $347,730.55 4.47% City Council $19,500.00 -$002 -$0.02 $19,50002 0.00% Elections $6,200.00 $0.00 $000 $6,200.00 0.00% Planning & Building $126,30000 $1,283.43 $1,283.43 $125,016.57 1.02% Police $127,200.00 -$64,60054 -$64,600.54 $191,800.54 -50.79% Fire Department $271,500.00 -$5,708.94 -$5,708.94 $277,20894 -210% Public Works $1,130,500.00 $26,857.46 $26,857.46 $1,103,642.54 2.38% Parks & Recreation $69,30000 $4,835.05 $4,835.05 $64,46495 698% Community Center $46,300.00 $689.00 $689.00 }45,611.00 1.49% Total General Fund $2,160,800.00 -$20,375.11 -$20,375.11 $2,181,175.11 -0.94% EDA $80000 $0.00 $0.00 $80000 0.00% DEBT 2007 ROAD PROJECT BOND $14,208.00 $000 $000 $14,208.00 000% 2013 EQUIPMENT CERTIFICATES $64,50300 $0.00 $435.00 $64,503.00 0.00% 2015 EQUIPMENT CERTIFICATE $45,801.00 $1,354.50 $1,35450 $44,446.50 296% 2017 EQUIPMENT CERTIFICATE $36,580.00 $1,881 34 $1,881.34 $34,698.66 5.14% $161,892.00 $3,235.84 $3,670.84 $158,656.16 2.00% CAPITAL IMPROVEMENTS $139,300.00 $000 $000 $139,300.00 000% PARK CAPITAL IMPROVEMENTS $18,220.00 $000 $000 $18,220.00 0.00% EQUIPMENT REPLACEMENT $115,500.00 $30,301 00 $30,301 00 $85,19900 2623% LOCAL ROAD IMPROVEMENT FUP $6,500,000.00 -$11,943.50 -$11,94350 $6,511,943.50 -0.18% 201 SEWER FUND $64,450.00 $2,061.07 $2,061.07 $62,388.93 320% UPTOWN SEWER $21.700.00 $ 1,247.12 11,247 12 $20,452.BB 5.75% Report Total $9,182,662.00 $4,526.42 $4,961.42 $9,178,135.58 0.05% SCANDILA CASH BALANCES 2018 END OF MONTH FUND JANUARY 101 GENERAL $1,723,333 225 EDA $9,745 307 BLACKTOP 2007 $18,150 313 EQUIPMENT CERTIFICATES $16,374 315 EQUIPMENT CERTIFICATES $13,230 317 EQUIPMENT CERTIFICATES -$4,381 401 CAPITAL IMPR $351,214 404 PARK CAP IMPR $16,255 406 EQUIPMENT REPLACEMENT $447,501 408 LOCAL ROAD IMPROVEMENT $1,486,837 602 201 SEWER $80,690 612 UPTOWN SEWER $5,740 801 ESCROW $12,750 TOTAL $4,177,438