cancel
Showing results for 
Search instead for 
Did you mean: 
LorraineMo
Level 3

Bank balance not updating

I have a situation where a client's credit card "Bank Balance" (only) has stopped updating.  Transactions are coming through fine and she reconciles to the credit card statement.  

However, the "Bank Balance" value showing in the summary bank is incorrect and has been for several weeks now.  

 

Fortunately, it is just a cosmetic issue, since feed is working.  But do you have any suggestions on what would cause this or how to fix it?

Solved
Best answer July 12, 2023

Best Answers
SarahannC
Moderator

Bank balance not updating

I appreciate you for returning to this thread, Lorraine. Allow me to help you this time and provide additional information regarding your bank balance.

 

Since you're using a third processor with your bank, I recommend contacting Spendtrack support to determine if there is a known problem related to this. They can provide the most up-to-date information and possible solutions.

 

Additionally, if you keep your credit card account connected to the program while manually importing your data, your bank balance should stay as is. 

 

I also noticed in your previous message that you mentioned having a plan to delete your account and then link it again. As initial steps to fix it, you can do it since you have no problem matching and reconciling transactions.

 

Just make sure that your bank transactions are fully reviewed or categorized from the For review tab before disconnecting your bank account. Otherwise, you may run the risk of losing the data that you need.

 

For more information on this topic, refer to the article: Disconnecting accounts linked to online banking in QuickBooks Online.

 

Feel free to go back here and ask more if you have further questions regarding bank transactions. I'm here to assist you whenever you need help. 

View solution in original post

8 Comments 8
jenop2
QuickBooks Team

Bank balance not updating

Hi there, Lorraine.

 

Can you tell us the of the bank that's connected in Online Banking? I just want to check if we have an open alert about this in QBO. 

 

In the meantime, let me share some steps to check if the balance issue is caused by too much cache in your browser. 

 

Start by switching or using other browsers like Google Chrome, Mozilla, Microsoft Edge, or Safari. They are all compatible with QBO and can help us isolate the issue. Use these keyboard shortcuts on how to do that:

 

  • Ctrl Shift for Google Chrome
  • Ctrl Shift for Firefox
  • Control Option +if you're using Safari
  • Ctrl Shift for Microsoft Edge

 

After that, go back to your account and click the Update button in the upper-right hand corner. This will force QuickBooks to establish a connection with your bank and refresh the Online Banking page.

 

 

If the balance is already updating, follow the steps in this article on how to clear cached or delete internet files; Clear Cache and Cookies to Fix Issues When Using QuickBooks Online.

 

Feel free to check out these online banking-related articles in case you need more guidance when using the feature:

 

 

The Community is always here if you need anything else. 

LorraineMo
Level 3

Bank balance not updating

Thank you for the suggestions.  

The credit card account is with Nicolet National Bank.

It does not appear to be a browser issue -  I cleared cache and pulled up account on Chrome, Chrome incognito, Bing, and Firefox with exact same results.  I don't know what browser client is using, but it is same on hers.

 

The feed shows "updated 17 hours ago" and does not change when force updated.  I know transactions have come across in the weeks since the Bank Balance figure changed, but there aren't necessarily daily transactions on this account so it is hard to tell if there are items available that have not come over yet.  

 

My plan today is to delete the feed and re link to see if that fixes it.

 

Thank you for your help with this.

LorraineMo
Level 3

Bank balance not updating

I have a bit more info.

Client's Nicolet National Bank checking account is linked, works fine.

However, the Nicolet National Bank Credit Card account, which is the problem account, is different:  

  • The processing is through Spendtrack. 
  • Originally, client says it was linked and auto updated.  Then about 6 months ago it stopped updating and since then she has had to go out to the account, create a file, and manually import the file into QBO.
  • Around 6 weeks ago, the "Bank Balance" field was correctly zero.
  • Since then, each import has seen the "Bank Balance" field become steadily more negative (currently -$9,050), which has no relation to the actual credit card balance.
  • The import files have had all of the transactions, the only problem is the "Bank Balance" field.
  • This incorrect field is driving her crazy, despite her understanding that it is not impacting her financial reports and register, which are correct.

I feel that she cannot be the only one experiencing this problem.  Is it a known issue with Spendtrack?  

Maybelle_S
QuickBooks Team

Bank balance not updating

Thanks for adding additional information, LorraineMo. Let me share some details about the bank balance that shows zero in QuickBooks Online (QBO).

 

The Bank Balance is zero because you're manually uploading your transactions, and QuickBooks doesn't have access to your bank. This is the default, even if you bring in the transactions. You can still review if the actual amount in your bank is the same as what's in QuickBooks by checking the total balance In the QuickBooks balance section.

 

In addition, all transactions you recorded will affect the QuickBooks balance. It's possible that there are duplicate transactions so you'll want to review them to avoid discrepancies. Here's how:

 

  1. Go to the Banking menu.
  2. Select the correct bank account.
  3. Tap the For Review tab and mark the items you want to delete.
  4. Click the Batch actions button.
  5. Choose Exclude.
    1.PNG
  6. Once done, go to the Excluded tab.
  7. Mark the transactions. Then, click the Batch actions button.
  8. Hit Delete.
    1.PNG

 

Additionally, make sure your books are accurate by putting the credit card transactions in the correct account: Categorize and Match Online Bank Transactions.

 

Moreover, you can also access your bank balance outside QuickBooks and compare it to what's in QBO.

 

I've also added an article that'll help you review your accounts in QuickBooks. This ensures the amounts match your real-life bank and credit card statements: Reconcile Workflow in QuickBooks.

 

If I can be of any additional assistance, please don't hesitate to let me know. I'm always here to help you out again.

LorraineMo
Level 3

Bank balance not updating

This reply does not address the stated issue. 

The bank balance is NOT zero because client is manually importing - it is a negative number and becoming more negative with each manual import.

Prior to 6 weeks ago, it was coming over correctly from the bank using the same importing procedure.  Nothing in process changed, except bank balance field is showing progressively more negative number.

There are no issues with the way the client is reviewing, matching, categorizing, excluding, or reconciling account; account is correctly reconciled and matches to actual balance. 

The issue is JUST the "bank balance" field being wrong.

SarahannC
Moderator

Bank balance not updating

I appreciate you for returning to this thread, Lorraine. Allow me to help you this time and provide additional information regarding your bank balance.

 

Since you're using a third processor with your bank, I recommend contacting Spendtrack support to determine if there is a known problem related to this. They can provide the most up-to-date information and possible solutions.

 

Additionally, if you keep your credit card account connected to the program while manually importing your data, your bank balance should stay as is. 

 

I also noticed in your previous message that you mentioned having a plan to delete your account and then link it again. As initial steps to fix it, you can do it since you have no problem matching and reconciling transactions.

 

Just make sure that your bank transactions are fully reviewed or categorized from the For review tab before disconnecting your bank account. Otherwise, you may run the risk of losing the data that you need.

 

For more information on this topic, refer to the article: Disconnecting accounts linked to online banking in QuickBooks Online.

 

Feel free to go back here and ask more if you have further questions regarding bank transactions. I'm here to assist you whenever you need help. 

LorraineMo
Level 3

Bank balance not updating

posted reply in wrong conversation - this is still an ongoing problem.

GlinetteC
Moderator

Bank balance not updating

You're most welcome, Lorraine.

 

I'm happy that my colleague was able to assist you in achieving your goal. Rest assured that we will continue to give the best customer service you ever experienced.

 

Let us know if you have other concerns in the comments below. We're always here to assist.

Need to get in touch?

Contact us