How to Download GSTR 1 & 3B?

  • Post author:
  • Post published:November 10, 2023
  • Post category:GST Return


Download GSTR 1 & 3B

Goods and Services Tax (GST) has revolutionized the taxation system in India. Under the GST regime, businesses are required to file various returns, including GSTR-1 and GSTR-3B, to report their sales and pay their taxes. These returns are essential for ensuring tax compliance and are submitted electronically through the official GST portal. In this guide, we will provide a comprehensive, step-by-step tutorial on how to download GSTR-1 and GSTR-3B returns in India.

Understanding GSTR-1 and GSTR-3B

Before we delve into the process of downloading these returns, let’s briefly understand what GSTR-1 and GSTR-3B are:

  1. GSTR-1: GSTR-1 is a monthly or quarterly return that businesses need to file to report their outward supplies of goods and services. It contains details of sales, such as invoices issued, credit notes, and debit notes. Accurate and timely filing of GSTR-1 is crucial for claiming input tax credits.
  2. GSTR-3B: GSTR-3B is a monthly return that summarizes a business’s sales, purchases, and the amount of tax payable. It is a simplified return intended for businesses to provide basic information about their tax liability and claim input tax credits. It serves as a self-assessment return and is filed on a monthly basis.

Now, let’s explore how to download these returns.

Downloading GSTR-1

Step 1: Log In

  • Visit the official GST portal:
  • Use your GSTIN (GST Identification Number) and password to log in to your account.

Step 2: Select ‘Services’

  • After logging in, you will find a menu bar. Click on the “Services” tab.

Step 3: Choose ‘Returns’

  • Under the “Services” tab, select “Returns.” This will take you to the returns section.

Step 4: Click on ‘Returns Dashboard’

  • On the Returns page, choose “Returns Dashboard” from the available options.

Step 5: Select Applicable Return Period

  • The Returns Dashboard displays a list of various returns that you can file. From this list, choose “GSTR-1” as the return you wish to download.
  • Now, select the applicable return period for GSTR-1. You can choose between monthly or quarterly returns, depending on your business turnover.

Step 6: File and Download

  • Once you’ve selected the return period, you will be directed to the GSTR-1 form. Here, you need to review all the data to ensure its accuracy. Make any necessary corrections.
  • After verifying the data, click on the “File GSTR-1” button.
  • Once your GSTR-1 is successfully filed, you will see a confirmation message.
  • Now, you can download the filed GSTR-1 in PDF format. You will find the download link on the Returns Dashboard.

Downloading GSTR-3B

Step 1: Log In: Start by logging in to your GST portal account using your GSTIN and password.

Step 2: Access ‘Services’: Once you are logged in, go to the “Services” tab in the menu.

Step 3: Navigate to ‘Returns’: In the “Services” section, select “Returns.”

Step 4: Choose ‘Returns Dashboard’: From the Returns menu, click on “Returns Dashboard.”

Step 5: Select Applicable Return Period: On the Returns Dashboard, you will see “GSTR-3B” listed among the returns. Select the appropriate return period for GSTR-3B, which is usually on a monthly basis.

Step 6: File and Download

  • After choosing the return period, you will be directed to the GSTR-3B form. Review all the data in the return form to make sure it’s accurate. You can make any necessary adjustments.
  • Once you’ve confirmed the accuracy of the data, click on the “File GSTR-3B” button.
  • After successfully filing GSTR-3B, you will receive a confirmation message.
  • Now, you can download the filed GSTR-3B in PDF format. Look for the download link on the Returns Dashboard.

What Do You Mean By GSTR-1 And GSTR-3B Reconciliation

Reconciliation between GSTR-1 and GSTR-3B is like double-checking to make sure everything adds up. It’s about comparing the information in both of these returns to spot any differences or discrepancies. Here’s why we do it:

  1. Differences in Outward Supplies: Imagine you’re keeping track of your sales in GSTR-1, and you’re also reporting the value of these sales in GSTR-3B. Reconciliation helps you catch any mismatches between these two. It’s a way to ensure that you’ve correctly accounted for all your sales transactions. In simple terms, it’s like making sure all the money you make from sales is accurately recorded.
  2. Input Tax Credit (ITC) Reconciliation: In GSTR-3B, you get to claim the input tax credit for the taxes you paid on your business purchases. Reconciliation here is about double-checking if the amount you’re claiming in GSTR-3B matches up with the details of the stuff you bought (that’s your inward supplies) as reported in GSTR-1. It’s just making sure you’re not missing out on any tax credits that you’re entitled to.

