Loading...
5.b) Treasurer's Report �� � d� , _ �, �: SCANDL� City of Scandia Treasurer's Report August 31, 2009 Beginning Balance 08/Ol/09 1,544,498.47 Receipts 176,650.94 Expenditures 67,375.67 Payroll 19,954.55 - 87.330.22 Adjustments: Reverse Bank Charges +80.39 Voided Check +75.00 Ending Balance 08/31/09 1,633,974.58 Submitted by: Colleen Firkus, Treasurer CITY OF SCANDIA 09/03/09 *Expenditure Guideline Sum Current Period:August 2009 2009 2009 August Enc %of YTD Budget YTD Amt MTD Amt Current Balance Budget GENERAL FUND Administration 8 Finance $347,719.00 $217,568.72 $21,822.47 $0.00 $130,150.28 62.57% City Council $19,883.00 $9,820.52 $0.00 $0.00 $10,062.48 49.39°/a Elections $495.00 $470.00 $0.00 $0.00 $25.00 94.95°/a Planning 8 Building $200,327.00 $72,059.33 $9,113.80 $0.00 $128,267.67 35.97% Police $117,366.00 $0.38 $0.00 $0.00 $117,365.62 0.00°/a Fire Dept $331,925.00 $146,549.13 $6,906.59 $0.00 $185,375.87 44.15% Public Works $586,271.00 $196,334.91 $23,311.81 $0.00 $389,936.09 33.49% Sewer 8 Water $27,330.00 $9,707.35 $654.73 $0.00 $17,622.65 35.52% Parks 8 Recreation $67,445.00 $43,438.67 $2,834.37 $0.00 $24,006.33 64.41% Community Center $56,651.00 $26,205.97 $3,314.56 $0.00 $30,445.09 46.26% Total GENERAL FUND $1,755,412.00 $722,154.92 $67,958.33 $0.00 $1,033,257.08 41.14% BLACKTOP PROJECT 2004 DebtService $247,920.00 $247,920.00 $0.00 $0.00 $0.00 100.00°/a Totel BLACKTOP PROJECT 2004 $247,920.00 $247,920.00 $0.00 $0.00 $0.00 100.00% BLACKTOP PROJECCT 2007 DebtService $181,038.00 $23,018.75 $0.00 $0.00 $158,019.25 12.71% Totel BLACKTOPPROJECCT 2007 $181,038.00 $23,018.75 $0.00 $0.00 $158,019.25 12.71% FIREHALUPUBLIC WORKS BOND DebtService $111,140.00 $13,495.00 $0.00 50.00 $97,645.00 12.14°/a Total FIREHALUPUBUC WORKS BOND $111,140.00 $13,495.00 $0.00 $0.00 $97,645.00 12.14% CAPITAL IMPROVEMENTS Capitallmprovements $23,000.00 $0.00 $0.00 $0.00 $23,000.00 0.00% Total CAPITAL IMPROVEMENTS $23,000.00 $0.00 $0.00 $0.00 $23,000.00 0.00% PARK ACQUISITION AND DEV Capitallmprovements $40,000.00 $10,787.13 $8,554.77 $0.00 $29,212.87 26.97% Total PARK ACQUISITION AND DEV $40,000.00 $10,787.13 $8,554.77 $0.00 $29,212.87 26.97% EQUIPMENT REPLACEMENT Capitallmproveme�ts $0.00 $0.00 $0.00 $0.00 $0.00 0.00% Equipment Replacement $25,000.00 $19,034.38 $0.00 $0.00 $5,965.62 76.14% Total EQUIPMENT REPLACEMENT $25,000.00 $19,034.38 $0.00 $0.00 $5,965.62 76.14% 201 SEWER FUND Sewer 8 Water $66,329.00 $15,684.86 $9,169.54 $0.00 $50,644.14 23.65% Total 201 SEWER FUND $66,329.00 $15,684.86 $9,169.54 $0.00 $50,644.14 23.65% ReportTotal $2,449,839.00 $1,052,095.04 $85,682.64 $0.00 $1,397,743.96 42.95% . .����� C_��f• SCANLIIA,. „ , � CASH BALANCES 2009 END OF MONTH FUND JANUARY FEBRUARY MARCH APRIL MAY JUNE JULY AUGUST 101 GENERAL 579,977 471,002 323,188 255,164 174,659 145,666 739,357 708,303 302 Blacktop 2002 136,031 136,031 140,803 0 0 0 0 304 Blacktop 2004 176,018 176,018 158,411 162,685 162,685 162,685 -16,480 -16,480 307 Blacktop 2007 -�eo,131 -180,131 -304,739 23,444 22,304 22,304 125,578 125,578 310 Fire Hall/Public Works Bond 159,�3a �59,�34 �s3,98a �5a,o72 �54,072 �5a,o72 207,0�2 207,072 401 CAPITAL IMPR 205,280 205,280 207,371 212,1ao 212,140 212,140 212,1ao 212,1ao 402 ROAD CONSTRUCTION 51,662 51,662 19�,0�� 0 0 0 0 0 403 SANCTUARY RD IMPR -19,925 -19,926 -19,925 -19,925 -19,926 -19,926 -19,926 -�9,926 404 PARK CAP IMPR 34,681 34,681 34,681 35,579 35,579 35,579 33,347 $32,292 406 EQUIPMENT REPLACEMENT a9,o�� a9,o�7 a9,on 50,0�� 50,0�� 50,5�� ��,a82 $��,a82 602 201 SEVNER 117,599 110,023 118,805 126,716 126,002 131,409 140,183 $131,692 801 ESCROW 48,777 46,777 62,027 62,027 62,027 56,825 51,825 $181,821 TOTAL 1,358,180 1,239,628 1,130,754 1,061,920 979,560 951,271 1,544,579 1,633,975 ;� CITY OF SCANDIA 09/03/09 2:52 PM '• .. Page 1 ; �,� .� � � ,,� Cash Balances �., � �_ '. ��. " -u � " ' Current Period:August 2009 MTD MTD Current � FUND Descr Account Debit Credit Balance � Cash ' I GENERAL FUND G 101-10100 $41,822 22 $72,951 91 $708,302 85 � DEBT SERVICE G 301-10100 $0 00 $0 00 $0.00 � BLACKTOP PROJECT 2002 G 302-10100 $0 00 $OAO -$0 50 � BLACKTOP PROJECT 2004 G 304-10100 $0.00 $0 00 -$16,479 58 � BLACKTOP PROJECCT 2007 G 307-10100 $0.00 $0.00 $125,577.53 � FIREHALL/PUBLIC WORKS BOND G 310-10100 $0.00 $0.00 $207,071.67 � CAPITAL IMPROVEMENTS G 401-10100 $0.00 $0.00 $212,140.26 � ROAD CONSTRUCTION G 402-10100 $0.00 $0 00 $0.00 � SANCTUARY G 403-10100 $0 00 $0 00 -$19,925.50 � PARK ACQUISITION AND DEV G 404-10100 $7,500.00 $8,554.77 $32,292 35 � EQUIPMENT REPLACEMENT G 406-10100 $0 00 $0 00 $71,482.26 � 201 SEWER FUND G 602-10100 $678.72 $9,169.54 $131,692.24 � ESCROW G 801-10100 $150,250.00 $20,254.00 $181,821.00 � Total Cash $200,25094 $110,930.22 $1,633,974.58 � INVESTMENT IN ESCROW � BLACKTOP PROJECT 2004 G 304-10200 $0.00 $0 00 $0.00 � Total INVESTMENT IN ESCROW $0 00 $0 00 $0.00 � Investments � GENERAL FUND G 101-10400 $0.00 $0 00 $0.00 � Total Investments $0.00 $0.00 $0.00 � Misc Receivables � GENERAL FUND G 101-10425 $0.00 $0.00 $0.00 � DEBT SERVICE G 301-10425 $0 00 $0-00 $0.00 � BLACKTOP PROJECT 2002 G 302-10425 $0.00 $0 00 $0.00 � BLACKTOP PROJECT 2004 G 304-10425 $0.00 $0.00 $0.00 � BLACKTOP PROJECCT 2007 G 307-10425 $0.00 $0.00 $0.00 � FIREHALL/PUBLIC WORKS BOND G 310-10425 $0.00 $0.00 $0.00 � ROAD CONSTRUCTION G 402-10425 $0 00 $0.00 $0 00 � SANCTUARY G 403-10425 $0.00 $0 00 $0.00 � PARK ACQUISITION AND DEV G 404-10425 $0 00 $0 00 $0 00 � 201 SEWER FUND G 602-10425 $0.00 $0.00 $0 00 � Total Misc Receivables $0.00 $0 00 $0 00 � ACCRUED INTEREST RECEIVABLE � GENERAL FUND G 101-10430 $0.00 $0 00 $0.00 � BLACKTOP PROJECCT 2007 G 307-10430 $0 00 $0 00 $0.00 � FIREHALL/PUBUC WORKS BOND G 310-10430 $0.00 $0 00 $OAO � ROAD CONSTRUCTION G 402-10430 $0.00 $0 00 $OAO � SANCTUARY G 403-10430 $0.00 $0.00 $0.00 � Total ACCRUED INTEREST RECEIVABLE $0.00 $0 00 $0.00 � Interest Receivable on Invest � GENERAL FUND G 101-10450 $OAO $0 00 $0.00 � Total Interest Receivable on Invest $0.00 $0 00 $0.00 