QBO duplicate expenses and reconciliation done

Thanks for reaching out to the Community, @Lasa_Accountancy.

Since you already reconciled the transactions that you've entered manually, you can just exclude those transactions on the Banking page. This will avoid you from duplicate records.

Here's how to do it:

1. In QuickBooks Online (QBO), go o the Banking menu at the left pane to get to the Banking page.
2. In the For Review tab, place a checkmark on the transactions to exclude.
3. Click Exclude.

The transaction moves to the Excluded tab of the Banking page. This is where you can Undo transactions that were accidentally excluded.

To learn more about excluding downloaded bank transactions, check out this article: Exclude a bank transaction you downloaded into QuickBooks Online.

Please know that I'm only a post away if you have any other questions or concerns. I'll be here to help. Have a good one!

Ok, I got your point. I definitely do that to resolve this issue. One more quick question. In Banking Center if any transaction show "Match", Can I match it or continue to exclude it as well?

Let me join this thread and share some details about banking, Lasa_Accountancy.

If QuickBooks Online found a similar entry, you'll see a Match button. This option will prevent it from duplicating. You can either match them or simply exclude the downloaded ones since you reconciled your accounts already.

Moving forward, it's best to match downloaded bank transactions in QuickBooks Online. This will help you to easily categorize and reconcile your accounts.

Comment again below if you have other questions. Take care!

Alright, it's best to match downloaded bank transactions in QuickBooks Online. This will help us to easily categorize and reconcile our accounts. But right now as I already manually added transactions and reconciled it as well (which is not correct workflow). But from now, for me it's better to exclude all of these transaction and don't use match option to avoid entering duplicate expenses and receipts. 

As I understand this thing. Is it right?

You got it right, Lasa_Accountancy.

For now, it'd be best to exclude the transactions from the banking page since the ones that were manually recorded are already reconciled. 

To help you with excluding the transactions, you can follow these steps:

1. Go to Transactions or Banking > For review.
2. Put a check mark on the transactions you want to remove.
3. Click the Exclude button.

Please see this sample screenshot for a visual reference:

Once done, the transactions will be moved to the Excluded tab. You can delete the transactions from there. 

If you need help with other task in QuickBooks, feel free to visit our general help topics page to view articles and guides.

Please leave a comment below if you need anything else. We'll respond as soon as we can. Have a great day!