{"text_format":"2","workbook":"xlsx","n_sheets":7,"sheets":["操作流程","基础计费","计费数据来源","前海电商收款通知书","中网收款通知书","预缴税款收款通知书","应收结算模块"],"not_rendered":{"charts":0,"images":3,"macros":0,"external_links":0,"defined_names":1,"comments":3,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"操作流程","index":0,"n_rows":23,"n_cols":5,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,0,0,4],[4,4,7,4],[11,4,12,4]]}
["应收应付操作流程"]
["步骤","内容","明细","录入部门","备注"]
[1,"客户信息资料维护",null,"客服部"]
[2,"基础数据维护（报价）","应收应付报价维护","财务部"]
[3,"数据录入（业务）","（1）派送费/操作费/综合税费","跟订单数据"]
[null,null,"（2）运输报关费用","关务部"]
[null,null,"（3）产品备案","客服部"]
[null,null,"（4）仓储数据","仓库"]
[null,null,"(5)耗材费","仓库"]
[4,"结账","在规定时间内","系统结账","录入时效性，超过规定时间或错误超过3次，需申请开通权限"]
[5,"生成收款通知待复核数据",null,"系统结账","查看格式（收款通知书)"]
[6,"复核","（1）有误：进行第3步修改","财务部"]
[null,null,"（2）无误：进行下一步"]
[7,"生成收款通知书（电子档）",null,"财务部"]
[8,"通知客服部领取（电子档）"]
[9,"客服部线下邮件客户收款通知书（电子档）","客服部邮件给到客户（收款通知书及明细账）","客服部"]
[10,"反馈商户收款通知书复核结果","（1）有误：进行第3步修改","客服部","（财务部授权重录解锁）--财务复核重录数据--按钮触发重新生成收款通知书--重复步骤8"]
[null,null,"（2）无误：进行下一步"]
[11,"通知开票","客服通知财务开票","客服部","开票线下操作"]
[12,"已开具（通知领票）",null,"财务部"]
[13,"领取发票","确认领取发票","客服部"]
[14,"客服跟踪及催收款项",null,"客服部","财务查看进度功能"]
[15,"账款核销",null,"财务部","收到款项勾选核销"]

