![Page 1: Kuali Days VII Birds of a Feather Wednesday 2:15 – 3:15 PM Travel Management System](https://reader035.vdocuments.us/reader035/viewer/2022062719/56649ef05503460f94c007f9/html5/thumbnails/1.jpg)
Kuali Days VII
Birds of a Feather
Wednesday 2:15 – 3:15 PM
Travel Management System
![Page 2: Kuali Days VII Birds of a Feather Wednesday 2:15 – 3:15 PM Travel Management System](https://reader035.vdocuments.us/reader035/viewer/2022062719/56649ef05503460f94c007f9/html5/thumbnails/2.jpg)
Welcome
• John Harner, Director Travel Management at Indiana University
• Anne Bartlett, Lead Developer Travel@IU
• Marilyn Kisters, Subject Matter Expert - Workflow
![Page 3: Kuali Days VII Birds of a Feather Wednesday 2:15 – 3:15 PM Travel Management System](https://reader035.vdocuments.us/reader035/viewer/2022062719/56649ef05503460f94c007f9/html5/thumbnails/3.jpg)
Overview
• History of travel systems at IU
• Travel@IU Abstract
• Workflow Design
![Page 4: Kuali Days VII Birds of a Feather Wednesday 2:15 – 3:15 PM Travel Management System](https://reader035.vdocuments.us/reader035/viewer/2022062719/56649ef05503460f94c007f9/html5/thumbnails/4.jpg)
TAPS (Before)
• DOS based programming language
• Difficult to push out to end users
• Document initiation & approval continued to be paper
• Limited developer pool
• Reporting depended on the application developers
![Page 5: Kuali Days VII Birds of a Feather Wednesday 2:15 – 3:15 PM Travel Management System](https://reader035.vdocuments.us/reader035/viewer/2022062719/56649ef05503460f94c007f9/html5/thumbnails/5.jpg)
TAPS (Before)
• Limited interface with Financial System
• Database management was involved, continuous, and labor-intensive (done by Travel)
![Page 6: Kuali Days VII Birds of a Feather Wednesday 2:15 – 3:15 PM Travel Management System](https://reader035.vdocuments.us/reader035/viewer/2022062719/56649ef05503460f94c007f9/html5/thumbnails/6.jpg)
Travel Today
• J2EE Web Application/Oracle Database
• Foundation for 2009 Deployment
• Document initiation & approval continues to be paper
• Because it is developed in a widely used language developer pool has fewer limitations.
![Page 7: Kuali Days VII Birds of a Feather Wednesday 2:15 – 3:15 PM Travel Management System](https://reader035.vdocuments.us/reader035/viewer/2022062719/56649ef05503460f94c007f9/html5/thumbnails/7.jpg)
Travel@IU - Today
• Data has been dimensionally modeled and is no longer dependent on J2EE developers.
• Data input/output is easily configured (csv, xml)
• Transferring data to Financial System is much easier because of the database.
• Database management is being done by qualified DBAs
![Page 8: Kuali Days VII Birds of a Feather Wednesday 2:15 – 3:15 PM Travel Management System](https://reader035.vdocuments.us/reader035/viewer/2022062719/56649ef05503460f94c007f9/html5/thumbnails/8.jpg)
Travel@IU - 2009
• The document initiation will occur at the traveler/arranger level
• Workflow controls routing
• Receipts will be scanned and associated with the reimbursements
• Traveler/arrangers can track reimbursements
![Page 9: Kuali Days VII Birds of a Feather Wednesday 2:15 – 3:15 PM Travel Management System](https://reader035.vdocuments.us/reader035/viewer/2022062719/56649ef05503460f94c007f9/html5/thumbnails/9.jpg)
Travel@IU - 2009
• ReportingDetails of expenses are maintained, i.e., airfare,
taxi, hotel, per diem, etc.
Foreign vs. Domestic vs. In-State categories
By Individual
By Account
By Organization
By Campus
![Page 10: Kuali Days VII Birds of a Feather Wednesday 2:15 – 3:15 PM Travel Management System](https://reader035.vdocuments.us/reader035/viewer/2022062719/56649ef05503460f94c007f9/html5/thumbnails/10.jpg)
Travel@IU
Authorization -Encumber Funds -Payments
Authorization -Encumber Funds -Payments
PrepaymentPrepaymentBefore Trip
Before Trip
After TripAfter Trip
Reimbursement -Disencumber Funds -Expenses
Reimbursement -Disencumber Funds -Expenses
SupplementSupplement
TripTrip
Out-of-State?Out-of-State?
AdditionalPayments?Additional
Payments?
AdditionalExpenses?Additional
Expenses?
YesYes
NoNo
YesYes
YesYes
![Page 11: Kuali Days VII Birds of a Feather Wednesday 2:15 – 3:15 PM Travel Management System](https://reader035.vdocuments.us/reader035/viewer/2022062719/56649ef05503460f94c007f9/html5/thumbnails/11.jpg)
Trip - Authorization
![Page 12: Kuali Days VII Birds of a Feather Wednesday 2:15 – 3:15 PM Travel Management System](https://reader035.vdocuments.us/reader035/viewer/2022062719/56649ef05503460f94c007f9/html5/thumbnails/12.jpg)
Trip Header
![Page 13: Kuali Days VII Birds of a Feather Wednesday 2:15 – 3:15 PM Travel Management System](https://reader035.vdocuments.us/reader035/viewer/2022062719/56649ef05503460f94c007f9/html5/thumbnails/13.jpg)
Traveler Information
![Page 14: Kuali Days VII Birds of a Feather Wednesday 2:15 – 3:15 PM Travel Management System](https://reader035.vdocuments.us/reader035/viewer/2022062719/56649ef05503460f94c007f9/html5/thumbnails/14.jpg)
Destination Information
![Page 15: Kuali Days VII Birds of a Feather Wednesday 2:15 – 3:15 PM Travel Management System](https://reader035.vdocuments.us/reader035/viewer/2022062719/56649ef05503460f94c007f9/html5/thumbnails/15.jpg)
Account Information
![Page 16: Kuali Days VII Birds of a Feather Wednesday 2:15 – 3:15 PM Travel Management System](https://reader035.vdocuments.us/reader035/viewer/2022062719/56649ef05503460f94c007f9/html5/thumbnails/16.jpg)
Prepaid Expense
![Page 17: Kuali Days VII Birds of a Feather Wednesday 2:15 – 3:15 PM Travel Management System](https://reader035.vdocuments.us/reader035/viewer/2022062719/56649ef05503460f94c007f9/html5/thumbnails/17.jpg)
Cost Summary
![Page 18: Kuali Days VII Birds of a Feather Wednesday 2:15 – 3:15 PM Travel Management System](https://reader035.vdocuments.us/reader035/viewer/2022062719/56649ef05503460f94c007f9/html5/thumbnails/18.jpg)
Travel@IU
Authorization -Encumber Funds -Payments
Authorization -Encumber Funds -Payments
PrepaymentPrepaymentBefore Trip
Before Trip
After TripAfter Trip
Reimbursement -Disencumber Funds -Expenses
Reimbursement -Disencumber Funds -Expenses
SupplementSupplement
TripTrip
Out-of-State?Out-of-State?
AdditionalPayments?Additional
Payments?
AdditionalExpenses?Additional
Expenses?
YesYes
NoNo
YesYes
YesYes
![Page 19: Kuali Days VII Birds of a Feather Wednesday 2:15 – 3:15 PM Travel Management System](https://reader035.vdocuments.us/reader035/viewer/2022062719/56649ef05503460f94c007f9/html5/thumbnails/19.jpg)
Trip - Reimbursement
![Page 20: Kuali Days VII Birds of a Feather Wednesday 2:15 – 3:15 PM Travel Management System](https://reader035.vdocuments.us/reader035/viewer/2022062719/56649ef05503460f94c007f9/html5/thumbnails/20.jpg)
Destination Information
![Page 21: Kuali Days VII Birds of a Feather Wednesday 2:15 – 3:15 PM Travel Management System](https://reader035.vdocuments.us/reader035/viewer/2022062719/56649ef05503460f94c007f9/html5/thumbnails/21.jpg)
Account Information
1.67
1181.67
![Page 22: Kuali Days VII Birds of a Feather Wednesday 2:15 – 3:15 PM Travel Management System](https://reader035.vdocuments.us/reader035/viewer/2022062719/56649ef05503460f94c007f9/html5/thumbnails/22.jpg)
Reconciled Expenses
• Air• Lodging• Rental Car• Fuel• Limo
• Air• Lodging• Rental Car• Fuel• Limo
![Page 23: Kuali Days VII Birds of a Feather Wednesday 2:15 – 3:15 PM Travel Management System](https://reader035.vdocuments.us/reader035/viewer/2022062719/56649ef05503460f94c007f9/html5/thumbnails/23.jpg)
Expense Reconciliation Process
Vendor Invoice
DataVendor Invoice
Data
Credit Card Transactional
Data
Credit Card Transactional
Data
Expenses
• Air• Lodging• Rental Car• Fuel• Limo
Expenses
• Air• Lodging• Rental Car• Fuel• Limo
ReconciliationReconciliation
Batch Process
- Invoice/Itinerary Number- Trip Id - Account Number
![Page 24: Kuali Days VII Birds of a Feather Wednesday 2:15 – 3:15 PM Travel Management System](https://reader035.vdocuments.us/reader035/viewer/2022062719/56649ef05503460f94c007f9/html5/thumbnails/24.jpg)
Reimbursement Expenses
![Page 25: Kuali Days VII Birds of a Feather Wednesday 2:15 – 3:15 PM Travel Management System](https://reader035.vdocuments.us/reader035/viewer/2022062719/56649ef05503460f94c007f9/html5/thumbnails/25.jpg)
Cost Summary
![Page 26: Kuali Days VII Birds of a Feather Wednesday 2:15 – 3:15 PM Travel Management System](https://reader035.vdocuments.us/reader035/viewer/2022062719/56649ef05503460f94c007f9/html5/thumbnails/26.jpg)
Travel@IU
Authorization -Encumber Funds -Payments
Authorization -Encumber Funds -Payments
PrepaymentPrepaymentBefore Trip
Before Trip
After TripAfter Trip
Reimbursement -Disencumber Funds -Expenses
Reimbursement -Disencumber Funds -Expenses
SupplementSupplement
TripTrip
Out-of-State?Out-of-State?
AdditionalPayments?Additional
Payments?
AdditionalExpenses?Additional
Expenses?
YesYes
NoNo
YesYes
YesYes
![Page 27: Kuali Days VII Birds of a Feather Wednesday 2:15 – 3:15 PM Travel Management System](https://reader035.vdocuments.us/reader035/viewer/2022062719/56649ef05503460f94c007f9/html5/thumbnails/27.jpg)
Routing – Reimbursement
Route Level PurposeUn-routed (traveler or traveler’s arranger)
To initiate document
Traveler To allow travelers to approve trips generated by their arrangers
Content (for reimbursements with no account structure)
Organizations set this up so that initiator and traveler do not need to know the accounting string
Travel Department •adds mileage•assigns per diem rate•applies limits to expenses•removes unapproved expenses
![Page 28: Kuali Days VII Birds of a Feather Wednesday 2:15 – 3:15 PM Travel Management System](https://reader035.vdocuments.us/reader035/viewer/2022062719/56649ef05503460f94c007f9/html5/thumbnails/28.jpg)
Routing – Reimbursement
Route Level PurposeSub-Account Orgs that use sub-accounts can require approval
from individuals at this levelFiscal Officer/Delegate This route level endorses the use of the
accounts. Base Review Review at a higher level than the fiscal officer.
![Page 29: Kuali Days VII Birds of a Feather Wednesday 2:15 – 3:15 PM Travel Management System](https://reader035.vdocuments.us/reader035/viewer/2022062719/56649ef05503460f94c007f9/html5/thumbnails/29.jpg)
Routing – Reimbursement
Route Level PurposeSeparation of Duties •If the initiator is also the fiscal officer/delegate
and no other approval levels have seen the document (excluding the Travel Department) then this group will need to approve.•There is no dollar limit
Contract & Grants If the account was changed or dates of the trip are outside of the effective/expired dates on the C&G account.
![Page 30: Kuali Days VII Birds of a Feather Wednesday 2:15 – 3:15 PM Travel Management System](https://reader035.vdocuments.us/reader035/viewer/2022062719/56649ef05503460f94c007f9/html5/thumbnails/30.jpg)
Travel@IU - Future
• Non-Employee Travel (Reimbursements)
• Group Travel
• Single-sign on to Agency Vendors
• Route Documents to Tax
• Route Documents to Export Controls Office
![Page 31: Kuali Days VII Birds of a Feather Wednesday 2:15 – 3:15 PM Travel Management System](https://reader035.vdocuments.us/reader035/viewer/2022062719/56649ef05503460f94c007f9/html5/thumbnails/31.jpg)
Questions & Answers