当前位置： 首页> 范文大全> 计划方案>

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

发布时间：2023-04-22 10:30:33 浏览数：

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




工资表
编制单位：                           
序号姓名基本工资假日加班工时平时加班工资法定节假日期加班工资伙食补贴住房补贴其他提成金额应付工资
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!  



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


上一篇：一封写给你的情书，请查收

上一篇：结合本职工作对照党章党规找差距个人汇报材料

相关范文
最新计划方案范文
热门计划方案范文

如有意见、反馈或投诉等情况，请随时联系我们，我们将会在48小时内给文章处理！