--- ## author: Carman, Pamela date: D:20260602153517-05'00' --- ## Waconia ISD #110 ## Bank Reconciliation 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 ## ABCDEFGHI ## Waconia Public Schools ## April Bank Reconciliation ## Beg. BalanceEnd. Balance 3/31/2026ReceiptsDisbursementsJournal Entry4/30/2026 Security #9081661,588,954.116,013,633.805,537,492.502,065,095.41 ## Hometown Bank-ACH Account250,424.66615,514.65615,528.35250,410.96 ## Hometown Bank-IMMA Acct-Sweep412,331.15228,062.93335,465.42304,928.66 ## Inv - PMA18,195,866.937,108,958.455,335,000.0019,969,825.38 ## OPEB Bonds574,009.221,614.4220.83575,602.81 ## OPEB Equity596,778.9730,573.52248.66627,103.83 2025A Bonds2,136,096.565,861.56366,513.321,775,444.80 ## US Bank COP396.111.100.00397.21 ## Subtotal23,754,857.7114,004,220.4312,190,269.080.0025,568,809.06 ## Transfers between A/Cs29,144.66(6,664,556.85)(6,640,388.19)4,976.00ICS Sweep ## Outstand Checks - Prior Months0.000.00 ## - Finance Skyward(502,142.62)(502,142.62)0.00 ## Outstand Checks - Current Month0.001,001,120.35(1,001,120.35) 0.000.00 ## Net Payroll Imported0.00(1,890,541.76)(1,890,541.76)0.00 ## Adjustments ## AprDental Ins-admin fees & Claim Withdraws0.00(32,478.07)(32,478.07)0.00 ## AprFlex Med/Dep Care Entries0.00(12,508.98)(12,508.98)0.00 ## AprNSF Check0.00(75.00)(75.00)0.00 ## AprMN Paid Leave Rounding Error0.000.140.140.00 ## MarCredit Card Deposit in Transit30.00(30.00)0.00Clears In April ## JulDistrict Petty Cash100.00100.00 BalAdjusted Cash Balance23,281,989.75 7,339,633.58 4,113,254.95 (1,935,603.67) 24,572,764.71 ## RepPer SKYWARD Reports23,281,989.757,339,633.58 4,113,254.95 (1,935,603.67)24,572,764.71 ## Difference0.000.000.000.000.00 ## Waconia ISD #110 ## Bank Reconciliation 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 ## ABCD ## Transfers ToTransfers From ## Security Bank400,000.00 2,100,000.00 235,000.00 3,000,000.00 ## Bond Disbursement ## OPEB EQUITY ## OPEB-Rounding 2025 Bonds131,557.55 234,955.77 ## Hometown Bank/Sweep4,736.42Transfer to reduce Sweep ## Hometown Bank/Sweep227,578.11 ## Hometown Bank335,465.42203,409.45 ## Deposit in Transit- ## Clears in Feb ## Hometown Bank400,000.00 ## Wire Transfer to ## Security Bank ## Hometown Sweep330,729.00Transfer from Sweep to Hometown for Security Bank 2019 Lease (Tennis Court) ## 2024 BONDS ## OPEB Equity ## OPEB ## PM-A Operating131,557.552,100,000.00 234,955.77235,000.00 3,000,000.00 ## Refunding Bonds ## 2017 COPS-US Bank ## PMA ## KleinBank General to Activities ## Old National ## Mid Country ## LTFM Bond ## Facility Bond to Debt Service ## Total Transfers6,664,556.856,640,388.19 24,168.66