cancel
Showing results for 
Search instead for 
Did you mean: 
Lasa_Accountancy
Level 3

QBO duplicate expenses and reconciliation done

I did a mistake in my QBO and I realized now. Can any one give me details process and guidance how can I tackle this situation.

The case scenario is I enter expenses, receipts etc. manually in my QBO account. I don't see Banking Center at all. I don't match/add anything. All transactions remain uncategorized/Unaccepted in Banking Center. I reconcile my Checking, Payal and Saving account. 

From now I see Banking Center shown almost 34 Uncategorized Transactions. Most transactions are dated the reconciliation already done. From now If I add these transaction and categories them. Some expenses and receipts amount will charge twice becuase I already enter these expenses and recepits manually. My previous reconciliation already done otherwise I void all manual expenses, and receipts but now void option can't work because transactions are reconciled. 

How can I resolve this issue? I do this wrong thing with all my Janurary data. No expense and receipts should charge twice and everything will go on track. Please give me detail go through process. So, I try to resolve this issue in my QBO.

Solved
Best answer February 10, 2021

Best Answers
FritzF
Moderator

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!

View solution in original post

Lasa_Accountancy
Level 3

QBO duplicate expenses and reconciliation done

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?

View solution in original post

AlexV
QuickBooks Team

QBO duplicate expenses and reconciliation done

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!

View solution in original post

Lasa_Accountancy
Level 3

QBO duplicate expenses and reconciliation done

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?

View solution in original post

RenjolynC
QuickBooks Team

QBO duplicate expenses and reconciliation done

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!

View solution in original post

5 Comments 5
FritzF
Moderator

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!

Lasa_Accountancy
Level 3

QBO duplicate expenses and reconciliation done

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?

AlexV
QuickBooks Team

QBO duplicate expenses and reconciliation done

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!

Lasa_Accountancy
Level 3

QBO duplicate expenses and reconciliation done

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?

RenjolynC
QuickBooks Team

QBO duplicate expenses and reconciliation done

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!

Need to get in touch?

Contact us