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

Invoice line item splits on P&L detail report

I have some invoice line items that are a simple, one line, entry on the invoice that are splitting into 3 or 4 random amounts on the P&L detail report. Can anyone tell me why and how to fix it? Some line items do not split, some split into 3 -4 random amounts to make up the total line item. I can find no rhyme or reason to how or which ones split. 

 

Thanks

Solved
Best answer July 02, 2022

Best Answers
Rainflurry
Level 12

Invoice line item splits on P&L detail report

@kpierson67 

 

Yes, it is because you are entering a credit line item on the invoice.  The proper way to record a customer prepayment is to record the prepayment by going to Customer > Receive Payments.  After entering the info (customer, amount, date, etc), make sure the "Leave the credit to be used later" radio button is checked in the lower-left land corner.  When you create the invoice later, click 'Apply credits' at the top of the invoice screen to apply the credit.

 

If you aren't actually receiving prepayments (your posted screenshot has the same date for the prepayment and the invoice, which is odd) use a sales receipt instead.  Sales receipts are designed to be used when payment is received at the same time as the sale occurs.

View solution in original post

6 Comments 6
Candice C
QuickBooks Team

Invoice line item splits on P&L detail report

Hey there, @kpierson67

 

Congrats on making your first post here in the Community. I hope your day is going well so far. 

 

To clarify, can you provide me with a screenshot of how the split look to ensure we're on the same page. 

 

This will help me determine the root of the problem. I'll be waiting for your response! 

kpierson67
Level 2

Invoice line item splits on P&L detail report

All of these that are duplicates are on my invoice as one line item. 

 

Capture.PNG

MadelynC
Moderator

Invoice line item splits on P&L detail report

I’m here to share insights on why invoices are split into random amounts on the Profit and Loss Detail report, @kpierson67.


There are several reasons why invoices are split into random amounts on the Profit and Loss Detail report. One of the following is partial payments or advance payments and inventory assembly.


I’ve seen advance payments on your screenshot. You can review the affected transactions to verify. Also, check the items on your invoices, then compare them to your Item list. Here’s how:

 

  1. Select Lists at the top.
  2. Go to Item List.
  3. Find the items and select to open.


I’ve added these resources to learn how to draw information clearly and save the same report settings for future use:

 


If you need more help in managing your transactions and reports, don’t hesitate to add a comment. I’ll be here. Take care always!

kpierson67
Level 2

Invoice line item splits on P&L detail report

Thanks. Can you give me some more info on why this happens and how to fix it. I have already checked my items list and see no settings that would affect this. I need to understand more about what causes it to be split up and how to make it not do that. Is it doing this because there is a credit line item on the invoice? (You mentioned advance payment. I use a simple credit line type entry) If so, how should it be entered on the invoice so that it does not split in the P&L? 

Rainflurry
Level 12

Invoice line item splits on P&L detail report

@kpierson67 

 

Yes, it is because you are entering a credit line item on the invoice.  The proper way to record a customer prepayment is to record the prepayment by going to Customer > Receive Payments.  After entering the info (customer, amount, date, etc), make sure the "Leave the credit to be used later" radio button is checked in the lower-left land corner.  When you create the invoice later, click 'Apply credits' at the top of the invoice screen to apply the credit.

 

If you aren't actually receiving prepayments (your posted screenshot has the same date for the prepayment and the invoice, which is odd) use a sales receipt instead.  Sales receipts are designed to be used when payment is received at the same time as the sale occurs.

debbieagu
Level 1

Invoice line item splits on P&L detail report

Hi, I'm having a similar issue but it's when I enter certain bills. I enter them as 1 line item on the bill, but it's splitting into random payments on the P&L detail report.

Need to get in touch?

Contact us