4. Format Import Daftar Barang.xls

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z
1	Category	Parent	ITEM NO.	ITEM DESCRIPTION	QTY	UNIT	TOTAL COST	WAREHOUSE	AS OF	ITEM TYPE	SALES PRICE 1	SALES TAX	PURCHASE TAX	INVENTORY ACC	SALES ACC	SALES RETURN ACC	SALES DISCOUNT ACC	GOODS IN TRANSIT ACC	COGS ACC	PURCHASE RETURN ACC	UNBILLED GOODS	Manage SN	Force SN	Deliver No Stock SN	Serial Number Type	Manage Expired Date

2	Air Conditioner		AC	Air Conditioner				Electronic		Inventory Part				1105-003 Persediaan Elektronik	4101-003 Penjualan Elektronik	4201-003 Retur Penjualan Elektronic	4301-003 Diskon Penjualan Elektronic	1115-999 Goods In Transit	5100-003 HPP Electronic	1105-003 Persediaan Elektronik	2106 Unbilled Goods	No	No	No		No
3	Air Conditioner	AC	AC-Sharp	AC Sharp AH-AP9JML	2	set	6,700,000	Electronic	30/06/2013	Inventory Part	3,700,000	T	T	1105-003 Persediaan Elektronik	4101-003 Penjualan Elektronik	4201-003 Retur Penjualan Elektronic	4301-003 Diskon Penjualan Elektronic	1115-999 Goods In Transit	5100-003 HPP Electronic	1105-003 Persediaan Elektronik	2106 Unbilled Goods	No	No	No		No
4	Pompa Air		PA	Pompa Air				Electronic	30/06/2013	Inventory Part				1105-003 Persediaan Elektronik	4101-003 Penjualan Elektronik	4201-003 Retur Penjualan Elektronic	4301-003 Diskon Penjualan Elektronic	1115-999 Goods In Transit	5100-003 HPP Electronic	1105-003 Persediaan Elektronik	2106 Unbilled Goods	No	No	No		No
5	Pompa Air	PA	PA-Pan	Pompa Air Panasonic	2	set	1,390,000	Electronic	30/06/2013	Inventory Part	1,050,000	T	T	1105-003 Persediaan Elektronik	4101-003 Penjualan Elektronik	4201-003 Retur Penjualan Elektronic	4301-003 Diskon Penjualan Elektronic	1115-999 Goods In Transit	5100-003 HPP Electronic	1105-003 Persediaan Elektronik	2106 Unbilled Goods	No	No	No		No
6	Pompa Air	PA	PA-Sanyo	Pompa Air Sanyo	2	set	1,476,000	Electronic	30/06/2013	Inventory Part	1,150,000	T	T	1105-003 Persediaan Elektronik	4101-003 Penjualan Elektronik	4201-003 Retur Penjualan Elektronic	4301-003 Diskon Penjualan Elektronic	1115-999 Goods In Transit	5100-003 HPP Electronic	1105-003 Persediaan Elektronik	2106 Unbilled Goods	No	No	No		No
7	Mesin Cuci		MC	Mesin Cuci				Electronic	30/06/2013	Inventory Part				1105-003 Persediaan Elektronik	4101-003 Penjualan Elektronik	4201-003 Retur Penjualan Elektronic	4301-003 Diskon Penjualan Elektronic	1115-999 Goods In Transit	5100-003 HPP Electronic	1105-003 Persediaan Elektronik	2106 Unbilled Goods	No	No	No		No
8	Mesin Cuci	MC	MC-Sharp	Mesin Cuci Sharp	2	set	4,740,000	Electronic	30/06/2013	Inventory Part	2,670,000	T	T	1105-003 Persediaan Elektronik	4101-003 Penjualan Elektronik	4201-003 Retur Penjualan Elektronic	4301-003 Diskon Penjualan Elektronic	1115-999 Goods In Transit	5100-003 HPP Electronic	1105-003 Persediaan Elektronik	2106 Unbilled Goods	No	No	No		No
9	Mesin Cuci	MC	MC- Tosh	Mesin Cuci Toshiba	2	set	3,920,000	Electronic	30/06/2013	Inventory Part	2,330,000	T	T	1105-003 Persediaan Elektronik	4101-003 Penjualan Elektronik	4201-003 Retur Penjualan Elektronic	4301-003 Diskon Penjualan Elektronic	1115-999 Goods In Transit	5100-003 HPP Electronic	1105-003 Persediaan Elektronik	2106 Unbilled Goods	No	No	No		No
10	Spring Bed		SB	Spring Bed				Furniture	30/06/2013	Inventory Part		T	T	1105-004 Persediaan Furniture	4101-004 Penjualan Furniture	4201-004 Retur Penjualan Furniture	4301-004 Diskon Penjualan Furniture	1115-999 Goods In Transit	5100-004 HPP Furniture	1105-004 Persediaan Furniture	2106 Unbilled Goods	No	No	No		No
11	Spring Bed	SB	SB-P Cel	SB Point - Celebrity	1	set	4,543,000	Furniture	30/06/2013	Inventory Part	4,815,000	T	T	1105-004 Persediaan Furniture	4101-004 Penjualan Furniture	4201-004 Retur Penjualan Furniture	4301-004 Diskon Penjualan Furniture	1115-999 Goods In Transit	5100-004 HPP Furniture	1105-004 Persediaan Furniture	2106 Unbilled Goods	No	No	No		No
12	Spring Bed	SB	SB-P Del	SB Point - Deluxe	1	set	1,952,000	Furniture	30/06/2013	Inventory Part	2,350,000	T	T	1105-004 Persediaan Furniture	4101-004 Penjualan Furniture	4201-004 Retur Penjualan Furniture	4301-004 Diskon Penjualan Furniture	1115-999 Goods In Transit	5100-004 HPP Furniture	1105-004 Persediaan Furniture	2106 Unbilled Goods	No	No	No		No
13	Spring Bed	SB	SB-P Std	SB Point - Standard	1	set	1,610,000	Furniture	30/06/2013	Inventory Part	2,000,000	T	T	1105-004 Persediaan Furniture	4101-004 Penjualan Furniture	4201-004 Retur Penjualan Furniture	4301-004 Diskon Penjualan Furniture	1115-999 Goods In Transit	5100-004 HPP Furniture	1105-004 Persediaan Furniture	2106 Unbilled Goods	No	No	No		No
14	Lemari		L	Lemari				Furniture	30/06/2013	Inventory Part		T	T	1105-004 Persediaan Furniture	4101-004 Penjualan Furniture	4201-004 Retur Penjualan Furniture	4301-004 Diskon Penjualan Furniture	1115-999 Goods In Transit	5100-004 HPP Furniture	1105-004 Persediaan Furniture	2106 Unbilled Goods	No	No	No		No
15	Lemari	L	L2P-Kaca	Lemari - Kaca	1	set	2,000,000	Furniture	30/06/2013	Inventory Part	2,450,000	T	T	1105-004 Persediaan Furniture	4101-004 Penjualan Furniture	4201-004 Retur Penjualan Furniture	4301-004 Diskon Penjualan Furniture	1115-999 Goods In Transit	5100-004 HPP Furniture	1105-004 Persediaan Furniture	2106 Unbilled Goods	No	No	No		No
16	Lemari	L	L2P-Polos	Lemari - Polos	1	set	2,000,000	Furniture	30/06/2013	Inventory Part	2,450,000	T	T	1105-004 Persediaan Furniture	4101-004 Penjualan Furniture	4201-004 Retur Penjualan Furniture	4301-004 Diskon Penjualan Furniture	1115-999 Goods In Transit	5100-004 HPP Furniture	1105-004 Persediaan Furniture	2106 Unbilled Goods	No	No	No		No
17	Meja Rias		MR	Meja Rias				Furniture	30/06/2013	Inventory Part		T	T	1105-004 Persediaan Furniture	4101-004 Penjualan Furniture	4201-004 Retur Penjualan Furniture	4301-004 Diskon Penjualan Furniture	1115-999 Goods In Transit	5100-004 HPP Furniture	1105-004 Persediaan Furniture	2106 Unbilled Goods	No	No	No		No
18	Meja Rias	MR	MR-O 3605	Meja Rias Olympic 3605	1	set	2,200,000	Furniture	30/06/2013	Inventory Part	2,750,000	T	T	1105-004 Persediaan Furniture	4101-004 Penjualan Furniture	4201-004 Retur Penjualan Furniture	4301-004 Diskon Penjualan Furniture	1115-999 Goods In Transit	5100-004 HPP Furniture	1105-004 Persediaan Furniture	2106 Unbilled Goods	No	No	No		No
19	Meja Rias	MR	MR-A C&H	Meja Rias Albatros CSD&HGM	1	set	2,545,000	Furniture	30/06/2013	Inventory Part	2,845,000	T	T	1105-004 Persediaan Furniture	4101-004 Penjualan Furniture	4201-004 Retur Penjualan Furniture	4301-004 Diskon Penjualan Furniture	1115-999 Goods In Transit	5100-004 HPP Furniture	1105-004 Persediaan Furniture	2106 Unbilled Goods	No	No	No		No
20	Kitchen Set		KS	Kitchen Set				Furniture	30/06/2013	Inventory Part		T	T	1105-004 Persediaan Furniture	4101-004 Penjualan Furniture	4201-004 Retur Penjualan Furniture	4301-004 Diskon Penjualan Furniture	1115-999 Goods In Transit	5100-004 HPP Furniture	1105-004 Persediaan Furniture	2106 Unbilled Goods	No	No	No		No
21	Kitchen Set	KS	KS-Natural	Kitchen Set Natural	0	set		Furniture	30/06/2013	Inventory Part	2,895,000	T	T	1105-004 Persediaan Furniture	4101-004 Penjualan Furniture	4201-004 Retur Penjualan Furniture	4301-004 Diskon Penjualan Furniture	1115-999 Goods In Transit	5100-004 HPP Furniture	1105-004 Persediaan Furniture	2106 Unbilled Goods	No	No	No		No
22	Kitchen Set	KS	KS-Green	Kitchen Set Green	0	set		Furniture	30/06/2013	Inventory Part	2,895,000	T	T	1105-004 Persediaan Furniture	4101-004 Penjualan Furniture	4201-004 Retur Penjualan Furniture	4301-004 Diskon Penjualan Furniture	1115-999 Goods In Transit	5100-004 HPP Furniture	1105-004 Persediaan Furniture	2106 Unbilled Goods	No	No	No		No
23	Gergaji		GJG	GERGAJI				Perkakas	30/06/2013	Inventory Part		T	T	1105-002 Persediaan Perkakas	4101-002 Penjualan Perkakas	4201-002 Retur Penjualan Perkakas	4301-002 Diskon Penjualan Perkakas	1115-999 Goods In Transit	5100-002 HPP Perkakas	1105-002 Persediaan Perkakas	2106 Unbilled Goods	No	No	No		No
24	Gergaji	GJG	Ggj-Sel	Gergaji Sellery	10	pcs	280,000	Perkakas	30/06/2013	Inventory Part	50,000	T	T	1105-002 Persediaan Perkakas	4101-002 Penjualan Perkakas	4201-002 Retur Penjualan Perkakas	4301-002 Diskon Penjualan Perkakas	1115-999 Goods In Transit	5100-002 HPP Perkakas	1105-002 Persediaan Perkakas	2106 Unbilled Goods	No	No	No		No
25	Gergaji	GJG	GL-Fuji	Gergaji Listrik Fujiyama	2	set	1,200,000	Perkakas	30/06/2013	Inventory Part	850,000	T	T	1105-002 Persediaan Perkakas	4101-002 Penjualan Perkakas	4201-002 Retur Penjualan Perkakas	4301-002 Diskon Penjualan Perkakas	1115-999 Goods In Transit	5100-002 HPP Perkakas	1105-002 Persediaan Perkakas	2106 Unbilled Goods	No	No	No		No
26	PowerTools		PT	PowerTools				Perkakas	30/06/2013	Inventory Part		T	T	1105-002 Persediaan Perkakas	4101-002 Penjualan Perkakas	4201-002 Retur Penjualan Perkakas	4301-002 Diskon Penjualan Perkakas	1115-999 Goods In Transit	5100-002 HPP Perkakas	1105-002 Persediaan Perkakas	2106 Unbilled Goods	No	No	No		No
27	PowerTools	PT	Bor Norita	Bor Listrik Norita 2800 Rpm	3	set	265,500	Perkakas	30/06/2013	Inventory Part	125,000	T	T	1105-002 Persediaan Perkakas	4101-002 Penjualan Perkakas	4201-002 Retur Penjualan Perkakas	4301-002 Diskon Penjualan Perkakas	1115-999 Goods In Transit	5100-002 HPP Perkakas	1105-002 Persediaan Perkakas	2106 Unbilled Goods	No	No	No		No
28	PowerTools	PT	MP-Fuji	Mesin Poles Fujiyama	2	set	1,429,000	Perkakas	30/06/2013	Inventory Part	115,000	T	T	1105-002 Persediaan Perkakas	4101-002 Penjualan Perkakas	4201-002 Retur Penjualan Perkakas	4301-002 Diskon Penjualan Perkakas	1115-999 Goods In Transit	5100-002 HPP Perkakas	1105-002 Persediaan Perkakas	2106 Unbilled Goods	Yes	No	No	Unique	No
29	PowerTools	PT	MPB-B&D	Mesin Potong Besi B&D	2	set	862,000	Perkakas	30/06/2013	Inventory Part	832,000	T	T	1105-002 Persediaan Perkakas	4101-002 Penjualan Perkakas	4201-002 Retur Penjualan Perkakas	4301-002 Diskon Penjualan Perkakas	1115-999 Goods In Transit	5100-002 HPP Perkakas	1105-002 Persediaan Perkakas	2106 Unbilled Goods	Yes	No	No	Unique	No
30	PowerTools	PT	MA-Makita	Mesin Amplas Makita	2	set	1,317,000	Perkakas	30/06/2013	Inventory Part	1,050,000	T	T	1105-002 Persediaan Perkakas	4101-002 Penjualan Perkakas	4201-002 Retur Penjualan Perkakas	4301-002 Diskon Penjualan Perkakas	1115-999 Goods In Transit	5100-002 HPP Perkakas	1105-002 Persediaan Perkakas	2106 Unbilled Goods	Yes	No	No	Unique	No
31	PowerTools		TNG	TANG				Perkakas	30/06/2013	Inventory Part		T	T	1105-002 Persediaan Perkakas	4101-002 Penjualan Perkakas	4201-002 Retur Penjualan Perkakas	4301-002 Diskon Penjualan Perkakas	1115-999 Goods In Transit	5100-002 HPP Perkakas	1105-002 Persediaan Perkakas	2106 Unbilled Goods	No	No	No		No
32	PowerTools	TNG	TC-Pro 8"	Tang Crimping Pro 8"	20	pcs	270,000	Perkakas	30/06/2013	Inventory Part	20,000	T	T	1105-002 Persediaan Perkakas	4101-002 Penjualan Perkakas	4201-002 Retur Penjualan Perkakas	4301-002 Diskon Penjualan Perkakas	1115-999 Goods In Transit	5100-002 HPP Perkakas	1105-002 Persediaan Perkakas	2106 Unbilled Goods	No	No	No		No
33	PowerTools	TNG	TL-5"	Tang Lancip 5"	20	pcs	650,000	Perkakas	30/06/2013	Inventory Part	59,000	T	T	1105-002 Persediaan Perkakas	4101-002 Penjualan Perkakas	4201-002 Retur Penjualan Perkakas	4301-002 Diskon Penjualan Perkakas	1115-999 Goods In Transit	5100-002 HPP Perkakas	1105-002 Persediaan Perkakas	2106 Unbilled Goods	No	No	No		No
34	Pasir		PSR	PASIR				Material	30/06/2013	Inventory Part		T	T	1105-001 Persediaan Bahan Bangunan	4101-001 Penjualan Bahan Bangunan	4201-001 Retur Penjualan Bahan Bangunan	4301-001 Diskon Penjualan Bahan Bangunan	1115-999 Goods In Transit	5100-001 HPP Bahan Bangunan	1105-001 Persediaan Bahan Bangunan	2106 Unbilled Goods	No	No	No		No
35	Pasir	PSR	P-Btn	Pasir Beton	100	m3	20,000,000	Material	30/06/2013	Inventory Part	350,000	T	T	1105-001 Persediaan Bahan Bangunan	4101-001 Penjualan Bahan Bangunan	4201-001 Retur Penjualan Bahan Bangunan	4301-001 Diskon Penjualan Bahan Bangunan	1115-999 Goods In Transit	5100-001 HPP Bahan Bangunan	1105-001 Persediaan Bahan Bangunan	2106 Unbilled Goods	No	No	No		No
36	Pasir	PSR	P-Bsa	Pasir Biasa	100	m3	20,000,000	Material	30/06/2013	Inventory Part	350,000	T	T	1105-001 Persediaan Bahan Bangunan	4101-001 Penjualan Bahan Bangunan	4201-001 Retur Penjualan Bahan Bangunan	4301-001 Diskon Penjualan Bahan Bangunan	1115-999 Goods In Transit	5100-001 HPP Bahan Bangunan	1105-001 Persediaan Bahan Bangunan	2106 Unbilled Goods	No	No	No		No
37	Semen		SMN	SEMEN				Material	30/06/2013	Inventory Part		T	T	1105-001 Persediaan Bahan Bangunan	4101-001 Penjualan Bahan Bangunan	4201-001 Retur Penjualan Bahan Bangunan	4301-001 Diskon Penjualan Bahan Bangunan	1115-999 Goods In Transit	5100-001 HPP Bahan Bangunan	1105-001 Persediaan Bahan Bangunan	2106 Unbilled Goods	No	No	No		No
38	Semen	SMN	SH-40	Semen Holcim - 40 kg	15	zak	585,000	Material	30/06/2013	Inventory Part	65,000	T	T	1105-001 Persediaan Bahan Bangunan	4101-001 Penjualan Bahan Bangunan	4201-001 Retur Penjualan Bahan Bangunan	4301-001 Diskon Penjualan Bahan Bangunan	1115-999 Goods In Transit	5100-001 HPP Bahan Bangunan	1105-001 Persediaan Bahan Bangunan	2106 Unbilled Goods	No	No	No		No
39	Semen	SMN	SH-50	Semen Holcim - 50 kg	25	zak	1,250,000	Material	30/06/2013	Inventory Part	85,000	T	T	1105-001 Persediaan Bahan Bangunan	4101-001 Penjualan Bahan Bangunan	4201-001 Retur Penjualan Bahan Bangunan	4301-001 Diskon Penjualan Bahan Bangunan	1115-999 Goods In Transit	5100-001 HPP Bahan Bangunan	1105-001 Persediaan Bahan Bangunan	2106 Unbilled Goods	No	No	No		No
40	Cat		CT	CAT				Material	30/06/2013	Inventory Part		T	T	1105-001 Persediaan Bahan Bangunan	4101-001 Penjualan Bahan Bangunan	4201-001 Retur Penjualan Bahan Bangunan	4301-001 Diskon Penjualan Bahan Bangunan	1115-999 Goods In Transit	5100-001 HPP Bahan Bangunan	1105-001 Persediaan Bahan Bangunan	2106 Unbilled Goods	No	No	No		No
41	Cat	CT	CI Dul 2,5lt	Cat Int Dulux 2,5lt	10	klg	1,050,000	Material	30/06/2013	Inventory Part	165,000	T	T	1105-001 Persediaan Bahan Bangunan	4101-001 Penjualan Bahan Bangunan	4201-001 Retur Penjualan Bahan Bangunan	4301-001 Diskon Penjualan Bahan Bangunan	1115-999 Goods In Transit	5100-001 HPP Bahan Bangunan	1105-001 Persediaan Bahan Bangunan	2106 Unbilled Goods	Yes	No	No	Batch	Yes
42	Cat	CT	CI Dul 20lt	Cat Int Dulux 20lt	5	klg	3,780,000	Material	30/06/2013	Inventory Part	976,000	T	T	1105-001 Persediaan Bahan Bangunan	4101-001 Penjualan Bahan Bangunan	4201-001 Retur Penjualan Bahan Bangunan	4301-001 Diskon Penjualan Bahan Bangunan	1115-999 Goods In Transit	5100-001 HPP Bahan Bangunan	1105-001 Persediaan Bahan Bangunan	2106 Unbilled Goods	Yes	No	No	Batch	Yes
43	Cat	CT	CI Mow 2,5lt	Cat Int Mowilex 2.5lt	10	klg	1,430,000	Material	30/06/2013	Inventory Part	213,000	T	T	1105-001 Persediaan Bahan Bangunan	4101-001 Penjualan Bahan Bangunan	4201-001 Retur Penjualan Bahan Bangunan	4301-001 Diskon Penjualan Bahan Bangunan	1115-999 Goods In Transit	5100-001 HPP Bahan Bangunan	1105-001 Persediaan Bahan Bangunan	2106 Unbilled Goods	Yes	No	No	Batch	Yes
44	Cat	CT	CI Mow 20lt	Cat Int Mowilex 20lt	5	klg	2,980,000	Material	30/06/2013	Inventory Part	716,000	T	T	1105-001 Persediaan Bahan Bangunan	4101-001 Penjualan Bahan Bangunan	4201-001 Retur Penjualan Bahan Bangunan	4301-001 Diskon Penjualan Bahan Bangunan	1115-999 Goods In Transit	5100-001 HPP Bahan Bangunan	1105-001 Persediaan Bahan Bangunan	2106 Unbilled Goods	Yes	No	No	Batch	Yes
45	Cat	CT	CI Cat 5kg	Cat Int Catylac 5kg	10	klg	600,000	Material	30/06/2013	Inventory Part	113,000	T	T	1105-001 Persediaan Bahan Bangunan	4101-001 Penjualan Bahan Bangunan	4201-001 Retur Penjualan Bahan Bangunan	4301-001 Diskon Penjualan Bahan Bangunan	1115-999 Goods In Transit	5100-001 HPP Bahan Bangunan	1105-001 Persediaan Bahan Bangunan	2106 Unbilled Goods	Yes	No	No	Batch	Yes
46	Cat	CT	CI Cat 25kg	Cat Int Catylac 25kg	5	klg	1,450,000	Material	30/06/2013	Inventory Part	410,000	T	T	1105-001 Persediaan Bahan Bangunan	4101-001 Penjualan Bahan Bangunan	4201-001 Retur Penjualan Bahan Bangunan	4301-001 Diskon Penjualan Bahan Bangunan	1115-999 Goods In Transit	5100-001 HPP Bahan Bangunan	1105-001 Persediaan Bahan Bangunan	2106 Unbilled Goods	Yes	No	No	Batch	Yes
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