HomeMy WebLinkAboutNovember✓ MONTHLY - FEB MAY AUG NOV
852
853
854
335
DUE DATE: 20TH
6% 1%
GATES GOLF
WARREN GOLF
SOUTH HILLS GOLF
$ 125.00 $ 21.00
$ 196.00 $ 33.00
$ 162.00 $ 27.00
SEWER/GARBAGE
336
313
732
857
855
WATER POLLUTION
YOUNG ARENA
SPORTS PLEX
$ 12,690.00
$ 25,424.00
SPORTS (REC CENTER)
$ 1,577.00
$ 8,256.00
$ 11.00
$ 2,115.00
Total Sales
2,077.00
3,271.00
2,705.00
211,504.00
$ 4,237.00
$ 263.00
$ 1,376.00
$ 2.00
GATES POOL
856
BYRNES POOL
601
LEISURE OFFICE
423,726.00
26,286.00
Total
Sales Tax
146.00
229.00
189.00
14,805.00
REGIONS BANK 29,661.00
137,606.00
190.00
0.00
0.00
0.00
1,840.00
9,632.00
13.00
Firefox https://a10-nw.city.alo/nwerp/Temp/FileStorageCache/3TDOENJX.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-00001027
Invoice Department: CC City Clerk
TREASURER, STATE OF IOWA
IOWA DEPT OF REVENUE & FINANCE
PO BOX 10412
DES MOINES, IA 50306-0412
Batch Date: 12/19/2022 Batch Number: 2023-00000719 Batch Description:
IRV WARREN MEMORIAL GOLF 11/30/2022 12/19/2022 12/19/2022 12/19/2022
1-07-025853
Check Sort Code:
Check Code:
Manual Check: Confirming EFT
Check Number:
Detail: P.O. Number C/D/FiT/A/1099 Description
Total Invoice Items:
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:
229.01
0.00
0.00
0.00
0.00
0.00
0.00
Amount/Unit Total Amount
N/Y/Y/N/N/N Conversion Item - WARREN GOLF (IMPROV) 1.0000 EA
G/L Distribution: G/L Account/Project
1.1000
1.10
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 - WARREN GOLF COURSE 1.0000 EA
PERMIT #1 07 025853
G/L Distribution: G/L Account/Project
1.10
227.9100
0.00
227.91
Expensed Unencumbered
010-37-4120 1398 ( General Fund -Leisure Services -Golf Courses Sales Tax)
2 Invoice Amount Expensed:
$229.01 Invoice Amount Unencumbered:
$0.00
227.91
0.00
$229.01
1 of 9 12/12/2022, 11:35 AM
Feb
May Aug NQM)
QTRLY REPORTING ONLY
Leisure Services - Sports & Pools
Sports
B rnes
Gates
2622
YEAR
Monthly State Sales Tax
QTRLY REPORTING ONLY
Leisure Services - Golf Courses
Re
Gates
Net Taxable Sales: 190.00
Sales Tax Collected:'. 13.30
6%11.40
1.90
Total Sales Text 13.30
Difference;
0.00
2,072.66
145.09
0.00
0.00
0.00
0.00
Total Tax Duei $ 13.30 1 $
Net Taxable Sales
Sales Tax Collected
6%
1%
Total Sales Tax
WM SERVICES
Water
Pollution
0.00
0.00
0.00
124.36
20.73
145.09
0.00
0.00
Im rov
3.97
0.28
0.24
0.04
Warren Memorial
Re Im rov
3,255.84 15.65
227.91 1.10
195.35 0.94
32.56 0.16
0.28
South Hills
Re
2,693.46
188.54
Improv
Leisure - Office
11.68
0.82
Re Im rov
0.00
0.00
161.61 0.70
26.93 0.12
227.91 1.10
0.00
Gates - Total
I $ 145.37
'GROSS SALES 2,076.63
- $. 145.09, $ 0.28.
Sewer
Garbage
Storm Wt
Young
Arena
Difference
423,725.84
29,660.81
25,423.55
4,237.26
211,504.14
14,805.29
12,690.25
2,115.04
26,286.35
1,840.04
1,577.18
262.86
29,660.81
0.00
Total Tax Duel $ 29,660.81 I
REGIONS
BANK
14,805.29 1,840.04
0.00
$ 14,805.29
0.00
$ 1,840.04
Sewer Tax
Garbage Tax
Storm Tax
8,166.07
16.75
6,622.47
0.00
0.00
188.54 0.82
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Warren Mem - Total South Hills - Total
$ 229.01 I $ 189.36
(GROSS SALES 3,271.49 (GROSS SALES 2,705.14
$ 227.91 - $ 1.10 $ 188.54 $ 0.82
0.00
Leisure - Total
0.00
$ -
GROSS SALES
$ $
0.00
SportsPlex
QTR, 857 Sports
6%
11.40
1%
1.90
Total _.
$ 13.30
.QTR 856.. Byrnes Pool
0.00
0.00
-
'.QTR: 855 Gates Pool
852 Gates
0.00
125.00
0.00
21.00
146 00
137,605.60
9,632.39
8,256.34
1,376.06
853 Warren
196.00
33.00
229.00
854 South Hills
QTR 601 - ` Leisure Office
336 Wtr Pollution
162.00
0.00
25,424.00
27.00
0.00
4,237.00
189.00
29,661.00
9,632.39
0.00
8,256.33
1,376.06
335 Wtr/Swr/Gbg
12,690.00
2,115.00
14,805.00
313 Young Arena
1,577.00
263.00
1,840.00
732 SportsPlex
8,256.00
1,376.00
9,632.00
$ 9,632.39
WATERLOO LEISURE SERVICES
SALES TAX REPORT
NOVEMBER
2022
ACTIVITY 4120 - GOLF COURSES
1398 SALES TAX
GOLF REVENUE 7% TAX COLLECTED
WARREN MEMORIAL 3,255.84 227.91
GATES 2,072.66 145.09
SOUTH HILLS 2,693.46 188.54
OFFICE 0.00 0.00
8,021.96 561.54
ACTIVITY 4125 - GOLF COURSE IMPROVEMENTS
1398 SALES TAX
GOLF REVENUE 7% TAX COLLECTED
WARREN MEMORIAL 15.65 1.10
GATES 3.97 0.28
SOUTH HILLS 11.68 0.82
OFFICE 0.00 0.00
31.30 2.19
12-5-22
Firefox https://a10-nw.city.alo/nwerp/Temp/FileStorageCache/3TDOENJX.htm
1434 - TREASURER, STATE OF 2023-00001028
IOWA
Invoice Department: CC City Clerk
TREASURER, STATE OF IOWA
IOWA DEPT OF REVENUE & FINANCE
PO BOX 10412
DES MOINES, IA 50306-0412
GATES PARK GOLF COURSE
1-07-025852
Check Sort Code:
Check Code:
Manual Check: Confirming EFT
Check Number:
Detail: P.O. Number C/D/F/T/A/1099 Description
11/30/2022 12/19/2022 12/19/2022
12/19/2022
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:
145.37
0.00
0.00
0.00
0.00
0.00
0.00
Amount/Unit Total Amount
N/Y/Y/N/N/N Conversion Item - GATES GOLF COURSE 1.0000 EA
IMPROVEMENTS
G/L Distribution: G/L Account/Project
0.2800
0.28
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 - GATES GOLF COURSE 1.0000 EA
PERMIT #1 07 025852
G/L Distribution: G/L Account/Project
Total Invoice Items: 2
0.28
145.0900
0.00
145.09
Expensed Unencumbered
010-37-4120 1398 ( General Fund -Leisure Services -Golf Courses Sales Tax)
Invoice Amount Expensed:
$145.37 Invoice Amount Unencumbered:
$0.00
145.09
0.00
$145.37
2 of 9 12/12/2022, 11:35 AM
Feb May Aug Nov
QTRLY REPORTIN NLY
Net Taxable Sales
Sales Tax Collected
6%'
1 °701,
Total Sales Tax'
Difference`!
Total Tax Due
Net Taxable Sales
Sales Tax Collected
6%
Total Sales Tax
YEAR
Monthly State Sales Tax
QTRLY REPORTING ONLY
Leisure Services - Golf Courses
Sports
B rnes
Gates
Gates
Warren Memorial
South Hills
Leisure Office
Re
Im rov
Re
Improv
Re
Im•rov
Re
Improv
--. 2,693.46
188.54
11.68
0.82
:
0.00
0.00.
3,255.84
227.91
15.65
1.10
2,072.66
145.09
3.97
0.28
190.00
13.30
11.40
1.90
13.30
0.00
0.00
0.00
0.00
0.00.
0.00
124.36
20.73
145.09
0.24
0.04
0.28
32.56
227.91
0.16
1.10
26.93
188.54
0.12
0.00
0.00
0.82
0.00
0.00
0.00 0,00 0.00; 0.00 0.00 0.00 0.00 0.00 0.00
13.30__r$L$
WM SERVICES
Water
Pollution
Gates - Total
I $ 145.37
GROSS SALES 2,076.63
$ 145.09 $ 0.28.
Sewer
Garbage
Storm Wtr
Young
Arena
423,725.84
29,660.81
Difference
25,423.55
4,237.26
211,504.14
14,805.29
12,690.25
2,115.04
26,286.35
1,840.04
1,577.18
262.86
29,660.81
0.00
Total Tax Due
$ 29,660.81
REGIONS
BANK
14,805.29 1,840.04
0.00
$ 14,805.29
0.00
$ 1,840.04
Sewer Tax
Garbage Tax
Storm Tax
8,166.07
16.75
6.622.47
WarrenMem- Total
$ 229.01
IGROSS SALES 3,271.49
$ 227.91 $ 1.10.
South Hills Total
$ 189.36
'GROSS SALES 2,705.14
$ 188.54 $ 0.82
0.00 0.00.
Leisure - Total
GROSS SALE'
$ - $
0.00
SportsPlex
QTR 857 Sports
6% .
11.40
1%
` 1.90
Total
$ 13 30:
QTR 856 Byrnes Pool
0 00
0.00
-
137,605.60
9,632.39
QTR 855 Gates Pool
852 Gates
0,00
125.00
0.00
21.00
146.00
8,256.34
1,376.06
853 Warren
196.00
33.00
229.00
854 South Hills
QTR 601 Leisure Office
336 Wtr Pollution
162.00
000
25,424.00
27 00
000
4,237 00
189.00.
-
29,661.00
9,632.39
0.00
8,256.33
1,376.06
335 Wtr/Swr/Gbg
12,690.00
2,115,00
14,805.00
313 Young Arena
1,577.00
263.00
1,840.00
732 SportsPlex
8,256.00
1,376.00
9,632.00
$ 9,632.39
WATERLOO LEISURE SERVICES
SALES TAX REPORT
NOVEMBER
2022
ACTIVITY 4120 - GOLF COURSES
1398 SALES TAX
GOLF REVENUE 7% TAX COLLECTED
WARREN MEMORIAL 3,255.84 227.91
GATES 2,072.66 145.09
SOUTH HILLS 2,693.46 188.54
OFFICE 0.00 0.00
8,021.96 561.54
ACTIVITY 4125 - GOLF COURSE IMPROVEMENTS
1398 SALES TAX
GOLF REVENUE 7% TAX COLLECTED
WARREN MEMORIAL 15.65 1.10
GATES 3.97 0.28
SOUTH HILLS 11.68 0.82
OFFICE 0.00 0.00
31.30 2.19
12-5-22
Firefox https://alo-nw.city.alo/nwerp/Temp/FileStorageCache/3TDOENJX.htm
1434 - TREASURER, STATE OF 2023-00001029
IOWA
Invoice Department: CC City Clerk
TREASURER, STATE OF IOWA
IOWA DEPT OF REVENUE & FINANCE
PO BOX 10412
DES MOINES, IA 50306-0412
SOUTH HILLS GOLF COURSE
1-07-025854
11/30/2022 12/19/2022 12/19/2022
12/19/2022
Check Sort Code: Bank Account: ACCOUNTS PAYABLE
Check Code: Invoice Terms:
Manual Check: Confirming EFT Hold Reason:
Check Number:
Detail: P.O. Number C/D/F/T/A/1099 Description
Quantity U/M
No
Gross:
Freight:
State Tax:
County Tax:
Local/City Tax:
Discount:
Retainage:
Net Amount:
189.36
0.00
0.00
0.00
0.00
0.00
0.00
Amount/Unit Total Amount
G/L Distribution:
N/Y/Y/N/N/N Conversion Item - SOUTH HILLS GOLF 1.0000 EA
(IMPROV)
G/L Account/Project
0.8200
0.82
Expensed Unencumbered
010-374125 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 1.0000 EA
PERMIT # 1 07 025854
G/L Distribution: G/L Account/Project
Total Invoice Items: 2
0.82
188.5400
0.00
188.54
Expensed Unencumbered
010-37-4120 1398 ( General Fund -Leisure Services -Golf Courses Sales Tax)
Invoice Amount Expensed:
$189.36 Invoice Amount Unencumbered:
$0.00
188.54
0.00
$189.36
3 of 9 12/12/2022, 11:35 AM
Feb May Aug (Nov
QTRLY REPORTING ONLY
Leisure Services - Sports & Pools
Sports
B rnes
Gates
YEAR
Monthly State Sales Tax
QTRLY REPORTING ONLY
Leisure Services - Golf Courses
Gates
Reg
Net Taxable Sales
Sales Tax Collected::
6%'
1°
Total Sales Tax
190.00
13.30
11.40
1.90
13.30
2,072.66
145.09
0.00
0.00
0.00
0.00
0.00
0.00
Im rov
3.97
0.28
Warren Memorial
Re mprov
3,255.84 15.65
227.91 1.10
124.36 0.24
20.73 0 04
145.09 0.28
Difference.:..
0.00 0.00 0.00
Total Tax Due $
Net Taxable Sales
Sales Tax Collected
1 %
Total Sales Tax
13.30 1 1 $
WM SERVICES
Water
Pollution
423,725.84
29,660.81
Difference
25,423.55
4,237.26
195.35
32.56
227.91
0.00 0.00
Gates - Total
$ 145.37
'GROSS SALES 2,076.63
$ 145.09 $ 0.28
Sewer
Garbage
Storm Wtr
211,504.14
14,805.29
12,690.25
2,115.04
Young
Arena
26,286.35
1,840.04
1, 577.18
262.86
29,660.81
0.00
Total Tax Due
$ 29,660.81
REGIONS
BANK
14,805.29 1,840.04
0 00
$ 14,805.29
0,00
$ 1,840.04
Sewer Tax
Garbage Tax
Storm Tax
8,166.07
16.75
6,622.47
South Hills
Reg
2,693.46
188.54
0.94
0.16
1.10
161.61
26.93
188.54
0.00 0.00
Improv
Leisure - Office
Re
11.68
0.82
0.70
0.12
0.82
0.00
0.00
0.00
Im rov
0.00
0.00
0.00
0.00
0.00
0.00 0.00
Warren Mem - Total South Hills - Total
I $ 229.01 I $ 189.36
'GROSS SALES 3,271.49 (GROSS SALES 2,705.14
$ 227.91 $ 1.10 $ 188.54 $ 0.82
SportsPlex
137,605.60
9,632.39
8,256.34
1,376.06
9,632.39
0.00
8,256.33
1,376.06
r$ 9,632.39
0.00 0.00
Leisure -Total
GROSS SALES
$ - $
0.00
6%
1%
Total
QTR
857
Sports
11.40
1.90
$ 13.30
QTR
856
Byrnes Pool
0.00
0.00
-
QTR
855
852
Gates Pool
Gates
0.00
125.00
0.00
21.00
146.00
853
Warren
196,00
33.00
229.00
854
South Hills
162.00
27.00
189.00
QTR
601
Leisure Office
0.00
0.00
-
336
Wtr Pollution
25,424.00
4,237.00
29,661.00
335
Wtr/Swr/Gbg
12,690.00
2,115.00
14,805.00
313
Young Arena
1,577.00
263.00
1,840.00
732
SportsPlex
8,256.00
1,376.00
9,632.00
WATERLOO LEISURE SERVICES
SALES TAX REPORT
NOVEMBER
2022
ACTIVITY 4120 - GOLF COURSES
1398 SALES TAX
GOLF REVENUE 7% TAX COLLECTED
WARREN MEMORIAL 3,255.84 227.91
GATES 2,072.66 145.09
SOUTH HILLS 2,693.46 188.54
OFFICE 0.00 0.00
8,021.96 561.54
ACTIVITY 4125 - GOLF COURSE IMPROVEMENTS
1398 SALES TAX
GOLF REVENUE 7% TAX COLLECTED
WARREN MEMORIAL 15.65 1.10
GATES 3.97 0.28
SOUTH HILLS 11.68 0.82
OFFICE 0.00 0.00
31.30 2.19
12-5-22
Firefox https://alo-nw.city.alo/nwerp/Temp/FileStorageCache/3TDOENJX.htm
1434 - TREASURER, STATE OF 2023-00001030
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
11/30/2022 12/19/2022 12/19/2022
12/19/2022
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:
1,840.04
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
1,840.0400 1,840.04
Expensed Unencumbered
010-37-4500 1398 ( General Fund -Leisure Services -Young Arena Sales Tax)
Invoice Amount Expensed: $1,840.04
Invoice Amount Unencumbered:
$0.00
1,840.04 0.00
$1,840.04
4 of 9
12/12/2022, 11:35 AM
Feb May Aug'
QTRLY REPORTING ONLY
Leisure Services Sports & Pools
Net Taxable Sales
Sales Tax Collected
6% 11.
1%: 1.90
Total Sales Tax 13.30
YEAR
Leisure Services - Golf
Monthly State Sales Tax
QTRLY REPORTING ONLY.
Sports
B rnes
Gates
Gates
Warren Memorial
South Hills
Leisure -Office
Re
Improv
Re
Improv
Re
Improv
Re
Improv
190.00
13.30
-
2,072.66
145.09
3.97
0.28
3,255.84
227.91
15.65
1.10
- 2,693.46
188.54
11.68
0.82
:.
0.00
0.00
0.00
0.00
0.00i'
0.00'
20.73
145.09
Difference
0.00
0.00
0.00
Total Tax Duey $ 13.30.
Net Taxable Sales
Sales Tax Collected
6%
1%
Total Sales Tax
WM SERVICES
Water
Pollution
0.00
0.24
0.04
0.28
0.00
195.35
32.56
227.91
0.00
0.94
0.16
1.10
161.61
26.93
188.54
0.00
0.00
0.70
0.12
0.82
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Gates -Total Warren Mem - Total South Hills - Total
I $ 145.37 I $ 229.01
I $ 189.36
'GROSS SALES 2,076.63 IGROSS SALES 3,271.49 'GROSS SALES 2,705 14
;.$ - 145.09, $ 0.28 $ 227.91 $ 1.10 $ 188.54 $ 0.82
Sewer
Garbage
Storm Wtr
Young
Arena
423,725.84
29,660.81
Difference
25,423,55
4,237.26
29,660.81
0.00
Total Tax Due
$ 29,660.81
REGIONS
BANK
211,504.14
14,805.29
12,690.25
2,115.04
26,286.35
1,840.04
1,577.18
262.86
14,805.29 1,840.04
0.00
$ 14,805.29
0.00
$ 1,840.04
Sewer Tax
Garbage Tax
Storm Tax
8,166.07
16.75
6,622.47
0.00
Leisure - Total
�$
0.00
GROSS SALE:
$ $
0.00
SportsPlex
QTR 857 Sports
6% ,
; 11.40
1%
1.90
Total
$ 1.3.30
QTR 856 Byrnes Pool
0.00
0.00
-
137,605.60
QTR 855 Gates Pool
0.00
0.00
9,632.39
852 Gates
125 00
21.00
146 00
8,256.34
853 Warren
196.00
33.00
229.00
1,376.06
854 South Hills
162.00
27.00
189.00
9,632.39
QTR 601 Leisure Office
`. 0.00
0.00
< -
336 Wtr Pollution
25,424.00
4,237.00
29,661.00
0.00
335 Wtr/Swr/Gbg
12,690.00
2,115.00
14,805.00
8,256.33
313 Young Arena
1,577.00
263.00
1,840.00
1,376.06
732 SportsPlex
8,256.00
1,376.00
9,632.00
12/9/2022
YOUNG ARENA
SALES TAX
010-37-4500-1398
Gross Taxable Sales November 2022 28,126.39
Net Taxable Sales November 2022 26,286.35
Total Tax November 2022 1,840.04
To: Ryan Stuber
City Clerks Office
Waterloo City Hall
From: Madonna Welsh
Leisure Services
Firefox https://alo-nw.city.alo/nwerp/Temp/FileStorageCache/3TDOENJX.htm
1434 - TREASURER, STATE OF 2023-00001031 STORMWATER+ SEWER+ 11/30/2022 12/19/2022 12/19/2022 12/19/2022 No Gross: 14,805.29
IOWA GARBAGE 1-07-030335
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: $14,805.29
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 - GARBAGE PERMIT #1 07 1.0000 EA 16.7500 16.75
030335
G/L Distribution: G/L Account/Project Expensed Unencumbered
525-15-5400 1398 ( Sanitation Fund -Waste Management -Sanitation -Solid Waste Disposal Sales Tax) 16.75 0.00
N/Y/Y/N/N/N Conversion Item - SEWER PERMIT #1 07 030335 1.0000 EA 8,166.0700 8,166.07
G/L Distribution: G/L Account/Project Expensed Unencumbered
520-14-5200 1398 ( Sanitary Sewer Fund -Waste Management -Water Pollution -Water Pollution Control Plant Op Sales 8,166.07 0.00
Tax)
N/Y/Y/N/N/N Conversion Item - STORM WATER PERMIT #1 07 1.0000 EA 6,622.4700 6,622.47
030335
G/L Distribution: G/L Account/Project Expensed Unencumbered
521-07-7830 1398 ( Storm Water Fund -City Engineer -City Engineer Sales Tax)
Total Invoice Items: 3 Invoice Amount Expensed: $14,805.29 Invoice Amount Unencumbered: $0.00
6,622.47 0.00
5 of 9 12/12/2022, 11:35 AM
Feb May Aug ( -
QTRLY REPORTING ONLY
Net Taxable Sales
Sales Tax Collected
YEAR
Monthly State Sales Tax
QTRLY REPORTING. ONLY
Sports
B roes
Gates
Gates
Warren Memorial
South Hills
Leisure - Office
Re
Im rov
Re.
Im rov
Re
Improv
Re
Im rov
190.00
13.30
-
2,072.66
145.09
3.97
0.28
- 3,255.84
227.91
15.65
1.10
2,693.46
188.54
11.68
0.82
: 0.00
0.00
6%!
11.40
1% 1.90
Total Sales Tax 13.30
Difference')
0.00
0.00
0.00
0.00
0.00
0.001i
0.00'r
0.00,
000
Total. Tax Due $ 13.30 1 $
Net Taxable Sales
Sales Tax Collected
6%
1%
Total Sales Tax
Difference
WM SERVICES
Water
Pollution
423,725.84
29,660.81
25,423.55
4,237.26
29,660.81
124.36
20.73
145.09
0.24
0.04
0.28
195.35
32.56
227.91
0.94
0.16
1.10
161.61
26.93
188.54
0.70
0.12
0.82
0.00
0.00
0.00
0.00
0.00
0.00
0.00 0.00 0.00 0.00 0.00 0.00
Gates - Total
$ 145.37
(GROSS SALES 2,076.63
$ 145.09. $ 0.28
Sewer
Garbage
Storm Wtr
Young
Arena
211,504.14
14,805.29
12,690.25
2,115.04
26,286.35
1,840.04
1,577.18
262.86
14,805.29 1,840.04
0.00
Total Tax Due
$ 29,660.81
REGIONS
BANK
0.00
$ 14,805.29
0.00
$ 1,840.04
Sewer Tax
Garbage Tax
Storm Tax
8,166.07
16.75
6,622.47
Warren Mem - Total South Hills - Total
$ 229.01 I $ 189.36
'GROSS SALES 3,271.49 (GROSS SALES 2,705.14
$ 227.91 $ 1.10 $ 188.54 $ 0.82
0.00
Leisure Total
0.00
GROSS SALES
$ - $
0.00
SportsPlex
QTR 857 Sports
6%
11.40
1%
1.90
Total
$ 13.30
QTR 856 Byrnes Pool
0.00
0.00
-
137,605.60
9,632.39
QTR 855 Gates Pool
852 Gates
0.00
125.00
0.00
21.00
146 00
8,256.34
853 Warren
196.00
33.00
229.00
1,376 06
854 South Hills
162.00
0.00
25,424.00
27.00
0.00
4,237.00
:
189.00
29,661.00
9,632.39 QTR 601 Leisure Office
336 Wtr Pollution
0.00
335 Wtr/Swr/Gbg
12,690.00
2,115.00
14,805.00
8,256.33
313 Young Arena
1,577.00
263.00
1,840.00
_..1,376.06.
732 SportsPlex
8,256.00
1,376.00
9,632.00
$ 9,632.39
RYAN STUBER
From: Annette Shepherd
Sent: Friday, December 2, 2022 9:55 AM
To: RYAN STUBER
Subject: November 2022 Sales Tax Number
Good morning
Here are your sales tax numbers for November 2022
Sewer $8,166.07
Garbage $ 16.75
Stormwaer $6,622.47
Annette Shepherd
Waterloo Water Works
(319) 232-6280
1
Firefox https://alo-nw.city.alo/nwerp/Temp/FileStorageCache/3TDOENJX.htm
1434 - TREASURER, STATE OF 2023-00001032 RECREATION CENTER 1-07-025857 11/30/2022 12/19/2022 12/19/2022
IOWA (SPORTS)
Invoice Department: CC City Clerk
TREASURER, STATE OF IOWA
IOWA DEPT OF REVENUE & FINANCE
PO BOX 10412
DES MOINES, IA 50306-0412
Check Sort Code:
Check Code:
Manual Check: Confirming EFT
Check Number:
Detail: P.O. Number C/D/F/T/A/1099 Description
12/19/2022
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:
13.30
0.00
0.00
0.00
0.00
0.00
0.00
$13.30
Amount/Unit Total Amount
N/Y/Y/N/N/N
G/L Distribution: G/L Account/Project
Total Invoice Items: 1
Conversion Item - SPORTS SALES TAX PERMIT
# 1 07 025857
1.0000 EA
13.3000
13.30
Expensed Unencumbered
010-37-4200 1398 ( General Fund -Leisure Services -Sports & Youth Services Sales Tax)
Invoice Amount Expensed: $13.30
Invoice Amount Unencumbered:
$0.00
13.30
0.00
6 of 9
12/12/2022, 11:35 AM
Feb May Aug �v
QTRLY REPORTING ONLY
Leisure Services - Sports & Pools
Sports
Net Taxable Sales 190.00
Sales Tax Collected, 13.30
6%= 1140
1% 1.90
Total Sales Tax 13.30
0.00
0.00
0.00
0.00z
0.00
0.00 f!
YEAR
Monthly State Sales Tax
QTRLY REPORTING ONLY'.
Leisure Services - Golf Courses
Gates
Warren Memorial
So th Hills
Re
2,072.66
145.09
124.36
20.73
145.09
Difference','
Total Tax Due $
Net Taxable Sales
Sales Tax Collected
6%
1%
Total Sales Tax
Difference
0.00 0.00
13.30 1 1 $
WM SERVICES
Water
Pollution
423,725.84
29,660.81
25,423.55
Sewer
Garbage
Storm Wtr
211,504.14
14,805.29
12,690.25
4,237.26 2,115.04
29,660.81
0.00
Total Tax Due
$ 29,660.81
REGIONS
BANK
0.00'il
Im rov
3.97
0.28
0.24
0.04
Re
3,255.84
227.91
195.35
32.56
Im rov
15.65
1.10
0.94
0.16
Re Improv
2,693.46 11.68
188.54 0.82
161.61 0.70
26.93 0.12
0.28 227.91 1.10 188.54 0.82
Leisure - Office
Re
0.00
0.00
0.00
Im rov
0.00
0.00
0.00;
0.00
0.00
0.00 0.00 0.00 0.00 0.00 0.00 0.00
Gates Total
$ 145.37
'GROSS SALES 2,076.63
$ 145.09. $ 0.28
Young
Arena
26,286.35
1,840.04
1,577.18
262.86
14,805.29 1,840.04
0.00
$ 14,805.29
0.00
$ 1,840.04
Sewer Tax
Garbage Tax
Storm Tax
8,166.07
16.75
6,622.47
Warren Mem - Total
$ 229.01
GROSS SALES 3,271.49
$ 227.91 $ 1.10
South Hills - Total
I $ 189.36
(GROSS SALES 2,705.14
$ 188.54. $ 0.82
Leisure - Total
0.00
GROSS SALES.
$ $
0.00
SportsPlex
QTR. 857 Sports
6%
11.40
1%
1.90
Total
$ 13.30
QTR 856 Byrnes Pool
0 00
0 00
-
137,605.60
9,632.39
QTR 855 ' Gates Pool
852 Gates
0,00
125.00
: 0:00
21 00
- -
146.00
8,256.34
853 Warren
196.00
33.00
229.00
1,376.06
854 South Hills
162.00
000
25,424.00
27.00
000
4,237 00
189.00
29,661 00
9,632.39 QTR 601 Leisure Office
336 Wtr Pollution
0.00
335 Wtr/Swr/Gbg
12,690.00
2,115.00
14,805.00
8,256.33
313 Young Arena
1,577.00
263.00
1,840.00
1,376.06
732 SportsPlex
8,256.00
1,376.00
9,632.00
SPORTS SALES TAX
010-37-4200
NOVEMBER 2022
Byrnes Pool Daily Admissions (4200-3475)
Pool Season Passes (4200-3475)
Outdoor Pool Rentals (4200-3475)
USSSA BB/58 (4200-3831)
Elks/Kiwanis/Katoski Golf (4200-3831)
Diamond Rentals (4200-3831)
Adult 8B/VB (4200-3897)
GROSS SALES TOTAL
NET SALES TOTAL
SALES TAX TOTAL
To: Ryan Stuber
City Clerks Office
Waterloo City Hall
From: Courtney Jackson
Leisure Services
GROSS SALES
NET SALES
SALES TAX
203.30
190.00
13.30
203.30
190.00
13.30
SPORTSPLEX SALES TAX
010-37-4180
NOVEMBER 2022
Facility Rentals (4180-3623)
Daily Admissions (4180-3832)
Membership Fees (4180-3835)
GROSS SALES TOTAL
NET SALES TOTAL
SALES TAX TOTAL
To: Ryan Stuber
City Clerks Office
Waterloo City Hall
From: Courtney Jackson
Leisure Services
GROSS SALES
14,598.75
5,905.01
127,387.37
147,891.12
137,605.60
9,632.39
i
NET SALES SALES TAX
13,643.69
955.06
5,491.66
118,470.25
384.42
8,292.92
Firefox https://alo-nw.city.alo/nwerp/Temp/FileStorageCache/3TDOENJX.htm
1434 - TREASURER, STATE OF 2023-00001033 SPORTSPLEX 1-07-040732
IOWA
11/30/2022 12/19/2022 12/19/2022 12/19/2022 No Gross: 9,632.39
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: $9,632.39
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 - SALES TAX PERMIT # 1.0000 EA 9,632.3900 9,632.39
1-07-040732
G/L Distribution: G/L Account/Project
Expensed Unencumbered
010-37-4180 1398 ( General Fund -Leisure Services-SportsPlex Sales Tax)
37SPLX.OPER ( CEDAR VALLEY SPORTSPLEX, SPORTSPLEX OPERATIONS)
Total Invoice Items: 1 Invoice Amount Expensed: $9,632.39 Invoice Amount Unencumbered: $0.00
9,632.39 0.00
7 of 9 12/12/2022, 11:35 AM
Feb
Net Taxable Sales
Sales Tax Collected,.
6%i
1%.
Total Sales Tax
May Aug V
QTRLY'REPORTING LY
Leisure Services - Sports & Pools
Sports
190.00
13.30
11.40
1.90
13.30
B rnes
Gates
YEAR
Monthly State Sales Tax
QTRLY REPORTING ONLY
Leisure Services - Golf Courses
Gates
Warren Memorial
0.00
0.00
0.00
Difference
0.00
0.00i,
o.00•
0.00°
0.00 0.00.
Total Tax Due $ 13.30 $
Net Taxable Sales
Sales Tax Collected
6%
1%
Total Sales Tax
WM SERVICES
Water
Pollution
423,725.84
29,660.81
Difference
25,423.55
4,237.26
Re
2,072.66
145.09
124.36
20.73
145.09
Improv
3.97
0.28
Reg Im rov
3,255.84 _. 15.65
227.91 1.10
0.24
0.04
0.28
195.35
32.56
227.91
0.00 0.00
Gates - Total
$ 145.37
IGROSS SALES 2,076.63
$ 145.09 $ 0.28
Sewer
Garbage
Storm Wtr
Young
Arena
211 ,504.14
14,805.29
12, 690.25
2,115.04
29,660.81
26,286.35
1,840.04
1,577.18
262.86
14,805.29 1,840.04
0.00
Total Tax Due
$ 29,660.81
REGIONS
BANK
0.00
$ 14,805.29
0.00
$ 1,840.04
Sewer Tax
Garbage Tax
Storm Tax
8,166.07
16.75
6,622.47
South Hills
0.94
0.16
1.10
Re
2,693.46
188.54
161.61
26.93
188.54
0.00 0.00
Improv
Leisure - Office
Re 1 Improv
11.68
0.82
0.70
0.12
0.82
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00 0.00
Warren Mem - Total South Hills - Total
$ 229.01 1 $ 189.36
'GROSS SALES 3,271.49 (GROSS SALES 2,705.14
$ 227.91 $ 1.10 $ 188.54 $ 0.82
0.00 0.00
Leisure - Total
GROSS SALE:
$ - $
0.00
SportsPlex
'..
QTR 857 Sports
6%
11.40
1%
1.90
Total
$ 13.30
QTR 856 Byrnes. Pool
0.00
0.00
-
137,605.60
9,632.39
QTR 855 Gates Pool
852 Gates
0.00
125.00
0.00
21 00
11
146.00
8,256.34
853 Warren
196.00
33.00
229.00
1,376.06
854 South Hills
162.00
0.00
25,424.00
27 00
0.00
4,237 00
189.00
29,661.00
9,632.39
QTR. 601. Leisure Office
336 Wtr Pollution
0.00
335 Wtr/Swr/Gbg
12,690.00
2,115.00
14,805.00
8,256.33
313 Young Arena
1,577.00
263.00
1,840.00
1,376.06
732 SportsPlex
8,256.00
1,376.00
9,632.00
SPORTS SALES TAX
010-37-4200
NOVEMBER 2022
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)
GROSS SALES TOTAL
NET SALES TOTAL
SALES TAX TOTAL
To: Ryan Stuber
City Clerks Office
Waterloo City Hall
From: Courtney Jackson
Leisure Services
GROSS SALES
NET SALES
SALES TAX
203.30 190.00
13.30
203.30
190.00
13.30
SPORTSPLEX SALES TAX
010-37-4180
NOVEMBER 2022
Facility Rentals (4180-3623)
Daily Admissions (4180-3832)
Membership Fees (4180-3835)
GROSS SALES TOTAL
NET SALES TOTAL
SALES TAX TOTAL
To: Ryan Stuber
City Clerks Office
Waterloo City Hall
From: Courtney Jackson
Leisure Services
GROSS SALES
NET SALES
SALES TAX
14,598.75
5,905.01 ' 5,491.66
127,387.37
13,643.69
118,470.25
955.06
384.42 -.
8,292.92
147,891.12
137,605.60
9,632.39
Firefox https://alo-nw.city.alo/nwerp/Temp/FileStorageCache/3 TDOENJX.htm
1434 - TREASURER, STATE OF 2023-00001034 WATER POLLUTION CONTROL 11/30/2022 12/19/2022 12/19/2022 12/19/2022 No Gross: 29,660.81
IOWA 1-07-030336
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: $29,660.81
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 - WATER POLLUTION 1.0000 EA
CONTROL 1-07-030336
29,660.8100 29,660.81
G/L Distribution: G/L Account/Project Expensed Unencumbered
520-14-5200 1398 ( Sanitary Sewer Fund -Waste Management -Water Pollution -Water Pollution Control Plant Op Sales 29,660.81 0.00
Tax)
Total Invoice Items: 1 Invoice Amount Expensed: $29,660.81 Invoice Amount Unencumbered: $0.00
Batch Total Invoices: 8
Batch Total Gross: $56,515.57
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: $56,515.57
Batch Total Unencumbered: $0.00
Grand Total Invoices: 8
Grand Total Gross: $56,515.57
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: $56,515.57
8 of 9 12/12/2022, 11:35 AM
Firefox
https://alo-nw.city.alo/nwerp/Temp/FileStorageCache/3 TDOENJX.htm
Grand Total Unencumbered: $0.00
9 of 9
12/12/2022, 11:35 AM
Feb May Aug
QTRLY REPORTft1G ONLY
Net Taxable Sales
Sales Tax Collected
6%i
1%,
Total Sales Tax
Difference'
Leisure Services - Sports & Pools
Sports
190.00
13.30
11.40
1.90
13.30
B rnes
0.00
0.00
0.00
0.00.
0. 001`
0.00
0.00 0.00 0.00j
Total Tax Due:$ 13.30
WM SERVICES
I Water
Pollution
Net Taxable Sales
Sales Tax Collected
6%
1%
Total Sales Tax
Difference
423,725.84
29,660.81
25,423.55
4,237.26
2 22_
YEAR
Monthly State Sales Tax
Leisure Services - Golf Courses
Gates
Re
2,072.66
145.09
124.36
20.73
145.09
In rov
3.97
0.28
0.24
0.04
Warren Memorial
South Hills
QTRLY REPORTING ONLY
Leisure - Office
Re
3,255.84
227.91
195.35
32.56
0.28
227.91
Im rov
15.65
1.10
0.94
0.16
1.10
Re Improv
2,693.46 11.68
188.54 0.82
161.61
26.93
188.54
Re Im rov
0.00
0.00
0.70
0.12
0.82
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
Gates - Total
I $ 145.37
IGROSS SALES 2,076.63
$ 145.09 - $... - 0.28
Sewer
Garbage
Storm Wtr
211,504.14
14,805.29
12,690.25
2,115.04
Young
Arena
29,660.81
26,286.35
1,840.04
1,577.18
262.86
14,805.29 1,840.04
0.00
Total Tax Due
$ 29,660.81
REGIONS
BANK
0.00
$ 14,805.29
0.00
$ 1,840.04
Sewer Tax
Garbage Tax
Storm Tax
8,166.07
16.75
6,622.47
WarrenMem - -Total: - SouthHilis - Total
$ 229.01 I $ 189.36
(GROSS SALES 3,271.49 (GROSS SALES 2,705.14 GROSS SALE:
$ 227.91 $ 1.10 $ 188.54 $ 0.82 $ $
Leisure - Total
I$
0.00
SportsPlex
QTR 857 Sports
6%
11.40
1%
1.90
Total
$ 13.30
QTR 856 Byrnes Pool
0.00
0.00
137,605.60
QTR 655 Gates Pool
0.00
. 0.00
-
9,632.39
852 Gates
125.00
21.00
146.00
8,256.34
853 Warren
196.00
33.00
229.00
1,376.06
854 South Hills
162.00
27.00
189.00
9,632.39
QTR. 601 Leisure Offce
0.00
0.00
I-
336 Wtr Pollution
25,424.00
4,237 00
29 661 00
0.00
335 Wtr/Swr/Gbg
12,690.00
2,115.00
14,805.00
8,256.33
313 Young Arena
1,577.00
263.00
1,840.00
1,376.06
732 SportsPlex
8,256.00
1,376.00
9,632.00
TAX REPORT FOR OCTOBER
WASTE MANAGEMENT SERVICES
Billing Dated 11/30/2022
Octobder 2022 Usage
NON-TAXABLE ACTIVITY
ACCT. a
COMPANY
NET BILLED
TOTAL BILLED
5452
BLACK HAWK CARE FACILITY
n/a
-
5453
BLACK HAWK COUNTY SOLID WASTE
1,123.55
n/a
1,123.55
5641
BLACK HAWK COUNTY LANDFILL PRET
236.80
n/a
236.80
14061
WATERLOO PROCESSING LLC
1,693.05
1,693.05
5644
TYSON FOODS PRET
2,002.30
n/a
2,002.30
7518
CONAGRA PRET
1,245.30
n/a
1,245.30
13109
CONAGRA
6,111.31
nla
6,111.31
6602
J.D. ENGINE WORKS
n/a
-
5840
ARAMARK UNIFORM SERVICES
n/a
-
5643
HYDRITE CHEMICAL CO. PRET
n/a
6464
DARLING INTERNATIONAL
n/a
-
5646
J.D. WESTFIELD
n/a
5845
J.D. TRACTOR WORKS
n/a
-
12488
PLANERGY
n/a
14453
VETS'S TRUCK WASH
n/a
-
10943
CANADIAN NATIONAL GROUNDWATER
n/a
-
10521
CANADIAN NATIONAL RAILWAY
n/a
-
22509
City of Evansdala
n/a
22065
COOLEY PUMPING
Ma
-
13874
J.D. PEC
Na
12935
IOWA NORTHERN RAILWAY
Na
Non-taxable
12 412.31
TAXABLE ACTIVITY
ACCT4
COMPANY
NET BILLED
TAXED APPLIED
TOTAL BILLED
5451
ARAMARK
4,834.211
338.40
5,172.68
14060
WATERLOO PROCESSING LLC
44,928.73
3,145.01
48,073.74
5456
TYSON FOODS
289,141.96
20,239.94
309,381.90
5457
JOHN DEERE - DONALD STREET
6,845.78
479.20
7,324.98
5458
JOHN DEERE • ENGINE WORKS
2,798.94
195.93
2,994.87
5452
Black Hawk Nursing & Rehab
3,534.71
247.43
3,782.14
S4S9
JOHN DEERE • FOUNDRY 8001
1,252.32
87.66
1,339.98
5460
JOHN DEERE- FOUNDRY 8002
656.32
45.94
702.26
5461
JOHN DEERE - PEC
2,184.25
152.90
2,337.15
5462
JOHN DEERE • BLDG 1020/1021
9,328.12
652.97
9,981.09
5463
JD - WESTFIELD IL JEFFERSON
8,092.38
566.47
6,658.85
12409
JOHN DEERE WSJ - BLDG A
552.02
38.64
590.66
10685
CN RAILWAY
-
-
5638
DRAIN DOCTOR
80.00
5.60
85.60
6657
CONAGRA GROCERY PRODUCTS
36,137.51
2,529.63
38,667.14
6960
HYDRITE CHEMICAL CO
3,551.07
248.57
3,799.64
7291
DARLING INTERNATIONAL
-
•
7324
BLACK HAWK WASTE
10.00
0.70
10.70
8747
LOST ISLAND METER
37.20
2.60
39.80
22671
Cedar Valley Portables
-
-
12557
A-1 SEPTIC
1,060.00
74.20
1,134.20
23461
Al Plus Septic
80.00
5.60
85.60
12313
SAVE OUR SINK
-
-
14452
VETS TRUCK WASH
7,933.60
555.35
8,488.95
13654
GROTH SERVICES
-
-
20319
PAUL COOLEY PUMPING COOLEY PUMPING
40.00
2.80
42.80
23413
Crystal Heating S Plumbing
-
20321
GREENS'S SEPTIC SERVICE
60.00
4.20
64.20
20635
22365
ACTIVE BIOMATERIALS
-
-
Roto R
60.00
4.20
64.20
21312
PLANERGY
•
-
23496
Advanced Drainage Systems (greenling)
526.65
36.87
63352.
SUBTOTAL TAXABLE
$ 423,725.84
6 29,660.81
S 453,386.65
Grand Total
S 423,725.84
S 29,660.81
S 465,798.96
Grand total of Posting
REV N U E
Name: CITY OF WATERLOO
Account ID: 1-07-025852
Filing Period: 30-Nov-2022
Date: 20-Dec-2022
Confirmation Number: 0-002-363-292
Sales and Use Return Summary
Sales Tax Gross Sales
Goods Consumed
Total Exemptions
Taxable Amount
State Sales Tax (6%)
Local Option Sales Tax
$2,076.63
$0.00
$0.00
$2,076.63
$124.60
$20.77
Total Taxable Purchases $0.00
Use Tax Sales Subject to Use Tax $0.00$0.00
Taxable Amount $0.00
Use Tax
Deposits/Overpayment Credit $0.00
Final Balances Total Tax & Surcharge $145.37$145.37
Balance $145.37
Total Amount Due
Payment Information Bank Name REGIONS BANK6001
Account Number *******6007
$145.3
Amount 20-Dec-2022
Payment Date
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.
County
Black Hawk County - 07
Confirmation Number: 0-002-363-292
20-Dec-2022
Date:
Taxable Sales Local Option
$2,076.63
$2,076.63
Local Option Tax (1.00%)
$20.77
$20.77
This is a summary only and will not be accepted as a return by the Iowa Department of Revenue. Retain this document for personal records.
KEV�ENUE
Sales and Use Return Summary
Sales Tax
Name: CITY OF WATERLOO
Account ID: 1-07-025853
Filing Period: 30-Nov-2022
Date:
Confirmation Number: 20-Dec-2022
0-002-459-352
Gross Sales
Goods Consumed
Total Exemptions
Taxable Amount
State Sales Tax (6%)
Local Option Sales Tax
Use Tax Total Taxable Purchases
Sales Subject to Use Tax $0.00
Taxable Amount $0.00
Use Tax $0.00
$0.00
$3,271.51
$0.00
$0.00
$3,271.51
$196.29
$32.72
Final Balances Deposits/Overpayment Credit
Total Tax & Surcharge $0.00
Balance $229.01
Total Amount Due $229.01
$229.01
Payment Information Bank Name
Account Number REGIONS BANK
Amount ****6001
Payment Date e229.01
20-Dec-2022
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-459-352
Date: 20-Dec-2022
Taxable Sales Local Option Local Option Tax (1.00%)
Black Hawk County - 07
$3,271.51 $32.72
$3,271.51 $32.72
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
Sales and Use Return Summa
Sales Tax
Name: CITY OF WATERLOO
Account ID: 1-07-025854
Filing Period: 30-Nov-2022
Date: 20-Dec-2022
Confirmation Number: 0-002-420-636
Gross Sales
Goods Consumed
Total Exemptions
Taxable Amount
State Sales Tax (6%)
Local Option Sales Tax
Use Tax Total Taxable Purchases
Sales Subject to Use Tax $0.00
Taxable Amount $0.00
Use Tax $0.00
$0.00
Payment Information Bank Name
Account Number REGIONS BANK
Amount ****6001
Payment Date $189.36
20-Dec-2022
$2,705.14
$0.00
$0.00
$2,705.14
$162.31
$27.05
Final Balances Deposits/Overpayment Credit
Total Tax & Surcharge $0.00
Balance $189.36
Total Amount Due $189.36
$189.36
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-420-636
Date: 20-Dec-2022
Taxable Sales Local Option Local Option Tax (1.00%)
Black Hawk County - 07
$2,705.14
$2,705.14
$27.05
$27.05
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
Sales Sales and Use Return Summa
Sales Tax
Use Tax
Final Balances
Payment Information
Name: CITY OF WATERLOO
Account ID: 1-07-025857
Filing Period: 30-Nov-2022
Date:
Confirmation Number: 20-Dec-2022
0-002-477-698
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
$190.00
$0.00
$0.00
$190.00
$11.40
$1.90
$0.00
$0.00
$0.00
$0.00
Deposits/Overpayment Credit
Total Tax & Surcharge $0.00
Balance $13.30
Total Amount Due $13.30
$13.30
Bank Name
Account Number REGIONS BANK
Amount ****6001
Payment Date $13.30
20-Dec-2022
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 O ion S les Details
County
Black Hawk County - 07
Confirmation Number: 0-002-477-698
Date: 20-Dec-2022
Taxable Sales Local Option Local Option Tax (1.00%)
$190.00
$190.00
$1.90
$1.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.
(ow; 1> r t'frn-s. of
REVENUE
Sales and Use Return Summary
Sales Tax
Use Tax
Final Balances
Payment Information
Name: CITY OF WATERLOO
Account ID: 1-07-030335
Filing Period: 30-Nov-2022
Date: 20-Dec-2022
Confirmation Number: 0-002-453-122
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
$211,504.14
$0.00
$0.00
$211,504.14
$12,690.25
$2,115.04
$0.00
$0.00
$0.00
$0.00
Deposits/Overpayment Credit
Total Tax & Surcharge $0.00
Balance $14,805.29
Total Amount Due $14,805.29
$14,805.29
Bank Name REGIONS BANK
Account Number ****6001
Amount $14,805.29
Payment Date 20-Dec-2022
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-453-122
Date: 20-Dec-2022
Taxable Sales Local Option Local Option Tax (1.00%)
Black Hawk County - 07
$211,504.14
$211,504.14
$2,115.04
$2,115.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.
R�EVEN�tU of
E
Sales and Use Return Summary
Sales Tax
Name: CITY OF WATERLOO
Account ID: 1-07-030336
Filing Period: 30-Nov-2022
Date: 20-Dec-2022
Confirmation Number: 0-002-432-642
Gross Sales
Goods Consumed
Total Exemptions
Taxable Amount
State Sales Tax (6%)
Local Option Sales Tax
Use Tax Total Taxable Purchases
Sales Subject to Use Tax $0.00
Taxable Amount $0.00
Use Tax $0.00
$0.00
Payment Information Bank Name
Account Number REGIONS BANK
Amount """6001
Payment Date $29,660.81
20-Dec-2022
$423,725.84
$0.00
$0.00
$423,725.84
$25,423.55
$4,237.26
Final Balances Deposits/Overpayment Credit
Total Tax & Surcharge $0.00
Balance $29,660.81
Total Amount Due $29,660.81
$29,660.81
This is a summary only and will not be accepted as a return by the Iowa Department of Revenue. Retain this document for personal records.
Local Option Sales Details
County
Black Hawk County - 07
Confirmation Number: 0-002-432-642
Date: 20-Dec-2022
Taxable Sales Local Option Local Option Tax (1.00%)
$423,725.84
$423,725.84
$4,237.26
$4,237.26
This is a summary only and will not be accepted as a return by the Iowa Department of Revenue. Retain this document for personal records.
RE�VEN�UE
Sales and Use Return Summary
Sales Tax
Use Tax
Final Balances
Payment Information
Name: CITY OF WATERLOO
Account ID: 1-07-037313
Filing Period: 30-Nov-2022
Date: 20-Dec-2022
Confirmation Number: 0-002-473-602
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
$26,286.35
$0.00
$0.00
$26,286.35
$1,577.18
$262.86
$0.00
$0.00
$0.00
$0.00
Deposits/Overpayment Credit $0.00
Total Tax & Surcharge $1,840.04
Balance $1,840.04
Total Amount Due $1,840.04
Bank Name REGIONS BANK
Account Number ****6001
Amount $1,840.04
Payment Date 20-Dec-2022
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-473-602
Date: 20-Dec-2022
Taxable Sales Local Option Local Option Tax (1.00%)
Black Hawk County - 07
$26,286.35
$26,286.35
$262.86
$262.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.
R`EVEN'U of
E
Sales and Use Return Summary
Sales Tax
Name: CITY OF WATERLOO
Account ID: 1-07-040732
Filing Period: 30-Nov-2022
Date: 20-Dec-2022
Confirmation Number: 0-002-373-597
Gross Sales
Goods Consumed
Total Exemptions
Taxable Amount
State Sales Tax (6%)
Local Option Sales Tax
$137,605.58
$0.00
$0.00
$137,605.58
$8,256.33
$1,376.06
Use Tax Total Taxable Purchases
Sales Subject to Use Tax $0.00
Taxable Amount $0.00
Use Tax $0.00
$0.00
Final Balances Deposits/Overpayment Credit
Total Tax & Surcharge $0.00
Balance $9,632.39
Total Amount Due $9,632.39
$9,632.39
Payment Information Bank Name REGIONS BANK
Account Number ****6001
Amount $9,632.39
Payment Date 20-Dec-2022
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-373-597
Date: 20-Dec-2022
Taxable Sales Local Option Local Option Tax (1.00%)
Black Hawk County - 07
$137,605.58
$137,605.58
$1,376.06
$1,376.06
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.
RjEVivUE
Sales and Use Return Summary
Sales Tax
Use Tax
Final Balances
Name: CITY OF WATERLOO
Account ID: 1-07-025856
Filing Period: 30-Nov-2022
Date: 20-Dec-2022
Confirmation Number: 0-002-367-388
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
Total Tax & Surcharge $0.00
Balance $0.00
Total Amount Due $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.
R EV'N
E
Sales and Use Return Summary
Sales Tax
Use Tax
Final Balances
Name: CITY OF WATERLOO
Account ID: 1-07-034601
Filing Period: 30-Nov-2022
Date: 20-Dec-2022
Confirmation Number: 0-002-463-448
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.