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! 

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:

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:

• Customize reports in QuickBooks Desktop
• Create, access and modify memorized reports

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? 

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.

I am having the same issue with my credit card statement amounts. I enter the balance then split the balance amongst several different accounts in one entry. I pay the bill on the bank website first then pay it using "EFT" on Quickbooks. It splits each account amount -drives me nuts. There is no rhyme or reason for this. 

Hi there, Colerain.

When you make a bill payment, QuickBooks will automatically split the payment between various accounts, if you've previously assigned multiple accounts to that vendor. This means you're entering a payment to a specific vendor or bill, QuickBooks is simply following the split you originally set up.

If this automatic split is causing inconsistencies with your bank feed reconciliation, you might want to try entering the individual charges as they occur rather than splitting the main amount from the “EFT”.

Here's how you can do it:

1. Go to the Banking menu, then click on Bank Feeds and Bank Feeds Center.
2. From the Bank Accounts list, select the account you want to connect, then click Download Transactions.
3. Select the Transaction List tab to open its window.
4. Select each transaction and from the Action column dropdown, select the appropriate action.
5. Assign correct account per line. This will add or match transactions one-by-one to ensure accuracy.

In addition, you can refer to these articles to learn how to match your bank transactions in QBDT: Add and match Bank Feed transactions in QuickBooks Desktop.

Comment on the post if you still have concerns about running your report in QBDT. I'm always here to help.