Artikel Pilar – Cara Membuat Aplikasi NPWP di Excel

Cara Membuat Aplikasi NPWP di Excel

In this article, we will discuss how to create an NPWP application using Excel. The NPWP (Nomor Pokok Wajib Pajak) is a tax identification number used in Indonesia. By creating an NPWP application in Excel, you can easily manage and track your tax obligations. Let’s dive into the details!

Step 1: Understanding NPWP

NPWP stands for Nomor Pokok Wajib Pajak, which translates to the Tax Identification Number in English. It is a unique number assigned by the Indonesian tax authorities to individuals and businesses for tax purposes. The NPWP is used to identify taxpayers and ensure proper tax compliance.

To create an NPWP application in Excel, we need to understand the structure and requirements of the NPWP. The NPWP consists of several components:

  • First component: The first digit indicates the type of taxpayer (individual or business entity).
  • Second component: The second digit represents the tax office code where the taxpayer is registered.
  • Third component: The following two digits represent the year of registration.
  • Fourth component: The next seven digits represent the taxpayer’s unique identification number.
  • Fifth component: The last digit is a check digit for data validation.

Now that we understand the components of the NPWP, let’s move on to creating the application in Excel.

Step 2: Setting Up Excel for NPWP Application

To begin creating the NPWP application in Excel, follow these steps:

  1. Open Microsoft Excel on your computer.
  2. Create a new workbook by clicking on the “File” menu, selecting “New,” and choosing “Blank Workbook.”
  3. Start by setting up the necessary columns for the NPWP application. The recommended columns include:
Column A Column B Column C
Full Name Tax Office Code Year of Registration
Identification Number
Check Digit

You can add additional columns as needed based on your specific requirements.

Step 3: Data Validation

Once you have set up the necessary columns, you can add data validation to ensure the accuracy and integrity of the NPWP application. Data validation allows you to set specific rules and restrictions for each cell, ensuring that only valid data is entered.

For the “Tax Office Code” column, you can set up a dropdown list with the available tax office codes. This will prevent users from entering an incorrect code and ensure that only valid codes are used in the application.

Similarly, you can set up data validation for the “Year of Registration” column, allowing only valid years to be entered.

For the “Identification Number” column, you can set up a formula to automatically generate a unique identification number based on the selected tax office code and year of registration. This will ensure that each taxpayer has a unique identification number.

Finally, for the “Check Digit” column, you can set up a formula to calculate the check digit based on the other components of the NPWP. This will help validate the accuracy of the NPWP entered in the application.

Step 4: User Interface and Functionality

To create a user-friendly NPWP application in Excel, you can add additional features and functionality. This includes:

  • Adding input masks or formatting for each cell to guide users in entering the correct data.
  • Implementing error handling and validation messages to alert users of any incorrect or incomplete data.
  • Creating buttons or macros to automate certain tasks, such as generating and validating the NPWP.
  • Designing a professional and user-friendly interface using Excel’s formatting and styling options.
  • Adding navigation buttons or dropdown menus to easily switch between different sections or views of the NPWP application.

By incorporating these features, you can create a robust and user-friendly NPWP application in Excel.

FAQ (Frequently Asked Questions)

Q1: Do I need an NPWP?

A1: The NPWP is mandatory for individuals and businesses in Indonesia who meet certain criteria. It is required for various purposes, including tax filing, business transactions, and financial transactions. It is advisable to consult with a tax professional or the local tax authorities to determine if you need an NPWP.

Q2: How long does it take to get an NPWP?

A2: The time required to obtain an NPWP can vary depending on the complexity of your tax situation and the efficiency of the tax authorities. In general, it may take a few weeks to a few months to obtain an NPWP. It is recommended to start the application process well in advance to ensure timely compliance.

Video Tutorial: Creating an NPWP Application in Excel


Creating an NPWP application in Excel can streamline the process of managing and tracking tax obligations in Indonesia. By understanding the structure and requirements of the NPWP, setting up the necessary columns and data validation, and adding user-friendly features and functionality, you can create a professional and efficient NPWP application. Remember to consult with a tax professional or the local tax authorities for specific guidance and compliance with the Indonesian tax regulations.

Thank you for reading this article!