Sanchit A & Co · Client tools
Upload your monthly GSTR-2B files together and get one consolidated GSTR-2B: invoices, credit notes, debit notes and amendments for every month in a single sheet, ready for the GSTR-2B Reconciliation tool.
Your files are read inside this browser and are never uploaded to any server.
The month is read from the file. If it is wrong or missing, correct it in the table.
On gst.gov.in, go to Services, Returns, Returns Dashboard. For each month, open GSTR-2B and download the Excel file (or the JSON file, when the portal offers only JSON for a large return). Upload all of them here together.
Summary: month-wise count and tax for invoices, debit notes, credit notes and amendments, and the net ITC. B2B: one row per document from the B2B, B2BA, B2B-CDNR and B2B-CDNRA sheets of every month, with columns for document type, GSTR-2B month and source sheet so you can filter. Checks: points that need your attention.
Credit notes carry minus signs and debit notes plus signs, so a credit note matches a purchase return entered as minus in your books. When an amended invoice (B2BA) refers to an invoice in an earlier month you uploaded, the original is replaced by the amended details. When the original is from a month you did not upload, the amended row is kept and listed under Checks.
Same invoice reported twice by a supplier (for example 09 and 9), a credit note numbered the same as an invoice of that supplier, missing or repeated months, amendments of earlier periods, and documents where ITC is not available.
ECO, ISD and import (IMPG, IMPGSEZ) sheets are included too when present. Files from different GSTINs are flagged; combine one GSTIN at a time.
We reconcile input tax credit month on month, follow up the suppliers who have not filed,
and keep the annual return tied back to the books.
© Sanchit A & Co, Chartered Accountants · FRN 044661N | All rights reserved. | Built on Imbibe ItWeb