Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
5.b Treasurer's September 2019 Report
Beginning Balance 9/1/2019 Receipts Expenditures Payroll fflffl• M City of Scandia 9/30/2019 $ 4,473,466.57 $ 44,336.40 0.05 Ending Balance 9/30/2019 $ 4,367,473.81 M -IT -2n. lMMff-,wMMM= Checking *102 Money Market *105 - Rate.25% CD *4422 - Rate 2.50% 12 mo., 3/25/2020 CD *4424 - Rate 2.00% 12 mo., 7/25/2020 CD *4425 - Rate 1.75% 12 mo., 9/28/2020 Checking Account *3102 Checks in Transit Transfer to EDA correct cash account *105 Deposit in transit Adj: Further HSA payment did not clear bank in Aug. Scandia EDA *6301 Receipts Expenditures Checks in Transit Deposit in Transit Total Designated Funds NMM= $ 58,818.52 $ 2,341,394.73 $ 520,542.02 $ 309,569.81 $ 430,006.32 $ 717,664.73 0 (10,522.32) $ 4,367,473.81 $ 21,614.34 $ 4,389,088.15 City i Expenditure S(". �.. NDIA September-19 2019 YTD Budget % of YTD GENERAL FUND 2019 YTD Budget 2019 YTD Amount 2019 MTD Amount Balance Budget Administration & Finance- $791,86200 $691,58206 $23,834 70 $100,27994 8734% City Council $31,00000 $19,38490 $0.00 $11,61510 62.53% Elections $2,200.00 $830.00 $0,00 $1,370.00 3773% Planning & Building $119,20000 $84,990.63 $3,172.46 $34,20937 71.30% Police $136,000.00 $68,127 51 $0,00 $67,872.49 5009% Fire Department $262,400.00 $156,213 94 $12,173 83 $106,18606 59,53% Public Works $661,00000 $430,59726 $48,322.67 $230,402,74 6514% Parks & Recreation $85,10000 $51,34691 $2,771 38 $33,75309 60.34% Community Center $49,8D0,00 $26,14258 $2,704.03 $23,65242 52.50% Total General Fund $2,138,562.00 $1,529,215.79 $92,979.07 $609,346.21 71.51% EDA $80000 $7,06000 $4,825.00 -$6,260.00 000% CABLE TV $22,200.00 $17,24994 $3,914 82 $4,95006 GATEWAY DONATIONS $000 $0.00 $0.00 $000 000% DEBT 2007 ROAD PROJECT BOND $000 $0,00 $000 $000 0.00% 2013 EQUIPMENT CERTIFICATI $62,918.00 $59,49250 $000 $3,42550 94.56% 2015 EQUIPMENT CERTIFICATI $44,941,00 $43,94600 $000 $99500 9779% 2017 EQUIPMENT CERTIFICATI $35,63600 $35,328.00 $000 $30800 99.14% 2018 BLACKTOP $329,638.00 $116,320.00 $000 $213,31800 3529% $473,133.00 $255,086.50 $0.00 $218,046.50 53.91% CAPITAL IMPROVEMENTS $224,200 00 $130,52394 $2,25788 $93,676.06 5822% ROAD CONSTRUCTION $0.00 $0.00 $0.00 $0.00 #DIV/01 PARK CAPITAL IMPROVEMENT $207,240 00 $107,65853 $1,952 60 $99,581,47 51,95% EQUIPMENT REPLACEMENT $73,000.00 $32,454.83 $32,45483 $40,545 17 44.46% LOCAL ROAD IMPROVEMENT F $368,29000 $124,199 77 $3,010.00 $244,09023 33.72% 201 SEWER FUND $137,52500 $64,239.44 $7,917,85 $73,285.56 4671% UPTOWN SEWER $21,39700 $8,06620 $63524 $13,330.80 37.70% Report Total $3,666,347.00 $2,275,754.94 $149,947.29 $1,390,592.06 ME FUND 101 GENERAL 225 EDA 226 CABLE TV 230 RESTRICTED DONATIONS 307 BLACKTOP 2007 313 EQUIPMENT CERTIFICATES 315 EQUIPMENT CERTIFICATES 317 EQUIPMENT CERTIFICATES 318 BLACKTOP PROJECT 401 CAPITAL IMPR 402 ROAD CONSTRUCTION 404 PARK CAP IMPIR 406 EQUIPMENT REPLACEMENT 408 LOCAL ROAD IMPROVEMENT 602 201 SEWER 612 UPTOWN SEWER 801 ESCROW CASH BALANCES JUNE JULY AUGUST SEPTEMBER END OF MONTH $1,134,328 $1,380,400 $1,242,710 JANUARY FEBRUARY MARCH APRIL $1,620,605 $1,452,297 $1,355,921 $1,260,238 $14,839 $21,313 $21,313 $20,793 $6,302 $6,666 $8,167 $9,655 $175 $175 $175 $175 $164 $164 $172 $172 $19,059 $19,059 $19,059 $19,059 $15,495 $15,495 $15,495 $15,495 -$2,201 -$2,201 -$2,201 -$2,201 $581,181 $568,810 $575,410 $676,096 $0 $0 $0 $0 $118,585 $251,594 $251,564 $153,492 $275,777 $276,977 $276,977 $276,977 $1,449,555 $1,447,207 $1,444,363 $1,443,648 $108,142 $104,598 $115,480 $104,513 $8,131 $12,893 $12,281 $8,567 $31,058 $59,389 $61,170 $60,244 $4,246,868 $4,234,437 $4,155,346 $4,046,923 MAY JUNE JULY AUGUST SEPTEMBER $1,216,414 $1,134,328 $1,380,400 $1,242,710 $1,171,623 $20,793 $19,813 $21,614 $21,614 $16,789 $9,588 -$700 $615 $2,349 -$40 $175 $175 $175 $175 $175 $172 $1,339 $1,339 $1,339 $1,339 -$40,434 -$40,434 -$5527 -$5,527 -$5,527 $15,495 $15,495 -$3,598 -$3,598 -$3,598 -$2,201 42,201 -$16,885 -$16S85 -$16,885 4116,320 4116,320 $59,249 $59,249 $59,249 $642,094 $638,666 $1,050,314 $1,056,381 $1,056,963 $0 $0 $0 $0 $0 $153,803 $150,663 $159,374 $159,153 $161,076 $276,977 $276,977 $292,195 $292,195 $259,740 $1,442,783 $1,433,471 $1,616,833 $1,518,222 $1,515,212 $97,954 $105,056 $114,923 $98,617 $102,941 $11,598 $10,662 $10,247 $14,641 $14,005 $59,736 $56,721 $54,801 $54,446 $51,200 $3,788,630 $3,683,914 $4,736,268 $4,495,081 $4,384,263