- Home
- Case studies
- Finance & CA
GST reconciliation: from three hours to under five minutes
A chartered accountancy firm in India. Tally to Python to Excel, fully automated.
<5 minper report, down from about 3 hours
Exceptions onlypeople review just the entries that need judgement
Every monthruns on schedule, with a log of every run
The challenge
What wasn’t working
Every month, the team exported data from Tally and reconciled it against GST records by hand in Excel. Each report took around three hours, and the work bunched up at month-end when everyone was busiest.
What we built
The solution
- 1
A Python pipeline pulls every transaction for the month straight from Tally.
- 2
Each entry is matched against GST portal data line by line.
- 3
Mismatches go to a short review list; everything else is cleared automatically.
- 4
GSTR-1 and GSTR-3B drafts are produced in Excel and sent to the team by WhatsApp and email.
Built with: Python, pandas, openpyxl, Tally, WhatsApp, email
“Our monthly GST reconciliation used to eat an entire day. Now it runs itself before we’ve even had coffee.”