cancel
Showing results for 
Search instead for 
Did you mean: 
Haole Boy
Level 2

View contents of qbo file outside of quickbooks

Aloha.  I'm having a problem with my credit card company.  They have a facility to create and download a qbo file for Quickbooks so that you can import transactions.  I have requested this file which should have over 100 transactions, but when I import it into Quickbooks, there are only around 10 transactions found.

 

I have called their support line, and they (of course) say that this is a Quickbooks problem. I really wish to have some definite proof of where the issue lies (QB or the credit card company). So, is there a way to open a qbo file so that I can see individual transactions? Best case would in a spreadsheet format, but anything where I can identify individual transactions would be very useful.

 

I'm running Quicbooks 2018 Desktop Pro Release R15P on Windows 10 1909. 

 

Mahalo,

 

Harry Z

Solved
Best answer May 10, 2020

Best Answers
BigRedConsulting
Community Champion

View contents of qbo file outside of quickbooks

You can view an OFX/QBO file by opening it in Notepad or other text editor.

 

If you open the file and find that it contains more than 10 transactions, then that probably means  QuickBooks is ignoring the rest because their ID's are below the "high water" mark saved when previously processing files for this account.

 

In turn, if that is not what you want, if you want to import them all, then the way to do that is to remove the bank feeds setup from the account (edit it from the chart of accounts to do that.)  Then import the QBO file again and QB will ask you what account it is for, and then it will import all of the transactions in the file.

View solution in original post

4 Comments
AlexV
QuickBooks Team

View contents of qbo file outside of quickbooks

Good day, Harry Z.

 

I understand that you need to import your bank transactions to your QuickBooks Desktop file.

 

We can only see the content of the .qbo file when it's being imported to QuickBooks Desktop. You'll want to look for a file converter so you can open it into Excel. 

 

Also, I have added these articles to guide you on how to fix web connect errors:

Please comment below if you have other concerns. Have 

Haole Boy
Level 2

View contents of qbo file outside of quickbooks

Aloha @AlexV,

 

I have been searching and have not found a free program to convert QBO to CSV or Excel. I don't want to pay $$ just to prove to my credit card company that they have a problem with generating the QBO file for their customers to download.

 

Can anyone suggest a utility to do this?

 

Harry Z

BigRedConsulting
Community Champion

View contents of qbo file outside of quickbooks

You can view an OFX/QBO file by opening it in Notepad or other text editor.

 

If you open the file and find that it contains more than 10 transactions, then that probably means  QuickBooks is ignoring the rest because their ID's are below the "high water" mark saved when previously processing files for this account.

 

In turn, if that is not what you want, if you want to import them all, then the way to do that is to remove the bank feeds setup from the account (edit it from the chart of accounts to do that.)  Then import the QBO file again and QB will ask you what account it is for, and then it will import all of the transactions in the file.

View solution in original post

Haole Boy
Level 2

View contents of qbo file outside of quickbooks

Aloha @BigRedConsulting. Mahalo nui loa!  I was able to open the QBO file with a text editor and see my transactions.  I have now imported them and get to start doing my reconciliations!  Whoo-hoo!

 

For anyone else who might want to take a look at the QBO file. You can open it with Notepad on Windows. Unfortunately, there are no line feeds, so it's just a few very wide lines that are hard to read. You can edit the file to add line feeds at the end of each transaction. I could not figure out how to do this with Notepad, but I used Notepad++ which has more functions.  This article explains how to do it.

 

The end of each transaction in the QBO file looks like this: </STMTTRN>  so you do a find on </STMTTRN> and replace with </STMTTRN>\n

 

Also note that your complete credit card account number is listed in the QBO file, so do not send this file to anyone without editing the credit card number.

 

Harry Z

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us