Mini-project
Banking & Fintech
GST invoice reconciliation tool
Match purchase invoices in the books with supplier invoices in GSTR-2B, and list what is missing or wrong.
The brief
A business loses input tax credit when its purchase books do not match what suppliers filed. Build a tool that matches the two lists by supplier, invoice number, date and amount (allowing small differences), and reports matched, missing, duplicate and mismatched invoices with the credit at risk. Good looks like: sensible fuzzy matching, a report an accountant can act on, and the tax value of each type of mismatch.
What you will build
- Read the GSTR-2B and purchase register formats
- Generate or load both lists
- Clean supplier names and invoice numbers
- Match exactly, then with tolerance
- List unmatched and mismatched invoices with credit at risk
- Export a follow-up list per supplier
Free, open data to build it with
Sign up free to get the data and links
It takes a minute with your email. AiTeky Pass (₹999/month or ₹9,999/year) is free for your first 30 days.