In a nutshell, if you have a PDF bank statement from your bank or downloaded a CSV file and would like to import it into QuickBooks using Bank Feeds (Online Banking), this is an article you may want to pay attention to.
Note: if your bank transaction data is in an EXCEL file, this will work as well.
Here is a video that explain how the converter software works (video is from 2018, but 100% relevant to 2020):
Step 1, convert your original Bank Statement PDF onto a CSV (Excel File), it is important to mention that SCANNED bank statements do not count. Launch PDF2CSV and load the bank statement:
Step 2, you can open it in EXCEL and make any changes you want, maybe you can rename some vendors or concatenate the Description and Memo fields, if you are skilled in excel you know what i mean… otherwise, you can leave the file as is and proceed to convert to .QBO (Please note if you are NOT going to make changes in EXCEL, then just get 2qbo Convert and skip this step)
Step 6, LASTLY, finish the conversion and 2qbo Convert will create a .QBO file in the same folder where the PDF/CSV was in, and now you can import it as “Web Connect” in QuickBooks…
And enjoy a world with LESS data entry!
For more information, you can buy this app for $349 at 2qbo Convert Pro
Consider partnering with us, to help you get your PDF Statements or Excel/CSV files converted into QuickBooks if you got large projects, this is our area of expertise.
Hector Garcia, CPA
Excel to QuickBooks Data Importing Specialist