Loading...
HomeMy WebLinkAboutJanuaryJan Apr July Oct Net Taxable Sales Sales Tax Collected 6% 1% Total Sales Tax Leisure Services - Sports & Pools Sports 690.00 48.30 41.40 6.90 48.30 B rnes 0.00 0.00 0.00 0.00 0.00 Gales 0.00 0.00 0.00 0.00 0.00 2023 YEAR Monthly State Sales Tax Leisure Services - Golf Courses Gates Reg Im rov 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Warren Memorial Re 0.00 0.00 0.00 0.00 0.00 Im rov 0.00 0.00 0.00 0.00 South Re 815.19 57.06 48.91 8.15 0.00 57.06 Hills 1 mprov 7.24 0.51 0.43 0.07 0.51 Leisure - Office Re 0.00 0.00 0.00 0.00 0.00 Im rov 0.00 0.00 0.00 0.00 0.00 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 $ 48.30 I L Net Taxable Sales Sales Tax Collected 6% 1% Total Sales Tax Difference WM SERVICES Water Pollution 436,257.691 30,538.04, 26,175.46 Gates - Total I$ IGROSS SALES $ $ Sewer Garbage Storm Wtr 133,722.57 9,360.58 Young Arena 40,959.35 2,867.15 8,023.35 2,457.56 4,362.58 1,337.23 409.59 30,538.04 9,360.58 2,867.15 Total Tax Due 0.00 $ 30,538.04, REGIONS BANK 0.00 $ 9,360.58 0.00 $ 2,867.15 0.00 Sewer Tax Garbage Tax Storm Tax 4,736.08 2.16 4,622.34 Warren Mem - Total I$ - IGROSS SALES0.00 $ - $ - SportsPlex 154,991.86 10,849.43 9,299.51 1,549.92 10,849.43 0.00 9,299.51 1,549.92 $ 10,849.43 South Hills - Total I $ 57.57 (GROSS SALES 822.43 $ 57.06 $ 0.51 Leisure - Total I$ 6% 1% Total QTR 857 Sports 41.40 6.90 $ 48.30 QTR 856 Byrnes Pool 0.00 0.00 - QTR 855 Gates Pool 0.00 0.00 - 852 Gates 0.00 0.00 - 853 Warren 0.00 0.00 - 854 South Hills 49.00 8.00 57.00 QTR 601 Leisure Office 0.00 0.00 - 336 Wtr Pollution 26,175.00 4,363.00 30,538.00 335 Wtr/Swr/Gbg 8,023.00 1,337.00 9,360.00 313 Young Arena 2,458.00 410.00 2,868.00 732 SportsPlex 9,300.00 1,550.00 10,850.00 Firefox https://alo-nw.city.alo/nwerp/Temp/FileStorageCache/3TDOETLS.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-00001356 Invoice Department: CC City Clerk TREASURER, STATE OF IOWA IOWA DEPT OF REVENUE & FINANCE PO BOX 10412 DES MOINES, IA 50306-0412 Batch Date: 02/13/2023 Batch Number: 2023-00000965 Batch Description: SOUTH HILLS GOLF COURSE 01/31/2023 02/13/2023 02/13/2023 02/13/2023 1-07-025854 Check Sort Code: Check Code: Manual Check: Confirming EFT Check Number: Detail: P.O. Number C/D/F/T/A/1099 Description 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: 57.57 0.00 0.00 0.00 0.00 0.00 0.00 Amount/Unit Total Amount NIY/Y/N/N/N Conversion Item - SOUTH HILLS GOLF (IMPROV) G/L Distribution: G/L Account/Project 1.0000 EA 0.5100 0.51 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 - SOUTH HILLS GOLF COURSE PERMIT #1 07 025854 1.0000 EA 0.51 57.0600 0.00 57.06 Expensed Unencumbered 010-37-4120 1398 ( General Fund -Leisure Services -Golf Courses Sales Tax) Invoice Amount Expensed: $57.57 Invoice Amount Unencumbered: $0.00 57.06 0.00 $57.57 1 of 7 2/7/2023, 1:17 PM WATERLOO LEISURE SERVICES SALES TAX REPORT JANUARY 2023 ACTIVITY 4120 - GOLF COURSES 1398 SALES TAX GOLF REVENUE 7% TAX COLLECTED WARREN MEMORIAL 0.00 0.00 GATES 0.00 0.00 SOUTH HILLS 815.19 57.06 OFFICE 0.00 0.00 815.19 57.06 ACTIVITY 4125 - GOLF COURSE IMPROVEMENTS 1398 SALES TAX GOLF REVENUE 7% TAX COLLECTED WARREN MEMORIAL 0.00 0.00 GATES 0.00 0.00 SOUTH HILLS 7.24 0.51 OFFICE 0.00 0.00 7.24 0.51 2-3-23 Firefox https://alo-nw.city.alo/nwerp/Temp/FileStorageCache/3TDOETL5.htm 1434 - TREASURER, STATE OF 2023-00001357 YOUNG ARENA 1-07-037313 01/31/2023 02/13/2023 02/13/2023 02/13/2023 No Gross: 2,867.15 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: $2,867.15 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 1.0000 EA 07 037313 2,867.1500 2,867.15 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: $2,867.15 Invoice Amount Unencumbered: $0.00 2,867.15 0.00 2 of 7 2/7/2023, 1:17 PM 2/7/2023 YOUNG ARENA SALES TAX 010-37-4500-1398 Gross Taxable Sales January 2023 43,826.50 Net Taxable Sales January 2023 40,959.35 Total Tax January 2023 2,867.15 To: Ryan Stuber City Clerks Office Waterloo City Hall From: Madonna Welsh Leisure Services Firefox https://alo-nw.city.alo/nwerp/Temp/FileStorageCache/3TDOETL5.htm 1434 - TREASURER, STATE OF 2023-00001358 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 01/31/2023 02/13/2023 02/13/2023 02/13/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: 9,360.58 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 - GARBAGE PERMIT #1 07 030335 1.0000 EA 2.1600 2.16 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 2.16 4,736.0800 Expensed 0.00 4,736.08 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 4,736.08 0.00 4,622.3400 4,622.34 Expensed Unencumbered 521-07-7830 1398 ( Storm Water Fund -City Engineer -City Engineer Sales Tax) Invoice Amount Expensed: $9,360.58 Invoice Amount Unencumbered: $0.00 4,622.34 0.00 $9,360.58 3 of 7 2/7/2023, 1:17 PM RYAN STUBER From: Holly Sackett Sent: Thursday, February 2, 2023 4:03 PM To: RYAN STUBER Cc: Annette Shepherd Subject: Sales Tax Billed January 2023 Hi Ryan, I'm replacing Annette here soon! Here's the billed sales tax for January 23. Storm water- $4,622.34 Garbage- $2.16 Sewer $4,736.08 Thanks! golly Saud' Residential Billing Waterloo Water Works 325 Sycamore St Waterloo, IA 50703 319-232-6280 1 Firefox https://alo-nw.city.alo/nwerp/Temp/FileStorageCache/3TDOETL5.htm 1434 - TREASURER, STATE OF 2023-00001361 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 01/31/2023 02/13/2023 02/13/2023 1-07-030336 Check Sort Code: Check Code: Manual Check: Confirming EFT Check Number: Detail: P.O. Number C/D/F/IYA/1099 Description Total Invoice Items: 02/13/2023 Bank Account: ACCOUNTS PAYABLE Invoice Terms: Hold Reason: Quantity U/M No Gross: 30,538.04 Freight: 0.00 State Tax: 0.00 County Tax: 0.00 Local/City Tax: 0.00 Discount: 0.00 Retainage: 0.00 Net Amount: $30,538.04 Amount/Unit Total Amount N/Y/Y/N/N/N G/L Distribution: G/L Account/Project Conversion Item - WATER POLLUTION CONTROL 1-07-030336 1.0000 EA 30,538.0400 30,538.04 Expensed Unencumbered 520-14-5200 1398 ( Sanitary Sewer Fund -Waste Management -Water Pollution -Water Pollution Control Plant Op Sales Tax) Invoice Amount Expensed: $30,538.04 Invoice Amount Unencumbered: 30,538.04 $0.00 0.00 Batch Total Invoices: 6 Batch Total Gross: $53,721.07 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: $53,721.07 Batch Total Unencumbered: $0.00 Grand Total Invoices: 6 Grand Total Gross: $53,721.07 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: $53,721.07 6 of 7 2/7/2023, 1:17 PM Firefox https://alo-nw.city.alo/nwerp/Temp/FileStorageCache/3TDOETL5.htm Grand Total Unencumbered: $0.00 7 of 7 2/7/2023, 1:17 PM TAX REPORT FOR FEBURARY WASTE MANAGEMENT SERVICES Billing Dated 01/03/23 DECEMBER 2022 Usage NONTAXABLE ACTIVITY ACCT. B COMPANY NET BILLED TOTAL BILLED 5452 BLACK HAWK CARE FACILITY Na - 5453 BUCK HAWK COUNTY SOLID WASTE 2,108.83 Na 2,108.83 5641 BLACKHAWK COUNTY LANDFILL PRET 177.60 nle 177.60 14061 WATERLOO PROCESSING LLC 1,785.10 Na 1,765.10 5644 TYSON FOODS PRET 2,027.30 Na 2,027 30 7518 CONAGRA PRET 1,232.30 Na 1,232.30 13109 CONAGRA 5,798.47 Na 5,798.47 6602 J.D. ENGINE WORKS/annual lab fee Na - 5640 ARAMARK UNIFORM SERVICES/annual lab lee Na - 5643 HYDRITE CHEMICAL CO. PRET/annual lab fee Na 2191 Men Indualrial Coatngs/annual lab fee Na - 5641 BLACK HAWK COUNTY LANDFILL PRETlannual lab fee Na - 6464 DARLING INTERNATIONAL/annual lab fee Na - 5646 J.D. WESTFIELDannuel lab fee Na 14061 WATERLOO PROCESSING LLC/ annual lab lee Na - 5640 TysoNannu,l lab lee Na - 7518 Conagralarnoal lab fee Na - 20973 The Crown Grouplannual lab fee Na - 12486 PLANERGY Na 14453 VETS'S TRUCK WASHItablee Na - 10943 CANADIAN NATIONAL GROUNDWATER N0 10521 CANADIAN NATIONAL RAILWAY/annual lab lee Na 22509 City of Evansdale Na 22085 COOLEY PUMPING Na - 5640 Aramarldanraal lab fee Na - 23714 Advanced Drainage /annual lab lee We - 13874 J.D. PEC/annual lab fee Na - 12935 IOWA NORTHERN RAILWAY/annual lab fee Na NODNxable 13,10980 TAXABLE ACTIVITY ACCT9 COMPANY NET BILLED TAXED APPLIED TOTAL BILLED 5451 ARAMARK 5,435.67 380.50 5,816.17 14060 WATERLOO PROCESSING LLC 48,603.97 3,402.42 52,008.39 14060 TWIN CITY TANNERY CO - - 5438 TYSON FOODS 306,459.11 21,452.14 327,911.25 5457 JOHN DEERE • DONALD STREET 6,640.16 464.81 7,104.97 5458 JOHN DEERE • ENGINE WORKS 1,609.58 126.67 1,936.25 5452 Black Hawk Nursing 8 Rehab 3,564.51 249.52 3,814.03 5459 JOHN DEERE- FOUNDRY 8001 18.60 1.30 19.90 5460 JOHN DEERE- FOUNDRY 8002 546.06 38.22 584.28 5481 JOHN DEERE • PEG 1,322.68 106.59 1,629.27 5462 JOHN DEERE - BLDG 102011021 11,938.80 835.70 12,774.30 5463 JO • WESTFIELD 8 JEFFERSON 5,416.45 379.15 5,793.60 12409 JOHN DEERE Villa • BLDG A 814.26 57.00 871.26 10685 CN RAILWAY - 5638 DRAIN DOCTOR ' 6657 CONAGRA GROCERY PRODUCTS 30,145.91 2,11042 32,259.33 6960 HYDRITE CHEMICAL CO 288.33 20.18 308.51 7291 DARLING INTERNATIONAL • • 7324 SLACK HAWK WASTE • • 8747 LOST ISLAND METER 37.20 2.60 39.80 22671 Cedar Valley Portables ' 12557 A.1 SEPTIC 1,560.00 109.20 1,669.20 23461 Al Plus Septic 40.00 2.80 42.80 12313 SAVE OUR SINK • - 14452 VET'S TRUCK WASH 8,497.24 594.81 9,092.05 13654 GROTH SERVICES • 20319 PAUL COOLEY PUMPING COOLEY PUMPING 80.00 5.60 65.60 23413 Crystal Heating 8 Plumbing - • 20321 GREENS'S SEPTIC SERVICE 60.00 4.20 64.20 20635 22365 ACTIVE BIOMATERIALS • • Rote Roolar 190.00 13.30 203.30 21312 PLANERGY - 23496 Greenllne Polymer 2,584.38 180.91 2,765.27 SUBTOTAL TAXABLE 8 436,257.69 5 30,538.04 $ 066,795.73 Grand Total $ 436,257.69 5 30,538.04 6 479,905.33 Grand total of Posting Firefox https://alo-nw.city.alo/nwerp/Temp/FileStorageCache/3TDOETL5.htm 1434 - TREASURER, STATE OF 2023-00001359 RECREATION CENTER 1-07-025857 01/31/2023 02/13/2023 02/13/2023 02/13/2023 No Gross: 48.30 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: $48.30 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 - SPORTS SALES TAX PERMIT 1.0000 EA 48.3000 48.30 # 1 07 025857 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: $48.30 Invoice Amount Unencumbered: $0.00 48.30 0.00 4 of 7 2/7/2023, 1:17 PM SPORTS SALES TAX 010-37-4200 Jan-23 Byrnes Pool Daily Admissions (4200-3475) Pool Season Passes (4200-3475) Outdoor Pool Rentals (4200-3475) USSSA BB/SB (4200-3831) Elks/Kiwanis/Katoski Golf (4200-3831) Diamond Rentals (4200-3831) Adult BB/VB (4200-3897) To: Ryan Stuber City Clerks Office Waterloo City Hall From: Courtney Jackson Leisure Services SALES NET SALES SALES TAX 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 422.65 395.00 27.65 0.00 0.00 0.00 107.00 100.00 7.00 208.65 195.00 13.65 GROSS SALES TOTAL 738.30 NET SALES TOTAL 690.00 SALES TAX TOTAL 48.30 Firefox hops://alo-nw.city.alo/nwerp/Temp/FileStorageCache/3TDOETL5.htm 1434 - TREASURER, STATE OF 2023-00001360 IOWA Invoice Department: CC City Clerk TREASURER, STATE OF IOWA IOWA DEPT OF REVENUE & FINANCE PO BOX 10412 DES MOINES, IA 50306-0412 SPORTSPLEX 1-07-040732 Check Sort Code: Check Code: Manual Check: Confirming EFT Check Number: Detail: P.O. Number C/D/F/F/A/1099 Description 01/31/2023 02/13/2023 02/13/2023 02/13/2023 Bank Account: ACCOUNTS PAYABLE Invoice Terms: Hold Reason: Quantity U/M No Gross: 10,849.43 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,849.43 Amount/Unit Total Amount N/Y/Y/N/N/N G/L Distribution: G/L Account/Project Total Invoice Items: 1 Conversion Item - SALES TAX PERMIT # 1-07-040732 1.0000 EA 10,849.4300 10,849.43 Expensed Unencumbered 010-37-4180 1398 ( General Fund -Leisure Services-SportsPlex Sales Tax) 37SPLX.OPER ( CEDAR VALLEY SPORTSPLEX, SPORTSPLEX OPERATIONS) Invoice Amount Expensed: $10,849.43 Invoice Amount Unencumbered: $0.00 10,849.43 0.00 5 of 7 2/7/2023, 1:17 PM SPORTSPLEX SALES TAX 010-37-4180 Jan-23 Facility Rentals (4180-3623) Daily Admissions (4180-3832) Membership Fees (4180-3835) To: Ryan Stuber City Clerks Office Waterloo City Hall GROSS SALES 38,218.71 NET SALES SALES TAX 35,718.42 9,861.73 9,216.57 117,760.85 110,056.87 GROSS SALES TOTAL 165,841.29 NET SALES TOTAL 154,991.86 SALES TAX TOTAL 10,849.43 From: Courtney Jackson Leisure Services 2,500.29 645.16 7,703.98 Sales and Use Return Summa Sales Tax Name: Account ID: Filing Period: Date: Confirmation Number: Gross Sales Goods Consumed Total Exemptions Taxable Amount State Sales Tax (6%) Local Option Sales Tax $0.00 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 $50.0 Total Tax & Surcharge $57.57 Balance $57.57 Total Amount Due REGIONS BANK "'6001 Bank Name * Payment Information Account Number *6001 Amount 21-Fe$57.57 Payment Date CITY OF WATERLOO 1-07-025854 31-Jan-2023 21-Feb-2023 0-003-004-373 $822.43 $0.00 $0.00 $822.43 $49.35 $8.22 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-004-373 Date: 21-Feb-2023 Taxable Sales Local Option Local Option Tax (1.00%) Black Hawk County - 07 $822.43 $8.22 $822.43 $8.22 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-025857 Filing Period: 31-Jan-2023 Date: 21-Feb-2023 Confirmation Number: 0-002-996-181 Gross Sales Goods Consumed Total Exemptions Taxable Amount State Sales Tax (6%) Local Option Sales Tax $690.00 $0.00 $0.00 $690.00 $41.40 $6.90 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 $48.30 Balance $48.30 Total Amount Due $48.30 Payment Information Bank Name REGIONS BANK Account Number "*"6001 Amount $48.30 Payment Date 21-Feb-2023 This is a summary only and will not be accepted as a return by the Iowa Department of Revenue. Retain this document for personal records. Local Option Sales Details County Confirmation Number: 0-002-996-181 Date: 21-Feb-2023 Taxable Sales Local Option Local Option Tax (1.00%) Black Hawk County - 07 $690.00 $6.90 $690.00 $6.90 This is a summary only and will not be accepted as a return by the Iowa Department of Revenue. Retain this document for personal records. 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-Jan-2023 Date: 21-Feb-2023 Confirmation Number: 0-002-959-022 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 $133,722.57 $0.00 $0.00 $133,722.57 $8,023.35 $1,337.23 $0.00 $0.00 $0.00 $0.00 Deposits/Overpayment Credit $0.00 Total Tax & Surcharge $9,360.58 Balance $9,360.58 Total Amount Due $9,360.58 Bank Name REGIONS BANK Account Number ****6001 Amount $9,360.58 Payment Date 21-Feb-2023 This is a summary only and will not be accepted as a return by the Iowa Department of Revenue. Retain this document for personal records. Local Option Sales Details County Confirmation Number: 0-002-959-022 Date: 21-Feb-2023 Taxable Sales Local Option Local Option Tax (1.00%) Black Hawk County - 07 $133,722.57 $133,722.57 $1,337.23 $1,337.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. Sales and Use Return Summary Sales Tax Name: CITY OF WATERLOO Account ID: 1-07-030336 Filing Period: 31-Jan-2023 Date: 21-Feb-2023 Confirmation Number: 0-003-003-763 Gross Sales Goods Consumed Total Exemptions Taxable Amount State Sales Tax (6%) Local Option Sales Tax $436,257.69 $0.00 $0.00 $436,257.69 $26,175.46 $4,362.58 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 $30,538.04 Balance $30,538.04 Total Amount Due $30,538.04 Payment Information Bank Name REGIONS BANK Account Number ****6001 Amount $30,538.04 Payment Date 21-Feb-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-003-763 Date: 21-Feb-2023 Taxable Sales Local Option Local Option Tax (1.00%) Black Hawk County - 07 $436,257.69 $436,257.69 $4,362.58 $4,362.58 This is a summary only and will not be accepted as a return by the Iowa Department of Revenue. Retain this document for personal records. VENUE 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-Jan-2023 Date: 21-Feb-2023 Confirmation Number: 0-002-952-563 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 $40,959.35 $0.00 $0.00 $40,959.35 $2,457.56 $409.59 $0.00 $0.00 $0.00 $0.00 Deposits/Overpayment Credit $0.00 Total Tax & Surcharge $2,867.15 Balance $2,867.15 Total Amount Due $2,867.15 Bank Name REGIONS BANK Account Number ****6001 Amount $2,867.15 Payment Date 21-Feb-2023 This is a summary only and will not be accepted as a return by the Iowa Department of Revenue. Retain this document for personal records. Local Option Sales Details County Confirmation Number: 0-002-952-563 Date: 21-Feb-2023 Taxable Sales Local Option Local Option Tax (1.00%) Black Hawk County - 07 $40,959.35 $40,959.35 $409.59 $409.59 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. rtrruiri k ; E N U E 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-Jan-2023 Date: 21-Feb-2023 Confirmation Number: 0-002-990-037 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 $154,991.86 $0.00 $0.00 $154,991.86 $9,299.51 $1, 549.92 $0.00 $0.00 $0.00 $0.00 Deposits/Overpayment Credit $0.00 Total Tax & Surcharge $10,849.43 Balance $10,849.43 Total Amount Due $10,849.43 Bank Name REGIONS BANK Account Number ****6001 Amount $10,849.43 Payment Date 21-Feb-2023 This is a summary only and will not be accepted as a return by the Iowa Department of Revenue. Retain this document for personal records. Local Option Sales Details County Confirmation Number: 0-002-990-037 Date: 21-Feb-2023 Taxable Sales Local Option Local Option Tax (1.00%) Black Hawk County - 07 $154,991.86 $154,991.86 $1,549.92 $1,549.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. x, EVENUE Sales and Use Return Summary Sales Tax Use Tax Final Balances Name: CITY OF WATERLOO Account ID: 1-07-025856 Filing Period: 31-Jan-2023 Date: 21-Feb-2023 Confirmation Number: 0-002-987-379 Gross Sales Goods Consumed Total Exemptions Taxable Amount State Sales Tax (6%) Local Option Sales Tax Total Taxable Purchases Sales Subject to Use Tax Taxable Amount Use Tax $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Deposits/Overpayment Credit $0.00 Total Tax & Surcharge $0.00 Balance $0.00 Total Amount Due $0.00 This is a summary only and will not be accepted as a return by the Iowa Department of Revenue. Retain this document for personal records. Sales and Use Return Summary Sales Tax Use Tax Final Balances Name: CITY OF WATERLOO Account ID: 1-07-025852 Filing Period: 31-Jan-2023 Date: 21-Feb-2023 Confirmation Number: 0-003-066-492 Gross Sales Goods Consumed Total Exemptions Taxable Amount State Sales Tax (6%) Local Option Sales Tax Total Taxable Purchases Sales Subject to Use Tax Taxable Amount Use Tax $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Deposits/Overpayment Credit $0.00 Total Tax & Surcharge $0.00 Balance $0.00 Total Amount Due $0.00 This is a summary only and will not be accepted as a return by the Iowa Department of Revenue. Retain this document for personal records. ENUE Sales and Use Return Summary Sales Tax Use Tax Final Balances Name: CITY OF WATERLOO Account ID: 1-07-025853 Filing Period: 31-Jan-2023 Date: 21-Feb-2023 Confirmation Number: 0-002-980-526 Gross Sales Goods Consumed Total Exemptions Taxable Amount State Sales Tax (6%) Local Option Sales Tax Total Taxable Purchases Sales Subject to Use Tax Taxable Amount Use Tax $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Deposits/Overpayment Credit $0.00 Total Tax & Surcharge $0.00 Balance $0.00 Total Amount Due $0.00 This is a summary only and will not be accepted as a return by the Iowa Department of Revenue. Retain this document for personal records.