|
XX公司工资表 |
|
|
|
|
|
|
19500 |
19500 |
0 |
0 |
0 |
0 |
5850 |
0 |
0 |
0 |
0 |
0 |
25350 |
0 |
3900 |
195 |
58.5 |
0 |
1950 |
0 |
2340 |
8443.5 |
1560 |
39 |
0 |
399 |
0 |
2340 |
4338 |
21012 |
98000 |
831.6 |
0 |
0 |
20180.4 |
| 序号 |
部门 |
岗位 |
职级 |
姓名 |
卡号 |
身份证号 |
约定工资标准 |
基本工资标准 |
绩效工资标准 |
绩效工资发放系数 |
绩效工资 |
提成 |
奖金 |
津贴 |
餐补 |
加班费 |
缺勤扣款 |
异动调整项 |
应付工资 |
基数 |
公司部分养老保险 |
公司部分失业保险 |
公司部分工伤保险 |
公司部分生育保险 |
公司部分医疗保险 |
公司部分其它社保 |
公司部分公积金 |
公司部分合计 |
个人养老保险扣款 |
个人失业保险扣款 |
个人生育保险扣款 |
个人医疗保险扣款 |
个人其它社保扣款 |
个人公积金扣款 |
个人保险公积金扣款合计 |
应纳税工资 |
个税起征点 |
个税 |
商业保险扣款 |
其它扣款 |
实发工资 |
| |
|
|
|
|
|
|
6500 |
6500 |
|
|
0 |
|
|
|
|
|
|
|
6500 |
|
1300 |
65 |
19.5 |
|
650 |
|
780 |
2815 |
520 |
13 |
|
133 |
|
780 |
1446 |
5054 |
3500 |
50.4 |
|
|
5003.6 |
| |
|
|
|
|
|
|
6500 |
6500 |
|
|
0 |
|
1950 |
|
|
|
|
|
8450 |
|
1300 |
65 |
19.5 |
|
650 |
|
780 |
2815 |
520 |
13 |
|
133 |
|
780 |
1446 |
7004 |
3500 |
245.4 |
|
|
6758.6 |
| |
|
|
|
|
|
|
6500 |
6500 |
|
|
0 |
|
3900 |
|
|
|
|
|
10400 |
|
1300 |
65 |
19.5 |
|
650 |
|
780 |
2815 |
520 |
13 |
|
133 |
|
780 |
1446 |
8954 |
3500 |
535.8 |
|
|
8418.2 |
| |
|
|
|
|
|
|
0 |
|
|
|
0 |
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
0 |
0 |
3500 |
0 |
|
|
0 |
| |
|
|
|
|
|
|
0 |
|
|
|
0 |
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
0 |
0 |
3500 |
0 |
|
|
0 |
| |
|
|
|
|
|
|
0 |
|
|
|
0 |
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
0 |
0 |
3500 |
0 |
|
|
0 |
| |
|
|
|
|
|
|
0 |
|
|
|
0 |
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
0 |
0 |
3500 |
0 |
|
|
0 |
| |
|
|
|
|
|
|
0 |
|
|
|
0 |
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
0 |
0 |
3500 |
0 |
|
|
0 |
| |
|
|
|
|
|
|
0 |
|
|
|
0 |
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
0 |
0 |
3500 |
0 |
|
|
0 |
| |
|
|
|
|
|
|
0 |
|
|
|
0 |
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
0 |
0 |
3500 |
0 |
|
|
0 |
| |
|
|
|
|
|
|
0 |
|
|
|
0 |
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
0 |
0 |
3500 |
0 |
|
|
0 |
| |
|
|
|
|
|
|
0 |
|
|
|
0 |
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
0 |
0 |
3500 |
0 |
|
|
0 |
| |
|
|
|
|
|
|
0 |
|
|
|
0 |
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
0 |
0 |
3500 |
0 |
|
|
0 |
| |
|
|
|
|
|
|
0 |
|
|
|
0 |
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
0 |
0 |
3500 |
0 |
|
|
0 |
| |
|
|
|
|
|
|
0 |
|
|
|
0 |
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
0 |
0 |
3500 |
0 |
|
|
0 |
| |
|
|
|
|
|
|
0 |
|
|
|
0 |
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
0 |
0 |
3500 |
0 |
|
|
0 |
| |
|
|
|
|
|
|
0 |
|
|
|
0 |
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
0 |
0 |
3500 |
0 |
|
|
0 |
| |
|
|
|
|
|
|
0 |
|
|
|
0 |
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
0 |
0 |
3500 |
0 |
|
|
0 |
| |
|
|
|
|
|
|
0 |
|
|
|
0 |
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
0 |
0 |
3500 |
0 |
|
|
0 |
| |
|
|
|
|
|
|
0 |
|
|
|
0 |
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
0 |
0 |
3500 |
0 |
|
|
0 |
| |
|
|
|
|
|
|
0 |
|
|
|
0 |
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
0 |
0 |
3500 |
0 |
|
|
0 |
| |
|
|
|
|
|
|
0 |
|
|
|
0 |
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
0 |
0 |
3500 |
0 |
|
|
0 |
| |
|
|
|
|
|
|
0 |
|
|
|
0 |
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
0 |
0 |
3500 |
0 |
|
|
0 |
| |
|
|
|
|
|
|
0 |
|
|
|
0 |
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
0 |
0 |
3500 |
0 |
|
|
0 |
| |
|
|
|
|
|
|
0 |
|
|
|
0 |
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
0 |
0 |
3500 |
0 |
|
|
0 |
| |
|
|
|
|
|
|
0 |
|
|
|
0 |
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
0 |
0 |
3500 |
0 |
|
|
0 |
| |
|
|
|
|
|
|
0 |
|
|
|
0 |
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
0 |
0 |
3500 |
0 |
|
|
0 |
| |
|
|
|
|
|
|
0 |
|
|
|
0 |
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
0 |
0 |
3500 |
0 |
|
|
0 |
1.允许插入删除行,不允许插入删除列;
2.A到I列是文本格式,其它是常规格式;
3.所有单元格数值小数位最多保留两位;(可以少于两位)
4.插入行后能自动复制列的公式到新插入的行中;(即姓名项不为空时,自动复制该列公式)
5.不允许修改黄色底纹列单元格的公式,允许其它列亩设置公式 |
|
