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
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article