HomeMy WebLinkAboutDecember❖ QUARTERLY lst 2nd 3rd 4th Quarter DUE DATE: 30th
6% 1%
601
335
336
LEISURE - OFFICE
SEWER/GARBAGE
WATER POLLUTION
$ 216.00
25,743.00
28,437.00
$ 36.00
4,291.00
4,740.00
313
YOUNG ARENA
4,676.00
779.00
852 GATES GOLF
853
854
855
856
857
732
WARREN GOLF
238.00
40.00
SOUTH HILLS GOLF
1,268.00
211.00
APR JULY OCT JAN
Total Sales YEAR
$ 3,598.00
789,187.00
1,356,008.00 REGIONS BANK
116,140.00
ZERO
14,529.00
25,888.00
42,882.00
GATES POOL
BYRNES POOL
SPORTS (REC CENTER)
SPORTS PLEX
74.00
7,283.00
12.00
1,214.00
ZERO 0.00
ZERO 0.00
5,868.00
351,201.00
Deposits This Quarter:
LEISURE - OFFICE
$ -
SEWER/GARBAGE
25,209.00
WATER POLLUTION
61,744.00
YOUNG ARENA
2,675.00
GATES GOLF
1,017.00
WARREN GOLF
1,535.00
SOUTH HILLS GOLF
1,523.00
GATES POOL
-
BYRNES POOL
-
SPORTS (REC CENTER)
-
SPORTS PLEX
16,088.00
TOTAL
SALES TAX
TOTAL
CHECK AMOUNT
252.00
251.86
30,034.00
30,034.04
33,177.00
33,176.83
5,455.00
5,455.04
-
0.00
278.00
277.39
1,479.00
1,479.16
-
0.00
0.00
86.00
86.45
8,497.00
8,496.54
Mar June Sept Dec
Net Taxable Sales
Sales Tax Collected
6%
1%
Total Sales Tax
Difference
Leisure Services - Sports & Pools
2oZZ
YEAR
Monthly State Sales Tax
QTRLY REPORTING ONLY
Leisure Services - Golf Courses
Sorts
B rnes
Gates
Gates
Warren Memorial
South Hills
Leisure - Office
Re.
Im.rov
Re.
Im.rov
Re.
Improv
Reg 1 1 Improv
1,235.00
86.45
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
3,916.82
274.18,
45.79
3.21
20,913.32
1,463.93
217.52 3,549.07 39.72
15.23 248.43 2.78
12.35
86.45
0.00
Total Tax Due
$
86.45
Net Taxable Sales
Sales Tax Collected
6%
1%
Total Sales Tax
Difference
WM SERVICES
Water
Pollution
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
Sewer
Garbage
Storm Wtr
0.00
0.00
Gates - Total
Young
Arena
473,954.88
33,176.83
28,437.29
4,739.55
33,176.84
-0.01
Total Tax Due
$ 33,176.83
REGIONS
BANK
429,057.71
30,034.04
25,743.46
4,290.58
77,929.16
5,455.04
4,675.75
779.29
30,034.04 5,455.04
$ 30,034.04
0.00
$ 5,455.04
Sewer Tax
Garbage Tax
Storm Tax
0.00
15,272,81
317.31
14,443.92
235.01
39.17
274.18
0.00
Warren Mem - Total
2.75
0.46
3.21
0.00
$ 277.39
1,254.80
209.13
1,463.93
0.00
13.05
2.18
15.23
South Hills - Total
0.00
$ 1,479.16
31 GROSS SALES
212.94
35.49
248.43
2.38
0.40
2.78
0.00
Leisure - Total
I $ 251.21
$ 274.18 $ 3.21 $ 1,463.93 $ 15.23 $ 248.43 S 2.78
SportsPlex I
121,379.16
8,496.54
7,282.75
1,213.79
8,496.54
7,282.75
1,213.79
$ 8,496.54
1 6% 1
1%
Total
QTR
857
Sports 74.00
12.00
$ 86.00
QTR
856
Byrnes Pool
0.00
0.00
-
QTR
855
Gates Pool
0.00
0.00
-
852
Gates
0.00
0.00
-
853
Warren
238.00
40.00
278.00
854
South Hills
1,268.00
211.00
1,479.00
QTR
601
Leisure Office
215.00
36.00
251.00
336
Wtr Pollution
28,437.00
4,740 00
33,177.00
335
Wtr/Swr/Gbg
25,743.00
4,291.00
30,034.00
313
Young Arena
4,676.00
779.00
5,455.00
732
SportsPlex
7,283.00
1,214.00
8,497.00
Firefox https://alo-nw.city.alo/nwerp/Temp/FileStorageCache/3TDOER12.htm
Vendor/Remittance Address Number
City of Waterloo
Accounts Payable Edit Listing
Description
Invoice G/L
Date Date
Due Received Confirming
Date Date EFT G/L Date Notes
Amounts
Batch Department: CC City Clerk
1434 - TREASURER, STATE OF
IOWA
2023-00001244
Invoice Department: CC City Clerk
TREASURER, STATE OF IOWA
IOWA DEPT OF REVENUE & FINANCE
PO BOX 10412
DES MOINES, IA 50306-0412
Batch Date: 01/23/2023 Batch Number: 2023-00000861
Batch Description:
IRV WARREN MEMORIAL GOLF 12/31/2022 01/23/2023 01/23/2023 01/23/2023
1-07-025853
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:
277.39
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 - WARREN GOLF (IMPROV)
1.0000 EA
3.2100
3.21
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 - WARREN GOLF COURSE
PERMIT # 1 07 025853
1.0000 EA
3.21
274.1800
0.00
274.18
Expensed Unencumbered
010-37-4120 1398 ( General Fund -Leisure Services -Golf Courses Sales Tax)
Invoice Amount Expensed: $277.39
Invoice Amount Unencumbered:
274.18
$0.00
0.00
$277.39
1 of 9 1/17/2023, 1:24 PM
WATERLOO LEISURE SERVICES
SALES TAX REPORT
DECEMBER
2022
ACTIVITY 4120 - GOLF COURSES
1398 SALES TAX
GOLF REVENUE 7% TAX COLLECTED
WARREN MEMORIAL 3,916.82 274.18
GATES 0.00 0.00
SOUTH HILLS 20,913.32 1,463.93
OFFICE 3,549.07 248.43
28, 379.21 1,986.54
ACTIVITY 4125 - GOLF COURSE IMPROVEMENTS
1398 SALES TAX
GOLF REVENUE 7% TAX COLLECTED
WARREN MEMORIAL 45.79 3.21
GATES 0.00 0.00
SOUTH HILLS 217.52 15.23
OFFICE 39.72 2.78
303.03 21.21
1-4-23
Firefox https://alo-nw.city.alo/nwerp/Temp/FileStorageCache/3TDOER12.htm
1434 - TREASURER, STATE OF 2023-00001245
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
Check Sort Code:
Check Code:
Manual Check: Confirming EFT
Check Number:
Detail: P.O. Number C/D/F/T/A/1099 Description
12/31/2022 01/232023 01/23/2023
01/23/2023 No
Bank Account: ACCOUNTS PAYABLE
Invoice Terms:
Hold Reason:
Quantity U/M
Gross:
Freight:
State Tax:
County Tax:
Local/City Tax:
Discount:
Retainage:
Net Amount:
1,479.16
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
15.2300
15.23
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 1.0000 EA
PERMIT #1 07 025854
G/L Distribution: G/L Account/Project
Total Invoice Items: 2
15.23
0.00
1,463.9300 1,463.93
Expensed Unencumbered
010-37-4120 1398 ( General Fund -Leisure Services -Golf Courses Sales Tax)
Invoice Amount Expensed:
$1,479.16 Invoice Amount Unencumbered:
$0.00
1,463.93
0.00
$1,479.16
2 of 1/17/2023, 1:24 PM
WATERLOO LEISURE SERVICES
SALES TAX REPORT
DECEMBER
2022
ACTIVITY 4120 - GOLF COURSES
1398 SALES TAX
GOLF REVENUE 7% TAX COLLECTED
WARREN MEMORIAL 3,916.82 274.18
GATES 0.00 0.00
SOUTH HILLS 20,913.32 1,463.93
OFFICE 3,549.07 248.43
28,379.21 1,986.54
ACTIVITY 4125 - GOLF COURSE IMPROVEMENTS
1398 SALES TAX
GOLF REVENUE 7% TAX COLLECTED
WARREN MEMORIAL 45.79 3.21
GATES 0.00 0.00
SOUTH HILLS 217.52 15.23
OFFICE 39.72 2.78
303.03 21.21
1-4-23
Firefox https://alo-nw.city.alo/nwerp/Temp/FileStorageCache/3TDOER12.htm
1434 - TREASURER, STATE OF 2023-00001246
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
12/31/2022 01/23/2023 01/23/2023
01/23/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:
5,455.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
5,455.0400
5,455.04
Expensed Unencumbered
010-37-4500 1398 ( General Fund -Leisure Services -Young Arena Sales Tax)
Invoice Amount Expensed: $5,455.04
Invoice Amount Unencumbered:
$0.00
5,455.04
0.00
$5,455.04
3 of 9 1/17/2023, 1:24 PM
1/11/2023
YOUNG ARENA
SALES TAX
010-37-4500-1398
Gross Taxable Sales December 2022 83,384.20
Net Taxable Sales December 2022 77,929.16
Total Tax December 2022 5,455.04
To: Ryan Stuber
City Clerks Office
Waterloo City Hall
From Madonna Welsh
Leisure Services
Firefox https://alo-nw.city.alo/nwerp/Temp/FileStorageCache/3TDOER12.htm
1434 - TREASURER, STATE OF 2023-00001247
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/F/A/I099 Description
12/31/2022 01/23/2023 01232023
01/23/2023
Bank Account: ACCOUNTS PAYABLE
Invoice Terms:
Hold Reason:
Quantity U/M
No Gross: 30,034.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,034.04
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
317.3100
317.31
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
317.31
15,272.8100
Expensed
0.00
15,272.81
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
15,272.81 0.00
14,443.9200 14,443.92
Expensed Unencumbered
521-07-7830 1398 ( Storm Water Fund -City Engineer -City Engineer Sales Tax)
Invoice Amount Expensed: $30,034.04
Invoice Amount Unencumbered:
$0.00
14,443.92
0.00
4 of 9 1/17/2023, 1:24 PM
RYAN STUBER
From: Annette Shepherd
Sent: Thursday, January 5, 2023 2:48 PM
To: RYAN STUBER
Subject: Sales Tax December 2022
Sales Tax December 2022
Sewer $15,272.81
Garbage $ 317.31
Stormwater $14,443.92
From: RYAN STUBER <RYAN.STUBER@WATERLOO-IA.ORG>
Sent: Thursday, January 5, 2023 1:26 PM
To: Annette Shepherd <Annette.Shepherd@WATERLOO-IA.ORG>; Julianna Henrich <Jul!anna.Henr!ch@WATERLOO-
IA.ORG>
Subject:...
Hello,
Just a reminder to send in sales tax reports as soon as possible for last month. Thanks!
Ryan Stuber
Cierk 11
715 Mulberry St.
CITY OF WATERLOO
319-291-4323
319-291-4571
CITY O
j4iTERLOO
Id WA
t
Firefox https://alo-nw.city.alo/nwerp/Temp/FileStorageCache/3TDOER12.htm
1434 - TREASURER, STATE OF 2023-00001248
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 12/31/2022 01/23/2023 01/23/2023
1-07-034601
01/23/2023
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:
251.21
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.7800
2.78
Expensed Unencumbered
010-37-4125 1398 ( General Fund -Leisure Services -Golf Course Improvements Sales Tax)
37GLF.000I ( GOLF COURSE PROJECTS, GENERAL GOLF COURSE IMPROVEMENTS)
N/Y/Y/N/N/N Conversion Item - L.S. OFFICE PERMIT #1 07
034601
G/L Distribution: G/L Account/Project
Total Invoice Items: 2
1.0000 EA
2.78
248.4300
0.00
248.43
Expensed Unencumbered
010-37-4120 1398 ( General Fund -Leisure Services -Golf Courses Sales Tax)
Invoice Amount Expensed:
$251.21 invoice Amount Unencumbered:
$0.00
248.43
0.00
$251.21
5 of 9 1/17/2023, 1:24 PM
WATERLOO LEISURE SERVICES
SALES TAX REPORT
DECEMBER
2022
ACTIVITY 4120 - GOLF COURSES
1398 SALES TAX
GOLF REVENUE 7% TAX COLLECTED
WARREN MEMORIAL 3,916.82 274.18
GATES 0.00 0.00
28,379.21
1,986.54
ACTIVITY 4125 - GOLF COURSE IMPROVEMENTS
1398 SALES TAX
WARREN MEMORIAL
GATES
GOLF REVENUE 7% TAX COLLECTED
45.79 3.21
0.00 0.00
39.72
303.03
21.21
1-4-23
Firefox https://alo-nw.city.alo/nwerp/Temp/FileStorageCache/3TDOER12.htm
1434 - TREASURER, STATE OF
IOWA
2023-00001249 RECREATION CENTER 1-07-025857 12/31/2022 01/23/2023 01/23/2023
(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
01/23/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:
86.45
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 - SPORTS SALES TAX PERMIT
# 1 07 025857
1.0000 EA
86.4500
86.45
Expensed Unencumbered
010-37-4200 1398 ( General Fund -Leisure Services -Sports & Youth Services Sales Tax)
Invoice Amount Expensed: $86.45
Invoice Amount Unencumbered:
$0.00
86.45
0.00
$86.45
6 of 9 1/17/2023, 1:24 PM
SPORTS SALES TAX
010-37-4200
Dec-22
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
GROSS SALES NET SALES SALES TAX
1,321.45
GROSS SALES TOTAL 1,321.45
NET SALES TOTAL 1,235.00
SALES TAX TOTAL 86.45
1,235.00
86.45
Firefox https://alo-nw.city.alo/nwerp/Temp/FileStorageCache/3TDOERI 2.htm
1434 - TREASURER, STATE OF 2023-00001250
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
12/312022 01/23/2023 01/23/2023
01/23/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,496.54
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 - SALES TAX PERMIT #
1-07-040732
1.0000 EA
8,496.5400
8,496.54
Expensed Unencumbered
010-37-4180 1398 ( General Fund -Leisure Services-SportsPlex Sales Tax)
37SPLX.OPER ( CEDAR VALLEY SPORTSPLEX, SPORTSPLEX OPERATIONS)
Invoice Amount Expensed: $8,496.54
Invoice Amount Unencumbered:
$0.00
8,496.54
0.00
$8,496.54
7 of 9 1/17/2023, 1:24 PM
SPORTSPLEX SALES TAX
010-37-4180
Dec-22
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
15, 696.43
14,669.56
1,026.87
8,687.11
8,118.79
568.32
105,492.17
98,590.81
6,901.36
GROSS SALES TOTAL 129,875.70
NET SALES TOTAL 121,379.16
SALES TAX TOTAL 8,496.54
From: Courtney Jackson
Leisure Services
Firefox https://a10-nw.city.alo/nwerp/Temp/FileStorageCache/3TD0ER12.htm
1434 - TREASURER, STATE OF 2023-00001251
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 12/31/2022 O1/23/2023 01/23/2023
1-07-030336
Check Sort Code:
Check Code:
Manual Check: Confirming EFT
Check Number:
Detail: P.O. Number C/D/F/T/A/1099 Description
01/23/2023
Bank Account: ACCOUNTS PAYABLE
Invoice Terms:
Hold Reason:
Quantity U/M
No Gross: 33,176.83
Freight: 0.00
State Tax: 0.00
County Tax: 0.00
Local/City Tax: 0.00
Discount: 0.00
Retainage: 0.00
Net Amount: $33,176.83
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
33,176.8300
33,176.83
Expensed Unencumbered
520-14-5200 1398 ( Sanitary Sewer Fund -Waste Management -Water Pollution -Water Pollution Control Plant Op Sales
Tax)
Invoice Amount Expensed: $33,176.83
Invoice Amount Unencumbered:
$0.00
33,176.83
0.00
8 of9 1/17/2023, 1:24 PM
TAX REPORT FOR December
WASTE MANAGEMENT SERVICES
Billing Dated 01/03/23
November 2022 Usage
NON-TAXABLE ACTIVITY
ACCT./
COMPANY
NET BILLED
TOTAL BILLED
5452
BLACK HAWK CARE FACILITY
n/a
-
5453
BLACK HAWK COUNTY SOLID WASTE
7,069.13
nla
7,069.13
5641
BLACK HAWK COUNTY LANDFILL PRET
236.80
nla
238.60
14061
WATERLOO PROCESSING LLC
1,810.10
Na
1,810,10
5644
TYSON FOODS PRET
2,0644.00
n/a
2,064.03
7518
CONAGRA PRET
Na
13109
CONAGRA
5,798.47
n/a
5,798.47
6602
J.D. ENGINE WORKS/annual lab fee
n/a
5840
ARAMARK UNIFORM SERVICES/annual lab lee
n/a
-
5543
HYDRITE CHEMICAL CO. PRET/annual lab fee
n/a
-
2191
Allan Indualdal Coatings/annual lab fee
n/a
-
5641
BLACK HAWK COUNTY LANDFILL PRET/annual lab fee
Na
-
8464
DARLING INTERNATIONAUannual lab fee
Na
-
5846
J. D. WESTFIELDannual lab lee
Na
-
14061
WATERLOO PROCESSING LLC/ annual lab lee
Na
-
5644
Tyson/annual lab fee
Na
-
7518
Conagra/annual lab fee
1,239.00
Na
1,239.00
20973
The Crown Group/annual lab fee
Na
-
12488
PLANERGY
5/0
14453
VETS'S TRUCKWASHLabfee
Na
-
10843
CANADIAN NATIONAL GROUNDWATER
Na
-
10521
CANADIAN NATIONAL RAILWAYlannual lab fee
Na
-
22509
City of Evanedale
60.00
Na
60.00
22085
COOLEY PUMPING
Ma
5640
Aramark/annual lab fee
Na
-
23714
Advanced Drainage/annual lab fee
Na
-
13874
J.D. PEC/annual lab fee
Na
-
12935
IOWA NORTHERN RAILWAY/annual lab fee
n/a
-
Non-taxable
13,27750
TAXABLE ACTIVITY
ACCTY
NET BILLED
TAXED APPLIED
TOTAL BILLED
5481
ARAMARK
5,027.98
351.98
5,379.94
14060
WATERLOO PROCESSING LLC
93,340.88
3,033.80
46,374.74
14060
TWIN CITY CO
-
•
5436
TYSON FOODS
335,616.21
23,493.13
359,109.39
5437
JOHN DEERE- DONALD STREET
5,439.22
380.75
5,819.97
5458
JOHN DEERE- ENGINE WORKS
2,513.59
198.95
3,010.49
5452
Black Hawk Nursing &
3,534.71
247.43
3,782.14
5459
JOHN DEERE - FOUNDRY 8001
18.80
1.30
19.90
5460
JOHN DEERE. FOUNDRY 8002
546.06
30.22
504.28
5461
JOHN DEERE - PEG
3,939.06
415.73
6,354.79
5462
JOHN DEERE - BLDG 102001021
9,602.28
872.16
10,274.44
5463
JO - WESTFIELD a JEFFERSON
8,432.82
590.30
9,023.12
12409
JOHN DEERE WSJ - BLDG A
486.46
34.05
520.51
10695
CN RAILWAY
5638
DRAIN DOCTOR
2.27
0.16
2.43
6657
CONAGRA GROCERY PRODUCTS
35,572.27
2,560.06
39,132.33
6960
HYDRITE CHEMICAL CO
4,264.10
298.49
4,562.59
7291
DARLING INTERNATIONAL
-
7324
BLACK HAWK WASTE
8747
LOST ISLAND METER
37.20
2.80
39.80
22671
Ceder Valley Portables
-
12557
A-1 SEPTIC
1,400.00
98.00
1,498.00
23461
Al P14.11 Septic
50.00
3.50
53.50
12313
SAVE OUR SINK
•
14432
VETS TRUCK WASH
6,801.59
476.11
7,277.70
13854
GROTH SERVICES
.
20319
PAUL COOLEY PUMPING COOLEY PUMPING
220.00
15.40
235A0
23413
Crystal Heating & Plumbing
•
20321
GREENS'S SEPTIC SERVICE
60.00
4.20
6430
20633
22365
ACTIVE BIOMATERIALS•
Rota Rooter
90.00
6.30
96.30
21312
PLANERGY
-
23496
Greenline Polymers
3,639.63
236.17
3,913.60
SUBTOTAL TAXABLE
$ 973,934.88
$ 33,176.83
$ 507,131.71
Grand Total
$ 473,954.88
$ 33,176.83
$ S25,906.21
Grand total of Posting
Grand total of Posting $
Firefox https://alo-nw.city.alo/nwerp/Temp/FileStorageCache/3TDOER12.htm
1434 - TREASURER, STATE OF 2023-00001263
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 POOL 1-07-025855 12/31/2022 01/232023 01232023
YEARLY
Check Sort Code:
Check Code:
Manual Check: Confirming EFT
Check Number:
Detail: P.O. Number C/D/F/T/A/1099 Description
01/23/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:
416.13
0.00
0.00
0.00
0.00
0.00
0.00
$416.13
Amount/Unit Total Amount
N/Y/Y/N/N/N
G/L Distribution: G/L Account/Project
Total Invoice Items: 1
Conversion Item - GATES POOL PERMIT #1 07
025855
1.0000 EA
416.1300
416.13
Expensed Unencumbered
010-37-4200 1398 ( General Fund -Leisure Services -Sports & Youth Services Sales Tax)
Invoice Amount Expensed: $416.13
Invoice Amount Unencumbered:
416.13
$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:
Grand Total Unencumbered:
0.00
9
$79,672.79
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$79,672.79
$0.00
9
$79,672.79
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$79,672.79
$0.00
9 of 9 1/17/2023, 1:24 PM
SPORTS SALES TAX
010-37-4200
Gates Pool 2022
Byrnes Pool Daily Admissions (4200-3475)
Gates 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
GROSS SALES
NET SALES
SALES TAX
9,604.00 8,931.72
672.28
GROSS SALES TOTAL 9,604.00
NET SALES TOTAL 8,931.72
SALES TAX TOTAL 672.28
vva
ent of
R`EVEN'UE
Sales and Use Return Summary
Sales Tax
Use Tax
Final Balances
Name: CITY OF WATERLOO
Account ID: 1-07-025852
Filing Period: 31-Dec-2022
Date: 25-Jan-2023
Confirmation Number: 0-002-770-304
Gross Sales
Goods Consumed
Total Exemptions
Taxable Amount
State Sales Tax (6%)
Local Option Sales Tax
Total Taxable Purchases
Sales Subject to Use Tax
Taxable Amount
Use Tax
Deposits/Overpayment Credit
Total Tax & Surcharge
Balance
Total Amount Due
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
This is a summary only and will not be accepted as a return by the Iowa Department of Revenue. Retain this document for personal records.
Iowa
partment of
REV�ENVE
Sales and Use Return Summary
Sales Tax
Name: CITY OF WATERLOO
Account ID: 1-07-025853
Filing Period: 31-Dec-2022
Date: 25-Jan-2023
Confirmation Number: 0-002-720-952
Gross Sales
Goods Consumed
Total Exemptions
Taxable Amount
State Sales Tax (6%)
Local Option Sales Tax
$3,962.61
$0.00
$0.00
$3,962.61
$237.76
$39.63
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 $277.39
Balance $277.39
Total Amount Due $277.39
Payment Information Bank Name REGIONS BANK
Account Number ****6001
Amount $277.39
Payment Date 25-Jan-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-720-952
Date: 25-Jan-2023
Taxable Sales Local Option Local Option Tax (1.00%)
Black Hawk County - 07
$3,962.61 $39.63
$3,962.61 $39.63
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 NUE
Sales and Use Return Summary
Sales Tax
Name: CITY OF WATERLOO
Account ID: 1-07-025854
Filing Period: 31-Dec-2022
Date: 25-Jan-2023
Confirmation Number: 0-002-798-976
Gross Sales
Goods Consumed
Total Exemptions
Taxable Amount
State Sales Tax (6%)
Local Option Sales Tax
$21,130.84
$0.00
$0.00
$21,130.84
$1,267.85
$211.31
Use Tax Total Taxable Purchases $0.00
Sales Subject to Use Tax $0.00
Taxable Amount $0.00
Use Tax $0.00
Final Balances Deposits/Overpayment Credit $0.00
Total Tax & Surcharge $1,479.16
Balance $1,479.16
Total Amount Due $1,479.16
Payment Information Bank Name REGIONS BANK
Account Number ****6001
Amount
$1,479.16
Payment Date 25-Jan-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-798-976
Date: 25-Jan-2023
Taxable Sales Local Option Local Option Tax (1.00%)
Black Hawk County - 07
$21,130.84
$21,130.84
$211.31
$211.31
This is a summary only and will not be accepted as a return by the Iowa Department of Revenue. Retain this document for personal records.
ea
REVENUE
Sales and Use Return Summary
Sales Tax
Use Tax
Final Balances
Payment Information
Name: CITY OF WATERLOO
Account ID: 1-07-025855
Filing Period: 31-Dec-2022
Date: 25-Jan-2023
Confirmation Number: 0-002-720-464
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
$9,604.00
$0.00
$0.00
$9,604.00
$576.24
$96.04
$0.00
$0.00
$0.00
$0.00
Deposits/Overpayment Credit $256.15
Total Tax & Surcharge $672.28
Balance $416.13
Total Amount Due $416.13
Bank Name REGIONS BANK
Account Number ****6001
Amount $416.13
Payment Date 25-Jan-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-720-464
Date: 25-Jan-2023
Taxable Sales Local Option Local Option Tax (1.00%)
Black Hawk County - 07
$9,604.00 $96.04
$9,604.00 $96.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.
REV
NUE
Sales and Use Return Summary
Sales Tax
Use Tax
Final Balances
Name: CITY OF WATERLOO
Account ID: 1-07-025856
Filing Period: 31-Dec-2022
Date: 25-Jan-2023
Confirmation Number: 0-002-704-080
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.
t
REVa De NnUE
Name: CITY OF WATERLOO
Account ID: 1-07-025857
Filing Period: 31-Dec-2022
Date: 25-Jan-2023
Confirmation Number: 0-002-704-056
Sales and Use Return Summary
Sales Tax Gross Sales $1,235.00
Goods Consumed $0.00
Total Exemptions $0.00
Taxable Amount $1,235.00
State Sales Tax (6%) $74.10
Local Option Sales Tax $12.35
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 $86.45
Balance $86.45
Total Amount Due $86.45
Payment Information Bank Name REGIONS BANK
Account Number ****6001
Amount $86.45
Payment Date 25-Jan-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-704-056
Date: 25-Jan-2023
Taxable Sales Local Option Local Option Tax (1.00%)
Black Hawk County - 07
$1,235.00 $12.35
$1,235.00 $12.35
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.
FeEVEaNUE
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-Dec-2022
Date: 25-Jan-2023
Confirmation Number: 0-002-769-792
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
$429,057.71
$0.00
$0.00
$429,057.71
$25,743.46
$4,290.58
$0.00
$0.00
$0.00
$0.00
Deposits/Overpayment Credit $0.00
Total Tax & Surcharge $30,034.04
Balance $30,034.04
Total Amount Due $30,034.04
Bank Name REGIONS BANK
Account Number ****6001
Amount $30,034.04
Payment Date 25-Jan-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-769-792
Date: 25-Jan-2023
Taxable Sales Local Option Local Option Tax (1.00%)
Black Hawk County - 07
$429,057.71
$429,057.71
$4,290.58
$4,290.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.
RI EVEaN U E
Sales and Use Return Summary
Sales Tax
Name: CITY OF WATERLOO
Account ID: 1-07-030336
Filing Period: 31-Dec-2022
Date: 25-Jan-2023
Confirmation Number: 0-002-751-789
Gross Sales
Goods Consumed
Total Exemptions
Taxable Amount
State Sales Tax (6%)
Local Option Sales Tax
$473,954.65
$0.00
$0.00
$473,954.65
$28,437.28
$4,739.55
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 $33,176.83
Balance $33,176.83
Total Amount Due $33,176.83
Payment Information Bank Name REGIONS BANK
Account Number """ 6001
Amount $33,176.83
Payment Date 25-Jan-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-751-789
Date: 25-Jan-2023
Taxable Sales Local Option Local Option Tax (1.00%)
Black Hawk County - 07
$473,954.65
$473,954.65
$4,739.55
$4,739.55
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.
RiEViaNUE
Sales and Use Return Summary
Sales Tax
Name: CITY OF WATERLOO
Account ID: 1-07-034601
Filing Period: 31-Dec-2022
Date: 25-Jan-2023
Confirmation Number: 0-002-704-173
Gross Sales
Goods Consumed
Total Exemptions
Taxable Amount
State Sales Tax (6%)
Local Option Sales Tax
$3,588.70
$0.00
$0.00
$3,588.70
$215.32
$35.89
Use Tax Total Taxable Purchases $0.00
Sales Subject to Use Tax $0.00
Taxable Amount $0.00
Use Tax $0.00
Final Balances Deposits/Overpayment Credit $0.00
Total Tax & Surcharge $251.21
Balance $251.21
Total Amount Due $251.21
Payment Information Bank Name REGIONS BANK
Account Number ****6001
Amount $251.21
Payment Date 25-Jan-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-704-173
Date: 25-Jan-2023
Taxable Sales Local Option Local Option Tax (1.00%)
Black Hawk County - 07
$3,588.70 $35.89
$3,588.70 $35.89
This is a summary only and will not be accepted as a return by the Iowa Department of Revenue. Retain this document for personal records.
R1EVeENUE
Sales and Use Return Summary
Sales Tax
Name: CITY OF WATERLOO
Account ID: 1-07-037313
Filing Period: 31-Dec-2022
Date: 25-Jan-2023
Confirmation Number: 0-002-708-176
Gross Sales
Goods Consumed
Total Exemptions
Taxable Amount
State Sales Tax (6%)
Local Option Sales Tax
$77,929.16
$0.00
$0.00
$77,929.16
$4,675.75
$779.29
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 $5,455.04
Balance $5,455.04
Total Amount Due $5,455.04
Payment Information Bank Name REGIONS BANK
Account Number ****6001
Amount $5,455.04
Payment Date 25-Jan-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-708-176
Date: 25-Jan-2023
Taxable Sales Local Option Local Option Tax (1.00%)
Black Hawk County - 07
$77,929.16
$77,929.16
$779.29
$779.29
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 Department of
REVENUE
Sales and Use Return Summary
Sales Tax
Name: CITY OF WATERLOO
Account ID: 1-07-040732
Filing Period: 31-Dec-2022
Date: 25-Jan-2023
Confirmation Number: 0-002-782-080
Gross Sales
Goods Consumed
Total Exemptions
Taxable Amount
State Sales Tax (6%)
Local Option Sales Tax
$121,379.16
$0.00
$0.00
$121,379.16
$7,282.75
$1, 213.79
Use Tax Total Taxable Purchases $0.00
Sales Subject to Use Tax $0.00
Taxable Amount $0.00
Use Tax $0.00
Final Balances Deposits/Overpayment Credit $0.00
Total Tax & Surcharge $8,496.54
Balance $8,496.54
Total Amount Due $8,496.54
Payment Information Bank Name REGIONS BANK
Account Number ****6001
Amount $8,496.54
Payment Date 25-Jan-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-782-080
Date: 25-Jan-2023
Taxable Sales Local Option Local Option Tax (1.00%)
Black Hawk County - 07
$121,379.16
$121,379.16
$1,213.79
$1,213.79
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.