Skip to main content
S
Stephen14
September 24, 2019
Question

Error reading QBO file form Barclays Business account

  • September 24, 2019
  • 1 reply
  • 0 views

Hi,

 

Can anyone help with this problem please? I'm having problems uploading account information from my Barclays Business account. It says its a Quickbooks QBO file but when I try to open it it says its a Quickbooks OFX data file, which I know is not compatible! See images below.... I have tried saving the file and then manually importing it but it has the same result.

 

 

Any ideas anyone??

1 reply

katherinejoyceO
katherinejoyceO
September 24, 2019

Hello there, @Stephen14.

 

Welcome to the Community. I understand the urgency of downloading your transactions from Barclays Business Banking account. Let me share a few insights about why you're getting this error when uploading bank transactions using the web connect in QuickBooks Desktop. 

 

QuickBooks web connect can only read a .QBO file format. Since you have a different type of file, I'd suggest you sign in to your bank's website and download a .qbo file and save it to your computer. 

 

If you have trouble finding it, you can contact your bank to verify if they can provide a .QBO file. Once you have the file ready, follow these steps below to import the .qbo file:

 

  1. Go to the File menu.
  2. Select Utilities. 
  3. Choose Import, then Web Connect Files.
  4. Select the QBO file you saved, then click Open.
  5. When prompted to Select Bank Account, select:
  • Use an existing QuickBooks account if the account you are importing the transactions into is already set up in QuickBooks.
  • Create a new QuickBooks account if the account you are importing the transactions into is not yet in QuickBooks. Type a name.

       6. Click Continue. 
       7. Click OK after seeing the message: Data has been successfully read into QuickBooks.  

 

Once completed, you can go to the Bank Feeds Center to review your transactions.

 

For more information, you can also read through our help article: Fix Web Connect import errors. It contains different error scenarios while using the web connect and how to fix them. 

 

If in case your bank don't support .QBO file, you can search for a file conversion tool in Google to help you. 

 

Feel free to message us again if you need help with anything else. we're always delighted to help. 


 

S
Stephen14Author
September 26, 2019

Katherine,

 

As I stated, I have downloaded a QBO file from my banks options (CVS, OFX or QBO). But despite the file having a *.QBO extension, Quickbooks says its incompatible. When I open up the file in Notepad to inspect, the 'header' clearly refers to 'OFX' !!

 

I tried speaking with my bank only to be told they no longer support Quickbooks. No point using a software which is not supported by my bank. Unless this is resolved in the next day or so I will be moving to another solution, which will be supported by my bank, and looking for a refund.

JaneD
JaneD
September 26, 2019

Thanks for getting back to us, Stephen14.

 

Let's try some troubleshooting steps by importing the .QBO file into a sample company file. 

 

Here are the steps:

  1. Open QuickBooks.
  2. In the No Company Open window, click on the Open a sample file drop down and choose one.

Then, try importing the file from there.

 

If successful, let's update QuickBooks to the latest release by following the steps in this article: Update to the latest release of QuickBooks Desktop. Now, try importing the file again.

 

However, if the error persists, I recommend running the Verify and Rebuild Utility tool.

 

Please let me know how it goes. I'll be here to keep helping. Have a good one.

Terms & ConditionsAccessibility statement