Deposits not showing in Balance Sheet Report by Class

PTJ · ‎April 16, 2019

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!

KhimG · ‎April 16, 2019

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:

Go to Reports from the left menu.
Enter Profit and Loss in the Search field.
Select Report period.
On the Display columns by drop-down, choose Classes.
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

JanyRoseB · ‎April 16, 2019

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 · ‎April 16, 2019

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 · ‎April 16, 2019

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!

KhimG · ‎April 16, 2019

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:

Go to Reports from the left menu.
Enter Profit and Loss in the Search field.
Select Report period.
On the Display columns by drop-down, choose Classes.
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!

PTJ · ‎April 16, 2019

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!

KhimG · ‎April 16, 2019

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 · ‎April 16, 2019

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!

KhimG · ‎April 16, 2019

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!

Malika24 · ‎September 08, 2019

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.

Anonymous · ‎September 08, 2019

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:

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

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.

cmkal · ‎March 31, 2023

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

KS2511 · ‎April 11, 2023

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?

Kevin_C · ‎April 11, 2023

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:

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

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

Go to the File menu.
Choose Utilities, then select Rebuild Data.
Click OK if you receive a prompt to back up your company file.
Click OK when you get the message, Rebuild has completed and proceeds to the next step.
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!

McBeng

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.

jeanbiverly_

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.

Close QuickBooks.
Download the latest version (1.6.0.3) of QB Tool Hub.
Save the file in an easily accessible location, such as your Downloads folder or Windows desktop.
Open the downloaded file (QuickBooksToolHub.exe).
Follow the on-screen instructions to install and agree to the terms and conditions.
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.
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.

McBeng

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.

Irene R

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:

Open your QBDT account.
At the top of your account, select Help.
Choose QuickBooks Desktop Help/Contact Us.
Click on Contact Us.
Please give a brief explanation of your concern, then press Continue.
Log into your Intuit account. Select Continue, then Continue with my account.
An email with a single-use code will be sent to you. Type in your code and click Continue.
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.

Topics

Training

Community

Resources

Deposits not showing in Balance Sheet Report by Class