1721-I Bulanan - Monthly Tax Report (Regular)

Created by Kamiworkforce Support Admin, Modified on Wed, 31 Jan at 10:34 AM by Shifa Shabrina

Payroll > View Reports > Create Report > Tax Reports > 1721-Bulanan > Create Reports > Employee List (CSV) > Preview



1721-I Monthly PPh21 (Excel)


List of Gross Income and Taxes on employees in that month.


The Excel Report is used as the basis for tax reporting on the official application (E-Bupot) of Directorate General of Taxes.



"Rekap" Sheet


Notes: You can only edit the white box



NoName
Explanation
1Tahun PajakTax Year
example: 2024
2Masa PajakTax Month
example: January = 1
3Jumlah Bukti Potong PPh Pasal 21Total column in "21" Sheet
4Jumlah Bukti Potong PPh Pasal 26Total column in "26" Sheet




"21" Sheet



Column A2No

Number


Column B2Tgl Pemotongan (dd/MM/yyyy)The date when the report exported

example: 27/01/2024
Column C2Penerima Penghasilan? (NPWP/NIK)

Fill NIK if NIK box in the system is filled


Fill NPWP if NPWP or both boxes in the system are filled

Column D2NPWP (tanpa format/tanda baca)
Tax ID Number, 15 digits numerical value

leave it blank if employee using NIK
Column E2NIK (tanpa format/tanda baca)Identification number, numerical value

leave it blank if employee using NPWP
Column F2Nama Penerima Penghasilan Sesuai NIK
Employee name
Column G2Alamat Penerima Penghasilan Sesuai NIK

Employee address


Column H2Kode Objek PajakTax Code

example:
If "Pegawai Tetap" fill the box with 21-100-01

Based on Ref Daftar Objek Pajak Sheet
Column I2Penandatangan Menggunakan? (NPWP/NIK)

If Tax Payer Name in the Company Details using NPWP fill with NPWP


If Tax Payer Name in the Company Details using NIK fill with NIK


Column J2NPWP Penandatangan (tanpa format/tanda baca)
Tax ID Number, 15 digits numerical value

leave it blank if Tax Payer Name in the Company Details  using NIK
Column K2NIK Penandatangan (tanpa format/tanda baca)
Identification number, numerical value

leave it blank if Tax Payer Name in the Company Details  using NPWP
Column L2PTKPNon Taxable Group
Column M2Pegawai Harian? (Ya/Tidak)
If the Wage Period is daily and column H2 is 21-100-03 fill with Ya

If the Wage Period is monthly and column H2 is 21-100-03 fill with Tidak

Other than that leave it blank
Column N2Menggunakan Gross Up? (Ya/Tidak)
If the Wage Type is Gross Up fill with Ya

If the Wage Type is Gross or Nett fill with Tidak
Column O2Penghasilan Bruto
Gross Income + Bonus 
Column P2Mendapatkan Fasilitas ? (N/SKB/DTP)
N
Column Q2Nomor SKB/Nomor DTP
leave it blank




"26" Sheet


Column A2
No
Number
Column B2Tgl Pemotongan (dd/MM/yyyy)
The date when the report exported

example: 27/01/2024
Column C2TIN (dengan format/tanda baca)
Tax ID Number, 15 digits numerical value
Column D2
Nama Penerima Penghasilan
Employee name
Column E2Alamat Penerima Penghasilan
Employee address
Column F2No Paspor Penerima Penghasilan
Fill with Identification Number if the Identification Document is Passport
Column G2Kode Negara
Nationality

example:
If "Afghanistan" fill the box with AFG

Based on Ref Daftar Kode Negara Sheet
Column H2Penandatangan Menggunakan? (NPWP/NIK)

If Tax Payer Name in the Company Details using NPWP fill with NPWP


If Tax Payer Name in the Company Details using NIK fill with NIK


Column I2NPWP Penandatangan (tanpa format/tanda baca)
Tax ID Number, 15 digits numerical value

leave it blank if Tax Payer Name in the Company Details using NIK
Column J2NIK Penandatangan (tanpa format/tanda baca)
Identification number, numerical value

leave it blank if Tax Payer Name in the Company Details using NPWP
Column K2Penghasilan Bruto
Gross Income + Bonus
Column L2Mendapatkan Fasilitas ? (N/SKD)
N
Column M2Nomor Tanda Terima SKD
Leave it blank
Column N2Tarif SKD
Leave it blank



Ref Daftar Objek Pajak, Ref Daftar Kode Negara and Ref Daftar PTKP same as the example in the excel worksheet



Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article