Solved by performing a mini reconciliation.
I have deleted a cheque from july 2019 and then recreated, went back in the bank account, and ticked the transaction so it would show as clear again.
I assume it was all ok until I started March Reconciliation and noticed that the beginning balance was off and the cheque I have deleted and recreated now shows in the list of march reconciliation.
I know in Quickbooks online you can mark with R but I use QB Desktop Enterprise 2020.
Undo the reconciliations isn't' an option, I have thousands of transactions from July 2019 to Feb 2020, I know I can fix the opening balance but there should be an easy way to do this....
Any help is appreciated
Hello again garbia,
Welcome back! It seems from your first sentence of this post that you may have solved the issue you were having with your transactions and reconciliations, which is awesome! I'd like to take a moment to shed some light on what you've mentioned here so you have a sense of what's happening in QuickBooks Desktop Enterprise.
Recreating a transaction that was previously reconciled and then going into the account register to put the check mark is the first step in approaching these situations. This check mark in QuickBooks Desktop is effectively the same thing as putting the R beside a transaction in the account register in QuickBooks Online.
That being said, completing that task doesn't always do the trick. The beauty of QuickBooks Desktop is you can undo a reconciliation back to the point where things were balanced and then move forward again, and this often solves these kinds of hiccups in your books. I can appreciate how having thousands of transactions would make this a daunting task and would take up a large chunk of your time, so I'm glad to hear that a mini-reconciliation seems to have solved this for you.
Feel free to share more details about what you did for the mini-reconciliation to help others who may be in the same boat. If you are still needing a hand with the reconciliation issue, please let me know. I'm here to help. :)
I can't find the account register to mark it R manually. Ive found the transaction but no where to mark it off. Someone deleted 7 transactions AFTER reconciliation, so it looks like i have to put them back in and then mark as reconciled,,,but I find figure out how to mark it that way.
Hello High Voltage,
Welcome to this thread, and thanks for taking a moment to explain a bit about what's going on with your books. I can definitely see how transactions being deleted post-reconciling would negatively impact your books, and it sounds like you're on the right track to fix it by recreating the transactions and then manually reconciling them. I can help you with this.
Since you mention that you're looking to manually change the transaction status to R in your account register, it sounds like you're potentially using QuickBooks Online. If that's the case, navigating to the account register is as simple as selecting the Accounting tab from the left menu and then Account history for the account in question. That'll bring you to the account register, where you'll see a column that has a checkmark as the header. Here's an example from a test account of what that looks like.
I've circled the column in green for emphasis. When you click that column for a transaction, the status of the transaction will change. The C denotes "cleared" and the R means "reconciled." Once you see R for your transactions, you should be good.
If you do happen to be using QuickBooks Desktop, the process for getting to the Chart of Accounts is a bit different and there are a few ways to get there, including using the keyboard shortcut CTRL + A. You can then double-click the account in question to bring up the register and then use the checkmark column there to change the status. However, QuickBooks Desktop also gives you the opportunity to undo the reconciliation entirely, which, depending on how many transactions you have overall, may be easier. Our article Reconcile an account in QuickBooks Desktop touches on that option if you'd like to explore that.
I hope this has been helpful. If you'd like any clarification, don't hesitate to ask in a reply. I'm here to help. :)
thanks,, I figured out how to find the register and manually change to R, so I do need to recreate each of the 7 transactions (expenses) and then just Reconcile correct? I only added one back first so I could figure out the manual steps, and needed confirmation that yes I indeed needed to add those expenses back in. I will do the other six once I hear back from you :) Edit: I added a couple of them back in and now my discrepancy is getting higher than it was before...
Hi there High Voltage,
I'm happy to hear that you were able to correct one of the transactions. Keep doing the same for the rest of the transactions and they should be reconciled once again.
If you have any other questions, feel free to reach out here for assistance.
I know it's been awhile since your post but I have exactly the same problem but over a longer span of time and redoing all reconciliations are not an option. Please tell me how you successfully did a mini-reconciliation?