';

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

FiltersMatchMismatchSupplier OnlyPurchaser OnlyPurposeComments
Counterparty GSTINYYYYTo getlist of the invoices for the selected GSTIN.Multiple GSTINs can be selected
Counterparty Filing StatusYYYYTo getlist of invoices belonging to the counter-partiesbased on their filing statusOne value at a time. Expected values – Yes or No
Invoice From DateYYYYTo getlist of invoices from a specific dateOne value at a time
Invoice To DateYYYYTo getlist of invoices up to a specific dateOne value at a time
Invoice NumberYYYYTo get the invoices with the invoice number specifiedMultiple invoice numbers
User Action TakenYYYYTo get the list of invoices based on the action taken by usersOne value at a time. Expected Values –  Accept Supplier (A), Rejected (R), Pending (P), Save to GSTN (S), No Action
Difference in Invoice ValueYTo getlist of invoices which are having differences in the invoice value up to the user defined limitOne value at a time
Difference in Taxable ValueYTo getlist of invoices which are having differences in the taxable value up to the user defined limitOne value at a time
Difference in CGSTYTo getlist of invoices which are having differences in the CGST amount up to the user defined limitOne value at a time
Difference in SGSTYTo getlist of invoices which are having differences in the SGST amount up to the user defined limitOne value at a time
Difference in IGSTYTo getlist of invoices which are having differences in the IGST amount up to the user defined limitOne value at a time
Difference in CESSYTo getlist of invoices which are having differences in the CESS amount up to the user defined limitOne value at a time
Difference in POSYTo getlist of invoices where POS is different in purchaser and supplier invoice
Difference in TaxrateYTo getlist of invoices where different tax rates are mentioned in different in purchaser and supplier invoice
ErrorYYYYTo get list of invoices which are having error or not having errorOne value at a time
GSTN StatusYYYYTo get list of invoices which are having GSTN status as saved or To be SavedOne value at a time
Division CodeYYYYTo get list of invoices based on division codeOne 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