{"sheet":"基础计费","index":1,"n_rows":45,"n_cols":10,"rows_kept":45,"cut":false,"hidden":true,"merged":[[0,0,9,0],[10,0,11,0],[12,0,24,0],[25,0,27,0],[1,1,3,1],[16,2,21,2],[1,3,3,3],[16,4,24,4],[1,5,3,5],[4,5,8,5],[10,5,11,5],[12,5,24,5],[25,5,27,5]]}
["仓库提供数据","收费项目","内容","计费规则","备注","字段"]
[null,"仓租","1.1固定面积仓储费用（或选）","三种报价选择一种（固定收取）",null,"客户名称、日期、仓储总（重量、体积、平方、板、箱、货架占用组数、置地区占用托盘数、耗材占用托盘数）、单价、金额、备注"]
[null,null,"1.2库位包租仓储费用（或选）"]
[null,null,"1.3按流量计仓租费用（或选）"]
[null,"包材费用",null,"手工录入",null,"客户名称、日期、装卸费、理货费、收货验货费、贴标费、其他（手工录入）、备注"]
[null,"仓库卸（装）货费",null,"报价计算"]
[null,"仓库理货费",null,"报价计算"]
[null,"收货验货费",null,"报价计算"]
[null,"产品重新贴条码/标签",null,"报价计算"]
[null,"耗材费",null,"报价计算",null,"序号、客户名称、日期、品名、规格（如下表内容）、单位（个、卷）、数量、单价、金额"]
["1、客服提供","企业备案费用",null,"报价计算",null,"序号、客户名称、日期、产品/类型、批次、数量（个）、单价、金额、备注"]
[null,"产品SKU费用",null,"报价计算"]
["2、关务提供","入区报关操作费","\n\n\n","报价计算","按报关单结合页数","序号、客户名称、日期、报关单号、起止地、车牌号、柜号、车型（3T、5T、8T、10T、12T、20GP、40GP等）报关首页、报关续页、入区报关操作费、运费、压车、返空等具体收费项目关务部提供"]
[null,"报关单改单",null,"报价计算"]
[null,"报关单删单",null,"报价计算",{"$nulls":4},"项目（运输费）"]
[null,"违规申报费",null,"报价计算",null,null,"商户费率","客户","车型","起始地 "]
[null,"前海湾保税港区——深圳门店","运输费用","报价计算","以关务提供字段，提取运输报关资料信息和费用"]
[null,"整批货物配送费前海湾保税港区-深圳门店（单点）",null,"报价按车型"]
[null,"\n中港车费用",null,"报价按车型"]
[null,"蛇口码头运输费用",null,"报价按车型"]
[null,"深圳机场-前海湾保税港",null,"报价按车型"]
[null,"广州机场-前海湾保税港",null,"报价按车型"]
[null,"压车费",null,"结合使用车型计算"]
[null,"返空费",null,"结合使用车型计算"]
[null,"香港装卸费",null,"报价计算"]
["跟着订单票结","出区包裹操作清关费",null,"结合报价跟订单结算           ",null,"序号、客户名称、发货时间、第三订单号、订单状态、保税模式、快递公司、快递单号、海关清单编号、海关缴款书编号、收件人省份、收件人城市、商户门店、货品数量(件、个、支）、货品重量（KG)、实际支付金额、综合税费（关税、消费税、增值税）、派送费、操作费、合计金额、备注"]
[null,"派送费",null,"结合报价跟订单结算           ","区分快递公司，按首重和续重收取费用"]
[null,"综合税费",null,"跟订单结算           "]
[]
["耗材"]
["客户","耗材","规格","数量","单位","金额"]
[null,"0#化妆盒"]
[null,"1#化妆盒"]
[null,"2#化妆盒"]
[null,"N1（5#）"]
[null,"N2（6#）"]
[null,"N3（7#）"]
[null,"N4"]
[null,"气泡膜"]
[null,"胶纸"]
[null,"气泡袋"]
[null,"气泡袋"]
[null,"气泡袋"]
[null,"填充气泡"]
[null,"缠绕膜"]

