← All demos

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

  1. Logs in to the demo tax portal
  2. Downloads August's supplier filings (GSTR-2A, 117 invoices)
  3. Downloads September's too (63 invoices), to catch suppliers who filed late
  4. Pastes both into the reconciliation workbook next to the purchase register (120 invoices)
  5. Normalises invoice numbers, so INV/2526/1234 and inv-2526-1234 count as the same invoice
  6. Matches in two passes: GSTIN + invoice number, then GSTIN + value. Every invoice lands in one of five outcomes
  7. Works out the credit treatment per invoice: availed, capped at portal value, reversed under Sec 17(5), deferred, not availed
  8. Fills GSTR-3B Table 4 from the portal figures
  9. 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

Summary after the run: control check passed, every rupee explained
Summary after the run: control check passed, every rupee explained
GSTR-3B Table 4 after the run: the difference is fully explained, unexplained 0
GSTR-3B Table 4 after the run: the difference is fully explained, unexplained 0
The reconciliation: every invoice checked four ways and classified
The reconciliation: every invoice checked four ways and classified
Suppliers to chase, with the GST held back from their payment
Suppliers to chase, with the GST held back from their payment
Exceptions by type: lines and tax per books and per portal
Exceptions by type: lines and tax per books and per portal

Try the demo portals

Demo tax portal

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

Get the bot

Coming soon.

How to run it

  1. Install Operative and the Guerrilla Bots extension
  2. Operative > Import the .gbw
  3. Download the input workbook into the bot's working folder
  4. The demo tax portal accepts any password
  5. Run, then open GSTR-3B Working: the unexplained difference should be 0