Bank reconciliation

Anonymous · ‎May 24, 2019

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

ShiellaGraceA · ‎May 24, 2019

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.

Click Reports, and then Custom Reports.
Click Transaction Detail.
Change the Date From = the earliest QuickBooks date (or leave blank). Then, the Date To = the date of last reconciled statement.
Click the Filters tab, select Account = the account being reconciled. In Entered/Modified Date From = date of the last reconcile, Date To = Today.
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.

Anonymous · ‎May 25, 2019

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

Anonymous · ‎May 26, 2019

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:

Choose Banking then clicks Missing Checks, from the Reports Menu.
Select the Appropriate Account then click OK.
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:

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

Drop by again if you have other questions about QuickBooks.

Topics

Training

Community

Resources

Bank reconciliation