Statement payments

Hey there, @Janet32. 

Thanks for stopping by the QuickBooks Community for support. 

It sounds like you may have some data integrity issues in the company file, causing the 5th payment to not show in full and the 6th payment to not show on the P&L. 

Using our Rebuild and Verify utilities, let's try some basic troubleshooting steps to scan the company file for any possible data integrity issues. 

To Rebuild: 

1. Select File, go to Utilities, then choose Rebuild data.
2. If you see the message Rebuild has completed, continue to Verify the data. 
   • 

To verify: 

1. Select Window, then Close All to close all open windows.
2. Tap on File, then Utilities, then Verify Data.
3. The verification has been completed if you see the message, QuickBooks detected no problems with your data.

Now let's go back to the company file and recheck the payments. Please let me know if the payments are showing correctly.  

I'm right here if you have any additional questions or concerns. Have a good one! 

Sorry, Tori B.  Rebuild and Verify did not fix it. 

Hi there, Janet32.

I appreciate you for coming back to the thread and confirming the status of your concern after the troubleshooting details shared above. Let's perform some steps to review all the data being entered so you can verify the cause of Profit and Loss shown incorrectly.

It's possible that the 5th payment included a credit that was applied to the invoice along with the payment, which is why it only shows a portion of the Profit and Loss report on a Cash basis. I recommend going to the Customers Center to locate the payment and check the entries associated with it.

Here's how:

1. Click the Customers menu at the top. Then, choose Customer Center.
2. Find the Payment and double-click it to expand the page.
3. Go to the Amounts for selected invoices section. Then, you'll be able to see the details of the transactions including the credits applied.
4. Click Save and Close.

On the other hand, it might be that the 6th payment is posted to another bank account and that is the reason why it didn't show correctly on P&L at all. To confirm this, you'll have to go to the Bank register and locate the payment so you can see what bank account is connected with the entry. Please follow the steps below.

1. Click the Accountant menu at the top.
2. Choose Chart of Accounts. Then, click each appropriate bank account to see all the transactions.
3. Locate the payment.

Once done, you can now verify the cause of the unusual data that appears on the P and L statement or report. However, if the issue continues to occur, I suggest contacting our QuickBooks Desktop support team. They have the tools to review your account and conduct screen sharing to help further investigate why the transaction on the P and L report appears inaccurately.

Lastly, you may refer to this article to see steps on how you customize the data and even personalize the font and style of the report to view the particular data that needs in your business: Customize reports in QuickBooks Desktop.

Let me know if you need further assistance with this or other concerns related to the Profit and Loss report. I'm always around to provide answers and clarifications to your questions, Janet32. Have a great day ahead and take care!

@Janet32 

This seems obvious but have you confirmed the items on invoices 5 & 6 are mapped to income accounts?  Assuming the payments were recorded properly and the invoices are showing as paid, there isn't much else it could be.  Confirm that the payment received date on invoice #6 is within the date range of the P&L.