I am trying to parse bank statements and credit card statements into a machine-readable format.
The bank statements are issued as (unprotected) Pdf documents.
I am looking for a tool that can convert these Pdf documents into something easier to process, like .csv or .xls
The data in these documents is shown in a weird table-like format, e.g.
DATE SUBJECT AMOUNT VARIABLE NUMBER OF FIELDS, DEPENDING ON THE TYPE OF TRANSACTION. TWO FIELDS MAY BE ON THE SAME LINE AND A SINGLE FIELD MAY SPAN TWO LINES DATE SUBJECT AMOUNT ....
Additional difficulties include:
- A single entry can be broken up over two pages.
- Header and footer have variable height and content.
- Some pages contain advertisements.
So I am looking for a software with the following features:
The software should deal with the weird multi-line input format. Simply parsing everything as fixed width tables, with one row per input row, would require a lot of editing afterwards.
should run on Windows, ideally Windows XP
should not require MS Office 10 or newer. Ideally not an Office plugin at all, but a stand-alone program.
Should not require excessive manual interaction during conversion, but also not excessive manual correction afterwards. Some amount of interaction is good, if it reduces the need for post-editing.
an offline tool would be strongly preferred, since these files are confidential.
either open source or a big, renowned publisher are preferred, for the same reason.
a large support base and active community for this tool would be a big plus
free software preferred, but a moderate one-time investment would be acceptable (if clearly superior to the free solution)
The volume of these pdf files is limited. For now I am looking to convert less than 100 files, so batch-conversion of 10000 files is not a priority.
It is no problem if the software requires advanced knowledge about regexp, parsing, etc. It should just be easier than writing my own parser from scratch.