uncleared checks that really did clear

Hello there, Lpollock. I have the information about handling the uncleared checks in QuickBooks Online (QBO).

I appreciate you using the QuickBooks program to help you with your business finances.

Since the checks has been already cleared in your bank, please know that you'll have to manually clear them in the bank register. Doing this doesn't directly impact your bank balance. You can use your bank statement as a reference.

Furthermore, if your bank is connected to QBO and transactions are automatically downloaded to the For Review tab, you'll have to match these transactions with the existing records in the system to clear them and prevent duplicates.

To manually clear an entry:

1. Sign in to your QBO account.
2. Click the Gear icon at the top right corner.
3. Select Chart of Accounts.
4. Choose the bank account you're working on, then select View Register in the Action column.
5. Locate and select the transactions.
6. In the column, keep clicking the blank status until it shows cleared (C).
7. Hit on Save, then Yes to confirm.

Visit this reference for guidance on matching downloaded bank transactions to the existing entries in the program: Match online bank transactions in QuickBooks Online.

Moreover, check out these articles you can read to manage bank transactions moving forward:

• Categorize online bank transactions in QuickBooks Online
• Set up bank rules to categorize online banking transactions in QuickBooks Online

I'll promptly follow up if you need further assistance handling checks or other banking-related tasks. The Community is accessible round the clock to help you further. Have a good one.

@Lpollock 

"The bank balance matches so clearing the checks will throw it off balance."

Do you mean the bank balance or the ending bank balance from your most recent reconciliation?  Whether a transaction is cleared or not has no affect on the bank balance, only the reconciled ending balance.

Thank you for your reply. I meant the Reconciled balance. If I clear those checks it will throw that off. In reality they have cleared but for some strange reason they show uncleared. I am assuming it was a QB glitch with the transfer from desktop to QBO. I can't otherwise explain how my books are balanced yet those are not cleared.

Thank you for your reply but I don't think you understood my question.

It did not get cleared in QBO. It did actually clear our bank.

Hey again, @Lpollock. 

I appreciate you coming back on this thread. 

When moving your data from QBDT to QBO, all transactions that were reconciled should've stayed reconciled and all cleared transactions should've stayed cleared. 

With that being said, let see if manually reconciling the transactions help with solving this problem. Please go to the bank register and click the box next to the transaction until it shows R. 

I do recommend speaking with your Accountant first before doing those steps. 

I'll be waiting for your response! 

I assume if I do that the reconciliation will then be off by that amount next time I go to reconcile.

I guess at this point I'll have to do that then create an adjustment of some sort.

Did you find a solution?  I found the same issue when moving from Desktop to Online.  I also have checks that actually cleared but are showing as uncleared and I have no idea how to mark them cleared without throwing of the reconciliation.

I have a solution for you, Texasidoc. You'll have to manually clear your check transactions in the bank register to mark them as cleared in the reconciliation window. Below, I'll provide insights and guide you through the process.

To begin, please note that checks will show as uncleared in the reconciliation unless you manually clear them in the bank register. Additionally, clearing these entries will not disrupt your reconciliation and doesn't directly affect your bank balance. Therefore, you'll have to manually change the status to Cleared in the bank register for the transaction to be recognized as cleared and to prevent them from appearing as uncleared.

Here's how to manually clear an entry in the bank register:

1. Sign in to your QBO account.
2. Click the Gear icon in the top right corner and select Chart of Accounts.
3. Choose the bank account you're working on, then select View Register in the Action column.
4. Locate and select the check transaction.
5. In the Status column, keep clicking the blank status until it shows Cleared (C).
6. Click Save, then confirm by selecting Yes. 

However, if you've connected your bank account and have online bank transactions downloaded in the For Review tab, you'll need to match them with your existing records in the system to prevent duplicates.

Moreover, refer to this guide to ensure a smooth reconciliation process and to understand what steps to take if your reconciliation doesn't match your bank statement at the end: Fix Issues at the End of Reconciliation.

Furthermore, have you considered our QuickBooks Live Expert Assisted team? They are dedicated to making transaction sorting and financial management easier for you. I suggest looking into their services—you might find it to be a revolutionary enhancement for your accounting workflow!

I'll always be here, ready to back you up if you have any further questions about handling uncleared checks or other QBO-related concerns. Please let us know any time in the thread.