There's a HUGE difference between my bank balance and my Quick Books balance that happened during February & i can't figure it out. Also i reconciled perfectly.

Let me provide some information about why your bank balance is not matching your QuickBooks Online (QBO) balance, jeff-mattingly.

There are several factors may cause the balances to vary between your bank account and QBO. Among these are the following reasons below:

• There are some outstanding transactions left
• You have made new transactions for a connected account
• There are duplicate transactions
• The transactions where either edited or deleted
• Credit card (liability) account

To resolve this balance difference, you can check this article for the recommended troubleshooting steps: Fix beginning balance issues if you've reconciled the account in the past QuickBooks Online.

For more details about reconciling your account, please refer to these articles:

• Learn the reconcile workflow in QuickBooks

• Fix issues when you're reconciling accounts in QuickBooks Online

I've got a link here that provides you with articles about managing your bank transactions: https://quickbooks.intuit.com/learn-support/en-us/banking/07?product=QuickBooks%20Online.

Keep me posted if you need a hand with importing your bank data or any QBO related. I'll be here to help. Wishing for your continued success. 

The video and article to me didn't address this issue which I am also experiencing.

The bank reconciliations for the end of 2023 showed when compared to the balance sheet a difference (negative vs bank ending balance), while the checking/savings had no difference. When looking at the two balances on the dashboard, there was also a difference.

After running the January reconciliation, once again the checking/savings had no difference. However, the difference showing between the bank account and QBO account had grown significantly, as well as the difference showing on the balance sheet.

I cannot figure out why QBO is showing such a significant difference. Need help in finding the solution to address this to get our accounts to match.

Good day, @ATestaPBC. Thanks for joining the thread. 

I'd be glad to share the possible reason why your bank balance and QuickBooks balance are showing different amounts. 

After you connect your account, the bank balance showing on the Banking page is the actual funds in your bank. On the other hand, the balance that shows in QuickBooks relies on the opening balance that you've set when creating the account and the transactions you've entered in the system. 

It's possible that the opening balance didn't match your actual bank when your account was created. That's why your QuickBooks balance and real-time bank balance didn't match.

To check, let's review your opening balance. Here's how:

1. Go to Settings ⚙ and select Chart of accounts.
2. Find the account on the list.
3. Click View register.
4. Search for the opening balance entry. It should have "Opening Balance Equity" in the Account column.
5. Take note of the date and balance.

Now you know the date and amount of the opening balance in QuickBooks. Check it against your bank records:

1. Sign in to your bank's website, or find your bank statement.
2. Check the account's balance for the same day as the opening balance in QuickBooks.
3. Compare the two balances.

If the opening balance in QuickBooks doesn't match your bank records, you'll need to correct it:

1. In QuickBooks, select the opening balance entry to expand the view.
2. In the Deposit column, edit the balance so it matches your bank records.
3. Select Save.

If the balances match, you entered the opening balance correctly. Move on to Step Three of this article and follow the steps to fix the problem: Fix issues the first time you reconcile an account in QuickBooks Online.

Once you know your opening balance is correct, you can start reconciling. 

Please let me know if you have additional concerns about matching your real-life accounts to your QuickBooks accounts. I'm always here to provide further assistance. 

Hello, appreciate the quick reply. I reviewed the steps and the article, and it didn't help me resolve my current issue. So perhaps I am not understanding the steps correctly. 

I started with the opening balance as of 1/1/2023, and they bank and QBO matched (chart of accounts). Everything from that date on has a R. The instructions suggest changing these all to a blank, is that correct? For the entire year?

According to my last reconciliation, I had uncleared checks & payments in one amount, and unclear deposits & other credits in another amount. The difference between those two amounts is the negative difference currently between my bank balance and the QBO balance. These uncleared transactions are primarily BEFORE 2023. I just took over this account for our business from my partner and prior the balance was never this much off; in fact we were almost always within $1-50. I do not know what I did to trigger the differences to show for these uncleared transactions.

I am not sure if I am making my issue clear, and our accountant who does our taxes primarily wants a huge sum to fix this. Can you provide further instructions? Is there a way if not to talk with someone live? tried the local resource that popped up but have yet to get a response. Thank you.

Thank you for coming back and posting your further concern here in the Community, ATestaPBC.

I appreciate that you have reviewed your transactions between your bank statements and QuickBooks Online (QBO) account. However, I highly suggest consulting with your accountant regarding this matter. In this way, you’ll be given the right advice on what to do about the discrepancies within your bank and QBO.

Since you want to talk with our live support, you can follow the steps I’ll be providing below:

1. Log in to your QuickBooks Online company.
2. Click Help (?).
3. Enter your concern, then select Let's Talk.
4. To get started, select one of the tabs:

• When you choose Chat, you’ll be having a chat with our customer support within five minutes. 
• When you choose Callback, you’ll have a spot on our line, and call you back within five minutes. 

Furthermore, I recommend reading these articles that entail the steps and information on fixing your reconciliation discrepancies in your QBO account: 

• Fixed issues at the end of a reconciliation in QuickBooks Online
• Fix issues for accounts you’ve reconciled in the past in QuickBooks Online
• Undo or remove transactions from reconciliations in QuickBooks Online

Let me know if you have more concerns with reconciliation with QBO. I’ll be here to assist you at any time.