Filter facility in GSTR 6 Reconciliation

You are here:
Estimated Reading Time: 2 Minutes

Using Filters in Reconciliation

Filter functionality is available under the Reconcile tab to view data based on the selected parameters. Here are the lists of parameters that can be selected-

Most of the filters are similar across the reconciliation categories; however, there are some filters which are specific to the categories or the type of document

Filters Match Mismatch Supplier Only Purchaser Only Purpose Comments
Counterparty GSTIN Y Y Y Y To getlist of the invoices for the selected GSTIN. Multiple GSTINs can be selected
Counterparty Filing Status Y Y Y Y To getlist of invoices belonging to the counter-partiesbased on their filing status One value at a time. Expected values – Yes or No
Invoice From Date Y Y Y Y To getlist of invoices from a specific date One value at a time
Invoice To Date Y Y Y Y To getlist of invoices up to a specific date One value at a time
Invoice Number Y Y Y Y To get the invoices with the invoice number specified Multiple invoice numbers
User Action Taken Y Y Y Y To get the list of invoices based on the action taken by users One value at a time. Expected Values –  Accept Supplier (A), Rejected (R), Pending (P), Save to GSTN (S), No Action
Difference in Invoice Value Y To getlist of invoices which are having differences in the invoice value up to the user defined limit One value at a time
Difference in Taxable Value Y To getlist of invoices which are having differences in the taxable value up to the user defined limit One value at a time
Difference in CGST Y To getlist of invoices which are having differences in the CGST amount up to the user defined limit One value at a time
Difference in SGST Y To getlist of invoices which are having differences in the SGST amount up to the user defined limit One value at a time
Difference in IGST Y To getlist of invoices which are having differences in the IGST amount up to the user defined limit One value at a time
Difference in CESS Y To getlist of invoices which are having differences in the CESS amount up to the user defined limit One value at a time
Difference in POS Y To getlist of invoices where POS is different in purchaser and supplier invoice
Difference in Taxrate Y To getlist of invoices where different tax rates are mentioned in different in purchaser and supplier invoice
Error Y Y Y Y To get list of invoices which are having error or not having error One value at a time
GSTN Status Y Y Y Y To get list of invoices which are having GSTN status as saved or To be Saved One value at a time
Division Code Y Y Y Y To get list of invoices based on division code One value at a time

Difference Filter

We have provided a new filter ‘Difference’ on selected parameters like Invoice Value, Taxable Value, CGST, SGST, IGST and CESS. Please note that it is applicable only for Mismatched Category. Using the difference filter, user can get list of all the invoices which have difference in value within the specified limit.

For example, if we select the limit of Rs. 1000 in taxable amount then user can see all the data which has difference up to Rs.1000.

We can select multiple filters for searching the records. For example we can select both ‘Counterparty GSTIN’ and ‘Invoice From Date’ simultaneously.

Search GSTIN