Pemakaian Termin.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1			DANA SUDAH SESUAI DGN DATA MONITORING
2			DANA DIPAKAI KOMISI MARKETING
3			DANA DIPINJAM CUSTOMER
4			DANA DIPAKAI FINANCE
5	Pemakaian Termin
6	No	Unit yg dipakai	Nominal	Keterangan Pemakaian	Nominal pemakaian	Bank	Tanggal Transfer	Berkas Pengembalian	Tanggal pengembalian	Realisasi pinjaman	Remarks			Yg blm disetor
7	1	3816, 3817, 1510	32,016,202	Dana dipinjam finance untuk bi. Marketing & vendor	28,787,277	BCA	18-Apr-23	731501-99TL2300011,731501-1TL23000205,731501-1TL23000251,731501-1TL23000238,731501-1TL23000257,731501-1TL23000253		Mintakan Dropping	OPEN			3,228,925
8	2			Dana dipinjam finance untuk refund customer roestien unit 3003	10,000,000	BCA	31-May-23	731501-1TL23000103		Mintakan Dropping	OPEN
9	3	2305	57,590,800	Bi. Akad Sudar Baliatin Unit 1809	32,696,300	BCA	16-Jun-23		20 Juni 2023	Buat Sett Off	CLOSE
10	4	2305	57,590,800	Bi. Akad Ferry Eka Yuana Unit 1111	24,894,500	BCA	20-Jun-23		20 Juni 2023	Buat Sett Off	CLOSE
11	5	3920, 1020,3316	51,730,424	Bi. Akad Kevin Yapania Unit 3208	11,924,800	BCA	20-Jun-23		21 Juni 2023	Buat Sett Off	CLOSE	3920	16,730,424
12	6			Bi. Akad Yuzion Sanjaya Unit 1020	21,677,000	BCA	23-Jun-23		06 Juli 2023	Buat Sett Off	CLOSE	3316	30,000,000	4,376,624
13	7			Bi. Akad Shafira Dinar Unit 1721	7,952,000	BCA	23-Jun-23		06 Juli 2023	Buat Sett Off	CLOSE	1020	5,000,000	5,800,000
14	8			Hold dana ferry eka yuana Unit 1111	5,800,000	BCA	1-Jul-23		15 Juli 2023	Dicicil cust	CLOSE
15	9	3802, 3803, 1510	35,139,813	Dipinjam Finance Untuk customer dan Vendor	35,139,813	BCA	23-Jun-23	731501-1TL22000323,731501-1TL21000147 & 731501-1SI2100055,731501-1TL23000222,731501-1TL23000191,731501-1TL23000219		Mintakan Dropping	OPEN
16	10	S0127	100,000,000	Biaya Subsidi Akad Unit 0502 a/n Naomi Lamria	11,955,290	BNI	24-Mar-23		03 April 2023	Buat Sett Off	CLOSE
17	11			Biaya Subsidi Akad Unit 3015 a/n Desy Agustina	12,572,220	BNI	28-Mar-23		03 April 2023	Buat Sett Off	CLOSE
18	12			Biaya Subsidi Akad Unit 3520 a/n Nenny Betadiantini	42,169,619	BNI	29-Mar-23		03 April 2023	Buat Sett Off	CLOSE
19	13			Subsidi UTJ Onni	24,753,823	BNI	29-Mar-23		14 Juli 2023	Buat Sett Off	CLOSE
20	14			Biaya Subsidi Akad Unit 3023 a/n Dyah Ayu	8,302,871	BNI	31-Mar-23		03 April 2023	Buat Sett Off	CLOSE
21	15	GF05	100,000,000	Biaya Subsidi Akad Unit 3023 a/n Dyah Ayu	4,416,329	BNI	31-Mar-23		03 April 2023	Buat Sett Off	CLOSE
22	16			Subsidi Biaya Akad Cahayu Arum Unit 0508	3,476,755	BNI	3-May-23		05 April 2023	Buat Sett Off	CLOSE
23	17			Dipinjam finance biaya material perbaikan HO dan Close Deffect	5,000,000	BNI	4-May-23	731501-1TL23000182		Mintakan Dropping	OPEN
24	18			Spread Termin UTJ 6 unit	30,000,000	BNI	5-May-23			OTS Muter	OPEN
25	19			Subsidi Biaya Akad Po Wahyu Sinatra Posasih Unit 0927	9,365,494	BNI	19-May-23		22 Juni 2023	Buat Sett Off	CLOSE
26				Pinjam hold dana Po Wahyu 0927	2,750,000	BNI	19-May-23		8 Des 2023	2750000	CLOSE
27	20			Subsidi Biaya Akad Yztcher Philip Unit S0203	10,950,029	BNI	23-May-23		23/5/2023	Buat Sett Off	CLOSE
28	21			Subsidi Biaya Akad Nurul Huda Unit 1718	34,041,393	BNI	16-Jun-23		16/6/2023	Buat Sett Off	CLOSE
29	22	Unit 3921 dan 3923	111,000,000	Subsidi Biaya Akad Nurul Huda Unit 1718	1,224,357	BNI	16-Jun-23		16/6/2023	Buat Sett Off	CLOSE
30	23			Subsidi Biaya Akad Liya Yussilawati Unit 1607	9,754,400	BNI	24-Jul-23		16/6/2023	Buat Sett Off	CLOSE
31	24			Subsidi Biaya Akad Catur Suratnoaji Unit 2108	43,404,375	BNI	25-Jul-23		16 Agustus 2023	Buat Sett Off	CLOSE
32	25			Subsidi Biaya Akad Nurhasanah Unit 2021	14,602,750	BNI	27-Jul-23		22 Agustus 2023	Buat Sett Off	CLOSE
33	26			Pinjam Biaya Akad Mohamad Burhana Unit 252	21,304,444	BNI	31-Jul-23	masuk ke 3921	20 Sept, 16 Okt, 21 Nov, 22 Des, 23 Jan, 27 Feb, 21 Mei	21,255,000	CLOSE	49,444	18,950,729
34	27	Unit 3923 dan 3921	27,250,000	Subsidi Biaya Akad Novi Dwi Reva Yanti Unit S0623	23,121,500	BNI	11-Agus-23		16 Agustus 2023	Buat Sett Off	CLOSE	-4,255,000	4,128,500
35	28	0518	245,000,000	Pinjam Biaya Asuransi H. Iwan 0501	62,199,790	BCA	26-Sept-23		20 Okt, 27 Nov, 25 Des, 23 Jan, 26 Feb, 22 Mar, 29 April, 29 Mei, 23 Juni, 14 Agust	62,199,790	CLOSE
36	29			Subsidi Biaya KPA Nandha 0503	10,148,531	BCA	29-Sept-23		05 Oktober 2023	Buat Sett Off	CLOSE
37	30			Pinjam hold dana Nandha 0503	3,876,289	BCA	29-Sept-23		29 Okt, 1 Des, 30 Maret	3,876,289	CLOSE
38	31			Dipinjam finance utk biaya Markom	38,000,000	BCA	02-Okt-23		5 Des 2023	Kas kecil	CLOSE
39	32	3907	23,125,000	Subsidi biaya akad H. Iwan 0501	19,097,500	BNI	26-Sept-23		05 Oktober 2023	Buat Sett Off	CLOSE
40	33	1029	200,000,000	Dipinjam finance pembayaran sewa mobil dan printer	24,941,750	BCA	10-Okt-23		28 Des 2023	Mintakan Dropping	CLOSE	melalui rek kawasan
41	34			Dipinjam finance utk gimmick WH	7,500,000	BCA	13-Okt-23		28 Des 2023	Mintakan Dropping	CLOSE	melalui rek kawasan
42				Dipinjam BM utk HO unit	5,000,000	BCA	24-Okt-23		28 Des 2023	Mintakan Dropping	CLOSE	melalui rek kawasan
43	35	BEBERAPA UNIT	83,741,948	Subsidi Biaya Akad Novitasari Unit 2016	83,741,948	BCA	18-Okt-23		05 Oktober 2023	Buat Sett Off	CLOSE
44	36	3527	11,500,000	Subsidi Biaya Akad Eileen Unit 1620	13,814,350	BNI	2-Nov-23		3 Nov 2023	Buat Sett Off	CLOSE
45	37	3203	7,361,889	Pinjam hold dana Eileen Unit 1620	4,473,969	BNI	2-Nov-23		2 Nov 2023	Dicicil cust	CLOSE
46	38	910	200,000,000	Subsidi biaya akad Novitasari Unit 0807	46,353,660	BNI	30-Nov-23		5 Des 2023	Buat Sett Off	CLOSE
47	39	1709 dan 3317	10.000.000 dan 25.000.000	Dipinjam finance utk biaya Markom	35,000,000	BCA	30-Nov-23		26 Jan 2024	Mintakan Dropping	CLOSE
48	40	1628	22,287,796	Dipinjam finance utk komisi marketing	20,000,000	BCA	1-Dec-23		29 Des 2023	Mintakan Dropping	CLOSE
49	41	2126	15,900,000	Subsidi Bi. KPA Tommy Unit S227	15,270,000	BNI	11-Dec-23		5 Des 2023	Buat Sett Off	CLOSE
50	42	3220	100,157,403	Gimmick sewa 1 bulan unit 3517	3,500,000	BCA	8-Mar-24		20 Maret 2024	Buat Sett Off	CLOSE
51	43			Subsidi Biaya Akad Danita Unit 3217	9,852,087	BCA	18-Mar-24		20 Maret 2024	Buat Sett Off	CLOSE
52	44			Subsidi Biaya Akad Rakhmat Unit S803	11,989,363	BCA	19-Mar-24		20 Maret 2024	Buat Sett Off	CLOSE
53	45			Pinjam hold dana Rakhmat Unit S803	2,407,507	BCA	19-Mar-24		4 Mei 2024, 19 Juni	2,407,506	CLOSE
54	56	2117	10,625,000	Subsidi Biaya Notaris Ach Witono Unit S507	1,000,000	BCA	26-Mar-24			Buat Sett Off	CLOSE
55	57	3030	11,500,002	Subsidi Biaya Notaris Rosy Unit S217	10,319,848	BCA	28-Mar-24			Buat Sett Off	CLOSE
56	58	3527	11,500,000	Gimmick 1AC 1PK dan 2AC 1/2 PK Rahardian Unit 0516	11,500,000	BNI	4-Apr-24			Buat Sett Off	CLOSE
57	59	3921, 3923, 3218	33,250,000	Dipinjam finance utk gimmick furnish Hastuti 0816	33,250,000	BNI	5-Apr-24			Buat Sett Off	CLOSE
58	60	3702, 3610, 1820	28,500,000	Subsidi Biaya KPA Riana Unit S103	23,728,988	BCA	19-Apr-24			Buat Sett Off	CLOSE
59	61	3907	23,125,000	Subsidi Biaya KPA Wiwien Unit 0521	10,963,850	BNI	29-Apr-24			Buat Sett Off	CLOSE
60	62	3921	13,500,000	Subsidi Biaya Notaris Mohamad Burhana Unit 2528	1,758,945	BNI	31-Jul-23		31 Juni 2024	Buat Sett Off	CLOSE
61	63	S603	15,000,000	Pinjam dana utk OTS S603	6,000,000	BCA	23-May-24			Buat Sett Off	CLOSE
62	64	930	15,000,000	Pinjam dana utk OTS 930 dan S120	12,000,000	BCA	24-May-24			Buat Sett Off	CLOSE
63	65
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