工资管理系统表

,一月份工资明细表1.0不扣税基数,工号姓 名基本工资岗位工资交通补贴公务补贴电话补贴车补午餐补贴工龄补加班天数加班工资计件工资缺勤天数考勤应扣其它应扣工 资 总 额养老保险失业保险医疗保险住房公积金(大病统筹)其它代扣代扣个人所得税备1备2实 发 工 资备1备2银行工资卡号签 字部 门身 份 证 号姓 名纳 税 人 收 入 额应 税 所 得 额税率(%)本次实缴 税 额0.0310%0.225%30%35%45%应纳税额应税所得税率速算扣除数 税款,001方国民7200.07500.07205.0123456789123456789方国民7500.010.010.0105.0,002李志刚4800.04761.0123456789123456790李志刚4800.01300.01300.0,003于雄飞4200.04470.0123456789123456791于雄飞1000.01000.0,004来广明3650.03645.5123456789123456792来广明3650.0,005苗凤英2800.02950.02788.55123456789123456793,006彭力3750.03742.5123456789123456794彭力3750.0250.0250.0,007范琳琳3800.03779.8935123456789123456795范琳琳288.558.66288.55,008字文莉3900.04033.5字文莉550.0550.0,009黄海波3580.03680.03674.6黄海波3680.0180.0180.0,010张浩4082.0张浩,011曾春林4200.04300.04119.3935曾春林4300.0638.5519.16638.55,012李平4130.5李平,013彭洁3850.03936.5彭洁450.0450.0,014邢向荣3876.8935邢向荣388.5511.66388.55,015丁昊4082.0丁昊,016罗红军4130.5罗红军,017刘惠3597.0刘惠,018王莉莉3250.03350.03350.0,019许新3300.03400.03238.55,020李成龙3450.03550.03548.5李成龙3550.050.050.0,合 计78680.02850.081530.0504.063.0240.25530.369580192.380571830.011845.65530.37235.37530.3811845.65105.0530.37,二月份工资明细表1.0不扣税基数,工号姓 名基本工资岗位工资交通补贴公务补贴电话补贴车补午餐补贴工龄补加班天数加班工资计件工资缺勤天数考勤应扣其它应扣工 资 总 额养老保险失业保险医疗保险住房公积金(大病统筹)其它代扣代扣个人所得税备1备2实 发 工 资备1备2银行工资卡号签 字部 门身 份 证 号姓 名纳 税 人 收 入 额应 税 所 得 额税率(%)本次实缴 税 额0.0310%0.225%30%35%45%应纳税额应税所得税率速算扣除数 税款,001方国民7500.07800.07475.0123456789123456789方国民7800.010.010.0105.0,002李志刚4800.04761.0123456789123456790李志刚4800.01300.01300.0,003于雄飞4200.04470.0123456789123456791于雄飞1000.01000.0,004来广明3650.03645.5123456789123456792来广明3650.0,005苗凤英2800.02950.02788.55123456789123456793,006彭力3750.03742.5123456789123456794彭力3750.0250.0250.0,007范琳琳3800.03779.8935123456789123456795范琳琳288.558.66288.55,008字文莉3900.04033.5字文莉550.0550.0,009黄海波3580.03680.03674.6黄海波3680.0180.0180.0,010张浩4000.04082.0张浩,011曾春林4200.04119.3935曾春林638.5519.16638.55,012李平4130.5李平,013彭洁3850.03936.5彭洁450.0450.0,014邢向荣3876.8935邢向荣388.5511.66388.55,015丁昊4000.04082.0丁昊,016罗红军4130.5罗红军,017刘惠3597.0刘惠,018王莉莉3250.03350.03350.0,019许新3300.03400.03238.55,020李成龙3450.03550.03548.5李成龙3550.050.050.0,合 计78980.02850.081830.0504.063.0240.25560.369580462.380572130.012145.65560.37235.37560.3812145.65105.0560.37,三月份工资明细表1.0不扣税基数,工号姓 名基本工资岗位工资交通补贴公务补贴电话补贴车补午餐补贴工龄补加班天数加班工资计件工资缺勤天数考勤应扣其它应扣工 资 总 额养老保险失业保险医疗保险住房公积金(大病统筹)其它代扣代扣个人所得税备1备2实 发 工 资备1备2银行工资卡号签 字部 门身 份 证 号姓 名纳 税 人 收 入 额应 税 所 得 额税率(%)本次实缴 税 额0.0310%0.225%30%35%45%应纳税额应税所得税率速算扣除数 税款,001方国民7500.07800.07475.0123456789123456789方国民7800.010.010.0105.0,002李志刚4800.04761.0123456789123456790李志刚4800.01300.01300.0,003于雄飞4200.04470.0123456789123456791于雄飞1000.01000.0,004来广明3650.03645.5123456789123456792来广明3650.0,005苗凤英2800.02950.02788.55123456789123456793,006彭力3750.03742.5123456789123456794彭力3750.0250.0250.0,007范琳琳3800.03779.8935123456789123456795范琳琳288.558.66288.55,008字文莉3900.04033.5字文莉550.0550.0,009黄海波3580.03680.03674.6黄海波3680.0180.0180.0,010张浩4000.04082.0张浩,011曾春林4200.04119.3935曾春林638.5519.16638.55,012李平4130.5李平,013彭洁3850.03936.5彭洁450.0450.0,014邢向荣3876.8935邢向荣388.5511.66388.55,015丁昊4000.04082.0丁昊,016罗红军4130.5罗红军,017刘惠3597.0刘惠,018王莉莉3250.03350.03350.0,019许新3300.03400.03238.55,020李成龙3450.03550.03548.5李成龙3550.050.050.0,合 计78980.02850.081830.0504.063.0240.25560.369580462.380572130.012145.65560.37235.37560.3812145.65105.0560.37,四月份工资明细表1.0不扣税基数,工号姓 名基本工资岗位工资交通补贴公务补贴电话补贴车补午餐补贴工龄补加班天数加班工资计件工资缺勤天数考勤应扣其它应扣工 资 总 额养老保险失业保险医疗保险住房公积金(大病统筹)其它代扣代扣个人所得税备1备2实 发 工 资备1备2银行工资卡号签 字部 门身 份 证 号姓 名纳 税 人 收 入 额应 税 所 得 额税率(%)本次实缴 税 额0.0310%0.225%30%35%45%应纳税额应税所得税率速算扣除数 税款,001方国民7500.07800.07475.0123456789123456789方国民7800.010.010.0105.0,002李志刚4800.04761.0123456789123456790李志刚4800.01300.01300.0,003于雄飞4200.04470.0123456789123456791于雄飞1000.01000.0,004来广明3650.03645.5123456789123456792来广明3650.0,005苗凤英2800.02950.02788.55123456789123456793,006彭力3750.03742.5123456789123456794彭力3750.0250.0250.0,007范琳琳3800.03779.8935123456789123456795范琳琳288.558.66288.55,008字文莉3900.04033.5字文莉550.0550.0,009黄海波3580.03680.03674.6黄海波3680.0180.0180.0,010张浩4000.04082.0张浩,011曾春林4200.04119.3935曾春林638.5519.16638.55,012李平4130.5李平,013彭洁3850.03936.5彭洁450.0450.0,014邢向荣3876.8935邢向荣388.5511.66388.55,015丁昊4000.04082.0丁昊,016罗红军4130.5罗红军,017刘惠3597.0刘惠,018王莉莉3250.03350.03350.0,019许新3300.03400.03238.55,020李成龙3450.03550.03548.5李成龙3550.050.050.0,合 计78980.02850.081830.0504.063.0240.25560.369580462.380572130.012145.65560.37235.37560.3812145.65105.0560.37,五月份工资明细表1.0不扣税基数,工号姓 名基本工资岗位工资交通补贴公务补贴电话补贴车补午餐补贴工龄补加班天数加班工资计件工资缺勤天数考勤应扣其它应扣工 资 总 额养老保险失业保险医疗保险住房公积金(大病统筹)其它代扣代扣个人所得税备1备2实 发 工 资备1备2银行工资卡号签 字部 门身 份 证 号姓 名纳 税 人 收 入 额应 税 所 得 额税率(%)本次实缴 税 额0.0310%0.225%30%35%45%应纳税额应税所得税率速算扣除数 税款,001方国民7500.07800.07475.0123456789123456789方国民7800.010.010.0105.0,002李志刚4800.04761.0123456789123456790李志刚4800.01300.01300.0,003于雄飞4200.04470.0123456789123456791于雄飞1000.01000.0,004来广明3650.03645.5123456789123456792来广明3650.0,005苗凤英2800.02950.02788.55123456789123456793,006彭力3750.03742.5123456789123456794彭力3750.0250.0250.0,007范琳琳3800.03779.8935123456789123456795范琳琳288.558.66288.55,008字文莉3900.04033.5字文莉550.0550.0,009黄海波3580.03680.03674.6黄海波3680.0180.0180.0,010张浩4000.04082.0张浩,011曾春林4200.04119.3935曾春林638.5519.16638.55,012李平4130.5李平,013彭洁3850.03936.5彭洁450.0450.0,014邢向荣3876.8935邢向荣388.5511.66388.55,015丁昊4000.04082.0丁昊,016罗红军4130.5罗红军,017刘惠3597.0刘惠,018王莉莉3250.03350.03350.0,019许新3300.03400.03238.55,020李成龙3450.03550.03548.5李成龙3550.050.050.0,合 计78980.02850.081830.0504.063.0240.25560.369580462.380572130.012145.65560.37235.37560.3812145.65105.0560.37,六月份工资明细表1.0不扣税基数,工号姓 名基本工资岗位工资交通补贴公务补贴电话补贴车补午餐补贴工龄补加班天数加班工资计件工资缺勤天数考勤应扣其它应扣工 资 总 额养老保险失业保险医疗保险住房公积金(大病统筹)其它代扣代扣个人所得税备1备2实 发 工 资备1备2银行工资卡号签 字部 门身 份 证 号姓 名纳 税 人 收 入 额应 税 所 得 额税率(%)本次实缴 税 额0.0310%0.225%30%35%45%应纳税额应税所得税率速算扣除数 税款,001方国民7500.07800.07475.0123456789123456789方国民7800.010.010.0105.0,002李志刚4800.04761.0123456789123456790李志刚4800.01300.01300.0,003于雄飞4200.04470.0123456789123456791于雄飞1000.01000.0,004来广明3650.03645.5123456789123456792来广明3650.0,005苗凤英2800.02950.02788.55123456789123456793,006彭力3750.03742.5123456789123456794彭力3750.0250.0250.0,007范琳琳3800.03779.8935123456789123456795范琳琳288.558.66288.55,008字文莉3900.04033.5字文莉550.0550.0,009黄海波3580.03680.03674.6黄海波3680.0180.0180.0,010张浩4000.04082.0张浩,011曾春林4200.04119.3935曾春林638.5519.16638.55,012李平4130.5李平,013彭洁3850.03936.5彭洁450.0450.0,014邢向荣3876.8935邢向荣388.5511.66388.55,015丁昊4000.04082.0丁昊,016罗红军4130.5罗红军,017刘惠3597.0刘惠,018王莉莉3250.03350.03350.0,019许新3300.03400.03238.55,020李成龙3450.03550.03548.5李成龙3550.050.050.0,合 计78980.02850.081830.0504.063.0240.25560.369580462.380572130.012145.65560.37235.37560.3812145.65105.0560.37,七月份工资明细表1.0不扣税基数,工号姓 名基本工资岗位工资交通补贴公务补贴电话补贴车补午餐补贴工龄补加班天数加班工资计件工资缺勤天数考勤应扣其它应扣工 资 总 额养老保险失业保险医疗保险住房公积金(大病统筹)其它代扣代扣个人所得税备1备2实 发 工 资备1备2银行工资卡号签 字部 门身 份 证 号姓 名纳 税 人 收 入 额应 税 所 得 额税率(%)本次实缴 税 额0.0310%0.225%30%35%45%应纳税额应税所得税率速算扣除数 税款,001方国民7500.07800.07475.0123456789123456789方国民7800.010.010.0105.0,002李志刚4800.04761.0123456789123456790李志刚4800.01300.01300.0,003于雄飞4200.04470.0123456789123456791于雄飞1000.01000.0,004来广明3650.03645.5123456789123456792来广明3650.0,005苗凤英2800.02950.02788.55123456789123456793,006彭力3750.03742.5123456789123456794彭力3750.0250.0250.0,007范琳琳3800.03779.8935123456789123456795范琳琳288.558.66288.55,008字文莉3900.04033.5字文莉550.0550.0,009黄海波3580.03680.03674.6黄海波3680.0180.0180.0,010张浩4000.04082.0张浩,011曾春林4200.04119.3935曾春林638.5519.16638.55,012李平4130.5李平,013彭洁3850.03936.5彭洁450.0450.0,014邢向荣3876.8935邢向荣388.5511.66388.55,015丁昊4000.04082.0丁昊,016罗红军4130.5罗红军,017刘惠3597.0刘惠,018王莉莉3250.03350.03350.0,019许新3300.03400.03238.55,020李成龙3450.03550.03548.5李成龙3550.050.050.0,合 计78980.02850.081830.0504.063.0240.25560.369580462.380572130.012145.65560.37235.37560.3812145.65105.0560.37,八月份工资明细表1.0不扣税基数,工号姓 名基本工资岗位工资交通补贴公务补贴电话补贴车补午餐补贴工龄补加班天数加班工资计件工资缺勤天数考勤应扣其它应扣工 资 总 额养老保险失业保险医疗保险住房公积金(大病统筹)其它代扣代扣个人所得税备1备2实 发 工 资备1备2银行工资卡号签 字部 门身 份 证 号姓 名纳 税 人 收 入 额应 税 所 得 额税率(%)本次实缴 税 额0.0310%0.225%30%35%45%应纳税额应税所得税率速算扣除数 税款,001方国民7500.07800.07475.0123456789123456789方国民7800.010.010.0105.0,002李志刚4800.04761.0123456789123456790李志刚4800.01300.01300.0,003于雄飞4200.04470.0123456789123456791于雄飞1000.01000.0,004来广明3650.03645.5123456789123456792来广明3650.0,005苗凤英2800.02950.02788.55123456789123456793,006彭力3750.03742.5123456789123456794彭力3750.0250.0250.0,007范琳琳3800.03779.8935123456789123456795范琳琳288.558.66288.55,008字文莉3900.04033.5字文莉550.0550.0,009黄海波3580.03680.03674.6黄海波3680.0180.0180.0,010张浩4000.04082.0张浩,011曾春林4200.04119.3935曾春林638.5519.16638.55,012李平4130.5李平,013彭洁3850.03936.5彭洁450.0450.0,014邢向荣3876.8935邢向荣388.5511.66388.55,015丁昊4000.04082.0丁昊,016罗红军4130.5罗红军,017刘惠3597.0刘惠,018王莉莉3250.03350.03350.0,019许新3300.03400.03238.55,020李成龙3450.03550.03548.5李成龙3550.050.050.0,合 计78980.02850.081830.0504.063.0240.25560.369580462.380572130.012145.65560.37235.37560.3812145.65105.0560.37,九月份工资明细表1.0不扣税基数,工号姓 名基本工资岗位工资交通补贴公务补贴电话补贴车补午餐补贴工龄补加班天数加班工资计件工资缺勤天数考勤应扣其它应扣工 资 总 额养老保险失业保险医疗保险住房公积金(大病统筹)其它代扣代扣个人所得税备1备2实 发 工 资备1备2银行工资卡号签 字部 门身 份 证 号姓 名纳 税 人 收 入 额应 税 所 得 额税率(%)本次实缴 税 额0.0310%0.225%30%35%45%应纳税额应税所得税率速算扣除数 税款,001方国民7500.07800.07475.0123456789123456789方国民7800.010.010.0105.0,002李志刚4800.04761.0123456789123456790李志刚4800.01300.01300.0,003于雄飞4200.04470.0123456789123456791于雄飞1000.01000.0,004来广明3650.03645.5123456789123456792来广明3650.0,005苗凤英2800.02950.02788.55123456789123456793,006彭力3750.03742.5123456789123456794彭力3750.0250.0250.0,007范琳琳3800.03779.8935123456789123456795范琳琳288.558.66288.55,008字文莉3900.04033.5字文莉550.0550.0,009黄海波3580.03680.03674.6黄海波3680.0180.0180.0,010张浩4000.04082.0张浩,011曾春林4200.04119.3935曾春林638.5519.16638.55,012李平4130.5李平,013彭洁3850.03936.5彭洁450.0450.0,014邢向荣3876.8935邢向荣388.5511.66388.55,015丁昊4000.04082.0丁昊,016罗红军4130.5罗红军,017刘惠3597.0刘惠,018王莉莉3250.03350.03350.0,019许新3300.03400.03238.55,020李成龙3450.03550.03548.5李成龙3550.050.050.0,合 计78980.02850.081830.0504.063.0240.25560.369580462.380572130.012145.65560.37235.37560.3812145.65105.0560.37,十月份工资明细表1.0不扣税基数,工号姓 名基本工资岗位工资交通补贴公务补贴电话补贴车补午餐补贴工龄补加班天数加班工资计件工资缺勤天数考勤应扣其它应扣工 资 总 额养老保险失业保险医疗保险住房公积金(大病统筹)其它代扣代扣个人所得税备1备2实 发 工 资备1备2银行工资卡号签 字部 门身 份 证 号姓 名纳 税 人 收 入 额应 税 所 得 额税率(%)本次实缴 税 额0.0310%0.225%30%35%45%应纳税额应税所得税率速算扣除数 税款,001方国民7500.07800.07475.0123456789123456789方国民7800.010.010.0105.0,002李志刚4800.04761.0123456789123456790李志刚4800.01300.01300.0,003于雄飞4200.04470.0123456789123456791于雄飞1000.01000.0,004来广明3650.03645.5123456789123456792来广明3650.0,005苗凤英2800.02950.02788.55123456789123456793,006彭力3750.03742.5123456789123456794彭力3750.0250.0250.0,007范琳琳3800.03779.8935123456789123456795范琳琳288.558.66288.55,008字文莉3900.04033.5字文莉550.0550.0,009黄海波3580.03680.03674.6黄海波3680.0180.0180.0,010张浩4000.04082.0张浩,011曾春林4200.04119.3935曾春林638.5519.16638.55,012李平4130.5李平,013彭洁3850.03936.5彭洁450.0450.0,014邢向荣3876.8935邢向荣388.5511.66388.55,015丁昊4000.04082.0丁昊,016罗红军4130.5罗红军,017刘惠3597.0刘惠,018王莉莉3250.03350.03350.0,019许新3300.03400.03238.55,020李成龙3450.03550.03548.5李成龙3550.050.050.0,合 计78980.02850.081830.0504.063.0240.25560.369580462.380572130.012145.65560.37235.37560.3812145.65105.0560.37,十一月份工资明细表1.0不扣税基数,工号姓 名基本工资岗位工资交通补贴公务补贴电话补贴车补午餐补贴工龄补加班天数加班工资计件工资缺勤天数考勤应扣其它应扣工 资 总 额养老保险失业保险医疗保险住房公积金(大病统筹)其它代扣代扣个人所得税备1备2实 发 工 资备1备2银行工资卡号签 字部 门身 份 证 号姓 名纳 税 人 收 入 额应 税 所 得 额税率(%)本次实缴 税 额0.0310%0.225%30%35%45%应纳税额应税所得税率速算扣除数 税款,001方国民7500.07800.07475.0123456789123456789方国民7800.010.010.0105.0,002李志刚4800.04761.0123456789123456790李志刚4800.01300.01300.0,003于雄飞4200.04470.0123456789123456791于雄飞1000.01000.0,004来广明3650.03645.5123456789123456792来广明3650.0,005苗凤英2800.02950.02788.55123456789123456793,006彭力3750.03742.5123456789123456794彭力3750.0250.0250.0,007范琳琳3800.03779.8935123456789123456795范琳琳288.558.66288.55,008字文莉3900.04033.5字文莉550.0550.0,009黄海波3580.03680.03674.6黄海波3680.0180.0180.0,010张浩4000.04082.0张浩,011曾春林4200.04119.3935曾春林638.5519.16638.55,012李平4130.5李平,013彭洁3850.03936.5彭洁450.0450.0,014邢向荣3876.8935邢向荣388.5511.66388.55,015丁昊4000.04082.0丁昊,016罗红军4130.5罗红军,017刘惠3597.0刘惠,018王莉莉3250.03350.03350.0,019许新3300.03400.03238.55,020李成龙3450.03550.03548.5李成龙3550.050.050.0,合 计78980.02850.081830.0504.063.0240.25560.369580462.380572130.012145.65560.37235.37560.3812145.65105.0560.37,十二月份工资明细表1.0不扣税基数,工号姓 名基本工资岗位工资交通补贴公务补贴电话补贴车补午餐补贴工龄补加班天数加班工资计件工资缺勤天数考勤应扣其它应扣工 资 总 额养老保险失业保险医疗保险住房公积金(大病统筹)其它代扣代扣个人所得税备1备2实 发 工 资备1备2银行工资卡号签 字部 门身 份 证 号姓 名纳 税 人 收 入 额应 税 所 得 额税率(%)本次实缴 税 额0.0310%0.225%30%35%45%应纳税额应税所得税率速算扣除数 税款,001方国民7500.07800.07475.0123456789123456789方国民7800.010.010.0105.0,002李志刚4800.04761.0123456789123456790李志刚4800.01300.01300.0,003于雄飞4200.04470.0123456789123456791于雄飞1000.01000.0,004来广明3650.03645.5123456789123456792来广明3650.0,005苗凤英2800.02950.02788.55123456789123456793,006彭力3750.03742.5123456789123456794彭力3750.0250.0250.0,007范琳琳3800.03779.8935123456789123456795范琳琳288.558.66288.55,008字文莉3900.04033.5字文莉550.0550.0,009黄海波3580.03680.03674.6黄海波3680.0180.0180.0,010张浩4000.04082.0张浩,011曾春林4200.04119.3935曾春林638.5519.16638.55,012李平4130.5李平,013彭洁3850.03936.5彭洁450.0450.0,014邢向荣3876.8935邢向荣388.5511.66388.55,015丁昊4000.04082.0丁昊,016罗红军4130.5罗红军,017刘惠3597.0刘惠,018王莉莉3250.03350.03350.0,019许新3300.03400.03238.55,020李成龙3450.03550.03548.5李成龙3550.050.050.0,合 计78980.02850.081830.0504.063.0240.25560.369580462.380572130.012145.65560.37235.37560.3812145.65105.0560.37,工号姓 名方国民 薪酬收入明细,001方国民,月份基本工资岗位工资交通补贴公务补贴电话补贴车补午餐补贴工龄补加班天数加班工资计件工资缺勤天数考勤应扣其它应扣工 资 总 额养老保险失业保险医疗保险住房公积金(大病统筹)其它代扣代扣个人所得税备1备2实 发 工 资,1月7200.0295.07205.0,2月,3月,4月,5月,6月,7月,8月,9月,10月,11月,12月,合计:89700.03600.093300.03870.089430.0,财务部 薪酬收入汇总办公室,部门:财务部人事部,月份基本工资岗位工资交通补贴公务补贴电话补贴车补午餐补贴工龄补加班天数加班工资计件工资缺勤天数考勤应扣其它应扣工 资 总 额养老保险失业保险医疗保险住房公积金(大病统筹)其它代扣代扣个人所得税备1备2实 发 工 资销售部,1月财务部,2月研发部,3月,4月,5月,6月,7月,8月,9月,10月,11月,12月,合计:183000.05400.0188400.02419.2302.41153.2495.756184029.444,全 年 员 工 薪 酬 发 放 汇 总 表,工号姓 名基本工资岗位工资交通补贴公务补贴电话补贴车补午餐补贴工龄补加班天数加班工资计件工资缺勤天数考勤应扣其它应扣工 资 总 额养老保险失业保险医疗保险住房公积金其它代扣代扣个人所得税备1备2实 发 工 资,001方国民89700.093300.03870.089430.0,002李志刚54000.057600.0468.057132.0,003于雄飞50400.054000.0360.053640.0,004来广明42000.043800.054.043746.0,005苗凤英33600.035400.033462.6,006彭力43200.045000.090.044910.0,007范琳琳45600.0103.87845358.722,008字文莉46800.0198.048402.0,009黄海波42960.044160.064.844095.2,010张浩48000.049200.0216.048984.0,011曾春林50400.051600.0229.87849432.722,012李平49800.0234.049566.0,013彭洁46200.0162.047238.0,014邢向荣139.87846522.722,015丁昊48000.049200.0216.048984.0,016罗红军49800.0234.049566.0,017刘惠42000.043200.036.043164.0,018王莉莉39000.040200.040200.0,019许新39600.040800.038862.6,020李成龙41400.042600.018.042582.0,合 计947460.034200.0981660.06048.0756.02883.06694.434965278.566,2月,方国民001,7500.0,001,7800.0325.0, 以上计算无误，收到现金7475 元。7475.0,李志刚002,4500.0,002,4800.039.0, 以上计算无误，收到现金4761 元。4761.0,于雄飞003,4200.0,003,4500.030.0, 以上计算无误，收到现金4470 元。4470.0,来广明004,3500.0,150.0004,3650.04.5, 以上计算无误，收到现金3645.5 元。3645.5,2月,001方国民7500.07800.0325.07475.0,002李志刚4500.04800.039.04761.0,003于雄飞4200.04500.030.04470.0,004来广明3500.03650.04.53645.5,005苗凤英2800.02950.02788.55,006彭力3600.03750.07.53742.5,007范琳琳3800.08.65653779.8935,008字文莉3900.016.54033.5,009黄海波3580.03680.05.43674.6,010张浩4000.04100.018.04082.0,011曾春林4200.04300.019.15654119.3935,012李平4150.019.54130.5,013彭洁3850.013.53936.5,014邢向荣11.65653876.8935,015丁昊4000.04100.018.04082.0,016罗红军4150.019.54130.5,017刘惠3500.03600.03.03597.0,018王莉莉3250.03350.03350.0,019许新3300.03400.03238.55,020李成龙3450.03550.01.53548.5,使用说明：,1、各月工资表，已用公式设置完毕，本表自动显示数据,您再按实际情况稍加修正,工资表就完成了!,2、使用时,请把一月份工资表中公式的数据,按你的实际情况修改,之后把一月份工资表复制到2至12月就行了。以后再用时,参阅第一条说明。3、养老保险、失业保险、医疗保险、住房公积金 自动生成，但各单位的比例不同，请自行修改公式中的参数。4、AF 列至AZ 列是报税资料，自动生成。5、“四联工资单”只须输入员工编号与选择月份，便可自动,6、“工资条”选择月份后，全部自动生成；若行数不够可选中1-3行复制再黏贴。7、加班工资、考勤应扣，按每月30天计算；养、失、医、房项目提取基数与比例亦应按单位规定进行修改。8、打印工资表时，可将不需用的列隐藏，避免页面橫向过长。9、《个人分月汇总》只在 A2 单元格选择编号,即自动生成该员工全年工资情况。10、《部门分月汇总》只在 B2 单元格选择编号,即自动生成该部门全年工资情况。11、年内离职人员，其编号与姓名不得删除或更换他人,否则《四联工资单》将会出错；《全员年度汇总》也会出错。12、年内新增人员，请在当月及以后月份工资表中同一位置添加。