表格模板-税前税后工资VS年终奖计算表灵活简单XLS5页 精品.xlsx

《表格模板-税前税后工资VS年终奖计算表灵活简单XLS5页 精品.xlsx》由会员分享，可在线阅读，更多相关《表格模板-税前税后工资VS年终奖计算表灵活简单XLS5页 精品.xlsx（26页珍藏版）》请在第一文库网上搜索。

1、税税前前个个税税计计算算模模版版序号员工级别税前工资个税税前月薪扣除标准个税税后月薪校对1普通员工4000.003874.003.783996.22-2普通员工大专4500.003948.0016.564483.44-3普通员工大专5000.003948.0031.564968.44-4普通员工大专5500.003948.0050.205449.80-5主任级6000.004021.0092.905907.10-6主任级6500.004021.00142.906357.10-7主任级7000.004021.00192.906807.10-8经理级7500.004095.00235.507264

2、.50-9经理级8000.004095.00285.507714.50-10经理级8500.004095.00335.508164.50-11经理级9000.004095.00426.008574.00-12经理级9500.004095.00526.008974.00-13经理级10000.004095.00626.009374.00-14经理级10500.004095.00726.009774.00-15经理级11000.004095.00826.0010174.00-16经理级11500.004095.00926.0010574.00-17经理级12000.004095.001026.00

3、10974.00-18经理级12500.004095.001126.0011374.00-19经理级13000.004095.001226.0011774.00-20经理级13500.004095.001346.2512153.75-21经理级14000.004095.001471.2512528.75-22经理级14500.004095.001596.2512903.75-23经理级15000.004095.001721.2513278.75-24经理级15500.004095.001846.2513653.75-25经理级20000.004095.002971.2517028.75-26副

4、总助理级以上 16500.004168.002078.0014422.00-27副总助理级以上 17000.004168.002203.0014797.00-28副总助理级以上 17500.004168.002328.0015172.00-29副总助理级以上 18000.004168.002453.0015547.00-30副总助理级以上 18500.004168.002578.0015922.00-31副总助理级以上 19000.004168.002703.0016297.00-32副总助理级以上 19500.004168.002828.0016672.00-33副总助理级以上 20000.

5、004168.002953.0017047.00-34副总助理级以上 20500.004168.003078.0017422.00-35副总助理级以上 21000.004168.003203.0017797.00-36副总助理级以上 21500.004168.003328.0018172.00-37副总助理级以上 22000.004168.003453.0018547.00-38副总助理级以上 22500.004168.003578.0018922.00-39副总助理级以上 23000.004168.003703.0019297.00-40副总助理级以上 23500.004168.003828

6、.0019672.00-41副总助理级以上 25000.004168.004203.0020797.00-42副总助理级以上 30000.004168.005453.0024547.00-43副总助理级以上 35000.004168.006703.0028297.00-44副总助理级以上 40000.004168.007994.6032005.40-45副总助理级以上 45000.004168.009494.6035505.40-46副总助理级以上 50000.004168.0010994.6039005.40-47副总助理级以上 55000.004168.0012494.6042505.40

7、-48副总助理级以上 60000.004168.0014036.2045963.80-49副总助理级以上 70000.004168.0017536.2052463.80-50副总助理级以上 80000.004168.0021036.2058963.80-员工级别每月个人社保每月个人公积金免税额扣除合计普通员工194.00180.003500.003874.001794普通员工大专232.00216.003500.003948.002152.8主任级269.00252.003500.004021.002511.6经理级307.00288.003500.004095.002870.4副总助理级以上

8、345.00323.003500.004168.003229.2社保公积金193.37179.4231.044215.28268.718251.16306.392287.04344.066322.92税后收入换算税前收入计算表员工级别税后月薪应税所得税率速算扣除数费用扣除标准税前应税所得普通员工4,0001263%-3,874129.90普通员工大专4,5005523%-3,948569.07普通员工大专5,0001,0523%-3,9481,084.54主任级5,5001,47910%1054,0211,526.67主任级6,0001,97910%1054,0212,082.22主任级6,5

