Consolidated GSTR3B Data Export to Excel in SwilERP Enterprise

Consolidated GSTR3B Data Export to Excel in SwilERP Enterprise

How to Export GSTR-3B to Excel in SwilERP

The GSTR-3B is a summary return that businesses registered under GST need to file monthly. It is a self-declaration form where taxpayers provide summarized details of their outward and inward supplies, along with the tax liability, input tax credit (ITC) claimed, and the net amount of tax payable.
In this guide, we will explore the streamlined process of exporting comprehensive GSTR-3B details into an Excel file.

Start with Login in the SwilERP to initiate the process

  1. Go to Menu > Consolidated Data.
  2. Select GST Forms (For Offline Tool) > Export GSTR3B (Excel).
Reference Image:
SwilERP Dashboard Window

Follow the steps below to convert data into Excel format:
  1. Go to the Date Range section and pick the dates, like October 1st to October 31st.
  2. Click OK to confirm your chosen dates.
  3. A new window will pop up.
  4. Pick where you want to save the Excel file.
  5. Give the file a clear name.
  6. Save the Excel file with those details.
Reference Image:
File Saving Window
  1. Once the file destination is saved, an Excel file will automatically open on your system.
  2. Review the details on the Excel sheet to ensure accuracy before proceeding with the upload into the Offline Utility.
Reference Image:
GSTR3B Excel Report Window

      • Related Articles

      • Export GSTR-3B Data in Excel Layout

        What is the process of exporting GSTR 3B data into excel in SwilERP (RetailGraph) What is GSTR-3B? The GSTR-3B is a consolidated summary return of inward and outward suppliers that the government of India has introduced to relax the requirements for ...

      • Export GSTR 3B (Json) in SwilERP Enterprise

        How to Generate and Export GSTR-3B Consolidated JSON File in SwilERP Enterprise GSTR-3B is a monthly self-declaration filed by a registered GST dealer along with GSTR 1 and GSTR 2 return forms. It is a simplified return to declare summary GST ...

      • Export Consolidated Data of GSTR2 in Excel Format

        How to Export Consolidated Data of GSTR2 in SwilERP GSTR-2 is a form that businesses use to report their purchases. It includes details about the goods and services they bought and the related invoices. This helps the government check and confirm ...

      • Export Consolidated GSTR1 Data in Excel & CSV Files

        How to Export GSTR1 Data in Excel & CSV Files in SwilERP If you are running a business with multiple locations and want to view data in one place, you can use a feature called Consolidated GSTR1 Data, which allows you to see all location data in one ...

      • Export Consolidated GSTR-1 JSON file

        How to Export Consolidated GSTR-1 in JSON Format using SwilERP Enterprise Form GSTR-1 is a return statement in which a regular dealer needs to capture all the outward supplies made during the month or quarter. In simple words, GSTR-1 is a return in ...