The Reconciliation guide

Open Reconciliation from the sidebar, search by name or GSTIN and select the client. Clients you have reconciled before are listed and labelled Mismatch or Clean.

With no live session, send an OTP and enter the code your client receives. A red label means the session has expired, though results already read stay visible. A session lasts about 30 days and renews itself.

A green chip at the top shows Portal session valid with its expiry, and Re-authenticate when you need it. Pick a comparison from the tabs:

• Returns: 1 vs 3B, 2B vs 3B, 2A vs 3B, 2A vs 2B.
• Books: 1 vs books, 2A vs books, 2B vs books, 3B vs books.

A one-line note under the tabs says what is being compared. Choose the financial year, then use Reconcile to read missing data, Refresh all to download everything again (once a day per client) or Export to save to Excel.

The summary card shows how many periods are compared, the GSTR-2B credit, the GSTR-3B claimed and the Difference, labelled Over-claimed or short.

The strip shows April to March. Each month has a mark: Clean, Gap found, Portal error, Nil, Not read yet or Not due. A red mark tells you which month to open first.

Each row is a month with the credit on one side, the amount claimed on the other and the difference between them. The outcome on the right says what happened: Clean, Mismatch, 2B not ready or Not attempted. Open a row to read the explanation.

A row with a red edge needs attention. The last row totals the periods that were compared.

An expanded mismatch says how much more was claimed than the portal makes available, and which tax head the gap sits in (IGST, CGST, SGST or Cess). Check invoices that were booked before the supplier filed.

More GSTR-3B checks covers reverse charge, imports and ISD credit, and credit reversed, each against the return itself and the portal’s pre-filled figures. Each line says whether there was anything to compare, or why a check could not run.

A line at the bottom of the page shows when the portal data was last read.

Upload a purchase or sales register as Excel or PDF, under 10 MB, exported from your accounting software. A blank template is available.

Mark the heading row and the register layout, then say what each column means or mark it unused. Your answers are remembered for files with the same layout.

Review the year summary, click a figure to filter invoices, filter by outcome, or view by supplier. Each invoice carries an outcome, and the info icon tells you why.

• Matched, amount differs, possible duplicate
• Missing from 2B, missing from books, unknown supplier
• No 2B data, wrong period or duplicate entry

Confirm the suggested GSTIN or enter the right one. You are asked once per supplier, and nothing is compared until you confirm.

Filter by outcome, review lines that were set aside (totals, payments, credit notes) with reasons, and reopen earlier comparisons.

3B vs books compares your register with GSTR-3B credit month by month. Gaps often come from timing, blocked credit or reverse charge.