Get 50% OFF QuickBooks for 3 months*
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks. Explore QuickBooks Payroll
Bevvy
Level 1

Bank reconciliation problems with Quickbooks desktop

I had done bank reconciliations and they were fine from 2023 to Feb 2025. When I went to do March 2025, the beginning balance did not match. I did a discrepancy report and found two issues. I was able to correct the one with no problem but the second one was a deleted transfer from December 2023 (Bank chequing account to MC payment).  I have tried several ways to fix this and it still shows up. During all of this, I voided another amount in July, 2023. I tried and failed to correct this transfer. Now, all of bank reconciliations from June 2023 to the present have the wrong beginning balance by the amount of the two discrepancies. How do I fix this awful mess?

2 Comments 2
KimberlyS
Moderator

Bank reconciliation problems with Quickbooks desktop

We really appreciate the effort you’ve put into addressing your concern, Bevvy. We understand this can be challenging, but don’t worry—we’re here to help. We can correct the beginning balances by conducting a mini reconciliation in QuickBooks Desktop (QBDT). Let’s explore the details below.

 

Beforehand, please make sure deleted and voided transactions are recreated. You can run and customize the Audit Trail report to look for each of them, ensuring the same information is captured again. To locate this data, go to the Reports menu and select Accountant & Taxes. Also, you can refer to your bank statement to ensure the bank register totals are accurate.

 

Once entries are entered back in QBDT, it's time to reconcile them. Begin by reconciling the transaction from June, followed by the one in December.

 

Here's how:

 

  1. In the Banking menu, select Reconcile.
  2. Choose the account, then enter the date for an "off-cycle reconciliation" in the Date of Statement field. It's any date between your last reconciliation and the next scheduled one.
  3. Provide the balance of your last successful reconciliation in the Ending Balance field and hit Continue.


     
  4. Once in the Reconcile window, check the transaction you're fixing.
  5. Make sure the Difference field shows $0.00.
  6. Click Reconcile Now.

 

To make sure these corrections are handled accurately, I recommend seeking guidance from your accountant. They can provide close guidance to prevent further discrepancies when fixing past reconciliations.

 

I hope the information above helps restore the integrity of your financial records. If other questions arise, drop by this thread again anytime. We are here to assist you with various tasks in QuickBooks Desktop. Have a great day ahead.

Bevvy
Level 1

Bank reconciliation problems with Quickbooks desktop

I received the reply and much appreciate the advice. I will be trying this solution next week when I go into the office again and will let you know how I do.

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

Need to get in touch?

Contact us