Laporan Biaya Internet.xlsx

	B	C	D	E	F	G	I	J	L
1
2	BELAJAR PINTAR EXCEL
3		LAPORAN BIAYA INTERNET
4		BULANAN Februari 2021
5
6	NO	TANGGAL	DESKRIPSI	DEBET	KREDIT	REKENING SALDO	NO	TRANSAKSI BIAYA QUOTA FEB 2021	BIAYA
7	1	1-Feb-21	Sisa Saldo Januari 2021	#REF!			1	Paket SIM LHG INDO	IDR 535.691
8	2	2-Feb-21	Mes Kantor 30GB		IDR 65.000	IDR (65.000)	2	Internet Rumah	IDR 80.000
9	3	3-Feb-21	Paket SIM LHG INDO 100GB		IDR 149.686	IDR (214.686)	3	Kantor ORB	IDR 470.700
10	4	4-Feb-21	GoPay Topup	IDR 500.000		IDR 285.314	4	Bescam TELCO	IDR 348.511
11	5	4-Feb-21	Kantor ORB 100 GB		IDR 130.000	IDR 155.314	5	Mes Kantor	IDR 633.511
12	6	6-Feb-21	Bescam TELCO 12 GB		IDR 108.000	IDR 47.314	Debet		#REF!
13	7	8-Feb-21	Paket SIM LHG INDO 100 GB		IDR 130.000	IDR (82.686)	Kredit		IDR 2.068.413
14	8	10-Feb-21	GoPay Topup	IDR 500.000		IDR 417.314	Sisa Saldo		#REF!
15	9	10-Feb-21	Bescam TELCO 52 GB		IDR 222.000	IDR 195.314
16	10	10-Feb-21	Bescam INDO 50 GB		IDR 100.000	IDR 95.314
17	11	10-Feb-21	Kantor ORB 100 GB		IDR 130.000	IDR (34.686)
18	12	15-Feb-21	Bescam TELCO 52 GB		IDR 203.511	IDR (238.197)
19	13	15-Feb-21	Cashback	IDR 5.000		IDR (233.197)
20	14	18-Feb-21	GoPay Topup	IDR 500.000		IDR 266.803
21	15	18-Feb-21	Paket SIM LHG INDO 100 GB		IDR 130.000	IDR 136.803
22	16	18-Feb-21	Internet Rumah 50GB		IDR 80.000	IDR 56.803
23	17	18-Feb-21	Paket SIM LHG INDO 100 GB		IDR 80.700	IDR (23.897)
24	18	22-Feb-21	Kantor ORB 100 GB		IDR 130.000	IDR (153.897)
25	19	22-Feb-21	Paket SIM LHG INDO		IDR 100.308	IDR (254.205)
26	20	22-Feb-21	Paket SIM LHG INDO 100GB		IDR 25.697	IDR (279.902)
27	21	25-Feb-21	GoPay Topup	IDR 500.000		IDR 220.098
28	22	25-Feb-21	Bescam ORB 50 GB		IDR 80.000	IDR 140.098
29	23	25-Feb-21	Bescam TELCO 50 GB		IDR 203.511	IDR (63.413)
30		28-Feb-21	TOTAL	#REF!	IDR 2.068.413	#REF!
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
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