UPDATED 01/28/2018 by Hector Garcia, CPA
I am going to tell you about 3 tools I tested from the developer MoneyThumb:
- PDF2CSV – take original PDF Bank Statements from the bank (not scanned, but the ones you can download from the bank’s website) and converts to a CSV (Excel) file $99.95
- CSV2QBO – take a CSV downloaded from the bank (or maybe created by yourself with bank debit/credit info) and convert to a QuickBooks WebConnect file or .QBO file, used to manually import Bank Feeds (previously known as “Online Banking”) into QuickBooks Desktop (Pro, Premier, Mac, or Enterprise) and QuickBooks Online $59.95
- PDF2QBO – is kind of both tools above combined into one, go straight from PDF2QBO, the most practical way (assuming you do not wish to see/edit the data in excel before converting to .QBO ofx file $199.95
- 2qbo Convert Pro – ALL TOOLS DESCRIBED ABOVE INTO ONE $249.95
At the end of this article, there is a video tutorial, But here are the steps:
So the first Thing I did, was to go to chase.com and download an old Credit Card statements from 2010, since I can no longer download a CSV or .QBO (WebConnect) file for this, I would have to otherwise enter this data by hand. For illustration purposes, my statement looks like this:
Which in my case, I made the mistake of not doing it, and I had to redo the import file afterwards, but this will depend on your bank statement.
After deleting the data you do not want, and adjusting anything you need, then you can save the CSV and proceed to use the next tool: CSV2QBO
The 3rd Tool: PDF2QBO is designed so you do not have to use two tools to perform this end result, goes straight to QBO from PDF, the only drawback is you cannot edit the spreadsheet before importing, sometimes that could be useful, specially of the PDF was not read too well.
This tool looks identical to the the two I showed above, the developer did a good job at staying consistent with the interface
But on this one you get check a checkmark and you can choose what you want to bring and what you do not.
Hector Garcia, CPA
“Fighting the War on Data Entry”