GST Reconciliation
Automatically reconcile your accounting books with GSTR data using AI-powered matching
GST Reconciliation
Step 1 of 5: Fetch Tally Data
Ensure Tally Prime is running and Tally Port Connector is active.
Understanding the Reconciliation Process
1. Exact Match
Records with matching GSTIN, invoice number (normalized), date period, and tax amounts within tolerance.
2. Partial Match
Records with matching GSTIN, invoice number, and date but different tax amounts (highlighted mismatches).
3. Likely Match
Records matched based on GSTIN + Invoice number or GSTIN + Same tax + Same month rules.
4. AI Match (Optional)
Uses machine learning (FAISS + Sentence Transformers) to find similar records based on semantic similarity.
5. Unmatched Records
Records that could not be matched are listed separately for manual review.
Expected File Format
Books File Columns
- • Date_book
- • Voucher No_book
- • GSTIN_book
- • Particulars_book
- • Taxable Value_book
- • Input CGST_book
- • Input SGST_book
- • Input IGST_book
GSTR File Columns
- • Invoice_Date_gstr
- • Invoice_Number_gstr
- • GSTIN_gstr
- • Particulars_gstr
- • Taxable_Value_gstr (or Taxable Value_gstr)
- • CGST_gstr
- • SGST_gstr
- • IGST_gstr