BharatTax GST by Neo Learnings

Home › Books vs GST returns

Reconciliation

Reconcile the books against the return, invoice by invoice

Sales against the GSTR-1 you filed. Purchase against the GSTR-2A, with per-supplier netting, the ITC gap and credit and debit notes reconciled. Upload one file per side, or a register and a return for every month of the year.

Free tier: one GSTIN, 1,000 invoice rows. Sign in with an email and a one-time code.

Sales vs GSTR-1 — FY 2025-26, Apr to Jun

Summary

HeadBooksGSTR-1Difference
Taxable value4,18,62,410.004,18,62,410.000.00
IGST31,05,880.4031,05,880.400.00
CGST22,64,110.1522,76,338.65(12,228.50)
SGST22,64,110.1522,76,338.65(12,228.50)
Documents1,6091,612(3)

Exceptions

Only in books1 documentNot declared
Only in GSTR-14 documentsCheck
Declared in another year’s return3 documentsTiming

Illustration. Figures are invented — no client data appears on this site. Negatives print in brackets, the way a working paper states one.

What it matches

Pick a mode and a period, upload one file per side — or a register and a return for every month in the year — and the tool pairs the documents.

Sales against GSTR-1

Your sale register against the outward-supply return you filed. Every invoice is paired, and what does not pair is listed on the side it sits on: booked but never declared, or declared but never booked.

Purchase against GSTR-2A

The purchase register against the supplier-declared ledger, with per-supplier netting so a credit note does not read as a missing invoice, and with the ITC gap stated per supplier. Credit and debit notes are reconciled rather than dropped.

Pairing, then differences

Documents are paired on identity first and value second, not the other way round. Keying purely on exact value is what turns an ordinary rounding difference of a few paise into a "gap" — and a genuinely different invoice into a match with a number that happens to agree.

Two ways to read the same exceptions

The unmatched population is offered dealer-wise — one row per party with the difference it accounts for, expandable to the invoices behind it — and invoice-wise, one flat row per document with the party named on every line. Dealer-wise answers who do I ring. Invoice-wise answers which bills.

Parties that could not be placed

A separate panel lists the rows that neither rule could place: no document number in the books names a supplier in the return, and no tax total identifies one. Nothing in that panel is a suggestion — it is the party’s own rows. Without it, a register with a couple of thousand unplaceable rows shows an empty proposals table and reads as finished.

The period is the return period. A document belongs to the month it was declared in, not the month it is dated. Re-basing a reconciliation on invoice dates turns an ordinary month-end cut-off into a long list of documents that appear in the books and not the return.

A difference is named in both directions. "Within the return" is not a clean bill when tax has been over-declared in one month and under-declared in another. Both directions are stated, and coloured apart.

Your files are not kept. A register is read in the request that uploads it and the result is streamed straight back. The reconciliation holds no server-side copy of your invoice data.

What you get at the end

The screen, the Excel and the PDF read the same figures off the same payload. A number cannot say one thing on screen and another in the file you file with.

XLS

Working-paper Excel

Both registers, the matched population, each exception sheet, the party summary, the monthly summary, the rate summary and the HSN reconciliation.

PDF

Recon statement

The signed-off statement and its pivots, laid out as a working paper — negatives in brackets, one colour for a difference in either direction.

CSV

The exceptions

Only-in-books and only-in-return, dealer-wise or invoice-wise, ready to send to the client or the supplier.

Questions

Can I reconcile a whole year in one go?

Yes. Upload a register and a return for each month; the tool keys the comparison on the return period and reports per period as well as for the year. A per-period test is summarised over the periods, not over the netted year — a year that nets to nothing can still contain a month of excess claim and a month of shortfall.

What if my register is not from Tally, Busy, Marg or Easy Sol?

Map your own columns. Anything with a taxable value, a tax breakup and a document number can be reconciled. See books import.

Does it handle credit and debit notes?

Yes, and on the purchase side it nets them per supplier before stating the ITC gap, so a note never reads as a missing invoice. A note dated in an earlier year but declared in this one is routed to the cross-year panel instead of being counted against the wrong year.

Where do the returns come from?

Upload the portal download, or pull GSTR-1, 2A and 2B straight from the portal through your GST Suvidha Provider — see converters and portal fetch.

Reconcile a period before you pay anything

The free tier covers one GSTIN and a thousand invoice rows — enough to put a real month through and see whether the answer is one you would sign.

Create a free account See a live reconciliation