Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowI 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! Go to Solution.
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.
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!
All of these that are duplicates are on my invoice as one line item.
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:
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!
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?
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.
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.