Collections report showing paid invoices

Thanks for sharing the details of your concern and for performing some troubleshooting steps to fix the issue, @Matkodisplays.

Let me share with you additional steps to isolate and fix this matter. Aside from restarting your QuickBooks Desktop (QBDT), you can run the Verify Rebuild tool. This scans your company file for potential errors and resolves them right away. I'll show you how.

To Verify:

1. Hover to the Window menu and select Close All.
2. Go to the File menu.
3. Select Utilities.
4. Click Verify Data.

To Rebuild:

1. Go to the File menu.
2. Select Utilities.
3. Click Rebuild Data.

You can also check this link for more detailed steps: Verify and Rebuild Data in QuickBooks Desktop. 

If the issue persists, I recommend running the QuickBooks Tool Hub in fixing this issue. You can utilize this link for the complete details about the process: Repair your QuickBooks Desktop for Windows.

When everything is in place, you might want to check out these articles that can guide you on how to modify your reports and invoices: 

• Use and customize form templates 
• Customize reports in QuickBooks Desktop

You can always count on me whenever you need assistance with managing your reports and invoices. Please feel free to leave the details in your response and I'll take care of it for you. Have a lovely day ahead!

Thanks for the suggestions, bu none of them helped in any way.

Hello, Matkodisplays.

I'd like to take over and help you remove those paid invoices from the Collections Report. 

It looks like the payment links between those invoices and their payments are broken. There are two solutions to fix this, and I'll go over each one and lay down the details. 

I see that my colleague had suggested you to run the Quick Fix my Program utility from the Tool Hub.

Aside from this, there's also the Quick Fix my File utility, which helps resolve any file and data-related issues within the company file. 

If you haven't done it yet, open the Tool Hub again and click the Company File Issues tab. Select Quick Fix my File, then follow the prompts to run the data repair. 

If you're still getting the same issue, you'll want to manually fix this by deleting and recreating the invoice and their corresponding payments. This will refresh and "re-sync" the links between the transactions.

Before doing this, you'll want to create a copy of the current company file (creating a backup and restoring it or creating a new one from the existing file). 

To delete and recreate the transactions:

1. Open the company file copy and pull up the Collections Report again. 
2. Pull up the paid invoices, then take note of the details. 
3. Click the Transaction tab on the right panel, and open the Payment transaction link. 
4. Click the Delete button, then hit OK.
5. Go back to the invoice, then click the Delete button. 
6. Create a new invoice with the same details. 

You can also use the Create a Copy button on the invoice screen, then delete the original invoice. After creating a copy, create a payment for it (with the same original details) then check your Collections report. 

When the report no longer shows the paid invoices, do the same steps on the original copy file (make sure to create a backup first to prevent data loss or overwrites).

If it's time for your regular reconciliation process, this article article will help you with the steps and details: Reconcile an account in QuickBooks Desktop.

Should you have any other concerns regarding your reports or customer transactions, please let me know and I'll assist you. I'll also cover other areas in QuickBooks that you might need help with. I'll see you again soon.