工资表自动计算个税和税后工资.xlsx

本月发放工资总计：¥104,913.05序号姓名部门身份证号银行卡卡号银行开户行应发工资应扣工资代扣工资税前工资实发工资基本工资补贴加班费全勤奖合计事病假其它扣款合计社保扣除1微风财务部5105210999125571农业银行80005005002009200100010096.410009003.690.118913.492微风财务部5105210999125571建设银行500050050010061000505096.405953.628.615924.993微风财务部510521099912557150005002001005800010010096.405603.618.115585.494微风财务部51052109991255715000500200200590000096.405803.624.115779.495微风财务部5105210999125571500050020010058000505096.405653.619.615633.996微风财务部51052109991255713000500200100380000096.403703.603703.67微风财务部5105210999125571300050020003700010010096.403503.603503.68微风财务部5105210999125571300050000350000096.403403.603403.69微风财务部5105210999125571300050000350000096.403403.603403.610微风财务部5105210999125571300050000350000096.403403.603403.611微风财务部510521099912557130005002000370000096.403603.603603.612微风财务部510521099912557130005002000370000096.403603.603603.613微风财务部510521099912557130005002000370000096.403603.603603.614微风财务部510521099912557130005002000370000096.403603.603603.615微风财务部510521099912557130005002000370000096.403603.603603.616微风财务部510521099912557130005002000370000096.403603.603603.617微风财务部510521099912557130003002000350000096.403403.603403.618微风财务部510521099912557130003002000350000096.403403.603403.619微风财务部510521099912557130003002000350000096.403403.603403.620微风财务部510521099912557130003002000350000096.403403.603403.621微风财务部510521099912557130003002000350000096.403403.603403.622微风财务部510521099912557130003002000350000096.403403.603403.623微风财务部510521099912557130003002000350000096.403403.603403.624微风财务部510521099912557130003002000350000096.403403.603403.625微风财务部510521099912557130003002000350000096.403403.603403.626微风财务部510521099912557130003002000350000096.403403.603403.6金额合计：910001100052008001080001003004002506.41000105093.6180.55104913.05XXX月份工资表专项抵扣扣税工资领款人签字