Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
Collinm
Level 1

Posted and Banking Balance Discrepancy

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 Comment 1
Tori B
QuickBooks Team

Posted and Banking Balance Discrepancy

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.

Need to get in touch?

Contact us