Solved

Dashboard balance and Balance Sheet amount does not match

Forum|Forum|4 years ago
January 13, 2022
1 reply
0 views

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.

QuickBooks Online

Best answer by CharleneMaeF

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:

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

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

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.

AlcaeusF

,

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.

C

crissi1Author

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.

C

CharleneMaeFAnswer