cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
Deadwood Al
Level 6

Class P&L mixup

*** IMPORTANT***

We just implemented class tracking in our Enterprise Gold. When I first ran the P&L report for the board, there were 3 separate entries that were coded for a different class that appeared in the report I was running. I called up the 3 invoices for those appearing incorrectly: there was nothing wrong with those invoices.I deleted  the class entry and replaced it with something else, then deleted the something else code and re-entered the code that was originally in the invoice, but still the invoices appeared in the wrong P&L by class!!!  Why???? Is there something special that makes a class assignment not work?

3 Comments 3
KiazzymaeC
QuickBooks Team

Class P&L mixup

Thank you for bringing this to our attention, @Deadwood Al. I get how challenging it can be when things don't go as planned, especially when running a Profit and Loss (P&L) report by Class that doesn't generate the invoices made. Let's work together to narrow down the root cause of the issue you've been experiencing.

 

When you open the invoices, do you see a Class in the header, and Class in the column part? If so, QuickBooks will follow the Class specified in the column part of the invoice. This means that the classification specified in each individual line item (column part) will dictate how the transactions are categorized and how they appear in your reports.

 

Example: (Please take note of the amount).

 


Let's take a closer look of the invoices to ensure everything is set up correctly. 

 

To do so, here's how: 

 

  1. Sign in to your QuickBooks Desktop Company file.
  2. Go to the Reports menu. 
  3. Select Company & Financial, then choose Profit & Loss by Class.
  4. Click the amount of the Invoices you've made and review the Class assigned in the column section. 

       5. Once clicked, it will route you to the Transaction Detail by Account where you can then identify which class the invoice is assigned. 

 

        6. To make necessary changes, double-click the assigned Class.

        7. Edit the Invoice as required.  

        8. Once done, hit Save & Close or Save and New.

 

For a deeper understanding of how Class affects your invoices and reports, you can refer to this helpful article: Understand reports.

 

Additionally, consider memorizing your reports in QuickBooks Desktop, so you don't have to go back through the customization process.

 

If you still have questions regarding handling reports, do not hesitate to comment below. I'll reply to you as quickly as possible! 

Deadwood Al
Level 6

Class P&L mixup

Thank you for telling me about checking everything I already checked. That check did help me find one error, but the others all appeared correctly done. I verified that the class in the header and in the detail lines matched. I even deleted the class, saved, changed the class to something else, saved, then changed back to what it should have been, and in one case it fixed the issue, in the other it didn't. 

 

It appears to me that if there is one error in the class assignment, it will randomly generate additional errors that seemingly have no reason to appear as they do. One of the "undocumented features" that pop up every so often in QB.

 

But thanks for following the script you are given by your overlords at QuickBooks that make most of the responses sound condescending and display the assumption that most of us poor users are all bumbling idiots.

 

JaneDave_I
QuickBooks Team

Class P&L mixup

Corrupted files in a company’s database system can impact data integrity and lessen operational efficiency in every transaction, Deadwood AI. 

 

Allow me to discuss this further in detail below.

 

Corruption can occur due to various reasons, including system crashes, hardware failures, software bugs, or improper system shutdowns. Thus, it also results in multiple errors when trying to run a report with your Profit and Loss in QuickBooks Desktop (QBDT).

 

To resolve this issue, we need to perform some basic troubleshooting steps which include verifying your company file to see if it has been corrupted or not. This process will detect whether you have a corrupted data system that's causing the error you're experiencing.

 

You can follow the steps below:

 

  1. Go to Window, then select Close All.
  2. Select File, then click Utilities.
  3. Choose Verify Data, then check if you see these three options:
    1. QuickBooks detected no problems with your data - no further actions are needed since your files aren't corrupted. 
    2. An error message - you can always search for it on our QuickBooks Desktop support site to learn how to troubleshoot the error. 
    3. Your data has lost integrity - Data damage was found in the file. Rebuild your data to fix it.

 

Once you're done with the troubleshooting steps that were recommended above, we can now move to the next step, which is rebuilding your company file data. Rebuilding the file is essential to make sure that we're able to solve the functional glitches and improve data performance when trying to run P&L reports once again.

 

Here's how:

 

  1. Go to File, Utilities, and then select Rebuild Data.
  2. QuickBooks will require a backup file to be created before it rebuilds your company file. Select OK.
  3. Choose where you want to save your backup file, then click OK. Remember not to replace another backup file with another. Instead, enter a new name in the File name, then select Save.
  4. Once done, click OK when you get the message Rebuild has completed.
  5. Go to File, select Utilities, then select Verify Data again to make sure that there's no additional damage that occurs.
  6. If the verification finds more damage, that's when you'll need to fix it manually. You can search for the error(s) in the qbwin.log on the QuickBooks Desktop support site to learn how to handle them.
  7. If your error can't be found, you can restore a recent backup. Go to File then select Open or Restore Company.

 

Once you're finished, you have to remember that you shouldn't replace your existing company file. Instead, you just need to enter information into your company file again since the backup was created.

 

Moreover, you can read this article to have a detailed information with the troubleshooting steps that we've perform in resolving your company files in QBDT: Verify and Rebuild Data in QuickBooks Desktop.

 

Furthermore, you can also refer to this article if you're trying to manage and memorize reports in QBDT: Create, access and modify memorized reports.

 

We're here to ensure your QuickBooks experience is smooth and error-free. Please don't hesitate to use these troubleshooting steps when needed or revisit this thread by clicking the Reply button. We're always here to help.

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Need to get in touch?

Contact us