自动计算的工资表

编号部门姓名全勤出勤缺勤考核天数基本工资岗位工资出勤工资考核标准考核得分考核工资加班工资补助标准应发补助应发工资超税基工资扣款项目实发工资签名备注三险罚款所得税扣款其他小计1部门1262512680022001644.231100.0098970.20290.492904.92767138.2951.66189.952714.97迟到2次2262512680012001211.54600.0098529.20193.421934.15-204138.290.00138.291795.86迟到1次,年假4天326224228001000990.00500.00100380.77152.311523.08-615138.290.00138.291384.79迟到2次，年假0.5天4262602680026001890.001300.001001170.00340.003400.001262138.29101.17239.463160.5452626080012000.00600.00960.000.000.00-2138138.290.00138.29-138.29迟到1次6262608006000.00300.00940.000.000.00-2138138.290.00138.29-138.29迟到2次7部门22626080022000.001100.00700.000.000.00-2138138.290.00200.00338.29-338.295月发错货连带责任罚款8262608006000.00300.001000.000.000.00-2138138.290.00138.29-138.299262608006000.00300.00800.000.000.00-2138138.290.00138.29-138.29102626080016000.00800.00800.000.000.00-2138138.290.000.00138.29-138.2911262608004000.00200.00800.000.005.715.71-2133138.290.00138.29-132.58年假5天12262608004000.00200.001000.000.00210.82210.82-1927138.290.00138.2972.5313262608004000.00200.00800.000.00108.93108.93-2029138.290.00138.29-29.36迟到1次14262608004000.00200.001000.000.0077.8077.80-2060138.290.00138.29-60.4915262608004000.00200.001000.000.00298.35298.35-1840138.290.00138.29160.0616262608004000.00200.00770.000.000.300.30-2138138.290.00138.29-137.99迟到1次172626080010000.00500.001000.000.000.00-20000.000.000.00182626080010000.00500.00900.000.000.00-2138138.290.00138.29-138.2919262608006000.00300.001000.000.000.00-2138138.290.00400.00538.29-538.295月发错货扣款20262608004000.00200.00800.000.009.759.75-2129138.290.00138.29-128.54年假3天21262608004000.00200.00800.000.000.00-2138138.290.00138.29-138.2922262608004000.00200.00750.000.000.00-2138138.290.00138.29-138.2923262608001000.0050.001000.000.000.00-20000.000.0005.23入职24262608004000.00200.001000.000.000.00-20000.000.000.00加6月份25262605000.000.000.000.000.00-20000.000.000.00262626080012000.00600.001000.000.00-2138138.290.001483.221621.51-1621.51272626080027000.001350.001000.000.00-20000.000.000.00282626080022000.001100.001000.000.000.00-20000.00189.18189.18-189.1829262608000.000.000.000.00-2207207.480.00207.48-207.48302626080022000.001100.001000.000.000.00-20000.00189.18189.18-189.18312626080010000.00500.001000.000.000.00-2138138.290.00138.29-138.29322626080010000.00500.001000.000.000.00-2138138.290.00138.29-138.29332626080010000.00500.001000.000.000.00-2138138.290.00138.29-138.2934262608008000.00400.001000.000.000.00-2138138.290.00138.29-138.29352626080014000.00700.001000.000.000.00-2138138.290.00138.29-138.29362626080014000.00700.001000.000.000.00-2138138.290.00138.29-138.29372626080010000.00500.001000.000.000.00-2138138.290.00138.29-138.2938262608004000.00200.001000.000.000.00-2138138.290.00138.29-138.2939262608006000.00300.001000.000.000.00-20000.000.0040262608006000.00300.001000.000.000.00-2138138.290.00138.29-138.2941262608004000.00200.001000.000.000.00-2138138.290.00138.29-138.2942262608008000.00400.001000.000.000.00-2138138.290.00138.29-138.29432626080014000.00700.00980.000.000.00-20000.000.000.00442626080010000.00500.001000.000.000.00-2138138.290.00138.29-138.29452626080012000.00600.001000.000.000.00-2138138.290.00138.29-138.2946262608004000.00200.001000.000.000.00-2138138.29138.29276.58-276.58472626080042000.002100.001000.000.00-20000.000.000.00482626080012000.00600.001000.000.00-20000.000.000.004926260100030000.001500.001000.000.00-2207207.480.00207.48-207.485026260100035000.001750.001000.000.00-2207207.480.00207.48-207.485126260100040000.002000.001000.000.00-2207207.480.00207.48-207.48522626080010000.00500.001000.000.000.00-2138138.290.00138.29-138.29532626080048000.002400.00980.000.000.00-2138138.290.00138.29-138.29542626080012000.00600.00990.000.000.00-2138138.290.00138.29-138.29552626080016000.00800.00980.000.00-2138138.290.00138.29-138.29562626080014000.00700.00880.000.00-2138138.290.00138.29-138.29572626080014000.00700.001000.000.00-2138138.290.00138.29-138.29582626080012000.00600.00880.000.00-2138138.290.00138.29-138.29592626080016000.00800.00970.000.00-2138138.290.00138.29-138.29602626080012000.00600.00750.000.00-2138138.290.00138.29-138.29612626080012000.00600.001000.000.00-2138138.290.00138.29-138.29622626080010000.00500.00960.000.00-2138138.290.00138.29-138.29632626080010000.00500.001000.000.00-2138138.290.00138.29-138.29642626080047000.002350.00990.000.000.00-2138138.290.000.000.0138.29-138.2965262608008000.00400.00990.000.000.00-20000.000.000.00662626080012000.00600.00900.000.00-2138138.290.00138.29-138.29672626080010000.00500.001000.000.00-20000.000.000.00682626080010000.00500.001000.000.00-2138138.290.00138.29-138.29692626080026000.001300.00980.000.00-2138138.290.003137.143275.43-3275.43702626080010000.00500.001000.000.00-20000.000.000.007126260100040000.002000.001000.000.00-20000.000.000.000.007226260100040000.002000.001000.000.00-20000.000.000.000.000.00732626080044000.002200.00960.000.00-2138138.290.00138.29-138.29742626080032000.001600.00820.000.00-20000.000.000.00752626080024000.001200.00850.000.00-2138138.290.00138.29-138.29162.122626080024000.001200.00900.000.00-20000.00162.12162.12-162.12772626080024000.001200.001000.000.00-20000.000.000.00782626080024000.001200.001000.000.00-2138138.290.00138.29-138.29792626080021000.001050.00970.000.00-2138138.290.00192.000.0330.29-330.29802626080021000.001050.00970.000.00-2138138.290.00138.29-138.29812626080018000.00900.00970.000.00-20000.00213.18213.18-213.18822626080021000.001050.00980.000.00-20000.000.000.00832626080024000.001200.00900.000.00-20000.000.000.00842626080021000.001050.00970.000.00-2138138.290.00138.29-138.29852626080021000.001050.00900.000.00-2138138.290.00138.29-138.29862626080021000.001050.00900.000.00-2138138.290.00138.29-138.29872626080015200.00760.001000.000.00-20000.000.000.00882626080014000.00700.00900.000.00-2138138.290.00138.29-138.29892626080014000.00700.00900.000.00-20000.00144.76144.76-144.76902626080015200.00760.001000.000.00-20000.000.000.00912626080015200.00760.001000.000.00-20000.000.000.00922626080015200.00760.001000.000.00-20000.000.000.00932626080015200.00760.001000.000.00-20000.000.000.00942626080015200.00760.001000.000.00-20000.000.000.00952626080015200.00760.001000.000.00-20000.000.000.00962626080015200.00760.001000.000.00-20000.000.000.00972626080015200.00760.001000.000.00-20000.000.000.00982626080015200.00760.001000.000.00-20000.000.000.00992626080022000.001100.001000.000.00-20000.000.000.0010026260100040000.002000.001000.000.00-2207207.4800.00207.48-207.481012626080036000.001800.001000.000.00-2138138.290.00138.29-138.291022626080018000.00900.001000.000.000.00-2138138.290.00138.29-138.291032626080012000.00600.001000.000.00-2138138.290.00138.29-138.29104262608007000.00350.001000.000.000.00-2138138.290.00138.29-138.291052626080010000.00500.001000.000.00-20000.00138.29138.29-138.291062626080021000.001050.001000.000.00-2138138.290.00138.29-138.291072626080014000.00700.001000.000.00-2138138.290.00138.29-138.291082626080012000.00600.001000.000.00-2138138.290.00138.29-138.291092626080012000.00600.001000.000.00-2138138.290.00138.29-138.291102626080012000.00600.001000.000.00-20000.0097.1997.19-97.191112626080018000.00900.001000.000.00-20000.00144.76144.76-144.761122626080012000.00600.001000.000.00-2138138.290.00138.29-138.291132626080012000.00600.001000.000.00-2138138.290.00138.29-138.291142626080021000.001050.001000.000.00-2138138.290.000.00138.29-138.291152626080016000.00800.001000.000.00-2138138.290.00138.29-138.29116262608005500.00275.001000.000.000.00-2138138.290.00138.29-138.291172626080014000.00700.001000.000.00-20000.00289.52289.52-289.5211826260100040000.002000.001000.000.00-2207207.480.00207.48-207.48119262608000.000.000.000.00-20000.000.000.00总计96300.00185450.005735.7792725.0011190.003050.17976.220.00711.6610473.81-239004.5311478.340.00152.837118.830.0018750.00-8276.19各部门费用统计部门15600.005800.000.002900.00698.000.000.000.000.000.00-14829.74829.740.000.00138.290.00968.03-968.03部门2800.001200.000.00600.00100.000.000.000.000.000.00-2138.29138.290.000.001483.220.001621.51-1621.51部门31600.004900.000.002450.00200.000.000.000.000.000.00-4000.000.000.000.00189.180.00189.18-189.18部门414900.0011700.000.005850.001592.000.000.000.00711.66711.66-39362.692074.350.000.00600.000.002674.35-1962.69部门58800.0010800.000.005400.001000.000.000.000.000.000.00-23313.801313.800.000.00189.180.001502.98-1502.98部门64800.008800.005735.774400.00586.003050.17976.220.000.009762.15-3067.59829.740.00152.830.000.00982.578779.58部门715200.0030900.000.0015450.001825.000.000.000.000.000.00-40212.642212.640.000.003137.140.005349.78-5349.78部门823600.0062200.000.0031100.002789.000.000.000.000.000.00(59244.61)1244.610.000.00712.060.001956.67(1956.67)部门914600.0029250.000.0014625.001800.000.000.000.000.000.00-38005.252005.250.000.00669.760.002675.01-2675.01部门104600.0015900.000.007950.00500.000.000.000.000.000.00(10622.44)622.440.000.000.000.00622.44(622.44)2626100040000200010000000-2207.48207.480000207.48-207.4810800000000000-2000000000096300.00185450.005735.7792725.0011190.003050.17976.220.00711.6610473.81(239004.53)11478.340.00152.837118.830.0018750.00(8276.19)