Question

Deleting an old uncleared entry creates an imbalance

Forum|Forum|4 years ago
July 1, 2022
1 reply
0 views

In my checking account I have a duplicate entry for a Sept, 2020 credit card payment. While reconciling the checking account this morning I saw this duplicate payment, double-checked it was uncleared, and deleted it.

But when I finished reconciling I was off by the exact amount of the payment.

How do I handle this?

thanks!

QuickBooks Desktop

KlentB

I'll help you in handling that, FajitaShorty.

Usually, this will happen when you delete or modify previously reconciled transactions. To fix this, you can perform a special reconciliation in QuickBooks Desktop. Here's how:

Go to the Banking menu, then choose Reconcile.
Select the credit card account with the transactions you need to reconcile.
In the Date of Statement field, enter the date for an "off-cycle reconciliation." This date can be any date between your last reconciliation and the next scheduled one.
In the Ending Balance field, enter the balance of your last successful reconciliation.
Click Continue, then check off the transactions you are fixing and re-reconciling.
Make sure the Difference field shows $0.00.
When everything looks good, select Reconcile Now.

I'm also adding this article to learn how to correct a zero or incorrect beginning balance: Fix beginning balance issues in QuickBooks Desktop.

Feel free to leave a comment below if you need further assistance in reconciling your other bank/credit card accounts.

F

FajitaShortyAuthor

Thank you, but I gave you wrong information.

This is a credit card reconciliation, not checking account as i wrote earlier.

There are 2 payments from the checking account to the credit card account from March of 2020. The payments in checking are for the same amount, but one is cleared and the other isn't.

I deleted the uncleared payment, then saw that same amount as a discrepancy when reconciling.

Not sure how to correct this...

thanks

C

Charies_M

I got the help you need, FajitaShorty.

It's possible that the deleted transactions were not added back reason why the amount shows an off balance.

If you no longer know the details of those deleted transactions, you can visit the Audit Trail to see them.

I'll show you how to do it:

Go to Reports.
Under Accountant & Taxes, choose Audit Trail.
Locate the deleted transaction and copy the information from there.

Once you were able to add those deleted transactions, you can then proceed to performing a mini reconciliation. This will "off-cycle" reconciliation date to make the corrections. Before this, make sure to know the ending balance from the most recent reconciliation.

Here's how to start the mini reconciliation:

Go to the Banking menu and select Reconcile.
Select the bank account with the transactions you need to reconcile.
In the Date of Statement field, enter date for an "off-cycle reconciliation." This date can be any date between your last reconciliation and the next scheduled one.
In the Ending Balance field, enter the balance of your last successful reconciliation. Then select Continue.
In the Reconcile window, check off the transactions you are fixing and re-reconciling.
Make sure the Difference field shows $0.00.
When everything looks good, select Reconcile Now.

The moment you enter an "off-cycle" date, QuickBooks will remind you that you're doing a mini reconciliation. This puts previously unreconciled transactions back without affecting the "cycle" that they follow. For more details about this process, visit this article: Reconcile previously deleted and re-entered checking or credit card transactions.

You might also want to check out this article to learn more about the reconciliation workflow: Learn the reconcile workflow in QuickBooks.

Feel more than welcome to leave me a reply if you have further questions with reconciliation. I'll be here to help. Have a wonderful day.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded