{"id":463,"date":"2023-07-24T10:01:54","date_gmt":"2023-07-24T10:01:54","guid":{"rendered":"https:\/\/www.programgaji.com\/blog\/?p=463"},"modified":"2025-01-20T11:27:05","modified_gmt":"2025-01-20T04:27:05","slug":"menghitung-pph-21-dengan-excel","status":"publish","type":"post","link":"https:\/\/www.programgaji.com\/blog\/menghitung-pph-21-dengan-excel\/","title":{"rendered":"Cara Menghitung PPh 21 dengan Excel Sesuai UU HPP 2023"},"content":{"rendered":"<p>Perhitungan PPh 21 merupakan pekerjaan yang cukup menyita waktu jika dilakukan dengan cara manual. Tentu dibutuhkan tools atau aplikasi untuk memudahkan pekerjaan tersebut. Cara menghitung PPh 21 menggunakan excel atau aplikasi OnTime Payroll menjadi pilihan yang tepat.<\/p>\n<p>Jika perusahaan Anda masih menggunakan aplikasi manual seperi MS Excel, <a href=\"https:\/\/www.programgaji.com\/blog\/507\/apa-itu-pph-21\/\">perhitungan PPh 21<\/a> jadi lebih sulit dan memakan waktu jika tidak menggunakan template excel.<\/p>\n<p>Sebelum kita membahas tentang bagaimana cara menghitung <a href=\"https:\/\/www.programgaji.com\/blog\/507\/apa-itu-pph-21\/\">PPh 21<\/a> menggunakan excel ada baiknya memahami terlebih dahulu tentang apa itu PPh 21.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_69_1 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.programgaji.com\/blog\/menghitung-pph-21-dengan-excel\/#Apa_itu_PPh_21\" title=\"Apa itu PPh 21?\">Apa itu PPh 21?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.programgaji.com\/blog\/menghitung-pph-21-dengan-excel\/#Cara_Menghitung_PPh_21_dengan_Excel\" title=\"Cara Menghitung PPh 21 dengan Excel\">Cara Menghitung PPh 21 dengan Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.programgaji.com\/blog\/menghitung-pph-21-dengan-excel\/#Cara_Menghitung_PPh_21_Menggunakan_Aplikasi_OnTime_Payroll\" title=\"Cara Menghitung PPh 21 Menggunakan Aplikasi OnTime Payroll\">Cara Menghitung PPh 21 Menggunakan Aplikasi OnTime Payroll<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Apa_itu_PPh_21\"><\/span>Apa itu PPh 21?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>PPh 21 adalah singkatan dari Pajak Penghasilan Pasal 21. PPh 21 merupakan pajak atas penghasilan berupa gaji, upah, honor, tunjangan, bonus, serta jenis pembayaran lain yang berhubungan dengan penghasilan dari suatu pekerjaan.<\/p>\n<p>Perhitungan tarif <a href=\"https:\/\/www.programgaji.com\/blog\/507\/apa-itu-pph-21\/\">PPh 21<\/a> saat ini merujuk pada UU HPP yang mengenakan tarif progresif. Artinya semakin besar penghasilan seseorang atas suatu pekerjaan, maka tarif pajaknya akan semakin besar.<\/p>\n<p><strong>Baca Juga:<\/strong> <a href=\"https:\/\/www.programgaji.com\/blog\/433\/cara-menghitung-tarif-progresif-pph-21-sesuai-uu-hpp\/\">Besaran Tarif Progresif PPh 21 Terbaru<\/a><\/p>\n<p>Biasanya bagian keuangan perusahaan sudah menghitung <a href=\"https:\/\/www.programgaji.com\/blog\/507\/apa-itu-pph-21\/\">PPh 21<\/a>, sehingga karyawan tinggal menerima take home pay (gaji bersih sudah terkena potongan-potongan) sesuai dengan anjuran pemerintah pusat.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cara_Menghitung_PPh_21_dengan_Excel\"><\/span>Cara Menghitung PPh 21 dengan Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Cara menghitung <a href=\"https:\/\/www.programgaji.com\/blog\/507\/apa-itu-pph-21\/\">PPh 21<\/a> menggunakan excel merupakan cara yang paling umum sebelum era digitalisasi. Tapi jika perusahaan anda ingin menggunakan Exel untuk perhitungan PPh 21, tim Anda perlu menguasai rumus-rumus Excel sehingga tim Anda bisa menggunakan model perhitungan manual.<\/p>\n<p>Ada banyak template Exel perhitungan <a href=\"https:\/\/www.programgaji.com\/blog\/507\/apa-itu-pph-21\/\">PPh 21<\/a> yang tersedia di internet. Rumus umum yang biasa digunakan untuk perhitungan PPh 21 meliputi SUM, VlookUp, dan If.<\/p>\n<p>Berikut ini merupakan contoh perhitungan <a href=\"https:\/\/www.programgaji.com\/blog\/507\/apa-itu-pph-21\/\">PPh 21<\/a> menggunakan Excel:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-464 size-full\" src=\"https:\/\/www.programgaji.com\/blog\/wp-content\/uploads\/2023\/07\/contoh-perhitungan-pph-21-dengan-excel.png\" alt=\"contoh perhitungan pph 21 dengan excel\" width=\"895\" height=\"431\" srcset=\"https:\/\/www.programgaji.com\/blog\/wp-content\/uploads\/2023\/07\/contoh-perhitungan-pph-21-dengan-excel.png 895w, https:\/\/www.programgaji.com\/blog\/wp-content\/uploads\/2023\/07\/contoh-perhitungan-pph-21-dengan-excel-300x144.png 300w, https:\/\/www.programgaji.com\/blog\/wp-content\/uploads\/2023\/07\/contoh-perhitungan-pph-21-dengan-excel-768x370.png 768w\" sizes=\"auto, (max-width: 895px) 100vw, 895px\" \/><\/p>\n<p><a href=\"https:\/\/www.programgaji.com\/blog\/507\/apa-itu-pph-21\/\">Cara menghitung PPh 21<\/a> dengan Excel seperti di atas anda perlu menyusun data sedemikian rupa agar perhitungan menjadi mudah.<\/p>\n<p><a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1M9gcNPMVcVaPedKp1OV26u57_mM7VXGbZ6uSsOGqqis\/edit?usp=sharing\" target=\"_blank\" rel=\"noopener\"><br \/>\n<button>Download template excel PPh 21 Gratis<\/button><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cara_Menghitung_PPh_21_Menggunakan_Aplikasi_OnTime_Payroll\"><\/span>Cara Menghitung PPh 21 Menggunakan Aplikasi OnTime Payroll<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Anda hanya perlu memasukkan data-data karyawan tanpa perlu repot-repot menggunakan rumus-rumus excel. Sehinggga pekerjaan perhitungan PPh 21 dapat dilakukan dengan mudah.<\/p>\n<p><a href=\"https:\/\/app.programgaji.com\/user\/register?referralCode=dfhrzl\" target=\"_blank\" rel=\"noopener\"><button>Gunakan OnTime Payroll Sekarang<\/button><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Perhitungan PPh 21 merupakan pekerjaan yang cukup menyita waktu jika dilakukan dengan cara manual. Tentu dibutuhkan tools atau aplikasi untuk memudahkan pekerjaan tersebut. Cara menghitung PPh 21 menggunakan excel atau aplikasi OnTime Payroll menjadi pilihan yang tepat. Jika perusahaan Anda masih menggunakan aplikasi manual seperi MS Excel, perhitungan PPh 21 jadi lebih sulit dan memakan [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":464,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"pagelayer_contact_templates":[],"_pagelayer_content":"","site-sidebar-layout":"default","site-content-layout":"default","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"rank_math_focus_keyword":"","rank_math_description":"","rank_math_opengraph_description":"","rank_math_title":"","rank_math_opengraph_title":"","rank_math_opengraph_image":"","footnotes":""},"categories":[5],"tags":[23,29,24,18,27,28],"class_list":["post-463","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-pph21","tag-aturan-pph-21","tag-cara-menghitung-pph-21","tag-ketentuan-pph-21","tag-pph-21","tag-tarif-pph-21","tag-tarif-progresif-pph-21"],"_links":{"self":[{"href":"https:\/\/www.programgaji.com\/blog\/wp-json\/wp\/v2\/posts\/463","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.programgaji.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.programgaji.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.programgaji.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.programgaji.com\/blog\/wp-json\/wp\/v2\/comments?post=463"}],"version-history":[{"count":1,"href":"https:\/\/www.programgaji.com\/blog\/wp-json\/wp\/v2\/posts\/463\/revisions"}],"predecessor-version":[{"id":6316,"href":"https:\/\/www.programgaji.com\/blog\/wp-json\/wp\/v2\/posts\/463\/revisions\/6316"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.programgaji.com\/blog\/wp-json\/wp\/v2\/media\/464"}],"wp:attachment":[{"href":"https:\/\/www.programgaji.com\/blog\/wp-json\/wp\/v2\/media?parent=463"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.programgaji.com\/blog\/wp-json\/wp\/v2\/categories?post=463"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.programgaji.com\/blog\/wp-json\/wp\/v2\/tags?post=463"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}