Loading...
3.a. SWCSR 02-04-2016 9:46 AM Sherburne-Wright County Cable Communications Commission 02/01/16 Balance Sheet Detail Accrual Basis As of January 31,2016 Type Date Num Name Memo CIr Split Amount Balance ASSETS 532,551.44 Current Assets 532,551.44 Checking/Savings 532,551.44 Wells Fargo Bank Minnesota,NA 532,551.44 Check 12/01/2015 3727 City of Buffalo Case X Buffalo -59.90 532,491.54 Check 12/01/2015 3728 City of Rockford Return Of Franchise Fees X Franchise Fee Return to Cities -10,344.87 522,146.67 Check 12/01/2015 3729 City of Watertown Return of Franchise Fees X Franchise Fee Return to Cities -10,448.07 511,698.60 Check 12/01/2015 3730 City of Monticello Franchise Fee Return X Franchise Fee Return to Cities -18,149.37 493,549.23 Check 12/01/2015 3731 City of Big Lake Franchise Fee Return X void 0.00 493,549.23 Check 12/01/2015 3732 City of Big Lake Franchise Fee Return X Franchise Fee Return to Cities -22,198.26 471,350.97 Check 12/01/2015 3733 City of Cokato Return of Franchise Fees X Franchise Fee Return to Cities -5,882.25 465,468.72 Check 12/01/2015 3734 City of Dassel Return of Franchise Fees X Franchise Fee Return to Cities -2,657.62 462,811.10 Check 12/01/2015 3735 City of Delano Return of Franchise Fees Franchise Fee Return to Cities -15,786.79 447,024.31 Check 12/01/2015 3736 City of Elk River Franchise Fee Return X Franchise Fee Return to Cities -51,636.48 395,387.83 Check 12/01/2015 3737 City of Maple Lake Franchise Fee Return X Franchise Fee Return to Cities -5,129.66 390,258.17 Check 12/01/2015 3738 Buffalo Storage,LLC G709,H29,101,104,Q1 X Rent -390.00 389,868.17 Check 12/01/2015 3739 Leightronix,Inc. 0924 X Equipment All Cities -4,714.06 385,154.11 Check 12/02/2015 3740 City of Buffalo X Producer Expenses -69.90 385,084.21 Deposit 12/07/2015 City of Maple Lake/Big... Deposit X Franchise Fee 290.25 385,374.46 Check 12/08/2015 3741 Kennedy and Graven,... 129073 X Legal Fees -80.00 385,294.46 Check 12/08/2015 3742 Niemeyers,Inc. 50247 X Trailer Equipment -4,441.23 380,853.23 Check 12/08/2015 3743 Charter Communications 8352305220097893;835... X -SPLIT- -1,921.44 378,931.79 Check 12/10/2015 3744 City of Buffalo 9096 X Producer Wage and Health Insura -2,938.18 375,993.61 Check 12/22/2015 3745 AV Design 321,319,318,17,16,15,14,... X -SPLIT- -13,172.35 362,821.26 Deposit 12/24/2015 City of Monticello Deposit X Franchise Fee 709.00 363,530.26 Deposit 12/24/2015 City of Maple Lake Deposit X Franchise Fee 312.87 363,843.13 Check 12/28/2015 3746 City of Buffalo 9134 X Producer Wage and Health Insura -3,146.65 360,696.48 Check 12/28/2015 3747 AV Solutions 13277,274,275,223,276 -SPLIT- -16,045.14 344,651.34 Check 12/28/2015 3748 L&L Courier,LLC 19993,011,042 Delivery Fee/Charges -345.00 344,306.34 Check 12/28/2015 3749 Brentec,Inc 068,063,076,067,075,077... X -SPLIT- -5,286.31 339,020.03 Check 12/28/2015 3750 Beritec,Ltd 2127,28,22,29,30,31,26 X -SPLIT- -5,308.57 333,711.46 Check 12/28/2015 3751 Electronic Center 599,316,317,327,603,666... Equipment All Cities -2,990.22 330,721.24 Check 12/28/2015 3752 Kennedy and Graven,... 129403 X Legal Fees -794.60 329,926.64 Check 12/29/2015 3753 Buffalo Storage,LLC G709,H29,103,104,Q1 X Rent -390.00 329,536.64 Deposit 12/31/2015 Wells Fargo Bank Deposit X Interest Income 3.09 329,539.73 Check 01/12/2016 3754 ipHouse 998242 Software and Hosted Server -329.00 329,210.73 Check 01/12/2016 3755 DVS Renewal YAX2653 Licenses and Permits -97.00 329,113.73 Check 01/15/2016 3756 DVS Renewal 6156,5974 -SPLIT- -42.00 329,071.73 Check 01/21/2016 3757 Niemeyers,Inc. 40788 Trailer Equipment -3,544.44 325,527.29 Check 01/21/2016 3758 Charter Communications 5060272184,5070101753 -SPLIT- -2,166.48 323,360.81 Check 01/22/2016 3759 City of Buffalo 9204 Producer Wage and Health Insura -3,070.99 320,289.82 Check 01/25/2016 3760 Buffalo Storage,LLC G709,H29,103,104,Q1 Rent -390.00 319,899.82 Total Wells Fargo Bank Minnesota,NA -212,651.62 319,899.82 Total Checking/Savings -212,651.62 319,899.82 Accounts Receivable 0.00 Accounts Receivable 0.00 Total Accounts Receivable 0.00 Total Accounts Receivable 0.00 Other Current Assets 0.00 Undeposited Funds 0.00 Total Undeposited Funds 0.00 Total Other Current Assets 0.00 Total Current Assets -212,651.62 319,899.82 Fixed Assets 0.00 Total Fixed Assets 0.00 Other Assets 0.00 Total Other Assets 0.00 TOTAL ASSETS -212,651.62 319,899.82 LIABILITIES&EQUITY 532,551.44 Liabilities -312.00 Current Liabilities -312.00 Accounts Payable 0.00 Accounts Payable 0.00 Equipment Storage 0.00 Total Equipment Storage 0.00 Accounts Payable-Other 0.00 Total Accounts Payable-Other 0.00 Total Accounts Payable 0.00 Total Accounts Payable 0.00 Credit Cards 0.00 Total Credit Cards 0.00 Page 1 9:46 AM Sherburne-Wright County Cable Communications Commission 02/01/16 Balance Sheet Detail Accrual Basis As of January 31,2016 Type Date Num Name Memo CIr Split Amount Balance Other Current Liabilities -312.00 Payroll Liabilities -312.00 Total Payroll Liabilities -312.00 Total Other Current Liabilities -312.00 Total Current Liabilities -312.00 Long Term Liabilities 0.00 Total Long Term Liabilities 0.00 Total Liabilities -312.00 Equity 532,863.44 Opening Bal Equity 227,531.07 Total Opening Bal Equity 227,531.07 Retained Earnings 305,332.37 Closing Entry 12/31/2015 -203,011.71 102,320.66 Total Retained Earnings -203,011.71 102,320.66 Net Income 0.00 Total Net Income -9,639.91 -9,639.91 Total Equity -212,651.62 320,211.82 TOTAL LIABILITIES&EQUITY -212,651.62 319,899.82 Page 2 9:49 AM Sherburne-Wright County Cable Communications Commission 02/01/16 Check Detail December 2015 through January 2016 Type Num Date Name Item Account Paid Amount Original Amount Check 3727 12/01/2015 City of Buffalo Wells Fargo Bank Minnesota,NA -59.90 Buffalo -59.90 59.90 TOTAL -59.90 59.90 Check 3728 12/01/2015 City of Rockford Wells Fargo Bank Minnesota,NA -10,344.87 Franchise Fee Return to Cities -10,344.87 10,344.87 TOTAL -10,344.87 10,344.87 Check 3729 12/01/2015 City of Watertown Wells Fargo Bank Minnesota,NA -10,448.07 Franchise Fee Return to Cities -10,448.07 10,448.07 TOTAL -10,448.07 10,448.07 Check 3730 12/01/2015 City of Monticello Wells Fargo Bank Minnesota,NA -18,149.37 Franchise Fee Return to Cities -18,149.37 18,149.37 TOTAL -18,149.37 18,149.37 Check 3731 12/01/2015 City of Big Lake Wells Fargo Bank Minnesota,NA 0.00 TOTAL 0.00 0.00 Check 3732 12/01/2015 City of Big Lake Wells Fargo Bank Minnesota,NA -22,198.26 Franchise Fee Return to Cities -22,198.26 22,198.26 TOTAL -22,198.26 22,198.26 Check 3733 12/01/2015 City of Cokato Wells Fargo Bank Minnesota,NA -5,882.25 Franchise Fee Return to Cities -5,882.25 5,882.25 TOTAL -5,882.25 5,882.25 Check 3734 12/01/2015 City of Dassel Wells Fargo Bank Minnesota,NA -2,657.62 Franchise Fee Return to Cities -2,657.62 2,657.62 TOTAL -2,657.62 2,657.62 Check 3735 12/01/2015 City of Delano Wells Fargo Bank Minnesota,NA -15,786.79 Franchise Fee Return to Cities -15,786.79 15,786.79 TOTAL -15,786.79 15,786.79 Check 3736 12/01/2015 City of Elk River Wells Fargo Bank Minnesota,NA -51,636.48 Franchise Fee Return to Cities -51,636.48 51,636.48 TOTAL -51,636.48 51,636.48 Check 3737 12/01/2015 City of Maple Lake Wells Fargo Bank Minnesota,NA -5,129.66 Franchise Fee Return to Cities -5,129.66 5,129.66 TOTAL -5,129.66 5,129.66 Check 3738 12/01/2015 Buffalo Storage,L... Wells Fargo Bank Minnesota,NA -390.00 Rent -390.00 390.00 TOTAL -390.00 390.00 Page 1 • 9:49 AM Sherburne-Wright County Cable Communications Commission 02/01/16 Check Detail December 2015 through January 2016 Type Num Date Name Item Account Paid Amount Original Amount Check 3739 12/01/2015 Leightronix,Inc. Wells Fargo Bank Minnesota,NA -4,714.06 Equipment All Cities -4,714.06 4,714.06 TOTAL -4,714.06 4,714.06 Check 3740 12/02/2015 City of Buffalo Wells Fargo Bank Minnesota,NA -69.90 Producer Expenses -69.90 69.90 TOTAL -69.90 69.90 Check 3741 12/08/2015 Kennedy and Gray... Wells Fargo Bank Minnesota,NA -80.00 Legal Fees -80.00 80.00 TOTAL -80.00 80.00 Check 3742 12/08/2015 Niemeyers,Inc. Wells Fargo Bank Minnesota,NA -4,441.23 Trailer Equipment -4,441.23 4,441.23 TOTAL -4,441.23 4,441.23 Check 3743 12/08/2015 Charter Communi... Wells Fargo Bank Minnesota,NA -1,921.44 cable service -918.96 918.96 cable service -1,002.48 1,002.48 TOTAL -1,921.44 1,921.44 Check 3744 12/10/2015 City of Buffalo Wells Fargo Bank Minnesota,NA -2,938.18 Producer Wage and Health lnsura -2,938.18 2,938.18 TOTAL -2,938.18 2,938.18 Check 3745 12/22/2015 AV Design Wells Fargo Bank Minnesota,NA -13,172.35 Postage and Delivery -73.60 73.60 Rockford -900.00 900.00 Elk River -300.00 300.00 Big Lake -187.50 187.50 Delano -1,961.25 1,961.25 Buffalo -2,943.75 2,943.75 Maple Lake -562.50 562.50 Dassel -1,087.50 1,087.50 Monticello -1,650.00 1,650.00 All Cities -3,506.25 3,506.25 TOTAL -13,172.35 13,172.35 Check 3746 12/28/2015 City of Buffalo Wells Fargo Bank Minnesota,NA -3,146.65 Producer Wage and Health Insura -3,146.65 3,146.65 TOTAL -3,146.65 3,146.65 Check 3747 12/28/2015 AV Solutions Wells Fargo Bank Minnesota,NA -16,045.14 Delano -2,349.11 2,349.11 Buffalo -1,830.77 1,830.77 Monticello -2,158.88 2,158.88 Trailer Equipment -5,443.14 5,443.14 Equipment All Cities -4,263.24 4,263.24 TOTAL -16,045.14 16,045.14 Page 2 9:49 AM Sherburne-Wright County Cable Communications Commission 02/01/16 Check Detail December 2015 through January 2016 Type Num Date Name Item Account Paid Amount Original Amount Check 3748 12/28/2015 L&L Courier,LLC Wells Fargo Bank Minnesota,NA -345.00 Delivery Fee/Charges -345.00 345.00 TOTAL -345.00 345.00 Check 3749 12/28/2015 Brentec,Inc Wells Fargo Bank Minnesota,NA -5,286.31 Buffalo -940.43 940.43 Buffalo -1,454.26 1,454.26 Rockford -315.16 315.16 Delano -558.00 558.00 Elk River -116.51 116.51 Trailer -280.94 280.94 Watertown -157.30 157.30 Monticello -1,343.14 1,343.14 Big Lake -120.57 120.57 TOTAL -5,286.31 5,286.31 Check 3750 12/28/2015 Beritec,Ltd Wells Fargo Bank Minnesota,NA -5,308.57 Buffalo -719.03 719.03 Delano -698.72 698.72 Monticello -1,662.50 1,662.50 Watertown -608.10 608.10 Cokato -436.96 436.96 Big Lake -233.44 233.44 Buffalo -949.82 949.82 TOTAL -5,308.57 5,308.57 Check 3751 12/28/2015 Electronic Center Wells Fargo Bank Minnesota,NA -2,990.22 Equipment All Cities -2,990.22 2,990.22 TOTAL -2,990.22 2,990.22 Check 3752 12/28/2015 Kennedy and Gray... Wells Fargo Bank Minnesota,NA -794.60 Legal Fees -794.60 794.60 TOTAL -794.60 794.60 Check 3753 12/29/2015 Buffalo Storage,L... Wells Fargo Bank Minnesota,NA -390.00 Rent -390.00 390.00 TOTAL -390.00 390.00 Check 3754 01/12/2016 ipHouse Wells Fargo Bank Minnesota,NA -329.00 Software and Hosted Server -329.00 329.00 TOTAL -329.00 329.00 Check 3755 01/12/2016 DVS Renewal Wells Fargo Bank Minnesota,NA -97.00 Licenses and Permits -97.00 97.00 TOTAL -97.00 97.00 Check 3756 01/15/2016 DVS Renewal Wells Fargo Bank Minnesota,NA -42.00 Licenses and Permits -21.00 21.00 Licenses and Permits -21.00 21.00 TOTAL -42.00 42.00 Page 3 9:49 AM Sherburne-Wright County Cable Communications Commission 02/01/16 Check Detail December 2015 through January 2016 Type Num Date Name Item Account Paid Amount Original Amount Check 3757 01/21/2016 Niemeyers,Inc. Wells Fargo Bank Minnesota,NA -3,544.44 Trailer Equipment -3,544.44 3,544.44 TOTAL -3,544.44 3,544.44 Check 3758 01/21/2016 Charter Communi... Wells Fargo Bank Minnesota,NA -2,166.48 cable service -1,164.36 1,164.36 cable service -1,002.12 1,002.12 TOTAL -2,166.48 2,166.48 Check 3759 01/22/2016 City of Buffalo Wells Fargo Bank Minnesota,NA -3,070.99 Producer Wage and Health Insura -3,070.99 3,070.99 TOTAL -3,070.99 3,070.99 Check 3760 01/25/2016 Buffalo Storage,L... Wells Fargo Bank Minnesota,NA -390.00 Rent -390.00 390.00 TOTAL -390.00 390.00 Page 4 9:50 AM Sherburne-Wright County Cable Communications Commission 02/01/16 Statement of Cash Flows December 2015 through January 2016 Dec'15-Jan 16 OPERATING ACTIVITIES Net Income -212,651.62 Net cash provided by Operating Activities -212,651.62 Net cash increase for period -212,651.62 Cash at beginning of period 532,551.44 Cash at end of period 319,899.82 Page 1 M 9:53 AM Sherburne-Wright County Cable Communications Commission 02/01/16 Transaction List by Vendor December 2015 through January 2016 Type Date Num Memo Account Cir Split Amount AV Design Check 12/22/2015 3745 321,319,318,17,16,15,14,13,... Wells Fargo Bank... X -SPLIT- -13,172.35 AV Solutions Check 12/28/2015 3747 13277,274,275,223,276 Wells Fargo Bank... -SPLIT- -16,045.14 Beritec,Ltd Check 12/28/2015 3750 2127,28,22,29,30,31,26 Wells Fargo Bank... X -SPLIT- -5,308.57 Brentec,Inc Check 12/28/2015 3749 068,063,076,067,075,077,07... Wells Fargo Bank... X -SPLIT- -5,286.31 Buffalo Storage,LLC Check 12/01/2015 3738 G709,H29,101,104,Q1 Wells Fargo Bank... X Rent -390.00 Check 12/29/2015 3753 G709,H29,103,104,Q1 Wells Fargo Bank... X Rent -390.00 Check 01/25/2016 3760 G709,H29,103,104,Q1 Wells Fargo Bank... Rent -390.00 City of Big Lake Check 12/01/2015 3731 Franchise Fee Return Wells Fargo Bank... X void 0.00 Check 12/01/2015 3732 Franchise Fee Return Wells Fargo Bank... X Franchise Fee Return to Cities -22,198.26 City of Buffalo Check 12/01/2015 3727 Case Wells Fargo Bank... X Buffalo -59.90 Check 12/02/2015 3740 Wells Fargo Bank... X Producer Expenses -69.90 Check 12/10/2015 3744 9096 Wells Fargo Bank... X Producer Wage and Health Insura -2,938.18 Check 12/28/2015 3746 9134 Wells Fargo Bank... X Producer Wage and Health Insura -3,146.65 Check 01/22/2016 3759 9204 Wells Fargo Bank... Producer Wage and Health Insura -3,070.99 City of Cokato Check 12/01/2015 3733 Return of Franchise Fees Wells Fargo Bank... X Franchise Fee Return to Cities -5,882.25 City of Dassel Check 12/01/2015 3734 Return of Franchise Fees Wells Fargo Bank... X Franchise Fee Return to Cities -2,657.62 City of Delano Check 12/01/2015 3735 Return of Franchise Fees Wells Fargo Bank... Franchise Fee Return to Cities -15,786.79 City of Maple Lake Check 12/01/2015 3737 Franchise Fee Return Wells Fargo Bank... X Franchise Fee Return to Cities -5,129.66 Deposit 12/24/2015 Deposit Wells Fargo Bank... X Franchise Fee 312.87 City of Rockford Check 12/01/2015 3728 Return Of Franchise Fees Wells Fargo Bank... X Franchise Fee Return to Cities -10,344.87 DVS Renewal Check 01/12/2016 3755 YAX2653 Wells Fargo Bank... Licenses and Permits -97.00 Check 01/15/2016 3756 6156,5974 Wells Fargo Bank... -SPLIT- -42.00 Electronic Center Check 12/28/2015 3751 599,316,317,327,603,666,62... Wells Fargo Bank... Equipment All Cities -2,990.22 ipHouse Check 01/12/2016 3754 998242 Wells Fargo Bank... Software and Hosted Server -329.00 Kennedy and Graven,Chartered Check 12/08/2015 3741 129073 Wells Fargo Bank... X Legal Fees -80.00 Check 12/28/2015 3752 129403 Wells Fargo Bank... X Legal Fees -794.60 L&L Courier,LLC Check 12/28/2015 3748 19993,011,042 Wells Fargo Bank... Delivery Fee/Charges -345.00 Leightronix,Inc. Check 12/01/2015 3739 0924 Wells Fargo Bank... X Equipment All Cities -4,714.06 Niemeyers,Inc. Check 12/08/2015 3742 50247 Wells Fargo Bank... X Trailer Equipment -4,441.23 Check 01/21/2016 3757 40788 Wells Fargo Bank... Trailer Equipment -3,544.44 Wells Fargo Bank Deposit 12/31/2015 Deposit Wells Fargo Bank... X Interest Income 3.09 Page 1