Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
06.b Treasurer's Report June 2021
aug SCANDIA FUND ACCOUNTING Beginning Cash Balance 6/1/2021 Beginning Checking Balance Checking Receipts Transfers to Checking Total Deposits Expenditures Payroll Total Payments Ending Checking Balance City of Scandia Treasurer's Report 6/30/2021 $ 27,306.17 $ 30,614.07 $ 718,000.00 $ 748,614.07 $ (687,040.54) $ (29,522.02) $ (716,562.56) $ 3,908,204.94 Beginnging Money Market Balance $ 1,834,375.84 Money Market Receipts $ 43,207.13 Tranfers to Checking $ (718,000.00) Ending Money Market Balance $ 1,159,582.97 Beginning Investments Balance $ 2,023,314.97 Investments Receipts $ 791,29 Ending Investments Balance $ 2,024,106.26 Beginning EDA Balance $ 26,827.64 EDA Receipts EDA Expenditures 5 (2,190.00) EDA Transfers in Progress Ending EDA Balance $ 24,637.64 Outstanding Checks $ (4,732.89) Ending Cash Balance 6/30/2021 $ 3,262,951.66 CHECKING MONEY MARKET & INVESTMENT CD's Checking *102 Beg Bal $ 27,306.17 Credits $ 748,614.07 Debits $ (716,562.56) End Bal $ 59,357.68 Money Market •105 - Rate .25% Beg Bal $ 1,834,375.84 rate change from 1.25% Credits $ 43,207.13 Debits $ (718,000.00) End Bal $ 1,159,582.97 Investments CD *4422 - Rate .90% 12 mo., 3/25/2022 $ 316,504.89 CD *4424 - Rate .30% 12 mo., 7/25/2021 $ 439,713.17 CD *4425 - Rate 1.75% 12 mo., 9/28/2021 $ 731,889.50 CD *4426 - Rate 1.60% 12 mo., 1/29/2022 $ 535,998.70 Total Investments $ 2,024,106.26 Total Bank & Investment Accounts X243,046.91 Checks in Transit *3102 $ (4,732.89) Deposit in transit checking Deposit in transit money market Total Adjusted Undesignated Funds $ 3,238,314.02 Scandia EDA *6301 Receipts Expenditures Checks in Transit Deposit in Transit Total Designated EDA Funds Total Funds Submitted by: Colleen Firkus, Treasurer $ 26,827.64 $ (2,190.00) $ 24,637.64 $ 3,262,951.66 2021 FUND 101 GENERAL 203 COVID-19 RELIEF 226 CABLE TV 230 RESTRICTED DONATIONS 307 BLACKTOP 2007 313 EQUIPMENT CERTIFICATES 315 EQUIPMENT CERTIFICATES 317 EQUIPMENT CERTIFICATES 318 BLACKTOP PROJECT 401 CAPITAL IMPR 404 PARK CAP IMPR 406 EQUIPMENT REPLACEMENT 408 LOCAL ROAD IMPROVEMENT 602 BIG MARINE SEWER 612 UPTOWN SEWER 801 ESCROW 225 EDA SUBTOTAL TOTAL CASH BALANCES END OF MONTH JANUARY $1,587,928 ($2,690) $21,930 $175 $91 $21,089 $15,452 ($2,468) ($15,633) $939,628 $157,785 $181,596 $1,599,921 $48,621 $22,458 $28,797 $4,604,681 $26,959 $4,631,640 REVISED 3-25-21 FEBRUARY $1,434,436 ($2,690) $23,775 $175 $0 $21,089 $15,452 ($2,468) ($15,633) $957,772 $149,599 $183,483 $1,596,279 $43,641 $20,116 $27,605 $4,452,631.91 $26,85264 $4,479,484.55 MARCH $1,297,969 ($2,690) $25,569 $175 $0 $21,089 $15,452 ($2,468) ($15,633) $957,772 $152,599 $183,483 $1,578,514 $49,211 $18,996 $37,583 $4,317,621 $26,828 $4,344,449 APRIL $1,254,652 ($2,690) $27,490 $175 $0 $21,089 $15,452 ($2,468) ($15,633) $956,400 $152,599 $172,259 $1,570,663 $48,727 $18,189 $34,332 $4,251,236 $26,828 $4,278,063 MAY $1,171,412 ($2,690) $27,816 $175 $0 ($42,046) $15,452 ($2,468) ($68,490) $920,311 $151,742 $172,259 $1,438,677 $45,513 $21,112 $32,997 $3,881,772 $26,433 $3,908,205 JUNE $826,422 $1,275 $29,773 $175 $0 ($42,046) $15,452 ($2,468) ($68,490) $1,018,807 $152,599 $172,259 $1,024,391 $54,973 $21,015 $34,177 $3,238,314 $24,638 $3,262,952 I CITY OF SCANDIA SC/�11NDIA Budget YTD Revenue & Expenses June 2021 FUND 101 GENERAL FUND 2021 Budget Z021 YTD 21121 MTD 2021 Budget Bal % of Budget Revenue Accounts Administration & Finance S 387,272 00 $209,585.49 S 25,790 49 R 101-41000-31000 Washington Cly. Tax Settlement 51,381,700 00 50.00 S000 $1,381,700 00 000% R 101-41000-31040 Fiscal Disparities S000 50,00 S000 S000 000% R 101-41000-31701 Gravel Taxes 510,000,00 $0.00 S000 S10,00000 000% R 101-41000-31830 Solar Energy Production Tax 56,000.00 5605,77 50,00 S5,39423 8990% R 101-41000-31900 Penalties & Interest Del Tax 51,000,00 S000 S000 $1,00000 0 00 % R 101-41000-32150 Utility Permits 51,800,00 S1,65000 S45000 S60000 5833% R 101-41000-32180 Tobacco & Liquor Licenses 56,200.00 52,200.00 S000 S6,00000 26 83 % R 101-41000-32190 Other City Permits 52,900.00 51,792,50 566000 51,10750 4250% R 101-41000-32210 Building Permits $95,500,00 598,220.27 528,43259 (52,720,27) 5086% R 101-41000-32260 Gambling Permits S000 5100,00 S000 ($100.00) 0.00% R 101-41000-33401 LGA/MVHCIAG/PERA Aid 513,000,00 50,00 S000 S13,00000 0 00 % R 101-41000-33420 Fire Relief Stale PERA S33,70000 $0,00 50.00 S33,70000 0 00 % R 101-41000-33422 Other Stale Grants & Aids 510,200.00 53,810,00 S3,50000 S6,39000 3 04 % R 101-41000-33428 PILOT S6,00000 50.00 S000 56,000.00 0 00 % R 101-41000-33620 Recycling Grant S8,00000 513,062.00 S13,06200 (S5,06200) 0 00 % R 101-41000-33630 Local Govt Grants & Aids S000 50.00 S000 S000 0 00 % R 101-41000-33640 Other Grants S4,00000 5724.00 50.00 53,276.00 18 10% R 101-41000-34102 Legal Services $0.00 $0.00 S000 S000 0 00 % R 101-41000-34103 Zoning and Planning S3,40000 S4,300.00 S65000 (S90000) 105 88% R 101-41000-34106 Engineering Fees S000 50.00 50.00 S000 000% R 101-41000-34107 Assessment Search Fees S000 520.00 50.00 (520.00) 000% R 101-41000-34109 Water Usage S20000 S000 50,00 S20000 0 00 % R 101-41000-34201 Impound Fees S20000 S000 50,00 S20000 000% R 10141000-34202 Fire Protection Services $36,80000 S30,71000 50.00 56,090.00 83.45% R 101-41000-34301 Damage Repairs $0.00 S3,67824 S000 (S3,67824) 0 00 % R 101-41000-34303 Dust Control S2,40000 S000 S000 S2,40000 0 00 % R 101-41000-34304 Reimbursement for Services $3,600.00 S3,60000 (S17695) S000 50001/. R 101-41000-34305 Other Street Services 50.00 S2,076.95 $1,976.95 ($2,076.95) 0,00% R 101-41000-34730 Ad Revenue 51,600.00 S2,10000 51,550.00 (5500.00) 0,00% R 101-41000-34740 Coffee Sales 50,00 S000 50,00 S000 0 00 % R 101-41000-34750 Facilities Rental S3,00000 S2,68918 5660,68 531082 46.07% R 101-41000-34760 Cleaning Fees 50.00 5150.00 550.00 (S15000) 0001/6 R 101-41000-34790 Recreation Programs 50.00 S76500 50,00 (S76500) 0 00 % R 101-41000-34950 Solar Subscription S9,00000 S000 $0.00 59,000.00 0 00 % R 101-41000-35101 Fines & Forfeitures S8,10000 $3,567.46 5224.42 54,532.54 32.369/6 R 101-41000-35201 Forfeited Land Sales $000 S000 $0 00 50.00 0,00% R 101-41000-36210 Interest Income S17,90000 S7,97338 $1,12048 59,926,62 36.04% R 101-41000-36230 Donations 55,00000 51,450.00 5000 53,550.00 29,00% R 101-41000-36240 Insurance Dividend 51,40000 50.00 50.00 51,400.00 0,00% R 10141000-36250 Misc Refund $50000 S2,08860 $42000 (S1,58860) 333.72% R 101-41000-38050 Cable TV Franchise Rebates $000 50.00 S000 S000 0,00% R 101-41000-39203 Transfer from other Funds S000 50.00 50.00 50.00 R 1014100 39200 rnterfund Operating Transfer 51,440 00 90.00 SO.DO 51 440.00 0.06% TOTAL GENERAL FUND REVENUES 51,676,540.00 4187,333.35 552 5&0.17 S1 4H9 556.135 11,17% R 101.49000-39204 Money_Market Transfer 5 51,741,021.92 $718,000.00 R 101-49000-39203 Transfers from Other Funds 53,965.40 53,965.40 F NN13 101 GENERAL FUND Expenditure Accounts 2021 Sud et 2021 YTD 2021 MTD 2021 Budget Bal % of Budget Administration & Finance S 387,272 00 $209,585.49 S 25,790 49 5177,686.51 54 12% City Council S 19,982.00 S13,39953 S - 56,582.47 67 06 % Elections S 1,03000 $1,47000 S - (5440.00) 142,72% Planning & Building $ 118,050.00 554,909.54 S 13,290.93 563,14046 4651% Assessor 5 21,600 00 S11,27665 5 2,776.65 $10,32335 52 21 % Police S 147,460 00 $309.36 S - S147,15064 0 21 % Fire Dept 5 262,778.00 596,924.50 S 15,963,22 5765,85350 36.889/6 Animal Control 5 2,00000 S93017 S - $1,069.83 46 51 % Public Works S 658,253 00 5238,779.52 S 43,731 53 S419,47348 36 27 % Parks & Recreation S 90,797.00 $41,373.91 S 6,242.03 $49,423.09 45.57% Community Center S 6B.500.00 $20,090.53 S 2,93887 548,40947 29,33% TOTAL GENERAL EXPENDITURES 3 1,777,722,00 S 589,049.20 S 110,733.72 S1 08a,671911 $8.76% Budgeted Transfers Between Accounts 5 280,000 00 S 280,000 00 S 280,000,00 S000 Transfers Between AccomLs 5 S 1.721.965.40 S 721 965,40 51-721-965.40 Total Transfers S 2.001,965 40 S 1-112.699.12 JS2,001,965.40 Page 1 of 2 Page 2 of 2 CITY OF SCANDIA 1 -Ll SCA N D IA Budget YTD Revenue S Expenses June 2021 FUND 225 EDP Revenue Accounts S 5,00000 S - S S5,00000 0 00 % Expenditure Accounts S 1,90000 S 1,97000 S 1,45000 ($7000) 103 68 % FUND 226 CABLE TV Revenue Accounts 5 16,500 00 S 9,730 86 S 1,95605 56,769.14 58 97 % Expenditure Accounts $ 10,500 00 S 2,04862 S - S8,45138 1951% FUND 313 2013 EQUIPMENT CeRT1FICATES Revenue Accounts 5 68,220 00 S - $68,22000 000% Expenditure Accounts 5 64,995 00 $ 63,135 00 S S1,86000 97 14 % FUND 317 2017 EQUIPMENT CERTIFICATES Revenue Accounts 3 35,909 00 5 - $35,909.00 0 00 % Expenditure Accounts 5 34,223 00 S 86400 S33,35900 2 52 % FUND 318 BLACKTOP PROJECT 2018 Revenue Accounts S 341,456 00 S S - S341,45600 0 00 % Expenditure Accounts $ 325,220 00 S 52,857 51 $ 5272,362.49 16 25 % FUND 401 CAPITAL IMPROVEMENTS Revenue Accoun is 5 300,50000 5 2DE.089.04 5 206.089.04 59441095 68.58% Expenditure Accounts Administration B Finance S 250,00000 5 7,87625 S - 5242,123.75 315% Fire Dept 5 75,000 00 S 141,873 24 S 105,784.20 (566,873.24) 189.16% Public Works 5 10,000 00 5 - S10,00000 0 00 % Community Center S 15,00000 S 3,69420 511,30580 2463% Capital Improvements 5 47,00000 S 163,11379 5 166,80799 ($116,11379) 34705% Operating Transfer $ 10,000 00 S 510,000.00 TOTAL CAPITAL IMPROVEMENTS S 407,000 00 S 31$,557 48 S_ 272.5q2 19 5 90,442.52 77 78i: FUND 404 PARK CAPITAL IMPROVEMENTS 2021 Bud et 2021 YTD 2021 MTD 2021 Budget Bet ii of Sud et Revenue Accounts $ 26,585 00 S 3,85700 S 85700 $22,72800 14 51 % Expenditure Accounts 5 42,025 00 S 1,75700 S - $40,26800 4 18 % FUND 406 EQUIPMENT REPLACEMENT Revenue Accounts 51 138,000 00 S - 5 - $138,000.00 0 00 % Expenditure Accounts 5 52,50000 S 11,22404 S - 541,275.96 21.38% FUND 408 LOCAL ROAD IMPROVEMENT FUND Revenue Accounts S 518,539 00 $ 80,000 00 S 80,000 00 S438,53900 1543% Expenditure Accounts 5 845,000 00 S 651,887 48 S 494,286 25 S193,11252 77 15% FUND 602 BIG MARINE SEWER Revenue Accounts S 98,945 00 S 35,797 33 $ 12,676,44 S63,14767 3618% Expenditure Accounts $ 167,005 00 S 29,D15 51 S 3,217.16 S 137,989 49 1737% FUND 612 UPTOWN SEWER Revenue Accounts S 23,000.00 S 3,271.02 S - $19,72898 14 22 % Expenditure Accounts 27,60700 S 3,112.54 S 9665 $24,49446 1127% TOTAL REVENUE ACCOUNTS 5 3,249,194.00 $ 2,267,100.52 $ 1,076,124.10 $ 2,723,565.40 69.77% TOTAL EXPENDITURE ACCOUNTS 5 3,755,697.00 $ 3,825,443.78 $ 1,884,341.37 $ 210,253.22 2255% Page 2 of 2