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

Correct Cash, AR, and AP Balance by Class

Our company has two locations. We use the class function in QB to distinguish locations with every invoice and bill which hits our income and expense accounts, and gives us an accurate P&L by class so we can look at the performance of each location. I would like to do the same thing with the balance sheet, but am having issues related to cash, AR, and AP. I have found I can hit our AR or AP account with the class I want when I enter an invoice/bill, but I cannot reduce the balance with the class I want when recording payments we receive or make. Because of the inability to specify class when receiving or making payments, our balance sheet accounts by class are inaccurate for cash, AR, and AP. What are my options in QuickBooks Desktop to get accurate cash, AR, and AP balances by class? 

Solved
Best answer January 28, 2022

Best Answers
Tori B
QuickBooks Team

Correct Cash, AR, and AP Balance by Class

Hi there, @vytronaccounting.

 

Thanks for taking the time to follow along with the thread and sharing your concerns here in the QuickBooks Community. 

 

At this time, class can not be assigned to cash transactions in QuickBooks Desktop. I can see how beneficial this would be for you and your business, so I've gone ahead and sent this suggestion to our Product Development Team. This way, the feedback can be took into consideration for a future update. 

 

Please let me know if you have any questions or concerns. I'm always here to lend a hand. Take care! 

 

View solution in original post

9 Comments 9
Jovychris_A
Moderator

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!

vytronaccounting
Level 2

Correct Cash, AR, and AP Balance by Class

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.

MarsStephanieL
QuickBooks Team

Correct Cash, AR, and AP Balance by Class

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!

vytronaccounting
Level 2

Correct Cash, AR, and AP Balance by Class

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

Jen_D
Moderator

Correct Cash, AR, and AP Balance by Class

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.

vytronaccounting
Level 2

Correct Cash, AR, and AP Balance by Class

How do you assign classes to cash transactions?

Tori B
QuickBooks Team

Correct Cash, AR, and AP Balance by Class

Hi there, @vytronaccounting.

 

Thanks for taking the time to follow along with the thread and sharing your concerns here in the QuickBooks Community. 

 

At this time, class can not be assigned to cash transactions in QuickBooks Desktop. I can see how beneficial this would be for you and your business, so I've gone ahead and sent this suggestion to our Product Development Team. This way, the feedback can be took into consideration for a future update. 

 

Please let me know if you have any questions or concerns. I'm always here to lend a hand. Take care! 

 

MAPMG
Level 1

Correct Cash, AR, and AP Balance by Class

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

SarahannC
Moderator

Correct Cash, AR, and AP Balance by Class

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:

 

 

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.

 

 

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

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us