Skip to content
Workflow · Match two lists · Opening soon

GSTR-1 vs sales register

Export your Tally sales register and your GSTR-1 B2B details for the month. Mammoth numbers the invoice lines, matches them by GSTIN and invoice number, and shows customer, invoice date, taxable value from both sides, and a status for each line.

Early access opens shortly. Check back soon.

Someone typed

“match each b2b invoice in the tally sales register to gstr-1 by gstin and invoice number, show customer, invoice date, taxable value from both sides, and status: Agrees, Not reported, Not in books, Differs”

The agent read it as

Match each b2b invoice in Tally sales register to GSTR-1 B2B details download by GSTIN and invoice number, show customer, invoice date, taxable value from both sides, and status: Agrees, Not reported, Not in books, Differs

What the agent built

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

  1. File
    Tally sales register
    CSV export · 30 rows
  2. File
    GSTR-1 B2B details download
    CSV export · 30 rows
  3. Step
    Number Tally invoice lines
    Step 1
  4. Step
    Number GSTR-1 invoice lines
    Step 2
  5. Join
    Bring in GSTR-1 lines
    27 of 30 paired
  6. Step
    Match invoice lines and show status
    Step 4
  7. Result
    B2B Invoice Reconciliation
    33 rows · 7 flagged
  8. Schedule
    Runs when you say
    Proposed

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

What you get back

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

B2B Invoice ReconciliationSample data33 rows
26 agrees1 differs3 not in books3 not reported
GSTINInvoice numberCustomerStatusTally invoice dateGSTR-1 invoice dateTally taxable valueGSTR-1 taxable value
27AAACH6677S1Z7SR-1018Harbor FoodsNot reported2026-10-18·13,400·
27AAACH6677S1Z7SR-1028Harbor FoodsNot reported2026-10-28·16,500·
29AAACG8844R1Z9SR-1027Garnet HomeNot reported2026-10-27·12,750·
27AAACH6677S1Z7SR-1008Harbor FoodsNot in books·2026-10-08·9,900
29AAACG8844R1Z9SR-1028Garnet HomeNot in books·2026-10-28·16,500
33AAACE2211P1Z6SR-1031Everest SuppliesNot in books·2026-10-30·8,000
29AABCB7788L1Z2SR-1012Bluebell RetailDiffers2026-10-122026-10-1215,00014,000
07AAACF5566Q1Z1SR-1006Fable ElectronicsAgrees2026-10-062026-10-0621,95021,950
07AAACF5566Q1Z1SR-1016Fable ElectronicsAgrees2026-10-162026-10-1612,60012,600
07AAACF5566Q1Z1SR-1026Fable ElectronicsAgrees2026-10-262026-10-2610,10010,100
09AAACI1122T1Z3SR-1009Indigo OfficeAgrees2026-10-092026-10-0916,80016,800
09AAACI1122T1Z3SR-1019Indigo OfficeAgrees2026-10-192026-10-1915,70015,700
33 rows in the result · 12 shown, problems first. Sample data: illustrative figures, not business results.

How it works

How to use the B2B Invoice Reconciliation 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.

B2B Invoice Reconciliation: questions

How do you reconcile GSTR-1 with your sales register?
Export your Tally sales register and your GSTR-1 B2B details for the month. Mammoth numbers the invoice lines, matches them by GSTIN and invoice number, and shows customer, invoice date, taxable value from both sides, and a status for each line. You can see which invoices are reported, not reported, not in books, or different.
Which exports should I use for this workflow?
Use the sales register export from Tally and the B2B details export from the GST portal for the same month. The file names can vary, but they need the invoice number, GSTIN, and taxable value fields.
What happens to invoices that do not match?
Rows that do not find a match are still shown. They are marked as Not reported when they appear in books only, Not in books when they appear in GSTR-1 only, or Differs when the invoice matches but the GSTIN or taxable value does not.
How do I change the matching rules?
You can change the rules in words, then rerun the workflow. For this job, you would usually keep GSTIN and invoice number as the match keys, and change which fields you want to compare if your process needs something else.

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.