PT BIA

Dear Sofwan,

Tolong buatkan report tax per employee ..

Field Mounth = period
Field Status = PHRPYTAXSTAT
Field Total Basic + Fix Salary = Hasil penjumlahan yg ada di reguler payroll (PHRPA0004)
Field Rapel Salary =
Field Non Fix Allowances = Additional Payroll
Field Total Non Fix Allowances = Penjumlahan dari Additional Payroll (PHRPA0005)
Field Total GROSS SALARY =
Field Insurance Premium Paid By Company =
Field Total Regular Income (F+J+K+L+M) = Penjumlahan dari Excel yg ada dibawah.
Field Irregular Income (THR / Bonus) = di ambil dari Additional Payroll ( klo dia medapatkan lembur) (PHRPA0005)
Field Irregular Income (THR / Bonus) Accumulated =
Field Gross Income (M+O) = Penjumlahan Total Regular Income + Irregular Income (THR / Bonus) Accumulated
Field Occ suport (max 5%) =
Field Calculasi JHT dan Pensiun by Empl JHT (2%) & Jaminan Pensiun 1% = ambil dari
Field Total Paid ( JHT & Pensiun ) by Empl = perjumlahan JHT 2% + Jaminan Pensiun 1%
Field Insurance premium paid by employee =
Field Total Deduction (Q+S) = Occ suport (max 5%) + Insurance premium paid by employee(Accumulated)
Field Monthly Regular Net Income (P - T) = Gross Income (M+O) - Total Deduction (Q+S)
Field Regular Net Income = Monthly Regular Net Income * 12 / 1 ( tergantung bln utk di baginya)
Field Irregular Income =
Field Total Net Income (V+W) = Perjumlahan Regular Net Income + Irregular Income
Field Non Taxable Income =
Field Taxable Income (X-Y) = =ROUNDDOWN
Field Income Tax Due =
Field Monthly Inc Tax Due =
Field Current month Inc Tax Due =
Field Gross Income =
Field Difference =
Field BPJS Kesehatan = Payroll Benefit
Field Receive Salary = Total yg di dapat.

Terima kasih ...