1721-I Bulanan - Monthly Tax Report (Regular)

Modified on Wed, 31 Jan at 10:34 AM

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

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

"21" Sheet

Column A2	No	Number
Column B2	Tgl Pemotongan (dd/MM/yyyy)	The date when the report exported example: 27/01/2024
Column C2	Penerima 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 D2	NPWP (tanpa format/tanda baca)	Tax ID Number, 15 digits numerical value leave it blank if employee using NIK
Column E2	NIK (tanpa format/tanda baca)	Identification number, numerical value leave it blank if employee using NPWP
Column F2	Nama Penerima Penghasilan Sesuai NIK	Employee name
Column G2	Alamat Penerima Penghasilan Sesuai NIK	Employee address
Column H2	Kode Objek Pajak	Tax Code example: If "Pegawai Tetap" fill the box with 21-100-01 Based on Ref Daftar Objek Pajak Sheet
Column I2	Penandatangan 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 J2	NPWP 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 K2	NIK Penandatangan (tanpa format/tanda baca)	Identification number, numerical value leave it blank if Tax Payer Name in the Company Details using NPWP
Column L2	PTKP	Non Taxable Group
Column M2	Pegawai 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 N2	Menggunakan 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 O2	Penghasilan Bruto	Gross Income + Bonus
Column P2	Mendapatkan Fasilitas ? (N/SKB/DTP)	N
Column Q2	Nomor SKB/Nomor DTP	leave it blank

"26" Sheet

Column A2	No	Number
Column B2	Tgl Pemotongan (dd/MM/yyyy)	The date when the report exported example: 27/01/2024
Column C2	TIN (dengan format/tanda baca)	Tax ID Number, 15 digits numerical value
Column D2	Nama Penerima Penghasilan	Employee name
Column E2	Alamat Penerima Penghasilan	Employee address
Column F2	No Paspor Penerima Penghasilan	Fill with Identification Number if the Identification Document is Passport
Column G2	Kode Negara	Nationality example: If "Afghanistan" fill the box with AFG Based on Ref Daftar Kode Negara Sheet
Column H2	Penandatangan 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 I2	NPWP 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 J2	NIK Penandatangan (tanpa format/tanda baca)	Identification number, numerical value leave it blank if Tax Payer Name in the Company Details using NPWP
Column K2	Penghasilan Bruto	Gross Income + Bonus
Column L2	Mendapatkan Fasilitas ? (N/SKD)	N
Column M2	Nomor Tanda Terima SKD	Leave it blank
Column N2	Tarif SKD	Leave it blank

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