HomeMy WebLinkAboutFebruaryFirefox https://alo-nw.city.alo/nwerp/Temp/FileStorageCache/3TDOEX1T.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 Batch Date: 03/20/2023 Batch Number: 2023-00001085 Batch Description:
1434 - TREASURER, STATE OF 2023-00001505 SOUTH HILLS GOLF COURSE 02/28/2023 03/20/2023 03/20/2023 03/20/2023 No Gross: 436.35
IOWA 1-07-025854
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: $436.35
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 - SOUTH HILLS GOLF 1.0000 EA 4.2800 4.28
(IMPROV)
G/L Distribution: G/L Account/Project
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 Conversion Item - SOUTH HILLS GOLF COURSE
PERMIT #1 07 025854
1.0000 EA
4.28 0.00
432.0700 432.07
G/L Distribution: G/L Account/Project Expensed Unencumbered
010-37-4120 1398 ( General Fund -Leisure Services -Golf Courses Sales Tax)
Total Invoice Items: 2 Invoice Amount Expensed: $436.35 Invoice Amount Unencumbered: $0.00
432.07 0.00
1 of 8 3/8/2023, 10:22 AM
Feb May Aug Nov 2023
Monthly State Sales Tax
QTRLY REPORTING ONLY
Leisure Services - Sports & Pools
Sports
Byrnes
Gates
NEAR
QTRLY REPORTING ONLY
Leisure Services - Golf Courses
Gates
Re
Net Taxable Sales
Sales Tax Collectedl.
6%
1%
Total Sales Tax.
Difference
395.00
27.65
23.70
3.95
27.65
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00 0.00
Total Tax Due. $
Net Taxable Sales
Sales Tax Collected
6%
1%
Total Sales Tax
Difference
27.65 1 $
WM SERVICES
Water
Pollution
616,203.70
43,134.25
36,972.22
6,162.04
Improv
Warren Memorial
Reg
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00 0.00
Gates - Total
I$
IGROSS SALES 0.00
$ - $ -
Sewer
Garbage
Storm Wtr
Young
Arena
118,183.29
8,272.83
7,091.00
1,18183
29,328.04
2,052.96
1,759.68
293.28
43,134.26
8,272.83 2,052.96
-0.01
Total Tax Due
$ 43,134.25
REGIONS
BANK
0.00
$ 8,272.83
0.00
$ 2,052.96
Sewer Tax
Garbage Tax
Storm Tax
4,717.44
6.20
3,549.19
Improv
South Hills
Reg
0.00
0.00
6,172.43
432.07
0.00
0.00
0.00
370.35
61.72
432.07
0.00 0.00
!GROSS SALES
$ - $
Warren Mem - Total
I$
0.00
SportsPlex
155,986.49
10,919.05
9, 359.19
1, 559.86
10,919.05
0.00
9,359.19
1,559.86
$ 10,919.05
Improv
Leisure - Office
Reg
Im rov
61.21
4.28
3,470.56
242.94
34.11
2.39
3.67
0.61
4.28
208.23
34.71
242.94
2.05
0.34
2.39
0.00 0.00
0.00 0.00
South Hills - Total Leisure - Total
I $ 436.35
'GROSS SALES 6,233.64
$ 432.07 $ 4.28 $ 242.94 $ 2.39
I $ 245.33
6%
1%
Total
QTR
857
Sports
23.70
3.95
$ 27.65
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
374.00
62.00
436.00
QTR
601
Leisure Office
210.28
35.05
245.33
336
Wtr Pollution
36,972.00
6,162.00
43,134.00
335
Wtr/Swr/Gbg
7,091.00
1,182.00
8,273.00
313
Young Arena
1,760.00
293.00
2,053.00
732
SportsPlex
9,359.00
1,560.00
10,919.00
WATERLOO LEISURE SERVICES
SALES TAX REPORT
FEBRUARY
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 6,172.43 432.07
OFFICE 3,470.56 242.94
9,642.99 675.01
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 61.21 4.28
OFFICE 34.11 2.39
95.32 6.67
3-1-23
Firefox https://alo -nw. city.alo/nwerp/Temp/File StorageC ache/3 TDOEX 1 T.htm
1434 - TREASURER, STATE OF 2023-00001506
IOWA
Invoice Department: CC City Clerk
TREASURER, STATE OF IOWA
IOWA DEPT OF REVENUE & FINANCE
PO BOX 10412
DES MOINES, IA 50306-0412
YOUNG ARENA 1-07-037313
Check Sort Code:
Check Code:
Manual Check: Confirming EFT
Check Number:
Detail: P.O. Number C/D/F/T/A/1099 Description
02/28/2023 03/20/2023 03/20/2023
03/20/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:
2,052.96
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
Total Invoice Items: 1
Conversion Item - YOUNG ARENA PERMIT #1
07 037313
1.0000 EA
2,052.9600
2,052.96
Expensed Unencumbered
010-37-4500 1398 ( General Fund -Leisure Services -Young Arena Sales Tax)
Invoice Amount Expensed: $2,052.96
Invoice Amount Unencumbered:
$0.00
2,052.96
0.00
$2,052.96
2 of 8 3/8/2023, 10:22 AM
Feb May Aug Nov
QTRLY REPORTING ONLY
Leisure Services - Sports & Pools
Sports
Byrnes
Gates
2023
YEAR
Monthly State Sales Tax
QTRLY REPORTING ONLY
Leisure Services - Golf Courses
Gates
Warren Memorial
South Hills
Re
Net Taxable Sales.
Sales Tax Collected
6%
1%
Total Sales Tax
Difference
395.00
27.65
23.70
3.95
27.65
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Total Tax Due $ 27.65 I 1 $
Net Taxable Sales
Sales Tax Collected
6%
1%
Total Sales Tax
Difference
WM SERVICES
Water
Pollution
616,203.70
43,134.25
36,972.22
6,162.04
118,183.29
8,272.83
0.00
Young
Arena
29,328.04
2,052.96
7,091.00
1,181.83
1,759.68
293.28
43,134.26
8,272.83 2,052.96
-0.01
Total Tax Due
$ 43,134.25
REGIONS
BANK
0.00
$ 8,272.83
0.00
$ 2,052.96
0.00
Improv
Reg Im rov
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Gates - Total
�$
IGROSS SALES
$ - $
0.00
0.00
Sewer Tax
Garbage Tax
Storm Tax
4,717.44
6.20
3,549.19
0.00
Re
6,172.43
432.07
370 35
61.72
0.00
432.07
0.00
Warren Mem - Total
(GROSS SALES
$ - $
0.00
SportsPlex
155,986.49
10,919.05
9,359.19
1,559.86
10,919.05
0.00
9,359.19
1,559.86
$ 10,919.05
0.00
Improv
61.21
4.28
3.67
0.61
4.28
Leisure - Office
Reg Improv
3,470.56 34.11
242.94 2.39
208.23
34.71
242.94
2.05
0.34
2.39
0.00
0.00 0.00
South Hills - Total Leisure - Total
f $ 436.35
(GROSS SALES 6,233.64
$ 432.07 $ 4.28 $ 242.94 $ 2.39
245.33
I
6%
1%
Total
QTR
857
Sports
23.70
3.95
$ 27.65
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
374.00
62.00
436.00
QTR
601
Leisure Office
210.28
35.05
245.33
336
Wtr Pollution
36,972.00
6,162.00
43,134.00
335
Wtr/Swr/Gbg
7,091.00
1,182.00
8,273.00
313
Young Arena
1,760.00
293.00
2,053.00
732
SportsPlex
9,359.00
1,560.00
10,919.00
3/7/2023
YOUNG ARENA
SALES TAX
010-37-4500-1398
Gross Taxable Sales February 2023 31,381.00
Net Taxable Sales February 2023 29,328.04
Total Tax February 2023 2,052.96
To: Ryan Stuber
City Clerks Office
Waterloo City Hall
From: Madonna Welsh
Leisure Services
Firefox
https://alo-nw.city.alo/nwerp/Temp/FileStorageCache/3 TDOEX 1 T.htm
1434 - TREASURER, STATE OF 2023-00001507
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: Confnming EFT
Check Number:
Detail: P.O. Number C/D/F/T/A/1099 Description
02/28/2023 03/20/2023 03/20/2023
03/20/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:
8,272.83
0.00
0.00
0.00
0.00
0.00
0.00
$8,272.83
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
6.2000
6.20
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
6.20
4,717.4400
Expensed
0.00
4,717.44
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,717.44 0.00
3,549.1900 3,549.19
Expensed Unencumbered
521-07-7830 1398 ( Storm Water Fund -City Engineer -City Engineer Sales Tax)
Invoice Amount Expensed: $8,272.83
Invoice Amount Unencumbered:
$0.00
3,549.19
0.00
3 of 8
3/8/2023, I0:22 AM
Feb May Aug Nov
QTRLY REPORTING ONLY
Leisure Services - Sports & Pools
Net Taxable Sales
Sales Tax Collected
6%p 23.70
1 %lj. 3.95
Total Sales Tax27.65
Difference:'.)
0.00
2023
YEAR
Monthly State Sales Tax
QTRLY. REPORTING ONLY
Leisure Services - Golf Courses
Sports
B mes
Gates
Gates
Warren Memorial
South Hills
Leisure - Office
Re
Improv
Re
Improv
Re
Improv
Re
Improv
395.00
27.65
0.00
0.00
0.00
6,172.43
432.07
61:.21
4.28
3,470.56
242.94
34.11
2.39
0.00
0.00
0.00
0.001
0.00
0.00
0.00
0.00
0.00
Total Tax Due; $ 27.65 1 1 $
Net Taxable Sales
Sales Tax Collected
6%
1%
Total Sales Tax
Difference
WM SERVICES
Water
Pollution
616,203.70
43,134.25
36, 972.22
6,162.04
0.00
0.00
0.00
0.00
0.00
0.00
0.00 0.00 0.00
Gates - Total
IGROSS SALES
- - $ - $
I$
0.00
Sewer
Garbage
Storm Wt
Young
Arena
118,183.29
8,272.83
7,091.00
1,181.83
43,134.26
-0.01
Total Tax Due
$ 43,134.25
REGIONS
BANK
29,328.04
2,052.96
1,759.68
293.28
8,272.83 2,052.96
0.00
$ 8,272.83
0.00
$ 2,052.96
0.00
Sewer Tax
Garbage Tax
Storm Tax
4,717.44
6.20
3,549.19
0.00
0.00
0.00
0.00
370.35
61.72
432.07
0.00
Warren Mem - Total
I$ -
IGROSS SALES 0.00
$ $
3.67
0.61
4.28
0.00 0.00
South Hills - Total.
$ 436.35
'GROSS SALES 6,233.64
$ 432.07 $ 4.28
208.23
34.71
242.94
2.05
0.34
2.39
0.00 0.00
Leisure - Total
$ ;. 245.33
242.94 $
2.39
SportsPlex
QTR 857 Sports
6%
23.70
1%
3 95
Total_.
$ 27.65
QTR 856 Byrnes. Pool
0.00
0.00
-
155,986.49
10,919.05
QTR 855 Gates Pool
852 Gates
0.00
0.00
0.00
0.00
-
9,359.19
853 Warren
0.00
0.00
-
1,559.86
854 South Hills
374.00
210.28
36,972.00
62.00
35.05
6,162.00
436.00
245.33
43,134 00
10,919.05 QTR 601 Leisure Office
336 Wtr Pollution
0.00
335 Wtr/SwrfGbg
7,091.00
1,182.00
8,273.00
9,359.19.
313 Young Arena
1,760.00
293.00
2,053.00
1,559.86.
732 SportsPlex
9,359.00
1,560.00
10,919.00
10,919.05
RYAN STUBER
From: Holly Sackett
Sent: Friday, March 3, 2023 10:40 AM
To: RYAN STUBER
Subject: Billed Sales Tax February 2023
Good morning,
Here's the billed sales tax for February 2023.
Storm water-$ 3,549.19
Garbage- $6.20
Sewer- $4,717.44
Thanks!
o 4 Sackett
Systems Billing Administrator
Waterloo Water Works
325 Sycamore St
Waterloo, IA 50703
319-232-6280
1
Firefox https://alo-nw.city.alo/nwerp/Temp/FileStorageCache/3TDOEX1T.htm
1434 - TREASURER, STATE OF 2023-00001508
IOWA
Invoice Department: CC City Clerk
TREASURER, STATE OF IOWA
IOWA DEPT OF REVENUE & FINANCE
PO BOX 10412
DES MOINES, IA 50306-0412
WATERLOO LEISURE SVCS COMM 02/28/2023 03/20/2023 03/20/2023
1-07-034601
Check Sort Code:
Check Code:
Manual Check: Confirming EFT
Check Number:
Detail: P.O. Number C/D/F/T/A/1099 Description
03/20/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:
245.33
0.00
0.00
0.00
0.00
0.00
0.00
Amount/Unit Total Amount
N/Y/Y/N/N/N Conversion Item - L.S. OFFICE GOLF (IMPROV) 1.0000 EA
PERMIT #1 07 034601
G/L Distribution: G/L Account/Project
2.3900
2.39
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 Conversion Item - L.S. OFFICE PERMIT #1 07 1.0000 EA
034601
G/L Distribution: G/L Account/Project
Total Invoice Items: 2
2.39
242.9400
0.00
242.94
Expensed Unencumbered
010-37-4120 1398 ( General Fund -Leisure Services -Golf Courses Sales Tax)
Invoice Amount Expensed:
$245.33 Invoice Amount Unencumbered:
$0.00
242.94
0.00
$245.33
4 of 8 3/8/2023, 10:22 AM
Feb May Aug Nov 2023
QTRLY REPORTING ONLY
Leisure Services - Sports & Pools
Sports
B rnes
Gates
YEAR
Monthly State Sales Tax
QTRLY REPORTING ONLY
Leisure Services - Golf Courses
Re
Gates
Net Taxable Sales
Sales Tax Collected,:
395.00
27.65
6%'I
1%
Total Sales Tax,
23.70
3.95
27.65
0.00
0.00
0.00
0.00>
0.00
0.00
0.00
0.00
0.00
Difference
0.00
Im rov
Warren
Re
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00 0.00 0.00
Gates - Total
{'GROSS SALES
Total Tax Due $ 27.65 1 [$
Net Taxable Sales
Sales Tax Collected
6%
1%
Total Sales Tax
Difference
WM SERVICES
Water
Pollution
616,203.70
43,134.25
36,972.22
6,162.04
43,134.26
Sewer
Garbage
Storm Wtr
Young
Arena
118,183.29
8,272.83
7,091.00
1,181.83
29,328.04
2,052.96
1,759.68
293.28
8,272.83 2,052.96
-0.01
Total Tax Due
$ 43,134.25
REGIONS
BANK
0.00
$ 8,272.83
0.00
$ 2,052.96
0.00
I$
0.00
Sewer Tax
Garbage Tax
Storm Tax
4,717.44
6.20
3,549.19
0.00
Memorial
Im rov
0.00
0.00
0.00
0.00
0.00
South Hills
Re
6,172.43
432.07
370.35
61.72
432.07
Warren Mem - Total
I$
0.00
GROSS SALES 0.00
$ - $ -
0.00
Leisure - Office
Improv
61.21
4.28
3.67
0.61
4.28
Re
3,470.56
242.94
208.23
34.71
242.94
Im rov
34.11
2.39
2.05
0.34
2.39
0.00
South Hills - Total
I $ 436.35
'GROSS SALES 6,233.64
$ 432.07 $ 4.28
$
0 00
0.00
Leisure - Total
$ 245.33
242.94 $
2.39
SportsPlex
QTR 857 Sports
6%
23.70
1%
3.95
Total
$ 27.65.
QTR 856 Byrnes Pool
0.00
0.00
-
155,986.49
10,919.05
'.QTR 855 Gates Pool
852 Gates
0.00
0.00
0.00
0.00
9,359.19
853 Warren
0.00
0.00
-
1,559.86
854 South Hills
374.00
210.28
36,972.00
62.00
35.05
6,162.00
436.00
245.33
43,134.00
10,919.05 QTR 601 Leisure Office
336 Wtr Pollution
0.00
335 Wtr/Swr/Gbg
7,091.00
1,182.00
8,273.00
9,35919
313 Young Arena
1,760.00
293.00
2,053.00
1,559.86
732 SportsPlex
9,359.00
1,560.00
10,919.00
0,919.05
WATERLOO LEISURE SERVICES
SALES TAX REPORT
FEBRUARY
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 6,172.43 432.07
OFFICE 3,470.56 242.94
9,642.99 675.01
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 61.21 4.28
OFFICE 34.11 2.39
95.32 6.67
3-1-23
Firefox https://alo-nw.city.alo/nwerp/Temp/FileStorageCache/3TDOEX 1 T.htm
1434 - TREASURER, STATE OF 2023-00001509 RECREATION CENTER 1-07-025857 02/28/2023 03/20/2023 03/20/2023 03/20/2023 No Gross: 27.65
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 MOTIVES, IA 50306-0412 Retainage: 0.00
Net Amount: $27.65
Detail: P.O. Number C/D/FIT/A/1099 Description
Quantity U/M
Amount/Unit Total Amount
N/Y/Y/N/N/N Conversion Item - SPORTS SALES TAX PERMIT
# 1 07 025857
1.0000 EA
27.6500 27.65
G/L Distribution: G/L Account/Project Expensed Unencumbered
010-37-4200 1398 ( General Fund -Leisure Services -Sports & Youth Services Sales Tax)
Total Invoice Items: 1 Invoice Amount Expensed: $27.65 Invoice Amount Unencumbered: $0.00
27.65 0.00
5 of 8 3/8/2023, 10:22 AM
Feb May Aug Nov 2023
QTRLY REPORTING ONLY
Leisure Services - Sports & Pools
Sports
B rnes
Gates
YEAR
Gate
Monthly State Sales Tax
QTRLY REPORTING ONLY
Leisure Services - Golf Courses
Warren Memorial
Re
Net Taxable Sales 395.00
Sales Tax Collected 27.65
6% 23.70
1% 3.95
Total Sales Tax 27.65
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Im rov
Re
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Im rov
0.00
0.00
0.00
0.00
South Hills
Re Improv
6,172.43 61.21
432.07 4.28
370.35 3.67
61.72 0.61
Leisure - Office
Re
3,470.56
242.94
208.23
34.71
Im rov
34.11
2.39
2.05
0.34
0.00 432.07 4.28
242.94
2.39
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 Due $
Net Taxable Sales
Sales Tax Collected
6%
1%
Total Sales Tax
Difference
27.65 1 1 $
WM SERVICES
Water
Pollution
616,203.70
43,134.25
36,972.22
6,162.04
Sewer
Garbage
Storm Wtr
118,183.29
8,272.83
7,091.00
Gates - Total
(GROSS SALES l$
$ - $
Young
Arena
29,328.04
2,052.96
1,759.68
1,181.83 293.28
43,134.26
8,272.83 2,052.96
-0 01
Total Tax Due
$ 43,134.25
REGIONS
BANK
0.00
$ 8,272.83
0.00
$ 2,052.96
0.00
Sewer Tax
Garbage Tax
Storm Tax
4,717.44
6.20
3,549.19
Warren Mem - Total
�$ -
IGROSS SALES 0.00
$ - $
SportsPlex
155,986.49
10,919.05
9,359.19
1,559.86
10,919.05
0.00
9,359.19
1, 559.86
$ 10,919.05
South Hills - Total
I $ 436.35
IGROSS SALES 6,233.64
$ 432.07 $ 4.28
Leisure - Total
I $ 245.33
$ 242.94 $ 2.39
6°/u
1%
Total
QTR
857
Sports
23.70
3.95
$ 27.65
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
374.00
62.00
436.00
QTR
601
Leisure Office
210.28
35.05
245.33
336
Wtr Pollution
36,972.00
6,162.00
43,134.00
335
Wtr/Swr/Gbg
7,091.00
1,182.00
8,273.00
313
Young Arena
1,760.00
293.00
2,053.00
732
SportsPlex
9,359.00
1,560.00
10,919.00
SPORTS SALES TAX
010-37-4200
Feb-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
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
0.00
0.00
0.00
0.00
0.00
0.00
GROSS SALES TOTAL 422.65
NET SALES TOTAL 395.00
SALES TAX TOTAL 27.65
Firefox https://alo-nw.city.alo/nwerp/Temp/FileStorageCache/3 TDOEX 1 T.htm
1434 - TREASURER, STATE OF 2023-00001510
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/T/A/1099 Description
Total Invoice Items:
02/28/2023 03/20/2023 03/20/2023
03/20/2023
Bank Account: ACCOUNTS PAYABLE
Invoice Terms:
Hold Reason:
Quantity U/M
No Gross: 10,919.05
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,919.05
Amount/Unit Total Amount
N/Y/Y/N/N/N
G/L Distribution: G/L Account/Project
Conversion Item - SALES TAX PERMIT #
1-07-040732
1.0000 EA
10,919.0500
10,919.05
Expensed Unencumbered
010-37-4180 1398 ( General Fund -Leisure Services-SportsPlex Sales Tax)
37SPLX.OPER ( CEDAR VALLEY SPORTSPLEX, SPORTSPLEX OPERATIONS)
Invoice Amount Expensed: $10,919.05
Invoice Amount Unencumbered:
$0.00
10,919.05
0.00
6 of 8 3/8/2023, 10:22 AM
Feb May Aug Nov
QTRLY REPORTING ONLY
Leisure Services - Sports & Pools
Sorts
B mes
Gates
2023
YEAR
Monthly State Sales Tax
QTRLY REPORTING ONLY
Leisure Services - Golf Courses
Gates
Warren Memorial
South Hills
Re
Net Taxable Sales
Sales Tax Collected'
6%
1%
Total Sales Tax
Difference
395.00
27.65
23.70
3.95
27.65
0.00
0.00
0.00
0.00
0.00
0.001'
0.00
0.00
0.00
0.00
0.00
0.00
Total Tax Due $ 27.65 1 $
Net Taxable Sales
Sales Tax Collected
6%
1%
Total Sales Tax
Difference
WM SERVICES
Water
Pollution
616,203.70
43,134.25
36,972.22
6,162.04
0.00
Im rov
0.00
0.00
0.00
Re Im rov
0.00
0.00 0.00
0.00 0.00
0.00 0.00
Re
6,172.43
432.07
0.00 0.00
Gates - Total
I$
'GROSS SALES
$ - $
Sewer
Garbage
Storm Wtr
Young
Arena
118,183.29
8,272.83
7,091.00
1,181.83
29,328.04
2,052.96
1,759,68
293,28
43,134.26
8,272.83 2,052.96
-0.01
Total Tax Due
$ 43,134.25
REGIONS
BANK
0.00
$ 8,272.83
0,00
$ 2,052.96
0.00
0.00
Sewer Tax
Garbage Tax
Storm Tax
4,717.44
6.20
3,549.19
370.35
61.72
432.07
0.00 0.00
Warren Mem - Total
I$
IGROSS SALES 0.00
$ - $ -
Improv
61.21
4.28
3.67
0.61
Leisure - Office
Re Im rov
3,470.56 34.11.
242.94 2.39
208.23 2.05
34.71 0.34
4.28
242.94
2.39
0.00 0.00
South Hills - Total
I $ 436.35
IGROSS SALES 6,233.64
$ 432.07 $ 4.28
0.00
Leisure - Total
0.00
(
$ 245.33
$ 242.94 $
2.39
6%
1%
Total
SportsPlex
QTR 857 Sports
23.70
3.95
$ 27.65
QTR 856 Byrnes Pool
0.00
0.00
-
155,986.49
QTR 855 Gates Pool
0.00
0.00
-
10,919.05
852 Gates
0.00
0.00
9,359.19
853 Warren
0.00
0.00
-
1,559.86
854 South Hills
374.00
62.00
436.00
10,919.05
QTR 601 Leisure Office
210.28
35.05
245.33
336 Wtr Pollution
36,972 00
6,162.00
43,134.00
0.00
335 Wtr/Swr/Gbg
7,091.00
1,182.00
8,273.00
9,359.19
313 Young Arena
1,760.00
293.00
2,053.00
1,559.86
732 SportsPlex
9,359.00
1,560.00
10,919.00
10,919.05
SPORTSPLEX SALES TAX
010-37-4180
Feb-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
41,197.97
38,502.78
2,695.19
7,887.67
7,371.65
516.02
117,819.90
110,112.06
7,707.84
GROSS SALES TOTAL 166,905.54
NET SALES TOTAL 155,986.49
SALES TAX TOTAL 10,919.05
From: Courtney Jackson
Leisure Services
Firefox https://alo-nw.city.alo/nwerp/Temp/FileStorageCache/3TDOEX1T.htm
1434 - TREASURER, STATE OF 2023-00001511
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 02/28/2023 03/20/2023 03/20/2023
1-07-030336
Check Sort Code:
Check Code:
Manual Check: Confirming EFT
Check Number:
Detail: P.O. Number C/D/FIT/A/1099 Description
03/20/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:
43,134.25
0.00
0.00
0.00
0.00
0.00
0.00
$43,134.25
Amount/Unit Total Amount
N/Y/Y/N/N/N
G/L Distribution: G/L Account/Project
Total Invoice Items: 1
Conversion Item - WATER POLLUTION
CONTROL 1-07-030336
1.0000 EA
43,134.2500
43,134.25
Expensed Unencumbered
520-14-5200 1398 ( Sanitary Sewer Fund -Waste Management -Water Pollution -Water Pollution Control Plant Op Sales
Tax)
Invoice Amount Expensed: $43,134.25
Invoice Amount Unencumbered:
43,134.25
$0.00
Batch Total Invoices:
Batch Total Gross:
Batch Total Freight:
Batch Total State Tax:
Batch Total County Tax:
Batch Total Local/City Tax:
Batch Total Discount:
Batch Total Retainage:
Batch Total Net:
Batch Total Unencumbered:
Grand Total Invoices:
Grand Total Gross:
Grand Total Freight:
Grand Total State Tax:
Grand Total County Tax:
Grand Total Local/City Tax:
Grand Total Discount:
Grand Total Retainage:
Grand Total Net:
0.00
7
$65,088.42
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$65,088.42
$0.00
7
$65,088.42
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$65,088.42
7 of 8 3/8/2023, 10:22 AM
Firefox https://alo-nw.city.alo/nwerp/Temp/FileStorageCache/3TDOEX1 T.htm
Grand Total Unencumbered: $0.00
8 of 8
3/8/2023, 10:22 AM
Feb May Aug Nov 2023
QTRLY REPORTING ONLY
Leisure Services - Sports & Pools
Sports
B rnes
Gates
YEAR
Monthly State Sales Tax
QTRLY REPORTING ONLY
Leisure Services - Golf Courses
Gates
Warren Memorial
Re
Net Taxable Sales:.
Sales Tax Collected
395.00
27.65
6%
1%.
Total Sales Tax
23.70
3.95
27.65
0.00
0.00
0.00
Difference':.
0.00
I Total Tax Due $ 27.65. 1 1. $
Net Taxable Sales
Sales Tax Collected
6%
1%
Total Sales Tax
Difference
WM SERVICES
Water
Pollution
616,203.70
43,134.25
36, 972.22
6,162.04
Total Tax Due
43,134.26
-0.01
$ 43,134.25
0.00
0.00'i
0.00
0.00!i
0.00
0.00
0.00
0.005
0.00
Im rov
Re
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Gates - Total
Is
(GROSS SALES
$ - $ - $
Sewer
Garbage
Storm Wtr
Young
Arena
118,183.29
8,272.83
7,091.00
1,181.83
29,328.04
2,052.96
1,759.68
293.28
8,272.83 2,052.96
REGIONS
BANK
0.00
$ 8,272.83
0.00
$ 2,052.96
0.00
0.00
Im rov
0.00
0.00
South
Re
6,172.43
432.07
0.00
0.00
370.35
61.72
0.00
432.07
0.00
Warren Mem - Total
I$
0.00 IGROSS SALES
$ $
Sewer Tax
Garbage Tax
Storm Tax
4,717.44
6.20
3,549.19
0.00
0.00
Hills
Improv
61.21
4.28
3.67
0.61
4.28
Leisure - Office
Re
3,470.56
242.94
208.23
34.71
242.94
Im rov
34.11
2.39
2.05
0.34
2.39
0.00
South Hills - Total
I $ 436.35
[GROSS SALES 6,233.64
$ 432.07 $ 4.28
0.00
Leisure - Total
0.00
I $ 245.33
$ 242.94 $
2.39
6%
1%
Total
SportsPlex
QTR 857 Sports
2370
3.95
$ 27.65
QTR 856 Byrnes Pool
0.00
0.00
-
155,986.49
QTR-.855'Gates Pool
0.00
- 0.00
-
10,919.05
852 Gates
0.00
0.00
-
9,359.19
853 Warren
0.00
0.00
-
1,559.86
854 South Hills
374.00
62.00
436.00
10,919.05
QTR 601 Leisure Office
210.28
35.05
245.33
336 Wtr Pollution
36,972 00
6,162.00
43,134 00
0.00
335 Wtr/Swr/Gbg
7,091.00
1,182.00
8,273.00
9,359.19
313 Young Arena
1,760.00
293.00
2,053.00
1,559.86
732 SportsPlex
9,359.00
1,560.00
10,919,00
$ 10,919.05
TAX REPORT FOR FEBRUARY 2022
WASTE MANAGEMENT SERVICES
Billing Dated 02/24/22
JANUARY 2023 USEAGE
NON-TAXABLE ACTIVITY
ACCT. 8
COMPANY
NET BILLED
TOTAL BILLED
5452
BLACK HAWK CARE FACILITY
Na
-
5453
BLACK HAWK COUNTY SOLID WASTE
3,450.37
Na
3,450 37
5641
BLACK HAWK COUNTY LANDFILL PRET
177.60
Ws
177.60
14061
WATERLOO PROCESSING LLC
1,738.05
Na
1,738.05
5844
TYSON FOODS PRET
1,945.30
Na
1,945.30
7518
CONAGRA PRET
1,260.30
-
1,260.30
CONAGRA
5,798.47
Na
5,798.47
12488
PLANERGY
Na
10943
CANADIAN NATIONAL GROUNDWATER
Na
5641
BLACK HAWK COUNTY LANDFILL PRET-FEES/PERM
Na
-
7518
CONAGRA PRET-FEES/PERM
130.00
IVa
130.00
6602
J.D. ENGINE WORKS-FEES/PERM
Na
-
5646
J.D. WESTFIELD-FEES/PERM
Na
-
5645
J.D. TRACTOR WORKS-FEES/PERM
Na
-
14453
VETS TRUCK WASH-FEES/PERM
265.00
Na
265.00
10521
CANADIAN NATIONAL RAILWAY-FEES/PERM
Na
21969
ALLAN INDUSTRIAL COATINGS -FEES/PERM
238.25
Na
238.25
13874
J.D. PEC-FEES/PERM
205.00
Na
205.00
5640
ARAMARK UNIFORM SERVICES -FEES/PERM
367.50
Na
367.50
6464
DARLING INTERNATIONAL -FEES/PERM
385.00
Na
385.00
5643
HYDRITE-FEES/PERM
392.50
Na
392.50
12935
IOWA NORTHERN RAILWAY-FEES/PERM
28625
Na
286.25
20973
Renews Co (Crown Group)
130.00
Na
130.00
14061
watERL00 PROCESSING LLCAabfeepermd
130.00
Na
130.00
14061
WATERLOO PROCESSING LLC
Na
-
5844
TYSON FRESH MEATS INC-FEES/PERM
130.00
n/a
130.00
12935
IOWA NORTHERN RAILWAY
Ne
-
22509
EVANSDALE
nra
'
5456
TYSON FRESH MEATS Crest
(100,000.00)
Na
(100,000.00)
(82,970A1)
0.00
(82,970AI)
TAXABLE ACTIVITY
ACCT#
COMPANY
TAXED APPLIED
TOTAL BILLED
5451
ARAMARK
5,803.73
406.26
6,209.99
14080
WATERLOO PROCESSING LLC
45,470.87
3,182.95
45,653.83
5456
TYSON FOODS
469,363.02
32,855.41
502,218.43
5457
JOHN DEERE • DONALD STREET
6,555.06
465.85
7,120.91
5458
JOHN DEERE • ENGINE WORKS
1,440.06
100.80
1,540.88
5459
JOHN DEERE - FOUNDRY 8001
805.66
42.40
648.06
5460
JOHN DEERE. FOUNDRY 8002
-
'
5461
JOHN DEERE -PEC
1,753.68
122.76
1,878.44
5462
JOHN DEERE • BLDG 1020/1021
13,714.68
960.03
14,874.71
5463
JD • WESTFIELD 8 JEFFERSON
7,877.55
551.43
8,428.98
12409
JOHN DEERE WSJ - BLDG A
1,907.92
133.55
2,041.47
5638
DRAIN DOCTOR
•
'
22538
NUTRI JECT SYSTEMS
•
'
5951
KAYSER PLUMBING
•
'
6657
CONAGRA GROCERY PRODUCTS
37,477.21
2,623.40
40,100.81
6960
NYDRITE CHEMICAL CO
1,090.23
78.32
1,166.55
7291
DARLING INTERNATIONAL
-
7324
BLACK HAWK WASTE
•
.
8747
LOST ISLAND METER
37.20
2.60
39.80
12557
A.1 SEPTIC
1,380.00
96.60
1,476.60
11070
CLEANTRAP SERVICES
22365
ROTO ROOTER
140.00
9.80
149.80
14452
VETS TRUCK WASH
11,373.54
796.15
12,169.69
5452
Black Hawk Nursing 5 Rehab
3,512.19
252.85
3,885.04
22671
CEDAR VALLEY PORTABLES
'
20319
PAUL COOLEY PUMPING COOLEY PUMPING
80.00
5.60
85.60
20321
GREENS'S SEPTIC SERVICE
60
4.20
84.20
23496
Advanced Draingage
6,321.10
442.48
6,763.58
23461
A Plus Septic
40.00
2.80
42.80
SUBTOTAL TAXABLE
$ 616,203.70
$ 43,134.25
$ 659,337.95
(.,, . V[le(i{RNLt+1
Grand Total
��pq�
5Q�.+lyaraJ $ 43,134.85
$ 576,367.54
Grand total of Postng 5 576,367.54
Grand total of Pooling
REVaNUyt
Sales and Use Return Summary
Sales Tax
Use Tax
Final Balances
Name: CITY OF WATERLOO
Account ID: 1-07-025852
Filing Period: 28-Feb-2023
Date: 21-Mar-2023
Confirmation Number: 0-003-205-614
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.
jit
Sales and Use Return Summary
Sales Tax
Use Tax
Final Balances
Name: CITY OF WATERLOO
Account ID: 1-07-025853
Filing Period: 28-Feb-2023
Date: 21-Mar-2023
Confirmation Number: 0-003-125-330
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.
Iowa V NUDe artment of
REE
Sales and Use Return Summary
Sales Tax
Name: CITY OF WATERLOO
Account ID: 1-07-025854
Filing Period: 28-Feb-2023
Date: 21-Mar-2023
Confirmation Number: 0-003-131-474
Gross Sales
Goods Consumed
Total Exemptions
Taxable Amount
State Sales Tax (6%)
Local Option Sales Tax
$6,233.55
$0.00
$0.00
$6,233.55
$374.01
$62.34
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 $436.35
Balance $436.35
Total Amount Due $436.35
Payment Information Bank Name REGIONS BANK
Account Number ****6001
Amount $436.35
Payment Date 21-Mar-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-131-474
Date: 21-Mar-2023
Taxable Sales Local Option Local Option Tax (1.00%)
Black Hawk County - 07
$6,233.55 $62.34
$6,233.55 $62.34
This is a summary only and will not be accepted as a retum by the Iowa Department of Revenue. Retain this document for personal records.
REVgaNUit
Sales and Use Return Summary
Sales Tax
Use Tax
Final Balances
Name: CITY OF WATERLOO
Account ID: 1-07-025856
Filing Period: 28-Feb-2023
Date: 21-Mar-2023
Confirmation Number: 0-003-123-282
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.
it
f
REVeiaNUE
Sales and Use Return Summary
Sales Tax
Name: CITY OF WATERLOO
Account ID: 1-07-025857
Filing Period: 28-Feb-2023
Date: 21-Mar-2023
Confirmation Number: 0-003-196-398
Gross Sales
Goods Consumed
Total Exemptions
Taxable Amount
State Sales Tax (6%)
Local Option Sales Tax
$395.00
$0.00
$0.00
$395.00
$23.70
$3.95
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 $27.65
Balance $27.65
Total Amount Due $27.65
Payment Information Bank Name REGIONS BANK
Account Number ****6001
Amount $27.65
Payment Date 21-Mar-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-196-398
Date: 21-Mar-2023
County
Taxable Sales Local Option Local Option Tax (1.00%)
Black Hawk County - 07
$395.00 $3.95
$395.00 $3.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.
14EVegaNUit
Sales and Use Return Summary
Sales Tax
Use Tax
Final Balances
Payment Information
Name: CITY OF WATERLOO
Account ID: 1-07-030335
Filing Period: 28-Feb-2023
Date: 21-Mar-2023
Confirmation Number: 0-003-188-206
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
$118,183.29
$0.00
$0.00
$118,183.29
$7,091.00
$1,181.83
$0.00
$0.00
$0.00
$0.00
Deposits/Overpayment Credit $0.00
Total Tax & Surcharge $8,272.83
Balance $8,272.83
Total Amount Due $8,272.83
Bank Name REGIONS BANK
Account Number ****6001
Amount $8,272.83
Payment Date 21-Mar-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-188-206
Date: 21-Mar-2023
Taxable Sales Local Option Local Option Tax (1.00%)
Black Hawk County - 07
$118,183.29
$118,183.29
$1,181.83
$1,181.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.
jut
Sales and Use Return Summary
Sales Tax
Use Tax
Final Balances
Payment Information
Name: CITY OF WATERLOO
Account ID: 1-07-030336
Filing Period: 28-Feb-2023
Date: 21-Mar-2023
Confirmation Number: 0-003-167-726
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
$616,203.50
$0.00
$0.00
$616,203.50
$36,972.21
$6,162.04
$0.00
$0.00
$0.00
$0.00
Deposits/Overpayment Credit $0.00
Total Tax & Surcharge $43,134.25
Balance $43,134.25
Total Amount Due $43,134.25
Bank Name REGIONS BANK
Account Number ****6001
Amount $43,134.25
Payment Date 21-Mar-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-167-726
Date: 21-Mar-2023
Taxable Sales Local Option Local Option Tax (1.00%)
Black Hawk County - 07
$616,203.50
$616,203.50
$6,162.04
$6,162.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.
RIEVeiaNUE
Sales and Use Return Summary
Sales Tax
Use Tax
Final Balances
Payment Information
Name: CITY OF WATERLOO
Account ID: 1-07-034601
Filing Period: 28-Feb-2023
Date: 21-Mar-2023
Confirmation Number: 0-003-148-824
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
$3,504.67
$0.00
$0.00
$3,504.67
$210.28
$35.05
$0.00
$0.00
$0.00
$0.00
Deposits/Overpayment Credit $0.00
Total Tax & Surcharge $245.33
Balance $245.33
Total Amount Due $245.33
Bank Name REGIONS BANK
Account Number ****6001
Amount $245.33
Payment Date 21-Mar-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-148-824
Date: 21-Mar-2023
Taxable Sales Local Option Local Option Tax (1.00%)
Black Hawk County - 07
$3,504.67 $35.05
$3,504.67 $35.05
This is a summary only and will not be accepted as a retum by the Iowa Department of Revenue. Retain this document for personal records.
FiEVegaNUE
Sales and Use Return Summary
Sales Tax
Name: CITY OF WATERLOO
Account ID: 1-07-037313
Filing Period: 28-Feb-2023
Date: 21-Mar-2023
Confirmation Number: 0-003-089-490
Gross Sales
Goods Consumed
Total Exemptions
Taxable Amount
State Sales Tax (6%)
Local Option Sales Tax
$29,328.04
$0.00
$0.00
$29,328.04
$1, 759.68
$293.28
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 $2,052.96
Balance $2,052.96
Total Amount Due $2,052.96
Payment Information Bank Name REGIONS BANK
Account Number ****6001
Amount $2,052.96
Payment Date 21-Mar-2023
This is a summary only and will not be accepted as a retum by the Iowa Department of Revenue. Retain this document for personal records.
Local Option Sales Details
County
Confirmation Number: 0-003-089-490
Date: 21-Mar-2023
Taxable Sales Local Option Local Option Tax (1.00%)
Black Hawk County - 07
$29,328.04
$29,328.04
$293.28
$293.28
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.
FiEVegaraj
E
Sales and Use Return Summary
Sales Tax
Name: CITY OF WATERLOO
Account ID: 1-07-040732
Filing Period: 28-Feb-2023
Date: 21-Mar-2023
Confirmation Number: 0-003-146-264
Gross Sales
Goods Consumed
Total Exemptions
Taxable Amount
State Sales Tax (6%)
Local Option Sales Tax
$155,986.49
$0.00
$0.00
$155,986.49
$9,359.19
$1,559.86
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 $10,919.05
Balance $10,919.05
Total Amount Due $10,919.05
Payment Information Bank Name REGIONS BANK
Account Number ****6001
Amount $10,919.05
Payment Date 21-Mar-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-146-264
Date: 21-Mar-2023
Taxable Sales Local Option Local Option Tax (1.00%)
Black Hawk County - 07
$155,986.49
$155,986.49
$1,559.86
$1,559.86
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.