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.

@jonmelhus

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

Hope this helps!

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. 

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.

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.

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.

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.

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.

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.

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?