v1.0可編寫可更正薪酬方案設(shè)計(jì)：1、新建薪水類型2、新增薪水項(xiàng)目及公式1所屬分類公共項(xiàng)目名稱發(fā)放項(xiàng)目名稱2合計(jì)類應(yīng)發(fā)薪水合計(jì)應(yīng)發(fā)薪水合計(jì)3合計(jì)類實(shí)發(fā)薪水合計(jì)實(shí)發(fā)薪水合計(jì)4合計(jì)類應(yīng)得薪水小計(jì)本月扣稅5虛假類應(yīng)發(fā)薪水a(chǎn)累計(jì)薪水6虛假類養(yǎng)老金a累計(jì)專項(xiàng)扣除1v1.0可編寫可更正7虛假類公積金a累計(jì)專項(xiàng)附帶扣除8虛假類其余a起征點(diǎn)9虛假類薪水稅a累計(jì)扣稅10虛假類外派天數(shù)a累計(jì)起征點(diǎn)11虛假類其余獎(jiǎng)勵(lì)一a專項(xiàng)扣除合計(jì)12虛假類其余獎(jiǎng)勵(lì)二a專項(xiàng)附帶扣除合計(jì)13基本類崗位薪水崗位薪水14財(cái)務(wù)待扣繳類扣基本養(yǎng)老保險(xiǎn)扣基本養(yǎng)老保險(xiǎn)15財(cái)務(wù)待扣繳類扣基本醫(yī)療保險(xiǎn)扣基本醫(yī)療保險(xiǎn)16財(cái)務(wù)待扣繳類扣失業(yè)保險(xiǎn)扣失業(yè)保險(xiǎn)17財(cái)務(wù)待扣繳類扣住宅公積金扣住宅公積金18財(cái)務(wù)待扣繳類扣企業(yè)年金扣企業(yè)年金19財(cái)務(wù)待扣繳類扣房租水電費(fèi)兒女教育20財(cái)務(wù)待扣繳類扣工會(huì)會(huì)費(fèi)連續(xù)教育21財(cái)務(wù)待扣繳類扣話費(fèi)重病醫(yī)療22財(cái)務(wù)待扣繳類扣借款住宅貸款利息23財(cái)務(wù)待扣繳類其余代扣代繳住宅租金24財(cái)務(wù)待扣繳類重病兼顧奉養(yǎng)老人25中間計(jì)算類特別年功工齡稅率26中間計(jì)算類速扣數(shù)速扣數(shù)27中間計(jì)算類應(yīng)稅所得額扣稅基數(shù)公式：應(yīng)發(fā)薪水合計(jì)：各薪水項(xiàng)合計(jì)，各單位依據(jù)自己需要進(jìn)行編寫。實(shí)發(fā)薪水合計(jì)：{薪水項(xiàng)目:應(yīng)發(fā)薪水合計(jì)}-{薪水項(xiàng)目:本月扣稅}-{薪水項(xiàng)目:專項(xiàng)扣除合計(jì)}2v1.0可編寫可更正本月扣稅：假如{薪水項(xiàng)目:扣稅基數(shù)}*{薪水項(xiàng)目:稅率}-{薪水項(xiàng)目:累計(jì)扣稅}-{薪水項(xiàng)目:速扣數(shù)}>0則{薪水項(xiàng)目:扣稅基數(shù)}*{薪水項(xiàng)目:稅率}-{薪水項(xiàng)目:累計(jì)扣稅}-{薪水項(xiàng)目:速扣數(shù)}不然0起征點(diǎn)：5000累計(jì)薪水、累計(jì)專項(xiàng)扣除、累計(jì)專項(xiàng)附帶扣除、累計(jì)扣稅、累計(jì)起征點(diǎn)：選擇其余數(shù)據(jù)源-薪水，點(diǎn)右側(cè)函數(shù)選擇薪水統(tǒng)計(jì)數(shù)-絕對(duì)時(shí)間段，選擇薪水類型，薪水項(xiàng)目對(duì)應(yīng)選擇以下：累計(jì)薪水-應(yīng)發(fā)薪水合計(jì)累計(jì)累計(jì)專項(xiàng)扣除-專項(xiàng)扣除合計(jì)累計(jì)專項(xiàng)附帶扣除-專項(xiàng)附帶扣除合計(jì)累計(jì)扣稅-本月扣稅累計(jì)起征點(diǎn)-起征點(diǎn)初步年度和時(shí)期依據(jù)各單位薪水采納新計(jì)稅算法時(shí)期為初步時(shí)期。（如1月做11月份薪水的，需用新稅率的，初步時(shí)期即為201811）專項(xiàng)扣除合計(jì)：{薪水項(xiàng)目:扣基本養(yǎng)老保險(xiǎn)}+{薪水項(xiàng)目:扣基本醫(yī)療保險(xiǎn)}+{薪水項(xiàng)目:扣失業(yè)保險(xiǎn)}+{薪水項(xiàng)目:扣住宅公積金}3v1.0可編寫可更正{薪水項(xiàng)目:扣企業(yè)年金}專項(xiàng)附帶扣除合計(jì)：{薪水項(xiàng)目:兒女教育}+{薪水項(xiàng)目:連續(xù)教育}+{薪水項(xiàng)目:重病醫(yī)療}+{薪水項(xiàng)目:住宅貸款利息}+{薪水項(xiàng)目:住宅租金}+{薪水項(xiàng)目:奉養(yǎng)老人}稅率：假如{薪水項(xiàng)目:扣稅基數(shù)}>0而且{薪水項(xiàng)目:扣稅基數(shù)}<=36000則假如{薪水項(xiàng)目:扣稅基數(shù)}>36000而且{薪水項(xiàng)目:扣稅基數(shù)}<=144000則假如{薪水項(xiàng)目:扣稅基數(shù)}>144000而且{薪水項(xiàng)目:扣稅基數(shù)}<=300000則假如{薪水項(xiàng)目:扣稅基數(shù)}>300000而且{薪水項(xiàng)目:扣稅基數(shù)}<=420000則假如{薪水項(xiàng)目:扣稅基數(shù)}>420000而且{薪水項(xiàng)目:扣稅基數(shù)}<=660000則假如{薪水項(xiàng)目:扣稅基數(shù)}>660000而且{薪水項(xiàng)目:扣稅基數(shù)}<=960000則假如{薪水項(xiàng)目:扣稅基數(shù)}>960000則不然0速扣數(shù)：假如{薪水項(xiàng)目:扣稅基數(shù)}>0而且{薪水項(xiàng)目:扣稅基數(shù)}<=36000則0假如{薪水項(xiàng)目:扣稅基數(shù)}>36000而且{薪水項(xiàng)目:扣稅基數(shù)}<=144000則2520假如{薪水項(xiàng)目:扣稅基數(shù)}>144000而且{薪水項(xiàng)目:扣稅基數(shù)}4v1.0可編寫可更正<=300000則16920假如{薪水項(xiàng)目:扣稅基數(shù)}>300000而且{薪水項(xiàng)目:扣稅基數(shù)}<=420000則31920假如{薪水項(xiàng)目:扣稅基數(shù)}>420000而且{薪水項(xiàng)目:扣稅基數(shù)}<=660000則52920假如{薪水項(xiàng)目:扣稅基數(shù)}>660000而且{薪水項(xiàng)目:扣稅基數(shù)}<=960000則85920假如{薪水項(xiàng)目:扣稅基數(shù)}>960000則181920不然0扣稅基數(shù)：{薪水項(xiàng)目:應(yīng)發(fā)薪水合計(jì)}+{薪水項(xiàng)目:累計(jì)薪水}-{薪水項(xiàng)目