Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
G
gloriadeb204
February 16, 2021
Question

Reconciliation Discrepancy

  • February 16, 2021
  • 1 reply
  • 29 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?  

 

1 reply

J
JamesDuanTQuickBooks Team
QuickBooks Team
February 16, 2021

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!

B
Blueyes63
April 14, 2023

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

M
Mich_S
Level 5
September 18, 2023

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 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 QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement