自动计算工资表.xls

1、 自自 动动 计计 算算 工工 资资 表表 （含含公公式式、参参数数）时时间间：【20122012年年3 3月月】序号姓名部门工作编号应应 发发 工工 资资基基本本工工资资合计不得低于当地最低工资830元加加班班加加点点工工资资合计(元)奖奖金金合计(元)津津贴贴和和补补贴贴基础工资岗位工资职务工资工龄工资合计(元)休假日加班(300%)休息日加班(200%)延时加点(150%)全勤奖安全奖年终奖生产奖节约奖先进奖其他奖岗位津贴特殊津贴保健津贴技术津贴年功津贴其他津贴物价补贴交通费补贴电话费补贴误餐费补贴加班（天）加班工资加班（天）加班工资加点(小时)加点工资1李一部门1sc001700020

2、00500100960096003397287062604966160001005000105016520030302王二部门2sc0027000200050010096009600226484353130248386621005000105016520030303张三部门3sc0037000200050010096009600113242176615124143311005000105016520030304刘四部门4sc0042000500200902790279031154820526014434650100500010501655030305陈五部门5sc005200050020090

3、27902790277041026307222517100500010501655030306杨六部门6sc0062000500200902790279013852513153611259100500010501655030307赵七部门7sc007500200100080083033438611604291383100500010501652030308黄八部门8sc00850020010008008302229430530215749100500010501652030309周九部门9sc009500200100080083011142153151073741005000105016520

4、303010吴十部门10 sc010083000000011徐11部门11 sc01112003002001001800180000001005000105016530303012孙12部门12 sc012830000000合合 计计2970029700840084002600260067067041370413704312043120181810941109414242170191701931531511966119663992639926100010005005000 00 010010050500 0165016508408400 00 00 00 00 00 0300300300300

5、0 0制制表表部部门门：制制表表人人签签名名：注：本表主要针对企业“用工成本”的自动预算使用。本本表表由由贵贵州州六六盘盘水水noonanyonenoonanyone拟拟制制，仅仅供供参参考考、学学习习。20122012年年3 3月月2626日日应应发发工工资资总总合合计计(元元)代代扣扣代代缴缴及及应应扣扣费费用用合计(元)特特殊殊情情况况工工资资合计(元)社社会会保保险险费费住房补贴其他补贴因病工伤产假婚假丧假事假探亲假定期休假停工学习计划生育假其他原因养养老老保保险险失失业业保保险险医医疗疗保保险险工工伤伤保保险险生生育育保保险险个人合计(元)缴费基数缴费比例缴费基数缴费比例缴费基数缴费

6、比例缴费基数缴费比例缴费基数缴费比例个人（8%）单位(20%)个人（1%）单位（2%）个人（2%）单位（7%）个人(0%)单位(煤矿)单位(非煤矿)个人(0%)单位(0.5%)吨数3元0.8%或2%或3%260000000000000260252602578636291573786379157849617059528320005708496428782600186871868778636291573786379157786315755028320005708496428652600143561435678636291573786379157786315755028320005708496428

7、651100771577157715617154377157715477151545402832000570771539849110055825582558244711165582561125582112391283200057055822861411004324432443243468654324438643248630328320005704324224768002458245824581974922458254924584917228320005702458122708001824182418241463651824183618353712828320005701982102018001

8、449144915731263151573163118353712828320005701982101780083083015731263151573163118353712828320005701982101789002055205520551644112055214120554114428320005702055102260083083015731263151573163118353712828320005701982101780 00 0144014400 00 00 00 00 00 00 00 00 00 00 00 086136861365226652266418141811045

9、3104535226652266523523104510455369653696107410743759375933984339840 00 00 06806800 0555505555027827857785778会会计计核核准准签签名名：出出纳纳签签名名：自自 动动 计计 算算 工工 资资 表表 （含含公公式式、参参数数）代代扣扣代代缴缴及及应应扣扣费费用用总总合合计计(元元)实实发发工工资资总总额额合合计计(元元)确确认认签签印印领领取取应缴社会保险费总合计(元)住住房房公公积积金金个个人人所所得得税税其其他他应应扣扣费费用用合计(元)单位合计(元)缴存基数缴存比例（5%12%）合计工资

10、薪金所得应纳税额个人所得税(元)事假病假旷工迟到早退违反规章制度造成单位经济损失费其他原因个人(5%)(元)单位(5%)(元)242433018496425425850247234301000000000560320422237932448496425425850173972469000000003759149282379324484964254258501306613870000000026761168023333181771538638677264811930000000014276288170323175582279279558468936000000009294654133218084

11、324216216432363240000000069636287821052245812312324620650000000003932065596797182491911821532000000000292153254171914497272145119900000000025111995417198304242836100000000002206106638892055103103206172600000000032917265417198304242836100000000002206101621516215219932199352555525552628262826282628525652567773077730838983890 00 00 00 00 00 00 00 00 016795167956934169341负负责责人人审审核核签签名名：