{"text_format":"3","workbook":"xls","n_sheets":2,"sheets":["员工报销明细","员工差旅明细"],"not_rendered":{"images":2,"external_links":1,"defined_names":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"员工报销明细","index":0,"n_rows":60,"n_cols":10,"rows_kept":60,"merged":[[1,2,1,7],[3,7,4,8],[3,9,4,9],[5,0,6,0],[5,1,6,1],[5,2,5,4],[5,5,5,8],[5,9,6,9],[7,0,11,0],[7,1,11,1],[7,2,11,2],[7,3,11,3],[7,4,11,4],[7,9,12,9],[13,0,14,0],[13,1,14,1],[13,2,14,2],[13,3,14,3],[13,4,14,4],[13,9,15,9],[16,0,19,0],[16,1,19,1],[16,2,19,2],[16,3,19,3],[16,4,19,4],[16,9,20,9],[21,0,22,0],[21,1,22,1],[21,2,22,2],[21,3,22,3],[21,4,22,4],[21,9,23,9],[24,0,25,0],[24,1,25,1],[24,2,25,2],[24,3,25,3],[24,4,25,4],[24,9,26,9],[27,0,30,0],[27,1,30,1],[27,2,30,2],[27,3,30,3],[27,4,30,4],[27,9,31,9],[32,0,35,0],[32,1,35,1],[32,2,35,2],[32,3,35,3],[32,4,35,4],[32,9,36,9],[37,0,38,0],[37,1,38,1],[37,2,38,2],[37,3,38,3],[37,4,38,4],[37,9,39,9],[40,0,42,0],[40,1,42,1],[40,2,42,2],[40,3,42,3],[40,4,42,4],[40,9,43,9],[44,0,50,0],[44,1,50,1],[44,2,50,2],[44,3,50,3],[44,4,50,4],[44,9,51,9],[56,0,56,1],[56,2,56,3],[56,4,56,5],[56,6,56,7],[57,0,57,1],[57,2,57,3],[57,4,57,5],[57,6,57,7]],"flags":["formulas_cached_only"]}
[]
[null,null,"【借款报销单】"]
[]
[{"$nulls":7},"团号：HMMA-180831-MOM999",null,"会议日期：2018-08-31 至 2018-09-12"]
[]
["序号","项目","借款",null,null,"还款",{"$nulls":3},"还发票要求"]
[null,null,"金额","数量","借款金额","发票金额","其他金额","还款金额","项目明细"]
[1,"活动交通",{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,"可用项目：租车费、大交通、过路费、过桥费。\n加油费（仅试驾活动可用，且只可使用活动当时当地的加油票）"]
[{"$nulls":5},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"活动交通合计",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[2,"媒体费用",{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,"仅可使用公司规定项目的发票，其余均不可用。需提供签到表及收条。"]
[{"$nulls":5},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"媒体费用合计",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[3,"客户使用费用",{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,"需有客户邮件确认，并抄送合规部。"]
[{"$nulls":5},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"客户使用费用合计",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[4,"活动餐费",{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,"需提供刷卡联、菜单（小票）"]
[{"$nulls":5},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"活动餐费合计",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[5,"现地采买费用",{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,"尽量提供可用的原始发票，发票项目不可用的，且开票需要加收税点的可以不提供原始发票。网上交易均需提供交易截图。"]
[{"$nulls":5},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"现地采买费用合计",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[6,"第三方人工工资",{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,"司机,导游不得直接付款,要使用地接间接付款\n身份证复印件,收条,签字即可,每人超过800元/人,需要补票或交个人所得税。\n"]
[{"$nulls":5},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"第三方人工工资合计",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[7,"制作费",{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":4152,"d":"4,152.00"},{"v":0,"d":"0.00"},{"v":4152,"d":"4,152.00"},"4个卡通人偶"]
[{"$nulls":5},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"制作费合计",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":4152,"d":"4,152.00"},{"v":0,"d":"0.00"},{"v":4152,"d":"4,152.00"}]
[8,"安全相关",{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,"药品500元/团以下可用"]
[{"$nulls":5},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"安全相关费用合计",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[9,"境外",{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,"离境税、落地签签证、小费，写清名单,提供收据并补票或交税"]
[{"$nulls":5},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"境外费用合计",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[10,"其他",{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":35,"d":"35.00"},{"v":0,"d":"0.00"},{"v":35,"d":"35.00"},"玩偶运费"]
[{"$nulls":5},{"v":1566,"d":"1,566.00"},{"v":0,"d":"0.00"},{"v":1566,"d":"1,566.00"},"玩偶运费"]
[{"$nulls":5},{"v":1050,"d":"1,050.00"},{"v":0,"d":"0.00"},{"v":1050,"d":"1,050.00"},"玩偶运费"]
[{"$nulls":5},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"其他费用合计",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":2651,"d":"2,651.00"},{"v":0,"d":"0.00"},{"v":2651,"d":"2,651.00"}]
[null,"合计",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":6803,"d":"6,803.00"},{"v":0,"d":"0.00"},{"v":6803,"d":"6,803.00"}]
[]
[]
[]
["借款金额合计",null,"报帐金额",null,"发票报帐金额",null,"其他发票报帐金额",null,"差额"]
[{"v":0,"d":"0.00"},null,{"v":6803,"d":"6,803.00"},null,{"v":6803,"d":"6,803.00"},null,{"v":0,"d":"0.00"},null,{"v":-6803,"d":"-6803.00"}]
[]
["借款人：",null,"总监：",null,"合规：",null,"财务："]

{"sheet":"员工差旅明细","index":1,"n_rows":38,"n_cols":11,"rows_kept":38,"merged":[[2,1,2,10],[4,5,4,6],[4,9,4,10],[5,5,5,6],[5,9,5,10],[6,5,6,6],[6,9,6,10],[7,9,7,10],[9,1,9,2],[9,4,9,5],[9,8,9,9],[10,1,10,2],[10,3,13,3],[10,4,10,5],[10,8,10,9],[11,1,11,2],[11,4,11,5],[11,8,11,9],[12,1,12,2],[12,4,12,5],[12,8,12,9],[13,1,13,2],[13,4,13,5],[13,8,13,9],[14,1,14,2],[14,3,16,3],[14,4,14,5],[14,8,14,9],[15,1,15,2],[15,4,15,5],[15,8,15,9],[16,1,16,2],[16,4,16,5],[16,8,16,9],[17,1,17,5],[17,8,17,9],[19,1,19,5],[19,6,19,9],[20,1,20,5],[20,6,20,9],[25,0,25,10],[27,5,27,6],[27,9,27,10],[28,5,28,6],[28,9,28,10],[29,5,29,6],[29,9,29,10],[30,9,30,10],[32,1,32,2],[32,4,32,5],[32,8,32,9],[33,1,33,2],[33,4,33,5],[33,8,33,9],[34,1,34,2],[34,4,34,5],[34,8,34,9],[35,1,35,2],[35,4,35,5],[35,8,35,9],[36,1,36,5],[36,8,36,9]],"flags":["formulas_cached_only"]}
[]
[]
[null,"【员工差旅报销单】"]
[]
[{"$nulls":3},"姓名:",null,"刘菲",null,"职位:",null,"经理"]
[{"$nulls":3},"发生地:",null,"北京",null,"部门:",null,"人事行政部"]
[{"$nulls":3},"发生日期:",null,"2018-09-04",null,"报销日期:",null,"2018-09-14"]
[{"$nulls":7},"团号:"]
[]
[null,"序号",null,"报销项目","用途",null,"实际报销金额","合格发票金额","不合格发票金额",null,"备注"]
[null,1,null,"差旅费","大交通（机票/火车票）",null,{"v":0,"d":"0.00"},{"$nulls":3},"当时当地"]
[null,2,null,null,"市内交通（打车）",null,{"v":0,"d":"0.00"},{"$nulls":3},"当时当地，公交充值票据无效"]
[null,3,null,null,"住宿费",null,{"v":0,"d":"0.00"},{"$nulls":3},"当时当地"]
[null,4,null,null,"餐费",null,{"v":0,"d":"0.00"},{"$nulls":3},"当时当地(注明会议日期）"]
[null,5,null,"其他",null,null,{"v":0,"d":"0.00"}]
[null,6,{"$nulls":4},{"v":0,"d":"0.00"}]
[null,7,{"$nulls":4},{"v":0,"d":"0.00"}]
[null,"合计",{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[]
[null,"合格发票金额",{"$nulls":4},"补票金额",{"$nulls":3},"报销总金额"]
[null,{"v":0,"d":"0.00"},{"$nulls":4},{"v":0,"d":"0.00"},{"$nulls":3},{"v":0,"d":"0.00"}]
[]
[null,"报销人:",{"$nulls":3},"总监：","合规:",null,null,"财务："]
[]
[]
["【员工上会补助统计单】"]
[]
[{"$nulls":3},"姓名:",null,"刘菲",null,"职位:",null,"经理"]
[{"$nulls":3},"发生地:",null,"北京",null,"部门:",null,"人事行政部"]
[{"$nulls":3},"发生日期:",null,"2018年9月8日至10日",null,"报销日期:",null,"2018-09-25"]
[{"$nulls":7},"团号:",null,"HMMA-180831-MOM999"]
[]
[{"$nulls":3},"出差城市","出差起止日期",null,"每天金额","天数","合计",null,"备注"]
[null,1,null,"北京","2018年9月8日至10日",null,{"v":300,"d":"300.00"},{"v":3,"d":"3.00"},{"v":900,"d":"900.00"}]
[null,2,{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,3,{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"合计",{"$nulls":5},{"v":3,"d":"3.00"},{"v":900,"d":"900.00"}]
[null,"报销人:",{"$nulls":3},"总监：","合规:",null,null,"财务："]