cancel
Showing results for 
Search instead for 
Did you mean: 
Matkodisplays
Level 1

Collections report showing paid invoices

My collections report has started showing paid invoices.  I have about 10 invoices showing up on my standard report and when I double click on about half of the invoices they already show "paid" with the date in the upper corner like they should.  I tried adding a new line to the invoice and saving it and the invoice says past due, if I delete that line and save it goes back to paid.  If I go to receive payments and click on a customer showing up in the report, that invoice does not show up on the list, which is correct.  It just seems to be an error with the collections report I tried to do an update but nothing was new to install.  I also shut quickbooks down and relaunched it

 

Quickbooks Enterprise 2021 R8_81

 

3 Comments 3
JasroV
QuickBooks Team

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: 

 

 

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!

Matkodisplays
Level 1

Collections report showing paid invoices

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

jamespaul
Moderator

Collections report showing paid invoices

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. 

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us