cancel
Showing results for 
Search instead for 
Did you mean: 
skibumps90
Level 3

Sale receipt class not always showing in P&L report.

For rental payments, I enter a sale receipt and include a class.  Then I make a deposit. 10 out of 12 rents do show properly on my P&L under the class.    But my P&L shows as unclassified for 2 transactions.  I checked and I have the class correctly in the sales receipt.  I tried to change the class to a different one as a test but QB wouldn't let me save the transaction.  It said that I hadn't selected a transaction but I could see that I did.  Thoughts?  I'm using QB Desktop.

 

Thanks.

Solved
Best answer March 04, 2020

Best Answers
JasroV
QuickBooks Team

Sale receipt class not always showing in P&L report.

Thanks for sharing the details with us, @skibumps90.

 

Let's delete and recreate the two (2) sales receipts to isolate this. Ensure to copy the details in the sales receipt before deleting to avoid errors. Here's how.

 

Before doing so, I recommend consulting with your accountant for guidance. This way, we'll ensure the accuracy of your accounts after making these changes. 

 

In your QuickBooks Desktop (QBDT):

  1. Go to the Reports menu.
  2. Select Company & Financial, then Profit & Loss by Class.
  3. Click the amount under the Unclassified column to see the transaction not classified.
  4. Double click the transaction.
  5. Click Delete from the toolbar. 2.PNG

Once done, recreate the sales receipt and run the report again. Also, ensure that all line items in the sales receipt have classes. If one (1) line item doesn't have a class, the transaction will be shown as unclassified in the report. 2.PNG

 

To learn more about running reports in your QBTD software, you can read this great article: Understand reports.

 

You can also check this article and learn how to run a report that shows the specific data you need: Customize reports in QuickBooks Desktop

 

Do get back to us if you have other concerns and questions. You can always count on us. Take care!

View solution in original post

Michael K
Moderator

Sale receipt class not always showing in P&L report.

Thanks for getting back with us, @skibumps90.

 

After deleting and re-creating the Sales Receipts as mentioned by my colleagues, you can do a mini-reconciliation so that you won't have to redo the whole reconcile. This "mini reconciliation" method uses an "off-cycle" reconciliation date to make a correction. I've included steps below that'll have you doing this like a pro in no time.

 

  1. Go to the Banking menu, then Reconcile.
  2. Choose the bank account with the transactions you need to reconcile.
  3. In the Date of Statement field, enter a date for an "off-cycle reconciliation." This date can be any date between your last reconciliation and the next scheduled one.
  4. In the Ending Balance field, enter the balance of your last successful reconciliation. Then click Continue.
  5. In the Reconcile window, check off the transactions you are fixing and rereconciling.
  6. Make sure the Difference field shows $0.00.
  7. When everything looks good, hit Reconcile Now.

 

If you'd like to learn more about reconciliations in QuickBooks Desktop, check out: Reconcile an account in QuickBooks Desktop

 

Feel free to shoot me a reply if you have any other questions. I'll be happy to help.

View solution in original post

10 Comments 10
JasroV
QuickBooks Team

Sale receipt class not always showing in P&L report.

Thanks for sharing the details with us, @skibumps90.

 

Let's delete and recreate the two (2) sales receipts to isolate this. Ensure to copy the details in the sales receipt before deleting to avoid errors. Here's how.

 

Before doing so, I recommend consulting with your accountant for guidance. This way, we'll ensure the accuracy of your accounts after making these changes. 

 

In your QuickBooks Desktop (QBDT):

  1. Go to the Reports menu.
  2. Select Company & Financial, then Profit & Loss by Class.
  3. Click the amount under the Unclassified column to see the transaction not classified.
  4. Double click the transaction.
  5. Click Delete from the toolbar. 2.PNG

Once done, recreate the sales receipt and run the report again. Also, ensure that all line items in the sales receipt have classes. If one (1) line item doesn't have a class, the transaction will be shown as unclassified in the report. 2.PNG

 

To learn more about running reports in your QBTD software, you can read this great article: Understand reports.

 

You can also check this article and learn how to run a report that shows the specific data you need: Customize reports in QuickBooks Desktop

 

Do get back to us if you have other concerns and questions. You can always count on us. Take care!

skibumps90
Level 3

Sale receipt class not always showing in P&L report.

Thanks for the reply.  I just did a backup but have a quick question.  I have already reconciled these transactions that are about 6 months old.  If I get them corrected by entering new ones, will I be able to update the reconciliations?  Trying to think ahead.

