How to View, Analyze, Print, and Export GST Query in RetailGraph Software

GST Query

How to view GST Query in SwilERP (RetailGraph)


What is a GST Query? 

GST Query  Data is an option in SwilERP; if users want to view their GST Sales and Purchase transaction data in a report, they can view it from the GST section. SwilERP also featured an accounting solution option in which users can manage their accounting data.  It will help you to compare data from GST and your transactions.

This option summarizes the data of  Sales Invoice/ Debit Note, Sales Credit Note,  and  Purchase Invoice/ Credit Note, Purchase Debit Note.  In this option, you will see the   data in Pivot Table format. As per requirement, select the data that to want to view in a report and you can also Remove, Export, and Import your Data. You can view the GST Query data by selecting a specific date range.  

Start with Login into SwilERP to initiate the process

  1. Go to the GST Section> GST Query
Reference image
SwilERP Dashboard Window

Process to view GST Query  

  1. A new window of GST Query will appear in the next slide.
  2. Select the Date Range  " From" to "To ", in which you want to view details.
  3. There is an option to view Check list and HSN Detail in the same window. 
  4. Click on the View option.
  5. And, there you'll see Purchase and Sales transaction details in the below-given information. 
Reference image: 



How can you analyze GST query report?

In this section, you can analyze your GST query report. You can find this report similar to the pivot table, in which you can view the sales and purchase transaction details. 
  1. Go to the   Analysis  section .
  2. Select the details as same as you selected in the  Home   section .
  3. Click on the   View  option. 
  4. After that,  Choose fields to add to report.  Tick-mark on the options; then, they will automatically field in the below-given areas. 
  5. You can also   Drag fields between below-given four areas :   Filter, Columns, Rows, Values. 
  6. The data reflect in the   Analysis Grid   section. 
Reference image:



  1. Click on the  Chart  tab to view the report in chart format.
  2. Here you'll see the   r eport's chart along with reflected every detai l .  
Reference image:



  1. You can also view the report in   Raw Data ,  where you can find every detail.
  2. Click on the   raw data and  there you will see GST Query  report .  
Reference image:



To Print and Preview the GST Query Report

  1. Go to the  Display   section.
  2. Select the  Print   and  Preview   option to take printout of the report. 
Reference image:


To Export the file in Excel format 

  1. Go to the  Display   section. 
  2. Click on the  ''T'' button,  and there, you'll see the options to convert your report into an excel file. 

Reference image:




      • Related Articles

      • Transactions Query

        How to View Transactions Query in SwilERP Software SwilERP Software provides users with the ability to view transaction queries using parameters. This report allows users to view two types of details in the same report: transaction details and ...
      • 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, ...
      • Update Purchase GST Lock Date

        How to Update Purchase GST Lock Date in SwilERP (RetailGraph) Software What is Purchase GST Lock Date?The lock date refers to the date after which you are no longer able to edit the transaction against or any positions related to an invoice. You are ...
      • Update Sales GST Lock Date

        How to Update GST Lock Date Sales in SwilERP (RetailGraph) Meaning of GST Lock Date Lock Date means the date after which you can no longer edit the transaction against or where any positions related to an invoice may no longer be Edited. As part of ...
      • Comprehensive Guide to GST Reports Features in SwilERP

        Detailed Overview of GST Reporting Features in SwilERP Overview GST reports in SwilERP help businesses manage and track their GST transactions easily and accurately. These reports include GST summaries, return filing forms, E-Way Bills, and ...