I know this is an old post, but I'm just now feeling the pain of this obviously intentional software flaw that we all know is just another way that the QBO fat cats have found to squeeze more money from it's hard-working small-business customer base. Anyway, stepping down from my soapbox for a min...I found a workaround. It isn't perfect, like being able to under a past reconciliation would be, but its quicker than manually unclearing a ton of transactions.
My situation: Our bank account in QBO was reconciled as of 12/30/22 with an uncleared deposit transaction on 12/6/22 of $150. Upon auditing our accounts, I discovered the uncleared deposit was a JE entered in error. I don't feel like answering a million times over in the coming year the question of 'why is there a $150 uncleared deposit for Dec?', when the deposit shouldn't have existed in the first place.
So to fix this, I entered a JE as of 12/31/22 that credited the $150 in our bank account and debited it in the correct expense account.
Next, I went to the Reconcile page and selected by bank account from the list of accounts I wanted to reconcile.
It brought up that blue note that says 'Last Statement ending date 12/30/22'. I ignored it.
Dropped down below that and entered the Ending Balance amount that was the same as the Beginning Balance amount.
Tabbed to the right and entered 12/30/22 as my Ending Date. (Yep, you saw right. You can totally do more than 1 reconciliation for an account on the same day!!...poof! I blew ur mind!!)
I clicked on 'Start Reconciling' and when the next screen opened up, I checked just my 12/6 deposit of $150 and my 12/31 payment of $150. They cancelled each other out, so my Difference was $0. I clicked 'Finish Now' and the reconciliation report now shows the 'unreconciled transactions as of 12/30/22' as $0 and my statement ending balance still matches to the actual bank statement .
If I go to the History by Account it shows both reconciliation reports dated 12/30/22 (like I said, not a perfect work-around). This I can handle and will raise less (if any) questions from our Accountants than the unreconciled deposit would.
I hope this helps some of you! Keep doing what you're doing and fighting the good fight!