{"sheet":"计费数据来源","index":2,"n_rows":88,"n_cols":14,"rows_kept":88,"cut":false,"hidden":true,"merged":[[0,1,0,5],[0,9,0,10],[1,9,1,10],[87,1,87,9],[3,0,4,0],[17,0,29,0],[31,0,36,0],[47,0,50,0],[53,0,57,0],[49,1,50,1],[57,1,58,1],[27,2,29,2],[49,2,50,2],[54,2,57,2],[69,2,77,2],[27,3,29,3],[43,3,44,3],[54,3,57,3],[27,4,29,4],[37,4,39,4],[49,4,50,4],[54,4,57,4],[3,5,4,5],[7,5,12,5],[15,5,16,5],[17,5,19,5],[20,5,24,5],[27,5,29,5],[32,5,34,5],[37,5,40,5],[43,5,44,5],[47,5,50,5],[53,5,58,5],[63,5,64,5],[68,5,77,5],[3,6,4,6],[7,6,12,6],[15,6,24,6],[27,6,29,6],[32,6,34,6],[37,6,40,6],[43,6,44,6],[47,6,50,6],[53,6,58,6],[63,6,65,6],[68,6,77,6],[3,7,4,7],[7,7,12,7],[15,7,24,7],[27,7,29,7],[32,7,34,7],[38,7,40,7],[43,7,44,7],[47,7,50,7],[53,7,58,7],[63,7,65,7],[68,7,77,7],[3,8,4,8],[7,8,12,8],[15,8,24,8],[27,8,29,8],[32,8,34,8],[37,8,40,8],[43,8,44,8],[47,8,50,8],[53,8,59,8],[63,8,65,8],[68,8,77,8],[3,9,4,9],[7,9,12,9],[17,9,19,9],[20,9,24,9],[27,9,29,9],[32,9,34,9],[37,9,40,9],[43,9,44,9],[47,9,50,9],[54,9,59,9],[63,9,64,9],[68,9,77,9],[3,10,4,10],[8,10,12,10],[15,10,24,10],[27,10,29,10],[32,10,34,10],[37,10,40,10],[43,10,44,10],[47,10,50,10],[54,10,59,10],[63,10,65,10],[68,10,77,10],[3,12,4,12],[8,12,12,12],[15,12,24,12],[27,12,29,12],[32,12,34,12],[37,12,40,12],[43,12,44,12],[47,12,50,12],[54,12,59,12],[63,12,65,12],[68,12,77,12],[3,13,4,13],[8,13,12,13],[15,13,24,13],[27,13,29,13],[32,13,34,13],[37,13,40,13],[43,13,44,13],[47,13,50,13],[54,13,59,13],[63,13,65,13],[68,13,77,13]]}
[null,"一、数据项目确认",{"$nulls":4},"二、数据来源","三、数据控制",null,"四、数据归口\n",null,"五、数据复核","六、账款核销","客户管理"]
["业务发生阶段","收费项目","业务模式","计费公式","计费规则","产生收费结点","原始数据来源维护部门","原始数据提取方式","数据归集类型","数据归集收费账目",null,"生成挂账凭证","收款核销                       （生成记账凭证）"]
[null,"一、备案收费"]
["客户进货前准备","1、企业备案费",null,"一次固定收费","固定报价","业务完结后","客服部","手工维护","整批核算","代理通关费","应收"]
[null,"2、产品备案费",null,"SKU*单价","固定报价*SKU备案数量"]
[]
["货物报关前准备","二、报关操作"]
[null,"1、报关单改单费",null,"固定报价费率",null,"业务完结后","关务部","手工维护","整批核算","代理通关费"]
[null,"2、报关单删单费",null,"固定报价费率",{"$nulls":6},"应收"]
[null,"3、违规申报",null,"固定报价费率"]
[null,"4、入区报关操作费",null,"固定报价费率（首页*续页）","固定报价（首页XX元，续页RMBX/票（每份报关单最多50项，每5项为一页）"]
[null,"5、自用物资报备费"]
[null,"6、报检代理费"]
[]
[null,"三、招商园区费用"]
[null,"报备费（登记写卡费）",null,null,"固定报价","业务完结后","招商账单                （关务核实）","手工维护","整批核算","代理通关费","应收/应付"]
[null,"货物在场证明费",null,null,"固定报价",{"$nulls":4},"运输费"]
["货物到港提货约车至入园区","园区过夜停车费",null,null,"夜间21:00时至夜间24:00时入闸且在园区停留时间超过6小时，或在除此之外的其它时间入闸，超过夜间24:00出闸的","业务完结后",null,null,null,"运输费"]
[null,"节假日写卡加班费",null,null,"在国家法定节假日发送运抵、写卡和开具在场证明"]
[null,"普通写卡加班费",null,null,"在5:30PM至11:00PM间加班发送运抵、写卡和开具在场证明"]
[null,"区内监管电子关锁使用费",null,null,"固定报价","业务完结后",null,null,null,"订单操作费"]
[null,"区内监管电子关锁逾期使用费"]
[null,"闸门布控车辆过机查验费"]
[null,"统一版布控包裹过机查验费"]
[null,"查验异常包裹超期堆存费"]
[]
[null,"四、代垫费"]
[null,"1、海关查验费",null,"实报实销","实报实销","业务完结后","关务部","手工维护","整批核算","运输费","应收/应付"]
[null,"2、国检查验费"]
[null,"3、国检CIC站台查验费"]
[]
["商品在库","五、仓储费"]
[null,"1、固定面积收租",null,"固定报价*每月","1） 固定仓库区域包租形式；签约日起，免租期15天；                                                      2）500平米起租,超过500平米则以100平米为单位递租；                                                   3）固定包租应承担仓储面积25%公摊率；                                                                          4）包材仓租费按实际面积计算","业务完结后","WMS系统              （仓库核实）","系统提取","整批核算","仓租","应收"]
[null,"2、库位包租",null,"固定报价*每月","1） 库位包租形式；                                                   2）以实际占用数量计算收费面积，最少起租面积不少于35平方米（地面卡板库位9位+轻型货架位1组+重型货架位1组）                                                           3）租赁面积：卡板库位=3.2㎡/个，轻型货架位=4㎡/组，重型货架位=2㎡/位；                                                                           4）包材仓租费按实际面积计算"]
[null,"3、按立方收取",null,"固定报价*立方数*每天","按每天立方数收取"]
[]
[null,"六、装卸费"]
[null,"1、按重量收取",null,"固定报价*货物重量","三者以大者计收（最低收费100元）","业务完结后","仓库","系统提取","整批核算","运输费","应收"]
[null,"2、按体积收取",null,"固定报价*货物体积",null,null,null,"手工维护"]
[null,"3、按卡板收取",null,"固定报价*货物卡板数"]
[null,"4、按整柜收取","一般贸易（新增）","固定报价*柜数"]
[]
[null,"六、库内增值服务"]
[null,"1、贴条码费",null,"视情况报价*数量",null,"订单操作中","仓库","手工维护","跟着订单票结","订单包裹费","应收"]
[null,"2、放宣传物及礼品"]
[]
[null,"七、包裹操作费"]
["包裹在库","1、订单操作费1                         ","备货模式                    ","阶梯式报价*包裹/个","1）包裹商品数量>3件,每增加一件收0.5元,放促销物宣传单视同计件；                                                   2）包裹商品数量>10件，按最大数量限额10件来拆分为多个包裹，分别计算收取操作费；                       ","订单操作中","WMS系统                  （仓库核实）","系统提取","跟着订单票结","订单包裹费","应收"]
[null,"2、订单操作费2","展示出区"]
[null,"订单使用耗材费1                     订单使用耗材费2 ","备货模式                    展示出区","箱型*报价"]
[null,null,null,"实际领用*报价"]
[]
[null,"八、包裹快递费"]
["包裹出库","1、正常订单派送费",null,null,null,"订单操作中","WMS系统                           （财务部核实）","系统提取","跟着订单票结"]
[null,"顺丰快递","备货模式","首重+续重","1、顺丰、中通=首重+续重                                                         2、韵达-按重量区间计费",{"$nulls":4},"订单包裹费","应收/应付"]
[null,"中通快递"]
[null,"邮政快递"]
[null,"韵达快递"]
[null,null,"展示模式","一口报价","如当天出车订单量小于200单，另加收XXX元运输费"]
[null,"2、异常订单派送费",{"$nulls":4},"客服","手工维护"]
[]
[]
[null,"九、库内其他作业费"]
[null,"理货费",null,"固定报价*件数",null,"业务完结后","仓库","手工维护","整批核算","退港费","应收"]
[null,"卡板费",null,"固定报价*卡板数"]
[null,"验货费",null,"固定报价*件数",null,"业务完结后",null,null,null,"订单包裹费"]
[]
[null,"十、运输费"]
[null,"1、园区-门店（国内运输）","展示出区","车型*固定报价",null,"业务完结后","关务","手工维护","整批核算","运输费","应收/应付"]
[null,"2、HK-保税区（中港运输）","备货模式",null,"压夜费在次日12:00前则最低按当次运费80%的计算，若压车超过次日中午12:00则最低按运费的100%计算"]
[null,"运输费",null,"车型*固定报价"]
[null,"压日/夜费",null,"车型*固定报价*80%或100%","压夜费在次日12:00前则最低按当次运费80%的计算，若压车超过次日中午12:00则最低按运费的100%计算"]
[null,"返空费",null,"车型*固定报价*80%或100%"," 车辆已到装货点，非我司原因导致车辆放空，返空费按该趟运费的100%计算； 车辆已到在装货途中导致车辆放空，返空费按该趟运费的80%计算（产生相关费用时，实报实销）"]
[null,"提货及装卸费",null,"重量、体积、卡板、箱数*单价（取大收取）","KG//CBM/plt/CTN;四者以大者计收（最低消费RMBXX/仓，如需多点提货和多点卸货每地加收XXX元）"]
[null,"清关费",null,null,"香港进口报关费收费：报关代理费RMB106，无缝清关RMB53元、香港税金实报实销（最低收费212元单）；香港出口代理报关收费模式与进口报关相同。"]
[null,"其他杂费",null,"实报实销"]
[null,"3、机场-保税区（国内运输）"]
[null,"4、蛇口码头-保税区（国内运输）"]
[]
[null,"十一、税单",null,null,null,"订单操作中","技术部","系统提取","跟着订单票结"]
{"$rows_empty":7}
[null,"7、功能需求：查询、修改、筛选、删除、导出excel、打印"]

