当前位置：首页 > 范文大全 > 公文范文 >

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

时间：2021-12-01 08:41:20 浏览量：
自动计算工资表（分级扣税）工资表
编制单位：                           
序号姓名基本工资假日加班工时平时加班工资法定节假日期加班工资伙食补贴住房补贴其他提成金额应付工资
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!  

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

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

上一篇：全年一次性奖金个税测算 下一篇：2020学习坚定信仰信念发言稿

相关推荐

  • 公司工资表制作（Office） 2021-11-16
  • 2020Excel工资表制作 2021-11-16
  • xxx公司3月份工资表 2021-12-01
  • 企业员工工资表自动计算... 2021-11-29
  • 煤矿安全风险分级管控专... 2022-01-22
  • 计算机专业大学生顶岗实... 2021-11-12
  • 计算机专业毕业生求职自... 2021-11-13
  • 2020计算机专业顶岗实习... 2021-11-15
  • 计算机专业学生实习报告8... 2021-11-16
  • 大学生计算机专业毕业实... 2021-11-20
  • 计算机网络实验报告 2021-11-29
  • 2020计算机专业大学生创业计划 2021-12-05
  • 企业件薪计算表 2021-12-06
  • 大学计算机网络专业个人... 2021-12-06
  • 大学计算机网络顶岗实习... 2021-12-07

    • 热门文章