9、002,47910%1054,0212,637.78主任级7,0002,97910%1054,0213,193.33经理级7,5003,40510%1054,0953,666.67经理级8,0003,90510%1054,0954,222.22经理级8,5004,40520%5554,0954,812.50经理级9,0004,90520%5554,0955,437.50经理级9,5005,40520%5554,0956,062.50经理级10,0005,90520%5554,0956,687.50经理级10,5006,40520%5554,0957,312.50经理级11,0006,90520

10、%5554,0957,937.50经理级11,5007,40520%5554,0958,562.50经理级12,0007,90525%1,0054,0959,200.00经理级12,5008,40525%1,0054,0959,866.67经理级13,0008,90525%1,0054,09510,533.33经理级13,5009,40525%1,0054,09511,200.00经理级14,0009,90525%1,0054,09511,866.67经理级14,50010,40525%1,0054,09512,533.33经理级15,00010,90525%1,0054,09513,200.

11、00副总助理级以上15,50011,33225%1,0054,16813,769.33副总助理级以上16,00011,83225%1,0054,16814,436.00副总助理级以上16,50012,33225%1,0054,16815,102.67副总助理级以上17,00012,83225%1,0054,16815,769.33副总助理级以上17,50013,33225%1,0054,16816,436.00副总助理级以上18,00013,83225%1,0054,16817,102.67副总助理级以上18,50014,33225%1,0054,16817,769.33副总助理级以上19,0

12、0014,83225%1,0054,16818,436.00副总助理级以上19,50015,33225%1,0054,16819,102.67副总助理级以上20,00015,83225%1,0054,16819,769.33副总助理级以上20,50016,33225%1,0054,16820,436.00副总助理级以上21,00016,83225%1,0054,16821,102.67副总助理级以上21,50017,33225%1,0054,16821,769.33副总助理级以上22,00017,83225%1,0054,16822,436.00副总助理级以上22,50018,33225%1,

13、0054,16823,102.67副总助理级以上23,00018,83225%1,0054,16823,769.33副总助理级以上23,50019,33225%1,0054,16824,436.00副总助理级以上25,00020,83225%1,0054,16826,436.00副总助理级以上30,00025,83225%1,0054,16833,102.67副总助理级以上35,00030,83230%2,7554,16840,110.00副总助理级以上40,00035,83230%2,7554,16847,252.86副总助理级以上46,70042,53235%5,5054,16856,96

14、4.62副总助理级以上50,00045,83235%5,5054,16862,041.54副总助理级以上55,00050,83235%5,5054,16869,733.85副总助理级以上60,00055,83235%5,5054,16877,426.15副总助理级以上70,00065,83245%13,5054,16895,140.00副总助理级以上80,00075,83245%13,5054,168113,321.82年年度度一一次次性性税税后后收收入入换换算算表表年度一次性收入年度区间应税所得税率速算扣除数 费用扣除标准5000417416.673%-10000833833.333%-11

15、000917916.673%-1200010001000.003%-1300010831083.333%-1400011671166.673%-1500012501250.003%-1600013331333.333%-1700014171416.673%-1800015001500.0010%1051900015831583.3310%1052000016671666.6710%1052500020832083.3310%1053000025002500.0010%1053500029172916.6710%1054000033333333.3310%1054500037503750.001

16、0%1055000041674166.6720%5556000050005000.0020%5557000058335833.3320%5558000066676666.6720%5559000075007500.0025%1,00510000083338333.3325%1,0051500001250012500.0025%1,0052000001666716666.6725%1,0052500002083320833.3325%1,0053000002500025000.0025%1,0053500002916729166.6730%2,7554000003333333333.3330%2,7554500003750037500.0030%2,7555000004166741666.6735%5,5055500004583345833.3335%5,5056000005000050000.0035%5,5056500005416754166.6745%13,5057000005833358333.3345%13,5057500006250062500.0045%13,5058000