laura9
Level 1
‎December 10, 2018 05:22 PM

How to import pdf bank statements?

My bank only exports pdfs of my bank statements. I have a lot of expenses to log from the last year. What's the best way to import in to desktop quickbooks? 
Reply Join the conversation
abiolapharm
Level 1
‎December 10, 2018 05:22 PM

Reports and accounting

how did this Money thumb work for you?
Reply Join the conversation
hectorgarciacpa
Level 4
‎December 10, 2018 05:22 PM

Reports and accounting

for me works great.. if you have scanned statements, you must get the PLUS version..

https://www.moneythumb.com/converters-2quickbooks/?ref=1

Reply Join the conversation
Quickbpro
Level 1
‎December 10, 2018 05:22 PM

Reports and accounting

Here is a video of the software that does the conversion
<a rel="nofollow" target="_blank" href="https://youtu.be/s-wbBTNVYBM">https://youtu.be/s-wbBTNVYBM</a>
Reply Join the conversation
Quickbpro
Level 1
‎December 10, 2018 05:22 PM

Reports and accounting

There are to apps that could do this:
ScanWriter: any bank statements (even scanned) can be imported directly into QuickBooks
MoneyThumb PDF2QBO: only works with DIGITAL Bank statements and it will convert them to .QBO which have to be imported via bank feeds (2 steps)
 
I use both apps currently, and sometimes in combination.
Reply Join the conversation
Michelle-Long-CPA
Level 4
‎December 10, 2018 05:22 PM

Reports and accounting

There are 3rd parties that will convert PDF bank statements into files to be imported into QB. Google it or check out a new one www.bankfeedme.com 

Reply Join the conversation
SkinnyRaven
Level 8
‎December 10, 2018 05:22 PM

Reports and accounting

There is no import of .pdf files, your options are .iif and .qbo
Reply Join the conversation
Anonymous
Not applicable
‎December 10, 2018 05:22 PM

Reports and accounting

If you can convert your PDF's to Excel, or download CSV or Excel files, then you can import using an IIF file. Use the IIF Transaction Creator to help you create the IIF for import file from your worksheet data.


Reply Join the conversation
DBL07-co
Level 1
‎December 10, 2018 05:22 PM

Reports and accounting

Why Doesn't intuit make a way to import .pdf files since ALL BANKS export monthly statements in PDF? DBL07.co
Reply Join the conversation
StevePVB
Level 4
‎December 10, 2018 05:22 PM

Reports and accounting

Most banks provide a QBO option for the QuickBooks download.  I can't even imagine the technical challenge of scanning/importing PDF files -- every bank has their own format.  Using the QBO file puts everything in a known format.
Reply Join the conversation
Anonymous
Not applicable
‎December 10, 2018 05:22 PM

Reports and accounting

I agree with Steve. I don't think importing data from PDF files would ever work as a feature.  PDF's are a nightmare to parse, and they're all different, and some don't even really contain text, but instead images of text.
It'd be like saying QB should handle "CSV" files, which have a similar issue in that they're all different, but at least they actually contain text.
Reply Join the conversation
DBL07-co
Level 1
‎December 10, 2018 05:22 PM

Reports and accounting

My bank does "supply" quickbook downloads, but only for last 3 months and anything before that I have to pay for! As if they haven't got enough of my $
Reply Join the conversation
Michelle-Long-CPA
Level 4
‎December 10, 2018 05:22 PM

Reports and accounting

My bank charges $6.95 for 12 months and $9.95 for 24 months.  It's not much and worth it so I can import things when needed.  At least they make it available whereas other banks do not.  3 months and that's it.
Reply Join the conversation
StevePVB
Level 4
‎December 10, 2018 05:22 PM

Reports and accounting

At least you have an option to pay rather than manually entering last year data.  It would be a one-time expense and would save time.  Going forward you would just need to stay current.
Reply Join the conversation
seletit4
Level 1
‎December 10, 2018 05:22 PM

Reports and accounting

ProperSoft PDF2QBO converts PDF to QBO files. Your will get free support before and after the purchase.

Reply Join the conversation
Lioness-15
Level 1
‎January 06, 2019 05:47 AM

Reports and accounting

Convert to excel files then clean them up and convert the excel files to a .qbo file and import to quickbooks. I am using CSV to QBO converter and it works great saved a lot of time when I had 3 years of pdf bank statements.

Reply Join the conversation
Lioness-15
Level 1
‎January 06, 2019 05:52 AM

Reports and accounting

I convert pdf to excel files using Adobe. Then clean them up a little and use a program called CSV to QBO converter you can find on line. I had 3 years of pdf bank statements and used this method.

Reply Join the conversation
Anonymous
Not applicable
‎January 07, 2019 03:54 AM

Reports and accounting

Hello Lioness-15,

 

We're glad to hear that you're able to convert the PDF file to CSV. Let me share with you an article on how to import a CSV file. Here it is: How To Import Bank Transactions Using Excel CSV Files.

 

Once you've imported the file, here's how toadd/categorize bank transactions: 

  1. In the Banking page, click on the For Review tab.
  2. Select the transactions and click on Batch actions.
  3. Choose Accept Selected (for multiple transactions)/click on the Add button for single transaction.

If you need anything else, please let us know. We're here to help. 

Reply Join the conversation
mineola siding plus
Level 1
‎January 19, 2019 04:36 AM

Reports and accounting

i need the same help

Reply Join the conversation
JenoP
Moderator
Moderator
‎January 20, 2019 07:50 PM

Reports and accounting

Thanks for joining us here, mineola siding plus.

 

Do you still your bank statements in PDF? If so, you will need to convert them first to Excel or CSV.

 

You can follow the same steps or use the third-party apps recommend in the previous replies. Once you're file is converted, you can then import it in QuickBooks.

 

Let me know if you run into an error when importing the file so we can help you again.  

 

Reply Join the conversation
TransportZero
Level 1
‎April 11, 2019 02:53 PM

Reports and accounting

Exactly! SMH

Reply Join the conversation
TransportZero
Level 1
‎April 11, 2019 03:08 PM

Reports and accounting

I can't belive the only way to convert PDF bank Statments to QBO is by sending a sensitive bank statement to a 3rd parties Apps Converters. This is Disappointing!

Reply Join the conversation
modest hawking
Level 1
‎May 29, 2019 09:38 PM

Reports and accounting

You can try https://www.docuclipper.com. It can extract text & tables from PDF documents and automatically create a Google Spreadsheet. It can also import PDF invoices into QuickBooks directly. 

Reply Join the conversation
hectorgarciacpa
Level 4
‎June 02, 2020 09:34 PM

Reports and accounting

I use it all the time, works great

 

Reply Join the conversation
cmtcav420
Level 1
‎July 30, 2020 02:46 PM

Reports and accounting

can you share this app with me for free?


cheers,

Reply Join the conversation