So, reconciliation is all about accuracy and making sure your records match up so you’re in the clear when it comes to taxes and credits. It’s like making sure all the pieces of the puzzle fit perfectly.

What Are The Reasons For Mismatches In GSTR-3B And GSTR-1?

Mismatches between GSTR-1 and GSTR-3B can happen for various reasons, and it’s crucial to understand these common causes:

  1. Timing Differences: The first reason for these mismatches is a timing issue. You see, GSTR-3B is like a monthly tax summary report where you sum up how much tax you need to pay. On the other hand, GSTR-1 is more detailed, where you list out all the stuff you sold during the month or quarter. Because of this difference in reporting periods and timing, it’s like comparing apples to oranges sometimes, and mismatches can pop up.
  2. Incorrect Reporting:Mistakes can happen. Sometimes, there are errors or mix-ups when entering details in GSTR-3B and GSTR-1. These can range from getting the invoice number wrong to messing up the tax amounts or any other info related to what you bought or sold.
  3. Non-Filing or Delayed Filing: If you miss the deadline for filing GSTR-3B or GSTR-1 set by the tax authorities, it can lead to discrepancies between these two forms. Late or missed filings can not only mess up your records but also result in penalties.
  4. Reversal or Modification of Transactions: Imagine you filed GSTR-1, and then you decide to change or cancel a transaction. If these changes aren’t correctly reflected in your GSTR-3B, it can cause mismatches.
  5. Input Tax Credit (ITC) Discrepancies: Mismatches can also occur when the ITC you claim doesn’t match the outward supplies reported in GSTR-1 by your supplier. In simple terms, it’s like saying you bought something, but the receipt you show doesn’t match the actual purchase.
  6. Technical Issues: Finally, technical glitches or problems with the GST portal or the software used to file returns can throw a wrench into the works. These technical hiccups can lead to unexpected mismatches.

So, when it comes to reconciling GSTR-1 and GSTR-3B, it’s essential to be on top of these common causes of mismatches. By understanding them, you can take steps to prevent errors and ensure that your records are in harmony. Think of it as keeping all your financial ducks in a row to avoid any surprises come tax time.

Why is It Necessary To Reconcile GSTR-3B And GSTR-1?

Reconciliation between GSTR-3B and GSTR-1 is like the checks and balances system for your business’s tax records. Let’s break down why it’s so important:

  1. Compliance: Imagine GSTR-3B as the summary report and GSTR-1 as the detailed sales report. Reconciliation ensures that the info you report in the summary (GSTR-3B) matches the nitty-gritty details in the sales report (GSTR-1). It’s all about following the rules and laws of the GST system. By making sure they align, you’re staying compliant.
  2. Accuracy of Tax Liability:When you’re filling out GSTR-3B, you’re calculating how much tax you owe. Reconciliation checks to see if this amount is spot on. By comparing it with the details of what you’ve sold in GSTR-1, it can catch any mistakes or differences. This accuracy is crucial for your tax liability.
  3. Input Tax Credit (ITC) Reconciliation: Reconciliation also helps with something called Input Tax Credit (ITC). Think of ITC as a refund you get for the taxes you paid on your business purchases. Reconciliation makes sure that the ITC you claim in GSTR-3B lines up perfectly with the purchases you reported in GSTR-1. It’s like making sure you get all the money you’re owed.
  4. Error Identification:Picture this: You report sales in GSTR-1 but make some typos, like getting invoice numbers wrong or messing up the tax amounts. Reconciliation steps in to spot these errors. Fixing them early on saves you from headaches during audits or assessments.
  5. Compliance with GST Law: GST laws demand accurate reporting of your sales and taxes. Non-compliance or mistakes can lead to penalties and other legal troubles. Reconciliation ensures you’re following the law to the letter.
  6. Smooth GST Return Filing:Lastly, reconciling GSTR-3B and GSTR-1 streamlines the process of filing your GST returns. When the info matches up, there’s less chance of errors or rejections. It’s like having all your documents in order before submitting them.

