Skip to main content
L
Lasa_Accountancy
February 10, 2021
Solved

QBO duplicate expenses and reconciliation done

  • February 10, 2021
  • 1 reply
  • 0 views

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.

Best answer by AlcaeusF

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!

1 reply

AlcaeusF
AlcaeusFAnswer
February 10, 2021

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!

    L
    Lasa_AccountancyAuthor
    February 10, 2021

    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
    AlexV
    February 10, 2021

    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!

      Terms & ConditionsAccessibility statement