reconciled transactions showing as uncleared

Hello there, ChristineD65.

Let me help you fix your reconciled transactions showing as uncleared in QuickBooks Online.

There may be times when transactions you already reconciled show up as unreconciled.  Normally, this happens if previously reconciled transactions are modified, and the system will tag them as unreconciled, causing them to show up again for reconciliation. 

Let's check the transaction status and make sure it is tagged as reconciled, follow the manual reconciliation steps below:

1. Click the Gear icon.
2. Tap Chart of Accounts.
3. Find the account you want to review.
4. From the Action column, click View register.
5. Find the transaction. If the transaction is reconciled, you’ll see an “R” in the checkmark ✔ column.
6. If it doesn't, click the field to change the reconcile status. A Blank status means the entry is not cleared or reconciled.
7. Once done press Save. 

I would also recommend consulting an accountant before making this change. They'll ensure your books are accurate and your reconciliation balances are correct. 

Also, we do have a guide to help you correct your reconciled account. You can follow the steps from this article if you need help with the corrections: Fix issues for accounts you've reconciled in the past in QuickBooks Online.

If you need more help with the reconciliation process, just reply here and I'll get back to you.

Thank you, the whole reason I'm asking is because they are reconciled, and still showing as uncleared. 

I discovered this when reviewing them to clean them up, there was nothing to clean, as they are reconciled.  The register shows them reconciled, and they are also showing as reconciled in the reconciliation report.  No changes are showing under reconciliation history.  
So, as they are reconciled, I'm not sure why they are still showing as uncleared, and how to correct it.  

Also, I'm *with* the accounting firm, so referring it to the accountant to fix isn't really a solution, lol.

Hi there, ChristineD65.

I appreciate you for coming back to the thread to add further details and clarification about your concern. With this, I'll be sharing information and troubleshooting steps to fix the issue.

Since the register shows the entries as reconciled and also on the reconciliation report, it could be the transactions you've seen as uncleared are the manually created ones inside QBO that caused duplicate. That said, you can delete them in the register.

Here's how:

1. Go to the Gear icon and select Chart of Accounts.
2. Find the specific account associated with the transactions that you want to delete. Then, choose View register in the Action column.
3. Click the Funnel dropdown arrow and choose a specific date in the Date field.
4. You can also use the Find field to search by amount, reference number, or memo. 
5. Choose the  Apply button.
6. Select each transaction and click it to expand the page.
7. Click the Delete button and choose Yes to confirm.

For additional information on how to find transactions in your account registers so you can review, edit, and delete them, you can click this article: Find, review, and edit transactions in account registers.

Additionally, duplicate transactions also show on the For Review tab after you downloaded the transactions in QuickBooks Online. That said, I suggest excluding them from the said section to totally remove and correct your bank data.

Lastly, you may refer to this article to view different guidelines to help fix any reconciliation issues that might you encounter: Learn the reconcile workflow in QuickBooks.

Let me know if you have other concerns with your reconciliation. I'm always here to help.

nope, they are not duplicates.

Thanks for making sure the transactions aren't duplicated, Christine. I want to stop this from happening to you. 

I have a solution that will work in your uncleared transactions. That way, they'll be eliminated from your bank streams.

It seems that you've already checked the necessary details and followed the steps to solve the outstanding invoice issue. With this, I'd recommend contacting our Customer Care Team. Our experts can view your bank flows in a safe place and send a ticket to our engineers to further investigate if needed.

1. Go to the Help menu, then click Contact Us. 
2. Type your concern in the box and tap Let's talk. 
3. Choose either Get a call or Start a chat. 
4. Complete the required data and submit the request.

Make sure to contact them within business hours to ensure a swift response.

You can also exclude the transactions to remove that on the For Review page and reports.  

Discover these articles below on how to troubleshoot specific bank errors and manage your chart of accounts in QuickBooks: 

• What to do if you get a bank error or can't download transactions in QuickBooks
• Learn about the chart of accounts in QuickBooks

Leave a line if you have follow-up questions about your banking flows. I'm happy to answer any questions you may have. Remain safe, Christine.

Would you mind sharing how you got this corrected? I have the same issue. Checks that show Reconciled that also have a banking match, but show up on the Check Detail report as "uncleared". ( no duplicates )

Hi @Organicmom365,

I appreciate you for dropping by here in the Community space. I'm here to assist you with the reconciled transactions showing as uncleared in QuickBooks Online.

I've checked the thread, and I can see that my colleagues have provided the necessary troubleshooting steps. I recommend following the instructions above to verify the status of the transactions in question.

You'll need to go to your chart of accounts to determine why it's showing as uncleared on your report. If the information is correct after checking the details, please proceed with contacting our QuickBooks Support Team.

