Loading...
5.b June Treasurer's ReportBeginning Balance 6/1/2017 Receipts Expenditures Payroll Adjustments: Ending Balance 6/30/2017 City of Scandia Treasurer's Report 6/30/2017 Ending Balance includes the following Investments: $ 172,641.35 $ 25,618.00 $ 2,794,348.09 $ 47,363.76 $ (198,259.35) $ 2,643,452.50 Checking *102 $ 16,400.06 Money Market *105 - Rate .25% $ 121,951.91 CD *3138 — Rate 1.20% 18 mo., 7/24/2018 $ 1,103,254.79 CD *3136 — Rate .70% 6 mo., 7/24/2017 $ 400,000.00 CD *2920 — Rate 1.00% 12 mo., 1/24/2018 $ 501,232.88 CD *4420 — Rate 1.00% 12 mo., 3/21/2018 $ 501,260.27 Total Undesignated Funds $ 2,644,099.91 Scandia EDA *6301 $ 4,754.47 Total Designated Funds $ 4,745.47 Checks in Transit $ (5,392.88) Deposits in Transit S Total Funds $ 2,643,452.50 3. SCANDLA, LA, City of Scandia Expenditure Summary June 2017 2017 YTD Budget % of YTD GENERAL FUND 2017 YTD Budget 2017 YTD Amount 2017 MTD Amount Balance Budget Administration & Finance $342,600.00 $175,67475 $26,52091 $166,92525 51.28% City Council $18,90000 $5,84659 $0.00 $13,05341 30.93% Elections $1,300.00 $83000 $000 $47000 63.85% Planning & Building $149,000.00 $70,71708 $16,41384 $78,28292 4746% Police $120,50000 $309.36 $000 $120,19064 026% Fire Department $244,490.00 $80,69610 $19,37887 $163.79390 3301% Public Works $1,371,800 00 $821,50793 $117,78694 $550,29207 5989% Parks & Recreation $60,90000 $30,11622 $4,053.73 $30,78378 4945% Community Center $40,20000 $16,221 17 $2,50843 $23,97883 4035% Total General Fund $2,349,690.00 $1,201,919.20 $186,662.72 $1,147,770.80 5115% PUBLIC HOUSING $000 $000 000% EDA $000 $32500 0 -$32500 000% DEBT 2007 ROAD PROJECT BOND $77,00000 $79,31756 $000 -$2,31756 000% 2010 EQUIPMENT CERTIFICATES $10,06000 $10,17713 $000 -$117.13 10116% 2011 EQUIPMENT CERTIFICATES $8,294.00 $8,311 93 $000 -$17.93 10022% 2013 EQUIPMENT CERTIFICATES $65,06300 $60,91750 $000 $4,145.50 9363% 2015 EQUIPMENT CERTIFICATE $46,364.00 $1,709.25 50.00 $44,65475 369% $206,781.00 $160,433.37 $0.00 $46,347.63 77.59% CAPITAL IMPROVEMENTS $266,70000 $0.00 $000 $266,700.00 000% PARK CAPITAL IMPROVEMENTS $44,90000 $1,29000 $1,29000 $43,610.00 287% EQUIPMENT REPLACEMENT $438,000.00 $0.00 $000 $438.00000 000% LOCAL ROAD IMPROVEMENT FUP $50,00000 $000 $0.00 $50,00000 000% 201 SEWER FUND $62,00000 $26,15527 $4,06677 $35,84473 4219% UPTOWN SEWER $15,40000 $6,03363 $1,13241 $9,36637 3918% Report Total $3,433,471.00 $1,396,156.47 $193,151.90 $2,037,314.53 40.66% SC'ANDIA 2017 FUND 101 GENERAL 213 PUBIC HOUSING 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 APRIL END OF MONTH JUNE JANUARY FEBRUARY $1,797,435 $1,628,261 $0 $0 $5,070 $5,091 $79,092 $2,318 $10,060 $117 $8,284 $28 $13,296 $13,341 $326 $331 $322,660 $326,803 $20,380 $17,441 $499,258 $501,061 $373,833 $469,363 $70,915 $67,025 $5,226 $4,602 $35,342 $24,079 $3,241,177 $3,059,861 MARCH APRIL MAY JUNE $1,036,162 $994,496 $893,533 $733,026 $0 $0 $0 $0 $5,091 $4,766 $4,766 $4,766 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $13,341 $13,341 -$47,142 -$47,142 $10,507 $10,507 $10,507 $10,507 $326,803 $326,803 $326,803 $326,803 $17,441 $18,641 $19,391 $21,101 $509,373 $509,373 $509,373 $509,373 $976,537 $976,537 $976,537 $976,537 $74,466 $76,884 $76,668 $83,495 $3,530 $4,952 $5,477 $4,345 $19,963 $19,233 $18,435 $20,641 $2,993,213 $2,955,533 $2,794,348 $2,643,453