cancel
Showing results for 
Search instead for 
Did you mean: 
Active Member

file types to import bank transaction

What file type (extension) do I need to import bank transaction into quickbooks desktop pro 2017?

My bank only offers Quicken (QFX) and .CSV files to download.

Solved
Best answer 07-25-2018

Accepted Solutions
QuickBooks Team

Re: file types to import bank transaction

Greetings, @Scott_B.

 

Allow me to share some insight on importing transactions via web connect and bank feeds. It sounds like you may have a damaged account in QuickBooks. The good news is, I can guide you through correcting this with just a few simple steps.

 

My recommendation is to merge your current credit card account with a new one. This will bring over all of your transactions, so you won't lose that data, and it will be in a new, healthy account. Here's how:

 

  • Go to your Chart of Accounts, right-click the problem account, then select Edit Account.
  • Highlight the Account Name, then click Copy.
  • At the end of the account name, enter an asterisk (*).
  • Go to the Bank Feed Settings tab then click the Deactivate All Online Services radio button.
  • Select Save & Close.
  • Go to the Chart of Accounts and create a new account.
  • Paste the Account name without the asterisk (*).
  • Close and reopen the company file.
  • Go to Chart of Accounts, right-click the account with the asterisk, then select Edit Account.
  • Remove the asterisk and select Save & Close.
  • Click Yes when prompted by the Merge warning dialog box.
  • Set up your account for bank feeds once more.
  • Try downloading transactions to the new merged account.

 

From this point, if you're still having trouble importing transactions via web connect, or bank feeds, you may need to troubleshoot further. In case that happens, I've included a helpful article for you here. If you have any questions about this or anything else QuickBooks, Don't hesitate to seek me out here in the Community. 

13 Comments
Frequent Contributor *

Re: file types to import bank transaction

You need a .QBO file and might have to talk with your bank. If you have the acountant ed, you can directly feed QB large numbers of transactions from a spreadsheet with just a little bit of column arranging, but plain desktop QB, I haven't been able to figure this out, and I don't think it can do it.

ProAdvisor

Re: file types to import bank transaction

@jonmelhus

Google QFX to QBO free converter for QuickBooks. It's should work fine.

Hope this helps!

Frequent Contributor *

Re: file types to import bank transaction

Thanks, I'll keep this in mind. I might have been quite useful last week, however with the Acountant's Ed I can just tailor my spreadsheet from the bank and upload all credits in one batch and all debits in another, but I don't think the OP has the accountant's ed. 

Community Explorer **

Re: file types to import bank transaction

I've tried the QFX file that was originally downloaded by my bank, converting it to a QBO file as you've suggested and a CSV file.  Nothing works correctly.

 

First, I use QB Desktop Pro 2017

 

I go File...Utilities...Import...Web Connect... and select the QBO file.  I then get the following header info:

 

You are downloading transactions for the following account:

 

The Financial Institution is incorrect

The Account type is "Credit Line" which is incorrect (needs to be Credit Card, I think)

...but the Account Number is right.

 

So, I need to select or create a new QB account to import the data into.  I do not want to do that.  I want to import the CC transactions into the CC account that is already active and working.

 

BTW - Why the transactions do not come down in my QB Bank Feed I do not know.  I am trying to catch up from Aug. 14 of last year and the Bank Feed connects properly but it says there are no new transactions.  So, I've reverted to downloading the transactions to import them.  This is why I am doing this.

 

HELP!  Next thing would be to just manually enter a few hundred, if not more, CC transactions since Aug. 14, 2017.

ProAdvisor

Re: file types to import bank transaction

