Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
dcal123
Level 1

Reconciliation Discrepancy

I am dealing with a difference in my reconciliation and I can not pinpoint exactly where it is coming from: 

- My ending date, beginning and ending balances match up with my bank statements. 

- My deposits and payments totals match up with bank statements, including the number of transactions. 

- When everything is checked, I have a difference of $371.90 and when I uncheck everything, there is a starting difference of $83.46. 

- I am assuming the starting difference comes from the previous month's reconciliation report that had uncleared transactions after 9/30/25 of $80.49. 

I am still unsure where to go from here and actively trying to find a solution. Any help would be greatly appreciated. 

1 Comment 1
Tori B
QuickBooks Team

Reconciliation Discrepancy

Hi there, @dcal123.

 

Thanks for taking the time to reach out to the QuickBooks Community for support. I hope your day is going great. 

 

It sounds like the $83.46 starting difference and $371.90 total difference could be due to previously cleared transactions have been modified, deleted, or unreconciled, and new uncleared transactions are affecting the balance.

 

I'm including some steps to help balance the reconciliation that we have seen other users use in the past below. However, please know you should always consult with your accounting professional before making any changes to your books. If you don't have an accountant, don't sweat it. You can find one here in our Resource Center

 

First things first, you'll need to fix that starting balance of $83.46. To do this:

 

  1. Run a Reconciliation Discrepancy Report
    • Go to the Reports menu, find the Reconciliation Discrepancy report for your account, and select the last successful reconciliation date.
  2. Identify Changes: 
    • This report will list any transactions that were changed, deleted, or added since the last reconciliation.
  3. Re-clear Transactions: 
    • Edit the identified transactions to bring the opening balance back to match the statement.

 

Once that balance is cleared, you'll need to resolve the remaining difference of $371.90. Here's how:

 

  1. Check for Duplicate Transactions by looking for duplicate deposits or payments.
  2. Verify "Uncleared" Transactions: 
    • You stated your previous report showed uncleared items after 9/30/25. Check if any of these should have been cleared in the current period, or if they were mistakenly cleared and then uncleared.
  3. Verify that all transaction amounts match the bank statement, as small errors like ($0.10, $1.00) can cause discrepancies.

 

If you continue to have issues, you may need to undo the last reconciliation to fix the starting balance, or, as a last resort, use a balance adjustment (adjusting journal entry) to match the bank statement.

 

Additionally, I would like to share some helpful resources to assist you in handling your transactions in QBO. These articles guide you through resolving any reconciliation issues you may encounter and guide you on maximizing the benefits of your financial reports:

 

 

Again, please make sure to run this by your accounting professional for accurate accounting. 

 

Don't hesitate to let me know if you have any questions or concerns. Take care! 

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us