cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Senior Explorer *

Bank reconciliation

I un-reconciled one month of a bank account and now it is showing a difference , but my bank statement equals qb.  How can I fix this?

Reports/banking/Reconciliation discrepancy shows 0 

3 Comments
QuickBooks Team

Re: Bank reconciliation

Hi there milsie,

 

You can use the Transaction Detail Report to verify if there are transactions that were changed or modified. Let me help you with the steps.

  1. Click Reports, and then Custom Reports.
  2. Click Transaction Detail.
  3. Change the Date From = the earliest QuickBooks date (or leave blank). Then, the Date To = the date of last reconciled statement.
  4. Click the Filters tab, select Account = the account being reconciled. In Entered/Modified Date From = date of the last reconcile, Date To = Today.
  5. Click OK.

Once you've identified, you need to make the necessary corrections. If you have a new transaction added to the reconciliation period or have modified previously reconciled transactions, you may need to do mini-reconciliation.

 

Feel free to read this article for details: Resolve common issues on Previous Reconciliation report.

 

You might also want to check out this article for future reference: How do I view, print or export a reconciliation report?

 

Let me know if you have additional questions. I'll be sure to get back to you as soon as I can.

 

pic03.JPG pic04.JPG

Senior Explorer *

Re: Bank reconciliation

I created the transaction detail report and the total 13,811.83 equals the difference in the reconciliation. Discrepancy report shows none. 

 

January 2019 reconciliation 

Service charge                                 .00

Interest earned                                .00

Ending balance                   12,883.68  Jan 2019 ending balance, equals bank statement 

Cleared balance                      -928.15  Ending balance of Dec/31/2018

Difference                            13,811.83

 

** 13,811.83 minus cleared balance -928.15 = 12,883.68

 

 

QuickBooks Team

Re: Bank reconciliation

Hello, milsie.


Another report that we can run to identify reconciliation discrepancies and fix transactions is the Missing Checks Report. This report helps you to find absent transactions. Here’s how to run the report:

  1. Choose Banking then clicks Missing Checks, from the Reports Menu.
  2. Select the Appropriate Account then click OK.
  3. Analysis of the report for transactions that don’t match your bank statement.

If you’re still unable to locate the discrepancies, I’d recommend contacting the support team. They have more tools like the screen sharing which will help you investigate and fix the issue. Here’s how to reach them:

  1. Click Help at the top.
  2. Select QuickBooks Desktop Help.
  3. Click Contact Us.
  4. Give a brief description of your issue and click Continue.
  5. Select Talk to a Specialist.

Drop by again if you have other questions about QuickBooks.