{"text_format":"2","workbook":"xlsx","n_sheets":11,"sheets":["操作流程","商户费率及维护字段","计费数据来源","耗材费率","供应商 商户档案","前海电商收款通知书","中网收款通知书","预缴税款收款通知书","保税备货快递、操作及耗材明细样例","保税展示快递、操作及耗材明细样例","综合税费明细样例"],"not_rendered":{"charts":0,"images":3,"macros":0,"external_links":0,"defined_names":3,"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":88,"n_cols":32,"rows_kept":88,"cut":false,"hidden":false,"merged":[[0,2,0,5],[0,6,0,10],[5,2,5,6],[9,2,9,5],[9,6,9,10],[14,2,14,6],[14,7,14,10],[19,2,19,7],[24,2,24,5],[24,6,24,8],[24,9,24,11],[28,2,28,5],[32,2,32,4],[32,5,32,7],[36,2,36,4],[41,2,41,5],[41,6,41,8],[45,2,45,9],[50,2,50,10],[56,12,56,15],[64,3,64,29],[70,2,70,17],[29,7,30,7],[29,8,30,8]]}
[null,null,"仓储费率"]
["商户费率",null,"归属商户","库位包租仓储","固定面积仓储","重量\n","体积"]
[null,null,null,"*报价","*报价","*报价","*报价"]
[]
[]
["录入数据界面",null,"仓储费"]
[null,"日期","商户名称","库位包租仓储","固定面积仓储","重量","体积","数据归集收费账目","归口账单类型","计费规则"]
[{"$nulls":7},"仓租费","应收账单","1、固定仓库区域包租形式 2、 库位包租形式，以实际占用数量计算收费面积，最少起租面积不少于35平方米"]
["                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      "]
[null,null,"包裹操作费率（订单抓取）-费用录入界面无"]
[null,null,"归属商户","操作费之起步价格","出库操作费之递增价格","数据归集收费账目","归口账单类型","计费规则"]
[null,null,null,"*报价","*报价","订单包裹费","应收账单","1、小于等于3件按起步价收取2、包裹商品数量>3件,每增加一件收0.5元,放促销物宣传单视同计件； 2）包裹商品数量>10件，按最大数量限额10件来拆分为多个包裹，分别计算收取操作费；     "]
[]
["                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      "]
["商户费率",null,"园区仓库装卸费率"]
[null,null,"归属商户","重量\n","体积","整柜","板"]
[null,null,null,"*报价","*报价","*报价","*报价"]
[]
[]
["录入数据界面",null,"园区仓库装卸费"]
[null,"日期","商户名称","重量\n","体积","整柜","板","其他","数据归集收费账目","归口账单类型","计费规则"]
[{"$nulls":8},"库内操作费","应收账单"]
["                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      "]
[]
["商户费率",null,"库内操作费率"]
[null,null,"归属商户","理货费","收货验货费率","产品重新贴条码/标签"]
[null,null,null,"*报价","*报价","*报价"]
[]
["录入数据界面",null,"库内操作费\n",{"$nulls":4},"数据归集收费账目","归口账单类型"]
[null,"日期","商户名称","仓库理货费","收货验货费","产品重新贴条码/标签","库内增值服务","库内操作费","应收账单"]
[null,null,null,"优缺优缺点件 "]
["                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      "]
["商户费率",null,"备案费率"]
[null,null,"归属商户","企业备案费","产品备案费"]
[null,null,null,"*报价","*报价"]
[]
[null,null,"备案费\n",null,null,"其他"]
["录入数据界面","日期","商户名称","企业备案费","产品备案费",null,"数据归集收费账目","归口账单类型"]
[null,null,null,"优缺优缺点件 ",null,null,"代理通关费","应收账单"]
["                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      "]
[]
["商户费率",null,"通关操作费率"]
[null,null,"归属商户","入区报关操作费（首页）","入区报关操作费（续页数）","入区报关操作费（续页报价）","报备费（登记写卡费）","报关单改单费","报关单删单费","违规申报","自用物资报备费"]
[null,null,null,"*报价",null,"*报价","*报价","*报价","*报价","*报价","*报价"]
[]
["录入数据界面",null,"通关操作费\n"]
[null,"日期","商户名称","入区报关操作费（首页）","入区报关操作费（续页）","报备费（登记写卡费）","报关单改单费","报关单删单费","违规申报","自用物资报备费","报检代理费","其他","数据归集收费账目","归口账单类型"]
[null,null,null,"优缺优缺点件 ",{"$nulls":8},"代理通关费","应收账单"]
[]
["                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      "]
["录入数据界面",null,"招商园区费用(无费率，直接录入金额)"]
[null,"日期","商户名称","承运商","货物在场证明费","园区过夜停车费","节假日写卡加班费","普通写卡加班费","区内监管电子关锁使用费","区内监管电子关锁逾期使用费","区内监管电子关锁使用费","区内监管电子关锁逾期使用费","闸门布控车辆过机查验费","统一版布控包裹过机查验费","查验异常包裹超期堆存费","数据归集收费账目","归口账单类型"]
[{"$nulls":15},"代理通关费","应收账单/应付账单"]
["                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      "]
[]
[{"$nulls":5},"运输费率"]
["商户费率",null,"归属商户","起始地 ","3T","5T","8T","10T","12T","20GP","40GP","45HQ","香港装卸费率（仅中港车）"]
[{"$nulls":4},"运输费/返空费/压日/压夜费","运输费/返空费/压日/压夜费","运输费/返空费/压日/压夜费","运输费/返空费/压日/压夜费","运输费/返空费/压日/压夜费","运输费/返空费/压日/压夜费","运输费/返空费/压日/压夜费","运输费/返空费/压日/压夜费","重量","体积","板","箱"]
[null,null,null,"1、前海湾保税港区——深圳门店 ","*报价","*报价","*报价","*报价","*报价","*报价","*报价","*报价"]
[null,null,null,"2、前海湾保税港区-深圳门店（单点）","*报价","*报价","*报价","*报价","*报价","*报价","*报价","*报价"]
[null,null,null,"\n3、中港车费用","*报价","*报价","*报价","*报价","*报价","*报价","*报价","*报价","*报价","*报价","*报价","*报价"]
[null,null,null,"4、蛇口码头运输费用","*报价","*报价","*报价","*报价","*报价","*报价","*报价","*报价"]
[null,null,null,"5、深圳机场-前海湾保税港","*报价","*报价","*报价","*报价","*报价","*报价","*报价","*报价"]
[]
["录入数据界面",null,null,"运输费"]
[null,"日期","商户名称","报关单号","承运商","起始地 ","车型","车牌号","货物单位","币种","运费","返空费/压日/压夜费","舱单","进出口报关","偏远费","提货/装卸费","超时费","登记费","换提单手续费","排仓费","过站费","港口建设费","园区库内装卸费","报检代理","海关查验费","代垫费","香港仓租","杂费","合计","备注","数据归集收费账目","归口账单类型"]
[{"$nulls":4},"选择","选择","选择",null,"选择香港装卸费率对应的（重量/体积/卡板/箱），",null,"根据车型对应的运输费率","根据车型对应",null,null,null,"根据香港装卸费率来计算四种费用，应该分成4x2（费用）x2(数量）个字段",{"$nulls":14},"运输费","应收账单/应付账单"]
["                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      "]
[]
[]
[null,null,"包裹快递费率（数据从OMS系统抓取）"]
[null,null,"物流公司名称 ","物流运送类型 ","归属商户","收寄地区 ","送达省份 ","送达城市","首重费 ","首重限重 ","续重金额 ","续重重量 ","≤1kg价格",">1kg≤3.5kg价格",">3.5kg价格","数据归集收费账目","归口账单类型"]
["物流费率",null,"韵达快递",{"$nulls":5},"*报价",null,"*报价",null,"*报价","*报价","首重+续重报价","订单包裹费","应收账单/应付账单"]
[null,null,"中通快递",{"$nulls":5},"*报价",null,"*报价"]
[null,null,"中国邮政",{"$nulls":5},"*报价",null,"*报价"]
[null,null,"顺丰快递",{"$nulls":5},"*报价",null,"*报价"]
[]
["                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      "]
[]
[]
["商户费率",null,"纸箱耗材费率（包括自有和商户分类），天虹使用的自有纸箱","按耗材所在sheet设置费率维护"]
[null,null,"天虹纸箱耗材费用","天虹的纸费和耗材费跟订单抓取结算，其纸箱费和耗材费计入订 包裹费用，归集为订单包裹费"]
[null,null,"非天虹纸箱耗材费用","手工维护纸箱和耗材数据，计入耗材费，结算后，归集入耗材费"]
[]
["录入数据界面（略）"]
[]
[]
["备注：","录入金额黄色标记，业务数据（跟费率挂沟）用绿色标记"]

{"sheet":"计费数据来源","index":2,"n_rows":88,"n_cols":14,"rows_kept":88,"cut":false,"hidden":false,"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],[46,0,49,0],[52,0,56,0],[48,1,49,1],[56,1,57,1],[27,2,29,2],[48,2,49,2],[53,2,56,2],[69,2,77,2],[27,3,29,3],[53,3,56,3],[27,4,29,4],[37,4,39,4],[48,4,49,4],[53,4,56,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],[46,5,49,5],[52,5,57,5],[62,5,63,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],[46,6,49,6],[52,6,57,6],[62,6,64,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],[46,7,49,7],[52,7,57,7],[62,7,64,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],[46,8,49,8],[52,8,58,8],[62,8,64,8],[68,8,77,8],[3,9,4,9],[7,9,12,9],[15,9,24,9],[27,9,29,9],[32,9,34,9],[37,9,40,9],[46,9,49,9],[53,9,58,9],[62,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],[46,10,49,10],[53,10,58,10],[62,10,64,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],[46,12,49,12],[53,12,58,12],[62,12,64,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],[46,13,49,13],[53,13,58,13],[62,13,64,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,"固定报价"]
["货物到港提货约车至入园区","园区过夜停车费",null,null,"夜间21:00时至夜间24:00时入闸且在园区停留时间超过6小时，或在除此之外的其它时间入闸，超过夜间24:00出闸的","业务完结后"]
[null,"节假日写卡加班费",null,null,"在国家法定节假日发送运抵、写卡和开具在场证明"]
[null,"普通写卡加班费",null,null,"在5:30PM至11:00PM间加班发送运抵、写卡和开具在场证明"]
[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、放宣传物及礼品",{"$nulls":7},"库内操作费"]
[]
[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,"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":47,"n_cols":7,"rows_kept":47,"cut":false,"hidden":false,"merged":[[0,0,0,5],[20,0,20,6],[37,0,37,6]]}
["手工录入耗材费率(非天虹)"]
["归属商户","品名","规格","个","卷","板"]
[null,"0#化妆盒","16*10.8*9.6"]
[null,"1#化妆盒","22*15*10"]
[null,"2#化妆盒","26*15*18"]
[null,"N1（5#）","32*20*27"]
[null,"N2（6#）","40*32*27"]
[null,"N3（7#）","48*40*27"]
[null,"N4","40*32*54"]
[null,"气泡膜","30cm*60cm"]
[null,"胶纸","5cm"]
[null,"气泡袋","20*30"]
[null,"气泡袋","20*40"]
[null,"气泡袋","25*40"]
[null,"填充气泡","10*20"]
[null,"缠绕膜","45cm"]
[null,"塑胶卡板",{"$nulls":4},"wq knx "]
[null,"木卡板"]
[]
[]
["跟订单抓取的耗材费率(备货）（计入包裹操作费用）"]
["归属商户（仅天虹）","纸箱规格","纸箱代码","纸箱费（使用我司纸箱）","耗材费用","数据归集收费账目","归口账单类型"]
[null,null,null,"*报价","*报价","订单包裹费","应收账单"]
[null,"18*13*8cm(自有纸箱）","1#(原箱）"]
[null,"24*13.5*16.5cm(自有纸箱）","2#"]
[null,"29*17*19cm(自有纸箱）","3#"]
[null,"37*23*12cm(自有纸箱）","4#"]
[null,"37*23*20cm(自有纸箱）","5#、6#、7#、8#"]
[null,"16*10.8*9.6cm（使用我司纸箱）","0#化妆品盒"]
[null,"22*15*10cm（使用我司纸箱）","1#化妆品盒"]
[null,"26*15*18cm（使用我司纸箱）","2#化妆品盒"]
[null,"32*20*27cm（使用我司纸箱）","N1"]
[null,"40*32*27cm（使用我司纸箱）","N2"]
[null,"48*40*27cm（使用我司纸箱）","N3"]
[null,"40*32*52cm（使用我司纸箱）","N4"]
[]
[]
["跟订单抓取的耗材费率(保税展示）（计入包裹操作费用）"]
["归属商户（仅天虹）","纸箱规格","纸箱代码","纸箱费（使用我司纸箱）","耗材费用","数据归集收费账目","归口账单类型"]
[null,null,null,"*报价","*报价","订单包裹费","应收账单"]
[null,"24*10*7cm(自有纸箱）","001"]
[null,"25*19*18.5cm(自有纸箱）","002"]
[null,"23*16*13.5cm(自有纸箱）","003"]
[null,"29.5*17*15cm(自有纸箱）","004"]
[null,"34.5*19.5*14.5cm(自有纸箱）","005"]
[null,"39*27*16cm(自有纸箱）","006"]
[null,"40*38*25cm(自有纸箱）","007"]

{"sheet":"供应商 商户档案","index":4,"n_rows":31,"n_cols":6,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,0,0,5],[10,0,10,5],[17,0,17,5],[27,0,27,5]]}
["供应商基本信息"]
["地区",null,"省",null,"市 "]
["联系人",null,"电话"]
["供应商编号",null,"供应商类别：","物流供应商/原材料供应商/其他","供应商分类","中港运输/国内运输/快递运输/仓库耗材/办事耗材/其他"]
["供应商名称"]
[]
[]
[]
[]
[]
["财务信息"]
["结算方式","月结","币种",null,"开户行"]
["户名",null,"帐号"]
["纳税人类型","一般纳税人/小规模纳税人/其他","税率","%","税票类型","增值税专用发票/增值税普通发票/形式发票"]
[]
[]
[]
["客户基本信息"]
["地区",null,"省",null,"市 "]
["联系人",null,"电话"]
["供应商编号",null,"供应商类别：","物流供应商/原材料供应商/其他","供应商分类","中港运输/国内运输/快递运输/仓库耗材/办事耗材/其他"]
["供应商名称"]
[]
[]
[]
[]
[]
["财务信息"]
["结算方式","月结","币种",null,"开户行"]
["户名",null,"帐号"]
["纳税人类型","一般纳税人/小规模纳税人/其他","税率","%","税票类型","增值税专用发票/增值税普通发票/形式发票"]

{"sheet":"前海电商收款通知书","index":5,"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":6,"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":7,"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":8,"n_rows":12,"n_cols":18,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["序号","发货时间","第三方订单号","商户名称","保税模式","快递公司","快递单号","订单重量 KG","省份","城市","派送费","北京件调价","纸箱代码","纸箱费","耗材费用","操作费","合计","备注"]
[1,"2018-09-30","602916934301","天虹商场","保税备货模式","韵达速递","3101976651435",0.173,"广东省","深圳市",5.3,null,"001",2.2,0.5,5,{"$f":"K2+L2+N2+O2+P2","v":13},"使用我司纸箱"]
[2,"2018-09-30","602916571001","天虹商场","保税备货模式","韵达速递","3101976651433",0.445,"广东省","深圳市",5.3,null,"ISTH02",null,0.8,5,{"$f":"K3+L3+N3+O3+P3","v":11.1}]
[]
[{"$nulls":10},{"$f":"SUM(K2:K4)","v":10.6},{"$f":"SUM(L2:L4)","v":0},null,{"$f":"SUM(N2:N4)","v":2.2},{"$f":"SUM(O2:O4)","v":1.3},{"$f":"SUM(P2:P4)","v":10},{"$f":"SUM(Q2:Q4)","v":24.1}]
[]
[]
[]
["注：系统716票-114（天虹保税展示）=602（保税备货）"]
[]
[]
["只有天虹有纸箱费、耗材费"]

{"sheet":"保税展示快递、操作及耗材明细样例","index":9,"n_rows":8,"n_cols":15,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["序号","发货时间","第三方订单号","商户名称","保税模式","快递公司","快递单号","订单重量 KG","省份","纸箱代码","纸箱费用","内耗费用","派送费","操作费","合计"]
[1,"2018-09-26","602698948301","天虹商场","保税展示","韵达速递","3101976651318",0.18,"广东省","001",0.3,0.5,4.3,3.5,{"$f":"K2+L2+M2+N2","v":8.6}]
[]
[]
[]
[{"$nulls":10},{"$f":"SUM(K2:K5)","v":0.3},{"$f":"SUM(L2:L5)","v":0.5},{"$f":"SUM(M2:M5)","v":4.3},{"$f":"SUM(N2:N5)","v":3.5},{"$f":"SUM(O2:O5)","v":8.6}]
[]
[null,null,null,"只有天虹有纸箱费、耗材费"]

{"sheet":"综合税费明细样例","index":10,"n_rows":6,"n_cols":16,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["收货人姓名","收货人联系电话","第三方订单号","电子税单编号","应征关税（总计）","应征增值税（总计）","应征消费税（总计）","海关税单状态","缴款书编号","海关商品编码","完税总价格","应征关税","应征增值税","应征消费税","合计","客户名称"]
["朱雪飞","15854886535","621600709501","53492018I743014170_0",0,6.61,0,"已生成",null,"3304990039",59,0,6.61,0,{"$f":"L2+M2+N2","v":6.61},"天虹商场"]
["邱俊","13683511049","621699535201","53492018I743014302_0",0,6.61,0,"已生成",null,"4818900000",59,0,6.61,0,{"$f":"L3+M3+N3","v":6.61},"天虹商场"]
["刘","13543318878","621699421001","53492018I742273138_0",0,2.23,0,"已生成",null,"3307900000",19.9,0,2.23,0,{"$f":"L4+M4+N4","v":2.23},"天虹商场"]
[]
[{"$nulls":14},{"$f":"SUM(O2:O5)","v":15.45}]