0% found this document useful (0 votes)
53 views3 pages

Gaji dan Pajak Karyawan Berdasarkan Golongan

The document contains tables showing employee data including name, job grade, base salary, allowances, transportation costs, taxes, and net salary. It lists 10 employees with their grade ranging from I to IV, along with the corresponding salary scales. The tables then calculate the total salary, taxes, and net salary for each employee based on their grade and the salary scales.

Uploaded by

Maz Eno
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
53 views3 pages

Gaji dan Pajak Karyawan Berdasarkan Golongan

The document contains tables showing employee data including name, job grade, base salary, allowances, transportation costs, taxes, and net salary. It lists 10 employees with their grade ranging from I to IV, along with the corresponding salary scales. The tables then calculate the total salary, taxes, and net salary for each employee based on their grade and the salary scales.

Uploaded by

Maz Eno
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

NO NAMA GOLONGAN

1 AHMAD I
2 DEWI II
3 ARVAN III
4 HENDRA IV
5 SANDI I
6 QUINTA II
7 RIZQI III
8 AKMAL IV
9 EDUARD III
10 HABIBI I
TOTAL

TABEL GAJI
GOLONGAN GAJI POKOK TUNJANGAN
I Rp 2,500,000 Rp 500,000
II Rp 3,500,000 Rp 700,000
III Rp 6,000,000 Rp 1,200,000
IV Rp 8,000,000 Rp 1,600,000
GAJI
TOTAL GAJI
GAJI POKOK TUNJANGAN TRANSPROT
Rp 2,500,000 Rp 500,000 Rp 200,000 Rp 3,200,000
Rp 3,500,000 Rp 700,000 Rp 300,000 Rp 4,500,000
Rp 6,000,000 Rp 1,200,000 Rp 400,000 Rp 7,600,000
Rp 8,000,000 Rp 1,600,000 Rp 500,000 Rp 10,100,000
Rp 2,500,000 Rp 500,000 Rp 200,000 Rp 3,200,000
Rp 3,500,000 Rp 700,000 Rp 300,000 Rp 4,500,000
Rp 6,000,000 Rp 1,200,000 Rp 400,000 Rp 7,600,000
Rp 8,000,000 Rp 1,600,000 Rp 500,000 Rp 10,100,000
Rp 6,000,000 Rp 1,200,000 Rp 400,000 Rp 7,600,000
Rp 2,500,000 Rp 500,000 Rp 200,000 Rp 3,200,000
Rp 48,500,000 Rp 9,700,000 Rp 3,400,000 Rp 61,600,000

TABEL PAJAK
TRANSPORT I II
Rp 200,000 0% 0%
Rp 300,000
Rp 400,000
Rp 500,000
PAJAK GAJI BERSIH

Rp - Rp 3,200,000
Rp - Rp 4,500,000
Rp 380,000 Rp 7,220,000
Rp 1,010,000 Rp 9,090,000
Rp - Rp 3,200,000
Rp - Rp 4,500,000
Rp 380,000 Rp 7,220,000
Rp 1,010,000 Rp 9,090,000
Rp 380,000 Rp 7,220,000
Rp - Rp 3,200,000
Rp 3,160,000 Rp 58,440,000

III IV
5% 10%

You might also like