Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
October 12, 2022
Question

My bank reconciliation bank register amount does not agree with my trial balance.

  • October 12, 2022
  • 1 reply
  • 0 views
I have completed a reconciliation for September 2022 and initially the bank register balance from the reconciliation agreed to the September 2022 trial balance and September 2022 balance sheet. I reconciled on October 6. Now on October 12, those balances do not agree. What did I do wrong?

1 reply

QuickBooks Team
October 12, 2022

This is unusual behavior, tiffhous.

 

There are several transactions why your bank register doesn't match your trial balance. I've added listed them below:

 

  • Outstanding transactions
  • New transactions for a connected account
  • Duplicate transactions
  • Edited or deleted transactions

 

Let's start by reviewing the opening balance in your account to make sure it's correct. Here's how:

 

  1. Select the Accounting menu.
  2. Choose Chart of Accounts.
  3. Look for the account on the list.
  4. From the Actions column, click View register.
  5. Search for the opening balance entry. This transaction should have an "Opening Balance Equity" in the Memo column.

 

If there's an opening balance, let's make sure it has the correct date and amount. Otherwise, you can enter it by creating a journal entry. You can refer to this article for the detailed steps: What to do if you didn't enter an opening balance in QuickBooks Online.

 

On the other hand, you may have transactions that were not supposed to be reconciled. Let's run the previous reconciliation report to review it one by one. Here's how: 

  1. Go to Accounting, then select the Reconcile tab. 
  2. Click the History by account link.
  3. Choose the Account and Report period.
  4. Open the year with the statement ending date.
  5. Click View report

 

For additional troubleshooting steps, please see this article: Fix issues for accounts you've reconciled in the past in QuickBooks Online.

 

Once done, you can reconcile your account. Then, review the reconciliation report to ensure your books are accurate.

 

Please update us if you need additional assistance in reconciling your transactions. We're always here to help.