GSTR-3B vs GSTR-1 reconciliation
“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”
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.
- FileGST portal GSTR-1 summaryCSV export · 12 rows
- FileGST portal GSTR-3B summaryCSV export · 12 rows
- FileTally GST ledger monthly summaryCSV export · 12 rows
- StepTotal GSTR-1 taxStep 3
- StepTotal GSTR-3B taxStep 1
- StepTotal Tally GSTStep 2
- JoinBring in GSTR-3B12 of 12 paired
- StepMatch the month keysStep 5
- JoinBring in Tally GST12 of 12 paired
- StepShow months that differStep 7
- ResultMonthly GST differences4 rows · 4 flagged
- ScheduleRuns when you sayProposed
On the sample files, every step runs and the result has 4 rows.
- Download GST portal GSTR-1 summary sample (12 rows)GST portal: Returns > GSTR-1 > Download summary
- Download GST portal GSTR-3B summary sample (12 rows)GST portal: Returns > GSTR-3B > Download summary
- Download Tally GST ledger monthly summary sample (12 rows)Tally Prime: Display More Reports > Statutory Reports > GST > GST Ledger Summary
What you get back
The result of that run, the rows to look at first.
| Month | GSTR-1 output tax | GSTR-3B output tax | Tally output tax | GSTR-3B ITC | Tally Input GST | Status |
|---|---|---|---|---|---|---|
| Aug-2025 | 396,000 | 396,000 | 396,000 | 104,000 | 94,000 | Input GST differs |
| Jan-2026 | 448,000 | 442,000 | 448,000 | 106,000 | 100,000 | Output tax and input GST differ |
| Jun-2025 | 410,000 | 406,000 | 410,000 | 94,000 | 94,000 | Output tax differs |
| Nov-2025 | 406,000 | 402,000 | 406,000 | 93,000 | 93,000 | Output tax differs |
How it works
How to use the Monthly GST differences workflow
- 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and working on 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.
Monthly GST differences: questions
How do you reconcile GSTR-3B vs GSTR-1 for each month?
Which export files should you use?
What happens if a month does not match?
How do you change the comparison rules?
Get early access to this workflow
It opens already built and working on sample files. Swap in your own exports to 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