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
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.
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!
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.
To delete and recreate the transactions:
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.