0% found this document useful (0 votes)
66 views14 pages

Track Shete

The document is a track sheet listing products with details on rate, opening stock, purchases, sales and closing stock for October 2021. It shows 63 products including tablets, capsules, injections, syrups and creams. For each product it provides information on unit of measurement (UOM), rate per unit, opening stock, purchases and sales for the month, and closing stock and value. The total sales for all products for October 2021 was Rs. 31381.27.

Uploaded by

Birjesh Rathour
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
66 views14 pages

Track Shete

The document is a track sheet listing products with details on rate, opening stock, purchases, sales and closing stock for October 2021. It shows 63 products including tablets, capsules, injections, syrups and creams. For each product it provides information on unit of measurement (UOM), rate per unit, opening stock, purchases and sales for the month, and closing stock and value. The total sales for all products for October 2021 was Rs. 31381.27.

Uploaded by

Birjesh Rathour
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 14

Track Sheet OCT 2021

Sr no. Product Name UOM Rate Opening stock

1 INFIROCK P TAB (10X10) TAB Box 58.24 16.1


2 INFIROCK SP TAB/ACEROCK SP (10X10) TAB Box 108.64 17
3 ROCKMON-L TAB (10X10) TAB Box 108.20 6.3
4 ROCKMON -L KID TAB (10X10) TAB Box 67.20
5 ROCXIM 200 TAB (10X10) TAB Box 313.60 9
6 ROCXIM FORTE TAB (10X10) TAB Box 425.60 2.7
7 MOXIKLEN CV 625 MG TAB (10X10) TAB Box 672.00 1.5
8 DESPRO MF TAB (10X10) TAB Box 135.60
9 ZOXDIL 200 TAB (10X10) TAB Box 425.60 5.9
10 AZISTIC 250 TAB Tab (10X6) TAB Box 308.00 3
11 AZISTIC 500 TAB (10X3) TAB Box 308.00 3
12 LEEPHE 5 TAB (10X10) TAB Box 41.89
13 VITAL RED TAB (10X10) TAB Box 155.76 3.7
14 XAFLOX 200 TAB (10X10) TAB Box 129.36
15 COLZEE TAB (10X10) TAB Box 80.10 1
16 GR-MOL-MF TAB (10X10) TAB Box 89.60 7.5
17 ACCPAR MR TAB (10X10) TAB Box 114.02
18 FYFLOT 400 TAB (10X10) TAB Box 209.50
19 FYFLOT M TAB (10X10) TAB Box 308.00
20 RABEOC DSR CAP (10X10) CAP Box 84.00 62
21 GROVIT G CAP (10X10) CAP Box 103.84 6.5
22 GRASEL C CAP (3X10) CAP Box 42.84 26
23 FECARBO - FZ CAP (10X10) CAP Box 94.40 0.9
24 CALCIROC K2-7 CAP (10X1X10) CAP Box 141.60 1.9
25 RISTRO -100 CAP (10X1X4) CAP Box 141.68 1
26 RISTRO -200 CAP (10X1X4) CAP Box 258.72 0.7
27 ROCKMON -L SYRUP 60 ML BT BT 12.32 7
28 ROCKOFF DM SYRUP 100 ML BT BT 15.68 5
29 VITAROCK + SYRUP 200 ML BT BT 20.06 3
30 ASKMORE SYRUP 200 ML BT BT 22.40 13
31 ADMZYIME SYRUP 200 ML BT BT 21.24 37
32 NT-LIVER SUSP. 200 ML BT BT 23.60 16
33 FEROC C SYRUP 150 ML BT BT 22.40 12
34 LUKOFEM SYRUP 200 ML BT BT 35.73 8
35 KEZIDEX CZ SUSP. 60 ML BT BT 14.56 39
36 KEZIDEX P SUSP. 60 ML BT BT 14.56
37 PEACEMOL M DS SUSP. 60 ML BT BT 15.40 32
38 ACCPAR - P SUSP. 60 ML BT BT 13.56 14
39 CAFKIL LS SYRUP 100 ML BT BT 20.95
40 MOXIKLEN CV D/S 30 ML BT BT 24.64 1
41 CEEXIME D/S 30 ML with WFI BT BT 20.33 16
42 KEZIFLOX MZ SUSP. 30 ML BT BT 14.75 10
43 KENCID -MPS 170 ML BT BT 20.16 1
44 PANTAGRA IV 40 INJ VL Vials 10.08 29
45 ASTRAC 1 GM INJ. VL Vials 19.10 5
46 ASTRAC 1.5 GM INJ. VL Vials 28.96 10
47 G- ZONE S 1.5 GM VL Vials 36.96
48 DINFLAM INJ. VL Vials 3.08 160
49 MITHBIN 1500 VL Vials 7.40
50 CLOBETA GM SUPER 10 G NOS Tube 7.84 36
51 OMLIMEX GEL 30 GM NOS Tube 12.94 26
52 BESTDERM + CREAM 15 GM NOS Tube 13.25 18
53 ITRAZEEL - T CREAM NOS Tube 22.40 7
54 SUPER SALIC OINTMENT NOS Tube 22.40 3
55 SKIN GLAM CREAM NOS Tube 23.52 1
56 ORAZEEL 10 GM NOS Tube 11.20 21
57 PILCODINE OINTMENT 10 GM NOS Tube 8.01 18
58 PILCODINE M PLUS 15 GM NOS Tube 12.32 13
59 KEBIZOLE SOAP 75GM NOS NOS 31.16
60 CLOTIKA DUSTING POWDER 750GM NOS NOS 30.13 9
61 AMOLUCK 500 CAP CAP Box 234.08
2021
Purchase Total Sale Closing stock Closing Value

