使用說明:,,,,,,,,,,,,,,,,,,,,,

1.本表打開后請按操作步驟：工具--宏--安全性--低—保存—關(guān)閉—再打開，否則按鈕無效，使用時(shí)請使用微軟officeexcel各版本打開。2.本表無任何鎖定密碼，表頭的顏色及文字格式可隨意更改，按鍵除外，表中公式都是正確無誤的。3.按“+”號鍵是生成工資條用的，按“-”號鍵是還原。,,,,,,,,,,,,,,,,,,,,,

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

序號,姓名,基本工資,假日加班工時(shí),平時(shí)加班工資,法定節(jié)假日加班工資,伙食補(bǔ)貼,住房補(bǔ)貼,其他,提成金額,"應(yīng)付工資

A","扣事假

D","代扣保險(xiǎn)

E",扣公積金B(yǎng),"稅前小計(jì)

F=C-D-E","應(yīng)稅所得

G=F-3500","稅率

H","速算扣除

I","代扣個(gè)稅

J=G*H-I","實(shí)發(fā)金額

L=F-J-K",簽領(lǐng),備注

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