So, reconciliation isn’t just about ticking boxes; it’s about keeping your business in good financial health, following the rules, and making sure you’re not leaving money on the table. It’s a way to maintain the integrity of your tax reporting and avoid any costly surprises down the road.

How To Reconcile GSTR-3B And GSTR-1 In Excel Format?

Reconciling GSTR-3B and GSTR-1 in Excel is like putting together a puzzle to make sure everything fits perfectly. Here’s a step-by-step guide to do it:

  1. Download the Data: Start by downloading your GSTR-3B and GSTR-1 data in Excel format. You can get this data from the GST portal or your accounting software.
  2. Create Excel Worksheets: Open a new Excel workbook and create two worksheets. One is for your GSTR-3B data, and the other is for your GSTR-1 data.
  3. Copy and Paste Data: Copy the relevant data from your GSTR-3B into the GSTR-3B worksheet. This data usually includes details like Invoice Number, Invoice Date, Taxable Value, CGST Amount, SGST/UTGST Amount, IGST Amount, and Total Tax Amount.
  4. GSTR-1 Data: Now, do the same for your GSTR-1 data. Copy and paste it into the GSTR-1 worksheet with the same columns as GSTR-3B.
  5. Create a Reconciliation Template: In a new worksheet, set up a reconciliation template with columns to compare the data. Copy the relevant information from your GSTR-3B and GSTR-1 worksheets into their respective columns in the reconciliation template.
  6. Use Excel Formulas:Here comes the magic of Excel. Use formulas to calculate the differences between your GSTR-3B and GSTR-1 data. For example, in the Discrepancy column for Taxable Value, use a formula like “=GSTR-3B Taxable Value – GSTR-1 Taxable Value” to find the difference.
  7. Apply Conditional Formatting: Make life easier by applying conditional formatting. This nifty Excel feature highlights any discrepancies in the Discrepancy column, making them stand out.
  8. Investigate Discrepancies: It’s like being a detective. Look into those differences. Check for data entry errors, mismatched invoice numbers, or any other reasons causing the discrepancies.
  9. Take Corrective Actions:Once you’ve identified the issues, it’s time to fix them. You might need to correct the data in GSTR-3B and GSTR-1, issue credit or debit notes, or even seek help from a tax pro.
  10. Update the Template: Finally, update your reconciliation template with any corrections you’ve made or any remarks about the changes.

Reconciling in Excel is like making sure all your financial ducks are in a row. It’s a bit of work, but it’s worth it to keep your records accurate and stay on the right side of the taxman.


Accurate and timely filing of GST returns is crucial for businesses in India. GSTR-1 and GSTR-3B are among the most important returns that need to be filed regularly. This step-by-step guide provides a clear understanding of how to download these returns from the official GST portal.

As the GST system evolves and updates are made, it’s essential to stay informed about the latest procedures and requirements for filing returns. The official GST portal is a valuable resource for businesses and tax professionals, and it offers comprehensive support for the GST return filing process.

By following the steps outlined in this guide, businesses can ensure that their GSTR-1 and GSTR-3B returns are filed accurately and on time, thus contributing to their compliance with GST regulations and benefiting from the input tax credit system. For any additional guidance or assistance, it’s advisable to consult with tax experts or explore the official GST portal for the most up-to-date information.


Greetings, I'm Iram, a taxation expert with a profound passion for helping businesses navigate the complex world of tax compliance and financial strategies. With extensive knowledge in tax law and a commitment to providing businesses with the guidance they need, I'm here to be your trusted partner in achieving financial success. I firmly believe that every business owner, regardless of their background, deserves access to expert taxation advice and strategies. My goal is to support you in optimizing your tax planning and compliance efforts, ensuring that your business thrives in the competitive landscape. I am honored to be part of your journey toward financial success through this blog, where I'll share valuable insights and strategies tailored to your taxation needs. Thank you for entrusting me with the opportunity to contribute to your business's financial prosperity. For more information and resources, please visit