Loading...
5.b) Treasurer's ReportCHECKBOOK RECONCILATION SECURITY STATE BANK ACCT. #0191555102 2014 GL Beg Bal $2,748,726.11 Receipts $65,447.42 Expenditures $73,182.22 Payroll $26,321.41 -$99,503 63 Adjustments State Surcharges-$1,701.05 GL End Bal Bank $2,712,968.85 Adj Bank Bal $9,736.10 New Balance $17,501.80 Investments $2,698,227.32 Deposits in Transit Checks in Transit-$7,765.70 Savings (Childers Credit $5,005.86 Savings (Childers Credit $5,005.86 Investments $2,698,227.32 Total $2,712,969.28 Total $2,712,969.28 Difference Journal Entry rounding -$0.43 kAN'DIA Beginning Balance 04/01/2014 Receipts Expenditures Payroll Adjustments: State Surcharges Ending Balance 4/30/2014 City of Scandia Treasurer's Report April 30, 2014 $ 73,182.22 $ 26,321.41 $ 2,748,726.11 $ 65,447.42 -$ 99,503.63 -$ 1,701.05 $ 2,712,968.85 ********************************************************* Ending Balance includes the following Investments: Money Market - Rate .25% $ 1,958,620.47 Savings *3110 — Rate .05% $ 5,005.86 (Childers Credit) CD *3134 — Rate .40%, 18 mo., 8/05/2015 $ 124,426.96 (Quinnell) CD *3136 — Rate .50%, 24 mo., 3/21/2015 $ 301,502.82 CD *3137 — Rate .40% 18 mo., 7/21/2015 $ 313,677.07 Submitted by: Colleen Firkus, Treasurer GENERALFUND Administration & Finance City Council Elections Planning & Building Police Fire Dept Public Works Sewer Parks & Recreation Community Center Total GENERAL FUND DEBT SERVICE BLACKTOP PROJECT 2007 FIREHALL/PUBLIC WORKS BOND 2010 EQUIPMENT CERTIFICATES 2011 EQUIPMENT CERTIFICATES 2013 EQUIPMENT CERTIFICATES Total Debt Service CITY OF SCANDIA Expenditure Summary April 2014 2014 2014 April 2014 % of YTD YTD Budget YTD Amt MTD Amt YTD Balance Budget $344,543.00 $93,810.54 $27,871.22 $250,732.46 27.23% $18,839.00 $4,916.77 $4,709.76 $13,922.23 26.10% $6,110.00 $470.00 $0.00 $5,640.00 7.69% $166,200.00 $938.08 -$1,397.56 $165,261.92 0.56% $122,068.00 $309.74 $0.00 $121,758.26 0.25% $309,404.00 $134,378.97 $12,238.03 $175,025.03 43.43% $1,076,097.00 $420,670.74 $31,770.66 $655,426.26 39.09% $0.00 $0.00 $0.00 $0.00 0.00% $56,031.00 $19,288.09 $1,710.50 $36,742.91 34.42% $39,707.00 $12,328.83 $3,499.40 $27,378.17 31.05% $2,138,999.00 $687,111.76 $80,402.01 $1,451,887.24 32.12% $150,388.00 $0.00 $0.00 $150,388.00 0.00% $41,640.00 $0.00 $0.00 $41,640.00 0.00% $43,330.00 $41,960.00 $0.00 $1,370.00 96.84% $33,300.00 $0.00 $0.00 $33,300.00 0.00% $66,460.00 $0.00 $0.00 $66,460.00 0.00% $335,118.00 $41,960.00 $0.00 $293,158.00 CAPITAL IMPROVEMENTS $68,250.00 $13,464.69 $6,652.34 $54,785.31 19.73% PARK CAPITAL IMPROVEMENTS $47,500.00 $0.00 $0.00 $47,500.00 0.00% EQUIPMENT REPLACEMENT $200,000.00 $0.00 $0.00 $200,000.00 0,00% 201 SEWER FUND $173,096.00 $12,003.13 $2,652.38 $161,092.87 6.93% UPTOWN SEWER $20,680.00 $3,939.47 $718.70 $16,740.53 19.05% Report Total $2,983,643.00 $758,479.05 $90,309.77 $2,225,163.95 25.42% ��: SGANDIA CASH BALANCES 2014 END OF MONTH FUND JANUARY FEBRUARY MARCH APRIL 101 GENERAL $1,470,985 $1,332,163 $1,030,717 $1,007,024 307 BLACKTOP 2007 $252,830 $261,576 $261,576 $261,575 310 FIRE HALL/PUBLIC WORKS BOND $12,367 $18,555 $18,555 $18,555 311 EQUIPMENT CERTIFICATES $2,370 $4,774 $6,874 $6,875 312 EQUIPMENT CERTIFICATES $3,810 $5,520 $3,420 $3,420 313 EQUIPMENT CERTIFICATES -$10,825 -$10,825 $5,291 $5,291 401 CAPITAL IMPR $229,882 $224,526 $223,771 $217,119 404 PARK CAP IMPR $7,956 $7,984 $7,984 $7,984 406 EQUIPMENT REPLACEMENT $643,815 $644,474 $628,358 $628,358 408 LOCAL ROAD IMPROVEMENT $0 $0 $200,000 $200,000 602 201 SEWER $180,286 $177,762 $185,889 $187,598 612 UPTOWN SEWER -$595 -$1,384 -$4,975 -$3,496 801 ESCROW $211,708 $188,920 $181,268 $174,368 TOTAL $3,004,588 $2,854,045 $2,748,726 $2,714,670