Home › Books vs GST returns
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.
Summary
| Head | Books | GSTR-1 | Difference |
|---|---|---|---|
| Taxable value | 4,18,62,410.00 | 4,18,62,410.00 | 0.00 |
| IGST | 31,05,880.40 | 31,05,880.40 | 0.00 |
| CGST | 22,64,110.15 | 22,76,338.65 | (12,228.50) |
| SGST | 22,64,110.15 | 22,76,338.65 | (12,228.50) |
| Documents | 1,609 | 1,612 | (3) |
Exceptions
| Only in books | 1 document | Not declared |
| Only in GSTR-1 | 4 documents | Check |
| Declared in another year’s return | 3 documents | Timing |
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.
Working-paper Excel
Both registers, the matched population, each exception sheet, the party summary, the monthly summary, the rate summary and the HSN reconciliation.
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.
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.