自动计算工资表(分级扣税)工资表

时间:2022-03-14 08:05:48 公文范文 来源:网友投稿
自动计算工资表(分级扣税)工资表
编制单位:                           
序号姓名基本工资假日加班工时平时加班工资法定节假日期加班工资伙食补贴住房补贴其他提成金额应付工资
A
扣事假
D
代扣保险
E
扣其他税前小计
F=C-D-E
应税所得
G=F-3500
税 率
H
速算扣除
I
代扣个税
J=G*H-I
实发金额
L=F-J-K
签领备注
01 10000        10000    10000.00 6500.00 20%555 745.00 9255.00   
02             #VALUE!#VALUE!#VALUE!#VALUE!#VALUE!  
03             #VALUE!#VALUE!#VALUE!#VALUE!#VALUE!  
04             #VALUE!#VALUE!#VALUE!#VALUE!#VALUE!  
05             #VALUE!#VALUE!#VALUE!#VALUE!#VALUE!  
06             #VALUE!#VALUE!#VALUE!#VALUE!#VALUE!  
07             #VALUE!#VALUE!#VALUE!#VALUE!#VALUE!  
08             #VALUE!#VALUE!#VALUE!#VALUE!#VALUE!  
09             #VALUE!#VALUE!#VALUE!#VALUE!#VALUE!  
10             #VALUE!#VALUE!#VALUE!#VALUE!#VALUE!  
11             #VALUE!#VALUE!#VALUE!#VALUE!#VALUE!  
12             #VALUE!#VALUE!#VALUE!#VALUE!#VALUE!  
13             #VALUE!#VALUE!#VALUE!#VALUE!#VALUE!  
14             #VALUE!#VALUE!#VALUE!#VALUE!#VALUE!  
15             #VALUE!#VALUE!#VALUE!#VALUE!#VALUE!  
16             #VALUE!#VALUE!#VALUE!#VALUE!#VALUE!  
17             #VALUE!#VALUE!#VALUE!#VALUE!#VALUE!  
18             #VALUE!#VALUE!#VALUE!#VALUE!#VALUE!  
19             #VALUE!#VALUE!#VALUE!#VALUE!#VALUE!  
20             #VALUE!#VALUE!#VALUE!#VALUE!#VALUE!  
21             #VALUE!#VALUE!#VALUE!#VALUE!#VALUE!  
22             #VALUE!#VALUE!#VALUE!#VALUE!#VALUE!  
23             #VALUE!#VALUE!#VALUE!#VALUE!#VALUE!  
24             #VALUE!#VALUE!#VALUE!#VALUE!#VALUE!  
25             #VALUE!#VALUE!#VALUE!#VALUE!#VALUE!  
26             #VALUE!#VALUE!#VALUE!#VALUE!#VALUE!  
27             #VALUE!#VALUE!#VALUE!#VALUE!#VALUE!  
28             #VALUE!#VALUE!#VALUE!#VALUE!#VALUE!  
29             #VALUE!#VALUE!#VALUE!#VALUE!#VALUE!  
30             #VALUE!#VALUE!#VALUE!#VALUE!#VALUE!  
31             #VALUE!#VALUE!#VALUE!#VALUE!#VALUE!  
 合计10000       10000  10000 #VALUE! #VALUE!#VALUE!#VALUE!  

文档下载《自动计算工资表(分级扣税)工资表》

推荐访问:工资表 分级 计算