Deprecated: Unparenthesized `a ? b : c ? d : e` is deprecated. Use either `(a ? b : c) ? d : e` or `a ? b : (c ? d : e)` in /homepages/44/d793335463/htdocs/pro/wp-content/themes/kleo/kleo-framework/lib/function-core.php on line 570

Notice: fwrite(): write of 13 bytes failed with errno=122 Disk quota exceeded in /homepages/44/d793335463/htdocs/pro/wp-content/plugins/wp-file-manager/file_folder_manager.php on line 62

Warning: ftp_nlist() expects parameter 1 to be resource, null given in /homepages/44/d793335463/htdocs/pro/wp-admin/includes/class-wp-filesystem-ftpext.php on line 420

Warning: ftp_pwd() expects parameter 1 to be resource, null given in /homepages/44/d793335463/htdocs/pro/wp-admin/includes/class-wp-filesystem-ftpext.php on line 230

Warning: ftp_pwd() expects parameter 1 to be resource, null given in /homepages/44/d793335463/htdocs/pro/wp-admin/includes/class-wp-filesystem-ftpext.php on line 230

Warning: ftp_nlist() expects parameter 1 to be resource, null given in /homepages/44/d793335463/htdocs/pro/wp-admin/includes/class-wp-filesystem-ftpext.php on line 420

Warning: ftp_pwd() expects parameter 1 to be resource, null given in /homepages/44/d793335463/htdocs/pro/wp-admin/includes/class-wp-filesystem-ftpext.php on line 230

Warning: ftp_pwd() expects parameter 1 to be resource, null given in /homepages/44/d793335463/htdocs/pro/wp-admin/includes/class-wp-filesystem-ftpext.php on line 230
GSTR 1 Excel Sheets & Guide | Company Vakil
  • GSTR1 is a monthly return that is to be filed by each and every registered dealer. It mainly contains the detail of all the sales made by the dealer.

Steps for getting a GSTR 1

  • Once you have filled in your Email id, a GSTR 1 form will be sent to your inbox for download
  • Create excel files after exporting data from your accounting software
  • Fill data in the Excel Templates
  • Import templates and your GSTR 1 will be automatically prepared

 

Note: Deadline of filing GSTR 1 form for July extends to 10th of September.

 

Return Period GSTR 1 GSTR 2 GSTR 3 GSTR 3B
July 2017 October 10 October 31 November 10 August 25
August 2017 October 5 October 10 October 15 September 20

 

How and When To Use Excel Templates

Note: We have tried to explain all the templates of each column to give you a better understanding of the information you might need to provide alongside sample values and instructions while filing your GST1 forms.

Excel Templates for Sales Documents:

01 – Sales Invoice and Bill of Supply: Provide all the required information in the template to ensure all invoice records supplied for your taxable and non-taxable goods and services such as sales invoices, bill of supply, invoices for export, sales that attract a reverse charge, etc.

02 – Outward Credit Debit Note: Give record of all credit and debit notes against the sales invoices into the template.

03 – Outward Advance Receipts: Record all the advance receipts received against the invoice awaiting to be issued in the template.

Excel Templates for Purchase Documents:

04 – Purchase Invoice and Bill of Supply: Fill into the template record of all invoices your supplier has issued for your taxable and non-taxable inward supplies of goods and services which may include purchase invoices, bill of supply, import invoices, and purchases that attracts a reverse charge.

05 – Inward Credit and Debit Note: Record all credit and debit notes against invoices of purchase and bill of supply issued by your supplier into the template.

06 – Inward Advance Payments: Record all the advance payments made against invoice that is yet to be raised.

Company vakil is one of largest legal platform that provides quality services to its customers. For more details on GST registration visit here

©2023 CV Legal Tech Services LLP. All Rights Reserved

CONTACT US

We're not around right now. But you can send us an email and we'll get back to you, asap.

Sending

Log in with your credentials

or    

Forgot your details?

Create Account