Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
July 30, 2025
Question

Bank reconciliation problems with Quickbooks desktop

  • July 30, 2025
  • 1 reply
  • 46 views

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?

1 reply

Moderator
July 30, 2025

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.

BevvyAuthor
August 2, 2025

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.