3. SWCSR General Ledger 06-29-20232:45 PM Sherburne -Wright County Cable Communications Commission
06/20/23 General Ledger
Accrual Basis As of May 31, 2023
Type Date Num Name Memo Split Amount
Wells Fargo Bank Minnesota, NA
Deposit 05/10/2023
Check 05/12/2023
Deposit 05/23/2023
Deposit 05/31/2023
Deposit 05/31/2023
Check 05/31/2023
Check 05/31/2023
Check 05/31/2023
Check 05/31/2023
Total Wells Fargo Bank Minnesota, NA
Accounts Receivable
Total Accounts Receivable
Undeposited Funds
Total Undeposited Funds
Accounts Payable
Equipment Storage
Total Equipment Storage
Accounts Payable - Other
Total Accounts Payable - Other
Total Accounts Payable
Payroll Liabilities
Total Payroll Liabilities
Opening Bal Equity
Total Opening Bal Equity
Retained Earnings
Total Retained Earnings
1502 Viking Drive Cable Fees HD
Total 1502 Viking Drive Cable Fees HD
3rd Quarter 2007 Franchise Fees
Total 3rd Quarter 2007 Franchise Fees
Campaign Income
Total Campaign Income
Contributions Income
Restricted
Total Restricted
Unrestricted
Total Unrestricted
Contributions Income - Other
Total Contributions Income - Other
Total Contributions Income
Franchise Fee
Total Franchise Fee
Franchise Fee Q4 2007
Total Franchise Fee Q4 2007
Franchise Fee Taxes
Franchise Fee Taxes 3rd Quarter
Total Franchise Fee Taxes 3rd Quarter
Franchise Fee Taxes Q1 2007
Total Franchise Fee Taxes Q1 2007
4821 Beritec, Ltd
4818 WH SECURITY
4819 City of Buffalo
4822 Leightronix, Inc.
4823 AV Solutions
Deposit
PEG and Fran...
4,344.28
-SPLIT-
-3,320.92
Deposit
PEG and Fran...
9,095.69
Deposit
-SPLIT-
192,524.64
Interest
Interest Income
21.41
150-1696-2719
-SPLIT-
-86.86
-SPLIT-
-1,040.88
-SPLIT-
-16,116.00
-SPLIT-
-9,514.92
175,906.44
Page 1
2:45 PM Sherburne -Wright County Cable Communications Commission
06/20/23 General Ledger
Accrual Basis As of May 31, 2023
Type Date Num Name Memo Split Amount
Franchise Fee Taxes Q3 2006
Total Franchise Fee Taxes Q3 2006
Franchise Fee Taxes - Other
Total Franchise Fee Taxes - Other
Total Franchise Fee Taxes
Franchise Fee Taxes and PEG Fee
Total Franchise Fee Taxes and PEG Fee
Franchise Fee, Connections, Big
Total Franchise Fee, Connections, Big
Franchise Fees
Total Franchise Fees
Grants
Total Grants
Legacies & Bequests
Total Legacies & Bequests
LMCIT Dividend
Total LMCIT Dividend
LMNCIT Dividend
Total LMNCIT Dividend
Membership Dues
Total Membership Dues
Miscellaneous Income
Total Miscellaneous Income
Other Income - Sale of Producti
Total Other Income - Sale of Producti
PEG and Franchise Fees - Local
Deposit 05/10/2023
1039841 Arvig
Q1 23 PEG & ...
Wells Fargo B...
-4,344.28
Deposit 05/23/2023
126989 City of Monticello
Deposit
Wells Fargo B...
-9,095.69
Deposit 05/31/2023
Charter Communica...
Deposit
Wells Fargo B...
-384.20
Deposit 05/31/2023
Charter Communica...
Deposit
Wells Fargo B...
-634.95
Deposit 05/31/2023
Charter Communica...
Deposit
Wells Fargo B...
-665.55
Deposit 05/31/2023
Charter Communica...
Deposit
Wells Fargo B...
-1,184.05
Deposit 05/31/2023
Charter Communica...
Deposit
Wells Fargo B...
-1,350.65
Deposit 05/31/2023
Charter Communica...
Deposit
Wells Fargo B...
-2,073.15
Deposit 05/31/2023
Charter Communica...
Deposit
Wells Fargo B...
-2,406.35
Deposit 05/31/2023
Charter Communica...
Deposit
Wells Fargo B...
-2,659.65
Deposit 05/31/2023
Charter Communica...
Deposit
Wells Fargo B...
-5,069.40
Deposit 05/31/2023
Charter Communica...
Deposit
Wells Fargo B...
-6,054.55
Deposit 05/31/2023
Charter Communica...
Deposit
Wells Fargo B...
-170,042.14
Total PEG and Franchise Fees - Local
-205,964.61
Program Fees
Total Program Fees
Reimbursed Expenses
Total Reimbursed Expenses
3rd Quarter 2007
Total 3rd Quarter 2007
Accounting Software
Total Accounting Software
Administrative
April
Total April
Page 2
2:45 PM Sherburne -Wright County Cable Communications Commission
06/20/23 General Ledger
Accrual Basis As of May 31, 2023
Type Date Num Name Memo Split Amount
December
Total December
February
Total February
January
Total January
June July August
Total June July August
March
Total March
May
Total May
October
Total October
September
Total September
Administrative - Other
Check 05/31/2023
Check 05/31/2023
Total Administrative - Other
Total Administrative
Amortization Expense
Total Amortization Expense
Automobile Expense
Total Automobile Expense
Bank Service Charges
Total Bank Service Charges
Bank Service Charges, January S
Total Bank Service Charges, January S
cable service
Check 05/31/2023
Check 05/31/2023
Total cable service
Cash Discounts
Total Cash Discounts
Check Printing
Total Check Printing
Conference Registration
Total Conference Registration
Contract Labor
All Cities
Check 05/12/2023
Total All Cities
Big Lake
Total Big Lake
Buffalo
Total Buffalo
4819 City of Buffalo March 2023 M... Wells Fargo B... 415.00
4819 City of Buffalo May 2023 Ma... Wells Fargo B... 415.00
4819 City of Buffalo March 2023 C... Wells Fargo B.
4819 City of Buffalo May 2023 Ch... Wells Fargo B.
830.00
830.00
105.44
105.44
210.88
4821 Beritec, Ltd All Cities: Reb... Wells Fargo B... 1,254.42
1,254.42
Page 3
2:45 PM Sherburne -Wright County Cable Communications Commission
06/20/23
General Ledger
Accrual Basis
As of May 31, 2023
Type Date
Num
Name Memo
Split
Channel 19
Total Channel 19
Cokato
Check 05/12/2023
4821
Beritec, Ltd Cokato: Troub...
Wells Fargo B...
Total Cokato
Dassel
Total Dassel
Delano
Total Delano
Elk River
Check 05/12/2023
4821
Beritec, Ltd Elk River: Re...
Wells Fargo B...
Total Elk River
Maple Lake
Total Maple Lake
Monticello
Check 05/12/2023
4821
Beritec, Ltd Monticello: So...
Wells Fargo B...
Total Monticello
Movie Setup Teardown
Total Movie Setup Teardown
Rockford
Check 05/12/2023
4821
Beritec, Ltd Rockford: Add...
Wells Fargo B...
Total Rockford
Sport Event Production/Shoot
Total Sport Event Production/Shoot
Trailer
Total Trailer
Watertown
Total Watertown
Contract Labor - Other
Total Contract Labor - Other
Total Contract Labor
Contributions
Total Contributions
Credit Memo
Total Credit Memo
Delivery Fee/Charges
Total Delivery Fee/Charges
Deposit/Interest Income/Service
Total Deposit/Interest Income/Service
Depreciation Expense
Total Depreciation Expense
Dues and Subscriptions
Total Dues and Subscriptions
Equipment Purchase
Big Lake
Total Big Lake
Amount
314.18
314.18
1,173.10
1,173.10
172.60
172.60
336.62
336.62
3,250.92
Page 4
2:45 PM Sherburne -Wright County Cable Communications Commission
06/20/23
General
Ledger
Accrual Basis
As of May 31, 2023
Type Date
Num
Name
Memo
Split
Buffalo
Total Buffalo
Cokato
Total Cokato
Dassel
Check 05/31/2023
4822
Leightronix, Inc.
Dassel: VieBit...
Wells Fargo B...
Total Dassel
Delano
Total Delano
Elk River
Check 05/12/2023
4821
Beritec, Ltd
Elk River: Parts
Wells Fargo B...
Check 05/31/2023
4823
AV Solutions
Elk River: Sa...
Wells Fargo B...
Total Elk River
Equipment All Cities
Check 05/12/2023
4821
Beritec, Ltd
All Cities: Parts
Wells Fargo B...
Check 05/31/2023
4823
AV Solutions
All Cities: Mis...
Wells Fargo B...
Total Equipment All Cities
Maple Lake
Check 05/31/2023
4822
Leightronix, Inc.
Maple Lake:...
Wells Fargo B...
Total Maple Lake
Monticello
Check 05/31/2023
4822
Leightronix, Inc.
Monticello: Vi...
Wells Fargo B...
Check 05/31/2023
4822
Leightronix, Inc.
Monticello: Vi...
Wells Fargo B...
Check 05/31/2023
4823
AV Solutions
Monticello: BI...
Wells Fargo B...
Total Monticello
parts and materials
Total parts and materials
playback
Total playback
Producer Equipment/Software
Total Producer Equipment/Software
Rockford
Check 05/12/2023
4821
Beritec, Ltd
Rockford: Parts
Wells Fargo B...
Check 05/31/2023
4822
Leightronix, Inc.
Rockford: Vie...
Wells Fargo B...
Total Rockford
Trailer Equipment
Total Trailer Equipment
Watertown
Check 05/31/2023
4822
Leightronix, Inc.
Watertown: Vi...
Wells Fargo B...
Check 05/31/2023
4822
Leightronix, Inc.
Watertown: Vi...
Wells Fargo B...
Total Watertown
Equipment Purchase - Other
Total Equipment Purchase - Other
Total Equipment Purchase
Equipment Rental
Total Equipment Rental
Equipment Sale, Truck
Total Equipment Sale, Truck
Amount
2,388.00
2,388.00
25.00
2,029.56
2,054.56
30.00
7,202.14
7,232.14
2,388.00
2,388.00
2,388.00
2,388.00
283.22
5,059.22
15.00
2,388.00
2,403.00
2,388.00
1,788.00
4,176.00
25, 700.92
Page 5
2:45 PM Sherburne -Wright County Cable Communications Commission
06/20/23 General Ledger
Accrual Basis As of May 31, 2023
Type Date Num Name Memo Split
Forever Stamps
Total Forever Stamps
Franchise Fee Return
Total Franchise Fee Return
Franchise Fee Return to Cities
Total Franchise Fee Return to Cities
Franchise Fee Taxes 4th Quarter
Total Franchise Fee Taxes 4th Quarter
Insurance
Disability Insurance
Total Disability Insurance
Liability Insurance
Total Liability Insurance
Insurance - Other
Total Insurance - Other
Total Insurance
Interest Expense
Finance Charge
Total Finance Charge
Loan Interest
Total Loan Interest
Mortgage
Total Mortgage
Interest Expense - Other
Total Interest Expense - Other
Total Interest Expense
Interest Income, January Statem
Total Interest Income, January Statem
Interest Income, May Statement
Total Interest Income, May Statement
Licenses and Permits
Total Licenses and Permits
Miscellaneous
Total Miscellaneous
Office Supplies
Total Office Supplies
Payroll Expenses
Total Payroll Expenses
Postage and Delivery
Total Postage and Delivery
Printing and Reproduction
Total Printing and Reproduction
Producer Expenses
Producer Reimbrusements
Total Producer Reimbrusements
Producer Wage and Health Insura
Total Producer Wage and Health Insura
Amount
Page 6
2:45 PM Sherburne -Wright County Cable Communications Commission
06/20/23 General Ledger
Accrual Basis As of May 31, 2023
Type Date Num Name Memo Split
Producer Expenses - Other
Total Producer Expenses - Other
Total Producer Expenses
Professional Fees
Accounting
Total Accounting
Consulting
Total Consulting
Legal Fees
Total Legal Fees
Professional Fees - Other
Total Professional Fees - Other
Total Professional Fees
Program Expense
Blank Tapes
Total Blank Tapes
Program Expense - Other
Total Program Expense - Other
Total Program Expense
Reconciliation Discrepancies
Total Reconciliation Discrepancies
Renewal reports
Total Renewal reports
Rent
Total Rent
Repairs
Building Repairs
Total Building Repairs
Computer Repairs
Total Computer Repairs
Equipment Repairs
Buffalo
Total Buffalo
Dassel
Total Dassel
Equipment Repairs - Other
Total Equipment Repairs - Other
Total Equipment Repairs
Repairs - Other
Total Repairs - Other
Total Repairs
Security
Check 05/31/2023
Total Security
Software and Hosted Server
Total Software and Hosted Server
4818 WH SECURITY 150-1696-2719 Wells Fargo B.
Amount
86.86
86.86
Page 7
2:45 PM Sherburne -Wright County Cable Communications Commission
06/20/23 General Ledger
Accrual Basis As of May 31, 2023
Type Date Num Name Memo Split
Supplies
Marketing
Total Marketing
Office
Total Office
Supplies - Other
Total Supplies - Other
Total Supplies
Telephone
Total Telephone
Trailer Tabs
Total Trailer Tabs
Training
Total Training
Travel & Ent
Entertainment
Total Entertainment
Meals
Total Meals
Travel
Total Travel
Travel & Ent - Other
Total Travel & Ent - Other
Total Travel & Ent
Utilities
Gas and Electric
Total Gas and Electric
Water
Total Water
Utilities - Other
Check 05/31/2023 4818 WH SECURITY
Total Utilities - Other
Total Utilities
Video Shoot - Sports
Total Video Shoot - Sports
Video Shoot Concert In Park
Total Video Shoot Concert In Park
Video Shoot Parade
Total Video Shoot Parade
void
Total void
Equipment Refund
Total Equipment Refund
Franchise Fee Taxes 2005
Total Franchise Fee Taxes 2005
150-1696-2719 Wells Fargo B...
Amount
0.00
0.00
0.00
Page 8
2:45 PM Sherburne -Wright County Cable Communications Commission
06/20/23 General Ledger
Accrual Basis As of May 31, 2023
Type Date Num Name Memo Split Amount
Interest Income
Deposit 05/31/2023
Total Interest Income
Other Income
Total Other Income
Other Income -Workers Comp Ref
Total Other Income - Workers Comp Ref
PEG Fees
Total PEG Fees
PEG Fees 3rd Quarter
Total PEG Fees 3rd Quarter
Pre 2006 Adj
Total Pre 2006 Adj
Refund of Overpayment During Tr
Total Refund of Overpayment During Tr
Reimbursed Extra Cable Services
Total Reimbursed Extra Cable Services
Workers Comp Dividend
Total Workers Comp Dividend
Other Expenses
Total Other Expenses
No accnt
Total no accnt
TOTAL
Interest Wells Fargo B... -21.41
-21.41
0.00
Page 9
2:45 PM Sherburne -Wright County Cable Communications Commission
06/20/23 General Ledger
Accrual Basis As of May 31, 2023
Balance
196,671.85
201,016.13
197,695.21
206,790.90
399, 315.54
399, 336.95
399,250.09
398,209.21
382,093.21
372,578.29
372,578.29
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
312.00
312.00
-227,531.07
-227,531.07
70,838.66
70,838.66
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Page 10
2:45 PM Sherburne -Wright County Cable Communications Commission
06/20/23 General Ledger
Accrual Basis As of May 31, 2023
Balance
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
-218,089.38
-222,433.66
-231,529.35
-231,913.55
-232,548.50
-233,214.05
-234,398.10
-235,748.75
-237,821.90
-240,228.25
-242,887.90
-247,957.30
-254,011.85
-424,053.99
-424,053.99
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
1,645.00
0.00
0.00
Page 11
2:45 PM Sherburne -Wright County Cable Communications Commission
06/20/23 General Ledger
Accrual Basis As of May 31, 2023
Balance
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
1,645.00
2,060.00
2,475.00
2,475.00
2,475.00
0.00
0.00
50.61
50.61
0.00
0.00
0.00
0.00
1,141.85
1,247.29
1,352.73
1,352.73
0.00
0.00
0.00
0.00
0.00
0.00
80,122.82
18,819.88
20,074.30
20,074.30
6,371.60
6,371.60
17,343.29
17,343.29
Page 12
2:45 PM Sherburne -Wright County Cable Communications Commission
06/20/23 General Ledger
Accrual Basis As of May 31, 2023
Balance
0.00
0.00
420.00
734.18
734.18
855.00
855.00
2,885.00
2,885.00
13,057.28
14,230.38
14,230.38
6,742.88
6,742.88
11,974.80
12,147.40
12,147.40
0.00
0.00
75.00
411.62
411.62
0.00
0.00
0.00
0.00
1,578.09
1,578.09
0.00
0.00
83,373.74
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
66,522.89
265.39
265.39
Page 13
2:45 PM Sherburne -Wright County Cable Communications Commission
06/20/23 General Ledger
Accrual Basis As of May 31, 2023
Balance
18,539.83
18,539.83
0.00
0.00
0.00
2,388.00
2,388.00
123.74
123.74
10,015.80
10,040.80
12,070.36
12,070.36
4,841.08
4,871.08
12,073.22
12,073.22
384.43
2,772.43
2,772.43
27,752.00
30,140.00
32,528.00
32,811.22
32,811.22
0.00
0.00
0.00
0.00
0.00
0.00
0.00
15.00
2,403.00
2,403.00
0.00
0.00
0.00
2,388.00
4,176.00
4,176.00
4,600.62
4,600.62
92,223.81
0.00
0.00
0.00
0.00
Page 14
2:45 PM Sherburne -Wright County Cable Communications Commission
06/20/23 General Ledger
Accrual Basis As of May 31, 2023
Balance
63.00
63.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
95.00
95.00
0.00
0.00
175.20
175.20
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Page 15
2:45 PM Sherburne -Wright County Cable Communications Commission
06/20/23 General Ledger
Accrual Basis As of May 31, 2023
Balance
0.00
0.00
0.00
1,359.75
0.00
0.00
0.00
0.00
1,359.75
1,359.75
0.00
0.00
1,359.75
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
9,640.00
9,640.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
219.29
306.15
306.15
16,847.60
16,847.60
Page 16
2:45 PM Sherburne -Wright County Cable Communications Commission
06/20/23 General Ledger
Accrual Basis As of May 31, 2023
Balance
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Page 17
2:45 PM Sherburne -Wright County Cable Communications Commission
06/20/23 General Ledger
Accrual Basis As of May 31, 2023
Balance
-85.07
-106.48
-106.48
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Page 18