{"text_format":"2","workbook":"xlsx","n_sheets":34,"sheets":["个人工作台需求模板","单票利润滚动表","单票毛利异常表","未达权责点已开票及已回票","已达权责点未开票及未回票","预收账款未拆分统计表","应付未回发票","单票费用统计表","分环节统计表","经营财务分析（按经营单位统计）","经营财务分析（按开票名称统计）","应收、预收账龄表 ","应付、预付账龄表","应付账龄表","应收账龄表","可用资金汇总表","资金日历、计划与实际差异表","贷款备查簿","信控风险分析","（客户、供应商）合同结算期跟踪统计表","费用统计表(按部门预算对比）","报销费用汇总（按个人）","报销费用汇总（按部门明细）","关联交易统计表","关联应收应付统计表","协同业务明细表","业务员业绩统计表","分货名毛利统计表","业务完结情况表","月度回款统计","港口对账单统计","商务KPI","平仓损益表","本模板规则"],"not_rendered":{"charts":6,"images":35,"macros":0,"external_links":1,"defined_names":2,"comments":0,"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":1817,"n_cols":16,"rows_kept":1817,"cut":false,"hidden":false,"merged":[]}
["序号","分类","事项\n（或者报表标题）",null,"统计范围\n(用于财务报表)","频度","推送方式","推送角色\n(请参考模板规则)","备注1：\n（用于补充\\备注。如果有多推送方式，也可在这备注）","备注2",null,"业务系统是否有该模块","模块位置","对应序号","核实情况","附件"]
[null,"预警提醒","船公司收据签收十天未换发票","从业务系统取数","单体","每天","系统在线","财务经理、总账会计、会计","取数：收据签收日期+10",null,null,"系统无"]
[null,"我的报表","单票费用统计表","暂时保留，和领导对碰","事业部、单体","每天","系统在线","财务经理、总账会计、商务经理","动态表，需在线查询",null,null,"系统有","报表中心--每日报表--单票费用统计",14,"已完成"]
[null,"我的报表","单票利润滚动表（船名，柜量柜型字段缺少）","从k3取数","事业部、单体","每天","系统在线","财务经理、总账会计、商务经理",null,null,null,"系统无"]
[null,"我的报表","经营财务分析（按经营单位统计）","从k3取数","事业部、单体","每周","系统在线","财务经理、商务经理、总账会计","每月推送货代总：同比按周折线对比图",null,null,"系统无"]
[null,"我的报表","经营财务分析（按开票单位统计）","从k3取数","事业部、单体","每周","系统在线","财务经理、商务经理、总账会计","每月推送货代总：同比按周折线对比图",null,null,"系统无"]
[null,"我的报表","分环节统计表","从业务系统取数（添加完结筛选，表格列转行），考虑合并到合并到单票费用统计表","事业部、单体","每周","系统在线","货代总、财务经理、商务经理、总账会计","推送货代总：分环节对比图","待确认",null,"系统有","报表中心--每日报表--货代分段核算列表",7,"1、未完成，无法查询出数据，见附件。"]
[null,"我的报表","分货名单吨毛利明细表","合并到单票费用统计表","事业部、单体","每月","系统在线","货代总、财务经理、商务经理、总账会计",null,null,null,"系统有","报表中心--每日报表--分货类单吨毛利明细表",12,"1、分货类单吨毛利明细表未完成，无货名货类，等于要人为导出该表后按照业务号去匹配货名并汇总整理出数据。"]
[null,"图表","分客户单吨（单车、单船）毛利明细表","合并到单票费用统计表","事业部、单体","每月","系统在线","货代总、财务经理、商务经理、总账会计","前五大货类按货量做成饼图，每块饼前五大客户（货量）的单吨毛利在图边上列示",null,null,"系统无"]
[null,"图表","单吨毛利前十大客户（柱形图）","合并到单票费用统计表","事业部、单体","每月","系统在线","货代总、财务经理、商务经理、总账会计",null,null,null,"系统无"]
[null,"图表","收入贡献前十大客户（饼图）","合并到单票费用统计表","股份合并、事业部、单体","每月","系统在线","货代总、财务经理、商务经理、总账会计",null,null,null,"系统无"]
[null,"图表","毛利贡献前十大客户（饼图）","合并到单票费用统计表","股份合并、事业部、单体","每月","系统在线","货代总、财务经理、商务经理、总账会计",null,null,null,"系统无"]
[null,"我的报表","可用资金汇总表","财务已有，不用再做","股份合并、事业部、单体","每周","系统在线","货代总、财务经理、商务经理、总账会计",null,null,null,"系统有","报表中心--每日报表--可用资金汇总表",17,"1、未完成，搜索条件无年份、月份，统计表无经营单位；"]
[null,"我的报表","应付未回票","合并到单票费用统计表","单体","每周","系统在线","各部门经理","要求含所有部门申请未回票的统计，每周发送累计应付未回票（结算单位、工作单号、通关收货人、金额）",null,null,"系统有","报表中心--每日报表--累计应付未回票",1,"1、增加结算单位、业务号作为搜索条件，并按帐套区分；按模版增加内容"]
[null,"我的报表","关联方交易统计表","从k3取数（待明确关联方配置）","股份合并、事业部、单体","每周","系统在线","财务经理、总账会计","每月推送集团领导",null,null,"系统有","报表中心--每日报表--关联方交易统计表",15,"1、该统计表无法查询出数据。"]
[null,"我的报表","已/未达权责点已开票及已回票","从业务系统取数","事业部、单体","每月","系统在线","财务经理、总账会计","没有完结的，统计开票信息",null,null,"系统有","报表中心--每日报表--未达权责点已开票及已回票",22,"1、缺少以下查询条件：业务区域、服务类型、负责人、环节、虚拟单号、查看费用明细；\n2、表头名称错误，该表名称应是“未达权责点已开票及已回票”；\n3、增加权责点日期、会计期作为搜索条件。\n"]
[null,"我的报表","应收、预收账龄表（预收放在财务系统表）","从业务系统取数（取业务完结日期）","股份合并、事业部、单体","每月","系统在线","财务经理、商务经理、总账会计","推送货代总：前十大排名及账龄图","按会计期来查",null,"系统有","报表中心--每日报表--预收账龄表",29,"1、该表搜索条件无经营单位、会计期，搜索条件应增加按帐套区分，总预收金额一列为空；\n2、该表导出excel后单位名称显示为代码；\n3、该表数据不准确：\n3.1、例如：预收账龄表客户厦门建发能源有限公司30天以内的预收有45800元，91-120天的预收有2000000元，查询收款通知和财务系统并未见到这两笔预收款，请核实。\n3.2、又例如：预收账龄表客户招远市宝发食品有限公司30天以内的预收有160000元，查询收款通知和财务系统并未见到这两笔预收款，请核实。"]
[null,"我的报表","应付、预付账龄表（预付放在财务系统表）","从业务系统取数（取业务完结日期）","股份合并、事业部、单体","每月","系统在线","财务经理、商务经理、总账会计","推送货代总：前十大排名及账龄图","按会计期来查",null,"系统有","报表中心--每日报表--预付账龄表",35,"1、预付账款账龄表金额一列为空，搜索条件缺少经营单位、会计期，应增加按帐套区分；\n2、预付账款账龄表从系统导出excel后单位名称显示为代码；\n3、该表数据不对\n3.1、例如，预付账款账龄表上广州市锦运物流有限公司91-120天预付款10000元，实际是2018年5月11日退押金给广州市锦运物流有限公司10000元，并非预付账款。\n3.2、又例如，预付账款账龄表上湛江市源利国际货运代理有限公司31-60天预付款30000元，实际是2018年7月退押金给湛江市源利国际货运代理有限公司30000元，并非预付账款。1、应付账龄该表搜索条件无经营单位、会计期，搜索条件应增加按帐套区分，总应付金额一列为空；\n2、应付账款账龄表从系统导出excel后单位名称显示为代码；\n3、该表数据待核实，例如，广州市广海物流有限公司，30天以内应付金额为12000元，并未有收到该公司的应付发票12000元。"]
[null,"我的报表","业务员业绩统计表",null,"股份合并、事业部、单体",{"$nulls":6},"系统无"]
[null,"我的报表","协同业务明细表",null,"股份合并、事业部、单体","每月","系统在线","货代总、市场部、财务经理、总账会计",null,null,null,"系统无"]
[null,"我的报表","信控风险分析（暂未作表样）",null,"股份合并、事业部、单体",{"$nulls":6},"系统无"]
[null,"我的报表","业务完结情况表","业务取数","事业部、单体","每周","系统在线","货代总、财务经理、商务经理、总账会计"]
[null,"我的报表","月度回款统计",null,"事业部、单体","每周","系统在线","货代总、财务经理、商务经理、总账会计"]
[null,"我的报表","港口对账单统计","暂放取数逻辑核对","事业部、单体","每周","系统在线","货代总、财务经理、商务经理、总账会计、商务主管"]
[null,"我的报表","商务KPI（lfs系统数据调整）",null,null,"每周","系统在线","货代总、财务经理、商务经理、总账会计、商务部",null,null,null,"系统有",null,null,"核销完结、收款完结未控制，可任意点击完结，导致数据不真实"]
[null,"我的报表","平仓损益表（暂未作表样）",null,null,"月","系统在线","货代总、财务经理、商务经理、总账会计、商务主管"]
{"$rows_empty":1565}
[{"$nulls":7},"鲅鱼圈项目人力行政专员"]
[{"$nulls":7},"鲅鱼圈项目业务经理"]
[{"$nulls":7},"鲅鱼圈项目业务员"]
[{"$nulls":7},"鲅鱼圈项目总经理"]
[{"$nulls":7},"北海元亨副总经理"]
[{"$nulls":7},"北海元亨人力行政专员"]
[{"$nulls":7},"北海元亨商务员"]
[{"$nulls":7},"北海元亨调度员"]
[{"$nulls":7},"北海元亨外勤"]
[{"$nulls":7},"财务总监"]
[{"$nulls":7},"仓储部经理"]
[{"$nulls":7},"仓储部专员"]
[{"$nulls":7},"仓储财务经理"]
[{"$nulls":7},"仓储出纳"]
[{"$nulls":7},"仓储会计"]
[{"$nulls":7},"船代财务经理"]
[{"$nulls":7},"船代出纳"]
[{"$nulls":7},"船代会计"]
[{"$nulls":7},"船代-结算提醒"]
[{"$nulls":7},"船代事业部风控"]
[{"$nulls":7},"船代事业部副总经理"]
[{"$nulls":7},"船代事业部商务"]
[{"$nulls":7},"船代事业部市场专员"]
[{"$nulls":7},"船代事业部调度"]
[{"$nulls":7},"船代事业部外勤"]
[{"$nulls":7},"船代事业部总经理"]
[{"$nulls":7},"东北项目人力行政专员"]
[{"$nulls":7},"东北项目业务经理"]
[{"$nulls":7},"东北项目业务员"]
[{"$nulls":7},"东北项目总经理"]
[{"$nulls":7},"东莞元亨副总经理"]
[{"$nulls":7},"东莞元亨人力行政专员"]
[{"$nulls":7},"东莞元亨商务员"]
[{"$nulls":7},"东莞元亨调度员"]
[{"$nulls":7},"东莞元亨外勤"]
[{"$nulls":7},"防城港元亨副总经理"]
[{"$nulls":7},"防城港元亨人力行政专员"]
[{"$nulls":7},"防城港元亨商务员"]
[{"$nulls":7},"防城港元亨调度员"]
[{"$nulls":7},"防城港元亨外勤"]
[{"$nulls":7},"供应商管理（仓储）"]
[{"$nulls":7},"供应商管理（车队）"]
[{"$nulls":7},"供应商管理（船代）"]
[{"$nulls":7},"供应商管理（船公司）"]
[{"$nulls":7},"供应商管理（检验公司、报关报检）"]
[{"$nulls":7},"供应商管理（码头、堆场）"]
[{"$nulls":7},"供应商管理（消毒公司）"]
[{"$nulls":7},"供应商管理（运输）"]
[{"$nulls":7},"供应商结算"]
[{"$nulls":7},"股份财务经理"]
[{"$nulls":7},"股份出纳"]
[{"$nulls":7},"股份公司副总经理"]
[{"$nulls":7},"股份公司总经理"]
[{"$nulls":7},"股份会计"]
[{"$nulls":7},"股份资金经理"]
[{"$nulls":7},"广西侨益副总经理"]
[{"$nulls":7},"广西侨益人力行政专员"]
[{"$nulls":7},"广西侨益业务经理"]
[{"$nulls":7},"广西侨益业务员"]
[{"$nulls":7},"广西侨益总经理"]
[{"$nulls":7},"广西悦达人力行政专员"]
[{"$nulls":7},"广西悦达业务经理"]
[{"$nulls":7},"广西悦达业务员"]
[{"$nulls":7},"广西悦达总经理"]
[{"$nulls":7},"广州惠安茅岗仓仓管"]
[{"$nulls":7},"广州惠安茅岗仓经理"]
[{"$nulls":7},"广州惠安明珠仓仓管"]
[{"$nulls":7},"广州惠安明珠仓经理"]
[{"$nulls":7},"广州惠安南沙仓仓管"]
[{"$nulls":7},"广州惠安南沙仓经理"]
[{"$nulls":7},"广州惠安人力行政专员"]
[{"$nulls":7},"广州惠安市场部经理"]
[{"$nulls":7},"广州惠安市场部专员"]
[{"$nulls":7},"广州惠安信华仓仓管"]
[{"$nulls":7},"广州惠安信华仓经理"]
[{"$nulls":7},"广州惠安总经理"]
[{"$nulls":7},"广州惠安总经理助理"]
[{"$nulls":7},"广州侨益办单专员"]
[{"$nulls":7},"广州侨益报价员"]
[{"$nulls":7},"广州侨益操作经理"]
[{"$nulls":7},"广州侨益发卡专员"]
[{"$nulls":7},"广州侨益副总经理"]
[{"$nulls":7},"广州侨益黄埔通关内勤"]
[{"$nulls":7},"广州侨益客服经理"]
[{"$nulls":7},"广州侨益客服主管"]
[{"$nulls":7},"广州侨益控货复核"]
[{"$nulls":7},"广州侨益控货专员"]
[{"$nulls":7},"广州侨益联运经理"]
[{"$nulls":7},"广州侨益联运专员"]
[{"$nulls":7},"广州侨益南沙通关内勤"]
[{"$nulls":7},"广州侨益人力行政经理"]
[{"$nulls":7},"广州侨益人力行政专员"]
[{"$nulls":7},"广州侨益商务经理"]
[{"$nulls":7},"广州侨益商务主管"]
[{"$nulls":7},"广州侨益商务专员"]
[{"$nulls":7},"广州侨益市场经理"]
[{"$nulls":7},"广州侨益市场专员"]
[{"$nulls":7},"广州侨益通关经理"]
[{"$nulls":7},"广州侨益总经理"]
[{"$nulls":7},"广州侨益总经理助理"]
[{"$nulls":7},"广州生生驳船"]
[{"$nulls":7},"广州生生航运经理"]
[{"$nulls":7},"广州生生航运调度"]
[{"$nulls":7},"广州生生汽运经理"]
[{"$nulls":7},"广州生生汽运调度"]
[{"$nulls":7},"广州生生人力行政经理"]
[{"$nulls":7},"广州生生人力行政专员"]
[{"$nulls":7},"广州生生市场经理"]
[{"$nulls":7},"广州生生市场专员"]
[{"$nulls":7},"广州生生司机"]
[{"$nulls":7},"广州生生装卸经理"]
[{"$nulls":7},"广州生生装卸专员"]
[{"$nulls":7},"广州生生总经理"]
[{"$nulls":7},"广州元亨船务部经理"]
[{"$nulls":7},"广州元亨副总经理"]
[{"$nulls":7},"广州元亨人力行政专员"]
[{"$nulls":7},"广州元亨商务经理"]
[{"$nulls":7},"广州元亨商务员"]
[{"$nulls":7},"广州元亨市场经理"]
[{"$nulls":7},"广州元亨市场专员"]
[{"$nulls":7},"广州元亨调度经理"]
[{"$nulls":7},"广州元亨调度员"]
[{"$nulls":7},"广州元亨外勤"]
[{"$nulls":7},"广州元亨外勤经理"]
[{"$nulls":7},"广州元亨总经理"]
[{"$nulls":7},"广州悦达人力行政专员"]
[{"$nulls":7},"广州悦达业务经理"]
[{"$nulls":7},"广州悦达业务员"]
[{"$nulls":7},"广州悦达总经理"]
[{"$nulls":7},"黄埔报关报检员"]
[{"$nulls":7},"黄埔通关外勤"]
[{"$nulls":7},"黄埔主管"]
[{"$nulls":7},"货代财务经理"]
[{"$nulls":7},"货代出纳"]
[{"$nulls":7},"货代会计"]
[{"$nulls":7},"货代事业部客服专员"]
[{"$nulls":7},"货代事业部商务专员"]
[{"$nulls":7},"货代事业部市场专员"]
[{"$nulls":7},"货代事业部通关专员"]
[{"$nulls":7},"货代事业部总经理"]
[{"$nulls":7},"货代物料管理专员"]
[{"$nulls":7},"检验鉴定员"]
[{"$nulls":7},"客服1组"]
[{"$nulls":7},"客服2组"]
[{"$nulls":7},"客服3组"]
[{"$nulls":7},"客服4组"]
[{"$nulls":7},"客服5组"]
[{"$nulls":7},"客户资料审核人"]
[{"$nulls":7},"老港报关供应商"]
[{"$nulls":7},"老港操作外勤"]
[{"$nulls":7},"南沙报关报检员"]
[{"$nulls":7},"南沙操作外勤"]
[{"$nulls":7},"南沙通关外勤"]
[{"$nulls":7},"南沙主管"]
[{"$nulls":7},"南通侨益副总经理"]
[{"$nulls":7},"南通侨益人力行政专员"]
[{"$nulls":7},"南通侨益业务经理"]
[{"$nulls":7},"南通侨益业务员"]
[{"$nulls":7},"南通侨益总经理"]
[{"$nulls":7},"南通元亨副总经理"]
[{"$nulls":7},"南通元亨人力行政专员"]
[{"$nulls":7},"南通元亨商务员"]
[{"$nulls":7},"南通元亨调度员"]
[{"$nulls":7},"南通元亨外勤"]
[{"$nulls":7},"南通元亨总经理"]
[{"$nulls":7},"内部审计"]
[{"$nulls":7},"企发经理"]
[{"$nulls":7},"企发专员"]
[{"$nulls":7},"企发总监"]
[{"$nulls":7},"钦州元亨副总经理"]
[{"$nulls":7},"钦州元亨人力行政专员"]
[{"$nulls":7},"钦州元亨商务员"]
[{"$nulls":7},"钦州元亨调度员"]
[{"$nulls":7},"钦州元亨外勤"]
[{"$nulls":7},"人力行政经理"]
[{"$nulls":7},"人力行政专员"]
[{"$nulls":7},"人力行政总监"]
[{"$nulls":7},"厦门鑫侨益报关报检员"]
[{"$nulls":7},"厦门鑫侨益操作经理"]
[{"$nulls":7},"厦门鑫侨益操作专员"]
[{"$nulls":7},"厦门鑫侨益客服专员"]
[{"$nulls":7},"厦门鑫侨益人力行政专员"]
[{"$nulls":7},"厦门鑫侨益业务经理"]
[{"$nulls":7},"厦门鑫侨益总经理"]
[{"$nulls":7},"深圳元亨船务经理"]
[{"$nulls":7},"深圳元亨单证经理"]
[{"$nulls":7},"深圳元亨单证员"]
[{"$nulls":7},"深圳元亨外勤"]
[{"$nulls":7},"深圳元亨总经理"]
[{"$nulls":7},"生生西江业务经理"]
[{"$nulls":7},"生生西江业务员"]
[{"$nulls":7},"市场专员"]
[{"$nulls":7},"市场总监"]
[{"$nulls":7},"市场总监助理"]
[{"$nulls":7},"新港报关供应商"]
[{"$nulls":7},"新港操作外勤"]
[{"$nulls":7},"新沙报关报检员"]
[{"$nulls":7},"新沙通关外勤"]
[{"$nulls":7},"新沙主管"]
[{"$nulls":7},"元亨国际副总经理"]
[{"$nulls":7},"元亨国际人力行政专员"]
[{"$nulls":7},"元亨国际业务员"]
[{"$nulls":7},"岳阳侨益人力行政专员"]
[{"$nulls":7},"岳阳侨益业务经理"]
[{"$nulls":7},"岳阳侨益业务员"]
[{"$nulls":7},"岳阳侨益总经理"]
[{"$nulls":7},"运输财务经理"]
[{"$nulls":7},"运输出纳"]
[{"$nulls":7},"运输会计"]
[{"$nulls":7},"湛江元亨副总经理"]
[{"$nulls":7},"湛江元亨人力行政专员"]
[{"$nulls":7},"湛江元亨商务员"]
[{"$nulls":7},"湛江元亨调度员"]
[{"$nulls":7},"湛江元亨外勤"]
[{"$nulls":7},"重庆侨益人力行政专员"]
[{"$nulls":7},"重庆侨益业务经理"]
[{"$nulls":7},"重庆侨益业务员"]
[{"$nulls":7},"重庆侨益总经理"]
[{"$nulls":7},"珠海侨益副总经理"]
[{"$nulls":7},"珠海侨益人力行政专员"]
[{"$nulls":7},"珠海侨益业务员"]
[{"$nulls":7},"珠海元亨副总经理"]
[{"$nulls":7},"珠海元亨人力行政专员"]
[{"$nulls":7},"珠海元亨商务员"]
[{"$nulls":7},"珠海元亨调度员"]
[{"$nulls":7},"珠海元亨外勤"]

{"sheet":"单票利润滚动表","index":1,"n_rows":27,"n_cols":26,"rows_kept":27,"cut":false,"hidden":false,"merged":[[5,14,5,16],[5,17,5,19],[5,23,5,25],[5,0,6,0],[5,1,6,1],[5,2,6,2],[5,3,6,3],[5,4,6,4],[5,5,6,5],[5,6,6,6],[5,7,6,7],[2,8,3,8],[5,8,6,8],[2,9,3,9],[5,9,6,9],[2,10,3,10],[5,10,6,10],[2,11,3,11],[5,11,6,11],[2,12,3,12],[5,12,6,12],[5,13,6,13],[2,14,3,14],[0,7,1,16]]}
[]
[]
[{"$nulls":7},"查询期间"]
[]
[null,"统计条件：以权责点日期"]
["当前进度","状态","工作单号","经营单位","结算单位","船名","货名","货量","柜型柜量","ATA卸货码头","建单时间","流向完结时间","清货完结时间","权责点","1月",null,null,"2月",null,null,null,"。。。",null,"合计"]
[{"$nulls":14},"收入","成本","利润","收入","成本","利润","应收","成本","利润","收入","成本","利润"]
["商检申报","确认","QYIC18030131F01","广州俊泰饲料有限公司",null,""]
["待确认","新建","QYIC18030145F01","凯配贸易（上海）有限公司",null,""]
["接收委托","确认","QYIC18030147F01","东莞嘉吉粮油有限公司",null,""]
["ETA中转港","确认","QYIC18030135F01","浙江省粮食集团有限公司",null,""]
["接收委托","确认","QYIC18030155F01","厦门建发原材料贸易有限公司",null,""]
["待确认","新建","QYIB18030027F01","托福国际贸易（上海）有限公司",null,""]
["ETA中转港","确认","QYIC18030134F01","宁波晶海工贸有限公司",null,""]
["ETA中转港","确认","QYIC18030142F01","厦门建发原材料贸易有限公司",null,""]
["ETA中转港","确认","QYIC18030136F01","宁波晶海工贸有限公司",null,""]
["ETA中转港","确认","QYIC18030137F01","宁波晶海工贸有限公司",null,""]
["ETA中转港","确认","QYIC18030138F01","宁波晶海工贸有限公司",null,""]
["ETA中转港","确认","QYIC18030140F01","厦门建发原材料贸易有限公司",null,""]
["ETA中转港","确认","QYIC18030141F01","广东恒兴饲料实业股份有限公司",null,""]
["待确认","新建","QYIB18030028F01","中粮四海丰（张家港）贸易有限公司",null,""]
["ETA中转港","确认","ZJIC18030001F01","北大荒粮食集团广州仁亿贸易有限公司",null,""]
["接收委托","确认","QYIC18030146F01","东莞嘉吉粮油有限公司",null,""]
["ETA中转港","确认","QYIC18030143F01","厦门建发原材料贸易有限公司",null,""]
["ETA中转港","确认","QYIC18030133F01","宁波晶海工贸有限公司",null,""]
["ETA中转港","确认","QYIC18030139F01","宁波晶海工贸有限公司",null,""]
["ETA中转港","确认","QYIC18030148F01","天津建源供应链管理有限公司",null,""]

{"sheet":"单票毛利异常表","index":2,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[]
["主要为毛利为负及单吨毛利高于平均毛利的  %，待与商务及分管领导进一步定义标准"]

{"sheet":"未达权责点已开票及已回票","index":3,"n_rows":42,"n_cols":11,"rows_kept":42,"cut":false,"hidden":false,"merged":[[0,7,1,10]]}
[]
[]
[]
[]
["当前进度","状态","工作单号","经营单位","结算单位","船名","货名","货量","币别","已开发票","已回发票"]
["商检申报","确认","QYIC18030131F01","广州俊泰饲料有限公司",null,"",null,null,"人民币",62257.55,62257.55]
["待确认","新建","QYIC18030145F01","凯配贸易（上海）有限公司",null,"",null,null,"人民币",7874.59,7391.6]
["接收委托","确认","QYIC18030147F01","东莞嘉吉粮油有限公司",null,"",null,null,"人民币",1855,2056]
["ETA中转港","确认","QYIC18030135F01","浙江省粮食集团有限公司",null,"",null,null,"人民币",13572,9211]
["接收委托","确认","QYIC18030155F01","厦门建发原材料贸易有限公司",null,"",null,null,"人民币",74298.32,72789.41]
["待确认","新建","QYIB18030027F01","托福国际贸易（上海）有限公司",null,"",null,null,"人民币",4382660.36,4382650]
["ETA中转港","确认","QYIC18030134F01","宁波晶海工贸有限公司",null,"",null,null,"人民币",5382.71,5100.24]
["ETA中转港","确认","QYIC18030142F01","厦门建发原材料贸易有限公司",null,"",null,null,"人民币",74302.98,72789.41]
["ETA中转港","确认","QYIC18030136F01","宁波晶海工贸有限公司",null,"",null,null,"人民币",6252.11,5985.24]
["ETA中转港","确认","QYIC18030137F01","宁波晶海工贸有限公司",null,"",null,null,"人民币",5382.71,5100.24]
["ETA中转港","确认","QYIC18030138F01","宁波晶海工贸有限公司",null,"",null,null,"人民币",5382.71,5100.24]
["ETA中转港","确认","QYIC18030140F01","厦门建发原材料贸易有限公司",null,"",null,null,"人民币",74298.32,72789.41]
["ETA中转港","确认","QYIC18030141F01","广东恒兴饲料实业股份有限公司",null,"",null,null,"人民币",49171.07,49157]
["待确认","新建","QYIB18030028F01","中粮四海丰（张家港）贸易有限公司",null,"",null,null,"人民币",0,0]
["ETA中转港","确认","ZJIC18030001F01","北大荒粮食集团广州仁亿贸易有限公司",null,"",null,null,"人民币",19771.59,19757.6]
["接收委托","确认","QYIC18030146F01","东莞嘉吉粮油有限公司",null,"",null,null,"人民币",1250,2281]
["ETA中转港","确认","QYIC18030143F01","厦门建发原材料贸易有限公司",null,"",null,null,"人民币",74298.32,72789.41]
["ETA中转港","确认","QYIC18030133F01","宁波晶海工贸有限公司",null,"",null,null,"人民币",5382.71,5100.24]
["ETA中转港","确认","QYIC18030139F01","宁波晶海工贸有限公司",null,"",null,null,"人民币",5382.71,5100.24]
["ETA中转港","确认","QYIC18030148F01","天津建源供应链管理有限公司",null,"",null,null,"人民币",49154.2,48900.24]
[]
["1、缺少以下查询条件：业务区域、服务类型、负责人、环节、虚拟单号、查看费用明细；"]
{"$rows_empty":14}
["2、表头名称错误，该表名称应是“未达权责点已开票及已回票”。"]

{"sheet":"已达权责点未开票及未回票","index":4,"n_rows":27,"n_cols":11,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,7,1,10]]}
[]
[]
[]
[]
["当前进度","状态","工作单号","经营单位","结算单位","船名","货名","货量","币别","未开发票","未回发票"]
["商检申报","确认","QYIC18030131F01","广州俊泰饲料有限公司",null,"",null,null,"人民币",62257.55,62257.55]
["待确认","新建","QYIC18030145F01","凯配贸易（上海）有限公司",null,"",null,null,"人民币",7874.59,7391.6]
["接收委托","确认","QYIC18030147F01","东莞嘉吉粮油有限公司",null,"",null,null,"人民币",1855,2056]
["ETA中转港","确认","QYIC18030135F01","浙江省粮食集团有限公司",null,"",null,null,"人民币",13572,9211]
["接收委托","确认","QYIC18030155F01","厦门建发原材料贸易有限公司",null,"",null,null,"人民币",74298.32,72789.41]
["待确认","新建","QYIB18030027F01","托福国际贸易（上海）有限公司",null,"",null,null,"人民币",4382660.36,4382650]
["ETA中转港","确认","QYIC18030134F01","宁波晶海工贸有限公司",null,"",null,null,"人民币",5382.71,5100.24]
["ETA中转港","确认","QYIC18030142F01","厦门建发原材料贸易有限公司",null,"",null,null,"人民币",74302.98,72789.41]
["ETA中转港","确认","QYIC18030136F01","宁波晶海工贸有限公司",null,"",null,null,"人民币",6252.11,5985.24]
["ETA中转港","确认","QYIC18030137F01","宁波晶海工贸有限公司",null,"",null,null,"人民币",5382.71,5100.24]
["ETA中转港","确认","QYIC18030138F01","宁波晶海工贸有限公司",null,"",null,null,"人民币",5382.71,5100.24]
["ETA中转港","确认","QYIC18030140F01","厦门建发原材料贸易有限公司",null,"",null,null,"人民币",74298.32,72789.41]
["ETA中转港","确认","QYIC18030141F01","广东恒兴饲料实业股份有限公司",null,"",null,null,"人民币",49171.07,49157]
["待确认","新建","QYIB18030028F01","中粮四海丰（张家港）贸易有限公司",null,"",null,null,"人民币",0,0]
["ETA中转港","确认","ZJIC18030001F01","北大荒粮食集团广州仁亿贸易有限公司",null,"",null,null,"人民币",19771.59,19757.6]
["接收委托","确认","QYIC18030146F01","东莞嘉吉粮油有限公司",null,"",null,null,"人民币",1250,2281]
["ETA中转港","确认","QYIC18030143F01","厦门建发原材料贸易有限公司",null,"",null,null,"人民币",74298.32,72789.41]
["ETA中转港","确认","QYIC18030133F01","宁波晶海工贸有限公司",null,"",null,null,"人民币",5382.71,5100.24]
["ETA中转港","确认","QYIC18030139F01","宁波晶海工贸有限公司",null,"",null,null,"人民币",5382.71,5100.24]
["ETA中转港","确认","QYIC18030148F01","天津建源供应链管理有限公司",null,"",null,null,"人民币",49154.2,48900.24]
[]
["1、缺少以下查询条件：业务区域、服务类型、负责人、环节、虚拟单号、查看费用明细；"]

