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

Reconciliation Balance Off

Quickbooks Desktop Premier 2021

 

After reconciling a bank account over 9 months, 4-5  previous months' transactions were deleted because they were coded wrong (deposits were coded as job incme versus a transfer from another account).  These transactions were seemingly re-entered properly, but the Beginning Balance for reconciliation is now off by the exact total of these transactions.  Help, I am driving myself crazy.

Solved
Best answer February 03, 2021

Best Answers
MaryAnn_E
QuickBooks Team

Reconciliation Balance Off

Hi there, @Rich428.

 

When previously cleared and reconciled transactions were voided, deleted, or modified some transactions may get unreconciled which affects your balance. Also, you can get the same result if the data file is damaged or corrupted. Let's get this sorted out. 

 

To fix the incorrect ending balance, let's start with running the Reconcile Discrepancy report. Use this report to identify the transaction causing the discrepancy.

 

Here's how: 

  1. Go to the Reports menu.
  2. Select Banking from the drop-down list then selects Reconciliation Discrepancy.
  3. Choose the appropriate Account, then select OK.
  4. If you find a discrepancy, note the transaction date and the Entered/Last Modified, which will tell you when the change occurred.

If the transactions show they were changed, you'll need to make the necessary corrections. For further assistance, I suggest consulting your accountant. If you have to add entries or you have modified previously reconciled transactions, you can perform a mini-reconciliation. Before doing so, make sure to create a backup of your company file to avoid data loss. 

 

However, if you find no discrepancy in the report, I recommend following the solutions outlined in this article for possible data damage: Fix your QuickBooks Desktop company file.

 

For additional reference, I've attached links that you can use to prepare for year-end:

 

Drop me a comment below if you have any other questions. I'll be happy to help you some more. 

 

 

View solution in original post

1 Comment
MaryAnn_E
QuickBooks Team

Reconciliation Balance Off

Hi there, @Rich428.

 

When previously cleared and reconciled transactions were voided, deleted, or modified some transactions may get unreconciled which affects your balance. Also, you can get the same result if the data file is damaged or corrupted. Let's get this sorted out. 

 

To fix the incorrect ending balance, let's start with running the Reconcile Discrepancy report. Use this report to identify the transaction causing the discrepancy.

 

Here's how: 

  1. Go to the Reports menu.
  2. Select Banking from the drop-down list then selects Reconciliation Discrepancy.
  3. Choose the appropriate Account, then select OK.
  4. If you find a discrepancy, note the transaction date and the Entered/Last Modified, which will tell you when the change occurred.

If the transactions show they were changed, you'll need to make the necessary corrections. For further assistance, I suggest consulting your accountant. If you have to add entries or you have modified previously reconciled transactions, you can perform a mini-reconciliation. Before doing so, make sure to create a backup of your company file to avoid data loss. 

 

However, if you find no discrepancy in the report, I recommend following the solutions outlined in this article for possible data damage: Fix your QuickBooks Desktop company file.

 

For additional reference, I've attached links that you can use to prepare for year-end:

 

Drop me a comment below if you have any other questions. I'll be happy to help you some more. 

 

 

View solution in original post

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

Need to get in touch?

Contact us