{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["REIMBURSEMENT FORM","MILEAGE LOG","MEAL LOG","TRANSPORTATION LOG","TRAVELER TIPS"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"REIMBURSEMENT FORM","index":0,"n_rows":46,"n_cols":13,"rows_kept":46,"cut":false,"hidden":false,"merged":[[16,6,16,7],[34,1,34,3],[29,1,29,12],[21,9,23,10],[45,3,45,7],[44,4,44,9],[43,7,43,9],[43,1,44,3],[43,4,43,5],[40,8,40,9],[40,10,40,11],[40,1,40,3],[43,12,44,12],[39,4,39,11],[42,1,42,3],[41,12,42,12],[36,1,36,3],[21,3,21,4],[23,7,23,8],[33,1,33,3],[23,1,23,2],[21,5,21,6],[25,3,26,12],[36,10,36,11],[30,1,30,3],[21,7,21,8],[21,11,21,12],[0,1,1,12],[6,1,6,12],[7,2,7,7],[8,2,8,7],[15,1,15,2],[14,1,14,12],[15,3,15,12],[7,9,7,12],[10,9,10,12],[11,1,11,7],[3,1,5,12],[45,8,45,11],[34,4,34,11],[8,9,8,11],[11,9,11,12],[32,4,32,11],[40,4,40,7],[42,4,42,9],[16,11,16,12],[18,1,18,12],[12,10,12,12],[41,4,41,9],[41,1,41,3],[10,1,10,2],[23,5,23,6],[35,9,35,11],[37,4,37,11],[38,1,38,3],[39,1,39,3],[10,5,10,7],[23,3,23,4],[37,1,37,3],[25,1,25,2],[21,1,21,2],[38,4,38,11],[36,4,36,9],[31,4,31,11],[32,1,32,3],[30,4,30,11],[35,1,35,3],[33,4,33,11],[31,1,31,3],[16,2,16,4]]}
[null,"APEP Travel Reimbursement Request Form"]
[]
[]
[null,"Please submit your request by following instructions found here"]
[]
[]
[null,"PAYEE INFORMATION"]
[null,"Name:",null,null,null,null,null,null,null,"Employee** (Including Student Employees)"]
[null,"Email:",null,null,null,null,null,null,null,"Non-Employee Student"]
[]
[null,"US Citizen:",null,"Yes","No*",null,null,null,null,"Unaffiliated Individual (Neither Employee/Student)"]
[null,"*Please provide a copy of your Permanent Resident card; or I-94, visa, passport and \"Certification of Academic Activity \" form. Not required for UCI students, faculty or staff.",null,null,null,null,null,null,null,"Vendor (e.g. Hotel, Travel Agency direct payments)"]
[null,"**Employees: make sure that your TEM profile is set up in KFS prior to submitting your reimbursement request",null,null,null,null,null,null,null,null,"follow these instructions"]
[]
[null,"Complete the following contact information only if payee is not a UCI employee:"]
[null,"Mailing Address:"]
[null,"City:",null,null,null,"State:",null,null,"Zip Code:",null,"Phone:"]
[]
[null,"TRIP INFORMATION"]
[]
[]
[null,"Departure Date:",null,null,null,"Return Date:",null,null,null,"Destination(City, State, Country):"]
[]
[null,"Departure Time: ",null,null,null,"Return Time: "]
[]
[null,"Trip Purpose:"]
[]
[]
[]
[null,"SUMMARY OF EXPENSES"]
[null,"Type of Expense",null,null,"Instructions/Policy           Click here for Info/Tips",null,null,null,null,null,null,null,"Amount"]
[null,"Airfare",null,null,"Itinerary, proof of payment & ticket number required on receipt",null,null,null,null,null,null,null,0]
[null,"Lodging",null,null,"Room & Tax only. Itemized Hotel bill/folio showing proof of payment required ",null,null,null,null,null,null,null,0]
[null,"Registration Fee",null,null,"Copy of registration form, proof of payment, dates and location are required",null,null,null,null,null,null,null,0]
[null,"Membership Fee",null,null,"Receipt showing proof of payment required.",null,null,null,null,null,null,null,0]
[null,"Taxi/Uber/Shuttle/Train",null,null,"Receipts required ",null,null,null,null,"Click here for Transportation Log",null,null,{"$f":"'TRANSPORTATION LOG'!K26","v":0}]
[null,"Rental Car",null,null,"Receipt showing contract agreement number & mileage in/out required. ",null,null,null,null,null,"Book Via Connexxus",null,0]
[null,"Parking",null,null,"Receipts required ",null,null,null,null,null,null,null,0]
[null,"Toll Road",null,null,"Receipts required ",null,null,null,null,null,null,null,0]
[null,"Other (Explain)",null,null,null,null,null,null,null,null,null,null,0]
[null,"Meals",null,null,"Itemized receipts required. \nPlease complete Daily Meal Log",null,null,null,"Click here for Meal Log",null,"Foreign Per Diem Rates",null,{"$f":"'MEAL LOG'!I33","v":0}]
[null,null,null,null,"Is any alcohol being reimbursed?"]
[null,null,null,null,"Did your registration fee include meals? If yes, please subtract from your Meal Log."]
[null,"Private Car Mileage",null,null,"Number of miles =",null,null,"Click here for Mileage Log",null,null,null,null,{"$f":"'MILEAGE LOG'!M37","v":0}]
[null,null,null,null,"Does the private car used have liability insurance?"]
[null,null,null,null,null,null,null,null,"Total amount to be reimubursed",null,null,null,{"$f":"SUM(M32,M33,M34,M35,M36,M37,M38,M39,M40,M41,M44)","v":0}]

{"sheet":"MILEAGE LOG","index":1,"n_rows":37,"n_cols":13,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,1,0,12],[1,1,1,12],[3,3,3,8],[22,6,22,10],[21,6,21,10],[10,1,10,12],[11,1,11,12],[12,1,12,12],[13,1,14,12],[18,6,18,10],[24,6,24,10],[23,6,23,10],[24,2,24,3],[16,6,16,10],[17,2,17,3],[19,6,19,10],[17,6,17,10],[19,2,19,3],[17,4,17,5],[18,2,18,3],[19,4,19,5],[18,4,18,5],[16,2,16,3],[16,4,16,5],[35,6,35,10],[26,4,26,5],[29,4,29,5],[31,6,31,10],[27,6,27,10],[26,6,26,10],[30,6,30,10],[31,4,31,5],[30,4,30,5],[29,6,29,10],[32,6,32,10],[28,6,28,10],[32,4,32,5],[34,6,34,10],[33,6,33,10],[34,4,34,5],[23,2,23,3],[22,2,22,3],[27,2,27,3],[24,4,24,5],[33,2,33,3],[25,6,25,10],[30,2,30,3],[20,6,20,10],[25,2,25,3],[35,2,35,3],[20,2,20,3],[21,2,21,3],[23,4,23,5],[22,4,22,5],[35,4,35,5],[26,2,26,3],[27,4,27,5],[21,4,21,5],[20,4,20,5],[31,2,31,3],[32,2,32,3],[34,2,34,3],[25,4,25,5],[28,2,28,3],[28,4,28,5],[29,2,29,3],[33,4,33,5]]}
[null,"MILEAGE LOG SHEET"]
[null,"Advanced Power and Energy Program"]
[]
[null,"Traveler's Name:"]
[]
[null,"Mileage Rate:",null,"0.655","*per mile","*"," $0.655 for travel that occurred after January 1, 2023"]
[]
[]
[null,"Instructions/Policies:"]
[]
[null," Mileage Log Sheet should accompany the Travel Reimbursement Form when mileage reimbursement is requested."]
[null," Private vehicle is required to have liability insurance coverage."]
[null,"For long distance trips, a private vehicle should only be used if it is more economical than airfare."]
[null,"Please attach a supporting document showing distance in miles (ie Google Maps). Mileage reimbursement between residence and primary workplace (commute) is excluded."]
[]
[]
[null,"Date","Departure   City/State",null,"Destination City/State",null,"Business Purpose",null,null,null,null,"# of Miles","Reimbursement Amount"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"L18*D$6","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"L19*D$6","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"L20*D$6","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(L18:L36)","v":0},{"$f":"SUM(M18:M36)","v":0}]

