cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Visit this post for a list of recent banking issues in QuickBooks Online.
dean-artystar-co
Level 1

Uncleared transactions after reconciliation

I reconciled my bank account - zero difference - but afterwards QuickBooks still shows a wrong amount as it's including 'uncleared transactions' that were correctly excluded from the reconciliation. Can anyone explain how to remove these, please?
Solved
Best answer March 24, 2022

Accepted Solutions
Ashleigh1
QuickBooks Team

Uncleared transactions after reconciliation

Hello Dean-artystar-co

 

Welcome to the Community page, 

So the uncleared transactions are what has not been matched in the banking. As you have reconciled the account, if the transactions are sitting on the banking page you cant match them off  as the reconcile has closed them off, you will either need to get the reconcile undone(if they should be part of the reconcile) and then match the transactions off  then re reconcile the account or just exclude the transaction  on the for review page and leave the reconcile as it is. If the reconcile is correct. If you have duplicates as you  have added them from the bank and added manually, then the duplicate needs to be either deleted and  excluded or taken out of the reconcile and then matched in the banking section to the existing manual transaction( rather than added)and then re-added back into the reconcile, its up to you what you do. 

 

EDIT- To clarify If any transactions are duplicated this would cause the In Quickbooks balance to be incorrect. When you do the reconcile you're telling the system the ending balance and ticking the transactions to be part of the reconcile therefore not including any duplicates in the reconcile. Which means that the reconcile can be correct but your bank balance in the chart of accounts may be off. You can go to chart of accounts>account history>select the funnel symbol on the top left of the chart of account history>select unreconciled in the drop down and that will show what is not part of the reconcile. If those transactions should not be in Quickbooks you can then delete them. 

View solution in original post

2 REPLIES 2
Ashleigh1
QuickBooks Team

Uncleared transactions after reconciliation

Hello Dean-artystar-co

 

Welcome to the Community page, 

So the uncleared transactions are what has not been matched in the banking. As you have reconciled the account, if the transactions are sitting on the banking page you cant match them off  as the reconcile has closed them off, you will either need to get the reconcile undone(if they should be part of the reconcile) and then match the transactions off  then re reconcile the account or just exclude the transaction  on the for review page and leave the reconcile as it is. If the reconcile is correct. If you have duplicates as you  have added them from the bank and added manually, then the duplicate needs to be either deleted and  excluded or taken out of the reconcile and then matched in the banking section to the existing manual transaction( rather than added)and then re-added back into the reconcile, its up to you what you do. 

 

EDIT- To clarify If any transactions are duplicated this would cause the In Quickbooks balance to be incorrect. When you do the reconcile you're telling the system the ending balance and ticking the transactions to be part of the reconcile therefore not including any duplicates in the reconcile. Which means that the reconcile can be correct but your bank balance in the chart of accounts may be off. You can go to chart of accounts>account history>select the funnel symbol on the top left of the chart of account history>select unreconciled in the drop down and that will show what is not part of the reconcile. If those transactions should not be in Quickbooks you can then delete them. 

dean-artystar-co
Level 1

Uncleared transactions after reconciliation

Why does QB show that the account is reconciled, because I have excluded items, then add them back as uncleared? I think it all results from adding PayPal - the amounts are getting counted twice. I've stopped adding PP items for now.

Need to get in touch?

Contact us