The URL can be used to link to this page

Home My WebLink AboutAugustFeb May Aug Nov QTRLY REPORTING ONLY Leisure Services - Sports & Pools Sports Net Taxable Sales Sales Tax Collected 6% 1% Total Sales Tax 2,357.50 165.03 141.45 23.58 165.03 Differencett Total Tax Due Net Taxable Sales Sales Tax Collected 6% 1% Total Sales Tax Difference 0.01 $ 165.03 WM SERVICES Water Pollution 452,109.31 31,647.64 27,126.56 4,521.09 31,647.65 -0.01 Total Tax Due $ 31,647.64 REGIONS BANK B rnes 3,191.64 223.42 191.50 31.92 223.41 0.01 Gates 0 00 0.00 0.00! 0.00 223.42 1 $ 2023 YEAR Monthly State Sales Tax QTRLY REPORTING ONLY Leisure Services - Golf Courses Gates Warren Memorial South Hills Leisure - Office Re. Improv Reg Improv Reg Improv Re. Improv 48,136.68 3,369.57 440.89 30.86 44,058.41 3,084.09 398.13 27.87 42,586.92 2,981.08 401.40 28.10 0.00 0.00 2,888.20 481.37 3,369.57 0.00 26.45 4.41 30.86 0.00 2,643.50 440.58 3,084,09 0.00 23.89 3.98 27.87 0.00 2,555.22 425.87 2.981.08 0.00 24.08 4.01 28.10 0.00 Gates - Total Warren Mem - Total South Hills Total I $ 3,400.43 I $ 3,111.96 I $ 3,009.18 GROSS SALES 48,577.57 'GROSS SALES 44,496.54 'GROSS SALES 42,988.32 $ 3,369.57 $ 30.86 $3,084.09 $ 27.87 $ 2,981.08 $ 28.10 Sewer Garbage Storm Wtr 169,482.00 11,863.744 10,168.92 1,694.82 11,863.74 0.00 $ 11,863.74 Young Arena 9,496.26 664.74 569.78 94.96 664.74 0.00 $ 664.74 Sewer Tax Garbage Tax Storm Tax 6,610.94 20.08 5,232.72 SportsPlex 94,542.82 6,618.00 5,672.57 945.43 6.618.00 0.00 5 672.57 945.43 $ 6,618.00 0.00 0.00 0.00 0.00 0.00' 0.00 0.00 Leisure - Total 0.00 Is - GROSS SALES 0.00 $ - $ 6% 1% Total QTR 857 Sports 141.45 I 23.58 $ 165.03 QTR 856 Byrnes Pool 191.50 31.92 223.41 QTR 855 Gates Pool 0.00 114 0.00 852 Gates 2,915.00 486.00 3,401.00 853 Warren 2,667.00 445.00 3,112.00 854 South Hills 2,579.00 430.00 3,009.00 QTR 601 Leisure Office 0.00 0.00 - 336 Wtr Pollution 27,127.00 4,521.00 31,648.00 335 _ Wtr/Swr/Gbg 10,169.00 1,695.00 11,864.00 313 Young Arena 570.00 95.00 665.00 732 SportsPlex 5,673.00 945.00 6,618.00 WATERLOO LEISURE SERVICES SALES TAX REPORT AUGUST 2023 ACTIVITY 4120 - GOLF COURSES 1398 SALES TAX GOLF REVENUE 7% TAX COLLECTED (-WARREN GATES 3,369.57 SOUTH HILLS 2,981.08 OFFICE 48,136.68 42, 586.92 0.00 134,782.01 0.00 9,434.74 ACTIVITY 4125 - GOLF COURSE IMPROVEMENTS 1398 SALES TAX WARREN MEMORIAL SOUTH HILLS OFFICE GOLF REVENUE 440.89 401.40 0.00 1,240.42 7% TAX COLLECTED 30.86 28.10 0.00 86.83 9-6-23 WATERLOO LEISURE SERVICES OFFICE AUGUST 2023 ACTIVITY 4120 - GOLF COURSES 1398 SALES TAX WARREN MEMORIAL SALES TAX REPORT GOLF REVENUE 7% TAX COLLECTED 44, 058.41 ATES 48,136.6� OUTH HILLS 42,586.92 0.00 134,782.01 3, 084.09 2,981.08 0.00 9,434.74 ACTIVITY 4125 - GOLF COURSE IMPROVEMENTS 1398 SALES TAX GOLF REVENUE 7% TAX COLLECTED WARREN MEMORIAL 398.13 27.87 GATES C4_10:89 30.86 401.40 28.10 0.00 0.00 1,240.42 86.83 SOUTH HILLS OFFICE 9-6-23 WATERLOO LEISURE SERVICES AUGUST 2023 ACTIVITY 4120 - GOLF COURSES 1398 SALES TAX WARREN MEMORIAL GATES SOUTH HILLS C_ OFFICE SALES TAX REPORT GOLF REVENUE 7% TAX COLLECTED 44, 058.41 3,084.09 48,136.68 3,369.57 42,586.92 2,981.08 0.00 134,782.01 0.00 9,434.74 ACTIVITY 4125 - GOLF COURSE IMPROVEMENTS 1398 SALES TAX WARREN MEMORIAL GATES GOLF REVENUE 398.13 440.89 7% TAX COLLECTED 27.87 30.86 SOUTH HILLS 401.40 28.10 OFFICE ' 0.00 -0.00 1,240.42 86.83 9-6-23 9/11/2023 YOUNG ARENA SALES TAX 010-37-4500-1398 Gross Taxable Sales August 2023 10,161.00 Net Taxable Sales August 2023 9,496.26 Total Tax August 2023 664.74 To: Ryan Stuber City Clerks Office Waterloo City Hall From: Madonna Welsh Leisure Services RYAN STUBER From: Holly Sackett Sent: Friday, September 1, 2023 8:57 AM To: RYAN STUBER Subject: Billed Sales Tax August 2023 Good Morning, Storm water- $5,232.72 Garbage- $20.08 Sewer- $6,610.94 Thanks, Systems Billing Administrator Waterloo Water Works 325 Sycamore St Waterloo, IA 50703 319-232-6280 1 BYRNES SALES TAX 010-37-4200-3475 Aug-23 Byrnes Pool Daily Admissions (4200-3475) Byrnes Pool Prepaid Passes (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 2,873.00 2,685.05 187.95 542.06 506.60 35.46 0.00 0.00 0.00 0.00 0.00 0.00 GROSS SALES TOTAL 3,415.06 NET SALES TOTAL 3,191.64 SALES TAX TOTAL 223.42 SPORTS SALES TAX 010-37-4200 Aug-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 462.78 432.50 30.28 2,059.75 1,925.00 134.75 GROSS SALES TOTAL 2,522.53 NET SALES TOTAL 2,357.50 SALES TAX TOTAL 165.03 SPORTSPLEX SALES TAX 010-37-4180 Aug-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 5,955.50 5,565.89 389.61 5,140.80 4,804.49 336.31 90,064.51 84,172.44 5,892.07 GROSS SALES TOTAL 101,160.82 NET SALES TOTAL 94,542.82 SALES TAX TOTAL 6,618.00 From: Courtney Jackson Leisure Services TAX REPORT FOR August 2023 WASTE MANAGEMENT SERVICES 8/1/2023 July 2023 Usage NON-TAXABLE ACTIVITY ACCT. # COMPANY NET BILLED TOTAL BILLED 5452 BLACK HAWK CARE FACILITY n/a - 5453 BLACK HAWK COUNTY SOLID WASTE 4,971.70 n/a 4,971.70 5641 BLACK HAWK COUNTY LANDFILL PRET 236.60 n/a 236.80 14061 WATERLOO PROCESSING LLC 1,693.05 + 1,693.05 5644 TYSON FOODS PRET 1,900.30 n/a 1,900.30 7518 CONAGRA PRET 1,217.30 n/a 1,217.30 13109 CONAGRA 5,798.47 n/a 5,798.47 6602 J.D. ENGINE WORKS n/a - 5640 ARAMARK UNIFORM SERVICES n/a - 5643 HYDRITE CHEMICAL CO. PRET n/a - 6464 DARLING INTERNATIONAL n/a - 5646 J.D. WESTFIELD n/a - 5645 J.D. TRACTOR WORKS n/a 12488 PLANERGY n/a - 14453 VETS'S TRUCK WASH n/a - 10943 CANADIAN NATIONAL GROUNDWATER n/a - 10521 CANADIAN NATIONAL RAILWAY n/a - 22085 COOLEY PUMPING n/a - 22509 City of Evansdale n/a - 13874 J.D. PEC n/a - 12935 IOWA NORTHERN RAILWAY n/a - 15,817.62 Non-taxable 15,817.62 TAXABLE ACTIVITY ACCT# COMPANY NET BILLED TAXED APPLIED TOTAL BILLED 5451 ARAMARK $ 6,538.05 457.66 6,995.71 14060 WATERLOO PROCESSING LLC $ 35,693.97 2,498.58 38,192.55 14060 TWIN CITY TANNERY CO - - 5456 TYSON FOODS $ 300,574.31 21,040.20 321,614.51 5457 JOHN DEERE - DONALD STREET $ 10,320.87 722.46 11,043.33 5458 JOHN DEERE - ENGINE WORKS $ 3,220.77 225.45 3,446.22 5459 JOHN DEERE - FOUNDRY 8001 $ 879.83 61.59 941.42 5460 JOHN DEERE- FOUNDRY 8002 - - 5461 JOHN DEERE - PEC $ 4,279.24 299.55 4,578.79 5462 JOHN DEERE - BLDG 1020/1021 $ 18,280.71 1,279.65 19,560.36 5463 JD - WESTFIELD & JEFFERSON $ 5,828.61 408.00 6,236.61 12409 JOHN DEERE W&J - BLDG A $ 3,642.59 254.98 3,897.57 10685 CN RAILWAY - - 5638 DRAIN DOCTOR $ 20.00 1.40 21.40 5742 HAROLD REUSCHER - - 6657 CONAGRA GROCERY PRODUCTS $ 43,240.00 3,026.80 46,266.80 6960 HYDRITE CHEMICAL CO $ 296.62 20.76 317.38 7291 DARLING INTERNATIONAL - - 7324 BLACK HAWK WASTE - - 8747 LOST ISLAND METER $ 543.39 38.04 581.43 22671 Cedar Valley Portables - - 12557 4-1 SEPTIC $ 1,480.00 103.60 1,583.60 23461 A 1 Plus $ 40.00 2.80 42.80 23413 Crystal Heating &Plumbing - - 14452 VETS TRUCK WASH $ 7,211.07 504.77 7,715.84 13654 GROTH SERVICES - - 20319 PAUL COOLEY PUMPING COOLEY PUMPING $ 20.00 1.40 21.40 20321 GREENS'S SEPTIC SERVICE $ 60.00 4.20 64.20 23496 22365 Advanced Drainage Systems $ 4,719.33 330.35 5,049.68 Roto Rooter $ 40.00 2.80 42.80 5452 Black Hawk Nursing & Rehab $ 5,179.95 362.60 5,542.55 22080 MUNICIPAL PIPE TOOL CO INC - - SUBTOTAL TAXABLE $ 452,109.31 $ 31,647.64 $ 483,756.95 Grand Total $ 467,926.93 $ 31,647.64 $ 499,574.57 Grand total of Posting 499574 Sales and Use Return Summary Sales Tax Use Tax Final Balances Payment Information Name: Account ID: Filing Period: Date: Confirmation Number: Gross Sales Goods Consumed Total Exemptions Taxable Amount State Sales Tax (6%) Local Option Sales Tax Total Taxable Purchases Sales Subject to Use Tax Taxable Amount Use Tax Deposits/Overpayment Credit Total Tax & Surcharge Balance Total Amount Due Bank Name Account Number Amount Payment Date CITY OF WATERLOO 1-07-025852 31-Aug-2023 19-Sep-2023 0-004-250-667 $48,577.57 $0.00 $0.00 $48,577.57 $2,914.65 $485.78 $0.00 $0.00 $0.00 $0.00 $0.00 $3,400.43 $3,400.43 $3,400.43 REGIONS BANK ****6001 $3,400.43 20-Sep-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-004-250-667 Date: 19-Sep-2023 Taxable Sales Local Option Local Option Tax (1.00%) Black Hawk County - 07 $48,577.57 $48,577.57 $485.78 $485.78 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. Sales and Use Return Summary Sales Tax Use Tax Final Balances Payment Information Name: Account ID: Filing Period: Date: Confirmation Number: Gross Sales Goods Consumed Total Exemptions Taxable Amount State Sales Tax (6%) Local Option Sales Tax Total Taxable Purchases Sales Subject to Use Tax Taxable Amount Use Tax Deposits/Overpayment Credit Total Tax & Surcharge Balance Total Amount Due Bank Name Account Number Amount Payment Date CITY OF WATERLOO 1-07-025853 31-Aug-2023 19-Sep-2023 0-004-226-091 $44,456.54 $0.00 $0.00 $44,456.54 $2,667.39 $444.57 $0.00 $0.00 $0.00 $0.00 $0.00 $3,111.96 $3,111.96 $3,111.96 REGIONS BANK ****6001 $3,111.96 20-Sep-2023 This is a summary only and will not be accepted as a return by the Iowa Department of Revenue. Retain this document for personal records. Local Option Sales Details Confirmation Number: 0-004-226-091 Date: 19-Sep-2023 County Taxable Sales Local Option Local Option Tax (1.00%) Black Hawk County - 07 $44,456.54 $44,456.54 $444.57 $444.57 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. Sales and Use Return Summary Sales Tax Use Tax Final Balances Payment Information Name: Account ID: Filing Period: Date: Confirmation Number: Gross Sales Goods Consumed Total Exemptions Taxable Amount State Sales Tax (6%) Local Option Sales Tax Total Taxable Purchases Sales Subject to Use Tax Taxable Amount Use Tax Deposits/Overpayment Credit Total Tax & Surcharge Balance Total Amount Due Bank Name Account Number Amount Payment Date CITY OF WATERLOO 1-07-025854 31-Aug-2023 19-Sep-2023 0-004-266-202 $42,988.32 $0.00 $0.00 $42,988.32 $2,579.30 $429.88 $0.00 $0.00 $0.00 $0.00 $0.00 $3,009.18 $3,009.18 $3,009.18 REGIONS BANK ****6001 $3,009.18 20-Sep-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-004-266-202 Date: 19-Sep-2023 Taxable Sales Local Option Local Option Tax (1.00%) Black Hawk County - 07 $42,988.32 $42,988.32 $429.88 $429.88 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. Sales and Use Return Summary Sales Tax Use Tax Final Balances Payment Information Name: Account ID: Filing Period: Date: Confirmation Number: Gross Sales Goods Consumed Total Exemptions Taxable Amount State Sales Tax (6%) Local Option Sales Tax Total Taxable Purchases Sales Subject to Use Tax Taxable Amount Use Tax Deposits/Overpayment Credit Total Tax & Surcharge Balance Total Amount Due Bank Name Account Number Amount Payment Date CITY OF WATERLOO 1-07-025856 31-Aug-2023 19-Sep-2023 0-004-277-111 $3,191.64 $0.00 $0.00 $3,191.64 $191.50 $31.92 $0.00 $0.00 $0.00 $0.00 $0.00 $223.42 $223.42 $223.42 REGIONS BANK ****6001 $223.42 20-Sep-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-004-277-111 Date: 19-Sep-2023 Taxable Sales Local Option Local Option Tax (1.00%) Black Hawk County - 07 $3,191.64 $3,191.64 $31.92 $31.92 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. Sales and Use Return Summary Sales Tax Use Tax Final Balances Payment Information Name: Account ID: Filing Period: Date: Confirmation Number: Gross Sales Goods Consumed Total Exemptions Taxable Amount State Sales Tax (6%) Local Option Sales Tax Total Taxable Purchases Sales Subject to Use Tax Taxable Amount Use Tax Deposits/Overpayment Credit Total Tax & Surcharge Balance Total Amount Due Bank Name Account Number Amount Payment Date CITY OF WATERLOO 1-07-030335 31-Aug-2023 19-Sep-2023 0-004-311-187 $169,482.00 $0.00 $0.00 $169,482.00 $10,168.92 $1,694.82 $0.00 $0.00 $0.00 $0.00 $0.00 $11,863.74 $11,863.74 $11,863.74 REGIONS BANK ****6001 $11,863.74 19-Sep-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-004-311-187 Date: 19-Sep-2023 Taxable Sales Local Option Local Option Tax (1.00%) Black Hawk County - 07 $169,482.00 $169,482.00 $1,694.82 $1, 694.82 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. Sales and Use Return Summary Sales Tax Use Tax Final Balances Payment Information Name: Account ID: Filing Period: Date: Confirmation Number: Gross Sales Goods Consumed Total Exemptions Taxable Amount State Sales Tax (6%) Local Option Sales Tax Total Taxable Purchases Sales Subject to Use Tax Taxable Amount Use Tax Deposits/Overpayment Credit Total Tax & Surcharge Balance Total Amount Due Bank Name Account Number Amount Payment Date CITY OF WATERLOO 1-07-030336 31-Aug-2023 19-Sep-2023 0-004-315-283 $452,109.20 $0.00 $0.00 $452,109.20 $27,126.55 $4,521.09 $0.00 $0.00 $0.00 $0.00 $0.00 $31,647.64 $31,647.64 $31,647.64 REGIONS BANK ****6001 $31,647.64 20-Sep-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-004-315-283 Date: 19-Sep-2023 Taxable Sales Local Option Local Option Tax (1.00%) Black Hawk County - 07 $452,109.20 $4,521.09 $452,109.20 $4,521.09 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. Sales and Use Return Summary Sales Tax Use Tax Final Balances Payment Information Name: Account ID: Filing Period: Date: Confirmation Number: Gross Sales Goods Consumed Total Exemptions Taxable Amount State Sales Tax (6%) Local Option Sales Tax Total Taxable Purchases Sales Subject to Use Tax Taxable Amount Use Tax Deposits/Overpayment Credit Total Tax & Surcharge Balance Total Amount Due Bank Name Account Number Amount Payment Date CITY OF WATERLOO 1-07-037313 31-Aug-2023 19-Sep-2023 0-004-238-891 $9,496.26 $0.00 $0.00 $9,496.26 $569.78 $94.96 $0.00 $0.00 $0.00 $0.00 $0.00 $664.74 $664.74 $664.74 REGIONS BANK ****6001 $664.74 20-Sep-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-004-238-891 Date: 19-Sep-2023 Taxable Sales Local Option Local Option Tax (1.00%) Black Hawk County - 07 $9,496.26 $9,496.26 $94.96 $94.96 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. Sales and Use Return Summary Sales Tax Use Tax Final Balances Payment Information Name: Account ID: Filing Period: Date: Confirmation Number: Gross Sales Goods Consumed Total Exemptions Taxable Amount State Sales Tax (6%) Local Option Sales Tax Total Taxable Purchases Sales Subject to Use Tax Taxable Amount Use Tax Deposits/Overpayment Credit Total Tax & Surcharge Balance Total Amount Due Bank Name Account Number Amount Payment Date CITY OF WATERLOO 1-07-040732 31-Aug-2023 19-Sep-2023 0-004-202-027 $94,542.82 $0.00 $0.00 $94,542.82 $5,672.57 $945.43 $0.00 $0.00 $0.00 $0.00 $0.00 $6,618.00 $6,618.00 $6,618.00 REGIONS BANK ****6001 $6,618.00 20-Sep-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-004-202-027 Date: 19-Sep-2023 Taxable Sales Local Option Local Option Tax (1.00%) Black Hawk County - 07 $94,542.82 $94,542.82 $945.43 $945.43 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. Sales and Use Return Summary Sales Tax Use Tax Final Balances Payment Information Name: Account ID: Filing Period: Date: Confirmation Number: Gross Sales Goods Consumed Total Exemptions Taxable Amount State Sales Tax (6%) Local Option Sales Tax Total Taxable Purchases Sales Subject to Use Tax Taxable Amount Use Tax Deposits/Overpayment Credit Total Tax & Surcharge Balance Total Amount Due Bank Name Account Number Amount Payment Date CITY OF WATERLOO 1-07-025857 31-Aug-2023 19-Sep-2023 0-004-285-303 $2,357.50 $0.00 $0.00 $2,357.50 $141.45 $23.58 $0.00 $0.00 $0.00 $0.00 $0.00 $165.03 $165.03 $165.03 REGIONS BANK ****6001 $165.03 20-Sep-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-004-285-303 Date: 19-Sep-2023 Taxable Sales Local Option Local Option Tax (1.00%) Black Hawk County - 07 $2,357.50 $2,357.50 $23.58 $23.58 This is a summary only and will not be accepted as a return by the lows Department of Revenue. Retain this document for personal records. Sales and Use Return Summary Sales Tax Use Tax Final Balances Name: Account ID: Filing Period: Date: Confirmation Number: Gross Sales Goods Consumed Total Exemptions Taxable Amount State Sales Tax (6%) Local Option Sales Tax Total Taxable Purchases Sales Subject to Use Tax Taxable Amount Use Tax Deposits/Overpayment Credit Total Tax & Surcharge Balance Total Amount Due CITY OF WATERLOO 1-07-034601 31-Aug-2023 19-Sep-2023 0-004-306-067 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 This is a summary only and will not be accepted as a return by the Iowa Department of Revenue. Retain this document for personal records.