Skip to content
Workflow · Match two lists · Opening soon

GSTR-3B vs GSTR-1 reconciliation

Export the monthly GSTR-1 summary from the GST portal, the monthly GSTR-3B summary from the GST portal, and the monthly GST ledger summary from Tally. Mammoth matches the months, compares output tax and input GST, excludes Cess, and shows the months that do not match so you can review them before filing GSTR-9.

Early access opens shortly. Check back soon.

Someone typed

“for each month of the financial year compare the output tax i reported in gstr-1 with the output tax i paid in gstr-3b and with my tally gst ledgers, compare the itc claimed in gstr-3b with the input gst in my books, and show the months that differ before i file gstr-9”

The agent read it as

For each month of the financial year compare the output tax I reported in GST portal GSTR-1 summary with the output tax I paid in GST portal GSTR-3B summary and with my Tally GST ledger monthly summary, compare the ITC claimed in GST portal GSTR-3B summary with the input GST in my Tally GST ledger monthly summary, and show the months that differ before I file GSTR-9, excluding Cess from the comparison.

What the agent built

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

  1. File
    GST portal GSTR-1 summary
    CSV export · 12 rows
  2. File
    GST portal GSTR-3B summary
    CSV export · 12 rows
  3. File
    Tally GST ledger monthly summary
    CSV export · 12 rows
  4. Step
    Total GSTR-1 tax
    Step 3
  5. Step
    Total GSTR-3B tax
    Step 1
  6. Step
    Total Tally GST
    Step 2
  7. Join
    Bring in GSTR-3B
    12 of 12 paired
  8. Step
    Match the month keys
    Step 5
  9. Join
    Bring in Tally GST
    12 of 12 paired
  10. Step
    Show months that differ
    Step 7
  11. Result
    Monthly GST differences
    4 rows · 4 flagged
  12. Schedule
    Runs when you say
    Proposed

On the sample files, every step runs and the result has 4 rows.

What you get back

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

Monthly GST differencesSample data4 rows
2 output tax differs1 input GST differs1 output tax and input GST differ
MonthGSTR-1 output taxGSTR-3B output taxTally output taxGSTR-3B ITCTally Input GSTStatus
Aug-2025396,000396,000396,000104,00094,000Input GST differs
Jan-2026448,000442,000448,000106,000100,000Output tax and input GST differ
Jun-2025410,000406,000410,00094,00094,000Output tax differs
Nov-2025406,000402,000406,00093,00093,000Output tax differs
4 rows in the result. Sample data: illustrative figures, not business results.

How it works

How to use the Monthly GST differences workflow

  1. 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and working on 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.

Monthly GST differences: questions

How do you reconcile GSTR-3B vs GSTR-1 for each month?
Export the monthly GSTR-1 summary from the GST portal, the monthly GSTR-3B summary from the GST portal, and the monthly GST ledger summary from Tally. Mammoth matches the months, compares output tax and input GST, excludes Cess, and shows the months that do not match so you can review them before filing GSTR-9.
Which export files should you use?
Use the monthly summary exports from GSTR-1 and GSTR-3B in the GST portal, plus the monthly GST ledger summary from Tally. The workflow uses those exported files to compare the figures month by month.
What happens if a month does not match?
The workflow flags that month in the results. It does not change your figures, it shows you where the values differ so you can check the records before you file GSTR-9.
How do you change the comparison rules?
You can change the rules in plain words, for example by adding or removing fields, changing which totals to compare, or adjusting the month match. You can also say what to exclude, such as Cess, if you do not want it in the comparison.

Get early access to this workflow

It opens already built and working on sample files. Swap in your own exports to see your result.

Early access opens shortly. Check back soon.