Reconciliation Discrepancy (2024)

‎February 15, 202106:46 PM

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?

• QuickBooks Desktop

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.

1. Click Accounting on the left menu and go to the Chart of Accounts tab.
2. Look for the affected bank account and click View register.
3. Look for the transaction whose duplicate was deleted.
4. Change the reconcile status from blank or Cleared (C) to Reconciled (R).
5. Click Save and select Yes to confirm the action.

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:

• Upgrade to newer versions of QuickBooks Desktop Pro Plus, Premier Plus, or Enterprise
• Update QuickBooks Desktop to the latest release

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:

1. Go to the Reports tab, then select Banking.
2. Click onReconciliation Discrepancy.
3. Choose the appropriateAccount, then selectOK. You now have a list of transactions that were changed since the last reconciliation. Use this report to identify the transaction/s causing the issue.
4. If you find a discrepancy, note the transaction date and the Entered/Last Modified, which will tell you when the change occurred.

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 underTo fix an incorrect balancesection.

Moreover, here's an article you can read more aboutreconciling 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:

1. Back up your QuickBooks company file.
2. Go to Banking, and thenReconcile.
3. SelectUndo Last Reconciliation.
4. When prompted, selectContinueand thenOK.
5. Close out of reconciliation and open it again toredothe process.

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 toreconcile your accountsin 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:

• Someone entered an incorrect ending balance at the start of the reconciliation.
• Someone edited or deleted transactions that were already reconciled.
• There are missing or duplicate transactions in QuickBooks.
• Someone entered transactions into QuickBooks that haven't cleared your bank yet.
• Someone made an adjustment to your last reconciliation with a journal entry.

If you haven't done so yet, make sure youropeningandbeginning balancesare 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:

1. Open the Reports menu. Goto Banking and run Reconciliation Discrepancy.
2. Choose the account you're reconciling and then hit OK.
3. Review the report and look for the removed entry.

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:

1. Back up your QuickBooks company file.
2. Go to Banking, and thenReconcile.
3. SelectUndo Last Reconciliation.
4. When prompted, hit Continueand thenOK.
5. Close out of reconciliation and open it again toredothe process.

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!