wowprompt

GST purchase register reconciliation against GSTR-2B

Matches a business's purchase register with the GSTR-2B statement line by line, finds invoices missing on either side, amount and date mismatches and wrong supplier GSTINs, and drafts the follow-up list for suppliers before input tax credit is claimed. Use it every month before filing GSTR-3B.

A reconciliation summary of matched, partly matched and missing invoices, a mismatch table with reasons, and supplier follow-up messages grouped by GSTIN
The output this prompt produced, unedited.

The prompt

What to give

  • Return period: [e.g. September 2026]
  • Purchase register: [paste rows: supplier name, supplier GSTIN, invoice number, invoice date, taxable value, IGST, CGST, SGST]
  • GSTR-2B lines: [paste rows: supplier GSTIN, trade name, invoice number, invoice date, taxable value, IGST, CGST, SGST]
  • Matching tolerance: [e.g. differences up to 1 rupee per invoice count as a match]
  • Invoices already followed up last month: [paste, or none]

Check every invoice

  1. Normalise invoice numbers before matching: drop spaces, slashes, leading zeros and the case of letters, and keep a column with the original.
  2. Match on supplier GSTIN plus normalised invoice number first, then on GSTIN plus amount plus a date within 5 days for the rest.
  3. Mark each line: exact match, matched with an amount difference, matched with a date difference, in books only, in GSTR-2B only.
  4. Flag IGST charged where CGST and SGST were expected, or the reverse, as a place-of-supply issue.
  5. Flag a GSTIN in the books that appears in GSTR-2B under a different trade name.
  6. List invoices in the books only that are older than the previous period, because they are the most at risk.

Output format

  1. Summary: | Status | Invoices | Taxable value | Tax |
  2. Mismatch table: | Supplier | GSTIN | Invoice | Books amount | GSTR-2B amount | Difference | Status | Likely reason |
  3. Supplier follow-up list, grouped by GSTIN, with a short polite message for each asking them to file or correct the invoice.
  4. GSTR-2B only lines: invoices the books may be missing, to check with the accounts team.
  5. Tax at risk this period if the open items are not fixed, as one figure.

Guardrails

  • Do not advise on whether a credit may legally be claimed; say "confirm with your tax adviser" for any line that depends on the rules.
  • Work only with the rows pasted; never invent a GSTIN or an invoice.
gstr 2b reconciliationgst input tax creditpurchase register matchingitc mismatchgst return filingsupplier follow up

How to run this

Copy the prompt and paste it into Gemini, then set the aspect ratio to 3:4. No reference photo is needed for this one.

The prompt is written in Markdown with each part under its own heading, which is what the copy action hands over. Change one section at a time, keeping the rest intact, so you can tell which change did the work.

Related prompts

All productivity