cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
PTJ
Level 2

Deposits not showing in Balance Sheet Report by Class

When I run a balance sheet report that is filtered by class, my bank deposits are not showing up in the report. If I turn off the class filter, they show up just fine and all of the balances are accurate. However, when filtered by class, the deposits don't show up.

 

How do I get a deposit that is attributed to a class to show up in a report that is filtered by class?

 

Thanks!

Solved
Best answer 04-16-2019

Accepted Solutions
QuickBooks Team

Re: Deposits not showing in Balance Sheet Report by Class

Thanks for getting back to us, @PTJ.


I appreciate you following the steps above to get the right information on your Balance Sheet by Class report. Allow me to join the conversation and provide clarification.


Each transaction (except journal entries) is separated into two parts, the header, and the detail. The Balance Sheet by Class Report pulls in the header portions of the transactions, in which asset, liability, and equity accounts are selected.


When using classes, transactions are attached to the detail portion making the report incorrect. Resolve this by entering all related transactions as General Journal Entries and specify a class on each line item.


Check out the following articles to know more about this: 

You can also run the Profit and Loss report and customize it by class to get the information from the detail side of the transaction. Let me show you how:

  1. Go to Reports from the left menu.
  2. Enter Profit and Loss in the Search field.
  3. Select Report period.
  4. On the Display columns by drop-down, choose Classes.
  5. Click Run report.

 

 

Take a look at this article for reference: Customize the Profit and Loss report.


That should get you on the right track.


Touch base with me here if you need anything else, I’m more than happy to help. Have a good one!

View solution in original post

10 Comments
QuickBooks Team

Re: Deposits not showing in Balance Sheet Report by Class

Thanks for reaching out to the QuickBooks Community, @PTJ.

 

I'm here to help resolve the issue when filtering Balance Sheet Report by Class in QuickBooks Online (QBO). 

 

I've replicated this on my QuickBooks sample file, and it seems like my bank deposit shows when filtering the Balance Sheet report by Class. Let's perform troubleshooting steps, which is to switch to a different browser. This is a good way to check if it's caused by the browser. Let's log into QBO using a private browser. 

 

Here are the keyboard shortcuts to open a private browser: 

  • Google Chrome: press Ctrl+Shift+N 
  • Mozilla Firefox: press Ctrl+Shift+P 
  • Internet Explorer: press Ctrl+Shift+P 
  • Safari: press Command+Shift+N

If it works fine, I suggest clearing your browser's cache to start fresh. The next time you log in to QuickBooks Online, your browser will download fresh copies of everything you see on each page. Any cache-related issues should be cleared up. 

 

For additional reference, you can check this article on how to customize reports

 

Please let me know how it goes by clicking the Reply button below. I'll be around to help if you have additional questions about the QBO reports. Have a good one. 

Anonymous
Not applicable

Re: Deposits not showing in Balance Sheet Report by Class

Thanks for the suggestion - sadly, this doesn't seem to help. I tried a different browser and a private window - it didn't work in either case. None of the "Quick Deposit" items are reflected in the class-filtered Balance Sheet, even though they have a class attributed to them. 

PTJ
Level 2

Re: Deposits not showing in Balance Sheet Report by Class

I did some more testing to see if I could isolate the problem. ... When I drill down from a Balance Sheet Report, in the transaction report for that bank account, the deposit does NOT show that it is classified at all. However, when I go into the bank account though the COA, the deposit does show it is classified. 

 

Any thoughts on how to correct this? Thanks!

QuickBooks Team

Re: Deposits not showing in Balance Sheet Report by Class

Thanks for getting back to us, @PTJ.


I appreciate you following the steps above to get the right information on your Balance Sheet by Class report. Allow me to join the conversation and provide clarification.


Each transaction (except journal entries) is separated into two parts, the header, and the detail. The Balance Sheet by Class Report pulls in the header portions of the transactions, in which asset, liability, and equity accounts are selected.


When using classes, transactions are attached to the detail portion making the report incorrect. Resolve this by entering all related transactions as General Journal Entries and specify a class on each line item.


Check out the following articles to know more about this: 

You can also run the Profit and Loss report and customize it by class to get the information from the detail side of the transaction. Let me show you how:

  1. Go to Reports from the left menu.
  2. Enter Profit and Loss in the Search field.
  3. Select Report period.
  4. On the Display columns by drop-down, choose Classes.
  5. Click Run report.

 

 

