RMK Tech Services logoRMK Tech ServicesAccurate & Accept

What's new

GST reconciliation: match GSTR-2B with your purchases and GSTR-1 with your sales

Upload the GSTR-2B, GSTR-2A or filed GSTR-1 file from the GST portal and see every bill that is missing, different or entered twice, with what to do about it.

Input tax credit is claimed on what your suppliers file, not on what you enter. Reports → GST returns → Reconcile with the portal compares the two for any month, so you find a missing or wrong bill before you file GSTR-3B, not after a notice.

How to reconcile

  1. 1Download the month's GSTR-2B (or 2A) JSON or .zip from the GST portal, and for sales the GSTR-1 as filed.
  2. 2Open Reports → GST returns → Reconcile with the portal and pick the month.
  3. 3Upload the file on the Purchases or the Sales side. It must carry your GSTIN; the screen switches to the file's month by itself.
  4. 4Read the tiles — tax on the portal, tax in your books, credit available, matched, to check — and work down the list.

What it finds

  • Bills on the portal but not in your books, and the reverse.
  • Bill number, GSTIN, date, value or tax rate that differ, IGST charged instead of CGST + SGST, reverse charge and credit marked not available.
  • Bills entered twice, or filed twice by the supplier, and late bills from an earlier month.
  • On the sales side: B2B bills and notes bill by bill, cancelled bills that were still filed, and B2C small sales as totals by state and rate.

Tip: “01/0012” and “1-12” count as the same bill number, so separators and leading zeros don't create false mismatches.

Each mismatch says what to do, opens the bill, or — for a bill missing in your books — opens a new purchase bill with the supplier, number and date filled in. Tick Checked and add a note as you go; Excel gives the whole list for your accountant, who can work on it from their own sign-in.

More on RMK Billing