GSTR-2B reconciliation with the purchase register
“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.”
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.
- FileTally purchase registerCSV export · 30 rows
- FileGSTR-2B B2B downloadCSV export · 29 rows
- StepNumber books linesStep 1
- StepNumber 2B linesStep 2
- JoinBring in matching 2B lines28 of 30 paired
- StepCompare invoice lines and amountsStep 4
- ResultGSTIN Invoice Match31 rows · 5 flagged
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 31 rows came out, and the join paired 28 of 30 rows.
- Download Tally purchase register sample (30 rows)Tally: Accounts Info > Vouchers > Purchase Register > Export
- Download GSTR-2B B2B download sample (29 rows)GST portal: Services > Returns > GSTR-2B > B2B Download
What you get back
The result of that run, the rows to look at first.
| Supplier GSTIN | Invoice number | Status | Books taxable value | 2B taxable value | Books tax | 2B tax | Books supplier | 2B supplier | Books invoice date | 2B invoice date |
|---|---|---|---|---|---|---|---|---|---|---|
| 27ZZZORBIT9Q1Z7 | OLS/1026/001 | Not in books | · | 20,000 | · | 3,600 | · | Orbit Lab Supplies Pvt Ltd | · | 2026-10-19 |
| 29AALFD5578Q1Z2 | DTD-7826 | Amount differs | 36,100 | 36,100 | 6,498 | 6,302 | Dharani Tools And Dies | Dharani Tools And Dies | 2026-10-28 | 2026-10-28 |
| 30AAHCH6655K1Z3 | HFI/77227 | Amount differs | 69,300 | 69,300 | 12,474 | 12,384 | Harbor Freight India | Harbor Freight India | 2026-10-20 | 2026-10-20 |
| 27AAEHG4419R1Z4 | GE/26-27/515 | ITC at risk | 24,300 | · | 4,374 | · | Greenfield Electronics | · | 2026-10-30 | · |
| 30AAHCH6655K1Z3 | HFI/77235 | ITC at risk | 81,200 | · | 14,616 | · | Harbor Freight India | · | 2026-10-31 | · |
| 07AAACL6601D1Z5 | LMS/10/26/77 | Agrees | 11,800 | 11,800 | 2,124 | 2,124 | Lotus Maintenance Services | Lotus Maintenance Services | 2026-10-13 | 2026-10-13 |
| 07AAACL6601D1Z5 | LMS/10/26/85 | Agrees | 14,950 | 14,950 | 2,691 | 2,691 | Lotus Maintenance Services | Lotus Maintenance Services | 2026-10-24 | 2026-10-24 |
| 19AAACF7890P1Z8 | FP/2026/1007 | Agrees | 61,250 | 61,250 | 11,025 | 11,025 | Foresight Plastics Private Limited | Foresight Plastics Private Limited | 2026-10-07 | 2026-10-07 |
| 24AAQFB4481L1Z6 | BC/1026/118 | Agrees | 76,000 | 76,000 | 13,680 | 13,680 | Bluepeak Chemicals LLP | Bluepeak Chemicals LLP | 2026-10-03 | 2026-10-03 |
| 24AAQFB4481L1Z6 | BC/1026/126 | Agrees | 41,500 | 41,500 | 7,470 | 7,470 | Bluepeak Chemicals LLP | Bluepeak Chemicals LLP | 2026-10-15 | 2026-10-15 |
| 24AAQFB4481L1Z6 | BC/1026/133 | Agrees | 56,800 | 56,800 | 10,224 | 10,224 | Bluepeak Chemicals LLP | Bluepeak Chemicals LLP | 2026-10-26 | 2026-10-26 |
| 27AABCA1201F1ZP | AP/26-27/041 | Agrees | 48,500 | 48,500 | 8,730 | 8,730 | Aarohi Packaging Pvt Ltd | Aarohi Packaging Pvt Ltd | 2026-10-02 | 2026-10-02 |
How it works
How to use the GSTIN Invoice Match workflow
- 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.
- 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
- 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?
Which export files should you use for this reconciliation?
What happens to invoices that do not match?
How do you change the matching rules?
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.
Workflows like this
Bank to ledger, payouts to deposits, returns to books. Every row comes back matched, or flagged with the reason.
- Bank reconciliationEvery line matched, flagged for a date check, or missing from one sideSee the workflow Template
- Payment reconciliationEach payout matched to its bank deposit, flagged for a date check, or missingSee the workflow Template
- Match names to a master listEach record with its master name (and ID), and how it matchedSee the workflow Template
- Cash reconciliationEach day's takings matched to a bank deposit, or flagged as not bankedSee the workflow Template
- Match customer payments to open invoicesMatch bank payments to QuickBooks open invoices by customer and amount, and see what is still unapplied.See the workflow Built by the agent
- Compare two listsCompare two exported spreadsheet lists by email, see matches, and label rows where name and email agree or differ.See the workflow Built by the agent