Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
5.b April Treasurer's Report
a L -g z ; CANDIA Beginning Balance 4/1/2017 Receipts Expenditures Payroll Adjustments: duplicate receipt entry Ending Balance 4/30/2017 City of Scandia Treasurer's Report 4/30/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 *3136 — Rate .70% 6 mo., 7/24/2017 CD *2920 — Rate 1.00% 12 mo., 1/24/2018 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 $ 80,518.11 $ 26,932.60 $ 28,042.69 $ 422,711.12 $ 1,103, 254.79 $ 400,000.00 $ 501,232.88 $ 500,000.00 $ 5,070.47 $ 2,993,212.86 $ 69,770.77 $ (107,450.71) $ 2,955,532.92 $ 2,955,241.48 $ 5,070.47 $ (4,779.03) S $ 2,955,532.92 SCANDIA City of Scandia Expenditure Summary April 2017 2017 YTD Budget % of YTD GENERAL FUND 2017 YTD Budget 2017 YTD Amount 2017 MTD Amount Balance Budget Administration & Finance $342,600.00 $99,910.86 $28,632.13 $242,689.14 2916% City Council $18,900.00 $5,846.59 $4,481.32 $13,053.41 3093% Elections $1,300.00 $830.00 $0.00 $470.00 63.85% Planning & Building $149,000.00 $38,591.45 $18,199.31 $110,40855 25.90% Police $120,500.00 $30936 $0.00 $120,19064 026% Fire Department $244,490.00 $51,427.14 $12,503.09 $193,062.86 21.03% Public Works $1,371,800.00 $661,44761 $29,675.34 $710,352.39 48.22% Parks & Recreation $60,900.00 $20,244.75 $3,297.03 $40,655.25 33.24% Community Center $40,200.00 $10,217.73 $2,506.95 $29,982.27 2542% Total General Fund $2,349,690.00 $888,825.49 $99,295.17 $1,460,864.51 37.83% PUBLIC HOUSING $0.00 $0.00 0.00% EDA $0.00 $325.00 $325.00 -$325.00 000% DEBT 2007 ROAD PROJECT BOND $77,000.00 $79,317.56 $0.00 -$2,31756 0.00% 2010 EQUIPMENT CERTIFICATES $10,060.00 $10,177.13 $0.00 -$117.13 101.16% 2011 EQUIPMENT CERTIFICATES $8,294.00 $8,311.93 $000 -$17.93 100.22% 2013 EQUIPMENT CERTIFICATES $65,063.00 $43500 $0.00 $64,628.00 0.67% 2015 EQUIPMENT CERTIFICATE $46,364.00 $1,709.25 $0.00 $44,654.75 3.69% $206,781.00 $99,950.87 $0.00 $106,830.13 48.34% CAPITAL IMPROVEMENTS $266,700.00 $0.00 $0.00 $266,700.00 0.00% PARK CAPITAL IMPROVEMENTS $44,90000 $000 $0.00 $44,90000 0.00% EQUIPMENT REPLACEMENT $438,000.00 $0.00 $0.00 $438,000.00 000% LOCAL ROAD IMPROVEMENT FUi' $50,000.00 $0.00 $0.00 $50,000.00 000% 201 SEWER FUND $62,000.00 $13,193.31 $4,000.69 $48,806.69 2128% UPTOWN SEWER $15.400.00 $3.877.70 $1.168.86 $11.52230 25.18% Report Total $3,433,471.00 $1,006,172.37 $104,789.72 $2,427,298.63 29.30% 4 1 SCA DIA CASH BALANCES 2017 END OF MONTH FUND JANUARY FEBRUARY MARCH APRIL 101 GENERAL $1,797,435 $1,628,261 $1,036,162 $994,496 213 PUBIC HOUSING $0 $0 $0 $0 225 EDA $5,070 $5,091 $5,091 $4,766 307 BLACKTOP 2007 $79,092 $2,318 $0 $0 311 EQUIPMENT CERTIFICATES $10,060 $117 $0 $0 312 EQUIPMENT CERTIFICATES $8,284 $28 $0 $0 313 EQUIPMENT CERTIFICATES $13,296 $13,341 $13,341 $13,341 315 EQUIPMENT CERTIFICATES $326 $331 $10,507 $10,507 401 CAPITAL IMPR $322,660 $326,803 $326,803 $326,803 404 PARK CAP IMPR $20,380 $17,441 $17,441 $18,641 406 EQUIPMENT REPLACEMENT $499,258 $501,061 $509,373 $509,373 408 LOCAL ROAD IMPROVEMENT $373,833 $469,363 $976,537 $976,537 602 201 SEWER $70,915 $67,025 $74,466 $76,884 612 UPTOWN SEWER $5,226 $4,602 $3,530 $4,952 801 ESCROW $35,342 $24,079 $19,963 $19,233 TOTAL $3,241,177 $3,059,861 $2,993,213 $2,955,533