Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
March
Firefox https://alo-nw.city.alo/nwerp/Temp/FileStorageCache/3 TDOF 180.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-00001763 Invoice Department: CC City Clerk TREASURER, STATE OF IOWA IOWA DEPT OF REVENUE & FINANCE PO BOX 10412 DES MOINES, IA 50306-0412 Batch Date: 04/17/2023 Batch Number: 2023-00001231 IRV WARREN MEMORIAL GOLF 03/31/2023 04/17/2023 04/17/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 Batch Description: 04/17/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: 3,297.85 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 33.4500 33.45 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 33.45 3,264.4000 0.00 3,264.40 Expensed Unencumbered 010-37-4120 1398 ( General Fund -Leisure Services -Golf Courses Sales Tax) Invoice Amount Expensed: $3,297.85 Invoice Amount Unencumbered: $0.00 3,264.40 0.00 $3,297.85 1 of 1 1 4/11/2023, 10:44 AM June Sept Dec Net Taxable Sales Sales Tax Collected 6% 1% Total Sales Tax 2023 YEAR Monthly State Sales Tax QTRLY REPORTING ONLY Leisure Services - Sports & Pools Leisure Services - Golf Courses Gates Warren Memorial South Hills Leisure - Office Sorts B rnes Gates Re• Im•rov Re Im•rov Re Improv Re Im•rov 22,12000 1,548.40 572.43 40.07 0.00 0.00 2,341.12 163.88 23.36 1.64 46,634.35 3,264.40 477.60 33.45 12,603.27 882.23 135.05 9.45 12,339.49 863.76 109.11t 7.64 1,327.20 221.20 1,548.40 34.35 5.72 40.07 0.00 0.00 0.00 140.47 23.41 163.88 1.40 0.23 1.64 Difference 0.00 0.00 0.00 0.00 0.00 Total Tax Due $ 1,548.40 Net Taxable Sales Sales Tax Collected 6% 1% Total Sales Tax WM SERVICES Water Pollution $ 40.07 ;.Gates -_ tal $ 166.52 GROSS SALES $ 163.88 $ 1.64; Sewer Garbage Storm Wtr Young Arena 571,435.02 40,000.45 446587.71 31,261.14 44,238.79 3,096.72 Difference 34,286.10 5,714.35 40,000.45 0.00 Total Tax Due $ 40,000.45 REGIONS BANK 26,795.26 4,465.88 31,261.14 0.00 $ 31,261.14 2,654.33 442.39 3,096.72 0.00 $ 3,096.72 2,364.48 Sewer Tax Garbage Tax Storm Tax 310.14 16,255.01 14,695.99 0.00 0.00 0.00 0.00 Warren„Mem.-Total._, i South ,Hills -Total,.,,,- I $ 3,297.85 GROSS SALES 47,112.15 GROSS SALES 15_5,264.40 $ 33.454 $ 882.23 $ 2,798.06 466.34 3,264.40 28.67 4.78 33.45 756.20 126.03 882.23 8.10 1.35 9.45 $ 891.68 740.37 123.39 863.76 6.55 1.09 7.64 0.00 0.00 Leisure Jotal,a;.- $ 871.40 12,738.32 9.45 $" 863.76 $ 7.64 SportsPlex 4�w� 'QTR 867 Sports 0 I ""6 1,327i00 0 221.00 Total $1,548:00: =QTR 856 Byrnes Pool 34,00 6 00 40.00 142,722.68 /QTR 855 Gates Pool 0 00 0,00 9,990.59 852 Gates 142.00 24.00 166.00 8,563.36 853 Warren 2,827.00 471.00 3,298.00 1,427.23 854 South Hills 764.00 127.00 891.00 9,990.59 QTR N601 Leisure Office 747.040 ;124.00 '_ 871.00 336 Wtr Pollution 34,286.00 5,71'4.00 40,000.00 0.00 336 Wtr/Swr/Gbq 26,795.00 4,466.00 31,261.00 8,563.36 313 Young Arena 2,654.00 442.00 3,096.00 1,427:23 732 SportsPlex 8,563.00 1,427.00 '9,990.00 $ 9,990.59 WATERLOO LEISURE SERVICES SALES TAX REPORT MARCH 2023 ACTIVITY 4120 - GOLF COURSES 1398 SALES TAX GOLF REVENUE 7% TAX COLLECTED WARREN MEMORIAL 46,634.35 3,264.40 GATES 2,341.12 163.88 SOUTH HILLS 12,603.27 882.23 OFFICE 12,339.49 863.76 73,918.23 5,174.28 ACTIVITY 4125 - GOLF COURSE IMPROVEMENTS 1398 SALES TAX GOLF REVENUE 7% TAX COLLECTED WARREN MEMORIAL 477.80 33.45 GATES 23.36 1.64 SOUTH HILLS 135.05 9.45 OFFICE 109.11 7.64 745.32 52.17 4-6-23 Firefox https://alo-nw.city.alo/nwerp/Temp/FileStorageCache/3TD0F180.httn 1434 - TREASURER, STATE OF 2023-00001764 GATES PARK GOLF COURSE 03/31/2023 04/17/2023 04/17/2023 04/17/2023 No Gross: 165.52 IOWA 1-07-025852 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: $165.52 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 - GATES GOLF COURSE IMPROVEMENTS G/L Distribution: G/L Account/Project 1.0000 EA 1.6400 1.64 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 PERMIT #1 07 025852 1.0000 EA 1.64 0.00 163.8800 163.88 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: $165.52 Invoice Amount Unencumbered: $0.00 163.88 0.00 2 of 11 4/11/2023, 10:44 AM June Sept Dec Leisure Services - Sports & Pools 2023 YEAR Monthly State Sales Tax QTRLY REPORTING ONLY, Leisure Services - Golf Courses S orts Net Taxable Sales 22,120.00 Sales Tax Collected 1,548.40 6% 1,327.20 1% 221.20 Total Sales Tax 1,548.40 Difference B rnes 572.43 40.07 34.35 5.72 Gates ✓ . Gates 0.00 0.00 0.00 0.00 40.07 0.00 Re 2,341.12 163.88 140.47 23.41 163.88 0.00 Total Tax. Due $ 1,548.40 Net Taxable Sales Sales Tax Collected 6% 1% Total Sales Tax WM SERVICES Water Pollution 0.00 $ 40.07 0.00 0.00 Im rov 23.36 1.64 1.40 0.23 1.64 Warren Memorial 0.00 Gates - Total: .,. I $ 165.52 GROSS SALES 2,364.48 Sewer Garbage Storm Wtr Young Arena Difference 571,435.02 40,000.45 34,286.10 5,714.35 40,000.45 446,587.71 31,261.14 26,795.26 4,465.88 44,238.79 3,096.72 2,654.33 442.39 31,261.14 3,096.72 0.00 Total Tax Due $ 40,000.45 REGIONS BANK 0.00 $ 31,261.14 0.00 $ 3,096.72 Sewer Tax Garbage Tax Storm Tax 310.14 16,255.01 14,695.99 Re 46,634.35 3,264.40 2,798.06 466.34 3,264.40 Im rov 477,80 33.45 South Hills 28.67 4.78 33.45 0.00 0.00 Re 12,603.27 882.23 756.20 126.03 882.23 Improv 135.05 9.45 Leisure - Office 8.10 1.35 9.45 0.00 0.00 Warren Mein - Total. , . South Hills, -Totals.. $ 891.68 $ 3,297.85 GROSS SALES 47,112.15 $ 3,264 40 $ 33,45 $ 1382.23 $ 9.45 $ 863.76 $ 7.64'' Re 12,339.49 863.76 740.37 123.39 863.76 0.00 Im rov 109.11 7.64 6.55 1.09 7.64 Leisure." Total 0.00 $ 871.40 GROSS SALES 12,738.32 SportsPlex 6° 1,327.00 221.00 Total QTR 857 `-Sports $1,548.00 3QTR 856 Byrnes Pool 34.00 6.00 40.00 142,722.68 ,I QTR 855 Gates Pool 0 00 _am � 0.00 - .�«�.,..�. 9,990.59 852 Gates 142.00 24.00 166.00 8,563.36 853 Warren 2,827.00 471.00 3,298.00, 1,427.23 854 South Hills 764.00 127.00 891.00 9,990.59 QTR 601 ' Leisure Office 74700 124.00 871.00`" 336 Wtr Pollution 34,286.00 5,714.00 4'0,000.00 0.00 335 Wtr/Swr/Gbg 26,795.00 4,466.00 31,261.00 8,563.36' 313 Young Arena 2,654 00 442.00 3,096.00 1,427.23' 732 SportsPlex 8,563.00 1,427.00 9,990.00 $ 9,990.59 WATERLOO LEISURE SERVICES SALES TAX REPORT MARCH 2023 ACTIVITY 4120 - GOLF COURSES 1398 SALES TAX GOLF REVENUE 7% TAX COLLECTED WARREN MEMORIAL 46,634.35 3,264.40 GATES 2,341.12 163.88 SOUTH HILLS 12,603.27 882.23 OFFICE 12,339.49 863.76 73,918.23 5,174.28 ACTIVITY 4125 - GOLF COURSE IMPROVEMENTS 1398 SALES TAX GOLF REVENUE 7% TAX COLLECTED WARREN MEMORIAL 477.80 33.45 GATES 23.36 1.64 SOUTH HILLS 135.05 9.45 OFFICE 109.11 7.64 745.32 52.17 4-6-23 Firefox https://alo-nw.city.alo/nwerp/Temp/FileStorageCache/3TD0F180.htm 1434 - TREASURER, STATE OF 2023-00001765 SOUTH HILLS GOLF COURSE 03/31/2023 04/17/2023 04/17/2023 04/17/2023 No Gross: 891.68 IOWA 1-07-025854 Invoice Department: CC City Clerk Check Sort Code: TREASURER, STATE OF IOWA Check Code: IOWA DEPT OF REVENUE & FINANCE Manual Check: Confirming EFT PO BOX 10412 Check Number: DES MOINES, IA 50306-0412 Detail: P.O. Number C/D/F/T/A/1099 Description Bank Account: ACCOUNTS PAYABLE Invoice Terms: Hold Reason: Quantity U/M Freight: 0.00 State Tax: 0.00 County Tax: 0.00 Local/City Tax: 0.00 Discount: 0.00 Retainage: 0.00 Net Amount: $891.68 Amount/Unit Total Amount N/Y/Y/N/N/N Conversion Item - SOUTH HILLS GOLF (IMPROV) 1.0000 EA 9.4500 9.45 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 9.45 0 00 882.2300 882.23 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: $891.68 Invoice Amount Unencumbered: $0.00 882.23 0.00 3 of 11 4/11/2023, 10:44 AM June Sept Dec Leisure Services - Sports & Pools S orts Net Taxable Sales 22,120.00 Sales Tax Collected 6% 1% Total Sales Tax Difference 1,548.40 1,327.20 221.20 1,548.40 0.00 Total Tax Due $ 1,548.40 Net Taxable Sales Sales Tax Collected 6% 1% Total Sales Tax Difference WM SERVICES Water Pollution B rnes 572.43 40.07 34.35 5.72 40.07 Gates 2023 YEAR Monthly State Sales Tax QTRLY REPORTING ONLY Leisure Services - Golf Courses 0.00 $ 40.07 0.00 0.00 0.00 0.00 0.00 Gates Re Im rov 2,341.12 23.36 163.88 1.64 140.47 23.41 163.88 1.40 0.23 1.64 Warren Memorial Re Im rov 46,634.35 477.80 3,264.40 33.45 2,798.06 28.67 466.34 4.78 3,264.40 33.45 South Hills Re 12,603.27 882.23 756.20 126.03 882.23 Leisure - Office Improv Re Im rov 0.00 0.00 0.00 Gates - Total $ 165.52 GROSS SALES $ 163.88 $ Sewer Garbage Storm Wtr Young Arena 571,435.02 40,000.45 34,286.10 5,714.35 446,587.71 31,261.14 44,238.79 3,096.72` 26,795.26 2,654.33 4,465.88 442.39 40,000.45 31,261.14 3,096.72 0.00 Total Tax Due $ 40,000.45 REGIONS BANK 0.00 $ 31,261.14 0.00 $ 3,096.72 Sewer Tax Garbage Tax Storm Tax 2,364.48 0.00 0.00 Warren Mem,:Total . $ 3,297.85 GROSS SALES 47,112.15 1.64 ` $ 3,264.40 $ ;, 33.45 310.14 16,255.01 14,695.99 135.05 12,339.49 109.11. 9.45 r 863.76 7.64 8.10 740.37 6.55 1.35 ;; 123.39 1.09 9.45 : 863.76 7.64 0.00 0.00 South Hills - Total. _ .(. $ 891.68 GROSS SALES 12,738.32 - 882.23 $ 9.4 $ 863.76 $ 7.64 0.00 0.00 Leisure -.Total-, :.. ,.. $ 871.40 SportsPlex QTR 807 Sports 1,327.00 1° 221.00 Total J $1,548.00 QTR 856 Byrnes Pool 34.00 6.00 40.00 142,722.68 9,990.59 QTR 855 Gates Pool gym, 0.00 142.00 0.00 ,., 24.00 166.00 .a -a . 852 Gates 8,563.36 853 Warren 2,827.00 471.00 3,298.00 1,427.23 854 South Hills 764.00 127.00 891.00 9,990.59 QTR 601 Leisure Office 747.00 - 124.00 -. 871.00 336 Wtr Pollution 34,286.00 m 5 ,714.00 40,000.00 0.00 335 Wtr/Swr/Gbg 26,795.00 4,466.00 31,261.00 8,563.36 313 Young Arena 2,654.00 442.00 3,096.00 1,427.23 732 SportsPlex 8,563.00 1,427.00 9,990.00 9,990.59 WATERLOO LEISURE SERVICES SALES TAX REPORT MARCH 2023 ACTIVITY 4120 - GOLF COURSES 1398 SALES TAX GOLF REVENUE 7% TAX COLLECTED WARREN MEMORIAL 46,634.35 3,264.40 GATES 2,341.12 163.88 SOUTH HILLS 12,603.27 882.23 OFFICE 12,339.49 863.76 73,918.23 5,174.28 ACTIVITY 4125 - GOLF COURSE IMPROVEMENTS 1398 SALES TAX GOLF REVENUE 7% TAX COLLECTED WARREN MEMORIAL 477.80 33.45 GATES 23.36 1.64 SOUTH HILLS 135.05 9.45 OFFICE 109.11 7.64 745.32 52.17 4-6-23 Firefox https://alo-nw.city.alo/nwerp/Temp/FileStorageCache/3TDOF 180.htm 1434 - TREASURER, STATE OF 2023-00001766 YOUNG ARENA 1-07-037313 03/31/2023 04/17/2023 04/17/2023 04/17/2023 No Gross: 3,096.72 IOWA Invoice Department: CC City Clerk Check Sort Code: TREASURER, STATE OF IOWA Check Code: IOWA DEPT OF REVENUE & FINANCE Manual Check: Confirming EFT PO BOX 10412 Check Number: DES MOINES, IA 50306-0412 Detail: P.O. Number C/D/F/T/A/1099 Description Bank Account: ACCOUNTS PAYABLE Invoice Terms: Hold Reason: Quantity U/M Freight: 0.00 Slate Tax: 0.00 County Tax: 0.00 Local/City Tax: 0.00 Discount: 0.00 Retainage: 0.00 Net Amount: $3,096.72 Amount/Unit Total Amount N/Y/Y/N/N/N Conversion Item - YOUNG ARENA PERMIT #1 07 037313 1.0000 EA 3,096.7200 3,096.72 G/L Distribution: G/L Account/Project Expensed Unencumbered 010-37-4500 1398 ( General Fund -Leisure Services -Young Arena Sales Tax) Total Invoice Items: 1 Invoice Amount Expensed: $3,096.72 Invoice Amount Unencumbered: $0.00 3,096.72 0.00 4 of 11 4/11/2023, 10:44 AM June Sept Dec Leisure Services - Sports & Pools Net Taxable Sales Sales Tax Collected 6% 1% Total Sales Tax Difference S orts 22,120.00 1,548.40 1,327.20 221.20 1,548.40 B rnes 572.43 40.07 34.35 5.72 40.07 Gates 0.00 0.00 0.00 0.00 0.00 2023 YEAR Monthly State Sales Tax QTRLY REPORTING ONLY Leisure Services - Golf Courses Gates Re 2,341.12 163.88 140.47 23.41 163.88 Im rov 23.36 1.64 1.40 0.23 1.64 Warren Memorial Re Im rov 46,634..35 477.80 3.264.40 33.45 2,798.06 466.34 3,264.40 28.67 4.78 33.45 South Hills Re 12,603.27 882.23 756.20 126.03 Improv Leisure - Office Re Im rov 135.05 12, 339.49 1109.11 9.45 863.76 7.64 8.10 740.37 6.55 1.35 123.39 1.09 882.23 9.45 863.76 7.64 0.00 0.00 0.00 0.00 0.00 Total Tax Due $ 1,548.40 Net Taxable Sales Sales Tax Collected 6% 1% Total Sales Tax Difference WM SERVICES Water Pollution $ 40.07 Gates - Total. $ 166.52 GROSS SALES 0.00 0.00 Warren Mem --Total, $ 3,297.85 0.00 South Hills - Total. 0.00 $ 891.68 2,364.48 GROSS SALES 47,112.15 GROSS SALES 12,738.32 0.00 0.00 Leisure -Total.:..: $ 871.40 $ 163.88 $ 1.64 ; $' 3,264.40 $ r+ 33.45 $ 882.23 $ 9.45 $ 863.76 $ 7.64'. Sewer Garbage Storm Wtr Young Arena 571,435.02 40,000.45 34,286.10 5,714.35 40,000.45 446,587.71 31,261.14 26,795.26 4,465.88 44,238.79 3,096.72 2,654.33 442.39 31,261.14 3,096.72 0.00 Total Tax Due $ 40,000.45 REGIONS BANK 0.00 $ 31,261.14 0.00 $ 3,096.72I Sewer Tax Garbage Tax Storm Tax 310.14 16,255.01 14,695.99 SportsPlex, QTR 857 Sports 1,327.00 JP� �� 221.00 Total. $1,548.00 QTR 866 Byrnes Pool 34.00 6.00 40.00 142,722.68 QTR 855 Gates Pool 0.00 0.00 9,990.59 852 Gates 142.00 24.00 166.00 8,563.36 853 Warren 2,827.00 471.00 3,298.00 1,427.23 854 South Hills 764.00 127.00 891.00 9,990.59 ,QTR 601 Leisure Office 747.00 -124.00 00� 336 Wtr Pollution 34,286.00 5,714.00 _-871 40,000.00 0.00 335 Wtr/Swr/Gbg 26,795.00 4,466.00 31,261.00 8,563.36 313 Young Arena 2,654.00 442.00 3,096.00 1,427.23 732 SportsPlex 8,563.00 1,427.00 9,990.00 $ 9,990.59 4/10/2023 YOUNG ARENA SALES TAX 010-37-4500-1398 Gross Taxable Sales March 2023 47,335.50 Net Taxable Sales March 2023 44,238.79 Total Tax March 2023 3,096.71 To: Ryan Stuber City Clerks Office Waterloo City Hall From: Madonna Welsh Leisure Services Firefox https://alo-nw.city.alo/nwerp/Temp/FileStorageCache/3TD0F180.htm 1434-TREASURER, STATE OF 2023-00001767 STORMWATER + SEWER + 03/31/2023 04/17/2023 04/17/2023 04/17/2023 No Gross: 31,261.14 IOWA GARBAGE 1-07-030335 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/I099 Description Bank Account: ACCOUNTS PAYABLE Invoice Terms: Hold Reason: Quantity U/M Freight: 0.00 State Tax: 0.00 County Tax: 0.00 Local/City Tax: 0.00 Discount: 0.00 Retainage: 0.00 Net Amount: $31,261.14 Amount/Unit Total Amount N/Y/Y/N/N/N Conversion Item - GARBAGE PERMIT #1 07 030335 1.0000 EA 16,255.0100 16,255.01 G/L Distribution: G/L Account/Project Expensed Unencumbered 525-15-5400 1398 ( Sanitation Fund -Waste Management -Sanitation -Solid Waste Disposal Sales Tax) N/Y/Y/N/N/N Conversion Item - SEWER PERMIT 41 07 030335 G/L Distribution: G/L Account/Project 1.0000 EA 16,255.01 0.00 310.1400 310.14 Expensed Unencumbered 520-14-5200 1398 ( Sanitary Sewer Fund -Waste Management -Water Pollution -Water Pollution Control Plant Op Sales 310.14 0.00 Tax) N/Y/Y/N/N/N Conversion Item - STORM WATER PERMIT #1 07 1.0000 EA 14,695.9900 14,695.99 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: $31,261.14 Invoice Amount Unencumbered: $0.00 14,695.99 0.00 5 of 11 4/11/2023, 10:44 AM June Sept Dec Leisure Services - Sports & Pools S orts Net Taxable Sales 22,120.00 Sales Tax Collected 6% 1% Total Sales Tax Difference 1,548.40 1,327.20 221.20 B rnes 572.43 40.07 34.35 5.72 1,548.40 40.07 Gates 0.00 0.00 0.00 0.00 2023 YEAR Monthly State Sales Tax QTRLY REPORTING ONLY Leisure Services - Golf Courses Gates Re 2,341.12 163.88 140.47 23.41 Im rov 23.36 1.64 1.40 0.23 Warren Re 46,634.35 3,264.40 2,798.06 466.34 0.00 163.88 1.64 3,264.40 Memorial Im rov 477.80 33.45 28.67 4.78 33.45 South Hills Re 12,603 27 882.23 756.20 126.03 882.23 0.00 Total,Tax Due $ 1,548.40 Net Taxable Sales Sales Tax Collected 6% 1% Total Sales Tax Difference WM SERVICES Water Pollution 571,435.02 40,000.45 34,286.10 5,714.35 40,000.45 0.00 Total Tax, Due $ 40,000.45 REGIONS BANK 0.00 $ 40.07 0.00 0.00 0.00 Gates -,Total ,. $ 165.52 GROSS SALES $ 163.88 $ Sewer Garbage Storm Wtr 446,587.71 31,261.14 26,795.26 4,465.88 Young Arena 44,238.79 3,096.72 2,654.33 442.39 31,261.14 3,096.72 0.00 $ 31,261.14 0.00 $ 3,096.72 Sewer Tax Garbage Tax Storm Tax 0.00 0.00 Warren Mem -Total ... , $ 3,297.85 Improv 135.05 9.45 8.10 1.35 9.45 0.00 0.00 South,Hilis - Total_ .. . $ 891.68 Leisure - Office Re 12,339.49 863.76 740.37 123.39 863.76 Im rov 109.11 7.64 6.55 1.09 7.64 0.00 0.00 Leisure -Totals ..--- - $ 871.40'. 2,364.48 GROSS SALES 47,112.15 GROSS SALES 12,738.32 1.64 $ 3,264.40 $ 33.45 $ 882.23 $ 9.45 $ 863.76 $ 7.64 310.14 16,255.01 14,696.99 SportsPlex o< mm ,-. QTR 857 Sports Y. 7 @,x,n w 221.00 Total $1,548.00A a 1,327.00 QTR 856 Byrnes Pool 34.00 6.00 40.00 142,722.68 9,990.59 1QTR 855 Gates Pool 852 Gates 0.00 142.00 0.00 24.00 166.00 8,563.36 853 Warren 2,827.00 471.00 3,298.00 1,427.23 854 South Hills 764.00 747,00 34,286.00 127.00 124.00 �5,714.00 891.00 ' 871.00 40,000.00 9,990.59 QTR 601 Leisure Office 336 Wtr Pollution 0.00 335 Wtr/Swr/Gbg 26,795.00 4,466.00 31,261.00 8,563.36 313 Young Arena 2,654.00 442.00 3,096.00 1,427.23 732 SportsPlex 8,563.00 1,427.00 9,990.00 $ 9,990.59 RYAN STUBER From: Holly Sackett Sent: Monday, April 3, 2023 11:07 AM To: RYAN STUBER Subject: Billed Sales Tax March 2023 Good morning, Here's the billed sales tax for March 2023. Storm water- $14,695.99 Garbage- $16,255.01 Sewer- $310.14 Thanks! Saekur 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/3TDOF 180.htm 1434 - TREASURER, STATE OF 2023-00001768 BYRNES PARK POOL 1-07-025856 03/31/2023 04/17/2023 04/17/2023 04/17/2023 No Gross: 40.07 IOWA Freight: 0.00 Invoice Department: CC City Clerk Check Sort Code: Bank Account: ACCOUNTS PAYABLE State Tax: 0.00 TREASURER, STATE OF IOWA Check Code: Invoice Terms: County Tax: 0.00 IOWA DEPT OF REVENUE & FINANCE Manual Check: Confirming EFT Hold Reason: Local/City Tax: 0.00 PO BOX 10412 Check Number: Discount: 0.00 DES MOINES, IA 50306-0412 Retainage: 0.00 Net Amount: $40.07 Detail: P.O. Number C/D/F/T/A/1099 Description Total Invoice Items: Quantity U/M Amount/Unit Total Amount N/Y/Y/N/N/N Conversion Item - BYRNES PARK POOL PERMIT # 107 025856 1.0000 EA 40.0700 40.07 G/L Distribution: G/L Account/Project Expensed Unencumbered 010-37-4200 1398 ( General Fund -Leisure Services -Sports & Youth Services Sales Tax) Invoice Amount Expensed: $40.07 Invoice Amount Unencumbered: $0.00 40.07 0.00 6 of 11 4/11/2023, 10:44 AM June Sept Dec Net Taxable Sales Sales Tax Collected 6% 1% Total Sales Tax Difference Pool 2023 YEAR Monthly State Sales Tax QTRLY REPORTING ONLY C �.......... ..... Sorts ......... ..,........� B roes .. Gates wmw c uc, V .ca - vu„ uu, aca Gates Warren Memorial South Hills ..1 Leisure - Office Re. Im.rov Re. Im.rov Re. Improv Re. Im.rov 22,120.00 1,548.40 572.43 40.07 0.00 0.00 2,341.12 163.88 23.36 1.64 46,634.35 3,264.40 477.80 33.45 12,603.27 882.23 135.05 9.45 12,339 49 863.76 109.11 7.64 1,327.20 221.20 1,548.40 34.35 5.72 40.07 0.00 0.00 0.00 140.47 23.41 163.88 1.40 0.23 1.64 2,798.06 466.34 3,264.40 28.67 4.78 33.45 756.20 126.03 882.23 8.10 1.35 9.45 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Gates - Total_ Warren Mem - Total Total Tax Due $ 1,548.40 Net Taxable Sales Sales Tax Collected 6% 1% Total Sales Tax WM SERVICES Water Pollution $ 40.07„ $ 165.52 GROSS SALES. 2,364.48 $ 3,297.85 0.00 South Hills - Total. 0.00 $ 891.68 GROSS SALE 12,738.32 $ 163.88 $ ` 1.64 - $ 3,264.40 $ 33.45 $ 882.23 $ 9.45 $ 863.76 740.37 123.39 863.76 0.00 6.55' 1.09 7.64 0.00 Leisure - Total Sewer Garbage Storm Wtr Young Arena 571,435.02 40,000.45 446,587.71 31,261.14 44,238.79 3,096.72 Difference 34,286.10 5,714.35 40,000.45 0.00 e TotaLTaXDue $ 40,000.45 REGIONS BANK 26,795.26 4,465.88 31,261.14 0.00 $ 31,261.14 2,654.33 442.39 3,096.72 0.00 $ 3,096.72 Sewer Tax Garbage Tax Storm Tax 310.14 16,255.01 14,695.99 GROSS SALES 47,112.15 $ 871.40 $ 7.64 SportsPlex' QTR 857 Sports 1,327.00 221.00 Total $1,548.00< QTR 856 Byrnes Pool 34.00 6.00 40.00 142,722.68 QTR 855 Gates Pool ,..,,ems.,.,, 0.00 0.00 9,990.59 852 Gates 142.00 24.00 166.00 8,563.36 853 Warren 2,827.00 , 471.00 3,298.00 1,427.23 854 South Hills 764.00 127.00 891.00 9,990.59 QTR 601 Leisure'.Offce 747.00 124 00 �.. mmg 871.00 336 Wtr Pollution 34,286.00 5,714.00 40,000.00' 0.00 335 Wtr/Swr/Gbg 26,795.00 4,466.00 31,261.00 8,563,36P 313 Young Arena 2,654.00 442.00 3,096.00 1,427.23 732 SportsPlex 8,563.00 1,427.00 9,990.00 BYRNES SALES TAX 010-37-4200-3475 Mar-23 Byrnes Pool Daily Admissions (4200-3475) Pool Season Passes (4200-3475) Outdoor Pool Rentals (4200-3475) To: Ryan Stuber City Clerks Office Waterloo City Hall From: Courtney Jackson Leisure Services GROSS SALES NET SALES SALES TAX 262.50 245.33 17.17 0.00 0.00 0.00 350.00 327.10 22.90 GROSS SALES TOTAL 612.50 NET SALES TOTAL 572.43 SALES TAX TOTAL 40.07 Firefox https://alo-nw.city.alo/nwerp/Temp/FileStorageCache/3 TDOF 180.htm 1434 - TREASURER, STATE OF 2023-00001769 WATERLOO LEISURE SVCS COMM 03/31/2023 04/17/2023 04/17/2023 04/17/2023 No Gross: 871.40 IOWA 1-07-034601 Invoice Department: CC City Clerk Check Sort Code: TREASURER, STATE OF IOWA Check Code: IOWA DEPT OF REVENUE & FINANCE Manual Check: Confirming EFT PO BOX 10412 Check Number: DES MOINES, IA 50306-0412 Detail: P.O. Number C/D/F/T/A/1099 Description Bank Account: ACCOUNTS PAYABLE Invoice Terms: Hold Reason: Quantity U/M Freight: 0.00 State Tax: 0.00 County Tax: 0.00 Local/City Tax: 0.00 Discount: 0.00 Retainage: 0.00 Net Amount: $871.40 Amount/Unit Total Amount N/Y/Y/N/N/N Conversion Item - L.S. OFFICE GOLF (IMPROV) PERMIT # 107 034601 1.0000 EA 7.6400 7.64 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 - L.S. OFFICE PERMIT #1 07 034601 1.0000 EA 7.64 0.00 863.7600 863.76 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: $871.40 Invoice Amount Unencumbered: $0.00 863.76 0.00 7 of 11 4/11/2023, 10:44 AM June Sept Dec Net Taxable Sales Sales Tax Collected 6% 1% Total Sales Tax Leisure Services - Sports & Pools 2023 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 Re. Im.rov 22,120.00 1,548.40 572.43 40.07 0.00 0.00 2,341.12 163.88 23.36 1.64 46,634.35 3,264.40 477.80 33.45 12,603.27 882.23 135.05 9.45 12,339.49 109.11 ` 863.76 7.641 Difference 1,327.20 221.20 1,548.40 34.35 5.72 40.07 0.00 0.00 0.00 0.00 Total Tax Due $ 1,548.40 Net Taxable Sales Sales Tax Collected 6% 1% Total Sales Tax WM SERVICES Water Pollution 140.47 23.41 163.88 0.00 $ 40.07 0.00 0.00 1.40 0.23 1.64 2,798.06 466.34 3,264.40 28.67 4.78 33.45 756.20 126.03 882.23 Gates - Total 0.00 $ 165.52 GROSS SALE: 0.00 0.00 Warren Mem - Total $ 3,297.85 0.00 8.10 1.35 9.45 740.37 123.39 863.76 0.00 South Hills - Total. $ 891.68 2,364.48 GROSS SALES 47,112.15 GROSS SALES 12,738.32 $ 163.88 $ ; 1.64 $ 3,264.40 $ 33.45 $ 882.23 $ 9.46 Sewer Garbage Storm Wtr Young Arena Difference 571,435.02 40000.45 34,286.10 5,714.35 40,000.45 446,587.71 31,261.14 26,795.26 4,465.88 44,238.79 3,096.72 2,654.33 442.39 31,261.14 3,096.72 0.00 Total Tax Due $ 40,000.45 REGIONS BANK 0.00 $ 31,261.14 0.00 $ 3,096.72 Sewer Tax Garbage Tax Storm Tax 310.14 16,255.01 14,695.99 SportsPlex 142,722.68 9,990.59 8,563.36 0.00 6.55 1.09 7.64 0.00 Leisure - Total...... $ 871.40 3 64: QTR 857 Sports 1,327:00 221.00 :$1,548.00' QTR 856 Byrnes Pool 34.00 6.00 40.00 QTR 855 Gates Pool 000 0. _ 852 Gates 142.00 24.0000 166.00 853 Warren 2,827.00 471.00 3,298.00 1,427.23 854 South Hills 9,990.59 QTR 601 Leisure Office 0.00 8,563.36 1,427.23 $ 9,990.59 336 Wtr Pollution 764.00 747.00 34,286.00 127.00 124.00 5,714.00 891.00 87100 40, 000.00 335 Wtr/Swr/Gbg 313 Young Arena 732 SportsPlex 26,795.00 2,654.00 8,563.00 4,466.00 442.00 1,427.00 31,261.00 3,096.00 9,990.00 WATERLOO LEISURE SERVICES SALES TAX REPORT MARCH 2023 ACTIVITY 4120 - GOLF COURSES 1398 SALES TAX GOLF REVENUE 7% TAX COLLECTED WARREN MEMORIAL 46,634.35 3,264.40 GATES 2,341.12 163.88 SOUTH HILLS 12,603.27 882.23 OFFICE 12,339.49 863.76 73,918.23 5,174.28 ACTIVITY 4125 - GOLF COURSE IMPROVEMENTS 1398 SALES TAX GOLF REVENUE 7% TAX COLLECTED WARREN MEMORIAL 477.80 33.45 GATES 23.36 1.64 SOUTH HILLS 135.05 9.45 OFFICE 109.11 7.64 745.32 52.17 4-6-23 Firefox https://alo-nw.city.alo/nwerp/Temp/FileStorageCache/3TD0F180.htm 1434 - TREASURER, STATE OF 2023-00001770 RECREATION CENTER 1-07-025857 03/31/2023 04/17/2023 04/17/2023 04/17/2023 No Gross: 1,548.40 IOWA (SPORTS) Freight: 0.00 Invoice Department: CC City Clerk Check Sort Code: Bank Account: ACCOUNTS PAYABLE State Tax: 0.00 TREASURER, STATE OF IOWA Check Code: Invoice Terms: County Tax: 0.00 IOWA DEPT OF REVENUE & FINANCE Manual Check: Confirming EFT Hold Reason: Local/City Tax: 0.00 PO BOX 10412 Check Number: Discount: 0.00 DES MOINES, IA 50306-0412 Retainage: 0.00 Net Amount: $1,548.40 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 - SPORTS SALES TAX PERMIT #1 07 025857 1.0000 EA 1,548.4000 1,548.40 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: $1,548.40 Invoice Amount Unencumbered: $0.00 1,548.40 0.00 8 of 11 4/11/2023, 10:44 AM Mar) June Sept Dec Net Taxable Sales Sales Tax Collected 6%' 1% Total Sales Tax Leisure Services - Sports & Pools 2023 YEAR Monthly State Sales Tax QTRLY REPORTING, ONLY,', Leisure Services - Golf Courses Sorts B rnes Gates Gates Warren Memorial South Hills Leisure - Office Re. lm.rov Re. Im.rov Re. Improv Re. Im.rov 22,120.00 1,548.40 572.43 40.07 0.00 0.00 2,341.12 163.88 23.36 1.64 46,634.35 3,264.40 477,80 33.45 12,603.27 882.23 135.05 9.45 12,33949 863.76 10911 7.64. 1,327.20 221.20 1,548.40 34.35 5.72 40.07 0.00 0.00 0.00 140.47 23.41 163.88 1.40 0.23 1.64 2,798.06 466.34 3,264.40 Difference 0.00 0.00 0.00 Total Tax Due $ 1,548.40 Net Taxable Sales Sales Tax Collected 6% 1% Total Sales Tax Difference WM SERVICES Water Pollution $ 40.07 0.00 0.00 Gates - Total $ 165.52 GROSS SALES $ 163.88 $ Sewer Garbage Storm Wtr Young Arena 571,435.02 40,000.45 34,286.10 5,714.35 40,000.45 0.00 Total Tax Due $ 40,000.45 REGIONS BANK 446,587.71 31,261.14 26,795.26 4,465.88 44,238.79 3,096.72 2,654.33 442.39 31,261.14 3,096.72 0.00 $ 31,261.14 0.00 $ 3,096.72 2,364.48 0.00 28.67 4.78 33.45 756.20 126.03 882.23 8.10 1.35 9.45 740.37 123.39 863.76 6.55 1.09 7.64 0.00 0.00 0.00 Warren Mem -.Total South Hills - Total $ 3,297.85 GROSS SALES 47,112.15 1.64 $ 3,264.40 $ 33.45 Sewer Tax Garbage Tax Storm Tax 310,14 16,255.01 14,695.99 $ 891.68 GROSS SALES 12,738.32 0.00 0.00. Cei "sure - Total: -a; I$ 871.40 $ 863.76$ 7,64 SportsPlex QTR 867 Sports 1,327:00 R ,Vla, 221.00 Total $1,548.00: QTR 856 Byrnes Pool 34.00 6.00 40.00 142,722.68 9,990.59 tQTR ;855 Gates Pool , 852 Gates 0 00 142.00 , 0.00 '24.00 166.00 8,563.36 863 Warren 2,827.00 471.00 3,298.00 1,427.23 854 South Hills 764.00 747i00i 34,286.00 127.00 124 00 5,714.00 tt 891.00 87100 40,000.00 9,990.69 iQTR 601 Leisure Office 336 Wtr Pollution 0.00 335 Wtr/Swr/Gbg 26,795.00 4,466.00 31,261.00 8,563.36: 313 Young Arena 2,654.00 442.00 3,096.00 1,427.23' 732 SportsPlex 8,563.00 1,427.00 9,990.00 SPORTS SALES TAX 010-37-4200 Mar-23 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 23,668.40 22,120.00 �0vx 0.00 0.00 0.00 133.75 125.00 8.75 0.00 0.00 0.00 GROSS SALES TOTAL 23,802.15 NET SALES TOTAL 22,245.00 SALES TAX TOTAL 1,557.15 Firefox https://alo-nw.city.alo/nwerp/Temp/FileStorageCache/3TD0F 180.htm 1434 - TREASURER, STATE OF 2023-00001771 SPORTSPLEX 1-07-040732 IOWA 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 03/31/2023 04/17/2023 04/17/2023 04/17/2023 No Gross: 9,990.59 Bank Account: ACCOUNTS PAYABLE Invoice Terms: Hold Reason: Quantity U/M Freight: 0.00 State Tax: 0.00 County Tax: 0.00 Local/City Tax: 0.00 Discount: 0.00 Retainage: 0.00 Net Amount: $9,990.59 Amount/Unit Total Amount N/Y/Y/N/N/N Conversion Item - SALES TAX PERMIT # 1-07-040732 1.0000 EA 9,990.5900 9,990.59 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,990.59 Invoice Amount Unencumbered: $0.00 9,990.59 0.00 9 of 11 4/11/2023, 10:44 AM Mar) June Sept Dec Net Taxable Sales Sales Tax Collected 6% 1% Total Sales Tax Difference Leisure Services - Sports & Pools 2023 YEAR Leisure Services Golf Course Monthly State Sales Tax QTRLY REPORTING ONLY S•orts B rnes Gates Gates Warren Memorial South Hills Leisure - Office Re. Im.rov Re. Im•rov Re Improv Re Im.rov 22,120.00 1,548.40 572.43 40.07 0.00 0.00 2,341.12 163.88 23.36 1.64 46,634..35 3,264.40 477.80 33.45 12,603.27 882.23 135.05 9.45 12,339.49 863.76 109.11 7.64 I,SZ/.ZU 221.20 1,548.40 5.72 40.07 0.00 Total Tax Due 1,548.40 Net Taxable Sales Sales Tax Collected 6% 1% Total Sales Tax Difference WM SERVICES Water Pollution 0.00 $ 40.07 0.00 0.00 0.00 0.00 140.47 23.41 163.88 1.40 0.23 1.64 2,798.06 466.34 3,264.40 0.00 Gates Total .. 0.00 $ 165.52 0.00 28.67 4.78 33.45 0.00 Warren Mem - Total $ 3,297.85 GROSS SALES 2,364.48 GROSS SALES 47,112.15 756.20 8.10 126.03 1.35 882.23 9.45 0.00 740.37 123.39 863.76 6.55 1.09 7.64 South Hills - Total 0.00 $ 891.68 GROSS SALES 12,738.32 $ 163.88 $ 1.641 $ 3,26440 $ i 33.45 $ 882.23 $ 9.46 $ 863.76$ 7.64: 0.00 0.00 Leisure - Total $u': r871.40. Sewer Garbage Storm Wtr Young Arena 571,435.02 40,000.45 34,286.10 5,714.35 40,000.45 0.00 Total Taxi.Due $ 40,000.45 REGIONS BANK 446,587.71 31,261.14 26, 795.26 4,465.88 44,238.79 3,096.72 2,654.33 442.39 31,261.14 3,096.72 0.00 $ 31,261.14 0.00 $ 3,096.72 Sewer Tax Garbage Tax Storm Tax 310.14 16,255.01 14,696.99 6 9, ..n .1y,R_,,,, MA .Total $ OltSPi4it QTR 857m Sports 1,327.00 221 00 $1,548.00 QTR 856 Byrnes Pool 34.00 6.00 40.00 142,722.68 $QTR � 855 Gates Pool 0.00 . 00000 Gates 9,990.59 852 142.00 24.00 166.00 8,563.36 853 Warren 2,827.00 471.00 3,298.00 1,427.23 854 South Hills 764.00 127.00 891.00 9,990.59 QTR ,.601 Leisure Office -747:00 124_.00 871.00 336 Wtr Pollution re 34,286.00 5,714.00 _ �40,000.00 0.00 336 Wtr/Swr/Gbg 26,795.00 4,466.00 31,261.00 8,563:36 313 Young Arena 2,654.00 442.00 3,096.00 1,427.23 732 SportsPlex 8,563.00 1,427.00 9,990.00 SPORTSPLEX SALES TAX 010-37-4180 Mar-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 37,223.06 34,787.91 2,435.15 GROSS SALES TOTAL NET SALES TOTAL SALES TAX TOTAL From: Courtney Jackson Leisure Services 10,678.40 9,979.81 698.59 104,811.81 97,954.96 6,856.85 152,713.27 142,722.68 9,990.59 Firefox https://alo-nw.city.alo/nwerp/Temp/FileStorageCache/3 TDOF 180.htm 1434 - TREASURER, STATE OF 2023-00001772 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 03/31/2023 04/17/2023 04/17/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 04/17/2023 Bank Account: ACCOUNTS PAYABLE Invoice Terms: Hold Reason: Quantity U/M No Gross: 40,000.45 Freight: 0.00 State Tax: 0.00 County Tax: 0.00 Local/City Tax: 0.00 Discount: 0.00 Retainage: 0.00 Net Amount: $40,000.45 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 40,000.4500 40,000.45 Expensed Unencumbered 520-14-5200 1398 ( Sanitary Sewer Fund -Waste Management -Water Pollution -Water Pollution Control Plant Op Sales Tax) Invoice Amount Expensed: $40,000.45 Invoice Amount Unencumbered: 40,000.45 $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 10 $91,163.82 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $91,163.82 $0.00 10 $91,163.82 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $91,163.82 10 of 11 4/11/2023, 10:56 AM Firefox https://alo-nw.city.alo/nwerp/Temp/F ileStorageCache/3TDOF 180.htm Grand Total Unencumbered: $0.00 11 of 11 4/11/2023, 10:56 AM June Sept Dec Net Taxable Sales Sales Tax Collected 6% 1% Total Sales Tax Difference 2023 YEAR Monthly State Sales Tax QTRLY REPORTING ONLY Leisure Services - Sports & Pools Leisure Services - Golf Courses Sorts B rnes Gates Gates Warren Memorial South Hills Leisure - Office Re Im•rov Re Im•rov Re• Improv Re Im•rov 22,120.00 1,548.40 572.43 40.07 0.00 0.00 2,341.12 163.88 23.36 1.64 46,634.35 3,264.40 477.80 33.45 12,603.27 882.23 135.05 9.45 12,339.49 863.76 109.11`' 7.64 1,327.20 221.20 1,548.40 34.35 5.72 40.07 0.00 Total Tax Due $ 1,548.40 WM SERVICES water Pollution Net Taxable Sales Sales Tax Collected 6% 1% Total Sales Tax Difference 571,435.02 40,000.45 34,286.10 5,714.35 40,000.45 0.00 0.00 0.00 140.47 23.41 163.88 1.40 0.23 1.64 0.00 0.00 0.00 0.00 40.07 Gates - Total. $ 165.52 GROSS SALES 2,798.06 466.34 3,264.40 28.67 4.78 33.45 0.00 0.00 Warren Mem -.Total, $ 3,297.85 756.20 126.03 882.23 8.10 1.35 9.45 0.00 0.00 South Hills - Total $ 891.68 2,364.48 GROSS SALES 47,112.15 GROSS SALES 12,738.32 $ 163.88 $ 1.64 , $ 3,264.40 $ 33.45$ 882.23 $ 9.45 $ 740.37 123.39 863.76 6.55 1.09 7.64 Sewer Garbage Storm Wtr Young Arena 0.00 Total Tax .Duei, $ 40,000.45 REGIONS BANK 446,587.71 31,261.14 26,795.26 4,465.88 44,238.79 3,096.72 2,654.33 442.39 31,261.14 3,096.72 0.00 $ 31,261.14 0.00 $ 3,096.72 Sewer Tax Garbage Tax Storm Tax 310.14 16,255.01 14,695.99 0.00 0.00 Leisure - Total .< $ 871.40 863.76 7.64' SportsPlex 6 e <•� Sports �QTR 867 po ° ,@_.a, 1,327.00 1° � 0 22100 Total , $1 $1548. 0 . QTR 856 Byrnes Pool 34.00 6.00 40.00 142,722.68 PQTR 856 Gates Pool 0.00 0.00 9,990.59 852 Gates 142.00 24.00 166.00 8,563.36 853 Warren 2,827.00 471.00 3,298.00 1,427.23 854 South Hills 764.00 127.00 891.00 9,990.59 1QTR 601 Leisure Office 747,00 124.00 w 871.00> 336 Wtr Pollution 34,286.00� 5,714 00 40,000.00 0.00 335 Wtr/Swr/Gbg 26,795.00 4,466.00 31,261.00 8,563.36 313 Young Arena 2,654.00 442.00 3,096.00 1,427.23 732 SportsPlex 8,563.00 1,427.00 9,990.00 9,990.59 TAX REPORT FOR FEBRUARY 2022 WASTE MANAGEMENT SERVICES Billing Dated 02/24/22 JANUARY 2023 USEAGE NON-TAXABLE ACTIVITY ACCT.a COMPANY NET BILLED TOTAL BILLED 5452 BLACK HAWK CARE FACILITY Na - 5453 BLACK HAWK COUNTY SOLID WASTE 3,746.81 Na 3,7413.81 5641 BLACK HAWK COUNTY LANDFILL PRET 177.60 Na 1T7.60 14061 WATERLOO PROCESSING LLC 1.693.05 Na 1,693.05 5644 TYSON FOODS PRET 1,71640 Na 1716.40 7518 CONAGRA PRET 1,136.40 - 1,136.40 CONAGRA 5,798.47 Na 5,7913.47 12488 PLANERGY Na - 10943 CA4ADIAN NATIONAL GROUNDWATER Na - 5641 BLACK HAWK COUNTY LANDFILL PRET-FEES/PERM Na - 7518 CONAGRA PRET-FEES/PERM Na - 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 Na - 10521 CANADIAN NATIONAL RAILWAY-FEES/PERM Na - 21969 ALLAN INDUSTRIAL COATINGS-FEES/PERMNa - 13874 J.D. PEG-FEESPERM Na - 5640 ARAMARK UNIFORM SERVICES -FEES/PERM Na - 6464 DARLING INTERNATIONAL FEES/PERM n/a - 5643 HYDRITEFEESPERM n/a - 12935 IOWA NORTHERN RAILWAY-FEES/PERM n/a - 20973 Renews Co ICrown Group) Na - 14061 waatERLOO PROCESSING LLC/labfeepermit Na - 14061 WATERLOO PROCESSING LLC Na 5644 TYSON FRESH MEATS INC-FEES/PERM Na - 12935 IOWA NORTHERN RAILWAY n/a - 22509 EVANSDALE 140.00 Na 140.00 5456 TYSON FRESH MEATS Credit n/a - 14408.73 0.00 14,408.73 TAXABLE ACTIVITY ACCT6 COMPANY TAXED APPLIED TOTAL BILLED 5451 ARAMARK 4,893.06 349.51 5,34267 14060 WATERLOO PROCESSING LLC 41,328A1 2,892.99 44,221.40 5456 TYSON FOODS 442,255.35 30,957.87 473,213.22 5457 JOHN DEERE - DONALD STREET 7,319.80 512.37 7,831.97 5458 JOHN DEERE- ENGINE WORKS 1,898.98 132.93 2,031.91 5459 JOHN DEERE - FOUNDRY 8001 784.411 54.91 839.37 5480 JOHN DEERE- FOUNDRY 8002 - - 5481 JOHN DEERE • PEG 1,868.36 130.79 1,999.15 5462 JOHN DEERE - BLDO 1020H021 11,679.00 831.53 12,710.53 5483 JD • WESTFIELD 8. JEFFERSON 7,045.89 493.21 7,539.10 12409 JOHN DEERE WBJ - BLDG A 847.04 59.29 906.33 5838 DRAIN DOCTOR 20.00 1.40 21A0 22538 NUTRI JECT SYSTEMS - - 5951 KAYSER PLUMBING - - 6657 CONAGRA GROCERY PRODUCTS 33,384.92 2,336.94 35,721.86 8960 HYDRITE CHEMICAL CO 247.82 17.35 285.17 7291 DARLING INTERNATIONAL - 7324 BLACK HAWK WASTE - 8747 LOST ISLAND METER 37.20 2.60 39.60 12557 A-1 SEPTIC 1,140.00 79.80 1,219.80 11070 CLEANTRAP SERVICES 22385 ROTO ROOTER 40.00 2.80 42.60 14452 VET1 TRUCK WASH 7,101.10 497.08 7,598.18 5452 Black Hawk Nursing S Rabab 4,142.63 289.98 4,432.61 22871 CEDAR VALLEY PORTABLES - - 20319 PAUL COOLEY PUMPING COOLEY PUMPING 260.00 1820 278.20 20321 GREENS'S SEPTIC SERVICE 60 4.20 64.20 23496 Advanced Draln9pe 4,701.20 329.08 5,030.28 23461 A Plus Septic 80.00 5.60 85.60 SUBTOTAL TAXABLE $ 571,480.92 $ 40600.43 $ 811,435A5 - � Oon6 Total S 585,943.75 $ 40,000A3 S 825,644.18 Grand total or Posting S Grand total or Postlrg Grand total of Posting Grand total of Posting 625,644.18 REVegaNUE Name: CITY OF WATERLOO Account ID: 1-07-025852 Filing Period: 31-Mar-2023 Date: 18-Apr-2023 Confirmation Number: 0-003-382-784 Sales and Use Return Summary Sales Tax Gross Sales Goods Consumed Total Exemptions Taxable Amount State Sales Tax (6%) Local Option Sales Tax $2,364.55 $0.00 $0.00 $2,364.55 $141.87 $23.65 Use Tax Total Taxable Purchases $0.00 Sales Subject to Use Tax $0.00 Taxable Amount $0.00 Use Tax $0.00 Final Balances Deposits/Overpayment Credit $0.00 Total Tax & Surcharge $165.52 Balance $165.52 Total Amount Due $165.52 Payment Information Bank Name REGIONS BANK Account Number ****6001 Amount $165.52 Payment Date 18-Apr-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-382-784 Date: 18-Apr-2023 Taxable Sales Local Option Local Option Tax (1.00%) Black Hawk County - 07 $2,364.55 $23.65 $2,364.55 $23.65 This is a summary only and will not be accepted as a return by the Iowa Department of Revenue. Retain this document for personal records. rtment iowa of REVeEaNUE Sales and Use Return Summary Sales Tax Use Tax Final Balances Payment Information Name: CITY OF WATERLOO Account ID: 1-07-025853 Filing Period: 31-Mar-2023 Date: 18-Apr-2023 Confirmation Number: 0-003-360-577 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 $47,112.15 $0.00 $0.00 $47,112.15 $2,826.73 $471.12 $0.00 $0.00 $0.00 $0.00 Deposits/Overpayment Credit $0.00 Total Tax & Surcharge $3,297.85 Balance $3,297.85 Total Amount Due $3,297.85 Bank Name REGIONS BANK Account Number ****6001 Amount $3,297.85 Payment Date 18-Apr-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-360-577 Date: 18-Apr-2023 Taxable Sales Local Option Local Option Tax (1.00%) Black Hawk County - 07 $47,112.15 $47,112.15 $471.12 $471.12 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. artment of VNUE Sales and Use Return Summary Sales Tax Name: CITY OF WATERLOO Account ID: 1-07-025854 Filing Period: 31-Mar-2023 Date: 18-Apr-2023 Confirmation Number: 0-003-401-601 Gross Sales Goods Consumed Total Exemptions Taxable Amount State Sales Tax (6%) Local Option Sales Tax $12,738.32 $0.00 $0.00 $12,738.32 $764.30 $127.38 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 $891.68 Balance $891.68 Total Amount Due $891.68 Payment Information Bank Name REGIONS BANK Account Number ****6001 Amount $891.68 Payment Date 18-Apr-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-401-601 Date: 18-Apr-2023 Taxable Sales Local Option Local Option Tax (1.00%) Black Hawk County - 07 $12,738.32 $12,738.32 $127.38 $127.38 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. ,a Department ol REVENUE Sales and Use Return Summary Sales Tax Name: CITY OF WATERLOO Account ID: 1-07-025856 Filing Period: 31-Mar-2023 Date: 18-Apr-2023 Confirmation Number: 0-003-397-441 Gross Sales Goods Consumed Total Exemptions Taxable Amount State Sales Tax (6%) Local Option Sales Tax $572.43 $0.00 $0.00 $572.43 $34.35 $5.72 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 $40.07 Balance $40.07 Total Amount Due $40.07 Payment Information Bank Name REGIONS BANK Account Number ****6001 Amount $40.07 Payment Date 18-Apr-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-397-441 Date: 18-Apr-2023 Taxable Sales Local Option Local Option Tax (1.00%) Black Hawk County - 07 $572.43 $5.72 $572.43 $5.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. De artment of REV NUE Sales and Use Return Summary Sales Tax Use Tax Final Balances Payment Information Name: CITY OF WATERLOO Account ID: 1-07-025857 Filing Period: 31-Mar-2023 Date: 18-Apr-2023 Confirmation Number: 0-003-389-249 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 $22,120.00 $0.00 $0.00 $22,120.00 $1,327.20 $221.20 $0.00 $0.00 $0.00 $0.00 Deposits/Overpayment Credit $0.00 Total Tax & Surcharge $1,548.40 Balance $1,548.40 Total Amount Due $1,548.40 Bank Name REGIONS BANK Account Number ****6001 Amount $1,548.40 Payment Date 18-Apr-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-389-249 Date: 18-Apr-2023 Taxable Sales Local Option Local Option Tax (1.00%) Black Hawk County - 07 $22,120.00 $22,120.00 $221.20 $221.20 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. REN VEUE 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-Mar-2023 Date: 18-Apr-2023 Confirmation Number: 0-003-395-218 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 $446,587.71 $0.00 $0.00 $446,587.71 $26,795.26 $4,465.88 $0.00 $0.00 $0.00 $0.00 Deposits/Overpayment Credit $0.00 Total Tax & Surcharge $31,261.14 Balance $31,261.14 Total Amount Due $31,261.14 Bank Name REGIONS BANK Account Number ****6001 Amount $31,261.14 Payment Date 18-Apr-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-395-218 Date: 18-Apr-2023 Taxable Sales Local Option Local Option Tax (1.00%) Black Hawk County - 07 $446,587.71 $446,587.71 $4,465.88 $4,465.88 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. ea REVENUE Sales and Use Return Summary Sales Tax Use Tax Final Balances Payment Information Name: CITY OF WATERLOO Account ID: 1-07-030336 Filing Period: 31-Mar-2023 Date: 18-Apr-2023 Confirmation Number: 0-003-354-258 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 $571,435.02 $0.00 $0.00 $571,435.02 $34,286.10 $5,714.35 $0.00 $0.00 $0.00 $0.00 Deposits/Overpayment Credit $0.00 Total Tax & Surcharge $40,000.45 Balance $40,000.45 Total Amount Due $40,000.45 Bank Name REGIONS BANK Account Number ****6001 Amount $40,000.45 Payment Date 18-Apr-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-354-258 Date: 18-Apr-2023 Taxable Sales Local Option Local Option Tax (1.00%) Black Hawk County - 07 $571,435.02 $5,714.35 $571,435.02 $5,714.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. ent of REVS aNUE Sales and Use Return Summary Sales Tax Use Tax Final Balances Payment Information Name: CITY OF WATERLOO Account ID: 1-07-034601 Filing Period: 31-Mar-2023 Date: 18-Apr-2023 Confirmation Number: 0-003-373-743 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 $12,448.55 $0.00 $0.00 $12,448.55 $746.91 $124.49 $0.00 $0.00 $0.00 $0.00 Deposits/Overpayment Credit $0.00 Total Tax & Surcharge $871.40 Balance $871.40 Total Amount Due $871.40 Bank Name REGIONS BANK Account Number ****6001 Amount $871.40 Payment Date 18-Apr-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-373-743 Date: 18-Apr-2023 Taxable Sales Local Option Local Option Tax (1.00%) Black Hawk County - 07 $12,448.55 $12,448.55 $124.49 $124.49 This is a summary only and will not be accepted as a return by the Iowa Department of Revenue. Retain this document for personal records. rtment of RE V`taN U E Sales and Use Return Summary Sales Tax Use Tax Final Balances Payment Information Name: CITY OF WATERLOO Account ID: 1-07-037313 Filing Period: 31-Mar-2023 Date: 18-Apr-2023 Confirmation Number: 0-003-356-872 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 $44,238.79 $0.00 $0.00 $44,238.79 $2,654.33 $442.39 $0.00 $0.00 $0.00 $0.00 Deposits/Overpayment Credit $0.00 Total Tax & Surcharge $3,096.72 Balance $3,096.72 Total Amount Due $3,096.72 Bank Name REGIONS BANK Account Number ****6001 Amount $3,096.72 Payment Date 18-Apr-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-356-872 Date: 18-Apr-2023 Taxable Sales Local Option Local Option Tax (1.00%) Black Hawk County - 07 $44,238.79 $442.39 $44,238.79 $442.39 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. r; J,, artment of REVENUE Sales and Use Return Summary Sales Tax Use Tax Final Balances Payment Information Name: CITY OF WATERLOO Account ID: 1-07-040732 Filing Period: 31-Mar-2023 Date: 18-Apr-2023 Confirmation Number: 0-003-348-143 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 $142,722.68 $0.00 $0.00 $142,722.68 $8,563.36 $1,427.23 $0.00 $0.00 $0.00 $0.00 Deposits/Overpayment Credit $0.00 Total Tax & Surcharge $9,990.59 Balance $9,990.59 Total Amount Due $9,990.59 Bank Name REGIONS BANK Account Number *'6001 Amount $9,990.59 Payment Date 18-Apr-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-348-143 Date: 18-Apr-2023 Taxable Sales Local Option Local Option Tax (1.00%) Black Hawk County - 07 $142,722.68 $142,722.68 $1,427.23 $1,427.23 This is a summary only and will not be accepted as a return by the Iowa Department of Revenue. Retain this document for personal records.