Loading...
5.b Treasurer's Sept 2018 Report,f1-, A� T h Beginning Balance 9/1/2018 Receipts Expenditures Payroll Adjustments: record CD interest Ending Balance City of Scandia Treasurer's Report 9/30/2018 9/30/2018 Ending Balance includes the following Investments: Checking *102 Money Market *105 - Rate .25% CD *2920 — Rate 1.80% 12 mo., 1/24/2019 CD *4420/4422 — Rate 1.90% 12 mo., 3/21/2019 CD *4424 - Rate 2.40% 12 mo., 7/25/2019 CD *4423/4425 - Rate 2.50% 2 mo., 9/28/2019 Total Undesignated Funds Scandia EDA *6301 Checks in Transit Deposits in Transit Total Designated Funds Total Funds Submitted by: Colleen Firkus, Treasurer $ 6,089,847.50 $ 83,627.27 $ 1,580,554.56 $ 24,802.43 $ (1,605,356.99) $ 5,413.79 $ 11,547.38 $ 2,607,407.54 $ 509,514.42 $ 302,880.30 $ 419,894.02 $ 700,000.00 $ 25564.07 $ 4,573,531.57 $ 4,551,243.66 $ 25,564.07 $ (3,276.16) S $ 4,573,531.57 dRihr City of Scandia r�T Expenditure Summary September 2018 2018 YTD Budget % of YTD GENERAL FUND 2018 YTD Budget 2018 YTD Amount 2018 MTD Amount Balance Budget Administration & Finance $364,00000 $273,016.34 $30,062.69 $90,983.66 75.00% City Council $19,50000 $9,388.62 $120.00 $10,111.38 48.15% Elections $6,20000 $3,050.73 $21800 $3,149.27 49.21% Planning & Building $126,30000 $116,392.65 $14,693.31 $9,907.35 92.16% Police $127,20000 $71,88996 $0.00 $55,310.04 56.52% Fire Department $271,500.00 $149,246.42 $46,97828 $122,253.58 54.97% Public Works $1,130,500.00 $800,573.21 $51,438.18 $329,926.79 70.82% Parks & Recreation $69,300.00 $52,36821 $6,61390 $16,931.79 75,57% Community Center $48,600.00 $30,577.37 $2,128.72 $18,022.63 62.92% Total General Fund $2,163,100.00 $1,506,503.51 $152,253.08 $656,596.49 69.65% EDA $800.00 $4,181.40 $0.00 -$3,381.40 000% GATEWAY DONATIONS $0.00 $5,000.00 $0.00 $0.00 000% CABLE TV $7.30000 $2,018.75 $0.00 $5,281.25 000% DEBT 2007 ROAD PROJECT BOND $14,20800 $18,149.86 $0.00 -$3,941.86 0.00% 2013 EQUIPMENT CERTIFICATES $64,50300 $60,07000 $0.00 $4,433.00 93.13% 2015 EQUIPMENT CERTIFICATE $45,801.00 $45,709.00 $0.00 $9200 99.80% 2017 EQUIPMENT CERTIFICATE $3_6,580.00 $35,921.34 $0.00 $658.66 98.20% $161,092.00 $159,850.20 $0.00 $1,241.80 99.23% CAPITAL IMPROVEMENTS $139,300.00 $191,955.00 $11,235.00 -$52,655,00 137.80% ROAD CONSTRUCTION $0.00 $3,293,151.56 $1,436,428.03 -$3,293,151.56 #DIV/O! PARK CAPITAL IMPROVEMENTS $18,220.00 $1,098.68 $251 74 $17,121.32 6.03% EQUIPMENT REPLACEMENT $155.04000 $229,837.23 $0.00 -$74,797.23 148.24% LOCAL ROAD IMPROVEMENT FUP $6,500,000 00 $3,617,704.51 $1,467,296.38 $2,882,295.49 55.66% 201 SEWER FUND $64.45000 $43,236.38 $3,26061 $21,213.62 67.09% UPTOWN SEWER $21,700.00 $9,24236 $581 17 $12,457.64 42.59% Report Total $9,231,002.00 $9,063,779.58 $3,071,306.01 $167,222.42 Val Sc l[tilIII,+ .� CASH BALANCES 2018 END OF MONTH FUND JANUARY FEBRUARY MARCH APRIL MAY JUNE JULY AUGUST SEPTEMBER 101 GENERAL $1,723,333 $1,505,745 $1,145,669 $1,024,689 $951,411 $895,700 $1,605,964 $1,462,641 $1,402,653 225 EDA $9,745 $29,745 $29,745 $25,920 $25,564 $25,564 $25,999 $25,999 $25,999 226 CABLE TV $0 $0 $0 $0 $0 41,869 -$2,019 -$806 $789 230 RESTRICTED DONATIONS $0 $3,450 $4,100 $4,175 $4,175 $4,175 $5,175 $175 $175 307 BLACKTOP 2007 $18,150 $18,150 $0 $0 $0 $0 -$8 -$8 -$8 313 EQUIPMENT CERTIFICATES $16,374 $16,374 $16,374 $16,374 -$43,696 -$43,696 47,365 -$7,365 -$7,365 315 EQUIPMENT CERTIFICATES $13,230 $13,230 $13,230 $13,230 $13,230 431,125 -$5,236 -$5,236 -$5,237 317 EQUIPMENT CERTIFICATES -$4,381 44,381 -$4,381 -$4,381 44,381 -$4,381 -$17,802 -$17,802 417,802 401 CAPITAL IMPR $351,214 $317,929 $623,569 $623,569 $623,569 $623,569 $628,757 $585,922 $580,687 402 ROAD CONSTRUCTION $0 $0 $0 $0 $0 $3,817,306 $2,944,421 $1,991,046 $554,619 404 PARK CAP IMPR $16,255 $19,805 $117,523 $117,823 $118,728 $118,779 $118,617 $118,326 $118,075 406 EQUIPMENT REPLACEMENT $447,501 $447,501 $447,501 $441,401 $440,927 $283,854 $300,182 $273,833 $276,983 408 LOCAL ROAD IMPROVEMENT $1,486,837 $1,474,864 $1,436,808 $1,357,919 $1,348,096 $904,974 $1,581,507 $1,543,658 $1,512,790 602201 SEWER $80,690 $75,782 $82,156 $60,280 $72,137 $81,662 $89,450 $85,114 $93,847 612 UPTOWN SEWER $5,740 $5,948 $2,473 $1,281 $4,923 $3,150 $2,328 $6,716 $6,135 801 ESCROW $12,750 $17,456 $16,466 $16,796 $17,846 $24,428 $20,010 $27,631 $31,190 TOTAL $4,177,438 $3,941,597 $3,931,233 $3,719,077 $3,572,532 $6,702,091 $7,289,981 $6,089,848 $4,573,531