The URL can be used to link to this page

3.0.A SWCSR 04-22-202111:42AM Sherburne -Wright County Cable Communications Commission 04/15/21 Reconciliation Detail Wells Fargo Bank Minnesota, NA, Period Ending 03/31/2021 Type Date Num Name Clr Amount Balance Beginning Balance 387,039.34 Cleared Transactions Checks and Payments -18 items Check 02/22/2021 4498 Beritec, Ltd X -17,183.10 -17,183.10 Check 02/22/2021 4502 BIG LAKE POLICE... X -8,500.00 -25,683.10 Check 02/22/2021 4496 OnCall Technical Se... X -3,030.00 -28,713.10 Check 02/22/2021 4500 Loberg Electric X -641.83 -29,354.93 Check 02/22/2021 4499 L & L Courier, LLC X -90.00 -29,444.93 Check 02/26/2021 4503 2plus2, LLC X -1,200.00 -30,644.93 General Journal 02/26/2021 Buffalo Storage, LLC X -1,081.00 -31,725.93 Check 03/08/2021 4505 City of Buffalo X -3,130.09 -34,856.02 Check 03/08/2021 4506 WRIGHT COUNTY ... X -723.50 -35,579.52 Check 03/26/2021 4517 AVI Systems X -64,614.80 -100,194.32 Check 03/26/2021 4514 AV Solutions X -29,081.76 -129,276.08 Check 03/26/2021 4510 AV Design X -13,507.09 -142,783.17 Check 03/26/2021 4513 Brentec,lnc X -11,664.61 -154,447.78 Check 03/26/2021 4511 Beritec, Ltd X -6,039.79 -160,487.57 Check 03/26/2021 4508 City of Buffalo X -5,131.17 -165,618.74 Check 03/26/2021 4518 Emhart's Auto Center X -4,297.38 -169,916.12 Check 03/26/2021 4515 City of Elk River X -747.00 -170,663.12 Check 03/26/2021 4520 Russell Security Re... X -16.00 -170,679.12 Total Checks and Payments -170,679.12 -170,679.12 Deposits and Credits - 6 items Check 02/26/2021 4504 Buffalo Storage, LLC X 0.00 0.00 Deposit 03/01/2021 X 213,052.02 213,052.02 Deposit 03/09/2021 X 5,118.84 218,170.86 Deposit 03/26/2021 X 500.00 218,670.86 General Journal 03/26/2021 R Buffalo Storage, LLC X 1,081.00 219,751.86 Deposit 03/31/2021 X 4.76 219,756.62 Total Deposits and Credits 219,756.62 219,756.62 Total Cleared Transactions 49,077.50 49,077.50 Cleared Balance 49,077.50 436,116.84 Uncleared Transactions Checks and Payments - 9 items Check 02/13/2018 4061 Leightronix, Inc. -21,357.46 -21,357.46 Check 02/13/2018 4062 Buffalo Storage, LLC -315.00 -21,672.46 Check 12/20/2019 4321 Charter Communica... -631.20 -22,303.66 Check 11/23/2020 4448 Brentec, Inc -2,132.59 -24,436.25 Check 03/26/2021 4509 2plus2, LLC -1,200.00 -25,636.25 Check 03/26/2021 4516 Wes Olson Electric -1,076.89 -26,713.14 Check 03/26/2021 4507 Buffalo Storage, LLC -581.00 -27,294.14 Check 03/26/2021 4512 Loberg Electric -309.16 -27,603.30 Check 03/26/2021 4519 VitalSigns -225.49 -27,828.79 Page 1 11:42AM Sherburne -Wright County Cable Communications Commission 04/15/21 Reconciliation Detail Wells Fargo Bank Minnesota, NA, Period Ending 03/31/2021 Type Date Num Name Clr Amount Balance Total Checks and Payments-27,828.79-27,828.79 Deposits and Credits -1 item Check 04/05/2019 4197 void 0.00 0.00 Total Deposits and Credits 0.00 0.00 Total Uncleared Transactions-27,828.79-27,828.79 Register Balance as of 03/31/2021 21,248.71 408,288.05 Ending Balance 21,248.71 408,288.05 Page 2 11:53AM Sherburne -Wright County Cable Communications Commission 04/15/21 Check Detail March 2021 Type Num Date Name Item Account Paid Amount Original Amount Check 4505 03/08/2021 City of Buffalo Wells Fargo Bank ... Payroll Expenses Payroll Expenses Payroll Expenses Payroll Expenses Payroll Expenses Telephone Telephone Administrative Administrative TOTAL Check 4506 03/08/2021 WRIGHT COUNTY ... Wells Fargo Bank ... Automobile Expense TOTAL Check 4507 03/26/2021 Buffalo Storage, LLC Wells Fargo Bank ... Rent TOTAL Check 4508 03/26/2021 City of Buffalo Wells Fargo Bank ... Payroll Expenses Administrative Telephone TOTAL Check 4509 03/26/2021 2plus2, LLC Wells Fargo Bank ... Rent TOTAL Check 4510 03/26/2021 AV Design Wells Fargo Bank ... All Cities Monticello -3,130.09 -2,044.00 2,044.00 -153.30 153.30 -126.73 126.73 -29.63 29.63 -5.20 5.20 -36.22 36.22 -723.50 723.50 723.50 723.50 723.50 581.00 581.00 581.00 581.00 581.00 -5,131.17 -4,709.94 4,709.94 -350.00 350.00 -71.23 71.23 -5,131.17 5,131.17 -13,507.09 -532.09 532.09 -3,881.25 3,881.25 Page 1 11:53AM Sherburne -Wright County Cable Communications Commission 04/15/21 Check Detail March 2021 Type Num Date Name Item Account Paid Amount Original Amount Rockford -300.00 300.00 Buffalo -1, 406.25 1,406.25 Elk River -2,437.50 2,437.50 Big Lake -1,575.00 1,575.00 Delano -262.50 262.50 Maple Lake -225.00 225.00 Watertown -150.00 150.00 All Cities -2,737.50 2,737.50 TOTAL -13,507.09 13,507.09 Check 4511 03/26/2021 Beritec, Ltd Wells Fargo Bank ... -6,039.79 Delano -458.36 458.36 Big Lake -656.59 656.59 Buffalo -458.36 458.36 Elk River -1,596.94 1,596.94 Rockford -224.30 224.30 Monticello -2,645.24 2,645.24 TOTAL -6,039.79 6,039.79 Check 4512 03/26/2021 Loberg Electric Wells Fargo Bank ... 309.16 Buffalo -309.16 309.16 TOTAL -309.16 309.16 Check 4513 03/26/2021 Brentec, Inc Wells Fargo Bank ... -11,664.61 Delano -249.41 249.41 Maple Lake -165.00 165.00 All Cities -371.71 371.71 Elk River -2,439.68 2,439.68 Monticello -4,388.66 4,388.66 Elk River -513.16 513.16 Monticello -296.05 296.05 Big Lake -972.62 972.62 Monticello -93.89 93.89 Elk River -192.50 192.50 Buffalo -1,981.93 1,981.93 TOTAL -11, 664.61 11, 664.61 Check 4514 03/26/2021 AV Solutions Wells Fargo Bank ...-29,081.76 Page 2 11:53AM Sherburne -Wright County Cable Communications Commission 04/15/21 Check Detail March 2021 Type Num Date Name Item Account Paid Amount Original Amount Delano Rockford Buffalo Elk River Equipment All Cities Watertown Big Lake TOTAL Check 4515 03/26/2021 Cityof Elk River Wells Fargo Bank ... Training TOTAL Check 4516 03/26/2021 Wes Olson Electric Wells Fargo Bank ... Monticello TOTAL Check 4517 03/26/2021 AVI Systems Wells Fargo Bank ... Rockford Monticello All Cities Elk River All Cities Elk River TOTAL Check 4518 03/26/2021 Ernharts Auto Cen... Wells Fargo Bank ... Repairs TOTAL Check 4519 03/26/2021 VitalSigns Wells Fargo Bank ... Producer Expenses TOTAL -5,822.55 5,822.55 -35.25 35.25 -2,730.66 2,730.66 -8,000.93 8,000.93 -64,614.80 -2,690.08 2,690.08 -17,051.09 17,051.09 -2,114.30 2,114.30 -225.49 225.49 Page 3 11:53AM Sherburne -Wright County Cable Communications Commission 04/15/21 Check Detail March 2021 Check TOTAL Type Num Date Name Item Account 4520 03/26/2021 Russell Security R... Wells Fargo Bank ... All Cities Paid Amount Original Amount -16.00 -16.00 16.00 -16.00 16.00 Page 4 11:56AM Sherburne -Wright County Cable Communications Commission 04/15/21 Expenses by Vendor Summary Accrual Basis March 2021 Mar 21 2plus2,LLC 1,200.00 Arvig -5,118.84 AV Design 13,507.09 AV Solutions 29,081.76 AVI Systems 64,614.80 Beritec, Ltd 6,039.79 Brentec,lnc 11,664.61 Buffalo Storage, LLC -1,000.00 City of Buffalo 8,261.26 Ernhart's Auto Center 4,297.38 Loberg Electric 309.16 Russell Security Resources, Inc 16.00 VitalSigns 225.49 Wes Olson Electric 1,076.89 WRIGHT COUNTY AUDITOR 723.50 TOTAL 134,898.89 Page 1 11:55AM Sherburne -Wright County Cable Communications Commission 04/15/21 Statement of Cash Flows March 2021 Mar 21 OPERATING ACTIVITIES Net Income 77,410.89 Net cash provided by Operating Activities 77,410.89 Net cash increase for period 77,410.89 Cash at beginning of period 330,877.16 Cash at end of period 408,288.05 Page 1