{"sheet":"前海电商收款通知书","index":3,"n_rows":50,"n_cols":28,"rows_kept":50,"cut":false,"hidden":false,"merged":[[2,4,2,11],[8,23,8,29],[10,23,10,29],[15,1,15,11],[17,1,17,5],[17,7,17,9],[19,1,19,5],[21,1,21,5],[21,6,21,12],[21,18,21,29],[26,1,26,4],[26,5,26,18],[26,19,26,24],[26,25,26,29],[27,1,27,4],[27,5,27,18],[27,19,27,24],[27,25,27,29],[28,1,28,4],[28,5,28,18],[28,19,28,24],[28,25,28,29],[29,1,29,4],[29,5,29,18],[29,19,29,24],[29,25,29,29],[30,1,30,4],[30,5,30,18],[30,19,30,24],[30,25,30,29],[31,1,31,4],[31,5,31,18],[31,19,31,24],[31,25,31,29],[32,1,32,4],[32,5,32,18],[32,19,32,24],[32,25,32,29],[33,1,33,4],[33,5,33,18],[33,19,33,24],[33,25,33,29],[34,1,34,4],[34,5,34,18],[34,19,34,24],[34,25,34,29],[35,1,35,4],[35,5,35,18],[35,19,35,24],[35,25,35,29],[36,1,36,4],[36,5,36,18],[36,19,36,24],[36,25,36,29],[37,1,37,4],[37,5,37,18],[37,19,37,24],[37,25,37,29],[38,1,38,4],[38,5,38,18],[38,19,38,24],[38,25,38,29],[39,1,39,4],[39,5,39,18],[39,19,39,24],[39,25,39,29],[40,1,40,4],[40,5,40,18],[40,19,40,24],[40,25,40,29],[41,1,41,4],[41,5,41,18],[41,19,41,29],[44,16,44,23],[49,1,49,21],[50,1,50,20],[1,2,3,2],[5,22,6,22],[24,26,25,26],[3,4,5,16],[5,23,6,29],[6,11,12,14],[12,1,13,5],[23,1,24,7],[23,9,24,17],[24,27,25,28],[43,1,46,13],[46,20,47,27],[47,1,48,13]]}
[]
[]
[{"$nulls":4},"深圳前海电商供应链管理有限公司"]
[{"$nulls":4},"ShenZhen Qianhai Electric Supply Chain Management CO.,Ltd"]
[]
[{"$nulls":22},"Tel：","0755-21628280"]
[{"$nulls":11},"收款通知书\nDEBIT NOTE"]
[]
[{"$nulls":22},"Fax：","0755-21628272"]
[]
[]
[]
[null,"收款单号"]
[]
[]
[null,"Debit Note No.:201809-FWF-QHK012"]
[]
[null,"签发日期",{"$nulls":5},"2018-10-12"]
[]
[null,"Issued Date: "]
[]
[null,"客户  Payer:"]
[]
[null,"计费区间  Billing Period:",{"$nulls":7},"2018年09月01日至09月30日"]
[{"$nulls":26},"税点：","6%"]
[]
[null,"序列号\nNo.",null,null,null,"收费明细 \nParticulars",{"$nulls":13},"金额（人民币）\nAmount(in RMB)",{"$nulls":5},"税额(人民币)\nTAX AMOUNT(RMB)"]
[null,1,null,null,null,"9月仓储费",{"$nulls":13},1,{"$nulls":5},{"$f":"T28*0.06","v":0.06}]
[null,2,null,null,null,"9月派送费及操作费",{"$nulls":13},1,{"$nulls":5},0.06]
[null,3,null,null,null,"9月运输及代理费服务费",{"$nulls":13},1,{"$nulls":5},0.06]
[null,4,null,null,null,"9月耗材费",{"$nulls":13},1,{"$nulls":5},0.06]
[null,5,null,null,null,"9月技术服务费",{"$nulls":13},1,{"$nulls":5},0.06]
[null,6,null,null,null,"9月异常费用",{"$nulls":13},1,{"$nulls":5},0.06]
[]
[]
[{"$nulls":25},{"$f":"T36*0.06","v":0}]
[{"$nulls":25},0]
[{"$nulls":25},0]
[{"$nulls":25},0]
[{"$nulls":25},0]
[null,"小计",{"$nulls":17},{"$f":"SUM(T28:Y40)","v":6},{"$nulls":5},{"$f":"SUM(Z28:AD40)","v":0.36}]
[null,"总计",null,null,null,{"$f":"AA44&SUBSTITUTE(SUBSTITUTE(IF(-DOLLAR(T42),TEXT(T42,\";负\")&TEXT(INT(ABS(T42)+0.5%),\"[dbnum2]G/通用格式元;;\")&TEXT(RIGHT(DOLLAR(T42),2),\"[dbnum2]0角0分;;整\"),),\"零角\",IF(T42^2<1,,\"零\")),\"零分\",\"整\")","v":"人民币陆元叁角陆分"},{"$nulls":13},{"$f":"T41+Z41","v":6.36}]
[]
[null,"公司银行资料\n公司名称:        深圳前海电商供应链管理有限公司\n开户银行:        中国建设银行深圳福华支行\n帐号：44201010300052533720\n地址：:      深圳市前海深港合作区临海大道59号海运中心口岸楼606G房\n",{"$nulls":24},"人民币"]
[]
[]
[{"$nulls":20},"签发人：肖湘辉"]
[null,"请根据双方合同中约定的时间，以书面形式向签发人确认账单。如\n付款人在收到本通知书之日起五日内不予书面确认的，则视为付款\n人对本通知书内容已经于收到之日予以确认。    \n"]
[]
[null,"Please confirm in writing within stipulated period in the agreement,                                           otherwise it will be regarded as default. "]

