Custom Invoice Report Needed

I'll help you find the report you need, @tcutrona.

Let's pull up and customize the Transaction List by Date report so you can look at all your fully paid invoices in QuickBooks Online (QBO) and manage your sales and income transactions accordingly.

In QBO, financial and transaction reports tell you everything about the different aspects of your business. To get the data you need, follow the steps below:

1. Go to Business overview and select Reports or go to the Reports menu.
2. Use the Find report by name search bar and search the Transaction List by Date report. Then, select it to open its data.
3. Click the Customize button.
4. Set the date in the Report period section.
5. Go to the Filter section.
6. Set the A/R Paid option to Paid and Transaction Type to Invoice.
7. Click the Run report button. 

If you wish to learn more about report features and how to run specific ones to get the info you need in QBO, please see this article: Run reports in QuickBooks Online.

Also, you can create and customize accounts receivable aging reports to give you an overview of your customers' outstanding balances, who are falling behind their payments, how much is still due, and how long they’re past due. You may want to check out this article as your reference to guide you on how you can run these reports in QBO: Run an accounts receivable aging report.

Please feel free to leave a comment below if you have other concerns about pulling up reports and managing transactions in QBO. I'm always ready to help. Take care, @tcutrona.

That didn't produce the report I'm needing. It shows all payments done in a period of time, not just the payments that closed invoices 100%.

I appreciate you for getting back to the thread, @tcutrona. I'll chime in and share information about what report you can pull to show paid invoices in QuickBooks Online (QBO).

 If you want a clear picture of your sales in QuickBooks, including paid invoices, run the Sales by Customer Detail Report with the Cash accounting method selected rather than the Accrual accounting method. This allows you to view the amount paid on your invoices.

Here's how:

1. Access your QuickBooks Online company.
2. Go to the Reports tab.
3. In the Search bar, type Sales by Customer Details and then click on it.
4. Have the Accounting method set to Cash.
5. Click the Customize button, and then go to the Filter section.
6. Modify the Transaction Type set to Invoices. 
7. Make the A/R Paid set to Paid.
8. Once done, Run the report.

In addition, if you want to save the current settings of your customized report and have them carry over the next time you run the same report in QuickBooks, you can utilize this article: Memorize reports in QuickBooks Online.

I’m just a post away if you need anything else. Have a great day!

I appreciate the advice, but still does not produce a report that only shows the final payment to an invoice in a given time.  It shows all the invoices that were CREATED in that time frame, and also happen to be paid in full (alot were paid in full in a different time period).

Example:

I am doing the report as you have instructed for the time period 10/01/2022-12/31/2022.  All the invoices that are paid in full, and were created in that time frame populate.  Some of those invoices, in reality got paid in full after 1/1/2023.

I don't care at all when an invoice was created, I just want to know when it was paid in full between 10/01/2022-12/31/2022.  

Hopefully someone can help.

Thank you,

Tony