Excel based Form GSTR-9C Offline Utility Released by CBIC - Taxsure Consultancy Services

Latest

Home Top Ad

Advertisement

Monday, April 15, 2019

Excel based Form GSTR-9C Offline Utility Released by CBIC




Excel based Form GSTR-9C Offline Tool Released by CBIC on April 14, 2019. GSTR-9C Offline  utility is designed to help auditor to prepare taxpayer’s GSTR-9C statement offline.



Your downloaded (GSTR9C Offline Tool) zip file contains:

  • GSTR_9C_Offline_Utility (Excel Macro)
  • Release Notes
2. Go to Downloads > Offline tools > GSTR-9C Offline Tool > Download button.
3. Unzip the downloaded Zip file which contain GSTR-9C Offline Tool, User Manual, Read Me.txt, Release Note.
4. Open the extracted folder and you will find a MS Excel file with Name “GSTR_9C_Offline_Utility.xls”.
5. Double Click on it to open.
6. Once opened, click on “Enable Editing” and “Enable Macros” and/or “Enable Content” button on top.
7. Now you can use the tool.
Installation
1. Access the GST Portal www.gst.gov.in.
Introduction to Excel based GSTR-9C offline tool:
1. The Excel based Form GSTR-9C Offline Tool is designed to help auditor to prepare taxpayer’s GSTR-9C statement offline.
“2. Details for following Tables of Form GSTR-9C statement can be added by auditor using the offline Tool.
Pt. II- Reconciliation of turnover declared in audited Annual Financial Statement with turnover declared in Annual Return (GSTR9).

Pt. II(5)- Reconciliation of Gross Turnover.
Pt. II(6)- Reasons for Un – Reconciled difference in Annual Gross Turnover.
Pt. II(7)- Reconciliation of Taxable Turnover.
Pt. II(8)- Reasons for Un – Reconciled difference in taxable turnover.
Pt. III- Reconciliation of tax paid
Pt. III(9)- Reconciliation of rate wise liability and amount payable thereon.
Pt. III(10)- Reasons for un-reconciled payment of amount.
Pt. III(11)- Additional amount payable but not paid (due to reasons specified under Tables 6,8 and 10 above).
Pt. IV- Reconciliation of Input Tax Credit (ITC)
Pt. IV(12)- Reconciliation of Net Input Tax Credit (ITC).
Pt. IV(13)- Reasons for un-reconciled difference in ITC.
Pt. IV(14)- Reconciliation of ITC declared in Annual Return (GSTR9) with ITC availed on expenses as per audited Annual Financial Statement or books of account.
Pt. IV(15)- Reasons for un – reconciled difference in ITC
Pt. IV(16)- Tax payable on un-reconciled difference in ITC (due to reasons specified in 13 and 15 above)
Pt. V- Auditor’s recommendation on additional Liability due to non-reconciliation .
PART – B- Certification”
b. Open GSTR-9C JSON Error File Downloaded from GST Portal: To open file downloaded from GST portal from the ‘Processed with error’ link. Upon successful import of the file details ‘processed with error’ records would be populated to respective tables of Excel workbook. The GST portal errors would be marked as red and can be shown in hover at red marked field.
c. Generate JSON File to Upload GSTR-9C details on GST Portal: To generate JSON file for upload of Form GSTR-9C details prepared offline on GST portal. The error file will also require to be signed by auditor again.
d. Generate Preview PDF file to view Draft GSTR-9C form: To preview in PDF format, Form GSTR-9C details as prepared offline on GST portal.
e. Validate Sheet: To Validate the data entered in respective worksheet of this offline Tool. Successful validation is notified to Taxpayer via pop-up while on failure of validation the cells that fail validation would be marked in Red. ”
b. Generate Json using ‘Generate JSON File to Upload’ option
c. Upload the generated JSON on GST Portal. Preview the details uploaded and File return on the GST portal
d. Open saved version (Yes/No):- If you select ‘No’ option then previously saved data not visible and if you select ‘Yes’ then saved data will be available in the respective worksheets”


3. The Offline tool has following features to help taxpayer in Return Preparation
a. Open GSTR-9C JSON file downloaded from GST Portal: To open Form GSTR-9C details (uploaded earlier) file – downloaded from GST portal into the Offline Tool. Upon successful import of file, the details wouldbe populated to respective tables of Excel workbook.
4. The high level process flow for GSTR-9C statement preparation is as follows
a. Validate the details filled in various tables using ‘validate’ button at the top of every sheet.
Please ensure you download the latest version of GSTR-9C Offline Tool.


Source: #GSTN Portal

SHOP KARO CASH KARO





No comments:

Post a Comment

Post Bottom Ad

>