Level 2

Importing Credit Card Transactions

When trying to import a .QBO file into a QB Pro 2019 registered bank feed, QB does not show any accounts that are already set up in bank accounts/feeds.

When bank account was set up and initiated the first time for direct connect feed, it only captured 90 days from date initiated and their was no option to select a longer period of time which was desired. 

The desired time frame of data was previous including the 90 day limit  set by the financial institution (FI) for the initiated auto feed. Time frame desired was selected from FI website and downloaded from the FI as a .QBO file, with the understanding that it could be imported to the bank account that was registered with QB and therefore the desired time frame of transactions would be added to the bank account.

When attempting to import the .QBO file (File-Utilities-Import-Web Connect Files) the prompt to select a bank account is blank and drop down box does not reveal any accounts available and the only option to do anything is to "Create a new QB account".

 

Questions

Why are bank accounts not showing up in the above described scenario when asked to "select a existing QB account"?

Can you import a .QBO file to a bank account that is connected for a "direct connect feed" in QB desktop?

Will imported QBO files create duplicates if there is a date overlap of previous entries?

Are "Bank" and "Credit Card" feeds handled differently?

Does the account need to be disconnected from direct connect feed as in its current state (connected) it is closed for import of files and will not show up as a "existing Account"?

 

QuickBooks Team

Banking

Hi B Cald Well,

 

In QuickBooks, you'll only have to choose one connection. Since your bank account is set up through direct connect, selecting a bank account from the drop-down list is unavailable.

 

You'll have to add the transactions from your direct connect feed, then disconnect it. Once done, you can import your transactions though WebConnect and repeat the process of adding the transaction in QuickBooks.

 

Finally, re-connect your bank account through direct connect. 

 

You may find this article handy: Get started with Bank Feeds for QuickBooks Desktop.

 

If you have other questions or concerns about Bank Feeds in QuickBooks, please reach out to us. Thanks.

Level 2

Banking

Thank you for your  reply. I am confirming from your reply that you cannot  import to a bank account while it is connected to direct connect.  I will apply your solution, however I am hesitant, would you be able to clarify the question of overlapping dates? Should I follow this procedure will I end up with duplicate entries should the dates overlap?

Thanks  B Cald Well

Moderator

Banking

Good thing you clarify, B Cald Well.

 

You can follow what my colleague, @RenjolynC stated above. Regarding the overlapping dates, you'll have the option to customize the date range of the transactions you'll want to download. For example, from January 01, 2018 to December 31, 2018.

 

Your bank institution will be the one to customize it for you.

 

This way, you'll be able to control what transactions to  be downloaded on your QuickBooks file. 

 

Feel free to post again, B Cald Well if you have further concerns. Have a good day!