Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
C
Collinm
October 27, 2025
Question

Posted and Banking Balance Discrepancy

  • October 27, 2025
  • 1 reply
  • 7 views

Hey! We are having an ongoing reconciliation issue in Quickbooks Online that has left our posted balance about $45,000 lower than our actual bank balance. After reviewing our records, we believed we have traced it back to two transactions that were deleted and edited after they had already been reconciled. One for around $7000 from August and one for around $12,000 from September. 

 

Those changes appear to have broken the reconciliation chain, causing our beginning balances to no longer align with the bank. We have already confirmed that all other transactions and feed data match the actual M&T account. At this point, we believe the best solution is to delete and redo both the August and Sept. reconciliations from scratch. First August with the corrected $7k and then Sept. with the corrected $12k so QB's can rebuild the reconciliation history. 

 

Before doing this, I wanted to confirm if this even makes sense and if it does, is it the best way to approach the problem. Any help is greatly appreciated!

1 reply

Tori B
Tori BQuickBooks Team
QuickBooks Team
October 27, 2025

Hey there, @Collinm.

 

Thanks for taking the time to reach out to the QuickBooks Community. I hope you're having a great day so far. 

 

As long as the transactions are recorded correctly (correct date, amount, etc.), then you can manually reconcile those transactions. Typically when recreating a transaction, it will reappear in your register. Subsequently, you can manually reconcile it by placing R status in the Reconcile (✓) column. 

 

Let me show you how:

 

  1. In QBO, go to the Accounting menu on the left pane.
  2. Proceed to the Chart of Accounts.
  3. Locate the bank account in question, then click View register and look for the recreated transaction.
  4. Under the Reconcile (✓) column, click on the blank field to mark the transactions as reconciled (R).
  5. Hit Save and select Yes to confirm.
     

After completing this, your starting balance should display the accurate amount. For additional assistance on manually reconciling bank transactions and removing their reconciled status, check out this article: Undo or remove transactions from reconciliations in QuickBooks Online.

 

Once done, you can now proceed with the reconciliation process. Refer to this article for future reference: Reconcile an account in QuickBooks Online.

 

That should do the trick. Please don't hesitate to let me know if you have any additional questions or concerns. Have a good one! 

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement