Correct Cash, AR, and AP Balance by Class

Hi @vytronaccounting.

I understand how you want to get accurate cash for AR and AP in a Balance Sheet by Class report. In the meantime, you can consider entering transactions in a specific way to ensure correctness. Besides, you can only use this advanced report if you want to see your balance sheet by fund, location, profit center, or other categories.

I'm adding this article as your reference to learn more about pulling up a report and seeing it differently like a specified one: Customize reports in QuickBooks Desktop. This includes the links that cover basic information about your financial data in QuickBooks Desktop.

Feel free to comment if you have additional questions or concerns about running your reports. I'm always around to help. Keep safe and more power to your business!

I use a 3rd party reporting application that takes care of all my financial reporting needs. I am more concerned with the ability to enter cash transactions (making and receiving payments) at the class level. Is there a way to designate the class you want to relate to a payment, on both the cash and the AR/AP side? So the JE's would look like this:

Receiving -

Cash  XXXX (Class A)

AR                   XXXX (Class A)

Payment - 

AP      XXXX (Class B)

Cash                 XXXX (Class B)

Right now, the JE's I am booking do not include the class designation.

Hello there, @vytronaccounting. It's a great idea to do class tracking on your transactions to track segments you want to keep a close eye on.

You can utilize class tracking when doing a Journal Entry or even creating an Invoice for a customer. 

The layout you've shown has the same setup as the Journal Entry form in QuickBooks Desktop. I have here a sample screenshot for your reference: 

To know more about managing classes, you can read through this article: Set up and use class tracking in QuickBooks Desktop.

On the other hand, I have here an article about running and customizing reports in QBDT that you can use in the future: Understand reports. 

Please let me know if you have any other questions about managing classes. I'll be right here to provide further assistance. Take care and have a good one!

To be clear, are you saying there is no way to track cash at the class level, without doing manual JE's?

Hello there, @vytronaccounting.

Just want to share some insights with you about the class reporting in QuickBooks. You don't really need to create journal entries to track cash entries.

The system allows you to enter cash transactions, and all you need to do is assign classes to them. Then, you can filter out the report by classes or transactions.

Refer to this link for the steps: Filter, sort or total reports by Class.

Please post here if you have other concerns with QuickBooks reporting. I'll be right here to help you out. All the best.

How do you assign classes to cash transactions?

Is class tracking available for the cash balances in QuickBooks online?

Hello there, MAPMG.

The class tracking feature will reflect the cash balances as long as we enter class when we create a transaction that affects the cash balance. It will also reflect on the reports.

Please be advised this feature is available in QuickBooks Online Plus and Advanced. And we can enable this feature from the settings. I'll show you how:

1. Go to the Gear icon.
2. Select Account and Settings.
3. In the Advanced tab, select Categories.
4. Tick the Track classes.
5. Click Save. Then, Done.

Then, we can create a class and assign the transaction to it. For further guidance and tips, we can read through these references:

• Create and manage classes in QuickBooks Online
• Track your transactions by class

If you want to modify a report personally for cash balances, we can visit the links below. They will tell us how we can customize and save the current modification.

• Customize reports in QuickBooks Online.
• Memorize reports in QuickBooks Online.

Comment below if you have other concerns about the class feature in QBO. Take care and have a good one.