PJ AHS 2021-2025.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X
1
2	Faktur						K N			Pembayaran									FOLLOW UP
3	Nomor	Tanggal	Pelanggan	L	Nilai Faktur	Nilai Sebelum Revisi	Tanggal	Nomor	Jumlah	TGL. KB	Tanggal	Cash	Giro	Jumlah	Sisa Faktur	KB / LB	Keterangan	PO	TOP	UMUR	AKAN JT	SUDAH JT	REMINDER	FOLLOW UP

4	0567	26-Agu-20	GSA		3.600.000					17346,04/09	5 Feb 2021		DNM 103261 16/02	3.600.000	-		LUNAS			2073
5	0578	28-Agu-20	GSA		8.120.000					17346,04/09	5 Feb 2021		DNM 103261 16/02	8.120.000	-		LUNAS			2071
6	0608	09-Sep-20	GSA		12.088.000	20.733.000				17382,18/09	20 Jan 2021		DNM 029514,029508 9 &2/2	12.088.000	-		LUNAS			2059
7	0617	11-Sep-20	GSA		685.000					17382,18/09	20 Jan 2021		DNM 029514,029508 9 &2/2	685.000	-		LUNAS			2057
8	0623	11-Sep-20	GSA		12.230.000					17382,18/09	20 Jan 2021		DNM 029514,029508 9 &2/2	12.230.000	-		LUNAS			2057
9	0651	23-Sep-20	GSA		16.229.000					17411,02/10	31 Mar 2021		DNM 182974 & 182975	16.229.000	-		LUNAS			2045
10	0662	24-Sep-20	GSA		6.630.000					17411,02/10	31 Mar 2021		DNM 182974 & 182975	6.630.000	-		LUNAS			2044
11	0674	26-Sep-20	GUCCITEX		400.000					77,14/10	13-Jan		TUNAI	400.000	-		LUNAS			2042
12	0692	01-Okt-20	GUCCITEX		6.300.000					77,14/10	13-Jan		TUNAI	6.300.000	-		LUNAS			2037
13	0703	06-Okt-20	GSA		3.600.000					17427,09/10	5 Mar 2021		DNM 103273 30/3	3.600.000	-		LUNAS			2032
14	0706	06-Okt-20	GSA		5.760.500					17445,16/10	5 Mar 2021		DNM 103270 16/3	5.760.500	-		LUNAS			2032
15	0735	15-Okt-20	GSA		2.390.000					17460,23/10	5 Mar 2021		DNM 103274 9/3	2.390.000	-		LUNAS			2023
16	0737	16-Okt-20	IBU. IRMA FAJARWATI		3.600						18/10		TOKPED RIM	3.600	-		LUNAS			2022
17	0761	23-Okt-20	GSA		2.464.000					17472,30/10	5 Mar 2021		DNM 103272 23/3	2.464.000	-		LUNAS			2015
18	0825	12-Nov-20	IBU. DWI		514.800						12/11/20		TRF BCA	514.800	-		LUNAS			1995
19	0841	16-Nov-20	MOSSAD OBAJA		72.300						14/11/20		TOKPED RIM	72.600	-	-300	LUNAS			1991
20	0849	17-Nov-20	MURNI KONTRUKSI		5.900.000					TT,27/11	7 Jan 2021		TRF BCA	5.900.000	-		LUNAS			1990
21	0867	21-Nov-20	BP. DAVID		3.304.750					TT,01/12	7 Jan 2021		TRF BCA	3.304.750	-		LUNAS			1986
22	0868	21-Nov-20	BP. DAVID		210.000					TT,01/12	7 Jan 2021		TRF BCA	210.000	-		LUNAS			1986
23	0871	23-Nov-20	GSA		5.588.000					17528,27/11	5 Mar 2021		DNM 103262 23/3	5.588.000	-		LUNAS			1984
24	0874	23-Nov-20	BP. GALUNG		4.345.000					TT,11/12	06-Jan		FAMA 691180 06/02	4.345.000	-		LUNAS			1984
25	0875	24-Nov-20	BP. GALUNG		1.975.000					TT,11/12	06-Jan		FAMA 691180 06/02	1.975.000	-		LUNAS			1983
26	0883	26-Nov-20	MURNI KONTRUKSI		720.000					TT,04/12	7 Jan 2021		TRF BCA	720.000	-		LUNAS			1981
27	0888	30-Nov-20	NOVATEX		4.370.950					684,10/12	07-Jan		TUNAI	4.370.950	-		LUNAS			1977
28	0889	01-Des-20	NOVATEX		5.818.750					684,10/12	07-Jan		TUNAI	5.818.750	-		LUNAS			1976
29	0892	02-Des-20	GINATEX		237.500					24,11/01	1 Feb 2021		TUNAI	237.500	-		LUNAS			1975
30	0893	02-Des-20	MULIA. TK		1.600.000						06-Jan		TUNAI	1.600.000	-		LUNAS			1975
31	0894	02-Des-20	MULYA ASIH		350.000	350.000					08-Jan		TUNAI	350.000	-		LUNAS			1975
32	0896	03-Des-20	MITRA ALAM		253.000					TT,18/12	23-Jan		TUNAI	253.000	-		LUNAS		30	1974
33	0898	03-Des-20	TOKOPEDIA		46.800						5/12/20		TOKPED RIM	46.800	-		LUNAS			1974
34	0899	03-Des-20	INDOKARYA T		869.560					TT,11/12	08-Jan		DNM 872937 22/1	869.560	-		LUNAS			1974
35	0900	04-Des-20	INDOKARYA T		1.173.250					TT,11/12	08-Jan		DNM 872937 22/1	1.173.250	-		LUNAS			1973
36	0903	04-Des-20	CITABAHANA		22.926.500					11,17/12	12Mar2021		TUNAI	22.926.500	-		LUNAS			1973
37	0906	05-Des-20	MITRA ALAM		37.000					TT,18/12	23-Jan		TUNAI	37.000	-		LUNAS		30	1972
38	0908	05-Des-20	MITRA ALAM		128.000					TT,18/12	23-Jan		TUNAI	128.000	-		LUNAS		30	1972
39	0909	07-Des-20	TOKOPEDIA		565.200						10/12/20		TOKPED RIM	565.200	-		LUNAS			1970
40	0911	08-Des-20	NOVATEX		8.527.200					695,17/12	07-Jan		TUNAI	8.527.300	-	-100	LUNAS			1969
41	0913	08-Des-20	GSA		4.320.000					17579,18/12	5 Mar 2021		DNM 103269 30/3	4.320.000	-		LUNAS			1969
42	0914	08-Des-20	BISMA. TB		3.298.000					TT,15/12	08-Jan		BCA 145915 13/1	3.298.000	-		LUNAS			1969
43	0916	08-Des-20	BISMA. TB		439.850					TT,15/12	08-Jan		BCA 145915 13/1	440.000	-	-150	LUNAS			1969
44	0917	10-Des-20	MENTARI. PD		10.500.000					0003,18/12	22 Jan 2021		TRF BCA	10.500.000	-		LUNAS			1967
45	0920	10-Des-20	INDOKARYA T		517.750					TT,18/12	08-Jan		DNM 872937 22/1	517.750	-		LUNAS			1967
46	0921	11-Des-20	PLANEET. CV		2.554.200					TT,19/12	23-Jan		TUNAI	2.554.400	-	-200	LUNAS			1966
47	0924	11-Des-20	GINATEX		1.250.000					24,11/01	1 Feb 2021		TUNAI	1.250.000	-		LUNAS			1966
48	0925	11-Des-20	BISMA. TB		906.000						15-Jan		TUNAI	906.000	-		LUNAS			1966
49	0927	11-Des-20	CITABAHANA		5.575.000					11,17/12	12Mar2021		TUNAI	5.575.000	-		LUNAS			1966
50	0928	11-Des-20	CITABAHANA		12.720.000					11,17/12	12Mar2021		TUNAI	12.720.000	-		LUNAS			1966
51	0929	12-Des-20	BP. HENDRI		150.000						26 Jan 2021		TUNAI	150.000	-		LUNAS			1965
52	0930	12-Des-20	BP. HENDRI		807.500						26 Jan 2021		TUNAI	807.500	-		LUNAS			1965
53	0933	12-Des-20	DWI TUNGGAL JAYA		2.497.150						4 Jan 2021		TRF BCA	2.497.150	-		LUNAS			1965
54	0934	12-Des-20	GINATEX		225.000					24,11/01	1 Feb 2021		TUNAI	225.000	-		LUNAS			1965
55	0935	14-Des-20	GINATEX		15.000					24,11/01	1 Feb 2021		TUNAI	15.000	-		LUNAS			1963
56	0936	14-Des-20	DWI TUNGGAL JAYA		167.200						4 Jan 2021		TRF BCA	167.200	-		LUNAS			1963
57	0939	15-Des-20	BP. HENDRI		110.000						26 Jan 2021		BCA 310567 25/1	110.000	-		LUNAS			1962
58	0940	15-Des-20	BP. DENI SUPRATMAN		194.000						15-Des		TRF BCA	194.000	-		LUNAS			1962
59	0941	15-Des-20	INDOKARYA T		1.425.000						22-Jan		DNM 872940 5/2	1.425.000	-		LUNAS			1962
60	0942	16-Des-20	PLANEET. CV		796.400					TT,19/12	23-Jan		TUNAI	796.400	-		LUNAS			1961
61	0943	16-Des-20	PLANEET. CV		93.000					TT,19/12	23-Jan		TUNAI	93.000	-		LUNAS			1961
62	0944	16-Des-20	DWI TUNGGAL JAYA		6.239.200						4 Jan 2021		TRF BCA	6.239.200	-		LUNAS			1961
63	0945	16-Des-20	BYSMA		2.371.500						18/1		PANIN 275245 18/1	2.371.500	-		LUNAS			1961
64	0946	16-Des-20	TOKOPEDIA		19.500						16/12/20		TOKPED RIM	19.500	-		LUNAS			1961
65	0948	16-Des-20	DWI TUNGGAL JAYA		99.000						4 Jan 2021		TRF BCA	99.000	-		LUNAS			1961
66	0949	16-Des-20	INDOKARYA T		459.000						22-Jan		DNM 872940 5/2	459.000	-		LUNAS			1961
67	0950	17-Des-20	MENTARI. PD		348.000						22-Jan		TUNAI	348.000	-		LUNAS			1960
68	0951	17-Des-20	BINTANG AGUNG. TK		5.621.400						21 Jan 2021		TRF BCA	5.621.400	-		LUNAS			1960
69	0953	18-Des-20	DWI TUNGGAL JAYA		66.000						4 Jan 2021		TRF BCA	66.000	-		LUNAS			1959
70	0954	19-Des-20	IBU. WATI		2.310.000						27 Jan 2021		OCBC 304815 28/1	2.310.000	-		LUNAS			1958
71	0955	19-Des-20	BINTANG AGUNG. TK		1.710.000						21 Jan 2021		TRF BCA	1.710.000	-		LUNAS			1958
72	0956	21-Des-20	CITABAHANA		3.400.000					8.14/01	12Mar2021		TUNAI	3.400.000	-		LUNAS			1956
73	0957	21-Des-20	MITRA ALAM		390.000	590.000					19-Jan		TUNAI	390.000	-		LUNAS		30	1956
74	0958	21-Des-20	MITRA ALAM		80.000						19-Jan		TUNAI	80.000	-		LUNAS		30	1956
75	0959	21-Des-21	CEMARA AGUNG		2.141.100						21-Jan		OCBC 605569 10/2	2.141.000	-	100	LUNAS			1591
76	0960	21-Des-20	TOKOPEDIA		1.200.000						21/12/20		TOKPED RIM	1.200.000	-		LUNAS			1956
77	0961	22-Des-20	CITABAHANA		1.700.000					8.14/01	12Mar2021		TUNAI	1.700.000	-		LUNAS			1955
78	0962	22-Des-20	PARAHYANGAN. TB		535.325						27/1		TUNAI	535.000	-	325	LUNAS			1955
79	0965	23-Des-20	GSA		3.660.000					17612,08/01	16 Apr 2021		DNM 182960 28/4	3.660.000	-		LUNAS			1954
80	0966	23-Des-20	GSA		104.000					17612,08/01	16 Apr 2021		DNM 182960 28/4	104.000	-		LUNAS			1954
81	0967	23-Des-20	CASH, BP. YELLO BRAHMATYO		61.500						31/12/20		TOKPED RIM	61.500	-		LUNAS			1954
82	0968	24-Des-20	BISMA. TB		1.472.500						26 Jan 2021		PANIN 690225 27/1	1.472.500	-		LUNAS			1953
83	0969	24-Des-21	GINATEX		7.000.000					24,11/01	1 Feb 2021		TUNAI	7.000.000	-		LUNAS			1588
84	0970	24-Des-20	BP. HENDRI		5.787.000						26 Jan 2021		BCA 310567 25/1	5.787.000	-		LUNAS			1953
85	0971	24-Des-20	MITRA ALAM		155.000						19-Jan		TUNAI	155.000	-		LUNAS		30	1953
86	0972	24-Des-20	IBU. WATI		15.932.500					16942,13/01	3 Feb 2021		OCBC 304818 15/2	15.932.000	-	500	LUNAS			1953
87	0973	24-Des-20	SINAR HARAPAN. TK		3.325.000						19-Jan		DNM 868301 9/2	3.325.000	-		LUNAS			1953
88	0974	24-Des-20	GSA		4.352.000					17612,08/01	16 Apr 2021		DNM 182960 28/4	4.352.000	-		LUNAS			1953
89	0975	28-Des-20	GSA		5.020.000					17612,08/01	16 Apr 2021		DNM 182960 28/4	5.020.000	-		LUNAS			1949
90	0976	29-Des-20	CITABAHANA		2.105.800					8.14/01	12Mar2021		TUNAI	2.105.800	-		LUNAS			1948
91	0977	28-Des-20	MITRA ALAM		4.500						06-Jan		TUNAI	4.500	-		LUNAS		30	1949
92	0978	30-Des-20	BP. NAJRUDIN		866.800						29-Des		TRF BCA	866.800	-		LUNAS			1947
93	0979	30-Des-20	MITRA ALAM		554.000					TT,15/01	19-Jan		TUNAI	554.000	-		LUNAS		30	1947
94	0001	04-Jan-21	BP. ARIF		8.250.000					19113,12/01	3-Feb		TRF BCA	8.250.000	-		LUNAS			1942
95	0002	04-Jan-21	JAMIKA. TB		17.100.000						18-Jan		DNM 186139 18/1	17.100.000	-		LUNAS			1942
96	0003	04-Jan-21	IBU. NETTY		933.300						5-Jan		TRF BCA	933.300	-		LUNAS			1942
97	0004	04-Jan-21	BATAL, GINATEX(KN06080,BPF 14/01/21)		-										-		LUNAS			1942
98	0005	05-Jan-21	DWI TUNGGAL		1.425.800					TT,14/01	1-Feb		TRF BCA	1.425.800	-		LUNAS			1941
99	0006	05-Jan-21	IBU. WATI		2.520.000					16942,13/01	3 Feb 2021		OCBC 304818 15/2	2.520.000	-		LUNAS			1941
100	0007	05-Jan-21	BISMA. TB		73.800	6.323.800				TT,19/01	5-Feb		PANIN 690238 15/2	73.800	-		LUNAS			1941