Excel表格通用模板：智能工资管理系统(自动按部门生成工资条).xls

工工 资资 管管 理理 系系 统统基基础础数数据据录录入入及及查查询询2018/2/12部部门门工工资资查查询询及及工工资资条条打打印印工工资资调调整整表表营营销销科科工工资资查查询询表表外外籍籍干干部部管管理理部部考考勤勤表表员员工工伙伙食食费费员员工工住住宿宿费费其其他他扣扣款款奖奖惩惩及及其其他他帐帐号号资资料料总总务务部部保保洁洁厨厨房房资资材材科科品品管管科科生生产产部部月月薪薪修修缮缮组组技技术术部部维维修修科科加加工工组组计计税税方方法法个个人人所所得得税税错错误误调调整整工工资资汇汇总总表表2018/2/12目 录包包装装组组冲冲压压组组退出系统工工资资汇汇总总表表工工资资调调整整表表考考勤勤表表员员工工住住宿宿费费其其他他扣扣款款奖奖惩惩及及其其他他目 录工工资资汇汇总总表表20182018年年2 2月月12 12日日单单位位：人人民民币币元元全全勤勤天天数数:2323部门人数基本工资 岗位津贴 其他基本工资基本工资百 分 比平时加班周末加班平时加班费周末加班费加班费加班工资百 分 比应发工资代扣伙食代扣住宿代扣其他个人所得税实得工资外籍33,0002,99705,997100.00%000000.00%5,9970010505,892管理部33,0002,96405,964100.00%000000.00%5,9640040585,867营销科54,8264,76809,594100.00%000000.00%9,59419301,628807,694总务部55,0004,90409,90495.84%48043004304.16%10,334282041329,915保洁厨房32,6002,9252005,725100.00%000000.00%5,725000465,678资材科43,2503,84907,09965.40%2702171,8151,9403,75534.60%10,854163202535110,296品管科43,0873,63706,72476.75%1351269071,1292,03723.25%8,76196001768,488生产部43,7503,90407,65489.64%535935652988510.36%8,5390001318,407修缮组32,2502,92805,17861.06%2072141,3881,9143,30238.94%8,480193082937,986技术部43,6153,90207,51780.83%115988399431,78319.17%9,30025701822028,659维修科43,5953,87807,47370.07%1971611,5271,6643,19229.93%10,6656007833210,195加工组31,6882,15603,84374.83%107647195741,29325.17%5,13675600814,920包装组32,2502,901-745,07771.95%1091407291,2501,98028.05%7,05773001706,814冲压组32,2502,892-1005,04262.59%1672111,1231,8913,01437.41%8,056602062517,7202018年2月合计5144,16148,6042692,79181.07%1,407 1,2889,83511,83521,66918.93%114,4601,4511002,0772,302.21108,531本本月月实实发发工工资资合合计计大大写写金金额额：壹壹拾拾万万捌捌仟仟伍伍佰佰叁叁拾拾壹壹元元整整*公公司司员员工工信信息息查查询询界界面面部门：技术部工号：E0002姓名：E0002出勤天数：平时加班工时：-平时加班工资：-23周末加班工时：-周末加班工资：-本 薪：1,000.00技能工资：992.00加班工资合计：-其 他：-应发工资：1,992.00其他扣款：-伙 食 费：-住 宿 费：-个人所得税：19.60实发合计：1,972.001,972.00工资调整总表截止序号工号姓名部门职务基本工资 岗位津贴合计入职时间1A0001A00011000100020002A0002A0002100099919993A0003A0003100099819987MS002MS002100099719978MS006MS006100099619969MD032MD0321000995199510Q0001Q00011000994199411A0020A00201000993199312E0002E00021000992199213A0030A00301000991199114P0003P00031000990199015A0012A00121000989198916A0016A00161000988198817A0018A00181000987198723A0022A00221000986198624A0035A00351000985198525A0040A00401000984198432A0015A00151000983198333A0046A00461000982198234A0029A00291000981198139A0019A0019总务部保安1000980198040A0032A0032保洁保洁800979177941A0034A0034总务部保安1000978197858AX001AX001修缮组電工750977172759AX003AX003修缮组木工750976172660AX004AX004修缮组電工750975172561C0001C0001厨房厨房1000974197462C0004C0004厨房厨房800973177363C0006C0006厨房厨房80097217724月-0771E0007E0007技术部865971183672E0011E0011技术部文員1000970197073E0015E0015技术部750969171979MB002MB002资材科750968171880MB003MB003包装组包裝750967171781MB004MB004包装组包裝7509661716272MC001MC001冲压组沖壓7509651715273MC002MC002冲压组沖壓7509641714274MC003MC003冲压组7509631713365MD002MD002维修科维修班长8659621827366MD003MD003维修科8659611826367MD006MD006维修科模具8659601825409MJ003MJ003加工组7509591709410MJ004MJ004加工组加工7509581708411MJ005MJ005加工组7509571707475MS004MS004生产部10009561956476MS007MS007生产部7509551705482P0004P0004资材科加工7509541704483P0005P0005资材科倉庫7509531703484P0006P0006资材科倉庫7509521702513Q0003Q0003品管科組長7509511701514Q0005Q0005品管科品管7509501700515Q0006Q0006品管科品管75094916995月-07最后一次调整时间1111115月-0714月-07113月-07110月-0614月-07110月-0614月-0713月-07116月-071117月-06111111110114月-07111114月-07111114月-0711114月-0717月-07114月-071114月-0711计算工时全勤天数:23新進人員離職人員月薪基本资料工资系统(用公式）考勤系统备注工号姓名出勤天数平时加班周末加班 平时加班 周末加班 休假天数部门A0012A00122300管理部A0015A00152300000總務A0016A00162300管理部A0018A00182300管理部A0019A00192300000總務A0020A00202300營銷部A0022A00221900營銷部A0029A00292300000總務A0030A00302300營銷部A0032A003223A0034A0034234804800總務A0035A00352300營銷部A0040A00402300營銷部A0046A00462300000總務AX001AX0012373.574.573.574.50 修繕組AX003AX003236269.56269.50 修繕組AX004AX004237169.57169.50 修繕組C0001C000123C0006C000623E0002E00022300技術课E0007E00072367.550.567.550.50 技術课E0011E00112300技術课E0015E001523474747510.5 技術课MB002MB0022355.561.555.5690.9375 包裝組MB003MB00323537853780 包裝組MB004MB0042300000 包裝組MC001MC00123577057700 沖壓組MC002MC00223567856780 沖壓組MC003MC00323546354630 沖壓組MD002MD0022382.58382.5830 維修课MD003MD0032356.57056.5781 維修课MD006MD0062358858566 維修课MD032MD0322300000 維修课MJ003MJ00314.5290293613 加工組MJ004MJ00423566456640 加工組MJ005MJ00514.25220221010 加工組MS002MS0022300生產课MS004MS0042300生產课MS006MS0062300生產课MS007MS0072353595359生產课P0003P00032300000 資材课P0004P000423118.566118.5660 資材课P0005P0005238768.58768.50 資材课P0006P00062364.58264.5820 資材课Q0001Q00012300000 品保課Q0003Q00031826026329 品保課Q0005Q000523566756751 品保課Q0006Q000623535953590 品保課2018年2月12日摘要A0012A00121A0015A00151A0016A00161A0018A00181A0019A00191A0020A00201A0022A00221A0029A00291A0030A00301滿勤A0032A00321A0034A00341A0035A00351A0040A00401A0046A00461AX001AX0011AX003AX0031AX004AX0041滿勤C0001C00011滿勤C0006C00061E0002E00021E0007E00071E0011E00111E0015E00151MB002MB0021MB003MB0031MB004MB0041MC001MC0011MC002MC0021MC003MC0031MD002MD0021MD003MD0031MD006MD0061备注MD032MD0321MJ003MJ0031MJ004MJ0041MJ005MJ0051MS002MS0021MS004MS0041MS006MS0061補6月 56/24MS007MS0071P0003P00031P0004P00041P0005P00051P0006P00061Q0001Q00011Q0003Q00031Q0005Q00051Q0006Q00061伙食费2018年2月12日工号姓名伙食费摘要MJ003MJ00325.681A0029A002925.681MB003MB00329.961MC001MC00129.961MC002MC00229.961P0004P000434.241Q0006Q000636.381MB002MB00242.801MJ004MJ00449.221MD002MD00259.921Q0005Q000559.921A0034A003464.201A0015A001564.201A0019A001964.201A0020A002064.201A0030A003064.201A0040A004064.201A0046A004664.201AX003AX00364.201AX004AX004128.401E0007E0007128.401E0015E0015128.401P0005P000564.201P0006P000664.201合计1,450.92MJ003MJ003A0029A0029MB003MB003MC001MC001MC002MC002P0004P0004Q0006Q0006MB002MB002MJ004MJ004MD002MD002Q0005Q0005A0034A0034A0015A0015A0019A0019A0020A0020A0030A0030A0040A0040A0046A0046AX003AX003AX004AX004E0007E0007E0015E0015P0005P0005P0006P0006住宿费2018年2月12日工号姓名金额摘要MC003MC003201MJ003MJ003201MJ004MJ004201MJ005MJ005201P0004P0004201合计100MC003MC003MJ003MJ003MJ004MJ004MJ005MJ005P0004P0004其他扣款2018年2月12日工号姓名金额借支押金手机费工卡工衣A0003A0003104.80104.80A0012A001239.7639.76A0015A00154.344.34A0020A0020161.00161.00A0022A00221,000.001,000A0030A0030451.32451.32A0035A003515.7015.70AX001AX0018.108.10E0015E0015182.22MC001MC0016.106.10MD002MD00243.1743.17MD006MD00628.1628.16MD032MD0326.706.70P0005P000525.2025.20合计2,076.571,000.000.00894.350.000.00其他摘要4月手机小灵通费7/1-7/31小灵通费用7/1-7/31小灵通费用6月份手机小灵通话费借支6月份手机小灵通话费7/1-7/31小灵通费用7/1-7/31小灵通费用182电费7/1-7/31小灵通费用7/1-7/31小灵通费用7/1-7/31小灵通费用7/1-7/31小灵通费用7/1-7/31小灵通费用182.222018年2月12日员工奖惩及其他日期:2018年2月工号姓名合计金额奖惩其他调整金额A0032A0032200200MC001MC001-100-100合计100-100200摘要（惩罚用负数，奖励用正数）割草补贴1A0032交接班中,未交接清楚1MC001员工奖惩及其他A0032MC001错误调整上上月月全全勤勤天天数数：2222日期:2018年2月工号姓名调整天数平时工时周末工时摘要MB002MB002-117月工时错误合计金额-73.94-73.94个人所得税明细表2018年2月12日序号工号姓名工資個人所得稅实发工资审核1A0001A00012,000.00-2,000.002A0002A00021,999.00-1,999.003A0003A00031,998.00-1,893.004A0012A00121,989.0019.451,930.005A0016A00161,988.0019.401,969.006A0018A00181,987.0019.351,968.007A0015A00151,983.0019.151,895.008A0029A00291,981.0019.051,936.009A0046A00461,982.0019.101,899.0010A0019A00191,980.0019.001,897.0011A0034A00342,408.2155.822,288.0012A0020A00201,993.0019.651,748.0013A0030A00301,991.0019.551,456.0014A0022A00221,640.612.03639.0015A0035A00351,985.0019.251,950.0016A0040A00401,984.0019.201,901.0017AX001AX0012,888.79103.882,777.0018AX003AX0032,765.6791.572,610.0019AX004AX0042,825.1797.522,599.0020A0032A00321,979.0018.951,960.0021C0001C00011,974.0018.701,955.0022C0006C00061,772.008.601,763.0023E0002E00021,992.0019.601,972.0024E0011E00111,970.0018.501,952.0025E0007E00072,881.33103.132,650.0026E0015E00152,456.1860.622,085.0027MB002MB0022,568.3471.832,454.0028MB003MB0032,772.3692.242,650.0029MB004MB0041,716.005.801,710.0030MC001MC0012,625.5577.552,512.0031MC002MC0022,789.5393.952,666.0032MC003MC0032,640.6479.062,542.0033MD032MD0321,995.0019.751,969.0034MD002MD0023,324.57147.463,074.0035MD003MD0032,987.62113.762,874.0036MD006MD0062,357.3650.742,278.0037MJ003MJ0031,272.35-1,227.0038MJ004MJ0042,658.0580.802,508.0039MJ005MJ0051,205.48-1,185.0040MS002MS0021,997.0019.851,977.0041MS006MS0061,996.0019.801,976.0042MS004MS0041,956.0017.801,938.0043MS007MS0072,590.0774.012,516.0044P0003P00031,990.0019.501,971.0045P0004P00043,092.10124.212,914.0046P0005P00052,901.76105.182,707.0047P0006P00062,870.51102.052,704.0048Q0001Q00011,994.0019.701,974.0049Q0003Q00031,505.99-1,506.0050Q0005Q00052,676.9482.692,534.0051Q0006Q00062,584.0773.412,474.00合计114,460.252,302.21108,531.00银行帐号帐号姓名现金发放00 5110.00现金发放00 5111.00现金发放00 5112.00000000001A001211 4320.00000000003A001611 4321.00000000004A001811 4322.00000000002A001511 2042.00000000011A002911 2043.00000000026A004611 2044.00000000005A001911 2045.00000000016A003411 2046.00000000006A002011 1229.00000000012A003011 1230.00000000008A002211 1231.00000000017A003511 1232.00000000021A004011 1233.00000000047AX00111 3203.00000000048AX00311 3204.00000000049AX00411 3205.00000000014A003211 1399.00000000050C000111 1400.00000000052C000611 1401.00现金发放10 2849.00现金发放10 2850.00000000058E000711 2851.00000000060E001511 2852.00000000065MB00211 2379.00000000066MB00311 1765.00000000067MB00411 1125.00000000236MC00111 2520.00000000237MC00211 2675.00000000238MC00311 1724.00000000338MD03211 4589.00000000320MD00211 4590.00000000321MD00311 3110.00000000322MD00611 3111.00000000356MJ00311 702.00000000357MJ00411 703.00000000358MJ00511 704.00现金发放10 1448.00现金发放10 1449.00000000423MS00411 1450.00现金发放10 1451.00现金发放10 2134.00000000429P000411 2135.00000000430P000511 2136.00000000431P000611 2137.00现金发放10 1968.00000000458Q000311 1969.00000000459Q000511 1970.00000000460Q000611 1971.00员工帐号工号姓名银行帐号A0012A00120000000011930 A0012A0012A0015A00150000000021895 A0015A0015A0016A00160000000031969 A0016A0016A0018A00180000000041968 A0018A0018A0019A00190000000051897 A0019A0019A0020A00200000000061748 A0020A0020A0022A0022000000008639 A0022A0022A0029A00290000000111936 A0029A0029A0030A00300000000121456 A0030A0030A0032A00320000000141960 A0032A0032A0034A00340000000162288 A0034A0034A0035A00350000000171950 A0035A0035A0040A00400000000211901 A0040A0040A0046A00460000000261899 A0046A0046AX001AX0010000000472777 AX001AX001AX003AX0030000000482610 AX003AX003AX004AX0040000000492599 AX004AX004C0001C00010000000501955 C0001C0001C0006C00060000000521763 C0006C0006E0007E00070000000582650 E0007E0007E0015E00150000000602085 E0015E0015MB002MB0020000000652454 MB002MB002MB003MB0030000000662650 MB003MB003MB004MB0040000000671710 MB004MB004MC001MC0010000002362512 MC001MC001MC002MC0020000002372666 MC002MC002MC003MC0030000002382542 MC003MC003MD002MD0020000003203074 MD002MD002MD003MD0030000003212874 MD003MD003MD006MD0060000003222278 MD006MD006MD032MD0320000003381969 MD032MD032MJ003MJ0030000003561227 MJ003MJ003MJ004MJ0040000003572508 MJ004MJ004MJ005MJ0050000003581185 MJ005MJ005MS004MS0040000004231938 MS004MS004P0004P00040000004292914 P0004P0004P0005P00050000004302707 P0005P0005P0006P00060000004312704 P0006P0006Q0003Q00030000004581506 Q0003Q0003Q0005Q00050000004592534 Q0005Q0005Q0006Q00060000004602474 Q0006Q00061.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.00个人所得税税率表级数含税级距税率(%)速算扣除数1不超过500元的502超过500元至2000元的部分10253超过2000元至5000元的部分151254超过5000元至20000元的部分203755超过20000元至40000元的部分2513756超过40000元至60000元的部分3033757超过60000元至80000元的部分3563758超过80000元至100000元的部分40103759超过100000元的部分4515375台籍人员扣除费用：4800一般员工扣除费用：1600管理部工资序号工号姓名天数基本工资岗位津贴平时加班周末加班平时加班费周末加班费加班费其他应发工资代扣伙食代扣住宿代扣其他个人所得税实得工资月份1A0001A0001231,0001,000-2,000-2,000#REF!2A0002A0002231,000999-1,999-1,999#REF!3A0003A0003231,000998-1,998105-1,893#REF!合计33,0002,997-5,997-105-5,892#REF!本本月月实实发发工工资资合合计计大大写写金金额额：伍伍仟仟捌捌佰佰玖玖拾拾贰贰元元整整管理部工资序号工号姓名天数 基本工资岗位津贴平时加班周末加班平时加班费周末加班费加班费其他应发工资代扣伙食代扣住宿代扣其他个人所得税实得工资月份1A0012A0012231,000989-1,989-4019.451,930#REF!A00122A0016A0016231,000988-1,988-19.401,969#REF!A00163A0018A0018231,000987-1,987-19.351,968#REF!A0018合计33,0002,964-5,964-4058.205,867A0012 A0012 A0012A0016 A0016 A0016A0018 A0018 A0018营销科工资#REF!序号工号姓名天数基本工资岗位津贴平时加班周末加班平时加班费周末加班费加班费其他应发工资代扣伙食代扣住宿代扣其他个人所得税实得工资月份1A0020A0020231,000993-1,99364-16119.651,748#REF!2A0030A0030231,000991-1,99164-45119.551,456#REF!3A0022A002219826815-1,641-1,0002.03639#REF!4A0035A0035231,000985-1,985-1619.251,950#REF!5A0040A0040231,000984-1,98464-19.201,901#REF!合计54,8264,768-9,594193-1,62879.687,694#REF!A0020 A0020 A0020 A0020A0030 A0030 A0030 A0030A0022 A0022 A0022 A0022A0035 A0035 A0035 A0035A0040 A0040 A0040 A0040总务部工资日期:2018年2月序号工号姓名天数基本工资岗位津贴平时加班周末加班平时加班费周末加班费加班费其他应发工资代扣伙食代扣住宿代扣其他个人所得税实得工资月份1A0015A0015231,000983-1,98364-419.151,8952月2A0029A0029231,000981-1,98126-19.051,9362月3A0046A0046231,000982-1,98264-19.101,8992月4A0019A0019231,000980-1,98064-19.001,8972月5A0034A0034231,00097848-430-430-2,40864-55.822,2882月合计55,0004,90448-430-430-10,334282-4132.129,9152月A0015 A0015 A0015 A0015A0029 A0029 A0029 A0029A0046 A0046 A0046 A0046A0019 A0019 A0019 A0019A0034 A0034 A0034 A0034保洁厨房工资#REF!序号工号姓名天数基本工资岗位津贴平时加班周末加班平时加班费周末加班费加班费其他应发工资代扣伙食代扣住宿代扣其他个人所得税实得工资月份1A0032A003223800979-2001,979-18.951,960#REF!A0032A0032A00322C0001C0001231,000974-1,974-18.701,955#REF!C0001C0001C00013C0006C000623800972-1,772-8.601,763#REF!C0006C0006C0006合计32,6002,9252005,725-46.255,678#REF!A0032C0001C0006资材科工资#REF!序号工号姓名天数 基本工资 岗位津贴平时加班周末加班平时加班费周末加班费加班费其他应发工资代扣伙食代扣住宿代扣其他个人所得税实得工资月份1P0003P0003231,000990-1,990-19.501,971#REF!2P0004P000423750954119667975921,388-3,0923420-124.212,914#REF!3P0005P00052375095387695856141,199-2,90264-25105.182,707#REF!4P0006P00062375095265824347351,169-2,87164-102.052,704#REF!合计43,2503,8492702171,8151,9403,755010,8541632025350.9410,296#REF!P0003P0003P0003P0003P0004P0004P0004P0004P0005P0005P0005P0005P0006P0006P0006P0006品管科工资#REF!序号工号姓名天数 基本工资 岗位津贴平时加班周末加班平时加班费周末加班费加班费其他应发工资代扣伙食代扣住宿代扣其他个人所得税实得工资月份1Q0001Q0001231,000994-1,994-19.701,974#REF!2Q0003Q00031858774426-175-175-1,506-1,506#REF!3Q0005Q0005237509505667376601977-2,67760-82.692,534#REF!4Q0006Q0006237509495359356529885-2,58436-73.412,474#REF!合计43,0873,6371351269071,1292,03708,7619600175.808,488#REF!Q0001 Q0001 Q0001 Q0001Q0003 Q0003 Q0003 Q0003Q0005 Q0005 Q0005 Q0005Q0006 Q0006 Q0006 Q0006生产部工资#REF!序号工号姓名天数 基本工资 岗位津贴平时加班周末加班平时加班费周末加班费加班费其他应发工资代扣伙食代扣住宿代扣其他个人所得税实得工资月份1MS002MS002231,000997-1,997-19.851,977#REF!2MS006MS006231,000996-1,996-19.801,976#REF!3MS004MS004231,000956-1,956-17.801,938#REF!4MS007MS007237509555359356529885-2,590-74.012,516#REF!合计43,7503,904535935652988508,539000131.468,407#REF!MS002 MS002 MS002 MS002MS006 MS006 MS006 MS006MS004 MS004 MS004 MS004MS007 MS007 MS007 MS007修缮组工资#REF!序号工号姓名天数基本工资 岗位津贴平时加班周末加班平时加班费周末加班费加班费其他应发工资代扣伙食代扣住宿代扣其他个人所得税实得工资月份1AX001AX0012375097774754946681,162-2,889-8103.882,777#REF!2AX003AX0032375097662704176231,040-2,76664-91.572,610#REF!3AX004AX0042375097571704776231,100-2,825128-97.522,599#REF!合计32,2502,9282072141,3881,9143,30208,48019308292.977,986#REF!AX001AX001AX001AX001AX003AX003AX003AX003AX004AX004AX004AX004技术部工资#REF!序号工号姓名天数 基本工资 岗位津贴平时加班周末加班平时加班费周末加班费加班费其他应发工资代扣伙食代扣住宿代扣其他个人所得税实得工资月份1E0002E0002231,000992-1,992-19.601,972#REF!2E0011E0011231,000970-1,970-18.501,952#REF!3E0007E00072386597168515235221,045-2,881128-103.132,650#REF!4E0015E0015237509694747316421737-2,456128-18260.622,085#REF!合计43,6153,902115988399431,78309,3002570182201.858,659#REF!E0002E0002E0002E0002E0011E0011E0011E0011E0007E0007E0007E0007E0015E0