This article provides a comprehensive guide on fetching ECO (E-Commerce Operator) documents from the GST Portal and reconciling Books data with E-Commerce (E-Com) data using the Books vs E-Com Reconciliation module in ExpressGST.
These features help ensure accurate GST reporting, identify mismatches, and improve overall compliance.
ECO Documents Fetch from GST Portal
ExpressGST now enables users to directly fetch ECO-related documents from the GST Portal.
Key Highlights
- Users can retrieve ECO data for any selected period and GSTIN.
- The imported dataset includes all E-Com entries available on the GST Portal.
- The fetched ECO data seamlessly integrates with the Books vs E-Com Reconciliation module.
Books vs E-Com Reconciliation Process
This section outlines the step-by-step process to reconcile Books data with E-Com (GSTR-2A/2B) data using ExpressGST.
The reconciliation helps identify mismatches, validate reported values, and ensure accuracy between Books and GSTR-2B records.
Step 1: Import GSTR-2 Data
- Import your GSTR-2 data into ExpressGST.
- Upload the file using the Excel Import option.
- Once the import is completed, proceed to the Reconciliation module.
Step 2: Open the “Books vs 2A/2B Annual” Module
- Navigate to Books vs 2A/2B Annual.
- This module provides all required options for Books vs GSTR-2A/2B as well as Books vs E-Com reconciliation.
Step 3: Perform Supplier-Wise Reconciliation
- Click Supplier Wise Reco.
- This enables supplier-wise comparison, allowing detailed variance analysis at the vendor level.
Step 4: Perform Invoice-Wise Reconciliation & Enable E-Com Comparison
- Select Invoice Wise Reco for a detailed invoice-level match.
- Under the B2B section, check the E-Com option to enable E-Commerce reconciliation.
- To view overall results, click Books vs E-Com – Reco Status.
You can also access the Books vs E-Com Reco Status report directly from the Invoice Wise Reco screen.
Step 5: Use Filters to Identify and Resolve Discrepancies
Once Invoice Wise Reco is opened, ExpressGST classifies entries into Matched, Partially Matched, and Unmatched categories.
Matched Entries
- Perfect Matched – All fields match between Books and E-Com.
- Manually Matched (Single/Multi Linked) – Invoices manually matched by the user.
- Doc. Date Different – Document date mismatch.
- Books & 2B Period Differ – Reporting period variance.
- RCM Differ – Difference in Reverse Charge applicability.
- POS Differ – Place of Supply mismatch.
Partially Matched Entries
- Only Document Number mismatch
- Taxable Value mismatch
- Tax Amount mismatch
- RCM difference
- POS difference
- Other partial differences
Unmatched Entries
- In Books Only – Present in Books but missing in GSTR-2A/2B (E-Com).
- In 2B Only – Present in E-Com/GSTR-2B but missing in Books.
Step 6: Download the E-Com Reconciliation Report
You can download the
Books vs E-Com Reconciliation Report, which provides a consolidated comparison of Books and GSTR-2B (E-Com) data. [
Download instructions ]
By following the above steps, users can efficiently:
- Fetch ECO documents directly from the GST Portal, and
- Reconcile Books data with E-Com (GSTR-2B) entries using ExpressGST.
This ensures accurate financial reporting, seamless reconciliation, and improved GST compliance.