Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
6.b Treasurer's Report October 2021
City of Scandiaaug Treasurer’sReport 10/31/2021 FUND ACCOUNTING Beginning Cash Balance $ 4,102,276.8010/1/2021 Beginning Checking Balance$ 91,698.53 Checking Receipts 39,855.97 Transfers to Checking 183,000.00 Total Deposits 222,855.97 Expenditures$ (217,142.23) Payroll$ (36,772.28) Total Payments 253,914.51) Ending Checking Balance 60,639.99 Beginnging Money Market Balance 1,986,249.27 Money Market Receipts 403.63 Tranfers to Checking 183,000.00) Ending Money Market Balance 1,803,652.90 Beginning Investments Balance 2,025,628.80 Investments Receipts 729.92 Ending Investments Balance$ 2,026,358.72 Beginning EDA Balance 27,363.67 EDA Receipts$ - EDA Expenditures 240.00) EDA Transfers from Checking Ending EDA Balance$ 27,123.67 Outstanding Checks 26,628.66) 10/31/2021EndingCashBalance $ 3,891,146.62 CHECKING, MONEY MARKET & INVESTMENT CD's Checking *102$ 91,698.53BegBal Credits$ 222,855.97 Debits$ (253,914.51) 60,639.99EndBal Money Market *105 - Rate .25%$ 1,986,249.27BegBal rate change from 1.25% Credits 403.63 Debits 183,000.00) End Bal$ 1,803,652.90 Investments CD *4422 - Rate .90% 12 mo., 3/25/2022$ 316,744.22 CD *4424 - Rate .30% 12 mo., 7/25/2022$ 440,366.36 CD *4425 - Rate .30% 12 mo., 9/28/2022$ 732,442.93 CD *4426 - Rate 1.60% 12 mo., 1/29/2022 536,805.21 Total Investments$ 2,026,358.72 Total Bank & Investment Accounts 3,890,651.61 26,628.66) Checks in Transit *3102 Deposit in transit checking Deposit in transit money market 3,864,022.95TotalAdjustedUndesignatedFunds Scandia EDA *6301 $ 27,363.67 Receipts Expenditures 240.00) Checks in Transit Deposit in Transit Total Designated EDA Funds$ 27,123.67 Total Funds$ 3,891,146.62 Submitted by: Colleen Firkus, Treasurer CASH BALANCES 2021END OF MONTH REVISED 3-25-21 FUNDJANUARYFEBRUARYMARCHAPRILMAYJUNEJULYAUGUSTSEPTEMBEROCTOBER 101GENERAL$1,587,928$1,434,436$1,297,969$1,254,652$1,171,412$826,422$1,493,140$1,393,890$1,178,368$1,046,592 203COVID-19RELIEF($2,690)($2,690)($2,690)($2,690)($2,690)$1,275$222,221$220,946$220,946$220,946 226CABLETV$21,930$23,775$25,569$27,490$27,816$29,773$31,636$33,490$35,381$35,818 230RESTRICTEDDONATIONS$175$175$175$175$175$175$175$175$175$175 307BLACKTOP2007$91$0$0$0$0$0$0$0$0$0 313EQUIPMENTCERTIFICATES$21,089$21,089$21,089$21,089($42,046)($42,046)($7,936)($7,936)($7,936)($7,936) 315EQUIPMENTCERTIFICATES$15,452$15,452$15,452$15,452$15,452$15,452$15,452$15,452$15,452$15,452 317EQUIPMENTCERTIFICATES($2,468)($2,468)($2,468)($2,468)($2,468)($2,468)$15,487($17,812)($17,812)($17,812) 318BLACKTOPPROJECT($15,633)($15,633)($15,633)($15,633)($68,490)($68,490)$102,238$102,238$102,238$102,238 401CAPITALIMPR$939,628$957,772$957,772$956,400$920,311$1,018,807$1,043,701$883,616$883,616$825,517 404PARKCAPIMPR$157,785$149,599$152,599$152,599$151,742$152,599$157,599$156,049$157,264$154,360 406EQUIPMENTREPLACEMENT$181,596$183,483$183,483$172,259$172,259$172,259$237,259$208,629$208,629$208,629 408LOCALROADIMPROVEMENT$1,599,921$1,596,279$1,578,514$1,570,663$1,438,677$1,024,391$1,207,472$1,191,504$1,175,217$1,155,069 602BIGMARINESEWER$48,621$43,641$49,211$48,727$45,513$54,973$64,943$61,531$69,448$72,455 612UPTOWNSEWER$22,458$20,116$18,996$18,189$21,112$21,015$20,307$23,183$19,330$16,806 801ESCROW$28,797$27,605$37,583$34,332$32,997$34,177$35,589$36,731$34,596$35,714 SUBTOTAL$4,604,681$4,452,631.91$4,317,621$4,251,236$3,881,772$3,238,314$4,639,282$4,301,685$4,074,913$3,864,023 225EDA$26,959$26,852.64$26,828$26,828$26,433$24,638$24,293$27,364$27,364$27,124 TOTAL$4,631,640$4,479,484.55$4,344,449$4,278,063$3,908,205$3,262,952$4,663,574$4,329,049.11$4,102,277$3,891,147 CITY OF SCANDIA BUDGETYTDREVENUEAND EXPENSES Oct-21 2021Budget2021YTD2021MTD2021BudgetBal% ofBudgetNotes 101GENERALFUND RevenueAccounts 753,614.59$0.00R101-41000-31000 Washington Cty. Tax Settlement$1,381,700.00$628,085.410.00% 82,986.81$0.00R101-41000-31040 Fiscal Disparities$0.00($82,986.81)0.00% 8,195.55$0.00R101-41000-31701 Gravel Taxes$10,000.00$1,804.450.00% 5,066.61$0.00R101-41000-31830 Solar Energy Production Tax$6,000.00$933.3989.90% 663.67$0.00R101-41000-31900 Penalties & Interest Del Tax$1,000.00$336.330.00% 5,550.00$1,500.00R101-41000-32150 Utility Permits$1,800.00$600.0058.33% 2,869.00$644.00R101-41000-32180 Tobacco & Liquor Licenses$8,200.00$5,331.0026.83% 2,587.50$75.00R101-41000-32190 Other City Permits$2,900.00$312.5042.50% 177,152.42$9,612.08R101-41000-32210 Building Permits$95,500.00($81,652.42)50.88% 130.00$0.00R101-41000-32260 Gambling Permits$0.00($130.00)0.00% 6,853.28$6,853.28R101-41000-33401 LGA/MVHC/AG/PERA Aid$13,000.00$6,146.720.00% 39,178.22$39,178.22R101-41000-33420 Fire Relief State PERA$33,700.00($5,478.22)0.00% 3,810.00$0.00R101-41000-33422 Other State Grants & Aids$10,200.00$6,390.003.04% 3,036.10$0.00R101-41000-33428 PILOT$6,000.00$2,963.900.00% 13,062.00$0.00R101-41000-33620 Recycling Grant$8,000.00($5,062.00)0.00% 0.00$0.00R101-41000-33630 Local Govt Grants & Aids$0.00$0.000.00% 724.00$0.00R101-41000-33640 Other Grants$4,000.00$3,276.0018.10% 0.00$0.00R101-41000-34102 Legal Services$0.00$0.000.00% 7,927.72$1,127.72R101-41000-34103 Zoning and Planning$3,400.00($4,527.72)105.88% 482.00$0.00R101-41000-34106 Engineering Fees$0.00($482.00)0.00% 20.00$0.00R101-41000-34107 Assessment Search Fees$0.00($20.00)0.00% 0.00$0.00R101-41000-34109 Water Usage$200.00$200.000.00% 0.00$0.00R101-41000-34201 Impound Fees$200.00$200.000.00% 30,710.00$0.00R101-41000-34202 Fire Protection Services$36,800.00$6,090.0083.45% 7,840.10$4,161.86R101-41000-34301 Damage Repairs$0.00($7,840.10)0.00% 2,665.61$0.00R101-41000-34303 Dust Control$2,400.00($265.61)0.00% 3,600.00$0.00R101-41000-34304 Reimbursement for Services$3,600.00$0.0050.00% 2,076.95$0.00R101-41000-34305 Other Street Services$0.00($2,076.95)0.00% Page 1 of 8 CITY OF SCANDIA BUDGETYTDREVENUEAND EXPENSES Oct-21 2021Budget2021YTD2021MTD2021BudgetBal% ofBudgetNotes 2,100.00$0.00R101-41000-34730 Ad Revenue$1,600.00($500.00)0.00% 5,174.18$950.00R101-41000-34750 Facilities Rental$3,000.00($2,174.18)46.07% 100.00$0.00R101-41000-34760 Cleaning Fees$0.00($100.00)0.00% 1,125.00$0.00R101-41000-34790 Recreation Programs$0.00($1,125.00)0.00% 0.00$0.00R101-41000-34950 Solar Subscription$9,000.00$9,000.000.00% 5,567.85$338.30R101-41000-35101 Fines & Forfeitures$8,100.00$2,532.1532.36% 11,940.89$1,134.58R101-41000-36210 Interest Income$17,900.00$5,959.1136.04% 1,450.00$0.00R101-41000-36230 Donations$5,000.00$3,550.0029.00% 0.00$0.00R101-41000-36240 Insurance Dividend$1,400.00$1,400.000.00% 2,575.00$68.00R101-41000-36250 Misc. Refund$500.00($2,075.00)333.72% No more transfers from 404- ballfield ad0.00$0.00R101-41000-39200 Interfund Operating Transfer$1,440.00$1,440.000.00% revenue and maintenance now inGen Fund TOTALREVENUEBEFORETRANSFERS$1,676,540.00$1,190,835.05$65,643.04$485,704.9571.03% 3,524,556.52$183,000.00R101-49000-39204 Money Market Transfer$ - R 101-49000-39203 Transfers from Other Funds$1,190.00$0.00 Balancing EDA account TOTALGENERALFUNDREVENUES$4,716,581.57$248,643.04 101GENERALFUND ExpenditureAccounts2021Budget2021YTD2021MTD2021 BudgetBal% ofBudget Administration & Finance$ 387,272.00 $317,187.61$30,276.95$70,084.3981.90% City Council$ 19,982.00 $23,167.43$4,786.03($3,185.43)115.94% Elections$ 1,030.00 $1,470.00$0.00($440.00)142.72% Planning & Building$ 118,050.00 $113,377.37$6,970.97$4,672.6396.04% Assessor$ 21,600.00 $18,476.65$1,800.00$3,123.3585.54% Police$ 147,460.00 $73,868.19$0.00$73,591.8150.09% Fire Dept$ 262,778.00 $241,438.33$76,389.73$21,339.6791.88% Animal Control$ 2,000.00 $3,643.50$617.60($1,643.50)182.18% Public Works$ 658,253.00 $560,976.04$71,222.94$97,276.9685.22% Parks & Recreation$ 90,797.00 $68,087.74$2,511.46$22,709.2674.99% Community Center$ 68,500.00 $31,911.76$1,814.44$36,588.2446.59% TOTALEXPENDITURESBEFORETRANSFERS$ 1,777,722.00 $1,453,604.62$ 196,390.12 $324,117.3881.77% Budgeted Transfers Between Accounts$ 280,000.00 $ 280,000.00 $0.00 Transfers Between Bank Accounts$ - $ 3,528,380.40 $ 183,000.00 ($3,528,380.40)$ 861,690.17 TOTALGENERALFUNDEXPENDITURES$ 2,057,722.00 $ 5,261,985.02 $ 379,390.12 $ (3,204,263.02) Page 2 of 8 CITY OF SCANDIA BUDGETYTDREVENUEAND EXPENSES Oct-21 2021Budget2021YTD2021MTD2021BudgetBal% ofBudgetNotes 203AMERICANRESCUEPLANFUND RevenueAccounts$ - $ 220,945.94 $ - ($220,945.94) Transfers Between Accounts$ 2,690.40 $ - ExpenditureAccounts$ - -$1,275.00$0.00$1,275.00 2020 check held inAP, cashed 2021 225EDAFUND RevenueAccounts$ 5,000.00 $ 2,500.00 $ - $2,500.0050.00% R 101-41000-39200 Interfund Operating Transfer$ 2,776.03 $ - ExpenditureAccounts E 225-46500-210 Operating Supplies$500.00$465.00$240.00$35.0093.00% E 225-46500-308 Other Professional Services$250.00$68.97$0.00$181.0327.59% E 225-46500-433 Dues and Subscriptions$1,150.00$1,795.00$0.00-$645.00156.09% TOTALEDA EXPENDITURES$ 1,900.00 $2,328.97$240.00-$428.97122.58% E 225-46500-720 Operating Transfers$0.00$2,776.03$0.00 226CABLETVFUND RevenueAccounts$ 16,500.00 $ 17,429.81 $ 1,897.87 -$929.81105.64% ExpenditureAccounts E 226-41950-240 Small Tools and Minor Equip$0.00$52.49$0.00($52.49) E 226-41950-309 Software Support & Maintenance$3,500.00$2,039.45$81.53$1,460.5558.27% E 226-41950-438 Misc. Contractual$7,000.00$1,380.00$1,380.00$5,620.0019.71% E 226-41950-570 Office Equipment$0.00$230.39$0.00($230.39) TOTALCABLETVEXPENDITURES$10,500.00$3,702.33$1,461.53$6,797.6735.26% Page 3 of 8 CITY OF SCANDIA BUDGETYTDREVENUEAND EXPENSES Oct-21 2021Budget2021YTD2021MTD2021BudgetBal% ofBudgetNotes 313EQUIPMENTCERTIFICATE2013FUND RevenueAccounts$ 68,220.00 $ 34,110.00 $ - $34,110.0050.00% ExpenditureAccounts$ 64,995.00 $ 63,135.00 $ - $1,860.0097.14% 317EQUIPMENTCERTIFICATE2017FUND RevenueAccounts$ 35,909.00 $ 17,954.50 $ - $17,954.5050.00% ExpenditureAccounts$ 34,223.00 $ 34,163.00 $ - $60.0099.82% 318BLACKTOPPROJECT2018FUND RevenueAccounts$ 341,456.00 $ 170,728.00 $ - $170,728.0050.00% ExpenditureAccounts$ 325,220.00 $ 52,857.51 $ - $272,362.4916.25% Page 4 of 8 CITY OF SCANDIA BUDGETYTDREVENUEAND EXPENSES Oct-21 2021Budget2021YTD2021MTD2021BudgetBal% ofBudgetNotes 401CAPITALIMPROVEMENTSFUND RevenueAccounts R 101-41000-31000 Washington Cty. Tax Settlement$ 100,000.00 $ 50,000.00 $ 50,000.00 $50,000.0050.00% R 101-41000-31951 SA Penalties & Interest$ (35.41) R 401-48000-36210 Interest Income$ 500.00 $ - $500.000.00% R 401-48000-36230 Donations$ - $ 6,089.04 $ - ($6,089.04) Fire Relief defibrillator donation R 101-48000-39200 Interfund Transfers$ 200,000.00 $ 200,000.00 $ - $0.00100.00% TOTALCAPITALIMPROVEMENTFUNDREVENUE$ 300,500.00 $ 256,089.04 $ 49,964.59 $ 44,410.96 85.22% ExpenditureAccounts Administration & Finance$ 250,000.00 $18,815.00$0.00$231,185.007.53% Fire Dept$ 75,000.00 $188,557.56$46,684.32($113,557.56)251.41% Public Works$ 10,000.00 $0.00$0.00$10,000.000.00% Community Center$ 15,000.00 $11,414.99$11,414.99$3,585.0176.10% Journal Entry to close out 2020 Midco Capital Improvements$ 47,000.00 $16,094.24$0.00$30,905.7634.24% Payable paid in2021 Operating Transfer$ 10,000.00 $0.00$0.00$10,000.00 Loan to Big Marine Sewer ifneeded TOTALCAPITALIMPROVEMENT EXPENDITURES$ 407,000.00 $234,881.79$58,099.31$172,118.2157.71% Page 5 of 8 CITY OF SCANDIA BUDGETYTDREVENUEAND EXPENSES Oct-21 2021Budget2021YTD2021MTD2021BudgetBal% ofBudgetNotes 404PARKDEVELOPMENTFUND2021Budget2021YTD2021MTD2021BudgetBal% ofBudget RevenueAccounts R 404-48000-31000 Washington Cty Tax Settlement$ 10,000.00 $ 5,000.00 $5,000.0050.00% R 404-48000-33422 Other State Grant$ 10,585.00 $ 2,407.00 $8,178.0022.74% R 404-48000-34730 Ad Revenue$ 1,600.00 $1,600.000.00% 1600 Ad revenue going into Gen Fund R 404-48000-34780 Park Dedication Fees$ 6,000.00 $ 3,000.00 $3,000.0050.00% TOTALPARKDEVELOPMENTREVENUE$ 28,185.00 $ 10,407.00 $ - $17,778.0036.92% ExpenditureAccounts E 404-48000-530 Capital Impr Other Than Bldgs$40,585.00$6,545.38$2,903.30$34,039.6216.13% No longer transferring Ballfield labor expense E 404-48000-720 Operating Transfers$1,440.00$0.00$0.00$1,440.000.00% toGeneral Fund TOTALPARKDEVELOPMENTEXPENDITURES$ 42,025.00 $6,545.38$2,903.30$35,479.6215.57% 406EQUIPMENTREPLACEMENTFUND RevenueAccounts$ 138,000.00 $ 65,000.00 $ - $73,000.0047.10% ExpenditureAccounts$ 52,500.00 $ 143,815.72 $ 103,961.68 ($91,315.72)273.93% 408LOCALROADIMPROVEMENT FUND RevenueAccounts$ 518,539.00 $ 343,950.50 $ - $174,588.5066.33% ExpenditureAccounts$ 845,000.00 $ 785,159.86 $ 20,148.00 $59,840.1492.92% Page 6 of 8 CITY OF SCANDIA BUDGETYTDREVENUEAND EXPENSES Oct-21 2021Budget2021YTD2021MTD2021BudgetBal% ofBudgetNotes 602BIGMARINESEWER FUND RevenueAccounts$ 98,945.00 $ 66,281.24 $ 9,929.16 $32,663.7666.99% ExpenditureAccounts E 602-43210-101 Regular Wages & Salaries$20,000.00$8,549.90$859.64$11,450.1042.75% E 602-43210-102 OT Regular Wages$0.00$308.39$88.11-$308.39#DIV/0! E 602-43210-121 PERA Coord. Employer Contribu.$1,500.00$610.59$71.08$889.4140.71% E 602-43210-122 FICA Employer Contribution$1,200.00$518.70$56.05$681.3043.23% E 602-43210-126 MEDICARE Employer Contribution$300.00$130.13$13.11$169.8743.38% E 602-43210-151 Worker s Comp Insurance Prem$455.00$422.00$0.00$33.0092.75% E 602-43210-200 Office Supplies$200.00$109.00$34.00$91.0054.50% E 602-43210-210 Operating Supplies$2,400.00$557.95$1.99$1,842.0523.25% E 602-43210-240 Small Tools and Minor Equip$550.00$0.00$0.00$550.000.00% E 602-43210-303 Engineering Fees$8,000.00$8,596.50$2,246.00-$596.50107.46% E 602-43210-308 Other Professional Services$2,200.00$2,667.00$61.00-$467.00121.23% E 602-43210-309 Software Support & Maintenance$1,200.00$0.00$0.00$1,200.000.00% E 602-43210-317 Employee Training$1,400.00$890.40$760.40$509.6063.60% E 602-43210-321 Telephone$2,100.00$1,910.82$203.52$189.1890.99% E 602-43210-322 Postage$550.00$0.00$0.00$550.000.00% E 602-43210-331 Travel Expenses$200.00$0.00$0.00$200.000.00% E 602-43210-334 Licenses & Permits$1,600.00$1,569.79$855.79$30.2198.11% E 602-43210-361 Liability/Property Ins$1,100.00$1,038.98$0.00$61.0294.45% E 602-43210-381 Utilities-Electric & Gas$2,500.00$1,419.14$130.10$1,080.8656.77% E 602-43210-385 Sewer Pumping & Maintenance$9,000.00$0.00$0.00$9,000.000.00% E 602-43210-386 Operation & Maintenance$5,000.00$1,574.26$0.00$3,425.7431.49% E 602-43210-404 Repair Machinery/Equipment$16,000.00$10,064.69$0.00$5,935.3162.90% E 602-43210-413 Equipment Rental$350.00$0.00$0.00$350.000.00% E 602-43210-420 Depreciation Expense$51,200.00$0.00$0.00$51,200.000.00% E 602-43210-438 Misc. Contractual$9,000.00$2,642.00$1,741.00$6,358.0029.36% E 602-43210-530 Capital Impr Other Than Bldgs$29,000.00$0.00$0.00$29,000.000.00% TOTALBIGMARINESEWEREXPENDITURES$ 167,005.00 $43,580.24$7,121.79$ 123,424.76 26.10% Page 7 of 8 CITY OF SCANDIA BUDGETYTDREVENUEAND EXPENSES Oct-21 2021Budget2021YTD2021MTD2021BudgetBal% ofBudgetNotes 612UPTOWNSEWERFUND RevenueAccounts$ 23,000.00 $ 6,878.05 $ 132.32 $16,121.9529.90% ExpenditureAccounts E 612-43210-101 Regular Wages & Salaries$8,700.00$2,915.39$267.90$5,784.6133.51% E 612-43210-121 PERA Coord. Employer Contribu.$700.00$201.41$20.10$498.5928.77% E 612-43210-122 FICA Employer Contribution$500.00$170.98$15.84$329.0234.20% E 612-43210-126 MEDICARE Employer Contribution$100.00$42.59$3.70$57.4142.59% E 612-43210-151 Worker s Comp Insurance Prem$235.00$217.00$0.00$18.0092.34% E 612-43210-200 Office Supplies$100.00$3.78$3.78$96.223.78% E 612-43210-210 Operating Supplies$200.00$0.00$0.00$200.000.00% E 612-43210-221 Equipment Parts$200.00$0.00$0.00$200.000.00% E 612-43210-303 Engineering Fees$300.00$6,447.00$2,322.00-$6,147.002149.00% E 612-43210-308 Other Professional Services$400.00$128.00$0.00$272.0032.00% E 612-43210-317 Employee Training$350.00$0.00$0.00$350.000.00% E 612-43210-322 Postage$45.00$17.90$0.00$27.1039.78% E 612-43210-334 Licenses & Permits$400.00$209.00$0.00$191.0052.25% E 612-43210-361 Liability/Property Ins$300.00$283.36$0.00$16.6494.45% E 612-43210-381 Utilities-Electric & Gas$1,700.00$452.38$23.39$1,247.6226.61% E 612-43210-385 Sewer Pumping & Maintenance$1,200.00-$260.00$0.00$1,460.00-21.67% E 612-43210-386 Operation & Maintenance$600.00$0.00$0.00$600.000.00% E 612-43210-404 Repair Machinery/Equipment$1,500.00$0.00$0.00$1,500.000.00% E 612-43210-420 Depreciation Expense$4,877.00$0.00$0.00$4,877.000.00% E 612-43210-438 Misc. Contractual$1,200.00$100.00$0.00$1,100.008.33% E 612-43210-530 Capital Impr Other Than Bldgs$4,000.00$0.00$0.00$4,000.000.00% TOTALUPTOWNSEWEREXPENDITURES$ 27,607.00 $10,928.79$2,656.71$16,678.2139.59% TOTALREVENUEWITHOUTTRANSFERS$ 3,250,794.00 $ 2,403,109.13 $ 127,566.98 $ 847,684.87 73.92% TOTALREVENUEACCOUNTS$ 3,250,794.00 $ 5,934,322.08 $ 310,566.98 $ 1,068,630.81 182.55% TOTALEXPENDITURESWITHOUTTRANSFERS$ 3,690,702.00 $ 2,770,293.21 $ 392,982.44 $ 920,408.79 75.06% TOTALEXPENDITUREACCOUNTS$ 4,035,697.00 $ 6,644,584.64 $ 575,982.44 $ (2,608,887.64) 164.65% Page 8 of 8