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...
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...
MATCH(B5,’GSTR-2A’!$E$5:$E$23,0):TheMATCHfunction locates the position of the specified value (B5) within the range (‘GSTR-2A’!$E$5:$E$23). INDEX(‘GSTR-2A’!$F$5:$F$23,MATCH(B5,’GSTR-2A’!$E$5:$E$23,0)):TheINDEXfunction the retrieves the value from the ...
Offset(, 1).Resize(xRg.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)...
GSTR-9 is a document or a statement that has to be filed once a year by the registered taxpayer irrespective of the turnover of an entity. To file GSTR-9,
1. How to create an interactive Excel chart This section describes how to create an interactive chart, the user may press with left mouse button on a button or multiple buttons and the chart shows corresponding data based on the selected buttons. Slicers were introduced in Excel 2010, see im...
GSTR 1 is a form to submit business details of outward supplies before the GSTR 1 due date i.e. 10th of every month. Find out the format and a step by step guide for how to file GSTR 1.
Step 1: Logging in to the GST Portal Access thewww.gst.gov.inURL. The GST home page will be displayed. Here, you will have to log in to the GST Portal with valid credentials. Logging into GST home page to file GSTR-3B returns ...
Method 1 – Using Excel VBA Macro to Automatically Send Email from Outlook to the Selected Recipients Steps: Go to theInserttab. SelectShapes. Select any of the offered shapes (i.e.,Rectangular: Rounded Corners). Drag thePlus Iconwherever you want to insert theShapeas shown in the image be...
But with TallyPrime at your fingertips, you don’t have to worry about reconciliation at all. You only have to download your GSTR-2A data in TallyPrime, and the relevant details from the portal will appear seamlessly in the GSTR-2A Reconciliation report, along with the details in your ...