{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Data","Setup","Manager","Accounting"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":21,"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":"Data","index":0,"n_rows":59,"n_cols":16,"rows_kept":59,"cut":false,"hidden":false,"merged":[[3,13,3,14],[0,1,2,15],[58,13,58,15],[58,9,58,10],[58,7,58,8],[58,0,58,6],[58,11,58,12],[57,0,57,1]]}
[null,"EXPENSE REPORT\n"]
[]
[]
[null,"EMPLOYEE NAME",null,null,null,"APPROVER",null,null,null,"REPORT DATE",null,null,"TOTAL CLAIM"]
[]
["#","DATE","LOCATION","DESCRIPTION","ATTENDEES","RECEIPT","MEALS","TRAVEL MEALS","HOTEL","AIR TRAVEL","FUEL","OTHER\nAMOUNT","OTHER CATEGORY","TIP","TAX","TOTAL EXPENSE"]
[{"$f":"IF(B7=\"\",\"\",1)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A7=\"\",\"\",SUM(G7:L7)+SUM(N7:O7))","v":""}]
[{"$f":"IF(B8=\"\",\"\",A7+1)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A8=\"\",\"\",SUM(G8:L8)+SUM(N8:O8))","v":""}]
[{"$f":"IF(B9=\"\",\"\",A8+1)","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,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,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,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,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,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,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,""]
["",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,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,null,null,""]
["TOTALS",null,null,null,null,null,{"$f":"SUM(G7:G57)","v":0},{"$f":"SUM(H7:H57)","v":0},0,{"$f":"SUM(J7:J57)","v":0},0,0,0,{"$f":"SUM(N7:N57)","v":0},{"$f":"SUM(O7:O57)","v":0},{"$f":"IF(A58=\"\",\"\",SUM(G58:L58)+N58+O58)","v":0}]
["Comments:",null,null,null,null,null,null,"EMPLOYEE REVIEW",null,{"$f":"IF(employeesignature=\"\",\"\",employeesignature)","v":""},null,"MANAGER REVIEW",null,{"$f":"IF(managersignature=\"\",\"\",managersignature)","v":""}]

{"sheet":"Setup","index":1,"n_rows":22,"n_cols":13,"rows_kept":22,"cut":false,"hidden":true,"merged":[[1,12,1,13]]}
["Expense Categories","Limit","GL Code","PerAtt",null,"Locations","GL Code",null,null,"GL Accounts","GL Code",null,"Report Status"]
["AIR TRAVEL",2000,5000,null,null,"Location A",-100,null,null,"Credit Account","2000-100",null,"Ready for Manager Review"]
["CAR RENTAL",500,5050,null,null,"Location B",-200,null,null,"Tax Account",2200]
["ENTERTAINMENT",500,5100,null,null,"Location C",-300]
["FUEL",200,5150,null,null,"Location D",-400,null,null,null,null,null,"Employee Signature"]
["HOTEL",1000,5200,null,null,"Location E",-500,null,null,null,null,null,"Manager Signature"]
["MEALS",50,5250,"X"]
["MEMBERSHIPS",1000,5300,null,null,"Accounting Password",5678]
["OFFICE SUPPLIES",100,5350]
["PROFESSIONAL FEES",1000,5400,null,null,"Employee"]
["RECRUITMENT FEES",500,5450,null,null,"Employee A"]
["REPAIRS & MAINTENANCE",1000,5500,null,null,"Employee B"]
["SOFTWARE",500,5550,null,null,"Employee C"]
["TELEPHONE",200,5600,null,null,"Employee D"]
["TRAINING",1000,5650,null,null,"Employee E"]
["TRAVEL MEALS",50,5700,"X"]
[null,null,null,null,null,"Approver","Password"]
["TIPPING",0.2,5800,null,null,"Approver A","AAA"]
[null,null,null,null,null,"Approver B","BBB"]
[null,null,null,null,null,"Approver C","CCC"]
[null,null,null,null,null,"Approver D","DDD"]
[null,null,null,null,null,"Approver E","EEE"]

{"sheet":"Manager","index":2,"n_rows":5,"n_cols":13,"rows_kept":5,"cut":false,"hidden":true,"merged":[[1,0,1,12]]}
[]
["Reviewable Items"]
["#","DATE","BRANCH","DESCRIPTION","ATTENDEES","RECEIPT","COST CATEGORY","EXPENSE","TIP","TAX","TOTAL EXPENSE","REVIEWABLE REASON","MANAGER COMMENTS"]
[1,"2017-01-01","Location A","Eating Out",2,"Not Attached","MEALS",200,75,10,285,"Excessive tipping"]
[1,"2017-01-01","Location A","Eating Out",2,"Not Attached","MEALS",200,75,10,285,"No receipt"]

{"sheet":"Accounting","index":3,"n_rows":7,"n_cols":22,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
[null,null,"GL #","Account","Debit","Credit","Memo",null,null,null,null,{"$f":"INDEX(Setup!$A:$A,MATCH(Accounting!L$2,Setup!$C:$C,0),1)","v":"MEALS"},{"$f":"INDEX(Setup!$A:$A,MATCH(Accounting!M$2,Setup!$C:$C,0),1)","v":"TRAVEL MEALS"},{"$f":"INDEX(Setup!$A:$A,MATCH(Accounting!N$2,Setup!$C:$C,0),1)","v":"HOTEL"},{"$f":"INDEX(Setup!$A:$A,MATCH(Accounting!O$2,Setup!$C:$C,0),1)","v":"AIR TRAVEL"},{"$f":"INDEX(Setup!$A:$A,MATCH(Accounting!P$2,Setup!$C:$C,0),1)","v":"FUEL"},"TIP","TAX",null,null,"TRAVEL MEALS","FUEL"]
[null,null,"2000-100","EXPENSES PAYABLE",null,0,"Employee A - Employee A",null,null,null,null,{"$f":"VLOOKUP(Data!G$6,Setup!$A:$C,3,FALSE)","v":5250},{"$f":"VLOOKUP(Data!H$6,Setup!$A:$C,3,FALSE)","v":5700},{"$f":"VLOOKUP(Data!I$6,Setup!$A:$C,3,FALSE)","v":5200},{"$f":"VLOOKUP(Data!J$6,Setup!$A:$C,3,FALSE)","v":5000},{"$f":"VLOOKUP(Data!K$6,Setup!$A:$C,3,FALSE)","v":5150},null,null,null,"OTHER"]
[null,null,null,null,null,null,null,null,null,{"$f":"Setup!F2","v":"Location A"},{"$f":"VLOOKUP(J3,Setup!F:G,2,FALSE)","v":-100},{"$f":"IF(L$2=\"\",0,SUMIF(Data!$C$7:$C$57,Accounting!$J3,Data!G$7:G$57))","v":0},{"$f":"IF(M$2=\"\",0,SUMIF(Data!$C$7:$C$57,Accounting!$J3,Data!H$7:H$57))","v":0},{"$f":"IF(N$2=\"\",0,SUMIF(Data!$C$7:$C$57,Accounting!$J3,Data!I$7:I$57))","v":0},{"$f":"IF(O$2=\"\",0,SUMIF(Data!$C$7:$C$57,Accounting!$J3,Data!J$8:J$57))","v":0},{"$f":"IF(P$2=\"\",0,SUMIF(Data!$C$7:$C$57,Accounting!$J3,Data!K$7:K$57))","v":0},{"$f":"IF(Q$1=\"\",0,SUMIF(Data!$C$7:$C$57,Accounting!$J3,Data!N$7:N$57))","v":0},{"$f":"IF(R$1=\"\",0,SUMIF(Data!$C$7:$C$57,Accounting!$J3,Data!O$7:O$57))","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"Setup!F3","v":"Location B"},{"$f":"VLOOKUP(J4,Setup!F:G,2,FALSE)","v":-200},{"$f":"IF(L$2=\"\",0,SUMIF(Data!$C$7:$C$57,Accounting!$J4,Data!G$7:G$57))","v":0},{"$f":"IF(M$2=\"\",0,SUMIF(Data!$C$7:$C$57,Accounting!$J4,Data!H$7:H$57))","v":0},{"$f":"IF(N$2=\"\",0,SUMIF(Data!$C$7:$C$57,Accounting!$J4,Data!I$7:I$57))","v":0},{"$f":"IF(O$2=\"\",0,SUMIF(Data!$C$7:$C$57,Accounting!$J4,Data!J$8:J$57))","v":0},{"$f":"IF(P$2=\"\",0,SUMIF(Data!$C$7:$C$57,Accounting!$J4,Data!K$7:K$57))","v":0},{"$f":"IF(Q$1=\"\",0,SUMIF(Data!$C$7:$C$57,Accounting!$J4,Data!N$7:N$57))","v":0},{"$f":"IF(R$1=\"\",0,SUMIF(Data!$C$7:$C$57,Accounting!$J4,Data!O$7:O$57))","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"Setup!F4","v":"Location C"},{"$f":"VLOOKUP(J5,Setup!F:G,2,FALSE)","v":-300},{"$f":"IF(L$2=\"\",0,SUMIF(Data!$C$7:$C$57,Accounting!$J5,Data!G$7:G$57))","v":0},{"$f":"IF(M$2=\"\",0,SUMIF(Data!$C$7:$C$57,Accounting!$J5,Data!H$7:H$57))","v":0},{"$f":"IF(N$2=\"\",0,SUMIF(Data!$C$7:$C$57,Accounting!$J5,Data!I$7:I$57))","v":0},{"$f":"IF(O$2=\"\",0,SUMIF(Data!$C$7:$C$57,Accounting!$J5,Data!J$8:J$57))","v":0},{"$f":"IF(P$2=\"\",0,SUMIF(Data!$C$7:$C$57,Accounting!$J5,Data!K$7:K$57))","v":0},{"$f":"IF(Q$1=\"\",0,SUMIF(Data!$C$7:$C$57,Accounting!$J5,Data!N$7:N$57))","v":0},{"$f":"IF(R$1=\"\",0,SUMIF(Data!$C$7:$C$57,Accounting!$J5,Data!O$7:O$57))","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"Setup!F5","v":"Location D"},{"$f":"VLOOKUP(J6,Setup!F:G,2,FALSE)","v":-400},{"$f":"IF(L$2=\"\",0,SUMIF(Data!$C$7:$C$57,Accounting!$J6,Data!G$7:G$57))","v":0},{"$f":"IF(M$2=\"\",0,SUMIF(Data!$C$7:$C$57,Accounting!$J6,Data!H$7:H$57))","v":0},{"$f":"IF(N$2=\"\",0,SUMIF(Data!$C$7:$C$57,Accounting!$J6,Data!I$7:I$57))","v":0},{"$f":"IF(O$2=\"\",0,SUMIF(Data!$C$7:$C$57,Accounting!$J6,Data!J$8:J$57))","v":0},{"$f":"IF(P$2=\"\",0,SUMIF(Data!$C$7:$C$57,Accounting!$J6,Data!K$7:K$57))","v":0},{"$f":"IF(Q$1=\"\",0,SUMIF(Data!$C$7:$C$57,Accounting!$J6,Data!N$7:N$57))","v":0},{"$f":"IF(R$1=\"\",0,SUMIF(Data!$C$7:$C$57,Accounting!$J6,Data!O$7:O$57))","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"Setup!F6","v":"Location E"},{"$f":"VLOOKUP(J7,Setup!F:G,2,FALSE)","v":-500},{"$f":"IF(L$2=\"\",0,SUMIF(Data!$C$7:$C$57,Accounting!$J7,Data!G$7:G$57))","v":0},{"$f":"IF(M$2=\"\",0,SUMIF(Data!$C$7:$C$57,Accounting!$J7,Data!H$7:H$57))","v":0},{"$f":"IF(N$2=\"\",0,SUMIF(Data!$C$7:$C$57,Accounting!$J7,Data!I$7:I$57))","v":0},{"$f":"IF(O$2=\"\",0,SUMIF(Data!$C$7:$C$57,Accounting!$J7,Data!J$8:J$57))","v":0},{"$f":"IF(P$2=\"\",0,SUMIF(Data!$C$7:$C$57,Accounting!$J7,Data!K$7:K$57))","v":0},{"$f":"IF(Q$1=\"\",0,SUMIF(Data!$C$7:$C$57,Accounting!$J7,Data!N$7:N$57))","v":0},{"$f":"IF(R$1=\"\",0,SUMIF(Data!$C$7:$C$57,Accounting!$J7,Data!O$7:O$57))","v":0}]