cancel
Showing results for 
Search instead for 
Did you mean: 
michaelsrv
Level 1

I am trying to reconcile my bank account and the previous month was reconciled to "0".  When I try to reconcile the next month it is telling me there is a $2000 difference (after I get thru selecting all that is on the bank statement that is cleared).  My bank statement matches my deposits and my withdrawals but it is still showing a $2000 difference and I can't find where it is coming from.  I have tried deleting all my reconciliations from last year and redoing them all and it still shows on there.  Any ideas of where I can look to try and find where the $2000 is coming from.

Solved
Best answer April 28, 2021

Best Answers
CharleneMae_F
QuickBooks Team

Thanks for updating us how it goes, michaelsrv.

 

It's possible that someone changed or deleted some transactions in your file. Let's perform a special reconciliation to zero out the $2000 balance. This method uses an "off-cycle" date. Please ensure you know the ending balance from the recent reconciliation. 

 

Here's how:

 

  1. Go to the Banking menu and then select Reconcile.
  2. Choose the bank account with the transactions you need to reconcile.
  3. 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.
  4. In the Ending Balance field, enter the balance of your last successful reconciliation. 
  5. Select Continue.
  6. From the Reconcile window, check off the transactions you are fixing and re-reconciling.
  7. Make sure the Difference field shows $0.00.
  8. When everything looks good, select Reconcile Now.

For further guidance, please see this article: Do a Special Reconciliation.

 

I'd also suggest consulting an accountant to avoid messing with your books.

 

Additionally, I've included these articles to ensure you'll reconcile your account successfully:

 

 

In case you'll need assistance in reconciling your account, don't hesitate to get back to this thread. I'm determined to get the difference resolved.

View solution in original post

3 Comments
Kristine Mae
QuickBooks Team

I'm here to help you check why you have a difference, Michaelsrv.

 

It's a good job for going through your bank statement and ensuring all transactions are correct. We'll have some things to check as well.
 

We'll start with looking for any changed, deleted, or added transactions. We have three reports that you can run to check them out:

  • Reconciliation Discrepancy report

  • Missing Checks report

  • Transaction Detail report

Then, let's also check for reconciliation adjustments. It also affects the balances.

 

You can refer to this article to better guide you: Fix issues when you're reconciling in QuickBooks Desktop.

 

Feel free to get back to this thread if you need more help. We'll get back to you as soon as we can. Keep safe!

michaelsrv
Level 1

I have done those three reports and there are no $2000 discrepancies or uncleared balances with that amount.  Any other ideas?  This is from 2019 and the only reason I found it was because I was reconciling my current bank statements and it kept showing the $2000 which I traced back to 2019.  As I said in my earlier remark the month before this amount started showing was "0" after I reconciled (which was 8/2019).  Also, the starting balance and ending balance is correct.  It is a mystery to me and the first time anything like this has happened.  I usually have no trouble reconciling every month.  The only thing I can think of is that something was changed somewhere that is effecting 2019 now.

CharleneMae_F
QuickBooks Team

Thanks for updating us how it goes, michaelsrv.

 

It's possible that someone changed or deleted some transactions in your file. Let's perform a special reconciliation to zero out the $2000 balance. This method uses an "off-cycle" date. Please ensure you know the ending balance from the recent reconciliation. 

 

Here's how:

 

  1. Go to the Banking menu and then select Reconcile.
  2. Choose the bank account with the transactions you need to reconcile.
  3. 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.
  4. In the Ending Balance field, enter the balance of your last successful reconciliation. 
  5. Select Continue.
  6. From the Reconcile window, check off the transactions you are fixing and re-reconciling.
  7. Make sure the Difference field shows $0.00.
  8. When everything looks good, select Reconcile Now.

For further guidance, please see this article: Do a Special Reconciliation.

 

I'd also suggest consulting an accountant to avoid messing with your books.

 

Additionally, I've included these articles to ensure you'll reconcile your account successfully:

 

 

In case you'll need assistance in reconciling your account, don't hesitate to get back to this thread. I'm determined to get the difference resolved.

View solution in original post

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up