Tool to convert GST invoice PDFs into Excel — feedback welcome

Hi Ajay,

This is a very relevant utility for accounting firms and finance teams. Manual purchase register entry from vendor PDFs is indeed a major operational bottleneck.

While standard ERPs handle outgoing sales and GSTR-2B auto-pulls summary tax data, they do not extract line-item HSN, quantity, and item-level details from incoming vendor PDFs.

A few suggestions to make your tool even more valuable:

1. Scanned PDF Support: Ensure strong OCR capability for scanned or camera-captured invoices.

2. Tally/Excel Import Templates: Offer option outputs mapped directly to Tally XML/Excel purchase import formats.

3. Error Flags: Highlight state code vs. tax type mismatches (e.g., CGST/SGST charged on inter-state GSTINs).

Hi Aashok ji,

Thank you for such detailed and practical feedback, this is exactly the kind of input I was hoping for.

The state-code vs tax-type mismatch flag is a great suggestion, and it fits naturally since the tool already reads both GSTIN state codes. I'll work on adding it. Tally/Excel import formats and OCR for scanned invoices are both on the road map.

Out of curiosity, which format do most of your clients import purchase data into, Tally Prime or something else? It would help me prioritise.

Thanks again,

Ajay

Hi Aashok ji, a quick update: I've added the GST mismatch check you suggested. It now flags CGST/SGST charged on an interstate supply, IGST on an intrastate one, and unequal CGST/SGST amounts, using the Place of Supply where it's printed and the GSTIN state codes otherwise. The results appear in the Excel output too.

If you'd like to see it on a few real invoices, I'd be happy to share a free trial or run a sample batch for you.

Sincere thanks

Ajay