HomeMy WebLinkAboutJanuaryJan Apr July Oct
Net Taxable Sales
Sales Tax Collected
6%
1%
Total Sales Tax
Leisure Services - Sports & Pools
Sports
690.00
48.30
41.40
6.90
48.30
B rnes
0.00
0.00
0.00
0.00
0.00
Gales
0.00
0.00
0.00
0.00
0.00
2023
YEAR
Monthly State Sales Tax
Leisure Services - Golf Courses
Gates
Reg Im rov
0.00 0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Warren Memorial
Re
0.00
0.00
0.00
0.00
0.00
Im rov
0.00
0.00
0.00
0.00
South
Re
815.19
57.06
48.91
8.15
0.00 57.06
Hills
1 mprov
7.24
0.51
0.43
0.07
0.51
Leisure - Office
Re
0.00
0.00
0.00
0.00
0.00
Im rov
0.00
0.00
0.00
0.00
0.00
Difference 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Total Tax Duel $ 48.30 I L
Net Taxable Sales
Sales Tax Collected
6%
1%
Total Sales Tax
Difference
WM SERVICES
Water
Pollution
436,257.691
30,538.04,
26,175.46
Gates - Total
I$
IGROSS SALES
$ $
Sewer
Garbage
Storm Wtr
133,722.57
9,360.58
Young
Arena
40,959.35
2,867.15
8,023.35 2,457.56
4,362.58 1,337.23
409.59
30,538.04
9,360.58 2,867.15
Total Tax Due
0.00
$ 30,538.04,
REGIONS
BANK
0.00
$ 9,360.58
0.00
$ 2,867.15
0.00
Sewer Tax
Garbage Tax
Storm Tax
4,736.08
2.16
4,622.34
Warren Mem - Total
I$ -
IGROSS SALES0.00
$ - $ -
SportsPlex
154,991.86
10,849.43
9,299.51
1,549.92
10,849.43
0.00
9,299.51
1,549.92
$ 10,849.43
South Hills - Total
I $ 57.57
(GROSS SALES 822.43
$ 57.06 $ 0.51
Leisure - Total
I$
6%
1%
Total
QTR
857
Sports
41.40
6.90
$ 48.30
QTR
856
Byrnes Pool
0.00
0.00
-
QTR
855
Gates Pool
0.00
0.00
-
852
Gates
0.00
0.00
-
853
Warren
0.00
0.00
-
854
South Hills
49.00
8.00
57.00
QTR
601
Leisure Office
0.00
0.00
-
336
Wtr Pollution
26,175.00
4,363.00
30,538.00
335
Wtr/Swr/Gbg
8,023.00
1,337.00
9,360.00
313
Young Arena
2,458.00
410.00
2,868.00
732
SportsPlex
9,300.00
1,550.00
10,850.00
Firefox https://alo-nw.city.alo/nwerp/Temp/FileStorageCache/3TDOETLS.htm
Vendor/Remittance Address Number
Description
City of Waterloo
Accounts Payable Edit Listing
Invoice G/L Due Received Confirming
Date Date Date Date EFT G/L Date Notes
Amounts
Batch Department: CC City Clerk
1434 - TREASURER, STATE OF
IOWA
2023-00001356
Invoice Department: CC City Clerk
TREASURER, STATE OF IOWA
IOWA DEPT OF REVENUE & FINANCE
PO BOX 10412
DES MOINES, IA 50306-0412
Batch Date: 02/13/2023 Batch Number: 2023-00000965
Batch Description:
SOUTH HILLS GOLF COURSE 01/31/2023 02/13/2023 02/13/2023 02/13/2023
1-07-025854
Check Sort Code:
Check Code:
Manual Check: Confirming EFT
Check Number:
Detail: P.O. Number C/D/F/T/A/1099 Description
Bank Account: ACCOUNTS PAYABLE
Invoice Terms:
Hold Reason:
Quantity U/M
No
Gross:
Freight:
State Tax:
County Tax:
Local/City Tax:
Discount:
Retainage:
Net Amount:
57.57
0.00
0.00
0.00
0.00
0.00
0.00
Amount/Unit Total Amount
NIY/Y/N/N/N Conversion Item - SOUTH HILLS GOLF
(IMPROV)
G/L Distribution: G/L Account/Project
1.0000 EA
0.5100
0.51
Expensed Unencumbered
010-37-4125 1398 ( General Fund -Leisure Services -Golf Course Improvements Sales Tax)
37GLF.0001 ( GOLF COURSE PROJECTS, GENERAL GOLF COURSE IMPROVEMENTS)
N/Y/Y/N/N/N
G/L Distribution: G/L Account/Project
Total Invoice Items: 2
Conversion Item - SOUTH HILLS GOLF COURSE
PERMIT #1 07 025854
1.0000 EA
0.51
57.0600
0.00
57.06
Expensed Unencumbered
010-37-4120 1398 ( General Fund -Leisure Services -Golf Courses Sales Tax)
Invoice Amount Expensed: $57.57
Invoice Amount Unencumbered:
$0.00
57.06
0.00
$57.57
1 of 7 2/7/2023, 1:17 PM
WATERLOO LEISURE SERVICES
SALES TAX REPORT
JANUARY
2023
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 815.19 57.06
OFFICE 0.00 0.00
815.19 57.06
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 7.24 0.51
OFFICE 0.00 0.00
7.24 0.51
2-3-23
Firefox https://alo-nw.city.alo/nwerp/Temp/FileStorageCache/3TDOETL5.htm
1434 - TREASURER, STATE OF 2023-00001357 YOUNG ARENA 1-07-037313 01/31/2023 02/13/2023 02/13/2023 02/13/2023 No Gross: 2,867.15
IOWA
Freight: 0.00
Invoice Department: CC City Clerk Check Sort Code: Bank Account: ACCOUNTS PAYABLE State Tax: 0.00
TREASURER, STATE OF IOWA Check Code: Invoice Terms: County Tax: 0.00
IOWA DEPT OF REVENUE & FINANCE Manual Check: Confirming EFT Hold Reason: Local/City Tax: 0.00
PO BOX 10412 Check Number: Discount: 0.00
DES MOINES, IA 50306-0412 Retainage: 0.00
Net Amount: $2,867.15
Detail: P.O. Number C/D/F/T/A/1099 Description
Quantity U/M
Amount/Unit Total Amount
N/Y/Y/N/N/N Conversion Item - YOUNG ARENA PERMIT # 1 1.0000 EA
07 037313
2,867.1500 2,867.15
G/L Distribution: G/L Account/Project Expensed Unencumbered
010-37-4500 1398 ( General Fund -Leisure Services -Young Arena Sales Tax)
Total Invoice Items: 1 Invoice Amount Expensed: $2,867.15 Invoice Amount Unencumbered: $0.00
2,867.15 0.00
2 of 7 2/7/2023, 1:17 PM
2/7/2023
YOUNG ARENA
SALES TAX
010-37-4500-1398
Gross Taxable Sales January 2023 43,826.50
Net Taxable Sales January 2023 40,959.35
Total Tax January 2023 2,867.15
To: Ryan Stuber
City Clerks Office
Waterloo City Hall
From: Madonna Welsh
Leisure Services
Firefox https://alo-nw.city.alo/nwerp/Temp/FileStorageCache/3TDOETL5.htm
1434 - TREASURER, STATE OF 2023-00001358
IOWA
Invoice Department: CC City Clerk
TREASURER, STATE OF IOWA
IOWA DEPT OF REVENUE & FINANCE
PO BOX 10412
DES MOINES, IA 50306-0412
STORMWATER + SEWER +
GARBAGE 1-07-030335
Check Sort Code:
Check Code:
Manual Check: Confirming EFT
Check Number:
Detail: P.O. Number C/D/F/T/A/1099 Description
01/31/2023 02/13/2023 02/13/2023
02/13/2023
Bank Account: ACCOUNTS PAYABLE
Invoice Terms:
Hold Reason:
Quantity U/M
No
Gross:
Freight:
State Tax:
County Tax:
Local/City Tax:
Discount:
Retainage:
Net Amount:
9,360.58
0.00
0.00
0.00
0.00
0.00
0.00
Amount/Unit Total Amount
N/Y/Y/N/N/N
G/L Distribution: G/L Account/Project
Conversion Item - GARBAGE PERMIT #1 07
030335
1.0000 EA
2.1600
2.16
Expensed Unencumbered
525-15-5400 1398 ( Sanitation Fund -Waste Management -Sanitation -Solid Waste Disposal Sales Tax)
N/Y/Y/N/N/N
G/L Distribution: G/L Account/Project
Conversion Item - SEWER PERMIT #1 07 030335
1.0000 EA
2.16
4,736.0800
Expensed
0.00
4,736.08
Unencumbered
520-14-5200 1398 ( Sanitary Sewer Fund -Waste Management -Water Pollution -Water Pollution Control Plant Op Sales
Tax)
N/Y/Y/N/N/N
G/L Distribution: G/L Account/Project
Total Invoice Items: 3
Conversion Item - STORM WATER PERMIT #1 07
030335
1.0000 EA
4,736.08 0.00
4,622.3400 4,622.34
Expensed Unencumbered
521-07-7830 1398 ( Storm Water Fund -City Engineer -City Engineer Sales Tax)
Invoice Amount Expensed: $9,360.58
Invoice Amount Unencumbered:
$0.00
4,622.34
0.00
$9,360.58
3 of 7 2/7/2023, 1:17 PM
RYAN STUBER
From: Holly Sackett
Sent: Thursday, February 2, 2023 4:03 PM
To: RYAN STUBER
Cc: Annette Shepherd
Subject: Sales Tax Billed January 2023
Hi Ryan,
I'm replacing Annette here soon!
Here's the billed sales tax for January 23.
Storm water- $4,622.34
Garbage- $2.16
Sewer $4,736.08
Thanks!
golly Saud'
Residential Billing
Waterloo Water Works
325 Sycamore St
Waterloo, IA 50703
319-232-6280
1
Firefox https://alo-nw.city.alo/nwerp/Temp/FileStorageCache/3TDOETL5.htm
1434 - TREASURER, STATE OF 2023-00001361
IOWA
Invoice Department: CC City Clerk
TREASURER, STATE OF IOWA
IOWA DEPT OF REVENUE & FINANCE
PO BOX 10412
DES MOINES, IA 50306-0412
WATER POLLUTION CONTROL 01/31/2023 02/13/2023 02/13/2023
1-07-030336
Check Sort Code:
Check Code:
Manual Check: Confirming EFT
Check Number:
Detail: P.O. Number C/D/F/IYA/1099 Description
Total Invoice Items:
02/13/2023
Bank Account: ACCOUNTS PAYABLE
Invoice Terms:
Hold Reason:
Quantity U/M
No Gross: 30,538.04
Freight: 0.00
State Tax: 0.00
County Tax: 0.00
Local/City Tax: 0.00
Discount: 0.00
Retainage: 0.00
Net Amount: $30,538.04
Amount/Unit Total Amount
N/Y/Y/N/N/N
G/L Distribution: G/L Account/Project
Conversion Item - WATER POLLUTION
CONTROL 1-07-030336
1.0000 EA
30,538.0400
30,538.04
Expensed Unencumbered
520-14-5200 1398 ( Sanitary Sewer Fund -Waste Management -Water Pollution -Water Pollution Control Plant Op Sales
Tax)
Invoice Amount Expensed: $30,538.04
Invoice Amount Unencumbered:
30,538.04
$0.00
0.00
Batch Total Invoices: 6
Batch Total Gross: $53,721.07
Batch Total Freight: $0.00
Batch Total State Tax: $0.00
Batch Total County Tax: $0.00
Batch Total Local/City Tax: $0.00
Batch Total Discount: $0.00
Batch Total Retainage: $0.00
Batch Total Net: $53,721.07
Batch Total Unencumbered: $0.00
Grand Total Invoices: 6
Grand Total Gross: $53,721.07
Grand Total Freight: $0.00
Grand Total State Tax: $0.00
Grand Total County Tax: $0.00
Grand Total Local/City Tax: $0.00
Grand Total Discount: $0.00
Grand Total Retainage: $0.00
Grand Total Net: $53,721.07
6 of 7
2/7/2023, 1:17 PM
Firefox https://alo-nw.city.alo/nwerp/Temp/FileStorageCache/3TDOETL5.htm
Grand Total Unencumbered: $0.00
7 of 7
2/7/2023, 1:17 PM
TAX REPORT FOR FEBURARY
WASTE MANAGEMENT SERVICES
Billing Dated 01/03/23
DECEMBER 2022 Usage
NONTAXABLE ACTIVITY
ACCT. B
COMPANY
NET BILLED
TOTAL BILLED
5452
BLACK HAWK CARE FACILITY
Na
-
5453
BUCK HAWK COUNTY SOLID WASTE
2,108.83
Na
2,108.83
5641
BLACKHAWK COUNTY LANDFILL PRET
177.60
nle
177.60
14061
WATERLOO PROCESSING LLC
1,785.10
Na
1,765.10
5644
TYSON FOODS PRET
2,027.30
Na
2,027 30
7518
CONAGRA PRET
1,232.30
Na
1,232.30
13109
CONAGRA
5,798.47
Na
5,798.47
6602
J.D. ENGINE WORKS/annual lab fee
Na
-
5640
ARAMARK UNIFORM SERVICES/annual lab lee
Na
-
5643
HYDRITE CHEMICAL CO. PRET/annual lab fee
Na
2191
Men Indualrial Coatngs/annual lab fee
Na
-
5641
BLACK HAWK COUNTY LANDFILL PRETlannual lab fee
Na
-
6464
DARLING INTERNATIONAL/annual lab fee
Na
-
5646
J.D. WESTFIELDannuel lab fee
Na
14061
WATERLOO PROCESSING LLC/ annual lab lee
Na
-
5640
TysoNannu,l lab lee
Na
-
7518
Conagralarnoal lab fee
Na
-
20973
The Crown Grouplannual lab fee
Na
-
12486
PLANERGY
Na
14453
VETS'S TRUCK WASHItablee
Na
-
10943
CANADIAN NATIONAL GROUNDWATER
N0
10521
CANADIAN NATIONAL RAILWAY/annual lab lee
Na
22509
City of Evansdale
Na
22085
COOLEY PUMPING
Na
-
5640
Aramarldanraal lab fee
Na
-
23714
Advanced Drainage /annual lab lee
We
-
13874
J.D. PEC/annual lab fee
Na
-
12935
IOWA NORTHERN RAILWAY/annual lab fee
Na
NODNxable
13,10980
TAXABLE ACTIVITY
ACCT9
COMPANY
NET BILLED
TAXED APPLIED
TOTAL BILLED
5451
ARAMARK
5,435.67
380.50
5,816.17
14060
WATERLOO PROCESSING LLC
48,603.97
3,402.42
52,008.39
14060
TWIN CITY TANNERY CO
-
-
5438
TYSON FOODS
306,459.11
21,452.14
327,911.25
5457
JOHN DEERE • DONALD STREET
6,640.16
464.81
7,104.97
5458
JOHN DEERE • ENGINE WORKS
1,609.58
126.67
1,936.25
5452
Black Hawk Nursing 8 Rehab
3,564.51
249.52
3,814.03
5459
JOHN DEERE- FOUNDRY 8001
18.60
1.30
19.90
5460
JOHN DEERE- FOUNDRY 8002
546.06
38.22
584.28
5481
JOHN DEERE • PEG
1,322.68
106.59
1,629.27
5462
JOHN DEERE - BLDG 102011021
11,938.80
835.70
12,774.30
5463
JO • WESTFIELD 8 JEFFERSON
5,416.45
379.15
5,793.60
12409
JOHN DEERE Villa • BLDG A
814.26
57.00
871.26
10685
CN RAILWAY
-
5638
DRAIN DOCTOR
'
6657
CONAGRA GROCERY PRODUCTS
30,145.91
2,11042
32,259.33
6960
HYDRITE CHEMICAL CO
288.33
20.18
308.51
7291
DARLING INTERNATIONAL
•
•
7324
SLACK HAWK WASTE
•
•
8747
LOST ISLAND METER
37.20
2.60
39.80
22671
Cedar Valley Portables
'
12557
A.1 SEPTIC
1,560.00
109.20
1,669.20
23461
Al Plus Septic
40.00
2.80
42.80
12313
SAVE OUR SINK
•
-
14452
VET'S TRUCK WASH
8,497.24
594.81
9,092.05
13654
GROTH SERVICES
•
20319
PAUL COOLEY PUMPING COOLEY PUMPING
80.00
5.60
65.60
23413
Crystal Heating 8 Plumbing
-
•
20321
GREENS'S SEPTIC SERVICE
60.00
4.20
64.20
20635
22365
ACTIVE BIOMATERIALS
•
•
Rote Roolar
190.00
13.30
203.30
21312
PLANERGY
-
23496
Greenllne Polymer
2,584.38
180.91
2,765.27
SUBTOTAL TAXABLE
8 436,257.69
5 30,538.04
$ 066,795.73
Grand Total
$ 436,257.69
5 30,538.04
6 479,905.33
Grand total of Posting
Firefox https://alo-nw.city.alo/nwerp/Temp/FileStorageCache/3TDOETL5.htm
1434 - TREASURER, STATE OF 2023-00001359 RECREATION CENTER 1-07-025857 01/31/2023 02/13/2023 02/13/2023 02/13/2023 No Gross: 48.30
IOWA (SPORTS)
Freight: 0.00
Invoice Department: CC City Clerk Check Sort Code: Bank Account: ACCOUNTS PAYABLE State Tax: 0.00
TREASURER, STATE OF IOWA Check Code: Invoice Terms: County Tax: 0.00
IOWA DEPT OF REVENUE & FINANCE Manual Check: Confirming EFT Hold Reason: Local/City Tax: 0.00
PO BOX 10412 Check Number: Discount: 0.00
DES MOINES, IA 50306-0412 Retainage: 0.00
Net Amount: $48.30
Detail: P.O. Number C/D/F/T/A/1099 Description
Total Invoice Items:
Quantity U/M
Amount/Unit Total Amount
N/Y/Y/N/N/N Conversion Item - SPORTS SALES TAX PERMIT 1.0000 EA 48.3000 48.30
# 1 07 025857
G/L Distribution: G/L Account/Project
Expensed Unencumbered
010-37-4200 1398 ( General Fund -Leisure Services -Sports & Youth Services Sales Tax)
Invoice Amount Expensed: $48.30 Invoice Amount Unencumbered: $0.00
48.30 0.00
4 of 7 2/7/2023, 1:17 PM
SPORTS SALES TAX
010-37-4200
Jan-23
Byrnes Pool Daily Admissions (4200-3475)
Pool Season Passes (4200-3475)
Outdoor Pool Rentals (4200-3475)
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
SALES
NET SALES
SALES TAX
0.00 0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
422.65
395.00
27.65
0.00
0.00
0.00
107.00
100.00
7.00
208.65
195.00
13.65
GROSS SALES TOTAL 738.30
NET SALES TOTAL 690.00
SALES TAX TOTAL 48.30
Firefox hops://alo-nw.city.alo/nwerp/Temp/FileStorageCache/3TDOETL5.htm
1434 - TREASURER, STATE OF 2023-00001360
IOWA
Invoice Department: CC City Clerk
TREASURER, STATE OF IOWA
IOWA DEPT OF REVENUE & FINANCE
PO BOX 10412
DES MOINES, IA 50306-0412
SPORTSPLEX 1-07-040732
Check Sort Code:
Check Code:
Manual Check: Confirming EFT
Check Number:
Detail: P.O. Number C/D/F/F/A/1099 Description
01/31/2023 02/13/2023 02/13/2023
02/13/2023
Bank Account: ACCOUNTS PAYABLE
Invoice Terms:
Hold Reason:
Quantity U/M
No Gross: 10,849.43
Freight: 0.00
State Tax: 0.00
County Tax: 0.00
Local/City Tax: 0.00
Discount: 0.00
Retainage: 0.00
Net Amount: $10,849.43
Amount/Unit Total Amount
N/Y/Y/N/N/N
G/L Distribution: G/L Account/Project
Total Invoice Items: 1
Conversion Item - SALES TAX PERMIT #
1-07-040732
1.0000 EA
10,849.4300
10,849.43
Expensed Unencumbered
010-37-4180 1398 ( General Fund -Leisure Services-SportsPlex Sales Tax)
37SPLX.OPER ( CEDAR VALLEY SPORTSPLEX, SPORTSPLEX OPERATIONS)
Invoice Amount Expensed: $10,849.43
Invoice Amount Unencumbered:
$0.00
10,849.43
0.00
5 of 7 2/7/2023, 1:17 PM
SPORTSPLEX SALES TAX
010-37-4180
Jan-23
Facility Rentals (4180-3623)
Daily Admissions (4180-3832)
Membership Fees (4180-3835)
To: Ryan Stuber
City Clerks Office
Waterloo City Hall
GROSS SALES
38,218.71
NET SALES SALES TAX
35,718.42
9,861.73 9,216.57
117,760.85 110,056.87
GROSS SALES TOTAL 165,841.29
NET SALES TOTAL 154,991.86
SALES TAX TOTAL 10,849.43
From: Courtney Jackson
Leisure Services
2,500.29
645.16
7,703.98
Sales and Use Return Summa
Sales Tax
Name:
Account ID:
Filing Period:
Date:
Confirmation Number:
Gross Sales
Goods Consumed
Total Exemptions
Taxable Amount
State Sales Tax (6%)
Local Option Sales Tax
$0.00
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 $50.0
Total Tax & Surcharge $57.57
Balance $57.57
Total Amount Due
REGIONS BANK "'6001
Bank Name *
Payment Information Account Number *6001
Amount 21-Fe$57.57
Payment Date
CITY OF WATERLOO
1-07-025854
31-Jan-2023
21-Feb-2023
0-003-004-373
$822.43
$0.00
$0.00
$822.43
$49.35
$8.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
County
Confirmation Number: 0-003-004-373
Date: 21-Feb-2023
Taxable Sales Local Option Local Option Tax (1.00%)
Black Hawk County - 07
$822.43 $8.22
$822.43 $8.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.
EVENUE
Sales and Use Return Summary
Sales Tax
Name: CITY OF WATERLOO
Account ID: 1-07-025857
Filing Period: 31-Jan-2023
Date: 21-Feb-2023
Confirmation Number: 0-002-996-181
Gross Sales
Goods Consumed
Total Exemptions
Taxable Amount
State Sales Tax (6%)
Local Option Sales Tax
$690.00
$0.00
$0.00
$690.00
$41.40
$6.90
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 $48.30
Balance $48.30
Total Amount Due $48.30
Payment Information Bank Name REGIONS BANK
Account Number "*"6001
Amount $48.30
Payment Date 21-Feb-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
County
Confirmation Number: 0-002-996-181
Date: 21-Feb-2023
Taxable Sales Local Option Local Option Tax (1.00%)
Black Hawk County - 07
$690.00 $6.90
$690.00 $6.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.
Sales and Use Return Summary
Sales Tax
Use Tax
Final Balances
Payment Information
Name: CITY OF WATERLOO
Account ID: 1-07-030335
Filing Period: 31-Jan-2023
Date: 21-Feb-2023
Confirmation Number: 0-002-959-022
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
$133,722.57
$0.00
$0.00
$133,722.57
$8,023.35
$1,337.23
$0.00
$0.00
$0.00
$0.00
Deposits/Overpayment Credit $0.00
Total Tax & Surcharge $9,360.58
Balance $9,360.58
Total Amount Due $9,360.58
Bank Name REGIONS BANK
Account Number ****6001
Amount $9,360.58
Payment Date 21-Feb-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
County
Confirmation Number: 0-002-959-022
Date: 21-Feb-2023
Taxable Sales Local Option Local Option Tax (1.00%)
Black Hawk County - 07
$133,722.57
$133,722.57
$1,337.23
$1,337.23
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
Name: CITY OF WATERLOO
Account ID: 1-07-030336
Filing Period: 31-Jan-2023
Date: 21-Feb-2023
Confirmation Number: 0-003-003-763
Gross Sales
Goods Consumed
Total Exemptions
Taxable Amount
State Sales Tax (6%)
Local Option Sales Tax
$436,257.69
$0.00
$0.00
$436,257.69
$26,175.46
$4,362.58
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 $30,538.04
Balance $30,538.04
Total Amount Due $30,538.04
Payment Information Bank Name REGIONS BANK
Account Number ****6001
Amount $30,538.04
Payment Date 21-Feb-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
County
Confirmation Number: 0-003-003-763
Date: 21-Feb-2023
Taxable Sales Local Option Local Option Tax (1.00%)
Black Hawk County - 07
$436,257.69
$436,257.69
$4,362.58
$4,362.58
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.
VENUE
Sales and Use Return Summary
Sales Tax
Use Tax
Final Balances
Payment Information
Name: CITY OF WATERLOO
Account ID: 1-07-037313
Filing Period: 31-Jan-2023
Date: 21-Feb-2023
Confirmation Number: 0-002-952-563
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
$40,959.35
$0.00
$0.00
$40,959.35
$2,457.56
$409.59
$0.00
$0.00
$0.00
$0.00
Deposits/Overpayment Credit $0.00
Total Tax & Surcharge $2,867.15
Balance $2,867.15
Total Amount Due $2,867.15
Bank Name REGIONS BANK
Account Number ****6001
Amount $2,867.15
Payment Date 21-Feb-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
County
Confirmation Number: 0-002-952-563
Date: 21-Feb-2023
Taxable Sales Local Option Local Option Tax (1.00%)
Black Hawk County - 07
$40,959.35
$40,959.35
$409.59
$409.59
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.
rtrruiri k
; E N U E
Sales and Use Return Summary
Sales Tax
Use Tax
Final Balances
Payment Information
Name: CITY OF WATERLOO
Account ID: 1-07-040732
Filing Period: 31-Jan-2023
Date: 21-Feb-2023
Confirmation Number: 0-002-990-037
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
$154,991.86
$0.00
$0.00
$154,991.86
$9,299.51
$1, 549.92
$0.00
$0.00
$0.00
$0.00
Deposits/Overpayment Credit $0.00
Total Tax & Surcharge $10,849.43
Balance $10,849.43
Total Amount Due $10,849.43
Bank Name REGIONS BANK
Account Number ****6001
Amount $10,849.43
Payment Date 21-Feb-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
County
Confirmation Number: 0-002-990-037
Date: 21-Feb-2023
Taxable Sales Local Option Local Option Tax (1.00%)
Black Hawk County - 07
$154,991.86
$154,991.86
$1,549.92
$1,549.92
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.
x,
EVENUE
Sales and Use Return Summary
Sales Tax
Use Tax
Final Balances
Name: CITY OF WATERLOO
Account ID: 1-07-025856
Filing Period: 31-Jan-2023
Date: 21-Feb-2023
Confirmation Number: 0-002-987-379
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
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
Deposits/Overpayment Credit $0.00
Total Tax & Surcharge $0.00
Balance $0.00
Total Amount Due $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: CITY OF WATERLOO
Account ID: 1-07-025852
Filing Period: 31-Jan-2023
Date: 21-Feb-2023
Confirmation Number: 0-003-066-492
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
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
Deposits/Overpayment Credit $0.00
Total Tax & Surcharge $0.00
Balance $0.00
Total Amount Due $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.
ENUE
Sales and Use Return Summary
Sales Tax
Use Tax
Final Balances
Name: CITY OF WATERLOO
Account ID: 1-07-025853
Filing Period: 31-Jan-2023
Date: 21-Feb-2023
Confirmation Number: 0-002-980-526
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
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
Deposits/Overpayment Credit $0.00
Total Tax & Surcharge $0.00
Balance $0.00
Total Amount Due $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.