GST Query
How to View GST Query in SwilERP
What is a GST Query?
A 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
-
Go to the
GST Section> GST Query.
Reference image:
Process to view GST Query
-
A new window of
GST Query
will appear in the next slide.
-
Select the
Date Range
"From"
to
"To
", in which you want to view details.
-
There is an option to view
Check list
and
HSN Detail
in the same window.
-
Click on the
View
option.
-
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.
-
Go to the
Analysis section.
-
Select the details as same as you selected in the Home
section.
-
Click on the
View option.
-
After that, Choose fields to add to report. Tick-mark on the options; then, they will automatically field in the below-given areas.
-
You can also
Drag fields between below-given four areas:
Filter, Columns, Rows, Values.
-
The data reflect in the
Analysis Grid
section.
Reference image:
-
Click on the Chart tab to view the report in chart format.
-
Here you'll see the
report's chart along with reflected every detail.
Reference image:
-
You can also view the report in
Raw Data,
where you can find every detail.
-
Click on the
raw data and
there you will see
GST Query report.
Reference image:
To Print and Preview GST Query Report
-
Go to the Display
section.
-
Select the Print
and Preview
option to take printout of the report.
Reference image:
To Export file in Excel format
-
Go to the Display section.
-
Click on the ''T'' button, and there, you'll see the options to convert your report into an excel file.
Reference image:
|
|
Related Articles
GST Summary Data
How to view GST Summary Data in SwilERP 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, and so on. ...Update Sales GST Lock Date
How to Update GST Lock Date Sales in SwilERP Meaning of GST Lock Date The Lock Date is the point after which you can’t make changes to a transaction or invoice. For GST returns, your sales data must be accurate and final. Once you submit it, no ...Update Purchase GST Lock Date
How to Update Purchase GST Lock Date in SwilERP 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 required to ...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 ...Transactions Query
How to View Transactions Query in SwilERP Software SwilERP 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 product ...