{"sheet":"预收账款未拆分统计表","index":5,"n_rows":54,"n_cols":29,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
["&#160;","财务No.","账套号","收款日期","会计期","收款编号","结算对象","金额","已核销金额","退款金额","押金种类","押金类型","币种","汇率","部门","是否预收","结算方式","凭证号","是否入账","上传财务","银行手续费","我方账户","我方银行","创建人","创建时间","对方账号","对方银行","文件名","操作"]
[null,77929,"(111)广州元亨国际船务代理有限公司","2018-03-01","2018-3","R0000005936","0045NGT3JOW0H",9991,{"$nulls":4},"人民币",1,"船代部门","否","电汇",null,1,"1",null,"3602014619200126230","工行广州金港支行","CL0200288","2018-03-02T09:43:09",null,null,"rmb9991.png"]
[null,77933,"(111)广州元亨国际船务代理有限公司","2018-03-01","2018-3","R0000005940","D41D5F23B0BB4313B2572E8E252FCAA6",1200,{"$nulls":4},"人民币",1,"船代部门","否","电汇",null,1,"1",null,"730257737921","中行黄埔支行","CL0200288","2018-03-02T09:53:38",null,null,"RMB1200.png"]
[null,78026,"(101)侨益物流股份有限公司","2018-03-02","2018-3","R0000005949","3E869911B0694F858D3F7C34AE670D3E",1000,{"$nulls":4},"人民币",1,"货运代理","否","现金",null,0,"0",null,"82210158700000562","浦发银行广州金穗支行-保证金户","admin","2018-03-02T11:03:15"]
[null,79753,"(101)侨益物流股份有限公司","2018-03-02","2018-3","R0000006049","42D8A172202142C6B8ACC371C00B4E1E",11165.56,11165.56,null,null,null,"人民币",1,"货运代理","否","电汇","3",1,"1",null,"3602014619200064936","工行广州金港支行","CL0200356","2018-03-05T18:11:29"]
[null,79865,"(101)侨益物流股份有限公司","2018-03-02","2018-3","R0000006069","DD99F199188441D1AFE93012711F06EC",6000,null,6000,"预收车队押金","长押","人民币",1,"货运代理","是","电汇","30",1,"1",null,"3602014619200064936","工行广州金港支行","CL0200356","2018-03-06T09:19:32"]
[null,79866,"(101)侨益物流股份有限公司","2018-03-05","2018-3","R0000006070","3C67F7379F8241C4A933E7DF626218AB",276594,{"$nulls":4},"人民币",1,"货运代理","否","电汇","2",1,"1",null,"3602014619200064936","工行广州金港支行","CL0200356","2018-03-06T09:20:12"]
[null,80255,"(101)侨益物流股份有限公司","2018-03-05","2018-3","R0000006071","3492265BE8C446BB94A63DE4E80DCA8D",89909.3,89909.3,null,null,null,"人民币",1,"货运代理","否","电汇","4",1,"1",null,"3602014619200064936","工行广州金港支行","CL0200356","2018-03-06T10:21:14"]
[null,80257,"(101)侨益物流股份有限公司","2018-03-05","2018-3","R0000006072","00449KJ3KH85J",21570,21570,null,null,null,"人民币",1,"货运代理","否","电汇","5",1,"1",null,"3602014619200064936","工行广州金港支行","CL0200356","2018-03-06T10:21:53"]
[null,80713,"(101)侨益物流股份有限公司","2018-03-05","2018-3","R0000006149","0043X2UGEKHCJ",372114.37,372114.37,null,null,null,"人民币",1,"货运代理","否","电汇","6",1,"1",null,"3602014619200064936","工行广州金港支行","CL0200356","2018-03-06T16:10:12"]
[null,81942,"(101)侨益物流股份有限公司","2018-03-06","2018-3","R0000006199","008BE9A234C048B2BF6E8B27727E30EB",102000,null,102000,null,null,"人民币",1,"货运代理","否","电汇","8",1,"1",null,"3602014619200064936","工行广州金港支行","CL0200356","2018-03-07T11:11:24"]
[null,81943,"(101)侨益物流股份有限公司","2018-03-06","2018-3","R0000006200","170C76CD4D114DA5801E0B952FFEF434",92586.25,92586.25,null,null,null,"人民币",1,"货运代理","否","电汇","9",1,"1",null,"3602014619200064936","工行广州金港支行","CL0200356","2018-03-07T11:11:56"]
[null,82101,"(101)侨益物流股份有限公司","2018-03-06","2018-3","R0000006209","44460EBEF0394031B5049C344225B26A",9979.74,9979.74,null,null,null,"人民币",1,"货运代理","否","电汇","7",1,"1",null,"3602014619200064936","工行广州金港支行","CL0200356","2018-03-07T14:17:35"]
[null,82102,"(101)侨益物流股份有限公司","2018-03-06","2018-3","R0000006210","D51B71FB175D4A779AE2FA5DE0EC1B32",30676.96,30676.96,null,null,null,"人民币",1,"货运代理","否","电汇","10",1,"1",null,"3602014619200064936","工行广州金港支行","CL0200356","2018-03-07T14:18:14"]
[null,83037,"(101)侨益物流股份有限公司","2018-03-07","2018-3","R0000006289","9E76933BF6984A2DADA39C6A4A78F9C3",102242.82,102242.82,null,null,null,"人民币",1,"货运代理","否","电汇","11",1,"1",null,"3602014619200064936","工行广州金港支行","CL0200356","2018-03-08T14:19:44"]
[null,83038,"(101)侨益物流股份有限公司","2018-03-07","2018-3","R0000006290","52771F2395FD41C9A25C3379561A688A",4919.4,4919.4,null,null,null,"人民币",1,"货运代理","否","电汇","12",1,"1",null,"3602014619200064936","工行广州金港支行","CL0200356","2018-03-08T14:20:24"]
[null,83571,"(101)侨益物流股份有限公司","2018-03-08","2018-3","R0000006349","3C67F7379F8241C4A933E7DF626218AB",347903.45,{"$nulls":4},"人民币",1,"货运代理","否","电汇","13",1,"1",null,"3602014619200064936","工行广州金港支行","CL0200356","2018-03-09T09:00:37"]
[null,83572,"(101)侨益物流股份有限公司","2018-03-08","2018-3","R0000006350","2C60E6930B174FB2B415D88B9B89A6BF",44044.56,44044.56,null,null,null,"人民币",1,"货运代理","否","电汇","14",1,"1",null,"3602014619200064936","工行广州金港支行","CL0200356","2018-03-09T09:01:09"]
[null,83573,"(101)侨益物流股份有限公司","2018-03-08","2018-3","R0000006351","CB3C0CA8FD3F467ABD57B5EEA02BB86D",21008,21008,null,null,null,"人民币",1,"货运代理","否","电汇","15",1,"1",null,"3602014619200064936","工行广州金港支行","CL0200356","2018-03-09T09:01:49"]
[null,84216,"(101)侨益物流股份有限公司","2018-03-08","2018-3","R0000006389","14AA2959FFAD48CEBBBAD26DD746CD09",49420,49420,null,null,null,"人民币",1,"货运代理","否","电汇","16",1,"1",null,"3602014619200064936","工行广州金港支行","CL0200356","2018-03-09T14:20:13"]
[null,85573,"(101)侨益物流股份有限公司","2018-03-09","2018-3","R0000006509","CFF0C6CA1DD647209183FD16ADC00992",5247,5247,null,null,null,"人民币",1,"货运代理","否","电汇","17",1,"1",null,"3602014619200064936","工行广州金港支行","CL0200356","2018-03-12T15:45:50"]
[null,85574,"(101)侨益物流股份有限公司","2018-03-09","2018-3","R0000006510","0044SF93RO5CO",1611.91,1611.91,null,null,null,"人民币",1,"货运代理","否","电汇","18",1,"1",null,"3602014619200064936","工行广州金港支行","CL0200356","2018-03-12T15:46:25"]
[null,87605,"(101)侨益物流股份有限公司","2018-03-05","2018-3","R0000006709","5E7E200903D04D9E9473AFC0834C77F0",22560,null,22560,null,null,"人民币",1,"货运代理","否","电汇","21",1,"1",null,"3602014619200064936","工行广州金港支行","CL0200356","2018-03-14T16:08:36"]
[null,87606,"(101)侨益物流股份有限公司","2018-03-05","2018-3","R0000006710","5E7E200903D04D9E9473AFC0834C77F0",36240,null,36240,null,null,"人民币",1,"货运代理","否","电汇","22",1,"1",null,"3602014619200064936","工行广州金港支行","CL0200356","2018-03-14T16:09:07"]
[null,87609,"(101)侨益物流股份有限公司","2018-03-05","2018-3","R0000006711","5E7E200903D04D9E9473AFC0834C77F0",32640,null,32640,null,null,"人民币",1,"货运代理","否","电汇","23",1,"1",null,"3602014619200064936","工行广州金港支行","CL0200356","2018-03-14T16:09:55"]
[null,87812,"(101)侨益物流股份有限公司","2018-03-05","2018-3","R0000006729","5E7E200903D04D9E9473AFC0834C77F0",3600,null,3600,null,null,"人民币",1,"货运代理","否","电汇","24",1,"1",null,"696457738064","中行广州港湾路支行","CL0200356","2018-03-14T17:59:11"]
[null,92070,"(101)侨益物流股份有限公司","2018-03-07","2018-3","R0000007069","721C9EA245FC4B21815671CBD8826CE0",105409.94,{"$nulls":4},"人民币",1,"货运代理","否","电汇","29",1,"1",null,"3602014619200064936","工行广州金港支行","CL0200356","2018-03-20T15:10:14"]
[null,100860,"(111)广州元亨国际船务代理有限公司","2018-03-02","2018-3","R0000007770","2CA9C42D5546417CB23EF0550D34AD9C",200,{"$nulls":4},"人民币",1,"船代部门","否","电汇",null,1,"1",null,"730257737921","中行黄埔支行","CL0200288","2018-03-29T11:32:30",null,null,"RMB200.jpg"]
[null,100869,"(111)广州元亨国际船务代理有限公司","2018-03-05","2018-3","R0000007771","0045811FRYJXG",29500,{"$nulls":4},"人民币",1,"船代部门","否","电汇",null,1,"1",null,"730257737921","中行黄埔支行","CL0200288","2018-03-29T11:37:22",null,null,"RMB29500.jpg"]
[null,100874,"(111)广州元亨国际船务代理有限公司","2018-03-02","2018-3","R0000007772","0045TOGXJH1EN",5872,{"$nulls":4},"人民币",1,"船代部门","否","电汇",null,1,"1",null,"730257737921","中行黄埔支行","CL0200288","2018-03-29T11:43:34",null,null,"RMB5872.jpg"]
[null,100875,"(111)广州元亨国际船务代理有限公司","2018-03-06","2018-3","R0000007773","0045C0NFM14KI",40666.6,{"$nulls":4},"人民币",1,"船代部门","否","电汇",null,1,"1",null,"730257737921","中行黄埔支行","CL0200288","2018-03-29T11:46:10",null,null,"RMB40666.6.jpg"]
[null,100876,"(111)广州元亨国际船务代理有限公司","2018-03-06","2018-3","R0000007774","3A6EC7C4A54F4B02AC777C43BF754858",500000,{"$nulls":4},"人民币",1,"船代部门","否","电汇",null,1,"1",null,"730257737921","中行黄埔支行","CL0200288","2018-03-29T11:50:06",null,null,"RMB500000.jpg"]
[null,100877,"(111)广州元亨国际船务代理有限公司","2018-03-08","2018-3","R0000007775","0045C0NFM14KI",95745.2,{"$nulls":4},"人民币",1,"船代部门","否","电汇",null,1,"1",null,"730257737921","中行黄埔支行","CL0200288","2018-03-29T11:50:53",null,null,"USD95745.2.jpg"]
[null,100878,"(111)广州元亨国际船务代理有限公司","2018-03-08","2018-3","R0000007776","2CA9C42D5546417CB23EF0550D34AD9C",200,{"$nulls":4},"人民币",1,"船代部门","否","电汇",null,1,"1",null,"730257737921","中行黄埔支行","CL0200288","2018-03-29T11:51:55",null,null,"3-9RMB200.jpg"]
[null,100879,"(111)广州元亨国际船务代理有限公司","2018-03-08","2018-3","R0000007777","40376F417D67485AACE57C1434C539A6",310000,{"$nulls":4},"人民币",1,"船代部门","否","电汇",null,1,"1",null,"730257737921","中行黄埔支行","CL0200288","2018-03-29T11:52:43",null,null,"USD310000.jpg"]
[null,100880,"(111)广州元亨国际船务代理有限公司","2018-03-09","2018-3","R0000007778","40376F417D67485AACE57C1434C539A6",90000,{"$nulls":4},"人民币",1,"船代部门","否","电汇",null,1,"1",null,"730257737921","中行黄埔支行","CL0200288","2018-03-29T11:54:28",null,null,"RMB90000.jpg"]
[null,100997,"(111)广州元亨国际船务代理有限公司","2018-03-01","2018-3","R0000007796","481AE1BF6ABC45DFB33E1987A915D44C",299984,{"$nulls":4},"人民币",1,"船代部门","否","电汇",null,1,"1",null,"3602014619200126230","工行广州金港支行","CL0200288","2018-03-29T14:52:58",null,null,"RMB299984.jpg"]
[null,100999,"(111)广州元亨国际船务代理有限公司","2018-03-02","2018-3","R0000007797","A7B5CF227AC14E879A3036A11E383F42",231000,{"$nulls":4},"人民币",1,"船代部门","否","电汇",null,1,"1",null,"3602014619200126230","工行广州金港支行","CL0200288","2018-03-29T14:54:02",null,null,"RMB231000.jpg"]
[null,101016,"(111)广州元亨国际船务代理有限公司","2018-03-05","2018-3","R0000007810","81A368F724594A0AA855D1D9DC8450E6",5327.66,{"$nulls":4},"美元",6.3291,"船代部门","否","电汇",null,1,"1",null,"3602014609200083914","工行广州金港支行","CL0200288","2018-03-29T15:16:07",null,null,"USD5327.66.jpg"]
[null,101017,"(111)广州元亨国际船务代理有限公司","2018-03-08","2018-3","R0000007811","C620A6E8D4364509887E33EA03BEF9DC",12057,{"$nulls":4},"美元",6.3171,"船代部门","否","电汇",null,1,"1",null,"3602014609200083914","工行广州金港支行","CL0200288","2018-03-29T15:17:45",null,null,"USD12057.jpg"]
[null,101478,"(101)侨益物流股份有限公司","2018-03-06","2018-3","R0000007852","A39D0A991B0446FBB7E60692B516C70D",22140.88,{"$nulls":4},"人民币",1,"货运代理","否","电汇","114",1,"1",null,"3602014619200064936","工行广州金港支行","CL0200356","2018-03-30T11:39:15"]
[null,101563,"(111)广州元亨国际船务代理有限公司","2018-03-01","2018-3","R0000007869","0045TOGXJHZX3",365,{"$nulls":4},"美元",6.3346,"船代部门","否","电汇",null,1,"1",null,"3602014609200083914","工行广州金港支行","CL0200288","2018-03-30T14:25:21",null,null,"365.png"]
[null,101566,"(111)广州元亨国际船务代理有限公司","2018-03-05","2018-3","R0000007870","0045TOGXJI08X",7038.85,{"$nulls":4},"美元",6.3291,"船代部门","否","电汇",null,1,"1",null,"3602014609200083914","工行广州金港支行","CL0200288","2018-03-30T14:30:36",null,null,"USD7038.85.jpg"]
[null,101567,"(111)广州元亨国际船务代理有限公司","2018-03-08","2018-3","R0000007871","0045TOGXJI0BN",12604,{"$nulls":4},"美元",6.3171,"船代部门","否","电汇",null,1,"1",null,"3602014609200083914","工行广州金港支行","CL0200288","2018-03-30T14:33:16",null,null,"USD12604.jpg"]
[null,101574,"(111)广州元亨国际船务代理有限公司","2018-03-08","2018-3","R0000007873","0045TOGXJI0D5",8150,{"$nulls":4},"美元",6.3111,"船代部门","否","电汇",null,1,"1",null,"3602014609200083914","工行广州金港支行","CL0200288","2018-03-30T14:38:05",null,null,"8150.jpg"]
[null,101584,"(111)广州元亨国际船务代理有限公司","2018-03-09","2018-3","R0000007883","00458NHRISCHD",142401.96,{"$nulls":4},"人民币",1,"船代部门","否","电汇",null,1,"1",null,"730257737921","中行黄埔支行","CL0200288","2018-03-30T14:54:53",null,null,"RMB142401.96.jpg"]
[]
[]
["1、该表导出后结算对象均是代码，未显示名称；"]

{"sheet":"应付未回发票","index":6,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["1、按账套区分。"]
["2、搜索条件：按账套号、业务号、通关收货人、结算单位。"]
["3、可按Excel表格形式导出数据。"]
[]
[]
["账套号","工作单号","通关收货人","结算单位","应付合计","未回票金额","已付款已回票","未付款已回票","已付款未回票","未付款未回票"]
["(101)侨益物流股份有限公司","QYIB18010003S01","上海鹏华船务有限公司","广州港引航站",null,31278.06]
["(101)侨益物流股份有限公司","QYIC18010028F01","托福国际贸易（上海）有限公司","广州惠安仓储装卸有限公司",null,2905.7]
["(101)侨益物流股份有限公司","QYIC18010061F01","宁波晶海工贸有限公司","广州惠安仓储装卸有限公司",null,1500]
["(101)侨益物流股份有限公司","QYD18010001TH01","厦门建发原材料贸易有限公司","广州惠安仓储装卸有限公司",null,84.95]
["(101)侨益物流股份有限公司","QYIC18010075F01","上海绿地能源集团实业发展有限公司","广州市生生物流有限公司",null,4700]
["(101)侨益物流股份有限公司","QYIC18010103F01","中国国投国际贸易有限公司","广州市生生物流有限公司",null,14370]
["(101)侨益物流股份有限公司","QYIC18010128F01","宁波晶海工贸有限公司","广州市生生物流有限公司",null,7990]
["合计",null,null,null,{"$f":"SUM(E7:E13)","v":0},62828.71,0,0,0,0]

{"sheet":"单票费用统计表","index":7,"n_rows":30,"n_cols":43,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,7,1,10]]}
[{"$nulls":7},"LFS系统的费用统计表中已有，增加绿色区域并维护数据即可。"]
[]
[]
[]
["1、搜索条件：除上面截图外，增加以下搜索条件：时间（按起止时间，包含以下时间类型：ATA卸货码头时间、流向完结时间、清货完结时间、业务完结时间、权责点时间）、账套、业务类型；"]
["2、统计口径：要求含货代事业部及单家公司所有业务类型的单票费用统计。"]
["3、可按Excel表格形式导出数据。"]
[]
["当前进度","状态","账套号","业务类型","工作单号","经营单位","船名","货名","货量（a）","ATA卸货码头","币别","报价应收（b）","报价成本（c）","报价利润（d=a-b）","预估单吨利润（e=d/a）","应收费用（f）","应付费用（g）","毛利（h）","单吨利润（i=h/a）","应收差异（j=b-f）","应付差异（k=c-g）","毛利差异（l=d-h）","单吨利润差异（m=e-i）","应收未确认（n=f-o）","应收已确认（o）","应收未对账(p=f-q)","应收已对账(q)","应收未开票(r=f-s)","应收已开票(s)","应收未核销(t=f-u)","应收已核销(u)","应付未确认(v=g-w)","应付已确认(w)","应付未对账(x=g-y)","应付已对账(y)","应付未开票(z=g-aa)","应付已开票(aa)","应付未核销(ab=g-ac)","应付已核销(ac)","流向完结时间","清货完结时间","业务完结时间","权责点"]
["商检申报","确认","(101)侨益物流股份有限公司","进口集装箱","QYIC18030131F01","广州俊泰饲料有限公司","",null,484.1,"2018-03-30","人民币",62257.55,62257.55,{"$f":"L10-M10","v":0},null,null,21405,{"$f":"P10-Q10","v":-21405},null,{"$f":"L10-P10","v":62257.55},{"$f":"M10-Q10","v":40852.55},{"$f":"N10-R10","v":21405},null,null,0,0,0,0,0,0,0,0,21405,0,21405,0,0,-21405]
["待确认","新建","(101)侨益物流股份有限公司","进口集装箱","QYIC18030145F01","凯配贸易（上海）有限公司","",null,19.386,"2018-05-01","人民币",7874.59,7391.6,{"$f":"L11-M11","v":482.99},null,null,null,{"$f":"P11-Q11","v":0},null,{"$f":"L11-P11","v":7874.59},7391.6,482.99,null,null,0,0,null,0,null,0,null,null,0,0,null,0,0,0]
["接收委托","确认","(101)侨益物流股份有限公司","进口集装箱","QYIC18030147F01","东莞嘉吉粮油有限公司","",null,202.89,"2018-04-01","人民币",1855,2056,-201,null,4500,null,4500,null,{"$f":"L12-P12","v":-2645},2056,-4701,null,4500,0,4500,null,0,null,0,null,null,0,4500,null,0,0,0]
["ETA中转港","确认","(101)侨益物流股份有限公司","进口集装箱","QYIC18030135F01","浙江省粮食集团有限公司","",null,1002.6,"2018-04-12","人民币",13572,9211,4361,null,null,null,0,null,13572,9211,4361,null,null,0,0,null,0,null,0,null,null,0,0,null,0,0,0]
["接收委托","确认","(101)侨益物流股份有限公司","进口集装箱","QYIC18030155F01","厦门建发原材料贸易有限公司","",null,25.927,"2018-04-04","人民币",74298.32,72789.41,1508.91,null,881.52,null,881.52,null,73416.8,72789.41,627.390000000004,null,881.52,0,881.52,null,0,null,0,null,null,0,881.52,null,0,0,0]
["待确认","新建","(101)侨益物流股份有限公司","进口散船","QYIB18030027F01","托福国际贸易（上海）有限公司","",null,70219.996,null,"人民币",4382660.36,4382650,10.3600000003353,null,null,null,0,null,4382660.36,4382650,10.3600000003353,null,null,0,0,null,0,null,0,null,null,0,0,null,0,0,0]
["ETA中转港","确认","(101)侨益物流股份有限公司","进口集装箱","QYIC18030134F01","宁波晶海工贸有限公司","",null,260.1,"2018-06-03","人民币",5382.71,5100.24,282.47,null,7280,null,7280,null,-1897.29,5100.24,-6997.53,null,7280,0,7280,null,0,null,0,null,null,0,7280,null,0,0,0]
["ETA中转港","确认","(101)侨益物流股份有限公司","进口集装箱","QYIC18030142F01","厦门建发原材料贸易有限公司","",null,137.98,"2018-04-24","人民币",74302.98,72789.41,1513.56999999999,null,4691.32,null,4691.32,null,69611.66,72789.41,-3177.75000000001,null,4691.32,0,4691.32,null,0,null,0,null,null,0,4691.32,null,0,0,0]
["ETA中转港","确认","(101)侨益物流股份有限公司","进口集装箱","QYIC18030136F01","宁波晶海工贸有限公司","",null,208.96,"2018-04-09","人民币",6252.11,5985.24,266.87,null,7280,null,7280,null,-1027.89,5985.24,-7013.13,null,7280,0,7280,null,0,null,0,null,null,0,7280,null,0,0,0]
["ETA中转港","确认","(101)侨益物流股份有限公司","进口集装箱","QYIC18030137F01","宁波晶海工贸有限公司","",null,208.959,"00:00:00","人民币",5382.71,5100.24,282.47,null,7280,null,7280,null,-1897.29,5100.24,-6997.53,null,7280,0,7280,null,0,null,0,null,null,0,7280,null,0,0,0]
["ETA中转港","确认","(101)侨益物流股份有限公司","进口集装箱","QYIC18030138F01","宁波晶海工贸有限公司","",null,253,"2018-04-30","人民币",5382.71,5100.24,282.47,null,7280,null,7280,null,-1897.29,5100.24,-6997.53,null,7280,0,7280,null,0,null,0,null,null,0,7280,null,0,0,0]
["ETA中转港","确认","(101)侨益物流股份有限公司","进口集装箱","QYIC18030140F01","厦门建发原材料贸易有限公司","",null,342.365,"2018-04-03","人民币",74298.32,72789.41,1508.91,null,11640.41,450,11190.41,null,62657.91,72339.41,-9681.5,null,11640.41,0,11640.41,0,0,null,0,0,0,450,11640.41,450,0,450,0]
["ETA中转港","确认","(101)侨益物流股份有限公司","进口集装箱","QYIC18030141F01","广东恒兴饲料实业股份有限公司","",null,1027.73,"2018-04-01","人民币",49171.07,49157,14.0699999999997,null,46247.85,null,46247.85,null,2923.22,49157,-46233.78,null,46247.85,0,46247.85,null,0,null,0,null,null,0,46247.85,null,0,0,0]
["待确认","新建","(101)侨益物流股份有限公司","进口散船","QYIB18030028F01","中粮四海丰（张家港）贸易有限公司","",null,70373.875,"2018-03-31","人民币",0,0,0,null,null,null,0,null,0,0,0,null,null,0,0,null,0,null,0,null,null,0,0,null,0,0,0]
["ETA中转港","确认","(101)侨益物流股份有限公司","进口集装箱","ZJIC18030001F01","北大荒粮食集团广州仁亿贸易有限公司","",null,272.119,"2018-04-11","人民币",19771.59,19757.6,13.9900000000016,null,12789.59,null,12789.59,null,6982,19757.6,-12775.6,null,12789.59,0,12789.59,null,0,null,0,null,null,0,12789.59,null,0,0,0]
["接收委托","确认","(101)侨益物流股份有限公司","进口集装箱","QYIC18030146F01","东莞嘉吉粮油有限公司","",null,1.06,null,"人民币",1250,2281,-1031,null,650,null,650,null,600,2281,-1681,null,650,0,650,null,0,null,0,null,null,0,650,null,0,0,0]
["ETA中转港","确认","(101)侨益物流股份有限公司","进口集装箱","QYIC18030143F01","厦门建发原材料贸易有限公司","",null,277.9,"2018-04-24","人民币",74298.32,72789.41,1508.91,null,9448.6,null,9448.6,null,64849.72,72789.41,-7939.69,null,9448.6,0,9448.6,null,0,null,0,null,null,0,9448.6,null,0,0,0]
["ETA中转港","确认","(101)侨益物流股份有限公司","进口集装箱","QYIC18030133F01","宁波晶海工贸有限公司","",null,130.05,"2018-05-17","人民币",5382.71,5100.24,282.47,null,7280,null,7280,null,-1897.29,5100.24,-6997.53,null,7280,0,7280,null,0,null,0,null,null,0,7280,null,0,0,0]
["ETA中转港","确认","(101)侨益物流股份有限公司","进口集装箱","QYIC18030139F01","宁波晶海工贸有限公司","",null,252.56,"2018-04-30","人民币",5382.71,5100.24,282.47,null,7280,null,7280,null,-1897.29,5100.24,-6997.53,null,7280,0,7280,null,0,null,0,null,null,0,7280,null,0,0,0]
["ETA中转港","确认","(101)侨益物流股份有限公司","进口集装箱","QYIC18030148F01","天津建源供应链管理有限公司","",null,1548.486,"2018-04-08","人民币",49154.2,48900.24,253.959999999999,null,69681.87,10872.86,58809.01,null,-20527.67,38027.38,-58555.05,null,69681.87,0,69681.87,null,0,null,0,null,10872.86,0,69681.87,null,0,0,0]
["合计",{"$nulls":7},{"$f":"SUM(I10:I29)","v":147250.043},null,null,{"$f":"SUM(L10:L29)","v":4917929.96},{"$f":"SUM(M10:M29)","v":4906306.07},{"$f":"SUM(N10:N29)","v":11623.8900000003},null,{"$f":"SUM(P10:P29)","v":204211.16},{"$f":"SUM(Q10:Q29)","v":32727.86},{"$f":"SUM(R10:R29)","v":171483.3},null,{"$f":"SUM(T10:T29)","v":4713718.8},{"$f":"SUM(U10:U29)","v":4873578.21},{"$f":"SUM(V10:V29)","v":-159859.41},null,{"$f":"SUM(X10:X29)","v":204211.16},0,204211.16,0,0,0,0,0,10872.86,21855,204211.16,21855,0,450,-21405,0]

