Vimal Pan Masala Pricing Overview

0% found this document useful (0 votes)
8K views4 pages
The document contains details of purchase and sales transactions of pan masala and tobacco products. It lists purchase invoices from various suppliers with quantity, rate and cess applicabil…

Uploaded by

Darth Vader
  • Voucher Details and Rates
  • GST Calculations
  • GST Sales Overview
  • Sales and Tax Summary

Particulars Voucher Supplier Quantity Rate

Type Invoice No.

Shyam Purchase 4557 100.00 CTN


Vimal Pan Masala MRP Rs.- 4 100.00 CTN 11113.00/CTN
Ram Purchase 3523 200.00 CTN
V-1 Brand Jarda Scented Tobacco MRP Rs.- 1 200.00 CTN 1356.50/CTN
Shyam Purchase 4663 100.00 CTN
Vimal Pan Masala MRP Rs.- 4 100.00 CTN 11113.00/CTN
Shyam Purchase 4725 50.00 CTN
Vimal Pan Masala MRP Rs.- 8.5 50.00 CTN 16734.00/CTN
Ram Purchase 3577 50.00 CTN
V-1 Brand Jarda Scented Tobacco MRP Rs.- 1.5 50.00 CTN 1506.50/CTN
Shyam Purchase 4740 100.00 CTN
Vimal Pan Masala MRP Rs.- 4 100.00 CTN 11113.00/CTN
Grand Total 600.00 CTN

CESS APPLICABILITY RATE


Vimal Pan Masala MRP Rs.- 4 60%
V-1 Brand Jarda Scented Tobacco MRP Rs.- 1 160%
Vimal Pan Masala MRP Rs.- 8.5 60%
Value Gross Total Purchase - Output CGST Output SGST Output Cess Output Cess
GST @ 14% @ 14% @ 60% @ 160%

1111300.00 2089244.00 1111300.00 155582.00 155582.00 666780.00


1111300.00
271300.00 781344.00 271300.00 37982.00 37982.00 434080.00
271300.00
1111300.00 2089244.00 1111300.00 155582.00 155582.00 666780.00
1111300.00
836700.00 1572996.00 836700.00 117138.00 117138.00 502020.00
836700.00
75325.00 216936.00 75325.00 10545.50 10545.50 120520.00
75325.00
1111300.00 2089244.00 1111300.00 155582.00 155582.00 666780.00
1111300.00
4517225.00 8839008.00 4517225.00 632411.50 632411.50 2502360.00 554600.00
Particulars Voucher Quantity Rate Value
Type

F F STORES(KALUPUR) GST SALES 80.00 CTN 503819.20


Vimal Pan Masala MRP Rs.- 4 40.00 CTN 11224.98/CTN 448999.20
V-1 Brand Jarda Scented Tobacco MRP Rs.- 1 40.00 CTN 1370.50/CTN 54820.00
AMDAVAD GENRAL STORES GST SALES 80.00 CTN 503819.20
Vimal Pan Masala MRP Rs.- 4 40.00 CTN 11224.98/CTN 448999.20
V-1 Brand Jarda Scented Tobacco MRP Rs.- 1 40.00 CTN 1370.50/CTN 54820.00
Nandani Stores GST SALES 10.00 CTN 62977.40
Vimal Pan Masala MRP Rs.- 4 5.00 CTN 11224.98/CTN 56124.90
V-1 Brand Jarda Scented Tobacco MRP Rs.- 1 5.00 CTN 1370.50/CTN 6852.50
Hari Om Stores GST SALES 1.00 CTN 6297.74
Vimal Pan Masala MRP Rs.- 4 0.50 CTN 11224.98/CTN 5612.49
V-1 Brand Jarda Scented Tobacco MRP Rs.- 1 0.50 CTN 1370.50/CTN 685.25
Krishna Traders (Kubernagar) GST SALES 1.00 CTN 6297.74
Vimal Pan Masala MRP Rs.- 4 0.50 CTN 11224.98/CTN 5612.49
V-1 Brand Jarda Scented Tobacco MRP Rs.- 1 0.50 CTN 1370.50/CTN 685.25
KiranTraders GST SALES 2.00 CTN 12595.48
Vimal Pan Masala MRP Rs.- 4 1.00 CTN 11224.98/CTN 11224.98
V-1 Brand Jarda Scented Tobacco MRP Rs.- 1 1.00 CTN 1370.50/CTN 1370.50
Grand Total 348.00 CTN 2191613.52
Gross Total Sales - GST Output Output Output Cess Output Cess
CGST @ SGST @ @ 60% @ 160%
14% 14%
1002000.00 503819.20 70534.69 70534.69 269399.52 87712.00

1002000.00 503819.20 70534.69 70534.69 269399.52 87712.00

125250.00 62977.40 8816.84 8816.84 33674.94 10964.00

12525.00 6297.74 881.69 881.69 3367.49 1096.40

12525.00 6297.74 881.69 881.69 3367.49 1096.40

25050.00 12595.48 1763.37 1763.37 6734.99 2192.80

2179350.00 1095806.76 153412.97 153412.97 585943.95 190773.60

Particulars
Quantity
Rate
Shyam
Purchase
4557
100.00 CTN
Vimal Pan Masala MRP Rs.- 4
100.00 CTN
11113.00/CTN
Ram
Purchase
352
Value
Gross Total
1111300.00
2089244.00
1111300.00
155582.00
155582.00
666780.00
1111300.00
271300.00
781344.00
271300.00
379
Particulars
Quantity
Rate
Value
F F STORES(KALUPUR)
GST SALES
80.00 CTN
503819.20
Vimal Pan Masala MRP Rs.- 4
40.00 CTN 11224
Gross Total
Sales - GST
1002000.00
503819.20
70534.69
70534.69
269399.52
87712.00
1002000.00
503819.20
70534.69
70534.69
2693

You might also like