当前位置：争朝文档网>范文大全 > 公文范文 > 自动计算工资表（分级扣税）工资表

自动计算工资表（分级扣税）工资表

时间：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         0     #VALUE!#VALUE!#VALUE!#VALUE!#VALUE!  
03         0     #VALUE!#VALUE!#VALUE!#VALUE!#VALUE!  
04         0     #VALUE!#VALUE!#VALUE!#VALUE!#VALUE!  
05         0     #VALUE!#VALUE!#VALUE!#VALUE!#VALUE!  
06         0     #VALUE!#VALUE!#VALUE!#VALUE!#VALUE!  
07         0     #VALUE!#VALUE!#VALUE!#VALUE!#VALUE!  
08         0     #VALUE!#VALUE!#VALUE!#VALUE!#VALUE!  
09         0     #VALUE!#VALUE!#VALUE!#VALUE!#VALUE!  
10         0     #VALUE!#VALUE!#VALUE!#VALUE!#VALUE!  
11         0     #VALUE!#VALUE!#VALUE!#VALUE!#VALUE!  
12         0     #VALUE!#VALUE!#VALUE!#VALUE!#VALUE!  
13         0     #VALUE!#VALUE!#VALUE!#VALUE!#VALUE!  
14         0     #VALUE!#VALUE!#VALUE!#VALUE!#VALUE!  
15         0     #VALUE!#VALUE!#VALUE!#VALUE!#VALUE!  
16         0     #VALUE!#VALUE!#VALUE!#VALUE!#VALUE!  
17         0     #VALUE!#VALUE!#VALUE!#VALUE!#VALUE!  
18         0     #VALUE!#VALUE!#VALUE!#VALUE!#VALUE!  
19         0     #VALUE!#VALUE!#VALUE!#VALUE!#VALUE!  
20         0     #VALUE!#VALUE!#VALUE!#VALUE!#VALUE!  
21         0     #VALUE!#VALUE!#VALUE!#VALUE!#VALUE!  
22         0     #VALUE!#VALUE!#VALUE!#VALUE!#VALUE!  
23         0     #VALUE!#VALUE!#VALUE!#VALUE!#VALUE!  
24         0     #VALUE!#VALUE!#VALUE!#VALUE!#VALUE!  
25         0     #VALUE!#VALUE!#VALUE!#VALUE!#VALUE!  
26         0     #VALUE!#VALUE!#VALUE!#VALUE!#VALUE!  
27         0     #VALUE!#VALUE!#VALUE!#VALUE!#VALUE!  
28         0     #VALUE!#VALUE!#VALUE!#VALUE!#VALUE!  
29         0     #VALUE!#VALUE!#VALUE!#VALUE!#VALUE!  
30         0     #VALUE!#VALUE!#VALUE!#VALUE!#VALUE!  
31         0     #VALUE!#VALUE!#VALUE!#VALUE!#VALUE!  
 合计10000       0 10000 0 0  10000 #VALUE! #VALUE!#VALUE!#VALUE!  

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

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

心得体会图文推荐
自动计算工资表（分级扣税）工资表相关文章
最新推荐
猜你喜欢

版权所有:争朝文档网 2017-2024 未经授权禁止复制或建立镜像[争朝文档网]所有资源完全免费共享

Powered by [争朝文档网] © All Rights Reserved. 备案号：浙ICP备17042862号