Full Process to Preview GSTR 9 Draft in Excel on GST Portal Step 1: Log in with username id & password on www.gst.gov.in to get started Step 2: Now coming to the dashboard, click on the ‘Annual Return’ tab Step 3: Opt for the financial year regarding the filing of returns, no...
Rows.Count, xRg.Columns.Count - 1) For I = 1 To xRgKey.Count If I > xRgKey.Count Then Exit For xStr = "" For J = 1 To xRgVal.Columns.Count xStr = xStr & " " & xRgVal(I, J) Next If xDic.Exists(xRgKey(I).Text) Then xDic(xRgKey(I).Text) = xDic(xRgKey(...
GSTR-2 and GSTR-3. This remains true even if the taxpayer has no business activity (Nil Return). For taxpayers who have chosen to file GSTR-1 orGSTR-2Bon a monthly or quarterly basis, GSTR-3B will be auto-generated by the
Select cell B4 as the cell to insert the table. Click OK. We will get all the combinations of the 2 columns. Notes: Here, we could not use the Close & Load command to load the Power Query table in the Excel sheet because we created the tables by applying Connection Only. So, we ...
Method 4 – Sending an Automatic Email from Excel to Outlook Using the HYPERLINK Function Use the following formula in cellH5. =HYPERLINK("MailTo:"&C5&"?Subject="&F5&"&cc="&$D$2&"&body="&G5,"Click Here") TheHYPERLINKfunction takes“MailTo:”&C5&”?Subject=”&F5&”&cc=”&$D$2...
Once your GSTR-3B details are final, you can easily export them to a JSON, CSV, or MS Excel file, and sign your return. In this way, you can easily keep a tab on your finalised return and prevent any tampering. If your signed transactions are modified, then you can easily spot ...
Please note: If you’ve opted for the Quarterly Return option, both Form GSTR-1 and Form GSTR-3B must be filed every quarter exclusively. How to Resolve Error in Table 8 (GSTR-1) Form Taxpayers are encountering challenges when organizing the Table 8 summary. This time, Table 8 has und...
“Unable to enlist in the transaction” with Oracle linked server from MS SQL Server [<Name of Missing Index, sysname,>] in non clustered index [Execute SQL Task] Error: The value type (__ComObject) can only be converted to variables of type Object. [ODBC Driver Manager] Data source nam...
!> in c# . Check is object null - What are the options? .Net 4 FileLoadException permissions problem With windows service .NET code to extract data from an excel sheet and create a text file having a specific format .Net Core 3.0 Console App. Microsoft.Data.SQLClient is not supported ...
GST compliance rating check is one of the key concepts brought by the government to bring the transparency in the taxation system of India. As introduced under section 149 of G Read More 01 Jan 1970Posted By: E-StartupIndia Reverse Charge under GST Under the reverse charge mechanism, the ...