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.

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. 

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.

Also - Go into Books Review and hit Select Accounts (right under where it says Current Status) and select only the accounts that you reconcile.  That will prevent QBO from looking at other balance sheet accounts when listing Uncleared Transactions.