HomeMy WebLinkAboutSupplemental Attachments - 1/30/2023City of Waterloo
Finance Committee Preliminary Draft Invoice Report
For Janua 23 2023 Approval
Finance Committee Accounts Payable Open Invoice Report Total
As of Thursday, January 19, 2023
EFT Transactions:
Bank Fees
Treasurer, State of Iowa
Iowa Medicaid
Add: Gatso
Add:Wellmark
1,248,271.41
11,256.92
79,672.79
61,910.13
96, 300.00
150,466.74
1,647,877.99
Workers Compensation Issued by TPA October
Workers Compensation Issued by TPA November
Workers Compensation Issued by TPA December
Housing Authority Assistance EFT's
Housing Authority Assistance EFT's
Payroll
19,570.62
62,353.35
51,677.73
819.00
Bill Payment Total - Monday, Januaury 23, 2023
1,782,298.69
Payment to Council members or related entities:
City of Waterloo
Finance Committee Preliminary Draft Invoice Report
For Janua 30 2023 Approval
Finance Committee Accounts Payable Open Invoice Report Total
As of Thursday, January 26, 2023
EFT Transactions:
1,079,407.59
Add:Wellmark Claims 100,665.99
1,180,073.58
Workers Compensation Issued by TPA
Housing Authority Assistance EFT's
Housing Authority Assistance EFT's
Payroll
2,148.80
417,142.31
1,937,243.87
Bill Payment Total - Monday, Januaury 30, 2023
3,536,608.56
Payment to Council members or related entities:
FINANCE DEPT. STAFF ONLY
LINE ITEM USED 010-29-7700 1346
TRAVEL REQUEST
CITY OF WATERLOO
FY 23 BUDGETED $10,000.00 after amend
EXPENDED YTD $2,819.64
THIS REQUEST $3,033.13
LEFT AFTER THIS
REQUEST $4,147.23 after amend
DATE 1/18/23
Original - Clerk/Finance Copy - Department
NAME(S) AND POSITION(S):
David Deeds, Airport Board Member
DATE:
1/17/2023
NAME OF CLASS / MEETING:
Informa Routes World 2022 Conference
DESTINATION: LasVegas, NV
DEPARTURE POINT
IF NOT WATERLOO:
DEPARTURE DATE:
October 15, 2022
RETURN DATE:
October 19, 2022
DATE(S) OF MEETING:
October 16 - 18, 2022
PURPOSE OF TRAVEL/TRAINING:
Routes conference provided the opportunity to meet one-on-one with executives of various airlines.
Met with American, Avelo, Allegiant, Southwest and Spirit to let them know that Waterloo is
interested in expanded air service and discuss options to accomplish that.
WILL TRAVEL REQUIRE ADDITIONAL PERSONNEL:
X COST $
YES NO
METHOD OF TRAVEL:
CITY VEHICLE PRIVATE VEHICLE
X AIRFARE DEPARTING FROM: ALO
ESTIMATE OF COST:
685.73 LODGING
MEALS
1,814.40 REGISTRATION 533
MILEAGE/FUEL
TOTAL FOR ALL: $ 3,033.13
TAXI
PARKING
AIRFARE
MISC/TOLLS
BUDGET LINE ITEM: 010-29-7700 1346
X GRANT REIMBURSABLE
YES NO
X REQUIRED CERTIFICATION
YES NO
TOTAL: $ 3,033.13 PER PERSON
I BELIEVE THIS TRIP SERVES A PUBLIC PURPOSE
AND IS NECESSARY AND BENEFICIAL TO THE
CITY OF WATERLOO
Keith Kaspari
I APPROVE THIS TRAVEL REQUEST
Own -an 9rr/
DEPARTMENT HEAD MAYOR
1/17/2023
1/30/2023
DATE DATE
K:\Shared Goodies\Forms\Travel Request Form January 2010
TRAVEL REQUEST
CITY OF WATERLOO
FINANCE DEPT.
LINE ITEM USED
FY 2023 BUDGETED
EXPENDED YTD
THIS REQUEST
LEFT AFTER THIS
REQUEST
DATE
Original - Clerk/Finance
STAFF ONLY
010-11-1100-1346
$123,416.00
$78,461.78
$1,500.00
$43,454.22
1/5/23
Copy - Department
NAME(S) AND POSITION(S):
Detective Jeremy Pohl
DATE:
1/05/23
NAME OF CLASS / MEETING:
2023 National Cyber Crime Conference
DESTINATION: Norwood, Massachusetts
DEPARTURE POINT Waterloo
IF NOT WATERLOO:
DEPARTURE DATE:
4/24/23
RETURN DATE:
4/28/23
DATE(S) OF MEETING:
4/25/23 - 4/27/23
PURPOSE OF TRAVEL/TRAINING:
Lt. Bose is requesting to send Detective Jeremy Pohl to the 2023 National Cyber Crime Conference.
This course is being held at Norwood Massachusetts. The City is covering Registration, Hotel and Meals.
Not to exceed $1,500. The County Attorneys Office will cover all other expenses.
WILL TRAVEL REQUIRE ADDITIONAL PERSONNEL:
X COST $
YES NO
METHOD OF TRAVEL:
CITY VEHICLE
Yes AIRFARE
PRIVATE VEHICLE
DEPARTING FROM: Waterloo Airport
ESTIMATE OF COST:
$800.00 LODGING
$250.00 MEALS
$450.00 REGISTRATION
$C/A paying MILEAGE/FUEL
C/A Covering
C/A Covering
C/A Covering
TOTAL FOR ALL: $ 1,500.00
TAXI
PARKING
AIRFARE
MISC/TOLLS
BUDGET LINE ITEM:
X GRANT REIMBURSABLE
YES NO
X REQUIRED CERTIFICATION
YES NO
TOTAL: $ 1,500.00 PER PERSON
I BELIEVE THIS TRIP SERVES A PUBLIC PURPOSE
AND IS NECESSARY AND BENEFICIAL TO THE
CITY OF WATERLOO
Lt. Steve Bose
DEPARTMENT HEAD
1/5/23
I APPROVE THIS TRAVEL REQUEST
Qtter iz 9-tart
MAYOR
1/30/2023
DATE DATE
K:\Shared Goodies\Forms\Travel Request Form January 2010