Montoring Tagihan PLNT UIP3 KAL.xlsx

	B	C	D	E	F	G	H	I	J	K	L	M
1
2	Kalimantan 1
3	Bulan	Jenis Kontrak	Nilai Invoice	Jumlah Tagihan	Submit ke UPT	Submit ke UIP3B	Persetujuan UIP3B	Faktur Pajak	VIP Disetujui
5	2024-01	GP UPT PONTIANAK	936.383.511	1	1	1	1	1	1		936.383.510
6		OPHARGI UPT PONTIANAK	1.248.291.097	3	3	3	3	3	3		1.248.291.094
7	2024-02	GP UPT PONTIANAK	914.862.031	1	1	1	1	1	1			914.862.030
8		OPHARGI UPT PONTIANAK	1.336.548.934	3	3	3	3	3	3		1.336.548.931
9	2024-03	GP UPT PONTIANAK	923.761.793	1	1	1	1	1	1			923.761.792
10		OPHARGI UPT PONTIANAK	1.335.581.836	3	3	3	3	3	3		1.335.581.833
11	2024-04	GP UPT PONTIANAK	934.074.714	1	1	1	1	1	1			934.074.713
12		OPHARGI UPT PONTIANAK	1.108.355.628	3	3	3	3	3	3			1.108.355.625
13	2024-05	GP UPT PONTIANAK	930.609.821	1	1	1	1	1	1			930.609.820
14		OPHARGI UPT PONTIANAK	1.108.355.628	3	3	3	3	3	3			1.108.355.625
15	2024-06	GP UPT PONTIANAK	886.684.503	1	1	1	1	1	1			886.684.502
16		OPHARGI UPT PONTIANAK	1.108.355.628	3	2	1	0	0	0			1.108.355.625
17	2024-07	OPHARGI UPT PONTIANAK	886684503	1	0	1	0	0	0		4.856.805.368
18	Grand Total		13.658.549.627	25	23	23	21	21	21
19	Kalimantan 2
20	Bulan	Kontrak	Nilai Invoice	Denda	Jumlah Tagihan	Submit ke UPT	Submit ke UIP3B	Persetujuan UIP3B	Faktur Pajak	VIP Disetujui
22	2024-01	GP UPT BANJARBARU & UPT PALANGKARAYA	2.346.915.711	0	1	0	1	0	0	0		2.346.915.711
23		OPHARGI UPT BANJARBARU & UPT PALANGKARAYA	1.712.734.069	0	3	2	3	2	2	1	1.712.734.069
24	2024-02	GP UPT BANJARBARU & UPT PALANGKARAYA	3.938.161.327	0	2	0	2	0	0	0		3.938.161.327
25		OPHARGI UPT BANJARBARU & UPT PALANGKARAYA	1.790.119.865	0	3	2	3	1	1	1	1.790.119.865
26	2024-03	GP UPT BANJARBARU & UPT PALANGKARAYA	3.493.011.758	0	2	0	2	0	0	0		3.493.011.758
27		OPHARGI UPT BANJARBARU & UPT PALANGKARAYA	1.829.344.019	0	3	1	3	1	1	1	1.829.344.019
28	2024-04	GP UPT BANJARBARU	1.024.255.923	0	2	0	1	0	0	0		1.024.255.923
29		GP UPT PALANGKARAYA	1.290.699.804	0	2	0	1	0	0	0		1.290.699.804
30		OPHARGI UPT BANJARBARU	1.016.767.547	0	3	0	3	0	0	0		1.016.767.547
31		OPHARGI UPT PALANGKARAYA	791.400.115	0	3	0	3	0	0	0		791.400.115
32	2024-05	GP UPT BANJARBARU	0	0	1	0	0	0	0	0		0
33		GP UPT PALANGKARAYA	749.537.028	0	2	0	1	0	0	0		749.537.028
34		OPHARGI UPT BANJARBARU	827.687.744	14.655.490	3	0	2	0	0	0		813.032.254
35		OPHARGI UPT PALANGKARAYA	658.636.611	0	3	0	2	0	0	0		658.636.611
36	Grand Total		21.469.271.521	14.655.490	33	5	27	4	4	3	5.332.197.953
37
38	Kalimantan 3
39	Bulan	Kontrak	Nilai Invoice	Denda	Jumlah Tagihan	Submit ke UPT	Submit ke UIP3B	Persetujuan UIP3B	Faktur Pajak	VIP Disetujui
41	2024-01	GP UPT BALIKPAPAN	1.658.543.744	61.125.690	2	2	2	1	2	2	1.597.418.054
42		OPHARGI UPT BALIKPAPAN	2.001.632.979	0	3	2	3	2	3	3	2.001.632.979
43	2024-02	GP UPT BALIKPAPAN	1.749.699.406	64.485.236	2	2	2	1	2	1		1.685.214.170
44		OPHARGI UPT BALIKPAPAN	2.048.545.964	0	3	2	3	1	3	3	2.048.545.964
45	2024-03	GP UPT BALIKPAPAN	1.603.356.736	42.118.968	2	2	2	0	1	1		1.561.237.768
46		OPHARGI UPT BALIKPAPAN	2.091.902.987	0	3	2	3	1	3	3	2.091.902.987
47	2024-04	GP UPT BALIKPAPAN	1.594.009.348	58.747.274	2	2	2	0	1	1
48		OPHARGI UPT BALIKPAPAN	2.042.441.444	0	3	2	3	1	3	3
49	2024-05	GP UPT BALIKPAPAN	1.555.760.829	0	2	1	1	0	1	1		1.555.760.829
50		OPHARGI UPT BALIKPAPAN	2.087.120.902	0	3	2	3	1	3	3
51	2024-06	GP UPT BALIKPAPAN	1.574.102.046	0	2	1	1	0	0	0		1.574.102.046
52		OPHARGI UPT BALIKPAPAN	2.179.718.765	0	3	2	3	0	1	1
53	2024-07	GP UPT BALIKPAPAN	787.051.023	0	1	0	0	0	0	0	7.739.499.984
54		OPHARGI UPT BALIKPAPAN	2.278.770.751	0	3	0	1	0	1	1
55	Grand Total		25.252.656.924	226.477.168	34	22	29	8	24	23
56			23.143.007.047								17.928.503.305	30.413.792.623
57
58
59
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
101
102
103