GSTZen’s powerful GSTR-2B Reconciliation Report enables Chartered Accountants, Tax Professionals, and Businesses to perform seamless reconciliation between GSTR-2B and GSTR-3B data. The advanced filter options provide maximum flexibility to extract only the relevant data needed for accurate compliance and decision-making.
Once you complete your reconciliation and save your entries in columns AN to AS in GSTZen, you can generate a custom report tailored to your needs. GSTZen offers a variety of filters for your convenience as explained below.
1. Filter by GSTR-3B Books vs 2A/2B Reconciliation Status
This section allows you to filter invoices based on their current reconciliation status:
- (Value not provided): Select invoices where no reconciliation status has been provided yet.
- Review Later: Flag invoices for review at a later stage.
- Wrong Invoice by Supplier: Identify invoices flagged as incorrectly filed by the supplier.
- Lost ITC: Invoices where Input Tax Credit (ITC) has been reported missing.
- E-Mail Supplier / E-Mail to Supplier sent: Track actions related to supplier communication for discrepancies.
- Lock Match: Fix an invoice as matched to prevent it from being automatically reprocessed.
2. Filter by Invoice / Credit Note Date
- Select invoices and credit notes within a specific date range.
- Allows targeting data for any custom period.
3. Filter by GSTR-3B ITC Claim Date
- Filter records based on whether an ITC claim date has been provided or not.
- If claim date is provided, you can also select a date range to narrow down your data.
4. Filter by ITC Eligibility
This section provides predefined ITC eligibility categories to filter records:
- (Value not provided): No eligibility assigned.
- T1 – Ineligible – Personal Use: Expenses not eligible for ITC as they are for personal use.
- T2 – Ineligible – Exempted Use: Expenses related to exempted supplies.
- T3 – Ineligible – Blocked Credit: Cases where ITC is blocked by GST rules.
- T4 – Eligible – Taxable Use: Fully eligible ITC for taxable business use.
- C2 – Common Credit: Credits shared between exempt and taxable supplies.
5. Filter by GSTR-3B ITC Claim Status
- (Value not provided): Records where claim status is missing.
- Accepted: ITC successfully claimed in GSTR-3B.
- Rejected: Claim was rejected by the system.
- Pending Accept: Claim is awaiting acceptance.
- Accept and Reverse: Claim initially accepted and reversed.
Download XLS Report Button
Once filters are set as per the user’s needs, clicking the “Download XLS Report” button generates a fully customized Excel report. This empowers tax professionals to focus only on actionable data, facilitating easy ITC reconciliation and decision-making.
This intuitive filtering mechanism in GSTZen ensures efficient data management, focused reporting, and better compliance with GST reconciliation requirements.