Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I noticed in a check register (Account B) that a check written from one account (Account B) to another (Account A) had been entered twice. Same amount, same date. This was back in July. I deleted one of them. I'm pretty sure that the one I deleted had not cleared, so I thought I was OK.
When I went to finish up reconciling Account A for December 2020, my beginning balance was off by the exact amount of that check.
I really don't want to undo any reconciliations.
Is there a better solution to this?
I know what we can do about this, gloriadeb204.
The beginning balance of the current period will be incorrect if you have deleted a reconciled transaction from the previous period.
We can manually reconcile the transaction from the previous period. With this, you don't need to undo your previous reconciliations while we correct the beginning balance of your current period.
You can also use this link for reference: Undo or remove transactions from reconciliations in QuickBooks Online.
From there, you can continue reconciling the current period.
You might also find this link helpful you have previously reconciled the account: Fix issues for accounts you've reconciled in the past in QuickBooks Online.
Keep us posted if you need additional assistance in reconciling the account. Have a great day!
Hello,
I tried to go through these steps. I am using Desktop 2017. Not sure if that makes a difference.
I went to the Register via Banking and Use Register.
I don't get the "C" or "R". I get a checkmark.
I don't get "save". But I hit Record at the bottom.
Is this the same thing?
But it still didn't change my beginning balance. It's still off by $80,000.
I undid two month's reconciliation, which is going to be suck a lot of time to redo.
What am I doing wrong, or do I not have this capability in 2017?
Hi Gloria.
Thank you for following up with us here on the Community page. I can help you with fixing the discrepancy in your reconciliation.
Yes, you're right about undoing the past reconciliation in QuickBooks Desktop (QBDT). Moreover, QBDT 2017 must not be an issue with the process. If you wish to, you can upgrade your QuickBooks versions to get the latest features available. You can open these articles for your references:
Since you're still getting an incorrect balance, you can proceed with running a discrepancy report or checking your audit trail to find the transactions causing the discrepancy.
Here's how:
To fix the discrepancy, you have to re-enter or edit the transactions. You can undo your previous reconciliation and redo it or ignore the discrepancy and let QuickBooks enter an offsetting adjustment. For your guide, check out the instructions under To fix an incorrect balance section.
Moreover, here's an article you can read more about reconciling previously deleted and re-entered checking or credit card transactions.
If you have any other questions about banking or reconciliation, please let me know by adding a comment below. I'm more than happy to help. Have a good one!
Didn't find any deleted transactions. I have my statement ending amount and my cleared balanced amount which is putting the difference . There should not be a cleared balance because I have not done anything yet. So haow do I get the cleared balance off there? Especially since I have not started yet.
Debra
Hello there, @debra.
Let's undo your previous reconciliation and redo it to get rid of the discrepancy and make sure of the accuracy of your financial data.
Your statement ending amount is the beginning balance in QBDT. Since you've identified that your cleared balance amount caused the discrepancy, you can correct it by undoing your previous reconciliation and redoing it. Here's how:
To learn more about fixing beginning balance issues in QuickBooks, you can refer to this article: Fix beginning balance issues in QuickBooks Desktop.
Also, I encourage you to reconcile your accounts in QBDT regularly (every month). This helps monitor your income and expense transactions and detect possible errors accordingly. You may want to check out this article as your reference to guide you in doing and fixing reconciliations in QBDT: Learn the reconcile workflow in QuickBooks.
Please let me know in the comments if you have other reconciliation concerns or questions about managing transactions in QBDT. I'll gladly help. Take care always, @debra.
I have a similar problem but mine is unique. I reconciled some credit card payments without matching them to the bank where the payments was made from, and reconciled both accounts. When I realized I deleted one transaction and did a match not to create duplicate transaction however now by once reconciled accoubnts are off? Kindly help.
Thanks
We appreciate you for notifying us of your similar reconciliation issue, 123145907091939. I'll help you isolate this so you can have this done in no time.
The following are the possible reasons why you're account balance are off:
If you haven't done so yet, make sure your opening and beginning balances are accurate. Once you know these are correct, start looking for the deleted entry by running the Reconciliation Discrepancy report. Let me walk you through the process:
After that, recreate the deleted transaction once you find it on the report. Otherwise, you can correct it by undoing your previous reconciliation and redoing it. Here's how:
Furthermore, I recommend getting in touch with your accountant for extra advice on the next step to take and to keep your books in order.
Feel free to also read this module to learn more about how to close out the previous year and prepare for the new one: Year-end guide for QuickBooks Desktop.
Please know that I'm always around here in the Community to help you with your banking concerns. Take the best care!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here