39 26.2 28.9 1683.14


26 47.2 -4.2 -456.29
13 12.1 7.2 779.04
3 1 2 134.40
22 23.6 7.4 2320.64
5 1.2 6.5 2766.40
2 1.9 1.6 1075.20
0 0 0.00
0 5.9 2511.04
0 3 924.00
0 3 924.00
4 3 1 41.89
0 3.7 576.31
8 5 3 388.08
15 0 16 1281.60
0.5 7 627.20
4 0 4 456.06
0 0 0.00
1 0.2 0.8 246.40
40 67.2 34.8 2923.20
6 4 8.5 882.64
9 17 728.28
20 9.3 11.6 1095.04
6 1.3 6.6 934.56
3 1.5 2.5 354.20
0 0.7 181.10
35 11 31 381.92
40 33 12 188.16
10 12 1 20.06
8 5 112.00
0 37 785.88
0 16 377.60
3 9 201.60
10 -2 -71.46
37 2 29.12
0 0 0.00
0 10 22 338.80
25 16 23 311.88
78 70 8 167.60
44 30 15 369.60
65 50 31 630.17
2 8 118.00
1 0 0.00
5 24 241.92
68 67 6 114.60
45 30 25 724.00
0 0 0.00
60 100 308.00
0 0 0.00
36 17 55 431.20
4 22 284.68
48 25 41 543.25
2 5 112.00
0 3 67.20
5 1 5 117.60
2 19 212.80
18 0 0.00
10 3 36.96
12 1 11 342.76
0 9 271.15
9 8 1 234.08
31381.27
Sr. No Product Name 12/1/2021 12/2/2021 12/3/2021 12/4/2021
1 INFIROCK P TAB (10X10) 1
2 INFIROCK SP TAB/ACEROCK SP (10X10) 4 1.5
3 ROCKMON-L TAB (10X10)
4 ROCKMON -L KID TAB (10X10)
5 ROCXIM 200 TAB (10X10) 3.5 2
6 ROCXIM FORTE TAB (10X10)
7 MOXIKLEN CV 625 MG TAB (10X10)
8 DESPRO MF TAB (10X10)
9 ZOXDIL 200 TAB (10X10)
10 AZISTIC 250 TAB Tab (10X6)
11 AZISTIC 500 TAB (10X3)
12 LEEPHE 5 TAB (10X10)
13 VITAL RED TAB (10X10)
14 XAFLOX 200 TAB (10X10)
15 COLZEE TAB (10X10)
16 GR-MOL-MF TAB (10X10) 0.4
17 ACCPAR MR TAB (10X10)
18 FYFLOT 400 TAB (10X10)
19 FYFLOT M TAB (10X10)
20 RABEOC DSR CAP (10X10) 1 1.5
21 GROVIT G CAP (10X10)
22 GRASEL C CAP (3X10)
23 FECARBO - FZ CAP (10X10)
24 CALCIROC K2-7 CAP (10X1X10)
25 RISTRO -100 CAP (10X1X4)
26 RISTRO -200 CAP (10X1X4)
27 ROCKMON -L SYRUP 60 ML
28 ROCKOFF DM SYRUP 100 ML 3
29 VITAROCK + SYRUP 200 ML
30 ASKMORE SYRUP 200 ML 5
31 ADMZYIME SYRUP 200 ML
32 NT-LIVER SUSP. 200 ML
33 FEROC C SYRUP 150 ML
34 LUKOFEM SYRUP 200 ML 5
35 KEZIDEX CZ SUSP. 60 ML 5 6
36 KEZIDEX P SUSP. 60 ML
37 PEACEMOL M DS SUSP. 60 ML
38 ACCPAR - P SUSP. 60 ML
39 CAFKIL LS SYRUP 100 ML 10
40 MOXIKLEN CV D/S 30 ML
41 CEEXIME D/S 30 ML with WFI
42 KEZIFLOX MZ SUSP. 30 ML
43 KENCID -MPS 170 ML 1
44 PANTAGRA IV 40 INJ
45 ASTRAC 1 GM INJ. 20
46 ASTRAC 1.5 GM INJ.
47 G- ZONE S 1.5 GM
48 DINFLAM INJ.
49 MITHBIN 1500
50 CLOBETA GM SUPER 10 G
51 OMLIMEX GEL 30 GM
52 BESTDERM + CREAM 15 GM
53 ITRAZEEL - T CREAM
54 SUPER SALIC OINTMENT
55 SKIN GLAM CREAM
56 ORAZEEL 10 GM
57 PILCODINE OINTMENT 10 GM
58 PILCODINE M PLUS 15 GM
59 KEBIZOLE SOAP 75GM
60 CLOTIKA DUSTING POWDER 750GM
61 AMOLUCK 500 CAP
12/5/2021 12/6/2021 12/7/2021 12/8/2021 12/9/2021 Total Rate
26.2 58.24 1
47.2 108.64 5.5
12.1 108.20 0
1 67.20 0
23.6 313.60 5.5
1.2 425.60 0
1.9 672.00 0
0 135.60 0
0 425.60 0
0 308.00 0
0 308.00 0
3 41.89 0
0 155.76 0
5 129.36 0
0 80.10 0
0.5 89.60 0.4
0 114.02 0
0 209.50 0
0.2 308.00 0
67.2 84.00 2.5
4 103.84 0
9 42.84 0
9.3 94.40 0
1.3 141.60 0
1.5 141.68 0
0 258.72 0
11 12.32 0
33 15.68 3
12 20.06 0
8 22.40 5
0 21.24 0
0 23.60 0
3 22.40 0
10 35.73 5
37 14.56 11
0 14.56 0
10 15.40 0
16 13.56 0
70 20.95 10
30 24.64 0
50 20.33 0
2 14.75 0
1 20.16 1
5 10.08 0
67 19.10 20
30 28.96 0
0 36.96 0
60 3.08 0
0 7.40 0
17 7.84 0
4 12.94 0
25 13.25 0
2 22.40 0
0 22.40 0
1 23.52 0
2 11.20 0
18 8.01 0
10 12.32 0
1 31.16 0
0 30.13 0
8 234.08 0

