工资表-自动计算查询查询明细员工姓名部门名称应发工资应扣工资代扣合计实发工资基本工资绩效工资提成考勤扣款业务扣款个税
代缴社会
保险公积金员工1销售部3000250030002000150.24008006949.8应发合计应扣合计代扣合计实发工资70200110010852.958247.1序号员工姓名部门名称基本工资绩效工资提成应发工资考勤扣款业务扣款扣款合计个税
代缴社会
保险公积金代扣合计实发工资员工签字备注1员工1销售部3000250030008500200200150.24008001350.26949.80 2员工2销售部3000300028008800100100151.24008001351.27348.80 3员工3销售部30002000350085000152.24008001352.27147.80 4员工4销售部3000300030009000300300153.24008001353.27346.80 5员工5销售部3000250028008300200200154.24008001354.26745.80 6员工6销售部30002500360091000155.24008001355.27744.80 7员工7销售部3000300020008000100100156.24008001356.26543.80 8员工8销售部30004000300010000200200180.54008001380.58419.50