GAJI 2024 NAVIGASI MEI 2024 REVISI.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W
1	Data Gaji Bulan		:	Juni 2024
2	Pimpinan		:	M ARIF SETIAWAN
3	Jumlah Karyawan		:	9
4
5	NO	NAMA	NOPEG	JABATAN	TANGGAL MASUK	PENDAPATAN										POTONGAN						GAJI BERSIH
6	NO	NAMA	NOPEG	JABATAN	TANGGAL MASUK	GAJI POKOK	TRANSPORT & MAKAN	INSENTIF	BONUS	LEMBUR	SHIFT MALAM	BPJS Kes	JKK/JKM	JHT	JML PENDAPATAN	BPJS KES	JKK/JKM	JHT	HASIL SO	LAIN-LAIN	JML POTONGAN	GAJI BERSIH
7	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22
8	1	M Arif Setiawan	FF001	PIMPINAN FALENSIA GROUP						Rp -	Rp -		Rp 12,079	Rp 127,509	Rp 139,588		Rp 12,079	Rp 127,509	Rp -	Rp -	Rp 139,588	Rp -
9	2	Maulin	FF002	MANAJER FALENSIA FARMA	28 April 2015	Rp 1,150,000	Rp 270,000	Rp 350,000	Rp 250,000	Rp 75,000	Rp -	Rp 92,676	Rp 12,079	Rp 27,509	Rp 2,227,264	Rp 115,845	Rp 12,079	Rp 127,509		Rp 72,900	Rp 328,333	Rp 1,898,931
10	3	Ibana	FF003	SALES	01 September 2022	Rp 1,000,000		Rp 400,000	Rp 250,000	Rp 75,000	Rp -	Rp -	Rp 12,079	Rp 27,509	Rp 1,764,588	Rp -	Rp 12,079	Rp 127,509		Rp -	Rp 139,588	Rp 1,625,000
11	4	Ulvy	FF004	SALES	14 Januari 2023	Rp 1,000,000		Rp 400,000	Rp 250,000	Rp 75,000	Rp -	Rp 92,676	Rp 12,079	Rp 27,509	Rp 1,857,264	Rp 115,845	Rp 12,079	Rp 127,509		Rp -	Rp 255,433	Rp 1,601,831
12	5	Galih	FF005	APOTEKER		Rp 2,000,000			Rp -		Rp -				Rp 2,000,000					Rp -	Rp -	Rp 2,000,000
13	6	Hanip Ridho	AFF001	SUPERVISOR		576,455									Rp 576,455							Rp 576,455
14	7	Puput	AFF002	ASSISTEN APOTEKER		400,000									Rp 400,000							Rp 400,000
15	8	Pakde	AFF003	-		2,900,000						57,923			Rp 2,957,923	Rp 115,845						Rp 2,957,923
16	9	Ino	AFF004	-								115,845			Rp 115,845	Rp 115,845						Rp 115,845
17	10	Ali	AFF005			Rp 1,000,000									Rp 1,000,000						Rp 1,000,000	Rp -
18	JUMLAH					Rp 10,026,455	Rp 270,000	Rp 1,150,000	Rp 750,000	Rp 225,000	Rp -	Rp 359,120	Rp 48,316	Rp 210,036	Rp 13,038,927	Rp 463,380	Rp 48,316	Rp 510,036	Rp -	Rp 72,900	Rp 862,942	Rp 11,175,985
19																		Rp 558,352
20	Data Gaji Bulan		:	JUNI 2024
21	Pimpinan		:	M ARIF SETIAWAN
22	Jumlah Karyawan		:	6
23
24	NO	NAMA	NOPEG	JABATAN	TANGGAL MASUK	PENDAPATAN										POTONGAN						GAJI BERSIH
25	NO	NAMA	NOPEG	JABATAN	TANGGAL MASUK	GAJI POKOK	TRANSPORT & MAKAN	INSENTIF	BONUS	LEMBUR	SHIFT MALAM	BPJS Kes	JKK/JKM	JHT	JML PENDAPATAN	BPJS KES	JKK/JKM	JHT	HASIL SO	LAIN-LAIN	JML POTONGAN	GAJI BERSIH
26	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22
27	1	Hanip Ridho	EW001	APOTEKER ENGGAL WARAS		Rp 3,500,000			1,038,004						Rp 4,538,004				Rp -	Rp -	Rp -	Rp 4,538,004
28	2	Puput	EW002	SUPERVISOR ENGGAL WARAS		Rp 1,750,000			605,425	Rp 75,000			Rp 12,079	Rp 27,509	Rp 2,470,013	Rp -	Rp 12,079	Rp 127,509	Rp -	Rp -	Rp 139,588	Rp 2,330,425
29	3	Lutfiana Khusnul H	EW003	SALES	30 Maret 2022	Rp 1,050,000		Rp 250,000	Rp 400,000	Rp 275,000	Rp 275,000	Rp -	Rp 12,079	Rp 27,509	Rp 2,289,588	Rp -	Rp 12,079	Rp 127,509	Rp -	Rp -	Rp 139,588	Rp 2,150,000
30	4	Rani	EW004	SALES & ADMINISTRASI	2 mei 2024	Rp 1,050,000		Rp 400,000	Rp 500,000	Rp 75,000	Rp -	Rp -	Rp 12,079	Rp 27,509	Rp 2,064,588	Rp -	Rp 12,079	Rp 127,509	Rp -	Rp -	Rp 139,588	Rp 1,925,000
31	5	siti mey kharisah	EW005	SALES	16 Agustus 2023	Rp 1,000,000		Rp 250,000	Rp 400,000	Rp 75,000	Rp 212,500	Rp -	Rp 12,079	Rp 27,509	Rp 1,977,088		Rp 12,079	Rp 127,509	Rp -	Rp -	Rp 139,588	Rp 1,837,500
32	6	Icha	EW006	SALES	11 Agustus 2024	Rp 750,000			Rp 250,000	Rp 225,000	Rp 225,000	Rp -			Rp 1,450,000							Rp 1,450,000
33	7	Risa	EW007	SALES	2 Juni 2024										Rp -							Rp -	percobaan
34	JUMLAH					Rp 9,100,000	Rp -	Rp 900,000	Rp 3,193,429	Rp 725,000	Rp 712,500	Rp -	Rp 48,316	Rp 110,036	Rp 14,789,281	Rp -	Rp 48,316	Rp 510,036	Rp -	Rp -	Rp 558,352	Rp 14,230,929
35																		Rp 558,352
36	Data Gaji Bulan		:	JUNI 2024
37	Pimpinan		:	M ARIF SETIAWAN
38	Jumlah Karyawan		:	7
39
40	NO	NAMA	NOPEG	JABATAN	TANGGAL MASUK	PENDAPATAN										POTONGAN						GAJI BERSIH
41	NO	NAMA	NOPEG	JABATAN	TANGGAL MASUK	GAJI POKOK	TRANSPORT & MAKAN	INSENTIF	BONUS	LEMBUR	SHIFT MALAM	BPJS Kes	JKK/JKM	JHT	JML PENDAPATAN	BPJS KES	JKK/JKM	JHT	HASIL SO	LAIN-LAIN	JML POTONGAN	GAJI BERSIH
42	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22
43	1	Edi	P001	APOTEKER PANDAWA	2 Februari 2022	Rp 2,000,000									Rp 2,000,000					Rp -	Rp -	Rp 2,000,000
44	2	Dwi Ayu	P002	SALES & ADMINISTRASI	16 Desember 2020	Rp 1,050,000		Rp 300,000	Rp 350,000	Rp 75,000	Rp 162,500	Rp -	Rp 12,079	Rp 27,509	Rp 1,977,088		Rp 12,079	Rp 127,509		Rp -	Rp 139,588	Rp 1,837,500
45	3	Choir	P003	SUPERVISOR PANDAWA	18 Maret 2016	Rp 1,150,000	Rp 260,000	Rp 250,000	Rp 350,000	Rp 75,000	Rp 150,000	Rp -	Rp 12,079	Rp 27,509	Rp 2,274,588		Rp 12,079	Rp 127,509		Rp -	Rp 139,588	Rp 2,135,000
46	4	Putri	P004	SALES & ADMINISTRASI	26 April 2020	Rp 1,050,000		Rp 300,000	Rp 350,000	Rp 75,000	Rp 212,500	Rp 92,676	Rp 12,079	Rp 27,509	Rp 2,119,764	Rp 115,845	Rp 12,079	Rp 127,509		Rp -	Rp 255,433	Rp 1,864,331
47	5														Rp -					Rp -	Rp -	Rp -
48	6	Hanip Ridho	AP001	SUPERVISOR		Rp 203,513									Rp 203,513							Rp 203,513
49	7	Puput	AP002	ASSISTEN APOTEKER		Rp 400,000									Rp 400,000							Rp 400,000
50	JUMLAH					Rp 5,853,519	Rp 260,007	Rp 850,008	Rp 1,050,009	Rp 225,010	Rp 525,011	Rp 92,688	Rp 36,250	Rp 82,541	Rp 8,974,968	Rp 115,861	Rp 36,254	Rp 382,545	Rp 19	Rp 20	Rp 534,630	Rp 8,440,366
51																		Rp 418,799
52
53	JUMLAH					PENDAPATAN										POTONGAN						GAJI BERSIH
54						GAJI POKOK	TRANSPORT & MAKAN	INSENTIF	BONUS	LEMBUR	SHIFT MALAM	BPJS Kes	JKK/JKM	JHT	JML PENDAPATAN	BPJS KES	JKK/JKM	JHT	HASIL SO	LAIN-LAIN	JML POTONGAN	GAJI BERSIH
55						Rp 24,979,974	Rp 530,007	Rp 2,900,008	Rp 4,993,438	Rp 1,175,010	Rp 1,237,511	Rp 451,808	Rp 132,882	Rp 402,613	Rp 36,803,176	Rp 579,241	Rp 132,886	Rp 1,402,617	Rp 19	Rp 72,920	Rp 1,955,924	Rp 33,847,280
56																		Rp 1,535,503
57
58																		Rp 1,535,503
59																					Rp 1,864,331
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100