Purchase vs GST portal reconciliation
Two months of supplier filings, 120 booked invoices, 38 suppliers: the bot downloads, matches and classifies every invoice, then fills GSTR-3B Table 4 with a tie-out that must come to zero.
ExcelTax portal (demo)
- Who
- Accounts or AP executive at a company that buys from dozens of suppliers
- When
- Every month, before GSTR-3B is due on the 20th
- Why
- Input credit follows what suppliers filed, not what you booked. Claim on an invoice the supplier never filed and you get a notice; miss one they did file and the money is left on the table.
180supplier filings across two months
120invoices in the books
38suppliers, names typed every which way
126reconciliation lines
35exceptions classified
0unexplained difference
What it does
- Logs in to the demo tax portal
- Downloads August's supplier filings (GSTR-2A, 117 invoices)
- Downloads September's too (63 invoices), to catch suppliers who filed late
- Pastes both into the reconciliation workbook next to the purchase register (120 invoices)
- Normalises invoice numbers, so INV/2526/1234 and inv-2526-1234 count as the same invoice
- Matches in two passes: GSTIN + invoice number, then GSTIN + value. Every invoice lands in one of five outcomes
- Works out the credit treatment per invoice: availed, capped at portal value, reversed under Sec 17(5), deferred, not availed
- Fills GSTR-3B Table 4 from the portal figures
- Checks the books-to-portal difference is fully explained: unexplained must be zero
What the bot hands you
- Table 4(A)(5): input credit per portal₹17,38,961
- Table 4(B)(1): reversed under Sec 17(5)₹1,36,786
- Table 4(C): net credit to claim₹16,02,175
- Hold from 4 suppliers who never filed₹19,999
- 5 suppliers filed late: claim next month, not lost₹63,718
- 6 invoices on the portal nobody booked₹58,879 to record
Screens





Try the demo portals
Inside the workbook
- GSTR-2A (Portal) and (Sep Portal) The two downloads, pasted as-is
- Purchase Register The books, deliberately messy: spacing, slashes, lowercase GSTINs
- Reconciliation 126 lines, 28 columns: four checks per invoice, outcome and credit treatment
- Vendor Follow-up Suppliers to chase, with the GST to hold back from their payment
- GSTR-3B Working Table 4 filled from the recon, with the books-to-portal tie-out
- Summary & Control Counts, credit, where the difference sits, and a pass/fail verdict
- Exception Pivot Exceptions by type: lines and tax per books and per portal
Sample files
- Purchase_GST_Recon_Aug2025.xlsx (input: the reconciliation workbook with August's purchase register. The bot starts here)
- Purchase_GST_Recon_Aug2025_expected.xlsx (expected output: what the workbook looks like after the bot runs)
Get the bot
Coming soon.
How to run it
- Install Operative and the Guerrilla Bots extension
- Operative > Import the .gbw
- Download the input workbook into the bot's working folder
- The demo tax portal accepts any password
- Run, then open GSTR-3B Working: the unexplained difference should be 0