昨天有小伙伴留言說,現(xiàn)在是用累計(jì)預(yù)扣法來計(jì)算個(gè)稅了。
什么是累計(jì)預(yù)扣法呢?
采用累計(jì)預(yù)扣法計(jì)算應(yīng)預(yù)扣稅款時(shí),扣繳義務(wù)人要以納稅人本年度截至當(dāng)前月份取得的累計(jì)收入減除累計(jì)免稅收入、累計(jì)減除費(fèi)用、累計(jì)專項(xiàng)扣除、累計(jì)專項(xiàng)附加扣除和累計(jì)依法確定的其他扣除后的余額,計(jì)算累計(jì)的應(yīng)納稅所得額,適用年度稅率表,計(jì)算累計(jì)應(yīng)預(yù)扣預(yù)繳稅額。最后,用累計(jì)應(yīng)預(yù)扣預(yù)繳稅額減除累計(jì)減免稅額和累計(jì)已預(yù)扣預(yù)繳稅額,計(jì)算本期應(yīng)預(yù)扣預(yù)繳稅額。
計(jì)算公式如下
本期應(yīng)預(yù)扣預(yù)繳稅額=(累計(jì)預(yù)扣預(yù)繳應(yīng)納稅所得額×預(yù)扣率-速算扣除數(shù))-累計(jì)減免稅額-累計(jì)已預(yù)扣預(yù)繳稅額
累計(jì)預(yù)扣預(yù)繳應(yīng)納稅所得額=累計(jì)收入-累計(jì)免稅收入-累計(jì)減除費(fèi)用-累計(jì)專項(xiàng)扣除-累計(jì)專項(xiàng)附加扣除-累計(jì)依法確定的其他扣除
咱們來看,某人每月應(yīng)發(fā)20000元,每月各項(xiàng)扣除6800元
先來看下1月份預(yù)扣預(yù)繳個(gè)稅的計(jì)算
(20000-6800)*0.03=396
接下來2月份預(yù)扣預(yù)繳個(gè)稅的計(jì)算
2月份要減去1月份預(yù)扣預(yù)繳個(gè)稅
(20000*2-6800*2)*0.03-396=396
3月份預(yù)扣預(yù)繳個(gè)稅的計(jì)算
3月份應(yīng)納稅所得額為20000*3-6800*3=39600
3月份的預(yù)扣率為10%,速扣數(shù)2520,減去1月份和2月份的預(yù)扣預(yù)繳個(gè)稅
(20000*3-6800*3)*0.1-2520-396-396=648
接下來,把上面的演算寫成代碼
定義一個(gè)double類型的變量taxable_income來存儲當(dāng)月應(yīng)納稅所得額
定義一個(gè)double類型的變量paid_in來存儲已繳累計(jì),如果是1月份,不參與累計(jì),如果是2月份往后的,就累計(jì)前面月份的已繳個(gè)稅
Sub main()
Dim i As Integer
Dim taxable_income As Double '應(yīng)繳納所得稅額
Dim paid_in As Double '已繳個(gè)稅累計(jì)
Dim payable As Double '當(dāng)月應(yīng)繳納個(gè)稅額
For i = 1 To 12
taxable_income = Cells(i 1, 2) * i - Cells(i 1, 3) * i
If i > 1 Then
paid_in = paid_in Cells(i, 4)
End If
If taxable_income >= 960000 Then
payable = taxable_income * 0.45 - 181920
ElseIf taxable_income >= 660000 Then
payable = taxable_income * 0.35 - 85920
ElseIf taxable_income >= 420000 Then
payable = taxable_income * 0.3 - 52920
ElseIf taxable_income >= 300000 Then
payable = taxable_income * 0.25 - 31920
ElseIf taxable_income >= 144000 Then
payable = taxable_income * 0.2 - 16920
ElseIf taxable_income >= 36000 Then
payable = taxable_income * 0.1 - 2520
ElseIf taxable_income >= 0 Then
payable = taxable_income * 0.03
End If
Cells(i 1, 4) = payable - paid_in
Next i
End Sub
小伙伴們和昨天計(jì)算個(gè)稅的代碼進(jìn)行比較,今天的代碼是先存儲在變量,然后寫入到單元格,昨天是依次寫入單元格,這樣有啥好處?
最后說下,那個(gè)某人不是我,只是舉例,舉例說明,儂曉得伐?
聯(lián)系客服