Loading...
5.b July 2018 Treasurer's Report'Pao", Q,CI A NTT-Io Beginning Balance 7/1/2018 Receipts Expenditures Payroll Adjustments: JE Tax Settlement City of Scandia Treasurer's Report 7/31/2018 $ 6,702,091.07 $ 62,656.06 $ 730,333.24 $ 29,200.92 $ (759,534.16) $ 1,284,767.69 Ending Balance 7/31/2018 $ 7,289,980.66 Ending Balance includes the following Investments: Checking *102 $ 79,097.99 Money Market *105 - Rate .25% $ 4,900,554.50 CD *2920 — Rate 1.80% 12 mo., 1/24/2019 $ 509,514.42 CD *4421/2921— Rate 1.35% 9 mo., 9/19/2018 $ 402,496.98 CD *4420/4422 — Rate 1.00% 12 mo., 3/21/2019 $ 301,436.71 CD *4423 - Rate 1.20% 2 mo., 9/23/2018 $ 700,000.00 CD *4424 - Rate 2.40% 12 mo., 7/25/2019 $ 419,894.02 Total Undesignated Funds $ 7,312,994.62 Scandia EDA *6301 $ 25,564.07 Total Designated Funds $ 25,564.07 Checks in Transit $ (48,578.03) Deposits in Transit S Total Funds $ 7,289,980.66 Submitted by: Colleen Firkus, Treasurer City of Scandia SCANDIA Expenditure Summary July 2018 2018 YTD Budget % of YTD GENERAL FUND 2018 YTD Budget 2018 YTD Amount 2018 MTD Amount Balance Budget Administration & Finance $360,000.00 $220,157.27 $23,996.31 $139,842.73 61.15% City Council $19,500.00 $9,268.62 $4,481.32 $10,231.38 47.53% Elections $6,200.00 $830.00 $0.00 $5,370.00 13.39% Planning & Building $126,300.00 $95,648.39 $17,527.94 $30,651.61 75.73% Police $127,20000 $309.36 $0.00 $126,890.64 0.24% Fire Department $271,500.00 $85,981.64 $14,616.53 $185,518.36 31.67% Public Works $1,130,500.00 $691,063.91 $56,417.02 $439,436.09 61.13% Parks & Recreation $72,800.00 $39,919.46 $3,985.31 $32,880.54 54.83% Community Center $48,600.00 $26,305.24 $2,379.13 $22,294.76 54.13% Total General Fund $2,162,600.00 $1,169,483.89 $123,403.56 $993,116.11 54.08% EDA $800.00 $4,181.40 $0.00 -$3,381.40 0.00% CABLE TV $7,300.00 $2,018.75 $150.00 $5,281.25 0.00% DEBT 2007 ROAD PROJECT BOND $14,208.00 $18,149.86 $000 -$3,941.86 0.00% 2013 EQUIPMENT CERTIFICATES $64,503.00 $60,070.00 $0.00 $4,433.00 93.13% 2015 EQUIPMENT CERTIFICATE $45,801.00 $45,709.00 $0.00 $92.00 99.80% 2017 EQUIPMENT CERTIFICATE $36,550.00. $35,921.34 $34,040.00 $658.66 98.20% $161,092.00 $159,850.20 $34,040.00 $1,241.80 99.23% CAPITAL IMPROVEMENTS $159,650.00 $133,285.00 $0.00 $26,365.00 83.49% ROAD CONSTRUCTION $0.00 $903,350.16 $872,885.16 -$903,350.16 #DIV/0! PARK CAPITAL IMPROVEMENTS $18,220.00 $556.02 $161.81 $17,663.98 3.05% EQUIPMENT REPLACEMENT $125,040.00 $203,488.02 $0.00 -$78,448.02 162.74% LOCAL ROAD IMPROVEMENT FUl` $6,500,000 00 $286,300.45 -$281,910.94 $6,213,699 55 4.40% 201 SEWER FUND $64,450.00 $35,42050 $1,571-92 $29,029.50 54.96% UPTOWN SEWER $21,700.00 $8.04414 $821 76 $13,655.86 3707% Report Total $9,220,852.00 $2,905,978.53 $751,123.27 $6,314,873.47 31.52% CASH BALANCES 2018 END OF MONTH FUND JANUARY FEBRUARY MARCH APRIL MAY JUNE JULY 101 GENERAL $1,723,333 $1,505,745 $1,145,669 $1,024,689 $951,411 $895,700 $1,605,964 225 EDA $9,745 $29,745 $29,745 $25,920 $25,564 $25,564 $25,999 226 CABLE TV $0 $0 $0 $0 $0 -$1,869 42,019 230 RESTRICTED DONATIONS $0 $3,450 $4,100 $4,175 $4,175 $4,175 $5,175 307 BLACKTOP 2007 $18,150 $18,150 $0 $0 $0 $0 -$8 313 EQUIPMENT CERTIFICATES $16,374 $16,374 $16,374 $16,374 -$43,696 -$43,696 -$7,365 315 EQUIPMENT CERTIFICATES $13,230 $13,230 $13,230 $13,230 $13,230 -$31,125 -$5,236 317 EQUIPMENT CERTIFICATES -$4,381 -$4,381 -$4,381 -$4,381 -$4,381 -$4,381 -$17,802 401 CAPITAL IMPR $351,214 $317,929 $623,569 $623,569 $623,569 $623,569 $628,757 402 ROAD CONSTRUCTION $0 $0 $0 $0 $0 $3,817,306 $2,944,421 404 PARK CAP IMPR $16,255 $19,805 $117,523 $117,823 $118,728 $118,779 $118,617 406 EQUIPMENT REPLACEMENT $447,501 $447,501 $447,501 $441,401 $440,927 $283,854 $300,182 408 LOCAL ROAD IMPROVEMENT $1,486,837 $1,474,864 $1,436,808 $1,357,919 $1,348,096 $904,974 $1,581,507 602 201 SEWER $80,690 $75,782 $82,156 $80,280 $72,137 $81,662 $89,450 612 UPTOWN SEWER $5,740 $5,948 $2,473 $1,281 $4,923 $3,150 $2,328 801 ESCROW $12,750 $17,456 $16,466 $16,796 $17,848 $24,428 $20,010 TOTAL $4,177,438 $3,941,597 $3,931,233 $3,719,077 $3,572,532 $6,702,091 $7,289,981