Loading...
5.b Treasurer's ReporttiCr Beginning Balance 7/1/2017 Receipts Expenditures Payroll Adjustments: Ending Balance 7/31/2017 City of Scandia Treasurer's Report 7/31/2017 Ending Balance includes the following Investments: Checking *102 Money Market *105 - Rate .25% CD *3138 — Rate 1.20% 18 mo., 7/24/2018 CD *2920 — Rate 1.00% 12 mo., 1/24/2018 CD *2921— Rate 1.00% 12 mo., 12/19/2017 CD *4420 — Rate 1.00% 12 mo., 3/21/2018 Total Undesignated Funds Scandia EDA *6301 Total Designated Funds Checks in Transit Deposits in Transit Total Funds Submitted by: Colleen Firkus, Treasurer $ 2,643,452.50 $ 1,282,322.30 $ 187,584.31 $ 28,759.34 $ (216,343.65) $ 41,908.00 $ 1,154,955.64 $ 1,106,555.49 $ 502,482.53 $ 401,388.49 $ 501,260.27 $ 4,745.47 $ 3,709,431.15 $ 3,708,550.42 $ 4,745.47 $ (3,864.74) S $ 3,709,431.15 awCity of Scandia C ANDI A Expenditure Summary July 2017 2017 YTD Budget % of YTD GENERAL FUND 2017 YTD Budget 2017 YTD Amount 2017 MTD Amount Balance Budget Administration & Finance $342,600.00 $198,616.79 $22,942.04 $143,983.21 57.97% City Council $18,90000 $10,32791 $4,481.32 $8,572.09 54.65% Elections $1,300.00 $830.00 $0.00 $470.00 63.85% Planning & Building $149,000.00 $88,706.05 $17,988.97 $60,293.95 59.53% Police $120,500.00 $309.36 $0.00 $120,190.64 0.26% Fire Department $244,490.00 $91,296.98 $10,600.88 $153,193.02 37.34% Public Works $1,371,800 00 $864,989.80 $43,481.87 $506,810.20 63.06% Parks & Recreation $60,900.00 $33,994.47 $3,878.25 $26,905.53 55.82% Community Center $40,200.00 $18,92722 $2,706.05 $21,272.78 47.08% Total General Fund $2,349,690.00 $1,307,998.58 $106,079.38 $1,041,691.42 55.67% PUBLIC HOUSING $0.00 $0.00 000% EDA $0.00 $32500 0 -$32500 000% DEBT 2007 ROAD PROJECT BOND $77,000.00 $79,317.56 $0.00 -$2,317.56 0.00% 2010 EQUIPMENT CERTIFICATES $10,06000 $10,177.13 $000 -$117.13 101.16% 2011 EQUIPMENT CERTIFICATES $8,294.00 $8,311.93 $0.00 -$17.93 100.22% 2013 EQUIPMENT CERTIFICATES $65,06300 $60,917.50 $0.00 $4,145.50 93.63% 2015 EQUIPMENT CERTIFICATE $46,364.00 $46,418.50 $44,709.25 -$54.50 100.12% $206,781.00 $205,142.62 $44,709.25 $1,638.38 99.21% CAPITAL IMPROVEMENTS $266,700.00 $6,335.00 $6,33500 $260,365.00 2.38% PARK CAPITAL IMPROVEMENTS $44,900.00 $3,00316 $1,713.16 $41,896.84 6.69% EQUIPMENT REPLACEMENT $438,000.00 $39,132.50 $39,132.50 $398,86750 8.93% LOCAL ROAD IMPROVEMENT FUP $50,000.00 $5,95000 $5,950.00 $44,05000 11.90% 201 SEWER FUND $62,000.00 $31,958.30 $5,803.03 $30,041.70 51.55% UPTOWN SEWER $15.400.00 $7,542.82 $1,509.19 $7.857.18 49.98% Report Total $3,433,471.00 $1,607,387.98 $211,231.51 $1,826,083.02 46.82% CASH BALANCES 2017 END OF MONTH FUND JANUARY FEBRUARY MARCH APRIL MAY JUNE JULY 101 GENERAL $1,797,435 $1,628,261 $1,036,162 $994,496 $893,533 $733,026 $1,515,821 213 PUBIC HOUSING $0 $0 $0 $0 $0 $0 $0 225 EDA $5,070 $5,091 $5,091 $4,766 $4,766 $4,766 $7,247 307 BLACKTOP 2007 $79,092 $2,318 $0 $0 $0 $0 $9,155 311 EQUIPMENT CERTIFICATES $10,060 $117 $0 $0 $0 $0 $0 312 EQUIPMENT CERTIFICATES $8,284 $28 $0 $0 $0 $0 $0 313 EQUIPMENT CERTIFICATES $13,296 $13,341 $13,341 $13,341 -$47,142 -$47,142 -$13,394 315 EQUIPMENT CERTIFICATES $326 $331 $10,507 $10,507 $10,507 $10,507 -$10,013 401 CAPITAL IMPR $322,660 $326,803 $326,803 $326,803 $326,803 $326,803 $335,357 404 PARK CAP IMPR $20,380 $17,441 $17,441 $18,641 $19,391 $21,101 $19,388 406 EQUIPMENT REPLACEMENT $499,258 $501,061 $509,373 $509,373 $509,373 $509,373 $470,241 408 LOCAL ROAD IMPROVEMENT $373,833 $469,363 $976,537 $976,537 $976,537 $976,537 $1,268,631 602 201 SEWER $70,915 $67,025 $74,466 $76,884 $76,668 $83,495 $87,435 612 UPTOWN SEWER $5,226 $4,602 $3,530 $4,952 $5,477 $4,345 $2,836 801 ESCROW $35,342 $24,079 $19,963 $19,233 $18,435 $20,641 $16,729 TOTAL $3,241,177 $3,059,861 $2,993,213 $2,955,533 $2,794,348 $2,643,453 $3,709,431