{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Instructions","NYSWYSA Expense Report"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":1,"comments":1,"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":"Instructions","index":0,"n_rows":69,"n_cols":3,"rows_kept":69,"cut":false,"hidden":false,"merged":[]}
["Instructions for the NYSW Expense Report"]
["ver 2009 2-1"]
[]
[]
[null,"1) Complete the name and address section."]
[null,"2) Select the appropriate Department from the drop down menu.  To activate the drop down place your cursor over the "]
[null,"cell and click on the cell.  A drop down arrow will appear on the right hand side of the cell, click on it to produce the "]
[null,"drop down menu.  Then select the department."]
[null,"3) Select the appropriate week ending date from the drop down menu."]
[]
[null,null,"Itemized Air/Transportation"]
[null,null,"1) Enter date of travel or when ticket was paid."]
[null,null,"2) Enter purpose of the travel."]
[null,null,"3) Enter the to-from information about the expense."]
[null,null,"4) Enter a yes or no if you used a corporate credit card for the expense."]
[null,null,"5) Enter the amount."]
[]
[null,null,"Itemized Lodging"]
[null,null,"1) Enter date of stay."]
[null,null,"2) Enter Hotel name and purpose of the stay."]
[null,null,"3) Enter the city information about the lodging."]
[null,null,"4) Enter a yes or no if you used a corporate credit card for the expense."]
[null,null,"5) Enter the amount."]
[]
[null,null,"Meals"]
[null,null,"1) Enter date of meal"]
[null,null,"2) Enter name of the place, purpose of the meal and who were in attendance."]
[null,null,"3) Enter the type of meal from the drop down menu."]
[null,null,"4) Enter a yes or no if you used a corporate credit card for the expense."]
[null,null,"5) Enter the amount."]
[]
[null,null,"Entertainment"]
[null,null,"1) Enter date of the entertainment"]
[null,null,"2) Enter name of the place and who were in attendance."]
[null,null,"3) Enter the purpose of the entertainment"]
[null,null,"4) Enter a yes or no if you used a corporate credit card for the expense."]
[null,null,"5) Enter the amount."]
[]
[null,null,"Business use of Personal Automobile"]
[null,null,"1) Enter date from (the date you left your original location)"]
[null,null,"2) Enter Date you returned to your original location."]
[null,null,"3) Enter the purpose of the trip."]
[null,null,"4) Enter your start mileage"]
[null,null,"5) Enter your ending mileage"]
[null,null,"6) Total mileage will be caculated by the spreadsheet and total reimbursement will use the current IRS deductions."]
[]
[null,null,"Other Travel Expense"]
[null,null,"1) Enter date of travel expense"]
[null,null,"2) Enter purpose of the expense"]
[null,null,"3) Enter the type of expense from the drop down menu."]
[null,null,"4) Enter a yes or no if you used a corporate credit card for the expense."]
[null,null,"5) Enter the amount."]
[]
[null,null,"Other Reimburseable Expense"]
[null,null,"1) Enter date of the expense"]
[null,null,"2) Enter the description of the expense"]
[null,null,"3) Enter the the GL number if you know it."]
[null,null,"4) Enter a yes or no if you used a corporate credit card for the expense."]
[null,null,"5) Enter the amount."]
[]
[]
[null,"4) Attach receipts in accordance with the NYSW policy.  If you can scan the reciepts"]
[null,"and attach the form and receipts to an email and send to the appropriate department "]
[null,"head for approval."]
[]
[null,"5) Once approved forward to the accounting department in the state office with the "]
[null,"attached receipts."]
[]
[null,"6)  Your form will be processed only if all the supporting documentation as required by NYSW policy at the time is attached."]

