cancel
Showing results for 
Search instead for 
Did you mean: 
brent3
Level 1

I imported items from my bank to set up QB, but all transactions including expenses were imported as deposits. How can I fix it?

Online version
3 Comments 3
BettyJaneB
QuickBooks Team

I imported items from my bank to set up QB, but all transactions including expenses were imported as deposits. How can I fix it?

Hi there, @brent3.

 

Welcome to the Community. Let's get this bank transaction issue sorted out and get you back to business.

 

First and foremost, QuickBooks reads the transactions exactly as they are sent from your bank. In this case, we'll need to exclude those transactions that were posted in reverse to avoid duplicates when re-downloading it.

 

Here's how:

  1. From the left menu, select Banking.
  2. On the Banking page, select the For Review tab.
  3. Select the checkboxes of the transactions to exclude.
  4. From the Batch actions drop-down, choose Exclude Selected.

For more details about this procedure, please refer to this article: How to exclude expenses from downloaded bank transactions.

 

There you go, @brent3 you should be back up in no time. Please let me know if you have further questions. I'll be around to help. Have a good one!

myarbroughgmroff
Level 1

I imported items from my bank to set up QB, but all transactions including expenses were imported as deposits. How can I fix it?

I've done the same thing and also when I set up my bank I did not enter and opening balance there for the transactions that were imported as deposits has created a huge mess.

Can you help me.

 

Alessandra_B
QuickBooks Team

I imported items from my bank to set up QB, but all transactions including expenses were imported as deposits. How can I fix it?

Thank you for visiting the Community, @myarbroughgmroff.

 

You've mentioned that you excluded the transactions already. You can re-upload your expenses and map them in the correct account. Let me guide you how to do this.

  1. Click on Banking from the left panel.
  2. Under the Update drop-down, choose File Upload.
  3. Choose the file, click on Next.
  4. Choose the Account. Then click on Next.
  5. Under the Money Spent drop-down, choose Credit. And under the Money Received drop-down, choose Debit.
  6. Click on Next until the file is uploaded.

Feel free to read this article for more details: How to Import Bank Transactions Using Excel CSV Files?

 

Please let us know if you have any other concerns. The QuickBooks Community team is here to help. 

Need to get in touch?

Contact us