Highlighted
ob
Frequent Explorer *
23 Comments
Community Explorer **
Re: pdf conversion to qbo

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. 

 

Community Explorer ***
Re: pdf conversion to qbo
Look for PDF2QBO or "PDF to QBO" conversion app. For Quickbooks online, you may also convert to CSV instead of QBO, look for PDF2CSV or "PDF to CSV" conversion app.
Community Explorer ***
Re: pdf conversion to qbo

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.

Frequent Explorer *
Re: pdf conversion to qbo

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.

Community Host
Re: Pdf Conversion 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. 

 

@sergiy@hectorgarciacpa@bambamrubble, what would you say is the biggest advantage of your respective recommended conversion programs? 

Community Explorer ***
Re: Pdf Conversion to QBO

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.

ProAdvisor
Re: Pdf Conversion to QBO

What Hector says.  He did a webinar years back and Money Thumb is the best!  So easy to do (watch his videos) and to me, it works like magic!

Frequent Explorer *
Re: Pdf Conversion to QBO

Money Thumb is easy it just doesn't have the samme capabilities at Able2Extract

Community Explorer ***
Re: Pdf Conversion to QBO

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"

Community Explorer **
Re: Pdf Conversion to QBO

That's me, scrappy!

Community Host
Re: Pdf Conversion to QBO

Lol, what can’t you use Notepad for Smiley Wink

Frequent Explorer *
Re: pdf conversion to qbo

i have csv file but unble to import

Community Explorer ***
Re: pdf conversion to qbo
Look for a CSV2QBO or CSV2IIF converter and convert your CSV/Excel file to a compatible format.
Community Host
Re: pdf conversion to qbo

@sergiy, any recommendations for the best/cheapest tool for @XPERTSSOLUTION?

Community Explorer ***
Re: pdf conversion to qbo
James, both tools cost the same, search for CSV2QBO or CSV2IIF
Frequent Explorer *
Re: Pdf Conversion to QBO

Hi!

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

Community Explorer ***
Re: Pdf Conversion to QBO
For Quickbooks Online, please use ProperSoft PDF2CSV (please google it for the link), and select CSV target as "Quickbooks Online". Quickbooks Online Self-Employed imports CSV files only.
ProAdvisor
Re: Pdf Conversion to QBO

Community Host
Re: Pdf Conversion to QBO

Hey @ParkwayInc, what tool is this? Without context it's tough to figure out. Also want to advocate for @sergiy's recommendation as well. Glad there are lots of tools available. 

Frequent Explorer *
Re: Pdf Conversion to QBO

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

Frequent 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.

Community Host
Re: Pdf Conversion to QBO

@vicWeller, what would you say is the advantage of this over other tools? 

Frequent Explorer *
Re: Pdf Conversion to QBO

Thanks! That worked perfectly.