You can open pdf files using Word. You could then copy all text and paste into a notepad file, import that data into an excel or csv file, and then import into QB. Might be a royal pain but it could certainly work.
I created a video on this subject... should clarify the whole process. NOTE: you need a 3rd party app to convert from PDF into CSV or QBO... QuickBooks does not have the capaciy to recognize a PDF statements.
I use Able2extract. It works great with bank statements but also has many more capablities. For importing into QBO use A2E to convert to excel and then upload to QBO.
Hey @ob, looks like you have several good options. Which one did you pick?
@srmcmahon, I love the scrappy Notepad approach, I still copy most of my HTML and CSS (yes, I still write in those! I've just aged myself) in Notepad.
I have used both "PDF2QBO" programs by MoneyThumb and by Propersoft.... I would say Propersoft at $49 vs $59 for MoneyThumbs is a better deal.
But I think thank MoneyThumb has a couple of extra features... Eitherway, they are both great. Propersoft's was the first one I used, and I use to promote it a lot through my blog (not to mention a few affiliate payments I got); but I moved to MoneyThumb because of the PDF technology they have, which is the strongest in the market at the moment SPECIFICALLY for bank statements. Their PDF2QBO, PDF2CSV, and 2qbo Converter Pro products are the best in the market for converting bank and credit card statements specifically.
Other programs like Able2Extract and PDF2XL are actually much more POWERFUL general conversion software, but are not designed for bank statements exclusively, so there is too much "clean-up" and finagling within the software to make these tools useful for bank statement conversion.
Lastly there is Personable's ScanWriter, which is enterprise-level bank statement to csv/quickbooks conversion... the strongest contender, but the cost is a bit prohibitive for small firms and small businesses at about $1,000 initial investment plus $49 a month per company.
You can e-mail me anytime about this ([email address removed]). I may be one of the handful of CPA/ProAdvisors that actually has used ALL these technologies in practice in the last decade.
Able2Extract is probably the most powerful PDF to WORD (maybe Excel) extractor out there... but is not functional for Importing into QuickBooks. I really Like PDF2XL as well. The challenge is then reformatting the word/excel file for it to be "QuickBooks friendly"
I am using "quickbooks self-employed" (which is online, but not to be confused with "quickbooks online"). They are asking me for CSV files, and so I need to convert from PDF (from bank of america) to CSV.
Does the program that you mentioned to that, or do you know of another solution?
thanks so much
You might well try to do so by exporting the pdf to word at first https://www.altoconvertpdftoword.com/ The thing is, all the conversion tools to QBO I've tried don't recognize the pdf's ocr well but there's no such an issue with ms office ones
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.