2025年1月21日01税率表02员工资料表03考勤统计表04工资明细表工资核算系统06查询员工工资07银行发放表08工资条09工资凭证表05部门汇总10设计说明工资表日期2025年1月21日工资明细表工资凭证表05部门汇总10设计说明工资表日期个人所得税税率表序号应纳税工薪范围上限范围扣税百分率扣除数1-3%-21,500.0010%105.0034,500.0020%555.0049,000.0025%1,005.00535,000.0030%2,755.00655,000.0035%5,505.00780,000.0045%13,505.0089不超过1500元的超过1500元至4500元部分超过4500元至9000元部分超过9000元至35000元部分超过35000元至55000元部分超过55000元至80000元部分超过80000元部分个人所得税税率表起征额3,500.00员工基础资料表员工代码姓名部门卡号进厂时间基础工资16001卞悦涵办公室60138261080000012342003-02-193,300.0016002陈鸿博办公室60138261080000012351999-12-063,300.0016003陈泽宇办公室60138261080000012362003-11-271,900.0016004方艺瞳办公室60138261080000012372005-07-241,300.0016005何汶泽技术部60138261080000012382002-05-072,000.0016006黄潇雅技术部60138261080000012392003-02-053,300.0016007黄梓钰技术部60138261080000012402005-03-012,600.0016008吉言技术部60138261080000012412004-02-294,000.0016009蒋鹏博技术部60138261080000012422000-10-172,000.0016010李博文营销部60138261080000012432005-04-302,600.0016011李畅营销部60138261080000012442005-03-104,000.0016012李方宇营销部60138261080000012452000-06-082,000.0016013李如好营销部60138261080000012462003-02-261,300.0016014李祥瑞营销部60138261080000012472002-04-193,300.0016015李宣蓉人力资源部60138261080000012482003-10-114,000.0016016李宇泽人力资源部60138261080000012492003-02-122,000.0016017李梓睿人力资源部60138261080000012501999-12-311,300.0016018林圣智人力资源部60138261080000012522001-10-173,300.0016019林芯羽人力资源部60138261080000012532004-08-162,600.00员工基础资料表绩效工资工龄工资2,500.001,050.002,900.001,250.001,500.001,050.003,300.00950.003,200.001,100.003,200.001,050.002,700.00950.003,500.001,000.002,800.001,200.002,800.00950.003,600.00950.002,900.001,200.002,900.001,050.002,400.001,100.003,000.001,050.002,800.001,050.003,500.001,250.003,100.001,150.002,500.001,000.00考勤统计表员工代码姓名部门通讯补助16001卞悦涵办公室24240.9150.0016002陈鸿博办公室2424116003陈泽宇办公室241230.9516004方艺瞳办公室24240.85216005何汶泽技术部24240.88150.0016006黄潇雅技术部245190.98116007黄梓钰技术部24240.9216008吉言技术部24240.97216009蒋鹏博技术部243210.9916010李博文营销部24241200.0016011李畅营销部24123116012李方宇营销部24240.9216013李如好营销部24240.9216014李祥瑞营销部242220.9516015李宣蓉人力资源部24240.85150.0016016李宇泽人力资源部241230.88116017李梓睿人力资源部24240.9816018林圣智人力资源部24240.92250.0016019林芯羽人力资源部246180.97应出勤天数缺勤天数实出勤天数绩效考核系数日常加班天数节日加班天数考勤统计表住宿费养老保险945.00200.001,125.00945.00855.00990.00945.00150.00855.00900.001,080.00855.00855.001,080.00945.00200.00990.00945.00945.00200.001,125.001,035.00900.00工资明细表员工代码部门姓名基础工资绩效工资工龄工资通讯补助应发合计日工资工资合计个人所得税住宿费代扣养老保险实发合计签名16001办公室卞悦涵3,300.002,250.001,050.00150.006,750.00281.00--6,750.00220.00945.005,585.00###16002办公室陈鸿博3,300.002,900.001,250.00-7,450.00310.00--7,450.00290.00200.001,125.005,835.00###16003办公室陈泽宇1,821.001,425.001,050.00-4,296.00179.00--4,296.0023.88945.003,327.12###16004办公室方艺瞳1,300.002,805.00950.00-5,055.00211.00844.00-5,899.00134.90855.004,909.10###16005技术部何汶泽2,000.002,816.001,100.00150.006,066.00253.00-...
