cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Created with Sketch. The QuickBooks Community will be unavailable for approximately 1 hour beginning at 10:00 PM PDT on Wednesday, August 14th for database maintenance. All community forums will be unavailable during maintenance but feel free to browse our Support articles for help in the interim.
willetteak
Level 2

Reconciling Bank Account with Uncleared Transactions from Prior Period

I'm trying to reconcile my bank statement, however, there are two checks from 2023 that the banks cleared that were not previously cleared - so, not fraudulent. However, these checks are no longer showing up in my list of uncleared checks to clear. So, I can't reconcile the bank statement. THIS IS A NEW CHANGE in QBO just this month. WHY HAS THIS CHANGED? This means I have to figure out yet another workaround to do what should be a BASIC accounting function. 

 

Additionally, when these checks came through the bank feeds, QBO did not allow me to match them to the correct transaction in the register because the "Find a Match" function would not allow for a date range search that went earlier than January 1, 2024. 

 

Banks are habitually cashing checks from 2020, "stale dated" doesn't really exist anymore. QBO needs to allow its users to determine how to handle checks older than whatever arbitrary date their engineers have suddenly decided is the cut off date. 

 

Has anyone else run in to this and how are you handling it? Thank you for any suggestions.

3 Comments 3
AnneMariee
QuickBooks Team

Reconciling Bank Account with Uncleared Transactions from Prior Period

Let's rectify the issue of your missing checks so you can reconcile your bank account, willetteak.

 

The checks could still be in the For review tab on your QuickBooks account. To allow them to your bank register, you'll need to either add or match them. If there are no matches available, you can add them to the correct categories. Alternatively, you can select the Match radio button in QuickBooks to locate more transactions to match. This will open a new page where you can set the date range before 2024 to find other transactions. 

 

If QuickBooks is unable to find a match, you can exclude the transaction from your bank feeds. You can then manually record a check by following these steps:

 

  1. Navigate to the +New button.
  2. Click Check.
  3. Fill in the necessary details. Ensure to associate the check with the correct accounts.
  4. Press Save and Close

 

This will add the check to your bank registers, allowing you to clear them and proceed with the reconciliation process.

 

For more information on fixing issues at the end of a reconciliation in QuickBooks, you can refer to this article: Fix issues at the end of a reconciliation in QuickBooks Online.

 

Once you've got it all figured out, you can use this guide to generate reconciliation reports for future reference: How do I view, print, or export a reconciliation report? 

 

Please don't hesitate to use the Reply button below, willetteak. I'll be right here to address any other concerns you may have with reconciling your bank accounts in QuickBooks.

Rainflurry
Level 13

Reconciling Bank Account with Uncleared Transactions from Prior Period

@willetteak 

 

Can you find the checks in the bank account register?  I've never seen outstanding, unreconciled checks not show up on the reconciliation screen.  There is a filter option on the reconciliation screen so make sure there are no filters restricting the dates of transactions.   

willetteak
Level 2

Reconciling Bank Account with Uncleared Transactions from Prior Period

Thank you for your reply! Yes, I had deleted all the filters, and they were still missing from the reconciliation screen, so after freaking out about yet another change by QBO engineers I took a deep breath and went searching for the checks themselves... aaaaand found the problem - a team member had posted a JE to void them and then marked them as reconciled outside of a reconciliation process, no notes, no documentation...nothing. 🤦‍So....much ado about nothing, incorrectly coming after QBO and their engineers, when all I apparently really need to do is retrain my team on how to handle bank register transactions...and to remind myself to exhaust EVERY angle of a problem before jumping into the community boards and wasting people's time. Apologies!

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us