{"sheet":"中网收款通知书","index":4,"n_rows":44,"n_cols":28,"rows_kept":44,"cut":false,"hidden":false,"merged":[[6,23,6,29],[8,23,8,29],[13,1,13,11],[15,1,15,5],[15,7,15,9],[17,1,17,5],[19,1,19,5],[19,6,19,12],[19,18,19,29],[24,1,24,4],[24,5,24,18],[24,19,24,24],[24,25,24,29],[25,1,25,4],[25,5,25,18],[25,19,25,24],[25,25,25,29],[26,1,26,4],[26,5,26,18],[26,19,26,24],[26,25,26,29],[27,1,27,4],[27,5,27,18],[27,19,27,24],[27,25,27,29],[28,1,28,4],[28,5,28,18],[28,19,28,24],[28,25,28,29],[29,1,29,4],[29,5,29,18],[29,19,29,24],[29,25,29,29],[30,1,30,4],[30,5,30,18],[30,19,30,24],[30,25,30,29],[31,1,31,4],[31,5,31,18],[31,19,31,24],[31,25,31,29],[32,1,32,4],[32,5,32,18],[32,19,32,24],[32,25,32,29],[33,1,33,4],[33,5,33,18],[33,19,33,24],[33,25,33,29],[34,1,34,4],[34,5,34,18],[34,19,34,24],[34,25,34,29],[35,1,35,4],[35,5,35,18],[35,19,35,29],[38,16,38,23],[43,1,43,21],[44,1,44,20],[3,22,4,22],[22,26,23,26],[1,4,3,19],[3,23,4,29],[4,11,10,14],[10,1,11,5],[21,1,22,7],[21,9,22,17],[22,27,23,28],[37,1,40,13],[40,20,41,27],[41,1,42,13]]}
[]
[{"$nulls":4},"                                          中网科技（深圳）有限公司"]
[]
[{"$nulls":22},"Tel：","0755-21628280"]
[{"$nulls":11},"收款通知书\nDEBIT NOTE"]
[]
[{"$nulls":22},"Fax：","0755-21628272"]
[]
[]
[]
[null,"收款单号"]
[]
[]
[null,"Debit Note No.:201809-FWF-APLZ030"]
[]
[null,"签发日期",{"$nulls":5},"2018-10-12"]
[]
[null,"Issued Date: "]
[]
[null,"客户  Payer:"]
[]
[null,"计费区间  Billing Period:",{"$nulls":7},"2018年10月1日至10月31日"]
[{"$nulls":26},"税点：",0.06]
[]
[null,"序列号\nNo.",null,null,null,"收费明细 \nParticulars",{"$nulls":13},"金额（人民币）\nAmount(in RMB)",{"$nulls":5},"税额(人民币)\nTAX AMOUNT(RMB)"]
[null,1,null,null,null,"10月平台服务费",{"$nulls":13},1,{"$nulls":5},{"$f":"T26*0.06","v":0.06}]
[null,2]
[null,3,{"$nulls":23},0]
[null,4]
[null,5,{"$nulls":23},0]
[null,6]
[null,7]
[null,8]
[null,9]
[null,"小计",{"$nulls":17},{"$f":"SUM(T26:T34)","v":1},{"$nulls":5},{"$f":"SUM(Z26:Z34)","v":0.06}]
[null,"总计",null,null,null,{"$f":"AA38&SUBSTITUTE(SUBSTITUTE(IF(-DOLLAR(T36),TEXT(T36,\";负\")&TEXT(INT(ABS(T36)+0.5%),\"[dbnum2]G/通用格式元;;\")&TEXT(RIGHT(DOLLAR(T36),2),\"[dbnum2]0角0分;;整\"),),\"零角\",IF(T36^2<1,,\"零\")),\"零分\",\"整\")","v":"人民币壹元零陆分"},{"$nulls":13},{"$f":"T35+Z35","v":1.06}]
[]
[null,"公司银行资料\n公司名称:        中网科技（深圳）有限公司\n开户银行:        北京银行股份有限公司深圳分行\n银行帐号：      20000032506200012146872\n地址：      深圳市南山区南头街道桃园路1号西海明珠大厦E座1503\n\n",{"$nulls":24},"人民币"]
[]
[]
[{"$nulls":20},"签发人：肖湘辉"]
[null,"请根据双方合同中约定的时间，以书面形式向签发人确认账单。如\n付款人在收到本通知书之日起五日内不予书面确认的，则视为付款\n人对本通知书内容已经于收到之日予以确认。    \n"]
[]
[null,"Please confirm in writing within stipulated period in the agreement,                                           otherwise it will be regarded as default. "]

