Importing Bank Transactions using QuickBooks Accountant Tools



Comments (6)

Comment Feed

Conversion Tools

A lot of people hace asked me if I prefer using Bank Feeds over Batch Enter.. and the quick answer is YES! But If I have the data in Excel or PDF only (and do not have it in .QBO format) then I use a tool called 2qbo Convert Pro to convert them:

Hector Garcia more than 1 year ago

Does PDFtoQBO work for Namibia

Hi, I have downloaded the trail versions for CSVtoQBO, QIFtoQBO, OFXtoQBO, and also 2QBO convert Pro, but cannot get the file (any one converted) to load into my Quickbooks 2010 Pro. The files seems to convert fine to QBO format, but when it tries to upload the file i get the following message "Quickbooks is unable to verify the Financial Institution information for this download. Please try again later." I have tried many of the different banks (Quickbooks FID nr's) as suggested for fault finding, but none works. I have used my Namibian bank account number in the settings. Not sure if the reason is because I am in Namibia and not in the USA. This leaves me with the question if this will work at all. If not then I need to probably upgrade to Quickbooks Accountant 2016, and use the excel batch import process to get my bank transactions and credit card transactions uploaded. Please advise if I am doing some thing wrong.

Antonie van Wyk 321 days ago

QuickBooks 2010 is unsupported for on-line services

Even when you are importing bank data via the *.QBO file format, you must have previously, or you must at the same time, set-up on-line banking to validate file access (it is a security thing). The problem is that your 2010 version of QB is no longer supported for on-line services (including on-line banking) so you can't get the initial verification required to access either your bank or a 'bank file download' even if you are converting it. 320 days ago

Start Up Time Saver

Thank you for this technique. As a business consultant I run into clients that don't have a formal set of books and this would be a great way to get them set up inexpensively.

Joyce Shimetz more than 2 years ago



Christy Bertani more than 2 years ago

Great info! One suggestion, though...

Thanks so much for posting this tutorial, which is very timely for me. The only thing I would do differently in Excel before the import process would be to sort by Payee name and then standardize the vendor/customer names more. Many bank transactions have unique numbers in them that would require adding a new name in QB for each transaction, causing a possible problem with list size limitations in QB. After sorting you could change the top name to be an actual vendor name, such as Best Buy, and leave off the rest of the data in the field, then copy and paste the name through the rest of the transactions that use that vendor. Depending on who uses the QB file, this might be very important for creating reports by vendor or customer name also. But I could see how this simpler method would be useful for tax preparers just wanting to get data in quickly to generate financials for year-end tax prep purposes only. Thanks again!

JL Reid more than 2 years ago

a small ad separator
Click to Subscribe
a small ad separator
a small ad separator
a small ad separator
a small ad separator
Built with Metro Publisher™