Excel模板：美容院销售提成工资管理系统.xlsx

基基础础信信息息录录入入表表0105040302销销售售明明细细记记录录表表销销售售员员提提成成查查询询客客户户消消费费明明细细查查询询员员工工工工资资汇汇总总员员工工工工资资提提成成管管理理系系统统使使用用说说明明0105040302 基基础础信信息息录录入入表表序号客户名称销售员产品名称分类产品价格提成金额提成比例1朱珠丹丹补水霜单品56885.215%2张宇甜甜乳腺无忧套盒328032810%3林娜王菲背部三焦疗程288028810%4袁培培田小林全身SPA 全身SPA 188018810%5孟林婷婷洗髓无忧养护套49802495%6程琳文文护理手工费07张芸天天大黄原液9809810%8方琳寒小殊黄芪原液66966.910%900000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000其它提成销售员基本工资 餐费补贴 车费补贴 住宿补贴 其它补贴扣款丹丹20001002005005020甜甜20001002005005010王菲20001002005005050田小林20001002005005080婷婷200010020050050305文文20001002005005070天天20001002005005060小殊2000100200500502500000000000销售明细记录表日期客户姓名销售员产品名称分类产品价格提成金额3月1日朱珠小殊乳腺无忧套盒32803283月2日张宇王菲补水霜单品56885.23月3日林娜丹丹洗髓无忧手工费003月4日孟林小殊补水霜单品56885.23月5日林娜田小林护理手工费003月6日袁培培甜甜洗髓无忧套盒32803283月7日袁培培田小林全身SPA 手工费003月8日方琳寒丹丹大黄单品56885.23月9日张宇王菲黄芪单品56885.23月10日袁培培婷婷乳腺无忧套盒32803283月11日孟林文文背部三焦疗程28802883月12日朱珠天天护理手工费003月13日方琳寒小殊洗髓无忧疗程28802883月14日袁培培田小林全身SPA 疗程28802883月15日孟林丹丹洗髓无忧套盒32803283月16日林娜王菲全身SPA 养护套49802493月17日孟林婷婷护理手工费003月18日朱珠文文黄芪手工费003月19日方琳寒天天乳腺无忧疗程28802883月20日袁培培婷婷背部三焦疗程28802883月21日孟林文文乳腺无忧套盒32803283月22日林娜天天背部三焦养护套4980249提成比例 其它提成提成总金额10%032815%085.20%5515%085.20%5510%03280%5515%085.215%085.210%032810%02880%5510%028810%028810%03285%02490%550%5510%028810%028810%03285%0249销售员提成查询明细20182018年3 3月销售员天天总金额542日期客户姓名销售员产品名称分类产品价格总提成金额备注2018/3/12朱珠天天护理手工费052018/3/19方琳寒天天乳腺无忧疗程28802882018/3/22林娜天天背部三焦养护套4980249客户消费明细查询客户姓名袁培培客户总消费0日期客户姓名销售员产品名称分类产品价格备注2018/3/6袁培培甜甜洗髓无忧套盒3280员工工资汇总查询销售员提成工资基本工资餐费补贴车费补贴住宿补贴丹丹418.22000100200500甜甜3282000100200500王菲419.42000100200500田小林2982000100200500婷婷6212000100200500文文6212000100200500天天5422000100200500小殊701.22000100200500总计27093.8其它补贴扣款总计50203288.25010318850503319.45080322850303501507035415060345250253576.2 使使用用说说明明1 1 底底纹纹有有颜颜色色无无需需手手动动输输入入2 2 首首先先基基础础信信息息录录入入表表要要全全部部填填写写清清楚楚（除除黄黄色色底底纹纹无无需需任任何何手手动动输输入入）3 3 销销售售明明细细记记录录明明细细中中白白色色底底纹纹需需要要手手动动录录入入信信息息，黄黄色色底底纹纹无无需需任任何何手手动动输输入入（自自动动生生成成）4 4 销销售售员员提提成成查查询询只只需需要要筛筛选选月月份份和和销销售售员员名名称称即即可可，其其它它会会自自动动计计算算生生成成，5 5 客客户户消消费费明明细细查查询询 只只需需选选择择要要查查询询客客户户对对象象的的名名称称，系系统统会会自自动动计计算算生生成成6 6 销销售售员员工工资资汇汇总总为为自自动动生生成成直直接接查查询询即即可可