Deleting an old uncleared entry creates an imbalance

JessT · ‎August 06, 2022

Hi FajitaShorty,

Thank you for the screenshot. Yes, that's the correct entries to add and opening balance. However, I'd like to go to the top to clarify this.

Before anything else, please back up your company file so you can restore that copy when something isn't right along the way, especially if you're following suggestions from different responses.

Let's go back to the top of the scenario where an uncleared duplicate payment was deleted and caused a discrepancy.

First of all, how did you manage to reconcile if there was a duplicate entry? Although it wasn't cleared, but it could still affect the account balance as it was a posting transaction. Therefore, there must be another transaction (an adjustment entry perhaps) that offsets that duplicate because you were able to reconcile. Both must be deleted.

I see that this is a long thread. The best thing to do is to have a screen-sharing session with our QB Desktop Support, so both you and the supporting agent are looking at the same record when correcting this.

Here are a few points to consider:

Compare your QB transactions with your credit card transactions in the affected period, even those in the prior month as well.
Check for adjustment entries.
You can always reconcile your transactions in the affected period after correcting some of them.

Feel free to reach back out if you have any other concerns with your reconciliation.

FajitaShorty · ‎August 09, 2022

Hi TizrahC

I emailed a few days ago, could you take a look?

Appreciate your help!

MariaSoledadG · ‎August 09, 2022

We'd really love to help you so we'll be able to fix your issue, FajitaShorty.

It looks like many of my colleagues have tried their best to provide a resolution so you'll be able to continue working with QuickBooks again. Since the Community is a public platform, I recommend reaching out to our support team. They certainly have the tools to pull up your account in a secure environment and check the email you sent. Aside from that, they'll be able to double-check why you're still unable to make a balance adjustment using a journal entry. Here's how to reach them:

Click the (?) Help icon and enter Talk to a human (then type it again when prompted).
When asked by the bot, enter your concern
Select I still need a human, then proceed with Contact us or Get help from a human.
Choose either Chat or Callback.

Furthermore, QuickBooks Online (QBO) automatically generates a reconciliation report once you're finished. You'll want to view, print ,or even export a reconciliation report for your business reference, in case your accountant needs the information. I've added this article for your guide: How Do I View, Print, or Export A Reconciliation Report?.

Reach out to us if you need further assistance. We're always right here if you need help.

FajitaShorty · ‎August 12, 2022

BC65 · ‎January 29, 2024

If I fix my CC account and it messes up my banking account that I have already reconciled, can I fix it?

JoesemM · ‎January 29, 2024

Good to see you here in the Community, BC65. Let me share information about reconciliation in QuickBooks.

Yes, you can still fix the bank accounts even if it's already reconciled in QuickBooks. Also, please note that making changes to reconciled transactions can impact your financial records and reports. That said, if you have an accountant or financial professional, it may be a good idea to consult with them before making any adjustments to your reconciliation.

Then, make sure to have your bank statement handy so you can match your beginning balance and ensure that you're reconciling the correct bank. If you have multiple accounts at the same bank or more than one account of the same type, ensure you're reconciling the right one.

To reconcile an account, follow the steps below:

Go to Transactions, then select Reconcile.
Select the account that you want to reconcile from the Account ▼ dropdown.

For more details about the process and how to reconcile accounts in QuickBooks, see these articles:

Additionally, I'll be sharing these resources that will guide you in fixing your reconciliation and how to print some reports in QuickBooks:

Please know that you are always welcome to reply to this thread if you have additional concerns with your reconciliation. I'm happy to help you. Keep safe.

Topics

Training

Community

Resources