69.9
58.24
597.52
0
0
1724.8
0
0
0
0
0
0
0
0
0
0
35.84
0
0
0
210
0
0
0
0
0
0
0
47.04
0
112
0
0
0
178.64
160.16
0
0
0
209.5
0
0
0
20.16
0
382
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

3735.9
13.10.202115.10.202123.10.2021
DSR 1
Rocxim forte 1
Infirockk P 1
Vital Red 0.5
N.K pharma Rajesh ji
Challan no Date Amount Paid Outstanding Challan no Date
67 12.11.2021 8734 8734 0 58 12.11.2021
60 23.11.2021 7175 7175
61 27.11.2021 8087 8087
62 01.12.2021 12000 12000
71 22.12.2021 6628 6628
0
0
Total 42624 42624
Rajesh ji
Amount Paid
4818
Date Sell Cash collection
1-Dec-21 3320 2180
2-Dec-21 1635 655
3-Dec-21
4-Dec-21
5-Dec-21
6-Dec-21
7-Dec-21
8-Dec-21
9-Dec-21
10-Dec-21
11-Dec-21
12-Dec-21
13-Dec-21
14-Dec-21
15-Dec-21
16-Dec-21
17-Dec-21
18-Dec-21
19-Dec-21
20-Dec-21
21-Dec-21
22-Dec-21
23-Dec-21
24-Dec-21
25-Dec-21
26-Dec-21
27-Dec-21
28-Dec-21
29-Dec-21
30-Dec-21
31-Dec-21

4955 2835 57.21493

You might also like