mutasi_supplier (1).xlsx

	A	B	C	D	E
1	Mutasi Pengeluaran Belanja Supplier
2
3	Saldo Awal	20,000,000
4
5	Catatan: klik ikon kalender untuk pilih TGL, isi KETERANGAN, lalu isi UANG MASUK atau UANG KELUAR sesuai transaksi. Kolom SISA SALDO terisi otomatis.
6
7	TGL	Keterangan	Uang Masuk	Uang Keluar	Sisa Saldo

8		Andy sugianto		2,250,000	17,750,000
9		PT gobic alca nessa		4,356,000	13,394,000
10		Sentra boris		2,900,000	10,494,000
11		Piutang caca		1,000,000	9,494,000
12		Then ngiang djung		3,025,000	6,469,000
13		Sentra boris		1,450,000	5,019,000
14		Tf a rizki	10,000,000		15,019,000
15		Andy sugiant		6,030,000	8,989,000
16		Nadzar celica		500,000	8,489,000
17		Sentra boris		2,705,000	5,784,000
18		Andy sugianto p		5,215,000	569,000
19		Top up a rizki	20,000,000		20,569,000
20		Wifi kantor		250,000	20,319,000
21		Sentra boris		10,300,000	10,019,000
22		Purnama auto		4,350,000	5,669,000
23		Gobic alca		4,256,000	1,413,000
24		A rendi		100,000	1,313,000
25		Lupa	20,000,000	578,000	20,735,000
26		Andy sugianto		6,745,000	13,990,000
27		Sentra boris		1,450,000	12,540,000
28		Gobic alca nesa		2,964,000	9,576,000
29		Yuliana		2,505,000	7,071,000
30		Sentra boris		2,650,000	4,421,000
31		Andy sugianto	4,000,000	6,555,000	1,866,000
32		Kebun		352,000	1,514,000
33		Top up	10,000,000		11,514,000
34		Sentra brosis		6,700,000	4,814,000
35		Top up gaji	20,000,000		24,814,000
36		Gaji nia		600,000	24,214,000
37		Gaji fitri		200,000	24,014,000
38		Pa nanag kebon ( 1 oct )		200,000	23,814,000
39		Pa nanang kebon (gajian 29 sep)		353,000	23,461,000
40		Top up aa	10,000,000		33,461,000
41		Then nging jung		2,400,000	31,061,000
42		Gobic alca nessa		4,256,000	26,805,000
43		Andy sugianto p		6,030,000	20,775,000
44		Sentra brosis		2,730,000	18,045,000
45		Gaji		17,437,928	607,072
46		Top up	7,000,000		7,607,072
47		Then ngiang jung		6,030,000	1,577,072
48		Kebon		561000
49		TOTAL	101,000,000	119,983,928	1,577,072
50
51	Keterangan warna:
52	Kuning = isi Saldo Awal. Kolom TGL (pakai kalender), Keterangan, Uang Masuk, Uang Keluar diisi manual. Sisa Saldo otomatis.
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