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

Reconciliation discrepancy

I'm performing my second reconciliation. The beginning balance, statement ending balance, payments and deposits match the bank statement, but the cleared balance does not. So when I choose the deposit entry that increases the cleared balance to match the bank statement, the deposits are then too high. Yet, it reconciles to $0.00 when I do this. This doesn't set well with me. Is there a fix or something I'm overlooking?


Screen Shot 2021-06-19 at 8.33.25 PM.png

1 Comment 1
MichelleBh
Moderator

Reconciliation discrepancy

I'm here to help you fix the discrepancy, @keishanharrison.

 

Thank you for attaching a screenshot. I can provide some information that will help you reconcile your account without trouble. This way, your books are accurate without a moment's delay. 

 

Here are some things you can check to ensure the discrepancy amount will resolve as soon as possible. 

 

  1. Make sure the ending balance is entered correctly at the start of the reconciliation.
  2. The bank sometimes adds fees to transactions that weren't included when you entered them into QuickBooks. Check your bank statement.
  3. The transactions included in the reconciled periods are correctly reconciled to their respective dates.
  4. Someone entered transactions into QuickBooks that haven't cleared your bank yet.

 

       5. There are missing or duplicate transactions in QuickBooks.

       6.  Someone accidentally changes any transactions that can't see in the current. 

 

 

For more information, visit this page: Fix issues at the end of reconciliation.

 

To figure this out, I'd recommend running the past reconciliation history. This way, we can double-check the history if there is something to do. 

 

Here's how: 

  1. Go to the Reports menu on the left pane. 
  2. Type Reconciliation Report in the search box. 
  3. Choose the accurate Account and Report period in the drop-down. 
  4. Review all the data. Modify the transactions if needed. 

 

For more details, check out this article: How do I view, print, or export a reconciliation report?

 

If you can't find errors in QuickBooks, there may be an error with the bank or credit card company. Here's how to check for mistakes on your bank or credit card statement.

 

Once you've figured this out and your accounts are balances, you can now finish reconciling.

 

Additionally, check out these pages below about how to fix some errors in reconciling accounts and handling your chart of accounts. 

 

 

Let me know in the comment section if you have follow-up questions about reconciling accounts. I'm always around to help. Take care. 

Need to get in touch?

Contact us