I believe (and it's been awhile since I used desktop for anything other than conversions) that the feed cannot see the existing account, so you have to first disconnect it from the direct connect link.  Go to Chart of Accts., find the acct., edit it and disconnect it.

 

Then try to pull that file you downloaded back in and the system will now list that acct as a possible acct. to connect to.  Then you can import it to the existing correct acct. 

 

I remember having to do that now and again in the desktop days.

Community Explorer **

Re: file types to import bank transaction

Already disconnected and reconnected the CC account prior to writing up the request.  Still trying to figure out the original question of importing a CC file into QuickBooks Desktop.

QuickBooks Team

Re: file types to import bank transaction

Hi there, @Scott_B,


Welcome to the QuickBooks Community. I’d like to help clarify why the QBO file for credit card transactions are not importing into QuickBooks Pro 2017.


QuickBooks Desktop allows importing transactions into a bank or credit card account. A credit line account type is usually tracked under Other Current Liabilities, which is why you’re getting the header info message.


I know you wish to keep the current account that is already active. However, the program is not able to download data into a liability account.


In order for the data to import, you’ll have to create a new credit card account. Here’s how:

 

1.    Go to the Lists menu.
2.    Choose Chart of Accounts.
3.    Right-click anywhere and select New.
4.    Tick the Credit Card radio button and click Continue.
5.    Fill out the Account Name.
6.    Description and Credit Card Acct. No. are optional.
7.    Click Save and Close.


Once done, you can import the web connect (.qbo) file you converted. With regard to the transactions you’re trying to catch up from August 14, 2017, they also need to be manually brought into the program via Web Connect.


The QuickBooks Bank Feeds typically downloads up to the last 90 days of transactions. Some information about how bank feeds work can be found in this article: Get started with Bank Feeds for QuickBooks Desktop.


Let me know if you have other concerns with QuickBooks and I’ll be here to help. Wishing you continued success.

 

Community Explorer **

Re: file types to import bank transaction

Thank you for the reply, I really appreciate it.  But, the account is already set up as a Credit Card account.  See attached.  

 

I've disabled the account and reinitialized it and it does connect properly but I am not getting any downloaded transactions.  After it connects it says "There are not transactions to review.".

 

I used to get the transactions properly into this CC account.

 

 

QuickBooks Team

Re: file types to import bank transaction

Greetings, @Scott_B.

 

Allow me to share some insight on importing transactions via web connect and bank feeds. It sounds like you may have a damaged account in QuickBooks. The good news is, I can guide you through correcting this with just a few simple steps.

 

My recommendation is to merge your current credit card account with a new one. This will bring over all of your transactions, so you won't lose that data, and it will be in a new, healthy account. Here's how:

 

  • Go to your Chart of Accounts, right-click the problem account, then select Edit Account.
  • Highlight the Account Name, then click Copy.
  • At the end of the account name, enter an asterisk (*).
  • Go to the Bank Feed Settings tab then click the Deactivate All Online Services radio button.
  • Select Save & Close.
  • Go to the Chart of Accounts and create a new account.
  • Paste the Account name without the asterisk (*).
  • Close and reopen the company file.
  • Go to Chart of Accounts, right-click the account with the asterisk, then select Edit Account.
  • Remove the asterisk and select Save & Close.
  • Click Yes when prompted by the Merge warning dialog box.
  • Set up your account for bank feeds once more.
  • Try downloading transactions to the new merged account.

 

From this point, if you're still having trouble importing transactions via web connect, or bank feeds, you may need to troubleshoot further. In case that happens, I've included a helpful article for you here. If you have any questions about this or anything else QuickBooks, Don't hesitate to seek me out here in the Community. 

Community Explorer **

Re: file types to import bank transaction

The instructions were great and everything worked...except I got the exact same result; No transactions to download.

 

Starting to enter all the data manually now.  It is going to be a late night.

 

Thanks.

Moderator

Re: file types to import bank transaction

Hello, @ Scott_B.

 

We recommend several solutions to this problem. Let me route you to this article for the detailed troubleshooting steps: https://community.intuit.com/articles/1620423.

 

If the issue persists, you'll need to contact your bank to check the .QBO download format and content. It might be possible that the file is not formatted properly.

 

I'm just a post away if you have other questions. Thank you for your patience.

 

 

 

 

 

 

 

 

 

 

 

Active Member

Re: file types to import bank transaction

This 'solution' simply doesn't work. I use QuickBooks Pro 2017. When I try to open a .qbo file and click 'OK' to import new transactions now, no credit card accounts show up as options under 'Use an existing QuickBooks account'. I created a new credit card account that was never set up for bank feeds and still it does not show up as an option. Only bank accounts show up.

 

This does not appear to be a problem with the how people are using the software, it is a fundamental problem with the software itself. When is it going to be fixed?

Highlighted
Moderator

Re: file types to import bank transaction

Hi, @catch.

 

Let me route you to the right support that can help further isolate this issue. 

 

Our Desktop Care support can access your account in a secure environment and check why these transactions are not showing up. They have tools specific to troubleshooting that can resolve this issue.

 

Here's how you can in touch with our support:

 

  1. Go to: https://help.quickbooks.intuit.com/en_US/contact.
  2. Choose your QuickBooks Product.
  3. Select your QuickBooks Version.
  4. On the Contact Us page, click a topic.
  5. Click on the Get Phone Number button to see the support number.

Let me know if you need anything else. All the best.