Tutorial Lengkap Perhitungan PPh 21 dengan Excel 2023 + Link Download Rumus
Download Rumus PPh 21 Excel: A Guide for Indonesian Taxpayers
If you are an Indonesian taxpayer who earns income from work, service, or activity, you need to pay income tax (Pajak Penghasilan or PPh) according to Article 21 of the Indonesian tax law. This tax is deducted from your income by your employer or payer, and you need to report it in your annual tax return. To calculate how much PPh 21 you have to pay, you can use a formula (rumus) in Microsoft Excel. In this article, we will explain what is PPh 21, how to download rumus PPh 21 excel from various sources, how to use it to calculate your income tax, and what are the benefits and drawbacks of using it. We will also answer some frequently asked questions about rumus PPh 21 excel.
What is PPh 21 and why do you need to calculate it?
PPh 21 is a withholding income tax that applies to income from work, service, or activity that is received by an individual resident taxpayer or a permanent establishment (PE) in Indonesia. This includes employees, civil servants, freelancers, consultants, artists, athletes, pensioners, and heirs. The amount of PPh 21 depends on your gross income, deductions, non-taxable income (PTKP), taxable income (PKP), and tax rates. You need to calculate your PPh 21 to know how much tax you have to pay or get refunded, and to comply with the Indonesian tax regulations.
download rumus pph 21 excel
How to download rumus PPh 21 excel from various sources?
There are many sources where you can download rumus PPh 21 excel for free or for a fee. Some of them are:
: This website provides various Excel formulas and templates for accounting, finance, and taxation purposes. You can download rumus PPh 21 excel for free from this link. The formula uses IF, SUM, AND, and VLOOKUP functions to calculate PPh 21 based on your income, deductions, PTKP, PKP, and tax rates.
: This website offers a payroll software and a blog that covers topics related to payroll and taxation. You can download rumus PPh 21 excel for free from this link. The formula uses SUM, IF, VLOOKUP, and MAX functions to calculate PPh 21 based on your income, deductions, PTKP, PKP, and tax rates.
: This website provides information and tips about jobs and careers in Indonesia. You can download rumus PPh 21 excel for free from this link. The formula uses SUM, IF, VLOOKUP, MAX, MIN functions to calculate PPh 21 based on your income, deductions, PTKP, PKP, and tax rates.
: This website shares knowledge and tutorials about Excel formulas and functions. You can download rumus PPh 21 excel for free from this link. The formula uses MAX function to calculate gross up PPh 21 based on your net income.
: This website explains the logic and meaning behind Excel formulas. You can download rumus PPh 21 excel for free from this link. The formula uses MAX function to calculate progressive PPh 21 based on your PKP.
How to use rumus PPh 21 excel to calculate your income tax?
To use rumus PPh 21 excel to calculate your income tax, you need to follow these steps:
Download the rumus PPh 21 excel file from the source of your choice and open it in Microsoft Excel.
Enter your income and deductions data in the designated cells. For example, if you use the rumus PPh 21 excel from Jurnal Excel, you need to enter your monthly income, THR, bonus, overtime, severance pay, pension, insurance premium, and other deductions in cells B4 to B11.
The rumus PPh 21 excel will automatically calculate your gross income, PTKP, PKP, and PPh 21 in the corresponding cells. For example, if you use the rumus PPh 21 excel from Jurnal Excel, you will see your gross income in cell B13, your PTKP in cell B14, your PKP in cell B15, and your PPh 21 in cell B16.
Check the accuracy of the calculation and make sure it matches with your tax slip or tax return. If there are any discrepancies, you may need to adjust your data or use a different rumus PPh 21 excel.
Benefits and drawbacks of using rumus PPh 21 excel
Using rumus PPh 21 excel can have some benefits and drawbacks for Indonesian taxpayers. Here are some of them:
Benefits
It can save you time and effort in calculating your PPh 21 manually or using a tax calculator online.
It can help you understand how PPh 21 is calculated and what factors affect it.
It can help you plan your tax payment or refund and manage your cash flow.
It can help you avoid errors or mistakes in reporting your PPh 21 to the tax authority.
Drawbacks
It may not be updated with the latest tax regulations or changes in the tax rates or PTKP.
It may not be compatible with your Excel version or operating system.
It may not be accurate or reliable if the formula is incorrect or incomplete.
It may not cover all types of income or deductions that are applicable to you.
Conclusion: Summarize the main points and provide some tips
In conclusion, rumus PPh 21 excel is a useful tool for Indonesian taxpayers who want to calculate their income tax easily and quickly. However, it also has some limitations and risks that you need to be aware of. Therefore, we recommend you to do the following tips when using rumus PPh 21 excel:
Always check the source and validity of the rumus PPh 21 excel before downloading it.
Always update your data and formula with the latest information and regulations.
Always compare your calculation with your tax slip or tax return and verify any discrepancies.
Always consult a professional tax advisor if you have any doubts or questions about your PPh 21 calculation.
FAQs: Answer some common questions about rumus PPh 21 excel
Q: Where can I find the official tax rates and PTKP for PPh 21?
A: You can find the official tax rates and PTKP for PPh 21 on the website of the Directorate General of Taxes (DGT) at . The current tax rates are 5%, 15%, 25%, and 30% for PKP brackets of up to Rp50 million, Rp50-250 million, Rp250-500 million, and above Rp500 million respectively. The current PTKP is Rp54 million for single taxpayers, plus Rp4.5 million for each dependent (up to three dependents).
Q: How can I get a tax slip or tax return for my PPh 21?
A: You can get a tax slip (bukti potong) for your PPh 21 from your employer or payer who deducts your income tax every month. You can also get a tax return (SPT) for your PPh 21 from the DGT website at by registering and logging in with your taxpayer identification number (NPWP) and password. You need to file your annual tax return by March 31 of the following year and report your PPh 21 along with other types of income tax.
download template excel perhitungan pph 21
download contoh excel perhitungan pph 21
download rumus excel perhitungan pph 21 terbaru
download file excel perhitungan pph 21
download aplikasi excel perhitungan pph 21
download format excel perhitungan pph 21
download gratis excel perhitungan pph 21
download software excel perhitungan pph 21
download tutorial excel perhitungan pph 21
download cara excel perhitungan pph 21
download panduan excel perhitungan pph 21
download kalkulator excel perhitungan pph 21
download tabel excel perhitungan pph 21
download rumus excel penghitungan pph 21
download rumus excel hitung pph 21
download rumus excel menghitung pph 21
download rumus excel menentukan pph 21
download rumus excel mencari pph 21
download rumus excel mengetahui pph 21
download rumus excel mengecek pph 21
download rumus excel mengisi pph 21
download rumus excel mengubah pph 21
download rumus excel menghapus pph 21
download rumus excel menyimpan pph 21
download rumus excel mencetak pph 21
download rumus excel membuat pph 21
download rumus excel memperbaiki pph 21
download rumus excel memperbarui pph 21
download rumus excel mempersiapkan pph 21
download rumus excel mempelajari pph 21
download rumus excel memahami pph 21
download rumus excel membandingkan pph 21
download rumus excel memvalidasi pph 21
download rumus excel mereview pph 21
download rumus excel merevisi pph 21
download rumus excel merekapitulasi pph 21
download rumus excel melaporkan pph 21
download rumus excel melihat pph 21
download rumus excel menyederhanakan pph 21
download rumus excel menyempurnakan pph 21
Q: How can I pay or get refunded for my PPh 21?
A: You can pay or get refunded for your PPh 21 through the DGT website at by logging in with your NPWP and password. You can also pay or get refunded through the bank or post office by using the payment slip (SSP) or refund slip (SSR) that you can print from the DGT website. You need to pay or get refunded for your PPh 21 by April 30 of the following year.
Q: What are the penalties for not calculating, reporting, or paying your PPh 21 correctly?
A: If you fail to calculate, report, or pay your PPh 21 correctly, you may face some penalties from the DGT. These include:
A fine of 2% per month of the underpaid tax amount, up to a maximum of 48%.
A penalty of 100% of the underpaid tax amount if you are found to be deliberately evading tax.
A criminal sanction of imprisonment for up to six years and/or a fine of up to four times the underpaid tax amount if you are found to be committing tax fraud.
Q: What are some tips to optimize your PPh 21 calculation?
A: Some tips to optimize your PPh 21 calculation are:
Claim all the deductions that you are entitled to, such as insurance premium,