{"sheet":"预缴税款收款通知书","index":5,"n_rows":29,"n_cols":6,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[2,1,2,5],[3,1,3,5],[4,1,4,4],[5,1,5,4],[6,1,6,4],[7,1,7,4],[8,1,8,4],[9,1,9,4],[10,1,10,4],[11,1,11,4],[12,1,12,4],[13,1,13,4],[14,1,14,4],[15,1,15,4],[16,1,16,4],[17,1,17,4],[18,1,18,4],[26,5,27,5],[21,0,24,5],[26,0,27,4]]}
["深圳前海电商供应链管理有限公司"]
["预缴税款收款通知书"]
["签发日期","2018-11-02"]
["客户："]
["序列号\n","收费明细 \n",null,null,null,"金额（人民币）"]
[1,"10月代缴保税电商综合税",null,null,null,1]
{"$rows_empty":11}
["小计",{"$nulls":4},{"$f":"SUM(F6:F17)","v":1}]
["总计",{"$f":"F29&SUBSTITUTE(SUBSTITUTE(IF(-DOLLAR(F19),TEXT(F19,\";负\")&TEXT(INT(ABS(F19)+0.5%),\"[dbnum2]G/通用格式元;;\")&TEXT(RIGHT(DOLLAR(F19),2),\"[dbnum2]0角0分;;整\"),),\"零角\",IF(F19^2<1,,\"零\")),\"零分\",\"整\")","v":"人民币壹元整"},null,null,null,{"$f":"F18","v":1}]
[]
[]
["公司银行资料\n公司名称:        深圳前海电商供应链管理有限公司\n开户银行:        中国建设银行深圳福华支行\n帐号：           44201010300052533720\n地址：       深圳市前海深港合作区临海大道59号海运中心口岸楼606G房\n"]
[]
[]
[]
[]
["   此通知发出之日起15日内未缴清税款，我司将按逾期账款总金额收取日万分之五的滞纳金，滞纳金计算期间为自款项到期之日起至客户款项付至我司账户之日为止。",{"$nulls":4},"签发人：肖湘辉"]
[]
[{"$nulls":5},"人民币"]

