GSTR-1 reconciliation with books and e-invoices, before you file

Short answer: Before filing GSTR-1, compare three sources: your sales register, the e-invoice data that auto-populates GSTR-1, and the sales and output tax ledgers in the trial balance. Every IRN should be in your books, B2B credit notes need an IRN, and tax heads must agree. An AI agent can run this three-way check from one message.

E-invoicing means much of GSTR-1 is filled in before you open it. That makes the pre-filing check more important, not less: an invoice that exists on the IRP but not in your books still reaches the return.

Here is the manual method from a recent Tally tutorial, then the same check done by an AI agent in Slack.

The tutorial this is based on

GSTR-1 RETURN FILING | GSTR1 RETURN FROM TALLY | E INVOICE GSTR1 RETURN FROM TALLY | ONLINE GSTR1 by Tally Home & Institute, published 5 October 2026 (in Hindi). It covers each reconciliation in order, from last period's open items to the final tie-out by tax head.

How do you reconcile GSTR-1 with your books?

  1. Clear anything left open from the previous period first, using TallyPrime's GST reconciliation.
  2. Compare GSTR-1 sales with the Sales account in the P&L for the month.
  3. Reconcile the output IGST, CGST and SGST ledgers with the tax in the return.
  4. Download the return data into TallyPrime and compare the e-invoice data with your vouchers. Invoices and credit notes with an IRN are auto-populated in GSTR-1.
  5. For documents not yet reported, export the e-invoice JSON from TallyPrime and upload it on the portal.
  6. Do the final tie-out: portal GSTR-1 against Tally, tax head by tax head.

Where it usually goes wrong

How an AI agent does it from Slack

We gave the agent three files for a made-up manufacturer, Tapti Polymers: October's Tally sales register (47 documents), the e-invoice data from the portal and the trial balance. We planted six problems. Every company, name, tax number and amount in these files is made up. The agent works in Slack, where it shows up as Mnemio AI, because Accountant AI is built on Mnemio AI.

The message in SlackTapti Polymers: check October sales before we file GSTR-1. Attached: Tally sales register, the e-invoice data from the portal and the trial balance. Tell me what doesn't tie and what to fix first. Don't change anything.
Slack request to check October sales before GSTR-1 with three Excel files attached, and the agent's summary table comparing the trial balance, Tally sales register and e-invoice data
The request and the three-way summary: trial balance, Tally sales register and e-invoice data side by side.

What the agent did

  1. Totalled all three sources: taxable value of ₹99,49,020 in the trial balance, ₹99,31,020 in the sales register and ₹1,00,40,750.50 in the e-invoice data.
  2. Matched documents by number between Tally and the e-invoice data, then compared GSTIN, place of supply, taxable value and each tax head.
  3. Explained the ₹1,09,730.50 gap between the register and the e-invoice data item by item.
  4. Checked the output tax ledgers in the trial balance against the register, and traced the ₹18,000 sales difference to an entry posted outside the sales register.
  5. Ranked the fixes and listed them in order, without changing the books.
The agent's list of discrepancies: an e-invoice missing from Tally, a B2B credit note without an IRN, an ₹18,000 gap between the trial balance and the sales register, and a GSTIN typo
Part of the list of what doesn't tie, with the risk of each.

What it found

What the agent found before GSTR-1
ProblemDocumentAmount (₹)Fix
Has an IRN but is missing in TallyTP/26-27/188197,330.00 taxableBook the invoice in Tally
B2B credit note without an IRNCN/26-27/02112,400.00 taxableGenerate the e-invoice for the credit note
Customer GSTIN typo in TallyTP/26-27/1879Correct the party master
CGST and SGST on an inter-state saleTP/26-27/187615,202.80 taxChange the place of supply and charge IGST
Sales in the trial balance higher than the registerJournal entry18,000.00Check whether GST applies and how it is reported
RoundingTP/26-27/18960.50Immaterial; note it

What you still check

Questions accountants ask

Why compare e-invoice data and not just GSTR-1?

Because e-invoices flow into GSTR-1 on their own. If an invoice exists on the IRP but not in your books, the return includes it and your books don't.

Can the agent download the data from the GST portal?

You sign in to the portal yourself, in the agent's browser window. After that it can download what it needs. It asks before it changes or files anything.

Does it only work with Tally?

No. It works from exports, so a sales register from Zoho Books, Busy or an ERP works the same way.

Hand this job to an agent

Bring one of your own files to a 30-minute call and watch an agent do it.

Book a 30-min demo