06.b Treasurer's Monthly Report 2022City of Scandiaaug
Treasurer’sReport
2/28/2022
REVISED 2-22-22
FUND ACCOUNTING
Beginning Cash Balance $ 4,392,949.202/1/2022
Beginning Checking Balance$ 718,621.81
Checking Receipts 48,892.04
Transfers to Checking
Total Deposits 48,892.04
Expenditures$ (173,930.69)
Payroll$ (38,025.66)
Total Payments 211,956.35)
Ending Checking Balance 555,557.50
Beginnging Money Market Balance 1,645,714.97
Money Market Receipts 315.62
Tranfers to Checking
Ending Money Market Balance 1,646,030.59
Beginning Investments Balance 2,027,878.34
Investments Receipts
Ending Investments Balance$ 2,027,878.34
Beginning EDA Balance$ 28,903.67
EDA Receipts
EDA Expenditures
EDA Transfers from Checking - in transit
Ending EDA Balance$ 28,903.67
Outstanding Checks 9,584.93)
2/28/2022EndingCashBalance $ 4,248,785.17
CHECKING, MONEY MARKET & INVESTMENT CD's
Checking *102$ 718,621.81BegBal
Credits$ 48,892.04
Debits$ (211,956.35)
555,557.50EndBal
Money Market *105 - Rate .25%$ 1,645,714.97BegBal
rate change from 1.25% Credits 315.62
Debits
End Bal$ 1,646,030.59
Investments
CD *4422 - Rate .90% 12 mo., 3/25/2022$ 316,981.13
CD *4424 - Rate .30% 12 mo., 7/25/2022$ 440,699.35
CD *4425 - Rate .30% 12 mo., 9/28/2022$ 732,986.74
CD *4426 - Rate .30% 12 mo., 1/29/2023 537,211.12
Total Investments$ 2,027,878.34
Total Bank & Investment Accounts 4,229,466.43
9,584.93) Checks in Transit *3102
Deposit in transit checking
Deposit in transit money market
4,219,881.50TotalAdjustedUndesignatedFunds
Scandia EDA *6301 $ 28,903.67
Receipts
Expenditures
Checks in Transit
Deposit in Transit
Total Designated EDA Funds$ 28,903.67
Total Funds$ 4,248,785.17
Submitted by: Colleen Firkus, Treasurer
CASH BALANCES
2022END OF MONTH
FUNDJANUARYFEBRUARY
101 GENERAL$1,375,256$1,243,314
203 COVID-19 RELIEF$228,181$228,181
226 CABLE TV$39,431$41,288
230 RESTRICTED DONATIONS$175$175
307 BLACKTOP 2007$0$0
313 EQUIPMENT CERTIFICATES$24,314$24,314
315 EQUIPMENT CERTIFICATES$15,452$15,452
317 EQUIPMENT CERTIFICATES($298)($298)
318 BLACKTOP PROJECT$603$603
401 CAPITAL IMPR$818,050$811,650
404 PARK CAP IMPR$144,888$144,888
406 EQUIPMENT REPLACEMENT$316,105$316,105
408 LOCAL ROAD IMPROVEMENT$1,258,340$1,248,056
602 BIG MARINE SEWER$96,113$91,196
612 UPTOWN SEWER$14,094$16,430
801 ESCROW$33,341$38,526
SUBTOTAL$4,364,046$4,219,881.50
225 EDA$28,904$28,904
TOTAL$4,392,949$4,248,785.17
CITY OFSCANDIA
REVENUE SUMMARY
February 2022
ofYTDYTDBudgetGENERALFUNDBudgetBudgetYTDAmountMTDAmountBalance
Administration & Finance
R 101-41000-31000 Washington Cty. Tax Settlement$1,583,000.00$0.00$0.00$1,583,000.000.00%
R 101-41000-31040 Fiscal Disparities$0.00$0.00$0.00$0.000.00%
R 101-41000-31701 Gravel Taxes$20,000.00$0.00$0.00$20,000.000.00%
R 101-41000-31830 Solar Energy Production Tax$5,000.00$0.00$0.00$5,000.000.00%
R 101-41000-31900 Penalties & Interest Del Tax$400.00$0.00$0.00$400.000.00%
R 101-41000-32150 Utility-ROW Permits$3,000.00$1,050.00$750.00$1,950.0035.00%
R 101-41000-32180 Tobacco & Liquor Licenses$8,500.00$397.00$0.00$8,103.004.67%
R 101-41000-32190 Other City Permits$3,000.00$785.00$675.00$2,215.0026.17%
R 101-41000-32210 Building Permits$135,000.00$18,207.92$9,974.10$116,792.0813.49%
R 101-41000-32260 Gambling Permits$0.00$100.00$100.00-$100.000.00%
R 101-41000-33401 LGA/MVHC/AG/PERA Aid$13,200.00$0.00$0.00$13,200.000.00%
R 101-41000-33420 Fire Relief State PERA$39,600.00$0.00$0.00$39,600.000.00%
R 101-41000-33422 Other State Grants & Aids$5,400.00$0.00$0.00$5,400.000.00%
R 101-41000-33428 PILOT$6,000.00$0.00$0.00$6,000.000.00%
R 101-41000-33620 Recycling Grant$9,000.00$0.00$0.00$9,000.000.00%
R 101-41000-33630 Local Govt Grants & Aids$0.00$0.00$0.00$0.00#DIV/0!
R 101-41000-33640 Other Grants$1,000.00$0.00$0.00$1,000.000.00%
R 101-41000-34102 Legal Services$0.00$0.00$0.00$0.00#DIV/0!
R 101-41000-34103 Zoning and Planning$4,300.00$250.00$250.00$4,050.005.81%
R 101-41000-34106 Engineering Fees$0.00$0.00$0.00$0.00#DIV/0!
R 101-41000-34107 Assessment Search Fees$100.00$20.00$0.00$80.0020.00%
R 101-41000-34109 Water Usage$200.00$0.00$0.00$200.000.00%
R 101-41000-34201 Impound Fees$0.00$0.00$0.00$0.00#DIV/0!
R 101-41000-34202 Fire Protection Services$32,300.00$0.00$0.00$32,300.000.00%
R 101-41000-34301 Damage Repairs$0.00$0.00$0.00$0.00#DIV/0!
R 101-41000-34303 Dust Control$2,400.00$0.00$0.00$2,400.000.00%
R 101-41000-34304 Reimbursement for Services$3,600.00$0.00$0.00$3,600.000.00%
R 101-41000-34305 Other Street Services$0.00$0.00$0.00$0.00#DIV/0!
R 101-41000-34730 Ad Revenue$2,100.00$0.00$0.00$2,100.000.00%
R 101-41000-34740 Coffee Sales$0.00$0.00$0.00$0.00#DIV/0!
R 101-41000-34750 Facilities Rental$5,000.00$378.00$78.00$4,622.007.56%
R 101-41000-34760 Cleaning Fees$200.00$0.00$0.00$200.000.00%
R 101-41000-34790 Recreation Programs$1,000.00$1,400.00$140.00-$400.00140.00% Skating Program
R 101-41000-34950 Solar Subscription$0.00$0.00$0.00$0.00#DIV/0!
R 101-41000-35101 Fines & Forfeitures$7,000.00$754.93$754.93$6,245.0710.78%
R 101-41000-35201 Forfeited Land Sales$0.00$0.00$0.00$0.00#DIV/0!
R 101-41000-36210 Interest Income$15,900.00$1,415.86$320.65$14,484.148.90%
R 101-41000-36230 Donations$1,500.00$2,841.35$1,041.35-$1,341.35189.42% Ice Sculpture $2,600; Buttons $241.35
R 101-41000-36240 Insurance Dividend$2,000.00$0.00$0.00$2,000.000.00%
R 101-41000-36250 Misc. Refund$2,500.00$49.95$49.95$2,450.052.00%
R 101-41000-38050 Cable TV Franchise Rebates$0.00$0.00$0.00$0.00#DIV/0!
R 101-41000-39200 Interfund Budgeted Transfers$0.00$0.00$0.00$0.00#DIV/0!
1,912,200.00$27,650.01$14,133.98$1,884,549.99TOTAL1.45%
INTERFUND OPERATING TRANSFERS
R 101-49000-39203 Transfer from Other Funds$0.00$0.00$0.00$0.000.00%
R 101-49000-39204 Money Market Transfer$0.00$0.00$0.00$0.000.00%
COVID-19RELIEF (ARPA)
R 203-46200-33150 Federal Grant$0.00$0.00$0.00$0.000.00%
R 203-46200-39200 Interfund Operating Transfer$0.00$0.00$0.00$0.000.00%
0.00$0.00$0.00$0.00TOTAL
EDA
R 225-46500-31000 Washington Cty. Tax Settlement$8,000.00$0.00$0.00$8,000.0031.25%
R 225-46500-33640 Other Grants$0.00$0.00$0.00$0.000.00%
R 225-46500-36210 Interest Income$200.00$0.00$0.00$200.000.00%
R 225-46500-39203 Transfer from Other Funds$0.00-$84.88($84.88)$84.880.00% 2021 interest booked back to 2021
8,200.00-$84.88-$84.88$8,284.88TOTAL-1.04%
CABLETV
R 226-41950-36210 Interest Income$0.00$0.00$0.00$0.000.00%
R 226-41950-38050 Cable TV Franchise Rebates$15,400.00$1,506.08$1,506.08$13,893.920.00%
R 226-41950-38051 PEG Fees$3,500.00$420.10$420.10$3,079.900.00%
18,900.00$1,926.18$1,926.18$16,973.82TOTAL10.19%
ofYTDYTDBudgetGENERALFUNDBudgetBudgetYTDAmountMTDAmountBalance
67,000.00$0.00$0.00$67,000.000.00% R 313-47000-31000 Washington Cty. Tax Settlement
34,524.00$0.00$0.00$34,524.000.00% R 317-47000-31000 Washington Cty. Tax Settlement
344,531.00$0.00$0.00$344,531.000.00% R 318-47000-31000 Washington Cty. Tax Settlement
CAPITALIMPROVEMENTS
R 401-48000-31000 Washington Cty. Tax Settlement$217,336.00$0.00$0.00$217,336.000.00%
R 401-48000-31951 Special Assessments Principal$0.00$0.00$0.00$0.000.00%
R 401-48000-31952 SA Penalties & Interest$0.00$0.00$0.00$0.000.00%
R 401-48000-33422 Other State Grants & Aids$240,625.00$0.00$0.00$240,625.000.00%
R 401-48000-33640 Other Grants$0.00$0.00$0.00$0.000.00%
R 401-48000-36100 Special Assessments$510.00$0.00$0.00$510.000.00%
R 401-48000-36210 Interest Income$4,500.00$0.00$0.00$4,500.000.00%
R 401-48000-36230 Donations$0.00$0.00$0.00$0.000.00%
R 401-48000-39200 Interfund Operating Transfer$200,000.00$0.00$0.00$200,000.000.00%
662,971.00$0.00$0.00$662,971.00TOTAL0.00%
PARKDEVELOPMENT
R 404-48000-31000 Washington Cty. Tax Settlement$20,000.00$0.00$0.00$20,000.000.00%
R 404-48000-33422 Other State Grants & Aids$104,000.00$0.00$0.00$104,000.000.00%
R 404-48000-33640 Other Grants$0.00$0.00$0.00$0.000.00%
R 404-48000-34780 Park Dedication Fees$3,000.00$0.00$0.00$3,000.000.00%
R 404-48000-36210 Interest Income$1,200.00$0.00$0.00$1,200.000.00%
R 404-48000-36230 Donations$0.00$0.00$0.00$0.000.00%
R 404-48000-39203 Transfer from Other Funds$0.00$0.00$0.00$0.000.00%
128,200.00$0.00$0.00$128,200.00TOTAL0.00%
EQUIPMENT REPLACEMENT
R 406-48500-31000 Washington Cty. Tax Settlement$87,800.00$0.00$0.00$87,800.000.00%
R 406-48500-36210 Interest Income$1,015.00$0.00$0.00$1,015.000.00%
R 406-48500-36260 Sale of Equipment$0.00$0.00$0.00$0.000.00%
R 406-48500-39200 Interfund Operating Transfer$0.00$0.00$0.00$0.000.00%
R 406-48500-39350 Certificate of Indebtedness$0.00$0.00$0.00$0.000.00%
88,815.00$0.00$0.00$88,815.00TOTAL0.00%
LOCAL ROADIMPROVEMENT FUND
R 408-43100-31000 Washington Cty. Tax Settlement$216,860.00$0.00$0.00$216,860.000.00%
R 408-43100-33422 Other State Grants & Aids$0.00$0.00$0.00$0.000.00%
R 408-43100-34304 Reimbursement for Services$0.00$0.00$0.00$0.000.00%
R 408-43100-36100 Special Assessments$0.00$0.00$0.00$0.000.00%
R 408-43100-36210 Interest Income$19,613.00$0.00$0.00$19,613.000.00%
R 408-43100-39203 Transfer from Other Funds$0.00$0.00$0.00$0.000.00%
R 408-43100-39310 Proceeds-Gen Obligation Bond$0.00$0.00$0.00$0.000.00%
236,473.00$0.00$0.00$236,473.00TOTAL0.00%
BIGMARINE SEWERFUND
R 602-43210-31951 Special Assessments Principal$0.00$0.00$0.00$0.000.00%
R 602-43210-31952 SA Penalties & Interest$0.00$0.00$0.00$0.000.00%
R 602-43210-33422 Other State Grants & Aids$0.00$0.00$0.00$0.000.00%
R 602-43210-34401 Sewer User Fees$109,592.00$341.39$115.00$109,250.610.00%
R 602-43210-34402 SEWER HOOKUP FEE$0.00$0.00$0.00$0.000.00%
R 602-43210-36100 Special Assessments$300.00$0.00$0.00$300.000.00%
R 602-43210-36210 Interest Income$49.00$0.00$0.00$49.000.00%
R 602-43210-36250 Misc. Refund$0.00$0.00$0.00$0.000.00%
R 602-43210-36270 Capital Contribution$0.00$0.00$0.00$0.000.00%
R 602-43210-39200 Interfund Operating Transfer$0.00$0.00$0.00$0.000.00%
109,941.00$341.39$115.00$109,599.61TOTAL0.31%
UPTOWN SEWERFUND
R 612-43210-31000 Washington Cty. Tax Settlement$0.00$0.00$0.00$0.000.00%
R 612-43210-33422 Other State Grants & Aids$0.00$0.00$0.00$0.000.00%
R 612-43210-34105 Sale of Maps and Publications$0.00$0.00$0.00$0.000.00%
R 612-43210-34401 Sewer User Fees$19,500.00$0.00$0.00$19,500.000.00%
R 612-43210-36210 Interest Income$92.00$0.00$0.00$92.000.00%
R 612-43210-36250 Misc. Refund$0.00$0.00$0.00$0.000.00%
R 612-43210-39203 Transfer from Other Funds$0.00$0.00$0.00$0.000.00%
19,592.00$0.00$0.00$19,592.000.00% TOTAL
3,631,347.00$29,832.70$16,090.28$3,601,514.300.82% REPORTTOTAL
CITY OF SCANDIA
EXPENDITURE SUMMARY
February 2022
FUNDS ofBUDGET2022BUDGETYTDAMOUNTMTDAMOUNTBALOFBUDGET
GENERAL FUND
373,700.00Administration & Finance$33,773.92$15,214.94$339,926.089.04%
23,000.00-$41.79-$4,827.82$23,041.79CityCouncil-0.18% Jan. expenses booked back to2021
Annual Equipment Maintenance7,600.00$1,515.00$1,515.00$6,085.00Elections19.93% Agreement
171,920.00$16,545.58$11,245.77$155,374.42Planning & Building9.62%
21,600.00$3,600.00$1,800.00$18,000.00Assessor16.67%
150,900.00$309.36$0.00$150,590.64Police0.21%
280,190.00$30,484.13$19,502.58$249,705.87FireDept10.88%
4,000.00$0.00$0.00$4,000.00AnimalControl0.00%
683,490.00$76,110.20$47,947.60$607,379.80PublicWorks11.14%
94,950.00$15,042.25$11,103.27$79,907.75 Events $3,393; Jellum bench $1,487;
Parks & Recreation15.84% Wages $5,424; WC Ins. $1,915
73,950.00$8,232.99$6,749.36$65,717.01CommunityCenter11.13% Freezer $1,999
1,885,300.00$185,571.64$110,250.70$1,699,728.36TOTAL9.84%
0.00$0.00$0.00$0.00OperatingTransfers
COVID-19RELIEF$0.00$0.00$0.00$0.00 0.00%
EDA$10,175.00$44.00$44.00$10,131.00 0.43%
CABLE TV$11,750.00$111.17$111.17$11,638.83 0.95%
2013 EQUIPMENT CERTIFICATES$63,285.00$0.00$0.00$63,285.00 0.00%
2017 EQUIPMENT CERTIFICATES$33,375.00$440.00$0.00$32,935.00 1.32%
BLACKTOP PROJECT 2018$328,620.00$0.00$0.00$328,620.00 0.00%
CAPITAL IMPROVEMENTS
319,280.00$0.00$0.00$319,280.00Administration & Finance0.00%
52,000.00$0.00$0.00$52,000.00CommunityCenter0.00%
286,000.00$0.00$0.00$286,000.00CapitalImprovements0.00%
657,280.00$0.00$0.00$657,280.00TOTAL 0.00%
PARK DEVELOPMENT$236,048.00$3,000.00$0.00$233,048.00 1.27%
EQUIPMENT REPLACEMENT$198,500.00$0.00$0.00$198,500.00 0.00%
LOCAL ROAD IMPROVEMENT FUND$707,200.00$321.86$321.86$707,200.00 0.05%
BIG MARINE SEWER$225,062.00$5,063.63$3,114.95$219,998.37 2.25%
UPTOWN SEWER$76,850.00$1,647.17$842.08$75,202.83 0.00%
4,433,445.00$196,199.47$114,684.76$4,237,567.39REPORTTOTAL2.03%