{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["ExpenseReportTemplate","General Directions & Coding"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":1,"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":"ExpenseReportTemplate","index":0,"n_rows":51,"n_cols":12,"rows_kept":51,"cut":false,"hidden":false,"merged":[[9,3,10,8],[11,1,26,2]]}
["Name","J"]
["Address, City, State, Zip"]
[]
["Conference name"]
["City, State"]
["Period on business (mmddyy-mmddyy)"]
[]
[null,null,null,"Day of Week"]
["Description","Mileage","Mileage Rate","Pre Payments","mm/dd/yy","mm/dd/yy","mm/dd/yy","mm/dd/yy","mm/dd/yy","Total"]
["Mileage from x to y",null,0.67,null,null,null,null,null,null,{"$f":"ROUND(B10*C10,2)","v":0}]
["Mileage from y to z",null,0.67,null,null,null,null,null,null,{"$f":"ROUND(B11*C11,2)","v":0}]
["Tolls",null,null,null,null,null,null,null,null,{"$f":"SUM(D12:I12)","v":0}]
["Airfare  enter travel points",null,null,null,null,null,null,null,null,0]
["Baggage",null,null,null,null,null,null,null,null,0]
["Parking Airport",null,null,null,null,null,null,null,null,0]
["Taxi / Shuttle  ",null,null,null,null,null,null,null,null,0]
["Rental Car",null,null,null,null,null,null,null,null,0]
["Rental Car gasoline",null,null,null,null,null,null,null,null,0]
["Hotel  ",null,null,null,null,null,null,null,null,0]
["Parking Hotel",null,null,null,null,null,null,null,null,0]
["Telephone",null,null,null,null,null,null,null,null,0]
["Conference registration",null,null,null,null,null,null,null,null,0]
["Event Parking",null,null,null,null,null,null,null,null,0]
["Meal 1",null,null,null,null,null,null,null,null,0]
["Meal 2",null,null,null,null,null,null,null,null,0]
["Meal 3",null,null,null,null,null,null,null,null,0]
["Meal 4",null,null,null,null,null,null,null,null,0]
["Total",{"$f":"SUM(B10:B27)","v":0},null,null,null,null,"Total Trip Expense",null,null,{"$f":"SUM(J10:J27)","v":0}]
[]
[null,null,null,null,null,null,"JCC PREPAYMENTS:","FOAP","Coded to","$ Amount"]
[null,null,null,null,null,null,"  LESS: AmEx - Airfare"]
[null,null,null,null,null,null,"  LESS: AmEx - Hotel"]
[null,null,null,null,null,null,"  LESS: Conference"]
[null,null,null,null,null,null,"Total Prepayments",null,null,{"$f":"SUM(J31:J33)","v":0}]
[null,null,null,null,null,null,"Total Trip Expenses less Prepayments",null,null,{"$f":"J28-J34","v":0}]
[null,null,null,null,null,null,"Amount due to Employee is limited to",null,null,null,null,"<-- This could be the $ in row above or a lessor amount."]
[]
[null,null,null,null,null,null,"GL Distribution","FOAP","$ Awarded","$ Amount to pay"]
[null,null,null,null,null,null,"Dept Funds","1000-xxxx-7402"]
[null,null,null,null,null,null,"Development Funds","see next tab"]
[null,null,null,null,null,null,"Other","see next tab"]
[null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(J39:J41)","v":0}]
[]
[]
["Employee's Certification: I certify that all expenses listed above are accurate and true and incurred for the benefit of the College."]
["Supervisor Certification: I authorize payment to the above employee and certify that College funds are available to reimburse the employee."]
[null,"Name",null,"Title",null,"Date"]
["Submitted By:"]
["Approved By:"]
["Approved By:"]
[" Reviewd By:"]

{"sheet":"General Directions & Coding","index":1,"n_rows":29,"n_cols":4,"rows_kept":29,"cut":false,"hidden":false,"merged":[[18,0,18,3],[0,0,0,3]]}
["General Directions"]
["Show all the expenses related to this trip - regardless of where the funds came from or if they were prepaid by the college or you."]
["Do not mess with the calculated totals."]
["If you took a personal day within the trip - jot in PERSONAL DAY in that day's column. I won't have to guess about lack of expenses that day."]
["If the mileage rate has been updated by IRS.gov, enter the correct rate."]
["If you are overwhelmed completing this, send me all your receipts. I would rather do it from scratch than figure out your accounting."]
["Save the file with the following naming convention:"]
[null,"Lastname, Firstname_MMDDYY-mmddyy_123.45.xlsx"]
[null,null,"where MMDDYY is the first day of travel"]
[null,null,"where mmddyy is the last day of travel"]
[null,null,"where 123.45 is the amount you think you are owed"]
[null,null,"where the file is an Excel Workbook (it is currently a Template .xltx)"]
["Scan all your receipts, hotel bill, etc. into one .pdf file - with receipts for each day all together. Do not overlap receipts."]
["Email the .xlsx file & .pdf file to your Supervisor and/or Grant Coordinator."]
["Your Supervisor / Grant Coordinator will email to accountspayable@mail.sunyjcc.edu once approved."]
["Accounts Payable will review and modify as needed before payment."]
[]
[]
["Common Fund-Org-Account-Program (FOAP) for Travel Expenses"]
["GL Distribution",null,"FOAP","Notes"]
["Dept Funds",null,"1000-xxxx-7402","Where xxxx is your Fund / Dept code."]
["Grant Funds",null,"2xxx-xxxx-7402","Grant Fund codes all begin with 2___. Add appropriate Org code."]
["Fac Dev Funds FT",null,"1000-1302-7524","Academic Affairs, Faculty Dev Funds, Full Time"]
["Fac Dev Funds PT",null,"1000-1302-7414","Academic Affairs, Faculty Dev Funds, Part Time / Adjunct"]
["Staff Dev Funds",null,"1000-1714-7526","Human Resources, Staff Dev Funds"]
["PASA Dev Funds",null,"1000-1714-7530","Human Resources, PASA Dev Funds"]
["JCC FSA Funds",null,"1000- -1362","Due to / Due from JCC FSA"]
["JCC Foundation Funds",null,"1000- -1394","Due to / Due from JCC Foundation"]
["KJC Funds (JCC Foundation)",null,"1000- -1394","Due to / Due from JCC Foundation"]