{"sheet":"NYSWYSA Expense Report","index":1,"n_rows":76,"n_cols":36,"rows_kept":76,"cut":false,"hidden":false,"merged":[[71,2,71,3],[71,5,71,6],[71,11,71,12],[71,14,71,15],[66,10,66,14],[67,10,67,14],[70,2,70,13],[69,10,69,14],[68,10,68,14],[68,2,68,3],[67,2,67,3],[64,2,64,3],[35,11,35,12],[41,1,41,15],[36,11,36,12],[38,2,38,3],[37,2,37,3],[63,2,63,3],[63,10,63,14],[37,11,37,12],[52,2,52,3],[47,3,47,11],[66,2,66,3],[65,2,65,3],[61,11,61,14],[42,3,42,11],[49,1,49,13],[48,3,48,11],[51,10,51,15],[45,3,45,11],[44,3,44,11],[43,3,43,11],[64,10,64,14],[62,2,62,3],[58,10,59,14],[65,11,65,14],[55,2,55,3],[54,2,54,3],[57,2,57,3],[60,10,60,14],[62,11,62,14],[58,15,59,15],[54,11,54,14],[55,11,55,14],[56,11,56,14],[57,11,57,14],[35,2,35,3],[34,2,34,3],[31,2,31,3],[38,11,38,12],[39,10,39,13],[16,1,16,6],[16,10,16,15],[13,1,13,2],[27,2,27,3],[28,11,28,12],[27,11,27,12],[8,2,8,10],[9,2,9,10],[10,2,10,3],[11,2,11,3],[13,3,14,13],[17,2,17,3],[17,11,17,12],[20,11,20,12],[18,2,18,3],[19,11,19,12],[21,11,21,12],[69,1,69,4],[61,2,61,3],[3,1,3,15],[60,1,60,6],[51,1,51,6],[58,1,58,4],[19,2,19,3],[39,1,39,4],[21,2,21,3],[4,1,4,15],[18,11,18,12],[20,2,20,3],[25,10,25,15],[23,1,23,4],[23,10,23,13],[52,11,52,14],[56,2,56,3],[22,11,22,12],[26,11,26,12],[26,2,26,3],[22,2,22,3],[28,2,28,3],[25,1,25,6],[33,2,33,3],[32,2,32,3],[30,2,30,3],[53,2,53,3],[53,10,53,14],[46,3,46,11],[29,2,29,3],[36,2,36,3]]}
[]
[]
[]
[null,"New York State West"]
[null,"2024 Expense form - UPDATED JANUARY 1, 2024"]
[null,null,null,null,null,null,null,null,null,2017,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Field Information for drop downs or calculations"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mileage Riem","Meal Type","Departments",null,"Other Travel","Week Ending","CC"]
[null,"Name",null,null,null,null,null,null,null,null,null,null,"Department",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2.3% increase",{"$f":"0.625+0.03+0.015","v":0.67},"Breakfast","Coaching Education",null,"Gas",null,"Y"]
[null,"Address",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lunch","DOC",null,"Tolls",null,"N"]
[null,"City",null,null,"State",null,null,null,null,"Zip","Zipcode",null,"Date",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dinner","ODP",null,"Parking"]
[null,"Phone",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Officers/Directors",null,"Other "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Player Development"]
[null,"PURPOSE OF TRIP:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"State Cup"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"State Office"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOPS Soccer"]
[null,"Itemized Air/Transport Expenses",null,null,null,null,null,null,null,null,"Itemized Lodging Expenses"]
[null,"Date","Business Purpose",null,"From - To","CC","Amount","Credit","Cash",null,"Date","Hotel & Business Purpose",null,"City","CC","Amount","Credit","Cash"]
[null,null,null,null,null,null,null,{"$f":"IF(F19=\"Y\",G19,0)","v":0},{"$f":"IF(F19=\"N\",G19,0)","v":0},null,null,null,null,null,null,null,{"$f":"IF(O19=\"Y\",P19,0)","v":0},{"$f":"IF(O19=\"N\",P19,0)","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(F20=\"Y\",G20,0)","v":0},{"$f":"IF(F20=\"N\",G20,0)","v":0},null,null,null,null,null,null,null,{"$f":"IF(O20=\"Y\",P20,0)","v":0},{"$f":"IF(O20=\"N\",P20,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,"IRS Standard Mileage Rate changed from .585 to .625 as of July 1, 2022 as per IRS"]
[null,null,null,null,null,null,null,{"$f":"IF(F21=\"Y\",G21,0)","v":0},{"$f":"IF(F21=\"N\",G21,0)","v":0},null,null,null,null,null,null,null,{"$f":"IF(O21=\"Y\",P21,0)","v":0},{"$f":"IF(O21=\"N\",P21,0)","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(F22=\"Y\",G22,0)","v":0},{"$f":"IF(F22=\"N\",G22,0)","v":0},null,null,null,null,null,null,null,{"$f":"IF(O22=\"Y\",P22,0)","v":0},{"$f":"IF(O22=\"N\",P22,0)","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(F23=\"Y\",G23,0)","v":0},{"$f":"IF(F23=\"N\",G23,0)","v":0},null,null,null,null,null,null,null,{"$f":"IF(O23=\"Y\",P23,0)","v":0},{"$f":"IF(O23=\"N\",P23,0)","v":0}]
[null,{"$f":"\"Total\" & \" \" &B17","v":"Total Itemized Air/Transport Expenses"},null,null,null,null,{"$f":"SUM(G19:G23)","v":0},{"$f":"SUM(H19:H23)","v":0},{"$f":"SUM(I19:I23)","v":0},null,{"$f":"\"Total\" & \" \" &K17","v":"Total Itemized Lodging Expenses"},null,null,null,null,{"$f":"SUM(P19:P23)","v":0},{"$f":"SUM(Q19:Q23)","v":0},{"$f":"SUM(R19:R23)","v":0}]
[]
[null,"Itemized Meal Expenses",null,null,null,null,null,null,null,null,"Itemized Entertainment Expenses"]
[null,"Date","Where and Business Purpose & Who",null,"Type","CC","Amount",null,null,null,"Date","Who",null,"Purpose","CC","Amount"]
[null,null,null,null,null,null,null,{"$f":"IF(F28=\"Y\",G28,0)","v":0},{"$f":"IF(F28=\"N\",G28,0)","v":0},null,null,null,null,null,null,null,{"$f":"IF(O28=\"Y\",P28,0)","v":0},{"$f":"IF(O28=\"N\",P28,0)","v":0}]
[null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,0,0]
[null,{"$f":"\"Total\" & \" \" &B26","v":"Total Itemized Meal Expenses"},null,null,null,null,{"$f":"SUM(G28:G39)","v":0},{"$f":"SUM(H28:H39)","v":0},{"$f":"SUM(I28:I39)","v":0},null,{"$f":"\"Total\" & \" \" &K26","v":"Total Itemized Entertainment Expenses"},null,null,null,null,{"$f":"SUM(P28:P39)","v":0},{"$f":"SUM(Q28:Q39)","v":0},{"$f":"SUM(R28:R39)","v":0}]
[]
[null,"Business Use of Personal Automobile"]
[null,"Date From","Date To","Business Purpose & Start to Destination",null,null,null,null,null,null,null,null,"Start Mileage","End Mileage","NA","Total Miles"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(N44),\"\",(N44-M44))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"Total Reimbursement for Business Use of Personal Automobile",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P44:P49)*AD9","v":0}]
[]
[null,"Itemized Other Travel Expenses (Parking/Tolls/Gas/Etc.)",null,null,null,null,null,null,null,null,"EXPENSE SUMMARY"]
[null,"Date","Business Purpose",null,"Type","CC","Amount",null,null,null,"GL Acct",null,null,null,null,"Amount"]
[null,null,null,null,null,null,null,{"$f":"IF(F54=\"Y\",G54,0)","v":0},{"$f":"IF(F54=\"N\",G54,0)","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(F55=\"Y\",G55,0)","v":0},{"$f":"IF(F55=\"N\",G55,0)","v":0},null,null,{"$f":"B24","v":"Total Itemized Air/Transport Expenses"},null,null,null,{"$f":"G24","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(F56=\"Y\",G56,0)","v":0},{"$f":"IF(F56=\"N\",G56,0)","v":0},null,null,{"$f":"K24","v":"Total Itemized Lodging Expenses"},null,null,null,{"$f":"P24","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(F57=\"Y\",G57,0)","v":0},{"$f":"IF(F57=\"N\",G57,0)","v":0},null,null,{"$f":"B50","v":"Total Reimbursement for Business Use of Personal Automobile"},null,null,null,{"$f":"P50","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(F58=\"Y\",G58,0)","v":0},{"$f":"IF(F58=\"N\",G58,0)","v":0},null,null,{"$f":"B59","v":"Total Itemized Other Travel Expenses (Parking/Tolls/Gas/Etc.)"},null,null,null,{"$f":"G59","v":0}]
[null,{"$f":"\"Total\" & \" \" &B52","v":"Total Itemized Other Travel Expenses (Parking/Tolls/Gas/Etc.)"},null,null,null,null,{"$f":"SUM(G54:G58)","v":0},{"$f":"SUM(H54:H58)","v":0},{"$f":"SUM(I54:I58)","v":0},null,"SUBTOTAL TRAVEL",null,null,null,null,{"$f":"SUM(P55:P58)","v":0}]
[]
[null,"Itemized Other Reimburseable Items"]
[null,"Date","Description",null,"GL Acct","CC","Amount",null,null,null,null,{"$f":"B40","v":"Total Itemized Meal Expenses"},null,null,null,{"$f":"G40","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(F63=\"Y\",G63,0)","v":0},{"$f":"IF(F63=\"N\",G63,0)","v":0},null,null,{"$f":"K40","v":"Total Itemized Entertainment Expenses"},null,null,null,{"$f":"P40","v":0}]
[null,null,null,null,null,null,null,0,0,null,"SUBTOTAL MEALS/ENTERTAINMENT",null,null,null,null,{"$f":"SUM(P62:P63)","v":0}]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0,null,null,"OTHER ITEMS",null,null,null,{"$f":"G70","v":0}]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0,null,"TOTAL EXPENSE SUMMARY",null,null,null,null,{"$f":"P59+P64+P66","v":0}]
[null,null,null,null,null,null,null,0,0,null,"Total Expenses charged to NYSWYSA CC",null,null,null,null,{"$f":"(H70+H59+H40+H24+Q40+Q24)","v":0}]
[null,{"$f":"\"Total\" & \" \" &B61","v":"Total Itemized Other Reimburseable Items"},null,null,null,null,{"$f":"SUM(G63:G69)","v":0},{"$f":"SUM(H63:H69)","v":0},{"$f":"SUM(I63:I69)","v":0},null,"TOTAL AMOUNT DUE",null,null,null,null,{"$f":"SUM(P68-P69)","v":0}]
[null,null,"By processing this expense report I am declaring (under the penalities of perjury)  this account of expenses is accurate and conforms with all travel and expense policies of New York State West Youth Soccer Association and any NYS regulations. The expenses were actual, reasonable and incurred in the performance of my official duties. No portion of this cliam was provided free of charge, convered by a registration fee, previously reimbursed from another source, or will be paid by any other source in the future.",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((P70+P69)=P68,\"\",\"Out of Balance, Please check your Credit Card and Cash Transactions for each expense item\")","v":""}]
[null,"Submitter",null,null,"Date",null,null,null,null,null,"Approved",null,null,"Date"]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"IF(F76=\"Y\",0,G76)","v":0}]