GSTR-1 vs sales register
“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”
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.
- FileTally sales registerCSV export · 30 rows
- FileGSTR-1 B2B details downloadCSV export · 30 rows
- StepNumber Tally invoice linesStep 1
- StepNumber GSTR-1 invoice linesStep 2
- JoinBring in GSTR-1 lines27 of 30 paired
- StepMatch invoice lines and show statusStep 4
- ResultB2B Invoice Reconciliation33 rows · 7 flagged
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 33 rows came out, and the join paired 27 of 30 rows.
- Download Tally sales register sample (30 rows)Tally: Display > Account Books > Sales Register > Alt+E export
- Download GSTR-1 B2B details download sample (30 rows)GST portal: Returns Dashboard > GSTR-1 > B2B Invoices > Download Excel
What you get back
The result of that run, the rows to look at first.
| GSTIN | Invoice number | Customer | Status | Tally invoice date | GSTR-1 invoice date | Tally taxable value | GSTR-1 taxable value |
|---|---|---|---|---|---|---|---|
| 27AAACH6677S1Z7 | SR-1018 | Harbor Foods | Not reported | 2026-10-18 | · | 13,400 | · |
| 27AAACH6677S1Z7 | SR-1028 | Harbor Foods | Not reported | 2026-10-28 | · | 16,500 | · |
| 29AAACG8844R1Z9 | SR-1027 | Garnet Home | Not reported | 2026-10-27 | · | 12,750 | · |
| 27AAACH6677S1Z7 | SR-1008 | Harbor Foods | Not in books | · | 2026-10-08 | · | 9,900 |
| 29AAACG8844R1Z9 | SR-1028 | Garnet Home | Not in books | · | 2026-10-28 | · | 16,500 |
| 33AAACE2211P1Z6 | SR-1031 | Everest Supplies | Not in books | · | 2026-10-30 | · | 8,000 |
| 29AABCB7788L1Z2 | SR-1012 | Bluebell Retail | Differs | 2026-10-12 | 2026-10-12 | 15,000 | 14,000 |
| 07AAACF5566Q1Z1 | SR-1006 | Fable Electronics | Agrees | 2026-10-06 | 2026-10-06 | 21,950 | 21,950 |
| 07AAACF5566Q1Z1 | SR-1016 | Fable Electronics | Agrees | 2026-10-16 | 2026-10-16 | 12,600 | 12,600 |
| 07AAACF5566Q1Z1 | SR-1026 | Fable Electronics | Agrees | 2026-10-26 | 2026-10-26 | 10,100 | 10,100 |
| 09AAACI1122T1Z3 | SR-1009 | Indigo Office | Agrees | 2026-10-09 | 2026-10-09 | 16,800 | 16,800 |
| 09AAACI1122T1Z3 | SR-1019 | Indigo Office | Agrees | 2026-10-19 | 2026-10-19 | 15,700 | 15,700 |
How it works
How to use the B2B Invoice Reconciliation 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.
B2B Invoice Reconciliation: questions
How do you reconcile GSTR-1 with your sales register?
Which exports should I use for this workflow?
What happens to invoices that do not match?
How do I 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