HomeMy WebLinkAboutJanuaryWATERLOO LEISURE SERVICES
SALES TAX REPORT
JANUARY
2024
ACTIVITY 4120 - GOLF COURSES
1398 SALES TAX
GOLF REVENUE 7% TAX COLLECTED
WARREN MEMORIAL 0.00 0.00
GATES 0.00 0.00
SOUTH HILLS 5,868.75 410.81
OFFICE 395.00 27.65
6,263.75 438.46
ACTIVITY 4125 - GOLF COURSE IMPROVEMENTS
1398 SALES TAX
GOLF REVENUE 7% TAX COLLECTED
WARREN MEMORIAL 0.00 0.00
GATES 0.00 0.00
SOUTH HILLS 62.25 4.36
OFFICE 5.00 0.35
67.25 4.71
3-1-23
2/6/2024
YOUNG ARENA
SALES TAX
010-37-4500-1398
Gross Taxable Sales January 2024 58,012.50
Net Taxable Sales January 2024 54,217.29
Total Tax January 2024 3,795.21
To: Ryan Stuber
City Clerks Office
Waterloo City Hall
From: Madonna Welsh
Leisure Services
RYAN STUBER
From: Holly Sackett
Sent: Thursday, February 1, 2024 9:53 AM
To: RYAN STUBER
Subject: Billed Sales Tax January 2024
Good Morning,
Storm water- $ 4,046.92
Garbage- $ 0
Sewer- $ 5,809.35
Thanks!
oUry Sacker
Systems Billing Administrator
Waterloo Water Works
325 Sycamore St
Waterloo, IA 50703
319-232-6280
1
WATERLOO LEISURE SERVICES
SALES TAX REPORT
JANUARY
2024
ACTIVITY 4120 - GOLF COURSES
1398 SALES TAX
GOLF REVENUE 7% TAX COLLECTED
WARREN MEMORIAL 0.00 0.00
GATES 0.00 0.00
SOUTH HILLS 5,868.75 410.81
OFFICE 395.00 27.65
6,263.75 438.46
ACTIVITY 4125 - GOLF COURSE IMPROVEMENTS
1398 SALES TAX
GOLF REVENUE 7% TAX COLLECTED
WARREN MEMORIAL 0.00 0.00
GATES 0.00 0.00
SOUTH HILLS 62.25 4.36
OFFICE 5.00 0.35
67.25 4.71
3-1-23
SPORTS SALES TAX
010-37-4200
Jan-24
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
0.00
0.00
0.00
0.00
0.00
0.00
107.00
100.00
7.00
0.00
0.00
0.00
GROSS SALES TOTAL 107.00
NET SALES TOTAL 100.00
SALES TAX TOTAL 7.00
SPORTSPLEX SALES TAX
010-37-4180
Jan-24
Facility Rentals (4180-3623)
Marketing Revenue (4180-3629)
Daily Admissions (4180-3832)
Membership Fees (4180-3835)
To: Ryan Stuber
City Clerks Office
Waterloo City Hall
GROSS SALES
NET SALES
SALES TAX
41,294.39
38,592.89
2,701.50
0.00
0.00
0.00
7,269.67
6,794.08
475.59
121,782.04
113,814.99
7,967.05
GROSS SALES TOTAL 170,346.10
NET SALES TOTAL 159,201.96
SALES TAX TOTAL 11,144.14
From: Courtney Jackson
Leisure Services
*New GL line added for plex marketing revenue: 4180-3629
TAX REPORT FOR November
WASTE MANAGEMENT SERVICES
Billing Dated 01/26/24
NON-TAXABLE ACTIVITY v`V
V' y`
ACCT. 8
COMPANY
NET BILLED
TOTAL BILLED
5452
BLACK HAWK CARE FACILITY
n/a
-
5453
BLACK HAWK COUNTY SOLID WASTE
1,367.49
n/a
1,367.49
5641
BLACK HAWK COUNTY LANDFILL Annual
2,033.25
2,033.25
5641
BLACK HAWK COUNTY LANDFILL PRET
155.10
n/a
155.10
14061
WATERLOO PROCESSING LLC
1,404.85
1,404.85
14061
WATERLOO PROCESSING LLC annual
130.00
130.00
5644
TYSON FOODS PRET
1,900.30
n/a
1,900.30
5644
Tyson Foods Annual
130.00
130.00
7518
CONAGRA PRET
1,200.30
n/a
1,200.30
13109
CONAGRA
6,098.80
n/a
6,098.80
7518
Conagra Annual
330.00
330.00
6602
J.D. ENGINE WORKS
167.50
n/a
167.50
5640
ARAMARK UNIFORM SERVICES
167.50
n/a
167.50
5643
HYDRITE CHEMICAL CO. PRET
192.50
n/a
192.50
5646
J.D. WESTFIELD
205.00
205.00
5645
J.D. TRACTOR WORKS
367.50
n/a
367.50
12488
PLANERGY
n/a
14453
VETS'S TRUCK WASH
465.00
n/a
465.00
10943
CANADIAN NATIONAL GROUNDWATER
n/a
10521
CANADIAN NATIONAL RAILWAY
516.25
n/a
-
516.25
22509
City of Evansdale
n/a
23714
Advanced Drainage Systems (greenline)Annual
357.95
-
357.95
22085
COOLEY PUMPING
n/a
20973
Renews (Crown Group) Annual
330.00
330.00
13874
J.D. PEC
205.00
n/a
205.00
21969
Allan Industrial
438.25
438.25
12935
IOWA NORTHERN RAILWAY
486.25
n/a
486.25
18,648.79
Non-taxable
18,648.79
TAXABLE ACTIVITY
ACCT#
COMPANY
NET BILLED
TAXED APPLIED
TOTAL BILLED
5451
ARAMARK
9,324.80
652.74
9,977.54
14060
WATERLOO PROCESSING LLC
39,326.01
2,752.82
42,078.83
5456
TYSON FOODS
301,328.04
21,092.96
322,421.00
5457
JOHN DEERE- DONALD STREET
7,445.41
521.18
7,966.59
5458
JOHN DEERE - ENGINE WORKS
1,279.11
89.54
1,368.65
5452
Black Hawk Nursing & Rehab
5,405.35
378.37
5,783.72
5459
JOHN DEERE • FOUNDRY 8001
976.43
68.35
1,044.78
5461
JOHN DEERE • PEC
1,695.63
118.69
1,814.32
5462
JOHN DEERE • BLDG 1020/1021
11,998.49
839.89
12,838.38
5463
JD - WESTFIELD 8 JEFFERSON
7,185.21
502.96
7,688.17
12409
JOHN DEERE WSJ . BLDG A
145.67
10.20
155.87
10685
CN RAILWAY
5638
DRAIN DOCTOR
-
6657
CONAGRA GROCERY PRODUCTS
34,074.89
2,385.24
36,460.13
6960
HYDRITE CHEMICAL CO
-
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
200.00
14.00
214.00
12313 SAVE
OUR SINK
14452 VET'S
TRUCK WASH
10,679.32
747.55
11,426.87
13654 GROTH
SERVICES
20319 PAUL
COOLEY PUMPING COOLEY PUMPING
140.00
9.80
149.80
23413 Crystal
Heating & Plumbing
20321 GREENS'S
SEPTIC SERVICE
60.00
4.20
64.20
20635 ACTIVE
BIOMATERIALS
22365 Roto
Rooter
23496 Advanced
Drainage Systems (greenline)
6,828.22
477.98
7,306.20
SUBTOTAL TAXABLE $
439,132.76
$ 30,739.28
$ 469,872.04
Grand Total $
457,781.55
$ 30,739.28
$ , 488,520,83.
Iowa U
REV
rtment of
NUE
Sales and Use Return Summary
Sales Tax
Use Tax
Final Balances
Payment Information
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
Bank Name
Account Number
Amount
Payment Date
CITY OF WATERLOO
1-07-030336
31-Jan-2024
13-Feb-2024
0-005-307-283
$439,132.55
$0.00
$0.00
$439,132.55
$26,347.95
$4,391.33
$0.00
$0.00
$0.00
$0.00
$0.00
$30,739.28
$30,739.28
$30,739.28
REGIONS BANK
****6001
$30,739.28
13-Feb-2024
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-005-307-283
Date: 13-Feb-2024
County
Taxable Sales Local Option Local Option Tax (1.00%)
Black Hawk County - 07
$439,132.55
$439,132.55
$4,391.33
$4,391.33
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
Payment Information
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
Bank Name
Account Number
Amount
Payment Date
CITY OF WATERLOO
1-07-025857
31-Jan-2024
13-Feb-2024
0-005-276-849
$100.00
$0.00
$0.00
$100.00
$6.00
$1.00
$0.00
$0.00
$0.00
$0.00
$0.00
$7.00
$7.00
$7.00
REGIONS BANK
****6001
$7.00
13-Feb-2024
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-005-276-849
Date: 13-Feb-2024
County
Taxable Sales Local Option Local Option Tax (1.00%)
Black Hawk County - 07 $100.00 $1.00
$100.00 $1.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
Payment Information
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
Bank Name
Account Number
Amount
Payment Date
CITY OF WATERLOO
1-07-030335
31-Jan-2024
13-Feb-2024
0-005-413-756
$140,803.86
$0.00
$0.00
$140,803.86
$8,448.23
$1,408.04
$0.00
$0.00
$0.00
$0.00
$0.00
$9,856.27
$9,856.27
$9,856.27
REGIONS BANK
****6001
$9,856.27
13-Feb-2024
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-005-413-756
Date: 13-Feb-2024
County
Taxable Sales Local Option Local Option Tax (1.00%)
Black Hawk County - 07
$140,803.86
$140,803.86
$1,408.04
$1,408.04
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.
]owa f`paz ` ` tnt
RED'
Sales and Use Return Summary
Sales Tax
Use Tax
Final Balances
Payment Information
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
Bank Name
Account Number
Amount
Payment Date
CITY OF WATERLOO
1-07-025854
31-Jan-2024
13-Feb-2024
0-005-363-195
$5,931.00
$0.00
$0.00
$5,931.00
$355.86
$59.31
$0.00
$0.00
$0.00
$0.00
$0.00
$415.17
$415.17
$415.17
REGIONS BANK
****6001
$415.17
13-Feb-2024
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-005-363-195
Date: 13-Feb-2024
County
Taxable Sales Local Option Local Option Tax (1.00%)
Black Hawk County - 07
$5,931.00
$5,931.00
$59.31
$59.31
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.
� �+ � r true °iof
REVENUE
Sales and Use Return Summary
Sales Tax
Use Tax
Final Balances
Payment Information
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
Bank Name
Account Number
Amount
Payment Date
CITY OF WATERLOO
1-07-034601
31-Jan-2024
13-Feb-2024
0-005-256-369
$400.00
$0.00
$0.00
$400.00
$24.00
$4.00
$0.00
$0.00
$0.00
$0.00
$0.00
$28.00
$28.00
$28.00
REGIONS BANK
****6001
$28.00
13-Feb-2024
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-005-256-369
Date: 13-Feb-2024
County
Taxable Sales Local Option Local Option Tax (1.00%)
Black Hawk County - 07
$400.00 $4.00
$400.00 $4.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.
Iowa De Department of
REVENUE
Sales and Use Return Summary
Sales Tax
Use Tax
Final Balances
Payment Information
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
Bank Name
Account Number
Amount
Payment Date
CITY OF WATERLOO
1-07-037313
31-Jan-2024
13-Feb-2024
0-005-269-674
$54,217.29
$0.00
$0.00
$54,217.29
$3,253.04
$542.17
$0.00
$0.00
$0.00
$0.00
$0.00
$3,795.21
$3,795.21
$3,795.21
REGIONS BANK
****6001
$3,795.21
13-Feb-2024
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-005-269-674
Date: 13-Feb-2024
County
Taxable Sales Local Option Local Option Tax (1.00%)
Black Hawk County - 07 $54,217.29 $542.17
$54,217.29 $542.17
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.
DepartmentN
R
Sales and Use Return Summary,
Sales Tax
Use Tax
Final Balances
Payment Information
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
Bank Name
Account Number
Amount
Payment Date
CITY OF WATERLOO
1-07-040732
31-Jan-2024
13-Feb-2024
0-005-263-448
$159,201.96
$0.00
$0.00
$159,201.96
$9,552.12
$1,592.02
$0.00
$0.00
$0.00
$0.00
$0.00
$11,144.14
$11,144.14
$11,144.14
REGIONS BANK
****6001
$11,144.14
13-Feb-2024
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-005-263-448
Date: 13-Feb-2024
County
Taxable Sales Local Option Local Option Tax (1.00%)
Black Hawk County - 07
$159,201.96
$159,201.96
$1,592.02
$1,592.02
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
31-Jan-2024
13-Feb-2024
0-005-358-646
$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.
...lima De artrnent 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-025852
31-Jan-2024
13-Feb-2024
0-005-360-123
$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.
Iowa De artment of
REV�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-025856
31-Jan-2024
13-Feb-2024
0-005-244-081
$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.