Skip to main content
January 12, 2025
Question

My bank balance does not agree to quick books and there are uncleared transaction going back years

  • January 12, 2025
  • 1 reply
  • 0 views
Original commenter did not share additional details

1 reply

January 12, 2025

I know how important it is to ensure that your bank balance and QuickBooks match with each other, @Waltham. Let me share more information about this.

 

If the balance in your QuickBooks Online bank register does not match your actual bank balance, several reasons could explain this discrepancy. Here are some reasons why balances do not match:

 

  • Outstanding transactions
  • New transactions for a connected account
  • Duplicate transactions
  • Edited or deleted transactions
  • Credit card (liability) account

 

You can visit this article to learn how to fix these issues and understand the causes: Fix issues for accounts you've reconciled in the past in QuickBooks Online.

 

There are several reasons why old transactions are showing from years ago:

  • Someone entered an incorrect opening balance when they created the account in QuickBooks.
  • Someone added transactions that are older than the opening balance but didn't edit the original opening balance entry to reflect the change.
  • Someone edited, deleted, moved, or unreconciled a previously reconciled transaction. This alteration affects the ending balance of your last reconciliation, which in turn impacts the beginning balance of the next one.
  • A transaction was manually reconciled, so it did not appear in the next reconciliation.

 

To manually reconcile them, follow these steps:

  1. Navigate to the Chart of Accounts and select the bank associated with the transaction.
  2. Click the transaction you want to reconcile.
  3. Change the C to R to reconcile.
  4. Hit Save.

 

You can visit this link to learn how to match and categorize your transactions in QuickBooks Online. This process can help you review transactions after they're downloaded from the bank.

 

Additionally, I am happy to inform you that our QuickBooks Live Expert Assisted service is available to help you manage and categorize your transactions. Our experts, who have extensive experience, are eager to share insights and best practices to streamline and improve your financial management. Their expertise guarantees a seamless and efficient approach tailored to your specific needs.

 

Let me know if you have other questions about your bank transactions. We'll attend to them as soon as possible. Have a great day ahead.