cancel
Showing results for 
Search instead for 
Did you mean: 
Jay-M-21
Level 1

Reconciliation Discrepancy

When attempting a monthly bank reconciliation, we noted that the beginning balance was incorrect; it did not agree with the ending balance on our last reconciliation.  Upon running the discrepancy report, we learned that one our AP clerks had deleted several old transactions (payments) and reentered them (the why is another story!).  These transactions amount to the discrepancy.  I am trying to determine how best to resolve this.  Thank you. 

1 Comment 1
MaryLandT
Moderator

Reconciliation Discrepancy

Hi there, Jay-M-21,

 

I'm here to help resolve the reconciliation discrepancy on your bank account in QuickBooks Desktop.

 

Since those transactions are deleted, you'll want to do a mini-reconciliation. This method uses an "off-cycle" reconciliation date to make a correction and balance the account.

 

To start, make you have the correct ending balance. Then, proceed to the following steps shown below to fix transactions in a bank account:

 

  1. Go to the Banking menu, then select Reconcile.
  2. Choose the bank account with the transactions you need to reconcile.
  3. 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.
  4. When 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.
  5. In the Ending Balance field, enter the balance of your last successful reconciliation, then click Continue.
  6. In 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 more details, check out the Fix issues when you're reconciling in QuickBooks Desktop

 

Upon sharing this process, I still recommend consulting your accountant. He/She might have specific instructions on how to handle discrepancy on your books.

 

Stay in touch if you have follow-up questions by commenting below. I'm always right here to help.

Need to get in touch?

Contact us