Hi Folks
I m sure someone could help.
I am struggling for the last few days now to search for any software which I could use to convert pdf files to one of the following formats:
Microsoft Money (.ofx)
Quickbooks (.qbo)
Quicken (.qfx)
Simple Accounting (.aso)
Any help would be much appreciated as always.
Replies (10)
Please login or register to join the discussion.
Unusual conversion formats ...
Would suggest that you may be looking for something that doesn't exist (possibly wrong)
Try an alternative approach by converting the PDF to another 'standard' format such as Excel and csv - then see about importing the result into your preferred app
Able2Extract?
Hi Arsalan,
I've been very impressed by software called Able2Extract. It has been able to convert complex tabular layouts with headers and footers for me where other products (including Adobe's!) have failed. That ought to get you as far as Excel/CSV reliably. Like JC, I can't help past that but it should get you to stage 2 of a 2 or 3 stage approach.
I hope this helps.
Are these
bank statement pdfs? In that case look at Autorec which is designed to OCR statements and export to csv or a number of other formats
Bank statements to csv
To convert bank statements to csv/Excel, try Statement Reader. Excellent quality and pretty cheap (pay per page).
Try Foxit as a pdf Reader
Download Foxit [which is free] -it enables pdf documents to be edited.
Use Adobe Acrobat Professional
Load PDFs into Adobe Acrobat Professional, crop pages to suit if necessary, then export document to Word Document, where any tables will be shown as table in a box, which box can be expanded as necessary, and all info copied and then pasted into an Excel blank table. From there you should be able to import into your favourite accounting package or whatever ... Just done this on my iMac so definitely works for Macs.
The only editing I did was to add a simple formula to the Balance column, and then copy down, so that the Balance column did actually work as an active balance, rather than just show figures ... if that makes sense.
Seconding Acrobat
Converting from PDF in general is never ideal, but Acrobat is definitely the tool for this kind of thing. It's immensely powerful and flexible, and you can use the demo free for 30 days.
I beg to differ.
Converting from PDF in general is never ideal, but Acrobat is definitely the tool for this kind of thing. It's immensely powerful and flexible, and you can use the demo free for 30 days.
Except that, on more than one occasion, Acrobat, and others, have not been able to cope with successfully retaining the critical columnar formatting of complex PDF documents. I have no vested interest in Able2Extract, but it is the only product I've come across that has been able to cope with anything I've thrown at it. Free trial available for anyone to have a look too.
I suppose all I'm saying is that, if Acrobat or your other conversion program can't do it, don't assume it can't be done without giving Able2Extract a try.
Able2Extract takes ages if you scan over 100 pages. It Is very slow. It is even much slower if you use the "Custom format". Most OCR software are good in something, but not always. I do not think there is near perfect software exist on the market as far as I know. I do not know what Banks use for OCR.