GSTR-2B & GSTR-1 Reconciliation with Tally

Match every purchase invoice in Tally against GSTR-2B and every sales invoice against GSTR-1 — for every client, in minutes instead of days of Excel VLOOKUPs.

Reads straight from Tally Downloads 2B / GSTR-1 from the GST portal Invoice-level match with reasons Excel export
Why reconcile

Your books and the GST portal rarely agree on their own

Input tax credit is only safe when the supplier's invoice appears in your GSTR-2B, and what you report in GSTR-1 has to agree with your sales books. Doing that by hand for every client, every month, is where most of the time goes.

  • Invoice numbers never line up exactly — INV/0045 in Tally is INV45 on the portal.
  • A supplier files under a different state GSTIN, so a plain GSTIN lookup misses the invoice.
  • A few rupees of round-off hide among real tax differences that put ITC at risk.
  • Suppliers who haven't filed only show up when it's too late to chase them.
  • Last month's review notes are lost when the working is redone in a new sheet.
How it works

Three steps, no data entry

DeltaBooks takes both sides of the reconciliation from the source, so nothing is copied or re-keyed.

1

Connect Tally

The free DeltaBooks Tally Connect plugin syncs your client's purchase and sales vouchers — supplier invoice number, date, GSTIN and tax ledgers — to DeltaBooks.

2

Download GST data

Fetch GSTR-2B and GSTR-1 for the year or month straight from the GST portal with the client's username and OTP. The session is kept alive, so you aren't asked for an OTP every time.

3

Reconcile and review

Run the reconciliation, review only what needs attention, add remarks and reasons, and export the working to Excel for the client or the file.

Purchases · Input tax credit

Tally vs GSTR-2B reconciliation

Every B2B purchase voucher is matched to GSTR-2B on supplier GSTIN and invoice number, then compared on taxable value, CGST, SGST, IGST, cess and invoice value.

Sample outputApr · B2B purchases
Supplier invoiceTax (books)Status
INV/26/04-0341₹87,336Matched
INV/26/04-0348₹27,720Tax mismatch
INV/0045 vs INV-45₹9,000Probable match
INV/26/04-0356₹16,650Only in books
INV/26/04-0359₹97,524Only in GSTR-2B

Matches what a VLOOKUP misses

Invoice numbers that differ only by separators or leading zeros, invoices that match on date, GSTIN and amounts, and suppliers who file under another state GSTIN of the same PAN — each shown as a probable match for you to confirm.

Real differences, not rounding noise

Amounts within ₹1 count as equal. Round-off differences up to ₹5 are matched separately, and a tax mismatch is kept apart from an invoice-value-only difference, so the list you review is short.

Only in books: chase the supplier

Purchases in Tally that aren't in GSTR-2B are listed with the likely reason — supplier hasn't filed, wrong or missing GSTIN in books, unregistered or composition supplier, or filed in another year's return.

Only in GSTR-2B: book or block

Invoices on the portal that aren't in Tally — a genuine omission, an expense booked without the invoice, blocked credit under section 17, or a personal purchase. ITC availability and reverse charge come straight from GSTR-2B.

Amendments included

Choose to include amended invoices from the portal so a corrected supplier invoice isn't reported as missing.

Sales · Outward supplies

Tally vs GSTR-1 reconciliation

Check that what was filed in GSTR-1 agrees with the sales in your books — before the client gets a notice about it.

B2B, invoice by invoice

Each sales invoice matched to GSTR-1 on buyer GSTIN and invoice number, with the same smart matching and tolerances as GSTR-2B.

B2C, month by month

Sales to unregistered customers compared with the B2CS totals filed for each month.

Exports

Export sales in Tally compared month-wise with the export invoices reported in GSTR-1.

Credit & debit notes

Notes to registered and unregistered parties reconciled too, with amendments (B2BA, B2CSA, CDNRA) when you want them.

What you see

Every invoice gets a clear status

The same statuses are used for GSTR-2B and GSTR-1, so your team reads both the same way.

StatusWhat it meansWhat you do
MatchedSame invoice, amounts agree within ₹1 (or a round-off up to ₹5).Nothing.
Probable / PAN matchInvoice number written differently, matched on date and amounts, or filed under another GSTIN of the same PAN.Confirm or reject with one click.
Tax mismatchThe tax amounts differ between books and the return.Correct the books or ask the party to amend.
Invoice value mismatchTax agrees; only the invoice total differs (rounding, other charges).Usually just note it.
Only in booksIn Tally, not in the return.Follow up, or record the reason.
Only in returnIn GSTR-2B / GSTR-1, not in Tally.Book it, or mark blocked / personal.
Review once

Your decisions carry forward

Confirm, reject and lock

Confirm a probable match or reject a wrong one. Locked decisions, remarks and reasons are kept when you re-run the reconciliation after the books change.

Every run is kept

Each reconciliation run is saved with its date, so you can see how the position moved through the year.

All your clients in one place

Switch between client companies in one login; each client's reconciliation stays separate.

Share it

Excel working, ready to send

One click exports the reconciliation to an Excel workbook:

Invoice-wise

Every invoice, books vs return, side by side with its status, remarks and reason.

Month-wise

Monthly totals from books and the return, with the difference — plus B2C and export months for GSTR-1.

Variance

Only the invoices that need action, ready to send to the client or a supplier.

FAQ

Questions CAs ask us

It is matching the purchase invoices in your books with the invoices your suppliers reported, as shown in GSTR-2B on the GST portal. Input tax credit is safe to claim only on invoices that appear in GSTR-2B, so the reconciliation shows which credit is supported, which is missing, and which amounts differ.

It checks that the outward supplies filed in GSTR-1 agree with the sales in your books: B2B invoices one by one, B2C sales and exports month by month, and credit and debit notes.

No. The free DeltaBooks Tally Connect plugin syncs purchase and sales vouchers from Tally, so there are no Excel exports or templates to fill.

It downloads them from the GST portal with the client's GST username and the OTP the portal sends (API access must be enabled on the portal). The session is kept alive, so you are not asked for an OTP every time.

DeltaBooks ignores separators and leading zeros (INV/0045 and INV45 are treated as the same), can match on date, GSTIN and amounts when the number differs, and finds suppliers who filed under another state GSTIN of the same PAN. These are shown as probable matches for you to confirm.

No. Amounts within ₹1 are treated as equal, and round-off differences up to ₹5 are matched separately so they do not crowd out real tax differences.

Yes. The export has invoice-wise, month-wise and variance sheets, plus B2C and export month-wise sheets for GSTR-1.

Yes. Every plan starts with a 14-day free trial, and no credit card is needed to sign up.

Reconcile your first client today

14-day free trial. No credit card needed.

Start free trial