HomeMy WebLinkAboutNovemberWATERLOO LEISURE SERVICES
SALES TAX REPORT
NOVEMBER
2023
ACTIVITY 4120 - GOLF COURSES
1398 SALES TAX
GOLF REVENUE 7% TAX COLLECTED
WARREN MEMORIAL 6,784.58 474.92
GATES 4,163.79 291.47
SOUTH HILLS 8,552.10 598.65
OFFICE 425.23 29.77
19,925.70 1,394.80
ACTIVITY 4125 - GOLF COURSE IMPROVEMENTS
1398 SALES TAX
GOLF REVENUE 7% TAX COLLECTED
WARREN MEMORIAL 47.20 3.30
GATES 23.13 1.62
SOUTH HILLS 75.00 5.25
OFFICE 4.67 0.33
150.00 10.50
12-8-23
WATERLOO LEISURE SERVICES
SALES TAX REPORT
NOVEMBER
2023
ACTIVITY 4120 - GOLF COURSES
1398 SALES TAX
GOLF REVENUE 7% TAX COLLECTED
WARREN MEMORIAL 6,784.58 474.92
GATES 4,163.79 291.47
SOUTH HILLS 8,552.10 598.65
OFFICE 425.23 29.77
19,925.70 1,394.80
ACTIVITY 4125 - GOLF COURSE IMPROVEMENTS
1398 SALES TAX
GOLF REVENUE 7% TAX COLLECTED
WARREN MEMORIAL 47.20 3.30
GATES 23.13 1.62
SOUTH HILLS 75.00 5.25
OFFICE 4.67 0.33
150.00 10.50
12-8-23
WATERLOO LEISURE SERVICES
SALES TAX REPORT
NOVEMBER
2023
ACTIVITY 4120 - GOLF COURSES
1398 SALES TAX
GOLF REVENUE 7% TAX COLLECTED
WARREN MEMORIAL 6,784.58 474.92
GATES 4,163.79 291.47
SOUTH HILLS 8,552.10 598.65
OFFICE 425.23 29.77
19,925.70 1,394.80
ACTIVITY 4125 - GOLF COURSE IMPROVEMENTS
1398 SALES TAX
GOLF REVENUE 7% TAX COLLECTED
WARREN MEMORIAL 47.20 3.30
GATES 23.13 1.62
SOUTH HILLS 75.00 5.25
OFFICE 4.67 0.33
150.00 10.50
12-8-23
12/12/2023
YOUNG ARENA
SALES TAX
010-37-4500-1398
Gross Taxable Sales November 2023 29,928.00
Net Taxable Sales November 2023 27,970.09
Total Tax November 2023 1,957.91
To: Ryan Stuber
City Clerks Office
Waterloo City Hall
From: Madonna Welsh
Leisure Services
RYAN STUBER
From: Holly Sackett
Sent: Friday, December 1, 2023 9:43 AM
To: RYAN STUBER
Subject: Billed Sales Tax November 2023
Good Morning,
Storm water- $ 4,221.65
Garbage- $ 6.20
Sewer- $ 5,247.98
Thanks!
r' 68i# Sadutx
Systems Billing Administrator
Waterloo Water Works
325 Sycamore St
Waterloo, IA 50703
319-232-6280
1
WATERLOO LEISURE SERVICES
SALES TAX REPORT
NOVEMBER
2023
ACTIVITY 4120 - GOLF COURSES
1398 SALES TAX
GOLF REVENUE 7% TAX COLLECTED
WARREN MEMORIAL 6,784.58 474.92
GATES 4,163.79 291.47
f S y.j.W1:1FCLS 8,552.10 598.65
OFFICE 425.23 29.77
19,925.70 1,394.80
ACTIVITY 4125 - GOLF COURSE IMPROVEMENTS
1398 SALES TAX
GOLF REVENUE 7% TAX COLLECTED
WARREN MEMORIAL 47.20 3.30
GATES 23.13 1.62
SOUTH HILLS 75.00 5.25
OFFICE 4.67 0.33
150.00 10.50
12-8-23
SPORTS SALES TAX
010-37-4200
Nov-23
USSSA BB/SB (4200-3831)
Elks/Kiwanis/Katoski Golf (4200-3831)
Diamond Rentals (4200-3831)
Adult BB/VB (4200-3897)
To: Ryan Stuber
City Clerks Office
Waterloo City Hall
From: Courtney Jackson
Leisure Services
NET SALES
SALES TAX
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
304.95
285.00
19.95
GROSS SALES TOTAL 304.95
NET SALES TOTAL 285.00
SALES TAX TOTAL 19.95
SPORTSPLEX SALES TAX
010-37-4180
Nov-23
Facility Rentals (4180-3623)
Daily Admissions (4180-3832)
Membership Fees (4180-3835)
To: Ryan Stuber
City Clerks Office
Waterloo City Hall
GROSS SALES NET SALES SALES TAX
11,811.49
8,004.22
GROSS SALES TOTAL 126,748.03
NET SALES TOTAL 118,456.10
SALES TAX TOTAL 8,291.93
From: Courtney Jackson
Leisure Services
11,038.78
7,480.58
99,936.74
772.71
523.64
6,995.57
TAX REPORT FOR November
WASTE MANAGEMENT SERVICES
Billing Dated 11/20/2023
October 2023 Usage
NON-TAXABLE ACTIVITY
ACCT. #
COMPANY
NET BILLED
TOTAL BILLED
5452
BLACK HAWK CARE FACILITY
n/a
-
5453
BLACK HAWK COUNTY SOLID WASTE
6,415.37
n/a
6,415.37
5641
BLACK HAWK COUNTY LANDFILL PRET
177.60
n/a
177.60
14061
WATERLOO PROCESSING LLC
1,810.10
1,810.10
5644
TYSON FOODS PRET
1,900.30
n/a
1,900.30
7518
CONAGRA PRET
1,117.80
n/a
1,117.80
13109
CONAGRA
6,624.59
n/a
6,624.59
6602
J.D. ENGINE WORKS
n/a
-
5640
ARAMARK UNIFORM SERVICES
n/a
-
5643
HYDRITE CHEMICAL CO. PRET
n/a
-
6464
DARLING INTERNATIONAL
n/a
-
5646
J.D. WESTFIELD
n/a
-
5645
J.D. TRACTOR WORKS
n/a
-
12488
PLANERGY
n/a
-
14453
VETS'S TRUCK WASH
n/a
-
10943
CANADIAN NATIONAL GROUNDWATER
n/a
-
10521
CANADIAN NATIONAL RAILWAY
n/a
-
22509
City of Evansdale
n/a
-
22085
COOLEY PUMPING
n/a
-
13874
J.D. PEC
n/a
12935
IOWA NORTHERN RAILWAY
n/a
-
Non-taxable
18,045.76
TAXABLE ACTIVITY
ACCT#
COMPANY
NET BILLED
TAXED APPLIED
TOTAL BILLED
5451
ARAMARK
8,820.33
617.42
9,437.75
14060
WATERLOO PROCESSING LLC
48,529.50
3,397.07
51,926.57
5456
TYSON FOODS
305,595.57
21,391.69
326,987.26
5457
JOHN DEERE - DONALD STREET
10,807.09
756.50
11,563.59
5458
JOHN DEERE - ENGINE WORKS
1,869.80
130.89
2,000.69
5452
Black Hawk Nursing & Rehab
6,448.63
451.40
6,900.03
5459
JOHN DEERE - FOUNDRY 8001
815.43
57.08
872.51
5461
JOHN DEERE - PEC
2,383.67
166.86
2,550.53
5462
JOHN DEERE - BLDG 1020/1021
12,912.97
903.91
13,816.88
5463
JD - WESTFIELD & JEFFERSON
7,094.79
496.64
7,591.43
12409
JOHN DEERE W&J - BLDG A
245.49
17.18
262.67
10685
CN RAILWAY
-
-
5638
DRAIN DOCTOR
•
-
6657
CONAGRA GROCERY PRODUCTS
29,700.46
2,079.03
31,779.49
6960
HYDRITE CHEMICAL CO
870.46
60.93
931.39
7291
DARLING INTERNATIONAL
-
7324
BLACK HAWK WASTE
-
-
8747
LOST ISLAND METER
46.62
3.26
49.88
22671
Cedar Valley Portables
-
12557
A-1 SEPTIC
1,440.00
100.80
1,540.80
23461
Al Plus Septic
120.00
8.40
128.40
12313
SAVE OUR SINK
-
14452
VET'S TRUCK WASH
7,126.15
498.83
7,624.98
13654
GROTH SERVICES
-
20319
PAUL COOLEY PUMPING COOLEY PUMPING
80.00
5.60
85.60
23413
Crystal Heating & Plumbing
-
20321
GREENS'S SEPTIC SERVICE
40.00
2.80
42.80
20635
22365
ACTIVE BIOMATERIALS
-
-
Roto Rooter
320.00
22.40
342.40
21312
PLANERGY
-
23496
Advanced Drainage Systems (greenline)
11,476.68
803.37
12,280.05
SUBTOTAL TAXABLE
$ 456,743.64
$ 31,972.06
$ 488,715.70
Grand Total
$ 456,743.64
$ 31,972.06
$ 506,761.46
Grand total of Posting
Sales and Use Return Summary
Sales Tax
Use Tax
Final Balances
Name:
Account ID:
Filing Period:
Date:
Confirmation Number:
Gross Sales
Goods Consumed
Total Exemptions
Taxable Amount
State Sales Tax (6%)
Local Option Sales Tax
Total Taxable Purchases
Sales Subject to Use Tax
Taxable Amount
Use Tax
Deposits/Overpayment Credit
Total Tax & Surcharge
Balance
Total Amount Due
CITY OF WATERLOO
1-07-025852
30-Nov-2023
21-Dec-2023
0-004-860-997
$4,186.92
$0.00
$0.00
$4,186.92
$251.22
$41.87
$0.00
$0.00
$0.00
$0.00
$0.00
$293.09
$293.09
$293.09
This is a summary only and will not be accepted as a return by the Iowa Department of Revenue. Retain this document for personal records.
Local Option Sales Details
Confirmation Number: 0-004-860-997
Date: 21-Dec-2023
County
Taxable Sales Local Option Local Option Tax (1.00%)
Black Hawk County - 07
$4,186.92
$4,186.92
$41.87
$41.87
This is a summary only and will not be accepted as a return by the Iowa Department of Revenue. Retain this document for personal records.
Sales and Use Return Summary
Sales Tax
Use Tax
Final Balances
Name:
Account ID:
Filing Period:
Date:
Confirmation Number:
Gross Sales
Goods Consumed
Total Exemptions
Taxable Amount
State Sales Tax (6%)
Local Option Sales Tax
Total Taxable Purchases
Sales Subject to Use Tax
Taxable Amount
Use Tax
Deposits/Overpayment Credit
Total Tax & Surcharge
Balance
Total Amount Due
CITY OF WATERLOO
1-07-025853
30-Nov-2023
21-Dec-2023
0-004-872-548
$6,831.65
$0.00
$0.00
$6,831.65
$409.90
$68.32
$0.00
$0.00
$0.00
$0.00
$0.00
$478.22
$478.22
$478.22
This is a summary only and will not be accepted as a return by the Iowa Department of Revenue. Retain this document for personal records.
Local Option Sales Details
Confirmation Number: 0-004-872-548
Date: 21-Dec-2023
County
Taxable Sales Local Option Local Option Tax (1.00%)
Black Hawk County - 07
$6,831.78 $68.32
$6,831.78 $68.32
This is a summary only and will not be accepted as a return by the Iowa Department of Revenue. Retain this document for personal records.
De' rtment 0
NUE
Sales and Use Return Summary
Sales Tax
Use Tax
Final Balances
Name:
Account ID:
Filing Period:
Date:
Confirmation Number:
Gross Sales
Goods Consumed
Total Exemptions
Taxable Amount
State Sales Tax (6%)
Local Option Sales Tax
Total Taxable Purchases
Sales Subject to Use Tax
Taxable Amount
Use Tax
Deposits/Overpayment Credit
Total Tax & Surcharge
Balance
Total Amount Due
CITY OF WATERLOO
1-07-025854
30-Nov-2023
21-Dec-2023
0-004-864-356
$8,627.10
$0.00
$0.00
$8,627.10
$517.63
$86.27
$0.00
$0.00
$0.00
$0.00
$0.00
$603.90
$603.90
$603.90
This is a summary only and will not be accepted as a return by the Iowa Department of Revenue. Retain this document for personal records.
Local Option Sales Details
Confirmation Number: 0-004-864-356
Date: 21-Dec-2023
County
Taxable Sales Local Option Local Option Tax (1.00%)
Black Hawk County - 07
$8,627.10
$8,627.10
$86.27
$86.27
This is a summary only and will not be accepted as a return by the Iowa Department of Revenue. Retain this document for personal records.
Sales and Use Return Summary
Sales Tax
Use Tax
Final Balances
Name:
Account ID:
Filing Period:
Date:
Confirmation Number:
Gross Sales
Goods Consumed
Total Exemptions
Taxable Amount
State Sales Tax (6%)
Local Option Sales Tax
Total Taxable Purchases
Sales Subject to Use Tax
Taxable Amount
Use Tax
Deposits/Overpayment Credit
Total Tax & Surcharge
Balance
Total Amount Due
CITY OF WATERLOO
1-07-025856
30-Nov-2023
21-Dec-2023
0-004-930-080
$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
This is a summary only and will not be accepted as a return by the Iowa Department of Revenue. Retain this document for personal records.
REVIowa NUDe artment of
E
Sales and Use Return Summary
Sales Tax
Use Tax
Final Balances
Name:
Account ID:
Filing Period:
Date:
Confirmation Number:
Gross Sales
Goods Consumed
Total Exemptions
Taxable Amount
State Sales Tax (6%)
Local Option Sales Tax
Total Taxable Purchases
Sales Subject to Use Tax
Taxable Amount
Use Tax
Deposits/Overpayment Credit
Total Tax & Surcharge
Balance
Total Amount Due
CITY OF WATERLOO
1-07-025857
30-Nov-2023
21-Dec-2023
0-004-880-740
$285.00
$0.00
$0.00
$285.00
$17.10
$2.85
$0.00
$0.00
$0.00
$0.00
$0.00
$19.95
$19.95
$19.95
This is a summary only and will not be accepted as a return by the Iowa Department of Revenue. Retain this document for personal records.
Local Option Sales Details
Confirmation Number: 0-004-880-740
Date: 21-Dec-2023
County
Taxable Sales Local Option Local Option Tax (1.00%)
Black Hawk County - 07
$285.00
$285.00
$2.85
$2.85
This is a summary only and will not be accepted as a return by the Iowa Department of Revenue. Retain this document for personal records.
Iowa De artment of
REV
w�ENUE
Sales and Use Return Summary
Sales Tax
Use Tax
Final Balances
Name:
Account ID:
Filing Period:
Date:
Confirmation Number:
Gross Sales
Goods Consumed
Total Exemptions
Taxable Amount
State Sales Tax (6%)
Local Option Sales Tax
Total Taxable Purchases
Sales Subject to Use Tax
Taxable Amount
Use Tax
Deposits/Overpayment Credit
Total Tax & Surcharge
Balance
Total Amount Due
CITY OF WATERLOO
1-07-030335
30-Nov-2023
21-Dec-2023
0-004-896-182
$135,369.00
$0.00
$0.00
$135,369.00
$8,122.14
$1,353.69
$0.00
$0.00
$0.00
$0.00
$0.00
$9,475.83
$9,475.83
$9,475.83
This is a summary only and will not be accepted as a return by the Iowa Department of Revenue. Retain this document for personal records.
Local Option Sales Details
Confirmation Number: 0-004-896-182
Date: 21-Dec-2023
County
Taxable Sales Local Option Local Option Tax (1.00%)
Black Hawk County - 07
$135,369.00
$135,369.00
$1,353.69
$1,353.69
This is a summary only and will not be accepted as a return by the Iowa Department of Revenue. Retain this document for personal records.
Sales and Use Return Summary
Sales Tax
Use Tax
Final Balances
Name:
Account ID:
Filing Period:
Date:
Confirmation Number:
Gross Sales
Goods Consumed
Total Exemptions
Taxable Amount
State Sales Tax (6%)
Local Option Sales Tax
Total Taxable Purchases
Sales Subject to Use Tax
Taxable Amount
Use Tax
Deposits/Overpayment Credit
Total Tax & Surcharge
Balance
Total Amount Due
CITY OF WATERLOO
1-07-030336
30-Nov-2023
21-Dec-2023
0-004-895-048
$456,743.64
$0.00
$0.00
$456,743.64
$27,404.62
$4,567.44
$0.00
$0.00
$0.00
$0.00
$0.00
$31,972.06
$31,972.06
$31,972.06
This is a summary only and will not be accepted as a return by the Iowa Department of Revenue. Retain this document for personal records.
Local Option Sales Details
Confirmation Number: 0-004-895-048
Date: 21-Dec-2023
County
Taxable Sales Local Option Local Option Tax (1.00%)
Black Hawk County - 07
$456,743.64
$456,743.64
$4,567.44
$4,567.44
This is a summary only and will not be accepted as a return by the Iowa Department of Revenue. Retain this document for personal records.
Iowa Cie artment of
REVENUE
Sales and Use Return Summary
Sales Tax
Use Tax
Final Balances
Name:
Account ID:
Filing Period:
Date:
Confirmation Number:
Gross Sales
Goods Consumed
Total Exemptions
Taxable Amount
State Sales Tax (6%)
Local Option Sales Tax
Total Taxable Purchases
Sales Subject to Use Tax
Taxable Amount
Use Tax
Deposits/Overpayment Credit
Total Tax & Surcharge
Balance
Total Amount Due
CITY OF WATERLOO
1-07-034601
30-Nov-2023
21-Dec-2023
0-004-809-151
$430.00
$0.00
$0.00
$430.00
$25.80
$4.30
$0.00
$0.00
$0.00
$0.00
$0.00
$30.10
$30.10
$30.10
This is a summary only and will not be accepted as a return by the lows Department of Revenue. Retain this document for personal records.
Local Option Sales Details
Confirmation Number: 0-004-809-151
Date: 21-Dec-2023
County
Taxable Sales Local Option Local Option Tax (1.00%)
Black Hawk County - 07
$430.00
$430.00
$4.30
$4.30
This is a summary only and will not be accepted as a return by the Iowa Department of Revenue. Retain this document for personal records.
Sales and Use Return Summary
Sales Tax
Use Tax
Final Balances
Name:
Account ID:
Filing Period:
Date:
Confirmation Number:
Gross Sales
Goods Consumed
Total Exemptions
Taxable Amount
State Sales Tax (6%)
Local Option Sales Tax
Total Taxable Purchases
Sales Subject to Use Tax
Taxable Amount
Use Tax
Deposits/Overpayment Credit
Total Tax & Surcharge
Balance
Total Amount Due
CITY OF WATERLOO
1-07-037313
30-Nov-2023
21-Dec-2023
0-004-796-863
$27,970.09
$0.00
$0.00
$27,970.09
$1,678.21
$279.70
$0.00
$0.00
$0.00
$0.00
$0.00
$1,957.91
$1,957.91
$1,957.91
This is a summary only and will not be accepted as a return by the Iowa Department of Revenue. Retain this document for personal records.
Local Option Sales Details
Confirmation Number: 0-004-796-863
Date: 21-Dec-2023
County
Taxable Sales Local Option Local Option Tax (1.00%)
Black Hawk County - 07
$27,970.09
$27,970.09
$279.70
$279.70
This is a summary only and will not be accepted as a return by the Iowa Department of Revenue. Retain this document for personal records.
Sales and Use Return Summary
Sales Tax
Use Tax
Final Balances
Name:
Account ID:
Filing Period:
Date:
Confirmation Number:
Gross Sales
Goods Consumed
Total Exemptions
Taxable Amount
State Sales Tax (6%)
Local Option Sales Tax
Total Taxable Purchases
Sales Subject to Use Tax
Taxable Amount
Use Tax
Deposits/Overpayment Credit
Total Tax & Surcharge
Balance
Total Amount Due
CITY OF WATERLOO
1-07-040732
30-Nov-2023
21-Dec-2023
0-004-863-332
$118,456.10
$0.00
$0.00
$118,456.10
$7,107.37
$1,184.56
$0.00
$0.00
$0.00
$0.00
$0.00
$8,291.93
$8,291.93
$8,291.93
This is a summary only and will not be accepted as a return by the Iowa Department of Revenue. Retain this document for personal records.
Local Option Sales Details
Confirmation Number: 0-004-863-332
Date: 21-Dec-2023
County
Taxable Sales Local Option Local Option Tax (1.00%)
Black Hawk County - 07
$118,456.10
$118,456.10
$1,184.56
$1,184.56
This is a summary only and will not be accepted as a return by the Iowa Department of Revenue. Retain this document for personal records.