Community Explorer **

Re: Pdf Conversion to QBO

I have a lot of clients who for one reason or another don't link their bank accounts and can't seem to download a csv file.  That or the banks/cc companies don't have it as an option.  Thus, I too am often stuck with .pdfs to somehow convert.  Most of the apps just don't work right for one reason or another (although I do use csv2qbo for desktop clients A LOT!)

 

Since, I know a few developer friends, I have had them create a script that takes a .txt file (see below) and converts it to a csv.  Since the statement has a lot of text that isn't necessary, I open the text file and delete that information.  The script works good for formatting and recognizes dates and spacing in order to efficiently separate items into correct columns.  I then open the csv and edit it some as it does occasionally miss things.  But I am also updating the script as I find things.  It works wonderfully for Bank of America Statements.  And MOST DEF better than converting to Word.

 

If anyone is interested in knowing more let me know.  I could possibly have this created on the web and modified for each banks specific statements.  Right now I just run it from my desktop.