这是一个页数为5页的Excel表格格式的公式版销售提成工资核算系统表,下载后可编辑可打印,其他销售报表薪酬管理销售统计销售提成表销售工资销售提成单提成比例表销售利润提成表销售业绩提成表可以在本网站搜索下载。
1、参数设置表录入业务员信息以及基本工资和商品信息,2、销售录入表,销售员、品名列下拉选择,蓝色列有计算公式,自动显示,保护密码为空,3、报表查询下拉选择月份,自动统计,保护密码为空,4、明细账查询下拉选择销售员,自动统计,保护密码为空,销售提成工资核算系统,业务员基本工资品名单位售价提成比例,王鹏1500.0冰箱2999.00.01,李丽2000.0洗衣机1999.00.02,张南2000.0电视3999.00.01,电脑2999.00.02,合计(动态):43.0124957.0,2018.0销售单号客户名称销售员品名单位数量单价金额提成比例提成金额备注,月日,14.00000001冰箱5998.059.98,18.000000025997.0119.94,29.000000039.017991.0359.82,29.0000000439.99,21.00000005用友软件电脑5998.0119.96,22.00000006用友软件11997.0119.97,25.000000075997.0119.94,0000008电脑5.014995.0299.9,11.00000009冰箱6.017994.0179.94,11.000000108.031992.0319.92,12.0000001139.98,计件工资2月报表,报表月份:2.0金额单位:元,序号业务员基本工资提成工资其他补贴其他扣款实发工资备注,1.0王鹏1500.0239.911789.91,2.0李丽2000.0119.96200.02219.96,3.0张南2000.02050.0,4.0,5.0,6.0,7.0,8.0,9.0,10.0,11.0,12.0,13.0,14.0,15.0,16.0,17.0,18.0,19.0,20.0,21.0,22.0,23.0,24.0,25.0,26.0,27.0,28.0,29.0,30.0,31.0,32.0,33.0,34.0,35.0,36.0,37.0,38.0,39.0,40.0,41.0,42.0,43.0,44.0,45.0,46.0,47.0,48.0,49.0,51.0,52.0,53.0,54.0,55.0,56.0,57.0,58.0,59.0,60.0,61.0,62.0,63.0,64.0,65.0,66.0,67.0,68.0,69.0,70.0,71.0,72.0,73.0,74.0,75.0,76.0,77.0,78.0,79.0,80.0,81.0,82.0,83.0,84.0,85.0,86.0,87.0,88.0,89.0,90.0,91.0,92.0,93.0,94.0,95.0,96.0,97.0,98.0,99.0,101.0,102.0,103.0,104.0,105.0,106.0,107.0,108.0,109.0,110.0,111.0,112.0,113.0,114.0,115.0,116.0,117.0,118.0,119.0,120.0,121.0,122.0,123.0,124.0,125.0,126.0,127.0,128.0,129.0,130.0,131.0,132.0,133.0,134.0,135.0,136.0,137.0,138.0,139.0,140.0,141.0,142.0,143.0,144.0,145.0,146.0,147.0,148.0,149.0,150.0,151.0,152.0,153.0,154.0,155.0,156.0,157.0,158.0,159.0,160.0,161.0,162.0,163.0,164.0,165.0,166.0,167.0,168.0,169.0,170.0,171.0,172.0,173.0,174.0,175.0,176.0,177.0,178.0,179.0,180.0,181.0,182.0,183.0,184.0,185.0,186.0,187.0,188.0,189.0,190.0,191.0,192.0,193.0,194.0,195.0,196.0,197.0,198.0,199.0,200.0,合 计5500.0359.87350.0150.06059.87,销售提成(王鹏)明细账4.06.09.0,业务员:合计:659.714.0,2018年销售单号客户名称销售员品名单位数量单价金额提成比例提成金额备注,月日,14.00000001东华软件冰箱2999.05998.00.0159.98,29.00000003浪潮集团洗衣机9.01999.017991.00.02359.82,23989.0419.8,23989.0419.8,22.00000006用友软件电视3999.011997.00.01119.97,25.00000007浪潮集团洗衣机1999.05997.00.02119.94,6.017994.0239.91,17.041983.0659.71
提示:预览文档经过压缩,下载后原文档超清晰!有任何问题联系客服QQ:43570874 微信:niutuwen 备注:牛图文