Scribd
Upload
16 views7 pages

Sales Returns and GST Summary

The document lists various sales returns and actual sales deletions for different branches and categories along with associated details such as dates, bill numbers, and GST information. It includes both credit and cash sales, detailing the taxable amounts, tax rates, and net amounts. Additionally, it provides a summary of party names and their respective GSTINs, along with the tax breakdown for each transaction.

Uploaded by

ritajainmodi
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
16 views7 pages

Sales Returns and GST Summary

The document lists various sales returns and actual sales deletions for different branches and categories along with associated details such as dates, bill numbers, and GST information. It includes both credit and cash sales, detailing the taxable amounts, tax rates, and net amounts. Additionally, it provides a summary of party names and their respective GSTINs, along with the tax breakdown for each transaction.

Uploaded by

ritajainmodi
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

Branch Category Vou.

No Bill No Date Sales's Return


FCTRY012 CREDIT SALE 10490000058 FCTRY012-56 17-Jun-25 Delete it (sales return)
FCTRY012 CREDIT SALE 10490000153 FCTRY012-153 25-Jun-25 Delete it (sales return)
FCTRY012 CREDIT SALE 10490000153 FCTRY012-153 25-Jun-25 Delete it (sales return)
FCTRY012 CREDIT SALE 10490000141 FCTRY012-140 24-Jun-25 Delete it (sales return)
LNKRD002 CASH SALE 10220000008 10220000008 29-Jun-25 Delete it (sales return)
LNKRD002 CASH SALE 10220000007 10220000007 19-Jun-25 Delete it (sales return)
LNKRD002 CASH SALE 10220000006 10220000006 16-Jun-25 Delete it (sales return)
LNKRD002 CASH SALE 10220000006 10220000006 16-Jun-25 Delete it (sales return)
LNKRD002 CASH SALE 10220000006 10220000006 16-Jun-25 Delete it (sales return)
LNKRD002 CASH SALE 10220000005 10220000005 10-Jun-25 Delete it (sales return)
MHVRNG01 CASH SALE 10120000006 10120000006 14-Jun-25 Delete it (sales return)
MHVRNG01 CASH SALE 10130000001 10130000001 2-Jun-25 Delete it (sales return)
MHVRNG01 CASH SALE 10130000001 10130000001 2-Jun-25 Delete it (sales return)
MHVRNG01 CASH SALE 10120000003 10120000003 6-Jun-25 Delete it (sales return)
MHVRNG01 CASH SALE 10120000003 10120000003 6-Jun-25 Delete it (sales return)
NRSLN003 CASH SALE 10320000004 10320000004 5-Jun-25 Delete it (sales return)
NRSLN003 CASH SALE 10320000008 10320000008 14-Jun-25 Delete it (sales return)
NRSLN003 CASH SALE 10320000006 10320000006 9-Jun-25 Delete it (sales return)
NRSLN003 CASH SALE 10320000006 10320000006 9-Jun-25 Delete it (sales return)
Party GSTIN Party Name Party State Tax Name
26AABCJ1029L1ZO [Link] PRIVATE LIMITED (JKSR) DNH GST 5%
27ACQPG8909E1ZB OM DRYFRUITS MAH GST 5%
27ACQPG8909E1ZB OM DRYFRUITS MAH GST 18%
27AAEPM4542K1ZJ PEPPILLON (LALBAG) MAH GST 18%
27AEMPM3450Q1ZU M S COLOR TONE MAH GST 5%
27AAWFS6854N1ZZ SHAILESH TUBE CORPORATION MAH GST 12%
27AAACI2628B1Z2 TECNIMONT PVT LTD MAH GST 12%
27AAACI2628B1Z2 TECNIMONT PVT LTD MAH GST 18%
27AAACI2628B1Z2 TECNIMONT PVT LTD MAH GST 5%
26AADCU2027M1Z9 UNOMAX DNH GST 5%
27AHFPK8243H1Z7 DEVANG MAH GST 5%
27AAAFE9163G1ZE EXPRESS CARGO MOVERS MAH GST 12%
27AAAFE9163G1ZE EXPRESS CARGO MOVERS MAH GST 5%
27AACCO4229L1Z8 OMNIFICENT TECHNOLOGIES [Link]. MAH GST 12%
27AACCO4229L1Z8 OMNIFICENT TECHNOLOGIES [Link]. MAH GST 5%
27BBBCJ1029L1ZM ABHISHEK SINGH RAJPUT MAH GST 5%
27BBBCJ1029L1ZM ABHISHEK SINGH RAJPUT MAH GST 5%
27AAKFS7629D1ZX SHERATONN APPARELS MAH GST 12%
27AAKFS7629D1ZX SHERATONN APPARELS MAH GST 5%
Tax % Taxable Amt Tax Amt IGST Amt CGST Amt SGST Amt
5 4,000.00 200.00 200.00 100.00 100.00
5 990.48 49.52 - 24.76 24.76
18 1,220.34 219.66 - 109.83 109.83
18 1,423.73 256.27 - 128.14 128.14
5 285.71 14.29 - 7.14 7.14
12 4,285.71 514.29 - 257.14 257.14
12 2,500.00 300.00 - 150.00 150.00
18 3,728.81 671.19 - 335.59 335.59
5 2,857.14 142.86 - 71.43 71.43
5 3,428.57 171.43 171.43 85.71 85.71
5 1,047.62 52.38 - 26.19 26.19
12 89.29 10.71 - 5.36 5.36
5 14,609.52 730.48 - 365.24 365.24
12 294.64 35.36 - 17.68 17.68
5 17,700.00 885.00 - 442.50 442.50
5 95.24 4.76 - 2.38 2.38
5 4.76 0.24 - 0.12 0.12
12 187.50 22.50 - 11.25 11.25
5 1,452.38 72.62 - 36.31 36.31
Net Amt
4,200.00
1,040.00
1,440.00
1,680.00
300.00
4,800.00
2,800.00
4,400.00
3,000.00
3,600.00
1,100.00
100.00
15,340.00
330.00
18,585.00
100.00
5.00
210.00
1,525.00
Branch Category Vou. No Bill No Date Remark
FCTRY012 CREDIT SALE 10490000005 FCTRY012-5 3-Jun-25 Delete Actual Sales
FCTRY012 CREDIT SALE 10490000021 FCTRY012-21 12-Jun-25 Delete Actual Sales
FCTRY012 CREDIT SALE 10490000156 FCTRY012-155 25-Jun-25 Delete Actual Sales
FCTRY012 CREDIT SALE 10490000020 FCTRY012-20 12-Jun-25 Delete Actual Sales
FCTRY012 CREDIT SALE 10490000058 FCTRY012-56 17-Jun-25 Delete Actual Sales
FCTRY012 CREDIT SALE 10490000023 FCTRY012-23 13-Jun-25 Delete Actual Sales
FCTRY012 CREDIT SALE 10490000023 FCTRY012-23 13-Jun-25 Delete Actual Sales
FCTRY012 CREDIT SALE 10490000023 FCTRY012-23 13-Jun-25 Delete Actual Sales
FCTRY012 CREDIT SALE 10490000012 FCTRY012-12 11-Jun-25 Delete Actual Sales
FCTRY012 CREDIT SALE 10490000153 FCTRY012-153 25-Jun-25 Delete Actual Sales
FCTRY012 CREDIT SALE 10490000153 FCTRY012-153 25-Jun-25 Delete Actual Sales
FCTRY012 CREDIT SALE 10490000141 FCTRY012-140 24-Jun-25 Delete Actual Sales
FCTRY012 CREDIT SALE 10490000022 FCTRY012-22 12-Jun-25 Delete Actual Sales
FCTRY012 CREDIT SALE 10490000022 FCTRY012-22 12-Jun-25 Delete Actual Sales
FCTRY012 CREDIT SALE 10490000166 FCTRY012-166 26-Jun-25 Delete Actual Sales
FCTRY012 CREDIT SALE 10490000166 FCTRY012-166 26-Jun-25 Delete Actual Sales
FCTRY012 CREDIT SALE 10490000024 FCTRY012-24 16-Jun-25 Delete Actual Sales
FCTRY012 CREDIT SALE 10490000006 FCTRY012-6 3-Jun-25 Delete Actual Sales
Party GSTIN Party Name Party State Tax Name Tax %
27AAAPC5854E1Z1 ADARSH MAH GST 5% 5
27FJMPB0587F1Z4 DARSHAN MAH GST 18% 18
27FJMPB0587F1Z4 DARSHAN MAH GST 18% 18
24ACPPG7463C1ZN GOA S KAJUWALLA MAH GST 12% 12
26AABCJ1029L1ZO [Link] PRIVATE LIMITED (JKSR) DNH GST 5% 5
27AANCM8036A1ZH MAHAVIR CASHEW AND FOODS PVT. LTD. MAH GST 12% 12
27AANCM8036A1ZH MAHAVIR CASHEW AND FOODS PVT. LTD. MAH GST 18% 18
27AANCM8036A1ZH MAHAVIR CASHEW AND FOODS PVT. LTD. MAH GST 5% 5
27AACFN2364C1ZM NATURAL SWEETS MAH GST 5% 5
27ACQPG8909E1ZB OM DRYFRUITS MAH GST 5% 5
27ACQPG8909E1ZB OM DRYFRUITS MAH GST 18% 18
27AAEPM4542K1ZJ PEPPILLON (LALBAG) MAH GST 18% 18
27AOPPS5741B1ZP Relish Enterprises MAH GST 18% 18
27AOPPS5741B1ZP Relish Enterprises MAH GST 12% 12
27ACPPG7463C1ZH ROYAL DRY FRUIT RANGE (538) MAH GST 12% 12
27ACPPG7463C1ZH ROYAL DRY FRUIT RANGE (538) MAH GST 18% 18
27AAAPT5433A1Z1 SHREEJI DRY FRUITS (MD) MAH GST 5% 5
27AAAPT5433A1Z1 SHREEJI DRYFRUIT (BORIVALI) MAH GST 5% 5
Taxable Amt Tax Amt IGST Amt CGST Amt SGST Amt Net Amt
3,961.91 198.09 - 99.05 99.05 4,160.00
1,016.95 183.05 - 91.53 91.53 1,200.00
1,275.25 164.75 - 114.77 114.77 1,440.00
2,142.86 257.14 - 128.57 128.57 2,400.00
4,000.00 200.00 200.00 100.00 100.00 4,200.00 not consider
857.14 102.86 - 51.43 51.43 960.00
1,220.34 219.66 - 109.83 109.83 1,440.00
1,508.57 75.43 - 37.71 37.71 1,584.00
8,428.58 421.42 - 210.71 210.71 8,850.00
990.48 49.52 - 24.76 24.76 1,040.00
1,220.34 219.66 - 109.83 109.83 1,440.00
1,423.73 256.27 - 128.14 128.14 1,680.00
1,830.51 329.49 - 164.75 164.75 2,160.00
2,142.86 257.14 - 128.57 128.57 2,400.00
2,142.86 257.14 - 128.57 128.57 2,400.00
2,033.90 366.10 - 183.05 183.05 2,400.00
3,200.00 160.00 - 80.00 80.00 3,360.00
609.52 30.48 - 15.24 15.24 640.00

You might also like