The URL can be used to link to this page

Home My WebLink AboutSupplemental Attachments - 3/21/2022City of Waterloo Finance Committee Preliminary Draft Invoice Report For March 14 2022 approval Finance Committee Accounts Payable Open Invoice Report Total As of Thursday, March o9, 2022 Thursday Total Iowa Medicaid Enterprise 880,831.93 741,189.02 139,642.91 Add: Wellmark Claims 126,305.19 Workers Compensation Issued by TPA Housing Authority Assistance EFT's Housing Authority Assistance EFT's Payroll Bill Payment Total - Monday, March 14, 2022 Payment to Council members or related entities: Zac.-c...W-otvu 3-14i-aa#2 2 1,007,137.12 7,873.39 2,293.58 1,850,337.26 2,867,641.35 City of Waterloo Finance Committee Preliminary Draft Invoice Report For 1 2022 AppirL vat Finance Committee Accounts Payable Open Invoice Report Total As of Thursday, March 17, 2022 Thursday Total Iowa Medicaid Enterprise Sensys GATSO Bank Fees 2,690,643.06 Add: Wellmark Claims Update AMS Construction Check to VISA $14,425.00 2,579,675.50 71,593.33 31,140.00 8,234.23 173,386.15 2,864,029.21 Workers Compensation Issued by TPA Housing Authority Assistance EFT's Housing Authority Assistance EFT's Payroll 27,833.08 1,465.00 274,312.05 Bill Payment Total - Monday, March 21, 2022 3,167,639.34 Payment to Council members or ted et�t ties: FINANCE DEPT. STAFF ONLY LINE ITEM USED 224 32 5850 1346 TRAVEL REQUEST CITY OF WATERLOO FY 22 BUDGETED $10,000.00 EXPENDED YTD .000 THIS REQUEST LEFT AFTER THIS REQUEST 4,115.00 5,885.00 DATE 3-7-2022 Original - Clerk/Finance Copy - Department NAME(S) AND POSITION(S): Angie Fordyce/Anita Rousselow/Mindy Smith DATE: 3-7-2022 NAME OF CLASS / MEETING: National Community Development Association Annual Conference DESTINATION: St Paul, Minnesota DEPARTURE POINT IF NOT WATERLOO: DEPARTURE DATE: June 21, 2022 RETURN DATE: June 24, 2022 DATE(S) OF MEETING: June 21-24, 2022 PURPOSE OF TRAVEL/TRAINING: Annual Conference that focuses on Federal program updates and best practices. Also sessions on financial management of federal programs and developing written policies and procedures for new programs. WILL TRAVEL REQUIRE ADDITIONAL PERSONNEL: X COST $ YES NO METHOD OF TRAVEL: x CITY VEHICLE AIRFARE DEPARTING FROM: PRIVATE VEHICLE ESTIMATE OF COST: 1,500.00 315.00 2,000.00 150.00 LODGING MEALS REGISTRATION MILEAGE/FUEL 50.00 100.00 TOTAL FOR ALL: $ 4,115.00 TAXI PARKING AIRFARE MISC/TOLLS BUDGET LINE ITEM: 224 32 5850 1346 X GRANT REIMBURSABLE YES NO X REQUIRED CERTIFICATION YES NO TOTAL: $ 1,371.67 PER PERSON I BELIEVE THIS TRIP SERVES A PUBLIC PURPOSE AND IS NECESSARY AND BENEFICIAL TO THE CITY OF WATERLOO Rudy D Jones DEPARTMENT HEAD 3-7-2022 I APPROVE THIS TRAVEL REQUEST MAYOR 03/21/2022 DATE DATE K:\Shared Goodies\Forms\Travel Request Form January 2010 FINANCE DEPT. STAFF ONLY LINE ITEM USED 010-11-1100-1346 TRAVEL REQUEST CITY OF WATERLOO FY 2022 BUDGETED $117,300.00 EXPENDED YTD $66,114.68 THIS REQUEST $1,237.00 LEFT AFTER THIS REQUEST $49,948.32 DATE 3/3/22 Original - Clerk/Finance Cosy - Department NAME(S) AND POSITION(S): Investigator Joe Saunders DATE: 3/3//2022 NAME OF CLASS / MEETING: International Outlaw Motorcycle Gang Investigators Conference DESTINATION: DEPARTURE POINT IF NOT WATERLOO: Myrtle Beach, SC DEPARTURE DATE: 4/2/22 RETURN DATE: 4/8/22 DATE(S) OF MEETING: 4/2-8/22 PURPOSE OF TRAVEL/TRAINING: Inv. Saunders will be attending the Outlaw Motorcycle Gang Investigators Conference April 2-8, 2022 in Myrtle Beach, SC. Saunders is attached to the ATF Task force and investigates major crimes involving motorcycle gangs. The city will only be responsible for lodging, and food. The cost will not exceed $1,237.00. WILL TRAVEL REQUIRE ADDITIONAL PERSONNEL: X COST $ YES NO METHOD OF TRAVEL: CITY VEHICLE PRIVATE VEHICLE AIRFARE DEPARTING FROM: Waterloo PD ESTIMATE OF COST: 990.00 247.00 0.00 0.00 LODGING MEALS REGISTRATION MILEAGE/FUEL 0.00 TOTAL FOR ALL: $ 1,237.00 TAXI PARKING AIRFARE MISC/TOLLS BUDGET LINE ITEM: X GRANT REIMBURSABLE YES NO X REQUIRED CERTIFICATION YES NO TOTAL: $ 1,237.00 PER PERSON I BELIEVE THIS TRIP SERVES A PUBLIC PURPOSE AND IS NECESSARY AND BENEFICIAL TO THE CITY OF WATERLOO Lieutenant, Aaron McClelland I APPROVE THIS TRAVEL REQUEST DEPARTMENT HEAD MAYOR 3/3/22 03/21/2022 DATE DATE K:\Shared Goodies\Forms\Travel Request Form January 2010 FINANCE DEPT. STAFF ONLY LINE ITEM USED 010-11-1100-1346 TRAVEL REQUEST CITY OF WATERLOO FY 2022 BUDGETED $117,300.00 EXPENDED YTD $67,327.68 THIS REQUEST $1,213.00 LEFT AFTER THIS REQUEST $48,759.32 DATE 3/3/22 Original - Clerk/Finance Cosy - Department NAME(S) AND POSITION(S): Investigator Jeremy Pohl DATE: 3/3/2022 NAME OF CLASS / MEETING: National Cyber Crime Conference 2022 DESTINATION: DEPARTURE POINT IF NOT WATERLOO: Norwood, MA DEPARTURE DATE: 4/26/22 RETURN DATE: 4/28/22 DATE(S) OF MEETING: 4/26-28/22 PURPOSE OF TRAVEL/TRAINING: Inv. Pohl will be attending the 2022 National Cyber Crime Conference April 26-28, 2022 in Norwood, MA. Inv. Pohl is a Data Recover Investigator for the WPD along with many outside agencies in the area. This cost of this conference will be split between the BHC Attorney's Office and the city. The cities cost will not exceed $1,213.00 WILL TRAVEL REQUIRE ADDITIONAL PERSONNEL: X COST $ YES NO METHOD OF TRAVEL: CITY VEHICLE PRIVATE VEHICLE AIRFARE DEPARTING FROM: Waterloo PD ESTIMATE OF COST: 0.00 (BHC) 303.00 0.00 (BHC) 360.00 LODGING MEALS REGISTRATION MILEAGE/FUEL 350.00 200.00 TOTAL FOR ALL: $ 1,213.00 TAXI PARKING AIRFARE MISC/TOLLS BUDGET LINE ITEM: X GRANT REIMBURSABLE YES NO X REQUIRED CERTIFICATION YES NO TOTAL: $ 1,213.00 PER PERSON I BELIEVE THIS TRIP SERVES A PUBLIC PURPOSE AND IS NECESSARY AND BENEFICIAL TO THE CITY OF WATERLOO Lieutenant, Aaron McClelland I APPROVE THIS TRAVEL REQUEST DEPARTMENT HEAD MAYOR 3/3/22 03/21 /2022 DATE DATE K:\Shared Goodies\Forms\Travel Request Form January 2010 TRAVEL REQUEST CITY OF WATERLOO FINANCE DEPT. LINE ITEM USED FY 2022 BUDGETED EXPENDED YTD THIS REQUEST LEFT AFTER THIS REQUEST DATE Original - Clerk/Finance STAFF ONLY 1345 $6,000 3015.58 2100.00 884.42 3/9/22 Cosy - Department NAME(S) AND POSITION(S): Quentin Hart, Mayor DATE: 3/9/22 NAME OF CLASS / MEETING: African American Mayor's Association Conference DESTINATION: DEPARTURE POINT IF NOT WATERLOO: Washington, D.C. DEPARTURE DATE: 4/26/22 RETURN DATE: 4/30/22 DATE(S) OF MEETING: 4/27/22-4/29/22 PURPOSE OF TRAVEL/TRAINING: The 2022 African American Mayors Association annual conference is an occasion to converse with decision -makers in the public sector and an opportunity to share successful strategies and new ideas. All in attendance, from mayors to corporate executives, can seize the opportunity to engage and connect with vital stakeholders in the transformation of our cities. WILL TRAVEL REQUIRE ADDITIONAL PERSONNEL: X COST $ YES NO METHOD OF TRAVEL: x CITY VEHICLE PRIVATE VEHICLE AIRFARE DEPARTING FROM: ESTIMATE OF COST: $1200 LODGING $150 $250 MEALS REGISTRATION MILEAGE/FUEL $0 No Chg $500 TOTAL FOR ALL: $ 2100 TAXI PARKING AIRFARE MISC/TOLLS BUDGET LINE ITEM: 010-01-8200-1345 X GRANT REIMBURSABLE YES NO X REQUIRED CERTIFICATION YES NO TOTAL: $ 2100 PER PERSON I BELIEVE THIS TRIP SERVES A PUBLIC PURPOSE AND IS NECESSARY AND BENEFICIAL TO THE CITY OF WATERLOO Quentin Hart DEPARTMENT HEAD 3/9/22 I APPROVE THIS TRAVEL REQUEST av2i1- Hr--1-- DIGITALLY SIGNED NI MAYOR 03/21 /2022 DATE DATE K:\Shared Goodies\Forms\Travel Request Form January 2010