{"sheet":"应收结算模块","index":6,"n_rows":18,"n_cols":30,"rows_kept":18,"cut":false,"hidden":true,"merged":[[0,0,0,22],[6,0,6,6],[13,0,13,29],[17,2,17,10]]}
["派送操作费（字段从OMS提取）"]
["第三方订单号","订单状态","商户名称","货品数量","货品重量","保税模式","快递公司名称","快递单编号","海关清单编号","收件人省份","收件人城市","收件人地址","支付单号","下单时间","实际支付金额","物流运输编号","推送时间","商户门店","园区状态","发货时间","关税","派送费","操作费"]
[]
[]
[]
[]
["产品备案费用表                             ",{"$nulls":6},"月份： 月份"]
["序号","客户","产品/类型","批次","数量（个）","单价","金额","备注"]
[1]
[]
[]
[]
[]
["保税区代理通关服务费（以下仅供参考，具体以关务的字段为准）"]
["序号","客户名称","进境    日期","报关单号","境进地/运地","车牌号","柜号","车型","页面","入区报关操作费","入区报备费","运输费","香港报关费","压车费","返空费","舱单费","排仓费","转关费","货站换单费","报检代理费","查验费","香港装卸费","保税仓装货费","理货费","电子关锁","代垫费","实报实销费用","金额","备注","毛重KG"]
[1,{"$nulls":26},{"$f":"SUM(J16:AA16)","v":0}]
[]
[null,null,"合计",{"$nulls":24},{"$f":"SUM(AB16:AB17)","v":0},null,{"$f":"SUM(AD16:AD17)","v":0}]