cancel
Showing results for 
Search instead for 
Did you mean: 
JillCHal
Level 1

Quickbooks online bank account balance does not match

I use QB online and download my checking account transactions on a weekly basis and reconcile my account monthly.  For a long time now, my "bank balance" has not changed.  It has not matched my actual balance for quite some time.  Capture1.PNGShouldn't the "bank balance" always update to the current balance that is actually in the bank account?  I understand that the "bank balance" and the "quickbooks balance" will probably never match, but why isn't the "bank balance" matching what's really in the bank??  

Solved
Best answer June 14, 2020

Best Answers
Rejeil_O
QuickBooks Team

Quickbooks online bank account balance does not match

Welcome to Community @JillCHal.

 

Let me help you with the bank balance in your QuickBooks Online account. The "Bank Balance" will only depend on the update on your financial bank institution while the "In QuickBooks" balance will change when you add transactions in your QuickBooks Online account.

 

If your "Bank Balance" is not automatically updating, you can manually update the bank balance to match it to your recent financial bank institution. Here's how:

 

  1. Go to the Banking menu or Transactions menu.
  2. Select Update. If you only want to update some accounts, select the unwanted ones, then select Update now.
  3. If asked, enter your Multi-Factor Authentication (MFA) credentials.
  4. Click the Continue update button.

 

For more detailed information about updating your bank balance, you can read this article: Manually download online bank transactions in QuickBooks Online.

 

You can also match and categorize your bank transactions to prevent duplicates activities.

 

If you have follow-up questions, feel free to leave a message in the comment section. I'll be around here in the Community to help. Take care and have a good one!

View solution in original post

13 Comments 13
Rejeil_O
QuickBooks Team

Quickbooks online bank account balance does not match

Welcome to Community @JillCHal.

 

Let me help you with the bank balance in your QuickBooks Online account. The "Bank Balance" will only depend on the update on your financial bank institution while the "In QuickBooks" balance will change when you add transactions in your QuickBooks Online account.

 

If your "Bank Balance" is not automatically updating, you can manually update the bank balance to match it to your recent financial bank institution. Here's how:

 

  1. Go to the Banking menu or Transactions menu.
  2. Select Update. If you only want to update some accounts, select the unwanted ones, then select Update now.
  3. If asked, enter your Multi-Factor Authentication (MFA) credentials.
  4. Click the Continue update button.

 

For more detailed information about updating your bank balance, you can read this article: Manually download online bank transactions in QuickBooks Online.

 

You can also match and categorize your bank transactions to prevent duplicates activities.

 

If you have follow-up questions, feel free to leave a message in the comment section. I'll be around here in the Community to help. Take care and have a good one!

Tetiana
Level 1

Quickbooks online bank account balance does not match

Hello!
 
