累计预扣预缴新个税全年工资表

使用说明,在1-12月份表中对应A-G栏录入数据，H-N栏自动统计,行数不够，可直接复制带公式行填充,111.0,,1月工资表,工号姓名工资合计保险公积金专项附加起征点工资累计保险累计公积金累计专项附加累计起征点累计累计扣税税,10440.0赵爱军15000.015000.0196.31,10439.0权永建14500.014500.0181.31,10407.0张立柱14000.014000.0166.31,10425.0支成武13500.013500.0151.31,10400.0商新军13000.013000.0136.31,10429.0游洪刚12500.012500.0121.31,10475.0杜松林12000.012000.0106.31,10348.0白红星11500.011500.091.31,27987.0孟金伏11000.011000.076.31,00254窦立燕10500.010500.061.31,81301.0商洪爱10000.010000.046.31,13135.0陈海涛9500.09500.031.31,61078.0刘光军9000.09000.016.31,10597.0王小宝8500.08500.01.31,23165.0王兴雷8000.08000.0,L2948张俊昌7500.07500.0,89474.0王杰7000.07000.0,90516.0刘阳6500.06500.0,69351.0邢相萌6000.06000.0,62093.0王海龙5500.05500.0,37297.0董亮亮,83054.0申海滨4500.04500.0,73577.0李志国4000.04000.0,71561.0杜凡3500.03500.0,74817.0周志山,75122.0耿伟2500.02500.0,76174.0石凯凯2000.02000.0,75004.0王学峰1500.01500.0,71845.0牛雪军1000.01000.0,75476.0王德华500.0500.0,2月工资表,工号姓名工资合计保险公积金专项附加起征点工资累计保险累计公积金累计专项附加累计起征点累计累计扣税税,10439.0权永建4444.1818944.18181.31-120.37,10407.0张立柱14500.028500.0166.31181.31,10425.0支成武24555.8238055.82151.31482.98,10400.0商新军34611.6447611.64136.31784.66,10429.0游洪刚44667.4657167.46121.311384.16,10475.0杜松林54723.2866723.28106.312354.74,10348.0白红星64779.176279.191.313325.32,27987.0孟金伏74834.9285834.9276.314295.9,00254窦立燕84890.7495390.7461.315266.48,81301.0商洪爱94946.56104946.5646.316237.07,13135.0陈海涛105002.38114502.3831.317207.65,61078.0刘光军115058.2124058.216.318178.23,10597.0王小宝125114.02133614.021.319148.81,23165.0王兴雷135169.84143169.8410105.7,L2948张俊昌145225.66152725.6611061.29,89474.0王杰155281.48162281.4812153.74,90516.0刘阳165337.3171837.314064.9,69351.0邢相萌175393.12181393.1215976.06,62093.0王海龙185448.94190948.9417887.23,37297.0董亮亮195504.76200504.7619798.39,83054.0申海滨205560.58210060.5821709.56,73577.0李志国215616.4219616.423620.72,71561.0杜凡225672.22229172.2225531.88,74817.0周志山235728.04238728.0427443.05,75122.0耿伟245783.86248283.8629354.21,76174.0石凯凯255839.68257839.6831265.38,75004.0王学峰265895.5267395.533176.54,71845.0牛雪军275951.32276951.3235087.7,10440.0赵爱军286007.144000.0301007.147000.0196.3139502.56,3月工资表,工号姓名工资合计保险公积金专项附加起征点工资累计保险累计公积金累计专项附加累计起征点累计累计扣税税,10439.0权永建4444.1823388.3660.94-60.94,10407.0张立柱14500.043000.0347.62181.3,10425.0支成武24555.8262611.64634.29569.95,10400.0商新军34611.6482223.28920.972244.44,10429.0游洪刚44667.46101834.921505.473621.1,10348.0白红星54723.28131002.383416.634626.69,27987.0孟金伏64779.1150614.024372.215632.27,00254窦立燕74834.92170225.665327.796723.5,10440.0赵爱军84890.744000.0385897.8811000.039698.8718013.3,13135.0陈海涛94946.56209448.947238.9612656.99,61078.0刘光军105002.38229060.588194.5415623.74,10597.0王小宝115058.2248672.229150.1218590.48,23165.0王兴雷125114.02268283.8610105.721557.23,L2948张俊昌135169.84287895.511061.2924523.97,89474.0王杰145225.66307507.1412153.7427353.85,90516.0刘阳155281.48327118.7814064.929452.5,69351.0邢相萌165337.3346730.4215976.0632444.25,62093.0王海龙175393.12366342.0617887.2335435.99,37297.0董亮亮185448.94385953.719798.3938427.74,83054.0申海滨195504.76405565.3421709.5641419.48,73577.0李志国205560.58425176.9823620.7244411.23,71561.0杜凡215616.4444788.6225531.8847402.98,74817.0周志山225672.22464400.2627443.0551346.27,75122.0耿伟235728.04484011.929354.2155318.6,76174.0石凯凯245783.86503623.5431265.3859290.92,75004.0王学峰255839.68523235.1833176.5463263.25,71845.0牛雪军265895.5542846.8235087.767235.59,75476.0王德华275951.32275951.320.036578.98,286007.14,4月工资表,工号姓名工资合计保险公积金专项附加起征点工资累计保险累计公积金累计专项附加累计起征点累计累计扣税税,10439.0权永建4444.1827832.540.00.0,10407.0张立柱14500.057500.0528.92181.31,10425.0支成武24555.8287167.461204.241609.95,10400.0商新军34611.64116834.923165.412615.52,10429.0游洪刚44667.46146502.385126.573621.11,10348.0白红星54723.28185725.668043.325416.69,27987.0孟金伏64779.1215393.1210004.489389.02,00254窦立燕74834.92245060.5812051.2913275.71,10440.0赵爱军84890.744000.0470788.6215000.057712.1719556.74,13135.0陈海涛94946.56304395.519895.9517298.03,61078.0刘光军105002.38334062.9623818.2819321.06,10597.0王小宝115058.2363730.4227740.622815.61,23165.0王兴雷125114.02393397.8831662.9326310.14,L2948张俊昌135169.84423065.3435585.2629804.68,89474.0王杰145225.66452732.839507.5933299.21,90516.0刘阳155281.48482400.2643517.438135.0,69351.0邢相萌165337.3512067.7248420.3142132.33,62093.0王海龙175393.12541735.1853323.2246129.65,37297.0董亮亮185448.94571402.6458226.1350126.98,83054.0申海滨195504.76601070.163129.0454124.31,73577.0李志国205560.58630737.5668031.9558121.64,71561.0杜凡215616.4660405.0272934.8662118.97,74817.0周志山225672.22690072.4878789.3265164.74,75122.0耿伟235728.04719739.9484672.8169477.21,76174.0石凯凯245783.86749407.490556.373977.33,75004.0王学峰255839.68779074.8696439.7978477.45,71845.0牛雪军265895.5808742.32102323.2982977.56,75476.0王德华275951.32551902.64669.2243.66000.010000.036578.9870997.97,286007.14,5月工资表,工号姓名工资合计保险公积金专项附加起征点工资累计保险累计公积金累计专项附加累计起征点累计累计扣税税,10439.0权永建4444.1832276.720.00.0,10407.0张立柱14500.072000.0710.23181.31,10425.0支成武24555.82111723.282814.191609.94,10400.0商新军34611.64151446.565780.932615.53,10429.0游洪刚44667.46191169.848747.684109.89,10348.0白红星54723.28240448.9413460.019253.38,27987.0孟金伏64779.1280172.2219393.511264.54,00254窦立燕74834.92319895.525327.013275.7,10440.0赵爱军84890.744000.0555679.3619000.077268.9122630.3,13135.0陈海涛94946.56399342.0637193.9820151.04,61078.0刘光军105002.38439065.3443139.3424136.5,10597.0王小宝115058.2478788.6250556.2127475.78,23165.0王兴雷125114.02518511.957973.0731975.9,L2948张俊昌135169.84558235.1865389.9436476.01,89474.0王杰145225.66597958.4672806.840976.14,90516.0刘阳155281.48637681.7481652.444047.52,69351.0邢相萌165337.3677405.0290552.6447064.27,62093.0王海龙175393.12717128.399452.8750823.33,37297.0董亮亮185448.94756851.58108353.1155826.24,83054.0申海滨195504.76796574.86117253.3560829.15,73577.0李志国205560.58836298.14126153.5965832.06,71561.0杜凡215616.4876021.42135053.8370834.97,74817.0周志山225672.22915744.7143954.0675837.89,75122.0耿伟235728.04955467.98154150.0279545.07,76174.0石凯凯245783.86995191.26164533.6383064.61,75004.0王学峰255839.681034914.54174917.2489847.4,71845.0牛雪军265895.51074637.82185300.8597339.27,75476.0王德华275951.32827853.961003.8365.49000.0107576.9587372.72,286007.14,6月工资表,工号姓名工资合计保险公积金专项附加起征点工资累计保险累计公积金累计专项附加累计起征点累计累计扣税税,10439.0权永建4444.1836720.90.00.0,10407.0张立柱14500.086500.0891.54181.31,10425.0支成武24555.82136279.14424.131609.94,10400.0商新军34611.64186058.28396.462615.52,10429.0游洪刚44667.46235837.312857.577242.21,10348.0白红星54723.28295172.2222713.399253.37,27987.0孟金伏64779.1344951.3230658.0411264.54,00254窦立燕74834.92394730.4238602.715475.31,10440.0赵爱军84890.744000.0640570.123000.099899.2122630.3,13135.0陈海涛94946.56494288.6257345.0222800.05,61078.0刘光军105002.38544067.7267275.8427802.96,10597.0王小宝115058.2593846.8278031.9931980.54,23165.0王兴雷125114.02643625.9289948.9734997.29,L2948张俊昌135169.84693405.02101865.9538014.04,89474.0王杰145225.66743184.12113782.9442653.06,90516.0刘阳155281.48792963.22125699.9248158.77,69351.0邢相萌165337.3842742.32137616.9153664.46,62093.0王海龙175393.12892521.42150276.258427.86,37297.0董亮亮185448.94942300.52164179.3561947.39,83054.0申海滨195504.76992079.62178082.565466.93,73577.0李志国205560.581041858.72191985.6572098.49,71561.0杜凡215616.41091637.82205888.880595.94,74817.0周志山225672.221141416.92219791.9589093.38,75122.0耿伟235728.041191196.02233695.0997590.84,76174.0石凯凯245783.861240975.12247598.24106088.28,75004.0王学峰255839.681290754.22264764.64111322.48,71845.0牛雪军265895.51340533.32282640.12115847.59,75476.0王德华275951.321103805.281338.4487.212000.020000.0194949.67104621.19,286007.14,7月工资表,工号姓名工资合计保险公积金专项附加起征点工资累计保险累计公积金累计专项附加累计起征点累计累计扣税税,10439.0权永建4444.1841165.080.00.0,10407.0张立柱14500.0101000.01072.85587.67,10425.0支成武24555.82160834.926034.071609.94,10400.0商新军34611.64220669.8411011.984363.03,10429.0游洪刚44667.46280504.7620099.787242.21,10348.0白红星54723.28349895.531966.769253.38,27987.0孟金伏64779.1409730.4241922.5813791.33,00254窦立燕74834.92469565.3454078.0116594.63,10440.0赵爱军84890.744000.0725460.8427000.0122529.5122643.6,13135.0陈海涛94946.56589235.1880145.0725947.04,61078.0刘光军105002.38649070.195078.828963.79,10597.0王小宝115058.2708905.02110012.5331980.54,23165.0王兴雷125114.02768739.94124946.2637474.54,L2948张俊昌135169.84828574.86139879.9943483.03,89474.0王杰145225.66888409.78156436.047869.24,90516.0刘阳155281.48948244.7173858.6951388.78,69351.0邢相萌165337.31008079.62191281.3754908.32,62093.0王海龙175393.121067914.54208704.0663299.82,37297.0董亮亮185448.941127749.46226126.7472802.86,83054.0申海滨195504.761187584.38243549.4382305.88,73577.0李志国205560.581247419.3264084.1488696.88,71561.0杜凡215616.41307254.22286484.7493222.0,74817.0周志山225672.221367089.14308885.3397747.12,75122.0耿伟235728.041426924.06331285.93102272.24,76174.0石凯凯245783.861486758.98353686.52106797.36,75004.0王学峰255839.681546593.9376087.12111322.48,71845.0牛雪军265895.51606428.82398487.71115847.6,75476.0王德华275951.321379756.61673.0609.015000.025000.0299570.86120372.71,286007.14,8月工资表,工号姓名工资合计保险公积金专项附加起征点工资累计保险累计公积金累计专项附加累计起征点累计累计扣税税,10439.0权永建4444.1845609.260.00.0,10407.0张立柱14500.0115500.01660.52604.36,10425.0支成武24555.82185390.747644.011609.94,10400.0商新军34611.64255281.4815375.015231.05,10429.0游洪刚44667.46325172.2227341.997242.21,10348.0白红星54723.28404618.7841220.1411101.76,27987.0孟金伏64779.1474509.5255713.9114080.67,00254窦立燕74834.92544400.2670672.6419432.08,10440.0赵爱军84890.744000.0810351.5831000.0145173.1126402.02,13135.0陈海涛94946.56684181.74106092.1125947.05,61078.0刘光军105002.38754072.48124042.5930284.86,10597.0王小宝115058.2823963.22141993.0736796.14,23165.0王兴雷125114.02893853.96162420.840830.17,L2948张俊昌135169.84963744.7183363.0244349.7,89474.0王杰145225.661033635.44204305.2448467.67,90516.0刘阳155281.481103526.18225247.4758976.27,69351.0邢相萌165337.31173416.92246189.6969484.88,62093.0王海龙175393.121243307.66272003.8875121.53,37297.0董亮亮185448.941313198.4298929.679646.64,83054.0申海滨195504.761383089.14325855.3184171.76,73577.0李志国205560.581452979.88352781.0288696.89,71561.0杜凡215616.41522870.62379706.7493222.0,74817.0周志山225672.221592761.36406632.4597747.12,75122.0耿伟235728.041662652.1433558.17102272.24,76174.0石凯凯245783.861732542.84460483.88106797.36,75004.0王学峰255839.681802433.58487409.6111322.47,71845.0牛雪军265895.51872324.32514335.31115847.59,75476.0王德华275951.321655707.922007.6730.818000.030000.0419943.57120372.71,286007.14,9月工资表,工号姓名工资合计保险公积金专项附加起征点工资累计保险累计公积金累计专项附加累计起征点累计累计扣税税,10439.0权永建4444.1850053.440.00.0,10407.0张立柱14500.0130000.02264.88604.36,10425.0支成武24555.82209946.569253.951609.95,10400.0商新军34611.64289893.1220606.065231.04,10429.0游洪刚44667.46369839.6834584.27242.22,10348.0白红星54723.28459342.0652321.911566.72,27987.0孟金伏64779.1539288.6269794.5816239.73,00254窦立燕74834.92619235.1890104.7219913.55,10440.0赵爱军84890.744000.0895242.3235000.0171575.1326402.02,13135.0陈海涛94946.56779128.3132039.1628098.09,61078.0刘光军105002.38859074.86154327.4533791.09,10597.0王小宝115058.2939021.42178789.2137310.63,23165.0王兴雷125114.021018967.98203250.9740830.16,L2948张俊昌135169.841098914.54227712.7250630.4,89474.0王杰145225.661178861.1252772.9161546.17,90516.0刘阳155281.481258807.66284223.7466071.29,69351.0邢相萌165337.31338754.22315674.5770596.41,62093.0王海龙175393.121418700.78347125.4175121.52,37297.0董亮亮185448.941498647.34378576.2479646.64,83054.0申海滨195504.761578593.9410027.0784171.77,73577.0李志国205560.581658540.46441477.9188696.88,71561.0杜凡215616.41738487.02472928.7493222.0,74817.0周志山225672.221818433.58504379.5797747.12,75122.0耿伟235728.041898380.14535830.41102272.23,76174.0石凯凯245783.861978326.7567281.24106797.36,75004.0王学峰255839.682058273.26598732.07111322.48,71845.0牛雪军265895.52138219.82630182.9115847.6,75476.0王德华275951.321931659.242342.2852.621000.035000.0540316.28120372.72,286007.14,10月工资表,工号姓名工资合计保险公积金专项附加起征点工资累计保险累计公积金累计专项附加累计起征点累计累计扣税税,10439.0权永建4444.1854497.620.00.0,10407.0张立柱14500.0144500.02869.24604.36,10425.0支成武24555.82234502.3810863.92203.78,10400.0商新军34611.64324504.7625837.15231.05,10429.0游洪刚44667.46414507.1441826.428739.37,10348.0白红星54723.28514065.3463888.6212041.78,27987.0孟金伏64779.1604067.7286034.3116896.81,00254窦立燕74834.92694070.1110018.2719913.56,10440.0赵爱军84890.744000.0980133.0639000.0197977.1526402.02,13135.0陈海涛94946.56874074.86160137.2530271.55,61078.0刘光军105002.38964077.24188118.5433791.09,10597.0王小宝115058.21054079.62216099.8438262.19,23165.0王兴雷125114.021144082.0244081.1350781.97,L2948张俊昌135169.841234084.38278343.1257021.05,89474.0王杰145225.661324086.76314319.0861546.16,90516.0刘阳155281.481414089.14350295.0366071.28,69351.0邢相萌165337.31504091.52386270.9870596.4,62093.0王海龙175393.121594093.9422246.9375121.53,37297.0董亮亮185448.941684096.28458222.8879646.65,83054.0申海滨195504.761774098.66494198.8484171.76,73577.0李志国205560.581864101.04530174.7988696.88,71561.0杜凡215616.41954103.42566150.7493222.0,74817.0周志山225672.222044105.8602126.6997747.12,75122.0耿伟235728.042134108.18638102.64102272.24,76174.0石凯凯245783.862224110.56674078.6106797.35,75004.0王学峰255839.682314112.94710054.55111322.47,71845.0牛雪军265895.52404115.32746030.5115847.59,75476.0王德华275951.322207610.562676.8974.424000.040000.0660689.0120372.71,286007.14,11月工资表,工号姓名工资合计保险公积金专项附加起征点工资累计保险累计公积金累计专项附加累计起征点累计累计扣税税,10439.0权永建4444.1858941.80.00.0,10407.0张立柱14500.0159000.03473.6604.36,10425.0支成武24555.82259058.213067.683219.88,10400.0商新军34611.64359116.431068.155231.05,10429.0游洪刚44667.46459174.650565.799052.76,10348.0白红星54723.28568788.6275930.413880.07,27987.0孟金伏64779.1668846.82102931.1216896.81,00254窦立燕74834.92768905.02129931.8320707.79,10440.0赵爱军84890.744000.01065023.843000.0224379.1726602.36,13135.0陈海涛94946.56969021.42190408.830271.56,61078.0刘光军105002.381069079.62221909.6335397.02,10597.0王小宝115058.21169137.82254362.0347970.81,23165.0王兴雷125114.021269196.02294863.152495.93,L2948张俊昌135169.841369254.22335364.1757021.05,89474.0王杰145225.661469312.42375865.2461546.17,90516.0刘阳155281.481569370.62416366.3166071.29,69351.0邢相萌165337.31669428.82456867.3870596.41,62093.0王海龙175393.121769487.02497368.4675121.52,37297.0董亮亮185448.941869545.22537869.5379646.64,83054.0申海滨195504.761969603.42578370.684171.76,73577.0李志国205560.582069661.62618871.6788696.88,71561.0杜凡215616.42169719.82659372.7493222.0,74817.0周志山225672.222269778.02699873.8197747.12,75122.0耿伟235728.042369836.22740374.88102272.24,76174.0石凯凯245783.862469894.42780875.95106797.36,75004.0王学峰255839.682569952.62821377.02111322.48,71845.0牛雪军265895.52670010.82861878.09115847.6,75476.0王德华275951.322483561.883011.41096.227000.045000.0781061.71120372.72,286007.14,12月工资表,工号姓名工资合计保险公积金专项附加起征点工资累计保险累计公积金累计专项附加累计起征点累计累计扣税税,10439.0权永建4444.1863385.980.00.0,10407.0张立柱14500.0173500.04077.96604.36,10425.0支成武24555.82283614.0216287.563219.88,10400.0商新军34611.64393728.0436299.25231.05,10429.0游洪刚44667.46503842.0659618.559052.77,10348.0白红星54723.28623511.989810.4713880.06,27987.0孟金伏64779.1733625.92119827.9316896.81,00254窦立燕74834.92843739.94150639.6223232.48,10440.0赵爱军84890.744000.01149914.5447000.0250981.5333945.45,13135.0陈海涛94946.561063967.98220680.3630520.67,61078.0刘光军105002.381174082.0257306.6543445.69,10597.0王小宝115058.21284196.02302332.8447970.81,23165.0王兴雷125114.021394310.04347359.0352495.93,L2948张俊昌135169.841504424.06392385.2257021.05,89474.0王杰145225.661614538.08437411.4161546.17,90516.0刘阳155281.481724652.1482437.666071.29,69351.0邢相萌165337.31834766.12527463.7970596.4,62093.0王海龙175393.121944880.14572489.9875121.52,37297.0董亮亮185448.942054994.16617516.1779646.64,83054.0申海滨195504.762165108.18662542.3684171.76,73577.0李志国205560.582275222.2707568.5588696.88,71561.0杜凡215616.42385336.22752594.7493222.0,74817.0周志山225672.222495450.24797620.9397747.12,75122.0耿伟235728.042605564.26842647.12102272.24,76174.0石凯凯245783.862715678.28887673.31106797.36,75004.0王学峰255839.682825792.3932699.5111322.48,71845.0牛雪军265895.52935906.32977725.69115847.59,75476.0王德华275951.322759513.23346.01218.030000.050000.0901434.43120372.71,286007.14