Saturday, October 28, 2017

GSTR-2 :- EXCEL EXPORT AND IMPORT FROM GST UTILITY

Friends Govt has released new GST Offline Tool utility Version 2.1 which is compatible with Excel. It can export data in excel and have capacity to import from Excel directly. Overview detail of the same if given below :-

Overview

The Offline Tool version 2.1 has been designed to enable taxpayers to prepare GSTR-1 and GSTR-2 return by adding invoice and other details and by taking action on the auto-drafted counterparty submitted details in the tool in offline mode(without internet).

The Offline Tool version 2.1 supports

GSTR-1: New Invoice and Other details Addition/Deletion

Registered Business to Registered Business (B2B), Business to Consumer inter-state for amount exceeding Rs 2.5 Lakhs (B2CL), Business to Consumer less than Rs. 2.5 Lakhs (B2CS), Exports, Credit/ Debit Note (CDNR) and Credit/ Debit Note for unregistered Persons (CDNUR), Advances (AT), Advance Adjustments (ATADJ) and HSN Summary. The data for sections Nil Rated/ other Exempted/ Non GST and Documents issued has to be entered on the GST portal directly.

GSTR-2:

Missing Invoice (New and Saved) and Other details addition/DeletionRegistered Business to Registered Business (B2B), Unregistered Person to Registered Business (B2BUR), Import of Services (IMPS), Import of inputs/Capital Goods from Overseas/SEZ (IMPG), Credit/ Debit Note (CDNR) and Credit/ Debit Note for unregistered Persons (CDNUR), Advances (AT), Advance Adjustments (ATADJ), Supplies from composition taxable person and Nil supplies (Exemp), ITC reversal/reclaim (ITCR) and HSN Summary. ISD credit received will be included in GSTR 2 on the portal and will be part of preview.

Direct Data entry of invoice data and other details in the tool as required under various categories for selected return type into the tool.

The tool has functionality to check duplicate records in file created for the lot.

Taxpayer can input data of invoices using Excel Workbook (*.xlsx/xls) with separated worksheets for each section of return for inputting invoice data and import the same into the tool. Data of all sections can be imported in the tool in one go.

Data can also be copied from the excel template in the window provided in the offline tool

Taxpayer can also use the CSV file (Comma delimited (*.csv)) to import section wise invoice details into the tool.

Taxpayer can download the invoice and other details from GST portal and take action on submitted counterparty invoices in the tool.

Taxpayer can export the downloaded details from offline tool to Excel for taking the actions of Accept/Reject/Modify/Pending on auto-populated submitted invoices/debit/credit note and addition of missing invoices and auto-populated saved details.

One of the above four actions need to be taken mandatorily on all submitted invoices otherwise GSTR 2 submission will throw an error.

The GST portal will not permit addition of invoices which are available with submitted status in a taxpayers GSTR 2.

Tool generates a file in JSON format, which needs to be saved for later upload on the GST Portal.

Uploaded details can be corrected by downloading and editing or deleting the invoices. Invoices can be deleted in through bulk selection. All data of a section can also be deleted in one go.

The file generated by tool will have to be uploaded on the GST portal. At this time internet connectivity will be required.

E-filing of your return (GSTR-1 and GSTR-2) consist of following steps:

Generation of JSON file with invoice data and other details as per the selected return type in the offline tool.

Creation of your return summary for all data, uploaded in multiple tranches, on GST Portal and this will be an online activity.

Verifying the summary on the Portal through preview and if correct submitting the return

Filing the return with applicable electronic signature ( DSC/EVC)

Important Note: If the JSON file size is more than 5MB the tool creates multiple JSON files in a ZIPPED format. The Zipped file needs to be unzipped and the multiple JSON file need to be uploaded on the portal, one at a time.

Benefit of Excel functions :-

Now data can save/accept/reject/pending partially in Excel and work later.

Consultants can handover detailed excel file to their clients for working.