Question

Reconciliation Discrepancy

Forum|Forum|5 years ago
February 16, 2021
1 reply
16 views

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

J

JamesDuanT

QuickBooks Team

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.

Click Accounting on the left menu and go to the Chart of Accounts tab.
Look for the affected bank account and click View register.
Look for the transaction whose duplicate was deleted.
Change the reconcile status from blank or Cleared (C) to Reconciled (R).
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!

B

Blueyes63

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

1

123145907091939

Hello there, @debra12_2.

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:

Back up your QuickBooks company file.
Go to Banking, and then Reconcile.
Select Undo Last Reconciliation.
When prompted, select Continue and then OK.
Close out of reconciliation and open it again to redo the 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 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, @debra12_2.

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

Sign up

Login with SSO

Let's get you signed in

Login with SSO

Scanning file for viruses.

This file cannot be downloaded