{"sheet":"MEAL LOG","index":2,"n_rows":33,"n_cols":9,"rows_kept":33,"cut":false,"hidden":false,"merged":[[8,1,8,8],[15,2,15,3],[16,2,16,3],[14,2,14,3],[14,4,14,5],[15,4,15,5],[24,2,24,3],[25,2,25,3],[18,6,18,7],[17,6,17,7],[16,6,16,7],[22,2,22,3],[22,4,22,5],[18,4,18,5],[22,6,22,7],[25,6,25,7],[24,6,24,7],[27,4,27,5],[26,4,26,5],[24,4,24,5],[26,6,26,7],[19,4,19,5],[17,4,17,5],[9,1,9,8],[12,1,12,8],[0,1,0,8],[1,1,1,8],[3,3,3,7],[16,4,16,5],[19,6,19,7],[17,2,17,3],[18,2,18,3],[19,2,19,3],[7,1,7,8],[11,1,11,8],[15,6,15,7],[14,6,14,7],[28,6,28,7],[27,6,27,7],[21,6,21,7],[21,4,21,5],[20,2,20,3],[28,4,28,5],[25,4,25,5],[28,2,28,3],[23,6,23,7],[21,2,21,3],[23,2,23,3],[23,4,23,5],[20,6,20,7],[20,4,20,5],[26,2,26,3],[27,2,27,3],[31,6,31,7],[30,6,30,7],[29,6,29,7],[29,4,29,5],[30,2,30,3],[31,2,31,3],[31,4,31,5],[30,4,30,5],[29,2,29,3]]}
[null,"DAILY MEAL LOG SHEET"]
[null,"Advanced Power and Energy Program"]
[]
[null,"Traveler's Name:"]
[]
[null,"Instructions/Policies:"]
[]
[null,"Daily Meal Log Sheet should accompany the Travel Reimbursement Form."]
[null,"No meal reimbursements for travel lasting less than 24 hours, unless the travel includes an “overnight stay” as supported by a lodging receipt"]
[null,"Itemized meal receipts are required and should be submitted along with Meal Log Sheet."]
[null,"Do not request a flat daily rate for domestic travel.  Use actual expense amounts.  There is no per diem for domestic travel."]
[null,"Domestic travel daily maximum reimbursement amount: $79"]
[null,"For travel outside the continental United States (Hawaii, Alaska, etc.) and foreign travel, please refer to the per diem rates set forth by the U.S. State Department."]
[]
[null,"Date","Breakfast",null,"Lunch",null,"Dinner",null,"Reimbursement Amount"]
[null,null,null,null,null,null,null,null,{"$f":"SUM(C16:H16)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(C17:H17)","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,{"$f":"SUM(C23:H23)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(C24:H24)","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,"Total  ",{"$f":"SUM(I16:I32)","v":0}]

{"sheet":"TRANSPORTATION LOG","index":3,"n_rows":26,"n_cols":11,"rows_kept":26,"cut":false,"hidden":false,"merged":[[13,7,13,9],[14,7,14,9],[15,7,15,9],[13,2,13,4],[14,2,14,4],[15,2,15,4],[13,5,13,6],[14,5,14,6],[15,5,15,6],[17,7,17,9],[16,5,16,6],[18,7,18,9],[16,2,16,4],[17,2,17,4],[18,2,18,4],[18,5,18,6],[24,7,24,9],[22,2,22,4],[23,2,23,4],[24,2,24,4],[22,5,22,6],[23,5,23,6],[24,5,24,6],[0,1,0,10],[1,1,1,10],[3,3,3,9],[22,7,22,9],[23,7,23,9],[20,7,20,9],[21,7,21,9],[19,2,19,4],[20,2,20,4],[21,2,21,4],[19,5,19,6],[20,5,20,6],[21,5,21,6],[19,7,19,9],[17,5,17,6],[16,7,16,9],[12,7,12,9],[11,1,11,10],[8,1,8,10],[12,2,12,4],[12,5,12,6],[9,1,9,10],[10,1,10,10]]}
[null,"TRANSPORTATION LOG SHEET"]
[null,"Advanced Power and Energy Program"]
[]
[null,"Traveler's Name:"]
[]
[]
[null,"Instructions/Policies:"]
[]
[null,"Please use this sheet to log your daily transportation expenses including taxi, shuttle, bus, train and ferry. (Do not include rental car expenses)"]
[null,"Please list each individual transportation expense on its own line"]
[null,"Original receipts showing proof of payment are required."]
[]
[null,"Date","Transportation from location",null,null,"Transportation to location",null,"Transportation Type",null,null,"Expense Amount"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Total  ",{"$f":"SUM(K9:K25)","v":0}]

{"sheet":"TRAVELER TIPS","index":4,"n_rows":36,"n_cols":2,"rows_kept":36,"cut":false,"hidden":false,"merged":[[2,0,2,1],[0,0,0,1],[1,0,1,1],[34,0,34,1],[35,0,35,1],[33,0,33,1],[5,0,6,0],[13,0,15,0],[8,0,10,0]]}
["APEP Traveler Guidelines"]
["These guidelines are not meant to be a comprehensive overview of UC travel policy. More information is available at http://www.accounting.uci.edu/travel/"]
["Connexxus, UC Managed Travel Program is recommended - CONNEXXUS"]
["Payee Information","Non-US citizens and non-permanent residents provide a copy of your passport, I-94 and completed Certification of Academic Activity form  (email mkm@apep.uci.edu to request a copy of the form). Not required for UCI students, faculty or staff."]
["Airfare","→Economy or coach class only."]
["Receipt required","→Receipt must show ticket number, flight dates and times, and proof/method of payment."]
[null,"→If travel extends more than 24 hours before and/or after direct University business, a comparison airfare is required at the time of ticket booking. Please identify and explain in the comments section any itinerary breaks or additions made for personal reasons*     Please identify and explain in the comments section any itinerary breaks or additions made for personal reasons"]
["Hotel","→Itemized folio for domestic travel must show proof/method of payment."]
["Receipt required","→If meals are included on a folio, they should be separated and moved to the Meal Log."]
[null,"→The domestic lodging cap is $275 per night (before taxes and fees)."]
[null,"→Per Diem rates for foreign lodging can be requested.  See rates published by location by the US Dept. of State."]
["Rental Car","→Companies with UC contracts should be used for business travel: Enterprise, National, Hertz"]
[null,"Book Your Enterprise, National, or Hertz Car Rental in ConnexUC  - https://accounting.uci.edu/travel/book/connexxus.html"]
["Receipt required","ConnexUC offers incredible discounts and savings, includes insurance when traveling on UC business, a free vehicle upgrade when available, and you can bypass long lines at most airport car rental counters by making sure you’ve signed up for one of the car rental agency’s premiere level memberships. The memberships are complimentary when booking through ConnexUC. "]
[null,"→Receipt must show proof/method of payment and mileage out/in."]
[null,"→Up to Intermediate class vehicle only."]
[null,"    → Upgrades and add-ons such as GPS rentals are not reimbursable."]
["Meals","DOMESTIC"]
["Itemized Receipt required","→Request meal reimbursement via Meal Log (Daily Max-$79 for domestic)"]
[null,"→Do not request a flat daily rate - there is no per diem rate for domestic travel.  Use actual expense amounts."]
[null,"→No meal reimbursements for travel less than 24 hours unless the travel includes an \"overnight stay\" as supported by a lodging receipt."]
[null,"→If meals are included as part of registration, they should be included on the Meal log"]
[null,"INTERNATIONAL"]
[null,"→Per Diem rates for foreign lodging can be requested.  See rates published by location by the US Dept. of State (https://aoprals.state.gov/web920/per_diem.asp)"]
["Transportation","→Transportation expenses shall be reimbursed based on the most economical mode of transportation and the most commonly traveled route consistent with the authorized purpose of the trip. Price comparisons are needed if it appears that a more expensive mode was used, such as"]
[null,"·          Use of personal car vs. airfare"]
[null,"·         Use of car service vs. shuttle or taxi"]
[]
["Mileage","→You are required to have liability insurance to request mileage reimbursement."]
[null,"→Fuel costs are factored into mileage rates, so fuel cannot be reimbursed in addition to mileage reimbursement"]
[null,"→Mileage shall ordinarily be computed between the traveler's headquarters and the common carrier or destination** "]
[null,"Mileage reimbursement rates: 65.5 cents per mile for travel that occurred after January 1, 2023"]
[]
["*Indirect or Interrupted Itineraries "]
["Obtaining advance approval is suggested when a traveler takes an indirect route or interrupts travel by a direct route, for other than University business. Any resulting additional expenses shall be borne by the traveler. The reimbursement of expenses shall be limited to the actual costs incurred or the charges that would have been incurred via a usually traveled route, whichever is less. The cost comparison should be based on what UC would have paid, which can be obtained by a Connexxus-related travel agency prior to or at the time of booking the trip. Any resulting excess travel time will not be considered work time, and will be charged to the appropriate type of leave. The employee shall be responsible for accurate reporting of such leave time. "]
["**Mileage shall ordinarily be computed between the traveler's headquarters and the common carrier or destination. Expenses for travel between the traveler's residence and headquarters (commuting expense) shall not be allowed. However, mileage expenses may be allowed between the traveler's residence and the common carrier or destination if University business travel originates or terminates during a regularly scheduled day off. "]