Skip to main content
October 7, 2020
Solved

The bank balance on the dashboard includes all future transactions so is not an accurate reflection of the balance now. Is it possible to change this?

  • October 7, 2020
  • 3 replies
  • 0 views
Original commenter did not share additional details
Best answer by vpcontroller

"The bank balance on the dashboard includes all future transactions so is not an accurate reflection of the balance now. Is it possible to change this?"

 

@nappybeth

REVISED (typo):

Sorry,  it's not possible to customize the Dashboard and show the QuickBooks cleared balance only or by the reporting period.

You will need to rely on the real Bank Balance on the dashboard, not QuickBooks balance.

3 replies

AlcaeusF
October 7, 2020

Thanks for reaching out to the Community, @nappybeth.

 

The bank balance is your bank's actual balance from the last bank feed update. If bank balance is greater than your QuickBooks balance, there might be some transactions that are causing the difference.

 

These are the factors that can affect how the balances are shown on your Dashboard.

 

  • Outstanding transactions.
  • New transactions for a connected account.
  • Duplicate transactions.
  • Edited or deleted transactions.
  • Card (liability) account.

 

There are different ways on how to fix this depending on the scenarios above. Check out this article for the complete guide: Fix beginning balance issues if you've reconciled the account in the past QuickBooks Online.

 

Also, I suggest reconciling your account again to ensure your beginning balance matches your bank statement. Refer to this article for future reference: Reconcile an account in QuickBooks Online.

 

Please leave a comment below if you have any other questions or concerns. I'll be here to assist. Have a good one!

nappybethAuthor
October 9, 2020

 That's not what I mean. 

I am referring to the QuickBooks bank balance which includes future dated transactions. 

MariaSoledadG
October 9, 2020

You've come to the right place, nappybeth.

 

QuickBooks balance depends on the transactions entered in the system. 

 

Every time you're getting an incorrect QuickBooks balance, you'll have to start reviewing and making sure your opening balance is correct. Then, ensure to match and categorize your bank transaction. Unreviewed transactions may affect your opening balance.

 

Lastly, review any discrepancy reports. Make sure that you're reconciling the right account for the right month. For more information and detailed steps, please read this article: Fix Beginning Balance Issues when reconciled.

 

For future reference, you can run reports in QuickBooks Online to view useful information for your business.

 

Reach out to us for further assistance. We always make sure to help you anytime.

vpcontroller
October 11, 2020

"The bank balance on the dashboard includes all future transactions so is not an accurate reflection of the balance now. Is it possible to change this?"

 

@nappybeth 

 

No, it's possible to customize the Dashboard and show the QuickBooks cleared balance only or by the report period.

You will need to rely on the real Bank Balance on the dashboard, not QuickBooks balance.

nappybethAuthor
October 16, 2020

How do I do that?

vpcontroller
October 17, 2020

"The bank balance on the dashboard includes all future transactions so is not an accurate reflection of the balance now. Is it possible to change this?"

 

@nappybeth

REVISED (typo):

Sorry,  it's not possible to customize the Dashboard and show the QuickBooks cleared balance only or by the reporting period.

You will need to rely on the real Bank Balance on the dashboard, not QuickBooks balance.

December 3, 2022

I have this same issue and wondering if QB has rolled out any features to support inclusion/exclusion of future transactions? 

December 3, 2022

I hope your day is going great so far, @Mcny.

 

I see that you need a feature that is relevant to your company. I'm looking forward to helping you today by sharing information about the inclusion and exclusion of future transactions in QuickBooks Online.

 

QuickBooks balance is solely dependent on the transaction entered. As a result, we must rely on the dashboard's Bank balance rather than the QuickBooks balance.

 

Furthermore, if you encountered errors while reconciling the QuickBooks balance, this is the ideal resource for the future: Fix issues for accounts you've reconciled in the past in QuickBooks Online.

 

For another future reference, you can run reports in QuickBooks Online to view valuable information for your business.

 

I'm always available to help you with your QuickBooks daily tasks. Feel free to add them to this thread. Have a lovely day.