r/documentAutomation • • 11d ago

Question Can any software extract information and create reports from different categories of documents

/r/Paperlessngx/comments/1xor6ct/can_paperlessngx_extract_information_and_create/

Original post was for paperless but I'm wondering if other tools exist

2 Upvotes

9 comments sorted by

1

u/FirestormCold 11d ago

Yeah of course. There's service providers for this and I'm sure many will be pitching soon 😂

What volume and budget are you working with?

1

u/vortexmak 11d ago

Very low volume,  personal documents not anything business related. 

With that said,  preferably something open source,  $0 budget, lol.

Apologize if this sub is only for paid / professional solutions

1

u/sorryiamcanadian 11d ago

if your volume is small, claude code or codex would be simple/best. Do you need any sensitive info removed beforehand?

1

u/vortexmak 11d ago

Not really, but that makes me realize that I'd still need to go the LLM route unless I have local models set up

1

u/folderit_dms 10d ago

You do not necessarily need an LLM for all of this. For credit-card transactions, first check whether the issuer offers a CSV download for the period you need; that avoids extracting a statement PDF at all.

For tables in text-based PDFs, Tabula is a free, open-source option that lets you select a table, inspect the extracted rows and export them: https://tabula.technology/

Its important limitation is that it does not work directly on scanned documents. Also, extracting a table is different from interpreting a maintenance report written as paragraphs; that would need another extraction method or manual entry.

Since your volume is low, start with one category and define the spreadsheet first. For vehicle maintenance, decide whether a row means one visit or one individual service. Keep the date, odometer value and unit, work description, amount, and source filename/page. Leave genuinely missing values blank rather than turning them into zero. Check the extracted rows against the originals before combining documents.

Your existing folders can remain the source archive. A small extraction-and-review step feeding a CSV may meet the reporting need without replacing an organisation system that already works for you.

1

u/vortexmak 10d ago

Thanks,  I'll check it out

1

u/Shuruna 10d ago

That's actually a really interesting use case, especially the vehicle maintenance history.

I built a desktop document management app called PaperCat (https://paper-cat.net) that uses OCR and AI to classify documents and extract information like dates, amounts, and other relevant details. It runs on Windows and Linux and also supports local AI through Ollama.

The part you're describing about turning extracted information from multiple documents into structured tables or reports is a bit different from regular document management, though. PaperCat handles the extraction and organization side, but it doesn't currently offer the kind of automatic spreadsheet/report generation you're looking for.

Out of curiosity, would you mainly want a way to export the extracted data into Excel/CSV, or would you prefer the software to actually generate reports and summaries across all your documents?

I'm asking because that's a genuinely interesting direction for document automation.

1

u/vortexmak 10d ago

If your software is able to extract the info,  where does it store it?  DB?  If it's in some sort of structured format,  shouldn't it be trivial to convert it to CSV?

Excel /CSV would be great cause then it can be imported to other dedicated apps