Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
06.b Treasurer's Report
City of Scandiaaug Treasurer’sReport 11/30/2021 FUND ACCOUNTING Beginning Cash Balance $ 3,891,146.6211/1/2021 Beginning Checking Balance$ 60,639.99 Checking Receipts 113,895.10 Transfers to Checking 106,000.00 Total Deposits 219,895.10 Expenditures$ (105,940.34) Payroll$ (32,017.89) Total Payments 137,958.23) Ending Checking Balance 142,576.86 Beginnging Money Market Balance 1,803,652.90 Money Market Receipts 359.41 Tranfers to Checking 106,000.00) Ending Money Market Balance 1,698,012.31 Beginning Investments Balance 2,026,358.72 Investments Receipts Ending Investments Balance$ 2,026,358.72 Beginning EDA Balance 27,123.67 EDA Receipts$ - EDA Expenditures EDA Transfers from Checking Ending EDA Balance$ 27,123.67 Outstanding Checks 41,261.55) 11/30/2021EndingCashBalance $ 3,852,810.01 CHECKING, MONEY MARKET & INVESTMENT CD's Checking *102$ 60,639.99BegBal Credits$ 219,895.10 Debits$ (137,958.23) 142,576.86EndBal Money Market *105 - Rate .25%$ 1,803,652.90BegBal rate change from 1.25% Credits 359.41 Debits 106,000.00) End Bal$ 1,698,012.31 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,866,947.89 41,261.55) Checks in Transit *3102 Deposit in transit checking Deposit in transit money market 3,825,686.34TotalAdjustedUndesignatedFunds Scandia EDA *6301 $ 27,123.67 Receipts Expenditures Checks in Transit Deposit in Transit Total Designated EDA Funds$ 27,123.67 Total Funds$ 3,852,810.01 Submitted by: Colleen Firkus, Treasurer CASH BALANCES 2021END OF MONTH REVISED 3-25-21 FUNDJANUARYFEBRUARYMARCHAPRILMAYJUNEJULYAUGUSTSEPTEMBEROCTOBERNOVEMBER 101 GENERAL$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$1,028,421 203 COVID-19 RELIEF($2,690)($2,690)($2,690)($2,690)($2,690)$1,275$222,221$220,946$220,946$220,946$228,181 226 CABLE TV$21,930$23,775$25,569$27,490$27,816$29,773$31,636$33,490$35,381$35,818$37,131 230 RESTRICTED DONATIONS$175$175$175$175$175$175$175$175$175$175$175 307 BLACKTOP 2007$91$0$0$0$0$0$0$0$0$0$1,688 313 EQUIPMENT CERTIFICATES$21,089$21,089$21,089$21,089($42,046)($42,046)($7,936)($7,936)($7,936)($7,936)($9,796) 315 EQUIPMENT CERTIFICATES$15,452$15,452$15,452$15,452$15,452$15,452$15,452$15,452$15,452$15,452$15,452 317 EQUIPMENT CERTIFICATES($2,468)($2,468)($2,468)($2,468)($2,468)($2,468)$15,487($17,812)($17,812)($17,812)($17,812) 318 BLACKTOP PROJECT($15,633)($15,633)($15,633)($15,633)($68,490)($68,490)$102,238$102,238$102,238$102,238$102,238 401 CAPITAL IMPR$939,628$957,772$957,772$956,400$920,311$1,018,807$1,043,701$883,616$883,616$825,517$827,325 404 PARK CAP IMPR$157,785$149,599$152,599$152,599$151,742$152,599$157,599$156,049$157,264$154,360$154,396 406 EQUIPMENT REPLACEMENT$181,596$183,483$183,483$172,259$172,259$172,259$237,259$208,629$208,629$208,629$250,448 408 LOCAL ROAD IMPROVEMENT$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$1,074,980 602 BIG MARINE SEWER$48,621$43,641$49,211$48,727$45,513$54,973$64,943$61,531$69,448$72,455$77,767 612 UPTOWN SEWER$22,458$20,116$18,996$18,189$21,112$21,015$20,307$23,183$19,330$16,806$20,262 801 ESCROW$28,797$27,605$37,583$34,332$32,997$34,177$35,589$36,731$34,596$35,714$34,831 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$3,825,686 225 EDA$26,959$26,852.64$26,828$26,828$26,433$24,638$24,293$27,364$27,364$27,124$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$3,852,810 CITY OF SCANDIA BUDGETYTDREVENUEAND EXPENSES Nov-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% 6,000.00$450.00R101-41000-32150 Utility Permits$1,800.00$600.0058.33% 9,741.00$6,872.00R101-41000-32180 Tobacco & Liquor Licenses$8,200.00($1,541.00)26.83% 2,784.08$196.58R101-41000-32190 Other City Permits$2,900.00$115.9242.50% 185,746.57$8,594.15R101-41000-32210 Building Permits$95,500.00($90,246.57)50.88% 130.00$0.00R101-41000-32260 Gambling Permits$0.00($130.00)0.00% 6,853.28$0.00R101-41000-33401 LGA/MVHC/AG/PERA Aid$13,000.00$6,146.720.00% 39,178.22$0.00R101-41000-33420 Fire Relief State PERA$33,700.00($5,478.22)0.00% DNR Fire Dept Grant; Small Cities48,491.00$44,681.00R101-41000-33422 Other State Grants & Aids$10,200.00($38,291.00)3.04% Assist Grant 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% 8,216.91$289.19R101-41000-34103 Zoning and Planning$3,400.00($4,816.91)105.88% 1,298.50$816.50R101-41000-34106 Engineering Fees$0.00($1,298.50)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% County reimbursement for streetlight; 24,432.10$16,592.00R101-41000-34301 Damage Repairs$0.00($24,432.10)0.00% SRC reimbursement for hydraulic spill 2,665.61$0.00R101-41000-34303 Dust Control$2,400.00($265.61)0.00% 5,400.00$1,800.00R101-41000-34304 Reimbursement for Services$3,600.00($1,800.00)50.00% 1,800 2020 Services 2,076.95$0.00R101-41000-34305 Other Street Services$0.00($2,076.95)0.00% County light pole reimbursement Page 1 of 8 CITY OF SCANDIA BUDGETYTDREVENUEAND EXPENSES Nov-21 2021Budget2021YTD2021MTD2021BudgetBal% ofBudgetNotes 2,600.00$500.00R101-41000-34730 Ad Revenue$1,600.00($1,000.00)0.00% Skate Park & Ballfield Ads 6,034.18$860.00R101-41000-34750 Facilities Rental$3,000.00($3,034.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% reclassed to reduce Xcel bills 5,919.47$351.62R101-41000-35101 Fines & Forfeitures$8,100.00$2,180.5332.36% 12,301.13$360.24R101-41000-36210 Interest Income$17,900.00$5,598.8736.04% 3,936.49$2,486.49R101-41000-36230 Donations$5,000.00$1,063.5129.00% 0.00$0.00R101-41000-36240 Insurance Dividend$1,400.00$1,400.000.00% 2,575.00$0.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,275,684.82$84,849.77$400,855.1876.09% 3,630,556.52$106,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,907,431.34$190,849.77 101GENERALFUND ExpenditureAccounts2021Budget2021YTD2021MTD2021 BudgetBal% ofBudget Administration & Finance$ 387,272.00 $344,764.56$27,576.95$42,507.4489.02% City Council$ 19,982.00 $23,167.43$0.00($3,185.43)115.94% Elections$ 1,030.00 $1,470.00$0.00($440.00)142.72% Planning & Building$ 118,050.00 $122,471.64$9,094.27($4,421.64)103.75% Assessor$ 21,600.00 $20,276.65$1,800.00$1,323.3593.87% Police$ 147,460.00 $73,868.19$0.00$73,591.8150.09% Fire Dept$ 262,778.00 $255,033.17$13,594.84$7,744.8397.05% Animal Control$ 2,000.00 $3,953.50$310.00($1,953.50)197.68% Public Works$ 658,253.00 $604,443.61$43,467.57$53,809.3991.83% Parks & Recreation$ 90,797.00 $72,556.42$4,468.68$18,240.5879.91% Community Center$ 68,500.00 $34,479.30$2,567.54$34,020.7050.33% TOTALEXPENDITURESBEFORETRANSFERS$ 1,777,722.00 $1,556,484.47$ 102,879.85 $221,237.5387.55% Budgeted Transfers Between Accounts$ 280,000.00 $ 280,000.00 $0.00 Transfers Between Bank Accounts$ - $ 3,634,380.40 $ 106,000.00 ($3,634,380.40) TOTALGENERALFUNDEXPENDITURES$ 2,057,722.00 $ 5,470,864.87 $ 208,879.85 $ (3,413,142.87) Page 2 of 8 CITY OF SCANDIA BUDGETYTDREVENUEAND EXPENSES Nov-21 2021Budget2021YTD2021MTD2021BudgetBal% ofBudgetNotes 203AMERICANRESCUEPLANFUND RevenueAccounts$ - $ 228,181.31 $ 7,235.37 ($228,181.31) 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$0.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$0.00-$428.97122.58% E 225-46500-720 Operating Transfers$0.00$2,776.03$0.00 226CABLETVFUND RevenueAccounts$ 16,500.00 $ 19,363.92 $ 1,934.11 -$2,863.92117.36% ExpenditureAccounts E 226-41950-240 Small Tools and Minor Equip$0.00$285.48$232.99($285.48) E 226-41950-309 Software Support & Maintenance$3,500.00$2,427.41$387.96$1,072.5969.35% E 226-41950-438 Misc. Contractual$7,000.00$1,380.00$0.00$5,620.0019.71% E 226-41950-570 Office Equipment$0.00$230.39$0.00($230.39) TOTALCABLETVEXPENDITURES$10,500.00$4,323.28$620.95$6,176.7241.17% Page 3 of 8 CITY OF SCANDIA BUDGETYTDREVENUEAND EXPENSES Nov-21 2021Budget2021YTD2021MTD2021BudgetBal% ofBudgetNotes 313EQUIPMENTCERTIFICATE2013FUND RevenueAccounts$ 68,220.00 $ 34,110.00 $ - $34,110.0050.00% ExpenditureAccounts$ 64,995.00 $ 64,995.00 $ 1,860.00 $0.00100.00% 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 Nov-21 2021Budget2021YTD2021MTD2021BudgetBal% ofBudgetNotes 401CAPITALIMPROVEMENTSFUND RevenueAccounts R 101-41000-31000 Washington Cty. Tax Settlement$ 100,000.00 $ 50,000.00 $ - $50,000.0050.00% R 101-41000-31951 SA Penalties & Interest$ - 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 $ - $ 44,410.96 85.22% ExpenditureAccounts Dev Code Update; Financial Mgmt Plan; City Administration & Finance$ 250,000.00 $33,101.25$14,286.25$216,898.7513.24% Land Survey Fire Dept$ 75,000.00 $188,557.56$0.00($113,557.56)251.41% Public Works$ 10,000.00 $0.00$0.00$10,000.000.00% Defibrillator; Radios; Roof Community Center$ 15,000.00 $11,414.99$11,414.99$3,585.0176.10% Annex roof replacement 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 $249,168.04$25,701.24$157,831.9661.22% Page 5 of 8 CITY OF SCANDIA BUDGETYTDREVENUEAND EXPENSES Nov-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 $ 5,242.50 $ 2,835.50 $5,342.5049.53% Lilleskogen DNR Grant 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% Olson TOTALPARKDEVELOPMENTREVENUE$ 28,185.00 $ 13,242.50 $ 2,835.50 $14,942.5046.98% ExpenditureAccounts E 404-48000-530 Capital Impr Other Than Bldgs$40,585.00$9,345.38$2,800.00$31,239.6223.03%Lilleskogen improvements 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 $9,345.38$2,800.00$32,679.6222.24% 406EQUIPMENTREPLACEMENTFUND RevenueAccounts$ 138,000.00 $ 107,037.80 $ 42,037.80 $30,962.2077.56% Sale of F250, tractor & mower ExpenditureAccounts$ 52,500.00 $ 144,035.03 $ 219.31 ($91,535.03)274.35% 408LOCALROADIMPROVEMENT FUND RevenueAccounts$ 518,539.00 $ 299,269.50 $ (44,681.00) $219,269.5057.71% reclassed Small Cities Assist Grant ExpenditureAccounts$ 845,000.00 $ 820,568.39 $ 35,408.53 $24,431.6197.11% Page 6 of 8 CITY OF SCANDIA BUDGETYTDREVENUEAND EXPENSES Nov-21 2021Budget2021YTD2021MTD2021BudgetBal% ofBudgetNotes 602BIGMARINESEWER FUND RevenueAccounts$ 98,945.00 $ 79,231.97 $ 12,950.73 $19,713.0380.08% ExpenditureAccounts E 602-43210-101 Regular Wages & Salaries$20,000.00$9,398.32$848.42$10,601.6846.99% E 602-43210-102 OT Regular Wages$0.00$440.56$132.17-$440.56#DIV/0! E 602-43210-121 PERA Coord. Employer Contribu.$1,500.00$684.14$73.55$815.8645.61% E 602-43210-122 FICA Employer Contribution$1,200.00$576.67$57.97$623.3348.06% E 602-43210-126 MEDICARE Employer Contribution$300.00$143.69$13.56$156.3147.90% 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$0.00$91.0054.50% E 602-43210-210 Operating Supplies$2,400.00$557.95$0.00$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$0.00-$596.50107.46% E 602-43210-308 Other Professional Services$2,200.00$3,253.50$586.50-$1,053.50147.89% 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$1,006.27$115.87$393.7371.88% E 602-43210-321 Telephone$2,100.00$2,114.34$203.52-$14.34100.68% E 602-43210-322 Postage$550.00$0.00$0.00$550.000.00% E 602-43210-331 Travel Expenses$200.00$7.85$7.85$192.153.93% E 602-43210-334 Licenses & Permits$1,600.00$1,179.79($390.00)$420.2173.74% 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,549.13$129.99$950.8761.97% E 602-43210-385 Sewer Pumping & Maintenance$9,000.00$5,364.00$5,364.00$3,636.0059.60% 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$3,137.00$495.00$5,863.0034.86% E 602-43210-530 Capital Impr Other Than Bldgs$29,000.00$0.00$0.00$29,000.000.00% TOTALBIGMARINESEWEREXPENDITURES$ 167,005.00 $51,218.64$7,638.40$ 115,786.36 30.67% Page 7 of 8 CITY OF SCANDIA BUDGETYTDREVENUEAND EXPENSES Nov-21 2021Budget2021YTD2021MTD2021BudgetBal% ofBudgetNotes 612UPTOWNSEWERFUND RevenueAccounts$ 23,000.00 $ 11,032.18 $ 4,154.13 $11,967.8247.97% ExpenditureAccounts E 612-43210-101 Regular Wages & Salaries$8,700.00$3,183.29$267.90$5,516.7136.59% E 612-43210-121 PERA Coord. Employer Contribu.$700.00$221.51$20.10$478.4931.64% E 612-43210-122 FICA Employer Contribution$500.00$186.82$15.84$313.1837.36% E 612-43210-126 MEDICARE Employer Contribution$100.00$46.29$3.70$53.7146.29% 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$0.00$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$0.00-$6,147.002149.00% E 612-43210-308 Other Professional Services$400.00$192.00$64.00$208.0048.00% E 612-43210-317 Employee Training$350.00$275.00$275.00$75.0078.57% 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$504.32$51.94$1,195.6829.67% 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 $11,627.27$698.48$15,979.7342.12% TOTALREVENUEWITHOUTTRANSFERS$ 3,250,794.00 $ 2,514,425.54 $ 111,316.41 $ 736,368.46 77.35% TOTALREVENUEACCOUNTS$ 3,250,794.00 $ 6,151,638.49 $ 217,316.41 $ 964,549.77 189.23% TOTALEXPENDITURESWITHOUTTRANSFERS$ 3,690,702.00 $ 2,934,844.98 $ 175,966.76 $ 755,857.02 79.52% TOTALEXPENDITUREACCOUNTS$ 4,035,697.00 $ 6,916,996.41 $ 283,826.76 $ (2,881,299.41) 171.40% Page 8 of 8