I used CSV import before my bank was qb enabled. Add qb integration with bank and now income shows double on P&L. How can I fix this...I deleted QB bank from "Banking".

We can exclude this bank transactions so that it won't affect your reconciliation report in QuickBooks, @wade.anderson.

Let me show you how:

1. Go to the Banking menu and select Banking.
2. In the For Review section, check the boxes for all transactions that you wanted to remove.
3. Click Batch actions, then select Exclude Selected.

Once done, you can now go back to your Profit and Loss report. Then, check if all the transactions are now correct. Just go to Reports and search for Profit and Loss report.

You can also customize this report to easily review your transactions and memorize it if you want to save its customized settings.

In addition, you can still connect your bank to QuickBooks Online (QBO). Just remember that once connected, it will automatically download 90 days worth of transactions. 

In case you don’t see your recently downloaded bank transactions in QBO, you can follow the steps provided in this article to fix it: What to do if bank transactions won’t download or there's a bank error.

You can always tag me in the comment section if you have further questions about banking issues. I'll always have your back.

I *might* have deleted that bank and I can't exclude those transactions anymore...  :|

@ReymondO 

I *might* have deleted that bank from the "bank" section and those transactions can't be excluded.

Anyway to fix that?

Thank You.

Hello wade.anderson,

When you connect your bank, you'll have an option to Add, Match, or Transfer the downloaded transactions to your register. We can only exclude the categorized transaction if the bank is still connected to QBO. Otherwise, those transactions will remain in your register.

The only way to remove the duplicate transactions is to delete them one at a time in your register.

1. Click Accounting on the left menu and go to the Chart of Accounts tab.
2. Look for the affected account and click View register.
3. Click on the duplicate transaction and select Delete.
4. Select Yes to confirm the action.
5. Delete the duplicate transactions one at a time.

Let me know if you have additional queries about this process. I'll be right here to further assist you.

@JamesDuanT @ReymondO 

I deleted this account when it first happened and now it doesn't appear in Chart of Accounts.

Hi there, @wade.anderson. 

Thank you for reaching back to the Community. This usually occurs when you delete the account in QuickBooks. I suggest activating the account first to locate the deleted transactions. Once done, go to the reviewed tab and undo it, then after that, we can exclude the transactions.

However, if you can't find the transactions you need to recreate.     

Let me guide you on how to do it. 

1. From the left pane click Banking and select Banking. 
2. Under Reviewed tab, you'll can see all the deleted transactions and click Undo. 
3. Go to the Review tab, tick-box the transactions you've undo. Then drop-down arrow in Batch actions and choose exclude selected.

You can also run a Audit log report to review, all the modified or deleted transactions.  

I've added an article for your reference: Assign, categorize, edit, and add your downloaded banking transactions.  

Let me know if you have further questions. I'll be here to answer them. Have a great day!