员工工资计算管理Excel管理系统

员工基本信息及专项扣除序号姓名身份证号联系电话专项扣除专项附加扣除备注养老保险医疗保险失业保险三险合计公积金子女教育住房租金房贷利息赡养老人继续教育1王二小123321199002063456188666699992张三丰3李大锤4宋小宝5678910111213141516171819员工工资明细表编制单位深圳市有限公司申报属期2019"年"1"月"编号姓名本月工资合计专项扣除专项附加扣除本月应预缴所得额累计应预缴所得额累计应预缴税额累计已预缴税额本月实缴税额实发工资员工签名社保公积金子女教育住房租金房贷利息赡养老人继续教育1王二小90000020000100000150000130000130000390039008761002张三丰800000300000300000900090007910003李大锤590000900009000027002700587300456789101112131415161718合计22900002000000010000015000000000000015600000156002254400审核制表人员工工资明细表编制单位深圳市有限公司申报属期2019"年"2"月"编号姓名本月工资合计专项扣除专项附加扣除本月应预缴所得额累计应预缴所得额累计应预缴税额累计已预缴税额本月实缴税额实发工资员工签名社保公积金子女教育住房租金房贷利息赡养老人继续教育1王二小890000200001000001500001200002500007500390036008664002张三丰350000-150000150000450090000003500003李大锤789000150001500025900034900010470270077707512304宋小宝6692001692001692005076000507666412456789101112131415161718合计269820035000150001000001500000000000002754615600164462631754审核制表人员工工资明细表编制单位深圳市有限公司申报属期2019"年"3"月"编号姓名本月工资合计专项扣除专项附加扣除本月应预缴所得额累计应预缴所得额累计应预缴税额累计

已预缴税额本月实缴税额实发工资员工签名社保公积金子女教育住房租金房贷利息赡养老人继续教育1王二小8900002000010000015000012000037000011100750036008664002张三丰350000-15000000000090000003500003李大锤7890001500015000259000608000182401047077707512304宋小宝669200169200338400101525076507666412456789101112131415161718合计269820035000150001000001500000000000003949232046164462631754审核制表人员工工资明细表编制单位深圳市有限公司申报属期2019"年"4"月"编号姓名本月工资合计专项扣除专项附加扣除本月应预缴所得额累计应预缴所得额累计应预缴税额累计已预缴税额本月实缴税额实发工资员工签名社保公积金子女教育住房租金房贷利息赡养老人继续教育1王二小89000020000100000150000120000490000147001110036008664002张三丰350000-150000-15000000090000003500003李大锤7890001500015000259000867000260101824077707512304宋小宝6692001692005076001522810152507666412456789101112131415161718合计269820035000150001000001500000000000005593848492164462631754审核制表人员工工资明细表编制单位深圳市有限公司申报属期2019"年"5"月"编号姓名本月工资合计专项扣除专项附加扣除本月应预缴所得额累计应预缴所得额累计应预缴税额累计已预缴税额本月实缴税额实发工资员工签名社保公积金子女教育住房租金房贷利息赡养老人继续教育1王二小89000020000100000150000120000610000183001470036008664002张三丰350000-150000-30000000090000003500003李大锤78

900015000150002590001126000337802601077707512304宋小宝6692001692006768002030415228507666412456789101112131415161718合计269820035000150001000001500000000000007238464938164462631754审核制表人员工工资明细表编制单位深圳市有限公司申报属期2019"年"6"月"编号姓名本月工资合计专项扣除专项附加扣除本月应预缴所得额累计应预缴所得额累计应预缴税额累计已预缴税额本月实缴税额实发工资员工签名社保公积金子女教育住房租金房贷利息赡养老人继续教育1王二小89000020000100000150000120000730000219001830036008664002张三丰350000-150000-45000000090000003500003李大锤78900015000150002590001385000415503378077707512304宋小宝6692001692008460002538020304507666412456789101112131415161718合计269820035000150001000001500000000000008883081384164462631754审核制表人员工工资明细表编制单位深圳市有限公司申报属期2019"年"7"月"编号姓名本月工资合计专项扣除专项附加扣除本月应预缴所得额累计应预缴所得额累计应预缴税额累计已预缴税额本月实缴税额实发工资员工签名社保公积金子女教育住房租金房贷利息赡养老人继续教育1王二小89000020000100000150000120000850000255002190036008664002张三丰700000200000-25000000090000007000003李大锤78900015000150002590001644000493204155077707512304宋小宝66920016920010152003045625380507666412456789101112131415161718合计304820035000150001000001500

