02-【管理系统】-09-销售管理系统（尾款跟踪业绩提成订单查询） (2).xlsx

销售订单登记表尾付款记录表订单尾款查询表提成对照表销售提成汇总表销售管理系统订单查询表销售员信息表客户信息表使用说明销售管理系统订单登记表日期订单编号订单详情客户名称联系电话地址单价数量32018/3/1520180329001门张1150*1356 开发区A小区400642018/3/1620180329002实木门张2150*1357 开发区B小区500652018/3/1620180329003窗张3150*1358 高新区X小区10052018/3/1620180329004窗张4150*1359 老城区C庄园100102018/3/1720180329005钢化门张5150*1360 高新区G小区80052018/3/1820180329005窗张5150*1360 高新区G小区1005返回总价预计制作周期交付日期定金尾款尾款是否结清销售员2400103月25日1002300已结清李13000204月5日3002700未结清李1500103月26日100400已结清李11000153月31日100900未结清李24000204月6日3003700已结清李2500304月17日0500已结清李20000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000尾款记录表返回日期订单编号客户名称联系电话金额2018/3/2120180329005张5150*136042002018/3/2220180329001张1150*135623002018/3/2320180329003张3150*1358400订单尾款查询表返回订单编号20180329002输入要查询的订单编号回车即可客户名称张2联系电话150*1357尾款2700销售员李1订单查询订单编号客户名称尾款是否结清日期订单编号订单详情客户名称联系电话地址单价数量33月15日 20180329001门张1150*1356 开发区A小区400643月16日 20180329002实木门张2150*1357 开发区B小区500653月16日 20180329003窗张3150*1358 高新区X小区10050000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000销售员李1返回总价 预计制作周期 交付日期定金尾款尾款是否结清销售员2400103月25日1002300已结清李13000204月5日3002700未结清李1500103月26日100400已结清李1提成标准对照表返回金额比例100010%200012%300014%400016%500018%600019%700020%800021%3 月份提成汇总表销售员基本工资补助销售金额销售提成比例提成金额工资总额李11200200590018.00%10622462李21500300550018.00%9902790李3000李4000李5000李600000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000返回客户信息表返回客户名称联系电话地址张1150*1356开发区A小区张2150*1357开发区B小区张3150*1358高新区X小区张4150*1359老城区C庄园张5150*1360高新区G小区销售员信息表返回客户名称联系电话地址李1188*1356开发区A小区李2188*1357开发区B小区李3188*1358高新区X小区李4188*1359老城区C庄园李5188*1360高新区G小区李6188*1361高新区G小区使使用用说说明明1、首先在【提成对照表】中录入不同销售金额对应的提成比例（金额为该等级的上线）,如果提成不是按照销量比例来定,至输入一个等级即可2、在【客户信息表】中登记客户信息，在【销售员信息表】中录入销售员信息3、然后再【销售提成汇总表】中录入统计的月份，销售人员姓名，基本工资，补助（没有的话，可以不录入），其他内容自动生成4、客户下单时在【订单登记表】中记录下单详情，其中总价、交付日期、尾款、尾款、客户地址和电话及是否结清可以自动生成，其他内容需要手动录入5、交货后，在【尾款记录表】中登记尾款较快情况。尾款交清后，【订单登记表】中,自动生成尾款已结清。6、交尾款时，可以通过【订单尾款查询表】来查询该订单的具体尾款（只需要输入订单号就可以）7、该销售管理系统适合定制式销售管理，该系统的优点：（1）、销售提成只计算尾款结清的订单,符合一般销售提成习惯返回