Take a look at this article for reference: Customize the Profit and Loss report.


That should get you on the right track.


Touch base with me here if you need anything else, I’m more than happy to help. Have a good one!

View solution in original post

PTJ
Level 2

Re: Deposits not showing in Balance Sheet Report by Class

This is super helpful! In order for a deposit to be able to show up in a class-filtered report, it needs to be entered in as a journal entry. I can fix that. 

 

What about Bill Payments? If I set-up a bill to have a class, the bill shows up in the class-filtered balance sheet report under the appropriate budget or liability line. However, when I pay the bill, the bill payment, even if given a class, does not show up on the class-filtered balance sheet. If I want a bill / bill payment to show up as class-related, do I need to change these to journal entries too? ... That seems to make the whole accounting process more complicated than it should be given the general simplicity of QBO. 

 

Thanks again!

QuickBooks Team

Re: Deposits not showing in Balance Sheet Report by Class

Thanks for the quick response, @PTJ.


I’m glad you found the information above helpful. Let me add some more details about the Balance Sheet by Class report.


Yes, you have to enter both AP and AR transactions using Journal Entry in order for classes to show on the report.

 

The Balance Sheet by Class pulls data from headers, which means the only option to get the class to show on the report is by entering a JE.


You can also use the Profit and Loss to pull details on transactions and filter it by Class. Refer to the articles I shared on my previous response for more information.


That should do it. Please post again in the Community if you have any other questions, I'm always here to help. Cheering you to continued success!

PTJ
Level 2

Re: Deposits not showing in Balance Sheet Report by Class

Thanks @KhimG! I did go back and was reading through the articles you posted while looking at actual checks, bill payments, etc on my QBO. What you're saying makes sense as to HOW it operates, but it doesn't help me a whole lot :-/ ... It would be great to be able to classify an entire bank account for the purpose of running a filtered balance sheet. 

 

It would be a lot of additional work to add journal entries for every AR and AP transaction, not to mention, it defeats the simplicity of QBO to not be able to use the "Quick Deposit" function. Any chance software changes can be made to help reconcile this and make entering expenses and deposits just as easy, while also allowing an easier balance sheet report by class?

 

Again, thanks for your help today!

QuickBooks Team

Re: Deposits not showing in Balance Sheet Report by Class

Hi again, @PTJ.


I appreciate your feedback about the Balance Sheet by Class report. Letting us know what works best for you will show our developers what they need to consider in future product updates.


In the meantime, I recommend visiting our QuickBooks Online Blog to know more about our latest happenings. From there, you’ll get the recent news, features, and updates about QBO and what our Product Team is working on.


I'm also adding the Community help link for future reference in case you need tips and related articles: QBO Self-help.


That should do it. Reach out to me if you have any other concerns, I’m always here to assist you. Wishing you continued success!

Level 2

Re: The balance does not show balances in the currency in which the account is open!

Dear mam/ sir!
I work in QB with several currencies. But when I create a balance sheet, the balance at the beginning and end of the month is indicated only in dirhams (home currency). And I need to see the balance in the currency in which the account is open.
Also, if I go to the age  Bank account history, then the balance, for example, in USD shows - n / a.
How can I fix this, since I did not find this option in the settings.
Thank you!
Regards,Malika.
 
 
 
Moderator

Re: The balance does not show balances in the currency in which the account is open!

Hi Malika24,

 

Thanks for attaching a screenshot for a reference. 

 

If the bank history report is filtered to show only specific transactions, it can't display the total balance amount (the same result as with your screenshot). There's currently no option to show edit it. However, you can export the report to Excel and manually add the total expense amounts. 

 

On the other hand, instead of viewing the register's history, let's run the General Ledger report. All financial reports in QuickBooks Online converts all the transaction amounts to the home currency. The good thing you can customize them to show the Foreign Amount column. It is the equivalent foreign currency of each transactions. 

 

Here's how:

  1. Go to Reports.
  2. Enter General Ledger in the search field.
  3. Click on Customize. 
  4. In the Rows/Columns section, check the Foreign Amount box.
  5. In the Filter section, choose the bank account from the Distribution Account drop-down. 
  6. Click on Run report

1.PNG

You can find more information about Mutlicurrency in QuickBooks Online in this link

 

Let us know if you have more questions about running reports in or anything else. We are here to help. 

Need to get in touch?

Contact us