Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
5.b Treasurer's Report
a U)9, SCANDILA Beginning Balance 09/01/2016 Receipts Expenditures Payroll Adjustments duplicate receipt entry Ending Balance 9/30/2016 City of Scandia Treasurer's Report 9/30/2016 Ending Balance includes the following Investments: $ 184,864.79 $ 21,612.90 $ 2,759,162.42 $ 30,235.78 $ - (206,477.69) $ 2,582,920.51 Checking *102 $ 116,561.67 Money Market *105 - Rate .25% $ 1,944,454.86 CD *3136 — Rate .90%, 24 mo., 3/21/2017 $ 307,134.91 CD *3137 — Rate .80% 18 mo., 1/21/2017 $ 317,779.47 Total Undesignated Funds $ 2,685,930.91 Scandia EDA *6301 $ 5,070.47 Total Designated Funds $ 5,070.47 Checks in Transit $ (108,080.87) Deposits in Transit S Total Funds $ 2,582,920.51 Submitted by: Colleen Firkus, Treasurer SCANDILA City of Scandia Expenditure Summary Sep -16 2016 YTD Budget % of YTD GENERAL FUND 2016 YTD Budget 2016 YTD Amount 2016 MTD Amount Balance Budget Administration & Finance $324,84800 $237,21725 $25,68098 $87,63075 7302% City Council $26,97600 $8,82652 $000 $18,149.48 3272% Elections $6,150.00 $2,55828 $0.00 $3,59172 41.60% Planning & Building $96,20600 $71,81815 $10,398.55 $24,38785 7465% Police $116,19700 $57,158.18 $0.00 $59,03882 4919% Fire Department $240,57600 $102,34758 $16,652.56 $138,228.42 4254% Public Works $1,197,153 00 $823,63070 $127,445.30 $373,522.30 68.80% Parks & Recreation $60,87900 $40,018.08 $2,990.09 $20,86092 65.73% Community Center $40,26100 $24,103.61 $1,75500 $16,157.39 59.87% Total General Fund $2,109,246.00 $1,367,678.35 $184,922.48 $741,567.65 64.84% EDA $000 $325.00 $0.00 -$32500 000% DEBT 2010 EQUIPMENT CERTIFICATES $43,01000 $40,71000 $000 $2,300.00 94.65% 2011 EQUIPMENT CERTIFICATES $31.18500 $592.50 $0.00 $30,592.50 1.90% 2013 EQUIPMENT CERTIFICATES $65,82300 $60,89500 $0.00 $4,928.00 92.51% 2015 EQUIPMENT CERTIFICATE $46.72000 $47,02050 $0.00 -$30050 100.64% $186,738.00 $149,218.00 $0.00 $37,520.00 79.91% CAPITAL IMPROVEMENTS $40,00000 $2,37000 $0.00 $37,630.00 5.93% PARK CAPITAL IMPROVEMENTS $38,500.00 $000 $0.00 $38,50000 000% EQUIPMENT REPLACEMENT $315,000.00 $0.00 $0.00 $315,000.00 000% LOCAL ROAD IMPROVEMENT FUP $1,250,000.00 $914,855.86 $11,30950 $335,144.14 73.19% 201 SEWER FUND $50,730.00 $41,701 88 $1,97646 $9,02812 8220% UPTOWN SEWER $16,035.00 $10,55558 $79578 $5.47942 65.83% Report Total $4,006,249.00 $2,486,704.67 $199,004.22 $1,519,544.33 62.07% SCANDrAr 2016 FUND 101GENERAL 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 602201 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 SEPTEMBER $1,548,904 $1,483,118 $1,429,801 $1,344,311 1,776,519 $1,602,522 $1,432,269 $5,396 $5,070 $5,070 $5,070 5,070 $5,070 $5,070 $42,934 $57,829 $58,187 $58,187 67,914 $67,914 $67,914 $12,360 $12,360 $12,360 $12,360 12,360 $12,360 $12,360 $6,735 $6,735 $6,143 $6,143 22,510 $22,510 $22,510 $10,086 $10,086 $10,086 -$50,809 -15,828 -$15,828 -$15,828 -$2,010 42,010 -$2,010 -$47,021 -23,643 -$23,643 -$23,643 $289,270 $289,270 $287,020 $287,020 307,660 $307,660 $307,660 $15,280 $16,030 $20,230 $20,380 17,380 $17,380 $17,380 $499,258 $499,258 $499,258 $499,258 499,258 $499,258 $499,258 $395,563 $392,240 $389,808 $97,790 227,821 $144,949 $133,640 $51,642 $56,707 $52,283 $57,774 65,817 $59,736 $67,812 $1,101 -$957 $1,717 $680 2,110 $2,091 $1,295 $74,737 $66,746 $62,945 $60,808 61,947 $57,185 $55,225 $2,951,256 $2,692,481 $2,832,698 $2,351,951 $3,026,695 $2,759,162 $2,582,921