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.
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.
INV/0045 in Tally is INV45 on the portal.DeltaBooks takes both sides of the reconciliation from the source, so nothing is copied or re-keyed.
The free DeltaBooks Tally Connect plugin syncs your client's purchase and sales vouchers — supplier invoice number, date, GSTIN and tax ledgers — to DeltaBooks.
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.
Run the reconciliation, review only what needs attention, add remarks and reasons, and export the working to Excel for the client or the file.
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.
| Supplier invoice | Tax (books) | Status |
|---|---|---|
| INV/26/04-0341 | ₹87,336 | Matched |
| INV/26/04-0348 | ₹27,720 | Tax mismatch |
| INV/0045 vs INV-45 | ₹9,000 | Probable match |
| INV/26/04-0356 | ₹16,650 | Only in books |
| INV/26/04-0359 | ₹97,524 | Only in GSTR-2B |
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.
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.
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.
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.
Choose to include amended invoices from the portal so a corrected supplier invoice isn't reported as missing.
Check that what was filed in GSTR-1 agrees with the sales in your books — before the client gets a notice about it.
Each sales invoice matched to GSTR-1 on buyer GSTIN and invoice number, with the same smart matching and tolerances as GSTR-2B.
Sales to unregistered customers compared with the B2CS totals filed for each month.
Export sales in Tally compared month-wise with the export invoices reported in GSTR-1.
Notes to registered and unregistered parties reconciled too, with amendments (B2BA, B2CSA, CDNRA) when you want them.
The same statuses are used for GSTR-2B and GSTR-1, so your team reads both the same way.
| Status | What it means | What you do |
|---|---|---|
| Matched | Same invoice, amounts agree within ₹1 (or a round-off up to ₹5). | Nothing. |
| Probable / PAN match | Invoice number written differently, matched on date and amounts, or filed under another GSTIN of the same PAN. | Confirm or reject with one click. |
| Tax mismatch | The tax amounts differ between books and the return. | Correct the books or ask the party to amend. |
| Invoice value mismatch | Tax agrees; only the invoice total differs (rounding, other charges). | Usually just note it. |
| Only in books | In Tally, not in the return. | Follow up, or record the reason. |
| Only in return | In GSTR-2B / GSTR-1, not in Tally. | Book it, or mark blocked / personal. |
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.
Each reconciliation run is saved with its date, so you can see how the position moved through the year.
Switch between client companies in one login; each client's reconciliation stays separate.
One click exports the reconciliation to an Excel workbook:
Every invoice, books vs return, side by side with its status, remarks and reason.
Monthly totals from books and the return, with the difference — plus B2C and export months for GSTR-1.
Only the invoices that need action, ready to send to the client or a supplier.