Uncleared Check Correction

Thanks for providing details of your concern, @Challis. I'll provide some information to help you with resolving your uncleared check in QuickBooks Online (QBO).

If the check isn't included in the bank statement that needs to be reconciled, we can void it so it won't affect your books. Additionally, we can utilize the Memo field to add notes about the duplicate entry. To do this, open the transaction, select More at the bottom, and then choose Void. See the screenshot below for visual reference:
 

Alternatively, while creating an offsetting journal entry is feasible, we may be unable to provide specific details about the affected accounts. Therefore, I suggest reaching out to your accountant to guarantee the accuracy of your books. If you're not affiliated with one, we can help you Find a ProAdvisor. 

You may want to check out this article as your reference to guide you in doing and fixing reconciliation issues in QBO: Learn the reconcile workflow in QuickBooks.

Stay in touch if you have any additional questions or other reconciliation concerns. Drop your comment below, and I'll ensure that you receive the assistance you need.

@Nicole_N - thank you for your response.  The check is currently an uncleared check, however, it is shows cleared in the June reconciliation, but shows up the next month (July) as uncleared.  

So, I guess my have two questions.

1. How does Quickbooks allow you to enter two checks with the same check number. 

2. How can I tell if a check is cleared?

Hi, there @Challis.

I'm glad my colleague helped you. Let me share an insight that will save you time.

it's not typical to create checks with the same check number, QBO does allow this. However, it will prompt you that the check number has been used in a past transaction. You may disregard the warning.

Just a tip: You can turn off the "Custom transaction numbers" in the account and settings under the Sales tab and then Sales from Content section, so QuickBooks will not auto-create check numbers in sequence.

QuickBooks can't automatically know if a check has cleared the bank. But when the transaction appears in your bank records, gets downloaded to the Banking page, and matches the check in QuickBooks, you can tell QuickBooks that the check has cleared. Also, cleared transactions in your bank register are marked with a "C" status, as shown in the screenshot.

I want to share this article to create a report in QuickBooks Online of checks that haven't cleared yet: Run a report of uncleared checks in QuickBooks Online.

Don't hesitate to reply if you need further guidance or clarification about reconciliation. I'm just around to continue helping you.

@Challis 

"If need to mark the check as cleared next month I won't be able to reconcile. My thoughts are to mark the check as cleared and then make a journal entry to offset the entry, but I am unsure of the specifics of the journal entry."

To reverse the entry, create a deposit in QB (New > Bank deposit) and assign the same account to the deposit that was assigned to the check.  Creating a deposit serves the same function as creating a journal entry.  It creates a debit entry to your bank account and a credit entry to whatever account you select under ACCOUNT.  Then, clear the deposit against the check the next time you reconcile.   

@Rainflurry - Thank you very much! Challis