Loading...
5.b. Treasurer's ReportaLig, SCANDIA Beginning Balance 08/01/2016 Receipts Expenditures Payroll Adjustments: duplicate receipt entry City of Scandia Treasurer's Report 8/31/2016 $ 290,702.43 $ 22,104.79 $ 3,026,894.97 $ 45,422.98 $ (312,807.22) $ (348.31) Ending Balance 8/31/2016 $ 2,759,162.42 Ending Balance includes the following Investments: Checking *102 Money Market *105 - Rate .25% CD *3136 — Rate .90%, 24 mo., 3/21/2017 CD *3137 — Rate .80% 18 mo., 1/21/2017 Total Undesignated Funds Scandia EDA *6301 Total Designated Funds Checks in Transit Deposits in Transit Total Funds Submitted by: Colleen Firkus, Treasurer $ 98,516.90 $ 2,122,679.42 $ 306,439.75 $ 317,779.47 $ 2,845,415.54 $ 5,070.47 $ 5,070.47 $ (91,323.59) $ 2,759,162.42 SCIADIIA City of Scandia Expenditure Summary August 2016 EQUIPMENT REPLACEMENT $315,00000 $0.00 $000 2016 YTD Budget % of YTD GENERAL FUND 2016 YTD Budget 2016 YTD Amount 2016 MTD Amount Balance Budget Administration & Finance $324,84800 $211,53627 $21,276.69 $113,31173 6512% City Council $26,976.00 $8,82652 $000 $18,14948 3272% Elections $6,150.00 $2,55828 $1,958.28 $3,591.72 4160% Planning & Building $96,206.00 $61,419.60 $9,57995 $34,78640 6384% Police $116,19700 $57,158.18 $56,848.82 $59,03882 4919% Fire Department $240,576.00 $85,695.02 $10,272.15 $154,880.98 3562% Public Works $1,197,153 00 $696,185.40 $104,337.04 $500,96760 5815% Parks & Recreation $60,87900 $37,02799 $8,28426 $23,851 01 6082% Community Center $40.26100 $22,348.61 $2.05896 $17.912.39 55.51% Total General Fund $2,109,246.00 $1,182,755.87 $214,616.15 $926,490.13 56.07% EDA $000 $325.00 $0.00 -$32500 000% DEBT 2010 EQUIPMENT CERTIFICATES $43,010.00 $40,710.00 $0.00 $2,300.00 9465% 2011 EQUIPMENT CERTIFICATES $31,185.00 $592.50 $000 $30,592.50 190% 2013 EQUIPMENT CERTIFICATES $65,82300 $60,895.00 $000 $4,92800 9251% 2015 EQUIPMENT CERTIFICATE $46,720.00 $47,020.50 $0.00 -$300.50 10064% $186,738.00 $149,218.00 $0.00 $37,520.00 79.91% CAPITAL IMPROVEMENTS $40,00000 $2,37000 $000 $37,630.00 593% PARK CAPITAL IMPROVEMENTS $38,50000 $000 $000 $38,50000 0.00% EQUIPMENT REPLACEMENT $315,00000 $0.00 $000 $315,000.00 000% LOCAL ROAD IMPROVEMENT FUP $1,250,000.00 $903,54636 $82,871 67 $346,45364 7228% 201 SEWER FUND $50,73000 $39,72542 $7,16846 $11,00458 78.31% UPTOWN SEWER $16,03500 $9,75980 $74975 $6,27520 6087% Report Total $4,006,249.00 $2,287,700.45 $305,406.03 $1,718,548.55 57.10% SCA \ D I A 2016 FUND 101 GENERAL 225 EDA 307 BLACKTOP 2007 311 EQUIPMENT CERTIFICATES 312 EQUIPMENT CERTIFICATES 313 EQUIPMENT CERTIFICATES 315 EQUIPMENT CERTIFICATES 401 CAPITAL IMPR 404 PARK CAP IMPR 406 EQUIPMENT REPLACEMENT 408 LOCAL ROAD IMPROVEMENT 602 201 SEWER 612 UPTOWN SEWER 801 ESCROW TOTAL CASH BALANCES END OF MONTH JANUARY FEBRUARY $1,737,452 $1,639,251 $5,395 $5,395 $42,934 $42,934 $12,360 $12,360 $6,735 $6,735 $10,521 $10,086 $0 -$2,010 $290,627 $289,390 $15,188 $15,188 $470,608 $470,608 $444,981 $402,956 $58,473 $47,447 -$5,307 $2,640 $101,798 $83,597 $3,191,766 $3,026,576 MARCH APRIL MAY JUNE JULY AUGUST $1,548,904 $1,483,118 $1,429,801 $1,344,311 1,776,519 $1,602,522 $5,396 $5,070 $5,070 $5,070 5,070 $5,070 $42,934 $57,829 $58,187 $58,187 67,914 $67,914 $12,360 $12,360 $12,360 $12,360 12,360 $12,360 $6,735 $6,735 $6,143 $6,143 22,510 $22,510 $10,086 $10,086 $10,086 -$50,809 -15,828 -$15,828 -$2,010 -$2,010 -$2,010 -$47,021 -23,643 -$23,643 $289,270 $289,270 $287,020 $287,020 307,660 $307,660 $15,280 $16,030 $20,230 $20,380 17,380 $17,380 $499,258 $499,258 $499,258 $499,258 499,258 $499,258 $395,563 $392,240 $389,808 $97,790 227,821 $144,949 $51,642 $56,707 $52,283 $57,774 65,817 $59,736 $1,101 -$957 $1,717 $680 2,110 $2,091 $74,737 $66,746 $62,945 $60,808 61,947 $57,185 $2,951,256 $2,892,481 $2,832,898 $2,351,951 $3,026,895 $2,759,162