cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
crissi1
Level 1

Dashboard balance and Balance Sheet amount does not match

Hi everyone

 

My bank balance on the dashboard and the bank balance on balance does not match. I have recently cleared the bank account (to move to a new one) so the balance is at $0. The dashboard reflects this but when I run the balance sheet (on accrual with the right end date), it shows that there is $5.05 in the account. 

 

This bank is a foreign currency account. I'm guessing it must have something to do with the currency conversion. 

 

I have checked everything line by line. Things seem to have been reconciled correctly. The actual bank balance and the dashboard number is correct - at $0. I'm just having the problem when I run the balance sheet. 

 

Any assistance would be much appreciated. 

Solved
Best answer January 13, 2022

Best Answers
CharleneMaeF
QuickBooks Team

Dashboard balance and Balance Sheet amount does not match

I understand how important it is to customize the Balance Sheet to match the currency on the Dashboard, crissi1. I'm here to share some insights about this.

 

As of now, the functionality to customize the Balance Sheet to match the currency on the Dashboard is unavailable. I'd recommend sending a feature request directly to our Product Development team. This helps us improve your experience with the program. 

 

Here's how:

 

  1. Go to the Gear menu and then select Feedback.
  2. Type in your feature request in the description box.
  3. Once done, click on Next.

 

For your visual reference, I've attached a screenshot below.

Capture.PNG

 

Also, you can track feature requests through the Customer Feedback for QuickBooks Online website.

 

Additionally, I've added these articles that'll help you learn more about running and customizing reports in QuickBooks Online.

 

 

I'm only a few clicks away if you need assistance running and personalizing reports in QuickBooks, crissi1. It's always my pleasure to help you out again.

View solution in original post

3 Comments 3
AlcaeusF
Moderator

Dashboard balance and Balance Sheet amount does not match

,

Hi @crissi1,

 

Thank you for posting here in the Community. I'm here to help you with your concern about the Balance Sheet report in QuickBooks Online.

 

The bank balances that'll show on your dashboard are the actual currency of your accounts. For example, if your account is in CAD, it'll also reflect the amount in CAD on your dashboard.

 

However, the balance sheet report will show the balance using the home currency exchange rate. It's the reason why it's showing different amounts when running the report.

 

Additionally, I've attached a link you can use to personalize financial reports, like changing the filters and columns in QuickBooks: Customize reports in QuickBooks Online.

 

Leave a comment below if you need more clarification about running financial reports in QBO. The Community and I will be around to help you. ​

crissi1
Level 1

Dashboard balance and Balance Sheet amount does not match

Thank you AlcaeusF, this is a very useful answer. Is there any way I can customize the balance sheet to match the currency on the dashboard? I had a look at the customization options which you sent the link for but I don't see this option. 

CharleneMaeF
QuickBooks Team

Dashboard balance and Balance Sheet amount does not match

I understand how important it is to customize the Balance Sheet to match the currency on the Dashboard, crissi1. I'm here to share some insights about this.

 

As of now, the functionality to customize the Balance Sheet to match the currency on the Dashboard is unavailable. I'd recommend sending a feature request directly to our Product Development team. This helps us improve your experience with the program. 

 

Here's how:

 

  1. Go to the Gear menu and then select Feedback.
  2. Type in your feature request in the description box.
  3. Once done, click on Next.

 

For your visual reference, I've attached a screenshot below.

Capture.PNG

 

Also, you can track feature requests through the Customer Feedback for QuickBooks Online website.

 

Additionally, I've added these articles that'll help you learn more about running and customizing reports in QuickBooks Online.

 

 

I'm only a few clicks away if you need assistance running and personalizing reports in QuickBooks, crissi1. It's always my pleasure to help you out again.

Log in today
Get expert help and peer support to tackle all your QuickBooks questions effortlessly.

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up