工资表（自动生成工资条）

使用说明:,,,,,,,,,,,,,,,,,,,,,

1.本表打开后请按操作步骤：工具--宏--安全性--低—保存—关闭—再打开，否则按钮无效，使用时请使用微软officeexcel各版本打开。2.本表无任何锁定密码，表头的颜色及文字格式可随意更改，按键除外，表中公式都是正确无误的。3.按“+”号键是生成工资条用的，按“-”号键是还原。,,,,,,,,,,,,,,,,,,,,,

XX有限公司2018年4月工资表,,,,,,,,,,,,,,,,,,,,,

序号,姓名,基本工资,假日加班工时,平时加班工资,法定节假日加班工资,伙食补贴,住房补贴,其他,提成金额,"应付工资

A","扣事假

D","代扣保险

E",扣公积金B,"税前小计

F=C-D-E","应税所得

G=F-3500","税率

H","速算扣除

I","代扣个税

J=G*H-I","实发金额

L=F-J-K",签领,备注

01,张三,3200,,,300,,,,2727,6227,,654,374,5199.55,1699.55,10%,25,144.95,5054.60,,

02,李四,2600,400,100,,200,300,,,3600,,378,216,3006.00,0.00,0%,0,0.00,3006.00,,

03,王五,2200,,,800,200,300,,1051,4501,50.00,473,270,3708.34,208.34,5%,0,10.42,3697.92,,

04,陈六,2700,200,,,200,200,,750,4050,,425,243,3381.75,0.00,0%,0,0.00,3381.75,,

05,郑七,3000,,,600,,,,,3400,200.00,357,204,2639.00,0.00,0%,0,0.00,2639.00,,

06,王二,3700,300,150,,200,200,,,4550,,478,273,3799.25,299.25,5%,0,14.96,3784.29,,

07,郑七,2600,,400,,200,200,,500,3900,,410,234,3256.50,0.00,0%,0,0.00,3256.50,,

08,陈六,2700,225,,,200,200,100,,3325,100.00,349,200,2676.38,0.00,0%,0,0.00,2676.38,,

09,赵四,3000,,300,,200,200,,350,4050,,425,243,3381.75,0.00,0%,0,0.00,3381.75,,

10,刘五,2600,175,,,200,300,,,3275,,344,197,2734.63,0.00,0%,0,0.00,2734.63,,

11,孙二,2950,,376,,200,100,,,3476,150.00,365,209,2752.43,0.00,0%,0,0.00,2752.43,,

12,孙二,2951,125,,,201,101,,,3378,,,203,3175.32,,,,,3175.32,,

13,孙二,2952,,,,202,102,,,3256,,,195,3060.64,,,,,3060.64,,

14,孙二,2953,100,,,203,103,,,3359,,,202,3157.46,,,,,3157.46,,

15,孙二,2954,,514,,204,104,,,3776,,,227,3549.84,,,,,3549.84,,

16,孙二,2955,50,549,,205,105,,,3864,,,232,3632.20,,,,,3632.20,,

17,孙二,2956,,,,206,106,,,3268,,,196,3071.92,,,,,3071.92,,

18,孙二,2957,0,618,,207,107,,,3889,,,233,3655.91,,,,,3655.91,,

19,孙二,2958,,,,208,108,,,3274,,344,196,2733.79,0.00,,,,2733.79,,

20,孙二,2959,,653,,209,109,,,3930,,4