{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Expense Auth Form","Expense Reconciliation","Athletic-UIL ","Per Diem Rate ","NOTES"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":4,"comments":2,"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":"Expense Auth Form","index":0,"n_rows":85,"n_cols":18,"rows_kept":85,"cut":false,"hidden":false,"merged":[[4,2,4,3],[0,0,0,17],[1,0,1,17],[2,12,2,13],[2,14,2,17],[3,14,3,17],[60,1,60,5],[61,1,61,5],[5,2,5,6],[6,2,6,6],[58,1,58,5],[59,1,59,5],[9,1,9,3],[9,4,9,5]]}
["POR VIDA ACADEMY"]
["Expense Authorization Form"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Printed…",null,{"$f":"NOW()","v":"2025-02-13T09:28:02.770"}]
["I   EMPLOYEE INFORMATION",null,null,null,"Revision Date:","2025-02-13",null,null,null,null,null,null,null,null,{"$f":"NOW()","v":45701.394476504633}]
[null,"      NAME",null,null,"Revision #","45"]
[null,"DESTINATION"]
[null,"PURPOSE"]
[null,"Departure Date    ",null,{"$f":"IF(C8=\"\",\"\",+C8)","v":""},"Return Date",null,{"$f":"IF(F8=\"\",\"\",+F8)","v":""}]
[]
[null,"Campus  ------>> Please Pick  one Location ---->>",null,null,"Por Vida Academy at Corpus Christi"]
[null,null,null,null,null,null,null,"Estimated","Pay By","Fund","Func","Obj","Opt 1&2","Org","FY","PIC","Opt 3","Opt 4&5"]
["II  TRANSPORTATION ",null,null,null,null,null,null,"Cost","Method","X X X","X X","X X X X","X X","X X X","X","XX","X","XX"]
[null,"  A.  Mileage",null,0,"Miles X",0.7,"Per Mile =",{"$f":"D13*F13","v":0}]
[null,"  B.  Auto/Van Rental ",null,0,"Days   X",0,"Per day =",{"$f":"+D14*F14","v":0}]
[null,"  C.  Gasoline for Rental Vehicle",null,null,null,null,null,0]
[null,"  D.  Airfare",null,null,null,null,null,0]
[null,"  E.  Gas for school vehicles",null,null,null,null,null,0]
[null,"  F.  Gas for school maintenance equipment",null,null,null,null,null,0]
[null,null,null,null,null,"Sub Total",null,{"$f":"SUM(H13:H18)","v":0}]
[null,null,null,"Room Rate","Room Rate",null,"# Of  ",null,null,"Fund","Func","Obj","Opt 1&2","Org","FY","PIC","Opt 3","Opt 4&5"]
["III  LODGING ",null,"Destination","W/O Taxes","Taxes",null,"Nights",null,null,"X X X","X X","X X X X","X X","X X X","X","XX","X","XX"]
["1.","Instate Lodging  Actual",null,0,0,"X # of Nights",0,{"$f":"(+D22+E22)*G22","v":0}]
[]
[]
["2.","Out of State Lodging 1st Stop",null,0,0,"X # of Nights",0,{"$f":"IF(D25>D26,\"Over Limit\",(D25+E25)*G25)","v":0}]
[null,"Out of State Lodging 1st Stop Limit",null,0]
[null,"Out of State Lodging 2nd Stop",null,0,0,"X # of Nights",0,{"$f":"IF(D27>D28,\"Over Limit\",(D27+E27)*G27)","v":0}]
[null,"Out of State Lodging 2nd Stop Limit",null,0]
[null,"Out of State Lodging 3rd Stop",null,0,0,"X # of Nights",0,{"$f":"IF(D29>D30,\"Over Limit\",(D29+E29)*G29)","v":0}]
[null,"Out of State Lodging 3rd Stop Limit",null,0]
[null,"Out of State Lodging 4th Stop",null,0,0,"X # of Nights",0,{"$f":"IF(D31>D32,\"Over Limit\",(D31+E31)*G31)","v":0}]
[null,"Out of State Lodging 4th Stop Limit",null,0]
[null,null,null,null,null,"Sub Total",null,{"$f":"+H22+SUM(H25:H32)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Fund","Func","Obj","Opt 1&2","Org","FY","PIC","Opt 3","Opt 4&5"]
["IV  MEALS ( Per Day )",null,"Destination",null,"Per Diem Rate",null,null,null,null,"X X X","X X","X X X X","X X","X X X","X","XX","X","XX"]
["A",null,null,null,null,null,null,{"$f":"E37","v":0}]
[null,null,null,null,null,null,null,{"$f":"E38","v":0}]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[]
["B","Meeting Meals",null,"# of Attendees","MEAL","TIPS"]
[null,"Attendees Names:",null,0,0,0,null,{"$f":"+E53+F53","v":0}]
[]
[null,null,null,null,null,"Sub Total",null,{"$f":"SUM(H37:H54)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Fund","Func","Obj","Opt 1&2","Org","FY","PIC","Opt 3","Opt 4&5"]
["V.  Other Expenses/Information ",null,null,null,null,null,null,null,null,"X X X","X X","X X X X","X X","X X X","X","XX","X","XX"]
["A",null,null,null,null,null,null,0]
["B",null,null,null,null,null,null,0]
["C",null,null,null,null,null,null,0]
["D",null,null,null,null,null,null,0]
[null,null,null,null,null,"Sub Total",null,{"$f":"SUM(H59:H62)","v":0}]
[]
["Requested By",null,null,"DATE",null,"Total Cost",null,{"$f":"+H19+H33+H55+H63","v":0},null,{"$f":"H65-H53","v":0}]
[]
["Approved By",null,null,"DATE"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Central Administration",null,null,null,"Check"]
[null,null,null,null,"Por Vida Academy",null,null,null,"Credit Card"]
[null,null,null,null,"Por Vida Academy at Corpus Christi",null,null,null,"Invoice"]
[null,null,null,null,null,null,null,null,"PO"]
[null,null,null,null,null,null,null,null,"Empl Pd"]

{"sheet":"Expense Reconciliation","index":1,"n_rows":43,"n_cols":14,"rows_kept":43,"cut":false,"hidden":false,"merged":[[5,0,5,1],[5,2,5,6],[0,0,0,13],[1,0,1,13],[4,0,4,1],[4,2,4,3],[4,8,4,12],[6,0,6,1],[6,2,6,6],[7,1,7,2],[7,3,7,4],[8,1,8,2],[8,3,8,4],[10,1,10,6],[10,9,10,12],[40,1,40,2],[40,5,40,6],[42,1,42,2],[42,5,42,6],[40,10,40,12],[42,10,42,12],[39,10,39,12],[41,10,41,12]]}
["Por Vida, Inc"]
["Expense Reconcilation"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Printed…",{"$f":"NOW()","v":"2025-02-13T09:28:02.770"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"NOW()","v":45701.394476504633}]
["NAME",null,{"$f":"+'Expense Auth Form'!C5:D5","v":0},null,null,null,null,"Note -->>","Yellow Cells are your Data Entry Fiels"]
["Destination",null,{"$f":"+'Expense Auth Form'!C6:G6","v":0}]
["Purpose",null,{"$f":"+'Expense Auth Form'!C7:G7","v":0}]
["Departure Date",{"$f":"+'Expense Auth Form'!C8","v":"00:00:00"},null,{"$f":"IF(B8=\"\",\"\",+B8)","v":"00:00:00"}]
["Return Date",{"$f":"+'Expense Auth Form'!F8","v":"00:00:00"},null,{"$f":"IF(B9=\"\",\"\",+B9)","v":"00:00:00"}]
[]
[null," ---Transportation---",null,null,null,null,null,null,null," -Other Expenses/Information-"]
[null,null,null,"Gas for",null,"Gas for","Gas For",null,null,null,null,null,null,"TOTAL"]
[null,"Mileage","Auto/Van","Rentals",null,"School ","School",null,null,"A","B","C","D","EXPENSES"]
[null,"Amount","Rentals","Vehicles","Air Fare","Bus/Vehicles","Maint Equp","Lodging","Meals","Other","Other","Other","Other","PER DAY"]
[{"$f":"IF('Expense Auth Form'!B37=\"\",\"\",'Expense Auth Form'!B37)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B15:M15)","v":0}]
[{"$f":"IF('Expense Auth Form'!B38=\"\",\"\",'Expense Auth Form'!B38)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF('Expense Auth Form'!B39=\"\",\"\",'Expense Auth Form'!B39)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF('Expense Auth Form'!B40=\"\",\"\",'Expense Auth Form'!B40)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF('Expense Auth Form'!B41=\"\",\"\",'Expense Auth Form'!B41)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF('Expense Auth Form'!B42=\"\",\"\",'Expense Auth Form'!B42)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF('Expense Auth Form'!B43=\"\",\"\",'Expense Auth Form'!B43)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF('Expense Auth Form'!B44=\"\",\"\",'Expense Auth Form'!B44)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B22:M22)","v":0}]
[{"$f":"IF('Expense Auth Form'!B45=\"\",\"\",'Expense Auth Form'!B45)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF('Expense Auth Form'!B46=\"\",\"\",'Expense Auth Form'!B46)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF('Expense Auth Form'!B47=\"\",\"\",'Expense Auth Form'!B47)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF('Expense Auth Form'!B48=\"\",\"\",'Expense Auth Form'!B48)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF('Expense Auth Form'!B49=\"\",\"\",'Expense Auth Form'!B49)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF('Expense Auth Form'!B50=\"\",\"\",'Expense Auth Form'!B50)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0]
["Actual Total",{"$f":"SUM(B15:B28)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["Prepaid Total",{"$f":"+'Expense Auth Form'!H13","v":0},{"$f":"+'Expense Auth Form'!H14","v":0},{"$f":"+'Expense Auth Form'!H15","v":0},{"$f":"+'Expense Auth Form'!H16","v":0},{"$f":"+'Expense Auth Form'!H17","v":0},{"$f":"+'Expense Auth Form'!H18","v":0},{"$f":"+'Expense Auth Form'!H33","v":0},{"$f":"+'Expense Auth Form'!H55","v":0},{"$f":"+'Expense Auth Form'!H59","v":0},{"$f":"+'Expense Auth Form'!H60","v":0},{"$f":"+'Expense Auth Form'!H61","v":0},{"$f":"+'Expense Auth Form'!H62","v":0},{"$f":"SUM(B30:M30)","v":0}]
[]
["Difference on CC?"]
[]
["Difference  ",{"$f":"IF(B32=\"y\",0,B29-B30)","v":0},{"$f":"IF(C32=\"y\",0,C29-C30)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(B34:M34)","v":0}]
[]
["Due to Employee",{"$f":"IF(B32=\"y\",0,IF(B29>B30,B29-B30,0))","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(B36:M36)","v":0}]
[]
["Due From Employee",{"$f":"IF(B32=\"Y\",0,IF(B29>B30,0,B30-B29))","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(B38:M38)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N36>N38,\"Due To Employee\",\"\")","v":""},null,null,{"$f":"IF(N36>N38,N36-N38,0)","v":0}]
["Submitted by:",null,null,null,"Date"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N38>N36,\"Due From Employee\",\"\")","v":""},null,null,{"$f":"IF(N38>N36,N38-N36,0)","v":0}]
["Approved by:",null,null,null,"Date"]

{"sheet":"Athletic-UIL ","index":2,"n_rows":34,"n_cols":12,"rows_kept":34,"cut":false,"hidden":false,"merged":[[15,8,15,9],[0,0,0,11],[1,0,1,11],[4,6,4,7],[5,0,5,1],[5,2,5,3],[5,8,5,10],[32,1,32,2],[32,5,32,6],[33,1,33,2],[33,5,33,6],[6,0,6,1],[6,2,6,4],[8,1,8,2],[9,1,9,2],[15,3,15,5]]}
["Por Vida, Inc."]
["Athletic/UIL Expense Reconciliation"]
[null,null,null,null,null,null,null,null,null,null,"Printed…",{"$f":"NOW()","v":"2025-02-13T09:28:02.770"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"NOW()","v":45701.394476504633}]
[]
["Coach",null,null,null,null,null,null,"Note -->>","Yellow Cells are your Data Entry Fiels"]
["Destination / Purpose"]
[null,null,null,null,null,null,null,"Please provide receipts for all expidentures"]
["Departure Date",null,null,{"$f":"IF(B9=\"\",\"\",+B9)","v":""}]
["Return Date",null,null,{"$f":"IF(B10=\"\",\"\",+B10)","v":""}]
[]
["Fund","Func","Obj","Opt 1&2","Org","FY","PIC","Opt 3","Opt 4&5"]
["X X X","X X","X X X X","X X","X X X","X","XX","X","XX"]
[420,36,null,"00",null,null,91,0,"00"]
[]
[]
[null,"Number of","Number of",null,null,"Gas for",null,null,null,null,null,"TOTAL"]
[null,"Staff","Student",null,"Auto/Van","Rentals",null,null,null,null,null,"EXPENSES"]
["Date","Attendees","Attendees","Meals","Rentals","Vehicles","Lodging","Mileage","Parking","Other","Description","PER DAY"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D20:J20)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
["Sub Total",null,null,{"$f":"SUM(D20:D27)","v":0},0,0,0,0,0,0,null,0]
["Credit Card",null,null,0,0,0,0,0,0,0,null,{"$f":"SUM(D29:J29)","v":0}]
["Due to Emp",null,null,{"$f":"IF(D28=0,\"\",IF(D28>D29,D28-D29,\"\"))","v":""},"","","","","","",null,{"$f":"SUM(D30:J30)","v":0}]
["Due From Emp",null,null,{"$f":"IF(D28=0,\"\",IF(D28<D29,D29-D28,\"\"))","v":""},"","","","","","",null,{"$f":"SUM(D31:J31)","v":0}]
[]
["Submitted by:",null,null,null,"Date"]
["Approved by:",null,null,null,"Date"]

{"sheet":"Per Diem Rate ","index":3,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["To look up the current per diem rates click on the below link:"]
[]
[null,"https://www.gsa.gov/travel/plan-book/per-diem-rates"]

{"sheet":"NOTES","index":4,"n_rows":50,"n_cols":2,"rows_kept":50,"cut":false,"hidden":false,"merged":[[0,0,0,10],[27,0,27,10]]}
["Expense Authorization Form"]
[]
[1,"Section I - Fill out completely - employee information."]
[]
[2,"Section II Transportation - Fill out the row that you will be needing, i.e. row A. - Mileage. "]
[null,"If traveling to Corpus you don't need a mapquest. Set mileage is at 280 miles.  Any other city please provide a mapquest."]
[null,"Under column I  Pay by Method -  make sure you specify if you will be needing a check or charging to credit card."]
[null,"Fill out the accounting code you will be using. "]
[]
[3,"Section III Lodging -  Fill out your destination, room rate w/o taxes, room rate taxes, and number of days."]
[null,"Under Room rate w/o taxes column you will see a comment pick the city you are going to. If you don't see your city, use Standard rate."]
[null,"Under Room rate taxes column you will see a comment.  Click on it to see City tax rates."]
[null,"Under column I  Pay by Method -  make sure you specify if you will be needing a check or charging to credit card."]
[null,"Fill out the accounting code you will be using. "]
[]
[4,"Section IV Meals - Fill out each date of travel, destination, per diem rate, and number of days is always one."]
[null,"I.E. If traveling for three days you should have three rows filled out one row per day."]
[null,"Under column I  Pay by Method -  make sure you specify if you will be needing a check or charging to credit card."]
[null,"Fill out the accounting code you will be using. "]
[]
[5,"Section V  - You fill out this section if you are have any other expenses on this travel. Example \"Regstration Fee, Parking,etc\""]
[null,"Under column I  Pay by Method -  make sure you specify if you will be needing a check or charging to credit card."]
[null,"Fill out the accounting code you will be using. "]
[]
[null,"Sign your name on the Requested by line and date it.  Make sure your Principal signs on the Approved by line and dates it."]
[]
[]
["Expense Reconciliation Form"]
[]
[1,"Your top section will be populated from the information you entered on the Expense Authorization form."]
[]
[2,"Complete Column B through M then proceed to # 3 below to complete Column I."]
[]
[3,"Go down to Row 45 to complete the correct per diem tier.   Go down to Row 95 for First & Last Day travel."]
[]
[4,"You will go to Column F - Actual and drop your receipt amounts for each meal Breakfast, Lunch and Dinner you had for the first day. "]
[null,"Your IE row is for tips given, make sure Tip is on receipt. You will be allowed Actual Expenses up to the Per Diem Rate !!!"]
[null,"If your actual expenses are less than the Per Diem Rate, you will need to reimburse Por Vida !!!!"]
[]
[5,"Continue to enter actual receipt amounts for each meal you had per day, If this is your last day then go to step 3 above."]
[]
[6,"Once you have entered all your meals, column I will be populated by the amounts you entered in the bottom section."]
[null,"You will see an amount either on Due to Employee or on Due from Employee."]
[]
[null,"Sign your name on the Submitted by line and date it.  Make sure your Principal signs on the Approved by line and dates it."]
[]
["***","Important NOTE - new EDGAR rules"]
[null,"Food - will be reimbursed on actual food costs at the Per Diem rate for the city/town."]
[null,"Food - actual receipts must be provided to be reimbursable, otherwise no receipts no reimbursement."]
[null,"Food - no left over Per Diem dollars from the previous day can be used for the following day Per Diem costs."]