The URL can be used to link to this page

Home My WebLink AboutAprilFirefox https://alo-nw.city.alo/nwerp/Temp/FileStorageCache/3TDOF4D2.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-00001996 Invoice Department: CC City Clerk TREASURER, STATE OF IOWA IOWA DEPT OF REVENUE & FINANCE PO BOX 10412 DES MOINES, IA 50306-0412 Batch Date: 05/15/2023 Batch Number: 2023-00001356 Batch Description: IRV WARREN MEMORIAL GOLF 04/30/2023 05/15/2023 05/15/2023 05/15/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: 7,502.20 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 74.9200 74.92 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 74.92 0.00 7,427.2800 7,427.28 Expensed Unencumbered 010-37-4120 1398 ( General Fund -Leisure Services -Golf Courses Sales Tax) Invoice Amount Expensed: $7,502.20 Invoice Amount Unencumbered: $0.00 7,427.28 0.00 $7,502.20 1 of 11 5/8/2023, 9:23 AM Jan Apr July Oct Net Taxable Sales Sales Tax Collected 1% Total Sales Tax Difference Leisure Services - Sports & Pools Sports 2,361.00 165.27 141.66 23.61 165.27 B rnes 4,497.15 314.80 269.83 44.97 314.80 Gates 2023 YEAR Gates 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Total Tax Duel $ 165.27 I $ 314.80 L Net Taxable Sales Sales Tax Collected 6% 1% Total Sales Tax Difference WM SERVICES Water Pollution 517,411.24 36,218.79 31,044.67 5,174.11 36,218.79 0.00 Total Tax Due $ 36,218.79 REGIONS BANK 0.00 Re 71,321.73 4,992.52 4,279.30 713.22 4,992.52 Improv Monthly State Sales Tax Leisure Services Golf Courses Warren Memorial Re Improv 702.10 49.15 42.13 7.02 106,103.97 7,427.28 6,366.24 1,061.04 49.15 7,427.28 1,070.33 74.92 64.22 10.70 74.92 South Hills Reg 75,623.60', 5,293.65'1 4,537.42 756.24 5,293.65 Improv Leisure - Office 769.86 53.89 46.19 7.70 53.89 0.0D 0.00 0.00 0.00 Gates - Total Warren Mem - Total I $ 5,041.67 I $ 7,502.20 (GROSS SALES 72,023.83 'GROSS SALES 107,174.30 $ 4,992.52 $ 49.15 $ 7,427.28 $ 74.92 Sewer Garbage Storm Wtr Young Arena 144,861.00 10,140.27 8,691.66 1,448.61 27,578.50 1,930.50 1,654.71 275.79 10,140.27 1,930.50 0.00 $ 10,140.27 0.00 $ 1,930.50 Sewer Tax Garbage Tax Storm Tax 5,469.61 3.48 4,667.18 SportsPlex 127,236.17 8,906.53 7,634.17 1,272.36 8,906.53 0.00 7,634.17 1,272.36 $ 8,906.53 0.00 D.00 South Hills - Total $ 5,347.54 'GROSS SALES 76,393.46 $ 5,293.65 $ 53.89 Re Im rov 6,556.07 45.79 458.92 3.21 393.36 65.56 458.92 2.75 0.46 3.21 0.00 0.00 Leisure - Total $ 462.13 458.92 $ 3.21 6% 1% Total QTR 857 Sports 141.66 23.61 $ 165.27 QTR 856 Byrnes Pool 269.83 44.97 314.80 QTR 855 Gates Pool 0.00 0.00 - 852 Gates 4,321.00 720.00 5,041.00 853 Warren 6,430.00 1,072.00 7,502.00 854 South Hills 4,584.00 764.00 5,348.00 QTR 601 Leisure Office 396.00 66.00 462.00 336 Wtr Pollution 31,045.00 5,174.00 36,219.00 335 Wtr/Swr/Gbg 8,692.00 1,449.00 10,141.00 313 Young Arena 1,655.00 276.00 1,931.00 732 SportsPlex 7,634.00 1,272.00 8,906.00 WATERLOO LEISURE SERVICES SALES TAX REPORT APRIL 2023 ACTIVITY 4120 - GOLF COURSES 1398 SALES TAX GOLF REVENUE 7% TAX COLLECTED WARREN MEMORIAL 106,103.97 7,427.28 GATES 71,321.73 4,992.52 SOUTH HILLS 75,623.60 5,293.65 OFFICE 6,556.07 458.92 259, 605.37 18,172.38 ACTIVITY 4125 - GOLF COURSE IMPROVEMENTS 1398 SALES TAX GOLF REVENUE 7% TAX COLLECTED WARREN MEMORIAL 1,070.33 74.92 GATES 702.10 49.15 SOUTH HILLS 769.86 53.89 OFFICE 45.79 3.21 2,588.08 181.17 4-3-23 Firefox https://alo-nw.city.alo/nwerp/Temp/FileStorageCache/3TD0F4D2.htm 1434 - TREASURER, STATE OF 2023-00001997 IOWA1 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 04/30/2023 05/15/2023 05/15/2023 05/15/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,041.67 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 49.1500 49.15 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 - GATES GOLF COURSE 1.0000 EA PERMIT #1 07 025852 G/L Distribution: G/L Account/Project Total Invoice Items: 2 49.15 4,992.5200 0.00 4.992.52 Expensed Unencumbered 010-37-4120 1398 ( General Fund -Leisure Services -Golf Courses Sales Tax) Invoice Amount Expensed: $5,041.67 Invoice Amount Unencumbered: $0.00 4,992.52 0.00 $5,041.67 2 of 11 5/8/2023, 9:23 AM Jan Apr July Oct Net Taxable Sales Sales Tax Collected 6% 1% Total Sales Tax Difference Leisure Services - Sports & Pools Sports 2,361.00 165.27 141 .66 23.61 165.27 B rnes 4,497.15 314.80 269.83 44.97 314.80 Gates 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Total Tax Duel $ 165.27 I I $ 314.80 I L Net Taxable Sales Sales Tax Collected 6% 1% Total Sales Tax Difference WM SERVICES Water I Pollution 517,411.24 36,218.79', 31, 044.67 5,174.11 0.00 2023 YEAR Monthly State Sales Tax Leisure Services - Golf Courses Ga Re 71,321.73 4,992.52 4,279.30 713.22 4,992.52 es 1 Improv 702.10 49.15 42.13 7.02 49.15 Warren Memorial Re 106,103.97 7,427.28 6,366.24 1,061.04 7,427.28 Im rov 1,070.33 74.92 64.22 10.70 74.92 0.00 0.00 Gates - Total I $ 5,041.67 (GROSS SALES 72,023.83 $ 4,992.52 $ 49.15 Sewer Garbage Storm Wtr 144,861.00 10,140.27 8,691.66 1,448.61 Young Arena 27,578.50 1,930.50 1,654.71 275.79 36,218.79 10,140.27 1,930.50 0.00 Total Tax Due $ 36,218.79 REGIONS BANK 0.00 $ 10,140.27 000 $ 1,930.50 Sewer Tax Garbage Tax Storm Tax 5,469.61 3.48 4,667.18 0.00 South Hills Re 75,623.60 5,293.65 4,537.42 756.24 Improv 769.86 53.89 46.19 7.70 5,293.65 53.89 Leisure - Office Re 6,556.07 458.92 393.36 65.56 Im rov 45.79 3.21 2.75 0.46 458.92 3.21 0.00 0.00 0.00 0.00 Warren Mem - Total South Hills - Total Leisure - Total I $ 7,502.20 I $ 5,347.54 (GROSS SALES 107,174.30 (GROSS SALES 76,393.46 $ 7,427.28 $ 74.92 $ 5,293.65 $ 53.89 $ 458.92 $ 3.21 0.00 SportsPlex 127,236.17 8,906.53 7,634.17 1,272.36 8,906.53 0.00 7,634.17 1,272.36 $ 8,906.53 $ 462.13 6% 1% Total QTR 857 Sports 141.66 23.61 $ 165.27 QTR 856 Byrnes Pool 269.83 44.97 314.80 QTR 855 Gates Pool 0.00 0.00 - 852 Gates 4,321.00 720.00 5,041.00 853 Warren 6,430.00 1,072.00 7,502.00 854 South Hills 4,584.00 764.00 5,348.00 QTR 601 Leisure Office 396.00 66.00 462.00 336 Wtr Pollution 31,045.00 5,174.00 36,219.00 335 Wtr/Swr/Gbg 8,692.00 1,449.00 10,141.00 313 Young Arena 1,655.00 276.00 1,931.00 732 SportsPlex 7,634.00 1,272.00 8,906.00 WATERLOO LEISURE SERVICES SALES TAX REPORT APRIL 2023 ACTIVITY 4120 - GOLF COURSES 1398 SALES TAX GOLF REVENUE 7% TAX COLLECTED WARREN MEMORIAL 106,103.97 7,427.28 GATES 71,321.73 4,992.52 SOUTH HILLS 75,623.60 5,293.65 OFFICE 6,556.07 458.92 259,605.37 18,172.38 ACTIVITY 4125 - GOLF COURSE IMPROVEMENTS 1398 SALES TAX GOLF REVENUE 7% TAX COLLECTED WARREN MEMORIAL 1,070.33 74.92 GATES 702.10 49.15 SOUTH HILLS 769.86 53.89 OFFICE 45.79 3.21 2,588.08 181.17 4-3-23 Firefox https://alo-nw.city.alo/nwerp/Temp/FileStorageCache/3 TD0F4D2.htm 1434 - TREASURER, STATE OF 2023-00001998 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 04/30/2023 05/15/2023 05/15/2023 05/15/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/f/A/1099 Description Quantity U/M No Gross: Freight: State Tax: County Tax: Local/City Tax: Discount: Retainage: Net Amount: 5,347.54 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 53.8900 53.89 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 53.89 0.00 5,293.6500 5,293.65 Expensed Unencumbered 010-37-4120 1398 ( General Fund -Leisure Services -Golf Courses Sales Tax) Invoice Amount Expensed: $5,347.54 Invoice Amount Unencumbered: $0.00 5,293.65 0.00 $5,347.54 3 of 11 5/8/2023, 9:23 AM Jan Apr July Oct Net Taxable Sales Sales Tax Collected 6% 1% Total Sales Tax Difference Leisure Services - Sparts & Pools 2023 YEAR Monthly State Sales Tax Leisure Services - Golf Courses Sports B rnes Gates Gates Warren Memorial South Hills Leisure - Office Reg Improv Re. Im.rov .. Re Im.rov Re Im .rov 2,361.00 165.27 4,497.15 314.80 0.00 0.00 71,321.73 4,992.52 702.10 49.15 106,103.97 7,427.28 1,070.33 74.92 75,623.60 5,293.65 769.86 53.89 6,556.07 458.92 45.79 3.21--'' 141.66 23.61 165.27 269.83 44.97 314.80 0.00 0.00 0.00 Total Tax Duel $ 0.00 0.00 165.27I $ 314.80 L WM SERVICES Net Taxable Sales Sales Tax Collected 6% 1% Total Sales Tax Difference Water Pollution 517,411.24 36,218.79 31,044.67 5,174.11 0.00 4,279.30 713.22 4,992.52 42.13 7.02 49.15 6,366.24 1.061 04 7,427.28 64.22 10.70 74.92 4,537.42 756.24 5,293.65 46.19 7.70 53.89 0.0D 0.00 Gates- Total I $ 5,041.67 [GROSS SALES 72,023.83 $ 4,992.52 $ 49.15 Sewer Garbage Storm Wtr Young Arena 144,861.00 10,140.27 27,578.50 1,930.50 8,691.66 1,448.61 1,654.71 275.79 36,218.79 10,140.27 1,930.50 0.00 Total Tax Due $ 36,218.79 REGIONS BANK 0.00 $ 10,140.27 0.00 $ 1,930.50 Sewer Tax Garbage Tax Storm Tax 5,469.61 3.48 4,667.18 0.00 0.00 0.00 0.00 Warren Mem - Total South Hills - Total I $ 7,502.20 I $ 5,347.54 (GROSS SALES 107,174.30 (GROSS SALE 76,393.46 $ 7,427.28 $ 74.92 SportsPlex 127,236.17 8,906.53 7,634.17 1,272.36 8,906.53 0.00 7,634.17 1,272.36 $ 8,906.53 393.36 65.56 458.92 2.75 0.46 3.21 0.00 Leisure - Total 0.00 $ 462.13 $ 5,293.65 $ 53.89 $ 458.92 $ 3.21 6% 1 1% Total QTR 857 Sports 141.66 23.61 $ 165.27 QTR 856 Byrnes Pool 269.83 44.97 314.80 QTR 855 Gates Pool 0.00 0.00 - 852 Gates 4,321.00 720.00 5,041.00 853 Warren 6,430.00 1,072.00 7,502.00 854 South Hills 4,584.00 764.00 5,348.00 QTR 601 Leisure Office 396.00 66.00 462.00 336 Wtr Pollution 31,045.00 5,174.00 36,219.00 335 Wtr/Swr/Gbg 8,692.00 1,449.00 10,141.00 313 Young Arena 1,655.00 276.00 1,931.00 732 SportsPlex 7,634.00 1,272.00 8,906.00 WATERLOO LEISURE SERVICES SALES TAX REPORT APRIL 2023 ACTIVITY 4120 - GOLF COURSES 1398 SALES TAX GOLF REVENUE 7% TAX COLLECTED WARREN MEMORIAL 106,103.97 7,427.28 GATES 71,321.73 4,992.52 SOUTH HILLS 75,623.60 5,293.65 OFFICE 6,556.07 458.92 259, 605.37 18,172.38 ACTIVITY 4125 - GOLF COURSE IMPROVEMENTS 1398 SALES TAX GOLF REVENUE 7% TAX COLLECTED WARREN MEMORIAL 1,070.33 74.92 GATES 702.10 49.15 SOUTH HILLS 769.86 53.89 OFFICE 45.79 3.21 2,588.08 181.17 4-3-23 Firefox https://alo-nw.city.alo/nwerp/Temp/FileStorageCache/3TDOF4D2.htm 1434 - TREASURER, STATE OF 2023-00001999 YOUNG ARENA 1-07-037313 04/30/2023 05/15/2023 05/15/2023 05/15/2023 No Gross: 1,930.50 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: $1,930.50 Detail: P.O. Number C/D/F/T/A/1099 Description Quantity U/M Amount/Unit Total Amount N/Y/Y/N/N/N Conversion Item - YOUNG ARENA PERMIT #1 07 037313 G/L Distribution: G/L Account/Project 1.0000 EA 1,930.5000 1,930.50 Expensed Unencumbered 010-37-4500 1398 ( General Fund -Leisure Services -Young Arena Sales Tax) Total Invoice Items: 1 Invoice Amount Expensed: $1,930.50 Invoice Amount Unencumbered: $0.00 1,930.50 0.00 4 of 11 5/8/2023, 9:23 AM Jan Apr July Oct Leisure Services - Sports & Pools Sports Net Taxable Sales 2,361.00 Sales Tax Collected 165.27 6% 141.66 1% 23.61 Total Sales Tax 165.27 B rnes 4,497.15 314.80 269.83 44.97 314.80 Gates 0.00 0.00 0.00 0.00 0.00 2023 YEAR Monthly State Sales Tax Leisure Services - Golf Courses Gates Re Im rov 71,321.73 702.10 4,992.52 49.15 4,279.30 713.22 4,992.52 42.13 7.D2 49.15 Warren Memorial Re 106,103.97 7,427.28 6,366.24 1,061.04 7,427.28 Im rov 1,070.33 74.92 South Hills Re Improv 75,623.60 769.86 5,293.65 53.89 64.22 4,537.42 10.70 756.24 74.92 5,293.65 46.19 7.70 53.89 Difference 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Total Tax Duel $ Net Taxable Sales Sales Tax Collected 6% 1% Total Sales Tax 165.27 I $ 314.80 L WM SERVICES Water Pollution 517,411.24 36,218.79 Difference 31,044.67 5,174.11 Gates - Total I $ 5,041.67 I $ 7,502.20 (GROSS SALES 72,023.83 IGROSS SALES 107,174.30 $ 4,992.52 $ 49.15 $ 7,427.28 $ 74.92 Sewer Garbage Storm Wtr Young Arena 144,861.00 10,140.27 8,691.66 1,448.61 27,578.50 1,930.50 1,654.71 275.79 36,218.79 10,140.27 1,930.50 0.00 Total Tax Due $ 36,218.79 REGIONS BANK 0.00 $ 10,140.27 0.00 $ 1,930.50 Sewer Tax Garbage Tax Storm Tax 5,469.61 3.48 4,667.18 Warren Mem - Total SportsPlex 127,236.17 8,906.53 7,634.17 1,272.36 8,906.53 0.00 7,634.17 1, 272.36 $ 8,906.53 South Hills - Total I $ 5,347.54 (GROSS SALES 76,393.46 $ 5,293.65 $ 53.89 Leisure - Office Re 6,556.07 458.92 393.36 65.56 Im rov 45.79 3.21 2.75 0.46 458.92 3.21 0.00 0.00 Leisure - Total $ 462.13 $ 458.92 $ 3.21 QTR 857 Sports 6% 141.66 1% 23.61 Total $ 165.27 QTR 856 Byrnes Pool 269.83 44.97 314.80 QTR 855 Gates Pool 0.00 0.00 - 852 Gates 4,321.00 720.00 5,041.00 853 Warren 6,430.00 1,072.00 7,502.00 854 South Hills 4,584.00 764.00 5,348.00 QTR 601 Leisure Office 396.00 66.00 462.00 336 Wtr Pollution 31,045.00 5,174.00 36,219.00 335 Wtr/Swr/Gbg 8,692.00 1,449.00 10,141.00 313 Young Arena 1,655.00 276.00 1,931.00 732 SportsPlex 7,634.00 1,272.00 8,906.00 5/5/2023 YOUNG ARENA SALES TAX 010-37-4500-1398 Gross Taxable Sales April 2023 29,509.00 Net Taxable Sales April 2023 27,578.50 Total Tax April 2023 1,930.50 To: Ryan Stuber City Clerks Office Waterloo City Hall From: Madonna Welsh Leisure Services Firefox https://alo-nw.city.alo/nwerp/Temp/FileStorageCache/3TD0F4D2.htm 1434 - TREASURER, STATE OF 2023-00002000 IOWA Invoice Department: CC City Clerk TREASURER, STATE OF IOWA IOWA DEPT OF REVENUE & FINANCE PO BOX 10412 DES MOINES, IA 50306-0412 STORMWATER + SEWER + GARBAGE 1-07-030335 Check Sort Code: Check Code: Manual Check: Confirming EFT Check Number: Detail: P.O. Number C/D/F/T/A/1099 Description 04/30/2023 05/15/2023 05/15/2023 05/15/2023 Bank Account: ACCOUNTS PAYABLE Invoice Terms: Hold Reason: Quantity U/M No Gross: 10,140.27 Freight: 0.00 State Tax: 0.00 County Tax: 0.00 Local/City Tax: 0.00 Discount: 0.00 Retainage: 0.00 Net Amount: $10,140.27 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 3.4800 3.48 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 3.48 5,469.6100 Expensed 0.00 5,469.61 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 5,469.61 0.00 4,667.1800 4,667.18 Expensed Unencumbered 521-07-7830 1398 ( Storm Water Fund -City Engineer -City Engineer Sales Tax) Invoice Amount Expensed: $10,140.27 Invoice Amount Unencumbered: $0.00 4,667.18 0.00 5 of 11 5/8/2023, 9:23 AM Jan Apr July Oct Net Taxable Sales Sales Tax Collected 6% 1% Total Sales Tax Leisure Services - Sports & Pools Sports 2,361.00 165.27 141.66 23.61 B rnes 4,497.15 314.80 269.83 44.97 Gates 2023 NEAR Monthly State Sales Tax Leisure Services - Golf Courses Gates Reg 165.27 314.80 0.00 0.00 0.00 0.00 0.00 71,321.73 4,992.52 4,279.30 713.22 Im rov 702.10 49.15 42.13 7.02 4,992.52 49.15 Warren Memorial Re Im rov 106,103.97 1,070.33 7,427.28 74.92 6,366.24 64.22 1,061.04 10.70 South Hills Re 75,623.60 5,293.65 4,537.42 756.24 Improv Leisure - Office 769.86 53.89 46.19 7.70 7,427.28 74.92 5,293.65 53.89 Re 6,556.07 458.92 393.36 65.56 Im rov 45.79 3.21 2.75 0.46 458.92 3.21 Difference 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Total Tax Duel $ 165.27 I $ 314.80 1 L Net Taxable Sales Sales Tax Collected 6% 1% Total Sales Tax Difference WM SERVICES Water Pollution Gates - Total Warren Mem - Total South Hills - Total $ 5,041.67 I $ 7,502.20 I $ 5,347.54 (GROSS SALES 72,023.83 IGROSS SALES 107,174.30 IGROSS SALES 76,393.46 $ 4,992.52 $ 49.15 $ 7,427.28 $ 74.92 $ 5,293.65 Sewer Garbage Storm Wtr Young Arena 517,411.24 36,218.79 31, 044.67 5,174.11 144,861.00 10,140.27 8,691.66 1,448.61 27,578.50 1,930.50 1,654.71 275.79 36,218.79 10,140.27 1,930.50 0.00 Total Tax Due $ 36,218.79 REGIONS BANK 0.00 [$ 10,140.27 0.00 $ 1,930.50 Sewer Tax Garbage Tax Storm Tax 5,469.61 3.48 4,667.18 SportsPlex 127,236.17 8,906.53 7,634.17 1,272.36 8,906.53 0.00 7,634.17 1,272.36 $ 8,906.53 Leisure - Total $ 462.13 $ 53.89 $ 458.92 $ 3.21 6% 1% Total QTR 857 Sports. 141.66 23.61 $ 165.27 QTR 856 Byrnes Pool 269.83 44.97 314.80 QTR 855 Gates Pool 0.00 0.00 - 852 Gates 4,321.00 720.00 5,041.00 853 Warren 6,430.00 1,072.00 7,502.00 854 South Hills 4,584.00 764.00 5,348.00 QTR 601 Leisure Office 396.00 66.00 462.00 336 Wtr Pollution 31,045.00 5,174.00 36,219.00 335 Wtr/Swr/Gbg 8,692.00 1,449.00 10,141.00 313 Young Arena 1,655.00 276.00 1,931.00 732 SportsPlex 7,634.00 1,272.00 8,906.00 RYAN STUBER From: Holly Sackett Sent: Monday, May 1, 2023 9:24 AM To: RYAN STUBER Subject: Billed Sales Tax April 2023 Good morning, Here's the billed sales tax for April 2023. Storm water- $ 4,667.18 Garbage- $ 3.48 Sewer- $ 5,469.61 Thanks! 144 Saekext 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/3TD0F4D2.htm 1434 - TREASURER, STATE OF 2023-00002001 BYRNES PARK POOL 1-07-025856 04/30/2023 05/15/2023 05/15/2023 05/15/2023 No Gross: 314.80 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 State Tax: 0.00 County Tax: 0.00 LocaUCity Tax: 0.00 Discount: 0.00 Retainage: 0.00 Net Amount: $314.80 Amount/Unit Total Amount N/Y/Y/N/N/N Conversion Item - BYRNES PARK POOL PERMIT # 1 07 025856 G/L Distribution: G/L Account/Project 1.0000 EA 314.8000 314.80 Expensed Unencumbered 010-37-4200 1398 ( General Fund -Leisure Services -Sports & Youth Services Sales Tax) Total Invoice Items: 1 Invoice Amount Expensed: $314.80 Invoice Amount Unencumbered: $0.00 314.80 0.00 6 of 11 5/8/2023, 9:23 AM Jan Apr July Oct Net Taxable Sales Sales Tax Collected 6% 1% Total Sales Tax Leisure Services - Sports & Pools 2023 YEAR Monthly State Sales Tax Leisure Services - Golf Courses Sports B rnes Gates Gates Warren Memorial South Hills Leisure - Office Re. Improv Re Improv Re Im rov Re Im rov 2,361.00 165.27 4,497.15 314.80 0.00 0.00 71,321.73 4,992.52 702.10 49.15 106,103.97 7,427.28 1,070.33 74.92 75,623.60 5,293.65 769.86 53.89 6,556.07 458.92 45.79 3.21 Difference 141.66 23.61 165.27 269.83 44.97 314.80 Total Tax Duel $ Net Taxable Sales Sales Tax Collected 6% 1% Total Sales Tax Difference 0.00 0.00 0.00 0.00 0.00 0.00 165.27 I I $ 314.80 I L WM SERVICES Water Pollution 517,411.24 36,218.79 31,044.67 5,174.11 Sewer Garbage Storm Wtr 144,861.00 10,140.27 4,279.30 713.22 4,992.52 42.13 7.02 49.15 6,366.24 1,061.04 7,427.28 0.00 0.00 Gates - Total $ 5,041.67 'GROSS SALES 72,023.83 $ 4,992.52 $ 49.15 Young Arena 27,578.50 1,930.50 8,691.66 1,654.71 1,448.61 275.79 36,218.79 10,140.27 1,930.50 0.00 Total Tax Due $ 36,218.79 REGIONS BANK 0,00 $ 10,140.27 0.00 I $ 1,930.50 Sewer Tax Garbage Tax Storm Tax 5,469.61 3.48 4,667.18 64.22 10.70 74.92 4,537.42 756.24 5,293.65 46.19 7.70 53.89 0.00 0.00 Warren Mem - Total $ 7,502.20 'GROSS SALES 107,174.30 $ 7,427.28 $ 74.92 SportsPlex 127,236.17 8,906.53 7,634.17 1,272.36 8,906.53 0.00 7,634.17 1,272.36 $ 8,906.53 0.00 0.00 South Hills - Total I $ 5,347.54 'GROSS SALES 76,393.46 $ 5,293.65 $ 53.89 65.56 458.92 0.46 3.21 0.0D Leisure - Total Is 0.00 462.13 $ 458.92 $ 3.21 6% 1% Total QTR 857 Sports 141.66 23.61 $ 165.27 QTR 856 Byrnes Pool 269.83 44.97 314.80 QTR 855 Gates Pool 0.00 0.00 - 852 Gates 4,321.00 720.00 5,041.00 853 Warren 6,430.00 1,072.00 7,502.00 854 South Hills 4,584.00 764.00 5,348.00 QTR 601 Leisure Office 396.00 66.00 462.00 336 Wtr Pollution 31,045.00 5,174.00 36,219.00 335 Wtr/Swr/Gbg 8,692.00 1,449.00 10,141.00 313 Young Arena 1,655.00 276.00 1,931.00 732 SportsPlex 7,634.00 1,272.00 8,906.00 BYRNES SALES TAX 010-37-4200-3475 Apr-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 0.00 0.00 0.00 4,811.95 4,497.15 314.80 0.00 0.00 0.00 GROSS SALES TOTAL 4,811.95 NET SALES TOTAL 4,497.15 SALES TAX TOTAL 314.80 Firefox https://alo-nw.city.alo/nwerp/Temp/FileStorageCache/3TD0F4D2.htm 1434 - TREASURER, STATE OF 2023-00002002 WATERLOO LEISURE SVCS COMM 04/30/2023 05/15/2023 05/15/2023 05/15/2023 No Gross: 462.13 IOWA 1-07-034601 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: $462.13 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 - L.S. OFFICE GOLF (IMPROV) PERMIT #1 07 034601 G/L Distribution: G/L Account/Project 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) 3.21 0.00 N/Y/Y/N/N/N Conversion Item - L.S. OFFICE PERMIT #1 07 1.0000 EA 458.9200 458.92 034601 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: $462.13 Invoice Amount Unencumbered: $0.00 458.92 0.00 7 of 11 5/8/2023, 9:23 AM Jan Apr July Oct Leisure Services - Sports & Pools Net Taxable Sales Sales Tax Collected 6% 1% Total Sales Tax Difference Sports 2,361.00 165.27 141.66 23.61 165.27 B rnes 4,497.15 314.80 269.83 44.97 Gates 2023 YEAR Monthly State Sales Tax Leisure Services Golf Courses Gates 314.80 0.00 0.00 0.00 0.0D 0.00 Re 71,321.73 4,992.52 4,279.30 713.22 Im rov 702.10 49.15 42.13 7.02 4,992.52 Warren Memorial Re 106,103.97 7,427.28 6,366.24 1,061.04 49.15 7,427.28 Im rov 1,070.33 74.92 64.22 10.70 74.92 South Hills Re 75,623.60 5,293.65 4,537.42 756.24 Improv Leisure - Office 769.86 53.89 46.19 7.70 5,293.65 53.89 Total Tax Duel $ Net Taxable Sales Sales Tax Collected 6% 1% Total Sales Tax Difference 0.00 0.00 165.27 I 1 $ 314.80 1 $ WM SERVICES Water Pollution 517,411.24 36,218.79 Storm Wtr Sewer Garbage 144,861.00 10,140.27 0.00 0.00 0.00 0.00 0.00 Gates - Total Warren Mem - Total I $ 5,041.67 I $ 7,502.20 (GROSS SALES 72,023.83 'GROSS SALES 107,174.30 $ 4,992.52 $ 49.15 $ 7,427.28 $ 74.92 Young Arena 27,578.50 1,930.50 31,044.67 8,691.66 5,174.11 1,448.61 1,654.71 275.79 36,218.79 0.00 Total Tax Due $ 36,218.79 REGIONS BANK 10,140.27 1,930.50 0.00 $ 10,140.27 0.00 $ 1,930.50 Sewer Tax Garbage Tax Storm Tax 5,469.61 3.48 4,667.18 SportsPlex 127,236.17 8,906.53 7,634.17 1,272.36 8,906.53 0.00 7,634.17 1,272.36 $ 8,906.53 0.00 0.00 Re 6,556.07 458.92 393.36 65.56 458.92 Im rov 45.79 3.21 2.75 0.46 3.21 0.00 South Hills - Total Leisure - Total I $ 5,347.54 'GROSS SALES 76,393.46 $ 5,293.65 $ 53.89 $ 458.92 $ 3.21 0.D0 I $ 462.13 6% 1% Total QTR 857 Sports 141.66 23.61 $ 165.27 QTR 856 Byrnes Pool 269.83 44.97 314.80 QTR 855 Gates Pool 0.00 0.00 - 852 Gates 4,321.00 720.00 5,041.00 853 Warren 6,430.00 1,072.00 7,502.00 854 South Hills 4,584.00 764.00 5,348.00 QTR 601 Leisure Office 396.00 66.00 462.00 336 Wtr Pollution 31,045.00 5,174.00 36,219.00 335 Wtr/Swr/Gbg 8,692.00 1,449.00 10,141.00 313 Young Arena 1,655.00 276.00 1,931.00 732 SportsPlex 7,634.00 1,272.00 8,906.00 WATERLOO LEISURE SERVICES SALES TAX REPORT APRIL 2023 ACTIVITY 4120 - GOLF COURSES 1398 SALES TAX GOLF REVENUE 7% TAX COLLECTED WARREN MEMORIAL 106,103.97 7,427.28 GATES 71,321.73 4,992.52 SOUTH HILLS 75,623.60 5,293.65 OFFICE 6,556.07 458.92 259, 605.37 18,172.38 ACTIVITY 4125 - GOLF COURSE IMPROVEMENTS 1398 SALES TAX GOLF REVENUE 7% TAX COLLECTED WARREN MEMORIAL 1,070.33 74.92 GATES 702.10 49.15 SOUTH HILLS 769.86 53.89 OFFICE 45.79 3.21 2,588.08 181.17 4-3-23 Firefox https://alo-nw.city.alo/nwerp/Temp/FileStorageCache/3 TDOF4D2.htm 1434 - TREASURER, STATE OF 2023-00002003 RECREATION CENTER 1-07-025857 04/30/2023 05/15/2023 05/15/2023 05/15/2023 No Gross: 165.27 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: $165.27 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 165.2700 165.27 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: $165.27 Invoice Amount Unencumbered: $0.00 165.27 0.00 8 of 11 5/8/2023, 9:23 AM Jan Apr July Oct Leisure Services - Sports & Pools Net Taxable Sales Sales Tax Collected 6% 1% Total Sales Tax Difference Sports 2,361.00 165.27 141.66 23.61 165.27 B rnes 4,497.15 314.80 269.83 44.97 314.80 Gates 2023 YEAR Monthly State Sales Tax Leisure Services - Golf Courses Gates 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Total Tax Duel $ 165.27 " $ 314.80 Net Taxable Sales Sales Tax Collected 6% 1% Total Sales Tax WM SERVICES Water Pollution 517,411.24 36,218.79 Difference 31,044.67 5,174.11 0.00 Re 71,321.73 4,992.52 4,279.30 713.22 Im rov 702.10 49.15 42.13 7.02 4,992.52 49.15 Warren Memorial Re 106,103.97 7,427.28 6,366.24 1,061.04 Im rov 1,070.33 74.92 64.22 10.70 South Hills 7,427.28 74.92 0.00 0.00 Gates - Total I $ 5,041.67 'GROSS SALES 72,023.83 $ 4,992.52 $ 49.15 Sewer Garbage Storm Wt Young Arena 144,861.00 10,140.27 8,691.66 1,448.61 27,578.50 1,930.50 1,654.71 275.79 36,218.79 10,140.27 1,930.50 0.00 Total Tax Due $ 36,218.79 REGIONS BANK 0.00 $ 10,140.27 0.00 $ 1,930.50 Sewer Tax Garbage Tax Storm Tax 5,469.61 3.48 4,66718 Re 75,623.60 5,293.65 4,537.42 756.24 5,293.65 Improv Leisure - Office 0.00 0.00 Warren Mem - Total I $ 7,502.20 'GROSS SALES 107,174.30 $ 7,427.28 $ 74.92 SportsPlex'. 127,236.17 8,906.53 7,634.17 1,272.36 8,906.53 0.00 7,634.17 1,272.36 $ 8,906.53 0.00 769.86 53.89 46.19 7.70 53.89 0.00 South Hills - Total $ 5,347.54 (GROSS SALES76,393.46 $ 5,293.65 - $ 53.89 $ 458.92 Re 6,556.07 458.92 393.36 65.56 458.92 Im rov 45.79 3.21 2.75 0.46 3.21 0.00 Leisure - Total 0.00 $ 462.13 3.21 6% 1% Total QTR 857 Sports 141.66 23.61 $ 165.27 QTR 856 Byrnes Pool 269.83 44.97 314.80 QTR 855 852 r Gates Pool Gates 0.00 4,321.00 < 0.00 720.00 5,041.00 853 Warren 6,430.00 1,072.00 7,502.00 854 South Hills 4,584.00 764.00 5,348.00 QTR 601 Leisure Office 396.00 66.00 462.00 336 Wtr Pollution 31,045.00 5,174.00 36,219.00 335 Wtr/Swr/Gbg 8,692.00 1,449.00 10,141.00 313 Young Arena 1,655.00 276.00 1,931.00 732 SportsPlex 7,634.00 1,272.00 8,906.00 SPORTS SALES TAX 010-37-4200 Apr-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 0.00 0.00 0.00 0.00 0.00 0.00 2,526.27 2,361.00 165.27 0.00 0.00 0.00 GROSS SALES TOTAL 2,526.27 NET SALES TOTAL 2,361.00 SALES TAX TOTAL 165.27 Firefox https://alo-nw.city.alo/nwerp/Temp/FileStorageCache/3TD0F4D2.htm 1434 - TREASURER, STATE OF 2023-00002004 SPORTSPLEX 1-07-040732 IOWA 04/30/2023 05/15/2023 05/15/2023 05/15/2023 No Gross: 8,906.53 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: $8,906.53 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 1-07-040732 G/L Distribution: G/L Account/Project 8,906.5300 8,906.53 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: $8,906.53 Invoice Amount Unencumbered: $0.00 8,906.53 0.00 9 of 11 5/8/2023, 9:23 AM Jan Apr July Oct Net Taxable Sales Sales Tax Collected 6% 1% Total Sales Tax Leisure Services - Sports & Pools Sports 2,361.00 165.27 141.66 23.61 165.27 Byrnes 4,497.15 314.80 269.83 44.97 314.80 Gates 2023 YEAR Monthly State Sales Tax Leisure Services - Golf Courses Gates 0.00 0.00 Re 71,321.73 4,992.52 Im rov 702.10 49.15 Warren Memorial 0.00 0.00 0.00 4,279.30 42.13 713.22 7.02 Re 106,103.97 7,427.28 6,366.24 1,061.04 Im rov 1,070.33 74.92 South Hills Re 75,623.60 5,293.65 Improv Leisure - Office 769.86 53.89 Re 6,556.07 458.92 m rov 45.79 3.21 64.22 4,537.42 10.70 756.24 46.19 393.36 2.75 7.70 65.56 0.46 4,992.52 49.15 7,427.28 74.92 5,293.65 53.89 458.92 3.21 Difference 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Total Tax Duel $ Net Taxable Sales Sales Tax Collected 6% 1% Total Sales Tax 165.27 I $ 314.80 I $ WM SERVICES Water Pollution Gates - Total Warren Mem - Total South Hills - Total I $ 5,041.67 I $ 7,502.20 (GROSS SALE 72,023.83 (GROSS SALES 107,174.30 IGROSS SALES 76,393.46 $ 4,992.52 $ 49.15 $ 7,427.28 $ 74.92 $ 5,293.65 $ 53.89 Sewer Garbage Storm Wtr Young Arena Difference 517,411.24 36,218.79 31, 044.67 5,174.11 144,861.00 10,140.27 8,691.66 1,448.61 27,578.50 1,930.50 1,654.71 275.79 36,218.79 0.00 Total Tax Due $ 36,218.79 REGIONS BANK 10,140.27 1,930.50 0.00 $ 10,140.27 0.00 $ 1,930.50 Sewer Tax Garbage Tax Storm Tax 5,469.61 3.48 4,667.18 SportsPlex 127,236.17 8,906.53 7,634.17 1,272.36 8,906.53 0.00 7,634.17 1,272.36 $ 8,906.53 I $ 5,347.54 Leisure - Total $ 462.13 $ 458.92 $ 3.21 QTR 857 Sports 6% 141.66. 1%/, 23.61 Total $ 165.27 QTR 856 Byrnes Pool 269.83 44.97 314.80 QTR 855 Gates Pool 0.00 0.00 - 852 Gates 4,321.00 720.00 5,041.00 853 Warren 6,430.00 1,072.00 7,502.00 854 South Hills 4,584.00 764.00 5,348.00 QTR 601 Leisure Office 396.00 66.00 462.00 336 Wtr Pollution 31,045.00 5.174.00 36,219.00 335 Wtr/Swr/Gbg 8,692.00 1,449.00 10,141.00 313 Young Arena 1,655.00 276.00 1,931.00 732 SportsPlex 7,634.00 1,272.00 8,906.00 SPORTSPLEX SALES TAX 010-37-4180 Apr-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 32,959.23 30,803.02 2,156.21 5,218.21 4,876.83 341.38 97,965.26 91,556.32 6,408.94 GROSS SALES TOTAL 136,142.70 NET SALES TOTAL 127,236.17 SALES TAX TOTAL 8,906.53 From: Courtney Jackson Leisure Services Firefox https://alo-nw.city.alo/nwerp/Temp/FileStorageCache/3TD0F4D2.htm 1434 - TREASURER, STATE OF 2023-00002005 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 04/30/2023 05/15/2023 05/15/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 05/15/2023 Bank Account: ACCOUNTS PAYABLE Invoice Terms: Hold Reason: Quantity U/M No Gross: 36,218.79 Freight: 0.00 State Tax: 0.00 County Tax: 0.00 Local/City Tax: 0.00 Discount: 0.00 Retainage: 0.00 Net Amount: $36,218.79 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 36,218.7900 36,218.79 Expensed Unencumbered 520-14-5200 1398 ( Sanitary Sewer Fund -Waste Management -Water Pollution -Water Pollution Control Plant Op Sales Tax) Invoice Amount Expensed: $36,218.79 Invoice Amount Unencumbered: 36,218.79 $0.00 0.00 Batch Total Invoices: 10 Batch Total Gross: $76,029.70 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: $76,029.70 Batch Total Unencumbered: $0.00 Grand Total Invoices: 10 Grand Total Gross: $76,029.70 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: $76,029.70 10 of 11 5/8/2023, 9:23 AM Firefox https://alo-nw.city.alo/nwerp/Temp/FileStorageCache/3TD0F4D2.htm Grand Total Unencumbered: $0.00 11 of 11 5/8/2023, 9:23 AM Jan Apr July Oct Net Taxable Sales Sales Tax Collected 6% 1% Total Sales Tax Difference Leisure Services - Sports & Pools 2023 YEAR Monthly State Sales Tax Leisure Services - Golf Courses Sports B rnes Gates Gates Warren Memorial South Hills Leisure Office Re Improv Re Improv Re Improv Re. Im•rov 2,361.00 165.27 4,497.15 314.80 0.00 0.00 71,321.73 4,992.52 702.10 49.15 106,103.97 7,427.28 1,070.33 74.92 75,623.60 5,293.65 769.86 53.89 6,556.07 458.92 45.79 3.21 141.66 23.61 165.27 269.83 44.97 314.80 0.00 0.00 0.00 Total Tax Duel $ Net Taxable Sales Sales Tax Collected 6% 1% Total Sales Tax Difference 0.00 0.00 165.271 $ 314.80 $ WM SERVICES Water Pollution 0.00 4,279.30 713.22 4,992.52 42.13 7.02 49.15 6,366.24 1,061.04 7,427.28 64.22 10.70 74.92 0.00 0.0D Gates - Total I $ 5,041.67 (GROSS SALES 72,023.83 $ 4,992.52 $ 49.15 Sewer Garbage Storm Wtr Young Arena 517,411.24 36,218.79 31, 044.67 5,174.11 144,861.00 10,140.27 8,691.66 1,448.61 27,578.50 1,930.50 1,654.71 275.79 Total Tax Due 36,218.79 0.0 10,140.27 1,930.50 0 $ 36,218.79 REGIONS BANK 0.00 $ 10,140.27 0.00 $ 1,930.50 Sewer Tax Garbage Tax Storm Tax 5,469.61 3.48 4,667.18 0.00 4,537.42 756.24 5,293.65 46.19 7.70 53.89 0.00 Warren Mem - Total $ 7,502.20 'GROSS SALES 107,174.30 $ 7,427.28 $ 74.92 SportsPlex 127,236.17 8,906.53 7,634.17 1,272.36 8,906.53 0.00 7,634.17 1.272.36 $ 8,906.53 0.00 0.00 South Hills - Total I $ 5,347.54 'GROSS SALES 76,393.46 $ 5,293.65 $ 53.89 393.36 65.56 458.92 2.75 0.46 3.21 0.00 Leisure - Total I$ 0.00 462.13 $ 458.92 $ 3.21 QTR 857 Sports 6% 141.66 1% 23.61 Total $ 165.27 QTR 856 Byrnes Pool 269.83 44.97 314.80 QTR 855 Gates Pool 0.00 0.00 - 852 Gates 4,321.00 720.00 5,041.00 853 Warren 6,430.00 1,072.00 7,502.00 854 South Hills 4,584.00 764.00 5,348.00 QTR 601 Leisure Office 396.00 - 66.00 462.00 336 Wtr Pollution 31,045.00 5,174 00 36 219.00 335 Wtr/Swr/Gbg 8,692.00 1,449.00 10,141.00 313 Young Arena 1,655.00 276.00 1,931.00 732 SportsPlex 7,634.00 1,272.00 8,906.00 TAX REPORT FOR April 2023 WASTE MANAGEMENT SERVICES Billing Date0 04/25/25 March 2023 USEAGE NON-TAXABLE ACTIVITY ACCT. II COMPANY NET BILLED TOTAL BILLED 5452 BLACK HAWK CARE FACILITY Na - 5453 BLACK HAWK COUNTY SOLID WASTE 4708.78 Na 4,70878 5641 BLACK HAWK COUNTY LANDFILL PRET 236.80 Ne 236.8D 14061 WATERLOO PROCESSING LLC 1,981.25 n/a 198125 5644 TYSON FOODS PRET 1.900.30 Na 1,900.30 7518 CONAGRA PRET 1,260.30 - 1,260.30 CONAGRA 6,055.66 n/a 6,055.66 12488 PLMIERGY nla 10943 CANADIAN NATIONAL GROUNDWATER N9 5641 BLACK HAWK COUNTY LANDFILL PRET-FEES/PERM Na 7518 CONAGRA PRET-FEES/PERM n/a - 8602 J.O. ENGINE WORKS-FEES/PERM Na - 5646 J.D. WESTFIELD-FEES/PERM Na 5845 J.D. TRACTOR WORKS-FEES/PERM Na - 14453 VETS TRUCK WASH-FEES/PERM n/a 10521 CANADIAN NATIONAL RAILWAY-FEES/PERM n/a - 219699 ALLAN INDUSTRIAL COATINGS -FEES/PERM n/a - 13674 J.D PEC-FEES/PERM n/a - 5640 ARAMARK UNIFORM SERVICES -FEES/PERM Na - 6464 DARLING INTERNATIONAL -FEES/PERM Na - 5643 HYDRITE-FEES/PERM Na - 12935 IOWA NORTHERN RAILWAY-FEES/PERM Na - 20973 Renews Co (Crown Group) Na 14061 wraIERLOO PROCESSING LLC9abfee0erm9 Na 14061 WATERLOO PROCESSING LLC Na 5544 TYSON FRESH MEATS INC-FEES/PERM Na 12935 IOWA NORTHERN RAILWAY Na - 22509 EVANSDALE 120.00 Na 120.00 545E TYSON FRESH MEATS Credit Na - 16,283.09 0,00 16,263.09 TAXABLE ACTIVITY ACCT9 COMPANY TAXED APPLIED TOTAL BILLED 5451 ARAMARK 5,148.98 360.39 5,508.87 14060 WATERLOO PROCESSING LLC 38,697.09 4,108.80 62,805.89 5458 TYSON FOODS 357,856.83 25,049.95 382,906.81 5457 JOHN DEERE - DONALD STREET 9,232.78 646.29 9,879.05 5458 JOHN DEERE- ENGINE WORKS 2,050.96 143.57 2,194.53 5459 JOHN DEERE - FOUNDRY 8001 1,532.94 107.27 1,639.71 5460 JOHN DEERE- FOUNDRY 8002 - - 5481 JOHN DEERE- PEC 1,999.48 139.98 2,139.44 5462 JOHN DEERE - BLDG 102011021 11,113.14 777.92 11,891.06 5463 JD - WESTFIELD S JEFFERSON 7,165.54 501.59 7,667.13 12409 JOHN DEERE WSJ - BLDG A 853.00 59.71 912.71 5638 DRAIN DOCTOR •- 22538 NUTRI JECT SYSTEMS - - 5951 KAYSER PLUMBING - 6657 CONAGRA GROCERY PRODUCTS 39,085.22 2,735.97 41,821.19 8960 HYDRITE CHEMICAL CO 192A9 13.47 205.96 7291 DARLING INTERNATIONAL - - 7324 BLACK HAWK WASTE - 8747 LOST ISLAND METER 37.20 260 39.80 12557 A-1 SEPTIC 1,700.00 1111.00 1,819.00 11070 CLEANTRAP SERVICES 22385 ROTO ROOTER - 14452 VETS TRUCK WASH 8,618.51 617.30 9,435.81 5452 Black Hawk Nursing 5 Rehab 3,725.43 260.78 3,968.21 22671 CEDAR VALLEY PORTABLES - - 20319 PAUL COOLEY PUMPING COOLEY PUMPING 120.00 8.40 128A0 20321 GREENS'S SEPTIC SERVICE 60.00 4.20 84.20 23498 Advanced Draingage 7,922.67 559.59 8,477.26 23461 A Plus Septic 100.00 7.00 107.00 SUBTOTAL TAXABLE S 517,911.24 6 36,215.79 S 553,630.03 Grand Total $ 533,674.33 5 36,218.79 5 560,893.12 Grand total of Posting S 569,893.12 Grand total of Posting Grand total of Posting Grand total of Posting BC'+Evel De artment REV NUE Sales and Use Return Summary Sales Tax Use Tax Final Balances Payment Information Name: CITY OF WATERLOO Account ID: 1-07-025852 Filing Period: 30-Apr-2023 Date: 16-May-2023 Confirmation Number: 0-003-553-322 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 $72,023.83 $0.00 $0.00 $72,023.83 $4,321.43 $720.24 $0.00 $0.00 $0.00 $0.00 Deposits/Overpayment Credit $0.00 Total Tax & Surcharge $5,041.67 Balance $5,041.67 Total Amount Due $5,041.67 Bank Name REGIONS BANK Account Number ****6001 Amount $5,041.67 Payment Date 16-May-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-553-322 Date: 16-May-2023 Taxable Sales Local Option Local Option Tax (1.00%) Black Hawk County - 07 $72,023.83 $72,023.83 $720.24 $720.24 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. 140-wa De rtl Ev NUE Sales and Use Return Summary Sales Tax Name: CITY OF WATERLOO Account ID: 1-07-025853 Filing Period: 30-Apr-2023 Date: 16-May-2023 Confirmation Number: 0-003-536-407 Gross Sales Goods Consumed Total Exemptions Taxable Amount State Sales Tax (6%) Local Option Sales Tax $107,174.30 $0.00 $0.00 $107,174.30 $6,430.46 $1, 071.74 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 $7,502.20 Balance $7,502.20 Total Amount Due $7,502.20 Payment Information Bank Name REGIONS BANK Account Number ****6001 Amount $7,502.20 Payment Date 16-May-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-536-407 Date: 16-May-2023 Taxable Sales Local Option Local Option Tax (1.00%) Black Hawk County - 07 $107,174.30 $107,174.30 $1,071.74 $1,071.74 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. 1-011 EVENUE Sales and Use Return Summary Sales Tax Name: CITY OF WATERLOO Account ID: 1-07-025854 Filing Period: 30-Apr-2023 Date: 16-May-2023 Confirmation Number: 0-003-477-015 Gross Sales Goods Consumed Total Exemptions Taxable Amount State Sales Tax (6%) Local Option Sales Tax $76,393.46 $0.00 $0.00 $76,393.46 $4,583.61 $763.93 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,347.54 Balance $5,347.54 Total Amount Due $5,347.54 Payment Information Bank Name REGIONS BANK Account Number ****6001 Amount $5,347.54 Payment Date 16-May-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-477-015 Date: 16-May-2023 Taxable Sales Local Option Local Option Tax (1.00%) Black Hawk County - 07 $76,393.46 $76,393.46 $763.93 $763.93 This is a summary only and will not be accepted as a return by the Iowa Department of Revenue. Retain this document for personal records. EVENUE Sales and Use Return Summary Sales Tax Name: CITY OF WATERLOO Account ID: 1-07-025856 Filing Period: 30-Apr-2023 Date: 16-May-2023 Confirmation Number: 0-003-476-449 Gross Sales Goods Consumed Total Exemptions Taxable Amount State Sales Tax (6%) Local Option Sales Tax $4,497.15 $0.00 $0.00 $4,497.15 $269.83 $44.97 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 $314.80 Balance $314.80 Total Amount Due $314.80 Payment Information Bank Name REGIONS BANK Account Number ****6001 Amount $314.80 Payment Date 16-May-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-476-449 Date: 16-May-2023 Taxable Sales Local Option Local Option Tax (1.00%) Black Hawk County - 07 $4,497.15 $44.97 $4,497.15 $44.97 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. K�a� yin t## 3 aFna 3�3i ` v.'7 EVENUE Sales and Use Return Summary Sales Tax Name: CITY OF WATERLOO Account ID: 1-07-025857 Filing Period: 30-Apr-2023 Date: 16-May-2023 Confirmation Number: 0-003-544-106 Gross Sales Goods Consumed Total Exemptions Taxable Amount State Sales Tax (6%) Local Option Sales Tax $2,361.00 $0.00 $0.00 $2,361.00 $141.66 $23.61 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.27 Balance $165.27 Total Amount Due $165.27 Payment Information Bank Name REGIONS BANK Account Number ****6001 Amount $165.27 Payment Date 16-May-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-544-106 Date: 16-May-2023 Taxable Sales Local Option Local Option Tax (1.00%) Black Hawk County - 07 $2,361.00 $23.61 $2,361.00 $23.61 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. wa De artment of REV NUE Sales and Use Return Summary Sales Tax Name: CITY OF WATERLOO Account ID: 1-07-030335 Filing Period: 30-Apr-2023 Date: 16-May-2023 Confirmation Number: 0-003-530-263 Gross Sales Goods Consumed Total Exemptions Taxable Amount State Sales Tax (6%) Local Option Sales Tax $144,861.00 $0.00 $0.00 $144,861.00 $8,691.66 $1,448.61 Use Tax Total Taxable Purchases $0.00 Sales Subject to Use Tax $0.00 Taxable Amount $0.00 Use Tax $0.00 Final Balances Deposits/Overpayment Credit $0.00 Total Tax & Surcharge $10,140.27 Balance $10,140.27 Total Amount Due $10,140.27 Payment Information Bank Name REGIONS BANK Account Number ****6001 Amount $10,140.27 Payment Date 16-May-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-530-263 Date: 16-May-2023 Taxable Sales Local Option Local Option Tax (1.00%) Black Hawk County - 07 $144,861.00 $144,861.00 $1,448.61 $1,448.61 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. REvI rt meat of NE Sales and Use Return Summary Sales Tax Name: CITY OF WATERLOO Account ID: 1-07-030336 Filing Period: 30-Apr-2023 Date: 16-May-2023 Confirmation Number: 0-003-574-826 Gross Sales Goods Consumed Total Exemptions Taxable Amount State Sales Tax (6%) Local Option Sales Tax $517,411.30 $0.00 $0.00 $517,411.30 $31, 044.68 $5,174.11 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 $36,218.79 Balance $36,218.79 Total Amount Due $36,218.79 Payment Information Bank Name REGIONS BANK Account Number ****6001 Amount $36,218.79 Payment Date 16-May-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-574-826 Date: 16-May-2023 Taxable Sales Local Option Local Option Tax (1.00%) Black Hawk County - 07 $517,411.30 $517,411.30 $5,174.11 $5,174.11 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. F3 "dxey..xk FCbtS REVENUE Sales and Use Return Summary Sales Tax Name: CITY OF WATERLOO Account ID: 1-07-034601 Filing Period: 30-Apr-2023 Date: 16-May-2023 Confirmation Number: 0-003-473-687 Gross Sales Goods Consumed Total Exemptions Taxable Amount State Sales Tax (6%) Local Option Sales Tax $6,601.86 $0.00 $0.00 $6,601.86 $396.11 $66.02 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 $462.13 Balance $462.13 Total Amount Due $462.13 Payment Information Bank Name REGIONS BANK Account Number ""*6001 Amount $462.13 Payment Date 16-May-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-473-687 Date: 16-May-2023 Taxable Sales Local Option Local Option Tax (1.00%) Black Hawk County - 07 $6,601.86 $66.02 $6,601.86 $66.02 This is a summary only and will not be accepted as a return by the Iowa Department of Revenue. Retain this document for personal records. EVENUE Sales and Use Return Summary Sales Tax Use Tax Final Balances Payment Information Name: CITY OF WATERLOO Account ID: 1-07-037313 Filing Period: 30-Apr-2023 Date: 16-May-2023 Confirmation Number: 0-003-518-716 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 $27,578.50 $0.00 $0.00 $27,578.50 $1,654.71 $275.79 $0.00 $0.00 $0.00 $0.00 Deposits/Overpayment Credit $0.00 Total Tax & Surcharge $1,930.50 Balance $1,930.50 Total Amount Due $1,930.50 Bank Name REGIONS BANK Account Number **"6001 Amount $1,930.50 Payment Date 16-May-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-518-716 Date: 16-May-2023 Taxable Sales Local Option Local Option Tax (1.00%) Black Hawk County - 07 $27,578.50 $27,578.50 $275.79 $275.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. q j 3 9F' YV�LE 9,i'6�Q.Yf>9r RE MSi r C., REVENUE F(.. Sales and Use Return Summary Sales Tax Use Tax Final Balances Payment Information Name: CITY OF WATERLOO Account ID: 1-07-040732 Filing Period: 30-Apr-2023 Date: 16-May-2023 Confirmation Number: 0-003-535-100 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 $127,236.17 $0.00 $0.00 $127,236.17 $7,634.17 $1,272.36 $0.00 $0.00 $0.00 $0.00 Deposits/Overpayment Credit $0.00 Total Tax & Surcharge $8,906.53 Balance $8,906.53 Total Amount Due $8,906.53 Bank Name REGIONS BANK Account Number ****6001 Amount $8,906.53 Payment Date 16-May-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-535-100 Date: 16-May-2023 Taxable Sales Local Option Local Option Tax (1.00%) Black Hawk County - 07 $127,236.17 $1,272.36 $127,236.17 $1,272.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.