QB shows on balance report not actual balance on account as on a bank statement,QB deducted unclear checks amount and payments that cleared next month, that`s why balances do not match. 
When I do a balance report - amount on my bank account from QB, not from bank, so reports are not very accurate.
 
Please advise.
Cindyc98
Level 1

Quickbooks online bank account balance does not match

 We opened a new bank account and we started using QB Online. My begining account balance does not match our bank stement when I want to reconcile. How do I fix this?

JaeAnnC
QuickBooks Team

Quickbooks online bank account balance does not match

Thanks for reaching out to us for assistance, @Cindyc98. It's my pleasure to guide you through the process of updating your beginning balance in QuickBooks Online (QBO) so you can reconcile your accounts.

 

Don't worry if the beginning balance is off when reconciling an account for the first time. It occurs when you enter an incorrect opening balance during the first setup. Correcting the opening balance should also resolve your beginning balance issues.

 

Follow the steps below on how to edit the opening balance so it will match your bank statement.

 

  1. Go to the Gear icon and select Chart of Accounts.
  2. Find the account on the list and click View Register.
  3. Please search for the opening balance entry and select it to expand the view. It should have "Opening Balance Equity" in the Account column. 
  4. In the Deposit column, edit the balance to match your bank records.
  5. Select Save.
    image (3).png

Then, review your account register. When reconciling for the first time, the opening balance should be the only entry that is reconciled. For the complete steps, please refer to this article: Fix issues the first time you reconcile an account in QuickBooks Online.

 

Furthermore, QBO automatically creates a reconciliation report each time you finish reconciling. It includes a list of cleared and uncleared transactions as well as an overview of the beginning and ending balances.

 

Feel free to drop by the Community anytime you have additional concerns about reconciliation. I'm always around to assist. Have a nice day and stay safe!

realpeoplepress
Level 1

Quickbooks online bank account balance does not match

This is happening to me also.

I just downloaded all my bank transactions, and opened the transaction download file. These transactions all show up in the QB banking window.

However, at the top of that window where it is supposed to show my bank balance, it seems to be frozen.

The date shown is in the past, and the bank balance didn't change when I input the new bank transactions.

i don't know what to do.

It used to work right and show the correct bank balance. But for quite a few months now it's been frozen showing the same date and same amount, no matter how many new transactions I enter.

Earlier the date shown at the top of that banking window was in the future. Now it's in the past. I have no idea what to do about it.

 

DebSheenD
QuickBooks Team

Quickbooks online bank account balance does not match

I know that this hasn't been easy for you. QuickBooks Online (QBO) always wants to make sure you can perform your banking tasks seamlessly.

 

The spinning wheel might be caused by a connection between your bank's website and QuickBooks Online. If you have noticed that you're no longer getting your latest transaction, you can perform a manual update to refresh your bank connection. Here's how:

 

  1. Go to the Banking menu.
  2. Select the Banking tab, then choose a bank account.
  3. Select Update.
     

Additionally, here's the article that compiles the solutions you can perform whenever transactions aren't downloading from your bank: What to do if you get a bank error or can't download transactions in QuickBooks Online.

 

I'm also adding this article to help review your downloaded online banking transactions in QBO: Categorize and match online bank transactions.

 

Just drop a comment below if you have any other concerns or follow-up questions. I'll be around to help.

realpeoplepress
Level 1

Quickbooks online bank account balance does not match

Hi Deb,

Thanks for your reply! However I think I need to clarify my situation. I AM able to successfully download my bank transactions. I don't have any trouble doing this. Also I'm not seeing a spinning wheel. I used the word "frozen" but I just meant that the number for "current bank balance" that shows up at the top of the online banking window, always stays the same. It doesn't change. Also the date shown doesn't change.

So my transactions all download properly. But that line at the top that says something like "your bank balance on X date is Y dollars" never changes. It's been like this for a few months. I can always download my new transactions. But if I want to see my current bank balance, I have to go online outside of quickbooks to my bank's website for that. It's an extra step and isn't efficient use of my time. 

Hope I"m being clearer now.

Please tell me how I can get quickbooks to update that line. I already tried closing and opening quickbooks, and that didin't help.

Thanks!

 

realpeoplepress
Level 1

Quickbooks online bank account balance does not match

Hi Deb,

Thanks for this. However I think I need to describe my situation better.

I AM able to download my bank transactions already. I can do this without any problem, and they show up in Quickbooks accurately. So I don't need help with that.

The problem is that that top line in the online banking window, that says something like "Your current bank balance on X date is Y dollars" never changes. The date stays the same and the balance stays the same. So that's what I meant by "frozen." Maybe I used the wrong word. But I don't see a spinning wheel. It's just that the information in that line doesn't update, and isn't correct.

This problem started a few months ago. At that time the listed date for the bank balance was actually in the future. Now the listed date is in the past. But the point is it doesn't change, even though the actual date is changing. And the dollar amount doesn't change, even though quickbooks has all the new transactions that have happened.

Can you tell me what to do to solve this?

Now to find out my bank balance I have to open a separate tab and go to my bank website, login etc. It's extra time for me, so not efficient. I'd like to get the Quickbooks banking window to start working again. It always used to work fine.

I did try closing Quickbooks and reopening. But that didn't help.

Thanks!

Connirae

Candice C
QuickBooks Team

Quickbooks online bank account balance does not match

Good afternoon, @realpeoplepress

 

Thanks for coming back and clarifying some more about your issue with banking in QuickBooks Online. 

 

Before moving further, let me gather some information from you: 

 

  • Is this happening to more that one bank account? 
  • Please provide the name of each bank that this is happening to. 

 

In the meantime, you can check out our banking section of the Community. You can review articles that may be helpful to you in the future from there. 

 

Overall, this will help us determine the next steps you need to take to fix the problem. I'll be back around shortly! 

realpeoplepress
Level 1

Quickbooks online bank account balance does not match

Hi Candice,

I just have one bank account in Quickbooks.

The bank is FirstBank of Colorado.

Thanks!

Connirae

Candice C
QuickBooks Team

Quickbooks online bank account balance does not match

Hey there again, @realpeoplepress

 

Thanks for getting back to me so quickly. 

 

After reviewing our investigations with particular banks, I didn't see one associated with your financial institutions. With that being said, I suggest contacting our Customer Support Team for further assistance. They'll be able to look over the back end of your account to see why this is occurring in the system. 

 

Here's how: 

 

  1. Go to the Help (?) icon in the top right-hand corner. 
  2. Press the Contact Us button/hyperlink. 
  3. Give a brief description of the issue and hit Let's talk
  4. Scroll down and pick to Get a callback

 

Keep us updated on how the call goes. It's my priority that you're able to update your bank balance as soon as possible. Take care! 

awilson0726
Level 1

Quickbooks online bank account balance does not match

i have 5 bank accounts.  Only one seems to update with the bank.  I followed your steps above and my bank balances on 4 of the accounts  still say zero.  It will go through the updating process but it's like nothing from the bank updates.  

SarahannC
Moderator

Quickbooks online bank account balance does not match

I appreciate you for joining here and sharing your concern here, awilson0726.

 

Have the four bank accounts been successfully linked through online banking? If they have, I suggest using a private browser to isolate the reasons behind the lack of balance updates for the other bank accounts.

 

You can utilize any of these keyboard shortcuts:
 

  • Ctrl + Shift + for Google Chrome
  • Ctrl + Shift + for Mozilla Firefox and Microsoft Edge
  • Command + Shift + for Safari

 

Aside from that, you can use other compatible browsers in QuickBooks Online. 

 

  • Mozilla
  • Google Chrome
  • Microsoft Edge
  • For Safari, make sure to use the latest one.

 

If the balances of those bank accounts continue to display as zero in QuickBooks Online, I recommend logging in directly to your bank's website. This action can help you identify any required updates, alerts, or notifications that might need your attention. Such issues could potentially be causing a disruption in the connection between QuickBooks and your bank.

 

Know that you can always tap me on my shoulder if you ever need anything else with QuickBooks. I'll be around to back you up.

Need to get in touch?

Contact us