自動(dòng)計(jì)算工資表(帶公式)是什么都能計(jì)算的哦!

1、 自自 動(dòng)動(dòng) 計(jì)計(jì) 算算 工工 資資 表表 （含含公公式式、參參數(shù)數(shù)）時(shí)時(shí)間間：【20122012年年3 3月月】序號(hào)姓名部門工作編號(hào)應(yīng)應(yīng) 發(fā)發(fā) 工工 資資基基本本工工資資合計(jì)不得低于當(dāng)?shù)刈畹凸べY830元加加班班加加點(diǎn)點(diǎn)工工資資合計(jì)(元)獎(jiǎng)獎(jiǎng)金金合計(jì)(元)津津貼貼和和補(bǔ)補(bǔ)貼貼合計(jì)(元)特特殊殊情情況況工工資資基礎(chǔ)工資崗位工資職務(wù)工資工齡工資合計(jì)(元)休假日加班(300%)休息日加班(200%)延時(shí)加點(diǎn)(150%)全勤獎(jiǎng)安全獎(jiǎng)年終獎(jiǎng)生產(chǎn)獎(jiǎng)節(jié)約獎(jiǎng)先進(jìn)獎(jiǎng)其他獎(jiǎng)崗位津貼特殊津貼保健津貼技術(shù)津貼年功津貼其他津貼物價(jià)補(bǔ)貼交通費(fèi)補(bǔ)貼電話費(fèi)補(bǔ)貼誤餐費(fèi)補(bǔ)貼住房補(bǔ)貼其他補(bǔ)貼因病加班（天）加班工資加班（天）加班工資

2、加點(diǎn)(小時(shí))加點(diǎn)工資1李一部門1sc001700020005001009600960033972870626049661600010050001050165200303026002王二部門2sc0027000200050010096009600226484353130248386621005000105016520030302603張三部門3sc0037000200050010096009600113242176615124143311005000105016520030302604劉四部門4sc0042000500200902790279031154820526014434650100500

3、010501655030301105陳五部門5sc00520005002009027902790277041026307222517100500010501655030301106楊六部門6sc0062000500200902790279013852513153611259100500010501655030301107趙七部門7sc00750020010008008303343861160429138310050001050165203030808黃八部門8sc0085002001000800830222943053021574910050001050165203030809周九部門9sc0

4、0950020010008008301114215315107374100500010501652030308010吳十部門10 sc0100830000000011徐11部門11 sc0111200300200100180018000000100500010501653030309012孫12部門12 sc0128300000000合合 計(jì)計(jì)2970029700840084002600260067067041370413704312043120181810941109414242170191701931531511966119663992639926100010005005000 00 01

5、0010050500 0165016508408400 00 00 00 00 00 03003003003000 00 00 0144014400 0制制表表部部門門： 制制表表人人簽簽名名：注：本表主要針對(duì)企業(yè)“用工成本”的自動(dòng)預(yù)算使用。本本表表由由貴貴州州六六盤盤水水noonanyonenoonanyone擬擬制制，僅僅供供參參考考、學(xué)學(xué)習(xí)習(xí)。 20122012年年3 3月月2626日日應(yīng)應(yīng)發(fā)發(fā)工工資資總總合合計(jì)計(jì)( (元元) )代代扣扣代代繳繳及及應(yīng)應(yīng)扣扣費(fèi)費(fèi)用用合計(jì)(元)社社會(huì)會(huì)保保險(xiǎn)險(xiǎn)費(fèi)費(fèi)應(yīng)繳社會(huì)保險(xiǎn)費(fèi)總合計(jì)(元)住住房房公公積積金金工傷產(chǎn)假婚假喪假事假探親假定期休假停工學(xué)習(xí)計(jì)劃生

6、育假其他原因養(yǎng)養(yǎng)老老保保險(xiǎn)險(xiǎn)失失業(yè)業(yè)保保險(xiǎn)險(xiǎn)醫(yī)醫(yī)療療保保險(xiǎn)險(xiǎn)工工傷傷保保險(xiǎn)險(xiǎn)生生育育保保險(xiǎn)險(xiǎn)個(gè)人合計(jì)(元)單位合計(jì)(元)繳存基數(shù)繳存比例（5%12%）合計(jì)繳費(fèi)基數(shù)繳費(fèi)比例繳費(fèi)基數(shù)繳費(fèi)比例 繳費(fèi)基數(shù)繳費(fèi)比例 繳費(fèi)基數(shù)繳費(fèi)比例 繳費(fèi)基數(shù)繳費(fèi)比例 個(gè)人（8%）單位(20%)個(gè)人（1%）單位（2%）個(gè)人（2%）單位（7%）個(gè)人(0%)單位(煤礦)單位(非煤礦)個(gè)人(0%)單位(0.5%)個(gè)人(5%)(元)單位(5%)(元)噸數(shù)3元0.8%或2%或3%000000000002 26 60 02 25 5786362915737863791578496170595283200057084964287824

7、243301849642542585001 18 86 68 87 7786362915737863791577863157550283200057084964286523793244849642542585001 14 43 35 56 6786362915737863791577863157550283200057084964286523793244849642542585007 77 71 15 5771561715437715771547715154540283200057077153984923333181771538638677205 55 58 82 25582447111655

8、82561125582112391283200057055822861417032317558227927955804 43 32 24 4432434686543244386432486303283200057043242247613321808432421621643202 24 45 58 824581974922458254924584917228320005702458122707821052245812312324601 18 82 24 418241463651824183618353712828320005701982102015967971824919118201 14 44

9、 49 915731263151573163118353712828320005701982101785417191449727214508 83 30 0157312631515731631183537128283200057019821017854171983042428302 20 05 55 52055164411205521412055411442832000570205510226663889205510310320608 83 30 015731263151573163118353712828320005701982101785417198304242830 00 00 00 0

10、0 00 00 00 00 00 00 0861368613652266522664181418110453104535226652266523523104510455369653696107410743759375933984339840 00 00 06806800 0555505555027827857785778162151621521993219935255552555262826282628262852565256會(huì)會(huì)計(jì)計(jì)核核準(zhǔn)準(zhǔn)簽簽名名：出出納納簽簽名名： 自自 動(dòng)動(dòng) 計(jì)計(jì) 算算 工工 資資 表表 （含含公公式式、參參數(shù)數(shù)）應(yīng)應(yīng) 發(fā)發(fā) 工工 資資特特殊殊情情況況工工資資代代扣扣代

11、代繳繳及及應(yīng)應(yīng)扣扣費(fèi)費(fèi)用用總總合合計(jì)計(jì)( (元元) )實(shí)實(shí)發(fā)發(fā)工工資資總總額額合合計(jì)計(jì)( (元元) )確確認(rèn)認(rèn)簽簽印印領(lǐng)領(lǐng)取取個(gè)個(gè)人人所所得得稅稅其其他他應(yīng)應(yīng)扣扣費(fèi)費(fèi)用用合計(jì)(元)工資薪金所得應(yīng)納稅額個(gè)人所得稅(元)事假病假曠工遲到早退違反規(guī)章制度造成單位經(jīng)濟(jì)損失費(fèi)其他原因247234301000000000560320422173972469000000003759149281306613870000000026761168064811930000000014276288468936000000009294654363240000000069636282065000000000393206515320000000002921532119900000000025111996100000000002