2019年新個稅工資表模板-全年累計個稅公式

1、專項扣除統(tǒng)計表月份姓名子女教育繼續(xù)教育住房貸款利息1張三100010001李四10001王五2張三100010002李四10002王五3張三100010003李四10003王五1000住房租金贍養(yǎng)老人合計10003000100020001000100010003000150010003500100010001000300015001000350010002000專項扣除統(tǒng)計表第 3 頁，共 5 頁序號員工姓名應(yīng) 發(fā) 工 資扣 除專項扣除合計合計扣除本年應(yīng)稅工資累計本年個稅累計本月應(yīng)繳個稅兒保費實發(fā)合計備注領(lǐng)款人簽章崗位工資工齡工資津貼其他補貼應(yīng)發(fā)合計養(yǎng)老保險失業(yè)保險醫(yī)療保險住房保險企業(yè)年金保險

2、扣除合計1張三12000.00540.00500.0013040.001355.0037.83151.32160091.723235.873000.0011235.871804.1354.1254.1259755.012李四3000.00660.00300.003960.00333.0033.18132.7279685.991380.892000.008380.89-4420.890.0002579.113王五5000.00780.00500.006280.00547.0044.37177.481065111.931945.781000.007945.78-1665.780.00054339.

3、22合計20000.001980.001300.000.0023280.002235.00115.38461.523461.00289.646562.546000.0027562.54(4282.54)54.1254.121016673.34第 4 頁，共 5 頁序號員工姓名應(yīng) 發(fā) 工 資扣 除專項扣除合計合計扣除本年應(yīng)稅工資累計本年個稅累計本月應(yīng)繳個稅兒保費實發(fā)合計備注領(lǐng)款人簽章崗位工資工齡工資津貼其他補貼應(yīng)發(fā)合計養(yǎng)老保險失業(yè)保險醫(yī)療保險住房保險企業(yè)年金保險扣除合計1張三12000.00540.00500.0013040.001355.0037.83151.32160091.723235.8

4、73000.0011235.873608.26108.2554.1359755.002李四3000.00660.00300.003960.00333.0033.18132.7279685.991380.893500.009880.89-5920.890.0002579.113王五5000.00780.00500.0050,000.0056280.00547.0044.37177.481065111.931945.781000.007945.7848334.222313.422313.42552025.80合計20000.001980.001300.0050000.0073280.002235.

5、00115.38461.523461.00289.646562.547500.0029062.5446021.592421.672367.551064359.91第 5 頁，共 5 頁序號員工姓名應(yīng) 發(fā) 工 資扣 除專項扣除合計合計扣除本年應(yīng)稅工資累計本年個稅累計本月應(yīng)繳個稅兒保費實發(fā)合計備注領(lǐng)款人簽章崗位工資工齡工資津貼其他補貼應(yīng)發(fā)合計養(yǎng)老保險失業(yè)保險醫(yī)療保險住房保險企業(yè)年金保險扣除合計1張三12000.00540.00500.0013040.001355.0037.83151.32160091.723235.873000.0011235.875412.39162.3754.1259755.012李四3000.00660.00300.006,000.009960.00333.0033.18132.7279685.991380.893500.009880.89-5841.780.0008579.113王五5000.00780.00500.006280.00547.0044.37177.481065111.931945.782000.008945.7845668.442046.84-266.5854605.80合計20000.001980.001300.006000.002928