00000000325920010527697830164462981754审核制表人员工工资明细表编制单位深圳市有限公司申报属期2019"年"8"月"编号姓名本月工资合计专项扣除专项附加扣除本月应预缴所得额累计应预缴所得额累计应预缴税额累计已预缴税额本月实缴税额实发工资员工签名社保公积金子女教育住房租金房贷利息赡养老人继续教育1王二小89000020000100000150000120000970000291002550036008664002张三丰700000200000-5000000090000007000003李大锤78900015000150002590001903000570904932077707512304宋小宝66920016920011844003553230456507666412456789101112131415161718合计304820035000150001000001500000000004007400121722114276164462981754审核制表人员工工资明细表编制单位深圳市有限公司申报属期2019"年"9"月"编号姓名本月工资合计专项扣除专项附加扣除本月应预缴所得额累计应预缴所得额累计应预缴税额累计已预缴税额本月实缴税额实发工资员工签名社保公积金子女教育住房租金房贷利息赡养老人继续教育1王二小56000020000100000150000-21000076000022800291000005400002张三丰700000200000150000450090000007000003李大锤78900015000150002590002162000648605709077707512304宋小宝66920016920013536004060835532507666412456789101112131415161718合计271820035000150001000001500000000004425600132768130722128462655354审核制表人员工工资明细表编制单位深圳市有限公司申报属期2019"年"10"月"编号姓名本月工资合计专项扣除专项附加扣除本月应预缴所得额累计应预缴所得额累计应预缴税额累计已预缴税额本月实

缴税额实发工资员工签名社保公积金子女教育住房租金房贷利息赡养老人继续教育1王二小56000020000100000150000-21000055000016500291000005400002张三丰70000020000035000010500900015006985003李大锤78900015000150002590002421000726306486077707512304宋小宝66920016920015228004568440608507666412456789101112131415161718合计271820035000150001000001500000000004843800145314143568143462653854审核制表人员工工资明细表编制单位深圳市有限公司申报属期2019"年"11"月"编号姓名本月工资合计专项扣除专项附加扣除本月应预缴所得额累计应预缴所得额累计应预缴税额累计已预缴税额本月实缴税额实发工资员工签名社保公积金子女教育住房租金房贷利息赡养老人继续教育1王二小56000020000100000150000-21000034000010200291000005400002张三丰700000200000550000165001050060006940003李大锤78900015000150002590002680000804007263077707512304宋小宝66920016920016920005076045684507666412456789101112131415161718合计271820035000150001000001500000000005262000157860157914188462649354审核制表人员工工资明细表编制单位深圳市有限公司申报属期2019"年"12"月"编号姓名本月工资合计专项扣除专项附加扣除本月应预缴所得额累计应预缴所得额累计应预缴税额累计已预缴税额本月实缴税额实发工资员工签名社保公积金子女教育住房租金房贷利息赡养老人继续教育1王二小56000020000100000150000-2100001300003900291000005400002张三丰700000200000750000225001

650060006940003李大锤78900015000150002590002939000881708040077707512304宋小宝66920016920018612005583650760507666412456789101112131415161718合计271820035000150001000001500000000005680200170406176760188462649354审核制表人员工工资明细表编制单位深圳市有限公司申报属期2019"年"4"月"如果知道实发工资需要反推应发工资和个税在尽量不改变原工资表格式和公式的前提下可以采取该 方法 快递客服问题件处理详细方法山木方法pdf计算方法pdf华与华方法下载八字理论方法下载 编号姓名本月工资合计专项扣除专项附加扣除本月应预缴所得额累计应预缴所得额累计应预缴税额累计已预缴税额本月实缴税额实发工资员工签名社保公积金子女教育住房租金房贷利息赡养老人继续教育个税反推方法之四次法以4月份工资表为例1王二小8900002000010000015000012000049000014700111003600866400361删除本月实缴税额O列和实发工资P列下面的公式2将本月实发工资复制粘贴到相应地方粘贴为数值2张三丰350000-150000-150000000900000035000003李大锤7890001500015000259000867000260101824077707512307774宋小宝669200169200507600152281015250766641245076567891011123删除本月工资合计C列值在C5处粘贴函数D5E5O5P54员工签名Q列设置公式在Q5处写粘贴函数IFM5N5M5-N50131415161718合计269820035000150001000001500000000000005593848492164462631754审核制表人5最重要步骤来了将Q列下面的值复制后粘贴到O列选择粘贴为数值这时发现O列和Q列不一致不用担心继续按上面的动作复制粘贴这时你会发现两列数据越来越接近6这时可以发现个税和应发工资已经成功反推出来一般来说复制粘贴4次后就可达到最终效果了所以在这里我称之为4次法如果万一发现4次不行可以继续复制粘贴大家试一下是不是觉得特别简单呢