Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
C
CHRfreeIST
November 28, 2021
Question

Understanding Classes and Reporting

  • November 28, 2021
  • 1 reply
  • 7 views

Hello All, I hope everyone had a great Thanksgiving. I am racking my brain trying to find a solution for my problem so I'm hoping someone(s) can help! I am currently using desktop pro to manage my rental property business. I have classes activated already. I am trying to use the class feature and the customer:job feature to achieve 3 separate actions simultaneously, but I am having no luck. If I can get some help/ideas/strategies on how to achieve the following or explanation on using these features correctly, that'd be awesome:

 

Ultimately, I want to be able to run a report or reports that show me all of the activity involved with an event, under the property and the department if possible. Ex: For the Purchase of 123 Main St (the event) for $75,000, Closing costs for $5,000, Down Payment for $5,000. Total "Main St Purchase" event = $85,000. I have been putting the $85,000 costs under "123 Main St -- Main St Purchase" class tag (the event), and on the flip side, I've been putting the $85,000 loan amount under "Accounting/Finance Dept" class tag (the department). It has taken a bit of work and some thinking ahead, along with constant report checking to ensure the debits and credits end up where I want them, but the problem I'm having is that the entries are not consistent. For instance, the Main St Purchase account will have debits and credits that don't follow the same guidelines as other accounts with debits and credits - in other words, the rules for determining debits and credits can change within an account, and from account to account, items that are debiting one account, are crediting another so the rules for applying the transaction can vary. I assume because I am trying to work around QB in a way it wasn't designed but I' don't know. Again, below are the 3 simultaneous activities I am trying to accomplish:

 

1) Track my 4 units as separate departments

EX: 123 Main St - Unit 110, Unit 120, Unit 130, Unit 140

 

2) Track the LLC's operations departments as as separate departments:

EX: Acct/Finance Dept, HR Dept., Building/Maintenance Dept. etc.

 

3) Track specific projects/events under either the property or a department

EX: 123 main st. purchase, Unit 120 2020 renovation, 2020 scouting trip, etc.

 

1 reply

M
mv32
Level 8
November 28, 2021

Happy Thanksgiving to you and your family, @CHRfreeIST.

 

You're in the right place to share your concern about running a report that would show relevant records from a class. You can run a QuickReport from your class list to view the units and departments activities involved with an event.

 

Please take note that the default filter is for All Income/Expense accounts. If your records are associated with Balance Sheet accounts, they won't show up. You'll want to remove the Account filter, and then you'll see all the related transactions to a class.

 

To view the non-posting transactions like purchase orders and estimates, make sure to toggle the Posting Status filter to Either.

 

Here's how to run a Class QuickReport:

  1. Go to the Lists menu and then select Class List.
  2. Click the Reports button, then choose QuickReport for a specific class.
  3. Select the Customize Report button.
  4. Go to Filters, then go to Current Filter Choices frame.
  5. Click the Account filter and then hit the Remove Selected Filter button.
  6. Select the Class filter, click Multiple classes.
  7. Check the classes that you want to include, hit OK.
  8. In the Search filters field, type posting, next tick Either.
  9. Select the Display tab to adjust the Dates and then add the columns Debit and Credit by checking it.
  10. Click OK.
     

You'll now have a closer look at your class report.

 

Additionally, I've held these articles that'll help you know more about running and managing reports in QuickBooks:

 

 

You can always come by and post a comment if you have other concerns with running class or any specified reports. I'm willing to help you now and then. Take care and happy Thanksgiving!

J
j_bonach
January 20, 2022

Is there a way to get the name of the class to show up on the Report itself so you know which class you are viewing?

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement