No. of Recipients (In Excel A3)
=SUMPRODUCT((A5:A200<>"")/COUNTIF(A5:A200,A5:A200&""))
No. of Invoices (In Excel C3)
=SUMPRODUCT((C5:C200<>"")/COUNTIF(C5:C200,C5:C200&""))
Total invoice value (In Excel E3)
=SUMPRODUCT(1/COUNTIF(C5:C200,C5:C200&""),E5:E200)
Total Taxable value (In Excel L3)
=SUM(L5:L200)
Example
In this Video we will see Important Formula that are used in GSTR 1 Offline tool
In this video we will see how to Convert Gstr 4A json file to Excel. It is very useful when we file Gstr 4 Annual return for Composition taxpayer
Form GSTR-4A is an auto-drafted and view only form for composition taxpayer, created on basis of data from the saved/submitted/filed Form GSTR-1 & 5 of their suppliers, where composition taxpayer is the recipient. The composition taxpayer cannot take any action in Form GSTR-4A and this form is only for view.
PAN and Legal Name is not matching with CBDT database / How to find Correct PAN card Name in NSDL database
https://youtu.be/Xz9kle-6hUQ How to add Mobile number and Email id to PAN card in Tamil (2021) https://youtu.be/wopLKwQy6zc Reprint PAN card in Tamil (2021) | How to get New PAN card in Tamil NSDL? https://youtu.be/VOZwXJewFno Correction / Reprint PAN card in Tamil (2021) | How to get New PAN card in Tamil UTIITSL? https://youtu.be/uMXa01YyUbU Link Aadhar Card with PAN card https://youtu.be/Bd2uc38AXHsIn this video we will see about Updation of mobile number and email id in PAN card ( Tamil )
Link Aadhar with PAN (income tax india e filing Link) https://www1.incometaxindiaefiling.gov.in/e-FilingGS/Services/LinkAadhaarHome.html Mobile Email updation (NSDL) Website link https://www.onlineservices.nsdl.com/paam/endUserAddressUpdate.html Mobile Email updation (UTIITSL) Website link https://www.myutiitsl.com/PAN_ONLINE/homeaddresschange NSDL if Mobile otp or Email otp not received then use "click here" link and update mobile number using change request in PAN card Other PAN card related Videos How to Link Aadhar Card with PAN card https://youtu.be/Bd2uc38AXHs PAN and Legal Name is not matching with CBDT database https://youtu.be/Xz9kle-6hUQ Reprint PAN card in Tamil (2021) | How to get New PAN card in Tamil NSDL? https://youtu.be/VOZwXJewFno Correction / Reprint PAN card in Tamil (2021) | How to get New PAN card in Tamil UTIITSL? https://youtu.be/uMXa01YyUbUIn this video we will see about GSTR 3B in tamil
Other videos Gstr 3B - RCM in Tamil (2021) https://youtu.be/1I0yTqVkVPI Gst PMT 09 Transfer of Amount/How to use Electronic Cash ledger ?? https://youtu.be/lD4xX0TSV1U GST PMT 07 |Amount debited from your bank account But Gst Portal again Goes to Make payment Page https://youtu.be/vacWgWW9GS4 How to use Electronic Credit Ledger https://youtu.be/dB2AbEiBRBE Gst DRC - 03 Form in Tamil (2021) https://youtu.be/7pRwiMxRpbEIn this video we will see about Reprint of New PAN card in Tamil
Link Aadhar with PAN (incometaxindiaefiling Link) https://www1.incometaxindiaefiling.gov.in/e-FilingGS/Services/LinkAadhaarHome.html UTIITSL https://www.pan.utiitsl.com/PAN/csf.html or https://www.pan.utiitsl.com/PAN/mainform.html Other Videos How to Link Aadhar Card with PAN card https://youtu.be/Bd2uc38AXHs PAN and Legal Name is not matching with CBDT database https://youtu.be/Xz9kle-6hUQ Reprint PAN card in Tamil (2021) | How to get New PAN card in Tamil NSDL? https://youtu.be/VOZwXJewFnoIn this video we will see How to add HSN wise summary in GSTR 1 Offline method (in Tamil) (2021)
How to add HSN wise Summary Online Method https://youtu.be/VljWZgT2PP8 GST Offline Tool https://youtu.be/SFXnNI2vrhA Gstr 1 Filing using offline tool https://youtu.be/VhnOJSfoucI GST IFF ( Invoice Furnishing Facility ) https://youtu.be/GFQ6tGHB6T0 How to Resolve Error in Gstr 1 (in Tamil)(2021) | Error! You have no summary to submit GSTR1 https://youtu.be/FJiK4TLdBm0In this video we will see about HSN wise Summary ( Table 12 of Gstr 1 ) which is Mandatory From April 1st 2021
GST Offline Tool https://youtu.be/SFXnNI2vrhA Gstr 1 Filing in Tamil https://youtu.be/jpfga2--pQI File your Gstr1 For Feb 2021 (Due Date 11/03/2021) https://youtu.be/sFx9xJjC9XQ GST IFF ( Invoice Furnishing Facility https://youtu.be/GFQ6tGHB6T0 Gstr 1 Filing using offline tool https://youtu.be/VhnOJSfoucI How to Resolve Error in Gstr 1 (in Tamil)(2021) | Error! You have no summary to submit GSTR1 https://youtu.be/FJiK4TLdBm0 Gstr 3B - RCM in Tamil (2021) https://youtu.be/1I0yTqVkVPIIn this video we will see about new update in GST portal in tamil
GST IFF ( Invoice Furnishing Facility https://youtu.be/GFQ6tGHB6T0 GST - QRMP Scheme ( in Tamil ) ( 2021 ) https://youtu.be/XsrU5-2GRpYIn this video we will see about Reprint of New PAN card in Tamil
Link Aadhar with PAN https://www1.incometaxindiaefiling.gov.in/e-FilingGS/Services/LinkAadhaarHome.html How to Link Aadhar Card with PAN card https://youtu.be/Bd2uc38AXHs PAN and Legal Name is not matching with CBDT database https://youtu.be/Xz9kle-6hUQIn this video we will see How to change Registered mobile number and email id in gst Portal in Tamil
Amendment of Registration Non Core Fields https://youtu.be/XidYQo5HsIk GST - Amendment of Registration Core Fields (in Tamil) (2021) https://youtu.be/RfVYsOanYhE How to add Additional Place of Business in Gst Portal in Tamil (2021) https://youtu.be/11NIM7yzhSE Core Business Selection | New Update in Gst Portal https://youtu.be/Fj3_DwpdPkgLast date to Linking of Aadhaar with PAN number is extended to 30th June 2021
Link Aadhar with PAN https://www1.incometaxindiaefiling.gov.in/e-FilingGS/Services/LinkAadhaarHome.html How to Link Aadhar Card with PAN card https://youtu.be/Bd2uc38AXHs PAN and Legal Name is not matching with CBDT database https://youtu.be/Xz9kle-6hUQIn this video we will see Ending task for GST for FY 2020-2021 and New updates in GST Portal which is applicable from 1st April 2021
PDF : https://www.cbic.gov.in/resources//htdocscbec/gst/Registration_under_GST_Law.pdf
In this video we will see How to add additional Place of Business in GST Portal
Form DRC-03 is used for making a voluntary payment of tax. Voluntary payment can be made either:
All the payments need to be made either from input tax credit available in electronic credit ledger or cash balance available in the electronic cash ledger. But, in case of interest and penalties ITC utilisation is not available. It has to be compulsorily paid in cash.
In this video we will see about DRC - 03 Form in tamil.
In this video we will see How to file Gstr 3b for Rcm Supplier and Recipient in Tamil
Generally, the supplier of goods or services is liable to pay GST. However, in specified cases like imports and other notified supplies, the liability may be cast on the recipient under the reverse charge mechanism. Reverse Charge means the liability to pay tax is on the recipient of supply of goods or services instead of the supplier of such goods or services in respect of notified categories of supply
PDF : https://www.cbic.gov.in/resources//htdocs-cbec/gst/51_GST_Flyer_Chapter12.pdf
In this video we will see How to file Gstr 1 in Tamil.
0:32 - Gstr 2A
1:28 - Table 4A,4B,4C,6B,6C
1:47 - Table 5A,5B
2:00 - Table 6A, 9A, 9B, 9C
2:48 - Table 7
3:08 - Table 8A,8B,8C,8D
3:44 - Table 11
3:52 - Table 12 Hsn wise Summary
4:51 - Table 13
5:07 - Table 10
GST Offline Tool
https://youtu.be/SFXnNI2vrhA
Gstr 1 Filing using offline tool
https://youtu.be/VhnOJSfoucI
GST IFF ( Invoice Furnishing Facility )
https://youtu.be/GFQ6tGHB6T0
How to Resolve Error in Gstr 1 (in Tamil)(2021) | Error! You have no summary to submit GSTR1
https://youtu.be/FJiK4TLdBm0
In this video we will see about PMT 09 Transfer of amount in tamil
In this video we will see about Google docs in Tamil. With this Google docs you can easily type documents in any language.
In this video we will see how to raise query/issue to CBIC department in Tamil
In this video we will see how to resolve mismatch error in Gstr 9 in Tamil.
In this video we will see about Locate GST Practitioner in tamil.
File your Gstr1 For Feb 2021 before March 11 2021 (Due Date 11/03/2021)
Late filing of Gstr1 Return will attract late feeIn case your name in the Aadhar card is wrongly spelt
In this Video we will see about new update in gst portal.
In this video we will see about Upcoming changes in Table 12 of Gstr 1 which is applicable From April 1st 2021
In this video we will see about Amendment of Registration Non Core Fields in Tamil.
Non Core fields
In this video we will see about Annual Return Gstr 9.
Today (28/02/2021) is the last day to file you are annual return GSTR 9 and 9C late fee : 100 per day Gstr 9 ( Mandatory ) : If Turnover is above 5 crores otherwise Optional Gstr 9c ( Mandatory ) : If Turnover is above 5 crores otherwise OptionalIn this video we will see about How to How to Resolve Error in Gstr 1 in Tamil. This Error is coming because we have not mentioned any invoice details under GSTR 1.
To resolve this Error add at least one line item with zero value, then only system will allow us to file the return.In this video we will see how effectively use electronic credit ledger in tamil. The electronic credit ledger reflects the amount of Input Tax Credit available to the taxpayer. Every claim of input tax credit of the registered taxpayer eligible for claiming such a credit is credited to this ledger
QRMP Scheme in Tamil
https://youtu.be/XsrU5-2GRpY In this video we will see about IFF ( Invoice Furnishing Facility ) in Tamil The IFF is an optional facility There is no requirement to upload invoices in GSTR 1 if the same has been uploaded in the IFF.In this video we will see about GSTR 1 Filing using Offline tool. With the help of Excel we can easily Reconcile GSTR 1. This video will help for small taxpayers.
In this video we will see about Final return GSTR 10
Who should file GSTR 10? Due date for GSTR 10? Late fee??In this video we will see about gst registration error PAN and Legal Name is not matching with CBDT database in tamil
In this video we will see about Amendment of Registration Core Fields in Tamil.
Core fieldsIn this Video we will see about different type of Supply in GST
In this video we will see about New update on Table 6A of GSTR-1. In GST exports are considered as zero-rated supplies. Export of goods under GST means taking the goods out of India to a place outside India. Exporters can claim the refund of IGST paid on all types of exports except where specifically not available.
In this video we will see about changing of Mobile number in SBI netbanking in Tamil. It's very easy if you having Netbanking.
In this video we will see about Online nomination in Yono Lite SBI app. It is very easy to Add nominee/Cancel Nominee/ Change Nominee at 1 min.
In this video we will see about what is Gst and what is Income tax. This video talk about difference between Gst and Income Tax and who should register under Gst and who should file Income tax return.
Difference Between GST and Income Tax
The main difference between GST and Income tax is, GST is levied on consumption of goods and services whereas Income tax is levied on income earned in a financial year.
GST is the indirect tax paid to the government whereas Income tax is the direct tax paid to the government.
GST is levied only on buying a product and using a service whereas Income tax is levied on salary, house, revenue from a business, income from capital gain.
The tax burden of GST shifts from the manufacturer to the consumer whereas no such transfer can happen in income tax if a person earns income which reaches the benchmark of taxation, he/she is liable to pay the Income tax.
GST registration is mandatory if a company makes an annual turn over of 20/40/10 lakhs per year while Income tax is levied on individuals if the annual salary is more than 2.5 lakhs.
In this video we will see about you QRMP scheme in Tamil. QRMP scheme is for small taxpayers to file their GSTR-1 and GSTR-3B returns on quarterly basis.
In this video we will see about GST offline tool in Tamil.
Section 17(5) Blocked credit
Motor vehicles for transportation of persons having approved seating capacity of not more than thirteen persons (including the driver), except when they are used for making the following taxable supplies 1. Further supply of such motor vehicles ITC is allowed even if seating capacity up to 13 persons and used for further taxable supply of such vehicles 2. Transportation of passenger ITC is allowed even if seating capacity up to 13 persons and used for transportation of passengers which are taxable 3. Further supply of such goods ITC of Motor vehicles used in Goods Transportation is always allowed. 4. Imparting training on driving such motor vehicles ITC is allowed even if seating capacity up to 13 persons and used for imparting taxable trainingForm GST PMT 07 - This form is to report about discrepancy where amount has been debited from account of taxpayer, but Electronic Credit Ledger is not updated.
In this video we will see about cancellation of GST registration in Tamil. Cancellation of GST registration means that the taxpayer will not be a GST registered person any more.
When a Taxpayer Can Cancel the GST registration? 1. Discontinuance or closure of the business 2. Taxable person ceases to be liable to pay tax 3. Transfer of business on account of amalgamation, merger de-merger, sale, leased or otherwise 4. Change in constitution of business leading to change in PAN Registered voluntarily but did not commence any business within specified time 5. A taxable person not liable any longer to be registered under GST actகீழ்க்கண்ட காரணங்களுக்காக ஜிஎஸ்டி பதிவு ரத்து செய்யப்படும்
உரிமையாளர் மாறும்போது நல்லது வணிகம் முழுமையாக நிறுத்தப்படும் போது அல்லது ஒன்றிணைக்க படும்போது..
உரிமையாளர் இறந்துவிட்டால்..
வரி செலுத்தும் நபர் சரக்கு மற்றும் சேவை வரி சட்டத்திற்கு புறம்பாக செயல்படும் போது..
தன்னார்வ பதிவு செய்தவர் பதிவு செய்த தேதியிலிருந்து 6 மாதங்களுக்குள் அலுவல் தொழில் தொடங்காமல் இருக்கும் போது..
மோசடியாக வேண்டுமென்றே தவறான விவரம் அல்லது உண்மை விவரங்களை மூடிமறைத்து அதன் மூலமாக பதிவு பெற்றால் பதிவு ரத்து செய்யப்படும்
ஜிஎஸ்டி பதிவினை ரத்து செய்த பின் அதனை திரும்ப பெறுவதற்கு செய்ய வேண்டியவை
பதிவினை ரத்து செய்த தேதியிலிருந்து 30 நாட்களுக்குள் பதிவு ரத்து செய்ததை விலக்குவதற்காக விண்ணப்பிக்கலாம்
அலுவலர் பதிவு ரத்து செய்ததை விலக்கலாம் அல்லது விண்ணப்பத்தை நிராகரிக்கலாம்
