Solved

reconciled transactions showing as uncleared

Forum|Forum|4 years ago
January 14, 2022
40 replies
807 views

In QBO, under "books review", there is a section that lists uncleared transactions.
When I went in to clear these up, I discovered that they HAVE cleared, and were reconciled. So, why are they showing as uncleared, and how do I fix it?
It makes the list rather useless if it's showing me transactions that are cleared.

QuickBooks Online

Best answer by katelynner

Why do reconciled transactions still show as uncleared in Books Review in QuickBooks Online, and how do I clear them?

When a transaction is genuinely reconciled (R in the register and on the reconciliation report) but still appears in the Books Review uncleared list, it's almost always because that transaction also posts to a second balance sheet account that hasn't been reconciled, and Books Review checks every balance sheet account it touches. The fix is to reconcile that offsetting account too, or to narrow Books Review with Select accounts so it only looks at the accounts you actually reconcile.

Why this happens

If a transaction hits a bank account and its other side lands on another balance sheet account (for example, a clearing account, a second cash account, or Owner's Draw from a journal entry), reconciling only the bank side leaves it flagged. Books Review looks at both accounts, so until the other balance sheet account is reconciled, the transaction keeps showing as uncleared even though the bank reconciliation is complete.

Fix option 1: Reconcile the offsetting balance sheet account

The official month-end review guidance is to reconcile bank accounts and other balance sheet accounts, not just the bank.

Identify the second balance sheet account on the flagged transaction (open the transaction and check where the other side posts).
Go to Settings (gear icon), then Reconcile, and choose that account.
Reconcile it for the relevant period. For an account like Owner's Draw that has no statement, you can reconcile using an ending balance that makes the difference $0.00, so the entries clear.

Reference: Review clients' books in QuickBooks Online Accountant.

Fix option 2: Narrow what Books Review checks

Open Books review.
Use Select accounts to choose only the accounts you actually reconcile.
Apply, so Books Review stops listing items tied to balance sheet accounts you don't reconcile.

If a transaction really did revert to unreconciled

Separately, a reconciled transaction can revert to unreconciled if it was later edited. To confirm and fix the status, go to Settings, then Chart of accounts, then View register for the account, open the transaction, and set the checkmark column to R if it isn't already. Note the status cycles R to C to blank as you click. Details: Undo or remove transactions from reconciliations in QuickBooks Online. If a change threw off a balance, use Fix issues with your beginning balance for accounts you've reconciled before.

If you open one of the flagged transactions and tell us the two accounts it posts to, we can help you confirm which balance sheet account still needs reconciling.

L

lin_jcaj

Level 9

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:

Click the Gear icon.
Tap Chart of Accounts.
Find the account you want to review.
From the Action column, click View register.
Find the transaction. If the transaction is reconciled, you’ll see an “R” in the checkmark ✔ column.
If it doesn't, click the field to change the reconcile status. A Blank status means the entry is not cleared or reconciled.
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.

C

ChristineD65Author

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.

C

ChristieAnn 11

Level 9

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:

Go to the Gear icon and select Chart of Accounts.
Find the specific account associated with the transactions that you want to delete. Then, choose View register in the Action column.
Click the Funnel dropdown arrow and choose a specific date in the Date field.
You can also use the Find field to search by amount, reference number, or memo.
Choose the Apply button.
Select each transaction and click it to expand the page.
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.

A

awmazinglyyou

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.

S

summitupllc

@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.

T

ThinkBig2023

All of my clients accounts are reconciled up-to-date and my client has 8,425 uncleared transactions in the Book Review.

L

leeseinmt

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.

S

sooverit2

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.

N

NSchabel

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.

Z

Zeem

Thank you so much! After reading through the long thread of responses, I’ve followed your instructions…It worked!! Thank you!!!!

katelynner

Answer

Community Manager

Why do reconciled transactions still show as uncleared in Books Review in QuickBooks Online, and how do I clear them?

When a transaction is genuinely reconciled (R in the register and on the reconciliation report) but still appears in the Books Review uncleared list, it's almost always because that transaction also posts to a second balance sheet account that hasn't been reconciled, and Books Review checks every balance sheet account it touches. The fix is to reconcile that offsetting account too, or to narrow Books Review with Select accounts so it only looks at the accounts you actually reconcile.

Why this happens

If a transaction hits a bank account and its other side lands on another balance sheet account (for example, a clearing account, a second cash account, or Owner's Draw from a journal entry), reconciling only the bank side leaves it flagged. Books Review looks at both accounts, so until the other balance sheet account is reconciled, the transaction keeps showing as uncleared even though the bank reconciliation is complete.

Fix option 1: Reconcile the offsetting balance sheet account

The official month-end review guidance is to reconcile bank accounts and other balance sheet accounts, not just the bank.

Identify the second balance sheet account on the flagged transaction (open the transaction and check where the other side posts).
Go to Settings (gear icon), then Reconcile, and choose that account.
Reconcile it for the relevant period. For an account like Owner's Draw that has no statement, you can reconcile using an ending balance that makes the difference $0.00, so the entries clear.

Reference: Review clients' books in QuickBooks Online Accountant.

Fix option 2: Narrow what Books Review checks

Open Books review.
Use Select accounts to choose only the accounts you actually reconcile.
Apply, so Books Review stops listing items tied to balance sheet accounts you don't reconcile.

If a transaction really did revert to unreconciled

Separately, a reconciled transaction can revert to unreconciled if it was later edited. To confirm and fix the status, go to Settings, then Chart of accounts, then View register for the account, open the transaction, and set the checkmark column to R if it isn't already. Note the status cycles R to C to blank as you click. Details: Undo or remove transactions from reconciliations in QuickBooks Online. If a change threw off a balance, use Fix issues with your beginning balance for accounts you've reconciled before.

If you open one of the flagged transactions and tell us the two accounts it posts to, we can help you confirm which balance sheet account still needs reconciling.

Sign up

Login with SSO

Let's get you signed in

Login with SSO