工资表(Excel格式,内含多页)

1、Cji返回目录银行工资 卡号编号养失医房姓名基本工资岗位 工资交通补贴公务补贴电话补贴12345678001111111一平¥ 158,100.001,900.00100.0050.00150.00135790020021 111彩云¥ 113,850.001,850.00123456790031 111知静¥ 80,800.001,600.000041111末莉¥ 58,400.00800.00876543210051111凌空¥ 22,400.00800.0000611成龙¥ 6,400.00800.002468000100711

2、11雄雁¥ 2,800.001,500.000081111丽骏¥ 1,200.001,500.00009朝晖¥ 100,000.001,500.00010011012013014015016017018某部门小计¥ 543,950.00¥ 12,250.00¥ 100.00¥ 50.00¥ 150.00019020021022023024025026027028029030031032033034035036某部门小计037038039040041042043044045某部门小计合计¥ 543,950.

3、00¥ 12,250.00某术有限公司2007年3月份工资明细表车补午餐补贴司龄补加班加班天数工资奖金缺勤 天数考勤应扣其它应扣工资总额80.00150.0080.002.015238.1020.0017,619.055.00168,244.05115,700.0082,400.0059,200.0023,200.007,200.004,300.002,700.00101,500.003¥ 80.00¥ 150.00¥ 80.00¥ 2.00#¥ 20.00¥ 4.00¥ 7,619.05¥5.00564

4、,444.052#¥ 20.004¥ 7,619.05¥5.00¥ 564,444.05明细表养老保险失 业医 疗保险保险住房公积金其它代扣个人代扣所得税实发工资¥ 13,459.52¥ 1,682.44¥ 3,364.88¥ 33,648.81¥ 36,144.78¥ 79,943.62¥ 9,256.00¥ 1,157.00¥ 2,314.00¥ 23,140.00¥ 21,006.55¥ 58,826.45¥ 6,592

5、.00¥ 824.00¥ 1,648.00¥ 16,480.00¥ 13,201.80¥ 43,654.20¥ 4,736.00¥ 592.00¥ 1,184.00¥ 11,840.00¥ 8,437.00¥ 32,411.00¥ 1,856.00¥ 232.00¥ 464.00¥ 4,640.00¥ 2,506.60¥ 13,501.40¥ 576.00¥ 144.00¥ 607.00¥

6、; 5,873.00¥ 344.00¥ 43.00¥ 86.00¥ 860.00¥ 111.70¥ 2,855.30¥ 216.00¥ 27.00¥ 54.00¥ 540.00¥ 13.15¥ 1,849.85¥ 29,585.00¥ 71,915.00¥ 37,035.52¥ 4,557.44¥ 9,258.88¥ 91,148.81¥ 111,613.58¥ 310,829.82¥

7、37,035.52¥ 4,557.44¥ 9,258.88¥ 91,148.81¥ 111,613.58¥ 310,829.8212007年3月份银行工资卡号签字部门身份证号姓名纳税人 收入额管理部123456789123456789一平¥ 168,244.05管理部123456789123456790彩云¥ 115,700.00管理部123456789123456791知静¥ 82,400.00管理部123456789123456792末莉¥ 59,200.00管理部123456789123456793

8、凌空¥ 23,200.00管理部123456789123456794成龙¥ 7,200.00开发部123456789123456795雄雁¥ 4,300.00开发部123456789123456796丽骏¥ 2,700.00开发部123456789123456797朝晖¥ 101,500.00应税所得额税率(%)本次实缴税额5%10%15%20%¥ 114,488.390.45¥ 36,144.78¥ 78,233.000.35¥ 21,006.55¥ 55,256.000.30¥ 1

9、3,201.80¥ 39,248.000.25¥ 8,437.00¥ 14,408.000.20¥ 2,506.60¥ 2,506.60¥ 4,880.000.15¥ 607.00¥ 607.00¥ 1,367.000.10¥ 111.70¥ 111.70¥ 263.000.05¥ 13.15¥ 13.15¥ 99,900.000.40¥ 29,585.00¥ 408,043.39¥ 111,613.58¥

10、 13.15¥ 111.70¥ 607.00¥ 2,506.602007年3月份个人所得税申报资料税率：分级纳税额合计： 分级纳税人数：分级纳税所得额：所得税纳税总额：税与工资表核对：5%10%15%¥ 13.15¥ 111.70¥ 607.00111263.001,367.004,880.00¥ 2,506.60114,408.00111,613.58完全正确20%不扣税基数160025%30%35%40%45%级数¥ 36,144.781¥ 21,006.552¥ 13,201.803

11、65; 8,437.0045678¥ 29,585.009¥ 8,437.00¥ 13,201.80¥ 21,006.55¥ 29,585.00¥ 36,144.7825%30%35%40%45%¥ 8,437.00¥ 13,201.80¥ 21,006.55¥ 29,585.00¥ 36,144.781111139,248.0055,256.0078,233.0099,900.00114,488.39应纳税工薪收入上一范围上限税率扣除数上一范围上限不超过500元的¥ 0.0

12、5¥ 100,000.00超过500元至2000元部份¥ 500.00¥ 0.10¥ 25.00¥ 60,000.00超过2000元至5000元部份¥ 2,000.00¥ 0.15¥ 125.00¥ 40,000.00超过5000元至20000元部份¥ 5,000.00¥ 0.20¥ 375.00¥ 20,000.00超过20000元至40000元部份¥ 20,000.00¥ 0.25¥ 1,375.00¥ 5,000.00超过40000元至60000元部份¥ 40,000.00¥ 0.30¥ 3,375.00¥ 2,000.00超过60000元至80