工資表自動(dòng)計(jì)算模板(含社保公積金比例、扣稅)

1、工資表勞動(dòng)法第五十一條的規(guī)定，法定節(jié)假日用人單位應(yīng)當(dāng)依法支付工資，即折算日工資、小時(shí)工資時(shí)不剔除國(guó)家規(guī)定的11天法定節(jié)假日。據(jù)此，日工資、小時(shí)工資的折算為：日工資：月工資收入寧月計(jì)薪天數(shù)小時(shí)工資：月工資收入寧（月計(jì)薪天數(shù)X8小時(shí)）。月計(jì)薪天數(shù)=（365天-104天）=12月=21.75天所屬月份：x月份發(fā)放日期:序號(hào)姓名基本工資其他應(yīng)發(fā)其他應(yīng)扣應(yīng)發(fā)工資應(yīng)扣部分（單位/個(gè)人承擔(dān)社會(huì)保險(xiǎn)+公積金）加班工資績(jī)效考核小計(jì)全勤獎(jiǎng)加班補(bǔ)貼小計(jì)事假病假遲到缺勤扣款小計(jì)社保養(yǎng)老保險(xiǎn)醫(yī)療保險(xiǎn)失業(yè)保險(xiǎn)工傷保險(xiǎn)生育保險(xiǎn)住房公積金天數(shù)扣款基數(shù)單位19%個(gè)人8%單位11%個(gè)人2%單位1%個(gè)人0.5%單位0.5%單位0.

2、5%基數(shù)單位11%個(gè)人11%1#1.00#9.540.233.159.00600.21252.72347.4963.1831.5915.8015.8015.802.500.00275.00275.0025.000.003.159.00600.21252.72347.4963.1831.5915.8015.8015.802.500.00275.00275.0033.500.003.159.00600.21252.72347.4963.1831.5915.8015.8015.802.500.00275.00275.004567891011121314151617181920212223合計(jì)1000

3、0001.800.63758.161.042.47189.5494.7747.4047.4047.407.500.00825.00825.00制表：批準(zhǔn)：按照據(jù)此，日工資、小時(shí)工資的折算為：金額單位：元實(shí)發(fā)金額簽名個(gè)人小計(jì)公司小計(jì)稅606.701,285.89531.718,401.82606.701,285.8926.804,366.50606.701,285.892,893.30代扣款項(xiàng)級(jí)數(shù)累進(jìn)區(qū)間下限上限稅率扣除數(shù)180000800001E+1000.45135051,820.103,857.67558.5115,661.623159企業(yè)比例亍人出例企業(yè)金頷個(gè)人金埶養(yǎng)老19%600.21252.72醫(yī)療11%2%347.4963.10失業(yè)1%0.50%31.5915.795生育0.5淡D15.T