自动计算工资表.xls

自动计算工资表.xls

《自动计算工资表.xls》由会员分享，可在线阅读，更多相关《自动计算工资表.xls（3页珍藏版）》请在冰点文库上搜索。

自自动动计计算算工工资资表表（含含公公式式、参参数数）时时间间：

【20122012年年33月月】序号姓名部门工作编号应应发发工工资资基基本本工工资资合计不得低于当地最低工资830元加加班班加加点点工工资资合计（元）奖奖金金合计（元）津津贴贴和和补补贴贴基础工资岗位工资职务工资工龄工资合计（元）休假日加班（300%）休息日加班（200%）延时加点（150%）全勤奖安全奖年终奖生产奖节约奖先进奖其他奖岗位津贴特殊津贴保健津贴技术津贴年功津贴其他津贴物价补贴交通费补贴电话费补贴误餐费补贴加班（天）加班工资加班（天）加班工资加点（小时）加点工资1李一部门1sc00170002000500100960096003397287062604966160001005000105016520030302王二部门2sc0027000200050010096009600226484353130248386621005000105016520030303张三部门3sc0037000200050010096009600113242176615124143311005000105016520030304刘四部门4sc0042000500200902790279031154820526014434650100500010501655030305陈五部门5sc00520005002009027902790277041026307222517100500010501655030306杨六部门6sc0062000500200902790279013852513153611259100500010501655030307赵七部门7sc007500200100080083033438611604291383100500010501652030308黄八部门8sc00850020010008008302229430530215749100500010501652030309周九部门9sc009500200100080083011142153151073741005000105016520303010吴十部门10sc010083000000011徐11部门11sc01112003002001001800180000001005000105016530303012孙12部门12sc012830000000合合计计29700297008400840026002600670670413704137043120431201818109411094142421701917019315315119661196639926399261000100050050000001001005050001650165084084000000000000030030030030000制制表表部部门门：

制制表表人人签签名名：

注：

本表主要针对企业“用工成本”的自动预算使用。

本本表表由由贵贵州州六六盘盘水水noonanyonenoonanyone拟拟制制，仅仅供供参参考考、学学习习。

20122012年年33月月2626日日应应发发工工资资总总合合计计（元元）代代扣扣代代缴缴及及应应扣扣费费用用合计（元）特特殊殊情情况况工工资资合计（元）社社会会保保险险费费住房补贴其他补贴因病工伤产假婚假丧假事假探亲假定期休假停工学习计划生育假其他原因养养老老保保险险失失业业保保险险医医疗疗保保险险工工伤伤保保险险生生育育保保险险个人合计（元）缴费基数缴费比例缴费基数缴费比例缴费基数缴费比例缴费基数缴费比例缴费基数缴费比例个人（8%）单位（20%）个人（1%）单位（2%）个人（2%）单位（7%）个人（0%）单位（煤矿）单位（非煤矿）个人（0%）单位（0.5%）吨数3元0.8%或2%或3%260000000000000260252602578636291573786379157849617059528320005708496428782600186871868778636291573786379157786315755028320005708496428652600143561435678636291573786379157786315755028320005708496428651100771577157715617154377157715477151545402832000570771539849110055825582558244711165582561125582112391283200057055822861411004324432443243468654324438643248630328320005704324224768002458245824581974922458254924584917228320005702458122708001824182418241463651824183618353712828320005701982102018001449144915731263151573163118353712828320005701982101780083083015731263151573163118353712828320005701982101789002055205520551644112055214120554114428320005702055102260083083015731263151573163118353712828320005701982101780000144014400000000000000000000000008613686136522665226641814181104531045352266522665235231045104553696536961074107437593759339843398400000068068000555505555027827857785778会会计计核核准准签签名名：

出出纳纳签签名名：

自自动动计计算算工工资资表表（含含公公式式、参参数数）代代扣扣代代缴缴及及应应扣扣费费用用总总合合计计（元元）实实发发工工资资总总额额合合计计（元元）确确认认签签印印领领取取应缴社会保险费总合计（元）住住房房公公积积金金个个人人所所得得税税其其他他应应扣扣费费用用合计（元）单位合计（元）缴存基数缴存比例（5%12%）合计工资薪金所得应纳税额个人所得税（元）事假病假旷工迟到早退违反规章制度造成单位经济损失费其他原因个人（5%）（元）单位（5%）（元）2424330184964254258502472343010000000005603204222379324484964254258501739724690000000037591492823793244849642542585013066138700000000267611680233331817715386386772648119300000000142762881703231755822792795584689360000000092946541332180843242162164323632400000000696362878210522458123123246206500000000039320655967971824919118215320000000002921532541719144972721451199000000000251119954171983042428361000000000022061066388920551031032061726000000000329172654171983042428361000000000022061016215162152199321993525555255526282628262826285256525677730777308389838900000000000000000016795167956934169341负负责责人人审审核核签签名名：