5. Format Import Daftar Aset Tetap.xls

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	Asset Type	Asset Code	Description	Purchase Date	Usage Date	Year	Month	Depr Method	Assets Account	Accum Deprec Acc	Deprec Exp Acc	Asset Cost	Expenditure Account	Intangible	Fiscal FA	Salvage Value	Notes
2	Gedung Permanen	GD.002	Gedung Lantai 3 di Wisma Sudirman	1/1/2002	1/1/2002	20	0	Straight Line Method	1201.002 Building	1202.002 Accum Deprec Building	6300.101 Deprec Exp of Building	1,000,000,000.00	Opening Balance Equity	No	Yes	0.00
3	Kendaraan 1	KD.004	MOTOR KANZEN (K 8889 EA)	1/1/2002	1/1/2002	4	8	Straight Line Method	1201.004 Vehicle	1202.004 Accum Deprec Vehicle	6300.103 Deprec Exp of Vehicle	10,500,000.00	Opening Balance Equity	No	Yes	0.00
4	Kendaraan 1	KD.002	MOTOR SUZUKI SATRIA (D 35 Y)	9/8/2001	9/15/2001	4	6	Straight Line Method	1201.004 Vehicle	1202.004 Accum Deprec Vehicle	6300.103 Deprec Exp of Vehicle	12,500,000.00	Opening Balance Equity	No	Yes	0.00
5	Kendaraan 1	KD.006	MOTOR HONDA SUPRA (B 5555 ZZ)	8/17/2001	8/21/2001	5	0	Straight Line Method	1201.004 Vehicle	1202.004 Accum Deprec Vehicle	6300.103 Deprec Exp of Vehicle	12,000,000.00	Opening Balance Equity	No	Yes	0.00
6	Gedung Semi Permanen	GD.003	Renovasi Gedung	1/1/2001	1/1/2001	10	0	Straight Line Method	1201.002 Building	1202.002 Accum Deprec Building	6300.101 Deprec Exp of Building	300,000,000.00	Opening Balance Equity	No	Yes	25,000,000.00
7	Intangible Asset 2	GW.001	Goodwill	1/1/2001	1/1/2001	15	0	Straight Line Method	1301.003 Goodwiil	1301.003 Goodwiil	6300.106 Amortization of Goodwill	100,000,000.00	Opening Balance Equity	Yes	Yes	0.00
8	Intangible Asset 2	CR.001	Copy Right & Licency	1/1/2001	1/1/2001	10	0	Straight Line Method	1301.002 Copy Right	1301.002 Copy Right	6300.105 Amortization of Copy Right	15,000,000.00	Opening Balance Equity	Yes	Yes	0.00
9	Kendaraan 2	KD.003	TRUCK COLT DIESEL (B 5566 XX)	1/1/2001	1/1/2001	5	0	Straight Line Method	1201.004 Vehicle	1202.004 Accum Deprec Vehicle	6300.103 Deprec Exp of Vehicle	50,000,000.00	Opening Balance Equity	No	Yes	0.00
10	Peralatan Kantor 1	PK.004	Komputer Marketing	1/1/2001	1/1/2001	5	0	Straight Line Method	1201.003 Equipment	1202.003 Accum Deprec Equipment	6300.102 Deprec Exp of Equipment	15,000,000.00	Opening Balance Equity	No	Yes	0.00
11	Peralatan Kantor 1	PK.003	Komputer Produksi	1/1/2001	1/1/2001	5	0	Straight Line Method	1201.003 Equipment	1202.003 Accum Deprec Equipment	6300.102 Deprec Exp of Equipment	35,000,000.00	Opening Balance Equity	No	Yes	5,000,000.00
12	Peralatan Kantor 1	PK.002	Komputer HRD	1/1/2001	1/1/2001	5	0	Straight Line Method	1201.003 Equipment	1202.003 Accum Deprec Equipment	6300.102 Deprec Exp of Equipment	10,000,000.00	Opening Balance Equity	No	Yes	0.00
13	Peralatan Kantor 1	PK.001	Komputer Accounting	1/1/2001	1/1/2001	5	0	Straight Line Method	1201.003 Equipment	1202.003 Accum Deprec Equipment	6300.102 Deprec Exp of Equipment	25,000,000.00	Opening Balance Equity	No	Yes	5,000,000.00
14	Gedung Permanen	GD.001	Bangunan Gedung (Pejaten)	1/1/2000	1/1/2000	20	0	Straight Line Method	1201.002 Building	1202.002 Accum Deprec Building	6300.101 Deprec Exp of Building	1,000,000,000.00	Opening Balance Equity	No	Yes	0.00
15	Intangible Asset 2	MD.001	Merk Dagang	1/1/2000	1/1/2000	10	0	Straight Line Method	1301.001 Trade Mark	1301.001 Trade Mark	6300.104 Amortization of Trade Mark	25,000,000.00	Opening Balance Equity	Yes	Yes	0.00
16	Kendaraan 2	KD.007	SEDAN VOLVO (D 25 Y)	1/1/2000	1/1/2000	12	0	Straight Line Method	1201.004 Vehicle	1202.004 Accum Deprec Vehicle	6300.103 Deprec Exp of Vehicle	210,000,000.00	Opening Balance Equity	No	Yes	0.00
17	Kendaraan 2	KD.005	TOYOTA KIJANG (B 8856 RS)	1/1/2000	1/1/2000	8	0	Straight Line Method	1201.004 Vehicle	1202.004 Accum Deprec Vehicle	6300.103 Deprec Exp of Vehicle	75,000,000.00	Opening Balance Equity	No	Yes	0.00
18	Kendaraan 2	KD.001	SEDAN BALENO (N 250 BJ)	1/1/2000	1/1/2000	12	0	Straight Line Method	1201.004 Vehicle	1202.004 Accum Deprec Vehicle	6300.103 Deprec Exp of Vehicle	180,000,000.00	Opening Balance Equity	No	Yes	20,000,000.00
19	Tanah	TN.001	TANAH 2 HA (JL. PEJATEN)	1/1/2000	1/1/2000	0	0	Non Depreciable	1201.001 Land			400,000,000.00	Opening Balance Equity	No	Yes	0.00
20
21
22
23
24
25
26
27
28
29
30
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