How to Export GSTR 3B Data into Excel Format in RetailGraph Software

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 businesses that have recently transitioned to GST.

Since many small and medium businesses have been using manual accounting methods, filing returns within the July 2017 deadlines would be difficult for many of these businesses. Hence, from July 2017 to June 2018, tax payments will be based on a simple return called the GSTR-3B.

Note:-  Every person who is registered under GST must file GSTR-3B.

Things to be noted:-

1) Before starting the process, ensure you have downloaded the latest version of SwilERP. (For this, you can contact your local service provider or make a ticket on:  Support.swildesk.com 

 2) To download the government offline tool please click the link given below:

     Reference link:  https://www.gst.gov.in/

Follow the below procedure for exporting GSTR 3B into Excel Structure:

Start with Login in the SwilERP dashboard to initiate the process:

  1. Go to the GST tab.
  2. GST Forms (For Offline Tool) > Export GSTR 3B (Excel).
Reference Window:
SwilERP Dashboard Window
   
 After that, a new pop-up window will appear:

  1. Follow the below-given steps to transform data into Excel format:

  • Select the Date Range between which the details are to be transferred in Excel. (For instance, you selected the 1st August to 31st August date range)
  • Next, click on  "Ok".
  • After clicking on the "Ok" button, a new window will appear. Select the file path and enter the file name, then Save it.
  • Note: These details export as per Offline tool v 3.1.3
    • Reference Window:
    File Saving Window
    1. After saving the file destination, an excel file will open in your system.
    2. You can check the details on the Excel sheet before uploading it into Offline Utility.
    GSTR 3B Export Into Excel

        • Related Articles

        • How to Export/ Import Master data

          How do exporting/importing master data in SwilERP (RetailGraph)? In RetailGraph, you have the feature to export the master data to excel sheets. You can export blank template files for master data creation using the Export/Import Master Data option ...

        • GST Summary Data

          How to view GST Summary Data in SwilERP (RetailGraph) What is GST summary data? GST stands for Goods and Services Tax. It is an Indirect tax that replaced a host of other Indirect taxes such as value-added tax, service tax, purchase tax, excise duty, ...

        • Export Tally Data from SwilERP (RetailGraph) & Import it into Tally

          How to Export Tally Data from SwilERP (RetailGraph) & Import it into Tally This article explains how to export tally data from SwilERP and import data in Tally. Basic Information In SwilERP, there is a feature to export master & voucher data for the ...

        • Export/Import all Customers (Debtors) party list

          How to Export/Import all Customers (Debtors) party list in Excel format in SwilERP (RetailGraph) Customer's or Debtor’s Ledgers Option in SwilERP Software facilitates the user to easily view the ledger account and balances of the Customers/debtors ...

        • Export/Import all Vendors (Creditors) party list

          How to Export/Import Vendors (Sundry Creditors) in Excel in SwilERP (RetailGraph) In SwilERP Software, the user can easily Export and Import the Ledger accounts and balances of the vendors and can also modify & print the ledgers as per their ...