They can help further by providing additional steps to fix the issue when running the Check Detail report. Our support for Plus, Essentials, Simple Start is available from 6 AM - 6 PM PT (Monday - Friday) and 6 AM - 3 PM PT (Saturday). For Advanced, any time, any day.

Here's how you can reach them:

1. Click the Help tab in the upper-right corner.
2. Go to the Assistant tab.
3. Click Get help from a human.
4. Choose Chat with us or Have us call you.

Also, I want to share a link you can use as a reference on how to run a bank report by cleared status in QuickBooks: Run a report of uncleared checks.

I'm always available in this public space if you need more help running reports or managing transactions. Reach out to me by clicking the Reply button below.

This happens to me as well with multiple clients. The transaction is marked reconciled, and is not a duplicate yet it shows up as an uncleared transaction.  I tried unmatching, and re-categorizing from the dashboard, then marking reconciled in the register but it still shows up on the Uncleared Transaction list. This is very frustrating, and I just ignore that list because it is not accurate.  I wish a solution other than "call support" would be posted here ...

Hello there, @caldridge4593.

Please know that this is not the experience we want you to have. I also understand how important it is to get this sorted out as soon as possible. As the previous representative recommended above, you'll need to get in touch with our QuickBooks Online Support team since the issue persists. They have the tools to check on your account and investigate the root cause of the problem. To begin, here's how:

1. Sign in to your QuickBooks Online company.
2. Select Help (?).
3. Select either tab to get started:

• Assistant: Get quick, personalized answers. Select a suggested option, or type a question or topic you need help with. If you decide you need further help, you can still Talk to a human.
• Search: Search the QuickBooks Online knowledge base directly, or select Contact Us and choose a way to connect with us:
  • Start a chat with a support expert.
  • Get a callback from the next available expert.

Please know if you're using Plus, Essentials, or Simple Start. You can reach out to our support from Monday to Friday from 6 AM to 6 PM PT, and on Saturday, you can reach out to our support from 6 AM to 3 PM PT. In case your subscription is QuickBooks Online Advance, you can contact our support team anytime.

I've also got you this article in case you'd like to learn more about the reconciliation workflow in QBO: Learn the reconcile workflow in QuickBooks.

If you need help performing specific tasks or if you have any additional QuickBooks-related concerns, @caldridge4593. Know that I've got your back and I'm more than willing to help you anytime. Take care!

I am having same issue as others. In book review there are numerous items listed as uncleared.

I do not have duplicates nor do I have more than a couple of uncleared items in the main checking account.

We migrated this client from DT to QBO so the older transactions have not come through the bank feed if that has something to do with it.

Not a helpful tool. 

What I noted when this occurred in one of my client's books is that the transaction was not cleared in another Cash account. I had a few transactions posting to a cash register account, but because the cash register account was not reconciled, the transactions still showed up as not cleared. To resolve this, I reconciled the Cash register account and the transactions cleared from the 'uncleared transactions' list. 

@awmazinglyyou Your correct.  I use to work at Quickbooks Live bookkeeping as a one of the Senior Experts.  The uncleared transactions are due to unreconciled accounts.  Try reconciling your Other Balance sheet accounts and see if this clears up your uncleared transactions.

I am having the same issue.

I've checked everything and I am 100% reconciled, no duplicates.

I LOVED the Books Review function until I got to this section.

Also, it shows YEARS worth of junk in my older companies instead of just the last Fiscal Year, which is even messier and more useless - I do not want to touch previous fiscal years! And while I'm at it - not only YEARS worth, but not in order by date, and you can't click on the date to reorder the list.

It seems to be a glitch in QBO.

I doubt contacting Help will fix the glitch that is across the board.

And Feedback doesn't fix the issue in real time.

@SoOverIt 

can you email me at [email address removed].  Let’s see if I can help you.  I wonder if it is a hidden balance sheet.  

@sooverit2 can you email me [email address removed].  I can try and help you.  It may be a hidden balance sheet account.  

Thanks but that isn't the issue.

Hello there, @sooverit2,

This is not the kind of service we want you to experience while using the program. I also understand how important it is to sort this out as soon as possible, and I know how frustrating it is to exert effort in performing troubleshooting steps to resolve this reconciliation issue. 

However, to ensure that your concern will be addressed accordingly I recommend contacting our QuickBooks Online (QBO) Support Team as per what my colleagues above have suggested. They have the tools to check on your account and investigate the root cause of the problem. They also provide a glance session to accurately guide you on ways to resolve the issue.

Here's how: 

1. On your QBO account, select Help (?).
2. Click the Search tab to get started:
3. Select Contact Us.
4. Enter the topic of your concern.
5. Click Continue.
6. Choose either Chat, Appointment, or Callback.

I'll also include this article to learn what to review so you can start reconciling: Fix issues for accounts you've reconciled in the past in QuickBooks Online.

