How to File GSTR-3B for Amazon Sellers|File GSTR3B using PIVOT Table in Excel|Credit Note|TCS Credit
9.7 هزار بار بازدید -
4 سال پیش
-
How to File GSTR-3B for
How to File GSTR-3B for Amazon Sellers|File GSTR3B using PIVOT Table in Excel|Credit Note|TCS Credit
#sellingonamazonforbeginners #sellingonamazon #gstr3b @cadeveshthakur
Dear Viewers,
In this video, we have discussed how Amazon sellers can file their GSTR3B with easy mode. How to file GSTR-3B using PIVOT Table in Excel. File your GSTR-3B error-free with no need for Accounting software.
Download Excel from here:
https://bit.ly/EcommerceExcel
or
https://www.cadeveshthakur.com/gst-co...
Time Slots:
Introduction [00:00 to 04:40]
Understand GSTR-3B Requirements [04:40 to 14:16]
Explore Amazon Dashboard for GST related Reports [14:16 to 18:30]
Understand Amazon MTR B2C Report [18:30 to 22:24]
Understand Amazon MTR B2B Report [22:24 to 25:55]
Consolidate All three Data Files i.e. Sales Report including B2C & B2B and Sales Return Report [25:55 to 31:00]
Use of PIVOT Table and prepare final excel sheet for filing GSTR-3B [31:00 to 38:48]
IMP: How to collect eligible ITC from Amazon (different sources of ITC, Implication of Credit Note issued by Amazon, Implication of Additional Tax Invoices issued by Amazon other than those that are visible on sellers’ dashboard) [38:48 to 46:10]
How to file GSTR-3B from the Prepared Data. [46:10 to 49:25]
After watching this video, the viewer can know
1. How online sellers can file their GSTR-3B using PIVOT Table in Excel.
2. How to download various GSTR related reports.
3. How to consider Tax invoices that are not reflected under the Seller dashboard.
4. How to Claim ITC on additional Invoices.
5. In how many ways Online sellers can claim ITC.
6. How to deal with Credit Note issued by Amazon.
7. Implications of Credit Note on TDS and in GST.
8. How to consolidate various excels in one single file for the generation of GSTR3B data.
9. How to use PIVOT Table.
10. How to file GSTR-3B
#howtofilegstr3b
#howtofilegstr3bonline
#howtofilegstr3breturn
#howtofilegstr3bnilreturnonline
#howtofilegstr3bingstporta,
#howtofilegstr3bforamazonsellers
#howtofilegstr3bincaseofexport
#howtofilegstr3beligibleitc
#howtofilegstr3bforexportsales
#howtofilegstr3bforecommerce
#howtofilegstr3bforamazon
#howtofilegstr3binhindi
#howtofilegstr3binhindilatest
#howtofilegstr3blatestvideo
#howtofilegstr3bmonthlyreturn
#howtofilegstr3bonlineinhindi
#howtofilegstr3bonlinestepbystep
#howtofilegstr3breturnonline
#howtofilegstr3breturnonlinelatest
#howtofilegstr3breturnonlineinhindi
#howtofilegstr3bstepbystep
#howtofilegstr3bwithitc
#howtofilegstr3b2020
#filegstr3bwithexcel
#howtofilegstr3busingpivottable
#howtofilegstr3busingexcel
#howtodealwithcreditnote
#pivottable
#gstr3bwithexcel
#gstr3bwithpivottable
#sellingonamazonforbeginners #sellingonamazon #gstr3b @cadeveshthakur
Dear Viewers,
In this video, we have discussed how Amazon sellers can file their GSTR3B with easy mode. How to file GSTR-3B using PIVOT Table in Excel. File your GSTR-3B error-free with no need for Accounting software.
Download Excel from here:
https://bit.ly/EcommerceExcel
or
https://www.cadeveshthakur.com/gst-co...
Time Slots:
Introduction [00:00 to 04:40]
Understand GSTR-3B Requirements [04:40 to 14:16]
Explore Amazon Dashboard for GST related Reports [14:16 to 18:30]
Understand Amazon MTR B2C Report [18:30 to 22:24]
Understand Amazon MTR B2B Report [22:24 to 25:55]
Consolidate All three Data Files i.e. Sales Report including B2C & B2B and Sales Return Report [25:55 to 31:00]
Use of PIVOT Table and prepare final excel sheet for filing GSTR-3B [31:00 to 38:48]
IMP: How to collect eligible ITC from Amazon (different sources of ITC, Implication of Credit Note issued by Amazon, Implication of Additional Tax Invoices issued by Amazon other than those that are visible on sellers’ dashboard) [38:48 to 46:10]
How to file GSTR-3B from the Prepared Data. [46:10 to 49:25]
After watching this video, the viewer can know
1. How online sellers can file their GSTR-3B using PIVOT Table in Excel.
2. How to download various GSTR related reports.
3. How to consider Tax invoices that are not reflected under the Seller dashboard.
4. How to Claim ITC on additional Invoices.
5. In how many ways Online sellers can claim ITC.
6. How to deal with Credit Note issued by Amazon.
7. Implications of Credit Note on TDS and in GST.
8. How to consolidate various excels in one single file for the generation of GSTR3B data.
9. How to use PIVOT Table.
10. How to file GSTR-3B
#howtofilegstr3b
#howtofilegstr3bonline
#howtofilegstr3breturn
#howtofilegstr3bnilreturnonline
#howtofilegstr3bingstporta,
#howtofilegstr3bforamazonsellers
#howtofilegstr3bincaseofexport
#howtofilegstr3beligibleitc
#howtofilegstr3bforexportsales
#howtofilegstr3bforecommerce
#howtofilegstr3bforamazon
#howtofilegstr3binhindi
#howtofilegstr3binhindilatest
#howtofilegstr3blatestvideo
#howtofilegstr3bmonthlyreturn
#howtofilegstr3bonlineinhindi
#howtofilegstr3bonlinestepbystep
#howtofilegstr3breturnonline
#howtofilegstr3breturnonlinelatest
#howtofilegstr3breturnonlineinhindi
#howtofilegstr3bstepbystep
#howtofilegstr3bwithitc
#howtofilegstr3b2020
#filegstr3bwithexcel
#howtofilegstr3busingpivottable
#howtofilegstr3busingexcel
#howtodealwithcreditnote
#pivottable
#gstr3bwithexcel
#gstr3bwithpivottable
4 سال پیش
در تاریخ 1399/03/25 منتشر شده
است.
9,793
بـار بازدید شده