GSTR-2 Excel Export and Import Utility from GST

Recently, 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/Deletion

Registered 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.

Take Action (Accept, Reject, Pending and Modify) on submitted counterparty details 

Registered Business to Registered Business (B2B), Credit/ Debit Note (CDNR)

Main features of Offline Tool:

• 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.
• Upload of generated JSON file to GST Portal (www.GST.GOV.IN)
• 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.
• Easy to select Accept / Reject or Pending in Excel.

Source: TDSTAXINDIA

Read More

Last date for filing GSTR-2 & GSTR-3 for July, 2017 extended to 30th Nov. & 11th Dec., 2017

GSTR-2 and GSTR-3 for July, 17 due date extended to 30th Nov.17 and 11th Dec.17

Recently Government has extend the last date for filing of GSTR-2 and GSTR-3 for July, 2017 to 30th Nov., 2017 and 11th December 2017 respectively in order to give more time to taxpayers and businesses for filing the return

In this regard Government will be issued a notification soon - to facilitate about 30.81 lakh taxpayers for filing GSTR-2 for month of July, 2017.

Read More

Last date for opting composition levy would be July 21, 2017

GST – CLARIFICATION ON MIGRATION, NEW REGISTRATION, OPTING FOR COMPENSATION SCHEME AND ISSUE OF BILLS OF SUPPLY

PRESS RELEASE, DATED 8-7-2017

The Rules related to Registration and Composition Scheme have been notified on 19th June, 2017. These Rules have been brought into effect from 22nd June, 2017. The intent of notifying these rules is to start the process of issue of registration certificate, called Goods and Services Tax Identification Number (GSTIN), to taxpayers who have already been issued provisional ID for registration(PID) as well as to the new taxpayers.

Any person who has been granted PID and who opts for composition scheme, should submit an intimation of option in a prescribed form on GSTN on or before 21st July, 2017.

Any persons who has PID may submit the required documents on GSTN for getting the certificate of registration. It is clarified that a period of three months is allowed to complete this procedure i.e. the formalities can be completed on or before 22nd September, 2017. In the interim, they can issue tax invoice using the PID already allotted to them.

A person seeking fresh registration can apply for registration within thirty days from the date on which he becomes liable for registration. They can also opt for composition scheme at the time of filing of registration form.

The applicant for grant of new registration can issue a bill of supply for supplying goods or services during the period from the date of liability to obtain registration till date of issuance of the registration certificate, if he has applied for registration within thirty days from the date he has become liable for registration. On grant of certificate of registration, he can issue revised tax invoices for the supplies made during this period.

Source: Taxmann

Read More

GST Enrollment Guide Excise and Service Tax releases - CBEC

As you are aware, the draft Model GST Laws and Rules have been placed in the public domain and CBEC is making all efforts for smooth implementation of GST by 1st April, 2017.  One of the priority tasks in this regard is the migration of existing CENTRAL EXCISE/SERVICE TAX Assessees to GST.

As per Sec.166 of the draft CGST Act read with relevant rules, every Central Excise/Service Tax assessee having a valid PAN shall be granted registration under GST regime on a provisional basis.  For such  assessees, GSTN shall generate provisional IDs and communicate the same to the assessees through CBEC for migration to the GST regime.  The Directorate General of Systems, CBEC has made necessary arrangement of communicating the provisional IDs along with passwords to the respective assessees in a secured manner through the ACES portal (www.aces.gov.in).  The entire procedure is described in the Guidance note to Departmental Officers at Annexure A to this letter.

Awareness companions/outreach programmes such as seminars and workshops may be arranged for taxpayers to facilitate this exercise.  Details, including photographs, of such seminars/workshops may be uploaded in the CBEC's INTRANET PORTAL-ANTARANG (https://antarang.icegate.gov.in) by the Zonal Chief Commissioners on a daily basis.  A separate TAB (titled: MIGRATION TO GST) is being created in ANTARANG to enable Chief Commissioners to upload the details of Seminars/Workshops.  Nodal Officers may be appointed at the Zonal/Commissionerate/Divisional level to assist the assessees in the migration process.  A communication to taxpayers is also enclosed (Annexure B) which may be shared to them at your level.
 

I would urge that you bestow your personal attention on this very important task and suitably guide the jurisdictional assessees to migrate to GST well in time.  Your personal involvement and monitoring would enable seamless migration of existing Central Excise/Service Tax Assessees to GST by the end of January, 2017.

Click Here for Details

Read More

Latest e-Hand Book on Revised GST Law - CA Pritam Mahure.

The Central Government is targeting to implementation the new indirect tax system w.e.f. April 1st, 2017, its called GST.

"The revised drafts of the Model GST Law, iGST Law, GST Compensation Law have been uploaded on our website (Central Board of Excise and Customs). These laws will be considered by the GST Council on December 2-3 and finalized,"

The revised drafts of three Goods and Service Tax laws have been released after incorporating suggestions from stakeholders, the government said on Saturday. These will now be placed before the Goods and Services Tax Council in its next meeting on December 2 and 3.

Revised GST law containing :

• Revised Model CGST /SGST Law
• Revised IGST Law
• GST Compensation Cess Law
• GST Rules for registration, payment, return, refund and invoices.

To Download Latest Free e-Handbook on Revised GST Law Click Here

Read More