Loading...
6.b1 March 2021 Treasurer's ReportrSCANDIA Staff Report Date of Meeting: April 20, 2021 To: City Council From: Colleen Firkus, Treasurer Re: Revised February Treasurer's Report & March Treasurer's Report In this meeting packet is a February 2021 Treasurer's Report revised 3/25/21. This is different from the previous report in that the beginning cash balance was changed to reflect the completion of the annual audit and audit journal entries, and I changed the format. The ending cash balance remained the same and is now in agreement with the February Cash Balance report. There were approximately 64 journal entries made to close out the books for the year involving booking accounts payable, receivable, delinquent taxes, depreciation, deferred revenue, interfund loans, coding errors, inventory, and prior year corrections. Therefore, January and February financial reports change due to these journal entries. The audit went very well for our first remote audit. It was actually a very efficient way of doing it and our Laserfiche system with all our data digitized made all the difference. With the March 2021 Treasurer's Report, I am including a report called Budget Control Summary to replace the Expenditure Summary. This summarizes both Revenues and Expenses for all funds and compares them to the budget. I won't be at this meeting to take questions as I will be in the North Carolina visiting my brothers and my daughter. Please feel free to reach out to me with any questions you may have regarding these reports. aug . City of Scandia Treasurer's Report SCANT A 3/31/2021 FUND ACCOUNTING Beginning Cash Balance 3/1/2021 $ 4,454,830.03 Beginning Checking Balance $ 59,422.56 Checking Receipts $ 18,655.47 Transfers to Checking $ 174,056.52 Total Deposits $ 192,711.99 Expenditures $ (166,402.83) Payroll $ 45,576.44 Total Payments $ (211,979.27) Ending Checking Balance $ 40,155.28 Beginnging Money Market Balance $ 2,396,444.24 Money Market Receipts $ 32,417.53 Tranfersto Checking $ (174,000.00) Ending Money Market Balance $ 2,254,861.77 Beginning Investments Balance $ 2,021,363.11 Investments Receipts $ 1,240.89 Ending Investments Balance $ 2,022,604.00 Beginning EDA Balance $ 26,909.16 EDA Receipts EDA Expenditures $ (25.00) EDA Transfers $ (56.52) Ending EDA Balance $ 26,827.64 Ending Cash Balance 3/31/2021 $ 4,344,448.69 CHECKING MONEY MARKET &INVESTMENT CD's Checking *102 Beg Balance $ 59,422.56 Credits $ 192,711.99 Debits $ (203,556.16) Checks in Transit *3102 $ (8,423.11) Deposit in transit checking $ End Balance $ 40,155.28 Money Market *105 - Rate .25% Beg Balance $ 2,396,444.24 rate change from 1.25% Credits $ 32,417.53 Debits $ (174,000.00) Deposit in transit money market $ End Balance $ 2,254,861.77 Investments CD *4422 - Rate .30% 12 mo., 3/25/2022 CD *4424 - Rate .30% 12 mo., 7/25/2021 CD *4425 - Rate 1.75% 12 mo., 9/28/2021 CD *4426 - Rate 1.60% 12 mo., 1/29/2021 Total Investments Designated Funds Total Bank & Investment Accounts Scandia EDA *6301 Beg Balance Receipts Expenditures Checks in Transit Deposit in Transit 3/1/2021 Total Designated Funds Total Funds Submitted by: Colleen Firkus, Treasurer $ 316,266.61 $ 439,388.14 $ 731,336.49 $ 535,612.76 $ 26,909.16 $ (81.52) $ 2,022,604.00 $ 4,317,621.05 $ 26,827.64 nt i n n e s u[ a CASH BALANCES 2021 END OF MONTH REVISED 3-25-21 FUND JANUARY FEBRUARY MARCH 101 GENERAL $1,587,928 $1,434,436 $1,297,969 203 COVID-19 RELIEF ($2,690) ($2,690) ($2,690) 226 CABLE TV $21,930 $23,775 $25,569 230 RESTRICTED DONATIONS $175 $175 $175 307 BLACKTOP 2007 $91 $0 $0 313 EQUIPMENT CERTIFICATES $21,089 $21,089 $21,089 315 EQUIPMENT CERTIFICATES $15,452 $15,452 $15,452 317 EQUIPMENT CERTIFICATES ($2,468) ($2,468) ($2,468) 318 BLACKTOP PROJECT ($15,633) ($15,633) ($15,633) 401 CAPITAL IMPR $939,628 $957,772 $957,772 404 PARK CAP IMPR $157,785 $149,599 $152,599 406 EQUIPMENT REPLACEMENT $181,596 $183,483 $183,483 408 LOCAL ROAD IMPROVEMENT $1,599,921 $1,596,279 $1,578,514 602 BIG MARINE SEWER $48,621 $43,641 $49,211 612 UPTOWN SEWER $22,458 $20,116 $18,996 801 ESCROW $28,797 $27,605 $37,583 SUBTOTAL $4,604,681 $4,452,631.91 $4,317,621 225 EDA $26,959 $26,852.64 $26,828 TOTAL $4,631,640 $4,479,484.55 $4,344,449 CITY OF SCANDIA i ' I� • . SCANDN A Budget Contol Summary �r . j t'L March 2021 FUND 101 GENERAL FUND 2021 Budget 2021 YTD 2021 MTD 2021 Budget Bal % of Budget Revenue Accounts R 101-41000-31000 Washington Cty. Tax Settlement $ 1,381,700.00 $ $ $ 1,381,700.00 0.00% R 101-41000-31040 Fiscal Disparities $ - $ $ $ - 0.00% R 101-41000-31701 Gravel Taxes $ 10,000.00 $ $ $ 10,000.00 0.00% R 101-41000-31830 Solar Energy Production Tax $ 6,000.00 $ $ $ 6,000.00 0.00% R 101-41000-31900 Penalties & Interest Del Tax $ 1,000.00 $ $ $ 1,000.00 0.00% R 101-41000-32150 Utility Permits $ 1,800.00 $ 750.00 $ 600.00 $ 1,050.00 41.67% R 101-41000-32180 Tobacco & Liquor Licenses $ 8,200.00 $ 2,200.00 $ $ 6,000.00 26.83% R 101-41000-32190 Other City Permits $ 2,900.00 $ 92250 $ 548.00 $ 1,977.50 31.81% R 101-41000-32210 Building Permits $ 95,500.00 $ 33,706.20 $ 11,578.77 $ 61.793.80 3529% R 101-41000-32260 Gambling Permits $ - $ - $ - $ 0.00% R 101-41000-33401 LGA/MVHC/AG/PERA Aid $ 13,000.00 $ $ $ 13,000.00 0.00% R 101-41000-33420 Fire Relief State PERA $ 33,700.00 $ - $ $ 33,700.00 0.00% R 101-41000-33422 Other State Grants & Aids $ 10,200.00 $ 310.00 $ 310.00 $ 9,890.00 3.04% R 101-41000-33428 PILOT $ 6,000.00 $ - $ - $ 6,000.00 0.00% R 101-41000-33620 Recycling Grant $ 8.000.00 $ $ $ 8,000.00 0.00% R 101-41000-33630 Local Govt Grants & Aids $ - $ $ $ - 0.00% R 101-41000-33640 Other Grants $ 4,000.00 $ 724.00 $ $ 3,276.00 18.10% R 101-41000-34102 Legal Services $ - $ - $ $ - 0.00% R 101-41000-34103 Zoning and Planning $ 3,400.00 $ 3,350.00 $ 2,65000 $ 50.00 9853% R 101-41000-34106 Engineering Fees $ - $ - $ - $ - 0.00% R 101-41000-34107 Assessment Search Fees $ $ $ $ - 0.00% R 101-41000-34109 Water Usage $ 200.00 $ $ $ 200.00 0.00% R 101-41000-34201 Impound Fees $ 200.00 $ $ $ 200.00 0.00% R 101-41000-34202 Fire Protection Services $ 36,800.00 $ $ $ 36,800.00 0.00% R 101-41000-34301 Damage Repairs $ - $ 3,678.24 $ 3,678.24 $ (3,678.24) 0.00% R 101-41000-34303 Dust Control $ 2,400.00 $ $ - $ 2,400.00 0.00% R101-41000-34304 Reimbursement for Services $ 3,600.00 $ 1,800.00 $ $ 1,800.00 50.00% R 101-41000-34305 Other Street Services $ - $ 100.00 $ 100.00 $ (100.00) 0.00% R 101-41000-34730 Ad Revenue $ $ 500.00 $ - $ (500.00) 0.00% R 101-41000-34740 Coffee Sales $ $ - $ - $ - 0.00% R 101-41000-34750 Facilities Rental $ 3,000.00 $ 1,082.06 $ 300.00 $ 1,917.94 36.07% R 101-41000-34760 Cleaning Fees $ $ - $ - $ - 0.00% R 101-41000-34790 Recreation Programs $ - $ 740.00 $ $ (740.00) 0.00% R 101-41000-34950 Solar Subscription $ 9,000.00 $ - $ $ 9,000.00 0.00% R 101-41000-35101 Fines & Forfeitures $ 8,100.00 $ 1,542.41 $ 281.09 $ 6,557.59 19.04% R 101-41000-35201 Forfeited Land Sales $ - $ - $ - $ - 0.00% R 101-41000-36210 Interest Income $ 17,900.00 $ 5,251.30 $ 1,732.08 $ 12,648.70 29.34% R 101-41000-36230 Donations $ 5,000.00 $ 1,450.00 $ 50.00 $ 3,550.00 29.00% R 101-41000-36240 Insurance Dividend $ 1,400.00 $ - $ - $ 1,400.00 0.00% R 101-41000-36250 Misc. Refund $ 500.00 $ 1,668.60 $ 738.00 $ (1,168.60) 333.72% R 101-41000-38050 Cable TV Franchise Rebates $ - $ - $ - $ 0.00% R 101-41000-39200 Interfund Operating Transfer $ 1,440.00 $ - $ - $ 1.440.00 0.00% TOTAL GENERAL FUND REVENUES $ 1,674,940.00 $ 59,775.31 $ 22,566.18 $ 1.615,164.69 3.57% R 101-49000-39204 Money Market Transfer $ $ 519,056.52 $ 174,056.52 $ (519,056.52) Page 1 of 3 FUND 101 GENERAL FUND Expenditure Accounts $ 2021 Budget 2021 YTD - 2021 MTD 2021 Budget Bal % of Budget Administration & Finance $ 387,272.00 $ 193,127.94 $ 142,569.78 $ 194,144.06 49.87% City Council $ 19,982.00 $ 8,613.50 $ (4,952.33) $ 11,368.50 43.11% Elections $ 1,030.00 $ 1,470.00 $ 3,874.26 $ (440.00) 142.72% Planning & Building $ 118,050.00 $ 20,328.41 $ 10,216.39 $ 97,721.59 17.22% Assessor $ 21,600.00 $ 5,100.00 $ 1,700.00 $ 16,500.00 23.61% Police $ 147,460.00 $ - $ - $ 147,460.00 0.00% Fire Dept $ 262,778.00 $ 49,168.89 $ 16,154.45 $ 213,609.11 18.71% Animal Control $ 2,000.00 $ 630.17 $ 302.33 $ 1,369.83 31.51% Public Works $ 658,253.00 $ 140,797.11 $ 55,364.98 $ 517,455.89 21.39% Parks & Recreation $ 90,797.00 $ 23,483.03 $ 6,106.00 $ 67,313.97 25.86% Community Center $ 68,500.00 $ 10,073.25 $ 4,870.76 $ 58,426.75 14.71% TOTAL GENERAL EXPENDITURES $ 1,777,722.00 $ 452,792.30 $ 232,332.36 $ 1,324,929.70 25.47% Transfers Between Accounts $ 280,000.00 $ 419,000.00 $ 74,000.00 $ (139,000.00) 325,220.00 FUND 225 EDA Revenue Accounts $ 5,000.00 $ - $ - $ 5,000.00 0.00% Expenditure Accounts $ 1,900.00 $ 125.00 $ 25.00 $ 1,775.00 6.58% FUND 226 CABLE TV Revenue Accounts $ 16,500.00 $ 3,874.26 $ 1,914.17 $ 12,625.74 23.48% Expenditure Accounts $ 10,500.00 $ 395.64 $ 120.43 $ 10,104.36 3.77% FUND 313 2013 EQUIPMENT CERTIFICATES Revenue Accounts $ 68,220.00 $ - $ 68,220.00 0.00% Expenditure Accounts $ 64,995.00 $ $ 64,995.00 0.00% FUND 317 2017 EQUIPMENT CERTIFICATES Revenue Accounts $ 35,909.00 $ - $ 35,909.00 0.00% Expenditure Accounts $ 34,223.00 $ 864.00 $ 33,359.00 2.52% FUND 318 BLACKTOP PROJECT 2018 Revenue Accounts $ 341,456.00 $ - $ $ 341,456.00 0.00% Expenditure Accounts $ 325,220.00 $ $ $ 325,220.00 0.00% FUND 401 CAPITAL IMPROVEMENTS Revenue Accounts $ 300,500.00 $ $ $ 300,500.00 0.00% Expenditure Accounts Administration & Finance 5 250,000.00 $ 6,503.75 $ 243,496.25 2.60% Fire Dept Sc 75,000.00 $ - $ 75,000.00 0.00% Public Works 5 10,000.00 $ $ 10,000.00 0.00% Community Center 5 15,000.00 $ 3,694.20 $ 11,305.80 24.63% Capital Improvements $ 47,000.00 $ (3,694.20) $ 60,694.20 -7.86% Operating Transfer $ 10,000.00 $ - $ - 0.00% TOTAL CAPITAL IMPROVEMENTS $ 407,000.00 $ 6,503.75 $ $ 400,496.25 1.60% Page 2 of 3 FUND 404 PARK CAPITAL IMPROVEMENTS 2021 Budget 2021 YTD 2021 MTD 2021 Budget Bal % of Budget Revenue Accounts $ 28,185.00 $ 3,000.00 $ 3,000.00 $ 25,185.00 10.64% Expenditure Accounts $ 42,025.00 $ 900.00 $ - $ 41,125.00 2.14% FUND 406 EQUIPMENT REPLACEMENT Revenue Accounts $ 138,000.00 $ - $ $ 138,000.00 0.00% Expenditure Accounts $ 52,500.00 $ $ $ 52,500.00 0.00% FUND 408 LOCAL ROAD IMPROVEMENT FUND Revenue Accounts $ 518,539.00 $ - $ - $ 518,539.00 0.00% Expenditure Accounts $ 845,000.00 $ 17,764.96 $ 17,764.96 $ 827,235.04 2.10% FUND 602 BIG MARINE SEWER Revenue Accounts $ 98,945.00 $ 12,252.86 $ 11,768.98 $ 86,692.14 12.38% Expenditure Accounts $ 167,005.00 $ 9,812.24 $ 6,016.02 $ 157,192.76 5.88% FUND 612 UPTOWN SEWER Revenue Accounts $ 23,000.00 $ - $ - $ 23,000.00 0.00% Expenditure Accounts $ 27,607.00 $ 1,860.49 $ 688.42 $ 25,746.51 6.74% TOTAL REVENUE ACCOUNTS $ 3,249,194.00 $ 597,958.95 $ 213,132.85 $ 2,651,235.05 18.40% TOTAL EXPENDITURE ACCOUNTS $ 4,035,697.00 $ 910,018.38 $ 330,947.19 $ 3,125,678.62 22.55% Page 3 of 3