HomeMy WebLinkAboutOctoberJan Apr July Oct
Net Taxable Sales
Sales Tax Collected
6°/0
1%
Total Sales Tax
Difference
Leisure Services - Sports & Pools
S orts
685.00
47.95
41.10
6.85
47.95
Total Tax Duel $
0.00
Byrnes
0.00
0.00
0.00
47.95 I $
WM SERVICES
Water
Pollution
Net Taxable Sales 459,334.20
Sales Tax Collected 32,153.37
6% 27,560.05
1% 4,593.34
Total Sales Tax 32.153.39
Difference
-0.02
Total Tax Duel $ 32,153.37 I
REGIONS
BANK
0.00
Gates
0.00
0.00
0.00
0.00
2023
YEAR
Monthly State Sales Tax
Leisure Services - Golf Courses
Gates
Warren Memorial
South Hills
Re.
14,300.70
1,001.05
' Improv
99.30
6.95
- -
Re.
Improv
Reg
Improv
16,359.81
1,145.19
119.63
8.37
13,504.67
945.33
85.98
6.02
810.28
135.05
945.33
0.00
5.16
0.86
6.02
981.59
163.60
1,145.19
0.00 0,00
7.18
1.20
8.37
143.01
1.001.05
0.00 0.00
Gates - Total Warren Mem - Total
I $ 951.35 j $ 1,153.56
'GROSS SALES 13,590.65 IGROSS SALES 16,479.44
$ 945.33 $ 6.02 $ 1,145.19 $ 8.37
Sewer
Garbage
Storm Wtr
136,881.29
9,581.69
8,212.88
1,368.81
9,581.69
0.00
I $ 9,581.69 I
Young
Arena
20,996.73
1,469.77.
1,259.80
209.97
1.469.77
0 00
$ 1,469.77 I
Sewer Tax
Garbage Tax
Storm Tax
4,103.97
0.00
5,477.72
SportsPlex
94,326.06
6,602.82
5,659.56
943.26
6,602.82
00
5,659.56
943.26
$ 6,602.82
0.99
6.95
0.00
Leisure - Office
Reg Im rov
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
South Hills - Total Leisure - Total
$ 1,008.00 I $
'GROSS SALES 14,400.00 GROSS SALE5
$ 1,001.05 $ 6.95 $ - $
0.00
6%
00
1%
Total
QTR
857
Sports
41.10
6.85
47.95
QTR
856
Byrnes Pool
0.00
0.00
QTR
855
852
Gates Pool
Gates
0.00
815.00
0.00
136.00
-
951.00
853
Warren
989.00
165.00
1,154.00
QTR
854
601
336
South Hills
Leisure Office
Wtr Pollution
864.00
0.00
27,560.00
144.00
0.00
4,593.00
1,008.00
-
32,153.00
335
Wtr/Swr/Gbg
8,213.00
1,369.00
9,582.00
313
Young Arena
1,260.00
210.00
1,470.00
732
SportsPlex
5,660.00
943.00
6,603.00
WATERLOO LEISURE SERVICES
SALES TAX REPORT
OCTOBER
2023
ACTIVITY 4120 - GOLF COURSES
1398 SALES TAX
GOLF REVENUE 7% TAX COLLECTED
WARREN MEMORIAL 16,359.81 1,145.19
GATES 13, 504.67 945.33
SOUTH HILLS 14,300.70 1,001.05
OFFICE 0.00 0.00
44,165.18 3,091.56
ACTIVITY 4125 - GOLF COURSE IMPROVEMENTS
1398 SALES TAX
GOLF REVENUE 7% TAX COLLECTED
WARREN MEMORIAL 119.63 8.37
GATES 85.98 6.02
SOUTH HILLS 99.30 6.95
OFFICE 0.00 0.00
304.91 21.34
11-2-23
WATERLOO LEISURE SERVICES
SALES TAX REPORT
OCTOBER
2023
ACTIVITY 4120 - GOLF COURSES
1398 SALES TAX
GOLF REVENUE 7% TAX COLLECTED
WARREN MEMORIAL 16,359.81 1,145.19
GATES 13,504.67 945.33
SOUTH HILLS 14,300.70 1,001.05
OFFICE 0.00 0.00
44,165.18 3,091.56
ACTIVITY 4125 - GOLF COURSE IMPROVEMENTS
1398 SALES TAX
GOLF REVENUE 7% TAX COLLECTED
WARREN MEMORIAL 119.63 8.37
GATES 85.98 6.02
SOUTH HILLS 99.30 6.95
OFFICE 0.00 0.00
304.91 21.34
11-2-23
WATERLOO LEISURE SERVICES
SALES TAX REPORT
OCTOBER
2023
ACTIVITY 4120 - GOLF COURSES
1398 SALES TAX
GOLF REVENUE 7% TAX COLLECTED
WARREN MEMORIAL 16,359.81 1,145.19
GATES 13,504.67 945.33
SOUTH HILLS 14,300.70 1,001.05
OFFICE 0.00 0.00
44,165.18 3,091.56
ACTIVITY 4125 - GOLF COURSE IMPROVEMENTS
1398 SALES TAX
GOLF REVENUE 7% TAX COLLECTED
WARREN MEMORIAL 119.63 8.37
GATES 85.98 6.02
SOUTH HILLS 99.30 6.95
OFFICE 0.00 0.00
304.91 21.34
11-2-23
TAX REPORT FOR OCTOBER
WASTE MANAGEMENT SERVICES
Billing Dated 10/24/2023
September 2023 Usage
NON-TAXABLE ACTIVITY
ACCT. #
COMPANY
NET BILLED
TOTAL BILLED
5452
BLACK HAWK CARE FACILITY
n/a
-
5453
BLACK HAWK COUNTY SOLID WASTE
2,624.38
n/a
2,624.38
5641
BLACK HAWK COUNTY LANDFILL PRET
177.60
n/a
177.60
14061
WATERLOO PROCESSING LLC
1,693.05
1,693.05
5644
TYSON FOODS PRET
1,839.00
n/a
1,839.00
7518
CONAGRA PRET
1,189,00
n/a
1,189.00
13109
CONAGRA
6,647.35
n/a
6,647.35
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
60.00
n/a
60.00
22085
COOLEY PUMPING
n/a
13874
J.D. PEC
n/a
-
12935
IOWA NORTHERN RAILWAY
n/a
-
Non-taxable
14,230.38
TAXABLE ACTIVITY
ACCT#
COMPANY
NET BILLED
TAXED APPLIED
TOTAL BILLED
5451
ARAMARK
8,756.62
612.96
9,369.58
14060
WATERLOO PROCESSING LLC
41,493.62
2,904.55
44,398.17
14060
TWIN CITY TANNERY CO
-
-
5456
TYSON FOODS
303,251.16
21,227.58
324,478.74
5457
JOHN DEERE - DONALD STREET
19,317.55
1,352.23
20,669.78
5458
JOHN DEERE - ENGINE WORKS
2,551.01
178.57
2,729.58
5452
Black Hawk Nursing & Rehab
5,720.91
400.46
6,121.37
5459
JOHN DEERE - FOUNDRY 8001
1,008.63
70.60
1,079.23
5460
JOHN DEERE- FOUNDRY 8002
-
-
5461
JOHN DEERE - PEC
3,521.32
246.49
3,767.81
5462
JOHN DEERE - BLDG 1020/1021
10,752.35
752.66
11,505.01
5463
JD • WESTFIELD & JEFFERSON
5,437.24
380.61
5,817.85
12409
JOHN DEERE W&J - BLDG A
2,145.29
150.17
2,295.46
10685
CN RAILWAY
-
-
5638
DRAIN DOCTOR
-
-
6657
CONAGRA GROCERY PRODUCTS
38,546.63
2,698.26
41,244.89
6960
HYDRITE CHEMICAL CO
37.06
2.59
39.65
7291
DARLING INTERNATIONAL
-
-
7324
BLACK HAWK WASTE
-
-
8747
LOST ISLAND METER
40.18
2.81
42.99
22671
Cedar Valley Portables
-
-
12557
A-1 SEPTIC
1,000.00
70.00
1,070.00
23461
Al Plus Septic
60.00
4.20
64.20
12313
SAVE OUR SINK
-
-
14452
VET'S TRUCK WASH
8,814.38
617.01
9,431.39
13654
GROTH SERVICES
-
-
20319
PAUL COOLEY PUMPING COOLEY PUMPING
220.00
15.40
235.40
23413
Crystal Heating & Plumbing
-
-
20321
GREENS'S SEPTIC SERVICE
40.00
2.80
42.80
20635
22365
ACTIVE BIOMATERIALS
-
Roto Rooter
80.00
5.60
85.60
21312
PLANERGY
-
23496
Advanced Drainage Systems (greenllne)
6,540.25
457.82
6,998.07
SUBTOTAL TAXABLE
$ 459,334.20
$ 32,153.37
$ 491,487.57
Grand Total
$ 459,334.20
$ 32,153.37
'S 505,717.95
Grand total of Posting
SPORTS SALES TAX
010-37-4200
Oct-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
GROSS SALES
NET SALES
SALES TAX
0.00
0.00
0.00
0.00
0.00
0.00
631.30
590.00
41.30
101.65
95.00
6.65
GROSS SALES TOTAL 732.95
NET SALES TOTAL 685.00
SALES TAX TOTAL 47.95
SPORTSPLEX SALES TAX
010-37-4180
Oct-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
12,503.29
11,685.32
817.97
4,616.19
4,314.20
301.99
83,809.40
78,326.54
5,482.86
GROSS SALES TOTAL 100,928.88
NET SALES TOTAL 94,326.06
SALES TAX TOTAL 6,602.82
From: Courtney Jackson
Leisure Services
RYAN STUBER
From: Holly Sackett
Sent: Wednesday, November 1, 2023 8:32 AM
To: RYAN STUBER
Subject: Billed Sales Tax October 2023
Good Morning,
Storm water- $ 4,103.97
Garbage- $ 0.00
Sewer- $ 5,477.72
Thanks
'RioU4 Saekctr
Systems Billing Administrator
Waterloo Water Works
325 Sycamore St
Waterloo, IA 50703
319-232-6280
i
11/7/2023
YOUNG ARENA
SALES TAX
010-37-4500-1398
Gross Taxable Sales October 2023 22,466.50
Net Taxable Sales October 2023 20,996.73
Total Tax October 2023 1,469.77
To: Ryan Stuber
City Clerks Office
Waterloo City Hall
From: Madonna Welsh
Leisure Services
Sales and Use Return Summary
Sales Tax
Use Tax
Final Balances
Name:
Account ID:
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
14-Nov-2023
0-004-774-954
$13, 590.65
$0.00
$0.00
$13,590.65
$815.44
$135.91
$0.00
$0.00
$0.00
$0.00
$0.00
$951.35
$951.35
$951.35
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-774-954
Date: 14-Nov-2023
County
Taxable Sales Local Option Local Option Tax (1.00%)
Black Hawk County - 07
$13,590.65
$13,590.65
$135.91
$135.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.
Sales and Use Return Summary
Sales Tax
Use Tax
Final Balances
Name:
Account ID:
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
14-Nov-2023
0-004-665-181
$16,479.44
$0.00
$0.00
$16,479.44
$988.77
$164.79
$0.00
$0.00
$0.00
$0.00
$0.00
$1,153.56
$1,153.56
$1,153.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.
Local Option Sales Details
Confirmation Number: 0-004-665-181
Date: 14-Nov-2023
County
Taxable Sales Local Option Local Option Tax (1.00%)
Black Hawk County - 07
$16,479.44
$16,479.44
$164.79
$164.79
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:
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
14-Nov-2023
0-004-703-069
$14,400.00
$0.00
$0.00
$14,400.00
$864.00
$144.00
$0.00
$0.00
$0.00
$0.00
$0.00
$1,008.00
$1,008.00
$1,008.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.
Local Option Sales Details
Confirmation Number: 0-004-703-069
Date: 14-Nov-2023
County
Taxable Sales Local Option Local Option Tax (1.00%)
Black Hawk County - 07
$14,400.00
$14,400.00
$144.00
$144.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.
Sales and Use Return Summary
Sales Tax
Use Tax
Final Balances
Name:
Account ID:
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
14-Nov-2023
0-004-692-434
$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 lows Department of Revenue. Retain this document for personal records.
lows De rtment of
REVENUE
Sales and Use Return Summary
Sales Tax
Use Tax
Final Balances
Name:
Account ID:
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
14-Nov-2023
0-004-629-438
$685.00
$0.00
$0.00
$685.00
$41.10
$6.85
$0.00
$0.00
$0.00
$0.00
$0.00
$47.95
$47.95
$47.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-629-438
14-Nov-2023
Date:
County
Taxable Sales Local Option Local Option Tax (1.00%)
Black Hawk County - 07
$685.00
$685.00
$6.85
$6.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.
Sales and Use Return Summary
Sales Tax
Use Tax
Final Balances
Name:
Account ID:
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
14-Nov-2023
0-004-684-978
$136,881.29
$0.00
$0.00
$136,881.29
$8,212.88
$1,368.81
$0.00
$0.00
$0.00
$0.00
$0.00
$9,581.69
$9,581.69
$9,581.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.
Local Option Sales Details
Confirmation Number: 0-004-684-978
Date: 14-Nov-2023
County
Taxable Sales Local Option Local Option Tax (1.00%)
Black Hawk County - 07
$136,881.29
$136,881.29
$1,368.81
$1,368.81
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:
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
14-Nov-2023
0-004-704-969
$459,333.75
$0.00
$0.00
$459,333.75
$27,560.03
$4,593.34
$0.00
$0.00
$0.00
$0.00
$0.00
$32,153.37
$32,153.37
$32,153.37
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-704-969
Date: 14-Nov-2023
County
Taxable Sales Local Option Local Option Tax (1.00%)
Black Hawk County - 07
$459,333.75
$459,333.75
$4,593.34
$4,593.34
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:
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
14-Nov-2023
0-004-589-775
$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.
Sales and Use Return Summary
Sales Tax
Use Tax
Final Balances
Name:
Account ID:
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
14-Nov-2023
0-004-587-855
$20,996.73
$0.00
$0.00
$20,996.73
$1,259.80
$209.97
$0.00
$0.00
$0.00
$0.00
$0.00
$1,469.77
$1,469.77
$1,469.77
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-587-855
Date: 14-Nov-2023
County
Taxable Sales Local Option Local Option Tax (1.00%)
Black Hawk County - 07
$20,996.73
$20,996.73
$209.97
$209.97
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:
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
14-Nov-2023
0-004-711-290
$94,326.06
$0.00
$0.00
$94,326.06
$5,659.56
$943.26
$0.00
$0.00
$0.00
$0.00
$0.00
$6,602.82
$6,602.82
$6,602.82
This is a summary only and will not be accepted as a return by the Iowa Department of Revenue. 'tetain this document for personal records.
Local Option Sales Details
Confirmation Number: 0-004-711-290
Date: 14-Nov-2023
County
Taxable Sales Local Option Local Option Tax (1.00%)
Black Hawk County - 07
$94,326.06
$94,326.06
$943.26
$943.26
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.