Skip to main content
April 22, 2025
Question

Reconciliation Discrepancy Report Errors

  • April 22, 2025
  • 1 reply
  • 0 views

We use QuickBooks Pro Desktop 2024. We ran a reconciliation discrepancy report, and the opening balance for April was off due to two recent transactions showing up affecting the opening balance. The last reconciliation was for March the two transactions were posted in April. We deleted both transactions and now one of the customers we deleted the current April transaction for is showing up again with a deleted transaction from 2013. This has the reconciliation opening balance for April off again. How can we correct this issue and why did the two transactions posted in April affect the opening balance for April reconciliation?

1 reply

April 22, 2025

April-posted transactions influenced the opening balance of the same month because entries affect account balances based on their date, EcoCal1. We can review your record to correct the balance, and I'll be pleased to show you.

 

Let's start by checking the last reconciliation report to verify if the March statement includes the two transactions. I'll show you how.

 

  1. Go to Reports, select Banking, and then Previous Reconciliation.
  2. Select the Account and Statement Ending Date and then Display.

 

Additionally, we recommend comparing your real-life bank statement with QuickBooks during reconciliation. If the deleted transactions are from the March statement, recreate them as their ending balance carries over as April's opening balance. If not, add these transactions to April's statement and mark them as Cleared or Reconciled.

 

However, it's best to consult your accountant regarding the entries from 2013. They can help you backtrack the previous reconciliations to find what's causing the discrepancy and ensure the accuracy of the account balances.

 

Moreover, refer to this article for other ways to rectify the discrepancy: Fix beginning balance issues in QuickBooks Desktop.

 

Furthermore, run the reconciliation report to view the changes or Print a copy for your records. You can also customize reports to meet your specific needs.

 

For further guidance with fixing the balance or personalizing reports, add a new comment below. We'll be here to provide extra help and insights. Take care.