Michael K
Moderator

Sale receipt class not always showing in P&L report.

Thanks for getting back with us, @skibumps90.

 

After deleting and re-creating the Sales Receipts as mentioned by my colleagues, you can do a mini-reconciliation so that you won't have to redo the whole reconcile. This "mini reconciliation" method uses an "off-cycle" reconciliation date to make a correction. I've included steps below that'll have you doing this like a pro in no time.

 

  1. Go to the Banking menu, then Reconcile.
  2. Choose the bank account with the transactions you need to reconcile.
  3. In the Date of Statement field, enter a date for an "off-cycle reconciliation." This date can be any date between your last reconciliation and the next scheduled one.
  4. In the Ending Balance field, enter the balance of your last successful reconciliation. Then click Continue.
  5. In the Reconcile window, check off the transactions you are fixing and rereconciling.
  6. Make sure the Difference field shows $0.00.
  7. When everything looks good, hit Reconcile Now.

 

If you'd like to learn more about reconciliations in QuickBooks Desktop, check out: Reconcile an account in QuickBooks Desktop

 

Feel free to shoot me a reply if you have any other questions. I'll be happy to help.

skibumps90
Level 3

Sale receipt class not always showing in P&L report.

So that worked!  I had to do it a bit differently, but my version of QB should be upgraded.  

I had to first delete the deposit in my check registry, then I could delete it in the report after that.  I recreated the Sales Receipt and even made sure the sales number was the same as the original.  Then I Made Deposits and everything fell into place.  

Not sure what was causing the error.  My version of QB doesn't have a line item for Class on the Sales Receipt.  It only shows Class in the header right after the Customer: Job field.  Makes sense to be in both places and should upgrade.

 

Thanks!

skibumps90
Level 3

Sale receipt class not always showing in P&L report.

Thanks for the tip on reconciling.  I started to do it and understand your steps.  I did get lost on how to find my Ending Balance from my last reconcile so I stopped.  I think I can just add the amounts from what I deleted from my account so I get to zero.  Going to tackle that tomorrow with clearer eyes.

skibumps90
Level 3

Sale receipt class not always showing in P&L report.

Looks I got everything fixed and reconciled.  Thanks!

 

I did notice I had two more recent transactions that showed as "unclassified" but they actually had a classification.  I corrected both using the same process but what could be causing this??   The only common thread I saw was that both where the first deposit in a multi item (sales receipts) deposit.  Has that happen before - to your knowledge?

JonpriL
Moderator

Sale receipt class not always showing in P&L report.

Glad to hear you're able to fix it, @skibumps90!

 

Ideally, a certain transaction in your report contains multiple line items and you missed to select a class on one of those items, it'll automatically be posted as unclassified. You're on the right track by reviewing them, one at a time.

 

I'm adding these reports and accounting articles for tips and ideas in managing your account and reports.

 

Let me know if you have other questions. I'll be happy to help you out!

skibumps90
Level 3

Sale receipt class not always showing in P&L report.

Thanks for the reply and I will review the tips link.   I only have the one spot on my sales receipts and I did confirm that I correctly added a class to the ones showing as unclassified.  I even tried changing the class to another one and I wasn't able to save because QB stated that I didn't assign a class.  If it comes up again I will include a pic of the error and the class field.

 

Thanks!

Tin28
Level 1

Sale receipt class not always showing in P&L report.

Hi,

 

Would like to ask how to fixed this issue.

I need to see the class column for Sales Receipt transaction when generating Bank Register.

 

Please refer to attached photo.

 

Thanks

RCV
QuickBooks Team
QuickBooks Team

Sale receipt class not always showing in P&L report.

Thanks for checking in with us, Tin28

 

I appreciate you for providing us a screenshot of your concern. It seems like you are using QuickBooks Online (QBO). We can add the Class and Locations column in the Bank Register page to see the class column for the Sales Receipt transactions. Here's how:

  1. Go to Accounting on the left menu.
  2. Choose Chart of Accounts.
  3. Tick View register on the bank account name.
  4. Tap the Filter icon and choose Sales Receipt on the Transaction Type field.
  5. Click the Gear icon.
  6. Under Columns, choose Class and Location.

Visit our Banking page for more insights about managing your bank feeds and reconciling accounts.

 

Feel free to update us on the result of this troubleshooting in the comment below. I'd like to ensure this is resolved for you. You have a good one.

 

Need to get in touch?

Contact us