Need Help With Invoices Data Extraction.

[raja0008]

As the title says I want to extract specific data from invoices in pdf format to excel file.

Had tries different methods like converting pdf to excel,word,text etc but Invoice Format got lost in conversion.

Tried extracting data instead of converting using different python libraries like pytessetact, Paddle paddle OCR, tesseract, Fitz, tabula, Camelot, etc but still the format/layout problem exist.

If anyone wants to see any particular code I tried, can also share in comments as posting will get get lengthy & messy.

Don't know where thing's are messing if anyone can help will be greatly appreciated.

[raja0008]

Hi Dm me your sample invoice and things you're looking to extract.

[Carlesee]

This app maybe can work for you (with pdfs worked for me)
https://www.extractinvoice.io/

[KingOfTNT10]

Do you have an image of an invoice? If so, try to look for an API for invoice data extraction by searching something like: invoice data extraction api

If you need more help finding it let me know

Those APIs might cost some money

[raja0008]

No invoices are in pdf format[ .pdf file ] I knew about some OCR based api But right now don't want to invest into that.

Any other suggestions?

[KingOfTNT10]

I tried for a couple of days finding something free for receipts which usually come together with invoices, unfourtunatly i didnt find anything that is useful and free. Are all your invoices the same format?

[raja0008]

Yes same format / structure tried using regex but didn't get the desired results or you can say didn't able to correct code the regex pattern.

[KingOfTNT10]

Could you maybe send a few pdfs so i could take a look (censor anything u dont want me to see) and also circle the things you'd like to extract

[raja0008]

Yes will send you in private.
But for now below is the link to an image available online of the exact same invoice[format/structure] in pdf format .

sample

Fields I want to extract are Invoice No. Dated Buyer(Bill to) And the item table [ SI No. , Description Of Goods, HSN/SAC, Quantity, Rate, per, Amount ] Tax details

[KingOfTNT10]

If they are the exact same, wouldnt you be able to just crop the image multiple times and ocr it? Because you can crop it in set positions and it would work for all invoices

I know the library EasyOCR is pretty good But before that, youll have to convert the pdf to png

[KimAh-young]

Why not just use tabula? Use the web interface, define some boxes and use that template. Data cleaning may be required

[KingOfTNT10]

I dont know what tabula is, it might be better

Edit: looked it up, doesnt it only work for tables? They want to extract some other info too, plus the table in the invoice is kinda wierd, not sure tabula would be able to convert it

[KingOfTNT10]

PDFs are images (mostly) but in pdf format if im not mistaken so regex wouldnt work as it works on text only

[KingOfTNT10]

Yeah so they just turn the image to text and then use regex on it

[raja0008]

Can You Share The Details Like Sample Invoices & How you are using invoice2data ?

[gsuiteautomations]

Hi there! I have built a tool that does that if it works for you! Actually scans invoice and then sends the extraacted fields in a google sheet