{"sheet":"分环节统计表","index":8,"n_rows":12,"n_cols":105,"rows_kept":12,"cut":false,"hidden":false,"merged":[[4,9,4,21],[4,22,4,34],[4,35,4,47],[4,48,4,60],[4,61,4,73],[4,74,4,86],[4,87,4,99],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,5,5],[4,6,5,6],[4,7,5,7],[4,8,5,8],[4,100,5,100],[4,101,5,101],[4,102,5,102],[4,103,5,103],[4,104,5,104]]}
["1、统计口径：要求含货代事业部及单家公司所有业务类型的分环节单票费用统计。"]
["2、搜索条件：业务号、经营单位、卸货码头、货名、仓库、时间（按起止时间，包含以下时间类型：ATA卸货码头时间、流向完结时间、清货完结时间、业务完结时间、权责点时间）、账套、业务类型。"]
["3、可按Excel表格形式导出数据。"]
[]
["账套号","工作单号","经营单位","业务类型","卸货码头","柜数","柜型","仓库","货名","船公司费用",{"$nulls":12},"码头费用",{"$nulls":12},"通关费用",{"$nulls":12},"仓储费用",{"$nulls":12},"运输费用",{"$nulls":12},"滞修洗费用",{"$nulls":12},"合计",{"$nulls":12},"ATA卸货码头","流向完结时间","清货完结时间","业务完结时间","权责点"]
[{"$nulls":9},"货量(ca)","预估应收(cb)","预估成本(cd)","预估利润(ce=cb-cd)","预估单吨利润(cf=ce/ca)","实际应收(cg)","实际成本(ch)","实际利润(ci=cg-ch)","实际单吨利润(cj=ci/ca)","应收差异(ck=cb-cg)","应付差异(cl=cd-ch)","利润差异(cm=ce-ci)","单吨利润差异(cn=cm/ca)","货量（a）","预估应收（b）","预估成本（c）","预估利润（d=b-c）","预估单吨利润（e=d/a）","实际应收（f）","实际成本（g）","实际利润（h=f-g）","实际单吨利润（i=h/a）","应收差异（j=b-f）","应付差异（k=c-g）","利润差异（l=d-h）","单吨利润差异（m=e-i）","货量（n）","预估应收（o）","预估成本（p）","预估利润（q=o-p）","预估单吨利润（r=q/n）","实际应收（s）","实际成本（t）","实际利润（u=s-t）","实际单吨利润（v=u/n）","应收差异（w=o-s）","应付差异（x=p-t）","利润差异（y=q-u）","单吨利润差异（z=r-v）","货量（aa）","预估应收（ab）","预估成本（ac）","预估利润（ad=ab-ac）","预估单吨利润（ae=ad/aa）","实际应收（af）","实际成本（ag）","实际利润（ah=af-ag）","实际单吨利润（ai=ah/aa）","应收差异（aj=ab-af）","应付差异（ak=ac-ag）","利润差异（al=ad-ah）","单吨利润差异（am=ae-ai）","货量（an）","预估应收（ao）","预估成本（ap）","预估利润（aq=ao-ap）","预估单吨利润（ar=aq/an）","实际应收（as）","实际成本（at）","实际利润（au=as-at）","实际单吨利润（av=au/an）","应收差异（aw=ao-as）","应付差异（ax=ap-at）","利润差异（ay=aq-au）","单吨利润差异（az=ar-av）","货量（ba）","预估应收（bb）","预估成本（bc）","预估利润（bd=bb-bc）","预估单吨利润（be=bd/ba）","实际应收（bf）","实际成本（bg）","实际利润（bh=bf-bg）","实际单吨利润（bi=bh/ba）","应收差异（bj=bb-bf）","应付差异（bk=bc-bg）","利润差异（bl=bd-bh）","单吨利润差异（bm=be-bi）","货量（bn）","预估应收（bo=b+o+ao+ab+bb+cb）","预估成本（bp=+c+p+ap+ac+bc+cd）","预估利润（bq=d+q+aq+ad+bd+ce）","预估单吨利润（br=e+r+ar+ae+be+cf）","实际应收（bs=f+s+as+af+bf+cg）","实际成本（bt=g+t+at+ag+bg+ch）","实际利润（bu=h+u+au+ah+bh+ci）","实际单吨利润（bv=i+v+av+ai+bi+cj）","应收差异（bw=j+w+aw+aj+bj+ck）","应付差异（bx=k+x+ax+ak+bk+cl）","利润差异（by=l+y+ay+al+bl+cm）","单吨利润差异（bz=m+z+az+am+bm+cn）"]
["(101)侨益物流股份有限公司","QYIC18030131F01","广州俊泰饲料有限公司","进口集装箱",{"$nulls":18},"取值应收计费中各包干对应的吨数",{"$nulls":12},"取值应收计费中各包干对应的吨数",{"$nulls":12},"取值应收计费中各包干对应的吨数",{"$nulls":12},"取值应收计费中各包干对应的吨数",{"$nulls":25},"取整票毛重（吨）",{"$nulls":12},"2018-04-23"]
["(101)侨益物流股份有限公司","QYIC18030145F01","凯配贸易（上海）有限公司","进口集装箱",{"$nulls":96},"2018-05-21"]
["(101)侨益物流股份有限公司","QYIC18030147F01","东莞嘉吉粮油有限公司","进口集装箱",{"$nulls":96},"2018-05-07"]
["合计",{"$nulls":21},{"$f":"SUM(W7:W9)","v":0},{"$f":"SUM(X7:X9)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(CJ7:CJ9)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
[{"$nulls":22},"见下图"]

{"sheet":"经营财务分析（按经营单位统计）","index":9,"n_rows":16,"n_cols":42,"rows_kept":16,"cut":false,"hidden":false,"merged":[[4,8,4,24],[4,25,4,41],[5,8,5,10],[5,11,5,13],[5,14,5,16],[5,17,5,19],[5,25,5,27],[5,28,5,30],[5,31,5,33],[5,34,5,36],[5,20,6,20],[5,21,6,21],[5,22,6,22],[5,23,6,23],[5,24,6,24],[5,37,6,37],[5,38,6,38],[5,39,6,39],[5,40,6,40],[5,41,6,41]]}
[]
[null,"还需增加：折线对比图"]
[]
[]
[{"$nulls":8},"本月",{"$nulls":16},"上年同期"]
[{"$nulls":8},"第一周",null,null,"第二周",null,null,"第三周",null,null,"第四周",null,null,"合计收入","合计成本","合计利润","毛利率","单吨利润","第一周",null,null,"第二周",null,null,"第三周",null,null,"第四周",null,null,"合计收入","合计成本","合计利润","毛利率","单吨利润"]
[null,"公司名（全称）","月份","客户（全称/经营单位）","货量","货类","货名","运输方式","收入","成本","利润","收入","成本","利润","收入","成本","利润","收入","成本","利润",{"$nulls":5},"收入","成本","利润","收入","成本","利润","收入","成本","利润","收入","成本","利润"]
[null,"侨益物流股份有限公司","1月","厦门建发原材料贸易有限公司",20,"粮谷类","高梁","集装箱",{"$nulls":12},100,80,{"$f":"U8-V8","v":20},{"$f":"W8/U8","v":0.2},{"$f":"W8/E8","v":1}]
[null,"侨益物流股份有限公司","1月","新谷(上海)贸易有限公司",3,"饲料","DDGS","集装箱",{"$nulls":12},20,10,{"$f":"U9-V9","v":10},{"$f":"W9/U9","v":0.5},3.33333333333333]
[null,"侨益物流股份有限公司","1月","厦门市明穗粮油贸易有限公司",20,"饲料","鱼粉","集装箱",{"$nulls":12},18,15,3,0.166666666666667,0.15]
[null,"侨益物流股份有限公司","1月","肇庆市福加德面粉有限公司",20,"饲料","豆粕","集装箱",{"$nulls":12},18,15,3,0.166666666666667,0.15]
[null,"侨益物流股份有限公司","1月","厦门建发农产品有限公司",50,"粮谷类","高梁","散船",{"$nulls":12},200,160,40,0.2,0.8]
[null,"侨益物流股份有限公司","1月","广州粤和能源有限公司",13,"饲料","DDGS","散船",{"$nulls":12},22,10,12,0.545454545454545,0.923076923076923]
[null,"侨益物流股份有限公司","1月","厦门建发农产品有限公司",15,"饲料","鱼粉","内贸",{"$nulls":12},8,3,5,0.625,0.333333333333333]
[null,"侨益物流股份有限公司","1月","厦门建发农产品有限公司",25,"饲料","豆粕","散船",{"$nulls":12},12,5,7,0.583333333333333,0.28]
[null,"侨益物流股份有限公司","1月","厦门建发农产品有限公司",30,"食品","大米","散船",{"$nulls":12},20,15,5,0.25,0.166666666666667]

{"sheet":"经营财务分析（按开票名称统计）","index":10,"n_rows":16,"n_cols":42,"rows_kept":16,"cut":false,"hidden":false,"merged":[[4,8,4,24],[4,25,4,41],[5,8,5,10],[5,11,5,13],[5,14,5,16],[5,17,5,19],[5,25,5,27],[5,28,5,30],[5,31,5,33],[5,34,5,36],[5,20,6,20],[5,21,6,21],[5,22,6,22],[5,23,6,23],[5,24,6,24],[5,37,6,37],[5,38,6,38],[5,39,6,39],[5,40,6,40],[5,41,6,41]]}
[]
[null,"还需增加：折线对比图"]
[]
[]
[{"$nulls":8},"本月",{"$nulls":16},"上年同期"]
[{"$nulls":8},"第一周",null,null,"第二周",null,null,"第三周",null,null,"第四周",null,null,"合计收入","合计成本","合计利润","毛利率","单吨利润","第一周",null,null,"第二周",null,null,"第三周",null,null,"第四周",null,null,"合计收入","合计成本","合计利润","毛利率","单吨利润"]
[null,"公司名（全称）","月份","客户（全称/经营单位）","货量","货类","货名","运输方式","收入","成本","利润","收入","成本","利润","收入","成本","利润","收入","成本","利润",{"$nulls":5},"收入","成本","利润","收入","成本","利润","收入","成本","利润","收入","成本","利润"]
[null,"侨益物流股份有限公司","1月","厦门建发原材料贸易有限公司",20,"粮谷类","高梁","集装箱",{"$nulls":12},100,80,{"$f":"U8-V8","v":20},{"$f":"W8/U8","v":0.2},{"$f":"W8/E8","v":1}]
[null,"侨益物流股份有限公司","1月","新谷(上海)贸易有限公司",3,"饲料","DDGS","集装箱",{"$nulls":12},20,10,{"$f":"U9-V9","v":10},{"$f":"W9/U9","v":0.5},3.33333333333333]
[null,"侨益物流股份有限公司","1月","厦门市明穗粮油贸易有限公司",20,"饲料","鱼粉","集装箱",{"$nulls":12},18,15,3,0.166666666666667,0.15]
[null,"侨益物流股份有限公司","1月","肇庆市福加德面粉有限公司",20,"饲料","豆粕","集装箱",{"$nulls":12},18,15,3,0.166666666666667,0.15]
[null,"侨益物流股份有限公司","1月","厦门建发农产品有限公司",50,"粮谷类","高梁","散船",{"$nulls":12},200,160,40,0.2,0.8]
[null,"侨益物流股份有限公司","1月","广州粤和能源有限公司",13,"饲料","DDGS","散船",{"$nulls":12},22,10,12,0.545454545454545,0.923076923076923]
[null,"侨益物流股份有限公司","1月","厦门建发农产品有限公司",15,"饲料","鱼粉","内贸",{"$nulls":12},8,3,5,0.625,0.333333333333333]
[null,"侨益物流股份有限公司","1月","厦门建发农产品有限公司",25,"饲料","豆粕","散船",{"$nulls":12},12,5,7,0.583333333333333,0.28]
[null,"侨益物流股份有限公司","1月","厦门建发农产品有限公司",30,"食品","大米","散船",{"$nulls":12},20,15,5,0.25,0.166666666666667]

{"sheet":"应收、预收账龄表 ","index":11,"n_rows":12,"n_cols":11,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[null,"1、按账套区分；"]
[null,"2、统计口径：可分别按发票日期、权责日期统计；"]
[null,"3、搜索条件：帐套、经营单位、结算单位、会计期、统计口径、发票日期（起止时间）、权责日期（起止时间）；"]
[null,"4、统计金额可点击查看并导出按业务号显示的明细（可参照T表应收、应付费目明细）；"]
[null,"5、可按Excel表格形式导出数据。"]
[null,"搜索条件：经营单位/结算单位","业务完结日期",{"$nulls":7},"单位：元"]
[null,"本公司名称","单位名称","金额（a=b+c+d+e+f+g+h）","30天以内（b）","31-60天（c）","61-90天（d）","91-120天（e）","121-180天（f）","181-360天（g）","360天以上（h）"]
[null,null,null,{"$f":"SUM(E8:K8)","v":0}]
[null,null,null,{"$f":"SUM(E9:K9)","v":0}]
[null,null,null,{"$f":"SUM(E10:K10)","v":0}]
[null,null,null,{"$f":"SUM(E11:K11)","v":0}]
[null,"合计",null,{"$f":"SUM(D8:D11)","v":0},{"$f":"SUM(E8:E11)","v":0},0,0,0,0,0,0]

{"sheet":"应付、预付账龄表","index":12,"n_rows":124,"n_cols":11,"rows_kept":124,"cut":false,"hidden":false,"merged":[]}
[null,"1、按账套区分；"]
[null,"2、统计口径：可分别按发票日期、权责日期统计；"]
[null,"3、搜索条件：帐套、结算单位、会计期、统计口径、发票日期（起止时间）、权责日期（起止时间）；"]
[null,"4、统计金额可点击查看并导出按业务号显示的明细（可参照T表应收、应付费目明细）；"]
[null,"5、可按Excel表格形式导出数据。"]
[null,"搜索条件：经营单位/结算单位","会计期",{"$nulls":7},"单位：元"]
[null,"本公司名称","结算单位","金额（a=b+c+d+e+f+g+h）","30天以内（b）","31-60天（c）","61-90天（d）","91-120天（e）","121-180天（f）","181-360天（g）","360天以上（h）"]
[null,null,null,{"$f":"SUM(E8:K8)","v":0}]
[null,null,null,{"$f":"SUM(E9:K9)","v":0}]
[null,null,null,{"$f":"SUM(E10:K10)","v":0}]
[null,null,null,{"$f":"SUM(E11:K11)","v":0}]
[null,"合计",null,{"$f":"SUM(D8:D11)","v":0},{"$f":"SUM(E8:E11)","v":0},0,0,0,0,0,0]
[]
["1、预付账款账龄表金额一列为空，搜索条件缺少经营单位、会计期，应增加按帐套区分；"]
{"$rows_empty":18}
["2、预付账款账龄表从系统导出excel后单位名称显示为代码；"]
{"$rows_empty":12}
["3、该表数据不对："]
["3.1例如，预付账款账龄表上广州市锦运物流有限公司91-120天预付款10000元，实际是2018年5月11日退押金给广州市锦运物流有限公司10000元，并非预付账款。"]
{"$rows_empty":76}
["3.2、又例如，预付账款账龄表上湛江市源利国际货运代理有限公司31-60天预付款30000元，实际是2018年7月退押金给湛江市源利国际货运代理有限公司30000元，并非预付账款。"]

{"sheet":"应付账龄表","index":13,"n_rows":81,"n_cols":11,"rows_kept":81,"cut":false,"hidden":false,"merged":[]}
[]
[null,"侨益物流股份有限公司"]
[null,"搜索条件：经营单位/结算单位","会计期",{"$nulls":5},"单位：元"]
[null,"本公司名称","供应商","金额","30天以内","31-60天","61-90天","91-120天","121-180天","181-360天","360天以上"]
{"$rows_empty":15}
["1、该表搜索条件无经营单位、会计期，搜索条件应增加按帐套区分，总应付金额一列为空；"]
{"$rows_empty":39}
["2、应付账款账龄表从系统导出excel后单位名称显示为代码；"]
{"$rows_empty":20}
["3、该表数据待核实，例如，广州市广海物流有限公司，30天以内应付金额为12000元，并未有收到该公司的应付发票12000元。"]

{"sheet":"应收账龄表","index":14,"n_rows":80,"n_cols":11,"rows_kept":80,"cut":false,"hidden":false,"merged":[]}
[]
[null,"侨益物流股份有限公司"]
[null,"搜索条件：经营单位/结算单位","会计期",{"$nulls":5},"单位：元"]
[null,"本公司名称","单位名称","金额","30天以内","31-60天","61-90天","91-120天","121-180天","181-360天","360天以上"]
{"$rows_empty":15}
["1、应收账款账龄表搜索条件无经营单位、会计期，金额一列为空，应增加帐套名称作为搜索条件区分；"]
{"$rows_empty":30}
["2、该表导出Excel后单位名称均是代码；"]
{"$rows_empty":28}
["3、该表数据待核实，例如，东莞嘉吉粮油有限公司业务号QYIB18070008F01在7月16日开票10000元未收款，截止2018年7月17日的应收账款账龄表，该笔应收款在31-60天账龄内，请核实。"]

{"sheet":"可用资金汇总表","index":15,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["1、搜索条件无年份、月份，统计表无经营单位；"]

{"sheet":"资金日历、计划与实际差异表","index":16,"n_rows":39,"n_cols":17,"rows_kept":39,"cut":false,"hidden":false,"merged":[[5,2,5,6],[5,7,5,11],[5,12,5,16],[5,0,6,0]]}
["系统应提供一个录入最初期初余额的地方，出纳在初始先将最开始的期初录入，后期每天需将实除余额录入，预计的每日期初等于实际的上一天的余额"]
[]
[]
["搜索：","按月份"]
[]
["日期",null,"预计",{"$nulls":4},"实际",{"$nulls":4},"差异"]
[null,"期初","业务应收","业务应付","费用报销","其他","余额","应收","应付","费用报销","其他","余额","应收","应付","费用报销","其他","余额"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
["小计"]

{"sheet":"贷款备查簿","index":17,"n_rows":113,"n_cols":20,"rows_kept":113,"cut":false,"hidden":false,"merged":[[0,0,0,12],[2,2,2,3],[2,8,2,9],[2,10,2,11],[2,16,2,18],[2,0,3,0],[4,0,30,0],[31,0,64,0],[65,0,94,0],[95,0,109,0],[2,1,3,1],[4,1,30,1],[31,1,64,1],[65,1,94,1],[95,1,109,1],[2,4,3,4],[2,5,3,5],[2,6,3,6],[2,7,3,7],[2,12,3,12],[2,13,3,13],[2,14,3,14],[2,15,3,15],[4,15,30,15],[31,15,64,15],[65,15,94,15],[95,15,109,15],[4,16,30,16],[31,16,64,16],[65,16,94,16],[95,16,109,16],[4,17,30,17],[31,17,64,17],[65,17,94,17],[95,17,109,17],[4,18,30,18],[31,18,94,18],[95,18,109,18],[2,19,3,19],[4,19,30,19],[31,19,64,19],[65,19,94,19],[95,19,109,19]]}
["贷款备查簿"]
[]
["编号","贷款银行","借款期限",null,"浮动/固定利率","综合年/月利率","担保费","期初余额","提款金额",null,"还款金额",null,"期末余额（元）","扣息日期","利息","是(否)逾期","借款条件",null,null,"借款用途"]
[null,null,"借款日","约定还款日",{"$nulls":4},"日期","金额（元）","日期","金额（元）",{"$nulls":4},"信用/保证/抵(质)押","保证人/抵(质)押物","担保期限"]
[1,"中国农业发展银行广东省分行营业部","2016-11-18","2017-10-31",null,0.0435,null,0,"2016-11-21",39580000,null,null,{"$f":"H5+J5-L5","v":39580000},null,null,"否",null,null,"2016年11月1日—2019年10月31日 ","购小麦"]
[{"$nulls":10},"2017-10-24",12128927,{"$f":"M5+J6-L6","v":27451073},"2017-01-21",148260.08]
{"$rows_empty":25}
[2,"中国工商银行广州黄埔支行"]
{"$rows_empty":33}
[3,"中国工商银行广州黄埔支行"]
{"$rows_empty":29}
[4,"广州惠民村镇银行科汇金谷支行"]
{"$rows_empty":16}
["合  计","----","----","----","----","----",null,"----","----",null,"----",null,{"$f":"M13+M47+M70+M96","v":0},null,null,"----","----","----","----","----"]

{"sheet":"信控风险分析","index":18,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"（客户、供应商）合同结算期跟踪统计表","index":19,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"费用统计表(按部门预算对比）","index":20,"n_rows":44,"n_cols":9,"rows_kept":44,"cut":false,"hidden":false,"merged":[[9,2,9,4],[9,5,9,7],[9,0,10,0],[9,1,10,1],[9,8,10,8],[0,0,1,7]]}
["费用预算进度表"]
{"$rows_empty":8}
["部门","费用大类=科目","年度预算对比",null,null,"月度预算对比",null,null,"原因说明"]
[null,null,"本年预算","本年累计","预算进度","本月预算","本月实际","预算进度"]
["管理部门","职工薪酬"]
["管理部门","职工教育经费"]
["管理部门","职工福利费"]
["管理部门","办公费用"]
["管理部门","招待费用"]
["管理部门","差旅费"]
["管理部门","车辆费用"]
["管理部门","通讯费"]
["管理部门","税费"]
["管理部门","其他"]
["管理部门","小计"]
["商务部门","职工薪酬"]
["商务部门","职工教育经费"]
["商务部门","职工福利费"]
["商务部门","办公费用"]
["商务部门","招待费用"]
["商务部门","差旅费"]
["商务部门","车辆费用"]
["商务部门","通讯费"]
["商务部门","税费"]
["商务部门","其他"]
["商务部门","小计"]
["。。。","职工薪酬"]
[null,"职工教育经费"]
[null,"职工福利费"]
[null,"办公费用"]
["汇总","招待费用"]
[null,"差旅费"]
[null,"车辆费用"]
[null,"通讯费"]
[null,"税费"]
[null,"其他"]
[null,"小计"]

{"sheet":"报销费用汇总（按个人）","index":21,"n_rows":33,"n_cols":18,"rows_kept":33,"cut":false,"hidden":false,"merged":[[4,0,4,17],[5,0,5,17],[6,0,6,17],[7,0,32,0]]}
[]
[]
[]
[]
["报销费用汇总-按部门个人"]
["制表日期：2018年03月31日"]
["统计时段：2014年01月01日 至 2018年03月31日"]
["管理部",null,"陈小明","陈峥峥","何海","姜苗","梁健斌","彭彪","秦结儿","秦锦钊","秦松添","阮金艳","苏月飞","温璐明","徐良能","叶艺芬","朱晓晖","总计"]
[null,"",3420,{"$nulls":14},3420]
[null,"办公用品",272.4,1838,null,342,null,28,null,10000,{"$nulls":7},12480.4]
[null,"部门餐费",null,null,null,2351.5,{"$nulls":5},2700,{"$nulls":5},5051.5]
[null,"部门活动费",{"$nulls":9},991,null,null,null,788,null,1779]
[null,"餐费",11009.9,68764.69,null,7192,null,36287.8,161,null,7236,null,50,350,null,null,6128,137179.39]
[null,"操作费",null,689306,{"$nulls":13},689306]
[null,"车船税",null,3000,{"$nulls":13},3000]
[null,"车辆保险费",null,8500,{"$nulls":13},8500]
[null,"车辆保养费",7880,447,{"$nulls":13},8327]
[null,"车辆维修费",67100.71,4745,{"$nulls":13},71845.71]
[null,"工作误餐费",6290,2054,134,559,50,265,{"$nulls":9},9352]
[null,"会议费",12000,{"$nulls":4},22000,{"$nulls":9},34000]
[null,"交通费",297,6347.2,null,216,null,662,155.5,null,null,null,895.5,{"$nulls":4},8573.2]
[null,"快递费",null,500,{"$nulls":8},109.5,{"$nulls":4},609.5]
[null,"礼品费",2800,115080.82,null,4195.62,null,17378,{"$nulls":6},2414,null,11556.3,153424.74]
[null,"路桥费",3541.66,6410,null,257,{"$nulls":11},10208.66]
[null,"年票费",1960,980,{"$nulls":13},2940]
[null,"其他",2820,62155.88,{"$nulls":13},64975.88]
[null,"汽车油费",1446.04,53449,{"$nulls":13},54895.04]
[null,"市内交通费",1856,2813,null,435,{"$nulls":11},5104]
[null,"停车费",1859,989,{"$nulls":13},2848]
[null,"文体活动费",24261,{"$nulls":4},78940,{"$nulls":8},452,103653]
[null,"易耗品",{"$nulls":5},1688,{"$nulls":8},324.8,2012.8]
[null,"住宿费",1366.2,67382.73,null,33391,null,35268.2,780,null,899,{"$nulls":6},139087.13]
[null,"总计",150179.91,1094762.32,134,48939.12,50,192517,1096.5,10000,8135,3691,1055,350,2414,788,18461.1,1532572.95]

{"sheet":"报销费用汇总（按部门明细）","index":22,"n_rows":89,"n_cols":14,"rows_kept":89,"cut":false,"hidden":false,"merged":[[4,0,4,13],[5,0,5,13],[6,0,6,13],[8,0,24,0],[25,0,26,0],[28,0,32,0],[33,0,42,0],[46,0,51,0],[54,0,62,0],[63,0,64,0],[68,0,69,0],[70,0,76,0],[77,0,82,0],[83,0,84,0],[85,0,87,0]]}
[]
[]
[]
[]
["报销费用汇总-按部门明细"]
["制表日期：2018年03月31日"]
["统计时段：2014年01月01日 至 2018年03月31日"]
["费用大类","科目名称","办公室","财务部","操作部","管理部","集运部","商务部","市场部","通关部","客服部","储运部","集团人力行政部","总计"]
["办公费用","其他年审费",0,0,150,0,0,0,0,0,0,0,0,150]
[null,"办公设备维修费",5690,980,460,0,0,0,0,0,0,0,0,7130]
[null,"耗材费",16910,0,120,0,0,34480,0,826,0,0,0,52336]
[null,"劳保用品",6747.9,0,1700,0,0,180,0,6532.3,0,0,0,15160.2]
[null,"订报费",2160,0,0,0,0,0,0,3520,0,0,0,5680]
[null,"证件年审费",0,0,100,0,0,0,0,50,0,0,0,150]
[null,"资料书籍费",3265.4,15,312,0,0,191.3,0,1870,2208,0,0,7861.7]
[null,"会议费",22017,0,0,34000,0,58500,0,0,0,0,0,114517]
[null,"房租费",2031,0,10560,0,0,0,0,460,0,0,0,13051]
[null,"复印机月租费",720,0,0,0,0,0,0,0,0,0,0,720]
[null,"市内交通费",977,2604.94,223547.35,5104,8055,382,3973.2,103522.51,612,1700,218,350696]
[null,"水电费",0,0,799.1,0,0,0,0,225,0,0,0,1024.1]
[null,"易耗品",3290.9,1503,30436,2012.8,664,7042,1331,22850.3,25,0,0,69155]
[null,"办公用品",25386.4,7921.5,31193.6,12480.4,1947,47753.7,12708,62810.37,6316,0,0,208516.97]
[null,"资质或证件类使用费",0,300,0,0,0,0,0,170469.28,0,0,0,170769.28]
[null,"快递费",9829,245,54,609.5,610,3113,0,650,135,0,0,15245.5]
[null,"饮用水费",13998.5,0,0,0,0,0,0,2073,0,0,0,16071.5]
["报关代理费","免税表打单费",0,0,0,0,0,0,0,270,0,0,0,270]
[null,"报关单打单费",0,0,0,0,0,0,0,18371,0,0,0,18371]
["操作费","操作费",0,0,4692,689306,0,0,0,468671,0,0,0,1162669]
["差旅费","住宿费",3772,2840,195261,139087.13,19154,220255.74,134524.08,115978.75,23186.74,0,2300.01,856359.45]
[null,"其他",30,0,6300,4008.88,6267.9,31747.5,5419,48486,180,0,0,102439.28]
[null,"礼品费",0,0,3846,0,0,0,0,2050,0,0,0,5896]
[null,"交通费",31910,995.4,33492.9,8573.2,6512,25300.85,76759.86,32417.47,59445.95,0,405,275812.63]
[null,"餐费",11582,400,64495.6,29173.37,3519,10822.5,40212.8,39595,7212,0,542.5,207554.77]
["车辆费用","车辆年审费",2435,0,70,0,0,0,0,0,0,0,0,2505]
[null,"停车费",9079,0,1158,2848,10,0,451.5,7781.5,0,0,2977,24305]
[null,"汽车油费",159971.87,0,173138.1,54895.04,10250,8979,18079,426022.49,800,0,0,852135.5]
[null,"外租车辆费",1342,0,130,0,0,13000,0,18873.32,0,0,0,33345.32]
[null,"车辆维修费",12433.81,0,50,71845.71,0,0,0,7685.9,0,0,120,92135.42]
[null,"车辆保养费",3695,0,0,8327,0,0,0,0,0,0,1510,13532]
[null,"年票费",18725,0,50,2940,0,0,0,3760,0,0,0,25475]
[null,"",2193,0,0,3420,0,0,0,0,0,0,0,5613]
[null,"路桥费",12803,0,30710,10208.66,86,14660,9217,171525.58,120,0,310,249640.24]
[null,"车辆保险费",16525.66,0,0,8500,0,0,0,13283.45,0,0,0,38309.11]
["船公司费用","出口封条费",0,0,0,0,0,0,0,0,400,0,0,400]
["搭架材料及人工费","工人费",0,0,4723,0,0,0,0,17440,500,0,0,22663]
["港建费","内贸港建费",0,0,16248,0,8658,0,0,0,900,0,0,25806]
["港口费","工本费",0,0,9036,0,0,0,0,20,0,0,0,9056]
[null,"装卸车费",0,0,0,0,0,0,0,140,0,0,0,140]
[null,"吊柜费",0,0,225,0,0,0,0,0,0,0,0,225]
[null,"工时费",0,0,200,0,0,0,0,200,0,0,0,400]
[null,"内贸港建费",0,0,170,0,0,0,0,0,0,0,0,170]
[null,"抽样吊柜费",0,0,0,0,0,0,0,3965,0,0,0,3965]
["海关费用","操作费",0,0,0,0,0,0,0,2400,0,0,0,2400]
["其他","其他",22,0,1860,1850,0,9000,0,36484,32,0,0,49248]
["商检费用","抽样费",0,0,0,0,0,0,0,28480,0,0,0,28480]
[null,"水尺费",0,0,0,0,0,0,0,200,0,0,0,200]
[null,"大飞",0,0,26840,0,0,0,0,56550,0,0,0,83390]
[null,"检测费",0,0,0,0,0,0,0,84140,0,0,0,84140]
[null,"商检费",0,0,0,0,0,0,0,1766,0,0,0,1766]
[null,"消毒自理费",0,0,0,0,0,0,0,238982,0,0,0,238982]
[null,"水船费",0,0,0,0,0,0,0,73500,0,0,0,73500]
[null,"消毒费",0,0,0,0,0,0,0,3080,200,0,0,3280]
[null,"操作费",0,0,3200,0,0,0,0,1533970.5,0,0,0,1537170.5]
["税费","车船税",3600,14724,0,3000,0,0,0,0,0,0,0,21324]
[null,"印花税",0,1500,0,0,0,0,0,0,0,0,0,1500]
["铁路运杂费","其他杂费",0,0,250,0,0,0,0,0,0,0,0,250]
["通讯费","电话费",1670.54,0,32858,0,2900,0,1250,1493,3050,0,0,43221.54]
["外包费","外包装卸费",0,0,400,0,0,124299,0,451657,0,0,0,576356]
["物料费","封条",0,0,11200,0,0,0,0,0,0,0,0,11200]
[null,"小包装袋",0,0,300,0,0,0,0,0,0,0,0,300]
["招待费用","娱乐费",0,0,30646,0,0,17195,0,215855.35,0,0,0,263696.35]
[null,"文体活动费",0,0,151869.33,103653,0,19983,22353.98,105893.8,0,0,3680,407433.11]
[null,"招待费",0,0,1264,0,1900,1502941.11,0,3917,0,0,0,1510022.11]
[null,"路桥费",0,0,295,0,0,1902,0,3983,0,0,0,6180]
[null,"餐费",7011.6,1346,515036.22,108006.02,19057,235128.5,107316.13,2055795.06,12806.5,0,4432.4,3065935.43]
[null,"其他",47400,0,6864,59117,0,551883.74,2288,92818.7,67,0,0,760438.44]
[null,"礼品费",43060.4,680,151664.4,153424.74,1660,157845.4,53826,945377.21,3069,0,0,1510607.15]
["职工福利费","工人餐费及水费",2976,0,1584,0,390,0,0,0,350,0,0,5300]
[null,"药品及其他保健",1172.8,0,0,0,0,0,1735,0,300,0,0,3207.8]
[null,"工作误餐费",32587,13532.28,2714,9352,658.5,662,0,1174,14064.2,0,1313,76056.98]
[null,"部门活动费",30236.6,0,57153,1779,0,0,0,0,799,0,0,89967.6]
[null,"部门餐费",5746,2864.5,17738,5051.5,0,2415,776,5359,16282.5,0,0,56232.5]
[null,"体检费",0,240,0,0,0,0,0,0,0,0,0,240]
["职工教育经费","资料及书费",0,0,0,0,0,0,0,0,1880,0,0,1880]
[null,"培训费",45567,0,0,0,0,0,1500,800,0,0,0,47867]
["资产采购","电子设备",9045,0,4600,0,16500,0,0,0,0,0,0,30145]
[null,"办公用具",2682,0,9499,0,600,0,0,100,0,0,0,12881]
[null,"车辆购置税",82317,0,0,0,0,0,0,0,0,0,0,82317]
[null,"合计",714614.38,52691.62,1871262.6,1532572.95,109398.4,3099662.34,493720.55,7716170.84,154940.89,1700,17807.91,15764542.48]

{"sheet":"关联交易统计表","index":23,"n_rows":7,"n_cols":9,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["关联交易统计表"]
["查询日期：",null,null,"统计公司名称：各公司帐套名（或不选，则是股份内所有公司）"]
["统计公司名称","核算科目","本月交易金额","本年累计金额","对方单位","对方科目","对方本月交易金额","对方本年累计金额","差异金额"]
["侨益物流股份有限公司","主营业务成本",null,null,"生生物流","主营业务收入"]
[null,"存货"]
[]
["1、该统计表无法查询出数据。"]

{"sheet":"关联应收应付统计表","index":24,"n_rows":4,"n_cols":9,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["关联应收应付统计表"]
["查询日期：",null,null,"统计公司名称：各公司帐套名（或不选，则是股份内所有公司）"]
["统计公司名称","核算科目","本月交易金额","期末余额","对方单位","对方科目","对方本月交易金额","期末余额","差异金额"]
["侨益物流股份有限公司","应付帐款",null,null,"生生物流","应收帐款",null,null,{"$f":"D4-H4","v":0}]

{"sheet":"协同业务明细表","index":25,"n_rows":5,"n_cols":14,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["搜索条件"]
["业务号：",null,"事业部：全部/货代/船代/运输/仓储",{"$nulls":5},"公司名：","选帐套名",null,null,"日期：","***年***月**日---***年***月**日"]
["经营单位：",null,"船名："]
[]
[null,"业务号","经营单位","船名","货名","货吨","事业部","公司名","收入","成本","公摊成本","毛利"]

{"sheet":"业务员业绩统计表","index":26,"n_rows":5,"n_cols":16,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["搜索条件"]
["业务员",null,null,"业务号：",null,"事业部：全部/货代/船代/运输/仓储",{"$nulls":4},"公司名：","选帐套名",null,null,"日期：","***年***月**日---***年***月**日"]
["经营单位：",null,"船名："]
["公摊成本：       元/吨"]
["业务员","业务号","经营单位","船名","货名","货吨","入仓吨数","入仓地点","事业部","公司名","收入","成本","公摊成本","毛利"]

{"sheet":"分货名毛利统计表","index":27,"n_rows":30,"n_cols":13,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["分货名毛利统计表"]
["统计口径：分别按经营单位、结算单位（发票抬头）进行统计"]
["搜索条件"]
["货名","业务类型",null,"事业部：货代/船代/运输/仓储/全部",null,"经营单位","结算单位（发票抬头）",null,"公司名：","选账套名",null,"日期：","***年***月**日---***年***月**日"]
[]
["可按Excel表格形式导出数据"]
[]
["事业部","本公司名称","月份","经营单位/结算单位（发票抬头）","货名","业务类型","货吨","收入（a）","成本（b）","毛利（c=a-b）"]
[{"$nulls":9},{"$f":"H9-I9","v":0}]
[{"$nulls":9},{"$f":"H10-I10","v":0}]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
["合计",{"$nulls":5},{"$f":"SUM(G9:G26)","v":0},{"$f":"SUM(H9:H26)","v":0},{"$f":"SUM(I9:I26)","v":0},{"$f":"SUM(J9:J26)","v":0}]
[]
[]
["1、分货类单吨毛利明细表未完成，无货名货类，等于要人为导出该表后按照业务号去匹配货名并汇总整理出数据。"]

{"sheet":"业务完结情况表","index":28,"n_rows":39,"n_cols":18,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,5,0,15],[0,16,0,17],[1,5,1,6],[1,7,1,8],[1,9,1,10],[1,11,1,12],[1,13,1,15],[5,1,5,2],[8,1,8,2],[11,1,11,2],[14,1,14,2],[17,1,17,2],[20,1,20,2],[23,1,23,2],[26,1,26,2],[29,1,29,2],[32,1,32,2],[35,1,35,2],[38,1,38,2],[0,0,2,0],[3,0,11,0],[12,0,20,0],[21,0,29,0],[30,0,38,0],[0,1,2,1],[3,1,4,1],[6,1,7,1],[9,1,10,1],[12,1,13,1],[15,1,16,1],[18,1,19,1],[21,1,22,1],[24,1,25,1],[27,1,28,1],[30,1,31,1],[33,1,34,1],[36,1,37,1],[0,2,2,2],[0,18,2,18],[0,19,2,19],[0,3,1,4]]}
["到港时间","业务类型","是否入仓","到港业务量",null,"已达权责业务量",{"$nulls":10},"剩余未达权责业务量"]
[{"$nulls":5},"2019-01-01",null,"2019-02-01",null,"2019-03-01",null,"。。。",null,"合计"]
[null,null,null,"票数","货量","票数","货量","票数","货量","票数","货量","票数","货量","票数","货量","完结货量%","票数","货量"]
["2019-01-01","集装箱","是",78,58543.901,11,3837.71,13,10135.53,{"$nulls":4},{"$f":"SUM(F4,H4)","v":24},{"$f":"SUM(G4,I4)","v":13973.24},{"$f":"O4/E4","v":0.238679687573262},{"$f":"D4-N4","v":54},{"$f":"E4-O4","v":44570.661}]
[null,null,"否",92,47954.758,49,21676.062,24,12151.081,{"$nulls":4},{"$f":"SUM(F5,H5)","v":73},{"$f":"SUM(G5,I5)","v":33827.143},{"$f":"O5/E5","v":0.7053970119086},{"$f":"D5-N5","v":19},{"$f":"E5-O5","v":14127.615}]
[null,"集装箱小计",null,{"$f":"SUM(D4:D5)","v":170},{"$f":"SUM(E4:E5)","v":106498.659},60,25513.772,37,22286.611,{"$nulls":4},97,47800.383,0.448835538858757,73,58698.276]
[null,"散船","是",7,59234.76,3,6015.76,1,5665,{"$nulls":4},{"$f":"SUM(F7,H7)","v":4},{"$f":"SUM(G7,I7)","v":11680.76},0.197194350074179,{"$f":"D7-N7","v":3},{"$f":"E7-O7","v":47554}]
[null,null,"否",8,204598.188,1,7000,{"$nulls":6},{"$f":"SUM(F8,H8)","v":1},{"$f":"SUM(G8,I8)","v":7000},0.0342134017335481,{"$f":"D8-N8","v":7},{"$f":"E8-O8","v":197598.188}]
[null,"散船小计",null,{"$f":"SUM(D7:D8)","v":15},{"$f":"SUM(E7:E8)","v":263832.948},4,13015.76,1,5665,{"$nulls":4},5,18680.76,0.0708052581817795,{"$f":"SUM(Q7:Q8)","v":10},{"$f":"SUM(R7:R8)","v":245152.188}]
[null,"小计","是",{"$f":"SUM(D4,D7)","v":85},{"$f":"SUM(E4,E7)","v":117778.661},14,9853.47,14,15800.53,{"$nulls":4},28,25654,0.217815347722454,57,92124.661]
[null,null,"否",{"$f":"SUM(D5,D8)","v":100},252552.946,50,28676.062,24,12151.081,{"$nulls":4},74,40827.143,0.161657757894458,26,211725.803]
[null,"2019年1月合计",null,{"$f":"SUM(D10:D11)","v":185},{"$f":"SUM(E10:E11)","v":370331.607},64,38529.532,38,27951.611,{"$nulls":4},102,66481.143,0.179517874638229,{"$f":"SUM(Q10:Q11)","v":83},{"$f":"SUM(R10:R11)","v":303850.464}]
["2019-02-01","集装箱","是",29,18264.832,null,null,1,2.06,{"$nulls":4},{"$f":"SUM(F13,H13)","v":1},{"$f":"SUM(G13,I13)","v":2.06},0.000112785050527703,{"$f":"D13-N13","v":28},{"$f":"E13-O13","v":18262.772}]
[null,null,"否",59,33227.634,null,null,8,1412.05,{"$nulls":4},{"$f":"SUM(F14,H14)","v":8},{"$f":"SUM(G14,I14)","v":1412.05},0.0424962547739631,{"$f":"D14-N14","v":51},{"$f":"E14-O14","v":31815.584}]
[null,"集装箱小计",null,{"$f":"SUM(D13:D14)","v":88},{"$f":"SUM(E13:E14)","v":51492.466},0,0,9,1414.11,{"$nulls":4},9,1414.11,0.0274624641204793,{"$f":"SUM(Q13:Q14)","v":79},{"$f":"SUM(R13:R14)","v":50078.356}]
[null,"散船","是",2,10699.39,{"$nulls":8},{"$f":"SUM(F16,H16)","v":0},{"$f":"SUM(G16,I16)","v":0},0,{"$f":"D16-N16","v":2},{"$f":"E16-O16","v":10699.39}]
[null,null,"否",6,149646.172,{"$nulls":8},{"$f":"SUM(F17,H17)","v":0},{"$f":"SUM(G17,I17)","v":0},0,{"$f":"D17-N17","v":6},{"$f":"E17-O17","v":149646.172}]
[null,"散船小计",null,{"$f":"SUM(D16:D17)","v":8},{"$f":"SUM(E16:E17)","v":160345.562},0,0,0,0,{"$nulls":4},0,0,0,{"$f":"SUM(Q16:Q17)","v":8},{"$f":"SUM(R16:R17)","v":160345.562}]
[null,"小计","是",{"$f":"SUM(D13,D16)","v":31},{"$f":"SUM(E13,E16)","v":28964.222},0,0,1,2.06,{"$nulls":4},1,2.06,7.11222279680083e-5,30,28962.162]
[null,null,"否",{"$f":"SUM(D14,D17)","v":65},182873.806,0,0,8,1412.05,{"$nulls":4},8,1412.05,0.00772144480877704,57,181461.756]
[null,"2019年2月合计",null,{"$f":"SUM(D19:D20)","v":96},{"$f":"SUM(E19:E20)","v":211838.028},0,0,9,1414.11,{"$nulls":4},9,1414.11,0.00667543034341313,{"$f":"SUM(Q19:Q20)","v":87},{"$f":"SUM(R19:R20)","v":210423.918}]
["。。。","集装箱","是",{"$nulls":10},{"$f":"SUM(F22,H22)","v":0},{"$f":"SUM(G22,I22)","v":0},{"$f":"O22/E22","v":{"$error":"#DIV/0!"}},{"$f":"D22-N22","v":0},{"$f":"E22-O22","v":0}]
[null,null,"否",{"$nulls":10},{"$f":"SUM(F23,H23)","v":0},{"$f":"SUM(G23,I23)","v":0},{"$error":"#DIV/0!"},{"$f":"D23-N23","v":0},{"$f":"E23-O23","v":0}]
[null,"集装箱小计",{"$nulls":11},{"$f":"SUM(N22:N23)","v":0},{"$f":"SUM(O22:O23)","v":0},{"$error":"#DIV/0!"},{"$f":"SUM(Q22:Q23)","v":0},{"$f":"SUM(R22:R23)","v":0}]
[null,"散船","是",{"$nulls":10},{"$f":"SUM(F25,H25)","v":0},{"$f":"SUM(G25,I25)","v":0},{"$error":"#DIV/0!"},{"$f":"D25-N25","v":0},{"$f":"E25-O25","v":0}]
[null,null,"否",{"$nulls":10},{"$f":"SUM(F26,H26)","v":0},{"$f":"SUM(G26,I26)","v":0},{"$error":"#DIV/0!"},{"$f":"D26-N26","v":0},{"$f":"E26-O26","v":0}]
[null,"散船小计",{"$nulls":11},{"$f":"SUM(N25:N26)","v":0},{"$f":"SUM(O25:O26)","v":0},{"$error":"#DIV/0!"},{"$f":"SUM(Q25:Q26)","v":0},{"$f":"SUM(R25:R26)","v":0}]
[null,"小计","是",{"$nulls":10},{"$f":"SUM(N22,N25)","v":0},{"$f":"SUM(O22,O25)","v":0},{"$error":"#DIV/0!"},{"$f":"SUM(Q22,Q25)","v":0},{"$f":"SUM(R22,R25)","v":0}]
[null,null,"否",{"$nulls":10},{"$f":"SUM(N23,N26)","v":0},{"$f":"SUM(O23,O26)","v":0},{"$error":"#DIV/0!"},{"$f":"SUM(Q23,Q26)","v":0},{"$f":"SUM(R23,R26)","v":0}]
[null,"。。。",{"$nulls":11},{"$f":"SUM(N28:N29)","v":0},{"$f":"SUM(O28:O29)","v":0},{"$error":"#DIV/0!"},{"$f":"SUM(Q28:Q29)","v":0},{"$f":"SUM(R28:R29)","v":0}]
["合计","集装箱","是",{"$f":"SUM(D4,D13)","v":107},76808.733,11,3837.71,14,10137.59,{"$nulls":4},{"$f":"SUM(N4,N13)","v":25},{"$f":"SUM(O4,O13)","v":13975.3},0.181949362450752,{"$f":"SUM(Q4,Q13)","v":82},{"$f":"SUM(R4,R13)","v":62833.433}]
[null,null,"否",{"$f":"SUM(D5,D14)","v":151},81182.392,49,21676.062,32,13563.131,{"$nulls":4},{"$f":"SUM(N5,N14)","v":81},{"$f":"SUM(O5,O14)","v":35239.193},0.434074337203565,{"$f":"SUM(Q5,Q14)","v":70},{"$f":"SUM(R5,R14)","v":45943.199}]
[null,"集装箱合计",null,{"$f":"SUM(D31:D32)","v":258},{"$f":"SUM(E31:E32)","v":157991.125},60,25513.772,46,23700.721,{"$nulls":4},106,49214.493,0.311501630233977,{"$f":"SUM(Q31:Q32)","v":152},{"$f":"SUM(R31:R32)","v":108776.632}]
[null,"散船","是",{"$f":"SUM(D7,D16)","v":9},69934.15,3,6015.76,1,5665,{"$nulls":4},{"$f":"SUM(N7,N16)","v":4},{"$f":"SUM(O7,O16)","v":11680.76},0.167025122919203,{"$f":"SUM(Q7,Q16)","v":5},{"$f":"SUM(R7,R16)","v":58253.39}]
[null,null,"否",{"$f":"SUM(D8,D17)","v":14},354244.36,1,7000,0,0,{"$nulls":4},{"$f":"SUM(N8,N17)","v":1},{"$f":"SUM(O8,O17)","v":7000},0.019760371061377,{"$f":"SUM(Q8,Q17)","v":13},{"$f":"SUM(R8,R17)","v":347244.36}]
[null,"散船合计",null,{"$f":"SUM(D34:D35)","v":23},{"$f":"SUM(E34:E35)","v":424178.51},4,13015.76,1,5665,{"$nulls":4},5,18680.76,0.0440398548243286,18,405497.75]
[null,"小计","是",{"$f":"SUM(D31,D34)","v":116},{"$f":"SUM(E31,E34)","v":146742.883},14,9853.47,15,15802.59,{"$nulls":4},29,25656.06,0.174836826669134,87,121086.823]
[null,null,"否",{"$f":"SUM(D32,D35)","v":165},435426.752,50,28676.062,32,13563.131,{"$nulls":4},82,42239.193,0.0970064260084782,83,393187.559]
[null,"合计",null,{"$f":"SUM(D37:D38)","v":281},{"$f":"SUM(E37:E38)","v":582169.635},64,38529.532,47,29365.721,{"$nulls":4},111,67895.253,0.116624517869263,{"$f":"SUM(Q37:Q38)","v":170},{"$f":"SUM(R37:R38)","v":514274.382}]

{"sheet":"月度回款统计","index":29,"n_rows":73,"n_cols":11,"rows_kept":73,"cut":false,"hidden":false,"merged":[[1,3,1,4]]}
["公司名：","选帐套名",null,null,"期间（会计期）","***年***月**日---***年***月**日"]
[]
[{"$nulls":6},"业务系统出纳取数"]
["结算单位","求和项:未收款金额","求和项:未开票金额","未收款比例","未开票比例",null,"第一周回款","第二周回款","第三周回款","第四周回款","小计"]
["厦门建发原材料贸易有限公司",819.190777,849.256183,0.318480962831041,0.257818688476272,{"$f":"67252.2","v":67252.2},{"$f":"F5/10000","v":6.72522},null,null,null,{"$f":"SUM(G5:J5)","v":6.72522}]
["厦门建发物产有限公司",458.788409,429.355602,0.178365502074057,0.130344530205887,2095564.04,209.556404,null,null,null,{"$f":"SUM(G6:J6)","v":209.556404}]
["深圳市中金岭南有色金属股份有限公司",181.98909,59.097171,0.0707528235456171,0.0179408233049956,2434590.36,243.459036,null,null,null,243.459036]
["云南元佳富农业科技有限公司",129.532482,22.979274,0.0503590015213935,0.00697608849180071,{"$f":"380000","v":380000},38,null,null,null,38]
["天津建源供应链管理有限公司",101.210719,110.524846,0.0393482057427289,0.0335533275001919,506858.73,50.685873,null,null,null,50.685873]
["湖南宇腾有色金属股份有限公司",100.826996,1214.490716,0.039199023725118,0.368697231569909,null,0,null,null,null,0]
["广州东凌贸易有限公司",91.28042,91.28042,0.0354875529186065,0.0277110707452609,null,0,null,null,null,0]
["双胞胎饲料有限公司",89.707756,89.138572,0.0348761402727014,0.0270608447553543,{"$f":"5691.84","v":5691.84},0.569184,0.6,null,null,1.169184]
["深圳市盛康源贸易有限公司",68.525518,5.767297,0.0266410139389455,0.00175084618558866,null,0,35.5,null,null,35.5]
["厦门市明穗粮油贸易有限公司",64.155553,55.981906,0.0249420804824294,0.0169950856670088,null,0,8.2,null,null,8.2]
["新谷（上海）贸易有限公司",55.91429,55.91429,0.0217380827704486,0.0169745586825853,null,0,36.7,null,null,36.7]
["厦门建发农产品有限公司",47.019706,30.447897,0.0182800901320603,0.00924342622230943,{"$f":"165718.09","v":165718.09},16.571809,null,null,null,16.571809]
["上海海申国际物流有限公司",41.161859,23.067334,0.0160027051436796,0.00700282190176779,null,0,null,null,null,0]
["广东恒兴饲料实业股份有限公司",36.282794,0,0.0141058462714117,0,null,0,null,null,null,0]
["中牧农业连锁发展有限公司",35.298467,43.59507,0.0137231644329986,0.0132346681677692,null,0,5.7,"预估仓租原因",null,5.7]
["建发物流集团有限公司",27.513352,0,0.0106965057037455,0,562645.28,56.264528,{"$f":"23.5+46.3","v":69.8},null,null,126.064528]
["中国国投国际贸易有限公司",24.731452,24.731452,0.00961497231940843,0.00750801777648509,null,0,null,null,null,0]
["广州东凌国际投资股份有限公司",23.523222,23.523222,0.00914524260012309,0.00714122118411022,null,0,null,null,null,0]
["安徽安粮国际发展有限公司",22.471662,5.016294,0.00873642227318891,0.00152285537153563,null,0,0.4,null,null,0.4]
["北京嘉粮益谷饲料有限公司",21.824813,4.964939,0.00848494348262904,0.00150726493014499,{"$f":"60000","v":60000},6,10.5,null,null,16.5]
["东莞嘉吉粮油有限公司",19.976232,0.211,0.00776626125116791,6.40557517948543e-5,null,0,null,null,null,0]
["东莞顶志食品有限公司",16.031114,6.922444,0.00623249768591351,0.00210152774728805,91086.7,9.10867,null,null,null,9.10867]
["广州市中川货运运输代理有限公司",14.554075,14.554075,0.00565826171417571,0.0044183517336668,119918.33,11.991833,null,null,null,11.991833]
["辽宁丰元天利农业生产资料有限公司",14.510835,0,0.00564145107959254,0,null,0,null,null,null,0]
["广州市粮食集团有限责任公司",12.042696,0,0.00468190014444161,0,120426.96,12.042696,null,null,null,12.042696]
["招远市宝发食品有限公司",12.017465,0,0.00467209096030673,0,null,0,null,null,null,0]
["湖南湘利来化工有限公司",10.075384,8.786896,0.00391705825712985,0.00266754137072606,null,0,null,null,null,0]
["新兴铸管（上海）金属资源有限公司",9.33008,9.190007,0.00362730262515457,0.0027899185184122,null,0,null,null,null,0]
["湛江嘉泰贸易有限公司",9.109525,2.464685,0.00354155634363721,0.000748233415225121,{"$f":"50345.16","v":50345.16},5.034516,3.7,null,null,8.734516]
["福州建发实业有限公司",8.898872,2.547257,0.00345965970594685,0.000773300768482015,null,0,2.1,null,null,2.1]
["青岛建发国际货运代理有限公司",7.780147,0,0.00302472729464146,0,null,0,null,null,null,0]
["湛江嘉冠禾贸易有限公司",7.598497,1.076597,0.00295410630658111,0.000326835214289501,{"$f":"59041","v":59041},5.9041,1.07,null,null,6.9741]
["建发物流（青岛）有限公司",7.396545,0,0.00287559239530357,0,null,0,null,null,null,0]
["厦门启润实业有限公司",7.042852,7.042852,0.00273808536991913,0.00213808142009428,null,0,null,null,null,0]
["苏州环秀湖国际贸易有限公司",6.712497,0.0134300000000003,0.00260965157741865,4.07710306447826e-6,null,0,null,null,null,0]
["大连金易鸿嘉有限公司",6.494525,0,0.0025249094999641,0,64945.25,6.494525,null,null,null,6.494525]
["成都金色纤维科技有限公司",6.247305,0.711646,0.00242879652379092,0.000216042746643606,null,0,null,null,null,0]
["广州市富人米贸易有限公司",5.3344,5.3344,0.00207388180607642,0.00161942655153778,null,0,null,null,null,0]
["广州星屏食品有限公司",4.329238,0,0.00168309986547216,0,43292.38,4.329238,null,null,null,4.329238]
["广东新供销天成供应链有限公司",3.601054,1.2631,0.00140000006997952,0.000383454123659149,null,0,null,null,null,0]
["国投俊杰农产品（北京）有限公司",3.382882,3.382882,0.0013151802324354,0.00102698127840417,null,0,null,null,null,0]
["天津信隆海铁进出口贸易有限公司",3.221522,6.006122,0.00125244748250746,0.00182334909991286,null,0,null,null,null,0]
["漳州美豆饲料科技有限公司",2.5,2.5,0.000971937709056512,0.000758954405152302,null,0,null,null,null,0]
["荣成市蓝海海洋生物科技有限公司",2.460779,2.460779,0.000956689559642065,0.000747047624862511,null,0,null,null,null,0]
["广西双胞胎饲料有限公司",1.476598,-0.0616149999999994,0.000574064509811061,-1.87051902693835e-5,null,0,null,null,null,0]
["重庆禾睿康粮油有限公司",1.411598,0,0.000548794130491502,0,null,0,null,null,null,0]
["北大荒米业集团国际米业（北京）有限公司",1.292266,0,0.000502400821236044,0,12922.66,1.292266,null,null,null,1.292266]
["双胞胎（集团）股份有限公司",0.639,0.639,0.000248427277951933,0.000193988745956928,null,0,null,null,null,0]
["晋宇国际货代（中国）有限公司",0.501621,0.501620999999999,0.000195017745842764,0.000152282987066761,null,0,null,null,null,0]
["建发物流集团有限公司",0.385243,78.186421,0.000149772879540023,0.023735971456417,178182,17.8182,null,null,null,17.8182]
["双胞胎（集团）股份有限公司",0.314063,0.262837,0.000122099868850419,7.97925195948063e-5,null,0,null,null,null,0]
["广东俊杰农产品有限公司",0.285491,0.285491,0.000110991787398501,8.66698608325344e-5,null,0,null,null,null,0]
["青岛柏尊贸易有限公司",0.218571,0.218570999999999,8.49749586372956e-5,6.63541693154173e-5,null,0,null,null,null,0]
["厦门港务贸易有限公司",0.21632,0,8.40998259257623e-5,0,null,0,null,null,null,0]
["广州江兆进出口有限公司",0.191629,0.936078,7.45005803546963e-5,0.000284176208666463,null,0,null,null,null,0]
["广州半边旗化工有限公司",0.181679,0.34205,7.06322682801709e-5,0.000103840141712938,1816.79,0.181679,null,null,null,0.181679]
["通威股份有限公司",0.15406,0.15406,5.98946892664707e-5,4.67698062631055e-5,null,0,null,null,null,0]
["武汉东周化工有限公司",0.125868,0.742031,4.89343421302878e-5,0.000225267078483827,null,0,null,null,null,0]
["上海海申国际物流有限公司",0.063753,0.26795,2.47855778580118e-5,8.13447331442238e-5,null,0,null,null,null,0]
["厦门夏商国际贸易有限公司",0.00504,0.00503999999999996,1.95942641764905e-6,1.53005208078703e-6,null,0,null,null,null,0]
["厦门国贸集团股份有限公司",-2.924029,-2.924029,-0.00113678961678014,-0.000887681876137232,null,0,null,null,null,0]
["中粮饲料有限公司",-4.055324,0.849360000000001,-0.00157660892721676,0.000257850205424064,null,0,null,null,null,0]
["广州市华壬谷物贸易有限公司",-69.9,0,-0.0271753782923945,0,null,0,null,null,null,0]
["合计",{"$f":"SUM(B5:B67)","v":2572.181305},{"$f":"SUM(C5:C67)","v":3294.005523},{"$f":"SUM(D5:D67)","v":1.00000000149619},{"$f":"SUM(E5:E67)","v":1.00000000091074},null,{"$f":"SUM(G5:G67)","v":702.029777},{"$f":"SUM(H4:H67)","v":174.27}]
[]
["未收款比例数值","未收款比例客户（单位：个）"]
[">1%",16]
[">0.1%",26]
["<0.1%",21]

{"sheet":"港口对账单统计","index":30,"n_rows":3,"n_cols":27,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,10,0,13],[0,18,0,21],[57,2,57,6],[58,2,58,6],[59,2,59,6],[63,1,63,25],[0,14,1,14],[0,15,1,15],[0,16,1,16],[0,17,1,17],[0,22,1,22],[0,23,1,23],[0,24,1,24],[0,25,1,25],[0,26,1,26]]}
[{"$nulls":10},"应收款",null,null,null,"已收款","未收款","已开票","未开票","应付款",null,null,null,"已付款","未付款","已回票","未回票","已收款-已付款"]
["卸货码头","业务号","客户","信用额度","配额","结算单位","船名","到港日期","货名","货量","港建费","港口费","堆存","合计",{"$nulls":4},"港建费","港口费","堆存","合计"]
["新港","QYB1705012","厦门建发股份有限公司",null,null,"广州港股份有限公司新港分公司","托帕斯","2017.6.17","玉米",65300.068,182843,{"$f":"3246211","v":3246211},{"$f":"52764+23+45+1843+1925+10771+112044+50076+32814","v":262305},{"$f":"SUM(K3:M3)","v":3691359},{"$f":"3182842+246212+251265+11040","v":3691359},{"$f":"N3-O3","v":0},null,null,182843,{"$f":"3246211","v":3246211},{"$f":"52764+23+45+1843+1925+10771+112044+50076+32814","v":262305},{"$f":"SUM(S3:U3)","v":3691359},{"$f":"3182842+246212+251265+11040","v":3691359},{"$f":"V3-W3","v":0}]

{"sheet":"商务KPI","index":31,"n_rows":65,"n_cols":41,"rows_kept":65,"cut":false,"hidden":false,"merged":[]}
["状态","业务计费完结","流向计费完结","开票完结","收款完结","结算单位","业务号","头程提单号","船名","装卸码头","货名","柜量","柜型","吨数","应收金额","已收款金额","未收款金额","已开票金额","未开票金额","请求报价时间","报价时间","报价时效标准天数","标价时效","ATA卸货码头","业务完结时间","业务创建时间","流向完结日期","流向计费完结日期","流向计费时效标准天数","流向计费时效","清货完结日期","清货计费完成日期","清货计费时效标准天数","清货计费时效","收款完结日期","流向收款时效标准天数","流向收款时效","清货收款时效标准天数","清货收款时效","商务员","计费员"]
["业务完结","√","√","√","√","福州建发实业有限公司","QYIC18060138F01","NSSLHCHGC1800103","博石航88/520101807050","黄埔老港码头","米糠",23,"20GP*23",540.06,43308.7,43308.7,0,43308.7,0,"2018-06-29T13:15:26","2018-06-29T16:11:59",1,0.1,"2018-07-05","2019-03-25","2018-06-29","2018-08-01","2018-08-02",3,2,"2019-03-25","2018-09-27",3,-178,"2018-11-05",70,96,70,40,"周翠",""]
["业务完结","","√","","","云南元佳富农业科技有限公司","QYIC18070044F01","ONEYLIMU03093500","/","乌冲码头","鱼粉",18,"40HQ*18",475.25,178207.08,0,178207.08,144836.36,33370.72,"2018-07-18T16:51:55","2018-07-19T15:57:35",1,1,"2018-08-08","2019-03-26","2018-07-11","2018-09-02","2018-09-03",3,2,"2019-03-26",null,3,null,null,70,null,70,null,"罗东明",""]
["业务完结","","√","","","云南元佳富农业科技有限公司","QYIC18080031F01","COSU8012088910","NORTHERN JASPER/0370-002W","乌冲码头","鱼粉",19,"40GP*19",495.64,119048.96,0,119048.96,116708.74,2340.22,"2018-08-07T17:03:39","2018-08-08T08:46:42",1,0.7,"2018-08-24","2019-03-21","2018-08-07","2018-08-30","2018-08-31",3,2,"2019-03-21",null,3,null,null,70,null,70,null,"罗东明",""]
["业务完结","","√","","","云南元佳富农业科技有限公司","QYIC18080041F01","ONEYLIMU04336600","/","乌冲码头","鱼粉",19,"40HQ*19",496.04,143699.49,0,143699.49,123788.37,19911.12,"2018-08-09T16:04:04","2018-08-13T08:52:54",1,3.7,"2018-09-03","2019-03-21","2018-08-09","2018-09-30","2018-10-08",3,9,"2019-03-21",null,3,null,null,70,null,70,null,"罗东明",""]
["业务完结","","√","","","中牧农业连锁发展有限公司","QYIC18080096F01","EGLV751800026119","/","乌冲码头","鱼粉",19,"40HQ*19",497.39,124398.17,94070.59,30327.58,94070.59,30327.58,"2018-08-27T09:29:54","2018-08-27T09:35:35",1,0,"2018-09-28","2019-03-28","2018-08-24","2018-10-19","2018-10-19",3,1,"2019-03-28",null,3,null,null,70,null,70,null,"林彩凤",""]
["业务完结","√","√","√","√","北京嘉粮益谷饲料有限公司","QYD18090038TH01","*","/","","米糠",null,"20GP*1",22,1028.97,1028.97,0,1028.97,0,"2018-09-20T14:36:17","2018-09-20T14:37:42",1,0,null,"2019-03-27","2018-09-19",null,"2018-10-11",3,null,"2019-03-27","2018-10-11",3,-166,"2018-12-13",70,64,70,64,"罗东明",""]
["业务完结","","√","","","厦门建发物产有限公司","QYIC18100140F01","SMLMVAN8A0870400","/","南沙二期码头","菜籽粕",100,"20HQ*100",2130.59,225154.72,225154.72,0,225154.72,0,"2018-10-30T18:18:01","2018-10-30T18:27:31",1,0,"2018-11-05","2019-03-27","2018-10-25","2018-11-29","2018-12-05",3,7,"2019-03-27",null,3,null,null,70,null,70,null,"周翠",""]
["业务完结","","√","","","上海海申国际物流有限公司","QYIC18110015F01","YMLUS505003528","/","乌冲码头","低压高密度聚乙烯HDPE",5,"40HQ*5",130.815,17278.3,17278.3,0,17278.3,0,"2018-11-02T18:47:27","2018-11-05T08:41:37",1,2.6,"2018-11-12","2019-03-28","2018-11-02","2018-11-29","2018-11-30",3,2,"2019-03-28",null,3,null,null,70,null,70,null,"罗东明",""]
["业务完结","","","","","中粮饲料有限公司","QYIB18110030F01","","","黄埔新港码头","棕榈粕",0,"",3700,513111.55,463928.42,49183.13,463928.42,49183.13,"2018-11-26T10:57:12","2018-11-26T11:27:56",1,0,"2019-01-11","2019-03-26","2018-11-26T10:56:03",null,null,3,null,"2019-03-26",null,3,null,null,70,null,70,null,"罗东明",""]
["业务完结","√","√","","","厦门国贸集团股份有限公司","QYIC18110128F01","OEA0147054","/","乌冲码头","葵花籽粕",9,"40HQ*9",243.27,60743.12,29391.52,31351.6,29391.52,31351.6,"2018-12-06T10:40:06","2018-12-25T15:05:11",1,19.2,"2019-01-04","2019-03-25","2018-11-27","2019-01-29","2019-01-29",3,1,"2019-03-25","2019-03-12",3,-12,null,70,null,70,null,"林彩凤",""]
["业务完结","","√","","","福州建发实业有限公司","QYIC18120008F01","OOLU2613699700","/","乌冲码头","鱼粉",17,"20GP*17",301.855,66204.24,57502.79,8701.45,57502.79,8701.45,"2018-12-04T16:59:21","2018-12-13T11:23:04",1,8.8,"2018-12-21","2019-03-28","2018-12-04","2018-12-28","2018-12-29",3,2,"2019-03-28",null,3,null,null,70,null,70,null,"周翠",""]
["业务完结","","√","","","新谷（上海）贸易有限公司","QYIC18120012F01","HLCUMTR181120392","/","乌冲码头","菜籽粕",54,"20GP*54",1295.665,87272.88,83764.88,3508,87272.88,0,"2018-12-05T14:58:24","2018-12-29T21:56:34",1,24.3,"2019-01-06","2019-03-27","2018-12-05","2019-02-02","2019-02-11",3,10,"2019-03-27",null,3,null,null,70,null,70,null,"周翠",""]
["业务完结","√","√","","","厦门国贸集团股份有限公司","QYIC18120018F01","OEA0147816","/","乌冲码头","葵花籽粕",8,"40HQ*8",228.45,55783.39,26687.45,29095.94,26687.45,29095.94,"2018-12-24T18:26:00","2018-12-25T15:08:41",1,0.9,"2019-01-04","2019-03-25","2018-12-06","2019-01-25","2019-01-24",3,0,"2019-03-25","2019-03-12",3,-12,null,70,null,70,null,"林彩凤",""]
["业务完结","","√","","","广东新供销天成供应链有限公司","QYIC18120056F01","COSU8016660490","/","乌冲码头","豌豆",80,"20GP*80",2191.3,297344.55,266878.61,30465.94,266878.61,30465.94,"2018-12-13T10:22:35","2018-12-13T14:58:06",1,0.2,"2018-12-22","2019-03-25","2018-12-13","2019-02-28","2019-01-22",3,-36,"2019-03-25",null,3,null,null,70,null,70,null,"吴燕钗",""]
["业务完结","","√","","","广东新供销天成供应链有限公司","QYIC18120075F01","SUDU28004AE26XCA","/","乌冲码头","豌豆",30,"20GP*30",825,111480.9,81921.1,29559.8,81921.1,29559.8,"2018-12-17T18:31:13","2018-12-18T09:10:02",1,0.6,"2019-01-01","2019-03-25","2018-12-17","2019-02-02","2019-01-22",3,-10,"2019-03-25",null,3,null,null,70,null,70,null,"吴燕钗",""]
["业务完结","","√","","","广东新供销天成供应链有限公司","QYIC18120076F01","SUDU28004AE43X7U","/","乌冲码头","豌豆",25,"20GP*25",687.5,107902.08,81843.74,26058.34,81843.74,26058.34,"2018-12-17T18:40:06","2018-12-18T08:57:26",1,0.6,"2018-12-31","2019-03-25","2018-12-17","2019-02-28","2019-01-22",3,-36,"2019-03-25",null,3,null,null,70,null,70,null,"吴燕钗",""]
["业务完结","√","√","","","新谷（上海）贸易有限公司","QYIC18120088F01","OEA0147571","/","乌冲码头","葵花籽粕（颗粒）",36,"40HQ*36",1031.66,183605.58,0,183605.58,169194.76,14410.82,"2018-12-19T10:41:31","2019-01-07T10:28:18",1,19,"2019-01-16","2019-03-25","2018-12-19","2019-02-13","2019-02-14",3,2,"2019-03-25","2019-03-14",3,-10,null,70,null,70,null,"周翠",""]
["业务完结","","√","","","天津建源供应链管理有限公司","QYIC18120123F01","MEDUMT168959","/","东江仓码头","大豆",99,"20HQ*99",2448.39,163011.94,0,163011.94,0,163011.94,"2018-12-28T11:51:54","2018-12-28T14:31:29",1,0.1,"2019-01-03","2019-03-25","2018-12-26","2019-01-25","2019-01-28",3,4,"2019-03-25",null,3,null,null,70,null,70,null,"周翠",""]
["业务完结","","√","","","新谷（上海）贸易有限公司","QYIC19010009F01","COSU8006099860","/","乌冲码头","菜籽粕",73,"20GP*73",1747.23,88635.56,87619.56,1016,87875.56,760,"2019-01-03T18:12:18","2019-01-07T08:53:50",1,3.6,"2019-01-16","2019-03-27","2019-01-02","2019-02-18","2019-02-20",3,3,"2019-03-27",null,3,null,null,70,null,70,null,"周翠",""]
["业务完结","","","√","√","安徽安粮国际发展有限公司","QYIC19010069F01","LCHCB19000178","/","黄埔老港码头","泰国茉莉香米",2,"20GP*2",35.19,2484,6844.91,-4360.91,2484,0,"2019-01-09T14:57:45","2019-01-11T18:09:09",1,2.1,"2019-01-18","2019-03-25","2019-01-09","2019-02-26",null,3,null,"2019-03-25",null,3,null,"2019-03-18",70,null,70,null,"吴燕钗",""]
["业务完结","","","√","√","安徽安粮国际发展有限公司","QYIC19010069F01","LCHCB19000178","/","黄埔老港码头","泰国茉莉香米",2,"20GP*2",35.19,4360.91,6844.91,-2484,4360.91,0,"2019-01-09T14:57:45","2019-01-11T18:09:09",1,2.1,"2019-01-18","2019-03-25","2019-01-09","2019-02-26",null,3,null,"2019-03-25",null,3,null,"2019-03-18",70,null,70,null,"吴燕钗",""]
["业务完结","","","","","厦门纳新贸易有限公司","XMIC19010042F01","PCSLHPXMC1800114","PEGASUS ZETTA/0070W","海天码头","棉纱",2,"40HQ*2",45.356,9193.84,0,9193.84,0,9193.84,"2019-01-10T10:20:08","2019-01-10T10:29:18",1,0,"2019-01-01","2019-03-28","2019-01-10","2019-01-21",null,3,null,"2019-03-28",null,3,null,null,70,null,70,null,"黄倩琳",""]
["业务完结","","","","","国投俊杰农产品（北京）有限公司","QYIC19010081F01","COSU8020548480","/","乌冲码头","乳清粉",8,"40GP*8",203,25788.18,23232.6,2555.58,0,25788.18,"2019-01-16T14:45:47","2019-01-16T14:49:15",1,0,"2019-01-31","2019-03-25","2019-01-14","2019-02-21",null,3,null,"2019-03-25",null,3,null,null,70,null,70,null,"吴燕钗",""]
["业务完结","√","√","","","湖南宇腾有色金属股份有限公司","QYIC19010098F01","579962670","/","东江仓码头","银精矿",35,"20GP*35",937.845,121180.82,0,121180.82,0,121180.82,"2019-01-18T11:56:51","2019-01-18T17:52:20",1,0.2,"2019-02-01","2019-03-25","2019-01-17","2019-03-01","2019-02-02",3,-26,"2019-03-25","2019-03-06",3,-18,null,70,null,70,null,"林彩凤",""]
["业务完结","","","","","厦门恒圳贸易有限公司","XMIC19010098F01","MEDUCO322191","MURCIA MAERSK/851EI","嵩屿码头","板材",7,"40HQ*7",162.275,25243.6,25243.6,0,25243.6,0,"2019-01-25T10:55:45","2019-01-25T10:56:11",1,0,"2019-01-28","2019-03-28","2019-01-23","2019-02-01",null,3,null,"2019-03-28",null,3,null,null,70,null,70,null,"黄倩琳",""]
["业务完结","","","","","广东新供销天成供应链有限公司","QYD19010096TH01","*","/","","豌豆",null,"*1",30,2788.54,0,2788.54,0,2788.54,"2019-01-28T16:52:51","2019-02-14T15:31:27",1,16.9,null,"2019-03-25","2019-01-28",null,null,3,null,"2019-03-25",null,3,null,null,70,null,70,null,"吴燕钗",""]
["业务完结","√","","","","厦门建发物产有限公司","QYIC19010146F01","OEA0149148","/","南沙二期码头","葵花籽粕",9,"40HQ*9",254.99,26870.81,0,26870.81,0,26870.81,"2019-02-11T14:05:49","2019-02-11T17:25:46",1,0.1,"2019-03-09","2019-03-23","2019-01-31","2019-03-23",null,3,null,"2019-03-23","2019-03-27",3,5,null,70,null,70,null,"周翠",""]
["业务完结","","√","","","厦门建发农产品有限公司","QYIC19010149F01","MEDUOD021665","/","南沙二期码头","葵花籽粕",35,"40GP*35",983.15,80016.75,0,80016.75,0,80016.75,"2019-01-31T10:06:20","2019-01-31T10:15:30",1,0,"2019-01-31","2019-03-25","2019-01-31","2019-02-18","2019-02-20",3,3,"2019-03-25",null,3,null,null,70,null,70,null,"周翠",""]
["业务完结","","","","","厦门建发物产有限公司","HKIC19010004F01","HLCUOD1181202655","/","海口港集装箱码头","葵花籽粕（颗粒）",17,"40HQ*17",481.07,78811.1,0,78811.1,0,78811.1,"2019-02-11T14:05:32","2019-02-11T17:14:36",1,0.1,"2019-03-02","2019-03-25","2019-01-31","2019-03-19",null,3,null,"2019-03-25",null,3,null,null,70,null,70,null,"周翠",""]
["业务完结","","","","","厦门恒圳贸易有限公司","XMIC19020002F01","GTG0246768","CMA CGM GEORG FORSTER /0FL28E1MAI","远海码头","板材",6,"40HQ*6",142.72,17196.48,16890.48,306,16890.48,306,"2019-02-11T08:36:40","2019-02-11T08:37:49",1,0,"2019-02-06","2019-03-28","2019-02-02","2019-03-28",null,3,null,"2019-03-28",null,3,null,null,70,null,70,null,"黄倩琳",""]
["业务完结","√","√","","","广东源信饲料实业有限公司","QYIC19020012F01","ZIMUOSS804540","/","乌冲码头","葵花籽粕（颗粒）",10,"40HQ*10",285.84,39469.24,0,39469.24,0,39469.24,"2019-02-11T15:07:24","2019-02-11T16:14:32",1,0,"2019-02-28","2019-03-23","2019-02-11","2019-03-23","2019-03-28",3,6,"2019-03-23","2019-03-28",3,6,null,70,null,70,null,"林彩凤",""]
["业务完结","","","","","江苏国泰华博进出口有限公司","QYIC19020016F01","HDMUTHGJ1048406","/","乌冲码头","木薯淀粉",20,"20GP*20",381.14,47735.48,0,47735.48,0,47735.48,"2019-02-13T15:04:27","2019-02-13T15:08:46",1,0,"2019-02-18","2019-03-26","2019-02-11","2019-03-26",null,3,null,"2019-03-26",null,3,null,null,70,null,70,null,"周翠",""]
["业务完结","","","","","厦门建发农产品有限公司","QYIB19020004F01","","","黄埔新港码头","棕榈粕",0,"",5199.39,190339.28,0,190339.28,180000,10339.28,"2019-02-13T09:34:52","2019-02-14T14:18:14",1,1.2,"2019-02-20T18:00:00","2019-03-25","2019-02-12T10:59:10",null,null,3,null,"2019-03-25",null,3,null,null,70,null,70,null,"周翠",""]
["业务完结","","","","","厦门建发农产品有限公司","QYIB19020004F01","","","黄埔新港码头","棕榈粕",0,"",5199.39,149143.32,0,149143.32,97818.74,51324.58,"2019-02-13T09:34:52","2019-02-14T14:18:14",1,1.2,"2019-02-20T18:00:00","2019-03-25","2019-02-12T10:59:10",null,null,3,null,"2019-03-25",null,3,null,null,70,null,70,null,"周翠",""]
["业务完结","√","√","","","北京嘉粮益谷饲料有限公司","QYIC19020026F01","COSU8020589310","/","南沙二期码头","米糠",38,"40GP*38",968.722,204735.74,160000,44735.74,150748.9,53986.84,"2019-02-13T17:43:20","2019-02-14T08:54:16",1,0.6,"2019-02-27","2019-03-23","2019-02-13","2019-03-23","2019-03-25",3,3,"2019-03-23","2019-03-25",3,3,null,70,null,70,null,"罗东明",""]
["业务完结","","√","","","建发物流（上海）有限公司","GXIB19020001F01","","","钦州港","锰矿",0,"",5500,237252.78,237252.78,0,237252.78,0,"2019-02-14T18:08:54","2019-02-15T17:16:59",1,1,"2019-02-08","2019-03-22","2019-02-14T18:04:59",null,"2019-03-28",3,null,"2019-03-22",null,3,null,null,70,null,70,null,"罗东明",""]
["业务完结","","","","","湛江嘉泰贸易有限公司","QYIC19020049F01","YGNCB19000682","/","乌冲码头","鱼粉",5,"20HQ*5",100.28,8829.6,0,8829.6,0,8829.6,"2019-02-25T15:48:53","2019-02-25T17:42:11",1,0.1,"2019-03-17","2019-03-25","2019-02-15","2019-03-25",null,3,null,"2019-03-25",null,3,null,null,70,null,70,null,"吴燕钗",""]
["业务完结","","","","","厦门建发物产有限公司","XMIC19020026F01","OOLU2614456361","DONG FANG XING/537WH","海润码头","豌豆",1,"20GP*1",27.353,1301.59,0,1301.59,0,1301.59,"2019-02-25T15:55:10","2019-02-25T15:55:59",1,0,"2019-02-27","2019-03-25","2019-02-15","2019-03-25",null,3,null,"2019-03-25",null,3,null,null,70,null,70,null,"黄倩琳",""]
["业务完结","√","√","","","双胞胎饲料有限公司","QYIC19020071F01","EGLV751900001622","/","乌冲码头","鱼粉",19,"40HQ*19",493.995,101240.58,363.37,100877.21,363.37,100877.21,"2019-02-20T16:27:39","2019-02-21T08:43:31",1,0.7,"2019-02-26","2019-03-25","2019-02-20","2019-03-06","2019-03-08",3,3,"2019-03-25","2019-03-08",3,-16,null,70,null,70,null,"罗东明",""]
["业务完结","","","","","湛江嘉泰贸易有限公司","QYIC19020073F01","ERU0101368","/","黄埔老港码头","鱼粉",16,"40HQ*16",422.16,37150.08,0,37150.08,0,37150.08,"2019-02-20T17:11:38","2019-02-21T16:34:12",1,1,"2019-03-05","2019-03-26","2019-02-20","2019-03-21",null,3,null,"2019-03-26",null,3,null,null,70,null,70,null,"吴燕钗",""]
["业务完结","","","","","新谷（上海）贸易有限公司","XMIC19020056F01","COSU8016673200","CSCL SATURN/0TX2DE1MAI","远海码头","菜粕",93,"20GP*93",1934.96,96748,0,96748,0,96748,"2019-02-27T09:10:07","2019-02-27T09:10:32",1,0,"2019-02-28","2019-03-25","2019-02-21","2019-03-25",null,3,null,"2019-03-25",null,3,null,null,70,null,70,null,"黄倩琳",""]
["业务完结","","","","","厦门建发物产有限公司","XMIC19020064F01","320910031735","NORDLILY/1902NI","海天码头","鱼粉",10,"20GP*10",200.48,18669.2,0,18669.2,0,18669.2,"2019-02-22T11:11:12","2019-02-22T11:13:49",1,0,"2019-02-24","2019-03-28","2019-02-22","2019-03-28",null,3,null,"2019-03-28",null,3,null,null,70,null,70,null,"黄倩琳",""]
["业务完结","","","","","厦门建发物产有限公司","XMIC19020069F01","ZIMUVAN0075983","OCTAVIA/28EI","海润码头","菜粕",70,"20GP*70",1445.84,48510,48510,0,0,48510,"2019-02-25T15:00:49","2019-02-25T15:01:18",1,0,"2019-02-26","2019-03-26","2019-02-22","2019-03-26",null,3,null,"2019-03-26",null,3,null,null,70,null,70,null,"黄倩琳",""]
["业务完结","","","","","厦门建发物产有限公司","XMIC19020069F01","ZIMUVAN0075983","OCTAVIA/28EI","海润码头","菜粕",70,"20GP*70",1445.84,92681.2,48510,44171.2,0,92681.2,"2019-02-25T15:00:49","2019-02-25T15:01:18",1,0,"2019-02-26","2019-03-26","2019-02-22","2019-03-26",null,3,null,"2019-03-26",null,3,null,null,70,null,70,null,"黄倩琳",""]
["业务完结","","","","","江苏杰龙农产品加工有限公司","QYIC19020095F01","COSU6163899690","KOTA MEGAH/0116E","南沙二期码头","棉籽粕",19,"40HQ*19",496.14,18853.32,0,18853.32,0,18853.32,"2019-02-27T11:33:25","2019-02-27T15:44:25",1,0.2,"2019-03-03","2019-03-23","2019-02-27","2019-03-23",null,3,null,"2019-03-23",null,3,null,null,70,null,70,null,"吴燕钗",""]
["业务完结","","","","","江苏杰龙农产品加工有限公司","QYIC19020095F01","COSU6163899690","KOTA MEGAH/0116E","南沙二期码头","棉籽粕",19,"40HQ*19",496.14,26199.08,0,26199.08,0,26199.08,"2019-02-27T11:33:25","2019-02-27T15:44:25",1,0.2,"2019-03-03","2019-03-23","2019-02-27","2019-03-23",null,3,null,"2019-03-23",null,3,null,null,70,null,70,null,"吴燕钗",""]
["业务完结","","","√","√","广州市富人米贸易有限公司","QYIC19020104F01","550910010021","KMTC DUBAI/1901E","乌冲码头","巴基斯坦大米",20,"20GP*20",501.2,10000,10000,0,10000,0,"2019-02-28T17:22:37","2019-03-01T08:57:36",1,0.6,"2019-03-06","2019-03-25","2019-02-28","2019-03-25",null,3,null,"2019-03-25",null,3,null,"2019-03-27",70,null,70,null,"吴燕钗",""]
["业务完结","","","","","广州市富人米贸易有限公司","QYIC19020105F01","550910010144","/","乌冲码头","巴基斯坦大米",40,"20HQ*40",1002.4,20000,0,20000,20000,0,"2019-02-28T17:33:02","2019-03-01T08:52:12",1,0.6,"2019-03-09","2019-03-23","2019-02-28","2019-03-23",null,3,null,"2019-03-23",null,3,null,null,70,null,70,null,"吴燕钗",""]
["业务完结","","","","","厦门恒圳贸易有限公司","XMIC19030001F01","579731457","MAERSK CABINDA/1902I","海润码头","板材",3,"40HQ*3",70.885,4001,0,4001,0,4001,"2019-03-01T17:44:39","2019-03-01T17:44:48",1,0,"2019-03-03","2019-03-28","2019-03-01","2019-03-28",null,3,null,"2019-03-28",null,3,null,null,70,null,70,null,"黄倩琳",""]
["业务完结","","","","","厦门恒圳贸易有限公司","XMIC19030002F01","580229625","MAERSK CABINDA/1902I","海润码头","板材",5,"40HQ*5",116.816,6601,0,6601,0,6601,"2019-03-01T17:47:22","2019-03-01T17:47:35",1,0,"2019-03-03","2019-03-27","2019-03-01","2019-03-27",null,3,null,"2019-03-27",null,3,null,null,70,null,70,null,"黄倩琳",""]
["业务完结","","","","","厦门恒圳贸易有限公司","XMIC19030003F01","580155786","MAERSK CABINDA/1902I","海润码头","板材",8,"40HQ*8",190.409,10501,0,10501,0,10501,"2019-03-01T17:49:23","2019-03-01T17:49:30",1,0,"2019-03-03","2019-03-27","2019-03-01","2019-03-27",null,3,null,"2019-03-27",null,3,null,null,70,null,70,null,"黄倩琳",""]
["业务完结","","","","","厦门恒圳贸易有限公司","XMIC19030005F01","580229643","MAERSK CABINDA/1902I","海润码头","板材",15,"40HQ*15",349.056,19803,0,19803,0,19803,"2019-03-01T17:50:56","2019-03-01T17:51:03",1,0,"2019-03-03","2019-03-28","2019-03-01","2019-03-28",null,3,null,"2019-03-28",null,3,null,null,70,null,70,null,"黄倩琳",""]
["业务完结","","","","","广州棕宝国际贸易有限公司","XMIC19030007F01","1449X00619","WAN HAI 103/S233","","天然椰丝（椰壳纤维）",6,"40HQ*6",115.14,37310.94,27146.87,10164.07,0,37310.94,"2019-03-01T17:53:02","2019-03-01T17:53:11",1,0,"2019-03-03","2019-03-28","2019-03-01","2019-03-28",null,3,null,"2019-03-28",null,3,null,null,70,null,70,null,"黄倩琳",""]
["业务完结","","","","","广州棕宝国际贸易有限公司","XMIC19030007F01","1449X00619","WAN HAI 103/S233","","天然椰丝（椰壳纤维）",6,"40HQ*6",115.14,27146.87,27146.87,0,27146.87,0,"2019-03-01T17:53:02","2019-03-01T17:53:11",1,0,"2019-03-03","2019-03-28","2019-03-01","2019-03-28",null,3,null,"2019-03-28",null,3,null,null,70,null,70,null,"黄倩琳",""]
["业务完结","","","","","湖南湘利来化工有限公司","QYIC19030001F01","BKKCB1900130901","/","乌冲码头","木薯淀粉",10,"20GP*10",190.76,15833.08,0,15833.08,0,15833.08,"2019-03-04T11:18:11","2019-03-04T11:25:44",1,0,"2019-03-03","2019-03-23","2019-03-01","2019-03-23",null,3,null,"2019-03-23",null,3,null,null,70,null,70,null,"周翠",""]
["业务完结","√","√","","","东莞嘉吉粮油有限公司","QYIC19030002F01","PKG900069100","/","集司码头","代可可脂",4,"20GP*4",82.8,9349.18,0,9349.18,0,9349.18,"2019-03-11T09:09:10","2019-03-11T09:23:21",1,0,"2019-03-10","2019-03-25","2019-03-01","2019-03-25","2019-03-20",3,-4,"2019-03-25","2019-03-25",3,1,null,70,null,70,null,"龙衍婷",""]
["业务完结","","","","","湖南湘利来化工有限公司","QYIC19030015F01","HDMUTHWB1064052","/","乌冲码头","木薯淀粉",30,"20GP*30",511.8,43262.59,0,43262.59,0,43262.59,"2019-03-04T17:52:51","2019-03-05T19:24:11",1,1.1,"2019-03-09","2019-03-25","2019-03-04","2019-03-25",null,3,null,"2019-03-25",null,3,null,null,70,null,70,null,"周翠",""]
["业务完结","","","","","厦门恒圳贸易有限公司","XMIC19030055F01","580207729","MSC REEF/FH905E","嵩屿码头","板材",5,"40HQ*5",119.667,6500,0,6500,0,6500,"2019-03-08T14:32:31","2019-03-08T14:32:46",1,0,"2019-03-11","2019-03-28","2019-03-08","2019-03-28",null,3,null,"2019-03-28",null,3,null,null,70,null,70,null,"黄倩琳",""]
["业务完结","","","","","厦门纳新贸易有限公司","XMIC19030061F01","GOSUNDL6034189","OOCL ATLANTA/104E","海天码头","棉纱",2,"40HQ*2",41.932,5244,0,5244,0,5244,"2019-03-13T09:16:57","2019-03-13T09:17:40",1,0,"2019-03-14","2019-03-28","2019-03-12","2019-03-28",null,3,null,"2019-03-28",null,3,null,null,70,null,70,null,"黄倩琳",""]
["业务完结","","","","","厦门海峡投资有限公司","XMIC19030084F01","GOSURQL6081084","SEAMAX STRATFORD/004E","海天码头","棉纱",1,"40HQ*1",20.726,2922,0,2922,0,2922,"2019-03-18T10:56:08","2019-03-18T10:57:32",1,0,"2019-03-17","2019-03-27","2019-03-18","2019-03-27",null,3,null,"2019-03-27",null,3,null,null,70,null,70,null,"黄倩琳",""]
["业务完结","","","","","厦门纳新贸易有限公司","XMIC19030098F01","454910003215","KMTC JAKARTA/1903NI","海天码头","棉纱",2,"40HQ*2",45.496,5773,0,5773,0,5773,"2019-03-20T09:28:35","2019-03-20T09:29:53",1,0,"2019-03-14","2019-03-28","2019-03-20","2019-03-28",null,3,null,"2019-03-28",null,3,null,null,70,null,70,null,"黄倩琳",""]
["业务完结","","","","","上海佳农香蕉实业有限公司","XMIC19030101F01","KMTCLCH2439572","TOKYO TOWER/19004NI","海天码头","鲜椰子",1,"40GP*1",21.451,13250.3,10881.3,2369,0,13250.3,"2019-03-20T15:08:16","2019-03-20T16:25:46",1,0.1,"2019-03-21","2019-03-22","2019-03-20",null,null,3,null,"2019-03-22",null,3,null,null,70,null,70,null,"",""]
["业务完结","","","","","上海佳农香蕉实业有限公司","XMIC19030115F01","KMTCLCH2441126","/","海天码头","鲜椰子",null,"40RF*1",21.42,2369,0,2369,0,2369,"2019-03-25T08:59:51","2019-03-25T14:07:16",1,0.2,"2019-03-26","2019-03-27","2019-03-25",null,null,3,null,"2019-03-27",null,3,null,null,70,null,70,null,"",""]
["业务完结","","","","","厦门太松新材料有限公司","XMIC19030116F01","EGLV003900654303","/","海天码头","聚甲醛POM",null,"20GP*1",20.24,1787,0,1787,0,1787,"2019-03-25T10:02:03","2019-03-25T14:08:47",1,0.2,"2019-03-23","2019-03-27","2019-03-25",null,null,3,null,"2019-03-27",null,3,null,null,70,null,70,null,"",""]

{"sheet":"平仓损益表","index":32,"n_rows":1,"n_cols":7,"rows_kept":1,"cut":false,"hidden":false,"merged":[[0,6,0,7],[0,9,0,10]]}
[{"$nulls":6},"应收"]

{"sheet":"本模板规则","index":33,"n_rows":62,"n_cols":5,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
["分类","报表统计范围","频度","推送方式","推送角色"]
["消息通知","股份合并、事业部、单体","每次","微信","财务总监"]
["待办事项","股份合并","每小时","短信","股份财务经理"]
["预警提醒","事业部","每天","系统在线","股份出纳"]
["每日业务一览","单体","每周",null,"股份公司副总经理"]
["我的报表",null,"每月",null,"股份公司总经理"]
["知识窗口",null,"每季度",null,"股份会计"]
[null,null,"每年",null,"股份资金经理"]
[{"$nulls":4},"广州侨益办单专员"]
[{"$nulls":4},"广州侨益报价员"]
[{"$nulls":4},"广州侨益操作经理"]
[{"$nulls":4},"广州侨益发卡专员"]
[{"$nulls":4},"广州侨益副总经理"]
[{"$nulls":4},"广州侨益黄埔通关内勤"]
[{"$nulls":4},"广州侨益客服经理"]
[{"$nulls":4},"广州侨益客服主管"]
[{"$nulls":4},"广州侨益控货复核"]
[{"$nulls":4},"广州侨益控货专员"]
[{"$nulls":4},"广州侨益联运经理"]
[{"$nulls":4},"广州侨益联运专员"]
[{"$nulls":4},"广州侨益南沙通关内勤"]
[{"$nulls":4},"广州侨益人力行政经理"]
[{"$nulls":4},"广州侨益人力行政专员"]
[{"$nulls":4},"广州侨益商务经理"]
[{"$nulls":4},"广州侨益商务主管"]
[{"$nulls":4},"广州侨益商务专员"]
[{"$nulls":4},"广州侨益市场经理"]
[{"$nulls":4},"广州侨益市场专员"]
[{"$nulls":4},"广州侨益通关经理"]
[{"$nulls":4},"广州侨益总经理"]
[{"$nulls":4},"广州侨益总经理助理"]
[{"$nulls":4},"广州悦达人力行政专员"]
[{"$nulls":4},"广州悦达业务经理"]
[{"$nulls":4},"广州悦达业务员"]
[{"$nulls":4},"广州悦达总经理"]
[{"$nulls":4},"黄埔报关报检员"]
[{"$nulls":4},"黄埔通关外勤"]
[{"$nulls":4},"黄埔主管"]
[{"$nulls":4},"货代财务经理"]
[{"$nulls":4},"货代出纳"]
[{"$nulls":4},"货代会计"]
[{"$nulls":4},"检验鉴定员"]
[{"$nulls":4},"客服1组"]
[{"$nulls":4},"客服2组"]
[{"$nulls":4},"客服3组"]
[{"$nulls":4},"客服4组"]
[{"$nulls":4},"客服5组"]
[{"$nulls":4},"老港报关供应商"]
[{"$nulls":4},"老港操作外勤"]
[{"$nulls":4},"南沙报关报检员"]
[{"$nulls":4},"南沙操作外勤"]
[{"$nulls":4},"南沙通关外勤"]
[{"$nulls":4},"南沙主管"]
[{"$nulls":4},"内部审计"]
[{"$nulls":4},"市场专员"]
[{"$nulls":4},"市场总监"]
[{"$nulls":4},"市场总监助理"]
[{"$nulls":4},"新港报关供应商"]
[{"$nulls":4},"新港操作外勤"]
[{"$nulls":4},"新沙报关报检员"]
[{"$nulls":4},"新沙通关外勤"]
[{"$nulls":4},"新沙主管"]