Why are my connected bank account balances showing incorrect amounts?

Hello there, @susanhope.

I'll help you check the reasons why your bank statement doesn't match with QuickBooks balance.

Here are the possible reasons:

1. Missing transactions needs to be recorded.
2. Duplicate or incorrectly entered transactions
3. The beginning balance in QuickBooks Online is incorrect, or no opening balance created for the bank account
4. Last option is bank reconciliation. Previously reconciled transactions were edited or deleted.

You can get a copy of your bank statement and compare it with the recorded transactions in the bank account inside QuickBooks.

If there are missing transactions, you can update your bank connection.

Here's how:

1. From the left menu, click Banking.
2. Select the account.
3. Press Update.

Here are some articles that you can use for additional reference:

• Categorize and match online bank transactions.
• Reconcile an account in QuickBooks Online.

Let me know if you have questions about bank transactions. I'm always here to help. Have a great day.

Hello Ethel and thank you so much for answering. I just want to make sure I asked my question the correct way, being new to QB online (I have previously used QB self employed).

The attached image shows what QB thinks I have in my two connected bank accounts, which is no where near the same as is actually in there and that is what I am asking. Note I have not tried to reconcile yet, all I have done is connect the banks and then categorised everything.

Hi there. We appreciate the additional information you shared. Let's make sure your account balances are in order.

There are several possible reasons why your QuickBooks Online bank register balance doesn't match your bank balance. Here are the following:

1. Outstanding transactions.
2. New transactions for a connected account
3. Duplicate transactions.
4. Edited or deleted transactions.
5. Credit card (liability) account.

One way to ensure both balances match is through reconciliation. I agree with my colleague Ethel_A. You can prepare a copy of your bank statement and compare it with your transactions in QBO. Make sure to review your opening balance first. Then, you can start the reconciliation. Here's how:

Note: I suggest contacting your accountant for extra advice to keep things in order.

1. Open the Accounting menu.
2. Go to the Reconcile tab.
3. Select your account from the What account do you want to reconcile? drop-down.
4. Check the Beginning balance. Make sure the beginning balance in QuickBooks matches the one on your statement. Here's what to do if they don't match.
5. Fill in the Ending balance and Ending date on your statement. Some banks call the ending balance a "new balance" or a "closing balance."
6. If you see it, check the Last statement ending date. This is the end date of your last reconciliation. Your current bank statement should start the day after.
7. Once ready, click on Start reconciling.

After that, you can start comparing your statement with QuickBooks. See the image below for reference:

Review the detailed steps by browsing this module: Reconcile an account in QuickBooks Online.

If you're all good, check out this guide on how you can keep track and manage reconciliation reports: How do I view, print, or export a reconciliation report?

Get more help about banking or QuickBooks by replying to this thread. I'll be around to back you and your business. Take the best care!

Thanks for your reply and I will give this a try later or tomorrow. I have to take my pet to the vets today. I will get back to you if I need any further help, again, thanks.