Skip to content
Workflow · Match two lists · Opening soon

GSTR-2B reconciliation with the purchase register

Export your purchase register from Tally and the month’s GSTR-2B B2B download from the GST portal. Mammoth matches rows by supplier GSTIN and invoice number, then shows books vs 2B taxable value, tax, and status.

Early access opens shortly. Check back soon.

Someone typed

“match my tally purchase register to the gstr-2b by supplier gstin and invoice number, show books vs 2b taxable value and tax plus status: Agrees, ITC at risk, Not in books, Amount differs.”

The agent read it as

Match my Tally purchase register to the GSTR-2B B2B download by supplier GSTIN and invoice number, show books vs 2B taxable value and tax plus status: Agrees, ITC at risk, Not in books, Amount differs.

What the agent built

4 steps, each one an ordinary Mammoth step you can open and change.

  1. File
    Tally purchase register
    CSV export · 30 rows
  2. File
    GSTR-2B B2B download
    CSV export · 29 rows
  3. Step
    Number books lines
    Step 1
  4. Step
    Number 2B lines
    Step 2
  5. Join
    Bring in matching 2B lines
    28 of 30 paired
  6. Step
    Compare invoice lines and amounts
    Step 4
  7. Result
    GSTIN Invoice Match
    31 rows · 5 flagged
  8. Schedule
    Runs when you say
    Proposed

Checked on the sample files: every step ran, 31 rows came out, and the join paired 28 of 30 rows.

What you get back

The result of that run, the rows to look at first.

GSTIN Invoice MatchSample data31 rows
26 agrees2 amount differs2 ITC at risk1 not in books
Supplier GSTINInvoice numberStatusBooks taxable value2B taxable valueBooks tax2B taxBooks supplier2B supplierBooks invoice date2B invoice date
27ZZZORBIT9Q1Z7OLS/1026/001Not in books·20,000·3,600·Orbit Lab Supplies Pvt Ltd·2026-10-19
29AALFD5578Q1Z2DTD-7826Amount differs36,10036,1006,4986,302Dharani Tools And DiesDharani Tools And Dies2026-10-282026-10-28
30AAHCH6655K1Z3HFI/77227Amount differs69,30069,30012,47412,384Harbor Freight IndiaHarbor Freight India2026-10-202026-10-20
27AAEHG4419R1Z4GE/26-27/515ITC at risk24,300·4,374·Greenfield Electronics·2026-10-30·
30AAHCH6655K1Z3HFI/77235ITC at risk81,200·14,616·Harbor Freight India·2026-10-31·
07AAACL6601D1Z5LMS/10/26/77Agrees11,80011,8002,1242,124Lotus Maintenance ServicesLotus Maintenance Services2026-10-132026-10-13
07AAACL6601D1Z5LMS/10/26/85Agrees14,95014,9502,6912,691Lotus Maintenance ServicesLotus Maintenance Services2026-10-242026-10-24
19AAACF7890P1Z8FP/2026/1007Agrees61,25061,25011,02511,025Foresight Plastics Private LimitedForesight Plastics Private Limited2026-10-072026-10-07
24AAQFB4481L1Z6BC/1026/118Agrees76,00076,00013,68013,680Bluepeak Chemicals LLPBluepeak Chemicals LLP2026-10-032026-10-03
24AAQFB4481L1Z6BC/1026/126Agrees41,50041,5007,4707,470Bluepeak Chemicals LLPBluepeak Chemicals LLP2026-10-152026-10-15
24AAQFB4481L1Z6BC/1026/133Agrees56,80056,80010,22410,224Bluepeak Chemicals LLPBluepeak Chemicals LLP2026-10-262026-10-26
27AABCA1201F1ZPAP/26-27/041Agrees48,50048,5008,7308,730Aarohi Packaging Pvt LtdAarohi Packaging Pvt Ltd2026-10-022026-10-02
31 rows in the result · 12 shown, problems first. Sample data: illustrative figures, not business results.

How it works

How to use the GSTIN Invoice Match workflow

  1. 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
  2. 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
  3. 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.

GSTIN Invoice Match: questions

How do you do GSTR-2B reconciliation?
Export your purchase register from Tally and the month’s GSTR-2B B2B download from the GST portal. Mammoth matches rows by supplier GSTIN and invoice number, then shows books vs 2B taxable value, tax, and status. You can see Agrees, ITC at risk, Not in books, and Amount differs in one table.
Which export files should you use for this reconciliation?
Use the purchase register export from your books, such as Tally, and the B2B download from GSTR-2B for the same month. Keep the columns for supplier GSTIN, invoice number, taxable value, and tax in the files you export.
What happens to invoices that do not match?
Rows that do not find a match stay in the result with a status. You can see invoices in your books but not in 2B, invoices in 2B but not in your books, and invoices where the amounts differ.
How do you change the matching rules?
You can change the rules in words by saying what should match, such as GSTIN and invoice number, and which amounts to compare. If you want, you can also ask to treat a row as a match only when the invoice details and values are the same.

Get early access to this workflow

It will open already built and checked on the sample files. Swap in your own exports and see your result.

Early access opens shortly. Check back soon.