Gstr 3b format download in excel

Details of outward and inward supplies made during. For the reconciliation purpose it will be easier to download in excel version. After submitting your email id, download gstr 1 files from your inbox. In this section, taxpayers need to enter their total taxable value, i.

Go to gstr1 page in octa gst and add the gstr1 return files. The consolidated gstr3b report gives a year to date, monthwise summary of all your gstr3b data from the government portal. What is gstr 3b how to file gstr 3b format, due date. Gstr 1 and gstr 3b return in excel auto calculation format. It only requires total values for each field, like a summary, for. Taxable outward supplies to a consumer where place of supply state code is other than the state where supplier is located interstate supplies and invoice value is more than rs 2. Details of sales and purchases which are liable for reverse charge.

Use the intuitive interface of ms excel to manage your gst compliance. Gstr 3b and gstr 1 reconciliation sheet in excel format. Download gstr 3b computation with optimum igst utilization ms. Also, there are tailormade gstr 3b pdf templates available for download. Preparing gstr3b return using excel based offline utility and gstr3b json upload on gst portal.

Gstr 9 in excel format with instructions tax house india. Correct mistakes if any that is prompted by the excel sheet. Yes, it is necessary to download json file from the gst portal. Click here to download the gstr 9a in excel format with instructions. The gstr 3b format has the details of gstin, name of the person, outward taxable supplies, inward supplies, itc, payment of tax, the collected and deducted tds and tcs. Gstr 3b computation with optimum igst utilization ms excel.

Download gstr 3 form in excel format gst monthly return other than compounding taxpayer and. Gstr1 vs gstr2a vs gstr3b consolidated comparison report. How to download gstr 9 offline utility in excel format on. All the templates contain detailed explanation of each column to help you understand what. Gstr3b offline utility downloadjason upload on gst portal. Download gstr2 in excel format sumathi, 9th june 2017 16th june 2017, gstr 2, download gstr2, download gstr2 in excel format, 1. Easy way for reconciliation of gstr 2a with gstr 3b. Json file thus downloaded helps in fetching the systemcomputed gstr 9 data based on gstr1 and form.

How to file gstr2 and download data from gstr2a in the. Download gstr2 in excel format archives reach accounting. A separate gstr 3b form has to be filed for each gstin. It also provides an excel utility tool for filing gstr 3b in excel also. Download gstr 3 form in excel format gst monthly return other than compounding taxpayer and isd. Select the required options in the gstr3b dashboard to view the relevant sections of gstr3b in the next screen. Download the format of gstr 3b and learn to file it online. Now it has been extended upto december 2017 by the gst council meeting on 9 th september 2017. Optimum utilization of input tax credit is automatically. Gstr3b is a simplified summary return and the purpose of the return is for taxpayers to declare their. However, you may download the offline utility from the below link. The offline utility contains the excel format which you require to prepare the return in offline mode. Income tax calculator new scheme vs old scheme and consent letter for fy 202021. Gstr1 return can be exported in the required excel format for any given period.

All type of free download gst bill format in excel, word, pfd and other bill format like. Download the gstr1 json files from gst portal for the whole financial year. How to file gstr 3b download gstr3b in excel format. The file contains gstr 3b computation in ms excel with following functionality. The gstr 3b computation sheet in excel format has been updated with latest amendment in section 49a of cgst act, 2017 as amended by cgst amendment act, 2018.

Gstr 3b form does not require invoice level information. Download form gstr 3 in excel format gst monthly return format. Gstr 4 form is a annual filing form for all the composition scheme dealers whose annual. Whenever the goods or services of the supplier are buying and sale, a gst. So our office have started reconciliation of gstr 3b and gstr 1. Your comments and suggestions are highly appreciated. Gst is going to simplify the current system of tax and we are making it simpler for you by building an endtoend gst. Download gstr3 in excel format reach accounting software. Gst bill formatword, excel, pdf format free download. Download form gstr 3 in excel format gst monthly return. Gstr 3b is a simplified summary return and the purpose of the return is for taxpayers to declare their summary gst liabilities for the tax period and the discharge of these liabilities in a timely manner. At the 26th gst council meeting, it was decided to continue gstr 3b till june. Gstr returns in pdf and excel format returns under gst. See the gstr3 3b excel format download procedure from the gst portal.

Download form gstr3b excel format file in xlsx format. In the 17 th gst council meeting held on 18 th june, 2017, council decided to provide relief by extending the due dates for invoicewise return filing inform gstr1details. Here we provide gst return form gstr 3 in excel format this from is applicable for gst monthly return other than compounding taxpayer and isd and this form is require to submit 20th of. Gstr 3b computation with optimum igst utilization ms. These templates, just like the gstr 3b excel format ones, explain all the relevant. Section 49a deals with utilization of input tax credit. Gstr 3b filing, format and due dates tally solutions.

Gst offline tool download and resolve windows not working. The gstr 3b excel format is exclusively provided by the gstn. Download gst annual return format gstr 9a in excel. Octa gst software is very user friendly and quick to prepare and upload return. Download gstr 3b return in excel format gst return format. How to file gstr3b online step by step guide gstr 3b. Gstr 3b online filing format in excel and pdf with due date. Therefore, one must download the excel format from the gst portal to prepare the return in offline mode. Gstr 3b online filing format in excel and pdf with due date filegstr3breturnongstportal.

Click here to download the gstr 9 in excel format with instructions. Click here to view the tables and understand the gstr3b format. Download gstr 3b computation updated file in xlsx format. Endtoend solution on gst goods and services tax in india gstplus. As per the amendment the input tax credit on account of central tax, state tax or union territory tax shall be utilised towards payment of integrated tax. Click on gstr3bformatexcel to download form gstr 3b form gstr3b see rule 615 year month 1 gstin 2 legal name of the registered person 3. Reconciliation of gstr3b with books in excel format taxguru. How to export gstr1 in excel format for return filing. Recently, gstn has issued the statistics which explained that in more than 50% of the cases, there is a mismatch in case of gstr 1 liability and gstr 3b liability. The file contains gstr 3b computation in ms excel with following functionality 1. How to view notice and circular from gst website what is due date for return for gstr 3b. The gstr 3b computation sheet in excel format has been updated with latest amendment in section 49a of cgst act, 2017 as amended by cgst amendment act, 2018 with effect from 1. We have updated the gstr 3b computation with latest amendment us 49a of cgst act. Gstr 3b computation sheet in excel as applicable from 01.

What is form gstr3b,how to generate gstr3b and file. All the transactions that are displayed under included in returns section in gstr1 report will be. Find out what is gstr3b, who needs to file it and what is the due date of filing gstr3b. Also, this is known as gst form 3b in excel format or gst offline tool.