Reports by class

Good day to you, @HBrooklyn.

The Transaction Detail reports normally show all affected accounts of the transaction. It’ll show the Credit and Debit account of that transaction. Thus, it shows two amounts for one transaction.

You can check out this article to learn more about reports in QuickBooks Desktop (QBDT): Understand reports.

On the other hand, trying closing and opening the reports again to isolate the issue on why it shows fractions of payment in the “amount paid” column. If the same things happen, I recommend running the Verify Rebuild tool to fix the uncommon behavior. Let me show you how to do it:

To Verify: 

1. Go to the File menu.
2. Select Utilities 
3. Click Verify Data.

To Rebuild:

1. Go to the File menu.
2. Select Utilities.
3. Click Rebuild Data.

You can also read through this article for more details about the process: Verify and Rebuild Data in QuickBooks Desktop.

Additionally, I have here an article that you can use for guidance in generating reports to show the information that matters to your business: Customize reports in QuickBooks Desktop.

You might also want to memorize the report to save its current settings. This way, you won’t have to customize it every time.

Let me know if you have other questions about reports in your QBDT software. I’d be more than happy to help you out again. Take care and always stay safe! 

Thank you.

We have done the verify & rebuild, it did not correct it. 

On the transaction report, it does not duplicate each entry, only the ones that were split between more than one class. If the entry was split between 3 classes, it will show it 3 times. I do not believe that this is normal. There has to be a way to prevent it from showing duplicate entries.

I can see the benefit of pulling up the accurate transaction report by class in QuickBooks Desktop (QBDT) Enterprise, @HBrooklyn. That's why I'm here to guide you on how to isolate this matter.

You can pull up a sample company file and verify the system's behavior. You need to enter a transaction and split an entry between three classes. Then, pull up a transaction report and filter it by class. Here's how:

1. Go to the File menu.
2. Select Close Company.
3. In the No Company Open window, click the Open a sample file drop-down and choose a sample file you want.
4. Follow the on-screen instructions to complete the process.

I've attached a screenshot below that shows the third step.

When the sample file shows a different outcome, that means your company data is damaged. However, if it shows the same, then its the system's behavior in generating the transaction report by class.

In case the issue persists, you can repair your company file using QuickBooks File Doctor. This fixes any data issues and helps you get the correct report details. For the step-by-step guide, I'd recommend checking out this article: Fix company file and network issues with QuickBooks File Doctor.

Moreover, classes and subclasses are additional means to categorize data in QBDT. To learn more about filtering ad sorting your transaction report by class, kindly check out this article: Filter, sort or total reports by Class. It includes topics about reports showing only unclassified transactions and P&L showing subclasses only to name a few.

Please let me know if you have other concerns. I'm just around to help. Take care always.

This is normal behavior. Nothing to fix:

If you split an amount by class, such as on a paycheck, then multiple accounting detail lines are created and saved.