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. 

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!

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!

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!

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!

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!

this is a HUGE miss by QBO. You have to do JE for every deposit or expense to be able to class is correctly? That's insane

In my desktop QB, the deposits always showed on the Balance Sheet by Class in the correct class, until last fall. Something changed. I doublechecked to see that each payment was classed in the "make deposits" window, and they show up as unclassified. The older deposits, made in the identical fashion, still show in the proper class. What happened?

I appreciate you for double-checking the deposit transaction window in QuickBooks Desktop (QBDT), KS2511. Let me provide some troubleshooting steps to get around this issue,

If you haven't tried running the Verify and Rebuild data tools to get this resolved, we can perform this to verify and resolve the most commonly known data issues within your company file. But beforehand, please make sure that your QBDT is up-to-date. This way, you'll always have the latest features and fixes.

Then, follow these steps to proceed to verify data:

1. Navigate to the File menu.
2. Choose Utilities, then select Verify Data.
3. Click OK when you see the message, QuickBooks detected no problem with your data.
4. If Verify finds an issue with your data, you'll be prompted to Rebuild Now or View Errors.
5. Click Close or View Errors and take note of the specific error message.

After that, here's how you can rebuild the data:

1. Go to the File menu.
2. Choose Utilities, then select Rebuild Data.
3. Click OK if you receive a prompt to back up your company file.
4. Click OK when you get the message, Rebuild has completed and proceeds to the next step.
5. Run Rebuild Data again to make sure there are no errors.

However, if performing these steps doesn't fix the issue, you can also try the File Doctor to fix company file issues in QBDT. For a step-by-step process, feel free to utilize this article: Fix company file and network issues with QuickBooks File Doctor.

I'm also adding this article for additional troubleshooting steps that will help you fix this issue: Fix data damage on your QuickBooks Desktop company file.

Keep me posted if you need a hand with other QuickBooks-related concerns. I'm always here to ensure your success. Have a great day!

I'm finding the only way to have my subacct bank deposits show up on the Balance Sheet filtered by Class is to make JE. This can't be the only way. I did the verify data and nothing was wrong. I'm at a loss. 

Hi, @McBeng. We appreciate you for performing troubleshooting steps. I'm here to further help you display your subaccount bank deposits on the Balance Sheet by Class report.

First, ensure that the report filters such as Date and Accounting Method are set correctly.

If the filters are set correctly, you can resolve the issue using QuickBooks Desktop (QBDT) Tool Hub. For the best experience, we recommend using it on Windows 10, 64-bit. I can walk you through the process.

1. Close QuickBooks.
2. Download the latest version (1.6.0.3) of QB Tool Hub. 
3. Save the file in an easily accessible location, such as your Downloads folder or Windows desktop.
4. Open the downloaded file (QuickBooksToolHub.exe).
5. Follow the on-screen instructions to install and agree to the terms and conditions.
6. Once installed, double-click the icon on your Windows desktop to open the tool hub. If you can't find the icon, search in Windows for QB Tool Hub and select the program.
7. Use tools such as Company File Issues or Advanced Tools to fix common data issues or QB errors. 

For a more detailed guide, you can visit this article: Fix common problems and errors with the QuickBooks Desktop Tool Hub.

In case you want to personalize your reports, you can check out this article for more guidance: Customize reports in QuickBooks Desktop.

If you have any further concerns about displaying your subaccount bank deposit on the Balance Sheet by Class report, feel free to reply. We're here to help in any way we can. 

I'm confused how this would help. I did what you said but nothing changed. I've looked through the tabs in the Tool Hub but nothing points in the right direction. I'm still forced to do J/E for the acct to show up on the Balance Sheet when filtered by class. It shows up when I don't filter. Every transaction has been coded with the correct class. 

Hi there, McBeng.

I appreciate your returning to the thread regarding your sub-account bank deposits not showing up on your balance sheet filtered by class in your QuickBooks Desktop (QBDT).

Let's start by reviewing the deposit transaction and checking if a class has been added to it. If not, attach a class to your deposit transaction and then generate a Balance Sheet report to ensure that your deposits are included.

However, if you've already added a class to your deposits, I recommend contacting our QBDT live support team. They discuss and guide you in finding an adequate solution regarding this matter. 

To reach our support team, you can follow the steps below:

1. Open your QBDT account.
2. At the top of your account, select Help. 
3. Choose QuickBooks Desktop Help/Contact Us.
4. Click on Contact Us.
5. Please give a brief explanation of your concern, then press Continue.
6. Log into your Intuit account. Select Continue, then Continue with my account.
7. An email with a single-use code will be sent to you. Type in your code and click Continue.
8. Select whether you want to Chat with us or Have us call you.

In addition, learn how to personalize reports in your QBDT by scanning through this thread: Customize reports in QuickBooks Desktop. 

Let me know if you have additional inquiries concerning your deposit transactions in QBDT. Just leave a comment below. I'll be sure to address them in no time.