Can't download Bank of America credit card transactions into Quickbooks.

I've thoroughly checked our records here but I can't find any related reports, syschroeder.

I'll make sure that you can import your bank transactions to QuickBooks Desktop. Before we start, we'll have to consider that we can't import QFX or QIF Quicken files into QuickBooks Desktop. We can only import Web Connect files into QuickBooks Desktop. These files have a .qbo extension at the end of the file name.

I recommend visiting the Intuit Marketplace to a find third-party applications that can handle QIF Quicken file conversion.

After converting it, you can follow the steps below in uploading the file to QBDT:

1. Open QuickBooks.
2. Select File from the top bar menu.
3. Choose Utilities then Import.
4. Select Web Connect Files.
5. Locate the QBO file you saved, then click Open.
6. When prompted to select a bank account, select Use an existing QuickBooks account.
7. Click Continue, then hit OK.
8. You can go to the Bank Feeds Center to review your transactions.

Once done, you can now categorize your bank transactions.

If you're about to reconcile your account, please check out this article that will guide you in doing it: Learn the reconcile workflow in QuickBooks.

I'm always here and ready to help you need additional assistance in managing your bank transactions. Don't hesitate to tag me below.

Thanks for your reply. I'm just so frustrated about paying the $ for what I thought was a higher-end program and then not being able to use it without purchasing even more stuff to try and patch the process. Quicken does this effortlessly! And all my other bank and credit cards work just fine using Quickbooks, but not Bank of America. Which leads me to believe that it is the bank, not Quickbooks. Just sad that one of the main banks/credit card companies is not compatible with one of the main accounting programs. Doesn't make sense to me. If no one else has had issues with downloading BOA credit card transactions into Quickboks, it must just be me. :(

Hello,

Similar issue for me.

Cannot download Bank of America credit card transaction to QB. I am signed up with QB WebConnect.

I have Quickbooks Pro 2017

At the BOA site I am able to initiate the .qbo statement download.

I get the QB dialog box for Import New Transactions which I select but then nothing happens.

Any ideas?

Thanks, John

Hello there, @jct9841.

Let's create a new test bank account to troubleshoot issues with importing WebConnect files. Then, merge it to your original account to avoid duplicates.

Here's how:

1. Go to Lists at the top menu.
2. Select Chart of Accounts.
3. Right-click on the pop-up window and select New.
4. Tick the radio button for Bank, then click Continue.
5. Enter the correct bank's name in the Account Name field and hit Save and Close.
6. Right-click the old account and rename it to the correct bank's name.
7. Hit Save and Close. 
8. When you get the prompt to merge the accounts, click Yes.

In the meantime, you can import .qbo file in a new test company so, you'll be able to determine if the issue lies in the original company or with the formatting of the .QBO file. Please follow the steps below:

1. Go to the File menu.
2. Click New Company.
3. Choose Express Start.
4. On the newly created test company, add your bank account to the Chart of Accounts.
5. Set up the account for Bank Feeds.
6. Download or import the .qbo file.

For more detailed steps, you can refer to this article for more detailed instructions: Troubleshoot Bank Feeds Web Connect import issues and errors.

Please know that the Community has your back should you have any questions. Have a great day.

Thanks Grace.

Will give these a try.

John

---

@GraceC wrote:

Hello there, @jct9841.

 

Let's create a new test bank account to troubleshoot issues with importing WebConnect files. Then, merge it to your original account to avoid duplicates.

 

Here's how:

1. Go to Lists at the top menu.
2. Select Chart of Accounts.
3. Right-click on the pop-up window and select New.
4. Tick the radio button for Bank, then click Continue.
5. Enter the correct bank's name in the Account Name field and hit Save and Close.
6. Right-click the old account and rename it to the correct bank's name.
7. Hit Save and Close. 
8. When you get the prompt to merge the accounts, click Yes.

In the meantime, you can import .qbo file in a new test company so, you'll be able to determine if the issue lies in the original company or with the formatting of the .QBO file. Please follow the steps below:

1. Go to the File menu.
2. Click New Company.
3. Choose Express Start.
4. On the newly created test company, add your bank account to the Chart of Accounts.
5. Set up the account for Bank Feeds.
6. Download or import the .qbo file.

For more detailed steps, you can refer to this article for more detailed instructions: Troubleshoot Bank Feeds Web Connect import issues and errors.

 

Please know that the Community has your back should you have any questions. Have a great day.

---

Bank of America says if you pay $15/month and have a business account, they will allow export via .qbo files. This is ridiculous. Intuit needs to negotiate with BOA to make this work without another $180/year just to access data is usable format.