cancel
Showing results for 
Search instead for 
Did you mean: 
gloriadeb204
Level 3

Reconciliation Discrepancy

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?  

 

7 Comments 7
JamesDuanT
Moderator

Reconciliation Discrepancy

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!

gloriadeb204
Level 3

Reconciliation Discrepancy

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?

 

 

Angelyn_T
QuickBooks Team

Reconciliation Discrepancy

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:

 

  1. Go to the Reports tab, then select Banking.
  2. Click on Reconciliation Discrepancy.
  3. Choose the appropriate Account, then select OK. 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 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!

Blueyes63
Level 1

Reconciliation Discrepancy

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

Rea_M
Moderator

Reconciliation Discrepancy

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 then Reconcile.
  3. Select Undo Last Reconciliation.
  4. When prompted, select Continue and then OK.
  5. 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, @debra.

123145907091939
Level 1

Reconciliation Discrepancy

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 

Mich_S
QuickBooks Team

Reconciliation Discrepancy

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 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:

    

  1. Open the Reports menu. Go to 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 then Reconcile.                                                                                                               
  3. Select Undo Last Reconciliation.                                                                                                                                
  4. When prompted, hit Continue and then OK.                                                                                  
  5. Close out of reconciliation and open it again to redo the 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!

Need to get in touch?

Contact us