0% found this document useful (0 votes)
335 views3 pages

HBK Invoice Format

The document contains a detailed inventory list of various personal care products, including creams, face washes, lotions, soaps, and body sprays, along with their respective barcodes, quantities, retail prices, and net selling prices. Each entry includes information on discounts, GST values, and total receivable amounts. The data is structured in a tabular format for easy reference and analysis.

Uploaded by

usamakhurshid2
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)
335 views3 pages

HBK Invoice Format

The document contains a detailed inventory list of various personal care products, including creams, face washes, lotions, soaps, and body sprays, along with their respective barcodes, quantities, retail prices, and net selling prices. Each entry includes information on discounts, GST values, and total receivable amounts. The data is structured in a tabular format for easy reference and analysis.

Uploaded by

usamakhurshid2
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

Package Ex Value TP Inculde On Discount NET Selling price Receivable

Sr# Barcode Product Name Range QTY Retail GST Value


Size MRP GST Invoice % Total Ex GST Amount

1 8964001078586 GPC Cream 28GM 144 A 432 305.1 360 288.00 8 9953 90,739.33 23,723.39 114,462.72
2 8964001078067 Face Wash (Foaming) 75ML 72 A 24 211.9 250 204.92 8 393 3,609.38 915.25 4,524.63
3 8964003015114 Face Wash (Foaming) 150ML 36 A 24 381.4 450 368.85 8 708 6,496.75 1,647.46 8,144.21
4 8964001078043 Face Wash (Herbal) 75ML 72 A 24 211.9 250 204.92 8 393 3,609.38 915.25 4,524.63
5 8964003015091 Face Wash (Herbal) 150ML 36 A 24 381.4 450 368.85 8 708 6,496.75 1,647.46 8,144.21
6 8964001078074 Face Wash (Neem) 75ML 72 A 24 211.9 250 204.92 8 393 3,609.38 915.25 4,524.63
7 8964003015121 Face Wash (Neem) 150ML 36 A 24 381.4 450 368.85 8 708 6,496.75 1,647.46 8,144.21
8 8964001078050 Face Wash (Normal) 75ML 72 A 24 211.9 250 204.92 8 393 3,609.38 915.25 4,524.63
9 8964003015107 Face Wash (Normal) 150ML 36 A 24 381.4 450 368.85 8 708 6,496.75 1,647.46 8,144.21
10 8964003015671 New Product White Beauty FW 75ML 72 A 24 211.9 250 204.92 8 393 3,609.38 915.25 4,524.63
11 8964003015688 New Product White Beauty FW 150ML 36 A 24 381.4 450 368.85 8 708 6,496.75 1,647.46 8,144.21
12 8964001753230 New Product Light & Glow FW 75ML 72 A 24 211.9 250 204.92 8 393 3,609.38 915.25 4,524.63
13 8964001753247 New Product Light & Glow FW 150ML 36 A 24 381.4 450 368.85 8 708 6,496.75 1,647.46 8,144.21
14 8964003015619 Face Wash Activated Charcol 75ml 72 A 24 211.9 250 204.92 8 393 3,609.38 915.25 4,524.63
15 8964003015695 Face Wash Vitamin C 75ml 72 A 24 211.9 250 204.92 8 393 3,609.38 915.25 4,524.63
16 8964003015718 Face Wash Tea Tree 75ml 72 A 24 211.9 250 204.92 8 393 3,609.38 915.25 4,524.63
17 8964003015633 Face Wash Men Power 75ml 72 A 24 211.9 250 204.92 8 393 3,609.38 915.25 4,524.63
18 8964003015626 Face Wash Activated Charcol 150ml 36 A 12 381.4 450 368.85 8 354 3,248.38 823.73 4,072.10
19 8964003015701 Face Wash Vitamin C 150ml 36 A 24 381.4 450 368.85 8 708 6,496.75 1,647.46 8,144.21
20 8964003015725 Face Wash Tea Tree 150ml 36 A 24 381.4 450 368.85 8 708 6,496.75 1,647.46 8,144.21
21 8964003015640 Face Wash Men Power 150ml 36 A 24 381.4 450 368.85 8 708 6,496.75 1,647.46 8,144.21
34 8964001753650 Skin Lightening Moisturiszing Lotion 400ML 24 A 12 491.5 580 483.33 8 464 4,274.27 1,061.69 5,335.96
35 8964001753568 Cocoa Touch Moisturiszing Lotion 400ML 24 A 10 491.5 580 483.33 8 387 3,561.89 884.75 4,446.64
36 8964001753599 Honey & Almond Moisturiszing Lotion 400ML 24 A 8 491.5 580 483.33 8 309 2,849.51 707.80 3,557.31
37 8964001753629 Healty White Moisturiszing Lotion 400ML 24 A 5 491.5 580 483.33 8 193 1,780.95 442.37 2,223.32
38 8964001753537 Aloe Magic Moisturiszing Lotion 400ML 24 A 18 491.5 580 483.33 8 696 6,411.40 1,592.54 8,003.94
39 8964001753681 Triple Action Cleaning Milk 400ML 24 A 18 491.5 580 483.33 8 696 6,411.40 1,592.54 8,003.94
40 8964003015510 Oud Lotion 200ML 36 A 24 381.4 450 375.00 8 720 6,632.54 1,647.46 8,280.00
41 8964003015558 Intensive Care Deep Moisture Lotion 200ML 36 A 24 381.4 450 375.00 8 720 6,632.54 1,647.46 8,280.00
42 8964003015534 White Beauty Lotion 200ML 36 A 24 381.4 450 375.00 8 720 6,632.54 1,647.46 8,280.00
43 8964003015527 Oud Lotion 400ML 24 A 24 678.0 800 666.67 8 1280 11,791.26 2,928.81 14,720.07
44 8964003015565 Intensive Care Deep Moisture Lotion 400ML 24 A 24 678.0 800 666.67 8 1280 11,791.26 2,928.81 14,720.07
45 8964003015541 White Beauty Lotion 400ML 24 A 24 678.0 800 666.67 8 1280 11,791.26 2,928.81 14,720.07
46 8964003015572 White Beauty Cream 50ML 72 A 24 322.0 380 316.67 8 608 5,600.89 1,391.19 6,992.07
47 8964001078173 Soap (Acne & Oily) 100GM 72 A 144 110.2 130 118.17 8 1361 12,799.57 2,855.59 15,655.16
48 8964001078180 Soap (Dry) 100GM 72 A 132 110.2 130 118.17 8 1248 11,732.94 2,617.63 14,350.56
49 8964001078166 Soap (Normal) 100GM 72 A 144 110.2 130 118.17 8 1361 12,799.57 2,855.59 15,655.16
50 8964001753261 Light & Glow BB Cream Light Shade 18ML 72 A 36 211.9 250 200.00 8 576 5,251.12 1,372.88 6,624.00
51 8964001753254 Light & Glow BB Cream Original Shade 18ML 72 A 36 211.9 250 200.00 8 576 5,251.12 1,372.88 6,624.00
52 8964001753155 Light & Glow (Jar) 70ML 72 A 24 296.6 350 286.89 8 551 5,053.18 1,281.36 6,334.53
54 8964001078791 Mens Face Wash 75ML 72 A 24 211.9 250 204.92 8 393 3,609.38 915.25 4,524.63
55 8964003015084 Mens Face Wash 150ML 36 A 24 381.4 450 368.85 8 708 6,496.75 1,647.46 8,144.21
60 8964003015749 Sun Block (SPF 30) 120ML 24 A 24 593.2 700 573.77 8 1102 10,106.13 2,562.71 12,668.84
61 8964003015480 Sun Block (SPF 45) 120ML 24 A 18 593.2 700 573.77 8 826 7,579.60 1,922.03 9,501.63
62 8964003015503 Sun Block (SPF 60) 120ML 24 A 24 593.2 700 573.77 8 1102 10,106.13 2,562.71 12,668.84
63 8964003015466 Sun Block (SPF 90) 120ML 24 A 12 593.2 700 573.77 8 551 5,053.06 1,281.36 6,334.42
64 8964001078500 GP Romance Body Spray 200ML 96 A 36 381.4 450 375.00 8 1080 9,948.81 2,471.19 12,420.00
65 8964001078517 GP Seduce Body Spray 200ML 96 A 36 381.4 450 375.00 8 1080 9,948.81 2,471.19 12,420.00
66 8964001078487 GP Urge Body Spray 200ML 96 A 36 381.4 450 375.00 8 1080 9,948.81 2,471.19 12,420.00
67 8964001078494 GP Flirt Body Spray 200ML 96 A 36 381.4 450 375.00 8 1080 9,948.81 2,471.19 12,420.00
68 8964001078524 Gp Attraction Body Spray 200ML 96 A 36 381.4 450 375.00 8 1080 9,948.81 2,471.19 12,420.00
69 8964001078555 GP Charge Body Spray 200ML 96 A 36 381.4 450 375.00 8 1080 9,948.81 2,471.19 12,420.00
70 8964001078531 GP Leader Body Spray 200ML 96 A 36 381.4 450 375.00 8 1080 9,948.81 2,471.19 12,420.00
71 8964001078548 GP Passion Body Spray 200ML 96 A 36 381.4 450 375.00 8 1080 9,948.81 2,471.19 12,420.00
72 8964001078449 GP Blue Yatch Body Spray 200ML 96 A 36 381.4 450 375.00 8 1080 9,948.81 2,471.19 12,420.00
73 8964001078463 GP Dark Energy Body Spray 200ML 96 A 36 381.4 450 375.00 8 1080 9,948.81 2,471.19 12,420.00
74 8964001078470 GP Golden Touch Body Spray 200ML 96 A 36 381.4 450 375.00 8 1080 9,948.81 2,471.19 12,420.00
75 8964001078456 GP Soldier Body Spray 200ML 96 A 36 381.4 450 375.00 8 1080 9,948.81 2,471.19 12,420.00
76 8964003015138 Golden Pearl Body Spray M& U Arabia Non Gas 120ML 72 A 24 423.7 500 416.67 8 800 7,369.57 1,830.51 9,200.07
77 8964003015145 Golden Pearl Body Spray M& U Night Fall Non Gas 120ML 72 A 24 423.7 500 416.67 8 800 7,369.57 1,830.51 9,200.07
78 8964003015152 Golden Pearl Body Spray M& U Splash Non Gas 120ML 72 A 24 423.7 500 416.67 8 800 7,369.57 1,830.51 9,200.07
79 8964003015176 Golden Pearl Body Spray M& U Password Non Gas 120ML 72 A 24 423.7 500 416.67 8 800 7,369.57 1,830.51 9,200.07
80 8964003015169 Golden Pearl Body Spray M& U Royal Non Gas 120ML 72 A 24 423.7 500 416.67 8 800 7,369.57 1,830.51 9,200.07
82 8964003015206 Golden Pearl Body Spray M& U Desert Rose Non Gas 120ML 72 A 24 423.7 500 416.67 8 800 7,369.57 1,830.51 9,200.07
83 8964003015213 Golden Pearl Body Spray M& U Sweet Heart Non Gas 120ML 72 A 24 423.7 500 416.67 8 800 7,369.57 1,830.51 9,200.07
84 8964003015244 Golden Pearl Body Spray M& U Dark Energy Non Gas 120ML 72 A 24 423.7 500 416.67 8 800 7,369.57 1,830.51 9,200.07
85 8964003015190 Golden Pearl Body Spray M& U Love Story Non Gas 120ML 72 A 24 423.7 500 416.67 8 800 7,369.57 1,830.51 9,200.07
86 8964003015237 Golden Pearl Body Spray M& U Blossom Non Gas 120ML 72 A 24 423.7 500 416.67 8 800 7,369.57 1,830.51 9,200.07
87 8964003015251 Golden Pearl Body Spray M& U Kiss Non Gas 120ML 72 A 24 423.7 500 416.67 8 800 7,369.57 1,830.51 9,200.07
88 8964003015268 Golden Pearl Body Spray M& U Millionaire Lady Non Gas 120 72 A 24 423.7 500 416.67 8 800 7,369.57 1,830.51 9,200.07
89 8964003015220 Golden Pearl Body Spray M& U Date Night Non Gas 120ML 72 A 24 423.7 500 416.67 8 800 7,369.57 1,830.51 9,200.07
90 8964003017576 Aloe vera 75ml Tube 72 B 24 194.9 230 192.00 8 369 3,397.33 842.03 4,239.36
91 8964003017583 Aloe vera 150ml Jar 48 B 24 339.0 400 333.00 8 639 5,888.23 1,464.41 7,352.64
92 8964001753308 G.P Flawless Skin Face Wash 75ML 72 B 24 211.9 250 208.00 8 399 3,677.39 915.25 4,592.64
93 8964001753292 G.P Flawless Skin Face Wash 150ML 36 B 24 381.4 450 375.00 8 720 6,632.54 1,647.46 8,280.00
94 8964003015657 Acno clear FW 75ml 72 B 24 211.9 250 208.00 8 399 3,677.39 915.25 4,592.64
95 8964003015664 Acno clear FW 150ml 36 B 24 381.4 450 375.00 8 720 6,632.54 1,647.46 8,280.00
96 8964001078647 G.P Black Head Removing Mask 30ML 72 B 24 169.5 200 167.00 8 321 2,955.16 732.20 3,687.36
97 8964001078869 G.P Bleach Powder 200G 24 B 18 508.5 600 500.00 8 720 6,632.54 1,647.46 8,280.00
98 8964001753506 G.P Bleach Powder 60GM 48 B 24 169.5 200 167.00 8 321 2,955.16 732.20 3,687.36
100 8964001078852 G.P Bleach Powder 400G 12 B 12 847.5 1000 833.00 8 800 7,365.81 1,830.51 9,196.32
101 8964001078418 G.P Cream Developer 20 vol 500ML 24 B 12 466.1 550 458.00 8 440 4,049.54 1,006.78 5,056.32
104 8964001753490 G.P Cream Developer 20 vol 60ML 72 B 24 110.2 130 108.00 8 207 1,908.71 475.93 2,384.64
106 8964001078609 G.P Glow Boosting Cream 50G 36 B 24 423.7 500 417.00 8 801 7,376.85 1,830.51 9,207.36
111 8964001753100 G.P Whitening Urgent Facial Tube 75ML 72 B 24 211.9 250 208.00 8 399 3,677.39 915.25 4,592.64
113 8964001753186 G.P Fruity Whitening Urgent Facial Tube 75ML 72 B 24 211.9 250 208.00 8 399 3,677.39 915.25 4,592.64
114 8964001753803 G.P Whitening Facial Trial Kit 11 ITEMS 12 B 6 678.0 800 667.00 8 320 2,949.64 732.20 3,681.84
117 8964001078623 G.P Glow Boosting Toner 150ML 36 B 12 339.0 400 333.00 8 320 2,944.12 732.20 3,676.32
119 8964001753735 G.P Healthy Glow Skin Shiner 120ML 48 B 24 152.5 180 150.00 8 288 2,653.02 658.98 3,312.00
120 8964001078890 G.P Healthy Glow Skin Shiner 500ML 24 B 12 406.8 480 400.00 8 384 3,537.36 878.64 4,416.00
131 8964001078753 G.P Multivitamin Massage Cream 300ML 24 B 24 423.7 500 417.00 8 801 7,376.85 1,830.51 9,207.36
132 8964001078715 G.P Skin Lightening Double Action Cleanser 300ML 24 B 24 423.7 500 417.00 8 801 7,376.85 1,830.51 9,207.36
133 8964001078722 G.P Skin Lightening Facial Scrub Jar 300ML 24 B 22 423.7 500 417.00 8 734 6,762.11 1,677.97 8,440.08
134 8964001078777 G.P Double Exfoliating Scrub Jar 300ML 24 B 21 423.7 500 417.00 8 701 6,454.75 1,601.69 8,056.44
135 8964001078739 G.P Skin Lightening Massage cream Jar 300ML 24 B 24 423.7 500 417.00 8 801 7,376.85 1,830.51 9,207.36
136 8964001078746 G.P Skin Lightening Moisturizing Mud Mask 300ML 24 B 24 423.7 500 417.00 8 801 7,376.85 1,830.51 9,207.36
137 8964001078760 G.P Skin Lightening organic clay mask Jar 300ML 24 B 24 423.7 500 417.00 8 801 7,376.85 1,830.51 9,207.36
138 8964001753209 G P Skin Lightening Skin Polish 300ML 24 B 21 423.7 500 417.00 8 701 6,454.75 1,601.69 8,056.44
140 8964001753421 G.P Skin Polishing Pack 4 ITEMS 24 B 12 381.4 450 375.00 8 360 3,316.27 823.73 4,140.00
141 8964001078876 G.P Ultra Calming Soothing Lotion 500ML 72 B 12 406.8 480 400.00 8 384 3,537.36 878.64 4,416.00
142 8964001753704 G.P Ultra Calming Soothing Lotion 120ML 48 B 6 152.5 180 150.00 8 72 663.25 164.75 828.00
145 8964003015299 G.P Moisturizing Cream Jar 200ML 24 B 24 440.7 520 433.00 8 831 7,656.91 1,903.73 9,560.64
146 8964003015275 G.P Body Butter Cocoa & Shea Jar 200ML 24 B 18 440.7 520 433.00 8 624 5,742.68 1,427.80 7,170.48
152 8964003015411 G.P 7Way Beauty Care Cream 200ML 24 B 24 440.7 520 433.00 8 831 7,656.91 1,903.73 9,560.64
154 8964003015442 G.P Soft Light Moisturizing Cream 200ML 24 B 12 440.7 520 433.00 8 416 3,828.46 951.86 4,780.32
158 8964003015312 GP - 24 K Gold Skin Serum 20ml 20ML 48 B 24 381.4 450 375.00 8 720 6,632.54 1,647.46 8,280.00
159 8964003015329 GP - Glutathione Skin Serum 20ml 20ML 48 B 24 381.4 450 375.00 8 720 6,632.54 1,647.46 8,280.00
160 8964003015305 GP - Vitamin C Skin Serum 20ml 20ML 48 B 24 381.4 450 375.00 8 720 6,632.54 1,647.46 8,280.00
165 8964001753889 Hello Hair Daily Moisturizing Shampoo 190ML 48 C 48 279.7 330 279.66 8 1074 9,933.51 2,416.27 12,349.79
166 8964001753896 Hello Hair Egg Protien Shampoo 190ML 48 C 48 279.7 330 279.66 8 1074 9,933.51 2,416.27 12,349.79
167 8964001753902 Hello Hair Herbal Shampoo 190ML 48 C 36 279.7 330 279.66 8 805 7,450.14 1,812.20 9,262.34
168 8964001753919 Hello Hair Anti-Dandruff Shampoo 190ML 48 C 48 279.7 330 279.66 8 1074 9,933.51 2,416.27 12,349.79
169 8964001753926 Hello Hair Daily Moisturizing Shampoo 400ML 24 C 24 483.1 570 483.05 8 927 8,578.96 2,086.78 10,665.74
170 8964001753933 Hello Hair Egg Protien Shampoo 400ML 24 C 24 483.1 570 483.05 8 927 8,578.96 2,086.78 10,665.74
171 8964001753940 Hello Hair Herbal Shampoo 400ML 24 C 24 483.1 570 483.05 8 927 8,578.96 2,086.78 10,665.74
172 8964001753957 Hello Hair Anti-Dandruff Shampoo 400ML 24 C 24 483.1 570 483.05 8 927 8,578.96 2,086.78 10,665.74
179 8964003015008 Set & Touch Keratin Repair Shampoo 190ML 48 C 48 313.6 370 313.56 8 1204 11,137.66 2,709.15 13,846.81
180 8964003015015 Set & Touch Rich Black Shine Shampoo 190ML 48 C 48 313.6 370 313.56 8 1204 11,137.66 2,709.15 13,846.81
181 8964003015022 Set & Touch Hair Fall Solution Shampoo 190ML 48 C 48 313.6 370 313.56 8 1204 11,137.66 2,709.15 13,846.81
182 8964003015039 Set & Touch Long & Strong Shampoo 190ML 48 C 48 313.6 370 313.56 8 1204 11,137.66 2,709.15 13,846.81
183 8964003015046 Set & Touch Keratin Repair Shampoo 400ML 24 C 24 525.4 620 525.42 8 1009 9,331.44 2,269.83 11,601.27
184 8964003015053 Set & Touch Rich Black Shine Shampoo 400ML 24 C 24 525.4 620 525.42 8 1009 9,331.44 2,269.83 11,601.27
185 8964003015060 Set & Touch Hair Fall Solution Shampoo 400ML 24 C 24 525.4 620 525.42 8 1009 9,331.44 2,269.83 11,601.27
186 8964003015077 Set & Touch Long & Strong Shampoo 400ML 24 C 24 525.4 620 525.42 8 1009 9,331.44 2,269.83 11,601.27
188 8964001753339 HRC Tube (Rose) 100ML 48 C 36 254.2 300 254.24 8 732 6,772.97 1,647.46 8,420.43
190 8964001753353 HRC Jar (Rose) 120ML 36 C 24 220.3 260 220.34 8 423 3,913.24 951.86 4,865.11
192 8964001753377 HRC Tube (Aloe Vera) 100ML 48 C 48 254.2 300 254.24 8 976 9,030.63 2,196.61 11,227.24
194 8964001753391 HRC Jar (Aloe Vera) 120ML 36 C 18 220.3 260 220.34 8 317 2,934.93 713.90 3,648.83
195 8964003015756 Hello Hair Color Natural Black 1 Kit 50 gm 72 C 12 237.3 280 237.29 8 228 2,107.14 512.54 2,619.68
196 8964003015787 Hair Color Cream Tube Medium Brown 4 Kit 50 gm 72 C 24 237.3 280 237.29 8 456 4,214.28 1,025.08 5,239.36
197 8964003015800 Hair Color Cream Tube Light Brown 5 Kit 50 gm 72 C 24 237.3 280 237.29 8 456 4,214.28 1,025.08 5,239.36
198 8964003015763 Hair Color Cream Tube Dark Brown 3 Kit 50 gm 72 C 24 237.3 280 237.29 8 456 4,214.28 1,025.08 5,239.36
199 8964003015770 Hair Color Cream Tube Deep Mahogany Brown 3.6 Kit 50 gm 72 C 12 237.3 280 237.29 8 228 2,107.14 512.54 2,619.68
200 8964003015794 Hair Color Cream Tube Burgundy 4.6 Kit 50 gm 72 C 12 237.3 280 237.29 8 228 2,107.14 512.54 2,619.68
201 8964003015817 Hair Color Cream Tube Medium Golden Brown 4.3 Kit 50 gm 72 C 12 237.3 280 237.29 8 228 2,107.14 512.54 2,619.68
202 8964003015824 Hair Color Cream Tube Ash Brown 5.1 Kit 50 gm 72 C 12 237.3 280 237.29 8 228 2,107.14 512.54 2,619.68
203 8964003015831 Hair Color Cream Tube Light Golden Blond 6.3 Kit 50 gm 72 C 12 237.3 280 237.29 8 228 2,107.14 512.54 2,619.68
204 8964003015848 Hair Color Cream Tube Ash Blond 7 Kit 50 gm 72 C 12 237.3 280 237.29 8 228 2,107.14 512.54 2,619.68
205 8964003015855 Hair Color Cream Tube Ultra Golden Blond 9.3 Kit 50 gm 72 C 12 237.3 280 237.29 8 228 2,107.14 512.54 2,619.68
207 8694003017644 Golden Pearl Almond Hair Oil 200ML 48 C 24 322.0 380 308.94 8 593 5,430.21 1,391.19 6,821.40
209 8964003017507 Golden Pearl Coconut Hair Oil 200ML 48 C 24 322.0 380 308.94 8 593 5,430.21 1,391.19 6,821.40
211 8964001753087 Golden Pearl 10 Natural herbs Hair Oil 200ML 48 C 24 322.0 380 308.94 8 593 5,430.21 1,391.19 6,821.40
213 8964003017484 Golden Pearl Argan Hair Oil 200ML 48 C 24 322.0 380 308.94 8 593 5,430.21 1,391.19 6,821.40
215 8964003017668 Golden Pearl Garlic Hair Oil 200ML 48 C 24 322.0 380 308.94 8 593 5,430.21 1,391.19 6,821.40
4,251 109,659 1,009,931.73 251,142.71 1,261,074.44

Total Value Excl Sales Tax 1,009,931.73


Sale Tax 251,142.71
Total Value Inc Sales Tax 1,261,074.44
Advance Income Tax 6,305.37
Net Payable 1,267,379.82

You might also like