We're looking forward to this issue getting resolved. Don't hesitate to leave a reply if you require further assistance with reconciliation in QBO. The Community team is here to help you anytime. Keep safe.

Hello my name is (Removed),

I have had those not cleared items for a long time, and could never find out why. But they go back for a ways, is there any hope in getting them cleared up?

Thanks

Shairon

My pleasure to have you here today, @crmbookeeper. Let me explain to you about the uncleared items on your reconciliation.

The system generates your reconciliation report every time you finished your reconciliation. It is a saved report which can't be modified.

The uncleared checks and deposits are those items that are not included in that reconciliation period. I'm adding these screenshots as your visual reference.

If you need to clear the transactions during that reconciliation, you can ask your accountant to undo the process, then reconcile your transactions again.

Here's how:

1. Go to the Gear icon, then click on Reconcile.
2. Tap on the History by Account link.
3. Select the reconciliation, then tap on Undo under Action.

Once done, go back to the Reconcile page, then select all the items on the list.

When you finished your reconciliation, the report will no longer display uncleared items.

For more tips while managing your reconciliation in our system, you can open this article: Reconcile an account in QuickBooks Online.

The same material will guide you on how to modify your completed reconciliations.

If you have follow-up questions, let me know by leaving a comment below. I'm more than happy to help you again. Have a good one!

Hi;

I think the the issue they are all describing, is that there is confusion regarding 'cleared' transactions vs 'Reconciled' transactions. The report we are trying to run is to find 'unreconciled' transactions, but apparently, quickbooks online, only filters the 'uncleared' transactions. So, any transaction that is uncleared but reconciled will still show up on the report.

Any transaction that was manually entered and not matched to a bank transaction in the auto import, is uncleared, despite being matched at the end of the month to a Bank statement.

I believe this explains the problem, waiting for Quickbooks to fix.

I appreciate the complete details you shared regarding the concerns shared in this thread, @bintiva. I also understand the convenience of viewing the unreconciled transactions in a report.

I agree that filtering a report not only with the uncleared transactions can help everyone easily track them. I can also see the importance of addressing the differences between cleared and reconciled ones.

Since this is currently unavailable, I recommend sending this request to our Product Development Team. Please know that we're unable to provide a timeline for when this will be implemented.

Here's how:

1. Go to the Gear icon.
2. Under the Profile column, select Feedback.
3. Share your suggestion, then click Next.

You'll want to track your suggestion through this website. You can also visit our blog to keep up with recent events and developments.

Feel free to check out this resource to learn more about reviewing your accounts and balancing your checkbook: Reconcile an account in QuickBooks Online.

Once everything's settled, you can read this reference for the complete reconciling process: Learn the reconcile workflow in QuickBooks.

You can always leave a reply on this thread if you need anything else. I'll be glad to assist you further. Stay safe.

I finally figured this out after reading through gazillions of (unhelpful) CSA responses.  I noted one USER @awmazinglyyou  who had the answer, so responding here in more depth in the hopes it helps someone else, as the moderators' responses are so infuriating (looking for duplicates or checking to see if the transaction is "really" reconciled, send us feedback, call CSA, or (slit my wrist) "ask your accountant").

It turns out that if a transaction is booked to more than one Balance Sheet account, it will look at both of those balance sheet accounts to see if they are reconciled.  If a transaction hits your bank account, and the offset is another Balance Sheet account, unless you reconcile the 2nd balance sheet account, the trans shows up in that "unreconciled" list.  You can recon the bank account all day long, but until you reconcile the other balance sheet account, it will be there in that list.

Example:  I did a major cleanup for a client that had no idea what they were doing.  My JE to fix the mess was to DR the bank account and CR Owner Draw.  Even though I had done a recon of the bank account, marking the DR associated with the cleanup JE as part of the recon, the transaction still showed up in my "Unreconciled" list during the Books Review.  I don't have any idea how you would reconcile Owner Draw, but based on ONE brief post I saw in this thread, I proceeded with a recon of the Owner Draw account, entering $0 as the balance.  Then I marked the CRs of the cleanup JE to see what my reconciliation "difference" was.  I then edited the Owner Draw balance per the recon = to the "difference" and was able to recon Owner Draw.  When I went back to my Books Review and looked at the Unreconciled list, the JE was no longer there.

Hope this helps someone, cuz the canned responses re: how to reconcile your bank feed or (God help me) ask your accountant are worthless all.day.long.

I figured it out too - I guess I should have posted. I think this is a miss on the part of Intuit. You're not supposed to be reconciling those other accounts. 

FINALLY!!!  Thank you for sharing this great information.  I was tired of being asked to contact Intuit for useless help. Too bad Intuit could find a resolution to this instead of them always asking us to either clear our cache and cookies, open incognito or call them and be put on hold forever!