HomeMy WebLinkAboutMay TAX REPORT FOR May 2023
WASTE MANAGEMENT SERVICES
Billing Dated 05/25/23
April 2023 Usage
NON-TAXABI E ACTIVITY
ACCT.d COMPANY NET BILLED TOTAL BILLED
5452 BLACK HAWK CARE FACILITY Na -
5453 BLACK HAWK COUNTY SOLID WASTE 2,252.18 nls 2,262.18
5641 BLACK HAWK COUNTY LANDFILL PRET 177.80 n/a 117.60
14061 WATERLOO PROCESSING LLC 1,837.15 n/a 1,83715
6644 TYSON FOODS PRET 1339.00 nla 1,839.00
7518 CONAGRA PRET 1209.00 n/a 1.209.00
13109 CONAGRA 6.208.50 n/a 8,208.50
12488 PLANERGY n/a -
10943 CANADIAN NATIONAL GROUNDWATER Na -
5641 BLACK HAWK COUNTY LANDFILL PRET-FEES/PERM Na -
7618 CONAGRA PRET-FEES/PERM n/a
•
6602 J.D.ENGINE WORKS-FEES/PERM n/a -
5646 J.D.WESTFIELD-FEES/PERM Na -
5645 J.D.TRACTOR WORKS-FEES/PERM n/a -
14453 VET'S TRUCK WASH-FEES/PERM n/a
10521 CANADIAN NATIONAL RAILWAY-FEES/PERM n/a -
21969 ALLAN INDUSTRIAL COATINGS-FEES/PERM n/° -
136T4 J.D PEC-FEES/PERM Na -
5640 ARAMARK UNIFORM SERVICES-FEES/PERM Ns -
6464 DARLING INTERNATIONAL.FEES/PERM Na -
5643 HYDRITE-FEES/PERM Na -
12935 IOWA NORTHERN RAILWAY-FEES/PERM Na
20973 THE CROWN GROUP Na -
14061 watERLOO PROCESSING LLCllatifeepermit Na -
14061 WATERLOO PROCESSING LLC n/a -
5844 TYSON FRESH MEATS INC-FEES/PERM n/a
12935 IOWA NORTHERN RAILWAY n/a
22509 EVANSDALE 60.00 n/a 60.00
6657 CONAGRA LABOR AND MATERIAL n/a
13,581 41 0.00 13,581 41
TAXABLE ACTIVITY
ACCT8 COMPANY TAXED APPLIED TOTAL BILLED
5451 ARAMARK 5,248.98 367.43 5,618.41
14060 WATERLOO PROCESSING LLC 51,707.71 3,619.54 55,327.25
5456 TYSON FOODS 381,858.38 26,729.95 408,586.33
5457 JOHN DEERE-DONALD STREET 8,383.46 586.84 8,970.30
5458 JOHN DEERE-ENGINE WORKS 2,080.78 145.65 2,228.91
5459 JOHN DEERE•FOUNDRY 8001 1,002.00 70.14 1,072.14
5480 JOHN DEERE-FOUNDRY 8002 "
5461 JOHN DEERE-PEC 1,599.85 129.49 1,979.34
5462 JOHN DEERE-BLDG 1020/1021 12,576.32 880.34 13,456.66
5463 JD-WESTFIELD 8 JEFFERSON 6,531.91 457.23 6,959.14
12409 JOHN DEERE W&J•BLDG A 1,799.98 122.50 1,872.48
5638 DRAIN DOCTOR •
22538 NUTRI JECT SYSTEMS
20321 GREEN'S SEPTIC 80.00 4.20 64.20
5951 KAYSER PLUMBING -
865T CONAGRA GROCERY PRODUCTS 33,471.71 2,343.02 35,814,73
6960 HYDRITE CHEMICAL CO 730.12 51.11 781.23
7291 DARLING INTERNATIONAL -
7324 BLACK HAWK WASTE 20.00 1.40 21.40
8747 LOST ISLAND METER 2,751.78 194.72 2,976.50
8089 CROWN SEWER 8 SEPTIC "
•
12557 A-1 SEPTIC 1,000.00 70.00 1,070.00
12313 SAVE OUR SINK •
23461 A PLUS SEPTIC 40.00 2.80 42.80
23496 ADVANCED DRAINAGE SYSTEMS -
•
21312 PLANERGYIROTO ROOTER
14452 VET'S TRUCK WASH 10,573.69 707.16 11,420.85
5452 Black Hawk Nursing S ReBaa 4,243.95 297.08 4,541.03
22671 CEDAR VALLEY PORTABLES
20319 PAUL COOLEY PUMPING COOLEY PUMPING 40.00 2.80 43.80
10685 CHICAGO CENTRAL AND PACIFIC
22365 ROTO ROOTER - -
23496 Advanced Drain9a9e 3,928.84 274.88 4,201.72
SUBTOTAL TAXABLE S 529,975.44 S 37,098.28 S 567,073./2
Grand Total $ 543,556.85 S 37,098.26 S 580,855.13
Grand total of Posting
Grand total of Posting
SPORTSPLEX SALES TAX
010-37-4180
May-23
GROSS SALES NET SALES SALES TAX
Facility Rentals (4180-3623) 10,755.48 10,051.85 703.63
Daily Admissions (4180-3832) 4,707.25 4,399.30 307.95
Membership Fees (4180-3835) 89,216.32 83,379.74 5,836.58
GROSS SALES TOTAL 104,679.05
NET SALES TOTAL 97,830.89
SALES TAX TOTAL 6,848.16
To: Ryan Stuber
City Clerks Office
Waterloo City Hall
From: Courtney Jackson
Leisure Services
SPORTS SALES TAX
010-37-4200
May-23
GROSS SALES NET SALES SALES TAX
USSSA BB/SB (4200-3831) 0.00 0.00 _ 0.00
Elks/Kiwanis/Katoski Golf(4200-3831) 0.00 0.00 0.00
Diamond Rentals (4200-3831) 283.55 265.00 18.55
Adult BB/VB (4200-3897) 0.00 0.00 _ 0.00
GROSS SALES TOTAL 283.55
NET SALES TOTAL 265.00
SALES TAX TOTAL 18.55
To: Ryan Stuber
City Clerks Office
Waterloo City Hall
From: Courtney Jackson
Leisure Services
WATERLOO LEISURE SERVICES
SALES TAX REPORT
MAY
2023
ACTIVITY 4120 - GOLF COURSES
1398 SALES TAX
GOLF REVENUE 7% TAX COLLECTED
WARREN MEMORIAL 52,630.61 3,684.14
GATES 42,955.14 3,006.86
SOUTH HILLS 48,034.58 3,362.42
OFFICE 4,704.21 329.29
148,324.54 10,382.72
ACTIVITY 4125 - GOLF COURSE IMPROVEMENTS
1398 SALES TAX
GOLF REVENUE 7%TAX COLLECTED
WARREN MEMORIAL 493.69 34.56
GATES 405.61 28.39
SOUTH HILLS 449.53 31.47
OFFICE 48.13 3.37
1,396.96 97.79
6-6-23
BYRNES SALES TAX
010-37-4200-3475
May-23
GROSS SALES NET SALES SALES TAX
Byrnes Pool Daily Admissions (4200-3475) 3,000.00 2,803.74 196.26
Pool Season Passes (4200-3475) 2,322.67 2,170.72 151.95
Outdoor Pool Rentals (4200-3475) 350.00 327.10 22.90
GROSS SALES TOTAL 5,672.67
NET SALES TOTAL 5,301.56
SALES TAX TOTAL 371.11
To: Ryan Stuber
City Clerks Office
Waterloo City Hall
From: Courtney Jackson
Leisure Services
RYAN STUBER
From: Holly Sackett
Sent: Thursday, June 1, 2023 9:56 AM
To: RYAN STUBER
Subject: Billed Sales Tax May 2023
Good Morning,
Here's the billed sales tax for May 2023:
Storm water-$3,599.33
Garbage-$6.20
Sewer-$5,219.25
Thanks!
Wol4 Saeatt
Systems Billing Administrator
Waterloo Water Works
325 Sycamore St
Waterloo, IA 50703
319-232-6280
1
6/7/2023
YOUNG ARENA
SALES TAX
010-37-4500-1398
Gross Taxable Sales May 2023 4,910.00
Net Taxable Sales May 2023 4,588.79
Total Tax May 2023 321.21
To: Ryan Stuber
City Clerks Office
Waterloo City Hall
From: Madonna Welsh
Leisure Services
WATERLOO LEISURE SERVICES
SALES TAX REPORT
MAY
2023
ACTIVITY 4120 - GOLF COURSES
1398 SALES TAX
GOLF REVENUE 7% TAX COLLECTED
WARREN MEMORIAL 52,630.61 3,684.14
GATES 42,955.14 3,006.86
SOUTH HILLS 48,034.58 3,362.42
OFFICE 4,704.21 329.29
148,324.54 10,382.72
ACTIVITY 4125 - GOLF COURSE IMPROVEMENTS
1398 SALES TAX
GOLF REVENUE 7%TAX COLLECTED
WARREN MEMORIAL 493.69 34.56
GATES 405.61 28.39
SOUTH HILLS 449.53 31.47
OFFICE 48.13 3.37
1,396.96 97.79
6-6-23
WATERLOO LEISURE SERVICES
SALES TAX REPORT
MAY
2023
ACTIVITY 4120 - GOLF COURSES
1398 SALES TAX
GOLF REVENUE 7% TAX COLLECTED
WARREN MEMORIAL 52,630.61 3,684.14
GATES 42,955.14 3,006.86
SOUTH HILLS 48,034.58 3,362.42
OFFICE 4,704.21 329.29
148,324.54 10,382.72
ACTIVITY 4125 - GOLF COURSE IMPROVEMENTS
1398 SALES TAX
GOLF REVENUE 7%TAX COLLECTED
WARREN MEMORIAL 493.69 34.56
GATES 405.61 28.39
SOUTH HILLS 449.53 31.47
OFFICE 48.13 3.37
1,396.96 97.79
6-6-23
WATERLOO LEISURE SERVICES
SALES TAX REPORT
MAY
2023
ACTIVITY 4120 - GOLF COURSES
1398 SALES TAX
GOLF REVENUE 7% TAX COLLECTED
WARREN MEMORIAL 52,630.61 3,684.14
GATES 42,955.14 3,006.86
SOUTH HILLS 48,034.58 3,362.42
OFFICE 4,704.21 329.29
148,324.54 10,382.72
ACTIVITY 4125 - GOLF COURSE IMPROVEMENTS
1398 SALES TAX
GOLF REVENUE 7%TAX COLLECTED
WARREN MEMORIAL 493.69 34.56
GATES 405.61 28.39
SOUTH HILLS 449.53 31.47
OFFICE 48.13 3.37
1,396.96 97.79
6-6-23
REVENUE
Name: CITY OF WATERLOO
Account ID: 1-07-025852
Filing Period: 31-May-2023
Date: 14-Jun-2023
Confirmation Number: 0-003-639-939
Sales and Use Return Summary
Sales Tax Gross Sales $43,360.70
Goods Consumed $0.00
Total Exemptions $0.00
Taxable Amount $43,360.70
State Sales Tax (6%) $2,601.64
Local Option Sales Tax $433.61
Use Tax Total Taxable Purchases $0.00
Sales Subject to Use Tax $0.00
Taxable Amount $0.00
Use Tax $0.00
Final Balances Deposits/Overpayment Credit $0.00
Total Tax & Surcharge $3,035.25
Balance $3,035.25
Total Amount Due $3,035.25
Payment Information Bank Name REGIONS BANK
Account Number ****6001
Amount $3,035.25
Payment Date 14-Jun-2023
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-003-639-939
Date: 14-Jun-2023
County Taxable Sales Local Option Local Option Tax (1.00%)
Black Hawk County - 07 $43,360.70 $433.61
$43,360.70 $433.61
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.
C9Wa De artment of
REVENUE
Name: CITY OF WATERLOO
Account ID: 1-07-025853
Filing Period: 31-May-2023
Date: 14-Jun-2023
Confirmation Number: 0-003-720-913
Sales and Use Return Summary
Sales Tax Gross Sales $53,124.30
Goods Consumed $0.00
Total Exemptions $0.00
Taxable Amount $53,124.30
State Sales Tax (6%) $3,187.46
Local Option Sales Tax $531.24
Use Tax Total Taxable Purchases $0.00
Sales Subject to Use Tax $0.00
Taxable Amount $0.00
Use Tax $0.00
Final Balances Deposits/Overpayment Credit $0.00
Total Tax & Surcharge $3,718.70
Balance $3,718.70
Total Amount Due $3,718.70
Payment Information Bank Name REGIONS BANK
Account Number "'*6001
Amount $3,718.70
Payment Date 14-Jun-2023
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-003-720-913
Date: 14-Jun-2023
County Taxable Sales Local Option Local Option Tax (1.00%)
Black Hawk County- 07 $53,124.30 $531.24
$53,124.30 $531.24
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.
REVeENUE
Name: CITY OF WATERLOO
Account ID: 1-07-025854
Filing Period: 31-May-2023
Date: 14-Jun-2023
Confirmation Number: 0-003-708-067
Sales and Use Return Summary
Sales Tax Gross Sales $48,484.11
Goods Consumed $0.00
Total Exemptions $0.00
Taxable Amount $48,484.11
State Sales Tax (6%) $2,909.05
Local Option Sales Tax $484.84
Use Tax Total Taxable Purchases $0.00
Sales Subject to Use Tax $0.00
Taxable Amount $0.00
Use Tax $0.00
Final Balances Deposits/Overpayment Credit $0.00
Total Tax & Surcharge $3,393.89
Balance $3,393.89
Total Amount Due $3,393.89
Payment Information Bank Name REGIONS BANK
Account Number ****6001
Amount $3,393.89
Payment Date 14-Jun-2023
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-003-708-067
Date: 14-Jun-2023
County Taxable Sales Local Option Local Option Tax (1.00%)
Black Hawk County- 07 $48,484.11 $484.84
$48,484.11 $484.84
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.
Rartment of
REVENUE
Name: CITY OF WATERLOO
Account ID: 1-07-025856
Filing Period: 31-May-2023
Date: 14-Jun-2023
Confirmation Number: 0-003-623-071
Sales and Use Return Summary
Sales Tax Gross Sales $5,301.56
Goods Consumed $0.00
Total Exemptions $0.00
Taxable Amount $5,301.56
State Sales Tax (6%) $318.09
Local Option Sales Tax $53.02
Use Tax Total Taxable Purchases $0.00
Sales Subject to Use Tax $0.00
Taxable Amount $0.00
Use Tax $0.00
Final Balances Deposits/Overpayment Credit $0.00
Total Tax & Surcharge $371.11
Balance $371.11
Total Amount Due $371.11
•
Payment Information Bank Name REGIONS BANK
Account Number ****6001
Amount $371.11
Payment Date 14-Jun-2023
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-003-623-071
Date: 14-Jun-2023
County Taxable Sales Local Option Local Option Tax (1.00%)
Black Hawk County- 07 $5,301.56 $53.02
$5,301.56 $53.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.
REVaNUE
Name: CITY OF WATERLOO
Account ID: 1-07-025857
Filing Period: 31-May-2023
Date: 14-Jun-2023
Confirmation Number: 0-003-631-263
Sales and Use Return Summary
Sales Tax Gross Sales $265.00
Goods Consumed $0.00
Total Exemptions $0.00
Taxable Amount $265.00
State Sales Tax (6%) $15.90
Local Option Sales Tax $2.65
Use Tax Total Taxable Purchases $0.00
Sales Subject to Use Tax $0.00
Taxable Amount $0.00
Use Tax $0.00
Final Balances Deposits/Overpayment Credit $0.00
Total Tax & Surcharge $18.55
Balance $18.55
Total Amount Due $18.55
Payment Information Bank Name REGIONS BANK
Account Number ****6001
Amount $18.55
Payment Date 14-Jun-2023
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-003-631-263
Date: 14-Jun-2023
County Taxable Sales Local Option Local Option Tax (1.00%)
Black Hawk County- 07 $265.00 $2.65
$265.00 $2.65
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,
rtment of
REVENUE
Name: CITY OF WATERLOO
Account ID: 1-07-030335
Filing Period: 31-May-2023
Date: 14-Jun-2023
Confirmation Number: 0-003-711-533
Sales and Use Return Summary
Sales Tax Gross Sales $126,068.29
Goods Consumed $0.00
Total Exemptions $0.00
Taxable Amount $126,068.29
State Sales Tax (6%) $7,564.10
Local Option Sales Tax $1,260.68
Use Tax Total Taxable Purchases $0.00
Sales Subject to Use Tax $0.00
Taxable Amount $0.00
Use Tax $0.00
Final Balances Deposits/Overpayment Credit $0.00
Total Tax & Surcharge $8,824.78
Balance $8,824.78
Total Amount Due $8,824.78
Payment Information Bank Name REGIONS BANK
Account Number ****6001
Amount $8,824.78
Payment Date 14-Jun-2023
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-003-711-533
Date: 14-Jun-2023
County Taxable Sales Local Option Local Option Tax(1.00%)
Black Hawk County- 07 $126,068.29 $1,260.68
$126,068.29 $1,260.68
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.
DeRartment of
REVENUE
Name: CITY OF WATERLOO
Account ID: 1-07-030336
Filing Period: 31-May-2023
Date: 14-Jun-2023
Confirmation Number: 0-003-659-935
Sales and Use Return Summary
Sales Tax Gross Sales $529,975.44
Goods Consumed $0.00
Total Exemptions $0.00
Taxable Amount $529,975.44
State Sales Tax (6%) $31,798.53
Local Option Sales Tax $5,299.75
Use Tax Total Taxable Purchases $0.00
Sales Subject to Use Tax $0.00
Taxable Amount $0.00
Use Tax $0.00
Final Balances Deposits/Overpayment Credit $0.00
Total Tax & Surcharge $37,098.28
Balance $37,098.28
Total Amount Due $37,098.28
Payment Information Bank Name REGIONS BANK
Account Number ''6001
Amount $37,098.28
Payment Date 14-Jun-2023
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-003-659-935
Date: 14-Jun-2023
County Taxable Sales Local Option Local Option Tax(1.00%)
Black Hawk County- 07 $529,975.44 $5,299.75
$529,975.44 $5,299.75
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.
REVENUE
Name: CITY OF WATERLOO
Account ID: 1-07-034601
Filing Period: 31-May-2023
Date: 14-Jun-2023
Confirmation Number: 0-003-625-236
Sales and Use Return Summary
Sales Tax Gross Sales $4,752.34
Goods Consumed $0.00
Total Exemptions $0.00
Taxable Amount $4,752.34
State Sales Tax (6%) $285.14
Local Option Sales Tax $47.52
Use Tax Total Taxable Purchases $0.00
Sales Subject to Use Tax $0.00
Taxable Amount $0.00
Use Tax $0.00
Final Balances Deposits/Overpayment Credit $0.00
Total Tax & Surcharge $332.66
Balance $332.66
Total Amount Due $332.66
Payment Information Bank Name REGIONS BANK
Account Number ****6001
Amount $332.66
Payment Date 14-Jun-2023
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-003-625-236
Date: 14-Jun-2023
County Taxable Sales Local Option Local Option Tax (1.00%)
Black Hawk County - 07 $4,752.34 $47.52
$4,752.34 $47.52
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.
REVN EUE
Name: CITY OF WATERLOO
Account ID: 1-07-037313
Filing Period: 31-May-2023
Date: 14-Jun-2023
Confirmation Number: 0-003-658-004
Sales and Use Return Summary
Sales Tax Gross Sales $4,588.79
Goods Consumed $0.00
Total Exemptions $0.00
Taxable Amount $4,588.79
State Sales Tax (6%) $275.33
Local Option Sales Tax $45.89
Use Tax Total Taxable Purchases $0.00
Sales Subject to Use Tax $0.00
Taxable Amount $0.00
Use Tax $0.00
Final Balances Deposits/Overpayment Credit $0.00
Total Tax & Surcharge $321.22
Balance $321.22
Total Amount Due $321.22
Payment Information Bank Name REGIONS BANK
Account Number ****6001
Amount $321.22
Payment Date 14-Jun-2023
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-003-658-004
Date: 14-Jun-2023
County Taxable Sales Local Option Local Option Tax (1.00%)
Black Hawk County- 07 $4,588.79 $45.89
$4,588.79 $45.89
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.
REV�EaNUE
Name: CITY OF WATERLOO
Account ID: 1-07-040732
Filing Period: 31-May-2023
Date: 14-Jun-2023
Confirmation Number: 0-003-715-174
Sales and Use Return Summary
Sales Tax Gross Sales $97,830.89
Goods Consumed $0.00
Total Exemptions $0.00
Taxable Amount $97,830.89
State Sales Tax (6%) $5,869.85
Local Option Sales Tax $978.31
Use Tax Total Taxable Purchases $0.00
Sales Subject to Use Tax $0.00
Taxable Amount $0.00
Use Tax $0.00
Final Balances Deposits/Overpayment Credit $0.00
Total Tax & Surcharge $6,848.16
Balance $6,848.16
Total Amount Due $6,848.16
Payment Information Bank Name REGIONS BANK
Account Number ****6001
Amount $6,848.16
Payment Date 14-Jun-2023
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-003-715-174
Date: 14-Jun-2023
County Taxable Sales Local Option Local Option Tax (1.00%)
Black Hawk County- 07 $97,830.89 $978.31
$97,830.89 $978.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.