DATA ENTRY WORK IN EXCEL
DATA ENTRY WORK ( Imaginary Inventory Management System )
DAILY INCOMING MATERIALS REPORT OF A MANUFACTURING UNIT
SL NO
VENDORS NAME
INV NO
INV DT
ITEM DESCRIPTION
UOM
QTY
RATE
BASIC VALUE
VEHICLE NO
VEHICLE WT
GRN NO
GRN DT
ADV
GST %
AMOUNT
DUE PAYMENT
LOCATION
1
MILL STORES TRADING CO.
-
GRINDING WHEEL AG-7 (180 X 7 X 22.23)MM
PCS
1050
0
NO
18
0
0
2
ELLENBARRIE INDUSTRIAL GASES LTD
-
O2 GAS CYLINDER 20PCS
CUM
140
0
NO
18
0
0
3
ELLENBARRIE INDUSTRIAL GASES LTD
-
O2 GAS CYLINDER 20PCS
CUM
140
0
NO
18
0
0
4
ECHO GASES PVT LTD
-
O2 GAS CYLINDER 40PCS
CUM
280
0
NO
18
0
0
5
B.B. CHATTERJEE & CO. PVT. LTD
-
POLYCARBONATE TRAPEZOIDICAL SHEET
PCS
27
0
NO
18
0
0
6
RAJESH ENTERPRISES
-
PRECISION GRINDING VICE 4" UNIQUE
PCS
1
0
NO
18
0
0
7
Pragatee International
-
TAX INVOICE
PCS
5000
0
NO
18
0
0
8
Aruna Corrugated Box
-
WHITE CORRUGATED BOX- 460 x 310 x 240 MM
PCS
1530
0
NO
18
0
0
9
OM TRADE CORPORATION
-/2" X 1" EXTENTION NIPPLE
PCS
10
0
NO
18
0
0
10
OM TRADE CORPORATION
-/2" X 1-1/2" EXTENTION NIPPLE
PCS
10
0
NO
18
0
0
11
OM TRADE CORPORATION
-/2"X2" EXTENTION NIPPLE
PCS
10
0
NO
18
0
0
12
NARAYANI ELECTRIC CO.
- AMP MCB 4 POLE
PCS
6
0
NO
18
0
0
13
ANKUSH FORMS CENTRE
-
Arch File
PCS
18
0
NO
18
0
0
14
OM TRADE CORPORATION
-
C.P PILLAR COCK 1/2"
PCS
10
0
NO
18
0
0
15
ANKUSH FORMS CENTRE
-
CALCULATOR
PCS
3
0
NO
18
0
0
16
OM TRADE CORPORATION
-
CI BIB COCK 1/2" (HEAVY DUTY)
PCS
20
0
NO
18
0
0
17
S.H HARDWARE & TOOLS
-
CI GATE VALVE FLANGE 200MM
PCS
3
0
NO
18
0
0
18
OM TRADE CORPORATION
-
CONNECTION PIPE 1/2 "
PCS
30
0
NO
18
0
0
19
M. K. Electric Company
-
COPPER CRIMPING SOCKET 1SQ MM(INSULATED)
PCS
100
0
NO
18
0
0
20
ANKUSH FORMS CENTRE
-
COVER FILE
PCS
10
0
NO
18
0
0
21
OM TRADE CORPORATION
-
CP FLANGE 1/2"
PCS
20
0
NO
18
0
0
22
Newar Trading Co. Pvt. Ltd.
-
CRANE DUTY GEAR REDUCER AMF60H
PCS
1
0
NO
18
0
0
23
M. K. Electric Company
-
CRIMPING SOCKET COPPER 6 sqmm PIN TYPE
PCS
50
0
NO
18
0
0
24
M. K. Electric Company
-
CRIMPING SOCKET COPPER 6 sqmm RING TYPE
PCS
50
0
NO
18
0
0
25
M. K. Electric Company
-
CRIMPING SOCKET CU 1 sqmm (PIN type)
PCS
200
0
NO
18
0
0
26
M. K. Electric Company
-
CRIMPING SOCKET CU 1.5 sqmm (PIN type)
PCS
300
0
NO
18
0
0
27
M. K. Electric Company
-
CRIMPING SOCKET CU 2.5 sqmm (PIN type)
PCS
100
0
NO
18
0
0
28
M. K. Electric Company
-
CRIMPING SOCKET CU 2.5 sqmm (ring type)
PCS
100
0
NO
18
0
0
29
BISHWA TRADING CORPRATION
-
ESAB FERROSPEED PLUS
PKT
72
0
NO
18
0
0
30
ANKUSH FORMS CENTRE
-
EXAM BOARD
PCS
4
0
NO
18
0
0
31
ANKUSH FORMS CENTRE
-
FLAT FILE / COBRA FILE
PCS
12
0
NO
18
0
0
32
ZENITH INDUSTRIES
-
GI HEX BOLT M6x20
PCS
10000
0
NO
18
0
0
33
M.K TRADING CO
-
GM FOOT VALVE WITH PLASTIC BALL 1-1/2"
PCS
6
0
NO
18
0
0
34
M.K TRADING CO
-
GM GATE VALVE 2"
PCS
6
0
NO
18
0
0
35
LADHURAM TOSHNIWAL & SONS
-
IGNITOR 3 PIN SN-58/02 (250 W HPSV LAMP)
PCS
8
0
NO
18
0
0
36
LADHURAM TOSHNIWAL & SONS
-
LAMP 100 WATT (GLS BULB)
PCS
50
0
NO
18
0
0
37
LADHURAM TOSHNIWAL & SONS
-
LAMP HPSV SON-T 250 WATT
PCS
8
0
NO
18
0
0
38
ANKUSH FORMS CENTRE
-
LONG.EX. BOOK
PCS
12
0
NO
18
0
0
39
NARAYANI ELECTRIC CO.
-
MCB 63 AMP TP
PCS
6
0
NO
18
0
0
40
M.K TRADING CO
-
MS REDUSER 6" X4"
PCS
4
0
NO
18
0
0
41
ANKUSH FORMS CENTRE
-
Pencil Carbon Paper
PCS
2
0
NO
18
0
0
42
ANKUSH FORMS CENTRE
-
Plastic Folder
PCS
12
0
NO
18
0
0
43
ANKUSH FORMS CENTRE
-
PUNCH MACHINE
PCS
2
0
NO
18
0
0
44
ANKUSH FORMS CENTRE
-
Register
PCS
29
0
NO
18
0
0
45
ANKUSH FORMS CENTRE
-
Register
PCS
12
0
NO
18
0
0
46
SHREENIWAS UDYOG
-
SELF DRILLING/TAPPING SCREW M5X25 MM
PCS
2000
0
NO
18
0
0
47
UNIVERSAL SUPPLY AGENCY
-
SILICON SPRAY
PCS
384
0
NO
18
0
0
48
ANKUSH FORMS CENTRE
-
SMALL.EX BOOK
PCS
10
0
NO
18
0
0
49
ANKUSH FORMS CENTRE
-
STAMP PAD
PCS
3
0
NO
18
0
0
50
ANKUSH FORMS CENTRE
-
Stamp Pad Ink
PCS
4
0
NO
18
0
0
51
OM TRADE CORPORATION
-
WHITE CEMENT
KG
5
0
NO
18
0
0
52
OM TRADE CORPORATION
-
WHITE ZINC (100 GM PACKING)
KG
1
0
NO
18
0
0
53
ANKUSH FORMS CENTRE
-
Wood Pencil
PCS
20
0
NO
18
0
0
54
ULTRATECH CEMENT LTD
-
CEMENT
MT
10
0
NO
18
0
0
55
VISHAL GASES PVT LTD
-
LPG GAS CYLINDER
KG
735
0
NO
18
0
0
56
OM TRADE CORPORATION
-" X 1/2" MS FIRE ELBOW
PCS
400
0
NO
18
0
0
57
R BEE TRADING COMPANY
-" X 25 TEETH DOUBLE SPROKET
PCS
10
0
NO
18
0
0
58
ALFA STICKERS & LEBELS
-
A4 WHITE PAPER (INR)
PCS
2000
0
NO
18
0
0
59
VINRAJ STEELS PVT LTD
-
GI HEX NUT KGS
KGS
485
0
NO
18
0
0
60
MOTORS & CONTROLS
-
HYDRO MOTOR(MR-315)
PCS
1
0
NO
18
0
0
61
K.K ENTERPRISE
-
LEATHER HAND GLOVES 18"
PAIR
200
0
NO
18
0
0
62
S.H HARDWARE & TOOLS
-
MS SHORT BEND 90 DEGREE
PCS
6
0
NO
18
0
0
63
MOTORS & CONTROLS
-
SOL.OPTD.DC VALVE DSG-03-2B3B-D24-N1-50
PCS
1
0
NO
18
0
0
64
KATEEL ENGINEERING INDUSTRY (P) LTD.
-
PNEU ACTIVE DISC BRAKE CALIPER KF-PA-180
PCS
2
0
NO
18
0
0
65
ARTECH INTERNATIONAL PVT. LTD.
-
T.R.BEARING 32222 A
PCS
12
0
NO
18
0
0
66
CHEMTEX SPECIALITY LIMITED
-
ALSTASAN HANDRUB 2 X 50 LTR
LTR
100
0
NO
18
0
0
67
CHEMTEX SPECIALITY LIMITED
-
ALSTASAN HANDRUB 500ML
LTR
36
0
NO
18
0
0
68
MITRA BUILDERS & ENGINEERING
SHUTTER 33KV 135'5" X 95"
PCS
3
0
NO
18
0
0
69
MITRA BUILDERS & ENGINEERING
SHUTTER 33KV 135'5" X 73"
SQ INCH
68.69
0
NO
18
0
0
70
MITRA BUILDERS & ENGINEERING
SHUTTER 11KV 152'5" X 134"
PCS
3
0
NO
18
0
0
71
MITRA BUILDERS & ENGINEERING
SHUTTER 33KV 133'5" X 98
SQ INCH
90.85
0
NO
18
0
0
72
MITRA BUILDERS & ENGINEERING
SHUTTER HAND COVER
PCS
15
0
NO
18
0
0
73
MITRA BUILDERS & ENGINEERING
BEARING 6007
KGS
140
0
NO
18
0
0
74
MITRA BUILDERS & ENGINEERING
BEARING 6205
PCS
8
0
NO
18
0
0
75
MITRA BUILDERS & ENGINEERING
BEARING SOCKET
PCS
8
0
NO
18
0
0
76
MITRA BUILDERS & ENGINEERING
PATI 25*5
PCS
20
0
NO
18
0
0
77
MANAKSA STEELS LIMITED
-
PPGL PROFILE 0.50
KGS
23607
0
NO
18
0
0
78
ZENITH INDUSTRIES
-
SS ALLEN BOLT M6x30 (FULL THREAD)
PCS
8000
0
NO
18
0
0
79
ZENITH INDUSTRIES
-
SS ALLEN BOLT M6x30 (FULL THREAD)
PCS
4500
0
NO
18
0
0
80
KAMAL STEEL ( INDIA )
-
GUN METAL BUSH
KGS
27.6
0
NO
18
0
0
81
KAMAL STEEL ( INDIA )
-
GUN METAL SQURE MACHINED FINISH
KGS
94.68
0
NO
18
0
0
82
ECHO GASES PRIVATE LTD
-
CO2 GAS CYL 20PCS
KGS
600
0
NO
18
0
0
83
ECHO GASES PRIVATE LTD
-
O2 GAS CYLINDER 20PCS
CYL
20
0
NO
18
0
0
84
ELLENBARRIE INDUSTRIAL GASES LTD
-
O2 GAS CYLINDER 16PCS
CUM
112
0
NO
18
0
0
85
ELLENBARRIE INDUSTRIAL GASES LTD
-
CO2 GAS CYL 20PCS
KGS
600
0
NO
18
0
0
86
SHAKTI ENGINEERING WORKS
-
SS ALLEN BOLT M6x30 (FULL THREAD)
PCS
6200
0
NO
18
0
0
87
SHIELDARC EQUIPMENT PVT LTD
-
MIG WIRE (334 SPOOLS)
KGS
5010
0
NO
18
0
0
88
MAHALAXMI INDUSTRIAL COMPONENTS
-
BRASS INSERT 1/2" FOR CPVC (FEMALE)
KGS
373
0
NO
18
0
0
89
MAHALAXMI INDUSTRIAL COMPONENTS
-
BRASS INSERT 3/4" (MTA)
KGS
332.1
0
NO
18
0
0
90
MAHALAXMI INDUSTRIAL COMPONENTS
-
BRASS INSERT 1/2" (MTA)
KGS
621.7
0
NO
18
0
0
91
MAHALAXMI INDUSTRIAL COMPONENTS
-
BRASS INSERT 3/4" FOR CPVC (FEMALE)
KGS
29.25
0
NO
18
0
0
92
MAHALAXMI INDUSTRIAL COMPONENTS
-
BRASS INSERT 1/2" FOR CPVC (FEMALE)
KGS
270.2
0
NO
18
0
0
93
Durgeshwari Rubplast Pvt. Ltd.
-
PP RUBBER RING 160 MM
PCS
5000
0
NO
18
0
0
94
Durgeshwari Rubplast Pvt. Ltd.
-
PP RUBBER RING 110 MM
PCS
50000
0
NO
18
0
0
95
Durgeshwari Rubplast Pvt. Ltd.
-
PP RUBBER RING 75 MM
PCS
50000
0
NO
18
0
0
96
Control Print Ltd.
-
MAKE UP MU 004 (600 ML)
BOTTLE
12
0
NO
18
0
0
97
Control Print Ltd.
-
INK BK004 (600 ML)
BOTTLE
4
0
NO
18
0
0
98
INDIAN OIL CORPORATION
-
FURNACE OIL
MT
15.55
0
NO
18
0
0
99
INTERSTATE SUPPLY COMPANY
-
HYDROLIC OIL HLP 68
LTR
1050
0
NO
18
0
0
100
Control Print Ltd.
-
MAKE UP MU 055 (600 ML)
PCS
50
0
NO
18
0
0
101
Control Print Ltd.
-
MAKE UP MU 004 (600 ML)
PCS
40
0
NO
18
0
0
102
Control Print Ltd.
-
MAKE UP 8306 (600 ML)
PCS
30
0
NO
18
0
0
103
Control Print Ltd.
-
INK BK004 (600 ML)
PCS
6
0
NO
18
0
0
104
VISHAL GASES PVT LTD
-
LPG GAS CYL 20PCS
KG
420
0
NO
18
0
0
105
ECHO GASES PVT LTD
-
O2 GAS CYLINDER 30PCS
CYL
30
0
NO
18
0
0
106
ECHO GASES PVT LTD
-
CO2 GAS CYLINDER 30PCS
KG
900
0
NO
18
0
0
107
ELLENBARRIE INDUSTRIAL GASES LTD
-
O2 GAS CYLINDER 40PCS
CUM
280
0
NO
18
0
0
108
ELLENBARRIE INDUSTRIAL GASES LTD
-
CO2 GAS CYLINDER 34PCS
KG
1020
0
NO
18
0
0
109
VISHAL GASES PVT LTD
-
LPG GAS CYL 20PCS
KG
420
0
NO
18
0
0
110
ECHO GASES PVT LTD
-
O2 GAS CYLINDER 30PCS
CYL
30
0
NO
18
0
0
111
ECHO GASES PVT LTD
-
CO2 GAS CYLINDER 30PCS
KG
900
0
NO
18
0
0
112
ELLENBARRIE INDUSTRIAL GASES LTD
-
O2 GAS CYLINDER 40PCS
CUM
280
0
NO
18
0
0
113
ELLENBARRIE INDUSTRIAL GASES LTD
-
CO2 GAS CYLINDER 34PCS
KG
1020
0
NO
18
0
0
114
DHANRAJ CHEMICAL INDUSTRIES
-
HCL ACID
MT
19.82
0
NO
18
0
0
115
ORIENT MICRO ABRASIVES LIMITED
-
HCL ACID
MT
20.32
0
NO
18
0
0
116
ELLENBARRIE INDUSTRIAL GASES LTD
-
O2 GAS CYLINDER 40PCS
CUM
280
0
NO
18
0
0
117
ELLENBARRIE INDUSTRIAL GASES LTD
-
CO2 GAS CYLINDER 34PCS
KG
1020
0
NO
18
0
0
118
A.K.PLASTIC
-MM PP RING BLUE
KG
180
0
NO
18
0
0
119
A.K.PLASTIC
-MM PP RING BLUE
KG
70
0
NO
18
0
0
120
A.K.PLASTIC
-MM PP RING BLUE FOR COLOUMN PIPE
PCS
10000
0
NO
18
0
0
121
A.K.PLASTIC
-MM PP RING BLUE FOR COLOUMN PIPE
PCS
18000
0
NO
18
0
0
12
A.K.PLASTIC
-MM PP RING BLUE
KG
60
0
NO
18
0
0
123
A.K.PLASTIC
-
PP RUBBER RING 110MM
PCS
5000
0
NO
18
0
0
124
HIMMAT ELECTRICALS & ELECTRONICS
-
AUTONICS PHOTO SENSOR
NOS
5
0
NO
18
0
0
125
HIMMAT ELECTRICALS & ELECTRONICS
28/05/2020
TOGGLE SWITCH
NOS
25
0
NO
18
0
0